Need Formula
 

I need a formula to provide the perfect score in a catagory
Using a relative index of 5 and weights

Category-Performance
Relativity Index-5
Weights-as noted below

Scope Of Work-8 (weight)
Service Level-6 (weight)
Estimate Turn Time-8 (weight)
Timeliness of Repairs-8 (weight)
Ingate To Available-6 (weight)
Inventory Reporting-4 (weight)
Staus Response-8 (weight)

Sub-total (perfect score) 137 (is this correct)
What should the formula be for this?

needinhelp


--
needinhelp
------------------------------------------------------------------------
needinhelp's Profile: http://www.excelforum.com/member.php...o&userid=32173
View this thread: http://www.excelforum.com/showthread...hreadid=519208