Embedded Files
If you lay your spreadsheet out as shown in the image, the formulas will be
Cell C5, convert to m/s by dividing by 3.6, so type
=C4/3.6
cell C8 does the calculation for vfinal = mv / (m + M)
which in the spreadsheet will be
=B8*$C$5/(B8 + $C$3)
Notice how the references to the car's mass (B8) are relative references so they will change as you fill down the table, but the references to the trucks mass and initial speed of the car are absolute references ($C$5, $C$3) so they stay fixed.
cell D8 does the calculation impulse = mΔv
which in the spreadsheet will be
=B8*(C8-$C$5)
Enter these formulas and fill down til you have a car's mass of 5000 kg
Page updated
Google Sites
Report abuse