This question is part of a larger investigation into specific machinery process rates.
I know the dimensions of the hopper, and thus the volume of the hopper (inverted frustum of a pyramid). However, I would like to know how to calculate the volume of a liquid in the hopper based on the level of the liquid within the hopper.
When the level of a liquid in the hopper is $75.1$ cm ($50\%$ in terms of distance between the top and the bottom of the hopper), what is the volume of the liquid?
When the level of a liquid in the hopper is $95\%$ ($142.69$ cm in terms of distance from the bottom of the hopper), what is the volume of the liquid?
I would like to be able to input a formula into an excel spreadsheet to calculate this volume, and ultimately further integrate this data into the control system.
FYI By my calculations the volume of the hopper is $2.04198802$ $\text{m}^3$.