We Helped With This Physics Assignment: Have A Similar One?

Linear Kinetics in Excel

Linear Kinetics

—   For the data set “GRF of 2 Jumpers” assume:

—   Body mass is 85 kg

—   Body starts with an initial velocity of zero

—   Body starts in a squat and leaves the ground when the COM rises 0.31m from the starting position

—   Determine:

—   Takeoff velocity (when leaving the ground)

—   Peak force for GRF and effective force (∑Fy)

—   Average force for GRF and effective force (∑Fy)

—   Jump height

—   Graph (put both jumpers on one graph, be sure to label!):

—   GRF vs. time

—   Position vs. time

—   Velocity vs. time

—   Acceleration vs. time

Set Up the Data

—  Download the file ‘GRF of 2 Jumpers’ from Moodle

—  Open with Excel

—  Insert a Column between Columns A and B

—  Repeat to insert a second column

—  Label Column B ‘Mass’

—  Label Column C ‘Weight’

—  Column D should be ‘GRF Jumper A’

—  Column E should be ‘GRF Jumper B’

Set Up the Data

—  You were given body mass for both jumpers=85 kg

—  Type this into column C and drag down

—  Calculate body weight and fill column D with this number

Set Up the Data

—  Add two columns between columns D and E

Determine acceleration from GRF data

—Σ F_y= ma_y —Σ F_y=GRF_y+F_g

—ay=GRFmy+Fg

Determine acceleration from GRF data

—Σ F_y= ma_y —Σ F_y=GRF_y+F_g

—ay=GRFmy+Fg

Determine Velocity from

Acceleration

—  𝑣_𝑓 =𝑎𝑡_𝑓 −𝑡_𝑖 +𝑣_𝑖

—  Add another blank column after your acceleration data

Determine Velocity from

Acceleration

—  𝑣_𝑓 =𝑎𝑡_𝑓 −𝑡_𝑖 +𝑣_𝑖

—  Add another blank column after your acceleration data

Determine Position from Velocity

—  𝑝_𝑓 = 𝑣𝑡_𝑓 −𝑡_𝑖 +𝑝_𝑖

—  Add another blank column after your velocity data

Determine Position from Velocity

— 

—  Add another blank column after your velocity data

Determine

—  Takeoff velocity (when leaving the ground)

—  Body starts in a squat and leaves the ground when the COM rises 0.31m from the starting position

—  Peak force for GRF and effective force (∑Fy)

—  Average force for GRF and effective force (∑Fy)

—  Jump Height

—  v_i=0

—  v_f²=v_i²+2a∆p

v2

—∆p=

19.62

Determine

—  Takeoff velocity (when leaving the ground)

—  Body starts in a squat and leaves the ground when the COM rises 0.31m from the starting position

—  2.75 m/s   

—  Peak force for GRF and effective force (∑Fy)

—  Peak GRF= 3214.57

—  Average force for GRF and effective force (∑Fy)

—  Average GRF= 2002.60

—  Jump Height

—  v_i=0

—  v_f²=v_i²+2a∆p

v2

—∆p=

19.62

Linear Kinetics

—  Determine:

—  Takeoff velocity (when leaving the ground)

—  Peak force for GRF and effective force (∑Fy)

—  Average force for GRF and effective force (∑Fy)

—  Jump height

—  Graph (put both jumpers on one graph, be sure to label!):

—  GRF vs. time

—  Position vs. time

—  Velocity vs. time

—  Acceleration vs. time

Assignment Description