{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Serviceability","HEM","Tables","Serviceability Calc","Tax Calc","User Problems","Version Control","Day and Months Table"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":7,"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","index":0,"n_rows":91,"n_cols":13,"rows_kept":91,"cut":false,"hidden":false,"merged":[[17,6,17,8],[73,8,74,10],[73,11,74,11],[58,6,58,7],[59,6,59,7],[60,6,60,7],[61,6,61,7],[58,8,58,9],[59,8,59,9],[60,8,60,9],[61,8,61,9],[85,3,86,11],[73,3,74,7],[40,7,40,12],[42,7,42,12],[30,3,30,11],[79,11,81,11],[57,8,57,9],[57,6,57,7],[64,6,64,7],[82,7,82,8]]}
[]
[]
[null,null,"Serviceability Calculator (Residential)"]
[null,null,null,"RedZed Lending Solutions Pty Ltd (ACL 311128)"]
[]
[null,null,null,"Information can be entered in the clear boxes, the grey boxes contain RedZed calculations."]
[]
[null,null,null,"Application name - mandatory"]
[]
[null,null,null,"Income Table",null,null,"Gross Annual",null,null,null,null,"Net Monthly"]
[]
[null,null,null,"Personal Income",null,"Select Household"]
[null,null,null,"Applicant / Guarantor 1","PAYG/Self Employed - Alt Doc Declaration/Self Employed - Full Doc",null,null," ",null,null,null,{"$f":"'Tax Calc'!I5","v":0}]
[null,null,null,"Applicant / Guarantor 2","PAYG/Self Employed - Alt Doc Declaration/Self Employed - Full Doc",null,null,null,null,null,null,{"$f":"'Tax Calc'!I6","v":0}]
[null,null,null,"Applicant / Guarantor 3","PAYG/Self Employed - Alt Doc Declaration/Self Employed - Full Doc",null,null,null,null,null,null,{"$f":"'Tax Calc'!I7","v":0}]
[null,null,null,"Applicant / Guarantor 4","PAYG/Self Employed - Alt Doc Declaration/Self Employed - Full Doc",null,null,null,null,null,null,{"$f":"'Tax Calc'!I8","v":0}]
[]
[null,null,null,null,null,"Select Household","Enter Source of Income"]
[null,null,null,"Applicant / Guarantor 1","Other Regular Monthly Income (eg - Centrelink payments, investments)"]
[null,null,null,"Applicant / Guarantor 2","Other Regular Monthly Income (eg - Centrelink payments, investments)"]
[null,null,null,"Applicant / Guarantor 3","Other Regular Monthly Income (eg - Centrelink payments, investments)"]
[null,null,null,"Applicant / Guarantor 4","Other Regular Monthly Income (eg - Centrelink payments, investments)"]
[]
[null,null,null,"Rental Income","Existing",null,null,null,null,null,null,{"$f":"G24*0.8/12","v":0}]
[null,null,null,"Rental Income","New",null,null,null,null,null,null,{"$f":"G25*0.8/12","v":0}]
[]
[null,null,null,"Company Income (only to be used if the company is the loan applicant)"]
[null,null,null,"*If a guarantor's income is also required to help with serviceability,"]
[null,null,null,"all company and guarantor debts, and living expenses need to be included"]
[null,null,null,"Company Net Profit Before Tax - Full Doc or Alt Doc Self Certified",null,null,null,null,null,null,null,{"$f":"(G30-(G30*Table_Company_Tax_Rate))/12","v":0}]
[null,null,null,{"$f":"IF(G30 <> 0, \"Only NPBT from the borrowing Company entity can be entered in this field. Other related company NPBT needs to be allocated to the director(s)/guarantor(s)\", 0)","v":0}]
[null,null,null,"Total Monthly Net Income",null,null,null,null,null,null,null,{"$f":"SUM(L13,L14,L15,L16,L19,L20,L21,L22,L24,L25,L30)","v":0}]
[]
[]
[null,null,null,"Monthly Living Expenses"]
[]
[null,null,null,"Applicants(s) declared expenses - mandatory"]
[null,null,null,"Ongoing (combined) standard monthly living expenses declared by applicant(s)"]
[]
[null,null,null,"RedZed Living Allowance",null,"Select Household"]
[null,null,null,"Number of adults - household 1",null,null,null,{"$f":"Tables!E82","v":" "}]
[null,null,null,"Number of dependant children - household 1"]
[null,null,null,"Number of adults - household 2",null,null,null,{"$f":"Tables!E83","v":" "}]
[null,null,null,"Number of dependant children - household 2"]
[]
[null,null,null,"Total Monthly Living Expenses used in assessment",null,null,null,null,null,null,null,{"$f":"MAX(SUM(L41:L44),G38)","v":0}]
[]
[]
[null,null,null,"Available Income",null,null,null,null,null,null,null,{"$f":"Tables!B311","v":0}]
[]
[null,null,null,"Commitments",null,null,null,null,null,null,null,"Monthly"]
[]
[null,null,null,"RedZed Loan Applied For"]
[null,null,null,null,null,null,"Loan Amount","Years","Interest Only Term","Interest Rate"]
[null,null,null,null,"Loan 1",null,null,null,null,null,null,{"$f":"Tables!B317","v":0}]
[null,null,null,null,"Loan 2",null,null,null,null,null,null,{"$f":"Tables!B318","v":0}]
[null,null,null,"Note: An interest rate buffer is automatically applied by the calculator. You do not need to apply a separate buffer."]
[null,null,null,null,null,null,"Limit",null,"Financier"]
[null,null,null,"Existing Loans","Loan 1 - Existing Secured"]
[null,null,null,null,"Loan 2 - Existing Secured"]
[null,null,null,null,"Loan 3 - Existing Unsecured"]
[null,null,null,null,"Loan 4 - Existing Unsecured"]
[]
[null,null,null,null,null,null,"Total Credit Limits"]
[null,null,null,"Credit Cards",null,null,null,null,"(@3.82%)",null,null,{"$f":"G65*3.82%","v":0}]
[]
[null,null,null,"Maintenance / On Going Rent"]
[]
[null,null,null,"Other Fixed Monthly Repayments"]
[]
[null,null,null,"Total Monthly Commitments",null,null,null,null,null,null,null,{"$f":"SUM(L55:L69)","v":0}]
[]
[null,null,null,null,null,null,null,null,"Debt Servicing Ratio",null,null,"(DSR)"]
[null,null,null,"This Serviceability Calculator is intended as a guide only and no loan approval can be assumed on the basis of the results of this calculator. All applications remain subject to the normal credit and approval criteria of RedZed Lending Solutions Pty Ltd.",null,null,null,null,null,null,null,{"$f":"IFERROR('Serviceability Calc'!C19,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,"DTI  must also be met for Regulated Loans"]
[null,null,null,null,null,null,null,null,"For Company Borrowers DSR must be >1.10"]
[null,null,null,null,null,null,null,null,"For IO Inv loans > 75% DSR must be >1.10"]
[null,null,null,"Debt to Income Ratio - minimum requirements - Regulated Loans Only",null,null,null,null,null,null,null,"DTI"]
[null,null,null,"Income Type","DTI >6.0x - 7.0x","DTI >7.0x-<8.0x","DTI >8.0x",null,null,null,null,{"$f":"IFERROR((SUM(G55:G56)+SUM(G59:G62)+G65)/(SUM(G13:G16)+SUM(L19:L22)*12+SUM(G24:G25)),\"\")","v":""}]
[null,null,null,"Self Employed","                                           DSR >1.10\n                               (>=1.06 with rental income)","DSR >1.10","Contact your BDM"]
[null,null,null,"Self Employed + PAYG\n(PAYG<25% of total income)","                                           DSR >1.10\n                               (>=1.06 with rental income)","Contact your BDM","Contact your BDM"]
[null,null,null,"PAYG Only\n(or PAYG >25% of total income)","                                          Max DTI 6.5x\n                                            DSR  >1.10\n                             (DSR >=1.06 with rental income)","Contact your BDM","Contact your BDM"]
[]
[]
[null,null,null,"I, the Introducer, confirm that reasonable enquiries about the applicant(s) current and ongoing financial situation have been undertaken and are reflected in the figures entered into this calculation. The applicants(s) have been given sufficient time to consider the declared monthly living expenses amount which has been derived following due consideration."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Version Control'!I1","v":"V10.16 220616"}]

{"sheet":"HEM","index":1,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":true,"merged":[[18,3,18,4]]}
["Income Range ($)","Single Adult","Single Adult +1","Single Adult +2","Single Adult +3","Single Adult +4","Single Adult +5","Single Adult +6","Couple","Couple +1","Couple +2","Couple +3","Couple +4","Couple +5","Couple +6"]
["0 - 23,000",1130.9647922804736,1611.7175919915917,2050.2008055077345,2623.6634955772988,2973.608268818597,3634.3037253191351,4293.5862337337994,2248.7389380243421,2651.9868291604157,2944.7970084478061,3285.4778576361859,3819.3701180140611,4138.4827082735283,4457.595298532995]
["23,001 - 34,000",1204.9654499764481,1611.7175919915917,2050.2008055077345,2623.6634955772988,2973.608268818597,3634.3037253191351,4293.5862337337994,2248.7389380243421,2651.9868291604157,2944.7970084478061,3285.4778576361859,3819.3701180140611,4138.4827082735283,4457.595298532995]
["34,001 - 46,000",1264.4432284896761,1670.7438712326432,2109.4426587720418,2623.6634955772988,2973.608268818597,3634.3037253191351,4293.5862337337994,2308.4616302262525,2651.9868291604157,2944.7970084478061,3285.4778576361859,3819.3701180140611,4138.4827082735283,4457.595298532995]
["46,001 - 57,000",1350.5065669132434,1756.1536566318066,2195.1644236723591,2712.1377924992494,3059.644024637852,3634.3037253191351,4293.5862337337994,2394.879159355623,2738.0782451615191,3031.0727677273803,3285.4778576361859,3819.3701180140611,4138.4827082735283,4457.595298532995]
["57,001 - 69,000",1497.9401503130018,1902.4679370709298,2342.0131178294791,2863.7017737755414,3207.0310103179081,3634.3037253191351,4293.5862337337994,2542.9197569761932,2885.5601831804192,3178.8705015042374,3433.0856739066517,3819.3701180140611,4138.4827082735283,4457.595298532995]
["69,001 - 92,000",1730.0608231939257,2132.8261442858015,2573.2127096694153,3102.3251460148745,3439.0777635538416,3866.331998643821,4293.5862337337994,2775.995889808501,3117.7567187555301,3411.5644271607266,3665.4808026752439,4050.715981246798,4369.3960041063729,4688.0760269659468]
["92,001 - 115,000",2056.2118763305302,2456.500864692955,2898.0696537818362,3437.6131925142727,3765.1251863074085,4192.3535138016277,4619.581841295847,3103.4895486635069,3444.0143584622529,3738.5206661671614,3992.0172606326082,4375.7779120505384,4693.8500028972958,5011.9220937440541]
["115,001 - 138,000",2347.8339691520782,2745.9087539259326,3188.5344090506655,3737.4045184795673,4056.6542195951597,4483.85928220593,4911.0643448167002,3396.3118730602218,3735.7320590949935,4030.862609125466,4283.984261845847,4666.4270068325804,4983.9557902756696,5301.4845737187588]
["138,001 - 161,000",2707.8408575255512,3103.1822124126843,3547.1130482742115,4107.4973031850959,4416.5469892784113,4843.7235222166255,5270.9000551548406,3757.8009305511059,4095.8567297847053,4391.7587952243211,4644.4166933922379,5025.2320227963291,5342.0897958576352,5658.9475689189412]
["161,001 - 184,000",2838.7015221859906,3233.0491315470786,3677.4543070485302,4242.0237980769225,4547.365647193993,4974.5316784459937,5401.6977096979936,3889.2001095109281,4226.7600487293876,4522.9424109523288,4775.431881700114,5155.6556837361131,5472.2695772924089,5788.8834708487047]
["184,001 - 229,000",3053.8888140934091,3446.6027252919098,3891.7878273231836,4463.2394503079931,4762.4847650510746,5189.6337527904907,5616.7827405299076,4105.2732766146864,4442.0178222762052,4738.6607866388749,4990.8736135318959,5370.1244939204853,5686.3372982469355,6002.5501025733847]
["229,001 - 287,000",3586.1384805759535,3974.811250337716,4421.9257160778407,5010.4000600961544,5294.5654770463179,5721.6722261639088,6148.7789752814997,4639.7138119564379,4974.4415437075249,5272.2248792265036,5523.7525804643237,5900.5976184747697,6215.8185701043521,6531.0395217339355]
["287,001 - 344,000",4138.7278802516548,4523.2048381780633,4972.3223145287966,5578.4698016826924,5846.9787454187554,6274.0414617105307,6701.1041780023052,5194.5778866151277,5527.2118912971928,5826.1783685618066,6076.9950047600969,6451.342266664542,6765.5333616768958,7079.7244566892496]
["344,001 - 574,000",4208.8776772260599,4592.8220077006335,5042.1937611478297,5650.5848088191115,5917.1062322924718,6344.163371059075,6771.2205098256782,5265.0164477032367,5597.3844799730732,5896.5016923000467,6147.2277217233895,6521.2578866920712,6835.3182464392794,7149.3786061864885]
[]
[]
[]
["Income Range lookup","Row Offset Value",null,"Dependents/Household Number",null,1,2,3,4,5,6,7]
[23001,1,null,0,null,0,7,13,13,13,13,13]
[34001,2,null,1,null,1,8,13,13,13,13,13]
[46001,3,null,2,null,2,9,13,13,13,13,13]
[57001,4,null,3,null,3,10,13,13,13,13,13]
[69001,5,null,4,null,4,11,13,13,13,13,13]
[92001,6,null,5,null,5,12,13,13,13,13,13]
[115001,7,null,6,null,6,13,13,13,13,13,13]
[138001,8,null,7,null,13,13,13,13,13,13,13]
[161001,9,null,8,null,13,13,13,13,13,13,13]
[184001,10,null,9,null,13,13,13,13,13,13,13]
[229001,11,null,10,null,13,13,13,13,13,13,13]
[287001,12,null,11,null,13,13,13,13,13,13,13]
[344001,13,null,12,null,13,13,13,13,13,13,13]
[]
[]
[]
[]
[]
[]
[null,null,null,"Household 1",null,null,null,"Household 2"]
[null,null,null,"Gross Income",null,{"$f":"IF(EXACT(Serviceability!F13,D39),Serviceability!G13,0)+IF(EXACT(Serviceability!F14, D39),Serviceability!G14,0)+IF(EXACT(Serviceability!F15, D39),Serviceability!G15,0)+IF(EXACT(Serviceability!F16, D39),Serviceability!G16,0)","v":0},null,"Gross Income",null,{"$f":"IF(EXACT(Serviceability!F13, H39),Serviceability!G13,0)+IF(EXACT(Serviceability!F14,H39),Serviceability!G14,0)+IF(EXACT(Serviceability!F15,H39),Serviceability!G15,0)+IF(EXACT(Serviceability!F16,H39),Serviceability!G16,0)","v":0}]
[null,null,null,"Single/Couple",null,{"$f":"+Serviceability!$G$41","v":0},null,"Single/Couple",null,{"$f":"Serviceability!G43","v":0}]
[null,null,null,"Dependents",null,{"$f":"+Serviceability!$G$42","v":0},null,"Dependents",null,{"$f":"Serviceability!G44","v":0}]
[null,null,null,"HEM Row Offset Value",null,{"$f":"IFERROR(VLOOKUP(F40,HEM!$A$20:$B$32,2,TRUE),0)","v":0},null,"HEM Row Offset Value",null,{"$f":"IFERROR(VLOOKUP(J40,HEM!$A$20:$B$32,2,TRUE),0)","v":0}]
[null,null,null,"HEM Column Offset Value",null,{"$f":"OFFSET($E$20,F42,F41)","v":0},null,"HEM Column Offset Value",null,{"$f":"OFFSET($E$20,J42,J41)","v":0}]
[null,null,null,"HEM Starting Value",null,{"$f":"OFFSET(B2,0,0)","v":1130.9647922804736},null,"HEM Starting Value",null,{"$f":"OFFSET(F2,0,0)","v":2973.608268818597}]
[null,null,null,"HEM Min Living Expense",null,{"$f":"IF(F40=0, 0, OFFSET($B$2,F43,F44))","v":0},null,"HEM Min Living Expense",null,{"$f":"IF(J40=0,0,OFFSET($B$2,J43,J44))","v":0}]

{"sheet":"Tables","index":2,"n_rows":318,"n_cols":15,"rows_kept":318,"cut":false,"hidden":true,"merged":[[68,5,68,6],[68,1,68,2],[68,7,68,8]]}
[]
["Tax"]
[null,null,null,null,null,null,"Flood Levy"]
["Wages Over","Not to Exceed","Tax Rate",null,null,null,"Taxable income","Flood levy on this income"]
[0,18200,0,null,null,null,"$0 to $50,000","Nil",0,50000,0]
[{"$f":"B5+1","v":18201},45000,0.19,{"$f":"D5+C5*(B5-A5)","v":0},null,null,"$50,001 to $100,000","Half a cent for each $1 over $50,000",50001,100000,0,{"$f":"(J6-J5)*K6","v":0}]
[{"$f":"B6+1","v":45001},120000,0.32500000000000001,{"$f":"ROUNDUP(D6+C6*(B6-A6),0)","v":5092},null,null,"Over $100,000","$250 plus 1c for each $1 over $100,000",{"$f":"J6+1","v":100001},null,0]
[{"$f":"B7+1","v":120001},180000,0.37,{"$f":"ROUNDUP(D7+C7*(B7-A7),0)","v":29467}]
[{"$f":"B8+1","v":180001},null,0.45,{"$f":"ROUNDUP(D8+C8*(B8-A8),0)","v":51667}]
[null,null,null,null,null,null,"                        "]
[null,null,null,null,null,null,"   "]
["Medicare Levy"]
[null,null,null,null,null,null,"Taxable income","Tax on this income"]
[0,16284,0,null,"not currently used",null,"0 - $18,200","Nil"]
[16284,17604,0.2,null,null,null,"$18,201 - $37,000","19c for each $1 over $18,200"]
["17604+",null,0.02,null,null,null,"$37,001 - $90,000","$3,572 plus 32.5c for each $1 over $37,000"]
[null,null,null,null,null,null,"$90,001 - $180,000","$17,547 plus 37c for each $1 over $87,000"]
[null,null,null,null,null,null,"$180,001 and over","$54,547 plus 45c for each $1 over $180,000"]
[]
["Company Tax"]
[]
["Rate",0.27500000000000002]
[]
[]
[]
[]
[]
["APR Buffer",2.5000000000000001E-2]
["Minimum Rate",7.0000000000000007E-2]
[]
["RedZed Loan Applied For: Repayment With Buffer",null,"Buffered %","Minimum %","Rate %","Buffer %","Buffered %","Total Term","Interest Only Term","Net Term","Amount"]
["Buffered Loan 1",{"$f":"IF(Serviceability!H55=0,0,-PMT((D32)/12,J32*12,Serviceability!G55))","v":0},{"$f":"G32","v":2.5000000000000001E-2},{"$f":"IF(C32>=$B$29,C32,$B$29)","v":7.0000000000000007E-2},{"$f":"Serviceability!J55","v":0},{"$f":"$B$28","v":2.5000000000000001E-2},{"$f":"E32+F32","v":2.5000000000000001E-2},{"$f":"Serviceability!H55","v":0},{"$f":"Serviceability!I55","v":0},{"$f":"H32-I32","v":0},{"$f":"Serviceability!G55","v":0}]
["Buffered Loan 2",{"$f":"IF(Serviceability!H56=0,0,-PMT((D33)/12,J33*12,Serviceability!G56))","v":0},{"$f":"G33","v":2.5000000000000001E-2},{"$f":"IF(C33>=$B$29,C33,$B$29)","v":7.0000000000000007E-2},{"$f":"Serviceability!J56","v":0},{"$f":"$B$28","v":2.5000000000000001E-2},{"$f":"E33+F33","v":2.5000000000000001E-2},{"$f":"Serviceability!H56","v":0},{"$f":"Serviceability!I56","v":0},{"$f":"H33-I33","v":0},{"$f":"Serviceability!G56","v":0}]
[]
[]
["Existing Loan: Repayment With Buffer"]
["Buffered Loan 1",0.2,{"$f":"Serviceability!L59*(1+Tables!B37)","v":0},null,null,null,{"$f":"Serviceability!L59","v":0},{"$f":"Serviceability!E59","v":"Loan 1 - Existing Secured"}]
["Buffered Loan 2",0.2,{"$f":"Serviceability!L60*(1+Tables!B38)","v":0},null,null,null,{"$f":"Serviceability!L60","v":0},{"$f":"Serviceability!E60","v":"Loan 2 - Existing Secured"}]
[]
[]
["Additional Fees for Serviceability",null,null,null,null,null," "]
["Fees - Loan 1",15,{"$f":"IF(Serviceability!L55=0,0,15)","v":0},"Monthly Account Keeping Fee Resi",null,null," "]
["Fees - Loan 2",15,{"$f":"IF(Serviceability!L56=0,0,15)","v":0},"Monthly Account Keeping Fee Resi",null,null," "]
[]
[]
[]
["Column1","Single Adult","Single Adult + 1 Dependant","Single Adult + 2 Dependants","Single Adult + 3 Dependants","Single Adult + 4 Dependants","Single Adult + 5 Dependants","Single Adult + 6 Dependants","Couple","Couple + 1 Dependant","Couple + 2 Dependants","Couple + 3 Dependants","Couple + 4 Dependants","Couple + 5 Dependants","Couple + 6 Dependants"]
["Income Range ($)","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark","Proposed Benchmark"]
["0 - 23,000",1130.9647922804736,1611.7175919915917,2050.2008055077345,2623.6634955772988,2973.608268818597,3634.3037253191351,4293.5862337337994,2248.7389380243421,2651.9868291604157,2944.7970084478061,3285.4778576361859,3819.3701180140611,4138.4827082735283,4457.595298532995]
["23,001 - 34,000",1204.9654499764481,1611.7175919915917,2050.2008055077345,2623.6634955772988,2973.608268818597,3634.3037253191351,4293.5862337337994,2248.7389380243421,2651.9868291604157,2944.7970084478061,3285.4778576361859,3819.3701180140611,4138.4827082735283,4457.595298532995]
["34,001 - 46,000",1264.4432284896761,1670.7438712326432,2109.4426587720418,2623.6634955772988,2973.608268818597,3634.3037253191351,4293.5862337337994,2308.4616302262525,2651.9868291604157,2944.7970084478061,3285.4778576361859,3819.3701180140611,4138.4827082735283,4457.595298532995]
["46,001 - 57,000",1350.5065669132434,1756.1536566318066,2195.1644236723591,2712.1377924992494,3059.644024637852,3634.3037253191351,4293.5862337337994,2394.879159355623,2738.0782451615191,3031.0727677273803,3285.4778576361859,3819.3701180140611,4138.4827082735283,4457.595298532995]
["57,001 - 69,000",1497.9401503130018,1902.4679370709298,2342.0131178294791,2863.7017737755414,3207.0310103179081,3634.3037253191351,4293.5862337337994,2542.9197569761932,2885.5601831804192,3178.8705015042374,3433.0856739066517,3819.3701180140611,4138.4827082735283,4457.595298532995]
["69,001 - 92,000",1730.0608231939257,2132.8261442858015,2573.2127096694153,3102.3251460148745,3439.0777635538416,3866.331998643821,4293.5862337337994,2775.995889808501,3117.7567187555301,3411.5644271607266,3665.4808026752439,4050.715981246798,4369.3960041063729,4688.0760269659468]
["92,001 - 115,000",2056.2118763305302,2456.500864692955,2898.0696537818362,3437.6131925142727,3765.1251863074085,4192.3535138016277,4619.581841295847,3103.4895486635069,3444.0143584622529,3738.5206661671614,3992.0172606326082,4375.7779120505384,4693.8500028972958,5011.9220937440541]
["115,001 - 138,000",2347.8339691520782,2745.9087539259326,3188.5344090506655,3737.4045184795673,4056.6542195951597,4483.85928220593,4911.0643448167002,3396.3118730602218,3735.7320590949935,4030.862609125466,4283.984261845847,4666.4270068325804,4983.9557902756696,5301.4845737187588]
["138,001 - 161,000",2707.8408575255512,3103.1822124126843,3547.1130482742115,4107.4973031850959,4416.5469892784113,4843.7235222166255,5270.9000551548406,3757.8009305511059,4095.8567297847053,4391.7587952243211,4644.4166933922379,5025.2320227963291,5342.0897958576352,5658.9475689189412]
["161,001 - 184,000",2838.7015221859906,3233.0491315470786,3677.4543070485302,4242.0237980769225,4547.365647193993,4974.5316784459937,5401.6977096979936,3889.2001095109281,4226.7600487293876,4522.9424109523288,4775.431881700114,5155.6556837361131,5472.2695772924089,5788.8834708487047]
["184,001 - 229,000",3053.8888140934091,3446.6027252919098,3891.7878273231836,4463.2394503079931,4762.4847650510746,5189.6337527904907,5616.7827405299076,4105.2732766146864,4442.0178222762052,4738.6607866388749,4990.8736135318959,5370.1244939204853,5686.3372982469355,6002.5501025733847]
["229,001 - 287,000",3586.1384805759535,3974.811250337716,4421.9257160778407,5010.4000600961544,5294.5654770463179,5721.6722261639088,6148.7789752814997,4639.7138119564379,4974.4415437075249,5272.2248792265036,5523.7525804643237,5900.5976184747697,6215.8185701043521,6531.0395217339355]
["287,001 - 344,000",4138.7278802516548,4523.2048381780633,4972.3223145287966,5578.4698016826924,5846.9787454187554,6274.0414617105307,6701.1041780023052,5194.5778866151277,5527.2118912971928,5826.1783685618066,6076.9950047600969,6451.342266664542,6765.5333616768958,7079.7244566892496]
["344,001 - 574,000",4208.8776772260599,4592.8220077006335,5042.1937611478297,5650.5848088191115,5917.1062322924718,6344.163371059075,6771.2205098256782,5265.0164477032367,5597.3844799730732,5896.5016923000467,6147.2277217233895,6521.2578866920712,6835.3182464392794,7149.3786061864885]
[" "]
[]
[]
[]
[]
["Household 1"]
["Household 2","Monthly Income",null,null,null,"Other Income",null,"Company"]
[]
[null,"Household 1","Household 2",null,null,"Household 1","Household 2",null,"Always Household 1"]
["Applicant / Guarantor 1",{"$f":"IF(EXACT(Serviceability!F13, \"Household 1\"),Serviceability!G13,0)","v":0},{"$f":"IF(EXACT(Serviceability!F13, \"Household 2\"),Serviceability!G13,0)","v":0},null,"Applicant / Guarantor 1",{"$f":"IF(EXACT(Serviceability!F19, \"Household 1\"),Serviceability!L19,0)","v":0},{"$f":"IF(EXACT(Serviceability!F19, \"Household 2\"),Serviceability!L19,0)","v":0},"Applicant / Guarantor 1",{"$f":"Serviceability!G30","v":0}]
["Applicant / Guarantor 2",{"$f":"IF(EXACT(Serviceability!F14, \"Household 1\"),Serviceability!G14,0)","v":0},{"$f":"IF(EXACT(Serviceability!F14, \"Household 2\"),Serviceability!G14,0)","v":0},null,"Applicant / Guarantor 2",{"$f":"IF(EXACT(Serviceability!F20, \"Household 1\"),Serviceability!L20,0)","v":0},{"$f":"IF(EXACT(Serviceability!F20, \"Household 2\"),Serviceability!L20,0)","v":0}]
["Applicant / Guarantor 3",{"$f":"IF(EXACT(Serviceability!F15, \"Household 1\"),Serviceability!G15,0)","v":0},{"$f":"IF(EXACT(Serviceability!F15, \"Household 2\"),Serviceability!G15,0)","v":0},null,"Applicant / Guarantor 3",{"$f":"IF(EXACT(Serviceability!F21, \"Household 1\"),Serviceability!L21,0)","v":0},{"$f":"IF(EXACT(Serviceability!F21, \"Household 2\"),Serviceability!L21,0)","v":0}]
["Applicant / Guarantor 4",{"$f":"IF(EXACT(Serviceability!F16, \"Household 1\"),Serviceability!G16,0)","v":0},{"$f":"IF(EXACT(Serviceability!F16, \"Household 2\"),Serviceability!G16,0)","v":0},null,"Applicant / Guarantor 4",{"$f":"IF(EXACT(Serviceability!F22, \"Household 1\"),Serviceability!L22,0)","v":0},{"$f":"IF(EXACT(Serviceability!F22, \"Household 2\"),Serviceability!L22,0)","v":0}]
["Applicant Totals",{"$f":"SUM(B72:B75,F76,I72)","v":0},{"$f":"SUM(C72:C75,G76)","v":0},null,"Applicant Totals",{"$f":"SUM(F72:F75)*12","v":0},{"$f":"SUM(G72:G75)*12","v":0}]
[]
["Adults - household","",{"$f":"IF(C76<=59999,\"test\",IF(B3>93,\"A\",IF(B3>89,\"A-\",IF(B3>87,\"B+\",IF(B3>83,\"B\",IF(B3>79,\"B-\", IF(B3>77,\"C+\",IF(B3>73,\"C\",IF(B3>69,\"C-\",IF(B3>57,\"D+\",IF(B3>53,\"D\",IF(B3>49,\"D-\",\"\"))))))))))))","v":"test"}]
["Adults - household - new",{"$error":"#REF!"}]
["Dependant children - household"]
[]
["Adult",{"$f":"Serviceability!G41","v":0},{"$f":"Serviceability!G43","v":0},null,{"$f":"IF(Serviceability!G41>2, \"Please call 1300 722 462 for assistance with calculation \",\" \")","v":" "},null,null,null,null,null,null,null,null,"offset amount"]
["Dependent ",{"$f":"Serviceability!G42","v":0},{"$f":"Serviceability!G44","v":0},null,{"$f":"IF(Serviceability!G43>2, \"Please call 1300 722 462 for assistance with calculation \",\" \")","v":" "}]
[null,{"$f":"\"Adult-\" & B82 & \",Dependents-\" & B83","v":"Adult-0,Dependents-0"},{"$f":"\"Adult-\" & C82 & \",Dependents-\" & C83","v":"Adult-0,Dependents-0"}]
[]
["LookupKey","Household","Income Range","Living Expense"]
[{"$f":"B87 & \":\" & C87","v":"Adult-1,Dependents-0:0-23,000"},"Adult-1,Dependents-0","0-23,000",1130.96479228047]
[{"$f":"B88 & \":\" & C88","v":"Adult-1,Dependents-0:23,001-34,000"},"Adult-1,Dependents-0","23,001-34,000",1204.9654499764481]
["Adult-1,Dependents-0:34,001-46,000","Adult-1,Dependents-0","34,001-46,000",1264.4432284896761]
["Adult-1,Dependents-0:46,001-57,000","Adult-1,Dependents-0","46,001-57,000",1350.5065669132434]
["Adult-1,Dependents-0:57,001-69,000","Adult-1,Dependents-0","57,001-69,000",1497.9401503130018]
["Adult-1,Dependents-0:69,001-92,000","Adult-1,Dependents-0","69,001-92,000",1730.0608231939257]
["Adult-1,Dependents-0:92,001-115,000","Adult-1,Dependents-0","92,001-115,000",2056.2118763305302]
["Adult-1,Dependents-0:115,001-138,000","Adult-1,Dependents-0","115,001-138,000",2347.8339691520782]
["Adult-1,Dependents-0:138,001-161,000","Adult-1,Dependents-0","138,001-161,000",2707.8408575255512]
["Adult-1,Dependents-0:161,001-184,000","Adult-1,Dependents-0","161,001-184,000",2838.7015221859906]
["Adult-1,Dependents-0:184,001-229,000","Adult-1,Dependents-0","184,001-229,000",3053.8888140934091]
["Adult-1,Dependents-0:229,001-287,000","Adult-1,Dependents-0","229,001-287,000",3586.1384805759535]
["Adult-1,Dependents-0:287,001-344,000","Adult-1,Dependents-0","287,001-344,000",4138.7278802516548]
["Adult-1,Dependents-0:344,001-574,000","Adult-1,Dependents-0","344,001-574,000",4208.8776772260599]
[]
["Adult-1,Dependents-1:0-23,000","Adult-1,Dependents-1","0-23,000",1611.7175919915917]
["Adult-1,Dependents-1:23,001-34,000","Adult-1,Dependents-1","23,001-34,000",1611.7175919915917]
["Adult-1,Dependents-1:34,001-46,000","Adult-1,Dependents-1","34,001-46,000",1670.7438712326432]
["Adult-1,Dependents-1:46,001-57,000","Adult-1,Dependents-1","46,001-57,000",1756.1536566318066]
["Adult-1,Dependents-1:57,001-69,000","Adult-1,Dependents-1","57,001-69,000",1902.4679370709298]
["Adult-1,Dependents-1:69,001-92,000","Adult-1,Dependents-1","69,001-92,000",2132.8261442858015]
["Adult-1,Dependents-1:92,001-115,000","Adult-1,Dependents-1","92,001-115,000",2456.500864692955]
["Adult-1,Dependents-1:115,001-138,000","Adult-1,Dependents-1","115,001-138,000",2745.9087539259326]
["Adult-1,Dependents-1:138,001-161,000","Adult-1,Dependents-1","138,001-161,000",3103.1822124126843]
["Adult-1,Dependents-1:161,001-184,000","Adult-1,Dependents-1","161,001-184,000",3233.0491315470786]
["Adult-1,Dependents-1:184,001-229,000","Adult-1,Dependents-1","184,001-229,000",3446.6027252919098]
["Adult-1,Dependents-1:229,001-287,000","Adult-1,Dependents-1","229,001-287,000",3974.811250337716]
["Adult-1,Dependents-1:287,001-344,000","Adult-1,Dependents-1","287,001-344,000",4523.2048381780633]
["Adult-1,Dependents-1:344,001-574,000","Adult-1,Dependents-1","344,001-574,000",4592.8220077006335]
[]
[{"$f":"B117 & \":\" & C117","v":"Adult-1,Dependents-2:0-23,000"},"Adult-1,Dependents-2","0-23,000",2050.2008055077345]
["Adult-1,Dependents-2:23,001-34,000","Adult-1,Dependents-2","23,001-34,000",2050.2008055077345]
["Adult-1,Dependents-2:34,001-46,000","Adult-1,Dependents-2","34,001-46,000",2109.4426587720418]
["Adult-1,Dependents-2:46,001-57,000","Adult-1,Dependents-2","46,001-57,000",2195.1644236723591]
["Adult-1,Dependents-2:57,001-69,000","Adult-1,Dependents-2","57,001-69,000",2342.0131178294791]
["Adult-1,Dependents-2:69,001-92,000","Adult-1,Dependents-2","69,001-92,000",2573.2127096694153]
["Adult-1,Dependents-2:92,001-115,000","Adult-1,Dependents-2","92,001-115,000",2898.0696537818362]
["Adult-1,Dependents-2:115,001-138,000","Adult-1,Dependents-2","115,001-138,000",3188.5344090506655]
["Adult-1,Dependents-2:138,001-161,000","Adult-1,Dependents-2","138,001-161,000",3547.1130482742115]
["Adult-1,Dependents-2:161,001-184,000","Adult-1,Dependents-2","161,001-184,000",3677.4543070485302]
["Adult-1,Dependents-2:184,001-229,000","Adult-1,Dependents-2","184,001-229,000",3891.7878273231836]
["Adult-1,Dependents-2:229,001-287,000","Adult-1,Dependents-2","229,001-287,000",4421.9257160778407]
["Adult-1,Dependents-2:287,001-344,000","Adult-1,Dependents-2","287,001-344,000",4972.3223145287966]
["Adult-1,Dependents-2:344,001-574,000","Adult-1,Dependents-2","344,001-574,000",5042.1937611478297]
[]
[{"$f":"B132 & \":\" & C132","v":"Adult-1,Dependents-3:0-23,000"},"Adult-1,Dependents-3","0-23,000",2623.6634955772988]
["Adult-1,Dependents-3:23,001-34,000","Adult-1,Dependents-3","23,001-34,000",2623.6634955772988]
["Adult-1,Dependents-3:34,001-46,000","Adult-1,Dependents-3","34,001-46,000",2623.6634955772988]
["Adult-1,Dependents-3:46,001-57,000","Adult-1,Dependents-3","46,001-57,000",2712.1377924992494]
["Adult-1,Dependents-3:57,001-69,000","Adult-1,Dependents-3","57,001-69,000",2863.7017737755414]
["Adult-1,Dependents-3:69,001-92,000","Adult-1,Dependents-3","69,001-92,000",3102.3251460148745]
["Adult-1,Dependents-3:92,001-115,000","Adult-1,Dependents-3","92,001-115,000",3437.6131925142727]
["Adult-1,Dependents-3:115,001-138,000","Adult-1,Dependents-3","115,001-138,000",3737.4045184795673]
["Adult-1,Dependents-3:138,001-161,000","Adult-1,Dependents-3","138,001-161,000",4107.4973031850959]
["Adult-1,Dependents-3:161,001-184,000","Adult-1,Dependents-3","161,001-184,000",4242.0237980769225]
["Adult-1,Dependents-3:184,001-229,000","Adult-1,Dependents-3","184,001-229,000",4463.2394503079931]
["Adult-1,Dependents-3:229,001-287,000","Adult-1,Dependents-3","229,001-287,000",5010.4000600961544]
["Adult-1,Dependents-3:287,001-344,000","Adult-1,Dependents-3","287,001-344,000",5578.4698016826924]
["Adult-1,Dependents-3:344,001-574,000","Adult-1,Dependents-3","344,001-574,000",5650.5848088191115]
[]
[]
[{"$f":"B148 & \":\" & C148","v":"Adult-1,Dependents-4:0-23,000"},"Adult-1,Dependents-4","0-23,000",2973.608268818597]
["Adult-1,Dependents-4:23,001-34,000","Adult-1,Dependents-4","23,001-34,000",2973.608268818597]
["Adult-1,Dependents-4:34,001-46,000","Adult-1,Dependents-4","34,001-46,000",2973.608268818597]
["Adult-1,Dependents-4:46,001-57,000","Adult-1,Dependents-4","46,001-57,000",3059.644024637852]
["Adult-1,Dependents-4:57,001-69,000","Adult-1,Dependents-4","57,001-69,000",3207.0310103179081]
["Adult-1,Dependents-4:69,001-92,000","Adult-1,Dependents-4","69,001-92,000",3439.0777635538416]
["Adult-1,Dependents-4:92,001-115,000","Adult-1,Dependents-4","92,001-115,000",3765.1251863074085]
["Adult-1,Dependents-4:115,001-138,000","Adult-1,Dependents-4","115,001-138,000",4056.6542195951597]
["Adult-1,Dependents-4:138,001-161,000","Adult-1,Dependents-4","138,001-161,000",4416.5469892784113]
["Adult-1,Dependents-4:161,001-184,000","Adult-1,Dependents-4","161,001-184,000",4547.365647193993]
["Adult-1,Dependents-4:184,001-229,000","Adult-1,Dependents-4","184,001-229,000",4762.4847650510746]
["Adult-1,Dependents-4:229,001-287,000","Adult-1,Dependents-4","229,001-287,000",5294.5654770463179]
["Adult-1,Dependents-4:287,001-344,000","Adult-1,Dependents-4","287,001-344,000",5846.9787454187554]
["Adult-1,Dependents-4:344,001-574,000","Adult-1,Dependents-4","344,001-574,000",5917.1062322924718]
[]
[{"$f":"B163 & \":\" & C163","v":"Adult-1,Dependents-5:0-23,000"},"Adult-1,Dependents-5","0-23,000",3634.3037253191351]
["Adult-1,Dependents-5:23,001-34,000","Adult-1,Dependents-5","23,001-34,000",3634.3037253191351]
["Adult-1,Dependents-5:34,001-46,000","Adult-1,Dependents-5","34,001-46,000",3634.3037253191351]
["Adult-1,Dependents-5:46,001-57,000","Adult-1,Dependents-5","46,001-57,000",3634.3037253191351]
["Adult-1,Dependents-5:57,001-69,000","Adult-1,Dependents-5","57,001-69,000",3634.3037253191351]
["Adult-1,Dependents-5:69,001-92,000","Adult-1,Dependents-5","69,001-92,000",3866.331998643821]
["Adult-1,Dependents-5:92,001-115,000","Adult-1,Dependents-5","92,001-115,000",4192.3535138016277]
["Adult-1,Dependents-5:115,001-138,000","Adult-1,Dependents-5","115,001-138,000",4483.85928220593]
["Adult-1,Dependents-5:138,001-161,000","Adult-1,Dependents-5","138,001-161,000",4843.7235222166255]
["Adult-1,Dependents-5:161,001-184,000","Adult-1,Dependents-5","161,001-184,000",4974.5316784459937]
["Adult-1,Dependents-5:184,001-229,000","Adult-1,Dependents-5","184,001-229,000",5189.6337527904907]
["Adult-1,Dependents-5:229,001-287,000","Adult-1,Dependents-5","229,001-287,000",5721.6722261639088]
["Adult-1,Dependents-5:287,001-344,000","Adult-1,Dependents-5","287,001-344,000",6274.0414617105307]
["Adult-1,Dependents-5:344,001-574,000","Adult-1,Dependents-5","344,001-574,000",6344.163371059075]
[]
[{"$f":"B178 & \":\" & C178","v":"Adult-1,Dependents-6:0-23,000"},"Adult-1,Dependents-6","0-23,000",4293.5862337337994]
["Adult-1,Dependents-6:23,001-34,000","Adult-1,Dependents-6","23,001-34,000",4293.5862337337994]
["Adult-1,Dependents-6:34,001-46,000","Adult-1,Dependents-6","34,001-46,000",4293.5862337337994]
["Adult-1,Dependents-6:46,001-57,000","Adult-1,Dependents-6","46,001-57,000",4293.5862337337994]
["Adult-1,Dependents-6:57,001-69,000","Adult-1,Dependents-6","57,001-69,000",4293.5862337337994]
["Adult-1,Dependents-6:69,001-92,000","Adult-1,Dependents-6","69,001-92,000",4293.5862337337994]
["Adult-1,Dependents-6:92,001-115,000","Adult-1,Dependents-6","92,001-115,000",4619.581841295847]
["Adult-1,Dependents-6:115,001-138,000","Adult-1,Dependents-6","115,001-138,000",4911.0643448167002]
["Adult-1,Dependents-6:138,001-161,000","Adult-1,Dependents-6","138,001-161,000",5270.9000551548406]
["Adult-1,Dependents-6:161,001-184,000","Adult-1,Dependents-6","161,001-184,000",5401.6977096979936]
["Adult-1,Dependents-6:184,001-229,000","Adult-1,Dependents-6","184,001-229,000",5616.7827405299076]
["Adult-1,Dependents-6:229,001-287,000","Adult-1,Dependents-6","229,001-287,000",6148.7789752814997]
["Adult-1,Dependents-6:287,001-344,000","Adult-1,Dependents-6","287,001-344,000",6701.1041780023052]
["Adult-1,Dependents-6:344,001-574,000","Adult-1,Dependents-6","344,001-574,000",6771.2205098256782]
[]
[{"$f":"B193 & \":\" & C193","v":"Adult-2,Dependents-0:0-23,000"},"Adult-2,Dependents-0","0-23,000",2248.7389380243421]
[{"$f":"B194 & \":\" & C194","v":"Adult-2,Dependents-0:23,001-34,000"},"Adult-2,Dependents-0","23,001-34,000",2248.7389380243421]
["Adult-2,Dependents-0:34,001-46,000","Adult-2,Dependents-0","34,001-46,000",2308.4616302262525]
["Adult-2,Dependents-0:46,001-57,000","Adult-2,Dependents-0","46,001-57,000",2394.879159355623]
["Adult-2,Dependents-0:57,001-69,000","Adult-2,Dependents-0","57,001-69,000",2542.9197569761932]
["Adult-2,Dependents-0:69,001-92,000","Adult-2,Dependents-0","69,001-92,000",2775.995889808501]
["Adult-2,Dependents-0:92,001-115,000","Adult-2,Dependents-0","92,001-115,000",3103.4895486635069]
["Adult-2,Dependents-0:115,001-138,000","Adult-2,Dependents-0","115,001-138,000",3396.3118730602218]
["Adult-2,Dependents-0:138,001-161,000","Adult-2,Dependents-0","138,001-161,000",3757.8009305511059]
["Adult-2,Dependents-0:161,001-184,000","Adult-2,Dependents-0","161,001-184,000",3889.2001095109281]
["Adult-2,Dependents-0:184,001-229,000","Adult-2,Dependents-0","184,001-229,000",4105.2732766146864]
["Adult-2,Dependents-0:229,001-287,000","Adult-2,Dependents-0","229,001-287,000",4639.7138119564379]
["Adult-2,Dependents-0:287,001-344,000","Adult-2,Dependents-0","287,001-344,000",5194.5778866151277]
["Adult-2,Dependents-0:344,001-574,000","Adult-2,Dependents-0","344,001-574,000",5265.0164477032367]
[]
[{"$f":"B208 & \":\" & C208","v":"Adult-2,Dependents-1:0-23,000"},"Adult-2,Dependents-1","0-23,000",2651.9868291604157]
["Adult-2,Dependents-1:23,001-34,000","Adult-2,Dependents-1","23,001-34,000",2651.9868291604157]
["Adult-2,Dependents-1:34,001-46,000","Adult-2,Dependents-1","34,001-46,000",2651.9868291604157]
["Adult-2,Dependents-1:46,001-57,000","Adult-2,Dependents-1","46,001-57,000",2738.0782451615191]
["Adult-2,Dependents-1:57,001-69,000","Adult-2,Dependents-1","57,001-69,000",2885.5601831804192]
["Adult-2,Dependents-1:69,001-92,000","Adult-2,Dependents-1","69,001-92,000",3117.7567187555301]
["Adult-2,Dependents-1:92,001-115,000","Adult-2,Dependents-1","92,001-115,000",3444.0143584622529]
["Adult-2,Dependents-1:115,001-138,000","Adult-2,Dependents-1","115,001-138,000",3735.7320590949935]
["Adult-2,Dependents-1:138,001-161,000","Adult-2,Dependents-1","138,001-161,000",4095.8567297847053]
["Adult-2,Dependents-1:161,001-184,000","Adult-2,Dependents-1","161,001-184,000",4226.7600487293876]
["Adult-2,Dependents-1:184,001-229,000","Adult-2,Dependents-1","184,001-229,000",4442.0178222762052]
["Adult-2,Dependents-1:229,001-287,000","Adult-2,Dependents-1","229,001-287,000",4974.4415437075249]
["Adult-2,Dependents-1:287,001-344,000","Adult-2,Dependents-1","287,001-344,000",5527.2118912971928]
["Adult-2,Dependents-1:344,001-574,000","Adult-2,Dependents-1","344,001-574,000",5597.3844799730732]
[]
[{"$f":"B223 & \":\" & C223","v":"Adult-2,Dependents-2:0-23,000"},"Adult-2,Dependents-2","0-23,000",2944.7970084478061]
["Adult-2,Dependents-2:23,001-34,000","Adult-2,Dependents-2","23,001-34,000",2944.7970084478061]
["Adult-2,Dependents-2:34,001-46,000","Adult-2,Dependents-2","34,001-46,000",2944.7970084478061]
["Adult-2,Dependents-2:46,001-57,000","Adult-2,Dependents-2","46,001-57,000",3031.0727677273803]
["Adult-2,Dependents-2:57,001-69,000","Adult-2,Dependents-2","57,001-69,000",3178.8705015042374]
["Adult-2,Dependents-2:69,001-92,000","Adult-2,Dependents-2","69,001-92,000",3411.5644271607266]
["Adult-2,Dependents-2:92,001-115,000","Adult-2,Dependents-2","92,001-115,000",3738.5206661671614]
["Adult-2,Dependents-2:115,001-138,000","Adult-2,Dependents-2","115,001-138,000",4030.862609125466]
["Adult-2,Dependents-2:138,001-161,000","Adult-2,Dependents-2","138,001-161,000",4391.7587952243211]
["Adult-2,Dependents-2:161,001-184,000","Adult-2,Dependents-2","161,001-184,000",4522.9424109523288]
["Adult-2,Dependents-2:184,001-229,000","Adult-2,Dependents-2","184,001-229,000",4738.6607866388749]
["Adult-2,Dependents-2:229,001-287,000","Adult-2,Dependents-2","229,001-287,000",5272.2248792265036]
["Adult-2,Dependents-2:287,001-344,000","Adult-2,Dependents-2","287,001-344,000",5826.1783685618066]
["Adult-2,Dependents-2:344,001-574,000","Adult-2,Dependents-2","344,001-574,000",5896.5016923000467]
[]
[{"$f":"B238 & \":\" & C238","v":"Adult-2,Dependents-3:0-23,000"},"Adult-2,Dependents-3","0-23,000",3285.4778576361859]
["Adult-2,Dependents-3:23,001-34,000","Adult-2,Dependents-3","23,001-34,000",3285.4778576361859]
["Adult-2,Dependents-3:34,001-46,000","Adult-2,Dependents-3","34,001-46,000",3285.4778576361859]
["Adult-2,Dependents-3:46,001-57,000","Adult-2,Dependents-3","46,001-57,000",3285.4778576361859]
["Adult-2,Dependents-3:57,001-69,000","Adult-2,Dependents-3","57,001-69,000",3433.0856739066517]
["Adult-2,Dependents-3:69,001-92,000","Adult-2,Dependents-3","69,001-92,000",3665.4808026752439]
["Adult-2,Dependents-3:92,001-115,000","Adult-2,Dependents-3","92,001-115,000",3992.0172606326082]
["Adult-2,Dependents-3:115,001-138,000","Adult-2,Dependents-3","115,001-138,000",4283.984261845847]
["Adult-2,Dependents-3:138,001-161,000","Adult-2,Dependents-3","138,001-161,000",4644.4166933922379]
["Adult-2,Dependents-3:161,001-184,000","Adult-2,Dependents-3","161,001-184,000",4775.431881700114]
["Adult-2,Dependents-3:184,001-229,000","Adult-2,Dependents-3","184,001-229,000",4990.8736135318959]
["Adult-2,Dependents-3:229,001-287,000","Adult-2,Dependents-3","229,001-287,000",5523.7525804643237]
["Adult-2,Dependents-3:287,001-344,000","Adult-2,Dependents-3","287,001-344,000",6076.9950047600969]
["Adult-2,Dependents-3:344,001-574,000","Adult-2,Dependents-3","344,001-574,000",6147.2277217233895]
[]
[]
[{"$f":"B254 & \":\" & C254","v":"Adult-2,Dependents-4:0-23,000"},"Adult-2,Dependents-4","0-23,000",3819.3701180140611]
["Adult-2,Dependents-4:23,001-34,000","Adult-2,Dependents-4","23,001-34,000",3819.3701180140611]
["Adult-2,Dependents-4:34,001-46,000","Adult-2,Dependents-4","34,001-46,000",3819.3701180140611]
["Adult-2,Dependents-4:46,001-57,000","Adult-2,Dependents-4","46,001-57,000",3819.3701180140611]
["Adult-2,Dependents-4:57,001-69,000","Adult-2,Dependents-4","57,001-69,000",3819.3701180140611]
["Adult-2,Dependents-4:69,001-92,000","Adult-2,Dependents-4","69,001-92,000",4050.715981246798]
["Adult-2,Dependents-4:92,001-115,000","Adult-2,Dependents-4","92,001-115,000",4375.7779120505384]
["Adult-2,Dependents-4:115,001-138,000","Adult-2,Dependents-4","115,001-138,000",4666.4270068325804]
["Adult-2,Dependents-4:138,001-161,000","Adult-2,Dependents-4","138,001-161,000",5025.2320227963291]
["Adult-2,Dependents-4:161,001-184,000","Adult-2,Dependents-4","161,001-184,000",5155.6556837361131]
["Adult-2,Dependents-4:184,001-229,000","Adult-2,Dependents-4","184,001-229,000",5370.1244939204853]
["Adult-2,Dependents-4:229,001-287,000","Adult-2,Dependents-4","229,001-287,000",5900.5976184747697]
["Adult-2,Dependents-4:287,001-344,000","Adult-2,Dependents-4","287,001-344,000",6451.342266664542]
["Adult-2,Dependents-4:344,001-574,000","Adult-2,Dependents-4","344,001-574,000",6521.2578866920712]
[]
[{"$f":"B269 & \":\" & C269","v":"Adult-2,Dependents-5:0-23,000"},"Adult-2,Dependents-5","0-23,000",4138.4827082735283]
["Adult-2,Dependents-5:23,001-34,000","Adult-2,Dependents-5","23,001-34,000",4138.4827082735283]
["Adult-2,Dependents-5:34,001-46,000","Adult-2,Dependents-5","34,001-46,000",4138.4827082735283]
["Adult-2,Dependents-5:46,001-57,000","Adult-2,Dependents-5","46,001-57,000",4138.4827082735283]
["Adult-2,Dependents-5:57,001-69,000","Adult-2,Dependents-5","57,001-69,000",4138.4827082735283]
["Adult-2,Dependents-5:69,001-92,000","Adult-2,Dependents-5","69,001-92,000",4369.3960041063729]
["Adult-2,Dependents-5:92,001-115,000","Adult-2,Dependents-5","92,001-115,000",4693.8500028972958]
["Adult-2,Dependents-5:115,001-138,000","Adult-2,Dependents-5","115,001-138,000",4983.9557902756696]
["Adult-2,Dependents-5:138,001-161,000","Adult-2,Dependents-5","138,001-161,000",5342.0897958576352]
["Adult-2,Dependents-5:161,001-184,000","Adult-2,Dependents-5","161,001-184,000",5472.2695772924089]
["Adult-2,Dependents-5:184,001-229,000","Adult-2,Dependents-5","184,001-229,000",5686.3372982469355]
["Adult-2,Dependents-5:229,001-287,000","Adult-2,Dependents-5","229,001-287,000",6215.8185701043521]
["Adult-2,Dependents-5:287,001-344,000","Adult-2,Dependents-5","287,001-344,000",6765.5333616768958]
["Adult-2,Dependents-5:344,001-574,000","Adult-2,Dependents-5","344,001-574,000",6835.3182464392794]
[]
[{"$f":"B284 & \":\" & C284","v":"Adult-2,Dependents-6:0-23,000"},"Adult-2,Dependents-6","0-23,000",4457.595298532995]
["Adult-2,Dependents-6:23,001-34,000","Adult-2,Dependents-6","23,001-34,000",4457.595298532995]
["Adult-2,Dependents-6:34,001-46,000","Adult-2,Dependents-6","34,001-46,000",4457.595298532995]
["Adult-2,Dependents-6:46,001-57,000","Adult-2,Dependents-6","46,001-57,000",4457.595298532995]
["Adult-2,Dependents-6:57,001-69,000","Adult-2,Dependents-6","57,001-69,000",4457.595298532995]
["Adult-2,Dependents-6:69,001-92,000","Adult-2,Dependents-6","69,001-92,000",4688.0760269659468]
["Adult-2,Dependents-6:92,001-115,000","Adult-2,Dependents-6","92,001-115,000",5011.9220937440541]
["Adult-2,Dependents-6:115,001-138,000","Adult-2,Dependents-6","115,001-138,000",5301.4845737187588]
["Adult-2,Dependents-6:138,001-161,000","Adult-2,Dependents-6","138,001-161,000",5658.9475689189412]
["Adult-2,Dependents-6:161,001-184,000","Adult-2,Dependents-6","161,001-184,000",5788.8834708487047]
["Adult-2,Dependents-6:184,001-229,000","Adult-2,Dependents-6","184,001-229,000",6002.5501025733847]
["Adult-2,Dependents-6:229,001-287,000","Adult-2,Dependents-6","229,001-287,000",6531.0395217339355]
["Adult-2,Dependents-6:287,001-344,000","Adult-2,Dependents-6","287,001-344,000",7079.7244566892496]
["Adult-2,Dependents-6:344,001-574,000","Adult-2,Dependents-6","344,001-574,000",7149.3786061864885]
[]
[]
[null,"Household 1","Household 2"]
["Household Key",{"$f":"B84","v":"Adult-0,Dependents-0"},{"$f":"C84","v":"Adult-0,Dependents-0"}]
["Salary Key",{"$f":"IF(B76<=0,\"0-23000\",IF(B76<=23000,\"0-23000\",IF(B76<=34000,\"23000-34000\",IF(B76<=46000,\"34001-46000\",IF(B76<=57000,\"46001-57000\",IF(B76<=69000,\"57001-69000\",IF(B76<=92000,\"69001-92000\",IF(B76<=115000,\"92001-115000\",IF(B76<=138000,\"115001-138000\",IF(B76<=161000,\"138001-161000\",IF(B76<=184000,\"161001-184000\",IF(B76<=229000,\"184001-229000\",IF(B76<=287000,\"229001-287000\",IF(B76<=344000,\"287001-344000\",IF(B76>344000,\"344000-574000\",FALSE)))))))))))))))","v":"0-23000"},{"$f":"IF(C76<=0,\"0-23000\",IF(C76<=23000,\"0-23000\",IF(C76<=34000,\"23000-34000\",IF(C76<=46000,\"34001-46000\",IF(C76<=57000,\"46001-57000\",IF(C76<=69000,\"57001-69000\",IF(C76<=92000,\"69001-92000\",IF(C76<=115000,\"92001-115000\",IF(C76<=138000,\"115001-138000\",IF(C76<=161000,\"138001-161000\",IF(C76<=184000,\"161001-184000\",IF(C76<=229000,\"184001-229000\",IF(C76<=287000,\"229001-287000\",IF(C76<=344000,\"287001-344000\",IF(C76>344000,\"344000-574000\",FALSE)))))))))))))))","v":"0-23000"}]
["Household Living Expense",{"$f":"HEM!F46","v":0},{"$f":"HEM!J46","v":0}]
[]
[]
[]
[]
["Monthly expense",{"$f":"MAX(SUM(B303:C303),Serviceability!G38)","v":0}]
[]
[]
["Avaiable Income",{"$f":"Serviceability!L32-Tables!B308","v":0}]
[]
[]
[]
[]
[]
["RedZed Loan Applied For Loan1",{"$f":"IF(Serviceability!H55=0,0,IF(Serviceability!J55=0,0,-PMT((Serviceability!J55)/12,(Serviceability!H55-Serviceability!I55)*12,Serviceability!G55)))","v":0}]
["RedZed Loan Applied For Loan2",{"$f":"IF(Serviceability!H56=0,0,IF(Serviceability!J56=0,0,-PMT((Serviceability!J56)/12,(Serviceability!H56-Serviceability!I56)*12,Serviceability!G56)))","v":0}]

{"sheet":"Serviceability Calc","index":3,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["Serviceability Cell Calculation"]
[]
[null,{"$f":"Serviceability!D49&\" (After Tax Rates Applied)\"","v":"Available Income (After Tax Rates Applied)"},{"$f":"Serviceability!L49","v":0}]
[null,"Divided by"]
[null,{"$f":"Serviceability!D71","v":"Total Monthly Commitments"},{"$f":"SUM(Serviceability!L55:L70)","v":0}]
["Less",{"$f":"Serviceability!$D$53&\" - \"&Serviceability!E55","v":"RedZed Loan Applied For - Loan 1"},{"$f":"-Serviceability!L55","v":0}]
["Less",{"$f":"Serviceability!$D$53&\" - \"&Serviceability!E56","v":"RedZed Loan Applied For - Loan 2"},{"$f":"-Serviceability!L56","v":0}]
["Plus",{"$f":"Serviceability!$D$53&\" - \"&Tables!A32","v":"RedZed Loan Applied For - Buffered Loan 1"},{"$f":"Tables!B32","v":0}]
["Plus",{"$f":"Serviceability!$D$53&\" - \"&Tables!A33","v":"RedZed Loan Applied For - Buffered Loan 2"},{"$f":"Tables!B33","v":0}]
["Less",{"$f":"Serviceability!$D$59&\": \"&Serviceability!E59","v":"Existing Loans: Loan 1 - Existing Secured"},{"$f":"-Serviceability!L59","v":0}]
["Less",{"$f":"Serviceability!$D$59&\": \"&Serviceability!E60","v":"Existing Loans: Loan 2 - Existing Secured"},{"$f":"-Serviceability!L60","v":0}]
["Plus",{"$f":"Serviceability!$D$59&\": \"&Tables!A37","v":"Existing Loans: Buffered Loan 1"},{"$f":"Tables!C37","v":0}]
["Plus",{"$f":"Serviceability!$D$59&\": \"&Tables!A38","v":"Existing Loans: Buffered Loan 2"},{"$f":"Tables!C38","v":0}]
["Plus",{"$f":"Tables!A42","v":"Fees - Loan 1"},{"$f":"Tables!C42","v":0}]
["Plus",{"$f":"Tables!A43","v":"Fees - Loan 2"},{"$f":"Tables!C43","v":0}]
[]
[null,"Total Monthly Commitments (After Repayment Buffering & Fees)",{"$f":"SUM(C5:C16)","v":0}]
[]
[null,{"$f":"Serviceability!I74&\" - Calculated as:\"","v":" - Calculated as:"},{"$f":"ROUNDUP(C3/C17,2)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Tax Calc","index":4,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Tax Calc"]
[]
["Annual Gross",null,null,"Gross","Tax","Medicare","Income offset","Net","Net Monthly"]
[]
["Applicant / G'Tor 1","Salary / Self Employed",null,{"$f":"Serviceability!G13","v":0},{"$f":"IF(D5<Tables!$A$6,0,IF(AND(D5>Tables!$A$6,D5<Tables!$A$7),(D5-Tables!$A$6)*Tables!$C$6,IF(AND(D5>Tables!$A$7,D5<Tables!$A$8),Tables!$D$7+(D5-Tables!$A$7)*Tables!$C$7,IF(AND(D5>Tables!$A$8,D5<Tables!$A$9),Tables!$D$8+(D5-Tables!$A$8)*Tables!$C$8,IF(D5>Tables!$A$9,Tables!$D$9+(D5-Tables!$A$9)*Tables!$C$9)))))","v":0},{"$f":"D5*Tables!C$16","v":0},{"$f":"IFERROR(((D5-VLOOKUP(D5,$A$29:$D$33,1,TRUE))*VLOOKUP(D5,$A$29:$D$33,3,TRUE)+VLOOKUP(D5,$A$29:$D$33,4,TRUE)),0)+IFERROR((IF(D5>66667,66667-45001,(D5-VLOOKUP(D5,$A$41:$D$43,1,TRUE)))*VLOOKUP(D5,$A$41:$D$43,3,TRUE)+VLOOKUP(D5,$A$41:$D$43,4,TRUE)),0)","v":0},{"$f":"D5-E5-F5+G5","v":0},{"$f":"H5/12","v":0}]
["Applicant / G'Tor 2","Salary / Self Employed",null,{"$f":"Serviceability!G14","v":0},{"$f":"IF(D6<Tables!$A$6,0,IF(AND(D6>=Tables!$A$6,D6<Tables!$A$7),(D6-Tables!$A$6)*Tables!$C$6,IF(AND(D6>=Tables!$A$7,D6<Tables!$A$8),Tables!$D$7+(D6-Tables!$A$7)*Tables!$C$7,IF(AND(D6>=Tables!$A$8,D6<Tables!$A$9),Tables!$D$8+(D6-Tables!$A$8)*Tables!$C$8,IF(D6>=Tables!$A$9,Tables!$D$9+(D6-Tables!$A$9)*Tables!$C$9)))))","v":0},{"$f":"D6*Tables!C$16","v":0},{"$f":"IFERROR(((D6-VLOOKUP(D6,$A$29:$D$33,1,TRUE))*VLOOKUP(D6,$A$29:$D$33,3,TRUE)+VLOOKUP(D6,$A$29:$D$33,4,TRUE)),0)+IFERROR((IF(D6>66667,66667-45001,(D6-VLOOKUP(D6,$A$41:$D$43,1,TRUE)))*VLOOKUP(D6,$A$41:$D$43,3,TRUE)+VLOOKUP(D6,$A$41:$D$43,4,TRUE)),0)","v":0},{"$f":"D6-E6-F6+G6","v":0},{"$f":"H6/12","v":0}]
["Applicant / G'Tor 3","Salary / Self Employed",null,{"$f":"Serviceability!G15","v":0},{"$f":"IF(D7<Tables!$A$6,0,IF(AND(D7>=Tables!$A$6,D7<Tables!$A$7),(D7-Tables!$A$6)*Tables!$C$6,IF(AND(D7>=Tables!$A$7,D7<Tables!$A$8),Tables!$D$7+(D7-Tables!$A$7)*Tables!$C$7,IF(AND(D7>=Tables!$A$8,D7<Tables!$A$9),Tables!$D$8+(D7-Tables!$A$8)*Tables!$C$8,IF(D7>=Tables!$A$9,Tables!$D$9+(D7-Tables!$A$9)*Tables!$C$9)))))","v":0},{"$f":"D7*Tables!C$16","v":0},0,0,{"$f":"H7/12","v":0}]
["Applicant / G'Tor 4","Salary / Self Employed",null,{"$f":"Serviceability!G16","v":0},{"$f":"IF(D8<Tables!$A$6,0,IF(AND(D8>=Tables!$A$6,D8<Tables!$A$7),(D8-Tables!$A$6)*Tables!$C$6,IF(AND(D8>=Tables!$A$7,D8<Tables!$A$8),Tables!$D$7+(D8-Tables!$A$7)*Tables!$C$7,IF(AND(D8>=Tables!$A$8,D8<Tables!$A$9),Tables!$D$8+(D8-Tables!$A$8)*Tables!$C$8,IF(D8>=Tables!$A$9,Tables!$D$9+(D8-Tables!$A$9)*Tables!$C$9)))))","v":0},{"$f":"D8*Tables!C$16","v":0},0,0,{"$f":"H8/12","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Test lower and middle income offset",null,null,"Formula","( income - income lower range ) *offset rate + baseline"]
[]
["income","offset baseline","Income lower range","Income - Lower range","offset reduced %","offset reduced amount","offset amount"]
[80000,{"$f":"VLOOKUP(A22,A29:D33,4,TRUE)","v":1080},{"$f":"VLOOKUP(A22,A29:D33,1,TRUE)","v":48001},{"$f":" A22-C22","v":31999},{"$f":"VLOOKUP(A22,A29:D33,3,TRUE)","v":0},{"$f":"+D22*E22","v":0},{"$f":"SUM(B22,F22)","v":1080}]
[]
[]
[]
["Lower and Middle income offset"]
[]
["Wages Over","Not to Exceed","Tax Rate"]
[1,37000,null,255]
[{"$f":"B29+1","v":37001},48000,7.4999999999999997E-2,255]
[{"$f":"B30+1","v":48001},90000,0,1080]
[{"$f":"B31+1","v":90001},126000,-0.03,1080]
[{"$f":"B32+1","v":126001},null,0,0]
[]
[]
[]
[]
["Low Income offset"]
[]
["Wages Over","Not to Exceed","Tax Rate"]
[1,37500,null,700,null,null,null,null,null,null,{"$f":"I41*52","v":0}]
[{"$f":"B41+1","v":37501},45000,-0.05,700]
[{"$f":"B42+1","v":45001},66667,-1.4999999999999999E-2,325]
[]
[]
[]
[]
["Test low income"]
[]
["income","offset baseline","Income lower range","Income - Lower range","offset reduced %","offset reduced amount","offset amount"]
[80000,{"$f":"VLOOKUP(A51,A41:D43,4,TRUE)","v":325},{"$f":"VLOOKUP(A51,A41:D43,1,TRUE)","v":45001},{"$f":"IF(A51>66667, 66667-45001, A51-C51)","v":21666},{"$f":"VLOOKUP(A51,A41:D43,3,TRUE)","v":-1.4999999999999999E-2},{"$f":"+D51*E51","v":-324.99},{"$f":"SUM(B51,F51)","v":9.9999999999909051E-3}]

{"sheet":"User Problems","index":5,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["#","Date","Submitted By","Sheet Name (if applicable)","Problem","Initial Review Assessment","Review Result Date","Review With User","Review Result or Action to Take","Sheets Affected","Development Version #","Type","Estimate (hrs)","Actual","Status","Date Unit Tested","Release Version #"]
[1,"2017-04-06","Bill Slattery",null,"What we are trying to achieve is a stress test of servicing capacity at the higher of;\n1. The selected interest rate + 2% or \n2. 7% \nThis change should only apply to Residential loans.\n",null,null,null,null,null,{"$f":"'Version Control'!C2","v":"V6.4 Test"},"Enhancement",null,null,"Completed","2017-04-10",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[2,"2017-04-10","Trevor Smith",null,"The tax table in the Residential calculator is not the same as in the Consolidated Calculator. Looks like the Residential Calculator was not updated for the 2017/2018 change to the upper limit for the 32.5% rate (ie from $80000 to $87000).","Change the tax table in the Residential Calculator in expectation you want it to match that in the Consolidated Calculator.","2017-04-10","Bill Slattery","Change as recommended",null,{"$f":"'Version Control'!C3","v":"V6.4 Test2  (v6.42)"},"Bug",null,null,"Completed","2017-04-10",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[3,"2017-04-24","Bill Slattery","Serviceability Calc","Add Serviceabilty Calculation Sheet as per Consolidated User Problem #131.","Name as \"Serviceability Calc\"",null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[4,"2017-04-24","Mario Lorenzi",null,"Add two macros:\n-Ctl/Shift/B to unhide the calculation sheets\n-Ctl/Shift/H to hide the calculation sheets\n",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[5,"2017-04-24","Mario Lorenzi","Tables","Change Company Tax Rate to 28.5%","Set up a  a new Company Tax Table on Tables sheet. Change Company Income Calculation (Cell K18) to reference the new Company Tax Table.",null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Data Maintenance",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[6,"2017-04-24","Mario Lorenzi","Serviceability","Add Interest Only Term cells for RedZed Loans 1 and 2 on Serviceability sheet.\nChange the Rate buffering calculation to use the net term (Total Term less Interest Only Term)",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[7,"2017-04-24","Mario Lorenzi","Serviceability","Add Source of Other Incomes cell for each of the Other Regular Monthly Income lines on the Serviceability sheets.",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[8,"2017-04-24","Mario Lorenzi","Serviceability","Change Company Income heading to display \"Company Income (if applicable)\"",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[9,"2017-04-24","Mario Lorenzi","Serviceability","Swap columns displaying Existing & New v Rental Income/Rental Income ",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[10,"2017-04-24","Mario Lorenzi","Tables","Check Monthly Service Fee calculation - to assume entry of Residential Loans only - calculated at $15 per month",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Bug",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[11,"2017-04-24","Mario Lorenzi","Serviceability","Company Income headings realigned to display above the detail line",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[12,"2017-04-24","Mario Lorenzi","Serviceability","Company Income section moved to display after Rental Income",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[13,"2017-04-24","Mario Lorenzi","Serviceability","Change Personal Income descriptors from \"Guarantor 1, 2, 3, and 4\" to \"Applicant / Guarantor 1, 2, 3, and 4\"",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[14,"2017-04-24","Mario Lorenzi","Tables","Tables Sheet - Highlight in yellow those data cells that can be changed to reflect legislation or company policy changes.",null,null,null,null,null,{"$f":"'Version Control'!$C$4","v":"V6.6 Test (v6.43)"},"Enhancement",null,null,"Completed","2017-05-01",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[15,"2017-06-08","Mario Lorenzi","Tax Calc","Tax Calc Sheet - delete Other Income Cells A10 to I13",null,null,null,null,null,{"$f":"'Version Control'!$C$5","v":"V6.8 Test (v6.44)"},"Enhancement",null,null,"Completed","2017-06-15",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[16,"2017-06-08","Mario Lorenzi","Tax Calc","Tax Calc Sheet - delete \"Correct Formula For Serviceability - Don’t Think Arm Can Do This\" Cells L1 to R25",null,null,null,null,null,{"$f":"'Version Control'!$C$5","v":"V6.8 Test (v6.44)"},"Enhancement",null,null,"Completed","2017-06-15",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[17,"2017-06-08","Mario Lorenzi","Serviceability","Fix formatting of Financier Cells for Existing Loans",null,null,null,null,null,{"$f":"'Version Control'!$C$5","v":"V6.8 Test (v6.44)"},"Bug",null,null,"Completed","2017-06-15",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[18,"2017-06-19","Trevor Smith","User Problems\nVersion Control","Add Sheets for User Problems and Version Control.",null,null,null,null,null,{"$f":"'Version Control'!$C$6","v":"V6.9 (v6.45)"},"Enhancement",null,null,"Completed","2017-06-20",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[19,"2017-06-19","Angelo Klidomitis","Serviceability","Change Look & Feel as per 4.0 ServiceabilityCalculator.xlsx",null,null,null,null,null,{"$f":"'Version Control'!$C$6","v":"V6.9 (v6.45)"},"Enhancement",null,null,"Completed","2017-06-21",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[20,"2017-05-22","Mario Lorenzi & Bill Slattery","Serviceability","Increase readability of printed version of the sheet",null,null,null,null,null,{"$f":"'Version Control'!C7","v":"V6.10 (v6.46)"},"Enhancement",null,null,"Completed","2017-06-26",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[21,"2017-06-29","Mario Lorenzi","Serviceability","1) Borders missing for  Enter Source of Income, Rental Income, Maintenance, & Other Fixed Monthly Repayments.\n2) Enter a zero in each dollar entry cell so the user is aware it is available for entry.",null,null,null,null,null,{"$f":"'Version Control'!C8","v":"v6.47 Pending"},"Enhancement & Bug",null,null,"Completed","2017-06-29",{"$f":"'Version Control'!$C$9","v":"v6.5"}]
[22,"2018-11-20","Lorraine Taylor ","Servicebility","IF more then three adult in one household please display the mssage",null,null,null,null,null,"V7.3",null,null,null,"Completed","2018-11-20","V7.3"]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]

{"sheet":"Version Control","index":6,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Name","Date","Version #","Development Version File Name","Changes","Released Version",null,"Current Version",{"$f":"VLOOKUP($J$1,B2:$I$3983,8,FALSE)","v":"V10.16 220616"},{"$f":"MAX(B2:B3983)","v":"2022-06-16"}]
["Trevor Smith","2017-04-10","V6.4 Test","K:\\IT\\Change_Work Requests\\Work Request\\WR004 - Commercial Calculator\\02 Residential Calculator\\2017 05 Changes\\4. REDZED-Serviceability-170410-V6.4 Test2.xls","User Problem 1",null,{"$f":"IFERROR(VLOOKUP(MONTH(B2),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B2),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0410"},{"$f":"RIGHT(YEAR(B2),2)&G2","v":"170410"},{"$f":"CONCATENATE(C2,\" \",H2)","v":"V6.4 Test 170410"}]
["Trevor Smith","2017-04-10","V6.4 Test2  (v6.42)","K:\\IT\\Change_Work Requests\\Work Request\\WR004 - Commercial Calculator\\02 Residential Calculator\\2017 05 Changes\\4. REDZED-Serviceability-170410-V6.4 Test.xls","User Problem 2",null,{"$f":"IFERROR(VLOOKUP(MONTH(B3),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B3),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0410"},{"$f":"RIGHT(YEAR(B3),2)&G3","v":"170410"},{"$f":"CONCATENATE(C3,\" \",H3)","v":"V6.4 Test2  (v6.42) 170410"}]
["Trevor Smith","2017-05-01","V6.6 Test (v6.43)","K:\\IT\\Change_Work Requests\\Work Request\\WR004 - Commercial Calculator\\02 Residential Calculator\\2017 05 Changes\\4. REDZED-Serviceability-170410-V6.6 Test.xls","User Problems 3 - 14 inclusive",null,{"$f":"IFERROR(VLOOKUP(MONTH(B4),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B4),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0501"},"170501","V6.6 Test (v6.43) 170501"]
["Trevor Smith","2017-05-15","V6.8 Test (v6.44)","K:\\IT\\Change_Work Requests\\Work Request\\WR004 - Commercial Calculator\\02 Residential Calculator\\2017 05 Changes\\4. REDZED-Serviceability-170410-V6.8 Test.xls","User Problems 15 - 17 inclusive",null,{"$f":"IFERROR(VLOOKUP(MONTH(B5),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B5),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0515"},"170515","V6.8 Test (v6.44) 170515"]
["Trevor Smith","2017-06-21","V6.9 (v6.45)","K:\\IT\\Change_Work Requests\\Work Request\\WR004 - Commercial Calculator\\02 Residential Calculator\\2017 05 Changes\\4. REDZED-Serviceability-170410-V6.9.xls","User Problem 18 - 19","Issued to Mario Lorenzi for testing 20 June 2017",{"$f":"IFERROR(VLOOKUP(MONTH(B6),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B6),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0621"},"170621","V6.9 (v6.45) 170621"]
["Trevor Smith","2017-06-27","V6.10 (v6.46)","K:\\IT\\Change_Work Requests\\Work Request\\WR004 - Commercial Calculator\\02 Residential Calculator\\2017 05 Changes\\4. REDZED-Serviceability-170410-V6.10.xls\nA changed versioning system for both this Residential Calculator and the Commercial Calculator was agreed with Tina Georgiadis 26 June 2015 (after receiving feedback from Angel Klidomitis). The last version of the Residential Calculator was named \"4. REDZED-Serviceability-170410-V6.4.xls\". The naming convention is being changed to \"REDZED-Serviceability Type (ie Residential or Commercial) Version Number.xls\". Each release will have a date added as a suffix in the format yymmdd. Because the upcoming release does not contain major ammendments it will be named  \"REDZED-Serviceability Residential v6.5 yymmdd.xls\". This being the case, the naming of the development files should have been as per the bracketed values in the Version # cells (eg 4. REDZED-Serviceability-170410-V6.4 Test.xls should have been 4. REDZED-Serviceability-170410-V6.41.xls)\nTo move to the new numbering system this version was copied and renamed and saved to the new development and release folder structure 26 June 2017. The new location and file name is K:\\Credit\\Servicing Calculator - Residential\\Development - Residential\\REDZED-Serviceability Residential V0.646.xlsm. The released version number for this series of amendments will be v6.5 with a date added in the format yymmdd.","A renamed version + User Problem 20",null,{"$f":"IFERROR(VLOOKUP(MONTH(B7),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B7),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0627"},"170627","V6.10 (v6.46) 170627"]
["Trevor Smith","2017-06-29","v6.47 Pending","K:\\Credit\\Servicing Calculator - Residential\\Development - Residential\\REDZED-Serviceability Residential V0.647.xlsm","User Problem 21",null,{"$f":"IFERROR(VLOOKUP(MONTH(B8),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B8),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0629"},"170629","v6.47 Pending 170629"]
["Trevor Smith","2017-06-30","v6.5",null,null,"K:\\Credit\\Servicing Calculator - Residential\\Current Released Version - Residential\\REDZED-Serviceability Residential V6.5.xlsm",{"$f":"IFERROR(VLOOKUP(MONTH(B9),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B9),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0630"},"170630","v6.5 170630"]
["Mayank Badhen","2018-06-25","V7.1A","Updated the living expense ",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B10),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B10),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0625"},"180625","V7.1A 180625"]
["Mayank Badhen","2018-07-25","V7.2","updated living expense for Company\nselecting household is mandatory\nupdated the tax scale\ncompnay income is always attached to household 1",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B11),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B11),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0725"},"180725","V7.2 180725"]
["Mayank Badhen","2018-12-11","V7.2.1","IF more then three adult in one household please display the mssage",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B12),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B12),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"1211"},"181211","V7.2.1 181211"]
["Mayank Badhen","2019-06-26","V7.3","credit card obligations",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B13),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B13),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0626"},"190626","V7.3 190626"]
["Mayank Badhen","2019-12-02","V7.4","IO term fixed",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B14),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B14),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"1202"},"191202","V7.4 191202"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B15),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B15),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"N/A"},"00N/A"," 00N/A"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B16),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B16),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"N/A"},"00N/A"," 00N/A"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B17),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B17),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"N/A"},"00N/A"," 00N/A"]
["John Jiang","2020-07-30","V10.0","1. Residential calculator \na. Introduction of a traffic light Pass, Refer to RZ or Fail notification. Pass >1.10, Refer >1.05 – 1.10, Fail below 1.05. The introduction of the Refer category is designed to encourage brokers to Refer deals where we don’t quite meet servicing requirements, but in discussion with RZ we may jointly find a way forward. Potentially these deals may be currently being sent to other lenders who have lower servicing ratio benchmarks). \nb. Creating a blank template.\nc. Removal of the tax calculation for company income to fall in line with the policy which states that we assess on NPBT.\n \nOther general changes including ensuring;\n1. Living expenses were consistent across all selections (there were some errors & inconsistencies)\n2. Tax scales were checked and amended for consistency.\n",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B18),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B18),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0730"},"200730","V10.0 200730"]
["John Jiang","2020-08-13","V10.0 Residential","Changed footer",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B19),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B19),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0813"},"200813","V10.0 Residential 200813"]
["John Jiang","2020-11-16","V10.1","changed tax bracket to new 2020 tax regulation",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B20),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B20),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"1116"},"201116","V10.1 201116"]
["John Jiang","2020-12-17","V10.11","change interest floor rate from 7% to 6%",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B21),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B21),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"1217"},"201217","V10.11 201217"]
["John Jiang","2021-01-15","V10.12","Update HEM table according to Sept 2020 quarter data from HEM",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B22),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B22),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0115"},"210115","V10.12 210115"]
["John Jiang","2021-09-15","V10.13","Update HEM table according to 2021 June quarter HEM review data",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B23),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B23),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0915"},{"$f":"RIGHT(YEAR(B23),2)&G23","v":"210915"},{"$f":"CONCATENATE(C23,\" \",H23)","v":"V10.13 210915"}]
["John Jiang","2021-10-27","V10.14","Add a footnote in resi calculator only. ","For Company Borrowers DSR must be >1.10",null,{"$f":"IFERROR(VLOOKUP(MONTH(B24),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B24),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"1027"},{"$f":"RIGHT(YEAR(B24),2)&G24","v":"211027"},{"$f":"CONCATENATE(C24,\" \",H24)","v":"V10.14 211027"}]
["Shun","2022-04-06","V10.15","Add DTI Calculation",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B25),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B25),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0406"},"220406","V10.15 220406"]
["Shun","2022-06-16","V10.16","Update Buffer and Floor Rates  && Add the Total Credit Card Limit values to the Total Debt value && Update HEM Rates Q1 2022",null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B26),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B26),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"0616"},"220616","V10.16 220616"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B27),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B27),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"N/A"},"00N/A"," 00N/A"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B28),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B28),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"N/A"},"00N/A"," 00N/A"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B29),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B29),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"N/A"},"00N/A"," 00N/A"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B30),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B30),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"N/A"},"00N/A"," 00N/A"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B31),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B31),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"N/A"},"00N/A"," 00N/A"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(MONTH(B32),'Day and Months Table'!A:B,2,FALSE)&VLOOKUP(DAY(B32),'Day and Months Table'!A:B,2,FALSE),\"N/A\")","v":"N/A"},"00N/A"," 00N/A"]

{"sheet":"Day and Months Table","index":7,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[1,"01"]
[2,"02"]
[3,"03"]
[4,"04"]
[5,"05"]
[6,"06"]
[7,"07"]
[8,"08"]
[9,"09"]
[10,"10"]
[11,"11"]
[12,"12"]
[13,"13"]
[14,"14"]
[15,"15"]
[16,"16"]
[17,"17"]
[18,"18"]
[19,"19"]
[20,"20"]
[21,"21"]
[22,"22"]
[23,"23"]
[24,"24"]
[25,"25"]
[26,"26"]
[27,"27"]
[28,"28"]
[29,"29"]
[30,"30"]
[31,"31"]