{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Header","Types","Buildings","Stations","Vehicles","Simulation Scenarios","ResponseTime","CallData","Results"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":1,"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":"Header","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Name","Template"]
["Location","Anywhere, USA"]
["Population",500]
["Total Area (acres)",1000]
["Buildings (incl. F&ES)",9]
["Base F&ES Stations",1]
["Mutual Aid Stations",1]
["Vehicles",9]
["Maintenance Period",0.05]
["Maintenance Time",30]
["Replications",30]
["Random Seed",1234]

{"sheet":"Types","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Building Types","Vehicle Types","Station Types"]
["Residential","Pumper","Mil"]
["Commercial","Tanker","Civ"]
["Retail","EMS"]
["Warehouse","HazMat"]
["Manufacturing","Command"]
["Laboratory","Auxiliary"]
["Dock"]
["Airfield"]

{"sheet":"Buildings","index":2,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Index","BuildingID","BuildingName","Type","Floors","Floor Area (sq ft)","Units"]
[1,100,"Building A","Residential",3,750,1]
[2,101,"Building B","Commercial",5,10000,1]
[3,102,"Building C","Retail",2,10000,1]
[4,103,"Building D","Warehouse",4,10000,1]
[5,104,"Building E","Manufacturing",1,20000,1]
[6,105,"Building F","Laboratory",3,5000,1]
[7,106,"Building G","Dock",1,50000,1]
[8,107,"Building H","Airfield",1,100000,1]
[9,1,"Fire Station 1","Commercial",1,30000,1]

{"sheet":"Stations","index":3,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Index","Station","Vehicles","Crew","Type"]
[1,"Onsite Station 1",6,54,"Mil"]
[2,"Mutual Aid Station 1",3,4,"Civ"]

{"sheet":"Vehicles","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Index","Vehicle","Type","Location","Crew on Duty"]
[1,"Pumper 1","Pumper",1,4]
[2,"Tanker 1","Tanker",1,4]
[3,"Ambulance 1","EMS",1,2]
[4,"HazMat 1","HazMat",1,2]
[5,"Command 1","Command",1,1]
[6,"Aux 1","Auxiliary",1,1]
[7,"Pumper 2","Pumper",2,4]
[8,"Pumper 3","Pumper",2,4]
[9,"Ambulance 2","EMS",2,2]

{"sheet":"Simulation Scenarios","index":5,"n_rows":16,"n_cols":21,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Fire Origination","Final Spread Limited to:","Probability","Prob Bins","Damage/Scale","alpha","beta",null,null,null,null,"Probability Given Origination"]
[null,null,null,null,null,null,"Ground Level","Original Room",{"$f":"R3*$E$8","v":0.10500000000000001},0,0.2,4.1843470587596565,9.6910445433702748,null,null,null,null,{"$f":"1-E11","v":0.15000000000000002},null,{"$f":"AVERAGE(L3/L$7,L8/L$12)*T$7","v":4.1757024175468729},{"$f":"AVERAGE(M3/M$7,M8/M$12)*U$7","v":9.4722204700847854}]
[null,null,null,null,null,null,"Ground Level","2 rooms on same floor",{"$f":"R4*$E$8","v":8.9250000000000038E-2},{"$f":"J3+I3","v":0.10500000000000001},0.4,4.0659024588743193,11.742596836573297,null,null,null,null,{"$f":"E11-SUM(R5:R7)","v":0.12750000000000006},null,4.0629928349374884,11.592302622298762]
[null,null,null,null,null,null,"Ground Level","3 rooms on same floor",{"$f":"R5*$E$8","v":0.10114999999999996},{"$f":"J4+I4","v":0.19425000000000003},0.6,4.0296402920960697,13.099369730922533,null,null,null,null,{"$f":"E11^2-SUM(R6:R7)","v":0.14449999999999996},null,4.0280527122664616,13.005967803831384]
[null,null,null,null,null,null,"Ground Level","1 Room in Other Floor",{"$f":"R6*$E$8","v":6.0689999999999994E-2},0.2954,0.8,4.0113264144655432,14.14134047769006,null,null,null,null,{"$f":"E11^2*E12-R7","v":8.6699999999999999E-2},null,4.0105707517230424,14.097632059984019]
[null,null,null,null,null,null,"Ground Level","Whole House",{"$f":"R7*$E$8","v":0.34390999999999994},0.35609000000000002,1,4,15,null,null,null,null,{"$f":"E11^3*E12","v":0.49129999999999996},null,4,15]
["%Prob Fire Starting at Ground Level (1-P for Uppel Level)",null,null,null,0.7,null,"Upper Level","Original Room",{"$f":"R8*(1-$E$8)","v":4.5000000000000012E-2},{"$f":"J7+I7","v":0.7},0.2,3.7503519987006793,10.487182583039202,null,null,null,null,{"$f":"1-E15","v":0.15000000000000002},null,{"$f":"AVERAGE(L3/L$7,L8/L$12)*T$12","v":3.7581321757921855},10.735183199429422]
[null,null,null,null,null,null,"Upper Level","2 rooms on same floor",{"$f":"R9*(1-$E$8)","v":3.825000000000002E-2},0.745,0.4,3.6540748899005919,12.967609529094123,null,null,null,null,{"$f":"E15-SUM(R10:R12)","v":0.12750000000000006},null,3.6566935514437398,13.137942971938598]
["Ground Level",null,null,null,null,null,"Upper Level","3 rooms on same floor",{"$f":"R10*(1-$E$8)","v":8.6700000000000013E-2},0.78325,0.6,3.6238186191931674,14.634241326972266,null,null,null,null,{"$f":"E15^2-SUM(R11:R12)","v":0.28899999999999998},null,3.6252474410398157,14.740096844342235]
["% Prob Spread Room to Room",null,null,null,0.85,null,"Upper Level","1 Room in Other Floor",{"$f":"R11*(1-$E$8)","v":1.9507500000000004E-2},0.86995,0.8,3.6088335800824871,15.927780127915042,null,null,null,null,{"$f":"E15^2*E16-R12","v":6.5024999999999999E-2},null,3.6095136765507383,15.977316334648556]
["% Prob Spread from floor to floor (after adjacent rooms ignited)",null,null,null,0.8,null,"Upper Level","Whole House",{"$f":"R12*(1-$E$8)","v":0.1105425},0.88945750000000001,1,3.6,17,null,null,null,null,{"$f":"E15^3*E16","v":0.36847499999999994},null,3.6,17]
[]
["Upper Level"]
["% Prob Spread Room to Room",null,null,null,0.85]
["% Prob Spread from floor to floor (after adjacent rooms ignited)",null,null,null,0.6]

{"sheet":"ResponseTime","index":6,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Station Index",1,2]
["Station Name","Onsite Station 1","Mutual Aid Station 1"]
["Building Name"]
["Building A",5,7]
["Building B",4,8]
["Building C",6,5]
["Building D",7,4]
["Building E",5,5]
["Building F",4,5]
["Building G",7,5]
["Building H",2,9]
["Fire Station 1",0,6]

{"sheet":"CallData","index":7,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Period Start","2010-01-01"]
["Period End","2011-12-31"]
["Total Days",{"$f":"B2-B1","v":729}]
[null,null,null,null,"Civilian","F&ES"]
["Building Fires",20,null,"Fire Injuries",0,2]
["Vehicle Fires",10,null,"Non-Fire Injuries",0,1]
["Other Fires",30,null,"Fire Deaths",0,0]
["Overpressure Ruptures, Explosion, Overheat",10,null,"Non-Fire Deaths",0,0]
["Medical Treatment",500]
["Other Rescue",30]
["Hazardous Conditions",150]
["Service Calls",200]
["Good Intent",75]
["Severe Weather & Natural Disaster",12]
["Special Incident",1]
["Unknown Incident",0]
["Malicious False Calls",5]
["Other False Calls",100]
[]
["Total Calls",{"$f":"SUM(B5:B18)","v":1143}]
[]
[]
[null,null,null,null,null,null,{"$f":"1095*24","v":26280}]
[null,null,null,null,null,null,{"$f":"G23/33","v":796.36363636363637}]

{"sheet":"Results","index":8,"n_rows":17,"n_cols":18,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,3,0,4],[0,10,0,13],[0,6,0,8],[0,15,0,17],[0,1,0,2]]}
["Base:",{"$f":"Header!B1","v":"Template"},null,"Average Response Time",null,null,"Percent On Time",null,null,null,"Response Times in Minutes",null,null,null,null,"Fire Loss vs. Timeliness"]
["Reps:",{"$f":"Header!B11","v":30},null,"1st Truck",4.304771900177002,null,null,"On Time","Late",null,null,"1st Truck","2nd Truck","3rd Truck",null,null,"On Time","Late"]
[null,null,null,"2nd Truck",4.8719863891601562,null,"1st Truck",0.75999999046325684,0.23999999463558197,null,1,0,0,0,null,"Max",0.464731365442276,0.56355929374694824]
[null,null,null,"3rd Truck",4.9716653823852539,null,"2nd Truck",0.54000002145767212,0.46000000834465027,null,2,0,0,0,null,"3rd Quartile",0.16986067593097687,0.26468056440353394]
[null,null,null,null,null,null,"3rd Truck",0.5,0.5,null,3,76,47,41,null,"Median",0.11735109239816666,0.15895280241966248]
[null,null,null,null,null,null,null,null,null,null,4,119,90,84,null,"2nd Quartile",6.8009689450263977E-2,0.10504241287708282]
[null,null,null,null,null,null,null,null,null,null,5,85,76,76,null,"Min",0,0]
[null,null,null,null,null,null,null,null,null,null,6,25,68,74]
[null,null,null,null,null,null,null,null,null,null,7,9,33,39]
[null,null,null,null,null,null,null,null,null,null,8,0,0,0,null,null,"On Time","Late"]
[null,null,null,null,null,null,null,null,null,null,9,0,0,0,null,"Max",0.29487067461013794,0.29887872934341431]
[null,null,null,null,null,null,null,null,null,null,10,0,0,0,null,"3rd Quartile",5.2509583532810211E-2,0.10572776198387146]
[null,null,null,null,null,null,null,null,null,null,11,0,0,0,null,"Median",4.9341402947902679E-2,5.3910389542579651E-2]
[null,null,null,null,null,null,null,null,null,null,12,0,0,0,null,"1st Quartile",6.8009689450263977E-2,0.10504241287708282]
[null,null,null,null,null,null,null,null,null,null,13,0,0,0,null,"Min",6.8009689450263977E-2,0.10504241287708282]
[null,null,null,null,null,null,null,null,null,null,14,0,0,0]
[null,null,null,null,null,null,null,null,null,null,15,0,0,0]