Skip to content

Instantly share code, notes, and snippets.

@ryanswanstrom
Created December 29, 2013 15:14
Show Gist options
  • Save ryanswanstrom/8171376 to your computer and use it in GitHub Desktop.
Save ryanswanstrom/8171376 to your computer and use it in GitHub Desktop.
An example of a defect file complete data with 5 applications, each released every month for 14 straight months
AppID AppName ReleaseDate DevHours TestHours SITDefects UATDefects ProdDefects ReportDate
app1 Application 1 2012-10-02 57 0 29 11 3 2012-10-24
app2 Application 2 2012-10-02 198 0 88 17 13 2012-10-24
app3 Application 3 2012-10-02 354 0 134 25 17 2012-10-24
app4 Application 4 2012-10-02 358 0 117 36 20 2012-10-24
app5 Application 5 2012-10-02 695 0 227 55 32 2012-10-24
app1 Application 1 2012-11-02 109 0 25 16 1 2012-11-24
app2 Application 2 2012-11-02 213 0 53 17 13 2012-11-24
app3 Application 3 2012-11-02 412 0 158 43 15 2012-11-24
app4 Application 4 2012-11-02 357 0 123 35 18 2012-11-24
app5 Application 5 2012-11-02 455 0 148 40 26 2012-11-24
app1 Application 1 2012-12-03 96 0 43 9 0 2012-12-25
app2 Application 2 2012-12-03 166 0 56 6 4 2012-12-25
app3 Application 3 2012-12-03 347 0 104 32 17 2012-12-25
app4 Application 4 2012-12-03 525 0 198 51 21 2012-12-25
app5 Application 5 2012-12-03 427 0 161 34 24 2012-12-25
app1 Application 1 2013-01-03 112 0 25 15 8 2013-01-25
app2 Application 2 2013-01-03 186 0 86 17 6 2013-01-25
app3 Application 3 2013-01-03 353 0 119 31 13 2013-01-25
app4 Application 4 2013-01-03 205 0 87 10 12 2013-01-25
app5 Application 5 2013-01-03 466 0 175 35 25 2013-01-25
app1 Application 1 2013-02-02 80 0 48 1 7 2013-02-24
app2 Application 2 2013-02-02 131 0 43 9 4 2013-02-24
app3 Application 3 2013-02-02 313 0 91 30 18 2013-02-24
app4 Application 4 2013-02-02 393 0 121 34 17 2013-02-24
app5 Application 5 2013-02-02 445 0 134 43 26 2013-02-24
app1 Application 1 2013-03-05 58 0 -6 9 -3 2013-03-27
app2 Application 2 2013-03-05 203 0 52 24 13 2013-03-27
app3 Application 3 2013-03-05 355 0 93 20 13 2013-03-27
app4 Application 4 2013-03-05 481 0 161 48 22 2013-03-27
app5 Application 5 2013-03-05 580 0 193 53 25 2013-03-27
app1 Application 1 2013-04-05 59 0 4 3 0 2013-04-27
app2 Application 2 2013-04-05 132 0 54 13 5 2013-04-27
app3 Application 3 2013-04-05 413 0 113 28 23 2013-04-27
app4 Application 4 2013-04-05 225 0 87 25 10 2013-04-27
app5 Application 5 2013-04-05 429 0 167 39 23 2013-04-27
app1 Application 1 2013-05-06 98 0 12 7 5 2013-05-28
app2 Application 2 2013-05-06 145 0 36 13 6 2013-05-28
app3 Application 3 2013-05-06 436 0 126 29 23 2013-05-28
app4 Application 4 2013-05-06 559 0 177 51 31 2013-05-28
app5 Application 5 2013-05-06 604 0 190 41 32 2013-05-28
app1 Application 1 2013-06-06 58 0 8 9 6 2013-06-28
app2 Application 2 2013-06-06 205 0 47 14 12 2013-06-28
app3 Application 3 2013-06-06 229 0 51 11 12 2013-06-28
app4 Application 4 2013-06-06 298 0 76 25 13 2013-06-28
app5 Application 5 2013-06-06 706 0 240 62 32 2013-06-28
app1 Application 1 2013-07-06 144 0 40 5 3 2013-07-28
app2 Application 2 2013-07-06 284 0 70 23 11 2013-07-28
app3 Application 3 2013-07-06 298 0 118 26 18 2013-07-28
app4 Application 4 2013-07-06 568 0 200 56 31 2013-07-28
app5 Application 5 2013-07-06 605 0 217 58 32 2013-07-28
app1 Application 1 2013-08-06 62 0 30 4 0 2013-08-28
app2 Application 2 2013-08-06 110 0 45 18 5 2013-08-28
app3 Application 3 2013-08-06 409 0 132 37 24 2013-08-28
app4 Application 4 2013-08-06 533 0 180 37 28 2013-08-28
app5 Application 5 2013-08-06 561 0 177 46 30 2013-08-28
app1 Application 1 2013-09-06 103 0 11 5 2 2013-09-28
app2 Application 2 2013-09-06 210 0 93 17 10 2013-09-28
app3 Application 3 2013-09-06 170 0 40 23 12 2013-09-28
app4 Application 4 2013-09-06 248 0 79 10 15 2013-09-28
app5 Application 5 2013-09-06 538 0 166 37 21 2013-09-28
app1 Application 1 2013-10-07 123 0 23 8 1 2013-10-29
app2 Application 2 2013-10-07 281 0 112 18 18 2013-10-29
app3 Application 3 2013-10-07 434 0 141 28 23 2013-10-29
app4 Application 4 2013-10-07 314 0 100 23 18 2013-10-29
app5 Application 5 2013-10-07 492 0 148 41 27 2013-10-29
app1 Application 1 2013-11-07 105 0 42 8 3 2013-11-29
app2 Application 2 2013-11-07 111 0 26 15 8 2013-11-29
app3 Application 3 2013-11-07 190 0 84 6 7 2013-11-29
app4 Application 4 2013-11-07 523 0 171 49 21 2013-11-29
app5 Application 5 2013-11-07 459 0 176 30 18 2013-11-29
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment