[AccessD] Who likes math!

Drew Wutka DWUTKA at marlow.com
Thu Oct 16 13:04:31 CDT 2003


Write a query for the top ten based solely on category 1.  What you need is
the total score for #10.  Then write a query for everyone's score.  If they
aren't in the first querries top 10, subtract the difference between #10 and
#11.

Drew

-----Original Message-----
From: Francisco H Tapia [mailto:my.lists at verizon.net]
Sent: Thursday, October 16, 2003 12:18 PM
To: AccessD
Subject: [AccessD] Who likes math!


I have a report that has 11 categories.  Each are scored from 1 - 100. 
Through refining the report some categories weigh less now for example 
category # 11 weights only 50% of the value thus a perfect score there 
is only worth 50points vs a perfect score on Category ID 1.

I was taking these individual category points and tallying them up and 
sort them in descending order thus those w/ the most points wins (those 
at the top).  Now My boss wants to now take those guys who do not meet 
the goal at category 1 to not be allowed to be in the TOP 10.  I tried 
watering down their points first by only giving them 75% of their total 
points down to 10% but the boss thought that probably wasn't a good idea.

My point is how do you fairly guage this, and how would you do it to 
rank 11 categories over 30 sub-companies

Category	% of 100points
1		100
2		
3		90
4		80
5		80
6		90
7		100
8		90
9		90
10		60
11		50

when I sum up all the points I get something like in the 900 or the 
like, when one sub-company and another are tied, they both take up the 
same ranking number such as 1, 2, 2, 4.  the next spot automatically is 
shifted to the next ranking value not 3rd place, but 4th.  How could I 
take a company that is ranked in 3rd place overall score but knock them 
down to be 11th place only because they didn't meet the primary 
criteria?  What this assures is that anybody that ever fails to meet the 
primary category can't qualify in the top 10.


thanks.
-- 
-Francisco


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list