City-Data Forum Need Help Writing An Excel Formula
 User Name Remember Me Password [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
 View detailed profile (Advanced) or searchsite with Search Forums  (Advanced)

07-11-2019, 06:30 AM
 5,211 posts, read 2,342,563 times Reputation: 14896

Quote:
 Originally Posted by Curly Q. Bobalink You're probably correct, there goes two minutes of my life, sigh. I went back and re-read the answers others gave him and saw that he's not really looking for the formula required to do the calculation, he's trying to figure out how to express it in Excel, which is really a different question than the one I answered with the link anyway. I'm no Excel expert, but I've seen this done by others - I think it's a pretty standard macro he's looking to accomplish, probably available in an Excel tutorial on You Tube, I would think. The internet has really spoiled me to the point where I was able to retire without having to do my own cipherin' anymore, LOL. During my career, I had little practical use for calculus, quite a bit for algebra, and knowing trig was essential. Kids, Math truly is Necessary, unless you want to spend your working years asking whether your customer wants fries with his order. You can look stuff up on the web, but unless you fully understand all the concepts, it's all Greek.
I'll say it again. No calculus is needed to derive the formula for the area of a partial circle. You don't even need to derive it at all, as it's readily available by a Google search, which took me less than 2 minutes. It's kind of a lengthy formula which means you have to be careful in typing it in so all your parentheses line up correctly.

Use the diameter of the tank and its length and type in the formula in Excel just like you would any other Excel formula. No macros. No need for Excel tutorials.

Done!

OP apparently did not want to do this. It was not clear to me whether OP actually understood the process of determining the volume of water in a cylindrical tank lying on its side, but at any rate, he clearly wanted to be given a fish rather than being taught how to fish.

07-11-2019, 07:27 AM
 Location: McAllen, TX 3,568 posts, read 2,393,349 times Reputation: 4246
We'll never know since the OP high tailed out of here. According to him, he had used Excel for 20 years, it sure didn't seem like it.

07-11-2019, 07:34 AM
 5,211 posts, read 2,342,563 times Reputation: 14896
Quote:
 Originally Posted by gguerra We'll never know since the OP high tailed out of here. According to him, he had used Excel for 20 years, it sure didn't seem like it.
Isn't "how to enter a formula for a calculation" about the second or third thing you learn to do in Excel?

07-11-2019, 01:27 PM
 28,243 posts, read 39,914,600 times Reputation: 36758
Quote:
 Originally Posted by Curly Q. Bobalink You're probably correct, there goes two minutes of my life, sigh. I went back and re-read the answers others gave him and saw that he's not really looking for the formula required to do the calculation, he's trying to figure out how to express it in Excel, which is really a different question than the one I answered with the link anyway. I'm no Excel expert, but I've seen this done by others - I think it's a pretty standard macro he's looking to accomplish, probably available in an Excel tutorial on You Tube, I would think. The internet has really spoiled me to the point where I was able to retire without having to do my own cipherin' anymore, LOL. During my career, I had little practical use for calculus, quite a bit for algebra, and knowing trig was essential. Kids, Math truly is Necessary, unless you want to spend your working years asking whether your customer wants fries with his order. You can look stuff up on the web, but unless you fully understand all the concepts, it's all Greek.
Ahh, math.

After 8 years I had forgotten all my trig and got a job as a draftsman - Many moons ago. Still on a drafting table moons ago - and I was told on Friday that I needed trig to do the job. I went to a store and bought a book "Plane and Spherical Trigonometry" that had questions and answers. With my wife's help I relearned trig over the weekend. I went to work Monday and told the checker that what I did. Much skepticism from everyone of course. They still sell that book

So he handed me the standard test they gave. Aced it.

A few years later we got a job forming a soccer stadium in Ridyah. The engineer gave it to me because I was the only one with an HP41, card reader, and printer. He wanted the abilty to print the numbers for the curves. It required Calculus. Uh, nope. So he had one of the interns teach me enough Calculus in an afternoon to do the job. I credit the intern with making it happen. This kid was probably the smartest person I've ever known, yet he had the ability to explain Calculus to someone like me in a manner I could easily grasp. The requirements were narrow so it wasn't like I was suddenly a Calculus wiz kid.

The stadium was a hyperbolic paraboloid. I still remember the engineers face when he saw my face after he told me that. He sort of smiled a little and said, "A horse saddle."

07-11-2019, 01:29 PM
 28,243 posts, read 39,914,600 times Reputation: 36758
Quote:
 Originally Posted by turf3 I'll say it again. No calculus is needed to derive the formula for the area of a partial circle. You don't even need to derive it at all, as it's readily available by a Google search, which took me less than 2 minutes. It's kind of a lengthy formula which means you have to be careful in typing it in so all your parentheses line up correctly. Use the diameter of the tank and its length and type in the formula in Excel just like you would any other Excel formula. No macros. No need for Excel tutorials. Done! OP apparently did not want to do this. It was not clear to me whether OP actually understood the process of determining the volume of water in a cylindrical tank lying on its side, but at any rate, he clearly wanted to be given a fish rather than being taught how to fish.
I reread the OP and I wonder if it is circular. They never said so as far as I can find. Perhaps that is why the insistence of using a chart.

07-11-2019, 01:48 PM
 5,211 posts, read 2,342,563 times Reputation: 14896
Quote:
 Originally Posted by Tek_Freek I reread the OP and I wonder if it is circular. They never said so as far as I can find. Perhaps that is why the insistence of using a chart.

He did write "Working on a project. putting together a spreadsheet to calculate fluid quantities in tanks/cylinders". But you're right, it is not totally explicit that the horizontal tank is a true cylinder (think of heating oil tanks that are oval in cross section).

But I think it was the suggestion of using thought to solve the problem that drove him off. Someone who isn't prepared to spend a couple minutes looking up a formula and a couple more minutes typing it into Excel, probably isn't prepared to distinguish between a horizontal tank of circular cross section and a horizontal tank of some other cross section.

Today, 09:03 AM
 Location: Holly Springs, NC 1,312 posts, read 729,657 times Reputation: 1908
Quote:
 Originally Posted by Des-Lab Mods: feel free to close or delete this. I came here looking for help. What has me confused might be second nature to others. I thought I explained it as clearly and succinctly as I could.
Assuming you haven't abandoned this thread, please know that what makes sense to you (because you're looking at the data) may not make sense to someone else and vice versa. I use Excel all day, every day and I'm having difficulty visualizing exactly what you want done.

You say type one value in one cell and return a corresponding value in another cell - what is the "other cell"? How is your spreadsheet configured? Without seeing what you want in Excel format, we can't help.

You said you want to:
- Create a table
- Populate cell "a" with a value
- Have cell "b" return a value based on the value entered in cell "a".

this sounds like a classic VLOOKUP. I think why people are struggling is trying to understand what you believe makes it so difficult. It sounds like there may be some information missing from your explanation that may just be an afterthought for you.

If you screenshot what you want your final result to look like that would be helpful.
 Please register to post and access all features of our very popular forum. It is free and quick. Over \$68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned. Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.