Help

Worksheet Format

Overview

Sigma Magic worksheet is formatted into four areas: header area, input area, output area, and temp area. The header contains information about the analysis being performed. Any comments or error messages from the analysis are also output to the header area. The header area is the first rows of the worksheet. The first row contains area for output/comments from the analysis. The second row contains the main header and a logo which stores default worksheet information as described below. The first few columns contain the input area. The input area is the location where raw data for the analysis can be input into the analysis. Note that some data may also be entered into the analysis through dialog boxes. The next few columns contains the output area. The output area usually contains 2 sections: Notes and Graphs. Any text output is sent to the Notes area and any graphs are sent to the Graphs area. In some templates, the input and output areas may be combined into one. For other templates, if no input is required, then only an output area may be present. In the example shown below, the first 5 columns contain the input area, the next 5 columns contain the output area and the last 5 columns contain the temp area. The temp area contains data that is used to plot any graphs. The temp area is usually hidden on a worksheet.

Ideally, you should not insert any rows or columns in this template as Sigma Magic is expecting to find data in certain areas of the worksheet. You may safely use the area to the right border to save any info on this worksheet. However, writings into the input, temp, or output area may be lost when Sigma Magic analysis is run. Once the analysis overwrites your data, it may be hard to retrieve it as there is no backup performed on your data when the worksheet is cleared. Hence, it is recommended that you not save any data on this worksheet except in the designated input area. The following section describes how Sigma Magic finds the information it is looking for. If you modify the format, use at your own risk.

Format

The worksheet format information is stored in the Sigma Magic logo located in the top right area of the header. Do not delete this logo - if you do then Sigma Magic software will not run on this worksheet. To look at the worksheet format, right-click on the Sigma Magic logo and then select "Format Picture" and then select "Alt Text". A dialog box such as the one shown below will then be displayed. Information in this text box is stored in JavaScript Object Notation (JSON) format. This format is similar to XML format but has less disadvantages than an XML format. For more information about JSON refer to the website: http://www.json.org. Data is stored in objects and string-value pairs. An object is an un-ordered set of name/value pairs. An object begins with a { and ends with a }. Each name value pair is separated by a semi-colon. Multiple name/value pairs are separated by commas. Here is a description of the name-value pairs for the worksheet layout. All Sigma Magic worksheets should have a worksheet layout that contains information about where Sigma Magic can find the input cells, output cells, temp area etc.

KeywordDescription
NameName of the analysis that is stored in the worksheet. This name tells the software what analysis to run on this worksheet. Each template has an unique name associated with it.
VersionVersion number of the worksheet. This is used to manage multiple versions of the worksheet.
LogoThe location of the logo on the worksheet.
InputThe location of the input cells
OutputThe location of the output cells (specifically notes section)
GraphThe location of the output cells (specifically graph section)
CommentsThe location to display any comments from the analysis (default: B1)
HeadingThe header locations (used to set background colors)
PrintThe print area of the worksheet. Used to print or export to PPT format
ClearThe area that should be cleared when you click on Clear button
TempThe area that stores temporary graph data.

In addition to the worksheet layout, information is also stored about any dialog box selections. These options correspond to the dialog box picks and are numbered 1, 2, 3 etc. Any selections you make in the dialog box are used to update the corresponding locations in the Sigma Magic user data. Finally, any conclusions from the analysis are stored in this format.

FAQ

This section contains some frequently asked questions. If you have other questions on this module, please contact technical support.
Can I modify the worksheet format?

If you modify the format, then the software will use the new locations specified in this file to update the worksheet. However, unless you fully understand how to use this feature, we recommend that you do not change the format string. If you want the changes to apply to all future worksheets then you need to modify the appropriate template located in the Templates folder in the Sigma Magic installation directory.