Excel Worksheets

[dolek]

Great info,thanks for allowing me to benefit from your hard work. Much appreciated.

 

[terraMODA]

Here's an updated version of the BDC Calc with upper and lower subtentions added, a better reticle diagram, more clear directions and the sheet is now protected so you can't inadvertently change something you're not supposed to. Enjoy!

 

[terraMODA]

Now with even more subtentions added! (Between circles)

Latest version above! Deleted the 'beta' version. Clearly, there are many, many ways you can range with the BDC reticle!

 

[Mozella]

.......... snip......

Also any one else who has used Excel for record keeping, ballistsics or reloading. OCW and ladder charts also welcomed.
Lets see if there are any new ideas out there.

I do seating tests two ways. Either I seat bullets using a Redding seating die with micrometer setting, or I use a Wilson seating die and arbor press, sometimes at home and sometimes at the range.

The CBTO (cartridge base to ogive) distance is different for each rifle/bullet combination and must be measured using something like the Hornady comparator tool to find that distance where the bullet just touches the lands. We all do that already. I call that reference length .000" Jump/Jam. I use negative numbers for rounds longer than that which are jammed into the lands and positive numbers for shorter rounds which "jump" into the lands. The appropriate die setting for .000" must be found by experimentation. Once that value is known, it can be entered into this spread sheet along with whatever CBTO length which equals .000" and die settings for other cartridge lengths will be calculated.

The notes out to the side are simply a mini log book where I store my particular reference numbers. Naturally, they will be different for you. I give my rifles goofy names too, like "kale", a rifle with an ugly green laminated stock.

If you use a good quality die, you can simply dial in the appropriate setting to seat cartridges of any reasonable length. NOTE: For reasons I don't remember, I have used negative numbers to mean screwing down my Wilson die in order to make shorter cartridges. That convention is just backwards from the convention I use for the Jump/Jam measurement; i.e. negative means longer rounds. This would be an easy thing to fix for people less lazy than I.

Unfortunately I am nearly illiterate when it comes to working in Excel, so this spreadsheet isn't very slick, but it does the job for me. Perhaps some Excel Guru could take my file and clean it up a little bit.