Replies: 74
| visibility 1417
|
Scout Team [194]
TigerPulse: 100%
12
|
National Championship Visualized
Jan 19, 2017, 9:15 AM
|
|
I don't post very often, but I wanted to share something I've been working on. I wanted to create something that would allow fans to see every play of the National Championship game, search for specific players, and click on any play to see the actual footage.
I've created this tool for that purpose: http://tabsoft.co/2jcmCM9
Hover over any play to see details, click on any play to see the actual footage, or use the highlight search to find the playmaker in the game.
|
|
|
 |
Varsity [238]
TigerPulse: 100%
13
|
Re: National Championship Visualized
Jan 19, 2017, 9:50 AM
|
|
Thanks man, this is a masterpiece !
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: National Championship Visualized
Jan 19, 2017, 9:51 AM
|
|
Thanks, glad you like it! It was definitely a labor of love to create the play by play data and link it to the game. Although it wasn't so bad watching that awesome win over and over though!
|
|
|
|
 |
Orange Phenom [14990]
TigerPulse: 82%
49
Posts: 23439
Joined: 1998
|
Re: National Championship Visualized
Jan 19, 2017, 9:56 AM
|
|
awesome job
|
|
|
|
 |
Ultimate Tiger [33233]
TigerPulse: 100%
56
Posts: 15102
Joined: 2011
|
THAT is the most ridiculously awesome thing I have ever seen
Jan 19, 2017, 9:54 AM
|
|
in regards to breaking down a football game.
And we get access to it for free ! ! !
How long did it take you to compile all of this ?
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: THAT is the most ridiculously awesome thing I have ever seen
Jan 19, 2017, 10:00 AM
|
|
It took several nights of working on it. Building out the play by play data and then linking it with youtube took the longest. I wanted to get it out sooner, but I was exhausted last week after coming back from the game.
|
|
|
|
 |
Game Changer [1973]
TigerPulse: 100%
31
|
Incredible!!! A sincere thanks!***
Jan 20, 2017, 10:12 PM
|
|
|
|
|
|
 |
Paw Warrior [4697]
TigerPulse: 100%
37
|
Re: National Championship Visualized
Jan 19, 2017, 9:56 AM
|
|
Wow. I'm impressed man. That's next-level right there!
|
|
|
|
 |
Ultimate Clemson Legend [101533]
TigerPulse: 100%
64
Posts: 29887
Joined: 2005
|
That's impressive work dood. Finally, somebody around here
Jan 19, 2017, 9:59 AM
|
|
with some brains.
|
|
|
|
 |
All-Time Great [88591]
TigerPulse: 100%
63
Posts: 48315
Joined: 2007
|
Re: That's impressive work dood. Finally, somebody around here
Jan 19, 2017, 10:02 AM
|
|
I have some brians, does that count?
|
|
|
|
 |
Ultimate Clemson Legend [101533]
TigerPulse: 100%
64
Posts: 29887
Joined: 2005
|
Didn't you loose 1/3 of your
Jan 19, 2017, 10:05 AM
|
|
skin in a motorcycle accident?
Sorry, but nice try.
|
|
|
|
 |
Ring of Honor [22911]
TigerPulse: 100%
53
Posts: 15724
Joined: 2012
|
|
|
|
 |
CU Medallion [18901]
TigerPulse: 100%
52
Posts: 13655
Joined: 2003
|
That is really awesome***
Jan 19, 2017, 10:00 AM
|
|
|
|
|
|
 |
Game Changer [1816]
TigerPulse: 96%
31
|
Very, very cool.
Jan 19, 2017, 10:04 AM
|
|
Very curious how you made this. I'm a software developer. I'm not familiar with Tableau but that looks to be the primary tool involved, no? I can't imagine they had a pre-made football play-by-play visualization, so you must have put this particular visual together from some kind of generalized building blocks right?
Regardless, very, very cool man. I'm super impressed. Not only is a cool visual on it's own, but the interactivity pushes it over the top.
Please consider posting this to the College Football subreddit (reddit.com/r/cfb). Those guys over there would love this.
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: Very, very cool.
Jan 19, 2017, 10:22 AM
|
|
Thanks! My coworker actually posted it to /r/cfb https://www.reddit.com/r/CFB/comments/5owtr8/a_play_by_play_vizualization_of_the_national/
Yes, this was created using Tableau. I created it by building out the data in a way that allows Tableau to plot two points and connect them. So for each play in the game, there is a play number, quarter, time, and path of 0 or 1. That allows it to plot the points and connect them.
|
|
|
|
 |
110%er [3987]
TigerPulse: 100%
35
|
As a fledgling software developer, this gives me ideas and
Jan 20, 2017, 5:12 PM
|
|
inspiration. Thanks! Gonna look up Tableau and see what makes it tick. Thanks and excellent work!
|
|
|
|
 |
110%er [5249]
TigerPulse: 100%
38
|
Very impressive
Jan 19, 2017, 10:09 AM
|
|
Have you thought about changing directional arrows based on lost yardage or penalties?
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: Very impressive
Jan 19, 2017, 10:23 AM
|
|
That's a good point. I think traditionally "drive charts" show the arrow for the way the team is going regardless of whether they gained or lost yardage, so that's why I did that.
|
|
|
|
 |
Ultimate Tiger [33593]
TigerPulse: 100%
56
Posts: 36030
Joined: 2003
|
A post that has purpose. .well done***
Jan 19, 2017, 10:12 AM
|
|
|
|
|
|
 |
All-In [10769]
TigerPulse: 100%
45
|
You should win a Nobel prize for this!
Jan 19, 2017, 10:13 AM
|
|
Have you done the linear regression analysis on each of the points yet?
|
|
|
|
 |
All-Conference [420]
TigerPulse: 100%
17
|
Fantastic! Thanks for sharing***
Jan 19, 2017, 10:23 AM
|
|
|
|
|
|
 |
Rival Killer [3022]
TigerPulse: 100%
33
|
Nice work! Would be cool to make a poster out of that.***
Jan 19, 2017, 10:27 AM
|
|
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: Nice work! Would be cool to make a poster out of that.***
Jan 19, 2017, 10:29 AM
|
|
Yep, that's actually the original reason I did it. I want to make a poster for my son's room.
|
|
|
|
 |
Orange Immortal [65806]
TigerPulse: 100%
60
Posts: 24268
Joined: 2005
|
HOF or BUST!!!!!!!!!!
Jan 19, 2017, 10:28 AM
|
|
this has to be the single best post on this board in quite a while!
+1
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: HOF or BUST!!!!!!!!!!
Jan 19, 2017, 10:29 AM
|
|
Haha thanks! I'm glad I could share it with y'all.
|
|
|
|
 |
Ultimate Clemson Legend [101533]
TigerPulse: 100%
64
Posts: 29887
Joined: 2005
|
Deer sirvizalot
Jan 19, 2017, 10:32 AM
|
|
Wood you be a princess and create this for all future Clemson Tigers Men's Varsity Football games?
Oh, and all future Men's Varsity Basketball games as well?
TIA in advance!
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: Deer sirvizalot
Jan 19, 2017, 10:35 AM
|
|
Haha I wish. It was very labor intensive to build it out. Maybe I can figure out a way to automate some of it.
|
|
|
|
 |
Ultimate Clemson Legend [101533]
TigerPulse: 100%
64
Posts: 29887
Joined: 2005
|
Can you outsource to India?
Jan 19, 2017, 10:45 AM
|
|
I won't tell Trump.
|
|
|
|
 |
CU Medallion [20831]
TigerPulse: 100%
52
|
Ridiculously Outstanding Job!! Thanks for this!!***
Jan 20, 2017, 9:56 AM
[ in reply to Re: Deer sirvizalot ] |
|
|
|
|
|
 |
110%er [7719]
TigerPulse: 100%
42
|
Re: National Championship Visualized
Jan 19, 2017, 10:34 AM
|
|
Holy #### man that is amazing...
Thanks!
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: National Championship Visualized
Jan 19, 2017, 1:43 PM
|
|
Thanks glad people have enjoyed it! I wanted to have a way to find any part of the game easily, so I thought I'd share with everyone.
|
|
|
|
 |
Clemson Icon [25710]
TigerPulse: 100%
54
Posts: 18015
Joined: 2000
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
|
|
|
 |
Orange Elite [5132]
TigerPulse: 100%
38
|
This post should be pinned for everyone to see. Great job!***
Jan 19, 2017, 2:03 PM
|
|
|
|
|
|
 |
All-Pro [762]
TigerPulse: 99%
22
|
That is awesome!! Well done!!******
Jan 19, 2017, 2:05 PM
|
|
|
|
|
|
 |
1st Rounder [620]
TigerPulse: 74%
21
|
POTY
Jan 19, 2017, 2:06 PM
|
|
This guy put in some major work here and should be recognized! Props man!
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: POTY
Jan 19, 2017, 2:21 PM
|
|
Thanks! I wish I could have gotten it out sooner, but you're right, it was a ton of work to finish it.
|
|
|
|
 |
1st Rounder [644]
TigerPulse: 95%
21
|
Re: National Championship Visualized
Jan 19, 2017, 2:08 PM
|
|
YOU Sir, win the internet today! Awesome work!
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: National Championship Visualized
Jan 19, 2017, 2:22 PM
|
|
Thanks, glad everyone is enjoying it. I've waited my whole life for this win, so this was the least I could do to commemorate it.
|
|
|
|
 |
All-TigerNet [6085]
TigerPulse: 72%
39
|
Coots would attempt this using crayons & construction paper
Jan 19, 2017, 2:08 PM
|
|
Technology Fail
|
|
|
|
 |
Valley Legend [12507]
TigerPulse: 100%
47
Posts: 12664
Joined: 2003
|
genius!***
Jan 19, 2017, 2:46 PM
|
|
|
|
|
|
 |
Paw Master [16181]
TigerPulse: 100%
51
|
This needs to be placed permanently on the homepage. Well done!***
Jan 19, 2017, 2:50 PM
|
|
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: This needs to be placed permanently on the homepage. Well done!***
Jan 19, 2017, 2:52 PM
|
|
Thanks! It'd be cool to see it there.
|
|
|
|
 |
Game Changer [1688]
TigerPulse: 100%
31
|
one of the coolest things ever! great work!***
Jan 19, 2017, 2:55 PM
|
|
|
|
|
|
 |
Orange Blooded [2266]
TigerPulse: 100%
32
|
Love it, great quick reference for each play***
Jan 19, 2017, 3:50 PM
|
|
|
|
|
|
 |
Legend [18408]
TigerPulse: 100%
52
Posts: 10717
Joined: 2013
|
Re: Love it, great quick reference for each play***
Jan 20, 2017, 9:30 AM
|
|
I was curious if you ever posted any of your "post analysis" on the game. sure hope you do the same posts as this year... if you can find the time that is.
|
|
|
|
 |
Associate AD [1051]
TigerPulse: 100%
25
|
Re: National Championship Visualized
Jan 19, 2017, 3:52 PM
|
|
Awesome. Great job.
|
|
|
|
 |
All-TigerNet [12666]
TigerPulse: 86%
47
Posts: 12291
Joined: 2011
|
Wow, you.ve really got skills. Thanks***
Jan 19, 2017, 3:52 PM
|
|
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: Wow, you.ve really got skills. Thanks***
Jan 19, 2017, 4:40 PM
|
|
Thanks, glad you liked it!
|
|
|
|
 |
Clemson Conqueror [11328]
TigerPulse: 100%
46
Posts: 12632
Joined: 1999
|
I hope this doesn't embarrass you, but - you're awesome!!!!***
Jan 19, 2017, 4:58 PM
|
|
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: I hope this doesn't embarrass you, but - you're awesome!!!!***
Jan 19, 2017, 7:57 PM
|
|
Haha glad you liked it. I just wanted to share it with everyone.
|
|
|
|
 |
Head Coach [918]
TigerPulse: 100%
24
|
Re: National Championship Visualized
Jan 19, 2017, 5:04 PM
|
|
HOF post
|
|
|
|
 |
Clemson Conqueror [11743]
TigerPulse: 100%
46
|
1st ever T-net post that I bookmarked on my computer...
Jan 19, 2017, 5:12 PM
|
|
very well done...
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: 1st ever T-net post that I bookmarked on my computer...
Jan 19, 2017, 7:58 PM
|
|
Wow, very kind words! Glad you liked it.
|
|
|
|
 |
Associate AD [800]
TigerPulse: 100%
23
|
Re: National Championship Visualized
Jan 19, 2017, 8:28 PM
|
|
That is amazing! Thank you for sharing and a job well done!
|
|
|
|
 |
Game Changer [1749]
TigerPulse: 100%
31
|
Re: National Championship Visualized
Jan 19, 2017, 8:29 PM
|
|
Cool!
|
|
|
|
 |
Rival Killer [2627]
TigerPulse: 100%
33
|
Re: National Championship Visualized.....Outstanding !
Jan 19, 2017, 8:31 PM
|
|
Thanks.
|
|
|
|
 |
Orange Blooded [2557]
TigerPulse: 100%
32
|
Well, when you do post apparently it's really good! +1
Jan 19, 2017, 8:37 PM
|
|
You don't live in Seneca by chance do you? Looks like something my cousin would/could (because I sure couldn't) make.
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: Well, when you do post apparently it's really good! +1
Jan 19, 2017, 8:42 PM
|
|
Thanks! No I live in Anderson.
|
|
|
|
 |
Valley Protector [1425]
TigerPulse: 100%
29
|
Re: National Championship Visualized
Jan 19, 2017, 8:48 PM
|
|
That is the most impressive post I have ever read on Tigernet! Thanks.
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: National Championship Visualized
Jan 19, 2017, 8:55 PM
|
|
Thanks, that means a lot.
|
|
|
|
 |
Orange Blooded [4506]
TigerPulse: 100%
36
|
I-M-P-R-E-S-S-I-V-E!!!***
Jan 19, 2017, 8:58 PM
|
|
|
|
|
|
 |
Clemson Conqueror [11484]
TigerPulse: 100%
46
|
I logged in just to give you a point.
Jan 20, 2017, 9:14 AM
|
|
Amazing job!
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: I logged in just to give you a point.
Jan 20, 2017, 9:28 PM
|
|
Thanks I really appreciate it!
|
|
|
|
 |
Scout Team [85]
TigerPulse: 100%
9
|
Re: National Championship Visualized
Jan 20, 2017, 1:49 PM
|
|
Very cool stuff. Kudos to you. +1
|
|
|
|
 |
All-In [27366]
TigerPulse: 100%
54
Posts: 26231
Joined: 2011
|
So did we still WIN!?***
Jan 20, 2017, 3:01 PM
|
|
|
|
|
|
 |
110%er [3821]
TigerPulse: 82%
35
|
please tell Chuckston and TIPster to give up their day jobs
Jan 20, 2017, 4:20 PM
|
|
as Brownell haters
and just spend their time on here
living the dream of the Natty.
Everybody would be a winner....
Absolutely great, great job!!!
|
|
|
|
 |
All-Pro [747]
TigerPulse: 100%
22
|
Now that is some quality work***
Jan 20, 2017, 4:32 PM
|
|
|
|
|
|
 |
CU Medallion [18789]
TigerPulse: 100%
52
Posts: 11095
Joined: 2008
|
That is the awesomest thing on Tigernet since Shoeless!***
Jan 20, 2017, 5:04 PM
|
|
|
|
|
|
 |
Associate AD [1013]
TigerPulse: 100%
25
|
Re: National Championship Visualized - That is Great
Jan 20, 2017, 5:20 PM
|
|
Nice work. Very interesting to look at like that.
|
|
|
|
 |
Clemson Icon [26944]
TigerPulse: 100%
54
Posts: 10221
Joined: 2015
|
You should post more often!
Jan 20, 2017, 5:28 PM
|
|
Fantastic job!
|
|
|
|
 |
Scout Team [194]
TigerPulse: 100%
12
|
Re: You should post more often!
Jan 20, 2017, 9:34 PM
|
|
Thanks, I'll try to share more of my stuff here.
|
|
|
|
 |
Hall of Famer [8577]
TigerPulse: 100%
43
|
Ok....this here is incredibly cool.
Jan 20, 2017, 7:48 PM
|
|
Wish we could have this for every game.
|
|
|
|
 |
National Champion [7875]
TigerPulse: 100%
42
|
This post needs to forever adorn the Home page menu.
Jan 20, 2017, 10:14 PM
|
|
Excellent work! GO TIGERS!!!
|
|
|
|
 |
Commissioner [1224]
TigerPulse: 100%
27
|
Giving you a thumbs up is not good enough.
Jan 20, 2017, 10:44 PM
|
|
That was awesome work that I will probably reference many many times in coming months or years.
Go Tigers!
|
|
|
|
Replies: 74
| visibility 1417
|
|
|