Replies: 74
| visibility 1
|
Scout Team [194]
TigerPulse: 100%
Posts: 22
Joined: 12/7/15
|
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%
Posts: 96
Joined: 2/15/99
|
Re: National Championship Visualized
Jan 19, 2017, 9:50 AM
|
|
Thanks man, this is a masterpiece !
|
|
|
|
|
Scout Team [194]
TigerPulse: 100%
Posts: 22
Joined: 12/7/15
|
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!
|
|
|
|
|
All-TigerNet [14477]
TigerPulse: 80%
Posts: 22921
Joined: 11/30/98
|
Re: National Championship Visualized
Jan 19, 2017, 9:56 AM
|
|
awesome job
|
|
|
|
|
All-In [32656]
TigerPulse: 100%
Posts: 14904
Joined: 6/29/11
|
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%
Posts: 22
Joined: 12/7/15
|
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.
|
|
|
|
|
CU Guru [1665]
TigerPulse: 100%
Posts: 1588
Joined: 10/2/00
|
Incredible!!! A sincere thanks!***
Jan 20, 2017, 10:12 PM
|
|
|
|
|
|
|
Orange Blooded [4660]
TigerPulse: 100%
Posts: 6064
Joined: 10/20/15
|
Re: National Championship Visualized
Jan 19, 2017, 9:56 AM
|
|
Wow. I'm impressed man. That's next-level right there!
|
|
|
|
|
Oculus Spirit [96873]
TigerPulse: 100%
Posts: 29215
Joined: 9/14/05
|
That's impressive work dood. Finally, somebody around here
Jan 19, 2017, 9:59 AM
|
|
with some brains.
|
|
|
|
|
Oculus Spirit [81925]
TigerPulse: 100%
Posts: 47119
Joined: 3/18/07
|
Re: That's impressive work dood. Finally, somebody around here
Jan 19, 2017, 10:02 AM
|
|
I have some brians, does that count?
|
|
|
|
|
Oculus Spirit [96873]
TigerPulse: 100%
Posts: 29215
Joined: 9/14/05
|
Didn't you loose 1/3 of your
Jan 19, 2017, 10:05 AM
|
|
skin in a motorcycle accident?
Sorry, but nice try.
|
|
|
|
|
Hall of Famer [21870]
TigerPulse: 100%
Posts: 15712
Joined: 10/23/12
|
|
|
|
|
Legend [17786]
TigerPulse: 100%
Posts: 13387
Joined: 9/16/03
|
That is really awesome***
Jan 19, 2017, 10:00 AM
|
|
|
|
|
|
|
CU Guru [1813]
TigerPulse: 96%
Posts: 2419
Joined: 9/24/07
|
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%
Posts: 22
Joined: 12/7/15
|
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.
|
|
|
|
|
Orange Blooded [3913]
TigerPulse: 100%
Posts: 3696
Joined: 11/27/03
|
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%
Posts: 7625
Joined: 3/5/12
|
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%
Posts: 22
Joined: 12/7/15
|
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.
|
|
|
|
|
All-In [30841]
TigerPulse: 100%
Posts: 34504
Joined: 6/22/03
|
A post that has purpose. .well done***
Jan 19, 2017, 10:12 AM
|
|
|
|
|
|
|
110%er [8278]
TigerPulse: 100%
Posts: 3926
Joined: 9/11/08
|
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%
Posts: 536
Joined: 11/2/99
|
Fantastic! Thanks for sharing***
Jan 19, 2017, 10:23 AM
|
|
|
|
|
|
|
Orange Blooded [2504]
TigerPulse: 100%
Posts: 1906
Joined: 9/20/08
|
Nice work! Would be cool to make a poster out of that.***
Jan 19, 2017, 10:27 AM
|
|
|
|
|
|
|
Scout Team [194]
TigerPulse: 100%
Posts: 22
Joined: 12/7/15
|
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.
|
|
|
|
|
CU Medallion [53258]
TigerPulse: 100%
Posts: 21827
Joined: 11/16/05
|
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%
Posts: 22
Joined: 12/7/15
|
Re: HOF or BUST!!!!!!!!!!
Jan 19, 2017, 10:29 AM
|
|
Haha thanks! I'm glad I could share it with y'all.
|
|
|
|
|
Oculus Spirit [96873]
TigerPulse: 100%
Posts: 29215
Joined: 9/14/05
|
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%
Posts: 22
Joined: 12/7/15
|
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.
|
|
|
|
|
Oculus Spirit [96873]
TigerPulse: 100%
Posts: 29215
Joined: 9/14/05
|
Can you outsource to India?
Jan 19, 2017, 10:45 AM
|
|
I won't tell Trump.
|
|
|
|
|
Legend [16088]
TigerPulse: 100%
Posts: 6058
Joined: 12/11/12
|
Ridiculously Outstanding Job!! Thanks for this!!***
Jan 20, 2017, 9:56 AM
[ in reply to Re: Deer sirvizalot ] |
|
|
|
|
|
|
110%er [7718]
TigerPulse: 100%
Posts: 7444
Joined: 1/10/16
|
Re: National Championship Visualized
Jan 19, 2017, 10:34 AM
|
|
Holy #### man that is amazing...
Thanks!
|
|
|
|
|
Scout Team [194]
TigerPulse: 100%
Posts: 22
Joined: 12/7/15
|
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.
|
|
|
|
|
Hall of Famer [22948]
TigerPulse: 100%
Posts: 16899
Joined: 12/2/00
|
|
|
|
|
Scout Team [194]
TigerPulse: 100%
Posts: 22
Joined: 12/7/15
|
|
|
|
|
Orange Blooded [4988]
TigerPulse: 100%
Posts: 7962
Joined: 2/27/02
|
This post should be pinned for everyone to see. Great job!***
Jan 19, 2017, 2:03 PM
|
|
|
|
|
|
|
Asst Coach [746]
TigerPulse: 98%
Posts: 567
Joined: 11/13/03
|
That is awesome!! Well done!!******
Jan 19, 2017, 2:05 PM
|
|
|
|
|
|
|
1st Rounder [615]
TigerPulse: 74%
Posts: 525
Joined: 1/23/12
|
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%
Posts: 22
Joined: 12/7/15
|
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 [633]
TigerPulse: 95%
Posts: 549
Joined: 11/18/07
|
Re: National Championship Visualized
Jan 19, 2017, 2:08 PM
|
|
YOU Sir, win the internet today! Awesome work!
|
|
|
|
|
Scout Team [194]
TigerPulse: 100%
Posts: 22
Joined: 12/7/15
|
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.
|
|
|
|
|
110%er [5383]
TigerPulse: 70%
Posts: 9274
Joined: 11/29/99
|
Coots would attempt this using crayons & construction paper
Jan 19, 2017, 2:08 PM
|
|
Technology Fail
|
|
|
|
|
All-TigerNet [12270]
TigerPulse: 100%
Posts: 12594
Joined: 12/1/03
|
genius!***
Jan 19, 2017, 2:46 PM
|
|
|
|
|
|
|
Legend [15914]
TigerPulse: 100%
Posts: 7797
Joined: 11/15/09
|
This needs to be placed permanently on the homepage. Well done!***
Jan 19, 2017, 2:50 PM
|
|
|
|
|
|
|
Scout Team [194]
TigerPulse: 100%
Posts: 22
Joined: 12/7/15
|
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.
|
|
|
|
|
CU Guru [1544]
TigerPulse: 100%
Posts: 3020
Joined: 6/21/05
|
one of the coolest things ever! great work!***
Jan 19, 2017, 2:55 PM
|
|
|
|
|
|
|
Orange Blooded [2253]
TigerPulse: 100%
Posts: 1444
Joined: 11/10/08
|
Love it, great quick reference for each play***
Jan 19, 2017, 3:50 PM
|
|
|
|
|
|
|
Legend [18407]
TigerPulse: 100%
Posts: 10717
Joined: 10/20/13
|
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.
|
|
|
|
|
Athletic Dir [867]
TigerPulse: 100%
Posts: 767
Joined: 2/12/16
|
Re: National Championship Visualized
Jan 19, 2017, 3:52 PM
|
|
Awesome. Great job.
|
|
|
|
|
All-TigerNet [12547]
TigerPulse: 86%
Posts: 12249
Joined: 11/21/11
|
Wow, you.ve really got skills. Thanks***
Jan 19, 2017, 3:52 PM
|
|
|
|
|
|
|
Scout Team [194]
TigerPulse: 100%
Posts: 22
Joined: 12/7/15
|
Re: Wow, you.ve really got skills. Thanks***
Jan 19, 2017, 4:40 PM
|
|
Thanks, glad you liked it!
|
|
|
|
|
110%er [9667]
TigerPulse: 100%
Posts: 11416
Joined: 9/10/99
|
I hope this doesn't embarrass you, but - you're awesome!!!!***
Jan 19, 2017, 4:58 PM
|
|
|
|
|
|
|
Scout Team [194]
TigerPulse: 100%
Posts: 22
Joined: 12/7/15
|
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.
|
|
|
|
|
Commissioner [903]
TigerPulse: 100%
Posts: 499
Joined: 10/21/00
|
Re: National Championship Visualized
Jan 19, 2017, 5:04 PM
|
|
HOF post
|
|
|
|
|
All-TigerNet [10859]
TigerPulse: 100%
Posts: 7646
Joined: 1/6/04
|
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%
Posts: 22
Joined: 12/7/15
|
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%
Posts: 1944
Joined: 10/28/01
|
Re: National Championship Visualized
Jan 19, 2017, 8:28 PM
|
|
That is amazing! Thank you for sharing and a job well done!
|
|
|
|
|
CU Guru [1736]
TigerPulse: 100%
Posts: 1523
Joined: 10/17/13
|
Re: National Championship Visualized
Jan 19, 2017, 8:29 PM
|
|
Cool!
|
|
|
|
|
Orange Blooded [2563]
TigerPulse: 100%
Posts: 4860
Joined: 10/2/08
|
Re: National Championship Visualized.....Outstanding !
Jan 19, 2017, 8:31 PM
|
|
Thanks.
|
|
|
|
|
Orange Blooded [2557]
TigerPulse: 100%
Posts: 3678
Joined: 2/18/09
|
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%
Posts: 22
Joined: 12/7/15
|
Re: Well, when you do post apparently it's really good! +1
Jan 19, 2017, 9:42 PM
|
|
Thanks! No I live in Anderson.
|
|
|
|
|
CU Guru [1019]
TigerPulse: 100%
Posts: 1341
Joined: 9/17/01
|
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%
Posts: 22
Joined: 12/7/15
|
Re: National Championship Visualized
Jan 19, 2017, 8:55 PM
|
|
Thanks, that means a lot.
|
|
|
|
|
Orange Blooded [4504]
TigerPulse: 100%
Posts: 9112
Joined: 11/30/98
|
I-M-P-R-E-S-S-I-V-E!!!***
Jan 19, 2017, 8:58 PM
|
|
|
|
|
|
|
All-TigerNet [11478]
TigerPulse: 100%
Posts: 9412
Joined: 10/3/12
|
I logged in just to give you a point.
Jan 20, 2017, 9:14 AM
|
|
Amazing job!
|
|
|
|
|
Scout Team [194]
TigerPulse: 100%
Posts: 22
Joined: 12/7/15
|
Re: I logged in just to give you a point.
Jan 20, 2017, 9:28 PM
|
|
Thanks I really appreciate it!
|
|
|
|
|
Recruit [75]
TigerPulse: 100%
Posts: 90
Joined: 10/26/05
|
Re: National Championship Visualized
Jan 20, 2017, 1:49 PM
|
|
Very cool stuff. Kudos to you. +1
|
|
|
|
|
All-In [27366]
TigerPulse: 100%
Posts: 26233
Joined: 9/19/11
|
So did we still WIN!?***
Jan 20, 2017, 3:01 PM
|
|
|
|
|
|
|
Orange Blooded [3820]
TigerPulse: 82%
Posts: 4395
Joined: 12/24/09
|
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!!!
|
|
|
|
|
Asst Coach [721]
TigerPulse: 100%
Posts: 685
Joined: 11/10/04
|
Now that is some quality work***
Jan 20, 2017, 4:32 PM
|
|
|
|
|
|
|
Legend [17626]
TigerPulse: 100%
Posts: 11052
Joined: 10/13/08
|
That is the awesomest thing on Tigernet since Shoeless!***
Jan 20, 2017, 5:04 PM
|
|
|
|
|
|
|
Commissioner [957]
TigerPulse: 100%
Posts: 534
Joined: 9/7/09
|
Re: National Championship Visualized - That is Great
Jan 20, 2017, 5:20 PM
|
|
Nice work. Very interesting to look at like that.
|
|
|
|
|
Hall of Famer [24123]
TigerPulse: 100%
Posts: 9796
Joined: 10/7/15
|
You should post more often!
Jan 20, 2017, 5:28 PM
|
|
Fantastic job!
|
|
|
|
|
Scout Team [194]
TigerPulse: 100%
Posts: 22
Joined: 12/7/15
|
Re: You should post more often!
Jan 20, 2017, 9:34 PM
|
|
Thanks, I'll try to share more of my stuff here.
|
|
|
|
|
110%er [8565]
TigerPulse: 100%
Posts: 5495
Joined: 12/12/15
|
Ok....this here is incredibly cool.
Jan 20, 2017, 7:48 PM
|
|
Wish we could have this for every game.
|
|
|
|
|
110%er [7169]
TigerPulse: 100%
Posts: 4003
Joined: 9/17/14
|
This post needs to forever adorn the Home page menu.
Jan 20, 2017, 10:14 PM
|
|
Excellent work! GO TIGERS!!!
|
|
|
|
|
CU Guru [1135]
TigerPulse: 100%
Posts: 1030
Joined: 9/4/06
|
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 1
|
|
|