Microsoft Office Forums Tank level calculation in excel
 Register FAQ Search Today's Posts Mark Forums Read

#1
10-25-2023, 12:31 PM
 GhumanJas Windows 10 Office 2021 Novice Join Date: Oct 2023 Posts: 3
Tank level calculation in excel

Hey there! I'm a small business owner and I could really use your help understanding how to calculate tank levels accurately in Excel. My customer sends me tank levels every day at 8 am and 4 pm in percentage. The tank size is 320 cubic meters, and I deliver 60 cubic meters every day. Can you show me the formula to calculate this in Excel? I would really appreciate your assistance. I'm not very familiar with modern technology, so any help is welcome! Thanks!
#2
10-25-2023, 11:49 PM
 ArviLaanemets Windows 8 Office 2016 Expert Join Date: May 2017 Posts: 857

Something like this?
Attached Files
 Deliveries.xlsx (20.2 KB, 12 views)
#3
10-27-2023, 01:21 PM
 GhumanJas Windows 10 Office 2021 Novice Join Date: Oct 2023 Posts: 3
Thank you and god bless you,

That's exactly what I was looking for! Can we display the hourly blend rate for the butane plant where I deliver loads and the production rate for the NGL plant where I pull out loads (60 cubes)? I'm dealing with a total of 4 plants - 2 butane and 2 NGL. The butane plants provide levels and blend rates, while the NgL plants provide hourly production rates and daily levels at 8 am and 4 pm. Your help is greatly appreciated! Thank you so very much
#4
10-28-2023, 12:51 PM
 GhumanJas Windows 10 Office 2021 Novice Join Date: Oct 2023 Posts: 3

Quote:
 Originally Posted by ArviLaanemets Something like this?
That's exactly what I was looking for! Can we display the hourly blend rate for the butane plant where I deliver loads and the production rate for the NGL plant where I pull out loads (60 cubes)? I'm dealing with a total of 4 plants - 2 butane and 2 NGL. The butane plants provide levels and blend rates, while the NgL plants provide hourly production rates and daily levels at 8 am and 4 pm. Your help is greatly appreciated! Thank you so very much

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post Mangesh1212 Excel 3 11-30-2018 06:11 AM artlk Excel 3 11-20-2017 09:55 AM sjp1966 Excel 2 06-17-2016 02:02 AM Purge07 Excel 4 05-20-2016 07:46 PM UnholySmoke Excel 2 09-14-2011 08:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:45 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top