Category: Learning curve

Posts in which I discuss things I’ve learned or need to learn about any of many topics.

Revisiting the cumulative title sales spreadsheet

Lynn

I had a thought that maybe there was a way to make updating my cumulative title sales spreadsheet easy enough that it would be worth keeping it up to date so I revisited the spreadsheet today for about an hour or so.

As you can see in the image above, I have several sheets in the workbook. The thing is, I know just enough Excel to know how much I don’t know.

But I had a thought and I followed up on it and that thought led to another and suddenly I’d found a way to make the currency conversions for the KDP sheet easily and quickly—and in a way that would work for future additions to the KDP sheet without requiring any additional effort on my part.

You see, if you’ve seen the KDP reports from Amazon, you’ve probably noticed they don’t include the currency conversion for the payments the way the reports from everywhere else does. It’s an inconvenience, but it is what it is.

My challenge was to find a way to prorate each month’s payment to each month’s sales. The way I chose to do it a few days ago was inelegant and not wholly accurate for each book. That bugged me, but it was a time versus accuracy dilemma, and my need to save time and effort won out.

But now I’ve figured out how to do it with zero additional upkeep.

#1

I created a column for a conversion factor in my book sales report where I track royalties earned and royalties paid by month for each vendor.
Sample row data (extraneous columns deleted):

Oct 2016 Amazon.de EUR 36.87 38.43 1.0423108

The conversion factor is simply the payment amount, which I have a column for ÷ earnings in the original currency, which I also already have a column for.

#2

I multiplied the foreign currency royalties in the KDP sheet by the conversion factor and got the USD royalties for each item (which I’d consolidated from the monthly KDP reports). I did this for all the rows in the KDP sheet.

If I’d had to do it manually, it would have taken forever.

The trick with the formula was to use the SUMIFS function because my royalty payments spreadsheet has only one row for every date and marketplace combination. That means the sum is always going to return only the conversion factor that matches the date and marketplace that the formula needs to calculate the USD royalty. It was just good luck that since KDP reports don’t show transaction dates, I had set up all my rows in the KDP sheet to contain only the period end date, which is also how I’d set up my royalty payments sheet (Oct 2016 is actually 10/31/2016 but set to the MMMYYYY format).

#3

I created a table so I could use the VLOOKUP function to solve the problem of having different names for the marketplaces in the two sheets (Amazon Kindle US Store vs. Amazon.com) but that was actually the easy part. :)

Anyway, what this means is that my brain spent a lot of time working on this while I wasn’t actively working on it—even after I’d decided it was too much trouble to keep up. But that happens sometimes.

I’m happy to say the sheet works well with the new formulas, even if my formulas are a bit of a hack. Updating the cumulative title sales will be a simple process that shouldn’t take more than half an hour every few months, and it’ll have the actual payment amounts from KDP applied to the correct months’ foreign sales.

I’m glad I was able to come up with a solution, and I swear, it feels like it’s taken me longer to write this post than it took me to fix the spreadsheet.

I had considered the idea of one massive spreadsheet that I could put into a PivotTable, but I didn’t consider that a good long term solution. The data between reports just isn’t standardized enough and I sure didn’t want to spend a bunch of time standardizing it each time I decided to update the cumulative title sales report. And I’m pretty happy with the solution I’ve come up with, because it means I can just copy and paste the new data into the appropriate sheets and I’ll be good to go.

Smashwords might be tricky, but my current plan is to just delete and re-add all the data from the updated reports, instead of append it. This is necessary because Smashwords throws in new transactions for some very old periods sometimes and trying to pick those transactions out of the whole would be a waste of time.

I don’t figure I’ll update this spreadsheet more than once a quarter anyway, but I’m tickled that it’ll be maintainable without a lot of effort. :D

Now, off to do some other stuff before I call it a night. It’s 12:03 a.m. and I swore I wasn’t going to bed late again! :o

Another day to add to my streaks!

Lynn

The streaks continue. :)

148 – 12/30
172 – 12/31
203 – 1/1
209 – 1/2
246 – 1/3

  1. >100 words a day, and
  2. increasing words per day

I’m up to almost a page a day now. :)

I’ve been writing so few words because (1) kids are still home for the holiday/winter break and (2) I spent the last two days working on a massive spreadsheet project I’d been putting off for a couple of years now.

I thought having all my title sales in one Excel workbook would benefit me, but after getting it done, I’m just not sure I didn’t waste a lot of time on this. As someone who will write a book I want to write regardless of the possible payoff, I don’t have any need to see my sales broken down by title or series (which is what I did).

Not only that, but there weren’t any surprises there either. I’ve apparently been doing just fine consolidating in my head the information I gather from the individual sales reports from each vendor. I’d created a very realistic picture of where my money was coming from and the books were all doing just about what I thought they were as far as revenues go.

I don’t think I’ll update the spreadsheet going forward. I won’t delete it outright, but I see no need to keep it current.

I just don’t care how much each specific book brings in, and I don’t even really care how much each series is bringing in. I write these books because I really want to and I’m willing to take my chances with them.

Now, time to go write some words for today. I have to get to bed earlier tonight. I’ve stayed up two nights in a row until 2 a.m. working on that stupid spreadsheet. I need a better night’s sleep tonight so I’ll feel liking writing lots of words tomorrow if I decide that’s what I want to do. :D

I have two writing streaks going!

Lynn

Addendum to the aside about my writing streak: I have two writing streaks going now.

  1. >100 words a day for three days
  2. increasing words per day for three days

So—awesome?! start to the new year. ;) (Stop laughing! *evil glare*)

Not only that, but I don’t feel feverish today, don’t feel sick, and don’t feel all that tired either. So good health too.

I think I’m losing weight but since I’ve abandoned my scale (it’s in the closet) I can’t say for sure.

I’m pretty happy with abandoning all these metrics of success and failure and the goal setting stuff. I feel free.

I need, now, to translate that into more writing and some real weight loss. 2017 seems like just the year for it. :D

Happy new year, everyone!

Coming up next: a new year’s update on the progress I’ve had building a pen name. Spoiler! I should’ve just written more books for my main name.

Aiming for more but giving up the need for speed

Lynn

I’m finding it difficult to write now that my kids are home for the holidays. :o I should have guessed that’d be a problem, and yet… I made no plans and thought I’d just be able to write on through. That’s typical of my thought processes, unfortunately.

However, today, finally, I’ve got some time to myself and I aim to make the most of it.

Today I will write more than 2,000 words.

Today I will format a paperback and ready it for uploading.

Today I will finish my online Christmas shopping. ;)

Today I will stop making excuses for not writing as much as I say I want to write.

Today I will stop second guessing my writing process and stop wishing I was a faster writer. My average pace will either speed up over time or it won’t. Four years of trying haven’t brought any real improvement in that—and in fact, some days I worry that all my focus on trying to speed up has actually slowed me down.

The speed of my writing isn’t what’s holding me back. Time spent writing is the real problem. But don’t worry, I’m not about to say a schedule is the answer. It’s not. I’ve been down that path and found nothing much there for me. I don’t believe time quotas are right for me either. (Same post.)

Mostly I’m just going to try to write as much as I can and stop even using the timers for a while. Sure I’ll end up struggling sometimes, but that’s what quotas are for. They tell you when you’re done. If my rolling 30 day average is close to 2,000 words, I can call it quits anytime I want. If it isn’t, then I need to write a little harder. :D

The challenge of quotas

Lynn

I was writing myself a rambling note in OneNote and I had this realization: Word count quotas don’t hurt the way time quotas do. One is a challenge, the other is work.

Anytime I make a schedule, I’m setting myself time quotas. I could try to look at it differently, but I’m pretty sure it wouldn’t matter. I have an inherent dislike of schedules and I’m tired of trying to force myself into that box.

So here’s the thing. I deleted all references to a writing schedule from my calendar. Time blocking, fixed schedule productivity, etc., they’re all just ways to tie my brain into knots. I get the most joy (and do the most work) when I’m pushing myself to write, but not when I’m pushing myself to write at a certain time of the day, for a certain length of time.

Word count quotas have a purpose in my world. They provide the kind of structure I work best in.

It does mean my life is a little messier. No set start and end times for my days. But you know what? I really like it better this way.

I’ve been struggling with this schedule again over the last few weeks and I’ve gained nothing from it, except stress I really don’t need at this time of year while I’m already stressed about a looming deadline (or two). If I keep to my goal of writing about 2000 words a day on average, I’ll get this book written and I’ll be able to make an educated guess about how many books I’ll be able to write every year, and I’ll reach my overriding goal to become a prolific writer.

:D

So here’s an early New Year’s Resolution for 2017: I’m done with schedules. It’s back to word count quotas for me.

I’m adding a 250 words a day minimum, and I don’t have to count deleted words in this. (So my actual daily word count log entry might be -1,112 words, but if I wrote 250, it’s good.) Every day, because I fall off and I take a nap before I get back up. ;)

After that, it doesn’t really matter where I end up for the day. My scale remains the same.

1,000 = low word count day
2,000 = average word count day
3,000 = moderate word count day
4,000 = high word count day
5,000 = record breaking word count day (always, because 5k is huge!)

I want more average to moderate days and fewer low word count days and every so often, I’d like to have some high and record breaking days just for fun.

Every day my goal will be to evaluate where I’m at, then do my best to reach or maintain a 2,000 word a day average, and if I can get a bit ahead… that would be fantastic, because I still dream of writing ALL the books. ;)

All right, I’ve finally had enough of that

Lynn

I very much dislike the way my categories and tags for this blog are set up.

I also dislike the extra sheet in my word count tracking spread sheet. I mean, I don’t really dislike it as much as I’m just tired of the extra record keeping. Why should I care about tracking my word count for a specific book? I don’t. I really don’t. I’ll still write the same books, even if they’re slow. I want to finish each book I write faster, to take advantage of momentum, but I’ve found over the last 2.5 months that keeping up with the exact numbers isn’t helping me finish my books faster. Not at all. The deadlines aren’t helping. Only getting to the computer and setting myself goals for how much time I spend writing is helping. And I’m not doing great with that, by any means, but it is helping.

What isn’t helping is ignoring these posts, reading Kboards and DWS’s blog and The Passive Voice and NPR and the trending news stories on my Kindle tablets’ silk browser. (God, I hate Silk and trending; it plays on every obsessive personality trait I have; I’m never buying another Kindle tablet. NEVER.)

And I’m self sabotaging again, dammit. I’m supposed to have started writing for 1.5 hours at 10:45 (and I was already behind on the 1.5 hours I was supposed to do from 9 to 10:30) and here it is 11:31. Okay, I’m done with this for now. Maybe I’ll revisit later, but I’m getting back to the damn book before I just start hating myself today.

Changing how I monitor my daily average word count

Lynn

I track my daily average word count in a number of ways, including yearly and monthly, and more recently, since 9/19. You see that last one in my word count posts. I’ve been adamant that I’m not going to change the start date for that count and I haven’t. Until today.

I decided today to change that column in my spreadsheet to hold a 30 day rolling average instead.

What I realized today is that there’s a problem with using a set start date for the average I’m using to monitor improvements to my daily word count. Over time the average becomes weighed down by the past and the present gets lost. If I have 90 days of numbers, the current 30 days are 1/3 of the average. If I have 180 days of numbers, the current 30 days are only 1/6 of the average. As the history of numbers grows larger, the average becomes less representative of the present and how I’m doing now.

A 30 day rolling average will be much more focused on current progress and will tell me if I’m doing well now and let me to see course corrections more clearly.

Update: This was a fail. I no longer even include this in my spreadsheet at all. :)

Second day of new plan and I’m failing to keep up

Lynn

As I said in the post where I discussed my new plan:

At this point, here’s what I need to finish by 11/30/2016, which is the date I’d like to finish: 3,150 words a day (average).

Yesterday, I didn’t keep up, writing only 1,846 words, so my goal number of words each day has now gone up to 3,237 (unless I can make up the entire 1,304 words I’m behind today).

The schedule I’m attempting to follow is:

8–9:30
10–11:30
12:30–2
2:30–4

Which is four 1.5 hour sessions. The goal is 1,000 words per session, or a very reasonable pace of 667 words per hour.

Yesterday, I got behind early and never caught up. In fact, I kept getting further and further behind, until I finished the second session at almost 8:30 last night.

Today isn’t looking much better.

It’s 1:42 pm and I’ve finished one session, which I finished at 11:55 am. I wrote 353 words in that 1.5 hours, which is a TERRIBLE pace. I don’t even know how I managed to do that badly.

Then I took a short 30 minute break (yeah, I know it’s almost two hours later!) and here’s where I am.

I’m about to start session 2, and I’m hoping I can pull myself out of this spiral of doom I seem to have fallen into.

Distractions? None. Or if they exist, they’re all in my head. I honestly, 100%, do not know where my time went this morning. All I can assume is that I started late (and didn’t really notice*), then had to take lots of breaks. I did notice that. Lots of bladder pangs this morning for some reason. TMI, I know. Don’t care. If you do, bail now. This is not the blog for you.

Anyway, I’m putting on headphones, cranking up some music, and going to get down to business with this writing thing. I cannot let today become another failure.

*Possible because I took a nap on the couch less than 10 minutes after I got up this morning. I can’t remember if I even noticed how long I was out.

Further update

I am absolutely and completely off the schedule at this point and it’s 11:14 PM and I’m still trying to write.

Here’s a cut and paste from my tracking spreadsheet.

Session Time in Hours Session Words WPH
1.5 353 235
1.5 409 273
0.75 307 409

Ugly, huh?

And here are the stats:

          285 avg wph
       2,168 words to go
7.6036015 hours to go
         6.00 hours planned
         3.75 hours completed
          963 wph needed

At my current pace, it would take me another 7.6 hours to finish today’s word count. Uh huh.

I could get it done in 2 hours and 15 minutes if I could maintain a 963 wph pace.

But did I mention it was 11:20 PM? (It takes time to write these posts.) I’m tired, so none of that will be happening. On the other hand, I did accomplish something this afternoon and evening.

  1. I discovered that although the pace of this book felt ridiculously slow, it was just feeling that way because of how long it was taking me to write stuff into a scene I already had mostly written. (Those 1000-ish words I wrote today.) When I read back through to see if the story’s pace was as bad as I thought, I discovered that it moved along just fine. So—lesson learned. Pacing is not something I can feel as I write. Don’t delete a bunch of stuff because it’s giving me trouble. Read back through the last few chapters first. (That definitely stole some writing time.)
  2. I had to update my timeline for this series and that meant skim reading a lot of pages from the last book looking for clues about dates and the passage of time. Unfortunately for me, some of these danged books overlap, i.e. the stories happen concurrently*, and I had to create a spreadsheet several books back to keep it straight. I’m trying to write my way out of this situation with this book. Future books will not happen concurrently if I can help it!  (That also definitely stole a lot of writing time.)

*Never set up a series that contains stories that happen concurrently unless you’re a glutton for punishment. It’s a nightmare to keep straight!

Now, I’m off to see if I can get more writing done before I crash. The next update will be nothing more than my word count post for the day.

Consider this a cliffhanger. ;)

 

Disheartened by a bad book

Lynn

I can’t make people like my books. I can’t really change what and how I write, or if I could, I wouldn’t want to, because then I just wouldn’t want to write. I don’t always enjoy the process of writing, and it’s the story, written the way I want it written, that carries me through when I’m feeling that way.

Writing is hard for me.

Sure, sure. There are people who’ll say that’s dumb, that writing isn’t hard, but those people? They don’t know how it feels to be me. I love making up stories, but writing them down, in some kind of coherent way, is really damn hard work. There are lots of days when I’d rather clean bathtubs all day than try to make sense of the stuff in my head and put it down in readable form.

I do the best I can with everything I write, and I do try to improve. And I recognize that not everyone is going to like what I write—especially because I write primarily for me.

All that doesn’t change the fact that it’s still disheartening when I realize I’m not writing things other people enjoy in the same way I do.

I’m pretty sure my last book didn’t hit the mark with a great many people. I had that realization after I accidentally saw a review I really didn’t need to see and went looking for evidence to support it one way or another—and it was an accident, because I never would have gone looking for it but one retailer in particular emails me reviews and I can’t stop them from doing it.

Probably not my best idea today.

What I found was that this latest book is my lowest rated book on Goodreads, by nearly a star. The thing I liked most about the book is the thing really not loved by most other readers. People do not seem to be liking this book. I’ve had a few 5 star ratings, but no reviews to go along with them, while the reviews I do have are all pretty negative.

Right now, I’m feeling like I’m just not that great a writer. My books have flaws, some of those flaws pretty major, but other than continuing on as I am, I’m not sure there’s anything I can do about it.

I’m doing the best I can. I just have to keep going, write what I write, and hope people continue to buy my books despite those flaws.

Book cover mockup: Made with GIMP

Lynn

So, since I’m still anti-reveal about my pen names (and if you figure them out, don’t tell me!), I just wanted to post something that shows a little of what a DIY author can create with GIMP, which is an open source alternative to using Adobe Photoshop, and free to use.

I also wanted to show off a bit of the stuff I’ve learned, since I talk a lot about studying cover design.

For my mockup, I didn’t worry about much other than mood, and I did this very quickly.

Misty Mockup

Here are the stock photos I used (all properly licensed from Dreamstime). :)

Misty Composite

I still don’t have an eye for design. But I have learned a lot and do think I can make a decent cover these days. Which is a good thing, because I decided a while back that I can’t do the hiring out thing. I wasn’t satisfied with either experience (not the quality of the covers—the experience).

I am not an expert designer, by any means, and no one is going to mistake that looking at this cover, but I really just wanted to show that you don’t have to use Photoshop to make decent DIY book covers if you’re a self-publisher. And if you practice your skills, you can make covers that are more than good enough to put on your books.

Also, who knows, but maybe I’ll start another new pen name someday soon and use this cover! :D

Schedule update: times are almost right, sessions keep changing

Lynn

Since I started following a writing schedule again, I’ve found that some adjustments have had to be made. A few things just weren’t working out how I’d like.

I added an extra half hour for the midday break. I also stopped an hour earlier for lunch and moved that hour to after lunch.

Scheduled times

7 to 12 became 7 to 11, while 1 to 4 became 12:30 to 4:30.

I’ve only tried this for one day, and not successfully, let me add, but possibly because it’s fall break for the schools here and I keep messing up my 7 am start time. Still, the lunch hour wasn’t working. I’ve had to adjust it every day, so building that into the schedule makes more sense than not.

Session times

First it was 50 minute sessions, then 15 minutes, then 25 minutes. They each worked at different times this week, but I’m moving permanently back to 50 minute sessions for planning writing output because of how well they work within the framework I’ve constructed. It’s very easy to account for how many sessions I should have completed in any number of hour long blocks if I assume 50 minutes writing time to 10 minutes break time.

One change I’ve made is that I’m not longer stressing over whether or not I can complete the entire 50 minutes without a break. (Too much tea, I know. I can’t help it. I feel compelled to have something to drink while I write.) I just plan to write for 50 minutes, pause the timer when necessary, and aim to complete the 50 minute session within the one hour block. Now this? This is something that’s actually had a much bigger impact on how I feel about these long sessions than I would have thought. The new perspective is working great. No more resentment for long sessions, or hesitation to start one, because it’s perfectly okay to pause the session. In fact, I expect it. There’s also a bit of pressure to get back to it quickly that’s helpful (because the timer is paused). It’s working out much better than the break between sessions. That’s where I’m still having a lot of trouble with distractions. :)

Session goals

One thing I realized right away was that I wasn’t just pushing for higher word counts per hour with the sessions. I was also demotivating myself a bit. Not much, just enough that I really started to notice it yesterday. The problem is that I use my number of sessions times my word count goal to estimate what goal I should have for a day’s writing. The numbers made me feel too optimistic about the chances I’d have of reaching really (really) high word counts, despite what I know of my historical performance.

So I scaled back. I might want to write 250 per 15 minute session, or 325 per 25 minutes, or 600 or 800 per 50 minute session, but that’s just not that likely, and it’s no way to plan. I can still hold all those numbers in my head as goals, but they’re really no good for planning.

I’ve settled on a 550 word goal for each 50 minute session for planning purposes. That’s 660 words per hour. My average the last time I checked was about 641 wph, and my all time average was about 541 wph, so it’s a bit of a push, but not an overwhelming one.

I know how many words I need to finish several of the books I’ve got going, I just needed estimates of sessions and words to get me to a daily plan to make it happen by the deadlines I’ve set myself (publicly this time). The book lengths are estimates, of course, but I don’t mind adjusting how much writing I need to do each day if I see that a book is going longer than I planned. It happens more often than not, to be honest, and that’s another reason overly optimistic word count expectations are a problem for me.

My former session goals led me to create deadlines that were just too tight. I gave myself some much needed breathing room. :)

Word count post for Oct. 3, 2016

Lynn

1,470 words.

Not as many words as I hoped. (See below.)

Daily average since 9/19: 522 words.

At least it’s still rising, right?

===Notes===

One thing I’ve decided today is that I have to get serious about starting on time in the mornings.

Starting late seems to have a major effect on how well I’m able to stick to the schedule the rest of the day. It also sets me up for a slow start and a low word count.

That’s not what I want.

Today was an excellent example of what starting late does to my day.

What I was aiming for

625 by 8 am
1250 by 9 am
1875 by 10 am
2500 by 11 am
3125 by 1 pm
3750 by 2 pm
4375 by 3 pm
5000 by 4 pm

What actually happened

Session Time in Hours Session Words WPH
0.8333 496 595
0.8333 391 469
0.8333 409 491
0.45 174 387

There’s really only one way to solve this, and that’s to get to bed on time, then get to writing before I let any distractions get in the way.

Of course, my word counts weren’t up to speed either, but that’s likely something I’ll have to address after I get settled into a better routine.

New goal: more average and moderate word count days, fewer low word count days

Lynn

I have to stop reevaluating my daily word count goal.

It’s kind of stupid really, all this number crunching I do. I’ve approached it in so many different ways that it doesn’t even make sense to keep redoing the calculations. I already know about where the numbers are going to end up.

I guess I keep hoping I’ll discover I’ve done something wrong and I’ll be able to write 500 words a day and make a killing and finish all the books I want finish in as little as a few months or a year at the most. :D Totally unrealistic, honestly, but I keep trying anyway.

I need to write…

  • 2,085 words a day to earn my ideal income.
  • 2,192 words a day to write 4 books in 4 series each year (16 novels of about 50,000 words each).
  • 1,644 words a day to write a book a month (12 novels of about 50,000 words each).
  • 2,466 words a day to write a book a month for one pen name and a book every other month for a second pen name (18 novels of about 50,000 words each).
  • 2,164 words a day if I write for 4 hours a day at my average 541 words an hour pace.
  • 1,623 words a day if I write for 3 hours a day at my average pace.

See where I’m going with this?

I have to stop reevaluating these numbers! It isn’t helping me in any way that I can see. None. It’s nothing more than a way to pass the time and distract myself from what I really need to be doing: writing.

I need to just write as much as I can each day, but that attitude never seems to work out for me. I need a bit of structure, but not too much. I don’t want another schedule, and I hate the arbitrariness of picking one of these numbers as a daily quota. How do I decide? (I’m remarkably indecisive. Impulsive too, but that’s another post.)

After a bit of thought, I’ve come up with a possible solution.

I’ve created a scale to help me keep things in perspective. :)

1,000 = low word count day
2,000 = average word count day
3,000 = moderate word count day
4,000 = high word count day
5,000 = record breaking word count day (always, because 5k is such a push for me)

My goal is to have more average and moderate word count days, sprinkled with high and record breaking days, and as few low word count days as possible.

I can track this by monitoring how I’m doing keeping my average daily word count at or above 2,000 words a day.

Easy, right?

Okay, maybe not so much easy as simple. :D

The concept makes sense, anyway. :)

That means today’s goal is to reach 2,000 words, and this week’s goal is to keep it there. And the month’s goal is the same, and so is the year’s goal. Like I said, simple.

Wish me luck.

Exporting OneNote sections to Word

Lynn

Here’s something I discovered about exporting from OneNote today: To export both pages and subpages of a section from OneNote to Word, expand the pages first.

I did some reorganizing of my Journals which are set up as Section > 2016, Page > September 2016, Subpages > September 16, 2016 & September 15, 2016, etc, and had them collapsed so the sidebar wasn’t too long (365 pages is a lot of pages for one section and I wanted some white space in that list!).

What happened, though, when I did my usual export to Word to back up my entries by section (year) is that most of the subpages didn’t export. Only those that were expanded were included in the Word docx file. :o

That wasn’t good, so I went back and expanded everything, then exported again, and it worked exactly as I expected.

I tried to find mention of this online, but I couldn’t find anything. So here it is, a tip for anyone who might be wondering why OneNote doesn’t export subpages to Word when exporting. See if your pages are collapsed and if they are, expand them before you try to export again.

I’d rather it not be this way, but as long as I have a workaround I’m satisfied.

Sometimes I still miss Evernote, but one of my favorite things about OneNote is how easily I can export pages, sections, or notebooks directly from OneNote to Word. I couldn’t do that in Evernote, and exporting to HTML wasn’t really what I wanted. I do it to back up important notes in a format I can access easily if my OneNote files were to become corrupt.

I’m not where I wanted to be

Lynn

It’s been four years since I started self-publishing. I published my first story in July 2012 and I’ve never looked back. I quit my job in September of that year, lived on savings, and wrote as much as I could. I had a ridiculous amount of faith that it was going to work out, even when it really didn’t look like it was going to work out.

But it has, and I’m making a living on the money I earn from my fiction.

But now I feel stuck.

It’s been four years and I’m not where I wanted to be at this point, with either income or output. I know what to blame: My inconsistency. I don’t meet my word count goals. I can’t stick to a regular production schedule. I don’t have a regular publishing schedule.

The only thing I’ve done with any consistency is spend weeks and months struggling to keep myself writing when the doldrums hit. My latest zero word day streak ended today after 35 days.

I’ve had 145 zero word days this year. That’s already more than in any other year, and this year has 4 months to go.

I’ve got a problem, and I’m not sure how to fix it.

On the other hand, my output over the last four years is eerily consistent considering how irregular my writing schedule is.

2012: 146,821 (tracks to 291k for the year)
2013: 268,191
2014: 217,641
2015: 250,011
2016: 137,080 (tracks to 205k for the year)

Of course, if I continue to fail to write, this year could be the first year I dip below 200k for the year. I really can’t let that happen. I already feel disconnected from my writing, and I don’t like that feeling. I’m just not sure what’s going on.

I want to change this, to improve my output numbers, but at this point, I’m just not sure what it’s going to take, or if I’m capable of it. As you can imagine, this is a very frustrating time for me. I’m at a low point, and I’m very much feeling like I just don’t have that something special that drives people to exceed their limits and achieve great things.

Conclusion: daily word count is more important than time spent writing

Lynn

After many experiments detailed here on this blog over the years, and much reading of articles about processes and systems versus goals and quotas, I’ve decided that forevermore I will consider working daily toward a word count goal more important than how much time I spend writing.

Here’s why.

No matter how I look at it, it’s all metrics. A system that says I need to write for a certain length of time (daily or weekly) is no different to me than having a goal to write 2,192 words a day or 15,344 words a week or 66,667 words a month or 800,000 words a year.

A daily word count goal and a daily time goal are exactly the same in all the ways that matter to me and they require exactly the same amount of mental energy from me.

Finally, I’ve concluded after a great many experiments detailed here on this blog, that I prefer to work to word count goals, not time goals, because, one, I have difficulties perceiving the passage of time, and two, I like numbers that reflect progress in a form I can visualize. What does it mean that I’ve spent three hours working on my book? I can’t see my book’s progress in time invested, but I can certainly see it in words written. YMMV.

Recognizing perfectionism

Lynn

I had a realization yesterday morning and it’s led me to some serious soul-searching. My 12-month 1,180,000 word challenge is quite possibly—probably, in fact—a manifestation of perfectionism.

I’ve been upfront with the fact that I suffer from repeated bouts of perfectionism, and I don’t always realize when I’ve let it creep back into my life.

But yesterday, I started to realize that the only reason this plan even exists is because I spend a lot of time imagining the awesome way I’ll feel if I write all those books right now, if I can find the perfect system so I can write a perfect number of words every day, all so I can design a perfect release schedule for the many series I have going.

I do not need to write that many books in 12 months.

Not only that, but this goal is so far from realistic for me that I’m not sure it’s even part of my universe.

To reach this goal, I’ll have to write 5 times my current average daily word count. FIVE TIMES.

Every single day.

But perfectionism keeps me re-figuring my calculations at every turn, trying to find a way to do the impossible, because it fits some ideal I’ve come to worship. As if I’m just not doing enough, as if I’m a loser if I can’t write all the books in all the series, and write them damn quick, too. Because I should be able to do it, because it’s so reasonable if I just consider the numbers.

Bullshit.

This all started because I do want to write a lot of books in the series I have going, and the unfortunate truth is that at my current speeds it’ll take me 3.5 years to write them. But I also want to write other things, and I definitely don’t want to wait 3.5 years to start writing those things.

But realism never has been one of my strengths, and neither has delaying gratification.

That was the crack that let perfectionism sneak in. What if I could write this many words? What if I could follow this schedule? What if I could double, triple, no, quadruple my word counts? What if, what if, what if.

I’ve set myself up for failure, trying to reach for some ideal. And I’m failing under the pressure. I’m losing my enjoyment of writing.

I’m going to fix this, now that I’ve recognized what’s going on

I’ve stopped the schedule experiment.

I’m ending the push for 1,180,000 words in 12 months. I studied the list of books I want to write and decided I need to focus on only a few series instead of trying to do everything.

It’s impossible. I can’t do everything, not in the time frame I want.

I love all the series I write, I really do, so I picked based on reader interest and money. I settled on 3 series, plus the pen name series. I picked the pen name series not because of reader interest and money but because of potential for those things. Also, if I give up that series, the pen name is dead, and I don’t want that. Not yet. I want to finish that experiment.

That’s not to say I’m not still setting the bar high. I want to release a book every month for my main name, and a book every 3 months for my pen name. For me, that comes to 2,192 words a day.

To be clear, at least to myself, it’s not a daily quota. It’s a goal.

2,000 one day and 2,400 the next will work fine. :)

It’s possible I’m fooling myself, still. 2,192 is still almost 3.5 times my current average daily word count. I’ll have to take that chance. I need to step up to another level in my earnings, and I can’t do that being satisfied with the number of words I’m currently writing each day.

I debated this goal, wondering why this feels necessary, wondering if I was just replacing one unrealistic goal with another, less obviously unrealistic goal, but decided in the end that I have good and valid reasons for not eschewing goals altogether. I can’t expect to get off the income plateau I’m on if I just keep releasing books at my current pace. Growth and improvement are important and having a big goal doesn’t have to mean I’m succumbing to perfectionism. This plan is a stretch, no doubt, but it isn’t grandiose in the same way as my plan to write 1,180,000 words a year.

One reason for that is because I’ll only be focusing on 4 series going forward. The consequences for failure are mild compared to the consequences I’m already facing because I haven’t been able to reach this other, huge, goal.

Even if I only increase my pace to 1,000 words a day, I’ll still be putting out 2 books a year in each series. That’s considerably better than the current schedule for one of those series, which hasn’t seen a new release in 18 months. And let’s not forget that it took me 11 months to put out the second book in the pen name series. I’ve spent too much time writing other stuff, in no particular order, just trying to stay on top of all the series. I can’t keep up.

So going forward, I’ll be writing a book for each series, in the same order every time, and I’ll stick to one book until it’s done before I move to the next.

Could be this is a mistake. But if I reach my 2,192 words for a day, I can write on anything I want, including those series I didn’t choose to make part of my plan. It’s a reward for staying on track.

And if I do stay on track long-term, I’m considering throwing in one of those side projects every three or four cycles through the main series. I’ll consider that a reward to strive for, too.

In the end, it was important for me to recognize that I’d let perfectionism into my planning. I don’t think it’s done my career any favors and it had to go if I want to move forward. It feels weird to give up on this challenge, but sometimes you have to give up on the things that aren’t working to make real progress.

Today starts a two week experiment with a new schedule

Lynn

Here’s the writing schedule I’m going to follow for the next two weeks.

9:00-10:30
1:00-2:30
7:30-9:00

Why have I changed my schedule yet again?

The other schedule wasn’t working for me. At all. I didn’t write one single time during my scheduled writing time. Right now, in particular, I’m having trouble with getting started, and the large blocks of time weren’t helping that. Even two hours felt like too much of a commitment when there wasn’t a lot of time empty between the sessions.

So I created this new schedule with one thing in mind: making sure I don’t feel like I have a job.

That’s important. I don’t ever want writing to feel like a job.

  • I split the time blocks up so that I have huge breaks between writing sessions.
  • I made the sessions as short as I could while making them long enough that I can still get into flow during them.
  • I gave myself 3 of them so my total writing time each day fits into my long-term goals. 3 × 1.5 = 4.5 hours.
  • I started the first one later in the morning so I can sleep late if I have a bad night of sleep.
  • I’m not going to move the scheduled times if something comes up to preempt the time. I’ll just assume that I’ll miss one or two of these a month and live with that knowledge. (I won’t schedule anything during these times unless there’s no other choice.)
  • I’m not going to skip a session and claim that as a preempted time. I’ll just start writing as soon as I can near the time I was supposed to start and write for 1.5 hours. There’s enough time between sessions that this shouldn’t be a big deal.

I’m feeling hopeful this morning that this is the right thing to do.

Now, I’m off to get that first session done. I’ll post later today with the results for the first day of this experiment.

Here’s an update on a few other ongoing experiments

The no sweets experiment has been working really well (I’m down 4 pounds in two weeks), and I’ve decided to extend it indefinitely. The only exception is that I will allow myself sweets if I go to a birthday party, which is rarely more often than once a month, and usually less often. I’ll also allow myself sweets at my family’s annual Christmas party, but that’s it. These exceptions are clearly defined so they shouldn’t put any decision-making stress on me. That’s something I’ve liked about this experiment: no decisions. If it’s a sweet, the answer to “Can I?” is simple: “No.”

No caffeine: I haven’t had any coffee and I haven’t had any other caffeinated drinks either.

No Kboards or TPV: I haven’t been back to Kboards or TPV since I started that experiment. The fear of missing out is what was keeping me clicking on links. I’ve read a few author blogs I’d begun to ignore and checked out a podcast or two, but I don’t really feel like I’m missing anything, other than the entertainment factor I get from reading the posts themselves. This experiment has been good for me.

Follow up for several ongoing experiments

Lynn

I’ve stuck to the new food rules and avoided sweets entirely, with the exception of a teaspoon of honey each day (in some yogurt and orange spice tea). Weight is going down, if I can trust the scale after only two days.

The schedule is working well. Sort of. I worked all day yesterday during my work time and during some make up time for the day before. HOWEVER, almost none of that time was writing. What time I did spend writing was spent editing a few bits of the story that weren’t going right and all I did was lose words.

Today I need to prioritize writing over other work.

I did come to a decision on one of my series book cover redesigns. I’ve been unable to make a commitment to a style for the typography—every time I do, I second guess myself. This has taught me one thing: writing isn’t the only place where I let perfectionism hold me back. So yesterday, after an entire day of trying changes that just didn’t work, I decided to stick with what I have and move forward with it.

Because of that decision, I now have two covers complete, one almost complete, and a draft version of two more. I’m going to load the covers as soon as possible, to stop myself from more of this waffling.

Until the covers and files are done and loaded everywhere, I’m making this my focus for the “after writing” time I’m hoping to have soon.

Anyway, I started writing this post with a 15 minute timer running and I’m down to less than two minutes. Time to get writing some fiction. :)

The experiment begins: rules of adjustment

Lynn

So today I’ve already had to make an adjustment to the schedule (but only for today) because I rose late and I’m not getting started at 7 am.

The first thing I decided was that I’m going to have to have some rules for adjustments. :)

Rules for adjustments to the schedule

  1. Lost time should be made up in the same day.
  2. Lost time should be added to the end of the 1–3 time block.
  3. The 11 am to 1 pm break should stay the same no matter what time I get started.
  4. Assume there’s an “if possible” tacked on to the end of every rule above. :)

Benefits of the rules

  1. Sticking to the planned number of hours of work gives me plenty of time to meet my writing goals: 3,233 words a day, 98,333 words a month, 1,180,000 words a year. If it’s ever going to happen, I’ve got to guard the time I need for it.
  2. Even if I skip my entire morning, I’ll still only have to work until 7 pm to make it up! Meaning I don’t even have to take a break for supper because although I don’t like eating late, 7 pm isn’t too late. ;)
  3. A simple, recurring lunch schedule throughout the summer means my children can plan to have lunch with me if they want without having to wait to see what kind of work day I’m having. At their ages, they don’t always want, but sometimes they do.
  4. Having some leeway in the application of the rules always makes me feel better.

I’m feeling hopeful about this schedule. I’m also not feeling pressured the way I usually feel, even though I’ve already messed up with today’s late start, so I’m hoping that’s a sign of good things to come from this experiment!