Thread: Sorting
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Sorting

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

On Jun 30, 5:38*pm, MPAVLAS wrote:
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.



"Pete_UK" wrote:
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


On Jun 30, 4:47 pm, MPAVLAS wrote:
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.- Hide quoted text -


- Show quoted text -