SOLVED v0.33 spreadsheet spring problems

Discussion in 'Car Modding' started by thoraxe, Jun 16, 2018.

  1. thoraxe

    thoraxe Registered

    Joined:
    Dec 25, 2016
    Messages:
    149
    Likes Received:
    15
    I am using v0.33 of the spreadsheet with LibreOffice 5.4.7.2

    On the "spring" tab when I look at the dropdown for the rear spring (B34) it only has "0" as an option. If I copy the cell from B10 to B34 I can properly select a dropdown value.

    Also, in North America, it's quite common to have springs in "k", which is usually short for kg/mm. In my case my SC300 has 17k front and 13k rear springs. My guess is that I should be using the conversion value kgf/mm = 9806.65

    A 17k spring here would correlate to a N/m rate of 166713.05. The spreadsheet has pretty big gaps in values. It goes from 164000 to 168000. This represents 16.72 - 17.13k. Is there a reason the spreadsheet doesn't take arbitrary and/or decimal values?
     
  2. thoraxe

    thoraxe Registered

    Joined:
    Dec 25, 2016
    Messages:
    149
    Likes Received:
    15
    I think I'm answering my own question:

    Starting on Row 65 there are some spring configurations.

    • You can change the unit to kgf/mm
    • You can change the min/max values
    • You can change the steps
    The values in the dropdown (B34/B10) don't end up getting updated to the stepped values, though. They're still showing the calculated SI N/m values, which is not fun.
     

Share This Page