{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Disclaimer","VaccRate","Vaccine Efficacy Calculator","How to"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,1,15],[30,0,30,14]]}
["DISCLAIMER"]
[]
[]
[]
[]
[]
[null,null,"The accuracy of VaccRate is not guaranteed. This tool is provided on an “as-is” basis, and in"]
[null,null,"no way assumes liability for loss due to its content. Use of VaccRate will be considered"]
[null,null,"acceptance of this agreement."]
[null,null,"This tool comes without warranty of any kind, including without limitation the warranties of"]
[null,null,"merchantability, fitness for a particular purpose and non-infringement. The entire risk as to the"]
[null,null,"quality and performance of the computations is borne by you. Should the results prove to be in"]
[null,null,"error, you assume the entire cost of any required service and repair, and any consequential"]
[null,null,"damage."]
[null,null,"You are solely responsible for any loss of profit or any other commercial damage, including but"]
[null,null,"not limited to special, incidental, consequential or other damages. This disclaimer specifically"]
[null,null,"disclaims all other warranties, expressed or implied, including but not limited to the implied"]
[null,null,"warranties of merchantability and fitness for a particular purpose, related to defects in the"]
[null,null,"computed results or the documentation."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["VaccRate is © Christiaan Robert Thonus March 2021"]

{"sheet":"VaccRate","index":1,"n_rows":195,"n_cols":15,"rows_kept":195,"cut":false,"hidden":false,"merged":[[173,0,173,1],[172,5,172,6],[172,8,172,9],[172,10,172,11],[194,0,194,14],[169,10,169,11],[170,0,170,5],[170,6,170,7],[170,8,170,9],[170,10,170,11],[171,0,171,5],[171,6,171,7],[171,8,171,9],[171,10,171,11],[173,8,173,9],[169,0,169,1],[169,2,169,3],[169,4,169,5],[169,6,169,7],[169,8,169,9],[169,12,169,13],[172,1,172,2],[163,0,163,14],[165,11,165,12],[168,11,168,12],[150,8,150,9],[150,10,150,11],[147,8,147,9],[148,6,148,7],[148,8,148,9],[148,10,148,11],[149,0,149,5],[149,6,149,7],[149,8,149,9],[149,10,149,11],[151,0,151,1],[166,11,166,12],[167,13,167,14],[151,8,151,9],[167,11,167,12],[161,0,161,14],[147,0,147,1],[147,2,147,3],[147,4,147,5],[147,6,147,7],[147,10,147,11],[107,8,107,9],[106,6,106,7],[109,0,109,14],[103,11,103,12],[138,10,138,11],[150,5,150,6],[140,0,140,1],[140,8,140,9],[150,1,150,2],[115,12,115,13],[115,4,115,5],[105,0,105,5],[105,8,105,9],[105,10,105,11],[104,0,104,1],[104,2,104,3],[145,11,145,12],[144,11,144,12],[104,8,104,9],[104,10,104,11],[104,12,104,13],[104,4,104,5],[115,2,115,3],[115,6,115,7],[0,0,1,14],[11,2,11,5],[18,2,18,5],[25,2,25,5],[34,2,34,5],[4,5,5,5],[7,12,8,12],[4,3,5,3],[7,10,8,10],[7,11,8,11],[2,13,2,14],[13,11,13,12],[14,11,14,12],[20,11,20,12],[21,11,21,12],[28,11,28,12],[27,11,27,12],[32,0,32,14],[90,8,90,9],[89,8,89,9],[108,8,108,9],[102,11,102,12],[100,11,100,12],[101,11,101,12],[92,8,92,9],[98,0,98,14],[102,13,102,14],[96,0,96,14],[105,6,105,7],[92,0,92,1],[108,0,108,1],[91,8,91,9],[91,10,91,11],[91,5,91,6],[89,0,89,5],[89,6,89,7],[90,6,90,7],[89,10,89,11],[90,10,90,11],[90,0,90,5],[91,1,91,2],[104,6,104,7],[88,0,88,1],[88,2,88,3],[88,4,88,5],[88,6,88,7],[88,8,88,9],[76,0,76,14],[82,0,82,14],[84,11,84,12],[85,11,85,12],[88,10,88,11],[88,12,88,13],[86,11,86,12],[80,13,80,14],[86,13,86,14],[80,11,80,12],[81,11,81,12],[87,11,87,12],[36,11,36,12],[37,11,37,12],[43,11,43,12],[44,11,44,12],[50,11,50,12],[41,2,41,5],[48,2,48,5],[78,11,78,12],[79,11,79,12],[55,2,55,5],[51,11,51,12],[64,0,64,14],[57,11,57,12],[58,11,58,12],[115,8,115,9],[115,10,115,11],[117,8,117,9],[137,0,137,5],[137,6,137,7],[137,8,137,9],[137,10,137,11],[116,6,116,7],[116,8,116,9],[128,0,128,14],[118,1,118,2],[113,13,113,14],[106,10,106,11],[106,8,106,9],[106,0,106,5],[113,11,113,12],[107,1,107,2],[111,11,111,12],[112,11,112,12],[136,6,136,7],[107,10,107,11],[107,5,107,6],[133,11,133,12],[136,0,136,1],[136,2,136,3],[136,4,136,5],[136,8,136,9],[136,10,136,11],[136,12,136,13],[118,5,118,6],[118,8,118,9],[118,10,118,11],[119,8,119,9],[134,11,134,12],[119,0,119,1],[147,12,147,13],[148,0,148,5],[114,11,114,12],[135,11,135,12],[146,11,146,12],[130,0,130,14],[116,0,116,5],[134,13,134,14],[145,13,145,14],[115,0,115,1],[139,5,139,6],[139,8,139,9],[139,10,139,11],[141,0,141,14],[143,11,143,12],[139,1,139,2],[116,10,116,11],[117,0,117,5],[117,6,117,7],[138,0,138,5],[138,6,138,7],[138,8,138,9],[117,10,117,11],[132,11,132,12]]}
[" Vaccination rate Covid-19 (VaccRate)"]
[]
["Formula to determine the minimal percentage of vaccination in a group:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-10-23"}]
[]
[null,null,null,"Vmin =","1-1/R₀","*10000","R₀=basic reproduction number",null,null,"Vmin=","minimum vaccination rate in %"]
[null,null,null,null,"Vₑ",null,"Vₑ=vaccine efficacy"]
[]
[null,null,"The formula to determine the minimum Vₑ for given R₀ looks like this:",null,null,null,null,null,null,null,"Vₑ min =","(1-1/R₀)","*100"]
[]
[null,null,null,null,null,null,null,null,null,"Vₑ min=","minimal vaccine efficacy for given R₀"]
[]
["Name vaccine",null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"AND(L14<>\"\",L15<>\"\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"%"]
["R₀ =",null,{"$f":"IF(B14=\"\",0,1)","v":0},null,null,null,"   Total individuals in this group"]
[null,null,null,"Vmin =",{"$f":"IF(B14<>\"\",((1-(1/B14))/B16)*10000,\"\")","v":""},"%","   Vaccinated individuals in this group",null,null,null,null,null,null,{"$f":"IF(N12=TRUE,100/(L14/L15),\"\")","v":""}]
["Vₑ =",null,"%",null,null,null,"Vmin =",{"$f":"IF(L14<>\"\",(E15/100)*L14,\"\")","v":""},{"$f":"IF(L14<>\"\",100/(L14/H16),\"\")","v":""},"% of ",{"$f":"IF(L14<>\"\",L14,\"\")","v":""}]
["Vₑ min =",{"$f":"IF(B14<>\"\",(1-1/B14)*100,\"\")","v":""},"%"]
[]
["Name vaccine",null,null,null,null,null,2,null,null,null,null,null,null,{"$f":"AND(L21<>\"\",L22<>\"\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"%"]
["R₀ =",null,{"$f":"IF(B21=\"\",0,1)","v":0},{"$f":"IF(B21=B14,2,1)","v":2},null,null,"   Total individuals in this group"]
[null,null,null,"Vmin =",{"$f":"IF(B$21<>\"\",((1-(1/B$21))/B$23)*10000,\"\")","v":""},"%","   Vaccinated individuals in this group",null,null,null,null,null,null,{"$f":"IF(N19=TRUE,100/(L21/L22),\"\")","v":""}]
["Vₑ =",null,"%",null,null,null,"Vmin =",{"$f":"IF(L21<>\"\",(E22/100)*L21,\"\")","v":""},{"$f":"IF(L21<>\"\",100/(L21/H23),\"\")","v":""},"% of ",{"$f":"IF(L21<>\"\",L21,\"\")","v":""}]
["Vₑ min =",{"$f":"IF(B21<>\"\",(1-1/B21)*100,\"\")","v":""},"%"]
[]
["Name vaccine",null,null,null,null,null,3,null,null,null,null,null,null,{"$f":"AND(L28<>\"\",L29<>\"\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"%"]
["R₀ =",null,{"$f":"IF(B28=\"\",0,1)","v":0},{"$f":"IF(B28=B21,3,1)","v":3},null,null,"   Total individuals in this group"]
[null,null,null,"Vmin =",{"$f":"IF(B28<>\"\",((1-(1/B28))/B30)*10000,\"\")","v":""},"%","   Vaccinated individuals in this group",null,null,null,null,null,null,{"$f":"IF(N26=TRUE,100/(L28/L29),\"\")","v":""}]
["Vₑ =",null,"%",null,null,null,"Vmin =",{"$f":"IF(L28<>\"\",(E29/100)*L28,\"\")","v":""},{"$f":"IF(L28<>\"\",100/(L28/H30),\"\")","v":""},"% of ",{"$f":"IF(L28<>\"\",L28,\"\")","v":""}]
["Vₑ min =",{"$f":"IF(B28<>\"\",(1-1/B28)*100,\"\")","v":""},"%"]
[]
["VaccRate  is © Copyright Christiaan Robert Thonus March 2021"]
[]
["Name vaccine",null,null,null,null,null,4,null,null,null,null,null,null,{"$f":"AND(L37<>\"\",L38<>\"\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"%"]
["R₀ =",null,{"$f":"IF(B37=\"\",0,1)","v":0},{"$f":"IF(B37=B28,4,1)","v":4},null,null,"   Total individuals in this group"]
[null,null,null,"Vmin =",{"$f":"IF(B37<>\"\",((1-(1/B37))/B39)*10000,\"\")","v":""},"%","   Vaccinated individuals in this group",null,null,null,null,null,null,{"$f":"IF(N35=TRUE,100/(L37/L38),\"\")","v":""}]
["Vₑ =",null,"%",null,null,null,"Vmin =",{"$f":"IF(L37<>\"\",(E38/100)*L37,\"\")","v":""},{"$f":"IF(L37<>\"\",100/(L37/H39),\"\")","v":""},"% van ",{"$f":"IF(L37<>\"\",L37,\"\")","v":""}]
["Vₑ min =",{"$f":"IF(B37<>\"\",(1-1/B37)*100,\"\")","v":""},"%"]
[]
["Name vaccine",null,null,null,null,null,5,null,null,null,null,null,null,{"$f":"AND(L44<>\"\",L45<>\"\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"%"]
["R₀ =",null,{"$f":"IF(B44=\"\",0,1)","v":0},{"$f":"IF(B44=B37,5,1)","v":5},null,null,"   Total individuals in this group"]
[null,null,null,"Vmin =",{"$f":"IF(B44<>\"\",((1-(1/B44))/B46)*10000,\"\")","v":""},"%","   Vaccinated individuals in this group",null,null,null,null,null,null,{"$f":"IF(N42=TRUE,100/(L44/L45),\"\")","v":""}]
["Vₑ =",null,"%",null,null,null,"Vmin =",{"$f":"IF(L44<>\"\",(E45/100)*L44,\"\")","v":""},{"$f":"IF(L44<>\"\",100/(L44/H46),\"\")","v":""},"% of ",{"$f":"IF(L44<>\"\",L44,\"\")","v":""}]
["Vₑ min =",{"$f":"IF(B44<>\"\",(1-1/B44)*100,\"\")","v":""},"%"]
[]
["Name vaccine",null,null,null,null,null,6,null,null,null,null,null,null,{"$f":"AND(L51<>\"\",L52<>\"\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"%"]
["R₀ =",null,{"$f":"IF(B51=\"\",0,1)","v":0},{"$f":"IF(B51=B44,6,1)","v":6},null,null,"   Total individuals in this group"]
[null,null,null,"Vmin =",{"$f":"IF(B51<>\"\",((1-(1/B51))/B53)*10000,\"\")","v":""},"%","   Vaccinated individuals in this group",null,null,null,null,null,null,{"$f":"IF(N49=TRUE,100/(L51/L52),\"\")","v":""}]
["Vₑ =",null,"%",null,null,null,"Vmin =",{"$f":"IF(L51<>\"\",(E52/100)*L51,\"\")","v":""},{"$f":"IF(L51<>\"\",100/(L51/H53),\"\")","v":""},"% of ",{"$f":"IF(L51<>\"\",L51,\"\")","v":""}]
["Vₑ min =",{"$f":"IF(B51<>\"\",(1-1/B51)*100,\"\")","v":""},"%"]
[]
["Name vaccine",null,null,null,null,null,7,null,null,null,null,null,null,{"$f":"AND(L58<>\"\",L59<>\"\")","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"%"]
["R₀ =",null,{"$f":"IF(B58=\"\",0,1)","v":0},{"$f":"IF(B58=B51,7,1)","v":7},null,null,"   Total individuals in this group"]
[null,null,null,"Vmin =",{"$f":"IF(B58<>\"\",((1-(1/B58))/B60)*10000,\"\")","v":""},"%","   Vaccinated individuals in this group",null,null,null,null,null,null,{"$f":"IF(N56=TRUE,100/(L58/L59),\"\")","v":""}]
["Vₑ =",null,"%",null,null,null,"Vmin =",{"$f":"IF(L58<>\"\",(E59/100)*L58,\"\")","v":""},{"$f":"IF(L58<>\"\",100/(L58/H60),\"\")","v":""},"% of ",{"$f":"IF(L58<>\"\",L58,\"\")","v":""}]
["Vₑ min =",{"$f":"IF(B58<>\"\",(1-1/B58)*100,\"\")","v":""},"%"]
[]
[]
[]
["VaccRate  is © Copyright Christiaan Robert Thonus March 2021"]
["     Which groups do you want to combine?"]
[]
[null,{"$f":"G12","v":1},{"$f":"C12","v":0},null,null,1,null,null,{"$f":"IF(G68=1,C$12,IF(G68=2,C$19,IF(G68=3,C$26,IF(G68=4,C$35,IF(G68=5,C$42,IF(G68=6,C$49,IF(G68=7,C$56,\"\")))))))","v":""}]
[null,{"$f":"G19","v":2},{"$f":"C19","v":0},null,null,2,null,null,{"$f":"IF(G69=1,C$12,IF(G69=2,C$19,IF(G69=3,C$26,IF(G69=4,C$35,IF(G69=5,C$42,IF(G69=6,C$49,IF(G69=7,C$56,\"\")))))))","v":""}]
[null,{"$f":"G26","v":3},{"$f":"C26","v":0},null,null,3,null,null,{"$f":"IF(G70=1,C$12,IF(G70=2,C$19,IF(G70=3,C$26,IF(G70=4,C$35,IF(G70=5,C$42,IF(G70=6,C$49,IF(G70=7,C$56,\"\")))))))","v":""}]
[null,{"$f":"G35","v":4},{"$f":"C35","v":0},null,null,4,null,null,""]
[null,{"$f":"G42","v":5},{"$f":"C42","v":0},null,null,5,null,null,""]
[null,{"$f":"G49","v":6},{"$f":"C49","v":0},null,null,6,null,null,""]
[null,{"$f":"G56","v":7},{"$f":"C56","v":0},null,null,7,null,null,""]
[]
[null,"Groups to combine:"]
[{"$f":"I68","v":""}]
[{"$f":"IF($A77=C$12,1,0)","v":1},{"$f":"IF($A77=C$19,1,0)","v":1},{"$f":"IF($A77=C$26,1,0)","v":1},{"$f":"IF($A77=C$35,1,0)","v":1},{"$f":"IF($A77=C$42,1,0)","v":1},{"$f":"IF($A77=C$49,1,0)","v":1},{"$f":"IF($A77=C$56,1,0)","v":1},null,null,null,null,null,null,"%"]
["R₀ =",{"$f":"IF($A$78=1,B14,IF($B$78=1,B21,IF($C$78=1,B28,IF($D$78=1,B37,IF($E$78=1,B44,IF($F$78=1,B51,IF($G$78=1,B58,\"x\")))))))","v":0},null,null,null,null,null,null,"Total individuals in this group",null,null,{"$f":"IF($A$78=1,L14,IF($B$78=1,L21,IF($C$78=1,L28,IF($D$78=1,L37,IF($E$78=1,L44,IF($F$78=1,L51,IF($G$78=1,L58,\"x\")))))))","v":0}]
[null,null,null,"Vmin =",{"$f":"IF($A$78=1,E15,IF($B$78=1,E22,IF($C$78=1,E29,IF($D$78=1,E38,IF($E$78=1,E45,IF($F$78=1,E52,IF($G$78=1,E59,\"x\")))))))","v":""},"%",null,"           Vaccinated individuals in this group",null,null,null,{"$f":"IF($A$78=1,L15,IF($B$78=1,L22,IF($C$78=1,L29,IF($D$78=1,L38,IF($E$78=1,L45,IF($F$78=1,L52,IF($G$78=1,L59,\"x\")))))))","v":0},null,{"$f":"IF($A$78=1,N15,IF($B$78=1,N22,IF($C$78=1,N29,IF($D$78=1,N38,IF($E$78=1,N45,IF($F$78=1,N52,IF($G$78=1,N59,\"x\")))))))","v":""},"*"]
["Vₑ =",{"$f":"IF($A$78=1,B16,IF($B$78=1,B23,IF($C$78=1,B30,IF($D$78=1,B39,IF($E$78=1,B46,IF($F$78=1,B53,IF($G$78=1,B60,\"x\")))))))","v":0},"%",null,null,null,null,{"$f":"IF($A$78=1,H16,IF($B$78=1,H23,IF($C$78=1,H30,IF($D$78=1,H39,IF($E$78=1,H46,IF($F$78=1,H53,IF($G$78=1,H60,\"x\")))))))","v":""},"= Minimum to vaccinate",null,null,{"$f":"L80*0.99+(L80*0.01*B81/100)","v":0},null,"Disease-free ▲"]
[null,null,null,null,null,null,null,null,null,"           Approximately",null,{"$f":"L80-L81","v":0},null,"Cases ","(sick)"]
[{"$f":"I69","v":""}]
[{"$f":"IF($A83=C$12,1,0)","v":1},{"$f":"IF($A83=C$19,1,0)","v":1},{"$f":"IF($A83=C$26,1,0)","v":1},{"$f":"IF($A83=C$35,1,0)","v":1},{"$f":"IF($A83=C$42,1,0)","v":1},{"$f":"IF($A83=C$49,1,0)","v":1},{"$f":"IF($A83=C$56,1,0)","v":1},null,null,null,null,null,null,"%"]
["R₀ =",{"$f":"IF(A84=1,B$14,IF(B84=1,B$21,IF(C84=1,B$28,IF(D84=1,B$37,IF(E84=1,B$44,IF(F84=1,B$51,IF(G84=1,B$58,\"x\")))))))","v":0},null,null,null,null,null,null,"Total individuals in this group",null,null,{"$f":"IF(A84=1,L$14,IF(B84=1,L$21,IF(C84=1,L$28,IF(D84=1,L$37,IF(E84=1,L$44,IF(F84=1,L$51,IF(G84=1,L$58,\"x\")))))))","v":0}]
[null,null,null,"Vmin =",{"$f":"IF(A84=1,E$15,IF(B84=1,E$22,IF(C84=1,E$29,IF(D84=1,E$38,IF(E84=1,E$45,IF(F84=1,E$52,IF(G84=1,E$59,\"x\")))))))","v":""},"%",null,"           Vaccinated individuals in this group",null,null,null,{"$f":"IF(A84=1,L$15,IF(B84=1,L$22,IF(C84=1,L$29,IF(D84=1,L$38,IF(E84=1,L$45,IF(F84=1,L$52,IF(G84=1,L$59,\"x\")))))))","v":0},null,{"$f":"IF(A84=1,N$15,IF(B84=1,N$22,IF(C84=1,N$29,IF(D84=1,N$38,IF(E84=1,N$45,IF(F84=1,N$52,IF(G84=1,N$59,\"x\")))))))","v":""},"*"]
["Vₑ =",{"$f":"IF(A84=1,B$16,IF(B84=1,B$23,IF(C84=1,B$30,IF(D84=1,B$39,IF(E84=1,B$46,IF(F84=1,B$53,IF(G84=1,B$60,\"x\")))))))","v":0},"%",null,null,null,null,{"$f":"IF(A84=1,H$16,IF(B84=1,H$23,IF(C84=1,H$30,IF(D84=1,H$39,IF(E84=1,H$46,IF(F84=1,H$53,IF(G84=1,H$60,\"x\")))))))","v":""},"= Minimum to vaccinate",null,null,{"$f":"L86*0.99+(L86*0.01*B87/100)","v":0},null,"Disease-free ▲"]
[null,null,null,null,null,null,null,null,null,"           Approximately",null,{"$f":"L86-L87","v":0},null,"Cases ","(sick)"]
[{"$f":"A77","v":""},null,{"$f":"A83","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND(F92=0,AND(I92=0,AND(M92=0)))","v":true}]
["Total individuals in combined groups",null,null,null,null,null,{"$f":"L79+L85","v":0},null,{"$f":"(L80*0.99+L86*0.99)+(L80/100)*(B81/100)+(L86/100)*(B87/100)","v":0},null,"are disease-free = ",null,{"$f":"IF(G90=0,0,100/(G90/I90))","v":0},"%"]
["Total individuals vaccinated in combined groups",null,null,null,null,null,{"$f":"L80+L86","v":0},null,{"$f":"(L80/100)*(B81/100)+(L86/100)*(B87/100)+(L80*0.99+L86*0.99)","v":0},null,"are disease-free = ",null,{"$f":"IF(G91=0,0,100/(G91/I91))","v":0},"%"]
["Vmin C =",{"$f":"IF(F93=\"\",\"\",IF(G90=0,0,F93/100*G90))","v":""},null,null,"Of",{"$f":"G90","v":0},null,"individuals ",{"$f":"G90-(L$80+L$86)","v":0},null,"are not vaccinated = ",null,{"$f":"IF(I92=0,0,IF(G90=0,0,100/(G90/I92)))","v":0},"% Rem.:",{"$f":"IF(O89=TRUE,0,100-M92)","v":0}]
["Vₑ combined =",null,{"$f":"(M91-INT(M91))*100","v":0},"%","Vmin C =",{"$f":"IF(B85<>0,((1-(1/B85))/C93)*10000,\"\")","v":""},"%","Aproxx.",{"$f":"G91-I91","v":0},null,"=Total cases expected in combined vaccinated groups."]
["* This does not mean that individuals in this group can not get the disease! Some can still become ill."]
["▲ A better description of 'protection' or 'disease-free' is: 'Vaccinated individuals are Vₑ % less likely to contract the infectious disease'. "]
["  Also keep in mind that generally partial protection starts 10 to 14 days after the first injection."]
["VaccRate  is © Copyright Christiaan Robert Thonus March 2021"]
[]
[{"$f":"I70","v":""}]
[{"$f":"IF($A99=C$12,1,0)","v":1},{"$f":"IF($A99=C$19,1,0)","v":1},{"$f":"IF($A99=C$26,1,0)","v":1},{"$f":"IF($A99=C$35,1,0)","v":1},{"$f":"IF($A99=C$42,1,0)","v":1},{"$f":"IF($A99=C$49,1,0)","v":1},{"$f":"IF($A99=C$56,1,0)","v":1},null,null,null,null,null,null,"%"]
["R₀ =",{"$f":"IF(A100=1,B$14,IF(B100=1,B$21,IF(C100=1,B$28,IF(D100=1,B$37,IF(E100=1,B$44,IF(F100=1,B$51,IF(G100=1,B$58,\"x\")))))))","v":0},null,null,null,null,null,null,"Total individuals in this group",null,null,{"$f":"IF(A100=1,L$14,IF(B100=1,L$21,IF(C100=1,L$28,IF(D100=1,L$37,IF(E100=1,L$44,IF(F100=1,L$51,IF(G100=1,L$58,\"x\")))))))","v":0}]
[null,null,null,"Vmin =",{"$f":"IF(A100=1,E$15,IF(B100=1,E$22,IF(C100=1,E$29,IF(D100=1,E$38,IF(E100=1,E$45,IF(F100=1,E$52,IF(G100=1,E$59,\"x\")))))))","v":""},"%",null,"           Vaccinated individuals in this group",null,null,null,{"$f":"IF(A100=1,L$15,IF(B100=1,L$22,IF(C100=1,L$29,IF(D100=1,L$38,IF(E100=1,L$45,IF(F100=1,L$52,IF(G100=1,L$59,\"x\")))))))","v":0},null,{"$f":"IF(A100=1,N$15,IF(B100=1,N$22,IF(C100=1,N$29,IF(D100=1,N$38,IF(E100=1,N$45,IF(F100=1,N$52,IF(G100=1,N$59,\"x\")))))))","v":""},"*"]
["Vₑ =",{"$f":"IF(A100=1,B$16,IF(B100=1,B$23,IF(C100=1,B$30,IF(D100=1,B$39,IF(E100=1,B$46,IF(F100=1,B$53,IF(G100=1,B$60,\"x\")))))))","v":0},"%",null,null,null,null,{"$f":"IF(A100=1,H$16,IF(B100=1,H$23,IF(C100=1,H$30,IF(D100=1,H$39,IF(E100=1,H$46,IF(F100=1,H$53,IF(G100=1,H$60,\"x\")))))))","v":""},"= Minimum to vaccinate",null,null,{"$f":"L102*0.99+(L102*0.01*B103/100)","v":0},null,"Disease-free ▲"]
[null,null,null,null,null,null,null,null,null,"           Approximately",null,{"$f":"L102-L103","v":0},null,"Cases ","(sick)"]
[{"$f":"A77","v":""},null,{"$f":"A83","v":""},null,{"$f":"A99","v":""},null,null,null,null,null,null,null,null,null,{"$f":"AND(F108=0,AND(I108=0,AND(M108=0)))","v":true}]
["Total individuals in combined groups",null,null,null,null,null,{"$f":"L79+L85+L101","v":0},null,{"$f":"(I90+L102*0.99)+(L102/100)*(B103/100)","v":0},null,"are disease-free = ",null,{"$f":"IF(G106=0,0,100/(G106/I106))","v":0},"%"]
["Total individuals vaccinated in combined groups",null,null,null,null,null,{"$f":"L80+L86+L102","v":0},null,{"$f":"(I90+L102*0.99)+(L102/100)*(B103/100)","v":0},null,"are disease-free = ",null,{"$f":"IF(G107=0,0,100/(G107/I107))","v":0},"%"]
["Vmin C =",{"$f":"IF(F109=\"\",\"\",IF(G106=0,0,F109/100*G106))","v":""},null,null,"Of",{"$f":"G106","v":0},null,"individuals ",{"$f":"G106-(L$80+L$86+L$102)","v":0},null,"are not vaccinated = ",null,{"$f":"IF(I108=0,0,IF(G106=0,0,100/(G106/I108)))","v":0},"% Rem.:",{"$f":"IF(O105=TRUE,0,100-M108)","v":0}]
["Vₑ combined =",null,{"$f":"(M107-INT(M107))*100","v":0},"%","Vmin C =",{"$f":"IF(B101<>0,((1-(1/B101))/C109)*10000,\"\")","v":""},"%","Aproxx.",{"$f":"I93+L104","v":0},null,{"$f":"K$93","v":"=Total cases expected in combined vaccinated groups."}]
[{"$f":"I71","v":""}]
[{"$f":"IF($A110=C$12,1,0)","v":1},{"$f":"IF($A110=C$19,1,0)","v":1},{"$f":"IF($A110=C$26,1,0)","v":1},{"$f":"IF($A110=C$35,1,0)","v":1},{"$f":"IF($A110=C$42,1,0)","v":1},{"$f":"IF($A110=C$49,1,0)","v":1},{"$f":"IF($A110=C$56,1,0)","v":1},null,null,null,null,null,null,"%"]
["R₀ =",{"$f":"IF(A111=1,B$14,IF(B111=1,B$21,IF(C111=1,B$28,IF(D111=1,B$37,IF(E111=1,B$44,IF(F111=1,B$51,IF(G111=1,B$58,\"x\")))))))","v":0},null,null,null,null,null,null,"Total individuals in this group",null,null,{"$f":"IF(A111=1,L$14,IF(B111=1,L$21,IF(C111=1,L$28,IF(D111=1,L$37,IF(E111=1,L$44,IF(F111=1,L$51,IF(G111=1,L$58,\"x\")))))))","v":0}]
[null,null,null,"Vmin =",{"$f":"IF(A111=1,E$15,IF(B111=1,E$22,IF(C111=1,E$29,IF(D111=1,E$38,IF(E111=1,E$45,IF(F111=1,E$52,IF(G111=1,E$59,\"x\")))))))","v":""},"%",null,"           Vaccinated individuals in this group",null,null,null,{"$f":"IF(A111=1,L$15,IF(B111=1,L$22,IF(C111=1,L$29,IF(D111=1,L$38,IF(E111=1,L$45,IF(F111=1,L$52,IF(G111=1,L$59,\"x\")))))))","v":0},null,{"$f":"IF(A111=1,N$15,IF(B111=1,N$22,IF(C111=1,N$29,IF(D111=1,N$38,IF(E111=1,N$45,IF(F111=1,N$52,IF(G111=1,N$59,\"x\")))))))","v":""},"*"]
["Vₑ =",{"$f":"IF(A111=1,B$16,IF(B111=1,B$23,IF(C111=1,B$30,IF(D111=1,B$39,IF(E111=1,B$46,IF(F111=1,B$53,IF(G111=1,B$60,\"x\")))))))","v":0},"%",null,null,null,null,{"$f":"IF(A111=1,H$16,IF(B111=1,H$23,IF(C111=1,H$30,IF(D111=1,H$39,IF(E111=1,H$46,IF(F111=1,H$53,IF(G111=1,H$60,\"x\")))))))","v":""},"= Minimum to vaccinate",null,null,{"$f":"L113*0.99+(L113*0.01*B114/100)","v":0},null,"Disease-free ▲"]
[null,null,null,null,null,null,null,null,null,"           Approximately",null,{"$f":"L113-L114","v":0},null,"Cases ","(sick)"]
[{"$f":"A77","v":""},null,{"$f":"A83","v":""},null,{"$f":"A99","v":""},null,{"$f":"A110","v":""},null,null,null,null,null,null,null,{"$f":"AND(F119=0,AND(I119=0,AND(M119=0)))","v":true}]
["Total individuals in combined groups",null,null,null,null,null,{"$f":"L79+L85+L101+L112","v":0},null,{"$f":"(I106+L113*0.99)+(L113/100)*(B114/100)","v":0},null,"are disease-free = ",null,{"$f":"IF(G117=0,0,100/(G117/I117))","v":0},"%"]
["Total individuals vaccinated in combined groups",null,null,null,null,null,{"$f":"L80+L86+L102+L113","v":0},null,{"$f":"(I106+L113*0.99)+(L113/100)*(B114/100)","v":0},null,"are disease-free = ",null,{"$f":"IF(G118=0,0,100/(G118/I118))","v":0},"%"]
["Vmin C =",{"$f":"IF(F120=\"\",\"\",IF(G117=0,0,F120/100*G117))","v":""},null,null,"Of",{"$f":"G117","v":0},null,"individuals ",{"$f":"G117-(L$80+L$86+L$102+L$113)","v":0},null,"are not vaccinated = ",null,{"$f":"IF(I119=0,0,IF(G117=0,0,100/(G117/I119)))","v":0},"% Rem.:",{"$f":"IF(O116=TRUE,0,100-M119)","v":0}]
["Vₑ combined =",null,{"$f":"(M118-INT(M118))*100","v":0},"%","Vmin C =",{"$f":"IF(B112<>0,((1-(1/B112))/C120)*10000,\"\")","v":""},"%","Aproxx.",{"$f":"I109+L115","v":0},null,{"$f":"K$93","v":"=Total cases expected in combined vaccinated groups."}]
[]
["* This does not mean that individuals in this group can not get the disease! Some can still become ill."]
["▲ A better description of 'protection' or 'disease-free' is: 'Vaccinated individuals are Vₑ % less likely to contract the infectious disease'. "]
["  Also keep in mind that generally partial protection starts 10 to 14 days after the first injection."]
[]
[]
[]
[]
["VaccRate  is © Copyright Christiaan Robert Thonus March 2021"]
[]
[{"$f":"I72","v":""}]
[{"$f":"IF($A131=C$12,1,0)","v":1},{"$f":"IF($A131=C$19,1,0)","v":1},{"$f":"IF($A131=C$26,1,0)","v":1},{"$f":"IF($A131=C$35,1,0)","v":1},{"$f":"IF($A131=C$42,1,0)","v":1},{"$f":"IF($A131=C$49,1,0)","v":1},{"$f":"IF($A131=C$56,1,0)","v":1},null,null,null,null,null,null,"%"]
["R₀ =",{"$f":"IF(A132=1,B$14,IF(B132=1,B$21,IF(C132=1,B$28,IF(D132=1,B$37,IF(E132=1,B$44,IF(F132=1,B$51,IF(G132=1,B$58,\"x\")))))))","v":0},null,null,null,null,null,null,"Total individuals in this group",null,null,{"$f":"IF(A132=1,L$14,IF(B132=1,L$21,IF(C132=1,L$28,IF(D132=1,L$37,IF(E132=1,L$44,IF(F132=1,L$51,IF(G132=1,L$58,\"x\")))))))","v":0}]
[null,null,null,"Vmin =",{"$f":"IF(A132=1,E$15,IF(B132=1,E$22,IF(C132=1,E$29,IF(D132=1,E$38,IF(E132=1,E$45,IF(F132=1,E$52,IF(G132=1,E$59,\"x\")))))))","v":""},"%",null,"           Vaccinated individuals in this group",null,null,null,{"$f":"IF(A132=1,L$15,IF(B132=1,L$22,IF(C132=1,L$29,IF(D132=1,L$38,IF(E132=1,L$45,IF(F132=1,L$52,IF(G132=1,L$59,\"x\")))))))","v":0},null,{"$f":"IF(A132=1,N$15,IF(B132=1,N$22,IF(C132=1,N$29,IF(D132=1,N$38,IF(E132=1,N$45,IF(F132=1,N$52,IF(G132=1,N$59,\"x\")))))))","v":""},"*"]
["Vₑ =",{"$f":"IF(A132=1,B$16,IF(B132=1,B$23,IF(C132=1,B$30,IF(D132=1,B$39,IF(E132=1,B$46,IF(F132=1,B$53,IF(G132=1,B$60,\"x\")))))))","v":0},"%",null,null,null,null,{"$f":"IF(A132=1,H$16,IF(B132=1,H$23,IF(C132=1,H$30,IF(D132=1,H$39,IF(E132=1,H$46,IF(F132=1,H$53,IF(G132=1,H$60,\"x\")))))))","v":""},"= Minimum to vaccinate",null,null,{"$f":"L134*0.99+(L134*0.01*B135/100)","v":0},null,"Disease-free ▲"]
[null,null,null,null,null,null,null,null,null,"           Approximately",null,{"$f":"L134-L135","v":0},null,"Cases ","(sick)"]
[{"$f":"A77","v":""},null,{"$f":"A83","v":""},null,{"$f":"A99","v":""},null,{"$f":"A110","v":""},null,{"$f":"A131","v":""},null,null,null,null,null,{"$f":"AND(F140=0,AND(I140=0,AND(M140=0)))","v":true}]
["Total individuals in combined groups",null,null,null,null,null,{"$f":"L79+L85+L101+L112+L133","v":0},null,{"$f":"(I117+L134*0.99)+(L134/100)*(B135/100)","v":0},null,"are disease-free = ",null,{"$f":"IF(G138=0,0,100/(G138/I138))","v":0},"%"]
["Total individuals vaccinated in combined groups",null,null,null,null,null,{"$f":"L80+L86+L102+L113+L134","v":0},null,{"$f":"(I117+L134*0.99)+(L134/100)*(B135/100)","v":0},null,"are disease-free = ",null,{"$f":"IF(G139=0,0,100/(G139/I139))","v":0},"%"]
["Vmin C =",{"$f":"IF(F141=\"\",\"\",IF(G138=0,0,F141/100*G138))","v":""},null,null,"Of",{"$f":"G138","v":0},null,"individuals ",{"$f":"G138-(L$80+L$86+L$102+L$113+L$134)","v":0},null,"are not vaccinated = ",null,{"$f":"IF(I140=0,0,IF(G138=0,0,100/(G138/I140)))","v":0},"% Rem.:",{"$f":"IF(O137=TRUE,0,100-M140)","v":0}]
["Vₑ combined =",null,{"$f":"(M139-INT(M139))*100","v":0},"%","Vmin C =",{"$f":"IF(B133<>0,((1-(1/B133))/C141)*10000,\"\")","v":""},"%","Aproxx.",{"$f":"I120+L136","v":0},null,{"$f":"K$93","v":"=Total cases expected in combined vaccinated groups."}]
[{"$f":"I73","v":""}]
[{"$f":"IF($A142=C$12,1,0)","v":1},{"$f":"IF($A142=C$19,1,0)","v":1},{"$f":"IF($A142=C$26,1,0)","v":1},{"$f":"IF($A142=C$35,1,0)","v":1},{"$f":"IF($A142=C$42,1,0)","v":1},{"$f":"IF($A142=C$49,1,0)","v":1},{"$f":"IF($A142=C$56,1,0)","v":1},null,null,null,null,null,null,"%"]
["R₀ =",{"$f":"IF(A143=1,B$14,IF(B143=1,B$21,IF(C143=1,B$28,IF(D143=1,B$37,IF(E143=1,B$44,IF(F143=1,B$51,IF(G143=1,B$58,\"x\")))))))","v":0},null,null,null,null,null,null,"Total individuals in this group",null,null,{"$f":"IF(A143=1,L$14,IF(B143=1,L$21,IF(C143=1,L$28,IF(D143=1,L$37,IF(E143=1,L$44,IF(F143=1,L$51,IF(G143=1,L$58,\"x\")))))))","v":0}]
[null,null,null,"Vmin =",{"$f":"IF(A143=1,E$15,IF(B143=1,E$22,IF(C143=1,E$29,IF(D143=1,E$38,IF(E143=1,E$45,IF(F143=1,E$52,IF(G143=1,E$59,\"x\")))))))","v":""},"%",null,"           Vaccinated individuals in this group",null,null,null,{"$f":"IF(A143=1,L$15,IF(B143=1,L$22,IF(C143=1,L$29,IF(D143=1,L$38,IF(E143=1,L$45,IF(F143=1,L$52,IF(G143=1,L$59,\"x\")))))))","v":0},null,{"$f":"IF(A143=1,N$15,IF(B143=1,N$22,IF(C143=1,N$29,IF(D143=1,N$38,IF(E143=1,N$45,IF(F143=1,N$52,IF(G143=1,N$59,\"x\")))))))","v":""},"*"]
["Vₑ =",{"$f":"IF(A143=1,B$16,IF(B143=1,B$23,IF(C143=1,B$30,IF(D143=1,B$39,IF(E143=1,B$46,IF(F143=1,B$53,IF(G143=1,B$60,\"x\")))))))","v":0},"%",null,null,null,null,{"$f":"IF(A143=1,H$16,IF(B143=1,H$23,IF(C143=1,H$30,IF(D143=1,H$39,IF(E143=1,H$46,IF(F143=1,H$53,IF(G143=1,H$60,\"x\")))))))","v":""},"= Minimum to vaccinate",null,null,{"$f":"L145*0.99+(L145*0.01*B146/100)","v":0},null,"Disease-free ▲"]
[null,null,null,null,null,null,null,null,null,"           Approximately",null,{"$f":"L145-L146","v":0},null,"Cases ","(sick)"]
[{"$f":"A77","v":""},null,{"$f":"A83","v":""},null,{"$f":"A99","v":""},null,{"$f":"A110","v":""},null,{"$f":"A131","v":""},null,{"$f":"A142","v":""},null,null,null,{"$f":"AND(F151=0,AND(I151=0,AND(M151=0)))","v":true}]
["Total individuals in combined groups",null,null,null,null,null,{"$f":"L79+L85+L101+L112+L133+L144","v":0},null,{"$f":"(I138+L145*0.99)+(L145/100)*(B146/100)","v":0},null,"are disease-free = ",null,{"$f":"IF(G149=0,0,100/(G149/I149))","v":0},"%"]
["Total individuals vaccinated in combined groups",null,null,null,null,null,{"$f":"L80+L86+L102+L113+L134+L145","v":0},null,{"$f":"(I138+L145*0.99)+(L145/100)*(B146/100)","v":0},null,"are disease-free = ",null,{"$f":"IF(G150=0,0,100/(G150/I150))","v":0},"%"]
["Vmin C =",{"$f":"IF(F152=\"\",\"\",IF(G149=0,0,F152/100*G149))","v":""},null,null,"Of",{"$f":"G149","v":0},null,"individuals ",{"$f":"G149-(L$80+L$86+L$102+L$113+L$134+L$145)","v":0},null,"are not vaccinated = ",null,{"$f":"IF(I151=0,0,IF(G149=0,0,100/(G149/I151)))","v":0},"% Rem.:",{"$f":"IF(O148=TRUE,0,100-M151)","v":0}]
["Vₑ combined =",null,{"$f":"(M150-INT(M150))*100","v":0},"%","Vmin C =",{"$f":"IF(B144<>0,((1-(1/B144))/C152)*10000,\"\")","v":""},"%","Aproxx.",{"$f":"I141+L147","v":0},null,{"$f":"K$93","v":"=Total cases expected in combined vaccinated groups."}]
[]
["* This does not mean that individuals in this group can not get the disease! Some can still become ill."]
["▲ A better description of 'protection' or 'disease-free' is: 'Vaccinated individuals are Vₑ % less likely to contract the infectious disease'. "]
["  Also keep in mind that generally partial protection starts 10 to 14 days after the first injection."]
[]
[]
[]
[]
[]
["VaccRate  is © Copyright Christiaan Robert Thonus March 2021"]
[]
[{"$f":"I74","v":""}]
[{"$f":"IF($A164=C$12,1,0)","v":1},{"$f":"IF($A164=C$19,1,0)","v":1},{"$f":"IF($A164=C$26,1,0)","v":1},{"$f":"IF($A164=C$35,1,0)","v":1},{"$f":"IF($A164=C$42,1,0)","v":1},{"$f":"IF($A164=C$49,1,0)","v":1},{"$f":"IF($A164=C$56,1,0)","v":1},null,null,null,null,null,null,"%"]
["R₀ =",{"$f":"IF(A165=1,B$14,IF(B165=1,B$21,IF(C165=1,B$28,IF(D165=1,B$37,IF(E165=1,B$44,IF(F165=1,B$51,IF(G165=1,B$58,\"x\")))))))","v":0},null,null,null,null,null,null,"Total individuals in this group",null,null,{"$f":"IF(A165=1,L$14,IF(B165=1,L$21,IF(C165=1,L$28,IF(D165=1,L$37,IF(E165=1,L$44,IF(F165=1,L$51,IF(G165=1,L$58,\"x\")))))))","v":0}]
[null,null,null,"Vmin =",{"$f":"IF(A165=1,E$15,IF(B165=1,E$22,IF(C165=1,E$29,IF(D165=1,E$38,IF(E165=1,E$45,IF(F165=1,E$52,IF(G165=1,E$59,\"x\")))))))","v":""},"%",null,"           Vaccinated individuals in this group",null,null,null,{"$f":"IF(A165=1,L$15,IF(B165=1,L$22,IF(C165=1,L$29,IF(D165=1,L$38,IF(E165=1,L$45,IF(F165=1,L$52,IF(G165=1,L$59,\"x\")))))))","v":0},null,{"$f":"IF(A165=1,N$15,IF(B165=1,N$22,IF(C165=1,N$29,IF(D165=1,N$38,IF(E165=1,N$45,IF(F165=1,N$52,IF(G165=1,N$59,\"x\")))))))","v":""},"*"]
["Vₑ =",{"$f":"IF(A165=1,B$16,IF(B165=1,B$23,IF(C165=1,B$30,IF(D165=1,B$39,IF(E165=1,B$46,IF(F165=1,B$53,IF(G165=1,B$60,\"x\")))))))","v":0},"%",null,null,null,null,{"$f":"IF(A165=1,H$16,IF(B165=1,H$23,IF(C165=1,H$30,IF(D165=1,H$39,IF(E165=1,H$46,IF(F165=1,H$53,IF(G165=1,H$60,\"x\")))))))","v":""},"= Minimum to vaccinate",null,null,{"$f":"L167*0.99+(L167*0.01*B168/100)","v":0},null,"Disease-free ▲"]
[null,null,null,null,null,null,null,null,null,"           Approximately",null,{"$f":"L167-L168","v":0},null,"Cases ","(sick)"]
[{"$f":"A77","v":""},null,{"$f":"A83","v":""},null,{"$f":"A99","v":""},null,{"$f":"A110","v":""},null,{"$f":"A131","v":""},null,{"$f":"A142","v":""},null,{"$f":"A164","v":""},null,{"$f":"AND(F173=0,AND(I173=0,AND(M173=0)))","v":true}]
["Total individuals in combined groups",null,null,null,null,null,{"$f":"L79+L85+L101+L112+L133+L144+L166","v":0},null,{"$f":"(I149+L167*0.99)+(L167/100)*(B168/100)","v":0},null,"are disease-free = ",null,{"$f":"IF(G171=0,0,100/(G171/I171))","v":0},"%"]
["Total individuals vaccinated in combined groups",null,null,null,null,null,{"$f":"L80+L86+L102+L113+L134+L145+L167","v":0},null,{"$f":"(I149+L167*0.99)+(L167/100)*(B168/100)","v":0},null,"are disease-free = ",null,{"$f":"IF(G172=0,0,100/(G172/I172))","v":0},"%"]
["Vmin C =",{"$f":"IF(F174=\"\",\"\",IF(G171=0,0,F174/100*G171))","v":""},null,null,"Of",{"$f":"G171","v":0},null,"individuals ",{"$f":"G171-(L$80+L$86+L$102+L$113+L$134+L$145+L$167)","v":0},null,"are not vaccinated = ",null,{"$f":"IF(I173=0,0,IF(G171=0,0,100/(G171/I173)))","v":0},"% Rem.:",{"$f":"IF(O170=TRUE,0,100-M173)","v":0}]
["Vₑ combined =",null,{"$f":"(M172-INT(M172))*100","v":0},"%","Vmin C =",{"$f":"IF(B166<>0,((1-(1/B166))/C174)*10000,\"\")","v":""},"%","Aproxx.",{"$f":"I152+L169","v":0},null,{"$f":"K$93","v":"=Total cases expected in combined vaccinated groups."}]
[]
["* This does not mean that individuals in this group can not get the disease! Some can still become ill."]
["▲ A better description of 'protection' or 'disease-free' is: 'Vaccinated individuals are Vₑ % less likely to contract the infectious disease'. "]
["  Also keep in mind that generally partial protection starts 10 to 14 days after the first injection."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["VaccRate  is © Copyright Christiaan Robert Thonus March 2021"]

{"sheet":"Vaccine Efficacy Calculator","index":2,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[15,2,15,3],[18,0,18,1],[18,2,18,3],[18,7,18,8],[17,2,17,3],[3,0,3,15],[8,14,9,14],[5,9,5,10],[5,6,5,7],[5,3,5,4],[5,0,5,1],[8,3,8,4],[9,3,9,4],[8,6,8,7],[9,6,9,7],[8,0,8,1],[9,0,9,1],[8,9,8,10],[9,9,9,10],[8,12,8,13],[9,12,9,13],[33,0,33,14],[35,0,35,13],[70,0,70,13],[5,12,5,13],[29,9,29,10],[16,2,16,3],[16,5,16,6],[17,5,17,6],[16,7,17,10],[16,11,17,11],[16,12,17,13],[6,12,6,13],[12,5,13,5],[12,2,13,4],[12,6,13,6],[15,0,15,1]]}
[]
[]
[]
["Vaccine efficacy calculator"]
[]
["GROUP",null,null,"SIZE",null,null,"INFECTED",null,null,"RISK %",null,null,"POPULATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,100000]
[]
["Placebo",null,null,42000,null,null,420,null,null,{"$f":"IF(D9=\"\",0,(G9/D9)*100)","v":1},null,null,{"$f":"IF(M7=\"\",0,M7*J9*0.01)","v":1000},null,"Infected"]
["Vaccine",null,null,42000,null,null,21,null,null,{"$f":"IF(D10=\"\",0,(G10/D10)*100)","v":0.05},null,null,{"$f":"IF(M7=\"\",0,M7*J10*0.01)","v":50}]
[]
[]
[null,null,"Vaccine efficacy = ",null,null,{"$f":"IF(D9=\"\",0,(J9-J10)/J9*100)","v":95},"%"]
[]
[]
["Approximately"]
["          Disease-free:",null,{"$f":"M7*((100-J9)/100)+(M7*J9/100*F13*0.01)","v":99950},null,"of",{"$f":"M7","v":100000},null,"If all are vaccinated with a vaccine with ",null,null,null,{"$f":"F13","v":95},"% efficacy."]
[null,"Sick:",{"$f":"M7-C17","v":50},null,"of",{"$f":"M7","v":100000}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["VaccRate is © Christiaan Robert Thonus March 2021"]

{"sheet":"How to","index":3,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[3,0,3,15],[69,0,69,14],[48,0,48,15],[34,0,34,14],[50,2,52,8],[56,0,58,14],[60,3,62,9],[61,0,61,2]]}
["Scientists tell us that the degree of vaccination of the population is of great importance when trying to stop a pandemic. Besides that there's another "]
["important factor in the fight against an infectious disease: the degree of efficacy of a vaccine."]
[]
["Keywords and abbreviations"]
["Vaccine:"]
["- A preparation that is administered (as by injection) to stimulate the body's immune response against a specific infectious disease. ",null,null,null,null,null,null,null,null,null,null,null,null,"(Merriam-Webster)"]
["- Substance that is injected into the bloodstream and protects the body by making it have a mild form of the disease.",null,null,null,null,null,null,null,null,null,null,null,"(Oxford Dictionary)"]
["Vaccination: "]
["- Active immunization against a variety of microorganisms or their components, with the ultimate goal of protecting the host against subsequent challenge by the"]
["  naturally occurring infectious agent.",null,null,null,"(McGraw-Hill Encyclopedia of Science & Technology)"]
["Vaccine efficacy:"]
["- % reduction in disease incidence in a vaccinated group compared to an unvaccinated group under optimal conditions."]
["Vaccine effectiveness:"]
["- Ability of vaccine to prevent outcomes of interest in the “real world”."]
["Vmin:"]
["- The minimum level of vaccination in a group expressed in % in order to achieve the so called collective protection by disrupting the chain of infection."]
["Vmin C:"]
["- The hypothetical minimum level of vaccination in a combined group in %."]
["R₀ :"]
["- The basic reproduction number of an infectious disease. This is defined as the average number of secondary cases that would be generated by a primary case"]
["  in a totally susceptible population. This is not the effective reproduction number!"]
["Vₑ :"]
["- Vaccine efficacy in %. "]
["Vₑ min:"]
["- Minimal vaccine efficacy % for given R₀. The higher R₀ the higher the vaccine efficacy % has to be."]
["Vₑ combined:"]
["- The hypothetical % of vaccine efficacy in a combined vaccinated group. Individuals in this group are vaccinated with different vaccines."]
["Attack rate = incidence proportion = risk: "]
["- The proportion of people who become ill with a disease in a population initially free of disease.    (Britannica)"]
["- Number of new cases of disease during specified time interval divided by population at start of time interval.    (Centers for Disease Control and Prevention)"]
["Herd immunity = population immunity:"]
["- Herd immunity describes a state in which an infectious disease transmissible through human contact is unlikely to spread because a large proportion of the"]
["  population is immune to the disease (Vmin)."]
[]
["VaccRate is © Christiaan Robert Thonus March 2021"]
["→","Type the names of the vaccines in the designated cells."]
["→","Type the right numbers in the designated cells."]
["→","You can combine up to 7 vaccines in VaccRate."]
["→","On page 3 you can choose the vaccines you want to combine."]
["→","Careful! A professor proclaimed in a newspaper that when two groups of people are vaccinated with two different vaccines (with significantly different Vₑ) "]
[null,"the mean vaccine efficacy is obtained by simply adding up the two respective percentages and dividing the result by 2."]
[null,"He forgot to mention that this is only true if the number of vaccinated individuals in both groups are equal!"]
["→","Keep in mind that the numbers you obtain are theoretical! Remember that Vₑ is not calculated in a real world scenario."]
["→","For practical reasons all numbers are rounded."]
["→","We make the assumption that the cumulated Covid-19 attack rate over a period of 3 months is about 1% without a vaccine."]
["→","Also note that when Vₑ < Vₑ min then Vmin > 100%  meaning that the vaccine will not achieve the threshold level for group protection (herd immunity)."]
["→","Make sure that you use the same R₀ for all the vaccines you want to combine!"]
[]
["Calculations"]
[]
[null,null,"Vaccinated*0 .99+(Vaccinated*0.01*Vₑ*0.01)"]
["Disease-free ="]
[]
[]
["Combined disease-free ="]
[]
["(Vaccinated 1*0.99+Vaccinated 2*0.99+ ...)+(Vaccinated 1*0.01)*(Vₑ1*0.01)+(Vaccinated 2*0.01)*(Vₑ2*0.01)+ …"]
[]
[]
[]
[null,null,null,"(% combined disease-free - (100% - attack rate %))*100"]
["Vₑ combined (%) ="]
[]
[]
["References"]
["*","Nieuw Coronavirus (Ziekte: COVID-19, Virus: SARS-CoV-2) | Coronavirus Covid-19 (sciensano.be)",null,null,null,null,null,null,null,null,"Accessed 2 Mar. 2021"]
["*","Coronavirus Disease 2019 (COVID-19) CDC",null,null,null,null,"Accessed 7 Mar. 2021"]
["*","COVID-19 Resource Centre (thelancet.com)",null,null,null,null,"Accessed 7 Mar. 2021"]
[]
["VaccRate is © Christiaan Robert Thonus March 2021"]