Answered step by step
Verified Expert Solution
Link Copied!

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"

image text in transcribed

this is the first steps

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Marketing The Ultimate Marketing Tool

Authors: Edward L. Nash

1st Edition

0070460639, 978-0070460638

More Books

Students also viewed these Databases questions

Question

b. Does senior management trust the team?

Answered: 1 week ago

Question

How will the members be held accountable?

Answered: 1 week ago