If you look at the second drawing, the top 63" was pretty easy for me to figure out, because it tells me that on the flat walls, there are 74.8 gallons per inch.
I dont have any information on the stirrer, although looking at the gallon sizes listed on the one image, im assuming that they are taking the stirrer into consideration when giving those numbers? What is the outside diameter of the pipe? That would help give a more accurate table. I would assume that no chocolate would be inside the pipe which serves as the axis for this mechanism. However, it looks like there is an agitator or stirrer which is mounted inside the tank. It's relatively easy to calculate the gross volume of the tank. BTW, 'ullage' is the distance between the top of the tank and the surface of the liquid inside the tank. It looks like you have the key tank dimensions to create this table. What you are looking for is called an 'ullage table'. The bottom 45" is what I cannot figure out. The overall depth of the tank, at the center is 108". That area of the tank holds 2,644 gallons or 29,347.078 pounds. From a side view of the tank(Small side 90") the tank appears to be a half circle with a 45" radius. The things that I do know are that a gallon of chocolate weighs 11.0995 lbs, and the bottom area that I am trying to figure out has a measurement from the top view of 192" x 90". The straight sides were pretty easy for me to figure out, but once the chocolate is down farther than 63" (where the slope starts) I am having a hard time grasping a way to come up with a formula for that part of the tank.īeing that im using an excel spreadsheet with VBA I dont need one big formula, everything can be split up into smaller formulas that will perform behind the scenes in the spreadsheet. The tank has straight sides, but a rounded bottom. I will be sharing this with others in my workplace also, so I will be placing it in a spreadsheet so that it is easy for everyone to use. Since we do not have a scale on this tank, my goal is to be able to take a measurement from the inside top of the tank to the top of the chocolate and be able to tell how many pounds we have left in the tank with that measurement. I am trying to come up with a way to calculate the amount of chocolate being held in the chocolate reserve tank at my place of employment.
Reading threw some of the threads, it sounds like we have a great group of people here. First off Id like to say hello and I am glad I found this forum.
0 kommentar(er)
