Skip to content

Instantly share code, notes, and snippets.

@dalpert-korewireless

dalpert-korewireless/work-wait.example.txt

Created June 1, 2016 02:15
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dalpert-korewireless/9d8e30624137fff06ae0adf99b9c4ce6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dalpert-korewireless/9d8e30624137fff06ae0adf99b9c4ce6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
work-wait.example.txt
Entered Status Left Time in State Type of Time Timespan Adjusted Time
42492.70621 Open 42502.70662 10.00:00:35.8220000 Wait 10.00041461 -10.00041461
42502.70662 In Progress 42506.8536 4.03:31:39 Work 4.146979167 4.146979167
42506.8536 Code Review 42506.86756 00:20:06 Wait 0.013958333 -0.013958333
42506.86756 Ready for QA 42517.59819 10.17:32:07 Wait 10.73063657 -10.73063657
42517.59819 In Testing 42517.62551 00:39:20 Work 0.027314815 0.027314815
42517.62551 Failed QA 42517.66536 00:57:23 Wait 0.039849537 -0.039849537
42517.66536 In Progress 42517.66567 00:00:27 Work 0.0003125 0.0003125
42517.66567 Ready for QA 42517.81193 03:30:37 Wait 0.146261574 -0.146261574
42517.81193 In Testing 42517.81461 00:03:51 Work 0.002673611 0.002673611
42517.81461 Ready for Production 42521.90524 4.02:10:31 Wait 4.090636574 -4.090636574
@dalpert-korewireless
Copy link
Author

dalpert-korewireless commented Jun 1, 2016

  • tab-separated;
  • times are in duration (including weekends)
  • I see a 25 day / 85% wait, 4 day / 15% touch time split
  • for simplicity on this ticket the code review was mostly queued wait time
  • Ready for Production was time spent after validation by our testers but before merged and done.
  • Timespan is (Left - Entered) or time spent in that status
  • Adjusted time is the Timespan value x 1 when work/touch time and x -1 when wait time

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment