Uploading hybrid data in Excel format

This section is specifically about uploading from a hybrid-style spreadsheet. This format is sometimes used with QuIP studies.

To upload the hybrid-style spreadsheet click on the upload button at top right as usual. The app will recognise the format.

Here is an example file.

This format has many rows, one for each answer, and includes the statements as one kind of answer; you can upload statements and additional data from the same fieldwork file.

By default, each row will become one statement.

The main differences to a normal upload are:

Rows whose question code does not include a “$” will be uploaded only as additional data, not as statements.
The app will also construct a table of sources based on the information.
A new question ID will be constructed from the question code together with the question text.

Your .xslx file must have just four columns, with column headers in this order:

text, containing the answers
source_id, containing the respondent ID
question_id, containing the question ID
question_text, containing the question text

(Actually the names of the columns do not matter, only the order.)

Your Question IDs may include the following characters:

A dollar $ to be treated as a statement.
A star * to be treated as a closed question.
A hash # to be treated as important additional data about the source, such as gender.

All the columns of the new sources table contain metadata about your sources and can for example be used to create filters (e.g. show me a map which only contains statements from people who live alone). Data whose question_code contains a # will also be shown in a few additional key place in the app such as the info panel.

You can mix these, so e.g.

#$* Do you have a house?

Will be treated as a statement and as closed question (part of a block) and as important additional data.

All important additional data, as indicated by the # in the question_id, can be found under the info toggle in your left-hand side panel.

image-20211220153042098

Uploading closed questions in hybrid format

Closed questions, as indicated by the * in the question_id, are treated like any other additional data for sources as shown in the picture above. Once imported, they will appear in the special closed questions table (which is really just a special view of the sources table) as well as in the the sources table itself.

QuIP recodes for closed questions - live link

Using this table (which includes spanish) the app recodes your data into + positive, - negative and 0 neutral.

For example:

This data will be displayed in the Tables panel if you select “closed questions.”

Appending additional hybrid data

Simply use the upload button as before and be sure to select Append not Overwrite . Contact Causal Map with any problems or issues.