Read Chapter 3 - Graphing with Excel Determine the near minimum Pipe inside diameters to carry water loads using Graphical means. 0.09 Cu Meters of water per second ( Velocity should not exceed 3 m/s) - 0.85 Cu Meters of water per second (Velocity should not exceed 3 m/s) Plot BOTH relationships on the same Graph Select & indicate the Best choice for each Pipe Inside Diameter. Sign in METHO FAZO Lesson-3 Class problems - Excel Tell me what you want to do File Home Insert Page Layout Formulas Data Review View Help Share AutoSum - Calibri A General X Cut B Copy Format Painter 2 Wrap Text Merge & Cartier - 47 Paste == +298 Insert Delete Format Conditional Format as Cell Formatting" Table Styles Styles Clear Sort & Find a Filter - Select Editing Clipboard Font Alignment Number Cells VIS A D M N P R $ T U v w 1. 2 3 Given that the required flow rate of water to a building to support peak water load demand is 0.20 Cu m/s and we need to miantain a flow velocity of 3.00 meters per second or less to minimize friction and power requirements of the pump that supplies water flow: Determine the Minimum pipe diameter needed to support these requirements. =PI()*((D12/2)^2) 5 A-Piersquared V-Q/A Diameter Fluid Velocity m/s 8 20.000 AV 0.06667 Square Meters A. Reg'd Flow rate cu m/sec 0.200 200 0.200 0.200 0.200 0.200 0.200 0.200 0.200 0.200 0.200 0.200 0.200 0.200 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 15.000 m 0.100 0.200 0.500 0.400 0.500 0.600 0.700 0.800 0.900 1000 1.100 1.200 1.300 Flow Area m2 0008 0.031 0.07 0.126 0.196 0269 0.30 0.500 0.636 0.785 0.950 1.131 1.327 1.539 Fluid Velocity m/s 225005 6500 2009 1.592 1.019 0.707 0.520 0.398 0.314 0.255 0.210 0.177 0.151 0.130 , 10.000 D- SORT A/PI)) 2 0.29135 Meters D- 5.000 0000 0.400 Inside ipewe Adding a plot line FA20 Lesson-3 Class lab - 1 FA20 Lesson-3 Class lab - 2 + 80 Type here to search Address 12:01 PM 9/21/2020