Stratosphere's powerful Excel add-in enables you to easily connect line items from your spreadsheet to your Stratosphere project. The first step in this process is to bring line items from your spreadsheet into Stratosphere.
- First, you'll want to tell Stratosphere where your line item descriptions are located by clicking the Stratosphere tab at the top of your Excel toolbar, then click "Settings", and then type in which column or row holds your line item descriptions (the default is column A)
- Next, you'll want to identify what type of quantity each cell will be holding. The options are a count, linear measurement, or area measurement
- When you've decided on the measurement type for a given cell (or group of cells in a range) select the cell(s) and click one of the buttons in the Stratosphere toolbar for Count, Lenght, or Area
- To create a new layer in Stratosphere, click the "Add new count," "Add new length," or "Add new area" button from the dropdown
- As an alternative, you can go through the same steps by right-clicking on the cell(s), finding the Stratosphere item in the menu, and then selecting "Add new..." from the menu
If you'd like to see this process in action, you can watch this short video.