volume

Hi Team wondering if you can help. I have 2 worksheets: Worksheet 1: Lookup table that has 2 columns that provides a water level and a volume - derived from a model <tbody> Level Volume 1330 14292.8 1329.9 14277.4 1329.8 14262.0 1329.7 14246.4 1329.6 14230.7 1329.5 14214.7...

I have a bunch of slicers for a graph that work perfectly but want to find a way to have a slicer that controls the Y axis so I can toggle between two variables (Sales and volume) If I add sales and volume as a typical slicer I know it wont work because it will pull each individual value for...

I'm having a hard time with this, and I'd really appreciate some help. I've got 8 compounds distributed across 4 containers. I need to see if there are any compounds for which the container is empty. I can use =SUMPRODUCT(1/COUNTIFS(tbl[COMPOUND],tbl[COMPOUND])) to return number of distinct...

Hi All Is it possible to maximise 2 variables using solver? Basically i have a sales organisation, i want to get the optimum product mix to maximise both Sales per unit sold & Profit per unit sold. Some products have high revenue but would loose money and vice versa. It is also subject to...

Hello Everyone, I have been working on a formula for the past hour or two and am running into a brick wall and am hoping that you will be able to help by saying "Yes that is simple, this is what you do" or "Stop being stupid Excel can't do that!!!" lol Anyway the problem I am having is...

is it possible to use a formula that will return the below from a large amount of data when given a date range? i need to know what Assigned ID performed the best over the date period, what was their total volume for that date period and the location. i have been looking for formuals that use...

I am exporting data that is coming in as a pivot summary format (not an actual pivot though). <tbody> Group Volume Held Volume Sold Week 1 (Sum) 5 (Sum) 6 (Sum) Person A 2 5 Person B 3 1 </tbody> How can I turn this (above) back to its un-formatted data (below) so that I can create my...

I am trying to duplicate values for dates when all I have is the start date. It's a SUM of all relevant volume but not cumulative since I don't want to add from the prior month. I receive a row value showing weekly quantity processed by start date. I also have a standard date table with every...

I have sales data with area & volume with sales value for both the years I want to bring total in the respective sales area, need formula when I will add new data it will automatically give results. <tbody> Data Year Volume Sales A 2018 1 200 B 2018 2 300 A 2018 3 400 B...

Hi Everyone. I'm a newbie and want to try few answers in this forum. I'm trying to find the formulae that are used to calculate Required FTE with forecasted volume, AHT and Shrinkage. As per my understanding, if we have Occupancy and SL; it would further help in accuracy of the outcome. For the...

I am working on building a formula that calculates a bonus based on multiple criteria: number of units, total volume and fixed cost per unit. I can easily create one based on the volume and fixed cost per unit, but adding the units portion is giving me difficulty. Below is the chart in which the...

hi! in a cell i have text that loos like this <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}</style><style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}table.t1 {border-collapse: collapse}td.td1 {border-style: solid...

I use excel to project production across a 12.5 hour shift. The chart is broken down by hours (rows) and columns for projected volume per hour and the actual volume for that hour. I'd like to figure out how to make the projected volume for each hour increase or decrease as the previous hour's...

Hello everyone! Tab 1 called "Component Matrix" I have a list of all my components vertically in Column C --> C5:C11 I have a list of all my programs in column F4:J4 See below for what I mean - This table represents a usage matrix. Program 2 has 1 of each of the following components - 1...

Hello everyone. I figured I would ask a question because I am going crazy figuring out where I am going wrong. Basically, I am pulling together a workout to look at the total volume for moves for my lifting program. I have a 5 day lifting routine, so ideally, I would like to simplify the below...

Hello I cannot figure this out, hoping you will:) I have a table consisting of Art.no./Month/Volume/Price <colgroup><col span="3"><col></colgroup><tbody> Art.no. Month Volume Price 210015 1612 200 190,00 210015 1702 200 200,00 210015 1705 200 200,00 </tbody> In Another...

My goal is to sum up the total Volume of a particular stock on a daily basis. The stock may be listed on one, or both, exchanges. If the Dates are the same, I want to add up both Volume totals; if the stock is listed on one Date only, then that needs to be shown as well. I have tried vlookup...

My goal is to add up the Short Volume for each stock, based on the same Stock Symbol and same date. Some stocks show on both lists, some don't. Some dates match on each list, some don't. I have tried using vlookup, as well as Index/Match, but I get confused because I am unfamiliar with dealing...

Hello, i have a report for call volume by interval, the report will exclude data if no volume on the day, the problem i'm having is the work group name and time intervals are in the same cloumn Column A | Column B | Column C workgroup a | totalcallsoffered | totalcallsanswered...

Say i have Ingredients A and B that form a solution with water. Ingredient A can be added up to 15 % of water solution volume. Ingredient B can be used up to 5 % of solution volume. Ingredients A and B in total can be used up to 15 % of solution volume. I need a calculator to count how much in...