{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Power Audit - Typical Values","Power Audit - No Values"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Power Audit - Typical Values","index":0,"n_rows":27,"n_cols":16,"rows_kept":27}
[null,12,"Volt System / Devices",{"$nulls":6},120,"Volt System / Devices"]
["Include","Device","Amps","Watts","Duration","Frequency","Watt/Hrs",null,"Include","Device","Amps","Watts","Duration","Frequency","Watt/Hrs"]
[1,"Aisle lights",{"v":0.5,"d":"0.50"},{"$f":"+$B$1*C3","v":{"v":6,"d":"6.00"}},{"v":4,"d":"4.00"},{"v":1,"d":"1.0"},{"$f":"+F3*E3*D3*A3","v":{"v":24,"d":"24.00"}},null,1,"20\" box fan",{"$f":"+L3/$J$1","v":{"v":0.4583333333333333,"d":"0.46"}},{"v":55,"d":"55.00"},{"v":1,"d":"1.00"},{"v":2,"d":"2.0"},{"$f":"+N3*M3*L3*I3","v":{"v":110,"d":"110.00"}}]
[1,"Baggage compartment",{"v":0.5,"d":"0.50"},{"v":6,"d":"6.00"},0.25,{"v":1,"d":"1.0"},{"v":1.5,"d":"1.50"},null,1,"40\" HD LED TV",{"v":0.7166666666666667,"d":"0.72"},{"v":86,"d":"86.00"},{"v":4,"d":"4.00"},{"v":1,"d":"1.0"},{"v":344,"d":"344.00"}]
[1,"Decorative wall lights",{"v":3,"d":"3.00"},{"v":36,"d":"36.00"},{"v":4,"d":"4.00"},{"v":1,"d":"1.0"},{"v":144,"d":"144.00"},null,1,"40\" HD LED TV (standby)",{"v":0.008333333333333333,"d":"0.01"},{"v":1,"d":"1.00"},{"v":20,"d":"20.00"},{"v":1,"d":"1.0"},{"v":20,"d":"20.00"}]
[1,"Dinette light",{"v":4.5,"d":"4.50"},{"v":54,"d":"54.00"},{"v":2,"d":"2.00"},{"v":1,"d":"1.0"},{"v":108,"d":"108.00"},null,0,"55\" 4K LED TV",{"v":1.3333333333333333,"d":"1.33"},{"v":160,"d":"160.00"},{"v":4,"d":"4.00"},{"v":1,"d":"1.0"},{"v":0,"d":"0.00"}]
[1,"Fantastic fan",{"v":1.5,"d":"1.50"},{"v":18,"d":"18.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.0"},{"v":72,"d":"72.00"},null,0,"55\" 4K LED TV (standby)",{"v":0.016666666666666666,"d":"0.02"},{"v":2,"d":"2.00"},{"v":20,"d":"20.00"},{"v":1,"d":"1.0"},{"v":0,"d":"0.00"}]
[1,"Furnace",{"v":12,"d":"12.00"},{"v":144,"d":"144.00"},{"v":0.1,"d":"0.10"},{"v":12,"d":"12.0"},{"v":172.8,"d":"172.80"},null,1,"Blender ",{"v":7.5,"d":"7.50"},{"v":900,"d":"900.00"},{"v":0.2,"d":"0.20"},{"v":1,"d":"1.0"},{"v":180,"d":"180.00"}]
[1,"Generator start",{"v":95,"d":"95.00"},{"v":1140,"d":"1140.00"},0.01,{"v":2,"d":"2.0"},{"v":22.8,"d":"22.80"},null,1,"Coffee Pot",{"v":10,"d":"10.00"},{"v":1200,"d":"1200.00"},{"v":0.5,"d":"0.50"},{"v":1,"d":"1.0"},{"v":600,"d":"600.00"}]
[1,"Levelling system*",{"v":95,"d":"95.00"},{"v":1140,"d":"1140.00"},{"v":0.1,"d":"0.10"},{"v":0.6666666666666666,"d":"0.7"},{"v":76,"d":"76.00"},null,1,"Hair Dryer",{"v":12.5,"d":"12.50"},{"v":1500,"d":"1500.00"},{"v":0.2,"d":"0.20"},{"v":1,"d":"1.0"},{"v":300,"d":"300.00"}]
[1,"LP detector",{"v":0.2,"d":"0.20"},{"v":2.4000000000000004,"d":"2.40"},{"v":24,"d":"24.00"},{"v":1,"d":"1.0"},{"v":57.60000000000001,"d":"57.60"},null,1,"Ice Maker",1.25,{"v":150,"d":"150.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.0"},{"v":150,"d":"150.00"}]
[1,"Map light",{"v":1.5,"d":"1.50"},{"v":18,"d":"18.00"},{"v":0.2,"d":"0.20"},{"v":2,"d":"2.0"},{"v":7.2,"d":"7.20"},null,1,"Instant Pot (6qt)*",{"v":8.333333333333334,"d":"8.33"},{"v":1000,"d":"1000.00"},{"v":1,"d":"1.00"},{"v":0.333333,"d":"0.3"},{"v":333.33299999999997,"d":"333.33"}]
[1,"Porch light",{"v":1.5,"d":"1.50"},{"v":18,"d":"18.00"},{"v":4,"d":"4.00"},{"v":1,"d":"1.0"},{"v":72,"d":"72.00"},null,1,"Juicer",{"v":7.5,"d":"7.50"},{"v":900,"d":"900.00"},{"v":0.2,"d":"0.20"},{"v":1,"d":"1.0"},{"v":180,"d":"180.00"}]
[1,"Power awning",{"v":10,"d":"10.00"},{"v":120,"d":"120.00"},{"v":0.1,"d":"0.10"},{"v":2,"d":"2.0"},{"v":24,"d":"24.00"},null,1,"Kettle",{"v":12.5,"d":"12.50"},{"v":1500,"d":"1500.00"},{"v":0.3,"d":"0.30"},{"v":1,"d":"1.0"},{"v":450,"d":"450.00"}]
[1,"Refrigerator (on propane)",{"v":3,"d":"3.00"},{"v":36,"d":"36.00"},{"v":24,"d":"24.00"},{"v":1,"d":"1.0"},{"v":864,"d":"864.00"},null,1,"Microwave",{"v":11.666666666666666,"d":"11.67"},{"v":1400,"d":"1400.00"},{"v":0.3,"d":"0.30"},{"v":2,"d":"2.0"},{"v":840,"d":"840.00"}]
[1,"Phone charger",{"v":3,"d":"3.00"},{"v":36,"d":"36.00"},{"v":2,"d":"2.00"},{"v":1,"d":"1.0"},{"v":72,"d":"72.00"},null,0,"Refrigerator (on AC)",{"v":5.083333333333333,"d":"5.08"},{"v":610,"d":"610.00"},{"v":24,"d":"24.00"},{"v":1,"d":"1.0"},{"v":0,"d":"0.00"}]
[1,"Antenna booster",{"v":1,"d":"1.00"},0.12,{"v":24,"d":"24.00"},{"v":1,"d":"1.0"},2.88,null,1,"Toaster Oven",{"v":12.5,"d":"12.50"},{"v":1500,"d":"1500.00"},{"v":0.2,"d":"0.20"},{"v":2,"d":"2.0"},{"v":600,"d":"600.00"}]
[1,"Vanity light",{"v":0.5,"d":"0.50"},{"$f":"+$B$1*C18","v":{"v":6,"d":"6.00"}},{"v":2,"d":"2.00"},{"v":1,"d":"1.0"},{"v":12,"d":"12.00"},null,1,"Tool Chargers**",{"v":0.4166666666666667,"d":"0.42"},{"v":50,"d":"50.00"},{"v":4,"d":"4.00"},{"v":0.25,"d":"0.3"},{"v":50,"d":"50.00"}]
[3,"Slides (each)*",{"v":25,"d":"25.00"},{"v":300,"d":"300.00"},{"v":0.1,"d":"0.10"},{"v":0.6666666666666666,"d":"0.7"},{"v":60,"d":"60.00"},null,1,"Vacuum*",{"v":9.583333333333334,"d":"9.58"},{"v":1150,"d":"1150.00"},0.25,{"v":0.333333,"d":"0.3"},{"v":95.8332375,"d":"95.83"}]
[1,"Water heater",{"v":6,"d":"6.00"},{"v":72,"d":"72.00"},{"v":4,"d":"4.00"},0.2,{"v":57.6,"d":"57.60"},null,0,"CPAP",{"v":0.5,"d":"0.50"},{"$f":"+K20*J1","v":{"v":60,"d":"60.00"}},{"v":8,"d":"8.00"},{"v":1,"d":"1.0"},{"v":0,"d":"0.00"}]
[1,"Water pump",{"v":7,"d":"7.00"},{"v":84,"d":"84.00"},0.05,{"v":12,"d":"12.0"},{"v":50.400000000000006,"d":"50.40"},null,1,"Item",{"$f":"+L21/$J$1","v":{"v":1,"d":"1.00"}},{"v":120,"d":"120.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"}]
[1,"CPAP",{"v":5,"d":"5.00"},{"v":60,"d":"60.00"},{"v":8,"d":"8.00"},{"v":1,"d":"1.0"},{"v":480,"d":"480.00"},null,1,"Item",{"$f":"+L22/$J$1","v":{"v":1,"d":"1.00"}},{"v":120,"d":"120.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"}]
[1,"Item",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"}]
[{"$nulls":13},"Total",{"$f":"SUM(O3:O22)","v":{"v":4253.1662375000005,"d":"4253.2"}},"watts"]
[{"$nulls":5},"Total",{"$f":"SUM(G3:G23)","v":{"v":2380.78,"d":"2380.8"}},"watts"]
[null,"*Based upon moving once every 3 days",{"$nulls":7},"*Based upon using every 3 days"]
[{"$nulls":9},"**Based upon using every 4 days"]

{"sheet":"Power Audit - No Values","index":1,"n_rows":44,"n_cols":16,"rows_kept":44,"merged":[[34,5,34,6],[34,7,34,8],[35,5,35,6],[35,7,35,8],[36,5,36,6],[37,7,37,8],[41,4,41,5]]}
[null,12,"Volt System / Devices",{"$nulls":6},120,"Volt System / Devices"]
["Include","Device","Amps","Watts","Duration","Frequency","Watt/Hrs",null,"Include","Device","Amps","Watts","Duration","Frequency","Watt/Hrs"]
[1,"Aisle light  LED",{"$nulls":4},{"$f":"+F3*E3*D3*A3","v":{"v":0,"d":"0.00"}},null,1,"20\" box fan",{"$nulls":4},{"$f":"+N3*M3*L3*I3","v":{"v":0,"d":"0.00"}}]
[1,"Baggage compartment",{"$nulls":4},{"v":0,"d":"0.00"},null,1,"40\" HD LED TV",{"$nulls":4},{"v":0,"d":"0.00"}]
[4,"Decorative wall lights",{"$nulls":4},{"v":0,"d":"0.00"},null,0,"40\" HD LED TV (standby)",{"$nulls":4},{"v":0,"d":"0.00"}]
[2,"Dinette light",{"$nulls":4},{"v":0,"d":"0.00"},null,1,"55\" 4K LED TV",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"Fantastic fan",{"$nulls":4},{"v":0,"d":"0.00"},null,1,"55\" 4K LED TV (standby)",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"Furnace",{"$nulls":4},{"v":0,"d":"0.00"},null,1,"Blender ",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"Range Hood Fan / light",{"$nulls":4},{"v":0,"d":"0.00"},null,1,"Coffee Pot",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"A Frame tongue jack *",{"$nulls":4},{"v":0,"d":"0.00"},null,1,"Hair Dryer",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"LP detector",{"$nulls":4},{"v":0,"d":"0.00"},null,1,"Ice Maker",{"$nulls":4},{"v":0,"d":"0.00"}]
[2,"Reading Lights",{"$nulls":4},{"v":0,"d":"0.00"},null,1,"Instant Pot (6qt)*",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"Porch light",{"$nulls":4},{"v":0,"d":"0.00"},null,1,"Juicer",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"Power Awning *",{"$nulls":4},{"v":0,"d":"0.00"},null,0,"Kettle",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"Refrigerator (on propane)",{"$nulls":4},{"v":0,"d":"0.00"},null,1,"Microwave",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"Phone charger",{"$nulls":4},{"v":0,"d":"0.00"},null,0,"Refrigerator (on AC)",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"Radio",{"$nulls":4},{"v":0,"d":"0.00"},null,0,"Toaster",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"Bathroom light",{"$nulls":4},{"v":0,"d":"0.00"},null,1,"Tool Chargers**",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"Slides (each)*",{"$nulls":4},{"v":0,"d":"0.00"},null,1,"Vacuum/ Battery Charge",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"Disc player",{"$nulls":4},{"v":0,"d":"0.00"},null,0,"Space Heater",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"Water pump",{"$nulls":4},{"v":0,"d":"0.00"},null,0,"Hot water Heater",{"$nulls":4},{"v":0,"d":"0.00"}]
[1,"Lap Top",{"$nulls":4},{"v":0,"d":"0.00"},null,1,"Item",{"$nulls":4},{"v":0,"d":"0.00"}]
[null," "," "," "," "," "," ",null,1,"Item",{"$nulls":4},{"v":0,"d":"0.00"}]
[]
[{"$nulls":5},"Total",{"$f":"SUM(G3:G24)","v":{"v":0,"d":"0.0"}},"watts",{"$nulls":5},"Total",{"$f":"SUM(O3:O22)","v":0},"watts"]
[null,"*Based upon moving once every 3 days",{"$nulls":7},"*Based upon using every 3 days"]
[{"$nulls":9},"**Based upon using every 4 days"]
[]
[]
[{"$nulls":3},"To determine any other value - use the PIE formula:",{"$nulls":3},"As long as you know two of the values, ",{"$nulls":3},12.8,100,{"$f":"+M30*L30","v":1280}]
[{"$nulls":4},"Power (in watts) =",null,"I * E","you can calculate theother",null,null,"Batteries",null,null,{"$f":"+(O25+G25)/N30","v":0}]
[{"$nulls":4},"Current (in amps) =",null,"P/E",{"$nulls":4},"Qty","Watts","Hours","Watt/Hrs."]
[{"$nulls":4},"Voltage (in volts) =",null,"P/I",{"$nulls":3},"Panels",4,210,5,{"$f":"+N33*M33*L33*0.75","v":3150}]
[]
[{"$nulls":4},"eg:","Power",null,"Current",null,"Voltage",{"$nulls":4},{"$f":"+O25+G25","v":{"v":0,"d":"0.0"}}]
[{"$nulls":5},"100 watts",null,"20 amps",null,"= 100/20 or 5 volts"]
[{"$nulls":5},"36 watts",null,"= 36/12 = 3 amps",null,"12 vollts"]
[{"$nulls":5},"= 12*5 or 60 watts",null,"5 amps",null,"12 volts"]
[]
[]
[{"$nulls":4},"Energy Calculator"]
[{"$nulls":4},"To determine power",null,12,5,null,{"$f":"+H42*G42","v":60},"Watts"]
[{"$nulls":4},"To determine current",null,120,12,null,{"$f":"G43/H43","v":10},"Amps"]
[{"$nulls":4},"To determine voltage",null,120,5,null,{"$f":"G44/H44","v":24},"Volts"]