New Table Help
Here is my situation:
I need to make one field take the average of some of the numbers in the chart on the attached picture. The way the table works is this, the dia. is diameter of a cylinder. The straight wall is how tall the cylinder is. What we use this for is to get a tapering thickness of a certain size cylinder.
You would read the chart like this: If you need a 6' dia. x 20' tall cylinder, find the 6' dia and the 20' straight wall and drag your fingers until they meet. That number is the bottom thickness. In this case it is 2.5. Now the cylinder tapers as you get taller and ends at the 2' straight wall for any given size. In the case of the 6' x 20' the tapering sequence would be this:
2.5, 2.5, 2.5, 2.5, 2.5, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 1.5, 1.5
What I am trying to do is make a table with this chart data (the chart is in excel now) and have a field gather all of the numbers in a tapering sequence and get the average of those numbers. It would also need to allow a user to enter any cylinder size up to 14' x 40' and find the average thickness of that size. I haven't the slightest clue how to make the table or get all of the numbers in a sequence. Any help would be greatly appreciated.