{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Solar Simulator","data"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":36,"comments":1,"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":"Solar Simulator","index":0,"n_rows":75,"n_cols":28,"rows_kept":75,"cut":false,"hidden":false,"merged":[[68,1,73,28],[56,1,58,28],[31,2,31,5],[31,6,31,12],[35,24,35,27],[33,24,34,27],[42,19,42,27],[40,14,40,18],[35,2,35,7],[45,17,45,20],[45,7,45,10],[45,12,45,15],[39,2,39,7],[40,2,40,7],[41,2,41,7],[41,19,41,22],[40,19,40,22],[33,19,33,20],[37,19,37,20],[37,23,39,27],[31,24,31,27],[12,10,12,13],[41,8,41,11],[19,2,19,9],[19,11,19,14],[21,14,25,16],[12,2,12,9],[28,2,28,5],[14,8,14,9],[16,8,16,9],[14,10,14,13],[16,10,16,13],[23,8,23,9],[21,12,21,13],[23,12,23,13],[21,2,21,4],[21,8,21,9],[2,18,2,27],[5,2,5,5],[5,19,5,27],[7,2,7,5],[7,6,7,13],[7,14,7,18],[7,19,7,27],[5,6,5,13],[14,22,14,25],[14,17,14,21],[16,26,16,27],[5,14,5,18],[16,22,16,25],[14,26,14,27],[12,16,12,21],[12,22,12,27],[19,24,19,26],[23,24,23,26],[25,2,25,4],[25,5,25,7],[25,8,25,9],[25,12,25,13],[21,5,21,7],[44,17,44,20],[23,2,23,4],[23,5,23,7],[25,24,25,27],[21,24,21,27],[28,6,28,12],[36,2,36,7],[37,2,37,7],[33,2,33,5],[35,8,35,9],[37,8,37,11],[33,6,33,12],[28,18,28,26],[35,19,35,22],[38,19,38,22],[39,19,39,22],[38,2,38,7],[38,8,38,11],[39,8,39,11],[40,8,40,11],[74,1,74,28],[55,23,55,27],[45,22,45,25],[44,2,44,5],[45,2,45,5],[48,17,48,27],[50,23,50,25],[54,23,54,25],[54,26,54,27],[52,23,52,25],[44,7,44,10],[44,12,44,15]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For help with quoting please email or call\n1300 080 163 admin@asmmoney.com.au\nthis is solar presenter version 10m standard v0218"]
[]
[]
[null,null,"Customer Name",null,null,null,null,null,null,null,null,null,null,null,"Installation address"]
[]
[null,null,"Phone",null,null,null,null,null,null,null,null,null,null,null,"Email"]
[]
[]
[]
[]
[null,null,{"$f":"IF(g_37=data!F3,\"Total price [after STCs] Including GST:\", \"Total price [after STCs] Excluding GST:\")","v":"Total price [after STCs] Excluding GST:"},null,null,null,null,null,null,null,100000,null,null,null,null,null,"Your nearest major city:",null,null,null,null,null," Sydney NSW  "]
[]
[null,null,null,null,null,null,null,null,"Deposit:",null,0,null,null,null,null,null,null,"System size (kW):",null,null,null,null,10,null,null,null,"kW"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(j_13=\"*\", \"Minimum amount is $2,000\",\"\")","v":""},{"$f":"IF(j_13=\"***\",\"\",\"TOTAL:\")","v":"TOTAL:"},null,{"$f":"IF(K13-K15<2000,\"*\",K13-K15)","v":100000},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Standard daily output \" & IFERROR(data!J10,\"\") & \"kWh.\"","v":"Standard daily output 39kWh."},39,null,null,null,"kWh"]
[]
[]
[null,null,"Your current rates:",null,null,null,null,null,null,null,null,"Usage weighting:",null,null,null,null,null,null,null,null,null,null,null,"Your current daily electricity usage:",40,null,null,"/kWh"]
[]
[null,null,"Peak:",null,null,0.3,null,null,"/kWh",null,null,null,0.5,null,{"$f":"IF(M22+M24+M26<>1,\"*Weighting levels must add to 100% - please adjust.\",\"\")","v":""},null,null,null,null,null,null,null,null,"% of generated power used on site:",0.8]
[]
[null,null,"Shoulder:",null,null,0,null,null,"/kWh",null,null,null,0,null,null,null,null,null,null,null,null,null,null,"Your current feed-in tariff:",0.11,null,null,"/kWh"]
[]
[null,null,"Off-peak:",null,null,0.3,null,null,"/kWh",null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,"Expected increase in electricity price:",7.0000000000000007E-2]
[]
[]
[null,null,"Finance product:",null,null,null,"Commercial Finance",null,null,null,null,null,null,null,null,null,null,"Select type of finance:","Finance lease"]
[]
[]
[null,null,{"$f":"IF(g_37<>data!F3,\"ABN\",\"\")","v":"ABN"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rate:",6.5000000000000002E-2]
[]
[null,null,"Total:",null,null,null,{"$f":"IFERROR(IF(g_37=data!F5,IF(j_13>=10000000,\"Contact ASM Money for quote\", j_13),IF(AND(g_37=\"Commercial finance\",'Solar Simulator'!S29=data!F10),j_13*1.1,j_13)),\"\")","v":100000},null,null,null,null,null,null,null,null,null,null,null,"Your chosen loan term:",84,null,"months",null,null,"Last payment"]
[]
[null,null,"Your chosen loan term:",null,null,null,null,null,120,null,"months",null,null,null,null,null,null,null,"Grid inflation:",7.0000000000000007E-2,null,null,null,null,{"$f":"data!G51","v":1200}]
[]
[null,null,"Interest rate:",null,null,null,null,null,0.1245,null,null,null,null,null,null,null,null,null,"Your chosen loan term:",60,null,"months",null,{"$f":"IF(g_37=aj_6,\"* Over 84 months contact ASM Money.\",\"\")","v":"* Over 84 months contact ASM Money."}]
[]
[null,null,"Establishment Fee",null,null,null,null,null,200,null,null,null,null,null,null,null,null,null,"Finance lease residual value",0]
[]
[null,null,"Monthly Fee:",null,null,null,null,null,7.5,null,null,null,null,null,null,null,null,null,"Chattel Mortgage residual value",0]
[null,null,{"$f":"IF(g_37=data!F3,\"Calculator adds fees and monthly fee to come up with the total payment for the client.\", \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(g_37=aj_6,b_9>=100000),\"Please call ASM Money for better rate\",IF(t_37=\"***\",\"Please call ASM Money for better rate\",\"\"))","v":"Please call ASM Money for better rate"}]
[]
[null,null,{"$f":"IF(OR(S29=FO_2,S29=FO_3),\"Residual Value\",\"\")","v":"Residual Value"},null,null,null,null,"Monthly:",null,null,null,null,{"$f":"IF(g_37=data!F3,\"Fortnightly:\",\"Term\")","v":"Term"},null,null,null,null,{"$f":"IF(g_37=data!F3,\"Weekly:\",IF(AND(S29=data!F9,g_37=data!F4),\"Residual\",\"Total\"))","v":"Residual"},null,null,null,null,{"$f":"IF(g_37=data!F3,\"Daily:\",IF(AND(S29=data!F9,g_37=data!F4),\"Total\",IF(AND(S29=data!F10,g_37=data!F4),\"GST claimed on your next BAS\",\"\")))","v":"Total"}]
[null,null,{"$f":"IF(S29=FO_2,data!N69,IF('Solar Simulator'!S29=FO_3,data!R69,\"\"))","v":0},null,null,null,null,{"$f":"IFERROR(IF(g_37=data!F3,data!G43,IF(g_37=data!F5,IF(b_9>=10000000,\"***\",data!G53),IF('Solar Simulator'!S29=FO_1,data!J69,IF('Solar Simulator'!S29=FO_2,data!N70,data!R70)))),\"\")","v":2110.8298644830993},null,null,null,{"$f":"IF(g_37=data!F5,\"+GST\",\"\")","v":""},{"$f":"IF(g_37=data!F3,data!G44,IF('Solar Simulator'!S29=FO_1,data!J70,IF('Solar Simulator'!S29=FO_2,data!N71,data!R71)))","v":60},null,null,null,null,{"$f":"IFERROR(IF(g_37=data!F3,data!G45,IF('Solar Simulator'!S29=FO_1,data!J71,IF('Solar Simulator'!S29=FO_3,data!R72,data!N62))),\"\")","v":0},null,null,null,null,{"$f":"IFERROR(IF(g_37=data!F3,data!G46,IF(g_37=data!F4,IF('Solar Simulator'!S29=FO_2,data!N72,IF(S29=FO_3,data!R74,\"\")))),\"\")","v":126649.79186898595}]
[]
[]
[null,null,"In just the first year, your solar PV system could:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Investment analysis:"]
[]
[null,null,null,{"$f":"IFERROR(\"• Generate $\"&INT(z_35)&\".00 worth of electricity \",\"\")","v":"• Generate $3729.00 worth of electricity "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(g_37=data!F3,\"Total Savings over 20 years:\",\"NPV* of solar install (before tax):\")","v":"NPV* of solar install (before tax):"},{"$f":"IFERROR(IF(g_37=data!F3,data!AH28,(NPV(X53,data!AE6:AE25))),\"\")","v":-33318.501061866635}]
[]
[null,null,null,{"$f":"IFERROR(\"• Prevent \"&(INT(t_15*365*VLOOKUP(t_13,data!B3:D12,3,FALSE)/100))/10&\" tonnes of CO2 from entering the atmosphere\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(g_37=aj_6,g_37=data!F5),\"NVP discount rate:\",\"\")","v":"NVP discount rate:"},0.06]
[]
[null,null,null,{"$f":"IFERROR(IF(g_37=data!F3,IF(ab_35>0.1,(\"• Save you $\"&ac_35)&\", after repayments!\",\"• Cost you just $\"&-1*INT(ac_35/365*100)/100&\" extra per day.\"),IF(ac_37>0.1,\"• Save you $\"&ac_37&\" (post-tax), after repayments!\",\"• Cost you just $\"&-1*INT(ac_35/365*100)/100&\" extra per day.\")),\"\")","v":"• Cost you just $59.18 extra per day."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Effective cost of solar generation:",{"$f":"IFERROR(data!AQ7,\"\")","v":0.46635469258296663},null,null,"/ kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(over 20 years)"]
[null,{"$f":"IF(OR(g_37=aj_6,g_37=data!F5),\"*Net Present Value (or NPV) is the sum of all the value your solar system will deliver over it's lifetime, minus its costs, adjusted for inflation and interest (i.e. NPV discount rate).\",\"\")","v":"*Net Present Value (or NPV) is the sum of all the value your solar system will deliver over it's lifetime, minus its costs, adjusted for inflation and interest (i.e. NPV discount rate)."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(g_37=data!F3,\"This is not an offer of finance and the information presented is an estimate only to assist you in making an informed decision about financial products to support your decision to purchase a solar solution.\"&\" Final figures may incur additional fees and charges which will be detailed in any contract offered for finance.\"&\" Repayments are based on an unsecured loan with a term of up to 120 months at an annual percentage rate of 9.95% (comparison rate 12.92%) accurate as of 30 April 2014. \"&\"Terms, fees, charges and credit criteria apply. The consumer credit product is the Thorn Money Solar Loan and the provider is Thorn Australia Pty Ltd ABN 63 008 454 439 \"&\"Australian Credit Licence 383003. Comparison rate based on an unsecured loan of $10,000 over a term of 3 years.\"&\" WARNING the comparison rate is true only for the example given and may not include all fees and charges.\"&\" Different terms , fees and other loan amounts might result in a different comparison rate. This information is based solely on the information supplied by the customer named and is an estimate of the likely benefits of installing a solar system.\"&\" Changes to regulations, tariffs and electricity pricing may affect the outcome.\",\"Application for finance submitted to ASM Money Pty Ltd ABN 88 158 031 960 are subject to credit approval, terms and conditions. \"&\"This information is presented to assist making an informed decision about financial products to support your decision to purchase a solar solution. This is not an offer of finance,\"&\" does not present financial, accounting, general or personal advice nor is it a recommendation. This information is based solely \"&\"on the information supplied by the customer named and is an estimate of the likely benefits of installing a solar system. Changes to regulations, tariffs and electricity pricing may affect the outcome.\")","v":"Application for finance submitted to ASM Money Pty Ltd ABN 88 158 031 960 are subject to credit approval, terms and conditions. This information is presented to assist making an informed decision about financial products to support your decision to purchase a solar solution. This is not an offer of finance, does not present financial, accounting, general or personal advice nor is it a recommendation. This information is based solely on the information supplied by the customer named and is an estimate of the likely benefits of installing a solar system. Changes to regulations, tariffs and electricity pricing may affect the outcome."}]
[]
[]
[]
[]
[]
[null,"©ASM Money Pty Ltd. This estimating tool is for use by ASM Money accredited solar finance dealers and is subject to licensing terms and conditions."]

{"sheet":"data","index":1,"n_rows":74,"n_cols":50,"rows_kept":74,"cut":false,"hidden":true,"merged":[[36,12,36,15],[26,31,26,32],[27,31,27,32],[2,33,3,35],[2,36,3,40],[2,27,4,27],[2,28,4,28],[2,29,4,29],[2,30,4,30],[2,31,4,31],[1,2,1,3],[15,42,15,44],[3,12,4,12],[13,14,13,15],[9,42,9,44],[10,42,10,44],[12,42,12,44],[13,42,13,44],[2,23,4,23],[3,24,4,24],[3,22,4,22],[2,25,4,25],[12,14,12,15],[2,32,4,32],[2,42,3,44]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Weighted Cost Power","checked",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH6/12","v":365},{"$f":"AI6/12","v":54.202499999999986},{"$f":"AJ6/12","v":2110.8298644830993},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OFFSET(data!$AX$3,1,0,MAX(data!$AW:$AW),1)","v":{"$error":"#VALUE!"}}]
[null,"Nearest City","Co2 conversion factor",null,null,"Finance_product",null,null,null,null,null,null,{"$f":"IF(('Solar Simulator'!M22+'Solar Simulator'!M24+'Solar Simulator'!M26)<>1,\"\",(d_25*'Solar Simulator'!M22)+(d_27*'Solar Simulator'!M24)+(d_29*'Solar Simulator'!M26))","v":0.3},null,null,null,null,null,null,null,null,null,null,null,null,null,"Outright Purchase",null,null,{"$f":"IF(g_37=aj_6,b_7,IF(g_37=F3,j_39,'Solar Simulator'!T34))","v":60}]
[null," Adelaide SA  ",4.2,0.79,null,"Residential loan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year","Total Annual Demand (kwh)","Loan stats","Blended Value of power","NPV/IRR Calcs","Cumulative savings","Initial","Repayment","Loan cash flows","power cost","Year","Loan Figures",null,null,"Cost of Power",null,null,null,null,null,"Average cost of power",null,null,null,null,null,{"$f":"IF(B3=\"\",\"\",MAX(AW$2:AW2)+1)","v":1},{"$f":"IFERROR(INDEX($B$2:$B$62,MATCH(ROW()-ROW($AX$2),$AW$2:$AW$62,0)),\"\")","v":" Adelaide SA  "}]
[null," Albany WA  ",3.9,0.86064743792769327,null,"Commercial Finance",null,null,null,null,null,null,"Blended solar power value",null,null,null,null,null,null,null,null,null,"Initial",null,"Solar Yield",null,"Cash flows",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B4=\"\",\"\",MAX(AW$2:AW3)+1)","v":2},{"$f":"IFERROR(INDEX($B$2:$B$62,MATCH(ROW()-ROW($AX$2),$AW$2:$AW$62,0)),\"\")","v":" Albany WA  "}]
[null," Alice Springs NT  ",5,0.79,null,"Governmnet and Schools Rental",null,null,null,null,null,null,null,"checked",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-1*j_13","v":-100000},null,null,null,null,null,null,"Old utility bill","New utility bill","Loan payments","Existing","Solar","Avg Solar",{"$f":"AK5","v":"Existing"},{"$f":"AL5","v":"Solar"},null,{"$f":"SUM(AJ6:AJ25)","v":126649.79186898595},"total 20 yr solar bill",null,null,null,null,{"$f":"IF(B5=\"\",\"\",MAX(AW$2:AW4)+1)","v":3}," Alice Springs NT  "]
[null," Brisbane Qld  ",4.2,0.98,null,null,null,null,null,null,null,null,{"$f":"IF(('Solar Simulator'!M22+'Solar Simulator'!M24+'Solar Simulator'!M26)<>1,\"\",(((d_25*'Solar Simulator'!M22)+(d_27*'Solar Simulator'!M24))*(1/('Solar Simulator'!M22+'Solar Simulator'!M24))*'Solar Simulator'!Y22)+((1-'Solar Simulator'!Y22)*'Solar Simulator'!Y24))","v":0.26200000000000001},null,null,null,null,null,null,null,null,null,1,{"$f":"'Solar Simulator'!Y20*365","v":14600},{"$f":"t_15*365","v":14235},{"$f":"z_29","v":0.26200000000000001},{"$f":"Y6*Z6","v":3729.57},{"$f":"AA6","v":3729.57},1,{"$f":"IF($AD$2/12>=AC6,aa_35,0)","v":25329.958373797192},{"$f":"AA6-AD6","v":-21600.388373797192},{"$f":"M2","v":0.3},{"$f":"AC6","v":1},{"$f":"X6*AF6","v":4380},{"$f":"AH6-(Y6*Z6)","v":650.42999999999984},{"$f":"AD6","v":25329.958373797192},{"$f":"AF6","v":0.3},{"$f":"IF((AJ6)/Y6>0.001,(AJ6)/Y6,0.001)","v":1.7794140058867012},{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},{"$f":"AK6*100","v":30},{"$f":"AL6*100","v":177.94140058867012},null,{"$f":"SUM(Y6:Y25)","v":271573.96265816363},"total 20 yr usage",null,null,null,null,{"$f":"IF(B6=\"\",\"\",MAX(AW$2:AW5)+1)","v":4}," Brisbane Qld  "]
[null," Cairns Qld  ",4.2,1.04,null,"Commercial_Finance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"X6","v":14600},{"$f":"Y6*(1-ab_5)","v":14163.825000000001},{"$f":"Z6*(1+t_29)","v":0.28034000000000003},{"$f":"Y7*Z7","v":3970.6867005000008},{"$f":"AA7+AB6","v":7700.256700500001},{"$f":"AC6+1","v":2},25329.958373797192,{"$f":"AA7-AD7","v":-21359.271673297189},{"$f":"AF6*(1+t_29)","v":0.32100000000000001},{"$f":"AC7","v":2},{"$f":"X7*AF7","v":4686.6000000000004},{"$f":"AH7-(Y7*Z7)","v":715.91329949999954},{"$f":"AD7","v":25329.958373797192},{"$f":"AF7","v":0.32100000000000001},{"$f":"IF((AJ7)/Y7>0.001,(AJ7)/Y7,0.001)","v":1.788355784810755},{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},{"$f":"AK7*100","v":32.1},{"$f":"AL7*100","v":178.83557848107549},null,{"$f":"AQ5/AQ6","v":0.46635469258296663},"Avg cost over 20 yrs",null,null,null,null,{"$f":"IF(B7=\"\",\"\",MAX(AW$2:AW6)+1)","v":5}," Cairns Qld  "]
[null," Canberra ACT  ",4.3,1.06,null,"Solar Rental",null,null,null,null,null,null,"Annual $ saving","checked",null,null,null,null,null,null,null,null,3,{"$f":"X7","v":14600},14093.005875000001,0.29996380000000006,4227.3915956873261,{"$f":"AA8+AB7","v":11927.648296187326},{"$f":"AC7+1","v":3},25329.958373797192,-21102.566778109867,0.34347000000000005,3,5014.6620000000012,787.27040431267505,25329.958373797192,0.34347000000000005,1.7973424972972412,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},34.347000000000008,179.73424972972413,null,null,null,null,null,null,null,{"$f":"IF(B8=\"\",\"\",MAX(AW$2:AW7)+1)","v":6}," Canberra ACT  "]
[null," Darwin NT  ",4.4000000000000004,0.79,null,"Finance lease",null,null,"System size (kW)",{"$f":"'Solar Simulator'!W15","v":10},null,"Normal",{"$f":"INT((M6*(t_15*365)*100))/100","v":3729.57},null,null,null,null,null,null,null,null,null,4,14600,14022.540845625001,0.32096126600000008,4500.692462348512,16428.340758535836,4,25329.958373797192,-20829.265911448681,0.36751290000000009,4,5365.6883400000015,864.99587765148954,25329.958373797192,0.36751290000000009,1.8063743691429559,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},36.751290000000012,180.63743691429559,null,null,null,null,null,null,null,{"$f":"IF(B9=\"\",\"\",MAX(AW$2:AW8)+1)","v":7}," Darwin NT  "]
[null," East Sale Vic  ",3.5,0.76063079230914299,null,"Chattel Mortgage",null,null,"System's average",{"$f":"J9*VLOOKUP(t_13,data!B3:C62,2)","v":39},null,"Post tax",{"$f":"z_35","v":3729.57},null,null,null,null,null,null,null,null,null,5,14600,13952.428141396875,0.3434285546200001,4791.6622300393428,21220.002988575179,5,25329.958373797192,-20538.296143757849,0.39323880300000014,5,5741.2865238000022,949.62429376065938,25329.958373797192,0.39323880300000014,1.8154516272793528,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},39.323880300000013,181.54516272793529,null,"Cost of capital",null,null,null,null,null,{"$f":"IF(B10=\"\",\"\",MAX(AW$2:AW9)+1)","v":8}," East Sale Vic  "]
[null," Forrest WA  ",4.7,1.0321045447023507,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,14600,13882.666000689891,0.36746855344340013,5101.4431932113876,26321.446181786567,6,0,5101.4431932113876,0.42076551921000016,6,6143.1765804660026,1041.7333872546151,0,0.42076551921000016,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},42.076551921000018,0.1,null,0.06,null,null,null,null,null,{"$f":"IF(B11=\"\",\"\",MAX(AW$2:AW10)+1)","v":9}," Forrest WA  "]
[null," Geraldton WA  ",4.8,1.0463926369335723,null,null,null,null,null,null,null,null,"Year 1 repayments","Savings","checked",null,null,null,null,null,null,null,7,14600,13813.252670686441,0.39319135218443818,5431.2514956525038,31752.697677439071,7,0,5431.2514956525038,0.45021910555470018,7,6573.1989410986225,1141.9474454461188,0,0.45021910555470018,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},45.021910555470015,0.1,null,null,null,null,null,null,null,{"$f":"IF(B12=\"\",\"\",MAX(AW$2:AW11)+1)","v":10}," Geraldton WA  "]
[null," Halls Creek WA  ",5.0999999999999996,1.1169926220760784,null,null,null,null,null,null,null,null,{"$f":"t_37*12","v":25329.958373797192},{"$f":"z_35-M13","v":-21600.388373797192},{"$f":"INT(N13*100)/100","v":-21600.39},null,null,null,null,null,null,null,8,14600,13744.186407333009,0.42071474683734889,5782.3819048464384,37535.079582285507,8,0,5782.3819048464384,0.48173444294352924,8,7033.3228669755272,1250.9409621290888,0,0.48173444294352924,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},48.173444294352926,0.1,null,"Annual System Degradation",null,null,null,null,null,{"$f":"IF(B13=\"\",\"\",MAX(AW$2:AW12)+1)","v":11}," Halls Creek WA  "]
[null," Hobart Tas  ",3.5,0.28999999999999998,null,"Month",null,null,null,null,null,{"$f":"IF(g_37<>data!F3,t_37*0.7,\"\")","v":1477.5809051381693},{"$f":"IFERROR(L14*12,0)","v":17730.970861658032},{"$f":"IFERROR(z_37-M14,0)","v":-14001.400861658032},{"$f":"INT(N14*100)/100","v":-14001.41},null,null,null,null,null,null,null,9,14600,13675.465475296343,0.45016477911596331,6156.212894994761,43691.292477280265,9,0,6156.212894994761,0.51545585394957627,9,7525.6554676638134,1369.4425726690524,0,0.51545585394957627,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},51.545585394957627,0.1,null,5.0000000000000001E-3,null,null,null,null,null,{"$f":"IF(B14=\"\",\"\",MAX(AW$2:AW13)+1)","v":12}," Hobart Tas  "]
[null," Kalgoorlie WA  ",4.0999999999999996,0.90771409468936404,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,14600,13607.088147919862,0.48167631365408076,6554.2120586561723,50245.504535936438,10,0,6554.2120586561723,0.55153776372604668,10,8052.4513504002816,1498.2392917441093,0,0.55153776372604668,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},55.153776372604668,0.1,null,null,null,null,null,null,null,{"$f":"IF(B15=\"\",\"\",MAX(AW$2:AW14)+1)","v":13}," Kalgoorlie WA  "]
[null," Launceston Tas  ",3.5,0.77744031258116819,null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,14600,13539.052707180263,0.51539365560986639,6977.9418682482938,57223.446404184731,11,0,6977.9418682482938,0.59014540718687003,11,8616.1229449283019,1638.1810766800081,0,0.59014540718687003,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},59.014540718687002,0.1,null,"Tree-o-metter",null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",MAX(AW$2:AW15)+1)","v":14}," Launceston Tas  "]
[null," Laverton Vic  ",3.8,0.84215696562846543,null,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,14600,13471.357443644361,0.55147121150255707,7429.0658100305463,64652.512214215276,12,0,7429.0658100305463,0.63145558568995097,12,9219.2515510732846,1790.1857410427383,0,0.63145558568995097,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},63.145558568995099,0.1,null,"car",1,null,null,null,null,{"$f":"IF(B17=\"\",\"\",MAX(AW$2:AW16)+1)","v":15}," Laverton Vic  "]
[null," Longreach Qld  ",5.0999999999999996,1.1279188102528948,null,48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,14600,13404.00065642614,0.59007419630773605,7909.3549146490213,72561.867128864295,13,0,7909.3549146490213,0.6756574766882476,13,9864.5991596484146,1955.2442449993932,0,0.6756574766882476,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},67.565747668824756,0.1,null,"PV",{"$f":"AS18/5.1","v":0},null,null,null,null,{"$f":"IF(B18=\"\",\"\",MAX(AW$2:AW17)+1)","v":16}," Longreach Qld  "]
[null," Melbourne Vic  ",3.8,1.35,null,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,14600,13336.98065314401,0.63137939004927757,8420.6947098810797,80982.561838745372,14,0,8420.6947098810797,0.722953500056425,14,10555.121100823804,2134.4263909427245,0,0.722953500056425,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},72.295350005642504,0.1,null,"Tonnes CO2","Tree-o-metter data",3.9E-2,null,null,null,{"$f":"IF(B19=\"\",\"\",MAX(AW$2:AW18)+1)","v":17}," Melbourne Vic  "]
[null," Mildura Vic  ",4.4000000000000004,0.9665474156414523,null,72,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,14600,13270.295749878289,0.67557594735272708,8965.0926228748922,89947.654461620259,15,0,8965.0926228748922,0.7735602450603748,15,11293.979577881471,2328.8869550065792,0,0.7735602450603748,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},77.356024506037485,0.1,null,5.0999999999999996,"Tree",1,null,null,null,{"$f":"IF(B20=\"\",\"\",MAX(AW$2:AW19)+1)","v":18}," Mildura Vic  "]
[null," Mt Gambier SA  ",3.7,0.80601649704361111,null,84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,14600,13203.944271128898,0.72286626366741802,9544.685860943755,99492.340322564007,16,0,9544.685860943755,0.82770946221460107,16,12084.558148333175,2539.8722873894203,0,0.82770946221460107,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},82.770946221460107,0.1,null,{"$f":"INT(t_15*365*VLOOKUP(t_13,B3:D62,3,FALSE)/100)/10","v":15},"PV",{"$f":"INT((AQ21/AS19)+0.5)","v":385},null,null,null,{"$f":"IF(B21=\"\",\"\",MAX(AW$2:AW20)+1)","v":19}," Mt Gambier SA  "]
[null," Oodnadatta NT  ",5,1.0884164376136354,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,14600,13137.924549773254,0.77346690212413738,10161.74980185377,109654.09012441778,17,0,10161.74980185377,0.88564912456962319,17,12930.477218716498,2768.7274168627282,0,0.88564912456962319,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},88.564912456962318,0.1,null,null,null,{"$f":"IFERROR(AS21,\"\")","v":385},null,null,null,{"$f":"IF(B22=\"\",\"\",MAX(AW$2:AW21)+1)","v":20}," Oodnadatta NT  "]
[null," Perth WA  ",4.4000000000000004,0.96,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,14600,13072.234927024387,0.82760958527282702,10818.706926543617,120472.7970509614,18,0,10818.706926543617,0.94764456328949687,18,13835.610624026654,3016.9036974830378,0,0.94764456328949687,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},94.764456328949692,0.1,null,null,null,null,null,null,null,{"$f":"IF(B23=\"\",\"\",MAX(AW$2:AW22)+1)","v":21}," Perth WA  "]
[null," Port Hedland WA  ",5.0999999999999996,1.1203545261304835,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,14600,13006.873752389265,0.88554225624192495,11518.136329344663,131990.93338030606,19,0,11518.136329344663,1.0139796827197618,19,14804.103367708522,3285.9670383638586,0,1.0139796827197618,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},101.39796827197618,0.1,null,null,null,null,null,null,null,{"$f":"IF(B24=\"\",\"\",MAX(AW$2:AW23)+1)","v":22}," Port Hedland WA  "]
[null," Rockhampton Qld  ",4.5,0.97831407983187002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,14600,12941.839383627319,0.94753021417885974,12262.783843036796,144253.71722334286,20,0,12262.783843036796,1.0849582605101451,20,15840.390603448119,3577.6067604113232,0,1.0849582605101451,1E-3,{"$f":"'Solar Simulator'!X$55","v":0.46635469258296663},108.4958260510145,0.1,null,null,null,null,null,null,null,{"$f":"IF(B25=\"\",\"\",MAX(AW$2:AW24)+1)","v":23}," Rockhampton Qld  "]
[null," Sydney NSW  ",3.9,1.06,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(B26=\"\",\"\",MAX(AW$2:AW25)+1)","v":24}," Sydney NSW  "]
[null," Tennant Creek NT  ",4.9000000000000004,1.0648831092328002,null,null,null,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:",null,{"$f":"SUM(AH6:AH25)","v":179560.25636699246},{"$f":"SUM(AI6:AI25)","v":35306.539143649614},{"$f":"SUM(AJ6:AJ25)","v":126649.79186898595},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B27=\"\",\"\",MAX(AW$2:AW26)+1)","v":25}," Tennant Creek NT  "]
[null," Townsville Qld  ",4.4000000000000004,0.95898313151904102,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Savings for 20 years",null,{"$f":"AH27-AI27-AJ27","v":17603.925354356907},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B28=\"\",\"\",MAX(AW$2:AW27)+1)","v":26}," Townsville Qld  "]
[null," Wagga Wagga NSW  ",4.0999999999999996,0.9035117146213576,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(B29=\"\",\"\",MAX(AW$2:AW28)+1)","v":27}," Wagga Wagga NSW  "]
[null," Williamtown NSW  ",3.8,0.83879506157406036,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(B30=\"\",\"\",MAX(AW$2:AW29)+1)","v":28}," Williamtown NSW  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(B31=\"\",\"\",MAX(AW$2:AW30)+1)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(B32=\"\",\"\",MAX(AW$2:AW31)+1)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(B33=\"\",\"\",MAX(AW$2:AW32)+1)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(B34=\"\",\"\",MAX(AW$2:AW33)+1)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(B35=\"\",\"\",MAX(AW$2:AW34)+1)","v":""},""]
[null,null,null,null,null,null,null,null,"checked",null,null,null,"checked",null,null,"instead of 10k,15k,... I insert universal values b1, b2,...",null,null,null,null,null,null,null,null,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":"IF(B36=\"\",\"\",MAX(AW$2:AW35)+1)","v":""},""]
[null,null,null,null,null,"Residental Loan Calculator","CHECKED",null,"CAFGA INPUTS",null,null,null,"k - TABLE",null,null,null,"Brokerage",null,null,null,null,null,null,null,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":"IF(B37=\"\",\"\",MAX(AW$2:AW36)+1)","v":""},""]
[null,null,null,null,null,"Loan Amount",{"$f":"j_13","v":100000},2,"Cost installed ",{"$f":"IF(ISNUMBER(b_9),b_9,\"\")","v":100000},null,null,null,"From min","To max",null,null,null,null,null,null,null,null,null,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":"IF(B38=\"\",\"\",MAX(AW$2:AW37)+1)","v":""},""]
[null,null,null,null,null,"Term",{"$f":"j_39","v":120},3,"Energy Inflation",{"$f":"b_5","v":7.0000000000000007E-2},null,null,{"$f":"IF(AND(c_5>=N39,c_5<O39),1,0)","v":0},2000,5000.99,"b1",0.1,"Enter brokerage rates here",null,null,null,null,null,null,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":"IF(B39=\"\",\"\",MAX(AW$2:AW38)+1)","v":""},""]
[null,null,null,null,null,"APR",{"$f":"'Solar Simulator'!I38","v":0.1245},4,"Rate",0.06,{"$f":"J40/12","v":5.0000000000000001E-3},null,0,5001,10000.99,"b2",0.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,{"$f":"IF(B40=\"\",\"\",MAX(AW$2:AW39)+1)","v":""},""]
[null,null,null,null,null,"Establishment Fee",{"$f":"'Solar Simulator'!I40","v":200},5,"Term",{"$f":"K41/12","v":5},{"$f":"J44","v":60},null,0,10001,20000.990000000002,"b3",0.06,null,null,null,null,null,null,null,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":"IF(B41=\"\",\"\",MAX(AW$2:AW40)+1)","v":""},""]
[null,null,null,null,null,"Monthly Fee",{"$f":"'Solar Simulator'!I42","v":7.5},6,"Time Period",null,null,null,0,20001,35000.99,"b4",0.06,null,null,null,null,null,null,null,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":"IF(B42=\"\",\"\",MAX(AW$2:AW41)+1)","v":""},""]
[null,null,null,null,null,"Monthly",{"$f":"IFERROR((-PMT(G40/12,G39,G38+G41,0,0)+G42),\"\")","v":1471.2648840205297},null,"Start","2013-09-01",null,null,0,35001,60000.99,"b5",0.06,null,null,null,null,null,null,null,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":"IF(B43=\"\",\"\",MAX(AW$2:AW42)+1)","v":""},""]
[null,null,null,null,null,"Forthnightly:",{"$f":"IFERROR(G43*12/26,\"\")","v":679.04533108639839},null,"No. of Months",{"$f":"b_7","v":60},null,null,1,60001,99999999999,"b6",0.06,null,null,null,null,null,null,null,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":"IF(B44=\"\",\"\",MAX(AW$2:AW43)+1)","v":""},""]
[null,null,null,null,null,"Weekly:",{"$f":"IFERROR(G43*12/52,\"\")","v":339.5226655431992},null,"RBA",2.75E-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,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B45=\"\",\"\",MAX(AW$2:AW44)+1)","v":""},""]
[null,null,null,null,null,"Daily:",{"$f":"IFERROR(G45/7,\"\")","v":48.503237934742742},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(B46=\"\",\"\",MAX(AW$2:AW45)+1)","v":""},""]
[null,null,null,null,null,null,null,null,"checked",null,null,null,"checked",null,null,null,null,null,null,null,null,null,null,null,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":"IF(B47=\"\",\"\",MAX(AW$2:AW46)+1)","v":""},""]
[null,null,null,null,null,"Governmnet and Schools Rental","CHECKED",null,"K factor","Brokerage",null,null,"Brokerage",null,null,12,24,36,48,60,72,84,null,null,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":"IF(B48=\"\",\"\",MAX(AW$2:AW47)+1)","v":""},""]
[null,null,null,null,null,"Term",{"$f":"'Solar Simulator'!T34","v":84},4,{"$f":"VLOOKUP(1,M39:P44,4,FALSE)","v":"b6"},{"$f":"VLOOKUP(1,M39:Q44,5,FALSE)","v":0.06},null,null,{"$f":"Q39","v":0.1},{"$f":"P39","v":"b1"},{"$f":"CONCATENATE(N49,\" \",M49)","v":"b1 0.1"},0.13,0.1275,0.1275,0.1275,0.1275,0.13750000000000001,0.13750000000000001,null,null,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":"IF(B49=\"\",\"\",MAX(AW$2:AW48)+1)","v":""},""]
[null,null,null,null,null,"Cost net GST",{"$f":"b_9","v":100000},5,{"$f":"CONCATENATE(I49,\" \",J49)","v":"b6 0.06"},null,null,null,0.1,"b2","b2 0.1",0.11749999999999999,0.1075,0.1075,0.1075,0.1075,0.11749999999999999,0.11749999999999999,"enter interest rates here",null,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":"IF(B50=\"\",\"\",MAX(AW$2:AW49)+1)","v":""},""]
[null,null,null,null,null,"Last Payment",{"$f":"IFERROR(G50*1.2%,\"\")","v":1200},6,"row","column",null,null,0.06,"b3","b3 0.06",0.109,6.7599999999999993E-2,6.7500000000000004E-2,6.7500000000000004E-2,6.7500000000000004E-2,7.7499999999999999E-2,7.7499999999999999E-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,{"$f":"IF(B51=\"\",\"\",MAX(AW$2:AW50)+1)","v":""},""]
[null,null,null,null,null,"Rate",{"$f":"'Solar Simulator'!Y32","v":6.5000000000000002E-2},7,{"$f":"MATCH(I50,O49:O54,0)","v":6},{"$f":"MATCH(K41,P48:V48,0)","v":5},null,null,0.06,"b4","b4 0.06",0.105,0.06,0.06,0.06,0.06,7.0000000000000007E-2,7.0000000000000007E-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,{"$f":"IF(B52=\"\",\"\",MAX(AW$2:AW51)+1)","v":""},""]
[null,null,null,null,null,"Payment",{"$f":"IFERROR(PMT(G52/12,G49,-G50*1.04,G51,0),\"\")","v":1533.0220693042356},null,"Rate",null,null,null,0.06,"b5","b5 0.06",0.1,5.7000000000000002E-2,5.7000000000000002E-2,5.7000000000000002E-2,5.7000000000000002E-2,6.7000000000000004E-2,6.7000000000000004E-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,{"$f":"IF(B53=\"\",\"\",MAX(AW$2:AW52)+1)","v":""},""]
[null,null,null,null,null,null,null,null,{"$f":"INDEX(P49:V54,I52,J52)","v":5.5E-2},null,null,null,0.06,"b6","b6 0.06",9.7500000000000003E-2,5.5E-2,5.5E-2,5.5E-2,5.5E-2,6.5000000000000002E-2,6.5000000000000002E-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,{"$f":"IF(B54=\"\",\"\",MAX(AW$2:AW53)+1)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(B55=\"\",\"\",MAX(AW$2:AW54)+1)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(B56=\"\",\"\",MAX(AW$2:AW55)+1)","v":""},""]
[null,null,null,null,null,null,null,null,"checked",null,null,null,"checked",null,null,null,"checked",null,null,null,null,null,null,null,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":"IF(B57=\"\",\"\",MAX(AW$2:AW56)+1)","v":""},""]
[null,null,null,null,null,null,null,null,"Rental",null,null,null,"Finance Lease",null,null,null,"Hire purchase",null,null,"Fees",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,{"$f":"IF(B58=\"\",\"\",MAX(AW$2:AW57)+1)","v":""},""]
[null,null,null,null,null,null,null,null,"Term",{"$f":"b_7","v":60},null,null,"Term",{"$f":"b_7","v":60},35,null,"Term",{"$f":"b_7","v":60},null,null,null,null,null,null,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":"IF(B59=\"\",\"\",MAX(AW$2:AW58)+1)","v":""},""]
[null,null,null,null,null,null,null,null,"Cost",{"$f":"b_9","v":100000},null,null,"Cost",{"$f":"b_9","v":100000},36,null,"Cost",{"$f":"b_9","v":100000},null,null,null,null,null,null,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":"IF(B60=\"\",\"\",MAX(AW$2:AW59)+1)","v":""},""]
[null,null,null,null,null,null,null,null,"Brokerage",{"$f":"J49","v":0.06},null,null,"Brokerage",{"$f":"J49","v":0.06},37,null,"Brokerage",{"$f":"J49","v":0.06},null,null,null,null,null,null,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":"IF(B61=\"\",\"\",MAX(AW$2:AW60)+1)","v":""},""]
[null,null,null,null,null,null,null,null,"Rate",{"$f":"I54","v":5.5E-2},null,null,"Residual",{"$f":"IFERROR(N60*b_11,\"\")","v":0},38,null,"Residual",{"$f":"IFERROR(R60*b_13*100/110,\"\")","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,{"$f":"IF(B62=\"\",\"\",MAX(AW$2:AW61)+1)","v":""},""]
[null,null,null,null,null,null,null,null,"Payment",{"$f":"IFERROR(PMT(J62/12,J59,-((J60*J61)+(J60+U58)),0,1),\"\")","v":2015.485548113398},null,null,"Rate",{"$f":"I54+0.02","v":7.4999999999999997E-2},39,null,"Rate",{"$f":"I54","v":5.5E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Payment",{"$f":"IFERROR(PMT(N63/12,N59,-((N60*N61)+(N60+U58)),N62,1),\"\")","v":2110.8298644830993},40,null,"Payment",{"$f":"IFERROR(PMT(R63/12,R59,-((R60*R61)+(R60+U58)),R62,1),\"\")","v":2015.485548113398}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Finance option 1",null,null,null,"Finance Option 2",null,null,null,"Finance Option 3"]
[null,null,null,null,null,null,null,null,"Monthly Payment",{"$f":"J63","v":2015.485548113398},null,null,"Residual Value",{"$f":"b_11","v":0},null,null,"Residual Value",{"$f":"b_13","v":0}]
[null,null,null,null,null,null,null,null,"Term",{"$f":"b_7","v":60},null,null,"Monthly Payment",{"$f":"N64","v":2110.8298644830993},null,null,"Monthly Payment",{"$f":"R64","v":2015.485548113398}]
[null,null,null,null,null,null,null,null,"Total",{"$f":"J69*d_9","v":120929.13288680388},null,null,"Term",{"$f":"J70","v":60},null,null,"Term",{"$f":"J70","v":60}]
[null,null,null,null,null,null,null,null,"Rental inc GST",{"$f":"J69*1.1","v":2217.0341029247379},null,null,"Total",{"$f":"N70*d_9+c_5*N69","v":126649.79186898595},null,null,"Total",{"$f":"R70*d_9+c_5*R69","v":120929.13288680388}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Finance Lease inc GST",{"$f":"N70*1.1","v":2321.9128509314096},null,null,"Hire Purchase inc GST",{"$f":"R70*1.1","v":2217.0341029247379}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GST claimed:",{"$f":"R60-R60/1.1","v":9090.9090909091028}]