Your reloading / shooting logbook

Discussion in 'Reloading Forum (All Calibers)' started by hicap40, Jul 8, 2019.

  1. Shooter13

    Shooter13 Gold $$ Contributor

    Joined:
    Sep 23, 2016
    Messages:
    431
    Could I get a copy of that? I've been looking and just dread making it as I'm not great with excel. Send to crum.frankie@gmail.com if you are so inclined, thanks,
     
  2. jimbo88mm

    jimbo88mm

    Joined:
    Jan 9, 2008
    Messages:
    328
    Several years ago I made a relational database with Access to keep my reloading data. I even started a thread and uploaded a blank copy of it to this forum. It's probably still out there.

    It started out mostly as a fun project while I was learning how to use Access. I still use it today.... although it turned out to be the last thing I ever created with Access.
     
  3. Jammer Six

    Jammer Six

    Joined:
    Dec 4, 2015
    Messages:
    461
    I did the same thing with Filemaker! (We run Macs.)

    It was a truly relational problem, and I learned a lot about relationships and data models!
     
    McGraw likes this.
  4. Joe R

    Joe R Silver $$ Contributor

    Joined:
    Feb 4, 2013
    Messages:
    1,878
    I am and F-Open shooter and do extensive testing. I don't have a reloading log, that seems too narrow a definition for what I do. I'm interested in documenting my experiments to improve my shooting scores. I call my journal a Range Report and in it I document any changes to my brass prep and reloading data as well as changes in equipment used to shoot. I keep one on each one of my rifles.

    Good luck,

    Joe

    Capture.JPG
     
    jepp2 and Mulligan like this.
  5. xswanted

    xswanted Gold $$ Contributor

    Joined:
    May 11, 2012
    Messages:
    994
    I use a notebook for each rifle.

    I keep track from round 1 and notate things like load development and round count. General info on the gun is kept as well suck as a scope change or stock change.

    I also record atmospheric info each time I shoot as well as actual adjustments needed versus what my ballistics program gives me.

    It’s not as organized as a spreadsheet but it works well for me.
     
  6. AckleymanII

    AckleymanII Silver $$ Contributor

    Joined:
    May 11, 2006
    Messages:
    2,585
    I use a three ring binder. Every load tried is documented on just std note book paper. Groups are cut off the target and glued on the notebook paper.

    Several things have become critical to keep track of:

    COal of the bullet to the lands when new
    COal of the current loads tried-distance from lands
    bushing sizes used
    Primers make a difference
    Wind directions that day, wind speed, and temperature
    brand of cases
    case prep notes, full length size, neck size, shoulder bump, brand of dies used if I have more than one brand

    This information can be transferred to any other form you want
     
  7. ballisticxlr

    ballisticxlr

    Joined:
    Sep 24, 2018
    Messages:
    151
    jepp2 and hicap40 like this.
  8. hicap40

    hicap40 Gold $$ Contributor

    Joined:
    Jan 27, 2010
    Messages:
    36
    that is COOL
     
  9. Texas10

    Texas10 Gold $$ Contributor

    Joined:
    Dec 10, 2016
    Messages:
    1,413
    What would be really cool, and probably the next great tool to come along, would be a mini-weather station on the range near your wind flags (or maybe a component of a wind flag) that would report temp, wind direction, speed, etc at the moment of the shot which would then correlate with the POI as recorded in real time by a target cam and a shot detector near the barrel (to differentiate from other shooters). Result: a comprehensive atmospheric model in real time and its effect on shot placement, downloadable to a spread sheet with ballistic calculator modeling. Oh, and maybe include a strain gage on the barrel also to record pressure, barrel time, etc.

    Imagine all of that wrapped up in a chronograph that sits on the bench next to you while shooting.
     
    rwj likes this.
  10. rwj

    rwj Gold $$ Contributor

    Joined:
    Jul 16, 2017
    Messages:
    571
    All that’s missing is a guidance feedback loop to the projectile:D!
     
  11. Joe R

    Joe R Silver $$ Contributor

    Joined:
    Feb 4, 2013
    Messages:
    1,878
    It seems to me that your app needs to be integrated into the Shot Marker. I only use it for 600 and 1K. I can see just fine at 300 yards.

    The Shot Marker (electronic target system) that generates a lot more data that I know what to do with. It can all be imported into an Excel spreadsheet. Currently, Doug Skogman (dskogman here) uses visual basic to create a match report of all the shooter's scores, scatter graphs of all the shots, etc...
     
    dmoran likes this.
  12. ballisticxlr

    ballisticxlr

    Joined:
    Sep 24, 2018
    Messages:
    151
    A bunch of years back I created an electronic device and software which used an Arduino and Raspberry Pi to run a weapon integrated sensor system including a primitive but surprisingly effective visible laser interferometry device to measure downrange mirage, an integrated wind speed sensor (which was buggy as hell), temp sensors, angle & motion sensors, magnetometer and other stuff to get environmental data and a spin-on chronograph (it looked a bit like a tiny suppressor) to get MV data. It would store record data when triggered by sensing the blast overpressure event in the chronograph module. The user could then input hit or miss and an angular measure of where the shot landed compared to POA. The statistics package then analyzed the data and would give the shooter a hit probability for subsequent shots. Each shot added to the data and refined the next prediction. It included a strain gauge which I never really got to work correctly. It generally worked well for an R&D model but the I ended the project for a lot of reasons only some of which were technical.
     
    Joe R likes this.
  13. Davey Boy

    Davey Boy

    Joined:
    Dec 13, 2016
    Messages:
    146
    Wow now that is a serious spreadsheet, kudos to you for sharing it.
    Website and review of the Spartan cleaner were great reading.
    Thank you
     
  14. ballisticxlr

    ballisticxlr

    Joined:
    Sep 24, 2018
    Messages:
    151
    Thanks very much! It's really nice to get feedback. If you think of things that can be usefully added or enhanced shoot an email to ballisticxlr at gmail and I'll do what I can.
     
  15. Metal God

    Metal God

    Joined:
    Dec 9, 2017
    Messages:
    137
    Pen and paper then three ring binder .

    My data sheet is this (both sides ) for a total of 4 data entry's

    [​IMG]

    I then use these targets at 100 and 200yds

    [​IMG]

    They are both placed in a corresponding binder labeled for a specific firearm or type of firearms . Like , AR load data , Handgun Load data . There is an index and or tabs on the pages to separate calibers or powders etc depending on the data book . Makes for reasonably quick referencing .

    I'm thinking of stream lining the data log . In most cases I don't need 4 different entry's when doing load development per paper . Things like Bullet and type , Powder , cases , COAL , Primers , Distance of target nd a few others things only need to be mentioned once per sheet of paper . I then can have individual notes for each charge tested .

    This is what my ammo box generally will look like or close to it

    [​IMG]
     
    foxguy likes this.
  16. ballisticxlr

    ballisticxlr

    Joined:
    Sep 24, 2018
    Messages:
    151
    You've got logging down pat. What about analytics?
     
  17. Metal God

    Metal God

    Joined:
    Dec 9, 2017
    Messages:
    137
    Not sure who that's directed at but I'll admit my analytics although antiquate are lacking some . I do like some of those programs I see guys using that analyze the group size . I've never researched them enough to even know where to start though .
     
  18. Jammer Six

    Jammer Six

    Joined:
    Dec 4, 2015
    Messages:
    461
  19. bloc

    bloc

    Joined:
    May 24, 2014
    Messages:
    195
    I use FMP too. Though I once created a relational DB with it, for my reloading records/shooting results I simply use it as a flat file.

    IMO, there is a little bit of a learning curve to setting up a Flat File db, but it's much easier than building a relational db if you're new to dbs.

    I feel FMP has several advantages over Excel (which I used extensively for other purposes back in the day).

    1) I created and use pull-down menus in most of my fields. What that means is that every one of my fields will have exactly the same entry style and data for each item. To me, that's huge. (I can add items - say a new powder - to a pull-down menu easy as pie.)

    For example, I avoid missing data on searches because my entry terms are consistent for each item. (When I create a record, I always enter H 4895, never H4895 or H-4895.)

    2) I can import a scan of my group for each record. It's very nice to have a picture right next to the group size.

    3) I can search quickly and efficiently using a whole variety of operators (<, >, ≤, ≥, range, date, etc.) in whichever search fields I choose.

    4) Like Excel, I can enter formulas in fields (I convert "inches and distance" to MOA).

    Just my way of doing things.
     
  20. rardoin

    rardoin Silver $$ Contributor

    Joined:
    May 13, 2013
    Messages:
    2,320
    Sinclair published an excellent reloading log book in a spiral bound form. I made photocopies on medium cardstock printed my charge weight test targets on the same. I kept the target and the associated log together in a 3 ring binder. Alas, Sinclair no longer sells the logbook. I have a JPEG file that I used for printing it but I fear I would violate copyright laws if posted on a public forum. If you can find a copy it is very useful.

    Robin
     
    18trapper likes this.

Share This Page