Excel scheduling calendar of visits to houses
3987
£80(approx. $99)
- Posted:
- Proposals: 6
- Remote
- #245439
- Archived
Description
Experience Level: Intermediate
To create a complicated Excel table.
Excel table showing
50 uneven groups of houses need to be visited, 100,000 total houses. 50 house groups,
initial parameters:
# individuals visited per Saturday
# visited per weekday session 1
# visited per weekday session 2
response rate Saturday
response rate weekday session 1
response rate weekday session 2
in Phase 1 in phase 2 and in phase 3
anticipated yearly move out rate uniform
Phase one
session Saturday start new houses
session Tuesday is houses of that previous Saturdays that where not met
session Thursday is houses of week before Saturday that where not met
no house gets visited more than 3 times before being put in next activity period to back of list
if you run out of a house group in a session go onto next house group in list order
Phase 2
visit those houses that where visited 3 time with no success
visit those houses that would have moved out
Phase 3 is same as phase 2
Pivot table report
Pivot table date each house group is completed by
End of each activity period review
dates of upcoming visit days are provided.
will be quick for someone very competent at excel but needs to be done quickly.
Kind regards,
Excel table showing
50 uneven groups of houses need to be visited, 100,000 total houses. 50 house groups,
initial parameters:
# individuals visited per Saturday
# visited per weekday session 1
# visited per weekday session 2
response rate Saturday
response rate weekday session 1
response rate weekday session 2
in Phase 1 in phase 2 and in phase 3
anticipated yearly move out rate uniform
Phase one
session Saturday start new houses
session Tuesday is houses of that previous Saturdays that where not met
session Thursday is houses of week before Saturday that where not met
no house gets visited more than 3 times before being put in next activity period to back of list
if you run out of a house group in a session go onto next house group in list order
Phase 2
visit those houses that where visited 3 time with no success
visit those houses that would have moved out
Phase 3 is same as phase 2
Pivot table report
Pivot table date each house group is completed by
End of each activity period review
dates of upcoming visit days are provided.
will be quick for someone very competent at excel but needs to be done quickly.
Kind regards,
Thomas B.
100% (9)Projects Completed
22
Freelancers worked with
19
Projects awarded
37%
Last project
16 Oct 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies