Kinetic Energy Equations in MS Excel

Click For Summary

Homework Help Overview

The discussion revolves around the use of Microsoft Excel to calculate various kinetic energy values, including initial and final kinetic energies for two masses, as well as total kinetic energy and its percentage. Participants are exploring how to formulate these calculations within Excel.

Discussion Character

  • Exploratory, Problem interpretation, Assumption checking

Approaches and Questions Raised

  • Participants are questioning the appropriate Excel formulas needed to calculate kinetic energy values based on the relevant physics equations. There is a focus on understanding how to input these formulas correctly in the spreadsheet.

Discussion Status

The discussion is ongoing, with some participants providing guidance on checking existing formulas in the spreadsheet and suggesting looking up textbook equations for kinetic energy. There is a recognition of the need for clarity on what specific formulas should be used.

Contextual Notes

There are mentions of a non-Excel format file being attached and the need for the original spreadsheet to verify formulas. Participants are also noting that vague attempts at solutions are not sufficient for the discussion.

Makali
Messages
14
Reaction score
1

Homework Statement


I am having trouble with Microsoft Excel formulas to obtain the correct data for Kinetic Energy 2 initial, KE1 final, KE2f, KEi, KEf, total KE and total KE%

Homework Equations


Microsoft office uses equations such as =(A2+B2) and I need to determine what is the appropriate formulas to use to complete the chart.

The Attempt at a Solution


Any formulas that I have tried were not successful. If I could have guidance on what formulas to use it would help a lot.
 

Attachments

  • Physics Table.png
    Physics Table.png
    26.5 KB · Views: 984
Physics news on Phys.org
Hello,

What is this about ? Do we have to guess ?

Microsoft office does not 'use' anything. YOU type in formulas based on the relevant equations you list under 2.
'no joy ' does not count as an attempt in PF
 
  • Like
Likes   Reactions: berkeman
The file you attached is not in Excel format.
Were you given the actual spreadsheet., if so you can check the result cells for
the formulas used.
As an example in cell H1 there must be a formula such as: =B1*D1
 
Makali said:

Homework Equations


Microsoft office uses equations such as =(A2+B2) and I need to determine what is the appropriate formulas to use to complete the chart.

Columns L to O are for the kinetic energy of mass 1 and 2 before the collision (eg I=initially) and after (f=finally). Column L (the KE of mass 1 initially) has already been completed. I wonder what equation they used to complete that column :-)

Failing that look in your textbook for the equation for the kinetic energy of a mass m moving at velocity v.
 

Similar threads

  • · Replies 21 ·
Replies
21
Views
5K
  • · Replies 9 ·
Replies
9
Views
2K
Replies
5
Views
1K
  • · Replies 7 ·
Replies
7
Views
1K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 6 ·
Replies
6
Views
2K
  • · Replies 12 ·
Replies
12
Views
13K
Replies
8
Views
4K
  • · Replies 54 ·
2
Replies
54
Views
11K