Excel Formula: Calculating Weight for Different Sized Containers
In this article, we will discuss how to calculate the weight of raw materials for different sized containers in Excel. This can be useful for customers who want to determine the total weight of many jerry cans needed for their raw materials.
Calculating Weight per Container
To calculate the weight per container, you will need to know the volume of the container and the density of the raw material. The formula for calculating weight is: weight = volume x density.
For example, if you have a jerry can with a volume of 20 liters and the raw material has a density of 0.8 kg/liter, the weight of the raw material in the jerry can would be: 20 liters x 0.8 kg/liter = 16 kg.
Weight per container formula:
= Volume x Density
Calculating Total Weight for Multiple Containers
To calculate the total weight for multiple containers, you will need to know the number of containers and the weight per container. The formula for calculating total weight is: total weight = number of containers x weight per container.
For example, if you have 10 jerry cans, each with a weight of 16 kg, the total weight of the raw materials would be: 10 jerry cans x 16 kg/jerry can = 160 kg.
Total weight formula:
= Number of containers x Weight per container
Creating an Excel Spreadsheet for Calculating Weight
To create an Excel spreadsheet for calculating weight, you can use the following steps:
- Create columns for volume, density, and weight per container.
- Enter the volume and density for each container in the corresponding columns.
- Use the weight per container formula to calculate the weight for each container.
- Create a new column for total weight.
- Enter the number of containers in the total weight column.
- Use the total weight formula to calculate the total weight of the raw materials.
Excel spreadsheet layout:
A | B | C | D
1 | Volume | Density | Weight per container | Total weight
2 | 20 | 0.8 | =B2*C2 | =D2*A2
3 | 30 | 0.9 | =B3*C3 | =D3*A3
4 | ... | ... | ... | ...
References
- Excel Easy: Weight and Density
- Vertex42: Weight and Volume Calculator
- Excel Tip: Calculate Density and Weight
This article covers the key concepts and steps for calculating the weight of raw materials for different sized containers in Excel. By following the instructions and formulas provided, you can effectively determine the total weight of many jerry cans needed for your raw materials.