{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["REPORT","Summary","1","2","3","4","5","6","7","8","9","10","PRE RIPE","RECEIVING","List"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":1,"defined_names":14,"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":"REPORT","index":0,"n_rows":22,"n_cols":33,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,8,3,8],[1,9,3,9],[1,10,3,10],[1,11,3,11],[1,12,3,12],[1,0,3,0],[1,24,3,24],[21,5,21,15],[1,13,3,13],[1,14,3,14],[1,15,3,15],[2,20,3,20],[2,21,3,21],[2,22,3,22],[2,23,3,23],[1,20,1,23],[20,9,20,13]]}
[]
["Don't Delete Ref Formaula",null,null,null,null,"ROOM","DATE RECEIVED","DATE GASSED","GASSING HOURS","PO #","LABEL","COO","PULP TEMP","SET TEMP","EST.SALE DATE","ROOM STAGE","CORPORATE","PCO","RIPE PLT","SDM","OUTBOUND ORDER",null,null,null,"Ref:Ripening Days Formula"]
[null,"CORPORATE","PCO","RIPE PLT","SDM",null,null,null,null,null,null,null,null,null,null,null,20175355004,20139509003,20033488002,20047209002,"CORPORATE BANANAS","PCO","RIPE PLANTAIN","SDM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qty","Qty","Qty","Qty"]
[{"$f":"U5","v":0},{"$f":"IF(Q5>0,Q$2&U5,\"\")","v":""},{"$f":"IF(R5>0,R$2&V5,\"\")","v":""},{"$f":"IF(S5>0,S$2&W5,\"\")","v":""},{"$f":"IF(T5>0,T$2&X5,\"\")","v":""},"1A",{"$f":"IF(ISBLANK('1'!$N$3),\"\",'1'!$N$3)","v":""},{"$f":"IF(ISBLANK('1'!$N$4),\"\",'1'!$N$4)","v":""},{"$f":"'1'!$G$13","v":0},{"$f":"'1'!$C$5","v":0},{"$f":"'1'!$E$5","v":0},{"$f":"'1'!$H$5","v":0},{"$f":"'1'!$C$13","v":0},{"$f":"'1'!$D$13","v":0},{"$f":"'1'!$N$7","v":0},{"$f":"'1'!$H$13","v":0},{"$f":"'1'!$I$13","v":0},{"$f":"'1'!$J$13","v":0},{"$f":"'1'!$K$13","v":0},{"$f":"'1'!$L$13","v":0},null,null,null,null,{"$f":"IF(AND($J5>0,U5<>\"Northern\"),TODAY()-G5,\"0\")","v":"0"},{"$f":"IF(AND($U5<>0,$U5<>\"Northern\"),\"Add\",\" \")","v":" "}]
[{"$f":"U6","v":0},{"$f":"IF(Q6>0,Q$2&U6,\"\")","v":""},{"$f":"IF(R6>0,R$2&V6,\"\")","v":""},{"$f":"IF(S6>0,S$2&W6,\"\")","v":""},{"$f":"IF(T6>0,T$2&X6,\"\")","v":""},"1B",{"$f":"IF(ISBLANK('1'!$N$5),\"\",'1'!$N$5)","v":"2022-05-28"},{"$f":"IF(ISBLANK('1'!$N$6),\"\",'1'!$N$6)","v":""},{"$f":"'1'!$G$14","v":0},{"$f":"'1'!$C$7","v":0},{"$f":"'1'!$E$7","v":0},{"$f":"'1'!$H$7","v":0},{"$f":"'1'!$C$14","v":58.9},{"$f":"'1'!$D$14","v":0},{"$f":"'1'!$N$8","v":0},{"$f":"'1'!$H$14","v":0},{"$f":"'1'!$I$14","v":0},{"$f":"'1'!$J$14","v":0},{"$f":"'1'!$K$14","v":0},{"$f":"'1'!$L$14","v":0},null,null,null,null,{"$f":"IF(AND($J6>0,U6<>\"Northern\"),TODAY()-G6,\"0\")","v":"0"},{"$f":"IF(AND($U6<>0,$U6<>\"Northern\"),\"Add\",\" \")","v":" "}]
["USE 1ST","CORPORATEUSE 1ST","","","","2A",{"$f":"IF(ISBLANK('2'!$N$3),\"\",'2'!$N$3)","v":"2022-05-25"},{"$f":"IF(ISBLANK('2'!$N$4),\"\",'2'!$N$4)","v":"2022-05-25"},{"$f":"'2'!$G$13","v":72},{"$f":"'2'!$C$5","v":2004504425},{"$f":"'2'!$E$5","v":"DELMONTE"},{"$f":"'2'!$H$5","v":"GUATEMALA"},{"$f":"'2'!$C$13","v":58.9},{"$f":"'2'!$D$13","v":58},{"$f":"'2'!$N$7","v":"SUN"},{"$f":"'2'!$H$13","v":3},{"$f":"'2'!$I$13","v":672},{"$f":"'2'!$J$13","v":0},{"$f":"'2'!$K$13","v":0},{"$f":"'2'!$L$13","v":0},"USE 1ST",null,null,null,{"$f":"IF(AND($J7>0,U7<>\"Northern\"),TODAY()-G7,\"\")","v":4},"Add"]
[",","CORPORATEUSE 2ND","PCOUSE 1ST","RIPE PLTUSE 1ST","SDM","2B",{"$f":"IF(ISBLANK('2'!$N$5),\"\",'2'!$N$5)","v":"2022-05-25"},{"$f":"IF(ISBLANK('2'!$N$6),\"\",'2'!$N$6)","v":"2022-05-25"},{"$f":"'2'!$G$14","v":72},{"$f":"'2'!$C$7","v":2004504432},{"$f":"'2'!$E$7","v":"DELMONTE"},{"$f":"'2'!$H$7","v":"GUATEMALA"},{"$f":"'2'!$C$14","v":61.3},{"$f":"'2'!$D$14","v":60},{"$f":"'2'!$N$8","v":"SUN"},{"$f":"'2'!$H$14","v":2.5},{"$f":"'2'!$I$14","v":528},{"$f":"'2'!$J$14","v":144},{"$f":"'2'!$K$14","v":96},{"$f":"'2'!$L$14","v":45},"USE 2ND","USE 1ST","USE 1ST",null,4,"Add"]
[0,"","","","","3A",{"$f":"IF(ISBLANK('3'!$N$3),\"\",'3'!$N$3)","v":"2022-05-25"},{"$f":"IF(ISBLANK('3'!$N$4),\"\",'3'!$N$4)","v":"2022-05-25"},{"$f":"'3'!$G$13","v":0},{"$f":"'3'!$C$5","v":0},{"$f":"'3'!$E$5","v":0},{"$f":"'3'!$H$5","v":0},{"$f":"'3'!$C$13","v":0},{"$f":"'3'!$D$13","v":0},{"$f":"'3'!$N$7","v":"SUN"},{"$f":"'3'!$H$13","v":0},{"$f":"'3'!$I$13","v":0},{"$f":"'3'!$J$13","v":0},{"$f":"'3'!$K$13","v":0},{"$f":"'3'!$L$13","v":0},null,null,null,null,""," "]
[0,"","","","","3B",{"$f":"IF(ISBLANK('3'!$N$5),\"\",'3'!$N$5)","v":"2022-05-26"},{"$f":"IF(ISBLANK('3'!$N$6),\"\",'3'!$N$6)","v":"2022-05-25"},{"$f":"'3'!$G$14","v":0},{"$f":"'3'!$C$7","v":0},{"$f":"'3'!$E$7","v":0},{"$f":"'3'!$H$7","v":0},{"$f":"'3'!$C$14","v":0},{"$f":"'3'!$D$14","v":0},{"$f":"'3'!$N$8","v":"SUN"},{"$f":"'3'!$H$14","v":0},{"$f":"'3'!$I$14","v":0},{"$f":"'3'!$J$14","v":0},{"$f":"'3'!$K$14","v":0},{"$f":"'3'!$L$14","v":0},null,null,null,null,""," "]
["USE 4TH","CORPORATEUSE 4TH","PCOUSE 2ND","RIPE PLT","","4A",{"$f":"IF(ISBLANK('4'!$N$3),\"\",'4'!$N$3)","v":"2022-05-26"},{"$f":"IF(ISBLANK('4'!$N$5),\"\",'4'!$N$5)","v":"2022-05-27"},{"$f":"'4'!$G$13","v":48},{"$f":"'4'!$C$5","v":2004504433},{"$f":"'4'!$E$5","v":"DELMONTE"},{"$f":"'4'!$H$5","v":"GUATEMALA"},{"$f":"'4'!$C$13","v":62.7},{"$f":"'4'!$D$13","v":62},{"$f":"'4'!$N$7","v":"MON"},{"$f":"'4'!$H$13","v":2},{"$f":"'4'!$I$13","v":624},{"$f":"'4'!$J$13","v":192},{"$f":"'4'!$K$13","v":48},{"$f":"'4'!$L$13","v":0},"USE 4TH","USE 2ND",null,null,3,"Add"]
["                                      ","CORPORATE","","","","4B",{"$f":"IF(ISBLANK('4'!$N$4),\"\",'4'!$N$4)","v":"2022-05-27"},{"$f":"IF(ISBLANK('4'!$N$5),\"\",'4'!$N$5)","v":"2022-05-27"},{"$f":"'4'!$G$14","v":24},{"$f":"'4'!$C$7","v":2004504938},{"$f":"'4'!$E$7","v":"DELMONTE"},{"$f":"'4'!$H$7","v":"GUATEMALA"},{"$f":"'4'!$C$14","v":62.2},{"$f":"'4'!$D$14","v":62},{"$f":"'4'!$N$8","v":"TUE"},{"$f":"'4'!$H$14","v":1},{"$f":"'4'!$I$14","v":960},{"$f":"'4'!$J$14","v":0},{"$f":"'4'!$K$14","v":0},{"$f":"'4'!$L$14","v":0},null,null,null,null,2," "]
["NORTHERN","CORPORATENORTHERN","","","",5,{"$f":"IF(ISBLANK('5'!$N$4),\"\",'5'!$N$4)","v":"2022-05-26"},{"$f":"IF(ISBLANK('5'!$N$5),\"\",'5'!$N$5)","v":"2022-05-26"},{"$f":"'5'!$G$12","v":48},{"$f":"'5'!$C$5","v":2004504426},{"$f":"'5'!$E$5","v":"DELMONTE"},{"$f":"'5'!$H$5","v":"GUATEMALA"},{"$f":"'5'!$C$12","v":61.2},{"$f":"'5'!$D$12","v":61},{"$f":"'5'!$N$6","v":"MON"},{"$f":"'5'!$H$12","v":2},{"$f":"'5'!$I$12","v":960},{"$f":"'5'!$J$12","v":0},{"$f":"'5'!$K$12","v":0},{"$f":"'5'!$L$12","v":0},"NORTHERN",null,null,null,""," "]
[{"$f":"U14","v":0},{"$f":"IF(Q14>0,Q$2&U14,\"\")","v":""},{"$f":"IF(R14>0,R$2&V14,\"\")","v":""},{"$f":"IF(S14>0,S$2&W14,\"\")","v":""},{"$f":"IF(T14>0,T$2&X14,\"\")","v":""},6,{"$f":"IF(ISBLANK('6'!$N$4),\"\",'6'!$N$4)","v":""},{"$f":"IF(ISBLANK('6'!$N$5),\"\",'6'!$N$5)","v":""},{"$f":"'6'!$G$12","v":0},{"$f":"'6'!$C$5","v":0},{"$f":"'6'!$E$5","v":0},{"$f":"'6'!$H$5","v":0},{"$f":"'6'!$C$12","v":0},{"$f":"'6'!$D$12","v":0},{"$f":"'6'!$N$6","v":0},{"$f":"'6'!$H$12","v":0},{"$f":"'6'!$I$12","v":0},{"$f":"'6'!$J$12","v":0},{"$f":"'6'!$K$12","v":0},{"$f":"'6'!$L$12","v":0},null,null,null,null,{"$f":"IF(AND($J14>0,U14<>\"Northern\"),TODAY()-G14,\"0\")","v":"0"}," "]
["USE 3RD","CORPORATEUSE 3RD","","","",7,{"$f":"IF(ISBLANK('7'!$N$4),\"\",'7'!$N$4)","v":"2022-05-27"},{"$f":"IF(ISBLANK('7'!$N$5),\"\",'7'!$N$5)","v":"2022-05-27"},{"$f":"'7'!$G$12","v":24},{"$f":"'7'!$C$5","v":2004505631},{"$f":"'7'!$E$5","v":"CHIQUITA"},{"$f":"'7'!$H$5","v":"GUATEMALA"},{"$f":"'7'!$C$12","v":59.9},{"$f":"'7'!$D$12","v":60},{"$f":"'7'!$N$6","v":"MON"},{"$f":"'7'!$H$12","v":2.5},{"$f":"'7'!$I$12","v":816},{"$f":"'7'!$J$12","v":0},{"$f":"'7'!$K$12","v":0},{"$f":"'7'!$L$12","v":0},"USE 3RD",null,null,null,2,"Add"]
[0,"","","","",8,{"$f":"IF(ISBLANK('8'!$N$4),\"\",'8'!$N$4)","v":""},{"$f":"IF(ISBLANK('8'!$N$5),\"\",'8'!$N$5)","v":""},{"$f":"'8'!$G$12","v":0},{"$f":"'8'!$C$5","v":0},{"$f":"'8'!$E$5","v":0},{"$f":"'8'!$H$5","v":0},{"$f":"'8'!$C$12","v":0},{"$f":"'8'!$D$12","v":0},{"$f":"'8'!$N$6","v":0},{"$f":"'8'!$H$12","v":0},{"$f":"'8'!$I$12","v":0},{"$f":"'8'!$J$12","v":0},{"$f":"'8'!$K$12","v":0},{"$f":"'8'!$L$12","v":0},null,null,null,null,""," "]
[{"$f":"U17","v":"OUT OF SERVICE"},"","","","",9,{"$f":"IF(ISBLANK('9'!$N$4),\"\",'9'!$N$4)","v":""},{"$f":"IF(ISBLANK('9'!$N$5),\"\",'9'!$N$5)","v":""},{"$f":"'9'!$G$12","v":0},{"$f":"'9'!$C$5","v":0},{"$f":"'9'!$E$5","v":0},{"$f":"'9'!$H$5","v":0},{"$f":"'9'!$C$12","v":0},{"$f":"'9'!$D$12","v":0},{"$f":"'9'!$N$6","v":0},{"$f":"'9'!$H$12","v":0},{"$f":"'9'!$I$12","v":0},{"$f":"'9'!$J$12","v":0},{"$f":"'9'!$K$12","v":0},{"$f":"'9'!$L$12","v":0},"OUT OF SERVICE",null,null,null,"","Add"]
[null,"CORPORATE","PCO","","SDM",10,{"$f":"IF(ISBLANK('10'!$N$4),\"\",'10'!$N$4)","v":"2022-05-27"},{"$f":"IF(ISBLANK('10'!$N$5),\"\",'10'!$N$5)","v":"2022-05-27"},{"$f":"'10'!$G$12","v":24},{"$f":"'10'!$C$5","v":2004504945},{"$f":"'10'!$E$5","v":"DELMONTE"},{"$f":"'10'!$H$5","v":"GUATEMALA"},{"$f":"'10'!$C$12","v":62.6},{"$f":"'10'!$D$12","v":62},{"$f":"'10'!$N$6","v":"TUE"},{"$f":"'10'!$H$12","v":1},{"$f":"'10'!$I$12","v":720},{"$f":"'10'!J12","v":144},{"$f":"'10'!K12","v":0},{"$f":"'10'!L12","v":45},null,null,null,null,2," "]
[0,"","","","","PRE1",{"$f":"'PRE RIPE'!$B$7","v":"00:00:00"},null,null,{"$f":"'PRE RIPE'!$C$7","v":0},{"$f":"'PRE RIPE'!$D$7","v":0},{"$f":"'PRE RIPE'!E7","v":0},{"$f":"'PRE RIPE'!F7","v":0},null,null,{"$f":"'PRE RIPE'!G7","v":0},{"$f":"'PRE RIPE'!H7","v":0},{"$f":"'PRE RIPE'!I7","v":0},{"$f":"'PRE RIPE'!J7","v":0},{"$f":"'PRE RIPE'!K7","v":0},null,null,null,null,{"$f":"IF(AND($J19>0,U19<>\"Northern\"),TODAY()-G19,\"0\")","v":"0"}," "]
[0,"","","","","PRE2",{"$f":"'PRE RIPE'!$B$8","v":"00:00:00"},null,null,{"$f":"'PRE RIPE'!$C$8","v":0},{"$f":"'PRE RIPE'!$D$8","v":0},{"$f":"'PRE RIPE'!E8","v":0},{"$f":"'PRE RIPE'!F8","v":0},null,null,{"$f":"'PRE RIPE'!G8","v":0},{"$f":"'PRE RIPE'!H8","v":0},{"$f":"'PRE RIPE'!I8","v":0},{"$f":"'PRE RIPE'!J8","v":0},{"$f":"'PRE RIPE'!K8","v":0},null,null,null,null,{"$f":"IF(AND($J20>0,U20<>\"Northern\"),TODAY()-G20,\"0\")","v":"0"}," "]
[null,null,null,null,null,null,5,null,81,"PRODUCT NOT IN BANANA ROOMS -LEFTOVER",null,null,null,null,{"$f":"TEXT(TODAY(),\"DDD\")","v":"Sun"},{"$f":"Summary!$C$47","v":3},{"$f":"Summary!D47","v":1620},{"$f":"Summary!F47","v":283},{"$f":"Summary!H47","v":81},{"$f":"Summary!J47","v":0},null,null,null,null,{"$f":"IF(Z21=\" \", G21,Z21)","v":4.25},{"$f":"IFERROR(AVERAGEIF(Z5:Z20,\"Add\",Y5:Y20)+1,\" \")","v":4.25},null,null,null,null,null,null,"  "]
[null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q5:Q21)","v":6900},{"$f":"SUM(R5:R21)","v":763},{"$f":"SUM(S5:S21)","v":225},{"$f":"SUM(T5:T21)","v":90}]

{"sheet":"Summary","index":1,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":false,"merged":[[7,7,7,8],[11,7,11,8],[7,9,7,10],[7,11,7,12],[7,13,7,14],[11,9,11,10],[11,11,11,12],[11,13,11,14],[36,0,38,1],[37,14,37,15],[34,0,35,11],[22,7,22,8],[22,11,22,12],[22,13,22,14],[28,7,28,8],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[14,7,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,14],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[16,13,16,14],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[16,7,16,8],[16,9,16,10],[16,11,16,12],[49,2,49,11],[50,0,50,11],[51,0,51,11],[36,2,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[49,0,49,1],[48,0,48,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[40,0,40,1],[41,0,41,1],[37,2,37,3],[37,4,37,5],[37,6,37,7],[37,8,37,9],[37,10,37,11],[36,10,36,11],[45,0,46,1],[27,7,27,8],[25,13,25,14],[26,13,26,14],[22,9,22,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[26,7,26,8],[26,11,26,12],[24,13,24,14],[24,7,24,8],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[0,0,1,4],[15,0,15,4],[8,7,8,8],[9,7,9,8],[10,7,10,8],[12,7,12,8],[4,7,4,8],[5,7,5,8],[0,7,1,14],[2,7,3,8],[2,9,3,10],[2,11,3,12],[2,13,3,14],[8,9,8,10],[8,11,8,12],[9,11,9,12],[10,11,10,12],[12,11,12,12],[8,13,8,14],[9,13,9,14],[10,13,10,14],[12,13,12,14],[9,9,9,10],[10,9,10,10],[12,9,12,10],[16,0,16,4],[15,16,15,17],[37,16,37,17],[39,0,39,1],[37,12,37,13],[4,9,4,10],[5,9,5,10],[6,9,6,10],[4,13,4,14],[5,13,5,14],[6,13,6,14],[4,11,4,12],[5,11,5,12],[6,11,6,12],[6,7,6,8],[14,16,14,17],[29,7,29,8],[24,11,24,12],[25,7,25,8],[25,11,25,12],[20,7,21,14],[16,16,16,17],[17,16,17,17]]}
["FOR QA PLANNING",null,null,null,null,null,null,"SC: Today's Banana Availability"]
[]
["DAY","CORPORATE","PCO","RIPE PLT","SDM",null,null,"BANANA TYPE",null,"# C/S",null,"Ripening Days",null,"Color Stage"]
["MON",{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$4, (REPORT!Q$5:Q$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$4, (REPORT!Q$5:Q$21)),\"\")","v":2400},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$4, (REPORT!R$5:R$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$4, (REPORT!R$5:R$21)),\"\")","v":192},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$4, (REPORT!S$5:S$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$4, (REPORT!S$5:S$21)),\"\")","v":48},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$4, (REPORT!T$5:T$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$4, (REPORT!T$5:T$21)),\"\")","v":""}]
["TUE",{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$5, (REPORT!Q$5:Q$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$5, (REPORT!Q$5:Q$21)),\"\")","v":1680},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$5, (REPORT!R$5:R$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$5, (REPORT!R$5:R$21)),\"\")","v":144},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$5, (REPORT!S$5:S$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$5, (REPORT!S$5:S$21)),\"\")","v":""},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$5, (REPORT!T$5:T$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$5, (REPORT!T$5:T$21)),\"\")","v":45},null,null,"CORPORATE",null,{"$f":"IF(SUMIF(REPORT!$P$5:$P$20,Summary!N5,REPORT!Q$5:Q$20)>0,SUMIF(REPORT!$P$5:$P$20,Summary!N5,REPORT!Q$5:Q$20),\"\")","v":672},null,{"$f":"(IF(OR(ISBLANK(N5),ISERROR(AVERAGEIF(REPORT!P$5:P$20,Summary!N5,REPORT!Y$5:Y$20))),\"\",AVERAGEIF(REPORT!P$5:P$20,Summary!N5,REPORT!Y$5:Y$20)))","v":4},null,3]
["WED",{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$6, (REPORT!Q$5:Q$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$6, (REPORT!Q$5:Q$21)),\"\")","v":""},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$6, (REPORT!R$5:R$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$6, (REPORT!R$5:R$21)),\"\")","v":""},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$6, (REPORT!S$5:S$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$6, (REPORT!S$5:S$21)),\"\")","v":""},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$6, (REPORT!T$5:T$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$6, (REPORT!T$5:T$21)),\"\")","v":""},null,null,"CORPORATE",null,{"$f":"IF(SUMIF(REPORT!$P$5:$P$20,Summary!N6,REPORT!Q$5:Q$20)>0,SUMIF(REPORT!$P$5:$P$20,Summary!N6,REPORT!Q$5:Q$20),\"\")","v":1344},null,{"$f":"IF(OR(ISBLANK(N6),ISERROR(AVERAGEIF(REPORT!P$5:P$20,Summary!N6,REPORT!Y$5:Y$20))),\"\",AVERAGEIF(REPORT!P$5:P$20,Summary!N6,REPORT!Y$5:Y$20))","v":3},null,2.5]
["THU",{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$7, (REPORT!Q$5:Q$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$7, (REPORT!Q$5:Q$21)),\"\")","v":""},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$7, (REPORT!R$5:R$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$7, (REPORT!R$5:R$21)),\"\")","v":""},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$7, (REPORT!S$5:S$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$7, (REPORT!S$5:S$21)),\"\")","v":""},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$7, (REPORT!T$5:T$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$7, (REPORT!T$5:T$21)),\"\")","v":""},null,null,"CORPORATE",null,{"$f":"IF(SUMIF(REPORT!$P$5:$P$20,Summary!N7,REPORT!Q$5:Q$20)>0,SUMIF(REPORT!$P$5:$P$20,Summary!N7,REPORT!Q$5:Q$20),\"\")","v":""},null,{"$f":"IF(OR(ISBLANK(N7),ISERROR(AVERAGEIF(REPORT!P$5:P$20,Summary!N7,REPORT!Y$5:Y$20))),\"\",AVERAGEIF(REPORT!P$5:P$20,Summary!N7,REPORT!Y$5:Y$20))","v":""}]
[null,null,null,null,null,null,null,"CORPORATE (Staging LN)",null,{"$f":"$D$47","v":1620},null,{"$f":"REPORT!$Y$21","v":4.25},null,{"$f":"$C$47","v":3}]
["FRI",{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$9, (REPORT!Q$5:Q$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$9, (REPORT!Q$5:Q$21)),\"\")","v":""},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$9, (REPORT!R$5:R$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$9, (REPORT!R$5:R$21)),\"\")","v":""},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$9, (REPORT!S$5:S$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$9, (REPORT!S$5:S$21)),\"\")","v":""},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$9, (REPORT!T$5:T$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$9, (REPORT!T$5:T$21)),\"\")","v":""},null,null,"PCO",null,{"$f":"IF(SUMIF(REPORT!$P$5:$P$20,Summary!N9,REPORT!R$5:R$20)>0,SUMIF(REPORT!$P$5:$P$20,Summary!N9,REPORT!R$5:R$20),\"\")","v":""},null,{"$f":"IF(OR(ISBLANK(N9),ISERROR(AVERAGEIF(REPORT!P$5:P$20,Summary!N9,REPORT!Y$5:Y$20))),\"\",AVERAGEIF(REPORT!P$5:P$20,Summary!N9,REPORT!Y$5:Y$20))","v":4},null,3]
["SAT",{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$10, (REPORT!Q$5:Q$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$10, (REPORT!Q$5:Q$21)),\"\")","v":""},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$10, (REPORT!R$5:R$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$10, (REPORT!R$5:R$21)),\"\")","v":""},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$10, (REPORT!S$5:S$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$10, (REPORT!S$5:S$21)),\"\")","v":""},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$10, (REPORT!T$5:T$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$10, (REPORT!T$5:T$21)),\"\")","v":""},null,null,"PCO",null,{"$f":"IF(SUMIF(REPORT!$P$5:$P$20,Summary!N10,REPORT!R$5:R$20)>0,SUMIF(REPORT!$P$5:$P$20,Summary!N10,REPORT!R$5:R$20),\"\")","v":144},null,{"$f":"IF(OR(ISBLANK(N10),ISERROR(AVERAGEIF(REPORT!P$5:P$21,Summary!N10,REPORT!Y$5:Y$21))),\"\",AVERAGEIF(REPORT!P$5:P$21,Summary!N10,REPORT!Y$5:Y$21))","v":3},null,2.5]
["SUN",{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$11, (REPORT!Q$5:Q$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$11, (REPORT!Q$5:Q$21)),\"\")","v":2820},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$11, (REPORT!R$5:R$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$11, (REPORT!R$5:R$21)),\"\")","v":427},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$11, (REPORT!S$5:S$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$11, (REPORT!S$5:S$21)),\"\")","v":177},{"$f":"IF(SUMIF(REPORT!$O$5:$O$21,$A$11, (REPORT!T$5:T$21))>0,SUMIF(REPORT!$O$5:$O$21,$A$11, (REPORT!T$5:T$21)),\"\")","v":45},null,null,"PCO",null,{"$f":"IF(SUMIF(REPORT!$P$5:$P$20,Summary!N11,REPORT!R$5:R$20)>0,SUMIF(REPORT!$P$5:$P$20,Summary!N11,REPORT!R$5:R$20),\"\")","v":""},null,{"$f":"IF(OR(ISBLANK(N11),ISERROR(AVERAGEIF(REPORT!P$5:P$21,Summary!N11,REPORT!Y$5:Y$21))),\"\",AVERAGEIF(REPORT!P$5:P$21,Summary!N11,REPORT!Y$5:Y$21))","v":""}]
[null,null,null,null,null,null,null,"PCO (Staging LN)",null,{"$f":"$F$47","v":283},null,{"$f":"REPORT!$Y$21","v":4.25},null,{"$f":"$E$47","v":3}]
["Total",{"$f":"SUM(B4:B11)","v":6900},763,225,90,null,null,"RIPE PLANTAIN",null,{"$f":"IF(SUMIF(REPORT!$P$5:$P$20,Summary!N13,REPORT!S$5:S$20)>0,SUMIF(REPORT!$P$5:$P$20,Summary!N13,REPORT!S$5:S$20),\"\")","v":96},null,{"$f":"IF(OR(ISBLANK(N13),ISERROR(AVERAGEIF(REPORT!P$5:P$21,Summary!N13,REPORT!Y$5:Y$21))),\"\",AVERAGEIF(REPORT!P$5:P$21,Summary!N13,REPORT!Y$5:Y$21))","v":3},null,2.5]
[null,null,null,null,null,null,null,"RIPE PLANTAIN",null,{"$f":"IF(SUMIF(REPORT!$P$5:$P$20,Summary!N14,REPORT!S$5:S$20)>0,SUMIF(REPORT!$P$5:$P$20,Summary!N14,REPORT!S$5:S$20),\"\")","v":""},null,{"$f":"IF(OR(ISBLANK(N14),ISERROR(AVERAGEIF(REPORT!P$5:P$21,Summary!N14,REPORT!Y$5:Y$21))),\"\",AVERAGEIF(REPORT!P$5:P$21,Summary!N14,REPORT!Y$5:Y$21))","v":""}]
[null,null,null,null,null,null,null,"RIPE PL (Staging LN)",null,{"$f":"$H$47","v":81},null,{"$f":"$G$47","v":3},null,{"$f":"$G$47","v":3}]
["Banana Daily report Summary",null,null,null,null,null,null,"SDM",null,{"$f":"IF(SUMIF(REPORT!$P$5:$P$20,Summary!N16,REPORT!T$5:T$20)>0,SUMIF(REPORT!$P$5:$P$20,Summary!N16,REPORT!T$5:T$20),\"\")","v":45},null,{"$f":"IF(OR(ISBLANK(N16),ISERROR(AVERAGEIF(REPORT!P$5:P$21,Summary!N16,REPORT!Y$5:Y$21))),\"\",AVERAGEIF(REPORT!P$5:P$21,Summary!N16,REPORT!Y$5:Y$21))","v":3},null,2.5]
[{"$f":"TODAY()","v":"2022-05-29"},null,null,null,null,null,null,"SDM",null,{"$f":"IF(SUMIF(REPORT!$P$5:$P$20,Summary!N17,REPORT!T$5:T$20)>0,SUMIF(REPORT!$P$5:$P$20,Summary!N17,REPORT!T$5:T$20),\"\")","v":""},null,{"$f":"IF(OR(ISBLANK(N17),ISERROR(AVERAGEIF(REPORT!P$5:P$21,Summary!N17,REPORT!Y$5:Y$21))),\"\",AVERAGEIF(REPORT!P$5:P$21,Summary!N17,REPORT!Y$5:Y$21))","v":""}]
["HR.","CORPORATE","PCO","RIPE PLT","SDM",null,null,"SDM (Staging LN)",null,{"$f":"$J$47","v":0},null,{"$f":"IF(OR(ISBLANK(N18),ISERROR(AVERAGEIF(REPORT!P$5:P$21,Summary!N18,REPORT!Y$5:Y$21))),\"\",AVERAGEIF(REPORT!P$5:P$21,Summary!N18,REPORT!Y$5:Y$21))","v":""},null,{"$f":"$I$47","v":0}]
["0-59",{"$f":"IF(SUMIFS(REPORT!Q$5:Q$21, REPORT!$I$5:$I$21,\">=0\",REPORT!$I$5:$I$21,\"<=59\")>0,SUMIFS(REPORT!Q$5:Q$21, REPORT!$I$5:$I$21,\">=0\",REPORT!$I$5:$I$21,\"<=59\"),\"\")","v":4080},{"$f":"IF(SUMIFS(REPORT!R$5:R$21, REPORT!$I$5:$I$21,\">=0\",REPORT!$I$5:$I$21,\"<=59\")>0,SUMIFS(REPORT!R$5:R$21, REPORT!$I$5:$I$21,\">=0\",REPORT!$I$5:$I$21,\"<=59\"),\"\")","v":336},{"$f":"IF(SUMIFS(REPORT!S$5:S$21, REPORT!$I$5:$I$21,\">=0\",REPORT!$I$5:$I$21,\"<=59\")>0,SUMIFS(REPORT!S$5:S$21, REPORT!$I$5:$I$21,\">=0\",REPORT!$I$5:$I$21,\"<=59\"),\"\")","v":48},{"$f":"IF(SUMIFS(REPORT!T$5:T$21, REPORT!$I$5:$I$21,\">=0\",REPORT!$I$5:$I$21,\"<=59\")>0,SUMIFS(REPORT!T$5:T$21, REPORT!$I$5:$I$21,\">=0\",REPORT!$I$5:$I$21,\"<=59\"),\"\")","v":45}]
["60-79",{"$f":"IF(SUMIFS(REPORT!Q$5:Q$21, REPORT!$I$5:$I$21,\">=60\",REPORT!$I$5:$I$21,\"<=79\")>0,SUMIFS(REPORT!Q$5:Q$21, REPORT!$I$5:$I$21,\">=60\",REPORT!$I$5:$I$21,\"<=79\"),\"\")","v":1200},{"$f":"IF(SUMIFS(REPORT!R$5:R$21, REPORT!$I$5:$I$21,\">=60\",REPORT!$I$5:$I$21,\"<=79\")>0,SUMIFS(REPORT!R$5:R$21, REPORT!$I$5:$I$21,\">=60\",REPORT!$I$5:$I$21,\"<=79\"),\"\")","v":144},{"$f":"IF(SUMIFS(REPORT!S$5:S$21, REPORT!$I$5:$I$21,\">=60\",REPORT!$I$5:$I$21,\"<=79\")>0,SUMIFS(REPORT!S$5:S$21, REPORT!$I$5:$I$21,\">=60\",REPORT!$I$5:$I$21,\"<=79\"),\"\")","v":96},{"$f":"IF(SUMIFS(REPORT!T$5:T$21, REPORT!$I$5:$I$21,\">=60\",REPORT!$I$5:$I$21,\"<=79\")>0,SUMIFS(REPORT!T$5:T$21, REPORT!$I$5:$I$21,\">=60\",REPORT!$I$5:$I$21,\"<=79\"),\"\")","v":45}]
["81-100",{"$f":"IF(SUMIFS(REPORT!Q$5:Q$21, REPORT!$I$5:$I$21,\">=81\",REPORT!$I$5:$I$21,\"<=100\")>0,SUMIFS(REPORT!Q$5:Q$21, REPORT!$I$5:$I$21,\">=81\",REPORT!$I$5:$I$21,\"<=100\"),\"\")","v":1620},{"$f":"IF(SUMIFS(REPORT!R$5:R$21, REPORT!$I$5:$I$21,\">=81\",REPORT!$I$5:$I$21,\"<=100\")>0,SUMIFS(REPORT!R$5:R$21, REPORT!$I$5:$I$21,\">=81\",REPORT!$I$5:$I$21,\"<=100\"),\"\")","v":283},{"$f":"IF(SUMIFS(REPORT!S$5:S$21, REPORT!$I$5:$I$21,\">=81\",REPORT!$I$5:$I$21,\"<=100\")>0,SUMIFS(REPORT!S$5:S$21, REPORT!$I$5:$I$21,\">=81\",REPORT!$I$5:$I$21,\"<=100\"),\"\")","v":81},{"$f":"IF(SUMIFS(REPORT!T$5:T$21, REPORT!$I$5:$I$21,\">=81\",REPORT!$I$5:$I$21,\"<=100\")>0,SUMIFS(REPORT!T$5:T$21, REPORT!$I$5:$I$21,\">=81\",REPORT!$I$5:$I$21,\"<=100\"),\"\")","v":""},null,null,"Sales Forecasting"]
["101-130+",{"$f":"IF(SUMIFS(REPORT!Q$5:Q$21, REPORT!$I$5:$I$21,\">=101\")>0,SUMIFS(REPORT!Q$5:Q$21, REPORT!$I$5:$I$21,\">=101\"),\"\")","v":""},{"$f":"IF(SUMIFS(REPORT!R$5:R$21, REPORT!$I$5:$I$21,\">=101\")>0,SUMIFS(REPORT!R$5:R$21, REPORT!$I$5:$I$21,\">=101\"),\"\")","v":""},{"$f":"IF(SUMIFS(REPORT!S$5:S$21, REPORT!$I$5:$I$21,\">=101\")>0,SUMIFS(REPORT!S$5:S$21, REPORT!$I$5:$I$21,\">=101\"),\"\")","v":""},{"$f":"IF(SUMIFS(REPORT!T$5:T$21, REPORT!$I$5:$I$21,\">=101\")>0,SUMIFS(REPORT!T$5:T$21, REPORT!$I$5:$I$21,\">=101\"),\"\")","v":""}]
["Total",{"$f":"SUM(B19:B22)","v":6900},{"$f":"SUM(C19:C22)","v":763},{"$f":"SUM(D19:D22)","v":225},{"$f":"SUM(E19:E22)","v":90},null,null,"SALES",null,"INV",null,"SALES",null,"VARIANCE"]
[null,null,null,null,null,null,null,"CORPORATE",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D49","v":4260},null,null,null,{"$f":"J24-L24","v":4260}]
[null,null,null,null,null,null,null,"PCO",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F49","v":619},null,null,null,{"$f":"J25-L25","v":619}]
["DAY","CORPORATE","PCO","RIPE PLT","SDM",null,null,"RIPE PLT",null,{"$f":"H49","v":177},null,null,null,177]
[1,{"$f":"IF((SUMIFS(REPORT!Q$5:Q$21, REPORT!$P$5:$P$21,$A27)>0),SUMIFS(REPORT!Q$5:Q$21, REPORT!$P$5:$P$21,$A27),\"\")","v":1680},{"$f":"IF((SUMIFS(REPORT!R$5:R$21, REPORT!$P$5:$P$21,$A27)>0),SUMIFS(REPORT!R$5:R$21, REPORT!$P$5:$P$21,$A27),\"\")","v":144},{"$f":"IF((SUMIFS(REPORT!S$5:S$21, REPORT!$P$5:$P$21,$A27)>0),SUMIFS(REPORT!S$5:S$21, REPORT!$P$5:$P$21,$A27),\"\")","v":""},{"$f":"IF((SUMIFS(REPORT!T$5:T$21, REPORT!$P$5:$P$21,$A27)>0),SUMIFS(REPORT!T$5:T$21, REPORT!$P$5:$P$21,$A27),\"\")","v":45},null,null,"SDM",null,{"$f":"J49","v":0},null,null,null,0]
[1.5,{"$f":"IF((SUMIFS(REPORT!Q$5:Q$21, REPORT!$P$5:$P$21,$A28)>0),SUMIFS(REPORT!Q$5:Q$21, REPORT!$P$5:$P$21,$A28),\"\")","v":""},{"$f":"IF((SUMIFS(REPORT!R$5:R$21, REPORT!$P$5:$P$21,$A28)>0),SUMIFS(REPORT!R$5:R$21, REPORT!$P$5:$P$21,$A28),\"\")","v":""},{"$f":"IF((SUMIFS(REPORT!S$5:S$21, REPORT!$P$5:$P$21,$A28)>0),SUMIFS(REPORT!S$5:S$21, REPORT!$P$5:$P$21,$A28),\"\")","v":""},{"$f":"IF((SUMIFS(REPORT!T$5:T$21, REPORT!$P$5:$P$21,$A28)>0),SUMIFS(REPORT!T$5:T$21, REPORT!$P$5:$P$21,$A28),\"\")","v":""}]
[2,{"$f":"IF((SUMIFS(REPORT!Q$5:Q$21, REPORT!$P$5:$P$21,$A29)>0),SUMIFS(REPORT!Q$5:Q$21, REPORT!$P$5:$P$21,$A29),\"\")","v":1584},{"$f":"IF((SUMIFS(REPORT!R$5:R$21, REPORT!$P$5:$P$21,$A29)>0),SUMIFS(REPORT!R$5:R$21, REPORT!$P$5:$P$21,$A29),\"\")","v":192},{"$f":"IF((SUMIFS(REPORT!S$5:S$21, REPORT!$P$5:$P$21,$A29)>0),SUMIFS(REPORT!S$5:S$21, REPORT!$P$5:$P$21,$A29),\"\")","v":48},{"$f":"IF((SUMIFS(REPORT!T$5:T$21, REPORT!$P$5:$P$21,$A29)>0),SUMIFS(REPORT!T$5:T$21, REPORT!$P$5:$P$21,$A29),\"\")","v":""}]
[2.5,{"$f":"IF((SUMIFS(REPORT!Q$5:Q$21, REPORT!$P$5:$P$21,$A30)>0),SUMIFS(REPORT!Q$5:Q$21, REPORT!$P$5:$P$21,$A30),\"\")","v":1344},{"$f":"IF((SUMIFS(REPORT!R$5:R$21, REPORT!$P$5:$P$21,$A30)>0),SUMIFS(REPORT!R$5:R$21, REPORT!$P$5:$P$21,$A30),\"\")","v":144},{"$f":"IF((SUMIFS(REPORT!S$5:S$21, REPORT!$P$5:$P$21,$A30)>0),SUMIFS(REPORT!S$5:S$21, REPORT!$P$5:$P$21,$A30),\"\")","v":96},{"$f":"IF((SUMIFS(REPORT!T$5:T$21, REPORT!$P$5:$P$21,$A30)>0),SUMIFS(REPORT!T$5:T$21, REPORT!$P$5:$P$21,$A30),\"\")","v":45}]
[3,{"$f":"IF((SUMIFS(REPORT!Q$5:Q$21, REPORT!$P$5:$P$21,$A31)>0),SUMIFS(REPORT!Q$5:Q$21, REPORT!$P$5:$P$21,$A31),\"\")","v":2292},{"$f":"IF((SUMIFS(REPORT!R$5:R$21, REPORT!$P$5:$P$21,$A31)>0),SUMIFS(REPORT!R$5:R$21, REPORT!$P$5:$P$21,$A31),\"\")","v":283},{"$f":"IF((SUMIFS(REPORT!S$5:S$21, REPORT!$P$5:$P$21,$A31)>0),SUMIFS(REPORT!S$5:S$21, REPORT!$P$5:$P$21,$A31),\"\")","v":81},{"$f":"IF((SUMIFS(REPORT!T$5:T$21, REPORT!$P$5:$P$21,$A31)>0),SUMIFS(REPORT!T$5:T$21, REPORT!$P$5:$P$21,$A31),\"\")","v":""}]
["4+",{"$f":"IF((SUMIFS(REPORT!Q$5:Q$21, REPORT!$P$5:$P$21,$A32)>0),SUMIFS(REPORT!Q$5:Q$21, REPORT!$P$5:$P$21,$A32),\"\")","v":""},{"$f":"IF((SUMIFS(REPORT!R$5:R$21, REPORT!$P$5:$P$21,$A32)>0),SUMIFS(REPORT!R$5:R$21, REPORT!$P$5:$P$21,$A32),\"\")","v":""},{"$f":"IF((SUMIFS(REPORT!S$5:S$21, REPORT!$P$5:$P$21,$A32)>0),SUMIFS(REPORT!S$5:S$21, REPORT!$P$5:$P$21,$A32),\"\")","v":""},{"$f":"IF((SUMIFS(REPORT!T$5:T$21, REPORT!$P$5:$P$21,$A32)>0),SUMIFS(REPORT!T$5:T$21, REPORT!$P$5:$P$21,$A32),\"\")","v":""}]
["Total",{"$f":"SUM(B27:B32)","v":6900},763,225,90]
[]
["2022-05-29"]
[]
["INFORMATION FOR IC",null,20175355007,null,20139509003,null,20111926003,null,20047209002,null,20175355002]
[null,null,"CORPORATE",null,"PCO",null,"RIPE PLT",null,"SDM",null,"NORTHERN"]
[null,null,"RM#","QTY","RM#","QTY","RM#","QTY","RM#","QTY","RM#","QTY"]
["USE 1ST",null,{"$f":"IF(ISNUMBER(D40),VLOOKUP(C$38&$A40,REPORT!$B$2:$AZ$29,5,0),\"\")","v":"2A"},{"$f":"IF(ISERROR(VLOOKUP(C$38&$A40,REPORT!$B$2:$AZ$29,16,0)),\"\",VLOOKUP(C$38&$A40,REPORT!$B$2:$AZ$29,16,0))","v":672},{"$f":"IF(ISNUMBER(F40),VLOOKUP(E$38&$A40,REPORT!$C$2:$AZ$29,4,0),\"\")","v":"2B"},{"$f":"IF(ISERROR(VLOOKUP(E$38&$A40,REPORT!$C$2:$AZ$29,16,0)),\"\",VLOOKUP(E$38&$A40,REPORT!$C$2:$AZ$29,16,0))","v":144},{"$f":"IF(ISNUMBER(H40),VLOOKUP(G$38&$A40,REPORT!$D$2:$AZ$29,3,0),\"\")","v":"2B"},{"$f":"IF(ISERROR(VLOOKUP(G$38&$A40,REPORT!$D$2:$AZ$29,16,0)),\"\",VLOOKUP(G$38&$A40,REPORT!$D$2:$AZ$29,16,0))","v":96},{"$f":"IF(ISNUMBER(J40),VLOOKUP(I$38&$A40,REPORT!$E$2:$AZ$29,2,0),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(I$38&$A40,REPORT!$E$2:$AZ$29,16,0)),\"\",VLOOKUP(I$38&$A40,REPORT!$E$2:$AZ$29,16,0))","v":""},{"$f":"IF(ISNUMBER(L40),VLOOKUP($K38,REPORT!$A$2:$S$28,6,0),\"\")","v":5},250]
["USE 2ND",null,{"$f":"IF(ISNUMBER(D41),VLOOKUP(C$38&$A41,REPORT!$B$2:$AZ$29,5,0),\"\")","v":"2B"},{"$f":"IF(ISERROR(VLOOKUP(C$38&$A41,REPORT!$B$2:$AZ$29,16,0)),\"\",VLOOKUP(C$38&$A41,REPORT!$B$2:$AZ$29,16,0))","v":528},{"$f":"IF(ISNUMBER(F41),VLOOKUP(E$38&$A41,REPORT!$C$2:$AZ$29,4,0),\"\")","v":"4A"},{"$f":"IF(ISERROR(VLOOKUP(E$38&$A41,REPORT!$C$2:$AZ$29,16,0)),\"\",VLOOKUP(E$38&$A41,REPORT!$C$2:$AZ$29,16,0))","v":192},{"$f":"IF(ISNUMBER(H41),VLOOKUP(G$38&$A41,REPORT!$D$2:$AZ$29,3,0),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(G$38&$A41,REPORT!$D$2:$AZ$29,16,0)),\"\",VLOOKUP(G$38&$A41,REPORT!$D$2:$AZ$29,16,0))","v":""},{"$f":"IF(ISNUMBER(J41),VLOOKUP(I$38&$A41,REPORT!$E$2:$AZ$29,2,0),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(I$38&$A41,REPORT!$E$2:$AZ$29,16,0)),\"\",VLOOKUP(I$38&$A41,REPORT!$E$2:$AZ$29,16,0))","v":""}]
["USE 3RD",null,{"$f":"IF(ISNUMBER(D42),VLOOKUP(C$38&$A42,REPORT!$B$2:$AZ$29,5,0),\"\")","v":7},{"$f":"IF(ISERROR(VLOOKUP(C$38&$A42,REPORT!$B$2:$AZ$29,16,0)),\"\",VLOOKUP(C$38&$A42,REPORT!$B$2:$AZ$29,16,0))","v":816},{"$f":"IF(ISNUMBER(F42),VLOOKUP(E$38&$A42,REPORT!$C$2:$AZ$29,4,0),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(E$38&$A42,REPORT!$C$2:$AZ$29,16,0)),\"\",VLOOKUP(E$38&$A42,REPORT!$C$2:$AZ$29,16,0))","v":""},{"$f":"IF(ISNUMBER(H42),VLOOKUP(G$38&$A42,REPORT!$D$2:$AZ$29,3,0),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(G$38&$A42,REPORT!$D$2:$AZ$29,16,0)),\"\",VLOOKUP(G$38&$A42,REPORT!$D$2:$AZ$29,16,0))","v":""},{"$f":"IF(ISNUMBER(J42),VLOOKUP(I$38&$A42,REPORT!$E$2:$AZ$29,2,0),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(I$38&$A42,REPORT!$E$2:$AZ$29,16,0)),\"\",VLOOKUP(I$38&$A42,REPORT!$E$2:$AZ$29,16,0))","v":""}]
["USE 4TH",null,{"$f":"IF(ISNUMBER(D43),VLOOKUP(C$38&$A43,REPORT!$B$2:$AZ$29,5,0),\"\")","v":"4A"},{"$f":"IF(ISERROR(VLOOKUP(C$38&$A43,REPORT!$B$2:$AZ$29,16,0)),\"\",VLOOKUP(C$38&$A43,REPORT!$B$2:$AZ$29,16,0))","v":624},{"$f":"IF(ISNUMBER(F43),VLOOKUP(E$38&$A43,REPORT!$C$2:$AZ$29,4,0),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(E$38&$A43,REPORT!$C$2:$AZ$29,16,0)),\"\",VLOOKUP(E$38&$A43,REPORT!$C$2:$AZ$29,16,0))","v":""},{"$f":"IF(ISNUMBER(H43),VLOOKUP(G$38&$A43,REPORT!$D$2:$AZ$29,3,0),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(G$38&$A43,REPORT!$D$2:$AZ$29,16,0)),\"\",VLOOKUP(G$38&$A43,REPORT!$D$2:$AZ$29,16,0))","v":""},{"$f":"IF(ISNUMBER(J43),VLOOKUP(I$38&$A43,REPORT!$E$2:$AZ$29,2,0),\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(I$38&$A43,REPORT!$E$2:$AZ$29,16,0)),\"\",VLOOKUP(I$38&$A43,REPORT!$E$2:$AZ$29,16,0))","v":""}]
["PARTIAL",null,{"$f":"IF(ISNUMBER(D44),VLOOKUP(C$38&$A44,REPORT!$B$2:$AZ$29,5,0),\"\")","v":""},null,{"$f":"IF(ISNUMBER(F44),VLOOKUP(E$38&$A44,REPORT!$C$2:$AZ$29,4,0),\"\")","v":""},null,{"$f":"IF(ISNUMBER(H44),VLOOKUP(G$38&$A44,REPORT!$D$2:$AZ$29,3,0),\"\")","v":""},null,{"$f":"IF(ISNUMBER(J44),VLOOKUP(I$38&$A44,REPORT!$E$2:$AZ$29,2,0),\"\")","v":""}]
["IF NEEDED",null,{"$f":"IF(ISNUMBER(D45),VLOOKUP(C$38&$A45,REPORT!$B$2:$AZ$29,5,0),\"\")","v":""},null,{"$f":"IF(ISNUMBER(F45),VLOOKUP(E$38&$A45,REPORT!$C$2:$AZ$29,4,0),\"\")","v":""},null,{"$f":"IF(ISNUMBER(H45),VLOOKUP(G$38&$A45,REPORT!$D$2:$AZ$29,3,0),\"\")","v":""},null,{"$f":"IF(ISNUMBER(J45),VLOOKUP(I$38&$A45,REPORT!$E$2:$AZ$29,2,0),\"\")","v":""}]
["Staging lanes /      Left Over",null,"STAGE","QTY","STAGE","QTY","STAGE","QTY","STAGE","QTY"]
[null,null,3,1620,3,283,3,81,null,null,null,140]
[]
["TOTALS",null,null,{"$f":"SUM(D40:D44)+D47","v":4260},null,{"$f":"SUM(F40:F44)+F47","v":619},null,{"$f":"SUM(H40:H44)+H47","v":177},null,{"$f":"SUM(J40:J44)+J47","v":0},null,{"$f":"SUM(L40:L44)+L47","v":390}]
["Comments"]

{"sheet":"1","index":2,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[21,12,21,14],[22,12,22,14],[24,12,24,14],[33,12,33,14],[34,12,34,14],[25,12,25,14],[27,12,27,14],[28,12,28,14],[30,12,30,14],[31,12,31,14],[6,4,6,6],[15,12,15,14],[16,12,16,14],[18,12,18,14],[19,12,19,14],[6,7,6,8],[7,7,7,8],[6,10,6,12],[6,13,6,14],[7,13,7,14],[3,0,3,1],[3,2,3,3],[4,4,4,6],[3,13,3,14],[4,13,4,14],[3,10,3,12],[4,10,4,12],[3,4,3,6],[3,7,3,8],[6,0,7,1],[6,2,6,3],[7,2,7,3],[5,2,5,3],[4,0,5,1],[4,2,4,3],[36,12,36,14],[37,12,37,14],[0,4,1,9],[2,10,2,12],[2,13,2,14],[4,7,4,8],[5,7,5,8],[5,13,5,14],[5,10,5,12],[5,4,5,6],[7,4,7,6],[10,12,10,14],[12,12,12,14],[13,12,13,14],[8,13,8,14],[7,10,7,12]]}
[null,null,null,null,"BANANA RECEIVING RIPENING LOG "]
[]
[null,null,null,null,null,null,null,null,null,null,"DATE RECEIVED 1A"]
["ROOM #",null,"PO #",null,"LABEL",null,null,"COO",null,null,"DATE GASSED"]
["1A",null,null,null,null,null,null,null,null,null,"DATE RECEIVED 1B",null,null,"2022-05-28"]
[null,null,null,null,null,null,null,null,null,null,"DATE GASSED"]
["1B",null,null,null,null,null,null,null,null,null,"ESTIMATED DATE OF SALE  1A"]
[null,null,null,null,null,null,null,null,null,null,"ESTIMATED DATE OF SALE 1B"]
[null,null,null,null,null,null,null,null,null,null,"GENERATOR SETTING",null,null,3]
[null,null,null,null,null,null," "]
["ROOM ","DATE","PULP TEMP","SET TEMP","RM TEMP","HUMIDITY","HRs.","STAGE","CORPORATE ","PCO","RIPE PLANTAIN","SDM","COMMENTS"]
[]
["1A","TODAY"]
["1B","TODAY",58.9]
[]
["1A",{"$f":"IF(ISBLANK($N$3),\" \", N3)","v":" "}]
["1B",{"$f":"IF(ISBLANK($N$5),\" \", N5)","v":"2022-05-28"}]
[]
["1A",{"$f":"IF(ISBLANK($N$3),\"\",B16+1)","v":""}]
["1B",{"$f":"IF(ISBLANK($N$5),\"\",B17+1)","v":"2022-05-29"},58.9]
[]
["1A",{"$f":"IF(ISBLANK($N$3),\"\",B19+1)","v":""}]
["1B",{"$f":"IF(ISBLANK($N$5),\"\",B20+1)","v":"2022-05-30"}]
[]
["1A",{"$f":"IF(ISBLANK($N$3),\"\",B22+1)","v":""}]
["1B",{"$f":"IF(ISBLANK($N$5),\"\",B23+1)","v":"2022-05-31"}]
[]
["1A",{"$f":"IF(ISBLANK($N$3),\"\",B25+1)","v":""}]
["1B",{"$f":"IF(ISBLANK($N$5),\"\",B26+1)","v":"2022-06-01"}]
[]
["1A",{"$f":"IF(ISBLANK($N$3),\"\",B28+1)","v":""}]
["1B",{"$f":"IF(ISBLANK($N$5),\"\",B29+1)","v":"2022-06-02"}]
[]
["1A",{"$f":"IF(ISBLANK($N$3),\"\",B31+1)","v":""}]
["1B",{"$f":"IF(ISBLANK($N$5),\"\",B32+1)","v":"2022-06-03"}]
[]
["1A",{"$f":"IF(ISBLANK($N$3),\"\",B34+1)","v":""}]
["1B",{"$f":"IF(ISBLANK($N$5),\"\",B35+1)","v":"2022-06-04"}]

{"sheet":"2","index":3,"n_rows":38,"n_cols":26,"rows_kept":38,"cut":false,"hidden":false,"merged":[[34,12,34,14],[27,12,27,14],[28,12,28,14],[30,12,30,14],[31,12,31,14],[33,12,33,14],[6,0,7,1],[3,0,3,1],[3,2,3,3],[3,4,3,6],[3,7,3,8],[0,4,1,9],[2,10,2,12],[10,12,10,14],[4,0,5,1],[4,2,4,3],[5,4,5,6],[5,7,5,8],[5,2,5,3],[5,10,5,12],[4,4,4,6],[4,10,4,12],[4,13,4,14],[5,13,5,14],[6,4,6,6],[6,7,6,8],[4,7,4,8],[7,2,7,3],[3,13,3,14],[6,2,6,3],[6,10,6,12],[7,4,7,6],[7,7,7,8],[6,13,6,14],[3,10,3,12],[8,13,8,14],[7,10,7,12],[36,12,36,14],[37,12,37,14],[2,13,2,14],[7,13,7,14],[15,12,15,14],[16,12,16,14],[18,12,18,14],[19,12,19,14],[12,12,12,14],[13,12,13,14],[21,12,21,14],[22,12,22,14],[24,12,24,14],[25,12,25,14]]}
[null,null,null,null,"BANANA RECEIVING RIPENING LOG "]
[]
[null,null,null,null,null,null,null,null,null,null,"DATE RECEIVED 2A",null,null,"2022-05-25"]
["ROOM #",null,"PO #",null,"LABEL",null,null,"COO",null,null,"DATE GASSED",null,null,"2022-05-25"]
["2A",null,2004504425,null,"DELMONTE",null,null,"GUATEMALA",null,null,"DATE RECEIVED 2B",null,null,"2022-05-25"]
[null,null,null,null,null,null,null,null,null,null,"DATE GASSED",null,null,"2022-05-25"]
["2B",null,2004504432,null,"DELMONTE",null,null,"GUATEMALA",null,null,"ESTIMATED DATE OF SALE  2A",null,null,"SUN"]
[null,null,null,null,null,null,null,null,null,null,"ESTIMATED DATE OF SALE 2B",null,null,"SUN"]
[null,null,null,null,null,null,null,null,null,null,"GENERATOR SETTING",null,null,3]
[null,null,null,null,null,null," "]
["ROOM ","DATE","PULP TEMP","SET TEMP","RM TEMP","HUMIDITY","HRs.","STAGE","CORPORATE ","PCO","RIPE PLANTAIN","SDM","COMMENTS"]
[]
["2A","TODAY",58.9,58,59,0.9,72,3,672]
["2B","TODAY",61.3,60,60,0.91,72,2.5,528,144,96,45]
[]
["2A",{"$f":"IF(ISBLANK($N$3),\" \", N3)","v":"2022-05-25"},61.7,62,60.4,0.72,0,1,960,null,null,null,"Gassing",null,null,null,null,null,null,null,null,null,null,null,null,"kkk"]
["2B",{"$f":"IF(ISBLANK($N$5),\" \", N5)","v":"2022-05-25"},62.3,62,60.9,0.72,0,1,528,192,96,45,"Gassing"]
[]
["2A",{"$f":"IF(ISBLANK($N$3),\"\",B16+1)","v":"2022-05-26"},62,62,62,0.85,24,1,960]
["2B",{"$f":"IF(ISBLANK($N$5),\"\",B17+1)","v":"2022-05-26"},62,62,62.1,0.85,24,1,528,192,96,45]
[]
["2A",{"$f":"IF(ISBLANK($N$3),\"\",B19+1)","v":"2022-05-27"},60.8,60,60.1,0.91,48,2,960]
["2B",{"$f":"IF(ISBLANK($N$5),\"\",B20+1)","v":"2022-05-27"},61.3,60,60,0.91,48,2,528,192,96,45]
[]
["2A",{"$f":"IF(ISBLANK($N$3),\"\",B22+1)","v":"2022-05-28"},58.9,58,59,0.9,72,3,672]
["2B",{"$f":"IF(ISBLANK($N$5),\"\",B23+1)","v":"2022-05-28"},61.3,60,60,0.91,72,2.5,528,144,96,45]
[]
["2A",{"$f":"IF(ISBLANK($N$3),\"\",B25+1)","v":"2022-05-29"}]
["2B",{"$f":"IF(ISBLANK($N$5),\"\",B26+1)","v":"2022-05-29"}]
[]
["2A",{"$f":"IF(ISBLANK($N$3),\"\",B28+1)","v":"2022-05-30"}]
["2B",{"$f":"IF(ISBLANK($N$5),\"\",B29+1)","v":"2022-05-30"}]
[]
["2A",{"$f":"IF(ISBLANK($N$3),\"\",B31+1)","v":"2022-05-31"}]
["2B",{"$f":"IF(ISBLANK($N$5),\"\",B32+1)","v":"2022-05-31"}]
[]
["2A",{"$f":"IF(ISBLANK($N$3),\"\",B34+1)","v":"2022-06-01"}]
["2B",{"$f":"IF(ISBLANK($N$5),\"\",B35+1)","v":"2022-06-01"}]

{"sheet":"3","index":4,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[27,12,27,14],[28,12,28,14],[30,12,30,14],[31,12,31,14],[33,12,33,14],[6,0,7,1],[6,4,6,6],[7,4,7,6],[7,13,7,14],[12,12,12,14],[7,2,7,3],[7,7,7,8],[6,2,6,3],[6,7,6,8],[6,10,6,12],[4,13,4,14],[4,0,5,1],[4,2,4,3],[4,7,4,8],[5,2,5,3],[5,7,5,8],[4,4,4,6],[5,13,5,14],[5,4,5,6],[5,10,5,12],[2,13,2,14],[3,0,3,1],[3,2,3,3],[3,7,3,8],[3,13,3,14],[3,4,3,6],[3,10,3,12],[4,10,4,12],[0,4,1,9],[2,10,2,12],[7,10,7,12],[8,13,8,14],[36,12,36,14],[37,12,37,14],[6,13,6,14],[19,12,19,14],[10,12,10,14],[13,12,13,14],[15,12,15,14],[16,12,16,14],[18,12,18,14],[21,12,21,14],[22,12,22,14],[24,12,24,14],[25,12,25,14],[34,12,34,14]]}
[null,null,null,null,"BANANA RECEIVING RIPENING LOG "]
[]
[null,null,null,null,null,null,null,null,null,null,"DATE RECEIVED 3A",null,null,"2022-05-25"]
["ROOM #",null,"PO #",null,"LABEL",null,null,"COO",null,null,"DATE GASSED",null,null,"2022-05-25"]
["3A",null,null,null,null,null,null,null,null,null,"DATE RECEIVED 3B",null,null,"2022-05-26"]
[null,null,null,null,null,null,null,null,null,null,"DATE GASSED",null,null,"2022-05-25"]
["3B",null,null,null,null,null,null,null,null,null,"ESTIMATED DATE OF SALE  3A",null,null,"SUN"]
[null,null,null,null,null,null,null,null,null,null,"ESTIMATED DATE OF SALE 3B",null,null,"SUN"]
[null,null,null,null,null,null,null,null,null,null,"GENERATOR SETTING",null,null,3]
[null,null,null,null,null,null," "]
["ROOM ","DATE","PULP TEMP","SET TEMP","RM TEMP","HUMIDITY","HRs.","STAGE","CORPORATE ","PCO","RIPE PLANTAIN","SDM","COMMENTS"]
[]
["3A","TODAY"]
["3B","TODAY"]
[]
["3A",{"$f":"IF(ISBLANK($N$3),\" \", N3)","v":"2022-05-25"}]
["3B",{"$f":"IF(ISBLANK($N$5),\" \", N5)","v":"2022-05-26"}]
[]
["3A",{"$f":"IF(ISBLANK($N$3),\"\",B16+1)","v":"2022-05-26"}]
["3B",{"$f":"IF(ISBLANK($N$5),\"\",B17+1)","v":"2022-05-27"}]
[]
["3A",{"$f":"IF(ISBLANK($N$3),\"\",B19+1)","v":"2022-05-27"}]
["3B",{"$f":"IF(ISBLANK($N$5),\"\",B20+1)","v":"2022-05-28"}]
[]
["3A",{"$f":"IF(ISBLANK($N$3),\"\",B22+1)","v":"2022-05-28"}]
["3B",{"$f":"IF(ISBLANK($N$5),\"\",B23+1)","v":"2022-05-29"}]
[]
["3A",{"$f":"IF(ISBLANK($N$3),\"\",B25+1)","v":"2022-05-29"}]
["3B",{"$f":"IF(ISBLANK($N$5),\"\",B26+1)","v":"2022-05-30"}]
[]
["3A",{"$f":"IF(ISBLANK($N$3),\"\",B28+1)","v":"2022-05-30"}]
["3B",{"$f":"IF(ISBLANK($N$5),\"\",B29+1)","v":"2022-05-31"}]
[]
["3A",{"$f":"IF(ISBLANK($N$3),\"\",B31+1)","v":"2022-05-31"}]
["3B",{"$f":"IF(ISBLANK($N$5),\"\",B32+1)","v":"2022-06-01"}]
[]
["3A",{"$f":"IF(ISBLANK($N$3),\"\",B34+1)","v":"2022-06-01"}]
["3B",{"$f":"IF(ISBLANK($N$5),\"\",B35+1)","v":"2022-06-02"}]

{"sheet":"4","index":5,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[28,12,28,14],[30,12,30,14],[6,0,7,1],[6,4,6,6],[7,4,7,6],[7,13,7,14],[7,2,7,3],[7,7,7,8],[6,2,6,3],[6,7,6,8],[6,10,6,12],[6,13,6,14],[7,10,7,12],[3,0,3,1],[3,2,3,3],[3,7,3,8],[0,4,1,10],[18,12,18,14],[10,12,10,14],[12,12,12,14],[13,12,13,14],[15,12,15,14],[16,12,16,14],[5,4,5,6],[5,10,5,12],[5,13,5,14],[2,10,2,12],[2,13,2,14],[3,4,3,6],[4,0,5,1],[4,2,4,3],[4,7,4,8],[5,2,5,3],[5,7,5,8],[4,4,4,6],[8,13,8,14],[36,12,36,14],[37,12,37,14],[3,13,3,14],[4,13,4,14],[3,10,3,12],[4,10,4,12],[19,12,19,14],[21,12,21,14],[22,12,22,14],[31,12,31,14],[33,12,33,14],[34,12,34,14],[24,12,24,14],[25,12,25,14],[27,12,27,14]]}
[null,null,null,null,"BANANA RECEIVING RIPENING LOG "]
[]
[null,null,null,null,null,null,null,null,null,null,"DATE RECEIVED 4A",null,null,"2022-05-26"]
["ROOM #",null,"PO #",null,"LABEL",null,null,"COO",null,null,"DATE GASSED",null,null,"2022-05-27"]
["4A",null,2004504433,null,"DELMONTE",null,null,"GUATEMALA",null,null,"DATE RECEIVED 4B",null,null,"2022-05-27"]
[null,null,null,null,null,null,null,null,null,null,"DATE GASSED",null,null,"2022-05-27"]
["4B",null,2004504938,null,"DELMONTE",null,null,"GUATEMALA",null,null,"ESTIMATED DATE OF SALE  4A",null,null,"MON"]
[null,null,null,null,null,null,null,null,null,null,"ESTIMATED DATE OF SALE 4B",null,null,"TUE"]
[null,null,null,null,null,null,null,null,null,null,"GENERATOR SETTING",null,null,3]
[null,null,null,null,null,null," "]
["ROOM ","DATE","PULP TEMP","SET TEMP","RM TEMP","HUMIDITY","HRs.","STAGE","CORPORATE ","PCO","RIPE PLANTAIN","SDM","COMMENTS"]
[]
["4A","TODAY",62.7,62,62,0.75,48,2,624,192,48]
["4B","TODAY",62.2,62,62,0.75,24,1,960]
[]
["4A",{"$f":"IF(ISBLANK($N$3),\" \", N3)","v":"2022-05-26"},62.3,61,58.7,0.72,0,1,624,192,48,null,"Gassing"]
["4B",{"$f":"IF(ISBLANK($N$5),\" \", N5)","v":"2022-05-27"}]
[]
["4A",{"$f":"IF(ISBLANK($N$3),\"\",B16+1)","v":"2022-05-27"},62.2,61,62,0.83,24,1.5,624,192,48,null,"Gassing"]
["4B",{"$f":"IF(ISBLANK($N$5),\"\",B17+1)","v":"2022-05-28"},63.2,62,62,0.83,0,1,960,null,null,null,"Gassing"]
[]
["4A",{"$f":"IF(ISBLANK($N$3),\"\",B19+1)","v":"2022-05-28"}]
["4B",{"$f":"IF(ISBLANK($N$5),\"\",B20+1)","v":"2022-05-29"},62.2,62,62,0.75,24,1,960]
[]
["4A",{"$f":"IF(ISBLANK($N$3),\"\",B22+1)","v":"2022-05-29"}]
["4B",{"$f":"IF(ISBLANK($N$5),\"\",B23+1)","v":"2022-05-30"}]
[]
["4A",{"$f":"IF(ISBLANK($N$3),\"\",B25+1)","v":"2022-05-30"}]
["4B",{"$f":"IF(ISBLANK($N$5),\"\",B26+1)","v":"2022-05-31"}]
[]
["4A",{"$f":"IF(ISBLANK($N$3),\"\",B28+1)","v":"2022-05-31"}]
["4B",{"$f":"IF(ISBLANK($N$5),\"\",B29+1)","v":"2022-06-01"}]
[]
["4A",{"$f":"IF(ISBLANK($N$3),\"\",B31+1)","v":"2022-06-01"}]
["4B",{"$f":"IF(ISBLANK($N$5),\"\",B32+1)","v":"2022-06-02"}]
[]
["4A",{"$f":"IF(ISBLANK($N$3),\"\",B34+1)","v":"2022-06-02"}]
["4B",{"$f":"IF(ISBLANK($N$5),\"\",B35+1)","v":"2022-06-03"}]

{"sheet":"5","index":6,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,4,1,10],[19,12,19,14],[21,12,21,14],[23,12,23,14],[25,12,25,14],[9,12,9,14],[11,12,11,14],[13,12,13,14],[15,12,15,14],[17,12,17,14],[7,13,7,14],[3,4,3,6],[3,7,3,8],[3,10,3,12],[3,13,3,14],[6,13,6,14],[3,0,3,1],[3,2,3,3],[4,0,5,1],[4,2,4,3],[5,2,5,3],[6,0,7,1],[6,2,6,3],[7,2,7,3],[5,4,5,6],[5,7,5,8],[6,4,6,6],[6,7,6,8],[7,4,7,6],[7,7,7,8],[5,10,5,12],[5,13,5,14],[4,4,4,6],[4,7,4,8],[4,10,4,12],[4,13,4,14]]}
[null,null,null,null,"BANANA RECEIVING RIPENING LOG "]
[]
[]
["ROOM #",null,"PO #",null,"LABEL",null,null,"COO",null,null,"DATE RECEIVED",null,null,"2022-05-26"]
[5,null,2004504426,null,"DELMONTE",null,null,"GUATEMALA",null,null,"DATE GASSED",null,null,"2022-05-26"]
[null,null,null,null,null,null,null,null,null,null,"ESTIMATED DATE OF SALE",null,null,"MON"]
[null,null,null,null,null,null,null,null,null,null,"GENERATOR SETTING",null,null,3]
[]
[null,null,null,null,null,null," "]
["ROOM ","DATE","PULP TEMP","SET TEMP","RM TEMP","HUMIDITY","HRs.","STAGE","CORPORATE ","PCO","RIPE PLANTAIN","SDM","COMMENTS"]
[]
[5,"TODAY",61.2,61,61,0.88,48,2,960]
[]
[5,{"$f":"IF(ISBLANK($N$4),\" \", N4)","v":"2022-05-26"},63,61,59.4,0.71,0,1,960,null,null,null,"Gassing"]
[]
[5,{"$f":"IF(ISBLANK($N$4),\"\",B14+1)","v":"2022-05-27"},62,62,62,0.87,24,1.5,960]
[]
[5,{"$f":"IF(ISBLANK($N$4),\"\",B16+1)","v":"2022-05-28"},61.2,61,61,0.88,48,2,960]
[]
[5,{"$f":"IF(ISBLANK($N$4),\"\",B18+1)","v":"2022-05-29"}]
[]
[5,{"$f":"IF(ISBLANK($N$4),\"\",B20+1)","v":"2022-05-30"}]
[]
[5,{"$f":"IF(ISBLANK($N$4),\"\",B22+1)","v":"2022-05-31"}]
[]
[5,{"$f":"IF(ISBLANK($N$4),\"\",B24+1)","v":"2022-06-01"}]

{"sheet":"6","index":7,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,12,25,14],[15,12,15,14],[17,12,17,14],[19,12,19,14],[21,12,21,14],[23,12,23,14],[6,0,7,1],[6,2,6,3],[6,4,6,6],[6,7,6,8],[7,2,7,3],[7,4,7,6],[7,7,7,8],[7,13,7,14],[9,12,9,14],[11,12,11,14],[13,12,13,14],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,10,5,12],[5,13,5,14],[6,13,6,14],[4,13,4,14],[4,0,5,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,10,4,12],[0,4,2,14],[3,0,3,1],[3,2,3,3],[3,4,3,6],[3,7,3,8],[3,10,3,12],[3,13,3,14]]}
[null,null,null,null,"BANANA RECEIVING RIPENING LOG "]
[]
[]
["ROOM #",null,"PO #",null,"LABEL",null,null,"COO",null,null,"DATE RECEIVED"]
[6,null,null,null,null,null,null,null,null,null,"DATE GASSED"]
[null,null,null,null,null,null,null,null,null,null,"ESTIMATED DATE OF SALE"]
[null,null,null,null,null,null,null,null,null,null,"GENERATOR SETTING",null,null,3]
[]
[null,null,null,null,null,null," "]
["ROOM ","DATE","PULP TEMP","SET TEMP","RM TEMP","HUMIDITY","HRs.","STAGE","CORPORATE ","PCO","RIPE PLANTAIN","SDM","COMMENTS"]
[]
[6,"TODAY"]
[]
[6,{"$f":"IF(ISBLANK($N$4),\" \", N4)","v":" "}]
[]
[6,{"$f":"IF(ISBLANK($N$4),\"\",B14+1)","v":""}]
[]
[6,{"$f":"IF(ISBLANK($N$4),\"\",B16+1)","v":""}]
[]
[6,{"$f":"IF(ISBLANK($N$4),\"\",B18+1)","v":""}]
[]
[6,{"$f":"IF(ISBLANK($N$4),\"\",B20+1)","v":""}]
[]
[6,{"$f":"IF(ISBLANK($N$4),\"\",B22+1)","v":""}]
[]
[6,{"$f":"IF(ISBLANK($N$4),\"\",B24+1)","v":""}]

{"sheet":"7","index":8,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[17,12,17,14],[19,12,19,14],[21,12,21,14],[23,12,23,14],[25,12,25,14],[15,12,15,14],[6,0,7,1],[6,2,6,3],[6,4,6,6],[6,7,6,8],[7,2,7,3],[7,4,7,6],[7,7,7,8],[7,13,7,14],[9,12,9,14],[6,13,6,14],[11,12,11,14],[13,12,13,14],[0,4,2,14],[3,0,3,1],[3,2,3,3],[3,4,3,6],[3,7,3,8],[3,10,3,12],[3,13,3,14],[4,13,4,14],[4,0,5,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,10,4,12],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,10,5,12],[5,13,5,14]]}
[null,null,null,null,"BANANA RECEIVING RIPENING LOG "]
[]
[]
["ROOM #",null,"PO #",null,"LABEL",null,null,"COO",null,null,"DATE RECEIVED",null,null,"2022-05-27"]
[7,null,2004505631,null,"CHIQUITA",null,null,"GUATEMALA",null,null,"DATE GASSED",null,null,"2022-05-27"]
[null,null,null,null,null,null,null,null,null,null,"ESTIMATED DATE OF SALE",null,null,"MON"]
[null,null,null,null,null,null,null,null,null,null,"GENERATOR SETTING",null,null,3]
[]
[null,null,null,null,null,null," "]
["ROOM ","DATE","PULP TEMP","SET TEMP","RM TEMP","HUMIDITY","HRs.","STAGE","CORPORATE ","PCO","RIPE PLANTAIN","SDM","COMMENTS"]
[]
[7,"TODAY",59.9,60,60.2,0.9,24,2.5,816]
[]
[7,{"$f":"IF(ISBLANK($N$4),\" \", N4)","v":"2022-05-27"},60.3,60,60.8,0.7,null,2,816,48,null,null,"Gassing"]
[]
[7,{"$f":"IF(ISBLANK($N$4),\"\",B14+1)","v":"2022-05-28"},59.9,60,60.2,0.9,24,2.5,816]
[]
[7,{"$f":"IF(ISBLANK($N$4),\"\",B16+1)","v":"2022-05-29"}]
[]
[7,{"$f":"IF(ISBLANK($N$4),\"\",B18+1)","v":"2022-05-30"}]
[]
[7,{"$f":"IF(ISBLANK($N$4),\"\",B20+1)","v":"2022-05-31"}]
[]
[7,{"$f":"IF(ISBLANK($N$4),\"\",B22+1)","v":"2022-06-01"}]
[]
[7,{"$f":"IF(ISBLANK($N$4),\"\",B24+1)","v":"2022-06-02"}]

{"sheet":"8","index":9,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,12,25,14],[15,12,15,14],[17,12,17,14],[19,12,19,14],[21,12,21,14],[23,12,23,14],[6,0,7,1],[6,2,6,3],[6,4,6,6],[6,7,6,8],[7,2,7,3],[7,4,7,6],[7,7,7,8],[7,13,7,14],[9,12,9,14],[11,12,11,14],[13,12,13,14],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,10,5,12],[5,13,5,14],[6,13,6,14],[4,13,4,14],[4,0,5,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,10,4,12],[0,4,2,14],[3,0,3,1],[3,2,3,3],[3,4,3,6],[3,7,3,8],[3,10,3,12],[3,13,3,14]]}
[null,null,null,null,"BANANA RECEIVING RIPENING LOG "]
[]
[]
["ROOM #",null,"PO #",null,"LABEL",null,null,"COO",null,null,"DATE RECEIVED"]
[8,null,null,null,null,null,null,null,null,null,"DATE GASSED"]
[null,null,null,null,null,null,null,null,null,null,"ESTIMATED DATE OF SALE"]
[null,null,null,null,null,null,null,null,null,null,"GENERATOR SETTING",null,null,3]
[]
[null,null,null,null,null,null," "]
["ROOM ","DATE","PULP TEMP","SET TEMP","RM TEMP","HUMIDITY","HRs.","STAGE","CORPORATE ","PCO","RIPE PLANTAIN","SDM","COMMENTS"]
[]
[8,"TODAY"]
[]
[8,{"$f":"IF(ISBLANK($N$4),\" \", N4)","v":" "}]
[]
[8,{"$f":"IF(ISBLANK($N$4),\"\",B14+1)","v":""}]
[]
[8,{"$f":"IF(ISBLANK($N$4),\"\",B16+1)","v":""}]
[]
[8,{"$f":"IF(ISBLANK($N$4),\"\",B18+1)","v":""}]
[]
[8,{"$f":"IF(ISBLANK($N$4),\"\",B20+1)","v":""}]
[]
[8,{"$f":"IF(ISBLANK($N$4),\"\",B22+1)","v":""}]
[]
[8,{"$f":"IF(ISBLANK($N$4),\"\",B24+1)","v":""}]

{"sheet":"9","index":10,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,0,7,1],[6,2,6,3],[6,4,6,6],[6,7,6,8],[7,2,7,3],[7,4,7,6],[7,7,7,8],[7,13,7,14],[9,12,9,14],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,10,5,12],[5,13,5,14],[6,13,6,14],[4,13,4,14],[4,0,5,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,10,4,12],[0,4,2,14],[3,0,3,1],[3,2,3,3],[3,4,3,6],[3,7,3,8],[3,10,3,12],[3,13,3,14],[21,12,21,14],[23,12,23,14],[25,12,25,14],[11,12,11,14],[13,12,13,14],[15,12,15,14],[17,12,17,14],[19,12,19,14]]}
[null,null,null,null,"BANANA RECEIVING RIPENING LOG "]
[]
[]
["ROOM #",null,"PO #",null,"LABEL",null,null,"COO",null,null,"DATE RECEIVED"]
[9,null,null,null,null,null,null,null,null,null,"DATE GASSED"]
[null,null,null,null,null,null,null,null,null,null,"ESTIMATED DATE OF SALE"]
[null,null,null,null,null,null,null,null,null,null,"GENERATOR SETTING",null,null,3]
[]
[null,null,null,null,null,null," "]
["ROOM ","DATE","PULP TEMP","SET TEMP","RM TEMP","HUMIDITY","HRs.","STAGE","CORPORATE ","PCO","RIPE PLANTAIN","SDM","COMMENTS"]
[]
[9,"TODAY"]
[]
[9,{"$f":"IF(ISBLANK($N$4),\" \", N4)","v":" "}]
[]
[9,{"$f":"IF(ISBLANK($N$4),\"\",B14+1)","v":""}]
[]
[9,{"$f":"IF(ISBLANK($N$4),\"\",B16+1)","v":""}]
[]
[9,{"$f":"IF(ISBLANK($N$4),\"\",B18+1)","v":""}]
[]
[9,{"$f":"IF(ISBLANK($N$4),\"\",B20+1)","v":""}]
[]
[9,{"$f":"IF(ISBLANK($N$4),\"\",B22+1)","v":""}]
[]
[9,{"$f":"IF(ISBLANK($N$4),\"\",B24+1)","v":""}]

{"sheet":"10","index":11,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,12,25,14],[15,12,15,14],[17,12,17,14],[19,12,19,14],[21,12,21,14],[23,12,23,14],[6,0,7,1],[6,2,6,3],[6,4,6,6],[6,7,6,8],[7,2,7,3],[7,4,7,6],[7,7,7,8],[7,13,7,14],[9,12,9,14],[11,12,11,14],[13,12,13,14],[5,2,5,3],[5,4,5,6],[5,7,5,8],[5,10,5,12],[5,13,5,14],[6,13,6,14],[4,13,4,14],[4,0,5,1],[4,2,4,3],[4,4,4,6],[4,7,4,8],[4,10,4,12],[0,4,2,14],[3,0,3,1],[3,2,3,3],[3,4,3,6],[3,7,3,8],[3,10,3,12],[3,13,3,14]]}
[null,null,null,null,"BANANA RECEIVING RIPENING LOG "]
[]
[]
["ROOM #",null,"PO #",null,"LABEL",null,null,"COO",null,null,"DATE RECEIVED",null,null,"2022-05-27"]
[10,null,2004504945,null,"DELMONTE",null,null,"GUATEMALA",null,null,"DATE GASSED",null,null,"2022-05-27"]
[null,null,null,null,null,null,null,null,null,null,"ESTIMATED DATE OF SALE",null,null,"TUE"]
[null,null,null,null,null,null,null,null,null,null,"GENERATOR SETTING",null,null,3]
[]
[null," ",null,null,null,null," "]
["ROOM ","DATE","PULP TEMP","SET TEMP","RM TEMP","HUMIDITY","HRs.","STAGE","CORPORATE ","PCO","RIPE PLANTAIN","SDM","COMMENTS"]
[]
[10,"TODAY",62.6,62,62,0.87,24,1,720,144,null,45]
[]
[10,{"$f":"IF(ISBLANK($N$4),\" \", N4)","v":"2022-05-27"},58.9,62,61.2,0.8,0,1,720,144,null,45,"Gassing"]
[]
[10,{"$f":"IF(ISBLANK($N$4),\"\",B14+1)","v":"2022-05-28"},62.6,62,62,0.87,24,1,720,144,null,45]
[]
[10,{"$f":"IF(ISBLANK($N$4),\"\",B16+1)","v":"2022-05-29"}]
[]
[10,{"$f":"IF(ISBLANK($N$4),\"\",B18+1)","v":"2022-05-30"}]
[]
[10,{"$f":"IF(ISBLANK($N$4),\"\",B20+1)","v":"2022-05-31"}]
[]
[10,{"$f":"IF(ISBLANK($N$4),\"\",B22+1)","v":"2022-06-01"}]
[]
[10,{"$f":"IF(ISBLANK($N$4),\"\",B24+1)","v":"2022-06-02"}]

{"sheet":"PRE RIPE","index":12,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,3,2,13],[4,11,4,13],[6,11,6,13],[7,11,7,13]]}
[null,null,null,"BANANA RECEIVING RIPENING LOG "]
[]
[]
[null,null,null,null,null," "]
["ROOM ","DATE REC","PO#","LABEL","COO","PULP TEMP","STAGE","CORPORATE","PCO","RIPE PLT","SDM","COMMENTS"]
[]
["PRE1"]
["PRE2"]

{"sheet":"RECEIVING","index":13,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":false,"merged":[[8,0,8,15]]}
["DATE","BAN ROOM #","PO#","# OF REGULAR","# OF ORGANIC","# OF RIPE PLANTAIN","# OF SDM","PULP #1","PULP #2","ORIGIN","SET PT","DAY","LABEL","CARRIER","RECEIVING DOOR","Comments"]

{"sheet":"List","index":14,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,"DELMONTE",null,"ECUADOR",null,"SUN",null,"USE 1ST",{"$f":"TODAY()","v":"2022-05-29"}]
[null,"DOLE",null,"GUATEMALA",null,"MON",null,"USE 2ND",{"$f":"TODAY()+1","v":"2022-05-30"}]
[null,"CHIQUITA",null,"PERU",null,"TUE",null,"USE 3RD"]
[null,"ONE BANANA",null,"MEXICO",null,"WED",null,"USE 4TH"]
[null,"TURBANA",null,"COSTA RICA",null,"THU",null,"PARTIAL"]
[null,"FYFFES",null,"HONDURAS",null,"FRI",null,"IF NEEDED"]
[null,null,null,"NICARAGUA",null,"SAT",null,"NORTHERN"]
[null,null,null,"COLUMBIA",null,null,null,"OUT OF SERVICE"]
[null,null,null,"PANAMA",null,null,null,"STANDBY"]
[null,null,null,"DOMINICAN"]