{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"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":"Sheet1","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[19,1,19,6],[0,0,1,2],[11,1,11,6],[12,1,12,6],[13,1,14,6],[15,1,16,6],[17,1,18,6]]}
["Start here by entering your electricity standng charge. Then tab down this column entering the other rates. Then go to page 2."]
[]
["Electricity Standing Charge:",10.96,"In a 31 day month this costs:",{"$f":"SUM(ESC*31/100)","v":3.3976000000000006},"inc. VAT:",{"$f":"SUM(D3+D3*VATR)","v":3.5674800000000007}]
["Gas Standing Charge:",27.4,"In a 31 day month this costs:",{"$f":"SUM(GSC*31/100)","v":8.4939999999999998},"inc. VAT:",{"$f":"SUM(D4+D4*VATR)","v":8.9186999999999994}]
[null,null,"Total cost of standing charges:",{"$f":"D4+D3","v":11.8916},"inc. VAT:",{"$f":"F3+F4","v":12.486180000000001}]
["Electricity Rate:",16.36]
["Gas Rate:",4.4269999999999996]
[]
["VAT Rate:",0.05]
[]
[]
[null,"Notes"]
[null,"1. The estimates on page 2 are of kWhours, not the difference in two gas readings."]
[null,"2. There are likely to be some rounding errors of a few pence. I suspect this might be the power companies."]
[]
[null,"3. The pages are protected to make it easy to tab, but there is no password so if you want to change anything just unprotect it."]
[]
[null,"4. I've calculated VAT seperately on Gas and Electricity which is how it's done by a few companies though I'm fairly sure that used to be illegal. "]

{"sheet":"Sheet2","index":1,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,9,0]]}
[" Use the spin controls to adjust your gas and electricity kWh usage for each month (or just enter the amounts in the boxes), in rows 20 and 25 below, then scroll down to see the costs with the year's totals on the right, and a chart of the costs."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Totals"]
["Gas kWh:",850,850,850,750,700,500,400,450,500,650,750,850,{"$f":"SUM(B20:M20)","v":8100}]
[]
[]
[]
["Electricity kWh:",140,140,140,125,120,120,120,120,125,140,140,140,{"$f":"SUM(B24:M24)","v":1570}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Year's Costs"]
["Standing Charges inc. VAT:",{"$f":"(GSC+ESC)*31/100+((GSC+ESC)*31/100)*VATR","v":12.486180000000001},{"$f":"(GSC+ESC)*28/100+((GSC+ESC)*28/100)*VATR","v":11.277839999999999},{"$f":"(GSC+ESC)*31/100+((GSC+ESC)*31/100)*VATR","v":12.486180000000001},{"$f":"(GSC+ESC)*30/100+((GSC+ESC)*30/100)*VATR","v":12.083399999999999},{"$f":"(GSC+ESC)*31/100+((GSC+ESC)*31/100)*VATR","v":12.486180000000001},{"$f":"(GSC+ESC)*30/100+((GSC+ESC)*30/100)*VATR","v":12.083399999999999},{"$f":"(GSC+ESC)*31/100+((GSC+ESC)*31/100)*VATR","v":12.486180000000001},{"$f":"(GSC+ESC)*31/100+((GSC+ESC)*31/100)*VATR","v":12.486180000000001},{"$f":"(GSC+ESC)*30/100+((GSC+ESC)*30/100)*VATR","v":12.083399999999999},{"$f":"(GSC+ESC)*31/100+((GSC+ESC)*31/100)*VATR","v":12.486180000000001},{"$f":"(GSC+ESC)*30/100+((GSC+ESC)*30/100)*VATR","v":12.083399999999999},{"$f":"(GSC+ESC)*31/100+((GSC+ESC)*31/100)*VATR","v":12.486180000000001},{"$f":"SUM(B29:M29)","v":147.0147}]
["Gas inc. SC and VAT:",{"$f":"B20*GR/100+GSC*0.31+(B20*GR/100+GSC*0.31)*VATR","v":48.429675000000003},{"$f":"C20*GR/100+GSC*0.28+(C20*GR/100+GSC*0.28)*VATR","v":47.566575000000007},{"$f":"D20*GR/100+GSC*0.31+(D20*GR/100+GSC*0.31)*VATR","v":48.429675000000003},{"$f":"E20*GR/100+GSC*0.3+(E20*GR/100+GSC*0.3)*VATR","v":43.493624999999994},{"$f":"F20*GR/100+GSC*0.31+(F20*GR/100+GSC*0.31)*VATR","v":41.457149999999999},{"$f":"G20*GR/100+GSC*0.3+(G20*GR/100+GSC*0.3)*VATR","v":31.87275},{"$f":"H20*GR/100+GSC*0.31+(H20*GR/100+GSC*0.31)*VATR","v":27.512099999999997},{"$f":"I20*GR/100+GSC*0.31+(I20*GR/100+GSC*0.31)*VATR","v":29.836274999999997},{"$f":"J20*GR/100+GSC*0.3+(J20*GR/100+GSC*0.3)*VATR","v":31.87275},{"$f":"K20*GR/100+GSC*0.31+(K20*GR/100+GSC*0.31)*VATR","v":39.132974999999995},{"$f":"L20*GR/100+GSC*0.3+(L20*GR/100+GSC*0.3)*VATR","v":43.493624999999994},{"$f":"M20*GR/100+GSC*0.31+(M20*GR/100+GSC*0.31)*VATR","v":48.429675000000003},{"$f":"SUM(B30:M30)","v":481.52684999999997}]
["Electricity inc. SC and VAT:",{"$f":"B24*ER/100+ESC*0.31+(B24*ER/100+ESC*0.31)*VATR","v":27.616680000000002},{"$f":"C24*ER/100+ESC*0.28+(C24*ER/100+ESC*0.28)*VATR","v":27.271439999999998},{"$f":"D24*ER/100+ESC*0.31+(D24*ER/100+ESC*0.31)*VATR","v":27.616680000000002},{"$f":"E24*ER/100+ESC*0.3+(E24*ER/100+ESC*0.3)*VATR","v":24.924900000000001},{"$f":"F24*ER/100+ESC*0.31+(F24*ER/100+ESC*0.31)*VATR","v":24.181079999999998},{"$f":"G24*ER/100+ESC*0.3+(G24*ER/100+ESC*0.3)*VATR","v":24.065999999999999},{"$f":"H24*ER/100+ESC*0.31+(H24*ER/100+ESC*0.31)*VATR","v":24.181079999999998},{"$f":"I24*ER/100+ESC*0.31+(I24*ER/100+ESC*0.31)*VATR","v":24.181079999999998},{"$f":"J24*ER/100+ESC*0.3+(J24*ER/100+ESC*0.3)*VATR","v":24.924900000000001},{"$f":"K24*ER/100+ESC*0.31+(K24*ER/100+ESC*0.31)*VATR","v":27.616680000000002},{"$f":"L24*ER/100+ESC*0.3+(L24*ER/100+ESC*0.3)*VATR","v":27.5016},{"$f":"M24*ER/100+ESC*0.31+(M24*ER/100+ESC*0.31)*VATR","v":27.616680000000002},{"$f":"SUM(B31:M31)","v":311.69880000000001}]
["Total inc. SC and VAT:",{"$f":"B20*GR/100+B24*ER/100+(GSC+ESC)*0.31+(B20*GR/100+B24*ER/100+(GSC+ESC)*0.31)*VATR","v":76.046355000000005},{"$f":"C20*GR/100+C24*ER/100+(GSC+ESC)*0.28+(C20*GR/100+C24*ER/100+(GSC+ESC)*0.28)*VATR","v":74.838015000000013},{"$f":"D20*GR/100+D24*ER/100+(GSC+ESC)*0.31+(D20*GR/100+D24*ER/100+(GSC+ESC)*0.31)*VATR","v":76.046355000000005},{"$f":"E20*GR/100+E24*ER/100+(GSC+ESC)*0.3+(E20*GR/100+E24*ER/100+(GSC+ESC)*0.3)*VATR","v":68.418524999999988},{"$f":"F20*GR/100+F24*ER/100+(GSC+ESC)*0.31+(F20*GR/100+F24*ER/100+(GSC+ESC)*0.31)*VATR","v":65.638229999999993},{"$f":"G20*GR/100+G24*ER/100+(GSC+ESC)*0.3+(G20*GR/100+G24*ER/100+(GSC+ESC)*0.3)*VATR","v":55.938749999999992},{"$f":"H20*GR/100+H24*ER/100+(GSC+ESC)*0.31+(H20*GR/100+H24*ER/100+(GSC+ESC)*0.31)*VATR","v":51.693179999999998},{"$f":"I20*GR/100+I24*ER/100+(GSC+ESC)*0.31+(I20*GR/100+I24*ER/100+(GSC+ESC)*0.31)*VATR","v":54.017354999999995},{"$f":"J20*GR/100+J24*ER/100+(GSC+ESC)*0.3+(J20*GR/100+J24*ER/100+(GSC+ESC)*0.3)*VATR","v":56.797650000000004},{"$f":"K20*GR/100+K24*ER/100+(GSC+ESC)*0.31+(K20*GR/100+K24*ER/100+(GSC+ESC)*0.31)*VATR","v":66.749655000000004},{"$f":"L20*GR/100+L24*ER/100+(GSC+ESC)*0.3+(L20*GR/100+L24*ER/100+(GSC+ESC)*0.3)*VATR","v":70.995224999999991},{"$f":"M20*GR/100+M24*ER/100+(GSC+ESC)*0.31+(M20*GR/100+M24*ER/100+(GSC+ESC)*0.31)*VATR","v":76.046355000000005},{"$f":"SUM(B32:M32)","v":793.22564999999986}]