Home

Complex Schedule in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-579468%22%20slang%3D%22en-US%22%3EComplex%20Schedule%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-579468%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20multi-stage%20schedule%20in%20excel%20(and%20I%20think%20it's%20too%20complex%20for%20my%20own%20good!)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'll%20try%20and%20explain%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B-%20There%20are%206%20people%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Each%20day%2C%203%20new%20tasks%20are%20introduced%20(i.e.%20a%2C%20b%2C%20and%20c)%3C%2FP%3E%3CP%3E%26nbsp%3B-%202%20people%20complete%201%20of%20the%203%20new%20tasks%20each%20day%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Every%20person%20completes%20their%20set%20task%20at%20a%20different%20time%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Each%20set%20of%20new%20tasks%20(which%20I%20have%20labelled%20as%20a%20list)%20is%20completed%20by%20a%20different%20person%20on%20the%203rd%20and%205th%20day%20after%20being%20introduced%3C%2FP%3E%3CP%3E%26nbsp%3B-%20the%20first%20time%20a%20list%20is%20'played'%20it%20is%20done%20int%20he%20morning%3C%2FP%3E%3CP%3E%26nbsp%3B-%20the%20second%20time%20a%20list%20is%20repeated%20(i.e.%20day%203)%20it%20is%20done%20at%20noon%3C%2FP%3E%3CP%3E%26nbsp%3B-%20the%20third%20time%20a%20list%20is%20repeated%20(ie%20day%205)%20it%20is%20done%20in%20the%20evening%3C%2FP%3E%3CP%3E%26nbsp%3B-%20as%20a%20result%2C%20each%20person%20will%20complete%20a%20different%20task%20(a.%20b.%20and%20c.)%20every%20day%2C%20but%20from%20a%20different%20list.%26nbsp%3B%20One%20task%20in%20the%20morning%2C%20noon%2C%20and%20evening.%26nbsp%3B%20Each%20day%2C%20these%20times%20will%20vary%20slightly.%3C%2FP%3E%3CP%3E(if%20you%20want%20to%20confuse%20it%20more%2C%20there%20are%20actually%206%20tasks%2C%20but%20have%20grouped%20into%203%20tasks)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20did%20(manual%2C%20no%20formulas)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B-%20The%20persons%20are%20numbered%201%20to%206%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Each%20day%2C%20the%20order%20of%20the%20person%20changes%20(Day%201%3A%20%5B1%2C2%2C3%2C4%2C5%2C6%5D%2C%20Day%202%3A%26nbsp%3B%20%5B6%2C1%2C2%2C3%2C4%2C5%5D%20Day%203%3A%20%5B5%2C6%2C1%2C2%2C3%2C4%5D%20etc)%3C%2FP%3E%3CP%3E%26nbsp%3B-%20each%20task%20is%20represented%20by%20a%20form%20of%20color%20(ie%20task%20a%20is%20dark%2C%20task%20b%20is%20medium%2C%20task%20c%20is%20light)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20I've%20attached%20a%20sample%20file%20(incomplete)%20to%20describe%20the%20rest.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20convert%20this%20into%20a%20template%20to%20become%20somewhat%20automated%2C%20or%20at%20least%2C%20formulated%3F%3C%2FP%3E%3CP%3E(in%20the%20most%20perfect%20form%2C%20It%20is%20a%20schedule%20to%20be%20repeated%20monthly%2C%20only%20on%20workdays.%20so%20would%20become%20a%20calendar%20but%20I'm%20pretty%20certain%20that%20would%20take%20hours%20of%20coding%20and%20an%20app%20to%20make%20complete!)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20that%20makes%20some%20form%20of%20sense!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-579468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
rache-99
Visitor

Hello all,

 

I am trying to create a multi-stage schedule in excel (and I think it's too complex for my own good!)

 

I'll try and explain:

 

 - There are 6 people

 - Each day, 3 new tasks are introduced (i.e. a, b, and c)

 - 2 people complete 1 of the 3 new tasks each day

 - Every person completes their set task at a different time

 - Each set of new tasks (which I have labelled as a list) is completed by a different person on the 3rd and 5th day after being introduced

 - the first time a list is 'played' it is done int he morning

 - the second time a list is repeated (i.e. day 3) it is done at noon

 - the third time a list is repeated (ie day 5) it is done in the evening

 - as a result, each person will complete a different task (a. b. and c.) every day, but from a different list.  One task in the morning, noon, and evening.  Each day, these times will vary slightly.

(if you want to confuse it more, there are actually 6 tasks, but have grouped into 3 tasks)

 

 

What I did (manual, no formulas):

 - The persons are numbered 1 to 6

 - Each day, the order of the person changes (Day 1: [1,2,3,4,5,6], Day 2:  [6,1,2,3,4,5] Day 3: [5,6,1,2,3,4] etc)

 - each task is represented by a form of color (ie task a is dark, task b is medium, task c is light)

 

and I've attached a sample file (incomplete) to describe the rest.

 

Is there any way to convert this into a template to become somewhat automated, or at least, formulated?

(in the most perfect form, It is a schedule to be repeated monthly, only on workdays. so would become a calendar but I'm pretty certain that would take hours of coding and an app to make complete!)

 

hope that makes some form of sense!