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.


Meter Reading:

Begin: 00750000

End: 00760000

10,000 US Gallons Used

10,000 x 8.34=83,400


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

[login to view URL] at [login to view URL]

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

Taidot: Excel, Tiedonsyöttö, Tietojenkäsittely, Englanti (Yhdysvallat)

Näytä lisää: write short description work, short article work travel, short answer work exp, spreadsheet calculating tiered rates, short essays work, spreadsheet calculating aluvial gold, excel spreadsheet calculating texas holdem odds, short answer work experience, short descriptive work samples, short articles work, excel spreadsheet calculating golf handicap, short article work, tons work load, sql short project work, excel golf handicap spreadsheet calculating scores, short biography work, short term work canberra freelancer, US english typing work, Morphing before (us carrying out work) and after product images , us to india work

Tietoa työnantajasta:
( 0 arvostelua ) Raleigh, United States

Projektin tunnus: #30177448

35 freelanceria on tarjonnut keskimäärin $19/tunti tähän työhön


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 Lisää

$25 USD / tunti
(252 arvostelua)
(1026 arvostelua)
(428 arvostelua)
(307 arvostelua)
(262 arvostelua)
(121 arvostelua)
(207 arvostelua)

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 Lisää

$15 USD / tunti
(125 arvostelua)
(103 arvostelua)

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 Lisää

$15 USD / tunti
(28 arvostelua)

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 Lisää

$15 USD / tunti
(20 arvostelua)

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. Lisää

$15 USD / tunti
(7 arvostelua)

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 Lisää

$15 USD / tunti
(1 arvostelu)

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 / tunti
(1 arvostelu)

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 Lisää

$20 USD / tunti
(0 arvostelua)

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 / tunti
(0 arvostelua)

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 / tunti
(0 arvostelua)

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 / tunti
(0 arvostelua)

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 / tunti
(0 arvostelua)

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 / tunti
(0 arvostelua)