Skip to content

Instantly share code, notes, and snippets.

@hamhands
Created August 21, 2015 20:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hamhands/738aa2a2e86ac5264d48 to your computer and use it in GitHub Desktop.
Save hamhands/738aa2a2e86ac5264d48 to your computer and use it in GitHub Desktop.
Contract tracking metrics
Order Step Year Total Valid Average_days Less_than_seven Eight_to_fifteen Fiteen_to_thirty More_than_thirty
1 Dept review 2011 39 22.1 8 4 15 12
1 Dept review 2012 119 25.2 34 22 36 27
1 Dept review 2013 143 23.4 62 15 30 36
1 Dept review 2014 128 21.5 53 16 28 31
1 Dept review 2015 67 12 44 6 5 12
2 Review sent to county 2011 37 7.9 25 3 7 2
2 Review sent to county 2012 111 8.9 84 8 6 13
2 Review sent to county 2013 144 4 122 15 5 2
2 Review sent to county 2014 124 7.5 105 4 5 10
2 Review sent to county 2015 62 2.5 57 3 1 1
3 County advertises 2011 25 15.8 7 7 8 3
3 County advertises 2012 94 19.6 25 19 34 16
3 County advertises 2013 90 23.8 14 19 39 18
3 County advertises 2014 74 24.5 8 12 36 18
3 County advertises 2015 31 34.6 0 5 13 13
4 Advertise period 2011 22 19.2 1 2 19 0
4 Advertise period 2012 105 21.8 23 19 54 9
4 Advertise period 2013 95 14.8 24 26 42 3
4 Advertise period 2014 91 16.6 28 10 47 6
4 Advertise period 2015 41 10.3 31 4 5 1
5 Bids tabbed 2011 22 2.5 20 2 0 0
5 Bids tabbed 2012 94 3.4 78 13 3 0
5 Bids tabbed 2013 94 2.6 87 4 2 1
5 Bids tabbed 2014 82 3.4 72 5 4 1
5 Bids tabbed 2015 44 2.8 38 5 1 0
6 Tabs sent to dept 2011 20 0.8 20 0 0 0
6 Tabs sent to dept 2012 92 -0.2 89 2 1 0
6 Tabs sent to dept 2013 94 0.7 92 2 0 0
6 Tabs sent to dept 2014 83 1.4 80 1 2 0
6 Tabs sent to dept 2015 44 0.4 44 0 0 0
7 Awardee selected 2011 13 6.1 11 1 0 1
7 Awardee selected 2012 87 15.7 41 16 18 12
7 Awardee selected 2013 92 15.6 35 19 25 13
7 Awardee selected 2014 81 18.6 34 17 15 15
7 Awardee selected 2015 46 11.8 24 9 7 6
8 Award sent to county 2011 11 1.4 11 0 0 0
8 Award sent to county 2012 83 2.4 80 0 1 2
8 Award sent to county 2013 88 0.7 87 1 0 0
8 Award sent to county 2014 72 1.3 69 2 1 0
8 Award sent to county 2015 43 1.6 43 0 0 0
9 County to EORC 2011 5 0.2 5 0 0 0
9 County to EORC 2012 71 15.5 44 7 7 13
9 County to EORC 2013 63 6.4 47 6 8 2
9 County to EORC 2014 49 24.7 24 5 7 13
9 County to EORC 2015 32 11 24 2 1 5
10 In EORC 2011 2 15.5 1 0 1 0
10 In EORC 2012 53 26.7 9 4 22 18
10 In EORC 2013 76 26.1 6 13 31 26
10 In EORC 2014 45 23.9 0 5 29 11
10 In EORC 2015 38 30 1 0 22 15
11 EORC to controller 2011 0 0 0 0 0 0
11 EORC to controller 2012 47 58 0 2 13 32
11 EORC to controller 2013 67 43.4 1 3 12 51
11 EORC to controller 2014 46 81.8 0 0 1 45
11 EORC to controller 2015 36 110.1 0 0 0 36
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment