{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":19,"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":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[32,1,34,6],[35,1,39,6],[40,1,42,6],[0,0,2,2],[17,1,17,6],[27,1,28,6],[29,1,31,6],[18,1,21,6],[25,1,26,6],[22,1,24,6]]}
["Start here by entering your electricity standing charge. Then tab down this column entering the charges and gas kWh conversion. Then go to page 2 and enter your readings."]
[]
[]
["Electricity Standing Charge:",10.96,"In a 31 day month this costs:",{"$f":"SUM(ESC*31/100)","v":3.3976000000000006},"inc. VAT:",{"$f":"SUM(D4+D4*VATRate)","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(D5+D5*VATRate)","v":8.9186999999999994}]
[null,null,"Total cost of standing charges:",{"$f":"D5+D4","v":11.8916},"inc. VAT:",{"$f":"F4+F5","v":12.486180000000001}]
["Electricity Rate:",16.36]
["Gas Rate:",4.4269999999999996]
[]
["Calorific Value:",39.799999999999997]
["Correction Factor:",1.02264]
["kWh conversion factor:",3.6]
["CVxCF/kWhCF = GKWHC",{"$f":"CV*CF/KCF","v":11.305853333333332}]
[]
["VAT Rate:",0.05]
[]
[]
[null,"Notes"]
[null,"1. Beware of missing a month. It's safest to take readings near the middle of each month but If you normally enter readings near the last day of each month and forget until the start of the next month it's best to back-date the readings into the correct month and reduce them a bit."]
[]
[]
[]
[null,"2. You can change the dates of readings on page 2 but if you want to include readings from earlier this year in order to get estimates and yearly totals it's better to enter them as estimates in the relevant month for next year on page 3."]
[]
[]
[null,"3. There are a couple of dummy readings on the first two lines on page 2. Just replace them with your readings. "]
[]
[null,"4. There are likely to be some rounding errors of a few pence. I suspect this might be the power companies."]
[]
[null,"5. The pages are protected and some columns are hidden on Page 2 to make it look simpler and to make it easy to tab, but there is no password so if you want to see the hidden columns or change anything just unprotect it."]
[]
[]
[null,"6. 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. "]
[]
[]
[null,"7. The charts on page 3 should start to look more sensible once you enter a couple of lines of readings. They expect one reading a month. If you don't do that - then they should work for quarterly readings and if you make more than one reading for a month they won't cover 12 months - which should be ok but if you want to add rows to page 2 and columns on page 3 you'll have to know what you're doing..  "]
[]
[]
[]
[]
[null,"8. If there is a price change - enter a meter reading the day before. If you continue to use the same sheet the previous months' figures will change to the new prices so it's better to make a copy starting with new sheets for the new rates."]

{"sheet":"Sheet2","index":1,"n_rows":24,"n_cols":32,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,31,7,31],[3,2,3,8],[11,27,11,28],[4,24,7,24],[4,26,7,26],[4,25,7,25],[4,29,7,29],[4,30,7,30],[11,29,11,30],[0,0,2,17],[20,1,20,17],[2,19,3,31],[4,22,7,22],[4,27,7,27],[4,28,7,28],[4,21,7,21],[4,23,7,23],[3,10,3,16]]}
["Enter readings below. Try to take readings on the same day of each month.Then scroll right to see predicted usage and costs. Then go to page 3 to adjust your predicted usage figures for each month."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projected Usage (All costs include VAT)"]
[null,null,"Gas",null,null,null,null,null,null,null,"Electricity"]
["Date of Reading","Days","Reading","Used","kWh used","Cost","Standing Charge","Total","VAT","Total inc. VAT","Reading","kWh used","Cost","Standing Charge","Total","VAT","Total inc. VAT","Total",null,null,null,"Total kWh used to date","Average kWh used per 30.5 days","Average cost per 30.5 days inc.SC & VAT","Projected kWh use over 365 days","Projected cost over 365 days inc. SC & VAT","Total Standing Charge for 365 days inc. VAT","Summer usage = minus 35% over 7 months*","Summer usage per month*","Winter usage = plus 35% over 5 months*","Winter usage per month*","Total seasonally adjusted usage"]
["2014-04-15",null,1,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,"From:",{"$f":"A6","v":"2014-04-15"}]
["2014-05-15",{"$f":"IF(A7>0,IF(A7-A6>=0,A7-A6,\"Err1\"),0)","v":30},2,{"$f":"IF(C7>0,IF(C7-C6>=0,C7-C6,\"Err2\"),0)","v":1},{"$f":"D7*GKWHC","v":11.305853333333332},{"$f":"E7*GR/100","v":0.50051012706666653},{"$f":"B7*GSC/100","v":8.2200000000000006},{"$f":"F7+G7","v":8.7205101270666674},{"$f":"H7*VATRate","v":0.43602550635333337},{"$f":"H7+I7","v":9.1565356334200008},2,{"$f":"IF(K7>0,IF(K7-K6>=0,K7-K6,\"Err3\"),0)","v":1},{"$f":"L7*ER/100","v":0.1636},{"$f":"B7*ESC/100","v":3.2880000000000003},{"$f":"M7+N7","v":3.4516000000000004},{"$f":"O7*VATRate","v":0.17258000000000004},{"$f":"O7+P7","v":3.6241800000000004},{"$f":"Q7+J7","v":12.780715633420002},null,"To:",{"$f":"LOOKUP(MAX(C6:C18),C6:C18,A6:A18)","v":"2014-05-15"}]
["2014-06-15",31,null,0,0,0,8.4939999999999998,8.4939999999999998,0.42470000000000002,8.9186999999999994,null,0,0,3.3976000000000006,3.3976000000000006,0.16988000000000003,3.5674800000000007,12.486180000000001,null,"Days:",{"$f":"U7-U6","v":30}]
["2014-07-15",30,null,0,0,0,8.2200000000000006,8.2200000000000006,0.41100000000000003,8.6310000000000002,null,0,0,3.2880000000000003,3.2880000000000003,0.16440000000000002,3.4524000000000004,12.083400000000001,null,null,"Gas",{"$f":"SUM(E7:E18)","v":11.305853333333332},{"$f":"V9*30.5/DTD","v":11.494284222222221},{"$f":"SUM(F4:F30)*30.5/DTD+GSC*30.5/100+(SUM(F4:F30)*30.5/DTD+GSC*30.5/100)*VATRate","v":9.8434391212873322},{"$f":"V9*365/DTD","v":137.55454888888886},{"$f":"X9*365/30.5","v":117.79853374655332},{"$f":"GSC*3.65+GSC*3.65*VATRate","v":105.01049999999999},{"$f":"((Z6-AA6)*7*0.65/12)+GSC*214/100+GSC*214*VATRate/100","v":61.567799999999998},{"$f":"AB9/7","v":8.795399999999999},{"$f":"((Z6-AA6)*5*1.35/12)+GSC*151/100+GSC*151*VATRate/100","v":43.442699999999995},{"$f":"AD9/5","v":8.6885399999999997},{"$f":"AB9+AD9","v":105.01049999999999}]
["2014-08-15",31,null,0,0,0,8.4939999999999998,8.4939999999999998,0.42470000000000002,8.9186999999999994,null,0,0,3.3976000000000006,3.3976000000000006,0.16988000000000003,3.5674800000000007,12.486180000000001,null,null,"Electricity",{"$f":"SUM(L7:L18)","v":1},{"$f":"V10*30.5/DTD","v":1.0166666666666666},{"$f":"SUM(M4:M30)*30.5/DTD+ESC*30.5/100+(SUM(M4:M30)*30.5/DTD+ESC*30.5/100)*VATRate","v":3.8592260000000005},{"$f":"V10*365/DTD","v":12.166666666666666},{"$f":"X10*365/30.5","v":46.184180000000005},{"$f":"ESC*3.65+ESC*3.65*VATRate","v":42.004200000000004},{"$f":"((Z7-AA7)*7*0.65/12)+ESC*214/100+ESC*214*VATRate/100","v":24.627119999999998},{"$f":"AB10/7","v":3.5181599999999995},{"$f":"((Z7-AA7)*5*1.35/12)+ESC*151/100+ESC*151*VATRate/100","v":17.377080000000003},{"$f":"AD10/5","v":3.4754160000000005},{"$f":"AB10+AD10","v":42.004199999999997}]
["2014-09-15",31,null,0,0,0,8.4939999999999998,8.4939999999999998,0.42470000000000002,8.9186999999999994,null,0,0,3.3976000000000006,3.3976000000000006,0.16988000000000003,3.5674800000000007,12.486180000000001,null,null,"Totals",{"$f":"V9+V10","v":12.305853333333332},12.510950888888889,13.702665121287332,149.72121555555552,163.98271374655332,147.0147,{"$f":"AB9+AB10","v":86.194919999999996},{"$f":"AC9+AC10","v":12.313559999999999},{"$f":"AD9+AD10","v":60.819779999999994},{"$f":"AE9+AE10","v":12.163956000000001},{"$f":"AB11+AD11","v":147.0147}]
["2014-10-15",30,null,0,0,0,8.2200000000000006,8.2200000000000006,0.41100000000000003,8.6310000000000002,null,0,0,3.2880000000000003,3.2880000000000003,0.16440000000000002,3.4524000000000004,12.083400000000001,null,null,null,null,null,null,null,null,null,"*March to September",null,"*October to February"]
["2014-11-15",31,null,0,0,0,8.4939999999999998,8.4939999999999998,0.42470000000000002,8.9186999999999994,null,0,0,3.3976000000000006,3.3976000000000006,0.16988000000000003,3.5674800000000007,12.486180000000001]
["2014-12-15",30,null,0,0,0,8.2200000000000006,8.2200000000000006,0.41100000000000003,8.6310000000000002,null,0,0,3.2880000000000003,3.2880000000000003,0.16440000000000002,3.4524000000000004,12.083400000000001]
["2015-01-15",31,null,0,0,0,8.4939999999999998,8.4939999999999998,0.42470000000000002,8.9186999999999994,null,0,0,3.3976000000000006,3.3976000000000006,0.16988000000000003,3.5674800000000007,12.486180000000001]
["2015-02-15",31,null,0,0,0,8.4939999999999998,8.4939999999999998,0.42470000000000002,8.9186999999999994,null,0,0,3.3976000000000006,3.3976000000000006,0.16988000000000003,3.5674800000000007,12.486180000000001]
["2015-03-15",28,null,0,0,0,7.6719999999999997,7.6719999999999997,0.3836,8.0556000000000001,null,0,0,3.0688,3.0688,0.15344000000000002,3.2222400000000002,11.277840000000001]
["2015-04-15",31,null,0,0,0,8.4939999999999998,8.4939999999999998,0.42470000000000002,8.9186999999999994,null,0,0,3.3976000000000006,3.3976000000000006,0.16988000000000003,3.5674800000000007,12.486180000000001]
["Totals",{"$f":"SUM(B7:B18)","v":365},"Gas",{"$f":"SUM(D7:D18)","v":1},11.305853333333332,0.50051012706666653,100.00999999999999,100.51051012706667,5.0255255063533335,105.53603563342,"Electricity",{"$f":"SUM(L7:L18)","v":1},0.1636,40.004000000000005,40.167600000000007,2.0083800000000007,42.17598000000001,147.71201563342001]
[]
[null,"Error Codes"]
[null,"Err1: ","Date must be greater than or equal to date above"]
[null,"Err2: ","Gas reading must be greater than or equal to reading above"]
[null,"Err3: ","Electricity reading must be greater than or equal to reading above"]

{"sheet":"Sheet3","index":2,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[18,0,18,1],[21,0,23,1],[26,0,28,1],[0,0,9,0],[19,0,19,1],[20,0,20,1],[24,0,24,1],[30,2,30,13],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[25,0,25,1]]}
[" 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 21 and 26 below, then scroll down to see the costs with the year's totals on the right, and a chart of the costs."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"Sheet2!A7","v":"2014-05-15"},{"$f":"Sheet2!A8","v":"2014-06-15"},{"$f":"Sheet2!A9","v":"2014-07-15"},{"$f":"Sheet2!A10","v":"2014-08-15"},{"$f":"Sheet2!A11","v":"2014-09-15"},{"$f":"Sheet2!A12","v":"2014-10-15"},{"$f":"Sheet2!A13","v":"2014-11-15"},{"$f":"Sheet2!A14","v":"2014-12-15"},{"$f":"Sheet2!A15","v":"2015-01-15"},{"$f":"Sheet2!A16","v":"2015-02-15"},{"$f":"Sheet2!A17","v":"2015-03-15"},{"$f":"Sheet2!A18","v":"2015-04-15"},"Totals"]
["Actual Gas kWh Used:",null,{"$f":"Sheet2!E7","v":11.305853333333332},{"$f":"Sheet2!E8","v":0},{"$f":"Sheet2!E9","v":0},{"$f":"Sheet2!E10","v":0},{"$f":"Sheet2!E11","v":0},{"$f":"Sheet2!E12","v":0},{"$f":"Sheet2!E13","v":0},{"$f":"Sheet2!E14","v":0},{"$f":"Sheet2!E15","v":0},{"$f":"Sheet2!E16","v":0},{"$f":"Sheet2!E17","v":0},{"$f":"Sheet2!E18","v":0},{"$f":"SUM(C20:N20)","v":11.305853333333332}]
["Gas kWh Estimates :",null,899,823,815,794,764,687,673,572,646,700,756,865,{"$f":"SUM(C21:N21)","v":8994}]
[]
[]
[]
["Actual Electricity kWh Used:",null,{"$f":"Sheet2!L7","v":1},{"$f":"Sheet2!L8","v":0},{"$f":"Sheet2!L9","v":0},{"$f":"Sheet2!L10","v":0},{"$f":"Sheet2!L11","v":0},{"$f":"Sheet2!L12","v":0},{"$f":"Sheet2!L13","v":0},{"$f":"Sheet2!L14","v":0},{"$f":"Sheet2!L15","v":0},{"$f":"Sheet2!L16","v":0},{"$f":"Sheet2!L17","v":0},{"$f":"Sheet2!L18","v":0},{"$f":"SUM(C25:N25)","v":1}]
["Electricity kWh Estimates:",null,186,130,163,131,126,123,126,120,120,120,122,124,{"$f":"SUM(C26:N26)","v":1591}]
[]
[]
[]
[]
[null,null,"Estimated Costs",null,null,null,null,null,null,null,null,null,null,null,"Year's Costs"]
["Standing Charges inc. VAT:",null,{"$f":"(GSC+ESC)*Sheet2!B7/100+((GSC+ESC)*Sheet2!B7/100)*VATRate","v":12.083399999999999},{"$f":"(GSC+ESC)*Sheet2!B8/100+((GSC+ESC)*Sheet2!B8/100)*VATRate","v":12.486180000000001},{"$f":"(GSC+ESC)*Sheet2!B9/100+((GSC+ESC)*Sheet2!B9/100)*VATRate","v":12.083399999999999},{"$f":"(GSC+ESC)*Sheet2!B10/100+((GSC+ESC)*Sheet2!B10/100)*VATRate","v":12.486180000000001},{"$f":"(GSC+ESC)*Sheet2!B11/100+((GSC+ESC)*Sheet2!B11/100)*VATRate","v":12.486180000000001},{"$f":"(GSC+ESC)*Sheet2!B12/100+((GSC+ESC)*Sheet2!B12/100)*VATRate","v":12.083399999999999},{"$f":"(GSC+ESC)*Sheet2!B13/100+((GSC+ESC)*Sheet2!B13/100)*VATRate","v":12.486180000000001},{"$f":"(GSC+ESC)*Sheet2!B14/100+((GSC+ESC)*Sheet2!B14/100)*VATRate","v":12.083399999999999},{"$f":"(GSC+ESC)*Sheet2!B15/100+((GSC+ESC)*Sheet2!B15/100)*VATRate","v":12.486180000000001},{"$f":"(GSC+ESC)*Sheet2!B16/100+((GSC+ESC)*Sheet2!B16/100)*VATRate","v":12.486180000000001},{"$f":"(GSC+ESC)*Sheet2!B17/100+((GSC+ESC)*Sheet2!B17/100)*VATRate","v":11.277839999999999},{"$f":"(GSC+ESC)*Sheet2!B18/100+((GSC+ESC)*Sheet2!B18/100)*VATRate","v":12.486180000000001},{"$f":"SUM(C32:N32)","v":147.0147}]
["Gas inc. SC and VAT:",null,{"$f":"C21*GR/100+GSC*Sheet2!B7/100+(C21*GR/100+GSC*Sheet2!B7/100)*VATRate","v":50.419666499999998},{"$f":"D21*GR/100+GSC*Sheet2!B8/100+(D21*GR/100+GSC*Sheet2!B8/100)*VATRate","v":47.174620500000003},{"$f":"E21*GR/100+GSC*Sheet2!B9/100+(E21*GR/100+GSC*Sheet2!B9/100)*VATRate","v":46.515052499999996},{"$f":"F21*GR/100+GSC*Sheet2!B10/100+(F21*GR/100+GSC*Sheet2!B10/100)*VATRate","v":45.826599000000002},{"$f":"G21*GR/100+GSC*Sheet2!B11/100+(G21*GR/100+GSC*Sheet2!B11/100)*VATRate","v":44.432093999999999},{"$f":"H21*GR/100+GSC*Sheet2!B12/100+(H21*GR/100+GSC*Sheet2!B12/100)*VATRate","v":40.565164499999995},{"$f":"I21*GR/100+GSC*Sheet2!B13/100+(I21*GR/100+GSC*Sheet2!B13/100)*VATRate","v":40.202095499999999},{"$f":"J21*GR/100+GSC*Sheet2!B14/100+(J21*GR/100+GSC*Sheet2!B14/100)*VATRate","v":35.219561999999996},{"$f":"K21*GR/100+GSC*Sheet2!B15/100+(K21*GR/100+GSC*Sheet2!B15/100)*VATRate","v":38.947040999999999},{"$f":"L21*GR/100+GSC*Sheet2!B16/100+(L21*GR/100+GSC*Sheet2!B16/100)*VATRate","v":41.457149999999999},{"$f":"M21*GR/100+GSC*Sheet2!B17/100+(M21*GR/100+GSC*Sheet2!B17/100)*VATRate","v":43.197125999999997},{"$f":"N21*GR/100+GSC*Sheet2!B18/100+(N21*GR/100+GSC*Sheet2!B18/100)*VATRate","v":49.126927499999994},{"$f":"SUM(C33:N33)","v":523.08309899999995}]
["Electricity inc. SC and VAT:",null,{"$f":"C26*ER/100+ESC*Sheet2!B7/100+(C26*ER/100+ESC*Sheet2!B7/100)*VATRate","v":35.403480000000002},{"$f":"D26*ER/100+ESC*Sheet2!B8/100+(D26*ER/100+ESC*Sheet2!B8/100)*VATRate","v":25.898879999999998},{"$f":"E26*ER/100+ESC*Sheet2!B9/100+(E26*ER/100+ESC*Sheet2!B9/100)*VATRate","v":31.452539999999999},{"$f":"F26*ER/100+ESC*Sheet2!B10/100+(F26*ER/100+ESC*Sheet2!B10/100)*VATRate","v":26.07066},{"$f":"G26*ER/100+ESC*Sheet2!B11/100+(G26*ER/100+ESC*Sheet2!B11/100)*VATRate","v":25.211760000000002},{"$f":"H26*ER/100+ESC*Sheet2!B12/100+(H26*ER/100+ESC*Sheet2!B12/100)*VATRate","v":24.581339999999997},{"$f":"I26*ER/100+ESC*Sheet2!B13/100+(I26*ER/100+ESC*Sheet2!B13/100)*VATRate","v":25.211760000000002},{"$f":"J26*ER/100+ESC*Sheet2!B14/100+(J26*ER/100+ESC*Sheet2!B14/100)*VATRate","v":24.065999999999999},{"$f":"K26*ER/100+ESC*Sheet2!B15/100+(K26*ER/100+ESC*Sheet2!B15/100)*VATRate","v":24.181079999999998},{"$f":"L26*ER/100+ESC*Sheet2!B16/100+(L26*ER/100+ESC*Sheet2!B16/100)*VATRate","v":24.181079999999998},{"$f":"M26*ER/100+ESC*Sheet2!B17/100+(M26*ER/100+ESC*Sheet2!B17/100)*VATRate","v":24.179399999999998},{"$f":"N26*ER/100+ESC*Sheet2!B18/100+(N26*ER/100+ESC*Sheet2!B18/100)*VATRate","v":24.868200000000002},{"$f":"SUM(C34:N34)","v":315.30617999999998}]
["Total inc. SC and VAT:",null,{"$f":"C21*GR/100+C26*ER/100+(GSC+ESC)*Sheet2!B7/100+(C21*GR/100+C26*ER/100+(GSC+ESC)*Sheet2!B7/100)*VATRate","v":85.823146499999993},{"$f":"D21*GR/100+D26*ER/100+(GSC+ESC)*Sheet2!B8/100+(D21*GR/100+D26*ER/100+(GSC+ESC)*Sheet2!B8/100)*VATRate","v":73.073500499999994},{"$f":"E21*GR/100+E26*ER/100+(GSC+ESC)*Sheet2!B9/100+(E21*GR/100+E26*ER/100+(GSC+ESC)*Sheet2!B9/100)*VATRate","v":77.967592499999995},{"$f":"F21*GR/100+F26*ER/100+(GSC+ESC)*Sheet2!B10/100+(F21*GR/100+F26*ER/100+(GSC+ESC)*Sheet2!B10/100)*VATRate","v":71.897258999999991},{"$f":"G21*GR/100+G26*ER/100+(GSC+ESC)*Sheet2!B11/100+(G21*GR/100+G26*ER/100+(GSC+ESC)*Sheet2!B11/100)*VATRate","v":69.64385399999999},{"$f":"H21*GR/100+H26*ER/100+(GSC+ESC)*Sheet2!B12/100+(H21*GR/100+H26*ER/100+(GSC+ESC)*Sheet2!B12/100)*VATRate","v":65.146504499999992},{"$f":"I21*GR/100+I26*ER/100+(GSC+ESC)*Sheet2!B13/100+(I21*GR/100+I26*ER/100+(GSC+ESC)*Sheet2!B13/100)*VATRate","v":65.413855499999997},{"$f":"J21*GR/100+J26*ER/100+(GSC+ESC)*Sheet2!B14/100+(J21*GR/100+J26*ER/100+(GSC+ESC)*Sheet2!B14/100)*VATRate","v":59.285561999999985},{"$f":"K21*GR/100+K26*ER/100+(GSC+ESC)*Sheet2!B15/100+(K21*GR/100+K26*ER/100+(GSC+ESC)*Sheet2!B15/100)*VATRate","v":63.128120999999993},{"$f":"L21*GR/100+L26*ER/100+(GSC+ESC)*Sheet2!B16/100+(L21*GR/100+L26*ER/100+(GSC+ESC)*Sheet2!B16/100)*VATRate","v":65.638229999999993},{"$f":"M21*GR/100+M26*ER/100+(GSC+ESC)*Sheet2!B17/100+(M21*GR/100+M26*ER/100+(GSC+ESC)*Sheet2!B17/100)*VATRate","v":67.376525999999984},{"$f":"N21*GR/100+N26*ER/100+(GSC+ESC)*Sheet2!B18/100+(N21*GR/100+N26*ER/100+(GSC+ESC)*Sheet2!B18/100)*VATRate","v":73.995127499999995},{"$f":"SUM(C35:N35)","v":838.38927899999987}]