November 8th, 2011, 02:44 PM
I have a bunch of excel spreadsheets that i would like to convert into a program that can be run off a db and be shareable with others. The logic is financial math. I suspect the hardest part is the graphing which needs to be semi-logs.
I need some advice on what language & db i could use to create this product.
- able to share (so net based)
- graphs need to be semi-logs with overlay formulae such as an average which can be interactive/dragged to re-calc the math. For example, revenues over time plotted semi-log on the revenues with a median across the revenues plot. And display an extrapolation into the future.
- db to store the data
since its been 20yrs since i last programmed anything i am look for a language and/or set of tools that is simple to learn and create the above requirements.
November 9th, 2011, 09:00 AM
The most popular language on these forums is PHP, so that's probably the recommendation you'll get for a web-based app.
For graphing you'll have to look into custom pre-written libraries like jpgraph or FusionCharts. This will be the hardest part of your requirements. There are no web based graphing utilities that work like excel.
Databases are generally all the same unless you really know you need something special. MySQL is easy and popular.
HEY! YOU! Read the New User Guide and Forum Rules
"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin
"The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002
Think we're being rude? Maybe you asked a bad question
or you're a Help Vampire.
Trying to argue intelligently? Please read this.
November 13th, 2011, 04:34 PM
for the graphs: www.jqplot.com
for the backend site, there are 2 choices,
relatively easy to start, but could take some time to be 'good', since you want to do a small project, php could be slightly better then c#
the start of learning it could be a bit intimidating, but soon you will be 'good' because of the backend .net library, and the very good IDE
November 22nd, 2011, 10:18 PM
thanks for all the advise... i went with php/mysql as they were easy to pick up... for graphing i went with a product called chartdirector...