weighting

Hi All, This is my first post here and hope will get my answer here. I have a table with 3 columns, store, Weighting and matrix. I need the unique store list from the table but weighting and matrix columns should be added or concatenated before deleting the duplicate rows. Please find the below...

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 all, I'm trying to get cell P11 to gauge a percentage from a figure typed into cell O11. O11 = a percentage, to 2 decimal points. There are five ranges that O11 will fall into: <35%, 35%-45%, 45%-55%, 55%-65%, 65%+ There are weightings attached to these ranges: 1.5%, 3%, 4.5%, 6%, 7.5%...

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, I'm hoping someone can help me with this. I have a total score being calculated based on 5 options under 9 categories (below is the formula). I need to make add a 50% weighting to the first category and then evenly distribute to the remaining 8. Does anyone have the slightest idea how...

I'm tying to rebuild our sales rep quarterly/year-end performance report to account for quarterly metrics weighting changes. Generally the performance metrics (attainment to quota and product volumes) have the same weightings each quarter so calculating the year-end ranks are easy, (YTD...

Hi all I need to push feed some weighting into the formula below: =SUMPRODUCT(--('[Weather Archive.xlsx]Reports'!$A:$A>=C4)*('[Weather Archive.xlsx]Reports'!$A:$A<=D4),'[Weather Archive.xlsx]Reports'!$C:$C) My weightings are in the sheet 'regionalweighting', Column A has Region (North...

Hi, I have some interesting data based on soccer that I am trying to use to measure performance based on the correlation coefficients. I have data for each player in the English Premier League that shows how many goals they have scored and with this range of other data that contributes to...

Hello, I am struggling to figure out how to go about this, perhaps someone can point me in the right direction? I wish to create a variable dutching calculator whereby, instead of all the runners in the field generating the same profit, one can be weighted to more than the rest. For example...

folks, anyone shed some light on why you woud add a trailing amount to a sumproduct formula? background: I am redoing a tender evaluation spreadsheet built a while ago and when it comes to the weighting of each respondents criteria, the person who built the spreadsheet has used a sumproduct...

Basically I have row #2 with columns b,c,d,e,& f. in each column there are a number of points in the cell. in column g I have the added total of all the points. Is there a way to make, say, column c worth twice as many points as those in column b?

Thanks in advance to anyone who can help with this!! I have a formula - which is giving me a percentage total - this is calculated by summing a series of totals from 6 rows of data i.e: Row 1: 1 2 3 4 5 = 15 Row 2: 6 7 8 9 10 = 40 Row 3: 11 12 13 14 15 = 65 Row 4: 16 17 18 19 20 = 90 =...