Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is an excel question. I need the input statements to enter in excel for each column. Problem 2 Many alterna and solar, produce more
This is an excel question. I need the input statements to enter in excel for each column.
Problem 2 Many alterna 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). Therefore, ways are being explored to store the excess energy produced so that energy levels do not drop during down times. As a CO-OP student at FEATS (Flywheels for Energy from Alternative Techniques Storage) LLC, you have been asked to explore the idea of using a large flywheel to store the energy produced as kinetic energy by spinning the flywheel with the excess energy and using the flywheel to turn a generator during time of energy deficits. tive energy technologies, such as wind The Excel worksheet labeled Problem 2 in the Homework 5 workbook has been set up to aid you in your analysis of different flywheel configurations. Follow the steps below to complete your analysis: Add an Excel formula to cell C4 that converts the rotational speed from rotations per minute (RPM) to radians per second (rad/s) Complete Table 1 by calculating the volume of the flywheel (i.e. a cylinder) for each diameter and height combination Complete Table 2 by using the density value from cell C5 and the volumes in Table 1 to determine the Mass of each possible flywheel 4 Complete Table 3 by computing the kinetic energy for each flywheel combination using the formula shown below: s Complete Table 4 by adding Excel commands to do the following: If the KE for the flywheel configuration is at most 1*10 J, indicate that the flywheel fails by displaying FAIL and causing the background to be Red If the KE for the flywheel configuration is between 1*10 J and 1 10 J, indicate that the flywheel is acceptable by displaying OK and causing the background to be Yellow If the KE for the flywheel configuration is at least 1*10 J, indicate that the flywheel is excellent by displaying GOOD and causing the background to be Green Step 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