Child pages
  • Libraries Weekly COVID stats

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Access the building rounds form using the appropriate link
  2. Click the Results tab.
  3. Click open in Excel
  4. Download excel file
  5. Delete all data that fall before or after the week (Sunday - Saturday) examining
  6. Delete columns A - E
  7. Copy any data from Columns C and D (times) to column B (this is after the previous column delete)
  8. Delete columns C and D
  9. Convert columns D and E to numbers
  10. Delete columns F and G
  11. Label column F “Total users in building”
  12. Enter formula in cell F2: “=d2+e2)” and fill down for all of column F
  13. Hide Column D
  14. Total the number of mask interactions during building rounds (sum column E)

...