 |
 |
Parallel Visions: City of Angels City of Demons ebook and trade paperback available on Amazon (or here). |
 |
 |
|
Welcome to 2020! Let's get some writing done.
Track your writing progress in 2020 using this free spreadsheet.
|
||||
2020 Writing log spreadsheet
 | |
| 2020 Writing log spreadsheet |
Happy New Year!
As is my tradition, I am posting my writing log (2020_Writing_log.ods) for the forthcoming year and wish everyone a productive year, whether or not you a writer.
Feel free to download this LibreOffice spreadsheet (link below) to track your writing productivity on a day by day, week by week, and month by month basis.
| Tags: | 2019, 2020, Writing, Log, Spreadsheet, ANwL, LibreOffice, OpenOffice, Word Smithy, Writing Tool, Getting Writing Done |
I've added a few statistical summaries to the Project page:
.jpg)
Download the spreadsheet here: 2019-2020_Writing_log.ods ( or 2020_Writing_log.ods for a version that excludes the 2019 example pages. )
You will need a copy of LibreOffice to use this spreadsheet.
I've been using spreadsheets since 2005 to track my daily word output, which can be considered a form of don't break the chain. The tracking of output on a daily basis is, I believe, to be the reason I finished my first novel.
You don't need to write using LibreOffice to make use of this spreadsheet. (But if you do, or might be thinking about using LibreOffice, see Authoring Novels with LibreOffice.)
See master writing log for more detailed information and examples.
Project page
The project page summarizes your writing project status. It is broken up into five sections, four for projects in barf (that is, 1st draft) up to publication, incubator, published, and trunked.
Customization
My approach to writing is based on barf and polish. Thus my writing phases labels are:
.jpg)
You can change the labels you apply to the status of a project.
2020 Daily Log
Track daily word deltas for 2020.
Add one row per day per project. It will automatically be summed in the weekly and monthly delta pages.
2020 Weekly Delta
Weekly summaries for 2020.
2020 Monthly Delta
Monthly summaries for 2020.
Example Daily Log
Example daily word deltas for 2014.
Example Weekly Delta
Example weekly summaries for 2014.
Example Monthly Delta
Example monthly summaries from 2014.
Links and Notes
A few links.
Config
Configuration fields.
Appendix
last_one2 VB Function
This spreadsheet includes a VB function for finding a project's most recent day in a given year. Ultimately, this populates the "Last Entry" column on the Projects page.
Function last_one2(searchList,target,resultList) REM =last_one2(A1:A14;"target";B1:B14) dim i as integer rem last_one2 = 0 for i = lbound(searchList,1) to ubound(searchList,1) if searchList(i,1) = target then last_one2 = resultList(i,1) next End function
If the "Last Entry" column is not being populated, turn on macros.
If the "Last Entry" column is still not being populated, then this function can be installed as follows:
- Tools → Macros → Organize Macros → LibreOffice Basic...
- In the Basic editor:
- Expand this spreadsheet
- Click on Standard
- Add Module
- Paste the contents of the pre-format box above at the end.
- Save and close Basic editor.
See
- Authoring Novels with LibreOffice
- Definition list of writing project files
- Using LibreOffice Writer templates
- Configuring LibreOffice Writer
- Example project: A Princess of Mars
- Example project: The Scarlet Pimpernel
- LibreOffice annoyances
- LibreOffice versus Microsoft Word
- Managing multiple writing projects
- My writing process
- Reasons to use master documents in LibreOffice
- Page layout notes
- Spelling and grammar check in LibreOffice
- Using markup to import and export text
- Using master documents and styles
- Writing markup notes
- Writing with markup
- (v)
Recent Related Changes
Recent Topics with Comments
Recent Blog Topics
- Google Plus posts
- NavFritzBlogs
- Retro-Future Automobile
- Music Monday
- Danger 5 (trailer)
- What do we want? Time travel...
- The Venture Brothers (TV series)
- Avatar and the Three Pillars of Storytelling
- A Travelogue on the Path to Publishing Dispensing Justice
- TPPDJ Link -- 10 Reasons You Should Skip the Traditional Publishers and Self-Publish by Robert Bidinotto
- TPPDJ Link -- Professional Writers -- The Business Rusch
Back to the Blog
- 2020 Writing log spreadsheet
- 2019 Writing log spreadsheet
- 2018 Writing log spreadsheet
- 2017 Writing log spreadsheet
- 2016 Writing log spreadsheet
- 2015 Writing log spreadsheet
- Authoring Novels with LibreOffice
- Authoring novels with LibreOffice external links
- Authoring Novels with LibreOffice FAQ
- Example project: A Princess of Mars
- Example project: The Scarlet Pimpernel
- Managing multiple writing projects
- Master writing log
- Project Based Writing
- Styling your novel for ebook publication
- ANwL subsections and related topics
- ANwL recent changes
- ANwL (category)
- (v)
.jpg){kind=small}
Categories
- 2019 (category)
- 2020 (category)
- 2020 Blog (category)
- ANwL (category)
- Fritz Blogs (category)
- Fritz Blogs in 2020 (category)
- Getting Writing Done (category)
- Has Banner (category)
- Has Data Table (category)
- Has DynamicPageList (category)
- Has FirstImage (category)
- Has Image (category)
- Has Infobox (category)
- Has Layout (category)
- Has Layout Base (category)
- Has Nav (category)
- Has Navbox (category)
- Has Tags (category)
- LibreOffice (category)
- Log (category)
- OpenOffice (category)
- Spreadsheet (category)
- Word Smithy (category)
- Writing (category)
- Writing Tool (category)
.jpg)
.jpg){kind=small}
_(poster).jpg)
.jpg)
.jpg){kind=small}