Rebecca's2017Spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
Setup and Instructions Page
2
The explanations in this set up page might get redundant or seem obvious to those who are using it. But since I planned on sharing it, I tried to make the instructions as detailed as possible, because I don't know how familiar the user will be with google sheets.A yellow highlight means you input information in that spot or that columnSave a copy of this to your drive, rename it and start filling it in.This looks like a lot of work, but basically, if it's highlighted yellow, you put something in the cell or column.
3
4
Statistics Page InstructionsOverviewMonth by monthSprint PageAwesome WIPRevisions Page
5
3. To begin enter you yearly word count goal in cell B9. That will set up the calculations on that page.1. The first three Awesome WIP pages are linked to the Overview page for you. I've put instructions on how to link future WIP pages in the instructions for the WIP section.Simply enter your day's total on the correct month and day and it will tally on its own.1. I set up the sprint page to keep track of individual sprints so I could put the end total of words at the end of the writing session and it would tabulate the number of words I typed.each sprint.1. There are a few things you need to do before you get startedlist your tasks.
6
4. The Month by Month page are the totals connected to the statistics page be sure to fill them in each day. Because I sometimes work on more than one WIP in a day, I needed both a WIP page and a total by month page.2. There's a spot for your revision progress to display, too. The first is linked. To link the ones after it. Go to the blank space under Title in Revision. Click =. Go to new copy of revision page. Click the title in cell A3. Click enter. Next on the blank under sections complete, click =. Go to revision page. Click cell C3. Hit enter. It's done.The charts will function correctly once you enter your word count in the cells even though they look a little weird at the moment. It's because they have only one set of data to go on.2. There's quite a bit to enter on this page. Most is self explanatory. Date, title, time start, time end. Set # might seem a little strange if you haven't done pomodoros. The 25 minute sessions are done 4 per set with 5 minute breaks between the first 3 and a longer break after the 4th. I highlighted the headers of the cells you fill in with yellow. But you don't have to use 25 minute sprints. You could use 15 minutes or 30. Or 12, 10, 60. Whatever suits you.2. Insert your target daily word count in b3 cell and the sheet will update on target hit or miss.when you get started and finish a task simply click x in the column with the check mark heading it will cross off that task and count it as completed.
7
If you finish and don't want to see the finished WIP page, I recommend hiding it. You'll still be able to see everything you've done and the links will remain intact while the finished page won't be cluttering the task bar3. The other boxes here are to chart the finished WIP you've completed this year. I suggest just typing in the information, although you could link it in the same manner you've done before. Quick Review. On the Finished WIP chart, under the title heading, type =. Click the tab of the finished WIP and then click they title. After that, under the finished word count section of the chart on the overview page, type =. Go to the finished WIP tab. Click it. Then click on cell J5. Done.I've added some formatting here if you want to keep track of the days you revise, edit or are ill. Type Edit and the cell will change to orange. Type Rev when you're wanting to revise and the cell will fill with purple. Type Ill when you're sick and the cell will fill with green.3. Beginning word count. The word count at the beginning of this sprint.3. Insert the goal or projected book length in cell b4The words added columns and words cut columns are there if you want to keep track of that aspect of your revisions. Sometimes I do, sometimes I don't.
8
There is also a WIP tracking section on the statistics page so that can get a quick glance of what needs to be done on each WIP. The title and total are linked here. Simply answer yes or no to finished or edited and it will give you a color code so that you can know where you are on the book.To create a chart for your awesome WIP, highlight the entire 3x2 table click chart. Select the pie chart. 4. The end word count. Enter your end word count in the box.4. Enter your starting total on cell C8Before you fill in the revisions page, I recommend you make a copy of it so that you'll always have a blank revision sheet to use.
9
You'll need to link new WIP when you start them after the first three. Under WIP chart--heading title on the statistics page in a blank cell, type =. Click the tab of your new WIP and then on the sheet click title. Then hit enter. Under word count, type =. Click your new WIP page. Maneuver over to cell I3 and click it. Hit enter. That's done.5. Words Typed, words per minute, words per hour will automatically calculate after you feel in your beginning word count and words you typed during your sprint.5. After that, you only need to enter the end total word count Words added per day in column F will total on its own. That will be added and totals updated. The words added per day will change color to notify you of whether your on track for your goal, green, hitting your goal exactly, orange, or missing your goal, red.
10
6. Location: where you did the sprint.(Remember to enter your words added on the Month by Month page in the month and day so that your stats page can update correctly.)
11
7. Notes can be anything you want to write down at the beginning or end of your session, perhaps it's a bit of line that came to you just as you finished the session and you don't want to forget it. Or an idea on where to go next.6. Fill in the date each day you write on your WIP to help track your consistency over time.
12
8. Distractions is just what it says. Anything that distracted you or annoyed during the session.7. In Column L, you'll find a bar chart that displays the percentage finished on your WIP.
13
There are over 500 rows of formatted space for you to enter your sprints. If you need more lines, you can get more in an easier way than copying the sheet and erasing the data you entered. Or you could highlight the areas that you filled in, date, time, title, set, sprint, beginning word count. Go to the edit tab above and click delete values. Do the same for end word count. After that do it again, for location, notes, and distractions8. When you finish the book, enter the finished word count in cell J5. After that, if you don't want to have to tab past the finished page, you can hide it. Right click on the finished WIP tab, click hide. If you want to unhide it, go to view tab, click on hidden sheets from the drop down menu and select the sheet.
14
To do that, go to the last formatted box on column I and click it. There will be a small square at the bottom right hand side. Click that and drag down until you think you have enough space. Release and if you clicked the box you'll have a newly formatted line. Do the same to column K and then L. Frame the expanded area with a border and you've got more space.9. Before you start to fill in Awesome WIP 3 with data, I recommend copying it so that you always have an empty one ready for your next WIP. The formulae will copy with it and survive retitling the tab.
15
Alternately, before you start the Sprints, you could make a copy and hide it using the hide function. When you're ready to use it, unhide it and hide the filled in sprint page or erase it since it's not linked to any of the other pages.10.Before you start a wip after these first three, you will need to link it to the Overview page so that will update as you work. On the overview page in an unlinked box, to the right of title, type =. Click new WIP tab, go to title of your new WIP at top of page and click it. Hit enter. Next, on overview page, go to box to the right of goal, type =. Click new Wip page. Click cell B4. Hit Enter. Finally, on overview page, go to cell to the right of Actual, click the empty cell. Type =. Go to Wip page, click cell I3. Hit enter. It's linked.
16
You'll want to rename the tabs here to match your WIP title, right click. Click on rename. Type in new name.
17
In cell I5, you'll find a projected completion date. You don't have to do anything to it. It's just there to tell you when you might finish based on the information you've entered into the worksheet.If you've entered a deadline date even if it's a goal, if the date is less than the deadline, the projected cell will turn green, if you're right on track and should finish on the deadline day, it's orange. If you'll finish after deadline the cell is shaded red.
18
In cell B5, I've added a place for you to put a deadline date in case you want to use that as a motivation factor-or you actually have a deadline. Simply input the date.
19
In cell F5, you'll find the target number of words per day you'll need to type to meet your deadline.
20
in cell I2 and j2, you'll find formula, please don't mess with them. Altering them will mess with the calculations for target words per day.
21
And a quick addendum. I know that the target words per day number looks strange at the start. When you fill in a deadline date, it will start calculating correctly.
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
SetUp
Statistics
Monthby Month
WIP &Revision Overview
Sprint page
AwesomeWIP1
AwesomeWIP2
AwesomeWIP3
Revisions
 
 
Main menu