{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Read Me!","Home_Page","Tabular_Output","Sheet1"],"not_rendered":{"charts":2,"macros":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Read Me!","index":0,"n_rows":33,"n_cols":1,"rows_kept":33}
[]
["TFIR 2016 Pension Choice Model"]
["First, please read documentation at:"]
["https://senate.universityofcalifornia.edu/resources/pension-choice-model.html "]
["This spreadsheet is intended to help new UC employees hired after July 1, 2016 choose"]
["between Savings Choice, Pension Choice, or Second Choice."]
[]
["All inputs should be entered on the \"Home_Page\" tab, and users are encouraged to experiment"]
["with different values for investment returns, inflation, and retirement age."]
["Note that investment returns and inflation are held constant for the simulations, so"]
["you should choose values that represent reasonable long-run values. The UC Investment Office"]
["currently assumes a 6.75% investment return and 2.5% inflation.  Note that you must choose"]
["values so that investment return is strictly greater than inflation and both are greater than"]
["zero. Entering other values will lead to erroneous calculations.  The \"2016 Pension Choice"]
["Model\" page (see link on line 4) provides some historical data on investment returns and"]
["inflation that will help you choose reasonable values for these key inputs."]
[]
["The \"Year of Second Choice Election\" is the year of UC employment when you elect to switch"]
["from Savings to Pension choice.  The election is effective the next year."]
[]
["The \"Annuity End Age\" controls the age when the withdrawals from retirement"]
["savings balances lead to zero balances.  This should generally be at least 100 years for"]
["a single retiree, but employees with younger spouses should set a higher value if they"]
["expect their retirement savings to last for their spouse's life."]
[]
["Note that macros must be enabled for this spreadsheet to work, and you must"]
["click the \"GO!\" button on the Home_Page each time you change any of the input values."]
[]
["The detailed computations are carried out on tab \"Sheet1,\" and there is a full description at"]
["https://senate.universityofcalifornia.edu/_files/committees/tfir/excel-sheet-description.pdf"]
[]
[]
["© David Brownstone, Jim Chalfant, and Daniel Hare 2022"]

{"sheet":"Home_Page","index":1,"n_rows":49,"n_cols":9,"rows_kept":49}
["TFIR 2016 Pension Choice Model Version 4.2"]
[null,"March 31, 2022"]
["Faculty Title? (Yes/No)",null,null,"yes",null,"Average Rate of Return (%)",null,null,6.75]
["Starting Age at UC:",null,null,35]
["Must be greater than 24",{"$nulls":4},"Average Inflation Rate (%)",null,null,{"v":2.5,"d":"2.50"}]
["Starting Salary",null,null,125000]
["or Covered Compensation",{"$nulls":4},"Year of Second Choice Election",null,null,6]
[{"$nulls":5},"Must be between 5 and 10 years"]
["Minimum Retirement Age",null,null,60]
["Must be at least 60 and less than",null,null,{"$f":"D4+45","v":80},null,"Annuity End Age",null,null,100]
["Prepared For:",null,null,"Your Name Here"]
["If you change any boxed numbers above row 10  you must hit the \"Go!\" button to update calculations"]
["The information below is only valid for UC employees first hired after July 1, 2016"]
{"$rows_empty":31}
["Note: for each age before",null,{"$f":"D9","v":60}," the graphs show the annuitized wealth from UC Retirement"]
["sources if you separate at that age and wait until age",{"$nulls":3},{"$f":"D9","v":60}," to retire."]
["For all ages equal or above  age",null,null,{"$f":"D9","v":60}," the graphs show the UC pension from retiring at that"]
["age plus the annuitized value of the UC Retirement Savings balance starting at that age until"]
["the annuity end age of",null,{"$f":"I10","v":100}]

{"sheet":"Tabular_Output","index":2,"n_rows":64,"n_cols":19,"rows_kept":64}
["All Inputs in the first 8 rows must be changed on the Home_Page ",{"$nulls":9},"last row",null,"Workspace",null,"Percent Income ",null,null,"Annuitization"]
["Faculty Title? (Yes/No)",null,null,"no",null,"Average Rate of Return (%)",null,null,6.75,null,{"$f":"MAX(70,(Home_Page!$D$9+5))-(Home_Page!D4)+2","v":37},"Salary","Age","Savings Choice","Pension Choice","Second Choice","Savings Choice","Pension Choice","Second Choice"]
["Starting Age at UC:",null,null,35,{"$nulls":7},{"$f":"Sheet1!D3","v":125000},{"$f":"Sheet1!A3","v":35},{"$f":"Sheet1!AB3","v":{"v":0,"d":"0%"}},{"$f":"Sheet1!AA3","v":{"v":0,"d":"0%"}},{"$f":"Sheet1!AC3","v":{"v":0,"d":"0%"}},{"$f":"Sheet1!Q3","v":0},{"$f":"Sheet1!Y3","v":0},{"$f":"Sheet1!AP3","v":0}]
[{"$nulls":5},"Average Inflation Rate (%)",null,null,{"v":2.5,"d":"2.50"},null,null,{"$f":"Sheet1!D4","v":{"v":132124.99999999997,"d":"132125"}},{"$f":"Sheet1!A4","v":36},{"$f":"Sheet1!AB4","v":{"v":0.01153766510605773,"d":"1%"}},{"$f":"Sheet1!AA4","v":{"v":3.8458883686859086E-3,"d":"0%"}},{"$f":"Sheet1!AC4","v":{"v":0.01153766510605773,"d":"1%"}},{"$f":"Sheet1!Q4","v":{"v":5251.888475802992,"d":"5252"}},{"$f":"Sheet1!Y4","v":{"v":1750.62949193433,"d":"1751"}},{"$f":"Sheet1!AP4","v":{"v":5251.888475802992,"d":"5252"}}]
["Starting Salary",null,null,{"$f":"Home_Page!$D$6","v":125000},{"$nulls":7},{"$f":"Sheet1!D5","v":{"v":139656.12499999994,"d":"139656"}},{"$f":"Sheet1!A5","v":37},{"$f":"Sheet1!AB5","v":{"v":0.022961844981564065,"d":"2%"}},{"$f":"Sheet1!AA5","v":{"v":0.00768883217392311,"d":"1%"}},{"$f":"Sheet1!AC5","v":{"v":0.022961844981564065,"d":"2%"}},{"$f":"Sheet1!Q5","v":{"v":10452.119032171853,"d":"10452"}},{"$f":"Sheet1!Y5","v":{"v":3499.918633052409,"d":"3500"}},{"$f":"Sheet1!AP5","v":{"v":10452.119032171853,"d":"10452"}}]
["or Covered Compensation",{"$nulls":4},{"$f":"Home_Page!F7","v":"Year of Second Choice Election"},null,null,{"$f":"Home_Page!$I$7","v":6},null,null,{"$f":"Sheet1!D6","v":{"v":147546.69606249992,"d":"147547"}},{"$f":"Sheet1!A6","v":38},{"$f":"Sheet1!AB6","v":{"v":0.034273655874688384,"d":"3%"}},{"$f":"Sheet1!AA6","v":{"v":0.011652744497277765,"d":"1%"}},{"$f":"Sheet1!AC6","v":{"v":0.034273655874688384,"d":"3%"}},{"$f":"Sheet1!Q6","v":{"v":15601.19977978955,"d":"15601"}},{"$f":"Sheet1!Y6","v":{"v":5304.27204934194,"d":"5304"}},{"$f":"Sheet1!AP6","v":{"v":15601.19977978955,"d":"15601"}}]
[{"$f":"Home_Page!A9","v":"Minimum Retirement Age"},null,null,{"$f":"Home_Page!D9","v":60},null,"Annuity End Age",null,null,{"$f":"Home_Page!I10","v":100},null,null,{"$f":"Sheet1!D7","v":{"v":155883.08439003114,"d":"155883"}},{"$f":"Sheet1!A7","v":39},{"$f":"Sheet1!AB7","v":{"v":0.045468904782028745,"d":"5%"}},{"$f":"Sheet1!AA7","v":{"v":0.015725875893947788,"d":"2%"}},{"$f":"Sheet1!AC7","v":{"v":0.045468904782028745,"d":"5%"}},{"$f":"Sheet1!Q7","v":{"v":20697.222084106266,"d":"20697"}},{"$f":"Sheet1!Y7","v":{"v":7158.341451249887,"d":"7158"}},{"$f":"Sheet1!AP7","v":{"v":20697.222084106266,"d":"20697"}}]
["Prepared For:",null,null,{"$f":"Home_Page!$D$11","v":"Your Name Here"},{"$nulls":7},{"$f":"Sheet1!D8","v":{"v":164690.47865806788,"d":"164690"}},{"$f":"Sheet1!A8","v":40},{"$f":"Sheet1!AB8","v":{"v":0.056548792810698606,"d":"6%"}},{"$f":"Sheet1!AA8","v":{"v":0.04717299578730008,"d":"5%"}},{"$f":"Sheet1!AC8","v":{"v":0.056548792810698606,"d":"6%"}},{"$f":"Sheet1!Q8","v":{"v":25740.73268317943,"d":"25741"}},{"$f":"Sheet1!Y8","v":{"v":21472.915938108417,"d":"21473"}},{"$f":"Sheet1!AP8","v":{"v":25740.73268317943,"d":"25741"}}]
[{"$f":"Sheet1!A1","v":"The information below is only valid for UC employees first hired after July 1, 2016"},{"$nulls":10},{"$f":"Sheet1!D9","v":{"v":173995.49070224867,"d":"173995"}},{"$f":"Sheet1!A9","v":41},{"$f":"Sheet1!AB9","v":{"v":0.06751450869106368,"d":"7%"}},{"$f":"Sheet1!AA9","v":{"v":0.05771610651957556,"d":"6%"}},{"$f":"Sheet1!AC9","v":{"v":0.06751450869106368,"d":"7%"}},{"$f":"Sheet1!Q9","v":{"v":30732.272681231705,"d":"30732"}},{"$f":"Sheet1!Y9","v":{"v":26272.08814886017,"d":"26272"}},{"$f":"Sheet1!AP9","v":{"v":30732.272681231705,"d":"30732"}}]
[null,null,"Percent of Income Replacement",{"$nulls":3},"Annuitization",{"$nulls":4},{"$f":"Sheet1!D10","v":{"v":183739.23818157456,"d":"183739"}},{"$f":"Sheet1!A10","v":42},{"$f":"Sheet1!AB10","v":{"v":0.07836722890427747,"d":"8%"}},{"$f":"Sheet1!AA10","v":{"v":0.06864463850970141,"d":"7%"}},{"$f":"Sheet1!AC10","v":{"v":0.07760443069864892,"d":"8%"}},{"$f":"Sheet1!Q10","v":{"v":35672.377606704526,"d":"35672"}},{"$f":"Sheet1!Y10","v":{"v":31246.702222746877,"d":"31247"}},{"$f":"Sheet1!AP10","v":{"v":35325.15561086064,"d":"35325"}}]
["Salary","Separation Age","Savings Choice","Pension Choice","Second Choice","Savings Choice","Pension Choice","Second Choice",{"$nulls":3},{"$f":"Sheet1!D12","v":{"v":204797.2247910884,"d":"204797"}},{"$f":"Sheet1!A12","v":44},{"$f":"Sheet1!AB12","v":{"v":0.09972318518079647,"d":"10%"}},{"$f":"Sheet1!AA12","v":{"v":0.09166530423562817,"d":"9%"}},{"$f":"Sheet1!AC12","v":{"v":0.09888445657956474,"d":"10%"}},{"$f":"Sheet1!Q12","v":{"v":45393.503989504,"d":"45394"}},{"$f":"Sheet1!Y12","v":{"v":41725.59616878708,"d":"41726"}},{"$f":"Sheet1!AP12","v":{"v":45011.718850600766,"d":"45012"}}]
[125000,35,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0,{"$nulls":3},{"$f":"Sheet1!D13","v":{"v":216061.0721545982,"d":"216061"}},{"$f":"Sheet1!A13","v":45},{"$f":"Sheet1!AB13","v":{"v":0.11022395236830648,"d":"11%"}},{"$f":"Sheet1!AA13","v":{"v":0.10376494102049676,"d":"10%"}},{"$f":"Sheet1!AC13","v":{"v":0.11008100213620393,"d":"11%"}},{"$f":"Sheet1!Q13","v":{"v":50173.4016266974,"d":"50173"}},{"$f":"Sheet1!Y13","v":{"v":47233.291392016356,"d":"47233"}},{"$f":"Sheet1!AP13","v":{"v":50108.33138330833,"d":"50108"}}]
[{"v":132124.99999999997,"d":"132125"},36,{"v":0.01153766510605773,"d":"1%"},{"v":3.8458883686859086E-3,"d":"0%"},{"v":0.01153766510605773,"d":"1%"},{"v":5251.888475802992,"d":"5252"},{"v":1750.62949193433,"d":"1751"},{"v":5251.888475802992,"d":"5252"},{"$nulls":3},{"$f":"Sheet1!D14","v":{"v":227728.37005094645,"d":"227728"}},{"$f":"Sheet1!A14","v":46},{"$f":"Sheet1!AB14","v":{"v":0.12060175975268411,"d":"12%"}},{"$f":"Sheet1!AA14","v":{"v":0.11626098458847302,"d":"12%"}},{"$f":"Sheet1!AC14","v":{"v":0.12165137719524503,"d":"12%"}},{"$f":"Sheet1!Q14","v":{"v":54897.328565563024,"d":"54897"}},{"$f":"Sheet1!Y14","v":{"v":52921.429035509704,"d":"52921"}},{"$f":"Sheet1!AP14","v":{"v":55375.1092690169,"d":"55375"}}]
[{"v":139656.12499999994,"d":"139656"},37,{"v":0.022961844981564065,"d":"2%"},{"v":0.00768883217392311,"d":"1%"},{"v":0.022961844981564065,"d":"2%"},{"v":10452.119032171853,"d":"10452"},{"v":3499.918633052409,"d":"3500"},{"v":10452.119032171853,"d":"10452"},{"$nulls":3},{"$f":"Sheet1!D15","v":{"v":240025.7020336975,"d":"240026"}},{"$f":"Sheet1!A15","v":47},{"$f":"Sheet1!AB15","v":{"v":0.13084832554484707,"d":"13%"}},{"$f":"Sheet1!AA15","v":{"v":0.1291531614550834,"d":"13%"}},{"$f":"Sheet1!AC15","v":{"v":0.13359474384019684,"d":"13%"}},{"$f":"Sheet1!Q15","v":{"v":59561.51497639614,"d":"59562"}},{"$f":"Sheet1!Y15","v":{"v":58789.884610478286,"d":"58790"}},{"$f":"Sheet1!AP15","v":{"v":60811.67109225608,"d":"60812"}}]
[{"v":147546.69606249992,"d":"147547"},38,{"v":0.034273655874688384,"d":"3%"},{"v":0.011652744497277765,"d":"1%"},{"v":0.034273655874688384,"d":"3%"},{"v":15601.19977978955,"d":"15601"},{"v":5304.27204934194,"d":"5304"},{"v":15601.19977978955,"d":"15601"},{"$nulls":3},{"$f":"Sheet1!D16","v":{"v":252747.0642414834,"d":"252747"}},{"$f":"Sheet1!A16","v":48},{"$f":"Sheet1!AB16","v":{"v":0.14096530947453306,"d":"14%"}},{"$f":"Sheet1!AA16","v":{"v":0.14244979969822244,"d":"14%"}},{"$f":"Sheet1!AC16","v":{"v":0.14591885160613588,"d":"15%"}},{"$f":"Sheet1!Q16","v":{"v":64166.716360019665,"d":"64167"}},{"$f":"Sheet1!Y16","v":{"v":64842.4490170668,"d":"64842"}},{"$f":"Sheet1!AP16","v":{"v":66421.54440332197,"d":"66422"}}]
[{"v":155883.08439003114,"d":"155883"},39,{"v":0.045468904782028745,"d":"5%"},{"v":0.015725875893947788,"d":"2%"},{"v":0.045468904782028745,"d":"5%"},{"v":20697.222084106266,"d":"20697"},{"v":7158.341451249887,"d":"7158"},{"v":20697.222084106266,"d":"20697"},{"$nulls":3},{"$f":"Sheet1!D17","v":{"v":265889.9115820405,"d":"265890"}},{"$f":"Sheet1!A17","v":49},{"$f":"Sheet1!AB17","v":{"v":0.15094487301360504,"d":"15%"}},{"$f":"Sheet1!AA17","v":{"v":0.15615228010473514,"d":"16%"}},{"$f":"Sheet1!AC17","v":{"v":0.1586244882735186,"d":"16%"}},{"$f":"Sheet1!Q17","v":{"v":68709.36465693354,"d":"68709"}},{"$f":"Sheet1!Y17","v":{"v":71079.75078266376,"d":"71080"}},{"$f":"Sheet1!AP17","v":{"v":72205.08779600824,"d":"72205"}}]
[{"v":164690.47865806788,"d":"164690"},40,{"v":0.056548792810698606,"d":"6%"},{"v":0.04717299578730008,"d":"5%"},{"v":0.056548792810698606,"d":"6%"},{"v":25740.73268317943,"d":"25741"},{"v":21472.915938108417,"d":"21473"},{"v":25740.73268317943,"d":"25741"},{"$nulls":3},{"$f":"Sheet1!D18","v":{"v":279450.2970727245,"d":"279450"}},{"$f":"Sheet1!A18","v":50},{"$f":"Sheet1!AB18","v":{"v":0.16077953422494343,"d":"16%"}},{"$f":"Sheet1!AA18","v":{"v":0.17026292377505262,"d":"17%"}},{"$f":"Sheet1!AC18","v":{"v":0.1717133671112278,"d":"17%"}},{"$f":"Sheet1!Q18","v":{"v":73186.05412611706,"d":"73186"}},{"$f":"Sheet1!Y18","v":{"v":77502.84646078268,"d":"77503"}},{"$f":"Sheet1!AP18","v":{"v":78163.0811418937,"d":"78163"}}]
[{"v":173995.49070224867,"d":"173995"},41,{"v":0.06751450869106368,"d":"7%"},{"v":0.05771610651957556,"d":"6%"},{"v":0.06751450869106368,"d":"7%"},{"v":30732.272681231705,"d":"30732"},{"v":26272.08814886017,"d":"26272"},{"v":30732.272681231705,"d":"30732"},{"$nulls":3},{"$f":"Sheet1!D19","v":{"v":293422.81192636065,"d":"293423"}},{"$f":"Sheet1!A19","v":51},{"$f":"Sheet1!AB19","v":{"v":0.17046218427938523,"d":"17%"}},{"$f":"Sheet1!AA19","v":{"v":0.18478500981548845,"d":"18%"}},{"$f":"Sheet1!AC19","v":{"v":0.18518814419824017,"d":"19%"}},{"$f":"Sheet1!Q19","v":{"v":77593.54886345839,"d":"77594"}},{"$f":"Sheet1!Y19","v":{"v":84113.22868450839,"d":"84113"}},{"$f":"Sheet1!AP19","v":{"v":84296.73347508011,"d":"84297"}}]
[{"v":183739.23818157456,"d":"183739"},42,{"v":0.07836722890427747,"d":"8%"},{"v":0.06864463850970141,"d":"7%"},{"v":0.07760443069864892,"d":"8%"},{"v":35672.377606704526,"d":"35672"},{"v":31246.702222746877,"d":"31247"},{"v":35325.15561086064,"d":"35325"},{"$nulls":3},{"$f":"Sheet1!D20","v":{"v":308093.95252267865,"d":"308094"}},{"$f":"Sheet1!A20","v":52},{"$f":"Sheet1!AB20","v":{"v":0.17998610236572146,"d":"18%"}},{"$f":"Sheet1!AA20","v":{"v":0.19972279249475877,"d":"20%"}},{"$f":"Sheet1!AC20","v":{"v":0.19905243520025145,"d":"20%"}},{"$f":"Sheet1!Q20","v":{"v":81928.78958871217,"d":"81929"}},{"$f":"Sheet1!Y20","v":{"v":90912.83397606076,"d":"90913"}},{"$f":"Sheet1!AP20","v":{"v":90607.6906288297,"d":"90608"}}]
[{"v":204797.2247910884,"d":"204797"},44,{"v":0.09972318518079647,"d":"10%"},{"v":0.09166530423562817,"d":"9%"},{"v":0.09888445657956474,"d":"10%"},{"v":45393.503989504,"d":"45394"},{"v":41725.59616878708,"d":"41726"},{"v":45011.718850600766,"d":"45012"},{"$nulls":3},{"$f":"Sheet1!D21","v":{"v":323498.6501488125,"d":"323499"}},{"$f":"Sheet1!A21","v":53},{"$f":"Sheet1!AB21","v":{"v":0.18935389064736363,"d":"19%"}},{"$f":"Sheet1!AA21","v":{"v":0.21508865518507014,"d":"22%"}},{"$f":"Sheet1!AC21","v":{"v":0.2133179689213723,"d":"21%"}},{"$f":"Sheet1!Q21","v":{"v":86192.9607938798,"d":"86193"}},{"$f":"Sheet1!Y21","v":{"v":97907.29918563309,"d":"97907"}},{"$f":"Sheet1!AP21","v":{"v":97101.29149715419,"d":"97101"}}]
[{"v":216061.0721545982,"d":"216061"},45,{"v":0.11022395236830648,"d":"11%"},{"v":0.10376494102049676,"d":"10%"},{"v":0.11008100213620393,"d":"11%"},{"v":50173.4016266974,"d":"50173"},{"v":47233.291392016356,"d":"47233"},{"v":50108.33138330833,"d":"50108"},{"$nulls":3},{"$f":"Sheet1!D22","v":{"v":339673.5826562531,"d":"339674"}},{"$f":"Sheet1!A22","v":54},{"$f":"Sheet1!AB22","v":{"v":0.1985681086293068,"d":"20%"}},{"$f":"Sheet1!AA22","v":{"v":0.23089562457701845,"d":"23%"}},{"$f":"Sheet1!AC22","v":{"v":0.22799710111990035,"d":"23%"}},{"$f":"Sheet1!Q22","v":{"v":90387.22755306111,"d":"90387"}},{"$f":"Sheet1!Y22","v":{"v":105102.5539987891,"d":"105103"}},{"$f":"Sheet1!AP22","v":{"v":103783.16036053115,"d":"103783"}}]
[{"v":227728.37005094645,"d":"227728"},46,{"v":0.12060175975268411,"d":"12%"},{"v":0.11626098458847302,"d":"12%"},{"v":0.12165137719524503,"d":"12%"},{"v":54897.328565563024,"d":"54897"},{"v":52921.429035509704,"d":"52921"},{"v":55375.1092690169,"d":"55375"},{"$nulls":3},{"$f":"Sheet1!D23","v":{"v":356657.26178906567,"d":"356657"}},{"$f":"Sheet1!A23","v":55},{"$f":"Sheet1!AB23","v":{"v":0.20763127385744756,"d":"21%"}},{"$f":"Sheet1!AA23","v":{"v":0.24715737870516152,"d":"25%"}},{"$f":"Sheet1!AC23","v":{"v":0.24310282212478765,"d":"24%"}},{"$f":"Sheet1!Q23","v":{"v":94512.73584078041,"d":"94513"}},{"$f":"Sheet1!Y23","v":{"v":112504.82458966415,"d":"112505"}},{"$f":"Sheet1!AP23","v":{"v":110659.21035288268,"d":"110659"}}]
[{"v":240025.7020336975,"d":"240026"},47,{"v":0.13084832554484707,"d":"13%"},{"v":0.1291531614550834,"d":"13%"},{"v":0.13359474384019684,"d":"13%"},{"v":59561.51497639614,"d":"59562"},{"v":58789.884610478286,"d":"58790"},{"v":60811.67109225608,"d":"60812"},{"$nulls":3},{"$f":"Sheet1!D24","v":{"v":374490.12487851887,"d":"374490"}},{"$f":"Sheet1!A24","v":56},{"$f":"Sheet1!AB24","v":{"v":0.21654586260643843,"d":"22%"}},{"$f":"Sheet1!AA24","v":{"v":0.26388825570928726,"d":"26%"}},{"$f":"Sheet1!AC24","v":{"v":0.2586487651775761,"d":"26%"}},{"$f":"Sheet1!Q24","v":{"v":98570.61284509445,"d":"98571"}},{"$f":"Sheet1!Y24","v":{"v":120120.63760905145,"d":"120121"}},{"$f":"Sheet1!AP24","v":{"v":117735.64725878337,"d":"117736"}}]
[{"v":252747.0642414834,"d":"252747"},48,{"v":0.14096530947453306,"d":"14%"},{"v":0.14244979969822244,"d":"14%"},{"v":0.14591885160613588,"d":"15%"},{"v":64166.716360019665,"d":"64167"},{"v":64842.4490170668,"d":"64842"},{"v":66421.54440332197,"d":"66422"},{"$nulls":3},{"$f":"Sheet1!D25","v":{"v":393214.63112244476,"d":"393215"}},{"$f":"Sheet1!A25","v":57},{"$f":"Sheet1!AB25","v":{"v":0.2253143105562656,"d":"23%"}},{"$f":"Sheet1!AA25","v":{"v":0.28110326333245317,"d":"28%"}},{"$f":"Sheet1!AC25","v":{"v":0.2746492155006214,"d":"27%"}},{"$f":"Sheet1!Q25","v":{"v":102561.96727556731,"d":"102562"}},{"$f":"Sheet1!Y25","v":{"v":127956.82450786309,"d":"127957"}},{"$f":"Sheet1!AP25","v":{"v":125018.97364127121,"d":"125019"}}]
[{"v":265889.9115820405,"d":"265890"},49,{"v":0.15094487301360504,"d":"15%"},{"v":0.15615228010473514,"d":"16%"},{"v":0.1586244882735186,"d":"16%"},{"v":68709.36465693354,"d":"68709"},{"v":71079.75078266376,"d":"71080"},{"v":72205.08779600824,"d":"72205"},{"$nulls":3},{"$f":"Sheet1!D26","v":{"v":412875.36267856695,"d":"412875"}},{"$f":"Sheet1!A26","v":58},{"$f":"Sheet1!AB26","v":{"v":0.2339390134577349,"d":"23%"}},{"$f":"Sheet1!AA26","v":{"v":0.2988180891577154,"d":"30%"}},{"$f":"Sheet1!AC26","v":{"v":0.2911191200932601,"d":"29%"}},{"$f":"Sheet1!Q26","v":{"v":106487.88966619634,"d":"106488"}},{"$f":"Sheet1!Y26","v":{"v":136020.52619683865,"d":"136021"}},{"$f":"Sheet1!AP26","v":{"v":132515.99330101494,"d":"132516"}}]
[{"v":279450.2970727245,"d":"279450"},50,{"v":0.16077953422494343,"d":"16%"},{"v":0.17026292377505262,"d":"17%"},{"v":0.1717133671112278,"d":"17%"},{"v":73186.05412611706,"d":"73186"},{"v":77502.84646078268,"d":"77503"},{"v":78163.0811418937,"d":"78163"},{"$nulls":3},{"$f":"Sheet1!D27","v":{"v":433519.13081249525,"d":"433519"}},{"$f":"Sheet1!A27","v":59},{"$f":"Sheet1!AB27","v":{"v":0.242422327787049,"d":"24%"}},{"$f":"Sheet1!AA27","v":{"v":0.3170491115862925,"d":"32%"}},{"$f":"Sheet1!AC27","v":{"v":0.30807409825839793,"d":"31%"}},{"$f":"Sheet1!Q27","v":{"v":110349.45267337243,"d":"110349"}},{"$f":"Sheet1!Y27","v":{"v":144319.19804375147,"d":"144319"}},{"$f":"Sheet1!AP27","v":{"v":140233.8160679651,"d":"140234"}}]
[{"v":293422.81192636065,"d":"293423"},51,{"v":0.17046218427938523,"d":"17%"},{"v":0.18478500981548845,"d":"18%"},{"v":0.18518814419824017,"d":"19%"},{"v":77593.54886345839,"d":"77594"},{"v":84113.22868450839,"d":"84113"},{"v":84296.73347508011,"d":"84297"},{"$nulls":3},{"$f":"Sheet1!D28","v":{"v":455195.0873531199,"d":"455195"}},{"$f":"Sheet1!A28","v":60},{"$f":"Sheet1!AB28","v":{"v":0.250766571389653,"d":"25%"}},{"$f":"Sheet1!AA28","v":{"v":0.33581341156073075,"d":"34%"}},{"$f":"Sheet1!AC28","v":{"v":0.32553045286281107,"d":"33%"}},{"$f":"Sheet1!Q28","v":{"v":114147.71136895548,"d":"114148"}},{"$f":"Sheet1!Y28","v":{"v":152860.61520973605,"d":"152861"}},{"$f":"Sheet1!AP28","v":{"v":148179.86292698796,"d":"148180"}}]
[{"v":308093.95252267865,"d":"308094"},52,{"v":0.17998610236572146,"d":"18%"},{"v":0.19972279249475877,"d":"20%"},{"v":0.19905243520025145,"d":"20%"},{"v":81928.78958871217,"d":"81929"},{"v":90912.83397606076,"d":"90913"},{"v":90607.6906288297,"d":"90608"},{"$nulls":3},{"$f":"Sheet1!D29","v":{"v":477499.64663342264,"d":"477500"}},{"$f":"Sheet1!A29","v":61},{"$f":"Sheet1!AB29","v":{"v":0.2659338565864137,"d":"27%"}},{"$f":"Sheet1!AA29","v":{"v":0.3648058645936443,"d":"36%"}},{"$f":"Sheet1!AC29","v":{"v":0.3528391611278544,"d":"35%"}},{"$f":"Sheet1!Q29","v":{"v":126983.32254787584,"d":"126983"}},{"$f":"Sheet1!Y29","v":{"v":174194.67143326538,"d":"174195"}},{"$f":"Sheet1!AP29","v":{"v":168480.57475698375,"d":"168481"}}]
[{"v":323498.6501488125,"d":"323499"},53,{"v":0.18935389064736363,"d":"19%"},{"v":0.21508865518507014,"d":"22%"},{"v":0.2133179689213723,"d":"21%"},{"v":86192.9607938798,"d":"86193"},{"v":97907.29918563309,"d":"97907"},{"v":97101.29149715419,"d":"97101"},{"$nulls":3},{"$f":"Sheet1!D30","v":{"v":500419.62967182684,"d":"500420"}},{"$f":"Sheet1!A30","v":62},{"$f":"Sheet1!AB30","v":{"v":0.28199750935079915,"d":"28%"}},{"$f":"Sheet1!AA30","v":{"v":0.3947737244659129,"d":"39%"}},{"$f":"Sheet1!AC30","v":{"v":0.38132344989860667,"d":"38%"}},{"$f":"Sheet1!Q30","v":{"v":141117.08919770442,"d":"141117"}},{"$f":"Sheet1!Y30","v":{"v":197552.52100139996,"d":"197553"}},{"$f":"Sheet1!AP30","v":{"v":190821.73958344417,"d":"190822"}}]
[{"v":339673.5826562531,"d":"339674"},54,{"v":0.1985681086293068,"d":"20%"},{"v":0.23089562457701845,"d":"23%"},{"v":0.22799710111990035,"d":"23%"},{"v":90387.22755306111,"d":"90387"},{"v":105102.5539987891,"d":"105103"},{"v":103783.16036053115,"d":"103783"},{"$nulls":3},{"$f":"Sheet1!D31","v":{"v":523939.35226640257,"d":"523939"}},{"$f":"Sheet1!A31","v":63},{"$f":"Sheet1!AB31","v":{"v":0.2990462980868023,"d":"30%"}},{"$f":"Sheet1!AA31","v":{"v":0.4257715660822829,"d":"43%"}},{"$f":"Sheet1!AC31","v":{"v":0.4110328307354945,"d":"41%"}},{"$f":"Sheet1!Q31","v":{"v":156682.12371726474,"d":"156682"}},{"$f":"Sheet1!Y31","v":{"v":223078.47854660312,"d":"223078"}},{"$f":"Sheet1!AP31","v":{"v":215356.27509578087,"d":"215356"}}]
[{"v":356657.26178906567,"d":"356657"},55,{"v":0.20763127385744756,"d":"21%"},{"v":0.24715737870516152,"d":"25%"},{"v":0.24310282212478765,"d":"24%"},{"v":94512.73584078041,"d":"94513"},{"v":112504.82458966415,"d":"112505"},{"v":110659.21035288268,"d":"110659"},{"$nulls":3},{"$f":"Sheet1!D32","v":{"v":548040.5624706569,"d":"548041"}},{"$f":"Sheet1!A32","v":64},{"$f":"Sheet1!AB32","v":{"v":0.31717920274285055,"d":"32%"}},{"$f":"Sheet1!AA32","v":{"v":0.4578642839713645,"d":"46%"}},{"$f":"Sheet1!AC32","v":{"v":0.4420289511821279,"d":"44%"}},{"$f":"Sheet1!Q32","v":{"v":173827.06867518634,"d":"173827"}},{"$f":"Sheet1!Y32","v":{"v":250928.1997228912,"d":"250928"}},{"$f":"Sheet1!AP32","v":{"v":242249.79503416794,"d":"242250"}}]
[{"v":374490.12487851887,"d":"374490"},56,{"v":0.21654586260643843,"d":"22%"},{"v":0.26388825570928726,"d":"26%"},{"v":0.2586487651775761,"d":"26%"},{"v":98570.61284509445,"d":"98571"},{"v":120120.63760905145,"d":"120121"},{"v":117735.64725878337,"d":"117736"},{"$nulls":3},{"$f":"Sheet1!D33","v":{"v":572702.3877818363,"d":"572702"}},{"$f":"Sheet1!A33","v":65},{"$f":"Sheet1!AB33","v":{"v":0.3365069313737638,"d":"34%"}},{"$f":"Sheet1!AA33","v":{"v":0.49112760956458834,"d":"49%"}},{"$f":"Sheet1!AC33","v":{"v":0.4743861720673088,"d":"47%"}},{"$f":"Sheet1!Q33","v":{"v":192718.32310289307,"d":"192718"}},{"$f":"Sheet1!Y33","v":{"v":281269.9547032252,"d":"281270"}},{"$f":"Sheet1!AP33","v":{"v":271682.0934736328,"d":"271682"}}]
[{"v":393214.63112244476,"d":"393215"},57,{"v":0.2253143105562656,"d":"23%"},{"v":0.28110326333245317,"d":"28%"},{"v":0.2746492155006214,"d":"27%"},{"v":102561.96727556731,"d":"102562"},{"v":127956.82450786309,"d":"127957"},{"v":125018.97364127121,"d":"125019"},{"$nulls":3},{"$f":"Sheet1!D34","v":{"v":597042.2392625642,"d":"597042"}},{"$f":"Sheet1!A34","v":66},{"$f":"Sheet1!AB34","v":{"v":0.35766759649819513,"d":"36%"}},{"$f":"Sheet1!AA34","v":{"v":0.5073516326563986,"d":"51%"}},{"$f":"Sheet1!AC34","v":{"v":0.49355784163489547,"d":"49%"}},{"$f":"Sheet1!Q34","v":{"v":213542.66272494168,"d":"213543"}},{"$f":"Sheet1!Y34","v":{"v":302910.3548546941,"d":"302910"}},{"$f":"Sheet1!AP34","v":{"v":294674.87897529604,"d":"294675"}}]
[{"v":412875.36267856695,"d":"412875"},58,{"v":0.2339390134577349,"d":"23%"},{"v":0.2988180891577154,"d":"30%"},{"v":0.2911191200932601,"d":"29%"},{"v":106487.88966619634,"d":"106488"},{"v":136020.52619683865,"d":"136021"},{"v":132515.99330101494,"d":"132516"},{"$nulls":3},{"$f":"Sheet1!D35","v":{"v":622416.5344312231,"d":"622417"}},{"$f":"Sheet1!A35","v":67},{"$f":"Sheet1!AB35","v":{"v":0.3799741972141416,"d":"38%"}},{"$f":"Sheet1!AA35","v":{"v":0.5239189207473479,"d":"52%"}},{"$f":"Sheet1!AC35","v":{"v":0.5131584864090927,"d":"51%"}},{"$f":"Sheet1!Q35","v":{"v":236502.2230033121,"d":"236502"}},{"$f":"Sheet1!Y35","v":{"v":326095.7989745109,"d":"326096"}},{"$f":"Sheet1!AP35","v":{"v":319398.3267247193,"d":"319398"}}]
[{"v":433519.13081249525,"d":"433519"},59,{"v":0.242422327787049,"d":"24%"},{"v":0.3170491115862925,"d":"32%"},{"v":0.30807409825839793,"d":"31%"},{"v":110349.45267337243,"d":"110349"},{"v":144319.19804375147,"d":"144319"},{"v":140233.8160679651,"d":"140234"},{"$nulls":3},{"$f":"Sheet1!D36","v":{"v":648869.2371445498,"d":"648869"}},{"$f":"Sheet1!A36","v":68},{"$f":"Sheet1!AB36","v":{"v":0.40353051510779764,"d":"40%"}},{"$f":"Sheet1!AA36","v":{"v":0.540891560771352,"d":"54%"}},{"$f":"Sheet1!AC36","v":{"v":0.5332601073920745,"d":"53%"}},{"$f":"Sheet1!Q36","v":{"v":261838.5375025439,"d":"261839"}},{"$f":"Sheet1!Y36","v":{"v":350967.8944156321,"d":"350968"}},{"$f":"Sheet1!AP36","v":{"v":346016.0790831161,"d":"346016"}}]
[{"v":455195.0873531199,"d":"455195"},60,{"v":0.250766571389653,"d":"25%"},{"v":0.33581341156073075,"d":"34%"},{"v":0.32553045286281107,"d":"33%"},{"v":114147.71136895548,"d":"114148"},{"v":152860.61520973605,"d":"152861"},{"v":148179.86292698796,"d":"148180"},{"$nulls":3},{"$f":"Sheet1!D37","v":{"v":676446.179723193,"d":"676446"}},{"$f":"Sheet1!A37","v":69},{"$f":"Sheet1!AB37","v":{"v":0.4284537579019699,"d":"43%"}},{"$f":"Sheet1!AA37","v":{"v":0.5583385250137404,"d":"56%"}},{"$f":"Sheet1!AC37","v":{"v":0.5539428256698667,"d":"55%"}},{"$f":"Sheet1!Q37","v":{"v":289825.9077208334,"d":"289826"}},{"$f":"Sheet1!Y37","v":{"v":377685.96223782713,"d":"377686"}},{"$f":"Sheet1!AP37","v":{"v":374712.5082094521,"d":"374713"}}]
[{"v":477499.64663342264,"d":"477500"},61,{"v":0.2659338565864137,"d":"27%"},{"v":0.3648058645936443,"d":"36%"},{"v":0.3528391611278544,"d":"35%"},{"v":126983.32254787584,"d":"126983"},{"v":174194.67143326538,"d":"174195"},{"v":168480.57475698375,"d":"168481"},{"$nulls":3},{"$f":"Sheet1!D38","v":{"v":705195.1423614286,"d":"705195"}},{"$f":"Sheet1!A38","v":70},{"$f":"Sheet1!AB38","v":{"v":0.45480685712460955,"d":"45%"}},{"$f":"Sheet1!AA38","v":{"v":0.5762808993926545,"d":"58%"}},{"$f":"Sheet1!AC38","v":{"v":0.5752403177241391,"d":"58%"}},{"$f":"Sheet1!Q38","v":{"v":320727.58635694295,"d":"320728"}},{"$f":"Sheet1!Y38","v":{"v":406390.4908873751,"d":"406390"}},{"$f":"Sheet1!AP38","v":{"v":405656.67774950765,"d":"405657"}}]
[{"v":500419.62967182684,"d":"500420"},62,{"v":0.28199750935079915,"d":"28%"},{"v":0.3947737244659129,"d":"39%"},{"v":0.38132344989860667,"d":"38%"},{"v":141117.08919770442,"d":"141117"},{"v":197552.52100139996,"d":"197553"},{"v":190821.73958344417,"d":"190822"},{"$nulls":3},{"$f":"Sheet1!D39","v":{"v":735165.9359117892,"d":"735166"}},{"$f":"Sheet1!A39","v":71},{"$f":"Sheet1!AB39","v":{"v":0.4826468933975643,"d":"48%"}},{"$f":"Sheet1!AA39","v":{"v":0.5947298867776578,"d":"59%"}},{"$f":"Sheet1!AC39","v":{"v":0.5971780685970423,"d":"60%"}},{"$f":"Sheet1!Q39","v":{"v":354825.5550995379,"d":"354826"}},{"$f":"Sheet1!Y39","v":{"v":437225.15382760926,"d":"437225"}},{"$f":"Sheet1!AP39","v":{"v":439024.97370613925,"d":"439025"}}]
[{"v":523939.35226640257,"d":"523939"},63,{"v":0.2990462980868023,"d":"30%"},{"v":0.4257715660822829,"d":"43%"},{"v":0.4110328307354945,"d":"41%"},{"v":156682.12371726474,"d":"156682"},{"v":223078.47854660312,"d":"223078"},{"v":215356.27509578087,"d":"215356"},{"$nulls":3},{"$f":"Sheet1!D40","v":{"v":766410.4881880401,"d":"766410"}},{"$f":"Sheet1!A40","v":72},{"$f":"Sheet1!AB40","v":{"v":0.5121369018482446,"d":"51%"}},{"$f":"Sheet1!AA40","v":{"v":0.6137753556061779,"d":"61%"}},{"$f":"Sheet1!AC40","v":{"v":0.6198622238734952,"d":"62%"}},{"$f":"Sheet1!Q40","v":{"v":392507.09296462353,"d":"392507"}},{"$f":"Sheet1!Y40","v":{"v":470403.8699279187,"d":"470404"}},{"$f":"Sheet1!AP40","v":{"v":475068.9096082097,"d":"475069"}}]
[{"v":548040.5624706569,"d":"548041"},64,{"v":0.31717920274285055,"d":"32%"},{"v":0.4578642839713645,"d":"46%"},{"v":0.4420289511821279,"d":"44%"},{"v":173827.06867518634,"d":"173827"},{"v":250928.1997228912,"d":"250928"},{"v":242249.79503416794,"d":"242250"},{"$nulls":3},{"$f":"Sheet1!D41","v":{"v":798982.9339360317,"d":"798983"}},{"$f":"Sheet1!A41","v":73},{"$f":"Sheet1!AB41","v":{"v":0.5434639748553275,"d":"54%"}},{"$f":"Sheet1!AA41","v":{"v":0.6335192264198006,"d":"63%"}},{"$f":"Sheet1!AC41","v":{"v":0.6434133469781868,"d":"64%"}},{"$f":"Sheet1!Q41","v":{"v":434218.4411184473,"d":"434218"}},{"$f":"Sheet1!Y41","v":{"v":506171.05022977747,"d":"506171"}},{"$f":"Sheet1!AP41","v":{"v":514076.28370223363,"d":"514076"}}]
[{"v":572702.3877818363,"d":"572702"},65,{"v":0.3365069313737638,"d":"34%"},{"v":0.49112760956458834,"d":"49%"},{"v":0.4743861720673088,"d":"47%"},{"v":192718.32310289307,"d":"192718"},{"v":281269.9547032252,"d":"281270"},{"v":271682.0934736328,"d":"271682"},{"$nulls":3},{"$f":"Sheet1!D42","v":{"v":832939.7086283128,"d":"832940"}},{"$f":"Sheet1!A42","v":74},{"$f":"Sheet1!AB42","v":{"v":0.5768438944844244,"d":"58%"}},{"$f":"Sheet1!AA42","v":{"v":0.6540778283972477,"d":"65%"}},{"$f":"Sheet1!AC42","v":{"v":0.6679692320086489,"d":"67%"}},{"$f":"Sheet1!Q42","v":{"v":480476.1853958777,"d":"480476"}},{"$f":"Sheet1!Y42","v":{"v":544807.395805443,"d":"544807"}},{"$f":"Sheet1!AP42","v":{"v":556378.0974819618,"d":"556378"}}]
[{"v":597042.2392625642,"d":"597042"},66,{"v":0.35766759649819513,"d":"36%"},{"v":0.5073516326563986,"d":"51%"},{"v":0.49355784163489547,"d":"49%"},{"v":213542.66272494168,"d":"213543"},{"v":302910.3548546941,"d":"302910"},{"v":294674.87897529604,"d":"294675"},{"$nulls":3},{"$f":"Sheet1!D43","v":{"v":868339.6462450159,"d":"868340"}},{"$f":"Sheet1!A43","v":75},{"$f":"Sheet1!AB43","v":{"v":0.6125268766350652,"d":"61%"}},{"$f":"Sheet1!AA43","v":{"v":0.6755848204741953,"d":"68%"}},{"$f":"Sheet1!AC43","v":{"v":0.6936883906453143,"d":"69%"}},{"$f":"Sheet1!Q43","v":{"v":531881.371372857,"d":"531881"}},{"$f":"Sheet1!Y43","v":{"v":586637.0840190654,"d":"586637"}},{"$f":"Sheet1!AP43","v":{"v":602357.1317372266,"d":"602357"}}]
[{"v":622416.5344312231,"d":"622417"},67,{"v":0.3799741972141416,"d":"38%"},{"v":0.5239189207473479,"d":"52%"},{"v":0.5131584864090927,"d":"51%"},{"v":236502.2230033121,"d":"236502"},{"v":326095.7989745109,"d":"326096"},{"v":319398.3267247193,"d":"319398"},{"$nulls":3},{"$f":"Sheet1!D44","v":{"v":905244.0812104288,"d":"905244"}},{"$f":"Sheet1!A44","v":76},{"$f":"Sheet1!AB44","v":{"v":0.6508047511414923,"d":"65%"}},{"$f":"Sheet1!AA44","v":{"v":0.6889286041097344,"d":"69%"}},{"$f":"Sheet1!AC44","v":{"v":0.7207544097638255,"d":"72%"}},{"$f":"Sheet1!Q44","v":{"v":589137.148994462,"d":"589137"}},{"$f":"Sheet1!Y44","v":{"v":623648.5412468999,"d":"623649"}},{"$f":"Sheet1!AP44","v":{"v":652458.6634450192,"d":"652459"}}]
[{"v":648869.2371445498,"d":"648869"},68,{"v":0.40353051510779764,"d":"40%"},{"v":0.540891560771352,"d":"54%"},{"v":0.5332601073920745,"d":"53%"},{"v":261838.5375025439,"d":"261839"},{"v":350967.8944156321,"d":"350968"},{"v":346016.0790831161,"d":"346016"},{"$nulls":3},{"$f":"Sheet1!D45","v":{"v":943716.9546618719,"d":"943717"}},{"$f":"Sheet1!A45","v":77},{"$f":"Sheet1!AB45","v":{"v":0.6920200148496297,"d":"69%"}},{"$f":"Sheet1!AA45","v":{"v":0.703866734536481,"d":"70%"}},{"$f":"Sheet1!AC45","v":{"v":0.7493814447656288,"d":"75%"}},{"$f":"Sheet1!Q45","v":{"v":653071.0209789559,"d":"653071"}},{"$f":"Sheet1!Y45","v":{"v":664250.971204564,"d":"664251"}},{"$f":"Sheet1!AP45","v":{"v":707203.974934333,"d":"707204"}}]
[{"v":676446.179723193,"d":"676446"},69,{"v":0.4284537579019699,"d":"43%"},{"v":0.5583385250137404,"d":"56%"},{"v":0.5539428256698667,"d":"55%"},{"v":289825.9077208334,"d":"289826"},{"v":377685.96223782713,"d":"377686"},{"v":374712.5082094521,"d":"374713"},{"$nulls":3},{"$f":"Sheet1!D46","v":{"v":983824.9252350013,"d":"983825"}},{"$f":"Sheet1!A46","v":78},{"$f":"Sheet1!AB46","v":{"v":0.7365773536097029,"d":"74%"}},{"$f":"Sheet1!AA46","v":{"v":0.7206030366756528,"d":"72%"}},{"$f":"Sheet1!AC46","v":{"v":0.7798212100117289,"d":"78%"}},{"$f":"Sheet1!Q46","v":{"v":724663.159844861,"d":"724663"}},{"$f":"Sheet1!Y46","v":{"v":708947.2286815391,"d":"708947"}},{"$f":"Sheet1!AP46","v":{"v":767207.5436364574,"d":"767208"}}]
[{"v":705195.1423614286,"d":"705195"},70,{"v":0.45480685712460955,"d":"45%"},{"v":0.5762808993926545,"d":"58%"},{"v":0.5752403177241391,"d":"58%"},{"v":320727.58635694295,"d":"320728"},{"v":406390.4908873751,"d":"406390"},{"v":405656.67774950765,"d":"405657"},{"$nulls":3},{"$f":"Sheet1!D47","v":{"v":1025637.4845574886,"d":"1025637"}},{"$f":"Sheet1!A47","v":79},{"$f":"Sheet1!AB47","v":{"v":0.7849584561484704,"d":"78%"}},{"$f":"Sheet1!AA47","v":{"v":0.7393804757110257,"d":"74%"}},{"$f":"Sheet1!AC47","v":{"v":0.8123719654142768,"d":"81%"}},{"$f":"Sheet1!Q47","v":{"v":805082.8164462468,"d":"805083"}},{"$f":"Sheet1!Y47","v":{"v":758336.3312391757,"d":"758336"}},{"$f":"Sheet1!AP47","v":{"v":833199.1391325219,"d":"833199"}}]
[{"$nulls":11},{"$f":"Sheet1!D48","v":{"v":1069227.0776511815,"d":"1069227"}},{"$f":"Sheet1!A48","v":80},{"$f":"Sheet1!AB48","v":{"v":0.8377412719705584,"d":"84%"}},{"$f":"Sheet1!AA48","v":{"v":0.7604909380953965,"d":"76%"}},{"$f":"Sheet1!AC48","v":{"v":0.8473901978619175,"d":"85%"}},{"$f":"Sheet1!Q48","v":{"v":895735.6520568638,"d":"895736"}},{"$f":"Sheet1!Y48","v":{"v":813137.5033199464,"d":"813138"}},{"$f":"Sheet1!AP48","v":{"v":906052.5448901545,"d":"906053"}}]
[{"$nulls":11},{"$f":"Sheet1!D49","v":{"v":1114669.2284513565,"d":"1114669"}},{"$f":"Sheet1!A49","v":81},{"$f":"Sheet1!AB49","v":{"v":0.8956253505539533,"d":"90%"}},{"$f":"Sheet1!AA49","v":{"v":0.784288101380541,"d":"78%"}},{"$f":"Sheet1!AC49","v":{"v":0.8853059903335363,"d":"89%"}},{"$f":"Sheet1!Q49","v":{"v":998326.0184834509,"d":"998326"}},{"$f":"Sheet1!Y49","v":{"v":874221.8128494269,"d":"874222"}},{"$f":"Sheet1!AP49","v":{"v":986823.345188447,"d":"986823"}}]
[{"$nulls":11},{"$f":"Sheet1!D50","v":{"v":1162042.6706605388,"d":"1162043"}},{"$f":"Sheet1!A50","v":82},{"$f":"Sheet1!AB50","v":{"v":0.9594656267780886,"d":"96%"}},{"$f":"Sheet1!AA50","v":{"v":0.8112045940717769,"d":"81%"}},{"$f":"Sheet1!AC50","v":{"v":0.9182722641348001,"d":"92%"}},{"$f":"Sheet1!Q50","v":{"v":1114939.9993481978,"d":"1114940"}},{"$f":"Sheet1!Y50","v":{"v":942654.352947266,"d":"942654"}},{"$f":"Sheet1!AP50","v":{"v":1067071.5542087029,"d":"1067072"}}]
{"$rows_empty":12}
["Data in Columns Q, R, and S are linked copies of Columns AB, AA, and AC, respectively from Sheet1."]
["Data in Columns A - H are copied values from Columns L - S from only the Startng Age to Age 70"]
["The row number in the workspace corresponding to Age 70 is calculated as 70 - Starting Age +2"]

{"sheet":"Sheet1","index":3,"n_rows":69,"n_cols":54,"rows_kept":69}
[{"$f":"Home_Page!$A$13","v":"The information below is only valid for UC employees first hired after July 1, 2016"},{"$nulls":14},"Savings Choice",{"$nulls":4},"Pension Choice",{"$nulls":5},"REPLACEMENT RATIOS",{"$nulls":7},"Second Choice"]
["Age","Service","Salary Growth","Salary","CCL","PEPRA","Max","HAPC","Benefit","Benefit55","HAPC1","CBenefit","CBenefit60","Age Factor","Annual","Inc. Bal.","Annuitization",null,"S1 = Above","Inc. Bal.","Annuitization","S2 = 5%all","Inc Bal","Ann","Tier16 Plus ",null,"Pension","Savings","2nd Choice",null,"HAPC12nd","Ben65","Ben60","DC Bal","Ann","S1 (Above)","Acc Balance","Annuity","S2 (5% all)","Acc Bal","Annuity","2nd Choice ",{"$nulls":10},"Salary Growth","Staff Salaries"]
[{"$f":"$A$53","v":35},0,{"$f":"BA3*$Q$53+BB3*(1-$Q$53)","v":2.7},{"$f":"$B$53","v":125000},290000,128059,{"$f":"MIN(D3,F3)","v":125000},0,{"$f":"0.025*H3*B3","v":0},0,0,{"$f":"MIN(K3,(0.025*K3*B3))","v":0},0,{"$f":"IF(A3<55,0,0.011)+IF(AND(A3>=55,A3<65),0.0014*(A3-55),0)+IF(A3>64,(0.025-0.011),0)","v":{"v":0,"d":"0.000"}},{"$f":"($A$56+$A$57)*MIN(D3,E3)","v":{"v":18750.000000000004,"d":"18750"}},0,null,null,{"$f":"($A$57+0.03*(1-$Q$53))*IF(D3>F3,(MIN(D3,E3))-F3,0)","v":0},0,0,{"$f":"0.05*MIN(D3,E3)*$Q$53","v":6250},0,0,{"$f":"M3+U3+X3","v":0},null,{"$f":"Y3/MAX(D3,$A$58)","v":{"v":0,"d":"0%"}},{"$f":"Q3/(MAX(D3,$A$58))","v":{"v":0,"d":"0%"}},{"$f":"AP3/(MAX(D3,$A$58))","v":{"v":0,"d":"0%"}},null,{"$f":"K3*(B3 > $H$53)","v":0},{"$f":"MIN(AE3,(0.025*AE3*MAX(0,(B3-$H$53))))","v":0},{"$f":"MIN(AE3,(AE3*MAX($F$53,N3)*MAX(0,(B3-($H$53)))))","v":0},0,null,{"$f":"($A$57+0.03*(1-$Q$53))*IF(D3>F3,(MIN(D3,E3))-F3,0)*(B3 >= $H$53)","v":0},0,0,{"$f":"0.05*MIN(D3,E3)*(B3>$H$53-1)*$Q$53","v":0},0,0,{"$f":"AG3+AI3+AL3+AO3","v":0},{"$nulls":10},2.7,2.5]
[{"$f":"A3+1","v":36},{"$f":"B3+1","v":1},{"$f":"BA4*$Q$53+BB4*(1-$Q$53)","v":2.7},{"$f":"D3*(1+0.005+(C3/100)+$D$53)","v":{"v":132124.99999999997,"d":"132125"}},{"$f":"E3*(1+$D$53)","v":297250},{"$f":"F3*(1+$D$53)","v":{"v":131260.47499999998,"d":"131260"}},{"$f":"MIN(D4,F4)","v":{"v":131260.47499999998,"d":"131260"}},0,{"$f":"0.025*H4*B4","v":0},0,0,{"$f":"MIN(K4,(0.025*K4*B4))","v":0},0,{"$f":"IF(A4<55,0,0.011)+IF(AND(A4>=55,A4<65),0.0014*(A4-55),0)+IF(A4>64,(0.025-0.011),0)","v":{"v":0,"d":"0.000"}},{"$f":"($A$56+$A$57)*MIN(D4,E4)","v":{"v":19818.75,"d":"19819"}},{"$f":"(1+$C$53)*P3+O3*($C$60/12)","v":{"v":19323.23729378216,"d":"19323"}},{"$f":"(P4*((1+$C$53)^(MAX(0,($E$53-A4))))*($C$53-$G$53)/(1-((1+$G$53)/(1+$C$53))^(MAX(0,($I$53-MAX($E$53,A4))))))","v":{"v":5251.888475802992,"d":"5252"}},null,{"$f":"($A$57+0.03*(1-$Q$53))*IF(D4>F4,(MIN(D4,E4))-F4,0)","v":{"v":60.5167499999996,"d":"61"}},{"$f":"(1+$C$53)*T3+S3*($C$60/12)","v":0},{"$f":"(T4*(1+$C$53)^(MAX(0,($E$53-A4)))*($C$53-$G$53)/(1-((1+$G$53)/(1+$C$53))^($I$53-MAX($E$53,A4))))","v":0},{"$f":"0.05*MIN(D4,E4)*$Q$53","v":{"v":6606.249999999999,"d":"6606"}},{"$f":"W3*(1+$C$53)+V3*$C$60/12","v":{"v":6441.079097927385,"d":"6441"}},{"$f":"(W4*(1+$C$53)^(MAX(0,($E$53-A4)))*($C$53-$G$53)/(1-((1+$G$53)/(1+$C$53))^($I$53-MAX($E$53,A4))))","v":{"v":1750.62949193433,"d":"1751"}},{"$f":"M4+U4+X4","v":{"v":1750.62949193433,"d":"1751"}},null,{"$f":"Y4/MAX(D4,$A$58)","v":{"v":3.8458883686859086E-3,"d":"0%"}},{"$f":"Q4/(MAX(D4,$A$58))","v":{"v":0.01153766510605773,"d":"1%"}},{"$f":"AP4/(MAX(D4,$A$58))","v":{"v":0.01153766510605773,"d":"1%"}},null,{"$f":"K4*(B4 > $H$53)","v":0},{"$f":"MIN(AE4,(0.025*AE4*MAX(0,(B4-$H$53))))","v":0},{"$f":"MIN(AE4,(AE4*MAX($F$53,N4)*MAX(0,(B4-($H$53)))))","v":0},{"$f":"(1+$C$53)*AH3+O3*($C$60/12)*($H$53 >= B4)","v":{"v":19323.23729378216,"d":"19323"}},{"$f":"(AH4*((1+$C$53)^(MAX(0,($E$53-A4))))*($C$53-$G$53)/(1-((1+$G$53)/(1+$C$53))^($I$53-MAX($E$53,A4))))","v":{"v":5251.888475802992,"d":"5252"}},{"$f":"($A$57+0.03*(1-$Q$53))*IF(D4>F4,(MIN(D4,E4))-F4,0)*(B4 >= $H$53)","v":0},{"$f":"(1+$C$53)*AK3+AJ3*($C$60/12)","v":0},{"$f":"(AK4*((1+$C$53)^(MAX(0,($E$53-A4))))*($C$53-$G$53)/(1-((1+$G$53)/(1+$C$53))^($I$53-MAX($E$53,A4))))","v":0},{"$f":"0.05*MIN(D4,E4)*(B4>$H$53-1)*$Q$53","v":0},{"$f":"(1+$C$53)*AN3+($C$60/12)*AM3","v":0},{"$f":"(AN4*((1+$C$53)^(MAX(0,($E$53-A4))))*($C$53-$G$53)/(1-((1+$G$53)/(1+$C$53))^($I$53-MAX($E$53,A4))))","v":0},{"v":5251.888475802992,"d":"5252"},{"$nulls":10},2.7,2.3]
[{"$f":"A4+1","v":37},2,2.65,{"$f":"D4*(1+0.005+(C4/100)+$D$53)","v":{"v":139656.12499999994,"d":"139656"}},{"$f":"E4*(1+$D$53)","v":{"v":304681.25,"d":"304681"}},{"v":134541.98687499997,"d":"134542"},{"v":134541.98687499997,"d":"134542"},0,0,0,0,0,0,{"v":0,"d":"0.000"},{"v":20948.418749999993,"d":"20948"},{"v":41052.217630640196,"d":"41052"},{"$f":"(P5*((1+$C$53)^(MAX(0,($E$53-A5))))*($C$53-$G$53)/(1-((1+$G$53)/(1+$C$53))^(MAX(0,($I$53-MAX($E$53,A5))))))","v":{"v":10452.119032171853,"d":"10452"}},null,{"v":357.98966874999786,"d":"358"},{"v":62.366907759919116,"d":"62"},{"$f":"(T5*(1+$C$53)^(MAX(0,($E$53-A5)))*($C$53-$G$53)/(1-((1+$G$53)/(1+$C$53))^($I$53-MAX($E$53,A5))))","v":{"v":15.878955661791649,"d":"16"}},{"v":6982.806249999998,"d":"6983"},{"v":13684.072543546728,"d":"13684"},{"$f":"(W5*(1+$C$53)^(MAX(0,($E$53-A5)))*($C$53-$G$53)/(1-((1+$G$53)/(1+$C$53))^($I$53-MAX($E$53,A5))))","v":{"v":3484.0396773906173,"d":"3484"}},{"v":3499.918633052409,"d":"3500"},null,{"v":0.00768883217392311,"d":"1%"},{"v":0.022961844981564065,"d":"2%"},{"v":0.022961844981564065,"d":"2%"},null,0,0,0,{"$f":"(1+$C$53)*AH4+O4*($C$60/12)*($H$53 >= B5)","v":{"v":41052.217630640196,"d":"41052"}},{"$f":"(AH5*((1+$C$53)^(MAX(0,($E$53-A5))))*($C$53-$G$53)/(1-((1+$G$53)/(1+$C$53))^($I$53-MAX($E$53,A5))))","v":{"v":10452.119032171853,"d":"10452"}},0,0,{"$f":"(AK5*((1+$C$53)^(MAX(0,($E$53-A5))))*($C$53-$G$53)/(1-((1+$G$53)/(1+$C$53))^($I$53-MAX($E$53,A5))))","v":0},0,0,{"$f":"(AN5*((1+$C$53)^(MAX(0,($E$53-A5))))*($C$53-$G$53)/(1-((1+$G$53)/(1+$C$53))^($I$53-MAX($E$53,A5))))","v":0},{"v":10452.119032171853,"d":"10452"},{"$nulls":10},2.65,2.1]
[38,3,2.65,{"v":147546.69606249992,"d":"147547"},{"v":312298.28125,"d":"312298"},{"v":137905.53654687497,"d":"137906"},{"v":137905.53654687497,"d":"137906"},0,0,0,0,0,0,{"v":0,"d":"0.000"},{"v":22132.004409374993,"d":"22132"},{"v":65412.10986394922,"d":"65412"},{"v":15601.19977978955,"d":"15601"},null,{"v":674.8811660937467,"d":"675"},{"v":435.5110376592432,"d":"436"},{"v":103.87212274542416,"d":"104"},{"v":7377.334803124996,"d":"7377"},{"v":21804.0366213164,"d":"21804"},{"v":5200.399926596516,"d":"5200"},{"v":5304.27204934194,"d":"5304"},null,{"v":0.011652744497277765,"d":"1%"},{"v":0.034273655874688384,"d":"3%"},{"v":0.034273655874688384,"d":"3%"},null,0,0,0,{"v":65412.10986394922,"d":"65412"},{"v":15601.19977978955,"d":"15601"},0,0,0,0,0,0,{"v":15601.19977978955,"d":"15601"},{"$nulls":10},2.65,1.9]
[39,4,2.65,{"v":155883.08439003114,"d":"155883"},{"v":320105.73828125,"d":"320106"},{"v":141353.17496054684,"d":"141353"},{"v":141353.17496054684,"d":"141353"},0,0,0,0,0,0,{"v":0,"d":"0.000"},{"v":23382.462658504675,"d":"23382"},{"v":92636.06583919971,"d":"92636"},{"v":20697.222084106266,"d":"20697"},null,{"v":1017.0936600639017,"d":"1017"},{"v":1160.4221083030488,"d":"1160"},{"v":259.26742321446693,"d":"259"},{"v":7794.154219501557,"d":"7794"},{"v":30878.68861306656,"d":"30879"},{"v":6899.074028035419,"d":"6899"},{"v":7158.341451249887,"d":"7158"},null,{"v":0.015725875893947788,"d":"2%"},{"v":0.045468904782028745,"d":"5%"},{"v":0.045468904782028745,"d":"5%"},null,0,0,0,{"v":92636.06583919971,"d":"92636"},{"v":20697.222084106266,"d":"20697"},0,0,0,0,0,0,{"v":20697.222084106266,"d":"20697"},{"$nulls":10},2.65,1.8]
[40,5,2.65,{"v":164690.47865806788,"d":"164690"},{"v":328108.3817382812,"d":"328108"},{"v":144887.0043345605,"d":"144887"},{"v":144887.0043345605,"d":"144887"},{"$f":"MIN(E8,((1/3)*(D5+D6+D7)))","v":{"v":147695.30181751034,"d":"147695"}},{"$f":"MIN(H8,(0.025*H8*B8))","v":{"v":18461.912727188792,"d":"18462"}},{"$f":"MIN(H8,B8*H8*MAX($F$53,N8))","v":{"v":13292.577163575928,"d":"13293"}},{"$f":"(1/3)*(G5+G6+G7)","v":{"v":137933.56612747393,"d":"137934"}},{"v":17241.69576593424,"d":"17242"},{"$f":"MIN(K8,B8*K8*MAX($F$53,N8))","v":{"v":12414.020951472652,"d":"12414"}},{"v":0,"d":"0.000"},{"v":24703.571798710185,"d":"24704"},{"v":122986.3269213876,"d":"122986"},{"v":25740.73268317943,"d":"25741"},null,{"v":1386.243202645516,"d":"1386"},{"v":2286.939514929034,"d":"2287"},{"v":478.6507589092907,"d":"479"},{"v":8234.523932903394,"d":"8235"},{"v":40995.4423071292,"d":"40995"},{"v":8580.244227726476,"d":"8580"},{"v":21472.915938108417,"d":"21473"},null,{"v":0.04717299578730008,"d":"5%"},{"v":0.056548792810698606,"d":"6%"},{"v":0.056548792810698606,"d":"6%"},null,0,0,0,{"v":122986.3269213876,"d":"122986"},{"v":25740.73268317943,"d":"25741"},0,0,0,0,0,0,{"v":25740.73268317943,"d":"25741"},{"$nulls":10},2.65,1.65]
[41,6,2.6,{"v":173995.49070224867,"d":"173995"},{"v":336311.09128173825,"d":"336311"},{"v":148509.1794429245,"d":"148509"},{"v":148509.1794429245,"d":"148509"},{"$f":"MIN(E9,((1/3)*(D6+D7+D8)))","v":{"v":156040.08637019963,"d":"156040"}},{"$f":"MIN(H9,(0.025*H9*B9))","v":{"v":23406.012955529946,"d":"23406"}},{"$f":"MIN(H9,B9*H9*MAX($F$53,N9))","v":{"v":16852.32932798156,"d":"16852"}},{"v":141381.90528066075,"d":"141382"},{"v":21207.285792099115,"d":"21207"},{"$f":"MIN(K9,B9*K9*MAX($F$53,N9))","v":{"v":15269.245770311361,"d":"15269"}},{"v":0,"d":"0.000"},{"v":26099.323605337304,"d":"26099"},{"v":156746.72958167255,"d":"156747"},{"v":30732.272681231705,"d":"30732"},null,{"v":1784.0417881526919,"d":"1784"},{"v":3869.9322709393755,"d":"3870"},{"v":758.751484804906,"d":"759"},{"v":8699.774535112434,"d":"8700"},{"v":52248.90986055751,"d":"52249"},{"v":10244.090893743902,"d":"10244"},{"v":26272.08814886017,"d":"26272"},null,{"v":0.05771610651957556,"d":"6%"},{"v":0.06751450869106368,"d":"7%"},{"v":0.06751450869106368,"d":"7%"},null,0,0,0,{"v":156746.72958167255,"d":"156747"},{"v":30732.272681231705,"d":"30732"},{"v":1784.0417881526919,"d":"1784"},0,0,{"v":8699.774535112434,"d":"8700"},0,0,{"v":30732.272681231705,"d":"30732"},{"$nulls":10},2.6,1.5]
[42,7,2.6,{"v":183739.23818157456,"d":"183739"},{"v":344718.86856378167,"d":"344719"},{"v":152221.9089289976,"d":"152222"},{"v":152221.9089289976,"d":"152222"},{"v":164856.3512501159,"d":"164856"},{"v":28849.861468770287,"d":"28850"},{"v":20771.900257514604,"d":"20772"},{"v":144916.45291267728,"d":"144916"},{"v":25360.379259718524,"d":"25360"},{"v":18259.473066997336,"d":"18259"},{"v":0,"d":"0.000"},{"v":27560.88572723619,"d":"27561"},{"v":194224.3830675364,"d":"194224"},{"v":35672.377606704526,"d":"35672"},null,{"v":2206.213047680387,"d":"2206"},{"v":5969.737382667671,"d":"5970"},{"v":1096.436620181369,"d":"1096"},{"v":9186.96190907873,"d":"9187"},{"v":64741.46102251212,"d":"64741"},{"v":11890.792535568173,"d":"11891"},{"v":31246.702222746877,"d":"31247"},null,{"v":0.06864463850970141,"d":"7%"},{"v":0.07836722890427747,"d":"8%"},{"v":0.07760443069864892,"d":"8%"},null,{"$f":"K10*(B10 >$H$53)","v":{"v":144916.45291267728,"d":"144916"}},{"v":3622.911322816932,"d":"3623"},{"v":2608.4961524281907,"d":"2608"},{"v":167327.13382843544,"d":"167327"},{"v":30732.272681231712,"d":"30732"},{"v":2206.213047680387,"d":"2206"},{"v":1838.584683439888,"d":"1839"},{"v":337.68513537646277,"d":"338"},{"v":9186.96190907873,"d":"9187"},{"v":8965.74974636698,"d":"8966"},{"v":1646.7016418242708,"d":"1647"},{"v":35325.15561086064,"d":"35325"},{"$nulls":10},2.6,1.4]
[43,8,2.55,{"v":194028.6355197427,"d":"194029"},{"v":353336.8402778762,"d":"353337"},{"v":156027.45665222255,"d":"156027"},{"v":156027.45665222255,"d":"156027"},{"v":174141.735847297,"d":"174142"},{"v":34828.347169459405,"d":"34828"},{"v":25076.409962010766,"d":"25076"},{"v":148539.3642354942,"d":"148539"},{"v":29707.872847098843,"d":"29708"},{"v":21389.66844991116,"d":"21390"},{"v":0,"d":"0.000"},{"v":29104.29532796141,"d":"29104"},{"v":235738.0241210857,"d":"235738"},{"v":40559.26360323782,"d":"40559"},null,{"v":2660.082520726411,"d":"2660"},{"v":8646.35749551595,"d":"8646"},{"v":1487.6254867069404,"d":"1488"},{"v":9701.431775987136,"d":"9701"},{"v":78579.3413736952,"d":"78579"},{"v":13519.754534412603,"d":"13520"},{"v":36397.04847103071,"d":"36397"},null,{"v":0.07995922953095386,"d":"8%"},{"v":0.08910303456718496,"d":"9%"},{"v":0.08805944648779722,"d":"9%"},null,{"v":148539.3642354942,"d":"148539"},{"v":7426.968211774711,"d":"7427"},{"v":5347.41711247779,"d":"5347"},{"v":178621.71536185482,"d":"178622"},{"v":30732.272681231712,"d":"30732"},{"v":2660.082520726411,"d":"2660"},{"v":4236.351989090291,"d":"4236"},{"v":728.874001902034,"d":"729"},{"v":9701.431775987136,"d":"9701"},{"v":19038.769586410282,"d":"19039"},{"v":3275.6636406687007,"d":"3276"},{"v":40084.22743628024,"d":"40084"},{"$nulls":10},2.55,1.3]
[44,9,2.5,{"v":204797.2247910884,"d":"204797"},{"v":362170.26128482306,"d":"362170"},{"v":159928.1430685281,"d":"159928"},{"v":159928.1430685281,"d":"159928"},{"v":183921.12146785532,"d":"183921"},{"v":41382.25233026745,"d":"41382"},{"v":29795.22167779256,"d":"29795"},{"v":152252.84834138156,"d":"152253"},{"v":34256.89087681085,"d":"34257"},{"v":24664.96143130381,"d":"24665"},{"v":0,"d":"0.000"},{"v":30719.583718663263,"d":"30720"},{"v":281644.43167675304,"d":"281644"},{"v":45393.503989504,"d":"45394"},null,{"v":3140.8357205792217,"d":"3141"},{"v":11971.394934145335,"d":"11971"},{"v":1929.4667409819367,"d":"1929"},{"v":10239.86123955442,"d":"10240"},{"v":93881.47722558431,"d":"93881"},{"v":15131.16799650133,"d":"15131"},{"v":41725.59616878708,"d":"41726"},null,{"v":0.09166530423562817,"d":"9%"},{"v":0.09972318518079647,"d":"10%"},{"v":0.09888445657956474,"d":"10%"},null,{"v":152252.84834138156,"d":"152253"},{"v":11418.963625603617,"d":"11419"},{"v":8221.653810434604,"d":"8222"},{"v":190678.68114878,"d":"190679"},{"v":30732.272681231705,"d":"30732"},{"v":3140.8357205792217,"d":"3141"},{"v":7263.714056035946,"d":"7264"},{"v":1170.7152561770304,"d":"1171"},{"v":10239.86123955442,"d":"10240"},{"v":30321.91684265766,"d":"30322"},{"v":4887.077102757431,"d":"4887"},{"v":45011.718850600766,"d":"45012"},{"$nulls":10},2.5,1.2]
[45,10,2.4,{"v":216061.0721545982,"d":"216061"},{"v":371224.5178169436,"d":"371225"},{"v":163926.34664524128,"d":"163926"},{"v":163926.34664524128,"d":"163926"},{"v":194188.3661641352,"d":"194188"},{"v":48547.0915410338,"d":"48547"},{"v":34953.90590954433,"d":"34954"},{"v":156059.16954991606,"d":"156059"},{"v":39014.792387479014,"d":"39015"},{"v":28090.650518984887,"d":"28091"},{"v":0,"d":"0.000"},{"v":32409.160823189733,"d":"32409"},{"v":332314.1937889038,"d":"332314"},{"v":50173.4016266974,"d":"50173"},null,{"v":3649.430785654984,"d":"3649"},{"v":16016.323501775587,"d":"16016"},{"v":2418.173664132343,"d":"2418"},{"v":10803.053607729911,"d":"10803"},{"v":110771.39792963456,"d":"110771"},{"v":16724.46720889913,"d":"16724"},{"v":47233.291392016356,"d":"47233"},null,{"v":0.10376494102049676,"d":"10%"},{"v":0.11022395236830648,"d":"11%"},{"v":0.11008100213620393,"d":"11%"},null,{"v":156059.16954991606,"d":"156059"},{"v":15605.916954991606,"d":"15606"},{"v":11236.260207593956,"d":"11236"},{"v":203549.4921263226,"d":"203549"},{"v":30732.2726812317,"d":"30732"},{"v":3649.430785654984,"d":"3649"},{"v":10990.874164393816,"d":"10991"},{"v":1659.4221793274376,"d":"1659"},{"v":10803.053607729911,"d":"10803"},{"v":42921.56722086038,"d":"42922"},{"v":6480.376315155231,"d":"6480"},{"v":50108.33138330833,"d":"50108"},{"$nulls":10},2.4,1.1]
[46,11,2.4,{"v":227728.37005094645,"d":"227728"},{"v":380505.13076236716,"d":"380505"},{"v":168024.5053113723,"d":"168025"},{"v":168024.5053113723,"d":"168025"},{"v":204962.31082180975,"d":"204962"},{"v":56364.63547599769,"d":"56365"},{"v":40582.53754271833,"d":"40583"},{"v":159960.64878866397,"d":"159961"},{"v":43989.17841688259,"d":"43989"},{"v":31672.208460155463,"d":"31672"},{"v":0,"d":"0.000"},{"v":34159.255507641974,"d":"34159"},{"v":388145.39680719306,"d":"388145"},{"v":54897.328565563024,"d":"54897"},null,{"v":4179.27053177019,"d":"4179"},{"v":20858.428914595843,"d":"20858"},{"v":2950.111053499908,"d":"2950"},{"v":11386.418502547323,"d":"11386"},{"v":129381.79893573099,"d":"129382"},{"v":18299.109521854334,"d":"18299"},{"v":52921.429035509704,"d":"52921"},null,{"v":0.11626098458847302,"d":"12%"},{"v":0.12060175975268411,"d":"12%"},{"v":0.12165137719524503,"d":"12%"},null,{"v":159960.64878866397,"d":"159961"},{"v":19995.081098582996,"d":"19995"},{"v":14396.458390979755,"d":"14396"},{"v":217289.08284484936,"d":"217289"},{"v":30732.272681231705,"d":"30732"},{"v":4179.27053177019,"d":"4179"},{"v":15493.761746940803,"d":"15494"},{"v":2191.359568695002,"d":"2191"},{"v":11386.418502547323,"d":"11386"},{"v":56952.104654114555,"d":"56952"},{"v":8055.018628110438,"d":"8055"},{"v":55375.1092690169,"d":"55375"},{"$nulls":10},2.4,1]
[47,12,2.3,{"v":240025.7020336975,"d":"240026"},{"v":390017.7590314263,"d":"390018"},{"v":172225.1179441566,"d":"172225"},{"v":172225.1179441566,"d":"172225"},{"v":216195.55566554435,"d":"216196"},{"v":64858.666699663314,"d":"64859"},{"v":46698.24002375758,"d":"46698"},{"v":163959.66500838057,"d":"163960"},{"v":49187.89950251418,"d":"49188"},{"v":35415.2876418102,"d":"35415"},{"v":0,"d":"0.000"},{"v":36003.85530505463,"d":"36004"},{"v":449548.80575584393,"d":"449549"},{"v":59561.51497639614,"d":"59562"},null,{"v":4746.040886267864,"d":"4746"},{"v":26573.414797014077,"d":"26573"},{"v":3520.7586432027033,"d":"3521"},{"v":12001.285101684876,"d":"12001"},{"v":149849.60191861461,"d":"149850"},{"v":19853.838325465378,"d":"19854"},{"v":58789.884610478286,"d":"58790"},null,{"v":0.1291531614550834,"d":"13%"},{"v":0.13084832554484707,"d":"13%"},{"v":0.13359474384019684,"d":"13%"},null,{"v":163959.66500838057,"d":"163960"},{"v":24593.94975125709,"d":"24594"},{"v":17707.643820905098,"d":"17708"},{"v":231956.09593687666,"d":"231956"},{"v":30732.272681231705,"d":"30732"},{"v":4746.040886267864,"d":"4746"},{"v":20846.63259554232,"d":"20847"},{"v":2762.0071583977974,"d":"2762"},{"v":12001.285101684876,"d":"12001"},{"v":72530.90327298908,"d":"72531"},{"v":9609.747431721478,"d":"9610"},{"v":60811.67109225608,"d":"60812"},{"$nulls":10},2.3,0.9]
[48,13,2.2,{"v":252747.0642414834,"d":"252747"},{"v":399768.2030072119,"d":"399768"},{"v":176530.74589276052,"d":"176531"},{"v":176530.74589276052,"d":"176531"},{"v":227938.38141308073,"d":"227938"},{"v":74079.97395925125,"d":"74080"},{"v":53337.581250660885,"d":"53338"},{"v":168058.65663359006,"d":"168059"},{"v":54619.06340591677,"d":"54619"},{"v":39325.72565226007,"d":"39326"},{"v":0,"d":"0.000"},{"v":37912.05963622252,"d":"37912"},{"v":516997.93892039364,"d":"516998"},{"v":64166.716360019665,"d":"64167"},null,{"v":5335.142284410602,"d":"5335"},{"v":33258.26025588432,"d":"33258"},{"v":4127.817911466847,"d":"4128"},{"v":12637.353212074171,"d":"12637"},{"v":172332.64630679786,"d":"172333"},{"v":21388.905453339885,"d":"21389"},{"v":64842.4490170668,"d":"64842"},null,{"v":0.14244979969822244,"d":"14%"},{"v":0.14096530947453306,"d":"14%"},{"v":0.14591885160613588,"d":"15%"},null,{"v":168058.65663359006,"d":"168059"},{"v":29410.264910878264,"d":"29410"},{"v":21175.390735832345,"d":"21175"},{"v":247613.1324126158,"d":"247613"},{"v":30732.272681231705,"d":"30732"},{"v":5335.142284410602,"d":"5335"},{"v":27144.920255813216,"d":"27145"},{"v":3369.0664266619406,"d":"3369"},{"v":12637.353212074171,"d":"12637"},{"v":89794.93550259259,"d":"89795"},{"v":11144.814559595983,"d":"11145"},{"v":66421.54440332197,"d":"66422"},{"$nulls":10},2.2,0.85]
[49,14,2.1,{"v":265889.9115820405,"d":"265890"},{"v":409762.4080823922,"d":"409762"},{"v":180944.01454007952,"d":"180944"},{"v":180944.01454007952,"d":"180944"},{"v":240167.04544204246,"d":"240167"},{"v":84058.46590471486,"d":"84058"},{"v":60522.0954513947,"d":"60522"},{"v":172260.1230494298,"d":"172260"},{"v":60291.04306730042,"d":"60291"},{"v":43409.5510084563,"d":"43410"},{"v":0,"d":"0.000"},{"v":39883.48673730608,"d":"39883"},{"v":590966.4317786801,"d":"590966"},{"v":68709.36465693354,"d":"68709"},null,{"v":5946.212792937268,"d":"5946"},{"v":41001.44457557022,"d":"41001"},{"v":4767.078221896287,"d":"4767"},{"v":13294.495579102026,"d":"13294"},{"v":196988.81059289334,"d":"196989"},{"v":22903.121552311175,"d":"22903"},{"v":71079.75078266376,"d":"71080"},null,{"v":0.15615228010473514,"d":"16%"},{"v":0.15094487301360504,"d":"15%"},{"v":0.1586244882735186,"d":"16%"},null,{"v":172260.1230494298,"d":"172260"},{"v":34452.02460988596,"d":"34452"},{"v":24805.457719117887,"d":"24805"},{"v":264327.01885046734,"d":"264327"},{"v":30732.2726812317,"d":"30732"},{"v":5946.212792937268,"d":"5946"},{"v":34475.45412549432,"d":"34475"},{"v":4008.3267370913804,"d":"4008"},{"v":13294.495579102026,"d":"13294"},{"v":108879.80430940421,"d":"108880"},{"v":12659.030658567277,"d":"12659"},{"v":72205.08779600824,"d":"72205"},{"$nulls":10},2.1,0.8]
[50,15,2,{"v":279450.2970727245,"d":"279450"},{"v":420006.4682844519,"d":"420006"},{"v":185467.61490358147,"d":"185468"},{"v":185467.61490358147,"d":"185468"},{"v":252887.55928574043,"d":"252888"},{"v":94832.83473215267,"d":"94833"},{"v":68279.64100714991,"d":"68280"},{"v":176566.62612566553,"d":"176567"},{"v":66212.48479712458,"d":"66212"},{"v":47672.98905392969,"d":"47673"},{"v":0,"d":"0.000"},{"v":41917.54456090868,"d":"41918"},{"v":671959.4967679211,"d":"671959"},{"v":73186.05412611706,"d":"73186"},null,{"v":6578.787751840012,"d":"6579"},{"v":49897.046393607874,"d":"49897"},{"v":5434.506031480635,"d":"5435"},{"v":13972.514853636225,"d":"13973"},{"v":223986.49892264037,"d":"223986"},{"v":24395.351375372353,"d":"24395"},{"v":77502.84646078268,"d":"77503"},null,{"v":0.17026292377505262,"d":"17%"},{"v":0.16077953422494343,"d":"16%"},{"v":0.1717133671112278,"d":"17%"},null,{"v":176566.62612566553,"d":"176567"},{"v":39727.490878274744,"d":"39727"},{"v":28603.793432357812,"d":"28604"},{"v":282169.09262287384,"d":"282169"},{"v":30732.2726812317,"d":"30732"},{"v":6578.787751840012,"d":"6579"},{"v":42930.55158815185,"d":"42931"},{"v":4675.754546675728,"d":"4676"},{"v":13972.514853636225,"d":"13973"},{"v":129930.13471501571,"d":"129930"},{"v":14151.26048162845,"d":"14151"},{"v":78163.0811418937,"d":"78163"},{"$nulls":10},2,0.75]
[51,16,2,{"v":293422.81192636065,"d":"293423"},{"v":430506.6299915632,"d":"430507"},{"v":190104.30527617098,"d":"190104"},{"v":190104.30527617098,"d":"190104"},{"v":266029.0909654161,"d":"266029"},{"v":106411.63638616644,"d":"106412"},{"v":76616.37819803983,"d":"76616"},{"v":180980.79177880718,"d":"180981"},{"v":72392.31671152287,"d":"72392"},{"v":52122.46803229646,"d":"52122"},{"v":0,"d":"0.000"},{"v":44013.4217889541,"d":"44013"},{"v":760515.8380169892,"d":"760516"},{"v":77593.54886345839,"d":"77594"},null,{"v":7232.295465513277,"d":"7232"},{"v":60045.01578966878,"d":"60045"},{"v":6126.244364392468,"d":"6126"},{"v":14671.140596318033,"d":"14671"},{"v":253505.27933899636,"d":"253505"},{"v":25864.51628781946,"d":"25865"},{"v":84113.22868450839,"d":"84113"},null,{"v":0.18478500981548845,"d":"18%"},{"v":0.17046218427938523,"d":"17%"},{"v":0.18518814419824017,"d":"19%"},null,{"v":180980.79177880718,"d":"180981"},{"v":45245.197944701795,"d":"45245"},{"v":32576.54252018529,"d":"32577"},{"v":301215.5063749178,"d":"301216"},{"v":30732.2726812317,"d":"30732"},{"v":7232.295465513277,"d":"7232"},{"v":52608.28258484448,"d":"52608"},{"v":5367.492879587561,"d":"5367"},{"v":14671.140596318033,"d":"14671"},{"v":153100.11054735706,"d":"153100"},{"v":15620.425394075557,"d":"15620"},{"v":84296.73347508011,"d":"84297"},{"$nulls":10},2,0.7]
[52,17,2,{"v":308093.95252267865,"d":"308094"},{"v":441269.29574135225,"d":"441269"},{"v":194856.91290807523,"d":"194857"},{"v":194856.91290807523,"d":"194857"},{"v":279587.6735270419,"d":"279588"},{"v":118824.76124899281,"d":"118825"},{"v":85553.8280992748,"d":"85554"},{"v":185505.3115732773,"d":"185505"},{"v":78839.75741864284,"d":"78840"},{"v":56764.62534142284,"d":"56765"},{"v":0,"d":"0.000"},{"v":46214.0928784018,"d":"46214"},{"v":857209.686061231,"d":"857210"},{"v":81928.78958871217,"d":"81929"},null,{"v":7926.59277302224,"d":"7927"},{"v":71551.46029994384,"d":"71551"},{"v":6838.612105067203,"d":"6839"},{"v":15404.697626133933,"d":"15405"},{"v":285736.56202041026,"d":"285737"},{"v":27309.596529570717,"d":"27310"},{"v":90912.83397606076,"d":"90913"},null,{"v":0.19972279249475877,"d":"20%"},{"v":0.17998610236572146,"d":"18%"},{"v":0.19905243520025145,"d":"20%"},null,{"v":185505.3115732773,"d":"185505"},{"v":51013.96068265125,"d":"51014"},{"v":36730.051691508896,"d":"36730"},{"v":321547.5530552247,"d":"321548"},{"v":30732.2726812317,"d":"30732"},{"v":7926.59277302224,"d":"7927"},{"v":63612.74760379388,"d":"63613"},{"v":6079.860620262296,"d":"6080"},{"v":15404.697626133933,"d":"15405"},{"v":178554.04433533532,"d":"178554"},{"v":17065.505635826816,"d":"17066"},{"v":90607.6906288297,"d":"90608"},{"$nulls":10},2,0.65]
[{"$f":"A20+1","v":53},18,2,{"v":323498.6501488125,"d":"323499"},{"$f":"E20*(1+$D$53)","v":{"v":452301.028134886,"d":"452301"}},{"v":199728.3357307771,"d":"199728"},{"v":199728.3357307771,"d":"199728"},{"v":293655.68717392127,"d":"293656"},{"v":132145.05922826458,"d":"132145"},{"v":95144.44264435048,"d":"95144"},{"v":190142.9443626092,"d":"190143"},{"v":85564.32496317415,"d":"85564"},{"v":61606.313973485376,"d":"61606"},{"v":0,"d":"0.000"},{"v":48524.79752232188,"d":"48525"},{"v":962698.3202973637,"d":"962698"},{"v":86192.9607938798,"d":"86193"},null,{"v":8663.92200926248,"d":"8664"},{"v":84550.11363468537,"d":"84550"},{"v":7569.998280854459,"d":"7570"},{"v":16174.932507440626,"d":"16175"},{"v":320899.4400991212,"d":"320899"},{"v":28730.98693129326,"d":"28731"},{"v":97907.29918563309,"d":"97907"},null,{"v":0.21508865518507014,"d":"22%"},{"v":0.18935389064736363,"d":"19%"},{"v":0.2133179689213723,"d":"21%"},null,{"v":190142.9443626092,"d":"190143"},{"v":57042.883308782766,"d":"57043"},{"v":41070.87598232359,"d":"41071"},{"v":343252.0128864523,"d":"343252"},{"v":30732.27268123169,"d":"30732"},{"v":8663.92200926248,"d":"8664"},{"v":76075.5378315453,"d":"76076"},{"v":6811.246796049552,"d":"6811"},{"v":16174.932507440626,"d":"16175"},{"v":206482.1024703037,"d":"206482"},{"v":18486.896037549363,"d":"18487"},{"v":97101.29149715419,"d":"97101"},{"$nulls":10},2,0.6]
[54,19,2,{"v":339673.5826562531,"d":"339674"},{"v":463608.5538382581,"d":"463609"},{"v":204721.54412404652,"d":"204722"},{"v":204721.54412404652,"d":"204722"},{"v":308338.47153261723,"d":"308338"},{"v":146460.7739779932,"d":"146461"},{"v":105451.7572641551,"d":"105452"},{"v":194896.51797167445,"d":"194897"},{"v":92575.84603654536,"d":"92576"},{"v":66654.60914631265,"d":"66655"},{"v":0,"d":"0.000"},{"v":50951.03739843797,"d":"50951"},{"v":1077688.7863657854,"d":"1077689"},{"v":90387.22755306111,"d":"90387"},null,{"v":9446.64269725446,"d":"9447"},{"v":99186.047418616,"d":"99186"},{"v":8318.869001456078,"d":"8319"},{"v":16983.679132812653,"d":"16984"},{"v":359229.59545526176,"d":"359230"},{"v":30129.07585102036,"d":"30129"},{"v":105102.5539987891,"d":"105103"},null,{"v":0.23089562457701845,"d":"23%"},{"v":0.1985681086293068,"d":"20%"},{"v":0.22799710111990035,"d":"23%"},null,{"v":194896.51797167445,"d":"194897"},{"v":63341.36834079419,"d":"63341"},{"v":45605.785205371816,"d":"45606"},{"v":366421.5237562878,"d":"366422"},{"v":30732.2726812317,"d":"30732"},{"v":9446.64269725446,"d":"9447"},{"v":90139.43774876397,"d":"90139"},{"v":7560.11751665117,"d":"7560"},{"v":16983.679132812653,"d":"16984"},{"v":237089.0875364991,"d":"237089"},{"v":19884.984957276458,"d":"19885"},{"v":103783.16036053115,"d":"103783"},{"$nulls":10},2,0.55]
[55,20,2,{"v":356657.26178906567,"d":"356657"},{"v":475198.7676842145,"d":"475199"},{"v":209839.58272714767,"d":"209840"},{"v":209839.58272714767,"d":"209840"},{"v":323755.3951092481,"d":"323755"},{"v":161877.69755462406,"d":"161878"},{"v":116551.9422393293,"d":"116552"},{"v":199768.93092096626,"d":"199769"},{"v":99884.46546048313,"d":"99884"},{"v":71916.81513154785,"d":"71917"},0.011,{"v":53498.58926835986,"d":"53499"},{"v":1202941.5253662432,"d":"1202942"},{"v":94512.73584078041,"d":"94513"},null,{"v":10277.237534334261,"d":"10277"},{"v":115616.55727103242,"d":"115617"},{"v":9083.764177856176,"d":"9084"},{"v":17832.863089453283,"d":"17833"},{"v":400980.50845541427,"d":"400981"},{"v":31504.245280260122,"d":"31504"},{"v":112504.82458966415,"d":"112505"},null,{"v":0.24715737870516152,"d":"25%"},{"v":0.20763127385744756,"d":"21%"},{"v":0.24310282212478765,"d":"24%"},null,{"v":199768.93092096626,"d":"199769"},{"v":69919.12582233819,"d":"69919"},{"v":50341.77059208349,"d":"50342"},{"v":391154.9766098372,"d":"391155"},{"v":30732.2726812317,"d":"30732"},{"v":10277.237534334261,"d":"10277"},{"v":105959.30144846538,"d":"105959"},{"v":8325.012693051267,"d":"8325"},{"v":17832.863089453283,"d":"17833"},{"v":270595.51625213516,"d":"270596"},{"v":21260.15438651622,"d":"21260"},{"v":110659.21035288268,"d":"110659"},{"$nulls":10},2,0.5]
[56,21,2,{"v":374490.12487851887,"d":"374490"},{"v":487078.73687631986,"d":"487079"},{"v":215085.57229532636,"d":"215086"},{"v":215085.57229532636,"d":"215086"},{"v":339943.1648647104,"d":"339943"},{"v":178470.16155397298,"d":"178470"},{"v":128498.51631886052,"d":"128499"},{"v":204763.1541939904,"d":"204763"},{"v":107500.65595184496,"d":"107501"},{"v":77400.47228532836,"d":"77400"},{"v":0.0124,"d":"0.012"},{"v":56173.51873177784,"d":"56174"},{"v":1339274.26154527,"d":"1339274"},{"v":98570.61284509445,"d":"98571"},null,{"v":11158.318680823477,"d":"11158"},{"v":134012.11486552074,"d":"134012"},{"v":9863.294375358277,"d":"9863"},{"v":18724.506243925945,"d":"18725"},{"v":446424.7538484232,"d":"446425"},{"v":32856.870948364805,"d":"32857"},{"v":120120.63760905145,"d":"120121"},null,{"v":0.26388825570928726,"d":"26%"},{"v":0.21654586260643843,"d":"22%"},{"v":0.2586487651775761,"d":"26%"},null,{"v":204763.1541939904,"d":"204763"},{"v":76786.1828227464,"d":"76786"},{"v":55286.051632377406,"d":"55286"},{"v":417557.93753100117,"d":"417558"},{"v":30732.27268123169,"d":"30732"},{"v":11158.318680823477,"d":"11158"},{"v":123702.99427493042,"d":"123703"},{"v":9104.54289055337,"d":"9105"},{"v":18724.506243925945,"d":"18725"},{"v":307238.7746714228,"d":"307239"},{"v":22612.78005462091,"d":"22613"},{"v":117735.64725878337,"d":"117736"},{"$nulls":10},2,{"$f":"BB23","v":0.5}]
[57,22,2,{"v":393214.63112244476,"d":"393215"},{"v":499255.70529822784,"d":"499256"},{"v":220462.7116027095,"d":"220463"},{"v":220462.7116027095,"d":"220463"},{"v":356940.32310794585,"d":"356940"},{"v":196317.17770937024,"d":"196317"},{"v":141348.36795074656,"d":"141348"},{"v":209882.2330488402,"d":"209882"},{"v":115435.22817686212,"d":"115435"},{"v":83113.36428734071,"d":"83113"},{"v":0.0138,"d":"0.014"},{"v":58982.19466836672,"d":"58982"},{"v":1487566.1665772216,"d":"1487566"},{"v":102561.96727556731,"d":"102562"},null,{"v":12092.63436638147,"d":"12093"},{"v":154557.39073463372,"d":"154557"},{"v":10656.13779533328,"d":"10656"},{"v":19660.73155612224,"d":"19661"},{"v":495855.3888590737,"d":"495855"},{"v":34187.322425189086,"d":"34187"},{"v":127956.82450786309,"d":"127957"},null,{"v":0.28110326333245317,"d":"28%"},{"v":0.2253143105562656,"d":"23%"},{"v":0.2746492155006214,"d":"27%"},null,{"v":209882.2330488402,"d":"209882"},{"v":83952.89321953608,"d":"83953"},{"v":60446.08311806597,"d":"60446"},{"v":445743.0983143437,"d":"445743"},{"v":30732.27268123169,"d":"30732"},{"v":12092.63436638147,"d":"12093"},{"v":143552.40450417856,"d":"143552"},{"v":9897.38631052837,"d":"9897"},{"v":19660.73155612224,"d":"19661"},{"v":347274.3560876257,"d":"347274"},{"v":23943.231531445188,"d":"23943"},{"v":125018.97364127121,"d":"125019"},{"$nulls":10},2,0.5]
[58,23,2,{"v":412875.36267856695,"d":"412875"},{"v":511737.09793068346,"d":"511737"},{"v":225974.2793927772,"d":"225974"},{"v":225974.2793927772,"d":"225974"},{"v":374787.3392633431,"d":"374787"},{"v":215502.72007642227,"d":"215503"},{"v":155161.95845502403,"d":"155162"},{"v":215129.28887506115,"d":"215129"},{"v":123699.34110316017,"d":"123699"},{"v":89063.5255942753,"d":"89064"},{"v":0.015199999999999998,"d":"0.015"},{"v":61931.30440178505,"d":"61931"},{"v":1648762.319817712,"d":"1648762"},{"v":106487.88966619634,"d":"106488"},null,{"v":13083.075830005282,"d":"13083"},{"v":177452.35292220998,"d":"177452"},{"v":11461.0373804979,"d":"11461"},{"v":20643.768133928348,"d":"20644"},{"v":549587.4399392371,"d":"549587"},{"v":35495.96322206543,"d":"35496"},{"v":136020.52619683865,"d":"136021"},null,{"v":0.2988180891577154,"d":"30%"},{"v":0.2339390134577349,"d":"23%"},{"v":0.2911191200932601,"d":"29%"},null,{"v":215129.28887506115,"d":"215129"},{"v":91429.947771901,"d":"91430"},{"v":65829.5623957687,"d":"65830"},{"v":475830.75745056185,"d":"475831"},{"v":30732.27268123169,"d":"30732"},{"v":13083.075830005282,"d":"13083"},{"v":165704.5301211991,"d":"165705"},{"v":10702.285895692994,"d":"10702"},{"v":20643.768133928348,"d":"20644"},{"v":390977.1874557164,"d":"390977"},{"v":25251.87232832153,"d":"25252"},{"v":132515.99330101494,"d":"132516"},{"$nulls":10},2,0.5]
[59,24,2,{"v":433519.13081249525,"d":"433519"},{"v":524530.5253789505,"d":"524531"},{"v":231623.63637759662,"d":"231624"},{"v":231623.63637759662,"d":"231624"},{"v":393526.7062265101,"d":"393527"},{"v":236116.02373590608,"d":"236116"},{"v":170003.53708985238,"d":"170004"},{"v":220507.5210969377,"d":"220508"},{"v":132304.51265816262,"d":"132305"},{"v":95259.24911387709,"d":"95259"},{"v":0.0166,"d":"0.017"},{"v":65027.8696218743,"d":"65028"},{"v":1823878.485251762,"d":"1823878"},{"v":110349.45267337243,"d":"110349"},null,{"v":14132.684610442906,"d":"14133"},{"v":202913.44694689848,"d":"202913"},{"v":12276.798038750268,"d":"12277"},{"v":21675.956540624764,"d":"21676"},{"v":607959.4950839204,"d":"607959"},{"v":36783.150891124125,"d":"36783"},{"v":144319.19804375147,"d":"144319"},null,{"v":0.3170491115862925,"d":"32%"},{"v":0.242422327787049,"d":"24%"},{"v":0.30807409825839793,"d":"31%"},null,{"v":220507.5210969377,"d":"220508"},{"v":99228.38449362197,"d":"99228"},{"v":71444.4368354078,"d":"71444"},{"v":507949.3335784747,"d":"507949"},{"v":30732.27268123169,"d":"30732"},{"v":14132.684610442906,"d":"14133"},{"v":190372.6461068194,"d":"190373"},{"v":11518.046553945363,"d":"11518"},{"v":21675.956540624764,"d":"21676"},{"v":438643.0505577621,"d":"438643"},{"v":26539.05999738023,"d":"26539"},{"v":140233.8160679651,"d":"140234"},{"$nulls":10},2,0.5]
[60,25,1.9,{"v":455195.0873531199,"d":"455195"},{"v":537643.7885134242,"d":"537644"},{"v":237414.2272870365,"d":"237414"},{"v":237414.2272870365,"d":"237414"},{"v":413203.0415378356,"d":"413203"},{"v":258251.9009611473,"d":"258252"},{"v":185941.368692026,"d":"185941"},{"v":226020.2091243611,"d":"226020"},{"v":141262.6307027257,"d":"141263"},{"v":101709.09410596249,"d":"101709"},0.018,{"v":68279.26310296799,"d":"68279"},{"v":2014006.227294928,"d":"2014006"},{"v":114147.71136895548,"d":"114148"},null,{"v":15244.66020462584,"d":"15245"},{"v":231174.86292652192,"d":"231175"},{"v":13102.283980788428,"d":"13102"},{"v":22759.754367655998,"d":"22760"},{"v":671335.409098309,"d":"671335"},{"v":38049.23712298514,"d":"38049"},{"v":152860.61520973605,"d":"152861"},null,{"v":0.33581341156073075,"d":"34%"},{"v":0.250766571389653,"d":"25%"},{"v":0.32553045286281107,"d":"33%"},null,{"v":226020.2091243611,"d":"226020"},{"v":107359.59933407154,"d":"107360"},{"v":77298.91152053149,"d":"77299"},{"v":542235.9135950217,"d":"542236"},{"v":30732.27268123169,"d":"30732"},{"v":15244.66020462584,"d":"15245"},{"v":217787.5580297375,"d":"217788"},{"v":12343.532495983523,"d":"12344"},{"v":22759.754367655998,"d":"22760"},{"v":490590.1045666351,"d":"490590"},{"v":27805.146229241247,"d":"27805"},{"v":148179.86292698796,"d":"148180"},{"$nulls":10},1.9,0.5]
[61,26,1.8,{"v":477499.64663342264,"d":"477500"},{"v":551084.8832262597,"d":"551085"},{"v":243349.5829692124,"d":"243350"},{"v":243349.5829692124,"d":"243350"},{"v":433863.19361472735,"d":"433863"},{"v":282011.0758495728,"d":"282011"},{"v":218840.59485926846,"d":"218841"},{"v":231670.71435247012,"d":"231671"},{"v":150585.9643291056,"d":"150586"},{"v":116854.70831938593,"d":"116855"},{"v":0.0194,"d":"0.019"},{"v":71624.94699501341,"d":"71625"},{"v":2220318.389140441,"d":"2220318"},{"v":126983.32254787584,"d":"126983"},null,{"v":16390.504456494717,"d":"16391"},{"v":262489.89612590545,"d":"262490"},{"v":15012.188931254195,"d":"15012"},{"v":23874.982331671134,"d":"23875"},{"v":740106.1297134801,"d":"740106"},{"v":42327.77418262526,"d":"42328"},{"v":174194.67143326538,"d":"174195"},null,{"v":0.3648058645936443,"d":"36%"},{"v":0.2659338565864137,"d":"27%"},{"v":0.3528391611278544,"d":"35%"},null,{"v":231670.71435247012,"d":"231671"},{"v":115835.35717623506,"d":"115835"},{"v":89888.23716875841,"d":"89888"},{"v":578836.8377626856,"d":"578837"},{"v":33104.542678073696,"d":"33105"},{"v":16390.504456494717,"d":"16391"},{"v":248198.94814858813,"d":"248199"},{"v":14194.868286884297,"d":"14195"},{"v":23874.982331671134,"d":"23875"},{"v":547160.5171259182,"d":"547161"},{"v":31292.926623267358,"d":"31293"},{"v":168480.57475698375,"d":"168481"},{"$nulls":10},1.8,0.5]
[62,27,1.7,{"v":500419.62967182684,"d":"500420"},{"v":564862.0053069162,"d":"564862"},{"v":249433.3225434427,"d":"249433"},{"v":249433.3225434427,"d":"249433"},{"v":455404.62159967923,"d":"455405"},{"v":307398.11957978347,"d":"307398"},{"v":255755.23549037986,"d":"255755"},{"v":237462.48221128184,"d":"237462"},{"v":160287.17549261526,"d":"160287"},{"v":133358.93000985586,"d":"133359"},{"v":0.0208,"d":"0.021"},{"v":75062.94445077404,"d":"75063"},{"v":2444004.5922441785,"d":"2444005"},{"v":141117.08919770442,"d":"141117"},null,{"v":17569.04149898689,"d":"17569"},{"v":297099.56981987826,"d":"297100"},{"v":17154.56125897598,"d":"17155"},{"v":25020.981483591342,"d":"25021"},{"v":814668.197414726,"d":"814668"},{"v":47039.02973256813,"d":"47039"},{"v":197552.52100139996,"d":"197553"},null,{"v":0.3947737244659129,"d":"39%"},{"v":0.28199750935079915,"d":"28%"},{"v":0.38132344989860667,"d":"38%"},null,{"v":237462.48221128184,"d":"237462"},{"v":124667.80316092298,"d":"124668"},{"v":103723.61222988789,"d":"103724"},{"v":617908.3243116668,"d":"617908"},{"v":35678.09340236367,"d":"35678"},{"v":17569.04149898689,"d":"17569"},{"v":281843.982854092,"d":"281844"},{"v":16273.702019412365,"d":"16274"},{"v":25020.981483591342,"d":"25021"},{"v":608698.7559775036,"d":"608699"},{"v":35146.33193178023,"d":"35146"},{"v":190821.73958344417,"d":"190822"},{"$nulls":10},1.7,0.5]
[63,28,1.6,{"v":523939.35226640257,"d":"523939"},{"v":578983.5554395891,"d":"578984"},{"v":255669.15560702872,"d":"255669"},{"v":255669.15560702872,"d":"255669"},{"v":477704.7878861232,"d":"477705"},{"v":334393.3515202863,"d":"334393"},{"v":296941.29615001415,"d":"296941"},{"v":243399.04426656387,"d":"243399"},{"v":170379.33098659472,"d":"170379"},{"v":151296.8459160961,"d":"151297"},{"v":0.022199999999999998,"d":"0.022"},{"v":78590.9028399604,"d":"78591"},{"v":2686332.720225583,"d":"2686333"},{"v":156682.12371726474,"d":"156682"},null,{"v":18778.91376615617,"d":"18779"},{"v":335259.9645378789,"d":"335260"},{"v":19554.25805808546,"d":"19554"},{"v":26196.96761332013,"d":"26197"},{"v":895444.240075194,"d":"895444"},{"v":52227.37457242157,"d":"52227"},{"v":223078.47854660312,"d":"223078"},null,{"v":0.4257715660822829,"d":"43%"},{"v":0.2990462980868023,"d":"30%"},{"v":0.4110328307354945,"d":"41%"},null,{"v":243399.04426656387,"d":"243399"},{"v":133869.47434661014,"d":"133869"},{"v":118876.09321978978,"d":"118876"},{"v":659617.1362027042,"d":"659617"},{"v":38472.60354698774,"d":"38473"},{"v":18778.91376615617,"d":"18779"},{"v":318974.6254519021,"d":"318975"},{"v":18604.404938911022,"d":"18604"},{"v":26196.96761332013,"d":"26197"},{"v":675571.8613409592,"d":"675572"},{"v":39403.17339009232,"d":"39403"},{"v":215356.27509578087,"d":"215356"},{"$nulls":10},1.6,0.5]
[64,29,1.5,{"v":548040.5624706569,"d":"548041"},{"v":593458.1443255787,"d":"593458"},{"v":262060.88449720442,"d":"262061"},{"v":262060.88449720442,"d":"262061"},{"v":500619.54285721725,"d":"500620"},{"v":362949.1685714825,"d":"362949"},{"v":342624.0151314795,"d":"342624"},{"v":249484.02037322792,"d":"249484"},{"v":180875.91477059026,"d":"180876"},{"v":170746.86354343718,"d":"170747"},{"v":0.0236,"d":"0.024"},{"v":82206.08437059855,"d":"82206"},{"v":2948653.8142919634,"d":"2948654"},{"v":173827.06867518634,"d":"173827"},null,{"v":20018.577458141677,"d":"20019"},{"v":377243.0471747408,"d":"377243"},{"v":22238.979954391918,"d":"22239"},{"v":27402.028123532848,"d":"27402"},{"v":982884.6047639875,"d":"982885"},{"v":57942.356225062096,"d":"57942"},{"v":250928.1997228912,"d":"250928"},null,{"v":0.4578642839713645,"d":"46%"},{"v":0.31717920274285055,"d":"32%"},{"v":0.4420289511821279,"d":"44%"},null,{"v":249484.02037322792,"d":"249484"},{"v":143453.31171460607,"d":"143453"},{"v":135419.9262585881,"d":"135420"},{"v":704141.2928963866,"d":"704141"},{"v":41510.066825774644,"d":"41510"},{"v":20018.577458141677,"d":"20019"},{"v":359858.44770046056,"d":"359858"},{"v":21214.134666667982,"d":"21214"},{"v":27402.028123532848,"d":"27402"},{"v":748170.8404651918,"d":"748171"},{"v":44105.66728313721,"d":"44106"},{"v":242249.79503416794,"d":"242250"},{"$nulls":10},1.5,0.5]
[65,30,1.25,{"v":572702.3877818363,"d":"572702"},{"v":608294.5979337181,"d":"608295"},{"v":268612.4066096345,"d":"268612"},{"v":268612.4066096345,"d":"268612"},{"v":524133.1814696287,"d":"524133"},{"v":393099.88610222156,"d":"393100"},{"v":393099.88610222156,"d":"393100"},{"v":255721.12088255858,"d":"255721"},{"v":191790.84066191895,"d":"191791"},{"v":191790.84066191895,"d":"191791"},0.025,{"v":85905.35816727547,"d":"85905"},{"v":3232407.2894385774,"d":"3232407"},{"v":192718.32310289307,"d":"192718"},null,{"v":21286.29868205413,"d":"21286"},{"v":423337.551392776,"d":"423338"},{"v":25239.673007008576,"d":"25240"},{"v":28635.11938909182,"d":"28635"},{"v":1077469.0964795253,"d":"1077469"},{"v":64239.44103429766,"d":"64239"},{"v":281269.9547032252,"d":"281270"},null,{"v":0.49112760956458834,"d":"49%"},{"v":0.3365069313737638,"d":"34%"},{"v":0.4743861720673088,"d":"47%"},null,{"v":255721.12088255858,"d":"255721"},{"v":153432.67252953516,"d":"153433"},{"v":153432.67252953516,"d":"153433"},{"v":751670.8301668926,"d":"751671"},{"v":44815.12660500259,"d":"44815"},{"v":21286.29868205413,"d":"21286"},{"v":404779.4914539819,"d":"404779"},{"v":24133.22883979827,"d":"24133"},{"v":28635.11938909182,"d":"28635"},{"v":826912.153090561,"d":"826912"},{"v":49301.0654992968,"d":"49301"},{"v":271682.0934736328,"d":"271682"},{"$nulls":10},1.25,0.5]
[66,31,1.25,{"v":597042.2392625642,"d":"597042"},{"v":623501.962882061,"d":"623502"},{"v":275327.71677487536,"d":"275328"},{"v":275327.71677487536,"d":"275328"},{"v":548227.4341729652,"d":"548227"},{"v":424876.2614840481,"d":"424876"},{"v":424876.2614840481,"d":"424876"},{"v":262114.14890462253,"d":"262114"},{"v":203138.46540108247,"d":"203138"},{"v":203138.46540108247,"d":"203138"},0.025,{"v":89556.33588938465,"d":"89556"},{"v":3539126.4945782735,"d":"3539126"},{"v":213542.66272494168,"d":"213543"},null,{"v":22520.016574138222,"d":"22520"},{"v":473849.91347390326,"d":"473850"},{"v":28591.001878631105,"d":"28591"},{"v":29852.111963128213,"d":"29852"},{"v":1179708.8315260906,"d":"1179709"},{"v":71180.88757498053,"d":"71181"},{"v":302910.3548546941,"d":"302910"},null,{"v":0.5073516326563986,"d":"51%"},{"v":0.35766759649819513,"d":"36%"},{"v":0.49355784163489547,"d":"49%"},null,{"v":262114.14890462253,"d":"262114"},{"v":163821.3430653891,"d":"163821"},{"v":163821.3430653891,"d":"163821"},{"v":802408.6112031578,"d":"802409"},{"v":48415.46966242666,"d":"48415"},{"v":22520.016574138222,"d":"22520"},{"v":454039.1844892405,"d":"454039"},{"v":27395.668559975267,"d":"27396"},{"v":29852.111963128213,"d":"29852"},{"v":912239.2944583714,"d":"912239"},{"v":55042.397687504985,"d":"55042"},{"v":294674.87897529604,"d":"294675"},{"$nulls":10},1.25,0.5]
[67,32,1.25,{"v":622416.5344312231,"d":"622417"},{"v":639089.5119541124,"d":"639090"},{"v":282210.90969424724,"d":"282211"},{"v":282210.90969424724,"d":"282211"},{"v":572595.0631716858,"d":"572595"},{"v":458076.05053734867,"d":"458076"},{"v":458076.05053734867,"d":"458076"},{"v":268667.00262723805,"d":"268667"},{"v":214933.60210179046,"d":"214934"},{"v":214933.60210179046,"d":"214934"},0.025,{"v":93362.48016468347,"d":"93362"},{"v":3870311.8438717593,"d":"3870312"},{"v":236502.2230033121,"d":"236502"},null,{"v":23814.39373158831,"d":"23814"},{"v":529043.2959198973,"d":"529043"},{"v":32328.122538283136,"d":"32328"},{"v":31120.826721561156,"d":"31121"},{"v":1290103.9479572524,"d":"1290104"},{"v":78834.07433443732,"d":"78834"},{"v":326095.7989745109,"d":"326096"},null,{"v":0.5239189207473479,"d":"52%"},{"v":0.3799741972141416,"d":"38%"},{"v":0.5131584864090927,"d":"51%"},null,{"v":268667.00262723805,"d":"268667"},{"v":174633.55170770476,"d":"174634"},{"v":174633.55170770476,"d":"174634"},{"v":856571.1924593708,"d":"856571"},{"v":52342.29161611493,"d":"52342"},{"v":23814.39373158831,"d":"23814"},{"v":507895.3427287698,"d":"507895"},{"v":31035.83960516728,"d":"31036"},{"v":31120.826721561156,"d":"31121"},{"v":1004580.2171374622,"d":"1004580"},{"v":61386.64379573236,"d":"61387"},{"v":319398.3267247193,"d":"319398"},{"$nulls":10},1.25,0.5]
[68,33,1.25,{"v":648869.2371445498,"d":"648869"},{"v":655066.7497529652,"d":"655067"},{"v":289266.1824366034,"d":"289266"},{"v":289266.1824366034,"d":"289266"},{"v":597387.0538252079,"d":"597387"},{"v":492844.31940579653,"d":"492844"},{"v":492844.3194057965,"d":"492844"},{"v":275383.67769291904,"d":"275384"},{"v":227191.5340966582,"d":"227192"},{"v":227191.53409665823,"d":"227192"},0.025,{"v":97330.38557168249,"d":"97330"},{"v":4227774.712456207,"d":"4227775"},{"v":261838.5375025439,"d":"261839"},null,{"v":25172.21382955625,"d":"25172"},{"v":589296.1813855857,"d":"589296"},{"v":36496.847818126,"d":"36497"},{"v":32443.461857227492,"d":"32443"},{"v":1409258.2374854016,"d":"1409258"},{"v":87279.51250084792,"d":"87280"},{"v":350967.8944156321,"d":"350968"},null,{"v":0.540891560771352,"d":"54%"},{"v":0.40353051510779764,"d":"40%"},{"v":0.5332601073920745,"d":"53%"},null,{"v":275383.67769291904,"d":"275384"},{"v":185883.98244272036,"d":"185884"},{"v":185883.98244272036,"d":"185884"},{"v":914389.7479503782,"d":"914390"},{"v":56630.84970096471,"d":"56631"},{"v":25172.21382955625,"d":"25172"},{"v":566720.7413540571,"d":"566721"},{"v":35098.68433890465,"d":"35099"},{"v":32443.461857227492,"d":"32443"},{"v":1104461.6548352756,"d":"1104462"},{"v":68402.56260052636,"d":"68403"},{"v":346016.0790831161,"d":"346016"},{"$nulls":10},1.25,0.5]
[{"$f":"A36+1","v":69},34,1.25,{"v":676446.179723193,"d":"676446"},{"$f":"E36*(1+$D$53)","v":{"v":671443.4184967893,"d":"671443"}},{"v":296497.8369975185,"d":"296498"},{"v":296497.8369975185,"d":"296498"},{"v":622776.0036127791,"d":"622776"},{"v":529359.6030708622,"d":"529360"},{"v":529359.6030708622,"d":"529360"},{"v":282268.269635242,"d":"282268"},{"v":239928.02918995573,"d":"239928"},{"v":239928.02918995573,"d":"239928"},0.025,{"v":100716.51277451841,"d":"100717"},{"v":4613455.539482837,"d":"4613456"},{"v":289825.9077208334,"d":"289826"},null,{"v":26246.19070494896,"d":"26246"},{"v":655015.4688844908,"d":"655015"},{"v":41149.297140926974,"d":"41149"},{"v":33572.17092483947,"d":"33572"},{"v":1537818.5131609447,"d":"1537819"},{"v":96608.6359069444,"d":"96609"},{"v":377685.96223782713,"d":"377686"},null,{"v":0.5583385250137404,"d":"56%"},{"v":0.4284537579019699,"d":"43%"},{"v":0.5539428256698667,"d":"55%"},null,{"v":282268.269635242,"d":"282268"},{"v":197587.7887446694,"d":"197588"},{"v":197587.7887446694,"d":"197588"},{"v":976111.0559370286,"d":"976111"},{"v":61321.12261669341,"d":"61321"},{"v":26246.19070494896,"d":"26246"},{"v":630916.186650834,"d":"630916"},{"v":39635.33514670929,"d":"39635"},{"v":33572.17092483947,"d":"33572"},{"v":1212448.1611819353,"d":"1212448"},{"v":76168.26170137995,"d":"76168"},{"v":374712.5082094521,"d":"374713"},{"$nulls":10},1.25,0.5]
[70,35,1.25,{"v":705195.1423614286,"d":"705195"},{"v":688229.503959209,"d":"688230"},{"v":303910.28292245645,"d":"303910"},{"v":303910.28292245645,"d":"303910"},{"v":649243.983766322,"d":"649244"},{"v":568088.4857955318,"d":"568088"},{"v":568088.4857955318,"d":"568088"},{"v":289324.976376123,"d":"289325"},{"v":253159.35432910768,"d":"253159"},{"v":253159.35432910768,"d":"253159"},0.025,{"v":103234.42559388136,"d":"103234"},{"v":5028659.472437622,"d":"5028659"},{"v":320727.58635694295,"d":"320728"},null,{"v":26902.345472572677,"d":"26902"},{"v":726277.6194901719,"d":"726278"},{"v":46321.94110595316,"d":"46322"},{"v":34411.47519796045,"d":"34411"},{"v":1676219.8241458728,"d":"1676220"},{"v":106909.19545231423,"d":"106909"},{"v":406390.4908873751,"d":"406390"},null,{"v":0.5762808993926545,"d":"58%"},{"v":0.45480685712460955,"d":"45%"},{"v":0.5752403177241391,"d":"58%"},null,{"v":289324.976376123,"d":"289325"},{"v":209760.6078726892,"d":"209761"},{"v":209760.6078726892,"d":"209761"},{"v":1041998.5522127779,"d":"1041999"},{"v":66458.60243080494,"d":"66459"},{"v":26902.345472572677,"d":"26902"},{"v":700551.6357057433,"d":"700552"},{"v":44681.13947063425,"d":"44681"},{"v":34411.47519796045,"d":"34411"},{"v":1328886.9734082806,"d":"1328887"},{"v":84756.32797537929,"d":"84756"},{"v":405656.67774950765,"d":"405657"},{"$nulls":10},1.25,0.5]
[71,36,1.25,{"v":735165.9359117892,"d":"735166"},{"v":705435.2415581892,"d":"705435"},{"v":311508.0399955178,"d":"311508"},{"v":311508.0399955178,"d":"311508"},{"v":676836.8530763905,"d":"676837"},{"v":609153.1677687515,"d":"609153"},{"v":609153.1677687515,"d":"609153"},{"v":296558.1007855261,"d":"296558"},{"v":266902.2907069735,"d":"266902"},{"v":266902.29070697346,"d":"266902"},0.025,{"v":105815.28623372839,"d":"105815"},{"v":5474484.562967847,"d":"5474485"},{"v":354825.5550995379,"d":"354826"},null,{"v":27574.904109386996,"d":"27575"},{"v":803026.1804231359,"d":"803026"},{"v":52047.67808745657,"d":"52048"},{"v":35271.76207790946,"d":"35272"},{"v":1824828.1876559476,"d":"1824828"},{"v":118275.18503317921,"d":"118275"},{"v":437225.15382760926,"d":"437225"},null,{"v":0.5947298867776578,"d":"59%"},{"v":0.4826468933975643,"d":"48%"},{"v":0.5971780685970423,"d":"60%"},null,{"v":296558.1007855261,"d":"296558"},{"v":222418.57558914457,"d":"222419"},{"v":222418.57558914457,"d":"222419"},{"v":1112333.4544871403,"d":"1112333"},{"v":72095.2504120714,"d":"72095"},{"v":27574.904109386996,"d":"27575"},{"v":775563.6927332584,"d":"775564"},{"v":50267.71280910124,"d":"50268"},{"v":35271.76207790946,"d":"35272"},{"v":1454050.369493568,"d":"1454050"},{"v":94243.43489582211,"d":"94243"},{"v":439024.97370613925,"d":"439025"},{"$nulls":10},1.25,0.5]
[72,37,1.25,{"v":766410.4881880401,"d":"766410"},{"v":723071.1225971439,"d":"723071"},{"v":319295.7409954057,"d":"319296"},{"v":319295.7409954057,"d":"319296"},{"v":705602.4193321369,"d":"705602"},{"v":652682.2378822267,"d":"652682"},{"v":652682.2378822267,"d":"652682"},{"v":303972.0533051642,"d":"303972"},{"v":281174.14930727694,"d":"281174"},{"v":281174.14930727694,"d":"281174"},0.025,{"v":108460.6683895716,"d":"108461"},{"v":5953062.61151238,"d":"5953063"},{"v":392507.09296462353,"d":"392507"},null,{"v":28264.276712121675,"d":"28264"},{"v":885648.3897595094,"d":"885648"},{"v":58394.02296576735,"d":"58394"},{"v":36153.55612985719,"d":"36154"},{"v":1984354.2038374583,"d":"1984354"},{"v":130835.6976548744,"d":"130836"},{"v":470403.8699279187,"d":"470404"},null,{"v":0.6137753556061779,"d":"61%"},{"v":0.5121369018482446,"d":"51%"},{"v":0.6198622238734952,"d":"62%"},null,{"v":303972.0533051642,"d":"303972"},{"v":235578.34131150227,"d":"235578"},{"v":235578.34131150227,"d":"235578"},{"v":1187415.9626650221,"d":"1187416"},{"v":78290.6577774146,"d":"78291"},{"v":28264.276712121675,"d":"28264"},{"v":856332.1841505652,"d":"856332"},{"v":56461.09879022327,"d":"56461"},{"v":36153.55612985719,"d":"36154"},{"v":1588548.8829491183,"d":"1588549"},{"v":104738.81172906957,"d":"104739"},{"v":475068.9096082097,"d":"475069"},{"$nulls":10},1.25,0.5]
[73,38,1.25,{"v":798982.9339360317,"d":"798983"},{"v":741147.9006620724,"d":"741148"},{"v":327278.1345202908,"d":"327278"},{"v":327278.1345202908,"d":"327278"},{"v":735590.5221537525,"d":"735591"},{"v":698810.9960460649,"d":"698811"},{"v":698810.9960460649,"d":"698811"},{"v":311571.3546377933,"d":"311571"},{"v":295992.78690590366,"d":"295993"},{"v":295992.78690590366,"d":"295993"},0.025,{"v":111172.18509931087,"d":"111172"},{"v":6466670.936847273,"d":"6466671"},{"v":434218.4411184473,"d":"434218"},null,{"v":28970.88362992471,"d":"28971"},{"v":974558.0467800334,"d":"974558"},{"v":65438.7829510582,"d":"65439"},{"v":37057.39503310362,"d":"37057"},{"v":2155556.9789490895,"d":"2155557"},{"v":144739.48037281565,"d":"144739"},{"v":506171.05022977747,"d":"506171"},null,{"v":0.6335192264198006,"d":"63%"},{"v":0.5434639748553275,"d":"54%"},{"v":0.6434133469781868,"d":"64%"},null,{"v":311571.3546377933,"d":"311571"},{"v":249257.08371023467,"d":"249257"},{"v":249257.08371023467,"d":"249257"},{"v":1267566.540144911,"d":"1267567"},{"v":85113.46447821056,"d":"85113"},{"v":28970.88362992471,"d":"28971"},{"v":943262.9972924854,"d":"943263"},{"v":63337.40996704291,"d":"63337"},{"v":37057.39503310362,"d":"37057"},{"v":1733034.7989007863,"d":"1733035"},{"v":116368.3255467455,"d":"116368"},{"v":514076.28370223363,"d":"514076"},{"$nulls":10},1.25,0.5]
[74,39,1.25,{"v":832939.7086283128,"d":"832940"},{"v":759676.5981786241,"d":"759677"},{"v":335460.08788329805,"d":"335460"},{"v":335460.08788329805,"d":"335460"},{"v":759676.5981786241,"d":"759677"},{"v":740684.6832241585,"d":"740685"},{"v":740684.6832241585,"d":"740685"},{"v":319360.6385037381,"d":"319361"},{"v":311376.62254114466,"d":"311377"},{"v":311376.62254114466,"d":"311377"},0.025,{"v":113951.48972679363,"d":"113951"},{"v":7017742.239118717,"d":"7017742"},{"v":480476.1853958777,"d":"480476"},null,{"v":29695.155720672825,"d":"29695"},{"v":1070197.3154172366,"d":"1070197"},{"v":73272.04479900593,"d":"73272"},{"v":37983.829908931206,"d":"37984"},{"v":2339247.4130395707,"d":"2339247"},{"v":160158.72846529246,"d":"160159"},{"v":544807.395805443,"d":"544807"},null,{"v":0.6540778283972477,"d":"65%"},{"v":0.5768438944844244,"d":"58%"},{"v":0.6679692320086489,"d":"67%"},null,{"v":319360.6385037381,"d":"319361"},{"v":263472.52676558396,"d":"263473"},{"v":263472.52676558396,"d":"263473"},{"v":1353127.2816046923,"d":"1353127"},{"v":92643.10549857997,"d":"92643"},{"v":29695.155720672825,"d":"29695"},{"v":1036789.8500892792,"d":"1036790"},{"v":70984.77191869881,"d":"70985"},{"v":37983.829908931206,"d":"37984"},{"v":1888204.9858380072,"d":"1888205"},{"v":129277.69329909916,"d":"129278"},{"v":556378.0974819618,"d":"556378"},{"$nulls":10},1.25,0.5]
[75,40,1.25,{"v":868339.6462450159,"d":"868340"},{"v":778668.5131330896,"d":"778669"},{"v":343846.5900803805,"d":"343847"},{"v":343846.5900803805,"d":"343847"},{"v":778668.5131330896,"d":"778669"},{"v":778668.5131330896,"d":"778669"},{"v":778668.5131330896,"d":"778669"},{"v":327344.6544663315,"d":"327345"},{"v":327344.6544663315,"d":"327345"},{"v":327344.6544663315,"d":"327345"},0.025,{"v":116800.27696996347,"d":"116800"},{"v":7608875.12964434,"d":"7608875"},{"v":531881.371372857,"d":"531881"},null,{"v":30437.534613689644,"d":"30438"},{"v":1173038.6496994398,"d":"1173039"},{"v":81998.63909511498,"d":"81999"},{"v":38933.42565665449,"d":"38933"},{"v":2536291.709881445,"d":"2536292"},{"v":177293.7904576189,"d":"177294"},{"v":586637.0840190654,"d":"586637"},null,{"v":0.6755848204741953,"d":"68%"},{"v":0.6125268766350652,"d":"61%"},{"v":0.6936883906453143,"d":"69%"},null,{"v":327344.6544663315,"d":"327345"},{"v":278242.95629638183,"d":"278243"},{"v":278242.95629638183,"d":"278243"},{"v":1444463.373113009,"d":"1444463"},{"v":100971.9763695375,"d":"100972"},{"v":30437.534613689644,"d":"30438"},{"v":1137376.1804618454,"d":"1137376"},{"v":79505.73407020091,"d":"79506"},{"v":38933.42565665449,"d":"38933"},{"v":2054803.9188437758,"d":"2054804"},{"v":143636.4650011064,"d":"143636"},{"v":602357.1317372266,"d":"602357"},{"$nulls":10},1.25,0.5]
[76,41,1.25,{"v":905244.0812104288,"d":"905244"},{"v":798135.2259614168,"d":"798135"},{"v":352442.75483239,"d":"352443"},{"v":352442.75483239,"d":"352443"},{"v":798135.2259614168,"d":"798135"},{"v":798135.2259614168,"d":"798135"},{"v":798135.2259614168,"d":"798135"},{"v":335528.2708279898,"d":"335528"},{"v":335528.2708279898,"d":"335528"},{"v":335528.2708279898,"d":"335528"},0.025,{"v":119720.28389421254,"d":"119720"},{"v":8242845.372515069,"d":"8242845"},{"v":589137.148994462,"d":"589137"},null,{"v":31198.47297903188,"d":"31198"},{"v":1283586.8494329802,"d":"1283587"},{"v":91741.22075408946,"d":"91741"},{"v":39906.76129807084,"d":"39907"},{"v":2747615.124171688,"d":"2747615"},{"v":196379.04966482054,"d":"196379"},{"v":623648.5412468999,"d":"623649"},null,{"v":0.6889286041097344,"d":"69%"},{"v":0.6508047511414923,"d":"65%"},{"v":0.7207544097638255,"d":"72%"},null,{"v":335528.2708279898,"d":"335528"},{"v":293587.2369744911,"d":"293587"},{"v":293587.2369744911,"d":"293587"},{"v":1541964.6507981368,"d":"1541965"},{"v":110208.14017093158,"d":"110208"},{"v":31198.47297903188,"d":"31198"},{"v":1245517.1635218482,"d":"1245517"},{"v":89020.28335841978,"d":"89020"},{"v":39906.76129807084,"d":"39907"},{"v":2233626.9072389766,"d":"2233627"},{"v":159643.00294117673,"d":"159643"},{"v":652458.6634450192,"d":"652459"},{"$nulls":10},1.25,0.5]
[77,42,1.25,{"v":943716.9546618719,"d":"943717"},{"v":818088.6066104522,"d":"818089"},{"v":361253.82370319974,"d":"361254"},{"v":361253.82370319974,"d":"361254"},{"v":818088.6066104522,"d":"818089"},{"v":818088.6066104522,"d":"818089"},{"v":818088.6066104522,"d":"818089"},{"v":343916.4775986895,"d":"343916"},{"v":343916.4775986895,"d":"343916"},{"v":343916.4775986895,"d":"343916"},0.025,{"v":122713.29099156785,"d":"122713"},{"v":8922617.886070067,"d":"8922618"},{"v":653071.0209789559,"d":"653071"},null,{"v":31978.434803507673,"d":"31978"},{"v":1402381.2549205052,"d":"1402381"},{"v":102644.15327955599,"d":"102644"},{"v":40904.43033052261,"d":"40904"},{"v":2974205.9620233537,"d":"2974206"},{"v":217690.34032631846,"d":"217690"},{"v":664250.971204564,"d":"664251"},null,{"v":0.703866734536481,"d":"70%"},{"v":0.6920200148496297,"d":"69%"},{"v":0.7493814447656288,"d":"75%"},null,{"v":343916.4775986895,"d":"343916"},{"v":309524.82983882056,"d":"309525"},{"v":309524.82983882056,"d":"309525"},{"v":1646047.2647270109,"d":"1646047"},{"v":120478.74082259506,"d":"120479"},{"v":31978.434803507673,"d":"31978"},{"v":1361741.8652103718,"d":"1361742"},{"v":99669.6442207972,"d":"99670"},{"v":40904.43033052261,"d":"40904"},{"v":2425523.540447684,"d":"2425524"},{"v":177530.76005212017,"d":"177531"},{"v":707203.974934333,"d":"707204"},{"$nulls":10},1.25,0.5]
[78,43,1.25,{"v":983824.9252350013,"d":"983825"},{"v":838540.8217757134,"d":"838541"},{"v":370285.1692957797,"d":"370285"},{"v":370285.1692957797,"d":"370285"},{"v":838540.8217757134,"d":"838541"},{"v":838540.8217757134,"d":"838541"},{"v":838540.8217757134,"d":"838541"},{"v":352514.38953865675,"d":"352514"},{"v":352514.38953865675,"d":"352514"},{"v":352514.38953865675,"d":"352514"},0.025,{"v":125781.12326635703,"d":"125781"},{"v":9651359.555562783,"d":"9651360"},{"v":724663.159844861,"d":"724663"},null,{"v":32777.895673595354,"d":"32778"},{"v":1529998.0901072081,"d":"1529998"},{"v":114878.45252792886,"d":"114878"},{"v":41927.04108878567,"d":"41927"},{"v":3217119.8518542587,"d":"3217120"},{"v":241554.3866149535,"d":"241554"},{"v":708947.2286815391,"d":"708947"},null,{"v":0.7206030366756528,"d":"72%"},{"v":0.7365773536097029,"d":"74%"},{"v":0.7798212100117289,"d":"78%"},null,{"v":352514.38953865675,"d":"352514"},{"v":326075.8103232575,"d":"326076"},{"v":326075.8103232575,"d":"326076"},{"v":1757155.455096084,"d":"1757155"},{"v":131934.3473940561,"d":"131934"},{"v":32777.895673595354,"d":"32778"},{"v":1486615.5415916408,"d":"1486616"},{"v":111621.11510220896,"d":"111621"},{"v":41927.04108878567,"d":"41927"},{"v":2631401.3668222316,"d":"2631401"},{"v":197576.27081693488,"d":"197576"},{"v":767207.5436364574,"d":"767208"},{"$nulls":10},1.25,0.5]
[79,44,1.25,{"v":1025637.4845574886,"d":"1025637"},{"v":859504.3423201061,"d":"859504"},{"v":379542.2985281742,"d":"379542"},{"v":379542.2985281742,"d":"379542"},{"v":859504.3423201061,"d":"859504"},{"v":859504.3423201061,"d":"859504"},{"v":859504.3423201061,"d":"859504"},{"v":361327.24927712313,"d":"361327"},{"v":361327.24927712313,"d":"361327"},{"v":361327.24927712313,"d":"361327"},0.025,{"v":128925.65134801593,"d":"128926"},{"v":10432452.911800832,"d":"10432453"},{"v":805082.8164462468,"d":"805083"},null,{"v":33597.34306543524,"d":"33597"},{"v":1667052.9641810027,"d":"1667053"},{"v":128648.14314663725,"d":"128648"},{"v":42975.21711600531,"d":"42975"},{"v":3477484.303933608,"d":"3477484"},{"v":268360.93881541543,"d":"268361"},{"v":758336.3312391757,"d":"758336"},null,{"v":0.7393804757110257,"d":"74%"},{"v":0.7849584561484704,"d":"78%"},{"v":0.8123719654142768,"d":"81%"},null,{"v":361327.24927712313,"d":"361327"},{"v":343260.88681326696,"d":"343261"},{"v":343260.88681326696,"d":"343261"},{"v":1875763.4483150693,"d":"1875763"},{"v":144754.53977349814,"d":"144755"},{"v":33597.34306543524,"d":"33597"},{"v":1620742.0936406348,"d":"1620742"},{"v":125074.28698817403,"d":"125074"},{"v":42975.21711600531,"d":"42975"},{"v":2852229.8211619193,"d":"2852230"},{"v":220109.42555758276,"d":"220109"},{"v":833199.1391325219,"d":"833199"},{"$nulls":10},1.25,0.5]
[80,45,1.25,{"v":1069227.0776511815,"d":"1069227"},{"v":880991.9508781087,"d":"880992"},{"v":389030.8559913785,"d":"389031"},{"v":389030.8559913785,"d":"389031"},{"v":880991.9508781087,"d":"880992"},{"v":880991.9508781087,"d":"880992"},{"v":880991.9508781087,"d":"880992"},{"v":370360.4305090512,"d":"370360"},{"v":370360.4305090512,"d":"370360"},{"v":370360.4305090512,"d":"370360"},0.025,{"v":132148.79263171632,"d":"132149"},{"v":11269510.734240886,"d":"11269511"},{"v":895735.6520568638,"d":"895736"},null,{"v":34437.27664207112,"d":"34437"},{"v":1814203.5423295675,"d":"1814204"},{"v":144198.52212527403,"d":"144199"},{"v":44049.59754390544,"d":"44050"},{"v":3756503.578080293,"d":"3756504"},{"v":298578.55068562104,"d":"298579"},{"v":813137.5033199464,"d":"813138"},null,{"v":0.7604909380953965,"d":"76%"},{"v":0.8377412719705584,"d":"84%"},{"v":0.8473901978619175,"d":"85%"},null,{"v":370360.4305090512,"d":"370360"},{"v":361101.41974632494,"d":"361101"},{"v":361101.41974632494,"d":"361101"},{"v":2002377.4810763362,"d":"2002377"},{"v":159155.1701731184,"d":"159155"},{"v":34437.27664207112,"d":"34437"},{"v":1764766.6880277246,"d":"1764767"},{"v":140269.12767612943,"d":"140269"},{"v":44049.59754390544,"d":"44050"},{"v":3089044.417721515,"d":"3089044"},{"v":245526.82729458172,"d":"245527"},{"v":906052.5448901545,"d":"906053"},{"$nulls":10},1.25,0.5]
[81,46,1.25,{"v":1114669.2284513565,"d":"1114669"},{"v":903016.7496500614,"d":"903017"},{"v":398756.6273911629,"d":"398757"},{"v":398756.6273911629,"d":"398757"},{"v":903016.7496500614,"d":"903017"},{"v":903016.7496500614,"d":"903017"},{"v":903016.7496500614,"d":"903017"},{"v":379619.4412717774,"d":"379619"},{"v":379619.4412717774,"d":"379619"},{"v":379619.4412717774,"d":"379619"},0.025,{"v":135452.51244750922,"d":"135453"},{"v":12166391.640967984,"d":"12166392"},{"v":998326.0184834509,"d":"998326"},null,{"v":35298.2085581229,"d":"35298"},{"v":1972152.397079819,"d":"1972152"},{"v":161827.03208316606,"d":"161827"},{"v":45150.83748250307,"d":"45151"},{"v":4055463.880322658,"d":"4055464"},{"v":332775.33949448337,"d":"332775"},{"v":874221.8128494269,"d":"874222"},null,{"v":0.784288101380541,"d":"78%"},{"v":0.8956253505539533,"d":"90%"},{"v":0.8853059903335363,"d":"89%"},null,{"v":379619.4412717774,"d":"379619"},{"v":379619.4412717774,"d":"379619"},{"v":379619.4412717774,"d":"379619"},{"v":2137537.9610489886,"d":"2137538"},{"v":175397.9178859878,"d":"175398"},{"v":35298.2085581229,"d":"35298"},{"v":1919378.555112602,"d":"1919379"},{"v":157496.619164861,"d":"157497"},{"v":45150.83748250307,"d":"45151"},{"v":3342951.226639663,"d":"3342951"},{"v":274309.3668658209,"d":"274309"},{"v":986823.345188447,"d":"986823"},{"$nulls":10},1.25,0.5]
[82,47,1.25,{"v":1162042.6706605388,"d":"1162043"},{"v":925592.1683913128,"d":"925592"},{"v":408725.54307594197,"d":"408726"},{"v":408725.54307594197,"d":"408726"},{"v":925592.1683913128,"d":"925592"},{"v":925592.1683913128,"d":"925592"},{"v":925592.1683913128,"d":"925592"},{"v":389109.92730357184,"d":"389110"},{"v":389109.92730357184,"d":"389110"},{"v":389109.92730357184,"d":"389110"},0.025,{"v":138838.82525869695,"d":"138839"},{"v":13127216.732203305,"d":"13127217"},{"v":1114939.9993481978,"d":"1114940"},null,{"v":36180.66377207596,"d":"36181"},{"v":2141650.052416788,"d":"2141650"},{"v":181897.7591942953,"d":"181898"},{"v":46279.608419565644,"d":"46280"},{"v":4375738.910734431,"d":"4375739"},{"v":371646.66644939885,"d":"371647"},{"v":942654.352947266,"d":"942654"},null,{"v":0.8112045940717769,"d":"81%"},{"v":0.9594656267780886,"d":"96%"},{"v":0.9182722641348001,"d":"92%"},null,{"v":389109.92730357184,"d":"389110"},{"v":389109.92730357184,"d":"389110"},{"v":389109.92730357184,"d":"389110"},{"v":2281821.773419795,"d":"2281822"},{"v":193803.02911646696,"d":"193803"},{"v":36180.66377207596,"d":"36181"},{"v":2085313.9761167835,"d":"2085314"},{"v":177112.94104475414,"d":"177113"},{"v":46279.608419565644,"d":"46280"},{"v":3615131.6529278345,"d":"3615132"},{"v":307045.65674391005,"d":"307046"},{"v":1067071.5542087029,"d":"1067072"},{"$nulls":10},1.25,0.5]
[]
["Hire Age","Start Salary","interest","inflation","Minimum retirement age","Age Factor","UC Pension COLA","2nd Choice Start Must be between 5 and 10 years","Annuity End Age",{"$nulls":7},"Faculty = 1 or Staff (Faculty=0)"]
[{"$f":"Home_Page!D4","v":35},{"$f":"Home_Page!D6","v":125000},{"$f":"Home_Page!I3/100","v":{"v":0.0675,"d":"6.75%"}},{"$f":"Home_Page!I5/100","v":{"v":0.025,"d":"2.50%"}},{"$f":"Home_Page!D9","v":60},{"$f":"0.018 + IF(AND($E$53>60,$E$53<65),0.0014*($E$53-60)) + IF($E$53>64,(0.025-0.018),0)","v":0.018},{"$f":"MIN(D53,IF(D53<0.04,0.02,MIN(0.06,(0.02+0.75*(D53-0.04)))))","v":{"v":0.02,"d":"2.00%"}},{"$f":"Home_Page!I7","v":6},{"$f":"Home_Page!I10","v":100},"Cells in Blue on this row should only be changed on the Home Page",{"$nulls":6},{"$f":"IF(Home_Page!$D$3=\"YES\",1,0)","v":1}]
[]
["Entries in the next 5 rows should not be changed"]
[0.08,"UC contribution to savings"]
[0.07,"UC Employee contribution to savings"]
[{"$f":"VLOOKUP($E$53,A3:D50,4)","v":{"v":455195.0873531199,"d":"455195"}},"Salary at retirement age (in cell $e$53)"]
[null,null,{"$f":"(1+$C$53)^(1/12)","v":1.0054581304569468},"Annual rate of return corresponding to receiving monthly savings increments"]
[null,null,{"$f":"C59^11+C59^10+C59^9+C59^8+C59^7+C59^6+C59^5+C59^4+C59^3+C59^2+C59+1","v":12.36687186802058},"Used to accumulate monthly savings increments"]
[]
["Each row corresponds to the situation at the start of the year for stock variables like savings balances"]
["Columns Q, Y, and AP give the expected annual payout from Savings Choice, Pension Choice, and Second Choice (with election at service year in cell $H$53)"]
["Each row from Service year 1 - 34 corresponds to separating at age given in row A and retiring at age Max(Age, Minimum Retirement Age in cell $E$53)"]
["All savings balances are converted to an annuity starting at Max(age in Col A, minimum retirement age in Cell $E$53) and ending at age in Cell $I$53 with payouts growing at the UC Pension COLA rate in cell $G$53"]
["The Replacement Ratios give the ratio of the pension payouts to projected UC salary in column D"]
[]
["Full descriptions of each column are given in:"]
["https://senate.universityofcalifornia.edu/_files/committees/tfir/excel-sheet-description.pdf"]