Inserting a range from a sheet

I am now searching the forums for people needing help in embedding Excel in their posts. One of them was about allowing someone to search their name in a long list of names, and show the value of the other column in the table.

Below I built a simple example for this, with the top 100 baby names. Enter a name, and it will tell you what (if any) was its position in the top 100.

The workbook itself is fairly simple – just a table of boy and girl names and their “ranking”, and a vlookup formula into that table.

In terms of embedding, I am introducing 2 new concepts: showing only a range (as opposed to the whole workbook), and selecting the active cell.

My workbook has 2 sheets. I only wanted to show the first sheet, and only a few cells in it. This simplifies what it shown to the user. To do this, I first created a named range called ‘Form’ for the cells I wanted to show. Then, I add &Item=Form to the HTML snippet. Note that users can still get to the rest of the workbook, for example by pressing the “view full size workbook” button in the bottom Excel Web App bar.

I also wanted the selection to be on cell B2, so that users can enter the name w/o selecting another cell. I have added  &ActiveCell=B1 to the HTML snipped, and… voila!

Real world: embedded pay calculator and comparison

A couple of days ago I pointed Ruth from “My Paper Work” to Excel Web App, as a way to create an Excel calculator embedded in a blog post. She created a post, with an Embedded workbook that translates hourly and annual income to a per minute rate, and then gave a table of how much various jobs earn per hour (in the U.K.). Her post, “How much is your time worth?” is here. I think that the way Ruth used Excel Web App is a really great way to get started. Very cool! I love to see Excel in action.

While reading it, I thought of what other ways people can use Excel to create an interactive, live experience in their blogs, while using graphics to tell a story and keep their users engaged. I’ve tried the following version:

In this example, I’ve used color scale conditional formatting on cells to show the range of pays for different jobs, and also created a simple bar chart to visually compare ones hourly rate with that of other jobs. A picture is worth a thousand words…

Related Posts: