Simplified datasheet

From mtab wikisupport
Jump to: navigation, search

mTAB's feature list also includes a new shortcut for copying and pasting data from mTAB's spreadsheet view into Powerpoint. A new spreadsheet menu item Simplified Datasheet displays a condensed spreadsheet view, which is suitable for cut-and-pasting into a Powerpoint chart datasheet.

The mTAB spreadsheet view shown consists of a few aggregated brand columns and rating row questions from an inspection survey. The row questions are formatted to Top 2 Box which effectively displays the "% satisfied". Note that the simplified data sheet can work with any type of row or column question format, but to cut-and-paste in a single operation, all row or column questions must have the same question format.

In the Spreadsheet ribbon, select Simplified Datasheet.

Spreadsheet simplified-datasheet simplified-datasheet.jpg

mTAB will prompt you to confirm the type or format of data that you wish to display in the simplified datasheet. The simplified view is now presented as a new spreadsheet.

If you wished to create a chart that requires the opposite row and column perspective, go to Invert Data located in the Spreadsheet ribbon to swap the row and column questions within the simplified datasheet.

Spreadsheet simplified-datasheet invert-data.jpg

Now it is just a matter of cut-and-paste between the simplified datasheet and Powerpoint's datasheet. Start by selecting the data block from the mTAB simplified datasheet, then use the mTAB menu command Copy to copy the datasheet results to the clipboard as shown. This can also be done by right-clicking on the highlighted data and selecting Copy.

Spreadsheet simplified-datasheet copy.jpg

Finally, after creating a new chart within Powerpoint and clearing the default datasheet values, paste to populate the Powerpoint datasheet.

Spreadsheet simplified-datasheet powerpoint.jpg

Note: the simplified datasheet view additionally supports exporting to an Excel XLS file by using mTAB's File Export menu item.