{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Introduction","iWARM","Material Mass Assumptions","Appliance Assumptions","Appliance List","Product Conversions","Energy Savings","Calculations","Conversions"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":9,"comments":4,"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":"Introduction","index":0,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,3,6,9],[8,3,11,9],[13,3,16,9]]}
[]
[]
[null,null,null,"iWARM (Individual Waste Reduction Model) is an EPA tool designed to help you understand the energy saved by recycling small quantities of common waste materials. iWARM uses the same energy factors as EPA's Waste Reduction Model (WARM)* to provide the relative energy savings from recycling a particular material unit compared to landfilling it."]
[]
[]
[]
[]
[]
[null,null,null,"In WARM, the energy consequences of waste management decisions are quantified for large-scale waste diversions (e.g., tons of aluminum cans). In iWARM, the tool quantifies the energy savings for household-scale amounts of common waste materials (e.g., a single aluminum can). "]
[]
[]
[]
[]
[null,null,null,"iWARM translates the total energy savings from recycling the materials you choose into an equivalent amount of electricity.  The tool then tells you how long you could run a variety a household appliances  (e.g., clothes washer, hairdryer) using that amount of electricity, and shows the results in a graph."]
[]
[]
[]
[]
[null,null,null,"*WARM is available online at: http://www.epa.gov/warm"]

{"sheet":"iWARM","index":1,"n_rows":72,"n_cols":18,"rows_kept":72,"cut":false,"hidden":false,"merged":[[46,3,48,6],[29,3,33,6],[35,3,39,6],[41,3,44,6],[4,16,5,16],[4,11,5,12],[7,11,7,12],[6,11,6,12],[12,10,12,18]]}
[null,"Version 2"]
[null,null,"Individual Waste Reduction Model (iWARM) "]
[null,null,"1. Inputs",null,null,null,null,null,null,null,"2. Results"]
[null,null,null,"Enter the number of items of each product type you will be recycling in the column on the right"]
[null,null,null,"Product Type",null,"Number of Items",null,null,null,null,null,"Net Energy Savings ",null,null,null,null,"Delivered Electricity Equivalent "]
[]
[null,null,null,"Aluminum drink can (12 fl. oz.)",null,null,null,null,null,null,null,"(Thousand Btu)",null,null,null,null,"(kWh)"]
[null,null,null,"Steel soup can (15.5 fl. oz.)",null,null,null,null,null,null,null,{"$f":"SUM(Calculations!$G$5:$G$24)","v":0},null,null,null,null,{"$f":"(L8/Conversions!$C$23)","v":0}]
[null,null,null,"Metal coat hanger"]
[null,null,null,"Glass bottle (12 fl. oz.)"]
[null,null,null,"Glass wine bottle (0.75 liter) "]
[null,null,null,"Gallon plastic milk jug"]
[null,null,null,"Gallon plastic detergent container",null,null,null,null,null,null,"3. The energy saved by recycling these products is equal to the electricity required to run"]
[null,null,null,"Plastic grocery bag",null,null,null,null,null,null,null," ONE of the following appliances for the indicated number of hours:"]
[null,null,null,"Plastic bottle (20 fl. oz.)"]
[null,null,null,"Plastic bottle (2 liter)",null,null,null,null,null,null,null,"Click on individual checkboxes to graph the hours equivalent for a particular appliance"]
[null,null,null,"2' x 2' x 2.5' corrugated cardboard box, 3mm thick",null,null,null,null,null,null,null,"Select All"]
[null,null,null,"Weekly magazine",null,null,null,null,null,null,null,"Appliance",null,"Hours Available",null,null,"Appliance","Hours Available"]
[null,null,null,"Catalog",null,null,null,null,null,null,null,"Room Air Conditioner",null,{"$f":"$Q$8/'Appliance List'!$E$52","v":0},null,null,"Dishwasher (w/dry cycle)",{"$f":"$Q$8/('Appliance List'!$C$15/1000)","v":0}]
[null,null,null,"Daily newspaper",null,null,null,null,null,null,null,"Ceiling Fan",null,{"$f":"$Q$8/'Appliance List'!$E$19","v":0},null,null,"Dishwasher (w/o dry cycle)",{"$f":"$Q$8/('Appliance List'!$B$15/1000)","v":0}]
[null,null,null,"Sunday edition of newspaper",null,null,null,null,null,null,null,"Window Fan",null,{"$f":"$Q$8/'Appliance List'!$E$20","v":0},null,null,"Light bulb, CFL (60 W equivalent)",{"$f":"$Q$8/'Appliance List'!$E$47","v":0}]
[null,null,null,"12-inch stack of newspaper",null,null,null,null,null,null,null,"Hairdryer",null,{"$f":"$Q$8/'Appliance List'!$E$23","v":0},null,null,"Light bulb, Incandescent (60 W)",{"$f":"$Q$8/'Appliance List'!$E$46","v":0}]
[null,null,null,"Printer paper, 1 ream (500 sheets)",null,null,null,null,null,null,null,"Clothes Dryer",null,{"$f":"$Q$8/'Appliance List'!$E$13","v":0},null,null,"Laptop Computer",{"$f":"$Q$8/'Appliance List'!$E$29","v":0}]
[null,null,null,"Sheet of printer paper",null,null,null,null,null,null,null,"Clothes Washer",null,{"$f":"$Q$8/'Appliance List'!$E$12","v":0},null,null,"CRT Television, 36\"",{"$f":"$Q$8/'Appliance List'!$E$35","v":0}]
[null,null,null,"White business envelope"]
[null,null,null,"Paperboard cereal box"]
[]
[]
[null,null,null,"Important Assumptions"]
[null,null," - ","Net energy savings are the result of recycling a product instead of landfilling it. EPA recognizes that not all products that are disposed are sent to a landfill. According to EPA's MSW Facts and Figures report, approximately 54% of all waste disposed is landfilled, 34% is recycled and the remaining 12% is combusted. The benefits of recycling as compared to combustion would be different than those presented here. However, since the majority of waste disposed is landfilled, this assumption is representative of the main disposal pathway in the United States."]
[]
[]
[]
[]
[]
[null,null," - ","The recycled product is assumed to be manufactured using 100% recycled inputs, and to displace the manufacture of a product made with 100% virgin inputs.  EPA recognizes that products that are recycled generally displace new materials that have a mixture of recycled and virgin inputs (i.e., current average industry mix). The benefits presented here may be overstated for some materials (e.g., aluminum cans) for which the current average industry mix includes a high percentage of recycled inputs."]
[]
[]
[]
[]
[]
[null,null," - ","All the upstream energy saved via recycling is described in terms of delivered electricity energy downstream. In other words, the energy content of all fuels saved in the production process is expressed in terms of delivered electricity energy equivalent. The delivered electricity equivalent incorporates transmission and distribution losses.  "]
[]
[]
[]
[]
[null,null," - ","The hours equivalencies for appliances are not additive and indicate the hours available to operate ONE appliance on the list at a time. The graph shows the comparison of hours available based on typical wattage of an appliance during operation.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Do not change any of these cells"]
[null,null,null,null,"hours","checked"]
[null,null,null,"Count",null,{"$f":"COUNTIF(F61:F72,TRUE)","v":0}]
[]
[null,null,null,{"$f":"L19","v":"Room Air Conditioner"},{"$f":"IF(F61,N19,0)","v":0},false]
[null,null,null,{"$f":"L20","v":"Ceiling Fan"},{"$f":"IF(F62,N20,0)","v":0},false]
[null,null,null,{"$f":"L21","v":"Window Fan"},{"$f":"IF(F63,N21,0)","v":0},false]
[null,null,null,{"$f":"L23","v":"Clothes Dryer"},{"$f":"IF(F64,N23,0)","v":0},false]
[null,null,null,{"$f":"L24","v":"Clothes Washer"},{"$f":"IF(F65,N24,0)","v":0},false]
[null,null,null,{"$f":"Q19","v":"Dishwasher (w/dry cycle)"},{"$f":"IF(F66,R19,0)","v":0},false]
[null,null,null,{"$f":"Q20","v":"Dishwasher (w/o dry cycle)"},{"$f":"IF(F67,R20,0)","v":0},false]
[null,null,null,{"$f":"L22","v":"Hairdryer"},{"$f":"IF(F68,N22,0)","v":0},false]
[null,null,null,{"$f":"Q21","v":"Light bulb, CFL (60 W equivalent)"},{"$f":"IF(F69,R21,0)","v":0},false]
[null,null,null,{"$f":"Q22","v":"Light bulb, Incandescent (60 W)"},{"$f":"IF(F70,R22,0)","v":0},false]
[null,null,null,{"$f":"Q23","v":"Laptop Computer"},{"$f":"IF(F71,R23,0)","v":0},false]
[null,null,null,{"$f":"Q24","v":"CRT Television, 36\""},{"$f":"IF(F72,R24,0)","v":0},false]

{"sheet":"Material Mass Assumptions","index":2,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Material Mass Assumptions"]
["The following are assumptions made in this model regarding the mass of each product."]
[]
["Example Products","Material Type","shorthand description","Weight (lbs)","Unit Explanation/Notes"]
["Aluminum drink can (12 fl. oz.)","Aluminum Cans","cans",2.8660100000000001E-2,"per can"]
["Soup steel can (15.5 fl. oz.)","Steel Cans","cans",0.13,"per tin ferrous can"]
["Metal coat hanger","Steel Cans","hangers",0.14000000000000001,"per hanger (adult)"]
["Glass bottle (12 fl. oz.)","Glass","bottles",0.53,"per bottle"]
["Glass wine bottle (0.75 liter) ","Glass","wine bottles",{"$f":"1.08","v":1.08},"per bottle"]
["Gallon plastic milk jug","HDPE","jugs",0.20499999999999999,"per empty jug"]
["Gallon plastic detergent container","HDPE","containers",0.33,"per empty container"]
["Plastic grocery bag","HDPE","bags",{"$f":"0.77/100","v":7.7000000000000002E-3},"per bag"]
["Plastic bottle (20 fl. oz.)","PET","bottles",5.1400000000000001E-2,"per bottle"]
["Plastic bottle (2 liter)","PET","bottles",0.13,"per bottle"]
["2' x 2' x 2.5' cardbox, 3mm ","Corrugated Cardboard","boxes",2.2000000000000002,"per box"]
["Annual magazine","Magazines/Third-class Mail","magazines",{"$f":"3/10","v":0.3},"per 8.5\" x 11\" magazine (10 magazines per year)"]
["Catalog","Magazines/Third-class Mail","catalogs",1,"per catalog of 100 pages ledger"]
["Daily newspaper","Newspaper","newspapers",0.44440000000000002,"per weekday edition of newspaper"]
["Sunday New York Times","Newspaper","newspapers",4.2,"per Sunday edition of newspaper"]
["12-inch stack of newspaper","Newspaper","stacks",35,"per 12\" stack"]
["Printer paper, 1 ream (500 sheets)","Office Paper","reams",5,"per 500 sheets of letter 8 1/2\" x 11\", "]
["Sheet of printer paper","Office Paper","sheets",{"$f":"D21/500","v":0.01},"per 1 sheet of letter 8 1/2\" x 11\", "]
["White business envelope","Office Paper","envelopes",1.0999999999999999E-2,"per No. 10 envelope (4 1/8\" x 9 1/2\") 24 bond paper"]
["Paperboard Cereal box","Broad Definition","cereal boxes",0.15,"per average Chipboard, cereal box"]

{"sheet":"Appliance Assumptions","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Appliance Assumptions"]
[]
[]
["Appliance","Wattage","Unit Explanation/Notes","Source ","Web link"]
["Room Air Conditioner",{"$f":"'Appliance List'!D52","v":1500},"Energy efficiency ratio (EER) equals 8","Energy Efficiency and Renewable Energy (EERE), US DOE, 2008","http://apps1.eere.energy.gov/consumer/your_home/space_heating_cooling/index.cfm/mytopic=12420"]
["Ceiling Fan",120,"Average of range of typical wattage","Energy Efficiency and Renewable Energy (EERE), US DOE, 2008","http://www.energy.ca.gov/appliances/database/historical_excel_files/Fans/"]
["Window Fan",{"$f":"'Appliance List'!D20","v":152.5},"Average of range of typical wattage","Energy Efficiency and Renewable Energy (EERE), US DOE, 2008","http://www.energysavers.gov/your_home/appliances/index.cfm/mytopic=10040"]
["Hairdryer",{"$f":"'Appliance List'!D23","v":1537.5},"Average of range of typical wattage","Energy Efficiency and Renewable Energy (EERE), US DOE, 2008","http://www.energysavers.gov/your_home/appliances/index.cfm/mytopic=10040"]
["Clothes Dryer",{"$f":"'Appliance List'!D13","v":3400},"Average of range of typical wattage","Energy Efficiency and Renewable Energy (EERE), US DOE, 2008","http://www.energysavers.gov/your_home/appliances/index.cfm/mytopic=10040"]
["Clothes Washer",{"$f":"'Appliance List'!D12","v":425},"Average of range of typical wattage","Energy Efficiency and Renewable Energy (EERE), US DOE, 2008","http://www.energysavers.gov/your_home/appliances/index.cfm/mytopic=10040"]
["Dishwasher (w/dry cycle)",{"$f":"'Appliance List'!C15","v":2400},"Maximum of range of typical wattage","Energy Efficiency and Renewable Energy (EERE), US DOE, 2008","http://www.energysavers.gov/your_home/appliances/index.cfm/mytopic=10040"]
["Dishwasher (w/o dry cycle)",{"$f":"'Appliance List'!B15","v":1200},"Minimum of range of typical wattage","Energy Efficiency and Renewable Energy (EERE), US DOE, 2008","http://www.energysavers.gov/your_home/appliances/index.cfm/mytopic=10040"]
["Light bulb, CFL (60 W equivalent)",{"$f":"'Appliance List'!D47","v":13},"Wattage equivalent for same light output as 60 W incandescent","Energy Star, US EPA and US DOE, 2009","http://www.energystar.gov/index.cfm?c=cfls.pr_cfls_lumens"]
["Light bulb, Incandescent (60 W)",{"$f":"'Appliance List'!D46","v":60},"Wattage for 60 W incandescent","Energy Star, US EPA and US DOE, 2009","http://www.energystar.gov/index.cfm?c=cfls.pr_cfls_lumens"]
["Laptop Computer",{"$f":"'Appliance List'!D29","v":50},"Typical wattage as listed","Energy Efficiency and Renewable Energy (EERE), US DOE, 2008","http://www.energysavers.gov/your_home/appliances/index.cfm/mytopic=10040"]
["CRT Television, 36\"",{"$f":"'Appliance List'!D35","v":133},"Typical wattage as listed","Energy Efficiency and Renewable Energy (EERE), US DOE, 2008","http://www.energysavers.gov/your_home/appliances/index.cfm/mytopic=10040"]

{"sheet":"Appliance List","index":4,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[47,0,47,3]]}
["Source: Energy Efficiency and Renewable Energy (EERE), US DOE, 2008"]
["http://apps1.eere.energy.gov/consumer/your_home/appliances/index.cfm/mytopic=10040"]
[]
[]
["Typical Wattages of Various Appliances"]
[]
[]
[null,"minimum","maximum","average","kW"]
["Aquarium",50,1210,{"$f":"AVERAGE(B9:C9)","v":630},{"$f":"D9/Conversions!$C$7","v":0.63},null,null,"https://data.energystar.gov/"]
["Clock radio",10,10,{"$f":"AVERAGE(B10:C10)","v":10},{"$f":"D10/Conversions!$C$7","v":0.01},null,null,null,null,"http://www.appliances.energy.ca.gov/QuickSearch1024.aspx"]
["Coffee maker",900,1200,1050,{"$f":"D11/Conversions!$C$7","v":1.05}]
["Clothes washer",350,500,425,{"$f":"D12/Conversions!$C$7","v":0.42499999999999999},null,null,"kwH/year","Clothes washer","washer type"]
["Clothes dryer",1800,5000,3400,{"$f":"D13/Conversions!$C$7","v":3.4},null,null,"kwH/year","Clothes dryer","drum capacity"]
["Clothes iron",1000,1800,{"$f":"AVERAGE(B14:C14)","v":1400},{"$f":"D14/Conversions!$C$7","v":1.4}]
["Dishwasher ",1200,2400,1800,{"$f":"D15/Conversions!$C$7","v":1.8},null,null,"kWh/year","Dishwasher ","kWh and water"]
["Dehumidifier",785,785,785,{"$f":"D16/Conversions!$C$7","v":0.78500000000000003}]
["Electric blanket (Single/Double) ",60,100,80,{"$f":"D17/Conversions!$C$7","v":0.08}]
["Fans",null,null,null,null,null,null,null,"Fans"]
["Ceiling",65,175,120,{"$f":"D19/Conversions!$C$7","v":0.12},null,null,"W","Ceiling","CFM/watt"]
["Window ",55,250,152.5,{"$f":"D20/Conversions!$C$7","v":0.1525},null,null,"W","Window ","missing"]
["Furnace",750,750,750,{"$f":"D21/Conversions!$C$7","v":0.75}]
["Whole house ",240,750,495,{"$f":"D22/Conversions!$C$7","v":0.495}]
["Hair dryer ",1200,1875,1537.5,{"$f":"D23/Conversions!$C$7","v":1.5375000000000001}]
["Heater (portable)",750,1500,{"$f":"AVERAGE(B24:C24)","v":1125},{"$f":"D24/Conversions!$C$7","v":1.125}]
["Microwave oven",750,1100,{"$f":"AVERAGE(B25:C25)","v":925},{"$f":"D25/Conversions!$C$7","v":0.92500000000000004}]
["Personal computer"]
["CPU - awake",120,120,{"$f":"AVERAGE(B27:C27)","v":120},{"$f":"D27/Conversions!$C$7","v":0.12}]
["Monitor - awake",150,150,{"$f":"AVERAGE(B28:C28)","v":150},{"$f":"D28/Conversions!$C$7","v":0.15}]
["Laptop",50,50,{"$f":"AVERAGE(B29:C29)","v":50},{"$f":"D29/Conversions!$C$7","v":0.05},null,null,"watts per mode","Laptop",50,50,{"$f":"AVERAGE(J29:K29)","v":50},{"$f":"L29/Conversions!$C$7","v":0.05}]
["Radio (stereo) ",70,400,{"$f":"AVERAGE(B30:C30)","v":235},{"$f":"D30/Conversions!$C$7","v":0.23499999999999999}]
["Refrigerator (frost-free, 16 cubic feet) ",725,725,{"$f":"AVERAGE(B31:C31)","v":725},{"$f":"D31/Conversions!$C$7","v":0.72499999999999998}]
["Televisions (color)"]
["19\" ",65,110,{"$f":"AVERAGE(B33:C33)","v":87.5},{"$f":"D33/Conversions!$C$7","v":8.7499999999999994E-2}]
["27\"",113,113,113,{"$f":"D34/Conversions!$C$7","v":0.113},null,null,"watts per mode","36\" ",57.6,94,{"$f":"AVERAGE(J34:K34)","v":75.8},{"$f":"L34/Conversions!$C$7","v":7.5799999999999992E-2}]
["36\" ",133,133,133,{"$f":"D35/Conversions!$C$7","v":0.13300000000000001}]
["53\"-61\" Projection",170,170,170,{"$f":"D36/Conversions!$C$7","v":0.17}]
["Flat screen ",120,120,120,{"$f":"D37/Conversions!$C$7","v":0.12}]
["Toaster ",800,1400,1100,{"$f":"D38/Conversions!$C$7","v":1.1000000000000001}]
["Toaster oven",1225,1225,1225,{"$f":"D39/Conversions!$C$7","v":1.2250000000000001}]
["VCR/DVD",21,25,23,{"$f":"D40/Conversions!$C$7","v":2.3E-2}]
["Vacuum cleaner ",1000,1440,1220,{"$f":"D41/Conversions!$C$7","v":1.22}]
["Water heater (40 gallon) ",4500,5500,5000,{"$f":"D42/Conversions!$C$7","v":5}]
["Water pump (deep well) ",250,1100,675,{"$f":"D43/Conversions!$C$7","v":0.67500000000000004}]
["Water bed (with heater, no cover) ",120,380,250,{"$f":"D44/Conversions!$C$7","v":0.25}]
[]
["Light bulb Incandescent (60 W)",60,60,60,{"$f":"D46/Conversions!$C$7","v":0.06},null,null,null,"Light bulb Incandescent (60 W)",60,60,60,{"$f":"L46/Conversions!$C$7","v":0.06}]
["Light bulb CFL (60 W eq.)",13,13,13,{"$f":"D47/Conversions!$C$7","v":1.2999999999999999E-2},null,null,"Watts","Light bulb CFL (60 W eq.)",null,null,13,{"$f":"L47/Conversions!$C$7","v":1.2999999999999999E-2}]
[]
[]
[]
[null,"EER (Energy Efficiency Ratio) ","but/hour","Typical Wattage","kW",null,null,null,null,"EER (Energy Efficiency Ratio) ","but/hour","Typical Wattage","kW"]
["Home Air Conditioner",8,12000,{"$f":"C52/B52","v":1500},{"$f":"D52/Conversions!$C$7","v":1.5},null,null,"EER and Btu/hour","Home Air Conditioner",8,5000,{"$f":"K52/J52","v":625},{"$f":"L52/Conversions!$C$7","v":0.625}]

{"sheet":"Product Conversions","index":5,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Product Conversions"]
[]
[]
["Example Products","Material Type","shorthand description","Number of Units","Weight (lbs)","Weight (ton)","Unit Explanation/Notes",null,"check (MTCE/ton)"]
["<select product>","<select product>","units",1,"n/a",0]
["Aluminum drink can (12 fl. oz.)","Aluminum Cans","cans",1,{"$f":"'Material Mass Assumptions'!D5","v":2.8660100000000001E-2},{"$f":"E6/Conversions!$C$5","v":1.433005E-5},"per can",null,{"$f":"F6*'Energy Savings'!C8","v":-2.9655983952539796E-3}]
["Soup steel can (15.5 fl. oz.)","Steel Cans","cans",1,{"$f":"'Material Mass Assumptions'!D6","v":0.13},{"$f":"E7/Conversions!$C$5","v":6.5000000000000008E-5},"per tin ferrous can",null,{"$f":"F7*'Energy Savings'!$C$9","v":-1.3320840680999999E-3}]
["Metal coat hanger","Steel Cans","hangers",1,{"$f":"'Material Mass Assumptions'!D7","v":0.14000000000000001},{"$f":"E8/Conversions!$C$5","v":7.0000000000000007E-5},"per hanger (adult)",null,{"$f":"F8*'Energy Savings'!$C$9","v":-1.4345520733384616E-3}]
["Glass bottle (12 fl. oz.)","Glass","bottles",1,{"$f":"'Material Mass Assumptions'!D8","v":0.53},{"$f":"E9/Conversions!$C$5","v":2.6499999999999999E-4},"per bottle",null,{"$f":"F9*'Energy Savings'!$C$11","v":-7.0299460222031211E-4}]
["Glass wine bottle (0.75 liter) ","Glass","wine bottles",1,{"$f":"'Material Mass Assumptions'!D9","v":1.08},{"$f":"E10/Conversions!$C$5","v":5.4000000000000001E-4},"per bottle",null,{"$f":"F10*'Energy Savings'!$C$11","v":-1.4325173026376171E-3}]
["Gallon plastic milk jug","HDPE","jugs",1,{"$f":"'Material Mass Assumptions'!D10","v":0.20499999999999999},{"$f":"E11/Conversions!$C$5","v":1.025E-4},"per empty jug",null,{"$f":"F11*'Energy Savings'!$C$12","v":-5.2717213663135906E-3}]
["Gallon plastic detergent container","HDPE","containers",1,{"$f":"'Material Mass Assumptions'!D11","v":0.33},{"$f":"E12/Conversions!$C$5","v":1.65E-4},"per empty container",null,{"$f":"F12*'Energy Savings'!$C$12","v":-8.4861856140657794E-3}]
["Plastic grocery bag","HDPE","bags",1,{"$f":"'Material Mass Assumptions'!D12","v":7.7000000000000002E-3},{"$f":"E13/Conversions!$C$5","v":3.8500000000000004E-6},"per bag",null,{"$f":"F13*'Energy Savings'!$C$12","v":-1.9801099766153488E-4}]
["Plastic bottle (20 fl. oz.)","PET","bottles",1,{"$f":"'Material Mass Assumptions'!D13","v":5.1400000000000001E-2},{"$f":"E14/Conversions!$C$5","v":2.5700000000000001E-5},"per bottle",null,{"$f":"F14*'Energy Savings'!$C$14","v":-1.371335202839474E-3}]
["Plastic bottle (2 liter)","PET","bottles",1,{"$f":"'Material Mass Assumptions'!D14","v":0.13},{"$f":"E15/Conversions!$C$5","v":6.5000000000000008E-5},"per bottle",null,{"$f":"F15*'Energy Savings'!$C$14","v":-3.4683575169091757E-3}]
["2' x 2' x 2.5' cardbox, 3mm ","Corrugated Cardboard","boxes",1,{"$f":"'Material Mass Assumptions'!D15","v":2.2000000000000002},{"$f":"E16/Conversions!$C$5","v":1.1000000000000001E-3},"per box",null,{"$f":"F16*'Energy Savings'!$C$15","v":-1.7197020328049567E-2}]
["Weekly magazine","Magazines/Third-class Mail","magazines",1,{"$f":"'Material Mass Assumptions'!D16","v":0.3},{"$f":"E17/Conversions!$C$5","v":1.4999999999999999E-4},"per 8.5\" x 11\" magazine (10 magazines per year)",null,{"$f":"F17*'Energy Savings'!C16","v":-1.6306662906365502E-4}]
["Catalog","Magazines/Third-class Mail","catalogs",1,{"$f":"'Material Mass Assumptions'!D17","v":1},{"$f":"E18/Conversions!$C$5","v":5.0000000000000001E-4},"per catalog of 100 pages ledger",null,{"$f":"F18*'Energy Savings'!C17","v":-8.4512406899367783E-3}]
["Daily newspaper","Newspaper","newspapers",1,{"$f":"'Material Mass Assumptions'!D18","v":0.44440000000000002},{"$f":"E19/Conversions!$C$5","v":2.2220000000000001E-4},"per weekday edition of newspaper",null,{"$f":"F19*'Energy Savings'!$C$17","v":-3.7557313626079042E-3}]
["Sunday New York Times","Newspaper","newspapers",1,{"$f":"'Material Mass Assumptions'!D19","v":4.2},{"$f":"E20/Conversions!$C$5","v":2.1000000000000003E-3},"per Sunday edition of newspaper",null,{"$f":"F20*'Energy Savings'!$C$17","v":-3.5495210897734476E-2}]
["12-inch stack of newspaper","Newspaper","stacks",1,{"$f":"'Material Mass Assumptions'!D20","v":35},{"$f":"E21/Conversions!$C$5","v":1.7500000000000002E-2},"per 12\" stack",null,{"$f":"F21*'Energy Savings'!$C$17","v":-0.29579342414778725}]
["Printer paper, 1 ream (500 sheets)","Office Paper","reams",1,{"$f":"'Material Mass Assumptions'!D21","v":5},{"$f":"E22/Conversions!$C$5","v":2.5000000000000001E-3},"per 500 sheets of letter 8 1/2\" x 11\", ",null,{"$f":"F22*'Energy Savings'!$C$18","v":-2.5204066076889967E-2}]
["Sheet of printer paper","Office Paper","sheets",1,{"$f":"'Material Mass Assumptions'!D22","v":0.01},{"$f":"E23/Conversions!$C$5","v":5.0000000000000004E-6},"per 1 sheet of letter 8 1/2\" x 11\", ",null,{"$f":"F23*'Energy Savings'!$C$18","v":-5.040813215377994E-5}]
["White business envelope","Office Paper","envelopes",1,{"$f":"'Material Mass Assumptions'!D23","v":1.0999999999999999E-2},{"$f":"E24/Conversions!$C$5","v":5.4999999999999999E-6},"per No. 10 envelope (4 1/8\" x 9 1/2\") 24 bond paper",null,{"$f":"F24*'Energy Savings'!$C$18","v":-5.5448945369157931E-5}]
["Paperboard Cereal box","Broad Definition","cereal boxes",1,{"$f":"'Material Mass Assumptions'!D24","v":0.15},{"$f":"E25/Conversions!$C$5","v":7.4999999999999993E-5},"per average Chipboard, cereal box"]

{"sheet":"Energy Savings","index":6,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Energy Consumed/Avoided Compared to Landfilling"]
[null,null,"(Million Btu/ton)"]
["Category","Material"]
[null,"<select product>",2009,2015]
["Inorganics","Aluminum Cans",-206.9496195235871,-153.2918316983795]
[null,"Steel Cans",-20.493601047692305,-20.493601047692305]
[null,"Copper Wire",-83.117044210684924,-83.117044210684924]
[null,"Glass",-2.6528098196992911,-2.6528098196992911]
["Plastics","HDPE",-51.431427964035031,-50.884151157586118]
[null,"LDPE",-56.537734825918761]
[null,"PET",-53.359346413987311,-32.582088198384334]
["Paper and Wood","Corrugated Cardboard",-15.633654843681425,-15.581393307075897]
[null,"Magazines/Third-class mail",-1.0871108604243669,-0.90024590921782122]
[null,"Newspaper",-16.902481379873556,-16.718732614204075]
[null,"Office Paper",-10.081626430755987,-10.476723230484218]
[null,"Phonebooks",-11.835885090714511,-11.974886954607321]
[null,"Textbooks",-0.53034484997080433,-1.4228812971141385]
[null,"Dimensional Lumber",0.22171844221302117,0.54406110307557409]
[null,"Medium Density Fiberboard",0.49209140221302095,0.33794164141595406]
["Other Organics","Food Scraps",0.25830719200927815]
[null,"Yard Trimmings",0.16525011309141507]
[null,"Grass",0.15495582002882324]
[null,"Leaves ",0.13357548604715441]
[null,"Branches",0.21777724221302119]
["Mixed Materials","Mixed Paper "]
[null,"Broad Definition",-23.177438143962572,-20.596162635536327]
[null,"Residential Definition",-23.19204128392256,-20.604712963445998]
[null,"Office Paper Definition",-14.194339524131083,-21.044790200860412]
[null,"Mixed Metals",-74.841767868020384,-67.170206870458586]
[null,"Mixed Plastics",-53.205127531803853,-39.776692258208485]
[null,"Mixed Recyclables",-16.994326977854669,-15.160368648229714]
[null,"Mixed Organics",0.21019097350485261]
[null,"Mixed MSW",-0.26421924227649241]
[null,"Carpet",-106.10853042216,-22.098303648733289]
[null,"Personal Computers",-43.962290492756232,-29.77033133596019]
[null,"Clay Bricks","NA"]
[null,"Aggregate",-0.6342221156744825]
[null,"Fly Ash",-5.2940763130925008,-5.2940763130925008]
[null,"Tires",-52.490711162784038,-4.1984523983435205]

{"sheet":"Calculations","index":7,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,5,1,6]]}
[null,"Calculations"]
[null,null,null,null,null,"Energy Savings"]
[null,"Product Type","Material Type","Units","Total Weight (short tons)","Million Btu","Thousand Btu"]
[]
[null,"Aluminum drink can (12 fl. oz.)","Aluminum Cans",{"$f":"iWARM!F7","v":0},{"$f":"D5*'Product Conversions'!F6","v":0},{"$f":"-E5*(VLOOKUP(C5,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},{"$f":"F5*1000","v":0}]
[null,"Soup steel can (15.5 fl. oz.)","Steel Cans",{"$f":"iWARM!F8","v":0},{"$f":"D6*'Product Conversions'!F7","v":0},{"$f":"-E6*(VLOOKUP(C6,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},{"$f":"F6*1000","v":0}]
[null,"Metal coat hanger","Steel Cans",{"$f":"iWARM!F9","v":0},{"$f":"D7*'Product Conversions'!F8","v":0},{"$f":"-E7*(VLOOKUP(C7,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Glass bottle (12 fl. oz.)","Glass",{"$f":"iWARM!F10","v":0},{"$f":"D8*'Product Conversions'!F9","v":0},{"$f":"-E8*(VLOOKUP(C8,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Glass wine bottle (0.75 liter) ","Glass",{"$f":"iWARM!F11","v":0},{"$f":"D9*'Product Conversions'!F10","v":0},{"$f":"-E9*(VLOOKUP(C9,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Gallon plastic milk jug","HDPE",{"$f":"iWARM!F12","v":0},{"$f":"D10*'Product Conversions'!F11","v":0},{"$f":"-E10*(VLOOKUP(C10,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Gallon plastic detergent container","HDPE",{"$f":"iWARM!F13","v":0},{"$f":"D11*'Product Conversions'!F12","v":0},{"$f":"-E11*(VLOOKUP(C11,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Plastic grocery bag","HDPE",{"$f":"iWARM!F14","v":0},{"$f":"D12*'Product Conversions'!F13","v":0},{"$f":"-E12*(VLOOKUP(C12,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Plastic bottle (20 fl. oz.)","PET",{"$f":"iWARM!F15","v":0},{"$f":"D13*'Product Conversions'!F14","v":0},{"$f":"-E13*(VLOOKUP(C13,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Plastic bottle (2 liter)","PET",{"$f":"iWARM!F16","v":0},{"$f":"D14*'Product Conversions'!F15","v":0},{"$f":"-E14*(VLOOKUP(C14,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"2' x 2' x 2.5' cardbox, 3mm ","Corrugated Cardboard",{"$f":"iWARM!F17","v":0},{"$f":"D15*'Product Conversions'!F16","v":0},{"$f":"-E15*(VLOOKUP(C15,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Weekly magazine","Magazines/Third-class Mail",{"$f":"iWARM!F18","v":0},{"$f":"D16*'Product Conversions'!F17","v":0},{"$f":"-E16*(VLOOKUP(C16,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Catalog","Magazines/Third-class Mail",{"$f":"iWARM!F19","v":0},{"$f":"D17*'Product Conversions'!F18","v":0},{"$f":"-E17*(VLOOKUP(C17,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Daily newspaper","Newspaper",{"$f":"iWARM!F20","v":0},{"$f":"D18*'Product Conversions'!F19","v":0},{"$f":"-E18*(VLOOKUP(C18,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Sunday New York Times","Newspaper",{"$f":"iWARM!F21","v":0},{"$f":"D19*'Product Conversions'!F20","v":0},{"$f":"-E19*(VLOOKUP(C19,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"12-inch stack of newspaper","Newspaper",{"$f":"iWARM!F22","v":0},{"$f":"D20*'Product Conversions'!F21","v":0},{"$f":"-E20*(VLOOKUP(C20,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Printer paper, 1 ream (500 sheets)","Office Paper",{"$f":"iWARM!F23","v":0},{"$f":"D21*'Product Conversions'!F22","v":0},{"$f":"-E21*(VLOOKUP(C21,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Sheet of paper","Office Paper",{"$f":"iWARM!F24","v":0},{"$f":"D22*'Product Conversions'!F23","v":0},{"$f":"-E22*(VLOOKUP(C22,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"White business envelope","Office Paper",{"$f":"iWARM!F25","v":0},{"$f":"D23*'Product Conversions'!F24","v":0},{"$f":"-E23*(VLOOKUP(C23,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},0]
[null,"Paperboard Cereal box","Broad Definition",{"$f":"iWARM!F26","v":0},{"$f":"D24*'Product Conversions'!F25","v":0},{"$f":"-E24*(VLOOKUP(C24,'Energy Savings'!$B$7:$C$42,2,FALSE))","v":0},{"$f":"F24*1000","v":0}]

{"sheet":"Conversions","index":8,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[null,"Unit Conversions"]
[]
[null,"Conversions"]
[]
[null,"lbs/ton",2000]
[null,"metric ton/short ton",0.90718474000000004]
[null,"thousand Btu/MMBtu or W/kW",{"$f":"10^3","v":1000}]
[null,"but to Moto",{"$f":"1/1000000","v":9.9999999999999995E-7}]
[null,"joule/MJ or Btu/MMBtu",{"$f":"10^6","v":1000000}]
[null,"but/joule",{"$f":"1/1055.05585","v":9.4781712266701337E-4}]
[null,"thousand btu/btu",{"$f":"1/1000","v":1E-3}]
[null,"million bum",{"$f":"C13/C7","v":9.4781712266701337E-4}]
[null,"thousand bum",{"$f":"C9*C10*C11","v":0.94781712266701335}]
[null,"bum",{"$f":"C7*C13","v":947.81712266701334}]
[null,"Btu/kWh",3412]
[null,"MMBtu/kWh",{"$f":"C15/C9","v":3.4120000000000001E-3}]
[null,"kwh/MJ",{"$f":"C15/C14","v":3.5998505601999997}]
[null,"(No Suggestions)",{"$f":"1/C15","v":2.9308323563892143E-4}]
[null,"Btu/kWh output (US national average)",9578]
[null,"MMBtu/kWh output (US national average)",{"$f":"C19/C9","v":9.5779999999999997E-3}]
[null,"upstream electricity efficiency (US national grid)",{"$f":"C15/C19","v":0.35623303403633327}]
[null,"delivered electricity equivalent (MMBtu/kWh)",{"$f":"(C16/C21)/(1-C24)","v":1.0235924801156905E-2}]
[null,"delivered electricity equivalent (thousand Btu/kWh)",{"$f":"C22*1000","v":10.235924801156905}]
[null,"transmission and distribution losses",{"$f":"0.95/14.78","v":6.427604871447902E-2}]
[]
[]
[]
[]
[]
[null,"Tracing raw energy savings into delivered electricity equivalent"]