Sunday, May 6, 2012

Test: Interactive Excel File in the Cloud Hints Calculator Possibilities.

This is a simple demonstration of how interactive Excel files [with formulas and lookups] can now be embedded into web pages/blogs, using data hosted in the cloud.  

What's the Big Deal?
Interactive cloud based Excel files that allow user input and use formulas/lookups could be used to directly post on web pages/blogs housing related calculators-think eligibility calculator, monthly payment calculator, affordable mortgage calculator, and affordable rent and income calculators. The big deal is that anyone with Excel can now post these interactive files/calculators to their web site or blog, without the need for highly sophisticated web programming skills.

The embedded Excel file below 
1. Has you enter a calender date in the column to the left with yellow fill.
2. Uses formulas to then insert the calendar year and two different fiscal years (starting in October 1 and July 1) in the columns to the right. 
3. The formulas used in this lookup can be used with a large data set when you have full calendar dates and you want to add fields that show only the calendar year and fiscal year so that you can sort/filter/pivot on that data.


Clicking icons at bottom of Excel embed will allow you to view full screen or download as Excel file.

As before would appreciate any feedback on appearance and especially how well you were able to enter date in left hand column and see results in columns to the right. (Interactively feels a little hit and miss when I try in preview move).

Direct link to this Excel file is HERE; All of my cloud based public Excel files can be found in the SkyDrive folder HERE. (A permanent link to this folder is now in the right pane, look for "Excel Cloud Folder").

Originally created and posted on the Oregon Housing Blog.

No comments:

Post a Comment