Solved

Convert Spreadsheet to online calculator

Posted on 2010-09-14
3
661 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
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 create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…

752 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