• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating an interactive web page (calculator) based on an Excel sheet

D

Denko

New Member
Some people at my company create gorgeous models in Excel. Input new numbers, change the assumptions, everything recalculates and you get lovely charts and tables showing all kinds of interesting things. I would love to put these on the web - at least the main sheet which accepts the inputs and spits out some aggregate results.


I've looked at SpreadsheetConverter.com and www.KDCalc.com and downloaded trials. I wonder whether anyone here has any advice.


Thanks.
 
Hi Denko..


I think it is better to use something like zoho spreadsheets (http://zoho.com ) or google spreadsheets (spreadsheets.google.com) to make a web-based calculator. All you need to do make the calculator in excel and then upload it to one of these sites. They will take care of converting formulas if any.


Remember, you can do lot of cool stuff in excel, but when it comes zoho or google docs, they have certain limitations (like no vba, no userforms etc). so keep those in mind.


Give it a try and let us know..
 
Thanks, Key Master. Nice haircut.


Tried Zoho, importing a sheet with hyperlinks and vlookups, and everything came through beautifully. I'm going to try something more complex and play with the formatting to see if I can make it appear more "webb-y" and less "spreadsheet-y." I'm sure that I will find some good uses for this site.


We create models that people pay for and share among themselves, while we maintain the models and keep the data current. We would want to host the spreadsheet/model, put our logo on it, password-protect it, secure the data to the extent possible, and so on. You wouldn't have any ideas about that, would you? Or perhaps I'm underestimating Zoho.


Thanks, PHD.


Dan
 
Denko


Microsoft did release an Excel Services Application which sits on a Sharepoint server and can interface with the web providing exactly the interface you seek


That's where my knowledge of it stops


Have a look at:

http://blogs.office.com/b/microsoft-excel/archive/2009/11/03/excel-services-2010-overview.aspx

http://blogs.office.com/b/microsoft-excel/archive/2009/11/23/uncovering-publish-to-excel-services-in-excel-2010.aspx


There are lots of links within those two links
 
You must log in or register to reply here.
Back
Top