{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":112,"n_cols":7,"rows_kept":112,"cut":false,"hidden":false,"merged":[[67,0,67,4],[72,0,72,4],[77,0,77,4],[0,0,0,4]],"flags":["formulas_cached_only"]}
["Energy Calculation Worksheet"]
[]
["NOTE!  Go to file, save as, and save your file as JUNK, before you start filling in this worksheet."]
[]
["General Instructions:"]
[]
["1. For each category, estimate your typical usage in one day."]
["2. Fill in yellow boxes only, everything else is automatically calculated."]
["3. If the category is for something you do weekly, such as laundry, divide the weekly total by 7."]
["4. If the appliance is on all the time, like a refrigerator or clock, enter 24 hours used."]
["5. A pie chart of your energy use will automatically be generated."]
["6. This is not a contest, nor is it intended to be judgmental. Be honest in your answers!"]
[]
["Note to Instructors:"]
[]
["The energy requirements figures are based on 1999 models. Feel free to update these figures or add items."]
["For the home heating section, fill in your local price per therm in the formula in cells C71 and C76, and KWH in cell C81."]
["You can use the figures to calculate class averages, or usage before and during the project."]
["If students live in dorms and do not control their heat, you can calculate an estimate for the heat, or just use the 3 other categories."]
[]
["I.  Appliances","hours used","energy requirement","kilowatt-hours","BTU"]
[null,null,"(watts)"]
["dryer",0,5000,0,0]
["washing machine",0,375,0,0]
["oven",0,4000,0,0]
["stove",0,2000,0,0]
["dishwasher",0,1200,0,0]
["microwave oven",0,1450,0,0]
["coffee maker",0,750,0,0]
["TV",0,300,0,0]
["VCR",0,20,0,0]
["hair dryer",0,1875,0,0]
["refrigerator- full size",0,750,0,0]
["refrigerator - med. size",0,330,0,0]
["refrigerator - dorm size",0,300,0,0]
["lights - total*",0,75,0,0]
["fluorescent lights - total*",0,18,0,0]
["stereo",0,100,0,0]
["computer",0,300,0,0]
["clock",0,4,0,0]
["TOTAL",null,null,0,0]
[]
["*For lights, enter the combined total for all light bulbs. For example, 2 lights on for 3 hours each = 6 hours."]
[]
["II.  Automobile","miles driven","fuel economy","gal. of gasoline","BTU"]
[null,null,"(miles/gallon)"]
["type of car:",0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Look up the fuel economy for your car at:",null,"http://www.fueleconomy.gov/ "]
[]
[]
["III.  Hot Water","minutes/loads","gallons of hot water","BTU "]
["hot shower (minutes)",0,5,0]
["bath (each)",0,35,0]
["dishwasher (loads)",0,12,0]
["faucet (minutes)",0,3,0]
["washing machine (loads)",0,40,0]
["washing dishes (minutes)",0,3,0]
["TOTAL",null,null,0]
[]
[]
["IV.  Home heating"]
["To estimate your home heating, chose the option below that best matches your source of heat."]
["Fill in only one of the sections below."]
["This will only calculate properly if the sections above this are already filled in."]
[]
[]
["If you have gas heat and gas hot water"]
[null,"$","therms","BTU monthly ","BTU daily","% from","Net BTU"]
[{"$nulls":5},"heating"]
["monthly gas bill",null,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["If you have gas heat and electric hot water"]
[null,"$","therms","BTU monthly ","BTU daily","% from","Net BTU"]
[{"$nulls":5},"heating"]
["monthly gas bill",0,0,0,0,1,0]
[]
["If you have electric heat and electric hot water"]
[null,"$","KWH","BTU monthly ","BTU daily","% from","Net BTU"]
[{"$nulls":5},"heating"]
["monthly electric bill",0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["So your net BTU for home heating is:",null,{"$error":"#DIV/0!"}]
[]
[]
[]
[]
["V. Totals","BTU"]
["Appliances",0]
["Automobile",{"$error":"#DIV/0!"}]
["Hot Water",0]
["Home heating",{"$error":"#DIV/0!"}]
["Grand  total",{"$error":"#DIV/0!"}]
{"$rows_empty":12}
["Follow up questions:"]
[]
["What is your largest use of energy?"]
["For appliances, which one uses the most energy?"]
["What is your largest single use of energy in a typical day? (ie driving to school, working on computer)"]
["Is there anything about the numbers that surprises you?"]
["Based on your numbers, what are some ways that you could conserve energy?"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}