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.
Features of the Streamer’s Haven Schedule Maker
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.
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:
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 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.
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:
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. 🙂
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:
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.