{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculator","Calculations"],"not_rendered":{"charts":1,"images":6,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Environmental Calculator"]
[]
[null,"Diameter in Millimeters",300]
[null,"Length in Meters",6]
[null,null,"CSP","RCP","% Difference"]
[null,"Global Warming CO2 (Tonnes)",{"$f":"IF($C$4=0,0,VLOOKUP($C$4,Env,3)*$C$5)","v":0.16214039999999996},{"$f":"IF($C$4=0,0,VLOOKUP($C$4,Env,13)*$C$5)","v":0.27987295081967212},{"$f":"IF(D7=0,0,(C7/D7)-1)","v":-0.42066427096604153}]
[null,"  Equivalent - KM's Driven",{"$f":"IF($C$4=0,0,VLOOKUP($C$4,Env,6)*$C$5)","v":647.9130384},{"$f":"IF($C$4=0,0,VLOOKUP($C$4,Env,16)*$C$5)","v":1118.3723114754098}]
[null,"Fresh Water (Liters)",{"$f":"IF($C$4=0,0,VLOOKUP($C$4,Env,4)*$C$5)","v":1051.7903999999999},{"$f":"IF($C$4=0,0,VLOOKUP($C$4,Env,14)*$C$5)","v":2261.7786885245901},{"$f":"IF(D9=0,0,(C9/D9)-1)","v":-0.53497200882810203}]
[null,"  Equivalent - No. of Plastic Bottles to Landfill*",{"$f":"IF($C$4=0,0,VLOOKUP($C$4,Env,7)*$C$5)","v":1513.3674820143885},{"$f":"IF($C$4=0,0,VLOOKUP($C$4,Env,17)*$C$5)","v":3254.3578252152374}]
[null,"Total Primary Energy (Megajoules)",{"$f":"IF($C$4=0,0,VLOOKUP($C$4,Env,5)*$C$5)","v":2233.7758799997114},{"$f":"IF($C$4=0,0,VLOOKUP($C$4,Env,15)*$C$5)","v":3691.5368852459014},-0.39489271015345284]
[null,"  Equivalent - Smart Phones Charged",{"$f":"IF($C$4=0,0,VLOOKUP($C$4,Env,8)*$C$5)","v":20949.350381999993},{"$f":"IF($C$4=0,0,VLOOKUP($C$4,Env,18)*$C$5)","v":36160.984610655738}]
[]
[null,"References: CSPI Environmental Product Declaration - SCS-EPD-05002, CCPPA EPD - ASTM Certified, AGECO LCA of CSP vs RCP (Nov 2020), * 500ml"]

{"sheet":"Calculations","index":1,"n_rows":43,"n_cols":42,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,10,0,15],[0,0,0,5]]}
["CSP",null,null,null,null,null,null,null,null,null,"Concrete",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Category","Units","Production","Transport","Manufacturing","End of Life","Total MT","Total KGs"]
[null,null,null,"GWP","Fresh Water","P.E.","KM / MT","LT to BT","No to MT",null,null,null,null,"GWP","Fresh Water","P.E.","KM / MT","LT to BT","No to MT"]
[null,null,"KG/Meter",{"$f":"V6","v":1.5012999999999999},{"$f":"V7","v":9738.7999999999993},{"$f":"V8","v":20683.10999999733},3996,1.39,129205,null,null,null,"KG/Meter",{"$f":"W6","v":0.221},{"$f":"W7","v":1786},{"$f":"W8","v":2915},3996,1.39,129205,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GWP","CO2 Metric Ton",2.21,2.0199999999999999E-2,3.1099999999999999E-2,-0.76,{"$f":"SUM(AK3:AN3)","v":1.5012999999999999},{"$f":"AO3*1000","v":1501.3}]
["Profile","Diameter",2,"MT/Meter","LT/Meter","MJ/Meter","KM/Meter","500ML/M","Per/meter",null,"Length","KG per Pc","B or C","MT/Meter","LT/Meter","MJ/Meter","KM/Meter","500ML/M","Per/meter",null,null,"CSP","RCP"]
[null,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,null,null,null,"Fresh Water","Cubic Meters",14.9,0,4.8800000000000003E-2,-5.21]
["68 x 13",300,18,{"$f":"$C6/1000*$D$3","v":2.7023399999999996E-2},{"$f":"$C6/1000*$E$3","v":175.29839999999999},{"$f":"$C6/1000*$F$3","v":372.2959799999519},{"$f":"$C6/1000*$G$3*D$3","v":107.98550639999999},{"$f":"E6/H$3*2","v":252.22791366906475},{"$f":"$C6/1000*$I$3*D$3","v":3491.5583969999989},null,2.44,515,{"$f":"L6/K6","v":211.0655737704918},{"$f":"$M6/1000*$N$3","v":4.6645491803278684E-2},{"$f":"$M6/1000*$O$3","v":376.96311475409834},{"$f":"$M6/1000*$P$3","v":615.25614754098353},{"$f":"$M6/1000*$Q$3*N$3","v":186.39538524590162},{"$f":"O6/R$3*2","v":542.39297086920624},{"$f":"$M6/1000*$S$3*N$3","v":6026.8307684426227},null,"Global Warming Potential (MT/MT)",{"$f":"AO3","v":1.5012999999999999},{"$f":"AP25","v":0.221}]
[null,400,24,{"$f":"$C7/1000*$D$3","v":3.6031199999999999E-2},{"$f":"$C7/1000*$E$3","v":233.7312},{"$f":"$C7/1000*$F$3","v":496.39463999993592},{"$f":"$C7/1000*$G$3*D$3","v":143.98067519999998},{"$f":"E7/H$3*2","v":336.30388489208633},{"$f":"$C7/1000*$I$3*D$3","v":4655.411196},null,2.44,{"$f":"515+150","v":665},272.5409836065574,{"$f":"$M7/1000*$N$3","v":6.0231557377049195E-2},{"$f":"$M7/1000*$O$3","v":486.75819672131155},{"$f":"$M7/1000*$P$3","v":794.45696721311492},{"$f":"$M7/1000*$Q$3*N$3","v":240.68530327868859},{"$f":"O7/R$3*2","v":700.37150607382966},{"$f":"$M7/1000*$S$3*N$3","v":7782.2183709016417},null,"Fresh Water (L/MT)",{"$f":"AO7","v":9738.7999999999993},{"$f":"AO29","v":1786},null,null,null,null,null,null,null,null,null,null,null,null,"Liters",{"$f":"AK5*1000","v":14900},{"$f":"AL5*1000","v":0},48.800000000000004,-5210,{"$f":"SUM(AK7:AN7)","v":9738.7999999999993}]
["Spiral Rib",450,26.8,4.0234840000000001E-2,260.99984000000001,554.30734799992842,160.77842063999998,375.53933812949646,5198.542502199999,null,2.44,740,303.27868852459017,6.702459016393443E-2,541.65573770491801,884.05737704918033,267.83026229508198,779.36077367614109,8659.9121721311476,null,"Total Primary Energy (MJ/MT)",{"$f":"AO15","v":20683.10999999733},{"$f":"AO31","v":2915}]
[null,525,31.3,4.6990689999999995E-2,304.82443999999998,647.38134299991646,187.77479724,438.59631654676258,6071.4321014499992,null,2.44,1100,450.81967213114757,9.9631147540983622E-2,805.16393442622962,1314.1393442622953,398.12606557377057,1158.509258167237,12872.842418032789,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Primary","Renewable",1080,7.11,332,-2.67]
[null,600,35.799999999999997,5.3746539999999995E-2,348.64903999999996,740.45533799990437,214.77117383999996,501.65329496402876,6944.3217006999994,null,2.44,1335,547.13114754098365,0.12091598360655739,977.17622950819691,1594.8872950819675,483.1802704918033,1406.0089633211467,15622.94966188525,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy",null,null,null,null,{"$f":"10*10*10*10*10*10*10*10*10","v":1000000000}]
[null,750,44.7,6.7108109999999999E-2,435.32436000000001,924.53501699988078,268.16400756000002,626.36598561151084,8670.703352550001,null,2.44,1900,778.68852459016398,0.17209016393442625,1390.7377049180329,2269.877049180328,687.67229508196726,2001.0614459252274,22234.909631147544,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Megajoules",{"$f":"AK9","v":1080},{"$f":"AL9","v":7.11},{"$f":"AM9","v":332},{"$f":"AN9/AN10","v":-2.6700000000000001E-9},{"$f":"SUM(AK11:AN11)","v":1419.1099999973299}]
[null,800,{"$f":"44.7+2.97","v":47.67},7.1566970999999993E-2,464.24859600000002,985.96385369987286,285.981616116,667.98359136690658,9246.810488055,null,2.44,{"$f":"1900+193","v":2093},857.78688524590166,0.18957090163934426,1532.0073770491804,2500.4487704918033,757.52532295081971,2204.3271612218423,24493.508346311475]
[null,900,53.6,8.0469680000000002E-2,521.99968000000001,1108.6146959998568,321.55684127999996,751.07867625899291,10397.085004399998,null,2.44,2480,1016.3934426229508,0.22462295081967212,1815.2786885245903,2962.7868852459019,897.59331147540979,2611.9117820497704,29022.408360655736,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-renew",27300,286,828,-9150,{"$f":"SUM(AK13:AN13)","v":19264}]
[null,1000,59.6,8.9477479999999998E-2,580.43247999999994,1232.7133559998408,357.55201007999995,835.15464748201441,11560.9378034,null,2.44,{"$f":"2480+331","v":2811},1152.049180327869,0.25460286885245903,2057.559836065574,3358.2233606557379,1017.3930639344263,2960.517749734639,32895.963670081968]
[null,1050,62.6,9.3981379999999989E-2,609.64887999999996,1294.7626859998329,375.54959448,877.19263309352516,12142.864202899998,null,2.44,2977,1220.0819672131147,0.26963811475409832,2179.0663934426229,3556.5389344262294,1077.4739065573769,3135.3473286944218,34838.592616803282,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"AK13+AK11","v":28380},{"$f":"AL13+AL11","v":293.11},{"$f":"AM13+AM11","v":1160},{"$f":"AN13+AN11","v":-9150.0000000026703},{"$f":"SUM(AK15:AN15)","v":20683.10999999733}]
[null,1200,71.5,0.10734294999999998,696.32419999999991,1478.842364999809,428.94242819999994,1001.9053237410071,13869.245854749997,null,2.44,3100,1270.4918032786886,0.2807786885245902,2269.0983606557379,3703.4836065573777,1121.9916393442625,3264.889727562213,36278.010450819675]
[null,1350,80.5,0.12085464999999999,783.97339999999997,1664.990354999785,482.93518139999998,1128.0192805755396,15615.025053249999,null,2.44,4410,1807.377049180328,0.39943032786885252,3227.9754098360659,5268.5040983606559,1596.1235901639345,4644.5689350159228,51608.395512295087]
[null,1400,{"$f":"80.5+2.97","v":83.47},0.12531351099999999,812.89763599999992,1726.4191916997772,500.75278995600002,1169.6368863309351,16191.132188754998,null,2.44,{"$f":"4410+102","v":4512},1849.1803278688526,0.40866885245901641,3302.6360655737708,5390.3606557377052,1633.0407344262296,4751.9943389550663,52802.059081967214]
[null,1500,89.4,0.13421622,870.64872000000003,1849.0700339997616,536.32801512000003,1252.7319712230217,17341.406705100002,null,2.44,4716,1932.7868852459017,0.42714590163934424,3451.9573770491802,5634.0737704918029,1706.8750229508196,4966.8451468333533,55189.38622131147]
[null,1600,95.3,0.14307388999999998,928.10763999999995,1971.1003829997455,571.72326443999998,1335.4066762589928,18485.861957449997,null,2.44,{"$f":"4716+1070","v":5786},2371.311475409836,0.52405983606557371,4235.1622950819665,6912.372950819672,2094.1431049180328,6093.7586979596645,67711.15111885246]
[null,1650,98.3,0.14757778999999999,957.32403999999997,2033.1497129997376,589.72084883999992,1377.4446618705038,19067.788356950001,null,2.44,6321,2590.5737704918033,0.57251680327868848,4626.7647540983608,7551.5225409836066,2287.7771459016394,6657.2154735228214,73972.033567622959]
[null,1800,107.3,0.16108948999999997,1044.9732399999998,2219.2977029997132,643.71360203999984,1503.5586187050358,20813.567555449994,null,2.44,6564,2690.1639344262294,0.59452622950819667,4804.6327868852459,7841.8278688524588,2375.7268131147539,6913.1407005543115,76815.761483606562]
[null,2000,119.2,0.17895496,1160.8649599999999,2465.4267119996816,715.10402015999989,1670.3092949640288,23121.8756068,null,2.44,{"$f":"6564+1464","v":8028},3290.1639344262294,0.72712622950819672,5876.2327868852462,9590.8278688524588,2905.5964131147539,8455.0112041514349,93948.344483606561]
[null,2100,125.2,0.18796275999999998,1219.2977599999999,2589.5253719996658,751.09918895999999,1754.3852661870503,24285.728405799997,null,2.44,8760,3590.1639344262294,0.79342622950819663,6412.0327868852455,10465.327868852459,3170.5312131147539,9225.9464559499938,102514.63598360655,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Category","Units","Production","Transport","Manufacturing","End of Life","Total KGs","Total MT"]
[2.8,2200,178.3,0.26768178999999998,1736.42804,3687.7985129995241,1069.65643284,2498.4576115107916,34585.82567695,null,2.44,{"$f":"8760+834","v":9594},3931.967213114754,0.8689647540983606,7022.4934426229511,11461.684426229509,3472.3831573770494,10104.3071116877,112274.59105327869,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GWP","CO2 KGs",174,9,38,null,{"$f":"SUM(AK25:AN25)","v":221},{"$f":"AO25/1000","v":0.221}]
[null,2400,194.5,0.29200284999999998,1894.1966,4022.8648949994808,1166.8433885999998,2725.4627338129499,37728.228234249997,null,2.44,11261,4615.1639344262294,1.0199512295081967,8242.682786885247,13453.202868852459,4075.7251131147541,11859.975232928413,131782.79860860656]
[null,2600,210.7,0.31632390999999999,2051.9651599999997,4357.9312769994376,1264.0303443599998,2952.4678561151077,40870.63079155,null,2.44,{"$f":"11261+2626","v":13887},5691.3934426229507,1.2577979508196722,10164.828688524589,16590.4118852459,5026.1606114754095,14625.652789244014,162513.78423565574,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fresh Water","Liters",1276,null,510]
["125 x 25",2700,250,0.37532499999999996,2434.6999999999998,5170.7774999993326,1499.7986999999998,3503.1654676258991,48493.866624999995,null,2.44,15200,6229.5081967213118,1.37672131147541,11125.901639344263,18159.016393442624,5501.3783606557381,16008.491567401819,177879.27704918035]
[null,3000,278,0.41736139999999999,2707.3863999999999,5749.9045799992582,1667.7761544,3895.52,53925.179687000003,null,2.44,17671,7242.2131147540986,1.6005290983606557,12934.592622950819,21111.051229508197,6395.714277049181,18610.924637339307,206796.36215368853,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK27","v":1276},{"$f":"AL27","v":0},510,null,{"$f":"SUM(AK29:AN29)","v":1786}]
[null,3300,305,0.45789649999999993,2970.3339999999998,6308.3485499991857,1829.7544139999998,4273.8618705035969,59162.517282499997]
[3.5,3600,410,0.61553299999999989,3992.9079999999994,8480.075099998905,2459.6698679999995,5745.1913669064743,79529.941264999987,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 Primary","Megajoules",2098,141,676,null,{"$f":"SUM(AK31:AN31)","v":2915}]
[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,null,null,null,null,null,"Energy"]
[null,1,{"$f":"B33+1","v":2},{"$f":"C33+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[]
[null,"carbon footprint per gallon of water"]
[null,"Divide by one million, and we get 0.000004082 metric tons per gallon. An easier calculation is to take the number of gallons and divide by 244,956. "]
[null,"If you use 2,000 gallons per month, your carbon emissions for water would be 2,000/244956 = 0.008 metric tons.Dec. 5, 2012"]
[null,"Gallons",null,"MT","Per Gallon"]
[null,2000,244956,{"$f":"B3:B39/C39","v":8.1647316252714767E-3},{"$f":"D39/B39","v":4.0823658126357382E-6}]
[]
[null,"Liters",4.5460900000000004,null,{"$f":"E39/C41","v":8.9799493908737789E-7}]
[]
[null,"95 liters to produce 1 KWH of Electricity"]