Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2018
    Posts
    22

    Default Coilover Load Excel Spreadsheet

    Does anyone have an excel spreadsheet for graphing coil loads they would be willing to share?Thanks

  2. #2
    Join Date
    Jun 2007
    Posts
    3,123

    Default

    Quote Originally Posted by Twenty-Five View Post
    Does anyone have an excel spreadsheet for graphing coil loads they would be willing to share?Thanks
    Are you just talking about a sheet that will create a graph once you have entered the load numbers at specific travel distances?

  3. #3
    Join Date
    Sep 2018
    Posts
    22

    Default

    Yes exactly.

  4. #4
    Join Date
    Nov 2014
    Posts
    488

    Default

    Penske has a good app

  5. #5
    Join Date
    Jun 2007
    Posts
    3,123

    Default

    We can't attach Excel files on 4m and I'm not going to offer to email you what I use or I'm going to get a flood of requests from other people and I'm not running a free consulting business :-)
    But this is super easy to do in Excel.
    Use column A for your travel. Make A1 0.0 and A2 your first increment (0.1), A3 your next increment (0.2), and so on. If you don't want to type these in manually all the way down to 4.0 (or whatever you're going for) there is a trick. After you have the first 3 or 4 entries in, highlight those cells (click and drag until you have them all). Then hover over the little square in the bottom right of the last highlighted cell and your cursor should change to a smaller cross. Then you can click and drag that down all the way to the last number you want (it will display what number you are up to next to your cursor) and it will fill in all the numbers for you.
    In column B, just enter your load numbers at all of the increments in column A that you want to map in your graph.
    The next part is kind of dependent on which version of Excel you are running. But you should be able to go to the Insert tab at the top and find a button that says Recommended Charts. The first couple should be scatter and line. Use either one you want depending on what kind of look you're going for.
    Last edited by Matt49; 04-17-2019 at 10:10 AM.

  6. #6
    Join Date
    May 2007
    Posts
    796

    Default

    It's actually pretty easy and you should be able to find a you tube video to walk you through it

  7. #7
    Join Date
    Sep 2018
    Posts
    22

    Default

    Thanks guys I will have to knock the rust off my excel skills!

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 11:12 AM.


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