You can take any named range from one of your Live Worksheets and drop it onto a canvas. In Scoop, this element is referred to as a sheetlet. A sheetlet is a powerful element because it doesn't just display your range, it is a fully editable window into your spreadsheet. You can click on cells, change their values, and see the results reflected on anything else on the page that depends on that Live Worksheet.

Some powerful use cases include:

• Changing assumptions when doing calculations and updating the visualizations based on that
• Doing what-if analysis based on spreadsheet calculations
• Allowing users to enter/modify data in your worksheet

To take a named range from a Live Worksheet and add it to a canvas, select the Sheetlet button from the canvas toolbar. Then select the Live Worksheet and named range.

When done, you can see that portion of your Live Worksheet embedded in your canvas and you can click on an individual cell to see the underlying formula or edit the value.

Assume your worksheet looks like the following:

When embedded as a sheetlet it will be rendered in the Scoop canvas.

Creating a Visualization based on a Live Worksheet

If you want to create a visualization based on your worksheet data, click the "Create from worksheet" button on the lower left and then pick the range that you want to visualize.

Your data must be in a table that has headers for each column. The table can be vertical or horizontal and you may also supply a time value in one of the columns which will allow you to chart the data over time. After selecting the metrics you are interested in, you can then use all the normal Scoop Explorer capabilities.

Updating Sheetlet Values to Dynamically Update a Visualization

If you then drop a sheetlet onto the canvas that contains the assumptions range as well as this visualization, you will see that they are linked. You can change an assumption, like the growth rate or the expense margin and see your chart update live. This allows you to do live, what-if analysis or change assumptions on the fly when you are having business discussions involving your analysis.