{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Form"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Form","index":0,"n_rows":31,"n_cols":25,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,8,30,12],[30,0,30,6],[2,22,2,24],[2,19,2,20],[9,0,13,0],[11,19,11,24],[12,18,13,18],[12,19,13,24],[29,8,29,12],[15,19,19,23],[0,0,0,17],[1,0,1,17],[25,0,26,0],[2,4,2,9],[2,11,2,13],[4,0,8,0],[14,0,18,0],[19,0,24,0]]}
["IAC Maintenance-Effectiveness Assessment Scoring"]
["Note: If you want to uncheck a checked cell, click somewhere else and come back to click your cell."]
[null,null,null,null,"Ratings",null,null,null,null,null,null,"Deficiency",null,null,null,null,null,null,null,"Y = rX",null,null,"Z = aY - b, b = 0"]
["Groups","Categories","CC","Weight",{"$f":"CONCATENATE(\"Superior (\", $U$5, \")\")","v":"Superior (1)"},{"$f":"CONCATENATE(\"Good [\", $U$6, \"]\")","v":"Good [0.85]"},{"$f":"CONCATENATE(\"Adequate [\", $U$7, \"]\")","v":"Adequate [0.75]"},{"$f":"CONCATENATE(\"Not Adequate [\", $U$8, \"]\")","v":"Not Adequate [0.65]"},{"$f":"CONCATENATE(\"Poor [\", $U$9, \"]\")","v":"Poor [0.55]"},{"$f":"CONCATENATE(\"N/A [\", $U$10, \"]\")","v":"N/A [1]"},null,{"$f":"CONCATENATE(\"Minor [\", $X$5, \"]\")","v":"Minor [0.66]"},{"$f":"CONCATENATE(\"Major [\", $X$6, \"]\")","v":"Major [0]"},{"$f":"CONCATENATE(\"None [\", $X$7, \"]\")","v":"None [1]"},null,"Row Ignored",null,"Score",null,"Ratings","Factors (r)",null,"Deficiency","Factor (a)","Subtract (b)"]
["Site","Roadways, Parking Lots, & Walkways",null,5,1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(J5=1, SUM(E5:J5) = 0 ), TRUE),\"Yes\", \"\")","v":""},null,{"$f":"CalculateRowScore($D5,$E5,$F5,$G5,$H5,$I5,$J5,$L5,$M5,$N5,$U$5,$U$6,$U$7,$U$8,$U$9,$U$10,$X$5,$X$6,$X$7,$Y$5,$Y$6,$Y$7,$P5)","v":5},null,"Superior",1,null,"Minor",0.66,0]
[null,"Grounds",null,3,1,null,null,null,null,null,null,null,null,null,null,"",null,3,null,"Good",0.85,null,"Major",0,0]
[null,"Positive Site Drainage Away from Structure(s)",null,8,1,null,null,null,null,null,null,null,null,null,null,"",null,8,null,"Adequate",0.75,null,"N/A",1,0]
[null,"Playgrounds, Equipment, & Fields",null,4,1,null,null,null,null,null,null,null,null,null,null,"",null,4,null,"Not Adequate",0.65]
[null,"Relocatables & Additional Structures",null,6,1,null,null,null,null,null,null,null,null,null,null,"",null,6,null,"Poor",0.55000000000000004]
["Building Exterior","Exterior Structure & Finishes",null,6,1,null,null,null,null,null,null,null,null,null,null,"",null,6,null,"N/A",1]
[null,"Roof Drains, Gutters, & Downspouts",null,7,1,null,null,null,null,null,null,null,null,null,null,"",null,7]
[null,"Windows, Caulking, & Skylights",null,3,1,null,null,null,null,null,null,null,null,null,null,"",null,3,"*","A category not answered will be considered as N/A"]
[null,"Entryways & Exterior Doors",null,7,1,null,null,null,null,null,null,null,null,null,null,"",null,7,"*","Used weights is total of all weights from only the categories being considered"]
[null,"Roofs, Flashing, and Gravel Stops",null,7,1,null,null,null,null,null,null,null,null,null,null,"",null,7]
["Building Interior","Interior Doors, Walls, Partitions, & Finishes ",null,3,1,null,null,null,null,null,null,null,null,null,null,"",null,3,null,"User notes:"]
[null,"Floors",null,3,1,null,null,null,null,null,null,null,null,null,null,"",null,3]
[null,"Interior Cleanliness & Appearance (incl. of Equip. Rooms)",null,6,1,null,null,null,null,null,null,null,null,null,null,"",null,6]
[null,"Ceilings",null,3,1,null,null,null,null,null,null,null,null,null,null,"",null,3]
[null,"Interior Lighting",null,5,1,null,null,null,null,null,null,null,null,null,null,"",null,5]
["Building Equipment & Systems","HVAC: Forced-air Heating, Ventilation, & Air Cond. (incl. Filters)",null,10,1,null,null,null,null,null,null,null,null,null,null,"",null,10]
[null,"Electrical Distribution & Service Equipment",null,3,1,null,null,null,null,null,null,null,null,null,null,"",null,3]
[null,"Boilers, Water Heaters, Steam, & Hot-water Distribution",null,8,1,null,null,null,null,null,null,null,null,null,null,"",null,8,null,"Overall Score","start","end"]
[null,"Plumbing Fixtures and Equipment",null,5,1,null,null,null,null,null,null,null,null,null,null,"",null,5,null,"Superior",0.9,1]
[null,"Fire and Safety Systems & Utility Controls",null,10,1,null,null,null,null,null,null,null,null,null,null,"",null,10,null,"Good",0.8,{"$f":"U23-0.01","v":0.89}]
[null,"Conveyances",null,5,1,null,null,null,null,null,null,null,null,null,null,"",null,5,null,"Adequate",0.7,{"$f":"U24-0.01","v":0.79}]
["Maintenance Management","Preventive Maintenance (PM)",null,15,1,null,null,null,null,null,null,null,null,null,null,"",null,15,null,"Not Adequate",0.6,{"$f":"U25-0.01","v":0.69}]
[null,"Computerized  Maint.  Mgmt. System (incl. Equip. Data)",null,14,1,null,null,null,null,null,null,null,null,null,null,"",null,14,null,"Poor",0,{"$f":"U26-0.01","v":0.59}]
[]
[null,"Total Weight",null,{"$f":"SUM(D5:D27)","v":146},null,null,null,null,null,null,null,null,null,null,null,null,"Total Raw Score",{"$f":"SUM(R5:R27)","v":146}]
[null,"Used Weight (Not applicable categories excluded)",null,{"$f":"SUM(D5:D27) -SUMPRODUCT((D5:D27)*(P5:P27=\"Yes\"))","v":146},null,null,null,null,"Overall Score:",null,null,null,null,null,null,null,"Scaled Score",{"$f":"ROUND(R29/D30, 2)","v":1}," <<< Raw score divided by total \"used\" weight"]
[{"$f":"IF(OR(SUM(E26:I26) = 0, SUM(E27:I27) = 0), \"You must rate all rows in Maintenance Management section\",\"  \")","v":"  "},null,null,null,null,null,null,null,"Overall Rating:",null,null,null,"Overall Rating",null,null,null,null,{"$f":"CalculateRating($R$30, $U$23,$U$24,$U$25,$U$26,$T$23,$T$24,$T$25,$T$26,$T$27)","v":"Superior"}]