{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Title","Assumptions","Epi-demographic","Cost_dog_vax_aid","Default_data","Cost_dog_vax_example","Flowchart","Calculations"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":1,"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","index":0,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,1,12,3]]}
[null,"Technical Appendix. Article link: https://wwwnc.cdc.gov/EID/article/23/12/17-1148-htm"]
[]
[]
[]
[]
[null,"Planning aid for the control of dog-mediated human rabies deaths based on dog vaccination*"]
[null,"Tool based on the article by Wallace et al. 2017  Front. Vet. Sci. 4:9. doi: 10.3389/fvets.2017.00009‡"]
[null,"Government perspective"]
[]
[null,{"$f":"Assumptions!D4","v":"2017-09-04"}]
[]
[]
[null,"Authors:†                       Ryan M. Wallace, Eduardo A. Undurraga, Jesse D. Blanton, M. Meltzer"]
[]
[]
[null,"*This spreasheet is a beta test version. It has not been officially cleared by the funding agency. The use of this version is for testing purposes only. The methodology used, findings, and conclusions produced from this software are those of the authors and do not necessarily represent the views of the Centers for Disease Control and Prevention."]
[null,"‡ Available in this link"]
[null,"† Preliminary order of authors. "]

{"sheet":"Assumptions","index":1,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Title!B6","v":"Planning aid for the control of dog-mediated human rabies deaths based on dog vaccination*"}]
[null,null,{"$f":"Title!B7","v":"Tool based on the article by Wallace et al. 2017  Front. Vet. Sci. 4:9. doi: 10.3389/fvets.2017.00009‡"}]
[]
[null,null,"Updated:","2017-09-04"]
[null,null,"Study perspective:","Government "]
[]
[null,null,"Note:","The default values correspond to country estimates in Wallace et al. 2017"]
[]
[null,null,"Instructions:",null,"Blue tabs indicate sheets were program data are required"]
[]
[null,null,null,null,"White cell: user can modify content"]
[null,null,null,null,"Grey cell: do not modify content"]
[null,null,"Main assumptions"]
[null,1,"70% of the dog population has to be vaccinated annually for 5-7 years to eliminate dog rabies, as per WHO recommendations and some evidence (WHO 2013, Coleman et al. 1996, Cleaveland et la. 2003). There may be some variation by setting that we are not considering (Kitala et al. 2001)"]
[null,{"$f":"B14+1","v":2},"Dog vaccination coverage estimates by Hampson et al. 2015, are reasonably accurate."]
[null,3,"Regional human to dog ratios estimated by Knobel et al. 2005 are representative of countries in each region."]
[null,4,"Countries where rabies has been eliminated from specific regions within the country (e.g., Brazil) still require national vaccination coverage."]
[null,5,"The time frames presented in the GDREP accurately reflect a country’s progression towards elimination."]
[null,6,"All countries commit to dog rabies elimination at year one of GDREP and move through the phases as predicted"]
[null,7,"After 7 years of vaccination of 70% of dog population, we consider the country rabies free and do not longer estimate dog vaccination maintenance costs. "]
[null,8,"Vaccination capacity: all public health veterinary work force would be willing / able to do dog vaccinations, and veterinary workers can move within countries at ease. We assume the workforce reported by OIE is reasonably accurate."]
[]
[null,null,"References in the spreadsheet"]
[null,1,"Cleaveland S, Kaare M, Tiringa P, Mlengeya T, Barrat J. A dog rabies vaccination campaign in rural Africa: impact on the incidence of dog rabies and human dog-bite injuries. Vaccine (2003) 21(17):1965-73."]
[null,{"$f":"B24+1","v":2},"Coleman PG, Dye C. Immunization coverage required to prevent outbreaks of dog rabies. Vaccine (1996) 14(3):185-6."]
[null,{"$f":"B25+1","v":3},"Hampson K, Coudeville L, Lembo T, Sambo M, Kieffer A, Attlan M, et al. Estimating the Global Burden of Endemic Canine Rabies. PLoS Negl Trop Dis (2015) 9(4):e0003709."]
[null,4,"Hatch B, Anderson A, Sambo M, Maziku M, Mchau G, Mbunda E, et al. Towards Canine Rabies Elimination in South‐Eastern Tanzania: Assessment of Health Economic Data. Transbound Emerg Dis (2016)."]
[null,5,"Kaare M, Lembo T, Hampson K, Ernest E, Estes A, Mentzel C, et al. Rabies control in rural Africa: evaluating strategies for effective domestic dog vaccination. Vaccine (2009) 27(1):152-60."]
[null,6,"Kayali U, Mindekem R, Hutton G, Ndoutamia A, Zinsstag J. Cost‐description of a pilot parenteral vaccination campaign against rabies in dogs in N'Djaména, Chad. Trop Med Int Health (2006) 11(7):1058-65."]
[null,7,"Kitala P, McDermott J, Kyule M, Gathuma J, Perry B, Wandeler A. Dog ecology and demography information to support the planning of rabies control in Machakos District, Kenya. Acta Trop (2001) 78(3):217-30."]
[null,8,"Knobel DL, Cleaveland S, Coleman PG, Fèvre EM, Meltzer MI, Miranda MEG, et al. Re-evaluating the burden of rabies in Africa and Asia. Bull WHO (2005) 83(5):360-8."]
[null,9,"Lapiz SMD, Miranda MEG, Garcia RG, Daguro LI, Paman MD, Madrinan FP, et al. Implementation of an intersectoral program to eliminate human and canine rabies: the Bohol Rabies Prevention and Elimination Project. PLoS Negl Trop Dis (2012) 6(12):e1891."]
[null,10,"Tenzin, Wangdi K, Ward MP. Human and animal rabies prevention and control cost in Bhutan, 2001–2008: The cost–benefit of dog rabies elimination. Vaccine (2012) 31(1):260-70."]
[null,11,"US Department of Commerce BoEA. National income and product account tables. Table 1.1.9 Implicit price deflators for Gross Domestic Product (2015) [cited 2015 22 December]. Available from: http://www.bea.gov/iTable/iTable.cfm?reqid=9&step=3&isuri=1&903=13#reqid=9&step=3&isuri=1&904=2000&903=13&906=a&905=2015&910=x&911=0 "]
[null,12,"Vigilato MAN, Clavijo A, Knobl T, Silva HMT, Cosivi O, Schneider MC, et al. Progress towards eliminating canine rabies: policies and perspectives from Latin America and the Caribbean. Philos Trans R Soc, Ser B: Biol Sci (2013) 368(1623):20120143."]
[null,13,"Wallace RM, Undurraga EA, Blanton JD, Cleaton J and Franka R (2017). Elimination of Dog-Mediated Human Rabies Deaths by 2030: Needs Assessment and Alternatives for Progress Based on Dog Vaccination. Front. Vet. Sci. 4:9. doi: 10.3389/fvets.2017.00009\n\n"]
[null,14,"World Bank. World Bank Open Data (2016) [cited 2016 October 10]. Available from: http://data.worldbank.org/indicator/SP.URB.TOTL.IN.ZS."]
[null,15,"World Health Organization. WHO Expert Consultation on Rabies. Second Report Geneva(2013) [cited 2016 30 March]. Available from: http://apps.who.int/iris/bitstream/10665/85346/1/9789240690943_eng.pdf."]

{"sheet":"Epi-demographic","index":2,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[6,2,6,3]]}
[]
[null,"Demographic, epidemiological, and cost input variables",null,null,null,null,"Summary of results from the analysis: dog vaccination campaign"]
[null,"Model Variable","Input values","Default values"]
[]
[null,"Select country","Kenya",{"$f":"VLOOKUP(C5,Default_data!$A$2:$M$194, 2, FALSE)","v":"KEN"},null,null,"Resources needed (annual)"]
[null,null,null,null,null,null,"Total dog population",{"$f":"C16","v":5169798.054716981}]
[null,"Discount rate (health outcomes & costs)",0,null,null,null,"Dogs vaccinated",{"$f":"H6*C20","v":258489.90273584906}]
[null,null,null,null,null,null,"Dogs unvaccinated",{"$f":"H6-H7","v":4911308.1519811321}]
[null,"Demographics",null,null,null,null,"Number of additional vaccinated dogs required",{"$f":"H6*C21-H7","v":3360368.7355660377}]
[null,"Human population",46050302,{"$f":"VLOOKUP(D5,Default_data!$B$2:$M$194, 2, FALSE)","v":46050302},null,null,"Average cost per dog vaccinated",{"$f":"Cost_dog_vax_aid!J5","v":1.8080000000000001}]
[null,"Percent urban",0.26,{"$f":"VLOOKUP(D5,Default_data!$B$2:$M$194, 3, FALSE)","v":0.25622},null,null,"Estimated years until elimination",{"$f":"IF(C20<(0.25*Flowchart!H20),Flowchart!H21+6,IF(C20<0.5*Flowchart!H20,Flowchart!H21+3,IF(C20<0.75*Flowchart!H20,Flowchart!H21+2,IF(C20<Flowchart!H20,Flowchart!H21+1,7))))","v":13}]
[null,"Urban population",{"$f":"C10*C11","v":11973078.52},{"$f":"D10*D11","v":11799008.37844},null,null,"Vaccinators needed during peak campaign years",{"$f":"C32","v":1723.2660182389936}]
[null,"Rural population",{"$f":"C10-C12","v":34077223.480000004},{"$f":"D10-D12","v":34251293.62156},null,null,"Total costs to eliminate"]
[null,"Number of humans per dog, urban areas",21.2,{"$f":"VLOOKUP(D5,Default_data!$B$2:$M$194, 4, FALSE)","v":21.2},null,null,"Net present value (NPV) Phase I",{"$f":"IF(C20<Flowchart!F16, SUM(Calculations!C7:E7)*'Epi-demographic'!H7+'Epi-demographic'!H9*SUM(Calculations!C7:E7)*Calculations!C23, 0)","v":3224713.2346102642}]
[null,"Number of humans per dog, rural areas",7.4,{"$f":"VLOOKUP(D5,Default_data!$B$2:$M$194, 5, FALSE)","v":7.4},null,null,"Net present value Phase II",{"$f":"IF(C21=0,0,IF(C20<Flowchart!F16,Flowchart!H16*Calculations!F7*'Epi-demographic'!H6+Calculations!C23*Calculations!F7*('Epi-demographic'!C21-Flowchart!H16)*'Epi-demographic'!H6+Calculations!G7*Flowchart!H17*'Epi-demographic'!H6+Calculations!C23*('Epi-demographic'!C21-Flowchart!H17)*Calculations!G7*'Epi-demographic'!H6+Calculations!H7*Flowchart!H18*'Epi-demographic'!H6+Calculations!C23*Calculations!H7*('Epi-demographic'!C21-Flowchart!H18)*'Epi-demographic'!H6, IF('Epi-demographic'!C20>='Epi-demographic'!C21,0,IF('Epi-demographic'!C20<'Epi-demographic'!C21,IF('Epi-demographic'!C20>=Flowchart!F18, 'Epi-demographic'!C20*Calculations!C7*'Epi-demographic'!H6+Calculations!C23*('Epi-demographic'!C21-'Epi-demographic'!C20)*Calculations!C7*'Epi-demographic'!H6, IF('Epi-demographic'!C20>=Flowchart!F17,'Epi-demographic'!C20*Calculations!C7*'Epi-demographic'!H6+Calculations!C23*('Epi-demographic'!C21-'Epi-demographic'!C20)*'Epi-demographic'!H6*Calculations!C7+Calculations!D7*Flowchart!H18*'Epi-demographic'!H6+Calculations!C23*Calculations!D7*('Epi-demographic'!C21-Flowchart!H18)*'Epi-demographic'!H6, IF('Epi-demographic'!C20>=Flowchart!F16, Calculations!C7*'Epi-demographic'!C20*'Epi-demographic'!H6+Calculations!C23*Calculations!C7*('Epi-demographic'!C21-'Epi-demographic'!C20)*'Epi-demographic'!H6+Calculations!D7*Flowchart!H17*'Epi-demographic'!H6+Calculations!C23*Calculations!D7*('Epi-demographic'!C21-Flowchart!H17)*'Epi-demographic'!H6+Calculations!E7*Flowchart!H18*'Epi-demographic'!H6+Calculations!C23*Calculations!E7*('Epi-demographic'!C21-Flowchart!H18)*'Epi-demographic'!H6, \"error\")))))))","v":13004006.630873999}]
[null,"Total dog population",{"$f":"C12/C14+C13/C15","v":5169798.054716981},{"$f":"$D$12/$D$14+$D$13/$D$15","v":5185110.1910857214},null,null,"Net present value Phase III",{"$f":"IF('Epi-demographic'!C20>='Epi-demographic'!C21,SUM(Calculations!C7:I7)*'Epi-demographic'!H6*'Epi-demographic'!C21, IF(C20<Flowchart!F16,SUM(Calculations!I7:O7)*H6*C21, IF(C20>=Flowchart!F18, SUM(Calculations!D7:J7)*H6*C21, IF(C20>=Flowchart!F17, SUM(Calculations!E7:K7)*'Epi-demographic'!H6*'Epi-demographic'!C21, IF(C20>=Flowchart!F16,SUM(Calculations!F7:L7)*H6*C21, \"error\")))))","v":45800274.926348679}]
[null,null,null,null,null,null,"NPV of dog rabies elimination (average)",{"$f":"SUM(H14:H16)","v":62028994.791832939}]
[null,null,null,null,null,null,"NPV of dog rabies elimination (lower-upper)",{"$f":"CONCATENATE(\"(\",TEXT(Calculations!P47,\"$#,##\"),\" - \",TEXT(Calculations!P60,\"$#,##\"),\")\")","v":"($50,615,843 - $72,755,985)"}]
[null,"Dog vaccination",null,null,null,null,"Additional costs to government",{"$f":"Calculations!P19","v":55953448.117929555}]
[null,"Current dog rabies vaccination coverage (%)",0.05,{"$f":"VLOOKUP(D5,Default_data!$B$2:$M$194, 6, FALSE)","v":5.0000000000000001E-3},null,null,"Range (lower-upper)",{"$f":"CONCATENATE(\"(\",TEXT(Calculations!P48,\"$#,##\"),\" - \",TEXT(Calculations!P61,\"$#,##\"),\")\")","v":"($45,658,179 - $65,629,763)"}]
[null,"Goal: annual coverage of dog population (%)",0.7,{"$f":"Flowchart!H20","v":0.7}]
[null,"Total dogs currently vaccinated per year",{"$f":"C20*C16","v":258489.90273584906},{"$f":"D20*D16","v":25925.550955428607}]
[null,"Dogs to reach vaccination goal",{"$f":"C21*C16-C22","v":3360368.7355660377},{"$f":"D21*D16-D22","v":3603651.582804576}]
[]
[null,"Vaccination campaign logistics"]
[null,"Vaccinators available",4300,{"$f":"VLOOKUP(D5,Default_data!$B$2:$M$194, 10, FALSE)","v":1207}]
[null,"Dogs vaccinated per vaccinator per day (rate)",100,100]
[null,"Campaign vaccination days",21,25,null,null," "]
[null,"Estimated dogs vaccinated during campaign",{"$f":"C28*C27*C26","v":9030000},{"$f":"D28*D27*D26","v":3017500}]
[null,"Additional vaccinators needed to reach goal",{"$f":"IF((C21*C16-C29)/(C27*C28)<0,\"Enough\", (C21*C16-C29)/(C27*C28))","v":"Enough"},{"$f":"IF((D21*D16-D29)/(D27*D28)<0,\"Enough\", (D21*D16-D29)/(D27*D28))","v":244.83085350400191}]
[null,"Vaccination rate needed to reach goal",{"$f":"(C21*C16)/C26/C28","v":40.075953912534736},{"$f":"(D21*D16)/D26/D28","v":120.28424635492973}]
[null,"Vaccinators to reach vaccination goal at peak‡",{"$f":"(C21*C16)/C27/C28","v":1723.2660182389936},{"$f":"(D21*D16)/D27/D28","v":1451.8308535040019}]
[]
[null,"Vaccination campaign costs per vaccinated dog*"]
[null,"Average cost per dog vaccinated"]
[]
[null,"Notes:"]
[null,"* Use cost_dog_vax help worksheet to estimate vaccination campaign costs (best cost estimate, and lower and upper bounds)"]
[null,"† Net dog vaccination capacity shows the maximum vaccination capacity of the country (total dogs per year) minus the number of dogs that the country needs to vaccinate. Thus is the number is positive, the country has enough capacity; if negative, the country needs more vaccinators, increased vaccination efficiency, or more campaign days. The estimated annual costs are based on the cost per dog vaccinated; excess vaccinator capacity is not included in the aggregate costs."]
[null,"‡ Minimum number of dog vaccinators that would be needed annually when the vaccination program is operating at its goal of dog population coverage (e.g., 70%) at the dog vaccination rate estimated (dogs per vaccinator per day). See \"calculations worksheet\" for yearly estimates."]
[]
[null,"References used in the worksheet"]
[null,"Hampson K, Coudeville L, Lembo T, Sambo M, Kieffer A, Attlan M, et al. Estimating the Global Burden of Endemic Canine Rabies. PLoS Negl Trop Dis (2015) 9(4):e0003709."]
[null,"Knobel DL, Cleaveland S, Coleman PG, Fèvre EM, Meltzer MI, Miranda MEG, et al. Re-evaluating the burden of rabies in Africa and Asia. Bull WHO (2005) 83(5):360-8."]
[null,"Vigilato MAN, Clavijo A, Knobl T, Silva HMT, Cosivi O, Schneider MC, et al. Progress towards eliminating canine rabies: policies and perspectives from Latin America and the Caribbean. Philos Trans R Soc, Ser B: Biol Sci (2013) 368(1623):20120143."]
[null,"World Bank. World Bank Open Data (2016) [cited 2016 October 10]. Available from: http://data.worldbank.org/indicator/SP.URB.TOTL.IN.ZS."]
[null,"World Health Organization. WHO Expert Consultation on Rabies. Second Report Geneva(2013) [cited 2016 30 March]. Available from: http://apps.who.int/iris/bitstream/10665/85346/1/9789240690943_eng.pdf."]

{"sheet":"Cost_dog_vax_aid","index":3,"n_rows":114,"n_cols":11,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Costs per dog vaccination campaign",null,null,null,null,null,null,null,"Total"]
[null,"Summary of dog vaccination costs (per dog vaccinated)",null,null,null,null,null,null,"Lower bound ","Average","Upper bound"]
[]
[null,"Cost per dog vaccinated (user input; these values determine all cost estimates)*",null,null,null,null,null,null,1.4753333333333334,1.8080000000000001,2.1206666666666671]
[]
[]
[null,"Instructions:",null,null,null,"Examples of cost estimates of cost per dog vaccinated from previous studies"]
[null,"Enter your best estimate, including lower and upper bounds, ",null,null,null,"Location",null,null,null,"Author","Estimate (US$)"]
[null,"of the average cost to vaccinate a dog in the white cells in this panel.",null,null,null,"N'Djamena, Chad",null,null,null,"Kayali et al 2006",2.38]
[null,"These estimates will inform all the cost calculations in GDREP.",null,null,null,"Rural Tanzania (pastoralist and agro-pastolarist villages)",null,null,null,"Kaare et al 2009",2.39]
[null,"If you need help to estimate these values, use the tables",null,null,null,"Petchabun, Thailand",null,null,null,"Knobel et al 2005",1.6]
[null,"below with data from a dog vaccination campaign. ",null,null,null,"Dar es Salaam, Tanzania",null,null,null,"Hatch et al 2016",8.67]
[null,"There are a few estimates of the costs to vaccinate a dog",null,null,null,"Bohol, Visayas Islands, Philippines",null,null,null,"Lapiz et al 2012",1.76]
[null,"in the table at the right of the panel.",null,null,null,"Bhutan",null,null,null,"Tenzin et al 2012",1.93]
[null,null,null,null,null,"All costs shown in this table are in 2015 US dollars using US GDP implicit price deflators. "]
[]
[null,"Costs per dog vaccination campaign - user aid tables",null,null,null,null,null,null,null,"Total"]
[null,"Summary of dog vaccination costs based on calculation tables (per dog vaccinated)",null,null,null,null,null,null,"Lower bound ","Average","Upper bound"]
[]
[null,"Total dogs vaccinated in pilot campaign (user input)",null,null,null,null,null,null,null,45000]
[]
[null,"Average cost per dog vaccinated (calculated using worksheet)",null,null,null,null,null,null,{"$f":"I100","v":1.4753333333333334},{"$f":"J100","v":1.8080000000000001},{"$f":"K100","v":2.1206666666666671}]
[]
[null,"Human resources",null,null,null,null,null,null,{"$f":"I34/$J$21","v":0.30444444444444446},{"$f":"J34/$J$21","v":0.31388888888888888},{"$f":"K34/$J$21","v":0.32333333333333331}]
[null,"Transport costs",null,null,null,null,null,null,{"$f":"I47/$J$21","v":0.1},{"$f":"J47/$J$21","v":0.14333333333333334},{"$f":"K47/$J$21","v":0.18666666666666668}]
[null,"Awareness campaign",null,null,null,null,null,null,{"$f":"I58/$J$21","v":7.955555555555556E-2},{"$f":"J58/$J$21","v":0.10311111111111111},{"$f":"K58/$J$21","v":0.12666666666666668}]
[null,"Equipment at vaccination point",null,null,null,null,null,null,{"$f":"I66/$J$21","v":1.3333333333333334E-2},{"$f":"J66/$J$21","v":1.6666666666666666E-2},{"$f":"K66/$J$21","v":0.02}]
[null,"Dog vaccinations (consumables)",null,null,null,null,null,null,{"$f":"I96/$J$21","v":0.9780000000000002},{"$f":"J96/$J$21","v":1.2310000000000001},{"$f":"K96/$J$21","v":1.4640000000000004}]
[]
[null,"Economic cost of vaccination campaign*","Units","Work days",null,"Price/Unit",null,null,null,"Total cost"]
[null,"Item",null,null,"Lower bound ","Average","Upper bound",null,"Lower bound ","Average","Upper bound"]
[]
[null,"Workers participating in campaign (per diem)",null,null,null,null,null,null,{"$f":"SUM(I36:I45)","v":13700},{"$f":"SUM(J36:J45)","v":14125},{"$f":"SUM(K36:K45)","v":14550}]
[]
[null,"Training supervisor",3,10,70,75,80,null,{"$f":"E36*$D36*$C36","v":2100},{"$f":"F36*$D36*$C36","v":2250},{"$f":"G36*$D36*$C36","v":2400}]
[null,"Informational supervisor",0,0,null,null,null,null,{"$f":"E37*$D37*$C37","v":0},0,0]
[null,"Vaccination supervisor",3,10,40,42.5,45,null,1200,1275,1350]
[null,"Training technician",0,0,null,null,null,null,0,0,0]
[null,"Informational technician",0,0,null,null,null,null,0,0,0]
[null,"Vaccination Technician",96,10,10,10,10,null,9600,9600,9600]
[null,"Driver",2,10,40,50,60,null,800,1000,1200]
[null,"Other personnel 1",0,0,null,null,null,null,{"$f":"E43*$D43*$C43","v":0},{"$f":"F43*$D43*$C43","v":0},{"$f":"G43*$D43*$C43","v":0}]
[null,"Other personnel 2",0,0,null,null,null,null,0,0,0]
[null,"Other personnel 3",0,0,null,null,null,null,0,0,0]
[]
[null,"Transportation and logistics",null,null,null,null,null,null,{"$f":"SUM(I49:I56)","v":4500},{"$f":"SUM(J49:J56)","v":6450},{"$f":"SUM(K49:K56)","v":8400}]
[]
[null,"Pick up (including gasoline)",42,10,5,7.5,10,null,{"$f":"E49*$D49*$C49","v":2100},{"$f":"F49*$D49*$C49","v":3150},{"$f":"G49*$D49*$C49","v":4200}]
[null,"Vehicle",0,0,null,null,null,null,{"$f":"E50*$D50*$C50","v":0},0,0]
[null,"Gasoline",6,10,30,40,50,null,1800,2400,3000]
[null,"Maintenance vehicle",6,10,10,15,20,null,600,900,1200]
[null,"Public transport",0,0,null,null,null,null,{"$f":"E53*$D53*$C53","v":0},{"$f":"F53*$D53*$C53","v":0},{"$f":"G53*$D53*$C53","v":0}]
[null,"Other transportation costs 1",0,0,null,null,null,null,0,0,0]
[null,"Other transportation costs 2",0,0,null,null,null,null,{"$f":"E55*$D55*$C55","v":0},{"$f":"F55*$D55*$C55","v":0},{"$f":"G55*$D55*$C55","v":0}]
[null,"Other transportation costs 3",0,0,null,null,null,null,0,0,0]
[]
[null,"Awareness campaign ",null,null,null,null,null,null,{"$f":"SUM(I60:I64)","v":3580},{"$f":"SUM(J60:J64)","v":4640},{"$f":"SUM(K60:K64)","v":5700}]
[]
[null,"Media (e.g. posters)",2000,"N/A",0.8,1,1.2,null,{"$f":"E60*$C60","v":1600},{"$f":"F60*$C60","v":2000},{"$f":"G60*$C60","v":2400}]
[null,"Air time (radio, car with speakers, etc.)",1,22,90,120,150,null,{"$f":"E61*$D61*$C61","v":1980},{"$f":"F61*$D61*$C61","v":2640},{"$f":"G61*$D61*$C61","v":3300}]
[null,"Other communication & awareness costs 1",0,0,null,null,null,null,{"$f":"E62*$D62*$C62","v":0},{"$f":"F62*$D62*$C62","v":0},{"$f":"G62*$D62*$C62","v":0}]
[null,"Other communication & awareness costs 2",0,0,null,null,null,null,0,0,0]
[null,"Other communication & awareness costs 3",0,0,null,null,null,null,{"$f":"E64*$D64*$C64","v":0},{"$f":"F64*$D64*$C64","v":0},{"$f":"G64*$D64*$C64","v":0}]
[]
[null,"Equipment at vaccination point",null,null,null,null,null,null,{"$f":"SUM(I68:I74)","v":600},{"$f":"SUM(J68:J74)","v":750},{"$f":"SUM(K68:K74)","v":900}]
[]
[null,"Tables",0,"N/A",null,null,null,null,{"$f":"E68*$C68","v":0},{"$f":"F68*$C68","v":0},{"$f":"G68*$C68","v":0}]
[null,"Coolers",0,"N/A",null,null,null,null,{"$f":"E69*$C69","v":0},0,0]
[null,"Dog handling (e.g., muzzles)",100,"N/A",2,2.5,3,null,200,250,300]
[null,"First-aid",100,"N/A",4,5,6,null,400,{"$f":"F71*$C71","v":500},600]
[null,"Other equipment / supplies 1",0,"N/A",null,null,null,null,{"$f":"E72*$C72","v":0},{"$f":"F72*$C72","v":0},{"$f":"G72*$C72","v":0}]
[null,"Other equipment / supplies 2",0,"N/A",null,null,null,null,0,0,0]
[null,"Other equipment / supplies 3",0,"N/A",null,null,null,null,0,0,0]
[]
[null,"Other costs associated with the campaign (per work day)",null,null,null,null,null,null,{"$f":"SUM(I78:I80)","v":0},{"$f":"SUM(J78:J80)","v":0},{"$f":"SUM(K78:K80)","v":0}]
[]
[null,"Other costs 1",0,0,null,null,null,null,{"$f":"E78*$D78*$C78","v":0},0,0]
[null,"Other costs 2",0,0,null,null,null,null,0,0,0]
[null,"Other costs 3",0,0,null,null,null,null,0,0,0]
[]
[]
[null,"Total fixed costs ",null,null,null,null,null,null,{"$f":"I34+I47+I58+I66+I76","v":22380},{"$f":"J34+J47+J58+J66+J76","v":25965},{"$f":"K34+K47+K58+K66+K76","v":29550}]
[]
[]
[null,"Dog vaccinations",null,null,null,null,null,null,{"$f":"SUM(I89:I94)","v":44010.000000000007},{"$f":"SUM(J89:J94)","v":55395.000000000007},{"$f":"SUM(K89:K94)","v":65880.000000000015}]
[]
[null,"Percent vaccine wastage",null,null,0.05,0.1,0.2]
[null,"Vaccines ",{"$f":"(1+F88)*J21","v":49500.000000000007},"N/A",0.74,0.91,1.08,null,{"$f":"E89*$C89","v":36630.000000000007},{"$f":"F89*$C89","v":45045.000000000007},{"$f":"G89*$C89","v":53460.000000000015}]
[null,"Syringes and needles",{"$f":"C89","v":49500.000000000007},"N/A",0.04,0.05,0.06,null,{"$f":"E90*$C90","v":1980.0000000000002},2475.0000000000005,2970.0000000000005]
[null,"Vaccination certificates",{"$f":"$J$21","v":45000},"N/A",0.08,0.125,0.15,null,3600,5625,6750]
[null,"Dog marking",{"$f":"$J$21","v":45000},"N/A",0.04,0.05,0.06,null,{"$f":"E92*$C92","v":1800},{"$f":"F92*$C92","v":2250},{"$f":"G92*$C92","v":2700}]
[null,"Other costs per dog vaccinated 1",{"$f":"$J$21","v":45000},"N/A",null,null,null,null,{"$f":"E93*$C93","v":0},{"$f":"F93*$C93","v":0},{"$f":"G93*$C93","v":0}]
[null,"Other costs per dog vaccinated 2",{"$f":"$J$21","v":45000},"N/A",null,null,null,null,0,0,0]
[]
[null,"Total variable costs",null,null,null,null,null,null,{"$f":"SUM(I89:I94)","v":44010.000000000007},{"$f":"SUM(J89:J94)","v":55395.000000000007},{"$f":"SUM(K89:K94)","v":65880.000000000015}]
[]
[]
[null,"Total costs",null,null,null,null,null,null,{"$f":"I96+I83","v":66390},{"$f":"J96+J83","v":81360},{"$f":"K96+K83","v":95430.000000000015}]
[null,"Average cost per dog vaccinated",null,null,null,null,null,null,{"$f":"I99/$J$21","v":1.4753333333333334},{"$f":"J99/$J$21","v":1.8080000000000001},{"$f":"K99/$J$21","v":2.1206666666666671}]
[]
[null,"Notes"]
[null,"* Costs have two components: (1) a measurement of the quantity used and (2) the unit cost of the resource. A pragmatic way of thinking about the costs in this sheet is to use the market prices for the resource used, i.e., the price one would have to pay for a resource during the dog vaccination campaign. For example:"]
[null,"A common question relates to the value of vehicles. One useful way of thinking about this cost is to estimate how much would it cost to rent a vehicle for the duration of the campaign (e.g., rental of a  pick-up truck for 20 days could be a good proxy because it includes maintainance, insurance, and depreciation)."]
[null,"Another common question relates to the value of the work of a person that participates only part-time on the campaign. One pragmatic way of estimating this cost would be to take the person's monthly salary/wage + fringe benefits and multiply by the proportion of time dedicated to the vaccination campaign. "]
[]
[null,"References used in the worksheet to estimate the average values utilized"]
[null,"Kayali U, Mindekem R, Hutton G, Ndoutamia A, Zinsstag J. Cost‐description of a pilot parenteral vaccination campaign against rabies in dogs in N'Djaména, Chad. Trop Med Int Health (2006) 11(7):1058-65."]
[null,"Kaare M, Lembo T, Hampson K, Ernest E, Estes A, Mentzel C, et al. Rabies control in rural Africa: evaluating strategies for effective domestic dog vaccination. Vaccine (2009) 27(1):152-60."]
[null,"Lapiz SMD, Miranda MEG, Garcia RG, Daguro LI, Paman MD, Madrinan FP, et al. Implementation of an intersectoral program to eliminate human and canine rabies: the Bohol Rabies Prevention and Elimination Project. PLoS Negl Trop Dis (2012) 6(12):e1891."]
[null,"Hatch B, Anderson A, Sambo M, Maziku M, Mchau G, Mbunda E, et al. Towards Canine Rabies Elimination in South‐Eastern Tanzania: Assessment of Health Economic Data. Transbound Emerg Dis (2016)."]
[null,"Knobel DL, Cleaveland S, Coleman PG, Fèvre EM, Meltzer MI, Miranda MEG, et al. Re-evaluating the burden of rabies in Africa and Asia. Bull WHO (2005) 83(5):360-8."]
[null,"Tenzin, Wangdi K, Ward MP. Human and animal rabies prevention and control cost in Bhutan, 2001–2008: The cost–benefit of dog rabies elimination. Vaccine (2012) 31(1):260-70."]
[null,"US Department of Commerce BoEA. National income and product account tables. Table 1.1.9 Implicit price deflators for Gross Domestic Product (2015) [cited 2015 22 December]. Available from: http://www.bea.gov/iTable/iTable.cfm?reqid=9&step=3&isuri=1&903=13#reqid=9&step=3&isuri=1&904=2000&903=13&906=a&905=2015&910=x&911=0 "]

{"sheet":"Default_data","index":4,"n_rows":200,"n_cols":13,"rows_kept":200,"cut":false,"hidden":true,"merged":[]}
["Country","ISO3","WB Human Pop 2015","WB Urban (%)","Urban H:D Ratio (Knoble)","Rural H:D Ration (Knoble)","Vax_coverage (Hampson)","Public Vet PubHealth Activities","Private Vet PubHealth Activities","PARA: Pub Hlth","All_PH_vacccinators","Paravet_PH","Years to elimination - best case scenario"]
["Afghanistan","AFG",32526562,0.26702999999999999,7.5,14.3,0.01,48,0,48,{"$f":"H2+I2+J2","v":96},{"$f":"J2","v":48},13]
["Albania","ALB",2889167,0.57406999999999997,6.5,6.5,0.46700000000000003,2.5994574079615962,0.42614055868222889,36.200640460055347,39.226238426699169,36.200640460055347,9]
["Algeria","DZA",39666519,0.70727000000000007,21.2,7.4,0.23699999999999999,1321,0,35,1356,35,10]
["Andorra","AND",70473,0.85114999999999996,6.5,6.5,0.7,5,0,10,15,10,7]
["Angola","AGO",25021974,0.44049999999999995,21.2,7.4,5.0000000000000001E-3,0,0,0,0,0,13]
["Antigua and Barbuda","ATG",91818,0.23773,7.5,7.5,0.55100000000000005,1.961157996167803,2.7896984298261783E-3,0.80343314778993924,2.7673808423875683,0.80343314778993924,8]
["Argentina","ARG",43416755,0.91751000000000005,7.5,7.5,0.20659920300000001,467,215,1151,1833,1151,10]
["Armenia","ARM",3017712,0.62673000000000001,6.5,6.5,0.46700000000000003,613,0,0,613,0,9]
["Australia","AUS",23781169,0.89422999999999997,7.5,14.3,0.7,190,25,886,1101,886,7]
["Austria","AUT",8611088,0.65968000000000004,6.5,6.5,0.7,214,0,0,214,0,7]
["Azerbaijan","AZE",9651349,0.54620000000000002,6.5,6.5,0.21099999999999999,4,0,0,4,0,10]
["Bahamas","BHS",388019,0.82873999999999992,7.5,7.5,0.55100000000000005,8.2877710744629027,1.1789148043332722E-2,3.3952746364798236,11.694834858986059,3.3952746364798236,8]
["Bahrain","BHR",1377237,0.88775000000000004,7.5,14.3,0.185,2,1,31,34,31,10]
["Bangladesh","BGD",160995642,0.34277000000000002,7.5,14.3,5.0849999999999999E-2,49.47195294540218,0,478.22887847222103,527.70083141762325,478.22887847222103,13]
["Barbados","BRB",284215,0.31475000000000003,7.5,7.5,0.55100000000000005,0,1,3,4,3,8]
["Belarus","BLR",9513000,0.76666999999999996,6.5,6.5,0.46700000000000003,8.5590892883445875,1.4031293915318994,119.19584181063487,129.15806049051136,119.19584181063487,9]
["Belgium","BEL",11285721,0.97858000000000001,6.5,6.5,0.7,233.06127991219975,89.71842317163086,199.96974203853239,522.749445122363,199.96974203853239,7]
["Belize","BLZ",359287,0.43973000000000001,7.5,7.5,0.68,1.3652144996484443,5.0771856478305075,0.23302799218137241,6.6754281396603243,0.23302799218137241,8]
["Benin","BEN",10879829,0.4395,21.2,7.4,8.0000000000000002E-3,1,0,13,14,13,13]
["Bhutan","BTN",774830,0.38644000000000001,7.5,14.3,0.1,5,0,77,82,77,13]
["Bolivia","BOL",10724705,0.68511999999999995,7.5,7.5,0.77664192899999995,107,61,239,407,239,7]
["Bosnia and Herzegovina","BIH",3810416,0.39767000000000002,6.5,6.5,0.46700000000000003,3.4283286838785694,0.56202109571779812,47.743692081226961,51.734041860823325,47.743692081226961,9]
["Botswana","BWA",2262485,0.57444000000000006,21.2,7.4,5.0000000000000001E-3,11,0,48,59,48,13]
["Brazil","BRA",207847528,0.85687000000000002,7.5,7.5,0.6885,1995,0,3614,5609,3614,8]
["Brunei Darussalam","BRN",423188,0.77201999999999993,7.5,14.3,0.7,1,0,15,16,15,7]
["Bulgaria","BGR",7177991,0.73947999999999992,6.5,6.5,0.46700000000000003,500,500,0,1000,0,9]
["Burkina Faso","BFA",18105570,0.29859000000000002,21.2,7.4,8.0000000000000002E-3,3,0,400,403,400,13]
["Burundi","BDI",11178921,0.12057000000000001,21.2,7.4,5.0000000000000001E-3,2,1,1523,1526,1523,13]
["C_te d'Ivoire","CIV",22701556,0.54179999999999995,21.2,7.4,8.0000000000000002E-3,93,0,315,408,315,13]
["Cambodia","CMR",15577899,0.20723,7.5,14.3,6.0000000000000001E-3,0,0,0,0,0,13]
["Cameroon","KHM",23344179,0.54381000000000002,21.2,7.4,8.0000000000000002E-3,16,0,0,16,0,13]
["Canada","CMR",35851774,0.81828000000000001,7.5,7.5,0.7,155.37833528851857,0,1366.3923957533041,1521.7707310418227,1366.3923957533041,7]
["Cape Verde","CPV",520502,0.65525999999999995,21.2,7.4,8.0000000000000002E-3,1,0,0,{"$f":"H34+I34+J34","v":1},{"$f":"J34","v":0},13]
["Central African Republic","CAF",4900274,0.40037,21.2,7.4,5.0000000000000001E-3,2,0,30,32,30,13]
["Chad","TCD",14037472,0.22470999999999999,21.2,7.4,8.0000000000000002E-3,211,0,200,411,200,13]
["Chile","CHL",17948141,0.89529999999999998,7.5,7.5,0.64800000000000002,199,21,272,492,272,8]
["China","CHN",1371220000,0.55613999999999997,48.3,48.3,0.14199999999999999,13748.616308605089,1028.916456664231,7608.0413548411743,22385.574120110494,7608.0413548411743,13]
["Colombia","COL",48228704,0.76436000000000004,7.5,7.5,0.73211786599999995,262,0,0,262,0,7]
["Comoros","COM",788474,0.28295999999999999,21.2,7.4,5.0000000000000001E-3,1.6033088648439136,0.62821301348228298,10.346395195960383,12.57791707428658,10.346395195960383,13]
["Congo","COG",4620330,0.65379999999999994,21.2,7.4,7.72227E-4,6,0,18,24,18,13]
["Cook Islands","COK",18027,1,7.5,14.3,0.7,0.20949065910573972,1.2608234112845446E-2,0.775406397939995,0.99750529115858022,0.775406397939995,7]
["Costa Rica","CRI",4807850,0.76820999999999995,7.5,7.5,0.22,21,128,25,174,25,10]
["Croatia","HRV",4224404,0.58963999999999994,6.5,6.5,0.46700000000000003,220,272,0,492,0,9]
["Cuba","CUB",11389562,0.77073999999999998,7.5,7.5,0.64644900000000005,571,0,260,831,260,8]
["Cyprus","CYP",1165300,0.66921000000000008,6.5,6.5,0.46700000000000003,30,5,41,76,41,9]
["Czech Republic","CZE",10551219,0.72992000000000001,6.5,6.5,0.46700000000000003,419,0,0,419,0,9]
["Denmark","DNK",5676002,0.87675999999999998,6.5,6.5,0.7,290,0,0,290,0,7]
["Djibouti","DJI",887861,0.77343000000000006,21.2,7.4,1E-3,3,2,15,20,15,13]
["Dominica","DMA",72680,0.69539000000000006,7.5,7.5,0.55100000000000005,1.5523858411365519,2.208230214987983E-3,0.63597030191653903,2.1905643732680788,0.63597030191653903,8]
["Dominican Republic","DOM",10528391,0.78980000000000006,7.5,7.5,0.26696276200000002,120,0,10,130,10,10]
["DRC","COD",77266814,0.42493999999999998,21.2,7.4,5.0000000000000001E-3,100,7,128,235,128,13]
["Ecuador","ECU",16144363,0.63741999999999999,7.5,7.5,0.78477691599999999,160,150,320,630,320,7]
["Egypt","EGY",91508084,0.43134999999999996,21.2,7.4,0.23699999999999999,0,0,0,0,0,10]
["El Salvador","SLV",6126583,0.66725999999999996,7.5,7.5,0.65700000000000003,23.279717732341179,86.576467497689521,3.9736069922444424,113.82979222227515,3.9736069922444424,8]
["Equatorial Guinea","GNQ",845060,0.39923000000000003,21.2,7.4,5.0000000000000001E-3,0.76032208493729392,0.12464296474381865,10.588419854987396,11.473384904668508,10.588419854987396,13]
["Eritrea","ERI",5222000,0.377,21.2,7.4,1E-3,50.000063363227163,5.8823603956737844E-2,4.2352994848851244,54.294186452069027,4.2352994848851244,13]
["Estonia","EST",1311998,0.67537999999999998,6.5,6.5,0.46700000000000003,41,6,7,54,7,9]
["Ethiopia","ETH",99390750,0.19472,21.2,7.4,5.0000000000000001E-3,310,25,2159,2494,2159,13]
["Fiji","FJI",892145,0.53727999999999998,7.5,14.3,0.7,2,0,10,12,10,7]
["Finland","FIN",5482013,0.84221000000000001,6.5,6.5,0.7,179,0,64,243,64,7]
["France","FRA",66808385,0.79519999999999991,6.5,6.5,0.7,971,0,2784,3755,2784,7]
["French Guiana","GUF",276000,0.84400000000000008,7.5,7.5,0.7,4,2,8,14,8,7]
["Gabon","GAB",1725292,0.87156000000000011,21.2,7.4,7.8667549999999996E-3,1.5522893174042478,0.2544736585908603,21.617537297293584,23.424300273288694,21.617537297293584,13]
["Gambia","GMB",1990924,0.59631999999999996,21.2,7.4,8.0000000000000002E-3,7.7108973358273349,0.87076998146044193,12.425658485445386,21.007325802733163,12.425658485445386,13]
["Georgia","GEO",3679000,0.53640999999999994,6.5,6.5,0.21099999999999999,120,450,292,{"$f":"H66+I66+J66","v":862},{"$f":"J66","v":292},10]
["Germany","DEU",81413145,0.75301000000000007,6.5,6.5,0.7,1297,1457,0,2754,0,7]
["Ghana","GHA",27409893,0.54042000000000001,21.2,7.4,8.0000000000000002E-3,1,0,216,217,216,13]
["Greece","GRC",10823732,0.78007000000000004,6.5,6.5,0.46700000000000003,425,0,0,425,0,9]
["Grenada","GRD",106825,0.35591,7.5,7.5,0.55100000000000005,2.2816953423144213,3.245654825482819E-3,0.93474858973905184,3.2196895868789559,0.93474858973905184,8]
["Guatemala","GTM",16342897,0.51571,7.5,7.5,0.63,8,37,10,55,10,8]
["Guinea","GIN",12608590,0.37161,21.2,7.4,5.0000000000000001E-3,12,12,0,24,0,13]
["Guinea-Bissau","GNB",1844325,0.49331999999999998,21.2,7.4,8.0000000000000002E-3,2,0,11,13,11,13]
["Guyana","GUY",767085,0.28553000000000001,7.5,7.5,0.68,2.9147605242127517,10.839893880563629,0.49751946878803865,14.25217387356442,0.49751946878803865,8]
["Haiti","HTI",10711067,0.58645000000000003,7.5,7.5,0.31409501400000001,12,0,15,27,15,10]
["Honduras","HND",8075060,0.54730000000000001,7.5,7.5,0.82476000000000005,30.683517626663829,114.11094400123082,5.2373590431719297,150.03182067106655,5.2373590431719297,7]
["Hungary","HUN",9844686,0.71227000000000007,6.5,6.5,0.46700000000000003,452,0,204,656,204,9]
["Iceland","ISL",330823,0.94137000000000004,6.5,6.5,0.7,25,0,0,25,0,7]
["India","IND",1311050527,0.32746999999999998,7.5,14.3,0.15,13145.323621969848,983.76734787168562,7274.1986170726186,21403.289586914154,7274.1986170726186,13]
["Indonesia","IDN",257563815,0.53742000000000001,7.5,14.3,0.23799999999999999,1270,0,0,1270,0,10]
["Iran","IRN",79109272,0.73375000000000001,7.5,14.3,0.18181818199999999,543.00555654885784,199.20458802571412,288.42363131136216,1030.633775885934,288.42363131136216,10]
["Iraq","IRQ",36423395,0.69471000000000005,7.5,14.3,0.185,73,0,6,79,6,10]
["Ireland","IRL",4640703,0.63241000000000003,6.5,6.5,0.7,54,606,0,660,0,7]
["Israel","ISR",8380400,0.9214,7.5,14.3,0.631788935,238,87,0,325,0,8]
["Italy","ITA",60802085,0.68964000000000003,6.5,6.5,0.7,2500,0,1453,3953,1453,7]
["Jamaica","JAM",2725941,0.54787999999999992,7.5,7.5,0.55100000000000005,58.223888444876351,8.2822031927277898E-2,23.852745195056034,82.159455671859661,23.852745195056034,8]
["Japan","JPN",126958472,0.93498000000000003,7.5,14.3,0.7,5285,0,0,5285,0,7]
["Jordan","JOR",7594547,0.83679000000000003,7.5,14.3,0.185,128,11,325,464,325,10]
["Kazakhstan","KAZ",17544126,0.53247,7.5,14.3,0.21099999999999999,273.77310035063624,644.04786116123751,122.78541291128747,1040.6063744231612,122.78541291128747,10]
["Kenya","KEN",46050302,0.25622,21.2,7.4,5.0000000000000001E-3,80,24,1103,1207,1103,13]
["Kiribati","KIR",112423,0.44304000000000004,7.5,14.3,0.7,1.3064607737640526,7.8629583606169839E-2,4.8357193917794445,6.2208097491496668,4.8357193917794445,7]
["Kuwait","KWT",3892115,0.98341999999999996,7.5,14.3,0.185,40,0,0,40,0,10]
["Kyrgyzstan","KGZ",5957000,0.35707,7.5,14.3,0.21099999999999999,0,0,0,0,0,10]
["Laos","LAO",6802023,0.38613999999999998,7.5,14.3,1.3899999999999999E-2,43.72097019452049,4.2201708681969592,105.50427170492397,153.44541276764141,105.50427170492397,13]
["Latvia","LVA",1978440,0.67382000000000009,6.5,6.5,0.46700000000000003,102,86,0,188,0,9]
["Lebanon","LBN",5850743,0.87792000000000003,7.5,14.3,0.185,40.159463974581058,14.73272120313951,21.331160043155659,76.223345220876226,21.331160043155659,10]
["Lesotho","LSO",2135022,0.27312000000000003,21.2,7.4,5.0000000000000001E-3,1,0,0,1,0,13]
["Liberia","LBR",4503438,0.49701000000000001,21.2,7.4,8.0000000000000002E-3,17.441925496032788,1.9696676637421868,28.106639228005285,{"$f":"H98+I98+J98","v":47.518232387780259},{"$f":"J98","v":28.106639228005285},13]
["Libya","LBY",6278438,0.78554000000000002,21.2,7.4,0.23699999999999999,60.115338533529915,7.0723927686505789E-2,5.092122793428417,65.278185254644839,5.092122793428417,10]
["Lithuania","LTU",2910199,0.66508,6.5,6.5,0.46700000000000003,533,0,0,533,0,9]
["Luxembourg","LUX",569676,0.90159999999999996,6.5,6.5,0.7,11.764371784067878,4.5287698002389023,10.093990695458711,26.387132279765492,10.093990695458711,7]
["Macedonia","MKD",2078453,0.75900000000000001,6.5,6.5,0.46700000000000003,68,0,0,68,0,9]
["Madagascar","MDG",24235390,0.35104999999999997,21.2,7.4,5.0000000000000001E-3,8,158,74,240,74,13]
["Malawi","MWI",17215232,0.16271999999999998,21.2,7.4,5.0000000000000001E-3,35.006016781713306,13.716156490279488,225.89913384860304,274.62130712059582,225.89913384860304,13]
["Malaysia","MYS",30331007,0.74704999999999999,7.5,14.3,0.7,901.50003445961022,72.219159497497643,86.266364434081851,1059.9855583911897,86.266364434081851,7]
["Maldives","MDV",409163,0.45535999999999999,7.5,14.3,0.7,12.161167566892766,0.97423102231569914,1.1637267589217275,14.299125348130193,1.1637267589217275,7]
["Mali","MLI",17599694,0.39915999999999996,21.2,7.4,8.0000000000000002E-3,303,135,0,438,0,13]
["Malta","MLT",431333,0.95406999999999997,6.5,6.5,0.46700000000000003,19,0,21,40,21,9]
["Marshall Islands","MHL",52993,0.72683999999999993,7.5,14.3,0.7,0.61582839618297358,3.7063746066567857E-2,2.2794203830939233,2.9323125253434648,2.2794203830939233,7]
["Mauritania","MRT",4067564,0.59859000000000007,21.2,7.4,8.0000000000000002E-3,15.753774835657804,1.7790295505349079,25.386283520461941,42.919087906654653,25.386283520461941,13]
["Mauritius","MUS",1262605,0.39671000000000001,21.2,7.4,5.0000000000000001E-3,12,0,0,12,0,13]
["Mexico","MEX",127017224,0.79245999999999994,7.5,7.5,0.76500000000000001,445,1972,0,2417,0,7]
["Micronesia","FSM",104460,0.22423999999999999,7.5,14.3,0.7,1.2139232401500843,7.3060195009032852E-2,4.4932019930555205,5.7801854282146374,4.4932019930555205,7]
["Moldova","MDA",3554150,0.44994999999999996,6.5,6.5,0.46700000000000003,170,105,0,275,0,9]
["Monaco","MCO",37731,1,6.5,6.5,0.7,0.77918239803794631,0.29995122373562166,0.66854907514157635,1.7476826969151442,0.66854907514157635,7]
["Mongolia","MNG",2959134,0.72040000000000004,7.5,14.3,0.15,295,0,0,295,0,13]
["Morocco","MAR",34377511,0.60194999999999999,21.2,7.4,0.140114353,131,0,0,131,0,13]
["Mozambique","MOZ",27977863,0.32213999999999998,21.2,7.4,0.1,56.89110327961167,22.291232971568455,367.12691520131006,446.30925145249017,367.12691520131006,13]
["Myanmar","MMR",53897154,0.34098000000000001,7.5,14.3,6.0000000000000001E-3,36,0,0,36,0,13]
["Namibia","NAM",2458830,0.46659999999999996,21.2,7.4,5.0000000000000001E-3,11,0,73,84,73,13]
["Nauru","NRU",10222,1,7.5,14.3,0.7,0.11878923378148729,7.1493520331450686E-3,0.43968515003842173,0.56562373585305403,0.43968515003842173,7]
["Nepal","NPL",28513700,0.18614999999999998,7.5,14.3,1.6999999999999999E-3,4,0,10,14,10,13]
["Netherlands","NLD",16936520,0.90495999999999999,6.5,6.5,0.7,337,66,383,786,383,7]
["New Zealand","NZL",4595700,0.86284000000000005,7.5,14.3,0.7,239,0,683,922,683,7]
["Nicaragua","NIC",6082032,0.58779000000000003,7.5,7.5,0.873,23.110433368660228,85.946904786551912,3.9447119025816595,113.0020500577938,3.9447119025816595,7]
["Niger","NER",19899120,0.18731999999999999,21.2,7.4,8.0000000000000002E-3,77.069778350810196,8.7032736324837661,124.1934244003769,209.96647638367085,124.1934244003769,13]
["Nigeria","NGA",182201962,0.47776000000000002,21.2,7.4,0.12292,696,0,758,1454,758,13]
["Niue","NIU",1591,1,7.5,14.3,0.7,1.8488913221125638E-2,1.1127586660862653E-3,6.8434657964305312E-2,8.8036329851517214E-2,6.8434657964305312E-2,7]
["North_Korea","PRK",25155317,0.60875000000000001,7.5,14.3,6.0000000000000001E-3,161.68937752646744,15.607082772825043,390.17706932062606,567.47352961991851,390.17706932062606,13]
["Norway","NOR",5195921,0.80472999999999995,6.5,6.5,0.7,535,0,152,{"$f":"H130+I130+J130","v":687},{"$f":"J130","v":152},7]
["Oman","OMN",4490541,0.77641000000000004,7.5,14.3,0.15,193,0,13,206,13,13]
["Pakistan","PAK",188924874,0.38758000000000004,7.5,14.3,5.0849999999999999E-2,58.054257622352509,0,561.19115701607416,619.24541463842661,561.19115701607416,13]
["Palau","PLW",21291,0.87070999999999998,7.5,14.3,0.7,1,1,0,2,0,7]
["Panama","PAN",3929141,0.66591999999999996,7.5,7.5,6.6666666999999999E-2,105,20,50,175,50,13]
["Papua New Guinea","PNG",7619321,0.13005,7.5,14.3,0.7,0,0,12,12,12,7]
["Paraguay","PRY",6639123,0.59665999999999997,7.5,7.5,0.83699999999999997,82,0,119,201,119,7]
["Peru","PER",31376670,0.78608999999999996,7.5,7.5,0.32737570399999999,221.02198225001933,88.158106341690143,233.55631016589948,542.73639875760898,233.55631016589948,10]
["Philippines","PHL",100699395,0.44372999999999996,7.5,14.3,0.1,367.4762435590365,0,87.42378374993207,454.90002730896856,87.42378374993207,13]
["Poland","POL",37999494,0.60538999999999998,6.5,6.5,0.624,611,0,0,611,0,8]
["Portugal","PRT",10348648,0.63468000000000002,6.5,6.5,0.7,330,330,0,660,0,7]
["Qatar","QAT",2235355,0.99243999999999999,7.5,14.3,0.185,15.34346297434354,5.628834150644443,8.1498563957207182,29.1221535207087,8.1498563957207182,10]
["Republic of Korea","KOR",50617045,0.82474000000000003,7.5,14.3,0.7,133,437,321,891,321,7]
["Romania","ROU",19832389,0.54564000000000001,6.5,6.5,0.46700000000000003,850,87,1149,2086,1149,9]
["Russia","RUS",144096812,0.74007999999999996,7.5,14.3,0.4,2248.6062270575785,5289.8185733933369,1008.4849231372461,8546.9097235881618,1008.4849231372461,9]
["Rwanda","RWA",11609666,0.28810999999999998,21.2,7.4,0.26,10.445513287276185,1.7123792274223253,145.46661536952655,157.62450788422507,145.46661536952655,10]
["Saint Kitts and Nevis","KNA",55572,0.32046999999999998,7.5,7.5,0.55100000000000005,1.1869728393456309,1.6884393162811253E-3,0.48627052308896407,1.6749318017508761,0.48627052308896407,8]
["Saint Lucia","LCA",184999,0.18504000000000001,7.5,7.5,0.55100000000000005,3.9514285666541134,5.6208087719119681E-3,1.6187929263106469,5.5758423017366727,1.6187929263106469,8]
["Saint Vincent and the Grenadines","VCT",109462,0.50549999999999995,7.5,7.5,0.55100000000000005,2.3380195231492742,3.3257745706248569E-3,0.95782307633995878,3.2991683740598576,0.95782307633995878,8]
["Samoa","WSM",193228,0.19097999999999998,7.5,14.3,0.7,2.2454907126911783,0.13514527437493204,8.3114343740583205,10.692070361124431,8.3114343740583205,7]
["San Marino","SMR",31781,0.94189999999999996,6.5,6.5,0.7,4,0,0,4,0,7]
["Sao Tome and Principe","STP",190344,0.65091999999999994,21.2,7.4,8.0000000000000002E-3,0.73720696645915074,8.3250712408462782E-2,1.1879657579865512,2.0084234368541649,1.1879657579865512,13]
["Saudi Arabia","SAU",31540372,0.83129999999999993,7.5,14.3,0.185,0,160,0,160,0,10]
["Senegal","SEN",15129273,0.43720999999999999,21.2,7.4,8.0000000000000002E-3,16,16,195,227,195,13]
["Serbia and Montenegro","SRB",7098247,0.55552999999999997,6.5,6.5,0.46700000000000003,160,0,0,160,0,9]
["Seychelles","SYC",92900,0.53886999999999996,21.2,7.4,5.0000000000000001E-3,0.18890590373810623,7.4017645416975184E-2,1.2190384384326174,1.4819619875876988,1.2190384384326174,13]
["Sierra Leone","SLE",6453184,0.39942,21.2,7.4,8.0000000000000002E-3,2,1,6,9,6,13]
["Singapore","SGP",5535002,1,7.5,14.3,0.7,36,0,186,222,186,7]
["Slovakia","SVK",5424050,0.53598000000000001,6.5,6.5,0.46700000000000003,347,350,25,722,25,9]
["Slovenia","SVN",2063768,0.4965,6.5,6.5,0.46700000000000003,117,0,0,117,0,9]
["Solomon Islands","SLB",583591,0.22329000000000002,7.5,14.3,0.7,6.7818751449591028,0.40816841150216826,25.102357307383347,32.29240086384462,25.102357307383347,7]
["Somalia","SOM",10787104,0.39551000000000003,21.2,7.4,1E-3,103.28530898232883,0.12151212821450452,8.7488732314443247,112.15569434198765,8.7488732314443247,13]
["South Africa","ZAF",54956920.374245599,0.64800999999999997,21.2,7.4,0.63,27,0,84,{"$f":"H162+I162+J162","v":111},{"$f":"J162","v":84},8]
["Spain","ESP",46418269,0.79578999999999989,6.5,6.5,0.7,958.58307895869348,369.01265776786386,822.47729478738711,2150.0730315139444,822.47729478738711,7]
["Sri Lanka","LKA",20966000,0.18356000000000003,7.5,14.3,0.49299999999999999,76.50996237324722,0,18.20196685492575,94.711929228172977,18.20196685492575,9]
["Sudan","SDN",52574694,0.33805999999999997,21.2,7.4,2E-3,503.39678883613152,0.59223151627780191,42.640669172001736,546.62968952441111,42.640669172001736,13]
["Suriname","SUR",542975,0.66043000000000007,7.5,7.5,0.68,1,0,14,15,14,8]
["Swaziland","SWZ",1286970,0.21307999999999999,21.2,7.4,5.0000000000000001E-3,3,0,14,17,14,13]
["Sweden","SWE",9798871,0.85814999999999997,6.5,6.5,0.7,108,0,81,189,81,7]
["Switzerland","CHE",8286976,0.73912000000000011,6.5,6.5,0.7,280,0,230,510,230,7]
["Syria","SYR",18502413,0.57655999999999996,7.5,14.3,0.185,127.00044905686683,46.590816297065878,67.457745603859863,241.04901095779258,67.457745603859863,10]
["Tajikistan","TJK",8481855,0.26782,7.5,14.3,0.147097382,132.35790372655475,311.37034534691264,59.361638672035767,503.08988774550318,59.361638672035767,13]
["Tanzania","TZA",53470420,0.31608000000000003,21.2,7.4,5.0000000000000001E-3,108.7285039112606,42.602309880051003,701.64152098101385,852.97233477232544,701.64152098101385,13]
["Thailand","THA",67959359,0.50374000000000008,7.5,14.3,0.495,248,0,59,307,59,9]
["Timor-Leste","TLS",1245015,0.32770000000000005,7.5,14.3,0.23799999999999999,12.483214607034585,0.93421655335673159,6.9078088179851411,20.325239978376459,6.9078088179851411,10]
["Togo","TGO",7304578,0.39964,21.2,7.4,8.2583690000000001E-2,1,0,55,56,55,13]
["Tonga","TON",106170,0.23712,7.5,14.3,0.7,1.2337950450577682,7.4256183267365675E-2,4.5667552709429886,5.8748064992681224,4.5667552709429886,7]
["Trinidad and Tobago","TTO",1360088,8.4449999999999997E-2,7.5,7.5,0.55100000000000005,29.050376360755788,4.1323437213023881E-2,11.901149917350878,40.992849715319693,11.901149917350878,8]
["Tunisia","TUN",11107800,0.66842000000000001,21.2,7.4,0.48449999999999999,245,0,94,339,94,9]
["Turkey","TUR",78665830,0.73397000000000001,6.5,6.5,0.46700000000000003,2643,0,345,2988,345,9]
["Turkmenistan","TKM",5373502,0.50036999999999998,7.5,14.3,0.21099999999999999,400,683,300,1383,300,10]
["Tuvalu","TUV",9916,0.59716999999999998,7.5,14.3,0.7,0.11523322658748072,6.9353330816539329E-3,0.42652298452171689,0.54869154419085153,0.42652298452171689,7]
["Uganda","UGA",39032383,0.16100999999999999,21.2,7.4,0.1,98,0,100,198,100,13]
["Ukraine","UKR",45198200,0.69694999999999996,6.5,6.5,0.46700000000000003,5920,0,0,5920,0,9]
["United Arab Emirates","ARE",9156963,0.85541,7.5,14.3,0.185,32,0,0,32,0,10]
["United Kingdom","GBR",65138232,0.82591999999999999,6.5,6.5,0.7,90,320,1037,1447,1037,7]
["United States of America","USA",321418820,0.81617000000000006,7.5,7.5,0.76726342700000005,1393,0,12250,13643,12250,7]
["Uruguay","URY",3431555,0.95311000000000012,7.5,7.5,0.64800000000000002,125,0,253,378,253,8]
["Uzbekistan","UZB",31299500,0.36365000000000003,7.5,14.3,0.40333897000000002,560,2224,0,2784,0,9]
["Vanuatu","VUT",264652,0.26128000000000001,7.5,14.3,0.7,0,0,8,8,8,7]
["Venezuela","VEN",31108083,0.88989999999999991,7.5,7.5,0.20568864000000001,219.13001502894119,87.403465351808308,231.55704801734998,538.09052839809942,231.55704801734998,10]
["Viet Nam","VNM",91703800,0.33593000000000006,7.5,14.3,0.25,1000,100,2500,3600,2500,10]
["Yemen","YEM",26832215,0.34606000000000003,7.5,14.3,0.185,184.17615876320554,67.56604124599184,97.827279796320227,349.56947980551763,97.827279796320227,10]
["Zambia","ZMB",16211767,0.40921999999999997,21.2,7.4,0.2,32.965538173591035,12.916650391696658,212.73161601629104,258.61380458157873,212.73161601629104,10]
["Zimbabwe","ZWE",15602751,0.32375999999999999,21.2,7.4,0.111524164,26,23,133,{"$f":"H194+I194+J194","v":182},133,13]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(U2:U194)","v":0},{"$f":"SUM(V2:V194)","v":0},{"$f":"SUM(Z2:Z194)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(AH2:AH194)","v":0},{"$f":"SUM(AI2:AI194)","v":0},{"$f":"SUM(BN2:BN194)","v":0}]

{"sheet":"Cost_dog_vax_example","index":5,"n_rows":102,"n_cols":11,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Worked example for costing a vaccination campaign. The numbers used largely correspond to publish literature, but do not represent any specific country. "]
[]
[null,"Costs per dog vaccination campaign",null,null,null,null,null,null,null,"Total"]
[null,"Summary of dog vaccination costs (per dog vaccinated)",null,null,null,null,null,null,"Lower bound ","Average","Upper bound"]
[]
[null,"Cost per dog vaccinated (user input; these values determine all cost estimates)*",null,null,null,null,null,null,1.63,2.17,2.63]
[]
[null,"Costs per dog vaccination campaign - user tables",null,null,null,null,null,null,null,"Total"]
[null,"Summary of dog vaccination costs based on calculation tables (per dog vaccinated)",null,null,null,null,null,null,"Lower bound ","Average","Upper bound"]
[]
[null,"Total dogs vaccinated in pilot campaign (user input)",null,null,null,null,null,null,null,999699.58666666655]
[]
[null,"Average cost per dog vaccinated (calculated using worksheet)",null,null,null,null,null,null,{"$f":"I92","v":1.6272929120213435},{"$f":"J92","v":2.1685702785579495},{"$f":"K92","v":2.6263874185590343}]
[]
[null,"Human resources",null,null,null,null,null,null,{"$f":"I25/$J$12","v":0.31020318917407047},{"$f":"J25/$J$12","v":0.52954908360536956},{"$f":"K25/$J$12","v":0.62870887252809249}]
[null,"Transport costs",null,null,null,null,null,null,{"$f":"I38/$J$12","v":0.13704116899438151},{"$f":"J38/$J$12","v":0.16805048460624886},{"$f":"K38/$J$12","v":0.20206070172894208}]
[null,"Awareness campaign",null,null,null,null,null,null,{"$f":"I49/$J$12","v":5.5216587799196054E-2},{"$f":"J49/$J$12","v":6.9020734748995075E-2},{"$f":"K49/$J$12","v":8.2824881698794081E-2}]
[null,"Equipment at vaccination point",null,null,null,null,null,null,{"$f":"I58/$J$12","v":3.9831966053695413E-2},{"$f":"J58/$J$12","v":4.984997559733579E-2},{"$f":"K58/$J$12","v":5.9792962603205511E-2}]
[null,"Dog vaccinations (consumables)",null,null,null,null,null,null,{"$f":"I88/$J$12","v":1.085},{"$f":"J88/$J$12","v":1.3521000000000001},{"$f":"K88/$J$12","v":1.653}]
[]
[null," Item","Units","Work days",null,"Price/Unit",null,null,null,"Total cost"]
[null,null,null,null,"Lower bound ","Average","Upper bound",null,"Lower bound ","Average","Upper bound"]
[]
[null,"Workers participating in campaign (per diem)",null,null,null,null,null,null,{"$f":"SUM(I27:I36)","v":310110},{"$f":"SUM(J27:J36)","v":529390},{"$f":"SUM(K27:K36)","v":628520}]
[]
[null,"Training supervisor",10,5,56,70,84,null,{"$f":"E27*$D27*$C27","v":2800},{"$f":"F27*$D27*$C27","v":3500},{"$f":"G27*$D27*$C27","v":4200}]
[null,"Informational supervisor",5,30,21,27,32,null,{"$f":"E28*$D28*$C28","v":3150},4050,4800]
[null,"Vaccination supervisor",40,30,30,38,46,null,36000,45600,55200]
[null,"Training technician",16,5,22,28,34,null,1760,2240,2720]
[null,"Informational technician",0,0,20,25,30,null,0,0,0]
[null,"Vaccination Technician",400,30,21,38,45,null,252000,456000,540000]
[null,"Driver",10,30,24,30,36,null,7200,9000,10800]
[null,"Other personnel 1",2,30,120,150,180,null,7200,9000,10800]
[null,"Other personnel 2",0,0,0,0,0,null,0,0,0]
[null,"Other Personnel 3",0,0,0,0,0,null,0,0,0]
[]
[null,"Transportation and logistics",null,null,null,null,null,null,{"$f":"SUM(I40:I47)","v":137000},{"$f":"SUM(J40:J47)","v":168000},{"$f":"SUM(K40:K47)","v":202000}]
[]
[null,"Pick up (including gasoline)",10,25,194,230,276,null,{"$f":"E40*$D40*$C40","v":48500},{"$f":"F40*$D40*$C40","v":57500},{"$f":"G40*$D40*$C40","v":69000}]
[null,"Vehicle",10,25,128,160,192,null,{"$f":"E41*$D41*$C41","v":32000},40000,48000]
[null,"Gasoline",800,25,2.1,2.6,3.1,null,42000,52000,62000]
[null,"Maintenance vehicle",20,25,3,5,8,null,1500,2500,4000]
[null,"Public transport",400,25,1.3,1.6,1.9,null,{"$f":"E44*$D44*$C44","v":13000},{"$f":"F44*$D44*$C44","v":16000},{"$f":"G44*$D44*$C44","v":19000}]
[null,"Other transportation costs 1",0,0,0,0,0,null,0,0,0]
[null,"Other transportation costs 2",0,0,0,0,0,null,0,0,0]
[null,"Other transportation costs 3",0,0,0,0,0,null,0,0,0]
[]
[null,"Awareness campaign ",null,null,null,null,null,null,{"$f":"SUM(I51:I56)","v":55200},{"$f":"SUM(J51:J56)","v":69000},{"$f":"SUM(K51:K56)","v":82800}]
[]
[null,"Media (e.g. posters)",15000,"N/A",0.48,0.6,0.72,null,{"$f":"E51*$C51","v":7200},{"$f":"F51*$C51","v":9000},{"$f":"G51*$C51","v":10800}]
[null,"Air time (radio, car with speakers, etc.)",4,20,200,250,300,null,{"$f":"E52*$D52*$C52","v":16000},{"$f":"F52*$D52*$C52","v":20000},{"$f":"G52*$D52*$C52","v":24000}]
[null,"Other costs",1,1,32000,40000,48000,null,{"$f":"E53*$D53*$C53","v":32000},{"$f":"F53*$D53*$C53","v":40000},{"$f":"G53*$D53*$C53","v":48000}]
[null,"Other communication & awareness costs 1",0,0,0,0,0,null,0,0,0]
[null,"Other communication & awareness costs 2",0,0,0,0,0,null,0,0,0]
[null,"Other communication & awareness costs 3",0,0,0,0,0,null,0,0,0]
[]
[null,"Equipment at vaccination point",null,null,null,null,null,null,{"$f":"SUM(I60:I66)","v":39820},{"$f":"SUM(J60:J66)","v":49835},{"$f":"SUM(K60:K66)","v":59775}]
[]
[null,"Tables",15,"N/A",31,45,54,null,{"$f":"E60*$C60","v":465},{"$f":"F60*$C60","v":675},{"$f":"G60*$C60","v":810}]
[null,"Coolers",45,"N/A",15,18,21,null,{"$f":"E61*$C61","v":675},810,945]
[null,"Dog handling (e.g., muzzles)",40,"N/A",112,140,168,null,4480,5600,6720]
[null,"First-aid",15,"N/A",280,350,420,null,4200,5250,6300]
[null,"Other equipment / supplies 1",15,"N/A",500,700,900,null,{"$f":"E64*$C64","v":7500},{"$f":"F64*$C64","v":10500},{"$f":"G64*$C64","v":13500}]
[null,"Other equipment / supplies 2",15,"N/A",500,700,900,null,7500,10500,13500]
[null,"Other equipment / supplies 3",15,"N/A",1000,1100,1200,null,15000,16500,18000]
[]
[null,"Other costs associated with the campaign (per work day)",null,null,null,null,null,null,{"$f":"SUM(I70:I72)","v":0},{"$f":"SUM(J70:J72)","v":0},{"$f":"SUM(K70:K72)","v":0}]
[]
[null,"Other costs 1",0,0,0,0,0,null,{"$f":"E70*$D70*$C70","v":0},0,0]
[null,"Other costs 2",0,0,0,0,0,null,0,0,0]
[null,"Other costs 3",0,0,0,0,0,null,0,0,0]
[]
[]
[null,"Total fixed costs ",null,null,null,null,null,null,{"$f":"I25+I38+I49+I58+I68","v":542130},{"$f":"J25+J38+J49+J58+J68","v":816225},{"$f":"K25+K38+K49+K58+K68","v":973095}]
[]
[]
[null,"Dog vaccinations",null,null,null,null,null,null,{"$f":"SUM(I81:I86)","v":1084674.0515333333},{"$f":"SUM(J81:J86)","v":1351693.8111319998},{"$f":"SUM(K81:K86)","v":1652503.4167599999}]
[]
[null,"Percent vaccine wastage",null,null,0.05,0.1,0.2]
[null,"Vaccines ",{"$f":"(1+F80)*J12","v":1099669.5453333333},"N/A",0.74,0.91,1.08,null,{"$f":"E81*$C81","v":813755.46354666667},{"$f":"F81*$C81","v":1000699.2862533333},{"$f":"G81*$C81","v":1187643.1089600001}]
[null,"Syringes and needles",{"$f":"C81","v":1099669.5453333333},"N/A",0.11,0.13100000000000001,0.15,null,{"$f":"E82*$C82","v":120963.64998666667},144056.71043866666,164950.43179999999]
[null,"Vaccination certificates",{"$f":"$J$12","v":999699.58666666655},"N/A",0.08,0.107,0.15,null,79975.96693333333,106967.85577333331,149954.93799999997]
[null,"Dog marking",{"$f":"$J$12","v":999699.58666666655},"N/A",7.0000000000000007E-2,0.1,0.15,null,{"$f":"E84*$C84","v":69978.971066666665},{"$f":"F84*$C84","v":99969.958666666658},{"$f":"G84*$C84","v":149954.93799999997}]
[null,"Other costs per dog vaccinated 1",{"$f":"$J$12","v":999699.58666666655},"N/A",0,0,0,null,{"$f":"E85*$C85","v":0},{"$f":"F85*$C85","v":0},{"$f":"G85*$C85","v":0}]
[null,"Other costs per dog vaccinated 2",{"$f":"$J$12","v":999699.58666666655},"N/A",0,0,0,null,0,0,0]
[]
[null,"Total variable costs",null,null,null,null,null,null,{"$f":"SUM(I81:I86)","v":1084674.0515333333},{"$f":"SUM(J81:J86)","v":1351693.8111319998},{"$f":"SUM(K81:K86)","v":1652503.4167599999}]
[]
[]
[null,"Total costs",null,null,null,null,null,null,{"$f":"I88+I75","v":1626804.0515333333},{"$f":"J88+J75","v":2167918.8111319998},{"$f":"K88+K75","v":2625598.4167599999}]
[null,"Average cost per dog vaccinated",null,null,null,null,null,null,{"$f":"I91/$J$12","v":1.6272929120213435},{"$f":"J91/$J$12","v":2.1685702785579495},{"$f":"K91/$J$12","v":2.6263874185590343}]
[]
[]
[null,"References used in the worksheet to estimate the average values utilized"]
[null,"Kayali U, Mindekem R, Hutton G, Ndoutamia A, Zinsstag J. Cost‐description of a pilot parenteral vaccination campaign against rabies in dogs in N'Djaména, Chad. Trop Med Int Health (2006) 11(7):1058-65."]
[null,"Kaare M, Lembo T, Hampson K, Ernest E, Estes A, Mentzel C, et al. Rabies control in rural Africa: evaluating strategies for effective domestic dog vaccination. Vaccine (2009) 27(1):152-60."]
[null,"Lapiz SMD, Miranda MEG, Garcia RG, Daguro LI, Paman MD, Madrinan FP, et al. Implementation of an intersectoral program to eliminate human and canine rabies: the Bohol Rabies Prevention and Elimination Project. PLoS Negl Trop Dis (2012) 6(12):e1891."]
[null,"Hatch B, Anderson A, Sambo M, Maziku M, Mchau G, Mbunda E, et al. Towards Canine Rabies Elimination in South‐Eastern Tanzania: Assessment of Health Economic Data. Transbound Emerg Dis (2016)."]
[null,"Knobel DL, Cleaveland S, Coleman PG, Fèvre EM, Meltzer MI, Miranda MEG, et al. Re-evaluating the burden of rabies in Africa and Asia. Bull WHO (2005) 83(5):360-8."]
[null,"Tenzin, Wangdi K, Ward MP. Human and animal rabies prevention and control cost in Bhutan, 2001–2008: The cost–benefit of dog rabies elimination. Vaccine (2012) 31(1):260-70."]
[null,"US Department of Commerce BoEA. National income and product account tables. Table 1.1.9 Implicit price deflators for Gross Domestic Product (2015) [cited 2015 22 December]. Available from: http://www.bea.gov/iTable/iTable.cfm?reqid=9&step=3&isuri=1&903=13#reqid=9&step=3&isuri=1&904=2000&903=13&906=a&905=2015&910=x&911=0 "]

{"sheet":"Flowchart","index":6,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[9,2,10,4],[9,5,10,7],[9,8,10,14],[12,1,12,14],[2,2,2,4],[2,5,2,7],[2,8,2,14],[4,2,4,4],[4,8,4,14],[5,1,8,1]]}
[]
[null,"Figure 1. Global Dog Rabies Elimination Pathway (GDREP): Phases for a dog rabies elimination program based on 70% dog population vaccination coverage."]
[null,"Implementation Phase:","Phase I: Preparation",null,null,"Phase II: Scale-up dog vaccination",null,null,"Phase III: Sustained 70% dog vaccination"]
[null,"Program year",1,{"$f":"C4+1","v":2},{"$f":"D4+1","v":3},4,5,6,7,8,9,10,11,12,13]
[null,"Expected dog vax coverage:","<18%",null,null,{"$f":"CONCATENATE(TEXT(F16,\"#,##0%\"),\" - \", TEXT(G16,\"#,##0%\"))","v":"18% - 35%"},{"$f":"CONCATENATE(TEXT(F17,\"#,##0%\"),\" - \", TEXT(G17,\"#,##0%\"))","v":"35% - 53%"},{"$f":"CONCATENATE(TEXT(F18,\"#,##0%\"),\" - \", TEXT(G18,\"#,##0%\"))","v":"53% - 70%"},">70%"]
[null,"Activities acheived:","Field studies",null,null,"Pilot implementation",null,null,"Mass vaccination of dogs"]
[null,null,"Workforce training",null,null,"Scaling-up vaccination coverage",null,null,"Surveillance to establish disease freedom"]
[null,null,"Strengthening lab capacity",null,null,"Logistical improvements"]
[null,null,null,null,null,"Operational equipment"]
[null,"Cost estimates:","    Current Vaccination Coverage \n+ Infrastructure Improvements*",null,null,"         Expected Vaccination Coverage\n+ Infrastructure Improvements*",null,null,"Vaccination of 70% of the dog population"]
[]
[]
[null,"Notes: There is variation between and within countries for the implementation and scaling-up of national dog vaccination campaigns. Based on expert opinion from dog vaccine implementation strategies in Haiti, Ethiopia, United States, Vietnam, and Latin America, we assumed that the current dog rabies vaccination coverage was directly correlated to the number of years it will take to achieve elimination, as illustrated by the three distinct Phases shown in the figure. For countries in Phase II, we estimated dog vaccination as the median value in the corresponding year range (e.g., we used 26% vaccination coverage in the rage 18-35%), or the current country vaccination rate for those countries that were already vaccinating dogs at a rate equivalent to Phase II. *Infrastructural improvement costs were estimated to be equivalent to the cost of vaccination for 10% of the country’s unvaccinated dog population."]
[]
[null,null,null,null,"Phase II","Lower bound","Upper bound","Median"]
[null,null,null,null,"Year 4",0.17499999999999999,0.35,{"$f":"MEDIAN(F16:G16)","v":0.26249999999999996}]
[null,null,null,null,"Year 5",{"$f":"G16","v":0.35},0.52499999999999991,{"$f":"MEDIAN(F17:G17)","v":0.43749999999999994}]
[null,null,null,null,"Year 6",{"$f":"G17","v":0.52499999999999991},0.7,0.61249999999999993]
[]
[null,null,null,null,"WHO recommended coverage to elimination",null,null,0.7]
[null,null,null,null,"WHO years until elimination",null,null,7]
[]
[null,"Source:"]
[null,"Wallace, RM, Undurraga, EA, Blanton JD, Cleaton, J, & Franka, R. 2017 Elimination of dog-mediated human rabies deaths by 2030: Needs assessment and alternatives for progress based on dog vaccination. Frontiers in Veterinary Science, in press. "]

{"sheet":"Calculations","index":7,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Internal calculations"]
[null,"Please do not modify the values in this worksheet"]
[]
[null,"Mean estimates","Years "]
[null,"Discounted values",0,1,2,3,4,5,6,7,8,9,10,11,12,"Total"]
[null,"Dog vaccines",{"$f":"Cost_dog_vax_aid!J5/(1+Calculations!$C$22)^Calculations!C6","v":1.8080000000000001},{"$f":"$C$7/(1+Calculations!$C$22)^Calculations!D6","v":1.8080000000000001},{"$f":"$C$7/(1+Calculations!$C$22)^Calculations!E6","v":1.8080000000000001},{"$f":"$C$7/(1+Calculations!$C$22)^Calculations!F6","v":1.8080000000000001},{"$f":"$C$7/(1+Calculations!$C$22)^Calculations!G6","v":1.8080000000000001},{"$f":"$C$7/(1+Calculations!$C$22)^Calculations!H6","v":1.8080000000000001},{"$f":"$C$7/(1+Calculations!$C$22)^Calculations!I6","v":1.8080000000000001},{"$f":"$C$7/(1+Calculations!$C$22)^Calculations!J6","v":1.8080000000000001},{"$f":"$C$7/(1+Calculations!$C$22)^Calculations!K6","v":1.8080000000000001},{"$f":"$C$7/(1+Calculations!$C$22)^Calculations!L6","v":1.8080000000000001},{"$f":"$C$7/(1+Calculations!$C$22)^Calculations!M6","v":1.8080000000000001},{"$f":"$C$7/(1+Calculations!$C$22)^Calculations!N6","v":1.8080000000000001},{"$f":"$C$7/(1+Calculations!$C$22)^Calculations!O6","v":1.8080000000000001}]
[null,"Dog vaccinations to reach goal",{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866}]
[null,"Dog vaccinations required",{"$f":"IF($C$25<$C$33,$C$25*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$25,IF($C$25>=$C$34,$C$26*$C$25,IF($C$25>=$C$33,$C$25*$C$26,\"check\")))))","v":258489.90273584906},{"$f":"IF($C$25<$C$33,$C$25*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$E$35,IF($C$25>=$C$33,$C$26*$E$34,\"check\")))))","v":258489.90273584906},{"$f":"IF($C$25<$C$33,$C$25*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$E$35,\"check\")))))","v":258489.90273584906},{"$f":"IF($C$24=0, 0,IF($C$25<$C$33, $E$33*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\"))))))","v":1357071.9893632072},{"$f":"IF($C$24=0, 0, IF($C$25<$C$33,$E$34*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\"))))))","v":2261786.6489386791},{"$f":"IF($C$24=0, 0,IF($C$25<$C$33, $E$35*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\"))))))","v":3166501.3085141503},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0,IF($C$25>=$C$33,$C$26*$C$24,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0,IF($C$25>=$C$33,0,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0,IF($C$25>=$C$33,0,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0,IF($C$25>=$C$33,0,\"check\")))))","v":3618858.6383018866}]
[null,{"$f":"CONCATENATE(\"Vaccinators required if\",\" \", 'Epi-demographic'!C27, \" \", \"dogs vaccinated per vaccinator daily\")","v":"Vaccinators required if 100 dogs vaccinated per vaccinator daily"},{"$f":"C9/('Epi-demographic'!$C$28*'Epi-demographic'!$C$27)","v":123.09042987421384},{"$f":"D9/('Epi-demographic'!$C$28*'Epi-demographic'!$C$27)","v":123.09042987421384},{"$f":"E9/('Epi-demographic'!$C$28*'Epi-demographic'!$C$27)","v":123.09042987421384},{"$f":"F9/('Epi-demographic'!$C$28*'Epi-demographic'!$C$27)","v":646.2247568396225},{"$f":"G9/('Epi-demographic'!$C$28*'Epi-demographic'!$C$27)","v":1077.041261399371},{"$f":"H9/('Epi-demographic'!$C$28*'Epi-demographic'!$C$27)","v":1507.8577659591192},{"$f":"I9/('Epi-demographic'!$C$28*'Epi-demographic'!$C$27)","v":1723.2660182389936},{"$f":"J9/('Epi-demographic'!$C$28*'Epi-demographic'!$C$27)","v":1723.2660182389936},{"$f":"K9/('Epi-demographic'!$C$28*'Epi-demographic'!$C$27)","v":1723.2660182389936},{"$f":"L9/('Epi-demographic'!$C$28*'Epi-demographic'!$C$27)","v":1723.2660182389936},{"$f":"M9/('Epi-demographic'!$C$28*'Epi-demographic'!$C$27)","v":1723.2660182389936},{"$f":"N9/('Epi-demographic'!$C$28*'Epi-demographic'!$C$27)","v":1723.2660182389936},{"$f":"O9/('Epi-demographic'!$C$28*'Epi-demographic'!$C$27)","v":1723.2660182389936}]
[null,"Max capac. dog vaccinations",{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000}]
[null,"Net dog vaccination capacity",{"$f":"C11-C9","v":8771510.0972641502},{"$f":"D11-D9","v":8771510.0972641502},8771510.0972641502,7672928.0106367925,6768213.3510613209,5863498.6914858501,5411141.3616981134,{"$f":"IF(J9=0,0,J11-J9)","v":5411141.3616981134},{"$f":"IF(K9=0,0,K11-K9)","v":5411141.3616981134},5411141.3616981134,5411141.3616981134,5411141.3616981134,5411141.3616981134]
[null,"Current spending on dog vaccination†",{"$f":"$C$25*C$7*'Epi-demographic'!$C$16","v":467349.74414641515},{"$f":"$C$25*D$7*'Epi-demographic'!$C$16","v":467349.74414641515},{"$f":"$C$25*E$7*'Epi-demographic'!$C$16","v":467349.74414641515},{"$f":"$C$25*F$7*'Epi-demographic'!$C$16","v":467349.74414641515},{"$f":"$C$25*G$7*'Epi-demographic'!$C$16","v":467349.74414641515},{"$f":"$C$25*H$7*'Epi-demographic'!$C$16","v":467349.74414641515},{"$f":"$C$25*I$7*'Epi-demographic'!$C$16","v":467349.74414641515},{"$f":"$C$25*J$7*'Epi-demographic'!$C$16","v":467349.74414641515},{"$f":"$C$25*K$7*'Epi-demographic'!$C$16","v":467349.74414641515},{"$f":"$C$25*L$7*'Epi-demographic'!$C$16","v":467349.74414641515},{"$f":"$C$25*M$7*'Epi-demographic'!$C$16","v":467349.74414641515},{"$f":"$C$25*N$7*'Epi-demographic'!$C$16","v":467349.74414641515},{"$f":"$C$25*O$7*'Epi-demographic'!$C$16","v":467349.74414641515}]
[null,"Cost to vaccinate dogs based on phases",{"$f":"C9*C7","v":467349.74414641509},467349.74414641509,467349.74414641509,2453586.1567686787,4089310.2612811318,5725034.3657935839,6542896.4180498114,6542896.4180498114,6542896.4180498114,6542896.4180498114,6542896.4180498114,6542896.4180498114,6542896.4180498114,{"$f":"SUM(C14:O14)","v":59470254.942631327}]
[null,"Additional cost from scaling*",{"$f":"IF($C$25<$C$33,$C$23*($C$24-$C$25)*$C$26*$C$7,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,$C$23*($C$24-$C$25)*$C$26*$C$7,IF($C$25>=$C$34,$C$23*($C$24-$C$25)*$C$26*$C$7, IF($C$25>=$C$33,$C$23*($C$24-$C$25)*$C$26*$C$7,\"check\"))))))","v":607554.66739033943},{"$f":"IF($C$25<$C$33,$C$23*($C$24-$C$25)*$C$26*D$7,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,$C$23*($C$24-$E$35)*$C$26*D$7, IF($C$25>=$C$33,$C$23*($C$24-$E$34)*$C$26*D$7,\"check\"))))))","v":607554.66739033943},{"$f":"IF($C$25<$C$33,$C$23*($C$24-$C$25)*$C$26*E$7,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,$C$23*($C$24-$E$35)*$C$26*E$7,\"check\"))))))","v":607554.66739033943},{"$f":"IF($C$24=0,0,IF($C$25<$C$33,$C$23*($C$24-$E$33)*$C$26*F$7,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,0,\"check\")))))))","v":408931.02612811327},{"$f":"IF($C$24=0,0,IF($C$25<$C$33,$C$23*($C$24-$E$34)*$C$26*G$7,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,0,\"check\")))))))","v":245358.61567686792},{"$f":"IF(C24=0,0,IF($C$25<$C$33,$C$23*($C$24-$E$35)*$C$26*H$7,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,0,\"check\")))))))","v":81786.20522562266},{"$f":"IF($C$25<$C$33,0,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,0,\"check\"))))))","v":0},0,0,0,0,0,0,{"$f":"SUM(C15:O15)","v":2558739.849201622}]
[null,"Total cost to vaccinate dogs",{"$f":"SUM(C14:C15)","v":1074904.4115367546},1074904.4115367546,1074904.4115367546,2862517.182896792,4334668.8769579995,5806820.5710192062,6542896.4180498114,6542896.4180498114,6542896.4180498114,6542896.4180498114,6542896.4180498114,6542896.4180498114,6542896.4180498114,{"$f":"SUM(C16:O16)","v":62028994.791832946}]
[null,"(Difference total costs with upper estimate)",{"$f":"C60-C16","v":185888.70538744051},185888.70538744051,185888.70538744051,495029.70456437953,749616.4097689176,1004203.1149734557,1131496.4675757242,1131496.4675757242,1131496.4675757242,1131496.4675757242,1131496.4675757242,1131496.4675757242,1131496.4675757242]
[null,"(Difference total costs with lower estimate)",{"$f":"C16-C47","v":197779.24091328925},197779.24091328925,197779.24091328925,526694.71764952037,797566.28672641609,1068437.8558033127,1203873.6403417615,1203873.6403417615,1203873.6403417615,1203873.6403417615,1203873.6403417615,1203873.6403417615,1203873.6403417615]
[null,"Additional spending required (government)",{"$f":"IF(C9=0,0,C16-C13)","v":607554.66739033943},{"$f":"IF(D9=0,0,D16-D13)","v":607554.66739033943},607554.66739033943,2395167.4387503769,3867319.1328115845,5339470.8268727912,6075546.6739033964,6075546.6739033964,6075546.6739033964,6075546.6739033964,6075546.6739033964,6075546.6739033964,6075546.6739033964,{"$f":"SUM(C19:O19)","v":55953448.117929555}]
[]
[null,"Constant variables",null,null,null,null,null,null,null,null,null,null,null,null,"Check estimates"]
[null,"Annual discount",{"$f":"'Epi-demographic'!C7","v":0},null,null,null,null,null,null,null,null,null,null,null,"NPV Phase I",{"$f":"'Epi-demographic'!H14","v":3224713.2346102642}]
[null,"Scaling up the program*",0.1,null,null,null,null,null,null,null,null,null,null,null,"NPV Phase II",{"$f":"'Epi-demographic'!H15","v":13004006.630873999}]
[null,"Goal to control rabies",{"$f":"'Epi-demographic'!C21","v":0.7},null,null,null,null,null,null,null,null,null,null,null,"NPV Phase III",{"$f":"'Epi-demographic'!H16","v":45800274.926348679}]
[null,"Current dog vaccination",{"$f":"'Epi-demographic'!C20","v":0.05},null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"'Epi-demographic'!H17","v":62028994.791832939}]
[null,"Total dogs",{"$f":"'Epi-demographic'!C16","v":5169798.054716981},null,null,null,null,null,null,null,null,null,null,null,"Difference",{"$f":"P25-P16","v":0},{"$f":"IF(P26=0, \"ok\", \"check\")","v":"ok"}]
[null,"Notes:"]
[null,"All estimates assume a constant human and dog population"]
[null,"†Estimate is based on average cost to vaccinate a dog and the proportion of the dog population currently being vaccinated; proportion of dogs vaccinated are assumed to be maintained in time"]
[null,"*Annual value of the costs of scaling up the program; x% of the what is needed to reach goal (countries with less vaccination would spend more to upgrade)"]
[]
[null,"Phase II Rabies campaigns","Lower bound","Upper bound","Median"]
[null,"Year 4",{"$f":"Flowchart!F16","v":0.17499999999999999},{"$f":"Flowchart!G16","v":0.35},{"$f":"Flowchart!H16","v":0.26249999999999996}]
[null,"Year 5",{"$f":"Flowchart!F17","v":0.35},{"$f":"Flowchart!G17","v":0.52499999999999991},{"$f":"Flowchart!H17","v":0.43749999999999994}]
[null,"Year 6",{"$f":"Flowchart!F18","v":0.52499999999999991},{"$f":"Flowchart!G18","v":0.7},{"$f":"Flowchart!H18","v":0.61249999999999993}]
[]
[null,"Lower bound estimates","Years "]
[null,"Discounted values",0,1,2,3,4,5,6,7,8,9,10,11,12,"Total"]
[null,"Dog vaccines - (lower bound)",{"$f":"Cost_dog_vax_aid!I5/(1+Calculations!$C$22)^Calculations!C38","v":1.4753333333333334},{"$f":"$C$39/(1+Calculations!$C$22)^Calculations!D38","v":1.4753333333333334},{"$f":"$C$39/(1+Calculations!$C$22)^Calculations!E38","v":1.4753333333333334},{"$f":"$C$39/(1+Calculations!$C$22)^Calculations!F38","v":1.4753333333333334},{"$f":"$C$39/(1+Calculations!$C$22)^Calculations!G38","v":1.4753333333333334},{"$f":"$C$39/(1+Calculations!$C$22)^Calculations!H38","v":1.4753333333333334},{"$f":"$C$39/(1+Calculations!$C$22)^Calculations!I38","v":1.4753333333333334},{"$f":"$C$39/(1+Calculations!$C$22)^Calculations!J38","v":1.4753333333333334},{"$f":"$C$39/(1+Calculations!$C$22)^Calculations!K38","v":1.4753333333333334},{"$f":"$C$39/(1+Calculations!$C$22)^Calculations!L38","v":1.4753333333333334},{"$f":"$C$39/(1+Calculations!$C$22)^Calculations!M38","v":1.4753333333333334},{"$f":"$C$39/(1+Calculations!$C$22)^Calculations!N38","v":1.4753333333333334},{"$f":"$C$39/(1+Calculations!$C$22)^Calculations!O38","v":1.4753333333333334}]
[null,"Dog vaccinations to reach goal",{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866}]
[null,"Dog vaccinations required",{"$f":"IF($C$25<$C$33,$C$25*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$25,IF($C$25>=$C$34,$C$26*$C$25,IF($C$25>=$C$33,$C$25*$C$26,\"check\")))))","v":258489.90273584906},{"$f":"IF($C$25<$C$33,$C$25*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$E$35,IF($C$25>=$C$33,$C$26*$E$34,\"check\")))))","v":258489.90273584906},{"$f":"IF($C$25<$C$33,$C$25*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$E$35,\"check\")))))","v":258489.90273584906},{"$f":"IF($C$24=0, 0,IF($C$25<$C$33, $E$33*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\"))))))","v":1357071.9893632072},{"$f":"IF($C$24=0, 0, IF($C$25<$C$33,$E$34*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\"))))))","v":2261786.6489386791},{"$f":"IF($C$24=0, 0,IF($C$25<$C$33, $E$35*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\"))))))","v":3166501.3085141503},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0,IF($C$25>=$C$33,$C$26*$C$24,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0,IF($C$25>=$C$33,0,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0,IF($C$25>=$C$33,0,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0,IF($C$25>=$C$33,0,\"check\")))))","v":3618858.6383018866}]
[null,"Max capac. dog vaccinations",{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000}]
[null,"Net dog vaccination capacity",{"$f":"C42-C41","v":8771510.0972641502},{"$f":"D42-D41","v":8771510.0972641502},8771510.0972641502,7672928.0106367925,6768213.3510613209,5863498.6914858501,5411141.3616981134,{"$f":"IF(J41=0,0,J42-J41)","v":5411141.3616981134},{"$f":"IF(K41=0,0,K42-K41)","v":5411141.3616981134},5411141.3616981134,5411141.3616981134,5411141.3616981134,5411141.3616981134]
[null,"Current spending on dog vaccination†",{"$f":"$C$25*C$39*'Epi-demographic'!$C$16","v":381358.76983628934},{"$f":"$C$25*D$39*'Epi-demographic'!$C$16","v":381358.76983628934},{"$f":"$C$25*E$39*'Epi-demographic'!$C$16","v":381358.76983628934},{"$f":"$C$25*F$39*'Epi-demographic'!$C$16","v":381358.76983628934},{"$f":"$C$25*G$39*'Epi-demographic'!$C$16","v":381358.76983628934},{"$f":"$C$25*H$39*'Epi-demographic'!$C$16","v":381358.76983628934},{"$f":"$C$25*I$39*'Epi-demographic'!$C$16","v":381358.76983628934},{"$f":"$C$25*J$39*'Epi-demographic'!$C$16","v":381358.76983628934},{"$f":"$C$25*K$39*'Epi-demographic'!$C$16","v":381358.76983628934},{"$f":"$C$25*L$39*'Epi-demographic'!$C$16","v":381358.76983628934},{"$f":"$C$25*M$39*'Epi-demographic'!$C$16","v":381358.76983628934},{"$f":"$C$25*N$39*'Epi-demographic'!$C$16","v":381358.76983628934},{"$f":"$C$25*O$39*'Epi-demographic'!$C$16","v":381358.76983628934}]
[null,"Cost to vaccinate dogs",{"$f":"C41*C39","v":381358.76983628934},{"$f":"D41*D39","v":381358.76983628934},381358.76983628934,2002133.5416405185,3336889.2360675316,4671644.9304945432,5339022.7777080499,5339022.7777080499,5339022.7777080499,5339022.7777080499,5339022.7777080499,5339022.7777080499,5339022.7777080499,{"$f":"SUM(C45:O45)","v":48527903.461667821}]
[null,"Additional cost from scaling",{"$f":"IF($C$25<$C$33,$C$23*($C$24-$C$25)*$C$26*$C$39,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,$C$23*($C$24-$C$25)*$C$26*$C$39,IF($C$25>=$C$34,$C$23*($C$24-$C$25)*$C$26*$C$39, IF($C$25>=$C$33,$C$23*($C$24-$C$25)*$C$26*$C$39,\"check\"))))))","v":495766.40078717598},{"$f":"IF($C$25<$C$33,$C$23*($C$24-$C$25)*$C$26*D$39,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,$C$23*($C$24-$E$35)*$C$26*D$39, IF($C$25>=$C$33,$C$23*($C$24-$E$34)*$C$26*D$39,\"check\"))))))","v":495766.40078717598},{"$f":"IF($C$25<$C$33,$C$23*($C$24-$C$25)*$C$26*E$39,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,$C$23*($C$24-$E$35)*$C$26*E$39,\"check\"))))))","v":495766.40078717598},{"$f":"IF($C$24=0,0,IF($C$25<$C$33,$C$23*($C$24-$E$33)*$C$26*F$39,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,0,\"check\")))))))","v":333688.92360675317},{"$f":"IF($C$24=0,0,IF($C$25<$C$33,$C$23*($C$24-$E$34)*$C$26*G$39,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,0,\"check\")))))))","v":200213.35416405188},{"$f":"IF($C$24=0,0,IF($C$25<$C$33,$C$23*($C$24-$E$35)*$C$26*H$39,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,0,\"check\")))))))","v":66737.784721350647},{"$f":"IF($C$25<$C$33,0,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,0,\"check\"))))))","v":0},0,0,0,0,0,0,{"$f":"SUM(C46:O46)","v":2087939.2648536833}]
[null,"Total cost to vaccinate dogs",{"$f":"SUM(C45:C46)","v":877125.17062346532},{"$f":"SUM(D45:D46)","v":877125.17062346532},877125.17062346532,2335822.4652472716,3537102.5902315835,4738382.7152158935,5339022.7777080499,5339022.7777080499,5339022.7777080499,5339022.7777080499,5339022.7777080499,5339022.7777080499,5339022.7777080499,50615842.726521507]
[null,"Additional spending required (gov.-lower bound)",{"$f":"IF(C41=0,0,C47-C44)","v":495766.40078717598},{"$f":"IF(D41=0,0,D47-D44)","v":495766.40078717598},495766.40078717598,1954463.6954109822,3155743.8203952941,4357023.9453796037,4957664.0078717601,4957664.0078717601,4957664.0078717601,4957664.0078717601,4957664.0078717601,4957664.0078717601,4957664.0078717601,{"$f":"SUM(C48:O48)","v":45658178.718649738}]
[]
[null,"Upper bound estimates","Years "]
[null,"Discounted values",0,1,2,3,4,5,6,7,8,9,10,11,12,"Total"]
[null,"Dog vaccines - (lower bound)",{"$f":"Cost_dog_vax_aid!K5/(1+Calculations!$C$22)^Calculations!C51","v":2.1206666666666671},{"$f":"$C$52/(1+Calculations!$C$22)^Calculations!D51","v":2.1206666666666671},{"$f":"$C$52/(1+Calculations!$C$22)^Calculations!E51","v":2.1206666666666671},{"$f":"$C$52/(1+Calculations!$C$22)^Calculations!F51","v":2.1206666666666671},{"$f":"$C$52/(1+Calculations!$C$22)^Calculations!G51","v":2.1206666666666671},{"$f":"$C$52/(1+Calculations!$C$22)^Calculations!H51","v":2.1206666666666671},{"$f":"$C$52/(1+Calculations!$C$22)^Calculations!I51","v":2.1206666666666671},{"$f":"$C$52/(1+Calculations!$C$22)^Calculations!J51","v":2.1206666666666671},{"$f":"$C$52/(1+Calculations!$C$22)^Calculations!K51","v":2.1206666666666671},{"$f":"$C$52/(1+Calculations!$C$22)^Calculations!L51","v":2.1206666666666671},{"$f":"$C$52/(1+Calculations!$C$22)^Calculations!M51","v":2.1206666666666671},{"$f":"$C$52/(1+Calculations!$C$22)^Calculations!N51","v":2.1206666666666671},{"$f":"$C$52/(1+Calculations!$C$22)^Calculations!O51","v":2.1206666666666671}]
[null,"Dog vaccinations to reach goal",{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866},{"$f":"'Epi-demographic'!$C$16*Calculations!$C$24","v":3618858.6383018866}]
[null,"Dog vaccinations required",{"$f":"IF($C$25<$C$33,$C$25*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$25,IF($C$25>=$C$34,$C$26*$C$25,IF($C$25>=$C$33,$C$25*$C$26,\"check\")))))","v":258489.90273584906},{"$f":"IF($C$25<$C$33,$C$25*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$E$35,IF($C$25>=$C$33,$C$26*$E$34,\"check\")))))","v":258489.90273584906},{"$f":"IF($C$25<$C$33,$C$25*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$E$35,\"check\")))))","v":258489.90273584906},{"$f":"IF($C$24=0, 0,IF($C$25<$C$33, $E$33*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\"))))))","v":1357071.9893632072},{"$f":"IF($C$24=0, 0, IF($C$25<$C$33,$E$34*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\"))))))","v":2261786.6489386791},{"$f":"IF($C$24=0, 0,IF($C$25<$C$33, $E$35*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\"))))))","v":3166501.3085141503},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,$C$24*$C$26,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,$C$26*$C$24,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,$C$26*$C$24,IF($C$25>=$C$33,$C$26*$C$24,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0,IF($C$25>=$C$33,$C$26*$C$24,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0,IF($C$25>=$C$33,0,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0,IF($C$25>=$C$33,0,\"check\")))))","v":3618858.6383018866},{"$f":"IF($C$25<$C$33,$C$24*$C$26,IF($C$25>=$C$24,0,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0,IF($C$25>=$C$33,0,\"check\")))))","v":3618858.6383018866}]
[null,"Max capac. dog vaccinations",{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000},{"$f":"'Epi-demographic'!$C$26*'Epi-demographic'!$C$27*'Epi-demographic'!$C$28","v":9030000}]
[null,"Net dog vaccination capacity",{"$f":"C55-C54","v":8771510.0972641502},{"$f":"D55-D54","v":8771510.0972641502},8771510.0972641502,7672928.0106367925,6768213.3510613209,5863498.6914858501,5411141.3616981134,{"$f":"IF(J54=0,0,J55-J54)","v":5411141.3616981134},{"$f":"IF(K54=0,0,K55-K54)","v":5411141.3616981134},5411141.3616981134,5411141.3616981134,5411141.3616981134,5411141.3616981134]
[null,"Current spending on dog vaccination†",{"$f":"$C$25*C$52*'Epi-demographic'!$C$16","v":548170.92040182406},{"$f":"$C$25*D$52*'Epi-demographic'!$C$16","v":548170.92040182406},{"$f":"$C$25*E$52*'Epi-demographic'!$C$16","v":548170.92040182406},{"$f":"$C$25*F$52*'Epi-demographic'!$C$16","v":548170.92040182406},{"$f":"$C$25*G$52*'Epi-demographic'!$C$16","v":548170.92040182406},{"$f":"$C$25*H$52*'Epi-demographic'!$C$16","v":548170.92040182406},{"$f":"$C$25*I$52*'Epi-demographic'!$C$16","v":548170.92040182406},{"$f":"$C$25*J$52*'Epi-demographic'!$C$16","v":548170.92040182406},{"$f":"$C$25*K$52*'Epi-demographic'!$C$16","v":548170.92040182406},{"$f":"$C$25*L$52*'Epi-demographic'!$C$16","v":548170.92040182406},{"$f":"$C$25*M$52*'Epi-demographic'!$C$16","v":548170.92040182406},{"$f":"$C$25*N$52*'Epi-demographic'!$C$16","v":548170.92040182406},{"$f":"$C$25*O$52*'Epi-demographic'!$C$16","v":548170.92040182406}]
[null,"Cost to vaccinate dogs",{"$f":"C54*C52","v":548170.92040182406},{"$f":"D54*D52","v":548170.92040182406},548170.92040182406,2877897.3321095756,4796495.5535159595,6715093.774922343,7674392.8856255356,7674392.8856255356,7674392.8856255356,7674392.8856255356,7674392.8856255356,7674392.8856255356,7674392.8856255356,{"$f":"SUM(C58:O58)","v":69754749.621132091}]
[null,"Additional cost from scaling",{"$f":"IF($C$25<$C$33,$C$23*($C$24-$C$25)*$C$26*$C$52,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,$C$23*($C$24-$C$25)*$C$26*$C$52,IF($C$25>=$C$34,$C$23*($C$24-$C$25)*$C$26*$C$52, IF($C$25>=$C$33,$C$23*($C$24-$C$25)*$C$26*$C$52,\"check\"))))))","v":712622.19652237103},{"$f":"IF($C$25<$C$33,$C$23*($C$24-$C$25)*$C$26*D$52,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,$C$23*($C$24-$E$35)*$C$26*D$52, IF($C$25>=$C$33,$C$23*($C$24-$E$34)*$C$26*D$52,\"check\"))))))","v":712622.19652237103},{"$f":"IF($C$25<$C$33,$C$23*($C$24-$C$25)*$C$26*E$52,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,$C$23*($C$24-$E$35)*$C$26*E$52,\"check\"))))))","v":712622.19652237103},{"$f":"IF($C$24=0,0,IF($C$25<$C$33,$C$23*($C$24-$E$33)*$C$26*F$52,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,0,\"check\")))))))","v":479649.55535159603},{"$f":"IF($C$24=0,0,IF($C$25<$C$33,$C$23*($C$24-$E$34)*$C$26*G$52,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,0,\"check\")))))))","v":287789.73321095761},{"$f":"IF($C$24=0,0,IF($C$25<$C$33,$C$23*($C$24-$E$35)*$C$26*H$52,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,0,\"check\")))))))","v":95929.911070319227},{"$f":"IF($C$25<$C$33,0,IF($C$25>=$C$24,0,IF($C$25<$C$24,IF($C$25>=$C$35,0,IF($C$25>=$C$34,0, IF($C$25>=$C$33,0,\"check\"))))))","v":0},0,0,0,0,0,0,{"$f":"SUM(C59:O59)","v":3001235.789199986}]
[null,"Total cost to vaccinate dogs",{"$f":"SUM(C58:C59)","v":1260793.1169241951},{"$f":"SUM(D58:D59)","v":1260793.1169241951},1260793.1169241951,3357546.8874611715,5084285.2867269171,6811023.6859926619,7674392.8856255356,7674392.8856255356,7674392.8856255356,7674392.8856255356,7674392.8856255356,7674392.8856255356,7674392.8856255356,72755985.410332084]
[null,"Additional spending required (gov.-upper bound)",{"$f":"IF(C54=0,0,C60-C57)","v":712622.19652237103},{"$f":"IF(D54=0,0,D60-D57)","v":712622.19652237103},712622.19652237103,2809375.9670593473,4536114.3663250934,6262852.7655908382,7126221.9652237119,7126221.9652237119,7126221.9652237119,7126221.9652237119,7126221.9652237119,7126221.9652237119,7126221.9652237119,{"$f":"SUM(C61:O61)","v":65629763.445108384}]