weight

Good day, I am hoping someone can help me simplify a project to rank our sales force. We need to rank them by 4 criteria and each has a different weight. Here are the columns, criteria and weights: <tbody> <tbody> Weight 0.4 0.2 0.25 0.15 Rep % of Budget % of PY PY $ Change Subjective...

Hi I wanted to assign value to this line Workbooks(1).Worksheets(1).Cells(xrow, xcol).Borders.Weight = So I used Object Browser, and typed Borders then clicked on weight and I read the following: Property Weight As Variant Property Weight As Variant that is all! nothing else. I had...

Hey Guys, I'm not too sure how to approach this but i think it's a VBA problem and i'm having a lot of trouble figuring it out. Apologies in advance... it's a long one lol TL;DR The problem is i'm trying to find the optimal allocations to result in the highest possible value given some...

I have created the following : <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> Total weight 45 25 15 10 5 220 4 1 1 0 0 100...

Hi wonderful people, I'm working on a spreadsheet for a weight loss program where a participant receives a financial reward for every full pound of weight they lose. Not sure if that title is exactly what I'm looking for, but it was a struggle to describe it in a few short words. I am...

Hi all, I was wondering if anyone could help me confirm that this formula, =60.7*height+45.3*weight-2055, was correctly written with the order of operations when put into excel. A2=(60.7*B2)+(45.3*C2)-2055 B2 = height C2 = weight Thanks in advance.

Hi Folks Having a brain fart...... On my "counts" sheet I want to get the number from a column in my KCPs sheet but only to be counted if cells another column in KCPs contains a specific value (T1)..... I thought this =COUNTIFS(KCPs!$H$2:$H$10000,"T1",KCPs!$K2:$K10000,<>"") (My K column is...

Hi, When I am passing a range to the below UDF, say A1=CorrelationCoefficient(B1:C100, 1, 2, 0) I am getting an VALUE error. Any reason why? The code is: Public Function CorrelationCoefficient(MyArray() As Double, Optional asX As Long = -1, _ Optional...

Hi all Long time lurker, first of many posts hopefully... I have a table in power bi with 2 columns. Column 1 = type of animal. Dog, cat, hamster, mouse, etc. Column 2 = weight of animal. Integer value. I have a bar chart with the x axis = type of animal. Each bar is the average weight of...

I am currently trying to work out how to return a row label based on the position of a value found in a table. My table has 4 rows and 7 columns of data (plus a row and column of labels). I want Excel to find my formula's value in the table and return the label for that row. This is to do with...

Hello! I'm using solver for stock portfolio optimization. The solver changes weights to achieve maximum expected return. I have set the following constraints: The portfolio should consist of at least 5 stocks (out of 10) and maximum weight assigned for one stock is 30%. In this case the solver...

Hello, I'm trying to make a table or chart which can show how much a person's running time will change with different weights of footwear. Ideally, I'd like to be able to enter a theoretical weight (in g or kg) and come up with a time in mm:ss or even just straight seconds. An example: A...

Hello, I'm looking to inquire about how to return a country's cost, based on a given weight. The issue is that the weights I'm looking up against have predesignated weight breaks, the given weights ('B' below) may fall between the range. I'm ultimately looking to return the rounded up value...

Hello, I will do my best to explain what I am looking to do. 1) Column A has a person's name 2) The top columns have all 50 states 3) The states that the people have licenses in will have an "x" in them. So it would look something like this <tbody> CA AZ FL OR NV Betty Sue X X X...

Hi, Have a data set with 6 columns and roughly 10000K rows. My columns are: Date/Initials/Commidity/Weight/Container Weight/Net Weight. I use this data to track how much recycling material is processed with 4 different types of commidities. However, while this is used for every entry, once my...

I am looking for an xl formula to calculate the check digit for a MERS MIN. They tell me it is a MOD 10 Weight 2 Algorithm.

Hi All, I have a UDF that works fine until I make an edit in another workbook. On return to the workbook with the UDF, it is not calculating properly. A press of F9 will force correct calculation. I have the line Application.volatile at the start of the function. If I edit any cell in the...

I am trying to make a chart to figure weight lost gains and losses per person. I need the beginning weight for the month with week 1's weight, week 2 and so on. I also need, in between the weeks, the gain or loss amount which I have figured by subtracting the two. When I get to the end of the...

<tbody> A B C D E F G H I J 1 ID DATE1 WEIGHT1 DATE2 WEIGHT2 DATE3 WEIGHT3 DATE4 WEIGHT4 ARRIVAL DATE 2 12345678 43108.55 60 39681.38 62 38227.88 58 42507.28 61 41109.58 3 23456781 42509.9 100 42634.77 111...

Hello, I have an issue where i have a shipping chart and want to use vlookup on the weight to grab a shipping price. the only thing is that anything past 150 lbs will be charged $0.47 per pound thats over 150. So lets say a have the weight in row B. B2 = 200. If B2 > 150 it needs to grab the...