Articles
   
       
       
Pics/Video
   
       
       
Shop
Search
 
 
 
 
 
Home   Articles   Pics/Video   Gear   Wake 101   Events   Community   Forums   Classifieds   Contests   Shop   Search
WAKE WORLD HOME
Email Password
Go Back   WakeWorld > Non-Wakeboarding Discussion

Share 
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old     (iridelow1998)      Join Date: Jun 2006       11-21-2010, 12:04 PM Reply   
Hopefully you can follow me on my question here. I'm looking to take the numbers from a group of cells and distribute evenly between a number that varies daily. I'm trying to distribute work evenly among a group of employees. I've determined that job A might entail 37% of an employees 8 hour day while job B may entail 43% of a day, job C 88%, job D 71%, job E 61%, job F 59%, etc.

How would I create and excel formula that would take the .37, .43, .88, .71, .61, and .59 and divide by the number of employees for a particular day (let's say 3 for example) and then tell me that employee 1 is assigned jobs A&E, employee 2 is assigned jobs B&F etc.

I know it seems really simple to look at this and just get as close to 100% as possible but when I've got 70-80 of the percentages to look at it is time consuming to try to do it on paper. Any help would be appreciated. I've got people doing this on paper and it's killing my business plan.

If you need me to explain anything differently please let me know. Nick

 
Share 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On



All times are GMT -7. The time now is 1:11 AM.

Home   Articles   Pics/Video   Gear   Wake 101   Events   Community   Forums   Classifieds   Contests   Shop   Search
Wake World Home

 

© 2012 eWake, Inc.    
Advertise    |    Contact    |    Terms of Use    |    Privacy Policy    |    Report Abuse    |    Conduct    |    About Us