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=519203