{"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":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":"targets","index":0,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":false,"merged":[[2,9,2,10],[3,9,3,10],[3,13,4,13]]}
[null,null,null,"Target run time calculator for flow rate",null,null,null,null,null,"v 6-26-11 University of California Cooperative Extension mcmathews@ucdavis.edu"]
[]
[null,null,null,null,"2011-06-01","date",null,null,"source lagoon:","main lagoon"]
[null,"My Dairy Farm",null,2011,"summer","season",null,null,"thousand gallons needed:",{"$f":"SUM(D35:M35)","v":0},null,null,null,"extra location"]
[]
[null,"Location"]
[null,"Acres"]
[null,"Irrigation number"]
[]
[null,"Expected total run time (hrs)"]
[null,"Expected GPM"]
[]
[null,"Target lbs/A available N"]
[null,"Total N applied (lbs/A)",null,{"$f":"IF(AND(D13>0,D25>0),D13/(D25/D20),0)","v":0},{"$f":"IF(AND(E13>0,E25>0),E13/(E25/E20),0)","v":0},0,0,0,0,0,0,0,{"$f":"IF(AND(M13>0,M25>0),M13/(M25/M20),0)","v":0},{"$f":"IF(AND(N13>0,N25>0),N13/(N25/N20),0)","v":0}]
[]
[null,"Avail N lbs/A @ 100% run",null,{"$f":"IF(AND(D25>0,D7>0),(((D11*D10*60)/1000)*D25*0.008345)/D7,0)","v":0},{"$f":"IF(AND(E25>0,E7>0),(((E11*E10*60)/1000)*E25*0.008345)/E7,0)","v":0},0,0,0,0,0,0,0,{"$f":"IF(AND(M25>0,M7>0),(((M11*M10*60)/1000)*M25*0.008345)/M7,0)","v":0},{"$f":"IF(AND(N25>0,N7>0),(((N11*N10*60)/1000)*N25*0.008345)/N7,0)","v":0}]
[null,"Total N lbs/A @ 100% run",null,{"$f":"IF(AND(D25>0,D7>0),((D11*D10*60)/1000*D20*0.008345)/D7,0)","v":0},{"$f":"IF(AND(E25>0,E7>0),((E11*E10*60)/1000*E20*0.008345)/E7,0)","v":0},0,0,0,0,0,0,0,{"$f":"IF(AND(M25>0,M7>0),((M11*M10*60)/1000*M20*0.008345)/M7,0)","v":0},{"$f":"IF(AND(N25>0,N7>0),((N11*N10*60)/1000*N20*0.008345)/N7,0)","v":0}]
[]
[null,"Sample name"]
[null,"TKN-N (mg/L)"]
[null,"Ammonium-N (mg/L)"]
[null,"% organic-N ",null,{"$f":"IF(D20>0,(D20-D21)/D20,0)","v":0},{"$f":"IF(E20>0,(E20-E21)/E20,0)","v":0},0,0,0,0,0,0,0,{"$f":"IF(M20>0,(M20-M21)/M20,0)","v":0},{"$f":"IF(N20>0,(N20-N21)/N20,0)","v":0}]
[null,"% org-N available"]
[]
[null," Available N (mg/L)",null,{"$f":"IF(D23>0,D21+((D20-D21)*D23),D21)","v":0},{"$f":"IF(E23>0,E21+((E20-E21)*E23),E21)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Lagoon only run time",null,{"$f":"IF(D61>0,HoursMinutes(D61),\"\")","v":""},{"$f":"IF(E61>0,HoursMinutes(E61),\"\")","v":""},{"$f":"IF(F61>0,HoursMinutes(F61),\"\")","v":""},{"$f":"IF(G61>0,HoursMinutes(G61),\"\")","v":""},{"$f":"IF(H61>0,HoursMinutes(H61),\"\")","v":""},{"$f":"IF(I61>0,HoursMinutes(I61),\"\")","v":""},{"$f":"IF(J61>0,HoursMinutes(J61),\"\")","v":""},{"$f":"IF(K61>0,HoursMinutes(K61),\"\")","v":""},{"$f":"IF(L61>0,HoursMinutes(L61),\"\")","v":""},{"$f":"IF(M61>0,HoursMinutes(M61),\"\")","v":""},{"$f":"IF(N61>0,HoursMinutes(N61),\"\")","v":""}]
[null,"LW % of total run time",null,{"$f":"IF(D10>0,D61/D10,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"Needed GPM at desired run time",null,{"$f":"IF(AND(D25>0,D10>0),((D13*D7)/(D25*0.008345)*1000)/(D10*60),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Needed run time at actual GPM",null,{"$f":"IF(AND(D25>0,D11>0),((D13*D7)/(D25*0.008345/1000)/D11)/60,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"Velocity (ft/sec)",null,{"$f":"IF(D63>0,D11/(D63*448.83),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"thousand gallons at desired rate",null,{"$f":"IF(AND(D14>0,D7>0,D20>0),(D14/(D20*0.008345))*D7,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"acre-inches pre acre",null,{"$f":"IF(D7>0,(D35/27.1542856)/D7,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,"Application Rate Quick Calculator"]
[]
[null,"actual GPM"]
[null,"actual hours"]
[null,"applied available N/acre",null,{"$f":"IF(AND(D25>0,D7>0),((D40*D41*60)/1000*D25*0.008345)/D7,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"applied total N/acre",null,{"$f":"IF(AND(D25>0,D7>0),((D40*D41*60)/1000*D20*0.008345)/D7,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Pump and Pipeline Parameters"]
[null,"Pipe inside diameter (in.)",null,12,12,12,12,12,12,12,12,12,12,12]
[null,"minimum velocity (f/s)",null,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998,2.2999999999999998]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"lagoon run time",null,{"$f":"IF(D$32<D$10,D$32,D$10)","v":0},{"$f":"IF(E$32<E$10,E$32,E$10)","v":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},0,0,0,0,0,0,0,0,0]
[null,"pipe ID sq ft","fall",{"$f":"(((D47/2)*(D47/2))*3.14)/144","v":0.78500000000000003},0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003]

{"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 qrtly"]
[null,"LW.default.Set3",null,null,null,"LW default 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":"(M12-N12)/M12","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":"(M13-N13)/M13","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,{"$f":"(M14-N14)/M14","v":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 qrtly 1st quarter",{"$f":"F$4","v":"2010 qrtly"},{"$f":"F4","v":"2010 qrtly"},null,"1st quarter"]
[null,"2010 qrtly 2nd quarter","2010 qrtly",null,null,"2nd quarter"]
[null,"2010 qrtly 3rd quarter","2010 qrtly",null,null,"3rd quarter"]
[null,"2010 qrtly 4th quarter","2010 qrtly",null,null,"4th quarter"]
[null,"2010 qrtly ","2010 qrtly"]
[null,"2010 qrtly ","2010 qrtly"]
[null,"2010 qrtly ","2010 qrtly"]
[null,"2010 qrtly ","2010 qrtly"]
[null,"2010 qrtly ","2010 qrtly"]
[null,"2010 qrtly ","2010 qrtly"]
[]
[null,"LW default set 3 fall",{"$f":"F$5","v":"LW default set 3"},{"$f":"F5","v":"LW default set 3"},null,"fall",null,"2011-10-01","2010-11-30"]
[null,"LW default set 3 winter","LW default set 3",null,null,"winter",null,{"$f":"I34+1","v":"2010-12-01"},"2011-02-28"]
[null,"LW default set 3 early spring","LW default set 3",null,null,"early spring",null,{"$f":"I35+1","v":"2011-03-01"},"2011-04-15"]
[null,"LW default set 3 late spring","LW default set 3",null,null,"late spring",null,{"$f":"I36+1","v":"2011-04-16"},"2011-06-01"]
[null,"LW default set 3 early summer","LW default set 3",null,null,"early summer",null,{"$f":"I37+1","v":"2011-06-02"},"2011-07-20"]
[null,"LW default set 3 late summer","LW default set 3",null,null,"late summer",null,{"$f":"I38+1","v":"2011-07-21"},"2011-09-30"]
[null,"LW default set 3 thin","LW default set 3",null,null,"thin"]
[null,"LW default set 3 med","LW default set 3",null,null,"med"]
[null,"LW default set 3 thick","LW default set 3",null,null,"thick"]
[null,"LW default set 3 v thick","LW default set 3",null,null,"v thick"]
[]
[null,"0 ",{"$f":"F$6","v":0},{"$f":"F6","v":0},null,null,null,"2011-10-01","2010-11-30"]
[null,"0 ",0,null,null,null,null,{"$f":"I45+1","v":"2010-12-01"},"2011-02-28"]
[null,"0 ",0,null,null,null,null,{"$f":"I46+1","v":"2011-03-01"},"2011-04-15"]
[null,"0 ",0,null,null,null,null,{"$f":"I47+1","v":"2011-04-16"},"2011-06-01"]
[null,"0 ",0,null,null,null,null,{"$f":"I48+1","v":"2011-06-02"},"2011-07-20"]
[null,"0 ",0,null,null,null,null,{"$f":"I49+1","v":"2011-07-21"},"2011-09-30"]
[null,"0 ",0]
[null,"0 ",0]
[null,"0 ",0]
[null,"0 ",0]
[]
[null,"0 ",{"$f":"F$7","v":0},{"$f":"F7","v":0},null,null,null,"2011-10-01","2010-11-30"]
[null,"0 ",0,null,null,null,null,{"$f":"I56+1","v":"2010-12-01"},"2011-02-28"]
[null,"0 ",0,null,null,null,null,{"$f":"I57+1","v":"2011-03-01"},"2011-04-15"]
[null,"0 ",0,null,null,null,null,{"$f":"I58+1","v":"2011-04-16"},"2011-06-01"]
[null,"0 ",0,null,null,null,null,{"$f":"I59+1","v":"2011-06-02"},"2011-07-20"]
[null,"0 ",0,null,null,null,null,{"$f":"I60+1","v":"2011-07-21"},"2011-09-30"]
[null,"0 ",0]
[null,"0 ",0]
[null,"0 ",0]
[null,"0 ",0]

{"sheet":"field sheet","index":2,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":true,"merged":[[1,2,1,3]]}
["Target run time field sheet for flow rate",null,"My Dairy Farm",2011,null,null,null,"v 5-10-11 University of California Cooperative Extension mcmathews@ucdavis.edu"]
["2011-06-01","summer","main lagoon",null,{"$f":"SUM(B36:K36)","v":1550.7700983329223},"Kgals needed"]
[]
["Location","Field 1","Field 2","Field 3","Field 4","Field 5"]
["acres",20,20,20,30,20]
["irrig num",1,1,1,1,1]
[]
["expected total run time (hrs)",9,8,8,13,8]
["expected GPM",1000,950,900,850,800]
[]
["target lbs/ac available N",40,40,40,40,40]
["lbs/ac total N applied",{"$f":"IF(AND(B11>0,B23>0),B11/(B23/B18),0)","v":47.058823529411768},{"$f":"IF(AND(C11>0,C23>0),C11/(C23/C18),0)","v":47.058823529411768},47.058823529411768,47.058823529411768,47.058823529411768,0,0,0,0,0,0]
[]
["avail N lbs/A @ 100% run",{"$f":"IF(AND(B23>0,B5>0),(((B9*B8*60)/1000)*B23*0.008345)/B5,0)","v":76.607100000000003},{"$f":"IF(AND(C23>0,C5>0),(((C9*C8*60)/1000)*C23*0.008345)/C5,0)","v":64.690439999999995},61.285679999999999,62.704329999999999,54.476160000000007,0,0,0,0,0,0]
["total N lbs/A @ 100% run",{"$f":"IF(AND(B23>0,B5>0),((B9*B8*60)/1000*B18*0.008345)/B5,0)","v":90.126000000000005},{"$f":"IF(AND(C23>0,C5>0),((C9*C8*60)/1000*C18*0.008345)/C5,0)","v":76.106399999999994},72.100800000000007,73.769800000000004,64.08959999999999,0,0,0,0,0,0]
[]
["sample name","LW default set 1 early summer","LW default set 1 early summer","LW default set 1 early summer","LW default set 1 early summer","LW default set 1 early summer"]
["TKN-N (mg/L)",400,400,400,400,400]
["ammonium-N (mg/L)",250,250,250,250,250]
["% organic-N ",{"$f":"IF(B18>0,(B18-B19)/B18,0)","v":0.375},{"$f":"IF(C18>0,(C18-C19)/C18,0)","v":0.375},0.375,0.375,0.375,0,0,0,0,0,0]
["% org-N available",0.6,0.6,0.6,0.6,0.6]
[]
["mg/L available N",{"$f":"IF(B21>0,B19+((B18-B19)*B21),B19)","v":340},{"$f":"IF(C21>0,C19+((C18-C19)*C21),C19)","v":340},340,340,340,0,0,0,0,0,0]
[]
["lagoon run time",{"$f":"IF(B54,\"\",CONCATENATE(INT(B43),\" hrs \",ROUND((B43-INT(B43))*60,0),\" mins\"))","v":"4 hrs 42 mins"},{"$f":"IF(C54,\"\",CONCATENATE(INT(C43),\" hrs \",ROUND((C43-INT(C43))*60,0),\" mins\"))","v":"4 hrs 57 mins"},{"$f":"IF(D54,\"\",CONCATENATE(INT(D43),\" hrs \",ROUND((D43-INT(D43))*60,0),\" mins\"))","v":"5 hrs 13 mins"},"8 hrs 18 mins","5 hrs 52 mins","","","","","",""]
["LW % of total run time",{"$f":"IF(B8>0,B43/B8,0)","v":0.52214481425350912},0.6183293853002082,0.65268101781688637,0.63791447895225106,0.73426614504399723,0,0,0,0,0,0]
["Application Rate Quick Calculator"]
[]
["actual GPM",0,0,0,0,0,0,0,0,0,0,0]
["actual hours",0,0,0,0,0,0,0,0,0,0,0]
["applied available N/acre",{"$f":"IF(AND(B23>0,B5>0),((B29*B30*60)/1000*B23*0.008345)/B5,0)","v":0},{"$f":"IF(AND(C23>0,C5>0),((C29*C30*60)/1000*C23*0.008345)/C5,0)","v":0},0,0,0,0,0,0,0,0,0]
["applied total N/acre",{"$f":"IF(AND(B23>0,B5>0),((B29*B30*60)/1000*B18*0.008345)/B5,0)","v":0},{"$f":"IF(AND(C23>0,C5>0),((C29*C30*60)/1000*C18*0.008345)/C5,0)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
["Velocity (ft/sec)",{"$f":"IF(B53>0,B9/(B53*448.83),0)","v":2.8382357469832038},{"$f":"IF(C53>0,C9/(C53*448.83),0)","v":2.6963239596340438},2.5544121722848834,2.4125003849357234,2.270588597586563,0,0,0,0,0,0]
["thousand gallons at desired rate",{"$f":"IF(AND(B12>0,B5>0,B18>0),(B12/(B18*0.008345))*B5,0)","v":281.95819969689495},{"$f":"IF(AND(C12>0,C5>0,C18>0),(C12/(C18*0.008345))*C5,0)","v":281.95819969689495},281.95819969689495,422.9372995453424,281.95819969689495,0,0,0,0,0,0]
["acre-inches pre acre",{"$f":"IF(B5>0,(B36/27.1542856)/B5,0)","v":0.51917808453943448},{"$f":"IF(C5>0,(C36/27.1542856)/C5,0)","v":0.51917808453943448},0.51917808453943448,0.51917808453943437,0.51917808453943448,0,0,0,0,0,0]
[]
["Pump and Pipeline Parameters"]
["Pipe inside diameter (in.)",12,12,12,12,12,12,12,12,12,12,12]
["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]
[]
["calculateded lagoon run time",{"$f":"IF(B$45<B$8,B$45,B$8)","v":4.6993033282815819},4.9466350824016656,5.2214481425350909,8.2928882263792634,5.8741291603519779,0,0,0,0,0,0]
["Needed GPM at desired run time",{"$f":"IF(AND(B23>0,B8>0),((B11*B5)/(B23*0.008345)*1000)/(B8*60),0)","v":522.14481425350925},{"$f":"IF(AND(C23>0,C8>0),((C11*C5)/(C23*0.008345)*1000)/(C8*60),0)","v":587.4129160351979},587.4129160351979,542.22730710941335,587.4129160351979,0,0,0,0,0,0]
["Needed run time at actual GPM",{"$f":"IF(AND(B23>0,B9>0),((B11*B5)/(B23*0.008345/1000)/B9)/60,0)","v":4.6993033282815819},{"$f":"IF(AND(C23>0,C9>0),((C11*C5)/(C23*0.008345/1000)/C9)/60,0)","v":4.9466350824016656},5.2214481425350909,8.2928882263792634,5.8741291603519779,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
["minutes/acre",{"$f":"IF(B5>0,(B8*60)/B5,0)","v":27},24,24,26,24,0,0,0,0,0,0]
["pipe ID sq ft",{"$f":"(((B40/2)*(B40/2))*3.14)/144","v":0.78500000000000003},0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003,0.78500000000000003]
["empty location",{"$f":"IF(B43>0,FALSE,TRUE)","v":false},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":[[4,1,4,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[11,3,12,3],[11,4,12,4],[11,6,12,6],[13,3,14,3],[13,4,14,4],[13,5,14,5],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[23,3,24,3],[23,4,24,4],[23,6,24,6],[17,3,18,3],[17,4,18,4],[17,6,18,6],[19,3,20,3],[19,4,20,4],[19,6,20,6],[17,5,18,5],[7,15,8,15],[7,10,8,10],[11,1,12,1],[11,5,12,5],[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,1],[29,1,30,1],[11,2,12,2],[13,2,14,2],[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],[25,1,26,1],[27,1,28,1],[23,2,24,2],[19,2,20,2],[25,2,26,2],[15,2,16,2],[19,5,20,5],[21,5,22,5],[23,5,24,5],[25,5,26,5],[29,6,30,6],[11,10,12,10],[17,10,18,10],[19,10,20,10],[21,10,22,10],[23,10,24,10],[13,6,14,6],[27,5,28,5],[25,3,26,3],[25,4,26,4],[25,6,26,6],[27,2,28,2],[27,3,28,3],[27,4,28,4],[27,6,28,6],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,6,22,6],[13,18,14,18],[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,18,16,18],[11,13,12,13],[11,14,12,14],[11,15,12,15],[11,18,12,18],[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,18,20,18],[17,11,18,11],[17,12,18,12],[17,13,18,13],[17,14,18,14],[17,15,18,15],[17,18,18,18],[23,11,24,11],[23,12,24,12],[23,13,24,13],[23,14,24,14],[23,15,24,15],[23,18,24,18],[21,11,22,11],[21,12,22,12],[21,13,22,13],[21,14,22,14],[21,15,22,15],[21,18,22,18],[29,18,30,18],[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,18,26,18],[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,18,28,18],[25,10,26,10],[25,11,26,11],[25,12,26,12],[25,13,26,13],[25,14,26,14],[25,15,26,15]]}
[]
[null,"Irrigation Data Sheet"]
[]
[null,{"$f":"targets!B4","v":"My Dairy Farm"},null,null,null,null,null,null,null,null,"date",null,null,null,null,null,null,null,"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     "]
[null,{"$f":"targets!E3","v":"2011-06-01"},null,null,null,null,null,null,null,null,"weather"]
[]
[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":"main lagoon"},null,null,null,null,null,null,null,null,"expected (mg/L)",{"$f":"targets!D20","v":0},{"$f":"targets!D21","v":0},{"$f":"mrs.total_N-M8","v":0},{"$f":"targets!D23","v":0},{"$f":"targets!D25","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 avail N lbs/A","Expect-\ned gpm",null,null,null,null,"Location Start Date/Time","Location End Date/Time","Starting Pond Level","Ending Pond Level","Estimated gpm","Fresh Water Source(s)"," day before"," day after","irrigator initials & notes"]
[null,{"$f":"targets!D$6","v":0},{"$f":"targets!D$7","v":0},{"$f":"targets!D$8","v":0},{"$f":"targets!D$13","v":0},{"$f":"cell.targets.expectedGPM1","v":0},{"$f":"HoursMinutes(targets!D$10)","v":""},null,{"$f":"HoursMinutes(targets!D$61)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"targets!D$29","v":0}]
[null,{"$f":"targets!E$6","v":0},{"$f":"targets!E$7","v":0},{"$f":"targets!E$8","v":0},{"$f":"targets!E$13","v":0},{"$f":"targets!E$11","v":0},{"$f":"HoursMinutes(targets!E$10)","v":""},null,{"$f":"HoursMinutes(targets!E$61)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"targets!E$29","v":0}]
[null,{"$f":"targets!F$6","v":0},{"$f":"targets!F$7","v":0},{"$f":"targets!F$8","v":0},{"$f":"targets!F$13","v":0},{"$f":"targets!F$11","v":0},{"$f":"HoursMinutes(targets!F$10)","v":""},null,{"$f":"HoursMinutes(targets!F$61)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"targets!F$29","v":0}]
[null,{"$f":"targets!G$6","v":0},{"$f":"targets!G$7","v":0},{"$f":"targets!G$8","v":0},{"$f":"targets!G$13","v":0},{"$f":"targets!G$11","v":0},{"$f":"HoursMinutes(targets!G$10)","v":""},null,{"$f":"HoursMinutes(targets!G$61)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"targets!G$29","v":0}]
[null,{"$f":"targets!H$6","v":0},{"$f":"targets!H$7","v":0},{"$f":"targets!H$8","v":0},{"$f":"targets!H$13","v":0},{"$f":"targets!H$11","v":0},{"$f":"HoursMinutes(targets!H$10)","v":""},null,{"$f":"HoursMinutes(targets!H$61)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"targets!H$29","v":0}]
[null,{"$f":"targets!I$6","v":0},{"$f":"targets!I$7","v":0},{"$f":"targets!I$8","v":0},{"$f":"targets!I$13","v":0},{"$f":"targets!I$11","v":0},{"$f":"HoursMinutes(targets!I$10)","v":""},null,{"$f":"HoursMinutes(targets!I$61)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"targets!I$29","v":0}]
[null,{"$f":"targets!J$6","v":0},{"$f":"targets!J$7","v":0},{"$f":"targets!J$8","v":0},{"$f":"targets!J$13","v":0},{"$f":"targets!J$11","v":0},{"$f":"HoursMinutes(targets!J$10)","v":""},null,{"$f":"HoursMinutes(targets!J$61)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"targets!J$29","v":0}]
[null,{"$f":"targets!K$6","v":0},{"$f":"targets!K$7","v":0},{"$f":"targets!K$8","v":0},{"$f":"targets!K$13","v":0},{"$f":"targets!K$11","v":0},{"$f":"HoursMinutes(targets!K$10)","v":""},null,{"$f":"HoursMinutes(targets!K$61)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"targets!K$29","v":0}]
[null,{"$f":"targets!L$6","v":0},{"$f":"targets!L$7","v":0},{"$f":"targets!L$8","v":0},{"$f":"targets!L$13","v":0},{"$f":"targets!L$11","v":0},{"$f":"HoursMinutes(targets!L$10)","v":""},null,{"$f":"HoursMinutes(targets!L$61)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"targets!L$29","v":0}]
[null,{"$f":"targets!M$6","v":0},{"$f":"targets!M$7","v":0},{"$f":"targets!M$8","v":0},{"$f":"targets!M$13","v":0},{"$f":"targets!M$11","v":0},{"$f":"HoursMinutes(targets!M$10)","v":""},null,{"$f":"HoursMinutes(targets!M$61)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"targets!M$29","v":0}]