Spreadsheet: 886505d1736522795-report-making-blank-report-forms_athlete-supplements
Sheet: Black Cohosh Report

Date | Vendor | Qty | U/M | Cost Price | Amount |  | Year | January | February | March | April | May | June | July | August | September | October | November | December | TOTALS:
2020-02-06 00:00:00 | [NAME] |  | lb | 5.25 | 204.75 |  | 2020
2020-02-12 00:00:00 | [NAME] |  | lb | 5.5 | 5164.5 |  | 2021
2020-02-17 00:00:00 | [NAME] |  | lb | 5.50073 | 37746 |  | 2022
2020-03-02 00:00:00 | Montaric Brown |  | lb | 5.5 | 7760.5 |  | 2023
2020-03-16 00:00:00 | [NAME] |  | lb | 5.5 | 3294.5 |  | 2024
2020-04-06 00:00:00 | [NAME] |  | lb | 5.6 | 3063.2 |  | 2025
2020-04-21 00:00:00 | [NAME] |  | lb | 5.6 | 7033.6 |  | Total
2020-04-29 00:00:00 | [NAME] |  | lb | 5.75 | 983.25 |  | ALL VENDOR TOTALS:
2020-05-04 00:00:00 | [NAME] |  | lb | 5.79762 | 9740 |  | Total Average amount purchased per month | This shouldn’t change when a different vendor is selected. / Example: 10,000 lbs are purchased on average in January
2020-05-07 00:00:00 | [NAME] |  | lb | 5.5 | 4240.5 |  | Total Vendor Percent by month: | This shouldn’t change when a different vendor is selected. / Example: 13% is purchased in January.
2020-05-28 00:00:00 | [NAME] |  | lb | 5.65 | 62.15 |  | [NAME] by month/total: | The vendor percentage of the total per month. / Example: Vendor A accounts for 10% of all product bought in January. |  |  |  |  |  |  |  |  |  |  |  |  | <<<The vendor total percentage. / Example: Vendor A accounts for 22% if all prodyct bought
2020-05-28 00:00:00 | [NAME] |  | lb | 5.75 | 12230.25 |  | Vendor Average amount purchased per month | The average amount the vendor sells in each month. / Vendor A  sells an average of 1,000 lbs in the month of January. |  |  |  |  |  |  |  |  |  |  |  |  | <<<The vendor total average. / Example: Vendor A sells an average of 1,200 lbs a month
2020-06-02 00:00:00 | [NAME] |  | lb | 5.5 | 258.5 |  | Annual Average by Vendor/Year | The average amount purchased from the vendor yearly. Would ideally like to place this information in row V / Example: Vendor A sells an average of 11,000 lbs a year
2020-06-10 00:00:00 | [NAME] |  | lb | 5.5 | 4939 |  |  | All [NAME] should not count for 0 values or for future dates.
2020-06-15 00:00:00 | [NAME] |  | lb | 5.75 | 5606.25
2020-06-25 00:00:00 | [NAME] |  | lb | 5.75 | 21712
2020-07-13 00:00:00 | [NAME] |  | lb | 5.75 | 5422.25
2020-07-21 00:00:00 | [NAME] |  | lb | 5.5 | 4482.5
2020-07-21 00:00:00 | [NAME] |  | lb | 5.75 | 6020.25
2020-07-28 00:00:00 | [NAME] |  | lb | 5.13176 | 1139.25 |  | Spend ($/lb)
2020-07-29 00:00:00 | [NAME] |  | lb | 5.5 | 720.5 |  | Year | January | February | March | April | May | June | July | August | September | October | November | December | TOTALS:
2020-08-11 00:00:00 | [NAME] |  | lb | 5.75 | 5980 |  | 2020
2020-08-27 00:00:00 | [NAME] |  | lb | 5.75 | 6227.25 |  | 2021
2020-08-27 00:00:00 | [NAME] |  | lb | 6 | 9708 |  | 2022
2020-09-09 00:00:00 | [NAME] |  | lb | 5.75 | 23983.25 |  | 2023
2020-09-21 00:00:00 | [NAME] |  | lb | 5.75 | 701.5 |  | 2024
2020-10-01 00:00:00 | [NAME] |  | lb | 5.75 | 4945 |  | 2025
2020-10-01 00:00:00 | [NAME] |  | lb | 5.75 | 6520.5 |  | Total
2020-10-01 00:00:00 | [NAME] |  | lb | 6 | 11310 |  | TOTAL Spent ALL Vendors
2020-10-07 00:00:00 | [NAME] |  | lb | 5.75 | 19659.25 |  | Average Spent Per month/All vendors | The average total spent per month for ALL vendors / Example: In January an average of $100,000 is spent |  |  |  |  |  |  |  |  |  |  |  |  | <<<Total Average Per month for all vendors. / Example: Our average spend is $120,000 per month
2020-10-26 00:00:00 | Shedeur Sanders |  | lb | 5.5 | 907.5 |  | Average Spent Per month/per [NAME] all vendors | The average total spent per month per lb for ALL vendors / Example: In January the average price is 7.22 per lb |  |  |  |  |  |  |  |  |  |  |  |  | <<<Total Average Per month for all vendors. / Example: Our average spend is $8.72 per month per lb
2020-10-27 00:00:00 | [NAME] |  | lb | 6 | 22044 |  | Total Spent Per month per vendor | The average total spent per month per vendors / Example: Vendor A sells an Average of $10,000 in January |  |  |  |  |  |  |  |  |  |  |  |  | <<<Total Average Per month per vendors. / Example: Our average spend is $11,000 per month per vendor
2020-11-09 00:00:00 | [NAME] |  | lb | 5.75 | 178.25 |  | Average Spent Per month/per lb/ per vendors | The average total spent per month per vendors / Example: Vendor A sells an Average of $10.01 per lb in January |  |  |  |  |  |  |  |  |  |  |  |  | <<<Total Average Per month per vendors per pound. / Example: Our average spend is $9.98 per month per vendor
2020-11-09 00:00:00 | [NAME] |  | lb | 5.75 | 3634
2020-11-30 00:00:00 | [NAME] |  | lb | 6.25 | 1256.25
2020-11-30 00:00:00 | [NAME] |  | lb | 6.25 | 34281.25
2020-12-03 00:00:00 | [NAME] |  | lb | 6.25 | 24906.25
2020-12-07 00:00:00 | [NAME] |  | lb | 6 | 600
2020-12-15 00:00:00 | [NAME] |  | lb | 6.12764 | 16802
2020-12-15 00:00:00 | [NAME] |  | lb | 5.75 | 17094.75
2020-12-28 00:00:00 | [NAME] |  | lb | 6.25 | 27681.25
2020-12-30 00:00:00 | [NAME] |  | lb | 6.25 | 2125
2021-01-14 00:00:00 | [NAME] |  | lb | 5.5 | 319
2021-01-14 00:00:00 | [NAME] |  | lb | 6.25 | 15800
2021-01-14 00:00:00 | [NAME] |  | lb | 6.65 | 21373.1
2021-02-09 00:00:00 | [NAME] |  | lb | 7 | 4249
2021-02-09 00:00:00 | [NAME] |  | lb | 6.5 | 5206.5
2021-02-09 00:00:00 | [NAME] |  | lb | 6.99525 | 10311
2021-03-23 00:00:00 | [NAME] |  | lb | 7 | 1939
2021-03-23 00:00:00 | [NAME] |  | lb | 6.76804 | 2626
2021-03-23 00:00:00 | [NAME] |  | lb | 7.25 | 9040.75
2021-03-23 00:00:00 | [NAME] |  | lb | 7 | 12824
2021-03-23 00:00:00 | [NAME] |  | lb | 7.5 | 26482.5
2021-04-12 00:00:00 | [NAME] |  | lb | 7 | 4200
2021-04-12 00:00:00 | [NAME] |  | lb | 7.25 | 7728.5
2021-04-12 00:00:00 | [NAME] |  | lb | 7.5 | 8497.5
2021-04-19 00:00:00 | [NAME] |  | lb | 7.5 | 24712.5
2021-04-21 00:00:00 | [NAME] |  | lb | 6.5 | 3120
2021-04-26 00:00:00 | [NAME] |  | lb | 7.25 | 2189.5
2021-04-26 00:00:00 | [NAME] |  | lb | 7.5 | 5242.5
2021-05-11 00:00:00 | [NAME] |  | lb | 7.5 | 952.5
2021-05-11 00:00:00 | [NAME] |  | lb | 7.25 | 1109.25
2021-05-24 00:00:00 | [NAME] |  | lb | 7.5 | 3420
2021-05-27 00:00:00 | [NAME] |  | lb | 7.25 | 1464.5
2021-06-01 00:00:00 | [NAME] |  | lb | 6.75 | 1154.25
2021-06-07 00:00:00 | [NAME] |  | lb | 7.25 | 1479
2021-06-10 00:00:00 | [NAME] |  | lb | 7.20849 | 7554.5
2021-06-18 00:00:00 | [NAME] |  | lb | 7.25 | 1102
2021-06-28 00:00:00 | [NAME] |  | lb | 7.5 | 5437.5
2021-06-30 00:00:00 | [NAME] |  | lb | 6.75 | 1188
2021-07-01 00:00:00 | [NAME] |  | lb | 7.25 | 1479
2021-07-07 00:00:00 | [NAME] |  | lb | 7.90975 | 14680.5
2021-07-19 00:00:00 | [NAME] |  | lb | 7.25 | 1508
2021-07-21 00:00:00 | [NAME] |  | lb | 6.75 | 978.75
2021-07-26 00:00:00 | [NAME] |  | lb | 7.25 | 1065.75
2021-07-26 00:00:00 | [NAME] |  | lb | 7.5 | 8415
2021-08-13 00:00:00 | [NAME] |  | lb | 7.25 | 3291.5
2021-08-18 00:00:00 | [NAME] |  | lb | 7.5 | 8437.5
2021-08-25 00:00:00 | [NAME] |  | lb | 7.25 | 1486.25
2021-09-02 00:00:00 | [NAME] |  | lb | 7.75 | 15486.05
2021-09-09 00:00:00 | [NAME] |  | lb | 7.75 | 7137.75
2021-09-14 00:00:00 | [NAME] |  | lb | 6.75 | 1950.75
2021-09-22 00:00:00 | [NAME] |  | lb | 7.75 | 5270
2021-10-11 00:00:00 | [NAME] |  | lb | 7.75 | 3216.25
2021-10-11 00:00:00 | [NAME] |  | lb | 7.75 | 6928.5
2021-10-18 00:00:00 | [NAME] |  | lb | 7.71261 | 2104
2021-11-02 00:00:00 | Shedeur Sanders |  | lb | 6.25 | 5318.75
2021-11-12 00:00:00 | [NAME] |  | lb | 7.70032 | 12012.5
2021-11-12 00:00:00 | [NAME] |  | lb | 7.8 | 29788.2
2021-11-22 00:00:00 | [NAME] |  | lb | 8 | 3624
2021-12-07 00:00:00 | [NAME] |  | lb | 7.06481 | 38.15
2021-12-07 00:00:00 | [NAME] |  | lb | 7.75 | 689.75
2021-12-21 00:00:00 | [NAME] |  | lb | 8 | 1896
2021-12-28 00:00:00 | [NAME] |  | lb | 7.75 | 38.75
2022-01-04 00:00:00 | [NAME] |  | lb | 7 | 21
2022-01-04 00:00:00 | [NAME] |  | lb | 8.25 | 20625
2022-01-04 00:00:00 | [NAME] |  | lb | 8.5 | 28339
2022-01-06 00:00:00 | [NAME] |  | lb | 8 | 4840
2022-01-06 00:00:00 | [NAME] |  | lb | 8.25 | 32348.25
2022-01-19 00:00:00 | [NAME] |  | lb | 8 | 6800
2022-01-19 00:00:00 | [NAME] |  | lb | 8.16948 | 9207
2022-02-15 00:00:00 | [NAME] |  | lb | 8.5 | 17688.5
2022-03-04 00:00:00 | [NAME] |  | lb | 8.5 | 5632.1
2022-03-04 00:00:00 | [NAME] |  | lb | 9 | 34309.8
2022-03-14 00:00:00 | [NAME] |  | lb | 8.5 | 12967.6
2022-04-05 00:00:00 | [NAME] |  | lb | 9 | 2592
2022-04-11 00:00:00 | [NAME] |  | lb | 8.5 | 5151
2022-04-11 00:00:00 | [NAME] |  | lb | 8.75 | 12346.25
2022-04-27 00:00:00 | [NAME] |  | lb | 8.49641 | 10059.75
2022-04-28 00:00:00 | [NAME] |  | lb | 8.75 | 2213.75
2022-04-29 00:00:00 | [NAME] |  | lb | 7 | 28
2022-05-10 00:00:00 | [NAME] |  | lb | 9 | 7128
2022-05-11 00:00:00 | [NAME] |  | lb | 8.75 | 4401.25
2022-05-13 00:00:00 | [NAME] |  | lb | 7 | 28
2022-05-25 00:00:00 | [NAME] |  | lb | 8 | 352
2022-05-31 00:00:00 | [NAME] |  | lb | 8.5 | 4284
2022-06-01 00:00:00 | [NAME] |  | lb | 9 | 3438
2022-06-02 00:00:00 | [NAME] |  | lb | 8.12658 | 1926
2022-06-13 00:00:00 | [NAME] |  | lb | 9 | 2250
2022-06-24 00:00:00 | [NAME] |  | lb | 9 | 1872
2022-07-22 00:00:00 | [NAME] |  | lb | 9 | 2007
2022-08-12 00:00:00 | [NAME] |  | lb | 6.00629 | 191
2022-08-15 00:00:00 | [NAME] |  | lb | 9 | 80460
2022-08-31 00:00:00 | [NAME] |  | lb | 9 | 13284
2022-08-31 00:00:00 | [NAME] |  | lb | 9 | 23166
2022-09-07 00:00:00 | [NAME] |  | lb | 8.5 | 1853
2022-10-11 00:00:00 | [NAME] |  | lb | 9.25 | 37083.25
2022-10-12 00:00:00 | [NAME] |  | lb | 8.5 | 1578.45
2022-10-13 00:00:00 | [NAME] |  | lb | 8.5 | 2966.5
2022-10-13 00:00:00 | Shedeur Sanders |  | lb | 7.5 | 6142.5
2022-10-18 00:00:00 | [NAME] |  | lb | 8.78415 | 27652.5
2022-10-20 00:00:00 | [NAME] |  | lb | 8.06563 | 10138.5
2022-10-25 00:00:00 | [NAME] |  | lb | 9 | 774
2022-11-04 00:00:00 | [NAME] |  | lb | 8.55822 | 16243.5
2022-11-10 00:00:00 | [NAME] |  | lb | 9.35 | 42972.6
2022-11-16 00:00:00 | [NAME] |  | lb | 9.35 | 27591.85
2022-11-17 00:00:00 | [NAME] |  | lb | 9 | 513
2022-11-28 00:00:00 | [NAME] |  | lb | 8.49402 | 4833.1
2022-12-19 00:00:00 | [NAME] |  | lb | 9 | 9000
2022-12-19 00:00:00 | [NAME] |  | lb | 8.5 | 13379
2023-01-11 00:00:00 | [NAME] |  | lb | 9.35 | 17765
2023-01-11 00:00:00 | [NAME] |  | lb | 8.5 | 25916.5
2023-01-25 00:00:00 | [NAME] |  | lb | 8.47135 | 31420.25
2023-01-26 00:00:00 | [NAME] |  | lb | 8.5 | 24488.5
2023-01-30 00:00:00 | [NAME] |  | lb | 8.5 | 22040.5
2023-03-06 00:00:00 | [NAME] |  | lb | 8 | 14640
2023-03-06 00:00:00 | [NAME] |  | lb | 8.27295 | 44673.93
2023-03-15 00:00:00 | [NAME] |  | lb | 8.25 | 5065.5
2023-03-23 00:00:00 | [NAME] |  | lb | 8.25 | 25080
2023-04-06 00:00:00 | [NAME] |  | lb | 7.90741 | 3416
2023-04-27 00:00:00 | [NAME] |  | lb | 8.25 | 16483.5
2023-05-10 00:00:00 | [NAME] |  | lb | 8 | 36136
2023-05-12 00:00:00 | [NAME] |  | lb | 8.25 | 18414
2023-05-25 00:00:00 | [NAME] |  | lb | 8 | 28464
2023-05-30 00:00:00 | [NAME] |  | lb | 8 | 120
2023-06-05 00:00:00 | [NAME] |  | lb | 7.59494 | 2400
2023-06-13 00:00:00 | [NAME] |  | lb | 8.25 | 8217
2023-06-15 00:00:00 | [NAME] |  | lb | 7.5 | 6727.5
2023-06-15 00:00:00 | [NAME] |  | lb | 7.75 | 7610.5
2023-06-15 00:00:00 | [NAME] |  | lb | 8.25 | 21202.5
2023-06-16 00:00:00 | [NAME] |  | lb | 7 | 70
2023-07-12 00:00:00 | [NAME] |  | lb | 7.5 | 8557.5
2023-07-20 00:00:00 | [NAME] |  | lb | 7.75 | 27411.75
2023-07-24 00:00:00 | [NAME] |  | lb | 8.14672 | 14770
2023-07-28 00:00:00 | [NAME] |  | lb | 7.90594 | 798.5
2023-07-28 00:00:00 | [NAME] |  | lb | 7.75 | 27047.5
2023-08-01 00:00:00 | [NAME] |  | lb | 7.81622 | 10309.6
2023-08-09 00:00:00 | [NAME] |  | lb | 7.5 | 2137.5
2023-08-21 00:00:00 | [NAME] |  | lb | 10.69519 | 2
2023-09-05 00:00:00 | [NAME] |  | lb | 8.21498 | 23034.8
2023-09-19 00:00:00 | [NAME] |  | lb | 7.5 | 12435
2023-09-26 00:00:00 | [NAME] |  | lb | 7.75 | 51343.75
2023-10-10 00:00:00 | [NAME] |  | lb | 7.75245 | 2465.28
2023-10-17 00:00:00 | [NAME] |  | lb | 5.83333 | 35
2023-10-19 00:00:00 | [NAME] |  | lb | 6.72472 | 1197
2023-10-30 00:00:00 | [NAME] |  | lb | 6 | 42
2023-11-01 00:00:00 | [NAME] |  | lb | 7.5 | 28552.5
2023-12-18 00:00:00 | [NAME] |  | lb | 7.1308 | 12143.75
2024-01-31 00:00:00 | [NAME] |  | lb | 7.35 | 48164.55
2024-02-01 00:00:00 | [NAME] |  | lb | 7 | 7686
2024-02-06 00:00:00 | [NAME] |  | lb | 6.86034 | 3684
2024-03-14 00:00:00 | [NAME] |  | lb | 7.5 | 5235
2024-03-28 00:00:00 | [NAME] |  | lb | 7.5 | 15217.5
2024-04-15 00:00:00 | [NAME] |  | lb | 7.25 | 4067.25
2024-04-16 00:00:00 | [NAME] |  | lb | 5.25 | 126
2024-05-14 00:00:00 | [NAME] |  | lb | 7.5 | 15420
2024-05-21 00:00:00 | [NAME] |  | lb | 7.5 | 3915
2024-05-21 00:00:00 | [NAME] |  | lb | 7.5 | 8707.5
2024-06-06 00:00:00 | [NAME] |  | lb | 7.5 | 5280
2024-06-20 00:00:00 | [NAME] |  | lb | 7.5 | 8197.5
2024-06-26 00:00:00 | [NAME] |  | lb | 7.5 | 6210
2024-06-28 00:00:00 | [NAME] |  | lb | 7.31057 | 5673
2024-07-15 00:00:00 | [NAME] |  | lb | 7.5 | 3772.5
2024-07-29 00:00:00 | [NAME] |  | lb | 6 | 48
2024-07-30 00:00:00 | [NAME] |  | lb | 7.5 | 7477.5
2024-08-06 00:00:00 | [NAME] |  | lb | 7.5 | 22642.5
2024-08-12 00:00:00 | [NAME] |  | lb | 7.5 | 16038.75
2024-08-27 00:00:00 | [NAME] |  | lb | 7.25 | 5292.5
2024-08-29 00:00:00 | [NAME] |  | lb | 7.75 | 5742.75
2024-08-29 00:00:00 | [NAME] |  | lb | 7.49031 | 6943.52
2024-08-29 00:00:00 | [NAME] |  | lb | 7 | 7287
2024-09-05 00:00:00 | [NAME] |  | lb | 7.5 | 8962.5
2024-09-11 00:00:00 | [NAME] |  | lb | 5.89273 | 64.82
2024-09-16 00:00:00 | [NAME] |  | lb | 5.5 | 33
2024-09-16 00:00:00 | [NAME] |  | lb | 7.5 | 1522.5
2024-09-16 00:00:00 | [NAME] |  | lb | 7.5 | 2040
2024-09-16 00:00:00 | [NAME] |  | lb | 7.5 | 25162.5
2024-09-23 00:00:00 | [NAME] |  | lb | 5.4565 | 109.13
2024-09-24 00:00:00 | [NAME] |  | lb | 7.75 | 42144.5
2024-10-08 00:00:00 | [NAME] |  | lb | 7.75 | 23629.75
2024-10-14 00:00:00 | [NAME] |  | lb | 6.45 | 25.8
2024-10-18 00:00:00 | [NAME] |  | lb | 7.25 | 14326
2024-10-18 00:00:00 | [NAME] |  | lb | 7.5 | 15570
2024-10-21 00:00:00 | [NAME] |  | lb | 7.25 | 1283.25
2024-10-30 00:00:00 | [NAME] |  | lb | 7.75 | 44616.75
2024-11-18 00:00:00 | [NAME] |  | lb | 7 | 735
2024-11-18 00:00:00 | [NAME] |  | lb | 7 | 8463
2024-11-18 00:00:00 | [NAME] |  | lb | 7.5 | 11632.5
2024-11-18 00:00:00 | [NAME] |  | lb | 7.5 | 16500
2024-12-17 00:00:00 | [NAME] |  | lb | 7.25 | 20329