{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Start","Section 1 Your details","Section 2.A","Section 2.B","Section 2.C","Section 2.D","Section 3. Result"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Start","index":0,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,8,10,10]]}
[]
[null,null,"IPART BILL COMPARATOR"]
[]
[null,null,"The Bill Comparator allows you to compare two different electricity offers."]
[]
[null,null,"To do this you will need to provide:"]
[null,null,"-","A year's worth of electricity bills for consecutive periods"]
[null,null,"-","information about your solar panel"]
[null,null,"-","tariffs of offers that you want to compare with"]
[]
[null,null,"Provide inputs in blue cells >>"]
[null,null,"Key results will be shown in >>"]
[]
[]
[null,null,"How to start"]
[null,null,"After you have read the important information below, press the 'Start' button."]
[null,null,"Then simply follow the instructions on each screen."]
[]
[null,null,"IMPORTANT  INFORMATION - PLEASE READ"]
[null,null,"Disclaimer - Not Financial Advice"]
[null,null,null,"The Bill Comparator does not provide financial advice.  The Bill Comparator results are an estimate only."]
[null,null,null,"The results are an approximate guide only and should not be used as exact values for financial planning"]
[null,null,null,"purposes."]
[null,null,"Disclaimer - Accuracy"]
[null,null,null,"Where information on PV generation is not provided, the Bill Comparator relies on IPART's estimated level of PV "]
[null,null,null,"generation for a typical PV unit based on its study in 2012.  Therefore, the estimated consumption used in the Bill"]
[null,null,null,"Calculator may not be accurate if your household characteristics are different from the typical characteristics of "]
[null,null,null,"similar households.  "]

{"sheet":"Section 1 Your details","index":1,"n_rows":61,"n_cols":21,"rows_kept":61,"cut":false,"hidden":false,"merged":[[19,17,19,19],[11,17,11,19],[9,17,9,19],[10,17,10,19],[5,17,5,19],[7,17,7,19],[8,17,8,19],[13,17,13,19],[17,17,17,19]]}
[null,{"$f":"Start!C2","v":"IPART BILL COMPARATOR"}]
[null,"SECTION 1. YOUR DETAILS"]
[]
[null,null,{"$f":"\"1. Enter your details\"","v":"1. Enter your details"}]
[]
[null,null,null,"(1) Do you have a solar panel?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,{"$f":"IF(R6=\"Yes\",1,0)","v":1}]
[]
[null,null,null,null,"What is the size of your solar panel?",null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"kW"]
[null,null,null,null,"What type of meter do you have?",null,null,null,null,null,null,null,null,null,null,null,null,"Net",null,null,{"$f":"IF(R6=\"No\",1,IF(R9=\"Gross\",1,0))","v":0}]
[null,null,null,null,"Do you know the total amount of PV generation?",null,null,null,null,null,null,null,null,null,null,null,null,"No",null,null,{"$f":"IF(R10=\"Yes\",1,0)","v":0}]
[null,null,null,null,{"$f":"IF(R10=\"Yes\",\"   Please provide total daily PV generation\",\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R10=\"Yes\",\"kWh per day\",\" \")","v":" "}]
[null,null,null,null,{"$f":"IF(R10=\"No\",\"   Bills will be calculated using an estimated amount of PV generation\",\" \")","v":"   Bills will be calculated using an estimated amount of PV generation"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R10=\"No\",INDEX(E45:E50,MATCH(R8,D45:D50,0)),\"\")","v":10.180821917808219},null,null,{"$f":"IF(R10=\"No\",\"kWh per day\",\" \")","v":"kWh per day"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R11:T12)","v":10.180821917808219}]
[null,null,null,"(2) What is your electricity tariff type?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Time of Use",null,null,{"$f":"IF(R14=D39,0,1)","v":1}]
[]
[null,null,null,null,{"$f":"IF(R14=D39,\"   Bills will be calculating using flat rate\",\" \")","v":" "}]
[]
[null,null,null,"(3) Do you have a controlled load for your hot water or another appliance?",null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[null,null,null,"(4) How much of your own PV electricity do you consume at home?",null,null,null,null,null,null,null,null,null,null,null,null,null,0.3]
[]
[]
[null,null,{"$f":"\"2. Proceed to \"&INDEX(I56:I61,F54)","v":"2. Proceed to Section 2.D: Time of Use Tariff without Controlled Load"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Flat Rate"]
[null,null,null,"Time of Use"]
[null,null,null,"I'm not sure"]
[null,null,null,"Yes"]
[null,null,null,"No"]
[null,null,null,"Gross"]
[null,null,null,"Net"]
[null,null,null,"PV unit size","Daily generation","Max cost"]
[null,null,null,1,{"$f":"1282/365","v":3.5123287671232877},{"$f":"$AC$23*D45*1000","v":0}]
[null,null,null,1.5,{"$f":"1882/365","v":5.1561643835616442},0]
[null,null,null,2,{"$f":"2546/365","v":6.9753424657534246},0]
[null,null,null,3,{"$f":"3716/365","v":10.180821917808219},0]
[null,null,null,4,{"$f":"4699/365","v":12.873972602739727},0]
[null,null,null,5,{"$f":"5687/365","v":15.580821917808219},0]
[null,null,null,"http://www.solarchoice.net.au/blog/news/solar-pv-system-prices-reach-unprecedented-lows-in-australia-141211/"]
[null,null,null,"IPART report in 2012, p 32"]
[]
[null,null,"Input",{"$f":"R14&\".\"&R18","v":"Time of Use.No"},null,{"$f":"MATCH(D54,C56:C61,0)","v":4}]
[null,null,null,"Tariff type","controlled load","section",null,"Seciton 1.2"]
[null,null,{"$f":"D56&\".\"&E56","v":"Flat Rate.Yes"},{"$f":"D37","v":"Flat Rate"},"Yes","Section 2.A",null,"Flat Rate with Controlled Load",{"$f":"F56&\": \"&H56","v":"Section 2.A: Flat Rate with Controlled Load"}]
[null,null,{"$f":"D57&\".\"&E57","v":"Flat Rate.No"},{"$f":"D56","v":"Flat Rate"},"No","Section 2.B",null,"Flat Rate without Controlled Load","Section 2.B: Flat Rate without Controlled Load"]
[null,null,"Time of Use.Yes",{"$f":"D38","v":"Time of Use"},"Yes","Section 2.C",null,"Time of Use Tariff with Controlled Load","Section 2.C: Time of Use Tariff with Controlled Load"]
[null,null,"Time of Use.No",{"$f":"D58","v":"Time of Use"},"No","Section 2.D",null,"Time of Use Tariff without Controlled Load","Section 2.D: Time of Use Tariff without Controlled Load"]
[null,null,"I'm not sure.Yes",{"$f":"D39","v":"I'm not sure"},"Yes","Section 2.A",null,{"$f":"H56","v":"Flat Rate with Controlled Load"},"Section 2.A: Flat Rate with Controlled Load"]
[null,null,"I'm not sure.No",{"$f":"D60","v":"I'm not sure"},"No","Section 2.B",null,{"$f":"H57","v":"Flat Rate without Controlled Load"},"Section 2.B: Flat Rate without Controlled Load"]

{"sheet":"Section 2.A","index":2,"n_rows":85,"n_cols":44,"rows_kept":85,"cut":false,"hidden":false,"merged":[[27,4,27,6],[63,4,63,6],[59,14,59,15],[32,14,32,15],[32,25,32,26],[57,8,57,9],[57,11,57,12],[52,14,52,15],[28,14,28,15],[54,25,54,26],[50,25,50,26],[57,25,57,26],[29,14,29,15],[30,11,30,12],[30,14,30,15],[31,14,31,15],[42,8,42,9],[34,4,35,7],[38,4,39,7],[63,14,63,15],[63,25,63,26],[28,11,28,12],[29,8,29,9],[27,8,27,9],[58,11,58,12],[58,14,58,15],[59,8,59,9],[21,8,21,9],[21,11,21,12],[21,25,21,26],[18,14,18,15],[23,11,23,12],[22,8,22,9],[22,11,22,12],[23,8,23,9],[76,8,76,9],[76,11,76,12],[79,8,79,9],[14,14,14,15],[15,14,15,15],[16,14,16,15],[17,14,17,15],[21,14,21,15],[66,8,66,9],[66,11,66,12],[68,14,68,15],[52,8,52,9],[52,11,52,12],[54,14,54,15],[53,14,53,15],[50,8,50,9],[50,11,50,12],[51,8,51,9],[51,11,51,12],[25,14,25,15],[30,8,30,9],[40,8,40,9],[57,14,57,15],[29,11,29,12],[13,25,13,26],[20,25,20,26],[20,14,20,15],[27,14,27,15],[27,25,27,26],[49,14,49,15],[49,25,49,26],[56,25,56,26],[56,14,56,15],[28,25,28,26],[4,22,4,24],[5,22,5,24],[14,8,14,9],[15,8,15,9],[16,8,16,9],[16,11,16,12],[15,11,15,12],[14,11,14,12],[6,22,6,24],[13,14,13,15],[13,8,13,9],[13,11,13,12],[74,4,75,7],[43,8,43,9],[36,8,36,9],[36,11,36,12],[34,11,35,12],[72,8,72,9],[72,11,72,12],[59,11,59,12],[70,8,71,9],[70,11,71,12],[34,8,35,9],[38,11,39,12],[38,8,39,9],[40,11,40,12],[63,11,63,12],[64,8,64,9],[64,11,64,12],[65,8,65,9],[65,11,65,12],[49,8,49,9],[56,8,56,9],[63,8,63,9],[49,11,49,12],[56,11,56,12],[14,25,14,26],[18,25,18,26],[22,14,22,15],[23,14,23,15],[24,14,24,15],[50,14,50,15],[51,14,51,15],[74,8,75,9],[74,11,75,12],[25,25,25,26],[28,8,28,9],[68,25,68,26],[66,14,66,15],[67,14,67,15],[64,25,64,26],[64,14,64,15],[65,14,65,15],[20,8,20,9],[60,14,60,15],[61,14,61,15],[61,25,61,26],[20,11,20,12],[27,11,27,12],[58,8,58,9]]}
[null,{"$f":"Start!C2","v":"IPART BILL COMPARATOR"}]
[null,"SECTION 2. YOUR ELECTRICITY CONSUMPTION AND ELECTRICITY OFFER DETAILS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"day",365,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"month",12,{"$f":"365/12","v":30.416666666666668}]
[null,null,{"$f":"\"1.\"","v":"1."},"Enter your annual electricity consumption",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"quarter",4,{"$f":"365/4","v":91.25}]
[null,null,null,null,"Standard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum",null,null,null,null,null,null,null,"year",1,365]
[null,null,null,null,"Controlled load 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum",null,null,null,null,null,null,null,"usage rate"]
[null,null,null,null,"Controlled load 2 (if applicable)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum",null,null,null,null,null,null,null,"total bill"]
[]
[null,null,{"$f":"\"2.\"","v":"2."},"Enter the details of the two electricity offers you wish to compare"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"if all consumption, calculate it daily"]
[null,null,null,null,"OFFER 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"con",{"$f":"W5/IF(L15=0,365,INDEX($AI$2:$AI$5,MATCH(L15,$AH$2:$AH$5,0)))","v":0},{"$f":"\"per \"&IF(L15=0,\"day\",L15)","v":"per day"},null,null,null,null,null,"Before discount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar used",{"$f":"IF('Section 1 Your details'!$U$9=1,0,solar_generation*solar_usage*IF(L15=0,1,INDEX($AJ$2:$AJ$5,MATCH(L15,$AH$2:$AH$5,0))))","v":3.0542465753424657},{"$f":"AJ12","v":"per day"},null,null,null,null,null,"Usage",{"$f":"AN15+AN22+AN29","v":0}]
[null,null,null,null,"Standard ",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"net  of solar",{"$f":"AI12-AI13","v":-3.0542465753424657},null,null,null,"bill per annum",null,null,"Supply",{"$f":"AN16+AN23+AN30","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$15>0,$Z$15,O15)","v":0},{"$f":"IF(I15>0,MIN(AI14,I15),AI14)","v":-3.0542465753424657},null,null,null,"usage",{"$f":"SUMPRODUCT(AI15:AI18,AH15:AH18)/100*IF(L15=0,365,INDEX($AI$2:$AI$5,MATCH(L15,$AH$2:$AH$5,0)))","v":0},null,"Fee",{"$f":"AN40","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$15>0,0,O16)","v":0},{"$f":"IF(I16>0,MAX(0,MIN(I16,AI14-AI15)),\"\")","v":""},null,null,null,"supply",{"$f":"AH19/100*365","v":0},null,"Total",{"$f":"SUM(AQ13:AQ15)","v":0},{"$f":"AQ16*1.1","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$15>0,0,O17)","v":0},{"$f":"IF(I17>0,MAX(0,MIN(I17,AI14-SUM(AI15:AI16))),\"\")","v":""},null,null,null,"check",{"$f":"SUM(AI15:AI18)-AI14","v":0},null,"After discount"]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$15>0,0,O18)","v":0},{"$f":"MAX(0,AI14-SUM(AI15:AI17))","v":0},null,null,null,null,null,null,"Usage",{"$f":"AQ13*(1-I37)","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day",null,null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day",null,null,null,null,null,{"$f":"IF($Z$15>0,Z19,O19)","v":0},null,null,null,null,null,null,null,"Supply",{"$f":"AQ14*(1-IF(L37=$AH$7,I37))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AP15","v":"Fee"},{"$f":"AQ15","v":0}]
[null,null,null,null,"Controlled Load 1",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"W6/IF(L22=0,365,INDEX($AI$2:$AI$5,MATCH(L22,$AH$2:$AH$5,0)))","v":0},null,null,null,"bill per annum",null,null,"Total",{"$f":"SUM(AQ18:AQ20)","v":0},{"$f":"AQ21*1.1","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$22>0,$Z$22,O22)","v":0},{"$f":"IF(I22>0,MIN(AI21,I22),AI21)","v":0},null,null,null,"usage",{"$f":"SUMPRODUCT(AI22:AI25,AH22:AH25)/100*IF(L22=0,365,INDEX($AI$2:$AI$5,MATCH(L22,$AH$2:$AH$5,0)))","v":0},null,"Feed-in tariff"]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$22>0,0,O23)","v":0},{"$f":"IF(I23>0,MAX(0,MIN(I23,AI21-AI22)),\"\")","v":""},null,null,null,"supply",{"$f":"AH26/100*365","v":0},null,"Total",{"$f":"AN44","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$22>0,0,O24)","v":0},{"$f":"IF(I24>0,MAX(0,MIN(I24,AI21-SUM(AI22:AI23))),\"\")","v":""},null,null,null,"check",{"$f":"SUM(AI22:AI25)-AI21","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"MAX(0,AI21-SUM(AI22:AI24))","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day",null,null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day",null,null,null,null,null,{"$f":"IF($Z$22>0,Z26,O26)","v":0}]
[]
[null,null,null,null,"Controlled Load 2 (if applicable)",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"W7/IF(L29=0,365,INDEX($AI$2:$AI$5,MATCH(L29,$AH$2:$AH$5,0)))","v":0},null,null,null,"bill per annum"]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$29>0,$Z$29,O29)","v":0},{"$f":"IF(I29>0,MIN(AI28,I29),AI28)","v":0},null,null,null,"usage",{"$f":"SUMPRODUCT(AI29:AI32,AH29:AH32)/100*IF(L29=0,365,INDEX($AI$2:$AI$5,MATCH(L29,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$29>0,0,O30)","v":0},{"$f":"IF(I30>0,MAX(0,MIN(I30,AI28-AI29)),\"\")","v":""},null,null,null,"supply",{"$f":"AH33/100*365","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$29>0,0,O31)","v":0},{"$f":"IF(I31>0,MAX(0,MIN(I31,AI28-SUM(AI29:AI30))),\"\")","v":""},null,null,null,"check",{"$f":"SUM(AI29:AI32)-AI28","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"MAX(0,AI28-SUM(AI29:AI31))","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day",null,null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day",null,null,null,null,null,{"$f":"IF($Z$29>0,Z33,O33)","v":0}]
[]
[null,null,null,null,"Available discounts",null,null,null,"Discount percentage",null,null,"Discount applies to usage rate or total bill?"]
[]
[null,null,null,null,"Guaranteed discount",null,null,null,null,null,"on"]
[]
[null,null,null,null,"Subscription or membership fee",null,null,null,"Fee                 ($, ex-GST)",null,null,"Per day, month, quarter or year?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fee",{"$f":"IF(I41=0,0,I41*(IF(L41=0,1,INDEX($AI$2:$AI$5,MATCH(L41,$AH$2:$AH$5,0)))))","v":0},"if frequency of membership fee is not specified, the default is \"per annum\""]
[null,null,null,null,null,null,null,null,null,null,"per"]
[]
[null,null,null,null,"Feed-in tariff",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar left",{"$f":"IF('Section 1 Your details'!$U$6=0,0,solar_generation-AI13/IF(L15=0,1,INDEX($AJ$2:$AJ$5,MATCH(L15,$AH$2:$AH$5,0))))","v":7.1265753424657525},"per day"]
[null,null,null,null,null,null,null,null,null,null,"cents","per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total credit",{"$f":"AI43*I44/100","v":0},"per day",null,null,"credit per annum",{"$f":"AI44*365","v":0}]
[]
[]
[]
[null,null,null,null,"OFFER 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"con",{"$f":"W5/IF(L51=0,365,INDEX($AI$2:$AI$5,MATCH(L51,$AH$2:$AH$5,0)))","v":0},{"$f":"\"per \"&IF(L51=0,\"day\",L51)","v":"per day"},null,null,null,null,null,"Before discount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar used",{"$f":"IF('Section 1 Your details'!$U$9=1,0,solar_generation*solar_usage*IF(L51=0,1,INDEX($AJ$2:$AJ$5,MATCH(L51,$AH$2:$AH$5,0))))","v":3.0542465753424657},{"$f":"AJ48","v":"per day"},null,null,null,null,null,"Usage",{"$f":"AN51+AN58+AN65","v":0}]
[null,null,null,null,"Standard ",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"net  of solar",{"$f":"AI48-AI49","v":-3.0542465753424657},null,null,null,"bill per annum",null,null,"Supply",{"$f":"AN52+AN59+AN66","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$51>0,$Z$51,O51)","v":0},{"$f":"IF(I51>0,MIN(AI50,I51),AI50)","v":-3.0542465753424657},null,null,null,"usage",{"$f":"SUMPRODUCT(AI51:AI54,AH51:AH54)/100*IF(L51=0,365,INDEX($AI$2:$AI$5,MATCH(L51,$AH$2:$AH$5,0)))","v":0},null,"Fee",{"$f":"AN76","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$51>0,0,O52)","v":0},{"$f":"IF(I52>0,MAX(0,MIN(I52,AI50-AI51)),\"\")","v":""},null,null,null,"supply",{"$f":"AH55/100*365","v":0},null,"Total",{"$f":"SUM(AQ49:AQ51)","v":0},{"$f":"AQ52*1.1","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$51>0,0,O53)","v":0},{"$f":"IF(I53>0,MAX(0,MIN(I53,AI50-SUM(AI51:AI52))),\"\")","v":""},null,null,null,"check",{"$f":"SUM(AI51:AI54)-AI50","v":0},null,"After discount"]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"MAX(0,AI50-SUM(AI51:AI53))","v":0},null,null,null,null,null,null,"Usage",{"$f":"AQ49*(1-I73)","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day",null,null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day","day",null,null,null,null,{"$f":"IF($Z$51>0,Z55,O55)","v":0},null,null,null,null,null,null,null,"Supply",{"$f":"AQ50*(1-IF(L73=$AH$7,I73))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AP51","v":"Fee"},{"$f":"AQ51","v":0}]
[null,null,null,null,"Controlled Load 1",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"W6/IF(L58=0,365,INDEX($AI$2:$AI$5,MATCH(L58,$AH$2:$AH$5,0)))","v":0},null,null,null,"bill per annum",null,null,"Total",{"$f":"SUM(AQ54:AQ56)","v":0},{"$f":"AQ57*1.1","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$58>0,$Z$58,O58)","v":0},{"$f":"IF(I58>0,MIN(AI57,I58),AI57)","v":0},null,null,null,"usage",{"$f":"SUMPRODUCT(AI58:AI61,AH58:AH61)/100*IF(L58=0,365,INDEX($AI$2:$AI$5,MATCH(L58,$AH$2:$AH$5,0)))","v":0},null,"Feed-in tariff"]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$58>0,0,O59)","v":0},{"$f":"IF(I59>0,MAX(0,MIN(I59,AI57-AI58)),\"\")","v":""},null,null,null,"supply",{"$f":"AH62/100*365","v":0},null,"Total",{"$f":"AN80","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$58>0,0,O60)","v":0},{"$f":"IF(I60>0,MAX(0,MIN(I60,AI57-SUM(AI58:AI59))),\"\")","v":""},null,null,null,"check",{"$f":"SUM(AI58:AI61)-AI57","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$58>0,0,O61)","v":0},{"$f":"MAX(0,AI57-SUM(AI58:AI60))","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day","day",null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day","day",null,null,null,null,{"$f":"IF($Z$58>0,Z62,O62)","v":0}]
[]
[null,null,null,null,"Controlled Load 2 (if applicable)",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"W7/IF(L65=0,365,INDEX($AI$2:$AI$5,MATCH(L65,$AH$2:$AH$5,0)))","v":0},null,null,null,"bill per annum"]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$65>0,$Z$65,O65)","v":0},{"$f":"IF(I65>0,MIN(AI64,I65),AI64)","v":0},null,null,null,"usage",{"$f":"SUMPRODUCT(AI65:AI68,AH65:AH68)/100*IF(L65=0,365,INDEX($AI$2:$AI$5,MATCH(L65,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$65>0,0,O66)","v":0},{"$f":"IF(I66>0,MAX(0,MIN(I66,AI64-AI65)),\"\")","v":""},null,null,null,"supply",{"$f":"AH69/100*365","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$65>0,0,O67)","v":0},{"$f":"IF(I67>0,MAX(0,MIN(I67,AI64-SUM(AI65:AI66))),\"\")","v":""},null,null,null,"check",{"$f":"SUM(AI65:AI68)-AI64","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$65>0,0,O68)","v":0},{"$f":"MAX(0,AI64-SUM(AI65:AI67))","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day","day",null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day","day",null,null,null,null,{"$f":"IF($Z$65>0,Z69,O69)","v":0}]
[]
[null,null,null,null,"Available discounts",null,null,null,"Discount percentage",null,null,"Discount applies to usage rate or total bill?"]
[]
[null,null,null,null,"Guaranteed discount",null,null,null,null,null,"on"]
[]
[null,null,null,null,"Subscription or membership fee",null,null,null,"Fee                 ($, ex-GST)",null,null,"Per day, month, quarter or year?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fee",{"$f":"IF(I77=0,0,I77*(IF(L77=0,1,INDEX($AI$2:$AI$5,MATCH(L77,$AH$2:$AH$5,0)))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"per"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar left",{"$f":"IF('Section 1 Your details'!$U$6=0,0,solar_generation-AI49/IF(L51=0,1,INDEX($AJ$2:$AJ$5,MATCH(L51,$AH$2:$AH$5,0))))","v":7.1265753424657525},"per day"]
[null,null,null,null,"Feed-in tariff",null,null,null,null,null,"cents","per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total credit",{"$f":"AI79*I80/100","v":0},"per day",null,null,"credit per annum",{"$f":"AI80*365","v":0}]
[]
[]
[]
[]
[null,null,{"$f":"\"3.\"","v":"3."},"Proceed to see the results"]

{"sheet":"Section 2.B","index":3,"n_rows":57,"n_cols":44,"rows_kept":57,"cut":false,"hidden":false,"merged":[[18,25,18,26],[15,8,15,9],[15,11,15,12],[16,8,16,9],[16,11,16,12],[18,14,18,15],[15,14,15,15],[16,14,16,15],[17,14,17,15],[4,22,4,24],[14,8,14,9],[14,11,14,12],[14,25,14,26],[13,11,13,12],[13,8,13,9],[13,14,13,15],[13,25,13,26],[14,14,14,15],[35,25,35,26],[20,4,21,7],[20,8,21,9],[20,11,21,12],[24,4,25,7],[24,8,25,9],[24,11,25,12],[22,8,22,9],[22,11,22,12],[26,8,26,9],[26,11,26,12],[38,8,38,9],[38,11,38,12],[38,14,38,15],[29,8,29,9],[35,8,35,9],[35,11,35,12],[35,14,35,15],[37,8,37,9],[36,8,36,9],[36,11,36,12],[40,25,40,26],[36,14,36,15],[36,25,36,26],[37,11,37,12],[37,14,37,15],[42,8,43,9],[42,11,43,12],[44,8,44,9],[44,11,44,12],[39,14,39,15],[40,14,40,15],[51,8,51,9],[46,4,47,7],[46,8,47,9],[46,11,47,12],[48,8,48,9],[48,11,48,12]]}
[null,{"$f":"Start!C2","v":"IPART BILL COMPARATOR"}]
[null,"SECTION 2. YOUR ELECTRICITY CONSUMPTION AND ELECTRICITY OFFER DETAILS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"day",365,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"month",12,{"$f":"365/12","v":30.416666666666668}]
[null,null,{"$f":"\"1.\"","v":"1."},"Enter your annual electricity consumption",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"quarter",4,{"$f":"365/4","v":91.25}]
[null,null,null,null,"Standard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum",null,null,null,null,null,null,null,"year",1,365]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"usage rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total bill"]
[]
[null,null,{"$f":"\"2.\"","v":"2."},"Enter the details of the two electricity offers you wish to compare"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"if all consumption, calculate it daily"]
[null,null,null,null,"OFFER 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"con",{"$f":"W5/IF(L15=0,365,INDEX($AI$2:$AI$5,MATCH(L15,$AH$2:$AH$5,0)))","v":0},{"$f":"\"per \"&IF(L15=0,\"day\",L15)","v":"per day"},null,null,null,null,null,"Before discount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar used",{"$f":"IF('Section 1 Your details'!$U$9=1,0,solar_generation*solar_usage*IF(L15=0,1,INDEX($AJ$2:$AJ$5,MATCH(L15,$AH$2:$AH$5,0))))","v":3.0542465753424657},{"$f":"AJ12","v":"per day"},null,null,null,null,null,"Usage",{"$f":"AN15","v":0}]
[null,null,null,null,"Standard ",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"net  of solar",{"$f":"AI12-AI13","v":-3.0542465753424657},null,null,null,"bill per annum",null,null,"Supply",{"$f":"AN16","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$15>0,$Z$15,O15)","v":0},{"$f":"IF(I15>0,MIN(AI14,I15),AI14)","v":-3.0542465753424657},null,null,null,"usage",{"$f":"SUMPRODUCT(AI15:AI18,AH15:AH18)/100*IF(L15=0,365,INDEX($AI$2:$AI$5,MATCH(L15,$AH$2:$AH$5,0)))","v":0},null,"Fee",{"$f":"AN26","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$15>0,0,O16)","v":0},{"$f":"IF(I16>0,MAX(0,MIN(I16,AI14-AI15)),\"\")","v":""},null,null,null,"supply",{"$f":"AH19/100*365","v":0},null,"Total",{"$f":"SUM(AQ13:AQ15)","v":0},{"$f":"AQ16*1.1","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$15>0,0,O17)","v":0},{"$f":"IF(I17>0,MAX(0,MIN(I17,AI14-SUM(AI15:AI16))),\"\")","v":""},null,null,null,"check",{"$f":"SUM(AI15:AI18)-AI14","v":0},null,"After discount"]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$15>0,0,O18)","v":0},{"$f":"MAX(0,AI14-SUM(AI15:AI17))","v":0},null,null,null,null,null,null,"Usage",{"$f":"AQ13*(1-I23)","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day",null,null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day",null,null,null,null,null,{"$f":"IF($Z$15>0,Z19,O19)","v":0},null,null,null,null,null,null,null,"Supply",{"$f":"AQ14*(1-IF(L23=$AH$7,I23))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AP15","v":"Fee"},{"$f":"AQ15","v":0}]
[null,null,null,null,"Available discounts",null,null,null,"Discount percentage",null,null,"Discount applies to usage rate or total bill?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AQ18:AQ20)","v":0},{"$f":"AQ21*1.1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed-in tariff"]
[null,null,null,null,"Guaranteed discount",null,null,null,null,null,"on",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"AN30","v":0}]
[]
[null,null,null,null,"Subscription or membership fee",null,null,null,"Fee                 ($, ex-GST)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fee",{"$f":"IF(I27=0,0,I27*(IF(L27=0,1,INDEX($AI$2:$AI$5,MATCH(L27,$AH$2:$AH$5,0)))))","v":0},"if frequency of membership fee is not specified, the default is \"per annum\""]
[null,null,null,null,null,null,null,null,null,null,"per"]
[]
[null,null,null,null,"Feed-in tariff",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar left",{"$f":"IF('Section 1 Your details'!$U$6=0,0,solar_generation-AI13/IF(L15=0,1,INDEX($AJ$2:$AJ$5,MATCH(L15,$AH$2:$AH$5,0))))","v":7.1265753424657525},"per day"]
[null,null,null,null,null,null,null,null,null,null,"cents","per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total credit",{"$f":"AI29*I30/100","v":0},"per day",null,null,"credit per annum",{"$f":"AI30*365","v":0}]
[]
[]
[]
[null,null,null,null,"OFFER 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"con",{"$f":"W5/IF(L37=0,365,INDEX($AI$2:$AI$5,MATCH(L37,$AH$2:$AH$5,0)))","v":0},{"$f":"\"per \"&IF(L37=0,\"day\",L37)","v":"per day"},null,null,null,null,null,"Before discount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar used",{"$f":"IF('Section 1 Your details'!$U$9=1,0,solar_generation*solar_usage*IF(L37=0,1,INDEX($AJ$2:$AJ$5,MATCH(L37,$AH$2:$AH$5,0))))","v":3.0542465753424657},{"$f":"AJ34","v":"per day"},null,null,null,null,null,"Usage",{"$f":"AN37","v":0}]
[null,null,null,null,"Standard ",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"net  of solar",{"$f":"AI34-AI35","v":-3.0542465753424657},null,null,null,"bill per annum",null,null,"Supply",{"$f":"AN38","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$37>0,$Z$37,O37)","v":0},{"$f":"IF(I37>0,MIN(AI36,I37),AI36)","v":-3.0542465753424657},null,null,null,"usage",{"$f":"SUMPRODUCT(AI37:AI40,AH37:AH40)/100*IF(L37=0,365,INDEX($AI$2:$AI$5,MATCH(L37,$AH$2:$AH$5,0)))","v":0},null,"Fee",{"$f":"AN48","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$37>0,0,O38)","v":0},{"$f":"IF(I38>0,MAX(0,MIN(I38,AI36-AI37)),\"\")","v":""},null,null,null,"supply",{"$f":"AH41/100*365","v":0},null,"Total",{"$f":"SUM(AQ35:AQ37)","v":0},{"$f":"AQ38*1.1","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$37>0,0,O39)","v":0},{"$f":"IF(I39>0,MAX(0,MIN(I39,AI36-SUM(AI37:AI38))),\"\")","v":""},null,null,null,"check",{"$f":"SUM(AI37:AI40)-AI36","v":0},null,"After discount"]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"MAX(0,AI36-SUM(AI37:AI39))","v":0},null,null,null,null,null,null,"Usage",{"$f":"AQ35*(1-I45)","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day",null,null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day","day",null,null,null,null,{"$f":"IF($Z$37>0,Z41,O41)","v":0},null,null,null,null,null,null,null,"Supply",{"$f":"AQ36*(1-IF(L45=$AH$7,I45))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AP37","v":"Fee"},{"$f":"AQ37","v":0}]
[null,null,null,null,"Available discounts",null,null,null,"Discount percentage",null,null,"Discount applies to usage rate or total bill?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AQ40:AQ42)","v":0},{"$f":"AQ43*1.1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed-in tariff"]
[null,null,null,null,"Guaranteed discount",null,null,null,null,null,"on",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"AN52","v":0}]
[]
[null,null,null,null,"Subscription or membership fee",null,null,null,"Fee                 ($, ex-GST)",null,null,"Per day, month, quarter or year?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fee",{"$f":"IF(I49=0,0,I49*(IF(L49=0,1,INDEX($AI$2:$AI$5,MATCH(L49,$AH$2:$AH$5,0)))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,"per"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar left",{"$f":"IF('Section 1 Your details'!$U$6=0,0,solar_generation-AI35/IF(L37=0,1,INDEX($AJ$2:$AJ$5,MATCH(L37,$AH$2:$AH$5,0))))","v":7.1265753424657525},"per day"]
[null,null,null,null,"Feed-in tariff",null,null,null,null,null,"cents","per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total credit",{"$f":"AI51*I52/100","v":0},"per day",null,null,"credit per annum",{"$f":"AI52*365","v":0}]
[]
[]
[]
[]
[null,null,{"$f":"\"3.\"","v":"3."},"Proceed to see the results"]

{"sheet":"Section 2.C","index":4,"n_rows":115,"n_cols":42,"rows_kept":115,"cut":false,"hidden":false,"merged":[[43,4,43,6],[93,4,93,6],[93,8,93,9],[93,11,93,12],[22,8,22,9],[22,11,22,12],[29,8,29,9],[29,11,29,12],[36,8,36,9],[36,11,36,12],[39,8,39,9],[39,11,39,12],[45,8,45,9],[45,11,45,12],[46,8,46,9],[24,8,24,9],[24,11,24,12],[25,8,25,9],[75,8,75,9],[75,11,75,12],[73,8,73,9],[73,11,73,12],[74,8,74,9],[31,8,31,9],[90,14,90,15],[91,14,91,15],[91,25,91,26],[65,11,65,12],[43,8,43,9],[43,11,43,12],[65,8,65,9],[88,8,88,9],[88,11,88,12],[88,14,88,15],[89,8,89,9],[89,11,89,12],[89,14,89,15],[46,11,46,12],[65,14,65,15],[65,25,65,26],[72,25,72,26],[79,25,79,26],[86,25,86,26],[86,8,86,9],[86,11,86,12],[41,25,41,26],[83,14,83,15],[80,25,80,26],[66,25,66,26],[70,25,70,26],[59,8,59,9],[52,8,52,9],[52,11,52,12],[56,8,56,9],[56,11,56,12],[68,8,68,9],[68,11,68,12],[72,14,72,15],[79,14,79,15],[74,11,74,12],[80,8,80,9],[44,14,44,15],[45,14,45,15],[46,14,46,15],[106,8,106,9],[106,11,106,12],[109,8,109,9],[80,11,80,12],[75,14,75,15],[76,14,76,15],[80,14,80,15],[66,8,66,9],[66,11,66,12],[94,14,94,15],[95,14,95,15],[96,14,96,15],[66,14,66,15],[67,14,67,15],[68,14,68,15],[69,14,69,15],[73,14,73,15],[74,14,74,15],[70,14,70,15],[104,8,105,9],[82,8,82,9],[82,11,82,12],[67,8,67,9],[67,11,67,12],[19,14,19,15],[23,14,23,15],[24,14,24,15],[25,14,25,15],[26,14,26,15],[30,14,30,15],[23,8,23,9],[23,11,23,12],[39,14,39,15],[20,14,20,15],[32,11,32,12],[31,14,31,15],[38,8,38,9],[38,11,38,12],[38,14,38,15],[31,11,31,12],[37,11,37,12],[37,14,37,15],[47,14,47,15],[54,8,55,9],[40,14,40,15],[37,8,37,9],[97,14,97,15],[94,8,94,9],[94,11,94,12],[94,25,94,26],[95,11,95,12],[96,8,96,9],[96,11,96,12],[86,14,86,15],[93,14,93,15],[87,8,87,9],[93,25,93,26],[50,8,51,9],[50,11,51,12],[73,25,73,26],[87,14,87,15],[87,25,87,26],[81,14,81,15],[82,14,82,15],[37,25,37,26],[41,14,41,15],[20,25,20,26],[44,8,44,9],[44,11,44,12],[44,25,44,26],[23,25,23,26],[25,11,25,12],[43,14,43,15],[43,25,43,26],[17,8,17,9],[17,11,17,12],[18,8,18,9],[18,11,18,12],[22,25,22,26],[22,14,22,15],[29,14,29,15],[29,25,29,26],[36,14,36,15],[36,25,36,26],[32,14,32,15],[33,14,33,15],[30,8,30,9],[30,11,30,12],[30,25,30,26],[32,8,32,9],[17,14,17,15],[18,14,18,15],[4,22,4,24],[8,22,8,24],[16,8,16,9],[16,11,16,12],[16,25,16,26],[9,22,9,24],[15,11,15,12],[15,8,15,9],[15,14,15,15],[15,25,15,26],[5,22,5,24],[6,22,6,24],[7,22,7,24],[16,14,16,15],[100,8,101,9],[100,11,101,12],[54,4,55,7],[54,11,55,12],[104,4,105,7],[104,11,105,12],[81,8,81,9],[81,11,81,12],[95,8,95,9],[87,11,87,12],[72,8,72,9],[72,11,72,12],[79,8,79,9],[79,11,79,12],[102,8,102,9],[102,11,102,12]]}
[null,{"$f":"Start!C2","v":"IPART BILL COMPARATOR"}]
[null,"SECTION 2. YOUR ELECTRICITY CONSUMPTION AND ELECTRICITY OFFER DETAILS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"day",365,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"month",12,{"$f":"365/12","v":30.416666666666668}]
[null,null,{"$f":"\"1.\"","v":"1."},"Enter your annual electricity consumption",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"quarter",4,{"$f":"365/4","v":91.25}]
[null,null,null,null,"Standard/Peak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum",null,null,null,null,null,null,null,"year",1,365]
[null,null,null,null,"Offpeak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum",null,null,null,null,null,null,null,"usage rate"]
[null,null,null,null,"Shoulder period 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum",null,null,null,null,null,null,null,"total bill"]
[null,null,null,null,"Shoulder period 2 (if applicable)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum"]
[null,null,null,null,"Controlled load 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum"]
[null,null,null,null,"Controlled load 2 (if applicable)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum"]
[null,null,{"$f":"\"2.\"","v":"2."},"Enter the details of the two electricity offers you wish to compare"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Before discount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usage",{"$f":"AL15+AL24+AL31+AL38+AL45","v":0}]
[null,null,null,null,"OFFER 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"con",{"$f":"W5/IF(L17=0,365,INDEX($AI$2:$AI$5,MATCH(L17,$AH$2:$AH$5,0)))","v":0},{"$f":"\"per \"&IF(L17=0,\"day\",L17)","v":"per day"},"bill per annum",null,null,"Supply",{"$f":"AL16+AL25+AL32+AL39+AL46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar used",{"$f":"IF('Section 1 Your details'!$U$9=1,0,solar_generation*solar_usage*IF(L17=0,1,INDEX($AJ$2:$AJ$5,MATCH(L17,$AH$2:$AH$5,0))))","v":3.0542465753424657},{"$f":"AJ14","v":"per day"},"usage",{"$f":"SUMPRODUCT(AI17:AI20,AH17:AH20)/100*IF(L17=0,365,INDEX($AI$2:$AI$5,MATCH(L17,$AH$2:$AH$5,0)))","v":0},null,"Fee",{"$f":"AL57","v":0}]
[null,null,null,null,"Standard/Peak ",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"net  of solar",{"$f":"AI14-AI15","v":-3.0542465753424657},null,"supply",{"$f":"AH21/100*365","v":0},null,"Total",{"$f":"SUM(AO13:AO15)","v":0},{"$f":"AO16*1.1","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$17>0,$Z$17,O17)","v":0},{"$f":"IF(I17>0,MIN(AI16,I17),AI16)","v":-3.0542465753424657},null,"check",{"$f":"SUM(AI17:AI20)-AI16","v":0},null,"After discount"]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$17>0,0,O18)","v":0},{"$f":"IF(I18>0,MAX(0,MIN(I18,AI16-AI17)),\"\")","v":""},null,null,null,null,"Usage",{"$f":"AO13*(1-I53)","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$17>0,0,O19)","v":0},{"$f":"IF(I19>0,MAX(0,MIN(I19,AI16-SUM(AI17:AI18))),\"\")","v":""},null,null,null,null,"Supply",{"$f":"AO14*(1-IF(L53=$AH$7,I53))","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$17>0,0,O20)","v":0},{"$f":"MAX(0,AI16-SUM(AI17:AI19))","v":0},null,null,null,null,{"$f":"AN15","v":"Fee"},{"$f":"AO15","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day",null,null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day",null,null,null,null,null,{"$f":"IF($Z$17>0,Z21,O21)","v":0},null,null,null,null,null,"Total",{"$f":"SUM(AO18:AO20)","v":0},{"$f":"AO21*1.1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed-in tariff"]
[null,null,null,null,"Off peak",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"W6/IF(L24=0,365,INDEX($AI$2:$AI$5,MATCH(L24,$AH$2:$AH$5,0)))","v":0},null,"bill per annum",null,null,"Total",{"$f":"AL60","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$24>0,$Z$24,O24)","v":0},{"$f":"IF(I24>0,MIN(AI23,I24),AI23)","v":0},null,"usage",{"$f":"SUMPRODUCT(AI24:AI27,AH24:AH27)/100*IF(L24=0,365,INDEX($AI$2:$AI$5,MATCH(L24,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$24>0,0,O25)","v":0},{"$f":"IF(I25>0,MAX(0,MIN(I25,AI23-AI24)),\"\")","v":""}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$24>0,0,O26)","v":0},{"$f":"IF(I26>0,MAX(0,MIN(I26,AI23-SUM(AI24:AI25))),\"\")","v":""},null,"check",{"$f":"SUM(AI24:AI27)-AI23","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$24>0,0,O27)","v":0},{"$f":"MAX(0,AI23-SUM(AI24:AI26))","v":0}]
[]
[]
[null,null,null,null,"Shoulder",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"SUM(W7:Y8)/IF(L31=0,365,INDEX($AH$2:$AH$5,MATCH(L31,#REF!,0)))","v":0},null,"bill per annum"]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$31>0,$Z$31,O31)","v":0},{"$f":"IF(I31>0,MIN(AI30,I31),AI30)","v":0},null,"usage",{"$f":"SUMPRODUCT(AI31:AI34,AH31:AH34)/100*IF(L31=0,365,INDEX($AI$2:$AI$5,MATCH(L31,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$31>0,0,O32)","v":0},{"$f":"IF(I32>0,MAX(0,MIN(I32,AI30-AI31)),\"\")","v":""}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$31>0,0,O33)","v":0},{"$f":"IF(I33>0,MAX(0,MIN(I33,AI30-SUM(AI31:AI32))),\"\")","v":""},null,"check",{"$f":"SUM(AI31:AI34)-AI30","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$31>0,0,O34)","v":0},{"$f":"MAX(0,AI30-SUM(AI31:AI33))","v":0}]
[]
[]
[null,null,null,null,"Controlled Load 1",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"W9/IF(L38=0,365,INDEX($AI$2:$AI$5,MATCH(L38,$AH$2:$AH$5,0)))","v":0},null,"bill per annum"]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$38>0,$Z$38,O38)","v":0},{"$f":"IF(I38>0,MIN(AI37,I38),AI37)","v":0},null,"usage",{"$f":"SUMPRODUCT(AI38:AI41,AH38:AH41)/100*IF(L38=0,365,INDEX($AI$2:$AI$5,MATCH(L38,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$38>0,0,O39)","v":0},{"$f":"IF(I39>0,MAX(0,MIN(I39,AI37-AI38)),\"\")","v":""},null,"supply",{"$f":"AH42/100*365","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$38>0,0,O40)","v":0},{"$f":"IF(I40>0,MAX(0,MIN(I40,AI37-SUM(AI38:AI39))),\"\")","v":""},null,"check",{"$f":"SUM(AI38:AI41)-AI37","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$38>0,0,O41)","v":0},{"$f":"MAX(0,AI37-SUM(AI38:AI40))","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day",null,null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day",null,null,null,null,null,{"$f":"IF($Z$17>0,Z42,O42)","v":0}]
[]
[null,null,null,null,"Controlled Load 2 (if applicable)",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"W10/IF(L45=0,365,INDEX($AI$2:$AI$5,MATCH(L45,$AH$2:$AH$5,0)))","v":0},null,"bill per annum"]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$45>0,$Z$45,O45)","v":0},{"$f":"IF(I45>0,MIN(AI44,I45),AI44)","v":0},null,"usage",{"$f":"SUMPRODUCT(AI45:AI48,AH45:AH48)/100*IF(L45=0,365,INDEX($AI$2:$AI$5,MATCH(L45,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$45>0,0,O46)","v":0},{"$f":"IF(I46>0,MAX(0,MIN(I46,AI44-AI45)),\"\")","v":""}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$45>0,0,O47)","v":0},{"$f":"IF(I47>0,MAX(0,MIN(I47,AI44-SUM(AI45:AI46))),\"\")","v":""},null,"check",{"$f":"SUM(AI45:AI48)-AI44","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$45>0,0,O48)","v":0},{"$f":"MAX(0,AI44-SUM(AI45:AI47))","v":0}]
[]
[]
[null,null,null,null,"Available discounts",null,null,null,"Discount percentage",null,null,"Discount applies to using rate or total bill?"]
[]
[null,null,null,null,"Guaranteed discount",null,null,null,null,null,"on"]
[]
[null,null,null,null,"Subscription or membership fee",null,null,null,"Fee                 ($, ex-GST)",null,null,"Per day, month, quarter and year?"]
[]
[null,null,null,null,null,null,null,null,null,null,"per",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fee",{"$f":"IF(I57=0,0,I57*(IF(L57=0,1,INDEX($AI$2:$AI$5,MATCH(L57,$AH$2:$AH$5,0)))))","v":0},"if frequency of membership fee is not specified, the default is \"per annum\""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar left",{"$f":"IF('Section 1 Your details'!$U$6=0,0,solar_generation-AI15/IF(L17=0,1,INDEX($AJ$2:$AJ$5,MATCH(L17,$AH$2:$AH$5,0))))","v":7.1265753424657525},"per day"]
[null,null,null,null,"Feed-in tariff",null,null,null,null,null,"cents","per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total credit",{"$f":"AI59*I60/100","v":0},"per day","credit per annum",{"$f":"AI60*365","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Before discount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usage",{"$f":"AL65+AL74+AL81+AL88+AL95","v":0}]
[null,null,null,null,"OFFER 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"con",{"$f":"W5/IF(L67=0,365,INDEX($AI$2:$AI$5,MATCH(L67,$AH$2:$AH$5,0)))","v":0},{"$f":"\"per \"&IF(L67=0,\"day\",L67)","v":"per day"},"bill per annum",null,null,"Supply",{"$f":"AL66+AL75+AL82+AL89+AL96","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar used",{"$f":"IF('Section 1 Your details'!$U$9=1,0,solar_generation*solar_usage*IF(L67=0,1,INDEX($AJ$2:$AJ$5,MATCH(L67,$AH$2:$AH$5,0))))","v":3.0542465753424657},{"$f":"AJ64","v":"per day"},"usage",{"$f":"SUMPRODUCT(AI67:AI70,AH67:AH70)/100*IF(L67=0,365,INDEX($AI$2:$AI$5,MATCH(L67,$AH$2:$AH$5,0)))","v":0},null,"Fee",{"$f":"AL107","v":0}]
[null,null,null,null,"Standard/Peak ",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"net  of solar",{"$f":"AI64-AI65","v":-3.0542465753424657},null,"supply",{"$f":"AH71/100*365","v":0},null,"Total",{"$f":"SUM(AO63:AO65)","v":0},{"$f":"AO66*1.1","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$67>0,$Z$67,O67)","v":0},{"$f":"IF(I67>0,MIN(AI66,I67),AI66)","v":-3.0542465753424657},null,"check",{"$f":"SUM(AI67:AI70)-AI66","v":0},null,"After discount"]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$67>0,0,O68)","v":0},{"$f":"IF(I68>0,MAX(0,MIN(I68,AI66-AI67)),\"\")","v":""},null,null,null,null,"Usage",{"$f":"AO63*(1-I103)","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$67>0,0,O69)","v":0},{"$f":"IF(I69>0,MAX(0,MIN(I69,AI66-SUM(AI67:AI68))),\"\")","v":""},null,null,null,null,"Supply",{"$f":"AO64*(1-IF(L103=$AH$7,I103))","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$67>0,0,O70)","v":0},{"$f":"MAX(0,AI66-SUM(AI67:AI69))","v":0},null,null,null,null,{"$f":"AN65","v":"Fee"},{"$f":"AO65","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day",null,null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day",null,null,null,null,null,{"$f":"IF($Z$67>0,Z71,O71)","v":0},null,null,null,null,null,"Total",{"$f":"SUM(AO68:AO70)","v":0},{"$f":"AO71*1.1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed-in tariff"]
[null,null,null,null,"Off peak",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"W6/IF(L74=0,365,INDEX($AI$2:$AI$5,MATCH(L74,$AH$2:$AH$5,0)))","v":0},null,"bill per annum",null,null,"Total",{"$f":"AL110","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$74>0,$Z$74,O74)","v":0},{"$f":"IF(I74>0,MIN(AI73,I74),AI73)","v":0},null,"usage",{"$f":"SUMPRODUCT(AI74:AI77,AH74:AH77)/100*IF(L74=0,365,INDEX($AI$2:$AI$5,MATCH(L74,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$74>0,0,O75)","v":0},{"$f":"IF(I75>0,MAX(0,MIN(I75,AI73-AI74)),\"\")","v":""}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$74>0,0,O76)","v":0},{"$f":"IF(I76>0,MAX(0,MIN(I76,AI73-SUM(AI74:AI75))),\"\")","v":""},null,"check",{"$f":"SUM(AI74:AI77)-AI73","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$74>0,0,O77)","v":0},{"$f":"MAX(0,AI73-SUM(AI74:AI76))","v":0}]
[]
[]
[null,null,null,null,"Shoulder",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"SUM(W7:Y8)/IF(L81=0,365,INDEX($AI$2:$AI$5,MATCH(L81,$AH$2:$AH$5,0)))","v":0},null,"bill per annum"]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$81>0,$Z$81,O81)","v":0},{"$f":"IF(I81>0,MIN(AI80,I81),AI80)","v":0},null,"usage",{"$f":"SUMPRODUCT(AI81:AI84,AH81:AH84)/100*IF(L81=0,365,INDEX($AI$2:$AI$5,MATCH(L81,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$81>0,0,O82)","v":0},{"$f":"IF(I82>0,MAX(0,MIN(I82,AI80-AI81)),\"\")","v":""}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$81>0,0,O83)","v":0},{"$f":"IF(I83>0,MAX(0,MIN(I83,AI80-SUM(AI81:AI82))),\"\")","v":""},null,"check",{"$f":"SUM(AI81:AI84)-AI80","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$81>0,0,O84)","v":0},{"$f":"MAX(0,AI80-SUM(AI81:AI83))","v":0}]
[]
[]
[null,null,null,null,"Controlled Load 1",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"W9/IF(L88=0,365,INDEX($AI$2:$AI$5,MATCH(L88,$AH$2:$AH$5,0)))","v":0},null,"bill per annum"]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$88>0,$Z$88,O88)","v":0},{"$f":"IF(I88>0,MIN(AI87,I88),AI87)","v":0},null,"usage",{"$f":"SUMPRODUCT(AI88:AI91,AH88:AH91)/100*IF(L88=0,365,INDEX($AI$2:$AI$5,MATCH(L88,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$88>0,0,O89)","v":0},{"$f":"IF(I89>0,MAX(0,MIN(I89,AI87-AI88)),\"\")","v":""},null,"supply",{"$f":"AH92/100*365","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$88>0,0,O90)","v":0},{"$f":"IF(I90>0,MAX(0,MIN(I90,AI87-SUM(AI88:AI89))),\"\")","v":""},null,"check",{"$f":"SUM(AI88:AI91)-AI87","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$88>0,0,O91)","v":0},{"$f":"MAX(0,AI87-SUM(AI88:AI90))","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day",null,null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day",null,null,null,null,null,{"$f":"IF($Z$88>0,Z92,O92)","v":0}]
[]
[null,null,null,null,"Controlled Load 2 (if applicable)",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"W10/IF(L95=0,365,INDEX($AI$2:$AI$5,MATCH(L95,$AH$2:$AH$5,0)))","v":0},null,"bill per annum"]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$95>0,$Z$95,O95)","v":0},{"$f":"IF(I95>0,MIN(AI94,I95),AI94)","v":0},null,"usage",{"$f":"SUMPRODUCT(AI95:AI98,AH95:AH98)/100*IF(L95=0,365,INDEX($AI$2:$AI$5,MATCH(L95,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$95>0,0,O96)","v":0},{"$f":"IF(I96>0,MAX(0,MIN(I96,AI94-AI95)),\"\")","v":""}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$95>0,0,O97)","v":0},{"$f":"IF(I97>0,MAX(0,MIN(I97,AI94-SUM(AI95:AI96))),\"\")","v":""},null,"check",{"$f":"SUM(AI95:AI98)-AI94","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$95>0,0,O98)","v":0},{"$f":"MAX(0,AI94-SUM(AI95:AI97))","v":0}]
[]
[]
[null,null,null,null,"Available discounts",null,null,null,"Discount percentage",null,null,"Discount applies to using rate or total bill?"]
[]
[null,null,null,null,"Guaranteed discount",null,null,null,null,null,"on"]
[]
[null,null,null,null,"Subscription or membership fee",null,null,null,"Fee                 ($, ex-GST)",null,null,"Per day, month, quarter and year?"]
[]
[null,null,null,null,null,null,null,null,null,null,"per",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fee",{"$f":"IF(I107=0,0,I107*(IF(L107=0,1,INDEX($AI$2:$AI$5,MATCH(L107,$AH$2:$AH$5,0)))))","v":0},"if frequency of membership fee is not specified, the default is \"per annum\""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar left",{"$f":"IF('Section 1 Your details'!$U$6=0,0,solar_generation-AI65/IF(L67=0,1,INDEX($AJ$2:$AJ$5,MATCH(L67,$AH$2:$AH$5,0))))","v":7.1265753424657525},"per day"]
[null,null,null,null,"Feed-in tariff",null,null,null,null,null,"cents","per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total credit",{"$f":"AI109*I110/100","v":0},"per day","credit per annum",{"$f":"AI110*365","v":0}]
[]
[]
[]
[]
[null,null,{"$f":"\"3.\"","v":"3."},"Proceed to see the results"]

{"sheet":"Section 2.D","index":5,"n_rows":87,"n_cols":42,"rows_kept":87,"cut":false,"hidden":false,"merged":[[52,25,52,26],[51,14,51,15],[51,25,51,26],[67,8,67,9],[16,14,16,15],[17,14,17,15],[18,14,18,15],[19,14,19,15],[23,14,23,15],[24,14,24,15],[25,14,25,15],[60,8,60,9],[60,11,60,12],[55,14,55,15],[53,8,53,9],[53,11,53,12],[54,8,54,9],[54,14,54,15],[33,14,33,15],[52,14,52,15],[53,14,53,15],[54,11,54,12],[45,8,45,9],[51,8,51,9],[51,11,51,12],[6,22,6,24],[7,22,7,24],[52,8,52,9],[52,11,52,12],[38,8,38,9],[38,11,38,12],[32,8,32,9],[29,8,29,9],[29,11,29,12],[25,11,25,12],[26,14,26,15],[18,11,18,12],[20,14,20,15],[32,11,32,12],[30,14,30,15],[31,14,31,15],[32,14,32,15],[36,8,37,9],[36,11,37,12],[40,8,41,9],[4,22,4,24],[5,22,5,24],[15,14,15,15],[22,14,22,15],[29,14,29,15],[18,8,18,9],[15,8,15,9],[15,11,15,12],[16,8,16,9],[16,11,16,12],[17,8,17,9],[17,11,17,12],[22,8,22,9],[22,11,22,12],[23,8,23,9],[23,11,23,12],[24,8,24,9],[24,11,24,12],[25,8,25,9],[40,4,41,7],[40,11,41,12],[42,8,42,9],[42,11,42,12],[15,25,15,26],[22,25,22,26],[29,25,29,26],[30,8,30,9],[30,11,30,12],[31,8,31,9],[31,11,31,12],[23,25,23,26],[16,25,16,26],[20,25,20,26],[30,25,30,26],[59,8,59,9],[59,11,59,12],[59,14,59,15],[59,25,59,26],[60,14,60,15],[56,14,56,15],[56,25,56,26],[58,8,58,9],[58,11,58,12],[58,14,58,15],[58,25,58,26],[65,8,65,9],[65,11,65,12],[65,14,65,15],[65,25,65,26],[61,8,61,9],[61,11,61,12],[61,14,61,15],[62,14,62,15],[68,8,68,9],[68,11,68,12],[68,14,68,15],[69,14,69,15],[66,8,66,9],[66,11,66,12],[66,14,66,15],[66,25,66,26],[67,11,67,12],[67,14,67,15],[81,8,81,9],[76,4,77,7],[76,11,77,12],[78,8,78,9],[78,11,78,12],[72,8,73,9],[72,11,73,12],[74,8,74,9],[74,11,74,12],[76,8,77,9]]}
[null,{"$f":"Start!C2","v":"IPART BILL COMPARATOR"}]
[null,"SECTION 2. YOUR ELECTRICITY CONSUMPTION AND ELECTRICITY OFFER DETAILS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"day",365,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"month",12,{"$f":"365/12","v":30.416666666666668}]
[null,null,{"$f":"\"1.\"","v":"1."},"Enter your annual electricity consumption",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"quarter",4,{"$f":"365/4","v":91.25}]
[null,null,null,null,"Standard/Peak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum",null,null,null,null,null,null,null,"year",1,365]
[null,null,null,null,"Offpeak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum",null,null,null,null,null,null,null,"usage rate"]
[null,null,null,null,"Shoulder period 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum",null,null,null,null,null,null,null,"total bill"]
[null,null,null,null,"Shoulder period 2 (if applicable)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh per annum"]
[]
[]
[null,null,{"$f":"\"2.\"","v":"2."},"Enter the details of the two electricity offers you wish to compare"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Before discount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usage",{"$f":"AL15+AL24+AL31","v":0}]
[null,null,null,null,"OFFER 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"con",{"$f":"W5/IF(L17=0,365,INDEX($AI$2:$AI$5,MATCH(L17,$AH$2:$AH$5,0)))","v":0},{"$f":"\"per \"&IF(L17=0,\"day\",L17)","v":"per day"},"bill per annum",null,null,"Supply",{"$f":"AL16+AL25+AL32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar used",{"$f":"IF('Section 1 Your details'!$U$9=1,0,solar_generation*solar_usage*IF(L17=0,1,INDEX($AJ$2:$AJ$5,MATCH(L17,$AH$2:$AH$5,0))))","v":3.0542465753424657},{"$f":"AJ14","v":"per day"},"usage",{"$f":"SUMPRODUCT(AI17:AI20,AH17:AH20)/100*IF(L17=0,365,INDEX($AI$2:$AI$5,MATCH(L17,$AH$2:$AH$5,0)))","v":0},null,"Fee",{"$f":"AL43","v":0}]
[null,null,null,null,"Standard/Peak ",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"net  of solar",{"$f":"AI14-AI15","v":-3.0542465753424657},null,"supply",{"$f":"AH21/100*365","v":0},null,"Total",{"$f":"SUM(AO13:AO15)","v":0},{"$f":"AO16*1.1","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$17>0,$Z$17,O17)","v":0},{"$f":"IF(I17>0,MIN(AI16,I17),AI16)","v":-3.0542465753424657},null,"check",{"$f":"SUM(AI17:AI20)-AI16","v":0},null,"After discount"]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$17>0,0,O18)","v":0},{"$f":"IF(I18>0,MAX(0,MIN(I18,AI16-AI17)),\"\")","v":""},null,null,null,null,"Usage",{"$f":"AO13*(1-I39)","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$17>0,0,O19)","v":0},{"$f":"IF(I19>0,MAX(0,MIN(I19,AI16-SUM(AI17:AI18))),\"\")","v":""},null,null,null,null,"Supply",{"$f":"AO14*(1-IF(L39=$AH$7,I39))","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$17>0,0,O20)","v":0},{"$f":"MAX(0,AI16-SUM(AI17:AI19))","v":0},null,null,null,null,{"$f":"AN15","v":"Fee"},{"$f":"AO15","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day",null,null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day",null,null,null,null,null,{"$f":"IF($Z$17>0,Z21,O21)","v":0},null,null,null,null,null,"Total",{"$f":"SUM(AO18:AO20)","v":0},{"$f":"AO21*1.1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed-in tariff"]
[null,null,null,null,"Off peak",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"W6/IF(L24=0,365,INDEX($AI$2:$AI$5,MATCH(L24,$AH$2:$AH$5,0)))","v":0},null,"bill per annum",null,null,"Total",{"$f":"AL46","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$24>0,$Z$24,O24)","v":0},{"$f":"IF(I24>0,MIN(AI23,I24),AI23)","v":0},null,"usage",{"$f":"SUMPRODUCT(AI24:AI27,AH24:AH27)/100*IF(L24=0,365,INDEX($AI$2:$AI$5,MATCH(L24,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$24>0,0,O25)","v":0},{"$f":"IF(I25>0,MAX(0,MIN(I25,AI23-AI24)),\"\")","v":""}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$24>0,0,O26)","v":0},{"$f":"IF(I26>0,MAX(0,MIN(I26,AI23-SUM(AI24:AI25))),\"\")","v":""},null,"check",{"$f":"SUM(AI24:AI27)-AI23","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$24>0,0,O27)","v":0},{"$f":"MAX(0,AI23-SUM(AI24:AI26))","v":0}]
[]
[]
[null,null,null,null,"Shoulder",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"SUM(W7:Y8)/IF(L31=0,365,INDEX($AH$2:$AH$5,MATCH(L31,#REF!,0)))","v":0},null,"bill per annum"]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$31>0,$Z$31,O31)","v":0},{"$f":"IF(I31>0,MIN(AI30,I31),AI30)","v":0},null,"usage",{"$f":"SUMPRODUCT(AI31:AI34,AH31:AH34)/100*IF(L31=0,365,INDEX($AI$2:$AI$5,MATCH(L31,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$31>0,0,O32)","v":0},{"$f":"IF(I32>0,MAX(0,MIN(I32,AI30-AI31)),\"\")","v":""}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$31>0,0,O33)","v":0},{"$f":"IF(I33>0,MAX(0,MIN(I33,AI30-SUM(AI31:AI32))),\"\")","v":""},null,"check",{"$f":"SUM(AI31:AI34)-AI30","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$31>0,0,O34)","v":0},{"$f":"MAX(0,AI30-SUM(AI31:AI33))","v":0}]
[]
[]
[null,null,null,null,"Available discounts",null,null,null,"Discount percentage",null,null,"Discount applies to using rate or total bill?"]
[]
[null,null,null,null,"Guaranteed discount",null,null,null,null,null,"on"]
[]
[null,null,null,null,"Subscription or membership fee",null,null,null,"Fee                 ($, ex-GST)",null,null,"Per day, month, quarter and year?"]
[]
[null,null,null,null,null,null,null,null,null,null,"per",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fee",{"$f":"IF(I43=0,0,I43*(IF(L43=0,1,INDEX($AI$2:$AI$5,MATCH(L43,$AH$2:$AH$5,0)))))","v":0},"if frequency of membership fee is not specified, the default is \"per annum\""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar left per day",{"$f":"IF('Section 1 Your details'!$U$6=0,0,solar_generation-AI15/IF(L17=0,1,INDEX($AJ$2:$AJ$5,MATCH(L17,$AH$2:$AH$5,0))))","v":7.1265753424657525},"per day"]
[null,null,null,null,"Feed-in tariff",null,null,null,null,null,"cents","per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total credit",{"$f":"AI45*I46/100","v":0},"per day","credit per annum",{"$f":"AI46*365","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Before discount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usage",{"$f":"AL51+AL60+AL67","v":0}]
[null,null,null,null,"OFFER 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"con",{"$f":"W5/IF(L53=0,365,INDEX($AI$2:$AI$5,MATCH(L53,$AH$2:$AH$5,0)))","v":0},{"$f":"\"per \"&IF(L53=0,\"day\",L53)","v":"per day"},"bill per annum",null,null,"Supply",{"$f":"AL52+AL61+AL68","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar used",{"$f":"IF('Section 1 Your details'!$U$9=1,0,solar_generation*solar_usage*IF(L53=0,1,INDEX($AJ$2:$AJ$5,MATCH(L53,$AH$2:$AH$5,0))))","v":3.0542465753424657},{"$f":"AJ50","v":"per day"},"usage",{"$f":"SUMPRODUCT(AI53:AI56,AH53:AH56)/100*IF(L53=0,365,INDEX($AI$2:$AI$5,MATCH(L53,$AH$2:$AH$5,0)))","v":0},null,"Fee",{"$f":"AL79","v":0}]
[null,null,null,null,"Standard/Peak ",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"net  of solar",{"$f":"AI50-AI51","v":-3.0542465753424657},null,"supply",{"$f":"AH57/100*365","v":0},null,"Total",{"$f":"SUM(AO49:AO51)","v":0},{"$f":"AO52*1.1","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$53>0,$Z$53,O53)","v":0},{"$f":"IF(I53>0,MIN(AI52,I53),AI52)","v":-3.0542465753424657},null,"check",{"$f":"SUM(AI53:AI56)-AI52","v":0},null,"After discount"]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$53>0,0,O54)","v":0},{"$f":"IF(I54>0,MAX(0,MIN(I54,AI52-AI53)),\"\")","v":""},null,null,null,null,"Usage",{"$f":"AO49*(1-I75)","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$53>0,0,O55)","v":0},{"$f":"IF(I55>0,MAX(0,MIN(I55,AI52-SUM(AI53:AI54))),\"\")","v":""},null,null,null,null,"Supply",{"$f":"AO50*(1-IF(L75=$AH$7,I75))","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$53>0,0,O56)","v":0},{"$f":"MAX(0,AI52-SUM(AI53:AI55))","v":0},null,null,null,null,{"$f":"AN51","v":"Fee"},{"$f":"AO51","v":0}]
[null,null,null,null,"Daily supply charge",null,null,null,null,null,null,null,null,null,null,null,"cents per day",null,null,null,null,"Daily supply charge",null,null,null,null,null,"cents per day",null,null,null,null,null,{"$f":"IF($Z$53>0,Z57,O57)","v":0},null,null,null,null,null,"Total",{"$f":"SUM(AO54:AO56)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed-in tariff"]
[null,null,null,null,"Off peak",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"W6/IF(L60=0,365,INDEX($AI$2:$AI$5,MATCH(L60,$AH$2:$AH$5,0)))","v":0},null,"bill per annum",null,null,"Total",{"$f":"AL82","v":0}]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$60>0,$Z$60,O60)","v":0},{"$f":"IF(I60>0,MIN(AI59,I60),AI59)","v":0},null,"usage",{"$f":"SUMPRODUCT(AI60:AI63,AH60:AH63)/100*IF(L60=0,365,INDEX($AI$2:$AI$5,MATCH(L60,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$60>0,0,O61)","v":0},{"$f":"IF(I61>0,MAX(0,MIN(I61,AI59-AI60)),\"\")","v":""}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$60>0,0,O62)","v":0},{"$f":"IF(I62>0,MAX(0,MIN(I62,AI59-SUM(AI60:AI61))),\"\")","v":""},null,"check",{"$f":"SUM(AI60:AI63)-AI59","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$60>0,0,O63)","v":0},{"$f":"MAX(0,AI59-SUM(AI60:AI62))","v":0}]
[]
[]
[null,null,null,null,"Shoulder",null,null,null,"Tariff block (kWh)",null,null,"Per day, month, quarter or year?",null,null,"Tariff",null,null,null,null,null,null,null,null,null,null,"Tariff",null,null,null,null,null,null,null,"con",{"$f":"SUM(W7:Y8)/IF(L67=0,365,INDEX($AI$2:$AI$5,MATCH(L67,$AH$2:$AH$5,0)))","v":0},null,"bill per annum"]
[null,null,null,null,"First",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,"OR",null,"All usage",null,null,null,null,null,"cents per kWh",null,null,null,null,null,{"$f":"IF($Z$67>0,$Z$67,O67)","v":0},{"$f":"IF(I67>0,MIN(AI66,I67),AI66)","v":0},null,"usage",{"$f":"SUMPRODUCT(AI67:AI70,AH67:AH70)/100*IF(L67=0,365,INDEX($AI$2:$AI$5,MATCH(L67,$AH$2:$AH$5,0)))","v":0}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$67>0,0,O68)","v":0},{"$f":"IF(I68>0,MAX(0,MIN(I68,AI66-AI67)),\"\")","v":""}]
[null,null,null,null,"Next",null,null,null,null,null,"per",null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$67>0,0,O69)","v":0},{"$f":"IF(I69>0,MAX(0,MIN(I69,AI66-SUM(AI67:AI68))),\"\")","v":""},null,"check",{"$f":"SUM(AI67:AI70)-AI66","v":0}]
[null,null,null,null,"Remaining usage",null,null,null,null,null,null,null,null,null,null,null,"cents per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($Z$67>0,0,O70)","v":0},{"$f":"MAX(0,AI66-SUM(AI67:AI69))","v":0}]
[]
[]
[null,null,null,null,"Available discounts",null,null,null,"Discount percentage",null,null,"Discount applies to using rate or total bill?"]
[]
[null,null,null,null,"Guaranteed discount",null,null,null,null,null,"on"]
[]
[null,null,null,null,"Subscription or membership fee",null,null,null,"Fee                 ($, ex-GST)",null,null,"Per day, month, quarter and year?"]
[]
[null,null,null,null,null,null,null,null,null,null,"per",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fee",{"$f":"IF(I79=0,0,I79*(IF(L79=0,1,INDEX($AI$2:$AI$5,MATCH(L79,$AH$2:$AH$5,0)))))","v":0},"if frequency of membership fee is not specified, the default is \"per annum\""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"solar left per day",{"$f":"IF('Section 1 Your details'!$U$6=0,0,solar_generation-AI51/IF(L53=0,1,INDEX($AJ$2:$AJ$5,MATCH(L53,$AH$2:$AH$5,0))))","v":7.1265753424657525},"per day"]
[null,null,null,null,"Feed-in tariff",null,null,null,null,null,"cents","per kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total credit",{"$f":"AI81*I82/100","v":0},"per day","credit per annum",{"$f":"AI82*365","v":0}]
[]
[]
[]
[]
[null,null,{"$f":"\"3.\"","v":"3."},"Proceed to see the results"]

{"sheet":"Section 3. Result","index":6,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[[8,7,8,9],[8,10,8,12],[9,10,9,12],[9,4,9,6],[10,4,10,6],[9,7,9,9],[10,7,10,9],[10,10,10,12],[20,4,20,6],[21,4,21,6],[22,4,22,6],[18,7,18,9],[18,10,18,12],[11,7,11,9],[11,10,11,12],[28,4,28,6],[28,7,28,9],[28,10,28,12],[27,4,27,6],[19,7,19,9],[20,7,20,9],[21,7,21,9],[22,7,22,9],[19,10,19,12],[20,10,20,12],[21,10,21,12],[22,10,22,12],[25,10,25,12],[19,4,19,6],[31,2,32,2],[31,3,32,4],[33,3,34,5],[33,2,34,2],[25,7,25,9],[25,4,25,6],[44,5,44,7],[44,8,44,10],[53,5,53,9],[53,10,53,14],[24,7,24,9],[24,10,24,12],[27,7,27,9],[27,10,27,12],[24,4,24,6]]}
[null,{"$f":"Start!C2","v":"IPART BILL COMPARATOR"}]
[null,"SECTION 3. RESULTS - COMPARISON OF ELECTRICITY OFFERS"]
[null,"This compares electricity offers based on estimated annual bills."]
[]
[]
[null,null,"1.  Estimated annual bills (excluding GST)"]
[]
[]
[null,null,null,null,null,null,null,"Offer 1",null,null,"Offer 2"]
[null,null,null,null,"BEFORE discount",null,null,{"$f":"INDEX(F47:F52,$E$46)","v":0},null,null,{"$f":"INDEX(I47:I52,$E$46)","v":0}]
[null,null,null,null,"AFTER discount",null,null,{"$f":"INDEX(G47:G52,$E$46)","v":0},null,null,{"$f":"INDEX(J47:J52,$E$46)","v":0}]
[null,null,null,null,{"$f":"IF('Section 1 Your details'!U6=1,\"AFTER discount AND feed-in tariffs\",\" \")","v":"AFTER discount AND feed-in tariffs"},null,null,{"$f":"IF('Section 1 Your details'!U6=1,INDEX(H47:H52,$E$46),\"\")","v":0},null,null,{"$f":"IF('Section 1 Your details'!U6=1,INDEX(K47:K52,$E$46),\"\")","v":0}]
[]
[]
[]
[null,null,"2.  Breakdown of the estimated annual bills (excluding GST)"]
[]
[]
[null,null,null,null,null,null,null,"Offer 1",null,null,"Offer 2"]
[null,null,null,null,"Usage charge",null,null,{"$f":"INDEX(F56:F61,$E$46)","v":0},null,null,{"$f":"INDEX(K56:K61,$E$46)","v":0}]
[null,null,null,null,"Supply charge",null,null,{"$f":"INDEX(G56:G61,$E$46)","v":0},null,null,{"$f":"INDEX(L56:L61,$E$46)","v":0}]
[null,null,null,null,"Subscription fee",null,null,{"$f":"INDEX(H56:H61,$E$46)","v":0},null,null,{"$f":"INDEX(M56:M61,$E$46)","v":0}]
[null,null,null,null,"   Total bill BEFORE discount",null,null,{"$f":"SUM(H20:J22)","v":0},null,null,{"$f":"SUM(K20:M22)","v":0}]
[]
[null,null,null,null,"Discount",null,null,{"$f":"-INDEX(I56:I61,$E$46)","v":0},null,null,{"$f":"-INDEX(N56:N61,$E$46)","v":0}]
[null,null,null,null,"   Total bill AFTER discount",null,null,{"$f":"H23-H25","v":0},null,null,{"$f":"K23-K25","v":0}]
[]
[null,null,null,null,"Feed-in tariff credit",null,null,{"$f":"INDEX(J56:J61,$E$46)","v":0},null,null,{"$f":"INDEX(O56:O61,$E$46)","v":0}]
[null,null,null,null,"   Total bill AFTER discount AND feed-in tariffs",null,null,{"$f":"H26-H28","v":0},null,null,{"$f":"K26-K28","v":0}]
[]
[]
[null,null,"∙","To start over"]
[]
[null,null,"∙","To compare different offers"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Offer 1",null,null,"Offer 2"]
[null,null,null,null,{"$f":"'Section 1 Your details'!F54","v":4},{"$f":"E10","v":"BEFORE discount"},{"$f":"E11","v":"AFTER discount"},{"$f":"E12","v":"AFTER discount AND feed-in tariffs"},{"$f":"F46","v":"BEFORE discount"},{"$f":"G46","v":"AFTER discount"},"AFTER discount AND feed-in tariffs"]
[null,null,null,null,{"$f":"'Section 1 Your details'!I56","v":"Section 2.A: Flat Rate with Controlled Load"},{"$f":"'Section 2.A'!AQ16","v":0},{"$f":"'Section 2.A'!AQ21","v":0},{"$f":"'Section 2.A'!AQ21-'Section 2.A'!AQ23","v":0},{"$f":"'Section 2.A'!AQ52","v":0},{"$f":"'Section 2.A'!AQ57","v":0},{"$f":"'Section 2.A'!AQ57-'Section 2.A'!AQ59","v":0}]
[null,null,null,null,{"$f":"'Section 1 Your details'!I57","v":"Section 2.B: Flat Rate without Controlled Load"},{"$f":"'Section 2.B'!AQ16","v":0},{"$f":"'Section 2.B'!AQ21","v":0},{"$f":"'Section 2.B'!AQ21-'Section 2.B'!AQ23","v":0},{"$f":"'Section 2.B'!AQ38","v":0},{"$f":"'Section 2.B'!AQ43","v":0},{"$f":"'Section 2.B'!AQ43-'Section 2.B'!AQ45","v":0}]
[null,null,null,null,{"$f":"'Section 1 Your details'!I58","v":"Section 2.C: Time of Use Tariff with Controlled Load"},{"$f":"'Section 2.C'!AO16","v":0},{"$f":"'Section 2.C'!AO21","v":0},{"$f":"'Section 2.C'!AO21-'Section 2.C'!AO23","v":0},{"$f":"'Section 2.C'!AO66","v":0},{"$f":"'Section 2.C'!AO71","v":0},{"$f":"'Section 2.C'!AO71-'Section 2.C'!AO73","v":0}]
[null,null,null,null,{"$f":"'Section 1 Your details'!I59","v":"Section 2.D: Time of Use Tariff without Controlled Load"},{"$f":"'Section 2.D'!AO16","v":0},{"$f":"'Section 2.D'!AO21","v":0},{"$f":"'Section 2.D'!AO21-'Section 2.D'!AO23","v":0},{"$f":"'Section 2.D'!AO52","v":0},{"$f":"'Section 2.D'!AO57","v":0},{"$f":"'Section 2.D'!AO57-'Section 2.D'!AO59","v":0}]
[null,null,null,null,{"$f":"'Section 1 Your details'!I60","v":"Section 2.A: Flat Rate with Controlled Load"},{"$f":"F47","v":0},{"$f":"G47","v":0},0,{"$f":"I47","v":0},{"$f":"J47","v":0},0]
[null,null,null,null,{"$f":"'Section 1 Your details'!I61","v":"Section 2.B: Flat Rate without Controlled Load"},{"$f":"F48","v":0},{"$f":"G48","v":0},0,{"$f":"I48","v":0},0,0]
[]
[null,null,null,null,null,"Offer 1",null,null,null,null,"Offer 2"]
[null,null,null,null,null,{"$f":"E20","v":"Usage charge"},{"$f":"E21","v":"Supply charge"},{"$f":"E22","v":"Subscription fee"},{"$f":"E25","v":"Discount"},{"$f":"E28","v":"Feed-in tariff credit"},{"$f":"F55","v":"Usage charge"},{"$f":"G55","v":"Supply charge"},"Subscription fee","Discount","Feed-in tariff credit"]
[null,null,null,null,{"$f":"E47","v":"Section 2.A: Flat Rate with Controlled Load"},{"$f":"'Section 2.A'!AQ13","v":0},{"$f":"'Section 2.A'!AQ14","v":0},{"$f":"'Section 2.A'!AQ15","v":0},{"$f":"'Section 2.A'!AQ21-'Section 2.A'!AQ16","v":0},{"$f":"'Section 2.A'!AQ23","v":0},{"$f":"'Section 2.A'!AQ49","v":0},{"$f":"'Section 2.A'!AQ50","v":0},{"$f":"'Section 2.A'!AQ51","v":0},{"$f":"'Section 2.A'!AQ57-'Section 2.A'!AQ52","v":0},{"$f":"'Section 2.A'!AQ59","v":0}]
[null,null,null,null,{"$f":"E48","v":"Section 2.B: Flat Rate without Controlled Load"},{"$f":"'Section 2.B'!AQ13","v":0},{"$f":"'Section 2.B'!AQ14","v":0},{"$f":"'Section 2.B'!AQ15","v":0},{"$f":"'Section 2.B'!AQ21-'Section 2.B'!AQ16","v":0},{"$f":"'Section 2.B'!AQ23","v":0},{"$f":"'Section 2.B'!AQ35","v":0},{"$f":"'Section 2.B'!AQ36","v":0},{"$f":"'Section 2.B'!AQ37","v":0},{"$f":"'Section 2.B'!AQ43-'Section 2.B'!AQ38","v":0},{"$f":"'Section 2.B'!AQ45","v":0}]
[null,null,null,null,"Section 2.C: Time of Use Tariff with Controlled Load",{"$f":"'Section 2.C'!AO13","v":0},{"$f":"'Section 2.C'!AO14","v":0},{"$f":"'Section 2.C'!AO15","v":0},{"$f":"'Section 2.C'!AO21-'Section 2.C'!AO16","v":0},{"$f":"'Section 2.C'!AO23","v":0},{"$f":"'Section 2.C'!AO63","v":0},{"$f":"'Section 2.C'!AO64","v":0},{"$f":"'Section 2.C'!AO70","v":0},{"$f":"'Section 2.C'!AO71-'Section 2.C'!AO66","v":0},{"$f":"'Section 2.C'!AO73","v":0}]
[null,null,null,null,"Section 2.D: Time of Use Tariff without Controlled Load",{"$f":"'Section 2.D'!AO13","v":0},{"$f":"'Section 2.D'!AO14","v":0},{"$f":"'Section 2.D'!AO15","v":0},{"$f":"'Section 2.D'!AO21-'Section 2.D'!AO16","v":0},{"$f":"'Section 2.D'!AO23","v":0},{"$f":"'Section 2.D'!AO49","v":0},{"$f":"'Section 2.D'!AO50","v":0},{"$f":"'Section 2.D'!AO51","v":0},{"$f":"'Section 2.D'!AO57-'Section 2.D'!AO52","v":0},{"$f":"'Section 2.D'!AO59","v":0}]
[null,null,null,null,"Section 2.A: Flat Rate with Controlled Load",{"$f":"F56","v":0},0,0,0,0,0,{"$f":"L56","v":0},0,0,0]
[null,null,null,null,"Section 2.B: Flat Rate without Controlled Load",0,0,0,0,0,0,{"$f":"L57","v":0},0,0,0]