Work schedule database design
- Posted:
- Proposals: 3
- Remote
- #1565517
- Awarded
have already sent a proposal. Description
Experience Level: Intermediate
I need a work schedule database. Presently the data is in two spreadsheet tables. The master table lists the "slot" (e.g. S1, S2,...) for each employee (A, BW,...) for wach week. The second lists the "route" (SH2, N/S/LS,...) for the slot for each day of the week.
I would like to be able too query, for example:
What route does employee A have Tuesday the week of 5/8/17?
Who is doing route CF/CDI on Friday the week of 5/15/17?
About how many hours would this take to set up?
I would like to be able too query, for example:
What route does employee A have Tuesday the week of 5/8/17?
Who is doing route CF/CDI on Friday the week of 5/15/17?
About how many hours would this take to set up?
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hello, so it seems that master table A and B provided in the spreadsheet are just transposed data from each other and then you have the schedule table. The questions I have are
1. I am guessing you need CRUD screens for managing the routes and employees with slots etc. Is that correct?
2. Do you need historical data? What I mean by that is say you change the schedule for some one for Tuesdays from 05/15 onward. In that case, reports for period before 05/15 will need to reflect that old schedule OR then just always the latest data and hence current route schedule?
If you can let me know about these two, I will be able to make an informed bid.
Thanks.