Some alternate energy technologies, such as wind and solar, produce more energy than needed during peak...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
This image presents a series of questions related to entering formulas in an Excel spreadsheet to perform calculations for a flywheels volume mass and ... View the full answer
Related Book For
Managing Business Ethics Making Ethical Decisions
ISBN: 9781506388595
1st Edition
Authors: Alfred A. Marcus, Timothy J. Hargrave
Posted Date:
Students also viewed these mechanical engineering questions
-
A square matrix is an upper triangular matrix if all elements below the principal diagonal are zero. So a 2 Ã 2 upper triangular matrix has the form where a, b and d are real numbers. Discuss...
-
A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...
-
At December 31, 2018, Landy Products has cash of $24,000, receivables of $18,000, and inventory of $80,000. The companys equipment totals $182,000. Landy owes accounts payable of $22,000 and...
-
Rockwell Company owns a single restaurant which has a cantina primarily to seat patrons while they wait on their tables. This is considering eliminating the cantina and adding more dining tables....
-
A random variable X has the geometric distribution g(x; p) = pq x?1 for x = 1, 2, 3 Show that the moment-generating function of X is and then use Mx(t) to find the mean and variance of the geometric...
-
As a battery is used to charge a capacitor, does the overall charge inside the battery get smaller, get greater, or stay the same?
-
CSB, Inc. has a beta of .765. If the expected market return is 10.5 percent and the risk-free rate is 3.5 percent, what is the appropriate expected rate of return of CSB (using the CAPM)?
-
a) A real estate contract is a contract between parties for the purchase and sale, exchange, or other conveyance of real estate. The sale of land is governed by the laws and practices of the...
-
A maker of a certain brand of low-fat cereal bars claims that their average saturated fat content is 0.5 gram. In a random sample of 8 cereal bars of this brand the saturated fat content was 0.6....
-
If you have a piece of lead (dpb = 11.34 g cm) with a volume of 23.4 cm, what is the mass (in g)?
-
On the earth, an astronaut throws a ball straight upward; it stays in the air for a total time of \(3.0 \mathrm{~s}\) before reaching the ground again. If a ball were to be thrown upward with the...
-
In testing the null hypothesis that p = 0:3 against the alternative that p 0:3, the probability of a type II error is ______ when the true p = 0:4 than when p = 0:6. (1) the same (2) smaller (3)...
-
Suppose that Y is a normally distributed random variable with = 10 and = 2, and X is an independent random variable, also normally distributed with = 5 and = 5. Find: (a) P(Y>12 and X>4) (b) P(Y...
-
In a hypothesis test the p value is 0.043. This means that we can find statistical significance at: (1) both the 0.05 and 0.01 levels (2) the 0.05 but not at the 0.01 level (3) the 0.01 but not at...
-
Refer to Problem 35. If we let E represent the event that a randomly selected American who is 25 years of age or older is employed, we can also obtain the following probabilities from the Census...
-
Consider the random process defines as: X(t)=B cos (2wt+3p), where B and w are constants and o is random variable X(t) can be categorized as: Select one: O a. deterministic O b. none of these O c....
-
Complete the following acid-base reactions: (a) HCCH + NaH
-
Your office furniture company has decided that it wants to make its furniture according to circular economy principles. This means that when customers are done using the furniture, they can return it...
-
Multinational oil company ExxonMobil faced many challenges related to climate change. Climate change is taking place because of the greenhouse effect. When solar radiation passes through the...
-
You have worked together with three other stock brokers in the same company for the past 12 years. The four of you are the best of friends, with strong personal ties going back 30 years; you grew up...
-
A crystal sample of bacteriorhodpsin, a light-sensitive protein found in halobacteria that responds to light energy, has crystal planes separated by 0.20 nm. If a beam of 11 keV x rays illuminates a...
-
A nickel crystals work function is measured to be 5.22 eV at 25C. As the temperature increases by 300C, the work function drops by 50 meV. By how much does this shift the threshold wavelength for...
-
One molecule of ATP provides 0.30 eV when it is used to power cellular processes. Photosynthesis in a typical plant requires 8 photons at 550 nm to produce 1 molecule of ATP. What is the overall...
Study smarter with the SolutionInn App