How should farm and crop information be set up on the FarmData worksheet?
On the FarmData worksheet, each column (Farms, Orchards or Vineyards, Blocks & Acres, Varieties, and Sprayers) is for you to enter a list of the names or codes for each that you have and use on your farm business. These lists then become drop-down lists on the SprayData, FertData, and BloomHarvestData worksheets to make data entry easier and more consistent. For the list of Block names or codes, the size of the block must be entered next to the block name. Use abbreviated names or codes if necessary. Put unique identifying characters at the front of the name when names are similar. For example, if several blocks contain Concord grapes, they might be designated as “B-l Concord” and “B-2 Concord”, etc. Also consider how your sprays are applied. Are all the Concord grape blocks sprayed on a single day or does it take longer? Are only the Ginger Gold apples sprayed for fire blight? In each of the lists (Farms, Orchards or Vineyards, Blocks, or Varieties) you may want to have the word “All”
