{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Planning Ratios","Support"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"Introduction","index":0,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,8],[3,1,3,8]]}
[]
[null,{"$f":"'Planning Ratios'!B2","v":"Retirement Planning Ratio Forecasts (LT25)"}]
[]
[null,"Personal Finance: Another Perspective"]
[]
[null,"Purpose:"]
[null,"The purpose of this spreadsheet is to give an Excel template for determining where you are in your"]
[null,"progress toward your retirement goals.  Special thanks to Ryan Huling who put"]
[null,"together the idea for this spreadsheet.  It is based on the article from the WSJ by Jonathan"]
[null,"Clements on: \"Ugly Math:  How Soaring Housing Costs are Jeopardizing Retirement Savings,\""]
[null,"March 25, 2005, p. D1.  The article makes some major assumptions which include:  1.  Investors "]
[null,"will earn 5% morethan inflation; 2.  Investors will save 12% of pre-tax income every year"]
[null,"from age 30 to 65; and 3.  Investors will withdraw 5% of portfolio value each year. "]
[]
[null,"Additional Assumptions:"]
[null,"With this spreadsheeet, we assume:  1.  Housing payments are expenses, and investors can handle "]
[null,"up to the recommended 36% of gross salary for housing.  2.  Additional payments to housing "]
[null,"expenses come out of savings.  3.  Individual inputs for assumptions are consistent and achievable. "]
[null,"4.  Tax savings on interest payments are considered part of expenses.  5.  The amount of "]
[null,"retirement savings desired is a multiple of income."]
[]
[null,"Disclosure:"]
[null,"The purpose of this spreadsheet and this class is to help you get your financial house in"]
[null,"order and to help you on your road to financial self-reliance.  If there are mistakes in this "]
[null,"spreadsheet, please bring them to our attention and we will correct them in upcoming "]
[null,"versions.  The teacher, and BYU, specifically disclaim any liability, or responsibility for "]
[null,"claims, loss, or risk incurred, directly or indirectly, from using this material."]

{"sheet":"Planning Ratios","index":1,"n_rows":117,"n_cols":22,"rows_kept":117,"cut":false,"hidden":false,"merged":[[31,10,31,11],[30,10,30,11],[1,1,1,11],[2,1,2,11],[29,7,29,9],[10,2,10,5],[8,2,8,11]]}
[]
[null,"Retirement Planning Ratio Forecasts (LT25)"]
[null,"Personal Finance: Another Perspective"]
[]
[null,"Special thanks to Ryan Huling who put together the idea for this spreadsheet.  It is based on the article from the WSJ by Jonathan Clements on: \"Ugly Math:  How Soaring"]
[null,"Housing Costs are Jeopardizing Retirement Savings,\" March 25, 2005, p. D1.  The article makes some major assumptions which include:  1.  Investors will 5% more"]
[null,"than inflation; 2.  Investors will save 12% of pre-tax income every year from age 30 to 65; and 3.  Investors will withdraw 5% of portfolio value each year.  With our model, "]
[null,"we assume:  1.  Housing payments are expenses; 2. Prepayments are out of savings; and 3.  You can set additional parameters depending on your situation."]
[null,null,"Retirement Planning Ratio Forecasts (LT25)"]
[]
[null,null,"Debt and Income Information"]
[null,null,"Age at beginning of employment",null,null,45,null,"Estiomated Savings and Debt to Income Ratios",null,null,"WSJ Recommended Ratios"]
[null,null,"Starting Income",null,null,82000,null,"Age","Savings","Debt","Savings","Debt"]
[null,null,"Average annual increase in income",null,null,1.4999999999999999E-2,null,25,{"$f":"IF(H14>=Age,VLOOKUP($H14,$B$36:$L$117,10),\"\")","v":""},{"$f":"IF(H14>=Age,VLOOKUP($H14,$B$36:$L$117,11),\"\")","v":""}]
[null,null,"Age at retirement",null,null,65,null,30,{"$f":"IF(H15>=Age,VLOOKUP($H15,$B$36:$L$117,10),\"NA\")","v":"NA"},{"$f":"IF(H15>=Age,VLOOKUP($H15,$B$36:$L$117,11),\"NA\")","v":"NA"},0.1,1.7]
[null,null,"Years in Retirement",null,null,30,null,35,"NA","NA",0.9,1.5]
[null,null,"Number of Working Years",null,null,{"$f":"Age_at_Retirement-F12","v":20},null,40,"NA","NA",1.8,1.25]
[null,null,"Estimated Annuity Rate (in %)",null,null,0.04,null,45,1.602439024390244,1.8623977017421485,3,1]
[null,null,"Estimated Payout Percentage (in %)",null,null,0.04,null,50,3.2786847078756027,1.2168869237250801,4.5,0.75]
[null,null,null,null,null,null,null,55,5.4610444904154827,0.55145967434955734,6.5,0.5]
[null,null,"Annual percent of salary saved",null,null,0.2,null,60,8.3023309840186243,0,8.9,0.2]
[null,null,"Current Savings ",null,null,115000,null,65,12.001495990320286,0,12,0]
[null,null,"Return on Investment",null,null,7.0000000000000007E-2,null,null,null,null,"Note 1","Note 2"]
[null,null,"Assumed inflation rate",null,null,null,null,"Total Savings at Retirement",null,null,"Annuity Pymt","Payout Pymt"]
[null,null,null,null,null,null,null,"Total Savings",null,{"$f":"VLOOKUP(Age_at_Retirement,$B$36:$L$118,5)","v":1325470.5467735683},{"$f":"PMT($F$18,$F$16,J25*-1)","v":76652.093118663746},{"$f":"J25*F19","v":53018.821870942731}]
[null,null,"Age when you purchase(d) home",null,null,30,{"$f":"IF(K31<>\"\",\"Too Much Debt\",\"\")","v":""},"Savings to Income / % of Salary",null,{"$f":"J25/VLOOKUP(Age_at_Retirement,$B$36:$L$117,2)","v":12.001495990320286},{"$f":"K25/VLOOKUP(Age_at_Retirement,$B$37:$T$117,2)","v":0.6940477028724612},{"$f":"L25/VLOOKUP(Age_at_Retirement,$B$37:$T$117,2)","v":0.48005983961281146}]
[null,null,"Cost of the home",null,null,250000,{"$f":"IF(K31<>\"\",\"for Salary\",\"\")","v":""},"Total Inflation-adjusted Savings",null,{"$f":"VLOOKUP(Age_at_Retirement,$B$36:$T$118,15)","v":880456.83358765719},{"$f":"PMT(((1+$F$18)/(1+F24)-1),$F$16,J27*-1)","v":50916.905969283805},{"$f":"J27*0.05","v":44022.841679382866}]
[null,null,"Down Payment",null,null,null,null,"Savings to Income / % of Salary",null,{"$f":"J27/VLOOKUP(Age_at_Retirement,$B$36:$L$117,2)","v":7.9721116275830024},{"$f":"K27/VLOOKUP(Age_at_Retirement,$B$37:$T$117,16)","v":0.4610280057277395},{"$f":"L27/VLOOKUP(Age_at_Retirement,$B$37:$T$117,16)","v":0.3986055813791502}]
[null,null,"Mortgage amount",null,null,{"$f":"F27-F28","v":250000}]
[null,null,"Taxes and Insurance",null,null,3000,null,"As a % of Salary",null,null,"PITI should be less than 36%"]
[null,null,"Mortgage interest rate",null,null,0.04,null,"Mortgage Payment before Prepmt",null,{"$f":"R35","v":0.21289664370018702},{"$f":"IF(J31>0.36,\"Not within Mortgage\",\"\")","v":""}]
[null,null,"Mortgage term",null,null,30,{"$f":"IF(MIN(E37:E117)<0,\"Not Enough\",\"\")","v":""},"Notes:",null,null,{"$f":"IF(J31>0.36,\"Payment Guidelines\",\"\")","v":""}]
[null,null,"Years to pay off loan",null,null,30,{"$f":"IF(MIN(E38:E118)<0,\"Savings to Prepay\",\"\")","v":""},"1.  The annuity payment is calculated based on your estimated annuity rate in F19."]
[null,null,"Assumed growth in home prices ",null,null,0,null,"2.  5% Payout assumes a 5% reduction in total savings per year",null,null,null,null,null,null,null,null,null,"Maximum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(R37:R117)","v":0.21289664370018702}]
[null,"Age","Income","Annual Savings","Net Annual Savings after Prepayment","Total Accumulated Savings","Savings to Extra Home Loan Payment","Standard Home Loan Payment","Standard Home Loan Balance","Loan Balance With additional Payments","Savings to Income Ratio","Debt to Income Ratio",null,null,null,"Inflation Adjusted Savings","Inflation Adjusted Salary","Maximum Payment as a % of Gross Salary (w/o savings)","Year","Value of Mortgage",null,"Savings after Payout"]
[null,{"$f":"F12","v":45},{"$f":"F13","v":82000},{"$f":"C37*Annual_Savings","v":16400},{"$f":"$F$21*C37-G37","v":16400},{"$f":"F22+E37","v":131400},{"$f":"IF(B37>=Support!$A$7,IF(VLOOKUP(B37,Support!$A$4:$F$47,2)>0,VLOOKUP(B37,Support!$A$4:$F$47,3)-Support!$J$7,0),0)","v":0},{"$f":"IF(B37<Support!$H$7,0,VLOOKUP(B37,Support!$H$4:$M$47,3))","v":14457.524783415336},{"$f":"IF(B37>=Support!$H$7,VLOOKUP(B37,Support!$H$4:$M$47,6),0)","v":152716.61154285618},{"$f":"IF(B37<Support!$A$7,0,VLOOKUP(B37,Support!$A$4:$F$47,6))","v":152716.61154285618},{"$f":"IF(C37>0,F37/C37,\"None\")","v":1.602439024390244},{"$f":"IF(C37>0,J37/C37,\"None\")","v":1.8623977017421485},null,null,null,{"$f":"D37","v":16400},{"$f":"C37/(1+$F$24)","v":82000},{"$f":"IF(H37=0,0,(H37+$F$30)/C37)","v":0.21289664370018702},1,{"$f":"IF(ISERR((IF(Support!$A$7=B37,Support!$B$7,IF(T36>0,T36*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B37,Support!$B$7,IF(T36>0,T36*(1+$F$34),0))))","v":""}]
[null,{"$f":"B37+1","v":46},{"$f":"IF(B38<=$F$15,C37*(1+$F$14),0)","v":83229.999999999985},16645.999999999996,{"$f":"$F$21*C38-G38","v":16645.999999999996},{"$f":"(E38+F37)*(1+$F$23)","v":158409.22},{"$f":"IF(B38>=Support!$A$7,IF(VLOOKUP(B38,Support!$A$4:$F$47,2)>0,VLOOKUP(B38,Support!$A$4:$F$47,3)-Support!$J$7,0),0)","v":0},{"$f":"IF(B38<Support!$H$7,0,VLOOKUP(B38,Support!$H$4:$M$47,3))","v":14457.524783415336},{"$f":"IF(B38>=Support!$H$7,VLOOKUP(B38,Support!$H$4:$M$47,6),0)","v":144367.75122115508},{"$f":"IF(B38<Support!$A$7,0,VLOOKUP(B38,Support!$A$4:$F$47,6))","v":144367.75122115508},{"$f":"IF(C38>0,F38/C38,\"None\")","v":1.903270695662622},{"$f":"IF(C38>0,J38/C38,\"None\")","v":1.7345638738574445},null,null,null,{"$f":"(P37+E38)*(1+$F$23)/(1+$F$24)","v":35359.22},{"$f":"C38/(1+$F$24)^(S38)","v":83229.999999999985},{"$f":"IF(B38=\"\",\"\",IF(H38=0,0,(H38+$F$30)/C38))","v":0.20975038788195768},2,{"$f":"IF(ISERR((IF(Support!$A$7=B38,Support!$B$7,IF(T37>0,T37*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B38,Support!$B$7,IF(T37>0,T37*(1+$F$34),0))))","v":""}]
[null,{"$f":"IF(B38=\"\",\"\",IF(B38+1>$F$15+$F$16,\"\",B38+1))","v":47},84478.449999999983,16895.689999999999,{"$f":"IF(B39=\"\",\"\",$F$21*C39-G39)","v":16895.689999999999},{"$f":"IF(B39=\"\",\"\",(E39+F38)*(1+$F$23))","v":187576.2537},{"$f":"IF(B39=\"\",\"\",IF(B39>=Support!$A$7,IF(VLOOKUP(B39,Support!$A$4:$F$47,2)>0,VLOOKUP(B39,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B39=\"\",\"\",IF(B39<Support!$H$7,0,VLOOKUP(B39,Support!$H$4:$M$47,3)))","v":14457.524783415336},{"$f":"IF(B39=\"\",\"\",IF(B39>=Support!$H$7,VLOOKUP(B39,Support!$H$4:$M$47,6),0))","v":135684.93648658594},{"$f":"IF(B39=\"\",\"\",IF(B39<Support!$A$7,0,VLOOKUP(B39,Support!$A$4:$F$47,6)))","v":135684.93648658594},{"$f":"IF(B39=\"\",\"\",IF(C39>0,F39/C39,\"None\"))","v":2.2204035905014834},{"$f":"IF(B39=\"\",\"\",IF(C39>0,J39/C39,\"None\"))","v":1.6061485087212888},null,null,null,55912.753700000008,84478.449999999983,{"$f":"IF(C39=0,\"\",IF(H39=0,0,(H39+$F$30)/C39))","v":0.20665062845513071},3,{"$f":"IF(ISERR((IF(Support!$A$7=B39,Support!$B$7,IF(T38>0,T38*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B39,Support!$B$7,IF(T38>0,T38*(1+$F$34),0))))","v":""}]
[null,48,85745.626749999981,17149.125349999998,17149.125349999998,219056.15558349999,{"$f":"IF(B40=\"\",\"\",IF(B40>=Support!$A$7,IF(VLOOKUP(B40,Support!$A$4:$F$47,2)>0,VLOOKUP(B40,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B40=\"\",\"\",IF(B40<Support!$H$7,0,VLOOKUP(B40,Support!$H$4:$M$47,3)))","v":14457.524783415336},{"$f":"IF(B40=\"\",\"\",IF(B40>=Support!$H$7,VLOOKUP(B40,Support!$H$4:$M$47,6),0))","v":126654.80916263405},{"$f":"IF(B40=\"\",\"\",IF(B40<Support!$A$7,0,VLOOKUP(B40,Support!$A$4:$F$47,6)))","v":126654.80916263405},2.5547210264399873,1.4770993456250416,null,null,null,78176.210583500011,85745.626749999981,0.20359667828091696,4,{"$f":"IF(ISERR((IF(Support!$A$7=B40,Support!$B$7,IF(T39>0,T39*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B40,Support!$B$7,IF(T39>0,T39*(1+$F$34),0))))","v":""}]
[null,49,87031.811151249975,17406.362230249997,17406.362230249997,253014.89406071251,{"$f":"IF(B41=\"\",\"\",IF(B41>=Support!$A$7,IF(VLOOKUP(B41,Support!$A$4:$F$47,2)>0,VLOOKUP(B41,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B41=\"\",\"\",IF(B41<Support!$H$7,0,VLOOKUP(B41,Support!$H$4:$M$47,3)))","v":14457.524783415336},{"$f":"IF(B41=\"\",\"\",IF(B41>=Support!$H$7,VLOOKUP(B41,Support!$H$4:$M$47,6),0))","v":117263.47674572407},{"$f":"IF(B41=\"\",\"\",IF(B41<Support!$A$7,0,VLOOKUP(B41,Support!$A$4:$F$47,6)))","v":117263.47674572407},2.9071541855081646,1.3473633972977466,null,null,null,102273.35291071252,87031.811151249975,0.20058786037528767,5,{"$f":"IF(ISERR((IF(Support!$A$7=B41,Support!$B$7,IF(T40>0,T40*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B41,Support!$B$7,IF(T40>0,T40*(1+$F$34),0))))","v":""}]
[null,50,88337.288318518709,17667.457663703743,17667.457663703743,289630.11634512543,{"$f":"IF(B42=\"\",\"\",IF(B42>=Support!$A$7,IF(VLOOKUP(B42,Support!$A$4:$F$47,2)>0,VLOOKUP(B42,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B42=\"\",\"\",IF(B42<Support!$H$7,0,VLOOKUP(B42,Support!$H$4:$M$47,3)))","v":14457.524783415336},{"$f":"IF(B42=\"\",\"\",IF(B42>=Support!$H$7,VLOOKUP(B42,Support!$H$4:$M$47,6),0))","v":107496.4910321377},{"$f":"IF(B42=\"\",\"\",IF(B42<Support!$A$7,0,VLOOKUP(B42,Support!$A$4:$F$47,6)))","v":107496.4910321377},3.2786847078756027,1.2168869237250801,null,null,null,128336.6673146254,88337.288318518709,0.19762350775890414,6,{"$f":"IF(ISERR((IF(Support!$A$7=B42,Support!$B$7,IF(T41>0,T41*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B42,Support!$B$7,IF(T41>0,T41*(1+$F$34),0))))","v":""}]
[null,51,89662.347643296482,17932.469528659298,17932.469528659298,329091.96688494965,{"$f":"IF(B43=\"\",\"\",IF(B43>=Support!$A$7,IF(VLOOKUP(B43,Support!$A$4:$F$47,2)>0,VLOOKUP(B43,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B43=\"\",\"\",IF(B43<Support!$H$7,0,VLOOKUP(B43,Support!$H$4:$M$47,3)))","v":14457.524783415336},{"$f":"IF(B43=\"\",\"\",IF(B43>=Support!$H$7,VLOOKUP(B43,Support!$H$4:$M$47,6),0))","v":97338.825890007865},{"$f":"IF(B43=\"\",\"\",IF(B43<Support!$A$7,0,VLOOKUP(B43,Support!$A$4:$F$47,6)))","v":97338.825890007865},3.6703474260363502,1.0856154054458924,null,null,null,156507.97642231465,89662.347643296482,0.19470296330926518,7,{"$f":"IF(ISERR((IF(Support!$A$7=B43,Support!$B$7,IF(T42>0,T42*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B43,Support!$B$7,IF(T42>0,T42*(1+$F$34),0))))","v":""},null,{"$f":"IF(C43=\"\",0)","v":false}]
[null,52,91007.282857945916,18201.456571589184,18201.456571589184,371603.96309849655,{"$f":"IF(B44=\"\",\"\",IF(B44>=Support!$A$7,IF(VLOOKUP(B44,Support!$A$4:$F$47,2)>0,VLOOKUP(B44,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B44=\"\",\"\",IF(B44<Support!$H$7,0,VLOOKUP(B44,Support!$H$4:$M$47,3)))","v":14457.524783415336},{"$f":"IF(B44=\"\",\"\",IF(B44>=Support!$H$7,VLOOKUP(B44,Support!$H$4:$M$47,6),0))","v":86774.854142192838},{"$f":"IF(B44=\"\",\"\",IF(B44<Support!$A$7,0,VLOOKUP(B44,Support!$A$4:$F$47,6)))","v":86774.854142192838},4.0832332471516208,0.95349351631166146,null,null,null,186939.09330347713,91007.282857945916,0.19182557961503963,8,{"$f":"IF(ISERR((IF(Support!$A$7=B44,Support!$B$7,IF(T43>0,T43*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B44,Support!$B$7,IF(T43>0,T43*(1+$F$34),0))))","v":""}]
[null,53,92372.392100815094,18474.478420163021,18474.478420163021,417383.93242496578,{"$f":"IF(B45=\"\",\"\",IF(B45>=Support!$A$7,IF(VLOOKUP(B45,Support!$A$4:$F$47,2)>0,VLOOKUP(B45,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B45=\"\",\"\",IF(B45<Support!$H$7,0,VLOOKUP(B45,Support!$H$4:$M$47,3)))","v":14457.524783415336},{"$f":"IF(B45=\"\",\"\",IF(B45>=Support!$H$7,VLOOKUP(B45,Support!$H$4:$M$47,6),0))","v":75788.323524465217},{"$f":"IF(B45=\"\",\"\",IF(B45<Support!$A$7,0,VLOOKUP(B45,Support!$A$4:$F$47,6)))","v":75788.323524465217},4.5184921915785567,0.8204650956938514,null,null,null,219792.52174429497,92372.392100815094,0.18899071883255136,9,{"$f":"IF(ISERR((IF(Support!$A$7=B45,Support!$B$7,IF(T44>0,T44*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B45,Support!$B$7,IF(T44>0,T44*(1+$F$34),0))))","v":""}]
[null,54,93757.977982327313,18751.595596465464,18751.595596465464,466665.01498293143,{"$f":"IF(B46=\"\",\"\",IF(B46>=Support!$A$7,IF(VLOOKUP(B46,Support!$A$4:$F$47,2)>0,VLOOKUP(B46,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B46=\"\",\"\",IF(B46<Support!$H$7,0,VLOOKUP(B46,Support!$H$4:$M$47,3)))","v":14457.524783415336},{"$f":"IF(B46=\"\",\"\",IF(B46>=Support!$H$7,VLOOKUP(B46,Support!$H$4:$M$47,6),0))","v":64362.331682028489},{"$f":"IF(B46=\"\",\"\",IF(B46<Support!$A$7,0,VLOOKUP(B46,Support!$A$4:$F$47,6)))","v":64362.331682028489},4.9773365960483318,0.68647312012381834,null,null,null,255242.20555461367,93757.977982327313,0.18619775254438559,10,{"$f":"IF(ISERR((IF(Support!$A$7=B46,Support!$B$7,IF(T45>0,T45*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B46,Support!$B$7,IF(T45>0,T45*(1+$F$34),0))))","v":""}]
[null,55,95164.347652062221,19032.869530412445,19032.869530412445,519696.73642927798,{"$f":"IF(B47=\"\",\"\",IF(B47>=Support!$A$7,IF(VLOOKUP(B47,Support!$A$4:$F$47,2)>0,VLOOKUP(B47,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B47=\"\",\"\",IF(B47<Support!$H$7,0,VLOOKUP(B47,Support!$H$4:$M$47,3)))","v":14457.524783415336},{"$f":"IF(B47=\"\",\"\",IF(B47>=Support!$H$7,VLOOKUP(B47,Support!$H$4:$M$47,6),0))","v":52479.300165894296},{"$f":"IF(B47=\"\",\"\",IF(B47<Support!$A$7,0,VLOOKUP(B47,Support!$A$4:$F$47,6)))","v":52479.300165894296},5.4610444904154827,0.55145967434955734,null,null,null,293474.33034097793,95164.347652062221,0.18344606162008434,11,{"$f":"IF(ISERR((IF(Support!$A$7=B47,Support!$B$7,IF(T46>0,T46*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B47,Support!$B$7,IF(T46>0,T46*(1+$F$34),0))))","v":""}]
[null,56,96591.812866843145,19318.362573368631,19318.362573368631,576746.15593283193,{"$f":"IF(B48=\"\",\"\",IF(B48>=Support!$A$7,IF(VLOOKUP(B48,Support!$A$4:$F$47,2)>0,VLOOKUP(B48,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B48=\"\",\"\",IF(B48<Support!$H$7,0,VLOOKUP(B48,Support!$H$4:$M$47,3)))","v":14457.524783415336},{"$f":"IF(B48=\"\",\"\",IF(B48>=Support!$H$7,VLOOKUP(B48,Support!$H$4:$M$47,6),0))","v":40120.947389114735},{"$f":"IF(B48=\"\",\"\",IF(B48<Support!$A$7,0,VLOOKUP(B48,Support!$A$4:$F$47,6)))","v":40120.947389114735},5.9709631573838102,0.41536592179322235,null,null,null,334688.18141835084,96591.812866843145,0.18073503607890085,12,{"$f":"IF(ISERR((IF(Support!$A$7=B48,Support!$B$7,IF(T47>0,T47*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B48,Support!$B$7,IF(T47>0,T47*(1+$F$34),0))))","v":""}]
[null,57,98040.690059845787,19608.138011969157,19608.138011969157,638099.09452093719,{"$f":"IF(B49=\"\",\"\",IF(B49>=Support!$A$7,IF(VLOOKUP(B49,Support!$A$4:$F$47,2)>0,VLOOKUP(B49,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B49=\"\",\"\",IF(B49<Support!$H$7,0,VLOOKUP(B49,Support!$H$4:$M$47,3)))","v":14457.524783415336},{"$f":"IF(B49=\"\",\"\",IF(B49>=Support!$H$7,VLOOKUP(B49,Support!$H$4:$M$47,6),0))","v":27268.260501263991},{"$f":"IF(B49=\"\",\"\",IF(B49<Support!$A$7,0,VLOOKUP(B49,Support!$A$4:$F$47,6)))","v":27268.260501263991},6.508512885123821,0.27813207439297866,null,null,null,379097.06179044244,98040.690059845787,0.17806407495458212,13,{"$f":"IF(ISERR((IF(Support!$A$7=B49,Support!$B$7,IF(T48>0,T48*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B49,Support!$B$7,IF(T48>0,T48*(1+$F$34),0))))","v":""}]
[null,58,99511.300410743468,19902.260082148696,19902.260082148696,704061.44942530198,{"$f":"IF(B50=\"\",\"\",IF(B50>=Support!$A$7,IF(VLOOKUP(B50,Support!$A$4:$F$47,2)>0,VLOOKUP(B50,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B50=\"\",\"\",IF(B50<Support!$H$7,0,VLOOKUP(B50,Support!$H$4:$M$47,3)))","v":14457.524783415336},{"$f":"IF(B50=\"\",\"\",IF(B50>=Support!$H$7,VLOOKUP(B50,Support!$H$4:$M$47,6),0))","v":13901.466137899213},{"$f":"IF(B50=\"\",\"\",IF(B50<Support!$A$7,0,VLOOKUP(B50,Support!$A$4:$F$47,6)))","v":13901.466137899213},7.07519092323398,0.13969736181237141,null,null,null,426929.27440367255,99511.300410743468,0.17543258616214988,14,{"$f":"IF(ISERR((IF(Support!$A$7=B50,Support!$B$7,IF(T49>0,T49*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B50,Support!$B$7,IF(T49>0,T49*(1+$F$34),0))))","v":""}]
[null,59,101003.96991690461,20200.793983380921,20200.793983381074,774960.60044729093,{"$f":"IF(B51=\"\",\"\",IF(B51>=Support!$A$7,IF(VLOOKUP(B51,Support!$A$4:$F$47,2)>0,VLOOKUP(B51,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":-1.546140993013978E-10},{"$f":"IF(B51=\"\",\"\",IF(B51<Support!$H$7,0,VLOOKUP(B51,Support!$H$4:$M$47,3)))","v":14457.524783415181},{"$f":"IF(B51=\"\",\"\",IF(B51>=Support!$H$7,VLOOKUP(B51,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B51=\"\",\"\",IF(B51<Support!$A$7,0,VLOOKUP(B51,Support!$A$4:$F$47,6)))","v":0},7.6725756530643956,0,null,null,null,478429.17317414738,101003.96991690461,0.17283998636664863,15,{"$f":"IF(ISERR((IF(Support!$A$7=B51,Support!$B$7,IF(T50>0,T50*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B51,Support!$B$7,IF(T50>0,T50*(1+$F$34),0))))","v":""}]
[null,60,102519.02946565817,20503.805893131634,20503.805893131634,851146.91478425218,{"$f":"IF(B52=\"\",\"\",IF(B52>=Support!$A$7,IF(VLOOKUP(B52,Support!$A$4:$F$47,2)>0,VLOOKUP(B52,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B52=\"\",\"\",IF(B52<Support!$H$7,0,VLOOKUP(B52,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B52=\"\",\"\",IF(B52>=Support!$H$7,VLOOKUP(B52,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B52=\"\",\"\",IF(B52<Support!$A$7,0,VLOOKUP(B52,Support!$A$4:$F$47,6)))","v":0},8.3023309840186243,0,null,null,null,533858.28760198865,102519.02946565817,0,16,{"$f":"IF(ISERR((IF(Support!$A$7=B52,Support!$B$7,IF(T51>0,T51*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B52,Support!$B$7,IF(T51>0,T51*(1+$F$34),0))))","v":""}]
[null,61,104056.81490764303,20811.362981528608,20811.362981528608,932995.35720938549,{"$f":"IF(B53=\"\",\"\",IF(B53>=Support!$A$7,IF(VLOOKUP(B53,Support!$A$4:$F$47,2)>0,VLOOKUP(B53,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B53=\"\",\"\",IF(B53<Support!$H$7,0,VLOOKUP(B53,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B53=\"\",\"\",IF(B53>=Support!$H$7,VLOOKUP(B53,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B53=\"\",\"\",IF(B53<Support!$A$7,0,VLOOKUP(B53,Support!$A$4:$F$47,6)))","v":0},8.9662109880787497,0,null,null,null,593496.52612436353,104056.81490764303,0,17,{"$f":"IF(ISERR((IF(Support!$A$7=B53,Support!$B$7,IF(T52>0,T52*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B53,Support!$B$7,IF(T52>0,T52*(1+$F$34),0))))","v":""}]
[null,62,105617.66713125767,21123.533426251535,21123.533426251535,1020907.2129801316,{"$f":"IF(B54=\"\",\"\",IF(B54>=Support!$A$7,IF(VLOOKUP(B54,Support!$A$4:$F$47,2)>0,VLOOKUP(B54,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B54=\"\",\"\",IF(B54<Support!$H$7,0,VLOOKUP(B54,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B54=\"\",\"\",IF(B54>=Support!$H$7,VLOOKUP(B54,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B54=\"\",\"\",IF(B54<Support!$A$7,0,VLOOKUP(B54,Support!$A$4:$F$47,6)))","v":0},9.6660647854623267,0,null,null,null,657643.46371915808,105617.66713125767,0,18,{"$f":"IF(ISERR((IF(Support!$A$7=B54,Support!$B$7,IF(T53>0,T53*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B54,Support!$B$7,IF(T53>0,T53*(1+$F$34),0))))","v":""}]
[null,63,107201.93213822652,21440.386427645306,21440.386427645306,1115311.9313663214,{"$f":"IF(B55=\"\",\"\",IF(B55>=Support!$A$7,IF(VLOOKUP(B55,Support!$A$4:$F$47,2)>0,VLOOKUP(B55,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B55=\"\",\"\",IF(B55<Support!$H$7,0,VLOOKUP(B55,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B55=\"\",\"\",IF(B55>=Support!$H$7,VLOOKUP(B55,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B55=\"\",\"\",IF(B55<Support!$A$7,0,VLOOKUP(B55,Support!$A$4:$F$47,6)))","v":0},10.403841695019402,0,null,null,null,726619.71965707967,107201.93213822652,0,19,{"$f":"IF(ISERR((IF(Support!$A$7=B55,Support!$B$7,IF(T54>0,T54*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B55,Support!$B$7,IF(T54>0,T54*(1+$F$34),0))))","v":""}]
[null,64,108809.96112029991,21761.992224059984,21761.992224059984,1216669.0982417082,{"$f":"IF(B56=\"\",\"\",IF(B56>=Support!$A$7,IF(VLOOKUP(B56,Support!$A$4:$F$47,2)>0,VLOOKUP(B56,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B56=\"\",\"\",IF(B56<Support!$H$7,0,VLOOKUP(B56,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B56=\"\",\"\",IF(B56>=Support!$H$7,VLOOKUP(B56,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B56=\"\",\"\",IF(B56<Support!$A$7,0,VLOOKUP(B56,Support!$A$4:$F$47,6)))","v":0},11.181596663715036,0,null,null,null,800768.4317128195,108809.96112029991,0,20,{"$f":"IF(ISERR((IF(Support!$A$7=B56,Support!$B$7,IF(T55>0,T55*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B56,Support!$B$7,IF(T55>0,T55*(1+$F$34),0))))","v":""}]
[null,65,110442.1105371044,22088.42210742088,22088.42210742088,1325470.5467735683,{"$f":"IF(B57=\"\",\"\",IF(B57>=Support!$A$7,IF(VLOOKUP(B57,Support!$A$4:$F$47,2)>0,VLOOKUP(B57,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B57=\"\",\"\",IF(B57<Support!$H$7,0,VLOOKUP(B57,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B57=\"\",\"\",IF(B57>=Support!$H$7,VLOOKUP(B57,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B57=\"\",\"\",IF(B57<Support!$A$7,0,VLOOKUP(B57,Support!$A$4:$F$47,6)))","v":0},12.001495990320286,0,null,null,null,880456.83358765719,110442.1105371044,0,21,{"$f":"IF(ISERR((IF(Support!$A$7=B57,Support!$B$7,IF(T56>0,T56*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B57,Support!$B$7,IF(T56>0,T56*(1+$F$34),0))))","v":""}]
[null,66,0,0,0,1418253.485047718,{"$f":"IF(B58=\"\",\"\",IF(B58>=Support!$A$7,IF(VLOOKUP(B58,Support!$A$4:$F$47,2)>0,VLOOKUP(B58,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B58=\"\",\"\",IF(B58<Support!$H$7,0,VLOOKUP(B58,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B58=\"\",\"\",IF(B58>=Support!$H$7,VLOOKUP(B58,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B58=\"\",\"\",IF(B58<Support!$A$7,0,VLOOKUP(B58,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,942088.81193879328,0,"",22,{"$f":"IF(ISERR((IF(Support!$A$7=B58,Support!$B$7,IF(T57>0,T57*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B58,Support!$B$7,IF(T57>0,T57*(1+$F$34),0))))","v":""}]
[null,67,0,0,0,1517531.2290010585,{"$f":"IF(B59=\"\",\"\",IF(B59>=Support!$A$7,IF(VLOOKUP(B59,Support!$A$4:$F$47,2)>0,VLOOKUP(B59,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B59=\"\",\"\",IF(B59<Support!$H$7,0,VLOOKUP(B59,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B59=\"\",\"\",IF(B59>=Support!$H$7,VLOOKUP(B59,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B59=\"\",\"\",IF(B59<Support!$A$7,0,VLOOKUP(B59,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,1008035.0287745089,0,"",23,{"$f":"IF(ISERR((IF(Support!$A$7=B59,Support!$B$7,IF(T58>0,T58*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B59,Support!$B$7,IF(T58>0,T58*(1+$F$34),0))))","v":""}]
[null,68,0,0,0,1623758.4150311328,{"$f":"IF(B60=\"\",\"\",IF(B60>=Support!$A$7,IF(VLOOKUP(B60,Support!$A$4:$F$47,2)>0,VLOOKUP(B60,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B60=\"\",\"\",IF(B60<Support!$H$7,0,VLOOKUP(B60,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B60=\"\",\"\",IF(B60>=Support!$H$7,VLOOKUP(B60,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B60=\"\",\"\",IF(B60<Support!$A$7,0,VLOOKUP(B60,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,1078597.4807887245,0,"",24,{"$f":"IF(ISERR((IF(Support!$A$7=B60,Support!$B$7,IF(T59>0,T59*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B60,Support!$B$7,IF(T59>0,T59*(1+$F$34),0))))","v":""}]
[null,69,0,0,0,1737421.5040833121,{"$f":"IF(B61=\"\",\"\",IF(B61>=Support!$A$7,IF(VLOOKUP(B61,Support!$A$4:$F$47,2)>0,VLOOKUP(B61,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B61=\"\",\"\",IF(B61<Support!$H$7,0,VLOOKUP(B61,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B61=\"\",\"\",IF(B61>=Support!$H$7,VLOOKUP(B61,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B61=\"\",\"\",IF(B61<Support!$A$7,0,VLOOKUP(B61,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,1154099.3044439352,0,"",25,{"$f":"IF(ISERR((IF(Support!$A$7=B61,Support!$B$7,IF(T60>0,T60*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B61,Support!$B$7,IF(T60>0,T60*(1+$F$34),0))))","v":""}]
[null,70,0,0,0,1859041.009369144,{"$f":"IF(B62=\"\",\"\",IF(B62>=Support!$A$7,IF(VLOOKUP(B62,Support!$A$4:$F$47,2)>0,VLOOKUP(B62,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B62=\"\",\"\",IF(B62<Support!$H$7,0,VLOOKUP(B62,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B62=\"\",\"\",IF(B62>=Support!$H$7,VLOOKUP(B62,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B62=\"\",\"\",IF(B62<Support!$A$7,0,VLOOKUP(B62,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,1234886.2557550108,0,"",26,{"$f":"IF(ISERR((IF(Support!$A$7=B62,Support!$B$7,IF(T61>0,T61*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B62,Support!$B$7,IF(T61>0,T61*(1+$F$34),0))))","v":""}]
[null,71,0,0,0,1989173.8800249842,{"$f":"IF(B63=\"\",\"\",IF(B63>=Support!$A$7,IF(VLOOKUP(B63,Support!$A$4:$F$47,2)>0,VLOOKUP(B63,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B63=\"\",\"\",IF(B63<Support!$H$7,0,VLOOKUP(B63,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B63=\"\",\"\",IF(B63>=Support!$H$7,VLOOKUP(B63,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B63=\"\",\"\",IF(B63<Support!$A$7,0,VLOOKUP(B63,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,1321328.2936578616,0,"",27,{"$f":"IF(ISERR((IF(Support!$A$7=B63,Support!$B$7,IF(T62>0,T62*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B63,Support!$B$7,IF(T62>0,T62*(1+$F$34),0))))","v":""}]
[null,72,0,0,0,2128416.051626733,{"$f":"IF(B64=\"\",\"\",IF(B64>=Support!$A$7,IF(VLOOKUP(B64,Support!$A$4:$F$47,2)>0,VLOOKUP(B64,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B64=\"\",\"\",IF(B64<Support!$H$7,0,VLOOKUP(B64,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B64=\"\",\"\",IF(B64>=Support!$H$7,VLOOKUP(B64,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B64=\"\",\"\",IF(B64<Support!$A$7,0,VLOOKUP(B64,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,1413821.274213912,0,"",28,{"$f":"IF(ISERR((IF(Support!$A$7=B64,Support!$B$7,IF(T63>0,T63*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B64,Support!$B$7,IF(T63>0,T63*(1+$F$34),0))))","v":""}]
[null,73,0,0,0,2277405.1752406047,{"$f":"IF(B65=\"\",\"\",IF(B65>=Support!$A$7,IF(VLOOKUP(B65,Support!$A$4:$F$47,2)>0,VLOOKUP(B65,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B65=\"\",\"\",IF(B65<Support!$H$7,0,VLOOKUP(B65,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B65=\"\",\"\",IF(B65>=Support!$H$7,VLOOKUP(B65,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B65=\"\",\"\",IF(B65<Support!$A$7,0,VLOOKUP(B65,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,1512788.7634088858,0,"",29,{"$f":"IF(ISERR((IF(Support!$A$7=B65,Support!$B$7,IF(T64>0,T64*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B65,Support!$B$7,IF(T64>0,T64*(1+$F$34),0))))","v":""}]
[null,74,0,0,0,2436823.5375074469,{"$f":"IF(B66=\"\",\"\",IF(B66>=Support!$A$7,IF(VLOOKUP(B66,Support!$A$4:$F$47,2)>0,VLOOKUP(B66,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B66=\"\",\"\",IF(B66<Support!$H$7,0,VLOOKUP(B66,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B66=\"\",\"\",IF(B66>=Support!$H$7,VLOOKUP(B66,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B66=\"\",\"\",IF(B66<Support!$A$7,0,VLOOKUP(B66,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,1618683.976847508,0,"",30,{"$f":"IF(ISERR((IF(Support!$A$7=B66,Support!$B$7,IF(T65>0,T65*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B66,Support!$B$7,IF(T65>0,T65*(1+$F$34),0))))","v":""}]
[null,75,0,0,0,2607401.1851329682,{"$f":"IF(B67=\"\",\"\",IF(B67>=Support!$A$7,IF(VLOOKUP(B67,Support!$A$4:$F$47,2)>0,VLOOKUP(B67,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B67=\"\",\"\",IF(B67<Support!$H$7,0,VLOOKUP(B67,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B67=\"\",\"\",IF(B67>=Support!$H$7,VLOOKUP(B67,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B67=\"\",\"\",IF(B67<Support!$A$7,0,VLOOKUP(B67,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,1731991.8552268336,0,"",31,{"$f":"IF(ISERR((IF(Support!$A$7=B67,Support!$B$7,IF(T66>0,T66*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B67,Support!$B$7,IF(T66>0,T66*(1+$F$34),0))))","v":""}]
[null,76,0,0,0,2789919.2680922761,{"$f":"IF(B68=\"\",\"\",IF(B68>=Support!$A$7,IF(VLOOKUP(B68,Support!$A$4:$F$47,2)>0,VLOOKUP(B68,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B68=\"\",\"\",IF(B68<Support!$H$7,0,VLOOKUP(B68,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B68=\"\",\"\",IF(B68>=Support!$H$7,VLOOKUP(B68,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B68=\"\",\"\",IF(B68<Support!$A$7,0,VLOOKUP(B68,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,1853231.2850927121,0,"",32,{"$f":"IF(ISERR((IF(Support!$A$7=B68,Support!$B$7,IF(T67>0,T67*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B68,Support!$B$7,IF(T67>0,T67*(1+$F$34),0))))","v":""}]
[null,77,0,0,0,2985213.6168587357,{"$f":"IF(B69=\"\",\"\",IF(B69>=Support!$A$7,IF(VLOOKUP(B69,Support!$A$4:$F$47,2)>0,VLOOKUP(B69,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B69=\"\",\"\",IF(B69<Support!$H$7,0,VLOOKUP(B69,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B69=\"\",\"\",IF(B69>=Support!$H$7,VLOOKUP(B69,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B69=\"\",\"\",IF(B69<Support!$A$7,0,VLOOKUP(B69,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,1982957.4750492021,0,"",33,{"$f":"IF(ISERR((IF(Support!$A$7=B69,Support!$B$7,IF(T68>0,T68*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B69,Support!$B$7,IF(T68>0,T68*(1+$F$34),0))))","v":""}]
[null,78,{"$f":"IF(B70<=$F$15,C69*(1+$F$14),0)","v":0},0,0,3194178.5700388472,{"$f":"IF(B70=\"\",\"\",IF(B70>=Support!$A$7,IF(VLOOKUP(B70,Support!$A$4:$F$47,2)>0,VLOOKUP(B70,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B70=\"\",\"\",IF(B70<Support!$H$7,0,VLOOKUP(B70,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B70=\"\",\"\",IF(B70>=Support!$H$7,VLOOKUP(B70,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B70=\"\",\"\",IF(B70<Support!$A$7,0,VLOOKUP(B70,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,{"$f":"(P69+E70)*(1+$F$23)/(1+$F$24)","v":2121764.4983026464},{"$f":"C70/(1+$F$24)^(S70)","v":0},"",34,{"$f":"IF(ISERR((IF(Support!$A$7=B70,Support!$B$7,IF(T69>0,T69*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B70,Support!$B$7,IF(T69>0,T69*(1+$F$34),0))))","v":""}]
[null,{"$f":"IF(B70=\"\",\"\",IF(B70+1>$F$15+$F$16,\"\",B70+1))","v":79},0,0,{"$f":"IF(B71=\"\",\"\",$F$21*C71-G71)","v":0},{"$f":"IF(B71=\"\",\"\",(E71+F70)*(1+$F$23))","v":3417771.0699415668},{"$f":"IF(B71=\"\",\"\",IF(B71>=Support!$A$7,IF(VLOOKUP(B71,Support!$A$4:$F$47,2)>0,VLOOKUP(B71,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B71=\"\",\"\",IF(B71<Support!$H$7,0,VLOOKUP(B71,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B71=\"\",\"\",IF(B71>=Support!$H$7,VLOOKUP(B71,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B71=\"\",\"\",IF(B71<Support!$A$7,0,VLOOKUP(B71,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,2270288.0131838317,0,{"$f":"IF(C71=0,\"\",IF(H71=0,0,(H71+$F$30)/C71))","v":""},35,{"$f":"IF(ISERR((IF(Support!$A$7=B71,Support!$B$7,IF(T70>0,T70*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B71,Support!$B$7,IF(T70>0,T70*(1+$F$34),0))))","v":""}]
[null,80,0,0,0,3657015.0448374767,{"$f":"IF(B72=\"\",\"\",IF(B72>=Support!$A$7,IF(VLOOKUP(B72,Support!$A$4:$F$47,2)>0,VLOOKUP(B72,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B72=\"\",\"\",IF(B72<Support!$H$7,0,VLOOKUP(B72,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B72=\"\",\"\",IF(B72>=Support!$H$7,VLOOKUP(B72,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B72=\"\",\"\",IF(B72<Support!$A$7,0,VLOOKUP(B72,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,2429208.1741066999,0,"",36,{"$f":"IF(ISERR((IF(Support!$A$7=B72,Support!$B$7,IF(T71>0,T71*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B72,Support!$B$7,IF(T71>0,T71*(1+$F$34),0))))","v":""}]
[null,81,0,0,0,3913006.0979761002,{"$f":"IF(B73=\"\",\"\",IF(B73>=Support!$A$7,IF(VLOOKUP(B73,Support!$A$4:$F$47,2)>0,VLOOKUP(B73,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B73=\"\",\"\",IF(B73<Support!$H$7,0,VLOOKUP(B73,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B73=\"\",\"\",IF(B73>=Support!$H$7,VLOOKUP(B73,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B73=\"\",\"\",IF(B73<Support!$A$7,0,VLOOKUP(B73,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,2599252.7462941692,0,"",37,{"$f":"IF(ISERR((IF(Support!$A$7=B73,Support!$B$7,IF(T72>0,T72*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B73,Support!$B$7,IF(T72>0,T72*(1+$F$34),0))))","v":""}]
[null,82,0,0,0,4186916.5248344275,{"$f":"IF(B74=\"\",\"\",IF(B74>=Support!$A$7,IF(VLOOKUP(B74,Support!$A$4:$F$47,2)>0,VLOOKUP(B74,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B74=\"\",\"\",IF(B74<Support!$H$7,0,VLOOKUP(B74,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B74=\"\",\"\",IF(B74>=Support!$H$7,VLOOKUP(B74,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B74=\"\",\"\",IF(B74<Support!$A$7,0,VLOOKUP(B74,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,2781200.4385347613,0,"",38,{"$f":"IF(ISERR((IF(Support!$A$7=B74,Support!$B$7,IF(T73>0,T73*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B74,Support!$B$7,IF(T73>0,T73*(1+$F$34),0))))","v":""}]
[null,83,0,0,0,4480000.6815728378,{"$f":"IF(B75=\"\",\"\",IF(B75>=Support!$A$7,IF(VLOOKUP(B75,Support!$A$4:$F$47,2)>0,VLOOKUP(B75,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B75=\"\",\"\",IF(B75<Support!$H$7,0,VLOOKUP(B75,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B75=\"\",\"\",IF(B75>=Support!$H$7,VLOOKUP(B75,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B75=\"\",\"\",IF(B75<Support!$A$7,0,VLOOKUP(B75,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,2975884.4692321946,0,"",39,{"$f":"IF(ISERR((IF(Support!$A$7=B75,Support!$B$7,IF(T74>0,T74*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B75,Support!$B$7,IF(T74>0,T74*(1+$F$34),0))))","v":""}]
[null,84,0,0,0,4793600.729282937,{"$f":"IF(B76=\"\",\"\",IF(B76>=Support!$A$7,IF(VLOOKUP(B76,Support!$A$4:$F$47,2)>0,VLOOKUP(B76,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B76=\"\",\"\",IF(B76<Support!$H$7,0,VLOOKUP(B76,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B76=\"\",\"\",IF(B76>=Support!$H$7,VLOOKUP(B76,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B76=\"\",\"\",IF(B76<Support!$A$7,0,VLOOKUP(B76,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,3184196.3820784483,0,"",40,{"$f":"IF(ISERR((IF(Support!$A$7=B76,Support!$B$7,IF(T75>0,T75*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B76,Support!$B$7,IF(T75>0,T75*(1+$F$34),0))))","v":""}]
[null,85,0,0,0,5129152.7803327432,{"$f":"IF(B77=\"\",\"\",IF(B77>=Support!$A$7,IF(VLOOKUP(B77,Support!$A$4:$F$47,2)>0,VLOOKUP(B77,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B77=\"\",\"\",IF(B77<Support!$H$7,0,VLOOKUP(B77,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B77=\"\",\"\",IF(B77>=Support!$H$7,VLOOKUP(B77,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B77=\"\",\"\",IF(B77<Support!$A$7,0,VLOOKUP(B77,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,3407090.1288239397,0,"",41,{"$f":"IF(ISERR((IF(Support!$A$7=B77,Support!$B$7,IF(T76>0,T76*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B77,Support!$B$7,IF(T76>0,T76*(1+$F$34),0))))","v":""}]
[null,86,0,{"$f":"C78*Annual_Savings","v":0},0,5488193.4749560356,{"$f":"IF(B78=\"\",\"\",IF(B78>=Support!$A$7,IF(VLOOKUP(B78,Support!$A$4:$F$47,2)>0,VLOOKUP(B78,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B78=\"\",\"\",IF(B78<Support!$H$7,0,VLOOKUP(B78,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B78=\"\",\"\",IF(B78>=Support!$H$7,VLOOKUP(B78,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B78=\"\",\"\",IF(B78<Support!$A$7,0,VLOOKUP(B78,Support!$A$4:$F$47,6)))","v":0},{"$f":"IF(B78=\"\",\"\",IF(C78>0,F78/C78,\"None\"))","v":"None"},{"$f":"IF(B78=\"\",\"\",IF(C78>0,J78/C78,\"None\"))","v":"None"},null,null,null,3645586.4378416156,0,"",42,{"$f":"IF(ISERR((IF(Support!$A$7=B78,Support!$B$7,IF(T77>0,T77*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B78,Support!$B$7,IF(T77>0,T77*(1+$F$34),0))))","v":""}]
[null,87,0,0,0,5872367.0182029586,{"$f":"IF(B79=\"\",\"\",IF(B79>=Support!$A$7,IF(VLOOKUP(B79,Support!$A$4:$F$47,2)>0,VLOOKUP(B79,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B79=\"\",\"\",IF(B79<Support!$H$7,0,VLOOKUP(B79,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B79=\"\",\"\",IF(B79>=Support!$H$7,VLOOKUP(B79,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B79=\"\",\"\",IF(B79<Support!$A$7,0,VLOOKUP(B79,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,3900777.4884905289,0,"",43,{"$f":"IF(ISERR((IF(Support!$A$7=B79,Support!$B$7,IF(T78>0,T78*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B79,Support!$B$7,IF(T78>0,T78*(1+$F$34),0))))","v":""}]
[null,88,0,0,0,6283432.7094771657,{"$f":"IF(B80=\"\",\"\",IF(B80>=Support!$A$7,IF(VLOOKUP(B80,Support!$A$4:$F$47,2)>0,VLOOKUP(B80,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B80=\"\",\"\",IF(B80<Support!$H$7,0,VLOOKUP(B80,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B80=\"\",\"\",IF(B80>=Support!$H$7,VLOOKUP(B80,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B80=\"\",\"\",IF(B80<Support!$A$7,0,VLOOKUP(B80,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,4173831.9126848662,0,"",44,{"$f":"IF(ISERR((IF(Support!$A$7=B80,Support!$B$7,IF(T79>0,T79*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B80,Support!$B$7,IF(T79>0,T79*(1+$F$34),0))))","v":""}]
[null,89,0,0,0,6723272.9991405681,{"$f":"IF(B81=\"\",\"\",IF(B81>=Support!$A$7,IF(VLOOKUP(B81,Support!$A$4:$F$47,2)>0,VLOOKUP(B81,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B81=\"\",\"\",IF(B81<Support!$H$7,0,VLOOKUP(B81,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B81=\"\",\"\",IF(B81>=Support!$H$7,VLOOKUP(B81,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B81=\"\",\"\",IF(B81<Support!$A$7,0,VLOOKUP(B81,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,4466000.1465728069,0,"",45,{"$f":"IF(ISERR((IF(Support!$A$7=B81,Support!$B$7,IF(T80>0,T80*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B81,Support!$B$7,IF(T80>0,T80*(1+$F$34),0))))","v":""}]
[null,90,0,0,0,7193902.1090804087,{"$f":"IF(B82=\"\",\"\",IF(B82>=Support!$A$7,IF(VLOOKUP(B82,Support!$A$4:$F$47,2)>0,VLOOKUP(B82,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B82=\"\",\"\",IF(B82<Support!$H$7,0,VLOOKUP(B82,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B82=\"\",\"\",IF(B82>=Support!$H$7,VLOOKUP(B82,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B82=\"\",\"\",IF(B82<Support!$A$7,0,VLOOKUP(B82,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,4778620.1568329036,0,"",46,{"$f":"IF(ISERR((IF(Support!$A$7=B82,Support!$B$7,IF(T81>0,T81*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B82,Support!$B$7,IF(T81>0,T81*(1+$F$34),0))))","v":""}]
[null,91,0,0,0,7697475.2567160381,{"$f":"IF(B83=\"\",\"\",IF(B83>=Support!$A$7,IF(VLOOKUP(B83,Support!$A$4:$F$47,2)>0,VLOOKUP(B83,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B83=\"\",\"\",IF(B83<Support!$H$7,0,VLOOKUP(B83,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B83=\"\",\"\",IF(B83>=Support!$H$7,VLOOKUP(B83,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B83=\"\",\"\",IF(B83<Support!$A$7,0,VLOOKUP(B83,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,5113123.5678112069,0,"",47,{"$f":"IF(ISERR((IF(Support!$A$7=B83,Support!$B$7,IF(T82>0,T82*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B83,Support!$B$7,IF(T82>0,T82*(1+$F$34),0))))","v":""}]
[null,92,0,0,0,8236298.5246861614,{"$f":"IF(B84=\"\",\"\",IF(B84>=Support!$A$7,IF(VLOOKUP(B84,Support!$A$4:$F$47,2)>0,VLOOKUP(B84,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B84=\"\",\"\",IF(B84<Support!$H$7,0,VLOOKUP(B84,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B84=\"\",\"\",IF(B84>=Support!$H$7,VLOOKUP(B84,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B84=\"\",\"\",IF(B84<Support!$A$7,0,VLOOKUP(B84,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,5471042.2175579919,0,"",48,{"$f":"IF(ISERR((IF(Support!$A$7=B84,Support!$B$7,IF(T83>0,T83*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B84,Support!$B$7,IF(T83>0,T83*(1+$F$34),0))))","v":""}]
[null,93,0,0,0,8812839.4214141928,{"$f":"IF(B85=\"\",\"\",IF(B85>=Support!$A$7,IF(VLOOKUP(B85,Support!$A$4:$F$47,2)>0,VLOOKUP(B85,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B85=\"\",\"\",IF(B85<Support!$H$7,0,VLOOKUP(B85,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B85=\"\",\"\",IF(B85>=Support!$H$7,VLOOKUP(B85,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B85=\"\",\"\",IF(B85<Support!$A$7,0,VLOOKUP(B85,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,5854015.1727870516,0,"",49,{"$f":"IF(ISERR((IF(Support!$A$7=B85,Support!$B$7,IF(T84>0,T84*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B85,Support!$B$7,IF(T84>0,T84*(1+$F$34),0))))","v":""}]
[null,94,0,0,0,9429738.1809131876,{"$f":"IF(B86=\"\",\"\",IF(B86>=Support!$A$7,IF(VLOOKUP(B86,Support!$A$4:$F$47,2)>0,VLOOKUP(B86,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B86=\"\",\"\",IF(B86<Support!$H$7,0,VLOOKUP(B86,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B86=\"\",\"\",IF(B86>=Support!$H$7,VLOOKUP(B86,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B86=\"\",\"\",IF(B86<Support!$A$7,0,VLOOKUP(B86,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,6263796.2348821452,0,"",50,{"$f":"IF(ISERR((IF(Support!$A$7=B86,Support!$B$7,IF(T85>0,T85*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B86,Support!$B$7,IF(T85>0,T85*(1+$F$34),0))))","v":""}]
[null,95,0,0,0,10089819.853577111,{"$f":"IF(B87=\"\",\"\",IF(B87>=Support!$A$7,IF(VLOOKUP(B87,Support!$A$4:$F$47,2)>0,VLOOKUP(B87,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":0},{"$f":"IF(B87=\"\",\"\",IF(B87<Support!$H$7,0,VLOOKUP(B87,Support!$H$4:$M$47,3)))","v":0},{"$f":"IF(B87=\"\",\"\",IF(B87>=Support!$H$7,VLOOKUP(B87,Support!$H$4:$M$47,6),0))","v":0},{"$f":"IF(B87=\"\",\"\",IF(B87<Support!$A$7,0,VLOOKUP(B87,Support!$A$4:$F$47,6)))","v":0},"None","None",null,null,null,6702261.9713238962,0,"",51,{"$f":"IF(ISERR((IF(Support!$A$7=B87,Support!$B$7,IF(T86>0,T86*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B87,Support!$B$7,IF(T86>0,T86*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B88=\"\",\"\",IF(B88>=Support!$A$7,IF(VLOOKUP(B88,Support!$A$4:$F$47,2)>0,VLOOKUP(B88,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B88=\"\",\"\",IF(B88<Support!$H$7,0,VLOOKUP(B88,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B88=\"\",\"\",IF(B88>=Support!$H$7,VLOOKUP(B88,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B88=\"\",\"\",IF(B88<Support!$A$7,0,VLOOKUP(B88,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",52,{"$f":"IF(ISERR((IF(Support!$A$7=B88,Support!$B$7,IF(T87>0,T87*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B88,Support!$B$7,IF(T87>0,T87*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B89=\"\",\"\",IF(B89>=Support!$A$7,IF(VLOOKUP(B89,Support!$A$4:$F$47,2)>0,VLOOKUP(B89,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B89=\"\",\"\",IF(B89<Support!$H$7,0,VLOOKUP(B89,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B89=\"\",\"\",IF(B89>=Support!$H$7,VLOOKUP(B89,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B89=\"\",\"\",IF(B89<Support!$A$7,0,VLOOKUP(B89,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",53,{"$f":"IF(ISERR((IF(Support!$A$7=B89,Support!$B$7,IF(T88>0,T88*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B89,Support!$B$7,IF(T88>0,T88*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B90=\"\",\"\",IF(B90>=Support!$A$7,IF(VLOOKUP(B90,Support!$A$4:$F$47,2)>0,VLOOKUP(B90,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B90=\"\",\"\",IF(B90<Support!$H$7,0,VLOOKUP(B90,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B90=\"\",\"\",IF(B90>=Support!$H$7,VLOOKUP(B90,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B90=\"\",\"\",IF(B90<Support!$A$7,0,VLOOKUP(B90,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",54,{"$f":"IF(ISERR((IF(Support!$A$7=B90,Support!$B$7,IF(T89>0,T89*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B90,Support!$B$7,IF(T89>0,T89*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B91=\"\",\"\",IF(B91>=Support!$A$7,IF(VLOOKUP(B91,Support!$A$4:$F$47,2)>0,VLOOKUP(B91,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B91=\"\",\"\",IF(B91<Support!$H$7,0,VLOOKUP(B91,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B91=\"\",\"\",IF(B91>=Support!$H$7,VLOOKUP(B91,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B91=\"\",\"\",IF(B91<Support!$A$7,0,VLOOKUP(B91,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",55,{"$f":"IF(ISERR((IF(Support!$A$7=B91,Support!$B$7,IF(T90>0,T90*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B91,Support!$B$7,IF(T90>0,T90*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B92=\"\",\"\",IF(B92>=Support!$A$7,IF(VLOOKUP(B92,Support!$A$4:$F$47,2)>0,VLOOKUP(B92,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B92=\"\",\"\",IF(B92<Support!$H$7,0,VLOOKUP(B92,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B92=\"\",\"\",IF(B92>=Support!$H$7,VLOOKUP(B92,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B92=\"\",\"\",IF(B92<Support!$A$7,0,VLOOKUP(B92,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",56,{"$f":"IF(ISERR((IF(Support!$A$7=B92,Support!$B$7,IF(T91>0,T91*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B92,Support!$B$7,IF(T91>0,T91*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B93=\"\",\"\",IF(B93>=Support!$A$7,IF(VLOOKUP(B93,Support!$A$4:$F$47,2)>0,VLOOKUP(B93,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B93=\"\",\"\",IF(B93<Support!$H$7,0,VLOOKUP(B93,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B93=\"\",\"\",IF(B93>=Support!$H$7,VLOOKUP(B93,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B93=\"\",\"\",IF(B93<Support!$A$7,0,VLOOKUP(B93,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",57,{"$f":"IF(ISERR((IF(Support!$A$7=B93,Support!$B$7,IF(T92>0,T92*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B93,Support!$B$7,IF(T92>0,T92*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B94=\"\",\"\",IF(B94>=Support!$A$7,IF(VLOOKUP(B94,Support!$A$4:$F$47,2)>0,VLOOKUP(B94,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B94=\"\",\"\",IF(B94<Support!$H$7,0,VLOOKUP(B94,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B94=\"\",\"\",IF(B94>=Support!$H$7,VLOOKUP(B94,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B94=\"\",\"\",IF(B94<Support!$A$7,0,VLOOKUP(B94,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",58,{"$f":"IF(ISERR((IF(Support!$A$7=B94,Support!$B$7,IF(T93>0,T93*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B94,Support!$B$7,IF(T93>0,T93*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B95=\"\",\"\",IF(B95>=Support!$A$7,IF(VLOOKUP(B95,Support!$A$4:$F$47,2)>0,VLOOKUP(B95,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B95=\"\",\"\",IF(B95<Support!$H$7,0,VLOOKUP(B95,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B95=\"\",\"\",IF(B95>=Support!$H$7,VLOOKUP(B95,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B95=\"\",\"\",IF(B95<Support!$A$7,0,VLOOKUP(B95,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",59,{"$f":"IF(ISERR((IF(Support!$A$7=B95,Support!$B$7,IF(T94>0,T94*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B95,Support!$B$7,IF(T94>0,T94*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B96=\"\",\"\",IF(B96>=Support!$A$7,IF(VLOOKUP(B96,Support!$A$4:$F$47,2)>0,VLOOKUP(B96,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B96=\"\",\"\",IF(B96<Support!$H$7,0,VLOOKUP(B96,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B96=\"\",\"\",IF(B96>=Support!$H$7,VLOOKUP(B96,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B96=\"\",\"\",IF(B96<Support!$A$7,0,VLOOKUP(B96,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",60,{"$f":"IF(ISERR((IF(Support!$A$7=B96,Support!$B$7,IF(T95>0,T95*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B96,Support!$B$7,IF(T95>0,T95*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B97=\"\",\"\",IF(B97>=Support!$A$7,IF(VLOOKUP(B97,Support!$A$4:$F$47,2)>0,VLOOKUP(B97,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B97=\"\",\"\",IF(B97<Support!$H$7,0,VLOOKUP(B97,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B97=\"\",\"\",IF(B97>=Support!$H$7,VLOOKUP(B97,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B97=\"\",\"\",IF(B97<Support!$A$7,0,VLOOKUP(B97,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",61,{"$f":"IF(ISERR((IF(Support!$A$7=B97,Support!$B$7,IF(T96>0,T96*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B97,Support!$B$7,IF(T96>0,T96*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B98=\"\",\"\",IF(B98>=Support!$A$7,IF(VLOOKUP(B98,Support!$A$4:$F$47,2)>0,VLOOKUP(B98,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B98=\"\",\"\",IF(B98<Support!$H$7,0,VLOOKUP(B98,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B98=\"\",\"\",IF(B98>=Support!$H$7,VLOOKUP(B98,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B98=\"\",\"\",IF(B98<Support!$A$7,0,VLOOKUP(B98,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",62,{"$f":"IF(ISERR((IF(Support!$A$7=B98,Support!$B$7,IF(T97>0,T97*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B98,Support!$B$7,IF(T97>0,T97*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B99=\"\",\"\",IF(B99>=Support!$A$7,IF(VLOOKUP(B99,Support!$A$4:$F$47,2)>0,VLOOKUP(B99,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B99=\"\",\"\",IF(B99<Support!$H$7,0,VLOOKUP(B99,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B99=\"\",\"\",IF(B99>=Support!$H$7,VLOOKUP(B99,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B99=\"\",\"\",IF(B99<Support!$A$7,0,VLOOKUP(B99,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",63,{"$f":"IF(ISERR((IF(Support!$A$7=B99,Support!$B$7,IF(T98>0,T98*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B99,Support!$B$7,IF(T98>0,T98*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B100=\"\",\"\",IF(B100>=Support!$A$7,IF(VLOOKUP(B100,Support!$A$4:$F$47,2)>0,VLOOKUP(B100,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B100=\"\",\"\",IF(B100<Support!$H$7,0,VLOOKUP(B100,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B100=\"\",\"\",IF(B100>=Support!$H$7,VLOOKUP(B100,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B100=\"\",\"\",IF(B100<Support!$A$7,0,VLOOKUP(B100,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",64,{"$f":"IF(ISERR((IF(Support!$A$7=B100,Support!$B$7,IF(T99>0,T99*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B100,Support!$B$7,IF(T99>0,T99*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B101=\"\",\"\",IF(B101>=Support!$A$7,IF(VLOOKUP(B101,Support!$A$4:$F$47,2)>0,VLOOKUP(B101,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B101=\"\",\"\",IF(B101<Support!$H$7,0,VLOOKUP(B101,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B101=\"\",\"\",IF(B101>=Support!$H$7,VLOOKUP(B101,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B101=\"\",\"\",IF(B101<Support!$A$7,0,VLOOKUP(B101,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",65,{"$f":"IF(ISERR((IF(Support!$A$7=B101,Support!$B$7,IF(T100>0,T100*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B101,Support!$B$7,IF(T100>0,T100*(1+$F$34),0))))","v":""}]
[null,"",{"$f":"IF(B102<=$F$15,C101*(1+$F$14),0)","v":0},0,"","",{"$f":"IF(B102=\"\",\"\",IF(B102>=Support!$A$7,IF(VLOOKUP(B102,Support!$A$4:$F$47,2)>0,VLOOKUP(B102,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B102=\"\",\"\",IF(B102<Support!$H$7,0,VLOOKUP(B102,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B102=\"\",\"\",IF(B102>=Support!$H$7,VLOOKUP(B102,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B102=\"\",\"\",IF(B102<Support!$A$7,0,VLOOKUP(B102,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$f":"(P101+E102)*(1+$F$23)/(1+$F$24)","v":{"$error":"#VALUE!"}},{"$f":"C102/(1+$F$24)^(S102)","v":0},"",66,{"$f":"IF(ISERR((IF(Support!$A$7=B102,Support!$B$7,IF(T101>0,T101*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B102,Support!$B$7,IF(T101>0,T101*(1+$F$34),0))))","v":""}]
[null,{"$f":"IF(B102=\"\",\"\",IF(B102+1>$F$15+$F$16,\"\",B102+1))","v":""},0,0,{"$f":"IF(B103=\"\",\"\",$F$21*C103-G103)","v":""},{"$f":"IF(B103=\"\",\"\",(E103+F102)*(1+$F$23))","v":""},{"$f":"IF(B103=\"\",\"\",IF(B103>=Support!$A$7,IF(VLOOKUP(B103,Support!$A$4:$F$47,2)>0,VLOOKUP(B103,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B103=\"\",\"\",IF(B103<Support!$H$7,0,VLOOKUP(B103,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B103=\"\",\"\",IF(B103>=Support!$H$7,VLOOKUP(B103,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B103=\"\",\"\",IF(B103<Support!$A$7,0,VLOOKUP(B103,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,{"$f":"IF(C103=0,\"\",IF(H103=0,0,(H103+$F$30)/C103))","v":""},67,{"$f":"IF(ISERR((IF(Support!$A$7=B103,Support!$B$7,IF(T102>0,T102*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B103,Support!$B$7,IF(T102>0,T102*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B104=\"\",\"\",IF(B104>=Support!$A$7,IF(VLOOKUP(B104,Support!$A$4:$F$47,2)>0,VLOOKUP(B104,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B104=\"\",\"\",IF(B104<Support!$H$7,0,VLOOKUP(B104,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B104=\"\",\"\",IF(B104>=Support!$H$7,VLOOKUP(B104,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B104=\"\",\"\",IF(B104<Support!$A$7,0,VLOOKUP(B104,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",68,{"$f":"IF(ISERR((IF(Support!$A$7=B104,Support!$B$7,IF(T103>0,T103*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B104,Support!$B$7,IF(T103>0,T103*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B105=\"\",\"\",IF(B105>=Support!$A$7,IF(VLOOKUP(B105,Support!$A$4:$F$47,2)>0,VLOOKUP(B105,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B105=\"\",\"\",IF(B105<Support!$H$7,0,VLOOKUP(B105,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B105=\"\",\"\",IF(B105>=Support!$H$7,VLOOKUP(B105,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B105=\"\",\"\",IF(B105<Support!$A$7,0,VLOOKUP(B105,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",69,{"$f":"IF(ISERR((IF(Support!$A$7=B105,Support!$B$7,IF(T104>0,T104*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B105,Support!$B$7,IF(T104>0,T104*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B106=\"\",\"\",IF(B106>=Support!$A$7,IF(VLOOKUP(B106,Support!$A$4:$F$47,2)>0,VLOOKUP(B106,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B106=\"\",\"\",IF(B106<Support!$H$7,0,VLOOKUP(B106,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B106=\"\",\"\",IF(B106>=Support!$H$7,VLOOKUP(B106,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B106=\"\",\"\",IF(B106<Support!$A$7,0,VLOOKUP(B106,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",70,{"$f":"IF(ISERR((IF(Support!$A$7=B106,Support!$B$7,IF(T105>0,T105*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B106,Support!$B$7,IF(T105>0,T105*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B107=\"\",\"\",IF(B107>=Support!$A$7,IF(VLOOKUP(B107,Support!$A$4:$F$47,2)>0,VLOOKUP(B107,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B107=\"\",\"\",IF(B107<Support!$H$7,0,VLOOKUP(B107,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B107=\"\",\"\",IF(B107>=Support!$H$7,VLOOKUP(B107,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B107=\"\",\"\",IF(B107<Support!$A$7,0,VLOOKUP(B107,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",71,{"$f":"IF(ISERR((IF(Support!$A$7=B107,Support!$B$7,IF(T106>0,T106*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B107,Support!$B$7,IF(T106>0,T106*(1+$F$34),0))))","v":""}]
[null,"",0,{"$f":"C108*Annual_Savings","v":0},"","",{"$f":"IF(B108=\"\",\"\",IF(B108>=Support!$A$7,IF(VLOOKUP(B108,Support!$A$4:$F$47,2)>0,VLOOKUP(B108,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B108=\"\",\"\",IF(B108<Support!$H$7,0,VLOOKUP(B108,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B108=\"\",\"\",IF(B108>=Support!$H$7,VLOOKUP(B108,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B108=\"\",\"\",IF(B108<Support!$A$7,0,VLOOKUP(B108,Support!$A$4:$F$47,6)))","v":""},{"$f":"IF(B108=\"\",\"\",IF(C108>0,F108/C108,\"None\"))","v":""},{"$f":"IF(B108=\"\",\"\",IF(C108>0,J108/C108,\"None\"))","v":""},null,null,null,{"$error":"#VALUE!"},0,"",72,{"$f":"IF(ISERR((IF(Support!$A$7=B108,Support!$B$7,IF(T107>0,T107*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B108,Support!$B$7,IF(T107>0,T107*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B109=\"\",\"\",IF(B109>=Support!$A$7,IF(VLOOKUP(B109,Support!$A$4:$F$47,2)>0,VLOOKUP(B109,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B109=\"\",\"\",IF(B109<Support!$H$7,0,VLOOKUP(B109,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B109=\"\",\"\",IF(B109>=Support!$H$7,VLOOKUP(B109,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B109=\"\",\"\",IF(B109<Support!$A$7,0,VLOOKUP(B109,Support!$A$4:$F$47,6)))","v":""},{"$f":"IF(B109=\"\",\"\",IF(C109>0,F109/C109,\"None\"))","v":""},{"$f":"IF(B109=\"\",\"\",IF(C109>0,J109/C109,\"None\"))","v":""},null,null,null,{"$error":"#VALUE!"},0,"",73,{"$f":"IF(ISERR((IF(Support!$A$7=B109,Support!$B$7,IF(T108>0,T108*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B109,Support!$B$7,IF(T108>0,T108*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B110=\"\",\"\",IF(B110>=Support!$A$7,IF(VLOOKUP(B110,Support!$A$4:$F$47,2)>0,VLOOKUP(B110,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B110=\"\",\"\",IF(B110<Support!$H$7,0,VLOOKUP(B110,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B110=\"\",\"\",IF(B110>=Support!$H$7,VLOOKUP(B110,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B110=\"\",\"\",IF(B110<Support!$A$7,0,VLOOKUP(B110,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",74,{"$f":"IF(ISERR((IF(Support!$A$7=B110,Support!$B$7,IF(T109>0,T109*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B110,Support!$B$7,IF(T109>0,T109*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B111=\"\",\"\",IF(B111>=Support!$A$7,IF(VLOOKUP(B111,Support!$A$4:$F$47,2)>0,VLOOKUP(B111,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B111=\"\",\"\",IF(B111<Support!$H$7,0,VLOOKUP(B111,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B111=\"\",\"\",IF(B111>=Support!$H$7,VLOOKUP(B111,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B111=\"\",\"\",IF(B111<Support!$A$7,0,VLOOKUP(B111,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",75,{"$f":"IF(ISERR((IF(Support!$A$7=B111,Support!$B$7,IF(T110>0,T110*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B111,Support!$B$7,IF(T110>0,T110*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B112=\"\",\"\",IF(B112>=Support!$A$7,IF(VLOOKUP(B112,Support!$A$4:$F$47,2)>0,VLOOKUP(B112,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B112=\"\",\"\",IF(B112<Support!$H$7,0,VLOOKUP(B112,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B112=\"\",\"\",IF(B112>=Support!$H$7,VLOOKUP(B112,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B112=\"\",\"\",IF(B112<Support!$A$7,0,VLOOKUP(B112,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",76,{"$f":"IF(ISERR((IF(Support!$A$7=B112,Support!$B$7,IF(T111>0,T111*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B112,Support!$B$7,IF(T111>0,T111*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B113=\"\",\"\",IF(B113>=Support!$A$7,IF(VLOOKUP(B113,Support!$A$4:$F$47,2)>0,VLOOKUP(B113,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B113=\"\",\"\",IF(B113<Support!$H$7,0,VLOOKUP(B113,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B113=\"\",\"\",IF(B113>=Support!$H$7,VLOOKUP(B113,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B113=\"\",\"\",IF(B113<Support!$A$7,0,VLOOKUP(B113,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",77,{"$f":"IF(ISERR((IF(Support!$A$7=B113,Support!$B$7,IF(T112>0,T112*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B113,Support!$B$7,IF(T112>0,T112*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B114=\"\",\"\",IF(B114>=Support!$A$7,IF(VLOOKUP(B114,Support!$A$4:$F$47,2)>0,VLOOKUP(B114,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B114=\"\",\"\",IF(B114<Support!$H$7,0,VLOOKUP(B114,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B114=\"\",\"\",IF(B114>=Support!$H$7,VLOOKUP(B114,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B114=\"\",\"\",IF(B114<Support!$A$7,0,VLOOKUP(B114,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",78,{"$f":"IF(ISERR((IF(Support!$A$7=B114,Support!$B$7,IF(T113>0,T113*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B114,Support!$B$7,IF(T113>0,T113*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B115=\"\",\"\",IF(B115>=Support!$A$7,IF(VLOOKUP(B115,Support!$A$4:$F$47,2)>0,VLOOKUP(B115,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B115=\"\",\"\",IF(B115<Support!$H$7,0,VLOOKUP(B115,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B115=\"\",\"\",IF(B115>=Support!$H$7,VLOOKUP(B115,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B115=\"\",\"\",IF(B115<Support!$A$7,0,VLOOKUP(B115,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",79,{"$f":"IF(ISERR((IF(Support!$A$7=B115,Support!$B$7,IF(T114>0,T114*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B115,Support!$B$7,IF(T114>0,T114*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B116=\"\",\"\",IF(B116>=Support!$A$7,IF(VLOOKUP(B116,Support!$A$4:$F$47,2)>0,VLOOKUP(B116,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B116=\"\",\"\",IF(B116<Support!$H$7,0,VLOOKUP(B116,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B116=\"\",\"\",IF(B116>=Support!$H$7,VLOOKUP(B116,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B116=\"\",\"\",IF(B116<Support!$A$7,0,VLOOKUP(B116,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",80,{"$f":"IF(ISERR((IF(Support!$A$7=B116,Support!$B$7,IF(T115>0,T115*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B116,Support!$B$7,IF(T115>0,T115*(1+$F$34),0))))","v":""}]
[null,"",0,0,"","",{"$f":"IF(B117=\"\",\"\",IF(B117>=Support!$A$7,IF(VLOOKUP(B117,Support!$A$4:$F$47,2)>0,VLOOKUP(B117,Support!$A$4:$F$47,3)-Support!$J$7,0),0))","v":""},{"$f":"IF(B117=\"\",\"\",IF(B117<Support!$H$7,0,VLOOKUP(B117,Support!$H$4:$M$47,3)))","v":""},{"$f":"IF(B117=\"\",\"\",IF(B117>=Support!$H$7,VLOOKUP(B117,Support!$H$4:$M$47,6),0))","v":""},{"$f":"IF(B117=\"\",\"\",IF(B117<Support!$A$7,0,VLOOKUP(B117,Support!$A$4:$F$47,6)))","v":""},"","",null,null,null,{"$error":"#VALUE!"},0,"",81,{"$f":"IF(ISERR((IF(Support!$A$7=B117,Support!$B$7,IF(T116>0,T116*(1+$F$34),0)))),\"\",(IF(Support!$A$7=B117,Support!$B$7,IF(T116>0,T116*(1+$F$34),0))))","v":""}]

{"sheet":"Support","index":2,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Mortgage Payment Data"]
[]
[]
[null,"Starting Balance","Payment","Principle","Interest","Balance",null,null,"Starting Balance","Payment","Principle","Interest","Balance"]
[]
[]
[{"$f":"'Planning Ratios'!$F$26","v":30},{"$f":"'Planning Ratios'!$F$29","v":250000},{"$f":"-PMT('Planning Ratios'!$F$31,'Planning Ratios'!$F$33,'Planning Ratios'!$F$29)","v":14457.524783415336},{"$f":"C7-E7","v":4457.5247834153361},{"$f":"'Planning Ratios'!$F$29*'Planning Ratios'!$F$31","v":10000},{"$f":"B7-D7","v":245542.47521658466},null,{"$f":"'Planning Ratios'!$F$26","v":30},{"$f":"'Planning Ratios'!$F$29","v":250000},{"$f":"-PMT('Planning Ratios'!$F$31,Loan_Term,'Planning Ratios'!$F$29)","v":14457.524783415336},{"$f":"J7-L7","v":4457.5247834153361},{"$f":"'Planning Ratios'!$F$29*'Planning Ratios'!$F$31","v":10000},{"$f":"I7-K7","v":245542.47521658466}]
[{"$f":"A7+1","v":31},{"$f":"F7","v":245542.47521658466},{"$f":"IF(F7>C7,C7,F7+('Planning Ratios'!$F$31*F7))","v":14457.524783415336},4635.8257747519492,{"$f":"'Planning Ratios'!$F$31*B8","v":9821.6990086633868},{"$f":"F7-D8","v":240906.64944183271},null,{"$f":"H7+1","v":31},{"$f":"M7","v":245542.47521658466},{"$f":"IF(M7>J7,J7,M7+('Planning Ratios'!$F$31*M7))","v":14457.524783415336},4635.8257747519492,{"$f":"'Planning Ratios'!$F$31*I8","v":9821.6990086633868},{"$f":"M7-K8","v":240906.64944183271}]
[32,240906.64944183271,{"$f":"IF(F8>C8,C8,F8+('Planning Ratios'!$F$31*F8))","v":14457.524783415336},4821.2588057420271,{"$f":"'Planning Ratios'!$F$31*B9","v":9636.265977673309},236085.39063609068,null,32,240906.64944183271,{"$f":"IF(M8>J8,J8,M8+('Planning Ratios'!$F$31*M8))","v":14457.524783415336},4821.2588057420271,{"$f":"'Planning Ratios'!$F$31*I9","v":9636.265977673309},236085.39063609068]
[33,236085.39063609068,{"$f":"IF(F9>C9,C9,F9+('Planning Ratios'!$F$31*F9))","v":14457.524783415336},5014.1091579717086,{"$f":"'Planning Ratios'!$F$31*B10","v":9443.4156254436275},231071.28147811897,null,33,236085.39063609068,{"$f":"IF(M9>J9,J9,M9+('Planning Ratios'!$F$31*M9))","v":14457.524783415336},5014.1091579717086,{"$f":"'Planning Ratios'!$F$31*I10","v":9443.4156254436275},231071.28147811897]
[34,231071.28147811897,{"$f":"IF(F10>C10,C10,F10+('Planning Ratios'!$F$31*F10))","v":14457.524783415336},5214.6735242905779,{"$f":"'Planning Ratios'!$F$31*B11","v":9242.8512591247581},225856.60795382838,null,34,231071.28147811897,{"$f":"IF(M10>J10,J10,M10+('Planning Ratios'!$F$31*M10))","v":14457.524783415336},5214.6735242905779,{"$f":"'Planning Ratios'!$F$31*I11","v":9242.8512591247581},225856.60795382838]
[35,225856.60795382838,{"$f":"IF(F11>C11,C11,F11+('Planning Ratios'!$F$31*F11))","v":14457.524783415336},5423.2604652622013,{"$f":"'Planning Ratios'!$F$31*B12","v":9034.2643181531348},220433.34748856619,null,35,225856.60795382838,{"$f":"IF(M11>J11,J11,M11+('Planning Ratios'!$F$31*M11))","v":14457.524783415336},5423.2604652622013,{"$f":"'Planning Ratios'!$F$31*I12","v":9034.2643181531348},220433.34748856619]
[36,220433.34748856619,{"$f":"IF(F12>C12,C12,F12+('Planning Ratios'!$F$31*F12))","v":14457.524783415336},5640.1908838726886,{"$f":"'Planning Ratios'!$F$31*B13","v":8817.3338995426475},214793.1566046935,null,36,220433.34748856619,{"$f":"IF(M12>J12,J12,M12+('Planning Ratios'!$F$31*M12))","v":14457.524783415336},5640.1908838726886,{"$f":"'Planning Ratios'!$F$31*I13","v":8817.3338995426475},214793.1566046935]
[37,214793.1566046935,{"$f":"IF(F13>C13,C13,F13+('Planning Ratios'!$F$31*F13))","v":14457.524783415336},5865.7985192275955,{"$f":"'Planning Ratios'!$F$31*B14","v":8591.7262641877405},208927.35808546591,null,37,214793.1566046935,{"$f":"IF(M13>J13,J13,M13+('Planning Ratios'!$F$31*M13))","v":14457.524783415336},5865.7985192275955,{"$f":"'Planning Ratios'!$F$31*I14","v":8591.7262641877405},208927.35808546591]
[38,208927.35808546591,{"$f":"IF(F14>C14,C14,F14+('Planning Ratios'!$F$31*F14))","v":14457.524783415336},6100.4304599966999,{"$f":"'Planning Ratios'!$F$31*B15","v":8357.0943234186361},202826.92762546922,null,38,208927.35808546591,{"$f":"IF(M14>J14,J14,M14+('Planning Ratios'!$F$31*M14))","v":14457.524783415336},6100.4304599966999,{"$f":"'Planning Ratios'!$F$31*I15","v":8357.0943234186361},202826.92762546922]
[39,202826.92762546922,{"$f":"IF(F15>C15,C15,F15+('Planning Ratios'!$F$31*F15))","v":14457.524783415336},6344.4476783965665,{"$f":"'Planning Ratios'!$F$31*B16","v":8113.0771050187695},196482.47994707266,null,39,202826.92762546922,{"$f":"IF(M15>J15,J15,M15+('Planning Ratios'!$F$31*M15))","v":14457.524783415336},6344.4476783965665,{"$f":"'Planning Ratios'!$F$31*I16","v":8113.0771050187695},196482.47994707266]
[40,196482.47994707266,{"$f":"IF(F16>C16,C16,F16+('Planning Ratios'!$F$31*F16))","v":14457.524783415336},6598.2255855324292,{"$f":"'Planning Ratios'!$F$31*B17","v":7859.2991978829068},189884.25436154022,null,40,196482.47994707266,{"$f":"IF(M16>J16,J16,M16+('Planning Ratios'!$F$31*M16))","v":14457.524783415336},6598.2255855324292,{"$f":"'Planning Ratios'!$F$31*I17","v":7859.2991978829068},189884.25436154022]
[41,189884.25436154022,{"$f":"IF(F17>C17,C17,F17+('Planning Ratios'!$F$31*F17))","v":14457.524783415336},6862.1546089537269,{"$f":"'Planning Ratios'!$F$31*B18","v":7595.3701744616092},183022.09975258651,null,41,189884.25436154022,{"$f":"IF(M17>J17,J17,M17+('Planning Ratios'!$F$31*M17))","v":14457.524783415336},6862.1546089537269,{"$f":"'Planning Ratios'!$F$31*I18","v":7595.3701744616092},183022.09975258651]
[42,183022.09975258651,{"$f":"IF(F18>C18,C18,F18+('Planning Ratios'!$F$31*F18))","v":14457.524783415336},7136.6407933118753,{"$f":"'Planning Ratios'!$F$31*B19","v":7320.8839901034607},175885.45895927463,null,42,183022.09975258651,{"$f":"IF(M18>J18,J18,M18+('Planning Ratios'!$F$31*M18))","v":14457.524783415336},7136.6407933118753,{"$f":"'Planning Ratios'!$F$31*I19","v":7320.8839901034607},175885.45895927463]
[43,175885.45895927463,{"$f":"IF(F19>C19,C19,F19+('Planning Ratios'!$F$31*F19))","v":14457.524783415336},7422.1064250443505,{"$f":"'Planning Ratios'!$F$31*B20","v":7035.4183583709855},168463.35253423027,null,43,175885.45895927463,{"$f":"IF(M19>J19,J19,M19+('Planning Ratios'!$F$31*M19))","v":14457.524783415336},7422.1064250443505,{"$f":"'Planning Ratios'!$F$31*I20","v":7035.4183583709855},168463.35253423027]
[44,168463.35253423027,{"$f":"IF(F20>C20,C20,F20+('Planning Ratios'!$F$31*F20))","v":14457.524783415336},7718.9906820461247,{"$f":"'Planning Ratios'!$F$31*B21","v":6738.5341013692114},160744.36185218414,null,44,168463.35253423027,{"$f":"IF(M20>J20,J20,M20+('Planning Ratios'!$F$31*M20))","v":14457.524783415336},7718.9906820461247,{"$f":"'Planning Ratios'!$F$31*I21","v":6738.5341013692114},160744.36185218414]
[45,160744.36185218414,{"$f":"IF(F21>C21,C21,F21+('Planning Ratios'!$F$31*F21))","v":14457.524783415336},8027.7503093279702,{"$f":"'Planning Ratios'!$F$31*B22","v":6429.7744740873659},152716.61154285618,null,45,160744.36185218414,{"$f":"IF(M21>J21,J21,M21+('Planning Ratios'!$F$31*M21))","v":14457.524783415336},8027.7503093279702,{"$f":"'Planning Ratios'!$F$31*I22","v":6429.7744740873659},152716.61154285618]
[46,152716.61154285618,{"$f":"IF(F22>C22,C22,F22+('Planning Ratios'!$F$31*F22))","v":14457.524783415336},8348.8603217010896,{"$f":"'Planning Ratios'!$F$31*B23","v":6108.6644617142474},144367.75122115508,null,46,152716.61154285618,{"$f":"IF(M22>J22,J22,M22+('Planning Ratios'!$F$31*M22))","v":14457.524783415336},8348.8603217010896,{"$f":"'Planning Ratios'!$F$31*I23","v":6108.6644617142474},144367.75122115508]
[47,144367.75122115508,{"$f":"IF(F23>C23,C23,F23+('Planning Ratios'!$F$31*F23))","v":14457.524783415336},8682.8147345691323,{"$f":"'Planning Ratios'!$F$31*B24","v":5774.7100488462029},135684.93648658594,null,47,144367.75122115508,{"$f":"IF(M23>J23,J23,M23+('Planning Ratios'!$F$31*M23))","v":14457.524783415336},8682.8147345691323,{"$f":"'Planning Ratios'!$F$31*I24","v":5774.7100488462029},135684.93648658594]
[48,135684.93648658594,{"$f":"IF(F24>C24,C24,F24+('Planning Ratios'!$F$31*F24))","v":14457.524783415336},9030.1273239518996,{"$f":"'Planning Ratios'!$F$31*B25","v":5427.3974594634374},126654.80916263405,null,48,135684.93648658594,{"$f":"IF(M24>J24,J24,M24+('Planning Ratios'!$F$31*M24))","v":14457.524783415336},9030.1273239518996,{"$f":"'Planning Ratios'!$F$31*I25","v":5427.3974594634374},126654.80916263405]
[49,126654.80916263405,{"$f":"IF(F25>C25,C25,F25+('Planning Ratios'!$F$31*F25))","v":14457.524783415336},9391.3324169099742,{"$f":"'Planning Ratios'!$F$31*B26","v":5066.1923665053619},117263.47674572407,null,49,126654.80916263405,{"$f":"IF(M25>J25,J25,M25+('Planning Ratios'!$F$31*M25))","v":14457.524783415336},9391.3324169099742,{"$f":"'Planning Ratios'!$F$31*I26","v":5066.1923665053619},117263.47674572407]
[50,117263.47674572407,{"$f":"IF(F26>C26,C26,F26+('Planning Ratios'!$F$31*F26))","v":14457.524783415336},9766.9857135863731,{"$f":"'Planning Ratios'!$F$31*B27","v":4690.539069828963},107496.4910321377,null,50,117263.47674572407,{"$f":"IF(M26>J26,J26,M26+('Planning Ratios'!$F$31*M26))","v":14457.524783415336},9766.9857135863731,{"$f":"'Planning Ratios'!$F$31*I27","v":4690.539069828963},107496.4910321377]
[51,107496.4910321377,{"$f":"IF(F27>C27,C27,F27+('Planning Ratios'!$F$31*F27))","v":14457.524783415336},10157.665142129828,{"$f":"'Planning Ratios'!$F$31*B28","v":4299.8596412855077},97338.825890007865,null,51,107496.4910321377,{"$f":"IF(M27>J27,J27,M27+('Planning Ratios'!$F$31*M27))","v":14457.524783415336},10157.665142129828,{"$f":"'Planning Ratios'!$F$31*I28","v":4299.8596412855077},97338.825890007865]
[52,97338.825890007865,{"$f":"IF(F28>C28,C28,F28+('Planning Ratios'!$F$31*F28))","v":14457.524783415336},10563.971747815021,{"$f":"'Planning Ratios'!$F$31*B29","v":3893.5530356003146},86774.854142192838,null,52,97338.825890007865,{"$f":"IF(M28>J28,J28,M28+('Planning Ratios'!$F$31*M28))","v":14457.524783415336},10563.971747815021,{"$f":"'Planning Ratios'!$F$31*I29","v":3893.5530356003146},86774.854142192838]
[53,86774.854142192838,{"$f":"IF(F29>C29,C29,F29+('Planning Ratios'!$F$31*F29))","v":14457.524783415336},10986.530617727622,{"$f":"'Planning Ratios'!$F$31*B30","v":3470.9941656877136},75788.323524465217,null,53,86774.854142192838,{"$f":"IF(M29>J29,J29,M29+('Planning Ratios'!$F$31*M29))","v":14457.524783415336},10986.530617727622,{"$f":"'Planning Ratios'!$F$31*I30","v":3470.9941656877136},75788.323524465217]
[54,75788.323524465217,{"$f":"IF(F30>C30,C30,F30+('Planning Ratios'!$F$31*F30))","v":14457.524783415336},11425.991842436728,{"$f":"'Planning Ratios'!$F$31*B31","v":3031.5329409786086},64362.331682028489,null,54,75788.323524465217,{"$f":"IF(M30>J30,J30,M30+('Planning Ratios'!$F$31*M30))","v":14457.524783415336},11425.991842436728,{"$f":"'Planning Ratios'!$F$31*I31","v":3031.5329409786086},64362.331682028489]
[55,64362.331682028489,{"$f":"IF(F31>C31,C31,F31+('Planning Ratios'!$F$31*F31))","v":14457.524783415336},11883.031516134197,{"$f":"'Planning Ratios'!$F$31*B32","v":2574.4932672811397},52479.300165894296,null,55,64362.331682028489,{"$f":"IF(M31>J31,J31,M31+('Planning Ratios'!$F$31*M31))","v":14457.524783415336},11883.031516134197,{"$f":"'Planning Ratios'!$F$31*I32","v":2574.4932672811397},52479.300165894296]
[56,52479.300165894296,{"$f":"IF(F32>C32,C32,F32+('Planning Ratios'!$F$31*F32))","v":14457.524783415336},12358.352776779564,{"$f":"'Planning Ratios'!$F$31*B33","v":2099.172006635772},40120.947389114735,null,56,52479.300165894296,{"$f":"IF(M32>J32,J32,M32+('Planning Ratios'!$F$31*M32))","v":14457.524783415336},12358.352776779564,{"$f":"'Planning Ratios'!$F$31*I33","v":2099.172006635772},40120.947389114735]
[57,40120.947389114735,{"$f":"IF(F33>C33,C33,F33+('Planning Ratios'!$F$31*F33))","v":14457.524783415336},12852.686887850747,{"$f":"'Planning Ratios'!$F$31*B34","v":1604.8378955645894},27268.260501263991,null,57,40120.947389114735,{"$f":"IF(M33>J33,J33,M33+('Planning Ratios'!$F$31*M33))","v":14457.524783415336},12852.686887850747,{"$f":"'Planning Ratios'!$F$31*I34","v":1604.8378955645894},27268.260501263991]
[58,27268.260501263991,{"$f":"IF(F34>C34,C34,F34+('Planning Ratios'!$F$31*F34))","v":14457.524783415336},13366.794363364777,{"$f":"'Planning Ratios'!$F$31*B35","v":1090.7304200505596},13901.466137899213,null,58,27268.260501263991,{"$f":"IF(M34>J34,J34,M34+('Planning Ratios'!$F$31*M34))","v":14457.524783415336},13366.794363364777,{"$f":"'Planning Ratios'!$F$31*I35","v":1090.7304200505596},13901.466137899213]
[59,13901.466137899213,{"$f":"IF(F35>C35,C35,F35+('Planning Ratios'!$F$31*F35))","v":14457.524783415181},13901.466137899213,{"$f":"'Planning Ratios'!$F$31*B36","v":556.05864551596858},0,null,59,13901.466137899213,{"$f":"IF(M35>J35,J35,M35+('Planning Ratios'!$F$31*M35))","v":14457.524783415181},13901.466137899213,{"$f":"'Planning Ratios'!$F$31*I36","v":556.05864551596858},0]
[60,0,{"$f":"IF(F36>C36,C36,F36+('Planning Ratios'!$F$31*F36))","v":0},0,{"$f":"'Planning Ratios'!$F$31*B37","v":0},0,null,60,0,{"$f":"IF(M36>J36,J36,M36+('Planning Ratios'!$F$31*M36))","v":0},0,{"$f":"'Planning Ratios'!$F$31*I37","v":0},0]
[61,0,{"$f":"IF(F37>C37,C37,F37+('Planning Ratios'!$F$31*F37))","v":0},0,{"$f":"'Planning Ratios'!$F$31*B38","v":0},0,null,61,0,{"$f":"IF(M37>J37,J37,M37+('Planning Ratios'!$F$31*M37))","v":0},0,{"$f":"'Planning Ratios'!$F$31*I38","v":0},0]
[62,0,{"$f":"IF(F38>C38,C38,F38+('Planning Ratios'!$F$31*F38))","v":0},0,{"$f":"'Planning Ratios'!$F$31*B39","v":0},0,null,62,0,{"$f":"IF(M38>J38,J38,M38+('Planning Ratios'!$F$31*M38))","v":0},0,{"$f":"'Planning Ratios'!$F$31*I39","v":0},0]
[63,0,{"$f":"IF(F39>C39,C39,F39+('Planning Ratios'!$F$31*F39))","v":0},0,{"$f":"'Planning Ratios'!$F$31*B40","v":0},0,null,63,0,{"$f":"IF(M39>J39,J39,M39+('Planning Ratios'!$F$31*M39))","v":0},0,{"$f":"'Planning Ratios'!$F$31*I40","v":0},0]
[64,0,{"$f":"IF(F40>C40,C40,F40+('Planning Ratios'!$F$31*F40))","v":0},0,{"$f":"'Planning Ratios'!$F$31*B41","v":0},0,null,64,0,{"$f":"IF(M40>J40,J40,M40+('Planning Ratios'!$F$31*M40))","v":0},0,{"$f":"'Planning Ratios'!$F$31*I41","v":0},0]
[65,0,{"$f":"IF(F41>C41,C41,F41+('Planning Ratios'!$F$31*F41))","v":0},0,{"$f":"'Planning Ratios'!$F$31*B42","v":0},0,null,65,0,{"$f":"IF(M41>J41,J41,M41+('Planning Ratios'!$F$31*M41))","v":0},0,{"$f":"'Planning Ratios'!$F$31*I42","v":0},0]
[66,0,{"$f":"IF(F42>C42,C42,F42+('Planning Ratios'!$F$31*F42))","v":0},0,{"$f":"'Planning Ratios'!$F$31*B43","v":0},0,null,66,0,{"$f":"IF(M42>J42,J42,M42+('Planning Ratios'!$F$31*M42))","v":0},0,{"$f":"'Planning Ratios'!$F$31*I43","v":0},0]
[67,0,{"$f":"IF(F43>C43,C43,F43+('Planning Ratios'!$F$31*F43))","v":0},0,{"$f":"'Planning Ratios'!$F$31*B44","v":0},0,null,67,0,{"$f":"IF(M43>J43,J43,M43+('Planning Ratios'!$F$31*M43))","v":0},0,{"$f":"'Planning Ratios'!$F$31*I44","v":0},0]
[68,0,{"$f":"IF(F44>C44,C44,F44+('Planning Ratios'!$F$31*F44))","v":0},0,{"$f":"'Planning Ratios'!$F$31*B45","v":0},0,null,68,0,{"$f":"IF(M44>J44,J44,M44+('Planning Ratios'!$F$31*M44))","v":0},0,{"$f":"'Planning Ratios'!$F$31*I45","v":0},0]
[69,0,{"$f":"IF(F45>C45,C45,F45+('Planning Ratios'!$F$31*F45))","v":0},0,{"$f":"'Planning Ratios'!$F$31*B46","v":0},0,null,69,0,{"$f":"IF(M45>J45,J45,M45+('Planning Ratios'!$F$31*M45))","v":0},0,{"$f":"'Planning Ratios'!$F$31*I46","v":0},0]
[70,0,{"$f":"IF(F46>C46,C46,F46+('Planning Ratios'!$F$31*F46))","v":0},0,{"$f":"'Planning Ratios'!$F$31*B47","v":0},0,null,70,0,{"$f":"IF(M46>J46,J46,M46+('Planning Ratios'!$F$31*M46))","v":0},0,{"$f":"'Planning Ratios'!$F$31*I47","v":0},0]