Simplifying the process

FREE TOOLS

Word | Page Count Tracker

Screen Shot 2021-06-16 at 4.56.12 PM.png

WORD TRACKING TOOL

An easy-to-use word count tracking spreadsheet in google drive. Just enter desired total word count and the number of days, it’ll do the rest. To use, make a copy, and go. It provides the same daily goal per day regardless of progress.

https://docs.google.com/spreadsheets/d/12R-AkVsdv3uuCC6mRYLS-DcokTMJBMTDMN5DJAMfYXQ/edit?usp=sharing

Screen Shot 2021-06-16 at 4.56.31 PM.png

ADVANCED WORD TRACKING TOOL

This is a more advanced word tracking tool. Again, enter desired word count and number of days, and it will calculate the daily goals. HOWEVER, each day’s goal is based on prior days’ work.

https://docs.google.com/spreadsheets/d/1E-pAlNFS9HyMJIFstp9h3c7z0k8snkwa4dO5nQH1dkM/edit?usp=sharing

Screen Shot 2021-06-16 at 4.59.06 PM.png

SPRINT TRACKER

Like to sprint? This document offers two tabs: one for sprints were you count the words, and the other is based on start/end of the document’s word count. You enter the starting word count before your first sprint and then for each sprint enter the end word count. It will automatically pull the word count down to the next day’s sprints.

https://docs.google.com/spreadsheets/d/1_0MIZoQsJBVv-ZTo_4odSHn6f55JlWJfZrciXjHq5FM/edit?usp=sharing

Screen Shot 2021-08-14 at 8.55.41 AM.png

FAST DRAFT DAILY GOAL WITH GRAPH

An easy-to-use word count tracking spreadsheet in google drive. Just enter the starting word count, desired total word count and the number of days, it’ll do the rest. Each day enter your word count in the sprint sections. The next days’ goal will automatically adjust based on what was completed each day.

To use, make a copy, and go.

https://docs.google.com/spreadsheets/d/1YVJN1sZLdAFKfevXZq6Mb4v1MLVFjzXi/edit?usp=sharing&ouid=101027655458537943096&rtpof=true&sd=true

Screen Shot 2021-08-13 at 11.14.33 PM.png

FAST DRAFT DAILY GOAL WITH GRAPH & DATE

An easy-to-use word count tracking spreadsheet in google drive. Just enter the starting word count, desired total word count and the number of days, it’ll do the rest. Each day enter your word count in the sprint sections. The next days’ goal will automatically adjust based on what was completed each day.

The difference between this one and the other, is this one uses today’s date to limit view of the daily goals.

To use, make a copy, and go. Google docs formatting is not as flexible as Excel. Some formatting is different between the two versions.

https://docs.google.com/spreadsheets/d/1E-pAlNFS9HyMJIFstp9h3c7z0k8snkwa4dO5nQH1dkM/edit?usp=sharing

FAST DRAFT GROUP TRACKER

I have a tracker that is built to track each persons’ goals by day and for the fast draft time period.

If you are interested in something like this, please contact. The sheet requires in-person instructions to use correctly.

Screen Shot 2021-06-16 at 5.00.13 PM.png

SCHEDULE TEMPLATE

This schedule uses the spreadsheet tabs for each week. You can select start date and intervals (15/30/60 minute). It will populate throughout the tabs. Currently it is set up for 16 weeks. Directions on how to use are on the intro-tab.

File - direct excel document because google docs cannot handle all features

https://drive.google.com/file/d/1hsm79g4au57ve83pzK-NeEb4oBJUXE_4/view?usp=sharing

Screen Shot 2021-06-16 at 5.00.55 PM.png

REVISION GOAL TRACKER

This tool is built to calculate daily goals based on starting word count, desired end word count, and a specific number of days to work (it goes to 90 days). Currently the color coding is built for adding words. If you are cutting words, let me know, and I’ll adjust it.

To use, make a copy, and go.

https://drive.google.com/file/d/1vSQC-cbsRj5UFWpE7Uie0Kyu6Vi2szdC/view?usp=sharing

Process Tools

Screen Shot 2021-06-16 at 5.02.43 PM.png

OUTLINE COMPARISONS

There are so many options when it comes to outlining. Here are a few examples lined up to show commonalities. IF you’d like one added, send me a message with its name. I’ll do my best to map it.

https://docs.google.com/spreadsheets/d/1LBAzyoXcQFzgEW06ldG2WIa3MLH5wWgBhJktFkBBZVM/edit?usp=sharing

STC BEAT CALCULATOR AND GRID

Enter your word count into the calculator tab and it will calculate the number of beats per section. On the grid tab, for 22,000-150,000, it will auto populate and make a template to use to plot. I highly recommend reading

Save The Cat! Writes a Novel by Jessica Brody

https://drive.google.com/file/d/1z4Ae7wyjEampxwNv8XA_HLLOmCtwmzSD/view?usp=sharing

STC ROMANCING

Enter your word count into the calculator tab and it will calculate the number of words per section. I HIGHLY recommend reading

Romancing the Beat by Gwen Hayes

https://docs.google.com/spreadsheets/d/1tRqWPC3U0dja9RgETSjWiDivu30xNEw8/edit?usp=sharing&ouid=101027655458537943096&rtpof=true&sd=true

Screen Shot 2021-06-16 at 5.04.10 PM.png

Polishing Tools

Screen Shot 2021-06-16 at 5.04.26 PM.png

REVISION CHECKLIST

This is a generic checklist based off different programs. I use it as I go section by section.

https://docs.google.com/spreadsheets/d/1tFTTxTZ8erRGvmMcfYm21aqUw-ZRGYTn9EtFCYF4r0g/edit?usp=sharing

Screen Shot 2021-06-16 at 5.04.37 PM.png

FEEDBACK TYPE

An easy to provide form that provides feedback descriptions to better understand the expected feedback.

https://drive.google.com/file/d/1OFKWcOH0obRu-9HqJfRTA6wArfXntAm2/view?usp=sharing

Business Tools

 
Screen Shot 2021-06-16 at 5.04.51 PM.png

BALANCE SHEET

A basic spreadsheet to keep track of business expenses. Note this is a beta version and not completely formatted but it is usable.

https://docs.google.com/spreadsheets/d/14UHrjUMtbbbuI70dXoecG8A8guguzOnISHO6zmDcPmo/edit?usp=sharing

Screen Shot 2021-06-16 at 5.05.16 PM.png

QUERY RECORDER

Keep track of who you queried, response times, and stats on responses.

Available in GoogleDocs: https://drive.google.com/file/d/1oIeRV2AilGuI8F7-BNCt-ssYdUyocrLG/view?usp=sharing

The format is a bit weird in GoogleDocs

And as an EXCEL download.

unsplash-image-3OiYMgDKJ6k.jpg

RESOURCES

An on-going list of resources for writing a novel.

https://docs.google.com/document/d/1pd87MZRYr8FhbJoVvEGcOVGecKT6lFXfWvdg1-amvus/edit?usp=sharing

Planners and Organizers for sale!

Etsy

Want PDF downloads of writers’ planner pages, notecards, scene sheets, One Month Novel, and more? Visit my Etsy store for easy to use writing tools!

https://www.etsy.com/shop/AJRWriterDesigns?ref=seller-platform-mcnav

Amazon

Want planners and plotting tools but don’t want to print them yourself? Visit my Amazon store for print-on-demand planners, planning tools, and One Month Novel!

https://www.amazon.com/stores/Amelia-Rivers/author/B0BS2SBRRJ