I have a question regarding this problem I\'m doing in Excel. I caclulated the a

Question

I have a question regarding this problem I'm doing in Excel. I caclulated the area just fine, because that's simple, and I believe the formula for Volumetric Flowrate is just Area x Velocity. But as far as calculating it over the entire object is confusing me. Can you help me figure out how to calculate the flowrate for the entire object given those numbers, and the average velocity? Is the average velocity done by doing a matrix function in excel?

Problem Richards 3-4 m Richards 3-4 The cross-sectional area of a rectangular duct is divided into 16 sections and the average velocity is indicated in each section. Use this to find the total volumetric flowrate and average velocity. If the duct connects to a 12 in diameter cylindrical section, what is the average velocity in that section? duct width 20 inches duct height 16 inches velocities in ft/s segment height, in 3.0 3.4 3.6 3.1 3.7 4.0 3.9 3.8 16.0 in 3.9 4.6 4.3 4.2 3.9 3.7 4.4 4.3 20.0 in 8 8 2 segment width 2 inches assume constant density for the air area of duct segments, ft2 0.333 1333 1.333 0.333 1.000 4.000 4.000 11.000 1.000 4.000 4.000 11.000 0.333 1333 1.333 0.333 Vol Flow cu ft/s cu ft/min full duct area

Explanation / Answer

First step is to calculate the area of flow in each segment. Which is just the segment width multiplied by segment height , remember to convert them to feet.

The next step is to find the flow of air in each segment which is area calculated in previous step multiplied by velocity of air in each segment.

To find the total flow add the individual flow rates obtained in previous step.

Average velocity is equal to total flow by total area.

Matrix function may not be necessary. You can use the summation function to obtain the sum of all the values

To find the velocity on cylindrical portion use continuity equation Q= Area* Avg Velovity=constant

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.