Disclosure: This site participates in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.


Schedule maker for streamers

Last Updated on

A schedule is an important part of a streamer for audience retention. We made a schedule maker in Google Sheets that is very simple & powerful.

This Schedule maker is free for use and Redistribution. Once again, like our free sounds, it is under the CC BY-SA License. You are free to redistribute & modify so long as you leave Column A, Row 2 and 3 untouched.

Streamer's Haven Schedule maker is protected by CC BY SA Copyright.

Features of the Streamer’s Haven Schedule Maker

Our Schedule maker supports custom categories

First and foremost, this Scheduler was made with Twitch & Mixer Streamers and YouTubers in mind. By default, it comes with 14 Categories. However, we designed it with expandability in mind. You can add your own categories, or rename existing categories.

  • Sleeping – Used to schedule sleeping.
  • Family Time – Used to slot in time to spend with your family & friends
  • Working – For use in whatever you do for a living aside from streaming & general content creation.
  • Food – Yup, Scheduling time to eat. Especially useful for dinner plans.
  • Break – Breaks are very important to slot into your schedule. Take some time to yourself to unwind. Helps stave off burnout.
  • Gym – Or just general exercise. Staying in shape is important for any influencer.
  • Get Ready – The mundane tasks like brushing teeth, showering, & general Hygiene/clothing.
  • Streaming – What else is there to say? This is to slot in your stream schedule compared to the rest of your day.
  • Recording – YouTuber/VOD Specific, or if you have a hobby of recording the music that you play.
  • Editing – Again, YouTuber and VOD Specific. Editing arguably takes more time than recording. Scheduling it takes a bit of stress off your shoulders.
  • Channel – Things like Overlay tweaking.
  • Networking – You can bundle Self-Advertisement into this. We recommend a minimum of 3 hours a week spent on this. More if you don’t work full time. Build those connections!
  • Events – Big events like Pax South, E3, etc.
  • Designing – This was a personal request of slide thistle, the man who helped build this scheduler.

Remember that you can over the existing categories for a breakdown.

Add your own Categories

We believe that the categories are specific enough to be easily discernable & applicable to most everything, however, you may customize this further if you wish.

Description prompts for various cells can be found throughout.

Hovering over “Add your own categories below” will show this tooltip. Follow the directions and you’ll quickly have a new category.

By highlighting E6 to K53, and right-clicking, you will be shown this:

Adding a custom Category is  easy. Schedule maker

Any category you choose to add will be unformatted for color, and will not have an hourly counter box set up…so Let’s do that next. For the purpose of this example, we will be creating the category “Streamer’s Haven” Make sure you do not use any spaces, and separate each category you make with a comma, or the Data Validation won’t work.

Setting up the hourly counter for the new category of the Streamer’s Haven Schedule Maker

    =DIVIDE(COUNTIF(E6:K53,"Sleeping"),2) & " Hours a Week"

Replace “Sleeping” with “Streamer’s Haven”, and paste it into P13.

The Formula is where the magic happens.
Note the fX for the selected cell. This is what you enter.

The color for the blue background for the hour counter is Dark Blue 3 in the pre-existing colors.

Speaking of colors…

Applying the colors for the new category with data validation.

Improperly set up Conditional Formatting of the Streamer's Haven Schedule maker

If you were to add the Streamer’s Haven Category into the list at this point, it will take the color of the existing category. This is not ideal. You’ll need to open up the conditional formatting and set up a color change based on the value of the cell.

Start by highlighting E6 to K53 again, and this time, select “Conditional Formatting” and select “+ Add another rule”. Then set the prompt up like so:

Conditional format rules for the Streamer's Haven Schedule Maker

And now, it applies the color you select for the paint can icon. You can also specify text color, bold it, italicize it, etc. Get creative. 🙂

Properly set up conditional formatting for the Streamer's Haven Schedule maker

Change the Timescale

Don’t like the top of the schedule to start at 12:00AM? Changing that is very simple. Simply select Cell C6, and modify the following formula:

    =TIME(0,0,0)

Want it to start at 7 AM? Set it to (7,0,0) 12PM? (12,0,0). Play with it and adjust it to your preference. Prefer Universal Time? We’re working on figuring that bit out… Let us know if you figure that out!

Don’t like the schedule in 30-minute increments? Change it.

You can even set it to schedule in hour-long blocks. You just need to remove the bottom 24 lines, and go into the time scale in C7-however many you end up with. Data Validation will be fine left untouched, unless you want to further split it into, say, 15-minute increments.

The last thing you will need to modify is the initial formula in the Summary section for every summary, Including the one that says “Stream Schedule” on E2. (You have permission to edit that formula on that line.)

    =DIVIDE(COUNTIF(E6:K53,"Sleeping"),2) & " Hours a Week"
 to 1 HR increments
    =(COUNT(E6:K53,"Sleeping")) & " Hours a Week"

Nothing else needs to be modified, but it is important to chop it off from the bottom up to avoid dealing with the headache of deleting the Summary on the right side of the schedule.

Did you find this post helpful to you? Spread the word to help other content creators!
error

Leave a Reply

Your email address will not be published. Required fields are marked *