{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["electricity consumption"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"electricity consumption","index":0,"n_rows":34,"n_cols":13,"rows_kept":34,"merged":[[0,0,0,12],[2,0,2,9],[3,0,3,9],[6,1,6,7],[6,8,6,12]]}
["Personal Energy Meter"]
[]
["How much energy are you using? Use your home energy use survey to calculate how much energy you personally use. Only enter appliances (Maximum of 23 appliances) that you personally use (or that are used for your benefit, i.e. washing machine, stove, etc.) "]
["*Energy cost based on total kWh (kilowatt-hours) X cost per kWh. Use default electric cost of $0.15/kWh or enter another value:",{"$nulls":10},0.17]
[]
["Column:   A","B","C","D","E","F","G","H","I","J","K","L","M"]
[null,"Energy Tracker (Hours/Day)",{"$nulls":6},"Cost Calculator"]
["Appliance","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Total Hours","Wattage","Total Wh","Total kWh","Energy Cost*"]
[{"$nulls":8},{"$f":"SUM(B9:H9)","v":{"v":0,"d":"0.00"}},null,{"$f":"PRODUCT(I9,J9)","v":{"v":0,"d":"0.00"}},{"$f":"PRODUCT(I9,J9)/1000","v":{"v":0,"d":"0.00"}},{"$f":"PRODUCT(L4,L9)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"$f":"SUM(B10:H10)","v":{"v":0,"d":"0.00"}},null,{"$f":"PRODUCT(I10,J10)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L10)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L11)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L12)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L13)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L14)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L15)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L16)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L17)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L18)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L19)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L20)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L21)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L22)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L23)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L24)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L25)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L26)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L27)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L28)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L29)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L30)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"PRODUCT(L4,L31)","v":{"v":0,"d":"$0.00"}}]
["Total for Week:",{"$nulls":10},{"$f":"SUM(L9:L31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M9:M31)","v":{"v":0,"d":"$0.00"}}]
["Monthly Total",{"$nulls":11},{"$f":"M32*4","v":{"v":0,"d":"$0.00"}}]
["Annual Total",{"$nulls":11},{"$f":"M32*52","v":{"v":0,"d":"$0.00"}}]