Buckskinner
Well-Known Member
John asked that I post this, for some reason it will only let me post a pdf, not a xls...
-
If you are being asked to change your password, and unsure how to do it, follow these instructions. Click here
Spreadsheet for reloading
- Thread starter Mike6158
- Start date
Help Support Long Range Hunting Forum
Doesn't surprise me. Posting a pdf image is relatively risk free to Len's website. Posting programmable documents carries a much greater risk of being infused with maleware/virus/worms and whatever else is out their on the www.
Oldtime Shooter13
Well-Known Member
My experience is that to shoot 115gr bullets you would need faster twist in the range of 1-7.5" to 1-8". I started having stabilizing issues with 105 A-Max in a 243 Winchester years ago with a 1-9.25" twist. I think all of the MFG. of heavy bullets for 6mm will state 1-8" twist or faster?
Oldtime Shooter13
Well-Known Member
Nice work on these spreadsheets, I have been looking at doing something like this and you saved me a great deal of time. I want to see if I can get something like this converted to my iPad to use at the range. I also have a app for my iPhone and iPad that connects to my chronograph via blue tooth. Man it would be a perfect world if I one could get all of these dots connected. Again, really nice job on these spreadsheets and thanks for sharing.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.
Saintsfan1977
Active Member
You could use MS Office app on your phone to open the sheets. If your chronograph spits out the data into a csv file then you could link the 2 books together so that it auto fills the sheet in this forum. Its not that difficult to do. Google would help you with how to do that.
Oldtime Shooter13
Well-Known Member
Wow, you have no idea how much time you have saved me! I think that I might be able to make that work?
TejasRider
Member
These sheets are a great addition to my reload tracking. I use a combination of OneNote and Google Sheets for some of my logging and planning. I use these apps since they are easily available on mobile devices as well as desktops. I'll try to put together a video of how I use them and maybe post links to see if they'd be helpful to others. Thanks for sharing!
TejasRider
Member
Here is that video but after seeing some of these spreadsheets, I think I have some updates/revisions to make.
Will do. You should get them shortly
ncwg2boatguy
Well-Known Member
ncwg2boatguy
Well-Known Member
You can save it to your desk top and print it.
SCSCHNUR
Well-Known Member
Can't find file it says on my screen.
TejasRider
Member
Yep, I got a 404 error from that link too.
Recent Posts
-
Interesting video on what we all know is going on with automobiles- Latest: FireFlyFishing
-
-
-
