Notes on the trail my work has left behind

In the year between 04/24/2014 and 04/23/2015, I billed 7 clients a total of 1184 hours, working on 25 distinct projects.

File Changes committed to git

Total number of changes recorded by git through the year, grouped by file type.

File ext. Total lines changed
html 43094
css 33627
js 14941
coffee 14404
py 10702
php 10678
groovy 6400
sql 1490

All caveats about file changes not having much to do with productivity apply. This is intended more to illustrate relative totals.

HTML and CSS groups include templates and pre-processed files such as Jinja/Django tempaltes and Less/Sass.

dayofweek,hours
0,4.181836734693878
1,4.8566666666666665
2,5.148400000000001
3,4.9642
4,4.073333333333333
5,2.4045454545454548
6,0.86

Average hours logged by day

Between 04/24/2014 and 04/23/2015.

Average calculated for all days where hours were logged, not all days that appeared in the period.

Time amount represents time I billed clients doing work directly related to their projects.

Data pulled from Harvest's API. Scripts used to generate datasets.

hour,percent
0,0.27472527472527475
4,0.27472527472527475
5,2.7472527472527473
6,4.945054945054945
7,6.593406593406594
8,28.57142857142857
9,46.97802197802198
10,51.373626373626365
11,56.86813186813187
12,44.78021978021978
13,54.395604395604394
14,56.86813186813187
15,60.43956043956044
16,53.84615384615385
17,28.296703296703296
18,11.813186813186812
19,5.4945054945054945
20,4.1208791208791204
21,3.8461538461538463
22,2.197802197802198
23,0.8241758241758242

Percentage of hour with billable time logged

Showing the percentage an hour contained billable time between 04/24/2014 and 04/23/2015.

It would perhaps be more intereseting to see what percentage of each hour had been logged as billable time.

Data pulled from Harvest's API. Scripts used to generate datasets.

date,clientid,hours
2014-04-24,1803519,2.5
2014-04-25,1803519,2.5
2014-04-28,1323495,0.5
2014-04-28,1803519,0.5
2014-04-28,1323495,5.75
2014-04-29,1803519,0.5
2014-04-29,1323495,5.9399999999999995
2014-04-30,1803519,0.55
2014-04-30,1323495,6.32
2014-05-01,1803519,0.36
2014-05-01,1323495,5.75
2014-05-02,1803519,3.8
2014-05-02,1323495,2.39
2014-05-05,1803519,0.5
2014-05-05,1323495,5.58
2014-05-06,1323495,4.2
2014-05-07,1803519,1.46
2014-05-07,1323495,4.98
2014-05-08,1323495,5.36
2014-05-09,1803519,2.74
2014-05-09,1323495,2.5
2014-05-10,1803519,0.5
2014-05-12,1803519,0.75
2014-05-12,1323495,1.0
2014-05-13,1323495,3.5
2014-05-14,1323495,3.75
2014-05-14,1803519,1.5
2014-05-15,1323495,6.72
2014-05-16,1323495,5.109999999999999
2014-05-19,1323495,1.5
2014-05-19,1803519,0.5
2014-05-19,1323495,3.5
2014-05-20,1323495,7.23
2014-05-22,1323495,0.5
2014-05-22,1803519,1.0
2014-05-22,1323495,3.5
2014-05-23,1323495,3.5
2014-05-24,1803519,0.75
2014-05-27,1323495,5.0
2014-05-28,1323495,5.9
2014-05-29,1323495,6.5
2014-05-30,1323495,3.57
2014-05-30,1803519,1.0
2014-05-31,1323495,1.0
2014-06-02,1323495,4.25
2014-06-02,1803519,0.25
2014-06-03,1323495,4.0
2014-06-03,1803519,0.5
2014-06-04,1323495,4.25
2014-06-04,1803519,1.0
2014-06-05,1323495,4.5
2014-06-05,1803519,1.0
2014-06-06,1323495,3.75
2014-06-09,1323495,4.92
2014-06-10,1323495,6.25
2014-06-11,1323495,6.1000000000000005
2014-06-12,1323495,4.0
2014-06-13,1323495,2.33
2014-06-16,1323495,1.5
2014-06-17,1323495,3.9
2014-06-17,2565858,0.5
2014-06-18,1323495,3.2
2014-06-18,2565858,1.5
2014-06-18,1803519,1.3
2014-06-19,1323495,3.4
2014-06-19,2565858,2.4
2014-06-20,1323495,0.8
2014-06-20,2565858,0.75
2014-06-20,1323495,2.5
2014-06-21,1803519,3.65
2014-06-23,1323495,6.0
2014-06-23,1803519,0.5
2014-06-24,1323495,0.5
2014-06-24,2565858,0.2
2014-06-24,1323495,4.5
2014-06-24,1803519,0.1
2014-06-25,1323495,5.0
2014-06-25,1803519,1.37
2014-06-26,1323495,1.15
2014-06-26,1803519,1.0
2014-06-26,2587400,1.03
2014-06-27,1323495,0.5
2014-06-27,1803519,1.0
2014-06-27,2587400,3.0
2014-06-29,2587400,1.0
2014-06-30,1323495,1.8
2014-06-30,1803519,0.5
2014-06-30,2587400,3.5300000000000002
2014-07-01,2565858,0.3
2014-07-01,1323495,0.7
2014-07-01,2587400,5.699999999999999
2014-07-02,2565858,0.25
2014-07-02,1323495,0.3
2014-07-02,2587400,5.0
2014-07-03,1323495,4.0
2014-07-03,2587400,2.4
2014-07-07,1323495,2.2
2014-07-07,2587400,3.5
2014-07-08,1323495,1.0
2014-07-08,2587400,1.0
2014-07-09,1323495,2.42
2014-07-09,2587400,3.0
2014-07-10,1323495,2.2
2014-07-10,2587400,2.0
2014-07-11,2565858,0.5
2014-07-11,2587400,4.0
2014-07-14,2587400,3.5
2014-07-15,1323495,3.5
2014-07-15,1803519,0.25
2014-07-15,2587400,5.1
2014-07-16,1323495,4.1
2014-07-16,2587400,1.7
2014-07-17,2565858,0.25
2014-07-17,1323495,5.5
2014-07-17,1803519,0.25
2014-07-18,2565858,0.8
2014-07-18,1323495,3.15
2014-07-18,1803519,2.75
2014-07-21,1323495,1.0
2014-07-21,1803519,0.5
2014-07-21,1323494,2.0
2014-07-22,1323495,2.42
2014-07-22,1803519,0.4
2014-07-22,1323494,4.0
2014-07-23,1323495,3.0
2014-07-23,1323494,2.0
2014-07-24,1323495,2.0
2014-07-24,1803519,1.0
2014-07-24,1323494,2.5
2014-07-25,1323495,1.5
2014-07-25,1803519,0.5
2014-07-25,2587400,1.0
2014-07-25,1323494,2.0
2014-07-28,1803519,0.25
2014-07-28,1323494,2.5
2014-07-29,1323495,4.0
2014-07-29,1803519,0.5
2014-07-29,1323494,0.5
2014-07-30,1323495,1.0
2014-07-30,1803519,0.5
2014-07-30,1323494,2.5
2014-07-31,1323494,3.5
2014-08-01,1323495,0.4
2014-08-01,1323494,1.5
2014-08-04,1323495,1.0
2014-08-04,1803519,0.75
2014-08-04,1323494,1.0
2014-08-05,1323495,0.3
2014-08-05,1803519,0.5
2014-08-05,1323494,4.0
2014-08-06,1323494,5.5
2014-08-07,1323495,3.5
2014-08-07,1803519,0.4
2014-08-07,1323494,2.5
2014-08-08,1323495,2.7
2014-08-08,1803519,0.75
2014-08-08,2565858,1.0
2014-08-09,2565858,2.25
2014-08-11,1323495,1.5
2014-08-11,1803519,1.2
2014-08-11,2565858,2.4
2014-08-12,1323495,4.0
2014-08-12,1803519,0.4
2014-08-13,1323495,2.8
2014-08-13,1803519,0.9
2014-08-13,1323494,2.5
2014-08-14,1323495,4.7299999999999995
2014-08-14,1323494,1.8
2014-08-15,1323495,3.2
2014-08-15,1323494,1.9
2014-08-18,1323495,4.5
2014-08-19,1323495,3.5
2014-08-19,2565858,0.5
2014-08-20,1323495,4.75
2014-08-20,1803519,1.0
2014-08-21,1323495,0.66
2014-08-21,1803519,2.8
2014-08-21,1323494,1.5
2014-08-22,1323494,3.0
2014-08-25,1323495,2.3
2014-08-25,1803519,1.25
2014-08-25,1323494,3.8
2014-08-26,1323495,2.0
2014-08-26,1803519,1.4
2014-08-26,1323494,1.7
2014-08-27,1323495,2.95
2014-08-27,1323494,1.3
2014-08-28,1323495,4.88
2014-08-28,1803519,0.5
2014-08-29,1323495,2.0
2014-08-29,2565858,1.5
2014-09-02,1323495,4.6
2014-09-02,2565858,0.63
2014-09-03,1323495,5.01
2014-09-03,1803519,0.33
2014-09-03,1323494,3.0
2014-09-04,1323495,2.5300000000000002
2014-09-04,1323494,2.25
2014-09-05,1323495,2.0
2014-09-05,1803519,0.5
2014-09-08,1803519,0.4
2014-09-08,1323494,1.75
2014-09-09,1323495,3.52
2014-09-09,1323494,0.7
2014-09-09,39310,2.0
2014-09-10,1323495,1.7
2014-09-10,1323494,3.54
2014-09-10,39310,1.0
2014-09-11,1323495,2.9999999999999996
2014-09-11,1323494,1.4
2014-09-11,39310,2.5
2014-09-12,1323495,1.0
2014-09-12,1803519,0.3
2014-09-12,1323494,2.73
2014-09-12,39310,1.7
2014-09-13,1323494,2.5
2014-09-15,1323494,5.8
2014-09-16,1323495,2.7
2014-09-17,1323495,3.4699999999999998
2014-09-17,1803519,1.0
2014-09-17,1323494,2.4
2014-09-18,1323495,2.7
2014-09-19,1323495,2.1
2014-09-20,1323494,0.8
2014-09-21,1323494,0.8
2014-09-22,1323494,2.0999999999999996
2014-09-22,1323495,2.45
2014-09-23,1323495,0.2
2014-09-23,1323494,3.0999999999999996
2014-09-23,1323495,2.8
2014-09-24,1323494,1.19
2014-09-24,1323495,5.6
2014-09-25,1323495,3.17
2014-09-26,1323495,0.5
2014-09-29,1803519,0.55
2014-09-29,1323495,3.73
2014-09-30,1323495,1.4
2014-10-01,1323495,2.0
2014-10-02,1323495,4.4
2014-10-03,1323495,2.8
2014-10-06,1323494,1.0
2014-10-06,1323495,0.75
2014-10-07,1323494,2.0
2014-10-08,1323494,3.0
2014-10-09,1803519,1.0
2014-10-09,1323494,2.0
2014-10-09,1323495,1.2
2014-10-10,1323495,2.17
2014-10-10,1803519,1.0
2014-10-13,1803519,4.1
2014-10-14,1803519,3.0
2014-10-15,1323494,4.53
2014-10-15,1803519,3.6
2014-10-16,1323495,2.5
2014-10-16,1803519,1.5
2014-10-17,1323495,2.5
2014-10-17,1803519,1.5
2014-10-18,1803519,5.0
2014-10-20,1323495,1.0
2014-10-20,1323494,2.25
2014-10-21,1323495,1.0
2014-10-21,1803519,6.9
2014-10-22,1323495,0.6
2014-10-22,1803519,1.0
2014-10-22,1323494,4.2
2014-10-23,1323495,1.0
2014-10-23,1803519,1.8
2014-10-23,1323494,2.4
2014-10-24,1803519,0.15
2014-10-24,1323494,5.4
2014-10-27,1803519,0.5
2014-10-27,1323494,3.0
2014-10-28,1323495,0.5
2014-10-28,1323494,4.97
2014-10-29,1323494,1.0
2014-10-30,1323495,1.0
2014-10-30,1323494,0.75
2014-10-31,1803519,0.5
2014-10-31,1323494,1.33
2014-11-03,1323494,0.5
2014-11-04,1323494,2.5
2014-11-05,1323494,3.0
2014-11-06,1803519,2.0
2014-11-06,1323494,4.5
2014-11-07,1323494,2.25
2014-11-10,1323495,1.8
2014-11-10,1323494,2.0
2014-11-11,1323495,4.0
2014-11-11,1803519,0.5
2014-11-12,1323495,4.6
2014-11-13,1323495,1.4
2014-11-14,1323495,1.2
2014-11-14,2565858,2.0
2014-11-17,1323495,1.0
2014-11-18,1323495,2.0
2014-11-19,1323495,2.5
2014-11-19,1323494,2.5
2014-11-20,1323495,6.0
2014-11-20,1323494,0.5
2014-11-21,1323495,4.6
2014-11-24,1323495,3.0
2014-11-24,1323494,1.8
2014-11-25,1323495,3.7
2014-11-25,1323494,1.5
2014-11-26,1323494,1.3
2014-11-28,1323495,1.0
2014-11-28,1323494,1.4
2014-12-01,1323495,0.5
2014-12-02,1323495,1.5
2014-12-02,1323494,1.0
2014-12-03,1323495,2.8
2014-12-04,1323495,4.7
2014-12-08,1323495,2.0
2014-12-08,1323494,2.3
2014-12-09,1323495,3.0
2014-12-09,1323494,2.2
2014-12-10,1323495,4.4
2014-12-10,1323494,1.5
2014-12-11,1323495,6.25
2014-12-12,1323495,4.0
2014-12-15,1323495,4.8
2014-12-15,1803519,0.7
2014-12-16,1323495,4.5
2014-12-17,1323495,5.5
2014-12-17,1803519,0.5
2014-12-18,1323495,3.0
2014-12-19,1323495,3.7
2014-12-23,1323495,4.0
2014-12-29,1323495,4.0
2014-12-30,1323495,3.0
2014-12-31,1323495,4.5
2015-01-02,1323495,2.0
2015-01-05,1323495,6.25
2015-01-05,1803519,0.25
2015-01-06,1323495,6.25
2015-01-07,1323495,5.5
2015-01-08,1323495,5.4
2015-01-09,1323495,5.3
2015-01-12,1323495,5.0
2015-01-13,1323495,5.5
2015-01-14,1323495,2.25
2015-01-15,1323495,6.0
2015-01-16,1323495,3.8
2015-01-16,1803519,2.0
2015-01-17,1803519,2.0
2015-01-19,1323495,2.5
2015-01-19,1803519,4.0
2015-01-20,1323495,1.5
2015-01-20,1803519,3.0
2015-01-21,1323495,2.0
2015-01-21,1803519,5.0
2015-01-22,1323495,2.5
2015-01-22,1803519,4.0
2015-01-23,1323495,2.8
2015-01-23,1803519,1.5
2015-01-26,1323495,4.0
2015-01-26,1803519,0.7
2015-01-27,1323495,5.5
2015-01-27,1803519,0.5
2015-01-28,1323495,3.5
2015-01-28,1803519,0.75
2015-01-29,1323495,4.5
2015-01-30,1323495,5.0
2015-02-02,1323495,5.5
2015-02-03,1323495,3.0
2015-02-04,1323495,2.5
2015-02-04,2565858,2.0
2015-02-05,1323495,5.0
2015-02-06,1323495,4.0
2015-02-06,2565858,2.0
2015-02-09,1323495,4.0
2015-02-10,1323495,2.0
2015-02-11,1323495,4.0
2015-02-12,1323495,5.0
2015-02-13,1323495,5.0
2015-02-16,1323495,2.0
2015-02-18,1323495,5.5
2015-02-19,1323495,5.5
2015-02-20,1323495,5.5
2015-02-23,1323495,7.0
2015-02-24,1323495,5.0
2015-02-25,1323495,6.0
2015-02-26,1323495,5.0
2015-02-27,1323495,5.0
2015-02-27,1803519,0.5
2015-02-28,1803519,1.0
2015-02-28,2565858,3.0
2015-03-01,2565858,1.0
2015-03-02,1323495,3.0
2015-03-02,1803519,1.0
2015-03-03,1323495,3.0
2015-03-03,1803519,2.0
2015-03-04,1323495,2.7
2015-03-04,1803519,3.0
2015-03-05,1323495,3.0
2015-03-05,1803519,1.0
2015-03-06,1323495,1.5
2015-03-06,1803519,1.0
2015-03-08,1803519,1.0
2015-03-09,1323495,4.0
2015-03-09,1803519,0.5
2015-03-10,1323495,3.5
2015-03-10,1803519,1.0
2015-03-10,3277324,1.5
2015-03-11,1323495,4.5
2015-03-11,2565858,0.5
2015-03-11,3277324,1.5
2015-03-12,1323495,4.5
2015-03-13,1323495,3.25
2015-03-13,1803519,1.0
2015-03-13,3277324,1.5
2015-03-16,1323495,5.25
2015-03-16,3277324,0.3
2015-03-17,1323495,4.8
2015-03-18,1323495,3.95
2015-03-18,1803519,0.5
2015-03-19,1323495,4.0
2015-03-20,1323495,1.6
2015-03-23,1323495,3.0
2015-03-24,1323495,4.8
2015-03-24,1803519,1.5
2015-03-25,1323495,3.5
2015-03-25,1803519,1.0
2015-03-26,1323495,3.35
2015-03-26,2565858,1.7
2015-03-30,1323495,3.0
2015-03-30,3277324,0.3
2015-03-30,2565858,0.25
2015-03-31,1323495,4.5
2015-03-31,3277324,2.0
2015-04-01,1323495,3.85
2015-04-01,3277324,1.7
2015-04-02,1323495,4.37
2015-04-02,3277324,1.5
2015-04-02,2565858,0.6
2015-04-03,1323495,1.2
2015-04-03,3277324,4.9
2015-04-04,3277324,2.0
2015-04-04,2565858,2.0
2015-04-06,1323495,2.6
2015-04-06,3277324,0.7
2015-04-07,1323495,2.1
2015-04-07,1803519,0.4
2015-04-07,3277324,3.73
2015-04-07,2565858,3.0
2015-04-08,1323495,3.5
2015-04-08,2565858,2.8000000000000003
2015-04-09,1323495,4.0
2015-04-09,2565858,2.8000000000000003
2015-04-10,1323495,4.0
2015-04-10,3277324,1.0
2015-04-10,2565858,0.6
2015-04-12,2565858,0.5
2015-04-13,1323495,2.5
2015-04-13,3277324,2.3
2015-04-13,2565858,0.3
2015-04-14,1323495,2.5
2015-04-14,3277324,3.0
2015-04-15,1323495,2.5
2015-04-15,3277324,2.0
2015-04-16,1323495,1.2999999999999998
2015-04-16,3277324,3.0
2015-04-16,2565858,1.0
2015-04-17,1323495,4.1
2015-04-17,3277324,1.25
2015-04-20,1323495,0.7
2015-04-20,3277324,1.75
2015-04-21,1323495,2.5
2015-04-21,3277324,1.7
2015-04-22,1323495,2.0
2015-04-22,3277324,2.0
2015-04-23,1323495,3.5
2015-04-23,2565858,0.7

Daily billable hours recorded for each client

Showing hours of billable time by day, separated by client between 04/24/2014 and 04/23/2015.

Data pulled from Harvest's API. Scripts used to generate datasets.