Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 670
  • Last Modified:

Convert Spreadsheet to online calculator

I have several financial applications that are programmed in excel and work very well. I've gone through several programmers who say that converting from excel to an online app like PHP is easy to do but then they come back and say they need the math formulas for the excel functions.
Someone suggested to pass the variables the user enters online to an excel spreadsheet and then pass results back to the online app.
Does that make sense and what would the hardware setup be and how to get that to work

Any other recommendations to speed up getting excel applications up and functioning online. Sometimes there are some visual basic programming within the excel spreadsheet



TIA for your help
0
emery_k
Asked:
emery_k
  • 2
1 Solution
 
Varghese JacobCommented:
Did you try docs.google.com ?
0
 
emery_kAuthor Commented:
Looked at docs.google.com and it's interesting how they have spreadsheets working online.
Our project involves collecting data about someone's retirement status/contributions/etc and forecast potential withdrawals. We do NOT want it to appear as a spreadsheet as many people find spreadsheets intimidating. We have used the spreadsheet for proof of concept and now we want non spreadsheet look/layout yet perform the same math. It appears that excel functions are not easily convert-able to an online application. I am hoping someone knows a way to get this to work that we've not found yet.

0
 
Varghese JacobCommented:
If you want to develop an application in PHP, you can use information in the below links to achieve your goal.

http://phpexcel.codeplex.com/
http://www.phpclasses.org/package/86-PHP-Manipulate-Excel-files-using-the-COM-interface.html
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now