This is the menu for Tables setup.
File, New
To create a new tables (QTF) file.
File, Open
To open an existing tables (QTF) file.
File, Save
To save the changes made to the tables (QTF) file being amended.
If there is no file in use then this will ask for the name of the new tables file.
File, Save as
Asks for a new tables file name and saves the current view into that file. It then opens that saved file and you are now working in that named file.
The original file that you opened will not be changed.
File, Exit
Exit the tables setup. You will be prompted to save any changed that you have made
Global, Tables overall settings
This opens Tables overall to change settings that affect the whole run.
It is also used to select the data files to be used in a run.
Global, Renumber tables
This is used to change the table numbers so that each table is given the next available number.
Only table names that begin with a digit are renumbered. If the name does not begin with a letter it will not be changed unless it is a continuation table.
Continuation tables are given the same name as the first table in the set with an added letter or letters to give a unique name.
If the continuation name becomes more that 8 characters it will start with _C_.
IMPORTANT: If you remove the continuation (CON) setting from a table you should give it a sensible name or number.
Global, Scan tables
This scans all the tables and reports any problems found.
A scan will always be done automatically before saving or running tables.
Global, Hide Groups
This invokes the Hide groups which can be used to hide (or show) all the entries in selected groups from the list of entries at the left of the display.
Global, formats use as default
This causes the global formats set in this tables file (QTF) to be set as the default formats for the project.
Any new tables files created using the project will have the default formats preset in global table settings.
You can use the main menu [Analysis] menu to change the default formats for the project.
Default formats will also be passed over to Reflect files created from the project.
Global, Reflect export
This exports the data to a Reflect database (.qrfx) with associated files in a sub-folder called Reflect.
It also copies the tables file (.qtf) to the sub-folder for use with the Reflect database.
Default formats will also be passed over to Reflect files created from the project for new tables files created using Companion Reflect.
NOTE: Only data that passes the global filter (if set) will be exported to the Reflect database.
NOTE: The job header for the tables will also be set in the Reflect database.
Global, Tables list to Excel/OpenXML
This will put all the information about the tables list setup to an xlsx file and display it.
Global, Use selection order in lists
This is toggle which can be turned on and off.
Normally the order in which items are selected in the entries list and the tables list is not relevant, the selected items will be used in the order they are in the list.
If turned on, the order that you select items in the entry list or the tables list will affect the order in which they are used: copied, dropped, or used to create tables.
Entries, Show ZZZ entries in entry list
You can turn off this menu item to not list ZZZ entries (if any) in the entries list.
Entries, Show filters in entry list
You can turn off this menu item to not list filters (if any) in the entries list.
Entries, Show variables entries in entry list
You can turn off this menu item to not list variables (if any) in the entries list.
Add, Header and sheet name
This is used to change the job header for following tables.
It can also be used to change the name of the worksheet that contains the following tables when "A separate sheet for each table" is not selected in Spreadsheet options.
If the same sheet name is used later on, the following tables will be added to those already in the worksheet.
Add, Footer
This is used to change the job footer for following tables.
Add, Standard table
Creates a new empty table after the last or only selected table and selects the table so that it can be amended.
Add, Tables stage CL syntax
Creates a new empty CL syntax after the last or only selected table and selects the syntax so that it can be amended.
This type of syntax is used to add additional information embedded with the tables creation.
For details see the online CL manual at https://netmr.scot/manuals/cl/manual.htm.
Add, Manip stage CL syntax
Creates a new empty CL syntax after the last or only selected table and selects the syntax so that it can be amended.
This type of syntax is used to manipulate table contents after they have been created.
For details see the online CL manual at https://netmr.scot/manuals/cl/manual.htm.
Add, Arithmetic table
Creates a new empty arithmetic table after the last or only selected table and selects the table so that it can be amended.
An arithmetic table is used to do arithmetic on previously defined tables of the same size.
TIP: to add tables together it is much better to use overlay tables. Tables that are overlaid are only created once and each overlay adds extra data into the same table.
Add, Grid table
Creates an empty grid table after the last or only selected table and selects the table so that it can be amended.
A grid table is a table where each column comes from a separate entry, each with the same responses.
There are two ways to create a grid table:
Grid tables can use Grid variables to set the row and column details.
Grid tables can also use correctly named entries by dragging one of them into the rows of the table.
For the second method, all the entries must have the same name, followed by an underscore and a number, or a letter. All similarly named entries will be included in the Grid table.
Grid tables can also be used in Companion Reflect.
Add, Header and sheet position >
Creates a new header and/or sheet name in the position requested: top, before the first or only selected, as the first, as the last.
Add, Footer position >
Creates a new footer in the position requested: top, before the first or only selected, as the first, as the last.
Add, Standard table to position >
Creates a new empty table in the position requested: top, before the first or only selected, as the first, as the last.
Add, Tables stage CL syntax to position >
Creates a new empty CL syntax in the position requested: before the first or only selected, as the first, as the last.
Add, Manip stage CL syntax to position >
Creates a new empty CL syntax in the position requested: before the first or only selected, as the first, as the last.
Add, Arithmetic table to position >
Creates a new empty arithmetic table in the position requested:before the first or only selected, as the first, as the last.
Add, Grid table to position >
Creates a new empty grid table in the position requested: before the first or only selected, as the first, as the last.
Tables, Cut selected tables
All tables selected in the list will be placed on the clipboard and deleted from the list. The table before the first table cut will then be selected so that any pasted tables are put in the same place.
Tables, Copy selected tables
All tables selected in the list will be copied to the clipboard. They remain selected.
Tables, Paste tables
Any tables on the Clipboard will be added to the list after the last or only selected table.
If the tables have names that are the same as existing tables, and are not overlay tables being added to the existing overlay set, they will be given new numbers.
Tables, Paste tables to position >
Any tables on the Clipboard will be added to the list in the position requested: before the first or only selected, as the first, as the last.
If the tables have names that are the same as existing tables, and are not overlay tables being added to the existing overlay set, they will be given new numbers.
Tables, Paste special tables
Any tables on the Clipboard will be added to the list after the last or only selected table.
Paste special tables appears to allow global changes to the tables on the clipboard before being pasted.
Tables, Paste special tables to position >
Any tables on the Clipboard will be added to the list in the position requested: before the first or only selected, as the first, as the last.
Paste special tables appears to allow global changes to the tables on the clipboard before being pasted.
Tables, Delete selected tables
All tables selected in the list are removed from the list.
Tables, Move selected tables up
All tables selected in the list are moved up one space towards the top of the list.
TIP: this is useful if you have just added tables in the wrong place or you have used the toolbar button to add a table and you want it at the top of the list.
Tables, Move selected tables down
All tables selected in the list are moved down one space towards the bottom of the list.
Select, All tables using the same column
This will select every table that has the same entry set as the rows on the tables selected when this option is used.
Select, All tables using the same row
This will select every table that has the same entry set as the rows on the tables selected when this option is used.
Select, All tables with rows entries selected on the main window
This will select every table that has an entry set as the rows that is selected on the main window.
To use this option you need to select the relevant entries on the main window before opening or creating the tables file.
Select, All tables with rows entries not selected on the main window
This will select every table that has an entry set as the rows that is not selected on the main window.
To use this option you need to select the relevant entries on the main window before opening or creating the tables file.
TIP: you can use this option to create a summary tables file for selected entries by using this and then deleting the unwanted tables.
Run, Run selected tables only
This will only run the tables that are selected in the list.
IMPORTANT: All the output files will be overwritten. If you have an earlier set of tables from this tables file that you want to preserve you must rename the file before running again.
Run, Run all tables
This will run all the tables in the QTF and produce a spreadsheet file with the tables and an index sheet.
IMPORTANT: All the output files will be overwritten. If you have an earlier set of tables from this tables file that you want to preserve you must rename the file before running again.
If you have changed anything in the tables file it will be saved before the run and a copy (before the changes) will be stored in the Archive folder for the project.
If you have not used the tables overall (global) settings, this will be shown before the run so that you can check that the correct data files are being used.