{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Financial Data","Reserve Components","Special Projects","Categories","Data Validation Sheet"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Instructions"]
[]
[null,"Item #","Description"]
[null,1,"Enter the reserve component inventory data.  If you are unsure of any data, leave the field blank.  "]
[null,2,"Enter the association's basic financial data.  If you unsure of any data or if the information is not available, leave the field blank."]
[null,3,"Save the workbook using a new file name.  Remember the name and directory where you are saving the workbook."]
[null,4,"With this workbook and the RFA both open, you can now copy and paste the data.  To perform this action, select the cell(s) in this workbook and right click and then select \"Copy\" (or press Ctrl-C).  "]
[null,5,"Then select the cell(s) in the RFA.  DO NOT click \"Paste\" or press Ctrl-V.  Once the target cell(s) is(are) selected, right click the cell and choose the \"123\" icon in the Paste Options section.  This pastes the value themselves and does not paste the format.  Alternatively, you can right click and choose \"Paste Special\" and then choose \"Value\".\n\nIf you perform a simple paste you will lose the formatting in the RFA workbook. "]

{"sheet":"Financial Data","index":1,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,3,8,4],[9,3,9,4],[7,3,7,4],[7,7,7,11]]}
[]
[null,"Association Basic Financial Data"]
[]
[]
[]
[]
[]
[null,"Data Item","Description","Data Entry",null,null,null,"Other Annual Incomes (Enter any other annual incomes here)"]
[null,1,"Association Name:",null,null,null,null,"Start Year","End Year","Amount","Annual % Incr","Description"]
[null,2,"Association City / State:",null,null,null,null,"Must be >=","If no end yr","Enter annual","Enter 0 if no"]
[null,3,"# Units:",null,null,null,null,"start year","enter 0","amount","increase yr to yr","Enter short description (25 chars max)"]
[null,4,"Start Year for Financial Analysis:",null,null,null,1]
[null,5,{"$f":" \"Reserve Fund Balance at Start of Year \" & startyear & \":\"","v":"Reserve Fund Balance at Start of Year :"},null,null,null,2]
[null,6,"Interest Earned on Reserve Balance:",null,null,null,3]
[null,null,null,null,null,null,4]
[null,7,{"$f":" \"Operations Fund Balance at Start of Year \" & startyear & \":\"","v":"Operations Fund Balance at Start of Year :"},null,null,null,5]
[null,null,null,null,null,null,6]
[null,8,{"$f":" \"Enter Total Taxes Paid in Year \" & startyear -1 & \":\"","v":"Enter Total Taxes Paid in Year -1:"},null,null,null,7]
[null,null,null,"Leave blank if you include taxes in the operational expenses.",null,null,8]
[null,9,{"$f":"\"Maintenance Assessments Received in Year \"&startyear-1&\":\"","v":"Maintenance Assessments Received in Year -1:"},null,null,null,9]
[null,null,null,null,null,null,10]
[null,10,{"$f":"\"Operating Expenses Incurred in Year \"&startyear-1&\":\"","v":"Operating Expenses Incurred in Year -1:"}]
[]
[null,11,"Reserve Expense (CAPEX) Inflation:"]
[null,12,"Long-Term Operating Expense (OPEX) Inflation:"]
[null,13,"Short Term OPEX Inflation:"]

{"sheet":"Reserve Components","index":2,"n_rows":261,"n_cols":16,"rows_kept":261,"cut":false,"hidden":false,"merged":[[9,11,9,12],[1,15,3,16],[5,13,6,16]]}
[]
[null,"Reserve Component Inventory ",null,null,null,null,null,null,null,null,null,null,null,null,null,"The asset's Remaining Useful Life and the Next Service Year is based on this year."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(startyear = \"\",\"You must enter a value for the Start Year on the Financial Data sheet to calculate the Remaining Useful Life and the Next Service Year\",\"The Start Year for Analysis is \" & startyear)","v":"You must enter a value for the Start Year on the Financial Data sheet to calculate the Remaining Useful Life and the Next Service Year"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"--- These Fields Optional ---"]
[null,"Item #","User Heading 1","User Heading 2","Indicate if Structure Integrity","Category\n(18 chars max)","Reserve Component Name\n(35 chars max)\nAvoid Duplicate Names","Replacement Cost","Year Last Serviced","Est\nUseful Life\n(yrs)","Replacement\nCost Basis","Qty\n(Optional)","Unit of\nMeasure\n(Optional)",null,"Remaining Useful Life","Next Service Yr"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(OR(startyear=\"\",I12=\"\"),\"\",IF(startyear<I12,I12-startyear,MAX(0,I12+J12-startyear)))","v":""},{"$f":"IF(OR(startyear=\"\",I12=\"\"),\"\",IF(startyear<I12,I12,startyear+$O12))","v":""}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,8,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,9,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,10,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,11,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,12,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,13,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,14,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,15,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,16,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,17,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,18,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,19,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,20,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,21,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,22,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,23,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,24,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,25,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,26,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,27,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,28,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,29,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,30,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,31,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,32,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,33,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,34,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,35,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,36,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,37,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,38,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,39,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,40,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,41,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,42,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,43,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,44,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,45,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,46,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,47,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,48,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,49,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,50,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,51,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,52,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,53,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,54,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,55,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,56,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,57,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,58,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,59,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,60,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,61,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,62,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,63,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,64,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,65,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(OR(startyear=\"\",I76=\"\"),\"\",IF(startyear<I76,I76-startyear,MAX(0,I76+J76-startyear)))","v":""},{"$f":"IF(OR(startyear=\"\",I76=\"\"),\"\",IF(startyear<I76,I76,startyear+$O76))","v":""}]
[null,66,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,67,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,68,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,69,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,70,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,71,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,72,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,73,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,74,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,75,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,76,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,77,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,78,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,79,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,80,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,81,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,82,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,83,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,84,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,85,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,86,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,87,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,88,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,89,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,90,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,91,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,92,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,93,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,94,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,95,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,96,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,97,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,98,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,99,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,100,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,101,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,102,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,103,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,104,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,105,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,106,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,107,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,108,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,109,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,110,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,111,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,112,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,113,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,114,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,115,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,116,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,117,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,118,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,119,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,120,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,121,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,122,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,123,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,124,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,125,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,126,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,127,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,128,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,129,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(OR(startyear=\"\",I140=\"\"),\"\",IF(startyear<I140,I140-startyear,MAX(0,I140+J140-startyear)))","v":""},{"$f":"IF(OR(startyear=\"\",I140=\"\"),\"\",IF(startyear<I140,I140,startyear+$O140))","v":""}]
[null,130,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,131,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,132,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,133,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,134,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,135,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,136,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,137,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,138,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,139,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,140,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,141,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,142,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,143,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,144,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,145,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,146,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,147,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,148,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,149,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,150,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,151,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,152,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,153,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,154,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,155,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,156,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,157,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,158,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,159,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,160,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,161,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,162,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,163,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,164,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,165,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,166,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,167,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,168,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,169,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,170,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,171,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,172,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,173,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,174,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,175,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,176,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,177,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,178,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,179,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,180,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,181,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,182,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,183,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,184,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,185,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,186,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,187,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,188,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,189,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,190,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,191,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,192,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,193,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(OR(startyear=\"\",I204=\"\"),\"\",IF(startyear<I204,I204-startyear,MAX(0,I204+J204-startyear)))","v":""},{"$f":"IF(OR(startyear=\"\",I204=\"\"),\"\",IF(startyear<I204,I204,startyear+$O204))","v":""}]
[null,194,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,195,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,196,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,197,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,198,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,199,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,200,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,201,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,202,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,203,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,204,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,205,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,206,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,207,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,208,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,209,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,210,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,211,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,212,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,213,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,214,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,215,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,216,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,217,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,218,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,219,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,220,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,221,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,222,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,223,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,224,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,225,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,226,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,227,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,228,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,229,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,230,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,231,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,232,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,233,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,234,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,235,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,236,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,237,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,238,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,239,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,240,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,241,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,242,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,243,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,244,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,245,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,246,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,247,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,248,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,249,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,250,null,null,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"Special Projects","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"Special Projects and One-Time Expenses"]
[]
[null,null,"Item #","Project or Expense Description\n(Maximum of 30 characters)","Estimated Cost\n(Note:  Inflation will not be applied for future years)","Year"]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]

{"sheet":"Categories","index":4,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Reserve Component Categories"]
[]
[null,"Asset Categories","Text Length\n(18 char max)"]
[null,"Access / Egress",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":15}]
[null,"Appliances",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":10}]
[null,"Balconies",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":9}]
[null,"Common Exterior",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":15}]
[null,"Common Interior",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":15}]
[null,"Discretionary",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":13}]
[null,"Doors",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":5}]
[null,"Doors - Exterior",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":16}]
[null,"Doors - Interior",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":16}]
[null,"Electrical",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":10}]
[null,"Elevators",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":9}]
[null,"Fences/Railings",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":15}]
[null,"Fire Safety",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":11}]
[null,"Floors - Exterior",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":17}]
[null,"Floors - Interior",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":17}]
[null,"Framing",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":7}]
[null,"Gas",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":3}]
[null,"HVAC",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":4}]
[null,"Landsacping",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":11}]
[null,"Miscellaneous",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":13}]
[null,"Other",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":5}]
[null,"Painting",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":8}]
[null,"Painting - Ext",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":14}]
[null,"Painting - Int",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":14}]
[null,"Plumbing",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":8}]
[null,"Plumbing - Ext",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":14}]
[null,"Plumbing - Int",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":14}]
[null,"Pool/Spa",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":8}]
[null,"Recreation",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":10}]
[null,"Roads / Parking",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":15}]
[null,"Roofing",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":7}]
[null,"Sanitary Waste",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":14}]
[null,"Sidewalks/Curbing",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":17}]
[null,"Signage",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":7}]
[null,"Stairs, Rails",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":13}]
[null,"Sump Pumps",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":10}]
[null,"Utilities",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":9}]
[null,"Ventilation",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":11}]
[null,"Walls",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":5}]
[null,"Walls - Exterior",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":16}]
[null,"Walls - Interior",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":16}]
[null,"Windows",{"$f":" LEN(Table2[[#This Row],[Asset Categories]])","v":7}]

{"sheet":"Data Validation Sheet","index":5,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Unit of Measure"]
[null,"acre"]
[null,"centimeter"]
[null,"cm"]
[null,"cubic foot"]
[null,"cubic inch"]
[null,"cubic meter"]
[null,"each"]
[null,"foot"]
[null,"ft"]
[null,"g"]
[null,"gallon"]
[null,"gram"]
[null,"hectare"]
[null,"in"]
[null,"inch"]
[null,"kg"]
[null,"kilogram"]
[null,"kilometer"]
[null,"km"]
[null,"liter"]
[null,"litre"]
[null,"lump sum"]
[null,"m"]
[null,"meter"]
[null,"metre"]
[null,"mile"]
[null,"other"]
[null,"pound"]
[null,"sq-ft"]
[null,"sq-m"]
[null,"square feet"]
[null,"square inch"]
[null,"square meter"]
[null,"square yard"]
[null,"sq-yd"]
[null,"ton"]
[null,"tonne"]