Link to home
Start Free TrialLog in
Avatar of viki2000
viki2000Flag for Germany

asked on

Webpage with formulas and graphics

Can anybody tell me what will be the recommended toll/software for a beginner to design a webpage which contains input boxes for numbers, tables which will be populated as result of calculations with complicated algebraic formulas and real time graphics as for example similar as in the next webpages?:
https://www.mathsisfun.com/algebra/quadratic-equation-graph.html
http://www.freemathhelp.com/equation-grapher.html
In my situation the curve on the graphic is already known, on logarithm scale,  and 2 cursors, one vertical and one horizontal which have to move along the curve from graphic after result of calculation.
I was thinking that maybe Adobe Dreamweaver can do the job.

Do you have any other suggestions, maybe simpler? Adobe Muse seems too simple, or?
If I hire a web page designer, how long time is estimated for such page to be done? And how much would that cost?

P.S. I have done an VBA application in Excel to do the job and now I would like to make it as webpage.
Avatar of aburr
aburr
Flag of United States of America image

Will not excell save the excell page as an html file?
Avatar of viki2000

ASKER

It is not a simple Excel Sheet. It is a UserForm in VBA which contains all kind of Controls with enough code behind.
SOLUTION
Avatar of Bob Learned
Bob Learned
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@Scott Fell
"The items you mentioned in your question would be fine if your graph was an image but you are asking for user input and dynamically changing the content."

The graph is actually an image, a curve drawn already as a picture.
But in the same time I have a set of equations which can generate that graph with a good acceptable precision. I need these equations because I want a point (defined by (x,y) values, where y=f(x)) moving on the graph based on user input. In fact I want two lines, one vertical and one horizontal, as 2 cursors, and at their intersection to have that point. Then all these 3 items: the horizontal line, the vertical one and the point will move every time the user provides a different x input value.
I do not need to generate a different graph always when the user gives a different input. The line/curve of the graph stays the same, only the above items will move.
Considering the above described behavior details, would be then a simpler situation?

@ Bob Learned (TheLearnedOne)
“You would need to convert the equations to Javascript functions, or there might be a library out in the world already”

Considering the explanation above, do you still consider I need Javascript and to convert the equations to Javascript functions?
My equations are polynomial equations and exponential equations with enough terms and high exponents. I do not remember thenm exactly now, because I found them 2 years ago with regression methods, but next week Monday I could provide the Excel with VBA and the equations – just to have a look and a better opinion what is needed in order to translate it into a web page.
Would that be helpful?

What about:
" If I hire a web page designer, how long time is estimated for such page to be done? And how much would that cost?"
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
There are many approaches to a solution, so my suggestion of writing the equations in JavaScript was only one possible approach.  We would need to know what you are comfortable with, what you have available, or what you are willing to experiment with, and that is a pretty broad subject.
OK, fair enough.
Monday I will upload here the Excel file with VBA UserForm.
"The first point you make contradicts the third."
Actually not. In my VBA case, I use both: static image and the curve. I move my cursors on image knowing the equations and user input data.

Here is my Exel VBA file made in 2013 and unfinished, but main function are working.
I would like to make something similar on a web page.
What do you think? How difficult would be to make such web page?
VBA-to-Webpage.xls
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Using Chartjs or FlotCharts would be possible to have logarithmic axes as in my VBA file?
Looking at the VBA form from my .xls file, could you estimate how long time would take for an experienced Javascript programmer to make the webpage with the same functionality as in VBA file?
Since this is going on the web, you would use javascript in place of vba.  If you look at the samples, they do exactly what you want to do.
I take that as a "yes", meaning I can have  logarithmic axes.

I would like to close the question now, but I need the last answer.
How long time would take for an experienced Javascript programmer to make the webpage with the same functionality as in VBA file? Can one of you two experts answer this question?
I thought I answered the question about time here http:/Q_28671624.html#a40776768
You said: "To create the graph with inputs and discriminate your formula could be several hours on the low end but don't be surprised if it ends up taking several days"
That is too wide.
Now, after you have seen the VBA file, I expected to narrow the results, because you also mentioned "The more specs you can give the person working on this as to what you want, the better that can be estimated."
I do not have more data than you see in the attached file.
Well, any chance for a better estimation?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
At least in the last moment you were honest and told me that actually you did not see the content of my VBA. I appreciate that.
If I decide to play with JavaScript and charts to emulate my VBA, then I know definitely I will have more questions, which for sure I will ask, of course as new questions.
Thank you for clarifications. They are helpful to get an idea.
Thank you.  

If somebody gave me a project like this and told me the vba is creating a graph and finding points, I would simply ask for the vba as a text file just to  look at but I would only need the algorithm used or a list of coordinates and wouldn't need the vba anyway.

Best of luck in getting this completed.