By default, OfficeReports produces tables and charts where the Column calculates percentages.
By default, OfficeReports will add the Base in the Top row of the table. If it is preferred default in the Bottom row, it can be change here.
By default, OfficeReports always shows unweighted bases in tables and charts. Check ‘Weighted’ if you want to display the Weighted Base instead.
Each variable in OfficeReports has a Name and a Text. OfficeReports offers different ways to work with these Names and Texts in tables and charts:
Use the defined text
By default OfficeReports uses the defined Text in tables and charts
Remove the name from the text
Some datasets repeat the Variable Name as the initial part of the Variable Text. This can be very convenient having a short Variable Name in tables and charts while building/testing a report, but when it comes to the final report we might want to remove the Variable names from the text in all tables and charts. Use this setting and ‘Refresh Report’ will remove this part of the variable text in all tables and charts.
Add the Variable Name to the start of the text
Variable names is typically technical/logical names related to the data structure. For example, a variable name could be ‘Eval_01’ and the related variable text could be ‘I receive useful and constructive feedback from my manager’. Now when building and testing a report it could be useful to add the variable name to tables and charts, and then when the process is over we could go back and just use the setting ‘Use the defined text’ and then ‘Refresh Report’
When producing reports for many different groups (brands/companies/products) it can be useful to group all the different table- and chart layouts. The Layout Module includes features for this type of grouping. In Settings, you can define that OfficeReports by default shows layouts related to one of these groups.
If we have defined weight variables in OfficeReports or added weight variables in a data import, we can select a weight variable to be used as a default on all tables and charts defined in the report.
tables and charts defined before this setting are NOT changed.
When calculating tables or charts where we in a cell are not able to perform the calculation because we would have to devide by zero, OfficeReports will default show ‘—‘. You can change that to what you want, e.g. ‘N/A’.
Significance characters and characters showing Low Base and Minimum Base are by default displayed in Superscript in Excel tables. You can change that by removing the checkmark.
This setting only affects Excel. As pointed out in the menu we recommend producing default Excel charts and then using Excel functionality to adjust charts.
Add a checkmark and a comment will be added to all OfficeReports tables created in Excel. Mark the table and the comment showing all settings for the table is displayed: