{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Calculations","Definitions","Instructions"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Calculations","index":0,"n_rows":10,"n_cols":19,"rows_kept":10,"flags":["formulas_cached_only"]}
[]
["End Date","Late reading","kWh used","Price $/kWh","Feedback kWh","Feedback $/kWh","Value $","Inverter Reading kWh","Solar produced kWh","Solar used","Solar saving $","Total saving $","Total kWh Used","Battery Saving $",{"$nulls":4},"Notes"]
["2022-10-14",6,{"v":301.98,"d":"302.0"},0.2733,{"v":82.81,"d":"82.8"},{"v":0.052000000000000005,"d":"0.052"},{"v":4.31,"d":"$4.31"},7202,0,"(Initial readings)"]
["2022-11-14",9,266.7,{"v":0.21461000000000002,"d":"0.2146"},88.4,{"v":0.052000000000000005,"d":"0.052"},{"v":4.6,"d":"$4.60"},7433,231,142.6,{"v":49.57491,"d":"$49.57"},{"v":54.174910000000004,"d":"$54.17"},{"v":409.29999999999995,"d":"409.30"},{"v":11.499779200000004,"d":"11.50"}]
["2022-12-14",9,250.3,{"v":0.21461000000000002,"d":"0.2146"},{"v":121.05,"d":"121.1"},{"v":0.052000000000000005,"d":"0.052"},{"v":6.29,"d":"$6.29"},7678,245,123.95,{"v":52.57945000000001,"d":"$52.58"},{"v":58.86945000000001,"d":"$58.87"},374.25,{"v":15.747152400000004,"d":"15.75"}]
["2023-01-14",12,259.6,{"v":0.21610000000000001,"d":"0.2161"},142.7,{"v":0.052000000000000005,"d":"0.052"},{"v":7.42,"d":"$7.42"},7975,297,154.3,{"v":64.1817,"d":"$64.18"},{"v":71.60170000000001,"d":"$71.60"},{"v":413.90000000000003,"d":"413.90"},{"v":18.733656000000003,"d":"18.73"}]
["2023-02-14",10,226.4,0.2146,112.1,{"v":0.052000000000000005,"d":"0.052"},{"v":5.83,"d":"$5.83"},8170,195,82.9,{"v":41.847,"d":"$41.85"},{"v":47.677,"d":"$47.68"},{"v":309.3,"d":"309.30"},{"v":14.581968000000003,"d":"14.58"},{"$nulls":4},"Paidlate Price rise Mid"]
[{"$nulls":8},-8170,-8170,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":-8170,"d":"-8170.00"},{"v":0,"d":"0.00"}]
[{"$nulls":8},0,0,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":8},0,0,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]

{"sheet":"Definitions","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"flags":["formulas_cached_only"]}
["Á","End Date ","Day of last reading from bill"]
["B","Days Late ","Number of days inverter reading after Á"]
["C","kWh used","Taken from bill"]
["D","Price","Price of electricity from bill"]
["E","Feedback","kWh feedback from bill"]
["F","Feedback $/kWh","$/kWh paid for electricity sold to the grid"]
["G","Value","$ paid for feedback"]
["H","Inverter Reading","kWh the inverter has produced since installed "]
["I","Solar Produced ","kWh produced for the billing period from solar"]
["J","Solar saving","Valve of the kWh that you did not have to buy"]
["K","Total Solar Saving","J + feedback value"]
["L","Total kWh used","Total kWh used from the grid and solar"]
["M"," Battery Saving","Extra Saving if battery was installed 80% for power in and out of battery"]

{"sheet":"Instructions","index":2,"n_rows":5,"n_cols":1,"rows_kept":5,"flags":["formulas_cached_only"]}
["These are my figures."]
["Over write the numbers in black with your numbers."]
["The blue numbers are calculated valves. ( have not protected them)"]
["When you run out of blue copy and paste them into the required rows"]
["Ignore the row not yet with numbers in them"]