Best Practices - USAID-OHA-SI/Wavelength GitHub Wiki

Below are some thoughts on best practices for setting up reporting templates.

  • Each column should be have a column name and that name should be unique
  • Avoid merging cells
  • Include a partner name, mechanism id
  • Site/facility names should be populated from DATIM and should also include a site uid
  • Include a tab that has a description of each header/data element
  • Be consistent and keep the same structure on every tab and for every reporting template
  • Avoid including calculations in the same sheets as there is raw data, including totals and yields
  • Each sheet should be limited to only one table