Long Range Hunting Online Magazine


Go Back   Long Range Hunting Online Magazine > Rifles, Reloading, Optics, Equipment > Rifles, Bullets, Barrels and Ballistics


Reply

modified Excel spreadsheet

 
LinkBack Thread Tools Display Modes
  #8  
Old 02-28-2003, 03:47 PM
Silver Member
 
Join Date: Jun 2002
Location: NY
Posts: 394
Re: modified Excel spreadsheet

Sheldon can you email me a link as well?

Thanks
Frank D
__________________
"A tie is as good as a loss, and no one remembers second place."
Reply With Quote
  #9  
Old 02-28-2003, 04:27 PM
Silver Member
 
Join Date: Aug 2002
Posts: 166
Re: modified Excel spreadsheet

Attention Admins: Please Delete

Last edited by Sheldon; 08-30-2009 at 04:22 PM.
Reply With Quote
  #10  
Old 02-28-2003, 04:38 PM
Platinum Member
 
Join Date: Jun 2001
Location: Palmer, Alaska
Posts: 2,539
Re: modified Excel spreadsheet

That would be him. [img]images/icons/smile.gif[/img]

Thanks Sheldon. [img]images/icons/smile.gif[/img]
__________________
Brent Moffitt
Reply With Quote
  #11  
Old 02-28-2003, 05:24 PM
Junior Member
 
Join Date: Sep 2002
Posts: 14
Re: modified Excel spreadsheet

Thanks Guys
Reply With Quote
  #12  
Old 03-01-2003, 08:52 AM
Platinum Member
 
Join Date: May 2001
Posts: 2,369
Re: modified Excel spreadsheet

All

Yes, I am the Dave King that worked on that spreadsheet. Peter Cronhelm initially had the ballistics portion on his website, I downloaded and I played with the thing to make it fit my/our desires (with the constant help of Peter Cronhelm).

It's free, have at it... Just give a little credit to the known designers.

It's certainly not perfect but allowed us to expand our own knowledge. The part that we installed that I'VE NEVER seen prior was the ability to enter GPS coordinates for Target Reference Point(s) (TRP) and the Final Firing Position (FFP). With this TRP and FFP info in the program and the selected wind speed and velocity at the FFP (sorry, only single vector winds) the program KNOWNS the distance, angle, wind correction and bearing to all the entered TPR's and displays the calculated windage and elevation values.
Reply With Quote
  #13  
Old 03-01-2003, 09:43 AM
Silver Member
 
Join Date: Aug 2002
Posts: 166
Re: modified Excel spreadsheet

Attention Admins: Please Delete

Last edited by Sheldon; 08-30-2009 at 04:22 PM.
Reply With Quote
  #14  
Old 03-01-2003, 03:01 PM
Platinum Member
 
Join Date: May 2001
Posts: 2,369
Re: modified Excel spreadsheet

Sheldon

No, I'm not in Canada, I live in Maryland just a stone's throw away from the dreaded Washington DC area. Perhaps you'd be willing to trade Citizenship and homes [img]images/icons/wink.gif[/img]?

After reading over what I posted I guess it is difficult with the jargon.

What I was stating as apparently unique in the civilian arena (in my sphere of knowledge) is that once I know the position of all my targets (I obtain this by GPS) and I know my firing position the spreadsheet automatically knows ALL the Ranges, Angles and Wind Speed corrections to all entered targets.

I know this because of the GPS positions entered. Look around the room you are in now and imagine it as a large Prairie Dog town. As you move around the room the relative distance(s) between you and the objects changes BUT the objects themselves don't move. All I need to know to determine the distance, bearing and relative height to ALL the plotted objects in the room if your actual position in the room (or Prairie Dog town). Once I know where the shooter is and where all the targets are I can provide scope corrections via ballistic prediction's. The single vector wind part simple means that I can only figure a wind coming from one direction and at one speed.

There are certainly programs that can do all this and much better but I had never seen one (for a rifleman) and it was great fun and educational to build one.

I had intended to add a section that would allow the user to enter KNOWN (tested on location) and verified ballistic data and then offer an option between using predicted trajectory data or data extrapolated from KNOWN tests.

There are Rangefinder units available that offer distance, angle and bearing data. With this type of data a person could build a GPS coordinate map for targets without actually going to each target site. Just determine the firing position and then enter each target by back calculating the GPS position using the range, bearing and angle to the target. Not a difficult proposition...questionable usefulness but not technically difficult.

Again, this spreadsheet was built as a toy at the whim(s) of two people.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes


Similar Threads for: modified Excel spreadsheet
Thread Thread Starter Forum Replies Last Post
Spreadsheet for reloading Mike6158 Reloading 33 04-08-2014 01:10 PM
REMINGTON 700 ADL 7mm-08 CALIBER IN SKYLINE EXCEL CAMO WITH 3X9X40mm SCOPE RICKSR Guns For Sale 0 08-25-2009 07:46 AM
Barrel life Spreadsheet Mikecr Rifles, Bullets, Barrels and Ballistics 6 05-10-2005 04:29 PM
Dave King & Spreadsheet Michael Eichele Rifles, Bullets, Barrels and Ballistics 3 05-17-2003 11:16 PM
Excel Spreadsheets Hunter Rifles, Bullets, Barrels and Ballistics 2 01-19-2002 12:03 AM

Current Poll
Where in the US do you live?
West of the Mississippi River - 60.80%
895 Votes
East of the Mississippi River - 36.89%
543 Votes
On the Mississippi River on a houseboat - 2.31%
34 Votes
Total Votes: 1,472
You may not vote on this poll.

All times are GMT -5. The time now is 05:35 PM.


Powered by vBulletin ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Management Powered by vBadvanced CMPS
All content ©2010-2014 Long Range Hunting, LLC