Quantcast

Keeping track of recipes.

Discussion in 'Handloading and Reloading' started by OrangeCat, Jul 23, 2019.

  1. Kaldor

    Kaldor Member

    Joined:
    Feb 25, 2015
    Messages:
    834
    Google Drive spreadsheet for me that is synced to my home desktop in case the internet goes down.

    I track
    Bullet, powder, primer, OAL, distance from lands, SD, ES, velocity, accuracy, test loads tried, and probably a couple of more things depending on caliber
     
    OrangeCat likes this.
  2. ArchAngelCD

    ArchAngelCD Member

    Joined:
    Nov 25, 2006
    Messages:
    25,833
    Location:
    Northeast PA, USA
    I have 3 binders from long ago that I still add things to at times. When I get a sheet of data from a hard copy source I still put it in the binders. I have hard copies of data from the powder manufactures and bullet manufacturers load data sites in a binder too.

    These days I also use a spread sheet to store most of my data and test results. I'm a little embarrassed I don't keep all the information many of you do. I have a sheet for each type of cartridge like 30-30 or 38 Special but not separate pages for each load. I guess I should keep more information.

    I have columns for:
    Load ID number
    Bullet manufacturer, Bullet weight and type, Bullet diameter
    Case maker, Case trim length
    Primer
    Powder ID, Powder charge
    COAL
    The recorded AV if I run them over a chrono
    Temperature
    Accuracy notes (not in the order, wrote them as I recalled them lol)
     
    OrangeCat likes this.
  3. LiveLife

    LiveLife Member

    Joined:
    Jan 10, 2010
    Messages:
    21,128
    Location:
    Northwest Coast
    Same here.

    Use of Chromebook is proliferating at our house due to low cost and files are easy to access anywhere from the cloud.

    In many ways, THR has become my default backup repository of loads I have developed that are readily accessible by smart phone at the range (Yes, I get 4G LTE signals where I shoot and even miles out to the sea when fishing - Ain't technology wonderful? :D)
     
    OrangeCat and Kaldor like this.
  4. Stew0576

    Stew0576 Addicted

    Joined:
    Mar 25, 2018
    Messages:
    424
    Location:
    Southern tier ny
    Here is a good example of what I do

    KIMG0170.JPG
     
    gotboostvr and OrangeCat like this.
  5. OrangeCat

    OrangeCat Member

    Joined:
    Mar 24, 2019
    Messages:
    227
    I assume that the marks on the right are put on the actual cartridge to keep track of which is which, or just the box you put them in?
     
  6. Stew0576

    Stew0576 Addicted

    Joined:
    Mar 25, 2018
    Messages:
    424
    Location:
    Southern tier ny
    On the base of the cartridge with a sharpie
     
    Jack Ryan likes this.
  7. Stew0576

    Stew0576 Addicted

    Joined:
    Mar 25, 2018
    Messages:
    424
    Location:
    Southern tier ny
  8. OrangeCat

    OrangeCat Member

    Joined:
    Mar 24, 2019
    Messages:
    227
    Cool that's what I thought it was.
    Thanks for clarifying.
     
  9. NR53

    NR53 Member

    Joined:
    Jul 10, 2017
    Messages:
    57
    Location:
    Missouri
  10. kmw1954

    kmw1954 Member

    Joined:
    Jun 24, 2018
    Messages:
    1,030
    Location:
    SE Wisconsin
    I use these and it's working very well. Each load gets a page with the Bullet make, size weight and makeup, Powder charge weight, Primer, OAL, brass case used and how many made and the date loaded. Then subsequent loading of the same load get listed below in order with number loaded, brass used and the date, this way I can track the number of times I have loaded this load. I then reserve the back side for notes and comments on the load.

    https://www.bing.com/videos/search?...295BE421468127C6E433295BE42146812&FORM=VDQVAP

    https://www.quill.com/cardinal-3-ho..._N&gclid=CN3P5vKcz-MCFR2OxQId3qkIvQ&gclsrc=ds

    The subject dividers are used to separate calibers.
     
    OrangeCat likes this.
  11. Chuck R.

    Chuck R. Member

    Joined:
    Jan 23, 2005
    Messages:
    2,455
    Location:
    Leavenworth, KS
    I've gone to a spreadsheet per gun.

    Lately for the last couple rifles I've been using the OCW method for load development. I ended up putting the charge weight formulas onto a spreadsheet to calculate the increments. Then it just seemed natural to record the rest of the data on the sheet. Before I knew it I had added the COAL tests to the mix and started importing the chronograph spreadsheets from my Labradar.

    So each rifle has it's own spreadsheet with multiple tabs covering loads and chrono data.
     
    OrangeCat and Nature Boy like this.
  12. ohihunter2014

    ohihunter2014 Member

    Joined:
    Jul 2, 2015
    Messages:
    5,754
    Location:
    Ohio
    I had to get away from the notecards. I got on this kick where I wanted to try a bunch of different powders, bullets, and primers because I started loading when you couldn't find anything. I now use a word document that I printed that has OAL with the comparator, bullet, BC, how far from lands, charge, primer, case and notes such as bla bla bla was too hot or this didn't shoot so well. I also started storing it on my computer. When I do a load workup I put a notecard in the box with the OAL, all the charges, primer, etc. When I shoot 5 shot groups and if it shoots bad it gets a sad face. If it shoots decent it gets a meh, face and shoots really good it gets a smiley face. I also record small videos of the target and say the charge so I have a backup incase the paper gets destroyed.
     
    OrangeCat likes this.
  13. Nature Boy

    Nature Boy Member

    Joined:
    Apr 21, 2015
    Messages:
    4,461
    I’ve started making my notes specific to the gun and not the caliber. (As I see @Chuck R. is doing)

    So in my log it’s:

    A tab for the gun

    Load specific data
    - bullet, powder charge, case, primer, CBTO/distance to the lands, fps, ES, SD
    - Load development targets

    General gun info
    - Round count on barrel
    - Distance to lands (for tracking throat erosion and tying back to CBTO)
     
    OrangeCat and Chuck R. like this.
  14. Fyrstyk

    Fyrstyk Member

    Joined:
    May 31, 2019
    Messages:
    170
    Location:
    Central CT
    Ditto for me Nature boy. Every gun is an individual. I have 2 .222's, and they all like a different load and/or bullet.
     
    OrangeCat likes this.
  15. ArchAngelCD

    ArchAngelCD Member

    Joined:
    Nov 25, 2006
    Messages:
    25,833
    Location:
    Northeast PA, USA
    I used different color markers and color in only the primers so that when I decap the marks are gone. You can have many marks without any chance of confusion. Don't forger, no mark on the primer is actually another choice for a mark lol.
     
  16. Steve in NC

    Steve in NC Member

    Joined:
    Aug 7, 2011
    Messages:
    86
    Location:
    North Carolina
    I have a pretty complex set of spreadsheets that are all linked to each other in various ways with formulas and VB code. I have 1 spreadsheet that has all my loading data going back as far as 20yrs now. I have tons more data in my old paper manuals I kept for each gun. Still entering in old data on rainy days.

    Then I have individual spreadsheets for rifle, pistol, or shotgun data all linked back to my master loading database with worksheets for rifle, pistol, and shotgun data. Each spreadsheet is designed drastically different. For rifles I usually load for all out accuracy and low volume as most of my rifles are custom single shot bolt guns with wildcat chambers. So I tract number of times cases are fired, neck turned diameters etc. But pistol is all bulk loaded and made to fire in any pistol I own for that caliber. None of my pistol ammo is made for a specific pistol. Then of course shotgun loading is completely different with the wading and spacers added in and wgt/size of the shot varying, etc.
    But other things I built into these individual spreadsheets is when I fire my reloaded rounds I keep track of which guns they were fired in etc. That way I can keep track of round count per gun within reason and various other means of needed info including inventory control for when I need more primers or powder. The inventory spreadsheet that contains all of the loading data can report on how many rounds I have left in bulk loaded ammo for pistols or shotguns, things like that. Nothing on the internet gave me anything close to what I was looking for, so I've built it all myself over several years.
    And the nice thing is that whenever I load rifle, pistol, or shotgun ammo I print out labels like jmorris does (use Avery labelsl from Staples or the like) with all data that is applicable including 1 of X data for shotgun and pistol ammo if I box it up. Those labels are on everything I have loaded. I assign my own Lot# every time I load ammo also. So that ammo loaded yesterday for 9mm isn't mixed with ammo loaded say last fall for 9mm also.

    But as great as this sounds.... you still need to use your head and double check. Computers/formuals can mess things up once in awhile. Always double check your data before loading. I've never personally had a problem, but I'm a programmer by trade and yes things can happen even with your best effort to put in proper checks and balances into your designed system.

    Steve
     
    OrangeCat likes this.
  17. Fyrstyk

    Fyrstyk Member

    Joined:
    May 31, 2019
    Messages:
    170
    Location:
    Central CT
    Wow, Steve in NC, that is quite a system. I'm guessing you are some sort of programer. As for me, I am a dinosaur qhen it comes to computers, I am envious of your system, but I guess I will stick to good old pen and paper for my reloading records.
     
    Stew0576 likes this.
  18. 2011redrider

    2011redrider Member

    Joined:
    May 3, 2014
    Messages:
    421
    Location:
    Central California
    I have been using this one from loaddata.com for about 2 yrs now and it works well.
     

    Attached Files:

    the Black Spot, NR53 and OrangeCat like this.
  19. .308 Norma

    .308 Norma Member

    Joined:
    Jun 6, 2016
    Messages:
    1,999
    Location:
    SE Idaho
    When I find a load I really like (or one I really don't like) I write the load down on an index card, along with a note about what I liked or disliked about it, and put the index card in the die box.:)
     
    Condor, Jack Ryan and OrangeCat like this.
  20. OrangeCat

    OrangeCat Member

    Joined:
    Mar 24, 2019
    Messages:
    227
    I do like all the suggestions to put the records with the relevant dies
     
    .308 Norma likes this.
  21. enine

    enine Member

    Joined:
    Jan 5, 2013
    Messages:
    192
    Location:
    Ohio
    Spreadsheet (LibreOffice, not Excel). But I also print out 4x6 'recipe' cards for the bench.
     
    OrangeCat likes this.
  22. Walkalong

    Walkalong Moderator Staff Member

    Joined:
    Nov 20, 2006
    Messages:
    60,035
    Location:
    Alabama
    Yep, ever load up 10 each of two, three, or four powders with the same bullet and then spilled them? Or everything the same but different primers? I have, so I started marking them.
    .40 S&W Test Loads - 49, 51, 52, & 53.JPG
    Yep, like the ones on the far right. :)
     
    OrangeCat and cfullgraf like this.
  23. peels

    peels Member

    Joined:
    May 22, 2011
    Messages:
    89
    Yikes! I have not considered what I would do if I spilled the finished rounds after boxing them...I think I would have ended redoing them. :confused:

    I might have to consider marking the rounds....
     
    Walkalong likes this.
  24. Walkalong

    Walkalong Moderator Staff Member

    Joined:
    Nov 20, 2006
    Messages:
    60,035
    Location:
    Alabama
    That is what I did, no choice really. o_O
     
  25. 748

    748 Member

    Joined:
    Feb 24, 2006
    Messages:
    774
    Location:
    clovis, NM
    I put it on the box, bag, sack, ziplock, wooden crate I dump the finished product in.
    At a minimum I put bullet weight make model and weigh, propellant with charge weight, primer make model type.

    I'll do other things like if it's boxed up peel the label off the bullet box and tape it on the ammo box. Put some empty primer pack skins in with bulk packed ammo.

    Otherwise it's hand written in the manual.
     
    OrangeCat likes this.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice