.
PowerPointWriter has the ability to evaluate a certain number of formulas on data sets that are brought into a presentation.
Placing Formulas in Data Markers
Formulas in a Data Marker in your template can be used to calculate average, products, sums, and other formulas based on values in the data sets being bound to the template.
To place a formula into your template presentation, insert a data marker with the following syntax:
The following formulas are valid with PowerPointTemplate and will be evaluated when the data are bound to the document: AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV, STDEVP, SUM, VAR, and VARP. Additional information is available on the How to use Data Markers page.
The example below uses formulas to display the average, standard deviation, maximum, and minimum college entrance exam scores of a group of fictional students as part of a table including their individual scores.
The following code opens the template and binds data to it using the SetDataSource and SetRepeatBlock methods, then streams the resulting document to the user:
The formulas are evaluated by PowerPointTemplate, as you can see in the sample output slide:
