Problem

Spheres will be placed in the wind tunnel and tested over a wide range of airspeeds to see how their drag varies with the airspeed. Create a Microsoft Excel spreadsheet that can be used to take the data collected in the wind tunnel and compute the Reynolds numbers and drag coefficients.

Both the vacuum and the dynamic pressure were measured using Dwyer gage-oil manometers scaled to read millimeters of water. Assume the density of the liquid in these manometers is ρ_m, =1000 kg/m³ when you compute the pressure difference with the hydrostatic formula, Δρ = (ρ_m - ρ_a)gh. A standard metric mass was used to calibrate the drag-beam dynamometer, and the drag force MD displayed by the dynamometer is in kilograms. Use F_D = M_Dg to put the drag force in newtons.

Use the attached sample as a guide for the proper formatting of your spreadsheet. On the attached sample spreadsheet all of the numerical values in the first four columns are input values, and all of the numerical values to the right of the first four columns have been computed using cell formulas. Your spreadsheet should have this same feature. For example, the sphere's diameter will be input in millimeters and the spreadsheet will compute the frontal area in m², so that when the value for D is changed the area will automatically change. Everything to the right of the first four columns must change automatically with changes in input values.