While I in no way claim to be a math expert, but in the past we have used created numbers. By that I mean to take the $sales and the percent of profit, drop the decimal from the percentage and multiply the two. While the number has no real meaning, it would sort them such that your example would rank them as 1-60000, 2-6000, 3-76000, 4-57000
the results would give a ranking overall.. ----- Original Message ----- From: "David M. Blocker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 12:24 AM Subject: Re: Statistics experts needed > Karen > > I've been having fun following this. I think the key is: > > 1. Listen to your clients - ask THEM what matters to them > 2. Read Enrique again and know that no one has the right answer! So > whatever you give them, they'll want a change, and so what - that's more > work for you! > 3. Get some sleep!! > > David Blocker > > ----- Original Message ----- > From: "tellef" <[EMAIL PROTECTED]> > To: "All" <[EMAIL PROTECTED]> > Sent: Thursday, November 07, 2002 6:58 PM > Subject: Re: Statistics experts needed > > > > > > I read all your interesting emails. Everyone agrees that > > it isn't easy to determine what's most important. Factors > > such as employee salary, the priorities of the company > > (is it sale$ or the number of sales they make) are all > > different. > > > > So let's put that all aside and say that my client has > > picked the one factor that is the most important to them > > in terms of weighing the profit%. Let's say that they > > pick the profit$ as most immportant. I could simly sort > > the RBase report by profit% DESC, and then profit$ DESC: > > > > Salesman1 $1,500 40% > > Salesman2 150 40 > > Salesman3 2,000 38 > > Salesman4 1,500 38 > > > > But again this doesn't look fair because Salesman3 was > > clearly more 'productive' than Salesman2! > > > > So here's my final question on this. Is there a formula > > where I can 'weigh' the profit% by the profit$ so that > > it gives me a number that is comparable between all 4 of > > these guys! > > > > > > > > Karen > > > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
