Need Formula Help
 

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

Need Formula Help
 

You have to understand that you are the only one who has any idea whatsoever
what you are talking about. Please provide details about your data layout
(this is in that column, that is in this other column, etc). Tell us in
what column you want this formula. Then tell us exactly how you would go
about calculating the answer if you were doing it manually. HTH Otto
"needinhelp" wrote
in message ...

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