You are Here: Home >< Physics

# physics equations watch

1. I have to do an excel spread sheet using physics equations, and the last time i did physics was three years ago at GCSE, so i was wondering if any of you could help me out?

The principle is that i am measure the distance/time a golf ball travels after being hit. I have t Second upto 15 in 0.1 intervals. I have X metres which has been worked out with the following:-

X = Vt cos (theta)

V = 45

How ever, i am stuck on working out Y.

The equation is;

Y = Vt sin (theta) - 1/2gt^2

I don't know how to work out my Value. Thus forth cannot complete the formula for the spreadsheet.

Can anyone help?
2. Usually with these you put the data in 3 columns
1st column t with values increasing in 0.1 steps, as you say, up to 15 seconds.
column 2 is x with the formula given and copied down, the value of t is taken from column 1
column 3 is y with the given formula again copied down, value of t from col 1
What is the value of theta? You need that. That's the trajectory angle.
If V is the initial velocity, V and theta need to be typed into another 2 cells (D1 and E1, say) on the sheet and the reference to those cells used in the appropriate formulas.
You also need to put in a value for g=9.81
The formula in the cell (C1) for y (in column 3) would look something like
=D1*A1*Sin(E1) - 0.5*9.81*A1^2
where D1 is the cell where you have stored V and E1 is the cell where you have theta in radians
A1 is the cell in the first column with the value of t
3. (Original post by Stonebridge)
Usually with these you put the data in 3 columns
1st column t with values increasing in 0.1 steps, as you say, up to 15 seconds.
column 2 is x with the formula given and copied down, the value of t is taken from column 1
column 3 is y with the given formula again copied down, value of t from col 1
What is the value of theta? You need that. That's the trajectory angle.
If V is the initial velocity, V and theta need to be typed into another 2 cells (D1 and E1, say) on the sheet and the reference to those cells used in the appropriate formulas.
You also need to put in a value for g=9.81
The formula in the cell (C1) for y (in column 3) would look something like
=D1*A1*Sin(E1) - 0.5*9.81*A1^2
where D1 is the cell where you have stored V and E1 is the cell where you have theta in radians
A1 is the cell in the first column with the value of t
I agree with all this, but in my version of excel, I would use "+SIN(e1)" instead of just "SIN(e1)",and of course, select from Column B to the RHS and copy down from Row 2 to the bottom

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: September 30, 2011
Today on TSR

### TSR Pub Quiz 2018 - Anime

Start time will be 6 PM tonight

### University open days

Wed, 21 Nov '18
• Buckinghamshire New University
Wed, 21 Nov '18
• Heriot-Watt University