mstreddy
Member
I started using a spiral bound notebook. I divided up into sections for the calibers (cartridges) I was loading. I would include date, bullet brand, type, weight, powder, charge, OAL, and quantity loaded. When working up loads, a note on how it shot.
After filling the section on 9MM, the caliber I load/shoot the most, and having to come back to find if I had loaded all of a certain batch of bullets (manually looking and adding) I decided to move the data to Excel. So, I created a simple spreadsheet with a tab for each caliber. I found a couple of variations here and another site that had some nice formulas and calculations. I borrowed and modified them to suit my needs.
The advantage is that now my spreadsheet is not only a log, but it gives me real time inventory information on the bullets, primers and powder.
I've thought of taking it all into Access or some other DB, but, the Excel file is working pretty well. And I still find Excel better for calculations.
I don't have the computer in the reloading room, but I go sit down after I load a batch and enter the information into the log.
I also place a label on each box/container of ammo I load with the load data -- caliber, bullet type/weight/brand, powder, charge, primer, date and OAL. This is just a handwritten address type label.
After filling the section on 9MM, the caliber I load/shoot the most, and having to come back to find if I had loaded all of a certain batch of bullets (manually looking and adding) I decided to move the data to Excel. So, I created a simple spreadsheet with a tab for each caliber. I found a couple of variations here and another site that had some nice formulas and calculations. I borrowed and modified them to suit my needs.
The advantage is that now my spreadsheet is not only a log, but it gives me real time inventory information on the bullets, primers and powder.
I've thought of taking it all into Access or some other DB, but, the Excel file is working pretty well. And I still find Excel better for calculations.
I don't have the computer in the reloading room, but I go sit down after I load a batch and enter the information into the log.
I also place a label on each box/container of ammo I load with the load data -- caliber, bullet type/weight/brand, powder, charge, primer, date and OAL. This is just a handwritten address type label.