Forum Discussion
CONTACT TRACING
Microsoft Excel
@msexcel
I need help with solving a problem
A company runs 6 shelters in a city. Each shelter keeps a log book of login and logout times of homeless people that come to the shelter. Attached is the log data from the shelters.
On 9th May 2020, Person 1 tested positive to the corona virus after leaving Shelter 3 and was immediately isolated. The company, in a bid to curb the spread of the virus in any of their shelters, decided to perform a contact tracing exercise of those that could have been exposed to Person 1.
The following assumptions are made for the purpose of this exercise.
The infection is only passed from person to person and cannot be transmitted from surfaces or the air. This implies that when a person leaves a place, the people that visit the place after him are not at risk.
There is a 14 day period in which the infected person could be asymptomatic.
The infection rate of the virus is exponential i.e. one person can infect another person, who can then in turn infect other people he comes in contact with.
You have been saddled with the task of generating a report showing a list of those that have visited any of the shelters and could have been infected through person to person contact starting with the index case.
Generate a routine that accepts the following parameters, and outputs the list of probable infected persons.
Person infected
Last Date/time he left the Shelter just before isolation
Last visited Shelter before being isolated
The routine should be dynamic such that slotting in different parameters would yield an accurate contact trace list.
@msexcel
I need help with solving a problem
A company runs 6 shelters in a city. Each shelter keeps a log book of login and logout times of homeless people that come to the shelter. Attached is the log data from the shelters.
On 9th May 2020, Person 1 tested positive to the corona virus after leaving Shelter 3 and was immediately isolated. The company, in a bid to curb the spread of the virus in any of their shelters, decided to perform a contact tracing exercise of those that could have been exposed to Person 1.
The following assumptions are made for the purpose of this exercise.
The infection is only passed from person to person and cannot be transmitted from surfaces or the air. This implies that when a person leaves a place, the people that visit the place after him are not at risk.
There is a 14 day period in which the infected person could be asymptomatic.
The infection rate of the virus is exponential i.e. one person can infect another person, who can then in turn infect other people he comes in contact with.
You have been saddled with the task of generating a report showing a list of those that have visited any of the shelters and could have been infected through person to person contact starting with the index case.
Generate a routine that accepts the following parameters, and outputs the list of probable infected persons.
Person infected
Last Date/time he left the Shelter just before isolation
Last visited Shelter before being isolated
The routine should be dynamic such that slotting in different parameters would yield an accurate contact trace list.
Hi
It may be that all you need to is apply filters to your data as in the attached.
So if you filter on person 1 , you can find details of all shelters they have visited.
Does that help?
Peter
- Hi. No really.. Remember the conditions embedded in the Problem
Some people are infected who infect others
The time they come in and go out determines if there has been any contact etc.
