weighted

Hello, I am working on a weighted ranking procedure. I have the procedure written for when it is always rank the top three. The problem is that this needs to be dynamic, it could be any number up to 15 or 20. n is a defined variable and I have a variable called ranknum that identifies how ranks...

Hi there, I'm looking to create a supplier score card which involves weighting & sub weighting - please see example of my score card below. As you can see Logistics Ordering & Packaging have been further broken down in to sub-criteria. I took this template from a website and their way of...

I have price in one column and quantity in other I wants to calculate weighted average of particular price range .can anyone help me

Greetings, I have two columns of data: A) Stock P/E B) Port Weight The data is susceptible to outliers so I'm using TRIMMEAN to calculate the average P/E. Now I'd like to calculate a weighted average that also excludes outlier values. Assuming I can't simply delete the outliers from the data...

Greetings! I have three data columns Column A - market sector Column B - stock weight Column C - stock return I would like to calculate a weighted median two ways: 1) for all the data in columns b & c irrespective of market sector 2) for only data in b & c that is also in the Technology...

Hi There, I have question regarding weighted percentages. Apologies in advance if this isn't in the correct thread. We currently mark our employees from 0 - 100 in what we call there quality score we then apply a weighting to get our new score: Currently the weighting for quality 25 so we...

Hi, I have a spreadsheet that I need to calculate a weighted score for each entered criteria - See table below. Each bidder will be given a score out of 10 for each of the criteria. Each criterion will be given a 'weighting' which is a multiplier for the score. This will then give each bidder...

Hi I would like get weighted average margin by category. I want to use the sales to weight the margins. Any help? thanking in advance <colgroup><col><col><col span="2"><col></colgroup><tbody> A B C D 1 Invoice Number Product Sales Margin 2 22 Pen 110 15% 3 28 Books 200 11% 4 26...

Hello Seniors, I need urgent help in following excel sheet. <tbody> Quantity Price 2 34.00 2 34.50 1 22.34 3 34.22 2 43.22 </tbody> I want to get the data in new table as <tbody> 3 "WEIGHTED AVG PRICE OF FIRST 3 QUANTITY: 3 "WEIGHTED AVG PRICE OF NEXT 3 QUANTITY. 3...

I am trying to build DA6 form (military duty roster form) that uses excel, but takes into consideration a Soldier's weighted percentage that is based on a few variables such as number of times Soldier has done duty, if the duty was on the weekend, was the duty a priority 1 vs a priority 3, and...

I need to do a allocation of time spent with customers using weighted averages I have 10 customers with a % of total of all time spent for each (I don't know the total of all time). I spend 50% of my time with Customer A004. I need to allocate the remaining 50% of my time to the remaining...

Hi I am an analyst and I need help with an advance use of the sum product function for weighted averages. I am trying to calculate three different weighted averages within 1 of 50 groups of data. Each of the 50 groups of data have a different weighting score (different importance). I have...

Hello All! I have a massive workbook with thousands of records. For each record, I need to include three weighted averages. I am using SUMPRODUCT to calculate the weighted average. Every time a change is made to the workbook, it takes about a minute to calculate, which gets old very quickly. Is...

Greetings all - I'm stumped on how to perform a weighted average using three criteria. I'd appreciate it if you folks could help me out. The formula if it were a simple weighted average is below, as well as the 3 criteria needed. Criteria: IF Sheet1!A:A="North" IF Sheet1!B:B="Apple" IF...

I am looking for a formula for "Weighted Share Based on Ranking". Any help would be appreciated. Thanks! <tbody> Doctor Ranking Weighted Share Based on Ranking Smith 1 1.05 Jones 2 1 Johnson 3 .95 </tbody>

Hello I cannot figure this out, hoping you will:) I have a table consisting of Art.no./Month/Volume/Price <colgroup><col span="3"><col></colgroup><tbody> Art.no. Month Volume Price 210015 1612 200 190,00 210015 1702 200 200,00 210015 1705 200 200,00 </tbody> In Another...

Hi, I am trying to calculate a weighted average in the Grand Total of a pivot table. I have lots of columns and one column carries volume which I need to use as the weight, so I am trying to show the Weighted average of all the different types of cost of the items grouped together. can somebody...

Hey guys, Spent about 5 hours or more trying to figure this out.. I don't see myself completing the formula without help. I need the weighted average for [(P) Storeys] where the following criteria are met: 1: [(C) Approved] = "Pending" 2: [(O) Approved] = "Pending" 3: [(O) Approved]...

Our office is voting on names for our conference rooms. My task is to declare the winners. People are asked to rate their top five choices from a list. Below is a sample of my data. Currently, the survey platform is telling me Siuslaw is the highest ranking choice--because it's using a weighted...

Looking for help on how to take an estimate of hours in onecell, and spread it across five cells (months) with varied weight in terms of %of the hours estimated. In this example,engineers get assigned to a project and have five months to work on it prior to therelease date. They start out with...