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 'Errors and significant figures'

I multiplied the values first without the error limit. Got 19.38. rounded it off to 2 significant figures since the given data has 2 significant figures. So = 19. For error I used the above formula. It comes out about 1.48. Now my question is. Should I write the answer as 19±1.5 (rounding 1.48 to 2 significant figures) OR should I write it as 19±1. So in short, should the error have same number of significant figures as the mean value or should it have the same number of decimal places as...
View full post »
Thread 'A cylinder connected to a hanging mass'

Thread 'A cylinder connected to a hanging mass'

Let's declare that for the cylinder, mass = M = 10 kg Radius = R = 4 m For the wall and the floor, Friction coeff = ##\mu## = 0.5 For the hanging mass, mass = m = 11 kg First, we divide the force according to their respective plane (x and y thing, correct me if I'm wrong) and according to which, cylinder or the hanging mass, they're working on. Force on the hanging mass $$mg - T = ma$$ Force(Cylinder) on y $$N_f + f_w - Mg = 0$$ Force(Cylinder) on x $$T + f_f - N_w = Ma$$ There's also...
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