I have a table of portfolio's that have varying number of clients and work hours. Each portfolio has 1-10 clients depending on the amount of work hours that are assigned, ie a portfolio with a large client with lots of work hours will only have 1 client, and a portfolio with clients with a small amount of hours may have 10 clients.
What I'm trying to do is to compare total work hours for a portfolio with the amount of repair hours and come up with a percentage (standard percentage), but then give 'credit' to the portfolio with 10 clients, vs the ones with only 1 client. I guess basically I'm saying that a 'small' percentage of repair is acceptable per client, but its gets skewed when we combine multiple clients into a portfolio, if that makes sense. so how do I 'level that out to be a more fair comparison in my formula?
Current % formula in B5 is '=B4/B3' (260/48171)
Hope my question makes sense....
Thanks,
Don
<tbody>
</tbody>
What I'm trying to do is to compare total work hours for a portfolio with the amount of repair hours and come up with a percentage (standard percentage), but then give 'credit' to the portfolio with 10 clients, vs the ones with only 1 client. I guess basically I'm saying that a 'small' percentage of repair is acceptable per client, but its gets skewed when we combine multiple clients into a portfolio, if that makes sense. so how do I 'level that out to be a more fair comparison in my formula?
Current % formula in B5 is '=B4/B3' (260/48171)
Hope my question makes sense....
Thanks,
Don
A1 | Portfolio1 | Portfolio2 | Portfolio3 | Portfolio4 | Portfolio5 | Portfolio6 |
# Clients | 1 | 4 | 3 | 1 | 10 | 1 |
Hours | 48171 | 26055 | 18961 | 11801 | 5429 | 43475 |
Break Fix | 260 | 459 | 1658 | 296 | 819 | 294 |
Fix/Hours % | 1% | 2% | 9% | 3% | 15% | 1% |
<tbody>
</tbody>
Last edited: