#google sheets

[physalian]

You don’t have to pay for that fancy worldbuilding program

As mentioned in this post about writing with executive dysfunction, if one of your reasons to keep procrastinating on starting your book is not being able to afford something like World Anvil or Campfire, I’m here to tell you those programs are a luxury, not a necessity: Enter Google Suite (not sponsored but gosh I wish).

MS Office offers more processing power and more fine-tuning, but Office is expensive and only autosaves to OneDrive, and I have a perfectly healthy grudge against OneDrive for failing to sync and losing 19k words of a WIP that I never got back.

Google’s sync has never failed me, and the Google apps (at least for iPhone) aren’t nearly as buggy and clunky as Microsoft’s. So today I’m outlining the system I used for my upcoming fantasy novel with all the helpful pictures and diagrams. Maybe this won’t work for you, maybe you have something else, and that’s okay! I refuse to pay for what I can get legally for free and sometimes Google’s simplicity is to its benefit.

The biggest downside is that you have to manually input and update your data, but as someone who loves organizing and made all these willingly and for fun, I don’t mind.

So. Let’s start with Google Sheets.

The Character Cheat Sheet:

I organized it this way for several reasons:

I can easily see which characters belong to which factions and how many I have named and have to keep up with for each faction

All names are in alphabetical order so when I have to come up with a new name, I can look at my list and pick a letter or a string of sounds I haven’t used as often (and then ignore it and start 8 names with A).

The strikethrough feature lets me keep track of which characters I kill off (yes, I changed it, so this remains spoiler-free)

It’s an easy place to go instead of scrolling up and down an entire manuscript for names I’ve forgotten, with every named character, however minor their role, all in one spot

Also on this page are spare names I’ll see randomly in other media (commercials, movie end credits, etc) and can add easily from my phone before I forget

Also on this page are my summary, my elevator pitch, and important character beats I could otherwise easily mess up, it helps stay consistent

*I also have on here not pictured an age timeline for all my vampires so I keep track of who’s older than who and how well I’ve staggered their ages relative to important events, but it’s made in Photoshop and too much of a pain to censor and add here

On other tabs, I keep track of location names, deities, made-up vocabulary and definitions, and my chapter word count.

The Word Count Guide:

*3/30 Edit to update this chart to its full glory. Column 3 is a cumulative count. Most of what I write breaks 100k and it's fun watching the word count rise until it boils over.

This is the most frustrating to update manually, especially if you don’t have separate docs for each chapter, but it really helps me stay consistent with chapter lengths and the formula for calculating the average and rising totals is super basic.

Not that all your chapters have to be uniform, but if you care about that, this little chart is a fantastic visualizer.

If you have multiple narrators, and this book does, you can also keep track of how many POVs each narrator has, and how spread out they are. I didn’t do that for this book since it’s not an ensemble team and matters less, but I did for my sci-fi WIP, pictured below.

As I was writing that one, I had “scripted” the chapters before going back and writing out all the glorious narrative, and updated the symbols from “scripted” to “finished” accordingly.

I also have a pie chart that I had to make manually on a convoluted iPhone app to color coordinate specifically the way I wanted to easily tell who narrates the most out of the cast, and who needs more representation.

—

Google Docs

Can’t show you much here unfortunately but I’d like to take an aside to talk about my “scene bits” docs.

It’s what it says on the tin, an entire doc all labeled with different heading styles with blurbs for each scene I want to include at some point in the book so I can hop around easily. Whether they make it into the manuscript or not, all practice is good practice and I like to keep old ideas because they might be useful in unsuspecting ways later.

Separate from that, I keep most of my deleted scenes and scene chunks for, again, possible use later in a “deleted scenes” doc, all labeled accordingly.

When I designed my alien language for the sci-fi series, I created a Word doc dictionary and my own "translation" matrix, for easy look-up or word generation whenever I needed it (do y'all want a breakdown for creating foreign languages? It's so fun).

Normally, as with my sci-fi series, I have an entire doc filled with character sheets and important details, I just… didn’t do that for this book. But the point is—you can still make those for free on any word processing software, you don’t need fancy gadgets.

—

I hope this helps anyone struggling! It doesn’t have to be fancy. It doesn’t have to be expensive. Everything I made here, minus the aforementioned timeline and pie chart, was done with basic excel skills and the paint bucket tool. I imagine this can be applicable to games, comics, what have you, it knows no bounds!

Now you have one less excuse to sit down and start writing.

#writing advice #writing resources #writing tips #writing tools #writing a book #writing #writeblr #organizing your book #outlining #shut up and write the book #google sheets #google docs

[izicodes]

Hey Xia, I'm a huge fan of Google sheets and absolutely love how you get yours laid out. Do you have any resources for someone who wants to get a little more familiar with the platform?

Hiya 💗

Sure, I'd be happy to help you get more familiar with Google Sheets! It's great to hear that you're a fan of how I organize things. 😄

I did learn how to use Google sheets back in school during IT lessons but here are some resources I've used lately just as a top up:

Google Sheets training and help - link

How to use Google Sheets: A complete guide - link

21 essential Google Sheets tips and tricks (2023 update) - link

Google Sheets Videos on YouTube (I don't have a specific, I just click any that helps) - link

And remember, practice makes perfect! Don't be afraid to experiment and make your own spreadsheets - this is how I learnt the most by just guessing and playing around. The more you play around with it, the more confident you'll become!

Good luck! 🙋🏾‍♀️

⤷ ♡ my shop ○ my mini website ○ pinned ○ navigation ♡

#my asks #resources #codeblr #coding #progblr #programming #studying #studyblr #learn to code #comp sci #tech #programmer #google sheets

[lord-fallen]

ALL-IN-ONE NANOWRIMO TRACKER: “NOVEMBER EVE” 

a highly customizable, automated but simple googlesheets for writers - especially for those participating in NANOWRIMO. perfect for tracking your progress with minimal effort while keeping your ideas in one place and keeping it aesthetically-pleasing with a dark-mode. to download / copy, go to file and click “make copy” to copy it to your gdrive. 

features: 

overview page for your wip incl. a refinement tracker for your chapters/excerpts

automated writing stats based on your progress

automated graph for tracking your word count

kanban board for your to-dos and tropes you want to feature

wall of fame for your favorite daily line

detailed writing session and word count tracker for every day with automated perks

fun achievements page incl. automated calendar that ticks off the days you've written on

please like / reblog if you’re using or interested in using it!

+ novel preparation doc for gDocs here.

#google docs template #gdocs template #docs template #docs #nanowrimo 2022 #gdoc template #google sheets template #google sheets #writing tracker #word tracker #writing resources #indiedocs #writeblr #nanowrimo

[bobbiprintables]

Free Monthly Expense Tracker - Google Sheets Template

Download Here

#free #monthly tracker #expense #tracker #expense tracker #budget #finance #template #spreadsheet #google sheets #budgeting #monthly

[pseudogirlie]

I made this originally for personal use for fun but I thought I’d make a blank version to share:

This is my best attempt to do a mock wiki format for BG3. Feel free to use, edit, make changes to for your own ocs ^__^ to use just copy a version to your drive! This is 100% inspired by the Inquisitor as a companion from a thousand years ago. I also have a dragon age mock document if people are interested.

If you want to make it “official” looking, I’d just save and insert pictures of items or icons from the official bg3 wiki.

There’s some weirdness with the pages causing unwanted breaks. Which I don’t care to fix but if you know how to feel free haha, I also have not made the banter/romance page yet… I may make more updates to this in the future too.

This does not work as a pageless document due to the tables and images. Unfortunately. If you are on mobile you will need to use print preview to make sense of it lol.

#baldur’s gate 3 #google sheets #character sheet #bg3 #tav #dark urge

[thiswasmadeonawhim]

Tsukino Productions Product Tracker

Yeah so i'm nuts and made myself a chronological release tracker for Tsukipro products cause I needed a way to keep track of everything i own/plan to get. A small preview inside:

Link below the cut!

I plan on keeping this updated month to month as a way to get myself back into the habit of being hardcore into the Tsukipro life. With the additional effect of making me happy if anyone found this useful in any way shape or form. All the titles are copied straight from the main sites so also easy to copy paste those into album info or anything needed.

This includes album releases, Blu ray/DVD releases, anything really that's a form of media to buy and consume.

The only shame is that the images had to be embedded in so no way to link to high-res cover art for anything. I didn't wanna add too many links to this page to make it hard to load either so it's really the most bare min I could get it.

If there's any products I missed in here, feel free to hit me up in DMs or via asks

#google sheets #tracker #tsukino productions #tsukipro #sun productions #sunpro #tsukiuta #six gravity #procellarum #fluna #seleas #alive #soara #growth #zix #SQ #solids #quell #altair theater #algeki #regulus #rigel #sargas #swiiiiiits! #noir revolution #white knight revolution #vazzrock #vazzy #rock down #x lied project

[traitsno]

Drawn in Google Sheets.

#art #drawing #sketch #mouse #mice #accounting #google sheets #rodent phase

[wtfcl0ud]

the tarot card spreadsheet

you can use this spreadsheet to do tarot card readings. i'd advise making a copy and using that. the only edits that are truly welcome on this original sheet shared here is adding in the missing meanings on the cards sheet. enjoy!

#tarot #excel #google sheets #self proclaimed nerd shit #cloud nonsense

[juniwinkle]

MEGA Doação de Cronogramas

Opa, quanto tempo! Decidi fazer essa doação de modelos que já foram liberados no @witchspellx no passado, mas que foram apagados com o fim dos jornais no SpiritFanfics. São 6 modelos, mas alguns tem uma segunda versão, totalizando 9 CRONOGRAMAS diferentes para vocês. Para baixar, vejam o fim do post!

1 - Agenda pessoal de 1 aba (2 versões: night & day)

2 - Cronograma para Desafios do Tumblr de 1 aba

3 - Cronograma multiuso de 1 aba

4 - Cronograma de icons de 1 aba (2 versões: day & night)

5 - Cronograma de escrita de 1 aba (2 versões: contagem de palavras & andamento da escrita)

6 - Cronograma de plots

. . . REGRAS

𝐈 OBRIGATÓRIO seguir @juniwinkle e @witchspellx e fav + reblog nesse post caso baixe; 𝐈𝐈 Você pode utilizar os modelos para se organizar, se inspirar para seus cronogramas ou como base para criar outros. Porém NÃO RETIRE OS CRÉDITOS EM HIPÓTESE ALGUMA E, CASO SE INSPIRE, CREDITE NO CRONOGRAMA; 𝐈𝐈𝐈 Para baixar o cronograma, faça uma cópia do arquivo clicando em Arquivo > Fazer uma cópia.

ᅟᅟᅟᅟᅟᅟᅟᅟᅟᅟ.download

#juniwinkle #tinker-baek #cronograma #witchspellx edits #cronogramas #google sheets #design #clean #layout #cronograma 2022 #crono #cronograma clean #cronomaker #graphic design #banner #google planilhas #cronograma divertido #doação #doação de capas #capas para doação #spiritfanfics #spirit fanfics #social spirit

[untitled-toh-blog]

Full MoringMark Post Directory

I've seen some people asking how they can read all of MoringMark's work for The Owl House, which can be a bit confusing (especially if you want to read them in order) since some of his work is split across multiple platforms. Additionally, scrolling back to try and find a specific post can be a bit difficult. So, I figured I could help out with this Google Sheets file that I made!

Right now, I have the spreadsheet showing all of his Owl House related posts on Reddit, Tumblr, and Instagram (although his Tumblr and Instagram are basically the same, I figured I'd include the option!). Not all of his posts have an actual title, so in those cases, I just wrote in "placeholder" titles that I thought fit well enough (those titles are written in grey). I also included the dates they were posted, as well as the dates that episodes of TOH aired (since that helps a bit with context, to clarify what we did and didn't know at the time!).

Hopefully somebody finds this helpful! I don't really plan on updating it daily or anything like that, since it's mostly to help find his older posts, but will probably add onto it every once in a while!

#toh #the owl house #moringmark #google sheets

[timetravelingcourtney]

Google Sheets to Catalog Collections

Hey friends, over on Reddit I got a request to upload my sheets for cataloging my collection. Thought I would share it out here. I think I have every item for each doll. There's a check box and then a drop down menu for AG/PC/Rerelease etc. Feel free to make your own copies!

#american girl #pleasant company #kirsten larson #samantha parkington #courtney moore #molly mcintire #josefina montoya #american girl of today #felicity merriman #google sheets #collection #catalog

[sivianna]

Sul Sul Fellow Simmers :)

WIP Super Sim Spreadsheet. I took @book2sims orginal sheet and put my twist on it. Let me know if anyone wants a copy <3

#sims 4 #spreadsheets #sims 4 challenge #super sim challenge #wip #the sims community #simblr #the sims 4 #the sims #google sheets #Super sim checklist

[izicodes]

I made an autumn-themed anime tracker for Google Sheets! (I love Google sheets so much now, it's ridiculous) I had one for just general anime shows I watched over the past few years but I wanted to make a themed one so as it's Autumn, I made the tracker in autumn colours~!

With the new tracker, you can easily log all the shows you're watching, mark episodes as watched, and even jot down some notes. It's like a personal anime journal! I added stuff like changing colours depending how long between the start and end dates for each show you add and a dropdown with the majority of anime genre to categories your shows~!

If you're into anime and love staying organized, check it out : Autumnal Anime Tracker | Google Sheets @ The XiaCodes' Shop

Also watch Trigun! 🤞🏾🌷

#my shop #my resources #resources #anime shows #anime #tracker #studyblr #studying #tech #productivity #student life #productivitytips #codeblr #organisation #coding #progblr #google sheets #autumn #autumn aesthetic #fall season #fall aesthetic

[posicanonical]

For my first post, I'm going to show just how nerdy I am by sharing a Sheet that I made to track the Sandrockers' favorite gifts. All image credits go to the official MTaS Wiki, but my goal was to organize the lists into a more easily accessible form so that I don't have to click around on a bunch of different pages. The first tab is alphabetical by name, and the second is in order of birthdate. I hope someone else finds it useful!

#my time at sandrock #mtas #gift guide #best friends #bff #google sheets #pdf #nerd #fandom wiki #fandom #organization #like #love #mtas builder #gifts are not my love language #but imma grind for that affinity #mtas fang #mtas unsuur #mtas heidi #mtas mian #mtas justice #mtas logan #mtas pablo #mtas captain #mtas x #mtas zeke #mtas trudy #everyone else gets water

[fuck-yeah-spreadsheets]

#poll #polls #spreadsheets #spreadsheeting #spreadsheet #pride flag #vote #actually autistic #special interest #data #numbers #google sheets #microsoft excel #excel #sheets

[lesbiansupernatural]

As a neurodivergent fucker myself, it's always so very rewarding any time I can introduce one of my equally neurodivergent peers to the joys that is microsoft excel/google sheets.

Anyways, here's a link to a google sheets version of my supernatural masterdoc tracking every on-screen death. It's filled with some pretty creative solutions and formulas if I dare say so myself

(I work in excel, but it's a bit finnicky with sharing there, so just lmk if you want the proper document and I can mail you the file. Had to remove a couple of things that didn't translate to google, so the true document also has a list of every single killer in the show, and a list of episodes with no deaths)

#oh and there's a scar map #one drawing for every season #currently working on season 7 #supernatural #neurodivergent #neurodiverse #neurodiverse stuff #neurospicy #tourettes #tourettes syndrome #excel #microsoft excel #google sheets