Key Item Overview

Summary

At the highest level, QuSheet consists of a Workbook and a number of Sheets.

You can organise your work using a single-sheet system, just using Save As whenever you build one project from a similar one. With this approach, you will need to make multiple edits whenever you change something in the common workbook.

With the multiple-sheet approach, common cross-sheet elements are kept within the workbook, and need only be changed just the once even if you need to re-generate all sheets (which you can do all at once from the sheet-list menu).

A Workbook has Headings – those items which generally translate into output lines which can be expanded by the viewer.

A Workbook has Tables – your data.

A Workbook has Fields – extra columns for your tables both to retrieve data and used as indexes. Fields are defined with default values or can take values from tables.

A Workbook has Selectors – collections of Field values to allow you to repeatedly process headings and tables.

A Workbook has Styles – the collections of parameters which govern how QuSheet displays its results.

A Workbook has Generation Parameters – not a key item as such, but rather a collection of parameters which can only be applied to a sheet as a whole.

A Sheet has Entries – references to Tables, Headings and Fields presenting an ordered list at the top level of what is to be displayed in a given sheet.

A Sheet has Table Additions – table rows which apply to the particular sheet only (and which are looked at before any in the workbook).

A Sheet has Field additions – as above for default Field values.

Finally, a Sheet can provide overrides for the Generation Parameters in the workbook.