{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["targets","Default LW sample sets","field sheet","datasheet "],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":66,"comments":2,"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":"targets","index":0,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[[2,9,2,10],[3,9,3,10],[3,13,4,13]]}
[null,"Target gpm calculator for flow meters",null,null,null,null,null,null,null,"v 7-25-11 Univesity of California Cooperative Extension mcmathews@ucdavis.edu"]
[]
[null,null,null,null,"2011-06-01","date",null,null,"source lagoon:","primary lagoon"]
[null,"My Dairy",null,2011,"summer","season",null,null,"thousand gallons needed:",{"$f":"SUM(D28:M28)","v":0},null,null,null,"extra location"]
[]
[null,"Location"]
[null,"Acres"]
[null,"Irrigation number"]
[]
[null,"Expected run time (hours)"]
[]
[null,"Target lbs/A available N"]
[null,"Total N applied (lbs/A)",null,{"$f":"IF(AND(D12>0,D21>0),D12/(D21/D16),0)","v":0},{"$f":"IF(AND(E12>0,E21>0),E12/(E21/E16),0)","v":0},0,0,0,0,0,0,0,{"$f":"IF(AND(M12>0,M21>0),M12/(M21/M16),0)","v":0},{"$f":"IF(AND(N12>0,N21>0),N12/(N21/N16),0)","v":0}]
[]
[null,"Sample name"]
[null,"TKN-N (mg/L)"]
[null,"Ammonium-N (mg/L)"]
[null,"% organic-N ",null,{"$f":"IF(D16>0,(D16-D17)/D16,0)","v":0},{"$f":"IF(E16>0,(E16-E17)/E16,0)","v":0},0,0,0,0,0,0,0,{"$f":"IF(M16>0,(M16-M17)/M16,0)","v":0},{"$f":"IF(N16>0,(N16-N17)/N16,0)","v":0}]
[null,"% org-N available"]
[]
[null," Available N (mg/L)",null,{"$f":"IF(D19>0,D17+((D16-D17)*D19),D17)","v":0},{"$f":"IF(E19>0,E17+((E16-E17)*E19),E17)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Target GPM",null,{"$f":"IF(D40=0,0,IF(OR(D40>D41,D40=D41),D40,D41))","v":0},{"$f":"IF(E40=0,0,IF(OR(E40>E41,E40=E41),E40,E41))","v":0},0,0,0,0,0,0,0,0,0]
[null,"Lagoon only run time",null,{"$f":"IF(D57>0,HoursMinutes(D57),\"\")","v":""},{"$f":"IF(E57>0,HoursMinutes(E57),\"\")","v":""},"","","","","","","","",""]
[null,"LW % of run time",null,{"$f":"IF(D10>0,D57/D10,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"Velocity (ft/sec)",null,{"$f":"IF(D59>0,D23/(D59*448.83),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Thousand gallons needed",null,{"$f":"IF(AND(D13>0,D7>0,D16>0),(D13/(D16*0.008345))*D7,0)","v":0},{"$f":"IF(AND(E13>0,E7>0,E16>0),(E13/(E16*0.008345))*E7,0)","v":0},{"$f":"IF(AND(F13>0,F7>0,F16>0),(F13/(F16*0.008345))*F7,0)","v":0},0,0,0,0,0,0,0,0]
[null,"Acre-inches per acre",null,{"$f":"IF(D7>0,(D28/27.1542856)/D7,0)","v":0},{"$f":"IF(E7>0,(E28/27.1542856)/E7,0)","v":0},{"$f":"IF(F7>0,(F28/27.1542856)/F7,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"Application Rate Quick Calculator"]
[]
[null,"Actual GPM"]
[null,"Actual hours"]
[null,"Available N applied (lbs/A)",null,{"$f":"IF(AND(D21>0,D7>0),((D33*D34*60)/1000*D21*0.008345)/D7,0)","v":0},{"$f":"IF(AND(E21>0,E7>0),((E33*E34*60)/1000*E21*0.008345)/E7,0)","v":0},{"$f":"IF(AND(F21>0,F7>0),((F33*F34*60)/1000*F21*0.008345)/F7,0)","v":0},0,0,0,0,0,0,0,0]
[null,"Total N applied (lbs/A)",null,{"$f":"IF(AND(D21>0,D7>0),((D33*D34*60)/1000*D16*0.008345)/D7,0)","v":0},{"$f":"IF(AND(E21>0,E7>0),((E33*E34*60)/1000*E16*0.008345)/E7,0)","v":0},{"$f":"IF(AND(F21>0,F7>0),((F33*F34*60)/1000*F16*0.008345)/F7,0)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[null,"Pump and Pipeline Parameters"]
[null,"calculated GPM",null,{"$f":"IF(AND(D21>0,D10>0),((D12*D7)/(D21*0.008345)*1000)/(D10*60),0)","v":0},{"$f":"IF(AND(E21>0,E10>0),((E12*E7)/(E21*0.008345)*1000)/(E10*60),0)","v":0},{"$f":"IF(AND(F21>0,F10>0),((F12*F7)/(F21*0.008345)*1000)/(F10*60),0)","v":0},0,0,0,0,0,0,0,0]
[null,"mimimum GPM",null,400,400,400,400,400,400,400,400,400,400,400]
[null,"Pipe inside diameter (in.)",null,10,10,10,10,10,10,10,10,10,10,10]
[null,"Minimum velocity (ft/sec)",null,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"run time at minimum gpm (hrs)",null,{"$f":"IF(AND(D21>0,D41>0),((D12*D7)/(D21*0.008345/1000)/D41)/60,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Target hours",null,{"$f":"IF(D$56<D$10,D$56,D$10)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"min/acre","summer",{"$f":"IF(D7>0,(D10*60)/D7,0)","v":0},{"$f":"IF(E7>0,(E10*60)/E7,0)","v":0},{"$f":"IF(F7>0,(F10*60)/F7,0)","v":0},0,0,0,0,0,0,0,0]
[null,"pipe ID sq ft","fall",{"$f":"(((D42/2)*(D42/2))*3.14)/144","v":0.54513888888888884},0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884]

{"sheet":"Default LW sample sets","index":1,"n_rows":65,"n_cols":18,"rows_kept":65,"cut":false,"hidden":false,"merged":[[55,3,64,3],[2,3,6,3],[11,3,20,3],[22,3,31,3],[33,3,42,3],[44,3,53,3]]}
[null,null,null,null,null,"Default Lagoon Samples"]
[null,"*don’t delete*"]
[null,"LW.default.Set1",null,"sample set name",null,"LW Default Set 1"]
[null,"LW.default.Set2",null,null,null,"2010 samples"]
[null,"LW.default.Set3",null,null,null,"LW set 3"]
[null,"LW.default.Set4"]
[null,"LW.default.Set5"]
[]
[null,null,null,null,null,"Sample description",null,null,null,null,"% organic N",null," Concentration"]
[null,null,null,null,null,null,null,"LWDset.start","LWDset.end","LWDset.OptSmplName",null,"LWDset.PctONavail","LWDset.TKN","LWDset.ammon","LWDset.NO3","LWDset.P","LWDset.K","LWDset.EC"]
[null,null,"set",null,null,"season or type",null,"use from start date","use to \nend date","sample notes","% total N in organic form","% of organic N available this crop","Total Kjeldahl Nitrogen\n(mg/l or ppm)","Ammonium nitrogen (mg/L)","nitrate-N (mg/L)","Phosphorus/P (mg/L)","Potassium/K (mg/L)","Electrical Conductivity\n(umhos/cm)"]
[null,{"$f":"C12&\" \"&F12","v":"LW Default Set 1 fall"},{"$f":"F$3","v":"LW Default Set 1"},{"$f":"F3","v":"LW Default Set 1"},null,"fall",null,"2010-10-01","2010-11-30","4th quarter 2009",{"$f":"IFERROR((M12-N12)/M12,0)","v":0.4},0.6,750,450]
[null,{"$f":"C13&\" \"&F13","v":"LW Default Set 1 winter"},"LW Default Set 1",null,null,"winter",null,{"$f":"I12+1","v":"2010-12-01"},"2011-02-28",null,{"$f":"IFERROR((M13-N13)/M13,0)","v":0.40666666666666668},0.3,900,534]
[null,{"$f":"C14&\" \"&F14","v":"LW Default Set 1 early spring"},"LW Default Set 1",null,null,"early spring",null,{"$f":"I13+1","v":"2011-03-01"},"2011-04-15",null,0.29166666666666669,0.25,600,425]
[null,"LW Default Set 1 late spring","LW Default Set 1",null,null,"late spring",null,{"$f":"I14+1","v":"2011-04-16"},"2011-06-01",null,0.5,0.7,500,250]
[null,"LW Default Set 1 early summer","LW Default Set 1",null,null,"early summer",null,{"$f":"I15+1","v":"2011-06-02"},"2011-07-20",null,0.375,0.6,400,250]
[null,"LW Default Set 1 late summer","LW Default Set 1",null,null,"late summer",null,{"$f":"I16+1","v":"2011-07-21"},"2011-09-30",null,0.21428571428571427,0.4,350,275]
[null,"LW Default Set 1 thin","LW Default Set 1",null,null,"thin",null,null,null,null,0.21428571428571427,0.5,350,275]
[null,"LW Default Set 1 med","LW Default Set 1",null,null,"med","x",null,null,null,0.33333333333333331,0.5,450,300]
[null,"LW Default Set 1 thick","LW Default Set 1",null,null,"thick",null,null,null,null,0.5,0.5,700,350]
[null,"LW Default Set 1 v thick","LW Default Set 1",null,null,"v thick",null,null,null,null,0.6875,0.5,1600,500]
[]
[null,"2010 samples 1st quarter",{"$f":"F$4","v":"2010 samples"},{"$f":"F4","v":"2010 samples"},null,"1st quarter",null,null,null,"primary - thicker",{"$f":"IFERROR((M23-N23)/M23,0)","v":0.49295774647887325},0.5,426,216]
[null,"2010 samples 2nd quarter","2010 samples",null,null,"2nd quarter",null,null,null,"primary",{"$f":"IFERROR((M24-N24)/M24,0)","v":0.30769230769230771},0.5,390,270]
[null,"2010 samples 3rd quarter","2010 samples",null,null,"3rd quarter",null,null,null,null,0]
[null,"2010 samples 4th quarter","2010 samples",null,null,"4th quarter",null,null,null,null,0]
[null,"2010 samples ","2010 samples",null,null,null,null,null,null,null,0]
[null,"2010 samples ","2010 samples",null,null,null,null,null,null,null,0]
[null,"2010 samples ","2010 samples",null,null,null,null,null,null,null,0]
[null,"2010 samples ","2010 samples",null,null,null,null,null,null,null,0]
[null,"2010 samples ","2010 samples",null,null,null,null,null,null,null,0]
[null,"2010 samples ","2010 samples",null,null,null,null,null,null,null,0]
[]
[null,"LW set 3 fall",{"$f":"F$5","v":"LW set 3"},{"$f":"F5","v":"LW set 3"},null,"fall",null,"2011-10-01","2010-11-30",null,{"$f":"IFERROR((M34-N34)/M34,0)","v":0}]
[null,"LW set 3 winter","LW set 3",null,null,"winter",null,{"$f":"I34+1","v":"2010-12-01"},"2011-02-28",null,{"$f":"IFERROR((M35-N35)/M35,0)","v":0}]
[null,"LW set 3 early spring","LW set 3",null,null,"early spring",null,{"$f":"I35+1","v":"2011-03-01"},"2011-04-15",null,0]
[null,"LW set 3 late spring","LW set 3",null,null,"late spring",null,{"$f":"I36+1","v":"2011-04-16"},"2011-06-01",null,0]
[null,"LW set 3 early summer","LW set 3",null,null,"early summer",null,{"$f":"I37+1","v":"2011-06-02"},"2011-07-20",null,0]
[null,"LW set 3 late summer","LW set 3",null,null,"late summer",null,{"$f":"I38+1","v":"2011-07-21"},"2011-09-30",null,0]
[null,"LW set 3 thin","LW set 3",null,null,"thin",null,null,null,null,0]
[null,"LW set 3 med","LW set 3",null,null,"med",null,null,null,null,0]
[null,"LW set 3 thick","LW set 3",null,null,"thick",null,null,null,null,0]
[null,"LW set 3 v thick","LW set 3",null,null,"v thick",null,null,null,null,0]
[]
[null,"0 ",{"$f":"F$6","v":0},{"$f":"F6","v":0},null,null,null,"2011-10-01","2010-11-30",null,{"$f":"IFERROR((M45-N45)/M45,0)","v":0}]
[null,"0 ",0,null,null,null,null,{"$f":"I45+1","v":"2010-12-01"},"2011-02-28",null,{"$f":"IFERROR((M46-N46)/M46,0)","v":0}]
[null,"0 ",0,null,null,null,null,{"$f":"I46+1","v":"2011-03-01"},"2011-04-15",null,0]
[null,"0 ",0,null,null,null,null,{"$f":"I47+1","v":"2011-04-16"},"2011-06-01",null,0]
[null,"0 ",0,null,null,null,null,{"$f":"I48+1","v":"2011-06-02"},"2011-07-20",null,0]
[null,"0 ",0,null,null,null,null,{"$f":"I49+1","v":"2011-07-21"},"2011-09-30",null,0]
[null,"0 ",0,null,null,null,null,null,null,null,0]
[null,"0 ",0,null,null,null,null,null,null,null,0]
[null,"0 ",0,null,null,null,null,null,null,null,0]
[null,"0 ",0,null,null,null,null,null,null,null,0]
[]
[null,"0 ",{"$f":"F$7","v":0},{"$f":"F7","v":0},null,null,null,"2011-10-01","2010-11-30",null,{"$f":"IFERROR((M56-N56)/M56,0)","v":0}]
[null,"0 ",0,null,null,null,null,{"$f":"I56+1","v":"2010-12-01"},"2011-02-28",null,{"$f":"IFERROR((M57-N57)/M57,0)","v":0}]
[null,"0 ",0,null,null,null,null,{"$f":"I57+1","v":"2011-03-01"},"2011-04-15",null,0]
[null,"0 ",0,null,null,null,null,{"$f":"I58+1","v":"2011-04-16"},"2011-06-01",null,0]
[null,"0 ",0,null,null,null,null,{"$f":"I59+1","v":"2011-06-02"},"2011-07-20",null,0]
[null,"0 ",0,null,null,null,null,{"$f":"I60+1","v":"2011-07-21"},"2011-09-30",null,0]
[null,"0 ",0,null,null,null,null,null,null,null,0]
[null,"0 ",0,null,null,null,null,null,null,null,0]
[null,"0 ",0,null,null,null,null,null,null,null,0]
[null,"0 ",0,null,null,null,null,null,null,null,0]

{"sheet":"field sheet","index":2,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":true,"merged":[[0,6,0,8]]}
["Target gpm field sheet for flow meters ",null,"My Dairy",2011,null,null,"University of California Cooperative Extension v 5-10-11"]
["2011-05-01","summer","main lagoon",{"$f":"SUM(B41:K41)","v":1815.6399222906111},"Kgals needed"]
[]
["location","Field 1","Field 2","Field 3","Field 4","Field 5"]
["acres",32,25,30,20,18]
["irrig num","pre","pre","pre","pre","pre"]
[]
["expected run time (hours)",13,9,12.8,8.5,9]
[]
["target lbs/ac available N",40,40,40,40,40]
["lbs/ac total N applied",{"$f":"IF(AND(B10>0,B14>0),B10/(B19/B14),0)","v":47.272727272727273},47.272727272727273,47.272727272727273,47.272727272727273,47.272727272727273,0,0,0,0,0,0]
[]
["sample name","2010 samples 2nd quarter","2010 samples 2nd quarter","2010 samples 2nd quarter","2010 samples 2nd quarter","2010 samples 2nd quarter"]
["TKN-N (mg/L)",390,390,390,390,390]
["ammonium-N (mg/L)",270,270,270,270,270]
["% organic-N ",{"$f":"IF(ISERROR((B14-B15)/B14),0,(B14-B15)/B14)","v":0.30769230769230771},{"$f":"IF(ISERROR((C14-C15)/C14),0,(C14-C15)/C14)","v":0.30769230769230771},0.30769230769230771,0.30769230769230771,0.30769230769230771,0,0,0,{"$f":"IF(ISERROR((J14-J15)/J14),0,(J14-J15)/J14)","v":0},{"$f":"IF(ISERROR((K14-K15)/K14),0,(K14-K15)/K14)","v":0},{"$f":"IF(ISERROR((L14-L15)/L14),0,(L14-L15)/L14)","v":0}]
["% org-N available",0.5,0.5,0.5,0.5,0.5]
[]
["mg/L available N",{"$f":"B15+((B14-B15)*B17)","v":330},330,330,330,330,0,0,0,0,0,0]
[]
["Target GPM",{"$f":"IF(B35=0,0,IF(OR(B35>B36,B35=B36),B35,B36))","v":595.90233346973912},672.4592304780042,567.38747571581609,569.61252464019185,484.17064594416303,0,0,0,0,0,0]
["target hours",{"$f":"IF(B52,\"\",CONCATENATE(INT(B51),\" hrs \",ROUND((B51-INT(B51))*60,0),\" mins\"))","v":"13 hrs 0 mins"},{"$f":"IF(C52,\"\",CONCATENATE(INT(C51),\" hrs \",ROUND((C51-INT(C51))*60,0),\" mins\"))","v":"9 hrs 0 mins"},"12 hrs 48 mins","8 hrs 30 mins","9 hrs 0 mins","","","","","",""]
["LW % of run time",{"$f":"IF(B8>0,B51/B8,0)","v":1},1,1,1,1,0,0,0,0,0,0]
["Velocity (ft/sec)",{"$f":"IF(B50>0,B21/(B50*448.83),0)","v":2.4354882785729077},2.748380869917344,2.318946358992759,2.3280402662829269,1.9788342263404877,0,0,0,0,0,0]
[]
["Application Rate Quick Calculator",{"$f":"IF(B4=\"\",\"\",B4)","v":"Field 1"},{"$f":"IF(C4=\"\",\"\",C4)","v":"Field 2"},{"$f":"IF(D4=\"\",\"\",D4)","v":"Field 3"},"Field 4","Field 5","","","","","",""]
[]
["actual GPM"]
["actual hours"]
["applied available N/acre",{"$f":"IF(AND(B19>0,B5>0),((B28*B29*60)/1000*B19*0.008345)/B5,0)","v":0},0,0,0,0,0,0,0,0,0,0]
["applied total N/acre",{"$f":"IF(AND(B19>0,B5>0),((B28*B29*60)/1000*B14*0.008345)/B5,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
["Pump and Pipeline Parameters"]
["calculated GPM",{"$f":"IF(AND(B19>0,B8>0),((B10*B5)/(B19*0.008345)*1000)/(B8*60),0)","v":595.90233346973912},672.4592304780042,567.38747571581609,569.61252464019185,484.17064594416303,0,0,0,0,0,0]
["mimimum GPM",400,400,400,400,400,400,400,400,400,400,400]
["pipe inside diameter (in.)",10,10,10,10,10,10,10,10,10,10,10]
["minimum velocity (f/s)",2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998]
[]
[]
["thousand gallons needed",{"$f":"IF(AND(B11>0,B5>0,B14>0),(B11/(B14*0.008345))*B5,0)","v":464.80382010639647},363.12798445812223,435.7535813497467,290.50238756649782,261.45214880984804,0,0,0,0,0,0]
["acre-inches pre acre",{"$f":"IF(B5>0,(B41/27.1542856)/B5,0)","v":0.53491075376790209},{"$f":"IF(C5>0,(C41/27.1542856)/C5,0)","v":0.53491075376790209},0.53491075376790198,0.53491075376790209,0.53491075376790209,0,0,0,0,{"$f":"IF(K5>0,(K41/27.1542856)/K5,0)","v":0},{"$f":"IF(L5>0,(L41/27.1542856)/L5,0)","v":0}]
[]
[]
[]
[]
[]
["run time at minimum gpm (hrs)",{"$f":"IF(AND(B19>0,B36>0),((B10*B5)/(B19*0.008345/1000)/B36)/60,0)","v":19.36682583776652},15.130332685755095,18.156399222906114,12.104266148604076,10.893839533743668,0,0,0,0,0,0]
["min/acre",{"$f":"IF(B5>0,(B8*60)/B5,0)","v":24.375},21.6,25.6,25.5,30,0,0,0,0,0,0]
["pipe ID sq ft",{"$f":"(((B37/2)*(B37/2))*3.14)/144","v":0.54513888888888884},0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884,0.54513888888888884]
["target hours",{"$f":"IF(B$48<B$8,B$48,B$8)","v":13},9,12.8,8.5,9,0,0,0,0,0,0]
["empty",{"$f":"IF(B51>0,FALSE,TRUE)","v":false},{"$f":"IF(C51>0,FALSE,TRUE)","v":false},false,false,false,true,true,true,true,true,true]

{"sheet":"datasheet ","index":3,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[7,15,8,15],[7,10,8,10],[11,1,12,1],[11,5,12,5],[11,8,12,8],[11,11,12,11],[11,12,12,12],[7,11,8,11],[7,12,8,12],[7,13,8,13],[7,14,8,14],[7,1,8,2],[29,1,30,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[13,2,14,2],[13,3,14,3],[13,4,14,4],[17,2,18,2],[13,1,14,1],[15,1,16,1],[17,1,18,1],[19,1,20,1],[21,1,22,1],[23,1,24,1],[29,2,30,2],[29,3,30,3],[29,4,30,4],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,8,16,8],[25,1,26,1],[27,1,28,1],[21,8,22,8],[23,2,24,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[23,8,24,8],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,8,18,8],[19,2,20,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[19,8,20,8],[29,5,30,5],[29,8,30,8],[11,10,12,10],[17,10,18,10],[19,10,20,10],[21,10,22,10],[23,10,24,10],[25,2,26,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[25,8,26,8],[27,2,28,2],[27,3,28,3],[27,4,28,4],[27,5,28,5],[27,8,28,8],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[13,5,14,5],[13,8,14,8],[15,2,16,2],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[15,15,16,15],[15,16,16,16],[11,13,12,13],[11,14,12,14],[11,15,12,15],[11,16,12,16],[13,10,14,10],[13,11,14,11],[13,12,14,12],[13,13,14,13],[13,14,14,14],[13,15,14,15],[19,11,20,11],[19,12,20,12],[19,13,20,13],[19,14,20,14],[19,15,20,15],[19,16,20,16],[17,11,18,11],[17,12,18,12],[17,13,18,13],[17,14,18,14],[17,15,18,15],[17,16,18,16],[23,11,24,11],[23,12,24,12],[23,13,24,13],[23,14,24,14],[23,15,24,15],[23,16,24,16],[21,11,22,11],[21,12,22,12],[21,13,22,13],[21,14,22,14],[21,15,22,15],[21,16,22,16],[29,16,30,16],[29,10,30,10],[29,11,30,11],[29,12,30,12],[29,13,30,13],[29,14,30,14],[29,15,30,15],[25,16,26,16],[27,10,28,10],[27,11,28,11],[27,12,28,12],[27,13,28,13],[27,14,28,14],[27,15,28,15],[27,16,28,16],[25,10,26,10],[25,11,26,11],[25,12,26,12],[25,13,26,13],[25,14,26,14],[25,15,26,15],[29,17,30,17],[29,18,30,18],[11,17,12,17],[11,18,12,18],[13,17,14,17],[13,18,14,18],[15,17,16,17],[15,18,16,18],[17,17,18,17],[17,18,18,18],[19,17,20,17],[19,18,20,18],[8,16,9,18],[21,17,22,17],[21,18,22,18],[23,17,24,17],[23,18,24,18],[25,17,26,17],[25,18,26,18],[27,17,28,17],[27,18,28,18],[13,16,14,16]]}
[]
[null,"Irrigation Data Sheet"]
[]
[null,{"$f":"targets!B4","v":"My Dairy"},null,null,null,null,null,null,null,null,"date"]
[null,{"$f":"targets!E3","v":"2011-06-01"},null,null,null,null,null,null,null,null,"rainfall"]
[]
[null,"source:",null,null,null,null,null,null,null,null,"concentrations","total N","NH4-N","Org-N","% avail","Avail N"]
[null,{"$f":"targets!J3","v":"primary lagoon"},null,null,null,null,null,null,null,null,"expected (mg/L)",{"$f":"targets!D16","v":0},{"$f":"targets!D17","v":0},{"$f":"mrs.total_N-M8","v":0},{"$f":"targets!D19","v":0},{"$f":"targets!D21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," standing water"]
[]
[null,"Location"," acres"," Irrigation\n number","Target\n N\nlbs/A",null,null,null,"Target gpm",null,"Location Start Date/Time","Location End Date/Time","Meter Start (total gallons)","Meter End (total gallons)","Average observed gpm","Fresh Water Source(s)"," day before"," day after","irrigator initials\n& notes"]
[null,{"$f":"targets!D$6","v":0},{"$f":"targets!D$7","v":0},{"$f":"targets!D$8","v":0},{"$f":"targets!D$12","v":0},{"$f":"HoursMinutes(targets!D$10)","v":""},null,{"$f":"HoursMinutes(targets!D$57)","v":""},{"$f":"MROUND(targets!D$23,5)","v":0}]
[null,null,null,null,null,null,null,{"$f":"targets!D$25","v":0}]
[null,{"$f":"targets!E$6","v":0},{"$f":"targets!E$7","v":0},{"$f":"targets!E$8","v":0},{"$f":"targets!E$12","v":0},{"$f":"HoursMinutes(targets!E$10)","v":""},null,{"$f":"HoursMinutes(targets!E$57)","v":""},{"$f":"MROUND(targets!E$23,5)","v":0}]
[null,null,null,null,null,null,null,{"$f":"targets!E$25","v":0}]
[null,{"$f":"targets!F$6","v":0},{"$f":"targets!F$7","v":0},{"$f":"targets!F$8","v":0},{"$f":"targets!F$12","v":0},{"$f":"HoursMinutes(targets!F$10)","v":""},null,{"$f":"HoursMinutes(targets!F$57)","v":""},{"$f":"MROUND(targets!F$23,5)","v":0}]
[null,null,null,null,null,null,null,{"$f":"targets!F$25","v":0}]
[null,{"$f":"targets!G$6","v":0},{"$f":"targets!G$7","v":0},{"$f":"targets!G$8","v":0},{"$f":"targets!G$12","v":0},{"$f":"HoursMinutes(targets!G$10)","v":""},null,{"$f":"HoursMinutes(targets!G$57)","v":""},{"$f":"MROUND(targets!G$23,5)","v":0}]
[null,null,null,null,null,null,null,{"$f":"targets!G$25","v":0}]
[null,{"$f":"targets!H$6","v":0},{"$f":"targets!H$7","v":0},{"$f":"targets!H$8","v":0},{"$f":"targets!H$12","v":0},{"$f":"HoursMinutes(targets!H$10)","v":""},null,{"$f":"HoursMinutes(targets!H$57)","v":""},{"$f":"MROUND(targets!H$23,5)","v":0}]
[null,null,null,null,null,null,null,{"$f":"targets!H$25","v":0}]
[null,{"$f":"targets!I$6","v":0},{"$f":"targets!I$7","v":0},{"$f":"targets!I$8","v":0},{"$f":"targets!I$12","v":0},{"$f":"HoursMinutes(targets!I$10)","v":""},null,{"$f":"HoursMinutes(targets!I$57)","v":""},{"$f":"MROUND(targets!I$23,5)","v":0}]
[null,null,null,null,null,null,null,{"$f":"targets!I$25","v":0}]
[null,{"$f":"targets!J$6","v":0},{"$f":"targets!J$7","v":0},{"$f":"targets!J$8","v":0},{"$f":"targets!J$12","v":0},{"$f":"HoursMinutes(targets!J$10)","v":""},null,{"$f":"HoursMinutes(targets!J$57)","v":""},{"$f":"MROUND(targets!J$23,5)","v":0}]
[null,null,null,null,null,null,null,{"$f":"targets!J$25","v":0}]
[null,{"$f":"targets!K$6","v":0},{"$f":"targets!K$7","v":0},{"$f":"targets!K$8","v":0},{"$f":"targets!K$12","v":0},{"$f":"HoursMinutes(targets!K$10)","v":""},null,{"$f":"HoursMinutes(targets!K$57)","v":""},{"$f":"MROUND(targets!K$23,5)","v":0}]
[null,null,null,null,null,null,null,{"$f":"targets!K$25","v":0}]
[null,{"$f":"targets!L$6","v":0},{"$f":"targets!L$7","v":0},{"$f":"targets!L$8","v":0},{"$f":"targets!L$12","v":0},{"$f":"HoursMinutes(targets!L$10)","v":""},null,{"$f":"HoursMinutes(targets!L$57)","v":""},{"$f":"MROUND(targets!L$23,5)","v":0}]
[null,null,null,null,null,null,null,{"$f":"targets!L$25","v":0}]
[null,{"$f":"targets!M$6","v":0},{"$f":"targets!M$7","v":0},{"$f":"targets!M$8","v":0},{"$f":"targets!M$12","v":0},{"$f":"HoursMinutes(targets!M$10)","v":""},null,{"$f":"HoursMinutes(targets!M$57)","v":""},{"$f":"MROUND(targets!M$23,5)","v":0}]
[null,null,null,null,null,null,null,{"$f":"targets!M$25","v":0}]