Printable Playa Schedule 2019

Summary:
This is a giant spreadsheet with every single event and art installation at Burning Man. Scroll down, download, and start getting excited ;)

Details:
When you arrive at the gates of Black Rock City, the greeters hand you a thick booklet full of all kinds of events, parties, classes, & games. It's awesome, but the last thing I wanted to do when I got there was sit in my tent reading. Only after returning from my virgin burn did I leaf through that book, and realize just how many incredible things I wished I'd known about. Next year, I wanted to go through the list in advance.

Unfortunately, I found the official Playa Events page to be a bit frustrating - you have to click each event one at a time, few include a location, and many are repeated over & over again. So to make things easier, I decided to whip up a script to export the whole event list to Excel.

With Excel you can see everything all at once, sort however you like, trim those you aren't interested in, add notes, or share & collaborate with friends. When finished, you've got a simple at-a-glance spreadsheet that you can print & take to the Playa. I've structured it with each day as a separate column - that way you can glance down a column to see what's happening at a moment's notice. I've also included the full list of art installations, and supplementary location data from BurnerMap.com & The Unofficial BRC Map.

I hope you find it useful (leave me a note below if you do!), & to see you all on the Playa )'(



The download is available in two flavors:
  • 2019 Pre-formatted Spreadsheet. If this is your first time here, this is the version I'd suggest. It's pre-formatted to be quicker & easier to read, providing the best first-look at what this is about. The data is current as of 08/22/2019.
  • 2019 Tab-Separated Values. Check back in 2020! :)
How To Format The CSV For Viewing/Printing (using Excel 2019 on Windows):
  • Open the CSV file in Excel
  • File->Save As->Excel Workbook (xlsx)
  • Select All->Calibri 8
  • Select All->Right-Click->Row Height = 14
  • Select All->Right-Click->Format Cells->Alignment->Wrap text = OFF
  • Page Layout->Gridlines->Print = ON
  • Select the columns up to & including "Where," then Page Layout->Print Area->Set Print Area
  • Page Layout->Scale = 50%
  • Page Layout->Margins->Custom->Top=0.1", all others=0"
  • Page Layout->Print Titles->Sheet->Rows to repeat at top = $1:$1
  • Insert->Header & Footer:
    • Left side = &[Page]/&[Pages]
    • Center = 20xx Playa Events && Art
    • Right side = https://www.justin-klein.com/playaevents-excel-exporter
  • View->Normal
  • View->Freeze Panes->Freeze Top Row
  • Select the top row...
    • Bold
    • Left-align
    • Right-Click->Format Cells->Number->Custom->Type = ddd m-dd
  • Data->Sort->Add a level for each date column, in reverse order (i.e. Mon, Sun, Sat, Fri, ...)
  • Column Widths:
    (Note: Widths render differently on-screen than when printed - if you tweak your widths at all,
    make sure to set them in Normal view, but verify them in View->Page Layout, to make sure they don't spill onto the next page.)
    • Dates = 6.89
    • Title = 17.33
    • Description = 114.89
    • Type = 2.67
    • Camp = 8
    • Where = 5.67
When finished, I suggest printing to PDF as a test run, to verify it comes out as expected (fits on the page, headers are there, first row is repeated, etc
Note: The data changes quite a bit in the weeks leading up to the burn, as camps submit their events & locations. I suggest downloading your final copy as late as possible for the most complete & accurate info.

Previous Years:
Disclaimer: This app is not affiliated with or endorsed by Burning Man Project or Black Rock City LLC.

  88 Responses to “Printable Playa Schedule”

  1. Would it be possible to add a column for the date added. So we can sort by the ones that were added latest

    • You can sort by the ‘Link’ column, which includes a chronological ID number (last added will appear last).

  2. Super useful, Justin. Thanks!

  3. Is there a way to set the settings so it all prints on a 8 1/2 x 11 piece of paper?

    • There are *far* too many events to fit them all on one piece of paper – almost 5000 rows. It’ll take ~22 pages front & back.

 Leave a Reply

(required)

(required)


(required)

Notify me of followup comments via e-mail. You can also subscribe without commenting.

jfb_p_buttontext

Contact | Terms & Privacy
©2004-2019 Justin Klein
whos online
Feedburner
HTML5 Valid
09-20-2019 19:06:03UTC 0.21s 60q 5.02MB