weights

I am creating a gradebook which has users add new evaluations through a VBA userform. Each new evaluation is added to the next empty column in the worksheet. Two of the data entered are the Category and the Points. In the sheet Settings!K2:L17, the Category code (column K) is associated with...

I've got data like this below. All the weights are supposed to be consistent. So for example all 3 pound weights are supposed to be $5, regardless of province. But there could be an error somewhere, such as in the last line. Is there a way to simply find all the difference prices for each...

Hello I am in need of some help when adding the overall grade as well as grade weights. Right now I have N/A's (Column P-R) defaulting to 1 if there is no grade.I am afraid this is still not correct. I think the grade is being over inflated with N/A's making the supplier's grade look better...

I am looking for a formula to do this if possible, but VBA will work if not available as a formula. So, in column A there are dates, column G has a driver name, column L has either LF or DT two show either landfill or downtime status. Over in column R I have weights of the landfill load, but...

Hi, I have excel files. There are different sections in this file. There are different features under each section. Unequal weights are available for these features. The sum of each section is 10. However, if there are no features under a section, the weight of the non-features needs to be...

Hi all, Very close to completing a model and cannot think of what to do. Essentially, I have a team of players 1-15 and each has a corresponding weight. I have a model with formulas that use the weights of the players to calculate a few things. Now, I could just enter the weights in manually...

Hi Guys, sorry if this has been covered before, I searched a lot but couldnt find an answer. In my formula, I need to change columns with cell references. My formula is: =SUMPRODUCT(--($C$3:$C$57=$BG3),BD$3:BD$57,H$3:H$57) I have weights in columns BD, BE and BF. In the above formula, I need...

Hi I'm trying to find a way to calculate the weight of a container based on whether I add 1,2,3,4 or 5 in a cell that references figures from another sheet. For Example In sheet "Weights" I have 5 cells with 40, 200, 480, 760, 1040 these are weights from an irregular shaped container based...

I'm creating a user input sheet of weights from a data validation list for each of four items (see image below). I'd like to code it so that it prevents the user from being able to enter (or at least issues a warning against entering) a cell value that results in the sum total of all four cells...

Hello, My requirement is to add sum of multiple rows which have individual variable weights. For example, row 1 cell has value 75 and its weight is 25%. Similarly row 2's cell has value say 100 and its weight is 40% and so on.. I need sum of all these rows. I also need to keep in mind that a...