Write a VBA function that will return the volume in the tank given the radius (R), the length (L) and the height of fuel (h).

Use your function to list the volume (V) of the tank in Gallons at every height at steps of 2*R/25 (i.e. there should be 25 rows, from 0 to 2*R) on an Excel worksheet, essentially creating a Fuel Gauge. Create a chart of the results, h vs. V.

Only high-school level trigonometry is required to solve for V given h, but, as this is a bonus problem, I'm not going to give you the formula (boo!). However, I will provide this figure as a hint:

Consider the infamous horizontal cylindrical fuel tank: 2R Write a VBA function that will return the volume in the tank given the radius (R), the length (L) and the height of fuel Use your function to list the volume (V) of the tank in Gallons at every height at steps of 2*R/25 (i.e. there should be 25 rows, from 0 to 2"R) on an Excel worksheet, essentially creating a Fuel Gauge. Create a chart of the results, h vs. V. Only high-school level trigonometry is required to solve for V given h, but, as this is a bonus problem, I'm not going to give you the formula (boo!). However, I will provide this figure as a hint: Air Space rh Consider the infamous horizontal cylindrical fuel tank: 2R Write a VBA function that will return the volume in the tank given the radius (R), the length (L) and the height of fuel Use your function to list the volume (V) of the tank in Gallons at every height at steps of 2*R/25 (i.e. there should be 25 rows, from 0 to 2"R) on an Excel worksheet, essentially creating a Fuel Gauge. Create a chart of the results, h vs. V. Only high-school level trigonometry is required to solve for V given h, but, as this is a bonus problem, I'm not going to give you the formula (boo!). However, I will provide this figure as a hint: Air Space rh