I need to be able to calculate the weight of an 18-wheeler before he is loaded with LPG.
Company X comes into our facility to be loaded with LPG. He provides his Tare weight (Empty Weight) as he has just been scaled at the CAT scales somewhere close by.
Of course we also have the capacity of the trailer in gallons (generally 10,500 - 11,500)
On an Excel spreadsheet I have:
calculations for measuring/calculating the vapor pressure based upon the analysis/composition of the product
I have the calculations for determining the Gravity of the product based upon the following gravities (assuming they are correct:
Methane 0.03
Ethane 0.356
Propane 0.5075
Propylene 0.527
Isobutane 0.563
Normal Butane. 0.584
Iso-Butylene. 0.6001
Trans-but 0.601
Cis2-Butylene 0.6271
Iso Pentane 0.624
Normal Pentane 0.631
Hexane 0.664
Truck Drivers can only load a maximum of 80,000 pounds (total weight of everything - tractor,trailer,bottle)
I'm doing something wrong in my calculations. My job is to get those bottles filled so that they weigh as close to 80,000 pounds as possible. Usually, with what we're loading right now, that comes out to around 70%-73%.
I'm calculating the weight per gallon as per the components of the anaylsis. Right now that weight is right at about 4.77 pounds/gallon
I'm taking 80,000 pounds and subtracting the tare weight (so we have an inbound weight and when he leaves to go scale right down the road he gets the outbound weight)
An example would be
Water capacity gallons - 11,500
Percent Loaded - 64%
Calculated Gravity - 0.594
Vapor Pressure - 30.9
Temperature 95
Temperature Factor 0.966
One more thing.... something that seems to be much more complicated.... I need to be able to calculate how much actual product is in the bottle when it is 'empty' but has 50# or 75# of pressure. I assume the variables above would be enough to come up with that number. So how many pounds OR how many gallons does that vapor pressure equal at 75# pressure on an 11,500 trailer?