Solved

Convert Spreadsheet to online calculator

Posted on 2010-09-14
3
664 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Recently I spent hours debugging an issue in a Rails project where ActiveRecord was causing MySQL errors trying to create a User object of a class at the top level of a Single Table Inheritance model structure.  It turns out `.create` behaves differ…
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…

622 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