office: +44 (0) 1491 825644
fax: +44 (0) 1491 832376
QPSMR 2019 - What's New
|Any Colour Table Labels
QPSMR Companion 2019.2 includes several analysis enhancements including the ability to choose any background colour for your table labels! Using the global "Tables overall settings" dialog box, [Spreadsheet options] button, simply use the [Background colour] button to make your choice.
Tip: If you need to match a colour exactly, enter the hex codes in the R, G and B boxes at the
"Colour Picker" dialog box. If you know the decimal number for the R, G and B colours, but not the hex codes, the Windows 10 calculator, set to Programmer mode, can be used to convert them. The default "Light Yellow" table label colour has the code FFFFFFE0.
|New View Data Reports
When viewing a data file, the number of records is shown at the top of the window and, along with the summary, new options have been added to the [Report] menu to list all serial numbers present in the data file and to list serial numbers missing from the file, saving the information to a txt file.
Also, to see all of the information entered for an individual record (the serial contents) simply right-click the serial number, select [List record] and the data will be output to a txt file.
As well as being able to merge (hand-in) responses from a CSV file by matching texts (for example, if a column headed GENDER in the CSV file contained the words Male and Female, and these matched the responses to a question named GENDER in your QDF file) QPSMR Companion can now merge multiple 1s.
If you have data for a multi-coded question split into several columns in your CSV file - that is a column for every response, each headed with the name of the multi-coded question, but all containing code 1s - when using the [Merge data files …] facilities QPSMR Companion will hand the 1 responses from each column into the relevant response for the multi-coded question in your QDF file. For example, a 1 in the third column will be handed into response 3 of the multi-coded question.
Furthermore you can "mix and match", so you can merge by text and sets of 1s at the same time!
Often a simple solution can save the most time! There is now a [Block] facility on the "Entry rename" dialog box, so you can quickly change entry names. This is especially useful if you copy a QDF and need to rename all entries in a section. For example, you might have many questions, filters and variables all containing Q9, which you’d like to change to Q13; using the [Block] button you can search for Q9 and replace that part of the name with Q13 - brilliant!
Block Ranking - Extended Facility
Another time saving feature is the ability to begin and end ranking for multiple entries simultaneously. For example, if you had a set of entries with 99 responses and you wanted all of the responses to each entry to be ranked in order (highest to lowest) on your tables, excluding responses 97 Don’t know, 98 Other and 99 None (which should always be positioned at the end of the table regardless) you would select all entries and use [Edit] [Block update responses] [Ranking] to add the ranking settings starting at the first response, and excluding the last 3 responses.
When creating and running tables, the default setting for format options RLW and CLW have been increased so row labels are now 30 characters wide and columns are 9 characters wide. Format ESS is now set, so if your tables are weighted any statistics calculations will use the effective sample sizes. Formats SMA’+’ and SMB’+’ are also applied, meaning that a plus or minus sign will be used to mark cells that are significantly higher or lower that the total column at the SLA and SLB levels respectively.
The global "Tables overall settings" dialog box, includes a new [Spreadsheet options] button, where you can set on or off many features to further control the spreadsheet output automatically generated when your tables are run.
As default, the spreadsheet output now includes larger table titles in bold, and the row titles are constrained to the first column.
QPSMR Limited YouTube Demonstration
A video has been added to the QPSMR Limited YouTube channel - this one is all about analysis using QPSMR Companion – why not take a look HERE.