square grid

D&D Maps using Spreadsheets

Ever since I first tried DM’ing, I have jumped from one method to another of creating maps for my D&D games. Recently I was using a Google Doc spreadsheet for something and it occured to me that I could use these to make maps.

What it is

I basically set the spreadsheet to be a small squared grid and apply conditional formatting to the entire grid along with a key of what means what. So once it’s set up, if I type a letter ‘T’ in a square, that square turns dark green and now represents ‘Trees’, same as ‘M’ means mountains and turns grey, ‘V’ means village, ‘C’ means city and shows as orange, and so on.

On top of the basic auto-colour coding mentioned above, you can right click any of the squares and ‘insert notes’ which gives you a text box to include any notes you have about that map-space(like a town name and who lives there)

Why it’s awesome

Super simple, hassle free
You can do it anywhere you like without needing any special software or apps (all browsers run google sheets i’m fairly sure). And it’s as easy as typing letters into a spreadsheet.

Can be shared easily
You can share it with friends thanks to the great sharing functions of google, you could even work on it at the same time as someone else(if you’re brave enough to try co-DMing).

Customisable
You can use the same method for world maps, town maps and dungeon maps. You could even make multiple pages of the documents for different levels of a dungeon.

Template/Example

I know not everyone is as into making spreadsheets as me, so below is a link to an example world map and city map (tabs down the bottom for different pages)

Example spreadsheet mapping

You should be able to click ‘File >> Make a copy’ to copy it and edit it yourself.

Other things you could do

- Hyperlink the letter to a google doc or another page in the spreadsheet
- Use symbols instead of letters, works well for dungeons, you could have slashes for up/down stairs etc.

Let me know

If you use this method please let me know how it goes for you, if you find this article confusing i’d love to hear about it so I can fix it up to make it more useful.

How to Start a Self-Care Bullet Journal

Hello journalers! This post is going to explain how to begin a bullet journal that will help you take care of yourself and manage your mental/physical health. I will go in depth and share various ideas to add to this kind of journal. 

How To Start: 

1. Like all bullet journals, make sure you have a journal that fits your needs. Dot grid, square grid, blank page, or lined are the options for basically all journals. Pick one that you can see yourself using for a while and that will conform to your needs. 

2. Make an outline on a separate piece of paper of the things you want in your self-care journal. Nothing is more cringe-worthy in my bullet journals is when I get lazy on design and layout. Figure out which lists, trackers, challenges, and calendars you will need. 

3. Start like you would with a normal bullet journal with the index. My rule is that I need to have 3 pages for my index, otherwise I run out of room to keep track of my pages and I get overwhelmed. 

Things To Add:

1. Future Plans/Goals

Pump yourself up for the future! You are going to accomplish many incredible feats during your lifetime, but it helps to take the first step and actually write down your goals and plans. I have two resources for you for this section. [Here] is a post about Goal Oriented Pages. Here is a picture of my bucketlist from my last bullet journal:

2. Fitness Log

If you are ready to get in shape or just be healthy, this is something you really need to stay motivated or keep track of your exercising habits. You can add checklists, hydration logs, running countdowns, etc. 

3. Daily Affirmations

When dealing with stress, mental health, and anything else that can get you feeling less than the amazing person you are, it’s good to remind yourself how truly fantastic you are. Here is a [link] to my 30-Day Affirmation Challenge. 

4. Gratitude Log

Being thankful for what you have will give you so much peace in your life. If you’d like some ideas for yours, click [here] for my 30-Day Gratitude Challenge.

5. Things That Make You Happy

List everything that makes you remotely happy and keep adding things as you go through your life. Below is my first journal that had my “Things I Love” page. It got filled so fast. 

6. Meditation Diary

I honestly loved this idea and used it like crazy. [Here] is a link to how I set my diary up. 

7. Habit Trackers

Keeping track of your actions will always help you feel at peace and there are many different kinds of habit trackers out there: medicine, sleep, reading, exercise, etc. If you’d like to be even more motivated for getting things done, [here] is a link to my Habit Tracker Reward System. 

8. Alternatives to Self-Destructive Acts

Many of us have negative habits that can be more extreme than others. But even the smallest self-destructive act will have a huge negative effect on your life. Here is a list of some ideas to do instead of thinking bad things or hurting yourself: do a puzzle, go exercise, take a nap, listen to music, watch funny videos, watch a movie, write, make lists, color a picture, bake something, etc.

9. When I Feel Triggered…

Anything can make us recall traumatic events, toxic people, or just make us feel anxious. Make a short list of maybe 5-10 things you can do to help yourself calm back down. 

10. All About Me

Writing and doodling things that represent yourself can be very therapeutic. I made a post about this recently that can be found [here].  

11. Self-Care Ideas/Me Time

Sometimes we don’t know how to make ourselves feel better. Write a list of things you could try to do to help yourself become a healthier you. Examples: take a warm bath, go for a walk, drink a glass of water, watch a sad movie, etc. You can also make a page to keep track of how long each task you complete and where you completed it. 

12. A Year In Pixels

I did not come up with this idea, but [here] is a post about where I found it and a picture of my page.

I found a few more ideas, but you can check this [link] for 100 more! 

4

1 October 2016

Today I decided to start a planner (or bullet journal? :o) and it was my first time making one. Honestly it was so fun and therapeutic that I took about 2hrs to do this haha. 2 more weeks till school starts, hopefully I can complete my assignments on time!