Spreadsheet: 482823d1475255460-find-first-available-cell-0-in-a-row-and-using-next-cell-0-thereafter-for-a-calculation-book1-sample
Sheet: APPLICATION_DATA

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Purple is normally hidden
ENTER DATA IN YELLOW COLUMNS
Operator ID-Permit Number | Permittee Name | Site Location ID | Block | Permit or NOI Commodity | Section | Township | Range | Earliest Fumigation Month | Latest Fumigation Month | Requested Acres | Product Name | Registration Number | Product Application Rate Per Treated Acre | Product Application Rate Units | Strip or Bed  [NAME] (inches) | Center to Center Spacing (inches) | Area of Beds/Strips + Row Spacing (acres) | Product Application Rate Per Treated Acre (lbs product/ac) | Broadcast Equivalent Rate for Bed/Strip Area (lbs product/ac) | Broadcast Equivalent Rate for Bed/Strip Area (gal product/ac) | Broadcast Equivalent Rate (lbs product/ac) | Broadcast Equivalent Rate (gal product/ac) | VOC Emission Rate (lbs/acre) | Combined Emission Potential and Emission Rating (%) | Chloropicrin | Dazomet | Methyl bromide | 1,3-dichloropropene | Metam sodium | Metam potassium | Sodium tetrathiocarbonate | Iodomethane | [NAME] | NOI Acres | NOI Reference | NOI Resubmit | NOI Fumigation Date | NOI Month | NOI VOC Emissions (lbs) | May-Oct NOI VOC Emissions (lbs) | NOI Remaining Acres | NOI AI (lbs) | Commodity | Fumigation Date | Month | Acres | Controlling Acres | VOC Emissions (lbs) | May-Oct PUR VOC Emissions (lbs) | Remaining Acres | Fumigation Date | AI (lbs) | May-Oct VOC Emissions (lbs) | Fumigated Acres | Remaining Acres | Total Active Ingredient (lbs)
 |  |  |  |  |  |  |  |  |  |  |  |  | 200 | lbs/ac |  |  | 7 | 200 | 200 |  | 100 |  | 13.86 | 1386 | 2772 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1143 | 14 |  |  | 2013-04-11 00:00:00 |  | 194.04 |  | -14 | 2772 |  |  |  | 14 | 14 | 194.04 |  | -14 |  | 2772 |  |  | -14 | 2772 |  | Ap Rate Units | Commodity | PCB
 |  |  |  |  |  |  |  |  |  |  |  |  | 200 | lbs/ac |  |  | 7 | 200 | 200 |  | 100 |  | 13.86 | 1386 | 2772 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1143 | 14 |  |  | 2013-05-01 00:00:00 |  | 194.04 |  | -14 | 2772 |  |  |  | 14 | 14 | 194.04 |  | -14 |  | 2772 |  |  | -14 | 2772 |  | lbs/ac | avocado | COAST
 |  |  |  |  |  |  |  |  |  |  |  |  | 200 | lbs/ac | 40 | 80 |  | 200 | 100 |  | 100 |  | 13.86 | 1386 | 39.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1143 | 1.46 |  |  | 2013-05-03 00:00:00 |  | 20.2356 |  | -1.46 | 289.08 |  |  |  | 0.2 | 0.2 | 2.772 |  | -0.2 |  | 39.6 |  |  | -0.2 | 39.6 |  | gal/ac | blackberry | CPS
 |  |  |  |  |  |  |  |  |  |  |  |  | 23 | gal/ac |  |  |  | 233.036 | 233.036 | 23 | 233.036 | 23 | 5.009500320479999 | 500.9500320479999 | 0 | 0 | 0 | 0 | 663.803046 | 0 | 0 | 0 | 1407 | 6.75 |  |  | 2013-05-03 00:00:00 |  | 33.81412716323999 |  | -6.75 | 663.803046 |  |  |  | 6.75 | 6.75 | 33.81412716323999 |  | -6.75 |  | 663.803046 |  |  | -6.75 | 663.803046 |  |  | blueberry | OTHER
 |  |  |  |  |  |  |  |  |  |  |  |  | 45 | gal/ac | 40 | 80 |  | 455.94 | 227.97 | 22.5 | 227.97 | 22.5 | 9.8011962792 | 980.1196279199999 | 0 | 0 | 0 | 0 | 2693.69352 | 0 | 0 | 0 | 1407 | 14 |  | Y | 2013-05-04 00:00:00 |  | 137.2167479088 |  | -14 | 2693.69352 |  |  |  | 14 | 14 | 137.2167479088 |  | -14 |  | 2693.69352 |  |  | -14 | 2693.69352 |  |  | carrot | SOIL FUME
 |  |  |  |  |  |  |  |  |  |  |  |  | 50 | gal/ac |  |  | 14 | 506.6 | 506.6 | 50 | 254.2078853046595 | 25.08960573476703 | 10.890218088 | 1089.0218088 | 0 | 0 | 0 | 0 | 5964.60708 | 0 | 0 | 0 | 1407 | 27.9 |  | Y | 2013-05-04 00:00:00 |  | 303.8370846551999 |  | -27.9 | 5964.60708 |  |  |  | 27.9 | 27.9 | 303.8370846551999 |  | -27.9 |  | 5964.60708 |  |  | -27.9 | 5964.60708 |  |  | cut flower | TRI-CAL
 |  |  |  |  |  |  |  |  |  |  |  |  | 33 | gal/ac | 40 | 80 | 5 | 395.472 | 197.736 | 16.5 | 98.868 | 8.25 | 31.92249984 | 3192.249984 | 2357.01312 | 0 | 0 | 1542.3408 | 0 | 0 | 0 | 0 | 1247 | 11 |  |  | 2013-05-06 00:00:00 |  | 351.14749824 |  | -11 | 4289.289312 |  |  |  | 10 | 10 | 319.2249984 |  | -10 |  | 3899.35392 |  |  | -10 | 4289.289312 |  |  | grape, wine
 |  |  |  |  |  |  |  |  |  |  |  |  | 33 | gal/ac |  |  |  | 395.472 | 395.472 | 33 | 395.472 | 33 | 31.92249984 | 3192.249984 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1247 | 14 |  | Y | 2013-05-07 00:00:00 |  | 446.91499776 |  | -14 | 5459.095488 |  |  |  |  | 14 |  |  |  |  | 0 |  |  | -14 | 5459.095488 |  |  | lemon
 |  |  |  |  |  |  |  |  |  |  |  |  | 24.7 | gal/ac |  |  |  | 250.2604 | 250.2604 | 24.7 | 250.2604 | 24.7 | 5.379767735471999 | 537.9767735471999 | 0 | 0 | 0 | 0 | 712.8667494 | 0 | 0 | 0 | 1407 | 6.75 |  |  | 2013-11-01 00:00:00 |  | 36.31343221443599 |  | -6.75 | 712.8667494 |  |  |  | 6.75 | 6.75 | 36.31343221443599 |  | -6.75 |  | 712.8667494 |  |  | -6.75 | 712.8667494 |  |  | nursery
 |  |  |  |  |  |  |  |  |  |  |  |  | 34 | gal/ac |  |  |  | 407.456 | 407.456 | 34 | 407.456 | 34 |  |  | 1457.062656 | 0 | 0 | 953.44704 | 0 | 0 | 0 | 0 |  | 7 |  |  | 2013-05-10 00:00:00 |  |  |  | -7 | 2812.261312 |  |  |  | 6 | 6 |  |  | -6 |  | 2410.509696 |  |  | -6 | 2812.261312 |  |  | other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 407.456 | 407.456 | 34 | 407.456 | 34 |  |  | 1457.062656 |  |  | 953.44704 | 0 | 0 | 0 | 0 |  | 7 |  |  | 2013-05-11 00:00:00 |  |  |  |  | 2812.261312 |  |  |  | 6 | 6 |  |  | -6 |  | 2410.509696 |  |  | -6 | 2812.261312 |  |  | pepper
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | raspberry
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1010 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sod
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | tangerine
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]