{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["BWC Costs","BWC Storage","Lists"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BWC Costs","index":0,"n_rows":204,"n_cols":6,"rows_kept":204,"cut":false,"hidden":false,"merged":[[0,0,0,5],[92,0,92,5],[104,0,104,5],[203,0,203,5],[12,0,12,5],[74,0,74,5],[95,0,95,5],[192,0,192,5],[193,0,193,5],[163,0,163,5],[11,1,11,5],[1,0,1,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5]]}
[]
["BWC Cost Estimator"]
["Worksheet Key"]
[null,"Leave Blank"]
[null,"Required User Input"]
[null,"Automatically Calculated Result"]
["Agency Information"]
["Agency Name","Example Agency"]
["Agency Address"]
["Agency City"]
["Agency State"]
["Agency Zip"]
["Cost Inputs"]
["Questions",null,null,null,null,"Comments & Explanations"]
["Number of sworn officers",1500]
["Number of BWC to be fielded",1500,null,null,null,"Include only primary (deployed) BWCs here. Purchases of spare (backup) cameras (if applicable) are entered below."]
[]
[null,null,null,null,null,"Unless purchases spread over multiple years, we will compute a five-year total cost of ownership, with all purchases in year one. "]
[]
[]
[]
[]
["Category","Questions",{"$f":"IF(C24>0,C24,\"Vendor 1\")","v":"BWC, Inc."},{"$f":"IF(D24>0,D24,\"Vendor 2\")","v":"Vendor 2"},{"$f":"IF(E24>0,E24,\"Vendor 3\")","v":"Vendor 3"},"Comments & Explanations"]
["Vendor Name(s)","Enter Vendor Names","BWC, Inc.",null,null,"Enter name(s) of vendors being considered as Vendor 1, Vendor 2, or Vendor 3 under the appropriate column. "]
["Cameras and Docking Stations","Cameras and Docking Stations"]
[null,"Cost per camera",50,null,null,"Enter the cost per camera under the appropriate column for each vendor. If you have a bundled upfront one-time cost per camera enter it here and leave all associated costs included in that bundle blank. "]
[null,"Cost per docking station",500,null,null,"Enter the cost per docking station under the appropriate column for each vendor. "]
[null,"# of cameras per docking station",10,10,10,"Enter the number of cameras per docking station under the appropriate column for each vendor. "]
["Number of BWC Purchased per Year","Number of BWC Purchased per Year",null,null,null,"This section will automatically populate unless you selected \"I want to manually input purchase costs across five years\" under the \"Purchase Cost Distribution\" question. "]
[null,"Year 1",1200,300,300]
[null,"Year 2",300,300,300]
[null,"Year 3",0,300,300]
[null,"Year 4",0,300,300]
[null,"Year 5",0,300,300]
["Storage","Storage",null,null,null,"Work with your IT personnel and vendors of interest to identify storage requirements and costs. "]
[null,"Cloud fees per camera per month",12,null,null,"If you are considering cloud storage, enter monthly fees charged per officer for any cloud storage vendors of interest. If you are not considering cloud storage, leave this section blank. If you have a bundled monthly cost per camera enter it here and leave all associated costs included in that bundle blank. "]
[null,"Other fixed monthly cloud fees <Describe Here> ",1500,null,null,"If you are considering cloud storage, enter monthly fees for any cloud storage vendors of interest. If you are not considering cloud storage, leave this section blank.  Please feel free to put a very brief explanation of what is included within this field between the brackets <>where it says <Describe Here>.    Additional description, if desired can be put here:"]
[null,"In-house video storage, overall cost",{"$f":"50*1500","v":75000},null,null,"If you are considering in-house storage, enter the one-time, upfront costs of all in-house video storage that will be required. If you are not considering in-house video storage leave this section blank. "]
["Peripheral Equipment","Peripheral Equipment",null,null,null,"Contact vendors of interest for availability and pricing of such items. "]
[null,"Spare cameras",50,null,null,"Enter the number of spare cameras desired. "]
[null,"Camera mounts not included with camera",50,null,null,"Enter the number of camera mounts desired (only if they do not come with cameras)."]
[null,"Cost per camera mount",20,null,null,"Enter the cost per camera mount."]
[null,"Annual cost of other spare parts",0,null,null,"Enter the combined annual cost of any other desired additional spare parts. "]
[null,"# of auto-initiation triggers",0,null,null,"Enter the number of desired auto-initiation triggers."]
[null,"Cost per auto-initiation trigger",500,null,null,"Enter the cost per auto-initiation trigger."]
[null,"Other peripheral equipment  <describe here>",0,null,null,"Enter the combined annual cost of any other desired peripheral equipment.    Please feel free to put a very brief explanation of what is included within this field between the brackets <>where it says <Describe Here>.    Additional description, if desired can be put here:"]
["Licenses (annual fees)","Licenses (annual fees)",null,null,null,"Contact vendors of interest for availability and pricing of such items. "]
["Software","Video management software",15000,null,null,"Enter the annual costs of video management software. "]
[null,"Video editing and redaction software",10000,null,null,"Enter the annual costs of redaction software. "]
[null,"CAD integration",5000,null,null,"Enter the annual costs of CAD integration. "]
["Other","Other <describe here>",500,null,null,"Enter the combined annual cost of any other licensing fees not captured already.   Please feel free to put a very brief explanation of what is included within this field between the brackets <>where it says <Describe Here>.    Additional description, if desired can be put here:"]
["Maintenance","Maintenance not included elsewhere ",0,null,null,"Enter the annual cost of maintenance. "]
["IT Infrastructure","Cost to upgrade IT infrastructure (one-time cost)",25000,null,null,"Work with your IT personnel to identify if upgrades are required and, if so, what the costs may be.  BWC infrastructure for uploads/downloads and charging often requires upgrades for bandwidth and electrical capacity. If you have a bundled upfront one time total cost enter it here and leave all associated costs included in that bundle blank. "]
["Personnel","Personnel (annual, fully loaded)",null,null,null,"Please enter as an annual cost, figuring the personnel time required for each position against the fully weighted annual cost for such a position in your agency. "]
[null,"BWC project manager/coordinator",100000,null,null,"Enter the annual cost for this position. "]
[null,"IT personnel",200000,null,null,"Enter the annual cost for all additional IT personnel. "]
[null,"Training (trainer cost)",45000,null,null,"Enter the annual cost for all training personnel. "]
[null,"Public information personnel",null,null,null,"Enter the annual cost for all personnel processing Public Information requests. "]
[null,"Other program personnel <describe here>",100000,null,null,"Enter the combined annual cost for all other additional personnel.  Please feel free to put a very brief explanation of what is included within this field between the brackets <>where it says <Describe Here>.    Additional description, if desired can be put here:"]
["Prosecution video transmission","Prosecution video transmission",null,null,null,"Work with your prosecutor's office and vendors of interest to identify available features and costs. "]
[null,"Can vendor transmit electronically to prosecutors?   (Yes/No)",null,null,null,"Please check with your vendor for this information. "]
["(Note: If your agency Is not responsible for preparing video for prosecutors, please feel free to skip this section)","If Prosecutor requires videos, will Prosecutor accept electronic transmission? (Yes/No/Maybe/Yes Sometimes)",null,null,null,"Please check with your prosecutor's office for this information. "]
[null,"Video Media: Annual # of Videos requested",null,null,null,"Enter the total number of annual videos being requested by your prosecutor’s office. This can be estimated by multiplying the number of cases per year that you expect to have video requests by the average number of videos requested per case. Please consult with your prosecutor’s office to determine this amount. "]
[null,"Prosecution video transmission personnel cost per video",null,null,null,"Enter the cost for one video for all personnel processing video requests from the prosecutors’ office. This cost can be estimated by multiplying the relevant personnel’s hourly rate by the time required to fulfill an average video request."]
[null,"Video editing and redaction equipment (upfront cost)",null,null,null,"Enter the upfront cost of any new equipment—such as DVD burners or computer upgrades—that you may specifically require to handle prosecution video media preparation. Please consult with IT personnel and prosecutors. "]
[null,"Video editing and redaction supplies cost per video",null,null,null,"Enter the cost of editing and redaction supplies per video. Please consult with your prosecutors’ office about the type of media (e.g., CD, DVD, USB thumb drive) generally used to transmit BWC video footage, and the cost of that media. "]
[null,"Video editing and redaction services cost per video",null,null,null,"Enter the expected cost of these services per video. Please consult with your agency’s IT personnel and consider consulting with video editing experts within your agency or government entity. "]
["Public Information Request","Public Information Request"]
[null,"Video editing and redaction equipment",200000,null,null,"Enter the upfront cost of this equipment."]
[null,"Video editing and redaction supplies",null,null,null,"Enter the expected average monthly cost of video editing and redaction supplies.  If you have a bundled monthly total cost enter it here and leave all associated costs included in that bundle blank. "]
[null,"Video editing and redaction services",null,null,null,"Enter the average expected monthly cost of these services. "]
[null,"Public Information Request user fees",0,null,null,"Enter the annual amount your agency expects to receive in reimbursements."]
[]
["Total Costs","Five-year totals (present value)",{"$f":"C113","v":4001071.5676513389},{"$f":"C142","v":0},{"$f":"C171","v":0},"This is the total five-year cost in present value. More detailed cost estimates can be found in the Results section."]
["Benefit Inputs"]
["Question","Actual","High Estimate","Middle Estimate","Low Estimate","Comments & Explanations"]
["Complaint Reductions",null,null,null,null,"Please note: The entries in this field are not predictions of what will happen.  They are merely assumptions of possible impacts, to analyze the benefits of those possible impacts."]
["# of complaints filed last year",1500,null,null,null,"Enter the actual number of complaints filed in the last full year of records. "]
["Average cost per complaint",3000,null,null,null,"Enter the average cost to investigate and resolve complaints filed in the last full year of records"]
["Expected % reduction in complaints",null,0.2,0.1,-0.1,"In the corresponding cells, enter a decimal value between 0 and 1 for the high, medium, and low estimates for the percent of complaints that BWCs might reduce. The value will appear as a percent. "]
["Expected % of complaints that can be resolved primarily by video review",null,0.6,0.5,0.4,"In the corresponding cells, enter a decimal value between 0 and 1 for the high, medium, and low estimated for the expected percent reductions in complaints resolved primarily by video review. The value will appear as a percent. "]
["Expected % reduction in average cost if complaint resolved primarily by video review",null,0.9,0.8,0.6,"In the corresponding cells, enter a decimal value between 0 and 1 for the high, medium, and low estimates of percentage reduction in average cost per complaint (entered earlier) if the complaint is resolved primarily by BWC video.  The value will appear as a percent. "]
["Use of Force Reductions",null,null,null,null,"Please note: The entries in this field are not predictions of what will happen.  They are merely assumptions of possible impacts, to analyze the benefits of those possible impacts."]
["# of use of force incidents last year",15,null,null,null,"Enter the actual number of use of force incidents filed in the last full year of records. "]
["Average cost per use of force incident",150000,null,null,null,"Enter the average cost to investigate and resolve use of force incidents filed in the last full year of records. "]
["Expected reductions in use of force incidents",null,0.05,0.01,0,"In the corresponding cells, enter a decimal value between 0 and 1 for the high, medium, and low estimates for the percentage of use of force incidents that BWCs might reduce. The value will appear as a percent. "]
["Officer-Involved Shooting Reductions  ",null,null,null,null,"Please note: The entries in this section are not predictions of what will happen.  They are merely assumptions of possible impacts, to analyze the benefits of those possible impacts."]
["# of officer-involved shooting incidents last year",5,null,null,null,"Enter the actual number of officer-involved shooting incidents filed in the last full year of records. "]
["Cost per officer-involved shooting incident",1000000,null,null,null,"Enter the average cost to investigate and resolve officer-involved shooting incidents filed in the last full year of records. "]
["Expected reductions in officer involved shooting incidents ",null,7.0000000000000001E-3,5.0000000000000001E-3,0,"In the corresponding cells, enter a decimal value between 0 and 1 for the high, medium, and low estimates of expected reductions in officer-involved shooting incidents. The value will appear as a percent.   Please note: The entries in this field are not predictions of what will happen.  They are merely assumptions of possible impacts, to analyze the benefits of those possible impacts.\n\n"]
[]
["Total Benefits","Five-year total (present value)",{"$f":"B121","v":14540866.714821991},{"$f":"C121","v":10292590.76337475},{"$f":"D121","v":3587216.9933273038},"This is the total five-year cost in present value. More detail cost estimates can be found in the Results section. "]
["Other Inputs"]
["Annual Inflation Rate",-6.0000000000000001E-3,null,null,null,"The annual inflation rate captures the assumed future increase in the average price of personnel and materials."]
["Annual Cost of Borrowing",-6.0000000000000001E-3,null,null,null,"The annual discount rate (or real interest rate) reflects how much less a benefit received one year from now is worth relative to a benefit received today. This can be positive, even if there is no price inflation."]
["Potential Funding Options"]
["Funding Sources","Funding Sources"]
[null,"Grants applied for: "]
[null,"Federal grants",null,null,null,"Federal grants, such as the DOJ BJA BWC PIP grant and the DOT DWI Check Point grants, can be used to fund BWC programs. "]
[null,"State grants",null,null,null,"Many states offer BWC grants.  Please check with your state government for more information. "]
[null,"Nonprofit grants",null,null,null,"Some nonprofit agencies, including local police foundations and police nonprofits, have helped fund BWC programs.  "]
[null,"State/local government direct appropriations",null,null,null,"How much, if any, has your state or local government budgeted directly for your agency's BWC program?"]
[null,"Other operating funds",null,null,null,"Any funds not covered by other sources will likely need to be covered by general operating budget funds."]
["Funding Gaps"]
["Calculations"]
[{"$f":"IF(C24>0, C24, \"Vendor 1\")","v":"BWC, Inc."}]
["Costs","Then Year (inflation-adjusted future dollars)","Present Value"]
["Year 1",{"$f":"IFERROR(C30*(C$26+C$27/C$28)+SUM(C$30:C30)*C$36*12+C$37*12+(C$40/B$16)*C30*C$26+(C$41/B$16)*C30*C$42+C$43+(C$44/B$16)*C30*C$45+C$38+C$46+C$48+C$49+C$50+C$51+C$52+C$53+C$55+C$56+C$57+C$58+C$59+ C65 + C63*(C64+C66+C67)+C$69+((C$70+C$71)*12)-C$72, \"\")","v":1089100},{"$f":"IFERROR(B108, \"\")","v":1089100}]
["Year 2",{"$f":"IFERROR((1+$B$94)*(C31*(C$26+C$27/C$28)+SUM(C$30:C31)*C$36*12+C$37*12+(C$40/B$16)*C31*C$26+(C$41/B$16)*C31*C$42+C$43+(C$44/B$16)*C31*C$45+C$46+C$48+C$49+C$50+C$51+C$52+C$55+C$56+C$57+C$58+C$59 + C63*(C64+C66+C67)+ ((C$70+C$71)*12)-C$72), \"\")","v":735758.8},{"$f":"IFERROR(B109/((1+$B$94)*(1+$B$95)), \"\")","v":744668.0080482898}]
["Year 3",{"$f":"IFERROR(((1+$B$94)^2)*(C32*(C$26+C$27/C$28)+SUM(C$30:C32)*C$36*12+C$37*12+(C$40/B$16)*C32*C$26+(C$41/B$16)*C32*C$42+C$43+(C$44/B$16)*C32*C$45+C$46+C$48+C$49+C$50+C$51+C$52+C$55+C$56+C$57+C$58+C$59+ C63*(C64+C66+C67)+((C$70+C$71)*12)-C$72), \"\")","v":701011.54200000002},{"$f":"IFERROR(B110/((1+$B$94)^2*(1+$B$95)^2), \"\")","v":718091.24363889568}]
["Year 4",{"$f":"IFERROR(((1+$B$94)^3)*(C33*(C$26+C$27/C$28)+SUM(C$30:C33)*C$36*12+C$37*12+(C$40/B$16)*C33*C$26+(C$41/B$16)*C33*C$42+C$43+(C$44/B$16)*C33*C$45+C$46+C$48+C$49+C$50+C$51+C$52+C$55+C$56+C$57+C$58+C$59+ C63*(C64+C66+C67)+ ((C$70+C$71)*12)-C$72), \"\")","v":696805.47274799994},{"$f":"IFERROR(B111/((1+$B$94)^3*(1+$B$95)^3), \"\")","v":722425.79842947249}]
["Year 5",{"$f":"IFERROR(((1+$B$94)^4)*(C34*(C$26+C$27/C$28)+SUM(C$30:C34)*C$36*12+C$37*12+(C$40/B$16)*C34*C$26+(C$41/B$16)*C34*C$42+C$43+(C$44/B$16)*C34*C$45+C$46+C$48+C$49+C$50+C$51+C$52+C$55+C$56+C$57+C$58+C$59+ C63*(C64+C66+C67)+ ((C$70+C$71)*12)-C$72), \"\")","v":692624.63991151203},{"$f":"IFERROR(B112/((1+$B$94)^4*(1+$B$95)^4), \"\")","v":726786.51753468066}]
["Total Five-Year",{"$f":"SUM(B108:B112)","v":3915300.4546595123},{"$f":"SUM(C108:C112)","v":4001071.5676513389}]
[]
["Benefits (all present value)","High Estimate","Middle Estimate","Low Estimate"]
["Year 1",{"$f":"IFERROR((SUM($C$30:$C30)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90)), \"\")","v":2393200},{"$f":"IFERROR((SUM($C$30:$C30)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90)), \"\")","v":1694000},{"$f":"IFERROR((SUM($C$30:$C30)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90)), \"\")","v":590400}]
["Year 2",{"$f":"IFERROR((SUM($C$30:$C31)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90))/(1+$B$95), \"\")","v":3009557.3440643866},{"$f":"IFERROR((SUM($C$30:$C31)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90))/(1+$B$95), \"\")","v":2130281.6901408453},{"$f":"IFERROR((SUM($C$30:$C31)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90))/(1+$B$95), \"\")","v":742454.72837022133}]
["Year 3",{"$f":"IFERROR((SUM($C$30:$C32)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90))/(1+$B$95)^2, \"\")","v":3027723.6861814749},{"$f":"IFERROR((SUM($C$30:$C32)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90))/((1+$B$95)^2), \"\")","v":2143140.5333408904},{"$f":"IFERROR((SUM($C$30:$C32)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90))/(1+$B$95)^2, \"\")","v":746936.34644891485}]
["Year 4",{"$f":"IFERROR((SUM($C$30:$C33)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90))/(1+$B$95)^3, \"\")","v":3045999.6842871984},{"$f":"IFERROR((SUM($C$30:$C33)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90))/(1+$B$95)^3, \"\")","v":2156076.9953127671},{"$f":"IFERROR((SUM($C$30:$C33)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90))/(1+$B$95)^3, \"\")","v":751445.016548204}]
["Year 5",{"$f":"IFERROR((SUM($C$30:$C34)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90))/(1+$B$95)^4, \"\")","v":3064386.0002889317},{"$f":"IFERROR((SUM($C$30:$C34)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90))/(1+$B$95)^4, \"\")","v":2169091.5445802482},{"$f":"IFERROR((SUM($C$30:$C34)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90))/(1+$B$95)^4, \"\")","v":755980.90195996372}]
["Total ",{"$f":"SUM(B116:B120)","v":14540866.714821991},{"$f":"SUM(C116:C120)","v":10292590.76337475},3587216.9933273038]
[]
["Net Present Value","High Estimate","Middle Estimate","Low Estimate"]
["Year 1",{"$f":"IFERROR(B116-$C108, \"\")","v":1304100},604900,-498700]
["Year 2",2264889.3360160966,1385613.6820925553,-2213.279678068473]
["Year 3",2309632.442542579,1425049.2897019947,28845.102810019162]
["Year 4",2323573.885857726,1433651.1968832947,29019.218118731515]
["Year 5",2337599.482754251,1442305.0270455675,29194.38442528306]
["Total ",{"$f":"B121-$C113","v":10539795.147170652},{"$f":"C121-$C113","v":6291519.1957234107},-413854.57432403509]
[]
[null,"High Estimate","Middle Estimate","Low Estimate"]
["Five-Year Return on Investment",{"$f":"IFERROR((B121-C113)/C113, \"\")","v":2.6342430943712403},{"$f":"IFERROR((C121-C113)/C113, \"\")","v":1.5724585500020394},{"$f":"IFERROR((D121-C113)/C113, \"\")","v":-0.1034359339308122}]
["Benefit-Cost Ratio",{"$f":"IFERROR(B121/C113, \"\")","v":3.6342430943712403},{"$f":"IFERROR(C121/C113, \"\")","v":2.5724585500020392},{"$f":"IFERROR(D121/C113, \"\")","v":0.89656406606918781}]
["Payback Period",{"$f":"IF(B129<0,\"Never\",IF(AND(SUM(B124:B127)<0,SUM(B124:B128)>0)=TRUE,5,IF(AND(SUM(B124:B126)<0,SUM(B124:B127)>0)=TRUE,4,IF(AND(SUM(B124:B125)<0,SUM(B124:B126)>0)=TRUE,3,IF(AND(SUM(B124:B124)<0,SUM(B124:B125)>0)=TRUE,2,1)))))","v":1},{"$f":"IF(C129<0,\"Never\",IF(AND(SUM(C124:C127)<0,SUM(C124:C128)>0)=TRUE,5,IF(AND(SUM(C124:C126)<0,SUM(C124:C127)>0)=TRUE,4,IF(AND(SUM(C124:C125)<0,SUM(C124:C126)>0)=TRUE,3,IF(AND(SUM(C124:C124)<0,SUM(C124:C125)>0)=TRUE,2,1)))))","v":1},{"$f":"IF(D129<0,\"Never\",IF(AND(SUM(D124:D127)<0,SUM(D124:D128)>0)=TRUE,5,IF(AND(SUM(D124:D126)<0,SUM(D124:D127)>0)=TRUE,4,IF(AND(SUM(D124:D125)<0,SUM(D124:D126)>0)=TRUE,3,IF(AND(SUM(D124:D124)<0,SUM(D124:D125)>0)=TRUE,2,1)))))","v":"Never"}]
[{"$f":"IF(D24>0, D24, \"Vendor 2\")","v":"Vendor 2"}]
["Costs","Then Year (inflation-adjusted future dollars)","Present Value"]
["Year 1",{"$f":"IFERROR(D30*(D$26+D$27/D$28)+SUM(D$30:D30)*D$36*12+D$37*12+(D$40/B$16)*D30*D$26+(D$41/B$16)*D30*D$42+D$43+(D$44/B$16)*D30*D$45+D$38+D$46+D$48+D$49+D$50+D$51+D$52+D$53+D$55+D$56+D$57+D$58+D$59+ D65+D63*(D64+D66+D67)+D$69+((D$70+D$71)*12)-D$72, \"\")","v":0},{"$f":"IFERROR(B137, \"\")","v":0}]
["Year 2",{"$f":"IFERROR((1+$B$94)*(D31*(D$26+D$27/D$28)+SUM(D$30:D31)*D$36*12+D$37*12+(D$40/B$16)*D31*D$26+(D$41/B$16)*D31*D$42+D$43+(D$44/B$16)*D31*D$45+D$46+D$48+D$49+D$50+D$51+D$52+D$55+D$56+D$57+D$58+D$59+D63*(D64+D66+D67)+((D$70+D$71)*12)-D$72), \"\")","v":0},{"$f":"IFERROR(B138/((1+$B$94)*(1+$B$95)), \"\")","v":0}]
["Year 3",{"$f":"IFERROR(((1+$B$94)^2)*(D32*(D$26+D$27/D$28)+SUM(D$30:D32)*D$36*12+D$37*12+(D$40/B$16)*D32*D$26+(D$41/B$16)*D32*D$42+D$43+(D$44/B$16)*D32*D$45+D$46+D$48+D$49+D$50+D$51+D$52+D$55+D$56+D$57+D$58+D$59+D63*(D64+D66+D67)+((D$70+D$71)*12)-D$72), \"\")","v":0},{"$f":"IFERROR(B139/((1+$B$94)^2*(1+$B$95)^2), \"\")","v":0}]
["Year 4",{"$f":"IFERROR(((1+$B$94)^3)*(D33*(D$26+D$27/D$28)+SUM(D$30:D33)*D$36*12+D$37*12+(D$40/B$16)*D33*D$26+(D$41/B$16)*D33*D$42+D$43+(D$44/B$16)*D33*D$45+D$46+D$48+D$49+D$50+D$51+D$52+D$55+D$56+D$57+D$58+D$59+D63*(D64+D66+D67)+((D$70+D$71)*12)-D$72), \"\")","v":0},{"$f":"IFERROR(B140/((1+$B$94)^3*(1+$B$95)^3), \"\")","v":0}]
["Year 5",{"$f":"IFERROR(((1+$B$94)^4)*(D34*(D$26+D$27/D$28)+SUM(D$30:D34)*D$36*12+D$37*12+(D$40/B$16)*D34*D$26+(D$41/B$16)*D34*D$42+D$43+(D$44/B$16)*D34*D$45+D$46+D$48+D$49+D$50+D$51+D$52+D$55+D$56+D$57+D$58+D$59+D63*(D64+D66+D67)+((D$70+D$71)*12)-D$72), \"\")","v":0},{"$f":"IFERROR(B141/((1+$B$94)^4*(1+$B$95)^4), \"\")","v":0}]
["Total Five-Year",{"$f":"SUM(B137:B141)","v":0},{"$f":"SUM(C137:C141)","v":0}]
[]
["Benefits (all present value)","High Estimate","Middle Estimate","Low Estimate"]
["Year 1",{"$f":"IFERROR((SUM($C$30:$C30)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90)), \"\")","v":2393200},{"$f":"IFERROR((SUM($C$30:$C30)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90)), \"\")","v":1694000},{"$f":"IFERROR((SUM($C$30:$C30)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90)), \"\")","v":590400}]
["Year 2",{"$f":"IFERROR((SUM($C$30:$C31)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90))/(1+$B$95), \"\")","v":3009557.3440643866},{"$f":"IFERROR((SUM($C$30:$C31)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90))/(1+$B$95), \"\")","v":2130281.6901408453},{"$f":"IFERROR((SUM($C$30:$C31)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90))/(1+$B$95), \"\")","v":742454.72837022133}]
["Year 3",{"$f":"IFERROR((SUM($C$30:$C32)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90))/(1+$B$95)^2, \"\")","v":3027723.6861814749},{"$f":"IFERROR((SUM($C$30:$C32)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90))/(1+$B$95)^2, \"\")","v":2143140.5333408904},{"$f":"IFERROR((SUM($C$30:$C32)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90))/(1+$B$95)^2, \"\")","v":746936.34644891485}]
["Year 4",{"$f":"IFERROR((SUM($C$30:$C33)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90))/(1+$B$95)^3, \"\")","v":3045999.6842871984},{"$f":"IFERROR((SUM($C$30:$C33)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90))/(1+$B$95)^3, \"\")","v":2156076.9953127671},{"$f":"IFERROR((SUM($C$30:$C33)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90))/(1+$B$95)^3, \"\")","v":751445.016548204}]
["Year 5",{"$f":"IFERROR((SUM($C$30:$C34)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90))/(1+$B$95)^4, \"\")","v":3064386.0002889317},{"$f":"IFERROR((SUM($C$30:$C34)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90))/(1+$B$95)^4, \"\")","v":2169091.5445802482},{"$f":"IFERROR((SUM($C$30:$C34)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90))/(1+$B$95)^4, \"\")","v":755980.90195996372}]
["Total ",{"$f":"SUM(B145:B149)","v":14540866.714821991},{"$f":"SUM(C145:C149)","v":10292590.76337475},{"$f":"SUM(D145:D149)","v":3587216.9933273038}]
[]
["Net Present Value","High Estimate","Middle Estimate","Low Estimate"]
["Year 1",{"$f":"IFERROR(B145-$C137, \"\")","v":2393200},1694000,590400]
["Year 2",3009557.3440643866,2130281.6901408453,742454.72837022133]
["Year 3",3027723.6861814749,2143140.5333408904,746936.34644891485]
["Year 4",3045999.6842871984,2156076.9953127671,751445.016548204]
["Year 5",3064386.0002889317,2169091.5445802482,755980.90195996372]
["Total ",{"$f":"B150-$C142","v":14540866.714821991},{"$f":"IFERROR(C150-$C142, \"\")","v":10292590.76337475},{"$f":"IFERROR(D150-$C142, \"\")","v":3587216.9933273038}]
[]
[null,"High Estimate","Middle Estimate","Low Estimate"]
["Five-Year Return on Investment",{"$f":"IFERROR((B150-C142)/C142, \"\")","v":""},{"$f":"IFERROR((C150-C142)/C142, \"\")","v":""},{"$f":"IFERROR((D150-C142)/C142, \"\")","v":""}]
["Benefit-Cost Ratio",{"$f":"IFERROR(B150/C142, \"\")","v":""},{"$f":"IFERROR(C150/C142, \"\")","v":""},{"$f":"IFERROR(D150/C142, \"\")","v":""}]
["Payback Period",{"$f":"IF(B158<0,\"Never\",IF(AND(SUM(B153:B156)<0,SUM(B153:B157)>0)=TRUE,5,IF(AND(SUM(B153:B155)<0,SUM(B153:B156)>0)=TRUE,4,IF(AND(SUM(B153:B154)<0,SUM(B153:B155)>0)=TRUE,3,IF(AND(SUM(B153:B153)<0,SUM(B153:B154)>0)=TRUE,2,1)))))","v":1},{"$f":"IF(C158<0,\"Never\",IF(AND(SUM(C153:C156)<0,SUM(C153:C157)>0)=TRUE,5,IF(AND(SUM(C153:C155)<0,SUM(C153:C156)>0)=TRUE,4,IF(AND(SUM(C153:C154)<0,SUM(C153:C155)>0)=TRUE,3,IF(AND(SUM(C153:C153)<0,SUM(C153:C154)>0)=TRUE,2,1)))))","v":1},{"$f":"IF(D158<0,\"Never\",IF(AND(SUM(D153:D156)<0,SUM(D153:D157)>0)=TRUE,5,IF(AND(SUM(D153:D155)<0,SUM(D153:D156)>0)=TRUE,4,IF(AND(SUM(D153:D154)<0,SUM(D153:D155)>0)=TRUE,3,IF(AND(SUM(D153:D153)<0,SUM(D153:D154)>0)=TRUE,2,1)))))","v":1}]
[{"$f":"IF(E24>0, E24, \"Vendor 3\")","v":"Vendor 3"}]
["Costs","Then Year (inflation-adjusted future dollars)","Present Value"]
["Year 1",{"$f":"IFERROR(E30*(E$26+E$27/E$28)+SUM(E$30:E30)*E$36*12+E$37*12+(E$40/B$16)*E30*E$26+(E$41/B$16)*E30*E$42+E$43+(E$44/B$16)*E30*E$45+E$38+E$46+E$48+E$49+E$50+E$51+E$52+E$53+E$55+E$56+E$57+E$58+E$59+E65+E63*(E64+E66+E67)+E$69+((E$70+E$71)*12)-E$72, \"\")","v":0},{"$f":"IFERROR(B166, \"\")","v":0}]
["Year 2",{"$f":"IFERROR((1+$B$94)*(E31*(E$26+E$27/E$28)+SUM(E$30:E31)*E$36*12+E$37*12+(E$40/B$16)*E31*E$26+(E$41/B$16)*E31*E$42+E$43+(E$44/B$16)*E31*E$45+E$46+E$48+E$49+E$50+E$51+E$52+E$55+E$56+E$57+E$58+E$59+E63*(E64+E66+E67)+((E$70+E$71)*12)-E$72), \"\")","v":0},{"$f":"IFERROR(B167/((1+$B$94)*(1+$B$95)), \"\")","v":0}]
["Year 3",{"$f":"IFERROR(((1+$B$94)^2)*(E32*(E$26+E$27/E$28)+SUM(E$30:E32)*E$36*12+E$37*12+(E$40/B$16)*E32*E$26+(E$41/B$16)*E32*E$42+E$43+(E$44/B$16)*E32*E$45+E$46+E$48+E$49+E$50+E$51+E$52+E$55+E$56+E$57+E$58+E$59+E63*(E64+E66+E67)+((E$70+E$71)*12)-E$72), \"\")","v":0},{"$f":"IFERROR(B168/((1+$B$94)^2*(1+$B$95)^2), \"\")","v":0}]
["Year 4",{"$f":"IFERROR(((1+$B$94)^3)*(E33*(E$26+E$27/E$28)+SUM(E$30:E33)*E$36*12+E$37*12+(E$40/B$16)*E33*E$26+(E$41/B$16)*E33*E$42+E$43+(E$44/B$16)*E33*E$45+E$46+E$48+E$49+E$50+E$51+E$52+E$55+E$56+E$57+E$58+E$59+E63*(E64+E66+E67)+((E$70+E$71)*12)-E$72), \"\")","v":0},{"$f":"IFERROR(B169/((1+$B$94)^3*(1+$B$95)^3), \"\")","v":0}]
["Year 5",{"$f":"IFERROR(((1+$B$94)^4)*(E34*(E$26+E$27/E$28)+SUM(E$30:E34)*E$36*12+E$37*12+(E$40/B$16)*E34*E$26+(E$41/B$16)*E34*E$42+E$43+(E$44/B$16)*E34*E$45+E$46+E$48+E$49+E$50+E$51+E$52+E$55+E$56+E$57+E$58+E$59+E63*(E64+E66+E67)+((E$70+E$71)*12)-E$72), \"\")","v":0},{"$f":"IFERROR(B170/((1+$B$94)^4*(1+$B$95)^4), \"\")","v":0}]
["Total Five-Year",{"$f":"SUM(B166:B170)","v":0},{"$f":"SUM(C166:C170)","v":0}]
[]
["Benefits (all present value)","High Estimate","Middle Estimate","Low Estimate"]
["Year 1",{"$f":"IFERROR((SUM($C$30:$C30)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90)), \"\")","v":2393200},{"$f":"IFERROR((SUM($C$30:$C30)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90)), \"\")","v":1694000},{"$f":"IFERROR((SUM($C$30:$C30)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90)), \"\")","v":590400}]
["Year 2",{"$f":"IFERROR((SUM($C$30:$C31)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90))/(1+$B$95), \"\")","v":3009557.3440643866},{"$f":"IFERROR((SUM($C$30:$C31)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90))/(1+$B$95), \"\")","v":2130281.6901408453},{"$f":"IFERROR((SUM($C$30:$C31)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90))/(1+$B$95), \"\")","v":742454.72837022133}]
["Year 3",{"$f":"IFERROR((SUM($C$30:$C32)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90))/(1+$B$95)^2, \"\")","v":3027723.6861814749},{"$f":"IFERROR((SUM($C$30:$C32)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90))/(1+$B$95)^2, \"\")","v":2143140.5333408904},{"$f":"IFERROR((SUM($C$30:$C32)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90))/(1+$B$95)^2, \"\")","v":746936.34644891485}]
["Year 4",{"$f":"IFERROR((SUM($C$30:$C33)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90))/(1+$B$95)^3, \"\")","v":3045999.6842871984},{"$f":"IFERROR((SUM($C$30:$C33)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90))/(1+$B$95)^3, \"\")","v":2156076.9953127671},{"$f":"IFERROR((SUM($C$30:$C33)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90))/(1+$B$95)^3, \"\")","v":751445.016548204}]
["Year 5",{"$f":"IFERROR((SUM($C$30:$C34)/$B$15)*($B$78*$B$79*(C$80+(1-C$80)*C$81*C$82)+$B$84*$B$85*(C$86)+$B$88*$B$89*(C$90))/(1+$B$95)^4, \"\")","v":3064386.0002889317},{"$f":"IFERROR((SUM($C$30:$C34)/$B$15)*($B$78*$B$79*(D$80+(1-D$80)*D$81*D$82)+$B$84*$B$85*(D$86)+$B$88*$B$89*(D$90))/(1+$B$95)^4, \"\")","v":2169091.5445802482},{"$f":"IFERROR((SUM($C$30:$C34)/$B$15)*($B$78*$B$79*(E$80+(1-E$80)*E$81*E$82)+$B$84*$B$85*(E$86)+$B$88*$B$89*(E$90))/(1+$B$95)^4, \"\")","v":755980.90195996372}]
["Total ",{"$f":"SUM(B174:B178)","v":14540866.714821991},{"$f":"SUM(C174:C178)","v":10292590.76337475},3587216.9933273038]
[]
["Net Present Value","High Estimate","Middle Estimate","Low Estimate"]
["Year 1",{"$f":"IFERROR(B174-$C166, \"\")","v":2393200},1694000,590400]
["Year 2",3009557.3440643866,2130281.6901408453,742454.72837022133]
["Year 3",3027723.6861814749,2143140.5333408904,746936.34644891485]
["Year 4",3045999.6842871984,2156076.9953127671,751445.016548204]
["Year 5",3064386.0002889317,2169091.5445802482,755980.90195996372]
["Total ",{"$f":"B179-$C171","v":14540866.714821991},{"$f":"C179-$C171","v":10292590.76337475},{"$f":"IFERROR(D179-$C171, \"\")","v":3587216.9933273038}]
[]
[null,"High Estimate","Middle Estimate","Low Estimate"]
["Five-Year Return on Investment",{"$f":"IFERROR((B179-C171)/C171, \"\")","v":""},{"$f":"IFERROR((C179-C171)/C171, \"\")","v":""},{"$f":"IFERROR((D179-C171)/C171, \"\")","v":""}]
["Benefit-Cost Ratio",{"$f":"IFERROR(B179/C171, \"\")","v":""},{"$f":"IFERROR(C179/C171, \"\")","v":""},{"$f":"IFERROR(D179/C171, \"\")","v":""}]
["Payback Period",{"$f":"IF(B187<0,\"Never\",IF(AND(SUM(B182:B185)<0,SUM(B182:B186)>0)=TRUE,5,IF(AND(SUM(B182:B184)<0,SUM(B182:B185)>0)=TRUE,4,IF(AND(SUM(B182:B183)<0,SUM(B182:B184)>0)=TRUE,3,IF(AND(SUM(B182:B182)<0,SUM(B182:B183)>0)=TRUE,2,1)))))","v":1},{"$f":"IF(C187<0,\"Never\",IF(AND(SUM(C182:C185)<0,SUM(C182:C186)>0)=TRUE,5,IF(AND(SUM(C182:C184)<0,SUM(C182:C185)>0)=TRUE,4,IF(AND(SUM(C182:C183)<0,SUM(C182:C184)>0)=TRUE,3,IF(AND(SUM(C182:C182)<0,SUM(C182:C183)>0)=TRUE,2,1)))))","v":1},{"$f":"IF(D187<0,\"Never\",IF(AND(SUM(D182:D185)<0,SUM(D182:D186)>0)=TRUE,5,IF(AND(SUM(D182:D184)<0,SUM(D182:D185)>0)=TRUE,4,IF(AND(SUM(D182:D183)<0,SUM(D182:D184)>0)=TRUE,3,IF(AND(SUM(D182:D182)<0,SUM(D182:D183)>0)=TRUE,2,1)))))","v":1}]
["Additional Benefits for Consideration"]
["(See manual for more information)"]
["In-Car Video (IVC) Integration)"]
["Investigation"]
["Civil Litigation and Settlement Costs"]
["Anticipated Reductions or Increases in Arrests and Citations"]
["Anticipated Reductions in Officer Assaults and Injuries"]
["Officer Wellness"]
["Impact on Insurance Costs"]
["Trust and Perception"]
["Training and Development"]
["Save, Reset, and Clear"]

{"sheet":"BWC Storage","index":1,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,0,45,5],[11,0,11,5],[37,0,37,5],[10,1,10,5],[0,0,0,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[2,4,4,5]]}
["BWC Storage Estimator"]
["Worksheet Key"]
[null,"Leave Blank",null,null,"Please note: This worksheet is intended to help agencies calcualte the amount of storage required for their BWC videos on an annual and 5 year basis.  \nIt is intented for  use by agencies considering self storage of their BWC video files and/or paying for cloud storage by the TB. "]
[null,"Required User Input"]
[null,"Automatically Calculated Result"]
["Agency Information"]
["Agency Name",{"$f":"IF('BWC Costs'!B8:F8>0,'BWC Costs'!B8:F8,\"\")","v":"Example Agency"}]
["Agency Address",{"$f":"IF('BWC Costs'!B9:F9>0,'BWC Costs'!B9:F9,\"\")","v":""}]
["Agency City",{"$f":"IF('BWC Costs'!B10:F10>0,'BWC Costs'!B10:F10,\"\")","v":""}]
["Agency State",{"$f":"IF('BWC Costs'!B11:F11>0,'BWC Costs'!B11:F11,\"\")","v":""}]
["Agency Zip",{"$f":"IF('BWC Costs'!B12:F12>0,'BWC Costs'!B12:F12,\"\")","v":""}]
["Storage Inputs"]
["Questions",null,null,null,null,"Comments & Explanations"]
["Number of sworn officers",{"$f":"'BWC Costs'!B15","v":1500},null,null,null,"Enter the number of officers that will be using BWCs. "]
["Number of BWCs to be purchased and deployed",{"$f":"'BWC Costs'!B16","v":1500},null,null,null,"Enter the number of BWCs to be fielded. "]
[]
[null,null,null,null,null,"Unless purchases spread over multiple years, we will compute a five-year total cost of ownership, with all purchases in year one. "]
[]
[]
[]
[]
["Category","Questions",{"$f":"IF(C23>0,C23,\"Vendor 1\")","v":"BWC, Inc."},{"$f":"IF(D23>0,D23,\"Vendor 2\")","v":"Vendor 2"},{"$f":"IF(E23>0,E23,\"Vendor 3\")","v":"Vendor 3"},"Comments & Explanations"]
["Vendor Name(s)","Enter Vendor Names","BWC, Inc.",null,null,"Enter name(s) of vendors being considered as Vendor 1, Vendor 2, or Vendor 3 under the appropriate column. "]
["Number of BWCs purchased and deployed per Year","Number of officers with BWC per Year",null,null,null,"This section will automatically populate unless you selected \"I want to manually input purchase costs across five years\" under the \"Purchase Cost Distribution\" question. "]
[null,"Year 1",1500,1500,1500]
[null,"Year 2",0,0,0]
[null,"Year 3",0,0,0]
[null,"Year 4",0,0,0]
[null,"Year 5",0,0,0]
["Storage Needs","Storage Needs"]
[null,"Resolution","Standard Definition – 480p","Medium Definition – 720p","High Definition – 1080p ","Select the resolution you will be using for each vendor (or comparing across one vendor). "]
[null,"Hourly bandwidth (GBs/Hour of Video)",0.5,2.5,5,"Enter the bandwidth for one hour in gigabytes. "]
[null,"# of shifts/officer/week",4,{"$f":"C33","v":4},{"$f":"C33","v":4},"Enter the estimated average number of shifts per officer per week"]
[null,"# of hours of video per officer per shift",3,{"$f":"C34","v":3},{"$f":"C34","v":3},"Enter the estimated average number of hours of video per officer per shift."]
[null,"Minimum retention requirements (in days)",30,{"$f":"C35","v":30},{"$f":"C35","v":30},"Enter the minimum retention requirements in days. "]
[null,"Percent of Videos that can be deleted at minimum retention",0.2,{"$f":"C36","v":0.2},{"$f":"C36","v":0.2},"Enter the percent of videos that can be deleted at the minimum retention provided above."]
["Hidden Row (For Calculations)",null,{"$f":"PRODUCT(C32:C34)","v":6},{"$f":"PRODUCT(D32:D34)","v":30},{"$f":"PRODUCT(E32:E34)","v":60},"This row is intended for calculations only. No user input is required"]
["Cumulative Storage"]
["Storage per Year","Year",{"$f":"C22","v":"BWC, Inc."},{"$f":"D22","v":"Vendor 2"},{"$f":"E22","v":"Vendor 3"},"Comments & Explanations"]
[null,"Year 1",{"$f":"IFERROR(IF(C$35<365, ((52*C37*C25)-((C$36)*((52-((C$35/7)))*C37*C$25))),(52*C37*C$25)), \"\")","v":382114.28571428568},{"$f":"IFERROR(IF(D$35<365, ((52*D37*D25)-((D$36)*((52-((D$35/7)))*D37*D$25))),(52*D37*D$25)), \"\")","v":1910571.4285714286},3821142.8571428573,"This is the amount of storage in gigabytes accumulated in year one. "]
[null,"Year 2",{"$f":"IFERROR(C40+IF(C$35>(365*2),(52*C$37*(C25+C26)),IF(C$35>365,(52*C$37*(C25+C26))-(C$36*C40),((1-C$36)*(52*C$37*C25+C26)-((C$36)*((52-(C$35/7))*C$37*C26))))),\"\")","v":756514.28571428568},{"$f":"IFERROR(D40+IF(D$35>(365*2),(52*D$37*(D25+D26)),IF(D$35>365,(52*D$37*(D25+D26))-(D$36*D40),((1-D$36)*(52*D$37*D25+D26)-((D$36)*((52-(D$35/7))*D$37*D26))))),\"\")","v":3782571.4285714286},7565142.8571428573,"This is the amount of storage in gigabytes accumulated in years one and two.  "]
[null,"Year 3",{"$f":"IFERROR(C41+IF(C$35>(365*3),(52*C$37*(C25+C26+C27)),IF(C$35>(365*2),(52*C$37*(C25+C26+C27))-(C$36*C41),((1-C$36)*(52*C$37*(C25+C26+C27))-((C$36)*((52-(C$35/7))*C$37*C27))))),\"\")","v":1130914.2857142857},{"$f":"IFERROR(D41+IF(D$35>(365*3),(52*D$37*(D25+D26+D27)),IF(D$35>(365*2),(52*D$37*(D25+D26+D27))-(D$36*D41),((1-D$36)*(52*D$37*(D25+D26+D27))-((D$36)*((52-(D$35/7))*D$37*D27))))),\"\")","v":5654571.4285714291},11309142.857142858,"This is the amount of storage in gigabytes accumulated in from year one to three.  "]
[null,"Year 4",{"$f":"IFERROR(C42+IF(C$35>(365*4),(52*C$37*(C25+C26+C27+C28)),IF(C$35>(365*3),(52*C$37*(C25+C26+C27+C28))-(C$36*C42),((1-C$36)*(52*C$37*(C25+C26+C27+C28))-((C$36)*((52-(C$35/7))*C$37*C28))))),\"\")","v":1505314.2857142857},{"$f":"IFERROR(D42+IF(D$35>(365*4),(52*D$37*(D25+D26+D27+D28)),IF(D$35>(365*3),(52*D$37*(D25+D26+D27+D28))-(D$36*D42),((1-D$36)*(52*D$37*(D25+D26+D27+D28))-((D$36)*((52-(D$35/7))*D$37*D28))))),\"\")","v":7526571.4285714291},15053142.857142858,"This is the amount of storage in gigabytes accumulated in year one to four  "]
[null,"Year 5",{"$f":"IFERROR(C43+IF(C$35>(365*5),(52*C$37*(C25+C26+C27+C28+C29)),IF(C$35>(365*4),(52*C$37*(C25+C26+C27+C28+C29))-(C$36*C43),((1-C$36)*(52*C$37*(C25+C26+C27+C28+C29))-((C$36)*((52-(C$35/7))*C$37*C29))))),\"\")","v":1879714.2857142857},{"$f":"IFERROR(D43+IF(D$35>(365*5),(52*D$37*(D25+D26+D27+D28+D29)),IF(D$35>(365*4),(52*D$37*(D25+D26+D27+D28+D29))-(D$36*D43),((1-D$36)*(52*D$37*(D25+D26+D27+D28+D29))-((D$36)*((52-(D$35/7))*D$37*D29))))),\"\")","v":9398571.4285714291},18797142.857142858,"This is the amount of storage in gigabytes accumulated in year one to five.  "]
[null,"Storage per each remaining year",{"$f":"IFERROR((1-C$36)*(C$33*50*$B$14*C$34*C$32),\"\")","v":360000},{"$f":"IFERROR((1-D$36)*(D$33*50*$B$14*D$34*D$32),\"\")","v":1800000},3600000,"This is the amount of storage in gigabytes accumulated per year after full deployment if minimum retention is less then five years days. "]
["Save and Clear"]

{"sheet":"Lists","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Yes",null,"Standard Definition – 480p"]
["No",null,"Medium Definition – 720p"]
["Sometimes",null,"High Definition – 1080p "]
["Don’t Know"]