{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Fire Stations Data","Interactive Worksheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"Fire Stations Data","index":0,"n_rows":81,"n_cols":16,"rows_kept":81,"cut":false,"hidden":true,"merged":[[78,0,78,3],[79,0,79,3],[0,10,0,12],[0,4,0,6],[0,1,0,3],[0,7,0,9],[69,0,69,3],[68,0,68,3],[70,0,70,3]]}
[9.2899999999999996E-2,"Space Allocation Standard",null,null,"One-Company Station",null,null,"Two Company Station",null,null,"AF \"Main\" Station"]
["Functional Component","m2","ft.2","Standard","No.","m2","ft.2","No.","m2","ft.2","No.","m2","ft.2","Notes",null,"Questions:"]
["Apparatus, Equip, & Maintenance",null,null,null,null,{"$f":"B3*E3","v":0},{"$f":"E3*C3","v":0},null,{"$f":"H3*B3","v":0},{"$f":"H3*C3","v":0},null,{"$f":"K3*B3","v":0},{"$f":"K3*C3","v":0}]
["Apparatus Bay - Extra Large",{"$f":"$A$1*C4","v":108.693},1170,"per truck",null,{"$f":"B4*E4","v":0},{"$f":"E4*C4","v":0},null,{"$f":"H4*B4","v":0},{"$f":"H4*C4","v":0},null,{"$f":"K4*B4","v":0},{"$f":"K4*C4","v":0},"Station"]
["Apparatus Bay - Large",{"$f":"$A$1*C5","v":86.954399999999993},936,"per truck",null,{"$f":"B5*E5","v":0},{"$f":"E5*C5","v":0},null,{"$f":"H5*B5","v":0},{"$f":"H5*C5","v":0},null,{"$f":"K5*B5","v":0},{"$f":"K5*C5","v":0},"Station"]
["Apparatus Bay - ARFF",{"$f":"$A$1*C6","v":122.628},1320,"per ARFF truck",null,{"$f":"B6*E6","v":0},{"$f":"E6*C6","v":0},null,{"$f":"H6*B6","v":0},{"$f":"H6*C6","v":0},null,{"$f":"K6*B6","v":0},{"$f":"K6*C6","v":0},"Station"]
["PPE Gear Storage",{"$f":"$A$1*C7","v":0.92899999999999994},10,"per person",null,{"$f":"B7*E7","v":0},{"$f":"E7*C7","v":0},null,{"$f":"H7*B7","v":0},{"$f":"H7*C7","v":0},null,{"$f":"K7*B7","v":0},{"$f":"K7*C7","v":0},"Station"]
["Hose Storage",5.0165999999999995,54,"per 52-Hose storage unit ",null,0,0,null,0,0,null,0,0,"Department"]
["SCBA Maintenance Room",13.377599999999999,144,"per four staffed vehicles",null,0,0,null,0,0,null,0,0,"Department"]
["SCBA Compressor Room",4.6449999999999996,50,"per four staffed vehicles",null,0,0,null,0,0,null,0,0,"Department"]
["Protective Clothing Laundry",{"$f":"$A$1*C11","v":9.2899999999999991},100,"per staffed vehicle",null,{"$f":"B11*E11","v":0},{"$f":"E11*C11","v":0},null,{"$f":"H11*B11","v":0},{"$f":"H11*C11","v":0},null,{"$f":"K11*B11","v":0},{"$f":"K11*C11","v":0},"Station"]
["Equipment  Wash/Disinfection",{"$f":"$A$1*C12","v":13.934999999999999},150,"per room",null,{"$f":"B12*E12","v":0},{"$f":"E12*C12","v":0},null,{"$f":"H12*B12","v":0},{"$f":"H12*C12","v":0},null,{"$f":"K12*B12","v":0},{"$f":"K12*C12","v":0},"Station"]
["Work Room/Equipment Maint.",11.148,120,"per room",null,0,0,null,0,0,null,0,0,"Station"]
["Vehicle Maint. Equipment Storage",{"$f":"$A$1*C14","v":37.159999999999997},400,"per station",null,{"$f":"B14*E14","v":0},{"$f":"E14*C14","v":0},null,{"$f":"H14*B14","v":0},{"$f":"H14*C14","v":0},null,{"$f":"K14*B14","v":0},{"$f":"K14*C14","v":0},"As dictated by Installation mission requirements"]
["EMT Storage (incl. locked Meds stor.)",3.7159999999999997,{"$f":"5*8","v":40},"per station",null,{"$f":"B15*E15","v":0},{"$f":"E15*C15","v":0},null,{"$f":"H15*B15","v":0},{"$f":"H15*C15","v":0},null,{"$f":"K15*B15","v":0},{"$f":"K15*C15","v":0},"Station"]
["HAZMAT/CBRNE Equip. Storage",11.148,120,"Tech. level / Tier 3 req.",null,0,0,null,0,0,null,0,0,"Department"]
["Spare PPE Gear Storage",5.9455999999999998,64,"per room ",null,0,0,null,0,0,null,0,0,"Department - storage for 30% total crew gear"]
["Fire Extinguisher Inspection",{"$f":"$A$1*C18","v":2.2296},24,"per inspection station",null,{"$f":"B18*E18","v":0},{"$f":"E18*C18","v":0},null,{"$f":"H18*B18","v":0},{"$f":"H18*C18","v":0},null,{"$f":"K18*B18","v":0},{"$f":"K18*C18","v":0},"Dept. - dictated by Installation mission requirements"]
["Non-FL Fire Exting. Maint. & Storage",{"$f":"$A$1*C19","v":11.148},120,"per room",null,{"$f":"B19*E19","v":0},{"$f":"E19*C19","v":0},null,{"$f":"H19*B19","v":0},{"$f":"H19*C19","v":0},null,{"$f":"K19*B19","v":0},{"$f":"K19*C19","v":0},"Dept. - dictated by Installation mission requirements"]
["Flightline Fire Exting. Maintenance",{"$f":"$A$1*C20","v":14.863999999999999},{"$f":"160","v":160},"per station",null,{"$f":"B20*E20","v":0},{"$f":"E20*C20","v":0},null,{"$f":"H20*B20","v":0},{"$f":"H20*C20","v":0},null,{"$f":"K20*B20","v":0},{"$f":"K20*C20","v":0},"Dept. - dictated by Installation mission requirements"]
["Flightline Fire Exting. Tank Recovery Exterior Covered Storage",{"$f":"$A$1*C21","v":3.7159999999999997},40,"per room",null,{"$f":"B21*E21","v":0},{"$f":"E21*C21","v":0},null,{"$f":"H21*B21","v":0},{"$f":"H21*C21","v":0},null,{"$f":"K21*B21","v":0},{"$f":"K21*C21","v":0},"Dept. - dictated by Installation mission requirements"]
["Spare FL Fire Exting. Tank Exterior Covered Storage",{"$f":"$A$1*C22","v":16.721999999999998},180,"9 sf/tank x 10% of total tanks",null,{"$f":"B22*E22","v":0},{"$f":"E22*C22","v":0},null,{"$f":"H22*B22","v":0},{"$f":"H22*C22","v":0},null,{"$f":"K22*B22","v":0},{"$f":"K22*C22","v":0},"As dictated by Installation mission requirements",null,"Data from George Hall at AF"]
["Vehicle Maintenance/Storage Bay",111.47999999999999,1200,"per station",null,0,0,null,0,0,null,0,0,"Department - AF only"]
["Vehicle Maintenance Office",13.934999999999999,150,"per office",null,0,0,null,0,0,null,0,0,"Tied to Vehicle Maintenance Bay"]
["Administrative and Training",null,null,null,null,{"$f":"B25*E25","v":0},{"$f":"E25*C25","v":0},null,{"$f":"H25*B25","v":0},{"$f":"H25*C25","v":0},null,{"$f":"K25*B25","v":0},{"$f":"K25*C25","v":0}]
["Station Officer's Office/ Watch Desk",{"$f":"$A$1*C26","v":11.148},120,"per office",null,0,0,null,0,0,null,0,0,"Station"]
["Fire Chief's Office",32.0505,{"$f":"140+140+65","v":345},"per office",null,0,0,null,0,0,null,0,0,"Department"]
["Chief's Conf. Room",11.148,120,"per room",null,0,0,null,0,0,null,0,0,"Department - tied to chief & deputy chief"]
["Deputy Chief's Office",11.148,120,"per office",null,0,0,null,0,0,null,0,0,"Dept. - dictated by Installation mission requirements"]
["Lobby Area",{"$f":"$A$1*C30","v":9.2899999999999991},100,"per lobby",null,{"$f":"B30*E30","v":0},{"$f":"E30*C30","v":0},null,{"$f":"H30*B30","v":0},{"$f":"H30*C30","v":0},null,{"$f":"K30*B30","v":0},{"$f":"K30*C30","v":0},"Department - tied to chief & deputy chief"]
["Admin. Asst.",{"$f":"$A$1*C31","v":5.9455999999999998},64,"per office",null,{"$f":"B31*E31","v":0},{"$f":"E31*C31","v":0},null,{"$f":"H31*B31","v":0},{"$f":"H31*C31","v":0},null,{"$f":"K31*B31","v":0},{"$f":"K31*C31","v":0},"Department - tied to chief & deputy chief"]
["Asst. Chief/ Shift Supervisor",11.148,120,"per office",null,0,0,null,0,0,null,0,0,"Dept. - dictated by Installation mission requirements"]
["Asst. Chief of Fire Prevention",11.148,120,"per office",null,0,0,null,0,0,null,0,0,"Dept. - dictated by Installation mission requirements"]
["Inspector(s) Offices",{"$f":"$A$1*C34","v":4.4592000000000001},{"$f":"6*8","v":48},"per workstations",null,0,0,null,0,0,null,0,0,"Department (may be spread-out over several stations)"]
["EMS Office",7.4319999999999995,80,"per office",null,0,0,null,0,0,null,0,0,"Station - dictated by Installation mission requirements"]
["HAZMAT/ Safety Office",11.148,120,"per office",null,0,0,null,0,0,null,0,0,"Dept. - dictated by Installation mission requirements"]
["Logistics Office",7.4319999999999995,80,"per office",null,0,0,null,0,0,null,0,0,"Dept. - dictated by Installation mission requirements"]
["Dept. Training Room",2.6012,28,"per person",null,{"$f":"B38*E38","v":0},{"$f":"E38*C38","v":0},null,{"$f":"H38*B38","v":0},{"$f":"H38*C38","v":0},null,{"$f":"K38*B38","v":0},{"$f":"K38*C38","v":0},"Department - total on-duty Fire Department Staff"]
["Training Room Storage",{"$f":"$A$1*C39","v":7.4319999999999995},80,"per training room",null,{"$f":"B39*E39","v":0},{"$f":"E39*C39","v":0},null,{"$f":"H39*B39","v":0},{"$f":"H39*C39","v":0},null,{"$f":"K39*B39","v":0},{"$f":"K39*C39","v":0},"Tied to Department Training Room"]
["Training Officer Office",9.2899999999999991,100,"per office",null,{"$f":"B40*E40","v":0},{"$f":"E40*C40","v":0},null,{"$f":"H40*B40","v":0},{"$f":"H40*C40","v":0},null,{"$f":"K40*B40","v":0},{"$f":"K40*C40","v":0},"Department"]
["Satellite Computer Training/Testing Room",13.006,140,"per four testing stations",null,{"$f":"B41*E41","v":0},{"$f":"E41*C41","v":0},null,{"$f":"H41*B41","v":0},{"$f":"H41*C41","v":0},null,{"$f":"K41*B41","v":0},{"$f":"K41*C41","v":0},"Satellite Station"]
["HQ Computer Training/Testing Room",17.651,190,"per six testing stations",null,null,{"$f":"E42*C42","v":0},null,null,{"$f":"H42*C42","v":0},null,null,{"$f":"K42*C42","v":0},"HQ Station"]
["General Admin Storage",{"$f":"$A$1*C43","v":7.4319999999999995},80,"per station",null,{"$f":"B43*E43","v":0},{"$f":"E43*C43","v":0},null,{"$f":"H43*B43","v":0},{"$f":"H43*C43","v":0},null,{"$f":"K43*B43","v":0},{"$f":"K43*C43","v":0},"Station"]
["IT Room",1.8579999999999999,20,"per room",null,0,0,null,0,0,null,0,0,"Station"]
["Dispatch",17.8368,192,"per dispatcher",null,0,0,null,0,0,null,0,0,"Department - either fire or consolidated"]
["Dispatch Supervisor",5.9455999999999998,64,"per workstation",null,0,0,null,0,0,null,0,0,"Department - tied to dispatch"]
["Dispatch Bathroom",4.4592000000000001,48,"per fixture (ADA)",null,0,0,null,0,0,null,0,0,"Department - tied to dispatch"]
["Dispatch Kitchenette",{"$f":"$A$1*C48","v":1.8579999999999999},{"$f":"4*5","v":20},"per kitchenette",null,{"$f":"B48*E48","v":0},{"$f":"E48*C48","v":0},null,{"$f":"H48*B48","v":0},{"$f":"H48*C48","v":0},null,{"$f":"K48*B48","v":0},{"$f":"K48*C48","v":0},"Department - tied to dispatch",null,"(Sink, micro, coffee, toaster, under-counter refridge)"]
["Additional IT Room Space",5.5739999999999998,60,"per room",null,0,0,null,0,0,null,0,0,"Tied to dispatch"]
["Emergency Generator Space",23.224999999999998,250,"per station",null,0,0,null,0,0,null,0,0,"station"]
["Residential and Living",null,null,null,null,0,0,null,0,0,null,0,0,null,null,"Hidden row above"]
["Day/Training Room",{"$f":"$A$1*C52","v":60.199199999999998},{"$f":"180+(18*26)","v":648},"per staffed vehicle",null,{"$f":"B52*E52","v":0},{"$f":"E52*C52","v":0},null,{"$f":"H52*B52","v":0},{"$f":"H52*C52","v":0},null,{"$f":"K52*B52","v":0},{"$f":"K52*C52","v":0},"Station = kitchen + dining/training + lounge"]
["Dorm Room with one bed",{"$f":"ROUND($A$1*C53,2)","v":10.029999999999999},{"$f":"9*12","v":108},"per room",null,{"$f":"E53*B53","v":0},0,null,0,0,null,0,0,"Station = staffed vehicle count + 1/company"]
["Dorm Room with two beds",{"$f":"ROUND($A$1*C54,2)","v":13.01},{"$f":"10*14","v":140},"per room",null,null,0,null,null,0,null,null,0,"Station = staffed vehicle count + 1/company"]
["Dorm Room with two fold-up beds",{"$f":"ROUND($A$1*C55,2)","v":9.2899999999999991},{"$f":"10*10","v":100},"per room",null,null,null,null,null,null,null,null,null,"Station = staffed vehicle count + 1/company"]
["Bathrooms/Showers/Changing",{"$f":"$A$1*C56","v":23.224999999999998},250,"per staffed vehicle",{"$f":"1+2","v":3},{"$f":"B56*E56","v":69.674999999999997},750,{"$f":"1+4","v":5},116.12499999999999,1250,null,0,0,"Station",null,"F(1 wc, 1 shower, 1 lav) + M(2 wc, 2 showers, 2 lav.) - F(1 wc, 1 shower, 1 lav) + M(4 wc, 4 showers, 3 lav.)"]
["Fitness Room",40.597299999999997,437,"per station",null,{"$f":"E57*B57","v":0},0,null,0,0,null,0,0,"Station - to accommodate 4 working out at one time",null,"(3 aerobic + univer + weights + water cooler)"]
["Laundry Room",7.4319999999999995,80,"per staffed vehicle",null,{"$f":"B58*E58","v":0},0,null,0,0,null,0,0,"Station - 1 washer, 2 dryers, sink, folding table"]
["Physical Therapy/Sauna",18.579999999999998,200,"per station",null,{"$f":"B59*E59","v":0},0,null,0,0,null,0,0,"Station - dictated by Installation mission requirements"]
["Recreation Room",33.443999999999996,360,"per station",null,{"$f":"B60*E60","v":0},0,null,0,0,null,0,0,"Optional - station = one or two \"game units\" "]
["Vending",1.8579999999999999,20,"per vending machine",null,{"$f":"B61*E61","v":0},0,null,0,0,null,0,0,"Station"]
["Other Spaces",null,null,null,null,{"$f":"B62*E62","v":0},0,null,0,0,null,0,0]
["SCPS (Surv. Collective Protective System)",null,null,null,null,null,null,null,null,null,null,null,null,"Only applies to Overseas Combination Stations (Geo. Hall)"]
["Reserve Offices",{"$f":"$A$1*C64","v":11.148},120,"per office",null,{"$f":"E64*$B$64","v":0},{"$f":"E64*C64","v":0},null,{"$f":"H64*B64","v":0},{"$f":"H64*C64","v":0},null,{"$f":"K64*$B$64","v":0},{"$f":"K64*C64","v":0},"AF only - dictated by Installation mission requirements",null,"Hidden row above"]
["Reserve and Active Duty Mobility/ Deployment Gear Storage ",{"$f":"$A$1*C65","v":18.579999999999998},200,"per station",null,{"$f":"B65*E65","v":0},{"$f":"E65*C65","v":0},null,{"$f":"H65*B65","v":0},{"$f":"H65*C65","v":0},null,{"$f":"K65*B65","v":0},{"$f":"K65*C65","v":0},"AF only - dictated by Installation mission requirements"]
["Reserve Firefighter PPE Gear",{"$f":"$A$1*C66","v":0.92899999999999994},10,"per person",null,{"$f":"B66*E66","v":0},{"$f":"E66*C66","v":0},null,{"$f":"H66*B66","v":0},{"$f":"H66*C66","v":0},null,{"$f":"K66*B66","v":0},{"$f":"K66*C66","v":0},"AF only - dictated by Installation mission requirements"]
["EOC Situation Room*",{"$f":"$A$1*C67","v":29.727999999999998},320,"per room",null,{"$f":"B67*E67","v":0},{"$f":"E67*C67","v":0},null,{"$f":"H67*B67","v":0},{"$f":"H67*C67","v":0},null,{"$f":"K67*B67","v":0},{"$f":"K67*C67","v":0},"Dept. - dictated by Installation mission requirements"]
["Public toilet (ADA-compliant, unisex)",{"$f":"$A$1*C68","v":4.1804999999999994},45,"per room",null,{"$f":"B68*E68","v":0},{"$f":"E68*C68","v":0},null,{"$f":"H68*B68","v":0},{"$f":"H68*C68","v":0},null,{"$f":"K68*B68","v":0},{"$f":"K68*C68","v":0},"Station"]
["Total Building Net Area-Core Spaces & Support",null,null,null,null,{"$f":"SUM(F3:F68)","v":69.674999999999997},{"$f":"SUM(G3:G68)","v":750},null,{"$f":"SUM(I3:I68)","v":116.12499999999999},{"$f":"SUM(J3:J68)","v":1250},null,{"$f":"SUM(L3:L68)","v":0},{"$f":"SUM(M3:M68)","v":0}]
[" Circulation and Mechanical Building Factor @",null,null,null,0.18,{"$f":"F69*E70","v":12.541499999999999},{"$f":"G69*E70","v":135},0.19,{"$f":"I69*H70","v":22.063749999999999},{"$f":"J69*H70","v":237.5},0.2,{"$f":"L69*K70","v":0},{"$f":"M69*K70","v":0}]
["Total Building Gross Area-Core Spaces & Support",null,null,null,null,{"$f":"SUM(F69:F70)","v":82.216499999999996},{"$f":"SUM(G69:G70)","v":885},null,{"$f":"SUM(I69:I70)","v":138.18874999999997},{"$f":"SUM(J69:J70)","v":1487.5},null,{"$f":"SUM(L69:L70)","v":0},{"$f":"SUM(M69:M70)","v":0}]
["Staff Parking",{"$f":"$A$1*C72","v":41.805},450,"per space (incl. circ.)",null,{"$f":"E72*B72","v":0},{"$f":"E72*C72","v":0},null,{"$f":"H72*B72","v":0},{"$f":"H72*C72","v":0},null,{"$f":"K72*B72","v":0},{"$f":"K72*C72","v":0},"Station",null,"Hidden rows above"]
["Visitor Parking",41.805,450,"per space (incl. circ.)",null,0,0,null,0,0,null,0,0,"Station"]
["Bicycle Rack Area",14.863999999999999,160,"per 10-bike Rack",null,0,0,null,0,0,null,0,0,"Station"]
["Site Approach to Apparatus Bays",185.79999999999998,2000,"per bay",null,0,0,null,0,0,null,0,0,"Station"]
["Agent Storage (ARFF)",6.9674999999999994,75,"per ARFF truck",null,0,0,null,0,0,null,0,0,"Station or Department - Foam + 2nd agent"]
["Agent Storage (Structural)",4.4592000000000001,48,"per Station (Struct. trucks)",null,0,0,null,0,0,null,0,0,"Station - Class A Foam"]
["Patio",13.934999999999999,150,"Min. (1 to 2 companies)",null,0,0,null,0,0,null,0,0,"Station - add 100 sf for 3-4 cos, add 100 sf for > 4 cos."]
["Total Site Support",null,null,null,null,{"$f":"SUM(F72:F78)","v":0},{"$f":"SUM(G72:G78)","v":0},null,{"$f":"SUM(I72:I78)","v":0},{"$f":"SUM(J72:J78)","v":0},null,{"$f":"SUM(L72:L78)","v":0},{"$f":"SUM(M72:M78)","v":0}]
["Total Facility (Building Gross Core Spaces and Site)",null,null,null,null,{"$f":"F79+F71","v":82.216499999999996},{"$f":"G79+G71","v":885},null,{"$f":"I79+I71","v":138.18874999999997},{"$f":"J79+J71","v":1487.5},null,{"$f":"L79+L71","v":0},{"$f":"M79+M71","v":0}]
["* Only if used in combination with Fire/EMS/Police."]

{"sheet":"Interactive Worksheet","index":1,"n_rows":215,"n_cols":15,"rows_kept":215,"cut":false,"hidden":false,"merged":[[183,4,183,6],[184,4,184,6],[187,4,187,6],[183,1,187,3],[91,14,94,14],[135,1,135,2],[139,1,139,2],[141,1,141,2],[143,1,143,2],[131,1,131,2],[145,1,145,2],[157,1,157,2],[2,11,2,12],[38,1,38,2],[22,1,24,2],[17,1,17,3],[20,5,21,6],[11,1,11,2],[11,3,11,6],[137,1,137,2],[73,1,73,2],[26,3,26,5],[32,1,33,2],[0,3,1,6],[2,0,2,6],[8,1,8,2],[0,1,1,2],[14,1,14,4],[80,1,81,1],[133,1,133,2],[169,1,169,2],[175,1,175,2],[40,1,40,2],[67,14,68,14],[97,14,98,14],[68,1,68,2],[82,1,83,2],[103,14,104,14]]}
[null,"ENTER PROJECT NAME \nAND INFORMATION:",null,null,null,null,null,null,null,null,null,null,null,null,"Rev.2, Nov 2013"]
[]
[{"$f":"IF(D1=0,\"Project Name and Information Here\",D1)","v":"Project Name and Information Here"},null,null,null,null,null,null,null,null,"Lists for Select Boxes",null,"Service Exceptions",null,null,"Notes"]
[]
["Select Service Branch:",null,null,null,null,null,null,null,null,"Army",null,"Army & Navy","AF & MC"]
[null,null,null,null,null,null,null,null,null,"Navy"]
[null,null,null,null,null,null,null,null,null,"Air Force"]
[{"$f":"\"Select Type of Facility\"","v":"Select Type of Facility"},null,null,null,null,null,null,null,null,"Marine Corps"]
[null,{"$f":"IF($C$5=0,,(IF(C5=\"Army\",\"* Select Type as Structural, ARFF, or Combination.\",(IF(C5=\"Navy\",\"* Select Type as Structural, ARFF, or Combination.\",(IF(C5=\"Air Force\",\"* Select Type as Structural, ARFF, or Combination.\",(IF(C5=\"Marine Corps\",\"* Select Type as Structural, ARFF, or Combination. Note: The Marine Corps rarely builds Combination Stations, and that selection must be justified.\",)))))))))","v":0}]
[null,null,null,null,null,null,null,null,null,"Structural"]
[{"$f":"\"Select Class of Facility\"","v":"Select Class of Facility"},null,null,null,null,null,null,null,null,"ARFF"]
[null,{"$f":"IF($C$8=0,,(IF(C5=\"Army\",\"* Select Class as HQ/Main or Satellite.  The Army does not build Large HQ Facilities.\",(IF(C5=\"Navy\",\"* Select Class as HQ/Main,  Satellite, or Large HQ.\",(IF(C5=\"Air Force\",\"* Select Class as HQ/Main,  Satellite, or Large HQ.\",(IF(C5=\"Marine Corps\",\"* Select Class as HQ/Main or Satellite.  The Marine Corps does not build Large HQ Facilities.\",)))))))))","v":0},null,{"$f":"IF(C8=\"Combination\",,IF(C11=\"Large HQ\",\"ERROR.  HQ/Main or Large HQ stations must be Combination stations.\",))","v":0},null,null,null,null,null,"Combination"]
[]
[{"$f":"\"Staffed Companies and Dorm Rooms\"","v":"Staffed Companies and Dorm Rooms"},null,null,null,null,null,null,null,null,"HQ/Main"]
[null,null,null,null,null,null,null,null,null,"Satellite"]
[null,{"$f":"IF(C11=0,,(IF(C8=\"ARFF\",,\"Enter No. of Structural Companies:\")))","v":0},null,null,null,null,null,null,null,"Large HQ",null,{"$f":"IF($C$11=0,,(IF(C5=\"Army\",\"* The Army typically builds 1- or 2-company stations, and Dorm Room count relates to Company count as follows: 5 rooms per structural co. and 4 rooms per ARFF co. You can modify the count below.\",(IF(C5=\"Navy\",\"* Navy stations range from 1 company up to 8 cos. Dorm Room count relates to co. count as follows: 5 rooms per structural co. and 4 rooms per ARFF co. You can modify the count below.\",)))))","v":0},{"$f":"IF($C$11=0,,(IF(C5=\"Air Force\",\"* Air Force stations range from 1 company up to 8 cos. Dorm Room counts relate to co. count as follows: 5 rooms per structural co. and 4 rooms per ARFF co. You can modify the count below.\",(IF(C5=\"Marine Corps\",\"* Marine Corps stations range from 1 company up to 8 cos. Dorm Room counts relate to co. count as follows: 4 rooms per structural co. and 4 rooms per ARFF co. You can modify the count below.\",)))))","v":0}]
[null,{"$f":"IF(C11=0,,(IF(C8=\"Structural\",,\"Enter No. of ARFF Companies:\")))","v":0}]
[null,{"$f":"IF($C$11=0,,(IF(C5=\"Army\",L16,(IF(C5=\"Navy\",L16,(IF(C5=\"Air Force\",M16,(IF(C5=\"Marine Corps\",M16,)))))))))","v":0},null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,"No"]
[null,{"$f":"IF($C$11=0,,\"Based on no. of companies entered, the following dorm rooms will be provided:\")","v":0},null,null,null,{"$f":"IF($C$8=\"Structural\",IF($C$17>0,\"ERROR\",($L$20+$M$20)),IF($C$8=\"ARFF\",IF($C$16>0,\"ERROR\",($L$20+$M$20)),($L$20+$M$20)))","v":0},null,null,null,null,null,{"$f":"IF($C$11=0,,(IF(C5=\"Army\",(C16*5)+(C17*4),(IF(C5=\"Navy\",(C16*5)+(C17*4),)))))","v":0},{"$f":"IF($C$11=0,,(IF(C5=\"Air Force\",(C16*5)+(C17*4),(IF(C5=\"Marine Corps\",(C16*4)+(C17*4),)))))","v":0}]
[null,null,null,null,null,{"$f":"IF(F20=\"Error\",\"Only enter data in shaded cells.\",)","v":0},null,null,null,"One Bed"]
[null,{"$f":"IF($C$11=0,,\"Modify Dorm Room count (+ or -) as needed:\")","v":0},null,null,null,null,null,null,null,"Two Beds"]
[null,{"$f":"IF($C$11=0,,\"* Add or subtract to the Dorm Room count as needed. Note, each Ambulance co. will typically require +2 rooms and each Rescue co. will typically require +3 rooms. Also consider X-staffing when modifying the count. Carefully review final room count with PM.\")","v":0},null,null,null,null,null,null,null,"Two Fold-ups"]
[]
[null,null,null,null,null,{"$f":"IF(C11=0,,\"Total Dorm Room Count:\")","v":0},{"$f":"IF(F20=0,0,F20+C22)","v":0},null,null,"Calculations"]
[]
[{"$f":"\"Enter No. of Each Class of Vehicle to be Housed\"","v":"Enter No. of Each Class of Vehicle to be Housed"},null,null,{"$f":"IF(G25=0,,\"     Bay Sizes **     \")","v":0},null,null,null,null,null,9.2899999999999996E-2]
[null,{"$f":"IF(G25=0,,\"Large\")","v":0},null,{"$f":"IF($G$25=0,,IF(B28=0,,(IF(($C$30+$C$31)>0,\"6706 mm (22 ft.) by 18288 mm (60 ft.)\",\"5944 mm (19.5 ft.) by 18288 mm (60 ft.)\"))))","v":0},null,null,null,null,null,{"$f":"IF($G$25=0,,(IF(($C$30+$C$31)>0,(22*60),(19.5*60))))","v":0},null,null,null,null,"If Ex. Lg or ARFF trucks are selected, all bays will be 60 ft. long."]
[null,{"$f":"IF(G25=0,,\"Medium\")","v":0},null,{"$f":"IF($G$25=0,,IF(B29=0,,(IF($C$30>0,\"6706 mm (22 ft.) by 18288 mm (60 ft.)\",(IF($C$31>0,(IF($C$28>0,\"6706 mm (22 ft.) by 18288 mm (60 ft.)\",\"6707 mm (22 ft.) by 14630 mm (48 ft.)\")),(IF($C$28>0,\"5944 mm (19.5 ft.) by 18288 mm (60 ft.)\",\"5944 mm (19.5 ft.) by 14630 mm (48 ft.)\"))))))))","v":0},null,null,null,null,null,{"$f":"IF($G$25=0,,(IF($C$30>0,(22*60),(IF($C$31>0,(IF($C$28>0,(22*60),(22*48))),(IF($C$28>0,(19.5*60),(19.5*48))))))))","v":0}]
[null,{"$f":"IF(G25=0,,\"Large ARFF\")","v":0},null,{"$f":"IF($G$25=0,,IF(B30=0,,\"6706 mm (22 ft.) by 18288 mm (60 ft.)\"))","v":0},null,null,null,null,null,{"$f":"IF($G$25=0,,(22*60))","v":0},null,null,null,null,"If ARFF trucks are selected, all the bays will be for a 12-ft. truck"]
[null,{"$f":"IF(G25=0,,\"Medium ARFF\")","v":0},null,{"$f":"IF($G$25=0,,IF(B31=0,,(IF(($C$30+$C$28)>0,\"6706 mm (22 ft.) by 18288 mm (60 ft.)\",\"6707 mm (22 ft.) by 14630 mm (48 ft.)\"))))","v":0},null,null,null,null,null,{"$f":"IF($G$25=0,,(IF(($C$30+$C$28)>0,(22*60),(22*48))))","v":0}]
[null,{"$f":"IF(G25=0,,\"Small\")","v":0},null,{"$f":"IF(G25=0,,\"Small vehicles do not have a dedicated bay size.\")","v":0}]
[null,{"$f":"IF($G25=0,,\"** Bay size includes area required around vehicle. Bay sizes are driven by largest vehicle selected, i.e., if at least 1 Large ARFF truck is entered, all bays will accommodate that size truck. See Para. 2-2.2-1 for more information.\")","v":0}]
[null,null,null,null,null,{"$f":"IF(G25=0,,\"Total Vehicles:\")","v":0},{"$f":"IF(G25=0,0,SUM($C$28:$C$32))","v":0}]
[]
[{"$f":"\"Maintenance and Apparatus Room Spaces\"","v":"Maintenance and Apparatus Room Spaces"}]
[null,null,null,null,null," m2","ft.2",null,null,null,null,"Army & Navy","AF & MC"]
[null,{"$f":"IF(G34=0,,\"Based on vehicle classes & quantities entered above, the basic Apparatus Room is sized:\")","v":0},null,null,null,{"$f":"G38*$J$27","v":0},{"$f":"(C28*J28)+(C29*J29)+(C30*J30)+(C31*J31)","v":0}]
[]
[null,{"$f":"IF(G34=0,,\"Based on the quantity of Small vehicles entered above, consider additional area as follows:\")","v":0},null,null,null,{"$f":"G40*$J$27","v":0},{"$f":"IF(M41=TRUE,,J40*J41)","v":0},null,null,{"$f":"ROUNDDOWN(C32/2,0)","v":0}]
[null,{"$f":"IF($G34=0,,\"* This suggested area must be carefully reviewed by the planning team. Review the actual size of Small vehicles and space available in other bays.\")","v":0},null,null,null,null,{"$f":"IF($G$34=0,,IF(J40=0,,\"Check here to delete additional Bay area. >\"))","v":0},null,null,{"$f":"IF(G34=0,,(SUMIF(C28:C31,\">0\",J28:J31))/(COUNT(C28:C31)))","v":0},null,null,false]
[]
[null,{"$f":"IF($G$34=0,,\"Based on no. of Dorm Rooms entered above, the PPE Gear Storage Area is sized:\")","v":0},null,null,null,{"$f":"G43*$J$27","v":0},{"$f":"IF(G34=0,,(G25*'Fire Stations Data'!C7))","v":0}]
[]
[null,{"$f":"IF($G$34=0,,IF(C11=\"Satellite\",\"Hose Storage is typically only provided in Main Stations. If required, check box below.\",\"Based on selections entered above, the Hose Storage Area is sized:\"))","v":0},null,null,null,{"$f":"G45*$J$27","v":0},{"$f":"IF(C11=\"Satellite\",IF(L46=TRUE,J45,0),J45)","v":0},null,null,{"$f":"IF(G34=0,,'Fire Stations Data'!C8)","v":0}]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"< Check here to add \"&'Fire Stations Data'!A8&\" in this Satellite station.\",))","v":0},null,null,null,null,null,null,null,null,null,false]
[]
[null,{"$f":"IF($G$34=0,,IF(C11=\"Satellite\",\"SCBA Maint. Room is typically only provided in Main Stations. If required, check box below.\",\"Based on selections entered above, the SCBA Maint. Room is sized:\"))","v":0},null,null,null,{"$f":"G48*$J$27","v":0},{"$f":"IF($C$11=\"Satellite\",IF(L49=TRUE,J48,0),J48)","v":0},null,null,{"$f":"IF($G$34=0,,IF(($C$16+$C$17)<5,(1*'Fire Stations Data'!C9),IF(($C$16+$C$17)<9,(2*'Fire Stations Data'!C9),IF(($C$16+$C$17)<13,(3*'Fire Stations Data'!C9),IF(($C$16+$C$17)<17,(4*'Fire Stations Data'!C9),IF(($C$16+$C$17)<21,(5*'Fire Stations Data'!C9),IF(($C$16+$C$17)<25,(6*'Fire Stations Data'!C9),)))))))","v":0}]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"< Check here to add \"&'Fire Stations Data'!A9&\" in this Satellite station.\",))","v":0},null,null,null,null,null,null,null,null,null,false]
[]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"SCBA Compressor Rm is typically only provided in Main Sta. If required, check box below.\",\"Based on selections entered above, the SCBA Compressor Rm is sized:\"))","v":0},null,null,null,{"$f":"G51*$J$27","v":0},{"$f":"IF($C$11=\"Satellite\",IF(L52=TRUE,J51,0),J51)","v":0},null,null,{"$f":"IF(G34=0,,IF(($C$16+$C$17)<5,(1*'Fire Stations Data'!C10),IF(($C$16+$C$17)<9,(2*'Fire Stations Data'!C10),IF(($C$16+$C$17)<13,(3*'Fire Stations Data'!C10),IF(($C$16+$C$17)<17,(4*'Fire Stations Data'!C10),IF(($C$16+$C$17)<21,(5*'Fire Stations Data'!C10),IF(($C$16+$C$17)<25,(6*'Fire Stations Data'!C10),)))))))","v":0}]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"< Check here to add \"&'Fire Stations Data'!A10&\" in this Satellite station.\",))","v":0},null,null,null,null,null,null,null,null,null,false]
[]
[null,{"$f":"IF($G$34=0,,\"Based on selections entered above, the Work Rm/Equip Maint. is sized:\")","v":0},null,null,null,{"$f":"G54*$J$27","v":0},{"$f":"IF($G$34=0,,'Fire Stations Data'!C13)","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Based on selections entered above, the Equip Wash/Disinfect. is sized:\")","v":0},null,null,null,{"$f":"G56*$J$27","v":0},{"$f":"IF($G$34=0,,'Fire Stations Data'!C12)","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Based on selections entered above, the Protect. Clothing Laund. is sized:\")","v":0},null,null,null,{"$f":"G58*$J$27","v":0},{"$f":"J58","v":0},null,null,{"$f":"IF($G$34=0,,IF(($C$16+$C$17)<3,(1*'Fire Stations Data'!C11),IF(($C$16+$C$17)<5,(2*'Fire Stations Data'!C11),IF(($C$16+$C$17)>4,(3*'Fire Stations Data'!C11),))))","v":0},null,null,null,null,"1 to 2 companies = 100 sf; 3 to 4 companies = 200 sf; 5+ companies = 300 sf."]
[]
[null,{"$f":"IF($G$34=0,,\"Based on selections entered above, the EMT Storage Room is sized:\")","v":0},null,null,null,{"$f":"G60*$J$27","v":0},{"$f":"IF($G$34=0,,'Fire Stations Data'!C15)","v":0}]
[]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"HAZMAT Equip. Storage is typically only provided in Main Sta. If required, check box below.\",\"Based on selections entered above, the HAZMAT Equip. Storage is sized:\"))","v":0},null,null,null,{"$f":"G62*$J$27","v":0},{"$f":"IF($C$11=\"Satellite\",IF(L63=TRUE,J62,0),J62)","v":0},null,null,{"$f":"IF(G34=0,,'Fire Stations Data'!C16)","v":0}]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"< Check here to add \"&'Fire Stations Data'!A16&\" in this Satellite station.\",))","v":0},null,null,null,null,null,null,null,null,null,false]
[]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"Spare PPE Storage is typically only provided in Main Sta. If required, check box below.\",\"Based on selections entered above, the Spare PPE Storage is sized:\"))","v":0},null,null,null,{"$f":"G65*$J$27","v":0},{"$f":"IF($C$11=\"Satellite\",IF(L66=TRUE,J65,0),J65)","v":0},null,null,{"$f":"IF(G34=0,,'Fire Stations Data'!C17)","v":0}]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"< Check here to add \"&'Fire Stations Data'!A17&\" in this Satellite station.\",))","v":0},null,null,null,null,null,null,null,null,null,false]
[]
[null,{"$f":"IF($G$34=0,,\"Select Vehicle Maint./Storage Bay (yes or no):\")","v":0},null,null,null,{"$f":"G68*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C68=\"Yes\",'Fire Stations Data'!C23,))","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Vehicle Maint./Storage Bay includes Vehicle Maint. Office at:\")","v":0},null,null,null,{"$f":"G70*$J$27","v":0},{"$f":"IF(G68=0,,'Fire Stations Data'!C24)","v":0}]
[null,{"$f":"IF($G$34=0,,\"Vehicle Maint./Storage Bay includes Vehicle Maint. Equipment Storage at:\")","v":0},null,null,null,{"$f":"G71*$J$27","v":0},{"$f":"IF(G68=0,,'Fire Stations Data'!C14)","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Enter Fire Exting. Inspection (no. of stations):\")","v":0},null,null,null,{"$f":"G73*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C73=0,,('Fire Stations Data'!C18*C73)))","v":0},null,null,null,null,null,null,null,"Limited to 10 Inspection Stations."]
[]
[null,{"$f":"IF($G$34=0,,\"Select Non-Flightline Fire Exting. Maint. (yes or no):\")","v":0},null,null,null,{"$f":"G75*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C75=\"Yes\",'Fire Stations Data'!C19,))","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Select Flightline (FL) Fire Exting. Maint. (yes or no):\")","v":0},null,null,null,{"$f":"G77*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C77=\"Yes\",'Fire Stations Data'!C20,))","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Select FL Fire Exting. Covered Storage (yes or no):\")","v":0},null,null,null,{"$f":"G79*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C79=\"Yes\",'Fire Stations Data'!C21,))","v":0}]
[]
[null,{"$f":"IF($G$34=0,,IF($C$5=\"Air Force\",\"Select \"&'Fire Stations Data'!A22&\" (yes or no):\",\"Air Force-only.\"))","v":0},null,null,null,{"$f":"G81*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C5=\"Air Force\",IF(C81=\"Yes\",'Fire Stations Data'!C22,),))","v":0}]
[]
[null,{"$f":"IF($G34=0,,IF(C5=\"Air Force\",\"* This Air Force-only item provides space for Spare Flightline Fire Extinguisher Tanks Exterior Covered Storage.\",))","v":0}]
[]
[]
[{"$f":"\"Day Room and Residential Area\"","v":"Day Room and Residential Area"}]
[null,null,null,null,null," m2","ft.2"]
[null,{"$f":"IF($G$34=0,,\"Based on no. of Companies entered above, the Day Room is sized:\")","v":0},null,null,null,{"$f":"G88*$J$27","v":0},{"$f":"IF($G$34=0,,((C16+C17)*'Fire Stations Data'!C52))","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Select Dorm Room bed configuration\")","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Based on Total Dorm Room Count & bed configuration selected, the Dorm Room Area is sized:\")","v":0},null,null,null,{"$f":"G92*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C90=J21,(G25*'Fire Stations Data'!C53),IF(C90=J22,(G25*'Fire Stations Data'!C54),IF(C90=J23,(G25*'Fire Stations Data'!C55),))))","v":0}]
[null,{"$f":"IF($G$34=0,,IF(C90=0,\"Must select bed configuration above.\",IF(C90=J21,\"This provides space for the '\"&C90&\"' configuration (at \"&'Fire Stations Data'!B53&\" sm (\"&'Fire Stations Data'!C53&\" sf) per room) for the following:\",IF(C90=J22,\"This provides space for the '\"&C90&\"' configuration (at \"&'Fire Stations Data'!B54&\" sm (\"&'Fire Stations Data'!C54&\" sf) per room) for the following:\",IF(C90=J23,\"This provides space for the '\"&C90&\"' configuration (at \"&'Fire Stations Data'!B55&\" sm (\"&'Fire Stations Data'!C55&\" sf) per room) for the following:\",\"Must select bed configuration above.\")))))","v":0}]
[null,{"$f":"IF($G$34=0,,IF(C16=0,\" 0  Structural Companies,\",\" \"&C16&\"  Structural Companies,\"))","v":0}]
[null,{"$f":"IF($G$34=0,,IF(C17=0,\" 0 ARFF Companies, and\",\" \"&C17&\"  ARFF Companies, and\"))","v":0}]
[null,{"$f":"IF($G$34=0,,IF(C22=0,\" 0 additional Dorm Rooms (for ambulance or rescue companies or other modifications).\",\" \"&C22&\"  additional Dorm Rooms (for ambulance or rescue companies or other modifications).\"))","v":0}]
[null,null,null,null,null,0,0,null,null,null,null,null,0]
[null,{"$f":"IF($G$34=0,,\"Based on no. of Companies entered above, the Bathrooms are sized:\")","v":0},null,null,null,{"$f":"G98*$J$27","v":0},{"$f":"IF($G$34=0,,J98)","v":0},null,null,{"$f":"IF($G$34=0,,IF(($C$16+$C$17)=1,('Fire Stations Data'!C56),IF(($C$16+$C$17)=2,('Fire Stations Data'!C56+80),IF(($C$16+$C$17)>2,(('Fire Stations Data'!C56+80)+(($C$16+$C$17-2)*50)),))))","v":0},null,null,null,null,"1 company = 250 sf; 2 companies = 330 sf; each additional co. over 2 adds 50 sf"]
[]
[null,{"$f":"IF($G$34=0,,\"Based on no. of Companies entered above, the Laundry Room is sized:\")","v":0},null,null,null,{"$f":"G100*$J$27","v":0},{"$f":"J100","v":0},null,null,{"$f":"IF($G$34=0,,IF(($C$16+$C$17)<3,(1*'Fire Stations Data'!C58),IF(($C$16+$C$17)<5,(2*'Fire Stations Data'!C58),IF(($C$16+$C$17)>4,(3*'Fire Stations Data'!C58),))))","v":0},null,null,null,null,"1 to 2 companies = 80 sf; 3 to 4 cos = 160 sf; 5+ companies = 240 sf."]
[]
[null,{"$f":"IF($G$34=0,,\"Based on no. of Companies entered above, the Fitness Room is sized:\")","v":0},null,null,null,{"$f":"G102*$J$27","v":0},{"$f":"IF($G$34=0,,'Fire Stations Data'!C57)","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Based on no. of Companies entered above, the Vending Area is sized:\")","v":0},null,null,null,{"$f":"G104*$J$27","v":0},{"$f":"IF($G$34=0,,J104)","v":0},null,null,{"$f":"IF($G$34=0,,IF(($C$16+$C$17)<3,(2*'Fire Stations Data'!C61),IF(($C$16+$C$17)<5,(3*'Fire Stations Data'!C61),IF(($C$16+$C$17)>4,(4*'Fire Stations Data'!C61),))))","v":0},null,null,null,null,"1 to 2 FF companies = 2 vending machines; 3 to 4 cos = 3 machines; and 5+ cos. = 4 machines"]
[]
[null,{"$f":"IF($G$34=0,,\"Select Physical Therepy/Sauna (yes or no)\")","v":0},null,null,null,{"$f":"G106*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C106=\"Yes\",'Fire Stations Data'!C59,))","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Select Recreation Room (yes or no)\")","v":0},null,null,null,{"$f":"G108*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C108=\"Yes\",'Fire Stations Data'!C60,))","v":0}]
[]
[]
[{"$f":"\"Training and Administrative Area\"","v":"Training and Administrative Area"}]
[null,null,null,null,null," m2","ft.2"]
[null,{"$f":"IF($G$34=0,,\"\"&'Fire Stations Data'!A26&\"\")","v":0},null,null,null,{"$f":"G113*$J$27","v":0},{"$f":"IF($G$34=0,,'Fire Stations Data'!C26)","v":0}]
[]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"\"&'Fire Stations Data'!A27&\" is typically only provided in HQ Stations. If required, check box below.\",\"Based on selections entered above, the \"&'Fire Stations Data'!A27&\" is provided:\"))","v":0},null,null,null,{"$f":"G115*$J$27","v":0},{"$f":"IF($C$11=\"Satellite\",IF(L116=TRUE,J115,0),IF(M116=TRUE,,J115))","v":0},null,null,{"$f":"IF($G$34=0,,'Fire Stations Data'!C27)","v":0}]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"< Check here to add \"&'Fire Stations Data'!A27&\" in this Satellite station.\",))","v":0},null,null,null,null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",,\"Check here to delete \"&'Fire Stations Data'!A27&\" in this HQ station. >\"))","v":0},null,null,null,null,false,false]
[]
[null,{"$f":"IF($G$34=0,,\"Select \"&'Fire Stations Data'!A29&\" (yes or no):\")","v":0},null,null,null,{"$f":"G118*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C118=\"Yes\",'Fire Stations Data'!C29,))","v":0}]
[]
[null,{"$f":"IF($G$34=0,,IF($G$115>0,\"Based on selections entered above, the \"&'Fire Stations Data'!A30&\" is provided:\",\"\"&'Fire Stations Data'!A30&\" is typically only provided with the \"&'Fire Stations Data'!A27&\". If required, check box below.\"))","v":0},null,null,null,{"$f":"G120*$J$27","v":0},{"$f":"IF($G$115>0,IF(M121=TRUE,0,J120),IF(L121=TRUE,J120,))","v":0},null,null,{"$f":"IF($G$34=0,,'Fire Stations Data'!C30)","v":0}]
[null,{"$f":"IF($G$34=0,,IF($G$115>0,,\"< Check here to add \"&'Fire Stations Data'!A30&\" in this station.\"))","v":0},null,null,null,null,{"$f":"IF($G$34=0,,IF($G$115>0,\"Check here to delete \"&'Fire Stations Data'!A30&\" in this HQ station. >\",))","v":0},null,null,null,null,false,false]
[]
[null,{"$f":"IF($G$34=0,,\"\"&'Fire Stations Data'!A68&\"\")","v":0},null,null,null,{"$f":"G123*$J$27","v":0},{"$f":"IF($G$34=0,,'Fire Stations Data'!C68)","v":0}]
[]
[null,{"$f":"IF($G$34=0,,IF($G$115>0,\"Based on selections entered above, the \"&'Fire Stations Data'!A31&\" is provided:\",\"\"&'Fire Stations Data'!A31&\" is typically only provided with the \"&'Fire Stations Data'!A27&\". If required, check box below.\"))","v":0},null,null,null,{"$f":"G125*$J$27","v":0},{"$f":"IF($G$115>0,IF(M126=TRUE,0,J125),IF(L126=TRUE,J125,))","v":0},null,null,{"$f":"IF($G$34=0,,'Fire Stations Data'!C31)","v":0}]
[null,{"$f":"IF($G$34=0,,IF($G$115>0,,\"< Check here to add \"&'Fire Stations Data'!A31&\" in this station.\"))","v":0},null,null,null,null,{"$f":"IF($G$34=0,,IF($G$115>0,\"Check here to delete \"&'Fire Stations Data'!A31&\" in this HQ station. >\",))","v":0},null,null,null,null,false,false]
[]
[null,{"$f":"IF($G$34=0,,IF($G$115>0,\"Based on selections entered above, the \"&'Fire Stations Data'!A28&\" is provided:\",\"\"&'Fire Stations Data'!A28&\" is typically only provided with \"&'Fire Stations Data'!A27&\". If required, check box below.\"))","v":0},null,null,null,{"$f":"G128*$J$27","v":0},{"$f":"IF($G$115>0,IF(M129=TRUE,0,J128),IF(L129=TRUE,J128,))","v":0},null,null,{"$f":"IF($G$34=0,,'Fire Stations Data'!C28)","v":0}]
[null,{"$f":"IF($G$34=0,,IF($G$115>0,,\"< Check here to add \"&'Fire Stations Data'!A28&\" in this station.\"))","v":0},null,null,null,null,{"$f":"IF($G$34=0,,IF($G$115>0,\"Check here to delete \"&'Fire Stations Data'!A28&\" in this HQ station. >\",))","v":0},null,null,null,null,false,false]
[]
[null,{"$f":"IF($G$34=0,,\"Select \"&'Fire Stations Data'!A32&\" (yes or no):\")","v":0},null,null,null,{"$f":"G131*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C131=\"Yes\",'Fire Stations Data'!C32,))","v":0}]
[null,{"$f":"IF($G$34=0,,IF(C11=\"Satellite\",\"* Note: This is usually only provided in HQ stations.\",))","v":0}]
[null,{"$f":"IF($G$34=0,,\"Select \"&'Fire Stations Data'!A33&\" (yes or no):\")","v":0},null,null,null,{"$f":"G133*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C133=\"Yes\",'Fire Stations Data'!C33,))","v":0}]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"* Note: This is usually only provided in HQ stations.\",))","v":0}]
[null,{"$f":"IF($G$34=0,,\"Enter \"&'Fire Stations Data'!A34&\" (no. of workstations):\")","v":0},null,null,null,{"$f":"G135*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C135=0,,('Fire Stations Data'!C34*C135)))","v":0},null,null,null,null,null,null,null,"Limited to 10 inspector workstations."]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"* Note: This is usually only provided in HQ stations. If required at this Satellite station, enter the no. of workstations desired.\",\"* If required, enter the no. of workstations desired at this station.\"))","v":0}]
[null,{"$f":"IF($G$34=0,,\"Select \"&'Fire Stations Data'!A35&\" (yes or no):\")","v":0},null,null,null,{"$f":"G137*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C137=\"Yes\",'Fire Stations Data'!C35,))","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Select \"&'Fire Stations Data'!A36&\" (yes or no):\")","v":0},null,null,null,{"$f":"G139*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C139=\"Yes\",'Fire Stations Data'!C36,))","v":0}]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"* Note: This is usually only provided in HQ stations.\",))","v":0}]
[null,{"$f":"IF($G$34=0,,\"Select \"&'Fire Stations Data'!A37&\" (yes or no):\")","v":0},null,null,null,{"$f":"G141*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C141=\"Yes\",'Fire Stations Data'!C37,))","v":0}]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"* Note: This is usually only provided in HQ stations.\",))","v":0}]
[null,{"$f":"IF($G$34=0,,\"Select \"&'Fire Stations Data'!A40&\" (yes or no):\")","v":0},null,null,null,{"$f":"G143*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C143=\"Yes\",'Fire Stations Data'!C40,))","v":0}]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"* Note: This is usually only provided in HQ stations or in conjunction with a \"&'Fire Stations Data'!A38&\" (see below).\",))","v":0}]
[null,{"$f":"IF($G$34=0,,\"Enter \"&'Fire Stations Data'!A38&\" (no. of people):\")","v":0},null,null,null,{"$f":"G145*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C145=0,,('Fire Stations Data'!C38*C145)))","v":0},null,null,null,null,null,null,null,"Limited to 100 people."]
[null,{"$f":"IF($G$34=0,,IF($C$11=\"Satellite\",\"* Note: This is usually only provided in HQ stations. If required at this Satellite station, enter the no. of people to be accommodated/trained (typically this no. is the total on-duty Department staff).\",\"* If required, enter the no. of people to be accommodated/trained (typically this no. is the total on-duty Department staff).\"))","v":0}]
[null,{"$f":"IF($G$34=0,,\"\"&'Fire Stations Data'!A38&\" includes \"&'Fire Stations Data'!A39&\" at:\")","v":0},null,null,null,{"$f":"G147*$J$27","v":0},{"$f":"IF(G145=0,,'Fire Stations Data'!C39)","v":0}]
[]
[null,{"$f":"IF($G$34=0,,IF(C11=J15,\"\"&'Fire Stations Data'!A41&\" (\"&'Fire Stations Data'!D41&\")\",\"\"&'Fire Stations Data'!A42&\" (\"&'Fire Stations Data'!D42&\")\"))","v":0},null,null,null,{"$f":"G149*$J$27","v":0},{"$f":"IF($G$34=0,,IF(M150=TRUE,0,J149))","v":0},null,null,{"$f":"IF($G$34=0,,IF(C11=J15,'Fire Stations Data'!C41,'Fire Stations Data'!C42))","v":0},null,null,null,null,"4 testing stations for satellite. 6 stations for HQ stations."]
[null,null,null,null,null,null,{"$f":"IF($G$34=0,,IF(C11=J15,\"Check here to delete \"&'Fire Stations Data'!A41&\" in this station. >\",\"Check here to delete \"&'Fire Stations Data'!A42&\" in this station. >\"))","v":0},null,null,null,null,null,false]
[]
[null,{"$f":"IF($G$34=0,,\"\"&'Fire Stations Data'!A43&\"\")","v":0},null,null,null,{"$f":"G152*$J$27","v":0},{"$f":"IF($G$34=0,,IF(M153=TRUE,0,'Fire Stations Data'!C43))","v":0}]
[null,null,null,null,null,null,{"$f":"IF($G$34=0,,\"Check here to delete \"&'Fire Stations Data'!A43&\" in this station. >\")","v":0},null,null,null,null,null,false]
[]
[null,{"$f":"IF($G$34=0,,\"\"&'Fire Stations Data'!A44&\"\")","v":0},null,null,null,{"$f":"G155*$J$27","v":0},{"$f":"IF($G$34=0,,'Fire Stations Data'!C44)","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Select \"&'Fire Stations Data'!A67&\" (yes or no):\")","v":0},null,null,null,{"$f":"G157*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C157=\"Yes\",'Fire Stations Data'!C67,))","v":0}]
[null,{"$f":"IF($G$34=0,,\"* Note: This is usually only provided in HQ stations that are consolidated with Police/ Security and Emergency Medical Services (EMS).\")","v":0}]
[null,{"$f":"IF($G$34=0,,IF($C$5=\"Air Force\",\"Enter \"&'Fire Stations Data'!A64&\" (no. of offices):\",\"Air Force-only.\"))","v":0},null,null,null,{"$f":"G159*$J$27","v":0},{"$f":"IF($G$34=0,,IF($C$5=\"Air Force\",(C159*'Fire Stations Data'!C64),))","v":0},null,null,null,null,null,null,null,"Limited to 10 offices"]
[]
[null,{"$f":"IF($G$34=0,,IF($C$5=\"Air Force\",\"Select Reserve & Active Duty Mob./Depl. Gear Storage:\",\"Air Force-only.\"))","v":0},null,null,null,{"$f":"G161*$J$27","v":0},{"$f":"IF($G$34=0,,IF($C$5=\"Air Force\",IF(C161=\"Yes\",'Fire Stations Data'!C65,),))","v":0}]
[]
[null,{"$f":"IF($G$34=0,,IF($C$5=\"Air Force\",\"Select \"&'Fire Stations Data'!A66&\" (no. of reservists):\",\"Air Force-only.\"))","v":0},null,null,null,{"$f":"G163*$J$27","v":0},{"$f":"IF($G$34=0,,IF($C$5=\"Air Force\",IF(C163=J163,('Fire Stations Data'!C66*M163),IF(C163=J164,('Fire Stations Data'!C66*M164),IF(C163=J165,('Fire Stations Data'!C66*M165),0)))))","v":0},null,null,{"$f":"\"\"&M163&\" Reservists\"","v":"12 Reservists"},null,null,12]
[null,null,null,null,null,null,null,null,null,{"$f":"\"\"&M164&\" Reservists\"","v":"24 Reservists"},null,null,24]
[null,null,null,null,null,null,null,null,null,{"$f":"\"\"&M165&\" Reservists\"","v":"36 Reservists"},null,null,36]
[]
[{"$f":"\"Dispatch\"","v":"Dispatch"}]
[null,null,null,null,null," m2","ft.2"]
[null,{"$f":"IF($G$34=0,,\"Enter no. of \"&'Fire Stations Data'!A45&\" stations (on-duty \"&'Fire Stations Data'!A45&\"ers):\")","v":0},null,null,null,{"$f":"G169*$J$27","v":0},{"$f":"IF($G$34=0,,IF(C169=0,,('Fire Stations Data'!C45*C169)))","v":0},null,null,null,null,null,null,null,"Limited to 5 Dispatchers.  - No. of dispatchers on duty"]
[]
[null,{"$f":"IF($G$34=0,,\"\"&'Fire Stations Data'!$A$45&\" includes \"&'Fire Stations Data'!A47&\" at:\")","v":0},null,null,null,{"$f":"G171*$J$27","v":0},{"$f":"IF(G169=0,,'Fire Stations Data'!C47)","v":0}]
[null,{"$f":"IF($G$34=0,,\"\"&'Fire Stations Data'!$A$45&\" includes \"&'Fire Stations Data'!A48&\" at:\")","v":0},null,null,null,{"$f":"G172*$J$27","v":0},{"$f":"IF(G169=0,,'Fire Stations Data'!C48)","v":0}]
[null,{"$f":"IF($G$34=0,,\"\"&'Fire Stations Data'!$A$45&\" includes \"&'Fire Stations Data'!A49&\" space at:\")","v":0},null,null,null,{"$f":"G173*$J$27","v":0},{"$f":"IF(G169=0,,'Fire Stations Data'!C49)","v":0}]
[]
[null,{"$f":"IF($G$34=0,,IF(G169=0,\"Only available with \"&'Fire Stations Data'!A45&\".\",\"Select \"&'Fire Stations Data'!A46&\" (yes or no):\"))","v":0},null,null,null,{"$f":"G175*$J$27","v":0},{"$f":"IF(G169=0,,IF(C175=\"Yes\",'Fire Stations Data'!C46,))","v":0}]
[null,{"$f":"IF($G$34=0,,IF(G169=0,,\"* This provides space for a \"&'Fire Stations Data'!A46&\"'s workstation.\"))","v":0}]
[]
[]
["Building Totals"]
[]
[null,null,null,"Subtotal - Total Net Building Area",null,{"$f":"G181*$J$27","v":0},{"$f":"SUM(G38:G180)","v":0}]
[]
[null,{"$f":"\"Net-to-Gross factor (modify as necessary):\"","v":"Net-to-Gross factor (modify as necessary):"},null,{"$f":"IF(C183=0,\"(factor at \"&J187&\")\",\"(factor at \"&C183&\")\")","v":"(factor at 0.22)"},null,{"$f":"G183*$J$27","v":0},{"$f":"IF(C183=0,G181*J187,G181*C183)","v":0},null,null,0.18]
[null,"*  The net-to-gross factor accounts for circulation space, mechanical space, and wall thicknesses.  The net-to-gross multiplier for Fire Stations may vary from 18% to 22% depending on the size of the Apparatus Room relative to the rest of the facility. Typically, the larger the Apparatus Bay, the lower the multiplier and vice versa. However, carefully consider the entire building configuration before changing the factor from the default setting of 22%.",null,null,null,null,null,null,null,0.19]
[null,null,null,null,null,null,null,null,null,0.2]
[null,null,null,null,null,null,null,null,null,0.21]
[null,null,null,null,null,null,null,null,null,0.22]
[]
[null,{"$f":"IF(G34=0,,\"Summary for \"&C5&\" Fire Station:\")","v":0},null,"TOTAL GROSS BUILDING",null,{"$f":"F183+F181","v":0},{"$f":"G183+G181","v":0}]
[null,{"$f":"IF(G34=0,,\"Type of Facility = \"&C8)","v":0}]
[null,{"$f":"IF(G34=0,,\"Class of Facility = \"&C11)","v":0}]
[null,{"$f":"IF(G34=0,,\"Total Dorm Room Count = \"&G25)","v":0}]
[null,{"$f":"IF(G34=0,,\"Total No. of Apparatus Bays = \"&J193&\" \")","v":0},null,null,null,null,null,null,null,{"$f":"IF(G40=0,SUM(C28:C31),SUM(C28:C31)+J40)","v":0}]
[]
[]
["Site"]
[null,null,null,null,null," m2","ft.2"]
[null,{"$f":"IF($G$34=0,,\"Based on selections entered above, \"&'Fire Stations Data'!A72&\" is sized:\")","v":0},null,null,null,{"$f":"G198*$J$27","v":0},{"$f":"IF(G34=0,,(G25*'Fire Stations Data'!C72*2))","v":0},null,null,null,null,null,null,null,"Using AF Guidance which states 200% of positions/shift"]
[]
[null,{"$f":"IF($G$34=0,,\"Based on selections entered above, \"&'Fire Stations Data'!A73&\" is sized:\")","v":0},null,null,null,{"$f":"G200*$J$27","v":0},{"$f":"IF(G34=0,,IF(OR(C11=J14,C11=J16),5*'Fire Stations Data'!C73,2*'Fire Stations Data'!C73))","v":0},null,null,null,null,null,null,null,"Using AF Guidance which states 5 spaces for HQ, 2 spaces for satellite"]
[]
[null,{"$f":"IF($G$34=0,,\"Based on selections entered above, \"&'Fire Stations Data'!A74&\" is sized:\")","v":0},null,null,null,{"$f":"G202*$J$27","v":0},{"$f":"IF(G34=0,,'Fire Stations Data'!C74)","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Based on selections entered above, \"&'Fire Stations Data'!A75&\" is sized:\")","v":0},null,null,null,{"$f":"G204*$J$27","v":0},{"$f":"IF(G34=0,,('Fire Stations Data'!C75*J193))","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Based on selections entered above, \"&'Fire Stations Data'!A76&\" is sized:\")","v":0},null,null,null,{"$f":"G206*$J$27","v":0},{"$f":"IF($G$34=0,,('Fire Stations Data'!C76*(C30+C31)))","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Based on selections entered above, \"&'Fire Stations Data'!A77&\" is sized:\")","v":0},null,null,null,{"$f":"G208*$J$27","v":0},{"$f":"IF($G$34=0,,('Fire Stations Data'!C77))","v":0}]
[]
[null,{"$f":"IF($G$34=0,,\"Based on selections entered above, \"&'Fire Stations Data'!A78&\" is sized:\")","v":0},null,null,null,{"$f":"G210*$J$27","v":0},{"$f":"IF($G$34=0,,J210)","v":0},null,null,{"$f":"IF($G$34=0,,IF(($C$16+$C$17)<3,('Fire Stations Data'!C78),IF(($C$16+$C$17)<5,('Fire Stations Data'!C78+100),IF(($C$16+$C$17)>4,(('Fire Stations Data'!C78+200)),\"Error\"))))","v":0},null,null,null,null,"1 to 2 companies = 150 sf; 3 to 4 cos = 250 sf; 5+ companies = 350 sf."]
[]
[null,null,null,"TOTAL GROSS SITE SUPPORT",null,{"$f":"SUM(F198:F210)","v":0},{"$f":"SUM(G198:G210)","v":0}]
[]
[]
[null,null,null,"TOTAL GROSS FACILITY (BUILDING + SITE SUPPORT)",null,{"$f":"F212+F189","v":0},{"$f":"G212+G189","v":0}]