Importing from Excel

shaman · Posted: Tue Feb 22, 2005 4:13 am Post subject: Importing from Excel

I have over 1000 loads that I pulled from the loading data from Hodgdon and IMR. I used the PointBlank bullet database to provide BC and SD data. Now that I've got things put together, I'd like to import all these loads into PointBlank as a reference.

I'm currently using Microsoft Excel. Any ideas?

BTW: you can find my discussion of my project on the 24HourCampfire.com in the Deer Hunting section.

www.24hourcampfire.com...e/0#433343

[/url]

DallanC · Site Admin Joined: Jan 18, 2005 Posts: 3572 Location: Utah

shaman wrote:

I have over 1000 loads that I pulled from the loading data from Hodgdon and IMR. I used the PointBlank bullet database to provide BC and SD data. Now that I've got things put together, I'd like to import all these loads into PointBlank as a reference.

I'm currently using Microsoft Excel. Any ideas?

BTW: you can find my discussion of my project on the 24HourCampfire.com in the Deer Hunting section.

www.24hourcampfire.com...e/0#433343

[/url]

The problem with people tracking data in EXCEL is they format things differently. Odds are it wouldnt take much work to write an app that translates your excel data into pointblank data. You would have to send me the excel file though. I'm kinda busy off and on for the next month or two with work, any free time goes to the website but I'd really like to take a look at your data and see if I can write a "rip" utility that can be generic enough to translate excel data to pointblank.

Side note: your "Shamanic Ratio" stuff seems interesting.

-DallanC

shaman · Posted: Wed Feb 23, 2005 5:49 am Post subject: Re: Importing from Excel

Okay. PM me with a mail address or ftp site and I'll sent you an extract of the database and a data dictionary.

What would be ideal is a method of importing via a comma-delimited .csv file.