{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Project Summary","Narrative","Inspected Units","Site","Architectural","Mech & Electric","Dwelling Units","Executive Summary","Photos","Photos (1)","Change History","Controls"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":69,"comments":11,"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":"Project Summary","index":0,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[26,9,26,11],[22,1,22,2],[23,3,23,4],[22,9,22,11],[22,3,22,4],[23,1,23,2],[25,1,25,2],[26,1,26,2],[24,3,24,4],[25,3,25,4],[24,1,24,2],[1,0,1,11],[6,1,6,5],[6,7,6,11],[8,3,8,5],[9,3,9,5],[2,0,2,11],[8,9,8,11],[9,9,9,11],[14,9,14,11],[10,9,10,11],[14,3,14,5],[17,7,17,11],[17,1,17,5],[10,3,10,5],[11,3,11,5],[13,3,13,5],[11,9,11,11],[13,9,13,11],[19,9,19,11],[20,9,20,11],[20,1,20,2],[21,1,21,2],[31,9,31,11],[24,9,24,11],[28,7,28,11],[25,9,25,11],[30,9,30,11],[20,3,20,4],[21,3,21,4],[19,3,19,4],[26,3,26,4],[27,3,27,4],[21,9,21,11],[27,1,27,2]]}
[]
["Capital Needs Assessment"]
["Project Summary"]
[]
["Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},null,null,null,null,null,null,null,"Date:",{"$f":"TODAY()","v":"2017-05-01"}]
[]
[null,"Provider",null,null,null,null,null,"Owner"]
[]
[null,null,"Name:",null,null,null,null,null,"Name:"]
[null,null,"Addr1:",null,null,null,null,null,"Addr1:"]
[null,null,"Addr2:",null,null,null,null,null,"Addr2:"]
[null,null,"City:",null,null,null,null,null,"City:"]
[null,null,"State:",null,"Zip Code:",null,null,null,"State:",null,"Zip Code:"]
[null,null,"Phone:",null,null,null,null,null,"Phone:"]
[null,null,"Email:",null,null,null,null,null,"Email:"]
[]
[]
[null,"Site Information / Unit Mix",null,null,null,null,null,"Project"]
[]
[null,null,"Type:","Family",null,null,null,null,"Name:"]
[null,"Year Built:",null,null,null,null,null,null,"Addr1:"]
[null,"Last Renovated:",null,null,null,null,null,null,"Addr2:"]
[null,"1 Bedroom Apts:",null,null,null,null,null,null,"City:"]
[null,"2 Bedroom Apts:",null,null,null,null,null,null,"State:",null,"Zip Code:"]
[null,"3 Bedroom Apts:",null,null,null,null,null,null,"County:"]
[null,"4 Bedroom Apts:",null,null,null,null,null,null,"Phone:"]
[null,"Fully Acc. Apts",null,null,null,null,null,null,"Email:"]
[null,"Total Dwelling Units:"]
[null,null,null,null,null,null,null,"Inspection Report"]
[]
[null,null,null,null,null,null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,"Inspector:"]

{"sheet":"Narrative","index":1,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,0,1,2],[2,0,2,2]]}
[]
["Capital Needs Assessment"]
["Narrative"]
[]
["Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},"Date:",{"$f":"ReportDate","v":"2017-05-01"}]
[]
[]
[null,"Double Click Here to insert the Narrative-->"]
[]
[]
[]
[null,"Instruction - Double click on the Microsoft Word Document link (above) to insert the narrative section in accordance with the categories listed below:"]
[]
[null,"Capital Needs Summary -  Include a general description of the property and purpose of the assessment. Summarize the total budget for capital needs, including funds needed in the reserve account and funds from any third party source. Explain which property components will absorb a majority of the needed funds."]
[]
[null,"Health and Safety - Include specific items that must be remedied immediately.  Such items as an inoperable central fire alarm system, missing / unsecured railings, blocked / inadequate fire egress, or property wide rodent infestation would be entered here."]
[]
[null,"Site - Include specific site amenities, such as walks and fencing, that need to be specially maintained, repaired, replaced, or improved immediately or during the 20-year long term schedule. Describe the condition of the items and when the appropriate actions are needed."]
[]
[null,"Architectural - Include specific architectural elements, such as roofing and interior common areas, that need to be specially maintained, repaired, replaced, or improved immediately or during the 20-year long term schedule. Describe the condition of the items and when the appropriate actions are needed."]
[]
[null,"Mechanical and Electrical - Include specific mechanical and electrical materials, such as furnaces and meters, that need to be specially maintained, repaired, replaced, or improved immediately or during the 20-year long term schedule.  Describe the condition of the items and when the appropriate actions are needed."]
[]
[null,"Dwellings - Include specific dwelling unit items, such as appliances and flooring, that need to be specially maintained, repaired, replaced, or improved immediately or during the 20-year long term schedule.  Describe the condition of the items and when the appropriate actions is needed."]
[]
[null,"Accessibility - Include items such as:\n\n            - How the property meets applicable local, state, and federal laws and standards for accessibility.\n            - Description of any actions and their estimated costs to correct any deficiencies noted during the inspection.\n            - An opinion on the adequacy of any existing property Transition Plan to achieve compliance."]
[]
[null,"Environmental - Include items such as:\n\n            - An assessment of observed or potential on-site environmental hazards.\n            - Results of any existing tests for the presence of radon, lead in water or paint, mold, and \n              other environmental concerns.\n           - An opinion on the adequacy of any existing lead based paint risk assessment for properties \n             constructed before 1978."]
[]
[null,"Recommendations - Include recommendations for any additional professional reports as deemed necessary, such as additional investigations on potential structural defects or environmental hazards."]
[]
[null,"Needs Funded by Third Party - Identify any needs being or to be funded from a third party, such as tax credits. Include a description of the work, the source of funds, the year's) the work is planned to be completed, and the total estimated costs in current dollars."]
[]
[null,"Acknowledgements - Include the names and addresses of persons who:  were interviewed during or as part of the inspection; provided information for the assessment; and performed any portion of the assessment on behalf of the provider."]

{"sheet":"Inspected Units","index":2,"n_rows":57,"n_cols":9,"rows_kept":57,"cut":false,"hidden":false,"merged":[[51,2,51,4],[48,2,48,4],[49,2,49,4],[56,2,56,4],[54,2,54,4],[55,2,55,4],[52,2,52,4],[53,2,53,4],[47,2,47,4],[44,2,44,4],[45,2,45,4],[50,2,50,4],[43,2,43,4],[46,2,46,4],[39,2,39,4],[36,2,36,4],[37,2,37,4],[42,2,42,4],[35,2,35,4],[38,2,38,4],[40,2,40,4],[41,2,41,4],[31,2,31,4],[28,2,28,4],[29,2,29,4],[34,2,34,4],[27,2,27,4],[30,2,30,4],[32,2,32,4],[33,2,33,4],[23,2,23,4],[20,2,20,4],[21,2,21,4],[26,2,26,4],[19,2,19,4],[22,2,22,4],[24,2,24,4],[25,2,25,4],[18,2,18,4],[11,2,11,4],[8,2,8,4],[9,2,9,4],[14,2,14,4],[16,2,16,4],[17,2,17,4],[1,0,1,8],[2,0,2,8],[7,2,7,4],[10,2,10,4],[15,2,15,4],[12,2,12,4],[13,2,13,4]]}
[]
["Capital Needs Assessment"]
["Inspected Units"]
[]
[null,"Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},null,null,null,null,"Date:",{"$f":"ReportDate","v":"2017-05-01"}]
[]
[null,null,null,"Unit Number",null,"Size","Fully Accessible unit?","Comments"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]

{"sheet":"Site","index":3,"n_rows":12,"n_cols":35,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,11],[2,0,2,11],[1,12,1,34],[2,12,2,34],[4,30,4,33]]}
[]
["Capital Needs Assessment",null,null,null,null,null,null,null,null,null,null,null,"Capital Needs Assessment"]
["Materials and Conditions - Site",null,null,null,null,null,null,null,null,null,null,null,"Capital Needs Over the Term - Site"]
[]
["Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},null,null,null,null,null,null,null,null,"Date:",{"$f":"ReportDate","v":"2017-05-01"},"Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"ReportDate","v":"2017-05-01"}]
[null,null,null,null,null,null,null,null,null,"Unit","Total",null,null,null,1,{"$f":"O6+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Item","EUL","AGE","RUL","Cond","Action","DUR","QTY","Unit","Cost","Cost","Comments","Item","H & S",{"$f":"YEAR(ReportDate)+1","v":2018},{"$f":"O7+1","v":2019},2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,"Total"]
[null,{"$f":"IF(A8=\"\",0,IF('Project Summary'!$D$20=\"Family\",VLOOKUP(A8,SiteEULtable,2,FALSE),VLOOKUP(A8,SiteEULtable,3,FALSE)))","v":0},0,{"$f":"IF(B8-C8>0,B8-C8,0)","v":0},null,null,0,0,"ea",0,{"$f":"H8*J8","v":0},null,{"$f":"IF(A8=\"\",\"\",A8)","v":""},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N8:AH8)","v":0}]
[null,{"$f":"IF(A9=\"\",0,IF('Project Summary'!$D$20=\"Family\",VLOOKUP(A9,SiteEULtable,2,FALSE),VLOOKUP(A9,SiteEULtable,3,FALSE)))","v":0},0,{"$f":"IF(B9-C9>0,B9-C9,0)","v":0},null,null,0,0,"ea",0,{"$f":"H9*J9","v":0},null,{"$f":"IF(A9=\"\",\"\",A9)","v":""},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N9:AH9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Uninflated Totals",{"$f":"SUM(N8:N9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N10:AH10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inflation Factor (3%)",1,1,{"$f":"1+(InflationRate^O6)","v":1.03},{"$f":"P11*$P$11","v":1.0609},1.092727,1.1255088100000001,1.1592740743000001,1.1940522965290001,1.2298738654248702,1.2667700813876164,1.3047731838292449,1.3439163793441222,1.3842338707244459,1.4257608868461793,1.4685337134515648,1.5125897248551119,1.5579674166007653,1.6047064390987884,1.652847632271752,1.7024330612399046,1.7535060530771018]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inflated Totals",{"$f":"N10*N11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N12:AH12)","v":0}]

{"sheet":"Architectural","index":4,"n_rows":12,"n_cols":35,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,11],[2,0,2,11],[1,12,1,34],[2,12,2,34],[4,30,4,33]]}
[]
["Capital Needs Assessment",null,null,null,null,null,null,null,null,null,null,null,"Capital Needs Assessment"]
["Materials and Conditions - Architectural",null,null,null,null,null,null,null,null,null,null,null,"Capital Needs Over the Term - Architectural"]
[]
["Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},null,null,null,null,null,null,null,null,"Date:",{"$f":"ReportDate","v":"2017-05-01"},"Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"ReportDate","v":"2017-05-01"}]
[null,null,null,null,null,null,null,null,null,"Unit","Total",null,null,null,1,{"$f":"O6+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Item","EUL","AGE","RUL","Cond","Action","DUR","QTY","Unit","Cost","Cost","Comments","Item","H & S",{"$f":"YEAR(ReportDate)+1","v":2018},2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,"Total"]
[null,{"$f":"IF(A8=\"\",0,IF('Project Summary'!$D$20=\"Family\",VLOOKUP(A8,ArchEULtable,2,FALSE),VLOOKUP(A8,ArchEULtable,3,FALSE)))","v":0},0,{"$f":"IF(B8-C8>0,B8-C8,0)","v":0},null,null,0,0,"ea",0,{"$f":"H8*J8","v":0},null,{"$f":"IF(A8=\"\",\"\",A8)","v":""},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N8:AH8)","v":0}]
[null,{"$f":"IF(A9=\"\",0,IF('Project Summary'!$D$20=\"Family\",VLOOKUP(A9,ArchEULtable,2,FALSE),VLOOKUP(A9,ArchEULtable,3,FALSE)))","v":0},0,{"$f":"IF(B9-C9>0,B9-C9,0)","v":0},null,null,0,0,"ea",0,{"$f":"H9*J9","v":0},null,{"$f":"IF(A9=\"\",\"\",A9)","v":""},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N9:AH9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Uninflated Totals",{"$f":"SUM(N8:N9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N10:AH10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inflation Factor (3%)",1,1,{"$f":"1+(InflationRate^O6)","v":1.03},{"$f":"P11*$P$11","v":1.0609},{"$f":"Q11*$P$11","v":1.092727},1.1255088100000001,1.1592740743000001,1.1940522965290001,1.2298738654248702,1.2667700813876164,1.3047731838292449,1.3439163793441222,1.3842338707244459,1.4257608868461793,1.4685337134515648,1.5125897248551119,1.5579674166007653,1.6047064390987884,1.652847632271752,1.7024330612399046,1.7535060530771018]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inflated Totals",{"$f":"N10*N11","v":0},{"$f":"O10*O11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N12:AH12)","v":0}]

{"sheet":"Mech & Electric","index":5,"n_rows":12,"n_cols":35,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,11],[2,0,2,11],[1,12,1,34],[2,12,2,34],[4,30,4,33]]}
[]
["Capital Needs Assessment",null,null,null,null,null,null,null,null,null,null,null,"Capital Needs Assessment"]
["Materials and Conditions - Mechanical & Electrical",null,null,null,null,null,null,null,null,null,null,null,"Capital Needs Over the Term - Mechanical & Electrical"]
[]
["Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},null,null,null,null,null,null,null,null,"Date:",{"$f":"ReportDate","v":"2017-05-01"},"Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"ReportDate","v":"2017-05-01"}]
[null,null,null,null,null,null,null,null,null,"Unit","Total",null,null,null,1,{"$f":"O6+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Item","EUL","AGE","RUL","Cond","Action","DUR","QTY","Unit","Cost","Cost","Comments","Item","H & S",{"$f":"YEAR(ReportDate)+1","v":2018},2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,"Total"]
[null,{"$f":"IF(A8=\"\",0,IF('Project Summary'!$D$20=\"Family\",VLOOKUP(A8,M_EEULtable,2,FALSE),VLOOKUP(A8,M_EEULtable,3,FALSE)))","v":0},0,{"$f":"IF(B8-C8>0,B8-C8,0)","v":0},null,null,0,0,"ea",0,{"$f":"H8*J8","v":0},null,{"$f":"IF(A8=\"\",\"\",A8)","v":""},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N8:AH8)","v":0}]
[null,{"$f":"IF(A9=\"\",0,IF('Project Summary'!$D$20=\"Family\",VLOOKUP(A9,M_EEULtable,2,FALSE),VLOOKUP(A9,M_EEULtable,3,FALSE)))","v":0},0,{"$f":"IF(B9-C9>0,B9-C9,0)","v":0},null,null,0,0,"ea",0,{"$f":"H9*J9","v":0},null,{"$f":"IF(A9=\"\",\"\",A9)","v":""},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N9:AH9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Uninflated Totals",{"$f":"SUM(N8:N9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N10:AH10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inflation Factor (3%)",1,1,{"$f":"1+(InflationRate^O6)","v":1.03},{"$f":"P11*$P$11","v":1.0609},{"$f":"Q11*$P$11","v":1.092727},1.1255088100000001,1.1592740743000001,1.1940522965290001,1.2298738654248702,1.2667700813876164,1.3047731838292449,1.3439163793441222,1.3842338707244459,1.4257608868461793,1.4685337134515648,1.5125897248551119,1.5579674166007653,1.6047064390987884,1.652847632271752,1.7024330612399046,1.7535060530771018]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inflated Totals",{"$f":"N10*N11","v":0},{"$f":"O10*O11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N12:AH12)","v":0}]

{"sheet":"Dwelling Units","index":6,"n_rows":12,"n_cols":35,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,11],[2,0,2,11],[1,12,1,34],[2,12,2,34],[4,30,4,33]]}
[]
["Capital Needs Assessment",null,null,null,null,null,null,null,null,null,null,null,"Capital Needs Assessment"]
["Materials and Conditions - Dwelling Units",null,null,null,null,null,null,null,null,null,null,null,"Capital Needs Over the Term - Dwelling Units"]
[]
["Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},null,null,null,null,null,null,null,null,"Date:",{"$f":"ReportDate","v":"2017-05-01"},"Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"ReportDate","v":"2017-05-01"}]
[null,null,null,null,null,null,null,null,null,"Unit","Total",null,null,null,1,{"$f":"O6+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Item","EUL","AGE","RUL","Cond","Action","DUR","QTY","Unit","Cost","Cost","Comments","Item","H & S",{"$f":"YEAR(ReportDate)+1","v":2018},{"$f":"O7+1","v":2019},2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,"Total"]
[null,{"$f":"IF(A8=\"\",0,IF('Project Summary'!$D$20=\"Family\",VLOOKUP(A8,DwellingEULtable,2,FALSE),VLOOKUP(A8,DwellingEULtable,3,FALSE)))","v":0},0,{"$f":"IF(B8-C8>0,B8-C8,0)","v":0},null,null,0,0,"ea",0,{"$f":"H8*J8","v":0},null,{"$f":"IF(A8=\"\",\"\",A8)","v":""},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N8:AH8)","v":0}]
[null,{"$f":"IF(A9=\"\",0,IF('Project Summary'!$D$20=\"Family\",VLOOKUP(A9,DwellingEULtable,2,FALSE),VLOOKUP(A9,DwellingEULtable,3,FALSE)))","v":0},0,{"$f":"IF(B9-C9>0,B9-C9,0)","v":0},null,null,0,0,"ea",0,{"$f":"H9*J9","v":0},null,{"$f":"IF(A9=\"\",\"\",A9)","v":""},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N9:AH9)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Uninflated Totals",{"$f":"SUM(N8:N9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N10:AH10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inflation Factor (3%)",1,1,{"$f":"1+(InflationRate^O6)","v":1.03},{"$f":"P11*$P$11","v":1.0609},1.092727,1.1255088100000001,1.1592740743000001,1.1940522965290001,1.2298738654248702,1.2667700813876164,1.3047731838292449,1.3439163793441222,1.3842338707244459,1.4257608868461793,1.4685337134515648,1.5125897248551119,1.5579674166007653,1.6047064390987884,1.652847632271752,1.7024330612399046,1.7535060530771018]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inflated Totals",{"$f":"N10*N11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N12:AH12)","v":0}]

{"sheet":"Executive Summary","index":7,"n_rows":22,"n_cols":23,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,7,20,8],[21,7,21,8],[18,10,18,11],[19,10,19,11],[20,10,20,11],[21,10,21,11],[1,0,1,22],[2,0,2,22],[18,7,18,8],[4,18,4,20],[19,7,19,8]]}
[]
["Capital Needs Assessment"]
["Executive Summary"]
[]
[null,null,"Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"ReportDate","v":"2017-05-01"}]
[]
[null,null,1,{"$f":"C7+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Item","H & S",{"$f":"YEAR(ReportDate)+1","v":2018},2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,"Total"]
["Site",{"$f":"Site!N10","v":0},{"$f":"Site!O10","v":0},{"$f":"Site!P10","v":0},{"$f":"Site!Q10","v":0},{"$f":"Site!R10","v":0},{"$f":"Site!S10","v":0},{"$f":"Site!T10","v":0},{"$f":"Site!U10","v":0},{"$f":"Site!V10","v":0},{"$f":"Site!W10","v":0},{"$f":"Site!X10","v":0},{"$f":"Site!Y10","v":0},{"$f":"Site!Z10","v":0},{"$f":"Site!AA10","v":0},{"$f":"Site!AB10","v":0},{"$f":"Site!AC10","v":0},{"$f":"Site!AD10","v":0},{"$f":"Site!AE10","v":0},{"$f":"Site!AF10","v":0},{"$f":"Site!AG10","v":0},{"$f":"Site!AH10","v":0},{"$f":"SUM(B9:V9)","v":0}]
["Architecture",{"$f":"Architectural!N10","v":0},{"$f":"Architectural!O10","v":0},{"$f":"Architectural!P10","v":0},{"$f":"Architectural!Q10","v":0},{"$f":"Architectural!R10","v":0},{"$f":"Architectural!S10","v":0},{"$f":"Architectural!T10","v":0},{"$f":"Architectural!U10","v":0},{"$f":"Architectural!V10","v":0},{"$f":"Architectural!W10","v":0},{"$f":"Architectural!X10","v":0},{"$f":"Architectural!Y10","v":0},{"$f":"Architectural!Z10","v":0},{"$f":"Architectural!AA10","v":0},{"$f":"Architectural!AB10","v":0},{"$f":"Architectural!AC10","v":0},{"$f":"Architectural!AD10","v":0},{"$f":"Architectural!AE10","v":0},{"$f":"Architectural!AF10","v":0},{"$f":"Architectural!AG10","v":0},{"$f":"Architectural!AH10","v":0},{"$f":"SUM(B10:V10)","v":0}]
["Mech & Electric",{"$f":"'Mech & Electric'!N10","v":0},{"$f":"'Mech & Electric'!O10","v":0},{"$f":"'Mech & Electric'!P10","v":0},{"$f":"'Mech & Electric'!Q10","v":0},{"$f":"'Mech & Electric'!R10","v":0},{"$f":"'Mech & Electric'!S10","v":0},{"$f":"'Mech & Electric'!T10","v":0},{"$f":"'Mech & Electric'!U10","v":0},{"$f":"'Mech & Electric'!V10","v":0},{"$f":"'Mech & Electric'!W10","v":0},{"$f":"'Mech & Electric'!X10","v":0},{"$f":"'Mech & Electric'!Y10","v":0},{"$f":"'Mech & Electric'!Z10","v":0},{"$f":"'Mech & Electric'!AA10","v":0},{"$f":"'Mech & Electric'!AB10","v":0},{"$f":"'Mech & Electric'!AC10","v":0},{"$f":"'Mech & Electric'!AD10","v":0},{"$f":"'Mech & Electric'!AE10","v":0},{"$f":"'Mech & Electric'!AF10","v":0},{"$f":"'Mech & Electric'!AG10","v":0},{"$f":"'Mech & Electric'!AH10","v":0},{"$f":"SUM(B11:V11)","v":0}]
["Dwelling Units",{"$f":"'Dwelling Units'!N10","v":0},{"$f":"'Dwelling Units'!O10","v":0},{"$f":"'Dwelling Units'!P10","v":0},{"$f":"'Dwelling Units'!Q10","v":0},{"$f":"'Dwelling Units'!R10","v":0},{"$f":"'Dwelling Units'!S10","v":0},{"$f":"'Dwelling Units'!T10","v":0},{"$f":"'Dwelling Units'!U10","v":0},{"$f":"'Dwelling Units'!V10","v":0},{"$f":"'Dwelling Units'!W10","v":0},{"$f":"'Dwelling Units'!X10","v":0},{"$f":"'Dwelling Units'!Y10","v":0},{"$f":"'Dwelling Units'!Z10","v":0},{"$f":"'Dwelling Units'!AA10","v":0},{"$f":"'Dwelling Units'!AB10","v":0},{"$f":"'Dwelling Units'!AC10","v":0},{"$f":"'Dwelling Units'!AD10","v":0},{"$f":"'Dwelling Units'!AE10","v":0},{"$f":"'Dwelling Units'!AF10","v":0},{"$f":"'Dwelling Units'!AG10","v":0},{"$f":"'Dwelling Units'!AH10","v":0},{"$f":"SUM(B12:V12)","v":0}]
["Uninflated Totals",{"$f":"SUM(B9:B12)","v":0},{"$f":"SUM(C9:C12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B13:V13)","v":0}]
["Inflation Factor (3%)",1,1,{"$f":"((1+InflationRate)^C7)","v":1.03},{"$f":"((1+(InflationRate))^D7)","v":1.0609},1.092727,1.1255088099999999,1.1592740742999998,1.1940522965289999,1.22987386542487,1.2667700813876159,1.3047731838292445,1.3439163793441218,1.3842338707244455,1.4257608868461786,1.4685337134515639,1.512589724855111,1.5579674166007644,1.6047064390987871,1.6528476322717507,1.7024330612399032,1.7535060530771003]
["Inflated Totals",{"$f":"B13*B14","v":0},{"$f":"C13*C14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B15:V15)","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Non-Inflated",null,null,"Inflated"]
[null,null,null,null,null,"Immediate Capital Needs:",null,{"$f":"B13","v":0}]
[null,null,null,null,null,"Total Capital Needs Over the Term:",null,{"$f":"SUM(C13:V13)","v":0},null,null,{"$f":"SUM(C15:V15)","v":0}]
[null,null,null,null,null,"Grand Total Capital Needs:",null,{"$f":"W13","v":0},null,null,{"$f":"W15","v":0}]
["Units:",{"$f":"'Project Summary'!D28","v":0},null,null,null,"Capital Needs Per Unit",null,{"$f":"IF($B$22>0,W13/$B$22,0)","v":0},null,null,{"$f":"IF($B$22>0,W15/$B$22,0)","v":0}]

{"sheet":"Photos","index":8,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":true,"merged":[[8,8,8,14],[9,8,9,14],[1,0,1,14],[2,0,2,14],[56,1,56,10],[29,1,29,10],[5,0,5,6],[6,0,6,6],[5,8,5,14],[6,8,6,14],[8,0,8,6],[9,0,9,6]]}
[]
["Capital Needs Assessment"]
["Photos"]
[]
["Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"ReportDate","v":"2017-05-01"}]
["Insert a picture in this shaded area.\n   1.  Select this object\n   2.  Click on \"Insert\" from the menu bar and click on \"Picture\"  \n   3.  From the submenu, pick \"From File\" -a dialog box will open\n   4.  Find the picture and click \"Insert\"",null,null,null,null,null,null,null,"Insert a picture in this shaded area.\n   1.  Select this object\n   2.  Click on \"Insert\" from the menu bar and click on \"Picture\"  \n   3.  From the submenu, pick \"From File\" -a dialog box will open\n   4.  Find the picture and click \"Insert\""]
["Insert your caption here",null,null,null,null,null,null,null,"Insert your caption here"]
[]
["Insert a picture in this shaded area.\n   1.  Select this object\n   2.  Click on \"Insert\" from the menu bar and click on \"Picture\"  \n   3.  From the submenu, pick \"From File\" -a dialog box will open\n   4.  Find the picture and click \"Insert\"",null,null,null,null,null,null,null,"Insert a picture in this shaded area.\n   1.  Select this object\n   2.  Click on \"Insert\" from the menu bar and click on \"Picture\"  \n   3.  From the submenu, pick \"From File\" -a dialog box will open\n   4.  Find the picture and click \"Insert\""]
["Insert your caption here",null,null,null,null,null,null,null,"Insert your caption here"]

{"sheet":"Photos (1)","index":9,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[56,1,56,10],[1,0,1,14],[2,0,2,14],[5,0,5,6],[5,8,5,14],[6,0,6,6],[6,8,6,14],[8,0,8,6],[8,8,8,14],[9,0,9,6],[9,8,9,14],[29,1,29,10]]}
[]
["Capital Needs Assessment"]
["Photos"]
[]
["Project:",{"$f":"IF(ProjectName=\"\",\"\",ProjectName)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"ReportDate","v":"2017-05-01"}]
["Insert a picture in this shaded area.\n   1.  Select this object\n   2.  Click on \"Insert\" from the menu bar and click on \"Picture\"  \n   3.  From the submenu, pick \"From File\" -a dialog box will open\n   4.  Find the picture and click \"Insert\"",null,null,null,null,null,null,null,"Insert a picture in this shaded area.\n   1.  Select this object\n   2.  Click on \"Insert\" from the menu bar and click on \"Picture\"  \n   3.  From the submenu, pick \"From File\" -a dialog box will open\n   4.  Find the picture and click \"Insert\""]
["Insert your caption here",null,null,null,null,null,null,null,"Insert your caption here"]
[]
["Insert a picture in this shaded area.\n   1.  Select this object\n   2.  Click on \"Insert\" from the menu bar and click on \"Picture\"  \n   3.  From the submenu, pick \"From File\" -a dialog box will open\n   4.  Find the picture and click \"Insert\"",null,null,null,null,null,null,null,"Insert a picture in this shaded area.\n   1.  Select this object\n   2.  Click on \"Insert\" from the menu bar and click on \"Picture\"  \n   3.  From the submenu, pick \"From File\" -a dialog box will open\n   4.  Find the picture and click \"Insert\""]
["Insert your caption here",null,null,null,null,null,null,null,"Insert your caption here"]

{"sheet":"Change History","index":10,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,1,5],[2,0,2,5]]}
[]
["Capital Needs Worksheet"]
["Change History"]
[]
["Version","Date","Type","Worksheet","Change",null,null,"Date:"]
["1.5h","2017-04-17","Bug","Narrative -  Embedded Word Doc.","Edited the footer to reflect the current version of the CNA on footer of letter."]
["1.5h","2017-02-13","Bug","Site, Archtiectural, Mech, Dwelling","Corrected Vlookup for exact match of Item from Control sheet"]
["1.5h","2017-02-06","Bug","Dwelling Sheet","Corrected date for Report on page 2 of Dwelling sheet."]
["1.5h","2017-01-23","Bug","Printed Sheets","Corrected Version reference on printed sheets"]
["1.5h","2016-12-14","Enhancement","Executive Summary Page","Protected to prevent changes to cells and formulas."]
["1.5h","2016-12-14","Enhancement","EULs","Verifying EUL updated and have all components per recommendations of task force."]
["1.5h","2016-12-14","Enhancement","Control Page (EULs) and Change History","Hid Control page and password protected page.  Password protected Change History."]
["1.5h","2016-12-05","bug","Workbook locked.   Would not allow adding Photo pages","Removed password for workbook. To enable function of inserting new photo page.  "]
["1.5g","2016-11-01","bug","Updated EUL pages.","Corrected EULs per UNLetter."]
["1.5f","2016-11-01","bug","Updated EUL pages.","Corrected EULs per UNLetter."]
["1.5d","2008-08-09","Enhancement","All Materials and Conditions Worksheets & Executive Summary","Modified the year on each page to be driven by the report date"]
["1.5d","2008-08-09","Enhancement","All Pages","Removed password from each page."]
["1.5c","2007-07-25","Enhancement","Photo Page","Photo Pages now support a 4 picture format"]
["1.5b","2007-07-18","bug","Photo Page","Photo Pages may now be inserted by hitting an insert new page button."]
["1.5b","2007-07-19","bug","All Materials and Conditions Worksheets & Executive Summary","Row sizes will resize automatically for all sheets"]
["1.5b","2007-07-20","bug","All Materials and Conditions Worksheets & Executive Summary","Fixed lookup of EUL for all m&c worksheets"]
["1.5a","2007-07-11","bug","All Materials and Conditions Worksheets & Executive Summary","Columns widths will adjust automatically to accomadate the new titles"]
["1.5a","2007-07-11","bug","All Materials and Conditions Worksheets & Executive Summary","Change Header Title to \"H & S\""]
[1.5,"2007-07-02","Enhancement","All Materials and Conditions Worksheets & Executive Summary","Year 0 was changed to \"Health & Safety\""]
[1.5,"2007-07-02","Enhancement","Narrative","Expanded to include Health and Safety"]
[1.5,"2007-07-02","Bug","Various","Fix several spelling mistakes and expanded some comment fields."]
[1.5,"2007-07-02","Bug","All Materials and Conditions Worksheets","Fixed word wrapping on the item & comment fields"]
[1.4,"2006-08-22","Bug","All","Version was printing 1.3 now changed to 1.4"]
[1.4,"2006-08-22","Bug","Mechanical & Electrical  Worksheet","Totals were missing off the 20 year plan"]
[1.4,"2006-08-09","Enhancement","All Materials and Conditions Worksheets","Changed the \"Protect\" command to be compatible with MAC Excel and older PC versions"]
[1.4,"2006-08-09","Bug","All Materials and Conditions Worksheets","Prevented the overwrite of the total column if the action was changed to \"No Action\" and back"]
[1.4,"2006-08-09","Bug","All Materials and Conditions Worksheets","Allowed Year to be 0"]
[1.4,"2006-08-03","Enhancement","All Materials and Conditions Worksheets","Added check to make sure the DUR does not exceed the EUL"]
[1.4,"2006-08-03","Bug","All Materials and Conditions Worksheets","Force insert line to occur within the data block"]
[1.4,"2006-08-03","Bug","Mechanical & Electrical  Worksheet","First line was not pulling the EUL"]
[1.4,"2006-08-03","Enhancement","Photo Page","Changed to make the page a better fit for landscape printing.  "]
[1.3,"2006-07-28","Enhancement","Change History","Added to Workbook"]
[1.3,"2006-07-28","Enhancement","All Pages","Added Footer information identifying the section, page number and version."]
[1.3,"2006-07-28","Enhancement","Project Summary","Set date in top right corner to today, allowing the ability to override if needed"]
[1.3,"2006-07-28","Enhancement","Project Summary","Added County to Project"]
[1.3,"2006-07-28","Enhancement","Narrative","Added embedded worksheet to hold the Narrative Document.  Reconfigured the comments."]
[1.3,"2006-07-28","Enhancement","All Materials and Conditions Worksheets","Modified the deletion so all rows can be deleted without affecting the underlying formulas"]
[1.3,"2006-07-28","Enhancement","All Materials and Conditions Worksheets","Modified the insert function to allow the insertion of a line below the current line instead of always at the end."]
[1.3,"2006-07-28","Bug","All Materials and Conditions Worksheets","20 Year plan values were not being properly overwritten. Fixed"]
[1.3,"2006-07-28","Bug","All Materials and Conditions Worksheets","Comment field was not allowing re-editing.  Turned hidden formula off - Fixed"]

{"sheet":"Controls","index":11,"n_rows":160,"n_cols":22,"rows_kept":160,"cut":false,"hidden":true,"merged":[]}
["Validation Values Worksheet"]
[]
["Project Types",null,"Actions","Conditions",null,null,"Family","Elderly",null,null,"Family","Elderly",null,null,"Family","Elderly",null,null,"Family","Elderly",null,"Inflation Rate"]
["Family",null,"Maintain","Excellent",null,"SITE","Family","Elderly",null,"ARCHITECTURAL","Family","Elderly",null,"MECHANICAL AND ELECTRICAL","Family","Elderly",null,"DWELLING UNITS","Family","Elderly",null,0.03]
["Elderly",null,"Repair","Good ",null,"Accessibility Compliance",50,50,null,"Accessibility Compliance",50,50,null,"Boiler: blowdown and water treatment",25,25,null,"Accessibility Compliance",50,50]
[null,null,"Replace","Fair",null,"Carports: metal frame",40,40,null,"Appliances: clothes washer/dryer",10,15,null,"Boilers: electric",20,20,null,"Appliances: clothes washer/dryer",10,15]
[null,null,"Construct","Poor",null,"Carports: wood frame",30,30,null,"Appliances: compactors (interior, residential)",7,10,null,"Boiler: exchanger in tank",15,15,null,"Appliances: compactors (interior, residential grade)",7,10]
[null,null,"No Action",null,null,"Composting: organic recycling equipment",10,10,null,"Appliances: dishwasher",10,15,null,"Boilers: gas fired atmospheric",25,25,null,"Appliances: dishwasher",10,15]
[null,null,null,null,null,"Curbing: asphalt",25,25,null,"Appliances: disposal (food waste)",7,10,null,"Boilers: gas/dual fuel: high MBH",40,40,null,"Appliances: disposal (food waste)",7,10]
[null,null,null,null,null,"Curbing: concrete",50,50,null,"Appliances: microwave",10,10,null,"Boilers: gas/dual fuel: low MBH",30,30,null,"Appliances: microwave",10,10]
[null,null,null,null,null,"Decks: composite",50,50,null,"Appliances: range, cook top, wall oven",15,20,null,"Boilers: gas/dual fuel: sectional",25,25,null,"Appliances: range, cooktop, wall oven",15,20]
[null,null,null,null,null,"Decks: treated lumber",20,20,null,"Appliances: range hood",15,20,null,"Boilers: oil fired: sectional",25,25,null,"Appliances: range hood",15,20]
[null,null,null,null,null,"Electric distribution center",40,40,null,"Appliances: refrigerator/freezer",12,15,null,"Boiler: temperature controls",15,15,null,"Appliances: refrigerator/freezer",12,15]
[null,null,null,null,null,"Electric distribution lines",40,40,null,"Balcony/Porch: composite decking",50,50,null,"Boiler Room: pipe insulation",25,25,null,"Bath: accessories (towel bars, grab bars, etc)",7,12]
[null,null,null,null,null,"Electric: transformer",30,30,null,"Balcony/Porch: steel frame or concrete",40,40,null,"Boiler Room: piping",50,50,null,"Bath: mirrors & medicine cabinets",15,25]
[null,null,null,null,null,"Fencing: chain-link",40,40,null,"Balcony/Porch: wood decking",20,20,null,"Boiler Room: valves",25,25,null,"Bath/kitchen vent/exhaust fans",15,15]
[null,null,null,null,null,"Fencing: concrete masonry unit (CMU)",30,30,null,"Balcony/Porch: wood frame",25,25,null,"Chimneys: metal: and chimney covers",35,35,null,"Cabinets & vanities",20,25]
[null,null,null,null,null,"Fencing: PVC",20,25,null,"Bath: accessories (towel bars, grab bars, etc)",7,12,null,"Detector:smoke or CO",10,10,null,"Ceiling: acoustic tile/drop ceiling",15,20]
[null,null,null,null,null,"Fencing: steel or aluminum",20,25,null,"Bath: mirrors & medicine cabinets",15,25,null,"DHW: circulating pumps",15,15,null,"Ceiling: drywall",35,40]
[null,null,null,null,null,"Fencing: wood board (=>1\"x 6\")",15,20,null,"Bath/kitchen vent/exhaust fans",15,15,null,"DHW: external tankless heater, gas or electric",15,20,null,"Ceiling: fan",10,15]
[null,null,null,null,null,"Fencing: wood picket",15,20,null,"Building fire supression sprinklers: standpipes",50,50,null,"DHW: flue, gas water heaters",35,35,null,"Closet/storage specialties: shelving",15,25]
[null,null,null,null,null,"Fencing: wrought Iron",50,50,null,"Building structure: reinforced concrete",100,100,null,"DHW: gas or electric, residential unit",12,15,null,"Countertops: Granite: natural stone, engineered stone",50,50]
[null,null,null,null,null,"Fountains: pond aerators",15,15,null,"Building structure: reinforced masonry, concrete masonry units (CMUs)",100,100,null,"DHW: solar hot water",20,20,null,"Countertops: plastic laminates, wood",15,25]
[null,null,null,null,null,"Irrigation System",25,25,null,"Building structure: solid masonry ",100,100,null,"DHW: storage tanks",15,15,null,"Countertops: solid surface, stainless steel",40,50]
[null,null,null,null,null,"Lighting: building mounted high intensity discharge (HID) lighting",10,20,null,"Building structure: steel: beams,trusses",100,100,null,"Electric: electric panel, dwelling unit",50,50,null,"Countertops (vanity): cultered marble, molded arcylic, fiberglass",20,25]
[null,null,null,null,null,"Lighting: building mounted lighting",10,10,null,"Building structure: tie downs, clips, braces, straps, hangers, shear walls/panels",75,75,null,"Electric: service panel, building",50,50,null,"Detector: smoke or CO, dwelling unit",10,10]
[null,null,null,null,null,"Lighting: ground lighting",10,10,null,"Building structure: wood, timbers, dimensioned lumber, laminated beams, trusses",100,100,null,"Electric: switches & outlets",35,35,null,"Doors: bifold & sliding doors",10,20]
[null,null,null,null,null,"Lighting: pole mounted lights",25,25,null,"Cabinets & vanities",20,25,null,"Electric: wiring, building/unit",50,50,null,"Doors: door trim",20,30]
[null,null,null,null,null,"Mail Kiosk",15,20,null,"Call station",10,15,null,"Elevator cab: frame",35,50,null,"Doors: Interior doors, solid core, wood, metal clad",30,35]
[null,null,null,null,null,"Owner provided allowance (specify $)",5,5,null,"Canopy: concrete",50,50,null,"Elevator cab: interior finish",10,20,null,"Doors: interior, hollow core doors",20,25]
[null,null,null,null,null,"Owner provided item(s) (specify)",5,5,null,"Canopy: wood/metal",40,40,null,"Elevator controller: call, dispatch, emergency",10,20,null,"Doors: passage & lock sets",12,20]
[null,null,null,null,null,"Paving pedestrian: asphalt",25,25,null,"Ceiling: acoustic tile/drop ceiling",15,20,null,"Elevator: machinery",20,30,null,"Floors: carpet",7,10]
[null,null,null,null,null,"Paving pedestrian: concrete",50,50,null,"Ceiling: drywall",35,40,null,"Elevator: shaftway doors",10,20,null,"Floors: concrete, masonry, terrazo",75,75]
[null,null,null,null,null,"Paving pedestrian: gravel",15,15,null,"Ceiling: fan",10,15,null,"Elevator: shaftway hoist rails, cables, traveling",20,25,null,"Floors: floor tile, ceramic, natural stone",40,50]
[null,null,null,null,null,"Paving pedestrian: permeable paving (brick, concrete pavers)",30,30,null,"Closet/storage specialties: shelving",15,25,null,"Elevator: shaftway hydraulic piston and leveling",20,25,null,"Floors: hardwood floor (3/4\" strip or parquet)",50,50]
[null,null,null,null,null,"Paving vehicular: asphalt overlay 2”",20,20,null,"Countertops: granite, natural stone, engineered stone",50,50,null,"Elevator: switchgear",50,50,null,"Floors: resilient tile or sheet floor (vinyl, linoleum)",15,20]
[null,null,null,null,null,"Paving vehicular: asphalt pavement",25,25,null,"Countertops: plastic laminates, wood",15,25,null,"Emergency/auxillary fuel storage tank",25,25,null,"Floors: vinyl plank (> 3mm thick)",20,25]
[null,null,null,null,null,"Paving vehicular: asphalt seal coat & stripe",5,5,null,"Countertops: solid surface, stainless steel",40,50,null,"Emergency/auxillary generator",25,25,null,"Floors: wood floor, laminated/veneered",15,20]
[null,null,null,null,null,"Paving vehicular: concrete pavement",50,50,null,"Countertops (vanity): cultured marble, molded arcylic, fibreglass",20,25,null,"Escalators",50,50,null,"Stairs: interior",50,50]
[null,null,null,null,null,"Paving vehicular: parking, gravel surfaced",15,15,null,"Crawl space: (de)pressurization, fans, pumps, radon gas alarms",10,10,null,"Fireplace insert: Stove",50,50,null,"Stairs and loft: railings",20,25]
[null,null,null,null,null,"Paving vehicular: permeable paving systems (brick, concrete pavers)",30,30,null,"Crawl Space: sealing/barrier system",40,40,null,"Fireplace: factory assembled",35,35,null,"Walls: drywall",35,40]
[null,null,null,null,null,"Paving vehicular: Striping and Marking",15,15,null,"Detector: smoke or CO, community area",10,10,null,"Fireplace: masonry & firebrick, masonry chimney",75,75,null,"Walls: paints, stains, clear finishes, interior",10,15]
[null,null,null,null,null,"Pool Deck",15,15,null,"Door bells: chimes",20,25,null,"Fireplace: free standing chimney",50,50,null,"Walls: plaster",50,50]
[null,null,null,null,null,"Pool/Spa Plastic Liner",8,8,null,"Doors: automatic entry doors",30,30,null,"Fuel Oil/Propane: storage tanks",40,40,null,"Walls: wallpaper",10,15]
[null,null,null,null,null,"Pool/Spa pumps and equipment",10,10,null,"Doors: bifold & sliding doors",10,20,null,"Fuel: transfer system",25,25,null,"Walls: wall tile, ceramic, glass, natural stone",30,40]
[null,null,null,null,null,"Recycling containers/equipment",15,15,null,"Doors: commercial entry systems",50,50,null,"Gas/oil distribution lines",50,50,null,"Walls: wall trim (base, chair rail, crown moldings)",25,35]
[null,null,null,null,null,"Retaining Walls: heavy block (50Q80 lb)",60,60,null,"Doors: common exterior door, aluminum and glass",30,30,null,"HVAC: 2 pipe/4 pipe hydronic distribution, above grade",50,50,null,"Window treatments: drapery rods, shades, blinds, etc",10,20]
[null,null,null,null,null,"Retaining Walls: reinforced concrete masonry unit (CMU)",30,30,null,"Doors: common exterior door, solid wood /metal clad",25,25,null,"HVAC: 2 pipe/4 pipe hydronic distribution, in ground",25,25]
[null,null,null,null,null,"Retaining Walls: treated timber",25,25,null,"Doors: door trim",20,30,null,"HVAC: air filtration/humidity control devices (humidifiers, HRV's)",20,20]
[null,null,null,null,null,"Sanitary: lift station",50,50,null,"Doors: french or atrium doors, wood/metal clad",25,30,null,"HVAC: AC condenser, pad or rooftop, electric",15,15]
[null,null,null,null,null,"Sanitary: sewer lines",50,50,null,"Doors: interior doors, solid core, wood, metal clad",30,35,null,"HVAC: baseboard heater, electric",30,30]
[null,null,null,null,null,"Sanitary: waste treatment system",40,40,null,"Doors: interior, hollow core doors",20,25,null,"HVAC: central exhaust fans/blowers",20,20]
[null,null,null,null,null,"Security gate: lift arm",10,10,null,"Doors: overhead door",30,30,null,"HVAC: cooling tower",25,25]
[null,null,null,null,null,"Security gate: rolling gate",15,15,null,"Doors: overhead door automatic opener",20,20,null,"HVAC: chilling plant",20,20]
[null,null,null,null,null,"Signage: entrance  wood",15,15,null,"Doors: passage & lock sets",12,20,null,"HVAC: combustion air, duct with fixed louvers",30,30]
[null,null,null,null,null,"Signage: entrance/monument",25,25,null,"Doors: sliding glass doors",25,30,null,"HVAC: combustion air, motor louvers & duct",25,25]
[null,null,null,null,null,"Signage: roadway / parking",15,15,null,"Doors: storm/screen doors",7,10,null,"HVAC: combustion waste flue",40,40]
[null,null,null,null,null,"Solar: photovoltaic inverters",10,10,null,"Doors: unit entry, door solid wood/metal clad",25,30,null,"HVAC: diffusers, registers",20,20]
[null,null,null,null,null,"Solar: photovoltaic Micro inverters",20,20,null,"Environmental: asbestos or LBP removal",100,100,null,"HVAC: duct, flexible: insulated",20,20]
[null,null,null,null,null,"Solar: photovoltaic panels",25,25,null,"Environmental: asbestos & LBP testing",100,100,null,"HVAC: duct, rigid sheet metal, insulated if not in conditioned space",35,35]
[null,null,null,null,null,"Sport Court: asphalt",25,25,null,"Environmental: LBP encapsulation",10,10,null,"HVAC: duct, sealing mastic or UL 181A or 181B tape.",20,20]
[null,null,null,null,null,"Sport Court: synthetic",15,20,null,"Environmental: mold treat/remediate (see other items for paint: drywall: etc.)",100,100,null,"HVAC: evaporative cooler",15,15]
[null,null,null,null,null,"Sport Court: hardwood",50,50,null,"Enironmental remediation system periodic tests",5,5,null,"HVAC: fan coil unit, hydronic",30,30]
[null,null,null,null,null,"Storage sheds",30,30,null,"Environmental remediation pumps & equipment (eg: radon)",5,5,null,"HVAC: furnace/air handler, electric",20,20]
[null,null,null,null,null,"Storm Water: marine or stormwater bulkhead",35,35,null,"Exterior wall: aluminum siding",40,40,null,"HVAC: furnace/air handler, gas",20,20]
[null,null,null,null,null,"Storm Water: drain lines",50,50,null,"Exterior wall: brick/block veneer",60,60,null,"HVAC: heat exchanger",35,35]
[null,null,null,null,null,"Storm Water: mgmt ponds",50,50,null,"Exterior wall: building wraps & moisture resistant barriers",50,50,null,"HVAC: heat pump, electric condenser, pad or rooftop",15,15]
[null,null,null,null,null,"Storm Water: catch basins, inlets, culverts",50,50,null,"Exterior wall: cedar/redwood shakes: clapboard",50,50,null,"HVAC: heat sensors",15,15]
[null,null,null,null,null,"Storm Water: earthwork, swales, drainways, erosion controls",50,50,null,"Exterior wall: cement board siding",50,50,null,"HVAC: hydronic feed electric heat pump/air handler",25,25]
[null,null,null,null,null,"Tot Lot: playground equipment",20,25,null,"Exterior wall: concrete/masonry sealants",10,10,null,"HVAC: hydronic heat/electric AC air handler",25,25]
[null,null,null,null,null,"Tot Lot: ground cover loose bark",3,5,null,"Exterior wall: exterior insulation finishing system (EIFS)",30,30,null,"HVAC: hydronic/Water Circulating Pumps",20,20]
[null,null,null,null,null,"Tot Lot: groundcover, loose rubber",10,15,null,"Exterior wall: glass block",50,50,null,"HVAC: hydronic/water controller",20,20]
[null,null,null,null,null,"Tot Lot: groundcover, poured rubber",15,20,null,"Exterior wall: metal/glass curtain wall",40,40,null,"HVAC: outdoor temperature sensor",10,10]
[null,null,null,null,null,"Trash: compactor",20,20,null,"Exterior wall: pine board, clapboard",50,50,null,"HVAC: package unit, roof top",20,20]
[null,null,null,null,null,"Trash: dumpster enclosure, CMU",20,25,null,"Exterior wall: plywood/laminated panels",20,20,null,"HVAC: PTAC Thruwall (packaged terminal air conditioning)",15,15]
[null,null,null,null,null,"Utilities: gas lights/fire pits",20,20,null,"Exterior wall: precast concrete panel (tilt-up)",60,60,null,"HVAC: radiation steam/hydronic (baseboard or freestanding radiator)",50,50]
[null,null,null,null,null,"Utilities: gas main",40,40,null,"Exterior wall: stone veneer",50,50,null,"HVAC: steam supply station",50,50]
[null,null,null,null,null,"Utilities: gas supply lines",40,40,null,"Exterior wall: stucco: over wire mesh/lath",50,50,null,"HVAC: thermostat, dwelling/common area",15,20]
[null,null,null,null,null,"Utilities: propane storage & distribution",35,35,null,"Exterior wall: vinyl siding",30,30,null,"HVAC: wall mounted electric/gas heater",25,25]
[null,null,null,null,null,"Trash: Compactor",20,20,null,"Fascia: wood or vinyl",20,20,null,"HVAC: window or thru-wall air conditioners",10,10]
[null,null,null,null,null,"Trash: Dumpster enclosure: CMU",15,15,null,"Fire escapes: metal",50,50,null,"Lighting: emergency lights, illuminated signs",5,10]
[null,null,null,null,null,"Water Mains/Valves",50,50,null,"Fire extinguishers",10,10,null,"Lighting: exterior entry",15,20]
[null,null,null,null,null,"Water Tower",50,50,null,"Fire hose stations",50,50,null,"Lighting: interior common space",25,30]
[null,null,null,null,null,null,null,null,null,"Fire pumps",20,20,null,"Lighting: tenant spaces",20,25]
[null,null,null,null,null,null,null,null,null,"Floors: carpet",7,10,null,"Meter: building",40,40]
[null,null,null,null,null,null,null,null,null,"Floors: concrete, masonry, terrazo",75,75,null,"Meter: dwelling unit",40,40]
[null,null,null,null,null,null,null,null,null,"Floors: floor tile, ceramic, natural stone",40,50,null,"Plumbing: bath tubs & sinks, cast iron",50,75]
[null,null,null,null,null,null,null,null,null,"Floors: Hardwood floor (3/4\" strip or parquet)",50,50,null,"Plumbing: bath tubs & sinks: fiberglass, stainless steel or enameled",30,40]
[null,null,null,null,null,null,null,null,null,"Floors: resilient tile or sheet floor (vinyl, linoleum)",15,20,null,"Plumbing: bath tubs & sinks: porcelain",40,50]
[null,null,null,null,null,null,null,null,null,"Floors: vinyl plank (> 3mm thick)",20,25,null,"Plumbing: tub/shower units or integrated assemblies",30,30]
[null,null,null,null,null,null,null,null,null,"Floors: wood floor, laminated/veneered",20,25,null,"Plumbing: cold water pumps, domestic",20,20]
[null,null,null,null,null,null,null,null,null,"Foundation: continuous reinforced concrete footer & CMU stem wall",100,100,null,"Plumbing: copper tube, supply",50,50]
[null,null,null,null,null,null,null,null,null,"Foundation: piers, reinforced concrete footer & CMU pier",100,100,null,"Plumbing: copper/brass hard pipe, supply",75,75]
[null,null,null,null,null,null,null,null,null,"Foundation: piers, treated timber post/pole",40,40,null,"Plumbing: faucets & valves",15,20]
[null,null,null,null,null,null,null,null,null,"Foundation: slab, reinforced concrete or post-tensioned",100,100,null,"Plumbing: galvanized pipe, supply",40,40]
[null,null,null,null,null,null,null,null,null,"Foundation: suction, drainage, moisture or radon gas controls/alarms",10,10,null,"Plumbing: PVC/CPVC pipe: supply and waste",75,75]
[null,null,null,null,null,null,null,null,null,"Foundation: waterproofing",40,40,null,"Plumbing: sanitary waste, cast iron",75,75]
[null,null,null,null,null,null,null,null,null,"Gutters/Downspouts: aluminum/vinyl",20,20,null,"Plumbing: sewage ejectors",50,50]
[null,null,null,null,null,null,null,null,null,"Gutters/Downspouts: copper",50,50,null,"Plumbing: sump pump, residential",15,15]
[null,null,null,null,null,null,null,null,null,"Insulation: batts, blankets, rolls, fiberglass or mineral wool",60,60,null,"Plumbing: sump pump, commercial",20,20]
[null,null,null,null,null,null,null,null,null,"Insulation: loose fill, fiberglass, cellulose, mineral wool",50,50,null,"Plumbing: toilets/bidets/urinals",40,40]
[null,null,null,null,null,null,null,null,null,"Insulation: rigid foam board",60,60,null,"Plumbing: toilet flush valves",10,15]
[null,null,null,null,null,null,null,null,null,"Insulation: sprayed foam",60,60,null,"Plumbing: water Softener/Filtration",15,15]
[null,null,null,null,null,null,null,null,null,"Interior Mail Facility",20,25,null,"Remediate/remove: abandoned tanks/fuel lines",100,100]
[null,null,null,null,null,null,null,null,null,"Paints and Stains: exterior stucco",10,10,null,"Satellite dishes/antennae",20,20]
[null,null,null,null,null,null,null,null,null,"Paints & Stains: exterior wood",7,7,null,"Security Camera System",15,15]
[null,null,null,null,null,null,null,null,null,"Paints & Stains: fiber cement",15,15,null,"Telecom: cabling & outlets",20,20]
[null,null,null,null,null,null,null,null,null,"Paints & Stains: wood waterproofing and sealants",10,10,null,"Telecom: panels & controls",20,20]
[null,null,null,null,null,null,null,null,null,"Penetrations: caulking/sealing",15,15]
[null,null,null,null,null,null,null,null,null,"Railings: composite",50,50]
[null,null,null,null,null,null,null,null,null,"Railings: metal",50,50]
[null,null,null,null,null,null,null,null,null,"Railings: wood",20,20]
[null,null,null,null,null,null,null,null,null,"Roof Hatch",30,30]
[null,null,null,null,null,null,null,null,null,"Roof Skylight",30,30]
[null,null,null,null,null,null,null,null,null,"Roof System: reinforced concrete deck",100,100]
[null,null,null,null,null,null,null,null,null,"Roof System: service door",30,30]
[null,null,null,null,null,null,null,null,null,"Roof System: steel frame and sheet metal or insulated panel sheathing",100,100]
[null,null,null,null,null,null,null,null,null,"Roof System: tie downs, clips, braces, straps, hangers",75,75]
[null,null,null,null,null,null,null,null,null,"Roof System: wood frame and board or plywood sheathing",75,75]
[null,null,null,null,null,null,null,null,null,"Roof Vents: passive",40,40]
[null,null,null,null,null,null,null,null,null,"Roof Vents: powered",20,20]
[null,null,null,null,null,null,null,null,null,"Roofing: asphalt dimensional shingle 30 yr+",25,25]
[null,null,null,null,null,null,null,null,null,"Roofing: asphalt shingle",20,20]
[null,null,null,null,null,null,null,null,null,"Roofing: clay/cementitious barrel tile",60,60]
[null,null,null,null,null,null,null,null,null,"Roofing: low slope, adhered rubber membrane (EPDM)",15,15]
[null,null,null,null,null,null,null,null,null,"Roofing: low slope, built-up Roof, no mineral or gravel finish",10,10]
[null,null,null,null,null,null,null,null,null,"Roofing: low slope, built-up roof, with gravel finish",20,20]
[null,null,null,null,null,null,null,null,null,"Roofing: low slope, roof drains, scuppers",30,30]
[null,null,null,null,null,null,null,null,null,"Roofing: low slope, rubberized/elastomeric white/cool roof",15,15]
[null,null,null,null,null,null,null,null,null,"Roofing: low slope, thermoplastic membrane (TPO, vinyl)",15,15]
[null,null,null,null,null,null,null,null,null,"Roofing: metal",50,50]
[null,null,null,null,null,null,null,null,null,"Roofing: slate shingle",75,75]
[null,null,null,null,null,null,null,null,null,"Roofing: wood shingle, cedar shakes/shingles",25,25]
[null,null,null,null,null,null,null,null,null,"Security: buzzer/intercom, central panel",20,20]
[null,null,null,null,null,null,null,null,null,"Security: tenant buzzer / intercom /secured entry system",20,20]
[null,null,null,null,null,null,null,null,null,"Security: tenant space alarm systems",10,15]
[null,null,null,null,null,null,null,null,null,"Smoke and fire detection system: central panel",15,15]
[null,null,null,null,null,null,null,null,null,"Soffits: wood, vinyl or metal",20,20]
[null,null,null,null,null,null,null,null,null,"Stair, Exterior: tread - metal, concrete filled",20,20]
[null,null,null,null,null,null,null,null,null,"Stair, Exterior: tread - wood",15,15]
[null,null,null,null,null,null,null,null,null,"Stair, Exterior: concrete",50,50]
[null,null,null,null,null,null,null,null,null,"Stair, Exterior: wood frame/stringer",30,30]
[null,null,null,null,null,null,null,null,null,"Stair, Exterior: steel frame/stringer",40,40]
[null,null,null,null,null,null,null,null,null,"Stair: interior",50,50]
[null,null,null,null,null,null,null,null,null,"Stair, inteior and loft: railings",20,25]
[null,null,null,null,null,null,null,null,null,"Vapor Barrier (VDR): ground or underfloor",30,30]
[null,null,null,null,null,null,null,null,null,"Vents: screened gable end or soffitt ",30,30]
[null,null,null,null,null,null,null,null,null,"Walls: drywall",35,40]
[null,null,null,null,null,null,null,null,null,"Walls: paints, stains, clear finishes, interior",10,15]
[null,null,null,null,null,null,null,null,null,"Walls: plaster",50,50]
[null,null,null,null,null,null,null,null,null,"Walls: wall tile, ceramic, glass, natural stone",30,40]
[null,null,null,null,null,null,null,null,null,"Walls: wallpapers",10,15]
[null,null,null,null,null,null,null,null,null,"Window treatments: drapery rods: shades: blinds: etc",10,20]
[null,null,null,null,null,null,null,null,null,"Windows: aluminum",35,40]
[null,null,null,null,null,null,null,null,null,"Windows: storm/screen windows",7,10]
[null,null,null,null,null,null,null,null,null,"Windows: vinyl",30,30]
[null,null,null,null,null,null,null,null,null,"Windows: vinyl/alum clad wood",50,50]
[null,null,null,null,null,null,null,null,null,"Windows: wood, (dbl-hung, sgl-hung, casement, awning, sliders)",35,45]
[null,null,null,null,null,null,null,null,null,"Windows: wood, fixed pane, picture",40,45]
[null,null,null,null,null,null,null,null,null,"Walls: wall trim (base, chair rail, crown moldings)",25,35]