{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Home","Your Info","Crowd Control Team Needs","Crowd Control Team Costs","Perimeter and Checkpoint Needs","Perimeter and Checkpoint Costs","Initial Costs","Annual Costs","Gap Costs","Lists","EquipmentCrowdControl","EquipmentPerimeter","Sheet2"],"not_rendered":{"charts":8,"images":1,"macros":1,"external_links":1,"defined_names":117,"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":"Home","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,1,11,10],[5,1,9,10]]}
[]
[]
[]
[]
[]
[null,"Public Safety and Security Response Capability Calculator"]
[]
[]
[]
[]
[null,"A tool for law enforcement and public safety agencies to use to estimate the number of crowd control and perimeter/checkpoint teams necessary to respond to a security event."]

{"sheet":"Your Info","index":1,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[[6,1,7,13],[12,7,12,8],[10,7,10,8],[15,1,16,13],[26,1,27,13],[20,7,20,8],[9,7,9,8],[11,7,11,8]]}
[]
[]
[]
[]
[]
[]
[null,"Event Information"]
[]
[]
[null,null,"Expected number of attendees",null,null,null,null,25000]
[null,null,"Length of event",null,null,null,null,6]
[null,null,"Number of officer shifts",null,null,null,null,1]
[null,null,"How often does this kind of event occur?",null,null,null,null,1]
[]
[]
[null,"Crowd Control Factors"]
[]
[]
[null,null,"Will your jurisdiction provide crowd control security for this event?",null,null,null,null,null,null,"Yes"]
[]
[null,null,"Desired officer-to-attendee ratio",null,null,null,"1 officer per",500]
[]
[null,null,"Suggested number of Crowd Control Teams",null,null,null,null,{"$f":"IF(CCInput=\"Yes\",ROUNDUP((EventAttendees/EventOfficerAttendeeRatio)/SUM(CCPersonnel),0),0)","v":1}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Results"]
[null,"Perimeter/Checkpoint Factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perimeter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(PCInput=\"yes\",IF(PCPerimeterTypeInput=\"Single\", G34, G36+G37),0)","v":500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Checkpoints"]
[null,null,"Will your jurisdiction provide perimeter security for this event?",null,null,null,null,null,null,"Yes",null,null,null,null,null,null,null,{"$f":"IF(OR(PCInput=\"No\",PCCheckpointInput=\"No\"),0,IF(PCPerimeterTypeInput=\"single\",H41,H43+H44))","v":4}]
[]
[null,null,"Does the event require a single or double perimeter?",null,null,null,null,null,null,"Single"]
[]
[null,null,"Length of perimeter",null,null,null,500]
[]
[null,null,"Length of outer perimeter",null,null,null,500]
[null,null,"Length of inner perimeter",null,null,null,200]
[]
[null,null,"Will your jurisdiction provide checkpoint/access point security for this event?",null,null,null,null,null,null,null,"Yes"]
[]
[null,null,"Number of access points for perimeter",null,null,null,null,4]
[]
[null,null,"Number of access points for outer perimeter",null,null,null,null,1]
[null,null,"Number of access points for inner perimeter",null,null,null,null,1]

{"sheet":"Crowd Control Team Needs","index":2,"n_rows":170,"n_cols":14,"rows_kept":170,"cut":false,"hidden":false,"merged":[[106,1,106,8],[107,1,107,8],[108,1,108,8],[109,1,109,8],[169,1,169,8],[164,1,164,8],[165,1,165,8],[166,1,166,8],[167,1,167,8],[168,1,168,8],[120,1,120,6],[121,1,121,6],[122,1,122,6],[123,1,123,6],[124,1,124,6],[125,1,125,6],[126,1,126,6],[127,1,127,6],[128,1,128,6],[163,1,163,8],[139,1,139,7],[140,1,140,7],[136,1,136,13],[147,1,147,13],[73,1,73,8],[80,1,80,8],[81,1,81,8],[100,1,100,8],[101,1,101,8],[102,1,102,8],[103,1,103,8],[104,1,104,8],[105,1,105,8],[64,1,64,8],[65,1,65,8],[66,1,66,8],[67,1,67,8],[68,1,68,8],[69,1,69,8],[70,1,70,8],[71,1,71,8],[72,1,72,8],[23,1,24,7],[25,1,25,8],[26,1,26,8],[27,1,27,8],[34,1,34,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[50,1,50,8],[48,1,48,8],[49,1,49,8],[51,1,51,8],[52,1,52,8],[53,1,53,8],[54,1,54,8],[55,1,55,8],[56,1,56,8],[57,1,57,8],[58,1,58,8],[59,1,59,8],[60,1,60,8],[61,1,61,8],[62,1,62,8],[63,1,63,8],[161,13,162,13],[118,13,119,13],[78,13,79,13],[8,13,9,13],[23,13,24,13],[32,13,33,13],[8,1,9,7],[32,1,33,7],[19,11,19,12],[28,11,28,12],[38,11,38,12],[74,11,74,12],[114,11,114,12],[129,11,129,12],[157,11,157,12],[135,1,135,7],[42,1,43,7],[78,1,79,7],[118,1,119,7],[133,1,134,7],[137,1,137,7],[138,1,138,7],[133,13,134,13],[42,13,43,13],[154,1,154,7],[155,1,155,7],[156,1,156,7],[161,1,162,7],[148,1,148,7],[149,1,149,7],[150,1,150,7],[151,1,151,7],[152,1,152,7],[153,1,153,7],[141,1,141,7],[142,1,142,7],[143,1,143,7],[144,1,144,7],[145,1,145,7],[146,1,146,7],[44,1,44,8],[45,1,45,8],[46,1,46,8],[47,1,47,8],[10,1,10,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[18,1,18,8],[110,1,110,8],[111,1,111,8],[112,1,112,8],[113,1,113,8],[6,1,6,4],[6,6,6,9],[91,1,91,8],[92,1,92,8],[93,1,93,8],[94,1,94,8],[95,1,95,8],[96,1,96,8],[97,1,97,8],[98,1,98,8],[99,1,99,8],[82,1,82,8],[83,1,83,8],[84,1,84,8],[85,1,85,8],[86,1,86,8],[87,1,87,8],[88,1,88,8],[89,1,89,8],[90,1,90,8]]}
[]
[]
[]
[]
[]
[]
[null,"Your suggested capability is",null,null,null,{"$f":"CCNumTeams","v":1},"  Crowd Control Team(s)."]
[]
[null,"Crowd Control Equipment",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N12:N19)","v":95910}]
[]
[null,"Item Description",null,null,null,null,null,null,null,"Default Quantity per Team","Quantity per Team","Total Quantity","Unit Cost","Total Initial Cost"]
[null,{"$f":"EquipmentCrowdControl!A3","v":"\"Grenade\" Launcher"},null,null,null,null,null,null,null,30,30,{"$f":"K12*CCNumTeams","v":30},2500,{"$f":"L12*M12","v":75000}]
[null,{"$f":"EquipmentCrowdControl!A4","v":"Smoke grenades"},null,null,null,null,null,null,null,150,150,150,25,{"$f":"L13*M13","v":3750}]
[null,{"$f":"EquipmentCrowdControl!A5","v":"\"Grenades\""},null,null,null,null,null,null,null,150,150,150,35,5250]
[null,{"$f":"EquipmentCrowdControl!A6","v":"Fogger"},null,null,null,null,null,null,null,30,30,30,26,780]
[null,{"$f":"EquipmentCrowdControl!A7","v":"Oleoresin Capsicum Fog Cartridge"},null,null,null,null,null,null,null,90,90,90,45,4050]
[null,{"$f":"EquipmentCrowdControl!A8","v":"Riot control batons"},null,null,null,null,null,null,null,59,59,59,35,2065]
[null,{"$f":"EquipmentCrowdControl!A9","v":"Bullhorns"},null,null,null,null,null,null,null,59,59,59,80,4720]
[null,{"$f":"EquipmentCrowdControl!A10","v":"Pepper spray"},null,null,null,null,null,null,null,59,59,59,5,295]
[null,null,null,null,null,null,null,null,null,null,null,"Total Initial Cost:  ",null,{"$f":"SUM(N12:N19)","v":95910}]
[]
[]
[]
[null,"Vehicles",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N27:N28)","v":180000}]
[]
[null,"Item Description",null,null,null,null,null,null,null,"Default Quantity per Team","Quantity per Team","Total Quantity","Unit Cost","Total Initial Cost"]
[null,{"$f":"EquipmentCrowdControl!A16","v":"Patrol Vehicles"},null,null,null,null,null,null,null,14,14,{"$f":"K27*CCNumTeams","v":14},10000,{"$f":"M27*L27","v":140000}]
[null,{"$f":"EquipmentCrowdControl!A17","v":"Prisoner Transport Vans"},null,null,null,null,null,null,null,2,2,{"$f":"K28*CCNumTeams","v":2},20000,{"$f":"M28*L28","v":40000}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Initial Cost:  ",null,{"$f":"SUM(N27:N28)","v":180000}]
[]
[]
[]
[null,"Mass Arrest Kit",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N36:N38)","v":14100}]
[]
[null,"Item Description",null,null,null,null,null,null,null,"Default Quantity per Team","Quantity per Team","Total Quantity","Unit Cost","Total Initial Cost"]
[null,{"$f":"EquipmentCrowdControl!A12","v":"Weather-resistant Field Booking forms"},null,null,null,null,null,null,null,30,30,{"$f":"K36*CCNumTeams","v":30},40,{"$f":"M36*L36","v":1200}]
[null,{"$f":"EquipmentCrowdControl!A13","v":"Digital camera"},null,null,null,null,null,null,null,30,30,{"$f":"K37*CCNumTeams","v":30},400,{"$f":"M37*L37","v":12000}]
[null,{"$f":"EquipmentCrowdControl!A14","v":"Fingerprinting equipment"},null,null,null,null,null,null,null,30,30,{"$f":"K38*CCNumTeams","v":30},30,900]
[null,null,null,null,null,null,null,null,null,null,null,"Total Initial Cost:  ",null,{"$f":"SUM(N36:N38)","v":14100}]
[]
[]
[]
[null,"Officer Equipment",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N46:N74)","v":231657}]
[]
[null,"Item Description",null,null,null,null,null,null,null,"Default Quantity per Team","Quantity per Team","Total Quantity","Unit Cost","Total Initial Cost"]
[null,{"$f":"EquipmentCrowdControl!A19","v":"Soft Body Armor"},null,null,null,null,null,null,null,59,59,{"$f":"K46*CCNumTeams","v":59},1000,{"$f":"M46*L46","v":59000}]
[null,{"$f":"EquipmentCrowdControl!A20","v":"Portable Radios"},null,null,null,null,null,null,null,59,59,59,570,{"$f":"M47*L47","v":33630}]
[null,{"$f":"EquipmentCrowdControl!A21","v":"Battery charger"},null,null,null,null,null,null,null,6,6,6,325,1950]
[null,{"$f":"EquipmentCrowdControl!A22","v":"Respiratory mask (NIOSH-approved)"},null,null,null,null,null,null,null,59,59,59,300,17700]
[null,{"$f":"EquipmentCrowdControl!A23","v":"Safety glasses"},null,null,null,null,null,null,null,59,59,59,3,177]
[null,{"$f":"EquipmentCrowdControl!A24","v":"Ear protection"},null,null,null,null,null,null,null,59,59,59,1,59]
[null,{"$f":"EquipmentCrowdControl!A25","v":"Fire extinguisher"},null,null,null,null,null,null,null,30,30,30,40,1200]
[null,{"$f":"EquipmentCrowdControl!A26","v":"Foul-weather gear"},null,null,null,null,null,null,null,59,59,59,15,885]
[null,{"$f":"EquipmentCrowdControl!A27","v":"Handheld shields"},null,null,null,null,null,null,null,59,59,59,100,5900]
[null,{"$f":"EquipmentCrowdControl!A28","v":"Personal hydration system"},null,null,null,null,null,null,null,59,59,59,50,2950]
[null,{"$f":"EquipmentCrowdControl!A29","v":"Level C PPE suits"},null,null,null,null,null,null,null,59,59,59,200,11800]
[null,{"$f":"EquipmentCrowdControl!A30","v":"Shoulder fired weapons"},null,null,null,null,null,null,null,0,0,0,0,0]
[null,{"$f":"EquipmentCrowdControl!A31","v":"Safety Helmet"},null,null,null,null,null,null,null,59,59,59,30,1770]
[null,{"$f":"EquipmentCrowdControl!A32","v":"Vest or Outer Garment, High-visibility  "},null,null,null,null,null,null,null,59,59,59,9,531]
[null,{"$f":"EquipmentCrowdControl!A33","v":"Handcuffs"},null,null,null,null,null,null,null,59,59,59,21,1239]
[null,{"$f":"EquipmentCrowdControl!A34","v":"Handcuff case"},null,null,null,null,null,null,null,59,59,59,16.5,973.5]
[null,{"$f":"EquipmentCrowdControl!A35","v":"Duty belt"},null,null,null,null,null,null,null,59,59,59,26,1534]
[null,{"$f":"EquipmentCrowdControl!A36","v":"Flashlight: MAG-LITE D-cell"},null,null,null,null,null,null,null,59,59,59,16,944]
[null,{"$f":"EquipmentCrowdControl!A37","v":"D-Cell Batteries (8)"},null,null,null,null,null,null,null,59,59,59,8,472]
[null,{"$f":"EquipmentCrowdControl!A38","v":"Flashlight holder (D-cell)"},null,null,null,null,null,null,null,59,59,59,5.75,339.25]
[null,{"$f":"EquipmentCrowdControl!A39","v":"Flex cuffs (10)"},null,null,null,null,null,null,null,59,59,59,11,649]
[null,{"$f":"EquipmentCrowdControl!A40","v":"Cutting tool for flex cuffs"},null,null,null,null,null,null,null,59,59,59,12.75,752.25]
[null,{"$f":"EquipmentCrowdControl!A41","v":"Knife"},null,null,null,null,null,null,null,59,59,59,107,6313]
[null,{"$f":"EquipmentCrowdControl!A42","v":"Waterproof Duty Boots"},null,null,null,null,null,null,null,59,59,59,124,7316]
[null,{"$f":"EquipmentCrowdControl!A43","v":"Regular Duty Boots"},null,null,null,null,null,null,null,59,59,59,65,3835]
[null,{"$f":"EquipmentCrowdControl!A44","v":"Regular Duty Gloves"},null,null,null,null,null,null,null,59,59,59,9,531]
[null,{"$f":"EquipmentCrowdControl!A45","v":"Kevlar-lined police leather gloves"},null,null,null,null,null,null,null,59,59,59,25,1475]
[null,{"$f":"EquipmentCrowdControl!A46","v":"Large rubber bands"},null,null,null,null,null,null,null,59,59,59,4,236]
[null,{"$f":"EquipmentCrowdControl!A47","v":"Handguns"},null,null,null,null,null,null,null,59,59,59,1144,67496]
[null,null,null,null,null,null,null,null,null,null,null,"Total Initial Cost:  ",null,{"$f":"SUM(N46:N74)","v":231657}]
[]
[]
[]
[null,"Communications and Logistics Equipment",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N82:N114)","v":1068334}]
[]
[null,"Item Description",null,null,null,null,null,null,null,"Default Quantity per Team","Quantity per Team","Total Quantity","Unit Cost","Total Initial Cost"]
[null,{"$f":"EquipmentCrowdControl!A49","v":"75’ Portable Communications Towers "},null,null,null,null,null,null,null,4,4,{"$f":"K82*CCNumTeams","v":4},90000,{"$f":"M82*L82","v":360000}]
[null,{"$f":"EquipmentCrowdControl!A50","v":"Satellite Communications trailer with data, VoIP & video capability"},null,null,null,null,null,null,null,2,2,2,199000,{"$f":"M83*L83","v":398000}]
[null,{"$f":"EquipmentCrowdControl!A51","v":"800 MHz 10 Watt Portable Repeaters"},null,null,null,null,null,null,null,1,1,1,8500,8500]
[null,{"$f":"EquipmentCrowdControl!A52","v":"800 MHz 25 Watt Portable Repeaters "},null,null,null,null,null,null,null,1,1,1,8500,8500]
[null,{"$f":"EquipmentCrowdControl!A53","v":"800 MHz Conventional Repeaters"},null,null,null,null,null,null,null,1,1,1,3934,3934]
[null,{"$f":"EquipmentCrowdControl!A54","v":"UHF Conventional Repeater"},null,null,null,null,null,null,null,1,1,1,4833,4833]
[null,{"$f":"EquipmentCrowdControl!A55","v":"UHF 10 Watt Portable Repeater"},null,null,null,null,null,null,null,1,1,1,1063,1063]
[null,{"$f":"EquipmentCrowdControl!A56","v":"VHF Conventional Repeater"},null,null,null,null,null,null,null,1,1,1,2500,2500]
[null,{"$f":"EquipmentCrowdControl!A57","v":"VHF 10 Watt Portable Repeater"},null,null,null,null,null,null,null,1,1,1,1063,1063]
[null,{"$f":"EquipmentCrowdControl!A58","v":"VHF, UHF & 800 MHz Desk Top Control Station "},null,null,null,null,null,null,null,1,1,1,10156,10156]
[null,{"$f":"EquipmentCrowdControl!A59","v":"800 MHz Handheld Radios  (Motorola XTS 2500)"},null,null,null,null,null,null,null,1,1,1,2500,2500]
[null,{"$f":"EquipmentCrowdControl!A60","v":"VHF Handheld Radios "},null,null,null,null,null,null,null,1,1,1,800,800]
[null,{"$f":"EquipmentCrowdControl!A61","v":"UHF Handheld Radios "},null,null,null,null,null,null,null,1,1,1,806,806]
[null,{"$f":"EquipmentCrowdControl!A62","v":"6 bay rack chargers "},null,null,null,null,null,null,null,1,1,1,639,639]
[null,{"$f":"EquipmentCrowdControl!A63","v":"Law enforcement surveillance equipment"},null,null,null,null,null,null,null,1,1,1,5432,5432]
[null,{"$f":"EquipmentCrowdControl!A64","v":"Mapping/GIS Software"},null,null,null,null,null,null,null,1,1,1,40000,40000]
[null,{"$f":"EquipmentCrowdControl!A65","v":"Data Acquisition Software"},null,null,null,null,null,null,null,1,1,1,7040,7040]
[null,{"$f":"EquipmentCrowdControl!A66","v":"Data Exchange and Interoperability Software of System(s)"},null,null,null,null,null,null,null,1,1,1,40000,40000]
[null,{"$f":"EquipmentCrowdControl!A67","v":"Intelligence Sharing System"},null,null,null,null,null,null,null,1,1,1,60000,60000]
[null,{"$f":"EquipmentCrowdControl!A68","v":"Generator (14,000 Watts)"},null,null,null,null,null,null,null,2,2,2,3689,7378]
[null,{"$f":"EquipmentCrowdControl!A69","v":"Generator (7,000 Watts)"},null,null,null,null,null,null,null,0,0,0,2300,0]
[null,{"$f":"EquipmentCrowdControl!A70","v":"Video capture software"},null,null,null,null,null,null,null,1,1,1,50,50]
[null,{"$f":"EquipmentCrowdControl!A71","v":"Document Scanner"},null,null,null,null,null,null,null,2,2,2,450,900]
[null,{"$f":"EquipmentCrowdControl!A72","v":"Fax Machine: Canon L90 Laser"},null,null,null,null,null,null,null,2,2,2,100,200]
[null,{"$f":"EquipmentCrowdControl!A73","v":"Printer: HP LaserJet P4014N"},null,null,null,null,null,null,null,2,2,2,900,1800]
[null,{"$f":"EquipmentCrowdControl!A74","v":"Copy Machine: Canon MF6540"},null,null,null,null,null,null,null,2,2,2,500,1000]
[null,{"$f":"EquipmentCrowdControl!A75","v":"Power strip (six outlet, surge protection)"},null,null,null,null,null,null,null,10,10,10,12,120]
[null,{"$f":"EquipmentCrowdControl!A76","v":"40' Extension Cord"},null,null,null,null,null,null,null,10,10,10,32,320]
[null,{"$f":"EquipmentCrowdControl!A77","v":"Single-unit Rapid Charger"},null,null,null,null,null,null,null,1,1,1,60,60]
[null,{"$f":"EquipmentCrowdControl!A78","v":"6 Unit Multi-Charger"},null,null,null,null,null,null,null,1,1,1,190,190]
[null,{"$f":"EquipmentCrowdControl!A79","v":"Microsoft Office/Adobe Acrobat"},null,null,null,null,null,null,null,1,1,1,200,200]
[null,{"$f":"EquipmentCrowdControl!A80","v":"ACU-1000 "},null,null,null,null,null,null,null,1,1,1,100000,100000]
[null,{"$f":"EquipmentCrowdControl!A81","v":"DC Power Electrical Rectifier system"},null,null,null,null,null,null,null,1,1,1,350,350]
[null,null,null,null,null,null,null,null,null,null,null,"Total Initial Cost:  ",null,{"$f":"SUM(N82:N114)","v":1068334}]
[]
[]
[]
[null,"Personnel",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N122:N129)","v":12048}]
[]
[null,"Item Description",null,null,null,null,null,"Default Quantity per Team","Quantity per Team","Number of Shifts","Total Personnel","Hours Deployed","Hourly Wage/\nBackfill","Operational Cost"]
[null,"Officer in Charge",null,null,null,null,null,1,1,{"$f":"EventShifts","v":1},{"$f":"I122*J122*CCNumTeams","v":1},{"$f":"EventLength","v":6},52,{"$f":"K122*L122*M122","v":312}]
[null,"Deputy OIC",null,null,null,null,null,1,1,1,1,6,52,{"$f":"K123*L123*M123","v":312}]
[null,"Supervisors",null,null,null,null,null,4,4,1,4,6,52,1248]
[null,"Counter Sniper",null,null,null,null,null,2,2,1,2,6,32,384]
[null,"Grenadiers",null,null,null,null,null,8,8,1,8,6,32,1536]
[null,"Officers",null,null,null,null,null,38,38,1,38,6,32,7296]
[null,"Prison Transport Officers",null,null,null,null,null,4,4,1,4,6,32,768]
[null,"Booking Personnel",null,null,null,null,null,1,1,1,1,6,32,192]
[null,null,null,null,null,null,null,null,null,null,null,"Total Initial Cost:  ",null,{"$f":"SUM(N122:N129)","v":12048}]
[]
[]
[]
[null,"Training",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N138:N147)+SUM(N149:N157)","v":228096}]
[]
[null,"Item Description",null,null,null,null,null,null,"Default Quantity (personnel to receive training)","Quantity","Course hours","Course cost","Hourly Wage/ Backfill","Total Cost"]
[null,"Supervisors"]
[null,"IS-100",null,null,null,null,null,null,{"$f":"SUM(CCNumSupervisors)","v":6},12,3,0,52,{"$f":"J138*K138*M138+L138","v":1872}]
[null,"IS-700",null,null,null,null,null,null,{"$f":"SUM(CCNumSupervisors)","v":6},12,3,0,52,{"$f":"J139*K139*M139+L139","v":1872}]
[null,"IS-800",null,null,null,null,null,null,6,12,3,0,52,1872]
[null,"IS-15.a Special Events Contingency Planning for Public Safety Agencies",null,null,null,null,null,null,6,12,5,0,52,3120]
[null,"ICS-300 (G-300)",null,null,null,null,null,null,6,12,18,0,52,11232]
[null,"Crowd Control Training",null,null,null,null,null,null,6,12,40,0,52,24960]
[null,"Additional training",null,null,null,null,null,null,6,12,0,0,52,0]
[null,"Additional training",null,null,null,null,null,null,6,12,0,0,52,0]
[null,"Additional training",null,null,null,null,null,null,6,12,0,0,52,0]
[null,"Additional training",null,null,null,null,null,null,6,12,0,0,52,0]
[null,"Line Officers"]
[null,"IS-100",null,null,null,null,null,null,{"$f":"SUM(CCNumOfficers)","v":53},106,3,0,32,{"$f":"J149*K149*M149+L149","v":10176}]
[null,"IS-700",null,null,null,null,null,null,53,106,3,0,32,{"$f":"J150*K150*M150+L150","v":10176}]
[null,"IS-800",null,null,null,null,null,null,53,106,3,0,32,10176]
[null,"IS-15.a Special Events Contingency Planning for Public Safety Agencies",null,null,null,null,null,null,53,106,5,0,32,16960]
[null,"Crowd Control Training",null,null,null,null,null,null,53,106,40,0,32,135680]
[null,"Additional training",null,null,null,null,null,null,53,106,0,0,32,0]
[null,"Additional training",null,null,null,null,null,null,53,106,0,0,32,0]
[null,"Additional training",null,null,null,null,null,null,53,106,0,0,32,0]
[null,"Additional training",null,null,null,null,null,null,53,106,0,0,32,0]
[null,null,null,null,null,null,null,null,null,null,null,"Total Initial Cost:  ",null,{"$f":"SUM(N138:N147)+SUM(N149:N157)","v":228096}]
[]
[]
[]
[null,"Custom Equipment",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CCCustomEquipInitCosts)","v":0}]
[]
[null,"Item Description",null,null,null,null,null,null,null,"Quantity per Team","Number of Teams","Total Quantity","Unit Cost","Total Cost"]
[null,"Custom equipment item",null,null,null,null,null,null,null,0,{"$f":"CCNumTeams","v":1},{"$f":"J165*K165","v":0},0,{"$f":"L165*M165","v":0}]
[null,"Custom equipment item",null,null,null,null,null,null,null,0,1,0,0,0]
[null,"Custom equipment item",null,null,null,null,null,null,null,0,1,0,0,0]
[null,"Custom equipment item",null,null,null,null,null,null,null,0,1,0,0,0]
[null,"Custom equipment item",null,null,null,null,null,null,null,0,1,0,0,0]
[null,"Custom equipment item",null,null,null,null,null,null,null,0,1,0,0,0]

{"sheet":"Crowd Control Team Costs","index":3,"n_rows":197,"n_cols":22,"rows_kept":197,"cut":false,"hidden":false,"merged":[[61,15,62,16],[7,1,8,7],[29,1,30,7],[52,1,53,7],[7,12,8,13],[29,12,30,13],[61,1,62,7],[29,10,29,11],[52,13,52,14],[56,1,56,4],[57,1,57,4],[58,1,58,4],[55,1,55,4],[13,8,13,10],[14,8,14,10],[15,8,15,10],[16,8,16,10],[13,11,13,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[35,8,35,10],[35,11,35,12],[144,11,144,12],[158,10,158,11],[143,1,144,6],[147,12,147,13],[148,12,148,13],[149,12,149,13],[150,12,150,13],[151,12,151,13],[152,12,152,13],[153,12,153,13],[154,12,154,13],[146,12,146,13],[155,12,155,13],[146,1,146,6],[147,1,147,6],[148,1,148,6],[149,1,149,6],[150,1,150,6],[151,1,151,6],[152,1,152,6],[153,1,153,6],[154,1,154,6],[65,1,65,4],[66,1,66,4],[67,1,67,5],[68,1,68,5],[69,1,69,5],[70,1,70,5],[71,1,71,5],[72,1,72,5],[186,15,187,16],[163,1,163,7],[164,1,164,7],[165,1,165,7],[166,1,166,7],[167,1,167,7],[168,1,168,7],[171,1,171,7],[172,1,172,7],[174,1,174,7],[175,1,175,7],[143,13,144,14],[158,1,159,1],[158,12,159,13],[73,1,73,5],[74,1,74,5],[75,1,75,5],[76,1,76,5],[77,1,77,5],[78,1,78,5],[79,1,79,5],[80,1,80,5],[81,1,81,5],[82,1,82,5],[83,1,83,5],[84,1,84,5],[85,1,85,5],[86,1,86,5],[87,1,87,5],[88,1,88,5],[89,1,89,5],[90,1,90,5],[91,1,91,5],[92,1,92,5],[93,1,93,5],[94,1,94,5],[95,1,95,5],[96,1,96,5],[97,1,97,5],[98,1,98,5],[99,1,99,5],[100,1,100,5],[101,1,101,5],[107,1,107,5],[108,1,108,5],[126,1,126,5],[109,1,109,5],[110,1,110,5],[111,1,111,5],[112,1,112,5],[113,1,113,5],[114,1,114,5],[115,1,115,5],[116,1,116,5],[117,1,117,5],[64,1,64,4],[140,11,140,14],[127,1,127,5],[128,1,128,5],[129,1,129,5],[130,1,130,5],[131,1,131,5],[132,1,132,5],[133,1,133,5],[134,1,134,5],[135,1,135,5],[118,1,118,5],[119,1,119,5],[120,1,120,5],[121,1,121,5],[122,1,122,5],[123,1,123,5],[124,1,124,5],[125,1,125,5],[102,1,102,5],[103,1,103,5],[104,1,104,5],[105,1,105,5],[106,1,106,5],[190,1,190,5],[191,1,191,5],[192,1,192,5],[193,1,193,5],[194,1,194,5],[196,1,196,5],[136,1,136,5],[137,1,137,5],[138,1,138,5],[139,1,139,5],[176,1,176,7],[177,1,177,7],[178,1,178,7],[179,1,179,7],[180,1,180,7],[181,1,181,7],[182,1,182,7],[186,1,187,5],[195,1,195,5],[162,1,162,13],[173,1,173,13],[161,1,161,7],[183,10,183,12],[155,9,155,11],[36,8,36,10],[36,11,36,12],[37,8,37,10],[37,11,37,12],[38,8,38,10],[38,11,38,12],[39,11,39,12],[44,9,45,11],[44,12,45,12]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"total"]
[]
[]
[]
[null,"Total Initial Costs for Crowd Control Team",null,null,null,null,null,null,null,null,null,null,{"$f":"L18","v":1818097}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Equipment Initial Costs:",null,null,{"$f":"SUM(CCArrestKitInitCost,CCCommsLogsInitCost,CCCrowdEquipmentInitCost,CCOfficerEquipInitCost,CCVehicleInitCost)","v":1590001},null,null,null,null,null,"Equipment Initial Costs:","Training Initial Costs:","User Input Equipment Initial Costs:"]
[null,null,null,null,null,null,null,null,"Personnel Initial Costs:",null,null,0,null,null,null,null,null,{"$f":"SUM(CCArrestKitInitCost,CCCommsLogsInitCost,CCCrowdEquipmentInitCost,CCOfficerEquipInitCost,CCVehicleInitCost)","v":1590001},{"$f":"CCTrainingInitCost","v":228096},{"$f":"SUM(CCCustomEquipInitCosts)","v":0}]
[null,null,null,null,null,null,null,null,"Training Initial Costs:",null,null,{"$f":"CCTrainingInitCost","v":228096}]
[null,null,null,null,null,null,null,null,"User Input Equipment Initial Costs:",null,null,{"$f":"SUM(CCCustomEquipInitCosts)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L14:M17)","v":1818097}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Annual Costs for Crowd Control Team",null,null,null,null,null,null,null,null,null,null,{"$f":"L40","v":838331.34999999986}]
[]
[null,null,null,null,null,null,null,null,null,"total"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Equipment Annual Costs:",null,null,{"$f":"CCEquipAllAnnCost","v":751947.34999999986}]
[null,null,null,null,null,null,null,null,"Personnel Annual Costs:",null,null,{"$f":"CCPersonnelAnnCost","v":12048},null,null,null,null,null,null,"Equipment Annual Costs:","Personnel Annual Costs:","Training Annual Costs:","User Input Equipment Annual Costs:"]
[null,null,null,null,null,null,null,null,"Training Annual Costs:",null,null,{"$f":"CCTrainingAnnCost","v":74336},null,null,null,null,null,null,{"$f":"CCEquipAllAnnCost","v":751947.34999999986},{"$f":"CCPersonnelAnnCost","v":12048},{"$f":"CCTrainingAnnCost","v":74336},{"$f":"SUM(CCCustomEquipAnnCost)","v":0}]
[null,null,null,null,null,null,null,null,"User Input Equipment Annual Costs:",null,null,{"$f":"SUM(CCCustomEquipAnnCost)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L36:M39)","v":838331.34999999986}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Number of expected deployments annually:",null,null,{"$f":"EventFrequency","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,"This can be changed on the User Input page."]
[]
[]
[]
[]
[]
[null,"Annual Cost Breakdown"]
[]
[]
[null,"Cost Factors",null,null,null,"(2)\nEnergy","(3) \nOperating","(4)\nRepair","(5)\nUpgrade"]
[null,"Large Vehicle",null,null,null,0.36,1200,0.15,0]
[null,"Small Vehicle",null,null,null,0.2,1200,0.15,0]
[null,"Equipment (as a percentage of the initial cost)",null,null,null,0.1,0.05,0.1,0.25]
[]
[]
[null,"Equipment Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CCEquipAllAnnCost","v":751947.34999999986}]
[]
[]
[null,"Item Description",null,null,null,"Annual Mileage","Quantity","Unit Cost","(1)\nInitial","Shelf\nLife","R-Cost","(2)\nEnergy","(3) \nOperating","(4)\nRepair","(5) Upgrade","Annual Costs","Category Total"]
[null,"Patrol Vehicles",null,null,null,12000,{"$f":"'Crowd Control Team Needs'!L27","v":14},{"$f":"'Crowd Control Team Needs'!M27","v":10000},{"$f":"G66*H66","v":140000},10,{"$f":"I66/J66","v":14000},{"$f":"F58*F66*G66","v":33600},{"$f":"G58*G66","v":16800},{"$f":"H58*F66*G66","v":25200},{"$f":"I58*G66","v":0},{"$f":"SUM(K66:O66)","v":89600}]
[null,"Prisoner Transport Vans",null,null,null,12000,{"$f":"'Crowd Control Team Needs'!L28","v":2},{"$f":"'Crowd Control Team Needs'!M28","v":20000},{"$f":"G67*H67","v":40000},10,{"$f":"I67/J67","v":4000},{"$f":"F57*F67*G67","v":8640},{"$f":"G57*G67","v":2400},{"$f":"H57*F67*G67","v":3600},{"$f":"I57*G67","v":0},{"$f":"SUM(K67:O67)","v":18640},{"$f":"SUM(P66:P67)","v":108240}]
[null,{"$f":"'Crowd Control Team Needs'!B12","v":"\"Grenade\" Launcher"},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L12","v":30},{"$f":"'Crowd Control Team Needs'!M12","v":2500},{"$f":"G68*H68","v":75000},5,{"$f":"I68/J68","v":15000},0,{"$f":"0.05*I68","v":3750},{"$f":"0.1*I68","v":7500},0,{"$f":"SUM(K68:O68)","v":26250}]
[null,{"$f":"'Crowd Control Team Needs'!B13","v":"Smoke grenades"},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L13","v":150},{"$f":"'Crowd Control Team Needs'!M13","v":25},3750,1,{"$f":"I69/J69","v":3750},0,0,{"$f":"0.1*I69","v":375},0,{"$f":"SUM(K69:O69)","v":4125}]
[null,{"$f":"'Crowd Control Team Needs'!B14","v":"\"Grenades\""},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L14","v":150},{"$f":"'Crowd Control Team Needs'!M14","v":35},5250,1,5250,0,0,525,0,{"$f":"SUM(K70:O70)","v":5775}]
[null,{"$f":"'Crowd Control Team Needs'!B15","v":"Fogger"},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L15","v":30},{"$f":"'Crowd Control Team Needs'!M15","v":26},780,1,780,0,0,78,0,858]
[null,{"$f":"'Crowd Control Team Needs'!B16","v":"Oleoresin Capsicum Fog Cartridge"},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L16","v":90},{"$f":"'Crowd Control Team Needs'!M16","v":45},4050,1,4050,0,0,405,0,4455]
[null,{"$f":"'Crowd Control Team Needs'!B17","v":"Riot control batons"},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L17","v":59},{"$f":"'Crowd Control Team Needs'!M17","v":35},2065,10,206.5,0,0,206.5,0,413]
[null,{"$f":"'Crowd Control Team Needs'!B18","v":"Bullhorns"},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L18","v":59},{"$f":"'Crowd Control Team Needs'!M18","v":80},4720,10,472,{"$f":"0.1*I74","v":472},{"$f":"0.05*I74","v":236},472,0,1652]
[null,{"$f":"'Crowd Control Team Needs'!B19","v":"Pepper spray"},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L19","v":59},{"$f":"'Crowd Control Team Needs'!M19","v":5},295,1,295,0,{"$f":"0.05*I75","v":14.75},29.5,0,339.25,{"$f":"SUM(P68:P75)","v":43867.25}]
[null,"Weather-resistant Field Booking Forms",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L36","v":30},{"$f":"'Crowd Control Team Needs'!M36","v":40},1200,1,1200,0,{"$f":"0.05*I76","v":60},{"$f":"0.1*I76","v":120},0,1380]
[null,"Digital camera",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L37","v":30},{"$f":"'Crowd Control Team Needs'!M37","v":400},12000,5,2400,{"$f":"0.1*I77","v":1200},{"$f":"0.05*I77","v":600},{"$f":"0.1*I77","v":1200},{"$f":"0.25*I77","v":3000},8400]
[null,"Fingerprinting equipment",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L38","v":30},{"$f":"'Crowd Control Team Needs'!M38","v":30},900,1,900,{"$f":"0.1*I78","v":90},{"$f":"0.05*I78","v":45},{"$f":"0.1*I78","v":90},{"$f":"0.25*I78","v":225},1350,{"$f":"SUM(P76:P78)","v":11130}]
[null,"Soft Body Armor",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L46","v":59},{"$f":"'Crowd Control Team Needs'!M46","v":1000},59000,5,11800,0,0,{"$f":"0.1*I79","v":5900},0,17700]
[null,"Portable Radios",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L47","v":59},{"$f":"'Crowd Control Team Needs'!M47","v":570},33630,5,6726,{"$f":"0.1*I80","v":3363},{"$f":"0.05*I80","v":1681.5},3363,0,15133.5]
[null,"Battery charger",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L48","v":6},{"$f":"'Crowd Control Team Needs'!M48","v":325},1950,5,390,{"$f":"0.1*I81","v":195},{"$f":"0.05*I81","v":97.5},195,0,877.5]
[null,"Respiratory mask (NIOSH-approved)",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L49","v":59},{"$f":"'Crowd Control Team Needs'!M49","v":300},17700,5,3540,0,{"$f":"0.05*I82","v":885},1770,0,6195]
[null,"Safety glasses",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L50","v":59},{"$f":"'Crowd Control Team Needs'!M50","v":3},177,5,35.4,0,0,17.7,0,53.099999999999994]
[null,"Ear protection",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L51","v":59},{"$f":"'Crowd Control Team Needs'!M51","v":1},59,5,11.8,0,0,5.9,0,17.700000000000003]
[null,"Fire extinguisher",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L52","v":30},{"$f":"'Crowd Control Team Needs'!M52","v":40},1200,5,240,0,{"$f":"0.05*I85","v":60},120,0,420]
[null,"Foul weather gear",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L53","v":59},{"$f":"'Crowd Control Team Needs'!M53","v":15},885,5,177,0,0,88.5,0,265.5]
[null,"Hand held shields",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L54","v":59},{"$f":"'Crowd Control Team Needs'!M54","v":100},5900,5,1180,0,0,590,0,1770]
[null,"Personal hydration system",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L55","v":59},{"$f":"'Crowd Control Team Needs'!M55","v":50},2950,5,590,{"$f":"0.1*I88","v":295},{"$f":"0.05*I88","v":147.5},295,0,1327.5]
[null,"Level C PPE suits",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L56","v":59},{"$f":"'Crowd Control Team Needs'!M56","v":200},11800,5,2360,0,{"$f":"0.05*I89","v":590},1180,0,4130]
[null,"Shoulder fired weapons",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L57","v":0},{"$f":"'Crowd Control Team Needs'!M57","v":0},0,1,0,0,0,0,0,0]
[null,"Safety Helmet",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L58","v":59},{"$f":"'Crowd Control Team Needs'!M58","v":30},1770,5,354,0,0,177,0,531]
[null,"Vest or Outer Garment, High-visibility  ",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L59","v":59},{"$f":"'Crowd Control Team Needs'!M59","v":9},531,5,106.2,0,0,{"$f":"0.1*I92","v":53.1},0,159.30000000000001]
[null,"Handcuffs",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L60","v":59},{"$f":"'Crowd Control Team Needs'!M60","v":21},1239,5,247.8,0,0,123.9,0,371.70000000000005]
[null,"Handcuff case",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L61","v":59},{"$f":"'Crowd Control Team Needs'!M61","v":16.5},973.5,5,194.7,0,0,97.350000000000009,0,292.05]
[null,"Duty belt",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L62","v":59},{"$f":"'Crowd Control Team Needs'!M62","v":26},1534,5,306.8,0,0,153.4,0,460.20000000000005]
[null,"Flashlight: MAG-LITE D-cell",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L63","v":59},{"$f":"'Crowd Control Team Needs'!M63","v":16},944,5,188.8,{"$f":"0.1*I96","v":94.4},{"$f":"0.05*I96","v":47.2},94.4,0,424.80000000000007]
[null,"D-Cell Batteries (8)",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L64","v":59},{"$f":"'Crowd Control Team Needs'!M64","v":8},472,1,472,{"$f":"0.1*I97","v":47.2},{"$f":"0.05*I97","v":23.6},47.2,0,590.00000000000011]
[null,"Flashlight holder (D-cell)",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L65","v":59},{"$f":"'Crowd Control Team Needs'!M65","v":5.75},339.25,5,67.849999999999994,0,0,33.925000000000004,0,101.77500000000001]
[null,"Flex cuffs (10)",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L66","v":59},{"$f":"'Crowd Control Team Needs'!M66","v":11},649,1,649,0,0,64.900000000000006,0,713.9]
[null,"Cutting tool for flex cuffs",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L67","v":59},{"$f":"'Crowd Control Team Needs'!M67","v":12.75},752.25,5,150.44999999999999,0,0,75.225000000000009,0,225.67500000000001]
[null,"Knife",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L68","v":59},{"$f":"'Crowd Control Team Needs'!M68","v":107},6313,5,1262.5999999999999,0,0,631.30000000000007,0,1893.9]
[null,"Waterproof Duty Boots",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L69","v":59},{"$f":"'Crowd Control Team Needs'!M69","v":124},7316,5,1463.2,0,0,731.6,0,2194.8000000000002]
[null,"Regular Duty Boots",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L70","v":59},{"$f":"'Crowd Control Team Needs'!M70","v":65},3835,5,767,0,0,383.5,0,1150.5]
[null,"Regular Duty Gloves",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L71","v":59},{"$f":"'Crowd Control Team Needs'!M71","v":9},531,5,106.2,0,0,53.1,0,159.30000000000001]
[null,"Kevlar-lined police leather gloves",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L72","v":59},{"$f":"'Crowd Control Team Needs'!M72","v":25},1475,5,295,0,0,147.5,0,442.5]
[null,"Large rubber bands",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L73","v":59},{"$f":"'Crowd Control Team Needs'!M73","v":4},236,1,236,0,0,23.6,0,259.60000000000002]
[null,"Handguns",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L74","v":59},{"$f":"'Crowd Control Team Needs'!M74","v":1144},67496,10,6749.6,0,{"$f":"0.05*I107","v":3374.8},6749.6,0,16874,{"$f":"SUM(P79:P107)","v":74734.800000000017}]
[null,"75’ Portable Communications Towers ",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L82","v":4},{"$f":"'Crowd Control Team Needs'!M82","v":90000},{"$f":"G108*H108","v":360000},10,36000,{"$f":"0.1*I108","v":36000},{"$f":"0.05*I108","v":18000},{"$f":"0.1*I108","v":36000},0,{"$f":"SUM(K108:O108)","v":126000}]
[null,"Satellite Communications trailer with data, VoIP & video capability",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L83","v":2},{"$f":"'Crowd Control Team Needs'!M83","v":199000},398000,10,39800,{"$f":"0.1*I109","v":39800},{"$f":"0.05*I109","v":19900},{"$f":"0.1*I109","v":39800},{"$f":"0.25*I109","v":99500},238800]
[null,"800 MHz 10 Watt Portable Repeaters",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L84","v":1},{"$f":"'Crowd Control Team Needs'!M84","v":8500},8500,5,1700,850,425,850,0,3825]
[null,"800 MHz 25 Watt Portable Repeaters ",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L85","v":1},{"$f":"'Crowd Control Team Needs'!M85","v":8500},8500,5,1700,850,425,850,0,3825]
[null,"800 MHz Conventional Repeaters",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L86","v":1},{"$f":"'Crowd Control Team Needs'!M86","v":3934},3934,5,786.8,393.40000000000003,196.70000000000002,393.40000000000003,0,1770.3000000000002]
[null,"UHF Conventional Repeater",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L87","v":1},{"$f":"'Crowd Control Team Needs'!M87","v":4833},4833,5,966.6,483.3,241.65,483.3,0,2174.8500000000004]
[null,"UHF 10 Watt Portable Repeater",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L88","v":1},{"$f":"'Crowd Control Team Needs'!M88","v":1063},1063,5,212.6,106.30000000000001,53.150000000000006,106.30000000000001,0,478.34999999999997]
[null,"VHF Conventional Repeater",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L89","v":1},{"$f":"'Crowd Control Team Needs'!M89","v":2500},2500,5,500,250,125,250,0,1125]
[null,"VHF 10 Watt Portable Repeater",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L90","v":1},{"$f":"'Crowd Control Team Needs'!M90","v":1063},1063,5,212.6,106.30000000000001,53.150000000000006,106.30000000000001,0,478.34999999999997]
[null,"VHF, UHF & 800 MHz Desk Top Control Station ",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L91","v":1},{"$f":"'Crowd Control Team Needs'!M91","v":10156},10156,5,2031.2,1015.6,507.8,1015.6,{"$f":"0.25*I117","v":2539},7109.2000000000007]
[null,"800 MHz Handheld Radios  (Motorola XTS 2500)",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L92","v":1},{"$f":"'Crowd Control Team Needs'!M92","v":2500},2500,5,500,250,125,250,0,1125]
[null,"VHF Handheld Radios ",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L93","v":1},{"$f":"'Crowd Control Team Needs'!M93","v":800},800,5,160,80,40,80,0,360]
[null,"UHF Handheld Radios ",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L94","v":1},{"$f":"'Crowd Control Team Needs'!M94","v":806},806,5,161.19999999999999,80.600000000000009,40.300000000000004,80.600000000000009,0,362.70000000000005]
[null,"6 bay rack chargers ",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L95","v":1},{"$f":"'Crowd Control Team Needs'!M95","v":639},639,5,127.8,63.900000000000006,31.950000000000003,63.900000000000006,0,287.54999999999995]
[null,"Law enforcement surveillance equipment",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L96","v":1},{"$f":"'Crowd Control Team Needs'!M96","v":5432},5432,10,543.20000000000005,543.20000000000005,271.60000000000002,543.20000000000005,{"$f":"0.25*I122","v":1358},3259.2]
[null,"Mapping/GIS Software",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L97","v":1},{"$f":"'Crowd Control Team Needs'!M97","v":40000},40000,10,4000,0,0,4000,{"$f":"0.25*I123","v":10000},18000]
[null,"Data Acquisition Software",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L98","v":1},{"$f":"'Crowd Control Team Needs'!M98","v":7040},7040,10,704,0,0,704,{"$f":"0.25*I124","v":1760},3168]
[null,"Data Exchange and Interoperability Software of System(s)",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L99","v":1},{"$f":"'Crowd Control Team Needs'!M99","v":40000},40000,10,4000,0,0,4000,{"$f":"0.25*I125","v":10000},18000]
[null,"Intelligence Sharing System",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L100","v":1},{"$f":"'Crowd Control Team Needs'!M100","v":60000},60000,10,6000,{"$f":"0.1*I126","v":6000},0,6000,{"$f":"15000*G126","v":15000},33000]
[null,"Generator (14,000 Watts)",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L101","v":2},{"$f":"'Crowd Control Team Needs'!M101","v":3689},7378,10,737.8,{"$f":"0.1*I127","v":737.80000000000007},{"$f":"0.05*I127","v":368.90000000000003},737.80000000000007,0,2582.3000000000002]
[null,"Generator (7,000 Watts)",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L102","v":0},{"$f":"'Crowd Control Team Needs'!M102","v":2300},0,10,0,{"$f":"0.1*I128","v":0},{"$f":"0.05*I128","v":0},{"$f":"0.1*I128","v":0},0,0]
[null,"Video capture software",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L103","v":1},{"$f":"'Crowd Control Team Needs'!M103","v":50},50,10,5,0,0,{"$f":"0.1*I129","v":5},{"$f":"0.25*I129","v":12.5},22.5]
[null,"Document Scanner",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L104","v":2},{"$f":"'Crowd Control Team Needs'!M104","v":450},900,5,180,{"$f":"0.1*I130","v":90},{"$f":"0.05*I130","v":45},{"$f":"0.1*I130","v":90},{"$f":"0.25*I130","v":225},630]
[null,"Fax Machine: Canon L90 Laser",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L105","v":2},{"$f":"'Crowd Control Team Needs'!M105","v":100},200,5,40,{"$f":"0.1*I131","v":20},{"$f":"0.05*I131","v":10},20,{"$f":"0.25*I131","v":50},140]
[null,"Printer: HP LaserJet P4014N",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L106","v":2},{"$f":"'Crowd Control Team Needs'!M106","v":900},1800,5,360,{"$f":"0.1*I132","v":180},{"$f":"0.05*I132","v":90},180,{"$f":"0.25*I132","v":450},1260]
[null,"Copy Machine: Canon MF6540",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L107","v":2},{"$f":"'Crowd Control Team Needs'!M107","v":500},1000,5,200,{"$f":"0.1*I133","v":100},{"$f":"0.05*I133","v":50},100,{"$f":"0.25*I133","v":250},700]
[null,"Power strip (six outlet, surge protection)",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L108","v":10},{"$f":"'Crowd Control Team Needs'!M108","v":12},120,5,24,0,0,12,0,36]
[null,"40' Extension Cord",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L109","v":10},{"$f":"'Crowd Control Team Needs'!M109","v":32},320,5,64,0,0,32,0,96]
[null,"Single-unit Rapid Charger",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L110","v":1},{"$f":"'Crowd Control Team Needs'!M110","v":60},60,5,12,{"$f":"0.1*I136","v":6},{"$f":"0.05*I136","v":3},6,0,27]
[null,"6 Unit Multi-Charger",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L111","v":1},{"$f":"'Crowd Control Team Needs'!M111","v":190},190,5,38,{"$f":"0.1*I137","v":19},{"$f":"0.05*I137","v":9.5},19,0,85.5]
[null,"Microsoft Office/Adobe Acrobat",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L112","v":1},{"$f":"'Crowd Control Team Needs'!M112","v":200},200,10,20,0,0,20,{"$f":"0.25*I138","v":50},90]
[null,"ACU-1000 ",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L113","v":1},{"$f":"'Crowd Control Team Needs'!M113","v":100000},100000,5,20000,{"$f":"0.1*I139","v":10000},{"$f":"0.05*I139","v":5000},10000,0,45000]
[null,"DC Power Electrical Rectifier system",null,null,null,null,{"$f":"'Crowd Control Team Needs'!L114","v":1},{"$f":"'Crowd Control Team Needs'!M114","v":350},350,5,70,{"$f":"0.1*I140","v":35},{"$f":"0.05*I140","v":17.5},35,0,157.5,{"$f":"SUM(P108:P140)","v":513975.29999999993}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Equipment Annual Cost:  ",null,null,null,{"$f":"SUM(P66:P140)","v":751947.34999999986}]
[]
[]
[null,"Personnel Costs",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CCPersonnelAnnCost","v":12048}]
[]
[]
[null,"Item Description",null,null,null,null,null,"Total Personnel","Hours Deployed","Hourly Wage/\nBackfill","Initial Cost","Deployment Frequency","Annual Cost"]
[null,"Officer in Charge",null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!K122","v":1},{"$f":"'Crowd Control Team Needs'!L122","v":6},{"$f":"'Crowd Control Team Needs'!M122","v":52},{"$f":"H148*I148*J148","v":312},{"$f":"EventFrequency","v":1},{"$f":"L148*K148","v":312}]
[null,"Deputy OIC",null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!K123","v":1},{"$f":"'Crowd Control Team Needs'!L123","v":6},{"$f":"'Crowd Control Team Needs'!M123","v":52},{"$f":"H149*I149*J149","v":312},1,{"$f":"L149*K149","v":312}]
[null,"Supervisors",null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!K124","v":4},{"$f":"'Crowd Control Team Needs'!L124","v":6},{"$f":"'Crowd Control Team Needs'!M124","v":52},1248,1,1248]
[null,"Counter Sniper",null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!K125","v":2},{"$f":"'Crowd Control Team Needs'!L125","v":6},{"$f":"'Crowd Control Team Needs'!M125","v":32},384,1,384]
[null,"Grenadiers",null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!K126","v":8},{"$f":"'Crowd Control Team Needs'!L126","v":6},{"$f":"'Crowd Control Team Needs'!M126","v":32},1536,1,1536]
[null,"Officers",null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!K127","v":38},{"$f":"'Crowd Control Team Needs'!L127","v":6},{"$f":"'Crowd Control Team Needs'!M127","v":32},7296,1,7296]
[null,"Prison Transport Officers",null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!K128","v":4},{"$f":"'Crowd Control Team Needs'!L128","v":6},{"$f":"'Crowd Control Team Needs'!M128","v":32},768,1,768]
[null,"Booking Personnel",null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!K129","v":1},{"$f":"'Crowd Control Team Needs'!L129","v":6},{"$f":"'Crowd Control Team Needs'!M129","v":32},192,1,192]
[null,null,null,null,null,null,null,null,null,"Total Personnel Annual Cost:  ",null,null,{"$f":"SUM(M148:N155)","v":12048}]
[]
[]
[null,"Training Costs",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O173,O183)","v":74336}]
[]
[]
[null,"Item Description",null,null,null,null,null,null,"Quantity","Cost of Course + Backfill","Initial Costs","Retraining Frequency (years)","Average Career (years)","Annual Costs"]
[null,"Supervisors"]
[null,"IS-100",null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J138","v":12},{"$f":"'Crowd Control Team Needs'!K138*'Crowd Control Team Needs'!M138+'Crowd Control Team Needs'!L138","v":156},{"$f":"I164*J164","v":1872},3,9,{"$f":"K164/(IF(L164<M164,L164,M164))","v":624}]
[null,"IS-700",null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J139","v":12},{"$f":"'Crowd Control Team Needs'!K139*'Crowd Control Team Needs'!M139+'Crowd Control Team Needs'!L139","v":156},1872,3,9,{"$f":"K165/(IF(L165<M165,L165,M165))","v":624}]
[null,"IS-800",null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J140","v":12},{"$f":"'Crowd Control Team Needs'!K140*'Crowd Control Team Needs'!M140+'Crowd Control Team Needs'!L140","v":156},1872,3,9,624]
[null,"IS-15.a Special Events Contingency Planning for Public Safety Agencies",null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J141","v":12},{"$f":"'Crowd Control Team Needs'!K141*'Crowd Control Team Needs'!M141+'Crowd Control Team Needs'!L141","v":260},3120,3,9,1040]
[null,"ICS-300 (G-300)",null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J142","v":12},{"$f":"'Crowd Control Team Needs'!K142*'Crowd Control Team Needs'!M142+'Crowd Control Team Needs'!L142","v":936},11232,3,9,3744]
[null,"Crowd Control Training",null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J143","v":12},{"$f":"'Crowd Control Team Needs'!K143*'Crowd Control Team Needs'!M143+'Crowd Control Team Needs'!L143","v":2080},24960,3,9,8320]
[null,{"$f":"'Crowd Control Team Needs'!B144:H144","v":"Additional training"},null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J144","v":12},{"$f":"'Crowd Control Team Needs'!K144*'Crowd Control Team Needs'!M144+'Crowd Control Team Needs'!L144","v":0},0,3,9,0]
[null,{"$f":"'Crowd Control Team Needs'!B145:H145","v":"Additional training"},null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J145","v":12},{"$f":"'Crowd Control Team Needs'!K145*'Crowd Control Team Needs'!M145+'Crowd Control Team Needs'!L145","v":0},{"$f":"I171*J171","v":0},3,9,{"$f":"K171/(IF(L171<M171,L171,M171))","v":0}]
[null,{"$f":"'Crowd Control Team Needs'!B146:H146","v":"Additional training"},null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J146","v":12},{"$f":"'Crowd Control Team Needs'!K146*'Crowd Control Team Needs'!M146+'Crowd Control Team Needs'!L146","v":0},0,3,9,0]
[null,{"$f":"'Crowd Control Team Needs'!B147:H147","v":"Additional training"},null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J147","v":12},{"$f":"'Crowd Control Team Needs'!K147*'Crowd Control Team Needs'!M147+'Crowd Control Team Needs'!L147","v":0},0,3,9,0,{"$f":"SUM(N164:N173)","v":14976}]
[null,"Line Officers"]
[null,"IS-100",null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!I149","v":53},{"$f":"'Crowd Control Team Needs'!K149*'Crowd Control Team Needs'!M149+'Crowd Control Team Needs'!L149","v":96},{"$f":"I175*J175","v":5088},3,9,{"$f":"K175/(IF(L175<M175,L175,M175))","v":1696}]
[null,"IS-700",null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J150","v":106},{"$f":"'Crowd Control Team Needs'!K150*'Crowd Control Team Needs'!M150+'Crowd Control Team Needs'!L150","v":96},{"$f":"I176*J176","v":10176},3,9,{"$f":"K176/(IF(L176<M176,L176,M176))","v":3392}]
[null,"IS-800",null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J151","v":106},{"$f":"'Crowd Control Team Needs'!K151*'Crowd Control Team Needs'!M151+'Crowd Control Team Needs'!L151","v":96},10176,3,9,3392]
[null,"IS-15.a Special Events Contingency Planning for Public Safety Agencies",null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J152","v":106},{"$f":"'Crowd Control Team Needs'!K152*'Crowd Control Team Needs'!M152+'Crowd Control Team Needs'!L152","v":160},16960,3,9,5653.333333333333]
[null,"Crowd Control Training",null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J153","v":106},{"$f":"'Crowd Control Team Needs'!K153*'Crowd Control Team Needs'!M153+'Crowd Control Team Needs'!L153","v":1280},135680,3,9,45226.666666666664]
[null,{"$f":"'Crowd Control Team Needs'!B154:H154","v":"Additional training"},null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J154","v":106},{"$f":"'Crowd Control Team Needs'!K154*'Crowd Control Team Needs'!M154+'Crowd Control Team Needs'!L154","v":0},0,3,9,0]
[null,{"$f":"'Crowd Control Team Needs'!B155:H155","v":"Additional training"},null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J155","v":106},{"$f":"'Crowd Control Team Needs'!K155*'Crowd Control Team Needs'!M155+'Crowd Control Team Needs'!L155","v":0},0,3,9,0]
[null,{"$f":"'Crowd Control Team Needs'!B156:H156","v":"Additional training"},null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!J156","v":106},{"$f":"'Crowd Control Team Needs'!K156*'Crowd Control Team Needs'!M156+'Crowd Control Team Needs'!L156","v":0},0,3,9,0]
[null,{"$f":"'Crowd Control Team Needs'!B157:H157","v":"Additional training"},null,null,null,null,null,null,{"$f":"'Crowd Control Team Needs'!I157","v":53},{"$f":"'Crowd Control Team Needs'!K157*'Crowd Control Team Needs'!M157+'Crowd Control Team Needs'!L157","v":0},0,3,9,0,{"$f":"SUM(N175:N183)","v":59360}]
[null,null,null,null,null,null,null,null,null,null,"Total Training Annual Cost:  ",null,null,{"$f":"SUM(N164:N173,N175:N183)","v":74336}]
[]
[]
[null,"User Input Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CCCustomEquipAnnCosts)","v":0}]
[]
[]
[]
[null,"Item Description",null,null,null,null,"Quantity","Unit Cost","(1)\nInitial","Shelf\nLife","R-Cost","(2)\nEnergy","(3) \nOperating","(4)\nRepair","(5) Upgrade","Annual Costs"]
[null,{"$f":"'Crowd Control Team Needs'!B165:I165","v":"Custom equipment item"},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L165","v":0},{"$f":"'Crowd Control Team Needs'!M165","v":0},{"$f":"H192*G192","v":0},5,{"$f":"I192/J192","v":0},0,0,0,0,{"$f":"SUM(K192:O192)","v":0}]
[null,{"$f":"'Crowd Control Team Needs'!B166:I166","v":"Custom equipment item"},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L166","v":0},{"$f":"'Crowd Control Team Needs'!M166","v":0},{"$f":"H193*G193","v":0},5,{"$f":"I193/J193","v":0},0,0,0,0,{"$f":"SUM(K193:O193)","v":0}]
[null,{"$f":"'Crowd Control Team Needs'!B167:I167","v":"Custom equipment item"},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L167","v":0},{"$f":"'Crowd Control Team Needs'!M167","v":0},0,5,0,0,0,0,0,0]
[null,{"$f":"'Crowd Control Team Needs'!B168:I168","v":"Custom equipment item"},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L168","v":0},{"$f":"'Crowd Control Team Needs'!M168","v":0},0,5,0,0,0,0,0,0]
[null,{"$f":"'Crowd Control Team Needs'!B169:I169","v":"Custom equipment item"},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L169","v":0},{"$f":"'Crowd Control Team Needs'!M169","v":0},0,5,0,0,0,0,0,0]
[null,{"$f":"'Crowd Control Team Needs'!B170:I170","v":"Custom equipment item"},null,null,null,null,{"$f":"'Crowd Control Team Needs'!L170","v":0},{"$f":"'Crowd Control Team Needs'!M170","v":0},0,5,0,0,0,0,0,0]

{"sheet":"Perimeter and Checkpoint Needs","index":4,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,1,66,7],[35,1,35,13],[36,1,36,7],[37,1,37,7],[38,1,38,7],[39,1,39,7],[57,13,58,13],[40,1,40,7],[41,1,41,7],[42,1,42,7],[43,1,43,7],[44,1,44,13],[61,1,61,7],[45,1,45,7],[46,1,46,7],[62,1,62,7],[31,13,32,13],[21,1,22,7],[21,13,22,13],[26,1,26,5],[65,1,65,7],[34,1,34,7],[63,1,63,7],[64,1,64,7],[47,1,47,7],[48,1,48,7],[49,1,49,7],[50,1,50,7],[51,1,51,7],[52,1,52,7],[57,1,58,7],[60,1,60,7],[8,13,9,13],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[17,10,17,11],[27,11,27,12],[53,11,53,12],[6,1,6,10],[11,1,11,8],[24,1,24,5],[25,1,25,5],[8,1,9,7],[16,1,16,8],[31,1,32,7]]}
[]
[]
[]
[]
[]
[]
[null,{"$f":"CONCATENATE(\"You indicated the need for \",PCCheckpoints,\" Checkpoint Team(s) and \", PCPerimeterLength, \" feet of perimeter coverage.\")","v":"You indicated the need for 4 Checkpoint Team(s) and 500 feet of perimeter coverage."}]
[]
[null,"Perimeter & Checkpoint Equipment",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M13:M17)","v":53007}]
[]
[]
[null,"Item Description",null,null,null,null,null,null,null,"Default Quantity","Quantity","Unit Cost","Total Initial Cost"]
[null,"Mobile Checkpoint Guard Booth",null,null,null,null,null,null,null,{"$f":"PCCheckpoints","v":4},1,18000,{"$f":"K13*L13","v":18000}]
[null,"Plastic Barriers",null,null,null,null,null,null,null,{"$f":"PCPerimeterLength/5","v":100},100,350,{"$f":"K14*L14","v":35000}]
[null,"Plastic Fold-up Barriers",null,null,null,null,null,null,null,{"$f":"VLOOKUP(B15,PerimeterEquipmentDefaults,2,FALSE)","v":0},0,300,{"$f":"K15*L15","v":0}]
[null,"Steel Crowd Control Barriers",null,null,null,null,null,null,null,{"$f":"VLOOKUP(B16,PerimeterEquipmentDefaults,2,FALSE)","v":0},0,100,{"$f":"K16*L16","v":0}]
[null,"Caution Tape",null,null,null,null,null,null,null,{"$f":"PCCheckpoints","v":4},1,7,{"$f":"K17*L17","v":7}]
[null,null,null,null,null,null,null,null,null,null,"Total Initial Cost:  ",null,{"$f":"SUM(M13:M17)","v":53007}]
[]
[]
[]
[null,"Personnel",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N26:N27)","v":10368}]
[]
[]
[null,"Item Description",null,null,null,null,"Default Quantity per Checkpoint","Quantity per Checkpoint","Number of Checkpoints","Number of Shifts","Total Personnel","Hours Deployed","Hourly Wage/Backfill","Operational Cost"]
[null,"Supervisors",null,null,null,null,4,4,{"$f":"PCCheckpoints","v":4},{"$f":"EventShifts","v":1},{"$f":"H26*I26","v":16},{"$f":"EventLength","v":6},52,{"$f":"M26*L26*K26","v":4992}]
[null,"Patrol Officers",null,null,null,null,7,7,{"$f":"PCCheckpoints","v":4},{"$f":"EventShifts","v":1},{"$f":"H27*I27","v":28},{"$f":"EventLength","v":6},32,{"$f":"M27*L27*K27","v":5376}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Initial Cost:  ",null,{"$f":"SUM(N26:N27)","v":10368}]
[]
[]
[]
[null,"Training",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N37:N44)+SUM(N46:N53)","v":4455}]
[]
[]
[null,"Item Description",null,null,null,null,null,null,"Default quantity (personnel to receive training)","Quantity","Course hours","Course cost","Hourly Wage/Backfill","Total Cost"]
[null,"Supervisors"]
[null,"IS-100",null,null,null,null,null,null,{"$f":"PCNumSupervisors","v":4},4,3,0,52,{"$f":"J37*K37*M37+L37","v":624}]
[null,"IS-230",null,null,null,null,null,null,4,4,1,0,52,{"$f":"J38*K38*M38+L38","v":208}]
[null,"IS-700",null,null,null,null,null,null,4,4,3,0,52,624]
[null,"IS-701",null,null,null,null,null,null,4,4,2,0,52,416]
[null,"Additional training",null,null,null,null,null,null,4,4,0,0,52,0]
[null,"Additional training",null,null,null,null,null,null,4,4,0,0,52,0]
[null,"Additional training",null,null,null,null,null,null,4,4,0,0,52,0]
[null,"Additional training",null,null,null,null,null,null,4,4,0,0,52,0]
[null,"Line Officers"]
[null,"IS-100",null,null,null,null,null,null,{"$f":"PCNumOfficers","v":7},7,3,0,41,{"$f":"J46*K46*M46+L46","v":861}]
[null,"IS-230",null,null,null,null,null,null,7,7,1,0,41,{"$f":"J47*K47*M47+L47","v":287}]
[null,"IS-700",null,null,null,null,null,null,7,7,3,0,41,861]
[null,"IS-701",null,null,null,null,null,null,7,7,2,0,41,574]
[null,"Additional training",null,null,null,null,null,null,7,7,0,0,41,0]
[null,"Additional training",null,null,null,null,null,null,7,7,0,0,41,0]
[null,"Additional training",null,null,null,null,null,null,7,7,0,0,41,0]
[null,"Additional training",null,null,null,null,null,null,7,7,0,0,41,0]
[null,null,null,null,null,null,null,null,null,null,null,"Total Initial Cost:  ",null,{"$f":"SUM(N37:N44)+SUM(N46:N53)","v":4455}]
[]
[]
[]
[null,"Custom Equipment",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(PCCustomEquipInitCosts)","v":0}]
[]
[]
[null,"Item Description",null,null,null,null,null,null,"Quantity per Checkpoint","Number of Checkpoints","Total Quantity","Unit Cost","Total Cost"]
[null,"Custom equipment item",null,null,null,null,null,null,0,{"$f":"PCCheckpoints","v":4},{"$f":"I62*J62","v":0},0,{"$f":"K62*L62","v":0}]
[null,"Custom equipment item",null,null,null,null,null,null,0,4,0,0,0]
[null,"Custom equipment item",null,null,null,null,null,null,0,4,0,0,0]
[null,"Custom equipment item",null,null,null,null,null,null,0,4,0,0,0]
[null,"Custom equipment item",null,null,null,null,null,null,0,4,0,0,0]
[null,"Custom equipment item",null,null,null,null,null,null,0,4,0,0,0]

{"sheet":"Perimeter and Checkpoint Costs","index":5,"n_rows":110,"n_cols":22,"rows_kept":110,"cut":false,"hidden":false,"merged":[[75,14,76,15],[75,1,76,5],[100,14,101,15],[88,1,88,12],[84,1,84,6],[85,1,85,6],[86,1,86,6],[87,1,87,6],[89,1,89,6],[90,1,90,6],[91,1,91,6],[92,1,92,6],[93,1,93,6],[50,1,50,4],[66,1,67,6],[66,14,67,15],[67,12,67,13],[54,1,55,7],[54,14,55,15],[57,1,57,3],[58,1,58,3],[59,1,59,3],[60,1,60,3],[61,1,61,3],[62,1,62,3],[44,1,45,7],[44,12,44,13],[47,1,47,4],[48,1,48,4],[49,1,49,4],[6,1,7,7],[6,12,7,13],[25,1,26,7],[25,10,25,11],[25,12,26,13],[69,1,69,6],[69,12,69,13],[70,1,70,6],[70,12,70,13],[71,1,71,6],[71,12,71,13],[78,1,78,6],[100,1,101,5],[79,1,79,12],[80,1,80,6],[81,1,81,6],[82,1,82,6],[83,1,83,6],[104,1,104,5],[105,1,105,5],[106,1,106,5],[107,1,107,5],[94,1,94,6],[95,1,95,6],[96,1,96,6],[108,1,108,5],[109,1,109,5],[11,9,11,11],[11,12,11,13],[12,9,12,11],[12,12,12,13],[13,9,13,11],[13,12,13,13],[14,12,14,13],[15,12,15,13],[14,8,14,11],[32,9,32,11],[32,12,32,13],[33,9,33,11],[33,12,33,13],[103,1,103,5],[38,9,39,11],[38,12,39,12],[97,9,97,11],[31,9,31,11],[31,12,31,13],[34,8,34,11],[34,12,34,13],[35,12,35,13],[75,12,75,13],[72,9,72,11],[72,12,72,13],[63,9,63,12]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"total"]
[]
[]
[null,"Total Initial Costs for Perimeter and Checkpoint Team",null,null,null,null,null,null,null,null,null,null,{"$f":"M16","v":57462}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Equipment Initial Costs:",null,null,{"$f":"PCEquipmentInitCost","v":53007}]
[null,null,null,null,null,null,null,null,null,"Personnel Initial Costs:",null,null,0,null,null,null,null,null,"Equipment Initial Costs:","Training Initial Costs:","User Input Equipment Initial Costs:"]
[null,null,null,null,null,null,null,null,null,"Training Initial Costs:",null,null,{"$f":"PCTrainingInitCost","v":4455},null,null,null,null,null,{"$f":"PCEquipmentInitCost","v":53007},{"$f":"PCTrainingInitCost","v":4455},{"$f":"PCCustomEquipInitCost","v":0}]
[null,null,null,null,null,null,null,null,"User Input Equipment Initial Costs:",null,null,null,{"$f":"PCCustomEquipInitCost","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M12:N15)","v":57462}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Annual Costs for Perimeter and Checkpoint Team",null,null,null,null,null,null,null,null,null,null,{"$f":"M36","v":28664.5}]
[]
[null,null,null,null,null,null,null,null,null,"total"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Equipment Annual Costs:",null,null,{"$f":"PCEquipAllAnnCost","v":16811.5}]
[null,null,null,null,null,null,null,null,null,"Personnel Annual Costs:",null,null,{"$f":"PCPersonnelAnnCost","v":10368},null,null,null,null,null,"Equipment Annual Costs:","Personnel Annual Costs:","Training Annual Costs:","User Input Equipment Annual Costs:"]
[null,null,null,null,null,null,null,null,null,"Training Annual Costs:",null,null,{"$f":"PCTrainingAnnCost","v":1485},null,null,null,null,null,{"$f":"PCEquipAllAnnCost","v":16811.5},{"$f":"PCPersonnelAnnCost","v":10368},{"$f":"PCTrainingAnnCost","v":1485},{"$f":"PCCustomEquipAnnCost","v":0}]
[null,null,null,null,null,null,null,null,"User Input Equipment Annual Costs:",null,null,null,{"$f":"PCCustomEquipAnnCost","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M32:N35)","v":28664.5}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Number of expected deployments annually:",null,null,{"$f":"EventFrequency","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,"This can be changed on the User Input page."]
[]
[]
[]
[null,"Annual Cost Breakdown"]
[]
[]
[null,"Cost Factors",null,null,null,"(2)\nEnergy","(3) \nOperating","(4)\nRepair","(5)\nUpgrade"]
[null,"Large Vehicle",null,null,null,0.36,1200,0.15,0]
[null,"Small Vehicle",null,null,null,0.2,1200,0.15,0]
[null,"Equipment (as a percentage of the initial cost)",null,null,null,0.1,0.05,0.1,0.25]
[]
[]
[]
[null,"Equipment Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PCEquipAllAnnCost","v":16811.5}]
[]
[]
[null,"Item Description",null,null,"Quantity","Comp Costs","(1)\nInitial","Shelf\nLife","R-Cost","(2)\nEnergy","(3) \nOperating","(4)\nRepair","(5) Upgrade","Annual Costs"]
[null,"Mobile Checkpoint Guard Booth",null,null,{"$f":"'Perimeter and Checkpoint Needs'!K13","v":1},{"$f":"'Perimeter and Checkpoint Needs'!L13","v":18000},{"$f":"E59*F59","v":18000},10,{"$f":"G59/H59","v":1800},{"$f":"0.1*G59","v":1800},{"$f":"0.05*G59","v":900},{"$f":"0.1*G59","v":1800},0,{"$f":"SUM(I59:M59)","v":6300}]
[null,"Plastic Barriers",null,null,{"$f":"'Perimeter and Checkpoint Needs'!K14","v":100},{"$f":"'Perimeter and Checkpoint Needs'!L14","v":350},{"$f":"E60*F60","v":35000},5,{"$f":"G60/H60","v":7000},0,0,{"$f":"0.1*G60","v":3500},0,{"$f":"SUM(I60:M60)","v":10500}]
[null,"Plastic Fold-up Barriers",null,null,{"$f":"'Perimeter and Checkpoint Needs'!K15","v":0},{"$f":"'Perimeter and Checkpoint Needs'!L15","v":300},{"$f":"E61*F61","v":0},5,{"$f":"G61/H61","v":0},0,0,{"$f":"0.1*G61","v":0},0,{"$f":"SUM(I61:M61)","v":0}]
[null,"Steel Crowd Control Barriers",null,null,{"$f":"'Perimeter and Checkpoint Needs'!K16","v":0},{"$f":"'Perimeter and Checkpoint Needs'!L16","v":100},{"$f":"E62*F62","v":0},5,{"$f":"G62/H62","v":0},0,0,{"$f":"0.1*G62","v":0},0,{"$f":"SUM(I62:M62)","v":0}]
[null,"Caution Tape",null,null,{"$f":"'Perimeter and Checkpoint Needs'!K17","v":1},{"$f":"'Perimeter and Checkpoint Needs'!L17","v":7},{"$f":"E63*F63","v":7},1,{"$f":"G63/H63","v":7},0,0,{"$f":"4.5*E63","v":4.5},0,{"$f":"SUM(I63:M63)","v":11.5}]
[null,null,null,null,null,null,null,null,null,"Total Equipment Annual Cost:  ",null,null,null,{"$f":"SUM(N59:N63)","v":16811.5}]
[]
[]
[null,"Personnel Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PCPersonnelAnnCost","v":10368}]
[]
[]
[null,"Item Description",null,null,null,null,null,"Total Personnel","Hours Deployed","Hourly Wage/\nBackfill","Initial Cost","Deployment Frequency","Annual Costs"]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B26:F26","v":"Supervisors"},null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!K26","v":16},{"$f":"'Perimeter and Checkpoint Needs'!L26","v":6},{"$f":"'Perimeter and Checkpoint Needs'!M26","v":52},{"$f":"H71*I71*J71","v":4992},{"$f":"EventFrequency","v":1},{"$f":"L71*K71","v":4992}]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B27:F27","v":"Patrol Officers"},null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!K27","v":28},{"$f":"'Perimeter and Checkpoint Needs'!L27","v":6},{"$f":"'Perimeter and Checkpoint Needs'!M27","v":32},{"$f":"H72*I72*J72","v":5376},1,{"$f":"L72*K72","v":5376}]
[null,null,null,null,null,null,null,null,null,"Total Personnel Annual Cost:  ",null,null,{"$f":"SUM(M71:N72)","v":10368}]
[]
[]
[null,"Training Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M81:M88)+SUM(M90:M97)","v":1485}]
[]
[]
[null,"Item Description",null,null,null,null,null,"Quantity","Cost of Course + Backfill","Initial Costs","Retraining Frequency (years)","Average Career (years)","Annual Costs"]
[null,"Supervisors"]
[null,"IS-100",null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J37","v":4},{"$f":"'Perimeter and Checkpoint Needs'!K37*'Perimeter and Checkpoint Needs'!M37+'Perimeter and Checkpoint Needs'!L37","v":156},{"$f":"H81*I81","v":624},3,9,{"$f":"J81/(IF(K81<L81,K81,L81))","v":208}]
[null,"IS-230",null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J38","v":4},{"$f":"'Perimeter and Checkpoint Needs'!K38*'Perimeter and Checkpoint Needs'!M38+'Perimeter and Checkpoint Needs'!L38","v":52},{"$f":"H82*I82","v":208},3,9,{"$f":"J82/(IF(K82<L82,K82,L82))","v":69.333333333333329}]
[null,"IS-700",null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J39","v":4},{"$f":"'Perimeter and Checkpoint Needs'!K39*'Perimeter and Checkpoint Needs'!M39+'Perimeter and Checkpoint Needs'!L39","v":156},624,3,9,208]
[null,"IS-701",null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J40","v":4},{"$f":"'Perimeter and Checkpoint Needs'!K40*'Perimeter and Checkpoint Needs'!M40+'Perimeter and Checkpoint Needs'!L40","v":104},416,3,9,138.66666666666666]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B41:H41","v":"Additional training"},null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J41","v":4},{"$f":"'Perimeter and Checkpoint Needs'!K41*'Perimeter and Checkpoint Needs'!M41+'Perimeter and Checkpoint Needs'!L41","v":0},0,3,9,0]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B42:H42","v":"Additional training"},null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J42","v":4},{"$f":"'Perimeter and Checkpoint Needs'!K42*'Perimeter and Checkpoint Needs'!M42+'Perimeter and Checkpoint Needs'!L42","v":0},0,3,9,0]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B43:H43","v":"Additional training"},null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J43","v":4},{"$f":"'Perimeter and Checkpoint Needs'!K43*'Perimeter and Checkpoint Needs'!M43+'Perimeter and Checkpoint Needs'!L43","v":0},0,3,9,0]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B44:H44","v":"Additional training"},null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J44","v":4},{"$f":"'Perimeter and Checkpoint Needs'!K44*'Perimeter and Checkpoint Needs'!M44+'Perimeter and Checkpoint Needs'!L44","v":0},0,3,9,{"$f":"J88/(IF(K88<L88,K88,L88))","v":0},{"$f":"SUM(M81:M88)","v":624}]
[null,"Line Officers"]
[null,"IS-100",null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J46","v":7},{"$f":"'Perimeter and Checkpoint Needs'!K46*'Perimeter and Checkpoint Needs'!M46+'Perimeter and Checkpoint Needs'!L46","v":123},{"$f":"H90*I90","v":861},3,9,{"$f":"J90/(IF(K90<L90,K90,L90))","v":287}]
[null,"IS-230",null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J47","v":7},{"$f":"'Perimeter and Checkpoint Needs'!K47*'Perimeter and Checkpoint Needs'!M47+'Perimeter and Checkpoint Needs'!L47","v":41},{"$f":"H91*I91","v":287},3,9,{"$f":"J91/(IF(K91<L91,K91,L91))","v":95.666666666666671}]
[null,"IS-700",null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J48","v":7},{"$f":"'Perimeter and Checkpoint Needs'!K48*'Perimeter and Checkpoint Needs'!M48+'Perimeter and Checkpoint Needs'!L48","v":123},861,3,9,287]
[null,"IS-701",null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J49","v":7},{"$f":"'Perimeter and Checkpoint Needs'!K49*'Perimeter and Checkpoint Needs'!M49+'Perimeter and Checkpoint Needs'!L49","v":82},574,3,9,191.33333333333334]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B50:H50","v":"Additional training"},null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J50","v":7},{"$f":"'Perimeter and Checkpoint Needs'!K50*'Perimeter and Checkpoint Needs'!M50+'Perimeter and Checkpoint Needs'!L50","v":0},0,3,9,0]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B51:H51","v":"Additional training"},null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J51","v":7},{"$f":"'Perimeter and Checkpoint Needs'!K51*'Perimeter and Checkpoint Needs'!M51+'Perimeter and Checkpoint Needs'!L51","v":0},0,3,9,0]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B52:H52","v":"Additional training"},null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J52","v":7},{"$f":"'Perimeter and Checkpoint Needs'!K52*'Perimeter and Checkpoint Needs'!M52+'Perimeter and Checkpoint Needs'!L52","v":0},0,3,9,0]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B53:H53","v":"Additional training"},null,null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!J53","v":7},{"$f":"'Perimeter and Checkpoint Needs'!K53*'Perimeter and Checkpoint Needs'!M53+'Perimeter and Checkpoint Needs'!L53","v":0},0,3,9,0,{"$f":"SUM(M90:M97)","v":861.00000000000011}]
[null,null,null,null,null,null,null,null,null,"Total Training Annual Cost:  ",null,null,{"$f":"SUM(M90:M97,M81:M88)","v":1485}]
[]
[]
[null,"User Input Equipment",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(PCCustomEquipAnnCosts)","v":0}]
[]
[]
[null,"Item Description",null,null,null,null,"Quantity","Unit Cost","(1)\nInitial","Shelf\nLife","R-Cost","(2)\nEnergy","(3) \nOperating","(4)\nRepair","(5) Upgrade","Annual Costs"]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B62:H62","v":"Custom equipment item"},null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!K62","v":0},{"$f":"'Perimeter and Checkpoint Needs'!L62","v":0},{"$f":"H105*G105","v":0},5,{"$f":"I105/J105","v":0},0,0,0,0,{"$f":"SUM(K105:O105)","v":0}]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B63:H63","v":"Custom equipment item"},null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!K63","v":0},{"$f":"'Perimeter and Checkpoint Needs'!L63","v":0},{"$f":"H106*G106","v":0},5,{"$f":"I106/J106","v":0},0,0,0,0,{"$f":"SUM(K106:O106)","v":0}]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B64:H64","v":"Custom equipment item"},null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!K64","v":0},{"$f":"'Perimeter and Checkpoint Needs'!L64","v":0},0,5,0,0,0,0,0,0]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B65:H65","v":"Custom equipment item"},null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!K65","v":0},{"$f":"'Perimeter and Checkpoint Needs'!L65","v":0},0,5,0,0,0,0,0,0]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B66:H66","v":"Custom equipment item"},null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!K66","v":0},{"$f":"'Perimeter and Checkpoint Needs'!L66","v":0},0,5,0,0,0,0,0,0]
[null,{"$f":"'Perimeter and Checkpoint Needs'!B67:H67","v":"Custom equipment item"},null,null,null,null,{"$f":"'Perimeter and Checkpoint Needs'!K67","v":0},{"$f":"'Perimeter and Checkpoint Needs'!L67","v":0},0,5,0,0,0,0,0,0]

{"sheet":"Initial Costs","index":6,"n_rows":30,"n_cols":23,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,1,8,15],[19,1,20,15],[25,14,25,15],[29,14,29,15],[25,10,25,13],[26,10,26,13],[27,10,27,13],[26,14,26,15],[27,14,27,15],[28,10,28,13],[28,14,28,15]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Input Summary"]
[]
[]
[null,null,{"$f":"CONCATENATE(\"Crowd Control Teams \",IF(CCInput=\"Yes\",\"are\",\"are not\"),\" included in calculations.\")","v":"Crowd Control Teams are included in calculations."}]
[null,null,null,{"$f":"CONCATENATE(\"The desired officer-to-attendee ratio is 1 officer for every \", EventOfficerAttendeeRatio, \" attendees.\")","v":"The desired officer-to-attendee ratio is 1 officer for every 500 attendees."}]
[null,null,null,"Total suggested Crowd Control Teams: ",null,null,null,{"$f":"CCNumTeams","v":1}]
[]
[null,null,{"$f":"CONCATENATE(\"Perimeter/Checkpoint Teams \",IF(PCInput=\"Yes\",\"are\",\"are not\"),\" included in calculations.\")","v":"Perimeter/Checkpoint Teams are included in calculations."}]
[null,null,null,{"$f":"CONCATENATE(\"You indicated the need for \",PCCheckpoints,\" Checkpoint Team(s) and \", PCPerimeterLength, \" feet of perimeter coverage.\")","v":"You indicated the need for 4 Checkpoint Team(s) and 500 feet of perimeter coverage."}]
[]
[]
[]
[null,"Initial Cost Breakdown"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Equipment Initial Costs:","Total Training Initial Costs:","Total User Input Initial Costs:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CCArrestKitInitCost,CCCommsLogsInitCost,CCCrowdEquipmentInitCost,CCOfficerEquipInitCost,CCVehicleInitCost)+PCEquipmentInitCost","v":1643008},{"$f":"CCTrainingInitCost+PCTrainingInitCost","v":232551},{"$f":"SUM(CCCustomEquipInitCosts)+SUM(PCCustomEquipInitCost)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Equipment Initial Costs:",null,null,null,{"$f":"SUM(CCArrestKitInitCost,CCCommsLogsInitCost,CCCrowdEquipmentInitCost,CCOfficerEquipInitCost,CCVehicleInitCost)+PCEquipmentInitCost","v":1643008}]
[null,null,null,null,null,null,null,null,null,null,"Total Personnel Initial Costs:",null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Total Training Initial Costs:",null,null,null,{"$f":"CCTrainingInitCost+PCTrainingInitCost","v":232551}]
[null,null,null,null,null,null,null,null,null,null,"Total User Input Initial Costs:",null,null,null,{"$f":"SUM(CCCustomEquipInitCosts)+SUM(PCCustomEquipInitCost)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O26:P29)","v":1875559}]

{"sheet":"Annual Costs","index":7,"n_rows":36,"n_cols":24,"rows_kept":36,"cut":false,"hidden":false,"merged":[[7,1,8,15],[19,1,20,15],[25,10,25,13],[25,14,25,15],[26,10,26,13],[26,14,26,15],[33,11,34,13],[33,14,34,14],[27,10,27,13],[27,14,27,15],[28,10,28,13],[28,14,28,15],[29,14,29,15]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Input Summary"]
[]
[]
[null,null,{"$f":"CONCATENATE(\"Crowd Control Teams \",IF(CCInput=\"Yes\",\"are\",\"are not\"),\" included in calculations.\")","v":"Crowd Control Teams are included in calculations."}]
[null,null,null,{"$f":"CONCATENATE(\"The desired officer-to-attendee ratio is 1 officer for every \", EventOfficerAttendeeRatio, \" attendees.\")","v":"The desired officer-to-attendee ratio is 1 officer for every 500 attendees."}]
[null,null,null,"Total suggested Crowd Control Teams: ",null,null,null,{"$f":"CCNumTeams","v":1}]
[]
[null,null,{"$f":"CONCATENATE(\"Perimeter/Checkpoint Teams \",IF(PCInput=\"Yes\",\"are\",\"are not\"),\" included in calculations.\")","v":"Perimeter/Checkpoint Teams are included in calculations."}]
[null,null,null,{"$f":"CONCATENATE(\"You indicated the need for \",PCCheckpoints,\" Checkpoint Team(s) and \", PCPerimeterLength, \" feet of perimeter coverage.\")","v":"You indicated the need for 4 Checkpoint Team(s) and 500 feet of perimeter coverage."}]
[]
[]
[]
[null,"Annual Cost Breakdown"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Equipment Annual Costs:","Total Personnel Annual Costs:","Total Training Annual Costs:","Total User Input Annual Costs:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CCEquipAllAnnCost+PCEquipAllAnnCost","v":768758.84999999986},{"$f":"CCPersonnelAnnCost+PCPersonnelAnnCost","v":22416},{"$f":"CCTrainingAnnCost+PCTrainingAnnCost","v":75821},{"$f":"SUM(CCCustomEquipAnnCosts)+SUM(PCCustomEquipAnnCost)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Equipment Annual Costs:",null,null,null,{"$f":"CCEquipAllAnnCost+PCEquipAllAnnCost","v":768758.84999999986}]
[null,null,null,null,null,null,null,null,null,null,"Total Personnel Annual Costs:",null,null,null,{"$f":"CCPersonnelAnnCost+PCPersonnelAnnCost","v":22416}]
[null,null,null,null,null,null,null,null,null,null,"Total Training Annual Costs:",null,null,null,{"$f":"CCTrainingAnnCost+PCTrainingAnnCost","v":75821}]
[null,null,null,null,null,null,null,null,null,null,"Total User Input Annual Costs:",null,null,null,{"$f":"SUM(CCCustomEquipAnnCosts)+SUM(PCCustomEquipAnnCost)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O26:P29)","v":866995.84999999986}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Number of expected deployments annually:",null,null,{"$f":"EventFrequency","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"This can be changed on the User Input page."]

{"sheet":"Gap Costs","index":8,"n_rows":56,"n_cols":23,"rows_kept":56,"cut":false,"hidden":false,"merged":[[51,11,52,13],[51,14,52,14],[45,11,45,13],[45,14,45,15],[46,14,46,15],[42,11,42,15],[43,11,43,13],[43,14,43,15],[44,11,44,13],[44,14,44,15],[24,11,24,15],[27,14,27,15],[25,11,25,13],[26,11,26,13],[25,14,25,15],[26,14,26,15],[19,1,20,15],[8,1,9,15],[11,2,11,6],[12,3,12,5],[13,3,13,5],[14,3,14,5],[11,8,11,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Gap Calculation"]
[]
[]
[null,null,"Suggested Capability Level",null,null,null,null,null,"Current Capability Level",null,null,null,"Gap",null,null,null,null,null,null,null,"Calculated Gaps"]
[null,null,null,"Crowd Control Team(s)",null,null,{"$f":"CCNumTeams","v":1},null,null,0,null,null,{"$f":"IF(OR(J13>G13,J13=G13),\"No gap\", G13-J13)","v":1},null,null,null,null,null,null,null,"Crowd Control Team Gap",{"$f":"IF(CCGap=\"No gap\",0,CCGap)","v":1}]
[null,null,null,"Checkpoint Team(s)",null,null,{"$f":"PCCheckpoints","v":4},null,null,0,null,null,{"$f":"IF(OR(J14>G14,J14=G14),\"No gap\", G14-J14)","v":4},null,null,null,null,null,null,null,"Checkpoint Gap",{"$f":"IF(CheckpointGap=\"No gap\",0,CheckpointGap)","v":4}]
[null,null,null,"Perimeter Barriers",null,null,{"$f":"SUM('Perimeter and Checkpoint Needs'!K14:K16)","v":100},null,null,0,null,null,100,null,null,null,null,null,null,null,"Perimeter Gap",{"$f":"IF(PerimeterGap=\"No gap\",0,PerimeterGap)","v":100}]
[]
[]
[]
[]
[null,"Gap Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INITIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CC - Training per Team",{"$f":"CCTrainingInitCost/CCNumTeams","v":228096}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PC Training per Checkpoint",{"$f":"PCTrainingInitCost/PCCheckpoints","v":1113.75}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Initial Equipment and Training Costs"]
[null,null,null,null,null,null,null,null,null,null,null,"Equipment Gap Costs:  ",null,null,{"$f":"CCGapCalc*CCEquipPerTeam+CheckpointGapCalc*PCCheckpointPerTeam+PerimeterGapCalc*PCBarrierPerBarrier","v":1697001},null,null,null,null,null,"Crowd Control Equipment per team",{"$f":"SUM(CCArrestKitInitCost,CCCommsLogsInitCost,CCCrowdEquipmentInitCost,CCOfficerEquipInitCost,CCVehicleInitCost)/CCNumTeams","v":1590001}]
[null,null,null,null,null,null,null,null,null,null,null,"Training Gap Costs:  ",null,null,{"$f":"CCGapCalc*CCTrainingPerTeam+CheckpointGapCalc*PCTrainingPerCheckpoint","v":232551},null,null,null,null,null,"Checkpoint Equipment per checkpoint",{"$f":"PCCheckpointBoothsCost+PCCustomEquipInitCost/PCCheckpoints","v":18000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O26:P27)","v":1929552},null,null,null,null,null,"Perimeter Equipment per barrier",{"$f":"MAX(PCBarrierCostMatrix)","v":350}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment Gap Costs:  ","Training Gap Costs:  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CCGapCalc*CCEquipPerTeam+CheckpointGapCalc*PCCheckpointPerTeam+PerimeterGapCalc*PCBarrierPerBarrier","v":1697001},{"$f":"CCGapCalc*CCTrainingPerTeam+CheckpointGapCalc*PCTrainingPerCheckpoint","v":232551}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Annual Equipment and Training Costs",null,null,null,null,null,null,null,null,"CC - Training per Team",{"$f":"CCTrainingAnnCost/CCNumTeams","v":74336}]
[null,null,null,null,null,null,null,null,null,null,null,"Equipment Gap Costs:  ",null,null,{"$f":"CCGapCalc*CCEquipmentPerTeamAnn+CheckpointGapCalc*PCEquipPerCheckpointAnn+PerimeterGapCalc*PCBarrierPerBarrierAnn","v":768747.34999999986},null,null,null,null,null,"PC Training per Checkpoint",{"$f":"PCTrainingAnnCost/PCCheckpoints","v":371.25}]
[null,null,null,null,null,null,null,null,null,null,null,"Personnel Gap Costs:  ",null,null,{"$f":"CCGapCalc*CCPersonnelPerTeamAnn+CheckpointGapCalc*PCPersonnelPerCheckpointAnn","v":22416}]
[null,null,null,null,null,null,null,null,null,null,null,"Training Gap Costs:  ",null,null,{"$f":"CCGapCalc*CCTrainingPerTeamAnn+CheckpointGapCalc*PCTrainingPerCheckpointAnn","v":75821}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O44:P46)","v":866984.34999999986},null,null,null,null,null,"Crowd Control Equipment per team",{"$f":"CCEquipAllAnnCost/CCNumTeams","v":751947.34999999986}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Checkpoint Equipment per checkpoint",{"$f":"PCMobileBoothAnnCost/PCCheckpoints+PCCustomEquipAnnCost/PCCheckpoints","v":1575}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perimeter Equipment per barrier",{"$f":"MAX(IF('Perimeter and Checkpoint Costs'!E60=0,0,'Perimeter and Checkpoint Costs'!N60/'Perimeter and Checkpoint Costs'!E60),IF('Perimeter and Checkpoint Costs'!E61=0,0,'Perimeter and Checkpoint Costs'!N61/'Perimeter and Checkpoint Costs'!E61),IF('Perimeter and Checkpoint Costs'!E62=0,0,'Perimeter and Checkpoint Costs'!N62/'Perimeter and Checkpoint Costs'!E62))","v":105}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CC Personnel Per team",{"$f":"CCPersonnelAnnCost/CCNumTeams","v":12048}]
[null,null,null,null,null,null,null,null,null,null,null,"Number of expected deployments annually:",null,null,{"$f":"EventFrequency","v":1},null,null,null,null,null,"PC Personnel Per team",{"$f":"PCPersonnelAnnCost/PCCheckpoints","v":2592}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"This can be changed on the User Input page."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment Gap Costs:  ","Personnel Gap Costs:  ","Training Gap Costs:  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CCGapCalc*CCEquipmentPerTeamAnn+CheckpointGapCalc*PCEquipPerCheckpointAnn+PerimeterGapCalc*PCBarrierPerBarrierAnn","v":768747.34999999986},{"$f":"CCGapCalc*CCPersonnelPerTeamAnn+CheckpointGapCalc*PCPersonnelPerCheckpointAnn","v":22416},{"$f":"CCGapCalc*CCTrainingPerTeamAnn+CheckpointGapCalc*PCTrainingPerCheckpointAnn","v":75821}]

{"sheet":"Lists","index":9,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["YesNo","SingleDouble"]
["Yes","Single"]
["No","Double"]

{"sheet":"EquipmentCrowdControl","index":10,"n_rows":81,"n_cols":4,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["Equipment","Default Quantity","Price","Source"]
["Crowd Control Equipment"]
["\"Grenade\" Launcher",30,2500,"GSA"]
["Smoke grenades",150,25,"GSA"]
["\"Grenades\"",150,35,"GSA"]
["Fogger",30,26,"GSA"]
["Oleoresin Capsicum Fog Cartridge",90,45,"GSA"]
["Riot control batons",59,35,"Galls"]
["Bullhorns",59,80,"BizChair"]
["Pepper spray",59,5,"GSA"]
["Mass Arrest Kit"]
["Weather-resistant Field Booking forms",30,40,"rkb"]
["Digital camera",30,400,"SC Fusion"]
["Fingerprinting equipment",30,30,"Copquest"]
["Vehicles"]
["Patrol Vehicles",14,10000,"Estimate"]
["Prisoner Transport Vans",2,20000,"Estimate"]
["Officer Equipment"]
["Soft Body Armor",59,1000,"rkb"]
["Portable Radios",59,570,"rkb"]
["Battery charger",6,325,"rkb"]
["Respiratory mask (NIOSH-approved)",59,300,"rkb"]
["Safety glasses",59,3,"rkb"]
["Ear protection",59,1,"rkb"]
["Fire extinguisher",30,40,"rkb"]
["Foul-weather gear",59,15,"rkb"]
["Handheld shields",59,100,"GSA pricing"]
["Personal hydration system",59,50,"GSA pricing"]
["Level C PPE suits",59,200,"GSA pricing"]
["Shoulder fired weapons",0,0,0]
["Safety Helmet",59,30,"SC Cobra"]
["Vest or Outer Garment, High-visibility  ",59,9,"SC Cit Prep"]
["Handcuffs",59,21,"Copquest"]
["Handcuff case",59,16.5,"MS Police Dept Document s7"]
["Duty belt",59,26,"MS Police Dept Document s7"]
["Flashlight: MAG-LITE D-cell",59,16,"Home Depot"]
["D-Cell Batteries (8)",59,8,"Staples"]
["Flashlight holder (D-cell)",59,5.75,"MS Police Dept Document s7"]
["Flex cuffs (10)",59,11,"Copquest"]
["Cutting tool for flex cuffs",59,12.75,"Copquest"]
["Knife",59,107,"Spyderco"]
["Waterproof Duty Boots",59,124,"Galls"]
["Regular Duty Boots",59,65,"Galls"]
["Regular Duty Gloves",59,9,"SC Cit Prep"]
["Kevlar-lined police leather gloves",59,25,"Copquest"]
["Large rubber bands",59,4,"Staples"]
["Handguns",59,1144,"Impact Guns"]
["Communications and Logistics Equipment"]
["75’ Portable Communications Towers ",4,90000,"SC Int Comm"]
["Satellite Communications trailer with data, VoIP & video capability",2,199000,"SC Int Comm"]
["800 MHz 10 Watt Portable Repeaters",1,8500,"SC Int Comm"]
["800 MHz 25 Watt Portable Repeaters ",1,8500,"SC Int Comm"]
["800 MHz Conventional Repeaters",1,3934,"SC Int Comm"]
["UHF Conventional Repeater",1,4833,"SC Int Comm"]
["UHF 10 Watt Portable Repeater",1,1063,"SC Int Comm"]
["VHF Conventional Repeater",1,2500,"SC Int Comm"]
["VHF 10 Watt Portable Repeater",1,1063,"SC Int Comm"]
["VHF, UHF & 800 MHz Desk Top Control Station ",1,10156,"SC Int Comm"]
["800 MHz Handheld Radios  (Motorola XTS 2500)",1,2500,"SC Int Comm"]
["VHF Handheld Radios ",1,800,"SC Int Comm"]
["UHF Handheld Radios ",1,806,"SC Int Comm"]
["6 bay rack chargers ",1,639,"SC Int Comm"]
["Law enforcement surveillance equipment",1,5432,"SC Fusion"]
["Mapping/GIS Software",1,40000,"SC Fusion"]
["Data Acquisition Software",1,7040,"SC Fusion"]
["Data Exchange and Interoperability Software of System(s)",1,40000,"SC Fusion"]
["Intelligence Sharing System",1,60000,"SC Fusion"]
["Generator (14,000 Watts)",2,3689,"Home Depot"]
["Generator (7,000 Watts)",0,2300,"SC Int comm."]
["Video capture software",1,50,"SC Fusion"]
["Document Scanner",2,450,"SC Fusion"]
["Fax Machine: Canon L90 Laser",2,100,"Staples"]
["Printer: HP LaserJet P4014N",2,900,"Staples"]
["Copy Machine: Canon MF6540",2,500,"Staples"]
["Power strip (six outlet, surge protection)",10,12,"Staples"]
["40' Extension Cord",10,32,"Staples"]
["Single-unit Rapid Charger",1,60,"SC COBRA"]
["6 Unit Multi-Charger",1,190,"SC COBRA"]
["Microsoft Office/Adobe Acrobat",1,200,"SC Cit Prep"]
["ACU-1000 ",1,100000,"SC Int Comm"]
["DC Power Electrical Rectifier system",1,350,"SC Int Comm"]

{"sheet":"EquipmentPerimeter","index":11,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Perimeter Equipment","Quantity","Cost"]
["Mobile Checkpoint Guard Booth",1,18000]
["Plastic Barriers",1,350]
["Plastic Fold-up Barriers",0,300]
["Steel Crowd Control Barriers",0,100]
["Caution Tape",0,7]

{"sheet":"Sheet2","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}