Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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"
this is the first steps
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.543Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started