web analytics

let me spreadsheet that for you

I’ve made lists and spreadsheets long before I was a librarian so when I desired to take my writing one step further and begin to submit my pieces, I needed a way to track everything without losing my mind. I’ve searched for such a thing but most of the tools were lacking. Then I came across Jamie Rubin‘s spreadsheet and later the one from The Sleeper Hit and the great spreadsheet of doom was born.1

I keeping a few of my examples to give you a better idea of how it works, starting from the left tab and over:

  • Upcoming deadlines Pretty self-explanatory. It has the name of the publication, theme/idea, due date, cost (if any), payment (flat rate or per word), and link to the submission information.
  • Stories I only count finished but you could break it up to include working as well. Title, abbreviation, word count. It should be noted some places have limits on word count hence this column. DO NOT MODIFY THE COLUMNS IN GREEN. This will become important later on.
  • Submissions Some of the cells will have drop-down options for each cell not green. Date (date you submitted);  market (which populates from the market tab); status (which populates from the configuration lists tab); leave the next three green columns alone; last date (when the piece was accepted); leave the next green column alone; and lastly, contact and notes.
  • Places to pitch The basic agreement is to collate listings of your favorite websites where you want to write and include the idea/theme of that site as well as the contact information. 75% of this list was compiled by The Sleeper Hit and I’ve been adding as I go.
  • Markets Market is similar to places to pitch with the difference by adding type of payment (populates from the configuration lists tab), the next six green columns pulling from the submissions tab, and the last green column pulling from the publications tab.
  • Publications A list of all places you’ve published coupled with how much you made for said sale. Story column will have a drop down generated by the abbreviation of your stories tab, markets pulling from markets tab; type pulling from configuration lists tab; fill in payment with how much you got paid (which will then populate the total payments column on the markets and payment summary tabs); payment date (date you received payment), and payment type (populated from the configurations lists tab); link to the piece and finally, year (which will be used in the submission and payment summaries tabs).
  • Submission summary for those who like charts.
  • Payment summary for those who like charts.
  • Configuration lists which are populated through the workbook. You can add cells (starting below the last filled cell) as necessary but do not delete the columns.
  • Instructions are for the Jamie Rubin parts of the workbook with links to their blog piece describing the process.

Some notes:

Yes, this seems overly complicated and could probably be simplified in bits but I found its current status to work well. Markets and publications and places are used interchangeably. (I should probably fix that some day for consistency.) As I’m a very visual person, having the visual gives me a better idea of how much work I’ve done in writing and submitting. At least one more tab I’m going to add is one for novel writing for daily word counts. (I don’t count blog pieces, journal entries, or anything of the sort since those have no value other  privately for me.)

There you have it!

1. The spreadsheet can be modified to fit a variety of projects, not just writing.