{"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":85,"n_cols":14,"rows_kept":85,"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$56","v":2024},null,null,null,{"$f":"$M$56","v":2024}]
["SITE",null,null,null,null,null,null,null,null,null,null,"Update Procedure:"]
["Concrete Walkways - Repair/Replace",10,10,600,"GSF",12,"GSF",{"$f":"D13*F13","v":7200},{"$f":"H13/C13","v":720},{"$f":"H13*(C13-B13)/C13","v":0},null,"You can update the values in columns"]
["Concrete Walkways - Repair/Replace",5,10,4000,"GSF",12,"GSF",{"$f":"D14*F14","v":48000},4800,24000,null,"B through G and re-spread the revised"]
["Concrete Parking Lot - Repair",5,15,7800,"GSF",12,"GSF",{"$f":"D15*F15","v":93600},{"$f":"H15/C15","v":6240},{"$f":"H15*(C15-B15)/C15","v":62400},null,"forecasted capital requirements on the"]
["Wood Fence (A) - Replace",7,17,4000,"LF",41,"LF",{"$f":"D16*F16","v":164000},9647.0588235294126,96470.588235294112,null,"Cash Flow spreadsheet by clicking the"]
["Wood Fence (B) - Replace",8,17,4000,"LF",41,"LF",{"$f":"D17*F17","v":164000},9647.0588235294126,86823.529411764699,null,"\"Spread All\" button below. You can then"]
["Wood Fence (C) - Replace",9,17,4000,"LF",41,"LF",164000,9647.0588235294126,77176.470588235301,null,"see the year-by-year effect on the reserve"]
["Wood Fence (D) - Replace",10,17,1682,"LF",41,"LF",68962,4056.5882352941176,28396.117647058825,null,"fund balance by looking at the graphs below"]
["Brick Columns - Repair",5,10,60,"ea",225.10176200000001,"ea",13506.10572,1350.610572,6753.0528599999989,null,"the table on the Cash Flow sheet. On this"]
["Parking Spaces - Restripe",5,7,1,"Lot",1969.6403660000001,"Lot",1969.6403660000001,281.37719514285715,562.75439028571429,null,"sheet you can also change the financial"]
["Car Park & BB Light Fixtures - Replace",0,15,5,"ea",848.72,"ea",{"$f":"D22*F22","v":4243.6000000000004},{"$f":"H22/C22","v":282.90666666666669},{"$f":"H22*(C22-B22)/C22","v":4243.6000000000004},null,"parameters in in the green shaded area"]
["Car Park & BB Poles - Refurbish",0,15,5,"ea",848.72,"ea",4243.6000000000004,282.90666666666669,4243.6000000000004,null,"at the top of the page."]
["Monument Signs - Refurbish",6,20,4,"ea",1969.6403660000001,"ea",7878.5614640000003,393.92807320000003,5514.9930248000001]
["Cul-de-sac Islands (A) - Irrigation",17,20,5,"Lot",2025.9158580000001,"Lot",10129.57929,506.47896449999996,1519.4368934999998]
["Cul-de-sac Islands (B) - Irrigation",17,20,4,"Lot",2025.9158580000001,"Lot",8103.6634320000003,405.18317160000004,1215.5495148]
["Cul-de-sac Islands (C) - Irrigation",15,20,4,"Lot",2025.9158580000001,"Lot",8103.6634320000003,405.18317160000004,2025.9158579999998]
["Sub Total",null,null,null,null,null,null,{"$f":"SUM(H13:H27)","v":767940.41370399995},{"$f":"SUM(I13:I27)","v":48666.339187258549},{"$f":"SUM(J13:J27)","v":401345.60842373851},null,"To calculate the monthly reserve contribution"]
["CLUBHOUSE",null,null,null,null,null,null,null,null,null,null,"which gives 100% funding at the start of the"]
["Surveillance System - Replace",8,10,1,"Lot",26522.5,"Lot",{"$f":"D30*F30","v":26522.5},{"$f":"H30/C30","v":2652.25},{"$f":"H30*(C30-B30)/C30","v":5304.5},null,"30th year, click the \"Calc Mnthly Reserve\""]
["Interior Lights - Replace",13,15,1,"Lot",3939.280835,"Lot",3939.280835,262.61872233333332,525.23744466666665,null,"button below. The macro re-populates the whole"]
["Hallway Flooring - Replace",13,15,40,"GSY",86.198125000000005,"GSY",3447.9250000000002,229.86166666666668,459.72333333333336,null,"FFB spread sheet so takes a while to process"]
["Indoor Carpet - Replace",8,10,180,"GSY",39.392761999999998,"GSY",7090.6971599999997,709.06971599999997,1418.1394319999999,null,"the 30 years. The required monthly contribution"]
["Utility Doors - Partial Replace",1,10,15,"ea",225.10176200000001,"ea",3376.5264299999999,337.65264300000001,3038.8737869999995,null,"will be shown in the yellow box below the button."]
["Pool Gates - Repair/Replace",4,15,2,"ea",844.13165900000001,"ea",1688.263318,112.55088786666667,1238.0597665333335]
["Chairs + Chair Trolleys (2021)",13,15,1,"Lot",1591.3500000000001,"ea",{"$f":"D36*F36","v":1591.3500000000001},{"$f":"H36/C36","v":106.09},{"$f":"H36*(C36-B36)/C36","v":212.18}]
["Tables",5,15,1,"Lot",2121.8000000000002,"Lot",2121.8000000000002,141.45333333333335,1414.5333333333333]
["Kitchen - Refurbish",18,20,1,"Lot",9004.0704800000003,"Lot",9004.0704800000003,450.20352400000002,900.40704800000003]
["Restrooms - Refurbish",7,20,2,"ea",7315.8072650000004,"Lot",14631.614530000001,731.58072650000008,9510.5494445000004,null,null,{"$f":"'Cash Flow'!B79/12","v":9538.5840203117787},"Per Month"]
["Interior Surfaces - Repaint",1,10,4100,"GSF",1.2,"GSF",4920,492,4428]
["Building Exteriors - Paint/Repair",1,10,5350,"GSF",1.5757970000000001,"GSF",8430.5139500000005,843.05139500000007,7587.4625550000001,null,"To add or delete a component row click below:"]
["Windows - Replace",36,40,12,"ea",562.75440500000002,"ea",6753.0528599999998,168.82632150000001,675.30528600000002]
["Fiber Cement Siding - Replace",16,40,3350,"GSF",8.452592000000001,"GSF",28316.183200000003,707.90458000000012,16989.709920000001]
["Asphalt Shingle Roof - Replace",12,25,4450,"GSF",4.502027,"GSF",20034.02015,801.36080600000003,10417.690478]
["Gutters/Downspouts - Replace",12,25,164,"LF",24.018364000000002,"LF",3939.0116960000005,157.56046784000003,2048.28608192]
["Sub Total",null,null,null,null,null,null,{"$f":"SUM(H30:H45)","v":145806.80960899999},{"$f":"SUM(I30:I45)","v":8904.0347900399993},{"$f":"SUM(J30:J45)","v":66168.657910286667},null,"To set up this spreadsheet for the next year :"]
["POOL/PARK/TENNIS",null,null,null,null,null,null,null,null,null,null,"click on the button below and follow the prompts"]
["Shade Awnings - Replace Screens",8,10,1140,"GSF",4.4557799999999999,"GSF",{"$f":"D48*F48","v":5079.5891999999994},{"$f":"H48/C48","v":507.95891999999992},{"$f":"H48*(C48-B48)/C48","v":1015.9178399999998}]
["Play Equipment - Replace",4,18,1,"Lot",56275.440500000004,"Lot",56275.440500000004,3126.4133611111115,43769.787055555556]
["Playground Awnings - Replace Screens",7,10,{"$f":"(27*33+26*37)","v":1853},"GSF",7.360792,"GSF",{"$f":"D50*F50","v":13639.547576000001},{"$f":"H50/C50","v":1363.9547576},{"$f":"H50*(C50-B50)/C50","v":4091.8642728000004}]
["Park Furniture - Replace (13 items)",10,10,1,"Lot",5000,"Lot",5000,500,0]
["Drinking Fountains - Replace",3,20,1,"Lot",2251.0176200000001,"Lot",2251.0176200000001,112.550881,1913.364977,null,"You can also perform the update manually"]
["Wood Fence - Replace",1,20,30,"LF",37.513218000000002,"LF",1125.39654,56.269826999999999,1069.1267130000001,null,"by entering the year and prior year reserve "]
["Pool Perimeter Fence - Powder Coat",3,15,560,"LF",38.188485999999997,"LF",21385.552159999999,1425.7034773333332,17108.441727999998,null,"total in the green shaded cells below:"]
["Pool Deck - Repair/Replace",5,15,8120,"GSF",12,"GSF",97440,6496,64960]
["Pool - Replaster",7,10,1,"Lot",51529.727139000002,"Lot",51529.727139000002,5152.9727139000006,15458.918141700002,null,"YEAR",2024]
["Kiddie Pool - Replaster",5,10,1,"Lot",3714.1790730000002,"Lot",3714.1790730000002,371.41790730000002,1857.0895365000001]
["Pool Filter (2016) - Replace",7,15,1,"ea",1294.3351830000001,"ea",1294.3351830000001,86.289012200000016,690.31209760000013,null,"then adjust figures in columns B, C and F and"]
["Pool Filters (Old) - Replace",1,15,3,"ea",1688.2632149999999,"ea",5064.7896449999998,337.65264300000001,4727.1370020000004,null,"enter the prior year's Dec 31 Reserve Total:"]
["Sand Filters - Replace Media",1,4,4,"ea",506.47891300000003,"ea",2025.9156520000001,506.47891300000003,1519.4367390000002]
["Pool Pumps - Replace",2,5,2,"ea",1688.2632149999999,"ea",3376.5264299999999,675.30528600000002,2025.9158579999998,null,"2019-12-31",726055,{"$f":"M56-1","v":2023}]
["Diving Board - Replace",12,15,1,"ea",13659.0875,"ea",{"$f":"D62*F62","v":13659.0875},{"$f":"H62/C62","v":910.60583333333329},{"$f":"H62*(C62-B62)/C62","v":2731.8174999999997}]
["Lifeguard Stands - Replace",15,15,2,"ea",6000,"ea",12000,800,0]
["Swim Lane Dividers - Replace",1,15,1,"Lot",2532.3947710000002,"Lot",2532.3947710000002,168.82631806666669,2363.5684529333334]
["Pool Coping - Replace",7,20,350,"LF",22.589033000000001,"LF",7906.1615499999998,395.30807749999997,5139.0050074999999]
["Pool Perimeter Fence - Replace",13,30,560,"LF",56.275492,"LF",31514.275519999999,1050.4758506666667,17858.089461333333]
["Pool Furniture - Replace (66 items)",2,8,1,"Lot",18008.140960000001,"Lot",18008.140960000001,2251.0176200000001,13506.10572]
["Tennis Courts - Resurface (26,000 GSF)",5,7,1,"Lot",25461.600000000002,"Lot",25461.600000000002,3637.3714285714291,7274.7428571428582]
["Tennis Court Light Fixtures - Replace",0,15,24,"Lot",2408.2429999999999,"Lot",57797.831999999995,3853.1887999999994,57797.832000000002]
["Tennis Court Light Poles - Refurbish",0,15,12,"ea",848.72,"ea",10184.64,678.976,10184.639999999998]
["Tennis Chain Link Fence - Replace",15,30,990,"LF",31.266680000000001,"LF",30954.013200000001,1031.80044,15477.006600000001]
["Basketball Court - Replace",10,40,3200,"GSF",12,"GSF",38400,960,28800]
["Basketball Hoop - Replace",10,10,1,"ea",1200,"ea",1200,120,0]
["Sub Total",null,null,null,null,null,null,{"$f":"SUM(H48:H73)","v":518820.16221900005},{"$f":"SUM(I48:I73)","v":36576.538067582544},{"$f":"SUM(J48:J73)","v":321340.1195600651}]
["HVAC"]
["HVAC Unit (A) 4Ton- Replace ",11,15,1,"ea",7315.8072650000004,"ea",{"$f":"D76*F76","v":7315.8072650000004},{"$f":"H76/C76","v":487.72048433333333},{"$f":"H76*(C76-B76)/C76","v":1950.8819373333333}]
["HVAC Unit (B) 4Ton- Replace ",11,15,1,"ea",7315.8072650000004,"ea",7315.8072650000004,{"$f":"H77/C77","v":487.72048433333333},{"$f":"H77*(C77-B77)/C77","v":1950.8819373333333}]
["HVAC Unit (C) 3Ton- Replace ",8,15,1,"ea",6190.2984550000001,"ea",5500,{"$f":"H78/C78","v":366.66666666666669},{"$f":"H78*(C78-B78)/C78","v":2566.6666666666665}]
["Sub Total",null,null,null,null,null,null,{"$f":"SUM(H76:H78)","v":20131.614529999999},{"$f":"SUM(I76:I78)","v":1342.1076353333333},{"$f":"SUM(J76:J78)","v":6468.4305413333332}]
[]
["Grand Total","BOT",null,null,null,null,null,{"$f":"SUM(H13:H79)/2","v":1452699.0000620002},{"$f":"SUM(I13:I79)/2","v":95489.01968021442},795322.8164354238]
[]
[null,null,null,null,null,null,null,null,"Total Required on Deposit:",{"$f":"J81","v":795322.8164354238}]
[null,null,null,null,null,null,null,null,"Prior year projected December 31 Reserve Total",{"$f":"M61","v":726055}]
[null,null,null,null,null,null,null,null,"Percent Funded",{"$f":"J84/J83","v":0.91290603638673806}]

{"sheet":"Cash Flow","index":1,"n_rows":82,"n_cols":31,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["$B$78",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESERVE STUDY -",{"$f":"Costs!$M$56","v":2024}]
["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!M61","v":726055},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",12.501420734353577,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",1.788E-2,null,"on the graph below."]
["Inflation rate",0.03]
[15]
[{"$f":"MID(A1,2,1)","v":"B"}]
[{"$f":"SUBSTITUTE(A1,\"$B$\",\"A\")","v":"A78"}]
[{"$f":"RIGHT(A11,2)","v":"78"},{"$f":"Costs!$M$56","v":2024},{"$f":"B12+1","v":2025},{"$f":"C12+1","v":2026},2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,{"$f":"U12+1","v":2044},2045,2046,2047,2048,2049,2050,2051,2052,2053]
[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 - Repair/Replace"},null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H13","v":7200},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H13","v":7200}]
[{"$f":"Costs!A14","v":"Concrete Walkways - Repair/Replace"},null,null,null,null,null,{"$f":"Costs!H14","v":48000},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H14","v":48000},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H14","v":48000}]
[{"$f":"Costs!A15","v":"Concrete Parking Lot - Repair"},null,null,null,null,null,{"$f":"Costs!H15","v":93600},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H15","v":93600}]
[{"$f":"Costs!A16","v":"Wood Fence (A) - Replace"},null,null,null,null,null,null,null,{"$f":"Costs!H16","v":164000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H16","v":164000}]
[{"$f":"Costs!A17","v":"Wood Fence (B) - Replace"},null,null,null,null,null,null,null,null,{"$f":"Costs!H17","v":164000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H17","v":164000}]
[{"$f":"Costs!A18","v":"Wood Fence (C) - Replace"},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H18","v":164000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H18","v":164000}]
[{"$f":"Costs!A19","v":"Wood Fence (D) - Replace"},null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H19","v":68962},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H19","v":68962}]
[{"$f":"Costs!A20","v":"Brick Columns - Repair"},null,null,null,null,null,{"$f":"Costs!H20","v":13506.10572},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H20","v":13506.10572},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H20","v":13506.10572}]
[{"$f":"Costs!A21","v":"Parking Spaces - Restripe"},null,null,null,null,null,{"$f":"Costs!H21","v":1969.6403660000001},null,null,null,null,null,null,{"$f":"Costs!H21","v":1969.6403660000001},null,null,null,null,null,null,{"$f":"Costs!H21","v":1969.6403660000001},null,null,null,null,null,null,{"$f":"Costs!H21","v":1969.6403660000001}]
[{"$f":"Costs!A22","v":"Car Park & BB Light Fixtures - Replace"},{"$f":"Costs!H22","v":4243.6000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H22","v":4243.6000000000004}]
[{"$f":"Costs!A23","v":"Car Park & BB Poles - Refurbish"},{"$f":"Costs!H23","v":4243.6000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H23","v":4243.6000000000004}]
[{"$f":"Costs!A24","v":"Monument Signs - Refurbish"},null,null,null,null,null,null,{"$f":"Costs!H24","v":7878.5614640000003},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H24","v":7878.5614640000003}]
[{"$f":"Costs!A25","v":"Cul-de-sac Islands (A) - Irrigation"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H25","v":10129.57929}]
[{"$f":"Costs!A26","v":"Cul-de-sac Islands (B) - Irrigation"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H26","v":8103.6634320000003}]
[{"$f":"Costs!A27","v":"Cul-de-sac Islands (C) - Irrigation"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H27","v":8103.6634320000003}]
[{"$f":"Costs!A30","v":"Surveillance System - Replace"},null,null,null,null,null,null,null,null,{"$f":"Costs!H30","v":26522.5},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H30","v":26522.5},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H30","v":26522.5}]
[{"$f":"Costs!A31","v":"Interior Lights - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H31","v":3939.280835},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H31","v":3939.280835}]
[{"$f":"Costs!A32","v":"Hallway Flooring - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H32","v":3447.9250000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H32","v":3447.9250000000002}]
[{"$f":"Costs!A33","v":"Indoor Carpet - Replace"},null,null,null,null,null,null,null,null,{"$f":"Costs!H33","v":7090.6971599999997},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H33","v":7090.6971599999997},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H33","v":7090.6971599999997}]
[{"$f":"Costs!A34","v":"Utility Doors - Partial Replace"},null,{"$f":"Costs!H34","v":3376.5264299999999},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H34","v":3376.5264299999999},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H34","v":3376.5264299999999}]
[{"$f":"Costs!A35","v":"Pool Gates - Repair/Replace"},null,null,null,null,{"$f":"Costs!H35","v":1688.263318},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H35","v":1688.263318}]
[{"$f":"Costs!A36","v":"Chairs + Chair Trolleys (2021)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H36","v":1591.3500000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H36","v":1591.3500000000001}]
[{"$f":"Costs!A37","v":"Tables"},null,null,null,null,null,{"$f":"Costs!H37","v":2121.8000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H37","v":2121.8000000000002}]
[{"$f":"Costs!A38","v":"Kitchen - Refurbish"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H38","v":9004.0704800000003}]
[{"$f":"Costs!A39","v":"Restrooms - Refurbish"},null,null,null,null,null,null,null,{"$f":"Costs!H39","v":14631.614530000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H39","v":14631.614530000001}]
[{"$f":"Costs!A40","v":"Interior Surfaces - Repaint"},null,{"$f":"Costs!H40","v":4920},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H40","v":4920},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H40","v":4920}]
[{"$f":"Costs!A41","v":"Building Exteriors - Paint/Repair"},null,{"$f":"Costs!H41","v":8430.5139500000005},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H41","v":8430.5139500000005},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H41","v":8430.5139500000005}]
[{"$f":"Costs!A42","v":"Windows - Replace"}]
[{"$f":"Costs!A43","v":"Fiber Cement Siding - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H43","v":28316.183200000003}]
[{"$f":"Costs!A44","v":"Asphalt Shingle Roof - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H44","v":20034.02015}]
[{"$f":"Costs!A45","v":"Gutters/Downspouts - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H45","v":3939.0116960000005}]
[{"$f":"Costs!A48","v":"Shade Awnings - Replace Screens"},null,null,null,null,null,null,null,null,{"$f":"Costs!H48","v":5079.5891999999994},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H48","v":5079.5891999999994},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H48","v":5079.5891999999994}]
[{"$f":"Costs!A49","v":"Play Equipment - Replace"},null,null,null,null,{"$f":"Costs!H49","v":56275.440500000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H49","v":56275.440500000004}]
[{"$f":"Costs!A50","v":"Playground Awnings - Replace Screens"},null,null,null,null,null,null,null,{"$f":"Costs!H50","v":13639.547576000001},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H50","v":13639.547576000001},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H50","v":13639.547576000001}]
[{"$f":"Costs!A51","v":"Park Furniture - Replace (13 items)"},null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H51","v":5000},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H51","v":5000}]
[{"$f":"Costs!A52","v":"Drinking Fountains - Replace"},null,null,null,{"$f":"Costs!H52","v":2251.0176200000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H52","v":2251.0176200000001}]
[{"$f":"Costs!A53","v":"Wood Fence - Replace"},null,{"$f":"Costs!H53","v":1125.39654},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H53","v":1125.39654}]
[{"$f":"Costs!A54","v":"Pool Perimeter Fence - Powder Coat"},null,null,null,{"$f":"Costs!H54","v":21385.552159999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H54","v":21385.552159999999}]
[{"$f":"Costs!A55","v":"Pool Deck - Repair/Replace"},null,null,null,null,null,{"$f":"Costs!H55","v":97440},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H55","v":97440}]
[{"$f":"Costs!A56","v":"Pool - Replaster"},null,null,null,null,null,null,null,{"$f":"Costs!H56","v":51529.727139000002},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H56","v":51529.727139000002},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H56","v":51529.727139000002}]
[{"$f":"Costs!A57","v":"Kiddie Pool - Replaster"},null,null,null,null,null,{"$f":"Costs!H57","v":3714.1790730000002},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H57","v":3714.1790730000002},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H57","v":3714.1790730000002}]
[{"$f":"Costs!A58","v":"Pool Filter (2016) - Replace"},null,null,null,null,null,null,null,{"$f":"Costs!H58","v":1294.3351830000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H58","v":1294.3351830000001}]
[{"$f":"Costs!A59","v":"Pool Filters (Old) - Replace"},null,{"$f":"Costs!H59","v":5064.7896449999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H59","v":5064.7896449999998}]
[{"$f":"Costs!A60","v":"Sand Filters - Replace Media"},null,{"$f":"Costs!H60","v":2025.9156520000001},null,null,null,{"$f":"Costs!H60","v":2025.9156520000001},null,null,null,{"$f":"Costs!H60","v":2025.9156520000001},null,null,null,{"$f":"Costs!H60","v":2025.9156520000001},null,null,null,{"$f":"Costs!H60","v":2025.9156520000001},null,null,null,{"$f":"Costs!H60","v":2025.9156520000001},null,null,null,{"$f":"Costs!H60","v":2025.9156520000001},null,null,null,{"$f":"Costs!H60","v":2025.9156520000001}]
[{"$f":"Costs!A61","v":"Pool Pumps - Replace"},null,null,{"$f":"Costs!H61","v":3376.5264299999999},null,null,null,null,{"$f":"Costs!H61","v":3376.5264299999999},null,null,null,null,{"$f":"Costs!H61","v":3376.5264299999999},null,null,null,null,{"$f":"Costs!H61","v":3376.5264299999999},null,null,null,null,{"$f":"Costs!H61","v":3376.5264299999999},null,null,null,null,{"$f":"Costs!H61","v":3376.5264299999999}]
[{"$f":"Costs!A62","v":"Diving Board - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H62","v":13659.0875},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H62","v":13659.0875}]
[{"$f":"Costs!A63","v":"Lifeguard Stands - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H63","v":12000}]
[{"$f":"Costs!A64","v":"Swim Lane Dividers - Replace"},null,{"$f":"Costs!H64","v":2532.3947710000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H64","v":2532.3947710000002}]
[{"$f":"Costs!A65","v":"Pool Coping - Replace"},null,null,null,null,null,null,null,{"$f":"Costs!H65","v":7906.1615499999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H65","v":7906.1615499999998}]
[{"$f":"Costs!A66","v":"Pool Perimeter Fence - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H66","v":31514.275519999999}]
[{"$f":"Costs!A67","v":"Pool Furniture - Replace (66 items)"},null,null,{"$f":"Costs!H67","v":18008.140960000001},null,null,null,null,null,null,null,{"$f":"Costs!H67","v":18008.140960000001},null,null,null,null,null,null,null,{"$f":"Costs!H67","v":18008.140960000001},null,null,null,null,null,null,null,{"$f":"Costs!H67","v":18008.140960000001}]
[{"$f":"Costs!A68","v":"Tennis Courts - Resurface (26,000 GSF)"},null,null,null,null,null,{"$f":"Costs!H68","v":25461.600000000002},null,null,null,null,null,null,{"$f":"Costs!H68","v":25461.600000000002},null,null,null,null,null,null,{"$f":"Costs!H68","v":25461.600000000002},null,null,null,null,null,null,{"$f":"Costs!H68","v":25461.600000000002}]
[{"$f":"Costs!A69","v":"Tennis Court Light Fixtures - Replace"},{"$f":"Costs!H69","v":57797.831999999995},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H69","v":57797.831999999995}]
[{"$f":"Costs!A70","v":"Tennis Court Light Poles - Refurbish"},{"$f":"Costs!H70","v":10184.64},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H70","v":10184.64}]
[{"$f":"Costs!A71","v":"Tennis Chain Link Fence - Replace"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H71","v":30954.013200000001}]
[{"$f":"Costs!A72","v":"Basketball Court - Replace"},null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H72","v":38400}]
[{"$f":"Costs!A73","v":"Basketball Hoop - Replace"},null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H73","v":1200},null,null,null,null,null,null,null,null,null,{"$f":"Costs!H73","v":1200}]
[{"$f":"Costs!A76","v":"HVAC Unit (A) 4Ton- Replace "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H76","v":7315.8072650000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H76","v":7315.8072650000004}]
[{"$f":"Costs!A77","v":"HVAC Unit (B) 4Ton- Replace "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H77","v":7315.8072650000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H77","v":7315.8072650000004}]
[{"$f":"Costs!A78","v":"HVAC Unit (C) 3Ton- Replace "},null,null,null,null,null,null,null,null,{"$f":"Costs!H78","v":5500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Costs!H78","v":5500}]
["Total Cost",{"$f":"SUM(B14:B73)","v":76469.671999999991},27475.536988,21384.667390000002,23636.569779999998,57963.703818000002,287839.240811,7878.5614640000003,256377.91240799997,208192.78636,166025.915652,138770.14095999999,31358.654909999997,68439.886142000003,42518.747006999998,0,192747.63342500001,35913.367616000003,88804.959518999996,87090.549960000004,29119.503684000003,206561.8,19878.352572,60946.302113000005,7751.0176200000005,164000,231246.20044499999,231949.55732000002,173704.66472499998,47671.342194999997,2025.9156520000001]
["Total Cost Adjusted for Inflation",{"$f":"B74*(1+$B$8)^B13","v":76469.671999999991},28299.80309764,22686.993634051003,25828.317985990059,65238.659307389637,333684.56943838677,9407.4144094340809,315312.49414278567,263732.39292157174,216626.16256342563,186495.4654000366,43407.712266781433,97578.912761469415,62440.213433497272,0,300294.53250305844,57630.412263117061,146781.06707496781,148265.83157346954,51061.225972494925,373073.58763353637,36979.591384219086,116779.4172361783,15297.303822336635,333378.23345950589,484178.19080813543,500220.38982697157,385848.26196989248,109068.58314748193,4774.2029435876984]
[]
[]
["Start of year reserve fund Balance",{"$f":"B4","v":726055},{"$f":"B82","v":786709.7956796725},{"$f":"C82","v":900189.62345685193},1024934.0906409498,1152436.3694523647,1245998.236013128,1072107.8016432167,1224407.3121963087,1073092.7061519241,971892.39506900718,917830.80010967806,895150.80198224052,1019525.3801271926,1095212.8294527908,1211445.5530273211,1397219.4421421853,1286445.2244270481,1421366.6726829151,1472644.3109864462,1526782.4728974672,{"$f":"U82","v":1684108.6106862752},1522219.9840749507,1699574.2181507882,1804323.9353035269,2018353.5701029007,1919098.0901001377,1666909.4504600912,1394000.0367017759,1232195.1306435885,1349810.4170640446]
["Annual Fee Revenue",{"$f":"$B$3*$B$6*12","v":114463.00824374135},{"$f":"B79*(1+$B$7)","v":116509.60683113943},118592.7986012802,120713.23784027107,122871.59053285512,125068.53457158255,127304.75996972244,129580.96907798106,131897.87680509535,134256.21084237043,136656.71189223201,{"$f":"L79*(1+$B$7)","v":139100.1339008651},{"$f":"M79*(1+$B$7)","v":141587.24429501256},{"$f":"N79*(1+$B$7)","v":144118.82422300737},{"$f":"O79*(1+$B$7)","v":146695.66880011471},{"$f":"P79*(1+$B$7)","v":149318.58735826076},{"$f":"Q79*(1+$B$7)","v":151988.40370022645},{"$f":"R79*(1+$B$7)","v":154705.95635838649},{"$f":"S79*(1+$B$7)","v":157472.09885807443},{"$f":"T79*(1+$B$7)","v":160287.69998565677},{"$f":"U79*(1+$B$7)","v":163153.64406140029},{"$f":"V79*(1+$B$7)","v":166070.8312172181},{"$f":"W79*(1+$B$7)","v":169040.17767938194},{"$f":"X79*(1+$B$7)","v":172062.61605628926},{"$f":"Y79*(1+$B$7)","v":175139.09563137571},{"$f":"Z79*(1+$B$7)","v":178270.58266126469},{"$f":"AA79*(1+$B$7)","v":181458.0606792481},{"$f":"AB79*(1+$B$7)","v":184702.53080419303},{"$f":"AC79*(1+$B$7)","v":188005.01205497197},{"$f":"AD79*(1+$B$7)","v":191366.54167051485}]
["Investment earnings",{"$f":"(B78+(B78+B79-B81))/2*((1+$B$5/12)^12-1)","v":22661.459435931138},25270.02404368011,28838.66221686867,32617.358957134013,35928.935335297683,34725.600496893028,34402.16499280378,34416.91902042002,30634.205033559396,28308.356761726165,27158.755380367245,28682.156510868532,31679.117792055051,34554.112785020297,39078.220314749509,40201.727429660568,40563.456818757673,43352.749020112366,44931.894626415946,48099.663775645924,48031.316960811506,48262.994242838446,52488.956709535065,57264.322565421164,58983.657825366892,53718.968506824291,45852.915389408219,39340.825107512166,38678.857512966344,43893.46775437687]
["Capital expenditures",{"$f":"B75","v":76469.671999999991},{"$f":"C75","v":28299.80309764},{"$f":"D75","v":22686.993634051003},25828.317985990059,65238.659307389637,333684.56943838677,9407.4144094340809,315312.49414278567,263732.39292157174,216626.16256342563,186495.4654000366,43407.712266781433,97578.912761469415,62440.213433497272,0,300294.53250305844,57630.412263117061,146781.06707496781,148265.83157346954,51061.225972494925,{"$f":"V75","v":373073.58763353637},36979.591384219086,116779.4172361783,15297.303822336635,333378.23345950589,484178.19080813543,500220.38982697157,385848.26196989248,109068.58314748193,4774.2029435876984]
["End of year reserve fund Balance",{"$f":"B78+B79+B80-B81","v":786709.7956796725},{"$f":"C78+C79+C80-C81","v":900189.62345685193},1024934.0906409498,1152436.3694523647,1245998.236013128,1072107.8016432167,1224407.3121963087,1073092.7061519241,971892.39506900718,917830.80010967806,895150.80198224052,1019525.3801271926,1095212.8294527908,1211445.5530273211,1397219.4421421853,1286445.2244270481,1421366.6726829151,1472644.3109864462,1526782.4728974672,1684108.6106862752,{"$f":"V78+V79+V80-V81","v":1522219.9840749507},1699574.2181507882,1804323.9353035269,2018353.5701029007,1919098.0901001377,1666909.4504600912,1394000.0367017759,1232195.1306435885,1349810.4170640446,1580296.2235453485]

{"sheet":"FFB Spread","index":2,"n_rows":77,"n_cols":31,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["$B$78",null,null,null,null,null,null,null,null,null,null,null,null,null,"RESERVE STUDY -",null,null,{"$f":"Costs!$M$56","v":2024}]
[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$75","v":1349810.4170640456}]
[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,1349810.4170640456]
[{"$f":"MID(A1,2,1)","v":"B"}]
[{"$f":"SUBSTITUTE(A1,\"$B$\",\"A\")","v":"A78"}]
[{"$f":"RIGHT(A11,2)","v":"78"},{"$f":"Costs!$M$56","v":2024},{"$f":"B12+1","v":2025},2026,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]
[2200,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 - Repair/Replace"},0,720,1440,2160,2880,3600,4320,5040,5760,6480,7200,720,1440,2160,2880,3600,4320,5040,5760,6480,7200,720,1440,2160,2880,3600,4320,5040,5760,6480]
[{"$f":"Costs!A14","v":"Concrete Walkways - Repair/Replace"},24000,28800,33600,38400,43200,48000,4800,9600,14400,19200,24000,28800,33600,38400,43200,48000,4800,9600,14400,19200,24000,28800,33600,38400,43200,48000,4800,9600,14400,19200]
[{"$f":"Costs!A15","v":"Concrete Parking Lot - Repair"},62400,68640,74880,81120,87360,93600,6240,12480,18720,24960,31200,37440,43680,49920,56160,62400,68640,74880,81120,87360,93600,6240,12480,18720,24960,31200,37440,43680,49920,56160]
[{"$f":"Costs!A16","v":"Wood Fence (A) - Replace"},96470.588235294112,106117.64705882352,115764.70588235294,125411.76470588235,135058.82352941178,144705.88235294117,154352.9411764706,164000,9647.0588235294126,19294.117647058825,28941.176470588234,38588.23529411765,48235.294117647056,57882.352941176468,67529.411764705888,77176.470588235301,86823.529411764699,96470.588235294112,106117.64705882352,115764.70588235294,125411.76470588235,135058.82352941178,144705.88235294117,154352.9411764706,164000,9647.0588235294126,19294.117647058825,28941.176470588234,38588.23529411765,48235.294117647056]
[{"$f":"Costs!A17","v":"Wood Fence (B) - Replace"},86823.529411764699,96470.588235294112,106117.64705882352,115764.70588235294,125411.76470588235,135058.82352941178,144705.88235294117,154352.9411764706,164000,9647.0588235294126,19294.117647058825,28941.176470588234,38588.23529411765,48235.294117647056,57882.352941176468,67529.411764705888,77176.470588235301,86823.529411764699,96470.588235294112,106117.64705882352,115764.70588235294,125411.76470588235,135058.82352941178,144705.88235294117,154352.9411764706,164000,9647.0588235294126,19294.117647058825,28941.176470588234,38588.23529411765]
[{"$f":"Costs!A18","v":"Wood Fence (C) - Replace"},77176.470588235301,86823.529411764699,96470.588235294112,106117.64705882352,115764.70588235294,125411.76470588235,135058.82352941178,144705.88235294117,154352.9411764706,164000,9647.0588235294126,19294.117647058825,28941.176470588234,38588.23529411765,48235.294117647056,57882.352941176468,67529.411764705888,77176.470588235301,86823.529411764699,96470.588235294112,106117.64705882352,115764.70588235294,125411.76470588235,135058.82352941178,144705.88235294117,154352.9411764706,164000,9647.0588235294126,19294.117647058825,28941.176470588234]
[{"$f":"Costs!A19","v":"Wood Fence (D) - Replace"},28396.117647058825,32452.705882352941,36509.294117647056,40565.882352941175,44622.470588235294,48679.058823529413,52735.647058823532,56792.23529411765,60848.823529411762,64905.411764705881,68962,4056.5882352941176,8113.1764705882351,12169.764705882353,16226.35294117647,20282.941176470587,24339.529411764706,28396.117647058825,32452.705882352941,36509.294117647056,40565.882352941175,44622.470588235294,48679.058823529413,52735.647058823532,56792.23529411765,60848.823529411762,64905.411764705881,68962,4056.5882352941176,8113.1764705882351]
[{"$f":"Costs!A20","v":"Brick Columns - Repair"},6753.0528599999989,8103.6634319999994,9454.2740040000008,10804.884576,12155.495147999998,13506.105719999998,1350.610572,2701.2211440000001,4051.8317159999997,5402.4422880000002,6753.0528599999989,8103.6634319999994,9454.2740040000008,10804.884576,12155.495147999998,13506.105719999998,1350.610572,2701.2211440000001,4051.8317159999997,5402.4422880000002,6753.0528599999989,8103.6634319999994,9454.2740040000008,10804.884576,12155.495147999998,13506.105719999998,1350.610572,2701.2211440000001,4051.8317159999997,5402.4422880000002]
[{"$f":"Costs!A21","v":"Parking Spaces - Restripe"},562.75439028571429,844.1315854285715,1125.5087805714286,1406.8859757142857,1688.263170857143,1969.6403660000001,281.37719514285715,562.75439028571429,844.1315854285715,1125.5087805714286,1406.8859757142857,1688.263170857143,1969.6403660000001,281.37719514285715,562.75439028571429,844.1315854285715,1125.5087805714286,1406.8859757142857,1688.263170857143,1969.6403660000001,281.37719514285715,562.75439028571429,844.1315854285715,1125.5087805714286,1406.8859757142857,1688.263170857143,1969.6403660000001,281.37719514285715,562.75439028571429,844.1315854285715]
[{"$f":"Costs!A22","v":"Car Park & BB Light Fixtures - Replace"},4243.6000000000004,282.90666666666669,565.81333333333339,848.72,1131.6266666666668,1414.5333333333333,1697.44,1980.346666666667,2263.2533333333336,2546.1600000000003,2829.0666666666666,3111.9733333333338,3394.88,3677.7866666666669,3960.6933333333341,4243.6000000000004,282.90666666666669,565.81333333333339,848.72,1131.6266666666668,1414.5333333333333,1697.44,1980.346666666667,2263.2533333333336,2546.1600000000003,2829.0666666666666,3111.9733333333338,3394.88,3677.7866666666669,3960.6933333333341]
[{"$f":"Costs!A23","v":"Car Park & BB Poles - Refurbish"},4243.6000000000004,282.90666666666669,565.81333333333339,848.72,1131.6266666666668,1414.5333333333333,1697.44,1980.346666666667,2263.2533333333336,2546.1600000000003,2829.0666666666666,3111.9733333333338,3394.88,3677.7866666666669,3960.6933333333341,4243.6000000000004,282.90666666666669,565.81333333333339,848.72,1131.6266666666668,1414.5333333333333,1697.44,1980.346666666667,2263.2533333333336,2546.1600000000003,2829.0666666666666,3111.9733333333338,3394.88,3677.7866666666669,3960.6933333333341]
[{"$f":"Costs!A24","v":"Monument Signs - Refurbish"},5514.9930248000001,5908.9210980000007,6302.8491712000005,6696.7772444000002,7090.7053175999999,7484.6333907999997,7878.5614640000003,393.92807320000003,787.85614640000006,1181.7842196000001,1575.7122928000001,1969.6403660000001,2363.5684392000003,2757.4965124,3151.4245856000002,3545.3526588,3939.2807320000002,4333.2088051999999,4727.1368784000006,5121.0649516000003,5514.9930248000001,5908.9210980000007,6302.8491712000005,6696.7772444000002,7090.7053175999999,7484.6333907999997,7878.5614640000003,393.92807320000003,787.85614640000006,1181.7842196000001]
[{"$f":"Costs!A25","v":"Cul-de-sac Islands (A) - Irrigation"},1519.4368934999998,2025.9158579999998,2532.3948224999999,3038.8737869999995,3545.3527515000001,4051.8317159999997,4558.3106804999998,5064.7896449999998,5571.2686094999999,6077.7475739999991,6584.2265384999992,7090.7055030000001,7597.1844675000002,8103.6634319999994,8610.1423964999994,9116.6213609999995,9623.1003254999996,10129.57929,506.47896449999996,1012.9579289999999,1519.4368934999998,2025.9158579999998,2532.3948224999999,3038.8737869999995,3545.3527515000001,4051.8317159999997,4558.3106804999998,5064.7896449999998,5571.2686094999999,6077.7475739999991]
[{"$f":"Costs!A26","v":"Cul-de-sac Islands (B) - Irrigation"},1215.5495148,1620.7326864000001,2025.9158579999998,2431.0990296,2836.2822012000001,3241.4653728000003,3646.6485444,4051.8317159999997,4457.0148876000003,4862.1980592,5267.3812307999997,5672.5644024000003,6077.747574,6482.9307456000006,6888.1139171999994,7293.2970888,7698.4802603999997,8103.6634319999994,405.18317160000004,810.36634320000007,1215.5495148,1620.7326864000001,2025.9158579999998,2431.0990296,2836.2822012000001,3241.4653728000003,3646.6485444,4051.8317159999997,4457.0148876000003,4862.1980592]
[{"$f":"Costs!A27","v":"Cul-de-sac Islands (C) - Irrigation"},2025.9158579999998,2431.0990296,2836.2822012000001,3241.4653728000003,3646.6485444,4051.8317159999997,4457.0148876000003,4862.1980592,5267.3812307999997,5672.5644024000003,6077.747574,6482.9307456000006,6888.1139171999994,7293.2970888,7698.4802603999997,8103.6634319999994,405.18317160000004,810.36634320000007,1215.5495148,1620.7326864000001,2025.9158579999998,2431.0990296,2836.2822012000001,3241.4653728000003,3646.6485444,4051.8317159999997,4457.0148876000003,4862.1980592,5267.3812307999997,5672.5644024000003]
[{"$f":"Costs!A30","v":"Surveillance System - Replace"},5304.5,7956.75,10609,13261.25,15913.5,18565.75,21218,23870.25,26522.5,2652.25,5304.5,7956.75,10609,13261.25,15913.5,18565.75,21218,23870.25,26522.5,2652.25,5304.5,7956.75,10609,13261.25,15913.5,18565.75,21218,23870.25,26522.5,2652.25]
[{"$f":"Costs!A31","v":"Interior Lights - Replace"},525.23744466666665,787.85616700000003,1050.4748893333333,1313.0936116666667,1575.7123340000001,1838.3310563333332,2100.9497786666666,2363.5685010000002,2626.1872233333333,2888.8059456666665,3151.4246680000001,3414.0433903333333,3676.6621126666664,3939.280835,262.61872233333332,525.23744466666665,787.85616700000003,1050.4748893333333,1313.0936116666667,1575.7123340000001,1838.3310563333332,2100.9497786666666,2363.5685010000002,2626.1872233333333,2888.8059456666665,3151.4246680000001,3414.0433903333333,3676.6621126666664,3939.280835,262.61872233333332]
[{"$f":"Costs!A32","v":"Hallway Flooring - Replace"},459.72333333333336,689.58500000000015,919.44666666666672,1149.3083333333334,1379.1700000000003,1609.0316666666668,1838.8933333333334,2068.7550000000001,2298.6166666666668,2528.4783333333335,2758.3400000000006,2988.2016666666668,3218.0633333333335,3447.9250000000002,229.86166666666668,459.72333333333336,689.58500000000015,919.44666666666672,1149.3083333333334,1379.1700000000003,1609.0316666666668,1838.8933333333334,2068.7550000000001,2298.6166666666668,2528.4783333333335,2758.3400000000006,2988.2016666666668,3218.0633333333335,3447.9250000000002,229.86166666666668]
[{"$f":"Costs!A33","v":"Indoor Carpet - Replace"},1418.1394319999999,2127.2091479999999,2836.2788639999999,3545.3485799999994,4254.4182959999998,4963.4880119999998,5672.5577279999998,6381.6274439999997,7090.6971599999988,709.06971599999997,1418.1394319999999,2127.2091479999999,2836.2788639999999,3545.3485799999994,4254.4182959999998,4963.4880119999998,5672.5577279999998,6381.6274439999997,7090.6971599999988,709.06971599999997,1418.1394319999999,2127.2091479999999,2836.2788639999999,3545.3485799999994,4254.4182959999998,4963.4880119999998,5672.5577279999998,6381.6274439999997,7090.6971599999988,709.06971599999997]
[{"$f":"Costs!A34","v":"Utility Doors - Partial Replace"},3038.8737869999995,3376.5264299999994,337.65264300000001,675.30528600000002,1012.9579289999999,1350.610572,1688.2632149999997,2025.9158579999998,2363.5685010000002,2701.2211440000001,3038.8737869999995,3376.5264299999994,337.65264300000001,675.30528600000002,1012.9579289999999,1350.610572,1688.2632149999997,2025.9158579999998,2363.5685010000002,2701.2211440000001,3038.8737869999995,3376.5264299999994,337.65264300000001,675.30528600000002,1012.9579289999999,1350.610572,1688.2632149999997,2025.9158579999998,2363.5685010000002,2701.2211440000001]
[{"$f":"Costs!A35","v":"Pool Gates - Repair/Replace"},1238.0597665333335,1350.6106543999999,1463.1615422666666,1575.7124301333336,1688.263318,112.55088786666667,225.10177573333334,337.65266359999998,450.20355146666668,562.75443933333338,675.30532719999997,787.85621506666678,900.40710293333336,1012.9579907999999,1125.5088786666668,1238.0597665333335,1350.6106543999999,1463.1615422666666,1575.7124301333336,1688.263318,112.55088786666667,225.10177573333334,337.65266359999998,450.20355146666668,562.75443933333338,675.30532719999997,787.85621506666678,900.40710293333336,1012.9579907999999,1125.5088786666668]
[{"$f":"Costs!A36","v":"Chairs + Chair Trolleys (2021)"},212.18,318.27000000000004,424.36,530.45000000000005,636.54000000000008,742.63,848.72,954.81000000000006,1060.9000000000001,1166.9900000000002,1273.0800000000002,1379.1700000000003,1485.26,1591.3500000000001,106.09,212.18,318.27000000000004,424.36,530.45000000000005,636.54000000000008,742.63,848.72,954.81000000000006,1060.9000000000001,1166.9900000000002,1273.0800000000002,1379.1700000000003,1485.26,1591.3500000000001,106.09]
[{"$f":"Costs!A37","v":"Tables"},1414.5333333333333,1555.9866666666669,1697.44,1838.8933333333334,1980.346666666667,2121.8000000000002,141.45333333333335,282.90666666666669,424.36,565.81333333333339,707.26666666666665,848.72,990.17333333333352,1131.6266666666668,1273.0800000000002,1414.5333333333333,1555.9866666666669,1697.44,1838.8933333333334,1980.346666666667,2121.8000000000002,141.45333333333335,282.90666666666669,424.36,565.81333333333339,707.26666666666665,848.72,990.17333333333352,1131.6266666666668,1273.0800000000002]
[{"$f":"Costs!A38","v":"Kitchen - Refurbish"},900.40704800000003,1350.610572,1800.8140960000001,2251.0176200000001,2701.2211440000001,3151.4246680000001,3601.6281920000001,4051.8317159999997,4502.0352400000002,4952.2387639999997,5402.4422880000002,5852.6458120000007,6302.8493360000002,6753.0528600000007,7203.2563840000003,7653.4599079999998,8103.6634319999994,8553.8669560000017,9004.0704800000003,450.20352400000002,900.40704800000003,1350.610572,1800.8140960000001,2251.0176200000001,2701.2211440000001,3151.4246680000001,3601.6281920000001,4051.8317159999997,4502.0352400000002,4952.2387639999997]
[{"$f":"Costs!A39","v":"Restrooms - Refurbish"},9510.5494445000004,10242.130171000001,10973.710897500001,11705.291624000001,12436.8723505,13168.453077000002,13900.033803499999,14631.614530000001,731.58072650000008,1463.1614530000002,2194.7421795,2926.3229060000003,3657.9036325000002,4389.484359,5121.0650855000004,5852.6458120000007,6584.226538500001,7315.8072650000004,8047.3879914999998,8778.9687180000001,9510.5494445000004,10242.130171000001,10973.710897500001,11705.291624000001,12436.8723505,13168.453077000002,13900.033803499999,14631.614530000001,731.58072650000008,1463.1614530000002]
[{"$f":"Costs!A40","v":"Interior Surfaces - Repaint"},4428,4920,492,984,1476,1968,2460,2952,3444,3936,4428,4920,492,984,1476,1968,2460,2952,3444,3936,4428,4920,492,984,1476,1968,2460,2952,3444,3936]
[{"$f":"Costs!A41","v":"Building Exteriors - Paint/Repair"},7587.4625550000001,8430.5139500000005,843.05139500000007,1686.1027900000001,2529.1541850000003,3372.2055800000003,4215.2569750000002,5058.3083700000007,5901.3597650000002,6744.4111600000006,7587.4625550000001,8430.5139500000005,843.05139500000007,1686.1027900000001,2529.1541850000003,3372.2055800000003,4215.2569750000002,5058.3083700000007,5901.3597650000002,6744.4111600000006,7587.4625550000001,8430.5139500000005,843.05139500000007,1686.1027900000001,2529.1541850000003,3372.2055800000003,4215.2569750000002,5058.3083700000007,5901.3597650000002,6744.4111600000006]
[{"$f":"Costs!A42","v":"Windows - Replace"},675.30528600000002,844.13160749999986,1012.9579289999999,1181.7842505000001,1350.610572,1519.4368934999998,1688.2632149999997,1857.0895365000001,2025.9158579999998,2194.7421795,2363.5685010000002,2532.3948224999999,2701.2211440000001,2870.0474654999998,3038.8737869999995,3207.7001085000002,3376.5264299999994,3545.3527515000001,3714.1790730000002,3883.0053945,4051.8317159999997,4220.6580374999994,4389.484359,4558.3106804999998,4727.1370020000004,4895.9633235000001,5064.7896449999998,5233.6159664999996,5402.4422880000002,5571.2686094999999]
[{"$f":"Costs!A43","v":"Fiber Cement Siding - Replace"},16989.709920000001,17697.614500000003,18405.519080000002,19113.423660000004,19821.328240000003,20529.232820000001,21237.1374,21945.041980000002,22652.946560000004,23360.851140000002,24068.755720000005,24776.660300000003,25484.564880000002,26192.46946,26900.374040000002,27608.278620000005,28316.183200000007,707.90458000000012,1415.8091600000002,2123.7137400000001,2831.6183200000005,3539.5229000000008,4247.4274800000003,4955.3320600000006,5663.236640000001,6371.1412200000004,7079.0458000000017,7786.9503800000002,8494.8549600000006,9202.7595400000009]
[{"$f":"Costs!A44","v":"Asphalt Shingle Roof - Replace"},10417.690478,11219.051284000001,12020.41209,12821.772896,13623.133701999999,14424.494508,15225.855314,16027.216119999999,16828.576925999998,17629.937731999999,18431.298537999999,19232.659344,20034.02015,801.36080600000003,1602.7216120000001,2404.082418,3205.4432240000001,4006.8040299999998,4808.1648359999999,5609.5256420000005,6410.8864480000002,7212.2472539999999,8013.6080599999996,8814.9688659999993,9616.3296719999998,10417.690478,11219.051284000001,12020.41209,12821.772896,13623.133701999999]
[{"$f":"Costs!A45","v":"Gutters/Downspouts - Replace"},2048.28608192,2205.84654976,2363.4070176000005,2520.9674854400005,2678.5279532800005,2836.0884211200005,2993.6488889600005,3151.2093568000005,3308.7698246400005,3466.3302924800005,3623.8907603200005,3781.45122816,3939.011696,157.56046784000003,315.12093568000006,472.68140352,630.24187136000012,787.80233920000012,945.36280704000001,1102.92327488,1260.4837427200002,1418.0442105600002,1575.6046784000002,1733.1651462400002,1890.72561408,2048.28608192,2205.84654976,2363.4070176000005,2520.9674854400005,2678.5279532800005]
[{"$f":"Costs!A48","v":"Shade Awnings - Replace Screens"},1015.9178399999998,1523.8767599999999,2031.8356799999997,2539.7945999999997,3047.7535199999998,3555.7124399999993,4063.6713599999994,4571.6302799999994,5079.5891999999994,507.95891999999992,1015.9178399999998,1523.8767599999999,2031.8356799999997,2539.7945999999997,3047.7535199999998,3555.7124399999993,4063.6713599999994,4571.6302799999994,5079.5891999999994,507.95891999999992,1015.9178399999998,1523.8767599999999,2031.8356799999997,2539.7945999999997,3047.7535199999998,3555.7124399999993,4063.6713599999994,4571.6302799999994,5079.5891999999994,507.95891999999992]
[{"$f":"Costs!A49","v":"Play Equipment - Replace"},43769.787055555556,46896.200416666667,50022.613777777784,53149.027138888894,56275.440500000004,3126.4133611111115,6252.826722222223,9379.240083333334,12505.653444444446,15632.066805555556,18758.480166666668,21884.893527777778,25011.306888888892,28137.720250000002,31264.133611111112,34390.546972222226,37516.960333333336,40643.373694444454,43769.787055555556,46896.200416666667,50022.613777777784,53149.027138888894,56275.440500000004,3126.4133611111115,6252.826722222223,9379.240083333334,12505.653444444446,15632.066805555556,18758.480166666668,21884.893527777778]
[{"$f":"Costs!A50","v":"Playground Awnings - Replace Screens"},4091.8642728000004,5455.8190304,6819.7737880000004,8183.7285456000009,9547.6833032000013,10911.6380608,12275.5928184,13639.547576000001,1363.9547576,2727.9095152,4091.8642728000004,5455.8190304,6819.7737880000004,8183.7285456000009,9547.6833032000013,10911.6380608,12275.5928184,13639.547576000001,1363.9547576,2727.9095152,4091.8642728000004,5455.8190304,6819.7737880000004,8183.7285456000009,9547.6833032000013,10911.6380608,12275.5928184,13639.547576000001,1363.9547576,2727.9095152]
[{"$f":"Costs!A51","v":"Park Furniture - Replace (13 items)"},0,500,1000,1500,2000,2500,3000,3500,4000,4500,5000,500,1000,1500,2000,2500,3000,3500,4000,4500,5000,500,1000,1500,2000,2500,3000,3500,4000,4500]
[{"$f":"Costs!A52","v":"Drinking Fountains - Replace"},1913.364977,2025.9158579999998,2138.4667390000004,2251.0176200000001,112.550881,225.10176200000001,337.65264300000001,450.20352400000002,562.75440500000002,675.30528600000002,787.85616700000003,900.40704800000003,1012.9579289999999,1125.50881,1238.0596909999999,1350.610572,1463.1614530000002,1575.7123340000001,1688.2632150000002,1800.8140960000001,1913.364977,2025.9158579999998,2138.4667390000004,2251.0176200000001,112.550881,225.10176200000001,337.65264300000001,450.20352400000002,562.75440500000002,675.30528600000002]
[{"$f":"Costs!A53","v":"Wood Fence - Replace"},1069.1267130000001,1125.39654,56.269826999999999,112.539654,168.80948100000001,225.079308,281.34913499999999,337.61896200000001,393.88878899999997,450.15861599999999,506.42844299999996,562.69826999999998,618.96809699999994,675.23792400000002,731.50775099999998,787.77757799999995,844.04740499999991,900.31723199999999,956.58705900000007,1012.8568859999999,1069.1267130000001,1125.39654,56.269826999999999,112.539654,168.80948100000001,225.079308,281.34913499999999,337.61896200000001,393.88878899999997,450.15861599999999]
[{"$f":"Costs!A54","v":"Pool Perimeter Fence - Powder Coat"},17108.441727999998,18534.145205333331,19959.848682666667,21385.552159999999,1425.7034773333332,2851.4069546666665,4277.1104319999995,5702.813909333333,7128.5173866666655,8554.220863999999,9979.9243413333334,11405.627818666666,12831.331295999998,14257.034773333331,15682.738250666667,17108.441727999998,18534.145205333331,19959.848682666667,21385.552159999999,1425.7034773333332,2851.4069546666665,4277.1104319999995,5702.813909333333,7128.5173866666655,8554.220863999999,9979.9243413333334,11405.627818666666,12831.331295999998,14257.034773333331,15682.738250666667]
[{"$f":"Costs!A55","v":"Pool Deck - Repair/Replace"},64960,71456,77952,84448,90944,97440,6496,12992,19488,25984,32480,38976,45472,51968,58464,64960,71456,77952,84448,90944,97440,6496,12992,19488,25984,32480,38976,45472,51968,58464]
[{"$f":"Costs!A56","v":"Pool - Replaster"},15458.918141700002,20611.890855600002,25764.863569500001,30917.836283400004,36070.808997300002,41223.781711200005,46376.754425100007,51529.727139000002,5152.9727139000006,10305.945427800001,15458.918141700002,20611.890855600002,25764.863569500001,30917.836283400004,36070.808997300002,41223.781711200005,46376.754425100007,51529.727139000002,5152.9727139000006,10305.945427800001,15458.918141700002,20611.890855600002,25764.863569500001,30917.836283400004,36070.808997300002,41223.781711200005,46376.754425100007,51529.727139000002,5152.9727139000006,10305.945427800001]
[{"$f":"Costs!A57","v":"Kiddie Pool - Replaster"},1857.0895365000001,2228.5074438000001,2599.9253511000002,2971.3432584000002,3342.7611657000002,3714.1790730000002,371.41790730000002,742.83581460000005,1114.2537219000001,1485.6716292000001,1857.0895365000001,2228.5074438000001,2599.9253511000002,2971.3432584000002,3342.7611657000002,3714.1790730000002,371.41790730000002,742.83581460000005,1114.2537219000001,1485.6716292000001,1857.0895365000001,2228.5074438000001,2599.9253511000002,2971.3432584000002,3342.7611657000002,3714.1790730000002,371.41790730000002,742.83581460000005,1114.2537219000001,1485.6716292000001]
[{"$f":"Costs!A58","v":"Pool Filter (2016) - Replace"},690.31209760000013,776.60110980000002,862.89012200000013,949.17913420000014,1035.4681464,1121.7571586000001,1208.0461708000003,1294.3351830000001,86.289012200000016,172.57802440000003,258.86703660000001,345.15604880000006,431.44506100000007,517.73407320000001,604.02308540000013,690.31209760000013,776.60110980000002,862.89012200000013,949.17913420000014,1035.4681464,1121.7571586000001,1208.0461708000003,1294.3351830000001,86.289012200000016,172.57802440000003,258.86703660000001,345.15604880000006,431.44506100000007,517.73407320000001,604.02308540000013]
[{"$f":"Costs!A59","v":"Pool Filters (Old) - Replace"},4727.1370020000004,5064.7896449999998,337.65264300000001,675.30528600000002,1012.9579289999999,1350.610572,1688.2632149999999,2025.9158579999998,2363.5685010000002,2701.2211440000001,3038.8737869999995,3376.5264299999999,3714.1790729999998,4051.8317159999997,4389.4843589999991,4727.1370020000004,5064.7896449999998,337.65264300000001,675.30528600000002,1012.9579289999999,1350.610572,1688.2632149999999,2025.9158579999998,2363.5685010000002,2701.2211440000001,3038.8737869999995,3376.5264299999999,3714.1790729999998,4051.8317159999997,4389.4843589999991]
[{"$f":"Costs!A60","v":"Sand Filters - Replace Media"},1519.4367390000002,2025.9156520000001,506.47891300000003,1012.9578260000001,1519.4367390000002,2025.9156520000001,506.47891300000003,1012.9578260000001,1519.4367390000002,2025.9156520000001,506.47891300000003,1012.9578260000001,1519.4367390000002,2025.9156520000001,506.47891300000003,1012.9578260000001,1519.4367390000002,2025.9156520000001,506.47891300000003,1012.9578260000001,1519.4367390000002,2025.9156520000001,506.47891300000003,1012.9578260000001,1519.4367390000002,2025.9156520000001,506.47891300000003,1012.9578260000001,1519.4367390000002,2025.9156520000001]
[{"$f":"Costs!A61","v":"Pool Pumps - Replace"},2025.9158579999998,2701.2211440000001,3376.5264299999994,675.30528600000002,1350.610572,2025.9158579999998,2701.2211440000001,3376.5264299999994,675.30528600000002,1350.610572,2025.9158579999998,2701.2211440000001,3376.5264299999994,675.30528600000002,1350.610572,2025.9158579999998,2701.2211440000001,3376.5264299999994,675.30528600000002,1350.610572,2025.9158579999998,2701.2211440000001,3376.5264299999994,675.30528600000002,1350.610572,2025.9158579999998,2701.2211440000001,3376.5264299999994,675.30528600000002,1350.610572]
[{"$f":"Costs!A62","v":"Diving Board - Replace"},2731.8174999999997,3642.4233333333332,4553.0291666666662,5463.6349999999993,6374.2408333333333,7284.8466666666664,8195.4524999999994,9106.0583333333325,10016.664166666666,10927.269999999999,11837.875833333332,12748.481666666667,13659.0875,910.60583333333329,1821.2116666666666,2731.8174999999997,3642.4233333333332,4553.0291666666662,5463.6349999999993,6374.2408333333333,7284.8466666666664,8195.4524999999994,9106.0583333333325,10016.664166666666,10927.269999999999,11837.875833333332,12748.481666666667,13659.0875,910.60583333333329,1821.2116666666666]
[{"$f":"Costs!A63","v":"Lifeguard Stands - Replace"},0,800,1600,2400,3200,4000,4800,5600,6400,7200,8000,8800,9600,10400,11200,12000,800,1600,2400,3200,4000,4800,5600,6400,7200,8000,8800,9600,10400,11200]
[{"$f":"Costs!A64","v":"Swim Lane Dividers - Replace"},2363.5684529333334,2532.3947710000002,168.82631806666669,337.65263613333337,506.47895420000003,675.30527226666675,844.13159033333329,1012.9579084000001,1181.7842264666667,1350.6105445333335,1519.4368626,1688.2631806666666,1857.0894987333336,2025.9158168000001,2194.7421348666671,2363.5684529333334,2532.3947710000002,168.82631806666669,337.65263613333337,506.47895420000003,675.30527226666675,844.13159033333329,1012.9579084000001,1181.7842264666667,1350.6105445333335,1519.4368626,1688.2631806666666,1857.0894987333336,2025.9158168000001,2194.7421348666671]
[{"$f":"Costs!A65","v":"Pool Coping - Replace"},5139.0050074999999,5534.3130849999998,5929.6211624999996,6324.9292399999995,6720.2373175000002,7115.5453949999992,7510.8534725000009,7906.1615499999998,395.30807749999997,790.61615499999994,1185.9242325,1581.2323099999999,1976.5403875,2371.848465,2767.1565424999999,3162.4646199999997,3557.7726974999996,3953.0807749999999,4348.3888525000002,4743.6969300000001,5139.0050074999999,5534.3130849999998,5929.6211624999996,6324.9292399999995,6720.2373175000002,7115.5453949999992,7510.8534725000009,7906.1615499999998,395.30807749999997,790.61615499999994]
[{"$f":"Costs!A66","v":"Pool Perimeter Fence - Replace"},17858.089461333333,18908.565311999999,19959.041162666668,21009.517013333334,22059.992863999996,23110.468714666666,24160.944565333331,25211.420416000001,26261.896266666667,27312.372117333332,28362.847967999998,29413.323818666668,30463.799669333333,31514.275519999999,1050.4758506666667,2100.9517013333334,3151.4275520000001,4201.9034026666668,5252.3792533333335,6302.8551040000002,7353.3309546666669,8403.8068053333336,9454.2826559999994,10504.758506666667,11555.234357333333,12605.710208,13656.186058666666,14706.661909333334,15757.13776,16807.613610666667]
[{"$f":"Costs!A67","v":"Pool Furniture - Replace (66 items)"},13506.10572,15757.12334,18008.140960000001,2251.0176200000001,4502.0352400000002,6753.0528599999998,9004.0704800000003,11255.088100000001,13506.10572,15757.12334,18008.140960000001,2251.0176200000001,4502.0352400000002,6753.0528599999998,9004.0704800000003,11255.088100000001,13506.10572,15757.12334,18008.140960000001,2251.0176200000001,4502.0352400000002,6753.0528599999998,9004.0704800000003,11255.088100000001,13506.10572,15757.12334,18008.140960000001,2251.0176200000001,4502.0352400000002,6753.0528599999998]
[{"$f":"Costs!A68","v":"Tennis Courts - Resurface (26,000 GSF)"},7274.7428571428582,10912.114285714286,14549.485714285716,18186.857142857145,21824.228571428572,25461.600000000002,3637.3714285714291,7274.7428571428582,10912.114285714286,14549.485714285716,18186.857142857145,21824.228571428572,25461.600000000002,3637.3714285714291,7274.7428571428582,10912.114285714286,14549.485714285716,18186.857142857145,21824.228571428572,25461.600000000002,3637.3714285714291,7274.7428571428582,10912.114285714286,14549.485714285716,18186.857142857145,21824.228571428572,25461.600000000002,3637.3714285714291,7274.7428571428582,10912.114285714286]
[{"$f":"Costs!A69","v":"Tennis Court Light Fixtures - Replace"},57797.832000000002,3853.1887999999994,7706.3775999999989,11559.5664,15412.755199999998,19265.944,23119.132799999999,26972.321599999999,30825.510399999996,34678.699199999995,38531.887999999999,42385.076800000003,46238.265599999999,50091.454399999995,53944.643199999999,57797.832000000002,3853.1887999999994,7706.3775999999989,11559.5664,15412.755199999998,19265.944,23119.132799999999,26972.321599999999,30825.510399999996,34678.699199999995,38531.887999999999,42385.076800000003,46238.265599999999,50091.454399999995,53944.643199999999]
[{"$f":"Costs!A70","v":"Tennis Court Light Poles - Refurbish"},10184.639999999998,678.976,1357.952,2036.9279999999999,2715.904,3394.8799999999997,4073.8559999999998,4752.8319999999994,5431.808,6110.7839999999997,6789.7599999999993,7468.7359999999999,8147.7119999999995,8826.6880000000001,9505.6639999999989,10184.639999999998,678.976,1357.952,2036.9279999999999,2715.904,3394.8799999999997,4073.8559999999998,4752.8319999999994,5431.808,6110.7839999999997,6789.7599999999993,7468.7359999999999,8147.7119999999995,8826.6880000000001,9505.6639999999989]
[{"$f":"Costs!A71","v":"Tennis Chain Link Fence - Replace"},15477.006600000001,16508.80704,17540.607480000002,18572.407920000001,19604.208360000001,20636.0088,21667.809239999999,22699.609680000001,23731.41012,24763.21056,25795.011000000002,26826.811440000001,27858.61188,28890.412320000003,29922.212760000002,30954.013200000001,1031.80044,2063.60088,3095.4013199999999,4127.2017599999999,5159.0021999999999,6190.8026399999999,7222.6030800000008,8254.4035199999998,9286.2039600000007,10318.0044,11349.804840000001,12381.60528,13413.405720000001,14445.206160000002]
[{"$f":"Costs!A72","v":"Basketball Court - Replace"},28800,29760,30720,31680,32640,33600,34560,35520,36480,37440,38400,960,1920,2880,3840,4800,5760,6720,7680,8640,9600,10560,11520,12480,13440,14400,15360,16320,17280,18240]
[{"$f":"Costs!A73","v":"Basketball Hoop - Replace"},0,120,240,360,480,600,720,840,960,1080,1200,120,240,360,480,600,720,840,960,1080,1200,120,240,360,480,600,720,840,960,1080]
[{"$f":"Costs!A76","v":"HVAC Unit (A) 4Ton- Replace "},1950.8819373333333,2438.6024216666669,2926.3229060000003,3414.0433903333333,3901.7638746666667,4389.484359,4877.2048433333339,5364.9253276666668,5852.6458120000007,6340.3662963333336,6828.0867806666665,7315.8072650000004,487.72048433333333,975.44096866666666,1463.1614530000002,1950.8819373333333,2438.6024216666669,2926.3229060000003,3414.0433903333333,3901.7638746666667,4389.484359,4877.2048433333339,5364.9253276666668,5852.6458120000007,6340.3662963333336,6828.0867806666665,7315.8072650000004,487.72048433333333,975.44096866666666,1463.1614530000002]
[{"$f":"Costs!A77","v":"HVAC Unit (B) 4Ton- Replace "},1950.8819373333333,2438.6024216666669,2926.3229060000003,3414.0433903333333,3901.7638746666667,4389.484359,4877.2048433333339,5364.9253276666668,5852.6458120000007,6340.3662963333336,6828.0867806666665,7315.8072650000004,487.72048433333333,975.44096866666666,1463.1614530000002,1950.8819373333333,2438.6024216666669,2926.3229060000003,3414.0433903333333,3901.7638746666667,4389.484359,4877.2048433333339,5364.9253276666668,5852.6458120000007,6340.3662963333336,6828.0867806666665,7315.8072650000004,487.72048433333333,975.44096866666666,1463.1614530000002]
[{"$f":"Costs!A78","v":"HVAC Unit (C) 3Ton- Replace "},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,3300,3666.6666666666665,4033.3333333333335,4400,4766.666666666667,5133.333333333333,5500,366.66666666666669,733.33333333333337,1100,1466.6666666666667,1833.3333333333333,2200]
["Total FFB",{"$f":"SUM(B14:B73)","v":795322.81643542368},814342.16411563847,882355.64680785278,956459.99909806706,1028312.448998282,1065837.7648604964,873487.54372971063,961098.00194592471,800209.10921813908,687505.34253835375,616968.44656656811,573687.32528678223,637817.69005699677,664866.82359521138,717837.09626842581,813326.11594864004,716067.50220385473,775643.15426806873,782327.21442928293,790725.68414949765,857095.20014571224,746022.41982592666,821633.08693414123,856175.80450135539,943913.80656157003,875402.82624178438,739645.64547699864,603185.10783721309,524969.46279242763,572787.14027764183]
["Total FFB Adjusted for Inflation",{"$f":"B74*(1+'Cash Flow'!$B$8)^B13","v":795322.81643542368},{"$f":"C74*(1+'Cash Flow'!$B$8)^C13","v":838772.42903910764},{"$f":"D74*(1+'Cash Flow'!$B$8)^D13","v":936091.10569845093},{"$f":"E74*(1+'Cash Flow'!$B$8)^E13","v":1045149.6654344335},{"$f":"F74*(1+'Cash Flow'!$B$8)^F13","v":1157374.720780242},{"$f":"G74*(1+'Cash Flow'!$B$8)^G13","v":1235598.0882126328},{"$f":"H74*(1+'Cash Flow'!$B$8)^H13","v":1042989.8075799362},{"$f":"I74*(1+'Cash Flow'!$B$8)^I13","v":1182029.3147053537},{"$f":"J74*(1+'Cash Flow'!$B$8)^J13","v":1013680.9584113737},{"$f":"K74*(1+'Cash Flow'!$B$8)^K13","v":897038.53468338307},{"$f":"L74*(1+'Cash Flow'!$B$8)^L13","v":829154.00087930949},{"$f":"M74*(1+'Cash Flow'!$B$8)^M13","v":794117.42686727666},{"$f":"N74*(1+'Cash Flow'!$B$8)^N13","v":909375.51542184479},{"$f":"O74*(1+'Cash Flow'!$B$8)^O13","v":976379.34540502168},{"$f":"P74*(1+'Cash Flow'!$B$8)^P13","v":1085793.0159354501},{"$f":"Q74*(1+'Cash Flow'!$B$8)^Q13","v":1267135.5877184365},{"$f":"R74*(1+'Cash Flow'!$B$8)^R13","v":1149078.1316159107},{"$f":"S74*(1+'Cash Flow'!$B$8)^S13","v":1282019.9510197695},{"$f":"T74*(1+'Cash Flow'!$B$8)^T13","v":1331859.7145521303},{"$f":"U74*(1+'Cash Flow'!$B$8)^U13","v":1386542.2734796754},{"$f":"V74*(1+'Cash Flow'!$B$8)^V13","v":1548009.2701644001},{"$f":"W74*(1+'Cash Flow'!$B$8)^W13","v":1387821.4579757536},{"$f":"X74*(1+'Cash Flow'!$B$8)^X13","v":1574333.958707314},{"$f":"Y74*(1+'Cash Flow'!$B$8)^Y13","v":1689737.0189168435},{"$f":"Z74*(1+'Cash Flow'!$B$8)^Z13","v":1918782.4229849633},{"$f":"AA74*(1+'Cash Flow'!$B$8)^AA13","v":1832899.1171419709},{"$f":"AB74*(1+'Cash Flow'!$B$8)^AB13","v":1595113.3401125227},{"$f":"AC74*(1+'Cash Flow'!$B$8)^AC13","v":1339848.4483624501},{"$f":"AD74*(1+'Cash Flow'!$B$8)^AD13","v":1201092.162839717},{"$f":"AE74*(1+'Cash Flow'!$B$8)^AE13","v":1349810.4170640456}]
[]
["Reserve Fund Strength",{"$f":"'Cash Flow'!B78/'FFB Spread'!B75","v":0.91290603638673817},{"$f":"'Cash Flow'!C78/'FFB Spread'!C75","v":0.93792996579647026},{"$f":"'Cash Flow'!D78/'FFB Spread'!D75","v":0.96164744860511031},{"$f":"'Cash Flow'!E78/'FFB Spread'!E75","v":0.9806577225616},{"$f":"'Cash Flow'!F78/'FFB Spread'!F75","v":0.99573314395138324},{"$f":"'Cash Flow'!G78/'FFB Spread'!G75","v":1.00841709606037},{"$f":"'Cash Flow'!H78/'FFB Spread'!H75","v":1.0279178126686046},{"$f":"'Cash Flow'!I78/'FFB Spread'!I75","v":1.0358519005947993},{"$f":"'Cash Flow'!J78/'FFB Spread'!J75","v":1.0586099080263476},{"$f":"'Cash Flow'!K78/'FFB Spread'!K75","v":1.0834455349368513},{"$f":"'Cash Flow'!L78/'FFB Spread'!L75","v":1.1069485272172934},{"$f":"'Cash Flow'!M78/'FFB Spread'!M75","v":1.1272272483850803},{"$f":"'Cash Flow'!N78/'FFB Spread'!N75","v":1.1211269303355402},{"$f":"'Cash Flow'!O78/'FFB Spread'!O75","v":1.1217083140963768},{"$f":"'Cash Flow'!P78/'FFB Spread'!P75","v":1.1157242082494119},{"$f":"'Cash Flow'!Q78/'FFB Spread'!Q75","v":1.1026597750742473},{"$f":"'Cash Flow'!R78/'FFB Spread'!R75","v":1.1195454765273121},{"$f":"'Cash Flow'!S78/'FFB Spread'!S75","v":1.1086930991614472},{"$f":"'Cash Flow'!T78/'FFB Spread'!T75","v":1.1057052742838296},{"$f":"'Cash Flow'!U78/'FFB Spread'!U75","v":1.1011438324673968},{"$f":"'Cash Flow'!V78/'FFB Spread'!V75","v":1.0879189441206778},{"$f":"'Cash Flow'!W78/'FFB Spread'!W75","v":1.0968413662483847},{"$f":"'Cash Flow'!X78/'FFB Spread'!X75","v":1.0795512659501476},{"$f":"'Cash Flow'!Y78/'FFB Spread'!Y75","v":1.06781346156465},{"$f":"'Cash Flow'!Z78/'FFB Spread'!Z75","v":1.0518928805711276},{"$f":"'Cash Flow'!AA78/'FFB Spread'!AA75","v":1.0470287601494273},{"$f":"'Cash Flow'!AB78/'FFB Spread'!AB75","v":1.0450100369309832},{"$f":"'Cash Flow'!AC78/'FFB Spread'!AC75","v":1.040416204090477},{"$f":"'Cash Flow'!AD78/'FFB Spread'!AD75","v":1.0258955713526057},{"$f":"'Cash Flow'!AE78/'FFB Spread'!AE75","v":0.99999999999999933}]