{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Serviceability Calculator","User Guide","Administration","HEM","Branding","Postcodes","Calculations","HEM Calculator","Drivers"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":138,"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":"Serviceability Calculator","index":0,"n_rows":406,"n_cols":6,"rows_kept":406,"cut":false,"hidden":false,"merged":[[255,1,255,5],[280,1,280,5],[286,1,286,5],[296,1,296,5],[306,1,306,5],[272,1,272,5],[288,1,289,1],[153,1,153,5],[178,1,178,5],[184,1,184,5],[204,1,204,5],[194,1,194,5],[323,1,323,5],[405,1,405,5],[354,1,354,5],[376,1,376,5],[327,1,327,5],[337,1,337,5],[329,1,330,1],[325,2,325,4],[237,1,238,1],[229,1,229,5],[235,1,235,5],[245,1,245,5],[4,1,4,5],[33,1,34,1],[84,1,85,1],[135,1,136,1],[186,1,187,1],[17,1,17,5],[68,1,68,5],[119,1,119,5],[170,1,170,5],[221,1,221,5],[25,1,25,5],[31,1,31,5],[411,1,411,5],[406,1,406,5],[407,1,407,5],[408,1,408,5],[409,1,409,5],[410,1,410,5],[102,1,102,5],[127,1,127,5],[133,1,133,5],[143,1,143,5],[41,1,41,5],[51,1,51,5],[76,1,76,5],[82,1,82,5],[92,1,92,5]]}
[null,null,null,null,null,{"$f":"\"Version: \"&vVersion","v":"Version: 4.00  (1 July 2026)"}]
[]
[]
[]
[null,"Loan Details"]
[]
[null,"Loan Amount",null,"Security Value"]
[]
[null,"Term (months)",null,"Actual Rate (%)"]
[]
[null,"Repayment Type",null,"I/O Period (years)"]
[]
[null,"Regulated Loan",null,"Purpose of Loan"]
[]
[null,"Number of Individuals",null,"Company Income Used"]
[]
[]
[" ",{"$f":"\"Applicant \"&INT(ROW(A18)/ROWS(vForm_Applicant)+0.9)","v":"Applicant 1"}]
[]
[null,"Name",null,"Residential Postcode"]
[null,null,null,null,{"$f":"OFFSET(tApplicant_HEM,INT(ROW(A18)/ROWS(vForm_Applicant)+0.9)-1,7,1,1)","v":""}]
[null,"Applying As",null,"Joint with Applicant"]
[]
[null,"Number of Dependents"]
[]
[null,"PAYG Income  (Annual)"]
[]
[null,"PAYG Gross"]
[]
[null,"Non-Taxable"]
[]
[null,"Self-Employed / Sole Trader / Partnership  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Variable Income  (Annual)"]
[]
[null,"Overtime / Allowance"]
[]
[null,"Bonus / Commission"]
[]
[null,"Investment"]
[]
[null,"Other"]
[]
[null,"Rental Income - If used for Assessment  (Annual)"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[" ",{"$f":"\"Applicant \"&INT(ROW(A69)/ROWS(vForm_Applicant)+0.9)","v":"Applicant 2"}]
[]
[null,"Name",null,"Residential Postcode"]
[null,null,null,null,{"$f":"OFFSET(tApplicant_HEM,INT(ROW(A69)/ROWS(vForm_Applicant)+0.9)-1,7,1,1)","v":""}]
[null,"Applying As",null,"Joint with Applicant"]
[]
[null,"Number of Dependents"]
[]
[null,"PAYG Income  (Annual)"]
[]
[null,"PAYG Gross"]
[]
[null,"Non-Taxable"]
[]
[null,"Self-Employed / Sole Trader / Partnership  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Variable Income  (Annual)"]
[]
[null,"Overtime / Allowance"]
[]
[null,"Bonus / Commission"]
[]
[null,"Investment"]
[]
[null,"Other"]
[]
[null,"Rental Income - If used for Assessment  (Annual)"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[" ",{"$f":"\"Applicant \"&INT(ROW(A120)/ROWS(vForm_Applicant)+0.9)","v":"Applicant 3"}]
[]
[null,"Name",null,"Residential Postcode"]
[null,null,null,null,{"$f":"OFFSET(tApplicant_HEM,INT(ROW(A120)/ROWS(vForm_Applicant)+0.9)-1,7,1,1)","v":""}]
[null,"Applying As",null,"Joint with Applicant"]
[]
[null,"Number of Dependents"]
[]
[null,"PAYG Income  (Annual)"]
[]
[null,"PAYG Gross"]
[]
[null,"Non-Taxable"]
[]
[null,"Self-Employed / Sole Trader / Partnership  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Variable Income  (Annual)"]
[]
[null,"Overtime / Allowance"]
[]
[null,"Bonus / Commission"]
[]
[null,"Investment"]
[]
[null,"Other"]
[]
[null,"Rental Income - If used for Assessment  (Annual)"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[" ",{"$f":"\"Applicant \"&INT(ROW(A171)/ROWS(vForm_Applicant)+0.9)","v":"Applicant 4"}]
[]
[null,"Name",null,"Residential Postcode"]
[null,null,null,null,{"$f":"OFFSET(tApplicant_HEM,INT(ROW(A171)/ROWS(vForm_Applicant)+0.9)-1,7,1,1)","v":""}]
[null,"Applying As",null,"Joint with Applicant"]
[]
[null,"Number of Dependents"]
[]
[null,"PAYG Income  (Annual)"]
[]
[null,"PAYG Gross"]
[]
[null,"Non-Taxable"]
[]
[null,"Self-Employed / Sole Trader / Partnership  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Variable Income  (Annual)"]
[]
[null,"Overtime / Allowance"]
[]
[null,"Bonus / Commission"]
[]
[null,"Investment"]
[]
[null,"Other"]
[]
[null,"Rental Income - If used for Assessment  (Annual)"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[" ",{"$f":"\"Applicant \"&INT(ROW(A222)/ROWS(vForm_Applicant)+0.9)","v":"Applicant 5"}]
[]
[null,"Name",null,"Residential Postcode"]
[null,null,null,null,{"$f":"OFFSET(tApplicant_HEM,INT(ROW(A222)/ROWS(vForm_Applicant)+0.9)-1,7,1,1)","v":""}]
[null,"Applying As",null,"Joint with Applicant"]
[]
[null,"Number of Dependents"]
[]
[null,"PAYG Income  (Annual)"]
[]
[null,"PAYG Gross"]
[]
[null,"Non-Taxable"]
[]
[null,"Self-Employed / Sole Trader / Partnership  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Variable Income  (Annual)"]
[]
[null,"Overtime / Allowance"]
[]
[null,"Bonus / Commission"]
[]
[null,"Investment"]
[]
[null,"Other"]
[]
[null,"Rental Income - If used for Assessment  (Annual)"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[" ",{"$f":"\"Applicant \"&INT(ROW(A273)/ROWS(vForm_Applicant)+0.9)","v":"Applicant 6"}]
[]
[null,"Name",null,"Residential Postcode"]
[null,null,null,null,{"$f":"OFFSET(tApplicant_HEM,INT(ROW(A273)/ROWS(vForm_Applicant)+0.9)-1,7,1,1)","v":""}]
[null,"Applying As",null,"Joint with Applicant"]
[]
[null,"Number of Dependents"]
[]
[null,"PAYG Income  (Annual)"]
[]
[null,"PAYG Gross"]
[]
[null,"Non-Taxable"]
[]
[null,"Self-Employed / Sole Trader / Partnership  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Variable Income  (Annual)"]
[]
[null,"Overtime / Allowance"]
[]
[null,"Bonus / Commission"]
[]
[null,"Investment"]
[]
[null,"Other"]
[]
[null,"Rental Income - If used for Assessment  (Annual)"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[null,"Company Details"]
[]
[null,"Company Name"]
[]
[null,"Income  (Annual)"]
[]
[null,"Net Profit (Loss)\nBefore Tax (NPBT)"]
[]
[null,"Interest"]
[]
[null,"Other Add Backs"]
[]
[null,"Depreciation"]
[]
[null,"Rental Income - If used for Assessment  (Annual)"]
[]
[null,"Number of Properties"]
[]
[null,null,"Rent Received","% Ownership","Investment Loan Amount"]
[null,"Investment Property 1"]
[null,"Investment Property 2"]
[null,"Investment Property 3"]
[null,"Investment Property 4"]
[null,"Investment Property 5"]
[null,"Investment Property 6"]
[null,"Investment Property 7"]
[null,"Investment Property 8"]
[null,"Investment Property 9"]
[null,"Investment Property 10"]
[]
[]
[null,"Commitments (Monthly)"]
[]
[null,"Number of Commitments"]
[]
[null,null,"Commitment","Repayment Amount","Commitment Limit"]
[null,"Commitment 1"]
[null,"Commitment 2"]
[null,"Commitment 3"]
[null,"Commitment 4"]
[null,"Commitment 5"]
[null,"Commitment 6"]
[null,"Commitment 7"]
[null,"Commitment 8"]
[null,"Commitment 9"]
[null,"Commitment 10"]
[]
[null,"Total Credit Card Limits"]
[]
[null,"Declared Living Costs",null,"Benchmark Living Costs",{"$f":"vHEM_Amount","v":0}]
[]
[]
[]
[null,"Serviceability Calculation"]
[]
[null,"Actual","Annual","Assessment","Annual"]
[]
[null,"Gross Income",{"$f":"Calculations!C33+Calculations!C66+Calculations!C35","v":0},"Gross Income",{"$f":"C381","v":0}]
[]
[null,"Taxable Income",{"$f":"Calculations!C33+Calculations!C66","v":0},"Taxable Income",{"$f":"C383","v":0}]
[]
[null,"Net Income",{"$f":"Calculations!C37+Calculations!C69","v":0},"Net Income",{"$f":"C385","v":0}]
[]
[null,"Total Commitments",{"$f":"Calculations!D84","v":0},"Other Commitments",{"$f":"Calculations!C84","v":0}]
[]
[null,"Living Costs",{"$f":"Calculations!D85","v":0},"Living Costs",{"$f":"Calculations!C85","v":0}]
[]
[null,"Net Available Income",{"$f":"IF(C385-C387-C389<0,0,C385-C387-C389)","v":0},"Net Available Income",{"$f":"IF(E385-E387-E389<0,0,E385-E387-E389)","v":0}]
[]
[null,"Proposed Repayments",{"$f":"IF(ISERROR(vRepayments),0,vRepayments)","v":0},"Proposed Repayments",{"$f":"IF(ISERROR(vAssessed_Repayments),0,vAssessed_Repayments)","v":0}]
[]
[null,"Net Disposable Income",{"$f":"IF(C391-C393<0,0,C391-C393)","v":0},"Net Disposable Income",{"$f":"IF(E391-E393<0,0,E391-E393)","v":0}]
[]
[null,null,null,{"$f":"IF(vResidential,\"NDI\",\"NDI\")&\" Ratio\"","v":"NDI Ratio"},{"$f":"IF(vResidential,vAssessed_NDI,vAssessed_NDI)","v":"1.00 : 1"}]
[]
[null,null,null,"DTI Ratio",{"$f":"vAssessed_DTI","v":"1.0"}]
[]
[null,null,null,"LVR",{"$f":"vLVR","v":0}]
[]
[null,null,null,"Maximum Loan Amount",{"$f":"-PV((vLoan_Rate+vBuffer)/12,(vLoan_Term-IF(bIO,vLoan_IOPeriod,0)*12),vAssessed_Available_Income/12)","v":0}]
[]
[]
[null,"Notes  (Optional)"]

{"sheet":"User Guide","index":1,"n_rows":675,"n_cols":1,"rows_kept":675,"cut":false,"hidden":false,"merged":[]}
[]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A2+1","v":2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A2+1","v":2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A173+1","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"A230+1","v":2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[8]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[9]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[10]

{"sheet":"Administration","index":2,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":true,"merged":[[1,1,1,4],[3,2,3,3]]}
[]
[null,"Administration"]
[]
[null,"Version","4.00  (1 July 2026)"]
[]
[null,"Parameter","Regulated","Unregulated"]
[null,"Buffer",0.02,0.02]
[null,"Buffer (for Refinance)",0.02,0.02,null,null,"Purpose of Loan Refinance Buffer included"]
[null,"Floor Rate",0.06,0.06]
[null,"Interest Gearing",3.7499999999999999E-2,3.7499999999999999E-2]
[null,"Credit Card Rate",3.7999999999999999E-2,3.7999999999999999E-2]
[null,"Loan Term (years)",30,30]
[null,"Rental Shading",0.8,0.8]
[null,"Property Expense %",0,0,null,null,"Property Expense % included"]
[]
[null,"PAYG","Taxable Income from","% on Excess","Income Tax"]
[null,null,0,0,0]
[null,null,18200,0.15,{"$f":"(C18-C17)*D17+E17","v":0}]
[null,null,45000,0.3,{"$f":"(C19-C18)*D18+E18","v":4020}]
[null,null,135000,0.37,31020]
[null,null,190000,0.45,51370]
[]
[null,"Medicare",0.02]
[]
[null,"Company Tax Rate",0.25]

{"sheet":"HEM","index":3,"n_rows":170,"n_cols":18,"rows_kept":170,"cut":false,"hidden":true,"merged":[[0,4,0,17],[0,0,0,2]]}
["Categories",null,null,"HEM","Gross Income (from)"]
["Region","Household","Dependents",null,0,27000,41000,54000,68000,82000,109000,136000,163000,191000,218000,272000,341000,409000]
[]
[]
[null,null,null,"Australia"]
["Australia","Couple",0,"Couple",0,623.39132412634933,639.69642810008213,663.63034313580499,707.14957645287461,767.25098560479501,854.53837407574485,928.62948251094986,1017.6434839161407,1064.7704831526985,1119.8659485400419,1251.4415163417841,1406.9724497040506,1444.0438104934062]
["Australia","Couple",1,"Couple with 1 child",0,0,735.80124082345844,759.71244278743734,803.19037835163249,863.23475688347708,950.43931371632641,1024.4601142653664,1113.3896443510082,1160.4719261882794,1215.5151076874852,1346.965817762592,1502.3491617638679,1539.3853430981133]
["Australia","Couple",2,"Couple with 2 children",0,0,813.60502406376827,837.60939608666047,881.25673850471617,941.53506991582321,1029.0794098415695,1103.3886235276705,1192.6646604350935,1239.9303893881561,1295.1880411236909,1427.1509339709362,1583.1397109256159,1620.320201039852]
["Australia","Couple","3 and above","Couple with 3 children",0,0,0,903.42676029456754,947.22257529076217,1007.7059534979903,1095.5480889549835,1170.1100743379557,1259.6897946214078,1307.1163053111861,1362.5619225283608,1494.9737079619383,1651.493102344783,1688.8000682311683]
[null,""]
["Australia","Single",0,"Single person",319.95367492125018,337.09493014794083,353.24325491838357,376.94703715326239,420.047817780755,479.57133183916068,566.01942198658423,639.39811921506805,727.55621934749888,774.23007760877567,828.79578083929698,959.10620498547155,1113.1416546540993,1149.8565606040008]
["Australia","Single",1,"Single parent with 1 child",0,438.61233996708393,454.66012855694038,478.21633880241353,521.04878341082781,580.20171607757629,666.11160318276359,739.0334601485381,826.64271220924047,873.02598818708168,927.25197656798889,1056.7511201164898,1209.8275845073151,1246.3139104375582]
["Australia","Single",2,"Single parent with 2 children",0,557.15547087948266,573.21452468930192,596.78727163904136,639.64978620686941,698.84424394636358,784.81443849420702,857.78748697871697,945.45824185684967,991.87407893034185,1046.1381382973575,1175.7281863140115,1328.9121086048649,1365.4240547875124]
["Australia","Single","3 and above","Single parent with 3 children",0,0,691.76892082166341,715.35820447566925,758.25078900291101,817.48677181515086,903.51727380565046,976.54151380889584,1064.2737715044589,1110.7221696736019,1165.024300026726,1294.7052525115332,1447.9966327024147,1484.5341991374667]
[]
[]
[null,null,null,"Sydney"]
["Sydney","Couple",0,"Couple",0,616.28517039522762,632.59027464038058,656.52418926287396,700.04342220788442,760.14483222133526,847.43222177491623,921.52332917628451,1010.5373299776417,1057.6643298851261,1112.7597955713366,1244.3353638427268,1399.8662978149264,1436.9376569574633]
["Sydney","Couple",1,"Couple with 1 child",0,0,727.26595872571625,751.17716264232752,794.65509750445267,854.69947507095083,941.9040312894889,1015.9248324235871,1104.8543630065287,1151.9366432348895,1206.9798264015117,1338.4305363011013,1493.8138789567422,1530.8500631577742]
["Sydney","Couple",2,"Couple with 2 children",0,0,805.54183409863469,829.54620407775519,873.19354663419108,933.4718802380952,1021.0162202489987,1095.325433413512,1184.6014695545207,1231.8671990611044,1287.124850626325,1419.0877430052062,1575.0765208966147,1612.2570096483357]
["Sydney","Couple","3 and above","Couple with 3 children",0,0,0,898.59512136185811,942.3909369125729,1002.8743147987631,1090.7164486797519,1165.278436572657,1254.8581574398147,1302.2846671372938,1357.7302834789102,1490.1420697296753,1646.6614628283685,1683.9684250957805]
[null,""]
["Sydney","Single",0,"Single person",312.71429925986797,329.85555488004417,346.00387906194021,369.70766205063813,412.80844234326213,472.33195620578942,558.7800468116518,632.15874383675543,720.3168437591379,766.9907015336363,821.55640516424944,951.8668285835904,1105.9022792391113,1142.6171860158697]
["Sydney","Single",1,"Single parent with 1 child",0,429.45830404830633,445.50609323763439,469.0623023627835,511.89474740360362,571.04768136756923,656.957566625205,729.87942567438847,817.48867557306255,863.87195430257634,918.09794386277201,1047.5970849740772,1200.6735477138989,1237.1598764744333]
["Sydney","Single",2,"Single parent with 2 children",0,547.20694039213856,563.26599674234615,586.8387402094877,629.70125484887603,688.89571430581566,774.86591128670705,847.83895938956232,935.5097109282176,981.92555143660081,1036.1896051742115,1165.7796546220702,1318.9635811111241,1355.4755232863984]
["Sydney","Single","3 and above","Single parent with 3 children",0,0,681.02590024705796,704.61517805619189,747.50776229414851,806.74374724406209,892.77425594820909,965.79849310473617,1053.5307462833725,1099.9791485706253,1154.281266485651,1283.9622242700632,1437.2536145083493,1473.7911700983634]
[]
[]
[null,null,null,"Balance of NSW"]
["Balance of NSW","Couple",0,"Couple",0,636.5749508786057,652.88005438802702,676.81396993914336,720.3332033050076,780.43461219008236,867.72200045670468,941.81310919687598,1030.82711066306,1077.9541100338035,1133.0495739939033,1264.6251434119679,1420.1560769450159,1457.2274363071283]
["Balance of NSW","Couple",1,"Couple with 1 child",0,0,747.53648536069522,771.44768702483145,814.92562247201511,874.9700002579101,962.17455979665476,1036.1953578591961,1125.1248905483483,1172.2071702794092,1227.2503489995877,1358.7010633456209,1514.0844074054019,1551.1205845272273]
["Balance of NSW","Couple",2,"Couple with 2 children",0,0,825.89134191201424,849.89571316849219,893.54305461256274,953.82138820582213,1041.3657271841951,1115.6749414770409,1204.9509768303453,1252.2167057408292,1307.4743586685647,1439.4372520054637,1595.4260285343573,1632.6065182228076]
["Balance of NSW","Couple","3 and above","Couple with 3 children",null,null,null,919.01385133618169,962.80966691608182,1023.2930454151626,1111.1351785081492,1185.6971670431303,1275.2768852252434,1322.7033963236152,1378.1490160507226,1510.5607978069568,1667.0801912558729,1704.3871543404725]
[null,""]
["Balance of NSW","Single",0,"Single person",332.80898617064111,349.95024176214082,366.09856587912606,389.80234885636293,432.90312973620524,492.42664296775422,578.87473352193797,652.25342985688314,740.41153083284121,787.08538854732558,841.65109231130282,971.96151635078627,1125.9969667662522,1162.7118712824911]
["Balance of NSW","Single",1,"Single parent with 1 child",0,449.42788669960925,465.47567595772909,489.03188443426973,531.86432904268418,591.01726440214077,676.92714903082287,749.84900709726617,837.45825731041703,883.84153313101967,938.06752316293068,1067.5666677334816,1220.6431290581572,1257.129456089069]
["Balance of NSW","Single",2,"Single parent with 2 children",0,567.19054409644616,583.24959846682054,606.82234274497807,649.68485626325605,708.87931710369355,794.84951198548481,867.82256161495843,955.49331429857727,1001.9091542344788,1056.1732104528444,1185.7632640989034,1338.9471877255482,1375.4591251301399]
["Balance of NSW","Single","3 and above","Single parent with 3 children",0,0,701.02352097591199,724.61280105568642,767.50538348382793,826.74136980524634,912.77187494014674,985.7961161326507,1073.5283712867376,1119.9767753379379,1174.2788977427581,1303.9598604643252,1457.2512463929393,1493.7887941712108]
[]
[]
[null,null,null,"Melbourne"]
["Melbourne","Couple",0,"Couple",0,623.72884519680986,640.03394872071715,663.96786442584141,707.48709754773256,767.58850640688502,854.87589501202024,928.96700381928417,1017.9810049866011,1065.1080053088399,1120.203468585815,1251.7790382844485,1407.309971549126,1444.3813304476896]
["Melbourne","Couple",1,"Couple with 1 child",0,0,734.70256942841195,758.61377177267889,802.09170714672985,862.13608518127489,949.34064354990278,1023.3614440989426,1112.2909741845842,1159.3732552905328,1214.4164341862286,1345.8671493220907,1501.2504925627902,1538.2866703281795]
["Melbourne","Couple",2,"Couple with 2 children",0,0,813.00742100465845,837.01179161713537,880.65913449291077,940.93746652140726,1028.4818054678462,1102.7910195158649,1192.0670573387276,1239.3327855892435,1294.5904366222319,1426.5533308958597,1582.5421091704754,1619.7225962190532]
["Melbourne","Couple","3 and above","Couple with 3 children",0,0,null,906.0861041972114,949.88191869725654,1010.3652974881901,1098.2074301142122,1172.7694178320057,1262.3491379403467,1309.7756468790087,1365.2212680653797,1497.6330510473949,1654.1524437958647,1691.4594097989911]
[null,""]
["Melbourne","Single",0,"Single person",320.08640078508313,337.22765582197434,353.37598018601835,377.07976306781666,420.18054361258197,479.70405737925381,566.15214795177519,639.53084454011184,727.68894485925205,774.36280351395283,828.92850594429024,959.23893081063022,1113.2743808126679,1149.9892851888746]
["Melbourne","Single",1,"Single parent with 1 child",0,436.78450933054876,452.83229772385727,476.38850585643871,519.22095186034426,578.37388672843088,664.2837715143512,737.20562926631771,824.81487904706307,871.19815706900363,925.42414419200361,1054.9232898632235,1207.9997507161838,1244.48607931948]
["Melbourne","Single",2,"Single parent with 2 children",0,554.53829093350362,570.59734337175178,594.17009024993115,637.03260324343398,696.22706327285562,782.19725758216487,855.17030649603646,942.84106185123721,989.25689615773365,1043.5209550476811,1173.1110075487766,1326.2949307937668,1362.8068699158041]
["Melbourne","Single","3 and above","Single parent with 3 children",0,0,688.36238901964634,711.95167464342353,754.84425462652371,814.08023981728036,900.11074364997853,973.13498372575521,1060.8672446554115,1107.3156352464637,1161.6177659033588,1291.2987252343296,1444.5901108713497,1481.1276605121282]
[]
[]
[null,null,null,"Balance of VIC"]
["Balance of VIC","Couple",0,"Couple",0,664.24024087328621,680.54534493088477,704.47925939022093,747.99849247551595,808.09990271769152,895.38729068544671,969.47839970008783,1058.4924003794586,1105.6193998050958,1160.7148658328688,1292.2904332625517,1447.8213666736128,1484.8927274629687]
["Balance of VIC","Couple",1,"Couple with 1 child",0,0,775.17552086055559,799.08672456508316,842.56466176744209,902.60903706683894,989.81359451399976,1063.8343941123196,1152.7639296097516,1199.846205186898,1254.8893880609912,1386.3400986919037,1541.7234418740968,1578.7596235008721]
["Balance of VIC","Couple",2,"Couple with 2 children",0,0,853.63807212132099,877.64244128080361,921.28978519975442,981.56811837787268,1069.1124578565439,1143.4216727880685,1232.6977073110907,1279.9634386485538,1335.2210878080843,1467.1839818262411,1623.1727590363919,1660.3532482564779]
["Balance of VIC","Couple","3 and above","Couple with 3 children",0,0,null,946.85496513885039,990.65078063119461,1051.1341580796059,1138.9762945872685,1213.5382802037229,1303.117999027912,1350.5445099511721,1405.9901277520523,1538.4019128354064,1694.9213054671352,1732.2282672675831]
[null,""]
["Balance of VIC","Single",0,"Single person",360.20826498638797,377.34952018807616,393.49784536869134,417.20162750073399,460.30240766207777,519.82592254400595,606.27401196959727,679.65270939145864,767.81081064414684,814.48466747842917,869.05037016215806,999.36079466174738,1153.396243736905,1190.1111505270001]
["Balance of VIC","Single",1,"Single parent with 1 child",0,476.65658403808158,492.70437314879041,516.26058135016365,559.0930271968308,618.24596257594237,704.15584641843213,777.07770597864067,864.6869565062683,911.07023122620194,965.2962207077785,1094.7953647279946,1247.8718288829623,1284.3581559138738]
["Balance of VIC","Single",2,"Single parent with 2 children",0,594.43835475728861,610.49741051116098,634.07015257095122,676.93266687639164,736.12713005446346,822.09732288486146,895.07037485196952,982.74112515024706,1029.156964132012,1083.421022640305,1213.0110699890633,1366.1949926615716,1402.7069382717373]
["Balance of VIC","Single","3 and above","Single parent with 3 children",0,0,728.29044787353155,751.8797237917388,794.77230655595247,854.00829753298456,940.03879935129078,1013.0630437252984,1100.7952937942259,1147.2436970378221,1201.5458245728314,1331.2267752501321,1484.518156440181,1521.0557206296007]
[]
[]
[null,null,null,"Brisbane"]
["Brisbane","Couple",0,"Couple",0,600.03778817209025,616.34289230288073,640.27680743619294,683.796040693794,743.8974500271695,831.18483841272882,905.27594713155224,994.28994839645861,1041.4169482978436,1096.5124122274469,1228.0879815845185,1383.6189151541621,1420.6902741381164]
["Brisbane","Couple",1,"Couple with 1 child",0,0,711.03399438440715,734.94519648733728,778.42313186138858,838.46751017383622,925.67206901051077,999.69286915000953,1088.622399089387,1135.7046800198177,1190.7478585644783,1322.1985737588466,1477.5819176431105,1514.6180947649354]
["Brisbane","Couple",2,"Couple with 2 children",0,0,789.24662424875169,813.25099457382316,856.89833677366346,917.17666962179771,1004.7210083979222,1079.0302226481892,1168.3062606413662,1215.5719884235177,1270.829640031317,1402.7925336662663,1558.7813103228955,1595.96179898946]
["Brisbane","Couple","3 and above","Couple with 3 children",0,0,0,882.24448165802869,926.04029624562963,986.52367448204302,1074.3658081587348,1148.9277951760821,1238.5075163350921,1285.9340245149378,1341.3796456429379,1473.7914279245067,1630.3108198557891,1667.6177832906119]
[null,""]
["Brisbane","Single",0,"Single person",296.62314157242787,313.76439699866313,329.91272142758856,353.61650415831053,396.71728467431922,456.2407982634503,542.68888900934485,616.06758603444848,704.2256857467828,750.89954454151552,805.4652463850515,935.7756716848246,1089.811121780217,1126.5260261830963]
["Brisbane","Single",1,"Single parent with 1 child",0,413.4673266053685,429.51511493479887,453.07132291996936,495.90376941524494,555.05670422436719,640.9665878309994,713.88844668363481,801.49769685747617,847.88097425046328,902.10696160932071,1031.6061079094941,1184.682569627266,1221.1688983878009]
["Brisbane","Single",2,"Single parent with 2 children",0,531.20474010355053,547.26379216014402,570.83653891905635,613.69905184099912,672.89351201354111,758.86370627514361,831.83675576149687,919.50751054421596,965.92334485071217,1020.1874032635917,1149.77745662341,1302.9613806317088,1339.4733178454735]
["Brisbane","Single","3 and above","Single parent with 3 children",0,0,665.01246938548911,688.60175491814334,731.4943342667533,790.73031980271503,876.76082471928783,949.78506483935894,1037.5173242309556,1083.9657154509609,1138.2678449178627,1267.9488053373259,1421.2401916361516,1457.7777373031461]
[]
[]
[null,null,null,"Balance of QLD"]
["Balance of QLD","Couple",0,"Couple",0,666.44378721898829,682.74889105014927,706.68280581750162,750.20203857648255,810.30344877596292,897.59083710052892,971.68194553573358,1060.6959472153944,1107.8229463238663,1162.9184115099317,1294.4939795800444,1450.0249130642978,1487.0962743172024]
["Balance of QLD","Couple",1,"Couple with 1 child",0,0,777.37697598235809,801.28818028657054,844.76611604090976,904.81049193999138,992.01505159574788,1066.0358495997834,1154.9653836345697,1202.0476591239571,1257.0908419102914,1388.5415530385035,1543.9248961621911,1580.9610786080477]
["Balance of QLD","Couple",2,"Couple with 2 children",0,0,855.84810585407286,879.85247590770587,923.49981700050307,983.77815171145028,1071.3224897956727,1145.6317050252474,1234.9077396121377,1282.1734691825898,1337.431122344507,1469.394013999552,1625.3827918483819,1662.563281451675]
["Balance of QLD","Couple","3 and above","Couple with 3 children",0,0,0,949.07251808351612,992.86833124103896,1053.351708455968,1141.1938440005172,1215.7558308427529,1305.3355488497541,1352.7620613490187,1408.2076795584924,1540.6194635911772,1697.1388593749152,1734.4458167392022]
[null,""]
["Balance of QLD","Single",0,"Single person",362.39062370183848,379.53187881489634,395.68020395448639,419.38398558328845,462.48476620640503,522.00828079659948,608.45637098736643,681.83506721562037,769.99316838162213,816.66702629615247,871.2327287798355,1001.5431535394843,1155.5786033614806,1192.2935080577608]
["Balance of QLD","Single",1,"Single parent with 1 child",0,478.82535605766657,494.87314521751244,518.42935334026652,561.26179877418269,620.41473356365009,706.32461760268791,779.24647696634838,866.85572678640324,913.23900111324065,967.46499373958579,1096.9641359515601,1250.0406001065278,1286.5269252505782]
["Balance of QLD","Single",2,"Single parent with 2 children",0,596.60864880112558,612.66770610546962,636.24044990655887,679.10296161197755,738.29742493316974,824.26761690484466,897.24066729762774,984.91141711883733,1031.3272582951161,1085.5913157538591,1215.1813659650268,1368.3652914999443,1404.8772334843914]
["Balance of QLD","Single","3 and above","Single parent with 3 children",0,0,730.46226699342674,754.05154647285121,796.9441244497724,856.18011630268938,942.21061620700141,1015.2348576289071,1102.9671074512714,1149.4155154769915,1203.7176377681326,1333.3985959784934,1486.6899828933608,1523.2275417182045]
[]
[]
[null,null,null,"Adelaide"]
["Adelaide","Couple",0,"Couple",0,644.55408539419193,660.85918883575812,684.79310448141393,728.31233739135325,788.41374709983768,875.70113527192029,949.79224405783657,1038.8062453898356,1085.9332449252606,1141.0287095501876,1272.6042783156238,1428.1352116900894,1465.2065713083739]
["Adelaide","Couple",1,"Couple with 1 child",0,0,755.50804856055095,779.41924943485833,822.89718527695629,882.94156449624461,970.1461219872848,1044.1669226387096,1133.096451817511,1180.1787347371403,1235.2219133695598,1366.6726281543872,1522.0559715120983,1559.0921483413945]
["Adelaide","Couple",2,"Couple with 2 children",0,0,833.89396454367079,857.89833628448014,901.5456789473626,961.82401001784103,1049.3683509761179,1123.6775649389795,1212.9536019315599,1260.2193292879256,1315.4769808744352,1447.4398745093847,1603.4286515917997,1640.6091401732067]
["Adelaide","Couple","3 and above","Couple with 3 children",0,0,0,927.04369664094725,970.8395124835148,1031.3228894357765,1119.1650236961736,1193.7270105384093,1283.3067310553438,1330.7332395270416,1386.1788598378544,1518.590643520316,1675.1100368524912,1712.4170009877607]
[null,""]
["Adelaide","Single",0,"Single person",340.71139897374519,357.85265373618205,374.00097903106825,397.70476160362881,440.80554199085782,500.32905599758499,586.77714594996382,660.15584357853959,748.31394342423778,794.98780172552381,849.55350456928954,979.86392926892472,1133.8993790842528,1170.6142847140807]
["Adelaide","Single",1,"Single parent with 1 child",0,457.28110046831677,473.32889011953279,496.88509869434756,539.71754373516751,598.87047911427908,684.78036252436311,757.70222184871409,845.31147072533815,891.69475110585552,945.92073634199403,1075.4198837428369,1228.4963459323239,1264.9826707618975]
["Adelaide","Single",2,"Single parent with 2 children",0,575.04926995352946,591.10832336976739,614.68107155988434,657.54358469650776,716.7380444873952,802.70823746091344,875.68128732892126,963.35204249329502,1009.7678786126507,1064.03193807508,1193.6219873321115,1346.8059119128927,1383.3178523707213]
["Adelaide","Single","3 and above","Single parent with 3 children",0,0,708.88775662000194,732.47704442542113,775.36962565784802,834.60560986051132,920.63611239746376,993.66035280912843,1081.3926142612518,1127.8410061194459,1182.1431398081659,1311.8240909213862,1465.1154778934615,1501.6530339795452]
[]
[]
[null,null,null,"Balance of SA"]
["Balance of SA","Couple",0,"Couple",0,593.99119662754629,610.29630065541073,634.23021581159526,677.74944841809292,737.85085854743113,825.13824703667888,899.22935631054156,988.24335629458847,1035.3703568059066,1090.4658215101249,1222.0413903365545,1377.5723236134304,1414.643682841358]
["Balance of SA","Couple",1,"Couple with 1 child",0,0,704.99313993593375,728.90434324554678,772.38228071849517,832.42665546208661,919.63121347967933,993.65201337052838,1082.5815451235867,1129.6638232457371,1184.7070073777058,1316.15771692626,1471.5410598159247,1508.5772419107464]
["Balance of SA","Couple",2,"Couple with 2 children",0,0,783.18223350461665,807.18660253636369,850.83394506086574,911.11227971858978,998.65661963369155,1072.9658334794619,1162.2418672786484,1209.5075973174651,1264.7652483717422,1396.7281429008419,1552.7169181949566,1589.8974075427782]
["Balance of SA","Couple","3 and above","Couple with 3 children",0,0,0,876.15946126627546,919.95527658350795,980.43865636674036,1068.2807877377963,1142.8427759809247,1232.4224959141538,1279.849006487191,1335.2946256305934,1467.7064064528986,1624.2258000185561,1661.5327614687806]
[null,""]
["Balance of SA","Single",0,"Single person",290.63468984735226,307.775945223843,323.92426972643767,347.62805224419395,390.72883289315001,450.25234673900673,536.70043704146599,610.07913431329303,698.23723443905556,744.91109306708336,799.47679469056868,929.78721875005692,1083.8226685587165,1120.5375759156082]
["Balance of SA","Single",1,"Single parent with 1 child",0,407.51615716115271,423.56394596721208,447.12015358876869,489.95259980887704,549.10553438214163,635.01541869634673,707.93727876758021,795.54652693663127,841.92980535166816,896.15579436152927,1025.6549364162652,1178.7313974264641,1215.2177274449064]
["Balance of SA","Single",2,"Single parent with 2 children",0,525.24939195391721,541.30844529859496,564.88119050703551,607.74370328585758,666.93816622539555,752.90835967598196,825.8814111183151,913.55216189366104,959.96800230663052,1014.2320565213097,1143.822114079328,1297.0060344619087,1333.5179711031913]
["Balance of SA","Single","3 and above","Single parent with 3 children",0,0,659.0529446299779,682.64222742530228,725.53480676283812,784.77079806864947,870.80130065561718,943.82554346904999,1031.5577968506909,1078.0061992615929,1132.30831868109,1261.9892917423908,1415.2806714973533,1451.8182147614762]
[]
[]
[null,null,null,"Perth"]
["Perth","Couple",0,"Couple",0,570.40886846978628,586.7139719792076,610.64788738165271,654.16712089542568,714.26853036756097,801.55591835971336,875.64702792634375,964.66102822145683,1011.7880276470939,1066.8834924611001,1198.4590607324906,1353.9899939727709,1391.0613545913454]
["Perth","Couple",1,"Couple with 1 child",0,0,681.43318931617068,705.34439370082862,748.82232917726515,808.86670538350245,896.07126417629775,970.09206267763284,1059.0215974144892,1106.1038747760638,1161.1470570943513,1292.5977663503763,1447.9811095910759,1485.0172909253217]
["Perth","Couple",2,"Couple with 2 children",0,0,759.53048324384054,783.53485330279602,827.1821965245224,887.4605303306746,975.00486953258508,1049.3140843683077,1138.5901179758905,1185.855849249486,1241.1135009637317,1373.0763939812912,1529.0651702972918,1566.2456596025349]
["Perth","Couple","3 and above","Couple with 3 children",0,0,0,852.42725779536943,896.22307296667577,956.70645012323439,1044.5485867768234,1119.1105721597955,1208.6902916260603,1256.1168034832494,1311.5624213424994,1443.9742046163676,1600.4936014507748,1637.8005623172942]
[null,""]
["Perth","Single",0,"Single person",267.27911364543974,284.42036897788637,300.56869383299448,324.27247638661839,367.37325643168555,426.89677109439668,513.34486074837355,586.72355786016385,674.88165904283608,721.55551605049152,776.12121968110478,906.43164303376363,1060.4670921689353,1097.1819990457166]
["Perth","Single",1,"Single parent with 1 child",0,384.30598797614198,400.3537758952782,423.90998499094525,466.74243014969403,525.8953646639942,611.80525110091821,684.72710869564639,772.33635918396442,818.71963413975561,872.94562668748165,1002.4447674056906,1155.5212307744659,1192.0075576481395]
["Perth","Single",2,"Single parent with 2 children",0,502.02292758047525,518.08198171231561,541.65472789874605,584.51724158399793,643.71170266296951,729.68189711539924,802.65494731735498,890.32569637525512,936.74153631115678,991.00559558275881,1120.5956415003125,1273.7795616920657,1310.2915071114041]
["Perth","Single","3 and above","Single parent with 3 children",0,0,635.81018752935302,659.39947080654679,702.29205301830189,761.52804066194483,847.55854312988026,920.58278593906357,1008.3150335665458,1054.7634384825578,1109.0655644780359,1238.7465155949344,1392.0378926096655,1428.5754565746688]
[]
[]
[null,null,null,"Balance of WA"]
["Balance of WA","Couple",0,"Couple",0,623.66244064739305,639.96754505112858,663.90145979865815,707.42069266132773,767.52210298279476,854.80949233814727,928.90059988894916,1017.9146003670421,1065.0416007441745,1120.1370657106643,1251.7126337929756,1407.2435675943939,1444.3149275908368]
["Balance of WA","Couple",1,"Couple with 1 child",0,0,734.63622836777279,758.54743158962731,802.02536731471344,862.06974510060843,949.27430133377334,1023.2951033600855,1112.224633211704,1159.3069143761581,1214.3500969284689,1345.800805511677,1501.1841479918007,1538.220332485362]
["Balance of WA","Couple",2,"Couple with 2 children",0,0,812.94082024322211,836.94519242578417,880.59253463626919,940.87086671798886,1028.4152085384824,1102.7244208407792,1192.0004572159698,1239.266186062586,1294.523838245196,1426.4867304537627,1582.4755076639135,1619.6559972246282]
["Balance of WA","Couple","3 and above","Couple with 3 children",0,0,null,906.0192784870269,949.81509462144697,1010.2984704938536,1098.140606184329,1172.7025908668547,1262.2823131349051,1309.7088246418714,1365.1544409251171,1497.5662223894983,1654.0856189904234,1691.3925830089518]
[null,""]
["Balance of WA","Single",0,"Single person",320.02063512923439,337.16189031049799,353.31021531130625,377.01399701074945,420.11477772888793,479.63829236409282,566.08638215310066,639.465078931481,727.62318008414627,774.29703751189822,828.8627403956732,959.1731648419169,1113.2086152707193,1149.9235210072384]
["Balance of WA","Single",1,"Single parent with 1 child",0,436.71915360612843,452.7669416161682,476.323150171328,519.15559564455384,578.30852939231647,664.21841508235809,737.14027409223195,824.74952257576001,871.13280154113147,925.35879322404594,1054.8579318981554,1207.9343951883118,1244.4207225337002]
["Balance of WA","Single",2,"Single parent with 2 children",0,554.47288568989768,570.53194332818953,594.10468681918439,636.96720062370332,696.16166089165904,782.13185615510474,855.10490502126925,942.7756578003017,989.19149210679814,1043.455551760055,1173.0455974867814,1326.2295201592895,1362.7414655786279]
["Balance of WA","Single","3 and above","Single parent with 3 children",0,0,688.29694504021086,711.88622346704074,754.7788056028528,814.01479239100161,900.04529722785139,973.06953595030654,1060.8017930248434,1107.2501826724647,1161.552310296064,1291.2332630754074,1444.5246451302671,1481.0622086235555]
[]
[]
[null,null,null,"Hobart"]
["Hobart","Couple",0,"Couple",0,645.62222168571861,661.92732578753737,685.86124137677427,729.38047405951352,789.4818839143818,876.76927165036238,950.86038050337129,1039.8743821220387,1087.0013816208677,1142.0968462701924,1273.6724151759133,1429.2033488065504,1466.274707802703]
["Hobart","Couple",1,"Couple with 1 child",0,0,756.57517160942768,780.48637377817693,823.96430834777289,884.00868804973436,971.21324396111675,1045.2340465432344,1134.1635748444482,1181.245856535455,1236.2890384734546,1367.7397502452311,1523.1230933689187,1560.159271134308]
["Hobart","Couple",2,"Couple with 2 children",0,0,834.96524630464501,858.96961743338704,902.61696009626962,962.89529168833565,1050.4396314863461,1124.7488451830916,1214.024882175672,1261.290609851377,1316.548261459176,1448.5111546683395,1604.4999326023265,1641.6804215669406]
["Hobart","Couple","3 and above","Couple with 3 children",0,0,null,928.11862247918259,971.91443633715187,1032.3978142233423,1120.2399491258152,1194.8019352092338,1284.3816557845389,1331.8081644313481,1387.2537835163803,1519.6655698255158,1676.1849614065748,1713.4919251916208]
[null,""]
["Hobart","Single",0,"Single person",341.76926489123122,358.91052019863707,375.05884525169688,398.76262728996795,441.86340810812942,501.38692228489555,587.8350122656143,661.21370940407735,749.371810199994,796.04566766108678,850.61137019144724,980.92179437096297,1134.9572445130325,1171.6721509163719]
["Hobart","Single",1,"Single parent with 1 child",0,458.33238064726635,474.3801698857315,497.9363786374393,540.76882416962951,599.92175825152401,685.83164276227706,758.75350247972403,846.36275104187143,892.74603102929268,946.97201744471954,1076.4711643738469,1229.5476257771418,1266.0339512356693]
["Hobart","Single",2,"Single parent with 2 children",0,576.10128870144149,592.16033946995083,615.73308849493719,658.59560330129932,717.79006123162071,803.76025506386168,876.73330617224713,964.40405856962491,1010.8198972651489,1065.0839552963739,1194.6740044579915,1347.8579280846359,1384.3698717865286]
["Hobart","Single","3 and above","Single parent with 3 children",0,0,709.94050905417021,733.52979835243514,776.42238243296913,835.65836421171741,921.6888673654463,994.71310986477022,1082.4453660973784,1128.8937635010052,1183.1958931480283,1312.876844542136,1466.16823039213,1502.7057923373879]
[]
[]
[null,null,null,"Balance of TAS"]
["Balance of TAS","Couple",0,"Couple",0,639.00311474824684,655.30821827977832,679.24213394373191,722.76136734619229,782.86277627396237,870.15016494314034,944.24127364366586,1033.2552749268702,1080.3822742122229,1135.477738782256,1267.053307596487,1422.5842416174812,1459.6556005282434]
["Balance of TAS","Couple",1,"Couple with 1 child",0,0,749.96234564117026,773.87354704934353,817.35148235026247,877.39586158417717,964.60041834389438,1038.6212200776774,1127.550749900043,1174.6330323516256,1229.676211481345,1361.1269243939848,1516.5102675176731,1553.5464448735215]
["Balance of TAS","Couple",2,"Couple with 2 children",0,0,828.32665425544269,852.33102602818587,895.97836782885224,956.25669982541456,1043.8010399640536,1118.1102528518063,1207.3862901424366,1254.6520186910027,1309.9096704265376,1441.8725630821791,1597.8613389723944,1635.0418285756871]
["Balance of TAS","Couple","3 and above","Couple with 3 children",0,0,null,921.45744709241728,965.25326261394673,1025.7366397705052,1113.5787749356457,1188.1407620113637,1277.720484279414,1325.1469926927412,1380.5926102017686,1513.0043940593414,1669.5237894928562,1706.830752927679]
[null,""]
["Balance of TAS","Single",0,"Single person",335.21380296192342,352.35505789497245,368.50338261024626,392.20716523448539,435.30794597596253,494.83146009271485,581.27954957498559,654.65824767366939,742.8163480061462,789.49020583399022,844.05590833767769,974.36633301730819,1128.4017827659541,1165.1166887558652]
["Balance of TAS","Single",1,"Single parent with 1 child",0,451.81773121662815,467.86552133955945,491.42172930507513,534.25417458175298,593.40710913536259,679.3169941571407,752.23885179117838,839.84810176847157,886.23138277794271,940.45736809270045,1069.9565134494435,1223.0329770540766,1259.5193031415577]
["Balance of TAS","Single",2,"Single parent with 2 children",0,569.58206596217531,585.64111775638128,609.21386575567101,652.07638108680828,711.27083882630234,797.24103246771608,870.21408290820591,957.88483492392913,1004.3006740011078,1058.564732509401,1188.1547792856773,1341.3387032939768,1377.8506460417327]
["Balance of TAS","Single","3 and above","Single parent with 3 children",0,0,703.4167141732031,727.00600220626688,769.89858759186359,829.13456851724209,915.16507077829147,988.18931402523344,1075.9215680793868,1122.3699652242731,1176.6720969261014,1306.353045121911,1459.644429533877,1496.1819889419078]
[]
[]
[null,null,null,"ACT & NT"]
["ACT & NT","Couple",0,"Couple",0,653.56924075782354,669.87434496180617,693.80826000515322,737.32749264214749,797.42890282637961,884.7162919713054,958.80740020218252,1047.8214007595664,1094.9484009354214,1150.0438658958115,1281.6194339110302,1437.1503676392567,1474.2217274161237]
["ACT & NT","Couple",1,"Couple with 1 child",0,0,764.51464921128593,788.42585224299648,831.90378741227721,891.94816609038639,979.15272165073384,1053.1735234430228,1142.1030524170535,1189.1853336107606,1244.2285179474995,1375.6792257701318,1531.062568425773,1568.0987530948516]
["ACT & NT","Couple",2,"Couple with 2 children",0,0,842.93565865249593,866.94003026024723,910.58737262507964,970.86570441939375,1058.4100464634248,1132.7192584996053,1221.995295023821,1269.2610243175125,1324.5186757337078,1456.4815681338782,1612.4703459827081,1649.6508353731083]
["ACT & NT","Couple","3 and above","Couple with 3 children",0,0,0,936.11614822355114,979.91196412448892,1040.3953401136366,1128.2374750744805,1202.7994603407117,1292.3791823169095,1339.8056938238751,1395.2513105157147,1527.6630926221721,1684.1824866547936,1721.4894518407325]
[null,""]
["ACT & NT","Single",0,"Single person",349.63987097485074,366.78112632601665,382.92945119194997,406.63323312936467,449.7340136874663,509.25752820597762,595.70561805666648,669.08431501842233,757.24241608106684,803.91627340212767,858.48197655929869,988.79240095219689,1142.8278510875982,1179.5427570241636]
["ACT & NT","Single",1,"Single parent with 1 child",0,466.15398691512206,482.20177499395362,505.75798423703162,548.59042904199407,607.74336324181729,693.6532489318588,766.57510766656549,854.18435583561666,900.56763456513045,954.79362664114103,1084.2927672021117,1237.3692290771221,1273.8555554790801]
["ACT & NT","Single",2,"Single parent with 2 children",0,583.92838231086091,599.98743971061856,623.56018434657722,666.42269838963023,725.61715770344938,811.58735353937698,884.56040130828478,972.23115351483534,1018.6469906837409,1072.9110494782749,1202.5010953958288,1355.6850173050277,1392.1969619610568]
["ACT & NT","Single","3 and above","Single parent with 3 children",0,0,717.77310442728344,741.36238445612275,784.25496773726638,843.49095216508147,929.52145814689516,1002.5456949500041,1090.2779511940539,1136.7263468023514,1191.0284723154086,1320.7094235895458,1474.0008055329333,1510.5383684430335]

{"sheet":"Branding","index":4,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":true,"merged":[[3,2,3,3],[8,2,8,3],[6,2,6,5],[1,2,1,5]]}
[]
[null,null,"Form Logo"]
[]
[]
[]
[]
[null,null,"Form Colors"]
[]
[null,null,"Enter the Hex Code",null,null,"Color"]
[]
[null,null,"Header 1","#BDD646"]
[]
[null,null,"Header 2","#0087A4"]
[]
[null,null,"Data Entry","#FFFFFF"]

{"sheet":"Postcodes","index":5,"n_rows":63,"n_cols":4,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
["From","To","State","Location"]
[200,799,"ACT","Non Metro"]
[800,820,"NT","Metro"]
[821,827,"NT","Non Metro"]
[828,832,"NT","Metro"]
[833,999,"NT","Non Metro"]
[1000,1920,"NSW","Metro"]
[1921,1999,"NSW","Non Metro"]
[2000,2005,"NSW","Inner City"]
[2006,2249,"NSW","Metro"]
[2250,2557,"NSW","Non Metro"]
[2558,2574,"NSW","Metro"]
[2575,2599,"NSW","Non Metro"]
[2600,2639,"ACT","Metro"]
[2640,2739,"NSW","Non Metro"]
[2740,2786,"NSW","Metro"]
[2787,2899,"NSW","Non Metro"]
[2900,2920,"ACT","Metro"]
[2921,2999,"NSW","Non Metro"]
[3000,3010,"VIC","Inner City"]
[3011,3216,"VIC","Metro"]
[3217,3334,"VIC","Non Metro"]
[3335,3341,"VIC","Metro"]
[3342,3424,"VIC","Non Metro"]
[3425,3443,"VIC","Metro"]
[3444,3749,"VIC","Non Metro"]
[3750,3811,"VIC","Metro"]
[3812,3909,"VIC","Non Metro"]
[3910,3920,"VIC","Metro"]
[3921,3925,"VIC","Non Metro"]
[3926,3944,"VIC","Metro"]
[3945,3971,"VIC","Non Metro"]
[3972,3978,"VIC","Metro"]
[3979,3979,"VIC","Non Metro"]
[3980,3983,"VIC","Metro"]
[3984,3999,"VIC","Non Metro"]
[4000,4004,"QLD","Inner City"]
[4005,4209,"QLD","Metro"]
[4210,4299,"QLD","Non Metro"]
[4300,4306,"QLD","Metro"]
[4307,4499,"QLD","Non Metro"]
[4500,4549,"QLD","Metro"]
[4550,4999,"QLD","Non Metro"]
[5000,5005,"SA","Inner City"]
[5006,5199,"SA","Metro"]
[5200,5799,"SA","Non Metro"]
[5800,5999,"SA","Metro"]
[6000,6004,"WA","Inner City"]
[6005,6214,"WA","Metro"]
[6215,6799,"WA","Non Metro"]
[6800,6999,"WA","Metro"]
[7000,7003,"TAS","Inner City"]
[7004,7199,"TAS","Metro"]
[7200,7799,"TAS","Non Metro"]
[7800,7899,"TAS","Metro"]
[7900,7999,"TAS","Non Metro"]
[8000,8399,"VIC","Inner City"]
[8400,8899,"VIC","Metro"]
[8900,8999,"VIC","Non Metro"]
[9000,9299,"QLD","Inner City"]
[9300,9399,"QLD","Non Metro"]
[9400,9596,"QLD","Metro"]
[9597,9597,"QLD","Non Metro"]

{"sheet":"Calculations","index":6,"n_rows":87,"n_cols":11,"rows_kept":87,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Applicants","Total","1","2","3","4","5","6",null,"Calculation Notes"]
[null,"PAYG Gross",{"$f":"IF(vApplicants<=0,0,SUM(OFFSET($D3,0,0,1,vApplicants)))","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C28,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C28,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C28,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C28,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C28,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C28,(I$2-1)*vApplicant_Rows,0)","v":0}]
[null,"Self Employed Income",0,{"$f":"OFFSET('Serviceability Calculator'!$C34,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C34,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C34,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C34,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C34,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C34,(I$2-1)*vApplicant_Rows,0)","v":0},null,"Self Employed Net Profit (Loss) Before Tax (NPBT)"]
[null,"Overtime / Allowance",0,{"$f":"OFFSET('Serviceability Calculator'!$C44,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C44,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C44,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C44,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C44,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C44,(I$2-1)*vApplicant_Rows,0)","v":0}]
[null,"Bonus / Commission",0,{"$f":"OFFSET('Serviceability Calculator'!$C46,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C46,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C46,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C46,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C46,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C46,(I$2-1)*vApplicant_Rows,0)","v":0}]
[null,"Investment",0,{"$f":"OFFSET('Serviceability Calculator'!$C48,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C48,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C48,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C48,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C48,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C48,(I$2-1)*vApplicant_Rows,0)","v":0}]
[null,"Other",0,{"$f":"OFFSET('Serviceability Calculator'!$C50,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C50,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C50,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C50,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C50,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C50,(I$2-1)*vApplicant_Rows,0)","v":0}]
[null,"Rental Income 1",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C57,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C57,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C57,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C57,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C57,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C57,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(I$2-1)*vApplicant_Rows,0),2)","v":0},null,"% Ownership applied to Rent Received"]
[null,"Rental Income 2",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C58,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C58,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C58,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C58,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C58,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C58,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 3",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C59,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C59,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C59,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C59,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C59,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C59,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 4",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C60,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C60,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C60,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C60,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C60,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C60,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 5",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C61,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C61,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C61,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C61,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C61,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C61,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 6",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C62,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C62,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C62,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C62,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C62,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C62,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 7",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C63,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C63,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C63,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C63,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C63,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C63,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 8",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C64,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C64,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C64,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C64,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C64,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C64,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 9",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C65,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C65,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C65,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C65,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C65,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C65,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Rental Income 10",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C66,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(D$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C66,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(E$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C66,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(F$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C66,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(G$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C66,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(H$2-1)*vApplicant_Rows,0),2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$C66,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(I$2-1)*vApplicant_Rows,0),2)","v":0}]
[null,"Total Income",0,{"$f":"SUM(D3:D18)","v":0},0,0,0,0,0]
[null,"Rental Shading",0,{"$f":"SUM(D9:D18)*(1-vRentalShading)","v":0},0,0,0,0,0]
[null,"Gross Annual Income",0,{"$f":"D19-D20","v":0},{"$f":"E19-E20","v":0},0,0,0,0]
[null,"Interest Deductions 1",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E57,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E57,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E57,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E57,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E57,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E57,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D57,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},null,"Gearing Rate entered for the Investment Loan Amount, % Ownership also applied"]
[null,"Interest Deductions 2",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E58,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E58,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E58,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E58,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E58,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E58,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D58,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 3",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E59,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E59,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E59,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E59,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E59,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E59,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D59,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 4",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E60,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E60,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E60,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E60,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E60,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E60,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D60,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 5",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E61,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E61,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E61,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E61,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E61,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E61,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D61,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 6",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E62,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E62,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E62,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E62,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E62,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E62,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D62,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 7",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E63,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E63,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E63,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E63,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E63,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E63,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D63,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 8",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E64,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E64,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E64,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E64,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E64,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E64,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D64,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 9",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E65,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E65,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E65,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E65,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E65,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E65,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D65,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,"Interest Deductions 10",0,{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E66,(D$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(D$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E66,(E$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(E$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E66,(F$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(F$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E66,(G$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(G$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E66,(H$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(H$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0},{"$f":"ROUND(OFFSET('Serviceability Calculator'!$E66,(I$2-1)*vApplicant_Rows,0)*OFFSET('Serviceability Calculator'!$D66,(I$2-1)*vApplicant_Rows,0)*vGearing,2)","v":0}]
[null,{"$f":"\"Rental Deductions \"&IF(vPropertyExpense=0,\"(N/A)\",\"@ \"&TEXT(vPropertyExpense,\"0.00%\"))","v":"Rental Deductions (N/A)"},0,{"$f":"IF(vPropertyExpense=0,0,ROUND(SUM(D9:D18)/(1-vPropertyExpense)*vPropertyExpense,2))","v":0},{"$f":"IF(vPropertyExpense=0,0,ROUND(SUM(E9:E18)/(1-vPropertyExpense)*vPropertyExpense,2))","v":0},0,0,0,0]
[null,"Taxable Gross Income",0,{"$f":"D21-SUM(D22:D32)","v":0},{"$f":"E21-SUM(E22:E32)","v":0},0,0,0,0,null,"Taxable Gross Income used for HEM Calculation"]
[null,"Income Tax and Medicare",0,{"$f":"IF(D33<=0,0,ROUND(VLOOKUP(D33,tIncomeTax,3)+(D33-VLOOKUP(D33,tIncomeTax,1))*VLOOKUP(D33,tIncomeTax,2)+D33*vMedicareLevy,2))","v":0},0,0,0,0,0,null,"From PAYG Table plus Medicare Rate"]
[null,"Non-Taxable",0,{"$f":"OFFSET('Serviceability Calculator'!$C30,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C30,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C30,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C30,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C30,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C30,(I$2-1)*vApplicant_Rows,0)","v":0}]
[null,"Self Employed Add Backs",0,{"$f":"OFFSET('Serviceability Calculator'!$C36,(D$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C38,(D$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C40,(D$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C36,(E$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C38,(E$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C40,(E$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C36,(F$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C38,(F$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C40,(F$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C36,(G$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C38,(G$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C40,(G$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C36,(H$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C38,(H$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C40,(H$2-1)*vApplicant_Rows,0)","v":0},{"$f":"OFFSET('Serviceability Calculator'!$C36,(I$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C38,(I$2-1)*vApplicant_Rows,0)+OFFSET('Serviceability Calculator'!$C40,(I$2-1)*vApplicant_Rows,0)","v":0},null,"Includes Interest, Other Addbacks and Depreciation"]
[null,"Net Annual Income",0,{"$f":"D21-D34+D35+D36","v":0},0,0,0,0,0]
[null,"Hem Expenses (Weekly)",0,{"$f":"ROUND(OFFSET(vHEM,D$2,0),0)","v":0},0,0,0,0,0]
[null,"HEM Expenses",0,{"$f":"ROUND(D38*52/12,0)","v":0},{"$f":"ROUND(E38*52/12,0)","v":0},0,0,0,0,null,"From the HEM Table"]
[]
[null,"Company","Total","1"]
[null,"Company Net Profit Before Tax",{"$f":"IF(vCompany,D42,0)","v":0},{"$f":"'Serviceability Calculator'!$C330","v":0}]
[null,"Rental Income 1",0,{"$f":"ROUND('Serviceability Calculator'!$C343*'Serviceability Calculator'!$D343,2)","v":0},null,null,null,null,null,null,"% Ownership applied to Rent Received"]
[null,"Rental Income 2",0,{"$f":"ROUND('Serviceability Calculator'!$C344*'Serviceability Calculator'!$D344,2)","v":0}]
[null,"Rental Income 3",0,{"$f":"ROUND('Serviceability Calculator'!$C345*'Serviceability Calculator'!$D345,2)","v":0}]
[null,"Rental Income 4",0,{"$f":"ROUND('Serviceability Calculator'!$C346*'Serviceability Calculator'!$D346,2)","v":0}]
[null,"Rental Income 5",0,{"$f":"ROUND('Serviceability Calculator'!$C347*'Serviceability Calculator'!$D347,2)","v":0}]
[null,"Rental Income 6",0,{"$f":"ROUND('Serviceability Calculator'!$C348*'Serviceability Calculator'!$D348,2)","v":0}]
[null,"Rental Income 7",0,{"$f":"ROUND('Serviceability Calculator'!$C349*'Serviceability Calculator'!$D349,2)","v":0}]
[null,"Rental Income 8",0,{"$f":"ROUND('Serviceability Calculator'!$C350*'Serviceability Calculator'!$D350,2)","v":0}]
[null,"Rental Income 9",0,{"$f":"ROUND('Serviceability Calculator'!$C351*'Serviceability Calculator'!$D351,2)","v":0}]
[null,"Rental Income 10",0,{"$f":"ROUND('Serviceability Calculator'!$C352*'Serviceability Calculator'!$D352,2)","v":0}]
[null,"Total Income",0,{"$f":"SUM(D42:D52)","v":0}]
[null,"Rental Shading",0,{"$f":"SUM(D43:D52)*(1-vRentalShading)","v":0}]
[null,"Gross Annual Income",0,{"$f":"D53-D54","v":0}]
[null,"Interest Deductions 1",0,{"$f":"ROUND('Serviceability Calculator'!$E343*'Serviceability Calculator'!$D343*vGearing,2)","v":0},null,null,null,null,null,null,"Gearing Rate entered for the Investment Loan Amount, % Ownership also applied"]
[null,"Interest Deductions 2",0,{"$f":"ROUND('Serviceability Calculator'!$E344*'Serviceability Calculator'!$D344*vGearing,2)","v":0}]
[null,"Interest Deductions 3",0,{"$f":"ROUND('Serviceability Calculator'!$E345*'Serviceability Calculator'!$D345*vGearing,2)","v":0}]
[null,"Interest Deductions 4",0,{"$f":"ROUND('Serviceability Calculator'!$E346*'Serviceability Calculator'!$D346*vGearing,2)","v":0}]
[null,"Interest Deductions 5",0,{"$f":"ROUND('Serviceability Calculator'!$E347*'Serviceability Calculator'!$D347*vGearing,2)","v":0}]
[null,"Interest Deductions 6",0,{"$f":"ROUND('Serviceability Calculator'!$E348*'Serviceability Calculator'!$D348*vGearing,2)","v":0}]
[null,"Interest Deductions 7",0,{"$f":"ROUND('Serviceability Calculator'!$E349*'Serviceability Calculator'!$D349*vGearing,2)","v":0}]
[null,"Interest Deductions 8",0,{"$f":"ROUND('Serviceability Calculator'!$E350*'Serviceability Calculator'!$D350*vGearing,2)","v":0}]
[null,"Interest Deductions 9",0,{"$f":"ROUND('Serviceability Calculator'!$E351*'Serviceability Calculator'!$D351*vGearing,2)","v":0}]
[null,"Interest Deductions 10",0,{"$f":"ROUND('Serviceability Calculator'!$E352*'Serviceability Calculator'!$D352*vGearing,2)","v":0}]
[null,"Taxable Gross Income",0,{"$f":"D55-SUM(D56:D65)","v":0}]
[null,{"$f":"\"Company Tax @ \"&TEXT(vCompanyTaxRate,\"0.00%\")","v":"Company Tax @ 25.00%"},0,{"$f":"IF(D66<=0,0,ROUND(D66*vCompanyTaxRate,2))","v":0},null,null,null,null,null,null,"Using Company Tax Rate entered"]
[null,"Company Addbacks",0,{"$f":"'Serviceability Calculator'!$C332+'Serviceability Calculator'!$C334+'Serviceability Calculator'!$C336","v":0},null,null,null,null,null,null,"Includes Interest, Other Addbacks and Depreciation"]
[null,"Company Profit After Tax",0,{"$f":"D55-D67+D68","v":0}]
[]
[null,"Commitments (Annual)","Used","Repayment","Limit",{"$f":"\"Assessed at \"&TEXT(vFloorRate,\"0.00%\")","v":"Assessed at 6.00%"}]
[null,"Commitment 1",{"$f":"IF(vResidential,MAX(D72,F72),MAX(D72,F72))*IF(vLoan_Regulated=\"\",0,1)","v":0},{"$f":"'Serviceability Calculator'!$D360*12","v":0},{"$f":"IF('Serviceability Calculator'!$E360=\"N/A\",0,'Serviceability Calculator'!E360)","v":0},{"$f":"IF(E72=0,0,-PMT(vFloorRate/12,vLoanTerm*12,E72)*12)","v":0},null,{"$f":"vLoan_Regulated","v":0},null,null,"Assessed using Floor Rate entered"]
[null,"Commitment 2",0,{"$f":"'Serviceability Calculator'!$D361*12","v":0},{"$f":"IF('Serviceability Calculator'!$E361=\"N/A\",0,'Serviceability Calculator'!E361)","v":0},0]
[null,"Commitment 3",0,{"$f":"'Serviceability Calculator'!$D362*12","v":0},{"$f":"IF('Serviceability Calculator'!$E362=\"N/A\",0,'Serviceability Calculator'!E362)","v":0},0]
[null,"Commitment 4",0,{"$f":"'Serviceability Calculator'!$D363*12","v":0},{"$f":"IF('Serviceability Calculator'!$E363=\"N/A\",0,'Serviceability Calculator'!E363)","v":0},0]
[null,"Commitment 5",0,{"$f":"'Serviceability Calculator'!$D364*12","v":0},{"$f":"IF('Serviceability Calculator'!$E364=\"N/A\",0,'Serviceability Calculator'!E364)","v":0},0]
[null,"Commitment 6",0,{"$f":"'Serviceability Calculator'!$D365*12","v":0},{"$f":"IF('Serviceability Calculator'!$E365=\"N/A\",0,'Serviceability Calculator'!E365)","v":0},0]
[null,"Commitment 7",0,{"$f":"'Serviceability Calculator'!$D366*12","v":0},{"$f":"IF('Serviceability Calculator'!$E366=\"N/A\",0,'Serviceability Calculator'!E366)","v":0},0]
[null,"Commitment 8",0,{"$f":"'Serviceability Calculator'!$D367*12","v":0},{"$f":"IF('Serviceability Calculator'!$E367=\"N/A\",0,'Serviceability Calculator'!E367)","v":0},0]
[null,"Commitment 9",0,{"$f":"'Serviceability Calculator'!$D368*12","v":0},{"$f":"IF('Serviceability Calculator'!$E368=\"N/A\",0,'Serviceability Calculator'!E368)","v":0},0]
[null,"Commitment 10",0,{"$f":"'Serviceability Calculator'!$D369*12","v":0},{"$f":"IF('Serviceability Calculator'!$E369=\"N/A\",0,'Serviceability Calculator'!E369)","v":0},0]
[null,"Total Repayments",{"$f":"SUM(C72:C81)","v":0},{"$f":"SUM(D72:D81)","v":0},{"$f":"SUM(E72:E81)","v":0},{"$f":"SUM(F72:F81)","v":0}]
[null,"Credit Cards",{"$f":"D83","v":0},{"$f":"'Serviceability Calculator'!$C371*vCCRate*12","v":0},{"$f":"'Serviceability Calculator'!C371","v":0},{"$f":"D83","v":0},null,null,null,null,"Credit Card Limits x Credit Card Rate entered"]
[null,"Total Commitments",{"$f":"SUM(C82:C83)","v":0},{"$f":"SUM(D82:D83)","v":0},{"$f":"SUM(E82:E83)","v":0},{"$f":"SUM(F82:F83)","v":0}]
[null,"Living Expenses",{"$f":"IF(OR(D85>F85),D85,F85)","v":0},{"$f":"'Serviceability Calculator'!$C373*12","v":0},null,{"$f":"vHEM_Amount*12","v":0},null,null,null,null,"Higher of Actual or HEM"]
[null,"Loan Applied For",{"$f":"F86","v":0},{"$f":"'Serviceability Calculator'!C393","v":0},{"$f":"vLoan_Amount","v":0},{"$f":"'Serviceability Calculator'!E393","v":0}]
[null,"Total Limits",{"$f":"E87","v":0},null,{"$f":"SUM(E84:E86)","v":0}]

{"sheet":"HEM Calculator","index":7,"n_rows":11,"n_cols":24,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,1,2,1],[1,2,1,6],[1,12,1,21]]}
[]
[null,"Applicant","Entries",null,null,null,null,null,null,null,null,null,"HEM"]
[null,null,"Postcode","Applying As","Coupled With","Dependents","Gross+NonTax Inc","Poscode Chek","State - Location","Region Check","HEM CoupleID","Couple Income","Region","Household","Dependents","Gr + NonTax Inc","HEM Row","HEM Col","Each Dep > 3","Benchmark","Minimum","HEM Weekly"]
[null,1,{"$f":"OFFSET(vApplicant_Postcode,($B4-1)*ROWS(vForm_Applicant),0)","v":0},{"$f":"T(OFFSET(vApplicant_Marital,($B4-1)*ROWS(vForm_Applicant),0))","v":""},{"$f":"OFFSET(vApplicant_Joint,($B4-1)*ROWS(vForm_Applicant),0)","v":0},{"$f":"IF($C4=0,\"\",OFFSET(vApplicant_Dependents,($B4-1)*ROWS(vForm_Applicant),0))","v":""},{"$f":"IF($C4=0,\"\",OFFSET(vApplicants_TotalGrossIncome,0,$B4)+OFFSET(vApplicants_NonTaxableIncome,0,$B4))","v":""},{"$f":"IF($C4=0,\"\",IF(OR($C4<MIN(OFFSET(tPostcodes,0,0,,1)),$C4>MAX(OFFSET(tPostcodes,0,0,,1))),-1,MATCH($C4,OFFSET(tPostcodes,0,0,,1))))","v":""},{"$f":"IF($C4=0,\"\",IF($H4=-1,\"Enter a valid Postcode\",INDEX(tPostcodes,$H4,3)&\" - \"&INDEX(tPostcodes,$H4,4)))","v":""},{"$f":"IF($C4=0,\"\",IF($H4=-1,-1,MATCH($I4,OFFSET(tRegion_HEM,0,2,ROWS(tRegion_HEM),1),0)))","v":""},0,{"$f":"IF($D4=\"Couple\",(MATCH($K4,K:K,0)=ROW($K4))*1,0)","v":0},{"$f":"IF(OR($C4=0,$H4=-1,ISERROR($H4)),\"\",OFFSET(tRegion_HEM,J4-1,3,1,1))","v":""},{"$f":"IF($D4=\"\",\"\",VLOOKUP(D4,tHousehold_HEM,2,FALSE))","v":""},{"$f":"IF($C4=0,\"\",IF(F4<3,F4,\"3 and above\"))","v":""},{"$f":"IF($C4=\"\",\"\",IF(K4=0,G4,SUMIF(K$4:K$9,K4,G$4:G$9)*L4))","v":""},null,null,{"$f":"IF(OR(F4<=3,R4=\"\",R4=0,Q4=\"\",Q4=0),IF($C4=0,\"\",0),ROUND(OFFSET(HEM!$A$1,Q4,R4-1),0))","v":""},{"$f":"IF(OR(R4=\"\",R4=0,Q4=\"\",Q4=0),0,OFFSET(HEM!$A$1,Q4-1,R4-1)+(F4-3)*S4)","v":0},{"$f":"IF(OR($P4=0,$R4=\"\",$R4=0,$Q4=\"\",$Q4=0),0,_xlfn.MINIFS(OFFSET(HEM!$1:$1,$Q4-1,0),OFFSET(HEM!$1:$1,$Q4-1,0),\">10\"))","v":0},{"$f":"MAX(T4:U4)","v":0},null,"`"]
[null,2,0,"",0,"","",{"$f":"IF($C5=0,\"\",IF(OR($C5<MIN(OFFSET(tPostcodes,0,0,,1)),$C5>MAX(OFFSET(tPostcodes,0,0,,1))),-1,MATCH($C5,OFFSET(tPostcodes,0,0,,1))))","v":""},{"$f":"IF($C5=0,\"\",IF($H5=-1,\"Enter a valid Postcode\",INDEX(tPostcodes,$H5,3)&\" - \"&INDEX(tPostcodes,$H5,4)))","v":""},"",0,{"$f":"IF($D5=\"Couple\",(MATCH($K5,K:K,0)=ROW($K5))*1,0)","v":0},"","",{"$f":"IF($C5=0,\"\",IF(F5<3,F5,\"3 and above\"))","v":""},"",null,null,{"$f":"IF(OR(F5<=3,R5=\"\",R5=0,Q5=\"\",Q5=0),IF($C5=0,\"\",0),ROUND(OFFSET(HEM!$A$1,Q5,R5-1),0))","v":""},{"$f":"IF(OR(R5=\"\",R5=0,Q5=\"\",Q5=0),0,OFFSET(HEM!$A$1,Q5-1,R5-1)+(F5-3)*S5)","v":0},{"$f":"IF(OR($P5=0,$R5=\"\",$R5=0,$Q5=\"\",$Q5=0),0,_xlfn.MINIFS(OFFSET(HEM!$1:$1,$Q5-1,0),OFFSET(HEM!$1:$1,$Q5-1,0),\">10\"))","v":0},{"$f":"MAX(T5:U5)","v":0}]
[null,3,0,"",0,"","","",{"$f":"IF($C6=0,\"\",IF($H6=-1,\"Enter a valid Postcode\",INDEX(tPostcodes,$H6,3)&\" - \"&INDEX(tPostcodes,$H6,4)))","v":""},"",0,0,"","","","",null,null,{"$f":"IF(OR(F6<=3,R6=\"\",R6=0,Q6=\"\",Q6=0),IF($C6=0,\"\",0),ROUND(OFFSET(HEM!$A$1,Q6,R6-1),0))","v":""},{"$f":"IF(OR(R6=\"\",R6=0,Q6=\"\",Q6=0),0,OFFSET(HEM!$A$1,Q6-1,R6-1)+(F6-3)*S6)","v":0},{"$f":"IF(OR($P6=0,$R6=\"\",$R6=0,$Q6=\"\",$Q6=0),0,_xlfn.MINIFS(OFFSET(HEM!$1:$1,$Q6-1,0),OFFSET(HEM!$1:$1,$Q6-1,0),\">10\"))","v":0},0]
[null,4,0,"",0,"","","",{"$f":"IF($C7=0,\"\",IF($H7=-1,\"Enter a valid Postcode\",INDEX(tPostcodes,$H7,3)&\" - \"&INDEX(tPostcodes,$H7,4)))","v":""},"",0,0,"","","","",null,null,{"$f":"IF(OR(F7<=3,R7=\"\",R7=0,Q7=\"\",Q7=0),IF($C7=0,\"\",0),ROUND(OFFSET(HEM!$A$1,Q7,R7-1),0))","v":""},{"$f":"IF(OR(R7=\"\",R7=0,Q7=\"\",Q7=0),0,OFFSET(HEM!$A$1,Q7-1,R7-1)+(F7-3)*S7)","v":0},{"$f":"IF(OR($P7=0,$R7=\"\",$R7=0,$Q7=\"\",$Q7=0),0,_xlfn.MINIFS(OFFSET(HEM!$1:$1,$Q7-1,0),OFFSET(HEM!$1:$1,$Q7-1,0),\">10\"))","v":0},0]
[null,5,0,"",0,"","","",{"$f":"IF($C8=0,\"\",IF($H8=-1,\"Enter a valid Postcode\",INDEX(tPostcodes,$H8,3)&\" - \"&INDEX(tPostcodes,$H8,4)))","v":""},"",0,0,"","","","",null,null,{"$f":"IF(OR(F8<=3,R8=\"\",R8=0,Q8=\"\",Q8=0),IF($C8=0,\"\",0),ROUND(OFFSET(HEM!$A$1,Q8,R8-1),0))","v":""},{"$f":"IF(OR(R8=\"\",R8=0,Q8=\"\",Q8=0),0,OFFSET(HEM!$A$1,Q8-1,R8-1)+(F8-3)*S8)","v":0},{"$f":"IF(OR($P8=0,$R8=\"\",$R8=0,$Q8=\"\",$Q8=0),0,_xlfn.MINIFS(OFFSET(HEM!$1:$1,$Q8-1,0),OFFSET(HEM!$1:$1,$Q8-1,0),\">10\"))","v":0},0]
[null,6,0,"",0,"","","",{"$f":"IF($C9=0,\"\",IF($H9=-1,\"Enter a valid Postcode\",INDEX(tPostcodes,$H9,3)&\" - \"&INDEX(tPostcodes,$H9,4)))","v":""},"",0,0,"","","","",null,null,{"$f":"IF(OR(F9<=3,R9=\"\",R9=0,Q9=\"\",Q9=0),IF($C9=0,\"\",0),ROUND(OFFSET(HEM!$A$1,Q9,R9-1),0))","v":""},{"$f":"IF(OR(R9=\"\",R9=0,Q9=\"\",Q9=0),0,OFFSET(HEM!$A$1,Q9-1,R9-1)+(F9-3)*S9)","v":0},{"$f":"IF(OR($P9=0,$R9=\"\",$R9=0,$Q9=\"\",$Q9=0),0,_xlfn.MINIFS(OFFSET(HEM!$1:$1,$Q9-1,0),OFFSET(HEM!$1:$1,$Q9-1,0),\">10\"))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HEM_col(P10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HEM_col(P11)","v":""}]

{"sheet":"Drivers","index":8,"n_rows":102,"n_cols":60,"rows_kept":102,"cut":false,"hidden":true,"merged":[[0,52,0,59],[0,43,0,50],[11,1,11,2],[7,1,7,2],[0,34,0,41],[1,7,1,8],[1,4,1,5],[1,1,1,2],[1,23,1,28]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Printed Form Rows Hidden",null,null,null,null,null,null,null,null,"Printed Form Sections",null,null,null,null,null,null,null,null,"Printed Form Rows Print"]
[null,"Defaults",null,null,"Application",null,null,"Assessment",null,null,"Repayments",null,"I/O Period",null,"State","Location","State - Location","HEM Region",null,"Marital","HEM Houshold",null,null,"Joint with Applicant",null,null,null,null,null,null,"Commitments",null,"Frequency",null,"Row","Applicant 1","Applicant 2","Applicant 3","Applicant 4","Applicant 5","Applicant 6","Company",null,"Section","1","2","3","4","5","6","Company",null,"Row","1","2","3","4","5","6","Company"]
[null,null,null,null,null,null,null,null,null,null,"Principal and Interest",null,0,null,"NSW","Inner City","NSW - Inner City","Sydney",null,"Sole Borrower","Couple",null,"Applicant",1,2,3,4,5,6,null,"Other Mortgage",null,"Annually",null,1,null,null,null,null,null,null,null,null,0,{"$f":"AND(AS$2*1<=vApplicants,OR(COUNTIF(AS$4:AS$6,TRUE)>0,AS$7*1>0))","v":false},false,false,false,false,false,{"$f":"AND(vCompany,OR(COUNTIF(AY$4,TRUE)>0,AY$5*1>0))","v":false},null,1,{"$f":"IF(AS$3,1,0)","v":0},{"$f":"IF(AT$3,1,0)","v":0},0,0,0,0,{"$f":"IF(AY$3,1,0)","v":0}]
[null,"Applicants Max",6,null,"LVR",{"$f":"IF(OR(vLoan_Amount=0,vLoan_Security=0),0,ROUND(vLoan_Amount/vLoan_Security,4))","v":0},null,"Total Income",{"$f":"Calculations!C19+Calculations!C35+Calculations!C36+Calculations!C53+Calculations!C68","v":0},null,"Interest Only",null,1,null,"NSW","Metro","NSW - Metro","Sydney",null,"Single","Single",null,"Couple",{"$f":"(OFFSET(vApplicant_Marital,(X$3-1)*vApplicant_Rows,0)=\"\")","v":true},true,true,true,true,true,null,"Rental Expense",null,"Monthly",null,2,null,null,null,null,null,null,null,null,1,{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$28:$C$30,(AS$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$28:$C$30,(AT$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$28:$C$30,(AU$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$28:$C$30,(AV$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$28:$C$30,(AW$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$28:$C$30,(AX$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS('Serviceability Calculator'!$C$330:$C$336))>0","v":false},null,2,{"$f":"IF(AS$3,1,0)","v":0},0,0,0,0,0,0]
[null,"Open","˅",null,"LVR Amount",{"$f":"IF(vLoan_Security=0,100000000,vLoan_Security)","v":100000000},null,null,null,null,null,null,2,null,"NSW","Non Metro","NSW - Non Metro","Balance of NSW",null,"Couple","Couple",null,"Couple",{"$f":"(OFFSET(vApplicant_Marital,(X$3-1)*vApplicant_Rows,0)=\"Couple\")","v":false},false,false,false,false,false,null,"Personal Loan",null,"Weekly",null,3,null,null,null,null,null,null,null,null,2,{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$34:$C$40,(AS$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$34:$C$40,(AT$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$34:$C$40,(AU$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$34:$C$40,(AV$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$34:$C$40,(AW$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$34:$C$40,(AX$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"vCompany_Properties","v":0},null,3,{"$f":"IF(AS$3,1,0)","v":0},0,0,0,0,0,0]
[null,"Close","˄",null,"LVR Security",{"$f":"IF(vLoan_Amount=0,100000000,vLoan_Amount)","v":100000000},null,"Net Income",{"$f":"'Serviceability Calculator'!E$385","v":0},null,null,null,3,null,"VIC","Inner City","VIC - Inner City","Melbourne",null,null,null,null,"Row",{"$f":"IF(X4,12,IF(X$5,7,6))","v":12},{"$f":"IF(Y4,12,IF(Y$5,7,6))","v":12},12,12,12,12,null,"Hire Purchase / Lease",null,"Fortnighly",null,4,null,null,null,null,null,null,null,null,3,{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$44:$C$50,(AS$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$44:$C$50,(AT$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$44:$C$50,(AU$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$44:$C$50,(AV$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$44:$C$50,(AW$2-1)*vApplicant_Rows,0)))>0","v":false},{"$f":"SUM(ABS(OFFSET('Serviceability Calculator'!$C$44:$C$50,(AX$2-1)*vApplicant_Rows,0)))>0","v":false},null,null,4,0,0,0,0,0,0,0]
[null,null,null,null,"LVR Passed",{"$f":"(vLVR<=100%)","v":true},null,null,null,null,null,null,4,null,"VIC","Metro","VIC - Metro","Melbourne",null,null,null,null,"Rows",{"$f":"IF(X$5,IF(vLoan_Applicants=0,1,vLoan_Applicants-1),1)","v":1},1,1,1,1,1,null,"HECS / Education",null,null,null,5,null,null,null,null,null,null,null,null,4,{"$f":"SUM(OFFSET(vApplicant_Properties,(AS$2-1)*vApplicant_Rows,0))","v":0},0,0,0,0,0,null,null,5,0,0,0,0,0,0,0]
[null,"Defaults",null,null,null,null,null,"Living Costs",{"$f":"'Serviceability Calculator'!E$389","v":0},null,null,null,5,null,"VIC","Non Metro","VIC - Non Metro","Balance of VIC",null,null,null,null,"List Range",{"$f":"\"Drivers!\"&CELL(\"address\",OFFSET(tApplicant_Joint,X6,X3-1,1,1))&\":\"&CELL(\"address\",OFFSET(tApplicant_Joint,X6+X7-1,X3-1,1,1))","v":"Drivers!$X$15:$X$15"},{"$f":"\"Drivers!\"&CELL(\"address\",OFFSET(tApplicant_Joint,Y6,Y3-1,1,1))&\":\"&CELL(\"address\",OFFSET(tApplicant_Joint,Y6+Y7-1,Y3-1,1,1))","v":"Drivers!$Y$15:$Y$15"},{"$f":"\"Drivers!\"&CELL(\"address\",OFFSET(tApplicant_Joint,Z6,Z3-1,1,1))&\":\"&CELL(\"address\",OFFSET(tApplicant_Joint,Z6+Z7-1,Z3-1,1,1))","v":"Drivers!$Z$15:$Z$15"},{"$f":"\"Drivers!\"&CELL(\"address\",OFFSET(tApplicant_Joint,AA6,AA3-1,1,1))&\":\"&CELL(\"address\",OFFSET(tApplicant_Joint,AA6+AA7-1,AA3-1,1,1))","v":"Drivers!$AA$15:$AA$15"},{"$f":"\"Drivers!\"&CELL(\"address\",OFFSET(tApplicant_Joint,AB6,AB3-1,1,1))&\":\"&CELL(\"address\",OFFSET(tApplicant_Joint,AB6+AB7-1,AB3-1,1,1))","v":"Drivers!$AB$15:$AB$15"},{"$f":"\"Drivers!\"&CELL(\"address\",OFFSET(tApplicant_Joint,AC6,AC3-1,1,1))&\":\"&CELL(\"address\",OFFSET(tApplicant_Joint,AC6+AC7-1,AC3-1,1,1))","v":"Drivers!$AC$15:$AC$15"},null,"Child Maintenance",null,null,null,6,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,6,0,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$4),1,0)","v":0}]
[null,"OpenClose Form",7,null,"I/O",{"$f":"vLoan_Type=OFFSET(tRepayments,1,0,1,1)","v":false},null,null,null,null,null,null,null,null,"QLD","Inner City","QLD - Inner City","Brisbane",null,null,null,null,null,0,0,0,0,0,0,null,"Other Commitment",null,null,null,7,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,7,0,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$4),1,0)","v":0}]
[null,"OpenClose Open",false,null,null,null,null,"Commitments",{"$f":"'Serviceability Calculator'!E$387","v":0},null,null,null,null,null,"QLD","Metro","QLD - Metro","Brisbane",null,null,null,null,null,2,1,1,1,1,1,null,null,null,null,null,8,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,8,0,0,0,0,0,0,0]
[null,null,null,null,"Applicants",{"$f":"IF(vLoan_Applicants<1,0,vLoan_Applicants)","v":0},null,null,null,null,null,null,null,null,"QLD","Non Metro","QLD - Non Metro","Balance of QLD",null,null,null,null,null,3,3,2,2,2,2,null,null,null,null,null,9,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,9,0,0,0,0,0,0,0]
[null,"HEM",null,null,"Applicant Rows",{"$f":"ROWS(vForm_Applicant)","v":51},null,"Debt Assessed",{"$f":"'Serviceability Calculator'!E$387+'Serviceability Calculator'!E$389","v":0},null,null,null,null,null,"SA","Inner City","SA - Inner City","Adelaide",null,null,null,null,null,4,4,4,3,3,3,null,null,null,null,null,10,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,10,{"$f":"IF(AND(AS$3,AS$4),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$4),1,0)","v":0},0,0,0,0,0]
[null,null,null,null,"Applicant Joints",{"$f":"IF(vApplicants-1<=0,1,vApplicants-1)","v":1},null,null,null,null,null,null,null,null,"SA","Metro","SA - Metro","Adelaide",null,null,null,null,null,5,5,5,5,4,4,null,null,null,null,null,11,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,11,{"$f":"IF(AND(AS$3,AS$4),1,0)","v":0},0,0,0,0,0,0]
[null,"Income Max",{"$f":"MAX(HEM!$2:$2)","v":409000},null,null,null,null,"Debt Serviced",{"$f":"'Serviceability Calculator'!E$387+'Serviceability Calculator'!E$393","v":0},null,null,null,null,null,"SA","Non Metro","SA - Non Metro","Balance of SA",null,null,null,null,null,6,6,6,6,6,5,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0,0,0,0,0,0,0]
[null,"CoupleID",{"$f":"MATCH(\"HEM \"&B15,OFFSET(tApplicant_HEM,-1,0,1),0)","v":10},null,"Company",{"$f":"(vLoan_Company=\"Yes\")","v":false},null,null,null,null,null,null,null,null,"WA","Inner City","WA - Inner City","Perth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0,0,0,0,0,0,0]
[null,"Row",{"$f":"MATCH(\"HEM \"&B16,OFFSET(tApplicant_HEM,-1,0,1),0)","v":16},null,null,null,null,"Repayments",{"$f":"IF(vLoan_Term=0,0,-PMT((vLoan_Rate+vBuffer)/12,(vLoan_Term-IF(bIO,vLoan_IOPeriod*12,0)),vLoan_Amount)*12)","v":0},null,null,null,null,null,"WA","Metro","WA - Metro","Perth",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"IF(AS$3,1,0)","v":0},{"$f":"IF(AT$3,1,0)","v":0},{"$f":"IF(AU$3,1,0)","v":0},{"$f":"IF(AV$3,1,0)","v":0},{"$f":"IF(AW$3,1,0)","v":0},{"$f":"IF(AX$3,1,0)","v":0},{"$f":"IF(AY$3,1,0)","v":0}]
[null,"Col",{"$f":"MATCH(\"HEM \"&B17,OFFSET(tApplicant_HEM,-1,0,1),0)","v":17},null,"Regulated",{"$f":"(vLoan_Regulated<>\"No\")","v":true},null,null,null,null,null,null,null,null,"WA","Non Metro","WA - Non Metro","Balance of WA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,0,0,0,0]
[null,null,null,null,"Refinance",{"$f":"(vLoan_Purpose=\"Refinance\")","v":false},null,"Avaliable Income",{"$f":"'Serviceability Calculator'!E$391","v":0},null,null,null,null,null,"TAS","Inner City","TAS - Inner City","Hobart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF(AND(AS$3,AS$5),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$5),1,0)","v":0},0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=1),1,0)","v":0}]
[null,null,null,null,"Residential",{"$f":"vRegulated","v":true},null,null,null,null,null,null,null,null,"TAS","Metro","TAS - Metro","Hobart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(AND(AS$3,AS$5),1,0)","v":0},0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=1),1,0)","v":0}]
[null,null,null,null,"Buffer",{"$f":"IF(vResidential,IF(vRefinance,vBuffer_Refinance_Residential,vBuffer_Residential),IF(vRefinance,vBuffer_Refinance_Commercial,vBuffer_Commercial))","v":0.02},null,"NDI Ratio",{"$f":"ROUND(IF(vAssessed_Commitments+vAssessed_Repayments=0,1,(vAssessed_Net_Income-vAssessed_LivingCosts)/(vAssessed_Commitments+vAssessed_Repayments)),2)","v":1},null,null,null,null,null,"TAS","Non Metro","TAS - Non Metro","Balance of TAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0,0,0,0,0,0,0]
[null,null,null,null,"Floor Rate",{"$f":"IF(vResidential,vFloorRate_Residential,vFloorRate_Commercial)","v":0.06},null,null,null,null,null,null,null,null,"ACT","Metro","ACT - Metro","ACT & NT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0,0,0,0,0,0,0]
[null,null,null,null,"Interest Gearing",{"$f":"IF(vResidential,vGearing_Residential,vGearing_Commercial)","v":3.7499999999999999E-2},null,"NDI Factor",{"$f":"TEXT(vAssessed_NDI_Ratio,\"0.00\")&\" : 1\"","v":"1.00 : 1"},null,null,null,null,null,"ACT","Non Metro","ACT - Non Metro","ACT & NT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0,0,0,0,0,0,0]
[null,null,null,null,"Credit Card",{"$f":"IF(vResidential,vCCRate_Residential,vCCRate_Commercial)","v":3.7999999999999999E-2},null,null,null,null,null,null,null,null,"NT","Metro","NT - Metro","ACT & NT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=2),1,0)","v":0}]
[null,null,null,null,"Loan Term",{"$f":"IF(vResidential,vLoanTerm_Residential,vLoanTerm_Commercial)","v":30},null,"DSC Factor",{"$f":"TEXT(IF(OR(vAssessed_Net_Income=0,vServiced_Debt=0),1.25,vAssessed_Net_Income/vServiced_Debt),\"0.00\")&\" : 1\"","v":"1.25 : 1"},null,null,null,null,null,"NT","Non Metro","NT - Non Metro","ACT & NT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=3),1,0)","v":0}]
[null,null,null,null,"Rental Shading",{"$f":"IF(vResidential,vRentalShading_Residential,vRentalShading_Commercial)","v":0.8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=4),1,0)","v":0}]
[null,null,null,null,"Prperty Expense",{"$f":"IF(vResidential,vPropertyExpense_Residential,vPropertyExpense_Commercial)","v":0},null,"Factor",{"$f":"IF(vAssessed_NDI_Ratio<1,3,IF(vAssessed_Available_Income<vAssessed_Repayments,2,1))","v":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,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF(AS$3,1,0)","v":0},{"$f":"IF(AT$3,1,0)","v":0},{"$f":"IF(AU$3,1,0)","v":0},{"$f":"IF(AV$3,1,0)","v":0},{"$f":"IF(AW$3,1,0)","v":0},{"$f":"IF(AX$3,1,0)","v":0},{"$f":"IF(AND(AY$3,AY$5*1>=5),1,0)","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,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=6),1,0)","v":0}]
[null,null,null,null,"Repayments",{"$f":"IF(vLoan_Term=0,0,IF(bIO,vLoan_Amount*vLoan_Rate,-PMT(vLoan_Rate/12,vLoan_Term,vLoan_Amount)*12))","v":0},null,"Debt Actual",{"$f":"'Serviceability Calculator'!C$387+'Serviceability Calculator'!C$389","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,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,{"$f":"IF(AND(AS$3,AS$6),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$6),1,0)","v":0},0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=7),1,0)","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,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,{"$f":"IF(AND(AS$3,AS$6),1,0)","v":0},0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=8),1,0)","v":0}]
[null,null,null,null,null,null,null,"Commitment Limit",{"$f":"Calculations!C87","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,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,0,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=9),1,0)","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,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,0,0,0,0,0,0,{"$f":"IF(AND(AY$3,AY$5*1>=10),1,0)","v":0}]
[null,null,null,null,null,null,null,"DTI Factor",{"$f":"TEXT(IF(OR(vAssessed_Commitment_Limit=0,vAssessed_Income=0),1,vAssessed_Commitment_Limit/vAssessed_Income),\"0.0\")","v":"1.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,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,0,0,0,0,0,{"$f":"IF(AY$3,1,0)","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,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0,0,0,0,0,0,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,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,0,0,0,0,0,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,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,0,0,0,0,0,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,34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,{"$f":"IF(AS$3,1,0)","v":0},{"$f":"IF(AT$3,1,0)","v":0},{"$f":"IF(AU$3,1,0)","v":0},{"$f":"IF(AV$3,1,0)","v":0},{"$f":"IF(AW$3,1,0)","v":0},{"$f":"IF(AX$3,1,0)","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,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,0,0,0,0,0,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,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,{"$f":"IF(AND(AS$3,AS$7*1>=1),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=1),1,0)","v":0},0,{"$f":"IF(AND(AV$3,AV$7*1>=1),1,0)","v":0},0,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,37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,{"$f":"IF(AND(AS$3,AS$7*1>=1),1,0)","v":0},0,0,0,0,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,38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,0,0,0,0,0,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,39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0,0,0,0,0,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,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0,0,0,0,0,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,41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,{"$f":"IF(AND(AS$3,AS$7*1>=2),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=2),1,0)","v":0},0,0,0,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,42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,{"$f":"IF(AND(AS$3,AS$7*1>=3),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=3),1,0)","v":0},0,0,0,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,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,{"$f":"IF(AND(AS$3,AS$7*1>=4),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=4),1,0)","v":0},0,0,0,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,44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,{"$f":"IF(AND(AS$3,AS$7*1>=5),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=5),1,0)","v":0},0,0,0,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,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,{"$f":"IF(AND(AS$3,AS$7*1>=6),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=6),1,0)","v":0},0,0,0,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,46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,{"$f":"IF(AND(AS$3,AS$7*1>=7),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=7),1,0)","v":0},0,0,0,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,47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,{"$f":"IF(AND(AS$3,AS$7*1>=8),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=8),1,0)","v":0},0,0,0,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,48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,{"$f":"IF(AND(AS$3,AS$7*1>=9),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=9),1,0)","v":0},0,0,0,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,49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,{"$f":"IF(AND(AS$3,AS$7*1>=10),1,0)","v":0},{"$f":"IF(AND(AT$3,AT$7*1>=10),1,0)","v":0},0,0,0,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,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"IF(AS$3,1,0)","v":0},{"$f":"IF(AT$3,1,0)","v":0},0,0,0,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,51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,{"$f":"IF(AS$3,1,0)","v":0},0,0,0,0,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,52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,61,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]