% Documentation: ODK2PDF.py % Jason Thomas, Samuel Clark, & Martin Bratschi
in collaboration with the Bloomberg Data for Health Initiative % May 10, 2018

Intro

The purpose of the program ODK2PDF.py is to convert a VA questionnaire, in Microsoft Excel format, into a human-readable pdf. The VA questionnaire must have the same format as the WHO 2016 VA questionnaire. Users can add an additional column to the spreadsheet with the name 'explanation' and the ODK2PDF.py program will include the text, intended to be an explanation of the particular question. The ODK2PDF.py program is implemented in Python 3 and requires the pandas and pylatex modules.

Set up

• Download and install Python 3

• Install the pandas and pylatex modules with the following command (in a terminal)

  $ python3 -m pip install pandas pylatex --user
  

  See the Python documentation page for more help on installing modules.

Usage

• Example 1: The WHO 2016 VA questionnaire is used for this example and the MS Excel file was renamed to q1.xlsx. The questionnare can be converted into a PDF with the following command:

  $ python3 ODK2PDF.py q1.xlsx
  

Output

The program will create a new PDF file: ODK2PDF_Output.pdf.

For each questionaire, a block will be created. Components of each block include:

• (Line 1) Question ID: Relevance field
• (Line 2) Question: Question Text
• (Line 3) list of possible answers