volume

Hi This is my first post so I hope I am doing everything correctly. I have 2 tabs of data one for imports and one for exports. What I need to do is: If cumulative value of exports is less than the imported volume of shipment 1, return the reference for shipment 1. Once the volume of shipment...

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...

Complicated problem! Thanks to Mr. Bill Jelen for authoring the extraordinary book; “PowerPivot for the Data Analyst”. However, I remain stumped on a difficult problem; Any assistance is greatly appreciated!!! The problem would be similar to restaurant occupancy. I need to calculate...

Hi Mr. Excel forum, Very grateful for any suggestions on how to achieve objective for this spreadsheet. Searched the forum for a while but don't even know how to categorize the question. The spreadsheet in question has 107,821 rows of data. Each row holds 1 years product volume for a...

Hi New here so was wondering if anyone can help me with a formula I have now had to start using regularly. It's a bit beyond my excel capabilities. It is for calculating the volume liquid in part of a cylinder lying on its side Where R is the cylinder radius D is the depth of liquid L is the...

Hi everyone, I'm coming across a problem for a greater issue and was hoping someone could help with the first step. I'm trying to put together a staffing and sizing chart (the big problem, that I may ask for help with at a later date) but have a question for the staffing component. My issue...

I have a fact file containing a column of measures and corresponding values, for example, <tbody> Measure Value Volume 100 Revenue 70 Cost 20 </tbody> This is repeated for thousands of transactions across many months - so my table is a few hundred thousand rows. I want to write...

Hi all, I am new to this forum so hope my post is ok :-) I am trying to sum up values based on date criteria. Say the date is 04/08/2017. I want to add up the total volume for that date and populate into one cell as below without having to do it manually. Does anyone know a formula for this? I...

Morning all, I am not sure how to explain what I need but I will try! I got a spreadsheet from 2007 until 2016 with flow data. I would like to excel populate G2, H2, I2... if column A and B match with F2 and G1 (f2 and H1, f2 and I1...). I am using the following formula but it only works for...

I'm new as a member to this forum but have admired the contributions from members for some time as a reader. I have a question on Price, Volume and Mix (PVM) calculations with the nuance regarding introduction of a 0 (Zero) into the analysis. Most of the PVM analysis and the corresponding...

Hello, I am trying to calculate headcount needed based off of volume. There is a toggle used in the calculation that I can say I need per 100 units of volume, per 200, etc. but I only went up to the toggle value times 4. I need the formula to possibly support a much larger volume such as 40...

Someone please help me to create a formula to calculate the volume in cubic feet from the given circumference and length (in feet). This is find the volume of lumber. Thank you all in advance.

Hi I have an area chart that has two series. I first want to calculate the area of the graph, or more specifically I want to calculate the area within the two series lines. I would then like to mark the point where it is 70% percent volume (of area) on the left and 30% vloume (of area) on...