{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":33,"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":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,15],[29,6,29,15],[3,1,3,3],[3,5,3,7],[3,9,3,11],[3,13,3,15],[22,6,24,15],[25,6,26,15],[27,6,28,15],[20,6,21,15]]}
[]
[null,"Enter tariffs here then go to page 2."]
[]
[null,"Tariff A",null,null,null,"Tariff B",null,null,null,"Tariff C",null,null,null,"Tariff D"]
[]
[null,"Electricity Standing Charge:",10.96,null,null,"ESC:",15,null,null,"ESC:",12.96,null,null,"ESC:",13.96]
[null,"Gas Standing Charge:",27.4,null,null,"GSC:",27.4,null,null,"GSC:",27.4,null,null,"GSC:",27.4]
[]
[null,"Electricity Rate:",16.36,null,null,"ER:",16.36,null,null,"ER:",16.36,null,null,"ER:",16.36]
[null,"Gas Rate:",4.4269999999999996,null,null,"GR:",4.4269999999999996,null,null,"GR:",4.4269999999999996,null,null,"GR:",4.4269999999999996]
[]
[null,"Calorific Value:",39.799999999999997,null,null,"CV:",39.799999999999997,null,null,"CV:",39.799999999999997,null,null,"CV:",39.799999999999997]
[null,"Correction Factor:",1.02264,null,null,"CF:",1.02264,null,null,"CF:",1.02264,null,null,"CF:",1.02264]
[null,"kWh conversion factor:",3.6,null,null,"kCF:",3.6,null,null,"kCF:",3.6,null,null,"kCF:",3.6]
[null,"CVxCF/kWhCF = GKWHC",{"$f":"CVA*CFA/KCFA","v":11.305853333333332},null,null,"GKWHC",{"$f":"CVB*CFB/KCFB","v":11.305853333333332},null,null,"GKWHC",{"$f":"CVC*CFC/KCFC","v":11.305853333333332},null,null,"GKWHC",{"$f":"CVD*CFD/KCFD","v":11.305853333333332}]
[]
[]
[]
[null,"VAT Rate:",0.05,null,null,null,"Notes"]
[]
[null,null,null,null,null,null,"1. If you enter your current tariff in, say, Tariff A, you can then get estimates for your monthly bills and compare them with other tariffs."]
[]
[null,null,null,null,null,null,"2. Compared to an actual bill there are likely to be some rounding errors of a few pence. I might be wrong but I think this is due to rounding errors by the power companies."]
[]
[]
[null,null,null,null,null,null,"3. The pages are protected, but there is no password so if you want to change anything just unprotect it."]
[]
[null,null,null,null,null,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":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[[44,0,44,2],[32,0,32,2],[36,0,36,2],[40,0,40,2],[28,0,30,2],[27,0,27,2],[0,0,16,0],[23,0,23,2],[22,0,22,2],[24,0,26,2]]}
[" Use the spin controls to adjust your estimates of gas and electricity usage for each month (or just enter the amounts in the boxes), in rows 24 and 28 below. The chart will change and you can scroll down to see the costs with the year's totals on the right."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Totals"]
["Gas kWh Estimates :",null,null,900,900,900,900,900,900,900,900,900,900,900,900,{"$f":"SUM(D24:O24)","v":10800}]
[]
[]
[]
["Electricity kWh Estimates:",null,null,150,150,150,150,150,150,150,150,150,150,150,150,{"$f":"SUM(D28:O28)","v":1800}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year's Cost"]
["Tariff A inc. SC and VAT:",null,null,{"$f":"D$24*GRA/100+D$28*ERA/100+(GSCA+ESCA)*0.31+(D$24*GRA/100+D$28*ERA/100+(GSCA+ESCA)*0.31)*VATRate","v":80.088329999999985},{"$f":"E$24*GRA/100+E$28*ERA/100+(GSCA+ESCA)*0.28+(E$24*GRA/100+E$28*ERA/100+(GSCA+ESCA)*0.28)*VATRate","v":78.879989999999992},80.088329999999985,{"$f":"G$24*GRA/100+G$28*ERA/100+(GSCA+ESCA)*0.3+(G$24*GRA/100+G$28*ERA/100+(GSCA+ESCA)*0.3)*VATRate","v":79.685549999999992},80.088329999999985,{"$f":"I$24*GRA/100+I$28*ERA/100+(GSCA+ESCA)*0.3+(I$24*GRA/100+I$28*ERA/100+(GSCA+ESCA)*0.3)*VATRate","v":79.685549999999992},80.088329999999985,80.088329999999985,{"$f":"L$24*GRA/100+L$28*ERA/100+(GSCA+ESCA)*0.3+(L$24*GRA/100+L$28*ERA/100+(GSCA+ESCA)*0.3)*VATRate","v":79.685549999999992},80.088329999999985,{"$f":"N$24*GRA/100+N$28*ERA/100+(GSCA+ESCA)*0.3+(N$24*GRA/100+N$28*ERA/100+(GSCA+ESCA)*0.3)*VATRate","v":79.685549999999992},80.088329999999985,{"$f":"SUM(D33:O33)","v":958.24049999999988}]
["Tariff A Gas:",null,null,{"$f":"D$24*GRA/100+GSCA*0.31+(D$24*GRA/100+GSCA*0.31)*VATRate","v":50.75385},{"$f":"E$24*GRA/100+GSCA*0.28+(E$24*GRA/100+GSCA*0.28)*VATRate","v":49.890749999999997},50.75385,{"$f":"G$24*GRA/100+GSCA*0.3+(G$24*GRA/100+GSCA*0.3)*VATRate","v":50.466149999999999},50.75385,{"$f":"I$24*GRA/100+GSCA*0.3+(I$24*GRA/100+GSCA*0.3)*VATRate","v":50.466149999999999},50.75385,50.75385,{"$f":"L$24*GRA/100+GSCA*0.3+(L$24*GRA/100+GSCA*0.3)*VATRate","v":50.466149999999999},50.75385,{"$f":"N$24*GRA/100+GSCA*0.3+(N$24*GRA/100+GSCA*0.3)*VATRate","v":50.466149999999999},50.75385,{"$f":"SUM(D34:O34)","v":607.03230000000008}]
["Tariff A Electricity:",null,null,{"$f":"D$28*ERA/100+ESCA*0.31+(D$28*ERA/100+ESCA*0.31)*VATRate","v":29.334479999999999},{"$f":"E$28*ERA/100+ESCA*0.28+(E$28*ERA/100+ESCA*0.28)*VATRate","v":28.989239999999999},29.334479999999999,{"$f":"G$28*ERA/100+ESCA*0.3+(G$28*ERA/100+ESCA*0.3)*VATRate","v":29.2194},29.334479999999999,{"$f":"I$28*ERA/100+ESCA*0.3+(I$28*ERA/100+ESCA*0.3)*VATRate","v":29.2194},29.334479999999999,29.334479999999999,{"$f":"L$28*ERA/100+ESCA*0.3+(L$28*ERA/100+ESCA*0.3)*VATRate","v":29.2194},29.334479999999999,{"$f":"N$28*ERA/100+ESCA*0.3+(N$28*ERA/100+ESCA*0.3)*VATRate","v":29.2194},29.334479999999999,{"$f":"SUM(D35:O35)","v":351.20819999999998}]
[]
["Tariff B inc. SC and VAT:",null,null,{"$f":"D$24*GRB/100+D$28*ERB/100+(GSCB+ESCB)*0.31+(D$24*GRB/100+D$28*ERB/100+(GSCB+ESCB)*0.31)*VATRate","v":81.403350000000003},{"$f":"E$24*GRB/100+E$28*ERB/100+(GSCB+ESCB)*0.28+(E$24*GRB/100+E$28*ERB/100+(GSCB+ESCB)*0.28)*VATRate","v":80.06774999999999},81.403350000000003,{"$f":"G$24*GRB/100+G$28*ERB/100+(GSCB+ESCB)*0.3+(G$24*GRB/100+G$28*ERB/100+(GSCB+ESCB)*0.3)*VATRate","v":80.958149999999989},81.403350000000003,{"$f":"I$24*GRB/100+I$28*ERB/100+(GSCB+ESCB)*0.3+(I$24*GRB/100+I$28*ERB/100+(GSCB+ESCB)*0.3)*VATRate","v":80.958149999999989},81.403350000000003,81.403350000000003,{"$f":"L$24*GRB/100+L$28*ERB/100+(GSCB+ESCB)*0.3+(L$24*GRB/100+L$28*ERB/100+(GSCB+ESCB)*0.3)*VATRate","v":80.958149999999989},81.403350000000003,{"$f":"N$24*GRB/100+N$28*ERB/100+(GSCB+ESCB)*0.3+(N$24*GRB/100+N$28*ERB/100+(GSCB+ESCB)*0.3)*VATRate","v":80.958149999999989},81.403350000000003,{"$f":"SUM(D37:O37)","v":973.72379999999998}]
["Tariff B Gas:",null,null,{"$f":"D$24*GRB/100+GSCB*0.31+(D$24*GRB/100+GSCB*0.31)*VATRate","v":50.75385},{"$f":"E$24*GRB/100+GSCB*0.28+(E$24*GRB/100+GSCB*0.28)*VATRate","v":49.890749999999997},50.75385,{"$f":"G$24*GRB/100+GSCB*0.3+(G$24*GRB/100+GSCB*0.3)*VATRate","v":50.466149999999999},50.75385,{"$f":"I$24*GRB/100+GSCB*0.3+(I$24*GRB/100+GSCB*0.3)*VATRate","v":50.466149999999999},50.75385,50.75385,{"$f":"L$24*GRB/100+GSCB*0.3+(L$24*GRB/100+GSCB*0.3)*VATRate","v":50.466149999999999},50.75385,{"$f":"N$24*GRB/100+GSCB*0.3+(N$24*GRB/100+GSCB*0.3)*VATRate","v":50.466149999999999},50.75385,{"$f":"SUM(D38:O38)","v":607.03230000000008}]
["Tariff B Electricity:",null,null,{"$f":"D$28*ERB/100+ESCB*0.31+(D$28*ERB/100+ESCB*0.31)*VATRate","v":30.649499999999996},{"$f":"E$28*ERB/100+ESCB*0.28+(E$28*ERB/100+ESCB*0.28)*VATRate","v":30.177},30.649499999999996,{"$f":"G$28*ERB/100+ESCB*0.3+(G$28*ERB/100+ESCB*0.3)*VATRate","v":30.491999999999997},30.649499999999996,{"$f":"I$28*ERB/100+ESCB*0.3+(I$28*ERB/100+ESCB*0.3)*VATRate","v":30.491999999999997},30.649499999999996,30.649499999999996,{"$f":"L$28*ERB/100+ESCB*0.3+(L$28*ERB/100+ESCB*0.3)*VATRate","v":30.491999999999997},30.649499999999996,{"$f":"N$28*ERB/100+ESCB*0.3+(N$28*ERB/100+ESCB*0.3)*VATRate","v":30.491999999999997},30.649499999999996,{"$f":"SUM(D39:O39)","v":366.69149999999996}]
[]
["Tariff C inc. SC and VAT:",null,null,{"$f":"D$24*GRC/100+D$28*ERC/100+(GSCC+ESCC)*0.31+(D$24*GRC/100+D$28*ERC/100+(GSCC+ESCC)*0.31)*VATRate","v":80.739329999999995},{"$f":"E$24*GRC/100+E$28*ERC/100+(GSCC+ESCC)*0.28+(E$24*GRC/100+E$28*ERC/100+(GSCC+ESCC)*0.28)*VATRate","v":79.467989999999986},80.739329999999995,{"$f":"G$24*GRC/100+G$28*ERC/100+(GSCC+ESCC)*0.3+(G$24*GRC/100+G$28*ERC/100+(GSCC+ESCC)*0.3)*VATRate","v":80.315550000000002},80.739329999999995,{"$f":"I$24*GRC/100+I$28*ERC/100+(GSCC+ESCC)*0.3+(I$24*GRC/100+I$28*ERC/100+(GSCC+ESCC)*0.3)*VATRate","v":80.315550000000002},80.739329999999995,80.739329999999995,{"$f":"L$24*GRC/100+L$28*ERC/100+(GSCC+ESCC)*0.3+(L$24*GRC/100+L$28*ERC/100+(GSCC+ESCC)*0.3)*VATRate","v":80.315550000000002},80.739329999999995,{"$f":"N$24*GRC/100+N$28*ERC/100+(GSCC+ESCC)*0.3+(N$24*GRC/100+N$28*ERC/100+(GSCC+ESCC)*0.3)*VATRate","v":80.315550000000002},80.739329999999995,{"$f":"SUM(D41:O41)","v":965.90550000000007}]
["Tariff C Gas:",null,null,{"$f":"D$24*GRC/100+GSCC*0.31+(D$24*GRC/100+GSCC*0.31)*VATRate","v":50.75385},{"$f":"E$24*GRC/100+GSCC*0.28+(E$24*GRC/100+GSCC*0.28)*VATRate","v":49.890749999999997},50.75385,{"$f":"G$24*GRC/100+GSCC*0.3+(G$24*GRC/100+GSCC*0.3)*VATRate","v":50.466149999999999},50.75385,{"$f":"I$24*GRC/100+GSCC*0.3+(I$24*GRC/100+GSCC*0.3)*VATRate","v":50.466149999999999},50.75385,50.75385,{"$f":"L$24*GRC/100+GSCC*0.3+(L$24*GRC/100+GSCC*0.3)*VATRate","v":50.466149999999999},50.75385,{"$f":"N$24*GRC/100+GSCC*0.3+(N$24*GRC/100+GSCC*0.3)*VATRate","v":50.466149999999999},50.75385,{"$f":"SUM(D42:O42)","v":607.03230000000008}]
["Tariff C Electricity:",null,null,{"$f":"D$28*ERC/100+ESCC*0.31+(D$28*ERC/100+ESCC*0.31)*VATRate","v":29.985480000000003},{"$f":"E$28*ERC/100+ESCC*0.28+(E$28*ERC/100+ESCC*0.28)*VATRate","v":29.57724},29.985480000000003,{"$f":"G$28*ERC/100+ESCC*0.3+(G$28*ERC/100+ESCC*0.3)*VATRate","v":29.849399999999996},29.985480000000003,{"$f":"I$28*ERC/100+ESCC*0.3+(I$28*ERC/100+ESCC*0.3)*VATRate","v":29.849399999999996},29.985480000000003,29.985480000000003,{"$f":"L$28*ERC/100+ESCC*0.3+(L$28*ERC/100+ESCC*0.3)*VATRate","v":29.849399999999996},29.985480000000003,{"$f":"N$28*ERC/100+ESCC*0.3+(N$28*ERC/100+ESCC*0.3)*VATRate","v":29.849399999999996},29.985480000000003,{"$f":"SUM(D43:O43)","v":358.8732}]
[]
["Tariff D inc. SC and VAT:",null,null,{"$f":"D$24*GRD/100+D$28*ERD/100+(GSCD+ESCD)*0.31+(D$24*GRD/100+D$28*ERD/100+(GSCD+ESCD)*0.31)*VATRate","v":81.064830000000001},{"$f":"E$24*GRD/100+E$28*ERD/100+(GSCD+ESCD)*0.28+(E$24*GRD/100+E$28*ERD/100+(GSCD+ESCD)*0.28)*VATRate","v":79.761989999999997},81.064830000000001,{"$f":"G$24*GRD/100+G$28*ERD/100+(GSCD+ESCD)*0.3+(G$24*GRD/100+G$28*ERD/100+(GSCD+ESCD)*0.3)*VATRate","v":80.630549999999999},81.064830000000001,{"$f":"I$24*GRD/100+I$28*ERD/100+(GSCD+ESCD)*0.3+(I$24*GRD/100+I$28*ERD/100+(GSCD+ESCD)*0.3)*VATRate","v":80.630549999999999},81.064830000000001,81.064830000000001,{"$f":"L$24*GRD/100+L$28*ERD/100+(GSCD+ESCD)*0.3+(L$24*GRD/100+L$28*ERD/100+(GSCD+ESCD)*0.3)*VATRate","v":80.630549999999999},81.064830000000001,{"$f":"N$24*GRD/100+N$28*ERD/100+(GSCD+ESCD)*0.3+(N$24*GRD/100+N$28*ERD/100+(GSCD+ESCD)*0.3)*VATRate","v":80.630549999999999},81.064830000000001,{"$f":"SUM(D45:O45)","v":969.73800000000006}]
["Tariff D Gas:",null,null,{"$f":"D$24*GRD/100+GSCD*0.31+(D$24*GRD/100+GSCD*0.31)*VATRate","v":50.75385},{"$f":"E$24*GRD/100+GSCD*0.28+(E$24*GRD/100+GSCD*0.28)*VATRate","v":49.890749999999997},50.75385,{"$f":"G$24*GRD/100+GSCD*0.3+(G$24*GRD/100+GSCD*0.3)*VATRate","v":50.466149999999999},50.75385,{"$f":"I$24*GRD/100+GSCD*0.3+(I$24*GRD/100+GSCD*0.3)*VATRate","v":50.466149999999999},50.75385,50.75385,{"$f":"L$24*GRD/100+GSCD*0.3+(L$24*GRD/100+GSCD*0.3)*VATRate","v":50.466149999999999},50.75385,{"$f":"N$24*GRD/100+GSCD*0.3+(N$24*GRD/100+GSCD*0.3)*VATRate","v":50.466149999999999},50.75385,{"$f":"SUM(D46:O46)","v":607.03230000000008}]
["Tariff D Electricity:",null,null,{"$f":"D$28*ERD/100+ESCD*0.31+(D$28*ERD/100+ESCD*0.31)*VATRate","v":30.310980000000001},{"$f":"E$28*ERD/100+ESCD*0.28+(E$28*ERD/100+ESCD*0.28)*VATRate","v":29.87124},30.310980000000001,{"$f":"G$28*ERD/100+ESCD*0.3+(G$28*ERD/100+ESCD*0.3)*VATRate","v":30.164399999999997},30.310980000000001,{"$f":"I$28*ERD/100+ESCD*0.3+(I$28*ERD/100+ESCD*0.3)*VATRate","v":30.164399999999997},30.310980000000001,30.310980000000001,{"$f":"L$28*ERD/100+ESCD*0.3+(L$28*ERD/100+ESCD*0.3)*VATRate","v":30.164399999999997},30.310980000000001,{"$f":"N$28*ERD/100+ESCD*0.3+(N$28*ERD/100+ESCD*0.3)*VATRate","v":30.164399999999997},30.310980000000001,{"$f":"SUM(D47:O47)","v":362.70569999999998}]