[Ultranothing]

Hello, I am trying to create a very simple standalone prog which allows me to calculate the DOT mileage from point A to point B.

I have a CT DOT official mileage book which it rather difficult to browse through when I'm on the road...it looks something like this :




So basically what I'm after is a way to enter all of the values into a program so that I can get something like this :



I started programming in Basic language when I was 5 or 6 years old...hehe I still remember the very first program I made :

10 Print "Hello, what is your name?"
20 Input A$
30 Print "Hello, ";A$

And then, whoa, when I figured out I could replace lines 10 and 20 with Input "What is your name ->"A$

...yah, those were the days...but unfortunately I forgot most of that over the years. It's times like these I wish I'd kept up on my lessons

So I'm hoping someone can give me some pointers. Would this be a difficult program to create? I'm not expecting anyone to make it for me, I'd like to do it myself, if it's something a newbie could accomplish.

Thanks in advance for any info!

- Josh

[jwshepherd]

Since you've used basic before I would recomend using VB with an access database. Do you have access to VB? If not you could probably even use Excel with VBA

[DaWei]

Language is not your problem. Access to data in a manipulable form is your problem If this data is available on the web, I would suggest Python and Beautiful Soup. If it isn't, you're in a world of hurt.

[jwshepherd]

modifying the data sheet as you have will be a pain in the arse, but not impossible. Once it is in proper format everything else should be simple.

[jwshepherd]

they have a program to dumps gdx files into an access database ( gdx2access ) , but it takes a table for each city. don't know if that is the best way, but I will give table layout some thought.