Trying to find best solution to convert custom estimating program.
Posted on 2006-03-28
This is not a real "application" but rather a set of spreadsheets with macros that was originally created back in the stone-age of DOS with Symphony.
It was created by my father for our family business to do price quotes. When he retired in 96, I took over his main duties of "one-man-geek-department" and so it was my responsability to keep these spreadsheets updated. At the time I took them over, we were converting all the machines to Windows, so I figured why not convert these as well. I had more experience with Quattro Pro then with Excel, so I converted them all to Quattro format, macros and all. This is how its been for the last 9 years basically and over the years some of the formulas that work in the background have kinda gotten out of sync with current conditions such as prices of itmes and cost of labor. So it has come down to being told to fix it by my boss and instead of trying to through all the spreadsheets with a fine-tooth comb, I would like to completely revamp the whole thing.
I have inlisted my father to recreate the original spreadsheets, this time in Excel format.
I would like to create my own front-end to this, but am unsure what would be the easiest/end-user friendly way to do it.
I have thought about doing it in HTML/DHTML/CSS and Access/VB.
I am not up on these languages but learn quick. I did go to tech school to learn programming, but that was back just before PC programming was the norm, so I learned mainframe style progs like COBOL.
What do you guys think would be my best solution to this, and no, I do not want to farm this out, I want to get the experience for myself. (I've been telling myself I will learn these languages, but have been lazy about it :()