| Key Item Example - part 2 |
| Part of the "Working With QuSheet" tutorial for QuSheet |
| Part of the "Working With QuSheet" tutorial for QuSheet |
| Summary |
Next define the fields: materials and size, and tables: price (filled in the workbook) and quantity ordered (filled in the sheet). Note that the default values for the fields are capitalised since they will be used in the final output. |
A: Styles are no longer shown in use if they are in-built. |
Then add a heading called Total Price, and demonstrate how placing it into the Sheet’s Entries means it is no longer shown in italics in the Heading drop-down list. Also highlight how the Sheet’s Entry colour-codes green. A heading placed in the Show column in a sheet entry can be clicked on by a viewer to expand details. |
Total Price will calculate and show a quote for tiles by material first and category second. Total Price starts by calculating / displaying another heading called Total Price by Material, repeated for all materials (by setting the Selector to the name of the Material field), and shown with an explanation of the material name itself. |
Total Price By Material does the same but with sizes. The heading now invoked is Tile Price, which by the time it is invoked will contain Field values set for both the Material field and the Size field. |
Tile Price invokes the two tables, Price and Quantity Ordered, and multiplies them together to get the result. The correct rows in both these tables are pulled out because of the two fields set during Heading processing. |
The first time the sheet is generated there is an error because of missing entries for Quantity Ordered. However, this is intended, as not every customer will order every tile, so the generation parameter Ignore “not found” Errors is set to cause QuSheet to ignore entries which result in tables which cannot be found. |
Selectors, in this instance, can be used to make things a bit more efficient, by selecting values for the materials and size fields using only the values which appear in the quantity ordered table. This isn’t guaranteed to prevent QuSheet wasting any time, but it helps. Selectors also allow the order in which fields are processed to be changed. |
| Summary » |
| View (duration 14m) |
| You will need to view this page on a non-handheld screen to see the presentation. |
| Addenda / Errata |
A: Styles are no longer shown in use if they are in-built. |
| Addenda / Errata » |
| « Summary |
Next define the fields: materials and size, and tables: price (filled in the workbook) and quantity ordered (filled in the sheet). Note that the default values for the fields are capitalised since they will be used in the final output. |
A: Styles are no longer shown in use if they are in-built. |
Then add a heading called Total Price, and demonstrate how placing it into the Sheet’s Entries means it is no longer shown in italics in the Heading drop-down list. Also highlight how the Sheet’s Entry colour-codes green. A heading placed in the Show column in a sheet entry can be clicked on by a viewer to expand details. |
Total Price will calculate and show a quote for tiles by material first and category second. Total Price starts by calculating / displaying another heading called Total Price by Material, repeated for all materials (by setting the Selector to the name of the Material field), and shown with an explanation of the material name itself. |
Total Price By Material does the same but with sizes. The heading now invoked is Tile Price, which by the time it is invoked will contain Field values set for both the Material field and the Size field. |
Tile Price invokes the two tables, Price and Quantity Ordered, and multiplies them together to get the result. The correct rows in both these tables are pulled out because of the two fields set during Heading processing. |
The first time the sheet is generated there is an error because of missing entries for Quantity Ordered. However, this is intended, as not every customer will order every tile, so the generation parameter Ignore “not found” Errors is set to cause QuSheet to ignore entries which result in tables which cannot be found. |
Selectors, in this instance, can be used to make things a bit more efficient, by selecting values for the materials and size fields using only the values which appear in the quantity ordered table. This isn’t guaranteed to prevent QuSheet wasting any time, but it helps. Selectors also allow the order in which fields are processed to be changed. |
| « Addenda / Errata |
A: Styles are no longer shown in use if they are in-built. |
-> output produced by QuSheet, licenced to "Richard Develyn", 15 Oct 2009 130|1|24094