# Spreadsheet for calculating water gallons to US short tons

I currently work for the North Carolina Ports Authority and we use a hand-written invoice to send our customers for the use of on-site trash bins and metered water usage. Currently, we record a water meter's current reading (gallons) then after the customer's use of the metered water is complete, we read the end reading of the meter which is in US gallons. Subtract the beginning reading from the end reading to receive the gallons used. We then take the total US gallons used and multiply that amount by 8.34 (weight of one US gallon of water), We then take that value and divide it by 2000 (1 US Ton). This final value is the US Short Ton end calculation that we bill.

EXAMPLE:

Begin: 00750000

End: 00760000

10,000 US Gallons Used

10,000 x 8.34=83,400

83,400/2000=41.7

US Short Tons=41.7

The final Short Ton calculation to be rounded to nearest whole number

Short Tons Charge=48 Short Tons.

I'm seeking a simple invoice with auto calculations per cell

I have attached a copy of the invoice we are currently using in hopes that might help.

Lance Baxter

This should require no more than 1 hour. I will need the editable Excel file sent to me directly when completed.

( 0 comentários ) Raleigh, United States

ID do Projeto: #30177448

## 36 freelancers estão ofertando em média \$19/hora nesse trabalho

asin1987

Dear Employer, I am an Excel expert and have delivered over 1000 projects since over a decade now. I have checked your project details and will ensure highly professional delivery. Kindly check my previous reviews he Mais

\$25 USD / hora
(248 Comentários)
8.1
(1021 Comentários)
8.2
(423 Comentários)
8.3
(306 Comentários)
7.3
(121 Comentários)
6.9
(249 Comentários)
6.9
(204 Comentários)
6.9
daniyal3214

Hello, I just read your project description and will be glad to assist you with that on top priority basis. I am an experienced Data Analyst and advance level Excel user. Data Analytics, Automation and Data Visualizati Mais

\$15 USD / hora
(119 Comentários)
6.7
(101 Comentários)
5.7

Hi, Greetings! ✅checked your project details. I can create auto calculate excel invoice sheet. I Have 4 years of experience with Data entry, Data analysis, and MIS Management. I have strong analysis, and Excel/google s Mais

\$15 USD / hora
(27 Comentários)
4.5
borispetrovfrl

Hello, Sir. Expert of Data Processing, Excel is here. I've gone through your project requirement and found my skill best suited in this one. I am familiar with technologies such as C++, VB, MS Office, Database Programm Mais

\$15 USD / hora
(18 Comentários)
4.1
lesv3003

I would like to work with you on your project, I am a Physics student and I can do these calculations without problems, I also work very well in Excel and I can do the work in the shortest time possible

\$15 USD / hora
(1 Comentário)
1.9
ireshtt

Hello, Good day to you, Thank you for sharing very informative description about your project :) It makes easy to understand the exact requirements. I have done this kind of project, you can see automated quotation gen Mais

\$15 USD / hora
(1 Comentário)
1.4
snehamehta525

Hello, I am Sneh and I have understand your project and I assure you to complete the Project with 100% efficiency. I have done many similar projects so it will be more convenient for me to provide you accurate work. Mais

\$15 USD / hora
(2 Comentários)
0.7
donniebrodyjac

I very much enjoyed connecting with you and learning more about your business and vision; it's a fantastic premise and something that will lend itself well to beautiful design.  In the next few pages, I've outlined bot Mais

\$20 USD / hora
(0 Comentários)
0.0
rajmeenaswm23

Dear sir/madam, I am offering my services on short notice. Relevant Skills and Experience Please consider me and give me a chance to impress you by my quality services

\$20 USD / hora
(0 Comentários)
0.0
Simran99Gill

My skill set is a perfect match for the job requirements. I am hard working and certified . I will complete my tasks on time.

\$20 USD / hora
(0 Comentários)
0.0
kunalbanerjee

Hi! Hope you are doing well! Its very interesting work and I m interested for work to be done within time frame. I hope you will give me a chance to show my work. Your satisfaction guaranteed! Thank You!

\$15 USD / hora
(0 Comentários)
0.0
praptigbhatt

Hi, This is Prapti. I have good knowledge about excel and data entry. I can give you 100% error free work in a less time. If you will give me a chance to do this work, it will grateful for me.

\$15 USD / hora
(0 Comentários)
0.0
goelnidhi91

I am a Chartered Accountant and we Chartered Accountants are very very proficient in excel working . So giving of this opportunity to me would really of great help to you .

\$20 USD / hora
(0 Comentários)
0.0