Michael Tauraso comments

Repositories
Issues
Comments

Results 2 comments of


                                            Michael Tauraso

Default location changes calculation for Avg Resident vaccinated/unvaccinated when it should not

I am fairly certain the issue is in how the E column is calculated on the log sheets. There is first a lookup of a default-location person record, which is...

Default location changes calculation for Avg Resident vaccinated/unvaccinated when it should not

After some experimentation I believe the part of column E's formula which reads `VLOOKUP(U6, LOCATION_TABLE, 2, FALSE) /PREVALENCE_LOCAL` should read ``` if(T6="Avg local Resident (unvaccinated)", VLOOKUP(U6, LOCATION_TABLE, 3, FALSE)/'📍 Locations'!$O$3,...