Solving Equations for Track Graph on Microsoft Excel

AI Thread Summary
The discussion revolves around finding equations for a 2D track graph in Microsoft Excel, focusing on variables like height, distance, and centripetal acceleration. The user is struggling with several equations, particularly for Initial Energy (IE) without and with centripetal acceleration, and seeks clarification on how to derive these equations. There is confusion about the relationship between total energy, kinetic energy, and how to incorporate centripetal acceleration into the calculations. Additionally, the user questions how to determine the radius for track segments and how to calculate speed with centripetal acceleration. Overall, the user is looking for guidance on correcting their equations and understanding the underlying physics concepts.
HawKMX2004
Messages
36
Reaction score
0
I am having some problems with equations for a problem. The problem isn't really a question, it's more of finding equations to make something work. Basically, It is a graph on Microsoft Excel, that resembles a 2D track. The track has variable points that you can change, to increase height, distance, Coefficient of Friction, Centripetal Acceleration, Force Centripetal, etc. I have some equations figured out, but I am stuck on a few. Here is what i have and what i need, any help is appreciated. (remember there are no numbers, just equations)

The first is IE ( Initial Energy ) without Centripetal Acceleration added. I have no idea where to even start with this equation, but i assume that Initial Energy is the greatest kinetic Energy, minus the Kinetic Energy at the point you are? I need a lot of help there. Final Equation: TE - KE

The second is IE of Individual Track segment with Centripetal Acceleration added. For this, I assume that it is once again the Total Energy minus the Kinetic Energy at that point plus ( Velocity^2 / Radius ) I don't know exactly how to get the radius though ( is it half of the track segment?? :confused: ) Final Equation: TE - KE + [v^2/(1/2)(TrackSegmentLength)]

The third is Speed with Centripetal Acceleration. For this I think I have it, but since i have Kinetic Energy as a Given, I would use the Equation v=SquareRoot(KE/.5m)

The fourth is Distance Traveled, for this, wouldn't it be the new track segment plus all of the previous track segments?? :confused: Final Equation: New Track + All Previous Track


That is all i have, please correct me on equations if I'm wrong, or if you need clarification id be glad to give it to you.
 
Physics news on Phys.org
What do u mean by centripetal acceleration added? when the centripetal acceleration is added, it shouldn't change the speed and only change the direction? no?
 
Last edited by a moderator:
yes, Think of a track that goes up and down at random points...thats what its saying...so what is the speed with Centripetal acceleration added..I am still very confused..because none of my equations are working :confused: :cry:
 
the speed should still be the same as the initial speed.
 
But what about Initial energy and speed? how do I get them without having Total Energy?
 

Thread 'Rolling without slipping on a curved surface'

Kindly see the attached pdf. My attempt to solve it, is in it. I'm wondering if my solution is right. My idea is this: At any point of time, the ball may be assumed to be at an incline which is at an angle of θ(kindly see both the pics in the pdf file). The value of θ will continuously change and so will the value of friction. I'm not able to figure out, why my solution is wrong, if it is wrong .
View full post »
Thread 'Voltmeter readings for this circuit with switches'

Thread 'Voltmeter readings for this circuit with switches'

TL;DR Summary: I would like to know the voltmeter readings on the two resistors separately in the picture in the following cases , When one of the keys is closed When both of them are opened (Knowing that the battery has negligible internal resistance) My thoughts for the first case , one of them must be 12 volt while the other is 0 The second case we'll I think both voltmeter readings should be 12 volt since they are both parallel to the battery and they involve the key within what the...
View full post »

Similar threads

Kinetic Energy Equations in MS Excel
Replies
3
Views
5K
Kinetic Energy of a Cylinder Rolling Without Slipping
Replies
21
Views
4K
Minimum h for Car to Remain on Track Around Loop
Replies
6
Views
2K
Starting height of marble rolling around a loop the loop
Replies
12
Views
12K
Vertical circle in a pendulum ride -- tension force acting on the gondola
Replies
7
Views
2K
Graphing Elastic Potential Energy
Replies
10
Views
2K
Magnitude of force of a disk on a circular track
Replies
6
Views
3K
Question Regarding Circular Motion and Normal Forces
Replies
2
Views
3K
Calculating Max Tension, Final Angle for Swinging on Rope Over Lake
Replies
43
Views
4K
Finding the normal at the bottom of a curved track
Replies
10
Views
2K

Hot Threads

Recent Insights

Back
Top