rotating schedule of 2 items between 5 people Announcing the arrival of Valued Associate #679:...
How many morphisms from 1 to 1+1 can there be?
What does this say in Elvish?
Sentence with dass with three Verbs (One modal and two connected with zu)
How could we fake a moon landing now?
A term for a woman complaining about things/begging in a cute/childish way
How long can equipment go unused before powering up runs the risk of damage?
Semigroups with no morphisms between them
Do I really need to have a message in a novel to appeal to readers?
How many time has Arya actually used Needle?
How would a mousetrap for use in space work?
Lagrange four-squares theorem --- deterministic complexity
Would it be easier to apply for a UK visa if there is a host family to sponsor for you in going there?
How often does castling occur in grandmaster games?
Intuitive explanation of the rank-nullity theorem
How to compare two different files line by line in unix?
Project Euler #1 in C++
Why are my pictures showing a dark band on one edge?
Can a Beast Master ranger change beast companions?
Random body shuffle every night—can we still function?
What does it mean that physics no longer uses mechanical models to describe phenomena?
What is the chair depicted in Cesare Maccari's 1889 painting "Cicerone denuncia Catilina"?
One-one communication
Why are vacuum tubes still used in amateur radios?
What does Turing mean by this statement?
rotating schedule of 2 items between 5 people
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30UTC (7:30pm US/Eastern)crontab schedule rule misunderstandingSchedule a task using JavaNumbering Identical Items in A ColumnConcatenate values for matching items in ExcelHow do I create a total at the bottom for VAT items and NON VAT items?Return most recent value for particular reference number in ExcelMAKING A SCHEDULEUsing IF statement to create a schedule with datesExcel Rotating ScheduleProduction Schedule Row Formating
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I do medical coding and there are 5 of us that code for a large practice. 2 of those doctors are the only ones that do certain procedures/surgeries so we want to rotate who does their charges so we all have a chance to code those particular types of procedures. We would rotate monthly with each month, 3 of us would be sitting out without coding for either of those 2 doctors. How would I set this up in Excel? I am "fairly" proficient in Excel but I can't seem to come up with how to do this. Can someone help?
microsoft-excel worksheet-function scheduling
asked 6 hours ago
Amy SAmy S
1
New contributor
Amy S is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I do medical coding and there are 5 of us that code for a large practice. 2 of those doctors are the only ones that do certain procedures/surgeries so we want to rotate who does their charges so we all have a chance to code those particular types of procedures. We would rotate monthly with each month, 3 of us would be sitting out without coding for either of those 2 doctors. How would I set this up in Excel? I am "fairly" proficient in Excel but I can't seem to come up with how to do this. Can someone help?
microsoft-excel worksheet-function scheduling
asked 6 hours ago
Amy SAmy S
1
New contributor
Amy S is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I do medical coding and there are 5 of us that code for a large practice. 2 of those doctors are the only ones that do certain procedures/surgeries so we want to rotate who does their charges so we all have a chance to code those particular types of procedures. We would rotate monthly with each month, 3 of us would be sitting out without coding for either of those 2 doctors. How would I set this up in Excel? I am "fairly" proficient in Excel but I can't seem to come up with how to do this. Can someone help?
microsoft-excel worksheet-function scheduling
asked 6 hours ago
Amy SAmy S
1
New contributor
Amy S is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I do medical coding and there are 5 of us that code for a large practice. 2 of those doctors are the only ones that do certain procedures/surgeries so we want to rotate who does their charges so we all have a chance to code those particular types of procedures. We would rotate monthly with each month, 3 of us would be sitting out without coding for either of those 2 doctors. How would I set this up in Excel? I am "fairly" proficient in Excel but I can't seem to come up with how to do this. Can someone help?
microsoft-excel worksheet-function scheduling
microsoft-excel worksheet-function scheduling
asked 6 hours ago
Amy SAmy S
1
New contributor
Amy S is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 6 hours ago
Amy SAmy S
1
New contributor
Amy S is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 6 hours ago
Amy SAmy S
1
New contributor
Amy S is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 6 hours ago
Amy SAmy S
1
asked 6 hours ago
Amy SAmy S
1
1
New contributor
Amy S is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Amy S is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Amy S is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I did a quick mockup of a table that may get you going.
Column A is the month. Column B and Column C are the coders assigned to the particular doctor.
I've just incremented the coders by month. After 5 months repeat (you can use a simple formula to do the repeating, e.g., in cell b7 the formula would be +b2 etc.)
You can manipulate the first coder in column C depending if you want to have coders to be doing for 2 consecutive months on and 3 consecutive months off. Also, you may need to take into consideration how vacation/sick time is handled.
answered 5 hours ago
gns100gns100
23024
Thank you!! So easy but i just couldn't get it started. This is perfect!
– Amy S
5 hours ago
Glad it's what you want. Maybe to handle vacation/sick: have an additional column D titled "backup". Then start that one with coder 5, and increment the same.
– gns100
5 hours ago
add a comment |
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
});
}
});
Amy S is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1427443%2frotating-schedule-of-2-items-between-5-people%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I did a quick mockup of a table that may get you going.
Column A is the month. Column B and Column C are the coders assigned to the particular doctor.
I've just incremented the coders by month. After 5 months repeat (you can use a simple formula to do the repeating, e.g., in cell b7 the formula would be +b2 etc.)
You can manipulate the first coder in column C depending if you want to have coders to be doing for 2 consecutive months on and 3 consecutive months off. Also, you may need to take into consideration how vacation/sick time is handled.
answered 5 hours ago
gns100gns100
23024
Thank you!! So easy but i just couldn't get it started. This is perfect!
– Amy S
5 hours ago
Glad it's what you want. Maybe to handle vacation/sick: have an additional column D titled "backup". Then start that one with coder 5, and increment the same.
– gns100
5 hours ago
add a comment |
I did a quick mockup of a table that may get you going.
Column A is the month. Column B and Column C are the coders assigned to the particular doctor.
I've just incremented the coders by month. After 5 months repeat (you can use a simple formula to do the repeating, e.g., in cell b7 the formula would be +b2 etc.)
You can manipulate the first coder in column C depending if you want to have coders to be doing for 2 consecutive months on and 3 consecutive months off. Also, you may need to take into consideration how vacation/sick time is handled.
answered 5 hours ago
gns100gns100
23024
Thank you!! So easy but i just couldn't get it started. This is perfect!
– Amy S
5 hours ago
Glad it's what you want. Maybe to handle vacation/sick: have an additional column D titled "backup". Then start that one with coder 5, and increment the same.
– gns100
5 hours ago
add a comment |
I did a quick mockup of a table that may get you going.
Column A is the month. Column B and Column C are the coders assigned to the particular doctor.
I've just incremented the coders by month. After 5 months repeat (you can use a simple formula to do the repeating, e.g., in cell b7 the formula would be +b2 etc.)
You can manipulate the first coder in column C depending if you want to have coders to be doing for 2 consecutive months on and 3 consecutive months off. Also, you may need to take into consideration how vacation/sick time is handled.
answered 5 hours ago
gns100gns100
23024
I did a quick mockup of a table that may get you going.
Column A is the month. Column B and Column C are the coders assigned to the particular doctor.
I've just incremented the coders by month. After 5 months repeat (you can use a simple formula to do the repeating, e.g., in cell b7 the formula would be +b2 etc.)
You can manipulate the first coder in column C depending if you want to have coders to be doing for 2 consecutive months on and 3 consecutive months off. Also, you may need to take into consideration how vacation/sick time is handled.
answered 5 hours ago
gns100gns100
23024
answered 5 hours ago
gns100gns100
23024
answered 5 hours ago
gns100gns100
23024
answered 5 hours ago
gns100gns100
23024
23024
Thank you!! So easy but i just couldn't get it started. This is perfect!
– Amy S
5 hours ago
Glad it's what you want. Maybe to handle vacation/sick: have an additional column D titled "backup". Then start that one with coder 5, and increment the same.
– gns100
5 hours ago
add a comment |
Thank you!! So easy but i just couldn't get it started. This is perfect!
– Amy S
5 hours ago
Glad it's what you want. Maybe to handle vacation/sick: have an additional column D titled "backup". Then start that one with coder 5, and increment the same.
– gns100
5 hours ago
Thank you!! So easy but i just couldn't get it started. This is perfect!
– Amy S
5 hours ago
Thank you!! So easy but i just couldn't get it started. This is perfect!
– Amy S
5 hours ago
Glad it's what you want. Maybe to handle vacation/sick: have an additional column D titled "backup". Then start that one with coder 5, and increment the same.
– gns100
5 hours ago
Glad it's what you want. Maybe to handle vacation/sick: have an additional column D titled "backup". Then start that one with coder 5, and increment the same.
– gns100
5 hours ago
add a comment |
Amy S is a new contributor. Be nice, and check out our Code of Conduct.
Amy S is a new contributor. Be nice, and check out our Code of Conduct.
Amy S is a new contributor. Be nice, and check out our Code of Conduct.
Amy S is a new contributor. Be nice, and check out our Code of Conduct.
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.
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%2f1427443%2frotating-schedule-of-2-items-between-5-people%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
