When I Use Spreadsheets

SpreadsheetLast week I talked about my DIY white board for managing my writing projects.  I mentioned then that keeping a spreadsheet of my projects didn’t work for me.  However, keeping spreadsheets for other things does work for me.

For various reasons, I use Google Drive to do my spreadsheets.  These sheets are for more than just writing.  I have one for exercising (tracking when, what, & calories burned).  But, most are for writing like the one I use to track when, on what, and how many words I wrote.

Of all my spreadsheets, the one I’m proudest of is my Chapter Book Agent spreadsheet.  I put a lot of work into that sucker!  Finding chapter book agents is a nightmare and a ton of work (compared to adult fantasy), so when I did find them, I wanted that information easily accessible to me (for the chapter book I’m shopping around now and future ones).

Now, your mileage may vary, but you might find how I organized my information useful. (If you’re in the market for an agent that is.)  So here’s my set up:
Column 1 – Agent’s Name
Column 2 – Literary Agency Name
Column 3 – Link to Query/Submission Guidelines
Column 4 – Date Sent
Column 5 – Expect Reply By (if they don’t have reply time listed I do 6 months)
Column 6 – Follow Up Date (if they encourage follow ups at a certain time)
Column 7 – Which Query I Used (I have more than one)
Column 8 – Notes (Like “no reply means no” or “form to submit” and wait times)
Column 9 – Replies (when received or waiting time for “no reply means no” is over)

What do you use spreadsheets for?
Is there something you created for your writing (that’s not writing) that you’re proud of?

Categories: Experience | Tags: , , , , , | Leave a comment

How Did I Do Round 1? (#ROW80)

ROW80This round had me figuring out the difference between technically can do and really can do.  I think my new patterns are ironing themselves out and that will mean a smoother Rounder 2.  Not that Round 1 was terrible… or bad.  There were bumps, but generally it was good to me.

Outline and Write ALCHEMY - DONE!
I wanted the outline done by 1/20. I wanted to then take a break and start draft 1 on 2/13.  And I wanted to finish the 80k draft by 3/31.
Reality had me finishing the outline on 1/9 (ahead of schedule).  I continued to be ahead of schedule and started writing 2/4.  My draft fell short and came to 57k on 3/20.

New Floor

New Bathroom Floor!!!

These edits would happen 1/21 to 2/12.
Because of the outline that got done early, I started this 1/11 and finished 2/2.

Read More - DONE!
During the round, I scheduled myself to read: I SHALL WEAR MIDNIGHT, THE SECRET DIARY OF LIZZIE BENNET, and KNIT ONE, KILL TWO.
I did indeed read all of those.  Additionally, I read and finished GAMER GIRL and my friend’s manuscript.  I started, but have yet to finish CHARMED: LUCK BE A LADY TONIGHT.

Fitting in extra stuff where I can.
My side reading (things I sneak in when I can) consisted of the e-book MURDER BY THE SEASIDE, Marvel PRIDE AND PREJUDICE, ANIMAL FARM, and YUREI ATTACK!  The only one I finished was the Marvel PRIDE AND PREJUDICE.  I have just been reading the others very slowly.

My desk area after I reorganized it.

My desk area after I reorganized it. (Twice.)

Be a Good ROWer – O.K.
Every check-in comment on 2+ ROWer blogs that I don’t follow and as many as I can of those that I do follow.
I’d say a C+, if I have a generous teacher B-.  I did well until this month.

Be Healthy – Very Good!
Exercise: Monday and Wednesday- Yoga + 1 Mile | Thursday- 3 Miles | Friday and Saturday- Light Workout
Next Round, I think I’ll be less specific about what on which day.  I did a good job honoring the exercise days, but not always following it to the letter of the goal.

Stick to Eating Plan
I had a few rough spots.  Over all, I usually did well on this.  I think I earned a B- (generous teacher might even say B+).

Be Summer 2012 Weight by end of round
This goal might have been a hard one from the start.  To break it down, I had 10 pounds to lose.  Doesn’t sound like a lot, right?  But, that would make my total weight loss 25 pounds.  I’m in the slowing down, hitting bumps phase.  I lost 6 of those pounds and I’m at 21 pounds lost total.  So, I didn’t make my goal, but I made progress.


My little Duke of Evil.

Other Things I Did This Round
I installed a new bathroom floor.
I did crafts with my kids during their many snow days.
I reorganized my desk.
Took part in the cover reveal for TORN by Kate Sparkes (Out 3/31!)
Got a birthday hamster.

I have my writing/reading schedule figured through mid-May, which means I know what I want to do between rounds: I hope to put the final polish on GRANDMA and finish that CHARMED book.  I would try to do more, but the kids’ have spring break next week.  I’ll reveal the rest of the schedule/hopes and perhaps try out a new prioritizing method start of next round.

Did you forget you were running laundry?
(Yup, I did. Just randomly remembered now.)
So, how are you?

Categories: ROW80 | Tags: , , | 2 Comments

Blog at WordPress.com. The Adventure Journal Theme.


Get every new post delivered to your Inbox.

Join 440 other followers