{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Data","Annual Summary","Charts","January","February","March","April","May","June","July","August","September","October","November","December"],"not_rendered":{"charts":33,"images":1,"macros":1,"external_links":0,"defined_names":26,"comments":0,"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":"Data","index":0,"n_rows":366,"n_cols":12,"rows_kept":366,"cut":false,"hidden":true,"merged":[]}
["Date","Month","GP","Rainfall","Min Air Temp","Max Air Temp","Dry Day","Wet Day","Frost Day","Smith Kerns","E.T","Humidity"]
["2022-01-01",{"$f":"TEXT($A2,\"mmmm\")","v":"January"},{"$f":"VLOOKUP($A2,INDIRECT($B2 & \"!$B$10:$P$40\"),9,FALSE)","v":""},{"$f":"IF($C2<>\"\",IF(VLOOKUP($A2,INDIRECT($B2 & \"!$B$10:$P$40\"),5,FALSE)<>\"\",VLOOKUP($A2,INDIRECT($B2 & \"!$B$10:$P$40\"),5,FALSE),0),\"\")","v":""},{"$f":"IF(VLOOKUP($A2,INDIRECT($B2 & \"!$B$10:$P$40\"),2,FALSE)<>\"\",VLOOKUP($A2,INDIRECT($B2 & \"!$B$10:$P$40\"),2,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A2,INDIRECT($B2 & \"!$B$10:$P$40\"),3,FALSE)<>\"\",VLOOKUP($A2,INDIRECT($B2 & \"!$B$10:$P$40\"),3,FALSE),\"\")","v":""},{"$f":"IF($C2<>\"\",IF($D2=0,1,0),\"\")","v":""},{"$f":"IF($G2<>\"\",IF($D2>0,1,0),\"\")","v":""},{"$f":"IF($E2<>\"\",IF($E2<=0,1,0),\"\")","v":""},{"$f":"IFERROR(IF((-11.4041+(0.0894*AVERAGE(#REF!))+(0.1932*AVERAGE(#REF!)))<>\"\",IF(OR(AVERAGE(#REF!)<=10,AVERAGE(#REF!)>=35),\"\",(EXP((-11.4041+(0.0894*AVERAGE(#REF!))+(0.1932*AVERAGE(#REF!)))))/(1+EXP((-11.4041+(0.0894*AVERAGE(#REF!))+(0.1932*AVERAGE(#REF!)))))),\"\"),\"\")","v":""},{"$f":"IF(VLOOKUP($A2,INDIRECT($B2 & \"!$B$10:$P$40\"),14,FALSE)<>\"\",VLOOKUP($A2,INDIRECT($B2 & \"!$B$10:$P$40\"),14,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A2,INDIRECT($B2 & \"!$B$10:$P$40\"),13,FALSE)<>\"\",VLOOKUP($A2,INDIRECT($B2 & \"!$B$10:$P$40\"),13,FALSE),\"\")","v":""}]
[{"$f":"SUM(A2+1)","v":"2022-01-02"},{"$f":"TEXT($A3,\"mmmm\")","v":"January"},{"$f":"VLOOKUP($A3,INDIRECT($B3 & \"!$B$10:$P$40\"),9,FALSE)","v":""},{"$f":"IF($C3<>\"\",IF(VLOOKUP($A3,INDIRECT($B3 & \"!$B$10:$P$40\"),5,FALSE)<>\"\",VLOOKUP($A3,INDIRECT($B3 & \"!$B$10:$P$40\"),5,FALSE),0),\"\")","v":""},{"$f":"IF(VLOOKUP($A3,INDIRECT($B3 & \"!$B$10:$P$40\"),2,FALSE)<>\"\",VLOOKUP($A3,INDIRECT($B3 & \"!$B$10:$P$40\"),2,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A3,INDIRECT($B3 & \"!$B$10:$P$40\"),3,FALSE)<>\"\",VLOOKUP($A3,INDIRECT($B3 & \"!$B$10:$P$40\"),3,FALSE),\"\")","v":""},{"$f":"IF($C3<>\"\",IF($D3=0,1,0),\"\")","v":""},{"$f":"IF($G3<>\"\",IF($D3>0,1,0),\"\")","v":""},{"$f":"IF($E3<>\"\",IF($E3<=0,1,0),\"\")","v":""},{"$f":"IFERROR(IF((-11.4041+(0.0894*AVERAGE(#REF!))+(0.1932*AVERAGE(#REF!)))<>\"\",IF(OR(AVERAGE(#REF!)<=10,AVERAGE(#REF!)>=35),\"\",(EXP((-11.4041+(0.0894*AVERAGE(#REF!))+(0.1932*AVERAGE(#REF!)))))/(1+EXP((-11.4041+(0.0894*AVERAGE(#REF!))+(0.1932*AVERAGE(#REF!)))))),\"\"),\"\")","v":""},{"$f":"IF(VLOOKUP($A3,INDIRECT($B3 & \"!$B$10:$P$40\"),14,FALSE)<>\"\",VLOOKUP($A3,INDIRECT($B3 & \"!$B$10:$P$40\"),14,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A3,INDIRECT($B3 & \"!$B$10:$P$40\"),13,FALSE)<>\"\",VLOOKUP($A3,INDIRECT($B3 & \"!$B$10:$P$40\"),13,FALSE),\"\")","v":""}]
[{"$f":"SUM(A3+1)","v":"2022-01-03"},"January","","","","","","","",{"$f":"IFERROR(IF((-11.4041+(0.0894*AVERAGE(#REF!))+(0.1932*AVERAGE(#REF!)))<>\"\",IF(OR(AVERAGE(#REF!)<=10,AVERAGE(#REF!)>=35),\"\",(EXP((-11.4041+(0.0894*AVERAGE(#REF!))+(0.1932*AVERAGE(#REF!)))))/(1+EXP((-11.4041+(0.0894*AVERAGE(#REF!))+(0.1932*AVERAGE(#REF!)))))),\"\"),\"\")","v":""},"",""]
["2022-01-04","January","","","","","","","",{"$f":"IFERROR(IF((-11.4041+(0.0894*AVERAGE($L1:$L5))+(0.1932*AVERAGE($E1:$F5)))<>\"\",IF(OR(AVERAGE($E1:$F5)<=10,AVERAGE($E1:$F5)>=35),\"\",(EXP((-11.4041+(0.0894*AVERAGE($L1:$L5))+(0.1932*AVERAGE($E1:$F5)))))/(1+EXP((-11.4041+(0.0894*AVERAGE($L1:$L5))+(0.1932*AVERAGE($E1:$F5)))))),\"\"),\"\")","v":""},"",""]
["2022-01-05","January","","","","","","","",{"$f":"IFERROR(IF((-11.4041+(0.0894*AVERAGE($L2:$L6))+(0.1932*AVERAGE($E2:$F6)))<>\"\",IF(OR(AVERAGE($E2:$F6)<=10,AVERAGE($E2:$F6)>=35),\"\",(EXP((-11.4041+(0.0894*AVERAGE($L2:$L6))+(0.1932*AVERAGE($E2:$F6)))))/(1+EXP((-11.4041+(0.0894*AVERAGE($L2:$L6))+(0.1932*AVERAGE($E2:$F6)))))),\"\"),\"\")","v":""},"",""]
["2022-01-06","January","","","","","","","",{"$f":"IFERROR(IF((-11.4041+(0.0894*AVERAGE($L3:$L7))+(0.1932*AVERAGE($E3:$F7)))<>\"\",IF(OR(AVERAGE($E3:$F7)<=10,AVERAGE($E3:$F7)>=35),\"\",(EXP((-11.4041+(0.0894*AVERAGE($L3:$L7))+(0.1932*AVERAGE($E3:$F7)))))/(1+EXP((-11.4041+(0.0894*AVERAGE($L3:$L7))+(0.1932*AVERAGE($E3:$F7)))))),\"\"),\"\")","v":""},"",""]
["2022-01-07","January","","","","","","","","","",""]
["2022-01-08","January","","","","","","","","","",""]
["2022-01-09","January","","","","","","","","","",""]
["2022-01-10","January","","","","","","","","","",""]
["2022-01-11","January","","","","","","","","","",""]
["2022-01-12","January","","","","","","","","","",""]
["2022-01-13","January","","","","","","","","","",""]
["2022-01-14","January","","","","","","","","","",""]
["2022-01-15","January","","","","","","","","","",""]
["2022-01-16","January","","","","","","","","","",""]
["2022-01-17","January","","","","","","","","","",""]
["2022-01-18","January","","","","","","","","","",""]
["2022-01-19","January","","","","","","","","","",""]
["2022-01-20","January","","","","","","","","","",""]
["2022-01-21","January","","","","","","","","","",""]
["2022-01-22","January","","","","","","","","","",""]
["2022-01-23","January","","","","","","","","","",""]
["2022-01-24","January","","","","","","","","","",""]
["2022-01-25","January","","","","","","","","","",""]
["2022-01-26","January","","","","","","","","","",""]
["2022-01-27","January","","","","","","","","","",""]
["2022-01-28","January","","","","","","","","","",""]
["2022-01-29","January","","","","","","","","","",""]
["2022-01-30","January","","","","","","","","","",""]
["2022-01-31","January","","","","","","","","","",""]
["2022-02-01","February","","","","","","","","","",""]
["2022-02-02","February","","","","","","","","","",""]
["2022-02-03","February","","","","","","","","","",""]
["2022-02-04","February","","","","","","","","","",""]
["2022-02-05","February","","","","","","","","","",""]
["2022-02-06","February","","","","","","","","","",""]
["2022-02-07","February","","","","","","","","","",""]
["2022-02-08","February","","","","","","","","","",""]
["2022-02-09","February","","","","","","","","","",""]
["2022-02-10","February","","","","","","","","","",""]
["2022-02-11","February","","","","","","","","","",""]
["2022-02-12","February","","","","","","","","","",""]
["2022-02-13","February","","","","","","","","","",""]
["2022-02-14","February","","","","","","","","","",""]
["2022-02-15","February","","","","","","","","","",""]
["2022-02-16","February","","","","","","","","","",""]
["2022-02-17","February","","","","","","","","","",""]
["2022-02-18","February","","","","","","","","","",""]
["2022-02-19","February","","","","","","","","","",""]
["2022-02-20","February","","","","","","","","","",""]
["2022-02-21","February","","","","","","","","","",""]
["2022-02-22","February","","","","","","","","","",""]
["2022-02-23","February","","","","","","","","","",""]
["2022-02-24","February","","","","","","","","","",""]
["2022-02-25","February","","","","","","","","","",""]
["2022-02-26","February","","","","","","","","","",""]
["2022-02-27","February","","","","","","","","","",""]
["2022-02-28","February","","","","","","","","","",""]
["2022-03-01","March","","","","","","","","","",""]
["2022-03-02","March","","","","","","","","","",""]
["2022-03-03","March","","","","","","","","","",""]
["2022-03-04","March","","","","","","","","","",""]
["2022-03-05","March","","","","","","","","","",""]
["2022-03-06","March","","","","","","","","","",""]
["2022-03-07",{"$f":"TEXT($A67,\"mmmm\")","v":"March"},{"$f":"VLOOKUP($A67,INDIRECT($B67 & \"!$B$10:$P$40\"),9,FALSE)","v":""},{"$f":"IF($C67<>\"\",IF(VLOOKUP($A67,INDIRECT($B67 & \"!$B$10:$P$40\"),5,FALSE)<>\"\",VLOOKUP($A67,INDIRECT($B67 & \"!$B$10:$P$40\"),5,FALSE),0),\"\")","v":""},{"$f":"IF(VLOOKUP($A67,INDIRECT($B67 & \"!$B$10:$P$40\"),2,FALSE)<>\"\",VLOOKUP($A67,INDIRECT($B67 & \"!$B$10:$P$40\"),2,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A67,INDIRECT($B67 & \"!$B$10:$P$40\"),3,FALSE)<>\"\",VLOOKUP($A67,INDIRECT($B67 & \"!$B$10:$P$40\"),3,FALSE),\"\")","v":""},{"$f":"IF($C67<>\"\",IF($D67=0,1,0),\"\")","v":""},{"$f":"IF($G67<>\"\",IF($D67>0,1,0),\"\")","v":""},{"$f":"IF($E67<>\"\",IF($E67<=0,1,0),\"\")","v":""},"",{"$f":"IF(VLOOKUP($A67,INDIRECT($B67 & \"!$B$10:$P$40\"),14,FALSE)<>\"\",VLOOKUP($A67,INDIRECT($B67 & \"!$B$10:$P$40\"),14,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A67,INDIRECT($B67 & \"!$B$10:$P$40\"),13,FALSE)<>\"\",VLOOKUP($A67,INDIRECT($B67 & \"!$B$10:$P$40\"),13,FALSE),\"\")","v":""}]
[{"$f":"SUM(A67+1)","v":"2022-03-08"},"March","","","","","","","","","",""]
["2022-03-09","March","","","","","","","","","",""]
["2022-03-10","March","","","","","","","","","",""]
["2022-03-11","March","","","","","","","",{"$f":"IFERROR(IF((-11.4041+(0.0894*AVERAGE($L67:$L71))+(0.1932*AVERAGE($E67:$F71)))<>\"\",IF(OR(AVERAGE($E67:$F71)<=10,AVERAGE($E67:$F71)>=35),\"\",(EXP((-11.4041+(0.0894*AVERAGE($L67:$L71))+(0.1932*AVERAGE($E67:$F71)))))/(1+EXP((-11.4041+(0.0894*AVERAGE($L67:$L71))+(0.1932*AVERAGE($E67:$F71)))))),\"\"),\"\")","v":""},"",""]
["2022-03-12","March","","","","","","","","","",""]
["2022-03-13","March","","","","","","","","","",""]
["2022-03-14","March","","","","","","","","","",""]
["2022-03-15","March","","","","","","","","","",""]
["2022-03-16","March","","","","","","","","","",""]
["2022-03-17","March","","","","","","","","","",""]
["2022-03-18","March","","","","","","","","","",""]
["2022-03-19","March","","","","","","","","","",""]
["2022-03-20","March","","","","","","","","","",""]
["2022-03-21","March","","","","","","","","","",""]
["2022-03-22","March","","","","","","","","","",""]
["2022-03-23","March","","","","","","","","","",""]
["2022-03-24","March","","","","","","","","","",""]
["2022-03-25","March","","","","","","","","","",""]
["2022-03-26","March","","","","","","","","","",""]
["2022-03-27","March","","","","","","","","","",""]
["2022-03-28","March","","","","","","","","","",""]
["2022-03-29","March","","","","","","","","","",""]
["2022-03-30","March","","","","","","","","","",""]
["2022-03-31","March","","","","","","","","","",""]
["2022-04-01","April","","","","","","","","","",""]
["2022-04-02","April","","","","","","","","","",""]
["2022-04-03","April","","","","","","","","","",""]
["2022-04-04","April","","","","","","","","","",""]
["2022-04-05","April","","","","","","","","","",""]
["2022-04-06","April","","","","","","","","","",""]
["2022-04-07","April","","","","","","","","","",""]
["2022-04-08","April","","","","","","","","","",""]
["2022-04-09","April","","","","","","","","","",""]
["2022-04-10","April","","","","","","","","","",""]
["2022-04-11","April","","","","","","","","","",""]
["2022-04-12","April","","","","","","","","","",""]
["2022-04-13","April","","","","","","","","","",""]
["2022-04-14","April","","","","","","","","","",""]
["2022-04-15","April","","","","","","","","","",""]
["2022-04-16","April","","","","","","","","","",""]
["2022-04-17","April","","","","","","","","","",""]
["2022-04-18","April","","","","","","","","","",""]
["2022-04-19","April","","","","","","","","","",""]
["2022-04-20","April","","","","","","","","","",""]
["2022-04-21","April","","","","","","","","","",""]
["2022-04-22","April","","","","","","","","","",""]
["2022-04-23","April","","","","","","","","","",""]
["2022-04-24","April","","","","","","","","","",""]
["2022-04-25","April","","","","","","","","","",""]
["2022-04-26","April","","","","","","","","","",""]
["2022-04-27","April","","","","","","","","","",""]
["2022-04-28","April","","","","","","","","","",""]
["2022-04-29","April","","","","","","","","","",""]
["2022-04-30","April","","","","","","","","","",""]
["2022-05-01","May","","","","","","","","","",""]
["2022-05-02","May","","","","","","","","","",""]
["2022-05-03","May","","","","","","","","","",""]
["2022-05-04","May","","","","","","","","","",""]
["2022-05-05","May","","","","","","","","","",""]
["2022-05-06","May","","","","","","","","","",""]
["2022-05-07","May","","","","","","","","","",""]
["2022-05-08","May","","","","","","","","","",""]
["2022-05-09","May","","","","","","","","","",""]
["2022-05-10",{"$f":"TEXT($A131,\"mmmm\")","v":"May"},{"$f":"VLOOKUP($A131,INDIRECT($B131 & \"!$B$10:$P$40\"),9,FALSE)","v":""},{"$f":"IF($C131<>\"\",IF(VLOOKUP($A131,INDIRECT($B131 & \"!$B$10:$P$40\"),5,FALSE)<>\"\",VLOOKUP($A131,INDIRECT($B131 & \"!$B$10:$P$40\"),5,FALSE),0),\"\")","v":""},{"$f":"IF(VLOOKUP($A131,INDIRECT($B131 & \"!$B$10:$P$40\"),2,FALSE)<>\"\",VLOOKUP($A131,INDIRECT($B131 & \"!$B$10:$P$40\"),2,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A131,INDIRECT($B131 & \"!$B$10:$P$40\"),3,FALSE)<>\"\",VLOOKUP($A131,INDIRECT($B131 & \"!$B$10:$P$40\"),3,FALSE),\"\")","v":""},{"$f":"IF($C131<>\"\",IF($D131=0,1,0),\"\")","v":""},{"$f":"IF($G131<>\"\",IF($D131>0,1,0),\"\")","v":""},{"$f":"IF($E131<>\"\",IF($E131<=0,1,0),\"\")","v":""},"",{"$f":"IF(VLOOKUP($A131,INDIRECT($B131 & \"!$B$10:$P$40\"),14,FALSE)<>\"\",VLOOKUP($A131,INDIRECT($B131 & \"!$B$10:$P$40\"),14,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A131,INDIRECT($B131 & \"!$B$10:$P$40\"),13,FALSE)<>\"\",VLOOKUP($A131,INDIRECT($B131 & \"!$B$10:$P$40\"),13,FALSE),\"\")","v":""}]
[{"$f":"SUM(A131+1)","v":"2022-05-11"},"May","","","","","","","","","",""]
["2022-05-12","May","","","","","","","","","",""]
["2022-05-13","May","","","","","","","","","",""]
["2022-05-14","May","","","","","","","",{"$f":"IFERROR(IF((-11.4041+(0.0894*AVERAGE($L131:$L135))+(0.1932*AVERAGE($E131:$F135)))<>\"\",IF(OR(AVERAGE($E131:$F135)<=10,AVERAGE($E131:$F135)>=35),\"\",(EXP((-11.4041+(0.0894*AVERAGE($L131:$L135))+(0.1932*AVERAGE($E131:$F135)))))/(1+EXP((-11.4041+(0.0894*AVERAGE($L131:$L135))+(0.1932*AVERAGE($E131:$F135)))))),\"\"),\"\")","v":""},"",""]
["2022-05-15","May","","","","","","","","","",""]
["2022-05-16","May","","","","","","","","","",""]
["2022-05-17","May","","","","","","","","","",""]
["2022-05-18","May","","","","","","","","","",""]
["2022-05-19","May","","","","","","","","","",""]
["2022-05-20","May","","","","","","","","","",""]
["2022-05-21","May","","","","","","","","","",""]
["2022-05-22","May","","","","","","","","","",""]
["2022-05-23","May","","","","","","","","","",""]
["2022-05-24","May","","","","","","","","","",""]
["2022-05-25","May","","","","","","","","","",""]
["2022-05-26","May","","","","","","","","","",""]
["2022-05-27","May","","","","","","","","","",""]
["2022-05-28","May","","","","","","","","","",""]
["2022-05-29","May","","","","","","","","","",""]
["2022-05-30","May","","","","","","","","","",""]
["2022-05-31","May","","","","","","","","","",""]
["2022-06-01","June","","","","","","","","","",""]
["2022-06-02","June","","","","","","","","","",""]
["2022-06-03","June","","","","","","","","","",""]
["2022-06-04","June","","","","","","","","","",""]
["2022-06-05","June","","","","","","","","","",""]
["2022-06-06","June","","","","","","","","","",""]
["2022-06-07","June","","","","","","","","","",""]
["2022-06-08","June","","","","","","","","","",""]
["2022-06-09","June","","","","","","","","","",""]
["2022-06-10","June","","","","","","","","","",""]
["2022-06-11","June","","","","","","","","","",""]
["2022-06-12","June","","","","","","","","","",""]
["2022-06-13","June","","","","","","","","","",""]
["2022-06-14","June","","","","","","","","","",""]
["2022-06-15","June","","","","","","","","","",""]
["2022-06-16","June","","","","","","","","","",""]
["2022-06-17","June","","","","","","","","","",""]
["2022-06-18","June","","","","","","","","","",""]
["2022-06-19","June","","","","","","","","","",""]
["2022-06-20","June","","","","","","","","","",""]
["2022-06-21","June","","","","","","","","","",""]
["2022-06-22","June","","","","","","","","","",""]
["2022-06-23","June","","","","","","","","","",""]
["2022-06-24","June","","","","","","","","","",""]
["2022-06-25","June","","","","","","","","","",""]
["2022-06-26","June","","","","","","","","","",""]
["2022-06-27","June","","","","","","","","","",""]
["2022-06-28","June","","","","","","","","","",""]
["2022-06-29","June","","","","","","","","","",""]
["2022-06-30","June","","","","","","","","","",""]
["2022-07-01","July","","","","","","","","","",""]
["2022-07-02","July","","","","","","","","","",""]
["2022-07-03","July","","","","","","","","","",""]
["2022-07-04","July","","","","","","","","","",""]
["2022-07-05","July","","","","","","","","","",""]
["2022-07-06","July","","","","","","","","","",""]
["2022-07-07","July","","","","","","","","","",""]
["2022-07-08","July","","","","","","","","","",""]
["2022-07-09","July","","","","","","","","","",""]
["2022-07-10","July","","","","","","","","","",""]
["2022-07-11","July","","","","","","","","","",""]
["2022-07-12","July","","","","","","","","","",""]
["2022-07-13",{"$f":"TEXT($A195,\"mmmm\")","v":"July"},{"$f":"VLOOKUP($A195,INDIRECT($B195 & \"!$B$10:$P$40\"),9,FALSE)","v":""},{"$f":"IF($C195<>\"\",IF(VLOOKUP($A195,INDIRECT($B195 & \"!$B$10:$P$40\"),5,FALSE)<>\"\",VLOOKUP($A195,INDIRECT($B195 & \"!$B$10:$P$40\"),5,FALSE),0),\"\")","v":""},{"$f":"IF(VLOOKUP($A195,INDIRECT($B195 & \"!$B$10:$P$40\"),2,FALSE)<>\"\",VLOOKUP($A195,INDIRECT($B195 & \"!$B$10:$P$40\"),2,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A195,INDIRECT($B195 & \"!$B$10:$P$40\"),3,FALSE)<>\"\",VLOOKUP($A195,INDIRECT($B195 & \"!$B$10:$P$40\"),3,FALSE),\"\")","v":""},{"$f":"IF($C195<>\"\",IF($D195=0,1,0),\"\")","v":""},{"$f":"IF($G195<>\"\",IF($D195>0,1,0),\"\")","v":""},{"$f":"IF($E195<>\"\",IF($E195<=0,1,0),\"\")","v":""},"",{"$f":"IF(VLOOKUP($A195,INDIRECT($B195 & \"!$B$10:$P$40\"),14,FALSE)<>\"\",VLOOKUP($A195,INDIRECT($B195 & \"!$B$10:$P$40\"),14,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A195,INDIRECT($B195 & \"!$B$10:$P$40\"),13,FALSE)<>\"\",VLOOKUP($A195,INDIRECT($B195 & \"!$B$10:$P$40\"),13,FALSE),\"\")","v":""}]
[{"$f":"SUM(A195+1)","v":"2022-07-14"},"July","","","","","","","","","",""]
["2022-07-15","July","","","","","","","","","",""]
["2022-07-16","July","","","","","","","","","",""]
["2022-07-17","July","","","","","","","",{"$f":"IFERROR(IF((-11.4041+(0.0894*AVERAGE($L195:$L199))+(0.1932*AVERAGE($E195:$F199)))<>\"\",IF(OR(AVERAGE($E195:$F199)<=10,AVERAGE($E195:$F199)>=35),\"\",(EXP((-11.4041+(0.0894*AVERAGE($L195:$L199))+(0.1932*AVERAGE($E195:$F199)))))/(1+EXP((-11.4041+(0.0894*AVERAGE($L195:$L199))+(0.1932*AVERAGE($E195:$F199)))))),\"\"),\"\")","v":""},"",""]
["2022-07-18","July","","","","","","","","","",""]
["2022-07-19","July","","","","","","","","","",""]
["2022-07-20","July","","","","","","","","","",""]
["2022-07-21","July","","","","","","","","","",""]
["2022-07-22","July","","","","","","","","","",""]
["2022-07-23","July","","","","","","","","","",""]
["2022-07-24","July","","","","","","","","","",""]
["2022-07-25","July","","","","","","","","","",""]
["2022-07-26","July","","","","","","","","","",""]
["2022-07-27","July","","","","","","","","","",""]
["2022-07-28","July","","","","","","","","","",""]
["2022-07-29","July","","","","","","","","","",""]
["2022-07-30","July","","","","","","","","","",""]
["2022-07-31","July","","","","","","","","","",""]
["2022-08-01","August","","","","","","","","","",""]
["2022-08-02","August","","","","","","","","","",""]
["2022-08-03","August","","","","","","","","","",""]
["2022-08-04","August","","","","","","","","","",""]
["2022-08-05","August","","","","","","","","","",""]
["2022-08-06","August","","","","","","","","","",""]
["2022-08-07","August","","","","","","","","","",""]
["2022-08-08","August","","","","","","","","","",""]
["2022-08-09","August","","","","","","","","","",""]
["2022-08-10","August","","","","","","","","","",""]
["2022-08-11","August","","","","","","","","","",""]
["2022-08-12","August","","","","","","","","","",""]
["2022-08-13","August","","","","","","","","","",""]
["2022-08-14","August","","","","","","","","","",""]
["2022-08-15","August","","","","","","","","","",""]
["2022-08-16","August","","","","","","","","","",""]
["2022-08-17","August","","","","","","","","","",""]
["2022-08-18","August","","","","","","","","","",""]
["2022-08-19","August","","","","","","","","","",""]
["2022-08-20","August","","","","","","","","","",""]
["2022-08-21","August","","","","","","","","","",""]
["2022-08-22","August","","","","","","","","","",""]
["2022-08-23","August","","","","","","","","","",""]
["2022-08-24","August","","","","","","","","","",""]
["2022-08-25","August","","","","","","","","","",""]
["2022-08-26","August","","","","","","","","","",""]
["2022-08-27","August","","","","","","","","","",""]
["2022-08-28","August","","","","","","","","","",""]
["2022-08-29","August","","","","","","","","","",""]
["2022-08-30","August","","","","","","","","","",""]
["2022-08-31","August","","","","","","","","","",""]
["2022-09-01","September","","","","","","","","","",""]
["2022-09-02","September","","","","","","","","","",""]
["2022-09-03","September","","","","","","","","","",""]
["2022-09-04","September","","","","","","","","","",""]
["2022-09-05","September","","","","","","","","","",""]
["2022-09-06","September","","","","","","","","","",""]
["2022-09-07","September","","","","","","","","","",""]
["2022-09-08","September","","","","","","","","","",""]
["2022-09-09","September","","","","","","","","","",""]
["2022-09-10","September","","","","","","","","","",""]
["2022-09-11","September","","","","","","","","","",""]
["2022-09-12","September","","","","","","","","","",""]
["2022-09-13","September","","","","","","","","","",""]
["2022-09-14","September","","","","","","","","","",""]
["2022-09-15",{"$f":"TEXT($A259,\"mmmm\")","v":"September"},{"$f":"VLOOKUP($A259,INDIRECT($B259 & \"!$B$10:$P$40\"),9,FALSE)","v":""},{"$f":"IF($C259<>\"\",IF(VLOOKUP($A259,INDIRECT($B259 & \"!$B$10:$P$40\"),5,FALSE)<>\"\",VLOOKUP($A259,INDIRECT($B259 & \"!$B$10:$P$40\"),5,FALSE),0),\"\")","v":""},{"$f":"IF(VLOOKUP($A259,INDIRECT($B259 & \"!$B$10:$P$40\"),2,FALSE)<>\"\",VLOOKUP($A259,INDIRECT($B259 & \"!$B$10:$P$40\"),2,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A259,INDIRECT($B259 & \"!$B$10:$P$40\"),3,FALSE)<>\"\",VLOOKUP($A259,INDIRECT($B259 & \"!$B$10:$P$40\"),3,FALSE),\"\")","v":""},{"$f":"IF($C259<>\"\",IF($D259=0,1,0),\"\")","v":""},{"$f":"IF($G259<>\"\",IF($D259>0,1,0),\"\")","v":""},{"$f":"IF($E259<>\"\",IF($E259<=0,1,0),\"\")","v":""},"",{"$f":"IF(VLOOKUP($A259,INDIRECT($B259 & \"!$B$10:$P$40\"),14,FALSE)<>\"\",VLOOKUP($A259,INDIRECT($B259 & \"!$B$10:$P$40\"),14,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A259,INDIRECT($B259 & \"!$B$10:$P$40\"),13,FALSE)<>\"\",VLOOKUP($A259,INDIRECT($B259 & \"!$B$10:$P$40\"),13,FALSE),\"\")","v":""}]
[{"$f":"SUM(A259+1)","v":"2022-09-16"},"September","","","","","","","","","",""]
["2022-09-17","September","","","","","","","","","",""]
["2022-09-18","September","","","","","","","","","",""]
["2022-09-19","September","","","","","","","",{"$f":"IFERROR(IF((-11.4041+(0.0894*AVERAGE($L259:$L263))+(0.1932*AVERAGE($E259:$F263)))<>\"\",IF(OR(AVERAGE($E259:$F263)<=10,AVERAGE($E259:$F263)>=35),\"\",(EXP((-11.4041+(0.0894*AVERAGE($L259:$L263))+(0.1932*AVERAGE($E259:$F263)))))/(1+EXP((-11.4041+(0.0894*AVERAGE($L259:$L263))+(0.1932*AVERAGE($E259:$F263)))))),\"\"),\"\")","v":""},"",""]
["2022-09-20","September","","","","","","","","","",""]
["2022-09-21","September","","","","","","","","","",""]
["2022-09-22","September","","","","","","","","","",""]
["2022-09-23","September","","","","","","","","","",""]
["2022-09-24","September","","","","","","","","","",""]
["2022-09-25","September","","","","","","","","","",""]
["2022-09-26","September","","","","","","","","","",""]
["2022-09-27","September","","","","","","","","","",""]
["2022-09-28","September","","","","","","","","","",""]
["2022-09-29","September","","","","","","","","","",""]
["2022-09-30","September","","","","","","","","","",""]
["2022-10-01","October","","","","","","","","","",""]
["2022-10-02","October","","","","","","","","","",""]
["2022-10-03","October","","","","","","","","","",""]
["2022-10-04","October","","","","","","","","","",""]
["2022-10-05","October","","","","","","","","","",""]
["2022-10-06","October","","","","","","","","","",""]
["2022-10-07","October","","","","","","","","","",""]
["2022-10-08","October","","","","","","","","","",""]
["2022-10-09","October","","","","","","","","","",""]
["2022-10-10","October","","","","","","","","","",""]
["2022-10-11","October","","","","","","","","","",""]
["2022-10-12","October","","","","","","","","","",""]
["2022-10-13","October","","","","","","","","","",""]
["2022-10-14","October","","","","","","","","","",""]
["2022-10-15","October","","","","","","","","","",""]
["2022-10-16","October","","","","","","","","","",""]
["2022-10-17","October","","","","","","","","","",""]
["2022-10-18","October","","","","","","","","","",""]
["2022-10-19","October","","","","","","","","","",""]
["2022-10-20","October","","","","","","","","","",""]
["2022-10-21","October","","","","","","","","","",""]
["2022-10-22","October","","","","","","","","","",""]
["2022-10-23","October","","","","","","","","","",""]
["2022-10-24","October","","","","","","","","","",""]
["2022-10-25","October","","","","","","","","","",""]
["2022-10-26","October","","","","","","","","","",""]
["2022-10-27","October","","","","","","","","","",""]
["2022-10-28","October","","","","","","","","","",""]
["2022-10-29","October","","","","","","","","","",""]
["2022-10-30","October","","","","","","","","","",""]
["2022-10-31","October","","","","","","","","","",""]
["2022-11-01","November","","","","","","","","","",""]
["2022-11-02","November","","","","","","","","","",""]
["2022-11-03","November","","","","","","","","","",""]
["2022-11-04","November","","","","","","","","","",""]
["2022-11-05","November","","","","","","","","","",""]
["2022-11-06","November","","","","","","","","","",""]
["2022-11-07","November","","","","","","","","","",""]
["2022-11-08","November","","","","","","","","","",""]
["2022-11-09","November","","","","","","","","","",""]
["2022-11-10","November","","","","","","","","","",""]
["2022-11-11","November","","","","","","","","","",""]
["2022-11-12","November","","","","","","","","","",""]
["2022-11-13","November","","","","","","","","","",""]
["2022-11-14","November","","","","","","","","","",""]
["2022-11-15","November","","","","","","","","","",""]
["2022-11-16","November","","","","","","","","","",""]
["2022-11-17","November","","","","","","","","","",""]
["2022-11-18",{"$f":"TEXT($A323,\"mmmm\")","v":"November"},{"$f":"VLOOKUP($A323,INDIRECT($B323 & \"!$B$10:$P$40\"),9,FALSE)","v":""},{"$f":"IF($C323<>\"\",IF(VLOOKUP($A323,INDIRECT($B323 & \"!$B$10:$P$40\"),5,FALSE)<>\"\",VLOOKUP($A323,INDIRECT($B323 & \"!$B$10:$P$40\"),5,FALSE),0),\"\")","v":""},{"$f":"IF(VLOOKUP($A323,INDIRECT($B323 & \"!$B$10:$P$40\"),2,FALSE)<>\"\",VLOOKUP($A323,INDIRECT($B323 & \"!$B$10:$P$40\"),2,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A323,INDIRECT($B323 & \"!$B$10:$P$40\"),3,FALSE)<>\"\",VLOOKUP($A323,INDIRECT($B323 & \"!$B$10:$P$40\"),3,FALSE),\"\")","v":""},{"$f":"IF($C323<>\"\",IF($D323=0,1,0),\"\")","v":""},{"$f":"IF($G323<>\"\",IF($D323>0,1,0),\"\")","v":""},{"$f":"IF($E323<>\"\",IF($E323<=0,1,0),\"\")","v":""},"",{"$f":"IF(VLOOKUP($A323,INDIRECT($B323 & \"!$B$10:$P$40\"),14,FALSE)<>\"\",VLOOKUP($A323,INDIRECT($B323 & \"!$B$10:$P$40\"),14,FALSE),\"\")","v":""},{"$f":"IF(VLOOKUP($A323,INDIRECT($B323 & \"!$B$10:$P$40\"),13,FALSE)<>\"\",VLOOKUP($A323,INDIRECT($B323 & \"!$B$10:$P$40\"),13,FALSE),\"\")","v":""}]
[{"$f":"SUM(A323+1)","v":"2022-11-19"},"November","","","","","","","","","",""]
["2022-11-20","November","","","","","","","","","",""]
["2022-11-21","November","","","","","","","","","",""]
["2022-11-22","November","","","","","","","",{"$f":"IFERROR(IF((-11.4041+(0.0894*AVERAGE($L323:$L327))+(0.1932*AVERAGE($E323:$F327)))<>\"\",IF(OR(AVERAGE($E323:$F327)<=10,AVERAGE($E323:$F327)>=35),\"\",(EXP((-11.4041+(0.0894*AVERAGE($L323:$L327))+(0.1932*AVERAGE($E323:$F327)))))/(1+EXP((-11.4041+(0.0894*AVERAGE($L323:$L327))+(0.1932*AVERAGE($E323:$F327)))))),\"\"),\"\")","v":""},"",""]
["2022-11-23","November","","","","","","","","","",""]
["2022-11-24","November","","","","","","","","","",""]
["2022-11-25","November","","","","","","","","","",""]
["2022-11-26","November","","","","","","","","","",""]
["2022-11-27","November","","","","","","","","","",""]
["2022-11-28","November","","","","","","","","","",""]
["2022-11-29","November","","","","","","","","","",""]
["2022-11-30","November","","","","","","","","","",""]
["2022-12-01","December","","","","","","","","","",""]
["2022-12-02","December","","","","","","","","","",""]
["2022-12-03","December","","","","","","","","","",""]
["2022-12-04","December","","","","","","","","","",""]
["2022-12-05","December","","","","","","","","","",""]
["2022-12-06","December","","","","","","","","","",""]
["2022-12-07","December","","","","","","","","","",""]
["2022-12-08","December","","","","","","","","","",""]
["2022-12-09","December","","","","","","","","","",""]
["2022-12-10","December","","","","","","","","","",""]
["2022-12-11","December","","","","","","","","","",""]
["2022-12-12","December","","","","","","","","","",""]
["2022-12-13","December","","","","","","","","","",""]
["2022-12-14","December","","","","","","","","","",""]
["2022-12-15","December","","","","","","","","","",""]
["2022-12-16","December","","","","","","","","","",""]
["2022-12-17","December","","","","","","","","","",""]
["2022-12-18","December","","","","","","","","","",""]
["2022-12-19","December","","","","","","","","","",""]
["2022-12-20","December","","","","","","","","","",""]
["2022-12-21","December","","","","","","","","","",""]
["2022-12-22","December","","","","","","","","","",""]
["2022-12-23","December","","","","","","","","","",""]
["2022-12-24","December","","","","","","","","","",""]
["2022-12-25","December","","","","","","","","","",""]
["2022-12-26","December","","","","","","","","","",""]
["2022-12-27","December","","","","","","","","","",""]
["2022-12-28","December","","","","","","","","","",""]
["2022-12-29","December","","","","","","","","","",""]
["2022-12-30","December","","","","","","","","","",""]
["2022-12-31","December","","","","","","","","","",""]

{"sheet":"Annual Summary","index":1,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[[6,3,6,5],[7,3,7,4],[7,6,7,10]]}
[]
[]
[]
[]
[]
[]
[null,null,null,"ANNUAL SUMMARY - ",null,null,2022]
[null,null,null,"Facility - "]
[]
[]
[null,"Date","Min Air Temp (C)","Max Air Temp (C)","Average Air Temp (C)","Monthly Rainfall Total (mm)","Monthly E.T Total (mm)","Cumulative Rainfall","Cumulative E.T","Monthly GDD Total ","Cumulative Monthly GDD","Monthly G.P Total ","Cumulative Monthly GP","Monthly Clipping Yield Total ","Total Dry Days","Total Wet Days","Total Frost Days"]
[null,{"$f":"DATE($G$7, ROW()-11, 1)","v":"2022-01-01"},{"$f":"INDIRECT(TEXT($B12,\"mmmm\")&\"!$C$42\")","v":""},{"$f":"INDIRECT(TEXT($B12,\"mmmm\")&\"!$D$42\")","v":""},{"$f":"INDIRECT(TEXT($B12,\"mmmm\")&\"!$E$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B12),1),\"mmmm\") &\"!$F$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B12),1),\"mmmm\") &\"!$O$42\")","v":""},{"$f":"$F$12","v":""},{"$f":"$G$12","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B12),1),\"mmmm\") &\"!$H$42\")","v":""},{"$f":"$J$12","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B12),1),\"mmmm\") &\"!$K$42\")","v":""},{"$f":"$L$12","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B12),1),\"mmmm\") &\"!$M$42\")","v":""},{"$f":"SUMIF(Data!$B:$B,TEXT($B12,\"mmmm\"),Data!$G:$G)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B12,\"mmmm\"),Data!$H:$H)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B12,\"mmmm\"),Data!$I:$I)","v":0}]
[null,{"$f":"DATE($G$7, ROW()-11, 1)","v":"2022-02-01"},{"$f":"INDIRECT(TEXT($B13,\"mmmm\")&\"!$C$42\")","v":""},{"$f":"INDIRECT(TEXT($B13,\"mmmm\")&\"!$D$42\")","v":""},{"$f":"INDIRECT(TEXT($B13,\"mmmm\")&\"!$E$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B13),1),\"mmmm\") &\"!$F$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B13),1),\"mmmm\") &\"!$O$42\")","v":""},{"$f":"IFERROR($H12+$F13,\"\")","v":""},{"$f":"IFERROR($I12+$G13,\"\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B13),1),\"mmmm\") &\"!$H$42\")","v":""},{"$f":"IFERROR($K12+$J13,\"\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B13),1),\"mmmm\") &\"!$K$42\")","v":""},{"$f":"IFERROR($M12+$L13,\"\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B13),1),\"mmmm\") &\"!$M$42\")","v":""},{"$f":"SUMIF(Data!$B:$B,TEXT($B13,\"mmmm\"),Data!$G:$G)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B13,\"mmmm\"),Data!$H:$H)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B13,\"mmmm\"),Data!$I:$I)","v":0}]
[null,"2022-03-01",{"$f":"INDIRECT(TEXT($B14,\"mmmm\")&\"!$C$42\")","v":""},{"$f":"INDIRECT(TEXT($B14,\"mmmm\")&\"!$D$42\")","v":""},{"$f":"INDIRECT(TEXT($B14,\"mmmm\")&\"!$E$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B14),1),\"mmmm\") &\"!$F$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B14),1),\"mmmm\") &\"!$O$42\")","v":""},{"$f":"IFERROR($H13+$F14,\"\")","v":""},{"$f":"IFERROR($I13+$G14,\"\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B14),1),\"mmmm\") &\"!$H$42\")","v":""},{"$f":"IFERROR($K13+$J14,\"\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B14),1),\"mmmm\") &\"!$K$42\")","v":""},{"$f":"IFERROR($M13+$L14,\"\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B14),1),\"mmmm\") &\"!$M$42\")","v":""},{"$f":"SUMIF(Data!$B:$B,TEXT($B14,\"mmmm\"),Data!$G:$G)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B14,\"mmmm\"),Data!$H:$H)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B14,\"mmmm\"),Data!$I:$I)","v":0}]
[null,"2022-04-01",{"$f":"INDIRECT(TEXT($B15,\"mmmm\")&\"!$C$42\")","v":""},{"$f":"INDIRECT(TEXT($B15,\"mmmm\")&\"!$D$42\")","v":""},{"$f":"INDIRECT(TEXT($B15,\"mmmm\")&\"!$E$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B15),1),\"mmmm\") &\"!$F$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B15),1),\"mmmm\") &\"!$O$42\")","v":""},"","",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B15),1),\"mmmm\") &\"!$H$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B15),1),\"mmmm\") &\"!$K$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B15),1),\"mmmm\") &\"!$M$42\")","v":""},{"$f":"SUMIF(Data!$B:$B,TEXT($B15,\"mmmm\"),Data!$G:$G)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B15,\"mmmm\"),Data!$H:$H)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B15,\"mmmm\"),Data!$I:$I)","v":0}]
[null,"2022-05-01",{"$f":"INDIRECT(TEXT($B16,\"mmmm\")&\"!$C$42\")","v":""},{"$f":"INDIRECT(TEXT($B16,\"mmmm\")&\"!$D$42\")","v":""},{"$f":"INDIRECT(TEXT($B16,\"mmmm\")&\"!$E$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B16),1),\"mmmm\") &\"!$F$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B16),1),\"mmmm\") &\"!$O$42\")","v":""},"","",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B16),1),\"mmmm\") &\"!$H$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B16),1),\"mmmm\") &\"!$K$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B16),1),\"mmmm\") &\"!$M$42\")","v":""},{"$f":"SUMIF(Data!$B:$B,TEXT($B16,\"mmmm\"),Data!$G:$G)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B16,\"mmmm\"),Data!$H:$H)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B16,\"mmmm\"),Data!$I:$I)","v":0}]
[null,"2022-06-01",{"$f":"INDIRECT(TEXT($B17,\"mmmm\")&\"!$C$42\")","v":""},{"$f":"INDIRECT(TEXT($B17,\"mmmm\")&\"!$D$42\")","v":""},{"$f":"INDIRECT(TEXT($B17,\"mmmm\")&\"!$E$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B17),1),\"mmmm\") &\"!$F$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B17),1),\"mmmm\") &\"!$O$42\")","v":""},"","",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B17),1),\"mmmm\") &\"!$H$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B17),1),\"mmmm\") &\"!$K$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B17),1),\"mmmm\") &\"!$M$42\")","v":""},{"$f":"SUMIF(Data!$B:$B,TEXT($B17,\"mmmm\"),Data!$G:$G)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B17,\"mmmm\"),Data!$H:$H)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B17,\"mmmm\"),Data!$I:$I)","v":0}]
[null,"2022-07-01",{"$f":"INDIRECT(TEXT($B18,\"mmmm\")&\"!$C$42\")","v":""},{"$f":"INDIRECT(TEXT($B18,\"mmmm\")&\"!$D$42\")","v":""},{"$f":"INDIRECT(TEXT($B18,\"mmmm\")&\"!$E$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B18),1),\"mmmm\") &\"!$F$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B18),1),\"mmmm\") &\"!$O$42\")","v":""},"","",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B18),1),\"mmmm\") &\"!$H$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B18),1),\"mmmm\") &\"!$K$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B18),1),\"mmmm\") &\"!$M$42\")","v":""},{"$f":"SUMIF(Data!$B:$B,TEXT($B18,\"mmmm\"),Data!$G:$G)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B18,\"mmmm\"),Data!$H:$H)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B18,\"mmmm\"),Data!$I:$I)","v":0}]
[null,"2022-08-01",{"$f":"INDIRECT(TEXT($B19,\"mmmm\")&\"!$C$42\")","v":""},{"$f":"INDIRECT(TEXT($B19,\"mmmm\")&\"!$D$42\")","v":""},{"$f":"INDIRECT(TEXT($B19,\"mmmm\")&\"!$E$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B19),1),\"mmmm\") &\"!$F$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B19),1),\"mmmm\") &\"!$O$42\")","v":""},"","",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B19),1),\"mmmm\") &\"!$H$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B19),1),\"mmmm\") &\"!$K$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B19),1),\"mmmm\") &\"!$M$42\")","v":""},{"$f":"SUMIF(Data!$B:$B,TEXT($B19,\"mmmm\"),Data!$G:$G)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B19,\"mmmm\"),Data!$H:$H)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B19,\"mmmm\"),Data!$I:$I)","v":0}]
[null,"2022-09-01",{"$f":"INDIRECT(TEXT($B20,\"mmmm\")&\"!$C$42\")","v":""},{"$f":"INDIRECT(TEXT($B20,\"mmmm\")&\"!$D$42\")","v":""},{"$f":"INDIRECT(TEXT($B20,\"mmmm\")&\"!$E$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B20),1),\"mmmm\") &\"!$F$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B20),1),\"mmmm\") &\"!$O$42\")","v":""},"","",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B20),1),\"mmmm\") &\"!$H$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B20),1),\"mmmm\") &\"!$K$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B20),1),\"mmmm\") &\"!$M$42\")","v":""},{"$f":"SUMIF(Data!$B:$B,TEXT($B20,\"mmmm\"),Data!$G:$G)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B20,\"mmmm\"),Data!$H:$H)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B20,\"mmmm\"),Data!$I:$I)","v":0}]
[null,"2022-10-01",{"$f":"INDIRECT(TEXT($B21,\"mmmm\")&\"!$C$42\")","v":""},{"$f":"INDIRECT(TEXT($B21,\"mmmm\")&\"!$D$42\")","v":""},{"$f":"INDIRECT(TEXT($B21,\"mmmm\")&\"!$E$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B21),1),\"mmmm\") &\"!$F$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B21),1),\"mmmm\") &\"!$O$42\")","v":""},"","",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B21),1),\"mmmm\") &\"!$H$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B21),1),\"mmmm\") &\"!$K$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B21),1),\"mmmm\") &\"!$M$42\")","v":""},{"$f":"SUMIF(Data!$B:$B,TEXT($B21,\"mmmm\"),Data!$G:$G)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B21,\"mmmm\"),Data!$H:$H)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B21,\"mmmm\"),Data!$I:$I)","v":0}]
[null,"2022-11-01",{"$f":"INDIRECT(TEXT($B22,\"mmmm\")&\"!$C$42\")","v":""},{"$f":"INDIRECT(TEXT($B22,\"mmmm\")&\"!$D$42\")","v":""},{"$f":"INDIRECT(TEXT($B22,\"mmmm\")&\"!$E$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B22),1),\"mmmm\") &\"!$F$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B22),1),\"mmmm\") &\"!$O$42\")","v":""},"","",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B22),1),\"mmmm\") &\"!$H$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B22),1),\"mmmm\") &\"!$K$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B22),1),\"mmmm\") &\"!$M$42\")","v":""},{"$f":"SUMIF(Data!$B:$B,TEXT($B22,\"mmmm\"),Data!$G:$G)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B22,\"mmmm\"),Data!$H:$H)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B22,\"mmmm\"),Data!$I:$I)","v":0}]
[null,"2022-12-01",{"$f":"INDIRECT(TEXT($B23,\"mmmm\")&\"!$C$42\")","v":""},{"$f":"INDIRECT(TEXT($B23,\"mmmm\")&\"!$D$42\")","v":""},{"$f":"INDIRECT(TEXT($B23,\"mmmm\")&\"!$E$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B23),1),\"mmmm\") &\"!$F$42\")","v":""},{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B23),1),\"mmmm\") &\"!$O$42\")","v":""},"","",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B23),1),\"mmmm\") &\"!$H$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B23),1),\"mmmm\") &\"!$K$42\")","v":""},"",{"$f":"INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B23),1),\"mmmm\") &\"!$M$42\")","v":""},{"$f":"SUMIF(Data!$B:$B,TEXT($B23,\"mmmm\"),Data!$G:$G)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B23,\"mmmm\"),Data!$H:$H)","v":0},{"$f":"SUMIF(Data!$B:$B,TEXT($B23,\"mmmm\"),Data!$I:$I)","v":0}]
[null,null,null,null,null,{"$f":"SUM($F$12:$F$23)","v":0},{"$f":"SUM($G$12:$G$23)","v":0},null,null,{"$f":"SUM($J$12:$J$23)","v":0},null,{"$f":"SUM($L$12:$L$23)","v":0},null,{"$f":"SUM($N$12:$N$23)","v":0}]

{"sheet":"Charts","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"January","index":3,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,5,5,10]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255) & \" \" & 'Annual Summary'!$G$7 & \" Weather Stats\"","v":"January 2022 Weather Stats"}]
[]
[]
[null,"Date","Min Air Temp (C)","Max Air Temp (C)","Average Air Temp (C)","Rainfall (mm)","Growth Degree Days","Cumulative GDD (Month)","Cumulative GDD (Year)","Growth Potential","Cumulative GP (Month)","Cumulative GP (Year)","Clipping Yield","Humidity % ","E.T (mm)","Smith Kerns Model","Microdochium Activity ","Anthracnose Activity ","Dollar Spot Activity","GP for C4 Grass","5-day average temp","5-day average humidity","Logit"]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-01"},null,null,{"$f":"IFERROR(AVERAGE($C10,$D10),\"\")","v":""},null,{"$f":"IFERROR(IF(($E10-6)>0,$E10-6,0),\"\")","v":""},{"$f":"IF(ISBLANK($G$10),\"\",$G$10)","v":""},{"$f":"IF(ISBLANK($G$10),\"\",$G$10)","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E10-18)/5.5)^2),\"\")","v":""},{"$f":"IF(ISBLANK($J$10),\"\",$J$10)","v":""},{"$f":"IF(ISBLANK($J$10),\"\",$J$10)","v":""},null,null,null,{"$f":"VLOOKUP($B10,Data!$A:$J,10,FALSE)","v":""},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E10-31)/7.3)^2),\"\")","v":""}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-02"},null,null,{"$f":"IFERROR(AVERAGE($C11,$D11),\"\")","v":""},null,{"$f":"IFERROR(IF(($E11-6)>0,$E11-6,0),\"\")","v":""},{"$f":"IFERROR($H10+$G11,\"\")","v":""},{"$f":"IFERROR($H10+$G11,\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E11-18)/5.5)^2),\"\")","v":""},{"$f":"IFERROR($K10+$J11,\"\")","v":""},{"$f":"IFERROR($K10+$J11,\"\")","v":""},null,null,null,{"$f":"VLOOKUP($B11,Data!$A:$J,10,FALSE)","v":""},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E11-31)/7.3)^2),\"\")","v":""}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-03"},null,null,"",null,"",{"$f":"IFERROR($H11+$G12,\"\")","v":""},{"$f":"IFERROR($H11+$G12,\"\")","v":""},"",{"$f":"IFERROR($K11+$J12,\"\")","v":""},{"$f":"IFERROR($K11+$J12,\"\")","v":""},null,null,null,{"$f":"VLOOKUP($B12,Data!$A:$J,10,FALSE)","v":""},null,null,null,""]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-04"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B13,Data!$A:$J,10,FALSE)","v":""},null,null,null,""]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-05"},null,null,"",null,"","","","","","",null,null,null,{"$f":"X14","v":{"$error":"#DIV/0!"}},null,null,null,"",{"$f":"AVERAGE(E10:E14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N10:N14)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V14)+(0.1932*U14))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U14<=10,U14>=35),0,(EXP(W14))/(1+EXP(W14)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-06"},null,null,"",null,"","","","","","",null,null,null,{"$f":"X15","v":{"$error":"#DIV/0!"}},null,null,null,"",{"$f":"AVERAGE(E11:E15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N11:N15)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V15)+(0.1932*U15))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U15<=10,U15>=35),0,(EXP(W15))/(1+EXP(W15)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-07"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-08"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-09"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-10"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(OR(U19<=10,U19>=35),0,(EXP(W19))/(1+EXP(W19)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-11"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-12"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-13"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-14"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-15"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-16"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-17"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-18"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-19"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-20"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-21"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-22"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-23"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-24"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-25"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-26"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-27"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-28"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-29"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-30"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,1,ROW()-9)","v":"2022-01-31"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Monthly Average/Total",{"$f":"IF(ISERROR(AVERAGE($C$10:$C$40)),\"\",AVERAGE($C$10:$C$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($D$10:$D$40)),\"\",AVERAGE($D$10:$D$40))","v":""},{"$f":"IFERROR(AVERAGE($E$10:$E$40),\"\")","v":""},{"$f":"IF(SUM($F$10:$F$40)=0,\"\",SUM($F$10:$F$40))","v":""},{"$f":"IFERROR(AVERAGE($G$10:$G$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($I$10:$I$40<>\"\"),$I$10:$I$40),LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40)),\"\")","v":""},{"$f":"IFERROR(AVERAGE($J$10:$J$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($L$10:$L$40<>\"\"),$L$10:$L$40),LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40)),\"\")","v":""},{"$f":"IF(SUM($M$10:$M$40)=0,\"\",SUM($M$10:$M$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($N$10:$N$40)),\"\",AVERAGE($N$10:$N$40))","v":""},{"$f":"IF(SUM($O$10:$O$40)=0,\"\",SUM($O$10:$O$40))","v":""},null,null,null,null,{"$f":"SUM($T$10:$T$40)","v":0}]

{"sheet":"February","index":4,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,5,5,10]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255) & \" \" & 'Annual Summary'!$G$7 & \" Weather Stats\"","v":"February 2022 Weather Stats"}]
[]
[]
[null,"Date","Min Air Temp (C)","Max Air Temp (C)","Average Air Temp (C)","Rainfall (mm)","Growth Degree Days","Cumulative GDD (Month)","Cumulative GDD (Year)","Growth Potential","Cumulative GP (Month)","Cumulative GP (Year)","Clipping Yield","Humidity % ","E.T (mm)","Smith Kerns Model","Microdochium Activity ","Anthracnose Activity ","Dollar Spot Activity","GP for C4 Grass","5-day average temp","5-day average humidity","Logit"]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-01"},null,null,{"$f":"IFERROR(AVERAGE($C10,$D10),\"\")","v":""},null,{"$f":"IFERROR(IF(($E10-6)>0,$E10-6,0),\"\")","v":""},{"$f":"IF(ISBLANK($G$10),\"\",$G$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$I$42\") + IF($G$10=\"\",0,$G$10),\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E10-18)/5.5)^2),\"\")","v":""},{"$f":"IF(ISBLANK($J$10),\"\",$J$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$L$42\") + IF($K$10=\"\",0,$K$10),\"\")","v":""},null,null,null,{"$f":"X10","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E10-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(January!E37:E40,February!E10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(January!N37:N40,February!N10)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V10)+(0.1932*U10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U10<=10,U10>=35),0,(EXP(W10))/(1+EXP(W10)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-02"},null,null,{"$f":"IFERROR(AVERAGE($C11,$D11),\"\")","v":""},null,{"$f":"IFERROR(IF(($E11-6)>0,$E11-6,0),\"\")","v":""},{"$f":"IFERROR($H10+$G11,\"\")","v":""},{"$f":"IFERROR($I10+$G11,\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E11-18)/5.5)^2),\"\")","v":""},{"$f":"IFERROR($K10+$J11,\"\")","v":""},{"$f":"IFERROR($L10+$J11,\"\")","v":""},null,null,null,{"$f":"X11","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E11-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(January!E38:E40,February!E10:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(January!N38:N40,February!N10:N11)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V11)+(0.1932*U11))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U11<=10,U11>=35),0,(EXP(W11))/(1+EXP(W11)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-03"},null,null,"",null,"",{"$f":"IFERROR($H11+$G12,\"\")","v":""},{"$f":"IFERROR($I11+$G12,\"\")","v":""},"",{"$f":"IFERROR($K11+$J12,\"\")","v":""},{"$f":"IFERROR($L11+$J12,\"\")","v":""},null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(January!E39:E40,February!E10:E12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(January!N39:N40,February!N10:N12)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V12)+(0.1932*U12))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-04"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(January!E40,February!E10:E13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(January!N40,February!N10:N13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-05"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E10:E14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N10:N14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-06"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E11:E15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N11:N15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-07"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-08"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-09"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-10"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-11"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-12"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-13"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-14"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-15"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-16"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-17"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-18"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-19"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-20"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-21"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-22"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-23"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-24"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-25"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E33:E37)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-26"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E34:E38)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-27"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E35:E39)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,2,ROW()-9)","v":"2022-02-28"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E36:E40)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[null,"Monthly Average/Total",{"$f":"IF(ISERROR(AVERAGE($C$10:$C$40)),\"\",AVERAGE($C$10:$C$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($D$10:$D$40)),\"\",AVERAGE($D$10:$D$40))","v":""},{"$f":"IFERROR(AVERAGE($E$10:$E$40),\"\")","v":""},{"$f":"IF(SUM($F$10:$F$40)=0,\"\",SUM($F$10:$F$40))","v":""},{"$f":"IFERROR(AVERAGE($G$10:$G$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($I$10:$I$40<>\"\"),$I$10:$I$40),LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40)),\"\")","v":""},{"$f":"IFERROR(AVERAGE($J$10:$J$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($L$10:$L$40<>\"\"),$L$10:$L$40),LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40)),\"\")","v":""},{"$f":"IF(SUM($M$10:$M$40)=0,\"\",SUM($M$10:$M$40))","v":""},{"$f":"IF(ISERROR(AVERAGE(#REF!)),\"\",AVERAGE(#REF!))","v":""},{"$f":"IF(SUM($O$10:$O$40)=0,\"\",SUM($O$10:$O$40))","v":""},null,null,null,null,{"$f":"SUM($T$10:$T$40)","v":0}]

{"sheet":"March","index":5,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,5,5,10]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255) & \" \" & 'Annual Summary'!$G$7 & \" Weather Stats\"","v":"March 2022 Weather Stats"}]
[]
[]
[null,"Date","Min Air Temp (C)","Max Air Temp (C)","Average Air Temp (C)","Rainfall (mm)","Growth Degree Days","Cumulative GDD (Month)","Cumulative GDD (Year)","Growth Potential","Cumulative GP (Month)","Cumulative GP (Year)","Clipping Yield","Humidity % ","E.T (mm)","Smith Kerns Model","Microdochium Activity ","Anthracnose Activity ","Dollar Spot Activity","GP for C4 Grass","5-day average temp","5-day average humidity","Logit"]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-01"},null,null,{"$f":"IFERROR(AVERAGE($C10,$D10),\"\")","v":""},null,{"$f":"IFERROR(IF(($E10-6)>0,$E10-6,0),\"\")","v":""},{"$f":"IF(ISBLANK($G$10),\"\",$G$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$I$42\") + IF($G$10=\"\",0,$G$10),\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E10-18)/5.5)^2),\"\")","v":""},{"$f":"IF(ISBLANK($J$10),\"\",$J$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$L$42\") + IF($K$10=\"\",0,$K$10),\"\")","v":""},null,null,null,{"$f":"X10","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E10-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(February!E37:E40,March!E10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(February!N37:N40,March!N10)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V10)+(0.1932*U10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U10<=10,U10>=35),0,(EXP(W10))/(1+EXP(W10)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-02"},null,null,{"$f":"IFERROR(AVERAGE($C11,$D11),\"\")","v":""},null,{"$f":"IFERROR(IF(($E11-6)>0,$E11-6,0),\"\")","v":""},{"$f":"IFERROR($H10+$G11,\"\")","v":""},{"$f":"IFERROR($I10+$G11,\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E11-18)/5.5)^2),\"\")","v":""},{"$f":"IFERROR($K10+$J11,\"\")","v":""},{"$f":"IFERROR($L10+$J11,\"\")","v":""},null,null,null,{"$f":"X11","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E11-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(February!E38:E40,March!E10:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(February!N38:N40,March!N10:N11)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V11)+(0.1932*U11))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U11<=10,U11>=35),0,(EXP(W11))/(1+EXP(W11)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-03"},null,null,{"$f":"IFERROR(AVERAGE($C12,$D12),\"\")","v":""},null,{"$f":"IFERROR(IF(($E12-6)>0,$E12-6,0),\"\")","v":""},{"$f":"IFERROR($H11+$G12,\"\")","v":""},{"$f":"IFERROR($I11+$G12,\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E12-18)/5.5)^2),\"\")","v":""},{"$f":"IFERROR($K11+$J12,\"\")","v":""},{"$f":"IFERROR($L11+$J12,\"\")","v":""},null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(February!E39:E40,March!E10:E12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(February!N39:N40,March!N10:N12)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V12)+(0.1932*U12))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-04"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(February!E40,March!E10:E13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(February!N40,March!N10:N13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-05"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E10:E14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N10:N14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-06"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E11:E15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N11:N15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-07"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E12:E16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-08"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-09"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-10"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-11"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-12"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-13"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-14"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-15"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-16"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-17"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-18"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-19"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-20"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-21"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-22"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-23"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-24"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E29:E33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-25"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E30:E34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(-11.4041+(0.0894*V34)+(0.1932*U34))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-26"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E31:E35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-27"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-28"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-29"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$f":"AVERAGE(N34:N38)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V38)+(0.1932*U38))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U38<=10,U38>=35),0,(EXP(W38))/(1+EXP(W38)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-30"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,3,ROW()-9)","v":"2022-03-31"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$f":"AVERAGE(N36:N40)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Monthly Average/Total",{"$f":"IF(ISERROR(AVERAGE($C$10:$C$40)),\"\",AVERAGE($C$10:$C$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($D$10:$D$40)),\"\",AVERAGE($D$10:$D$40))","v":""},{"$f":"IFERROR(AVERAGE($E$10:$E$40),\"\")","v":""},{"$f":"IF(SUM($F$10:$F$40)=0,\"\",SUM($F$10:$F$40))","v":""},{"$f":"IFERROR(AVERAGE($G$10:$G$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($I$10:$I$40<>\"\"),$I$10:$I$40),LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40)),\"\")","v":""},{"$f":"IFERROR(AVERAGE($J$10:$J$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($L$10:$L$40<>\"\"),$L$10:$L$40),LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40)),\"\")","v":""},{"$f":"IF(SUM($M$10:$M$40)=0,\"\",SUM($M$10:$M$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($N$10:$N$40)),\"\",AVERAGE($N$10:$N$40))","v":""},{"$f":"IF(SUM($O$10:$O$40)=0,\"\",SUM($O$10:$O$40))","v":""},null,null,null,null,{"$f":"SUM($T$10:$T$40)","v":0}]

{"sheet":"April","index":6,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,5,5,10]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255) & \" \" & 'Annual Summary'!$G$7 & \" Weather Stats\"","v":"April 2022 Weather Stats"}]
[]
[]
[null,"Date","Min Air Temp (C)","Max Air Temp (C)","Average Air Temp (C)","Rainfall (mm)","Growth Degree Days","Cumulative GDD (Month)","Cumulative GDD (Year)","Growth Potential","Cumulative GP (Month)","Cumulative GP (Year)","Clipping Yield","Humidity % ","E.T (mm)","Smith Kerns Model","Microdochium Activity ","Anthracnose Activity ","Dollar Spot Activity","GP for C4 Grass","5-day average temp","5-day average humidity","Logit"]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-01"},null,null,{"$f":"IFERROR(AVERAGE($C10,$D10),\"\")","v":""},null,{"$f":"IFERROR(IF(($E10-6)>0,$E10-6,0),\"\")","v":""},{"$f":"IF(ISBLANK($G$10),\"\",$G$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$I$42\") + IF($G$10=\"\",0,$G$10),\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E10-18)/5.5)^2),\"\")","v":""},{"$f":"IF(ISBLANK($J$10),\"\",$J$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$L$42\") + IF($K$10=\"\",0,$K$10),\"\")","v":""},null,null,null,{"$f":"X10","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E10-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(March!E37:E40,April!E10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(March!N37:N40,April!N10)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V10)+(0.1932*U10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U10<=10,U10>=35),0,(EXP(W10))/(1+EXP(W10)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-02"},null,null,{"$f":"IFERROR(AVERAGE($C11,$D11),\"\")","v":""}," ",{"$f":"IFERROR(IF(($E11-6)>0,$E11-6,0),\"\")","v":""},{"$f":"IFERROR($H10+$G11,\"\")","v":""},{"$f":"IFERROR($I10+$G11,\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E11-18)/5.5)^2),\"\")","v":""},{"$f":"IFERROR($K10+$J11,\"\")","v":""},{"$f":"IFERROR($L10+$J11,\"\")","v":""},null,null,null,{"$f":"X11","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E11-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(March!E38:E40,April!E10:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(March!N38:N40,April!N10:N11)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V11)+(0.1932*U11))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U11<=10,U11>=35),0,(EXP(W11))/(1+EXP(W11)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-03"},null,null,"",null,"",{"$f":"IFERROR($H11+$G12,\"\")","v":""},{"$f":"IFERROR($I11+$G12,\"\")","v":""},"",{"$f":"IFERROR($K11+$J12,\"\")","v":""},{"$f":"IFERROR($L11+$J12,\"\")","v":""},null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(March!E39:E40,April!E10:E12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(March!N39:N40,April!N10:N12)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V12)+(0.1932*U12))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-04"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(March!E40,April!E10:E13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(March!N40,April!N10:N13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-05"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E10:E14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N10:N14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-06"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E11:E15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N11:N15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-07"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E12:E16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-08"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-09"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-10"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-11"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-12"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-13"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-14"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-15"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-16"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-17"},null,null,""," ","","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-18"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-19"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-20"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-21"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-22"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-23"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-24"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E29:E33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-25"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E30:E34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(-11.4041+(0.0894*V34)+(0.1932*U34))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-26"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E31:E35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-27"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-28"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-29"},null,null,""," ","","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,4,ROW()-9)","v":"2022-04-30"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,"Monthly Average/Total",{"$f":"IF(ISERROR(AVERAGE($C$10:$C$40)),\"\",AVERAGE($C$10:$C$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($D$10:$D$40)),\"\",AVERAGE($D$10:$D$40))","v":""},{"$f":"IFERROR(AVERAGE($E$10:$E$40),\"\")","v":""},{"$f":"IF(SUM($F$10:$F$39)=0,\"\",SUM($F$10:$F$39))","v":""},{"$f":"IFERROR(AVERAGE($G$10:$G$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($I$10:$I$40<>\"\"),$I$10:$I$40),LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40)),\"\")","v":""},{"$f":"IFERROR(AVERAGE($J$10:$J$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($L$10:$L$40<>\"\"),$L$10:$L$40),LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40)),\"\")","v":""},{"$f":"IF(SUM($M$10:$M$40)=0,\"\",SUM($M$10:$M$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($N$10:$N$40)),\"\",AVERAGE($N$10:$N$40))","v":""},{"$f":"IF(SUM($O$10:$O$40)=0,\"\",SUM($O$10:$O$40))","v":""},null,null,null,null,{"$f":"SUM($T$10:$T$40)","v":0}]

{"sheet":"May","index":7,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,5,5,10]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255) & \" \" & 'Annual Summary'!$G$7 & \" Weather Stats\"","v":"May 2022 Weather Stats"}]
[]
[]
[null,"Date","Min Air Temp (C)","Max Air Temp (C)","Average Air Temp (C)","Rainfall (mm)","Growth Degree Days","Cumulative GDD (Month)","Cumulative GDD (Year)","Growth Potential","Cumulative GP (Month)","Cumulative GP (Year)","Clipping Yield","Humidity % ","E.T (mm)","Smith Kerns Model","Microdochium Activity ","Anthracnose Activity ","Dollar Spot Activity","GP for C4 Grass","5-day average temp","5-day average humidity","Logit"]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-01"},null,null,{"$f":"IFERROR(AVERAGE($C10,$D10),\"\")","v":""},null,{"$f":"IFERROR(IF(($E10-6)>0,$E10-6,0),\"\")","v":""},{"$f":"IF(ISBLANK($G$10),\"\",$G$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$I$42\") + IF($G$10=\"\",0,$G$10),\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E10-18)/5.5)^2),\"\")","v":""},{"$f":"IF(ISBLANK($J$10),\"\",$J$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$L$42\") + IF($K$10=\"\",0,$K$10),\"\")","v":""},null,null,null,{"$f":"X10","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E10-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(April!E37:E40,May!E10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(April!N37:N40,May!N10)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V10)+(0.1932*U10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U10<=10,U10>=35),0,(EXP(W10))/(1+EXP(W10)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-02"},null,null,{"$f":"IFERROR(AVERAGE($C11,$D11),\"\")","v":""},null,{"$f":"IFERROR(IF(($E11-6)>0,$E11-6,0),\"\")","v":""},{"$f":"IFERROR($H10+$G11,\"\")","v":""},{"$f":"IFERROR($I10+$G11,\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E11-18)/5.5)^2),\"\")","v":""},{"$f":"IFERROR($K10+$J11,\"\")","v":""},{"$f":"IFERROR($L10+$J11,\"\")","v":""},null,null,null,{"$f":"X11","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E11-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(April!E38:E40,May!E10:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(April!N38:N40,May!N10:N11)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V11)+(0.1932*U11))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U11<=10,U11>=35),0,(EXP(W11))/(1+EXP(W11)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-03"},null,null,"",null,"",{"$f":"IFERROR($H11+$G12,\"\")","v":""},{"$f":"IFERROR($I11+$G12,\"\")","v":""},"",{"$f":"IFERROR($K11+$J12,\"\")","v":""},{"$f":"IFERROR($L11+$J12,\"\")","v":""},null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(April!E39:E40,May!E10:E12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(April!N39:N40,May!N10:N12)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V12)+(0.1932*U12))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-04"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(April!E40,May!E10:E13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(April!N40,May!N10:N13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-05"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E10:E14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N10:N14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-06"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E11:E15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N11:N15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-07"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E12:E16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-08"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-09"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-10"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-11"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-12"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-13"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-14"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-15"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-16"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-17"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-18"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-19"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-20"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-21"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-22"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-23"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-24"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E29:E33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-25"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E30:E34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(-11.4041+(0.0894*V34)+(0.1932*U34))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-26"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E31:E35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-27"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-28"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-29"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-30"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,5,ROW()-9)","v":"2022-05-31"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E36:E40)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N36:N40)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V40)+(0.1932*U40))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U40<=10,U40>=35),0,(EXP(W40))/(1+EXP(W40)))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Monthly Average/Total",{"$f":"IF(ISERROR(AVERAGE($C$10:$C$40)),\"\",AVERAGE($C$10:$C$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($D$10:$D$40)),\"\",AVERAGE($D$10:$D$40))","v":""},{"$f":"IFERROR(AVERAGE($E$10:$E$40),\"\")","v":""},{"$f":"IF(SUM($F$10:$F$40)=0,\"\",SUM($F$10:$F$40))","v":""},{"$f":"IFERROR(AVERAGE($G$10:$G$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($I$10:$I$40<>\"\"),$I$10:$I$40),LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40)),\"\")","v":""},{"$f":"IFERROR(AVERAGE($J$10:$J$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($L$10:$L$40<>\"\"),$L$10:$L$40),LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40)),\"\")","v":""},{"$f":"IF(SUM($M$10:$M$40)=0,\"\",SUM($M$10:$M$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($N$10:$N$40)),\"\",AVERAGE($N$10:$N$40))","v":""},{"$f":"IF(SUM($O$10:$O$40)=0,\"\",SUM($O$10:$O$40))","v":""},null,null,null,null,{"$f":"SUM($T$10:$T$40)","v":0}]

{"sheet":"June","index":8,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,5,5,10]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255) & \" \" & 'Annual Summary'!$G$7 & \" Weather Stats\"","v":"June 2022 Weather Stats"}]
[]
[]
[null,"Date","Min Air Temp (C)","Max Air Temp (C)","Average Air Temp (C)","Rainfall (mm)","Growth Degree Days","Cumulative GDD (Month)","Cumulative GDD (Year)","Growth Potential","Cumulative GP (Month)","Cumulative GP (Year)","Clipping Yield","Humidity % ","E.T (mm)","Smith Kerns Model","Microdochium Activity ","Anthracnose Activity ","Dollar Spot Activity","GP for C4 Grass","5-day average temp","5-day average humidity","Logit"]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-01"},null,null,{"$f":"IFERROR(AVERAGE($C10,$D10),\"\")","v":""},null,{"$f":"IFERROR(IF(($E10-6)>0,$E10-6,0),\"\")","v":""},{"$f":"IF(ISBLANK($G$10),\"\",$G$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$I$42\") + IF($G$10=\"\",0,$G$10),\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E10-18)/5.5)^2),\"\")","v":""},{"$f":"IF(ISBLANK($J$10),\"\",$J$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$L$42\") + IF($K$10=\"\",0,$K$10),\"\")","v":""},null,null,null,{"$f":"VLOOKUP($B10,Data!$A:$J,10,FALSE)","v":""},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E10-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(May!E37:E40,June!E10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(May!N37:N40,June!N10)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V10)+(0.1932*U10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U10<=10,U10>=35),0,(EXP(W10))/(1+EXP(W10)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-02"},null,null,{"$f":"IFERROR(AVERAGE($C11,$D11),\"\")","v":""},null,{"$f":"IFERROR(IF(($E11-6)>0,$E11-6,0),\"\")","v":""},{"$f":"IFERROR($H10+$G11,\"\")","v":""},{"$f":"IFERROR($I10+$G11,\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E11-18)/5.5)^2),\"\")","v":""},{"$f":"IFERROR($K10+$J11,\"\")","v":""},{"$f":"IFERROR($L10+$J11,\"\")","v":""},null,null,null,{"$f":"VLOOKUP($B11,Data!$A:$J,10,FALSE)","v":""},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E11-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(May!E38:E40,June!E10:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(May!N38:N40,June!N10:N11)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V11)+(0.1932*U11))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U11<=10,U11>=35),0,(EXP(W11))/(1+EXP(W11)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-03"},null,null,"",null,"",{"$f":"IFERROR($H11+$G12,\"\")","v":""},{"$f":"IFERROR($I11+$G12,\"\")","v":""},"",{"$f":"IFERROR($K11+$J12,\"\")","v":""},{"$f":"IFERROR($L11+$J12,\"\")","v":""},null,null,null,{"$f":"VLOOKUP($B12,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$f":"AVERAGE(May!E39:E40,June!E10:E12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(May!N39:N40,June!N10:N12)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V12)+(0.1932*U12))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-04"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B13,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$f":"AVERAGE(May!E40,June!E10:E13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(May!N40,June!N10:N13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-05"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B14,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$f":"AVERAGE(E10:E14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N10:N14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-06"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B15,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$f":"AVERAGE(E11:E15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N11:N15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-07"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B16,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$f":"AVERAGE(E12:E16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-08"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B17,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-09"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B18,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-10"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B19,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-11"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B20,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-12"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B21,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-13"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B22,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-14"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B23,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-15"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B24,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-16"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B25,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-17"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B26,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-18"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B27,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-19"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B28,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-20"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B29,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-21"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B30,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-22"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B31,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-23"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B32,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-24"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B33,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$f":"AVERAGE(E29:E33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-25"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B34,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$f":"AVERAGE(E30:E34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(-11.4041+(0.0894*V34)+(0.1932*U34))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-26"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B35,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$f":"AVERAGE(E31:E35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-27"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B36,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-28"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B37,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-29"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B38,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,6,ROW()-9)","v":"2022-06-30"},null,null,"",null,"","","","","","",null,null,null,{"$f":"VLOOKUP($B39,Data!$A:$J,10,FALSE)","v":""},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,"Monthly Average/Total",{"$f":"IF(ISERROR(AVERAGE($C$10:$C$40)),\"\",AVERAGE($C$10:$C$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($D$10:$D$40)),\"\",AVERAGE($D$10:$D$40))","v":""},{"$f":"IFERROR(AVERAGE($E$10:$E$40),\"\")","v":""},{"$f":"IF(SUM($F$10:$F$40)=0,\"\",SUM($F$10:$F$40))","v":""},{"$f":"IFERROR(AVERAGE($G$10:$G$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($I$10:$I$40<>\"\"),$I$10:$I$40),LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40)),\"\")","v":""},{"$f":"IFERROR(AVERAGE($J$10:$J$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($L$10:$L$40<>\"\"),$L$10:$L$40),LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40)),\"\")","v":""},{"$f":"IF(SUM($M$10:$M$40)=0,\"\",SUM($M$10:$M$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($N$10:$N$40)),\"\",AVERAGE($N$10:$N$40))","v":""},{"$f":"IF(SUM($O$10:$O$40)=0,\"\",SUM($O$10:$O$40))","v":""},null,null,null,null,{"$f":"SUM($T$10:$T$40)","v":0}]

{"sheet":"July","index":9,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,5,5,10]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255) & \" \" & 'Annual Summary'!$G$7 & \" Weather Stats\"","v":"July 2022 Weather Stats"}]
[]
[]
[null,"Date","Min Air Temp (C)","Max Air Temp (C)","Average Air Temp (C)","Rainfall (mm)","Growth Degree Days","Cumulative GDD (Month)","Cumulative GDD (Year)","Growth Potential","Cumulative GP (Month)","Cumulative GP (Year)","Clipping Yield","Humidity % ","E.T (mm)","Smith Kerns Model","Microdochium Activity ","Anthracnose Activity ","Dollar Spot Activity","GP for C4 Grass","5-day average temp","5-day average humidity","Logit"]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-01"},null,null,{"$f":"IFERROR(AVERAGE($C10,$D10),\"\")","v":""},null,{"$f":"IFERROR(IF(($E10-6)>0,$E10-6,0),\"\")","v":""},{"$f":"IF(ISBLANK($G$10),\"\",$G$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$I$42\") + IF($G$10=\"\",0,$G$10),\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E10-18)/5.5)^2),\"\")","v":""},{"$f":"IF(ISBLANK($J$10),\"\",$J$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$L$42\") + IF($K$10=\"\",0,$K$10),\"\")","v":""},null,null,null,{"$f":"X10","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E10-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(June!E36:E39,July!E10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(June!N36:N39,July!N10)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V10)+(0.1932*U10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U10<=10,U10>=35),0,(EXP(W10))/(1+EXP(W10)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-02"},null,null,{"$f":"IFERROR(AVERAGE($C11,$D11),\"\")","v":""},null,{"$f":"IFERROR(IF(($E11-6)>0,$E11-6,0),\"\")","v":""},{"$f":"IFERROR($H10+$G11,\"\")","v":""},{"$f":"IFERROR($I10+$G11,\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E11-18)/5.5)^2),\"\")","v":""},{"$f":"IFERROR($K10+$J11,\"\")","v":""},{"$f":"IFERROR($L10+$J11,\"\")","v":""},null,null,null,{"$f":"X11","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E11-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(June!E37:E39,July!E10:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(June!N37:N39,July!N10:N11)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V11)+(0.1932*U11))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U11<=10,U11>=35),0,(EXP(W11))/(1+EXP(W11)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-03"},null,null,"",null,"",{"$f":"IFERROR($H11+$G12,\"\")","v":""},{"$f":"IFERROR($I11+$G12,\"\")","v":""},"",{"$f":"IFERROR($K11+$J12,\"\")","v":""},{"$f":"IFERROR($L11+$J12,\"\")","v":""},null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(June!E38:E39,July!E10:E12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(June!N38:N39,July!N10:N12)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V12)+(0.1932*U12))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-04"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(June!E39,July!E10:E13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(June!N39,July!N10:N13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-05"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E10:E14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N10:N14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-06"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E11:E15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N11:N15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-07"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E12:E16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-08"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-09"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-10"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-11"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-12"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-13"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-14"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-15"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-16"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-17"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-18"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-19"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-20"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-21"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-22"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-23"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-24"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E29:E33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-25"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E30:E34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(-11.4041+(0.0894*V34)+(0.1932*U34))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-26"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E31:E35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-27"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-28"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-29"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-30"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,7,ROW()-9)","v":"2022-07-31"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E36:E40)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N36:N40)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V40)+(0.1932*U40))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U40<=10,U40>=35),0,(EXP(W40))/(1+EXP(W40)))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Monthly Average/Total",{"$f":"IF(ISERROR(AVERAGE($C$10:$C$40)),\"\",AVERAGE($C$10:$C$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($D$10:$D$40)),\"\",AVERAGE($D$10:$D$40))","v":""},{"$f":"IFERROR(AVERAGE($E$10:$E$40),\"\")","v":""},{"$f":"IF(SUM($F$10:$F$40)=0,\"\",SUM($F$10:$F$40))","v":""},{"$f":"IFERROR(AVERAGE($G$10:$G$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($I$10:$I$40<>\"\"),$I$10:$I$40),LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40)),\"\")","v":""},{"$f":"IFERROR(AVERAGE($J$10:$J$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($L$10:$L$40<>\"\"),$L$10:$L$40),LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40)),\"\")","v":""},{"$f":"IF(SUM($M$10:$M$40)=0,\"\",SUM($M$10:$M$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($N$10:$N$40)),\"\",AVERAGE($N$10:$N$40))","v":""},{"$f":"IF(SUM($O$10:$O$40)=0,\"\",SUM($O$10:$O$40))","v":""},null,null,null,null,{"$f":"SUM($T$10:$T$40)","v":0}]

{"sheet":"August","index":10,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,5,5,10]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255) & \" \" & 'Annual Summary'!$G$7 & \" Weather Stats\"","v":"August 2022 Weather Stats"}]
[]
[]
[null,"Date","Min Air Temp (C)","Max Air Temp (C)","Average Air Temp (C)","Rainfall (mm)","Growth Degree Days","Cumulative GDD (Month)","Cumulative GDD (Year)","Growth Potential","Cumulative GP (Month)","Cumulative GP (Year)","Clipping Yield","Humidity % ","E.T (mm)","Smith Kerns Model","Microdochium Activity ","Anthracnose Activity ","Dollar Spot Activity","GP for C4 Grass","5-day average temp","5-day average humidity","Logit"]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-01"},null,null,{"$f":"IFERROR(AVERAGE($C10,$D10),\"\")","v":""},null,{"$f":"IFERROR(IF(($E10-6)>0,$E10-6,0),\"\")","v":""},{"$f":"IF(ISBLANK($G$10),\"\",$G$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$I$42\") + IF($G$10=\"\",0,$G$10),\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E10-18)/5.5)^2),\"\")","v":""},{"$f":"IF(ISBLANK($J$10),\"\",$J$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$L$42\") + IF($K$10=\"\",0,$K$10),\"\")","v":""},null,null,null,{"$f":"X10","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E10-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(July!E37:E40,August!E10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(July!N37:N40,August!N10)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V10)+(0.1932*U10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U10<=10,U10>=35),0,(EXP(W10))/(1+EXP(W10)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-02"},null,null,{"$f":"IFERROR(AVERAGE($C11,$D11),\"\")","v":""},null,{"$f":"IFERROR(IF(($E11-6)>0,$E11-6,0),\"\")","v":""},{"$f":"IFERROR($H10+$G11,\"\")","v":""},{"$f":"IFERROR($I10+$G11,\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E11-18)/5.5)^2),\"\")","v":""},{"$f":"IFERROR($K10+$J11,\"\")","v":""},{"$f":"IFERROR($L10+$J11,\"\")","v":""},null,null,null,{"$f":"X11","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E11-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(July!E38:E40,August!E10:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(July!N38:N40,August!N10:N11)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V11)+(0.1932*U11))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U11<=10,U11>=35),0,(EXP(W11))/(1+EXP(W11)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-03"},null,null,"",null,"",{"$f":"IFERROR($H11+$G12,\"\")","v":""},{"$f":"IFERROR($I11+$G12,\"\")","v":""},"",{"$f":"IFERROR($K11+$J12,\"\")","v":""},{"$f":"IFERROR($L11+$J12,\"\")","v":""},null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(July!E39:E40,August!E10:E12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(July!N39:N40,August!N10:N12)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V12)+(0.1932*U12))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-04"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(July!E40,August!E10:E13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(July!N40,August!N10:N13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-05"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E10:E14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N10:N14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-06"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E11:E15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N11:N15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-07"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E12:E16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-08"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-09"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-10"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-11"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-12"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-13"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-14"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-15"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-16"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-17"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-18"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-19"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-20"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-21"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-22"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-23"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-24"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E29:E33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-25"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E30:E34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(-11.4041+(0.0894*V34)+(0.1932*U34))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-26"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E31:E35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-27"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-28"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-29"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-30"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,8,ROW()-9)","v":"2022-08-31"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Monthly Average/Total",{"$f":"IF(ISERROR(AVERAGE($C$10:$C$40)),\"\",AVERAGE($C$10:$C$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($D$10:$D$40)),\"\",AVERAGE($D$10:$D$40))","v":""},{"$f":"IFERROR(AVERAGE($E$10:$E$40),\"\")","v":""},{"$f":"IF(SUM($F$10:$F$40)=0,\"\",SUM($F$10:$F$40))","v":""},{"$f":"IFERROR(AVERAGE($G$10:$G$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($I$10:$I$40<>\"\"),$I$10:$I$40),LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40)),\"\")","v":""},{"$f":"IFERROR(AVERAGE($J$10:$J$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($L$10:$L$40<>\"\"),$L$10:$L$40),LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40)),\"\")","v":""},{"$f":"IF(SUM($M$10:$M$40)=0,\"\",SUM($M$10:$M$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($N$10:$N$40)),\"\",AVERAGE($N$10:$N$40))","v":""},{"$f":"IF(SUM($O$10:$O$40)=0,\"\",SUM($O$10:$O$40))","v":""},null,null,null,null,{"$f":"SUM($T$10:$T$40)","v":0}]

{"sheet":"September","index":11,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,5,5,10]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255) & \" \" & 'Annual Summary'!$G$7 & \" Weather Stats\"","v":"September 2022 Weather Stats"}]
[]
[]
[null,"Date","Min Air Temp (C)","Max Air Temp (C)","Average Air Temp (C)","Rainfall (mm)","Growth Degree Days","Cumulative GDD (Month)","Cumulative GDD (Year)","Growth Potential","Cumulative GP (Month)","Cumulative GP (Year)","Clipping Yield","Humidity % ","E.T (mm)","Smith Kerns Model","Microdochium Activity ","Anthracnose Activity ","Dollar Spot Activity","GP for C4 Grass","5-day average temp","5-day average humidity","Logit"]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-01"},null,null,{"$f":"IFERROR(AVERAGE($C10,$D10),\"\")","v":""},null,{"$f":"IFERROR(IF(($E10-6)>0,$E10-6,0),\"\")","v":""},{"$f":"IF(ISBLANK($G$10),\"\",$G$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$I$42\") + IF($G$10=\"\",0,$G$10),\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E10-18)/5.5)^2),\"\")","v":""},{"$f":"IF(ISBLANK($J$10),\"\",$J$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$L$42\") + IF($K$10=\"\",0,$K$10),\"\")","v":""},null,null,null,{"$f":"X10","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E10-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(August!E37:E40,September!E10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(August!N37:N40,September!N10)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V10)+(0.1932*U10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U10<=10,U10>=35),0,(EXP(W10))/(1+EXP(W10)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-02"},null,null,{"$f":"IFERROR(AVERAGE($C11,$D11),\"\")","v":""},null,{"$f":"IFERROR(IF(($E11-6)>0,$E11-6,0),\"\")","v":""},{"$f":"IFERROR($H10+$G11,\"\")","v":""},{"$f":"IFERROR($I10+$G11,\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E11-18)/5.5)^2),\"\")","v":""},{"$f":"IFERROR($K10+$J11,\"\")","v":""},{"$f":"IFERROR($L10+$J11,\"\")","v":""},null,null,null,{"$f":"X11","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E11-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(August!E38:E40,September!E10:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(August!N38:N40,September!N10:N11)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V11)+(0.1932*U11))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U11<=10,U11>=35),0,(EXP(W11))/(1+EXP(W11)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-03"},null,null,"",null,"",{"$f":"IFERROR($H11+$G12,\"\")","v":""},{"$f":"IFERROR($I11+$G12,\"\")","v":""},"",{"$f":"IFERROR($K11+$J12,\"\")","v":""},{"$f":"IFERROR($L11+$J12,\"\")","v":""},null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(August!E39:E40,September!E10:E12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(August!N39:N40,September!N10:N12)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V12)+(0.1932*U12))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-04"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(August!E40,September!E10:E13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(August!N40,September!N10:N13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-05"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E10:E14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N10:N14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-06"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E11:E15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N11:N15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-07"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E12:E16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-08"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-09"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-10"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-11"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-12"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-13"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-14"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-15"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-16"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-17"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-18"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-19"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-20"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-21"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-22"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-23"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-24"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E29:E33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-25"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E30:E34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(-11.4041+(0.0894*V34)+(0.1932*U34))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-26"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E31:E35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-27"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-28"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-29"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,9,ROW()-9)","v":"2022-09-30"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[null,"Monthly Average/Total",{"$f":"IF(ISERROR(AVERAGE($C$10:$C$40)),\"\",AVERAGE($C$10:$C$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($D$10:$D$40)),\"\",AVERAGE($D$10:$D$40))","v":""},{"$f":"IFERROR(AVERAGE($E$10:$E$40),\"\")","v":""},{"$f":"IF(SUM($F$10:$F$40)=0,\"\",SUM($F$10:$F$40))","v":""},{"$f":"IFERROR(AVERAGE($G$10:$G$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($I$10:$I$40<>\"\"),$I$10:$I$40),LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40)),\"\")","v":""},{"$f":"IFERROR(AVERAGE($J$10:$J$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($L$10:$L$40<>\"\"),$L$10:$L$40),LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40)),\"\")","v":""},{"$f":"IF(SUM($M$10:$M$40)=0,\"\",SUM($M$10:$M$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($N$10:$N$40)),\"\",AVERAGE($N$10:$N$40))","v":""},{"$f":"IF(SUM($O$10:$O$40)=0,\"\",SUM($O$10:$O$40))","v":""},null,null,null,null,{"$f":"SUM($T$10:$T$40)","v":0}]

{"sheet":"October","index":12,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,5,5,10]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255) & \" \" & 'Annual Summary'!$G$7 & \" Weather Stats\"","v":"October 2022 Weather Stats"}]
[]
[]
[null,"Date","Min Air Temp (C)","Max Air Temp (C)","Average Air Temp (C)","Rainfall (mm)","Growth Degree Days","Cumulative GDD (Month)","Cumulative GDD (Year)","Growth Potential","Cumulative GP (Month)","Cumulative GP (Year)","Clipping Yield","Humidity % ","E.T (mm)","Smith Kerns Model","Microdochium Activity ","Anthracnose Activity ","Dollar Spot Activity","GP for C4 Grass","5-day average temp","5-day average humidity","Logit"]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-01"},null,null,{"$f":"IFERROR(AVERAGE($C10,$D10),\"\")","v":""},null,{"$f":"IFERROR(IF(($E10-6)>0,$E10-6,0),\"\")","v":""},{"$f":"IF(ISBLANK($G$10),\"\",$G$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$I$42\") + IF($G$10=\"\",0,$G$10),\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E10-18)/5.5)^2),\"\")","v":""},{"$f":"IF(ISBLANK($J$10),\"\",$J$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$L$42\") + IF($K$10=\"\",0,$K$10),\"\")","v":""},null,null,null,{"$f":"X10","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E10-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(September!E37:E40,October!E10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(September!N37:N40,October!N10)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V10)+(0.1932*U10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U10<=10,U10>=35),0,(EXP(W10))/(1+EXP(W10)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-02"},null,null,{"$f":"IFERROR(AVERAGE($C11,$D11),\"\")","v":""},null,{"$f":"IFERROR(IF(($E11-6)>0,$E11-6,0),\"\")","v":""},{"$f":"IFERROR($H10+$G11,\"\")","v":""},{"$f":"IFERROR($I10+$G11,\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E11-18)/5.5)^2),\"\")","v":""},{"$f":"IFERROR($K10+$J11,\"\")","v":""},{"$f":"IFERROR($L10+$J11,\"\")","v":""},null,null,null,{"$f":"X11","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E11-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(September!E38:E40,October!E10:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(September!N38:N40,October!N10:N11)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V11)+(0.1932*U11))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U11<=10,U11>=35),0,(EXP(W11))/(1+EXP(W11)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-03"},null,null,"",null,"",{"$f":"IFERROR($H11+$G12,\"\")","v":""},{"$f":"IFERROR($I11+$G12,\"\")","v":""},"",{"$f":"IFERROR($K11+$J12,\"\")","v":""},{"$f":"IFERROR($L11+$J12,\"\")","v":""},null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(September!E39:E40,October!E10:E12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(September!N39:N40,October!N10:N12)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V12)+(0.1932*U12))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-04"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(September!E40,October!E10:E13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(September!N40,October!N10:N13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-05"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E10:E14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N10:N14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-06"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E11:E15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N11:N15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-07"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E12:E16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-08"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-09"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-10"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-11"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-12"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-13"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-14"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-15"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-16"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-17"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-18"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-19"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-20"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-21"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-22"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-23"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-24"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E29:E33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-25"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E30:E34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(-11.4041+(0.0894*V34)+(0.1932*U34))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-26"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E31:E35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-27"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-28"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-29"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-30"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,10,ROW()-9)","v":"2022-10-31"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E36:E40)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N36:N40)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V40)+(0.1932*U40))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U40<=10,U40>=35),0,(EXP(W40))/(1+EXP(W40)))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Monthly Average/Total",{"$f":"IF(ISERROR(AVERAGE($C$10:$C$40)),\"\",AVERAGE($C$10:$C$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($D$10:$D$40)),\"\",AVERAGE($D$10:$D$40))","v":""},{"$f":"IFERROR(AVERAGE($E$10:$E$40),\"\")","v":""},{"$f":"IF(SUM($F$10:$F$40)=0,\"\",SUM($F$10:$F$40))","v":""},{"$f":"IFERROR(AVERAGE($G$10:$G$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($I$10:$I$40<>\"\"),$I$10:$I$40),LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40)),\"\")","v":""},{"$f":"IFERROR(AVERAGE($J$10:$J$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($L$10:$L$40<>\"\"),$L$10:$L$40),LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40)),\"\")","v":""},{"$f":"IF(SUM($M$10:$M$40)=0,\"\",SUM($M$10:$M$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($N$10:$N$40)),\"\",AVERAGE($N$10:$N$40))","v":""},{"$f":"IF(SUM($O$10:$O$40)=0,\"\",SUM($O$10:$O$40))","v":""},null,null,null,null,{"$f":"SUM($T$10:$T$40)","v":0}]

{"sheet":"November","index":13,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,5,5,10]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255) & \" \" & 'Annual Summary'!$G$7 & \" Weather Stats\"","v":"November 2022 Weather Stats"}]
[]
[]
[null,"Date","Min Air Temp (C)","Max Air Temp (C)","Average Air Temp (C)","Rainfall (mm)","Growth Degree Days","Cumulative GDD (Month)","Cumulative GDD (Year)","Growth Potential","Cumulative GP (Month)","Cumulative GP (Year)","Clipping Yield","Humidity % ","E.T (mm)","Smith Kerns Model","Microdochium Activity ","Anthracnose Activity ","Dollar Spot Activity","GP for C4 Grass","5-day average temp","5-day average humidity","Logit"]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-01"},null,null,{"$f":"IFERROR(AVERAGE($C10,$D10),\"\")","v":""},null,{"$f":"IFERROR(IF(($E10-6)>0,$E10-6,0),\"\")","v":""},{"$f":"IF(ISBLANK($G$10),\"\",$G$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$I$42\") + IF($G$10=\"\",0,$G$10),\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E10-18)/5.5)^2),\"\")","v":""},{"$f":"IF(ISBLANK($J$10),\"\",$J$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$L$42\") + IF($K$10=\"\",0,$K$10),\"\")","v":""},null,null,null,{"$f":"X10","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E10-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(October!E37:E40,November!E10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(October!N37:N40,November!N10)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V10)+(0.1932*U10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U10<=10,U10>=35),0,(EXP(W10))/(1+EXP(W10)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-02"},null,null,{"$f":"IFERROR(AVERAGE($C11,$D11),\"\")","v":""},null,{"$f":"IFERROR(IF(($E11-6)>0,$E11-6,0),\"\")","v":""},{"$f":"IFERROR($H10+$G11,\"\")","v":""},{"$f":"IFERROR($I10+$G11,\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E11-18)/5.5)^2),\"\")","v":""},{"$f":"IFERROR($K10+$J11,\"\")","v":""},{"$f":"IFERROR($L10+$J11,\"\")","v":""},null,null,null,{"$f":"X11","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E11-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(October!E38:E40,November!E10:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(October!N38:N40,November!N10:N11)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V11)+(0.1932*U11))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U11<=10,U11>=35),0,(EXP(W11))/(1+EXP(W11)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-03"},null,null,"",null,"",{"$f":"IFERROR($H11+$G12,\"\")","v":""},{"$f":"IFERROR($I11+$G12,\"\")","v":""},"",{"$f":"IFERROR($K11+$J12,\"\")","v":""},{"$f":"IFERROR($L11+$J12,\"\")","v":""},null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(October!E39:E40,November!E10:E12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(October!N39:N40,November!N10:N12)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V12)+(0.1932*U12))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-04"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(October!E40,November!E10:E13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(October!N40,November!N10:N13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-05"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E10:E14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N10:N14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-06"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E11:E15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N11:N15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-07"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E12:E16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-08"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-09"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-10"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-11"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-12"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-13"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-14"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-15"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-16"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-17"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-18"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-19"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-20"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-21"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-22"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-23"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-24"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E29:E33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-25"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E30:E34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(-11.4041+(0.0894*V34)+(0.1932*U34))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-26"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E31:E35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-27"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-28"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-29"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,11,ROW()-9)","v":"2022-11-30"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Monthly Average/Total",{"$f":"IF(ISERROR(AVERAGE($C$10:$C$40)),\"\",AVERAGE($C$10:$C$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($D$10:$D$40)),\"\",AVERAGE($D$10:$D$40))","v":""},{"$f":"IFERROR(AVERAGE($E$10:$E$40),\"\")","v":""},{"$f":"IF(SUM($F$10:$F$40)=0,\"\",SUM($F$10:$F$40))","v":""},{"$f":"IFERROR(AVERAGE($G$10:$G$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($I$10:$I$40<>\"\"),$I$10:$I$40),LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40)),\"\")","v":""},{"$f":"IFERROR(AVERAGE($J$10:$J$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($L$10:$L$40<>\"\"),$L$10:$L$40),LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40)),\"\")","v":""},{"$f":"IF(SUM($M$10:$M$40)=0,\"\",SUM($M$10:$M$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($N$10:$N$40)),\"\",AVERAGE($N$10:$N$40))","v":""},{"$f":"IF(SUM($O$10:$O$40)=0,\"\",SUM($O$10:$O$40))","v":""},null,null,null,null,{"$f":"SUM($T$10:$T$40)","v":0}]

{"sheet":"December","index":14,"n_rows":42,"n_cols":24,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,5,5,10]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255) & \" \" & 'Annual Summary'!$G$7 & \" Weather Stats\"","v":"December 2022 Weather Stats"}]
[]
[]
[null,"Date","Min Air Temp (C)","Max Air Temp (C)","Average Air Temp (C)","Rainfall (mm)","Growth Degree Days","Cumulative GDD (Month)","Cumulative GDD (Year)","Growth Potential","Cumulative GP (Month)","Cumulative GP (Year)","Clipping Yield","Humidity % ","E.T (mm)","Smith Kerns Model","Microdochium Activity ","Anthracnose Activity ","Dollar Spot Activity","GP for C4 Grass","5-day average temp","5-day average humidity","Logit"]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-01"},null,null,{"$f":"IFERROR(AVERAGE($C10,$D10),\"\")","v":""},null,{"$f":"IFERROR(IF(($E10-6)>0,$E10-6,0),\"\")","v":""},{"$f":"IF(ISBLANK($G$10),\"\",$G$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$I$42\") + IF($G$10=\"\",0,$G$10),\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E10-18)/5.5)^2),\"\")","v":""},{"$f":"IF(ISBLANK($J$10),\"\",$J$10)","v":""},{"$f":"IFERROR(INDIRECT(TEXT(DATE('Annual Summary'!$G$7,MONTH($B10)-1,1),\"mmmm\") &\"!$L$42\") + IF($K$10=\"\",0,$K$10),\"\")","v":""},null,null,null,{"$f":"X10","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E10-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(November!E37:E40,December!E10)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(November!N37:N40,December!N10)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V10)+(0.1932*U10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U10<=10,U10>=35),0,(EXP(W10))/(1+EXP(W10)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-02"},null,null,{"$f":"IFERROR(AVERAGE($C11,$D11),\"\")","v":""},null,{"$f":"IFERROR(IF(($E11-6)>0,$E11-6,0),\"\")","v":""},{"$f":"IFERROR($H10+$G11,\"\")","v":""},{"$f":"IFERROR($I10+$G11,\"\")","v":""},{"$f":"IFERROR(2.71828^(-0.5*(($E11-18)/5.5)^2),\"\")","v":""},{"$f":"IFERROR($K10+$J11,\"\")","v":""},{"$f":"IFERROR($L10+$J11,\"\")","v":""},null,null,null,{"$f":"X11","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IFERROR(2.71828^(-0.5*(($E11-31)/7.3)^2),\"\")","v":""},{"$f":"AVERAGE(November!E38:E40,December!E10:E11)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(November!N38:N40,December!N10:N11)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V11)+(0.1932*U11))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(U11<=10,U11>=35),0,(EXP(W11))/(1+EXP(W11)))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-03"},null,null,"",null,"",{"$f":"IFERROR($H11+$G12,\"\")","v":""},{"$f":"IFERROR($I11+$G12,\"\")","v":""},"",{"$f":"IFERROR($K11+$J12,\"\")","v":""},{"$f":"IFERROR($L11+$J12,\"\")","v":""},null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(November!E39:E40,December!E10:E12)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(November!N39:N40,December!N10:N12)","v":{"$error":"#DIV/0!"}},{"$f":"(-11.4041+(0.0894*V12)+(0.1932*U12))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-04"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(November!E40,December!E10:E13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(November!N40,December!N10:N13)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-05"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E10:E14)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N10:N14)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-06"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E11:E15)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N11:N15)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-07"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E12:E16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-08"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-09"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-10"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-11"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-12"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-13"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-14"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-15"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-16"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-17"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-18"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-19"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-20"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-21"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-22"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-23"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-24"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E29:E33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-25"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E30:E34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(-11.4041+(0.0894*V34)+(0.1932*U34))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-26"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$f":"AVERAGE(E31:E35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-27"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-28"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-29"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-30"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"DATE('Annual Summary'!$G$7,12,ROW()-9)","v":"2022-12-31"},null,null,"",null,"","","","","","",null,null,null,{"$error":"#DIV/0!"},null,null,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Monthly Average/Total",{"$f":"IF(ISERROR(AVERAGE($C$10:$C$40)),\"\",AVERAGE($C$10:$C$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($D$10:$D$40)),\"\",AVERAGE($D$10:$D$40))","v":""},{"$f":"IFERROR(AVERAGE($E$10:$E$40),\"\")","v":""},{"$f":"IF(SUM($F$10:$F$40)=0,\"\",SUM($F$10:$F$40))","v":""},{"$f":"IFERROR(AVERAGE($G$10:$G$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($I$10:$I$40<>\"\"),$I$10:$I$40),LOOKUP(2,1/($H$10:$H$40<>\"\"),$H$10:$H$40)),\"\")","v":""},{"$f":"IFERROR(AVERAGE($J$10:$J$40),\"\")","v":""},{"$f":"IFERROR(LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40),\"\")","v":""},{"$f":"_xlfn.IFNA(IFERROR(LOOKUP(2,1/($L$10:$L$40<>\"\"),$L$10:$L$40),LOOKUP(2,1/($K$10:$K$40<>\"\"),$K$10:$K$40)),\"\")","v":""},{"$f":"IF(SUM($M$10:$M$40)=0,\"\",SUM($M$10:$M$40))","v":""},{"$f":"IF(ISERROR(AVERAGE($N$10:$N$40)),\"\",AVERAGE($N$10:$N$40))","v":""},{"$f":"IF(SUM($O$10:$O$40)=0,\"\",SUM($O$10:$O$40))","v":""},null,null,null,null,{"$f":"SUM($T$10:$T$40)","v":0}]