{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Plant setup","Production data","Incoming water","mix vs WU","Non-returnable Lines","Glass Lines","CIP","Utilities +WTP","Water Balance","Output-Tier 1&2","Cans","AWS requirement"],"not_rendered":{"charts":7,"images":22,"macros":0,"external_links":2,"defined_names":10,"comments":7,"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":"Instructions","index":0,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[[29,0,29,6],[30,0,30,6],[9,0,9,15],[11,0,13,14],[25,0,25,6],[26,0,26,6],[27,0,27,6],[28,0,28,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Water Profiler - Beverage"]
[]
["This tool will help identify and undertand how water is used in a manufacturing plant.  It will help focus Resource Conservation efforts to the areas of highest usage, opportunities and cost. It builds a profile of plant water usage which should be updated yearly or as conservation tactics are implemented and new equipment added."]
[]
[]
[]
["HOW TO USE:  ",null,"Set up the Profile by entering data about plant equipment and water sources and consumptions into the various worksheets."]
[null,null,"Target certain months for the data collection."]
[null,null,"Fill \"Production data\" sheet then \"Plant Setup\" before filling the rest of sheets."]
[]
["DATA REQUIRED:     ",null,"1.  Water cosumption and bills for a fixed amount of time."]
[null,null,"2.  Production output for the same period."]
[null,null,"3.  Details on the different water users such as lines, boilers, sanitation, etc...   "]
[]
[]
[]
["Color Codes"]
["Yellow Cells/Tabs Require/Contain User Inputs"]
["Blue Cells/Tabs Contain Calculated Values/Outputs"]
["Green Cells Contain Best in Class (BIC) & Opportunities Values/Outputs"]
["Purple Cells Contain Projects Values/Outputs"]
["Orange Tabs/Posting Contain Helpful Information"]

{"sheet":"Plant setup","index":1,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,0,24,10],[10,0,10,19]]}
["Divisions"]
["BU"]
["Country"]
["Site Name"]
["Site Plant Manager"]
["BU Sustainability Lead"]
["Year of Profile"]
["Site Product Type"]
["No of Production Lines"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]
["Production Set Up "]
["Line Category",{"$f":"IFERROR(VLOOKUP(B10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(F10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(I10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(K10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(M10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(N10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(O10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(R10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(S10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(T10,'Production data'!$A$4:$B$206,2,0),\"\")","v":""}]
["Year of Installation"]
["Full Year NE %"]
["No. of SKUs produced"]
["total Running Hours",{"$f":"SUMIF('Production data'!$B$4:$B$206,B12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,C12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,D12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,E12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,F12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,G12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,H12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,I12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,J12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,K12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,L12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,M12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,N12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,O12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,P12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,Q12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,R12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,S12,'Production data'!$K$4:$K$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,T12,'Production data'!$K$4:$K$206)","v":0}]
["# of Rinses",{"$f":"IFERROR(VLOOKUP(B$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(F$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(I$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(K$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(M$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(N$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(O$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(R$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(S$12,CIP!$A$11:$K$29,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(T$12,CIP!$A$11:$K$29,2,0),\"\")","v":""}]
["# of 3S CIP",{"$f":"IFERROR(VLOOKUP(B$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(F$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(I$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(K$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(M$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(N$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(O$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(R$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(S$12,CIP!$A$11:$K$29,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(T$12,CIP!$A$11:$K$29,5,0),\"\")","v":""}]
["# of 5S CIP",{"$f":"IFERROR(VLOOKUP(B$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(F$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(I$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(K$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(M$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(N$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(O$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(R$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(S$12,CIP!$A$11:$K$29,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(T$12,CIP!$A$11:$K$29,8,0),\"\")","v":""}]
["# of 7S CIP",{"$f":"IFERROR(VLOOKUP(B$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(F$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(H$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(I$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(K$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(M$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(N$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(O$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(R$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(S$12,CIP!$A$11:$K$29,11,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(T$12,CIP!$A$11:$K$29,11,0),\"\")","v":""}]
["Annual Production in Liters",{"$f":"SUMIF('Production data'!$B$4:$B$206,B12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,C12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,D12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,E12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,F12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,G12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,H12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,I12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,J12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,K12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,L12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,M12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,N12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,O12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,P12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,Q12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,R12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,S12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUMIF('Production data'!$B$4:$B$206,T12,'Production data'!$I$4:$I$206)","v":0},{"$f":"SUM(B21:T21)","v":0}]
["%age Production Contribution",{"$f":"IFERROR(B21/$U$21,\"\")","v":""},"","","","","","","","","","","",{"$f":"IFERROR(N21/$U$21,\"\")","v":""},"","","","","","",{"$f":"SUM(B22:T22)","v":0}]
[]
[]
["Utilities Set Up "]
[null,"Boilers","HVAC"]

{"sheet":"Production data","index":2,"n_rows":206,"n_cols":15,"rows_kept":206,"cut":false,"hidden":false,"merged":[[0,1,0,11]]}
[null,"Production data by line by pack by month"]
[]
[null,"Line category","Line Code","Line number\n(Line1)","Pack type\n(PET, Cans…etc)","Product Type\n(CSD/NCB/BW)","Pack size\n(Can-330ml)","Month","Production (Liters)","NE%","Hrs NE","rated speed\nL/hr",null,"Monthly figures"]
[{"$f":"IF(I4>0,IF(B4=B3,A3,A3+1),\"\")","v":""},{"$f":"D4&\"-\"&E4","v":"-"},{"$f":"IF(I4>0,D4&\"-\"&F4&\"-\"&G4,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Jan",{"$f":"SUMIF($H$4:$I$123,\"january\",$I$4:$I$123)","v":0}]
["",{"$f":"D5&\"-\"&E5","v":"-"},{"$f":"IF(I5>0,D5&\"-\"&F5&\"-\"&G5,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"feb",{"$f":"SUMIF($H$4:$I$123,\"February\",$I$4:$I$123)","v":0}]
["","-","",null,null,null,null,null,null,null,null,null,null,"Mar",{"$f":"SUMIF($H$4:$I$123,\"March\",$I$4:$I$123)","v":0}]
["","-","",null,null,null,null,null,null,null,null,null,null,"Apr",{"$f":"SUMIF($H$4:$I$123,\"April\",$I$4:$I$123)","v":0}]
["","-","",null,null,null,null,null,null,null,null,null,null,"May",{"$f":"SUMIF($H$4:$I$123,\"May\",$I$4:$I$123)","v":0}]
["","-","",null,null,null,null,null,null,null,null,null,null,"Jun",{"$f":"SUMIF($H$4:$I$123,\"hune\",$I$4:$I$123)","v":0}]
["","-","",null,null,null,null,null,null,null,null,null,null,"Jul",{"$f":"SUMIF($H$4:$I$123,\"huly\",$I$4:$I$123)","v":0}]
["","-","",null,null,null,null,null,null,null,null,null,null,"Aug",{"$f":"SUMIF($H$4:$I$123,\"August\",$I$4:$I$123)","v":0}]
["","-","",null,null,null,null,null,null,null,null,null,null,"Sep",{"$f":"SUMIF($H$4:$I$123,\"September\",$I$4:$I$123)","v":0}]
["","-","",null,null,null,null,null,null,null,null,null,null,"Oct",{"$f":"SUMIF($H$4:$I$123,\"October\",$I$4:$I$123)","v":0}]
["","-","",null,null,null,null,null,null,null,null,null,null,"Nov",{"$f":"SUMIF($H$4:$I$123,\"November\",$I$4:$I$123)","v":0}]
["","-","",null,null,null,null,null,null,null,null,null,null,"Dec",{"$f":"SUMIF($H$4:$I$123,\"December\",$I$4:$I$123)","v":0}]
["","-","",null,null,null,null,null,null,null,null,null,null,"full year",{"$f":"SUM(O4:O15)","v":0}]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
[{"$f":"IF(I68>0,IF(B68=B67,A67,A67+1),\"\")","v":""},"-",""]
["",{"$f":"D69&\"-\"&E69","v":"-"},{"$f":"IF(I69>0,D69&\"-\"&F69&\"-\"&G69,\"\")","v":""}]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
[{"$f":"IF(I132>0,IF(B132=B131,A131,A131+1),\"\")","v":""},"-",""]
["",{"$f":"D133&\"-\"&E133","v":"-"},{"$f":"IF(I133>0,D133&\"-\"&F133&\"-\"&G133,\"\")","v":""}]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
[{"$f":"IF(I196>0,IF(B196=B195,A195,A195+1),\"\")","v":""},"-",""]
["",{"$f":"D197&\"-\"&E197","v":"-"},{"$f":"IF(I197>0,D197&\"-\"&F197&\"-\"&G197,\"\")","v":""}]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]
["","-",""]

{"sheet":"Incoming water","index":3,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,8,4,14],[19,8,19,14],[19,0,19,4],[0,0,0,14],[2,8,2,9],[4,0,4,6],[2,4,2,5]]}
["Site Incoming & Outgoing Water Data"]
[]
[{"$f":"'Plant setup'!B4","v":0},"Year",{"$f":"'Plant setup'!B7","v":0},null,"Cost of Raw Water $/m3",null,null,null,"Cost of treated Water $/m3"]
[]
["Incoming Water Usage",null,null,null,null,null,null,null,"WasteWater Effluent Discharge from WWTP on site"]
["Source Type","Month","Year","Water Used m3","Purchase Cost","production Liters","WUR",null,"Month","Year","Treated Effluent Discharged m3","Effluent BOD","Effluent COD","Effluent TSS","Effluent pH"]
[null,"Jan",{"$f":"$C$3","v":0},null,{"$f":"D7*$G$3","v":0},{"$f":"VLOOKUP(B7,'Production data'!$N$4:$O$15,2,0)","v":0},{"$f":"IFERROR(D7*1000/F7,0)","v":0},null,"Jan",{"$f":"$C$3","v":0}]
[null,"feb",0,null,0,{"$f":"VLOOKUP(B8,'Production data'!$N$4:$O$15,2,0)","v":0},{"$f":"IFERROR(D8*1000/F8,0)","v":0},null,"Feb",0]
[null,"Mar",0,null,0,{"$f":"VLOOKUP(B9,'Production data'!$N$4:$O$15,2,0)","v":0},0,null,"Mar",0]
[null,"Apr",0,null,0,{"$f":"VLOOKUP(B10,'Production data'!$N$4:$O$15,2,0)","v":0},0,null,"Apr",0]
[null,"May",0,null,0,{"$f":"VLOOKUP(B11,'Production data'!$N$4:$O$15,2,0)","v":0},0,null,"May",0]
[null,"Jun",0,null,0,{"$f":"VLOOKUP(B12,'Production data'!$N$4:$O$15,2,0)","v":0},0,null,"Jun",0]
[null,"Jul",0,null,0,{"$f":"VLOOKUP(B13,'Production data'!$N$4:$O$15,2,0)","v":0},0,null,"Jul",0]
[null,"Aug",0,null,0,{"$f":"VLOOKUP(B14,'Production data'!$N$4:$O$15,2,0)","v":0},0,null,"Aug",0]
[null,"Sep",0,null,0,{"$f":"VLOOKUP(B15,'Production data'!$N$4:$O$15,2,0)","v":0},0,null,"Sep",0]
[null,"Oct",0,null,0,{"$f":"VLOOKUP(B16,'Production data'!$N$4:$O$15,2,0)","v":0},0,null,"Oct",0]
[null,"Nov",0,null,0,{"$f":"VLOOKUP(B17,'Production data'!$N$4:$O$15,2,0)","v":0},0,null,"Nov",0]
[null,"Dec",0,null,0,{"$f":"VLOOKUP(B18,'Production data'!$N$4:$O$15,2,0)","v":0},0,null,"Dec",0]
[null,"Full year",null,{"$f":"SUM(D7:D18)","v":0},null,{"$f":"SUM(F7:F18)","v":0},{"$f":"IFERROR(SUM(D7:D18)*1000/SUM(F7:F18),0)","v":0},null,"Full year",null,{"$f":"SUM(K7:K18)","v":0}]
["Rain Water Harvested and Used on site",null,null,null,null,null,null,null,"Domestic WasteWater Effluent Discharged from Septic Drain"]
["Source Type","Month","Year","Water Used m3","Collection/ Treatment Cost $",null,null,null,"Month","Year","Domestic Effluent Discharged m3","Effluent BOD","Effluent COD","Effluent TSS","Effluent pH"]
["Rain Water Harvesting","Jan",{"$f":"$C$3","v":0},null,null,null,null,null,"Jan",{"$f":"$C$3","v":0}]
["Rain Water Harvesting","Feb",0,null,null,null,null,null,"Feb",0]
["Rain Water Harvesting","Mar",0,null,null,null,null,null,"Mar",0]
["Rain Water Harvesting","Apr",0,null,null,null,null,null,"Apr",0]
["Rain Water Harvesting","May",0,null,null,null,null,null,"May",0]
["Rain Water Harvesting","Jun",0,null,null,null,null,null,"Jun",0]
["Rain Water Harvesting","Jul",0,null,null,null,null,null,"Jul",0]
["Rain Water Harvesting","Aug",0,null,null,null,null,null,"Aug",0]
["Rain Water Harvesting","Sep",0,null,null,null,null,null,"Sep",0]
["Rain Water Harvesting","Oct",0,null,null,null,null,null,"Oct",0]
["Rain Water Harvesting","Nov",0,null,null,null,null,null,"Nov",0]
["Rain Water Harvesting","Dec",0,null,null,null,null,null,"Dec",0]

{"sheet":"mix vs WU","index":4,"n_rows":12,"n_cols":18,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[null,"cans","PET CSD","PET HF","AF","RB","NRGB","WU (L/L) actual","WU (L/L) calculated",null,null,"cans","PET CSD","PET HF","AF","RB","NRGB","total"]
["P02/Jan (P01 UK)",{"$f":"L2/$R2","v":{"$error":"#DIV/0!"}},{"$f":"M2/$R2","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,L$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,M$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,N$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,O$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,P$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,Q$1)","v":0},{"$f":"SUM(L2:Q2)","v":0}]
["P03/Feb (P02 UK)",{"$f":"L3/$R3","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,L$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,M$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,N$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,O$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,P$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,Q$1)","v":0},{"$f":"SUM(L3:Q3)","v":0}]
["P04/Mar (P03 UK)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,L$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,M$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,N$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,O$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,P$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,Q$1)","v":0},0]
["P05/Apr (P04 UK)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,L$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,M$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,N$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,O$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,P$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,Q$1)","v":0},0]
["P06/May (P05 UK)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,L$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,M$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,N$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,O$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,P$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,Q$1)","v":0},0]
["P07/Jun (P06 UK)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,L$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,M$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,N$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,O$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,P$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,Q$1)","v":0},0]
["P08/Jul (P07 UK)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,L$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,M$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,N$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,O$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,P$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,Q$1)","v":0},0]
["P09/Aug (P08 UK)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,L$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,M$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,N$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,O$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,P$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,Q$1)","v":0},0]
["P10/Sep (P09 UK)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,L$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,M$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,N$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,O$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,P$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,Q$1)","v":0},0]
["P11/Oct (P10 UK)",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,L$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,M$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,N$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,O$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,P$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,Q$1)","v":0},0]
["P12/Nov (P11 UK)",{"$f":"L12/$R12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,L$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,M$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,N$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,O$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,P$1)","v":0},{"$f":"SUMIFS('Production data'!$I$4:$I$123,'Production data'!$G$4:$G$123,Q$1)","v":0},0]

{"sheet":"Non-returnable Lines","index":5,"n_rows":178,"n_cols":17,"rows_kept":178,"cut":false,"hidden":false,"merged":[[2,0,4,0],[2,9,4,9],[0,0,0,7],[0,9,0,16]]}
["PET CSD, HF & AF",null,null,null,null,null,null,null,null,"Cans CSD/NCB"]
[]
["Total","PET CSD",{"$f":"SUMIF(B7:B180,B3,F7:F180)","v":0},null,null,null,null,null,null,"Total","Cans CSD",{"$f":"SUMIF(K7:K180,K3,O7:O180)","v":0}]
[null,"PET AF",{"$f":"SUMIF(B7:B180,B4,F7:F180)","v":0},null,null,null,null,null,null,null,"Cans HF",{"$f":"SUMIF(K7:K180,K4,O7:O180)","v":0}]
[null,"PET HF",{"$f":"SUMIF(B7:B180,B5,F7:F180)","v":0},"Opportunities vs BIC",{"$f":"SUM(H25,H9,H40,H56,H72,H88,H104,H120,H136,H152,H168)","v":0},null,null,null,null,null,"Tetrapak",{"$f":"SUMIF(K7:K180,K5,O7:O180)","v":0},"Opportunities vs BIC",{"$f":"SUM(Q25,Q9,Q40,Q56,Q72,Q88,Q104,Q120,Q136,Q152,Q168)","v":0}]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A7,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"IFERROR(F9*D7,\"\")","v":0},"WU L/L",{"$f":"IFERROR(F9/B8+1,0)","v":0},null,null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(J7,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"O9*M7","v":0},"WU L/L",{"$f":"IFERROR(O9/K8+1,0)","v":0}]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A7,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A7,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity",null,"Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(J7,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(J7,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity"]
["station","water type","comment1","comment2",{"$f":"SUM(E10:E19)","v":0},{"$f":"SUM(F10:F19)","v":0},{"$f":"SUM(G10:G19)","v":0},{"$f":"SUM(H10:H19)*D7","v":0},null,"station","water type","comment1","comment2",{"$f":"SUM(N10:N19)","v":0},{"$f":"SUM(O10:O19)","v":0},{"$f":"SUM(P10:P19)","v":0},{"$f":"SUM(Q10:Q19)*M7","v":0}]
["Rinser",null,null,null,null,null,null,null,null,"Rinser"]
["Filler Cleaning",null,null,null,null,null,null,null,null,"Filler Cleaning"]
["Filler Rollers lub",null,null,null,null,null,null,null,null,"Filler Rollers lub"]
["Filler flush (AquaFina)",null,null,null,null,null,null,null,null,"Seamer sanitation"]
["Bottle base cooling",null,null,null,null,null,null,null,null,"Warmer"]
["Container shower",null,null,null,null,null,null,null,null,"Tunnel Pasteurizer/cooler"]
["Conveyor lubrication",null,null,null,null,null,null,null,null,"Container shower"]
["Pumps cooling water",null,null,null,null,null,null,null,null,"Conveyor lubrication"]
["HF Cooling tunnel",null,null,null,null,null,null,null,null,"Pumps cooling water"]
["HF closure sanitation",null,null,null,null,null,null,null,null,"Tetrapak air filteration"]
[]
[]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A23,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"IFERROR(F25*D23,\"\")","v":0},"WU L/L",{"$f":"IFERROR(F25/B24+1,0)","v":0},null,null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(J23,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"O25*M23","v":0},"WU L/L",{"$f":"IFERROR(O25/K24+1,0)","v":0}]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A23,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A23,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity",null,"Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(J23,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(J23,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity"]
["station","water type","comment1","comment2",{"$f":"SUM(E26:E35)","v":0},{"$f":"SUM(F26:F35)","v":0},{"$f":"SUM(G26:G35)","v":0},{"$f":"SUM(H26:H35)*D23","v":0},null,"station","water type","comment1","comment2",{"$f":"SUM(N26:N35)","v":0},{"$f":"SUM(O26:O35)","v":0},{"$f":"SUM(P26:P35)","v":0},{"$f":"SUM(Q26:Q35)*M23","v":0}]
["Rinser",null,null,null,null,null,null,null,null,"Rinser"]
["Filler Cleaning",null,null,null,null,null,null,null,null,"Filler Cleaning"]
["Filler Rollers lub",null,null,null,null,null,null,null,null,"Filler Rollers lub"]
["Filler flush (AquaFina)",null,null,null,null,null,null,null,null,"Seamer sanitation"]
["Bottle base cooling",null,null,null,null,null,null,null,null,"Warmer"]
["Container shower",null,null,null,null,null,null,null,null,"Tunnel Pasteurizer/cooler"]
["Conveyor lubrication",null,null,null,null,null,null,null,null,"Container shower"]
["Pumps cooling water",null,null,null,null,null,null,null,null,"Conveyor lubrication"]
["HF Cooling tunnel",null,null,null,null,null,null,null,null,"Pumps cooling water"]
["HF closure sanitation",null,null,null,null,null,null,null,null,"Tetrapak air filteration"]
[]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A38,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"IFERROR(F40*D38,\"\")","v":0},"WU L/L",{"$f":"IFERROR(F40/B39+1,0)","v":0},null,null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(J38,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"O40*M38","v":0},"WU L/L",{"$f":"IFERROR(O40/K39+1,0)","v":0}]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A38,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A38,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity",null,"Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(J38,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(J38,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity"]
["station","water type","comment1","comment2",{"$f":"SUM(E41:E50)","v":0},{"$f":"SUM(F41:F50)","v":0},{"$f":"SUM(G41:G50)","v":0},{"$f":"SUM(H41:H50)*D38","v":0},null,"station","water type","comment1","comment2",{"$f":"SUM(N41:N50)","v":0},{"$f":"SUM(O41:O50)","v":0},{"$f":"SUM(P41:P50)","v":0},{"$f":"SUM(Q41:Q50)*M38","v":0}]
["Rinser",null,null,null,null,null,null,null,null,"Rinser"]
["Filler Cleaning",null,null,null,null,null,null,null,null,"Filler Cleaning"]
["Filler Rollers lub",null,null,null,null,null,null,null,null,"Filler Rollers lub"]
["Filler flush (AquaFina)",null,null,null,null,null,null,null,null,"Seamer sanitation"]
["Bottle base cooling",null,null,null,null,null,null,null,null,"Warmer"]
["Container shower",null,null,null,null,null,null,null,null,"Tunnel Pasteurizer/cooler"]
["Conveyor lubrication",null,null,null,null,null,null,null,null,"Container shower"]
["Pumps cooling water",null,null,null,null,null,null,null,null,"Conveyor lubrication"]
["HF Cooling tunnel",null,null,null,null,null,null,null,null,"Pumps cooling water"]
["HF closure sanitation",null,null,null,null,null,null,null,null,"Tetrapak air filteration"]
[]
[]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A54,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"IFERROR(F56*D54,\"\")","v":0},"WU L/L",{"$f":"IFERROR(F56/B55+1,0)","v":0},null,null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(J54,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"O56*M54","v":0},"WU L/L",{"$f":"IFERROR(O56/K55+1,0)","v":0}]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A54,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A54,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity",null,"Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(J54,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(J54,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity"]
["station","water type","comment1","comment2",{"$f":"SUM(E57:E66)","v":0},{"$f":"SUM(F57:F66)","v":0},{"$f":"SUM(G57:G66)","v":0},{"$f":"SUM(H57:H66)*D54","v":0},null,"station","water type","comment1","comment2",{"$f":"SUM(N57:N66)","v":0},{"$f":"SUM(O57:O66)","v":0},{"$f":"SUM(P57:P66)","v":0},{"$f":"SUM(Q57:Q66)*M54","v":0}]
["Rinser",null,null,null,null,null,null,null,null,"Rinser"]
["Filler Cleaning",null,null,null,null,null,null,null,null,"Filler Cleaning"]
["Filler Rollers lub",null,null,null,null,null,null,null,null,"Filler Rollers lub"]
["Filler flush (AquaFina)",null,null,null,null,null,null,null,null,"Seamer sanitation"]
["Bottle base cooling",null,null,null,null,null,null,null,null,"Warmer"]
["Container shower",null,null,null,null,null,null,null,null,"Tunnel Pasteurizer/cooler"]
["Conveyor lubrication",null,null,null,null,null,null,null,null,"Container shower"]
["Pumps cooling water",null,null,null,null,null,null,null,null,"Conveyor lubrication"]
["HF Cooling tunnel",null,null,null,null,null,null,null,null,"Pumps cooling water"]
["HF closure sanitation",null,null,null,null,null,null,null,null,"Tetrapak air filteration"]
[]
[]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A70,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"IFERROR(F72*D70,\"\")","v":0},"WU L/L",{"$f":"IFERROR(F72/B71+1,0)","v":0},null,null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(J70,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"O72*M70","v":0},"WU L/L",{"$f":"IFERROR(O72/K71+1,0)","v":0}]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A70,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A70,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity",null,"Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(J70,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(J70,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity"]
["station","water type","comment1","comment2",{"$f":"SUM(E73:E82)","v":0},{"$f":"SUM(F73:F82)","v":0},{"$f":"SUM(G73:G82)","v":0},{"$f":"SUM(H73:H82)*D70","v":0},null,"station","water type","comment1","comment2",{"$f":"SUM(N73:N82)","v":0},{"$f":"SUM(O73:O82)","v":0},{"$f":"SUM(P73:P82)","v":0},{"$f":"SUM(Q73:Q82)*M70","v":0}]
["Rinser",null,null,null,null,null,null,{"$f":"IF(G73>0,IF(F73>G73,F73-G73,0),0)","v":0},null,"Rinser"]
["Filler Cleaning",null,null,null,null,null,null,{"$f":"IF(G74>0,IF(F74>G74,F74-G74,0),0)","v":0},null,"Filler Cleaning"]
["Filler Rollers lub",null,null,null,null,null,null,0,null,"Filler Rollers lub"]
["Filler flush (AquaFina)",null,null,null,null,null,null,0,null,"Seamer sanitation"]
["Bottle base cooling",null,null,null,null,null,null,0,null,"Warmer"]
["Container shower",null,null,null,null,null,null,0,null,"Tunnel Pasteurizer/cooler"]
["Conveyor lubrication",null,null,null,null,null,null,0,null,"Container shower"]
["Pumps cooling water",null,null,null,null,null,null,0,null,"Conveyor lubrication"]
["HF Cooling tunnel",null,null,null,null,null,null,0,null,"Pumps cooling water"]
["HF closure sanitation",null,null,null,null,null,null,0,null,"Tetrapak air filteration"]
[]
[]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A86,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"IFERROR(F88*D86,\"\")","v":0},"WU L/L",{"$f":"IFERROR(F88/B87+1,0)","v":0},null,null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(J86,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"O88*M86","v":0},"WU L/L",{"$f":"IFERROR(O88/K87+1,0)","v":0}]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A86,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A86,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity",null,"Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(J86,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(J86,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity"]
["station","water type","comment1","comment2",{"$f":"SUM(E89:E98)","v":0},{"$f":"SUM(F89:F98)","v":0},{"$f":"SUM(G89:G98)","v":0},{"$f":"SUM(H89:H98)*D86","v":0},null,"station","water type","comment1","comment2",{"$f":"SUM(N89:N98)","v":0},{"$f":"SUM(O89:O98)","v":0},{"$f":"SUM(P89:P98)","v":0},{"$f":"SUM(Q89:Q98)*M86","v":0}]
["Rinser",null,null,null,null,null,null,{"$f":"IF(G89>0,IF(F89>G89,F89-G89,0),0)","v":0},null,"Rinser"]
["Filler Cleaning",null,null,null,null,null,null,{"$f":"IF(G90>0,IF(F90>G90,F90-G90,0),0)","v":0},null,"Filler Cleaning"]
["Filler Rollers lub",null,null,null,null,null,null,0,null,"Filler Rollers lub"]
["Filler flush (AquaFina)",null,null,null,null,null,null,0,null,"Seamer sanitation"]
["Bottle base cooling",null,null,null,null,null,null,0,null,"Warmer"]
["Container shower",null,null,null,null,null,null,0,null,"Tunnel Pasteurizer/cooler"]
["Conveyor lubrication",null,null,null,null,null,null,0,null,"Container shower"]
["Pumps cooling water",null,null,null,null,null,null,0,null,"Conveyor lubrication"]
["HF Cooling tunnel",null,null,null,null,null,null,0,null,"Pumps cooling water"]
["HF closure sanitation",null,null,null,null,null,null,0,null,"Tetrapak air filteration"]
[]
[]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A102,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"IFERROR(F104*D102,\"\")","v":0},"WU L/L",{"$f":"IFERROR(F104/B103+1,0)","v":0},null,null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(J102,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"O104*M102","v":0},"WU L/L",{"$f":"IFERROR(O104/K103+1,0)","v":0}]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A102,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A102,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity",null,"Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(J102,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(J102,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity"]
["station","water type","comment1","comment2",{"$f":"SUM(E105:E114)","v":0},{"$f":"SUM(F105:F114)","v":0},{"$f":"SUM(G105:G114)","v":0},{"$f":"SUM(H105:H114)*D102","v":0},null,"station","water type","comment1","comment2",{"$f":"SUM(N105:N114)","v":0},{"$f":"SUM(O105:O114)","v":0},{"$f":"SUM(P105:P114)","v":0},{"$f":"SUM(Q105:Q114)*M102","v":0}]
["Rinser",null,null,null,null,null,null,{"$f":"IF(G105>0,IF(F105>G105,F105-G105,0),0)","v":0},null,"Rinser"]
["Filler Cleaning",null,null,null,null,null,null,{"$f":"IF(G106>0,IF(F106>G106,F106-G106,0),0)","v":0},null,"Filler Cleaning"]
["Filler Rollers lub",null,null,null,null,null,null,0,null,"Filler Rollers lub"]
["Filler flush (AquaFina)",null,null,null,null,null,null,0,null,"Seamer sanitation"]
["Bottle base cooling",null,null,null,null,null,null,0,null,"Warmer"]
["Container shower",null,null,null,null,null,null,0,null,"Tunnel Pasteurizer/cooler"]
["Conveyor lubrication",null,null,null,null,null,null,0,null,"Container shower"]
["Pumps cooling water",null,null,null,null,null,null,0,null,"Conveyor lubrication"]
["HF Cooling tunnel",null,null,null,null,null,null,0,null,"Pumps cooling water"]
["HF closure sanitation",null,null,null,null,null,null,0,null,"Tetrapak air filteration"]
[]
[]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A118,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"IFERROR(F120*D118,\"\")","v":0},"WU L/L",{"$f":"IFERROR(F120/B119+1,0)","v":0},null,null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(J118,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"O120*M118","v":0},"WU L/L",{"$f":"IFERROR(O120/K119+1,0)","v":0}]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A118,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A118,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity",null,"Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(J118,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(J118,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity"]
["station","water type","comment1","comment2",{"$f":"SUM(E121:E130)","v":0},{"$f":"SUM(F121:F130)","v":0},{"$f":"SUM(G121:G130)","v":0},{"$f":"SUM(H121:H130)*D118","v":0},null,"station","water type","comment1","comment2",{"$f":"SUM(N121:N130)","v":0},{"$f":"SUM(O121:O130)","v":0},{"$f":"SUM(P121:P130)","v":0},{"$f":"SUM(Q121:Q130)*M118","v":0}]
["Rinser",null,null,null,null,null,null,{"$f":"IF(G121>0,IF(F121>G121,F121-G121,0),0)","v":0},null,"Rinser"]
["Filler Cleaning",null,null,null,null,null,null,{"$f":"IF(G122>0,IF(F122>G122,F122-G122,0),0)","v":0},null,"Filler Cleaning"]
["Filler Rollers lub",null,null,null,null,null,null,0,null,"Filler Rollers lub"]
["Filler flush (AquaFina)",null,null,null,null,null,null,0,null,"Seamer sanitation"]
["Bottle base cooling",null,null,null,null,null,null,0,null,"Warmer"]
["Container shower",null,null,null,null,null,null,0,null,"Tunnel Pasteurizer/cooler"]
["Conveyor lubrication",null,null,null,null,null,null,0,null,"Container shower"]
["Pumps cooling water",null,null,null,null,null,null,0,null,"Conveyor lubrication"]
["HF Cooling tunnel",null,null,null,null,null,null,0,null,"Pumps cooling water"]
["HF closure sanitation",null,null,null,null,null,null,0,null,"Tetrapak air filteration"]
[]
[]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A134,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"IFERROR(F136*D134,\"\")","v":0},"WU L/L",{"$f":"IFERROR(F136/B135+1,0)","v":0},null,null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(J134,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"O136*M134","v":0},"WU L/L",{"$f":"IFERROR(O136/K135+1,0)","v":0}]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A134,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A134,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity",null,"Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(J134,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(J134,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity"]
["station","water type","comment1","comment2",{"$f":"SUM(E137:E146)","v":0},{"$f":"SUM(F137:F146)","v":0},{"$f":"SUM(G137:G146)","v":0},{"$f":"SUM(H137:H146)*D134","v":0},null,"station","water type","comment1","comment2",{"$f":"SUM(N137:N146)","v":0},{"$f":"SUM(O137:O146)","v":0},{"$f":"SUM(P137:P146)","v":0},{"$f":"SUM(Q137:Q146)*M134","v":0}]
["Rinser",null,null,null,null,null,null,{"$f":"IF(G137>0,IF(F137>G137,F137-G137,0),0)","v":0},null,"Rinser"]
["Filler Cleaning",null,null,null,null,null,null,{"$f":"IF(G138>0,IF(F138>G138,F138-G138,0),0)","v":0},null,"Filler Cleaning"]
["Filler Rollers lub",null,null,null,null,null,null,0,null,"Filler Rollers lub"]
["Filler flush (AquaFina)",null,null,null,null,null,null,0,null,"Seamer sanitation"]
["Bottle base cooling",null,null,null,null,null,null,0,null,"Warmer"]
["Container shower",null,null,null,null,null,null,0,null,"Tunnel Pasteurizer/cooler"]
["Conveyor lubrication",null,null,null,null,null,null,0,null,"Container shower"]
["Pumps cooling water",null,null,null,null,null,null,0,null,"Conveyor lubrication"]
["HF Cooling tunnel",null,null,null,null,null,null,0,null,"Pumps cooling water"]
["HF closure sanitation",null,null,null,null,null,null,0,null,"Tetrapak air filteration"]
[]
[]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A150,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"IFERROR(F152*D150,\"\")","v":0},"WU L/L",{"$f":"IFERROR(F152/B151+1,0)","v":0},null,null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(J150,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"O152*M150","v":0},"WU L/L",{"$f":"IFERROR(O152/K151+1,0)","v":0}]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A150,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A150,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity",null,"Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(J150,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(J150,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity"]
["station","water type","comment1","comment2",{"$f":"SUM(E153:E162)","v":0},{"$f":"SUM(F153:F162)","v":0},{"$f":"SUM(G153:G162)","v":0},{"$f":"SUM(H153:H162)*D150","v":0},null,"station","water type","comment1","comment2",{"$f":"SUM(N153:N162)","v":0},{"$f":"SUM(O153:O162)","v":0},{"$f":"SUM(P153:P162)","v":0},{"$f":"SUM(Q153:Q162)*M150","v":0}]
["Rinser",null,null,null,null,null,null,{"$f":"IF(G153>0,IF(F153>G153,F153-G153,0),0)","v":0},null,"Rinser"]
["Filler Cleaning",null,null,null,null,null,null,{"$f":"IF(G154>0,IF(F154>G154,F154-G154,0),0)","v":0},null,"Filler Cleaning"]
["Filler Rollers lub",null,null,null,null,null,null,0,null,"Filler Rollers lub"]
["Filler flush (AquaFina)",null,null,null,null,null,null,0,null,"Seamer sanitation"]
["Bottle base cooling",null,null,null,null,null,null,0,null,"Warmer"]
["Container shower",null,null,null,null,null,null,0,null,"Tunnel Pasteurizer/cooler"]
["Conveyor lubrication",null,null,null,null,null,null,0,null,"Container shower"]
["Pumps cooling water",null,null,null,null,null,null,0,null,"Conveyor lubrication"]
["HF Cooling tunnel",null,null,null,null,null,null,0,null,"Pumps cooling water"]
["HF closure sanitation",null,null,null,null,null,null,0,null,"Tetrapak air filteration"]
[]
[]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A166,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"IFERROR(F168*D166,\"\")","v":0},"WU L/L",{"$f":"IFERROR(F168/B167+1,0)","v":0},null,null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(J166,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"total Lost L",{"$f":"O168*M166","v":0},"WU L/L",{"$f":"IFERROR(O168/K167+1,0)","v":0}]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A166,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A166,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity",null,"Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(J166,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(J166,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","Opportunity"]
["station","water type","comment1","comment2",{"$f":"SUM(E169:E178)","v":0},{"$f":"SUM(F169:F178)","v":0},{"$f":"SUM(G169:G178)","v":0},{"$f":"SUM(H169:H178)*D166","v":0},null,"station","water type","comment1","comment2",{"$f":"SUM(N169:N178)","v":0},{"$f":"SUM(O169:O178)","v":0},{"$f":"SUM(P169:P178)","v":0},{"$f":"SUM(Q169:Q178)*M166","v":0}]
["Rinser",null,null,null,null,null,null,{"$f":"IF(G169>0,IF(F169>G169,F169-G169,0),0)","v":0},null,"Rinser"]
["Filler Cleaning",null,null,null,null,null,null,{"$f":"IF(G170>0,IF(F170>G170,F170-G170,0),0)","v":0},null,"Filler Cleaning"]
["Filler Rollers lub",null,null,null,null,null,null,0,null,"Filler Rollers lub"]
["Filler flush (AquaFina)",null,null,null,null,null,null,0,null,"Seamer sanitation"]
["Bottle base cooling",null,null,null,null,null,null,0,null,"Warmer"]
["Container shower",null,null,null,null,null,null,0,null,"Tunnel Pasteurizer/cooler"]
["Conveyor lubrication",null,null,null,null,null,null,0,null,"Container shower"]
["Pumps cooling water",null,null,null,null,null,null,0,null,"Conveyor lubrication"]
["HF Cooling tunnel",null,null,null,null,null,null,0,null,"Pumps cooling water"]
["HF closure sanitation",null,null,null,null,null,null,0,null,"Tetrapak air filteration"]

{"sheet":"Glass Lines","index":6,"n_rows":58,"n_cols":24,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,0,7],[48,10,51,10],[48,11,51,11],[48,12,51,12],[48,13,51,13],[20,10,23,10],[20,11,23,11],[20,12,23,12],[20,13,23,13],[0,9,0,23],[6,10,9,10],[6,11,9,11],[6,12,9,12],[6,13,9,13],[6,14,9,14],[2,0,3,0],[20,9,23,9],[34,9,37,9],[48,9,51,9],[6,9,9,9],[48,14,51,14],[20,14,23,14],[34,10,37,10],[34,11,37,11],[34,12,37,12],[34,13,37,13],[34,14,37,14]]}
["Glass Bottles (RGB/NRGB)",null,null,null,null,null,null,null,null,"Bottle Washer details"]
[]
["Total","RGB",{"$f":"SUMIF(B6:B235,B3,F6:F235)","v":0},"Opportunities vs BIC",{"$f":"SUMIF(B6:B235,B3,I6:I235)","v":0}]
[null,"NRGB",{"$f":"SUMIF(B6:B235,B4,F6:F235)","v":0},"Opportunities vs BIC",{"$f":"SUMIF(B6:B235,B4,I6:I235)","v":0}]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A6,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"Total Lost L",{"$f":"F8*D6","v":0},"WU L/L",{"$f":"IFERROR(F8/B7+1,0)","v":0},{"$f":"H8","v":0},"Bottle Washer details","OEM & year","bottle size (ml)","speed (BPH)","# of pockets per carrier","fresh water auto stop with washer (Y/N)","Zone","Pressure (bar)","# of Sprayers","Nozzle size (mm)","% Fresh water","Source of Water if Recycled","theo. Consumption (OEM) (L/hr)","Actual consumption (L/hr)","comments"]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A6,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A6,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","opportunity",null,{"$f":"\"Bottle Washer \" &A6","v":"Bottle Washer "},null,null,null,null,null,"Final rinse"]
["Station","water type","comment1","comment2",{"$f":"SUM(E9:E16)","v":0},{"$f":"SUM(F9:F16)","v":0},{"$f":"SUM(G9:G16)","v":0},{"$f":"SUM(H9:H16)*D6","v":0},null,null,null,null,null,null,null,"Prefinal"]
["Bottle Washer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warm rinse"]
["Filler Cleaning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pre-rinse"]
["Filler Bottle Burst"]
["Filler Rollers lub"]
["NRGB rinser"]
["Pasteurizer/cooling tunnel"]
["Conveyor lubrication"]
["Pumps cooling water"]
[]
[]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A20,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"Total Lost L",{"$f":"F22*D20","v":0},"WU L/L",{"$f":"IFERROR(F22/B21+1,0)","v":0},{"$f":"H22","v":0},"Bottle Washer details","OEM & year","bottle size (ml)","speed (BPH)","# of pockets per carrier","fresh water auto stop with washer (Y/N)","Zone","Pressure (bar)","# of Sprayers","Nozzle size (mm)","% Fresh water","Source of Water if Recycled","theo. Consumption (OEM) (L/hr)","Actual consumption (L/hr)","comments"]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A20,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A20,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","opportunity",null,{"$f":"\"Bottle Washer \" &A20","v":"Bottle Washer "},null,null,null,null,null,"Final rinse"]
["Station","water type","comment1","comment2",{"$f":"SUM(E23:E30)","v":0},{"$f":"SUM(F23:F30)","v":0},{"$f":"SUM(G23:G30)","v":0},{"$f":"SUM(H23:H30)*D20","v":0},null,null,null,null,null,null,null,"Prefinal"]
["Bottle Washer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warm rinse"]
["Filler Cleaning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pre-rinse"]
["Filler Bottle Burst"]
["Filler Rollers lub"]
["NRGB rinser"]
["Pasteurizer/cooling tunnel"]
["Conveyor lubrication"]
["Pumps cooling water"]
[]
[]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A34,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"Total Lost L",{"$f":"F36*D34","v":0},"WU L/L",{"$f":"IFERROR(F36/B35+1,0)","v":0},{"$f":"H36","v":0},"Bottle Washer details","OEM & year","bottle size (ml)","speed (BPH)","# of pockets per carrier","fresh water auto stop with washer (Y/N)","Zone","Pressure (bar)","# of Sprayers","Nozzle size (mm)","% Fresh water","Source of Water if Recycled","theo. Consumption (OEM) (L/hr)","Actual consumption (L/hr)","comments"]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A34,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A34,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","opportunity",null,{"$f":"\"Bottle Washer \" &A34","v":"Bottle Washer "},null,null,null,null,null,"Final rinse"]
["Station","water type","comment1","comment2",{"$f":"SUM(E37:E44)","v":0},{"$f":"SUM(F37:F44)","v":0},{"$f":"SUM(G37:G44)","v":0},{"$f":"SUM(H37:H44)*D34","v":0},null,null,null,null,null,null,null,"Prefinal"]
["Bottle Washer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warm rinse"]
["Filler Cleaning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pre-rinse"]
["Filler Bottle Burst"]
["Filler Rollers lub"]
["NRGB rinser"]
["Pasteurizer/cooling tunnel"]
["Conveyor lubrication"]
["Pumps cooling water"]
[]
[]
[]
[null,null,"NE hrs",{"$f":"IFERROR(VLOOKUP(A48,'Production data'!$C$4:$L$206,9,0),\"0\")","v":"0"},"Total Lost L",{"$f":"F50*D48","v":0},"WU L/L",{"$f":"IFERROR(F50/B49+1,0)","v":0},{"$f":"H50","v":0},"Bottle Washer details","OEM & year","bottle size (ml)","speed (BPH)","# of pockets per carrier","fresh water auto stop with washer (Y/N)","Zone","Pressure (bar)","# of Sprayers","Nozzle size (mm)","% Fresh water","Source of Water if Recycled","theo. Consumption (OEM) (L/hr)","Actual consumption (L/hr)","comments"]
["Line capacity L/hr:",{"$f":"IFERROR(VLOOKUP(A48,'Production data'!$C$4:$L$206,10,0),\"0\")","v":"0"},"NE:",{"$f":"IFERROR(VLOOKUP(A48,'Production data'!$C$4:$L$206,8,0),\"0\")","v":"0"},"L/hr recycled","L/hr fresh","BIC","opportunity",null,{"$f":"\"Bottle Washer \" &A48","v":"Bottle Washer "},null,null,null,null,null,"Final rinse"]
["Station","water type","comment1","comment2",{"$f":"SUM(E51:E58)","v":0},{"$f":"SUM(F51:F58)","v":0},{"$f":"SUM(G51:G58)","v":0},{"$f":"SUM(H51:H58)*D48","v":0},null,null,null,null,null,null,null,"Prefinal"]
["Bottle Washer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warm rinse"]
["Filler Cleaning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pre-rinse"]
["Filler Bottle Burst"]
["Filler Rollers lub"]
["NRGB rinser"]
["Pasteurizer/cooling tunnel"]
["Conveyor lubrication"]
["Pumps cooling water"]

{"sheet":"CIP","index":7,"n_rows":65,"n_cols":16,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,0,0,15],[8,0,9,0],[32,0,33,0]]}
["Lines & Tanks Sanitation - Monthly"]
[]
["CIP","L/month","L/year","Opportunity",null,"TIP:",null,null,null,null,null,null,null,"days/month","months/year"]
["Lines",{"$f":"N10","v":0},{"$f":"B4*O4","v":0},{"$f":"P30","v":0},null,"Please add the water that being wasted to drain per CIP. "]
["Tanks",{"$f":"N34","v":0},{"$f":"B5*O4","v":0},{"$f":"P65","v":0},null,"Reclaimed steps to other application should NOT be considered"]
["Total CIPs",{"$f":"B5+B4","v":0},{"$f":"SUM(C4:C5)","v":0},{"$f":"SUM(D4:D5)","v":0},null,"Closed loop streams should NOT be considered"]
[null,null,null,null,null,"The above data should be based on actual full month"]
[]
["Lines","Rinse",null,null,"3 Steps",null,null,"5 steps",null,null,"7 steps",null,null,"Total lines","Cat.3/4 extension","Opportunity"]
[null,"#/month","L/rinse","L/Month","#/month","L/3S","L/Month","#/month","L/5S","L/Month","#/month","L/5S","L/Month",{"$f":"SUM(N11:N29)","v":0},"hrs"]
[null,null,null,{"$f":"C11*B11","v":0},null,null,{"$f":"F11*E11","v":0},null,null,{"$f":"I11*H11","v":0},null,null,{"$f":"L11*K11","v":0},{"$f":"J11+G11+D11+M11","v":0}]
[null,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"J12+G12+D12+M12","v":0}]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P11:P29)","v":0}]
[]
[]
["Tank name (volume)","Rinse",null,null,"3 Steps",null,null,"5 steps",null,null,"7 steps",null,null,"Total Tanks","Cat.3/4 extension","Opportunity"]
[null,"#/month","L/rinse","L/Month","#/month","L/3S","L/Month","#/month","L/5S","L/Month","#/month","L/5S","L/Month",{"$f":"SUM(N35:N64)","v":0},"hrs"]
[null,null,null,{"$f":"C35*B35","v":0},null,null,{"$f":"F35*E35","v":0},null,null,{"$f":"I35*H35","v":0},null,null,{"$f":"L35*K35","v":0},{"$f":"J35+G35+D35+M35","v":0}]
[null,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"J36+G36+D36+M36","v":0}]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,0,null,null,0,null,null,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P35:P64)","v":0}]

{"sheet":"Utilities +WTP","index":8,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,0,0,15],[50,0,72,0],[50,1,50,14],[65,1,65,15],[34,0,34,11],[25,0,25,10]]}
["Admin, Utilities & WTP - Monthly"]
[]
["Utilities + projects","L/day","L/month","L/Year","Opportunity",null,null,null,null,null,"days/month","months/year"]
["Boiler & Steam network",{"$f":"IFERROR(C4/K4,0)","v":0},{"$f":"I32","v":0},{"$f":"C4*L4","v":0},{"$f":"K32","v":0}]
["Admin & Others",{"$f":"IFERROR(C5/K5,0)","v":0},{"$f":"D24","v":0},{"$f":"C5*L5","v":0},{"$f":"F24","v":0}]
["Cooling towers",{"$f":"IFERROR(C6/K6, 0)","v":0},{"$f":"I47","v":0},{"$f":"C6*L6","v":0},{"$f":"L47","v":0}]
["WTP Filters",{"$f":"IFERROR(C7/K7,0)","v":0},{"$f":"M64","v":0},{"$f":"C7*L7","v":0},{"$f":"O64","v":0}]
["WTP RO",{"$f":"IFERROR(C8/K8, 0)","v":0},{"$f":"N73","v":0},{"$f":"C8*L8","v":0},{"$f":"P73","v":0}]
["Projects"]
[]
["Admin & others - Monthly"]
["Application","Purpose of Water Use","water type","L/month","BIC","Opportunity","Headcount"]
["Kitchen/Canteen",null,null,null,null,null,"TPP hours"]
["Admin Offices",null,null,null,null,null,"Admin usage",{"$f":"IFERROR(SUM(D13:D15)/H13,0)","v":0}]
["Labor Locker room"]
["WWTP"]
["QC Labs"]
["Warehouses"]
["Warehouses"]
["Cleaning inside halls"]
["Cleaning outside grounds"]
["Landscaping"]
["Others"]
["Total",null,null,{"$f":"SUM(D13:D23)","v":0},{"$f":"SUM(E13:E23)","v":0},{"$f":"SUM(F13:F23)","v":0}]
[]
["Boiler & Steam Network"]
[null,"Type","capacity tons","Blowdown type","# of BD/month","L/BD","Total BD (L)","Network losses","Make up L/month","BIC","Opportunity"]
["Boiler1",null,null,null,null,null,{"$f":"F28*E28","v":0},{"$f":"I28-G28","v":0},null,null,{"$f":"IF(J28>0,IF(I28>J28,I28-J28,0),0)","v":0}]
["Boiler2",null,null,null,null,null,{"$f":"F29*E29","v":0},{"$f":"I29-G29","v":0},null,null,{"$f":"IF(J29>0,IF(I29>J29,I29-J29,0),0)","v":0}]
["Boiler3",null,null,null,null,null,{"$f":"F30*E30","v":0},{"$f":"I30-G30","v":0},null,null,{"$f":"IF(J30>0,IF(I30>J30,I30-J30,0),0)","v":0}]
["Boiler4",null,null,null,null,null,{"$f":"F31*E31","v":0},{"$f":"I31-G31","v":0},null,null,{"$f":"IF(J31>0,IF(I31>J31,I31-J31,0),0)","v":0}]
["Total",null,null,null,null,null,null,{"$f":"SUM(H28:H31)","v":0},{"$f":"SUM(I28:I31)","v":0},{"$f":"SUM(J28:J30)","v":0},{"$f":"SUM(K28:K30)","v":0}]
[]
[]
["Cooling Towers - Monthly"]
[null,"Basin capacity m3","Cooling capacity (TR)","application","Blowdown type","# of BD/month","L/BD","Total BD (L/month)","makeup L/month","Evaporation","BIC Design","Opportunity"]
["CT1",null,null,null,null,null,null,{"$f":"G37*F37","v":0},null,{"$f":"I37-H37","v":0},null,{"$f":"IF(K37>0,IF(I37>K37,I37-K37,0),0)","v":0}]
["CT2",null,null,null,null,null,null,{"$f":"G38*F38","v":0},null,{"$f":"I38-H38","v":0},null,{"$f":"IF(K38>0,IF(I38>K38,I38-K38,0),0)","v":0}]
["CT3",null,null,null,null,null,null,0,null,{"$f":"I39-H39","v":0},null,0]
["CT4",null,null,null,null,null,null,0,null,0,null,0]
["CT5",null,null,null,null,null,null,0,null,0,null,0]
["CT6",null,null,null,null,null,null,0,null,0,null,0]
["CT7",null,null,null,null,null,null,0,null,0,null,0]
["CT8",null,null,null,null,null,null,0,null,0,null,0]
["CT9",null,null,null,null,null,null,0,null,0,null,0]
["CT10",null,null,null,null,null,null,0,null,0,null,0]
["Total",null,null,null,null,null,null,{"$f":"SUM(H37:H46)","v":0},{"$f":"SUM(I37:I46)","v":0},{"$f":"SUM(J37:J46)","v":0},{"$f":"SUM(K37:K46)","v":0},{"$f":"SUM(L37:L46)","v":0}]
[]
[]
[]
["Water \nTreatment \nplant \n(monthly)","Filters (Pre/Post treatment)"]
[null,"Treatment station name","unit","# of units","# BW per month","L/BW","# Hot Sanitation per month","L/Sanitation","CEB per month","L/ CEB ","chemical cleaning / regeneration per month","L/cleaning\nL/regeneration","Total water wasted / month","BIC","Opportunity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N53>0,IF(M53>N53,M53-N53,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N54>0,IF(M54>N54,M54-N54,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M53:M63)","v":0},{"$f":"SUM(N53:N62)","v":0},{"$f":"SUM(O53:O63)","v":0}]
[]
[null,"Reverse Osmosis"]
[null,"Membrane","Rinse per month","L/Rinse","CIP per month","L per CIP","inlet (L)","RO hot sanitation/month","RO hot sanitation L/sanitation","reject (L)","CEB per month","L/ CEB ","recovery (%)","Total water wasted / month","BIC","Opportunity"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J68+G68>0,1-J68/G68,\"\")","v":""},null,"`",{"$f":"IF(O68>0,IF(N68>O68,N68-O68,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF(O69>0,IF(N69>O69,N69-O69,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J72+G72>0,1-J72/G72,\"\")","v":""},null,null,0]
[null,"Total WTP losses",null,null,null,{"$f":"SUM(F68:F72)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(N68:N72)","v":0},{"$f":"SUM(O68:O72)","v":0},{"$f":"SUM(P68:P72)","v":0}]

{"sheet":"Water Balance","index":9,"n_rows":58,"n_cols":30,"rows_kept":58,"cut":false,"hidden":false,"merged":[[14,26,16,27],[10,29,11,31],[3,29,3,31],[8,29,8,31],[9,29,9,31],[4,29,6,31],[3,26,3,27],[4,26,6,27],[8,26,8,27],[9,26,11,27],[13,26,13,27]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Incoming",null,null,"Water Capex $m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N57+N58","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Outgoing",null,null,"Water Storage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N55,N49,N54)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xx days"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accuracy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(AA10/AA5,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"evaporation",null,{"$f":"'Utilities +WTP'!J47/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Utilities",null,{"$f":"('Output-Tier 1&2'!C9)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"WTP total",null,{"$f":"'Output-Tier 1&2'!C13/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Projects"]
[null,null,null,null,null,null,null,null,null,null,null,"CIP",null,{"$f":"'Output-Tier 1&2'!C17/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"product",null,{"$f":"'Output-Tier 1&2'!I21*'Output-Tier 1&2'!E21/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"WWTP",null,{"$f":"(SUM('Incoming water'!K7:K18,'Incoming water'!K22:K33))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"process",null,{"$f":"'Output-Tier 1&2'!C4/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"incoming water",null,{"$f":"SUM('Incoming water'!D7:D18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"rain",null,{"$f":"'AWS requirement'!$B$13","v":0}]

{"sheet":"Output-Tier 1&2","index":10,"n_rows":57,"n_cols":9,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
[null,"The Below data is based on Peak full month "]
[null,null,"Losses in Liters","% weight","Losses in $","Losses L/L","Opportunity (L)","Opportunity ($)","Saving in L/L"]
[null,"Total",{"$f":"SUM(C4,C9,C13,C16,C17)","v":0},{"$f":"SUM(D4,D9,D13,D16,D17)","v":0},{"$f":"SUM(E4,E9,E13,E16,E17)","v":0},{"$f":"IFERROR(C3/$E$21,\"\")","v":""},{"$f":"SUM(G4,G9,G13,G16,G17)","v":0},{"$f":"SUM(H4,H9,H13,H16,H17)","v":0},{"$f":"IFERROR(SUM(I4,I9,I13,I16),0)","v":0}]
[null,"Production lines",{"$f":"SUM(C5:C8)","v":0},{"$f":"IFERROR(C4/$C$3,\"\")","v":""},{"$f":"C4*$H$21/1000","v":0},"",{"$f":"SUM(G5:G8)","v":0},{"$f":"(G4*$H$21)/1000","v":0},{"$f":"IFERROR(G4/$E$21,0)","v":0}]
[null,"RGB",{"$f":"'Glass Lines'!C3","v":0},"",{"$f":"(C5*$H$21)/1000","v":0},"",{"$f":"'Glass Lines'!E3","v":0},{"$f":"(G5*$H$21)/1000","v":0},0]
[null,"Cans/Tetra",{"$f":"SUM('Non-returnable Lines'!L3:L5)","v":0},"",{"$f":"(C6*$H$21)/1000","v":0},"",{"$f":"'Non-returnable Lines'!N5","v":0},{"$f":"(G6*$H$21)/1000","v":0},0]
[null,"PET (CSD/HF/AF)",{"$f":"SUM('Non-returnable Lines'!C3:C5)","v":0},"",{"$f":"(C7*$H$21)/1000","v":0},"",{"$f":"'Non-returnable Lines'!E5","v":0},{"$f":"(G7*$H$21)/1000","v":0},0]
[null,"NRGB",{"$f":"'Glass Lines'!C4","v":0},"",{"$f":"(C8*$H$21)/1000","v":0},"",{"$f":"'Glass Lines'!E4","v":0},{"$f":"(G8*$H$21)/1000","v":0},0]
[null,"Utilities",{"$f":"SUM(C10:C12)","v":0},"",{"$f":"C9*$H$21","v":0},"",{"$f":"SUM(G10:G12)","v":0},{"$f":"G9*$H$21","v":0},0]
[null,"Boiler & Steam network",{"$f":"'Utilities +WTP'!C4","v":0},"",{"$f":"(C10*$H$21)/1000","v":0},"",{"$f":"'Utilities +WTP'!E4","v":0},{"$f":"(G10*$H$21)/1000","v":0},0]
[null,"Admin & Others",{"$f":"'Utilities +WTP'!C5","v":0},"",{"$f":"(C11*$H$21)/1000","v":0},"",{"$f":"'Utilities +WTP'!E5","v":0},{"$f":"(G11*$H$21)/1000","v":0},0]
[null,"Cooling towers",{"$f":"'Utilities +WTP'!C6","v":0},"",{"$f":"(C12*$H$21)/1000","v":0},"",{"$f":"'Utilities +WTP'!E6","v":0},{"$f":"(G12*$H$21)/1000","v":0},0]
[null,"WTP total",{"$f":"C14+C15","v":0},"",0,"",{"$f":"SUM(G14:G15)","v":0},{"$f":"G13*$H$21","v":0},0]
[null,{"$f":"'Utilities +WTP'!A7","v":"WTP Filters"},{"$f":"'Utilities +WTP'!C7","v":0},"",{"$f":"(C14*$H$21)/1000","v":0},"",{"$f":"'Utilities +WTP'!E7","v":0},{"$f":"(G14*$H$21)/1000","v":0},0]
[null,{"$f":"'Utilities +WTP'!A8","v":"WTP RO"},{"$f":"'Utilities +WTP'!C8","v":0},"",{"$f":"(C15*$H$21)/1000","v":0},"",{"$f":"'Utilities +WTP'!E8","v":0},{"$f":"(G15*$H$21)/1000","v":0},0]
[null,"Projects",{"$f":"'Utilities +WTP'!C9","v":0},"",0,"",{"$f":"IFERROR(F16-A16,0)","v":0},{"$f":"IFERROR(G16*$H$21,0)","v":0},0]
[null,"CIP",{"$f":"SUM(C18:C19)","v":0},"",0,"",{"$f":"SUM(G18:G19)","v":0},0,0]
[null,"Lines",{"$f":"CIP!B4","v":0},"",{"$f":"(C18*$H$21)/1000","v":0},"",{"$f":"CIP!D4","v":0},{"$f":"(G18*$H$21)/1000","v":0},0]
[null,"Tanks",{"$f":"CIP!B5","v":0},"",{"$f":"(C19*$H$21)/1000","v":0},"",{"$f":"CIP!D5","v":0},{"$f":"(G19*$H$21)/1000","v":0},0]
[null,"Targeted month in profiler","WWTP effluent","WU calc w/o theo","Production in Liters","WU actual full month","Error %","$/m3","ingredient WUR"]
[null,null,{"$f":"IFERROR(VLOOKUP(B21,'Incoming water'!I7:K19,2,0),0)","v":0},{"$f":"IFERROR((C3+C16)/E21+I21,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B21,'Incoming water'!$B$7:$F$19,5,0),0)","v":0},{"$f":"IFERROR(VLOOKUP(B21,'Incoming water'!B7:G19,6,0),0)","v":0},{"$f":"IFERROR(F21/D21-1,\"\")","v":""},{"$f":"'Incoming water'!G3","v":0}]
[]
[null,null,null,null,null,null,null,"Non-Tech","Technology"]
[null,null,null,null,null,null,"Saving L/L"]
[null,null,null,null,null,null,"new KPI"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Zerobase",{"$f":"I21","v":0}]
[{"$f":"B4","v":"Production lines"},{"$f":"F4","v":""}]
[{"$f":"B9","v":"Utilities"},{"$f":"F9","v":""}]
[{"$f":"B13","v":"WTP total"},{"$f":"F13","v":""}]
[{"$f":"B17","v":"CIP"},{"$f":"F17","v":""}]
[{"$f":"B16","v":"Projects"},{"$f":"F16","v":""}]
["error",{"$f":"IFERROR(B50-SUM(B43:B48),0)","v":0}]
[{"$f":"F20","v":"WU actual full month"},{"$f":"IFERROR(F21,0)","v":0}]
["Baseline",{"$f":"D21","v":""}]
[{"$f":"A44","v":"Production lines"},{"$f":"IFERROR((I4)*-1,0)","v":0}]
[{"$f":"A45","v":"Utilities"},{"$f":"IFERROR((I9)*-1,0)","v":0}]
[{"$f":"A46","v":"WTP total"},{"$f":"IFERROR((I13)*-1,0)","v":0}]
[{"$f":"A47","v":"CIP"},{"$f":"IFERROR((I17)*-1,0)","v":0}]
[{"$f":"A48","v":"Projects"},{"$f":"IFERROR((I16)*-1,0)","v":0}]
["Landing WUR",{"$f":"IFERROR(B51+SUM(B52:B56),0)","v":0}]

{"sheet":"Cans","index":11,"n_rows":236,"n_cols":6,"rows_kept":236,"cut":false,"hidden":true,"merged":[[0,0,0,5]]}
["Cans CSD"]
[null,null,null,null,"TE:"]
[null,null,null,null,"NE:"]
["Line name:","Cans1","Line capacity L/hr:",{"$f":"36000*0.35","v":12600},"WU L/L",{"$f":"F15/D4+1","v":1.6944444444444444}]
["station","water type",null,null,"L/hr recycled","L/hr fresh"]
["Rinser","fresh","# of nozzles","Nozzle size",null,8000]
["Filler Cleaning",null,"hose size","Guns/hoses?",null,{"$f":"3000/20","v":150}]
["Filler Rollers lub","recycled",null,"auto stop?",null,500]
["Seamer sanitation","fresh","time/freq?","auto/manual"]
["Warmer",null,null,"dew point ctrl?"]
["Tunnel Pasteurizer"]
["Container shower"]
["Conveyor lubrication","recycled",null,"Dry/semi/wet",null,100]
["Pumps cooling water","fresh",null,"open/closed/reclaimed",1000]
[null,null,null,null,{"$f":"SUM(E6:E14)","v":1000},{"$f":"SUM(F6:F14)","v":8750}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TE:"]
[null,null,null,null,"NE:"]
["Line name:","Cans1","Line capacity L/hr:",{"$f":"36000*0.35","v":12600},"WU L/L",{"$f":"F36/D25+1","v":1.6944444444444444}]
["station","water type",null,null,"L/hr recycled","L/hr fresh"]
["Rinser","fresh","# of nozzles","Nozzle size",null,8000]
["Filler Cleaning",null,"hose size","Guns/hoses?",null,{"$f":"3000/20","v":150}]
["Filler Rollers lub","recycled",null,"auto stop?",null,500]
["Seamer sanitation","fresh","time/freq?","auto/manual"]
["Warmer",null,null,"dew point ctrl?"]
["Tunnel Pasteurizer"]
["Container shower"]
["Conveyor lubrication","recycled",null,"Dry/semi/wet",null,100]
["Pumps cooling water","fresh",null,"open/closed/reclaimed",1000]
[null,null,null,null,{"$f":"SUM(E27:E35)","v":1000},{"$f":"SUM(F27:F35)","v":8750}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TE:"]
[null,null,null,null,"NE:"]
["Line name:","Cans1","Line capacity L/hr:",{"$f":"36000*0.35","v":12600},"WU L/L",{"$f":"F56/D45+1","v":1.6944444444444444}]
["station","water type",null,null,"L/hr recycled","L/hr fresh"]
["Rinser","fresh","# of nozzles","Nozzle size",null,8000]
["Filler Cleaning",null,"hose size","Guns/hoses?",null,{"$f":"3000/20","v":150}]
["Filler Rollers lub","recycled",null,"auto stop?",null,500]
["Seamer sanitation","fresh","time/freq?","auto/manual"]
["Warmer",null,null,"dew point ctrl?"]
["Tunnel Pasteurizer"]
["Container shower"]
["Conveyor lubrication","recycled",null,"Dry/semi/wet",null,100]
["Pumps cooling water","fresh",null,"open/closed/reclaimed",1000]
[null,null,null,null,{"$f":"SUM(E47:E55)","v":1000},{"$f":"SUM(F47:F55)","v":8750}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TE:"]
[null,null,null,null,"NE:"]
["Line name:","Cans1","Line capacity L/hr:",{"$f":"36000*0.35","v":12600},"WU L/L",{"$f":"F76/D65+1","v":1.6944444444444444}]
["station","water type",null,null,"L/hr recycled","L/hr fresh"]
["Rinser","fresh","# of nozzles","Nozzle size",null,8000]
["Filler Cleaning",null,"hose size","Guns/hoses?",null,{"$f":"3000/20","v":150}]
["Filler Rollers lub","recycled",null,"auto stop?",null,500]
["Seamer sanitation","fresh","time/freq?","auto/manual"]
["Warmer",null,null,"dew point ctrl?"]
["Tunnel Pasteurizer"]
["Container shower"]
["Conveyor lubrication","recycled",null,"Dry/semi/wet",null,100]
["Pumps cooling water","fresh",null,"open/closed/reclaimed",1000]
[null,null,null,null,{"$f":"SUM(E67:E75)","v":1000},{"$f":"SUM(F67:F75)","v":8750}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TE:"]
[null,null,null,null,"NE:"]
["Line name:","Cans1","Line capacity L/hr:",{"$f":"36000*0.35","v":12600},"WU L/L",{"$f":"F96/D85+1","v":1.6944444444444444}]
["station","water type",null,null,"L/hr recycled","L/hr fresh"]
["Rinser","fresh","# of nozzles","Nozzle size",null,8000]
["Filler Cleaning",null,"hose size","Guns/hoses?",null,{"$f":"3000/20","v":150}]
["Filler Rollers lub","recycled",null,"auto stop?",null,500]
["Seamer sanitation","fresh","time/freq?","auto/manual"]
["Warmer",null,null,"dew point ctrl?"]
["Tunnel Pasteurizer"]
["Container shower"]
["Conveyor lubrication","recycled",null,"Dry/semi/wet",null,100]
["Pumps cooling water","fresh",null,"open/closed/reclaimed",1000]
[null,null,null,null,{"$f":"SUM(E87:E95)","v":1000},{"$f":"SUM(F87:F95)","v":8750}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TE:"]
[null,null,null,null,"NE:"]
["Line name:","Cans1","Line capacity L/hr:",{"$f":"36000*0.35","v":12600},"WU L/L",{"$f":"F116/D105+1","v":1.6944444444444444}]
["station","water type",null,null,"L/hr recycled","L/hr fresh"]
["Rinser","fresh","# of nozzles","Nozzle size",null,8000]
["Filler Cleaning",null,"hose size","Guns/hoses?",null,{"$f":"3000/20","v":150}]
["Filler Rollers lub","recycled",null,"auto stop?",null,500]
["Seamer sanitation","fresh","time/freq?","auto/manual"]
["Warmer",null,null,"dew point ctrl?"]
["Tunnel Pasteurizer"]
["Container shower"]
["Conveyor lubrication","recycled",null,"Dry/semi/wet",null,100]
["Pumps cooling water","fresh",null,"open/closed/reclaimed",1000]
[null,null,null,null,{"$f":"SUM(E107:E115)","v":1000},{"$f":"SUM(F107:F115)","v":8750}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TE:"]
[null,null,null,null,"NE:"]
["Line name:","Cans1","Line capacity L/hr:",{"$f":"36000*0.35","v":12600},"WU L/L",{"$f":"F136/D125+1","v":1.6944444444444444}]
["station","water type",null,null,"L/hr recycled","L/hr fresh"]
["Rinser","fresh","# of nozzles","Nozzle size",null,8000]
["Filler Cleaning",null,"hose size","Guns/hoses?",null,{"$f":"3000/20","v":150}]
["Filler Rollers lub","recycled",null,"auto stop?",null,500]
["Seamer sanitation","fresh","time/freq?","auto/manual"]
["Warmer",null,null,"dew point ctrl?"]
["Tunnel Pasteurizer"]
["Container shower"]
["Conveyor lubrication","recycled",null,"Dry/semi/wet",null,100]
["Pumps cooling water","fresh",null,"open/closed/reclaimed",1000]
[null,null,null,null,{"$f":"SUM(E127:E135)","v":1000},{"$f":"SUM(F127:F135)","v":8750}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TE:"]
[null,null,null,null,"NE:"]
["Line name:","Cans1","Line capacity L/hr:",{"$f":"36000*0.35","v":12600},"WU L/L",{"$f":"F156/D145+1","v":1.6944444444444444}]
["station","water type",null,null,"L/hr recycled","L/hr fresh"]
["Rinser","fresh","# of nozzles","Nozzle size",null,8000]
["Filler Cleaning",null,"hose size","Guns/hoses?",null,{"$f":"3000/20","v":150}]
["Filler Rollers lub","recycled",null,"auto stop?",null,500]
["Seamer sanitation","fresh","time/freq?","auto/manual"]
["Warmer",null,null,"dew point ctrl?"]
["Tunnel Pasteurizer"]
["Container shower"]
["Conveyor lubrication","recycled",null,"Dry/semi/wet",null,100]
["Pumps cooling water","fresh",null,"open/closed/reclaimed",1000]
[null,null,null,null,{"$f":"SUM(E147:E155)","v":1000},{"$f":"SUM(F147:F155)","v":8750}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TE:"]
[null,null,null,null,"NE:"]
["Line name:","Cans1","Line capacity L/hr:",{"$f":"36000*0.35","v":12600},"WU L/L",{"$f":"F176/D165+1","v":1.6944444444444444}]
["station","water type",null,null,"L/hr recycled","L/hr fresh"]
["Rinser","fresh","# of nozzles","Nozzle size",null,8000]
["Filler Cleaning",null,"hose size","Guns/hoses?",null,{"$f":"3000/20","v":150}]
["Filler Rollers lub","recycled",null,"auto stop?",null,500]
["Seamer sanitation","fresh","time/freq?","auto/manual"]
["Warmer",null,null,"dew point ctrl?"]
["Tunnel Pasteurizer"]
["Container shower"]
["Conveyor lubrication","recycled",null,"Dry/semi/wet",null,100]
["Pumps cooling water","fresh",null,"open/closed/reclaimed",1000]
[null,null,null,null,{"$f":"SUM(E167:E175)","v":1000},{"$f":"SUM(F167:F175)","v":8750}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TE:"]
[null,null,null,null,"NE:"]
["Line name:","Cans1","Line capacity L/hr:",{"$f":"36000*0.35","v":12600},"WU L/L",{"$f":"F196/D185+1","v":1.6944444444444444}]
["station","water type",null,null,"L/hr recycled","L/hr fresh"]
["Rinser","fresh","# of nozzles","Nozzle size",null,8000]
["Filler Cleaning",null,"hose size","Guns/hoses?",null,{"$f":"3000/20","v":150}]
["Filler Rollers lub","recycled",null,"auto stop?",null,500]
["Seamer sanitation","fresh","time/freq?","auto/manual"]
["Warmer",null,null,"dew point ctrl?"]
["Tunnel Pasteurizer"]
["Container shower"]
["Conveyor lubrication","recycled",null,"Dry/semi/wet",null,100]
["Pumps cooling water","fresh",null,"open/closed/reclaimed",1000]
[null,null,null,null,{"$f":"SUM(E187:E195)","v":1000},{"$f":"SUM(F187:F195)","v":8750}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TE:"]
[null,null,null,null,"NE:"]
["Line name:","Cans1","Line capacity L/hr:",{"$f":"36000*0.35","v":12600},"WU L/L",{"$f":"F216/D205+1","v":1.6944444444444444}]
["station","water type",null,null,"L/hr recycled","L/hr fresh"]
["Rinser","fresh","# of nozzles","Nozzle size",null,8000]
["Filler Cleaning",null,"hose size","Guns/hoses?",null,{"$f":"3000/20","v":150}]
["Filler Rollers lub","recycled",null,"auto stop?",null,500]
["Seamer sanitation","fresh","time/freq?","auto/manual"]
["Warmer",null,null,"dew point ctrl?"]
["Tunnel Pasteurizer"]
["Container shower"]
["Conveyor lubrication","recycled",null,"Dry/semi/wet",null,100]
["Pumps cooling water","fresh",null,"open/closed/reclaimed",1000]
[null,null,null,null,{"$f":"SUM(E207:E215)","v":1000},{"$f":"SUM(F207:F215)","v":8750}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TE:"]
[null,null,null,null,"NE:"]
["Line name:","Cans1","Line capacity L/hr:",{"$f":"36000*0.35","v":12600},"WU L/L",{"$f":"F236/D225+1","v":1.6944444444444444}]
["station","water type",null,null,"L/hr recycled","L/hr fresh"]
["Rinser","fresh","# of nozzles","Nozzle size",null,8000]
["Filler Cleaning",null,"hose size","Guns/hoses?",null,{"$f":"3000/20","v":150}]
["Filler Rollers lub","recycled",null,"auto stop?",null,500]
["Seamer sanitation","fresh","time/freq?","auto/manual"]
["Warmer",null,null,"dew point ctrl?"]
["Tunnel Pasteurizer"]
["Container shower"]
["Conveyor lubrication","recycled",null,"Dry/semi/wet",null,100]
["Pumps cooling water","fresh",null,"open/closed/reclaimed",1000]
[null,null,null,null,{"$f":"SUM(E227:E235)","v":1000},{"$f":"SUM(F227:F235)","v":8750}]

{"sheet":"AWS requirement","index":12,"n_rows":20,"n_cols":22,"rows_kept":20,"cut":false,"hidden":true,"merged":[[13,21,13,22],[14,21,14,22],[16,21,16,22],[17,21,17,22],[0,1,0,18],[5,17,7,18],[10,17,12,18],[15,17,17,18],[4,17,4,18],[9,17,9,18],[14,17,14,18]]}
[null,"Facility Water Balance (m3)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"('Utilities +WTP'!H32+'Utilities +WTP'!J47)/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Incoming"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B13,B10)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Output-Tier 1&2'!$E$21/1000","v":0}]
[]
[null,{"$f":"'Incoming water'!D19","v":0},null,null,null,null,"Tanks",null,null,null,null,null,null,null,null,null,null,"Total Outgoing"]
[null,null,null,null,null,"m3",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P23,P20,P16,P12,P8,P4)","v":0}]
[null,null,null,null,null,"DOS",null,null,null,null,null,null,null,null,null,{"$f":"SUM('Incoming water'!K7:K18)","v":0}]
[null,{"$f":"SUM('Incoming water'!D22:D33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Capex $m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accuracy",null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('Incoming water'!K22:K33)","v":0},null,{"$f":"R11/R6","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost of treating water"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Utilities +WTP'!D22/1000","v":0}]