Spreadsheet for reloading

[tjsoutdoor]

Funny, I've done the same with a spreadsheet, but mine also calcs ballistics, in inches and moa out to 1000 yards, including wind drift, temp and elevation.

I load it on my phone, and use Google sheets. I have a sheet for everything I shoot with me at all times.

Gotta love technology... .

That's a nice one ! Any chance you want to share. I like the included ballistics section.

 

[TBell]

I've built a couple of spreadsheets that I think are handy so I thought that I would share them with the reloading community here.

I use one for documenting my load when I use a chronograph. It calculates the following for a 1 to 10 shot group for 7 different loads:

Number of shots
Lowest velocity
Highest velocity
Average Velocity
ES
Energy in ft. lbs
SD (note- Standard Deviation is a statistical value. 10 data points is the least number recommended by most chronograph mfgs and a very small sample. Statisticians will tell you that SD is only as good as the number of samples and they generally wrinkle their nose at a sample as small as 10. If you have less than 10 data points the spreadsheet will still calculate a result but it's probably not of much value)

Just fill in the blanks that you can before you go to the range and add the velocity and atmospheric data once you get there and start shooting. I take a printed copy with me but it will load on to a PDA (I loaded it on my Dell Axim 50). Once you get home you can type in the recorded values and do file Save As and save a copy specific to a particular test.

I also use the sheet when I don't use a chronograph. It's handy for keeping track of what loads that I've tried. I also have columns to record atmospheric data as well as data about the load that I am testing (caliber, BC, powder, bullet, etc.). The spreadsheet is protected to prevent accidental over writing of a formula. If someone wants the password I will gladly give it out. For that matter, if Len wants to include it when he edits the post that's fine with me. Who knows, maybe someone will get froggy and change the calcs to handle a larger sample size

I use the other spreadsheet to give me an overview of what charges I will use for a specific cartridge. When I go to the loading bench all I take with me is one sheet of paper rather than the manual. Once the loads are built I put the printout into the cartridge box with notes on which row contains which load. This doesn't sound like it would be that handy but I list every powder that I have on hand and I have a tab for rifle and a tab for pistol. I know this is going to make some long time reloaders wince a little but we have a lot of new to reloading people out there (that's a good thing). By listing all of the rifle powders on one tab and all of the pistol powders on another the likelihood of accidentally loading a rifle powder in a pistol case or vice-versa should be diminished since the "recipe" is for a specific powder is right there. Another benefit is that I only have load info for the powders that I have on hand. I don't have to worry about weeding through all of the other data. I thought about breaking it into caliber specific tabs but decided it would be more useful to more people if I did it this way. To tweak it to your liking just remove the powders that you don't have and add the ones that you do.

If Len posts the sheets that I sent him then they will already have data points entered in a couple of columns. Just delete the blue and red colored info. BTW- I used red to indicate max or over max charges in.

Feedback is appreciated but not necessary.

So do you use a range finder for your yardage?

Then use one like BR …. From Gunwerks holds 4-5 load data. You hit the button it gives yardage and MOA correction for temp., humidity, altitude, windage, and angle of of shot to target. Mine works great and gives correction to the yard not just 5-25 yard increments.

Personally I've had great luck with it. There are several manuf. of capable units out there

 

[Hugnot]

I am working on a combo spreadsheet that will provide Sg, Form Factor (given G7 BC), & RPM.

I also see that MicroSoft has a free BASIC compiler for those who don't want to deal with row/column spreadsheet constraints. BASIC stands for -"Beginners' All-purpose Symbolic Instruction Code" and is exactly that. I have seen computer wizards use BASIC instead of other languages when they wanted a quick & easy solution. Imagine - using the term G7BC vs. C37,R151 C37,R152 -....................

 

[jdvangeystel]

I've built a couple of spreadsheets that I think are handy so I thought that I would share them with the reloading community here.

I use one for documenting my load when I use a chronograph. It calculates the following for a 1 to 10 shot group for 7 different loads:

Number of shots
Lowest velocity
Highest velocity
Average Velocity
ES
Energy in ft. lbs
SD (note- Standard Deviation is a statistical value. 10 data points is the least number recommended by most chronograph mfgs and a very small sample. Statisticians will tell you that SD is only as good as the number of samples and they generally wrinkle their nose at a sample as small as 10. If you have less than 10 data points the spreadsheet will still calculate a result but it's probably not of much value)

Just fill in the blanks that you can before you go to the range and add the velocity and atmospheric data once you get there and start shooting. I take a printed copy with me but it will load on to a PDA (I loaded it on my Dell Axim 50). Once you get home you can type in the recorded values and do file Save As and save a copy specific to a particular test.

I also use the sheet when I don't use a chronograph. It's handy for keeping track of what loads that I've tried. I also have columns to record atmospheric data as well as data about the load that I am testing (caliber, BC, powder, bullet, etc.). The spreadsheet is protected to prevent accidental over writing of a formula. If someone wants the password I will gladly give it out. For that matter, if Len wants to include it when he edits the post that's fine with me. Who knows, maybe someone will get froggy and change the calcs to handle a larger sample size

I use the other spreadsheet to give me an overview of what charges I will use for a specific cartridge. When I go to the loading bench all I take with me is one sheet of paper rather than the manual. Once the loads are built I put the printout into the cartridge box with notes on which row contains which load. This doesn't sound like it would be that handy but I list every powder that I have on hand and I have a tab for rifle and a tab for pistol. I know this is going to make some long time reloaders wince a little but we have a lot of new to reloading people out there (that's a good thing). By listing all of the rifle powders on one tab and all of the pistol powders on another the likelihood of accidentally loading a rifle powder in a pistol case or vice-versa should be diminished since the "recipe" is for a specific powder is right there. Another benefit is that I only have load info for the powders that I have on hand. I don't have to worry about weeding through all of the other data. I thought about breaking it into caliber specific tabs but decided it would be more useful to more people if I did it this way. To tweak it to your liking just remove the powders that you don't have and add the ones that you do.

If Len posts the sheets that I sent him then they will already have data points entered in a couple of columns. Just delete the blue and red colored info. BTW- I used red to indicate max or over max charges in.

Feedback is appreciated but not necessary.

Very nicely done!

 

[Dgod]

Let us know if/when you get it released, I am very interested..

Thanks
Dan

 

[TXTrained]

I've built a couple of spreadsheets that I think are handy so I thought that I would share them with the reloading community here.

I use one for documenting my load when I use a chronograph. It calculates the following for a 1 to 10 shot group for 7 different loads:

Number of shots
Lowest velocity
Highest velocity
Average Velocity
ES
Energy in ft. lbs
SD (note- Standard Deviation is a statistical value. 10 data points is the least number recommended by most chronograph mfgs and a very small sample. Statisticians will tell you that SD is only as good as the number of samples and they generally wrinkle their nose at a sample as small as 10. If you have less than 10 data points the spreadsheet will still calculate a result but it's probably not of much value)

Just fill in the blanks that you can before you go to the range and add the velocity and atmospheric data once you get there and start shooting. I take a printed copy with me but it will load on to a PDA (I loaded it on my Dell Axim 50). Once you get home you can type in the recorded values and do file Save As and save a copy specific to a particular test.

I also use the sheet when I don't use a chronograph. It's handy for keeping track of what loads that I've tried. I also have columns to record atmospheric data as well as data about the load that I am testing (caliber, BC, powder, bullet, etc.). The spreadsheet is protected to prevent accidental over writing of a formula. If someone wants the password I will gladly give it out. For that matter, if Len wants to include it when he edits the post that's fine with me. Who knows, maybe someone will get froggy and change the calcs to handle a larger sample size

I use the other spreadsheet to give me an overview of what charges I will use for a specific cartridge. When I go to the loading bench all I take with me is one sheet of paper rather than the manual. Once the loads are built I put the printout into the cartridge box with notes on which row contains which load. This doesn't sound like it would be that handy but I list every powder that I have on hand and I have a tab for rifle and a tab for pistol. I know this is going to make some long time reloaders wince a little but we have a lot of new to reloading people out there (that's a good thing). By listing all of the rifle powders on one tab and all of the pistol powders on another the likelihood of accidentally loading a rifle powder in a pistol case or vice-versa should be diminished since the "recipe" is for a specific powder is right there. Another benefit is that I only have load info for the powders that I have on hand. I don't have to worry about weeding through all of the other data. I thought about breaking it into caliber specific tabs but decided it would be more useful to more people if I did it this way. To tweak it to your liking just remove the powders that you don't have and add the ones that you do.

If Len posts the sheets that I sent him then they will already have data points entered in a couple of columns. Just delete the blue and red colored info. BTW- I used red to indicate max or over max charges in.

Feedback is appreciated but not necessary.

Thank youu.. and thanks for all your effert.Much appreciated

 

[TXTrained]

I like the LOAD DATA SUMMARY sheet.!! Good Idea. That's a nice way to keep all the data on one sheet, AND have the computer do all the calculations too. I plan on doing alot of load testing over the next couple of years, as I've got 3 custom guns being built currently. I like to find the best load for each rifle and then, once I've found it; I'll load up a few hundred rounds. I'll probably find this easier than keeping it all in "scribble" form in a small notebook....LOL.

Thanks for sharing this

Yep.Ive been writing in notebooks a long time.Then I have to weed thru and find the right book.Thstvwas before I gad sense enough to dedicate one book fir each caliber.Its been a learning curve for sure on keeping records stored..

 

[hoghunter62]

Saved me a lot of work. These are awesome
Thanks

 

[Chas1]

Great spreadsheets, nice work, thanks.

 

[Comhertz]

Thank you. Works great.

 

[Moondoggie]

Take a photo, crop, save to files. Print. No bug issues. That being said, I don't do electronic spreadsheets. All paper and filled in, notebook with tabs on calibers

 

[Dgod]

I would like to get a copy of this spreadsheet. Thanks

 

[emp1953]

Those are good adds.

If I'm not mistaken the term Bullet Stability Factor comes from LoadBase 3.0. I lost my main hard drive a few months ago and I haven't gotten around to recovering everything that was on it yet otherwise I would look.

Get one of these
Amazon product ASIN B00KT3BEASand a spare hard drive for another $50 and make a spare hard drive. After losing a hard drive once and all the inconvenience it caused I do this now and am better off for it. Losing a hard drive can be like losing your wallet.

 

[C-130 Dude]

I've built a couple of spreadsheets that I think are handy so I thought that I would share them with the reloading community here.

I use one for documenting my load when I use a chronograph. It calculates the following for a 1 to 10 shot group for 7 different loads:

Number of shots
Lowest velocity
Highest velocity
Average Velocity
ES
Energy in ft. lbs
SD (note- Standard Deviation is a statistical value. 10 data points is the least number recommended by most chronograph mfgs and a very small sample. Statisticians will tell you that SD is only as good as the number of samples and they generally wrinkle their nose at a sample as small as 10. If you have less than 10 data points the spreadsheet will still calculate a result but it's probably not of much value)

Just fill in the blanks that you can before you go to the range and add the velocity and atmospheric data once you get there and start shooting. I take a printed copy with me but it will load on to a PDA (I loaded it on my Dell Axim 50). Once you get home you can type in the recorded values and do file Save As and save a copy specific to a particular test.

I also use the sheet when I don't use a chronograph. It's handy for keeping track of what loads that I've tried. I also have columns to record atmospheric data as well as data about the load that I am testing (caliber, BC, powder, bullet, etc.). The spreadsheet is protected to prevent accidental over writing of a formula. If someone wants the password I will gladly give it out. For that matter, if Len wants to include it when he edits the post that's fine with me. Who knows, maybe someone will get froggy and change the calcs to handle a larger sample size

I use the other spreadsheet to give me an overview of what charges I will use for a specific cartridge. When I go to the loading bench all I take with me is one sheet of paper rather than the manual. Once the loads are built I put the printout into the cartridge box with notes on which row contains which load. This doesn't sound like it would be that handy but I list every powder that I have on hand and I have a tab for rifle and a tab for pistol. I know this is going to make some long time reloaders wince a little but we have a lot of new to reloading people out there (that's a good thing). By listing all of the rifle powders on one tab and all of the pistol powders on another the likelihood of accidentally loading a rifle powder in a pistol case or vice-versa should be diminished since the "recipe" is for a specific powder is right there. Another benefit is that I only have load info for the powders that I have on hand. I don't have to worry about weeding through all of the other data. I thought about breaking it into caliber specific tabs but decided it would be more useful to more people if I did it this way. To tweak it to your liking just remove the powders that you don't have and add the ones that you do.

If Len posts the sheets that I sent him then they will already have data points entered in a couple of columns. Just delete the blue and red colored info. BTW- I used red to indicate max or over max charges in.

Feedback is appreciated but not necessary.

Thanks!