{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["AUTO FORM","LINKS-FLUSIG","OPEN-FLUSIG"],"not_rendered":{"macros":1,"external_links":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"AUTO FORM","index":0,"n_rows":27,"n_cols":14,"rows_kept":27,"merged":[[2,2,2,6],[2,10,2,13],[4,10,4,13],[11,10,11,13],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[26,2,29,6]]}
[]
[]
[null,null,"FERTILISER AND SPRAYING AUTO FORM V.1",{"$nulls":7},"Ressources"]
[]
[null,null,"Date","2022-01-04",null,"Name","Erwan Le cocq",{"$nulls":3},"Add new ressources:"]
[]
[null,null,"Course","OPEN",null,"Spraying or Fert?","Spraying",{"$nulls":3},"Add a new course"]
[{"$nulls":10},"Add a new area"]
[null,null,"Area sprayed","Surface",{"$nulls":6},"Add new area to the DR"]
[null,null,"Zone 1",{"$f":"IFERROR(_xlfn.SWITCH($D$7,$M$21,_xlfn.IFS(C10=$K$14,$L$14,C10=$K$15,$L$15,C10=$K$16,$L$16,C10=$K$17,$L$17,C10=$K$18,$L$18),$M$22,_xlfn.IFS(C10=$K$14,$M$14,C10=$K$15,$M$15,C10=$K$16,$M$16,C10=$K$17,$M$17,C10=$K$18,$M$18),$M$23,_xlfn.IFS(C10=$K$14,$N$14,C10=$K$15,$N$15,C10=$K$16,$N$16,C10=$K$17,$N$17,C10=$K$18,$N$18),$M$24,_xlfn.IFS(C10=$K$21,$L$21,C10=$K$22,$L$22,C10=$K$23,$L$23,C10=$K$24,$L$24,C10=$K$25,$L$25)),\"0\")","v":"0"},{"$nulls":6},"Add a new operator"]
[null,null,"Zone 2",{"$f":"IFERROR(_xlfn.SWITCH($D$7,$M$21,_xlfn.IFS(C11=$K$14,$L$14,C11=$K$15,$L$15,C11=$K$16,$L$16,C11=$K$17,$L$17,C11=$K$18,$L$18),$M$22,_xlfn.IFS(C11=$K$14,$M$14,C11=$K$15,$M$15,C11=$K$16,$M$16,C11=$K$17,$M$17,C11=$K$18,$M$18),$M$23,_xlfn.IFS(C11=$K$14,$N$14,C11=$K$15,$N$15,C11=$K$16,$N$16,C11=$K$17,$N$17,C11=$K$18,$N$18),$M$24,_xlfn.IFS(C11=$K$21,$L$21,C11=$K$22,$L$22,C11=$K$23,$L$23,C11=$K$24,$L$24,C11=$K$25,$L$25)),\"0\")","v":"0"}]
[{"$nulls":3},{"$f":"IFERROR(_xlfn.SWITCH($D$7,$M$21,_xlfn.IFS(C12=$K$14,$L$14,C12=$K$15,$L$15,C12=$K$16,$L$16,C12=$K$17,$L$17,C12=$K$18,$L$18),$M$22,_xlfn.IFS(C12=$K$14,$M$14,C12=$K$15,$M$15,C12=$K$16,$M$16,C12=$K$17,$M$17,C12=$K$18,$M$18),$M$23,_xlfn.IFS(C12=$K$14,$N$14,C12=$K$15,$N$15,C12=$K$16,$N$16,C12=$K$17,$N$17,C12=$K$18,$N$18),$M$24,_xlfn.IFS(C12=$K$21,$L$21,C12=$K$22,$L$22,C12=$K$23,$L$23,C12=$K$24,$L$24,C12=$K$25,$L$25)),\"0\")","v":"0"},{"$nulls":6},"Courses and surfaces"]
[{"$nulls":3},{"$f":"IFERROR(_xlfn.SWITCH($D$7,$M$21,_xlfn.IFS(C13=$K$14,$L$14,C13=$K$15,$L$15,C13=$K$16,$L$16,C13=$K$17,$L$17,C13=$K$18,$L$18),$M$22,_xlfn.IFS(C13=$K$14,$M$14,C13=$K$15,$M$15,C13=$K$16,$M$16,C13=$K$17,$M$17,C13=$K$18,$M$18),$M$23,_xlfn.IFS(C13=$K$14,$N$14,C13=$K$15,$N$15,C13=$K$16,$N$16,C13=$K$17,$N$17,C13=$K$18,$N$18),$M$24,_xlfn.IFS(C13=$K$21,$L$21,C13=$K$22,$L$22,C13=$K$23,$L$23,C13=$K$24,$L$24,C13=$K$25,$L$25)),\"0\")","v":"0"},{"$nulls":6},"Surfaces","OPEN","LINKS","KRANICH"]
[null,null,"Total area",{"$f":"SUM(D10:D12)","v":{"v":0,"d":"0.00 Ha"}},{"$nulls":6},"Greens",2,2,0.5]
[{"$nulls":10},"Approches",0.5,1,0]
[null,null,"Products",null,null,"Rate/ha","Total",{"$nulls":3},"Tees",0.5,0.5,0.25]
[null,null,"Produit A",null,null,{"$f":"G17/$D$14","v":{"$error":"#DIV/0!"}},800,{"$nulls":3},"Fairways",8,10,4]
[null,null,"Produit B / Si cette cellule est vide, ne pas continuer de copier",null,null,{"$f":"G18/$D$14","v":{"$error":"#DIV/0!"}},250,{"$nulls":3},"Semi",15,8,0]
[null,null,"Produit C / Idem",null,null,{"$error":"#DIV/0!"},150]
[null,null,"Produit D / Idem…",null,null,{"$error":"#DIV/0!"},250,{"$nulls":3},"Surfaces DR","Driving_Range","Courses","Operator"]
[null,null,"Produit E",null,null,{"$error":"#DIV/0!"},350,{"$nulls":3},"Target greens",1,{"$f":"t_coursesareasize[[#Headers],[OPEN]]","v":"OPEN"},"Erwan Le cocq"]
[null,null,"Produit F",null,null,{"$error":"#DIV/0!"},450,{"$nulls":3},"All tees",1,{"$f":"t_coursesareasize[[#Headers],[LINKS]]","v":"LINKS"},"Stephen Cutt"]
[null,null,"Produit G",null,null,{"$error":"#DIV/0!"},550,{"$nulls":3},"Main deck tees",0.5,{"$f":"t_coursesareasize[[#Headers],[KRANICH]]","v":"KRANICH"},"Phillip Stegeman"]
[null,null,"Produit H",null,null,{"$error":"#DIV/0!"},650,{"$nulls":3},"Landing Zone",6,{"$f":"t_DrivingrangeAreaSurfaces[[#Headers],[Driving_Range]]","v":"Driving_Range"},"Marcin Strybelzki"]
[{"$nulls":10},"Surrounding Area",2]
[null,null,"Note:"]
[null,null,"TEST"]

{"sheet":"LINKS-FLUSIG","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"merged":[[1,1,1,6],[3,1,3,6]]}
[]
[null,"LINKS COURSE / SPRITZBUCH"]
[]
[null,"YEAR 2020"]
[null,"Date","Area","Products","l/ha (kg/ha)","Total","Person"]
[null,"TEST","TEST","TEST","TEST","TEST","TEST"]
[null,"2022-01-04","Approches","Dispatch",{"v":228.57142857142858,"d":"228.57"},800,"Erwan Le cocq"]
[null,"2022-01-04","Zone 1","Produit C / Idem",{"$f":"F8/$D$14","v":{"$error":"#VALUE!"}},150,"Erwan Le cocq"]
[null,"2022-01-04","Zone 1","Produit D / Idem…",{"$error":"#VALUE!"},250,"Erwan Le cocq"]
[null,"2022-01-04","Zone 1","Produit E",{"$error":"#VALUE!"},350,"Erwan Le cocq"]
[null,"2022-01-04","Zone 1","Produit F",{"$error":"#VALUE!"},450,"Erwan Le cocq"]
[null,"2022-01-04","Zone 1","Produit B / Si cette cellule est vide, ne pas continuer de copier",{"$error":"#VALUE!"},250,"Erwan Le cocq"]
[null,"2022-01-04","Zone 1","Produit G",{"$error":"#VALUE!"},550,"Erwan Le cocq"]
[null,"2022-01-04","Zone 1","Produit H",{"$error":"#VALUE!"},650,"Erwan Le cocq"]
[null,"2022-01-04","Zone 2","Produit A",{"$f":"F15/$D$14","v":{"$error":"#VALUE!"}},800,"Erwan Le cocq"]
[null,"2022-01-04","Zone 2","Produit B / Si cette cellule est vide, ne pas continuer de copier",{"$f":"F16/$D$14","v":{"$error":"#VALUE!"}},250,"Erwan Le cocq"]
[null,"2022-01-04","Zone 2","Produit C / Idem",{"$error":"#VALUE!"},150,"Erwan Le cocq"]
[null,"2022-01-04","Zone 2","Produit D / Idem…",{"$error":"#VALUE!"},250,"Erwan Le cocq"]
[null,"2022-01-04","Zone 2","Produit E",{"$error":"#VALUE!"},350,"Erwan Le cocq"]
[null,"2022-01-04","Zone 2","Produit F",{"$error":"#VALUE!"},450,"Erwan Le cocq"]
[null,"2022-01-04","Zone 2","Produit B / Si cette cellule est vide, ne pas continuer de copier",{"$error":"#VALUE!"},250,"Erwan Le cocq"]
[null,"2022-01-04","Zone 2","Produit G",{"$error":"#VALUE!"},550,"Erwan Le cocq"]
[null,"2022-01-04","Zone 2","Produit H",{"$error":"#VALUE!"},650,"Erwan Le cocq"]

{"sheet":"OPEN-FLUSIG","index":2,"n_rows":6,"n_cols":7,"rows_kept":6,"merged":[[1,1,1,6],[3,1,3,6]]}
[]
[null,"OPEN COURSE / SPRITZBUCH"]
[]
[null,"YEAR 2020"]
[null,"Date","Area","Products","l/ha (kg/ha)","Total","Person"]
[null,"TEST","TEST","TEST","TEST","TEST","TEST"]