Microsoft Excel Rotas [on hold]
up vote
-1
down vote
favorite
All,
Looking for a solutions. Not a super user of excel but good on basics of it.
Need a spreadsheet for the following
Multiple employees working shifts on multiple sites.
Spreadsheet needs to allow me to enter all rotas-persons on different sites and be able to see (in a weekly view) where everybody is and how may hours each employee is doing and where- Also to see who is free at any time. and make sure nobody is double booked anywhere
Any ideas
microsoft-excel
asked Dec 3 at 10:38
t mac
4
put on hold as too broad by Kamil Maciorowski, Twisty Impersonator, fixer1234, bertieb, n8te Dec 12 at 7:04
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
up vote
-1
down vote
favorite
All,
Looking for a solutions. Not a super user of excel but good on basics of it.
Need a spreadsheet for the following
Multiple employees working shifts on multiple sites.
Spreadsheet needs to allow me to enter all rotas-persons on different sites and be able to see (in a weekly view) where everybody is and how may hours each employee is doing and where- Also to see who is free at any time. and make sure nobody is double booked anywhere
Any ideas
microsoft-excel
asked Dec 3 at 10:38
t mac
4
put on hold as too broad by Kamil Maciorowski, Twisty Impersonator, fixer1234, bertieb, n8te Dec 12 at 7:04
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
That's quite a big ask. Have you searched for commercially available software to do what you need?
– Mark Fitzgerald
Dec 3 at 11:00
1
Hi, what have you tried so far?
– dmb
Dec 3 at 12:14
Step 1 : list your list (Multiple employees working shifts on multiple sites) | Step 2 : list your constrain (number of maximum available employee, number of people/shift, minimum manpower allowed)
– p._phidot_
Dec 4 at 6:57
... | Step 3 : make a simple calendar, fill it up with [ Step1 + Step2 ], then share where you get stuck. || Putting all the info in one step invites a hurricane when you are brainstorming. It need not to be pretty.. Something that just work will do just fine. || You may start by creating a sample excel with all details in Step 1, then start step 2. Then you may share which part you can't build/list.
– p._phidot_
Dec 4 at 7:06
1
As someone who works in high volume manufacturing that's spread over multiple sites, I have to second @Mark Fitzgerald's comment that you should research what software packages are available to do this. Trying to build something like this in Excel would be a massive undertaking and there are probably much easier solutions out there.
– user2800
Dec 4 at 17:14
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
All,
Looking for a solutions. Not a super user of excel but good on basics of it.
Need a spreadsheet for the following
Multiple employees working shifts on multiple sites.
Spreadsheet needs to allow me to enter all rotas-persons on different sites and be able to see (in a weekly view) where everybody is and how may hours each employee is doing and where- Also to see who is free at any time. and make sure nobody is double booked anywhere
Any ideas
microsoft-excel
asked Dec 3 at 10:38
t mac
4
All,
Looking for a solutions. Not a super user of excel but good on basics of it.
Need a spreadsheet for the following
Multiple employees working shifts on multiple sites.
Spreadsheet needs to allow me to enter all rotas-persons on different sites and be able to see (in a weekly view) where everybody is and how may hours each employee is doing and where- Also to see who is free at any time. and make sure nobody is double booked anywhere
Any ideas
microsoft-excel
microsoft-excel
asked Dec 3 at 10:38
t mac
4
asked Dec 3 at 10:38
t mac
4
asked Dec 3 at 10:38
t mac
4
asked Dec 3 at 10:38
t mac
4
asked Dec 3 at 10:38
t mac
4
4
put on hold as too broad by Kamil Maciorowski, Twisty Impersonator, fixer1234, bertieb, n8te Dec 12 at 7:04
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
put on hold as too broad by Kamil Maciorowski, Twisty Impersonator, fixer1234, bertieb, n8te Dec 12 at 7:04
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
That's quite a big ask. Have you searched for commercially available software to do what you need?
– Mark Fitzgerald
Dec 3 at 11:00
1
Hi, what have you tried so far?
– dmb
Dec 3 at 12:14
Step 1 : list your list (Multiple employees working shifts on multiple sites) | Step 2 : list your constrain (number of maximum available employee, number of people/shift, minimum manpower allowed)
– p._phidot_
Dec 4 at 6:57
... | Step 3 : make a simple calendar, fill it up with [ Step1 + Step2 ], then share where you get stuck. || Putting all the info in one step invites a hurricane when you are brainstorming. It need not to be pretty.. Something that just work will do just fine. || You may start by creating a sample excel with all details in Step 1, then start step 2. Then you may share which part you can't build/list.
– p._phidot_
Dec 4 at 7:06
1
As someone who works in high volume manufacturing that's spread over multiple sites, I have to second @Mark Fitzgerald's comment that you should research what software packages are available to do this. Trying to build something like this in Excel would be a massive undertaking and there are probably much easier solutions out there.
– user2800
Dec 4 at 17:14
add a comment |
That's quite a big ask. Have you searched for commercially available software to do what you need?
– Mark Fitzgerald
Dec 3 at 11:00
1
Hi, what have you tried so far?
– dmb
Dec 3 at 12:14
Step 1 : list your list (Multiple employees working shifts on multiple sites) | Step 2 : list your constrain (number of maximum available employee, number of people/shift, minimum manpower allowed)
– p._phidot_
Dec 4 at 6:57
... | Step 3 : make a simple calendar, fill it up with [ Step1 + Step2 ], then share where you get stuck. || Putting all the info in one step invites a hurricane when you are brainstorming. It need not to be pretty.. Something that just work will do just fine. || You may start by creating a sample excel with all details in Step 1, then start step 2. Then you may share which part you can't build/list.
– p._phidot_
Dec 4 at 7:06
1
As someone who works in high volume manufacturing that's spread over multiple sites, I have to second @Mark Fitzgerald's comment that you should research what software packages are available to do this. Trying to build something like this in Excel would be a massive undertaking and there are probably much easier solutions out there.
– user2800
Dec 4 at 17:14
That's quite a big ask. Have you searched for commercially available software to do what you need?
– Mark Fitzgerald
Dec 3 at 11:00
That's quite a big ask. Have you searched for commercially available software to do what you need?
– Mark Fitzgerald
Dec 3 at 11:00
1
1
Hi, what have you tried so far?
– dmb
Dec 3 at 12:14
Hi, what have you tried so far?
– dmb
Dec 3 at 12:14
Step 1 : list your list (Multiple employees working shifts on multiple sites) | Step 2 : list your constrain (number of maximum available employee, number of people/shift, minimum manpower allowed)
– p._phidot_
Dec 4 at 6:57
Step 1 : list your list (Multiple employees working shifts on multiple sites) | Step 2 : list your constrain (number of maximum available employee, number of people/shift, minimum manpower allowed)
– p._phidot_
Dec 4 at 6:57
... | Step 3 : make a simple calendar, fill it up with [ Step1 + Step2 ], then share where you get stuck. || Putting all the info in one step invites a hurricane when you are brainstorming. It need not to be pretty.. Something that just work will do just fine. || You may start by creating a sample excel with all details in Step 1, then start step 2. Then you may share which part you can't build/list.
– p._phidot_
Dec 4 at 7:06
... | Step 3 : make a simple calendar, fill it up with [ Step1 + Step2 ], then share where you get stuck. || Putting all the info in one step invites a hurricane when you are brainstorming. It need not to be pretty.. Something that just work will do just fine. || You may start by creating a sample excel with all details in Step 1, then start step 2. Then you may share which part you can't build/list.
– p._phidot_
Dec 4 at 7:06
1
1
As someone who works in high volume manufacturing that's spread over multiple sites, I have to second @Mark Fitzgerald's comment that you should research what software packages are available to do this. Trying to build something like this in Excel would be a massive undertaking and there are probably much easier solutions out there.
– user2800
Dec 4 at 17:14
As someone who works in high volume manufacturing that's spread over multiple sites, I have to second @Mark Fitzgerald's comment that you should research what software packages are available to do this. Trying to build something like this in Excel would be a massive undertaking and there are probably much easier solutions out there.
– user2800
Dec 4 at 17:14
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
That's quite a big ask. Have you searched for commercially available software to do what you need?
– Mark Fitzgerald
Dec 3 at 11:00
1
Hi, what have you tried so far?
– dmb
Dec 3 at 12:14
Step 1 : list your list (Multiple employees working shifts on multiple sites) | Step 2 : list your constrain (number of maximum available employee, number of people/shift, minimum manpower allowed)
– p._phidot_
Dec 4 at 6:57
... | Step 3 : make a simple calendar, fill it up with [ Step1 + Step2 ], then share where you get stuck. || Putting all the info in one step invites a hurricane when you are brainstorming. It need not to be pretty.. Something that just work will do just fine. || You may start by creating a sample excel with all details in Step 1, then start step 2. Then you may share which part you can't build/list.
– p._phidot_
Dec 4 at 7:06
1
As someone who works in high volume manufacturing that's spread over multiple sites, I have to second @Mark Fitzgerald's comment that you should research what software packages are available to do this. Trying to build something like this in Excel would be a massive undertaking and there are probably much easier solutions out there.
– user2800
Dec 4 at 17:14