software

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: www.excelforum.com/member.php...oamp;userid=32173
View this thread: www.excelforum.com/showthread...hreadid=519203You 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
quot;needinhelpquot; gt; wrote
in message ...
gt;
gt; I need a formula to provide the perfect score in a catagory
gt; Using a relative index of 5 and weights
gt;
gt; Category-Performance
gt; Relativity Index-5
gt; Weights-as noted below
gt;
gt; Scope Of Work-8 (weight)
gt; Service Level-6 (weight)
gt; Estimate Turn Time-8 (weight)
gt; Timeliness of Repairs-8 (weight)
gt; Ingate To Available-6 (weight)
gt; Inventory Reporting-4 (weight)
gt; Staus Response-8 (weight)
gt;
gt; Sub-total (perfect score) 137 (is this correct)
gt; What should the formula be for this?
gt;
gt; needinhelp
gt;
gt;
gt; --
gt; needinhelp
gt; ------------------------------------------------------------------------
gt; needinhelp's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32173
gt; View this thread: www.excelforum.com/showthread...hreadid=519203
gt;