Reference

Equations & Excel Reference

Every equation used in the manual, grouped by topic, with the spreadsheet formulas that implement them.

Units & constants

g = 9.81 m/s²Gravitational acceleration (acts downward: −9.81 m/s² with up positive)
kg = lb / 2.2046Mass conversion
m = ft × 0.3048 ; m = in × 0.0254Length conversions
rad = deg / 57.3 ; 180° = π radAngle conversion
s = ms / 1000 ; Δt = 1 / fpsTime
W = m·gWeight (N)

Vectors & trigonometry Week 1

x = r cos θ ; y = r sin θComponents (θ CCW from +x)
r = √(x² + y²)Magnitude
θ = tan⁻¹(y/x) + quadrant correctionDirection (II: 180° − φ; III: 180° + φ; IV: 360° − φ)
R = (ΣX, ΣY)Vector addition by components

Linear kinematics Weeks 2, 4

v = (p_f − p_i) / ΔtAverage velocity
a = (v_f − v_i) / ΔtAverage acceleration
Δp = ∫ v dt ; Δv = ∫ a dtAreas under curves
v_f = v_i + a·tConstant-acceleration equations
v_f² = v_i² + 2a·Δy
y_f = y_i + v_i·t + ½a·t²

Projectiles Week 5

x = v_x·tHorizontal position (v_x constant)
y = y₀ + v_y0·t − ½g·t²Vertical position
v_y0 = √(2g(y_max − y₀))Initial vertical velocity from peak height
t_up = v_y0/g ; t_down = √(2·y_max/g)Rise and fall times (landing at y = 0)
v₀ = √(v_x² + v_y0²) ; θ = tan⁻¹(v_y0/v_x)Launch speed and angle
R = v₀² sin(2θ)/gRange when launch and landing heights are equal

Angular kinematics Weeks 3, 12

ω = (θ_f − θ_i) / ΔtAngular velocity
α = (ω_f − ω_i) / ΔtAngular acceleration
s = r·θ ; v = r·ω ; a_t = r·αLinear–angular links (θ, ω, α in radians)
a_r = v²/r = r·ω²Radial (centripetal) acceleration
Knee flexion = 180° − included angleKinovea angle conversion
ROM = θ_max − θ_minRange of motion
Asymmetry % = (R − L)/((R + L)/2) × 100Left–right comparison

Linear kinetics & friction Week 6

ΣF = m·a ; ΣFx = m·aₓ ; ΣFy = m·a_yNewton's second law
F_down = mg sin θ ; F_into = mg cos θWeight on an incline
F_friction ≤ μs·F_normal ; F_k = μk·F_normalStatic and kinetic friction
μs = tan θ_slipCoefficient of static friction from slip angle

Impulse & momentum Week 7

p = m·vMomentum
J = F̄·Δt = m·v_f − m·v_iImpulse–momentum
F̄_GRF = J/Δt + m·gAverage vertical GRF
v_to = g·t_flight/2 ; h = g·t_flight²/8Jump takeoff velocity and height from flight time
m₁u₁ + m₂u₂ = m₁v₁ + m₂v₂Conservation of momentum (any collision)
m_a·u_a + m_b·u_b = (m_a + m_b)·vPerfectly inelastic collision (bodies move together)
e = (v₂ − v₁)/(u₁ − u₂)Coefficient of restitution (1 = elastic, 0 = perfectly inelastic)
v₁ = (m₁u₁ + m₂u₂ − m₂e(u₁ − u₂))/(m₁ + m₂)Final velocities for any e
v₂ = (m₁u₁ + m₂u₂ + m₁e(u₁ − u₂))/(m₁ + m₂)

Work, energy & power Week 8

W = F·dMechanical work (J)
KE = ½mv² ; PE = mghKinetic and gravitational potential energy
W = ΔKE + ΔPEWork–energy principle
P = W/Δt = F·vPower (W)
VO₂ ≈ (P/eff × 60 / 20.9)/massNet ml O₂·kg⁻¹·min⁻¹ (eff ≈ 0.20–0.25)

Torque & center of mass Week 9

τ = F·d⊥ = F·r·sin θTorque (CCW +)
Στ = I·α ; static: ΣF = 0, Στ = 0Angular Newton's 2nd law; equilibrium
F_e·d_e = F_r·d_r ; MA = d_e/d_rLever balance; mechanical advantage
x_cm = Σ(mᵢxᵢ)/ΣmᵢSegmental COM (same for y)
x_cm = (S − S₀)·L / WReaction board
±|Rₓ|·l ± |R_y|·l = I_cm·αAngular kinetics about the COM (free-body / mass-acceleration diagrams)

Signal processing Weeks 2, 3, 10, 11

vᵢ ≈ (yᵢ₊₁ − yᵢ)/(tᵢ₊₁ − tᵢ)Forward difference
vᵢ ≈ (yᵢ₊₁ − yᵢ₋₁)/(tᵢ₊₁ − tᵢ₋₁)Central difference (less noisy)
ȳᵢ = mean(yᵢ₋ₖ … yᵢ₊ₖ)Moving-average smoothing
RMS = √(Σx²/N)Root-mean-square amplitude (sway, EMG)
vᵢ = vᵢ₋₁ + aᵢ·ΔtCumulative integration
Sway area = π·SD_ML·SD_APEllipse approximation (1 SD; a 95% confidence ellipse is about 6× larger)
%MVC = EMG / EMG_max × 100EMG normalization

Excel function cheat sheet

TaskFormulaNotes
Sine/cosine of degrees=SIN(RADIANS(A2))Excel trig uses radians
Angle from components (0–360°)=MOD(DEGREES(ATAN2(x,y)),360)ATAN2 takes x first
Inverse tangent (first quadrant)=DEGREES(ATAN(B2/A2))
Square root, power=SQRT(A2) ; =A2^2
Finite difference=(B3-B2)/(A3-A2)Fill down
Moving average (5 points)=AVERAGE(B2:B6)Relative refs, fill down
Moving RMS (50 points)=SQRT(SUMSQ(B2:B51)/50)Week 10
Max, min, range=MAX(B:B)-MIN(B:B)ROM
Mean ± SD=AVERAGE(r) ; =STDEV.S(r)Sample SD
Mean by group=AVERAGEIFS(values,group,"CMJ")Condition summaries
Time at the maximum=INDEX(A:A,MATCH(MAX(B:B),B:B,0))Find event times
Absolute reference=$B$1*C2Constants (mass, g)
π=PI()
Correlation / R²=RSQ(y,x)Or trendline "Display R²"

Chart recipe

  1. Select the x column then the y column (Ctrl-click to select non-adjacent columns).
  2. Insert → Scatter → Scatter with Smooth Lines (time series) or Markers only (relationships).
  3. Chart Elements (+): Axis Titles (with units), Chart Title; remove the legend for single series.
  4. Format Axis → Bounds to align time axes across stacked charts.
  5. Error bars: Chart Elements → Error Bars → More Options → Custom → select your SD cells.

Sources

  • Urone, P. P., & Hinrichs, R. (2022). College physics 2e. OpenStax. openstax.org. Vectors, kinematics, projectiles, Newton's laws, friction, momentum, work–energy, torque.
  • Winter, D. A. (2009). Biomechanics and motor control of human movement (4th ed.). Wiley. Finite differences, smoothing, segmental center of mass.
  • Linthorne, N. P. (2001). Analysis of standing vertical jumps using a force platform. American Journal of Physics, 69(11), 1198–1204. doi.org/10.1119/1.1397460. Jump height and takeoff velocity from flight time.
  • Gaesser, G. A., & Brooks, G. A. (1975). Muscular efficiency during steady-rate exercise: Effects of speed and work rate. Journal of Applied Physiology, 38(6), 1132–1139. doi.org/10.1152/jappl.1975.38.6.1132. Muscular efficiency.
  • Each week's page lists the references for that lab.