Some alternate energy technologies, such as wind and solar, produce more energy than needed during peak production times (windy and sunny days), but produce insufficient energy at other times (calm days and nighttime). Many schemes have been concocted to store the surplus energy generated during peak times for later use when generation decreases. One scheme is to use the energy to spin a massive flywheel at very high speeds, then use the rotational kinetic energy stored to power an electric generator later. (b) What should be typed into cell E4 that can then be copied through the rest of the first table to calculate the flywheel volumes? Assume the shape of the flywheel to be a cylinder. For the cell E4 select the the appropriate expression in Excel. Assume the contents of all the other cells in the required range to be copy-pasted from E4. 18 2 3 19 4 20 5 6 7 23 8 24 ... 21 ... 22 ... 10 11 12 ... 13 14 15 D Volume (V) [m] Diameter (D) [m] 16 (c) What should be typed into cell E12 that can then be copied through the rest of the second table to calculate the flywheel masses? 2 3 4 For the cell E12 select the the appropriate expression in Excel. Assume the contents of all the other cells in the required range to be copy-pasted from E12. D 0.2 0.2 0.4 0.4 0.6 0.6 0.8 Mass (m) [kg] Diameter (D) [m] 0.8 1.0 1.0 D 0.2 Speed (v) [rpm] Speed () [rad /s] Density (p) [kg / m] 0.4 0.6 Kinetic Energy (KE) [J] Diameter (D) [m] 0.8 1.0 ... F Height (H) [m] 0.6 0.9 1.2 (pasted (pasted (pasted (pasted = (PI()/4) * $D4^2* E$3 from E4) from E4) from E4) from E4) (pasted from E4) (pasted from E4) (pasted (pasted (pasted (pasted from E4) from E4) from E4) from E4) (pasted (pasted (pasted (pasted from E4) from E4) from E4) from E4) (pasted (pasted (pasted (pasted from E4) from E4) from E4) from E4) (pasted (pasted (pasted (pasted from E4) from E4) from E4) from E4) (pasted from E4) (pasted from E4) 0.3 E (d) What should be typed into cell E20 that can then be copied through the rest of the third table to calculate the kinetic energies stored in the flywheels? The rotational kinetic energy is given by the formula: KErot=1w = (mr) . E For the cell E20 select the the appropriate expression in Excel. Assume the contents of all the other cells in the required range to be copy-pasted from E20. 15,000 = B2 (2* PI())/60 8,000 0.3 = $B$4* E4 (pasted from E12) (pasted from E12) (pasted from E12) (pasted from E12) E 0.3 F Height (H) [m] 0.9 0.6 1.2 1.5 (pasted (pasted (pasted (pasted from E12) from E12) from E12) from E12) (pasted (pasted (pasted (pasted from E12) from E12) |from E12) from E12) (pasted (pasted (pasted (pasted from E12) from E12) from E12) from E12) (pasted (pasted (pasted (pasted from E12) from E12) |from E12) from E12) (pasted (pasted (pasted (pasted from E12) from E12) from E12) from E12) Height (H) [m] = $E$12* ($D20)^2 * $B$3 = E12* ($D20/2) * $B$3 G G = E12* ($D20/2)^2 * $B$3 = E12* ($D20/2)^2 * $B$3^2 H F = $E$12* ($D20/2)* $B$3 = E12 ($D20/2)^2/$B$3 I H G 0.9 1.2 1.5 0.6 (pasted (pasted (pasted (pasted from E20) from E20) from E20) from E20) (pasted (pasted (pasted from E20) from E20) from E20) (pasted (pasted (pasted from E20) from E20) from E20) (pasted (pasted (pasted from E20) from E20) from E20) (pasted (pasted (pasted from E20) from E20) from E20) H 1