|
| Hi all,
I've been searching NAT and having trouble finding what I'm after. Could someone help my brain fog on how to create a streamlined spreadsheet? Basically I plan to just keep paper records in the sprayer and bring them home to enter. I would like to have records separated by individual field. I also would like to keep track of total gallons used (and unit price if possible) per field due to credit/rebill on landlord share. Is there a streamlined way to keep track of this info without a majorly complicated spreadsheet?
I've thought of making a 'master' sheet with drop down menus for chemical names, then using the 'save as' feature to save to a folder, but then it would be hard to keep track of totals for credit/rebill. If I just open a new tab for every spray record, I could then have a totals tab at the last, but that seems like it will be a lot of copying and pasting for each individual spray record 'tab'.
Anyone done something similar or have some ideas for me?
Thanks. | |
|