Help Making Mils Spread Sheet

[combatgrunt84]

I have been racking my head for about 2 hrs trying to figure this out and I'm on no caffeine and a cold lol so this is probably a stupid simple solution to this but I just want to check.

Feel free to heckle I sucked at math in school.

Had to convert it from Excel to a PDF to work on the forum.

What I'm trying to do is this:

1. I shoot at 650yards notice I'm 5inches left then look at this chart and convert that to mils (input clicks into scope)

2. I think I got the 3rd Row Right.

3. I pretty possitive I got Column K right according to google and (3.6xYardage Divide 100),

Q: So how do I get the in-between yardages for the 1/10ths?

 

[1moaoff]

Why not input the known dope you have into a calculator?

 

[6.5SH]

JBM - Calculations - Trajectory

www.jbmballistics.com

set column 1 and 2 to 0.1 Mil at the bottom after you've entered the rest of your data and will have click value

 

[combatgrunt84]

Oh sweet didn’t know about that I have solid data to )00 and will have it out to 1030 next week

 

[1moaoff]

You really only need data at a few distances to make the chart accurate as long as you true the solver to it.

Different mile stones can help.
Example
0
300
600
900
With actual dope at those distances you can build a card to about 1100

Have you used a BC before?

 

[combatgrunt84]

I have a ballistic calculator that I use but what I’m trying to do is not build a dope card.

for example if a guys new to shooting kills and hits 5inches low at 700yards and he ask how many mils is 5inches at 700 I can look at the chart and see so it’s not to any one particular bullet or load just the math

 

[hlee]

Stop thinking in inches.

 

[1moaoff]

If your adjusting in mils why not read it in mils?

 

[6.5SH]

I have a ballistic calculator that I use but what I’m trying to do is not build a dope card.

for example if a guys new to shooting kills and hits 5inches low at 700yards and he ask how many mils is 5inches at 700 I can look at the chart and see so it’s not to any one particular bullet or load just the math

As others have stated you are doing it the hard way. Stick with pure mils and life gets simple and fast.

What you are looking for is called a Mil Relation Chart. One is still available here along with some other sheets:

Shooting Voodoo :: Reference Sheets

 

[smoothy8500]

for example if a guys new to shooting kills and hits 5inches low at 700yards and he ask how many mils is 5inches at 700

ummmm, ask him look through the scope and count how many hash marks to the center...... Then turn the turret the appropriate number of "clicks".....

" Oh wow, it's like an optical ruler, right there! "

 

[DFOOSKING]

for example if a guys new to shooting kills and hits 5inches low at 700yards and he ask how many mils is 5inches at 700

You tell him who cares and move on.

Plus I guarantee you nobody has absolutely any clue if that impact was 5 inches or 7.5 inches or 11.35 inches when its 700yds away. Your pulling a number out of your ass at 700yds.

The call is likely false and meaningless and your conversion to it is likely false and meaningless.

You have a reticle (at least you had better at this point as its invaluable)....use it. You can immediately see on impact and tell him hes 0.3 mils low. Answer supplied....done.

When your driving a car....do you convert MPH to inches of travel per seconds traveled? No. Because its pointless and the community at large does not use that as a standard of reference. And your speedometer doesn't even give that for you to use that reference.

"But I'm new, I wanna know the inches of travel."

"Well your going 45MPH bud....figure it out if it matters to you."

"I went 37 feet that last second."

"And how the fuck did you figure that out going down the highway?"

"I saw it. You saying I don't know what 37 feet looks like? Or what a second of time is?"

---

Asking for inches when you already have the 0.3 mils low upon impact sounds equally as stupid and pointless.

The only time you should be hearing inches is if someone states a physical dimension of a target that has actually been verified.

"You see that 10" yellow plate over on that left ridge?"

"That 20% IPSC target is 12"x 20"...."

Other than that...

Your dope should be in mils.

Your misses should be called in mils.

Your leads applied and called in mils.

Your corrections called in mils.

Your holds called in mils.

You never say hold a foot left or 6 inches right. Or you were 27.63 feet low.

You make a chart. It gives the figures needed.

"Hold .5 left. Your way low...come up 1 mil."

You have a ballistic solver that does all the heavy lifting for you. Having it spit anything in inches is dumb. Have it spit out info in the adjustment your scope is built to use and roll on.

You can walk down to that dead elk at 700yds and he can stare at the hole from 6 inches away if he feels compelled to know how many inches off he is.