Below Are The Instructions And Statement Of Problem All Work Is To Be Done On The Excel Spreadsheet This Spreadsheet I 1 (66.28 KiB) Viewed 34 times
Below Are The Instructions And Statement Of Problem All Work Is To Be Done On The Excel Spreadsheet This Spreadsheet I 2 (34.94 KiB) Viewed 34 times
Below are the instructions and statement of problem. All work is to be done on the EXCEL spreadsheet. This spreadsheet is to be submitted for grading via an upload. You will have to save the spreadsheet under a different name. Introduction: In this activity you will use EXCEL to calculate how much energy is stored in flywheels of various sizes. The speed of the wheels is given in revolutions per minutes [RPM]. You will need to change these to radians per seconds. The speed in RPM is entered in B2 and the density of the wheel is entered in B4. A formula to convert the speed from RPM to radian per second is to be entered in B3. To simplify the calculations, the stored energy was calculated in 3 steps. The first table calculates the volumes of the flywheels. The second table calculate the masses of the flywheels. The third table use these masses to determine the stored rotational kinetic energy. Note: Changing the values in B2 and or B4 will cause appropriate values to be automatically recalculated. 1. In B3 type in the following formula: You must click on the cell B3 then enter the following in the formula bar at the top of the page: =B2∗(2∗PI0⋅60) Then hit "Enter." 2. What must be typed in E4 that can be copied throughout the rest of the first table to calculate the flywheel volumes? All wheels are homogeneous cylinders. The volume of a cylinder is * h. Where, h, is the height and, R, is the radius. 3. What should be copied in cell El2 that can then be copied through the rest of the table 2 to calculate the masses of the flywheels. M=r* V. Where r is the density and V the volume? 4. What should be copied in cellE20 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:, where I=, is the rotational inertia. A modified formula for rotational kinetic energy is given by KE=. 5.5. What should be typed in cell E25 that can then be copied through row 25 to determine the average kinetic energy at each height? 6. What should be typed in cell E26 to determine the difference between the maximum kinetic energy and 800 times the minimum kinetic energy given in the table?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!