Assistance needed in creating simple calculator program :D

Ultranothing's Avatar, Join Date: Aug 2007
Newbie Member
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 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's Avatar, Join Date: Aug 2007
Team Leader
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's Avatar, Join Date: Dec 2006
Team Leader
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's Avatar, Join Date: Aug 2007
Team Leader
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's Avatar, Join Date: Aug 2007
Team Leader
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.