Using Excel Data a Single time
I have multiple task I want to assign to multiple people that are only available on specific days. These task have variable work to be completed, and specific date time frame they need to be completed and only completed one time.
Example of task:
A 4 hours
B 3 hours
C 3 hours
D 2 hours
E 2 hours
X 4 hours
Y 4 hours
Z 4 hours
Task A can only be completed tomorrow through next Friday.
Task B can only be completed Thursday-Friday.
Task C can only be completed Wednesday-Thursday and so on.
Workers that can complete those task are only available a static amount of hours on each day they work.
John 6 hours every day.
Joe 4 hours.
What Excel formula combination could I use that can sort these by day and say, "Task A, B, and C can be completed on this day." and removes those task from the following days list to be completed (makes them unique).
Edit to add on request: I would say the main thing I need is help on how to make a function use a field 1 time before it marks it to not be used in others. If I can break down a formula to say, "=IF((Start date < ProposedDay < end date) & (TotalWorkHours > (Vlookup TaskHours)), Assign Task to Date & Totalworkhours=TotalworkHours-taskhours, Day Full"
I feel like this might even be easier to do in a C++ While statement but it is still just on the edge that I can't process a formulia that works.
microsoft-excel scheduled-tasks
asked Dec 5 at 19:28
Robbie Matthew
12
add a comment |
I have multiple task I want to assign to multiple people that are only available on specific days. These task have variable work to be completed, and specific date time frame they need to be completed and only completed one time.
Example of task:
A 4 hours
B 3 hours
C 3 hours
D 2 hours
E 2 hours
X 4 hours
Y 4 hours
Z 4 hours
Task A can only be completed tomorrow through next Friday.
Task B can only be completed Thursday-Friday.
Task C can only be completed Wednesday-Thursday and so on.
Workers that can complete those task are only available a static amount of hours on each day they work.
John 6 hours every day.
Joe 4 hours.
What Excel formula combination could I use that can sort these by day and say, "Task A, B, and C can be completed on this day." and removes those task from the following days list to be completed (makes them unique).
Edit to add on request: I would say the main thing I need is help on how to make a function use a field 1 time before it marks it to not be used in others. If I can break down a formula to say, "=IF((Start date < ProposedDay < end date) & (TotalWorkHours > (Vlookup TaskHours)), Assign Task to Date & Totalworkhours=TotalworkHours-taskhours, Day Full"
I feel like this might even be easier to do in a C++ While statement but it is still just on the edge that I can't process a formulia that works.
microsoft-excel scheduled-tasks
asked Dec 5 at 19:28
Robbie Matthew
12
1
Hi Robbie, that's quite a question. Would you mind sharing your own research into this problem? Otherwise it's sounding as if you're asking other people to do all the work for you. I am sure that's not your intention. Could you edit your question and indicate what you've tried yourself, or what things you've looked up related to your task?
– Saaru Lindestøkke
Dec 5 at 20:18
What your data actually looks like may be helpful too
– cybernetic.nomad
Dec 5 at 20:54
1
It's little complicated issue since you have not shared what you have tried so far. Then let me suggest one simple procedure will help you to fix the issue. The 1st job you need worksheets dedicated to users, like Sheet1 to user A and so on. 2nd you need master Sheet to carry User's Name & Pass code. Then create User Form and use it with Workbook Load event. Let the users to write Name & Password to goto their respective sheet to work. Keep one Cell to enter Current Date & time before start work to unprotect the Sheet. And use
– Rajesh S
Dec 6 at 5:15
Cont,, Worsheet Change event to check the Entered Time + Work Time if it reaches then put Message and protect the Sheet.
– Rajesh S
Dec 6 at 5:15
add a comment |
I have multiple task I want to assign to multiple people that are only available on specific days. These task have variable work to be completed, and specific date time frame they need to be completed and only completed one time.
Example of task:
A 4 hours
B 3 hours
C 3 hours
D 2 hours
E 2 hours
X 4 hours
Y 4 hours
Z 4 hours
Task A can only be completed tomorrow through next Friday.
Task B can only be completed Thursday-Friday.
Task C can only be completed Wednesday-Thursday and so on.
Workers that can complete those task are only available a static amount of hours on each day they work.
John 6 hours every day.
Joe 4 hours.
What Excel formula combination could I use that can sort these by day and say, "Task A, B, and C can be completed on this day." and removes those task from the following days list to be completed (makes them unique).
Edit to add on request: I would say the main thing I need is help on how to make a function use a field 1 time before it marks it to not be used in others. If I can break down a formula to say, "=IF((Start date < ProposedDay < end date) & (TotalWorkHours > (Vlookup TaskHours)), Assign Task to Date & Totalworkhours=TotalworkHours-taskhours, Day Full"
I feel like this might even be easier to do in a C++ While statement but it is still just on the edge that I can't process a formulia that works.
microsoft-excel scheduled-tasks
asked Dec 5 at 19:28
Robbie Matthew
12
I have multiple task I want to assign to multiple people that are only available on specific days. These task have variable work to be completed, and specific date time frame they need to be completed and only completed one time.
Example of task:
A 4 hours
B 3 hours
C 3 hours
D 2 hours
E 2 hours
X 4 hours
Y 4 hours
Z 4 hours
Task A can only be completed tomorrow through next Friday.
Task B can only be completed Thursday-Friday.
Task C can only be completed Wednesday-Thursday and so on.
Workers that can complete those task are only available a static amount of hours on each day they work.
John 6 hours every day.
Joe 4 hours.
What Excel formula combination could I use that can sort these by day and say, "Task A, B, and C can be completed on this day." and removes those task from the following days list to be completed (makes them unique).
Edit to add on request: I would say the main thing I need is help on how to make a function use a field 1 time before it marks it to not be used in others. If I can break down a formula to say, "=IF((Start date < ProposedDay < end date) & (TotalWorkHours > (Vlookup TaskHours)), Assign Task to Date & Totalworkhours=TotalworkHours-taskhours, Day Full"
I feel like this might even be easier to do in a C++ While statement but it is still just on the edge that I can't process a formulia that works.
microsoft-excel scheduled-tasks
microsoft-excel scheduled-tasks
asked Dec 5 at 19:28
Robbie Matthew
12
asked Dec 5 at 19:28
Robbie Matthew
12
edited Dec 5 at 20:38
asked Dec 5 at 19:28
Robbie Matthew
12
asked Dec 5 at 19:28
Robbie Matthew
12
asked Dec 5 at 19:28
Robbie Matthew
12
12
1
Hi Robbie, that's quite a question. Would you mind sharing your own research into this problem? Otherwise it's sounding as if you're asking other people to do all the work for you. I am sure that's not your intention. Could you edit your question and indicate what you've tried yourself, or what things you've looked up related to your task?
– Saaru Lindestøkke
Dec 5 at 20:18
What your data actually looks like may be helpful too
– cybernetic.nomad
Dec 5 at 20:54
1
It's little complicated issue since you have not shared what you have tried so far. Then let me suggest one simple procedure will help you to fix the issue. The 1st job you need worksheets dedicated to users, like Sheet1 to user A and so on. 2nd you need master Sheet to carry User's Name & Pass code. Then create User Form and use it with Workbook Load event. Let the users to write Name & Password to goto their respective sheet to work. Keep one Cell to enter Current Date & time before start work to unprotect the Sheet. And use
– Rajesh S
Dec 6 at 5:15
Cont,, Worsheet Change event to check the Entered Time + Work Time if it reaches then put Message and protect the Sheet.
– Rajesh S
Dec 6 at 5:15
add a comment |
1
Hi Robbie, that's quite a question. Would you mind sharing your own research into this problem? Otherwise it's sounding as if you're asking other people to do all the work for you. I am sure that's not your intention. Could you edit your question and indicate what you've tried yourself, or what things you've looked up related to your task?
– Saaru Lindestøkke
Dec 5 at 20:18
What your data actually looks like may be helpful too
– cybernetic.nomad
Dec 5 at 20:54
1
It's little complicated issue since you have not shared what you have tried so far. Then let me suggest one simple procedure will help you to fix the issue. The 1st job you need worksheets dedicated to users, like Sheet1 to user A and so on. 2nd you need master Sheet to carry User's Name & Pass code. Then create User Form and use it with Workbook Load event. Let the users to write Name & Password to goto their respective sheet to work. Keep one Cell to enter Current Date & time before start work to unprotect the Sheet. And use
– Rajesh S
Dec 6 at 5:15
Cont,, Worsheet Change event to check the Entered Time + Work Time if it reaches then put Message and protect the Sheet.
– Rajesh S
Dec 6 at 5:15
1
1
Hi Robbie, that's quite a question. Would you mind sharing your own research into this problem? Otherwise it's sounding as if you're asking other people to do all the work for you. I am sure that's not your intention. Could you edit your question and indicate what you've tried yourself, or what things you've looked up related to your task?
– Saaru Lindestøkke
Dec 5 at 20:18
Hi Robbie, that's quite a question. Would you mind sharing your own research into this problem? Otherwise it's sounding as if you're asking other people to do all the work for you. I am sure that's not your intention. Could you edit your question and indicate what you've tried yourself, or what things you've looked up related to your task?
– Saaru Lindestøkke
Dec 5 at 20:18
What your data actually looks like may be helpful too
– cybernetic.nomad
Dec 5 at 20:54
What your data actually looks like may be helpful too
– cybernetic.nomad
Dec 5 at 20:54
1
1
It's little complicated issue since you have not shared what you have tried so far. Then let me suggest one simple procedure will help you to fix the issue. The 1st job you need worksheets dedicated to users, like Sheet1 to user A and so on. 2nd you need master Sheet to carry User's Name & Pass code. Then create User Form and use it with Workbook Load event. Let the users to write Name & Password to goto their respective sheet to work. Keep one Cell to enter Current Date & time before start work to unprotect the Sheet. And use
– Rajesh S
Dec 6 at 5:15
It's little complicated issue since you have not shared what you have tried so far. Then let me suggest one simple procedure will help you to fix the issue. The 1st job you need worksheets dedicated to users, like Sheet1 to user A and so on. 2nd you need master Sheet to carry User's Name & Pass code. Then create User Form and use it with Workbook Load event. Let the users to write Name & Password to goto their respective sheet to work. Keep one Cell to enter Current Date & time before start work to unprotect the Sheet. And use
– Rajesh S
Dec 6 at 5:15
Cont,, Worsheet Change event to check the Entered Time + Work Time if it reaches then put Message and protect the Sheet.
– Rajesh S
Dec 6 at 5:15
Cont,, Worsheet Change event to check the Entered Time + Work Time if it reaches then put Message and protect the Sheet.
– Rajesh S
Dec 6 at 5:15
add a comment |
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1381115%2fusing-excel-data-a-single-time%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1381115%2fusing-excel-data-a-single-time%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Hi Robbie, that's quite a question. Would you mind sharing your own research into this problem? Otherwise it's sounding as if you're asking other people to do all the work for you. I am sure that's not your intention. Could you edit your question and indicate what you've tried yourself, or what things you've looked up related to your task?
– Saaru Lindestøkke
Dec 5 at 20:18
What your data actually looks like may be helpful too
– cybernetic.nomad
Dec 5 at 20:54
1
It's little complicated issue since you have not shared what you have tried so far. Then let me suggest one simple procedure will help you to fix the issue. The 1st job you need worksheets dedicated to users, like Sheet1 to user A and so on. 2nd you need master Sheet to carry User's Name & Pass code. Then create User Form and use it with Workbook Load event. Let the users to write Name & Password to goto their respective sheet to work. Keep one Cell to enter Current Date & time before start work to unprotect the Sheet. And use
– Rajesh S
Dec 6 at 5:15
Cont,, Worsheet Change event to check the Entered Time + Work Time if it reaches then put Message and protect the Sheet.
– Rajesh S
Dec 6 at 5:15