Automated recurring planner in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3339571%22%20slang%3D%22en-US%22%3EAutomated%20recurring%20planner%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3339571%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20fluid%20set%20of%20data%20(in%20terms%20of%20it%20can%20change)%20and%20I%20need%20to%20auto%20populate%20in%20excel%20to%20get%20a%20data%20set%20of%20dates%20per%20team.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20explain.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%2010%20teams.%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20team%20has%20a%20different%20number%20of%20staff.%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20team%20has%20to%20contribute%20to%20a%20weekend%20planner%20depending%20on%20the%20number%20of%20staff%20they%20have.%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20Team%201%20has%20x%2020%20staff%20for%20example.%26nbsp%3B%3C%2FP%3E%3CP%3ETeam%202%20has%20x%2010%20staff.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20Team%201%20has%20to%20contribute%20double%20the%20number%20of%20times%20as%20team%202.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20way%20to%20enter%20the%20team%20name%2C%20enter%20the%20number%20of%20staff%2C%20and%20the%20dates%20to%20autopopulate%20which%20weekends%20they%20should%20work.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20only%20need%20x%202%20teams%20per%20Friday%20and%20x%202%20teams%20per%20Saturday.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%3F%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3339571%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3339948%22%20slang%3D%22en-US%22%3ERe%3A%20Automated%20recurring%20planner%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3339948%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1383129%22%20target%3D%22_blank%22%3E%40Cfrance123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20of%20this%20writing%20your%20question%20has%20been%20viewed%2054%20times%20with%200%20replies.%20I%20suspect%20the%20cause%20is%20a%20lack%20of%20clarity%20in%20what%20you're%20desiring%20to%20do.%20The%20description%20you've%20provided%20no%20doubt%20is%20clear%20to%20you%2C%20but%20you're%20asking%20people%20here%20to%20do%20a%20LOT%20of%20guessing%20at%3A%3C%2FP%3E%3CUL%3E%3CLI%3Enot%20only%20what%20the%20%3CU%3E%3CEM%3E%3CSTRONG%3Eoutput%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FU%3E%20is%20going%20to%20be%2C%20what%20it's%20going%20to%20look%20like%2C%20but%3C%2FLI%3E%3CLI%3Ewhat%20the%20%3CU%3E%3CEM%3E%3CSTRONG%3Einput%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FU%3E%20is%2C%20and%3C%2FLI%3E%3CLI%3Ewhat's%20to%20be%20done%20with%20that%20input%20(the%20%3CU%3E%3CEM%3E%3CSTRONG%3Eprocesses%20to%20apply%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FU%3E)%20in%20order%20to%20produce%20that%20output.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAssume%20you're%20talking%20with%20a%20very%20bright%20pre-teen%20whom%20you'd%20like%20to%20do%20this%20task%2C%20but%20do%20it%20on%20paper.%3C%2FP%3E%3COL%3E%3CLI%3EHow%20would%20you%20lay%20out%20the%20task%3F%3C%2FLI%3E%3CLI%3EWhat%20would%20the%20parts%20(information)%20be%20that%20he%20or%20she%20would%20start%20with%3F%3C%2FLI%3E%3CLI%3EHow%20would%20you%20direct%20him%20or%20her%20to%20rearrange%20it%3F%3C%2FLI%3E%3CLI%3EWhat%20rules%2Fprocedures%20would%20govern%3F%3C%2FLI%3E%3CLI%3EHow%20would%20they%20know%20they'd%20completed%20it%20to%20your%20satisfaction%3F%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3343895%22%20slang%3D%22en-US%22%3ERe%3A%20Automated%20recurring%20planner%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3343895%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20certainly%20possible.%20If%20you're%20able%20to%20provide%20a%20sample%20workbook%2C%20something%20could%20be%20drawn%20up.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20must%20say%20this%20does%20sound%20like%20something%20that%20would%20be%20right%20up%20MS%20Project's%20alley%20with%20the%20need%20for%20resource%20allocation.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi. 

 

I have a fluid set of data (in terms of it can change) and I need to auto populate in excel to get a data set of dates per team. 

 

To explain. 

 

I have 10 teams. 

Each team has a different number of staff. 

Each team has to contribute to a weekend planner depending on the number of staff they have. 

So Team 1 has x 20 staff for example. 

Team 2 has x 10 staff. 

 

So Team 1 has to contribute double the number of times as team 2. 

 

I need a way to enter the team name, enter the number of staff, and the dates to autopopulate which weekends they should work. 

 

I also only need x 2 teams per Friday and x 2 teams per Saturday. 

 

Can anyone help?  

2 Replies

@Cfrance123 

 

As of this writing your question has been viewed 54 times with 0 replies. I suspect the cause is a lack of clarity in what you're desiring to do. The description you've provided no doubt is clear to you, but you're asking people here to do a LOT of guessing at:

  • not only what the output is going to be, what it's going to look like, but
  • what the input is, and
  • what's to be done with that input (the processes to apply) in order to produce that output.

 

Assume you're talking with a very bright pre-teen whom you'd like to do this task, but do it on paper.

  1. How would you lay out the task?
  2. What would the parts (information) be that he or she would start with?
  3. How would you direct him or her to rearrange it?
  4. What rules/procedures would govern?
  5. How would they know they'd completed it to your satisfaction?

This is certainly possible. If you're able to provide a sample workbook, something could be drawn up.

I must say this does sound like something that would be right up MS Project's alley with the need for resource allocation.