Loading Data and Range Results on Computer

  • 821 Views
  • Last Post 01 April 2022
Millelacs posted this 04 January 2022

Anyone keep their loading data and range results on a computer?

 

There has to be a better way than recording in a book, and then paging through the book to see what you've tried that did or did not work.

Attached Files

Order By: Standard | Newest | Votes
RicinYakima posted this 04 January 2022

Not if you have been doing it for 40 years. 

Attached Files

  • Liked by
  • Maven
  • Glenn R. Latham
Bud Hyett posted this 04 January 2022

I've been working on an ACCESS database that records the attributes of the Technical Sheet. Also, I'll add tables to record .22 LR matches which are a different breed. This is a project when I have little to do which is rare. And in line with Ric's comment, I'll baseline the loads from the time I finish the database.

I did this once before, but the first one was limited in scope and data, it was not useful. The main benefit will be the ability to download EXCEL spreadsheets for analysis and then using PivotTables to compare selected attributes in relation to each other. 

 When I retired, Boeing was introducing the concept of "Big Data" and I thought of spending another few years. EXCEL spreadsheets and PivotTables greatly aid these analyses.  However, I had an attack of common sense and retired.

Farm boy from Illinois, living in the magical Pacific Northwest

Attached Files

  • Liked by
  • RicinYakima
Wm Cook posted this 04 January 2022

I used a computer for 30 years. Every target goes in a three ring binder and everything from group size to bullet lube goes in a database. Let’s me slice and dice it maybe 20 different ways. I’m always looking for an angle I haven’t tried to shrink the groups.

Not so much on by jacketed 6mm PPC. Same lot of powder, same lot of primers, same lot of brass same lot of bullets through multiple barrels. Barrels lose their edge pretty quick.

Cast accuracy has lots more variables than jacketed, so everything goes on a spreadsheet. Bill.

Attached Files

  • Liked by
  • RicinYakima
  • Bud Hyett
Squid Boy posted this 04 January 2022

I keep a folder for every gun I own. It has everything in it including purchase receipts and anything special like molds I might have bought just for that gun. Plus, every target, Quick Load sheet and chrono data that matches up. The target has all the shooting data written on it. The info is easy to assess because it is in chronological order. It's all in a two drawer filing cabinet in alphabetical order according to make. I find it very helpful to have the target, load and chronograph data all in one spot. Hard to save all that to a computer unless you scan it all in. That's my two cents worth, Squid Boy  

"Squid Pro Quo"

Attached Files

  • Liked by
  • Bud Hyett
Boschloper posted this 05 January 2022

I have been using an Excel spreadsheet for 25+ years. I have a tab for each caliber and I fill in a row for each box of bullets I load. I have columns for the bullet used (every batch cast gets a lot number with all the data recorded on a seperate spreadsheet), primer, powder type and charge, and the case (each box is numbered). In additional columns I record data from when the box is fired.  For the calibers that I have more than one gun for, I have a column for which one was used.

Yes you can call me anal retentive but it's all part of the fun. 

Attached Files

  • Liked by
  • RicinYakima
  • Bud Hyett
Ken Campbell Iowa posted this 05 January 2022

i always thought it would have been great if Dr. Mann had been gifted a modern spreadsheet ... of course it would have been steam-powered ...

isn't it great how far we have come since Pope ?? 

 

.... oh wait ...

ken

Attached Files

hporter posted this 05 January 2022

I built a reloading database in 2008 using Apple's Filemaker database.  It has worked great and it is very reliable, but my version of Filemaker is very old and I doubt it will work on Mac computers much longer.  And I do not wish to spend the $$$ that Apple wants for the most recent version.

So I recently started looking for a replacement.  I tried a few open source databases and settled on the Libre Office database program called Base.  It is a free program to download and use. It is available in Windows, Mac and Linux distributions.

I have replicated my Filemaker database almost completely using Base.  I still have a few issues to work through, but it is working the way I want it to.   Base is much more like Microsoft Access, which I am more comfortable with than Apple's Filemaker.  In all the years of using it, I never felt comfortable with Filemakers user interface and the way it does relational database table linking.  Just too different from the databases I am used to using in the PC world.

My goal for both Filemaker and Base was to have a load data input screen, tied to backend tables containing all the information to be input.  You just simply select parameters on the load data screen, click the down arrow and use existent data from your data tables.  It then uses the information you entered or selected to create an entry in the Load Data table.  Which is a master table of all your loads.  It looks like a spreadsheet in Table view.

Here is my current load data input screen.

 

 

Everywhere you see a little arrow on the right side of the data box, that data can be selected from a set of tables containing the information.  Here are my Tables I have thus far:

 

 

For example, all my cast bullet molds and commercial bullets I have bought over the years are contained in the Bullet table.  When I select the bullet box on my input screen, it displays all of them to pick from.

Same thing for powder and so on and so forth.

 

I can also build custom queries and save them to show filtered data from the load table using a particular caliber, or caliber with a certain powder or a certain bullet.  Very useful for going back and finding all the different loads you have done over the years.

I still have a lot of work to do.  For example my bullet database I used in Apple's Filemaker had the fields for bullet weight and caliber combined in my display box to select from, and I have no desire to do that again.  So I am updating my new bullet table with a proper single field description, while still saving the caliber and weight fields in the table, as well as other pertinent info such as which ones are from molds that I own.  I just update that table as I enter new loads.

Another feature I am working on in the new database is printing ammo labels straight from the database.  I had it perfected in Filemaker, but I can't get Base to rotate the label to print correctly on my Dymo shipping label printer.  I have to do a screen capture and print it separately.  But that is really not a deal breaker for me, but I do want to figure it out.  Since my label printer is a thermal unit that prints black and white, I found that using a yellow background makes a nice contrast on the printed labels.

Your question on electronic data record keeping has come up on different forums that I enjoy reading.  It usually boils down to folks who do everything on paper and have no desire to change their workflow, folks who use spreadsheets, and then people like me that use databases frequently for work and home use and depend on them.  I always learn something useful by reading others input on the subject though. 

One interesting thing I saw on another forum that I haven't implemented yet is to record range results, chrono data, target photos and other useful information into the database.  Since it is all linked to a specific load number, that will be easy to do.  I just haven't gotten there yet.

Other options are databases on your phone.  I recently used my favorite called Tap Forms on my iPhone to create a database with photographs of all the bullet molds I have.  It records the mold manufacturer, mold part number, the bullet weight, the mold material (brass, aluminum, steel) and how many cavities the mold has.  It is nice to be able to have the camera images taken in real time as you enter data.  This type of database would also be useful at the range for taking photos of your target or chronograph output, since we usually have our phones with us.

And finally, there is a commercially developed reloading database that I have purchased in the past.  It is TMT Precision Ballistics and Records.  https://www.tmtpages.com/  It uses a Microsoft Access backend.  It worked well, but since I use Mac computers exclusively at home and already had a working database, it wasn't worth it to me as I had to run the program in a virtual environment under Windows.

Just my 2 cents on the topic.

Harold

Attached Files

  • Liked by
  • Millelacs
hporter posted this 05 January 2022

And in an effort to keep better notes at the range, I am going to put the load data on each of my targets using my ammo box labels.  That way I can take them home and better analyze them and ensure I have the correct load number for each target.

Attached Files

Ken Campbell Iowa posted this 05 January 2022

hporter ... thanks for your post.

reminded me that a couple years ago i was using OfficeLibre to create an live index of the FS issues, the idea that all the members could use the free data base to look up any subject in any past issue.   went pretty well, i put in several sample issues ... but that version wasn't stable enough for universal member use ... it crashed a few times on me, so i " paused " the excercise ...   

maybe time i loaded up the latest version and start entering stuff again ?? ...  especially now that we have the early issues.            how is your stability ?? ...

but just in case, i advise backing up often ... and rotate backups ...

oh, i still use Filemaker Pro v 4.0 windows a lot ... has a killer search engine.

ken

Attached Files

hporter posted this 05 January 2022

Ken,

I am glad you mentioned stability, as I had meant to address that.

As Base comes from Libre Office, it is an embedded HSQL database.  When it crashes (and it will crash) it can destroy your data.  Which is funny to me, as data integrity is one of the main reasons to use a relational database.  And I do regularly backup my databases manually, and automatically with Apple Time machine.

I have the instructions for splitting the HSQL database saved to my computer.  Splitting the database removes your data tables from the embedded container which helps with protecting the data.  It also allows the data tables to be backed up separate from the container.  I need to look into doing that.

I have no experience with a database used online.  I am sure there are many pitfalls in implementing something like that.  Both functionally and from a data security standpoint.

I think I still have my Filemaker Pro 4 install floppies.  I upgraded through version 10 and decided I wasn't going to keep giving them more money for very little improvement in their product.  Since I don't make my living with their software, I am happy to keep chugging along with my old version.

Harold

Attached Files

Squid Boy posted this 05 January 2022

I give you guys a lot of credit for being so computer literate but have lost data on the computer from all sorts of reasons. I find my file cabinet is pretty fool proof short of a real disaster. Keeping targets together with all the other data helps me the most. Visually, it is right there in black and white so to speak and easy to make a direct comparison of groups and data. Squid Boy

"Squid Pro Quo"

Attached Files

  • Liked by
  • RicinYakima
  • John Alexander
TRKakaCatWhisperer posted this 06 January 2022

hporter - thanks!  I'm adding accuracy data at 100/200 yards 5/10 shot group size and date shot

 

 

Attached Files

Lee Wiggins posted this 06 January 2022

Several have mentioned backup , Very wise . Unlike PC data files , I have never had a piece of paper erase itself.

                     Lee

Attached Files

  • Liked by
  • RicinYakima
  • Glenn R. Latham
TRKakaCatWhisperer posted this 07 January 2022

So, here's a start of my converting the scattered 3x5's and business card notes.  Lots of calibers, bullets, powders, and shootin' irons yet to add.  But I've got a good start on the types of data.  Yes it can be printed too for backup.

 

Attached Files

hporter posted this 08 January 2022

That looks like it covers all the bases. Good Job.

I think I need to add estimated velocity and actual chronographed velocity to my database too.  I will often put the estimated velocity in the note field, but it would be a good reminder to record it, if it had it's own field.

I like the group size field that you included too.  I would need shorter ranges as I primarily shoot handguns.  And of course, the specific handgun it was shot in too, as you included. Perhaps just a field for group size and one for range would be enough?  Lots to think about.  I suppose you could have a separate table to record the load number and then the specifics?

I shot 16 different 32 H&R mag loads through my Ruger LCR .327 mag today, recording each load on a separate target.  So now I am contemplating how to record this information - or at least the ones that look promising.

I also shot the Ed Harris "full charge wadcutter" load through 6 different snubby's.  I didn't keep individual targets for those tests - which now that I am home and trying to remember the details - makes it obvious now why I should record each one!

Attached Files

  • Liked by
  • TRKakaCatWhisperer
  • RicinYakima
TRKakaCatWhisperer posted this 08 January 2022

as I'm hammering through populating the spreadsheet I'm thinking about how to create a link to a jpg or pdf of the target itself....

 

and I've added the trim-to length column

Attached Files

Boschloper posted this 08 January 2022

hporter:  Would to see the specifics of your 16 .32 H&R loads.  It's one of my favorites. Maybe you could start a new thread...

Attached Files

lotech posted this 08 January 2022

I regret that I only started keeping good notes about thirty years ago. I record all range notes, load data, accuracy, and everything else including temperature and app. wind velocity in a notebook. Periodically, I transfer the basics to a 4"x6" card file. Seldom do I need to look up all the detailed information, but when I do, I simply go back to the range notebook. This system works very well for me even during power outages and I've never lost any data. 

Attached Files

hporter posted this 08 January 2022

as I'm hammering through populating the spreadsheet I'm thinking about how to create a link to a jpg or pdf of the target itself....

That is exactly what came to me last night.  When you start sticking photographs in databases or spreadsheets, the file sizes can get quite large. 

But a link to the photograph file (which for me would be in its own folder in the same subfolder as the database) would make it quick and easy to find again.  And it wouldn't have an impact on the overall file size of the spreadsheet or database.

Threads like this are nice because you always learn a thing or two from your peers.  There are always different solutions to the same problem, and I find it interesting to seeing solutions that I may not have thought of on my own.

Attached Files

hporter posted this 08 January 2022

hporter:  Would to see the specifics of your 16 .32 H&R loads.  It's one of my favorites. Maybe you could start a new thread...

You are right, a new thread would be better as that would be quite some thread drift. 

I am just experimenting with multiple bullets and powder combinations to find one that shoots to the point of aim at 7 yards that would be comfortable for my wife to learn on. 

My .327 LCR is easy for the wife to handle and she finds the double action trigger on it to be smooth and easy to actuate. 

I tried three different full wadcutters, a wide ogival wadcutter, the RCBS 98 grain SWC and I threw in the Lee 93 grain and 100 grain round noses and 90 grain SWC- just because I had recently cast them up and had them on my bench. 

I still need to cast up some of my 115gr Keith type SWC's, another 90gr SWC and one other wadcutter mold that I have.  So maybe I will start a thread when I get more testing done.  So far the 98gr Mihec DEWC looks the most promising.

 

Attached Files

Show More Posts
Close