- 551K Members
- 2,907 Online
- 661K Conversations

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- Home
- :
- Excel
- :
- General Discussion
- :
- Re: Help required to determine correct calculation methodology/formula

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- Home
- :
- Excel
- :
- General Discussion
- :
- Re: Help required to determine correct calculation methodology/formula

- Subscribe to RSS Feed
- Mark Conversation as New
- Mark Conversation as Read
- Pin this Conversation for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-11-2019 11:50 AM

Greetings

I am quite a newbie around excel, and I am in the process to design an excel calculator to determine volume in tanks.

My question is this:

From calibration tables, I observe for example the following information,

1 mtr of level = 375 cub mtrs

1.10 mtr of level=380 cub mtrs

1.20 mtrs of level = 417 cub mtrs

Is there any formula, which I can use to calculate the within the 1.10 & 1.20 mtrs indication cubic meters.

For example if the measurement shows, 1.13 mtrs I would like to find how much cubic mtrs has the tank…

I hope my question was clear…

Thanks in advanced for any help and any advice for further research.

Labels:

5 Replies

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-15-2019 09:15 PM

You may use array constants as follows:

=LOOKUP(A7,

{0;1;1.1;1.2},

{0;375;380;417}+({375;50;370;0}*(A7-LOOKUP(A7,{0;1;1.1;1.2}))))

Note the calculation of the following constants:

1. (375-0)/(1-0)=375;

2. (380-375)/(1.1-1)=50; and

3. (417-380)/(1.2-1.1)=370.

=LOOKUP(A7,

{0;1;1.1;1.2},

{0;375;380;417}+({375;50;370;0}*(A7-LOOKUP(A7,{0;1;1.1;1.2}))))

Note the calculation of the following constants:

1. (375-0)/(1-0)=375;

2. (380-375)/(1.1-1)=50; and

3. (417-380)/(1.2-1.1)=370.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-16-2019 03:24 AM

Afraid the function is far from linear. If the tank is horizontal cylinder we shall to calculate segment square based on the level. If more complex form the approximation will be even more complex. In any case just 3 points is not enough for any approximation but linear.

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-16-2019 11:51 AM

Thanks for the prompt reply, I will cross check and revert if any correction need...

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-16-2019 11:57 AM

@Sergei Baklanthanks for the reply.

All my tanks are cylinder tanks, with conical bottom.

The conical space can be easily measured (I have done that already), the issue is that I have to calculate fast the volume on all tanks based on their level, as much as accurate as possible.

The level is very fast changing and the only remote indication I have is the level in centimeters, that's the reason I need to create this calculator...

Thanks again...

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

02-16-2019 01:59 PM

With such shape formula could work after 1.1, as I guess that's cylindrical part

I'd only use linear approximation for the second part ignoring first point, like

=270*(A7-1.1)+380

Related Conversations

SharePoint 2013 LIst Filters (by latest date)

dmphil
in
SharePoint
on
02-27-2020
45
Views

0 Likes

0 Replies

How to get maximum scores by control Category?

lvillara
in
Using Microsoft Graph Security API
on
01-26-2020
148
Views

0 Likes

2 Replies

Can i please get some explanation and information about the things written in the Local State file?

HotCakeX
in
Discussions
on
01-21-2020
291
Views

0 Likes

5 Replies

Can't sign in to Edge insider browser on Windows Sandbox

HotCakeX
in
Discussions
on
01-11-2020
112
Views

0 Likes

2 Replies

Cannot Export App Package Save As for SharePint

LukeA79
in
Access
on
12-02-2019
149
Views

0 Likes

0 Replies

Share

Popular

Learning Resources

Programs

Values

- Contact us
- Privacy & cookies
- Terms of use
- Trademarks
- About our ads
- © Microsoft