Closed

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:

Meter Reading:

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

[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.

Skills: Excel, Data Entry, Data Processing, English (US)

See more: 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

About the Employer:
( 0 reviews ) Raleigh, United States

Project ID: #30177448

35 freelancers are bidding on average $19/hour for this job

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 More

$25 USD / hour
(252 Reviews)
8.1
(1026 Reviews)
8.2
(428 Reviews)
8.3
(307 Reviews)
7.3
(262 Reviews)
6.9
(121 Reviews)
6.9
(207 Reviews)
7.0
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 More

$15 USD / hour
(125 Reviews)
6.8
(103 Reviews)
5.8
AnuradhaVM

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 More

$15 USD / hour
(28 Reviews)
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 More

$15 USD / hour
(20 Reviews)
4.3
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. More

$15 USD / hour
(7 Reviews)
2.3
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 More

$15 USD / hour
(1 Review)
1.8
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 / hour
(1 Review)
1.9
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 More

$20 USD / hour
(0 Reviews)
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 / hour
(0 Reviews)
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 / hour
(0 Reviews)
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 / hour
(0 Reviews)
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 / hour
(0 Reviews)
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 / hour
(0 Reviews)
0.0