I am looking for a simple calculator or Microsoft excel spreadsheet that can help me figure out net bbls of crude based on API gravity and temperature...

For example:

A truck comes and picks up 180 bbl (gross volume) of 44 gravity crude that is 85 degrees Farenheit and has .8% BS&W.

What is my net bbl that I will get paid on taking into consideration gravity* temperature and BS&W???

I am trying to audit my crude purchaser on oil sales year to date. Any help is most appreciated.

Thank you*

See More: Crude Oil Sales - Gross vs. Net Bbls