I need some computer/spreadsheet help

Discussion in 'TMO General Discussion Forum' started by blacksheep-1, Mar 19, 2019.

  1. blacksheep-1

    blacksheep-1 TMO Addict

    Messages:
    1,658
    Likes Received:
    830
    Joined:
    Mar 12, 2013
    I used to have a spread sheet (I think it was in Excel) that would allow me to do several different cars, after inputting the base tire pressures on a car, I could change the temp inputs and it would change the pressures on each car based on the delta I used. I could keep track of several cars that way, and even print out the results during the day. My computer got hacked, I had to reload everything and lost the spreadsheet, not a massive loss because I keep everything on paper, but I have to do all the calculations for all the cars manually. At the runoffs I was handling temps and pressures for as many as 9 cars at once, so this was a great tool for me.
    I really would like to have another one, it needed some tweaks, and there were some things that needed to be upgraded based on experience.
    Others may find it useful as well, and I don't care if you sell it, eat it, smoke it or give it away once it's developed.
    I'm just tired of ****ing around with computers

    Here's a pic of the old printed sheet

    [​IMG]
     
  2. AboveAvgJoe5

    AboveAvgJoe5 TMO Intermediate

    Messages:
    25
    Likes Received:
    7
    Joined:
    Feb 17, 2016
    Hi Rob,

    I'm a big time lurker on the site, not a huge poster. I live in excel, primarily focused on financial modeling. Shoot me a message and I'm sure I could whip something up for you in a few minutes.

    Joe
     
  3. ArizonaBOSS

    ArizonaBOSS Because racecar. Moderator

    Messages:
    8,127
    Likes Received:
    1,724
    Joined:
    Dec 6, 2010
    Location:
    Arizona, USA
    That should be a walk in the park.
     
  4. blacksheep-1

    blacksheep-1 TMO Addict

    Messages:
    1,658
    Likes Received:
    830
    Joined:
    Mar 12, 2013
    yeah well it's not for me..all my excel stuff I left behind when I left FD...including my cheat sheets. I used to program videos in Liquid so, it's not that I can't do it, it's just that the importing, exporting sometimes it works, sometimes it doesn't, sometimes it won't import completely, I'm just tired of dealing with it.
     
    Last edited: Mar 19, 2019
    Grant 302 likes this.
  5. Grant 302

    Grant 302 OPM Spent: $587,402 Moderator

    Messages:
    6,572
    Likes Received:
    1,609
    Joined:
    Nov 23, 2011
    Location:
    In the OC
    Rob-

    So the only inputs are the 3 cells at the top, and the 4 blue 'target' cells for both cars? Pink/purple cells are all outputs?

    Targets are based off the 'nominal temp' and slope from the 'pressure factor' like you've taught us to chart, right?
     
    blacksheep-1 likes this.
  6. blacksheep-1

    blacksheep-1 TMO Addict

    Messages:
    1,658
    Likes Received:
    830
    Joined:
    Mar 12, 2013
    the difference is that on most race days the temp was about 85 degrees, so I thought that since that was the case, I would make 85 degrees the standard and correct from there, that way, whatever delta I decided on, (that depends on a lot like brand, compound and other stuff) that it would be less of a reach.
    As an example 85 degrees corrected to 95 degrees as opposed to 70 degrees corrected to 95 degrees. Seemed to make sense, but it didn't work out in real life.
    But the answer to your question is yes, although the targets have to be inputted, you have to start someplace. .
     
    Last edited: Mar 19, 2019
  7. blacksheep-1

    blacksheep-1 TMO Addict

    Messages:
    1,658
    Likes Received:
    830
    Joined:
    Mar 12, 2013
    That 15.6 is pretty intense..lol, don't try that on BBS wheels
     
  8. Grant 302

    Grant 302 OPM Spent: $587,402 Moderator

    Messages:
    6,572
    Likes Received:
    1,609
    Joined:
    Nov 23, 2011
    Location:
    In the OC
    Done. Used 'numbers' on a mac and exported to an Excel format.
    pressure xls.png
    PM me an email addy and check if it works.
     
    TymeSlayer and VoodooBoss like this.
  9. blacksheep-1

    blacksheep-1 TMO Addict

    Messages:
    1,658
    Likes Received:
    830
    Joined:
    Mar 12, 2013
    To clarify, these are all cold pressures derived from hot pressures, which gives us new cold targets. the problem is that when the temperature changes, you lose your cold targets and have to compensate for that..and track temp...I really haven't figured out how to deal with track temp exactly, I still swag those, but I'm pretty good at it.
    Which is why I set all the tires in the AM when everything is the same temp.
     
  10. Grant 302

    Grant 302 OPM Spent: $587,402 Moderator

    Messages:
    6,572
    Likes Received:
    1,609
    Joined:
    Nov 23, 2011
    Location:
    In the OC
    Understood. I'd use my charts the same way to set pressures the night before.

    So you'd want another adjustment for the difference in expected hot temps with varying track temps? Like how much pressure to pull for hotter than normal conditions?

    Message me your email address and I'll send you the Excel file.
     

Share This Page