Create new cell result based on a linear change in another cell's value

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



 1ciVqAaufxXdVKWE8Rxz5Kq8AKPYJqbVlPEcc SoVUGwRWeCqo1pb1FHHso1QIrNAXqNaW9RRx7KNUCKzQF6jWlvUUceyjVAis0Beo1pb1FHHso1QIrNAXqNaW9RRx7KNUCKzQF6jWlvUUceyjVEi1Qf4POYUu1ydNyYcAAAAASUVORK5CYII=
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,223,908
Messages
6,175,306
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top