A master presentation (or template) contains the boilerplate information and also determines the format of the resulting document. This way, you can produce similar composite presentations. You can show in the resulting document:
▪Ranges of the Overhead workbook
▪Charts of the Overhead workbook
▪Global variables.
Prerequisites
In User Sheets of the Overhead workbook, populate a set of contiguous cells for each object to publish; to apply filters, select Data>Filter and proceed as in Excel. Then define the Range of Cells in the Overhead workbook.
NOTES
- When you enforce a filter, QDV7 creates a user-defined variable in the Name Manager (name: _FilterDatabase)
- A filter on values may affect all the tables.
Example: open the Multi-languages_Sample _with_Documents sample. The Sample Function tab features three tables meant for PowerPoint:
1.with horizontal headers
2.without headers
3.with horizontal and vertical headers.
How to Build a Master Presentation
PowerPoint™ is recommended to edit a template, mandatory if a chart must be inserted.
To edit an existing template, click Data>PowerPoint>Manage Presentations.
CREATING A TABLE
Create an empty table with as many columns and rows as in the worksheet. If there is no horizontal headers in the worksheet, they can be added.
Enter a code in the first cell of ) (in header if the headers must be provided by the overhead workbook OR ).
▪the table data section if you want to keep the horizontal headers of the PowerPoint file if any
▪the headers if the headers must be provided by QDV7.
Syntax:
{//insert_overhead_table:name=<range name>;HeightOfFirstRow=xxx;HeightOfOtherRows=xxx;FontSizeOfInstruction=xxx}
where
▪HeightOfFirstRow = height of the first row of the table (set it to a low value if you want it to be automatically adjusted to the content)
▪HeightOfOtherRows = height of all other rows below first row (set it to a low value if you want it to be automatically adjusted to the content)
▪FontSizeOfInstruction = font size of the cell containing the code; it should be equal to the one of the rows in PowerPoint.
▪xxx: value in pixels.
// informs QDV7 that it is a comment to ignore; for creation of the presentation.
CREATING A CHART (PowerPoint is required)
In PowerPoint, insert a chart type in conformance with the source table: in the example, we have chosen a two-dimension bar chart with clusters (vertical headers) and colors inside each cluster (horizontal headers).
Right-click the chart and click “Edit Data” and enter the name of the related range in QDV7.
INSERTING A GLOBAL VARIABLE
Insert the code {//Insert_Global_Variable:name=<GLV_VariableName>} as text.
How to Create a Presentation
Strip away // from the codes.
Click Manage Presentations. Select a template and click Create. This creates a presentation named Resulting_<template name> in <user>/Temp/QDVTempFilesMain.
Extra Functions
Create External Presentation: uses the first template in the list in Manage Presentations and creates a temporary file in the estimates default directory instead of QDVTempFilesMain.
Edit External Presentation: opens a file selector; then you can edit a presentation located anywhere. It can be used to view/edit a template or check out a resulting presentation with an open source presenter in the absence of PowerPoint.