Solved

Convert Spreadsheet to online calculator

Posted on 2010-09-14
3
652 Views
Last Modified: 2013-11-10
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
Comment
Question by:emery_k
  • 2
3 Comments
 
LVL 5

Expert Comment

by:Varghese Jacob
ID: 33682312
Did you try docs.google.com ?
0
 
LVL 1

Author Comment

by:emery_k
ID: 33683719
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
 
LVL 5

Accepted Solution

by:
Varghese Jacob earned 500 total points
ID: 33689156
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Open Page or Post…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now