{"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":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Name","SUBASE New London (Baseline)"]
["Location","Groton, CT"]
["Population",19500,"(7500 active duty + 12000 family members))"]
["Total Area (acres)",1217,"(687 for base, 530 for PPV area)"]
["Buildings (incl. F&ES)",131,"(243 for base per PCA, 160 major facilities per NLON website, found 130 on base map (+1 large PPV group (1495 units)))"]
["Base F&ES Stations",2]
["Mutual Aid Stations",3]
["Vehicles",21]
["Maintenance Period",0.05]
["Maintenance Time",30]
["Replications",30]
["Random Seed",17]

{"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":132,"n_cols":7,"rows_kept":132,"cut":false,"hidden":false,"merged":[]}
["Index","BuildingID","BuildingName","Type","Floors","Floor Area (sq ft)","Units"]
[1,1,"Port Operations","Dock",1,5000,1]
[2,17,"Naval Submarine Support Center (NSSC)","Commercial",1,5000,1]
[3,20,"Naval Submarine Support Facility (NSSF)","Manufacturing",1,10000,1]
[4,33,"FISC Maintenance Warehouse","Warehouse",2,5000,1]
[5,38,"Naval Submarine Support Facility (NSSF)","Manufacturing",1,10000,1]
[6,40,"Naval Submarine Support Facility (NSSF)","Manufacturing",1,10000,1]
[7,76,"Naval Submarine Support Center (NSSC)","Commercial",3,5000,1]
[8,77,"Phone Company","Commercial",1,2000,1]
[9,83,"Fleet and Family Support Center","Commercial",3,30000,1]
[10,84,"Legal Center/Supply","Commercial",1,5000,1]
[11,85,"PSV/Electric Boat","Commercial",2,5000,1]
[12,86,"SUBASE Headquarters","Commercial",4,5000,1]
[13,87,"Naval Submarine Support Center (NSSC)","Commercial",3,5000,1]
[14,89,"Naval Submarine Support Facility (NSSF)","Manufacturing",1,10000,1]
[15,103,"Naval Submarine Support Facility (NSSF)","Manufacturing",1,10000,1]
[16,106,"NAVSEC","Commercial",3,5000,1]
[17,107,"Fire Station 1","Commercial",2,1550,1]
[18,108,"Navy Exchange/Thrift","Retail",1,20000,1]
[19,120,"Indoor Swimming Pool","Residential",1,18000,1]
[20,135,"Public Works Dept","Commercial",2,5000,1]
[21,137,"Unknown","Commercial",1,2000,1]
[22,141,"Naval Submarine Research Medical Laboratory (NSRML)","Laboratory",2,25000,1]
[23,148,"Naval Submarine Research Medical Laboratory (NSRML)","Laboratory",2,25000,1]
[24,152,"Submarine School","Commercial",3,30000,1]
[25,153,"Naval Submarine Support Facility (NSSF)","Manufacturing",1,10000,1]
[26,156,"Naval Submarine Research Medical Laboratory (NSRML)","Laboratory",2,25000,1]
[27,157,"Naval Submarine Support Facility (NSSF)/Ant. Shop","Manufacturing",1,10000,1]
[28,159,"Navy Undersea Medical Institute","Laboratory",2,20000,1]
[29,160,"Brig","Residential",1,7500,1]
[30,164,"Dealey Center","Commercial",2,40000,1]
[31,166,"Naval Criminal Investigative Service (NCIS)","Commercial",2,5000,1]
[32,169,"Morton Hall Gymnasium","Commercial",1,35000,1]
[33,173,"Morale Welfare & Recreation (MWR)/Spikes","Retail",2,12500,1]
[34,174,"Naval Submarine Support Facility (NSSF)","Manufacturing",1,10000,1]
[35,175,"Naval Submarine Support Facility (NSSF)","Manufacturing",1,10000,1]
[36,176,"Naval Submarine Support Facility (NSSF)","Manufacturing",1,10000,1]
[37,178,"Morale Welfare & Recreation (MWR)","Commercial",1,5000,1]
[38,181,"Self Help","Commercial",1,5000,1]
[39,186,"Child Development Center","Commercial",2,12000,1]
[40,325,"Naval Submarine Support Facility (NSSF)/WEPS","Manufacturing",2,25000,1]
[41,326,"WT","Manufacturing",1,10000,1]
[42,355,"Defense Reutilization and Marketing Office (DRMO)","Commercial",2,5000,1]
[43,383,"Child Development Center","Commercial",2,8000,1]
[44,386,"Child Development Center","Commercial",2,8000,1]
[45,397,"Defense Reutilization and Marketing Office (DRMO)","Commercial",2,5000,1]
[46,410,"Dolphin Exp.","Commercial",1,5000,1]
[47,427,"Submarine School","Commercial",3,30000,1]
[48,428,"Navy Exchange","Retail",2,60000,1]
[49,429,"Barracks – Groton Hall","Residential",3,10750,1]
[50,430,"Barracks – Scorpion Hall","Residential",3,10750,1]
[51,434,"Barracks – Gato Hall","Residential",3,10750,1]
[52,435,"Barracks – Grayling Hall","Residential",3,10750,1]
[53,436,"Electric Boat","Commercial",2,5000,1]
[54,439,"Barracks – O'Kane Hall","Residential",3,10750,1]
[55,444,"WT","Commercial",1,10000,1]
[56,445,"Morale Welfare & Recreation (MWR)","Commercial",2,5000,1]
[57,446,"Cross Hall Galley","Retail",1,30000,1]
[58,448,"Submarine School","Commercial",3,15000,1]
[59,449,"Navy Branch Health Clinic","Laboratory",3,100000,1]
[60,451,"Public Works Dept Shop","Manufacturing",1,10000,1]
[61,454,"Morale Welfare & Recreation (MWR)","Commercial",2,5000,1]
[62,455,"Barracks – Nautilus Hall","Residential",3,10750,1]
[63,456,"Naval Submarine Support Facility (NSSF)","Manufacturing",2,10000,1]
[64,460,"Auto Shop/F&ES Storage","Manufacturing",1,1000,1]
[65,461,"Navy Exchange/Package","Retail",1,3000,1]
[66,462,"Security","Commercial",1,45000,1]
[67,465,"Submarine School","Commercial",3,20000,1]
[68,474,"Submarine School","Commercial",3,20000,1]
[69,476,"Public Works Dept","Manufacturing",1,10000,1]
[70,478,"Naval Submarine Support Facility (NSSF)/Metal","Manufacturing",1,35000,1]
[71,480,"WT","Commercial",2,5000,1]
[72,481,"Public Works Dept","Manufacturing",1,10000,1]
[73,483,"Public Works Dept","Manufacturing",1,10000,1]
[74,484,"Commissary/Navy Exchange","Retail",1,50000,1]
[75,485,"SUBASE Lanes Bowling Center","Retail",1,80000,1]
[76,488,"Barracks – Triton Hall","Residential",3,10750,1]
[77,492,"Barracks – Thresher Hall","Residential",3,10750,1]
[78,493,"Naval Submarine Support Facility (NSSF)/SUP","Warehouse",2,75000,1]
[79,499,"Submarine School","Commercial",3,25000,1]
[80,500,"Pass and ID Office","Commercial",1,2500,1]
[81,518,"Submarine School","Commercial",3,20000,1]
[82,519,"Submarine School","Commercial",3,30000,1]
[83,520,"Submarine School","Commercial",3,20000,1]
[84,521,"Veterinary Clinic","Laboratory",1,12000,1]
[85,522,"Racquetball Center","Commercial",1,30000,1]
[86,523,"Public Works Dept Shop","Manufacturing",1,10000,1]
[87,524,"Naval Submarine Support Facility (NSSF)/WEPS","Manufacturing",2,10000,1]
[88,530,"Morale Welfare & Recreation (MWR)/Pest Control","Laboratory",1,5000,1]
[89,533,"Submarine School","Commercial",3,17000,1]
[90,534,"Barracks – Fulton Hall","Residential",3,10750,1]
[91,535,"Thames View Marina","Dock",1,20000,1]
[92,548,"Vacant","Warehouse",2,12000,1]
[93,549,"Fuels","Laboratory",1,25000,1]
[94,553,"Environmental Oily Waste","Laboratory",1,7000,1]
[95,555,"Morale Welfare & Recreation (MWR)/Pest Control","Laboratory",1,5000,1]
[96,559,"Security Dog Kennel","Residential",1,8000,1]
[97,560,"Barracks – Bishop Hall","Residential",3,10750,1]
[98,561,"Supply/Chrimp","Warehouse",2,80000,1]
[99,562,"ENV","Manufacturing",1,9000,1]
[100,564,"Naval Submarine Support Facility (NSSF)/Nuclear Regional Maintenance Department","Laboratory",3,12000,1]
[101,569,"Liberty Recreation Center","Commercial",1,5000,1]
[102,571,"Nautilus","Retail",1,7500,1]
[103,574,"Small Boat Maintenance","Manufacturing",1,10000,1]
[104,575,"Navy Branch Health Clinic","Laboratory",3,50000,1]
[105,582,"Gate 7 Guard Shack","Commercial",1,1000,1]
[106,583,"Truck Inspection","Commercial",1,2000,1]
[107,588,"Unknown","Commercial",1,500,1]
[108,589,"Unknown","Commercial",1,500,1]
[109,590,"Unknown","Commercial",1,1000,1]
[110,592,"Sub Escape Trainer","Commercial",1,20000,1]
[111,602,"Crane Maintenance Facility","Manufacturing",2,35000,1]
[112,607,"Submarine Learning Center","Retail",1,1500,1]
[113,"109A","MAGFAC","Manufacturing",2,20000,1]
[114,"587A","Gate 1 Guard Shack","Commercial",1,500,1]
[115,"CH 1001","Chapel","Commercial",1,3000,1]
[116,"CH 1005","Dolphin Mart","Retail",1,1000,1]
[117,"CH 905","Morale Welfare & Recreation (MWR)/Youth Center","Commercial",2,10000,1]
[118,"DF 50","Navy Lodge","Residential",2,15000,1]
[119,"FIFE EST","Morale Welfare & Recreation (MWR)","Commercial",1,10000,1]
[120,"P1","Pier 1","Dock",1,13500,1]
[121,"P10","Pier 10","Dock",1,13500,1]
[122,"P2","Pier 1","Dock",1,13500,1]
[123,"P3","Pier 3","Dock",1,13500,1]
[124,"P4","Pier 4","Dock",1,13500,1]
[125,"P5","Pier 5","Dock",1,13500,1]
[126,"P6","Pier 6","Dock",1,13500,1]
[127,"P7","Pier 7","Dock",1,13500,1]
[128,"P8","Pier 8","Dock",1,13500,1]
[129,"P9","Pier 9","Dock",1,13500,1]
[130,"PP-141","Fire Station 2","Warehouse",1,1000,1]
[131,"PPV","PPV Housing","Residential",2,1000,1495]

{"sheet":"Stations","index":3,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Index","Station","Vehicles","Crew","Type"]
[1,"SUBASE New London Station 1 (Building 107)",5,54,"Mil"]
[2,"PPV Housing Station 2 (Building PP-141)",6,4,"Mil"]
[3,"City of Groton VFD Station 1",3,10,"Civ"]
[4,"Poquonnock Bridge VFD Long Hill Station",2,3,"Civ"]
[5,"Groton Ambulance Station 1",5,15,"Civ"]

{"sheet":"Vehicles","index":4,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Index","Vehicle","Type","Location","Crew on Duty"]
[1,"Engine Co-11","Pumper",1,4]
[2,"Engine Co-12","Pumper",1,4]
[3,"Ladder Co-15","Pumper",1,4]
[4,"Ambulance XX","EMS",1,2]
[5,"Excursion","Command",1,1]
[6,"Engine Co-25","Pumper",2,4]
[7,"HazMat XX","Hazmat",2,2]
[8,"Reserve Ambulance","EMS",2,2]
[9,"Explorer","Command",2,1]
[10,"Tahoe","Command",2,1]
[11,"Dodge Crew Cab","Auxiliary",2,1]
[12,"Engine G-11","Pumper",3,3]
[13,"Ladder G-15","Pumper",3,3]
[14,"Rescue G-27","EMS",3,3]
[15,"Engine G-33","Pumper",4,3]
[16,"Ladder G-35","Pumper",4,3]
[17,"Ambulance 1","EMS",5,2]
[18,"Ambulance 2","EMS",5,2]
[19,"Ambulance 3","EMS",5,2]
[20,"Ambulance 4","EMS",5,2]
[21,"Ambulance 5","EMS",5,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":134,"n_cols":7,"rows_kept":134,"cut":false,"hidden":false,"merged":[]}
["Response Time","Station Index",1,2,3,4,5]
[null,"Station Name","SUBASE New London Station 1 (Building 107)","PPV Housing Station 2 (Building PP-141)","City of Groton VFD Station 1","Poquonnock Bridge VFD Long Hill Station","Groton Ambulance Station 1"]
["Building Index","Building Name"]
[1,{"$f":"IF(A4=\"\",\"\",VLOOKUP(A4,[1]Buildings!$A$2:$F$301,3))","v":"Port Operations"},5,5,6,5,7]
[2,{"$f":"IF(A5=\"\",\"\",VLOOKUP(A5,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Center (NSSC)"},5,5,6,5,7]
[3,{"$f":"IF(A6=\"\",\"\",VLOOKUP(A6,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)"},5,5,6,5,7]
[4,{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,[1]Buildings!$A$2:$F$301,3))","v":"FISC Maintenance Warehouse"},5,5,6,5,7]
[5,{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)"},5,5,6,5,7]
[6,{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)"},5,5,6,5,7]
[7,{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Center (NSSC)"},5,5,6,5,7]
[8,{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,[1]Buildings!$A$2:$F$301,3))","v":"Phone Company"},5,5,6,5,7]
[9,{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,[1]Buildings!$A$2:$F$301,3))","v":"Fleet and Family Support Center"},5,5,6,5,7]
[10,{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,[1]Buildings!$A$2:$F$301,3))","v":"Legal Center/Supply"},5,5,6,5,7]
[11,{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,[1]Buildings!$A$2:$F$301,3))","v":"PSV/Electric Boat"},5,5,6,5,7]
[12,{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,[1]Buildings!$A$2:$F$301,3))","v":"SUBASE Headquarters"},5,5,6,5,7]
[13,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Center (NSSC)"},5,5,6,5,7]
[14,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)"},5,5,6,5,7]
[15,{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)"},5,5,6,5,7]
[16,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,[1]Buildings!$A$2:$F$301,3))","v":"NAVSEC"},5,5,6,5,7]
[17,{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,[1]Buildings!$A$2:$F$301,3))","v":"Fire Station 1"},0,5,6,5,7]
[18,{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,[1]Buildings!$A$2:$F$301,3))","v":"Navy Exchange/Thrift"},5,5,6,5,7]
[19,{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,[1]Buildings!$A$2:$F$301,3))","v":"Indoor Swimming Pool"},5,5,6,5,7]
[20,{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,[1]Buildings!$A$2:$F$301,3))","v":"Public Works Dept"},5,5,6,5,7]
[21,{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,[1]Buildings!$A$2:$F$301,3))","v":"Unknown"},5,5,6,5,7]
[22,{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Research Medical Laboratory (NSRML)"},5,5,6,5,7]
[23,{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Research Medical Laboratory (NSRML)"},5,5,6,5,7]
[24,{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,[1]Buildings!$A$2:$F$301,3))","v":"Submarine School"},5,5,6,5,7]
[25,{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)"},5,5,6,5,7]
[26,{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Research Medical Laboratory (NSRML)"},5,5,6,5,7]
[27,{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)/Ant. Shop"},5,5,6,5,7]
[28,{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,[1]Buildings!$A$2:$F$301,3))","v":"Navy Undersea Medical Institute"},5,5,6,5,7]
[29,{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,[1]Buildings!$A$2:$F$301,3))","v":"Brig"},5,5,6,5,7]
[30,{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,[1]Buildings!$A$2:$F$301,3))","v":"Dealey Center"},5,5,6,5,7]
[31,{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,[1]Buildings!$A$2:$F$301,3))","v":"Naval Criminal Investigative Service (NCIS)"},5,5,6,5,7]
[32,{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,[1]Buildings!$A$2:$F$301,3))","v":"Morton Hall Gymnasium"},5,5,6,5,7]
[33,{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,[1]Buildings!$A$2:$F$301,3))","v":"Morale Welfare & Recreation (MWR)/Spikes"},5,5,6,5,7]
[34,{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)"},5,5,6,5,7]
[35,{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)"},5,5,6,5,7]
[36,{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)"},5,5,6,5,7]
[37,{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,[1]Buildings!$A$2:$F$301,3))","v":"Morale Welfare & Recreation (MWR)"},5,5,6,5,7]
[38,{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,[1]Buildings!$A$2:$F$301,3))","v":"Self Help"},5,5,6,5,7]
[39,{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,[1]Buildings!$A$2:$F$301,3))","v":"Child Development Center"},5,5,6,5,7]
[40,{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)/WEPS"},5,5,6,5,7]
[41,{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,[1]Buildings!$A$2:$F$301,3))","v":"WT"},5,5,6,5,7]
[42,{"$f":"IF(A45=\"\",\"\",VLOOKUP(A45,[1]Buildings!$A$2:$F$301,3))","v":"Defense Reutilization and Marketing Office (DRMO)"},5,5,6,5,7]
[43,{"$f":"IF(A46=\"\",\"\",VLOOKUP(A46,[1]Buildings!$A$2:$F$301,3))","v":"Child Development Center"},5,5,6,5,7]
[44,{"$f":"IF(A47=\"\",\"\",VLOOKUP(A47,[1]Buildings!$A$2:$F$301,3))","v":"Child Development Center"},5,5,6,5,7]
[45,{"$f":"IF(A48=\"\",\"\",VLOOKUP(A48,[1]Buildings!$A$2:$F$301,3))","v":"Defense Reutilization and Marketing Office (DRMO)"},5,5,6,5,7]
[46,{"$f":"IF(A49=\"\",\"\",VLOOKUP(A49,[1]Buildings!$A$2:$F$301,3))","v":"Dolphin Exp."},5,5,6,5,7]
[47,{"$f":"IF(A50=\"\",\"\",VLOOKUP(A50,[1]Buildings!$A$2:$F$301,3))","v":"Submarine School"},5,5,6,5,7]
[48,{"$f":"IF(A51=\"\",\"\",VLOOKUP(A51,[1]Buildings!$A$2:$F$301,3))","v":"Navy Exchange"},5,5,6,5,7]
[49,{"$f":"IF(A52=\"\",\"\",VLOOKUP(A52,[1]Buildings!$A$2:$F$301,3))","v":"Barracks – Groton Hall"},5,5,6,5,7]
[50,{"$f":"IF(A53=\"\",\"\",VLOOKUP(A53,[1]Buildings!$A$2:$F$301,3))","v":"Barracks – Scorpion Hall"},5,5,6,5,7]
[51,{"$f":"IF(A54=\"\",\"\",VLOOKUP(A54,[1]Buildings!$A$2:$F$301,3))","v":"Barracks – Gato Hall"},5,5,6,5,7]
[52,{"$f":"IF(A55=\"\",\"\",VLOOKUP(A55,[1]Buildings!$A$2:$F$301,3))","v":"Barracks – Grayling Hall"},5,5,6,5,7]
[53,{"$f":"IF(A56=\"\",\"\",VLOOKUP(A56,[1]Buildings!$A$2:$F$301,3))","v":"Electric Boat"},5,5,6,5,7]
[54,{"$f":"IF(A57=\"\",\"\",VLOOKUP(A57,[1]Buildings!$A$2:$F$301,3))","v":"Barracks – O'Kane Hall"},5,5,6,5,7]
[55,{"$f":"IF(A58=\"\",\"\",VLOOKUP(A58,[1]Buildings!$A$2:$F$301,3))","v":"WT"},5,5,6,5,7]
[56,{"$f":"IF(A59=\"\",\"\",VLOOKUP(A59,[1]Buildings!$A$2:$F$301,3))","v":"Morale Welfare & Recreation (MWR)"},5,5,6,5,7]
[57,{"$f":"IF(A60=\"\",\"\",VLOOKUP(A60,[1]Buildings!$A$2:$F$301,3))","v":"Cross Hall Galley"},5,5,6,5,7]
[58,{"$f":"IF(A61=\"\",\"\",VLOOKUP(A61,[1]Buildings!$A$2:$F$301,3))","v":"Submarine School"},5,5,6,5,7]
[59,{"$f":"IF(A62=\"\",\"\",VLOOKUP(A62,[1]Buildings!$A$2:$F$301,3))","v":"Navy Branch Health Clinic"},5,5,6,5,7]
[60,{"$f":"IF(A63=\"\",\"\",VLOOKUP(A63,[1]Buildings!$A$2:$F$301,3))","v":"Public Works Dept Shop"},5,5,6,5,7]
[61,{"$f":"IF(A64=\"\",\"\",VLOOKUP(A64,[1]Buildings!$A$2:$F$301,3))","v":"Morale Welfare & Recreation (MWR)"},5,5,6,5,7]
[62,{"$f":"IF(A65=\"\",\"\",VLOOKUP(A65,[1]Buildings!$A$2:$F$301,3))","v":"Barracks – Nautilus Hall"},5,5,6,5,7]
[63,{"$f":"IF(A66=\"\",\"\",VLOOKUP(A66,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)"},5,5,6,5,7]
[64,{"$f":"IF(A67=\"\",\"\",VLOOKUP(A67,[1]Buildings!$A$2:$F$301,3))","v":"Auto Shop/F&ES Storage"},5,5,6,5,7]
[65,{"$f":"IF(A68=\"\",\"\",VLOOKUP(A68,[1]Buildings!$A$2:$F$301,3))","v":"Navy Exchange/Package"},5,5,6,5,7]
[66,{"$f":"IF(A69=\"\",\"\",VLOOKUP(A69,[1]Buildings!$A$2:$F$301,3))","v":"Security"},5,5,6,5,7]
[67,{"$f":"IF(A70=\"\",\"\",VLOOKUP(A70,[1]Buildings!$A$2:$F$301,3))","v":"Submarine School"},5,5,6,5,7]
[68,{"$f":"IF(A71=\"\",\"\",VLOOKUP(A71,[1]Buildings!$A$2:$F$301,3))","v":"Submarine School"},5,5,6,5,7]
[69,{"$f":"IF(A72=\"\",\"\",VLOOKUP(A72,[1]Buildings!$A$2:$F$301,3))","v":"Public Works Dept"},5,5,6,5,7]
[70,{"$f":"IF(A73=\"\",\"\",VLOOKUP(A73,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)/Metal"},5,5,6,5,7]
[71,{"$f":"IF(A74=\"\",\"\",VLOOKUP(A74,[1]Buildings!$A$2:$F$301,3))","v":"WT"},5,5,6,5,7]
[72,{"$f":"IF(A75=\"\",\"\",VLOOKUP(A75,[1]Buildings!$A$2:$F$301,3))","v":"Public Works Dept"},5,5,6,5,7]
[73,{"$f":"IF(A76=\"\",\"\",VLOOKUP(A76,[1]Buildings!$A$2:$F$301,3))","v":"Public Works Dept"},5,5,6,5,7]
[74,{"$f":"IF(A77=\"\",\"\",VLOOKUP(A77,[1]Buildings!$A$2:$F$301,3))","v":"Commissary/Navy Exchange"},5,5,6,5,7]
[75,{"$f":"IF(A78=\"\",\"\",VLOOKUP(A78,[1]Buildings!$A$2:$F$301,3))","v":"SUBASE Lanes Bowling Center"},5,5,6,5,7]
[76,{"$f":"IF(A79=\"\",\"\",VLOOKUP(A79,[1]Buildings!$A$2:$F$301,3))","v":"Barracks – Triton Hall"},5,5,6,5,7]
[77,{"$f":"IF(A80=\"\",\"\",VLOOKUP(A80,[1]Buildings!$A$2:$F$301,3))","v":"Barracks – Thresher Hall"},5,5,6,5,7]
[78,{"$f":"IF(A81=\"\",\"\",VLOOKUP(A81,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)/SUP"},5,5,6,5,7]
[79,{"$f":"IF(A82=\"\",\"\",VLOOKUP(A82,[1]Buildings!$A$2:$F$301,3))","v":"Submarine School"},5,5,6,5,7]
[80,{"$f":"IF(A83=\"\",\"\",VLOOKUP(A83,[1]Buildings!$A$2:$F$301,3))","v":"Pass and ID Office"},5,5,6,5,7]
[81,{"$f":"IF(A84=\"\",\"\",VLOOKUP(A84,[1]Buildings!$A$2:$F$301,3))","v":"Submarine School"},5,5,6,5,7]
[82,{"$f":"IF(A85=\"\",\"\",VLOOKUP(A85,[1]Buildings!$A$2:$F$301,3))","v":"Submarine School"},5,5,6,5,7]
[83,{"$f":"IF(A86=\"\",\"\",VLOOKUP(A86,[1]Buildings!$A$2:$F$301,3))","v":"Submarine School"},5,5,6,5,7]
[84,{"$f":"IF(A87=\"\",\"\",VLOOKUP(A87,[1]Buildings!$A$2:$F$301,3))","v":"Veterinary Clinic"},5,5,6,5,7]
[85,{"$f":"IF(A88=\"\",\"\",VLOOKUP(A88,[1]Buildings!$A$2:$F$301,3))","v":"Racquetball Center"},5,5,6,5,7]
[86,{"$f":"IF(A89=\"\",\"\",VLOOKUP(A89,[1]Buildings!$A$2:$F$301,3))","v":"Public Works Dept Shop"},5,5,6,5,7]
[87,{"$f":"IF(A90=\"\",\"\",VLOOKUP(A90,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)/WEPS"},5,5,6,5,7]
[88,{"$f":"IF(A91=\"\",\"\",VLOOKUP(A91,[1]Buildings!$A$2:$F$301,3))","v":"Morale Welfare & Recreation (MWR)/Pest Control"},5,5,6,5,7]
[89,{"$f":"IF(A92=\"\",\"\",VLOOKUP(A92,[1]Buildings!$A$2:$F$301,3))","v":"Submarine School"},5,5,6,5,7]
[90,{"$f":"IF(A93=\"\",\"\",VLOOKUP(A93,[1]Buildings!$A$2:$F$301,3))","v":"Barracks – Fulton Hall"},5,5,6,5,7]
[91,{"$f":"IF(A94=\"\",\"\",VLOOKUP(A94,[1]Buildings!$A$2:$F$301,3))","v":"Thames View Marina"},5,5,6,5,7]
[92,{"$f":"IF(A95=\"\",\"\",VLOOKUP(A95,[1]Buildings!$A$2:$F$301,3))","v":"Vacant"},5,5,6,5,7]
[93,{"$f":"IF(A96=\"\",\"\",VLOOKUP(A96,[1]Buildings!$A$2:$F$301,3))","v":"Fuels"},5,5,6,5,7]
[94,{"$f":"IF(A97=\"\",\"\",VLOOKUP(A97,[1]Buildings!$A$2:$F$301,3))","v":"Environmental Oily Waste"},5,5,6,5,7]
[95,{"$f":"IF(A98=\"\",\"\",VLOOKUP(A98,[1]Buildings!$A$2:$F$301,3))","v":"Morale Welfare & Recreation (MWR)/Pest Control"},5,5,6,5,7]
[96,{"$f":"IF(A99=\"\",\"\",VLOOKUP(A99,[1]Buildings!$A$2:$F$301,3))","v":"Security Dog Kennel"},5,5,6,5,7]
[97,{"$f":"IF(A100=\"\",\"\",VLOOKUP(A100,[1]Buildings!$A$2:$F$301,3))","v":"Barracks – Bishop Hall"},5,5,6,5,7]
[98,{"$f":"IF(A101=\"\",\"\",VLOOKUP(A101,[1]Buildings!$A$2:$F$301,3))","v":"Supply/Chrimp"},5,5,6,5,7]
[99,{"$f":"IF(A102=\"\",\"\",VLOOKUP(A102,[1]Buildings!$A$2:$F$301,3))","v":"ENV"},5,5,6,5,7]
[100,{"$f":"IF(A103=\"\",\"\",VLOOKUP(A103,[1]Buildings!$A$2:$F$301,3))","v":"Naval Submarine Support Facility (NSSF)/Nuclear Regional Maintenance Department"},5,5,6,5,7]
[101,{"$f":"IF(A104=\"\",\"\",VLOOKUP(A104,[1]Buildings!$A$2:$F$301,3))","v":"Liberty Recreation Center"},5,5,6,5,7]
[102,{"$f":"IF(A105=\"\",\"\",VLOOKUP(A105,[1]Buildings!$A$2:$F$301,3))","v":"Nautilus"},5,5,6,5,7]
[103,{"$f":"IF(A106=\"\",\"\",VLOOKUP(A106,[1]Buildings!$A$2:$F$301,3))","v":"Small Boat Maintenance"},5,5,6,5,7]
[104,{"$f":"IF(A107=\"\",\"\",VLOOKUP(A107,[1]Buildings!$A$2:$F$301,3))","v":"Navy Branch Health Clinic"},5,5,6,5,7]
[105,{"$f":"IF(A108=\"\",\"\",VLOOKUP(A108,[1]Buildings!$A$2:$F$301,3))","v":"Gate 7 Guard Shack"},5,5,6,5,7]
[106,{"$f":"IF(A109=\"\",\"\",VLOOKUP(A109,[1]Buildings!$A$2:$F$301,3))","v":"Truck Inspection"},5,5,6,5,7]
[107,{"$f":"IF(A110=\"\",\"\",VLOOKUP(A110,[1]Buildings!$A$2:$F$301,3))","v":"Unknown"},5,5,6,5,7]
[108,{"$f":"IF(A111=\"\",\"\",VLOOKUP(A111,[1]Buildings!$A$2:$F$301,3))","v":"Unknown"},5,5,6,5,7]
[109,{"$f":"IF(A112=\"\",\"\",VLOOKUP(A112,[1]Buildings!$A$2:$F$301,3))","v":"Unknown"},5,5,6,5,7]
[110,{"$f":"IF(A113=\"\",\"\",VLOOKUP(A113,[1]Buildings!$A$2:$F$301,3))","v":"Sub Escape Trainer"},5,5,6,5,7]
[111,{"$f":"IF(A114=\"\",\"\",VLOOKUP(A114,[1]Buildings!$A$2:$F$301,3))","v":"Crane Maintenance Facility"},5,5,6,5,7]
[112,{"$f":"IF(A115=\"\",\"\",VLOOKUP(A115,[1]Buildings!$A$2:$F$301,3))","v":"Submarine Learning Center"},5,5,6,5,7]
[113,{"$f":"IF(A116=\"\",\"\",VLOOKUP(A116,[1]Buildings!$A$2:$F$301,3))","v":"MAGFAC"},5,5,6,5,7]
[114,{"$f":"IF(A117=\"\",\"\",VLOOKUP(A117,[1]Buildings!$A$2:$F$301,3))","v":"Gate 1 Guard Shack"},5,5,6,5,7]
[115,{"$f":"IF(A118=\"\",\"\",VLOOKUP(A118,[1]Buildings!$A$2:$F$301,3))","v":"Chapel"},5,5,6,5,7]
[116,{"$f":"IF(A119=\"\",\"\",VLOOKUP(A119,[1]Buildings!$A$2:$F$301,3))","v":"Dolphin Mart"},5,5,6,5,7]
[117,{"$f":"IF(A120=\"\",\"\",VLOOKUP(A120,[1]Buildings!$A$2:$F$301,3))","v":"Morale Welfare & Recreation (MWR)/Youth Center"},5,5,6,5,7]
[118,{"$f":"IF(A121=\"\",\"\",VLOOKUP(A121,[1]Buildings!$A$2:$F$301,3))","v":"Navy Lodge"},5,5,6,5,7]
[119,{"$f":"IF(A122=\"\",\"\",VLOOKUP(A122,[1]Buildings!$A$2:$F$301,3))","v":"Morale Welfare & Recreation (MWR)"},5,5,6,5,7]
[120,{"$f":"IF(A123=\"\",\"\",VLOOKUP(A123,[1]Buildings!$A$2:$F$301,3))","v":"Pier 1"},5,5,6,5,7]
[121,{"$f":"IF(A124=\"\",\"\",VLOOKUP(A124,[1]Buildings!$A$2:$F$301,3))","v":"Pier 10"},5,5,6,5,7]
[122,{"$f":"IF(A125=\"\",\"\",VLOOKUP(A125,[1]Buildings!$A$2:$F$301,3))","v":"Pier 1"},5,5,6,5,7]
[123,{"$f":"IF(A126=\"\",\"\",VLOOKUP(A126,[1]Buildings!$A$2:$F$301,3))","v":"Pier 3"},5,5,6,5,7]
[124,{"$f":"IF(A127=\"\",\"\",VLOOKUP(A127,[1]Buildings!$A$2:$F$301,3))","v":"Pier 4"},5,5,6,5,7]
[125,{"$f":"IF(A128=\"\",\"\",VLOOKUP(A128,[1]Buildings!$A$2:$F$301,3))","v":"Pier 5"},5,5,6,5,7]
[126,{"$f":"IF(A129=\"\",\"\",VLOOKUP(A129,[1]Buildings!$A$2:$F$301,3))","v":"Pier 6"},5,5,6,5,7]
[127,{"$f":"IF(A130=\"\",\"\",VLOOKUP(A130,[1]Buildings!$A$2:$F$301,3))","v":"Pier 7"},5,5,6,5,7]
[128,{"$f":"IF(A131=\"\",\"\",VLOOKUP(A131,[1]Buildings!$A$2:$F$301,3))","v":"Pier 8"},5,5,6,5,7]
[129,{"$f":"IF(A132=\"\",\"\",VLOOKUP(A132,[1]Buildings!$A$2:$F$301,3))","v":"Pier 9"},5,5,6,5,7]
[130,{"$f":"IF(A133=\"\",\"\",VLOOKUP(A133,[1]Buildings!$A$2:$F$301,3))","v":"Fire Station 2"},5,0,6,5,7]
[131,{"$f":"IF(A134=\"\",\"\",VLOOKUP(A134,[1]Buildings!$A$2:$F$301,3))","v":"PPV Housing"},5,5,6,5,7]

{"sheet":"CallData","index":7,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Period Start","2004-01-01"]
["Period End","2006-12-31"]
["Total Days",{"$f":"B2-B1","v":1095}]
[null,null,null,null,"Civilian","F&ES"]
["Building Fires",33,null,"Fire Injuries",0,2]
["Vehicle Fires",12,null,"Non-Fire Injuries",0,1]
["Other Fires",73,null,"Fire Deaths",0,0]
["Overpressure Ruptures, Explosion, Overheat",18,null,"Non-Fire Deaths",0,0]
["Medical Treatment",1829]
["Other Rescue",69]
["Hazardous Conditions",314]
["Service Calls",273]
["Good Intent",199]
["Severe Weather & Natural Disaster",2]
["Special Incident",4]
["Unknown Incident",0]
["Malicious False Calls",24]
["Other False Calls",756]
[]
["Total Calls",{"$f":"SUM(B5:B18)","v":3606}]
[]
[]
[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":"SUBASE New London (Baseline)"},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]