{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Costs","Cash Flow","FFB Spread"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Costs","index":0,"n_rows":87,"n_cols":14,"rows_kept":87,"cut":false,"hidden":false,"merged":[[9,3,9,4],[9,5,9,6]]}
[]
[]
[]
["Note:  The reason for this blank space is that the macro linked from the \"Spread Cost\" button requires the table row numbers to be"]
["           between 10 and 99."]
[]
[]
["Note: This workbook is based on the Information and methodology used by Association Reserves in its study submitted on September 10, 2019"]
[]
["Item","Estimated Remaining Life (RUL) as of Jan","Estimated\nEconomic\nUnit Life (UL)","Number of\nUnits*",null,"Cost/Unit\nas of",null,"Replacement\nCost","Annual Cost of Deterioration\n(Depreciation)","Fully Funded Balance\n(FFB)"]
[null,{"$f":"$M$58","v":2026},null,null,null,{"$f":"$M$58","v":2026}]
["SITE",null,null,null,null,null,null,null,null,null,null,"Update Procedure:"]
["Concrete Walkways - Replace",2,15,250,"GSF",9.5,"GSF",{"$f":"D13*F13","v":2375},{"$f":"H13/C13","v":158.33333333333334},{"$f":"H13*(C13-B13)/C13","v":2058.3333333333335},null,"You can update the values in columns"]
["Concrete Walkways - Replace",10,15,4350,"GSF",9.5,"GSF",{"$f":"D14*F14","v":41325},2755,13775,null,"B through G and re-spread the revised"]
["Concrete Parking Lot - Replace",10,40,7800,"GSF",12.7308,"GSF",{"$f":"D15*F15","v":99300.24},{"$f":"H15/C15","v":2482.5060000000003},{"$f":"H15*(C15-B15)/C15","v":74475.180000000008},null,"forecasted capital requirements on the"]
["Colonial Pkwy & Franz Perimeter Fence",2,12,5153,"LF",43.26,"LF",{"$f":"D16*F16","v":222918.78},18576.564999999999,185765.65,null,"Cash Flow spreadsheet by clicking the"]
["Mason & Franz Plaza Perimeter Fence",3,12,3028,"LF",43.26,"LF",{"$f":"D17*F17","v":130991.28},10915.94,98243.46,null,"\"Spread All\" button below. You can then"]
["Mason Creek Perimeter Fence",4,12,3172,"LF",43.26,"LF",137220.72,11435.06,91480.48,null,"see the year-by-year effect on the reserve"]
["Subdivision West Perimeter Fence",5,12,2322,"LF",43.26,"LF",{"$f":"D19*F19","v":100449.72},{"$f":"H19/C19","v":8370.81},{"$f":"H19*(C19-B19)/C19","v":58595.670000000006},null,"fund balance by looking at the graphs below"]
["Brick Columns - Repair",3,10,60,"ea",238.81054699999999,"ea",14328.632819999999,1432.8632819999998,10030.042974,null,"the table on the Cash Flow sheet. On this"]
["Parking Spaces - Restripe",3,7,1,"Lot",2089.591488,"Lot",2089.591488,298.51306971428573,1194.0522788571429,null,"sheet you can also change the financial"]
["Area Light Fixtures - Replace",13,15,7,"ea",937.29,"ea",{"$f":"D22*F22","v":6561.03},{"$f":"H22/C22","v":437.40199999999999},{"$f":"H22*(C22-B22)/C22","v":874.80399999999997},null,"parameters in in the green shaded area"]
["Area Light Poles - Replace",28,30,7,"ea",2677.97,"ea",18745.789999999997,624.85966666666661,1249.7193333333332,null,"at the top of the page."]
["Monument Signs - Refurbish",4,20,4,"ea",2089.591488,"ea",8358.3659520000001,417.91829760000002,6686.6927616000003]
[]
["Sub Total",null,null,null,null,null,null,{"$f":"SUM(H13:H24)","v":784664.15026000002},{"$f":"SUM(I13:I24)","v":57905.770649314283},{"$f":"SUM(J13:J24)","v":544429.08468112373}]
["CLUBHOUSE"]
["Surveillance System - Replace",6,10,1,"Lot",28137.720249999998,"Lot",{"$f":"D28*F28","v":28137.720249999998},{"$f":"H28/C28","v":2813.7720249999998},{"$f":"H28*(C28-B28)/C28","v":11255.088099999999}]
["Interior Lights - Replace",11,15,1,"Lot",4179.1829760000001,"Lot",4179.1829760000001,278.61219840000001,1114.4487936,null,"To calculate the monthly reserve contribution"]
["Hallway Flooring - Replace",11,15,40,"GSY",91.447520000000011,"GSY",3657.9008000000003,243.86005333333335,975.44021333333342,null,"which gives 100% funding at the start of the"]
["Indoor Carpet - Replace",6,10,180,"GSY",41.791837999999998,"GSY",7522.5308399999994,752.25308399999994,3009.0123359999998,null,"30th year, click the \"Calc Mnthly Reserve\""]
["Utility Doors - Partial Replace",1,10,15,"ea",238.81054699999999,"ea",3582.1582049999997,358.21582049999995,3223.9423844999997,null,"button below. The macro re-populates the whole"]
["Pool Gates - Repair/Replace",2,15,2,"ea",895.53937099999996,"ea",1791.0787419999999,119.40524946666666,1552.2682430666666,null,"FFB spread sheet so takes a while to process"]
["Chairs + Chair Trolleys (2021)",11,15,1,"Lot",1688.2632150000002,"ea",{"$f":"D34*F34","v":1688.2632150000002},{"$f":"H34/C34","v":112.55088100000002},{"$f":"H34*(C34-B34)/C34","v":450.20352400000007},null,"the 30 years. The required monthly contribution"]
["Tables",3,15,1,"Lot",2251.0176200000001,"Lot",2251.0176200000001,150.06784133333335,1800.8140959999998,null,"will be shown in the yellow box below the button."]
["Kitchen - Refurbish",16,20,1,"Lot",9552.4183780000003,"Lot",9552.4183780000003,477.62091889999999,1910.4836756]
["Restrooms - Refurbish",5,20,2,"ea",7761.3399450000006,"Lot",15522.679890000001,776.13399450000009,11642.009917500001]
["Interior Surfaces - Repaint",1,10,4100,"GSF",1.27308,"GSF",5219.6279999999997,521.96280000000002,4697.6651999999995]
["Building Exteriors - Paint/Repair",1,10,5350,"GSF",1.6717930000000001,"GSF",8944.0925500000012,894.40925500000014,8049.6832950000007]
["Windows - Replace",34,40,12,"ea",597.0261099999999,"ea",7164.3133199999993,179.10783299999997,1074.6469979999997,null,null,{"$f":"'Cash Flow'!B81/12","v":8717.7805120484536},"Per Month"]
["Fiber Cement Siding - Replace",14,40,3350,"GSF",8.9673860000000012,"GSF",30040.743100000003,751.01857750000011,19526.483015000002]
["Asphalt Shingle Roof - Replace",10,25,4450,"GSF",4.7762130000000003,"GSF",21254.147850000001,850.16591400000004,12752.48871,null,"To add or delete a component row click below:"]
["Gutters/Downspouts - Replace",10,25,164,"LF",25.481170000000002,"LF",4178.9118800000006,167.15647520000002,2507.3471280000003]
[]
["Sub Total",null,null,null,null,null,null,{"$f":"SUM(H28:H43)","v":154686.78761600002},{"$f":"SUM(I28:I43)","v":9446.3129211333326},{"$f":"SUM(J28:J43)","v":85542.025629600001}]
["POOL/PARK/TENNIS"]
["Shade Awnings - Replace Screens",6,10,1140,"GSF",4.7271850000000004,"GSF",{"$f":"D47*F47","v":5388.9909000000007},{"$f":"H47/C47","v":538.89909000000011},{"$f":"H47*(C47-B47)/C47","v":2155.5963600000005}]
["Play Equipment - Replace",4,18,1,"Lot",59702.614810999999,"Lot",59702.614810999999,3316.8119339444443,46435.367075222224,null,"To set up this spreadsheet for the next year :"]
["Playground Awnings - Replace Screens",5,10,{"$f":"(27*33+26*37)","v":1853},"GSF",7.8090479999999998,"GSF",{"$f":"D49*F49","v":14470.165944},{"$f":"H49/C49","v":1447.0165944},{"$f":"H49*(C49-B49)/C49","v":7235.0829720000011},null,"click on the button below and follow the prompts"]
["Park Furniture - Replace",8,10,1,"Lot",5304.5,"Lot",5304.5,530.45000000000005,1060.9000000000001]
["Drinking Fountains - Replace",1,20,1,"Lot",2388.1045429999999,"Lot",2388.1045429999999,119.40522715,2268.6993158499999]
["Trash Area Wood Fence - Replace",1,20,30,"LF",43.26,"LF",1297.8,64.89,1232.9100000000001]
["Pool Perimeter Fence - Powder Coat",1,15,560,"LF",40.514226000000001,"LF",22687.966560000001,1512.5311040000001,21175.435455999999]
["Pool Deck - Repair/Replace",10,15,7520,"GSF",12.7308,"GSF",95735.616000000009,6382.3744000000006,31911.872000000007,null,"You can also perform the update manually"]
["Pool Deck - Replace Bad section",2,15,600,"GSF",12.7308,"GSF",{"$f":"D55*F55","v":7638.4800000000005},{"$f":"H55/C55","v":509.23200000000003},{"$f":"H55*(C55-B55)/C55","v":6620.0160000000005},null,"by entering the year and prior year reserve "]
["Pool - Replaster",5,10,1,"Lot",54667.887467,"Lot",54667.887467,5466.7887467,27333.943733500004,null,"total in the green shaded cells below:"]
["Kiddie Pool - Replaster",3,10,1,"Lot",3940.3726350000002,"Lot",3940.3726350000002,394.03726349999999,2758.2608445000001]
["Baby Pool Filter (2016) - Replace",5,15,1,"ea",1373.160259,"ea",1373.160259,91.544017266666671,915.44017266666674,null,"YEAR",2026]
["Main Pool Filters - Replace",4,15,3,"ea",1791.0784330000001,"ea",5373.2352989999999,358.21568659999997,3940.3725525999998]
["Pool Filter Sand",3,4,4,"ea",537.32349900000008,"ea",2149.2939960000003,537.32349900000008,537.32349900000008,null,"then adjust figures in columns B, C and F and"]
["Baby Pool Pump - Replace",3,5,1,"ea",669.5,"ea",{"$f":"D61*F61","v":669.5},{"$f":"H61/C61","v":133.9},{"$f":"H61*(C61-B61)/C61","v":267.8},null,"enter the prior year's Dec 31 Reserve Total:"]
["Main Pool Pump - Replace",3,5,1,"ea",1545,"ea",1545,309,618]
["Diving Board - Replace",10,15,1,"ea",14490.925902999999,"ea",{"$f":"D63*F63","v":14490.925902999999},{"$f":"H63/C63","v":966.06172686666662},{"$f":"H63*(C63-B63)/C63","v":4830.3086343333325},null,"2019-12-31",909994,{"$f":"M58-1","v":2025}]
["Lifeguard Stands - Replace",13,15,2,"ea",6365.4000000000005,"ea",12730.800000000001,848.72,1697.44]
["Pool Coping - Replace",5,20,350,"LF",23.964701000000002,"LF",8387.6453500000007,419.38226750000001,6290.7340125000001]
["Pool Perimeter Fence - Replace",11,30,560,"LF",59.702714,"LF",33433.519840000001,1114.4506613333333,21174.562565333334]
["Pool Furniture - Replace (66 items)",2,8,1,"Lot",19104.836756000001,"Lot",19104.836756000001,2388.1045945000001,14328.627567]
["Tennis Courts - Resurface (26,000 GSF)",3,7,1,"Lot",27012.211440000003,"Lot",27012.211440000003,3858.8873485714289,15435.549394285716]
["Tennis Court Light Fixtures - Replace",13,15,24,"ea",937.29,"ea",22494.959999999999,1499.664,2999.328]
["Tennis Court Light Poles - Replace",28,30,12,"ea",2677.97,"ea",32135.64,1071.1879999999999,2142.3759999999997]
["Tennis Chain Link Fence - Replace",13,30,990,"LF",33.170841000000003,"LF",32839.132590000001,1094.637753,18608.841801000002]
["Basketball Court - Replace",5,40,3200,"GSF",12.7308,"GSF",40738.559999999998,1018.4639999999999,35646.239999999998]
["Basketball Hoop - Replace",8,10,1,"ea",1273.08,"ea",1273.08,127.30799999999999,254.61599999999999]
[]
["Sub Total",null,null,null,null,null,null,{"$f":"SUM(H47:H73)","v":528974.00029300002},{"$f":"SUM(I47:I73)","v":36119.287914332541},{"$f":"SUM(J47:J73)","v":279875.64395579125}]
["HVAC"]
["HVAC Unit (A) 4Ton- Replace ",9,15,1,"ea",7761.3399450000006,"ea",{"$f":"D77*F77","v":7761.3399450000006},{"$f":"H77/C77","v":517.42266300000006},{"$f":"H77*(C77-B77)/C77","v":3104.5359780000003}]
["HVAC Unit (B) 4Ton- Replace ",9,15,1,"ea",7761.3399450000006,"ea",7761.3399450000006,{"$f":"H78/C78","v":517.42266300000006},{"$f":"H78*(C78-B78)/C78","v":3104.5359780000003}]
["HVAC Unit (C) 3Ton- Replace ",6,15,1,"ea",6567.2877250000001,"ea",5500,{"$f":"H79/C79","v":366.66666666666669},{"$f":"H79*(C79-B79)/C79","v":3300}]
[]
["Sub Total",null,null,null,null,null,null,{"$f":"SUM(H77:H79)","v":21022.679889999999},{"$f":"SUM(I77:I79)","v":1401.5119926666669},{"$f":"SUM(J77:J79)","v":9509.0719559999998}]
[]
["Grand Total","BOT",null,null,null,null,null,{"$f":"SUM(H13:H81)/2","v":1489347.6180590005},{"$f":"SUM(I13:I81)/2","v":104872.88347744683},919355.82622251508]
[]
[null,null,null,null,null,null,null,null,"Total Required on Deposit:",{"$f":"J83","v":919355.82622251508}]
[null,null,null,null,null,null,null,null,"Prior year December 31 Reserve Total",{"$f":"M63","v":909994}]
[null,null,null,null,null,null,null,null,"Percent Funded",{"$f":"J86/J85","v":0.98981697188891349}]

{"sheet":"Cash Flow","index":1,"n_rows":84,"n_cols":31,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
["$B$79",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESERVE STUDY -",{"$f":"Costs!$M$58","v":2026}]
["PARAMETERS",null,null,null,null,null,null,null,null,null,null,null,null,null,"30 YEAR CASH FLOW"]
["Number of homes",763,null,"Notes:"]
["Starting reserve fund balance",{"$f":"Costs!M63","v":909994},null,"Values in shaded area to the left",null,null,null,"To recalculate to monthly contribution required"]
["Reserve fund earnings rate",0.03,null,"can be adjusted, and the effect ",null,null,null,"for full funding following a change to any of the",null,null,null,null,null,"Link to"]
["Monthly per resident reserve fee",11.425662532173595,null,"on the 30 year cash flow observed",null,null,null,"parameters in the green shaded area, cilck below:",null,null,null,null,null,"US Inflation Forecast"]
["Reserve fee escalation rate",{"$f":"B8","v":0.03},null,"on the graph below."]
["Inflation rate",0.03]
[15]
[{"$f":"MID(A1,2,1)","v":"B"}]
[{"$f":"SUBSTITUTE(A1,\"$B$\",\"A\")","v":"A79"}]
[{"$f":"RIGHT(A11,2)","v":"79"},{"$f":"Costs!$M$58","v":2026},{"$f":"B12+1","v":2027},{"$f":"C12+1","v":2028},2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,{"$f":"U12+1","v":2046},2047,2048,2049,2050,2051,2052,2053,2054,2055]
[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]
[{"$f":"Costs!A13","v":"Concrete Walkways - Replace"},null,null,{"$f":"Costs!H13","v":2375},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H13","v":2375}]
[{"$f":"Costs!A14","v":"Concrete Walkways - Replace"},null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H14","v":41325},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H14","v":41325}]
[{"$f":"Costs!A15","v":"Concrete Parking Lot - Replace"},null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H15","v":99300.24}]
[{"$f":"Costs!A16","v":"Colonial Pkwy & Franz Perimeter Fence"},null,null,{"$f":"Costs!H16","v":222918.78},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H16","v":222918.78},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H16","v":222918.78}]
[{"$f":"Costs!A17","v":"Mason & Franz Plaza Perimeter Fence"},null,null,null,{"$f":"Costs!H17","v":130991.28},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H17","v":130991.28},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H17","v":130991.28}]
[{"$f":"Costs!A18","v":"Mason Creek Perimeter Fence"},null,null,null,null,{"$f":"Costs!H18","v":137220.72},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H18","v":137220.72},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H18","v":137220.72}]
[{"$f":"Costs!A19","v":"Subdivision West Perimeter Fence"},null,null,null,null,null,{"$f":"Costs!H19","v":100449.72},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H19","v":100449.72},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H19","v":100449.72}]
[{"$f":"Costs!A20","v":"Brick Columns - Repair"},null,null,null,{"$f":"Costs!H20","v":14328.632819999999},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H20","v":14328.632819999999},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H20","v":14328.632819999999}]
[{"$f":"Costs!A21","v":"Parking Spaces - Restripe"},null,null,null,{"$f":"Costs!H21","v":2089.591488},null,null,null,null,null,null,{"$f":"Costs!H21","v":2089.591488},null,null,null,null,null,null,{"$f":"Costs!H21","v":2089.591488},null,null,null,null,null,null,{"$f":"Costs!H21","v":2089.591488}]
[{"$f":"Costs!A22","v":"Area Light Fixtures - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H22","v":6561.03},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H22","v":6561.03}]
[{"$f":"Costs!A23","v":"Area Light Poles - Replace"},null,null,null,null,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":"Costs!H23","v":18745.789999999997}]
[{"$f":"Costs!A24","v":"Monument Signs - Refurbish"},null,null,null,null,{"$f":"Costs!H24","v":8358.3659520000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H24","v":8358.3659520000001}]
[{"$f":"Costs!A25","v":0}]
[{"$f":"Costs!A28","v":"Surveillance System - Replace"},null,null,null,null,null,null,{"$f":"Costs!H28","v":28137.720249999998},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H28","v":28137.720249999998},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H28","v":28137.720249999998}]
[{"$f":"Costs!A29","v":"Interior Lights - Replace"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H29","v":4179.1829760000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H29","v":4179.1829760000001}]
[{"$f":"Costs!A30","v":"Hallway Flooring - Replace"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H30","v":3657.9008000000003},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H30","v":3657.9008000000003}]
[{"$f":"Costs!A31","v":"Indoor Carpet - Replace"},null,null,null,null,null,null,{"$f":"Costs!H31","v":7522.5308399999994},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H31","v":7522.5308399999994},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H31","v":7522.5308399999994}]
[{"$f":"Costs!A32","v":"Utility Doors - Partial Replace"},null,{"$f":"Costs!H32","v":3582.1582049999997},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H32","v":3582.1582049999997},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H32","v":3582.1582049999997}]
[{"$f":"Costs!A33","v":"Pool Gates - Repair/Replace"},null,null,{"$f":"Costs!H33","v":1791.0787419999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H33","v":1791.0787419999999}]
[{"$f":"Costs!A34","v":"Chairs + Chair Trolleys (2021)"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H34","v":1688.2632150000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H34","v":1688.2632150000002}]
[{"$f":"Costs!A35","v":"Tables"},null,null,null,{"$f":"Costs!H35","v":2251.0176200000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H35","v":2251.0176200000001}]
[{"$f":"Costs!A36","v":"Kitchen - Refurbish"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H36","v":9552.4183780000003}]
[{"$f":"Costs!A37","v":"Restrooms - Refurbish"},null,null,null,null,null,{"$f":"Costs!H37","v":15522.679890000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H37","v":15522.679890000001}]
[{"$f":"Costs!A38","v":"Interior Surfaces - Repaint"},null,{"$f":"Costs!H38","v":5219.6279999999997},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H38","v":5219.6279999999997},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H38","v":5219.6279999999997}]
[{"$f":"Costs!A39","v":"Building Exteriors - Paint/Repair"},null,{"$f":"Costs!H39","v":8944.0925500000012},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H39","v":8944.0925500000012},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H39","v":8944.0925500000012}]
[{"$f":"Costs!A40","v":"Windows - Replace"}]
[{"$f":"Costs!A41","v":"Fiber Cement Siding - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H41","v":30040.743100000003}]
[{"$f":"Costs!A42","v":"Asphalt Shingle Roof - Replace"},null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H42","v":21254.147850000001}]
[{"$f":"Costs!A43","v":"Gutters/Downspouts - Replace"},null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H43","v":4178.9118800000006}]
[{"$f":"Costs!A44","v":0}]
[{"$f":"Costs!A47","v":"Shade Awnings - Replace Screens"},null,null,null,null,null,null,{"$f":"Costs!H47","v":5388.9909000000007},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H47","v":5388.9909000000007},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H47","v":5388.9909000000007}]
[{"$f":"Costs!A48","v":"Play Equipment - Replace"},null,null,null,null,{"$f":"Costs!H48","v":59702.614810999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H48","v":59702.614810999999}]
[{"$f":"Costs!A49","v":"Playground Awnings - Replace Screens"},null,null,null,null,null,{"$f":"Costs!H49","v":14470.165944},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H49","v":14470.165944},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H49","v":14470.165944}]
[{"$f":"Costs!A50","v":"Park Furniture - Replace"},null,null,null,null,null,null,null,null,{"$f":"Costs!H50","v":5304.5},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H50","v":5304.5},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H50","v":5304.5}]
[{"$f":"Costs!A51","v":"Drinking Fountains - Replace"},null,{"$f":"Costs!H51","v":2388.1045429999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H51","v":2388.1045429999999}]
[{"$f":"Costs!A52","v":"Trash Area Wood Fence - Replace"},null,{"$f":"Costs!H52","v":1297.8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H52","v":1297.8}]
[{"$f":"Costs!A53","v":"Pool Perimeter Fence - Powder Coat"},null,{"$f":"Costs!H53","v":22687.966560000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H53","v":22687.966560000001}]
[{"$f":"Costs!A54","v":"Pool Deck - Repair/Replace"},null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H54","v":95735.616000000009},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H54","v":95735.616000000009}]
[{"$f":"Costs!A55","v":"Pool Deck - Replace Bad section"},null,null,{"$f":"Costs!H55","v":7638.4800000000005},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H55","v":7638.4800000000005}]
[{"$f":"Costs!A56","v":"Pool - Replaster"},null,null,null,null,null,{"$f":"Costs!H56","v":54667.887467},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H56","v":54667.887467},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H56","v":54667.887467}]
[{"$f":"Costs!A57","v":"Kiddie Pool - Replaster"},null,null,null,{"$f":"Costs!H57","v":3940.3726350000002},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H57","v":3940.3726350000002},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H57","v":3940.3726350000002}]
[{"$f":"Costs!A58","v":"Baby Pool Filter (2016) - Replace"},null,null,null,null,null,{"$f":"Costs!H58","v":1373.160259},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H58","v":1373.160259}]
[{"$f":"Costs!A59","v":"Main Pool Filters - Replace"},null,null,null,null,{"$f":"Costs!H59","v":5373.2352989999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H59","v":5373.2352989999999}]
[{"$f":"Costs!A60","v":"Pool Filter Sand"},null,null,null,{"$f":"Costs!H60","v":2149.2939960000003},null,null,null,{"$f":"Costs!H60","v":2149.2939960000003},null,null,null,{"$f":"Costs!H60","v":2149.2939960000003},null,null,null,{"$f":"Costs!H60","v":2149.2939960000003},null,null,null,{"$f":"Costs!H60","v":2149.2939960000003},null,null,null,{"$f":"Costs!H60","v":2149.2939960000003},null,null,null,{"$f":"Costs!H60","v":2149.2939960000003}]
[{"$f":"Costs!A61","v":"Baby Pool Pump - Replace"},null,null,null,{"$f":"Costs!H61","v":669.5},null,null,null,null,{"$f":"Costs!H61","v":669.5},null,null,null,null,{"$f":"Costs!H61","v":669.5},null,null,null,null,{"$f":"Costs!H61","v":669.5},null,null,null,null,{"$f":"Costs!H61","v":669.5},null,null,null,null,{"$f":"Costs!H61","v":669.5}]
[{"$f":"Costs!A62","v":"Main Pool Pump - Replace"},null,null,null,{"$f":"Costs!H62","v":1545},null,null,null,null,{"$f":"Costs!H62","v":1545},null,null,null,null,{"$f":"Costs!H62","v":1545},null,null,null,null,{"$f":"Costs!H62","v":1545},null,null,null,null,{"$f":"Costs!H62","v":1545},null,null,null,null,{"$f":"Costs!H62","v":1545}]
[{"$f":"Costs!A63","v":"Diving Board - Replace"},null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H63","v":14490.925902999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H63","v":14490.925902999999}]
[{"$f":"Costs!A64","v":"Lifeguard Stands - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H64","v":12730.800000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H64","v":12730.800000000001}]
[{"$f":"Costs!A65","v":"Pool Coping - Replace"},null,null,null,null,null,{"$f":"Costs!H65","v":8387.6453500000007},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H65","v":8387.6453500000007}]
[{"$f":"Costs!A66","v":"Pool Perimeter Fence - Replace"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H66","v":33433.519840000001}]
[{"$f":"Costs!A67","v":"Pool Furniture - Replace (66 items)"},null,null,{"$f":"Costs!H67","v":19104.836756000001},null,null,null,null,null,null,null,{"$f":"Costs!H67","v":19104.836756000001},null,null,null,null,null,null,null,{"$f":"Costs!H67","v":19104.836756000001},null,null,null,null,null,null,null,{"$f":"Costs!H67","v":19104.836756000001}]
[{"$f":"Costs!A68","v":"Tennis Courts - Resurface (26,000 GSF)"},null,null,null,{"$f":"Costs!H68","v":27012.211440000003},null,null,null,null,null,null,{"$f":"Costs!H68","v":27012.211440000003},null,null,null,null,null,null,{"$f":"Costs!H68","v":27012.211440000003},null,null,null,null,null,null,{"$f":"Costs!H68","v":27012.211440000003}]
[{"$f":"Costs!A69","v":"Tennis Court Light Fixtures - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H69","v":22494.959999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H69","v":22494.959999999999}]
[{"$f":"Costs!A70","v":"Tennis Court Light Poles - Replace"},null,null,null,null,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":"Costs!H70","v":32135.64}]
[{"$f":"Costs!A71","v":"Tennis Chain Link Fence - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H71","v":32839.132590000001}]
[{"$f":"Costs!A72","v":"Basketball Court - Replace"},null,null,null,null,null,{"$f":"Costs!H72","v":40738.559999999998}]
[{"$f":"Costs!A73","v":"Basketball Hoop - Replace"},null,null,null,null,null,null,null,null,{"$f":"Costs!H73","v":1273.08},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H73","v":1273.08},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H73","v":1273.08}]
[{"$f":"Costs!A74","v":0}]
[{"$f":"Costs!A77","v":"HVAC Unit (A) 4Ton- Replace "},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H77","v":7761.3399450000006},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H77","v":7761.3399450000006}]
[{"$f":"Costs!A78","v":"HVAC Unit (B) 4Ton- Replace "},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H78","v":7761.3399450000006},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H78","v":7761.3399450000006}]
[{"$f":"Costs!A79","v":"HVAC Unit (C) 3Ton- Replace "},null,null,null,null,null,null,{"$f":"Costs!H79","v":5500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H79","v":5500}]
[{"$f":"Costs!A80","v":0}]
["Total Cost",{"$f":"SUM(B14:B74)","v":0},44119.749858000003,253828.17549800003,184976.89999900002,210654.93606199999,235609.81891,46549.241989999995,2149.2939960000003,8792.08,15522.679890000001,324491.481317,62854.039581999998,0,95109.428045000008,252959.52309999999,202278.62740699999,210510.34692799998,141356.08167000001,30147.934376000005,7522.5292950000003,1373.160259,26931.783298000002,59702.614810999999,22632.799450999999,52982.848770000004,244599.92055400001,292598.20573699998,133140.57399599999,238681.02,100449.72]
["Total Cost Adjusted for Inflation",{"$f":"B76*(1+$B$8)^B13","v":0},45443.342353740001,269286.31138582824,202129.25300520728,237093.98640776769,273136.35471288086,55582.229299843646,2643.3605147949856,11137.54389716643,20253.576461637487,436089.41669955337,87004.690501259363,0,139671.40155117819,382623.97544530907,315143.51057483238,337807.30921228114,233640.06489547173,51324.840209793401,13190.800653232312,2480.0801707814612,50101.050275725858,114396.38375725922,44667.787705527204,107703.22272313875,512137.91525113932,631014.73539141018,295743.69321261451,546084.91133119853,236716.34524030032]
[]
[]
["Start of year reserve fund Balance",{"$f":"B4","v":909994},{"$f":"B84","v":1043876.6622587463},{"$f":"C84","v":1138883.1797978575},1012813.9570085795,954468.76466729259,862334.04112409032,734392.46900195256,827115.71298067074,980207.59062206966,1133251.0791504825,1285730.9566438631,1024845.9694008757,1114701.4067363634,1300028.0878157483,1353738.7951583937,1167114.71256507,1048140.2933179012,907502.57034932869,873451.4368585255,1028718.6632156343,{"$f":"U84","v":1232846.644619154},1459643.8805466616,1650748.6873182647,1788320.1339514309,2006969.9288316758,2174564.1925326865,1943147.4152332374,1590678.2270328542,1574729.3676852863,1311224.3214633181]
["Annual Fee Revenue",{"$f":"$B$3*$B$6*12","v":104613.36614458144},{"$f":"B81*(1+$B$7)","v":107751.76712891889},110984.32014278646,114313.84974707005,117743.26523948216,121275.56319666663,124913.83009256663,128661.24499534363,132521.08234520393,136496.71481556006,140591.61626002687,{"$f":"L81*(1+$B$7)","v":144809.36474782767},{"$f":"M81*(1+$B$7)","v":149153.64569026249},{"$f":"N81*(1+$B$7)","v":153628.25506097038},{"$f":"O81*(1+$B$7)","v":158237.1027127995},{"$f":"P81*(1+$B$7)","v":162984.21579418349},{"$f":"Q81*(1+$B$7)","v":167873.74226800899},{"$f":"R81*(1+$B$7)","v":172909.95453604928},{"$f":"S81*(1+$B$7)","v":178097.25317213076},{"$f":"T81*(1+$B$7)","v":183440.17076729468},{"$f":"U81*(1+$B$7)","v":188943.37589031353},{"$f":"V81*(1+$B$7)","v":194611.67716702295},{"$f":"W81*(1+$B$7)","v":200450.02748203365},{"$f":"X81*(1+$B$7)","v":206463.52830649467},{"$f":"Y81*(1+$B$7)","v":212657.43415568952},{"$f":"Z81*(1+$B$7)","v":219037.15718036023},{"$f":"AA81*(1+$B$7)","v":225608.27189577103},{"$f":"AB81*(1+$B$7)","v":232376.52005264416},{"$f":"AC81*(1+$B$7)","v":239347.81565422349},{"$f":"AD81*(1+$B$7)","v":246528.25012385022}]
["Investment earnings",{"$f":"(B80+(B80+B81-B83))/2*((1+$B$5/12)^12-1)","v":29269.296114164896},32698.092763932411,32232.768453763838,29470.210916850359,27215.99762508311,23919.219394076379,23391.643185995177,27073.993160850307,31659.950080375365,36236.739139457939,34612.813196539217,32050.763088919535,36173.03538912232,39753.853832853332,37762.790139185963,33184.875533480073,29295.843975699849,26678.976868619444,28494.813394771332,33878.611289457469,40333.940207975415,46594.179880305805,51517.802908391641,56854.054279277283,62640.052268459702,61683.980771330273,52937.275295255888,47418.31381240239,43232.049455006847,40031.361703659131]
["Capital expenditures",{"$f":"B77","v":0},{"$f":"C77","v":45443.342353740001},{"$f":"D77","v":269286.31138582824},202129.25300520728,237093.98640776769,273136.35471288086,55582.229299843646,2643.3605147949856,11137.54389716643,20253.576461637487,436089.41669955337,87004.690501259363,0,139671.40155117819,382623.97544530907,315143.51057483238,337807.30921228114,233640.06489547173,51324.840209793401,13190.800653232312,{"$f":"V77","v":2480.0801707814612},50101.050275725858,114396.38375725922,44667.787705527204,107703.22272313875,512137.91525113932,631014.73539141018,295743.69321261451,546084.91133119853,236716.34524030032]
["End of year reserve fund Balance",{"$f":"B80+B81+B82-B83","v":1043876.6622587463},{"$f":"C80+C81+C82-C83","v":1138883.1797978575},1012813.9570085795,954468.76466729259,862334.04112409032,734392.46900195256,827115.71298067074,980207.59062206966,1133251.0791504825,1285730.9566438631,1024845.9694008757,1114701.4067363634,1300028.0878157483,1353738.7951583937,1167114.71256507,1048140.2933179012,907502.57034932869,873451.4368585255,1028718.6632156343,1232846.644619154,{"$f":"V80+V81+V82-V83","v":1459643.8805466616},1650748.6873182647,1788320.1339514309,2006969.9288316758,2174564.1925326865,1943147.4152332374,1590678.2270328542,1574729.3676852863,1311224.3214633181,1361067.5880505273]

{"sheet":"FFB Spread","index":2,"n_rows":80,"n_cols":31,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
["$B$79",null,null,null,null,null,null,null,null,null,null,null,null,null,"RESERVE STUDY -",null,null,{"$f":"Costs!$M$58","v":2026}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," 30 YEAR ANNUAL FFBs"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,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":"$AE$78","v":1316362.5328140368}]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1316362.5328140368]
[{"$f":"MID(A1,2,1)","v":"B"}]
[{"$f":"SUBSTITUTE(A1,\"$B$\",\"A\")","v":"A79"}]
[{"$f":"RIGHT(A11,2)","v":"79"},{"$f":"Costs!$M$58","v":2026},{"$f":"B12+1","v":2027},2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055]
[2933.3333333333335,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]
[{"$f":"Costs!A13","v":"Concrete Walkways - Replace"},2058.3333333333335,2216.6666666666665,2375,158.33333333333334,316.66666666666669,475,633.33333333333337,791.66666666666663,950,1108.3333333333333,1266.6666666666667,1425,1583.3333333333333,1741.6666666666667,1900,2058.3333333333335,2216.6666666666665,2375,158.33333333333334,316.66666666666669,475,633.33333333333337,791.66666666666663,950,1108.3333333333333,1266.6666666666667,1425,1583.3333333333333,1741.6666666666667,1900]
[{"$f":"Costs!A14","v":"Concrete Walkways - Replace"},13775,16530,19285,22040,24795,27550,30305,33060,35815,38570,41325,2755,5510,8265,11020,13775,16530,19285,22040,24795,27550,30305,33060,35815,38570,41325,2755,5510,8265,11020]
[{"$f":"Costs!A15","v":"Concrete Parking Lot - Replace"},74475.180000000008,76957.686000000002,79440.19200000001,81922.698000000004,84405.203999999998,86887.71,89370.216,91852.722000000009,94335.228000000003,96817.734000000011,99300.24,2482.5060000000003,4965.0120000000006,7447.5180000000009,9930.0240000000013,12412.53,14895.036000000002,17377.542000000001,19860.048000000003,22342.554,24825.06,27307.566000000003,29790.072000000004,32272.578000000001,34755.084000000003,37237.590000000004,39720.096000000005,42202.601999999999,44685.108,47167.614000000001]
[{"$f":"Costs!A16","v":"Colonial Pkwy & Franz Perimeter Fence"},185765.65,204342.215,222918.78,18576.564999999999,37153.129999999997,55729.695,74306.259999999995,92882.824999999997,111459.39,130035.955,148612.51999999999,167189.08499999999,185765.65,204342.215,222918.78,18576.564999999999,37153.129999999997,55729.695,74306.259999999995,92882.824999999997,111459.39,130035.955,148612.51999999999,167189.08499999999,185765.65,204342.215,222918.78,18576.564999999999,37153.129999999997,55729.695]
[{"$f":"Costs!A17","v":"Mason & Franz Plaza Perimeter Fence"},98243.46,109159.40000000001,120075.34000000001,130991.27999999998,10915.94,21831.88,32747.819999999996,43663.76,54579.700000000004,65495.639999999992,76411.58,87327.52,98243.46,109159.40000000001,120075.34000000001,130991.27999999998,10915.94,21831.88,32747.819999999996,43663.76,54579.700000000004,65495.639999999992,76411.58,87327.52,98243.46,109159.40000000001,120075.34000000001,130991.27999999998,10915.94,21831.88]
[{"$f":"Costs!A18","v":"Mason Creek Perimeter Fence"},91480.48,102915.54,114350.59999999999,125785.65999999999,137220.72,11435.06,22870.12,34305.18,45740.24,57175.299999999996,68610.36,80045.42,91480.48,102915.54,114350.59999999999,125785.65999999999,137220.72,11435.06,22870.12,34305.18,45740.24,57175.299999999996,68610.36,80045.42,91480.48,102915.54,114350.59999999999,125785.65999999999,137220.72,11435.06]
[{"$f":"Costs!A19","v":"Subdivision West Perimeter Fence"},58595.670000000006,66966.48,75337.289999999994,83708.099999999991,92078.909999999989,100449.72000000002,8370.81,16741.62,25112.430000000004,33483.24,41854.049999999996,50224.860000000008,58595.670000000006,66966.48,75337.289999999994,83708.099999999991,92078.909999999989,100449.72000000002,8370.81,16741.62,25112.430000000004,33483.24,41854.049999999996,50224.860000000008,58595.670000000006,66966.48,75337.289999999994,83708.099999999991,92078.909999999989,100449.72000000002]
[{"$f":"Costs!A20","v":"Brick Columns - Repair"},10030.042974,11462.906255999998,12895.769537999999,14328.632819999999,1432.8632819999998,2865.7265639999996,4298.5898459999999,5731.4531279999992,7164.3164099999995,8597.1796919999997,10030.042974,11462.906255999998,12895.769537999999,14328.632819999999,1432.8632819999998,2865.7265639999996,4298.5898459999999,5731.4531279999992,7164.3164099999995,8597.1796919999997,10030.042974,11462.906255999998,12895.769537999999,14328.632819999999,1432.8632819999998,2865.7265639999996,4298.5898459999999,5731.4531279999992,7164.3164099999995,8597.1796919999997]
[{"$f":"Costs!A21","v":"Parking Spaces - Restripe"},1194.0522788571429,1492.5653485714286,1791.0784182857144,2089.591488,298.51306971428573,597.02613942857147,895.5392091428572,1194.0522788571429,1492.5653485714286,1791.0784182857144,2089.591488,298.51306971428573,597.02613942857147,895.5392091428572,1194.0522788571429,1492.5653485714286,1791.0784182857144,2089.591488,298.51306971428573,597.02613942857147,895.5392091428572,1194.0522788571429,1492.5653485714286,1791.0784182857144,2089.591488,298.51306971428573,597.02613942857147,895.5392091428572,1194.0522788571429,1492.5653485714286]
[{"$f":"Costs!A22","v":"Area Light Fixtures - Replace"},874.80399999999997,1312.2059999999999,1749.6079999999999,2187.0100000000002,2624.4119999999998,3061.8139999999999,3499.2159999999999,3936.6179999999999,4374.0200000000004,4811.4220000000005,5248.8239999999996,5686.2259999999997,6123.6279999999997,6561.03,437.40199999999999,874.80399999999997,1312.2059999999999,1749.6079999999999,2187.0100000000002,2624.4119999999998,3061.8139999999999,3499.2159999999999,3936.6179999999999,4374.0200000000004,4811.4220000000005,5248.8239999999996,5686.2259999999997,6123.6279999999997,6561.03,437.40199999999999]
[{"$f":"Costs!A23","v":"Area Light Poles - Replace"},1249.7193333333332,1874.579,2499.4386666666664,3124.2983333333327,3749.1579999999999,4374.0176666666657,4998.8773333333329,5623.7369999999992,6248.5966666666654,6873.4563333333326,7498.3159999999998,8123.1756666666652,8748.0353333333314,9372.8949999999986,9997.7546666666658,10622.614333333331,11247.473999999998,11872.333666666666,12497.193333333331,13122.052999999998,13746.912666666665,14371.772333333331,14996.632,15621.491666666665,16246.35133333333,16871.210999999996,17496.070666666663,18120.93033333333,18745.789999999997,624.85966666666661]
[{"$f":"Costs!A24","v":"Monument Signs - Refurbish"},6686.6927616000003,7104.6110591999995,7522.5293567999997,7940.4476544000008,8358.3659520000001,417.91829760000002,835.83659520000003,1253.7548928000001,1671.6731904000001,2089.591488,2507.5097856000002,2925.4280831999999,3343.3463808000001,3761.2646783999999,4179.1829760000001,4597.1012736000002,5015.0195712000004,5432.9378687999997,5850.8561663999999,6268.7744640000001,6686.6927616000003,7104.6110591999995,7522.5293567999997,7940.4476544000008,8358.3659520000001,417.91829760000002,835.83659520000003,1253.7548928000001,1671.6731904000001,2089.591488]
[{"$f":"Costs!A25","v":0}]
[{"$f":"Costs!A28","v":"Surveillance System - Replace"},11255.088099999999,14068.860125000001,16882.632149999998,19696.404174999996,22510.176199999998,25323.948225,28137.720250000002,2813.7720249999998,5627.5440499999995,8441.3160749999988,11255.088099999999,14068.860125000001,16882.632149999998,19696.404174999996,22510.176199999998,25323.948225,28137.720250000002,2813.7720249999998,5627.5440499999995,8441.3160749999988,11255.088099999999,14068.860125000001,16882.632149999998,19696.404174999996,22510.176199999998,25323.948225,28137.720250000002,2813.7720249999998,5627.5440499999995,8441.3160749999988]
[{"$f":"Costs!A29","v":"Interior Lights - Replace"},1114.4487936,1393.0609919999999,1671.6731904000001,1950.2853888,2228.8975872000001,2507.5097855999998,2786.1219839999999,3064.7341824000005,3343.3463808000001,3621.9585791999998,3900.5707775999999,4179.1829760000001,278.61219840000001,557.22439680000002,835.83659520000003,1114.4487936,1393.0609919999999,1671.6731904000001,1950.2853888,2228.8975872000001,2507.5097855999998,2786.1219839999999,3064.7341824000005,3343.3463808000001,3621.9585791999998,3900.5707775999999,4179.1829760000001,278.61219840000001,557.22439680000002,835.83659520000003]
[{"$f":"Costs!A30","v":"Hallway Flooring - Replace"},975.44021333333342,1219.3002666666666,1463.1603200000002,1707.0203733333335,1950.8804266666668,2194.7404800000004,2438.6005333333333,2682.460586666667,2926.3206400000004,3170.1806933333337,3414.040746666667,3657.9008000000003,243.86005333333335,487.72010666666671,731.58016000000009,975.44021333333342,1219.3002666666666,1463.1603200000002,1707.0203733333335,1950.8804266666668,2194.7404800000004,2438.6005333333333,2682.460586666667,2926.3206400000004,3170.1806933333337,3414.040746666667,3657.9008000000003,243.86005333333335,487.72010666666671,731.58016000000009]
[{"$f":"Costs!A31","v":"Indoor Carpet - Replace"},3009.0123359999998,3761.2654199999997,4513.5185039999997,5265.7715879999996,6018.0246719999996,6770.2777559999986,7522.5308399999994,752.25308399999994,1504.5061679999999,2256.7592519999998,3009.0123359999998,3761.2654199999997,4513.5185039999997,5265.7715879999996,6018.0246719999996,6770.2777559999986,7522.5308399999994,752.25308399999994,1504.5061679999999,2256.7592519999998,3009.0123359999998,3761.2654199999997,4513.5185039999997,5265.7715879999996,6018.0246719999996,6770.2777559999986,7522.5308399999994,752.25308399999994,1504.5061679999999,2256.7592519999998]
[{"$f":"Costs!A32","v":"Utility Doors - Partial Replace"},3223.9423844999997,3582.1582049999997,358.21582049999995,716.4316409999999,1074.6474615,1432.8632819999998,1791.0791024999999,2149.2949229999999,2507.5107435,2865.7265639999996,3223.9423844999997,3582.1582049999997,358.21582049999995,716.4316409999999,1074.6474615,1432.8632819999998,1791.0791024999999,2149.2949229999999,2507.5107435,2865.7265639999996,3223.9423844999997,3582.1582049999997,358.21582049999995,716.4316409999999,1074.6474615,1432.8632819999998,1791.0791024999999,2149.2949229999999,2507.5107435,2865.7265639999996]
[{"$f":"Costs!A33","v":"Pool Gates - Repair/Replace"},1552.2682430666666,1671.6734925333333,1791.0787419999999,119.40524946666666,238.81049893333332,358.2157484,477.62099786666664,597.02624733333334,716.43149679999999,835.83674626666664,955.24199573333328,1074.6472452,1194.0524946666667,1313.4577441333333,1432.8629936,1552.2682430666666,1671.6734925333333,1791.0787419999999,119.40524946666666,238.81049893333332,358.2157484,477.62099786666664,597.02624733333334,716.43149679999999,835.83674626666664,955.24199573333328,1074.6472452,1194.0524946666667,1313.4577441333333,1432.8629936]
[{"$f":"Costs!A34","v":"Chairs + Chair Trolleys (2021)"},450.20352400000007,562.75440500000002,675.30528600000014,787.85616700000003,900.40704800000015,1012.9579290000001,1125.50881,1238.0596909999999,1350.6105720000003,1463.1614530000002,1575.7123340000001,1688.2632150000002,112.55088100000002,225.10176200000004,337.65264300000007,450.20352400000007,562.75440500000002,675.30528600000014,787.85616700000003,900.40704800000015,1012.9579290000001,1125.50881,1238.0596909999999,1350.6105720000003,1463.1614530000002,1575.7123340000001,1688.2632150000002,112.55088100000002,225.10176200000004,337.65264300000007]
[{"$f":"Costs!A35","v":"Tables"},1800.8140959999998,1950.8819373333333,2100.9497786666666,2251.0176200000001,150.06784133333335,300.1356826666667,450.20352399999996,600.27136533333339,750.33920666666677,900.40704799999992,1050.4748893333333,1200.5427306666668,1350.610572,1500.6784133333335,1650.7462546666668,1800.8140959999998,1950.8819373333333,2100.9497786666666,2251.0176200000001,150.06784133333335,300.1356826666667,450.20352399999996,600.27136533333339,750.33920666666677,900.40704799999992,1050.4748893333333,1200.5427306666668,1350.610572,1500.6784133333335,1650.7462546666668]
[{"$f":"Costs!A36","v":"Kitchen - Refurbish"},1910.4836756,2388.1045945000001,2865.7255133999997,3343.3464322999998,3820.9673511999999,4298.5882701,4776.2091890000002,5253.8301079000003,5731.4510267999995,6209.0719456999996,6686.6928645999997,7164.3137834999998,7641.9347023999999,8119.5556213,8597.1765402000001,9074.7974591000002,9552.4183780000003,477.62091889999999,955.24183779999998,1432.8627566999999,1910.4836756,2388.1045945000001,2865.7255133999997,3343.3464322999998,3820.9673511999999,4298.5882701,4776.2091890000002,5253.8301079000003,5731.4510267999995,6209.0719456999996]
[{"$f":"Costs!A37","v":"Restrooms - Refurbish"},11642.009917500001,12418.143912000001,13194.277906500001,13970.411901000003,14746.545895500001,15522.679890000003,776.13399450000009,1552.2679890000002,2328.4019835000004,3104.5359780000003,3880.6699725000008,4656.8039670000007,5432.9379615000007,6209.0719560000007,6985.2059505000016,7761.3399450000015,8537.4739395000015,9313.6079340000015,10089.741928500001,10865.875923000001,11642.009917500001,12418.143912000001,13194.277906500001,13970.411901000003,14746.545895500001,15522.679890000003,776.13399450000009,1552.2679890000002,2328.4019835000004,3104.5359780000003]
[{"$f":"Costs!A38","v":"Interior Surfaces - Repaint"},4697.6651999999995,5219.6279999999997,521.96280000000002,1043.9256,1565.8883999999998,2087.8512000000001,2609.8139999999999,3131.7767999999996,3653.7395999999999,4175.7024000000001,4697.6651999999995,5219.6279999999997,521.96280000000002,1043.9256,1565.8883999999998,2087.8512000000001,2609.8139999999999,3131.7767999999996,3653.7395999999999,4175.7024000000001,4697.6651999999995,5219.6279999999997,521.96280000000002,1043.9256,1565.8883999999998,2087.8512000000001,2609.8139999999999,3131.7767999999996,3653.7395999999999,4175.7024000000001]
[{"$f":"Costs!A39","v":"Building Exteriors - Paint/Repair"},8049.6832950000007,8944.0925500000012,894.40925500000014,1788.8185100000003,2683.2277650000005,3577.6370200000006,4472.0462750000006,5366.4555300000011,6260.8647850000007,7155.2740400000012,8049.6832950000007,8944.0925500000012,894.40925500000014,1788.8185100000003,2683.2277650000005,3577.6370200000006,4472.0462750000006,5366.4555300000011,6260.8647850000007,7155.2740400000012,8049.6832950000007,8944.0925500000012,894.40925500000014,1788.8185100000003,2683.2277650000005,3577.6370200000006,4472.0462750000006,5366.4555300000011,6260.8647850000007,7155.2740400000012]
[{"$f":"Costs!A40","v":"Windows - Replace"},1074.6469979999997,1253.7548309999997,1432.8626639999998,1611.9704969999998,1791.0783299999998,1970.1861629999999,2149.2939959999994,2328.4018289999995,2507.5096619999995,2686.6174949999995,2865.7253279999995,3044.8331609999996,3223.9409939999996,3403.0488269999996,3582.1566599999996,3761.2644929999997,3940.3723259999997,4119.4801589999997,4298.5879919999988,4477.6958249999998,4656.8036579999989,4835.9114909999998,5015.019323999999,5194.1271569999999,5373.234989999999,5552.342823,5731.4506559999991,5910.5584889999991,6089.6663219999991,6268.7741549999992]
[{"$f":"Costs!A41","v":"Fiber Cement Siding - Replace"},19526.483015000002,20277.501592500001,21028.520170000003,21779.538747500003,22530.557325000002,23281.575902500004,24032.594480000003,24783.613057500002,25534.631635000005,26285.650212500004,27036.668790000003,27787.687367500002,28538.705945000005,29289.724522500001,30040.743100000003,751.01857750000011,1502.0371550000002,2253.0557325,3004.0743100000004,3755.0928875000004,4506.111465,5257.1300425000009,6008.1486200000008,6759.1671975000008,7510.1857750000008,8261.2043525000008,9012.2229299999999,9763.2415075000008,10514.260085000002,11265.278662500001]
[{"$f":"Costs!A42","v":"Asphalt Shingle Roof - Replace"},12752.48871,13602.654624000001,14452.820538000002,15302.986452000001,16153.152366000002,17003.318280000003,17853.484194000001,18703.650108000002,19553.816021999999,20403.981936,21254.147850000001,850.16591400000004,1700.3318280000001,2550.497742,3400.6636560000002,4250.8295700000008,5100.995484,5951.1613980000002,6801.3273120000003,7651.4932260000005,8501.6591400000016,9351.8250540000008,10201.990968,11052.156881999999,11902.322796,12752.48871,13602.654624000001,14452.820538000002,15302.986452000001,16153.152366000002]
[{"$f":"Costs!A43","v":"Gutters/Downspouts - Replace"},2507.3471280000003,2674.5036032000003,2841.6600784000002,3008.8165536000001,3175.9730288000005,3343.1295040000005,3510.2859792000004,3677.4424544000003,3844.5989296000002,4011.7554048000006,4178.9118800000006,167.15647520000002,334.31295040000003,501.46942560000008,668.62590080000007,835.78237600000011,1002.9388512000002,1170.0953264000002,1337.2518016000001,1504.4082768000001,1671.5647520000002,1838.7212272000002,2005.8777024000003,2173.0341776000005,2340.1906528000004,2507.3471280000003,2674.5036032000003,2841.6600784000002,3008.8165536000001,3175.9730288000005]
[{"$f":"Costs!A44","v":0}]
[{"$f":"Costs!A44","v":0}]
[{"$f":"Costs!A47","v":"Shade Awnings - Replace Screens"},2155.5963600000005,2694.4954500000003,3233.3945400000002,3772.2936300000001,4311.1927200000009,4850.0918100000008,5388.9909000000007,538.89909000000011,1077.7981800000002,1616.6972700000001,2155.5963600000005,2694.4954500000003,3233.3945400000002,3772.2936300000001,4311.1927200000009,4850.0918100000008,5388.9909000000007,538.89909000000011,1077.7981800000002,1616.6972700000001,2155.5963600000005,2694.4954500000003,3233.3945400000002,3772.2936300000001,4311.1927200000009,4850.0918100000008,5388.9909000000007,538.89909000000011,1077.7981800000002,1616.6972700000001]
[{"$f":"Costs!A48","v":"Play Equipment - Replace"},46435.367075222224,49752.17900916667,53068.990943111108,56385.802877055554,59702.614810999999,3316.8119339444443,6633.6238678888885,9950.4358018333332,13267.247735777777,16584.059669722221,19900.871603666666,23217.683537611112,26534.495471555554,29851.3074055,33168.119339444442,36484.931273388887,39801.743207333333,43118.555141277779,46435.367075222224,49752.17900916667,53068.990943111108,56385.802877055554,59702.614810999999,3316.8119339444443,6633.6238678888885,9950.4358018333332,13267.247735777777,16584.059669722221,19900.871603666666,23217.683537611112]
[{"$f":"Costs!A49","v":"Playground Awnings - Replace Screens"},7235.0829720000011,8682.0995664000002,10129.1161608,11576.1327552,13023.1493496,14470.165944000002,1447.0165944,2894.0331888000001,4341.0497832000001,5788.0663776000001,7235.0829720000011,8682.0995664000002,10129.1161608,11576.1327552,13023.1493496,14470.165944000002,1447.0165944,2894.0331888000001,4341.0497832000001,5788.0663776000001,7235.0829720000011,8682.0995664000002,10129.1161608,11576.1327552,13023.1493496,14470.165944000002,1447.0165944,2894.0331888000001,4341.0497832000001,5788.0663776000001]
[{"$f":"Costs!A50","v":"Park Furniture - Replace"},1060.9000000000001,1591.35,2121.8000000000002,2652.25,3182.7,3713.15,4243.6000000000004,4774.05,5304.5,530.45000000000005,1060.9000000000001,1591.35,2121.8000000000002,2652.25,3182.7,3713.15,4243.6000000000004,4774.05,5304.5,530.45000000000005,1060.9000000000001,1591.35,2121.8000000000002,2652.25,3182.7,3713.15,4243.6000000000004,4774.05,5304.5,530.45000000000005]
[{"$f":"Costs!A51","v":"Drinking Fountains - Replace"},2268.6993158499999,2388.1045429999999,119.40522715,238.8104543,358.21568145000003,477.62090860000001,597.02613574999998,716.43136290000007,835.83659004999993,955.24181720000001,1074.64704435,1194.0522715,1313.4574986499999,1432.8627258000001,1552.2679529499999,1671.6731800999999,1791.0784072499998,1910.4836344,2029.88886155,2149.2940887,2268.6993158499999,2388.1045429999999,119.40522715,238.8104543,358.21568145000003,477.62090860000001,597.02613574999998,716.43136290000007,835.83659004999993,955.24181720000001]
[{"$f":"Costs!A52","v":"Trash Area Wood Fence - Replace"},1232.9100000000001,1297.8,64.89,129.78,194.67,259.56,324.45,389.34,454.23,519.12,584.01,648.9,713.79,778.68,843.56999999999994,908.46,973.35,1038.24,1103.1299999999999,1168.02,1232.9100000000001,1297.8,64.89,129.78,194.67,259.56,324.45,389.34,454.23,519.12]
[{"$f":"Costs!A53","v":"Pool Perimeter Fence - Powder Coat"},21175.435455999999,22687.966560000004,1512.5311040000001,3025.0622080000003,4537.593312,6050.1244160000006,7562.6555200000003,9075.1866239999999,10587.717728,12100.248832000001,13612.779936000001,15125.311040000001,16637.842144000002,18150.373248,19662.904351999998,21175.435455999999,22687.966560000004,1512.5311040000001,3025.0622080000003,4537.593312,6050.1244160000006,7562.6555200000003,9075.1866239999999,10587.717728,12100.248832000001,13612.779936000001,15125.311040000001,16637.842144000002,18150.373248,19662.904351999998]
[{"$f":"Costs!A54","v":"Pool Deck - Repair/Replace"},31911.872000000007,38294.246399999996,44676.620800000004,51058.995200000005,57441.369600000005,63823.744000000013,70206.118400000007,76588.492799999993,82970.867200000008,89353.241600000008,95735.616000000009,6382.3744000000006,12764.748800000001,19147.123199999998,25529.497600000002,31911.872000000007,38294.246399999996,44676.620800000004,51058.995200000005,57441.369600000005,63823.744000000013,70206.118400000007,76588.492799999993,82970.867200000008,89353.241600000008,95735.616000000009,6382.3744000000006,12764.748800000001,19147.123199999998,25529.497600000002]
[{"$f":"Costs!A55","v":"Pool Deck - Replace Bad section"},6620.0160000000005,7129.2480000000005,7638.4800000000005,509.23200000000003,1018.4640000000001,1527.6960000000001,2036.9280000000001,2546.1600000000003,3055.3920000000003,3564.6240000000003,4073.8560000000002,4583.0880000000006,5092.3200000000006,5601.5519999999997,6110.7840000000006,6620.0160000000005,7129.2480000000005,7638.4800000000005,509.23200000000003,1018.4640000000001,1527.6960000000001,2036.9280000000001,2546.1600000000003,3055.3920000000003,3564.6240000000003,4073.8560000000002,4583.0880000000006,5092.3200000000006,5601.5519999999997,6110.7840000000006]
[{"$f":"Costs!A56","v":"Pool - Replaster"},27333.943733500004,32800.7324802,38267.521226900004,43734.3099736,49201.098720299997,54667.887467000008,5466.7887467,10933.5774934,16400.3662401,21867.1549868,27333.943733500004,32800.7324802,38267.521226900004,43734.3099736,49201.098720299997,54667.887467000008,5466.7887467,10933.5774934,16400.3662401,21867.1549868,27333.943733500004,32800.7324802,38267.521226900004,43734.3099736,49201.098720299997,54667.887467000008,5466.7887467,10933.5774934,16400.3662401,21867.1549868]
[{"$f":"Costs!A57","v":"Kiddie Pool - Replaster"},2758.2608445000001,3152.298108,3546.3353715000003,3940.3726350000006,394.03726349999999,788.07452699999999,1182.1117905000001,1576.149054,1970.1863175000003,2364.2235810000002,2758.2608445000001,3152.298108,3546.3353715000003,3940.3726350000006,394.03726349999999,788.07452699999999,1182.1117905000001,1576.149054,1970.1863175000003,2364.2235810000002,2758.2608445000001,3152.298108,3546.3353715000003,3940.3726350000006,394.03726349999999,788.07452699999999,1182.1117905000001,1576.149054,1970.1863175000003,2364.2235810000002]
[{"$f":"Costs!A58","v":"Baby Pool Filter (2016) - Replace"},915.44017266666674,1006.9841899333334,1098.5282072,1190.0722244666665,1281.6162417333333,1373.160259,91.544017266666671,183.08803453333334,274.6320518,366.17606906666668,457.72008633333337,549.2641036,640.80812086666663,732.35213813333337,823.8961554,915.44017266666674,1006.9841899333334,1098.5282072,1190.0722244666665,1281.6162417333333,1373.160259,91.544017266666671,183.08803453333334,274.6320518,366.17606906666668,457.72008633333337,549.2641036,640.80812086666663,732.35213813333337,823.8961554]
[{"$f":"Costs!A59","v":"Main Pool Filters - Replace"},3940.3725525999998,4298.5882392000003,4656.8039257999999,5015.0196124000004,5373.2352990000009,358.21568659999997,716.43137319999994,1074.6470598000001,1432.8627463999999,1791.0784329999999,2149.2941196000002,2507.5098062000002,2865.7254927999998,3223.9411793999998,3582.1568659999998,3940.3725525999998,4298.5882392000003,4656.8039257999999,5015.0196124000004,5373.2352990000009,358.21568659999997,716.43137319999994,1074.6470598000001,1432.8627463999999,1791.0784329999999,2149.2941196000002,2507.5098062000002,2865.7254927999998,3223.9411793999998,3582.1568659999998]
[{"$f":"Costs!A60","v":"Pool Filter Sand"},537.32349900000008,1074.6469980000002,1611.9704970000003,2149.2939960000003,537.32349900000008,1074.6469980000002,1611.9704970000003,2149.2939960000003,537.32349900000008,1074.6469980000002,1611.9704970000003,2149.2939960000003,537.32349900000008,1074.6469980000002,1611.9704970000003,2149.2939960000003,537.32349900000008,1074.6469980000002,1611.9704970000003,2149.2939960000003,537.32349900000008,1074.6469980000002,1611.9704970000003,2149.2939960000003,537.32349900000008,1074.6469980000002,1611.9704970000003,2149.2939960000003,537.32349900000008,1074.6469980000002]
[{"$f":"Costs!A61","v":"Baby Pool Pump - Replace"},267.8,401.7,535.6,669.5,133.9,267.8,401.7,535.6,669.5,133.9,267.8,401.7,535.6,669.5,133.9,267.8,401.7,535.6,669.5,133.9,267.8,401.7,535.6,669.5,133.9,267.8,401.7,535.6,669.5,133.9]
[{"$f":"Costs!A62","v":"Main Pool Pump - Replace"},618,927,1236,1545,309,618,927,1236,1545,309,618,927,1236,1545,309,618,927,1236,1545,309,618,927,1236,1545,309,618,927,1236,1545,309]
[{"$f":"Costs!A63","v":"Diving Board - Replace"},4830.3086343333325,5796.3703611999999,6762.4320880666664,7728.4938149333329,8694.5555417999985,9660.617268666665,10626.678995533332,11592.7407224,12558.802449266666,13524.864176133333,14490.925902999999,966.06172686666662,1932.1234537333332,2898.1851806,3864.2469074666665,4830.3086343333325,5796.3703611999999,6762.4320880666664,7728.4938149333329,8694.5555417999985,9660.617268666665,10626.678995533332,11592.7407224,12558.802449266666,13524.864176133333,14490.925902999999,966.06172686666662,1932.1234537333332,2898.1851806,3864.2469074666665]
[{"$f":"Costs!A64","v":"Lifeguard Stands - Replace"},1697.44,2546.1600000000003,3394.88,4243.6000000000004,5092.3200000000006,5941.04,6789.76,7638.4800000000005,8487.2000000000007,9335.9200000000019,10184.640000000001,11033.360000000002,11882.08,12730.800000000001,848.72,1697.44,2546.1600000000003,3394.88,4243.6000000000004,5092.3200000000006,5941.04,6789.76,7638.4800000000005,8487.2000000000007,9335.9200000000019,10184.640000000001,11033.360000000002,11882.08,12730.800000000001,848.72]
[{"$f":"Costs!A65","v":"Pool Coping - Replace"},6290.7340125000001,6710.1162800000002,7129.4985475000012,7548.8808150000013,7968.2630824999997,8387.6453500000007,419.38226750000001,838.76453500000002,1258.1468025000001,1677.52907,2096.9113375000002,2516.2936050000003,2935.6758725000004,3355.0581400000001,3774.4404075000007,4193.8226750000003,4613.2049425000005,5032.5872100000006,5451.9694775000007,5871.3517450000008,6290.7340125000001,6710.1162800000002,7129.4985475000012,7548.8808150000013,7968.2630824999997,8387.6453500000007,419.38226750000001,838.76453500000002,1258.1468025000001,1677.52907]
[{"$f":"Costs!A66","v":"Pool Perimeter Fence - Replace"},21174.562565333334,22289.013226666666,23403.463888000002,24517.914549333334,25632.365210666667,26746.815872000003,27861.266533333335,28975.717194666668,30090.167856,31204.618517333336,32319.069178666668,33433.519840000001,1114.4506613333333,2228.9013226666666,3343.3519840000004,4457.8026453333332,5572.2533066666665,6686.7039680000007,7801.154629333334,8915.6052906666664,10030.055952000001,11144.506613333333,12258.957274666667,13373.407936000001,14487.858597333334,15602.309258666668,16716.75992,17831.210581333333,18945.661242666665,20060.111904000001]
[{"$f":"Costs!A67","v":"Pool Furniture - Replace (66 items)"},14328.627567,16716.7321615,19104.836756000001,2388.1045945000001,4776.2091890000002,7164.3137834999998,9552.4183780000003,11940.522972500001,14328.627567,16716.7321615,19104.836756000001,2388.1045945000001,4776.2091890000002,7164.3137834999998,9552.4183780000003,11940.522972500001,14328.627567,16716.7321615,19104.836756000001,2388.1045945000001,4776.2091890000002,7164.3137834999998,9552.4183780000003,11940.522972500001,14328.627567,16716.7321615,19104.836756000001,2388.1045945000001,4776.2091890000002,7164.3137834999998]
[{"$f":"Costs!A68","v":"Tennis Courts - Resurface (26,000 GSF)"},15435.549394285716,19294.436742857146,23153.324091428574,27012.211440000003,3858.8873485714289,7717.7746971428578,11576.662045714287,15435.549394285716,19294.436742857146,23153.324091428574,27012.211440000003,3858.8873485714289,7717.7746971428578,11576.662045714287,15435.549394285716,19294.436742857146,23153.324091428574,27012.211440000003,3858.8873485714289,7717.7746971428578,11576.662045714287,15435.549394285716,19294.436742857146,23153.324091428574,27012.211440000003,3858.8873485714289,7717.7746971428578,11576.662045714287,15435.549394285716,19294.436742857146]
[{"$f":"Costs!A69","v":"Tennis Court Light Fixtures - Replace"},2999.328,4498.9920000000002,5998.6559999999999,7498.3199999999988,8997.9840000000004,10497.647999999999,11997.312,13496.975999999999,14996.639999999998,16496.304,17995.968000000001,19495.631999999998,20995.295999999998,22494.959999999999,1499.664,2999.328,4498.9920000000002,5998.6559999999999,7498.3199999999988,8997.9840000000004,10497.647999999999,11997.312,13496.975999999999,14996.639999999998,16496.304,17995.968000000001,19495.631999999998,20995.295999999998,22494.959999999999,1499.664]
[{"$f":"Costs!A70","v":"Tennis Court Light Poles - Replace"},2142.3759999999997,3213.5639999999999,4284.7519999999995,5355.9400000000005,6427.1279999999997,7498.3159999999998,8569.503999999999,9640.6920000000009,10711.880000000001,11783.067999999999,12854.255999999999,13925.444,14996.632,16067.82,17139.007999999998,18210.196,19281.384000000002,20352.572,21423.760000000002,22494.947999999997,23566.135999999999,24637.324000000001,25708.511999999999,26779.7,27850.887999999999,28922.076000000001,29993.263999999999,31064.451999999997,32135.64,1071.1879999999999]
[{"$f":"Costs!A71","v":"Tennis Chain Link Fence - Replace"},18608.841801000002,19703.479554000001,20798.117307,21892.75506,22987.392813000002,24082.030565999998,25176.668319,26271.306072000003,27365.943825000002,28460.581578000001,29555.219331,30649.857084000003,31744.494836999998,32839.132590000001,1094.637753,2189.275506,3283.9132590000004,4378.5510119999999,5473.1887649999999,6567.8265180000008,7662.4642710000007,8757.1020239999998,9851.7397770000007,10946.37753,12041.015282999999,13135.653036000002,14230.290789000001,15324.928542000001,16419.566295000001,17514.204048]
[{"$f":"Costs!A72","v":"Basketball Court - Replace"},35646.239999999998,36664.703999999998,37683.167999999998,38701.631999999998,39720.095999999998,40738.559999999998,1018.4639999999999,2036.9279999999999,3055.3919999999998,4073.8559999999998,5092.32,6110.7839999999997,7129.2479999999996,8147.7119999999995,9166.1759999999995,10184.64,11203.103999999999,12221.567999999999,13240.032000000001,14258.495999999999,15276.959999999997,16295.423999999999,17313.887999999999,18332.351999999999,19350.815999999999,20369.28,21387.743999999999,22406.207999999999,23424.671999999999,24443.135999999999]
[{"$f":"Costs!A73","v":"Basketball Hoop - Replace"},254.61599999999999,381.92399999999998,509.23199999999997,636.54,763.84799999999996,891.15599999999995,1018.4639999999999,1145.7719999999999,1273.08,127.30799999999999,254.61599999999999,381.92399999999998,509.23199999999997,636.54,763.84799999999996,891.15599999999995,1018.4639999999999,1145.7719999999999,1273.08,127.30799999999999,254.61599999999999,381.92399999999998,509.23199999999997,636.54,763.84799999999996,891.15599999999995,1018.4639999999999,1145.7719999999999,1273.08,127.30799999999999]
[{"$f":"Costs!A74","v":0}]
[{"$f":"Costs!A77","v":"HVAC Unit (A) 4Ton- Replace "},3104.5359780000003,3621.9586410000002,4139.3813040000005,4656.8039670000007,5174.226630000001,5691.6492930000004,6209.0719560000007,6726.494619000001,7243.9172820000003,7761.3399450000006,517.42266300000006,1034.8453260000001,1552.2679890000002,2069.6906520000002,2587.1133150000005,3104.5359780000003,3621.9586410000002,4139.3813040000005,4656.8039670000007,5174.226630000001,5691.6492930000004,6209.0719560000007,6726.494619000001,7243.9172820000003,7761.3399450000006,517.42266300000006,1034.8453260000001,1552.2679890000002,2069.6906520000002,2587.1133150000005]
[{"$f":"Costs!A78","v":"HVAC Unit (B) 4Ton- Replace "},3104.5359780000003,3621.9586410000002,4139.3813040000005,4656.8039670000007,5174.226630000001,5691.6492930000004,6209.0719560000007,6726.494619000001,7243.9172820000003,7761.3399450000006,517.42266300000006,1034.8453260000001,1552.2679890000002,2069.6906520000002,2587.1133150000005,3104.5359780000003,3621.9586410000002,4139.3813040000005,4656.8039670000007,5174.226630000001,5691.6492930000004,6209.0719560000007,6726.494619000001,7243.9172820000003,7761.3399450000006,517.42266300000006,1034.8453260000001,1552.2679890000002,2069.6906520000002,2587.1133150000005]
[{"$f":"Costs!A79","v":"HVAC Unit (C) 3Ton- Replace "},3300,3666.6666666666665,4033.3333333333335,4400,4766.666666666667,5133.333333333333,5500,366.66666666666669,733.33333333333337,1100,1466.6666666666667,1833.3333333333333,2200,2566.6666666666665,2933.3333333333335,3300,3666.6666666666665,4033.3333333333335,4400,4766.666666666667,5133.333333333333,5500,366.66666666666669,733.33333333333337,1100,1466.6666666666667,1833.3333333333333,2200,2566.6666666666665,2933.3333333333335]
[{"$f":"Costs!A80","v":0}]
["Total FFB",{"$f":"SUM(B14:B75)","v":919355.82622251532},1024228.7096999618,1084981.8433194091,936026.55129885557,855922.53477730253,750140.48219274951,619403.54676019645,677727.18824764271,780450.77772908937,876531.58120653639,965881.78479398356,746263.18695443019,788282.03084987681,893154.91432732402,902918.36975977046,754831.73013721744,657425.98620766413,551788.52275711123,515305.32456455799,590030.27366600488,687380.62784845184,790880.35106689879,868821.45124634507,913991.71991279209,996231.80393923901,1048121.8386466862,908394.80157013237,720669.47931057913,692401.78879202623,558593.65226947295]
["Total FFB Adjusted for Inflation",{"$f":"B77*(1+'Cash Flow'!$B$8)^B13","v":919355.82622251532},{"$f":"C77*(1+'Cash Flow'!$B$8)^C13","v":1054955.5709909608},{"$f":"D77*(1+'Cash Flow'!$B$8)^D13","v":1151057.2375775611},{"$f":"E77*(1+'Cash Flow'!$B$8)^E13","v":1022821.4853211446},{"$f":"F77*(1+'Cash Flow'!$B$8)^F13","v":963348.35356938536},{"$f":"G77*(1+'Cash Flow'!$B$8)^G13","v":869618.41308895522},{"$f":"H77*(1+'Cash Flow'!$B$8)^H13","v":739600.22748722031},{"$f":"I77*(1+'Cash Flow'!$B$8)^I13","v":833518.95671365689},{"$f":"J77*(1+'Cash Flow'!$B$8)^J13","v":988651.69522290665},{"$f":"K77*(1+'Cash Flow'!$B$8)^K13","v":1143674.9019377343},{"$f":"L77*(1+'Cash Flow'!$B$8)^L13","v":1298064.3510947686},{"$f":"M77*(1+'Cash Flow'!$B$8)^M13","v":1033002.7798570914},{"$f":"N77*(1+'Cash Flow'!$B$8)^N13","v":1123901.6873894271},{"$f":"O77*(1+'Cash Flow'!$B$8)^O13","v":1311628.1030246185},{"$f":"P77*(1+'Cash Flow'!$B$8)^P13","v":1365745.0484815566},{"$f":"Q77*(1+'Cash Flow'!$B$8)^Q13","v":1176003.2405701661},{"$f":"R77*(1+'Cash Flow'!$B$8)^R13","v":1054975.7132983089},{"$f":"S77*(1+'Cash Flow'!$B$8)^S13","v":912022.3533538183},{"$f":"T77*(1+'Cash Flow'!$B$8)^T13","v":877272.8211716623},{"$f":"U77*(1+'Cash Flow'!$B$8)^U13","v":1034621.6563720775},{"$f":"V77*(1+'Cash Flow'!$B$8)^V13","v":1241485.8744512037},{"$f":"W77*(1+'Cash Flow'!$B$8)^W13","v":1471270.4239614517},{"$f":"X77*(1+'Cash Flow'!$B$8)^X13","v":1664751.7444244921},{"$f":"Y77*(1+'Cash Flow'!$B$8)^Y13","v":1803841.7297012915},{"$f":"Z77*(1+'Cash Flow'!$B$8)^Z13","v":2025134.1397160995},{"$f":"AA77*(1+'Cash Flow'!$B$8)^AA13","v":2194534.3733470268},{"$f":"AB77*(1+'Cash Flow'!$B$8)^AB13","v":1959036.2965483672},{"$f":"AC77*(1+'Cash Flow'!$B$8)^AC13","v":1600815.1910425581},{"$f":"AD77*(1+'Cash Flow'!$B$8)^AD13","v":1584165.2153072618},{"$f":"AE77*(1+'Cash Flow'!$B$8)^AE13","v":1316362.5328140368}]
[]
["Reserve Fund Strength",{"$f":"'Cash Flow'!B80/'FFB Spread'!B78","v":0.98981697188891316},{"$f":"'Cash Flow'!C80/'FFB Spread'!C78","v":0.9894982224494937},{"$f":"'Cash Flow'!D80/'FFB Spread'!D78","v":0.98942358608914682},{"$f":"'Cash Flow'!E80/'FFB Spread'!E78","v":0.9902157625194753},{"$f":"'Cash Flow'!F80/'FFB Spread'!F78","v":0.99078257738315301},{"$f":"'Cash Flow'!G80/'FFB Spread'!G78","v":0.9916234846741685},{"$f":"'Cash Flow'!H80/'FFB Spread'!H78","v":0.99295868458158665},{"$f":"'Cash Flow'!I80/'FFB Spread'!I78","v":0.99231781871136748},{"$f":"'Cash Flow'!J80/'FFB Spread'!J78","v":0.99145896917828769},{"$f":"'Cash Flow'!K80/'FFB Spread'!K78","v":0.99088567671670447},{"$f":"'Cash Flow'!L80/'FFB Spread'!L78","v":0.99049862632734376},{"$f":"'Cash Flow'!M80/'FFB Spread'!M78","v":0.9921037865383634},{"$f":"'Cash Flow'!N80/'FFB Spread'!N78","v":0.99181398092351492},{"$f":"'Cash Flow'!O80/'FFB Spread'!O78","v":0.99115601809528131},{"$f":"'Cash Flow'!P80/'FFB Spread'!P78","v":0.99120900834565606},{"$f":"'Cash Flow'!Q80/'FFB Spread'!Q78","v":0.99244174871424107},{"$f":"'Cash Flow'!R80/'FFB Spread'!R78","v":0.99352077977317865},{"$f":"'Cash Flow'!S80/'FFB Spread'!S78","v":0.99504421905025808},{"$f":"'Cash Flow'!T80/'FFB Spread'!T78","v":0.99564401834764116},{"$f":"'Cash Flow'!U80/'FFB Spread'!U78","v":0.9942945393419057},{"$f":"'Cash Flow'!V80/'FFB Spread'!V78","v":0.99304121777795606},{"$f":"'Cash Flow'!W80/'FFB Spread'!W78","v":0.9920976163012335},{"$f":"'Cash Flow'!X80/'FFB Spread'!X78","v":0.99158850131671239},{"$f":"'Cash Flow'!Y80/'FFB Spread'!Y78","v":0.99139525630531289},{"$f":"'Cash Flow'!Z80/'FFB Spread'!Z78","v":0.99103061346495791},{"$f":"'Cash Flow'!AA80/'FFB Spread'!AA78","v":0.99090003735786447},{"$f":"'Cash Flow'!AB80/'FFB Spread'!AB78","v":0.9918894400562539},{"$f":"'Cash Flow'!AC80/'FFB Spread'!AC78","v":0.99366762380415574},{"$f":"'Cash Flow'!AD80/'FFB Spread'!AD78","v":0.99404364675426526},{"$f":"'Cash Flow'!AE80/'FFB Spread'!AE78","v":0.99609665937563974}]