{"id":2590,"date":"2021-04-24T17:28:42","date_gmt":"2021-04-25T00:28:42","guid":{"rendered":"https:\/\/www.scot.fun\/damentals\/?p=2590"},"modified":"2021-04-24T17:30:34","modified_gmt":"2021-04-25T00:30:34","slug":"making-7-spreadsheet","status":"publish","type":"post","link":"https:\/\/www.scot.fun\/damentals\/making-7-spreadsheet\/","title":{"rendered":"MAKING! 7 Spreadsheet"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n
I\u2019m *making* an online fundraising event for a school.  I thought maybe people would gain something by seeing my process for creating, rehearsing, collaborating, and performing the event\u2026 So, here I am sharing.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

I really like spreadsheets for a lot of stuff. I’m not saying that I have the best way of doing this organization of a show flow, but here’s how I do it. All my crew is welcome to take notes however they like to get their work done, but I start out with a general show order so that I can plug things in and move things around. There are a lot of conversations that happen, but this gets them started.<\/p>\n\n\n\n

Column A<\/strong> : time<\/h2>\n\n\n\n

not every row has a time. The times (like “8:15p”) are just there for important times. I don’t like when someone puts together a rough timeline and everything has an exact time. It will change a lot. This also prevents me from having to adjust every row when something new is added or edited.<\/p>\n\n\n\n

Column B<\/strong> : general what<\/h2>\n\n\n\n

These are the simple descriptions of events that happen during the show like “intro the lion act” “opening monolog” “heartfelt speech”<\/p>\n\n\n\n

Column C<\/strong> : duration<\/h2>\n\n\n\n

Rough estimates of how long things take help me understand the pacing and remind me to keep things short. “3min”<\/p>\n\n\n\n

Column D<\/strong> : duration sums<\/h2>\n\n\n\n

This is the only spreadsheet formula so I can see how long the whole thing is running. Do I have too much content or too little? It adds the above some to the duration to the left. eg: the D4 cell says<\/p>\n\n\n\n

“=(C4 + D3)”<\/p>\n\n\n\n

Column E <\/strong>: notes to self<\/h2>\n\n\n\n

When I’m going thru, I this sheet, it’s nice to jot stuff down because I HAVE IMPORTANT THOUGHTS!<\/p>\n\n\n\n

Column F<\/strong> thru Z<\/strong> : pieces needed<\/h2>\n\n\n\n

Each of these columns will have assets or things that I need from my people. So maybe column F is the “sound FX” column. Each moment in the show has its corresponding required sound effects next to it. This makes it easy for me to reconfigure the info later however i need to to talk to my sound effect person<\/p>\n\n\n\n

This whole thing is messy.<\/h2>\n\n\n\n

Like I said, this is rough and it’s incomplete. It’s not a cue sheet or anything else like that. this is to get the whole production out of my head so that I start to visualize and use my brain for fleshing out, instead of doing the math and memorizing the order.<\/p>\n","protected":false},"excerpt":{"rendered":"

I\u2019m *making* an online fundraising event for a school.  I thought maybe people would gain something by seeing my process for creating, rehearsing, collaborating, and performing the event\u2026 So, here I am sharing. I really like spreadsheets for a lot of stuff. I’m not saying that I have the best way of doing this organization […]<\/p>\n","protected":false},"author":15,"featured_media":2592,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":{"facebook_10158666434799935_26707174888":"","twitter_aToyMjM4MTQzMDs=_22381430":""},"rop_publish_now_history":[],"rop_publish_now_status":"pending","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1],"tags":[],"class_list":["post-2590","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-alfie-thompson-2421586.jpg?fit=2000%2C1087&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/pc33gc-FM","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2566,"url":"https:\/\/www.scot.fun\/damentals\/making-3-the-storm\/","url_meta":{"origin":2590,"position":0},"title":"Making! 3 The Storm","author":"scot","date":"April 20, 2021","format":false,"excerpt":"I\u2019m *making* an online fundraising event for a school. \u00a0I thought maybe people would gain something by seeing my process for creating, rehearsing, collaborating, and performing the event\u2026 So, here I am sharing. Today and tomorrow were scheduled for me to work on the showflow and game structure of the\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-lindeboom-jeanbapt-613778.jpg?fit=1200%2C794&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-lindeboom-jeanbapt-613778.jpg?fit=1200%2C794&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-lindeboom-jeanbapt-613778.jpg?fit=1200%2C794&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-lindeboom-jeanbapt-613778.jpg?fit=1200%2C794&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-lindeboom-jeanbapt-613778.jpg?fit=1200%2C794&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":829,"url":"https:\/\/www.scot.fun\/damentals\/whats-an-event-ticket-do\/","url_meta":{"origin":2590,"position":1},"title":"Event Tickets Do A Heck Of A Lot","author":"scot","date":"June 9, 2020","format":false,"excerpt":"Tickets are part of the solution for every desire for your event. When I talk to new show producers about their tickets, they often don't care at first. They either assume they'll have tickets of some kind, or they'll just let people pay a cover at the door. Mistakes. Tickets\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2020\/06\/top-view-of-assorted-colored-row-boats-929032.jpg?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2020\/06\/top-view-of-assorted-colored-row-boats-929032.jpg?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2020\/06\/top-view-of-assorted-colored-row-boats-929032.jpg?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2020\/06\/top-view-of-assorted-colored-row-boats-929032.jpg?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2020\/06\/top-view-of-assorted-colored-row-boats-929032.jpg?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":2579,"url":"https:\/\/www.scot.fun\/damentals\/making-4-leaning\/","url_meta":{"origin":2590,"position":2},"title":"MAKING! 4 Leaning","author":"scot","date":"April 21, 2021","format":false,"excerpt":"I\u2019m *making* an online fundraising event for a school. \u00a0I thought maybe people would gain something by seeing my process for creating, rehearsing, collaborating, and performing the event\u2026 So, here I am sharing. Today it's about show flow and game structure. I spent some time laying it out in a\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-dmitriy-ganin-7537816.jpg?fit=1200%2C593&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-dmitriy-ganin-7537816.jpg?fit=1200%2C593&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-dmitriy-ganin-7537816.jpg?fit=1200%2C593&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-dmitriy-ganin-7537816.jpg?fit=1200%2C593&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-dmitriy-ganin-7537816.jpg?fit=1200%2C593&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":2587,"url":"https:\/\/www.scot.fun\/damentals\/making-6-hidden-value\/","url_meta":{"origin":2590,"position":3},"title":"MAKING! 6 Hidden Value","author":"scot","date":"April 23, 2021","format":false,"excerpt":"I\u2019m *making* an online fundraising event for a school. \u00a0I thought maybe people would gain something by seeing my process for creating, rehearsing, collaborating, and performing the event\u2026 So, here I am sharing. Today was tech rehearsal. We're dealing with a lot of new technology. New to the world and\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-snapwire-205790.jpg?fit=1200%2C661&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-snapwire-205790.jpg?fit=1200%2C661&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-snapwire-205790.jpg?fit=1200%2C661&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-snapwire-205790.jpg?fit=1200%2C661&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-snapwire-205790.jpg?fit=1200%2C661&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":2583,"url":"https:\/\/www.scot.fun\/damentals\/making-5-format-it\/","url_meta":{"origin":2590,"position":4},"title":"Making! 5 Format It","author":"scot","date":"April 22, 2021","format":false,"excerpt":"I\u2019m *making* an online fundraising event for a school. \u00a0I thought maybe people would gain something by seeing my process for creating, rehearsing, collaborating, and performing the event\u2026 So, here I am sharing. I need structure. Today was about finding the format of the event. I nailed down the timing\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-david-ohboy-7516689.jpg?fit=1200%2C800&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-david-ohboy-7516689.jpg?fit=1200%2C800&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-david-ohboy-7516689.jpg?fit=1200%2C800&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-david-ohboy-7516689.jpg?fit=1200%2C800&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-david-ohboy-7516689.jpg?fit=1200%2C800&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":2612,"url":"https:\/\/www.scot.fun\/damentals\/making-11-more-than-enough\/","url_meta":{"origin":2590,"position":5},"title":"MAKING! 11 More Than Enough","author":"scot","date":"April 28, 2021","format":false,"excerpt":"I\u2019m *making* an online fundraising event for a school. \u00a0I thought maybe people would gain something by seeing my process for creating, rehearsing, collaborating, and performing the event\u2026 So, here I am sharing. I love Parkinson's Law. It resets me a lot. Sometimes I get lost in action. I forget\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-harry-cooke-6194940.jpg?fit=1200%2C713&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-harry-cooke-6194940.jpg?fit=1200%2C713&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-harry-cooke-6194940.jpg?fit=1200%2C713&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-harry-cooke-6194940.jpg?fit=1200%2C713&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.scot.fun\/damentals\/wp-content\/uploads\/2021\/04\/pexels-harry-cooke-6194940.jpg?fit=1200%2C713&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.scot.fun\/damentals\/wp-json\/wp\/v2\/posts\/2590","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.scot.fun\/damentals\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.scot.fun\/damentals\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.scot.fun\/damentals\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.scot.fun\/damentals\/wp-json\/wp\/v2\/comments?post=2590"}],"version-history":[{"count":1,"href":"https:\/\/www.scot.fun\/damentals\/wp-json\/wp\/v2\/posts\/2590\/revisions"}],"predecessor-version":[{"id":2593,"href":"https:\/\/www.scot.fun\/damentals\/wp-json\/wp\/v2\/posts\/2590\/revisions\/2593"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.scot.fun\/damentals\/wp-json\/wp\/v2\/media\/2592"}],"wp:attachment":[{"href":"https:\/\/www.scot.fun\/damentals\/wp-json\/wp\/v2\/media?parent=2590"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.scot.fun\/damentals\/wp-json\/wp\/v2\/categories?post=2590"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.scot.fun\/damentals\/wp-json\/wp\/v2\/tags?post=2590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}