Milestone 2 - Analyze, Clean-Up and Visualize Excel Data

Below are the screenshots of our data:

Original data set: http://gyazo.com/c01a1d864f7b773582d949540815f2a7

First iteration:
http://gyazo.com/a681a0df4eb070acfced98e5b4eeecd2
http://gyazo.com/51781fe39062f343db1eb6ae6063b56f
http://gyazo.com/aa7e152e6ffb31bddc254ebea804949a
http://gyazo.com/aa7e152e6ffb31bddc254ebea804949a
http://gyazo.com/2c835c7b218671d5e1e174ce3b88d380
http://gyazo.com/f899545fe3fa5face5fe59fb90fb7535

Second iteration:
some macro coding to clean up data: http://gyazo.com/e83706488701f1278700f2abc21ab6d7
http://gyazo.com/2ab9d02e041fe931e1d4ef97c3f31ed9
http://gyazo.com/a15ab73a1ddd071a233716bb41d73d59
http://gyazo.com/d87aebc5737c362f3ac7a41e747fde7a
http://gyazo.com/d87aebc5737c362f3ac7a41e747fde7a
http://gyazo.com/e062fb5f03ab73f4a1951037c7c66a03
http://gyazo.com/6750408147865d4a2bdcde5b26fda7b7
http://gyazo.com/6750408147865d4a2bdcde5b26fda7b7
http://gyazo.com/9b470dca5d183cc090636b62da54d5f7

Third iteration:
http://gyazo.com/7ebc3c62949213ae075e56233228c7de
http://gyazo.com/b6ea800a181df6803f6bcf6807a63be6
http://gyazo.com/ac44cf4fb26242bf26953b07718c7d50
http://gyazo.com/b38b8a072cc977f735703176f08ab7a4
http://gyazo.com/8b306557efecef08af0a7d3ed3c2b1b4
http://gyazo.com/fb614853f000954ea85b41f5cb6092ca
http://gyazo.com/1393ab3dbfe18d4936fece4e526f7142
http://gyazo.com/8c3dbf17158aa21a328b09a5e0b639d4

Fourth iteration:
http://gyazo.com/58933206ab8538ec8c9fe1454e2d30ae
http://gyazo.com/2a979beb000274490173aa29ca0f9ca0
http://gyazo.com/29dffdee33100970b2ad8829e56fa152
http://gyazo.com/1f9a5233a71a7efedbfe94f3c40b5d21
http://gyazo.com/dcbe94a19b0d708b3f5d2937007b0f88
http://gyazo.com/2ed596064008ccd866ecfe9d6e8370f5
http://gyazo.com/8d2449c344b571dcc1038771207e61f0
http://gyazo.com/f32619dc3411b11725d69ee222567e17