NHForester
New Member
- Joined
- Aug 13, 2014
- Messages
- 4
I work with a bunch of foresters that are baffled by Pivot Tables. We use a spreadsheet to track harvested sawlog volumes. There can be up to 400 loads entered; when a load is entered a Date is entered which calculates a Fiscal Year. I used CSE formula to generate a list of Fiscal Years. I would like to Automatically sum volumes by using my list of Fiscal Years. Since Fiscal years will change I cant use Sumif because I can't use a cell reference for the criteria. Any suggestions? I am not a coder and but OK with Functions.
Below will give you an idea of data. Any help will be much appreciated.
Thanks
Shaun
NH Div. of Forests & Lands
<colgroup><col><col><col><col span="2"><col><col span="9"></colgroup><tbody>
</tbody>
Below will give you an idea of data. Any help will be much appreciated.
Thanks
Shaun
NH Div. of Forests & Lands
Property: | William Thomas SF | Project #: | P2-425 | |||||||||||
Other Trip Ticket | F&L Trip Ticket | Scale Slip # | Date | Fy | Custom | White pine - G | White pine - P | Hemlock | red pine | Red Spruce | Red Oak | Red Maple | Other hardwood | Hardwood pallet |
% of Vol. Harvested | 124.9% | 74.9% | 78.1% | 77.2% | 100.0% | 87.3% | 57.5% | 147.0% | 486.7% | |||||
6951 | 142386 | 01/19/16 | 2016 | In | ||||||||||
6952 | 142501 | 01/22/16 | 2016 | Co | ||||||||||
6953 | 142506 | 01/22/16 | 2016 | Co | ||||||||||
6954 | 55751 | 01/22/16 | 2016 | King | 6.045 | 0.915 | ||||||||
6955 | 142514 | 01/19/16 | 2016 | In | ||||||||||
6956 | 142521 | 01/22/16 | 2016 | In | ||||||||||
6957 | 142528 | 01/23/16 | 2016 | In | ||||||||||
6958 | 51730 | 01/23/16 | 2016 | Beck | ||||||||||
6959 | 698423 | 01/23/16 | 2016 | In | ||||||||||
6960 | 698479 | 01/23/16 | 2016 | In | ||||||||||
6961 | 55718 | 01/25/16 | 2016 | King | 6.845 | |||||||||
6962 | 142608 | 01/22/16 | 2016 | In | ||||||||||
6963 | 142616 | 01/25/16 | 2016 | In | ||||||||||
6964 | 142637 | 01/25/16 | 2016 | In | ||||||||||
6965 | 51752 | 01/25/16 | 2016 | Beck | ||||||||||
Total volume | 293.395 | 15.200 | 26.425 | 2.875 | 0.500 | 43.990 | 5.360 | 6.490 | 27.838 | |||||
# of Loads | 222 | 223 | 14 | 1 | 1 | 14 | 8 | 15 | 16 | |||||
Avg. Load | 1.322 | 0.068 | 1.888 | 2.875 | 0.500 | 3.142 | 0.670 | 0.433 | 1.740 | |||||
FY | Category | Sftwd | Sftwd | Sftwd | Sftwd | Sftwd | Hdwd | Hdwd | Hdwd | Hdwd | ||||
2016 | ||||||||||||||
List of Fiscal Years | 2017 | |||||||||||||
2019 | ||||||||||||||
2021 | ||||||||||||||
2023 | ||||||||||||||
2024 | ||||||||||||||
1900 | ||||||||||||||
<colgroup><col><col><col><col span="2"><col><col span="9"></colgroup><tbody>
</tbody>