{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Intro","Master"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Intro","index":0,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,10,26,15],[39,1,39,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[1,1,1,6],[23,1,23,3],[24,1,24,3],[25,1,25,3],[22,3,22,5],[5,1,5,2],[11,1,11,2],[17,1,17,2],[5,5,5,6],[11,5,11,6]]}
[]
[null,"SELECT YOUR WATER FLOW METER TYPE"]
[]
[null,null,null,null,null,null,null,null,"STEP 1: Select your water meter type at left"]
[null,null,null,1,2,null,null,null,"STEP 2: Input Field Data on Data Tabs"]
[null,"Gallons x 100",null,null,null,"Acre Feet x .01",null,null,"STEP 3: Select Make Field button"]
[null,null,null,null,null,null,null,null,"STEP 4:  For Additional Fields, Repeat Steps 1-3"]
[null,null,null,null,null,null,null,null,null,null,null,"Multiplier","CFS Conversion"]
[null,null,null,null,null,null,null,null,1,"Gallons","Gallons X 100",100,453]
[null,null,null,null,null,null,null,null,3,"Gallons","Gallons 000",1000,453]
[null,null,null,3,4,null,null,null,5,"Acre Inches","Ac-In X .01",271.54000000000002,453]
[null,"Gallons x 1000",null,null,null,"Acre Feet x .001",null,null,2,"Acre Feet","Ac-Ft X 0.001",325.84800000000001,453]
[null,null,null,null,null,null,null,null,4,"Acre Feet","Ac-Ft X 0.001",325.84800000000001,1]
[]
[]
[]
[null,null,null,5]
[null,"Acre Inches x .01"]
[]
[]
[null,null,null,null,null,3]
[]
[null,"Enter Field Name",null,"test"]
[null,null,null,null,null,null,null,null,null,null,"Developed by:","Chuck Burr, Extension Educator - WCREC"]
[null,null,null,null,null,null,null,null,null,null,null,"Tim Lemmons, Extension Educator - NEREC"]
[null,null,null,null,null,null,null,null,null,null,null,"Tom Dorn, Extension Educator - Lancaster County"]
[null,null,null,null,null,null,null,null,null,null,"Special Thanks to Brian Lubeck and Shirlee Poyser, LRNRD for their input"]

{"sheet":"Master","index":1,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":true,"merged":[[8,2,8,4],[9,2,9,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Year of Allocation"]
["Field Name:",null,null,null,null,null,"Multiplier","Const.",null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
["Meter Manufacturer***",null,null,null,null,null,{"$f":"INDEX(Intro!$I$9:$M$13,MATCH(Master!$B$12,Intro!$I$9:$I$13,0),MATCH(Master!G2,Intro!$I$8:$M$8,0))","v":271.54000000000002},{"$f":"INDEX(Intro!$I$9:$M$13,MATCH(Master!$B$12,Intro!$I$9:$I$13,0),5)","v":453},null,null,null,{"$f":"+(B8)","v":2013},{"$f":"+IF(B7>1,(B8+1),\"\")","v":2014},{"$f":"+IF(B7>2,(B8+2),\"\")","v":2015},{"$f":"+IF(B7>3,(B8+3),\"\")","v":2016},{"$f":"+IF(B7>4,(B8+4),\"\")","v":2017}]
["Meter Serial Number",null,null,null,null,null,null,null,null,"Beginning Meter Reading",null,0,{"$f":"+(L5)","v":0},{"$f":"+(M5)","v":0},{"$f":"+(N5)","v":0},{"$f":"+(O5)","v":0}]
["Acres in Field:",1,null,null,null,null,null,null,null,"End of Season Meter Reading",null,{"$f":"P16","v":0}]
[null,null,null,null,null,"Use the Section to the right to keep track",null,null,null,"    Total Gallons Pumped",null,{"$f":"IF(ISBLANK(L5),0,(L5-L4)*$G$3)","v":0},{"$f":"IF(ISBLANK(M5),0,(M5-M4)*$G$3)","v":0},{"$f":"IF(ISBLANK(N5),0,(N5-N4)*$G$3)","v":0},{"$f":"IF(ISBLANK(O5),0,(O5-O4)*$G$3)","v":0},{"$f":"IF(ISBLANK(P5),0,(P5-P4)*$G$3)","v":0}]
["Years in Allocation",5,null,null,null,"Of your Remaining Allocation.",null,null,null,"    Water Pumped, Ac-In",null,{"$f":"L6*0.000036827","v":0},{"$f":"M6*0.000036827","v":0},{"$f":"N6*0.000036827","v":0},{"$f":"O6*0.000036827","v":0},{"$f":"P6*0.000036827","v":0}]
["First Year of Allocation",2013,null,null,null,"Enter the Beginning Season Meter Reading",null,null,null,"Water Pumped Per Acre, inches",null,{"$f":"+(L7)/($B$5)","v":0},{"$f":"+(M7)/($B$5)","v":0},{"$f":"+(N7)/($B$5)","v":0},{"$f":"+(O7)/($B$5)","v":0},{"$f":"+(P7)/($B$5)","v":0}]
["Allocation, inches:",45,null,null,null,"and the End of Season Meter Reading.",null,null,null,"Remaining Annual Cap, Inches",null,{"$f":"IF($B$10>0,($B$10-L8),\"\")","v":10.5},{"$f":"IF($B$10>0,($B$10-M8),\"\")","v":10.5},{"$f":"IF($B$10>0,($B$10-N8),\"\")","v":10.5},{"$f":"IF($B$10>0,($B$10-O8),\"\")","v":10.5},{"$f":"IF($B$10>0,($B$10-P8),\"\")","v":10.5}]
["Annual Cap, Inches:",10.5,"Meter Totalizer Unit Type",null,null,null,null,null,null,"Annual Cap Penalty",null,{"$f":"IF($B$10>0,IF((L8>$B$10),((L8-$B$10)*$B$11),\"0\"),\"\")","v":"0"},{"$f":"IF($B$10>0,IF((M8>$B$10),((M8-$B$10)*$B$11),\"0\"),\"\")","v":"0"},{"$f":"IF($B$10>0,IF((N8>$B$10),((N8-$B$10)*$B$11),\"0\"),\"\")","v":"0"},{"$f":"IF($B$10>0,IF((O8>$B$10),((O8-$B$10)*$B$11),\"0\"),\"\")","v":"0"},{"$f":"IF($B$10>0,IF((P8>$B$10),((P8-$B$10)*$B$11),\"0\"),\"\")","v":"0"}]
["Annual Cap, Penalty",3,null,null,null,null,null,null,null,"Remaining Allocation, inches:",null,{"$f":"+IF($B$10>0,($B$9-L8-L10),($B$9-L8))","v":45},{"$f":"+IF($B$10>0,(L11-M8-M10),(L11-M8))","v":45},{"$f":"+IF($B$10>0,(M11-N8-N10),(M11-N8))","v":45},{"$f":"+IF($B$10>0,(N11-O8-O10),(N11-O8))","v":45},{"$f":"+IF($B$10>0,(O11-P8-P10),(O11-P8))","v":45}]
[null,5]
[null,null,"Period 1","Period 2","Period 3","Period 4","Period 5","Period 6","Period 7","Period 8","Period 9","Period 10","Period 11","Period 12","Period 13","End of Season"]
["Date Read"]
["Beginning Meter Reading",null,null,{"$f":"C16","v":0},{"$f":"D16","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Ending Meter Reading"]
["Gallons Pumped",null,{"$f":"IF(ISBLANK(C16),0,(C16-C15)*$G$3)","v":0},{"$f":"IF(ISBLANK(D16),0,(D16-D15)*$G$3)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["    Water Pumped, Ac-In",null,{"$f":"C17*0.000036827","v":0},{"$f":"D17*0.000036827","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["    Water Pumped Per Acre, inches",null,{"$f":"+(C18)/($B$5)","v":0},{"$f":"+(D18)/($B$5)","v":0},{"$f":"+(E18)/($B$5)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Total Water pumped this year, in",null,{"$f":"SUM(C19)","v":0},{"$f":"IF(ISBLANK(D16),0,(C20+D19))","v":0},{"$f":"IF(ISBLANK(E16),0,(D20+E19))","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Annual Cap Section"]
["Remaining Annual Cap, Inches",null,{"$f":"IF($B$10>0,(B10-C20),\"\")","v":10.5},{"$f":"IF($B$10>0,($B$10-D20),\"\")","v":10.5},{"$f":"IF($B$10>0,($B$10-E20),\"\")","v":10.5},10.5,10.5,10.5,10.5,10.5,10.5,10.5,10.5,10.5,10.5,10.5]
["Annual Cap Penalty",null,{"$f":"IF($B$10>0,IF((C20>$B$10),((C20-$B$10)*$B$11),\"0\"),\"0\")","v":"0"},{"$f":"IF($B$10>0,IF((D20>$B$10),((D20-$B$10)*$B$11),\"0\"),\"0\")","v":"0"},"0","0","0","0","0","0","0","0","0","0","0","0"]
["Total Pumped Plus Penalty",null,{"$f":"+(C20+C24)","v":0},{"$f":"+(D20+D24)","v":0},{"$f":"+(E20+E24)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Gallons to Pump for Remaining Cap",null,{"$f":"IF($B$10>0,IF(ISBLANK(C16),0,(C23*$B$5)*27154.285),\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Final Reading to pump "]
["    Remaining Annual Cap",null,{"$f":"IF($B$10>0,IF(ISBLANK(C16),0,(C27/$G$3)+C16),\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["*** Mention of Trade Names Does Not Indicate Endorsement"]