Turn on thread page Beta
    • Thread Starter
    Offline

    8
    ReputationRep:
    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?
    Offline

    10
    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
    Offline

    13
    ReputationRep:
    (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
 
 
 
Reply
Submit reply
Turn on thread page Beta
Updated: September 30, 2011

University open days

  • University of Bradford
    All faculties Undergraduate
    Wed, 21 Nov '18
  • Buckinghamshire New University
    All Faculties Postgraduate
    Wed, 21 Nov '18
  • Heriot-Watt University
    All Schools Postgraduate
    Wed, 21 Nov '18
Poll
Black Friday: Yay or Nay?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.