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 
Reply
 
Thread Tools Display Modes
Old    Nick B (iridelow1998)      Join Date: Jun 2006       11-21-2010, 1: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
Old    Bobby (mastercraf)      Join Date: Jul 2009       11-21-2010, 1:30 PM Reply   
Quote:
Originally Posted by iridelow1998 View Post
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
Your distributing percentages by a single employee, and then your trying to find a way to match these percentages up to get 100% for each employee?

A single formula seems like the wrong way to go with this. It would be complicated and time consuming to write in one formula. You need a comprehensive spreadsheet to combine "vlookups" and "if" statements.

PM me and I can see what I can do with a sample of the data?
Old    Nick B (iridelow1998)      Join Date: Jun 2006       11-21-2010, 1:51 PM Reply   
Bobby - PM sent
Old    Tyler Steeb (tsteeb)      Join Date: Aug 2006       11-22-2010, 9:18 AM Reply   
Use Microsoft project, it has a lot of built in tools to do stuff exactly like this

Reply
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 5:54 PM.

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