Spreadsheet: 2983d61d-89db-462b-902f-10baa3960c84
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | i1 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | i2 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | i3 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | i4 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | i5 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | i6 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | i7 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | i8 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | i9 | Unnamed: 36 | Unnamed: 37 | Unnamed: 38 | i10 | Unnamed: 40 | Unnamed: 41 | Unnamed: 42 | i11 | Unnamed: 44 | Unnamed: 45 | Unnamed: 46 | i12 | Unnamed: 48 | Unnamed: 49 | Unnamed: 50 | i13 | Unnamed: 52 | Unnamed: 53 | Unnamed: 54 | Unnamed: 55 | Unnamed: 56 | Unnamed: 57 | Unnamed: 58 | Unnamed: 59 | Unnamed: 60 | Unnamed: 61
 | j | V | Δt | f | a(t) | ri | Δt | f | a(t) | ri | Δt | f | a(t) | ri | Δt | f | a(t) | ri | Δt | f | a(t) | ri | Δt | f | a(t) | ri | Δt | f | a(t) | ri | Δt | f | a(t) | ri | Δt | f | a(t) | ri | Δt | f | a(t) | ri | Δt | f | a(t) | ri | Δt | f | a(t) | ri | Δt | f | a(t) | ri |  | rj | h | rj/h | R0 I | R0 e | R0
house | 1 | 20 | 720 | 7 | 0.1 | 1 | 960 | 7 | 0.1 | 1.333333333333333 | 720 | 7 | 0.1 | 1 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 | 60 | 5 | 1 | 0.5952380952380952 | 60 | 2 | 1 | 0.2380952380952381 |  |  | 1 | 0 |  |  | 1 | 0 |  | 1 | 1 | 0 |  |  | 1 | 0 | 60 | 3 | 1 | 0.3571428571428571 |  | 4.523809523809524 | 0.1327838827838828 | 2.620689655172414 | 0.2929298172562342 | 0.05523736151069585 | 0.131064902331443
market | 2 | 2 | 480 | 6 | 1 | 0.5714285714285714 |  |  | 1 | 0 |  |  | 1 | 0 | 120 | 6 | 1 | 0.1428571428571428 |  |  | 1 | 0 |  | 1 | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 | 60 | 2 | 1 | 0.02380952380952381 |  |  | 1 | 0 | 120 | 6 | 1 | 0.1428571428571428 | 30 | 2 | 1 | 0.0119047619047619 |  | 0.8928571428571428 | 0.03434065934065934 | 2 | 0.04412204657425964 | 0.124393722057651 | 0
house/lunchette | 3 | 15 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 | 1080 | 7 | 0.1 | 1.125 | 720 | 7 | 0.1 | 0.75 | 720 | 7 | 0.1 | 0.75 | 960 | 7 | 0.1 | 1 | 45 | 5 | 1 | 0.3348214285714285 | 60 | 5 | 1 | 0.4464285714285714 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 | 30 | 4 | 1 | 0.1785714285714285 |  | 4.584821428571429 | 0.1908195970695971 | 1.848230353929214 | 0.2093737345285947 | 0.01911772998104946 | 0.0552930056710775
store | 4 | 5 | 30 | 3 | 1 | 0.04464285714285714 |  | 1 | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  | 6 | 1 | 0 | 600 | 6 | 1 | 1.785714285714286 |  |  | 1 | 0 | 60 | 2 | 1 | 0.05952380952380952 |  |  | 1 | 0 |  | 1.889880952380952 | 0.02907509157509158 | 5 | 0.233479163122124 | 0.9182607435358103 | 0
house | 5 | 20 | 60 | 2 | 1 | 0.2380952380952381 | 60 | 2 | 1 | 0.2380952380952381 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 | 720 | 7 | 0.1 | 1 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 | 60 | 5 | 1 | 0.5952380952380952 |  | 2.071428571428572 | 0.04258241758241758 | 3.741935483870968 | 0.1915181479687864 | 0.3511635065975783 | 0.3931947069943288
plaza | 6 | 0 |  |  | 1 | 0 |  |  | 1 | 0 | 120 | 2 | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 | 120 | 2 | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 | 120 | 2 | 1 | 0 | 120 | 2 | 1 | 0 |  | 1 | 1 | 0 |  | 0 | 0.007326007326007326 | 0 | 0 | 0 | 0
house/shop | 7 | 20 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 | 960 | 7 | 0.1 | 1.333333333333333 | 720 | 7 | 0.1 | 1 |  |  | 1 | 0 |  |  | 1 | 0 |  | 1 | 1 | 0 |  | 2.333333333333333 | 0.08974358974358974 | 2 | 0.1153056150473985 | 0.04759963854246849 | 0.1965973534971644
restaurant | 8 | 2 | 60 | 1 | 1 | 0.0119047619047619 | 60 | 1 | 1 | 0.0119047619047619 | 60 | 1 | 1 | 0.0119047619047619 |  | 1 | 1 | 0 | 30 | 6 | 1 | 0.03571428571428571 |  |  | 1 | 0 |  |  | 1 | 0 | 120 | 2 | 1 | 0.04761904761904762 | 60 | 3 | 1 | 0.03571428571428571 | 60 | 3 | 1 | 0.03571428571428571 | 60 | 1 | 1 | 0.0119047619047619 |  |  | 1 | 0 | 60 | 1 | 1 | 0.0119047619047619 |  | 0.2142857142857143 | 0.008241758241758242 | 2 | 0.01058929117782232 | 0.5183071752402126 | 0
house | 9 | 25 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 | 120 | 1 | 1 | 0.2976190476190476 |  |  | 1 | 0 | 120 | 1 | 1 | 0.2976190476190476 | 120 | 1 | 1 | 0.2976190476190476 |  |  | 1 | 0 |  | 1 | 1 | 0 |  |  | 1 | 0 | 720 | 7 | 0.1 | 1.25 | 720 | 7 | 0.1 | 1.25 |  |  | 1 | 0 |  | 3.392857142857142 | 0.07967032967032966 | 3.275862068965517 | 0.2746217036777195 | 0.1438472956007704 | 0.3071833648393195
school | 10 | 1 |  |  | 1 | 0 | 20 | 0.1 | 1 | 0.0001984126984126984 | 480 | 5 | 1 | 0.2380952380952381 | 15 | 5 | 1 | 0.00744047619047619 |  | 1 | 1 | 0 | 480 | 5 | 1 | 0.2380952380952381 | 480 | 5 | 1 | 0.2380952380952381 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  | 0.7219246031746032 | 0.05553266178266178 | 1 | 0.0178375629400493 | 0.01923085575303799 | 0
house | 11 | 15 |  |  | 1 | 0 | 30 | 2 | 1 | 0.08928571428571427 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  | 1 | 1 | 0 | 45 | 2 | 1 | 0.1339285714285714 | 45 | 2 | 1 | 0.1339285714285714 | 720 | 7 | 0.1 | 0.75 |  | 1.107142857142857 | 0.0402930402930403 | 2.113636363636363 | 0.0578199364879957 | 0.1184070624409319 | 0.22117202268431
soccer field | 12 | 0 | 60 | 1 | 1 | 0 | 120 | 1 | 1 | 0 | 60 | 4 | 1 | 0 |  |  | 1 | 0 | 120 | 1 | 1 | 0 | 60 | 4 | 1 | 0 |  |  | 1 | 0 | 120 | 1 | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 | 120 | 1 | 1 | 0 |  |  | 1 | 0 | 120 | 2 | 1 | 0 |  | 0 | 0.009615384615384616 | 0 | 0 | 0 | 0
clinic | 13 | 5 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 |  |  | 1 | 0 | 480 | 5 | 1 | 1.19047619047619 |  | 1 | 1 | 0 | 30 | 1 | 1 | 0.01488095238095238 |  | 1.205357142857143 | 0.01854395604395604 | 5 | 0.1489119071881263 | 1.439742153445036 | 0
Total mosquitoes |  | 130 | 8250 |  |  | 1.866071428571429 | 7082 |  |  | 1.67281746031746 | 7980 |  |  | 1.25 | 8475 |  |  | 1.572916666666667 | 5340 |  |  | 0.7857142857142857 | 8040 |  |  | 1.285714285714286 | 9540 |  |  | 2.130952380952381 | 5745 |  |  | 1.620535714285714 | 7200 |  |  | 1.81547619047619 | 8940 |  |  | 2.845238095238095 | 7950 |  |  | 2.586309523809524 | 6210 |  |  | 1.586309523809524 | 6030 |  |  | 1.919642857142857 | Totals | 22.93769841269841 | 0.738568376068376 | 30.60035392557447 | 1.59650892596911 | 3.755307244705242 | 1.304505356017643
Total in houses |  | 115
Parameter | Definition
j | site reference
V | number of female mosquitoes
Δt | duration of visits to site j
f | frequency of visits to site j within some interval, e.g. 1 week
a(t) | probability of biting as a function of the time of day of a visit
ri | individual risk: V * (Δt * f )/ (dt * P) * a(t)
rj | site risk: Σ ri
hj | human host time at location j
R0 | pathogen transmission rate
R0 I | pathogen transmission rate per individual
R0 e | pathogen transmission rate per site with exposure included