Question: doing the homwork with program the way to start the program Open the Excel then go to View then go to Macros then choose View

doing the homwork with program

the way to start the program "Open the Excel then go to View then go to Macros then choose View Macros"

doing the homwork with program the way to start the program "Open

this is the first steps

the Excel then go to View then go to Macros then choose

Input all values except Problem 1 with InputBox. Echo input and output results to a single spreadsheet. Type all variables. Turn in both the spreadsheet and your programs. All subs may be placed in one file. 1. 1 mi = 5.28 x 103 ft., 3.28 ft = 1.00 m, 1000 m = 1 km, 1 hr-3.60 x 103 secs. Put the following V's in ft/sec in 3 cells of a column in Excel: 35.0, 45.0, 55.0. (so no echoing required.) Write a VBA program to read these values and place the equivalent speed in km/hr in adjacent cells. Label result from within VBA. 2. a. Use a long variable to compute 9! b. By trial and error, what is the largest factorial that can be computed as a long? c. Compute 12/5 as an integer, a long, and evaluate 12 mod 5. 3. The following explicit approximation to the fiction factor, f, in turbulent pipe flow is due to Zigrang and Sylvester: !=-4.0log10 [ ks/D 5.02 3.7 Re * log 10 (t ks/D 13 Re ) + Vf 3.7 Here Re is the Reynolds number, ks the roughness, and D the pipe diameter. Note logiox) 0.43429 In(x) ratio. Then evaluate f for Re = 1,000,000 and ks/D = 0.04. 4. The number of heat transfer units, NTU, in a parallel flow heat exchanger is given by Write a VBA program to input the Reynolds number and the roughness factor/diameter 1+Cr Compute NTU if Cr=0.351 and P 0.543

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!