[GSCD]

Good evening Ladies and Gentlemen,
I am not a chemist or student but looking to gain some knowledge if some of you would share. My company trucks in a mixed NGL product where we weigh in and weigh out the tanks to determine the net weight of the total load. For each incoming load we receive an analysis with all of the components (Nitrogen, CO, Methane, Ethane, Propane, Iso-Butane, N-Butane, Iso-Pentane, N-Pentane and Hexanes plus)
Our goal is to determine , based on each load's analysis, how many gallons there are of each component in the load.
I have put together a spreadsheet based on a similar application we once used which uses each component's Mole %,Molecular wt., lbs. of component per gal, etc. , but I'm not sure I can rely on it's accuracy even though I feel it is close.
I may not be posting under the right category for this particular topic, if not please advise. Any help is much appreciated.