2020 Writing log spreadsheet

float= The Red Rook (cover).png

Parallel Visions: City of Angels City of Demons ebook and trade paperback available on Amazon (or here).
The question of whether Vance was dead or not became more than academic when he found himself in a bathtub up to his chin in ice water like some forgotten cocktail garnish, a demonic woman standing over him, and no memory of how he got there.
Read free chapters of Parallel Visions: City of Angels City of Demons here
The Red Rook, sequel to Dispensing Justice and the second novel of Nova Genesis World is now available for Kindle or as a paperback at Amazon.
Read free chapters of Dispensing Justice here (or get it here).
Read free chapters of The Red Rook here (or get it here). -- Fritz Freiheit

Dispensing Justice (cover).png 20th Annual Writer's Digest Self-Published Book Awards - Honorable Mention.png
Welcome to 2020! Let's get some writing done.
Track your writing progress in 2020 using this free spreadsheet.
Article icon.svg
 v  d   
Picture
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.



I've added a few statistical summaries to the Project page:

2019-2020 Writing log - Project statistics.(screenshot).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.

2019-2020 Writing log - Projects.(screenshot).jpg

Customization

My approach to writing is based on barf and polish. Thus my writing phases labels are:

Writing phases flow diagram (vertical).jpg

You can change the labels you apply to the status of a project.

2014-2015 Writing log - word count totals - change status labels.jpg

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.


2015-2016 Writing log - 2016 Daily Log.(screenshot).jpg

2020 Weekly Delta

Weekly summaries for 2020.

2015-2016 Writing log - 2016 Weekly Delta.(screenshot).jpg

2020 Monthly Delta

Monthly summaries for 2020.

2015-2016 Writing log - 2016 Monthly Delta.(screenshot).jpg

Example Daily Log

Example daily word deltas for 2014.

2014-2015 Writing log - 2014 Daily Log.(screenshot).jpg

Example Weekly Delta

Example weekly summaries for 2014.

2014-2015 Writing log - 2014 Weekly Delta.(screenshot).jpg

Example Monthly Delta

Example monthly summaries from 2014.

2014-2015 Writing log - 2014 Monthly Delta.(screenshot).jpg

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.





2019-2020 Writing log - Projects.(screenshot).jpg
v  d  


2019 Writing log spreadsheet

float= The Red Rook (cover).png

Parallel Visions: City of Angels City of Demons ebook and trade paperback available on Amazon (or here).
The question of whether Vance was dead or not became more than academic when he found himself in a bathtub up to his chin in ice water like some forgotten cocktail garnish, a demonic woman standing over him, and no memory of how he got there.
Read free chapters of Parallel Visions: City of Angels City of Demons here
The Red Rook, sequel to Dispensing Justice and the second novel of Nova Genesis World is now available for Kindle or as a paperback at Amazon.
Read free chapters of Dispensing Justice here (or get it here).
Read free chapters of The Red Rook here (or get it here). -- Fritz Freiheit

Dispensing Justice (cover).png 20th Annual Writer's Digest Self-Published Book Awards - Honorable Mention.png
Welcome to 2020! Let's get some writing done.
Track your writing progress in 2020 using this free spreadsheet.
Article icon.svg
 v  d   
Picture
2019 Writing log spreadsheet



Happy New Year!

As is my tradition, I am posting my writing log 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.



I've added a few statistical summaries to the Project page:

2018-2019 Writing log - Project statistics.(screenshot).jpg

Download the spreadsheet here: 2018-2019_Writing_log.ods ( or 2019_Writing_log.ods for a version that excludes the 2018 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.

2018-2019 Writing log - Projects.(screenshot).jpg

Customization

My approach to writing is based on barf and polish. Thus my writing phases labels are:

Writing phases flow diagram (vertical).jpg

You can change the labels you apply to the status of a project.

2014-2015 Writing log - word count totals - change status labels.jpg

2019 Daily Log

Track daily word deltas for 2019.

Add one row per day per project. It will automatically be summed in the weekly and monthly delta pages.


2015-2016 Writing log - 2016 Daily Log.(screenshot).jpg

2019 Weekly Delta

Weekly summaries for 2019.

2015-2016 Writing log - 2016 Weekly Delta.(screenshot).jpg

2019 Monthly Delta

Monthly summaries for 2019.

2015-2016 Writing log - 2016 Monthly Delta.(screenshot).jpg

Example Daily Log

Example daily word deltas for 2014.

2014-2015 Writing log - 2014 Daily Log.(screenshot).jpg

Example Weekly Delta

Example weekly summaries for 2014.

2014-2015 Writing log - 2014 Weekly Delta.(screenshot).jpg

Example Monthly Delta

Example monthly summaries from 2014.

2014-2015 Writing log - 2014 Monthly Delta.(screenshot).jpg

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.



Getting Writing Done (category)

ANwL (category)


2018-2019 Writing log - Projects.(screenshot).jpg
v  d  


2019 Writing log spreadsheet early release

float= The Red Rook (cover).png

Parallel Visions: City of Angels City of Demons ebook and trade paperback available on Amazon (or here).
The question of whether Vance was dead or not became more than academic when he found himself in a bathtub up to his chin in ice water like some forgotten cocktail garnish, a demonic woman standing over him, and no memory of how he got there.
Read free chapters of Parallel Visions: City of Angels City of Demons here
The Red Rook, sequel to Dispensing Justice and the second novel of Nova Genesis World is now available for Kindle or as a paperback at Amazon.
Read free chapters of Dispensing Justice here (or get it here).
Read free chapters of The Red Rook here (or get it here). -- Fritz Freiheit

Dispensing Justice (cover).png 20th Annual Writer's Digest Self-Published Book Awards - Honorable Mention.png
Welcome to 2020! Let's get some writing done.
Track your writing progress in 2020 using this free spreadsheet.
Article icon.svg
 v  d   
Picture
2019 Writing log spreadsheet



2019 is almost here! Get your 2019 writing log spreadsheet now (link below) to track your writing productivity on a day by day, week by week, and month by month basis.



I've added a few statistical summaries to the Project page:

2018-2019 Writing log - Project statistics.(screenshot).jpg

Download the spreadsheet here: 2018-2019_Writing_log.ods ( or 2019_Writing_log.ods for a version that excludes the 2018 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.

2018-2019 Writing log - Projects.(screenshot).jpg

Customization

My approach to writing is based on barf and polish. Thus my writing phases labels are:

Writing phases flow diagram (vertical).jpg

You can change the labels you apply to the status of a project.

2014-2015 Writing log - word count totals - change status labels.jpg

2019 Daily Log

Track daily word deltas for 2019.

Add one row per day per project. It will automatically be summed in the weekly and monthly delta pages.


2015-2016 Writing log - 2016 Daily Log.(screenshot).jpg

2019 Weekly Delta

Weekly summaries for 2019.

2015-2016 Writing log - 2016 Weekly Delta.(screenshot).jpg

2019 Monthly Delta

Monthly summaries for 2019.

2015-2016 Writing log - 2016 Monthly Delta.(screenshot).jpg

Example Daily Log

Example daily word deltas for 2014.

2014-2015 Writing log - 2014 Daily Log.(screenshot).jpg

Example Weekly Delta

Example weekly summaries for 2014.

2014-2015 Writing log - 2014 Weekly Delta.(screenshot).jpg

Example Monthly Delta

Example monthly summaries from 2014.

2014-2015 Writing log - 2014 Monthly Delta.(screenshot).jpg

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.



Getting Writing Done (category)

ANwL (category)


2018-2019 Writing log - Projects.(screenshot).jpg
v  d  


5 Things Only Serious Writers Do (link)

float= The Red Rook (cover).png

Parallel Visions: City of Angels City of Demons ebook and trade paperback available on Amazon (or here).
The question of whether Vance was dead or not became more than academic when he found himself in a bathtub up to his chin in ice water like some forgotten cocktail garnish, a demonic woman standing over him, and no memory of how he got there.
Read free chapters of Parallel Visions: City of Angels City of Demons here
The Red Rook, sequel to Dispensing Justice and the second novel of Nova Genesis World is now available for Kindle or as a paperback at Amazon.
Read free chapters of Dispensing Justice here (or get it here).
Read free chapters of The Red Rook here (or get it here). -- Fritz Freiheit

Dispensing Justice (cover).png 20th Annual Writer's Digest Self-Published Book Awards - Honorable Mention.png
Welcome to 2020! Let's get some writing done.
Track your writing progress in 2020 using this free spreadsheet.
Article icon.svg
 v  d   
Picture

To sum up:

  1. Show up regularly.
  2. Get started, no matter how inspired they’re feeling.
  3. Think on paper.
  4. Get bored, and understand it’s part of the process.
  5. Meet their deadlines no matter the hardship or duress.

https://www.copyblogger.com/serious-writers/

Tags:Link, On Writing, Writing, GWD, Getting Writing Done
Comment:Obviously, if you are going to get writing done you are going to have to show up. It won't surprise you if I confess that when I "fall off the wagon" and don't schedule time everyday for writing, it doesn't get done. So, yeah, #1 is critical. For #2, I find that caffeine really helps (weekdays, I write first thing in the morning). Not so sure about #3, but if I translate this into "barf" mode, then, yeah, getting it written helps with the ideas. Another way to look at #3 is write your ideas down. Take copious notes and consult them as necessary. All I can say about #4 is that I only get bored with the process of writing, not the results. I find that showing up, mood enhancement with caffeine, and keeping the fact that I love having written gets me through the boredom. As to #5, well, that is almost entirely self imposed. See my response to #4.
v  d  


2018 Writing log spreadsheet

float= The Red Rook (cover).png

Parallel Visions: City of Angels City of Demons ebook and trade paperback available on Amazon (or here).
The question of whether Vance was dead or not became more than academic when he found himself in a bathtub up to his chin in ice water like some forgotten cocktail garnish, a demonic woman standing over him, and no memory of how he got there.
Read free chapters of Parallel Visions: City of Angels City of Demons here
The Red Rook, sequel to Dispensing Justice and the second novel of Nova Genesis World is now available for Kindle or as a paperback at Amazon.
Read free chapters of Dispensing Justice here (or get it here).
Read free chapters of The Red Rook here (or get it here). -- Fritz Freiheit

Dispensing Justice (cover).png 20th Annual Writer's Digest Self-Published Book Awards - Honorable Mention.png
Welcome to 2020! Let's get some writing done.
Track your writing progress in 2020 using this free spreadsheet.
Article icon.svg
 v  d   
Picture
2018 Writing log spreadsheet



Happy New Year!

It has become a tradition for me to release a writing log 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.


For those who might want to comment (and don't want to figure out how my wiki works), you can comment on the blog version of this page.



I've added a few statistical summaries to the Project page:

2017-2018 Writing log - Project statistics.(screenshot).jpg

Download the spreadsheet here: 2017-2018_Writing_log.ods ( or 2018_Writing_log.ods for a version that excludes the 2017 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.

2017-2018 Writing log - Projects.(screenshot).jpg

Customization

My approach to writing is based on barf and polish. Thus my writing phases labels are:

Writing phases flow diagram (vertical).jpg

You can change the labels you apply to the status of a project.

2014-2015 Writing log - word count totals - change status labels.jpg

2018 Daily Log

Track daily word deltas for 2018.

Add one row per day per project. It will automatically be summed in the weekly and monthly delta pages.


2015-2016 Writing log - 2016 Daily Log.(screenshot).jpg

2018 Weekly Delta

Weekly summaries for 2018.

2015-2016 Writing log - 2016 Weekly Delta.(screenshot).jpg

2018 Monthly Delta

Monthly summaries for 2018.

2015-2016 Writing log - 2016 Monthly Delta.(screenshot).jpg

Example Daily Log

Example daily word deltas for 2014.

2014-2015 Writing log - 2014 Daily Log.(screenshot).jpg

Example Weekly Delta

Example weekly summaries for 2014.

2014-2015 Writing log - 2014 Weekly Delta.(screenshot).jpg

Example Monthly Delta

Example monthly summaries from 2014.

2014-2015 Writing log - 2014 Monthly Delta.(screenshot).jpg

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.





2017-2018 Writing log - Projects.(screenshot).jpg
v  d  


2017 Writing log spreadsheet

float= The Red Rook (cover).png

Parallel Visions: City of Angels City of Demons ebook and trade paperback available on Amazon (or here).
The question of whether Vance was dead or not became more than academic when he found himself in a bathtub up to his chin in ice water like some forgotten cocktail garnish, a demonic woman standing over him, and no memory of how he got there.
Read free chapters of Parallel Visions: City of Angels City of Demons here
The Red Rook, sequel to Dispensing Justice and the second novel of Nova Genesis World is now available for Kindle or as a paperback at Amazon.
Read free chapters of Dispensing Justice here (or get it here).
Read free chapters of The Red Rook here (or get it here). -- Fritz Freiheit

Dispensing Justice (cover).png 20th Annual Writer's Digest Self-Published Book Awards - Honorable Mention.png
Welcome to 2020! Let's get some writing done.
Track your writing progress in 2020 using this free spreadsheet.
Article icon.svg
 v  d   
Picture
2017 Writing log spreadsheet



Happy New Year!

It has become a tradition for me to release a writing log 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.



Download the spreadsheet here: 2016-2017_Writing_log.ods ( or 2017_Writing_log.ods for a version that excludes the 2016 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.

2016-2017 Writing log - Projects.(screenshot).jpg

Customization

My approach to writing is based on barf and polish. Thus my writing phases labels are:

Writing phases flow diagram (vertical).jpg

You can change the labels you apply to the status of a project.

2014-2015 Writing log - word count totals - change status labels.jpg

2017 Daily Log

Track daily word deltas for 2017.

Add one row per day per project. It will automatically be summed in the weekly and monthly delta pages.


2015-2016 Writing log - 2016 Daily Log.(screenshot).jpg

2017 Weekly Delta

Weekly summaries for 2017.

2015-2016 Writing log - 2016 Weekly Delta.(screenshot).jpg

2017 Monthly Delta

Monthly summaries for 2017.

2015-2016 Writing log - 2016 Monthly Delta.(screenshot).jpg

Example Daily Log

Example daily word deltas for 2014.

2014-2015 Writing log - 2014 Daily Log.(screenshot).jpg

Example Weekly Delta

Example weekly summaries for 2014.

2014-2015 Writing log - 2014 Weekly Delta.(screenshot).jpg

Example Monthly Delta

Example monthly summaries from 2014.

2014-2015 Writing log - 2014 Monthly Delta.(screenshot).jpg

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.



Getting Writing Done (category)

ANwL (category)


2016-2017 Writing log - Projects.(screenshot).jpg
v  d  


2016 Writing log free download

float= The Red Rook (cover).png

Parallel Visions: City of Angels City of Demons ebook and trade paperback available on Amazon (or here).
The question of whether Vance was dead or not became more than academic when he found himself in a bathtub up to his chin in ice water like some forgotten cocktail garnish, a demonic woman standing over him, and no memory of how he got there.
Read free chapters of Parallel Visions: City of Angels City of Demons here
The Red Rook, sequel to Dispensing Justice and the second novel of Nova Genesis World is now available for Kindle or as a paperback at Amazon.
Read free chapters of Dispensing Justice here (or get it here).
Read free chapters of The Red Rook here (or get it here). -- Fritz Freiheit

Dispensing Justice (cover).png 20th Annual Writer's Digest Self-Published Book Awards - Honorable Mention.png
Welcome to 2020! Let's get some writing done.
Track your writing progress in 2020 using this free spreadsheet.
Article icon.svg
 v  d   
Picture
2015-2016 Writing log - Projects page



On the verge of 2016, I would like to wish everyone a Happy New Year!

For those of you who are writers, may your words be bountiful. I've put together a spreadsheet to track your writing productivity on a day by day basis.

Happy New Year!


The most recent master writing log is 2020 Writing log spreadsheet




Download the spreadsheet here: 2015-2016 Writing log.ods ( or 2016 Writing log.ods for a version that excludes the 2015 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.

2015-2016 Writing log - Projects.(screenshot).jpg

Customization

My approach to writing is based on barf and polish. Thus my writing phases labels are:

Writing phases flow diagram (vertical).jpg

You can change the labels you apply to the status of a project.

2014-2015 Writing log - word count totals - change status labels.jpg

2016 Daily Log

Track daily word deltas for 2016.

Add one row per day per project. It will automatically be summed in the weekly and monthly delta pages.


2015-2016 Writing log - 2016 Daily Log.(screenshot).jpg

2016 Weekly Delta

Weekly summaries for 2016.

2015-2016 Writing log - 2016 Weekly Delta.(screenshot).jpg

2016 Monthly Delta

Monthly summaries for 2016.

2015-2016 Writing log - 2016 Monthly Delta.(screenshot).jpg

Example Daily Log

Example daily word deltas for 2014.

2014-2015 Writing log - 2014 Daily Log.(screenshot).jpg

Example Weekly Delta

Example weekly summaries for 2014.

2014-2015 Writing log - 2014 Weekly Delta.(screenshot).jpg

Example Monthly Delta

Example monthly summaries from 2014.

2014-2015 Writing log - 2014 Monthly Delta.(screenshot).jpg

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.



Getting Writing Done (category)

ANwL (category)


2015-2016 Writing log - Projects.(screenshot).jpg
v  d  


2015 Writing log free download

float= The Red Rook (cover).png

Parallel Visions: City of Angels City of Demons ebook and trade paperback available on Amazon (or here).
The question of whether Vance was dead or not became more than academic when he found himself in a bathtub up to his chin in ice water like some forgotten cocktail garnish, a demonic woman standing over him, and no memory of how he got there.
Read free chapters of Parallel Visions: City of Angels City of Demons here
The Red Rook, sequel to Dispensing Justice and the second novel of Nova Genesis World is now available for Kindle or as a paperback at Amazon.
Read free chapters of Dispensing Justice here (or get it here).
Read free chapters of The Red Rook here (or get it here). -- Fritz Freiheit

Dispensing Justice (cover).png 20th Annual Writer's Digest Self-Published Book Awards - Honorable Mention.png
Welcome to 2020! Let's get some writing done.
Track your writing progress in 2020 using this free spreadsheet.
Article icon.svg
 v  d   
Picture
2014-2015 Writing log - Projects page

Welcome to 2015, and for those of you who are writers, may your words be bountiful. For those so inclined, I've put together a spreadsheet to track your writing productivity on a day by day basis.

Happy New Year! Now go get some writing done.


The most recent master writing log is 2020 Writing log spreadsheet




Download the spreadsheet here: 2014-2015 Writing log.ods ( or 2015 Writing log.ods for a version that excludes the 2014 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.

2014-2015 Writing log - Projects.(screenshot).jpg

Customization

My approach to writing is based on barf and polish. Thus my writing phases labels are:

Writing phases flow diagram (vertical).jpg

You can change the labels you apply to the status of a project.

2014-2015 Writing log - word count totals - change status labels.jpg

2015 Daily Log

Track daily word deltas for 2015.

Add one row per day per project. It will automatically be summed in the weekly and monthly delta pages.


2014-2015 Writing log - 2015 Daily Log.(screenshot).jpg

2015 Weekly Delta

Weekly summaries for 2015.

2014-2015 Writing log - 2015 Weekly Delta.(screenshot).jpg

2015 Monthly Delta

Monthly summaries for 2015.

2014-2015 Writing log - 2015 Monthly Delta.(screenshot).jpg

2014 Daily Log

Example daily word deltas for 2014.

2014-2015 Writing log - 2014 Daily Log.(screenshot).jpg

2014 Weekly Delta

Example weekly summaries for 2014.

2014-2015 Writing log - 2014 Weekly Delta.(screenshot).jpg

2014 Monthly Delta

Example monthly summaries from 2014.

2014-2015 Writing log - 2014 Monthly Delta.(screenshot).jpg

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.



Getting Writing Done (category)

ANwL (category)


2014-2015 Writing log - Projects.(screenshot).jpg
v  d