Nova Genesis Logo.png
The Red Rook (cover).png
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.

In The Red Rook, Penny confronts her doubts about becoming a superhero as events around the disappearance of one her school mates unfolds.
Subscribe to the Liberty IV Newsletter here.
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
Are you an author with a wiki? Or know of an author who has one?
If so, I'd like to hear about it. Add a comment here, or contact me.

2015 Writing log free download

From FritzWiki
Jump to: navigation, search is best viewed with JavaScript turned on.
Article icon.svg
 v  d  e 
2014-2015 Writing log - Projects page

Update: 2016 Writing log free download available here.

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 2017 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[edit]

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


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[edit]

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[edit]

Weekly summaries for 2015.

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

2015 Monthly Delta[edit]

Monthly summaries for 2015.

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

2014 Daily Log[edit]

Example daily word deltas for 2014.

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

2014 Weekly Delta[edit]

Example weekly summaries for 2014.

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

2014 Monthly Delta[edit]

Example monthly summaries from 2014.

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

Links and Notes[edit]

A few links.


Configuration fields.


last_one2 VB Function[edit]

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)
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.



Recent Related Changes

Recent Topics with Comments

Recent Blog Topics

Back to the Blog


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


v  d  e