units

Good evening, I am having (a lot of) trouble attempting to put together a formula that properly calculates my organization's tiered bonus formula. Our managers are paid bonuses according to the following criteria: Goal: "X" units rented First Tier: 0-49.99% of goal reached, $0 (if you don't...

Hi everyone. I hopefully have a quick question that can be answered: How do I use Excel's advance filter with an array value for the criteria? Here is part of my code so far (the last line is the where I am currently stumped at): With Sheets("temp") Set matrices = .Range("B2"...

Hello, I am building an inventory production schedule and need help writing a formula for the following logic. For example, in Row A, Column A:L (January-December), I have projected sales of 25 units per month (starting in June). Additionally, my minimum monthly production order is for 30...

Hello All, There is a set of data in sheet 1. <tbody> Category Unit Period Data Lifecycle </tbody> There are 5 different units, and the categories can be similar or different across data. The data needs to categorized across units, per category, per period based on the lifecycle (only...

I am familiar with the basic functions of excel but do not have extensive experience with VBA--I have been trying to learn but I cannot seem to find an answer to a specific task which I am trying to complete. I am working with a data table (shown above) of Units with a set number of designated...

Hello Community, I've been stumped with a question for a bit while using a SUMPRODUCT. Below I have a fairly simple of example of what I want to accomplish. If the stock price ($20) is greater than the strike price, I want to take the difference and multiply it by the units. If I have a stock...

I'm trying to figure out a way to allocate a sell transaction to tax lots where the order might change over time. For example: Say you have a table with four columns and the number of units of stock stored in a row across the four columns. So A1 has the number 10 A2 has the number 4 A3 has the...

Hi I've got a spreadsheet where the power formula is used to work out the elasticity of a product. The value of cell B8 is 1,600 units and the formula in that cell is =$B$4*POWER($A8,$B$2) where B4 = 100 (and is the number of average units sold at $1) A8 = 0.25 cents (and is the price of...

Hello. I'm looking for help in creating a production schedule in excel, Gantt chart style. The schedule is for Mon - Fri, 10 hour shifts. Id like the schedule to show in 1 column the routed time in units per hour to show how many units should be produced every hour, based on the total units...

Hi, I'd greatly appreciate help finding a formula that will calculate the figures in red (cells C3:F6) in my mockup below. Column I contains sales thresholds at which different bonuses are paid in 4 tiers labelled in Column H. If I sell 100 units in Quarter 1 (Cell B3), that would mean all of...

Hi - I probably didn't title this right, but I'm not sure how to explain this. I'm working on a spreadsheet similar to this (this is a very basic example), with a summary at the bottom for all items: <tbody> Year 1 Year 2 Year 3 Item 1 Sales $20,000 $30,000 $40,000 Units 1,000 1,500...

Hi - New member and novice excel user I'm trying to set up a sheet that will calculate the price of a service based on variable pricing where the rate for the first three units is fixed at $59.30 whether it be 1,2,or 3 units and every unit after that is an extra $19.90. I am using the formula...

Hi, How would I convert hours to minutes, and minutes to units (15 min units) in excel. For example: Hours. 8 Minutes. 480 Total Units 32 How do I create a formula for this?

Hello, I will do my best to explain this... I have a list of data like this on one tab: <tbody> SKU Units Colour Shape Size abc 10 Red Square S def 15 Red Circle M ghi 40 Orange Circle L jkl 25 Yellow Square L </tbody> I have a second tab that has in cell A1 a dta validation list...

Hi, Can someone please help me with the syntax to find the average of a measure using DISTINCTCOUNT. Here is the syntax of my measure: Number of Units = DISTINCTCOUNT( LoggedInData[Unit_ID] ) I was hoping I could just do something like this: Avg Number of Units =...

Hi, I have the below table with "From (column A), To(Column B) & Unit(Column C)". In E1 when the data is entered, the formula should check if the numbers is between or equal to the number and give the updated units. In the below table if E1 = 200 then E2 should get 3.5(formula) comparing the...

Hi I'm trying to figure out a way I can actualise some data so this is the only place to come. 1) I have forecast Sales, Forecast volume and Net Invoice value (NIV) in one table. The data is granular in that it shows the sales ID an product code. 2) In another table, I am pulling through the...

I have a table consisting of ID numbers, dates, and logged units of work carried out (cumulative). From this I have added columns of: 1. Days Passed: How many days since the last entry for this ID. 2. Work Done: How many work units have been done since the last entry for that ID. 3. Daily...

Hi all, I already have a scroll bar that increases profit value of all my products sold uniformly on a quoting spreadsheet. However I require some products to have a higher profit applied as they are more expensive to produce. What happens at the moment is my SS works out the base cost, uses a...

Hi, I have an issue with a DAX formula and have spent over a week trying to resolve it. I would like to know the number of sale transactions each day. But here’s the quandary: If the total number of units sold after returns is zero, ignore transaction. If total units sold is >0 then count it 1...