units

I have a spreadsheet set up as: date utility units used cost 7/2/2016 gas 122 $94.86 7/12/2016 electric 98 $100.00 2/15/2017 water 99 $56.87 2/20/2017 gas 120 $122.25 4/28/2017 electric 147...

I'm working on a project where I need to count unique distinct values that meet more multiple criteria. In this instance I need to look at: Orders that were placed in 2014 Unique customers that placed Web Orders I am trying to determine how many units (rooms) each unique customer...

Hello, I am attempting to write a formula for distributed/cumulative tiered pricing and am not able to get the formula correctly. 1 - 30 units = $90/unit 31 - 60 units = $75/unit 61 - 100 units = $60/unit More than 100 units = $55/unit Examples of expected calculations are: 55 Units...

Mr. Excel Forum, I have a sales team that gets paid based on units sold not dollars sold and then a percentage for bonus. I'm trying to figure out a formula that would allow them to track sales and see potential commissions. For basic math sake they need to sell 60 units a quarter. They only...

I am hoping someone can help me with this issue. I may not be explaining this very well but hopefully someone can decipher this for me. I have been looking everywhere to see how it would be possible to add data to bars in a pivot chart from related data. If you look at the attached image, I...

Please help me sort out this problem as I need to use it everyday and it is really a headache if it goes wrong, I have a target to sell 1500 units (A1) which is calculated on a daily achievement, suppose I achieved 50 units (A4) today and my till date achievement is 500 units (A2), the...

Greetings, I can find information about how to build a formula to calculate income tax, but I can't seem to get them to work for my use case, which is admittedly a little different. Let's say I have a price chart: <tbody> From To Price Ea 0 1000 200 1001 5000 50 5001 10000 45 10001...

I'm working on a pretty cool, albeit challenging (to me) problem, and I've gotten pretty far thanks to the good people of this forum and I need some help to make a good solution GREAT! Production Output Tracking: Cycle times are around 20-60 seconds for each cell, and there are 20 cells, so we...

Hi guys, i'm wondering if anyone can help, as this has got me completely confused... i'm not sure if there is a simple way to do this, or if I need to delve into the murky waters of circular referencing? I have a spreadsheet that look like this... <colgroup><col width="107"...

Hi. I've had a look on line but all the Macros are too complicated. I am looking for the following Looking for an email with the title West Availability Report – 0500hrs Tuesday 25th July 2017 ( the date changes daily) to extract information in it (a table to be exact) and move it to Excel...

Hi, Good day! I have a column of figures with several units attached to it via custom format, e.g. KG, PC, G, CS, etc. I would like to extract the units onto another column, showing only the units using formula only. I've tried the =cell("format",XX) function but it seems to return ",0"...

Dear All, I am struggling with a situation where I developed a feasibility study, and would like to ADD COST (FIXED NUMBER) AT EVERY INTERNAL AFTER ACHIEVING A CERTAIN NUMBER OF UNITS SOLD, for example: Cost of procuring 10,000 units is USD 2,000.00 Yr0 Yr1 Yr2...

Hi, I need ideas on how to display a Metric and Imperial units on a chart. The problem is I need to somehow show these on the primary AND secondary axis. The chart is showing a comparison of pump performances with speed curves and an expected output torque. Y1 Axis: Output Speed (RPM) Y2 Axis...

I'm working on a report where I'm auto-generating a text report based on this months numbers using several cells and IF functions etc. The result is something like this: Inbound of $24.5M is up $3.8M from last month. EBIT for the month of ($0.7)M was equally to forecast. Compared to budget...