{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Silica Gel Calculator v1","Silica Gel Inputs v2","Calcium Chloride Calculator","CACi2 inputs"],"not_rendered":{"charts":0,"images":20,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Silica Gel Calculator v1","index":0,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[[4,3,4,11]]}
[]
[]
[]
[]
[null,null,null,"INPUTS"]
[null,null,null,"Input your annual silica gel usage"]
[null,null,null,"Step 1: Input estimated number of silica gel bags used anually (millions of bags)"]
[null,null,null,"Step 2: Input the average weight of the bags (select size from the dropdown list)"]
[]
[{"$nulls":4},"Input Number of Sachets",null,null,100,"Million"]
[{"$nulls":4},"Input Weight of Each Sachet ",null,null,5,"Grams","*Click cell to select from dropdown list"]

{"sheet":"Silica Gel Inputs v2","index":1,"n_rows":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":true,"merged":[[55,4,55,6],[57,4,57,6],[52,4,52,6],[54,4,54,6],[5,1,5,7],[6,2,6,6],[19,1,19,7],[7,1,7,7],[51,1,51,7]]}
[]
[]
[]
[]
[]
[null,"SILICA GEL MATERIAL WASTE CALCULATOR"]
[]
[null,"INPUTS"]
[]
[null,null,"Annual Silica Gel Usage "]
[null,null,"Number of sachets",{"$f":"D16*1000000","v":{"$error":"#REF!"}}]
[null,null,"Step 1: Input estimated number of silica gel bags used anually (millions of bags)"]
[null,null,"Step 2: Input the average weight of the bags (select size from the dropdown list)"]
[]
[]
[null,null,"Input Number of Sachets",{"$f":"#REF!","v":{"$error":"#REF!"}},"Million"]
[null,null,"Input Weight of Each Sachet ",{"$f":"#REF!","v":{"$error":"#REF!"}},"Grams","*Click cell to select size from dropdown list"]
[]
[]
[null,"RESULTS"]
[]
[null,null,"Silica Gel Waste to Landfill"]
[]
[null,null,"Silica Gel Beads",{"$f":"(D11*D17)/1000000","v":{"$error":"#REF!"}},"Metric Tonnes"]
[null,null,"Plastic Packaging (Quantity)",{"$f":"IF(D17=2,(D39*D11)/10000,IF(D17=5,D40*D11/10000,IF(D17=10,D41*D11/10000,IF(D17=25,D42*D11/10000,IF(D17=50,D43*D11/10000,IF(D17=1,D38*D11/10000,\"\"))))))","v":{"$error":"#REF!"}},"Square Meters"]
[null,null,"Equivalent to:",{"$f":"ROUNDUP(D25/7000,2)","v":{"$error":"#REF!"}},"Soccer Pitches"]
[null,null,null,{"$f":"ROUNDUP(D25/5500,0)","v":{"$error":"#REF!"}},"American Football Fields (incl. end zones)"]
[null,null,"Plastic Packaging (Weight)",{"$f":"IF(D17=2,(E39*D11)/1000,IF(D17=5,E40*D11/1000,IF(D17=10,E41*D11/1000,IF(D17=25,E42*D11/1000,IF(D17=50,E43*D11/1000,IF(D17=1,E38*D11/1000,\"\"))))))","v":{"$error":"#REF!"}},"Kilograms",null,{"$f":"ROUNDUP(D28/1000,0)","v":{"$error":"#REF!"}},"MT"]
[null,null,"Equivalent to:",{"$f":"(D28*1000)/20","v":{"$error":"#REF!"}},"1 Litre Plastic Bottles (20g per litre)"]
[]
[null,null,"Micro-Pak Dri Clay® Equivalent Waste to Landfill"]
[]
[null,null,"Natural Clay",{"$f":"D24","v":{"$error":"#REF!"}},"Metric Tonnes"]
[null,null,"Plastic Waste (Quantity & Weight)","ZERO","Square Meters / Kilograms"]
[]
[]
[null,null,"Weight (grams)","Size (cm²)","Weight (g)"]
[null,null,1,{"$f":"(2.2*4.2)*2","v":18.480000000000004},0.16]
[null,null,2,{"$f":"(3.5*5)*2","v":35},0.27]
[null,null,5,{"$f":"(3.5*6)*2","v":42},0.47]
[null,null,10,{"$f":"(3.5*9.6)*2","v":67.2},0.82]
[null,null,25,{"$f":"(8.5*11.5)*2","v":195.5},1.3]
[null,null,50,{"$f":"(9*12.5)*2","v":225},1.85]
[]
[]
[]
[null,null,"Silica Gel Output",45000,"MT",null,"1MT of silica gel needs:"]
[null,null,"Sodium Silicate",63000,"MT",null,"Sodium Silicate (MT)",{"$f":"(D48/D47)/1000","v":1.4E-3},"MT"]
[null,null,"Sulphuric Acid",22500,"MT"]
[null,null,"Fresh Water",855000,"MT",null,"Fresh Water (Litres)",{"$f":"(D50/D47)*1000","v":19000},"Ltr"]
[null,null,"Waste Water",697000,"MT",null,"Waste Water (Litres)",{"$f":"(D51/D47)*1000","v":15488.888888888889},"Ltr"]
[null,"CHEMICAL INPUTS & WATER CONSUMPTION"]
[null,null,"Sodium Silicate",{"$f":"((D48/D47))*D24","v":{"$error":"#REF!"}},"Metric Tonnes"]
[null,null,"Fresh Water",{"$f":"((D50/D47))*D24","v":{"$error":"#REF!"}},"Metric Tonnes"]
[null,null,"Sulphuric Acid",{"$f":"(D49/D47)*D24","v":{"$error":"#REF!"}},"Metric Tonnes"]
[null,null,"Fresh Water",{"$f":"D54*1000","v":{"$error":"#REF!"}},"Litres"]
[null,null,"Waste Water",{"$f":"(D51/D47)*D24","v":{"$error":"#REF!"}},"Metric Tonnes"]
[null,null,"Waste Water",{"$f":"D57*1000","v":{"$error":"#REF!"}},"Litres"]

{"sheet":"Calcium Chloride Calculator","index":2,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,4,5,12]]}
[]
[]
[]
[]
[]
[{"$nulls":4},"INPUTS"]
[{"$nulls":4},"Input your annual calcium chloride desiccant usage"]
[{"$nulls":4},"Step 1: Input estimated number of calcium chloride bags used anually (millions of bags)"]
[{"$nulls":4},"Step 2: Input the average weight of the bags (select size from the dropdown list)"]
[]
[{"$nulls":5},"Input Number of Sachets",null,null,50,"Million"]
[{"$nulls":5},"Input Weight of Each Sachet ",null,null,2,"Grams","*Click cell to select from dropdown list"]

{"sheet":"CACi2 inputs","index":3,"n_rows":69,"n_cols":13,"rows_kept":69,"cut":false,"hidden":true,"merged":[[5,1,5,7],[6,2,6,6],[7,1,7,7],[19,1,19,7],[7,11,7,21]]}
[]
[]
[]
[]
[]
[null,"CALCIUM CHLORIDE DESICCANT MATERIAL WASTE CALCULATOR"]
[]
[null,"INPUTS",{"$nulls":9},"PACKAGING BREAKDOWN"]
[]
[null,null,"Annual Calcium Chloride Desiccant Usage ",{"$nulls":9},"Calcium Chloride Desiccants"]
[null,null,"Number of sachets",{"$f":"D16*1000000","v":50000000}]
[null,null,"Step 1: Input estimated number of desiccant bags used anually (millions of bags)"]
[null,null,"Step 2: Input the average weight of the bags (select size from the dropdown list)"]
[]
[]
[null,null,"Input Number of Sachets",{"$f":"'Calcium Chloride Calculator'!$I$11","v":50},"Million"]
[null,null,"Input Weight of Each Sachet ",{"$f":"'Calcium Chloride Calculator'!$I$12","v":2},"Grams","*Click cell to select size from dropdown list"]
[]
[]
[null,"RESULTS"]
[]
[null,null,"Calcium Chloride Desiccant Waste to Landfill"]
[]
[null,null,"Calcium Chloride Ingredient",{"$f":"(D11*D17)/1000000","v":100},"Metric Tonnes"]
[null,null,"Plastic Packaging (Quantity)",{"$f":"IF(D17=5,(D40*D11)/10000,IF(D17=10,D41*D11/10000,IF(D17=25,D42*D11/10000,IF(D17=50,D43*D11/10000,IF(D17=100,D44*D11/10000,IF(D17=2,D39*D11/10000,\"\"))))))","v":935000},"Square Meters"]
[null,null,"Equivalent to:",{"$f":"ROUNDUP(D25/7000,2)","v":133.57999999999998},"Soccer Pitches"]
[null,null,null,{"$f":"ROUNDUP(D25/5500,0)","v":170},"American Football Fields (incl. end zones)"]
[null,null,"Plastic Packaging (Weight KGS)",{"$f":"IF(D17=5,(E40*D11)/1000,IF(D17=10,E41*D11/1000,IF(D17=25,E42*D11/1000,IF(D17=50,E43*D11/1000,IF(D17=100,E44*D11/1000,IF(D17=2,E39*D11/1000,\"\"))))))","v":55000.000000000007},"Kilograms"]
[null,null,"Plastic Packaging (Weight MT",{"$f":"ROUNDUP(D28/1000,0)","v":55},"MT"]
[null,null,"Equivalent to:",{"$f":"(D28*1000)/20","v":2750000.0000000005},"1 Litre Plastic Bottles (20g per litre)"]
[]
[null,null,"Micro-Pak Dri Clay® Equivalent Waste to Landfill",{"$nulls":9},"Dri Clay® Kraft - Plastic free, biodegradable and FSC-Certified Kraft paper"]
[]
[null,null,"Natural Clay",{"$f":"D24","v":100},"Metric Tonnes"]
[null,null,"Plastic Waste (Quantity & Weight)","ZERO","Square Meters / Kilograms"]
[]
[]
[null,null,"Weight (grams)","Size (cm²)","Weight (g)"]
[null,null,2,{"$f":"(8.5*5.5)*4","v":187},1.1000000000000001]
[null,null,5,{"$f":"(11.5*5.5)*4","v":253},1.4]
[null,null,10,{"$f":"(10.3*10.2)*4","v":420.24},1.7]
[null,null,25,{"$f":"(12.5*10.2)*4","v":509.99999999999994},2.4]
[null,null,50,{"$f":"(17*10.2)*4","v":693.59999999999991},3]
[null,null,100,{"$f":"(17.5*16)*4","v":1120},4.3]
[]
[]
[null,null,"Calicum chloride output",15000,"MT",null,"Conversion"]
[null,null,"Inputs:"]
[null,null,"CaCO3 (calcium carbonate)",13750,"MT",null,{"$f":"(D49/$D$47)*$D$24","v":91.666666666666657},"MT"]
[null,null,"CaO (calcium oxide)",1095,"MT",null,{"$f":"(D50/$D$47)*$D$24","v":7.3},"MT"]
[null,null,"HCI (hydrochloric acid)",29200,"MT",null,{"$f":"(D51/$D$47)*$D$24","v":194.66666666666669},"MT"]
[null,null,"Water",2700,"MT",null,18,"MT",{"$f":"G52*1000","v":18000},"Litres"]
[null,null,"Coal",6000,"MT",null,40,"MT"]
[null,null,"Waste Output"]
[null,null,"Waste Water",2010,"MT",null,{"$f":"(D55/$D$47)*$D$24","v":13.4},"MT"]
[null,null,"Furnace slag & dust",1357,"MT",null,{"$f":"(D56/$D$47)*$D$24","v":9.0466666666666669},"MT"]
[null,null,"Exhaust Gas (Sulphur dioxide / Nitrogen oxide)",292,"MT",null,{"$f":"(D57/$D$47)*$D$24","v":1.9466666666666668},"MT"]
[null,null,"CO2 (carbon dioxide)",10059,"MT",null,{"$f":"(D58/$D$47)*$D$24","v":67.06},"MT"]
[null,null,"Water Vapor",18075,"MT",null,{"$f":"(D59/$D$47)*$D$24","v":120.5},"MT",{"$f":"G59*1000","v":120500},"Litres"]
[]
[]
[]
[null,null,"Item","Input","Annual consumption",null,"Output","Annual production"]
[null,null,1,"CaCO3 (95%)","13,750 MT",null,"Calcium Chloride (CaCl2)","15,000 MT"]
[null,null,2,"CaO (88.64%)","1,095 MT",null,"Waste water sludge","2,010 MT"]
[null,null,3,"HCl (31%)","29,238 MT",null,"Furnace slag & dust","1,357 MT"]
[null,null,4,"Water","2,700 MT",null,"Exhaust gas (SO2, NOx)","292 MT"]
[null,null,5,"Electricity","1,650k kwh",null,"CO2","10,059 MT"]
[null,null,6,"Coal","6,000 MT",null,"Water Vapor","18,065 MT"]