Forum Discussion
tiwasalvation
May 14, 2020Copper Contributor
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....
peteryac60
May 15, 2020Iron Contributor
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
tiwasalvation
May 15, 2020Copper Contributor
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.
Some people are infected who infect others
The time they come in and go out determines if there has been any contact etc.