68 coaches online • Server time: 23:39
Index Search Usergroups Profile
Log in
Recent Forum Topics goto Post Secret League Cupgoto Post Blackbox Trophy Seas...goto Post Born to Win Forever?...
Post new topic   Reply to topic
View previous topic Log in to check your private messages View next topic

Joined: Jun 25, 2010

Post 1 Posted: Jan 24, 2017 - 12:28
Reply with quote Back to top

Hi all, I have a project to do at work but its been so long since I have looked at excel that after 30 minutes I made some tables!!...Embarassed

Any help would be great.. I need something that parses out weekly assignments to shifts that my people work on.

-3 shifts (days/evenings/nights) doing 2 week intervals
-up to 10 people in each shift
-10 areas that need coverage
-every person on each shift has one primary, one secondary and one tertiary center assigned them that I want evenly distributed throughout the year
-all areas must be covered by at least 2 bodies each week on every shift(See Note*)

*Note - two of the areas are only covered during day shift and only by one person that week.

My math and excel skills have failed lately... Any help would be amazing.

Joined: Feb 17, 2008

Post   Posted: Jan 08, 2018 - 01:56 Reply with quote Back to top

http://www.abc-roster.com/ looks nice, but I didn't tried it.

"la virtú sta nel cielo e nella terra, ma anche nelle nuvole e nelle stelle"


Joined: Sep 17, 2018

Post 7 Posted: Sep 17, 2018 - 14:14 Reply with quote Back to top

Hello! Wink
Now on the Internet, there are many step-by-step instructions for using the program Exel.
Working with tables does not suffer a rush. Create a table in different ways and for specific purposes, each method has its own advantages. Columns are indicated in Latin letters. The lines are numbers. To select the entire column, click on its name (Latin letter) with the left mouse button. To select several columns or rows, click the left mouse button on the name, hold, and drag.
To see the results, you need to scroll through more than one thousand lines.
Delete rows is not an option (data will be needed later). But you can hide it. Use numeric filters (pictured above) for this purpose. Clear the checkboxes against the values that should be hidden.
Maybe this link will be useful https://support.office.com/en-us/excel

Apply for help to
essay writing service anytime you need.
Display posts from previous:     
 Jump to:   
All times are GMT + 1 Hour
Post new topic   Reply to topic
View previous topic Log in to check your private messages View next topic