Management statistics

• History of court usage
• The states of the court are:
  • No data => 1
  • Available => 2
  • Booked => 3
  • Closed => 4
• Lifecycle (assuming not closed): 1>2>3
• What do you need to know
  • New fields:
    • A) timeFirstScrape - Done
    • B) timeCourtReleased - Done
    • C) timeCourtTaken (ie time on a scrape  when the court was Available before but is now Booked) - Done
  • Compute
    • SnapUpTime:  (C-Max(A,B))
    • LeadTime: (PlayTime-C)  - Done