units

Hi! I'm designing a new promotion and i'm thinking how to determine the quantity for each tier as well as how to determine what tiers i should create? e.g. Tier 1 = 1 to 5 units purchase = 2x bonus points Tier 2 = 6 to 50 units purchase = 5 x bonus points Tier 3 = 51 units and above = 10 x...

Hi Guys, im working on a database for my works units that we send to events, ive made a formula that works perfectly when looking at a certain location, where is the locations are represented by a number (ie. 1 is Australia 2 is United States and so forth), but id like to make an option to see...

Hi I have a sheet where I'm extracting the pack size of a product using IF(ISNUMBER(SEARCH then multplying that pack size by the units of the product. However, there are some products where the pack size is 2 and others where it is 12 eg Chocolates 2x250g Chocolates 12x250g Excel can't...

Hello, I'm trying get my head around how i can get to the below done using function instead doing manually. Basically I need split the units value based on the minutes allocated within time slot (start time & end time) ie, for the first line because it's between 04:00 and 05:00 it will...

Hi, I am new to VBA and trying to build a macro. I need to select a particular entire column which has some units for example say distance 72.4 Km/h (this value may varied and is applicable for single cell). I need to strip off the units and get only 72.4 and that should be copied to another...

Hi, Good day all, I am preparing a forecast for next 10 years for my company. So I used activex scroll bars to control number of units expected to be sold. For example no of units sold in 1st year were controlled by an ActiveX bar and then the annual increase (by a %age) in no. of units was...

How do I combine these two formulas? =VLOOKUP(A4,Units,2,FALSE) =MID(A4,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A4&"0123456789")),1)

I am trying to sum a positive and a negative value to give a positive value i.e <colgroup><col><col span="3"></colgroup><tbody> Positive units Negative Units Total Units UK 3,722 -8,378 12,100 </tbody> Ideally this needs to be done automatically with no further manual steps...

Hi, I have 2 elements that I would like to use to find the final result. I have quantity and length, upon which I am looking for price per unit. Here is a table of the information with quantity along the X axis and length down the Y: <tbody> 2500 5000 10,000 15,000 78m 0.76 0.73 0.71 0.70...

Hi All, I've used this site for years to search for answers to formula problems I've had and loved it. But now I'm trying to find a formula to calculate a productivity based on 2 different volume metrics and I'm stumped! So the basic productivity calculation we use is ORDERS / HOURS = hourly...

So I am trying to do some analysis on a portfolio of loans. The structure of the data is such that it is a web of many to many relationships. I have data tables for, among others: Borrowers Loans Guarantees Units Properties The Units have a many to one relationship with the properties, but...

Hi all, I’m currently working on a generic pricing template, where the End user is able to specify the unit cost of an item, the number of units that qualify for a bulk purchase discount and the discount rate at each of these bulk purchase intervals. Example This is an example of the table...

Hi! Let me apologize for the vague title but the one thing that i'm looking for I don't even know if it has a technical name -which limits my ability to google it-. I have a file with 22.000 rows and these are the headers for each column: SERIAL NUMBER LOCATION_MONITORING LEVEL EFFECTIVE...

I have the following table below and I'm trying to use INDEX:MATCH:MATCH, but I'm having a challenge searching between the two different ranges. In Cell B1 user would input the number of units In Cell B2 User would input the annual sales. In cell B3 I need a formula that would look at cell B1...

Hi I have an OH report that calculates the current OH. I would like to figure out what the OH was each of the last 52 weeks. I need to take OH + SALES + UNITS SENT - UNITS RECEIVED to figure out the balances of each of the prior 52 weeks. Do I have to create 52 measures? Is there a better...

I'm trying to analyze some sales data at work and forecast demand.#3[/URL] 33333] I need help drafting an excel formula to do what I want. Here are the important points: 1. Products are often out of stock, so I want to assume that any day with zero sales is an out of stock day, and...

Hi I've created a formula to calculate the OH as of 1 YR ago today. But I would like to find a way to figure out the OH as of any date I enter into a cell or select from a drop down (Calendar table) What the current formula does is take OH now + units sold in the last 364 days, - whats been...

Hi, Sorry if this is trivial, but I can't internet search this properly cause it is difficult to explain my question to a search engine :( I am working on a capacity planning spreadsheet. If can do 100 units of work, but I know that if someone assigns me 100 units of work but it may be 50%...

Hi guys I have a various level pricing format as below, which should work similar to scaled commission / tax calculations. For example, 15000 units, should be charged as the first 5k (£0), the next 5k (£3 per unit) and the remaining 5k units charged at £2.50 per unit. I've done some research...

I have a problem where I am trying to determine percentage averages for multiple customers in a given period. For example in the graphic below, "Cust 1" has 10 units at a 10 percent discount, Customer 2 had 20 units at a 5% discount and so on. For the quarter, the average discount is...