1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Trouble Logging In or Staying Logged In?

    CLEAR YOUR BROWSER COOKIES! More info about this can be found here. If you still have trouble after clearing your browser's cookies and cache, reply to that thread and tell us what browser you're using and what device you're using.

Blueprinting/Engine Assembling Spreadsheet

Posted by jakelandry, Aug 10, 2018

Please Support Morrison Fabrications
  1. jakelandry

    jakelandry Proven Member

    765
    69
    Joined Oct 13, 2009
    Minden, Louisiana
    I finally broke down and bought all the PROPER tools to blueprint an engine which led me to recording some measurements in excel. Long story short I kept adding measurements and basic formulas till I realized I pretty much had everything needed for a basic bottom end rebuild. Being a firm believer in checklists, I realized this could be used as a list for someone who is concerned they may miss something or maybe they don't know what to measure at all and this is a quick summary vs googling and going through ten forum posts.

    There could be 10,000 spreadsheets like this floating around for all I know and I could be wasting my time but I figured I would drop by here and offer it up to the general public in the event someone wants to save it or print it out and use it next time they build a motor. It is not pretty. It is not smart. It is not anything special period. Hell its not even printer friendly. Its just some basic charts that are cleaner than writing on the nearest piece of paper and using a calculator on your phone with greasy fingers.

    If there seems to be a general interest in using this, I am willing to clean it up and add anything anyone more experienced than me feels needs to be added. I haven't built an engine in a few years so I just started making this off memory and got to this point. Right now I'd like to see a few things listed below but I'm also lazy to the extent that I am aware all of this is floating around the internet and I'm not currently looking for it.

    Places to record bolt torques.
    List of torque specs JUST FOR FASTENERS RELATIVE TO THE ENGINE
    Bolt stretch
    Part number list for all the small parts you cant remember like wrist pin locks or Maybe comprehensive list of all gaskets/Misc parts required

    Like I said if this thread perks up with some interest I'll go further into detail explaining everything and making it clearer. Just let me know what yall think.
     

    Log in/Register to remove ads

    Attached Files:

    My DSM:
    1995 Mitsubishi Eclipse GSX

    11.410 @ 125.490 MPH
    Loading...
    ec17pse, Mitsubishiown and Mello like this.
  2. Biddy420

    Biddy420 Proven Member

    129
    11
    Joined Jun 17, 2017
    Naperville, Illinois
    54E7FA59-D9C8-4E56-8D9E-5148CD84888D.jpeg This is very close to what my machine shop uses nice spread sheet man. (Also I know my ptw clearance is really tight I’m running forged Mahle Motorsport pistons that require that tight of a fit)
     
    My DSM:
    Loading...
  3. jakelandry

    jakelandry Proven Member

    765
    69
    Joined Oct 13, 2009
    Minden, Louisiana
    That's incredibly nice compared to what my shop gives LOL. The shop I use builds some of the best late model dirt track motors for people around the nation and they blueprinted my last block on 3 pages of scratch paper with phone numbers and other notes on them.
     
    My DSM:
    1995 Mitsubishi Eclipse GSX

    11.410 @ 125.490 MPH
    Loading...
  4. Biddy420

    Biddy420 Proven Member

    129
    11
    Joined Jun 17, 2017
    Naperville, Illinois
    Apex is prob best machine shop in my state I guess bill has even done machine work for boostin from what I’ve been told. And let me say they were amazing knew far more about 4g63’s then any other shop ive ever been too. Downfall was block took about 3 months and about a month on the head.
     
    My DSM:
    Loading...
  5. arrowhead

    arrowhead Proven Member

    543
    28
    Joined Apr 19, 2011
    miami, Florida
    I use something similar for different motors, AERA has something nice to go by.
    Wonderful effort on your part, I am sure it will be very useful to a lot of people, maybe I will replace mine with yours since it is more complete.
    Thanks for your contribution.
    Mandy
     
    My DSM:
    1998 Eagle Talon TSi

    Road Race Build

    16g   manual
    Loading...
  6. jakelandry

    jakelandry Proven Member

    765
    69
    Joined Oct 13, 2009
    Minden, Louisiana
    Well i'm glad to see a few people interested. I'm going to gradually work on it as I have free time at work over the next month or so to clean it up some. Will post updated versions as I improve it.
     
    My DSM:
    1995 Mitsubishi Eclipse GSX

    11.410 @ 125.490 MPH
    Loading...
  7. 1990TSIAWDTALON

    1990TSIAWDTALON Moderator

    3,051
    955
    Joined Nov 14, 2013
    Independence, Kansas
    I like the macro programming. I write them too, and although mine is a bit different, they do the same thing. Good job on the little things that others might not appreciate!
     
    My DSM:
    1992 Eagle Talon TSi AWD

    Street Build

    14b   automatic
    1990 Eagle Talon TSi AWD

    13.620 @ 108.460 MPH
    1990 Eagle Talon TSi AWD

    13.612 @ 107.760 MPH
    Loading...
    jakelandry likes this.
  8. jakelandry

    jakelandry Proven Member

    765
    69
    Joined Oct 13, 2009
    Minden, Louisiana
    Thanks man. I actually know how to make userforms and i've written a few basic programs in VBA, I just didn't feel like taking this that far when its all basic stuff. The more I mess with this the more I'd like to make a one stop, everything you need in one spreadsheet ordeal when assembling an engine though. So far I've added a list of taps needed to tap out all the threads on the block and a few of the main torque specs pulled from the torque spec thread on here. The main problem is I'm not an artistic individual. I can make excel do the math, I just cant make it pretty LOL.
     
    My DSM:
    1995 Mitsubishi Eclipse GSX

    11.410 @ 125.490 MPH
    Loading...

Share This Page

Loading...


Log in/Register to remove ads

Support Vendors who Support the DSM Community
Ace Race Parts Archer Fabrication Best Used Tires Boostin Performance ECM Tuning ExtremePSI Feal Suspension Fuel Injector Clinic Jacks Transmissions Jackson Auto Machine JNZ Tuning Kiggly Racing Magnus Motorsports Miller Import Parts Morrison Fabrications OHM Racing RockAuto SouthBay Fuel Injectors STM Tuned Tire Rack VR Speed Factory White Shed Speed