The above is an explanation for a sample calculation of the volume of a trapezoidal prismatic pit with slopes around its perimeter, and interior rectangular prisms with slopes away. This, and other formulas, can be transferred into excel sheets for efficient calculation based on different variables.
Please note that the above formula is simplistic, for demonstration purposes only, has some limitations, and should not be used for any actual work or calculation. Any complex calculations or spreadsheet design which includes engineering calculations, applications, or designs also require the approval and oversight by a professional engineer within the company which intends to use them, prior to using them on any actual projects. For more information, contact us.