Upload your Barrier Analysis data (CSV or Excel), define Doers and Non-Doers according to responses given for particular BA questions (the field names in the column headers of your spreadsheet), and get responses ranked by Estimated Relative Risk — replicating the automated BA Tabulation Table.
One row per respondent, one column per question/response, with column headers in the first row. CSV, .xlsx, .xls and .xlsm accepted (only the data is read — macros are ignored).
Use this step if your file holds the raw text answers to open-ended questions such as “What makes it difficult…?”, “What makes it easier…?”, “Who approves…?” or “What are the advantages…?”. You group answers that mean the same thing into one category (for example, “time”, “enough time” and “having enough time” into Lack of time). Each category is then analysed like a pre-coded response.
Answers to one question are often spread over several columns: the question itself, then “What else? (#2)”, “What else? (#3)” and so on. The tool has grouped those columns. Tick the questions you want to code, shorten each name if you wish (the name becomes the question label in the results), and say how answers are separated when one cell holds more than one.
“Apply codes” adds one Yes/No column per category, named “Question: Category”, and removes the original text columns from the analysis. Answers you leave uncoded are analysed one by one under their own wording and marked “uncoded” in the results. Respondents who gave no answer to a question, or only answers marked not codeable, are handled by the “Blank cells are…” setting in Step 4.
Your coding is saved automatically in this browser on this computer. If you close the page, load the same file again and the tool offers to restore it. To keep a copy, to carry on from another computer, or to code a later file from the same questionnaire, download the codebook and load it in part A. The coded data file also lists the codebook on a second sheet.
Respondents who are neither Doers nor Non-Doers are excluded from the analysis (as on the tabulation sheet).