{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Title Page","User Input","POD Types","Type I Needs","Type I Costs","Type II Needs","Type II Costs","Type III Needs","Type III Costs","Initial Costs","Annual Costs","Gap Costs","HoldShapes","Lists","FormatHold","CostsQuants"],"not_rendered":{"charts":21,"images":5,"macros":1,"external_links":0,"defined_names":100,"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":"Title Page","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[6,1,11,12],[12,1,14,12]]}
[]
[]
[]
[]
[]
[]
[null,"Non-Medical Points of Distribution (PODs) Capability Cost Calculator"]
[]
[]
[]
[]
[]
[null,"A tool for jurisdictional planners to estimate the number of PODs needed by their jurisdiction and to estimate the associated costs."]

{"sheet":"User Input","index":1,"n_rows":52,"n_cols":24,"rows_kept":52,"cut":false,"hidden":false,"merged":[[24,2,24,7],[24,8,24,9],[26,23,30,23],[31,6,31,8],[28,2,29,13],[26,2,26,7],[26,8,26,9],[34,9,34,10],[34,3,34,4],[44,3,44,4],[44,7,44,11],[49,3,49,11],[45,8,45,10],[21,19,21,22],[21,1,22,8],[21,9,22,13],[9,9,10,13],[9,1,10,8],[16,2,16,6],[14,2,14,6],[13,2,13,6],[12,2,12,6],[16,7,16,8],[14,7,14,8],[13,7,13,8],[12,7,12,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jurisdictional Input"]
[]
[]
[null,null,"Jurisdiction Population: ",null,null,null,null,250000]
[null,null,"Additional Population to Include: ",null,null,null,null,50000]
[null,null,"Percent of Population in Need of POD Services: ",null,null,null,null,0.75]
[]
[null,null,"Total Population to Serve with PODs: ",null,null,null,null,{"$f":"H15*(H14+H13)","v":225000}]
[]
[]
[]
[]
[null,"POD Type Distribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not edit the data in this box"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I","II","III"]
[null,null,"How many days will your PODs be deployed for?",null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,"Percents",{"$f":"SolverPerI","v":0.06},{"$f":"SolverPerII","v":0.04},{"$f":"SolverPerIII","v":0.9},"To Minimize"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solver Answers",3.849567587491566,2.5515823711039785,51.52544936545906,{"$f":"IF(H17-W28>0,H17-W28,0)","v":0}]
[null,null,"How many times per year do you expect to deploy PODs?",null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pop Served","(This gives the \"such that\")"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"20000*T26+10000*U26+5000*V26","v":360134.42228816642}]
[null,null,"How would you like to determine POD Type Distribution - by specifying the approximate percentage of each type to employ, or by entering the specific number of each to employ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Theoretical Ratios",{"$f":"T25/U25","v":1.5},{"$f":"U25/V25","v":4.4444444444444446E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual Ratios",{"$f":"T26/U26","v":1.5086981439780036},{"$f":"U26/V26","v":4.9520817431521015E-2}]
[]
[null,null,null,null,null,null,"Percent",null,null,null,null,null,null,null,null,null,null,null,null,"Rounded Results"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(T26,0)","v":4},{"$f":"ROUNDUP(U26,0)","v":3},52]
[]
[null,null,null,"Percentage of…",null,null,null,null,null,"Number of…"]
[null,null,null,null,"Type I",0.06,null,null,null,null,"Type I",{"$f":"T33","v":4}]
[null,null,null,null,"Type II",0.04,null,null,null,null,"Type II",{"$f":"U33","v":3}]
[null,null,null,null,"Type III",0.9,null,null,null,null,"Type III",{"$f":"V33","v":52}]
[null,null,null,null,"Total",{"$f":"ROUND(SUM(F36:F38),2)","v":1}]
[]
[]
[]
[]
[]
[null,null,null,"Number of…",null,null,null,"Population Remaining to be Served"]
[null,null,null,null,"Type I",5,null,null,{"$f":"IF(H17-F46*20000-F47*10000-F48*5000>=0,H17-F46*20000-F47*10000-F48*5000,0)","v":0}]
[null,null,null,null,"Type II",12]
[null,null,null,null,"Type III",4]
[]
[null,null,null,"Add teams of your preferred type until the Population Remaining to be Served is 0."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type I","Type II","Type III"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(InputPerNum=\"Percent\",L36,F46)","v":4},{"$f":"IF(InputPerNum=\"Percent\",L37,F47)","v":3},{"$f":"IF(InputPerNum=\"Percent\",L38,F48)","v":52}]

{"sheet":"POD Types","index":2,"n_rows":120,"n_cols":16,"rows_kept":120,"cut":false,"hidden":false,"merged":[[10,9,11,17],[96,14,96,16],[119,14,119,16],[43,1,44,8],[10,1,11,8],[15,1,15,3],[29,1,29,2],[43,9,44,17],[68,10,68,11],[86,11,86,14],[73,6,73,9],[72,6,72,9],[71,6,71,9],[70,6,70,9],[68,6,68,9],[68,12,68,14],[90,15,90,16],[73,10,73,11],[72,10,72,11],[71,10,71,11],[70,10,70,11],[46,8,46,10],[77,8,77,10],[110,11,110,14],[110,15,110,16],[91,11,91,14],[91,15,91,16],[69,6,69,9],[69,10,69,11],[87,11,87,14],[87,15,87,16],[86,15,86,16],[88,11,88,14],[88,15,88,16],[89,11,89,14],[89,15,89,16],[90,11,90,14],[115,11,115,14],[115,15,115,16],[104,8,104,10],[112,11,112,14],[112,15,112,16],[113,11,113,14],[113,15,113,16],[114,11,114,14],[114,15,114,16],[111,11,111,14],[111,15,111,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"POD Module: Loading Points"]
[]
[]
[]
[]
[null,"Loading Point"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"POD Module"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"POD Types"]
[]
[]
[null,null,null,null,null,null,null,null,"Type I POD"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Population Served per Day:  ",null,null,null,20000,null,"(approximately 6,700 cars)"]
[null,null,null,null,null,null,"Number of POD Modules:  ",null,null,null,4]
[null,null,null,null,null,null,"Dimensions:  ",null,null,null,"500' by 250'"]
[null,null,null,null,null,null,"Number of Daytime Personnel:  ",null,null,null,78]
[null,null,null,null,null,null,"Number of Nighttime Personnel:  ",null,null,null,10]
[null,null,null,null,null,null,"Number of Car Lanes:  ",null,null,null,4]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Type II POD"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Population Served per Day:  ",null,null,null,"10,000*"]
[null,null,null,null,null,null,null,null,null,null,null,"Number of POD Modules:  ",null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,"Dimensions:  ",null,null,null,"300' by 250'"]
[null,null,null,null,null,null,null,null,null,null,null,"Number of Daytime Personnel:  ",null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,"Number of Nighttime Personnel:  ",null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,"Number of Car Lanes:  ",null,null,null,2]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*(approximately 3,400 cars)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Type III POD"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Population Served per Day:  ",null,null,null,"5,000*"]
[null,null,null,null,null,null,null,null,null,null,null,"Number of POD Modules:  ",null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,"Dimensions:  ",null,null,null,"300' by 150'"]
[null,null,null,null,null,null,null,null,null,null,null,"Number of Daytime Personnel:  ",null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,"Number of Nighttime Personnel:  ",null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,"Number of Car Lanes:  ",null,null,null,1]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*(approximately 1,700 cars)"]

{"sheet":"Type I Needs","index":3,"n_rows":79,"n_cols":15,"rows_kept":79,"cut":false,"hidden":false,"merged":[[77,1,77,7],[14,14,15,17],[66,1,66,7],[67,1,67,7],[68,1,68,7],[75,1,75,7],[76,1,76,7],[41,1,41,8],[42,1,42,8],[64,1,64,7],[65,1,65,7],[21,1,21,8],[22,1,22,8],[23,1,23,8],[24,1,24,8],[30,1,30,8],[16,1,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[8,2,8,5],[9,7,9,13],[14,1,15,8],[14,9,15,12],[12,12,13,12],[12,11,13,11],[12,10,13,10],[12,9,13,9],[8,7,8,10],[72,1,73,8],[72,9,73,12],[31,1,31,8],[32,1,32,8],[33,1,33,8],[34,1,34,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[39,1,39,8],[40,1,40,8],[48,1,48,8],[49,1,49,8],[46,1,47,10],[46,14,46,17],[47,14,57,17],[28,1,29,8],[28,9,29,12],[61,1,62,8],[61,9,62,12],[56,1,56,7],[55,1,55,7],[54,1,54,7],[53,1,53,7],[52,1,52,7],[51,1,51,7],[50,1,50,7],[50,8,51,8],[57,1,57,7],[46,11,47,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Your capability need is",null,null,null,{"$f":"IF(InputPerNum=\"Percent\",'User Input'!L36,'User Input'!F46)","v":4},"Type I PODs, operating for",null,null,null,{"$f":"CONCATENATE(SUM('User Input'!I25:J25), \" days\")","v":"3 days"}]
[null,null,null,null,null,null,null,"You can adjust costs and quantities below to reflect your actual costs and needs."]
[]
[]
[null,null,null,null,null,null,null,null,null,"Default Quantities","Quantities","Unit Costs","Initial Cost"]
[]
[null,"Loading Point Equipment",null,null,null,null,null,null,null,{"$f":"M26","v":465454},null,null,null,null,"For more information about a Type I POD…"]
[]
[null,"Forklifts",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J17","v":12},{"$f":"J17","v":12},25000,{"$f":"K17*L17","v":300000}]
[null,"Pallet Jacks",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J18","v":12},12,365,{"$f":"K18*L18","v":4380}]
[null,"Power Light Set",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J19","v":8},8,11230,89840]
[null,"Toilets",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J20","v":24},24,686,16464]
[null,"Tents",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J21","v":8},8,595,4760]
[null,"Dumpsters",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J22","v":16},16,752,12032]
[null,"Traffic cones",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J23","v":120},120,27.15,3258]
[null,"Two way radio",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J24","v":16},16,250,4000]
[null,"Pallets",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J25","v":3072},3072,10,30720]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M17:M25)","v":465454}]
[]
[]
[null,"POD Kit",null,null,null,null,null,null,null,{"$f":"M44","v":32694.399999999998}]
[]
[null,"96-gallon trash can",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J31","v":16},{"$f":"J31","v":16},90,{"$f":"K31*L31","v":1440}]
[null,"Work gloves (pairs)",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J32","v":256},256,2,{"$f":"K32*L32","v":512}]
[null,"Duct tape",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J33","v":64},64,1,64]
[null,"Flashlights",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J34","v":320},320,20,6400]
[null,"Batteries",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J35","v":576},576,1.25,720]
[null,"Reflective safety vests",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J36","v":320},320,30,9600]
[null,"First Aid kit",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J37","v":16},16,40,640]
[null,"Traffic cones",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J38","v":192},192,27.15,5212.7999999999993]
[null,"Hard hats",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J39","v":256},256,15.35,3929.6]
[null,"Glow sticks (orange/red)",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J40","v":480},480,1,{"$f":"K40*L40","v":480}]
[null,"Back support vest",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J41","v":128},128,15,1920]
[null,"Fire extinguisher (5lb)",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J42","v":16},16,61,976]
[null,"Signage",null,null,null,null,null,null,null,{"$f":"$G$9*CostsQuants!J43","v":80},80,10,800]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M31:M43)","v":32694.399999999998}]
[]
[]
[null,"POD Supplies (if these items are donated/provided free of charge, change all prices to $0.00.)",null,null,null,null,null,null,null,null,null,{"$f":"M59","v":4440000},null,null,"How to add custom supplies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1) Decide if your custom supply will be provided each day or once total.\n2) Add your item description on the appropriate line.\n3) In the Custom Quantities cell, indicate the number provided per person.  (If the item is provided per household, divide by 3.)\n4) The Default Quantities cell will update to reflect the deployment period and suggested capability need.\n5) Enter your expected price per unit."]
[null,{"$f":"CostsQuants!A49","v":"Water (gallons) - 1 gallon per person daily"},null,null,null,null,null,null,null,{"$f":"TypeIPODs*Days*CostsQuants!J49","v":240000},{"$f":"J49","v":240000},0.5,{"$f":"K49*L49","v":120000}]
[null,{"$f":"CostsQuants!A50","v":"Ice (pounds) - 8 lbs per person daily"},null,null,null,null,null,null,null,{"$f":"TypeIPODs*Days*CostsQuants!J50","v":1920000},1920000,0.5,{"$f":"K50*L50","v":960000}]
[null,{"$f":"CostsQuants!A51","v":"Meals-Ready-to-Eat - 2 per person daily"},null,null,null,null,null,null,"Custom Quantities",{"$f":"TypeIPODs*Days*CostsQuants!J51","v":480000},480000,2,960000]
[null,{"$f":"CostsQuants!A52","v":"Tarps (20' x 25') - 1 per household, total"},null,null,null,null,null,null,null,{"$f":"TypeIPODs*Days*CostsQuants!J52","v":240000},240000,10,2400000]
[null,"Custom Item - daily",null,null,null,null,null,null,0,{"$f":"I53*TypeIPODs*Days*20000","v":0},{"$f":"J53","v":0},0,0]
[null,"Custom Item - daily",null,null,null,null,null,null,0,{"$f":"I54*TypeIPODs*Days*20000","v":0},0,0,0]
[null,"Custom Item - daily",null,null,null,null,null,null,0,{"$f":"I55*TypeIPODs*Days*20000","v":0},0,0,0]
[null,"Custom Item - daily",null,null,null,null,null,null,0,{"$f":"I56*TypeIPODs*Days*20000","v":0},0,0,0]
[null,"Custom Item - once",null,null,null,null,null,null,0,{"$f":"I57*TypeIPODs*20000","v":0},0,0,0]
[null,"Custom Item - once",null,null,null,null,null,null,0,{"$f":"I58*TypeIPODs*20000","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M49:M58)","v":4440000}]
[]
[]
[null,"Personnel",null,null,null,null,null,null,null,{"$f":"M70","v":363024}]
[]
[null,null,null,null,null,null,null,null,"Hours Deployed","Default Quantities","Quantities","Backfill Rate","Operating Cost"]
[null,"POD Manager",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"$G$9*CostsQuants!J65","v":4},{"$f":"J65","v":4},52,{"$f":"L65*K65*I65","v":7488}]
[null,"Support Team Leader",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"$G$9*CostsQuants!J66","v":12},12,45,{"$f":"L66*K66*I66","v":19440}]
[null,"Fork Lift Operator",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"$G$9*CostsQuants!J67","v":20},20,45,32400]
[null,"Loading Point Labor",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"$G$9*CostsQuants!J68","v":216},216,37,287712]
[null,"Pallet Jacks Labor",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"$G$9*CostsQuants!J69","v":12},12,37,15984]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M65:M69)","v":363024}]
[]
[]
[null,"Training",null,null,null,null,null,null,null,{"$f":"M79","v":71280}]
[]
[null,null,null,null,null,null,null,null,"Course Hours","Default Quantities","Quantities","Average Backfill Rate","Initial Cost"]
[null,"IS 100 - Introduction to ICS",null,null,null,null,null,null,3,{"$f":"SUM($J$65:$J$69)","v":264},{"$f":"SUM($K$65:$K$69)","v":264},30,{"$f":"L76*K76*I76","v":23760}]
[null,"IS 200 - ICS for Single Resources and Initial Action Incidents",null,null,null,null,null,null,3,264,{"$f":"SUM($K$65:$K$69)","v":264},30,{"$f":"L77*K77*I77","v":23760}]
[null,"IS 700 - NIMs",null,null,null,null,null,null,3,264,264,30,23760]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M76:M78)","v":71280}]

{"sheet":"Type I Costs","index":4,"n_rows":119,"n_cols":25,"rows_kept":119,"cut":false,"hidden":false,"merged":[[99,0,100,0],[107,1,107,5],[108,1,108,5],[109,1,109,5],[110,1,110,5],[102,1,102,5],[103,1,103,5],[104,1,104,5],[105,1,105,5],[106,1,106,5],[92,1,92,5],[93,1,93,5],[94,1,94,5],[70,11,71,14],[59,10,59,13],[59,14,59,15],[60,11,60,13],[60,14,60,15],[61,14,61,15],[63,10,63,13],[63,14,63,15],[62,10,62,13],[8,1,9,8],[55,1,56,8],[16,14,16,15],[8,9,9,16],[17,10,17,13],[16,10,16,13],[14,11,14,13],[13,11,13,13],[12,10,12,13],[17,14,17,15],[14,14,14,15],[13,14,13,15],[12,14,12,15],[18,14,18,15],[90,0,91,0],[64,10,64,13],[64,14,64,15],[65,14,65,15],[84,1,85,8],[87,1,88,8],[90,1,90,5],[91,1,91,5],[87,9,88,16],[72,11,72,16],[117,1,117,5],[118,1,118,5],[70,15,71,15],[15,14,15,15],[15,11,15,13],[62,14,62,15],[31,1,32,8],[31,9,32,16],[33,2,33,4],[37,10,37,13],[36,10,36,13],[37,14,37,15],[36,14,36,15],[38,14,38,15],[61,11,61,13],[113,1,114,8],[113,9,114,16],[116,1,116,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],[111,1,111,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Initial Costs for POD Type I",null,null,null,null,null,null,null,{"$f":"O19","v":569428.4}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source Data to be Hidden"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"T13","v":"Initial Equipment Costs: "},null,null,null,{"$f":"T14","v":498148.4},null,null,null,null,"Initial Equipment Costs: ","Initial Personnel Costs: ","Initial Training Costs: "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"T16","v":"Loading Point Costs: "},null,null,{"$f":"T17","v":465454},null,null,null,null,{"$f":"'Type I Needs'!M26+'Type I Needs'!M44","v":498148.4},0,{"$f":"'Type I Needs'!M79","v":71280}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"U16","v":"POD Kit Costs: "},null,null,{"$f":"U17","v":32694.399999999998}]
[null,null,null,null,null,null,null,null,null,null,null,"POD Supplies Costs: ",null,null,0,null,null,null,null,"Loading Point Costs: ","POD Kit Costs: ","Initial Training Costs: "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"U13","v":"Initial Personnel Costs: "},null,null,null,{"$f":"U14","v":0},null,null,null,null,{"$f":"'Type I Needs'!M26","v":465454},{"$f":"'Type I Needs'!M44","v":32694.399999999998},{"$f":"'Type I Needs'!M79","v":71280}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"V13","v":"Initial Training Costs: "},null,null,null,{"$f":"V14","v":71280}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O18,O17,O13)","v":569428.4}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Operational Costs for POD Type I",null,null,null,null,null,null,null,{"$f":"O39","v":4803024}]
[]
[null,null,"Based on one deployment"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Operational POD Supplies Costs: ",null,null,null,{"$f":"T38","v":4440000},null,null,null,null,"Operational POD Supplies Costs:","Operational Personnel Costs"]
[null,null,null,null,null,null,null,null,null,null,"Operational Personnel Costs: ",null,null,null,{"$f":"U38","v":363024},null,null,null,null,{"$f":"'Type I Needs'!M59","v":4440000},{"$f":"'Type I Needs'!M70","v":363024}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O37:P38)","v":4803024}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Annual Costs for POD Type I"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loading Point Costs: ","POD Kit Costs: ","Operational POD Supplies Costs: ","Operational Personnel Costs: ","Annual Training Costs: "]
[null,null,null,null,null,null,null,null,null,null,"Annual Equipment Costs: ",null,null,null,{"$f":"J88","v":147278.48000000001},null,null,null,null,null,{"$f":"Q99","v":140066},{"$f":"Q112","v":7212.48},{"$f":"P71*O37","v":4440000},{"$f":"P71*O38","v":363024},{"$f":"J114","v":7920}]
[null,null,null,null,null,null,null,null,null,null,null,"Loading Point Costs: ",null,null,{"$f":"U60","v":140066}]
[null,null,null,null,null,null,null,null,null,null,null,"POD Kit Costs: ",null,null,{"$f":"V60","v":7212.48}]
[null,null,null,null,null,null,null,null,null,null,"Operational POD Supplies Costs: ",null,null,null,{"$f":"W60","v":4440000}]
[null,null,null,null,null,null,null,null,null,null,"Operational Personnel Costs: ",null,null,null,{"$f":"X60","v":363024}]
[null,null,null,null,null,null,null,null,null,null,"Annual Training Costs: ",null,null,null,{"$f":"Y60","v":7920}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O60:P65)","v":5105500.96}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"How many times per year do you \nexpect to deploy PODs?",null,null,null,{"$f":"Deployed","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"This can be changed on the User Input page."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Annualized Cost Summary"]
[]
[]
[null,"Equipment Annualized Costs",null,null,null,null,null,null,null,{"$f":"SUM(Q99,Q112)","v":147278.48000000001}]
[]
[null,null,null,null,null,null,"Quantity","Unit Cost","Initial Cost","Shelf Life","R-Cost","Energy","Operating","Repair","Upgrade","Annual Costs","Category Totals"]
["Loading Point",{"$f":"'Type I Needs'!B17:I17","v":"Forklifts"},null,null,null,null,{"$f":"'Type I Needs'!K17","v":12},{"$f":"'Type I Needs'!L17","v":25000},{"$f":"H91*G91","v":300000},10,{"$f":"I91/J91","v":30000},{"$f":"I91*0.1","v":30000},{"$f":"0.05*I91","v":15000},{"$f":"0.05*I91","v":15000},0,{"$f":"SUM(K91:O91)","v":90000}]
[null,{"$f":"'Type I Needs'!B18:I18","v":"Pallet Jacks"},null,null,null,null,{"$f":"'Type I Needs'!K18","v":12},{"$f":"'Type I Needs'!L18","v":365},{"$f":"H92*G92","v":4380},10,{"$f":"I92/J92","v":438},{"$f":"I92*0.1","v":438},{"$f":"0.05*I92","v":219},{"$f":"0.05*I92","v":219},0,{"$f":"SUM(K92:O92)","v":1314}]
[null,{"$f":"'Type I Needs'!B19:I19","v":"Power Light Set"},null,null,null,null,{"$f":"'Type I Needs'!K19","v":8},{"$f":"'Type I Needs'!L19","v":11230},89840,10,8984,8984,4492,4492,0,26952]
[null,{"$f":"'Type I Needs'!B20:I20","v":"Toilets"},null,null,null,null,{"$f":"'Type I Needs'!K20","v":24},{"$f":"'Type I Needs'!L20","v":686},16464,10,1646.4,0,0,823.2,0,2469.6000000000004]
[null,{"$f":"'Type I Needs'!B21:I21","v":"Tents"},null,null,null,null,{"$f":"'Type I Needs'!K21","v":8},{"$f":"'Type I Needs'!L21","v":595},4760,10,476,0,0,238,0,714]
[null,{"$f":"'Type I Needs'!B22:I22","v":"Dumpsters"},null,null,null,null,{"$f":"'Type I Needs'!K22","v":16},{"$f":"'Type I Needs'!L22","v":752},12032,10,1203.2,0,0,601.6,0,1804.8000000000002]
[null,{"$f":"'Type I Needs'!B23:I23","v":"Traffic cones"},null,null,null,null,{"$f":"'Type I Needs'!K23","v":120},{"$f":"'Type I Needs'!L23","v":27.15},3258,5,651.6,0,0,0,0,651.6]
[null,{"$f":"'Type I Needs'!B24:I24","v":"Two way radio"},null,null,null,null,{"$f":"'Type I Needs'!K24","v":16},{"$f":"'Type I Needs'!L24","v":250},4000,5,800,0,0,0,0,800]
[null,{"$f":"'Type I Needs'!B25:I25","v":"Pallets"},null,null,null,null,{"$f":"'Type I Needs'!K25","v":3072},{"$f":"'Type I Needs'!L25","v":10},30720,2,15360,0,0,0,0,15360,{"$f":"SUM(P91:P99)","v":140066}]
["POD Kit",{"$f":"'Type I Needs'!B31:I31","v":"96-gallon trash can"},null,null,null,null,{"$f":"'Type I Needs'!K31","v":16},{"$f":"'Type I Needs'!L31","v":90},1440,5,288,0,0,0,0,288]
[null,{"$f":"'Type I Needs'!B32:I32","v":"Work gloves (pairs)"},null,null,null,null,{"$f":"'Type I Needs'!K32","v":256},{"$f":"'Type I Needs'!L32","v":2},512,5,102.4,0,0,0,0,102.4]
[null,{"$f":"'Type I Needs'!B33:I33","v":"Duct tape"},null,null,null,null,{"$f":"'Type I Needs'!K33","v":64},{"$f":"'Type I Needs'!L33","v":1},64,2,32,0,0,0,0,32]
[null,{"$f":"'Type I Needs'!B34:I34","v":"Flashlights"},null,null,null,null,{"$f":"'Type I Needs'!K34","v":320},{"$f":"'Type I Needs'!L34","v":20},6400,5,1280,0,0,0,0,1280]
[null,{"$f":"'Type I Needs'!B35:I35","v":"Batteries"},null,null,null,null,{"$f":"'Type I Needs'!K35","v":576},{"$f":"'Type I Needs'!L35","v":1.25},720,1,720,0,0,0,0,720]
[null,{"$f":"'Type I Needs'!B36:I36","v":"Reflective safety vests"},null,null,null,null,{"$f":"'Type I Needs'!K36","v":320},{"$f":"'Type I Needs'!L36","v":30},9600,5,1920,0,0,0,0,1920]
[null,{"$f":"'Type I Needs'!B37:I37","v":"First Aid kit"},null,null,null,null,{"$f":"'Type I Needs'!K37","v":16},{"$f":"'Type I Needs'!L37","v":40},640,5,128,0,0,0,{"$f":"0.05*I106","v":32},160]
[null,{"$f":"'Type I Needs'!B38:I38","v":"Traffic cones"},null,null,null,null,{"$f":"'Type I Needs'!K38","v":192},{"$f":"'Type I Needs'!L38","v":27.15},5212.7999999999993,5,1042.56,0,0,0,0,1042.56]
[null,{"$f":"'Type I Needs'!B39:I39","v":"Hard hats"},null,null,null,null,{"$f":"'Type I Needs'!K39","v":256},{"$f":"'Type I Needs'!L39","v":15.35},3929.6,5,785.92,0,0,0,0,785.92]
[null,{"$f":"'Type I Needs'!B40:I40","v":"Glow sticks (orange/red)"},null,null,null,null,{"$f":"'Type I Needs'!K40","v":480},{"$f":"'Type I Needs'!L40","v":1},480,2,240,0,0,0,0,240]
[null,{"$f":"'Type I Needs'!B41:I41","v":"Back support vest"},null,null,null,null,{"$f":"'Type I Needs'!K41","v":128},{"$f":"'Type I Needs'!L41","v":15},1920,5,384,0,0,0,0,384]
[null,{"$f":"'Type I Needs'!B42:I42","v":"Fire extinguisher (5lb)"},null,null,null,null,{"$f":"'Type I Needs'!K42","v":16},{"$f":"'Type I Needs'!L42","v":61},976,10,97.6,0,0,0,0,97.6]
[null,{"$f":"'Type I Needs'!B43:I43","v":"Signage"},null,null,null,null,{"$f":"'Type I Needs'!K43","v":80},{"$f":"'Type I Needs'!L43","v":10},800,5,160,0,0,0,0,160,{"$f":"SUM(P100:P112)","v":7212.48}]
[]
[null,"Training Annualized Costs",null,null,null,null,null,null,null,{"$f":"SUM(P117:P119)","v":7920}]
[]
[null,null,null,null,null,null,"Quantity","Course Hours","Backfill Rate","Initial Cost","Shelf Life",null,null,null,null,"Annual Costs"]
[null,{"$f":"'Type I Needs'!B76:H76","v":"IS 100 - Introduction to ICS"},null,null,null,null,{"$f":"'Type I Needs'!K76","v":264},{"$f":"'Type I Needs'!I76","v":3},{"$f":"'Type I Needs'!L76","v":30},{"$f":"I117*H117*G117","v":23760},9,null,null,null,null,{"$f":"J117/K117","v":2640}]
[null,{"$f":"'Type I Needs'!B77:H77","v":"IS 200 - ICS for Single Resources and Initial Action Incidents"},null,null,null,null,{"$f":"'Type I Needs'!K77","v":264},{"$f":"'Type I Needs'!I77","v":3},{"$f":"'Type I Needs'!L77","v":30},{"$f":"I118*H118*G118","v":23760},9,null,null,null,null,{"$f":"J118/K118","v":2640}]
[null,{"$f":"'Type I Needs'!B78:H78","v":"IS 700 - NIMs"},null,null,null,null,{"$f":"'Type I Needs'!K78","v":264},{"$f":"'Type I Needs'!I78","v":3},{"$f":"'Type I Needs'!L78","v":30},23760,9,null,null,null,null,2640]

{"sheet":"Type II Needs","index":5,"n_rows":79,"n_cols":15,"rows_kept":79,"cut":false,"hidden":false,"merged":[[77,1,77,7],[65,1,65,7],[66,1,66,7],[67,1,67,7],[68,1,68,7],[72,1,73,8],[75,1,75,7],[76,1,76,7],[72,9,73,12],[40,1,40,8],[41,1,41,8],[42,1,42,8],[61,1,62,8],[61,9,62,12],[64,1,64,7],[48,1,48,8],[49,1,49,8],[46,11,47,12],[46,1,47,10],[39,1,39,8],[28,1,29,8],[28,9,29,12],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[34,1,34,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[24,1,24,8],[14,1,15,8],[14,9,15,12],[14,14,15,17],[16,1,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[21,1,21,8],[22,1,22,8],[23,1,23,8],[8,2,8,5],[8,7,8,10],[9,7,9,13],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[46,14,46,17],[47,14,57,17],[50,1,50,7],[50,8,51,8],[51,1,51,7],[52,1,52,7],[53,1,53,7],[54,1,54,7],[55,1,55,7],[56,1,56,7],[57,1,57,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Your capability need is",null,null,null,{"$f":"IF(InputPerNum=\"Percent\",'User Input'!L37,'User Input'!F47)","v":3},"Type II PODs, operating for",null,null,null,{"$f":"CONCATENATE(SUM('User Input'!I25:J25), \" days\")","v":"3 days"}]
[null,null,null,null,null,null,null,"You can adjust costs and quantities below to reflect your actual costs and needs."]
[]
[]
[null,null,null,null,null,null,null,null,null,"Default Quantities","Quantities","Unit Costs","Initial Cost"]
[]
[null,"Loading Point Equipment",null,null,null,null,null,null,null,{"$f":"M26","v":214935.75},null,null,null,null,"For more information about a Type II POD…"]
[]
[null,"Forklifts",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K17","v":6},{"$f":"J17","v":6},25000,{"$f":"K17*L17","v":150000}]
[null,"Pallet Jacks",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K18","v":6},6,365,{"$f":"K18*L18","v":2190}]
[null,"Power Light Set",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K19","v":3},3,11230,33690]
[null,"Toilets",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K20","v":12},12,686,8232]
[null,"Tents",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K21","v":6},6,595,3570]
[null,"Dumpsters",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K22","v":6},6,752,4512]
[null,"Traffic cones",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K23","v":45},45,27.15,1221.75]
[null,"Two way radio",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K24","v":0},0,250,0]
[null,"Pallets",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K25","v":1152},1152,10,11520]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M17:M25)","v":214935.75}]
[]
[]
[null,"POD Kit",null,null,null,null,null,null,null,{"$f":"M44","v":12260.4}]
[]
[null,"96-gallon trash can",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K31","v":6},{"$f":"J31","v":6},90,{"$f":"K31*L31","v":540}]
[null,"Work gloves (pairs)",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K32","v":96},96,2,{"$f":"K32*L32","v":192}]
[null,"Duct tape",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K33","v":24},24,1,24]
[null,"Flashlights",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K34","v":120},120,20,2400]
[null,"Batteries",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K35","v":216},216,1.25,270]
[null,"Reflective safety vests",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K36","v":120},120,30,3600]
[null,"First Aid kit",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K37","v":6},6,40,240]
[null,"Traffic cones",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K38","v":72},72,27.15,1954.8]
[null,"Hard hats",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K39","v":96},96,15.35,1473.6]
[null,"Glow sticks (orange/red)",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K40","v":180},180,1,{"$f":"K40*L40","v":180}]
[null,"Back support vest",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K41","v":48},48,15,720]
[null,"Fire extinguisher (5lb)",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K42","v":6},6,61,366]
[null,"Signage",null,null,null,null,null,null,null,{"$f":"TypeIIPODs*CostsQuants!K43","v":30},30,10,300]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M31:M43)","v":12260.4}]
[]
[]
[null,"POD Supplies (if these supplies are donated/provided free of charge, change all prices to $0.00.)",null,null,null,null,null,null,null,null,null,{"$f":"M59","v":1665000},null,null,"How to add custom supplies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\n1) Custom supplies can be added on the POD Type I Needs page, and will be filled in on this page automatically."]
[null,{"$f":"CostsQuants!A49","v":"Water (gallons) - 1 gallon per person daily"},null,null,null,null,null,null,null,{"$f":"TypeIIPODs*Days*CostsQuants!K49","v":90000},{"$f":"J49","v":90000},0.5,{"$f":"K49*L49","v":45000}]
[null,{"$f":"CostsQuants!A50","v":"Ice (pounds) - 8 lbs per person daily"},null,null,null,null,null,null,null,{"$f":"TypeIIPODs*Days*CostsQuants!K50","v":720000},720000,0.5,{"$f":"K50*L50","v":360000}]
[null,{"$f":"CostsQuants!A51","v":"Meals-Ready-to-Eat - 2 per person daily"},null,null,null,null,null,null,"Custom Quantities",{"$f":"TypeIIPODs*Days*CostsQuants!K51","v":180000},180000,2,360000]
[null,{"$f":"CostsQuants!A52","v":"Tarps (20' x 25') - 1 per household, total"},null,null,null,null,null,null,null,{"$f":"TypeIIPODs*Days*CostsQuants!K52","v":90000},90000,10,900000]
[null,{"$f":"Custom1","v":"Custom Item - daily"},null,null,null,null,null,null,{"$f":"'Type I Needs'!I53","v":0},{"$f":"I53*TypeIIPODs*Days*10000","v":0},{"$f":"J53","v":0},{"$f":"'Type I Needs'!L53","v":0},0]
[null,{"$f":"Custom2","v":"Custom Item - daily"},null,null,null,null,null,null,{"$f":"'Type I Needs'!I54","v":0},{"$f":"I54*TypeIIPODs*Days*10000","v":0},0,{"$f":"'Type I Needs'!L54","v":0},0]
[null,{"$f":"Custom3","v":"Custom Item - daily"},null,null,null,null,null,null,{"$f":"'Type I Needs'!I55","v":0},{"$f":"I55*TypeIIPODs*Days*10000","v":0},0,{"$f":"'Type I Needs'!L55","v":0},0]
[null,{"$f":"Custom4","v":"Custom Item - daily"},null,null,null,null,null,null,{"$f":"'Type I Needs'!I56","v":0},{"$f":"I56*TypeIIPODs*Days*10000","v":0},0,{"$f":"'Type I Needs'!L56","v":0},0]
[null,{"$f":"Custom5","v":"Custom Item - once"},null,null,null,null,null,null,{"$f":"'Type I Needs'!I57","v":0},{"$f":"I57*TypeIIPODs*10000","v":0},0,{"$f":"'Type I Needs'!L57","v":0},0]
[null,{"$f":"Custom6","v":"Custom Item - once"},null,null,null,null,null,null,{"$f":"'Type I Needs'!I58","v":0},{"$f":"I58*TypeIIPODs*10000","v":0},0,{"$f":"'Type I Needs'!L58","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M49:M58)","v":1665000}]
[]
[]
[null,"Personnel",null,null,null,null,null,null,null,{"$f":"M70","v":141048}]
[]
[null,null,null,null,null,null,null,null,"Hours Deployed","Default Quantities","Quantities","Backfill Rate","Operating Cost"]
[null,"POD Manager",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"TypeIIPODs*CostsQuants!K65","v":0},{"$f":"J65","v":0},52,{"$f":"L65*K65*I65","v":0}]
[null,"Support Team Leader",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"TypeIIPODs*CostsQuants!K66","v":9},9,45,{"$f":"L66*K66*I66","v":14580}]
[null,"Fork Lift Operator",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"TypeIIPODs*CostsQuants!K67","v":9},9,45,14580]
[null,"Loading Point Labor",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"TypeIIPODs*CostsQuants!K68","v":81},81,37,107892]
[null,"Pallet Jacks Labor",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"TypeIIPODs*CostsQuants!K69","v":3},3,37,3996]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M65:M69)","v":141048}]
[]
[]
[null,"Training",null,null,null,null,null,null,null,{"$f":"M79","v":27540}]
[]
[null,null,null,null,null,null,null,null,"Course Hours","Default Quantities","Quantities","Average Backfill Rate","Initial Cost"]
[null,"IS 100 - Introduction to ICS",null,null,null,null,null,null,3,{"$f":"SUM($J$65:$J$69)","v":102},{"$f":"J76","v":102},30,{"$f":"L76*K76*I76","v":9180}]
[null,"IS 200 - ICS for Single Resources and Initial Action Incidents",null,null,null,null,null,null,3,102,102,30,{"$f":"L77*K77*I77","v":9180}]
[null,"IS 700 - NIMs",null,null,null,null,null,null,3,102,102,30,9180]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M76:M78)","v":27540}]

{"sheet":"Type II Costs","index":6,"n_rows":119,"n_cols":25,"rows_kept":119,"cut":false,"hidden":false,"merged":[[113,9,114,16],[116,1,116,5],[117,1,117,5],[118,1,118,5],[107,1,107,5],[108,1,108,5],[109,1,109,5],[110,1,110,5],[111,1,111,5],[113,1,114,8],[106,1,106,5],[95,1,95,5],[96,1,96,5],[97,1,97,5],[98,1,98,5],[101,1,101,5],[102,1,102,5],[103,1,103,5],[104,1,104,5],[105,1,105,5],[99,0,100,0],[99,1,99,5],[100,1,100,5],[90,0,91,0],[90,1,90,5],[91,1,91,5],[92,1,92,5],[93,1,93,5],[94,1,94,5],[65,14,65,15],[70,11,71,14],[70,15,71,15],[84,1,85,8],[87,1,88,8],[87,9,88,16],[72,11,72,16],[62,10,62,13],[62,14,62,15],[63,10,63,13],[63,14,63,15],[64,10,64,13],[64,14,64,15],[59,10,59,13],[59,14,59,15],[60,11,60,13],[60,14,60,15],[61,11,61,13],[61,14,61,15],[55,1,56,8],[17,10,17,13],[17,14,17,15],[18,14,18,15],[31,1,32,8],[31,9,32,16],[33,2,33,4],[36,10,36,13],[36,14,36,15],[37,10,37,13],[37,14,37,15],[38,14,38,15],[14,11,14,13],[14,14,14,15],[15,11,15,13],[15,14,15,15],[16,10,16,13],[16,14,16,15],[8,1,9,8],[8,9,9,16],[12,10,12,13],[12,14,12,15],[13,11,13,13],[13,14,13,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Initial Costs for POD Type II",null,null,null,null,null,null,null,{"$f":"O19","v":254736.15}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source Data to be Hidden"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"T13","v":"Initial Equipment Costs: "},null,null,null,{"$f":"T14","v":227196.15},null,null,null,null,"Initial Equipment Costs: ","Initial Personnel Costs: ","Initial Training Costs: "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"T16","v":"Loading Point Costs: "},null,null,{"$f":"T17","v":214935.75},null,null,null,null,{"$f":"'Type II Needs'!M26+'Type II Needs'!M44","v":227196.15},0,{"$f":"'Type II Needs'!M79","v":27540}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"U16","v":"POD Kit Costs: "},null,null,{"$f":"U17","v":12260.4}]
[null,null,null,null,null,null,null,null,null,null,null,"POD Supplies Costs: ",null,null,0,null,null,null,null,"Loading Point Costs: ","POD Kit Costs: ","Initial Training Costs: "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"U13","v":"Initial Personnel Costs: "},null,null,null,{"$f":"U14","v":0},null,null,null,null,{"$f":"'Type II Needs'!M26","v":214935.75},{"$f":"'Type II Needs'!M44","v":12260.4},{"$f":"'Type II Needs'!M79","v":27540}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"V13","v":"Initial Training Costs: "},null,null,null,{"$f":"V14","v":27540}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O18,O17,O13)","v":254736.15}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Operational Costs for POD Type II",null,null,null,null,null,null,null,{"$f":"O39","v":1806048}]
[]
[null,null,"Based on one deployment"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Operational POD Supplies Costs: ",null,null,null,{"$f":"T38","v":1665000},null,null,null,null,"Operational POD Supplies Costs:","Operational Personnel Costs"]
[null,null,null,null,null,null,null,null,null,null,"Operational Personnel Costs: ",null,null,null,{"$f":"U38","v":141048},null,null,null,null,{"$f":"'Type II Needs'!M59","v":1665000},{"$f":"'Type II Needs'!M70","v":141048}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O37:P38)","v":1806048}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Annual Costs for POD Type II"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loading Point Costs: ","POD Kit Costs: ","Operational POD Supplies Costs: ","Operational Personnel Costs: ","Annual Training Costs: "]
[null,null,null,null,null,null,null,null,null,null,"Annual Equipment Costs: ",null,null,null,{"$f":"J88","v":66920.13},null,null,null,null,null,{"$f":"Q99","v":64215.450000000004},{"$f":"Q112","v":2704.68},{"$f":"P71*O37","v":1665000},{"$f":"P71*O38","v":141048},{"$f":"J114","v":3060}]
[null,null,null,null,null,null,null,null,null,null,null,"Loading Point Costs: ",null,null,{"$f":"U60","v":64215.450000000004}]
[null,null,null,null,null,null,null,null,null,null,null,"POD Kit Costs: ",null,null,{"$f":"V60","v":2704.68}]
[null,null,null,null,null,null,null,null,null,null,"Operational POD Supplies Costs: ",null,null,null,{"$f":"W60","v":1665000}]
[null,null,null,null,null,null,null,null,null,null,"Operational Personnel Costs: ",null,null,null,{"$f":"X60","v":141048}]
[null,null,null,null,null,null,null,null,null,null,"Annual Training Costs: ",null,null,null,{"$f":"Y60","v":3060}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O60:P65)","v":1942948.26}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"How many times per year do you \nexpect to deploy PODs?",null,null,null,{"$f":"Deployed","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"This can be changed on the User Input page."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Annualized Cost Summary"]
[]
[]
[null,"Equipment Annualized Costs",null,null,null,null,null,null,null,{"$f":"SUM(Q99,Q112)","v":66920.13}]
[]
[null,null,null,null,null,null,"Quantity","Unit Cost","Initial Cost","Shelf Life","R-Cost","Energy","Operating","Repair","Upgrade","Annual Costs","Category Totals"]
["Loading Point",{"$f":"'Type II Needs'!B17:I17","v":"Forklifts"},null,null,null,null,{"$f":"'Type II Needs'!K17","v":6},{"$f":"'Type II Needs'!L17","v":25000},{"$f":"H91*G91","v":150000},10,{"$f":"I91/J91","v":15000},{"$f":"I91*0.1","v":15000},{"$f":"0.05*I91","v":7500},{"$f":"0.05*I91","v":7500},0,{"$f":"SUM(K91:O91)","v":45000}]
[null,{"$f":"'Type II Needs'!B18:I18","v":"Pallet Jacks"},null,null,null,null,{"$f":"'Type II Needs'!K18","v":6},{"$f":"'Type II Needs'!L18","v":365},{"$f":"H92*G92","v":2190},10,{"$f":"I92/J92","v":219},{"$f":"I92*0.1","v":219},{"$f":"0.05*I92","v":109.5},{"$f":"0.05*I92","v":109.5},0,{"$f":"SUM(K92:O92)","v":657}]
[null,{"$f":"'Type II Needs'!B19:I19","v":"Power Light Set"},null,null,null,null,{"$f":"'Type II Needs'!K19","v":3},{"$f":"'Type II Needs'!L19","v":11230},33690,10,3369,3369,1684.5,1684.5,0,10107]
[null,{"$f":"'Type II Needs'!B20:I20","v":"Toilets"},null,null,null,null,{"$f":"'Type II Needs'!K20","v":12},{"$f":"'Type II Needs'!L20","v":686},8232,10,823.2,0,0,411.6,0,1234.8000000000002]
[null,{"$f":"'Type II Needs'!B21:I21","v":"Tents"},null,null,null,null,{"$f":"'Type II Needs'!K21","v":6},{"$f":"'Type II Needs'!L21","v":595},3570,10,357,0,0,178.5,0,535.5]
[null,{"$f":"'Type II Needs'!B22:I22","v":"Dumpsters"},null,null,null,null,{"$f":"'Type II Needs'!K22","v":6},{"$f":"'Type II Needs'!L22","v":752},4512,10,451.2,0,0,225.60000000000002,0,676.8]
[null,{"$f":"'Type II Needs'!B23:I23","v":"Traffic cones"},null,null,null,null,{"$f":"'Type II Needs'!K23","v":45},{"$f":"'Type II Needs'!L23","v":27.15},1221.75,5,244.35,0,0,0,0,244.35]
[null,{"$f":"'Type II Needs'!B24:I24","v":"Two way radio"},null,null,null,null,{"$f":"'Type II Needs'!K24","v":0},{"$f":"'Type II Needs'!L24","v":250},0,5,0,0,0,0,0,0]
[null,{"$f":"'Type II Needs'!B25:I25","v":"Pallets"},null,null,null,null,{"$f":"'Type II Needs'!K25","v":1152},{"$f":"'Type II Needs'!L25","v":10},11520,2,5760,0,0,0,0,5760,{"$f":"SUM(P91:P99)","v":64215.450000000004}]
["POD Kit",{"$f":"'Type II Needs'!B31:I31","v":"96-gallon trash can"},null,null,null,null,{"$f":"'Type II Needs'!K31","v":6},{"$f":"'Type II Needs'!L31","v":90},540,5,108,0,0,0,0,108]
[null,{"$f":"'Type II Needs'!B32:I32","v":"Work gloves (pairs)"},null,null,null,null,{"$f":"'Type II Needs'!K32","v":96},{"$f":"'Type II Needs'!L32","v":2},192,5,38.4,0,0,0,0,38.4]
[null,{"$f":"'Type II Needs'!B33:I33","v":"Duct tape"},null,null,null,null,{"$f":"'Type II Needs'!K33","v":24},{"$f":"'Type II Needs'!L33","v":1},24,2,12,0,0,0,0,12]
[null,{"$f":"'Type II Needs'!B34:I34","v":"Flashlights"},null,null,null,null,{"$f":"'Type II Needs'!K34","v":120},{"$f":"'Type II Needs'!L34","v":20},2400,5,480,0,0,0,0,480]
[null,{"$f":"'Type II Needs'!B35:I35","v":"Batteries"},null,null,null,null,{"$f":"'Type II Needs'!K35","v":216},{"$f":"'Type II Needs'!L35","v":1.25},270,1,270,0,0,0,0,270]
[null,{"$f":"'Type II Needs'!B36:I36","v":"Reflective safety vests"},null,null,null,null,{"$f":"'Type II Needs'!K36","v":120},{"$f":"'Type II Needs'!L36","v":30},3600,5,720,0,0,0,0,720]
[null,{"$f":"'Type II Needs'!B37:I37","v":"First Aid kit"},null,null,null,null,{"$f":"'Type II Needs'!K37","v":6},{"$f":"'Type II Needs'!L37","v":40},240,5,48,0,0,0,{"$f":"0.05*I106","v":12},60]
[null,{"$f":"'Type II Needs'!B38:I38","v":"Traffic cones"},null,null,null,null,{"$f":"'Type II Needs'!K38","v":72},{"$f":"'Type II Needs'!L38","v":27.15},1954.8,5,390.96,0,0,0,0,390.96]
[null,{"$f":"'Type II Needs'!B39:I39","v":"Hard hats"},null,null,null,null,{"$f":"'Type II Needs'!K39","v":96},{"$f":"'Type II Needs'!L39","v":15.35},1473.6,5,294.71999999999997,0,0,0,0,294.71999999999997]
[null,{"$f":"'Type II Needs'!B40:I40","v":"Glow sticks (orange/red)"},null,null,null,null,{"$f":"'Type II Needs'!K40","v":180},{"$f":"'Type II Needs'!L40","v":1},180,2,90,0,0,0,0,90]
[null,{"$f":"'Type II Needs'!B41:I41","v":"Back support vest"},null,null,null,null,{"$f":"'Type II Needs'!K41","v":48},{"$f":"'Type II Needs'!L41","v":15},720,5,144,0,0,0,0,144]
[null,{"$f":"'Type II Needs'!B42:I42","v":"Fire extinguisher (5lb)"},null,null,null,null,{"$f":"'Type II Needs'!K42","v":6},{"$f":"'Type II Needs'!L42","v":61},366,10,36.6,0,0,0,0,36.6]
[null,{"$f":"'Type II Needs'!B43:I43","v":"Signage"},null,null,null,null,{"$f":"'Type II Needs'!K43","v":30},{"$f":"'Type II Needs'!L43","v":10},300,5,60,0,0,0,0,60,{"$f":"SUM(P100:P112)","v":2704.68}]
[]
[null,"Training Annualized Costs",null,null,null,null,null,null,null,{"$f":"SUM(P117:P119)","v":3060}]
[]
[null,null,null,null,null,null,"Quantity","Course Hours","Backfill Rate","Initial Cost","Shelf Life",null,null,null,null,"Annual Costs"]
[null,{"$f":"'Type II Needs'!B76:H76","v":"IS 100 - Introduction to ICS"},null,null,null,null,{"$f":"'Type II Needs'!K76","v":102},{"$f":"'Type II Needs'!I76","v":3},{"$f":"'Type II Needs'!L76","v":30},{"$f":"I117*H117*G117","v":9180},9,null,null,null,null,{"$f":"J117/K117","v":1020}]
[null,{"$f":"'Type II Needs'!B77:H77","v":"IS 200 - ICS for Single Resources and Initial Action Incidents"},null,null,null,null,{"$f":"'Type II Needs'!K77","v":102},{"$f":"'Type II Needs'!I77","v":3},{"$f":"'Type II Needs'!L77","v":30},{"$f":"I118*H118*G118","v":9180},9,null,null,null,null,{"$f":"J118/K118","v":1020}]
[null,{"$f":"'Type II Needs'!B78:H78","v":"IS 700 - NIMs"},null,null,null,null,{"$f":"'Type II Needs'!K78","v":102},{"$f":"'Type II Needs'!I78","v":3},{"$f":"'Type II Needs'!L78","v":30},9180,9,null,null,null,null,1020]

{"sheet":"Type III Needs","index":7,"n_rows":79,"n_cols":15,"rows_kept":79,"cut":false,"hidden":false,"merged":[[8,2,8,5],[8,7,8,10],[9,7,9,13],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[24,1,24,8],[14,1,15,8],[14,9,15,12],[14,14,15,17],[16,1,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[21,1,21,8],[22,1,22,8],[23,1,23,8],[39,1,39,8],[28,1,29,8],[28,9,29,12],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[34,1,34,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[46,11,47,12],[46,14,46,17],[47,14,57,17],[48,1,48,8],[49,1,49,8],[50,1,50,7],[55,1,55,7],[52,1,52,7],[53,1,53,7],[54,1,54,7],[40,1,40,8],[41,1,41,8],[42,1,42,8],[46,1,47,10],[50,8,51,8],[51,1,51,7],[72,9,73,12],[75,1,75,7],[56,1,56,7],[57,1,57,7],[61,1,62,8],[61,9,62,12],[64,1,64,7],[65,1,65,7],[76,1,76,7],[77,1,77,7],[66,1,66,7],[67,1,67,7],[68,1,68,7],[72,1,73,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Your capability need is",null,null,null,{"$f":"IF(InputPerNum=\"Percent\",'User Input'!L38,'User Input'!F48)","v":52},"Type III PODs, operating for",null,null,null,{"$f":"CONCATENATE(SUM('User Input'!I25:J25), \" days\")","v":"3 days"}]
[null,null,null,null,null,null,null,"You can adjust costs and quantities below to reflect your actual costs and needs."]
[]
[]
[null,null,null,null,null,null,null,null,null,"Default Quantities","Quantities","Unit Costs","Initial Cost"]
[]
[null,"Loading Point Equipment",null,null,null,null,null,null,null,{"$f":"M26","v":2158286},null,null,null,null,"For more information about a Type III POD…"]
[]
[null,"Forklifts",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L17","v":52},{"$f":"J17","v":52},25000,{"$f":"K17*L17","v":1300000}]
[null,"Pallet Jacks",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L18","v":52},52,365,{"$f":"K18*L18","v":18980}]
[null,"Power Light Set",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L19","v":52},52,11230,583960]
[null,"Toilets",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L20","v":104},104,686,71344]
[null,"Tents",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L21","v":52},52,595,30940]
[null,"Dumpsters",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L22","v":52},52,752,39104]
[null,"Traffic cones",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L23","v":520},520,27.15,14118]
[null,"Two way radio",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L24","v":0},0,250,0]
[null,"Pallets",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L25","v":9984},9984,10,99840]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M17:M25)","v":2158286}]
[]
[]
[null,"POD Kit",null,null,null,null,null,null,null,{"$f":"M44","v":106256.8}]
[]
[null,"96-gallon trash can",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L31","v":52},{"$f":"J31","v":52},90,{"$f":"K31*L31","v":4680}]
[null,"Work gloves (pairs)",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L32","v":832},832,2,{"$f":"K32*L32","v":1664}]
[null,"Duct tape",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L33","v":208},208,1,208]
[null,"Flashlights",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L34","v":1040},1040,20,20800]
[null,"Batteries",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L35","v":1872},1872,1.25,2340]
[null,"Reflective safety vests",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L36","v":1040},1040,30,31200]
[null,"First Aid kit",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L37","v":52},52,40,2080]
[null,"Traffic cones",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L38","v":624},624,27.15,16941.599999999999]
[null,"Hard hats",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L39","v":832},832,15.35,12771.199999999999]
[null,"Glow sticks (orange/red)",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L40","v":1560},1560,1,{"$f":"K40*L40","v":1560}]
[null,"Back support vest",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L41","v":416},416,15,6240]
[null,"Fire extinguisher (5lb)",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L42","v":52},52,61,3172]
[null,"Signage",null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*CostsQuants!L43","v":260},260,10,2600]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M31:M43)","v":106256.8}]
[]
[]
[null,"POD Supplies (if these supplies are donated/provided free of charge, change all prices to $0.00.)",null,null,null,null,null,null,null,null,null,{"$f":"M59","v":14430000},null,null,"How to add custom supplies"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\n1) Custom supplies can be added on the POD Type I Needs page, and will be filled in on this page automatically."]
[null,{"$f":"CostsQuants!A49","v":"Water (gallons) - 1 gallon per person daily"},null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*Days*CostsQuants!L49","v":780000},{"$f":"J49","v":780000},0.5,{"$f":"K49*L49","v":390000}]
[null,{"$f":"CostsQuants!A50","v":"Ice (pounds) - 8 lbs per person daily"},null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*Days*CostsQuants!L50","v":6240000},6240000,0.5,{"$f":"K50*L50","v":3120000}]
[null,{"$f":"CostsQuants!A51","v":"Meals-Ready-to-Eat - 2 per person daily"},null,null,null,null,null,null,"Custom Quantities",{"$f":"TypeIIIPODs*Days*CostsQuants!L51","v":1560000},1560000,2,3120000]
[null,{"$f":"CostsQuants!A52","v":"Tarps (20' x 25') - 1 per household, total"},null,null,null,null,null,null,null,{"$f":"TypeIIIPODs*Days*CostsQuants!L52","v":780000},780000,10,7800000]
[null,{"$f":"Custom1","v":"Custom Item - daily"},null,null,null,null,null,null,{"$f":"'Type I Needs'!I53","v":0},{"$f":"I53*TypeIIIPODs*Days*5000","v":0},{"$f":"J53","v":0},{"$f":"'Type I Needs'!L53","v":0},0]
[null,{"$f":"Custom2","v":"Custom Item - daily"},null,null,null,null,null,null,{"$f":"'Type I Needs'!I54","v":0},{"$f":"I54*TypeIIIPODs*Days*5000","v":0},0,{"$f":"'Type I Needs'!L54","v":0},0]
[null,{"$f":"Custom3","v":"Custom Item - daily"},null,null,null,null,null,null,{"$f":"'Type I Needs'!I55","v":0},{"$f":"I55*TypeIIIPODs*Days*5000","v":0},0,{"$f":"'Type I Needs'!L55","v":0},0]
[null,{"$f":"Custom4","v":"Custom Item - daily"},null,null,null,null,null,null,{"$f":"'Type I Needs'!I56","v":0},{"$f":"I56*TypeIIIPODs*Days*5000","v":0},0,{"$f":"'Type I Needs'!L56","v":0},0]
[null,{"$f":"Custom5","v":"Custom Item - once"},null,null,null,null,null,null,{"$f":"'Type I Needs'!I57","v":0},{"$f":"I57*TypeIIIPODs*5000","v":0},0,{"$f":"'Type I Needs'!L57","v":0},0]
[null,{"$f":"Custom6","v":"Custom Item - once"},null,null,null,null,null,null,{"$f":"'Type I Needs'!I58","v":0},{"$f":"I58*TypeIIIPODs*5000","v":0},0,{"$f":"'Type I Needs'!L58","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M49:M58)","v":14430000}]
[]
[]
[null,"Personnel",null,null,null,null,null,null,null,{"$f":"M70","v":1222416}]
[]
[null,null,null,null,null,null,null,null,"Hours Deployed","Default Quantities","Quantities","Backfill Rate","Operating Cost"]
[null,"POD Manager",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"TypeIIIPODs*CostsQuants!L65","v":0},{"$f":"J65","v":0},52,{"$f":"L65*K65*I65","v":0}]
[null,"Support Team Leader",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"TypeIIIPODs*CostsQuants!L66","v":52},52,45,{"$f":"L66*K66*I66","v":84240}]
[null,"Fork Lift Operator",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"TypeIIIPODs*CostsQuants!L67","v":104},104,45,168480]
[null,"Loading Point Labor",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"TypeIIIPODs*CostsQuants!L68","v":676},676,37,900432]
[null,"Pallet Jacks Labor",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},{"$f":"TypeIIIPODs*CostsQuants!L69","v":52},52,37,69264]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M65:M69)","v":1222416}]
[]
[]
[null,"Training",null,null,null,null,null,null,null,{"$f":"M79","v":238680}]
[]
[null,null,null,null,null,null,null,null,"Course Hours","Default Quantities","Quantities","Average Backfill Rate","Initial Cost"]
[null,"IS 100 - Introduction to ICS",null,null,null,null,null,null,3,{"$f":"SUM($J$65:$J$69)","v":884},{"$f":"J76","v":884},30,{"$f":"L76*K76*I76","v":79560}]
[null,"IS 200 - ICS for Single Resources and Initial Action Incidents",null,null,null,null,null,null,3,884,884,30,{"$f":"L77*K77*I77","v":79560}]
[null,"IS 700 - NIMs",null,null,null,null,null,null,3,884,884,30,79560]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M76:M78)","v":238680}]

{"sheet":"Type III Costs","index":8,"n_rows":119,"n_cols":25,"rows_kept":119,"cut":false,"hidden":false,"merged":[[113,9,114,16],[116,1,116,5],[117,1,117,5],[118,1,118,5],[107,1,107,5],[108,1,108,5],[109,1,109,5],[110,1,110,5],[111,1,111,5],[113,1,114,8],[106,1,106,5],[95,1,95,5],[96,1,96,5],[97,1,97,5],[98,1,98,5],[101,1,101,5],[102,1,102,5],[103,1,103,5],[104,1,104,5],[105,1,105,5],[99,0,100,0],[99,1,99,5],[100,1,100,5],[90,0,91,0],[90,1,90,5],[91,1,91,5],[92,1,92,5],[93,1,93,5],[94,1,94,5],[65,14,65,15],[70,11,71,14],[70,15,71,15],[84,1,85,8],[87,1,88,8],[87,9,88,16],[72,11,72,16],[62,10,62,13],[62,14,62,15],[63,10,63,13],[63,14,63,15],[64,10,64,13],[64,14,64,15],[59,10,59,13],[59,14,59,15],[60,11,60,13],[60,14,60,15],[61,11,61,13],[61,14,61,15],[55,1,56,8],[17,10,17,13],[17,14,17,15],[18,14,18,15],[31,1,32,8],[31,9,32,16],[33,2,33,4],[36,10,36,13],[36,14,36,15],[37,10,37,13],[37,14,37,15],[38,14,38,15],[14,11,14,13],[14,14,14,15],[15,11,15,13],[15,14,15,15],[16,10,16,13],[16,14,16,15],[8,1,9,8],[8,9,9,16],[12,10,12,13],[12,14,12,15],[13,11,13,13],[13,14,13,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Initial Costs for POD Type III",null,null,null,null,null,null,null,{"$f":"O19","v":2503222.7999999998}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Source Data to be Hidden"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"T13","v":"Initial Equipment Costs: "},null,null,null,{"$f":"T14","v":2264542.7999999998},null,null,null,null,"Initial Equipment Costs: ","Initial Personnel Costs: ","Initial Training Costs: "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"T16","v":"Loading Point Costs: "},null,null,{"$f":"T17","v":2158286},null,null,null,null,{"$f":"'Type III Needs'!M26+'Type III Needs'!M44","v":2264542.7999999998},0,{"$f":"'Type III Needs'!M79","v":238680}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"U16","v":"POD Kit Costs: "},null,null,{"$f":"U17","v":106256.8}]
[null,null,null,null,null,null,null,null,null,null,null,"POD Supplies Costs: ",null,null,0,null,null,null,null,"Loading Point Costs: ","POD Kit Costs: ","Initial Training Costs: "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"U13","v":"Initial Personnel Costs: "},null,null,null,{"$f":"U14","v":0},null,null,null,null,{"$f":"'Type III Needs'!M26","v":2158286},{"$f":"'Type III Needs'!M44","v":106256.8},{"$f":"'Type III Needs'!M79","v":238680}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"V13","v":"Initial Training Costs: "},null,null,null,{"$f":"V14","v":238680}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O18,O17,O13)","v":2503222.7999999998}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Operational Costs for POD Type III",null,null,null,null,null,null,null,{"$f":"O39","v":15652416}]
[]
[null,null,"Based on one deployment"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Operational POD Supplies Costs: ",null,null,null,{"$f":"T38","v":14430000},null,null,null,null,"Operational POD Supplies Costs:","Operational Personnel Costs"]
[null,null,null,null,null,null,null,null,null,null,"Operational Personnel Costs: ",null,null,null,{"$f":"U38","v":1222416},null,null,null,null,{"$f":"'Type III Needs'!M59","v":14430000},{"$f":"'Type III Needs'!M70","v":1222416}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O37:P38)","v":15652416}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Annual Costs for POD Type III"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loading Point Costs: ","POD Kit Costs: ","Operational POD Supplies Costs: ","Operational Personnel Costs: ","Annual Training Costs: "]
[null,null,null,null,null,null,null,null,null,null,"Annual Equipment Costs: ",null,null,null,{"$f":"J88","v":668274.36},null,null,null,null,null,{"$f":"Q99","v":644833.79999999993},{"$f":"Q112","v":23440.560000000001},{"$f":"P71*O37","v":14430000},{"$f":"P71*O38","v":1222416},{"$f":"J114","v":26520}]
[null,null,null,null,null,null,null,null,null,null,null,"Loading Point Costs: ",null,null,{"$f":"U60","v":644833.79999999993}]
[null,null,null,null,null,null,null,null,null,null,null,"POD Kit Costs: ",null,null,{"$f":"V60","v":23440.560000000001}]
[null,null,null,null,null,null,null,null,null,null,"Operational POD Supplies Costs: ",null,null,null,{"$f":"W60","v":14430000}]
[null,null,null,null,null,null,null,null,null,null,"Operational Personnel Costs: ",null,null,null,{"$f":"X60","v":1222416}]
[null,null,null,null,null,null,null,null,null,null,"Annual Training Costs: ",null,null,null,{"$f":"Y60","v":26520}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O60:P65)","v":17015484.719999999}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"How many times per year do you \nexpect to deploy PODs?",null,null,null,{"$f":"Deployed","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"This can be changed on the User Input page."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Annualized Cost Summary"]
[]
[]
[null,"Equipment Annualized Costs",null,null,null,null,null,null,null,{"$f":"SUM(Q99,Q112)","v":668274.36}]
[]
[null,null,null,null,null,null,"Quantity","Unit Cost","Initial Cost","Shelf Life","R-Cost","Energy","Operating","Repair","Upgrade","Annual Costs","Category Totals"]
["Loading Point",{"$f":"'Type III Needs'!B17:I17","v":"Forklifts"},null,null,null,null,{"$f":"'Type III Needs'!K17","v":52},{"$f":"'Type III Needs'!L17","v":25000},{"$f":"H91*G91","v":1300000},10,{"$f":"I91/J91","v":130000},{"$f":"I91*0.1","v":130000},{"$f":"0.05*I91","v":65000},{"$f":"0.05*I91","v":65000},0,{"$f":"SUM(K91:O91)","v":390000}]
[null,{"$f":"'Type III Needs'!B18:I18","v":"Pallet Jacks"},null,null,null,null,{"$f":"'Type III Needs'!K18","v":52},{"$f":"'Type III Needs'!L18","v":365},{"$f":"H92*G92","v":18980},10,{"$f":"I92/J92","v":1898},{"$f":"I92*0.1","v":1898},{"$f":"0.05*I92","v":949},{"$f":"0.05*I92","v":949},0,{"$f":"SUM(K92:O92)","v":5694}]
[null,{"$f":"'Type III Needs'!B19:I19","v":"Power Light Set"},null,null,null,null,{"$f":"'Type III Needs'!K19","v":52},{"$f":"'Type III Needs'!L19","v":11230},583960,10,58396,58396,29198,29198,0,175188]
[null,{"$f":"'Type III Needs'!B20:I20","v":"Toilets"},null,null,null,null,{"$f":"'Type III Needs'!K20","v":104},{"$f":"'Type III Needs'!L20","v":686},71344,10,7134.4,0,0,3567.2000000000003,0,10701.6]
[null,{"$f":"'Type III Needs'!B21:I21","v":"Tents"},null,null,null,null,{"$f":"'Type III Needs'!K21","v":52},{"$f":"'Type III Needs'!L21","v":595},30940,10,3094,0,0,1547,0,4641]
[null,{"$f":"'Type III Needs'!B22:I22","v":"Dumpsters"},null,null,null,null,{"$f":"'Type III Needs'!K22","v":52},{"$f":"'Type III Needs'!L22","v":752},39104,10,3910.4,0,0,1955.2,0,5865.6]
[null,{"$f":"'Type III Needs'!B23:I23","v":"Traffic cones"},null,null,null,null,{"$f":"'Type III Needs'!K23","v":520},{"$f":"'Type III Needs'!L23","v":27.15},14118,5,2823.6,0,0,0,0,2823.6]
[null,{"$f":"'Type III Needs'!B24:I24","v":"Two way radio"},null,null,null,null,{"$f":"'Type III Needs'!K24","v":0},{"$f":"'Type III Needs'!L24","v":250},0,5,0,0,0,0,0,0]
[null,{"$f":"'Type III Needs'!B25:I25","v":"Pallets"},null,null,null,null,{"$f":"'Type III Needs'!K25","v":9984},{"$f":"'Type III Needs'!L25","v":10},99840,2,49920,0,0,0,0,49920,{"$f":"SUM(P91:P99)","v":644833.79999999993}]
["POD Kit",{"$f":"'Type III Needs'!B31:I31","v":"96-gallon trash can"},null,null,null,null,{"$f":"'Type III Needs'!K31","v":52},{"$f":"'Type III Needs'!L31","v":90},4680,5,936,0,0,0,0,936]
[null,{"$f":"'Type III Needs'!B32:I32","v":"Work gloves (pairs)"},null,null,null,null,{"$f":"'Type III Needs'!K32","v":832},{"$f":"'Type III Needs'!L32","v":2},1664,5,332.8,0,0,0,0,332.8]
[null,{"$f":"'Type III Needs'!B33:I33","v":"Duct tape"},null,null,null,null,{"$f":"'Type III Needs'!K33","v":208},{"$f":"'Type III Needs'!L33","v":1},208,2,104,0,0,0,0,104]
[null,{"$f":"'Type III Needs'!B34:I34","v":"Flashlights"},null,null,null,null,{"$f":"'Type III Needs'!K34","v":1040},{"$f":"'Type III Needs'!L34","v":20},20800,5,4160,0,0,0,0,4160]
[null,{"$f":"'Type III Needs'!B35:I35","v":"Batteries"},null,null,null,null,{"$f":"'Type III Needs'!K35","v":1872},{"$f":"'Type III Needs'!L35","v":1.25},2340,1,2340,0,0,0,0,2340]
[null,{"$f":"'Type III Needs'!B36:I36","v":"Reflective safety vests"},null,null,null,null,{"$f":"'Type III Needs'!K36","v":1040},{"$f":"'Type III Needs'!L36","v":30},31200,5,6240,0,0,0,0,6240]
[null,{"$f":"'Type III Needs'!B37:I37","v":"First Aid kit"},null,null,null,null,{"$f":"'Type III Needs'!K37","v":52},{"$f":"'Type III Needs'!L37","v":40},2080,5,416,0,0,0,{"$f":"0.05*I106","v":104},520]
[null,{"$f":"'Type III Needs'!B38:I38","v":"Traffic cones"},null,null,null,null,{"$f":"'Type III Needs'!K38","v":624},{"$f":"'Type III Needs'!L38","v":27.15},16941.599999999999,5,3388.3199999999997,0,0,0,0,3388.3199999999997]
[null,{"$f":"'Type III Needs'!B39:I39","v":"Hard hats"},null,null,null,null,{"$f":"'Type III Needs'!K39","v":832},{"$f":"'Type III Needs'!L39","v":15.35},12771.199999999999,5,2554.2399999999998,0,0,0,0,2554.2399999999998]
[null,{"$f":"'Type III Needs'!B40:I40","v":"Glow sticks (orange/red)"},null,null,null,null,{"$f":"'Type III Needs'!K40","v":1560},{"$f":"'Type III Needs'!L40","v":1},1560,2,780,0,0,0,0,780]
[null,{"$f":"'Type III Needs'!B41:I41","v":"Back support vest"},null,null,null,null,{"$f":"'Type III Needs'!K41","v":416},{"$f":"'Type III Needs'!L41","v":15},6240,5,1248,0,0,0,0,1248]
[null,{"$f":"'Type III Needs'!B42:I42","v":"Fire extinguisher (5lb)"},null,null,null,null,{"$f":"'Type III Needs'!K42","v":52},{"$f":"'Type III Needs'!L42","v":61},3172,10,317.2,0,0,0,0,317.2]
[null,{"$f":"'Type III Needs'!B43:I43","v":"Signage"},null,null,null,null,{"$f":"'Type III Needs'!K43","v":260},{"$f":"'Type III Needs'!L43","v":10},2600,5,520,0,0,0,0,520,{"$f":"SUM(P100:P112)","v":23440.560000000001}]
[]
[null,"Training Annualized Costs",null,null,null,null,null,null,null,{"$f":"SUM(P117:P119)","v":26520}]
[]
[null,null,null,null,null,null,"Quantity","Course Hours","Backfill Rate","Initial Cost","Shelf Life",null,null,null,null,"Annual Costs"]
[null,{"$f":"'Type III Needs'!B76:H76","v":"IS 100 - Introduction to ICS"},null,null,null,null,{"$f":"'Type III Needs'!K76","v":884},{"$f":"'Type III Needs'!I76","v":3},{"$f":"'Type III Needs'!L76","v":30},{"$f":"I117*H117*G117","v":79560},9,null,null,null,null,{"$f":"J117/K117","v":8840}]
[null,{"$f":"'Type III Needs'!B77:H77","v":"IS 200 - ICS for Single Resources and Initial Action Incidents"},null,null,null,null,{"$f":"'Type III Needs'!K77","v":884},{"$f":"'Type III Needs'!I77","v":3},{"$f":"'Type III Needs'!L77","v":30},{"$f":"I118*H118*G118","v":79560},9,null,null,null,null,{"$f":"J118/K118","v":8840}]
[null,{"$f":"'Type III Needs'!B78:H78","v":"IS 700 - NIMs"},null,null,null,null,{"$f":"'Type III Needs'!K78","v":884},{"$f":"'Type III Needs'!I78","v":3},{"$f":"'Type III Needs'!L78","v":30},79560,9,null,null,null,null,8840]

{"sheet":"Initial Costs","index":9,"n_rows":129,"n_cols":20,"rows_kept":129,"cut":false,"hidden":false,"merged":[[124,2,124,8],[125,2,125,8],[126,2,126,8],[127,2,127,8],[128,2,128,8],[118,2,118,9],[119,2,119,9],[120,2,120,9],[121,2,122,9],[121,10,122,13],[113,2,113,9],[114,2,114,9],[115,2,115,9],[116,2,116,9],[117,2,117,9],[111,2,111,9],[112,2,112,9],[100,10,101,13],[103,2,103,8],[104,2,104,8],[105,2,105,8],[108,2,109,9],[108,10,109,13],[100,2,101,9],[95,2,95,9],[96,2,96,9],[97,2,97,9],[98,2,98,9],[99,2,99,9],[94,2,94,9],[83,2,83,9],[84,2,84,9],[85,2,86,9],[85,10,86,13],[87,2,87,9],[88,2,88,9],[89,2,89,9],[90,2,90,9],[91,2,91,9],[92,2,92,9],[93,2,93,9],[82,2,82,9],[54,12,54,13],[70,1,71,8],[70,9,71,14],[74,2,75,9],[74,10,75,13],[76,2,76,9],[60,9,60,14],[77,2,77,9],[78,2,78,9],[79,2,79,9],[80,2,80,9],[81,2,81,9],[47,1,48,8],[47,9,48,14],[53,9,53,11],[52,9,52,11],[53,12,53,13],[52,12,52,13],[8,1,9,8],[8,9,9,14],[11,2,11,5],[11,6,11,7],[58,9,59,12],[58,13,59,13],[13,2,13,6],[25,1,26,8],[25,9,26,14],[32,9,32,11],[31,9,31,11],[30,9,30,11],[32,12,32,13],[31,12,31,13],[30,12,30,13],[33,12,33,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input Summary"]
[]
[]
[null,null,"Total population to be served with PODs: ",null,null,null,{"$f":"SUM('User Input'!H17:I17)","v":225000}]
[]
[null,null,"POD Type Distribution:"]
[null,null,null,null,"Type I",null,{"$f":"TypeIPODs","v":4}]
[null,null,null,null,"Type II",null,{"$f":"TypeIIPODs","v":3}]
[null,null,null,null,"Type III",null,{"$f":"TypeIIIPODs","v":52}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Initial Cost Breakdown"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Equipment Costs: ",null,null,{"$f":"S32","v":2989887.3499999996},null,null,null,null,null,"Equipment Costs:","Training Costs:"]
[null,null,null,null,null,null,null,null,null,"Personnel Costs: ",null,null,0,null,null,null,null,null,{"$f":"SUM('Type I Costs'!O13:P13,'Type II Costs'!O13:P13,'Type III Costs'!O13:P13)","v":2989887.3499999996},{"$f":"SUM('Type I Costs'!O18:P18,'Type II Costs'!O18:P18,'Type III Costs'!O18:P18)","v":337500}]
[null,null,null,null,null,null,null,null,null,"Training Costs: ",null,null,{"$f":"T32","v":337500}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M31:N33)","v":3327387.3499999996}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Operational Cost Breakdown"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POD Supplies Costs:","Personnel Costs:"]
[null,null,null,null,null,null,null,null,null,"POD Supplies Costs:",null,null,{"$f":"S53","v":20535000},null,null,null,null,null,{"$f":"SUM('Type I Costs'!O37:P37,'Type II Costs'!O37:P37,'Type III Costs'!O37:P37)","v":20535000},{"$f":"SUM('Type I Costs'!O38:P38,'Type II Costs'!O38:P38,'Type III Costs'!O38:P38)","v":1726488}]
[null,null,null,null,null,null,null,null,null,"Personnel Costs:",null,null,{"$f":"T53","v":1726488}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M53:N54)","v":22261488}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"How many times per year do you \nexpect to deploy PODs?",null,null,null,{"$f":"Deployed","v":1}]
[]
[null,null,null,null,null,null,null,null,null,"This can be changed on the User Input page."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Detailed Cost Breakdown"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Quantity","Cost","Initial Cost"]
[null,null,"Loading Point Equipment (Initial Cost)",null,null,null,null,null,null,null,{"$f":"SUM(M77:M85)","v":2838675.75}]
[]
[null,null,"Forklifts",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J17,'Type II Needs'!J17,'Type III Needs'!J17)","v":70},{"$f":"'Type I Needs'!L17","v":25000},{"$f":"L77*K77","v":1750000}]
[null,null,"Pallet Jacks",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J18,'Type II Needs'!J18,'Type III Needs'!J18)","v":70},{"$f":"'Type I Needs'!L18","v":365},{"$f":"L78*K78","v":25550}]
[null,null,"Power Light Set",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J19,'Type II Needs'!J19,'Type III Needs'!J19)","v":63},{"$f":"'Type I Needs'!L19","v":11230},{"$f":"L79*K79","v":707490}]
[null,null,"Toilets",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J20,'Type II Needs'!J20,'Type III Needs'!J20)","v":140},{"$f":"'Type I Needs'!L20","v":686},96040]
[null,null,"Tents",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J21,'Type II Needs'!J21,'Type III Needs'!J21)","v":66},{"$f":"'Type I Needs'!L21","v":595},39270]
[null,null,"Dumpsters",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J22,'Type II Needs'!J22,'Type III Needs'!J22)","v":74},{"$f":"'Type I Needs'!L22","v":752},55648]
[null,null,"Traffic cones",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J23,'Type II Needs'!J23,'Type III Needs'!J23)","v":685},{"$f":"'Type I Needs'!L23","v":27.15},18597.75]
[null,null,"Two way radio",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J24,'Type II Needs'!J24,'Type III Needs'!J24)","v":16},{"$f":"'Type I Needs'!L24","v":250},4000]
[null,null,"Pallets",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J25,'Type II Needs'!J25,'Type III Needs'!J25)","v":14208},{"$f":"'Type I Needs'!L25","v":10},142080]
[null,null,"POD Kit Equipment (Initial Cost)",null,null,null,null,null,null,null,{"$f":"SUM(M88:M100)","v":151211.6}]
[]
[null,null,"96-gallon trash can",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J31,'Type II Needs'!J31,'Type III Needs'!J31)","v":74},{"$f":"'Type I Needs'!L31","v":90},{"$f":"L88*K88","v":6660}]
[null,null,"Work gloves (pairs)",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J32,'Type II Needs'!J32,'Type III Needs'!J32)","v":1184},{"$f":"'Type I Needs'!L32","v":2},{"$f":"L89*K89","v":2368}]
[null,null,"Duct tape",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J33,'Type II Needs'!J33,'Type III Needs'!J33)","v":296},{"$f":"'Type I Needs'!L33","v":1},296]
[null,null,"Flashlights",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J34,'Type II Needs'!J34,'Type III Needs'!J34)","v":1480},{"$f":"'Type I Needs'!L34","v":20},29600]
[null,null,"Batteries",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J35,'Type II Needs'!J35,'Type III Needs'!J35)","v":2664},{"$f":"'Type I Needs'!L35","v":1.25},3330]
[null,null,"Reflective safety vests",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J36,'Type II Needs'!J36,'Type III Needs'!J36)","v":1480},{"$f":"'Type I Needs'!L36","v":30},44400]
[null,null,"First Aid kit",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J37,'Type II Needs'!J37,'Type III Needs'!J37)","v":74},{"$f":"'Type I Needs'!L37","v":40},2960]
[null,null,"Traffic cones",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J38,'Type II Needs'!J38,'Type III Needs'!J38)","v":888},{"$f":"'Type I Needs'!L38","v":27.15},24109.199999999997]
[null,null,"Hard hats",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J39,'Type II Needs'!J39,'Type III Needs'!J39)","v":1184},{"$f":"'Type I Needs'!L39","v":15.35},18174.399999999998]
[null,null,"Glow sticks (orange/red)",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J40,'Type II Needs'!J40,'Type III Needs'!J40)","v":2220},{"$f":"'Type I Needs'!L40","v":1},2220]
[null,null,"Back support vest",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J41,'Type II Needs'!J41,'Type III Needs'!J41)","v":592},{"$f":"'Type I Needs'!L41","v":15},8880]
[null,null,"Fire extinguisher (5lb)",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J42,'Type II Needs'!J42,'Type III Needs'!J42)","v":74},{"$f":"'Type I Needs'!L42","v":61},4514]
[null,null,"Signage",null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!J43,'Type II Needs'!J43,'Type III Needs'!J43)","v":370},{"$f":"'Type I Needs'!L43","v":10},3700]
[null,null,"Training (Initial Cost)",null,null,null,null,null,null,null,{"$f":"SUM(M104:M106)","v":337500}]
[]
[null,null,null,null,null,null,null,null,null,"Course Hours","Quantity","Backfill Rate","Initial Cost"]
[null,null,"IS 100 - Introduction to ICS",null,null,null,null,null,null,{"$f":"'Type I Needs'!I76","v":3},{"$f":"SUM('Type I Needs'!K76,'Type II Needs'!K76,'Type III Needs'!K76)","v":1250},{"$f":"'Type I Needs'!L76","v":30},{"$f":"L104*K104*J104","v":112500}]
[null,null,"IS 200 - ICS for Single Resources and Initial Action Incidents",null,null,null,null,null,null,{"$f":"'Type I Needs'!I77","v":3},{"$f":"SUM('Type I Needs'!K77,'Type II Needs'!K77,'Type III Needs'!K77)","v":1250},{"$f":"'Type I Needs'!L77","v":30},{"$f":"L105*K105*J105","v":112500}]
[null,null,"IS 700 - NIMs",null,null,null,null,null,null,{"$f":"'Type I Needs'!I78","v":3},{"$f":"SUM('Type I Needs'!K78,'Type II Needs'!K78,'Type III Needs'!K78)","v":1250},{"$f":"'Type I Needs'!L78","v":30},112500]
[]
[]
[null,null,"POD Supplies (Operational Cost)",null,null,null,null,null,null,null,{"$f":"SUM(M112:M121)","v":20535000}]
[]
[null,null,null,null,null,null,null,null,null,null,"Quantity","Cost","Initial Cost"]
[null,null,{"$f":"CostsQuants!A49","v":"Water (gallons) - 1 gallon per person daily"},null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!K49,'Type II Needs'!K49,'Type III Needs'!K49)","v":1110000},{"$f":"'Type I Needs'!L49","v":0.5},{"$f":"L112*K112","v":555000}]
[null,null,{"$f":"CostsQuants!A50","v":"Ice (pounds) - 8 lbs per person daily"},null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!K50,'Type II Needs'!K50,'Type III Needs'!K50)","v":8880000},{"$f":"'Type I Needs'!L50","v":0.5},{"$f":"L113*K113","v":4440000}]
[null,null,{"$f":"CostsQuants!A51","v":"Meals-Ready-to-Eat - 2 per person daily"},null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!K51,'Type II Needs'!K51,'Type III Needs'!K51)","v":2220000},{"$f":"'Type I Needs'!L51","v":2},4440000]
[null,null,{"$f":"CostsQuants!A52","v":"Tarps (20' x 25') - 1 per household, total"},null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!K52,'Type II Needs'!K52,'Type III Needs'!K52)","v":1110000},{"$f":"'Type I Needs'!L52","v":10},11100000]
[null,null,{"$f":"Custom1","v":"Custom Item - daily"},null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!K53,'Type II Needs'!K53,'Type III Needs'!K53)","v":0},{"$f":"'Type I Needs'!L53","v":0},0]
[null,null,{"$f":"Custom2","v":"Custom Item - daily"},null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!K54,'Type II Needs'!K54,'Type III Needs'!K54)","v":0},{"$f":"'Type I Needs'!L54","v":0},0]
[null,null,{"$f":"Custom3","v":"Custom Item - daily"},null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!K55,'Type II Needs'!K55,'Type III Needs'!K55)","v":0},{"$f":"'Type I Needs'!L55","v":0},0]
[null,null,{"$f":"Custom4","v":"Custom Item - daily"},null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!K56,'Type II Needs'!K56,'Type III Needs'!K56)","v":0},{"$f":"'Type I Needs'!L56","v":0},0]
[null,null,{"$f":"Custom5","v":"Custom Item - once"},null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!K57,'Type II Needs'!K57,'Type III Needs'!K57)","v":0},{"$f":"'Type I Needs'!L57","v":0},0]
[null,null,{"$f":"Custom6","v":"Custom Item - once"},null,null,null,null,null,null,null,{"$f":"SUM('Type I Needs'!K58,'Type II Needs'!K58,'Type III Needs'!K58)","v":0},{"$f":"'Type I Needs'!L58","v":0},0]
[null,null,"Personnel (Operational Cost)",null,null,null,null,null,null,null,{"$f":"SUM(M125:M129)","v":1726488}]
[]
[null,null,null,null,null,null,null,null,null,"Hours Deployed","Quantity","Backfill Rate","Initial Cost"]
[null,null,"POD Manager",null,null,null,null,null,null,{"$f":"'Type I Needs'!I65","v":36},{"$f":"'Type I Needs'!K65+'Type II Needs'!K65+'Type III Needs'!K65","v":4},{"$f":"'Type I Needs'!L65","v":52},{"$f":"L125*K125*J125","v":7488}]
[null,null,"Support Team Leader",null,null,null,null,null,null,{"$f":"'Type I Needs'!I66","v":36},{"$f":"'Type I Needs'!K66+'Type II Needs'!K66+'Type III Needs'!K66","v":73},{"$f":"'Type I Needs'!L66","v":45},{"$f":"L126*K126*J126","v":118260}]
[null,null,"Fork Lift Operator",null,null,null,null,null,null,{"$f":"'Type I Needs'!I67","v":36},{"$f":"'Type I Needs'!K67+'Type II Needs'!K67+'Type III Needs'!K67","v":133},{"$f":"'Type I Needs'!L67","v":45},215460]
[null,null,"Loading Point Labor",null,null,null,null,null,null,{"$f":"'Type I Needs'!I68","v":36},{"$f":"'Type I Needs'!K68+'Type II Needs'!K68+'Type III Needs'!K68","v":973},{"$f":"'Type I Needs'!L68","v":37},1296036]
[null,null,"Pallet Jacks Labor",null,null,null,null,null,null,{"$f":"'Type I Needs'!I69","v":36},{"$f":"'Type I Needs'!K69+'Type II Needs'!K69+'Type III Needs'!K69","v":67},{"$f":"'Type I Needs'!L69","v":37},89244]

{"sheet":"Annual Costs","index":10,"n_rows":63,"n_cols":22,"rows_kept":63,"cut":false,"hidden":false,"merged":[[25,1,26,8],[25,9,26,14],[50,9,50,12],[52,10,52,12],[8,1,9,8],[8,9,9,14],[11,2,11,5],[11,6,11,7],[13,2,13,6],[29,9,29,11],[33,10,33,12],[32,10,32,12],[31,10,31,12],[30,10,30,12],[60,9,61,12],[60,13,61,13],[62,9,62,14],[51,9,51,12],[54,9,54,12],[55,9,55,12],[56,9,56,12],[53,10,53,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Input Summary"]
[]
[]
[null,null,"Total population to be served with PODs: ",null,null,null,{"$f":"SUM('User Input'!H17:I17)","v":225000}]
[]
[null,null,"POD Type Distribution:"]
[null,null,null,null,"Type I",null,{"$f":"TypeIPODs","v":4}]
[null,null,null,null,"Type II",null,{"$f":"TypeIIPODs","v":3}]
[null,null,null,null,"Type III",null,{"$f":"TypeIIIPODs","v":52}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Annual Costs Summary"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Without deployment costs…",null,null,null,null,null,null,null,"Equipment"]
[null,null,null,null,null,null,null,null,null,null," Annual Equipment Costs: ",null,null,{"$f":"SUM(N32:N33)","v":882472.97},null,null,null,"Loading Point Equipment Costs: ","POD Kit Costs: ","Training Costs: "]
[null,null,null,null,null,null,null,null,null,null,"Loading Point Costs: ",null,null,{"$f":"R32","v":849115.25},null,null,null,{"$f":"SUM('Type I Costs'!O61:P61,'Type II Costs'!O61:P61,'Type III Costs'!O61:P61)","v":849115.25},{"$f":"SUM('Type I Costs'!O62:P62,'Type II Costs'!O62:P62,'Type III Costs'!O62:P62)","v":33357.72},{"$f":"SUM('Type I Costs'!O65:P65,'Type II Costs'!O65:P65,'Type III Costs'!O65:P65)","v":37500}]
[null,null,null,null,null,null,null,null,null,null,"POD Kit Costs: ",null,null,{"$f":"S32","v":33357.72}]
[null,null,null,null,null,null,null,null,null,null,"Annual Training Costs: ",null,null,{"$f":"T32","v":37500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N34,N31)","v":919972.97}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Including deployment costs…"]
[null,null,null,null,null,null,null,null,null,"Annual Equipment Costs: ",null,null,null,{"$f":"SUM(N53:N54)","v":882472.97}]
[null,null,null,null,null,null,null,null,null,null,"Loading Point Costs: ",null,null,{"$f":"R55","v":849115.25}]
[null,null,null,null,null,null,null,null,null,null,"POD Kit Costs: ",null,null,{"$f":"S55","v":33357.72},null,null,null,"Loading Point Equipment Costs: ","POD Kit Costs: ","POD Supplies Costs:","Personnel Costs:","Training Costs: "]
[null,null,null,null,null,null,null,null,null,"Operational POD Supplies Costs: ",null,null,null,{"$f":"T55","v":20535000},null,null,null,{"$f":"SUM('Type I Costs'!O61:P61,'Type II Costs'!O61:P61,'Type III Costs'!O61:P61)","v":849115.25},{"$f":"SUM('Type I Costs'!O62:P62,'Type II Costs'!O62:P62,'Type III Costs'!O62:P62)","v":33357.72},{"$f":"SUM('Type I Costs'!O63:P63,'Type II Costs'!O63:P63,'Type III Costs'!O63:P63)","v":20535000},{"$f":"SUM('Type I Costs'!O64:P64,'Type II Costs'!O64:P64,'Type III Costs'!O64:P64)","v":1726488},{"$f":"SUM('Type I Costs'!O65:P65,'Type II Costs'!O65:P65,'Type III Costs'!O65:P65)","v":37500}]
[null,null,null,null,null,null,null,null,null,"Operational Personnel Costs: ",null,null,null,{"$f":"U55","v":1726488}]
[null,null,null,null,null,null,null,null,null,"Annual Training Costs: ",null,null,null,{"$f":"V55","v":37500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N57,N56,N55,N52)","v":23181460.969999999}]
[]
[]
[null,null,null,null,null,null,null,null,null,"How many times per year do you \nexpect to deploy PODs?",null,null,null,{"$f":"Deployed","v":1}]
[]
[null,null,null,null,null,null,null,null,null,"This can be changed on the User Input page."]

{"sheet":"Gap Costs","index":11,"n_rows":77,"n_cols":22,"rows_kept":77,"cut":false,"hidden":false,"merged":[[29,9,29,11],[9,1,10,8],[12,2,12,5],[12,6,12,9],[12,10,12,13],[9,9,10,14],[21,1,22,8],[21,9,22,14],[26,9,26,11],[27,9,27,11],[28,9,28,11],[25,9,25,11],[26,12,26,13],[27,2,31,7],[27,12,27,13],[28,12,28,13],[43,9,43,13],[29,12,29,13],[30,12,30,13],[70,13,70,14],[74,9,75,12],[74,13,75,13],[69,13,69,14],[48,12,48,13],[47,9,47,11],[44,12,44,13],[45,12,45,13],[46,12,46,13],[47,12,47,13],[44,9,44,11],[45,9,45,11],[46,9,46,11],[76,9,76,14],[63,9,63,13],[64,9,64,12],[65,9,65,12],[66,9,66,12],[67,9,67,12],[68,9,68,12],[69,9,69,12],[64,13,64,14],[65,13,65,14],[66,13,66,14],[67,13,67,14],[68,13,68,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Gap Calculation"]
[]
[]
[null,null,"Suggested Number of PODs by Type",null,null,null,"Current PODs by Type",null,null,null,"Difference Between Current and Suggested",null,null,null,null,null,null,null,null,"Effective Gap"]
[null,null,null,"Type I",{"$f":"TypeIPODs","v":4},null,null,"Type I",0,null,null,"Type I",{"$f":"I14-E14","v":-4},null,null,null,null,null,null,{"$f":"IF(M14<=0,ABS(M14),0)","v":4}]
[null,null,null,"Type II",{"$f":"TypeIIPODs","v":3},null,null,"Type II",1,null,null,"Type II",{"$f":"I15-E15","v":-2},null,null,null,null,null,null,{"$f":"IF(M15<=0,ABS(M15),0)","v":2}]
[null,null,null,"Type III",{"$f":"TypeIIIPODs","v":52},null,null,"Type III",4,null,null,"Type III",-48,null,null,null,null,null,null,48]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Effective Gap",{"$f":"T14","v":4},{"$f":"T15","v":2},{"$f":"T16","v":48}]
[]
[]
[]
[null,"Gap Costs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type I","Type II","Type III"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loading Point",{"$f":"'Type I Needs'!M26/TypeIPODs","v":116363.5},{"$f":"'Type II Needs'!M26/TypeIIPODs","v":71645.25},{"$f":"'Type III Needs'!M26/TypeIIIPODs","v":41505.5}]
[null,null,null,null,null,null,null,null,null,"Initial Investment Costs",null,null,null,null,null,null,null,"POD Kit",{"$f":"'Type I Needs'!M44/TypeIPODs","v":8173.5999999999995},{"$f":"'Type II Needs'!M44/TypeIIPODs","v":4086.7999999999997},{"$f":"'Type III Needs'!M44/TypeIIIPODs","v":2043.4}]
[null,null,null,null,null,null,null,null,null,"Equipment Costs: ",null,null,{"$f":"SUM(M28:N29)","v":2739959.7},null,null,null,null,"Training",{"$f":"'Type I Needs'!M79/TypeIPODs","v":17820},{"$f":"'Type II Needs'!M79/TypeIIPODs","v":9180},{"$f":"'Type III Needs'!M79/TypeIIIPODs","v":4590}]
[null,null,{"$f":"IF(AND(N26>=0,N27>=0,N28>=0), \"Your suggest capability and current capability are equal, or your current capability is higher than the suggested capability, so you have no gap.  Thus there are no associated costs.\",\"\")","v":"Your suggest capability and current capability are equal, or your current capability is higher than the suggested capability, so you have no gap.  Thus there are no associated costs."},null,null,null,null,null,null,"Loading Point Costs: ",null,null,{"$f":"R32","v":2601008.5}]
[null,null,null,null,null,null,null,null,null,"POD Kit Costs: ",null,null,{"$f":"S32","v":138951.20000000001}]
[null,null,null,null,null,null,null,null,null,"Training Costs: ",null,null,{"$f":"T32","v":309960},null,null,null,null,"For chart"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M30,M27)","v":3049919.7},null,null,null,null,"Loading Point Equipment Costs:","POD Kit Costs: ","Training Costs:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(S18:U18,S25:U25)","v":2601008.5},{"$f":"SUMPRODUCT(S18:U18,S26:U26)","v":138951.20000000001},{"$f":"SUMPRODUCT(S18:U18,S27:U27)","v":309960}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Annual Costs (Without Deployment)"]
[null,null,null,null,null,null,null,null,null,"Equipment Costs: ",null,null,{"$f":"SUM(M46:N47)","v":808760.54},null,null,null,null,null,"Type I","Type II","Type III"]
[null,null,null,null,null,null,null,null,null,"Loading Point Costs: ",null,null,{"$f":"R55","v":778107.5},null,null,null,null,"Loading Point",{"$f":"'Type I Costs'!Q99/TypeIPODs","v":35016.5},{"$f":"'Type II Costs'!Q99/TypeIIPODs","v":21405.15},{"$f":"'Type III Costs'!Q99/TypeIIIPODs","v":12400.649999999998}]
[null,null,null,null,null,null,null,null,null,"POD Kit Costs: ",null,null,{"$f":"S55","v":30653.040000000001},null,null,null,null,"POD Kit",{"$f":"'Type I Costs'!Q112/TypeIPODs","v":1803.12},{"$f":"'Type II Costs'!Q112/TypeIIPODs","v":901.56},{"$f":"'Type III Costs'!Q112/TypeIIIPODs","v":450.78000000000003}]
[null,null,null,null,null,null,null,null,null,"Training Costs: ",null,null,{"$f":"T55","v":34440},null,null,null,null,"POD Supplies",{"$f":"SUM('Type I Costs'!O63:P63)/TypeIPODs","v":1110000},{"$f":"SUM('Type II Costs'!O63:P63)/TypeIIPODs","v":555000},{"$f":"SUM('Type III Costs'!O63:P63)/TypeIIIPODs","v":277500}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M48,M45)","v":843200.54},null,null,null,null,"Personnel",{"$f":"SUM('Type I Costs'!O64:P64)/TypeIPODs","v":90756},{"$f":"SUM('Type II Costs'!O64:P64)/TypeIIPODs","v":47016},{"$f":"SUM('Type III Costs'!O64:P64)/TypeIIIPODs","v":23508}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Training",{"$f":"SUM('Type I Costs'!J114:Q115)/TypeIPODs","v":1980},{"$f":"SUM('Type II Costs'!J114:Q115)/TypeIIPODs","v":1020},{"$f":"SUM('Type III Costs'!J114:Q115)/TypeIIIPODs","v":510}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"for chart"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loading Point Equipment Costs: ","POD Kit Costs:","Training Costs:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(S18:U18,S46:U46)","v":778107.5},{"$f":"SUMPRODUCT(S18:U18,S47:U47)","v":30653.040000000001},{"$f":"SUMPRODUCT(S18:U18,S50:U50)","v":34440}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Annual Costs (Including Deployment)"]
[null,null,null,null,null,null,null,null,null,"Equipment Costs: ",null,null,null,{"$f":"SUM(N66:O67)","v":808760.54}]
[null,null,null,null,null,null,null,null,null,"Loading Point Costs: ",null,null,null,{"$f":"R70","v":778107.5}]
[null,null,null,null,null,null,null,null,null,"POD Kit Costs: ",null,null,null,{"$f":"S70","v":30653.040000000001}]
[null,null,null,null,null,null,null,null,null,"Operational POD Supplies Costs: ",null,null,null,{"$f":"T70","v":18870000},null,null,null,"For chart"]
[null,null,null,null,null,null,null,null,null,"Operational Personnel Costs: ",null,null,null,{"$f":"U70","v":1585440},null,null,null,"Loading Point Equipment Costs:","POD Kit Costs:","POD Supplies Costs:","Personnel Costs:","Training Costs:"]
[null,null,null,null,null,null,null,null,null,"Training Costs: ",null,null,null,{"$f":"V70","v":34440},null,null,null,{"$f":"SUMPRODUCT(S18:U18,S46:U46)","v":778107.5},{"$f":"SUMPRODUCT(S18:U18,S47:U47)","v":30653.040000000001},{"$f":"SUMPRODUCT(S18:U18,S48:U48)","v":18870000},{"$f":"SUMPRODUCT(S18:U18,S49:U49)","v":1585440},{"$f":"SUMPRODUCT(S18:U18,S50:U50)","v":34440}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N68:O70,N65)","v":21298640.539999999}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"How many times per year do you \nexpect to deploy PODs?",null,null,null,{"$f":"Deployed","v":1}]
[]
[null,null,null,null,null,null,null,null,null,"This can be changed on the User Input page."]

{"sheet":"HoldShapes","index":12,"n_rows":78,"n_cols":23,"rows_kept":78,"cut":false,"hidden":true,"merged":[[77,12,77,13],[11,1,12,8],[17,1,17,8],[44,2,45,7],[47,2,47,5],[11,9,12,12],[15,1,15,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Cost 1","Cost 2","Cost 3"]
[null,null,null,null,null,null,4,8,1]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost 1","Cost 2","Cost 3","Cost 4 ","Cost 5"]
[null,null,"Gap Calculation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,5,45,30]
[]
[]
[null,null,"Suggested WMD/HAZMAT Team Capability"]
[null,null,null,"Type I Team",null,null,0]
[null,null,null,"Type II Team",null,null,0]
[null,null,null,"Type III Team",null,null,0]
[null,null,null,null,null,"Total:",{"$f":"SUM(G49:G51)","v":0}]
[]
[null,null,"Current WMD/HAZMAT Capability"]
[null,null,null,"Type I Team",null,null,2]
[null,null,null,"Type II Team",null,null,0]
[null,null,null,"Type III Team",null,null,1]
[null,null,null,null,null,"Total:",{"$f":"SUM(G55:G57)","v":3}]
[]
[]
[null,null,"Difference Between Current and Suggested"]
[null,null,null,"Type I Team",null,null,{"$f":"G55-G49","v":2}]
[null,null,null,"Type II Team",null,null,{"$f":"G56-G50","v":0}]
[null,null,null,"Type III Team",null,null,{"$f":"G57-G51","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"text text text to test"]

{"sheet":"Lists","index":13,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Percent"]
["Number"]

{"sheet":"FormatHold","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[[15,7,15,9],[19,2,19,10],[3,2,3,3],[3,8,3,9],[14,2,14,3],[14,6,14,10]]}

{"sheet":"CostsQuants","index":15,"n_rows":78,"n_cols":14,"rows_kept":78,"cut":false,"hidden":true,"merged":[[72,0,73,7],[72,8,73,13],[14,0,15,7],[14,8,15,13],[28,0,29,7],[28,8,29,13],[61,0,62,7],[61,8,62,13],[46,0,47,8],[46,9,47,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Q Type I","Q Type II","Q Type III","C"]
["Loading Point Equipment"]
[]
["Forklifts",null,null,null,null,null,null,null,null,3,2,1,25000]
["Pallet Jacks",null,null,null,null,null,null,null,null,3,2,1,365]
["Power Light Set",null,null,null,null,null,null,null,null,2,1,1,11230]
["Toilets",null,null,null,null,null,null,null,null,6,4,2,686]
["Tents",null,null,null,null,null,null,null,null,2,2,1,595]
["Dumpsters",null,null,null,null,null,null,null,null,4,2,1,752]
["Traffic cones",null,null,null,null,null,null,null,null,30,15,10,27.15]
["Two way radio",null,null,null,null,null,null,null,null,4,0,0,250]
["Pallets",null,null,null,null,null,null,null,null,768,384,192,10]
[]
[]
[]
["POD Kit"]
[]
["96-gallon trash can",null,null,null,null,null,null,null,null,4,2,1,90]
["Work gloves (pairs)",null,null,null,null,null,null,null,null,64,32,16,2]
["Duct tape",null,null,null,null,null,null,null,null,16,8,4,1]
["Flashlights",null,null,null,null,null,null,null,null,80,40,20,20]
["Batteries",null,null,null,null,null,null,null,null,144,72,36,1.25]
["Reflective safety vests",null,null,null,null,null,null,null,null,80,40,20,30]
["First Aid kit",null,null,null,null,null,null,null,null,4,2,1,40]
["Traffic cones",null,null,null,null,null,null,null,null,48,24,12,27.15]
["Hard hats",null,null,null,null,null,null,null,null,64,32,16,15.35]
["Glow sticks (orange/red)",null,null,null,null,null,null,null,null,120,60,30,1]
["Back support vest",null,null,null,null,null,null,null,null,32,16,8,15]
["Fire extinguisher (5lb)",null,null,null,null,null,null,null,null,4,2,1,61]
["Signage",null,null,null,null,null,null,null,null,20,10,5,10]
[]
[]
[]
["POD Supplies"]
[]
["Water (gallons) - 1 gallon per person daily",null,null,null,null,null,null,null,null,20000,10000,5000,0.5]
["Ice (pounds) - 8 lbs per person daily",null,null,null,null,null,null,null,null,{"$f":"8*20000","v":160000},80000,40000,0.5]
["Meals-Ready-to-Eat - 2 per person daily",null,null,null,null,null,null,null,null,{"$f":"2*20000","v":40000},20000,10000,2]
["Tarps (20' x 25') - 1 per household, total",null,null,null,null,null,null,null,null,20000,10000,5000,10]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Personnel"]
[]
[null,null,null,null,null,null,null,"Hours Deployed",null,null,null,null,"backfill"]
["POD Manager",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},null,1,0,0,52]
["Support Team Leader",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},null,3,3,1,45]
["Fork Lift Operator",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},null,5,3,2,45]
["Loading Point Labor",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},null,54,27,13,37]
["Pallet Jacks Labor",null,null,null,null,null,null,{"$f":"12*SUM('User Input'!$I$25:$J$25)","v":36},null,3,1,1,37]
[]
[]
[]
["Training"]
[]
[null,null,null,null,null,null,null,"Course Hours",null,null,null,null,"Average Backfill Rate","Initial Cost"]
["IS 100 - Introduction to ICS",null,null,null,null,null,null,3,null,null,null,null,30]
["IS 200 - ICS for Single Resources and Initial Action Incidents",null,null,null,null,null,null,3,null,null,null,null,30]
["IS 700 - NIMs",null,null,null,null,null,null,3,null,null,null,null,30]