Answered step by step
Verified Expert Solution
Link Copied!
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.
image text in transcribed
image text in transcribed
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

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

Data And Databases

Authors: Jeff Mapua

1st Edition

1978502257, 978-1978502253

More Books

Students explore these related Databases questions