{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Instructions","Main","Data","Starting Bal","Addnl Info","30-yr","Budget Sum","Thermometer","Chart - Expenses","Chart - FP","Chart - Cash","Chart - %","Solver","Coding-F","Coding-B","Output-F","Output-B","SA Risk","wksCommandBars"],"not_rendered":{"charts":12,"images":5,"macros":1,"external_links":0,"defined_names":188,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Chart - Expenses","index":8,"reason":"not_a_worksheet"},{"sheet":"Chart - FP","index":9,"reason":"not_a_worksheet"},{"sheet":"Chart - Cash","index":10,"reason":"not_a_worksheet"},{"sheet":"Chart - %","index":11,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ARInc Reserves Analysis Spreadsheet!"]
[null,{"$f":"Main!D7","v":"Analysis File V4.1, 9/14"}]
[]
[]
[]
[]
[]
[null,"This File will enable you to:"]
[null,"1)","Work with Reserve Data"]
[null,"2)","Compute your Percent Funded"]
[null,"3)","Test various Funding Plans"]
[]
[null,"This file is provided and intended only for same-year adjustments of Reserve Study information,"]
[null,"not multi-year updating of Reserve Studies. Multi-year use is not intended or supported."]
[]
[null,"Think of the Main sheet as your control panel, where you enter information about"]
[null,"your association and test your Funding Plan ideas."]
[]
[null,"The left-most portion of the Data Sheet is where your Reserve Component data goes."]
[]
[null,"Only make entries in cells that are colored orange, as shown below:"]
[null,null,25.55]
[]
[null,"Macros are provided to print key pages, add rows, and delete rows."]

{"sheet":"Main","index":1,"n_rows":91,"n_cols":6,"rows_kept":91,"cut":false,"hidden":false,"merged":[[15,4,15,5],[50,2,50,5]]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Analysis File V4.1, 9/14"]
[]
[null,null,null,"Starting Information:"]
[null,null,"Client #:","16151-1"]
[null,null,"Name:","Kings Row HOA"]
[null,null,"Location:","Carbondale, CO"]
[null,null,"# Units:",45]
[null,null,"Base Yr:",2015]
[null,null,"Period Start:","2015-01-01"]
[null,null,"Period End:","2015-12-31","date problem?"]
[null,null,"Site Inspection Date:","2014-09-28"]
[null,null,"Total Assessmts.",null,"Per Unit:",{"$f":"D18/D13","v":0}]
[null,null,"Budgeted Res Contribs.",170,"Per Unit:",{"$f":"D19/D13","v":3.7777777777777777}]
[null,null,"Starting Reserve Bal:",175103.11]
[null,null,"Interest:",0.01]
[null,null,"Inflation:",0.03]
[]
[null,null,null,"Status:"]
[null,null,"Proportional FFB:",{"$f":"Data!DV$42+(1-D61)*(Data!DW42-Data!DV42)","v":102591.66666666666}]
[null,null,"Percent Funded:",{"$f":"D20/D25","v":1.7067966209081309}]
[null,null,"Swain Factor:",{"$f":"10*STDEV(Data!BB42:BF42,Data!BI42:BM42,Data!BP42:BT42,Data!BW42:CA42,Data!CD42:CH42,Data!CK42:CP42)/SUM(Data!BB42:BF42,Data!BI42:BM42,Data!BP42:BT42,Data!BW42:CA42,Data!CD42:CH42,Data!CK42:CP42)/31","v":1.8320424232015152E-2}]
[]
["TempStorage",null,null,"Recommendation:"]
[700,null,"Recommended Contrib Rate:",720,"Per Unit:",{"$f":"D30/D13","v":16}]
[null,null,"Alternate Contrib Rate:",495,"Per Unit:",{"$f":"D31/D13","v":11}]
[null,null,"Annual Increase:",0.03]
[null,null,"# of Years:",25]
[null,null,"Secondary Increase:",2.5000000000000001E-2]
[null,null,"# of Years:",30]
[null,null,"1st Yr S.A.:",0,"Per Unit:",{"$f":"D36/D$13","v":0}]
[null,null,"2nd Yr S.A.:",0,"Per Unit:",{"$f":"D37/D$13","v":0}]
[null,null,"3rd Yr S.A.:",0,"Per Unit:",{"$f":"D38/D$13","v":0}]
[null,null,"4th Yr S.A.:",0,"Per Unit:",{"$f":"D39/D$13","v":0}]
[null,null,"5th Yr S.A.:",0,"Per Unit:",{"$f":"D40/D$13","v":0}]
[]
[null,null,"Minimum Balance(Full):",{"$f":"MIN('30-yr'!C14:C43)","v":128598.57151342204}]
[null,null,"Min Margin (Full):",{"$f":"Solver!MinEndBalanceMargin","v":1}]
[null,null,"Minimum Balance(Alt):",{"$f":"MIN(Data!BB7:BF7,Data!BI7:BM7,Data!BP7:BT7,Data!BW7:CA7,Data!CD7:CH7,Data!CK7:CP7)","v":18461.651359116702}]
[null,null,"Min Margin (Alt):",{"$f":"MIN(Data!BB9:BF9,Data!BI9:BM9,Data!BP9:BT9,Data!BW9:CA9,Data!CD9:CH9,Data!CK9:CP9)","v":-0.3304751981881705}]
[null,null,null,"System Defaults:"]
[null,null,"Current Annual Increase:",0.03]
[null,null,"Budget Cycles Per Year:",12]
[]
[null,null,"Project Manager Notes:"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Risk of Special Assessment:",{"$f":"OFFSET(C77,MATCH(PercentFunded,C77:C87,-1)-1,1)","v":"under 1%"}]
[null,null,"Text Budget Cycles:",{"$f":"LOOKUP(D48,C89:C91,D89:D91)","v":"Monthly"},"(Monthly/Annual/Quarterly)"]
[null,null,"Initial Year Fraction:",{"$f":"ROUND((EndDate-StartDate)/30,0)/12","v":1}]
[null,null,"System Information"]
[null,null,"Period Start:",{"$f":"D15","v":"2015-01-01"}]
[null,null,"Period End:",{"$f":"D16","v":"2015-12-31"}]
[null,null,"SI Date:",{"$f":"D17","v":"2014-09-28"}]
[null,null,"Cycles this first Yr:",{"$f":"IF(D48=12,ROUND((D16-D15)/30,0),D48)","v":12}]
[null,null,"Annualized Cmpnded Int.:",{"$f":"(1+(D21/12))^12-1","v":1.0045960887180572E-2}]
[null,null,"Deficit per unit:",{"$f":"(FullyFunded-StartingBalance)/NumUnits","v":-1611.3654074074072}]
[null,null,"Solver Success:","Success"]
[null,null,"Solver Cycle1:",296]
[null,null,"Solver Cycle2:",9]
[null,null,"Solver Cycle3:",7]
[null,null,"Expense total, first 5 yrs:",{"$f":"SUM(Data!BB42:BF42)","v":52846.166847499997}]
[null,null,"Expense total, second 5 yrs:",{"$f":"SUM(Data!BI42:BM42)","v":17062.335025381872}]
[null,null,"Expense total, first 10 years:",{"$f":"D73+D74","v":69908.501872881869}]
[null,null,"Special Assmt Risk Ranges - lookup based on Percent Funded"]
[null,"up to",99999999,"under 1%"]
[null,"up to",1,"under 1%"]
[null,"up to",0.9,"approx 1%"]
[null,"up to",0.8,"approx 2%"]
[null,"up to",0.7,"approx 3%"]
[null,"up to",0.6,"approx 6%"]
[null,"up to",0.5,"approx 13%"]
[null,"up to",0.4,"approx 20%"]
[null,"up to",0.3,"approx 35%"]
[null,"up to",0.2,"approx 48%"]
[null,"up to",0.1,"approx 58%"]
[]
[null,null,1,"Annual"]
[null,null,4,"Quarterly"]
[null,null,12,"Monthly"]

{"sheet":"Data","index":2,"n_rows":44,"n_cols":161,"rows_kept":44,"cut":false,"hidden":false,"merged":[[28,9,28,10],[28,23,28,24]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year Increment",0,1,2,3,4,null,"Year Increment",5,6,7,8,9,null,"Year Increment",10,11,12,13,14,null,"Year Increment",15,16,17,18,19,null,"Year Increment",20,21,22,23,24,null,"Year Increment",25,26,27,28,29,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inflation",{"$f":"(1+Main!$D$22)^BB2","v":1},{"$f":"(1+Main!$D$22)^BC2","v":1.03},{"$f":"(1+Main!$D$22)^BD2","v":1.0609},{"$f":"(1+Main!$D$22)^BE2","v":1.092727},{"$f":"(1+Main!$D$22)^BF2","v":1.1255088099999999},null,"Inflation",{"$f":"(1+Main!$D$22)^BI2","v":1.1592740742999998},{"$f":"(1+Main!$D$22)^BJ2","v":1.1940522965289999},{"$f":"(1+Main!$D$22)^BK2","v":1.22987386542487},{"$f":"(1+Main!$D$22)^BL2","v":1.2667700813876159},{"$f":"(1+Main!$D$22)^BM2","v":1.3047731838292445},null,"Inflation",{"$f":"(1+Main!$D$22)^BP2","v":1.3439163793441218},{"$f":"(1+Main!$D$22)^BQ2","v":1.3842338707244455},{"$f":"(1+Main!$D$22)^BR2","v":1.4257608868461786},{"$f":"(1+Main!$D$22)^BS2","v":1.4685337134515639},{"$f":"(1+Main!$D$22)^BT2","v":1.512589724855111},null,"Inflation",{"$f":"(1+Main!$D$22)^BW2","v":1.5579674166007644},{"$f":"(1+Main!$D$22)^BX2","v":1.6047064390987871},{"$f":"(1+Main!$D$22)^BY2","v":1.6528476322717507},{"$f":"(1+Main!$D$22)^BZ2","v":1.7024330612399032},{"$f":"(1+Main!$D$22)^CA2","v":1.7535060530771003},null,"Inflation",{"$f":"(1+Main!$D$22)^CD2","v":1.8061112346694133},{"$f":"(1+Main!$D$22)^CE2","v":1.8602945717094954},{"$f":"(1+Main!$D$22)^CF2","v":1.9161034088607805},{"$f":"(1+Main!$D$22)^CG2","v":1.973586511126604},{"$f":"(1+Main!$D$22)^CH2","v":2.0327941064604018},null,"Inflation",{"$f":"(1+Main!$D$22)^CK2","v":2.0937779296542138},{"$f":"(1+Main!$D$22)^CL2","v":2.1565912675438406},{"$f":"(1+Main!$D$22)^CM2","v":2.2212890055701555},{"$f":"(1+Main!$D$22)^CN2","v":2.2879276757372602},{"$f":"(1+Main!$D$22)^CO2","v":2.3565655060093778},{"$f":"(1+Main!$D$22)^CP2","v":2.4272624711896591}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alt Contribution rate (total)",{"$f":"Main!$D48*Main!$D61*Main!$D31","v":5940},{"$f":"IF(BC2<=Main!$D33,(Main!$D31*Main!$D48)*(1+Main!$D32),IF(BC2<=(Main!$D33+Main!$D35),(Main!$D31*Main!$D48)*(1+Main!$D34),(Main!$D31*Main!$D48)))","v":6118.2},{"$f":"IF(BD2<=Main!$D33,BC4*(1+Main!$D32),IF(BD2<=(Main!$D35),BC4*(1+Main!$D34),BC4))","v":6301.7460000000001},{"$f":"IF(BE2<=Main!$D33,BD4*(1+Main!$D32),IF(BE2<=(Main!$D35),BD4*(1+Main!$D34),BD4))","v":6490.7983800000002},{"$f":"IF(BF2<=Main!$D33,BE4*(1+Main!$D32),IF(BF2<=(Main!$D35),BE4*(1+Main!$D34),BE4))","v":6685.5223314000004},null,"Alt Contribution rate (total)",{"$f":"IF(BI2<=Main!$D33,BF4*(1+Main!$D32),IF(BI2<=(Main!$D35),BF4*(1+Main!$D34),BF4))","v":6886.088001342001},{"$f":"IF(BJ2<=Main!$D33,BI4*(1+Main!$D32),IF(BJ2<=(Main!$D35),BI4*(1+Main!$D34),BI4))","v":7092.6706413822612},{"$f":"IF(BK2<=Main!$D33,BJ4*(1+Main!$D32),IF(BK2<=(Main!$D35),BJ4*(1+Main!$D34),BJ4))","v":7305.4507606237294},{"$f":"IF(BL2<=Main!$D33,BK4*(1+Main!$D32),IF(BL2<=(Main!$D35),BK4*(1+Main!$D34),BK4))","v":7524.6142834424418},{"$f":"IF(BM2<=Main!$D33,BL4*(1+Main!$D32),IF(BM2<=(Main!$D35),BL4*(1+Main!$D34),BL4))","v":7750.3527119457149},null,"Alt Contribution rate (total)",{"$f":"IF(BP2<=Main!$D33,BM4*(1+Main!$D32),IF(BP2<=(Main!$D35),BM4*(1+Main!$D34),BM4))","v":7982.8632933040863},{"$f":"IF(BQ2<=Main!$D33,BP4*(1+Main!$D32),IF(BQ2<=(Main!$D35),BP4*(1+Main!$D34),BP4))","v":8222.3491921032091},{"$f":"IF(BR2<=Main!$D33,BQ4*(1+Main!$D32),IF(BR2<=(Main!$D35),BQ4*(1+Main!$D34),BQ4))","v":8469.0196678663051},{"$f":"IF(BS2<=Main!$D33,BR4*(1+Main!$D32),IF(BS2<=(Main!$D35),BR4*(1+Main!$D34),BR4))","v":8723.090257902295},{"$f":"IF(BT2<=Main!$D33,BS4*(1+Main!$D32),IF(BT2<=(Main!$D35),BS4*(1+Main!$D34),BS4))","v":8984.7829656393642},null,"Alt Contribution rate (total)",{"$f":"IF(BW2<=Main!$D33,BT4*(1+Main!$D32),IF(BW2<=(Main!$D35),BT4*(1+Main!$D34),BT4))","v":9254.3264546085447},{"$f":"IF(BX2<=Main!$D33,BW4*(1+Main!$D32),IF(BX2<=(Main!$D35),BW4*(1+Main!$D34),BW4))","v":9531.9562482468009},{"$f":"IF(BY2<=Main!$D33,BX4*(1+Main!$D32),IF(BY2<=(Main!$D35),BX4*(1+Main!$D34),BX4))","v":9817.9149356942053},{"$f":"IF(BZ2<=Main!$D33,BY4*(1+Main!$D32),IF(BZ2<=(Main!$D35),BY4*(1+Main!$D34),BY4))","v":10112.452383765032},{"$f":"IF(CA2<=Main!$D33,BZ4*(1+Main!$D32),IF(CA2<=(Main!$D35),BZ4*(1+Main!$D34),BZ4))","v":10415.825955277984},null,"Alt Contribution rate (total)",{"$f":"IF(CD2<=Main!$D33,CA4*(1+Main!$D32),IF(CD2<=(Main!$D35),CA4*(1+Main!$D34),CA4))","v":10728.300733936323},{"$f":"IF(CE2<=Main!$D33,CD4*(1+Main!$D32),IF(CE2<=(Main!$D35),CD4*(1+Main!$D34),CD4))","v":11050.149755954413},{"$f":"IF(CF2<=Main!$D33,CE4*(1+Main!$D32),IF(CF2<=(Main!$D35),CE4*(1+Main!$D34),CE4))","v":11381.654248633045},{"$f":"IF(CG2<=Main!$D33,CF4*(1+Main!$D32),IF(CG2<=(Main!$D35),CF4*(1+Main!$D34),CF4))","v":11723.103876092036},{"$f":"IF(CH2<=Main!$D33,CG4*(1+Main!$D32),IF(CH2<=(Main!$D35),CG4*(1+Main!$D34),CG4))","v":12074.796992374799},null,"Alt Contribution rate (total)",{"$f":"IF(CK2<=Main!$D33,CH4*(1+Main!$D32),IF(CK2<=(Main!$D35),CH4*(1+Main!$D34),CH4))","v":12437.040902146044},{"$f":"IF(CL2<=Main!$D33,CK4*(1+Main!$D32),IF(CL2<=(Main!$D35),CK4*(1+Main!$D34),CK4))","v":12747.966924699693},{"$f":"IF(CM2<=Main!$D33,CL4*(1+Main!$D32),IF(CM2<=(Main!$D35),CL4*(1+Main!$D34),CL4))","v":13066.666097817184},{"$f":"IF(CN2<=Main!$D33,CM4*(1+Main!$D32),IF(CN2<=(Main!$D35),CM4*(1+Main!$D34),CM4))","v":13393.332750262613},{"$f":"IF(CO2<=Main!$D33,CN4*(1+Main!$D32),IF(CO2<=(Main!$D35),CN4*(1+Main!$D34),CN4))","v":13728.166069019177},{"$f":"IF(CP2<=Main!$D33,CO4*(1+Main!$D32),IF(CP2<=(Main!$D35),CO4*(1+Main!$D34),CO4))","v":14071.370220744655}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alt Interest Earnings",{"$f":"IF((BB7+(BB4+BB26-BB42)/2)>0,(BB7+(BB4+BB26-BB42)/2)*Main!$D67,0)","v":1550.3239270480649},{"$f":"IF((BC7+(BC4+BC26-BC42)/2)>0,(BC7+(BC4+BC26-BC42)/2)*Main!$D67,0)","v":1387.8749522960118},{"$f":"IF((BD7+(BD4+BD26-BD42)/2)>0,(BD7+(BD4+BD26-BD42)/2)*Main!$D67,0)","v":1464.2026356515223},{"$f":"IF((BE7+(BE4+BE26-BE42)/2)>0,(BE7+(BE4+BE26-BE42)/2)*Main!$D67,0)","v":1543.1686583046851},{"$f":"IF((BF7+(BF4+BF26-BF42)/2)>0,(BF7+(BF4+BF26-BF42)/2)*Main!$D67,0)","v":1598.0019800170096},null,"Alt Interest Earnings",{"$f":"IF((BI7+(BI4+BI26-BI42)/2)>0,(BI7+(BI4+BI26-BI42)/2)*Main!$D67,0)","v":1640.8141596621999},{"$f":"IF((BJ7+(BJ4+BJ26-BJ42)/2)>0,(BJ7+(BJ4+BJ26-BJ42)/2)*Main!$D67,0)","v":1712.9552183114458},{"$f":"IF((BK7+(BK4+BK26-BK42)/2)>0,(BK7+(BK4+BK26-BK42)/2)*Main!$D67,0)","v":1793.2185331016412},{"$f":"IF((BL7+(BL4+BL26-BL42)/2)>0,(BL7+(BL4+BL26-BL42)/2)*Main!$D67,0)","v":1863.7318917890259},{"$f":"IF((BM7+(BM4+BM26-BM42)/2)>0,(BM7+(BM4+BM26-BM42)/2)*Main!$D67,0)","v":1897.3009308890657},null,"Alt Interest Earnings",{"$f":"IF((BP7+(BP4+BP26-BP42)/2)>0,(BP7+(BP4+BP26-BP42)/2)*Main!$D67,0)","v":1875.3550119901302},{"$f":"IF((BQ7+(BQ4+BQ26-BQ42)/2)>0,(BQ7+(BQ4+BQ26-BQ42)/2)*Main!$D67,0)","v":1904.7133307302915},{"$f":"IF((BR7+(BR4+BR26-BR42)/2)>0,(BR7+(BR4+BR26-BR42)/2)*Main!$D67,0)","v":2007.6884257124782},{"$f":"IF((BS7+(BS4+BS26-BS42)/2)>0,(BS7+(BS4+BS26-BS42)/2)*Main!$D67,0)","v":1819.1565721152124},{"$f":"IF((BT7+(BT4+BT26-BT42)/2)>0,(BT7+(BT4+BT26-BT42)/2)*Main!$D67,0)","v":1595.2322879651222},null,"Alt Interest Earnings",{"$f":"IF((BW7+(BW4+BW26-BW42)/2)>0,(BW7+(BW4+BW26-BW42)/2)*Main!$D67,0)","v":1373.3220082284433},{"$f":"IF((BX7+(BX4+BX26-BX42)/2)>0,(BX7+(BX4+BX26-BX42)/2)*Main!$D67,0)","v":1171.8991649600989},{"$f":"IF((BY7+(BY4+BY26-BY42)/2)>0,(BY7+(BY4+BY26-BY42)/2)*Main!$D67,0)","v":1264.7452245553411},{"$f":"IF((BZ7+(BZ4+BZ26-BZ42)/2)>0,(BZ7+(BZ4+BZ26-BZ42)/2)*Main!$D67,0)","v":1377.5606508926871},{"$f":"IF((CA7+(CA4+CA26-CA42)/2)>0,(CA7+(CA4+CA26-CA42)/2)*Main!$D67,0)","v":1076.1409478635007},null,"Alt Interest Earnings",{"$f":"IF((CD7+(CD4+CD26-CD42)/2)>0,(CD7+(CD4+CD26-CD42)/2)*Main!$D67,0)","v":679.52994369390683},{"$f":"IF((CE7+(CE4+CE26-CE42)/2)>0,(CE7+(CE4+CE26-CE42)/2)*Main!$D67,0)","v":700.49256102006609},{"$f":"IF((CF7+(CF4+CF26-CF42)/2)>0,(CF7+(CF4+CF26-CF42)/2)*Main!$D67,0)","v":820.20419471932769},{"$f":"IF((CG7+(CG4+CG26-CG42)/2)>0,(CG7+(CG4+CG26-CG42)/2)*Main!$D67,0)","v":944.49868219335724},{"$f":"IF((CH7+(CH4+CH26-CH42)/2)>0,(CH7+(CH4+CH26-CH42)/2)*Main!$D67,0)","v":596.1739439321027},null,"Alt Interest Earnings",{"$f":"IF((CK7+(CK4+CK26-CK42)/2)>0,(CK7+(CK4+CK26-CK42)/2)*Main!$D67,0)","v":221.64352670937731},{"$f":"IF((CL7+(CL4+CL26-CL42)/2)>0,(CL7+(CL4+CL26-CL42)/2)*Main!$D67,0)","v":324.0814367108257},{"$f":"IF((CM7+(CM4+CM26-CM42)/2)>0,(CM7+(CM4+CM26-CM42)/2)*Main!$D67,0)","v":440.26730612703471},{"$f":"IF((CN7+(CN4+CN26-CN42)/2)>0,(CN7+(CN4+CN26-CN42)/2)*Main!$D67,0)","v":560.86203416380602},{"$f":"IF((CO7+(CO4+CO26-CO42)/2)>0,(CO7+(CO4+CO26-CO42)/2)*Main!$D67,0)","v":613.9498220117955},{"$f":"IF((CP7+(CP4+CP26-CP42)/2)>0,(CP7+(CP4+CP26-CP42)/2)*Main!$D67,0)","v":116.23651410113948}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alt Starting Balance (for charts)",{"$f":"Main!D20","v":175103.11},{"$f":"IF(BB7+BB5+BB4+BB26-BB42>0,BB7+BB5+BB26+BB4-BB42,0)","v":135093.43392704806},{"$f":"IF(BC7+BC5+BC4+BC26-BC42>0,BC7+BC5+BC26+BC4-BC42,0)","v":142599.50887934407},{"$f":"IF(BD7+BD5+BD4+BD26-BD42>0,BD7+BD5+BD26+BD4-BD42,0)","v":150365.45751499559},{"$f":"IF(BE7+BE5+BE4+BE26-BE42>0,BE7+BE5+BE26+BE4-BE42,0)","v":158399.42455330028},null,"Alt Starting Balance (for charts)",{"$f":"IF(BF7+BF5+BF4+BF26-BF42>0,BF7+BF5+BF4+BF26-BF42,0)","v":161336.78201721728},{"$f":"IF(BI7+BI5+BI4+BI26-BI42>0,BI7+BI5+BI26+BI4-BI42,0)","v":166965.49899247149},{"$f":"IF(BJ7+BJ5+BJ4+BJ26-BJ42>0,BJ7+BJ5+BJ26+BJ4-BJ42,0)","v":175771.1248521652},{"$f":"IF(BK7+BK5+BK4+BK26-BK42>0,BK7+BK5+BK26+BK4-BK42,0)","v":183024.98334775327},{"$f":"IF(BL7+BL5+BL4+BL26-BL42>0,BL7+BL5+BL26+BL4-BL42,0)","v":189879.78936020951},null,"Alt Starting Balance (for charts)",{"$f":"IF(BM7+BM5+BM4+BM26-BM42>0,BM7+BM5+BM4+BM26-BM42,0)","v":189741.64412432496},{"$f":"IF(BP7+BP5+BP4+BP26-BP42>0,BP7+BP5+BP26+BP4-BP42,0)","v":185488.74044650586},{"$f":"IF(BQ7+BQ5+BQ4+BQ26-BQ42>0,BQ7+BQ5+BQ26+BQ4-BQ42,0)","v":195615.80296933936},{"$f":"IF(BR7+BR5+BR4+BR26-BR42>0,BR7+BR5+BR26+BR4-BR42,0)","v":206092.51106291817},{"$f":"IF(BS7+BS5+BS4+BS26-BS42>0,BS7+BS5+BS26+BS4-BS42,0)","v":157893.40935487309},null,"Alt Starting Balance (for charts)",{"$f":"IF(BT7+BT5+BT4+BT26-BT42>0,BT7+BT5+BT4+BT26-BT42,0)","v":161288.62341541582},{"$f":"IF(BW7+BW5+BW4+BW26-BW42>0,BW7+BW5+BW26+BW4-BW42,0)","v":113492.49375572416},{"$f":"IF(BX7+BX5+BX4+BX26-BX42>0,BX7+BX5+BX26+BX4-BX42,0)","v":120986.93629073349},{"$f":"IF(BY7+BY5+BY4+BY26-BY42>0,BY7+BY5+BY26+BY4-BY42,0)","v":132069.59645098302},{"$f":"IF(BZ7+BZ5+BZ4+BZ26-BZ42>0,BZ7+BZ5+BZ26+BZ4-BZ42,0)","v":143559.60948564074},null,"Alt Starting Balance (for charts)",{"$f":"IF(CA7+CA5+CA4+CA26-CA42>0,CA7+CA5+CA4+CA26-CA42,0)","v":71760.038867619951},{"$f":"IF(CD7+CD5+CD4+CD26-CD42>0,CD7+CD5+CD26+CD4-CD42,0)","v":64203.70158122135},{"$f":"IF(CE7+CE5+CE4+CE26-CE42>0,CE7+CE5+CE26+CE4-CE42,0)","v":75954.343898195832},{"$f":"IF(CF7+CF5+CF4+CF26-CF42>0,CF7+CF5+CF26+CF4-CF42,0)","v":88156.202341548196},{"$f":"IF(CG7+CG5+CG4+CG26-CG42>0,CG7+CG5+CG26+CG4-CG42,0)","v":100823.80489983359},null,"Alt Starting Balance (for charts)",{"$f":"IF(CH7+CH5+CH4+CH26-CH42>0,CH7+CH5+CH4+CH26-CH42,0)","v":18461.651359116702},{"$f":"IF(CK7+CK5+CK4+CK26-CK42>0,CK7+CK5+CK26+CK4-CK42,0)","v":25885.890963836588},{"$f":"IF(CL7+CL5+CL4+CL26-CL42>0,CL7+CL5+CL26+CL4-CL42,0)","v":38957.939325247105},{"$f":"IF(CM7+CM5+CM4+CM26-CM42>0,CM7+CM5+CM26+CM4-CM42,0)","v":49132.939220836088},{"$f":"IF(CN7+CN5+CN4+CN26-CN42>0,CN7+CN5+CN26+CN4-CN42,0)","v":63087.134005262509},{"$f":"IF(CO7+CO5+CO4+CO26-CO42>0,CO7+CO5+CO26+CO4-CO42,0)","v":59755.008601223148}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alt Starting Balance (for calcs)",{"$f":"Main!D20","v":175103.11},{"$f":"BB7+BB5+BB4+BB26-BB42","v":135093.43392704806},{"$f":"BC7+BC5+BC4+BC26-BC42","v":142599.50887934407},{"$f":"BD7+BD5+BD4+BD26-BD42","v":150365.45751499559},{"$f":"BE7+BE5+BE4+BE26-BE42","v":158399.42455330028},null,"Alt Starting Balance (for calcs)",{"$f":"BF7+BF5+BF4+BF26-BF42","v":161336.78201721728},{"$f":"BI7+BI5+BI4+BI26-BI42","v":166965.49899247149},{"$f":"BJ7+BJ5+BJ4+BJ26-BJ42","v":175771.1248521652},{"$f":"BK7+BK5+BK4+BK26-BK42","v":183024.98334775327},{"$f":"BL7+BL5+BL4+BL26-BL42","v":189879.78936020951},null,"Alt Starting Balance (for calcs)",{"$f":"BM7+BM5+BM4+BM26-BM42","v":189741.64412432496},{"$f":"BP7+BP5+BP4+BP26-BP42","v":185488.74044650586},{"$f":"BQ7+BQ5+BQ4+BQ26-BQ42","v":195615.80296933936},{"$f":"BR7+BR5+BR4+BR26-BR42","v":206092.51106291817},{"$f":"BS7+BS5+BS4+BS26-BS42","v":157893.40935487309},null,"Alt Starting Balance (for calcs)",{"$f":"BT7+BT5+BT4+BT26-BT42","v":161288.62341541582},{"$f":"BW7+BW5+BW4+BW26-BW42","v":113492.49375572416},{"$f":"BX7+BX5+BX4+BX26-BX42","v":120986.93629073349},{"$f":"BY7+BY5+BY4+BY26-BY42","v":132069.59645098302},{"$f":"BZ7+BZ5+BZ4+BZ26-BZ42","v":143559.60948564074},null,"Alt Starting Balance (for calcs)",{"$f":"CA7+CA5+CA4+CA26-CA42","v":71760.038867619951},{"$f":"CD7+CD5+CD4+CD26-CD42","v":64203.70158122135},{"$f":"CE7+CE5+CE4+CE26-CE42","v":75954.343898195832},{"$f":"CF7+CF5+CF4+CF26-CF42","v":88156.202341548196},{"$f":"CG7+CG5+CG4+CG26-CG42","v":100823.80489983359},null,"Alt Starting Balance (for calcs)",{"$f":"CH7+CH5+CH4+CH26-CH42","v":18461.651359116702},{"$f":"CK7+CK5+CK4+CK26-CK42","v":25885.890963836588},{"$f":"CL7+CL5+CL4+CL26-CL42","v":38957.939325247105},{"$f":"CM7+CM5+CM4+CM26-CM42","v":49132.939220836088},{"$f":"CN7+CN5+CN4+CN26-CN42","v":63087.134005262509},{"$f":"CO7+CO5+CO4+CO26-CO42","v":59755.008601223148}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alt Percent Funded",{"$f":"IF(BB6/DV42<0,0,BB6/DV42)","v":1.7067966209081309},{"$f":"IF(BC6/DW42<0,0,BC6/DW42)","v":2.0576599353993563},{"$f":"IF(BD6/DX42<0,0,BD6/DX42)","v":1.8567567221938837},{"$f":"IF(BE6/DY42<0,0,BE6/DY42)","v":1.6979622947002995},{"$f":"IF(BF6/DZ42<0,0,BF6/DZ42)","v":1.5691071684055262},null,"Alt Percent Funded",{"$f":"IF(BI6/EA42<0,0,BI6/EA42)","v":1.4869969770705156},{"$f":"IF(BJ6/EB42<0,0,BJ6/EB42)","v":1.4019314243347856},{"$f":"IF(BK6/EC42<0,0,BK6/EC42)","v":1.318533185729853},{"$f":"IF(BL6/ED42<0,0,BL6/ED42)","v":1.2504719391117556},{"$f":"IF(BM6/EE42<0,0,BM6/EE42)","v":1.1909735882115364},null,"Alt Percent Funded",{"$f":"IF(BP6/EF42<0,0,BP6/EF42)","v":1.1446707881527747},{"$f":"IF(BQ6/EG42<0,0,BQ6/EG42)","v":1.1029646423051886},{"$f":"IF(BR6/EH42<0,0,BR6/EH42)","v":1.0542433639020619},{"$f":"IF(BS6/EI42<0,0,BS6/EI42)","v":1.011148399189574},{"$f":"IF(BT6/EJ42<0,0,BT6/EJ42)","v":0.97156110459239686},null,"Alt Percent Funded",{"$f":"IF(BW6/EK42<0,0,BW6/EK42)","v":0.92979594268412225},{"$f":"IF(BX6/EL42<0,0,BX6/EL42)","v":0.85735654055818844},{"$f":"IF(BY6/EM42<0,0,BY6/EM42)","v":0.82115456133421327},{"$f":"IF(BZ6/EN42<0,0,BZ6/EN42)","v":0.79328813414946042},{"$f":"IF(CA6/EO42<0,0,CA6/EO42)","v":0.76915405280736815},null,"Alt Percent Funded",{"$f":"IF(CD6/EP42<0,0,CD6/EP42)","v":0.5878208897616104},{"$f":"IF(CE6/EQ42<0,0,CE6/EQ42)","v":0.52497381106351293},{"$f":"IF(CF6/ER42<0,0,CF6/ER42)","v":0.53285541601781616},{"$f":"IF(CG6/ES42<0,0,CG6/ES42)","v":0.53789888970630406},{"$f":"IF(CH6/ET42<0,0,CH6/ET42)","v":0.54092844921938621},null,"Alt Percent Funded",{"$f":"IF(CK6/EU42<0,0,CK6/EU42)","v":0.16452907803230399},0.20091758105697949,0.25644115393304445,0.28427841873177584,0.31797441341961519,0.28846720857490166]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alt Min Expense Margin",{"$f":"IF(BB42>0,(BB5+BB7+BB4-BB42)/BB42,1)","v":2.8440722932010116},{"$f":"IF(BC42>0,(BC5+BC7+BC4-BC42)/BC42,1)","v":1},{"$f":"IF(BD42>0,(BD5+BD7+BD4-BD42)/BD42,1)","v":1},{"$f":"IF(BE42>0,(BE5+BE7+BE4-BE42)/BE42,1)","v":1},{"$f":"IF(BF42>0,(BF5+BF7+BF4-BF42)/BF42,1)","v":30.178029720988292},null,"Alt Min Expense Margin",{"$f":"IF(BI42>0,(BI5+BI7+BI4-BI42)/BI42,1)","v":57.610362447996486},{"$f":"IF(BJ42>0,(BJ5+BJ7+BJ4-BJ42)/BJ42,1)","v":1},{"$f":"IF(BK42>0,(BK5+BK7+BK4-BK42)/BK42,1)","v":99.210706882544571},{"$f":"IF(BL42>0,(BL5+BL7+BL4-BL42)/BL42,1)","v":74.946429565267209},{"$f":"IF(BM42>0,(BM5+BM7+BM4-BM42)/BM42,1)","v":19.389489450569663},null,"Alt Min Expense Margin",{"$f":"IF(BP42>0,(BP5+BP7+BP4-BP42)/BP42,1)","v":13.144861242676482},{"$f":"IF(BQ42>0,(BQ5+BQ7+BQ4-BQ42)/BQ42,1)","v":1},{"$f":"IF(BR42>0,(BR5+BR7+BR4-BR42)/BR42,1)","v":1},{"$f":"IF(BS42>0,(BS5+BS7+BS4-BS42)/BS42,1)","v":2.6879432169073052},{"$f":"IF(BT42>0,(BT5+BT7+BT4-BT42)/BT42,1)","v":22.448585434927427},null,"Alt Min Expense Margin",{"$f":"IF(BW42>0,(BW5+BW7+BW4-BW42)/BW42,1)","v":1.942573681518905},{"$f":"IF(BX42>0,(BX5+BX7+BX4-BX42)/BX42,1)","v":37.697529386957683},{"$f":"IF(BY42>0,(BY5+BY7+BY4-BY42)/BY42,1)","v":1},{"$f":"IF(BZ42>0,(BZ5+BZ7+BZ4-BZ42)/BZ42,1)","v":1},{"$f":"IF(CA42>0,(CA5+CA7+CA4-CA42)/CA42,1)","v":0.86155257788809037},null,"Alt Min Expense Margin",{"$f":"IF(CD42>0,(CD5+CD7+CD4-CD42)/CD42,1)","v":3.3855269423368686},{"$f":"IF(CE42>0,(CE5+CE7+CE4-CE42)/CE42,1)","v":1},{"$f":"IF(CF42>0,(CF5+CF7+CF4-CF42)/CF42,1)","v":1},{"$f":"IF(CG42>0,(CG5+CG7+CG4-CG42)/CG42,1)","v":1},{"$f":"IF(CH42>0,(CH5+CH7+CH4-CH42)/CH42,1)","v":0.19426543598048476},null,"Alt Min Expense Margin",{"$f":"IF(CK42>0,(CK5+CK7+CK4-CK42)/CK42,1)","v":4.9452982758513695},1,14.746074343209189,1,3.3809094038955951,-0.3304751981881705]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Contribution rate (period)",{"$f":"Main!D19","v":170},{"$f":"BB10*(1+Main!$D47)","v":175.1},{"$f":"BC10*(1+Main!$D47)","v":180.35300000000001},{"$f":"BD10*(1+Main!$D47)","v":185.76359000000002},{"$f":"BE10*(1+Main!$D47)","v":191.33649770000002},null,"Current Contribution rate (period)",{"$f":"BF10*(1+Main!$D47)","v":197.07659263100004},{"$f":"BI10*(1+Main!$D47)","v":202.98889040993004},{"$f":"BJ10*(1+Main!$D47)","v":209.07855712222795},{"$f":"BK10*(1+Main!$D47)","v":215.3509138358948},{"$f":"BL10*(1+Main!$D47)","v":221.81144125097165},null,"Current Contribution rate (period)",{"$f":"BM10*(1+Main!$D47)","v":228.46578448850082},{"$f":"BP10*(1+Main!$D47)","v":235.31975802315586},{"$f":"BQ10*(1+Main!$D47)","v":242.37935076385054},{"$f":"BR10*(1+Main!$D47)","v":249.65073128676607},{"$f":"BS10*(1+Main!$D47)","v":257.14025322536907},null,"Current Contribution rate (period)",{"$f":"BT10*(1+Main!$D47)","v":264.85446082213014},{"$f":"BW10*(1+Main!$D47)","v":272.80009464679404},{"$f":"BX10*(1+Main!$D47)","v":280.98409748619787},{"$f":"BY10*(1+Main!$D47)","v":289.41362041078384},{"$f":"BZ10*(1+Main!$D47)","v":298.09602902310735},null,"Current Contribution rate (period)",{"$f":"CA10*(1+Main!$D47)","v":307.03890989380056},{"$f":"CD10*(1+Main!$D47)","v":316.2500771906146},{"$f":"CE10*(1+Main!$D47)","v":325.73757950633308},{"$f":"CF10*(1+Main!$D47)","v":335.50970689152308},{"$f":"CG10*(1+Main!$D47)","v":345.57499809826879},null,"Current Contribution rate (period)",{"$f":"CH10*(1+Main!$D47)","v":355.94224804121689},{"$f":"CK10*(1+Main!$D47)","v":366.62051548245341},{"$f":"CL10*(1+Main!$D47)","v":377.61913094692704},{"$f":"CM10*(1+Main!$D47)","v":388.94770487533486},{"$f":"CN10*(1+Main!$D47)","v":400.61613602159491},{"$f":"CO10*(1+Main!$D47)","v":412.63462010224276}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Contribution rate (total)",{"$f":"Main!D48*Main!D19*Main!D61","v":2040},{"$f":"BC10*Main!$D48","v":2101.1999999999998},{"$f":"BD10*Main!$D48","v":2164.2359999999999},{"$f":"BE10*Main!$D48","v":2229.1630800000003},{"$f":"BF10*Main!$D48","v":2296.0379724000004},null,"Current Contribution rate (total)",{"$f":"BI10*Main!$D48","v":2364.9191115720005},{"$f":"BJ10*Main!$D48","v":2435.8666849191604},{"$f":"BK10*Main!$D48","v":2508.9426854667354},{"$f":"BL10*Main!$D48","v":2584.2109660307378},{"$f":"BM10*Main!$D48","v":2661.7372950116596},null,"Current Contribution rate (total)",{"$f":"BP10*Main!$D48","v":2741.5894138620097},{"$f":"BQ10*Main!$D48","v":2823.8370962778704},{"$f":"BR10*Main!$D48","v":2908.5522091662065},{"$f":"BS10*Main!$D48","v":2995.8087754411927},{"$f":"BT10*Main!$D48","v":3085.6830387044288},null,"Current Contribution rate (total)",{"$f":"BW10*Main!$D48","v":3178.2535298655616},{"$f":"BX10*Main!$D48","v":3273.6011357615284},{"$f":"BY10*Main!$D48","v":3371.8091698343742},{"$f":"BZ10*Main!$D48","v":3472.9634449294063},{"$f":"CA10*Main!$D48","v":3577.1523482772882},null,"Current Contribution rate (total)",{"$f":"CD10*Main!$D48","v":3684.4669187256068},{"$f":"CE10*Main!$D48","v":3795.0009262873755},{"$f":"CF10*Main!$D48","v":3908.8509540759969},{"$f":"CG10*Main!$D48","v":4026.1164826982767},{"$f":"CH10*Main!$D48","v":4146.899977179226},null,"Current Contribution rate (total)",{"$f":"CK10*Main!$D48","v":4271.3069764946031},{"$f":"CL10*Main!$D48","v":4399.4461857894412},{"$f":"CM10*Main!$D48","v":4531.4295713631245},{"$f":"CN10*Main!$D48","v":4667.3724585040181},{"$f":"CO10*Main!$D48","v":4807.3936322591389},{"$f":"CP10*Main!$D48","v":4951.6154412269134}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Interest Earnings",{"$f":"IF((BB14+(BB11-BB42)/2)>0,(BB14+(BB11-BB42)/2)*Main!$D67,0)","v":1530.7343033180628},{"$f":"IF((BC14+(BC11-BC42)/2)>0,(BC14+(BC11-BC42)/2)*Main!$D67,0)","v":1328.3215958003191},{"$f":"IF((BD14+(BD11-BD42)/2)>0,(BD14+(BD11-BD42)/2)*Main!$D67,0)","v":1363.0910642087122},{"$f":"IF((BE14+(BE11-BE42)/2)>0,(BE14+(BE11-BE42)/2)*Main!$D67,0)","v":1398.8525813851461},{"$f":"IF((BF14+(BF11-BF42)/2)>0,(BF14+(BF11-BF42)/2)*Main!$D67,0)","v":1408.7817045710287},null,"Current Interest Earnings",{"$f":"IF((BI14+(BI11-BI42)/2)>0,(BI14+(BI11-BI42)/2)*Main!$D67,0)","v":1404.9349477218416},{"$f":"IF((BJ14+(BJ11-BJ42)/2)>0,(BJ14+(BJ11-BJ42)/2)*Main!$D67,0)","v":1428.605594915404},{"$f":"IF((BK14+(BK11-BK42)/2)>0,(BK14+(BK11-BK42)/2)*Main!$D67,0)","v":1458.528543048694},{"$f":"IF((BL14+(BL11-BL42)/2)>0,(BL14+(BL11-BL42)/2)*Main!$D67,0)","v":1476.7713036808314},{"$f":"IF((BM14+(BM11-BM42)/2)>0,(BM14+(BM11-BM42)/2)*Main!$D67,0)","v":1456.0773868768367},null,"Current Interest Earnings",{"$f":"IF((BP14+(BP11-BP42)/2)>0,(BP14+(BP11-BP42)/2)*Main!$D67,0)","v":1377.8121215921012},{"$f":"IF((BQ14+(BQ11-BQ42)/2)>0,(BQ14+(BQ11-BQ42)/2)*Main!$D67,0)","v":1348.7287070378752},{"$f":"IF((BR14+(BR11-BR42)/2)>0,(BR14+(BR11-BR42)/2)*Main!$D67,0)","v":1391.0716622524869},{"$f":"IF((BS14+(BS11-BS42)/2)>0,(BS14+(BS11-BS42)/2)*Main!$D67,0)","v":1139.6471585835118},{"$f":"IF((BT14+(BT11-BT42)/2)>0,(BT14+(BT11-BT42)/2)*Main!$D67,0)","v":850.49746299349351},null,"Current Interest Earnings",{"$f":"IF((BW14+(BW11-BW42)/2)>0,(BW14+(BW11-BW42)/2)*Main!$D67,0)","v":560.95454729123662},{"$f":"IF((BX14+(BX11-BX42)/2)>0,(BX14+(BX11-BX42)/2)*Main!$D67,0)","v":289.41510147042936},{"$f":"IF((BY14+(BY11-BY42)/2)>0,(BY14+(BY11-BY42)/2)*Main!$D67,0)","v":309.58150214200901},{"$f":"IF((BZ14+(BZ11-BZ42)/2)>0,(BZ14+(BZ11-BZ42)/2)*Main!$D67,0)","v":347.07270478870316},{"$f":"IF((CA14+(CA11-CA42)/2)>0,(CA14+(CA11-CA42)/2)*Main!$D67,0)","v":0},null,"Current Interest Earnings",{"$f":"IF((CD14+(CD11-CD42)/2)>0,(CD14+(CD11-CD42)/2)*Main!$D67,0)","v":0},{"$f":"IF((CE14+(CE11-CE42)/2)>0,(CE14+(CE11-CE42)/2)*Main!$D67,0)","v":0},{"$f":"IF((CF14+(CF11-CF42)/2)>0,(CF14+(CF11-CF42)/2)*Main!$D67,0)","v":0},{"$f":"IF((CG14+(CG11-CG42)/2)>0,(CG14+(CG11-CG42)/2)*Main!$D67,0)","v":0},{"$f":"IF((CH14+(CH11-CH42)/2)>0,(CH14+(CH11-CH42)/2)*Main!$D67,0)","v":0},null,"Current Interest Earnings",{"$f":"IF((CK14+(CK11-CK42)/2)>0,(CK14+(CK11-CK42)/2)*Main!$D67,0)","v":0},{"$f":"IF((CL14+(CL11-CL42)/2)>0,(CL14+(CL11-CL42)/2)*Main!$D67,0)","v":0},{"$f":"IF((CM14+(CM11-CM42)/2)>0,(CM14+(CM11-CM42)/2)*Main!$D67,0)","v":0},{"$f":"IF((CN14+(CN11-CN42)/2)>0,(CN14+(CN11-CN42)/2)*Main!$D67,0)","v":0},{"$f":"IF((CO14+(CO11-CO42)/2)>0,(CO14+(CO11-CO42)/2)*Main!$D67,0)","v":0},{"$f":"IF((CP14+(CP11-CP42)/2)>0,(CP14+(CP11-CP42)/2)*Main!$D67,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Starting Balance (for charts)",{"$f":"Main!D20","v":175103.11},{"$f":"IF(BB14+BB12+BB11-BB42>0,BB14+BB12+BB11-BB42, 0)","v":131173.84430331804},{"$f":"IF(BC14+BC12+BC11-BC42>0,BC14+BC12+BC11-BC42, 0)","v":134603.36589911836},{"$f":"IF(BD14+BD12+BD11-BD42>0,BD14+BD12+BD11-BD42, 0)","v":138130.69296332708},{"$f":"IF(BE14+BE12+BE11-BE42>0,BE14+BE12+BE11-BE42, 0)","v":141758.70862471222},null,"Current Starting Balance (for charts)",{"$f":"IF(BF14+BF12+BF11-BF42>0,BF14+BF12+BF11-BF42, 0)","v":140117.36145418326},{"$f":"IF(BI14+BI12+BI11-BI42>0,BI14+BI12+BI11-BI42, 0)","v":140989.03032772712},{"$f":"IF(BJ14+BJ12+BJ11-BJ42>0,BJ14+BJ12+BJ11-BJ42, 0)","v":144853.50260756168},{"$f":"IF(BK14+BK12+BK11-BK42>0,BK14+BK12+BK11-BK42, 0)","v":146976.16303793978},{"$f":"IF(BL14+BL12+BL11-BL42>0,BL14+BL12+BL11-BL42, 0)","v":148503.60514487614},null,"Current Starting Balance (for charts)",{"$f":"IF(BM14+BM12+BM11-BM42>0,BM14+BM12+BM11-BM42, 0)","v":142835.62094804531},{"$f":"IF(BP14+BP12+BP11-BP42>0,BP14+BP12+BP11-BP42, 0)","v":132843.90050038614},{"$f":"IF(BQ14+BQ12+BQ11-BQ42>0,BQ14+BQ12+BQ11-BQ42, 0)","v":137016.46630370186},{"$f":"IF(BR14+BR12+BR11-BR42>0,BR14+BR12+BR11-BR42, 0)","v":141316.09017512054},{"$f":"IF(BS14+BS12+BS11-BS42>0,BS14+BS12+BS11-BS42, 0)","v":86710.197571082681},null,"Current Starting Balance (for charts)",{"$f":"IF(BT14+BT12+BT11-BT42>0,BT14+BT12+BT11-BT42, 0)","v":83461.576879718821},{"$f":"IF(BW14+BW12+BW11-BW42>0,BW14+BW12+BW11-BW42, 0)","v":28777.006834346954},{"$f":"IF(BX14+BX12+BX11-BX42>0,BX14+BX12+BX11-BX42, 0)","v":29130.610193381337},{"$f":"IF(BY14+BY12+BY11-BY42>0,BY14+BY12+BY11-BY42, 0)","v":32812.000865357724},{"$f":"IF(BZ14+BZ12+BZ11-BZ42>0,BZ14+BZ12+BZ11-BZ42, 0)","v":36632.037015075839},null,"Current Starting Balance (for charts)",{"$f":"IF(CA14+CA12+CA11-CA42>0,CA14+CA12+CA11-CA42, 0)","v":0},{"$f":"IF(CD14+CD12+CD11-CD42>0,CD14+CD12+CD11-CD42, 0)","v":0},{"$f":"IF(CE14+CE12+CE11-CE42>0,CE14+CE12+CE11-CE42, 0)","v":0},{"$f":"IF(CF14+CF12+CF11-CF42>0,CF14+CF12+CF11-CF42, 0)","v":0},{"$f":"IF(CG14+CG12+CG11-CG42>0,CG14+CG12+CG11-CG42, 0)","v":0},null,"Current Starting Balance (for charts)",{"$f":"IF(CH14+CH12+CH11-CH42>0,CH14+CH12+CH11-CH42, 0)","v":0},{"$f":"IF(CK14+CK12+CK11-CK42>0,CK14+CK12+CK11-CK42, 0)","v":0},{"$f":"IF(CL14+CL12+CL11-CL42>0,CL14+CL12+CL11-CL42, 0)","v":0},{"$f":"IF(CM14+CM12+CM11-CM42>0,CM14+CM12+CM11-CM42, 0)","v":0},{"$f":"IF(CN14+CN12+CN11-CN42>0,CN14+CN12+CN11-CN42, 0)","v":0},{"$f":"IF(CO14+CO12+CO11-CO42>0,CO14+CO12+CO11-CO42, 0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Starting Balance (for calcs)",{"$f":"Main!D20","v":175103.11},{"$f":"BB14+BB12+BB11-BB42","v":131173.84430331804},{"$f":"BC14+BC12+BC11-BC42","v":134603.36589911836},{"$f":"BD14+BD12+BD11-BD42","v":138130.69296332708},{"$f":"BE14+BE12+BE11-BE42","v":141758.70862471222},null,"Current Starting Balance (for calcs)",{"$f":"BF14+BF12+BF11-BF42","v":140117.36145418326},{"$f":"BI14+BI12+BI11-BI42","v":140989.03032772712},{"$f":"BJ14+BJ12+BJ11-BJ42","v":144853.50260756168},{"$f":"BK14+BK12+BK11-BK42","v":146976.16303793978},{"$f":"BL14+BL12+BL11-BL42","v":148503.60514487614},null,"Current Starting Balance (for calcs)",{"$f":"BM14+BM12+BM11-BM42","v":142835.62094804531},{"$f":"BP14+BP12+BP11-BP42","v":132843.90050038614},{"$f":"BQ14+BQ12+BQ11-BQ42","v":137016.46630370186},{"$f":"BR14+BR12+BR11-BR42","v":141316.09017512054},{"$f":"BS14+BS12+BS11-BS42","v":86710.197571082681},null,"Current Starting Balance (for calcs)",{"$f":"BT14+BT12+BT11-BT42","v":83461.576879718821},{"$f":"BW14+BW12+BW11-BW42","v":28777.006834346954},{"$f":"BX14+BX12+BX11-BX42","v":29130.610193381337},{"$f":"BY14+BY12+BY11-BY42","v":32812.000865357724},{"$f":"BZ14+BZ12+BZ11-BZ42","v":36632.037015075839},null,"Current Starting Balance (for calcs)",{"$f":"CA14+CA12+CA11-CA42","v":-43082.34815780913},{"$f":"CD14+CD12+CD11-CD42","v":-58362.049203112358},{"$f":"CE14+CE12+CE11-CE42","v":-54567.048276824979},{"$f":"CF14+CF12+CF11-CF42","v":-50658.19732274898},{"$f":"CG14+CG12+CG11-CG42","v":-46632.080840050701},null,"Current Starting Balance (for calcs)",{"$f":"CH14+CH12+CH11-CH42","v":-137518.30533989525},{"$f":"CK14+CK12+CK11-CK42","v":-138481.44318753618},{"$f":"CL14+CL12+CL11-CL42","v":-134081.99700174673},{"$f":"CM14+CM12+CM11-CM42","v":-132882.50093873884},{"$f":"CN14+CN12+CN11-CN42","v":-128215.12848023482},{"$f":"CO14+CO12+CO11-CO42","v":-141081.97614304602}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Percent Funded",{"$f":"IF(BB13/DV42<0,0,BB13/DV42)","v":1.7067966209081309},{"$f":"IF(BC13/DW42<0,0,BC13/DW42)","v":1.9979591616644048},{"$f":"IF(BD13/DX42<0,0,BD13/DX42)","v":1.7526407098258485},{"$f":"IF(BE13/DY42<0,0,BE13/DY42)","v":1.5598044409179759},{"$f":"IF(BF13/DZ42<0,0,BF13/DZ42)","v":1.4042639770581904},null,"Current Percent Funded",{"$f":"IF(BI13/EA42<0,0,BI13/EA42)","v":1.2914233835110986},{"$f":"IF(BJ13/EB42<0,0,BJ13/EB42)","v":1.1838191320701719},{"$f":"IF(BK13/EC42<0,0,BK13/EC42)","v":1.0866070887235557},{"$f":"IF(BL13/ED42<0,0,BL13/ED42)","v":1.0041774856935901},{"$f":"IF(BM13/EE42<0,0,BM13/EE42)","v":0.93145179946573731},null,"Current Percent Funded",{"$f":"IF(BP13/EF42<0,0,BP13/EF42)","v":0.86169677490387708},{"$f":"IF(BQ13/EG42<0,0,BQ13/EG42)","v":0.78992463286519976},{"$f":"IF(BR13/EH42<0,0,BR13/EH42)","v":0.73843062857569297},{"$f":"IF(BS13/EI42<0,0,BS13/EI42)","v":0.6933368787800307},{"$f":"IF(BT13/EJ42<0,0,BT13/EJ42)","v":0.53355143622393397},null,"Current Percent Funded",{"$f":"IF(BW13/EK42<0,0,BW13/EK42)","v":0.48113892914138634},{"$f":"IF(BX13/EL42<0,0,BX13/EL42)","v":0.21739019216740643},{"$f":"IF(BY13/EM42<0,0,BY13/EM42)","v":0.19771335788900479},{"$f":"IF(BZ13/EN42<0,0,BZ13/EN42)","v":0.19708829014140875},{"$f":"IF(CA13/EO42<0,0,CA13/EO42)","v":0.19626467244990187},null,"Current Percent Funded",{"$f":"IF(CD13/EP42<0,0,CD13/EP42)","v":0},{"$f":"IF(CE13/EQ42<0,0,CE13/EQ42)","v":0},{"$f":"IF(CF13/ER42<0,0,CF13/ER42)","v":0},{"$f":"IF(CG13/ES42<0,0,CG13/ES42)","v":0},{"$f":"IF(CH13/ET42<0,0,CH13/ET42)","v":0},null,"Current Percent Funded",{"$f":"IF(CK13/EU42<0,0,CK13/EU42)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recommended Annual Avg. Balance",{"$f":"BB24+(BB25+BB26-BB42)/2","v":155673.10999999999},{"$f":"BC24+(BC25+BC26-BC42)/2","v":142256.59597424575},{"$f":"BD24+(BD25+BD26-BD42)/2","v":152718.38817334647},{"$f":"BE24+(BE25+BE26-BE42)/2","v":163556.25976768919},{"$f":"BF24+(BF25+BF26-BF42)/2","v":172109.03483161895},null,"Recommended Annual Avg. Balance",{"$f":"BI24+(BI25+BI26-BI42)/2","v":179586.12150741881},{"$f":"BJ24+(BJ25+BJ26-BJ42)/2","v":190107.51398906909},{"$f":"BK24+(BK25+BK26-BK42)/2","v":201566.28225953446},{"$f":"BL24+(BL25+BL26-BL42)/2","v":212187.5356170618},{"$f":"BM24+(BM25+BM26-BM42)/2","v":219268.5606856076},null,"Recommended Annual Avg. Balance",{"$f":"BP24+(BP25+BP26-BP42)/2","v":220965.20255203624},{"$f":"BQ24+(BQ25+BQ26-BQ42)/2","v":227915.05842304148},{"$f":"BR24+(BR25+BR26-BR42)/2","v":242343.86153826391},{"$f":"BS24+(BS25+BS26-BS42)/2","v":227911.11689678059},{"$f":"BT24+(BT25+BT26-BT42)/2","v":210116.08145080198},null,"Recommended Annual Avg. Balance",{"$f":"BW24+(BW25+BW26-BW42)/2","v":192687.41658011859},{"$f":"BX24+(BX25+BX26-BX42)/2","v":177469.30238679328},{"$f":"BY24+(BY25+BY26-BY42)/2","v":191720.07920646816},{"$f":"BZ24+(BZ25+BZ26-BZ42)/2","v":208140.90421943384},{"$f":"CA24+(CA25+CA26-CA42)/2","v":183515.76781551301},null,"Recommended Annual Avg. Balance",{"$f":"CD24+(CD25+CD26-CD42)/2","v":149609.05398163799},{"$f":"CE24+(CE25+CE26-CE42)/2","v":157468.80978784809},{"$f":"CF24+(CF25+CF26-CF42)/2","v":175364.77456799132},{"$f":"CG24+(CG25+CG26-CG42)/2","v":193929.9426886361},{"$f":"CH24+(CH25+CH26-CH42)/2","v":165669.15733720327},null,"Recommended Annual Avg. Balance",{"$f":"CK24+(CK25+CK26-CK42)/2","v":135026.46975746049},152082.08730792531,170718.20981631437,190010.90704655714,202807.3549533725,161005.25241614043]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recommended Periodic Reserve Contribs",{"$f":"Main!D30","v":720},{"$f":"BC25/Main!$D48","v":741.6},{"$f":"BD25/Main!$D48","v":763.84800000000007},{"$f":"BE25/Main!$D48","v":786.76344000000017},{"$f":"BF25/Main!$D48","v":810.36634320000019},null,"Recommended Periodic Reserve Contribs",{"$f":"BI25/Main!$D48","v":834.67733349600019},{"$f":"BJ25/Main!$D48","v":859.71765350088015},{"$f":"BK25/Main!$D48","v":885.50918310590657},{"$f":"BL25/Main!$D48","v":912.07445859908375},{"$f":"BM25/Main!$D48","v":939.43669235705636},null,"Recommended Periodic Reserve Contribs",{"$f":"BP25/Main!$D48","v":967.61979312776805},{"$f":"BQ25/Main!$D48","v":996.64838692160117},{"$f":"BR25/Main!$D48","v":1026.5478385292492},{"$f":"BS25/Main!$D48","v":1057.3442736851266},{"$f":"BT25/Main!$D48","v":1089.0646018956804},null,"Recommended Periodic Reserve Contribs",{"$f":"BW25/Main!$D48","v":1121.7365399525509},{"$f":"BX25/Main!$D48","v":1155.3886361511275},{"$f":"BY25/Main!$D48","v":1190.0502952356615},{"$f":"BZ25/Main!$D48","v":1225.7518040927314},{"$f":"CA25/Main!$D48","v":1262.5243582155133},null,"Recommended Periodic Reserve Contribs",{"$f":"CD25/Main!$D48","v":1300.4000889619786},{"$f":"CE25/Main!$D48","v":1339.4120916308379},{"$f":"CF25/Main!$D48","v":1379.5944543797632},{"$f":"CG25/Main!$D48","v":1420.982288011156},{"$f":"CH25/Main!$D48","v":1463.6117566514906},null,"Recommended Periodic Reserve Contribs",{"$f":"CK25/Main!$D48","v":1507.5201093510357},{"$f":"CL25/Main!$D48","v":1545.2081120848113},{"$f":"CM25/Main!$D48","v":1583.8383148869314},{"$f":"CN25/Main!$D48","v":1623.4342727591045},{"$f":"CO25/Main!$D48","v":1664.0201295780819},{"$f":"CP25/Main!$D48","v":1705.620632817534}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recommended Percent Funded",{"$f":"IF(BB24/DV42<0,0,BB24/DV42)","v":1.7067966209081309},{"$f":"IF(BC24/DW42<0,0,BC24/DW42)","v":2.0989912402927837},{"$f":"IF(BD24/DX42<0,0,BD24/DX42)","v":1.928837038448677},{"$f":"IF(BE24/DY42<0,0,BE24/DY42)","v":1.7936100396265235},{"$f":"IF(BF24/DZ42<0,0,BF24/DZ42)","v":1.6832293777998355},null,"Recommended Percent Funded",{"$f":"IF(BI24/EA42<0,0,BI24/EA42)","v":1.6223940803039587},{"$f":"IF(BJ24/EB42<0,0,BJ24/EB42)","v":1.5529322420564418},{"$f":"IF(BK24/EC42<0,0,BK24/EC42)","v":1.4790974067342129},{"$f":"IF(BL24/ED42<0,0,BL24/ED42)","v":1.4209834837858699},{"$f":"IF(BM24/EE42<0,0,BM24/EE42)","v":1.3706425188817051},null,"Recommended Percent Funded",{"$f":"IF(BP24/EF42<0,0,BP24/EF42)","v":1.3405758742481655},{"$f":"IF(BQ24/EG42<0,0,BQ24/EG42)","v":1.3196846488405658},{"$f":"IF(BR24/EH42<0,0,BR24/EH42)","v":1.2728829498972407},{"$f":"IF(BS24/EI42<0,0,BS24/EI42)","v":1.231171759473104},{"$f":"IF(BT24/EJ42<0,0,BT24/EJ42)","v":1.2747985673090254},null,"Recommended Percent Funded",{"$f":"IF(BW24/EK42<0,0,BW24/EK42)","v":1.2404046443675549},{"$f":"IF(BX24/EL42<0,0,BX24/EL42)","v":1.3004101663671914},{"$f":"IF(BY24/EM42<0,0,BY24/EM42)","v":1.2527677021808958},{"$f":"IF(BZ24/EN42<0,0,BZ24/EN42)","v":1.2060418723088808},{"$f":"IF(CA24/EO42<0,0,CA24/EO42)","v":1.1657697776702296},null,"Recommended Percent Funded",{"$f":"IF(CD24/EP42<0,0,CD24/EP42)","v":1.2392785964204784},{"$f":"IF(CE24/EQ42<0,0,CE24/EQ42)","v":1.2218620055224199},{"$f":"IF(CF24/ER42<0,0,CF24/ER42)","v":1.1721952830648572},{"$f":"IF(CG24/ES42<0,0,CG24/ES42)","v":1.1312718723585611},{"$f":"IF(CH24/ET42<0,0,CH24/ET42)","v":1.0966454337737905},null,"Recommended Percent Funded",{"$f":"IF(CK24/EU42<0,0,CK24/EU42)","v":1.1460623969007155},1.1084497067314323,1.0721673151174012,1.0430264714837891,1.016416961176674,0.99442484331333092]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference Point",1,1,1,1,1,null,"Reference Point",1,1,1,1,1,null,"Reference Point",1,1,1,1,1,null,"Reference Point",1,1,1,1,1,null,"Reference Point",1,1,1,1,1,null,"Reference Point",1,1,1,1,1,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 6:  30-Year Income/Expense Detail (yrs 0 through 4)",null,null,null,null,null,{"$f":"Main!$D$10","v":"16151-1"},"Table 6:  30-Year Income/Expense Detail (yrs 5 through 9)",null,null,null,null,null,{"$f":"Main!$D$10","v":"16151-1"},"Table 6:  30-Year Income/Expense Detail (yrs 10 through 14)",null,null,null,null,null,{"$f":"Main!$D$10","v":"16151-1"},"Table 6:  30-Year Income/Expense Detail (yrs 15 through 19)",null,null,null,null,null,{"$f":"Main!$D$10","v":"16151-1"},"Table 6:  30-Year Income/Expense Detail (yrs 20 through 24)",null,null,null,null,null,{"$f":"Main!$D$10","v":"16151-1"},"Table 6:  30-Year Income/Expense Detail (yrs 25 through 29)",null,null,null,null,null,{"$f":"Main!$D$10","v":"16151-1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,null,null,1,1,1,1,1,null,null,1,1,1,1,1,null,null,1,1,1,1,1,null,null,1,1,1,1,1,null,null,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fiscal Year",{"$f":"Main!D14","v":2015},{"$f":"BB23+1","v":2016},{"$f":"BC23+1","v":2017},2018,2019,null,"Fiscal Year",{"$f":"BF23+1","v":2020},2021,2022,2023,2024,null,"Fiscal Year",{"$f":"BM23+1","v":2025},2026,2027,2028,2029,null,"Fiscal Year",{"$f":"BT23+1","v":2030},2031,2032,2033,2034,null,"Fiscal Year",{"$f":"CA23+1","v":2035},2036,2037,2038,2039,null,"Fiscal Year",{"$f":"CH23+1","v":2040},2041,2042,2043,2044,2045]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Starting Reserve Balance",{"$f":"Main!D20","v":175103.11},{"$f":"+BB44","v":137806.99597424574},148135.30017334648,158835.67912768919,169919.92019616894,null,"Starting Reserve Balance",{"$f":"+BF44","v":176027.15009931781},184949.2080680638,197175.63255996766,207981.85894685492,218524.83997082492,null,"Starting Reserve Balance",{"$f":"+BM44","v":222215.04478482626},221935.16810151187,236184.57450708843,250937.72552370111,207174.0944359588,null,"Starting Reserve Balance",{"$f":"+BT44","v":215168.88640166761},172141.67700898531,184579.77743505419,200786.39339487746,217586.39042680108,null,"Starting Reserve Balance",{"$f":"+CA44","v":151288.73742988054},149432.33723806308,167087.20784171275,185404.04896056917,204404.04903580624,null,"Starting Reserve Balance",{"$f":"+CH44","v":128598.57151342204},142810.83863541644,162881.14668117039,180270.30141000252,201660.35482343918,205991.74983879997,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RowCount",{"$f":"COUNTA(F30:F42)-1","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Reserve Contribution",{"$f":"Main!D48*Main!D30*Main!D61","v":8640},{"$f":"IF(BC2<=Main!$D33,(Main!$D30*Main!$D48)*(1+Main!$D32),IF(BC2<=(Main!$D33+Main!$D35),(Main!$D30*Main!$D48)*(1+Main!$D34),(Main!$D30*Main!$D48)))","v":8899.2000000000007},{"$f":"IF(BD2<=Main!$D33,BC25*(1+Main!$D32),IF(BD2<=(Main!$D33+Main!$D35),BC25*(1+Main!$D34),BC25))","v":9166.1760000000013},{"$f":"IF(BE2<=Main!$D33,BD25*(1+Main!$D32),IF(BE2<=(Main!$D33+Main!$D35),BD25*(1+Main!$D34),BD25))","v":9441.1612800000021},{"$f":"IF(BF2<=Main!$D33,BE25*(1+Main!$D32),IF(BF2<=(Main!$D33+Main!$D35),BE25*(1+Main!$D34),BE25))","v":9724.3961184000018},null,"Annual Reserve Contribution",{"$f":"IF(BI2<=Main!$D33,BF25*(1+Main!$D32),IF(BI2<=(Main!$D33+Main!$D35),BF25*(1+Main!$D34),BF25))","v":10016.128001952002},{"$f":"IF(BJ2<=Main!$D33,BI25*(1+Main!$D32),IF(BJ2<=(Main!$D33+Main!$D35),BI25*(1+Main!$D34),BI25))","v":10316.611842010561},{"$f":"IF(BK2<=Main!$D33,BJ25*(1+Main!$D32),IF(BK2<=(Main!$D33+Main!$D35),BJ25*(1+Main!$D34),BJ25))","v":10626.110197270878},{"$f":"IF(BL2<=Main!$D33,BK25*(1+Main!$D32),IF(BL2<=(Main!$D33+Main!$D35),BK25*(1+Main!$D34),BK25))","v":10944.893503189005},{"$f":"IF(BM2<=Main!$D33,BL25*(1+Main!$D32),IF(BM2<=(Main!$D33+Main!$D35),BL25*(1+Main!$D34),BL25))","v":11273.240308284676},null,"Annual Reserve Contribution",{"$f":"IF(BP2<=Main!$D33,BM25*(1+Main!$D32),IF(BP2<=(Main!$D33+Main!$D35),BM25*(1+Main!$D34),BM25))","v":11611.437517533217},{"$f":"IF(BQ2<=Main!$D33,BP25*(1+Main!$D32),IF(BQ2<=(Main!$D33+Main!$D35),BP25*(1+Main!$D34),BP25))","v":11959.780643059214},{"$f":"IF(BR2<=Main!$D33,BQ25*(1+Main!$D32),IF(BR2<=(Main!$D33+Main!$D35),BQ25*(1+Main!$D34),BQ25))","v":12318.57406235099},{"$f":"IF(BS2<=Main!$D33,BR25*(1+Main!$D32),IF(BS2<=(Main!$D33+Main!$D35),BR25*(1+Main!$D34),BR25))","v":12688.131284221519},{"$f":"IF(BT2<=Main!$D33,BS25*(1+Main!$D32),IF(BT2<=(Main!$D33+Main!$D35),BS25*(1+Main!$D34),BS25))","v":13068.775222748165},null,"Annual Reserve Contribution",{"$f":"IF(BW2<=Main!$D33,BT25*(1+Main!$D32),IF(BW2<=(Main!$D33+Main!$D35),BT25*(1+Main!$D34),BT25))","v":13460.838479430611},{"$f":"IF(BX2<=Main!$D33,BW25*(1+Main!$D32),IF(BX2<=(Main!$D33+Main!$D35),BW25*(1+Main!$D34),BW25))","v":13864.66363381353},{"$f":"IF(BY2<=Main!$D33,BX25*(1+Main!$D32),IF(BY2<=(Main!$D33+Main!$D35),BX25*(1+Main!$D34),BX25))","v":14280.603542827937},{"$f":"IF(BZ2<=Main!$D33,BY25*(1+Main!$D32),IF(BZ2<=(Main!$D33+Main!$D35),BY25*(1+Main!$D34),BY25))","v":14709.021649112776},{"$f":"IF(CA2<=Main!$D33,BZ25*(1+Main!$D32),IF(CA2<=(Main!$D33+Main!$D35),BZ25*(1+Main!$D34),BZ25))","v":15150.292298586159},null,"Annual Reserve Contribution",{"$f":"IF(CD2<=Main!$D33,CA25*(1+Main!$D32),IF(CD2<=(Main!$D33+Main!$D35),CA25*(1+Main!$D34),CA25))","v":15604.801067543744},{"$f":"IF(CE2<=Main!$D33,CD25*(1+Main!$D32),IF(CE2<=(Main!$D33+Main!$D35),CD25*(1+Main!$D34),CD25))","v":16072.945099570055},{"$f":"IF(CF2<=Main!$D33,CE25*(1+Main!$D32),IF(CF2<=(Main!$D33+Main!$D35),CE25*(1+Main!$D34),CE25))","v":16555.133452557158},{"$f":"IF(CG2<=Main!$D33,CF25*(1+Main!$D32),IF(CG2<=(Main!$D33+Main!$D35),CF25*(1+Main!$D34),CF25))","v":17051.787456133872},{"$f":"IF(CH2<=Main!$D33,CG25*(1+Main!$D32),IF(CH2<=(Main!$D33+Main!$D35),CG25*(1+Main!$D34),CG25))","v":17563.341079817888},null,"Annual Reserve Contribution",{"$f":"IF(CK2<=Main!$D33,CH25*(1+Main!$D32),IF(CK2<=(Main!$D33+Main!$D35),CH25*(1+Main!$D34),CH25))","v":18090.241312212427},{"$f":"IF(CL2<=Main!$D33,CK25*(1+Main!$D32),IF(CL2<=(Main!$D33+Main!$D35),CK25*(1+Main!$D34),CK25))","v":18542.497345017735},{"$f":"IF(CM2<=Main!$D33,CL25*(1+Main!$D32),IF(CM2<=(Main!$D33+Main!$D35),CL25*(1+Main!$D34),CL25))","v":19006.059778643175},{"$f":"IF(CN2<=Main!$D33,CM25*(1+Main!$D32),IF(CN2<=(Main!$D33+Main!$D35),CM25*(1+Main!$D34),CM25))","v":19481.211273109253},{"$f":"IF(CO2<=Main!$D33,CN25*(1+Main!$D32),IF(CO2<=(Main!$D33+Main!$D35),CN25*(1+Main!$D34),CN25))","v":19968.241554936983},{"$f":"IF(CP2<=Main!$D33,CO25*(1+Main!$D32),IF(CP2<=(Main!$D33+Main!$D35),CO25*(1+Main!$D34),CO25))","v":20467.447593810408},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Years"]
[null,null,"Raw Data for Reserve Analysis goes below double line",null,null,null,null,null,null,null,null,null,null,"Table 1: Executive Summary",null,null,null,{"$f":"Main!$D$10","v":"16151-1"},"Table 2:  Reserve Component List Detail",null,null,null,null,null,{"$f":"Main!$D$10","v":"16151-1"},"Table 3:  Fully Funded Balance",null,null,null,null,null,null,null,{"$f":"Main!$D$10","v":"16151-1"},null,"Table 4: Component Significance",null,null,null,null,{"$f":"Main!$D$10","v":"16151-1"},null,"Accounting - Tax Summary",null,null,null,null,null,null,{"$f":"Main!$D$10","v":"16151-1"},null,null,"Recommended Special Assessments",{"$f":"Main!D36","v":0},{"$f":"Main!D37","v":0},{"$f":"Main!D38","v":0},{"$f":"Main!D39","v":0},{"$f":"Main!D40","v":0},null,"Recommended Special Assessments",0,0,0,0,0,null,"Recommended Special Assessments",0,0,0,0,0,null,"Recommended Special Assessments",0,0,0,0,0,null,"Recommended Special Assessments",0,0,0,0,0,null,"Recommended Special Assessments",0,0,0,0,0,0,"RUL Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FFB Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inflation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest Earnings",{"$f":"IF(BB16>0,BB16*Main!$D67,0)","v":1563.8859742457587},{"$f":"IF(BC16>0,BC16*Main!$D67,0)","v":1429.1041991007219},{"$f":"IF(BD16>0,BD16*Main!$D67,0)","v":1534.2029543426986},{"$f":"IF(BE16>0,BE16*Main!$D67,0)","v":1643.079788479751},{"$f":"IF(BF16>0,BF16*Main!$D67,0)","v":1729.0006322488425},null,"Interest Earnings",{"$f":"IF(BI16>0,BI16*Main!$D67,0)","v":1804.1151525439871},{"$f":"IF(BJ16>0,BJ16*Main!$D67,0)","v":1909.8126498933216},{"$f":"IF(BK16>0,BK16*Main!$D67,0)","v":2024.9269877536824},{"$f":"IF(BL16>0,BL16*Main!$D67,0)","v":2131.6276835562376},{"$f":"IF(BM16>0,BM16*Main!$D67,0)","v":2202.7633844359934},null,"Interest Earnings",{"$f":"IF(BP16>0,BP16*Main!$D67,0)","v":2219.8077822656887},{"$f":"IF(BQ16>0,BQ16*Main!$D67,0)","v":2289.6257625173498},{"$f":"IF(BR16>0,BR16*Main!$D67,0)","v":2434.5769542617031},{"$f":"IF(BS16>0,BS16*Main!$D67,0)","v":2289.586166098697},{"$f":"IF(BT16>0,BT16*Main!$D67,0)","v":2110.817936022404},null,"Interest Earnings",{"$f":"IF(BW16>0,BW16*Main!$D67,0)","v":1935.7302504157406},{"$f":"IF(BX16>0,BX16*Main!$D67,0)","v":1782.8496704529471},{"$f":"IF(BY16>0,BY16*Main!$D67,0)","v":1926.0124169953403},{"$f":"IF(BZ16>0,BZ16*Main!$D67,0)","v":2090.9753828108301},{"$f":"IF(CA16>0,CA16*Main!$D67,0)","v":1843.592225655555},null,"Interest Earnings",{"$f":"IF(CD16>0,CD16*Main!$D67,0)","v":1502.966704667622},{"$f":"IF(CE16>0,CE16*Main!$D67,0)","v":1581.925504079599},{"$f":"IF(CF16>0,CF16*Main!$D67,0)","v":1761.707666299279},{"$f":"IF(CG16>0,CG16*Main!$D67,0)","v":1948.2126191032082},{"$f":"IF(CH16>0,CH16*Main!$D67,0)","v":1664.3058748217084},null,"Interest Earnings",{"$f":"IF(CK16>0,CK16*Main!$D67,0)","v":1356.4706339175184},{"$f":"IF(CL16>0,CL16*Main!$D67,0)","v":1527.8107007361984},{"$f":"IF(CM16>0,CM16*Main!$D67,0)","v":1715.0284585441805},{"$f":"IF(CN16>0,CN16*Main!$D67,0)","v":1908.8421403274162},{"$f":"IF(CO16>0,CO16*Main!$D67,0)","v":2037.3947554941271},{"$f":"IF(CP16>0,CP16*Main!$D67,0)","v":1617.4524684031819},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,null,null,null,null,null,null,null,"Remaining",null,null,null,null,null,null,"Useful","Rem.","Current",null,null,null,null,"Rem.",null,null," ",null,"Current",null,null,null,null,null,"Fully",null,null,null,null,"Current",null,null,null,null,null,null,null,"Current","Fully","Current","Proportional",null,null,"Total Income",{"$f":"SUM(BB24:BB27)","v":185306.99597424574},148135.30017334648,158835.67912768919,169919.92019616894,181373.31694681779,null,"Total Income",187847.39325381379,197175.63255996766,209826.66974499222,221058.38013360015,232000.84366354559,null,"Total Income",236046.29008462516,236184.57450708843,250937.72552370111,265915.44297402137,222353.68759472939,null,"Total Income",230565.45513151397,187789.19031325178,200786.39339487746,217586.39042680108,234580.27495104281,null,"Total Income",168396.50520209191,167087.20784171275,185404.04896056917,204404.04903580624,223631.69599044582,null,"Total Income",148045.28345955198,162881.14668117039,183602.23491835775,201660.35482343918,223665.9911338703,228076.64990101356,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,{"$f":"(1+Main!$D$22)^DV27","v":1},{"$f":"(1+Main!$D$22)^DW27","v":1.03},{"$f":"(1+Main!$D$22)^DX27","v":1.0609},{"$f":"(1+Main!$D$22)^DY27","v":1.092727},{"$f":"(1+Main!$D$22)^DZ27","v":1.1255088099999999},{"$f":"(1+Main!$D$22)^EA27","v":1.1592740742999998},{"$f":"(1+Main!$D$22)^EB27","v":1.1940522965289999},{"$f":"(1+Main!$D$22)^EC27","v":1.22987386542487},{"$f":"(1+Main!$D$22)^ED27","v":1.2667700813876159},{"$f":"(1+Main!$D$22)^EE27","v":1.3047731838292445},{"$f":"(1+Main!$D$22)^EF27","v":1.3439163793441218},{"$f":"(1+Main!$D$22)^EG27","v":1.3842338707244455},{"$f":"(1+Main!$D$22)^EH27","v":1.4257608868461786},{"$f":"(1+Main!$D$22)^EI27","v":1.4685337134515639},{"$f":"(1+Main!$D$22)^EJ27","v":1.512589724855111},{"$f":"(1+Main!$D$22)^EK27","v":1.5579674166007644},{"$f":"(1+Main!$D$22)^EL27","v":1.6047064390987871},{"$f":"(1+Main!$D$22)^EM27","v":1.6528476322717507},{"$f":"(1+Main!$D$22)^EN27","v":1.7024330612399032},{"$f":"(1+Main!$D$22)^EO27","v":1.7535060530771003},{"$f":"(1+Main!$D$22)^EP27","v":1.8061112346694133},{"$f":"(1+Main!$D$22)^EQ27","v":1.8602945717094954},{"$f":"(1+Main!$D$22)^ER27","v":1.9161034088607805},{"$f":"(1+Main!$D$22)^ES27","v":1.973586511126604},{"$f":"(1+Main!$D$22)^ET27","v":2.0327941064604018},{"$f":"(1+Main!$D$22)^EU27","v":2.0937779296542138},{"$f":"(1+Main!$D$22)^EV27","v":2.1565912675438406},{"$f":"(1+Main!$D$22)^EW27","v":2.2212890055701555},{"$f":"(1+Main!$D$22)^EX27","v":2.2879276757372602},{"$f":"(1+Main!$D$22)^EY27","v":2.3565655060093778},{"$f":"(1+Main!$D$22)^EZ27","v":2.4272624711896591},null,null,null,"Remaining","Inflation"]
[null,null,"Additional",null,null,null,null,"Useful","Useful","| --- Current Cost  Est --- |",null,null,null,null,null,"Life","Useful","Cost",null,null,null,"Useful","Useful","[ --- Current Cost Estimate --- ]",null,null,null,"Cost",null,"Effective",null,"Useful",null,"Funded",null,null,null,"Useful","Cost","Deterioration","Deterioration","Fully Funded",null,null,null,null,"Cost","Funded","Fund","Reserve",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Useful","Adjusted"]
[null,null,"Sort 1","Category","#","Component Title","Description","Life","Life","Best ","Worst ",null,"Cost","#","Component","(yrs)","Life (yrs)","Estimate","#","Component","Quantity","Life","Life","Best Case ","Worst Case ","#","Component","Estimate","X","Age","/","Life","=","Balance",null,"#","Component","Life","Estimate","Cost/yr","Significance","Running Total","#","Component","UL","RUL","Estimate","Balance","Balance","Contribs",null,"#","Component",null,null,null,null,null,"#","Component",null,null,null,null,null,"#","Component",null,null,null,null,null,"#","Component",null,null,null,null,null,"#","Component",null,null,null,null,null,"#","Component",null,null,null,null,null,null,{"$f":"Main!D14","v":2015},{"$f":"CQ30+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,{"$f":"Main!AI14","v":0},{"$f":"DV30+1","v":1},{"$f":"DW30+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,null,null,"Life","Cost"]
[{"$f":"AND(ISBLANK(E31),ISBLANK(G31))","v":false},null,null,null,2128,"Well #2 - Replace","(1) Well",50,13,30000,50000,null,{"$f":"(J31+K31)/2","v":40000},{"$f":"E31","v":2128},{"$f":"F31","v":"Well #2 - Replace"},{"$f":"H31","v":50},{"$f":"I31","v":13},{"$f":"M31","v":40000},{"$f":"E31","v":2128},{"$f":"F31","v":"Well #2 - Replace"},{"$f":"G31","v":"(1) Well"},{"$f":"H31","v":50},{"$f":"I31","v":13},{"$f":"J31","v":30000},{"$f":"K31","v":50000},{"$f":"E31","v":2128},{"$f":"F31","v":"Well #2 - Replace"},{"$f":"M31","v":40000},"X",{"$f":"IF(H31-I31<0,0,H31-I31)","v":37},"/",{"$f":"H31","v":50},"=",{"$f":"DV31+(1-Main!$D$61)*(DW31-DV31)","v":29600},null,{"$f":"E31","v":2128},{"$f":"F31","v":"Well #2 - Replace"},{"$f":"H31","v":50},{"$f":"M31","v":40000},{"$f":"IF(H31>0,M31/H31,0)","v":800},{"$f":"AN31/AN$42","v":9.2485549132947972E-2},{"$f":"SUM(AV$31:AV31)","v":29600},{"$f":"E31","v":2128},{"$f":"F31","v":"Well #2 - Replace"},{"$f":"H31","v":50},{"$f":"I31","v":13},{"$f":"M31","v":40000},{"$f":"DV31+(1-Main!$D$61)*(DW31-DV31)","v":29600},{"$f":"IF(Main!D$26>1,Main!D$26*AV31,IF((AP31-AV31)>=Main!D$20,0,IF(AP31<=Main!D$20,AV31,Main!D$20-AP31+AV31)))","v":50521.179978880675},{"$f":"AO31*Main!RecommendContrib","v":66.589595375722539},null,{"$f":"$E31","v":2128},{"$f":"$F31","v":"Well #2 - Replace"},{"$f":"IF(CQ31=0,$M31*BB$3,0)","v":0},{"$f":"IF(CR31=0,$M31*BC$3,0)","v":0},{"$f":"IF(CS31=0,$M31*BD$3,0)","v":0},{"$f":"IF(CT31=0,$M31*BE$3,0)","v":0},{"$f":"IF(CU31=0,$M31*BF$3,0)","v":0},{"$f":"$E31","v":2128},{"$f":"$F31","v":"Well #2 - Replace"},{"$f":"IF(CV31=0,$M31*BI$3,0)","v":0},{"$f":"IF(CW31=0,$M31*BJ$3,0)","v":0},{"$f":"IF(CX31=0,$M31*BK$3,0)","v":0},{"$f":"IF(CY31=0,$M31*BL$3,0)","v":0},{"$f":"IF(CZ31=0,$M31*BM$3,0)","v":0},{"$f":"$E31","v":2128},{"$f":"$F31","v":"Well #2 - Replace"},{"$f":"IF(DA31=0,$M31*BP$3,0)","v":0},{"$f":"IF(DB31=0,$M31*BQ$3,0)","v":0},{"$f":"IF(DC31=0,$M31*BR$3,0)","v":0},{"$f":"IF(DD31=0,$M31*BS$3,0)","v":58741.348538062557},{"$f":"IF(DE31=0,$M31*BT$3,0)","v":0},{"$f":"$E31","v":2128},{"$f":"$F31","v":"Well #2 - Replace"},{"$f":"IF(DF31=0,$M31*BW$3,0)","v":0},{"$f":"IF(DG31=0,$M31*BX$3,0)","v":0},{"$f":"IF(DH31=0,$M31*BY$3,0)","v":0},{"$f":"IF(DI31=0,$M31*BZ$3,0)","v":0},{"$f":"IF(DJ31=0,$M31*CA$3,0)","v":0},{"$f":"$E31","v":2128},{"$f":"$F31","v":"Well #2 - Replace"},{"$f":"IF(DK31=0,$M31*CD$3,0)","v":0},{"$f":"IF(DL31=0,$M31*CE$3,0)","v":0},{"$f":"IF(DM31=0,$M31*CF$3,0)","v":0},{"$f":"IF(DN31=0,$M31*CG$3,0)","v":0},{"$f":"IF(DO31=0,$M31*CH$3,0)","v":0},{"$f":"$E31","v":2128},{"$f":"$F31","v":"Well #2 - Replace"},{"$f":"IF(DP31=0,$M31*CK$3,0)","v":0},{"$f":"IF(DQ31=0,$M31*CL$3,0)","v":0},{"$f":"IF(DR31=0,$M31*CM$3,0)","v":0},{"$f":"IF(DS31=0,$M31*CN$3,0)","v":0},{"$f":"IF(DT31=0,$M31*CO$3,0)","v":0},{"$f":"IF(DU31=0,$M31*CP$3,0)","v":0},{"$f":"IF(H31=0,I31,IF($I31>$H31,$H31,$I31))","v":13},{"$f":"IF(AND($H31>0,$I31-CR$28>=$H31),$H31,IF(CQ31=999,999,IF(CQ31-1<0,IF($H31=0,999,$H31-1),CQ31-1)))","v":12},11,10,9,8,7,6,5,4,3,2,1,0,49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,{"$f":"IF($H31>0,$M31*($H31-CQ31)/$H31,$M31/(CQ31+1))","v":29600},{"$f":"IF(CR31=999,0,IF($H31>0,DW$28*$M31*($H31-CR31)/$H31,DW$28*$M31/(CR31+1)))","v":31312},{"$f":"IF(CS31=999,0,IF($H31>0,DX$28*$M31*($H31-CS31)/$H31,DX$28*$M31/(CS31+1)))","v":33100.080000000002},{"$f":"IF(CT31=999,0,IF($H31>0,DY$28*$M31*($H31-CT31)/$H31,DY$28*$M31/(CT31+1)))","v":34967.264000000003},{"$f":"IF(CU31=999,0,IF($H31>0,DZ$28*$M31*($H31-CU31)/$H31,DZ$28*$M31/(CU31+1)))","v":36916.688967999995},{"$f":"IF(CV31=999,0,IF($H31>0,EA$28*$M31*($H31-CV31)/$H31,EA$28*$M31/(CV31+1)))","v":38951.608896479993},{"$f":"IF(CW31=999,0,IF($H31>0,EB$28*$M31*($H31-CW31)/$H31,EB$28*$M31/(CW31+1)))","v":41075.399000597601},{"$f":"IF(CX31=999,0,IF($H31>0,EC$28*$M31*($H31-CX31)/$H31,EC$28*$M31/(CX31+1)))","v":43291.560062955425},{"$f":"IF(CY31=999,0,IF($H31>0,ED$28*$M31*($H31-CY31)/$H31,ED$28*$M31/(CY31+1)))","v":45603.722929954172},{"$f":"IF(CZ31=999,0,IF($H31>0,EE$28*$M31*($H31-CZ31)/$H31,EE$28*$M31/(CZ31+1)))","v":48015.653164916199},{"$f":"IF(DA31=999,0,IF($H31>0,EF$28*$M31*($H31-DA31)/$H31,EF$28*$M31/(DA31+1)))","v":50531.255863338978},{"$f":"IF(DB31=999,0,IF($H31>0,EG$28*$M31*($H31-DB31)/$H31,EG$28*$M31/(DB31+1)))","v":53154.580635818711},{"$f":"IF(DC31=999,0,IF($H31>0,EH$28*$M31*($H31-DC31)/$H31,EH$28*$M31/(DC31+1)))","v":55889.826764370206},{"$f":"IF(DD31=999,0,IF($H31>0,EI$28*$M31*($H31-DD31)/$H31,EI$28*$M31/(DD31+1)))","v":58741.348538062557},{"$f":"IF(DE31=999,0,IF($H31>0,EJ$28*$M31*($H31-DE31)/$H31,EJ$28*$M31/(DE31+1)))","v":1210.0717798840888},{"$f":"IF(DF31=999,0,IF($H31>0,EK$28*$M31*($H31-DF31)/$H31,EK$28*$M31/(DF31+1)))","v":2492.747866561223},{"$f":"IF(DG31=999,0,IF($H31>0,EL$28*$M31*($H31-DG31)/$H31,EL$28*$M31/(DG31+1)))","v":3851.2954538370891},{"$f":"IF(DH31=999,0,IF($H31>0,EM$28*$M31*($H31-DH31)/$H31,EM$28*$M31/(DH31+1)))","v":5289.112423269602},{"$f":"IF(DI31=999,0,IF($H31>0,EN$28*$M31*($H31-DI31)/$H31,EN$28*$M31/(DI31+1)))","v":6809.7322449596131},{"$f":"IF(DJ31=999,0,IF($H31>0,EO$28*$M31*($H31-DJ31)/$H31,EO$28*$M31/(DJ31+1)))","v":8416.8290547700817},{"$f":"IF(DK31=999,0,IF($H31>0,EP$28*$M31*($H31-DK31)/$H31,EP$28*$M31/(DK31+1)))","v":10114.222914148713},{"$f":"IF(DL31=999,0,IF($H31>0,EQ$28*$M31*($H31-DL31)/$H31,EQ$28*$M31/(DL31+1)))","v":11905.885258940771},{"$f":"IF(DM31=999,0,IF($H31>0,ER$28*$M31*($H31-DM31)/$H31,ER$28*$M31/(DM31+1)))","v":13795.944543797621},{"$f":"IF(DN31=999,0,IF($H31>0,ES$28*$M31*($H31-DN31)/$H31,ES$28*$M31/(DN31+1)))","v":15788.692089012833},{"$f":"IF(DO31=999,0,IF($H31>0,ET$28*$M31*($H31-DO31)/$H31,ET$28*$M31/(DO31+1)))","v":17888.588136851537},{"$f":"IF(DP31=999,0,IF($H31>0,EU$28*$M31*($H31-DP31)/$H31,EU$28*$M31/(DP31+1)))","v":20100.268124680453},{"$f":"IF(DQ31=999,0,IF($H31>0,EV$28*$M31*($H31-DQ31)/$H31,EV$28*$M31/(DQ31+1)))","v":22428.549182455939},{"$f":"IF(DR31=999,0,IF($H31>0,EW$28*$M31*($H31-DR31)/$H31,EW$28*$M31/(DR31+1)))","v":24878.436862385744},{"$f":"IF(DS31=999,0,IF($H31>0,EX$28*$M31*($H31-DS31)/$H31,EX$28*$M31/(DS31+1)))","v":27455.132108847123},{"$f":"IF(DT31=999,0,IF($H31>0,EY$28*$M31*($H31-DT31)/$H31,EY$28*$M31/(DT31+1)))","v":30164.038476920035},{"$f":"IF(DU31=999,0,IF($H31>0,EZ$28*$M31*($H31-DU31)/$H31,EZ$28*$M31/(DU31+1)))","v":33010.769608179362},null,null,null,{"$f":"MAX(0,I31-Years)","v":13},{"$f":"K31*(1+Inflation/100)^Years","v":50000}]
[false,null,null,null,2128,"Well #3 - Replace","(1) Well",30,19,30000,50000,null,40000,2128,"Well #3 - Replace",30,19,40000,2128,"Well #3 - Replace","(1) Well",30,19,30000,50000,2128,"Well #3 - Replace",40000,"X",11,"/",30,"=",{"$f":"DV32+(1-Main!$D$61)*(DW32-DV32)","v":14666.666666666666},null,2128,"Well #3 - Replace",30,40000,1333.3333333333333,0.15414258188824662,{"$f":"SUM(AV$31:AV32)","v":44266.666666666664},2128,"Well #3 - Replace",30,19,40000,{"$f":"DV32+(1-Main!$D$61)*(DW32-DV32)","v":14666.666666666666},{"$f":"IF(Main!D$26>1,Main!D$26*AV32,IF((AP32-AV32)>=Main!D$20,0,IF(AP32<=Main!D$20,AV32,Main!D$20-AP32+AV32)))","v":25033.017106652584},{"$f":"AO32*Main!RecommendContrib","v":110.98265895953756},null,2128,"Well #3 - Replace",0,0,0,0,0,2128,"Well #3 - Replace",0,0,0,0,0,2128,"Well #3 - Replace",0,0,0,0,0,2128,"Well #3 - Replace",0,0,0,0,70140.242123084012,2128,"Well #3 - Replace",0,0,0,0,0,2128,"Well #3 - Replace",0,0,0,0,0,0,19,{"$f":"IF(AND($H32>0,$I32-CR$28>=$H32),$H32,IF(CQ32=999,999,IF(CQ32-1<0,IF($H32=0,999,$H32-1),CQ32-1)))","v":18},17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0,29,28,27,26,25,24,23,22,21,20,19,14666.666666666666,16480,18388.933333333334,20397.570666666667,22510.176199999998,24731.180251733331,27065.185387990667,29516.972770196884,32091.508728486268,34793.951568779848,37629.658621635412,40604.193541250403,43723.333863282809,46993.078830450046,50419.657495170366,54009.537108826495,57769.431807556335,61706.311604812028,65827.411701276258,70140.242123084012,2408.1483128925511,4960.7855245586543,7664.4136354431221,10525.794726008555,13551.960709736013,16750.223437233712,20128.185163742513,23693.749392748326,27455.132108847123,31420.873413458368,35599.849577448331,null,null,null,19,50000]
[false,null,null,null,2128,"Well #4 - Replace","(1) Well",30,24,30000,50000,null,40000,2128,"Well #4 - Replace",30,24,40000,2128,"Well #4 - Replace","(1) Well",30,24,30000,50000,2128,"Well #4 - Replace",40000,"X",6,"/",30,"=",{"$f":"DV33+(1-Main!$D$61)*(DW33-DV33)","v":8000},null,2128,"Well #4 - Replace",30,40000,1333.3333333333333,0.15414258188824662,{"$f":"SUM(AV$31:AV33)","v":52266.666666666664},2128,"Well #4 - Replace",30,24,40000,{"$f":"DV33+(1-Main!$D$61)*(DW33-DV33)","v":8000},{"$f":"IF(Main!D$26>1,Main!D$26*AV33,IF((AP33-AV33)>=Main!D$20,0,IF(AP33<=Main!D$20,AV33,Main!D$20-AP33+AV33)))","v":13654.372967265048},{"$f":"AO33*Main!RecommendContrib","v":110.98265895953756},null,2128,"Well #4 - Replace",0,0,0,0,0,2128,"Well #4 - Replace",0,0,0,0,0,2128,"Well #4 - Replace",0,0,0,0,0,2128,"Well #4 - Replace",0,0,0,0,0,2128,"Well #4 - Replace",0,0,0,0,81311.764258416079,2128,"Well #4 - Replace",0,0,0,0,0,0,24,{"$f":"IF(AND($H33>0,$I33-CR$28>=$H33),$H33,IF(CQ33=999,999,IF(CQ33-1<0,IF($H33=0,999,$H33-1),CQ33-1)))","v":23},22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0,29,28,27,26,25,24,8000,9613.3333333333339,11316.266666666666,13112.724,15006.784133333333,17002.686423066665,19104.836744463999,21317.813667364415,23646.374852568832,26095.463676584888,28670.216092674596,31375.967736420764,34218.26128430829,37202.85407410629,40335.725996136294,43623.087664821403,47071.38888023109,50687.327389667022,54477.857959676905,58450.201769236679,62611.856135206319,66970.604581541833,71534.527264135802,76312.011763562026,81311.764258416079,2791.7039062056188,5750.9100467835751,8885.156022280622,12202.280937265388,15710.436706729184,19418.099769517274,null,null,null,24,50000]
[{"$f":"AND(ISBLANK(E34),ISBLANK(G34))","v":false},null,null,null,2157,"Water Storage Tank - Repair/Paint","~ 5,200 GSF",15,0,30000,40000,null,35000,2157,"Water Storage Tank - Repair/Paint",15,0,35000,2157,"Water Storage Tank - Repair/Paint","~ 5,200 GSF",15,0,30000,40000,2157,"Water Storage Tank - Repair/Paint",35000,"X",15,"/",15,"=",{"$f":"DV34+(1-Main!$D$61)*(DW34-DV34)","v":35000},null,2157,"Water Storage Tank - Repair/Paint",15,35000,2333.3333333333335,0.26974951830443161,{"$f":"SUM(AV$31:AV34)","v":87266.666666666657},2157,"Water Storage Tank - Repair/Paint",15,0,35000,{"$f":"DV34+(1-Main!$D$61)*(DW34-DV34)","v":35000},{"$f":"IF(Main!D$26>1,Main!D$26*AV34,IF((AP34-AV34)>=Main!D$20,0,IF(AP34<=Main!D$20,AV34,Main!D$20-AP34+AV34)))","v":59737.881731784582},{"$f":"AO34*Main!RecommendContrib","v":194.21965317919077},null,2157,"Water Storage Tank - Repair/Paint",35000,0,0,0,0,2157,"Water Storage Tank - Repair/Paint",0,0,0,0,0,2157,"Water Storage Tank - Repair/Paint",0,0,0,0,0,2157,"Water Storage Tank - Repair/Paint",54528.859581026758,0,0,0,0,2157,"Water Storage Tank - Repair/Paint",0,0,0,0,0,2157,"Water Storage Tank - Repair/Paint",0,0,0,0,0,84954.186491638073,0,{"$f":"IF(AND($H34>0,$I34-CR$28>=$H34),$H34,IF(CQ34=999,999,IF(CQ34-1<0,IF($H34=0,999,$H34-1),CQ34-1)))","v":14},13,12,11,10,9,8,7,6,5,4,3,2,1,0,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0,35000,2403.3333333333335,4950.8666666666668,7649.088999999999,10504.748893333333,13524.864200166663,16716.732151405999,20087.939801939541,23646.374852568832,27400.236860414134,31358.048851362841,35528.6693485941,39921.304831693,44545.522641364107,49411.264345266958,54528.859581026758,3744.3150245638367,7713.2889506015035,11917.031428679324,16366.056495386269,21071.297737809822,26044.124003932935,31296.355678059408,36840.281541029937,42688.676235668441,48854.818358598321,55352.509200291912,62196.092155964361,69400.47283069689,76981.13986297301,84954.186491638087,null,null,null,0,40000]
[false,null,null,null,2189,"Pump House - Maintain","(1) 10x8 Structure",20,7,1000,2000,null,1500,2189,"Pump House - Maintain",20,7,1500,2189,"Pump House - Maintain","(1) 10x8 Structure",20,7,1000,2000,2189,"Pump House - Maintain",1500,"X",13,"/",20,"=",{"$f":"DV35+(1-Main!$D$61)*(DW35-DV35)","v":975},null,2189,"Pump House - Maintain",20,1500,75,8.670520231213872E-3,{"$f":"SUM(AV$31:AV35)","v":88241.666666666657},2189,"Pump House - Maintain",20,7,1500,{"$f":"DV35+(1-Main!$D$61)*(DW35-DV35)","v":975},{"$f":"IF(Main!D$26>1,Main!D$26*AV35,IF((AP35-AV35)>=Main!D$20,0,IF(AP35<=Main!D$20,AV35,Main!D$20-AP35+AV35)))","v":1664.1267053854276},{"$f":"AO35*Main!RecommendContrib","v":6.2427745664739875},null,2189,"Pump House - Maintain",0,0,0,0,0,2189,"Pump House - Maintain",0,0,1844.810798137305,0,0,2189,"Pump House - Maintain",0,0,0,0,0,2189,"Pump House - Maintain",0,0,0,0,0,2189,"Pump House - Maintain",0,0,0,0,0,2189,"Pump House - Maintain",0,0,3331.9335083552332,0,0,0,7,{"$f":"IF(AND($H35>0,$I35-CR$28>=$H35),$H35,IF(CQ35=999,999,IF(CQ35-1<0,IF($H35=0,999,$H35-1),CQ35-1)))","v":6},5,4,3,2,1,0,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0,19,18,17,975,1081.5,1193.5125,1311.2724000000001,1435.0237327499999,1565.0200003049997,1701.5245225538249,1844.810798137305,95.007756104071206,195.71597757438667,302.38118535242739,415.27016121733368,534.66033256731703,660.84017105320379,794.10960554893325,934.78044996045867,1083.1768463916812,1239.635724203813,1404.5072755229201,1578.1554477693903,1760.9584538026779,1953.3093002949704,2155.6163349683784,2368.3038133519249,2591.8124857370121,2826.600205033189,3073.1425562499726,3331.9335083552332,171.59457568029453,353.48482590140668,546.13405601767329,null,null,null,7,2000]
[false,null,null,null,2531,"Sensaphone - Replace","(1) Unit",8,0,1000,3000,null,2000,2531,"Sensaphone - Replace",8,0,2000,2531,"Sensaphone - Replace","(1) Unit",8,0,1000,3000,2531,"Sensaphone - Replace",2000,"X",8,"/",8,"=",{"$f":"DV36+(1-Main!$D$61)*(DW36-DV36)","v":2000},null,2531,"Sensaphone - Replace",8,2000,250,2.8901734104046242E-2,{"$f":"SUM(AV$31:AV36)","v":90241.666666666657},2531,"Sensaphone - Replace",8,0,2000,{"$f":"DV36+(1-Main!$D$61)*(DW36-DV36)","v":2000},{"$f":"IF(Main!D$26>1,Main!D$26*AV36,IF((AP36-AV36)>=Main!D$20,0,IF(AP36<=Main!D$20,AV36,Main!D$20-AP36+AV36)))","v":3413.593241816262},{"$f":"AO36*Main!RecommendContrib","v":20.809248554913296},null,2531,"Sensaphone - Replace",2000,0,0,0,0,2531,"Sensaphone - Replace",0,0,0,2533.5401627752317,0,2531,"Sensaphone - Replace",0,0,0,0,0,2531,"Sensaphone - Replace",0,3209.4128781975742,0,0,0,2531,"Sensaphone - Replace",0,0,0,0,4065.5882129208035,2531,"Sensaphone - Replace",0,0,0,0,0,0,0,{"$f":"IF(AND($H36>0,$I36-CR$28>=$H36),$H36,IF(CQ36=999,999,IF(CQ36-1<0,IF($H36=0,999,$H36-1),CQ36-1)))","v":7},6,5,4,3,2,1,0,7,6,5,4,3,2,1,0,7,6,5,4,3,2,1,0,7,6,5,4,3,2,2000,257.5,530.44999999999993,819.54525000000012,1125.5088099999998,1449.0925928749998,1791.0784447934998,2152.2792644935225,2533.5401627752317,326.19329595731114,671.95818967206094,1038.1754030433342,1425.7608868461787,1835.6671418144549,2268.8845872826664,2726.4429790513377,3209.4128781975742,413.21190806793766,851.21653061995164,1315.129539807825,1806.1112346694133,2325.3682146368692,2874.1551132911709,3453.7763944715571,4065.5882129208035,523.44448241355349,1078.2956337719204,1665.9667541776166,2287.9276757372604,2945.7068825117221,3640.893706784489,null,null,null,0,3000]
[false,null,null,null,2533,"Submersible Transducer - Replace","(1) Transducer",10,4,1000,1500,null,1250,2533,"Submersible Transducer - Replace",10,4,1250,2533,"Submersible Transducer - Replace","(1) Transducer",10,4,1000,1500,2533,"Submersible Transducer - Replace",1250,"X",6,"/",10,"=",{"$f":"DV37+(1-Main!$D$61)*(DW37-DV37)","v":750},null,2533,"Submersible Transducer - Replace",10,1250,125,1.4450867052023121E-2,{"$f":"SUM(AV$31:AV37)","v":90991.666666666657},2533,"Submersible Transducer - Replace",10,4,1250,{"$f":"DV37+(1-Main!$D$61)*(DW37-DV37)","v":750},{"$f":"IF(Main!D$26>1,Main!D$26*AV37,IF((AP37-AV37)>=Main!D$20,0,IF(AP37<=Main!D$20,AV37,Main!D$20-AP37+AV37)))","v":1280.0974656810981},{"$f":"AO37*Main!RecommendContrib","v":10.404624277456648},null,2533,"Submersible Transducer - Replace",0,0,0,0,1406.8860124999999,2533,"Submersible Transducer - Replace",0,0,0,0,0,2533,"Submersible Transducer - Replace",0,0,0,0,1890.7371560688887,2533,"Submersible Transducer - Replace",0,0,0,0,0,2533,"Submersible Transducer - Replace",0,0,0,0,2540.9926330755025,2533,"Submersible Transducer - Replace",0,0,0,0,0,0,4,{"$f":"IF(AND($H37>0,$I37-CR$28>=$H37),$H37,IF(CQ37=999,999,IF(CQ37-1<0,IF($H37=0,999,$H37-1),CQ37-1)))","v":3},2,1,0,9,8,7,6,5,4,3,2,1,0,9,8,7,6,5,4,3,2,1,0,9,8,7,6,5,4,750,901.25,1060.9000000000001,1229.3178750000002,1406.8860124999999,144.90925928749999,298.51307413224998,461.20269953432626,633.38504069380792,815.48323989327776,1007.9372845080914,1211.2046368838896,1425.7608868461787,1652.1004276330095,1890.7371560688887,194.74592707509555,401.17660977469677,619.81786210190648,851.21653061995164,1095.9412831731877,1354.5834260020597,1627.7577502458084,1916.1034088607805,2220.2848250174293,2540.9926330755025,261.72224120677674,539.14781688596008,832.98337708880831,1143.96383786863,1472.8534412558611,1820.4468533922445,null,null,null,4,1500]
[false,null,null,null,2535,"Well Motor/Pump - Replace (2014)","(1) Unit",10,9,3000,5000,null,4000,2535,"Well Motor/Pump - Replace (2014)",10,9,4000,2535,"Well Motor/Pump - Replace (2014)","(1) Unit",10,9,3000,5000,2535,"Well Motor/Pump - Replace (2014)",4000,"X",1,"/",10,"=",{"$f":"DV38+(1-Main!$D$61)*(DW38-DV38)","v":400},null,2535,"Well Motor/Pump - Replace (2014)",10,4000,400,4.6242774566473986E-2,{"$f":"SUM(AV$31:AV38)","v":91391.666666666657},2535,"Well Motor/Pump - Replace (2014)",10,9,4000,{"$f":"DV38+(1-Main!$D$61)*(DW38-DV38)","v":400},{"$f":"IF(Main!D$26>1,Main!D$26*AV38,IF((AP38-AV38)>=Main!D$20,0,IF(AP38<=Main!D$20,AV38,Main!D$20-AP38+AV38)))","v":682.71864836325233},{"$f":"AO38*Main!RecommendContrib","v":33.294797687861269},null,2535,"Well Motor/Pump - Replace (2014)",0,0,0,0,0,2535,"Well Motor/Pump - Replace (2014)",0,0,0,0,5219.0927353169782,2535,"Well Motor/Pump - Replace (2014)",0,0,0,0,0,2535,"Well Motor/Pump - Replace (2014)",0,0,0,0,7014.0242123084008,2535,"Well Motor/Pump - Replace (2014)",0,0,0,0,0,2535,"Well Motor/Pump - Replace (2014)",0,0,0,0,9426.2620240375109,0,9,{"$f":"IF(AND($H38>0,$I38-CR$28>=$H38),$H38,IF(CQ38=999,999,IF(CQ38-1<0,IF($H38=0,999,$H38-1),CQ38-1)))","v":8},7,6,5,4,3,2,1,0,9,8,7,6,5,4,3,2,1,0,9,8,7,6,5,4,3,2,1,0,9,400,824,1273.08,1748.3632000000002,2251.0176199999996,2782.2577783199999,3343.3464302811999,3935.5963693595841,4560.3722929954174,5219.0927353169782,537.56655173764875,1107.3870965795563,1710.9130642154146,2349.6539415225025,3025.1794497102219,3739.1217998418347,4493.178029476604,5289.112423269602,6128.7590204636517,7014.0242123084008,722.44449386776535,1488.2356573675963,2299.3240906329365,3157.7384178025663,4065.588212920803,5025.0670311701133,6038.4555491227538,7108.1248178244978,8236.5396326541377,9426.2620240375109,970.90498847586366,null,null,null,9,5000]
[false,null,null,null,2535,"Well Motors/Pumps - Replace (2005)","(2) Units",10,0,6000,10000,null,8000,2535,"Well Motors/Pumps - Replace (2005)",10,0,8000,2535,"Well Motors/Pumps - Replace (2005)","(2) Units",10,0,6000,10000,2535,"Well Motors/Pumps - Replace (2005)",8000,"X",10,"/",10,"=",{"$f":"DV39+(1-Main!$D$61)*(DW39-DV39)","v":8000},null,2535,"Well Motors/Pumps - Replace (2005)",10,8000,800,9.2485549132947972E-2,{"$f":"SUM(AV$31:AV39)","v":99391.666666666657},2535,"Well Motors/Pumps - Replace (2005)",10,0,8000,{"$f":"DV39+(1-Main!$D$61)*(DW39-DV39)","v":8000},{"$f":"IF(Main!D$26>1,Main!D$26*AV39,IF((AP39-AV39)>=Main!D$20,0,IF(AP39<=Main!D$20,AV39,Main!D$20-AP39+AV39)))","v":13654.372967265048},{"$f":"AO39*Main!RecommendContrib","v":66.589595375722539},null,2535,"Well Motors/Pumps - Replace (2005)",8000,0,0,0,0,2535,"Well Motors/Pumps - Replace (2005)",0,0,0,0,0,2535,"Well Motors/Pumps - Replace (2005)",10751.331034752975,0,0,0,0,2535,"Well Motors/Pumps - Replace (2005)",0,0,0,0,0,2535,"Well Motors/Pumps - Replace (2005)",14448.889877355306,0,0,0,0,2535,"Well Motors/Pumps - Replace (2005)",0,0,0,0,0,19418.099769517274,0,{"$f":"IF(AND($H39>0,$I39-CR$28>=$H39),$H39,IF(CQ39=999,999,IF(CQ39-1<0,IF($H39=0,999,$H39-1),CQ39-1)))","v":9},8,7,6,5,4,3,2,1,0,9,8,7,6,5,4,3,2,1,0,9,8,7,6,5,4,3,2,1,0,8000,824,1697.4399999999998,2622.5448000000006,3601.6281919999992,4637.0962971999998,5731.4510233391993,6887.2936463792721,8107.3285208807411,9394.3669235705602,10751.331034752975,1107.3870965795563,2281.217418953886,3524.4809122837532,4840.287119536355,6231.8696664030576,7702.5909076741782,9255.9467407218035,10895.571591935381,12625.243582155123,14448.889877355305,1488.2356573675963,3065.765454177249,4736.6076267038497,6504.9411406732852,8375.1117186168558,10351.638084210435,12439.21843119287,14642.737124718467,16967.271643267519,19418.099769517274,null,null,null,0,10000]
[false,null,null,null,2537,"Pumps/Valves - Allowance","Multiple Units",5,4,3000,4000,null,3500,2537,"Pumps/Valves - Allowance",5,4,3500,2537,"Pumps/Valves - Allowance","Multiple Units",5,4,3000,4000,2537,"Pumps/Valves - Allowance",3500,"X",1,"/",5,"=",{"$f":"DV40+(1-Main!$D$61)*(DW40-DV40)","v":700},null,2537,"Pumps/Valves - Allowance",5,3500,700,8.0924855491329481E-2,{"$f":"SUM(AV$31:AV40)","v":100091.66666666666},2537,"Pumps/Valves - Allowance",5,4,3500,{"$f":"DV40+(1-Main!$D$61)*(DW40-DV40)","v":700},{"$f":"IF(Main!D$26>1,Main!D$26*AV40,IF((AP40-AV40)>=Main!D$20,0,IF(AP40<=Main!D$20,AV40,Main!D$20-AP40+AV40)))","v":1194.7576346356916},{"$f":"AO40*Main!RecommendContrib","v":58.265895953757223},null,2537,"Pumps/Valves - Allowance",0,0,0,0,3939.2808349999996,2537,"Pumps/Valves - Allowance",0,0,0,0,4566.7061434023553,2537,"Pumps/Valves - Allowance",0,0,0,0,5294.0640369928888,2537,"Pumps/Valves - Allowance",0,0,0,0,6137.2711857698514,2537,"Pumps/Valves - Allowance",0,0,0,0,7114.779372611406,2537,"Pumps/Valves - Allowance",0,0,0,0,8247.979271032822,0,4,{"$f":"IF(AND($H40>0,$I40-CR$28>=$H40),$H40,IF(CQ40=999,999,IF(CQ40-1<0,IF($H40=0,999,$H40-1),CQ40-1)))","v":3},2,1,0,4,3,2,1,0,4,3,2,1,0,4,3,2,1,0,4,3,2,1,0,4,3,2,1,0,4,700,1442,2227.89,3059.6356000000001,3939.2808349999991,811.49185200999989,1671.6732151406,2582.735117392227,3546.956227885325,4566.7061434023553,940.74146554088532,1937.9274190142237,2994.0978623769747,4111.8943976643786,5294.0640369928888,1090.5771916205351,2246.589014738302,3470.9800277706759,4766.8125714717289,6137.2711857698514,1264.2778642685894,2604.4124003932934,4023.8171586076387,5526.0422311544917,7114.779372611406,1465.6445507579497,3019.2277745613765,4664.7069116973271,6406.1974920643279,8247.979271032822,1699.0837298327613,null,null,null,4,4000]
[false,null,null,null,2569,"Water Storage Tank - Minor Repairs","~ 200k Gallons",5,0,2000,3000,null,2500,2569,"Water Storage Tank - Minor Repairs",5,0,2500,2569,"Water Storage Tank - Minor Repairs","~ 200k Gallons",5,0,2000,3000,2569,"Water Storage Tank - Minor Repairs",2500,"X",5,"/",5,"=",{"$f":"DV41+(1-Main!$D$61)*(DW41-DV41)","v":2500},null,2569,"Water Storage Tank - Minor Repairs",5,2500,500,5.7803468208092484E-2,{"$f":"SUM(AV$31:AV41)","v":102591.66666666666},2569,"Water Storage Tank - Minor Repairs",5,0,2500,{"$f":"DV41+(1-Main!$D$61)*(DW41-DV41)","v":2500},{"$f":"IF(Main!D$26>1,Main!D$26*AV41,IF((AP41-AV41)>=Main!D$20,0,IF(AP41<=Main!D$20,AV41,Main!D$20-AP41+AV41)))","v":4266.9915522703268},{"$f":"AO41*Main!RecommendContrib","v":41.618497109826592},null,2569,"Water Storage Tank - Minor Repairs",2500,0,0,0,0,2569,"Water Storage Tank - Minor Repairs",2898.1851857499996,0,0,0,0,2569,"Water Storage Tank - Minor Repairs",3359.7909483603044,0,0,0,0,2569,"Water Storage Tank - Minor Repairs",3894.918541501911,0,0,0,0,2569,"Water Storage Tank - Minor Repairs",4515.2780866735329,0,0,0,0,2569,"Water Storage Tank - Minor Repairs",5234.4448241355349,0,0,0,0,6068.1561779741478,0,{"$f":"IF(AND($H41>0,$I41-CR$28>=$H41),$H41,IF(CQ41=999,999,IF(CQ41-1<0,IF($H41=0,999,$H41-1),CQ41-1)))","v":4},3,2,1,0,4,3,2,1,0,4,3,2,1,0,4,3,2,1,0,4,3,2,1,0,4,3,2,1,0,2500,515,1060.9000000000001,1639.0904999999998,2251.0176199999996,2898.1851857499996,597.02614826449997,1229.87386542487,1900.155122081424,2609.5463676584886,3359.7909483603044,692.11693536222276,1425.7608868461787,2202.8005701773459,3025.1794497102219,3894.9185415019106,802.35321954939354,1652.8476322717506,2553.6495918598548,3507.0121061542004,4515.2780866735329,930.14728585474768,1916.1034088607805,2960.3797666899059,4065.5882129208039,5234.4448241355349,1078.2956337719202,2221.2890055701555,3431.8915136058904,4713.1310120187554,6068.1561779741478,null,null,null,0,3000]
[false,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(TopCell:CellAbove<>0,1,0))","v":11},"Total Funded Components",null,null,null,{"$f":"N42","v":11},"Total Funded Components",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(TopCell:CellAbove)","v":102591.66666666666},null,{"$f":"N42","v":11},"Total Funded Components",null,null,{"$f":"SUM(TopCell:CellAbove)","v":8650},{"$f":"IF(ISERROR(SUM(TopCell:CellAbove)),0,SUM(TopCell:CellAbove))","v":0.99999999999999989},null,{"$f":"N42","v":11},"Total Funded Components",null,null,null,null,{"$f":"SUM(TopCell:CellAbove)","v":175103.11000000002},{"$f":"SUM(TopCell:CellAbove)","v":720},null,null,"Total Expenses",{"$f":"SUM(TopCell:CellAbove)","v":47500},{"$f":"SUM(TopCell:CellAbove)","v":0},{"$f":"SUM(TopCell:CellAbove)","v":0},{"$f":"SUM(TopCell:CellAbove)","v":0},{"$f":"SUM(TopCell:CellAbove)","v":5346.1668474999997},null,"Total Expenses",{"$f":"SUM(TopCell:CellAbove)","v":2898.1851857499996},{"$f":"SUM(TopCell:CellAbove)","v":0},{"$f":"SUM(TopCell:CellAbove)","v":1844.810798137305},{"$f":"SUM(TopCell:CellAbove)","v":2533.5401627752317},{"$f":"SUM(TopCell:CellAbove)","v":9785.7988787193335},null,"Total Expenses",{"$f":"SUM(TopCell:CellAbove)","v":14111.12198311328},{"$f":"SUM(TopCell:CellAbove)","v":0},{"$f":"SUM(TopCell:CellAbove)","v":0},{"$f":"SUM(TopCell:CellAbove)","v":58741.348538062557},{"$f":"SUM(TopCell:CellAbove)","v":7184.8011930617777},null,"Total Expenses",{"$f":"SUM(TopCell:CellAbove)","v":58423.778122528667},{"$f":"SUM(TopCell:CellAbove)","v":3209.4128781975742},{"$f":"SUM(TopCell:CellAbove)","v":0},{"$f":"SUM(TopCell:CellAbove)","v":0},{"$f":"SUM(TopCell:CellAbove)","v":83291.53752116226},null,"Total Expenses",{"$f":"SUM(TopCell:CellAbove)","v":18964.167964028838},{"$f":"SUM(TopCell:CellAbove)","v":0},{"$f":"SUM(TopCell:CellAbove)","v":0},{"$f":"SUM(TopCell:CellAbove)","v":0},{"$f":"SUM(TopCell:CellAbove)","v":95033.124477023783},null,"Total Expenses",{"$f":"SUM(TopCell:CellAbove)","v":5234.4448241355349},{"$f":"SUM(TopCell:CellAbove)","v":0},{"$f":"SUM(TopCell:CellAbove)","v":3331.9335083552332},{"$f":"SUM(TopCell:CellAbove)","v":0},{"$f":"SUM(TopCell:CellAbove)","v":17674.241295070333},{"$f":"SUM(TopCell:CellAbove)","v":110440.44243912949},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(TopCell:CellAbove)","v":102591.66666666666},{"$f":"SUM(TopCell:CellAbove)","v":65653.916666666672},{"$f":"SUM(TopCell:CellAbove)","v":76800.319166666653},{"$f":"SUM(TopCell:CellAbove)","v":88556.417291666658},{"$f":"SUM(TopCell:CellAbove)","v":100948.76101691667},{"$f":"SUM(TopCell:CellAbove)","v":108498.39273719414},{"$f":"SUM(TopCell:CellAbove)","v":119096.76614296336},{"$f":"SUM(TopCell:CellAbove)","v":133308.07806317738},{"$f":"SUM(TopCell:CellAbove)","v":146364.72648699413},{"$f":"SUM(TopCell:CellAbove)","v":159432.4099540684},{"$f":"SUM(TopCell:CellAbove)","v":165760.88608893624},{"$f":"SUM(TopCell:CellAbove)","v":168172.88001076411},{"$f":"SUM(TopCell:CellAbove)","v":185550.8980823064},{"$f":"SUM(TopCell:CellAbove)","v":203820.24164613165},{"$f":"SUM(TopCell:CellAbove)","v":162515.16102130784},{"$f":"SUM(TopCell:CellAbove)","v":173466.68877669011},{"$f":"SUM(TopCell:CellAbove)","v":132374.90867199079},{"$f":"SUM(TopCell:CellAbove)","v":147337.59268675768},{"$f":"SUM(TopCell:CellAbove)","v":166483.76644708554},{"$f":"SUM(TopCell:CellAbove)","v":186646.10679961499},{"$f":"SUM(TopCell:CellAbove)","v":122078.06853669677},{"$f":"SUM(TopCell:CellAbove)","v":122298.86563513507},{"$f":"SUM(TopCell:CellAbove)","v":142542.12609083488},{"$f":"SUM(TopCell:CellAbove)","v":163889.91319480506},{"$f":"SUM(TopCell:CellAbove)","v":186390.27961153165},{"$f":"SUM(TopCell:CellAbove)","v":112209.04888005208},{"$f":"SUM(TopCell:CellAbove)","v":128838.35664184831},{"$f":"SUM(TopCell:CellAbove)","v":151917.65723928553},{"$f":"SUM(TopCell:CellAbove)","v":172833.86983798552},{"$f":"SUM(TopCell:CellAbove)","v":198403.17756010615},{"$f":"SUM(TopCell:CellAbove)","v":207146.62472877753}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ending Reserve Balance:",{"$f":"BB28-BB42","v":137806.99597424574},{"$f":"BC28-BC42","v":148135.30017334648},{"$f":"BD28-BD42","v":158835.67912768919},{"$f":"BE28-BE42","v":169919.92019616894},{"$f":"BF28-BF42","v":176027.15009931781},null,"Ending Reserve Balance:",{"$f":"BI28-BI42","v":184949.2080680638},{"$f":"BJ28-BJ42","v":197175.63255996766},{"$f":"BK28-BK42","v":207981.85894685492},{"$f":"BL28-BL42","v":218524.83997082492},{"$f":"BM28-BM42","v":222215.04478482626},null,"Ending Reserve Balance:",{"$f":"BP28-BP42","v":221935.16810151187},{"$f":"BQ28-BQ42","v":236184.57450708843},{"$f":"BR28-BR42","v":250937.72552370111},{"$f":"BS28-BS42","v":207174.0944359588},{"$f":"BT28-BT42","v":215168.88640166761},null,"Ending Reserve Balance:",{"$f":"BW28-BW42","v":172141.67700898531},{"$f":"BX28-BX42","v":184579.77743505419},{"$f":"BY28-BY42","v":200786.39339487746},{"$f":"BZ28-BZ42","v":217586.39042680108},{"$f":"CA28-CA42","v":151288.73742988054},null,"Ending Reserve Balance:",{"$f":"CD28-CD42","v":149432.33723806308},{"$f":"CE28-CE42","v":167087.20784171275},{"$f":"CF28-CF42","v":185404.04896056917},{"$f":"CG28-CG42","v":204404.04903580624},{"$f":"CH28-CH42","v":128598.57151342204},null,"Ending Reserve Balance:",{"$f":"CK28-CK42","v":142810.83863541644},162881.14668117039,180270.30141000252,201660.35482343918,205991.74983879997,117636.20746188407]

{"sheet":"Starting Bal","index":3,"n_rows":89,"n_cols":8,"rows_kept":89,"cut":false,"hidden":false,"merged":[[6,0,6,7],[11,1,11,3],[8,1,8,2],[9,1,9,2],[8,3,8,5],[24,1,24,5],[22,1,22,5],[12,2,12,3],[20,2,20,5],[31,1,31,5],[23,1,23,5],[21,1,21,5],[35,1,35,5],[25,1,25,5],[30,1,30,5],[32,1,32,5],[34,1,34,5],[33,1,33,5]]}
[null,null,"Reserve Study Starting Reserve Balance Projection"]
[]
[]
[]
[]
[]
["Document your work in the shaded areas B, C, D, & E below"]
[]
["A","Association Name:",null,{"$f":"Main!D11","v":"Kings Row HOA"},null,null,"#",{"$f":"Main!ClientNumber","v":"16151-1"}]
[null,"Period Start:",null,{"$f":"Main!StartDate","v":"2015-01-01"}]
[]
["B","Most Recent Reserve Balance:",null,null,55321]
[null,null,"as-of (mm/dd/yy):",null,"2012-02-18"]
[]
["C","Regular Association Budgeted Assessment Income Total:",null,null,null,null,null,5000]
[null,"Regular Budgeted Reserve contribution portion of above:",null,null,null,null,null,1000]
[null,"Frequency of Above (Month, Quarter, Year):",null,null,null,null,null,"Month"]
[]
["D",{"$f":"\"Additional Reserve Income (Contribs) expected until \" & TEXT(D10,\"mm/dd/yy\") & \":\"","v":"Additional Reserve Income (Contribs) expected until 01/01/15:"}]
[null,"Description",null,null,null,null,null,"Amount"]
[null,2,"Periods of budgeted Reserve contributions",null,null,null,null,{"$f":"H16*B21","v":2000}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Subtotal Expenses:",null,null,null,null,null,{"$f":"SUM(H21:H26)","v":2000}]
[]
["E",{"$f":"\"Anticipated Reserve Expenses expected until \" & TEXT(D10,\"mm/dd/yy\") & \":\"","v":"Anticipated Reserve Expenses expected until 01/01/15:"}]
[null,"Description",null,null,null,null,null,"Amount"]
[null,"remainder of painting project",null,null,null,null,null,30000]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,"Subtotal Expenses:",null,null,null,null,null,{"$f":"SUM(H31:H36)","v":30000}]
[]
[null,{"$f":"\"Projected \" & TEXT(D10,\"mm/dd/yy\") & \" Reserve Balance (A+B-C):\"","v":"Projected 01/01/15 Reserve Balance (A+B-C):"},null,null,null,null,null,{"$f":"E12+H27-H37","v":27321}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Month"]
[null,null,null,"Quarter"]
[null,null,null,"Year"]

{"sheet":"Addnl Info","index":4,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,1,23,7],[8,1,8,7],[27,1,27,7],[28,1,28,7],[24,1,24,7],[25,1,25,7],[26,1,26,7],[18,1,18,7],[19,1,19,7],[20,1,20,7],[17,1,17,7],[0,1,0,7],[16,1,16,7],[4,1,4,7],[2,1,2,2],[9,1,9,7],[10,1,10,7],[11,1,11,7],[12,1,12,7]]}
[null,{"$f":"'Starting Bal'!C1","v":"Reserve Study Starting Reserve Balance Projection"}]
[]
[null,"Association Name:",null,{"$f":"Main!D11","v":"Kings Row HOA"},null,null,"#",{"$f":"Main!ClientNumber","v":"16151-1"}]
[]
[null,"Please enter additional information, as applicable, in the shaded spaces below"]
[]
[null,"Significant Recent Reserve Expenses:"]
[null,"(Description of what, when, $)"]
[]
[]
[]
[]
[]
[]
[null,"Significant Planned Reserve Expenses:"]
[null,"(Description of what, when, $)"]
[]
[]
[]
[]
[]
[]
[null,"Significant Vendors - Roofer, elevator, asphalt, painter, etc.:"]
[null,"(Company Name, Contact Person, phone)"]

{"sheet":"30-yr","index":5,"n_rows":58,"n_cols":12,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,1,57,2],[5,1,5,3],[54,1,54,2],[55,1,55,2],[56,1,56,2],[7,8,8,11],[10,5,10,6],[11,5,11,6],[12,5,12,6],[7,1,7,6],[8,1,8,6]]}
[]
[null,"Table 5:  30-Year Reserve Plan Summary",null,null,null,null,null,null,null,null,null,{"$f":"Main!D10","v":"16151-1"}]
[]
[]
[]
[null,"Fiscal Year Start:",null,null,{"$f":"Main!StartDate","v":"2015-01-01"},null,null,null,"Interest:",{"$f":"Main!InterestRate","v":0.01},"Inflation:",{"$f":"Main!InflationRate","v":0.03}]
[]
[null,"Reserve Fund Strength Calculations",null,null,null,null,null,null,"Projected Reserve Balance Changes"]
[null,"(All values as of Fiscal Year Start Date)"]
[]
[null,null,"Starting","Fully",null,"Special",null,null,null,"Loans or"]
[null,null,"Reserve","Funded","Percent","Assmt",null,null,"Reserve","Special","Interest","Reserve"]
[null,"Year","Balance","Balance","Funded","Risk",null,null,"Contribs.","Assmts","Income","Expenses"]
[null,{"$f":"Data!BB23","v":2015},{"$f":"Data!BB24","v":175103.11},{"$f":"Main!FullyFunded","v":102591.66666666666},{"$f":"Main!PercentFunded","v":1.7067966209081309},null,{"$f":"IF(E14<D$55,E$55,IF(E14<D$56,E$56,IF(E14<D$57,E$57,E$58)))","v":"Low"},null,{"$f":"Data!BB25","v":8640},{"$f":"Data!BB26","v":0},{"$f":"Data!BB27","v":1563.8859742457587},{"$f":"Data!BB42","v":47500}]
[null,{"$f":"Data!BC23","v":2016},{"$f":"Data!BC24","v":137806.99597424574},{"$f":"Data!DW42","v":65653.916666666672},{"$f":"Data!BC18","v":2.0989912402927837},null,"Low",null,{"$f":"Data!BC25","v":8899.2000000000007},{"$f":"Data!BC26","v":0},{"$f":"Data!BC27","v":1429.1041991007219},{"$f":"Data!BC42","v":0}]
[null,{"$f":"Data!BD23","v":2017},{"$f":"Data!BD24","v":148135.30017334648},{"$f":"Data!DX42","v":76800.319166666653},{"$f":"Data!BD18","v":1.928837038448677},null,"Low",null,{"$f":"Data!BD25","v":9166.1760000000013},{"$f":"Data!BD26","v":0},{"$f":"Data!BD27","v":1534.2029543426986},{"$f":"Data!BD42","v":0}]
[null,{"$f":"Data!BE23","v":2018},{"$f":"Data!BE24","v":158835.67912768919},{"$f":"Data!DY42","v":88556.417291666658},{"$f":"Data!BE18","v":1.7936100396265235},null,"Low",null,{"$f":"Data!BE25","v":9441.1612800000021},{"$f":"Data!BE26","v":0},{"$f":"Data!BE27","v":1643.079788479751},{"$f":"Data!BE42","v":0}]
[null,{"$f":"Data!BF23","v":2019},{"$f":"Data!BF24","v":169919.92019616894},{"$f":"Data!DZ42","v":100948.76101691667},{"$f":"Data!BF18","v":1.6832293777998355},null,"Low",null,{"$f":"Data!BF25","v":9724.3961184000018},{"$f":"Data!BF26","v":0},{"$f":"Data!BF27","v":1729.0006322488425},{"$f":"Data!BF42","v":5346.1668474999997}]
[null,{"$f":"Data!BI23","v":2020},{"$f":"Data!BI24","v":176027.15009931781},{"$f":"Data!EA42","v":108498.39273719414},{"$f":"Data!BI18","v":1.6223940803039587},null,"Low",null,{"$f":"Data!BI25","v":10016.128001952002},{"$f":"Data!BI26","v":0},{"$f":"Data!BI27","v":1804.1151525439871},{"$f":"Data!BI42","v":2898.1851857499996}]
[null,{"$f":"Data!BJ23","v":2021},{"$f":"Data!BJ24","v":184949.2080680638},{"$f":"Data!EB42","v":119096.76614296336},{"$f":"Data!BJ18","v":1.5529322420564418},null,"Low",null,{"$f":"Data!BJ25","v":10316.611842010561},{"$f":"Data!BJ26","v":0},{"$f":"Data!BJ27","v":1909.8126498933216},{"$f":"Data!BJ42","v":0}]
[null,{"$f":"Data!BK23","v":2022},{"$f":"Data!BK24","v":197175.63255996766},{"$f":"Data!EC42","v":133308.07806317738},{"$f":"Data!BK18","v":1.4790974067342129},null,"Low",null,{"$f":"Data!BK25","v":10626.110197270878},{"$f":"Data!BK26","v":0},{"$f":"Data!BK27","v":2024.9269877536824},{"$f":"Data!BK42","v":1844.810798137305}]
[null,{"$f":"Data!BL23","v":2023},{"$f":"Data!BL24","v":207981.85894685492},{"$f":"Data!ED42","v":146364.72648699413},{"$f":"Data!BL18","v":1.4209834837858699},null,"Low",null,{"$f":"Data!BL25","v":10944.893503189005},{"$f":"Data!BL26","v":0},{"$f":"Data!BL27","v":2131.6276835562376},{"$f":"Data!BL42","v":2533.5401627752317}]
[null,{"$f":"Data!BM23","v":2024},{"$f":"Data!BM24","v":218524.83997082492},{"$f":"Data!EE42","v":159432.4099540684},{"$f":"Data!BM18","v":1.3706425188817051},null,"Low",null,{"$f":"Data!BM25","v":11273.240308284676},{"$f":"Data!BM26","v":0},{"$f":"Data!BM27","v":2202.7633844359934},{"$f":"Data!BM42","v":9785.7988787193335}]
[null,{"$f":"Data!BP23","v":2025},{"$f":"Data!BP24","v":222215.04478482626},{"$f":"Data!EF42","v":165760.88608893624},{"$f":"Data!BP18","v":1.3405758742481655},null,"Low",null,{"$f":"Data!BP25","v":11611.437517533217},{"$f":"Data!BP26","v":0},{"$f":"Data!BP27","v":2219.8077822656887},{"$f":"Data!BP42","v":14111.12198311328}]
[null,{"$f":"Data!BQ23","v":2026},{"$f":"Data!BQ24","v":221935.16810151187},{"$f":"Data!EG42","v":168172.88001076411},{"$f":"Data!BQ18","v":1.3196846488405658},null,"Low",null,{"$f":"Data!BQ25","v":11959.780643059214},{"$f":"Data!BQ26","v":0},{"$f":"Data!BQ27","v":2289.6257625173498},{"$f":"Data!BQ42","v":0}]
[null,{"$f":"Data!BR23","v":2027},{"$f":"Data!BR24","v":236184.57450708843},{"$f":"Data!EH42","v":185550.8980823064},{"$f":"Data!BR18","v":1.2728829498972407},null,"Low",null,{"$f":"Data!BR25","v":12318.57406235099},{"$f":"Data!BR26","v":0},{"$f":"Data!BR27","v":2434.5769542617031},{"$f":"Data!BR42","v":0}]
[null,{"$f":"Data!BS23","v":2028},{"$f":"Data!BS24","v":250937.72552370111},{"$f":"Data!EI42","v":203820.24164613165},{"$f":"Data!BS18","v":1.231171759473104},null,"Low",null,{"$f":"Data!BS25","v":12688.131284221519},{"$f":"Data!BS26","v":0},{"$f":"Data!BS27","v":2289.586166098697},{"$f":"Data!BS42","v":58741.348538062557}]
[null,{"$f":"Data!BT23","v":2029},{"$f":"Data!BT24","v":207174.0944359588},{"$f":"Data!EJ42","v":162515.16102130784},{"$f":"Data!BT18","v":1.2747985673090254},null,"Low",null,{"$f":"Data!BT25","v":13068.775222748165},{"$f":"Data!BT26","v":0},{"$f":"Data!BT27","v":2110.817936022404},{"$f":"Data!BT42","v":7184.8011930617777}]
[null,{"$f":"Data!BW23","v":2030},{"$f":"Data!BW24","v":215168.88640166761},{"$f":"Data!EK42","v":173466.68877669011},{"$f":"Data!BW18","v":1.2404046443675549},null,"Low",null,{"$f":"Data!BW25","v":13460.838479430611},{"$f":"Data!BW26","v":0},{"$f":"Data!BW27","v":1935.7302504157406},{"$f":"Data!BW42","v":58423.778122528667}]
[null,{"$f":"Data!BX23","v":2031},{"$f":"Data!BX24","v":172141.67700898531},{"$f":"Data!EL42","v":132374.90867199079},{"$f":"Data!BX18","v":1.3004101663671914},null,"Low",null,{"$f":"Data!BX25","v":13864.66363381353},{"$f":"Data!BX26","v":0},{"$f":"Data!BX27","v":1782.8496704529471},{"$f":"Data!BX42","v":3209.4128781975742}]
[null,{"$f":"Data!BY23","v":2032},{"$f":"Data!BY24","v":184579.77743505419},{"$f":"Data!EM42","v":147337.59268675768},{"$f":"Data!BY18","v":1.2527677021808958},null,"Low",null,{"$f":"Data!BY25","v":14280.603542827937},{"$f":"Data!BY26","v":0},{"$f":"Data!BY27","v":1926.0124169953403},{"$f":"Data!BY42","v":0}]
[null,{"$f":"Data!BZ23","v":2033},{"$f":"Data!BZ24","v":200786.39339487746},{"$f":"Data!EN42","v":166483.76644708554},{"$f":"Data!BZ18","v":1.2060418723088808},null,"Low",null,{"$f":"Data!BZ25","v":14709.021649112776},{"$f":"Data!BZ26","v":0},{"$f":"Data!BZ27","v":2090.9753828108301},{"$f":"Data!BZ42","v":0}]
[null,{"$f":"Data!CA23","v":2034},{"$f":"Data!CA24","v":217586.39042680108},{"$f":"Data!EO42","v":186646.10679961499},{"$f":"Data!CA18","v":1.1657697776702296},null,"Low",null,{"$f":"Data!CA25","v":15150.292298586159},{"$f":"Data!CA26","v":0},{"$f":"Data!CA27","v":1843.592225655555},{"$f":"Data!CA42","v":83291.53752116226}]
[null,{"$f":"Data!CD23","v":2035},{"$f":"Data!CD24","v":151288.73742988054},{"$f":"Data!EP42","v":122078.06853669677},{"$f":"Data!CD18","v":1.2392785964204784},null,"Low",null,{"$f":"Data!CD25","v":15604.801067543744},{"$f":"Data!CD26","v":0},{"$f":"Data!CD27","v":1502.966704667622},{"$f":"Data!CD42","v":18964.167964028838}]
[null,{"$f":"Data!CE23","v":2036},{"$f":"Data!CE24","v":149432.33723806308},{"$f":"Data!EQ42","v":122298.86563513507},{"$f":"Data!CE18","v":1.2218620055224199},null,"Low",null,{"$f":"Data!CE25","v":16072.945099570055},{"$f":"Data!CE26","v":0},{"$f":"Data!CE27","v":1581.925504079599},{"$f":"Data!CE42","v":0}]
[null,{"$f":"Data!CF23","v":2037},{"$f":"Data!CF24","v":167087.20784171275},{"$f":"Data!ER42","v":142542.12609083488},{"$f":"Data!CF18","v":1.1721952830648572},null,"Low",null,{"$f":"Data!CF25","v":16555.133452557158},{"$f":"Data!CF26","v":0},{"$f":"Data!CF27","v":1761.707666299279},{"$f":"Data!CF42","v":0}]
[null,{"$f":"Data!CG23","v":2038},{"$f":"Data!CG24","v":185404.04896056917},{"$f":"Data!ES42","v":163889.91319480506},{"$f":"Data!CG18","v":1.1312718723585611},null,"Low",null,{"$f":"Data!CG25","v":17051.787456133872},{"$f":"Data!CG26","v":0},{"$f":"Data!CG27","v":1948.2126191032082},{"$f":"Data!CG42","v":0}]
[null,{"$f":"Data!CH23","v":2039},{"$f":"Data!CH24","v":204404.04903580624},{"$f":"Data!ET42","v":186390.27961153165},{"$f":"Data!CH18","v":1.0966454337737905},null,"Low",null,{"$f":"Data!CH25","v":17563.341079817888},{"$f":"Data!CH26","v":0},{"$f":"Data!CH27","v":1664.3058748217084},{"$f":"Data!CH42","v":95033.124477023783}]
[null,{"$f":"Data!CK23","v":2040},{"$f":"Data!CK24","v":128598.57151342204},{"$f":"Data!EU42","v":112209.04888005208},{"$f":"Data!CK18","v":1.1460623969007155},null,"Low",null,{"$f":"Data!CK25","v":18090.241312212427},{"$f":"Data!CK26","v":0},{"$f":"Data!CK27","v":1356.4706339175184},{"$f":"Data!CK42","v":5234.4448241355349}]
[null,{"$f":"Data!CL23","v":2041},{"$f":"Data!CL24","v":142810.83863541644},{"$f":"Data!EV42","v":128838.35664184831},{"$f":"Data!CL18","v":1.1084497067314323},null,"Low",null,{"$f":"Data!CL25","v":18542.497345017735},{"$f":"Data!CL26","v":0},{"$f":"Data!CL27","v":1527.8107007361984},{"$f":"Data!CL42","v":0}]
[null,{"$f":"Data!CM23","v":2042},{"$f":"Data!CM24","v":162881.14668117039},{"$f":"Data!EW42","v":151917.65723928553},{"$f":"Data!CM18","v":1.0721673151174012},null,"Low",null,{"$f":"Data!CM25","v":19006.059778643175},{"$f":"Data!CM26","v":0},{"$f":"Data!CM27","v":1715.0284585441805},{"$f":"Data!CM42","v":3331.9335083552332}]
[null,{"$f":"Data!CN23","v":2043},{"$f":"Data!CN24","v":180270.30141000252},{"$f":"Data!EX42","v":172833.86983798552},{"$f":"Data!CN18","v":1.0430264714837891},null,"Low",null,{"$f":"Data!CN25","v":19481.211273109253},{"$f":"Data!CN26","v":0},{"$f":"Data!CN27","v":1908.8421403274162},{"$f":"Data!CN42","v":0}]
[null,{"$f":"Data!CO23","v":2044},{"$f":"Data!CO24","v":201660.35482343918},{"$f":"Data!EY42","v":198403.17756010615},{"$f":"Data!CO18","v":1.016416961176674},null,"Low",null,{"$f":"Data!CO25","v":19968.241554936983},{"$f":"Data!CO26","v":0},{"$f":"Data!CO27","v":2037.3947554941271},{"$f":"Data!CO42","v":17674.241295070333}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Top of Weak Range:",null,0.3,"High"]
[null,"Top of Fair Range:",null,0.7,"Med"]
[null,"Top of Strong Range:",null,1.3,"Low"]
[null,"Named Surplus:",null,null,"Low"]

{"sheet":"Budget Sum","index":6,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[[17,8,17,10],[7,4,7,5],[7,6,7,7]]}
[null,null,null,null,4,4,5,5,9,50,45,30,null,46]
[]
[null,null,"Reserve Budget Funding Summary"]
[null,null,{"$f":"Main!ClientNumber","v":"16151-1"},{"$f":"Main!ClientName","v":"Kings Row HOA"}]
[]
[]
[null,null,null,null,null,null,{"$f":"Main!BaseYear","v":2015},null,"Estimated",null,{"$f":"Main!StartDate","v":"2015-01-01"},{"$f":"Main!StartDate","v":"2015-01-01"}]
[null,null,null,null,"Useful Life",null,"Rem. Useful Life",null,"Replacement",{"$f":"Main!BaseYear","v":2015},"Current Fund","Fully Funded","Remaining Bal.",{"$f":"Main!BaseYear","v":2015}]
["Code",null,null,null,"Min","Max","Min","Max",{"$f":" \"Cost in\" & \" \" & TEXT(Main!BaseYear,0)","v":"Cost in 2015"},"Expenditures","Balance","Balance","to be Funded","Contributions"]
["I",null,"Interiors",null,{"$f":"MIN(IF(Data!Category=$A10,OFFSET(Data!Category,0,E$1),\"\"))","v":0},{"$f":"MAX(IF(Data!Category=$A10,OFFSET(Data!Category,0,F$1),\"\"))","v":0},{"$f":"MIN(IF(Data!Category=$A10,OFFSET(Data!Category,0,G$1),\"\"))","v":0},{"$f":"MAX(IF(Data!Category=$A10,OFFSET(Data!Category,0,H$1),\"\"))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A10,OFFSET(Data!Category,0,I$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A10,OFFSET(Data!Category,0,J$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A10,OFFSET(Data!Category,0,K$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A10,OFFSET(Data!Category,0,L$1))","v":0},{"$f":"I10-K10","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A10,OFFSET(Data!Category,0,N$1))*Main!D$48","v":0}]
["R",null,"Roofing",null,{"$f":"MIN(IF(Data!Category=$A11,OFFSET(Data!Category,0,E$1),\"\"))","v":0},{"$f":"MAX(IF(Data!Category=$A11,OFFSET(Data!Category,0,F$1),\"\"))","v":0},{"$f":"MIN(IF(Data!Category=$A11,OFFSET(Data!Category,0,G$1),\"\"))","v":0},{"$f":"MAX(IF(Data!Category=$A11,OFFSET(Data!Category,0,H$1),\"\"))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A11,OFFSET(Data!Category,0,I$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A11,OFFSET(Data!Category,0,J$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A11,OFFSET(Data!Category,0,K$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A11,OFFSET(Data!Category,0,L$1))","v":0},{"$f":"I11-K11","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A11,OFFSET(Data!Category,0,N$1))*Main!D$48","v":0}]
["A",null,"Capital Assets",null,{"$f":"MIN(IF(Data!Category=$A12,OFFSET(Data!Category,0,E$1),\"\"))","v":0},{"$f":"MAX(IF(Data!Category=$A12,OFFSET(Data!Category,0,F$1),\"\"))","v":0},{"$f":"MIN(IF(Data!Category=$A12,OFFSET(Data!Category,0,G$1),\"\"))","v":0},{"$f":"MAX(IF(Data!Category=$A12,OFFSET(Data!Category,0,H$1),\"\"))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A12,OFFSET(Data!Category,0,I$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A12,OFFSET(Data!Category,0,J$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A12,OFFSET(Data!Category,0,K$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A12,OFFSET(Data!Category,0,L$1))","v":0},{"$f":"I12-K12","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A12,OFFSET(Data!Category,0,N$1))*Main!D$48","v":0}]
["P",null,"Paint",null,{"$f":"MIN(IF(Data!Category=$A13,OFFSET(Data!Category,0,E$1),\"\"))","v":0},{"$f":"MAX(IF(Data!Category=$A13,OFFSET(Data!Category,0,F$1),\"\"))","v":0},{"$f":"MIN(IF(Data!Category=$A13,OFFSET(Data!Category,0,G$1),\"\"))","v":0},{"$f":"MAX(IF(Data!Category=$A13,OFFSET(Data!Category,0,H$1),\"\"))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A13,OFFSET(Data!Category,0,I$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A13,OFFSET(Data!Category,0,J$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A13,OFFSET(Data!Category,0,K$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A13,OFFSET(Data!Category,0,L$1))","v":0},{"$f":"I13-K13","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A13,OFFSET(Data!Category,0,N$1))*Main!D$48","v":0}]
["H",null,"Hardscape",null,{"$f":"MIN(IF(Data!Category=$A14,OFFSET(Data!Category,0,E$1),\"\"))","v":0},{"$f":"MAX(IF(Data!Category=$A14,OFFSET(Data!Category,0,F$1),\"\"))","v":0},{"$f":"MIN(IF(Data!Category=$A14,OFFSET(Data!Category,0,G$1),\"\"))","v":0},{"$f":"MAX(IF(Data!Category=$A14,OFFSET(Data!Category,0,H$1),\"\"))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A14,OFFSET(Data!Category,0,I$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A14,OFFSET(Data!Category,0,J$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A14,OFFSET(Data!Category,0,K$1))","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A14,OFFSET(Data!Category,0,L$1))","v":0},{"$f":"I14-K14","v":0},{"$f":"SUMIF(Data!Category,\"=\" & $A14,OFFSET(Data!Category,0,N$1))*Main!D$48","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I10:I14)","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,"Percent Funded:",{"$f":"IF(L15=0,0,K15/L15)","v":0}]

{"sheet":"Thermometer","index":7,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["X","Y","Labels"]
[0.15,-0.05,"High"]
[0.5,-0.05,"Medium"]
[1,-0.05,"Low"]
[1.5,-0.05]
[{"$f":"MIN(A11,C7)","v":1.59},7.0000000000000007E-2,"Max Value"]
[null,0,1.59]
[0.3,0]
[0.7,0]
[1.3,0]
[{"$f":"Main!PercentFunded","v":1.7067966209081309}]
[{"$f":"\"Reserves % Funded: \" & TEXT($A$11,\"0%\")","v":"Reserves % Funded: 171%"}]

{"sheet":"Solver","index":12,"n_rows":47,"n_cols":34,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,2,0,3]]}
[1,null,"Initial Settings:",null,null,null,null,null,null,"= administrator initial settings"]
[2,null,"Initial Contrib:",{"$f":"Data!AW42/12","v":14591.925833333335},"InitialContribution",null,null,null,null,"= computed diagnostics used by solver"]
[3,null,"# of units",{"$f":"Main!NumUnits","v":45},"NumUnits"]
[4,null,"1AI & 2AI",0.03,"AnnualIncreasePct"]
[5,null,"1AIY & 2AIY",30,"AnnualIncreaseYears"]
[6,null,"Initial Cycle Contrib Change",0.01,"ContributionChangeCycle1",null,null,"Counters"]
[7,null,"2nd Cycle Contrib Change",5.0000000000000001E-3,"ContributionChangeCycle2",null,null,"Pass #",1]
[8,null,"Min Expense Remainder",0.1,"MinExpRemainder",null,null,"Cycle1",296]
[9,null,"SA Rounder (per unit)",10,"RoundFactor",null,null,"Cycle2",9]
[10,null,"SA Change",0.1,"SAChangePct",null,null,"Cycle3",7]
[11,null,"Early Special Assmt Range max yr",4,"MaxEarlyYears"]
[12,null,"Contribution rounder",10,"ContribRound",null,null,{"$f":"Main!RecommendContrib","v":720},"Main!d30","Contrib Rate"]
[13,null,"Change in 2AI",5.0000000000000001E-3,"ChangeIn2AI",null,null,{"$f":"Main!D33","v":25},"Main!d32","# of Initial Years"]
[14,null,"2nd Cycle Contrib Boost",0.04,"Cycle2ContribBoost",null,null,{"$f":"Main!D34","v":2.5000000000000001E-2},"Main!d33","% of Secondary Increase"]
[15,null,"1AI Change Increment",5,"YearsIncrement",null,null,{"$f":"Main!SpecialAssessment","v":0},"Main!d35","Special Assmt"]
[16,null,"1AI minimum yr limit",5,"YearsMinimum",null,null,{"$f":"D36","v":5.1493462294237187E-2},null,"Std Dev last 5 yrs"]
[17,null,"2AI Lower limit",5.0000000000000001E-3,"AnnualIncreaseLowerLimit2",null,null,{"$f":"D38","v":4},null,"#downslope yrs, last 5 yrs"]
[18,null,"2AI upper limit (underfunded)",0.06,"AnnualIncreaseUpperLimit2",null,null,{"$f":"AvgPctFunded25_29","v":1.0772245702820025},null,"Avg Pct Funded, last 5 yrs"]
[19,null,"Surplus Threshold",2,"SurplusThreshold",null,null,{"$f":"D35","v":-1.6045694519423302E-2},null,"Avg Slope, last 5 yrs"]
[20,null,"Final Cycle Contrib Change",5.0000000000000001E-3,"ContributionChangeCycle3"]
[21,null,"Surplus Pct Funded Flatness",0.15,"SurplusPctFlatness"]
[22,null,"Percent Funded Flatness Criteria",0.02,"FlatnessCriteria"]
[23,null,"Baseline Funding Minimum",0,"BaselineFundingMin"]
[24,null,"Year",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[25,null,"Expenditure",{"$f":"Data!BB42","v":47500},{"$f":"Data!BC42","v":0},{"$f":"Data!BD42","v":0},{"$f":"Data!BE42","v":0},{"$f":"Data!BF42","v":5346.1668474999997},{"$f":"Data!BI42","v":2898.1851857499996},{"$f":"Data!BJ42","v":0},{"$f":"Data!BK42","v":1844.810798137305},{"$f":"Data!BL42","v":2533.5401627752317},{"$f":"Data!BM42","v":9785.7988787193335},{"$f":"Data!BP42","v":14111.12198311328},{"$f":"Data!BQ42","v":0},{"$f":"Data!BR42","v":0},{"$f":"Data!BS42","v":58741.348538062557},{"$f":"Data!BT42","v":7184.8011930617777},{"$f":"Data!BW42","v":58423.778122528667},{"$f":"Data!BX42","v":3209.4128781975742},{"$f":"Data!BY42","v":0},{"$f":"Data!BZ42","v":0},{"$f":"Data!CA42","v":83291.53752116226},{"$f":"Data!CD42","v":18964.167964028838},{"$f":"Data!CE42","v":0},{"$f":"Data!CF42","v":0},{"$f":"Data!CG42","v":0},{"$f":"Data!CH42","v":95033.124477023783},{"$f":"Data!CK42","v":5234.4448241355349},{"$f":"Data!CL42","v":0},{"$f":"Data!CM42","v":3331.9335083552332},{"$f":"Data!CN42","v":0},{"$f":"Data!CO42","v":17674.241295070333},{"$f":"Data!CP42","v":110440.44243912949}]
[26,null,"Ending Balance",{"$f":"Data!BB44","v":137806.99597424574},{"$f":"Data!BC44","v":148135.30017334648},{"$f":"Data!BD44","v":158835.67912768919},{"$f":"Data!BE44","v":169919.92019616894},{"$f":"Data!BF44","v":176027.15009931781},{"$f":"Data!BI44","v":184949.2080680638},{"$f":"Data!BJ44","v":197175.63255996766},{"$f":"Data!BK44","v":207981.85894685492},{"$f":"Data!BL44","v":218524.83997082492},{"$f":"Data!BM44","v":222215.04478482626},{"$f":"Data!BP44","v":221935.16810151187},{"$f":"Data!BQ44","v":236184.57450708843},{"$f":"Data!BR44","v":250937.72552370111},{"$f":"Data!BS44","v":207174.0944359588},{"$f":"Data!BT44","v":215168.88640166761},{"$f":"Data!BW44","v":172141.67700898531},{"$f":"Data!BX44","v":184579.77743505419},{"$f":"Data!BY44","v":200786.39339487746},{"$f":"Data!BZ44","v":217586.39042680108},{"$f":"Data!CA44","v":151288.73742988054},{"$f":"Data!CD44","v":149432.33723806308},{"$f":"Data!CE44","v":167087.20784171275},{"$f":"Data!CF44","v":185404.04896056917},{"$f":"Data!CG44","v":204404.04903580624},{"$f":"Data!CH44","v":128598.57151342204},{"$f":"Data!CK44","v":142810.83863541644},{"$f":"Data!CL44","v":162881.14668117039},{"$f":"Data!CM44","v":180270.30141000252},{"$f":"Data!CN44","v":201660.35482343918},{"$f":"Data!CO44","v":205991.74983879997},{"$f":"Data!CP44","v":117636.20746188407}]
[27,null,"Early Ending Bal Minimum",{"$f":"MIN(OFFSET(D26,0,0,,MaxEarlyYears+1))","v":137806.99597424574},"MinEndBalance"]
[28,null,"Ending Balance to expense ratio",{"$f":"IF(D25>0,D26/D25,1)","v":2.9011999152472789},{"$f":"IF(E25>0,E26/E25,1)","v":1},1,1,32.925861672579948,63.815524617762541,1,112.73885601539899,86.252763299972131,22.707910466877234,15.7276769605635,1,1,3.5268869304509831,29.947785696485521,2.9464317875499759,57.512007473066326,1,1,1.8163758520058766,7.879720192391555,1,1,1,1.3531973427277286,27.282900753281233,1,54.103811182892024,1,11.654913294425533,1.0651551629442322]
[29,null,"$ to make margin ok",{"$f":"IF(D28<$D$8,$D$8*D25-D26,0)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(M28<$D$8,$D$8*M25-M26,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[30,null,"Minimum Ending Balance Margin",{"$f":"MIN(D28:AG28)","v":1},"MinEndBalanceMargin"]
[31,null,"Early Min Ending Bal Margin",{"$f":"MIN(OFFSET(D28,0,0,,MaxEarlyYears+1))","v":1},"MinEndBalanceMarginEarly"]
[32,null,"Early Min Ending Bal Needs",{"$f":"MAX(OFFSET(D29,0,0,,MaxEarlyYears+1))","v":0},"MinEndBalanceNeeds"]
[33,null,"Pct Funded",{"$f":"Data!BB18","v":1.7067966209081309},{"$f":"Data!BC18","v":2.0989912402927837},{"$f":"Data!BD18","v":1.928837038448677},{"$f":"Data!BE18","v":1.7936100396265235},{"$f":"Data!BF18","v":1.6832293777998355},{"$f":"Data!BI18","v":1.6223940803039587},{"$f":"Data!BJ18","v":1.5529322420564418},{"$f":"Data!BK18","v":1.4790974067342129},{"$f":"Data!BL18","v":1.4209834837858699},{"$f":"Data!BM18","v":1.3706425188817051},{"$f":"Data!BP18","v":1.3405758742481655},{"$f":"Data!BQ18","v":1.3196846488405658},{"$f":"Data!BR18","v":1.2728829498972407},{"$f":"Data!BS18","v":1.231171759473104},{"$f":"Data!BT18","v":1.2747985673090254},{"$f":"Data!BW18","v":1.2404046443675549},{"$f":"Data!BX18","v":1.3004101663671914},{"$f":"Data!BY18","v":1.2527677021808958},{"$f":"Data!BZ18","v":1.2060418723088808},{"$f":"Data!CA18","v":1.1657697776702296},{"$f":"Data!CD18","v":1.2392785964204784},{"$f":"Data!CE18","v":1.2218620055224199},{"$f":"Data!CF18","v":1.1721952830648572},{"$f":"Data!CG18","v":1.1312718723585611},{"$f":"Data!CH18","v":1.0966454337737905},{"$f":"Data!CK18","v":1.1460623969007155},{"$f":"Data!CL18","v":1.1084497067314323},{"$f":"Data!CM18","v":1.0721673151174012},{"$f":"Data!CN18","v":1.0430264714837891},{"$f":"Data!CO18","v":1.016416961176674},{"$f":"Data!CP18","v":0.99442484331333092}]
[34,null,"Pct Funded Change",null,{"$f":"(E33-D33)","v":0.39219461938465283},{"$f":"(F33-E33)","v":-0.17015420184410668},{"$f":"(G33-F33)","v":-0.1352269988221535},{"$f":"(H33-G33)","v":-0.11038066182668804},{"$f":"(I33-H33)","v":-6.0835297495876794E-2},{"$f":"(J33-I33)","v":-6.9461838247516949E-2},-7.3834835322228898E-2,-5.8113922948342944E-2,-5.0340964904164842E-2,-3.0066644633539585E-2,-2.0891225407599689E-2,-4.6801698943325087E-2,-4.1711190424136735E-2,4.3626807835921433E-2,-3.4393922941470478E-2,6.0005521999636491E-2,-4.7642464186295586E-2,-4.6725829872015012E-2,-4.0272094638651224E-2,7.3508818750248839E-2,-1.7416590898058582E-2,-4.9666722457562651E-2,-4.0923410706296126E-2,-3.4626438584770547E-2,4.9416963126925006E-2,-3.7612690169283258E-2,-3.6282391614031129E-2,-2.9140843633612024E-2,-2.6609510307115114E-2,-2.1992117863343097E-2]
[35,null,"Avg % Funded Change 25-29",{"$f":"AVERAGE(AC34:AG34)","v":-1.6045694519423302E-2},"AvgPctFundedChange25_29",null,null,"ac-ag"]
[36,null,"Pct Funded Std Dev 25-29",{"$f":"STDEV(AC33:AG33)","v":5.1493462294237187E-2},null,null,null,"ac-ag"]
[37,null,"Avg Pct Funded 25-29",{"$f":"AVERAGE(AC33:AG33)","v":1.0772245702820025},"AvgPctFunded25_29",null,null,"ac-ag"]
[38,null,"Yrs 25-29 with neg slope",{"$f":"COUNTIF(AC34:AG34,\"<0\")","v":4},"NumMonthLessThanZero"]
[39,null,"Ending Balance Minimum",{"$f":"MIN(D26:AH26)","v":117636.20746188407},"EndingBalanceMin"]
[40,null,"Constraints","Minimum","Maximum"]
[41,null,"1st cycle underfunded",0.7,1.2,"ConstraintCycle1UnderMin","ConstraintCycle1UnderMax"]
[42,null,"2nd cycle",0.9,1.1000000000000001,"ConstraintCycle2Min","ConstraintCycle2Max"]
[43,null,"Final Year",0.98,1.02,"ConstraintFinalYearMin","ConstraintFinalYearMax"]
[44,null,"# of allowable Cycle 1 iterations",500,"MaxCycle1"]
[45,null,"# of allowable Cycle 2 iterations",1000,"MaxCycle2"]
[46,null,"# of allowable Cycle 3 iterations",50,"MaxCycle3"]
[47,null,"# of times through the solver",1,"MaxPass"]

{"sheet":"Coding-F","index":13,"n_rows":199,"n_cols":5,"rows_kept":199,"cut":false,"hidden":false,"merged":[]}
["Note: all cell references refer to \"Solver\" worksheet unless otherwise designated"]
["Full Funding Solver"]
[]
["Start","set annual increases"]
[null,null,"Set 1AI = d4",null,"(1st ramp annual increase)"]
[null,null,"Set 1AIY = d5",null,"(1st ramp annual increase years)"]
[null,null,"Set 2AI = d4",null,"(2nd ramp annual increase)"]
[null,null,"Set 2AIY = d5",null,"(2nd ramp annual increase years)"]
[null,"set pass counter (integers)"]
[null,null,"set pass = 0"]
[null,"set cycle counters (integers)"]
[null,null,"set cycle1 = 0"]
[null,null,"set cycle2 = 0"]
[null,null,"set cycle3 = 0"]
[null,"set initial contribution rate "]
[null,null,"Set contribution (Main!RecommendedContrib) to d2"]
[null,"set flatness check"]
[null,null,"set flat = 0"]
[null,"set 2nd cycle boost check"]
[null,null,"set 2boost = 0"]
[null,"set initial special assessment"]
[null,null,"set special assessment yr 1 (Main!SpecialAssessment) = $0.00"]
[null,"if crash in first few (as defined by 0-d11) yrs, then special assessment"]
[null,null,"if d27<0, goto Special Assess"]
[null,null,"Goto Cycle1"]
[]
["Restart","set cycle counters (integers)"]
[null,null,"set cycle1 = 0"]
[null,null,"set cycle2 = 0"]
[null,null,"set cycle3 = 0"]
[null,null,"set pass = pass + 1"]
[null,"set initial contribution rate "]
[null,null,"Set contribution (Main!RecommendedContrib) to d2"]
[null,"set initial special assessment"]
[null,null,"set special assessment yr 1 (Main!SpecialAssessment) = $0.00"]
[null,"if crash in first few (as defined by 0-d11) yrs, then special assessment"]
[null,null,"if d27<0, goto Special Assess"]
[null,null,"Goto Cycle1"]
[]
["Special Assess","set special assmt amount needed to keep from going negative"]
[null,null,"Set special assessment yr 1 (Main!SpecialAssessment) = +d27"]
[null,null,"divide by d3 to get individual owner special assessment"]
[null,null,"round above up to nearest d9."]
[null,null,"set special assmt yr1 = rounded up individual unit owner special assessment x d3"]
[null,null,"Goto-Cycle1"]
[]
["Special Assess Small","small nudges to increase special assessment"]
[null,null,"if d32>0, set special assmt yr1 = special assessment yr 1 + d32, otherwise…"]
[null,null,"If special assmt yr1 = 0, set special assmt to d2, otherwise…"]
[null,null,"SA = SA x (1+d10)"]
[null,null,"divide by d3 to get individual owner special assessment"]
[null,null,"round above up to nearest d9."]
[null,null,"set special assmt yr1 = rounded up individual unit owner special assessment x d3"]
[null,null,"goto-Cycle1"]
[]
["Cycle1","begin adjusting"]
[null,null,"set cycle1 = cycle1 + 1"]
[null,"test to see if too many cycles (looping broken)"]
[null,null,"if cycle1>d44 goto Cycle2"]
[null,"test to see if early min margin is not met and small special assessment is needed"]
[null,null,"if d31<d8, goto Special Assess Small"]
[null,"test to see if min margin is not met and max constraints are exceeded"]
[null,null,"if d30<d8 and d37>e41, go to Special Assess Small"]
[null,"test to see if min margin is not met and contrib needs increasing"]
[null,null,"if d30<d8 goto-Cycle1-low"]
[null,"test to see if max constraints are exceeded and contrib needs reducing"]
[null,null,"if d37>e41, goto-Cycle1-high"]
[null,"test to see if min constraints not met and contrib needs increasing"]
[null,null,"if d37<d41, goto-Cycle1-low"]
[null,"to get here, must be good, so move on to Cycle2"]
[null,null,"goto-Cycle2"]
[]
["Cycle1-low","contrib needs to be increased"]
[null,null,"increase Main!D30 by d6"]
[null,"try again to see if it passes the minimum ending balance criteria"]
[null,null,"goto-Cycle1"]
[]
["Cycle1-high","contrib needs to be decreased"]
[null,null,"decrease Main!D30 by d6"]
[null,"try again to see if it has dropped down enough to pass along"]
[null,null,"goto-Cycle1"]
[]
["Cycle2","tighten up constraints and work on leveling"]
[null,"set cycle counter"]
["A",null,"set Cycle2=Cycle2 + 1"]
[null,"Set/Reset 2AI (Main!d33)"]
["B",null,"set Main!d33=d4"]
[null,"test to see if too many cycles (looping broken)"]
["C",null,"if cycle2>maxcycle2, goto SolverFailure"]
[null,"check # of declining years in final yrs & send to appropriate corrective measures."]
["D",null,"if NumMonthLessThanZero>2, goto Cycle2-low"]
[null,null,"if NumMonthLessThanZero<=2, goto Cycle2-high"]
[]
["Cycle2-High","due to increasing trend, try to lower the final slope"]
[null,"first... set initial settings"]
["E",null,"set Main!D32=d5"]
[null,"lower secondary increase a notch, if not too low already"]
["F",null,"if(Main!D33-d13>d17, set Main!d33=Main!D33-d13, otherwise set Main!d33=d17)"]
["Cycle2-High-yr","Now cycle # yrs of secondary increases by dropping years of first increase"]
["G",null,"if(Main!D32-d15>d16, set Main!D32=Main!D32-d15, otherwise set Main!D32=d16)"]
[null,"test to see if it flattened the slope enough"]
[null,null,"if 2Boost=0, then"]
[null,null,"if (ABS)d35<=d22, goto Cycle2-constraint"]
[null,null,"else, it has already been boosted and needs to just hunt for a solution,"]
["H",null,"if (ABS)d35<=d22 and d37<=e42 and d37 >= d42, goto Cycle2-constraint"]
[null,"test to see if flattened slope drops below minimum margin"]
["I",null,"if d30<d8, set 2Boost=1 and goto Cycle2-Boost"]
[null,"test to see if flattened profile falls below ending constraints"]
["J",null,"if flat=0, then if d37<d42, goto Cycle2-Boost"]
[null,"still not flat enough, so try more years of lowered secondary ramp"]
["K",null,"if Main!D32>d16, goto Cycle2-High-yr"]
[null,"Since 1AI-yrs are at minimum, drop secondary ramp value & retry"]
["L",null,"if Main!d33>d17, goto Cycle2-High"]
[null,"Since 1AI-yrs are at minimum and 2AI is at minimum, go to SolverFailure"]
["M",null,"goto SolverFailure"]
[]
["Cycle2-Low","due to decreasing trend, try to increase the final slope"]
[null,"first… set initial settings"]
["E",null,"set Main!D32=d5"]
[null,"increase secondary increase a notch, if not too high already"]
["F",null,"if(Main!D33+d13<d18, set Main!d33=Main!D33+d13, otherwise set Main!d33=d18)"]
["Cycle2-Low-yr","Now test # yrs of secondary increases"]
["G",null,"if(Main!D32-d15>d16, set Main!D32=Main!D32-d15, otherwise set Main!D32=d16)"]
[null,"test to see if it flattened the slope enough"]
[null,null,"if main!Percent Funded => d19, then"]
[null,null,"if (ABS)d35<=d21, goto Cycle2-Constraint"]
[null,null,"else, it not a surplus funded situation,"]
["H",null,"if (ABS)d35<=d22, goto Cycle2-constraint"]
[null,"test to see if flattened profile is too high for ending constraints"]
["I",null,"if flat=0, if d37>e42, goto Cycle2-Trim"]
[null,"still not flat enough, so try more years of raised secondary ramp"]
["J",null,"if Main!D32>d16, goto Cycle2-Low-yr"]
[null,"Since1AI-yrs are at minimum, increase secondary ramp value and retry"]
["K",null,"if Main!d33<d18, goto Cycle2-Low"]
[null,"Since, 1AI yrs are at minimum and 2AI is at maximum, go to SolverFailure"]
["L",null,"goto SolverFailure"]
[]
["Cycle2-Constraint","test to see if flattened profile meets ending criteria"]
[null,"But first, document that it got here (was flat enough)...for use in surplus funded situations, "]
[null,"to avoid ever trimming something that needs to be boosted)"]
["M",null,"set flat = 1"]
[null,"test to see if minimum margin met"]
["N",null,"if d30<d8, set 2Boost=1 and goto Cycle2-Boost"]
[null,"test to see if flattened profile falls below ending constraints"]
["O",null,"if d35<d42, goto Cycle2-Boost"]
[null,"test to see if flattened profile is too high for ending constraints"]
["P",null,"if 2boost=0, if d35>e42, goto Cycle2-Trim"]
[null,"test to see if too many passes"]
["Q",null,"if pass < d71, go to restart"]
[null,"otherwise, must be within acceptable range"]
[null,null,"goto Cycle3"]
[]
["Cycle2-Boost","flattened profile now too low, so boost contrib a bit"]
[null,null,"if 2boost=0, then"]
[null,null,"Increase Main!D30 (contribution) by d7"]
[null,null,"otherwise increase Main!d30 (contribution) by d14"]
[null,"try again to flatten it out and pass the min ending balance criteria"]
[null,null,"goto-Cycle2"]
[]
["Cycle2-Trim","flattened profile now too high, so trim contrib a bit"]
[null,null,"Decrease Main!D30 (contribution) by d7"]
[null,"try again to see if it has dropped down enough to pass along"]
[null,null,"goto-Cycle2"]
[]
["Cycle3","Now make minor adjustments to polish contrib & tune in to 100% zone at end"]
[null,"Assume no more slope changes necessary. Contrib tweak only"]
[null,"set Cycle3 counter"]
[null,null,"set cycle3=cycle3+1"]
[null,"test to see if it is looping almost endlessly"]
[null,null,"if cycle3=>d46, goto solverfailure"]
[null,"test to see if too low, & if so, boost contribution a bit"]
[null,null,"if d37<d43, goto Cycle3-Boost"]
[null,"test to see if too high, & if so, drop contribution a bit"]
[null,null,"if d37>e43, goto Cycle3-Trim"]
[null,"Now create a rounded \"final candidate\" contribution"]
[null,null,"Round contribution to nearest d12"]
[null,"otherwise, must be good. Finished"]
[null,null,"goto SolverDone"]
[]
["Cycle3-Boost","Final year slightly too low, so boost contrib a bit"]
[null,null,"increase contribution by d20"]
[null,null,"goto Cycle3"]
[]
["Cycle3-Trim","Final year slightly too high, so trim contrib a bit"]
[null,null,"decrease contribution by d20"]
[null,null,"goto Cycle3"]
[]
["SolverFailure","Indicate failure"]
[null,null,"set Main!d55=\"Failure\""]
[null,null,"goto Display"]
[]
["SolverDone","Indicate Success"]
[null,null,"set Main!d55=\"Success\""]
[null,null,"goto Display"]
[]
["Display","Show # of cycles"]
[null,null,"set Main!d56=Cycle1"]
[null,null,"set Main!d57=Cycle2"]
[null,null,"set Main!d58=Cycle3"]

{"sheet":"Coding-B","index":14,"n_rows":127,"n_cols":12,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
["Note: all cell references refer to \"Solver\" worksheet unless otherwise designated"]
["Baseline Solver"]
[]
["Start","Set Cycle Counters"]
[null,null,"set cycle1 = 0"]
[null,null,"set cycle2 = 0"]
[null,"Set Annual Increases"]
[null,null,"set 1AI = d4"]
[null,null,"set 1AIY=d5"]
[null,"Note: only one ramp that goes 30 yrs. No need for 2AI or 2AIY"]
[null,"Set initial contribution rate "]
[null,null,"Set contribution (Main!RecommendedContrib) to d2"]
[null,"check to see if min margin met"]
[null,null,"set margin1 = N"]
[null,null,"set margin2 = N"]
[null,"set initial special assessment"]
[null,null,"set special assessment yr 1 (Main!SpecialAssessment) = $0.00"]
[null,"if crash in first few (as defined by 0-d11) yrs, then special assessment"]
[null,null,"if d27<0, goto Special Assess"]
[null,null,"Goto Cycle1"]
[]
[]
["Special Assess","set special assmt amount needed to keep from going negative"]
[null,null,"Set special assessment yr 1 (Main!SpecialAssessment) = +d27"]
[null,null,"divide by d3 to get individual owner special assessment"]
[null,null,"round above up to nearest d9."]
[null,null,"set special assmt yr1 = rounded up individual unit owner special assessment x d3"]
[null,null,"Goto-Cycle1"]
[]
["Special Assess Small","small nudges to increase special assessment"]
[null,null,"if d32>0, set special assmt yr1 = special assessment yr 1 + d32, otherwise…"]
[null,null,"If special assmt yr1 = 0, set special assmt to d2, otherwise…"]
[null,null,"SA = SA x (1+d10)"]
[null,null,"divide by d3 to get individual owner special assessment"]
[null,null,"round above up to nearest d9."]
[null,null,"set special assmt yr1 = rounded up individual unit owner special assessment x d3"]
[null,null,"goto-Cycle1"]
[]
["Cycle1","begin adjusting"]
["A",null,"set cycle1 = cycle1 + 1"]
[null,"test to see if too many cycles (looping broken)"]
["B",null,"if cycle1>d44 goto SolverFailure"]
[null,"test to see if early min bal is not met and small special assessment is needed"]
["C",null,"if d27<d23, goto Special Assess Small"]
[null,"test to see if min bal is not met and ending is too high"]
["D",null,"if d39<d23 and d37>e41, go to Special Assess Small"]
[null,"test to see if min bal is not met and contrib needs increasing"]
["E",null,"if d39<d23 goto-Cycle1-low"]
[null,"test to see if min bal is met and contrib needs reducing"]
["F",null,"if d39>=d23 goto-Cycle1-high"]
[null,"if here, must be a problem"]
["G",null,"goto SolverFailure"]
[]
["Cycle1-low","first - check if there was prior success & only dipped low this first time"]
[null,null,"if margin1 = Y, goto-Cycle2"]
[null,"otherwise, confirm unsuccessful Marginmet setting"]
[null,null,"set margin1 = N"]
[null,"contrib needs to be increased"]
[null,null,"increase Main!D30 by d6"]
[null,"return to Cycle1 adjustments"]
[null,null,"goto-Cycle1"]
[]
["Cycle1-high","contrib needs to be decreased"]
[null,null,"decrease Main!D30 by d6"]
[null,"confirm successful Marginmet setting"]
[null,null,"set margin1 = Y"]
[null,"return to Cycle1 adjustments"]
[null,null,"goto-Cycle1"]
[]
["Cycle2","Now make minor adjustments to polish contrib"]
[null,"set Cycle2 counter"]
[null,null,"set cycle2=cycle2+1"]
[null,"test to see if it is looping almost endlessly"]
[null,null,"if cycle2=>d46, goto solverfailure"]
[null,"test to see if successful margin"]
[null,null,"if d39<d23 goto-Cycle2-Boost"]
[null,"test to see if too high, & if so, drop contribution a bit"]
[null,null,"if d39>=d23 goto Cycle2-Trim"]
[]
[]
["Cycle2-Boost","Contrib slightly too low, so boost contrib a bit"]
[null,null,"increase contribution by d20"]
[null,"check to see if that was enough to provide a solution"]
[null,null,"if d39>=d23 and Margin2=N, goto Cycle3"]
[null,"otherwise, confirm unsuccessful Marginmet setting"]
[null,null,"set margin2 = N"]
[null,null,"goto Cycle2"]
[]
["Cycle2-Trim","Final year slightly too high, so trim contrib a bit"]
[null,null,"decrease contribution by d20"]
[null,null,"goto Cycle2"]
[]
["Cycle3","Trim any overfunding"]
[null,null,"Set Main!d32=d5"]
[null,"lower secondary increase a substantial notch"]
[null,null,"if(Main!D33-(2*d13)>d17, set Main!d33=Main!D33-(2*d13), otherwise set Main!d33=d17)"]
["Cycle3yrs","Now cycle # yrs of secondary increases by dropping years of first increase",null,null,null,null,null,null,null,null,"Do While d39>=d23 and Main!d32>d16"]
[null,null,"if(Main!D32-d15>d16, set Main!D32=Main!D32-d15, otherwise set Main!D32=d16)",null,null,null,null,null,null,null,null,"This is the only action inside the loop"]
[null,"test to see if margin is still ok & we can drop further",null,null,null,null,null,null,null,null,"Loop"]
[null,null,"if d39>=d23 and Main!d32>d16, goto Cycle3yrs"]
[null,"test to see if we went too far and we need to back up away from sensitive yr.",null,null,null,null,null,null,null,null,"After exiting the loop, perform this check one time and move on regardless of the outcome."]
[null,null,"if d39<d23, set Main!d32=Main!d32+d15."]
["Cycle3AI","If here, must still be ok. So try a lower 2AI"]
[null,null,"if(Main!D33-d13>d17, set Main!d33=Main!D33-d13, otherwise set Main!d33=d17)",null,null,null,null,null,null,null,"This works exactly the same way as Cycle3yrs"]
[null,"test to see if margin is still ok & we can drop further"]
[null,null,"if d39>=d23 and Main!d33>d17, goto Cycle3AI"]
[null,"test to see if we went too far and we need to back up"]
[null,null,"if d39<d23, set Main!d33=Main!d33+d13."]
[null,"If here, must be ok. Time to wrap it up."]
[null,null,"Goto Finisher"]
[]
["Finisher","Now create a rounded \"final candidate\" contribution"]
[null,null,"Roundup contribution to nearest d12"]
[null,"Must be good. Finished"]
[null,null,"goto SolverDone"]
[]
["SolverFailure","Indicate failure"]
[null,null,"set Main!d55=\"Failure\""]
[null,null,"goto Display"]
[]
["SolverDone","Indicate Success"]
[null,null,"set Main!d55=\"Success\""]
[null,null,"goto Display"]
[]
["Display","Show # of cycles"]
[null,null,"set Main!d56=Cycle1"]
[null,null,"set Main!d57=Cycle2"]

{"sheet":"Output-F","index":15,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Cycle 2 #","Contrib","1AI Yrs","2AI %","Slope","% Funded","At the End of Branch","Last Operation"]
[null,752.48,30,0.03,-1.1325237821221901E-2,1.198447095710468,"Cycle 2","Reset 2AI"]
[1,748.72,25,3.4999999999999996E-2,-1.1204828433487579E-2,1.1855842279391859,"Cycle 2 Low","Trim"]
[null,748.72,25,0.03,-1.1805561017779631E-2,1.1845226658004917,"Cycle 2","Reset 2AI"]
[2,744.97,25,3.4999999999999996E-2,-1.1685754630077838E-2,1.1717240847490162,"Cycle 2 Low","Trim"]
[null,744.97,25,0.03,-1.2283483551049291E-2,1.1706678304217206,"Cycle 2","Reset 2AI"]
[3,741.25,25,3.4999999999999996E-2,-1.2164277729577044E-2,1.1579331980685132,"Cycle 2 Low","Trim"]
[null,741.25,25,0.03,-1.2759017995964373E-2,1.1568822250304887,"Cycle 2","Reset 2AI"]
[4,737.54,25,3.4999999999999996E-2,-1.2640410514416356E-2,1.1442111995119888,"Cycle 2 Low","Trim"]
[null,737.54,25,0.03,-1.3232177055122519E-2,1.1431654813821823,"Cycle 2","Reset 2AI"]
[5,733.86,25,3.4999999999999996E-2,-1.3114152984595862E-2,1.1305580890794427,"Cycle 2 Low","Trim"]
[null,733.86,25,0.03,-1.3702960728523551E-2,1.1295175994768019,"Cycle 2","Reset 2AI"]
[6,730.19,25,3.4999999999999996E-2,-1.358553070497801E-2,1.1169731299994965,"Cycle 2 Low","Trim"]
[null,730.19,25,0.03,-1.4171394421362837E-2,1.1159378428251179,"Cycle 2","Reset 2AI"]
[7,726.53,25,3.4999999999999996E-2,-1.405455645799436E-2,1.1034559538864606,"Cycle 2 Low","Trim"]
[null,726.53,25,0.03,-1.4637490836238021E-2,1.1024258431825174,"Cycle 2","Reset 2AI"]
[8,722.9,25,3.4999999999999996E-2,-1.4521230243644956E-2,1.0900065607403309,"Cycle 2 Low","Trim"]
[null,722.9,25,0.03,-1.5101249973149145E-2,1.0889816005489954,"Cycle 2","Reset 2AI"]
[9,722.9,25,3.4999999999999996E-2,-1.4521230243644956E-2,1.0900065607403309,"Cycle 2 Low","No Boost or Trim"]

{"sheet":"Output-B","index":16,"n_rows":337,"n_cols":9,"rows_kept":337,"cut":false,"hidden":false,"merged":[]}
["Loop #","Contrib","Special Assmt","Margin1","MinEndBalMargin","1AI Yrs","2AI %","Cycle #","Last Operation"]
[1,14446.01,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[2,14301.55,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[3,14158.54,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[4,14016.95,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[5,13876.78,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[6,13738.01,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[7,13600.63,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[8,13464.63,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[9,13329.98,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[10,13196.68,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[11,13064.71,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[12,12934.07,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[13,12804.73,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[14,12676.68,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[15,12549.91,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[16,12424.41,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[17,12300.17,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[18,12177.17,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[19,12055.39,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[20,11934.84,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[21,11815.49,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[22,11697.34,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[23,11580.36,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[24,11464.56,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[25,11349.91,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[26,11236.42,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[27,11124.05,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[28,11012.81,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[29,10902.68,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[30,10793.66,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[31,10685.72,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[32,10578.86,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[33,10473.07,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[34,10368.34,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[35,10264.66,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[36,10162.01,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[37,10060.39,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[38,9959.7900000000009,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[39,9860.19,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[40,9761.59,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[41,9663.9699999999993,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[42,9567.33,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[43,9471.66,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[44,9376.94,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[45,9283.17,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[46,9190.34,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[47,9098.44,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[48,9007.4500000000007,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[49,8917.3799999999992,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[50,8828.2099999999991,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[51,8739.92,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[52,8652.5300000000007,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[53,8566,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[54,8480.34,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[55,8395.5400000000009,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[56,8311.58,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[57,8228.4699999999993,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[58,8146.18,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[59,8064.72,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[60,7984.07,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[61,7904.23,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[62,7825.19,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[63,7746.94,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[64,7669.47,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[65,7592.77,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[66,7516.84,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[67,7441.68,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[68,7367.26,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[69,7293.59,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[70,7220.65,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[71,7148.44,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[72,7076.96,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[73,7006.19,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[74,6936.13,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[75,6866.77,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[76,6798.1,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[77,6730.12,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[78,6662.82,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[79,6596.19,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[80,6530.23,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[81,6464.93,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[82,6400.28,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[83,6336.27,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[84,6272.91,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[85,6210.18,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[86,6148.08,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[87,6086.6,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[88,6025.73,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[89,5965.48,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[90,5905.82,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[91,5846.76,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[92,5788.29,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[93,5730.41,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[94,5673.11,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[95,5616.38,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[96,5560.21,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[97,5504.61,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[98,5449.56,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[99,5395.07,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[100,5341.12,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[101,5287.71,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[102,5234.83,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[103,5182.4799999999996,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[104,5130.66,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[105,5079.3500000000004,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[106,5028.5600000000004,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[107,4978.2700000000004,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[108,4928.49,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[109,4879.2,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[110,4830.41,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[111,4782.1099999999997,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[112,4734.29,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[113,4686.9399999999996,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[114,4640.07,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[115,4593.67,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[116,4547.74,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[117,4502.26,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[118,4457.24,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[119,4412.66,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[120,4368.54,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[121,4324.8500000000004,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[122,4281.6000000000004,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[123,4238.79,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[124,4196.3999999999996,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[125,4154.4399999999996,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[126,4112.8900000000003,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[127,4071.76,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[128,4031.05,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[129,3990.73,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[130,3950.83,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[131,3911.32,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[132,3872.21,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[133,3833.48,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[134,3795.15,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[135,3757.2,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[136,3719.63,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[137,3682.43,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[138,3645.6,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[139,3609.15,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[140,3573.06,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[141,3537.33,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[142,3501.95,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[143,3466.93,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[144,3432.26,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[145,3397.94,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[146,3363.96,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[147,3330.32,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[148,3297.02,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[149,3264.05,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[150,3231.41,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[151,3199.1,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[152,3167.1,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[153,3135.43,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[154,3104.08,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[155,3073.04,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[156,3042.31,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[157,3011.88,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[158,2981.77,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[159,2951.95,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[160,2922.43,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[161,2893.2,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[162,2864.27,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[163,2835.63,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[164,2807.27,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[165,2779.2,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[166,2751.41,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[167,2723.89,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[168,2696.66,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[169,2669.69,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[170,2642.99,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[171,2616.56,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[172,2590.4,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[173,2564.4899999999998,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[174,2538.85,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[175,2513.46,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[176,2488.3200000000002,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[177,2463.44,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[178,2438.81,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[179,2414.42,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[180,2390.27,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[181,2366.37,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[182,2342.71,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[183,2319.2800000000002,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[184,2296.09,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[185,2273.13,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[186,2250.4,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[187,2227.89,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[188,2205.61,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[189,2183.56,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[190,2161.7199999999998,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[191,2140.1,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[192,2118.6999999999998,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[193,2097.52,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[194,2076.54,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[195,2055.7800000000002,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[196,2035.22,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[197,2014.87,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[198,1994.72,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[199,1974.77,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[200,1955.02,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[201,1935.47,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[202,1916.12,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[203,1896.96,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[204,1877.99,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[205,1859.21,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[206,1840.61,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[207,1822.21,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[208,1803.99,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[209,1785.95,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[210,1768.09,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[211,1750.41,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[212,1732.9,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[213,1715.57,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[214,1698.42,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[215,1681.43,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[216,1664.62,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[217,1647.97,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[218,1631.49,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[219,1615.18,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[220,1599.03,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[221,1583.04,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[222,1567.21,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[223,1551.53,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[224,1536.02,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[225,1520.66,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[226,1505.45,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[227,1490.4,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[228,1475.49,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[229,1460.74,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[230,1446.13,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[231,1431.67,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[232,1417.35,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[233,1403.18,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[234,1389.15,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[235,1375.26,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[236,1361.5,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[237,1347.89,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[238,1334.41,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[239,1321.06,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[240,1307.8499999999999,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[241,1294.78,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[242,1281.83,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[243,1269.01,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[244,1256.32,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[245,1243.76,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[246,1231.32,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[247,1219.01,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[248,1206.82,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[249,1194.75,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[250,1182.8,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[251,1170.97,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[252,1159.26,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[253,1147.67,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[254,1136.19,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[255,1124.83,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[256,1113.58,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[257,1102.45,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[258,1091.42,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[259,1080.51,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[260,1069.7,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[261,1059.01,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[262,1048.42,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[263,1037.93,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[264,1027.55,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[265,1017.28,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[266,1007.1,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[267,997.03,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[268,987.06,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[269,977.19,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[270,967.42,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[271,957.75,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[272,948.17,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[273,938.69,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[274,929.3,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[275,920.01,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[276,910.81,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[277,901.7,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[278,892.68,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[279,883.75,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[280,874.92,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[281,866.17,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[282,857.51,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[283,848.93,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[284,840.44,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[285,832.04,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[286,823.72,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[287,815.48,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[288,807.33,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[289,799.25,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[290,791.26,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[291,783.35,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[292,775.51,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[293,767.76,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[294,760.08,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[295,752.48,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[296,744.96,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[297,737.51,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[298,730.13,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[299,722.83,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[300,715.6,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[301,708.44,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[302,701.36,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[303,694.35,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[304,687.4,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[305,680.53,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[306,673.72,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[307,666.99,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[308,660.32,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[309,653.71,0,true,1,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[310,647.17999999999995,0,true,0.97809776629084966,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[311,640.70000000000005,0,true,0.9447631297134198,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[312,634.29999999999995,0,true,0.91176147745143898,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[313,627.95000000000005,0,true,0.87909025985470834,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[314,621.67999999999995,0,true,0.84674539748291777,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[315,615.46,0,true,0.81472434068587229,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[316,609.29999999999995,0,true,0.78302301002326069,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[317,603.21,0,true,0.75163885584488732,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[318,597.17999999999995,0,true,0.72056881857052135,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[319,591.21,0,true,0.68980932868988509,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[320,585.29,0,true,0.65935732662274771,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[321,579.44000000000005,0,true,0.62920975278887226,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[322,573.65,0,true,0.59936405753806909,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[323,567.91,0,true,0.56981667136006098,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[324,562.23,0,true,0.5405645346746174,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[325,556.61,0,true,0.51160509783154084,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[326,551.04,0,true,0.48293530125059975,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[327,545.53,0,true,0.45455208535155722,30,3.4999999999999996E-2,"Cycle 1","Cycle1-high"]
[328,545.53,0,true,0.45455208535155722,30,3.4999999999999996E-2,"Cycle 1","Cycle1-low - Margin1 flag TRUE - Exiting Cycle 1"]
[1,548.26,0,true,0.46860195592888199,30,3.4999999999999996E-2,"Cycle 2","Cycle2-Boost - Condition met. Exiting Cycle 2"]
[1,548.26,0,true,0.46860195592888199,25,2.4999999999999994E-2,"Cycle 3","Cycle3yrs"]
[2,548.26,0,true,0.46860195592888199,30,2.4999999999999994E-2,"Cycle 3","Cycle3yrs - Post process increment"]
[3,548.26,0,true,0.46860195592888199,30,1.9999999999999993E-2,"Cycle 3","Cycle3AI"]
[4,548.26,0,true,0.46860195592888199,30,1.4999999999999993E-2,"Cycle 3","Cycle3AI"]
[5,548.26,0,true,0.46860195592888199,30,9.9999999999999915E-3,"Cycle 3","Cycle3AI"]
[6,548.26,0,true,0.46860195592888199,30,5.0000000000000001E-3,"Cycle 3","Cycle3AI"]
[7,560,0,true,0.52906798681857747,30,5.0000000000000001E-3,"Cycle 3","Final Candidate"]

{"sheet":"SA Risk","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"wksCommandBars","index":18,"n_rows":26,"n_cols":25,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Command Bar Name","Control Caption","Control Caption","Control Caption","Position","IsMenubar","Visible","Width","Protection","IsTemporary","IsEnabled","OnAction","Control ID","Control Type","Control Style","Face ID","Begin Group","Before","Tooltip","Shortcut Text","Tag","Parameter","State","ListRange","Lists"]
["Worksheet Menu Bar"]
[null,"&ARI",null,null,null,null,null,null,null,null,null,null,null,{"$f":"msoControlPopup","v":10},null,null,null,"Window"]
[null,null,"&Insert Data Table Row",null,null,null,null,null,null,null,null,"InsertDataSheetRow",1,{"$f":"msoControlButton","v":1},{"$f":"msoButtonIconAndCaption","v":3},296,null,null,null,"Ctrl+Shift+I"]
[null,null,"&Delete Data Table Row",null,null,null,null,null,null,null,null,"DeleteDataSheetRow",1,1,3,293,null,null,null,"Ctrl+Shift+D"]
[null,null,"&Remove Unused Data Rows",null,null,null,null,null,null,null,null,"RemoveUnusedDataSheetRows",1,1,3,541,null,null,null,"Ctrl+Shift+R"]
[null,null,"&Sort Data Table",null,null,null,null,null,null,null,null,"SortDataSheet",1,1,3,210,true]
[null,null,"Restore Data Table &Format",null,null,null,null,null,null,null,null,"ReformatDataInputArea",1,1,3,369]
[null,null,"&Print Analysis…",null,null,null,null,null,null,null,null,"PrintReports",1,1,3,4,true]
[null,null,"&Export Summary Report",null,null,null,null,null,null,null,null,"ExportSummaryReport",1,1,3,1950,true]
[null,null,"&Update Wizard",null,null,null,null,null,null,null,null,"UpdateWizard",1,{"$f":"msoControlButton","v":1},{"$f":"msoButtonIconAndCaption","v":3},1952]
["Stop"]
[]
["ARI Toolbar",null,null,null,{"$f":"msoBarTop","v":1},false,true,null,null,false]
[null,"Prev",null,null,null,null,null,null,null,null,null,"NavigateSheets",1,{"$f":"msoControlButton","v":1},{"$f":"msoButtonIcon","v":1},"picPrev",null,null,"Previous Sheet",null,2]
[null,"Next",null,null,null,null,null,null,null,null,null,"NavigateSheets",1,1,1,"picNext",null,null,"Next Sheet",null,1]
[null,"Insert Data Table Row",null,null,null,null,null,null,null,null,null,"InsertDataSheetRow",1,1,1,296,true,null,"Insert Data Table Row","Ctrl+Shift+I"]
[null,"Delete Data Table Row",null,null,null,null,null,null,null,null,null,"DeleteDataSheetRow",1,1,1,293,null,null,"Delete Data Table Row","Ctrl+Shift+D"]
[null,"Remove Unused Data Rows",null,null,null,null,null,null,null,null,null,"RemoveUnusedDataSheetRows",1,1,1,541,null,null,"Remove Unused Data Rows","Ctrl+Shift+R"]
[null,"Sort Data Table",null,null,null,null,null,null,null,null,null,"SortDataSheet",1,1,1,210,true,null,"Sort Data Table"]
[null,"Restore Data Table Format",null,null,null,null,null,null,null,null,null,"ReformatDataInputArea",1,1,1,369,null,null,"Restore Data Table Format"]
[null,"Print Analysis",null,null,null,null,null,null,null,null,null,"PrintReports",1,1,1,4,true,null,"Print Reports"]
[null,"Export Summary Report",null,null,null,null,null,null,null,null,null,"ExportSummaryReport",1,1,1,1950,true,null,"Export Summary Report"]
[null,"&Update Wizard",null,null,null,null,null,null,null,null,null,"UpdateWizard",1,{"$f":"msoControlButton","v":1},{"$f":"msoButtonIcon","v":1},1952,true,null,"Update Wizard"]
[null,"<< ARI Report Controls",null,null,null,null,null,null,null,null,null,"Instructions",1,1,{"$f":"msoButtonCaption","v":2},null,true,null,"Instructions",null,1]
["Stop"]