SSSpread

---

Introduction

SSSpread is a proof-of-concept Microsoft Excel client for the Surveyor Summary Server (SSS).  Using embedded Excel web queries and the full range of Excel's analysis tools, the Surveyor analyst can customize a view of the Surveyor measurement data that best meets their needs.  (screenshot)

Demonstration

To experiment with the SSSpread demonstration, follow these steps:

1. Download the "ssspread.xls" Excel spreadsheet (don't worry, there are no nasty macros!)
2. On the "Control & Charts" worksheet, edit the query parameters in row 2
• use the drop-down lists to select the desired Source Node and Dest Node names
• the Start Time and End Time fields may be edited  as well; times are given in GMT in the format MM/DD/YY HH:MM {AM|PM}
3. Finally, press the "Refresh All" button  to invoke the web queries on the "Data" worksheet and update the graphs

More Information

For more information on embedding web queries in Excel spreadsheets, see the Microsoft Excel Web Connectivity Kit (available here).
The SSS web queries used in SSSpread are defined in the files: "getNodes.iqy" and "getStatistics.iqy".