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.
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.
[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.
35 freelancers are bidding on average $19/hour for this job
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
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
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!
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.
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 .