Last Updated on
This stream schedule creator is free for use and redistribution. 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 Stream Schedule creator
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 hover the existing categories for a list of example things that could fit within it.
Add your own Categories
We believe that the categories are specific enough to be easily discernable, yet general enough to be 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 Stream Schedule Creator
=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?
Simply change the format to”Duration.” Note, you will likely need to cheat the time when 24 rolls back to 0. This is the simplest way, and since we don’t need to do anything special with the formatting, easy is best.
A22 =TIME(0,0,0) A23 =A22+TIME(1,0,0) A24 =A23+TIME(1,0,0) ...
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.
Want to plan a stream collab with your stream team? Introducing the Streamer’s Haven Stream Collab Schedule sheet!
This stream collab planner was actually born from my DND group and quickly figuring out at a glance when all of us were available to run the dnd session. It was repurposed for Stream Teams & Collabs.
The features of this sheet include:
- A Schedule aggregation page to quickly determine when every single person is available for a collab session.
- UP TO 6 people supported for scheduling. You could add more if you wanted, but you’re on your own for the formula Its a bit complicated.
- EST, CST, MST. and PST conversion directly on the sheet in an easy to understand the layout
- Quick copy-paste blocks to change larger sections at a time.
- Hourly incremented
- Able to change the start time of every sheet within the book from the “Availability Sheet Cell H4”
- It’s Free!
You can change “Person1, Person 2” to whatever. The formula is targeting the sheet. However, do NOT use spaces. It won’t work with spaces. If you must use a separator, use _.