Search results

with this problem I spent many hours tweaking the percentages until it worked. That was my job after you pointed me in the corrrect direction. I think, shades you will never respond to thanks? for your own reasons, I respect that. You knew if you gave me a pointer I would find the solution...

the lookup scoring system it is now working great. Good News, it is working perfectly now. I just had to add more rows to the lookup with the same score, and just tweaked the percentages to focus on the correct score. I found Goal Seek useful to acheive this. But anyway I have tested every...

Hi, tried that, also been googling this all day, but no joy yet. Possibly the scoring criteria is a bit to complex, some score combinations work and most others dont. When tested with different possibilities it generally doesnt work. I have spent to many hours on this, but have learned a lot...

Thanks again for that, very helpful You asked what i meant by "return accurate values". My score criteria includes "Between" values. For example a Score of "9" is awarded if Call Handling time is between 3 and 10 percent better thac average. Your previous post helped me see what the problem...

Scoring system on Lookup Hello there, I have worked on this solution, I now have an understanding of the way it works, and I will certainly use this. I am struggling though to get the scoring system return accurate values. The criteria has "between percentages" factors, which makes this...

Hello Shades, thanks a lot for that, given me a lot to think about, you obviously know your formulas!! I will need to study the system you are using. At the moment though if the individual calls per hour is higher than the "average", I am getting a lower score rather than higher, probably the...

Thanks for your reply Hello I attached an example worksheet, struggled with IFs all day, but I reckon lookups are the way to go as you suggest. I need some guidance on how to proceed as their is so many comparisons to work out. I have attached a sample worksheet if that helps. Any...

I work for a contact centre in UK, keeps me off the streets. They offered me the opportunity ( I am an ex applications trainer) to do this call centre scoring system in excel and write an access database to produce scoring reports etc. I am not bad on applications including access, I like...