Results 1 to 16 of 16
  1. #1
    Join Date
    Jun 2007
    Posts
    557

    Default excel / spring / stack

    I'm thinking somebody out there probably has an excel sheet to calculate backwards from load numbers to nut adjustment ...

    anybody want to share ? would be nice if it did stacks.

    thanks !

  2. #2
    Join Date
    May 2007
    Location
    Batavia, OH
    Posts
    12,944

    Default

    I probably should have made one, but I always get out the paper and calculator.
    Vado - 2

    Modern Day Wedge Racing

  3. #3
    Join Date
    Oct 2017
    Posts
    1,276

    Default

    Quote Originally Posted by RacerX10 View Post
    I'm thinking somebody out there probably has an excel sheet to calculate backwards from load numbers to nut adjustment ...anybody want to share ? would be nice if it did stacks.thanks !
    To many variables. Not all shocks use the same thread spacing. For instance it's almost 5 turns on ohlins to get the same travel as 2 turns on a afco or Integra. Penske are kinda nice in that it's 10 turns per inch so it's easy math. You mention stacks well stacks are tough because of the staging/ timing. Not much need for a big cheat sheet its just math as long as your using quality springs that stay linear. But really hard to have some generic deal because of the variables in coilover nut travel per turn differences

  4. #4
    Join Date
    Jun 2007
    Posts
    557

    Default

    Quote Originally Posted by Jking24 View Post
    To many variables. Not all shocks use the same thread spacing. For instance it's almost 5 turns on ohlins to get the same travel as 2 turns on a afco or Integra. Penske are kinda nice in that it's 10 turns per inch so it's easy math. You mention stacks well stacks are tough because of the staging/ timing. Not much need for a big cheat sheet its just math as long as your using quality springs that stay linear. But really hard to have some generic deal because of the variables in coilover nut travel per turn differences
    Don't really care about thread pitch on the shock. Just looking to do it by free height / compressed height / target load etc.

    I don't think the stack part will be too much harder .. same kind of thing as a single, you're just doing serial coils (s1 X s2)/(s1 + s2) to a certain point then it's locked out and you're on the single spring.

    I thought somebody would have already had this, and I'm lazy, but I guess it's on me. Will work it out and share when it's ready

  5. #5
    Join Date
    Nov 2014
    Posts
    478

    Default

    Spring rhythm app on play store has exactly what your looking for.

  6. #6
    Join Date
    Oct 2017
    Posts
    1,276

    Default

    Quote Originally Posted by RacerX10 View Post
    Don't really care about thread pitch on the shock. Just looking to do it by free height / compressed height / target load etc.I don't think the stack part will be too much harder .. same kind of thing as a single, you're just doing serial coils (s1 X s2)/(s1 + s2) to a certain point then it's locked out and you're on the single spring.I thought somebody would have already had this, and I'm lazy, but I guess it's on me. Will work it out and share when it's ready
    I guess I just don't see the point. Most setups be it stack or single rate now days use a bump or spring rubbers and it's impossible to have a generic cheat sheet for that. Also if you have to use a tape measure and a chart at the race track. How much more convenient if at all is it then just knowing that 1 turn = x load on your given setup. And as far as that app. Theirs alot of assumptions with it. Not all springs have the exact same free length. Most all springs do not compress at their rated value the first inch. As I stated their are to many variables but feel free to waste for time making a spreadsheet that has no real world relevance.

  7. #7
    Join Date
    Jun 2007
    Posts
    557

    Default

    Quote Originally Posted by Punisher88 View Post
    Spring rhythm app on play store has exactly what your looking for.
    I've seen that. Good idea but I don't like subscription based ... anything

  8. #8
    Join Date
    Jun 2007
    Posts
    557

    Default

    Quote Originally Posted by Jking24 View Post
    I guess I just don't see the point. Most setups be it stack or single rate now days use a bump or spring rubbers and it's impossible to have a generic cheat sheet for that. Also if you have to use a tape measure and a chart at the race track. How much more convenient if at all is it then just knowing that 1 turn = x load on your given setup. And as far as that app. Theirs alot of assumptions with it. Not all springs have the exact same free length. Most all springs do not compress at their rated value the first inch. As I stated their are to many variables but feel free to waste for time making a spreadsheet that has no real world relevance.
    Respectfully disagree .. to whit :

    1 ) the spring rubber just tunes in some direction from a known point. That's an "after the fact" adjustment, and is predictable when I've tested them in a spring smasher. It's going to be a pretty consistent value from the spring rate.

    2 ) It's also super easy to know what a turn is worth on given spring / shock if you want to do it that way.

    3 ) Free length can be known before it's mounted up. Spring compression value is also within a certain percentage of rated value. If it's not in that range, you've got a crap spring or it needs replacing. In any case, you're talking about a few pounds difference in any direction that is out of the tolerance range for any driver to know the difference. Other factors that change on the track (picking up mud / humidity changes / wind blows some other direction) are a larger issue than then a 500 lb spring being 500 or 510 lbs actual.


    As far as value goes, if I can grab up my phone, plug a number in a spreadsheet and have it spit out a new load number from whatever delta in spring height (aka turns on the nut) .. that's pretty (not a nice word)(not a nice word)(not a nice word)(not a nice word) convenient.

    Appreciate your comments / your opinion !
    Last edited by RacerX10; 01-23-2023 at 10:51 AM.

  9. #9
    Join Date
    Jun 2007
    Posts
    557

    Default

    Quote Originally Posted by MasterSbilt_Racer View Post
    I probably should have made one, but I always get out the paper and calculator.
    I got the single spring deal working last night. Just need to confirm what it's spitting out on a smasher and make it a little more user friendly with some gfx

  10. #10
    Join Date
    Nov 2014
    Posts
    478

    Default

    If your only using a single spring and not having to account for a bump stop. I don't even pull the shock off to check anything. I just measure the distance between the changes I made and do the math.

  11. #11
    Join Date
    Jun 2007
    Posts
    557

    Default

    Quote Originally Posted by Punisher88 View Post
    If your only using a single spring and not having to account for a bump stop. I don't even pull the shock off to check anything. I just measure the distance between the changes I made and do the math.
    Entirely possible that I'm looking for a solution for a problem that doesn't exist

    But that would also mean that the "springrithm" app is entirely useless and a bit of a scam ?

    Maybe ....

  12. #12
    Join Date
    May 2007
    Location
    Batavia, OH
    Posts
    12,944

    Default

    Quote Originally Posted by RacerX10 View Post
    Entirely possible that I'm looking for a solution for a problem that doesn't exist

    But that would also mean that the "springrithm" app is entirely useless and a bit of a scam ?

    Maybe ....
    The app is a PT Barnum money maker.
    Vado - 2

    Modern Day Wedge Racing

  13. #13
    Join Date
    Sep 2010
    Posts
    153

    Default

    Is there any way to add a graph system to a MLR EZ Rater?

  14. #14
    Join Date
    May 2007
    Location
    Batavia, OH
    Posts
    12,944

    Default

    Quote Originally Posted by mab475 View Post
    Is there any way to add a graph system to a MLR EZ Rater?
    I can't remember if the linear indicator has a data port on it or not. If not, you need a new linear transducer and data acquisition cards for it and the load cell. I use my computer keyboard for the acquisition.
    Vado - 2

    Modern Day Wedge Racing

  15. #15
    Join Date
    Oct 2017
    Posts
    1,276

    Default

    Quote Originally Posted by mab475 View Post
    Is there any way to add a graph system to a MLR EZ Rater?
    Not exactly the first problem is the dro is not an absolute dro. Basically it can loose its zero point aswell as skip a beat if moved to fast. This can be fixed by upgrading to a absolute dro witch iguage (the brand that comes on the machine) makes a absolute model that is basically a direct replacement for what is their. They have a communication cable that can be bought separately but to my knowledge it can only transmit data statically. Basically you have to push a button to log a point. But the next issue becomes logging the load data. The load cells have a "printer" out put but I believe it's the same scenario you have to push a button to get a data point. So it makes it a little convoluted. Someone pretty tech savy could get it going but I'm not sure how user friendly it would be

  16. #16
    Join Date
    May 2007
    Location
    Batavia, OH
    Posts
    12,944

    Default

    Quote Originally Posted by Jking24 View Post
    Not exactly the first problem is the dro is not an absolute dro. Basically it can loose its zero point aswell as skip a beat if moved to fast. This can be fixed by upgrading to a absolute dro witch iguage (the brand that comes on the machine) makes a absolute model that is basically a direct replacement for what is their. They have a communication cable that can be bought separately but to my knowledge it can only transmit data statically. Basically you have to push a button to log a point. But the next issue becomes logging the load data. The load cells have a "printer" out put but I believe it's the same scenario you have to push a button to get a data point. So it makes it a little convoluted. Someone pretty tech savy could get it going but I'm not sure how user friendly it would be
    The load cell should have an analog mv/V signal, which is what the display uses. You can plot that real time by converting with the appropriate acquisition card. The load cell is just a strain gauge bridge where you excite it with a voltage and you get a mV output that is proportional to the load applied.
    Vado - 2

    Modern Day Wedge Racing

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

All times are GMT -5. The time now is 03:00 PM.


Powered by vBulletin® Version 4.2.0
Copyright © 2023 vBulletin Solutions, Inc. All rights reserved.