khakistatistic1
New Member
- Joined
- Dec 14, 2015
- Messages
- 1
I am trying to create an automated duty scheduler that places people into time slots based upon their availability. Either through formulas or code I'll need something that allows me to click a "Generate" button and auto populate the below table with names. Once everyone is placed I need for everyone's total blocks of time to be as close to equal as possible for the week. I'll have their schedule availability on a separate sheet and will use it as a reference.
I'm not a stranger to Excel VBA - I'm a slightly less than moderately adept coder. I just need someone to point me in the right direction for a starting point.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Sun[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[/TR]
[TR]
[TD]0700[/TD]
[TD]Jason[/TD]
[TD]Jason[/TD]
[TD]Todd[/TD]
[TD]Alan[/TD]
[TD]Todd[/TD]
[TD]Brian[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0800[/TD]
[TD]Jason[/TD]
[TD]Jason[/TD]
[TD]Todd[/TD]
[TD]Alan[/TD]
[TD]Todd[/TD]
[TD]Brian[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0900[/TD]
[TD]Jason[/TD]
[TD]Jason[/TD]
[TD]Frank[/TD]
[TD]Frank[/TD]
[TD]Brian[/TD]
[TD]Jason[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[TD]Frank[/TD]
[TD]Frank[/TD]
[TD]Brian[/TD]
[TD]Jason[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1100[/TD]
[TD][/TD]
[TD][/TD]
[TD]Frank[/TD]
[TD]Frank[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1300[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1400[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1500[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1600[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1700[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1800[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1900[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2300[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2400[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I'm not a stranger to Excel VBA - I'm a slightly less than moderately adept coder. I just need someone to point me in the right direction for a starting point.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Sun[/TD]
[TD]Mon[/TD]
[TD]Tue[/TD]
[TD]Wed[/TD]
[TD]Thu[/TD]
[TD]Fri[/TD]
[TD]Sat[/TD]
[/TR]
[TR]
[TD]0700[/TD]
[TD]Jason[/TD]
[TD]Jason[/TD]
[TD]Todd[/TD]
[TD]Alan[/TD]
[TD]Todd[/TD]
[TD]Brian[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0800[/TD]
[TD]Jason[/TD]
[TD]Jason[/TD]
[TD]Todd[/TD]
[TD]Alan[/TD]
[TD]Todd[/TD]
[TD]Brian[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]0900[/TD]
[TD]Jason[/TD]
[TD]Jason[/TD]
[TD]Frank[/TD]
[TD]Frank[/TD]
[TD]Brian[/TD]
[TD]Jason[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[TD]Frank[/TD]
[TD]Frank[/TD]
[TD]Brian[/TD]
[TD]Jason[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1100[/TD]
[TD][/TD]
[TD][/TD]
[TD]Frank[/TD]
[TD]Frank[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1300[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1400[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1500[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1600[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1700[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1800[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1900[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2300[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2400[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]