 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2008Sorting
I have two columns. one contains two variables (John or Eddie) the other contains a precentage per job relative to the painter (john or Eddie). What is the best way to get an average percentage for each of the painters. You really need to know the size of each job, as you can't just add the percentages together and take an average. Someone with a large percentage of a small job would be skewed compared to someone else having a smaller percentage of a larger job. Hope this helps. Pete > I have two columns. > [quoted text clipped - 4 lines] > > What is the best way to get an average percentage for each of the painters. The percentage is Gross Profit on a job. Yes, job size does matter but there would be too many variables to sort through to make the report completely accurate. I am just lloking to find the avergae gross precentage of each technician. If I sort the techs myself I can easily find there average, but I do not want seperate pages for each tech. I owuld like to just be able to use excel to sort through the list and do it for me. I know it is possible, I have seen excel do way more. > You really need to know the size of each job, as you can't just add > the percentages together and take an average. Someone with a large [quoted text clipped - 13 lines] > > > > What is the best way to get an average percentage for each of the painters. Let's say the two technicians do two jobs - for the first (which is worth, say, $500) the split is 90%:10%, but on the second job (worth $2000) the split is 40%:60%. The strict average of the percentage split is 65%:35%, but this is meaningless. You need to take the value of each job split between the two, i.e. 450:50 and 800:1200 and compare these - 1250:1250, or 50%:50%. Hope this helps. Pete > The percentage is Gross Profit on a job. Yes, job size does matter but there > would be too many variables to sort through to make the report completely [quoted text clipped - 25 lines] > > - Show quoted text - No.....Here is my example.... John 50% Eddie 48% Eddie 55% Eddie 66% John 48% John 40% Now I know how to find the averages if I wanted to do it manually, but these figures are just part of a data sheet. I am looking for the average precent per technician based of of precents, not totals. > Let's say the two technicians do two jobs - for the first (which is > worth, say, $500) the split is 90%:10%, but on the second job (worth [quoted text clipped - 36 lines] > > > > - Show quoted text - |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.