PAX West 2017 - Desert Bus Panel 1 - Advanced VST Spreadsheet

PAX West 2017 - Desert Bus Panel - Day - 1
Start Time	End Time	Event Type	Description	Submitter / Auction Winner	Poster Event?	Media Link
20:00	--	Promo	The panel title was: "We Are Desert Bus: The Desert Bus for Hope Doc Premiere"			--
20:00	--	Promo	The panel description was: "Since 2007, the internet comedy troupe Loading Ready Run has raised money for Child's Play charity by streaming themselves acting like idiots and playing the most boring game in the world. Ten years later, they've raised over $3 million and oversee an operation that runs almost year-round with volunteers from around the globe. For the 10th anniversary of Desert Bus for Hope, this is the story of how they built it and (perhaps more importantly) why. EXTENDED EDITION! With commentary and Q&A!"			--
20:00	--	PSA	^ Yes, LoadingReadyRun was spelled incorrectly in the panel description, that is not a typo here.			--
20:00	--	Promo	Panelists were listed as: Russ Pitts [President, Flying Saucer Media], Graham Stark [President, Bionic Trousers], Ian Horner [Contributor, Desert Bus for Hope], Ashton Cummings [Contributor, Desert Bus for Hope], James Turner [Dad, Desert Bus for Hope], Christian Cicerone [Director of Photography, Flying Saucer Media], Ian Dorsch [Composer, Flying Saucer Media]			--
20:00	--	Promo	The panel was scheduled to happen at: PAX West in Seattle Washington USA on Friday 2017-09-01 in the Cat Theatre, and was scheduled to run from 20:00 to 22:00 PDT			--
20:00	22:00	Technical	Sadly, the only known footage from this panel is a short ~50 sec clip of applause during the Doc credits (provided by Graham). No other known footage, recordings, or even photographs from this panel are known to exist. It is further not known what exact times the panel ran or even who was actually present. Based on DBcommunity IRC logs, it is assumed the panel ran about 50 min to 1 hour over time. (Which last-panel-of-the-days are allowed to do at PAX)			--

HOW THIS WORK?!
Filtering and Linking Functions
Link to this Specific Page	A link to the specific page that you have created via the filtering methods described below
Filter By:	Defaults: \|- All Cells [default on page load, show everything] \|- Img/Gif Cells [Show only: lines with Imgs or Gifs] \|- Video Cells [Show only: lines with videos, and associated poster moments] \|- Poster Cells [Show only: lines with poster moments] \|- Driver/Game Cells [Show only: Driver Changes, Game Events, and Crashes] \|- Prize Cells [Show only: Auctions, Drive/Giveaways, and Prize Info] Mystery Box: (hidden by default) Can be ANY Event Type [just find the desired event type and click on it] Click: Filters the current spreadsheet to your desired preference, and updates the 'Link to' (above)
'Day' Filtering	Options: \|- Tech Test -> DAY # [Show that specific 'day'] \|- All [Show everything, except this page] \|- DB# G-Doc [Link to that year's public VST Google Spreadsheet] \|- ? [This page] Click (TT, Day #, All): Filter by that specific request, and update the 'Link to' (above) Click (G-Doc): Open the VST public Google doc for that year in a new tab. Click (?): Show This Page
Spreadsheet Column Features
Start Time	When the event started (exact to the minute) Mouse Hover: Show the local time the event started in the format of: Day of the Week, YYYY-MM-DD HH:MM, TZ - (GMT Offset) Click: Link to this SPECIFIC row, and have that row have a black border box around it for visibility.
End Time	When the event ended (exact to the minute) [if available / applicable] Mouse Hover: Show the local time the event ended (if available) in the format of: Day of the Week, YYYY-MM-DD HH:MM, TZ - (GMT Offset)
Event Type	The VST's categorization of the event Click: Filter by this specific event type, populate the 'Mystery Box' (above) with that event type, and update the 'Link to' (above) with said event type.
Description	The VST's description of what happened during said event or what the event was
Submitter / Auction Winner	The person(s) who submitted the challenge or The person(s) who won the Auction or The person(s) who won the Giveaway.
Poster Event?	If said item appears on the poster a [✓] will appear. Click (If [✓] present): Same as clicking 'Poster Cells' (above), filter by poster moments.
Media Link	If: There is an img or gif associate with the event an img: or gif: icon will appear If: There is a YouTube, Twitch, or Vimeo video associated with the event a relevant icon will appear: \|\| \|\| If: The VST is currently working on uploading a video for it: 'Marked...', 'Editing...', or 'Uploading...' will appear Click (in the presence of a Img or Video link): Open said Media in a new tab.