{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Notes","IP","Metric"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":2,"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":"Notes","index":0,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Total Climatic Impact of Insulation"]
[]
["Introduction"]
[null,"Developed by David White (www.rightenvironments.com) with support from BuildingGreen (www.buildinggreen.com)"]
[null,"More information on the tool can be found here: http://www.buildinggreen.com/live/index.cfm/2011/3/21/Global-Warming-Potential-Insulation-Calculator-polystyrene-eps-xps-gwp"]
[null,"This tool calculates total global warming potential (GWP) of various insulation materials.  Total impact is defined as the embodied GWP of the insulation plus GWP of heating energy demand."]
[null,"It does not consider other important environmental impacts, such as resource depletion, habitat loss, toxicity, eutrophication, acidification, etc; nor does it consider other financial costs."]
[]
["Use"]
[null,"The tool uses macros. You may need to change your macro security level (under Tools: Options: Security) to Medium to allow the macros to work.  Macros do not work with Excel 2008 for Mac. "]
[null,"Enter all required info about the building into the yellow cells.  Move the cursor over the red triangles for help notes."]
[null,"Examine alternative thicknesses and materials that may perform better from a GWP standpoint, within overall project objectives."]
[null,"The calculation sheets are locked to prevent damage to the formulas, but you can unlock them if you want to examine the formulas or edit them.  The password is \"unlock\""]
[]
["Method"]
[null,"Heating energy demand is calculated for envelope transmission only.  Infiltration is neglected because building air tightness may happen independently of the insulation."]
[null,"\"Whole Assembly R Value\" in the graph is Reference R Value plus R value of the insulation graphed."]
[null,"Note that proper air tightness is very important from the standpoints of durability, health, and energy.  The neglect of air tightness by this calculator is not meant to encourage its neglect in construction."]
[null,"Thermal bridging effects are neglected.  Accuracy is acceptable for comparison of options whose insulated layers contain identical, moderate amounts of material no more conductive than wood."]
[null,"The GWP of materials making up the \"Reference\" assembly is neglected while their insulating effect considered, because its construction is considered to be based on other design issues."]
[null,"The reference assembly may be insulated, but for accurate comparison it should only be with a low-GWP insulation."]
[null,"Each curve's lowest point is the point of minimum impact for that material.  Any amount of insulation added past that point increases rather than reduces total impact."]
[null,"The low point is also the point at which embodied GWP and operational GWP are each half of total."]
[null,"Note that the low point for a given material always occurs at the same total R-value, for a given climate and heating system, regardless of reference R value."]
[null,"Embodied energy for extra non-insulating materials required to build highly insulated walls is neglected, but may be important."]
[]
["Format"]
[null,"Charts are automatically generated but can be scaled and otherwise formatted to your preference, just like an ordinary excel chart."]
[null,"The worksheets are locked to protect the formulas, and some of the formulas are hidden, but you can unprotect the sheet and unhide the formulas for your own purposes."]
[]
["Sources and Acknowledgements"]
[null,"All information regarding embodied energy and blowing agents from Harvey, \"Net climatic impact of solid foam insulation...\" except where otherwise noted."]
[null,"We gratefully acknowledge Dr. Harvey's generous support of this tool."]
[null,"Thanks to Mary Bogdan and David Williams of Honeywell for generous support on data for various aspects of HFC-245fa."]
[null,"Thanks to Terry Brennan, John Straube, and Daniel Bergey for technical guidance."]
[null,"Special thanks to Paul Eldrenkamp for project genesis & seed funding, Alex Wilson for collaboration & publicity, Cramer Silkworth for Excel mastery, & New Hampshire friends for beta testing."]
[null,"copyright 2011 by David White.  This file may be freely distributed, but never used for profit."]

{"sheet":"IP","index":1,"n_rows":134,"n_cols":63,"rows_kept":134,"cut":false,"hidden":false,"merged":[]}
["Total Climatic Impact of Insulation"]
[]
[]
[null,"Inputs"]
[null,"Climate HDD (°Fd)",6000]
[null,"Reference R Value",2]
[null,"Heating Fuel","Natural Gas"]
[null,"Heating Efficiency/COP",0.9]
[null,"Life Span of Insulation (Years)",50]
[null,"BA Release Rate","High"]
[null,"Chart Type","R Value"]
[null,"R Value Chart x-axis maxiumum",60]
[null,"Thickness Chart x-axis maximum",10]
[null,"Chart y-axis maximum",1.5]
[]
[null,"Displayed in Graph (mark with \"x\")"]
[null,{"$f":"B45","v":"Cellulose"},"x"]
[null,"Rigid Mineral Wool"]
[null,"Mineral Wool Batt"]
[null,"Fiberglass Batt"]
[null,"Loose Fill Fiberglass"]
[null,{"$f":"B50","v":"Dense Pack Blown Fiberglass"}]
[null,"Fiberboard"]
[null,"EPS type I (1 lb/cf)"]
[null,"EPS type VII (1.25 lb/cf)"]
[null,"EPS type II (1.5 lb/cf)"]
[null,"EPS type IX (2 lb/cf)"]
[null,"Solid PU, n-pentane"]
[null,"XPS, CO2"]
[null,"XPS, HFC-134a"]
[null,"Spray PU, Water/CO2"]
[null,"Spray PU, HFC-245fa"]
[]
[]
[]
[]
[]
[null,{"$f":"#REF!&\"     \"&#REF!&\"          \"&B7&\"                \"&B8&\"   \"&B9&\"  \"&B10","v":{"$error":"#REF!"}}]
[null,{"$f":"TEXT(#REF!,\"0.00\")&\"          \"&TEXT(#REF!,\"0,000\")&\"          \"&C7&\" \"&TEXT(C8,\"0.00\")&\"            \"&TEXT(C9,\"00\")&\"               \"&C10","v":{"$error":"#REF!"}}]
[]
[]
[]
["Material Data",null,{"$f":"Metric!C44","v":"Conductivity"},{"$f":"Metric!D44","v":"Mnfr CO2"},{"$f":"Metric!E44","v":"Mnfr CO2"},{"$f":"Metric!F44","v":"BA CO2"},{"$f":"Metric!G44","v":"BA CO2"},{"$f":"Metric!H44","v":"BA GWP"},{"$f":"Metric!I44","v":"BA Mass"},{"$f":"Metric!J44","v":"Overall"},{"$f":"Metric!K44","v":"Total CO2"},{"$f":"Metric!L44","v":"Total CO2"},"R-value"]
[null,null,{"$f":"Metric!C45","v":"(W/mK)"},{"$f":"Metric!D45","v":"(kg/m2RSI)"},{"$f":"Metric!E45","v":"(kg/m3)"},{"$f":"Metric!F45","v":"(kg/m2RSI)"},{"$f":"Metric!G45","v":"(kg/m3)"},{"$f":"Metric!H45","v":"-"},{"$f":"Metric!I45","v":"(kg/m2RSI)"},{"$f":"Metric!J45","v":"Emissions"},{"$f":"Metric!K45","v":"(kg/m2RSI)"},{"$f":"Metric!L45","v":"(kg/m3)"},"per inch"]
[null,{"$f":"Metric!B46","v":"Cellulose"},{"$f":"Metric!C46","v":3.9E-2},{"$f":"E45*C45","v":0.12171802500000001},{"$f":"Metric!E46","v":3.1209750000000001},0,{"$f":"F45/C45","v":0},{"$f":"Metric!H46","v":0},{"$f":"Metric!I46","v":0},0,{"$f":"D45+F45","v":0.12171802500000001},{"$f":"E45+G45","v":3.1209750000000001},{"$f":"0.1442/C45","v":3.6974358974358972}]
[null,{"$f":"Metric!B47","v":"Rigid Mineral Wool"},{"$f":"Metric!C47","v":3.6999999999999998E-2},{"$f":"E46*C46","v":6.5142791999999989},{"$f":"Metric!E47","v":176.06159999999997},0,{"$f":"F46/C46","v":0},{"$f":"Metric!H47","v":0},{"$f":"Metric!I47","v":0},0,{"$f":"D46+F46","v":6.5142791999999989},{"$f":"E46+G46","v":176.06159999999997},{"$f":"0.1442/C46","v":3.8972972972972975}]
[null,{"$f":"Metric!B48","v":"Mineral Wool Batt"},{"$f":"Metric!C48","v":3.5000000000000003E-2},1.297296,{"$f":"Metric!E48","v":37.065599999999996},0,0,{"$f":"Metric!H48","v":0},{"$f":"Metric!I48","v":0},0,1.297296,37.065599999999996,4.1199999999999992]
[null,{"$f":"Metric!B49","v":"Fiberglass Batt"},{"$f":"Metric!C49","v":4.3999999999999997E-2},0.48399951599999996,{"$f":"Metric!E49","v":10.999988999999999},0,0,{"$f":"Metric!H49","v":0},{"$f":"Metric!I49","v":0},0,0.48399951599999996,10.999988999999999,3.2772727272727273]
[null,{"$f":"Metric!B50","v":"Loose Fill Fiberglass"},{"$f":"Metric!C50","v":6.3E-2},0.69299930700000001,{"$f":"Metric!E50","v":10.999988999999999},0,0,{"$f":"Metric!H50","v":0},{"$f":"Metric!I50","v":0},0,0.69299930700000001,10.999988999999999,2.2888888888888888]
[null,{"$f":"Metric!B51","v":"Dense Pack Blown Fiberglass"},{"$f":"Metric!C51","v":3.4000000000000002E-2},1.398855744,{"$f":"Metric!E51","v":41.142815999999996},0,0,{"$f":"Metric!H51","v":0},{"$f":"Metric!I51","v":0},0,1.398855744,41.142815999999996,4.2411764705882344]
[null,{"$f":"Metric!B52","v":"Fiberboard"},{"$f":"Metric!C52","v":5.5E-2},11.111475374999999,{"$f":"Metric!E52","v":202.02682499999997},0,0,{"$f":"Metric!H52","v":0},{"$f":"Metric!I52","v":0},0,11.111475374999999,202.02682499999997,2.6218181818181816]
[null,{"$f":"Metric!B53","v":"EPS type I (1 lb/cf)"},{"$f":"Metric!C53","v":0.04},5.2303679999999995,{"$f":"Metric!E53","v":130.75919999999999},{"$f":"H52*I52*J52","v":0.26880000000000004},6.7200000000000006,{"$f":"Metric!H53","v":7},{"$f":"Metric!I53","v":3.8400000000000004E-2},1,5.4991679999999992,137.47919999999999,3.605]
[null,{"$f":"Metric!B54","v":"EPS type VII (1.25 lb/cf)"},{"$f":"Metric!C54","v":3.7999999999999999E-2},6.2110620000000001,{"$f":"Metric!E54","v":163.44900000000001},{"$f":"H53*I53*J53","v":0.26880000000000004},7.0736842105263174,{"$f":"Metric!H54","v":7},{"$f":"Metric!I54","v":3.8400000000000004E-2},1,6.4798619999999998,170.52268421052634,3.7947368421052632]
[null,{"$f":"Metric!B55","v":"EPS type II (1.5 lb/cf)"},{"$f":"Metric!C55","v":3.5999999999999997E-2},7.060996799999999,{"$f":"Metric!E55","v":196.13879999999997},0.26880000000000004,7.4666666666666686,{"$f":"Metric!H55","v":7},{"$f":"Metric!I55","v":3.8400000000000004E-2},1,7.3297967999999987,203.60546666666664,4.0055555555555555]
[null,{"$f":"Metric!B56","v":"EPS type IX (2 lb/cf)"},{"$f":"Metric!C56","v":3.4000000000000002E-2},8.8916255999999994,{"$f":"Metric!E56","v":261.51839999999999},0.26880000000000004,7.9058823529411768,{"$f":"Metric!H56","v":7},{"$f":"Metric!I56","v":3.8400000000000004E-2},1,9.1604255999999999,269.42428235294119,4.2411764705882344]
[null,{"$f":"Metric!B57","v":"Solid PU, n-pentane"},{"$f":"Metric!C57","v":2.4E-2},6.7706495999999996,{"$f":"Metric!E57","v":282.11039999999997},7.6326417887153025E-2,3.1802674119647092,{"$f":"Metric!H57","v":7},{"$f":"Metric!I57","v":3.8400000000000004E-2},{"$f":"IF($C$10=\"Low\",D65,IF($C$10=\"High\",E65,F65))","v":0.283952447496849},6.8469760178871528,285.29066741196471,6.0083333333333329]
[null,{"$f":"Metric!B58","v":"XPS, CO2"},{"$f":"Metric!C58","v":3.3000000000000002E-2},6.0680441250000001,{"$f":"Metric!E58","v":183.88012499999999},5.361358789859319E-2,1.6246541787452482,{"$f":"Metric!H58","v":1},{"$f":"Metric!I58","v":5.9400000000000008E-2},{"$f":"IF($C$10=\"Low\",D68,IF($C$10=\"High\",E68,F68))","v":0.90258565485847109},6.1216577128985934,185.50477917874525,4.3696969696969692]
[null,{"$f":"Metric!B59","v":"XPS, HFC-134a"},{"$f":"Metric!C59","v":2.9000000000000001E-2},5.3325236250000003,{"$f":"Metric!E59","v":183.88012499999999},67.374408792565447,2323.2554756057048,{"$f":"Metric!H59","v":1430},{"$f":"Metric!I59","v":5.220000000000001E-2},{"$f":"IF($C$10=\"Low\",D69,IF($C$10=\"High\",E69,F69))","v":0.90258565485847109},72.70693241756544,2507.1356006057049,4.9724137931034482]
[null,{"$f":"Metric!B60","v":"Spray PU, Water/CO2"},{"$f":"Metric!C60","v":2.9000000000000001E-2},{"$f":"E59*C59","v":12.9594465},{"$f":"Metric!E60","v":446.87746551724138},1.6790786188272053E-2,0.57899262718179489,{"$f":"Metric!H60","v":1},{"$f":"Metric!I60","v":3.5000000000000003E-2},{"$f":"IF($C$10=\"Low\",D72,IF($C$10=\"High\",E72,F72))","v":0.47973674823634427},12.976237286188272,447.45645814442315,4.9724137931034482]
[null,{"$f":"Metric!B61","v":"Spray PU, HFC-245fa"},{"$f":"Metric!C61","v":2.4E-2},{"$f":"E60*C60","v":8.3927844},{"$f":"Metric!E61","v":349.69934999999998},17.294509773920211,720.60457391334216,{"$f":"Metric!H61","v":1030},{"$f":"Metric!I61","v":3.5000000000000003E-2},{"$f":"IF($C$10=\"Low\",D73,IF($C$10=\"High\",E73,F73))","v":0.47973674823634427},25.687294173920211,1070.3039239133423,{"$f":"0.1442/C60","v":6.0083333333333329}]
[]
["Overall Emissions",null,{"$f":"Metric!C63","v":"Mnfr"},{"$f":"Metric!D63","v":"Annual Rate/Full Emissions"},null,null,null,"GWP by Fuel Type"]
[null,null,null,{"$f":"Metric!D64","v":"Low"},{"$f":"Metric!E64","v":"High"},{"$f":"Metric!F64","v":"All"}]
[null,null,null,2E-3,5.0000000000000001E-3,1,null,null,null,{"$f":"Metric!J65","v":"kgCO2/kWh"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low"]
[null,"Solid PU, n-pentane",0.08,{"$f":"1-(1-$C65)*(1-D$64)^$C$9","v":0.16763292743628688},{"$f":"1-(1-$C65)*(1-E$64)^$C$9","v":0.283952447496849},{"$f":"1-(1-$C65)*(1-F$64)^$C$9","v":1},null,null,{"$f":"Metric!I66","v":"Wood"},{"$f":"Metric!J66","v":0.05},{"$f":"Metric!K66","v":"from PHPP"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High"]
[null,null,null,null,null,null,null,null,{"$f":"Metric!I67","v":"Natural Gas"},{"$f":"Metric!J67","v":0.23200000000000001},{"$f":"Metric!K67","v":"from EIA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All"]
[null,null,null,7.4999999999999997E-3,0.04,1,null,null,{"$f":"Metric!I68","v":"LPG"},{"$f":"Metric!J68","v":0.21299999999999999},{"$f":"Metric!K68","v":"from EIA"}]
[null,"XPS, CO2",0.25,{"$f":"1-(1-$C68)*(1-D$67)^$C$9","v":0.48526104663117897},0.90258565485847109,1,null,null,{"$f":"Metric!I69","v":"Fuel Oil"},{"$f":"Metric!J69","v":0.25},{"$f":"Metric!K69","v":"from EIA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R Value"]
[null,"XPS, HFC-134a",0.25,0.48526104663117897,0.90258565485847109,1,null,null,{"$f":"Metric!I70","v":"Electricity"},{"$f":"Metric!J70","v":0.60599999999999998},{"$f":"Metric!K70","v":"from EIA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thickness"]
[]
[null,null,null,1.0999999999999999E-2,1.0999999999999999E-2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pleasure and Pain"]
[null,"Spray PU, Water/CO2",{"$f":"AVERAGE(6.4,11.8,11.8,6.4,11.8,9.1)/100","v":9.5500000000000002E-2},{"$f":"1-(1-$C72)*(1-D$71)^$C$9","v":0.47973674823634427},0.47973674823634427,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sickness and Health"]
[null,"Spray PU, HFC-245fa",{"$f":"AVERAGE(6.4,11.8,11.8,6.4,11.8,9.1)/100","v":9.5500000000000002E-2},0.47973674823634427,0.47973674823634427,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Success and Failure"]
[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,"Fame and Disrepute"]
["Chart Data"]
[null,{"$f":"IF($C$11=\"Final Rsi\", B96,B116)","v":"Net Impact (kgCO2eq/sfyr)"}]
[null,{"$f":"IF($C$11=\"R Value\",B97,IF(C11=\"Thickness\",B117,\"error: please select chart type from dropdown menu\"))","v":"Whole Assembly R Value (hrsf°F/Btu)"},{"$f":"IF($C$11=\"R Value\",C97,IF($C$11=\"Thickness\",C117,0))","v":2},7,12,17,22,27,32,37,42,47,52,57,62,67,72,77,82,87,92,97,102,107,112,117,122,127,132,137,{"$f":"IF($C$11=\"R Value\",AE97,IF($C$11=\"Thickness\",AE117,0))","v":142},147,152,157,162,167,172,177,182,187,192,197,202,207,212,217,222,227,232,237,242,247,252,257,262,267,272,277,282,287,292,297,302]
[null,{"$f":"IF($C$11=\"Final Rsi\", B99,B119)","v":"Cellulose"},{"$f":"IF($C$11=\"R Value\",C99,C119)","v":5.4411235026848415},1.5548059416133579,0.9072523702352322,0.64072985646809022,0.49544449739535168,0.4040423181867927,0.34126557828107912,0.29550936985273285,0.26069493165983731,0.2333302093719293,0.21126624647795478,0.19310810629529954,0.17791083171638661,0.16501154238216897,0.15393149136666853,0.14431628159481052,0.13589795430251397,0.12847015044157861,0.12187137162645652,0.115973418107795,0.11067322734199701,0.10588700081230595,0.10154590402281459,9.7592869058112791E-2,9.3980183398759187E-2,9.0667648307901583E-2,8.7621155766392761E-2,8.4811577027953639E-2,{"$f":"IF($C$11=\"R Value\",AE99,AE119)","v":8.2213885986626156E-2},7.9806461448827484E-2,7.757052711486731E-2,7.5489698570366082E-2,7.3549614168151756E-2,7.1737632218797323E-2,7.0042580996762707E-2,6.8454551118376714E-2,6.6964722143228739E-2,6.5565216993518957E-2,6.4248979120384977E-2,6.3009668375864233E-2,6.184157234941607E-2,6.0739530554223695E-2,5.9698869341849134E-2,5.8715345814862652E-2,5.778509931884613E-2,5.6904609345145088E-2,5.6070658877230603E-2,5.5280302376761695E-2,5.4530837738318183E-2,5.3819781650441073E-2,5.3144847889882336E-2,5.250392814960006E-2,5.1895075062021144E-2,5.1316487129802732E-2,5.076649531864183E-2,5.0243551102127366E-2,4.9746215778416494E-2,4.9273150903634433E-2,4.8823109708144435E-2,4.8394929379861021E-2,4.7987524114121646E-2]
[null,"Rigid Mineral Wool",{"$f":"IF($C$11=\"R Value\",C100,C120)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE100,AE120)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Mineral Wool Batt",{"$f":"IF($C$11=\"R Value\",C101,C121)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE101,AE121)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Fiberglass Batt",{"$f":"IF($C$11=\"R Value\",C102,C122)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE102,AE122)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Loose Fill Fiberglass",{"$f":"IF($C$11=\"R Value\",C103,C123)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE103,AE123)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Dense Pack Blown Fiberglass",{"$f":"IF($C$11=\"R Value\",C104,C124)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE104,AE124)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Fiberboard",{"$f":"IF($C$11=\"R Value\",C105,C125)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE105,AE125)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type I (1 lb/cf)",{"$f":"IF($C$11=\"R Value\",C106,C126)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE106,AE126)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type VII (1.25 lb/cf)",{"$f":"IF($C$11=\"R Value\",C107,C127)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE107,AE127)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type II (1.5 lb/cf)",{"$f":"IF($C$11=\"R Value\",C108,C128)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE108,AE128)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type IX (2 lb/cf)",{"$f":"IF($C$11=\"R Value\",C109,C129)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE109,AE129)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Solid PU, n-pentane",{"$f":"IF($C$11=\"R Value\",C110,C130)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE110,AE130)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"XPS, CO2",{"$f":"IF($C$11=\"R Value\",C111,C131)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE111,AE131)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"XPS, HFC-134a",{"$f":"IF($C$11=\"R Value\",C112,C132)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE112,AE132)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Spray PU, Water/CO2",{"$f":"IF($C$11=\"R Value\",C113,C133)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE113,AE133)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Spray PU, HFC-245fa",{"$f":"IF($C$11=\"R Value\",C114,C134)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE114,AE134)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[]
[null,"Net Impact (kgCO2eq/sfyr)"]
[null,"Whole Assembly R Value (hrsf°F/Btu)",{"$f":"C6","v":2},{"$f":"C97+5","v":7},{"$f":"D97+5","v":12},17,22,27,32,37,42,47,52,57,62,67,72,77,82,87,92,97,102,107,112,117,122,127,132,137,{"$f":"AD97+5","v":142},147,152,157,162,167,172,177,182,187,192,197,202,207,212,217,222,227,232,237,242,247,252,257,262,267,272,277,282,287,292,297,302]
[null,"Whole Assembly Rsi (m2K/W)",{"$f":"C97/5.678","v":0.35223670306445931},1.2328284607256077,2.1134202183867559,2.9940119760479043,3.8746037337090526,4.755195491370201,5.635787249031349,6.5163790066924978,7.3969707643536458,8.2775625220147937,9.1581542796759425,10.038746037337091,10.919337794998238,11.799929552659387,12.680521310320536,13.561113067981683,14.441704825642832,15.322296583303981,16.202888340965128,17.083480098626278,17.964071856287426,18.844663613948573,19.725255371609723,20.60584712927087,21.486438886932017,22.367030644593168,23.247622402254315,24.128214159915462,{"$f":"AE97/5.678","v":25.008805917576613},25.88939767523776,26.769989432898907,27.650581190560057,28.531172948221204,29.411764705882355,30.292356463543502,31.172948221204649,32.0535399788658,32.934131736526943,33.814723494188094,34.695315251849244,35.575907009510388,36.456498767171539,37.337090524832689,38.21768228249384,39.098274040154983,39.978865797816134,40.859457555477285,41.740049313138428,42.620641070799579,43.501232828460729,44.381824586121873,45.262416343783023,46.143008101444174,47.023599859105317,47.904191616766468,48.784783374427619,49.665375132088762,50.545966889749913,51.426558647411063,52.307150405072207,53.187742162733358]
[null,{"$f":"B45","v":"Cellulose"},{"$f":"IF(LOWER($C17)=\"x\", (1/C$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K45*(C$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":5.4411235026848415},1.5548059416133579,0.9072523702352322,0.64072985646809022,0.49544449739535168,0.4040423181867927,0.34126557828107912,0.29550936985273285,0.26069493165983731,0.2333302093719293,0.21126624647795478,0.19310810629529954,0.17791083171638661,0.16501154238216897,0.15393149136666853,0.14431628159481052,0.13589795430251397,0.12847015044157861,0.12187137162645652,0.115973418107795,0.11067322734199701,0.10588700081230595,0.10154590402281459,9.7592869058112791E-2,9.3980183398759187E-2,9.0667648307901583E-2,8.7621155766392761E-2,8.4811577027953639E-2,8.2213885986626156E-2,7.9806461448827484E-2,7.757052711486731E-2,7.5489698570366082E-2,{"$f":"IF(LOWER($C17)=\"x\", (1/AI$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K45*(AI$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":7.3549614168151756E-2},7.1737632218797323E-2,7.0042580996762707E-2,6.8454551118376714E-2,6.6964722143228739E-2,6.5565216993518957E-2,6.4248979120384977E-2,6.3009668375864233E-2,6.184157234941607E-2,6.0739530554223695E-2,5.9698869341849134E-2,5.8715345814862652E-2,5.778509931884613E-2,5.6904609345145088E-2,5.6070658877230603E-2,5.5280302376761695E-2,5.4530837738318183E-2,5.3819781650441073E-2,5.3144847889882336E-2,5.250392814960006E-2,5.1895075062021144E-2,5.1316487129802732E-2,5.076649531864183E-2,5.0243551102127366E-2,4.9746215778416494E-2,4.9273150903634433E-2,4.8823109708144435E-2,4.8394929379861021E-2,4.7987524114121646E-2]
[null,"Rigid Mineral Wool",{"$f":"IF(LOWER($C18)=\"x\", (1/C$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K46*(C$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},{"$f":"IF(LOWER($C18)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K46*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C18)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K46*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Mineral Wool Batt","",{"$f":"IF(LOWER($C19)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K47*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C19)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K47*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Fiberglass Batt","",{"$f":"IF(LOWER($C20)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K48*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C20)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K48*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Loose Fill Fiberglass","",{"$f":"IF(LOWER($C21)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K49*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C21)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K49*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Dense Pack Blown Fiberglass","",{"$f":"IF(LOWER($C22)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K50*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C22)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K50*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Fiberboard","",{"$f":"IF(LOWER($C23)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K51*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C23)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K51*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type I (1 lb/cf)","",{"$f":"IF(LOWER($C24)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K52*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C24)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K52*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type VII (1.25 lb/cf)","",{"$f":"IF(LOWER($C25)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K53*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C25)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K53*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type II (1.5 lb/cf)","",{"$f":"IF(LOWER($C26)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K54*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C26)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K54*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type IX (2 lb/cf)","",{"$f":"IF(LOWER($C27)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K55*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C27)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K55*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Solid PU, n-pentane","",{"$f":"IF(LOWER($C28)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K56*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C28)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K56*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"XPS, CO2","",{"$f":"IF(LOWER($C29)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K57*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C29)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K57*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"XPS, HFC-134a","",{"$f":"IF(LOWER($C30)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K58*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C30)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K58*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Spray PU, Water/CO2","",{"$f":"IF(LOWER($C31)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K59*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C31)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K59*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Spray PU, HFC-245fa","",{"$f":"IF(LOWER($C32)=\"x\", (1/D$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K60*(D$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C32)=\"x\", (1/S$98*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$K60*(S$98-$C$6/5.678)/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Net Impact (kgCO2eq/sfyr)"]
[null,"Added Thickness (inches)",0,{"$f":"C117+1","v":1},{"$f":"D117+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,{"$f":"AD117+1","v":28},29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60]
[null,"Added Thickness (cm)",{"$f":"C117*2.54","v":0},{"$f":"D117*2.54","v":2.54},5.08,7.62,10.16,12.7,15.24,17.78,20.32,22.86,{"$f":"M117*2.54","v":25.4},{"$f":"N117*2.54","v":27.94},{"$f":"O117*2.54","v":30.48},{"$f":"P117*2.54","v":33.020000000000003},{"$f":"Q117*2.54","v":35.56},38.1,40.64,43.18,45.72,48.26,50.8,53.34,55.88,58.42,60.96,63.5,66.040000000000006,68.58,{"$f":"AE117*2.54","v":71.12},73.66,76.2,78.739999999999995,81.28,83.820000000000007,86.36,88.9,91.44,93.98,96.52,99.06,101.6,104.14,106.68,109.22,111.76,114.3,116.84,119.38,121.92,124.46000000000001,127,129.54,132.08000000000001,134.62,137.16,139.69999999999999,142.24,144.78,147.32,149.86000000000001,152.4]
[null,{"$f":"B45","v":"Cellulose"},{"$f":"IF(LOWER($C17)=\"x\", (1/(1/$C45*C$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L45*C$118/100/$C$9)/10.76,\"\")","v":5.4411235026848415},1.9099904818676388,1.1584784448897292,0.83153247594460056,0.64865395385046876,0.53183978490341943,0.45078909273278456,0.3912739545991254,0.34572992798199675,0.3097639665000248,0.28065008184209778,0.25660710055759756,0.23642196872710242,0.21923997188081837,0.20444151668688071,0.19156648471851814,0.18026602603140743,0.17027084217960475,0.16136973316486267,0.15339473153016489,0.14621057880034499,0.13970713316254299,0.13379379809732714,0.12839537101942877,0.12344890688617143,0.11890131860047833,0.11470751988292772,0.11082897273456602,0.10723254025949233,0.10388957248912672,0.1007751718038675,9.7867598093279107E-2,{"$f":"IF(LOWER($C17)=\"x\", (1/(1/$C45*AI$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L45*AI$118/100/$C$9)/10.76,\"\")","v":9.5147783595050467E-2},9.2598934522674647E-2,9.0206201893362092E-2,8.7956407926749483E-2,8.5837817368901254E-2,8.3839945364671362E-2,8.195339524030941E-2,8.0169720901236266E-2,7.8481309594800278E-2,7.6881281606334159E-2,7.5363404102175707E-2,7.3922016845264074E-2,7.2551967917428115E-2,7.1248557910256055E-2,7.000749131082469E-2,6.8824834022903889E-2,6.769697613884898E-2,6.6620599220271345E-2,6.5592647463013118E-2,6.4610302218880672E-2,6.367095942691689E-2,6.2772209573815144E-2,6.1911819858874582E-2,6.1087718285650482E-2,6.0297979441767013E-2,5.954081176152233E-2,5.8814546093982026E-2,5.8117625423079036E-2,5.7448595606520374E-2]
[null,"Rigid Mineral Wool",{"$f":"IF(LOWER($C18)=\"x\", (1/(1/$C46*C$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L46*C$118/100/$C$9)/10.76,\"\")","v":""},{"$f":"IF(LOWER($C18)=\"x\", (1/(1/$C46*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L46*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C18)=\"x\", (1/(1/$C46*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L46*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Mineral Wool Batt","",{"$f":"IF(LOWER($C19)=\"x\", (1/(1/$C47*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L47*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C19)=\"x\", (1/(1/$C47*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L47*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Fiberglass Batt","",{"$f":"IF(LOWER($C20)=\"x\", (1/(1/$C48*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L48*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C20)=\"x\", (1/(1/$C48*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L48*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Loose Fill Fiberglass","",{"$f":"IF(LOWER($C21)=\"x\", (1/(1/$C49*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L49*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C21)=\"x\", (1/(1/$C49*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L49*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Dense Pack Blown Fiberglass","",{"$f":"IF(LOWER($C22)=\"x\", (1/(1/$C50*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L50*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C22)=\"x\", (1/(1/$C50*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L50*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Fiberboard","",{"$f":"IF(LOWER($C23)=\"x\", (1/(1/$C51*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L51*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C23)=\"x\", (1/(1/$C51*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L51*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type I (1 lb/cf)","",{"$f":"IF(LOWER($C24)=\"x\", (1/(1/$C52*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L52*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C24)=\"x\", (1/(1/$C52*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L52*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type VII (1.25 lb/cf)","",{"$f":"IF(LOWER($C25)=\"x\", (1/(1/$C53*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L53*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C25)=\"x\", (1/(1/$C53*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L53*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type II (1.5 lb/cf)","",{"$f":"IF(LOWER($C26)=\"x\", (1/(1/$C54*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L54*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C26)=\"x\", (1/(1/$C54*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L54*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type IX (2 lb/cf)","",{"$f":"IF(LOWER($C27)=\"x\", (1/(1/$C55*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L55*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C27)=\"x\", (1/(1/$C55*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L55*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Solid PU, n-pentane","",{"$f":"IF(LOWER($C28)=\"x\", (1/(1/$C56*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L56*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C28)=\"x\", (1/(1/$C56*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L56*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"XPS, CO2","",{"$f":"IF(LOWER($C29)=\"x\", (1/(1/$C57*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L57*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C29)=\"x\", (1/(1/$C57*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L57*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"XPS, HFC-134a","",{"$f":"IF(LOWER($C30)=\"x\", (1/(1/$C58*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L58*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C30)=\"x\", (1/(1/$C58*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L58*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Spray PU, Water/CO2","",{"$f":"IF(LOWER($C31)=\"x\", (1/(1/$C59*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L59*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C31)=\"x\", (1/(1/$C59*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L59*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Spray PU, HFC-245fa","",{"$f":"IF(LOWER($C32)=\"x\", (1/(1/$C60*D$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L60*D$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","",{"$f":"IF(LOWER($C32)=\"x\", (1/(1/$C60*S$118/100+$C$6/5.678)*$C$5/1.8*24/$C$8*VLOOKUP($C$7,$I$65:$J$69,2,FALSE)/1000+$L60*S$118/100/$C$9)/10.76,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"Metric","index":2,"n_rows":133,"n_cols":63,"rows_kept":133,"cut":false,"hidden":false,"merged":[]}
["Total Climatic Impact of Insulation"]
[]
[]
[null,"Inputs"]
[null,"Climate HDD (Kd)",4000]
[null,"Reference Rsi",0.18]
[null,"Heating Fuel","Natural Gas"]
[null,"Heating Efficiency/COP",0.9]
[null,"Life Span of Insulation (Years)",50]
[null,"BA Release Rate","High"]
[null,"Chart Type","R Value"]
[null,"R Value Chart x-axis maxiumum",10]
[null,"Thickness Chart x-axis maximum",30]
[null,"Chart y-axis maximum",20]
[]
[null,"Displayed in Graph (mark with \"x\")"]
[null,{"$f":"B46","v":"Cellulose"},"x"]
[null,{"$f":"B47","v":"Rigid Mineral Wool"}]
[null,"Mineral Wool Batt"]
[null,"Fiberglass Batt"]
[null,"Loose Fill Fiberglass"]
[null,"Dense Pack Blown Fiberglass"]
[null,"Fiberboard"]
[null,"EPS type I (1 lb/cf)"]
[null,"EPS type VII (1.25 lb/cf)"]
[null,"EPS type II (1.5 lb/cf)"]
[null,"EPS type IX (2 lb/cf)"]
[null,"Solid PU, n-pentane"]
[null,"XPS, CO2"]
[null,"XPS, HFC-134a"]
[null,"Spray PU, Water/CO2"]
[null,"Spray PU, HFC-245fa"]
[]
[]
[]
[]
[null,{"$f":"#REF!&\"     \"&B5&\"          \"&B7&\"                \"&B8&\"   \"&B9&\"  \"&B10","v":{"$error":"#REF!"}}]
[null,{"$f":"TEXT(#REF!,\"0.00\")&\"          \"&TEXT(C5,\"0,000\")&\"          \"&C7&\" \"&TEXT(C8,\"0.00\")&\"            \"&TEXT(C9,\"00\")&\"               \"&C10","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
["Material Data",null,"Conductivity","Mnfr CO2","Mnfr CO2","BA CO2","BA CO2","BA GWP","BA Mass","Overall","Total CO2","Total CO2"]
[null,null,"(W/mK)","(kg/m2RSI)","(kg/m3)",{"$f":"D45","v":"(kg/m2RSI)"},{"$f":"E45","v":"(kg/m3)"},"-","(kg/m2RSI)","Emissions",{"$f":"D45","v":"(kg/m2RSI)"},{"$f":"E45","v":"(kg/m3)"}]
[null,"Cellulose",3.9E-2,{"$f":"E46*C46","v":0.12171802500000001},{"$f":"(36+61)/2*64.35/1000","v":3.1209750000000001},0,{"$f":"F46/C46","v":0},0,0,0,{"$f":"D46+F46","v":0.12171802500000001},{"$f":"E46+G46","v":3.1209750000000001}]
[null,"Rigid Mineral Wool",3.6999999999999998E-2,{"$f":"E47*C47","v":6.5142791999999989},{"$f":"152*18*64.35/1000","v":176.06159999999997},0,0,0,0,0,6.5142791999999989,176.06159999999997]
[null,"Mineral Wool Batt",3.5000000000000003E-2,1.297296,{"$f":"32*18*64.35/1000","v":37.065599999999996},0,0,0,0,0,1.297296,37.065599999999996]
[null,"Fiberglass Batt",4.3999999999999997E-2,0.48399951599999996,{"$f":"7.7*22.2*64.35/1000","v":10.999988999999999},0,0,0,0,0,0.48399951599999996,10.999988999999999]
[null,"Loose Fill Fiberglass",6.3E-2,0.69299930700000001,{"$f":"7.7*22.2*64.35/1000","v":10.999988999999999},0,0,0,0,0,0.69299930700000001,10.999988999999999]
[null,"Dense Pack Blown Fiberglass",3.4000000000000002E-2,1.398855744,{"$f":"28.8*22.2*64.35/1000","v":41.142815999999996},0,0,0,0,0,1.398855744,41.142815999999996]
[null,"Fiberboard",5.5E-2,{"$f":"E52*C52","v":11.111475374999999},{"$f":"(11.2+11.8)/2*273*64.35/1000","v":202.02682499999997},0,0,0,0,0,11.111475374999999,202.02682499999997]
[null,"EPS type I (1 lb/cf)",0.04,5.2303679999999995,{"$f":"16*127*64.35/1000","v":130.75919999999999},{"$f":"H53*I53*J53","v":0.26880000000000004},6.7200000000000006,{"$f":"H57","v":7},{"$f":"I57","v":3.8400000000000004E-2},1,5.4991679999999992,137.47919999999999]
[null,"EPS type VII (1.25 lb/cf)",3.7999999999999999E-2,6.2110620000000001,{"$f":"20*127*64.35/1000","v":163.44900000000001},0.26880000000000004,7.0736842105263174,{"$f":"H57","v":7},{"$f":"I57","v":3.8400000000000004E-2},1,6.4798619999999998,170.52268421052634]
[null,"EPS type II (1.5 lb/cf)",3.5999999999999997E-2,7.060996799999999,{"$f":"24*127*64.35/1000","v":196.13879999999997},0.26880000000000004,7.4666666666666686,{"$f":"H57","v":7},{"$f":"I57","v":3.8400000000000004E-2},1,7.3297967999999987,203.60546666666664]
[null,"EPS type IX (2 lb/cf)",3.4000000000000002E-2,8.8916255999999994,{"$f":"32*127*64.35/1000","v":261.51839999999999},0.26880000000000004,7.9058823529411768,{"$f":"H57","v":7},{"$f":"I57","v":3.8400000000000004E-2},1,9.1604255999999999,269.42428235294119]
[null,"Solid PU, n-pentane",2.4E-2,6.7706495999999996,{"$f":"D57/C57","v":282.11039999999997},7.6326417887153025E-2,3.1802674119647092,7,3.8400000000000004E-2,{"$f":"IF($C$10=\"Low\",D66,IF($C$10=\"High\",E66,F66))","v":0.283952447496849},6.8469760178871528,285.29066741196471]
[null,"XPS, CO2",3.3000000000000002E-2,6.0680441250000001,{"$f":"D58/C58","v":183.88012499999999},5.361358789859319E-2,1.6246541787452482,1,5.9400000000000008E-2,{"$f":"IF($C$10=\"Low\",D69,IF($C$10=\"High\",E69,F69))","v":0.90258565485847109},6.1216577128985934,185.50477917874525]
[null,"XPS, HFC-134a",2.9000000000000001E-2,5.3325236250000003,{"$f":"D59/C59","v":183.88012499999999},67.374408792565447,2323.2554756057048,1430,5.220000000000001E-2,{"$f":"IF($C$10=\"Low\",D70,IF($C$10=\"High\",E70,F70))","v":0.90258565485847109},72.70693241756544,2507.1356006057049]
[null,"Spray PU, Water/CO2",2.9000000000000001E-2,12.9594465,{"$f":"D60/C60","v":446.87746551724138},1.6790786188272053E-2,0.57899262718179489,1,3.5000000000000003E-2,{"$f":"IF($C$10=\"Low\",D73,IF($C$10=\"High\",E73,F73))","v":0.47973674823634427},12.976237286188272,447.45645814442315]
[null,"Spray PU, HFC-245fa",2.4E-2,8.3927844,{"$f":"D61/C61","v":349.69934999999998},17.294509773920211,720.60457391334216,1030,3.5000000000000003E-2,{"$f":"IF($C$10=\"Low\",D74,IF($C$10=\"High\",E74,F74))","v":0.47973674823634427},25.687294173920211,1070.3039239133423]
[]
["Overall Emissions",null,"Mnfr","Annual Rate/Full Emissions",null,null,null,"GWP by Fuel Type"]
[null,null,null,"Low","High","All"]
[null,null,null,2E-3,5.0000000000000001E-3,1,null,null,null,"kgCO2/kWh"]
[null,"Solid PU, n-pentane",0.08,{"$f":"1-(1-$C66)*(1-D$65)^$C$9","v":0.16763292743628688},{"$f":"1-(1-$C66)*(1-E$65)^$C$9","v":0.283952447496849},{"$f":"1-(1-$C66)*(1-F$65)^$C$9","v":1},null,null,"Wood",0.05,"from PHPP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Low"]
[null,null,null,null,null,null,null,null,"Natural Gas",0.23200000000000001,"from EIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High"]
[null,null,null,7.4999999999999997E-3,0.04,1,null,null,"LPG",0.21299999999999999,"from EIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All"]
[null,"XPS, CO2",0.25,{"$f":"1-(1-$C69)*(1-D$68)^$C$9","v":0.48526104663117897},0.90258565485847109,1,null,null,"Fuel Oil",0.25,"from EIA"]
[null,"XPS, HFC-134a",0.25,0.48526104663117897,0.90258565485847109,1,null,null,"Electricity",0.60599999999999998,"from EIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R Value"]
[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,"Thickness"]
[null,null,null,1.0999999999999999E-2,1.0999999999999999E-2,1]
[null,"Spray PU, Water/CO2",{"$f":"AVERAGE(6.4,11.8,11.8,6.4,11.8,9.1)/100","v":9.5500000000000002E-2},{"$f":"1-(1-$C73)*(1-D$72)^$C$9","v":0.47973674823634427},0.47973674823634427,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greed"]
[null,"Spray PU, HFC-245fa",{"$f":"AVERAGE(6.4,11.8,11.8,6.4,11.8,9.1)/100","v":9.5500000000000002E-2},0.47973674823634427,0.47973674823634427,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hatred"]
[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,"Delusion"]
["Chart Data"]
[null,{"$f":"IF($C$11=\"Final Rsi\",B97, B116)","v":"Net Impact (kgCO2eq/m2a)"},{"$f":"IF($C$11=\"R Value\",C97, C116)","v":"Whole Assembly Rsi (m2K/W)"}]
[null,null,0.18,{"$f":"IF($C$11=\"R Value\",D98, D117)","v":1.18},2.1799999999999997,3.1799999999999997,4.18,5.18,6.18,7.18,8.18,9.18,10.18,11.18,12.18,13.18,14.18,15.18,16.18,17.18,18.18,19.18,20.18,21.18,22.18,23.18,24.18,25.18,26.18,27.18,{"$f":"IF($C$11=\"R Value\",AE98, AE117)","v":28.18},29.18,30.18,31.18,32.18,33.18,34.18,35.18,36.18,37.18,38.18,39.18,40.18,41.18,42.18,43.18,44.18,45.18,46.18,47.18,48.18,49.18,50.18,51.18,52.18,53.18,54.18,55.18,56.18,57.18,58.18,59.18,60.18]
[null,{"$f":"IF($C$11=\"Final Rsi\",B99, B118)","v":"Cellulose"},137.4814814814815,{"$f":"IF($C$11=\"R Value\",D99, D118)","v":20.974185772929381},11.356550678186547,7.7892737313951788,5.9299926254130799,4.7895205798487792,4.0189211576062576,3.4636514798602609,3.0447397576756319,2.7176245676663044,2.4552538865979048,2.2402544115345853,2.0609583577460318,1.909238998083207,1.7792620531118946,1.666730602932587,1.5684100069781624,1.4818187423921225,1.4050212759453613,1.3364857309737574,1.2749838733630661,1.2195194301159902,1.1692757987487226,1.1235772917876043,1.0818599980159915,1.0436495870300504,1.0085442006037686,0.97620112079457932,{"$f":"IF($C$11=\"R Value\",AE99, AE118)","v":0.946326276635439},0.91866590846390217,0.89299988944223552,0.86913633222439612,0.84690720121649066,0.82616471828018889,0.80677839938346019,0.78863259665482288,0.77162444805712194,0.75566215793697333,0.74066354778645005,0.72655482894019063,0.71326955854322227,0.70074774763615022,0.68893509611300763,0.67778233398417476,0.66724465210110162,0.657281208481998,0.64785469877883628,0.63893098136915361,0.63047874913629454,0.62246924129273418,0.61487598966055534,0.6076745946963007,0.60084252726996301,0.59435895280813589,0.5882045749118987,0.58236149597891762,0.57681309271104786,0.57154390468514638,0.56653953441537752,0.56178655754776385,0.55727244200841919]
[null,"Rigid Mineral Wool","",{"$f":"IF($C$11=\"R Value\",D100, D119)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE100, AE119)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Mineral Wool Batt","",{"$f":"IF($C$11=\"R Value\",D101, D120)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE101, AE120)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Fiberglass Batt","",{"$f":"IF($C$11=\"R Value\",D102, D121)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE102, AE121)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Loose Fill Fiberglass","",{"$f":"IF($C$11=\"R Value\",D103, D122)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE103, AE122)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Dense Pack Blown Fiberglass","",{"$f":"IF($C$11=\"R Value\",D104, D123)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE104, AE123)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Fiberboard","",{"$f":"IF($C$11=\"R Value\",D105, D124)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE105, AE124)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type I (1 lb/cf)","",{"$f":"IF($C$11=\"R Value\",D106, D125)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE106, AE125)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type VII (1.25 lb/cf)","",{"$f":"IF($C$11=\"R Value\",D107, D126)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE107, AE126)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type II (1.5 lb/cf)","",{"$f":"IF($C$11=\"R Value\",D108, D127)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE108, AE127)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type IX (2 lb/cf)","",{"$f":"IF($C$11=\"R Value\",D109, D128)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE109, AE128)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Solid PU, n-pentane","",{"$f":"IF($C$11=\"R Value\",D110, D129)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE110, AE129)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"XPS, CO2","",{"$f":"IF($C$11=\"R Value\",D111, D130)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE111, AE130)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"XPS, HFC-134a","",{"$f":"IF($C$11=\"R Value\",D112, D131)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE112, AE131)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Spray PU, Water/CO2","",{"$f":"IF($C$11=\"R Value\",D113, D132)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE113, AE132)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Spray PU, HFC-245fa","",{"$f":"IF($C$11=\"R Value\",D114, D133)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF($C$11=\"R Value\",AE114, AE133)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[]
[null,"Net Impact (kgCO2eq/m2a)","Whole Assembly Rsi (m2K/W)"]
[null,null,{"$f":"C6","v":0.18},{"$f":"C98+1","v":1.18},{"$f":"D98+1","v":2.1799999999999997},3.1799999999999997,4.18,5.18,6.18,7.18,8.18,9.18,10.18,11.18,12.18,13.18,14.18,15.18,16.18,17.18,18.18,19.18,20.18,21.18,22.18,23.18,24.18,25.18,26.18,27.18,{"$f":"AD98+1","v":28.18},29.18,30.18,31.18,32.18,33.18,34.18,35.18,36.18,37.18,38.18,39.18,40.18,41.18,42.18,43.18,44.18,45.18,46.18,47.18,48.18,49.18,50.18,51.18,52.18,53.18,54.18,55.18,56.18,57.18,58.18,59.18,60.18]
[null,{"$f":"B46","v":"Cellulose"},{"$f":"IF(LOWER($C17)=\"x\", 1/C$98*$C$5*24/$C$8*VLOOKUP($C$7,$I$66:$J$70,2,FALSE)/1000+$K46*(C$98-$C$6)/$C$9,\"\")","v":137.4814814814815},{"$f":"IF(LOWER($C17)=\"x\", 1/D$98*$C$5*24/$C$8*VLOOKUP($C$7,$I$66:$J$70,2,FALSE)/1000+$K46*(D$98-$C$6)/$C$9,\"\")","v":20.974185772929381},11.356550678186547,7.7892737313951788,5.9299926254130799,4.7895205798487792,4.0189211576062576,3.4636514798602609,3.0447397576756319,2.7176245676663044,2.4552538865979048,2.2402544115345853,2.0609583577460318,1.909238998083207,1.7792620531118946,1.666730602932587,1.5684100069781624,1.4818187423921225,1.4050212759453613,1.3364857309737574,1.2749838733630661,1.2195194301159902,1.1692757987487226,1.1235772917876043,1.0818599980159915,1.0436495870300504,1.0085442006037686,0.97620112079457932,0.946326276635439,0.91866590846390217,0.89299988944223552,0.86913633222439612,0.84690720121649066,0.82616471828018889,0.80677839938346019,0.78863259665482288,0.77162444805712194,0.75566215793697333,0.74066354778645005,0.72655482894019063,0.71326955854322227,0.70074774763615022,0.68893509611300763,0.67778233398417476,0.66724465210110162,0.657281208481998,0.64785469877883628,0.63893098136915361,0.63047874913629454,0.62246924129273418,0.61487598966055534,0.6076745946963007,0.60084252726996301,0.59435895280813589,0.5882045749118987,0.58236149597891762,0.57681309271104786,0.57154390468514638,0.56653953441537752,0.56178655754776385,0.55727244200841919]
[null,"Rigid Mineral Wool","",{"$f":"IF(LOWER($C18)=\"x\", 1/D$98*$C$5*24/$C$8*VLOOKUP($C$7,$I$66:$J$70,2,FALSE)/1000+$K47*(D$98-$C$6)/$C$9,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Mineral Wool Batt","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Fiberglass Batt","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Loose Fill Fiberglass","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(LOWER($C21)=\"x\", 1/AH$98*$C$5*24/$C$8*VLOOKUP($C$7,$I$66:$J$70,2,FALSE)/1000+$K50*(AH$98-$C$6)/$C$9,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Dense Pack Blown Fiberglass","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Fiberboard","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type I (1 lb/cf)","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type VII (1.25 lb/cf)","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(LOWER($C25)=\"x\", 1/AW$98*$C$5*24/$C$8*VLOOKUP($C$7,$I$66:$J$70,2,FALSE)/1000+$K54*(AW$98-$C$6)/$C$9,\"\")","v":""},"","","","","","","","","","","","","",""]
[null,"EPS type II (1.5 lb/cf)","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type IX (2 lb/cf)","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Solid PU, n-pentane","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"XPS, CO2","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"XPS, HFC-134a","",{"$f":"IF(LOWER($C30)=\"x\", 1/D$98*$C$5*24/$C$8*VLOOKUP($C$7,$I$66:$J$70,2,FALSE)/1000+$K59*(D$98-$C$6)/$C$9,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Spray PU, Water/CO2","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Spray PU, HFC-245fa","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Net Impact (kgCO2eq/m2a)","Added Thickness (cm)"]
[null,null,0,{"$f":"C117+2.5","v":2.5},{"$f":"D117+2.5","v":5},7.5,10,12.5,15,17.5,20,22.5,25,27.5,30,32.5,35,37.5,40,42.5,45,47.5,50,52.5,55,57.5,60,62.5,65,67.5,{"$f":"AD117+2.5","v":70},72.5,75,77.5,80,82.5,85,87.5,90,92.5,95,97.5,100,102.5,105,107.5,110,112.5,115,117.5,120,122.5,125,127.5,{"$f":"BB117+2.5","v":130},132.5,135,137.5,140,142.5,145,147.5,150]
[null,{"$f":"B46","v":"Cellulose"},{"$f":"IF(LOWER($C17)=\"x\", 1/(1/$C46*C$117/100+$C$6)*$C$5*24/$C$8*VLOOKUP($C$7,$I$66:$J$70,2,FALSE)/1000+$L46*C$117/100/$C$9,\"\")","v":137.4814814814815},{"$f":"IF(LOWER($C17)=\"x\", 1/(1/$C46*D$117/100+$C$6)*$C$5*24/$C$8*VLOOKUP($C$7,$I$66:$J$70,2,FALSE)/1000+$L46*D$117/100/$C$9,\"\")","v":30.142722261391324},16.929111855392851,11.771567587835284,9.0243694028125567,7.318209951513027,6.1558410806489618,5.3131978878323816,4.6744489275335717,4.173685797723258,3.7706433934032368,3.439334003021949,3.1622344162171849,2.927099180099844,2.7251127484776765,2.5497671889462596,2.3961534911208298,2.2604989370069677,2.1398563125257102,2.0318898334306668,1.9347244042542697,1.84683737783307,1.7669794629268247,1.6941160157713651,1.627382839006952,1.5660524710353314,1.5095081716363274,1.4572236290552329,1.4087469723954062,1.3636880600704213,1.3217082869904364,1.2825123468418327,1.2458415255037052,1.2114682035549025,1.1791913209802571,1.1488326131677855,1.1202334693843574,1.0932522968506577,1.0677622979619026,1.0436495870300504,1.0208115875454307,0.99915566239002152,0.9785979384349397,0.95906229408351984,0.9404794840011923,0.92278637982434053,0.90592530930623494,0.88984347932628016,0.87449247060363533,0.85982779393009034,0.84580849935760771,0.83239683111203422,0.81955792211060263,0.80725952288009939,0.7954717604394187,0.78416692335223082,0.77331926969481612,0.76290485513872008,0.75290137873227558,0.74328804429106876,0.73404543558479662]
[null,"Rigid Mineral Wool","",{"$f":"IF(LOWER($C18)=\"x\", 1/(1/$C47*D$117/100+$C$6)*$C$5*24/$C$8*VLOOKUP($C$7,$I$66:$J$70,2,FALSE)/1000+$L47*D$117/100/$C$9,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Mineral Wool Batt","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Fiberglass Batt","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Loose Fill Fiberglass","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(LOWER($C21)=\"x\", 1/(1/$C50*AH$117/100+$C$6)*$C$5*24/$C$8*VLOOKUP($C$7,$I$66:$J$70,2,FALSE)/1000+$L50*AH$117/100/$C$9,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Dense Pack Blown Fiberglass","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Fiberboard","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type I (1 lb/cf)","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type VII (1.25 lb/cf)","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(LOWER($C25)=\"x\", 1/(1/$C54*AW$117/100+$C$6)*$C$5*24/$C$8*VLOOKUP($C$7,$I$66:$J$70,2,FALSE)/1000+$L54*AW$117/100/$C$9,\"\")","v":""},"","","","","","","","","","","","","",""]
[null,"EPS type II (1.5 lb/cf)","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"EPS type IX (2 lb/cf)","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Solid PU, n-pentane","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"XPS, CO2","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"XPS, HFC-134a","",{"$f":"IF(LOWER($C30)=\"x\", 1/(1/$C59*D$117/100+$C$6)*$C$5*24/$C$8*VLOOKUP($C$7,$I$66:$J$70,2,FALSE)/1000+$L59*D$117/100/$C$9,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Spray PU, Water/CO2","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Spray PU, HFC-245fa","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]