Event/Tracker program Excel template

The template generated to event/Tracker program will contain different tab:

• Instructions: Contain information how to use the template excel.

• TEAs: Contain the Program Tracked Entity Attributes management.

• Stages: These tabs are going to be generated depending on the program stages, a tab is generated for every program stage.

• Release notes: This tab is for reference only, you cannot edit it. Please refer to this tab for latest features and fixes

• Mapping: This tab is for reference only, you cannot edit it. This tab will list all the option sets /Health are / Legend etc. Used in the Excel spreadsheet.

When you open the sheet, ‘Template’ tab will be selected by default.

The instructions tab

This tab provides brief information related to the Excel sheet. You can go through this tab to have a thorough understanding of all the fields in the sheet.

All cells are protected in the spreadsheet, the instruction tab contains the program setting for the selected tracker or event, also the instruction tab contain a section for the server info about server from the template was downloaded.

The TEAs tab

This tab contains the Tracked Entity Attributes assigned to the current program.

Managing sections

• To add another section, the user only will have to add a new row (it is very important to remark that an entire row needs to be added) right below the previous section’s last TEAs.

  • For a new section, the user has to select "Section" on the Structure (A) column.

  • Then type a name on (C) column that will be displayed for the new section.

Managing TEA