JakkeJakobsen
Board Regular
- Joined
- Sep 10, 2014
- Messages
- 94
So, I am working with a sheet that has a certain number in each column KL-LM, only if the number in JX is different from the one in the row above. So JX3 is 1850, that means KL to LM will have this number times a factor. In JX43 there is 1450. Now as you can see in the screenshot, KF3 is 6607, and KF43 is 4028. Now, what I want to happen is a linear reduction from KF3 to KF43, so basically there are 38 rows between that should have 6607-4028/rownumber+3 (or there abouts).
But I am unsure how to do this in formulas. This is 100% dynamic, meaning it doesn't have to be 1850 and 1450 in JX, and it doesn't have to be JX3 and JX43 (well it must be JX3 as it is the start). Further down this also happens, JX64 is 1350, so KF64 is 3750.
Here is how the sheet looks like.
The reason I am doing this is to use Excel to "draw" an image of a bowling lane, to show where the oil on the lane is put down. Since this is done with a machine with a high rpm brush, it gets dragged down the lane and smoothed out, so where the machine puts the oil down isn't equal to where the oil is when the lane is done being conditioned with said oil and machine.
This is how the sheet looks like with the raw data put in.
This is how the oil looks like on the lanes in professional bowling as seen on TV. Us mortals don't have access to the blue additive, so for us it is invisible. That is why sheets like the one I made are used to show where the oil is put down, so the players can adjust accordingly. Quick intro: Longer oil means you have to play straighter, shorter means more violent hook, but the width of the pattern also decides where you play, a wide short pattern forces players to play down the edge, while a more narrow pattern lets players play deeper in the lane, hooking it more. The difficulty of a pattern is the ratio between the center and the edge of the lane, sideways. Lengthwise most patterns are around 1/5 to 1/3 in ratio, 3 times more in the start than the end of the pattern.
Cheers for any help!
But I am unsure how to do this in formulas. This is 100% dynamic, meaning it doesn't have to be 1850 and 1450 in JX, and it doesn't have to be JX3 and JX43 (well it must be JX3 as it is the start). Further down this also happens, JX64 is 1350, so KF64 is 3750.
Here is how the sheet looks like.
The reason I am doing this is to use Excel to "draw" an image of a bowling lane, to show where the oil on the lane is put down. Since this is done with a machine with a high rpm brush, it gets dragged down the lane and smoothed out, so where the machine puts the oil down isn't equal to where the oil is when the lane is done being conditioned with said oil and machine.
This is how the sheet looks like with the raw data put in.
This is how the oil looks like on the lanes in professional bowling as seen on TV. Us mortals don't have access to the blue additive, so for us it is invisible. That is why sheets like the one I made are used to show where the oil is put down, so the players can adjust accordingly. Quick intro: Longer oil means you have to play straighter, shorter means more violent hook, but the width of the pattern also decides where you play, a wide short pattern forces players to play down the edge, while a more narrow pattern lets players play deeper in the lane, hooking it more. The difficulty of a pattern is the ratio between the center and the edge of the lane, sideways. Lengthwise most patterns are around 1/5 to 1/3 in ratio, 3 times more in the start than the end of the pattern.
Cheers for any help!
