kelleybill
New Member
- Joined
- Dec 19, 2018
- Messages
- 1
Am working on a basic sports training spreadsheet that demonstrates a change in weight (body weight) or power (measured on a pad on the floor,sensing jumping force) results in a change in speed. Below are actual measurements. The manually entered Power and Weight cells mathematically determine the Power/lb cell. The Power/lb to speed ratio cell is the mathematical result of the manually input 40Y (yard) value divided into the Power/lb value.
I would like to demonstrate to an athlete that changes in weight and/or power result in a direct change in speed. One or both of those cells' values would be adjusted to modify the Power/lb cell.
How do I set up the 40Y cell to result in a linear change in speed against a linear change in the Power/Lb Speed ratio cell? I would use that top row as my base math reference using a rule of a Speed Ratio of 5.0 results in a 40Y(ard) of 5.46
https://drive.google.com/file/d/1Tvcw_XV6WMZvm5tBrqAx7RiTbCVHQdUu/view?usp=sharing
I would like to demonstrate to an athlete that changes in weight and/or power result in a direct change in speed. One or both of those cells' values would be adjusted to modify the Power/lb cell.
How do I set up the 40Y cell to result in a linear change in speed against a linear change in the Power/Lb Speed ratio cell? I would use that top row as my base math reference using a rule of a Speed Ratio of 5.0 results in a 40Y(ard) of 5.46
https://drive.google.com/file/d/1Tvcw_XV6WMZvm5tBrqAx7RiTbCVHQdUu/view?usp=sharing