Excel Worksheets

Discussion in 'ELR, Ballistics & Bullets Board' started by dmoran, Jan 1, 2016.

  1. dmoran

    dmoran Gold $$ Contributor

    Joined:
    Nov 25, 2004
    Messages:
    2,671
    Over the years I have made many Excel calculators, solvers, and miscellaneous spreadsheets.
    Below is a list, followed by the Attached Files of a few that I will share with you all:

    --------------------------------------------------------------------------------

    - Ballistic Comparison: added 1/1/2016

    + Cartridge Laboratory v2015: New - 1/22/2015

    - Velocity Prediction: added 1/1/2016

    - Barrel weight calculator: added 1/1/2016

    - MOA Ranging Solver: added 1/1/2016


    - Seating Depth Calculator: added 1/5/2016 <> Updated 1/22/2016

    - Rifle weight log: added 1/5/2016

    -
    Recoil calculator: added 1/5/2016

    - Bullet RPM Calculator: added 1/1/2016

    - MOA Solutions: added 1/1/2016

    - Speed Calc: added 1/1/2016

    -
    Machine Calc: added 1/1/2016

    - Altitude Pressure: added 1/1/2016

    +
    Die Adjustment Calculator: New - 1/24/2015

    - Target Dimensions: added 1/1/2016


    Select and Click on the Attached Files below to Download
    Donovan Moran
     

    Attached Files:

    Last edited: Jan 25, 2016
  2. dmoran

    dmoran Gold $$ Contributor

    Joined:
    Nov 25, 2004
    Messages:
    2,671
    More Excel Attachments below:
     

    Attached Files:

    Last edited: Jan 22, 2016
  3. MNFinn

    MNFinn Erik on the Range

    Joined:
    May 10, 2012
    Messages:
    502
    please do share them. I had some fun last night with ones you did already share
     
    halfmoanut likes this.
  4. milanuk

    milanuk Team Savage Gold $$ Contributor

    Joined:
    Nov 23, 2004
    Messages:
    2,370
  5. eric32

    eric32 Shooting when I can Gold $$ Contributor

    Joined:
    Nov 25, 2011
    Messages:
    877
    ill keep an o_O out for more. i really liked the excel sheets
     
  6. BartsBullets

    BartsBullets Gold $$ Contributor

    Joined:
    Mar 5, 2015
    Messages:
    651
    Thank Donovan! That's Awesome!

    Bart
     
  7. Jet

    Jet Rich Jette Gold $$ Contributor

    Joined:
    Apr 23, 2012
    Messages:
    689
    Thanks Donovan. Great tools.

    Rich
     
  8. milanuk

    milanuk Team Savage Gold $$ Contributor

    Joined:
    Nov 23, 2004
    Messages:
    2,370
    Hah. Saw this comic today... figured it fit this thread just about *perfect* ;)
     
    UltraBR30 and Mulligan like this.
  9. Marksman63

    Marksman63

    Joined:
    May 12, 2014
    Messages:
    268
    Great! Thanks
     
  10. Outrider27

    Outrider27 Gold $$ Contributor

    Joined:
    Mar 24, 2010
    Messages:
    686
    Thanks; we're going to have fun with several of them.

    Mike
     
  11. no 23

    no 23

    Joined:
    Mar 24, 2012
    Messages:
    15
    Thank you for the excel sheets Donovan already been a good help for me to choose a reamer...

    But i'd like to make one suggestion for version 1,1 of the Bullet seating depth calculator for boat tail bullets... can you add one box for boat-tail length and make that subtract from the bullet length so people like me who would want to seat boat tail bullets so that the bearing surface doesn't go down through the throat can use it without manually subtracting the boat tail.

    This box could be optional... ;)

    You could then also add another result tap that would be named something like Bering surface seating depth.

    Let me know if you understand what i'm talking about, if not i'll try to make myself more clear...

    Thanks again for your effort!
     
    dmoran likes this.
  12. dmoran

    dmoran Gold $$ Contributor

    Joined:
    Nov 25, 2004
    Messages:
    2,671
    Stefan (no 23) -

    I updated the Seating Depth Calc workbook with a second worksheet (additional Tab).
    This sheet calculates the amount of bullet seated, to both the total amount and the amount of shank/bearing only. (Attachment Above)

    Edit: Added what I call my "Cartridge Laboratory" (Attachment Above), which draws the bullet and its placement in the case, to a complete cartridge schematic. It's one of my nerdier ones !.!.!

    Good idea for the Calc..... Thanks
    Donovan

    ---------------------------------------------------------------------------------------------------

    Added 1 New - 1/22/2016 <> See original post and attached files above.

    ----------------------------------------------------------------------------------------------------
     
    Last edited: Jan 27, 2016
    UltraBR30 and Marksman63 like this.
  13. tom

    tom Gold $$ Contributor

    Joined:
    Mar 10, 2009
    Messages:
    2,079
    Sucking up should help up your "likes" total lol

    Tom
     
    dmoran likes this.
  14. dmoran

    dmoran Gold $$ Contributor

    Joined:
    Nov 25, 2004
    Messages:
    2,671
    ^^^^ Sounds like jealousy to me... try to stay ahead of LTard in your counts !.!.!
    D
     
    Last edited: Jan 23, 2016
    UltraBR30 and tom like this.
  15. tom

    tom Gold $$ Contributor

    Joined:
    Mar 10, 2009
    Messages:
    2,079
    Nice!
     
  16. dmoran

    dmoran Gold $$ Contributor

    Joined:
    Nov 25, 2004
    Messages:
    2,671
    --------------------------------------------------------------------------------------------------------

    Adding 1 New - 1/24/2016 <> Die Adjustment Calculator <> See "More Excel Attachments" above

    --------------------------------------------------------------------------------------------------------
     
    UltraBR30 likes this.
  17. dmoran

    dmoran Gold $$ Contributor

    Joined:
    Nov 25, 2004
    Messages:
    2,671
    --------------------------------------------------------------------------------------------------------

    Update - 2/21/2016 <> Target Dimensions <> Attached Below

    • F-Class / F-TR <> Score Target Dimensions
    • IBS-600/1000 <> Target Dimensions
     

    Attached Files:

    Last edited: Feb 21, 2016
    UltraBR30 likes this.
  18. dmoran

    dmoran Gold $$ Contributor

    Joined:
    Nov 25, 2004
    Messages:
    2,671
    --------------------------------------------------------------------------------------------------------

    Adding 1 New - 2/22/2016 <> Cartridge Efficiency <> Attached Below

    --------------------------------------------------------------------------------------------------------
     

    Attached Files:

    UltraBR30 likes this.
  19. dmoran

    dmoran Gold $$ Contributor

    Joined:
    Nov 25, 2004
    Messages:
    2,671
    --------------------------------------------------------------------------------------------------------

    Adding 1 New - 3/17/2016 <> Bolt-Face Specs <> Attached Below

    --------------------------------------------------------------------------------------------------------
     

    Attached Files:

    UltraBR30 likes this.
  20. 1980 Harley

    1980 Harley

    Joined:
    Oct 7, 2014
    Messages:
    1
    Donovan, thanks for all your hard work. Now I can enjoy the fruits of someone else's labor.
     
    dmoran likes this.

Share This Page