I’ve made a mistake I don’t plan to make again

Yesterday morning, I read a good chunk of my current book. I was pretty damn pleased with it. But there were a few things I needed to fix. Only I decided not to highlight those things because I knew I was going to have to get back to the read through on the computer and what was the point?

The point was that if I’d just highlighted those little bits I could have sped through this second read. I forgot just how much time it takes me to thoroughly read 40,000 words. So today has not been the kind of writing day I really wanted it to be.

It’s a mistake I don’t plan to make again.

Note to self: Next time, just highlight the damn mistakes!

Trying to read a couple of craft books

I’ve been stalled out reading a couple of craft books lately, but I’m going to make more of an effort to get through them as soon as I finish this particular book I’m working on.

A while back, I picked up the Kindle version of this one: 27 Fiction Writing Blunders – And How Not To Make Them! by James Scott Bell. I started it but got distracted, and I keep meaning to go back to it, but I just haven’t. I liked what I read, I just need to read the rest of it.

I got the paperback edition of this one as a gift: The Anatomy of Story: 22 Steps to Becoming a Master Storyteller by John Truby. I started it, skipped to the end because I do that sometimes and read several chapters out of order. Now I just need to start at the beginning and make it there.

This is my note to myself to remember to get back to these. Frankly, it might be time. It’s been a while since I’ve read anything about the craft.

I want to write every day

How can I say this and it not be a goal for the year, for the month, for my life? I don’t know, but I have and it isn’t. It’s a statement of fact. I want to be the kind of writer who writes every day. It’s not a challenge and I’m not making it into an experiment. I’m just throwing it out there so that I can hear myself say it because it’s true.

I want to write every day.

Random thoughts: File naming conventions

First, a new column for the blog, if you can call anything here columns: Random thoughts.

Second, I had one. :D

It led me to researching the accepted wisdom for naming files. I have a very confused set of file name conventions I just haven’t been happy with for a while.

Almost everything I’ve read over the years says to avoid spaces in file names, so a while back I started naming folders and files like this:

c:\Writing\MySeries\MyBookTitle\MyBookTitle.docx

I did that not just because of having read a lot of advice saying to avoid spaces. I also had an instance where a file on my computer wouldn’t delete. I had to use the command prompt to get rid of it, and oh boy, was that a headache. So I don’t use spaces in file names in most instances anymore.

Some folders are like this though:

c:\Writing\MySeries\MyBookTitle\cover

In fact, all the subfolders inside my book folders are lowercase and use _ for spaces like_this, but all the folders outside those book folders are LikeThis or Like This.

I hate it.

It’s not very readable, and it’s definitely not consistent, although it is more readable than my first iteration:

c:\writing\myseries\mybooktitle\mybooktitle.docx

It was a nightmare with filenames like:

myseriesbookcovertemplate5x8.xcf

So I continually find myself looking for a better way, and yet internet searches never turn up anything I find particularly useful.

At some point, I read something that said to avoid hyphens because of cross OS compatibility. Underscores were the winner, but I can’t remember why, and so I started using _ whenever I needed a space.

I still don’t like spaces in file names because of the internet issue. And they’re ugly. Seeing %20 mixed into a long file name makes that filename look ridiculous and difficult to read.

So mostly I tried to stick with PascalCase.

PascalCase was a new term to me when I came across it. I thought I was using camel case, but apparently thisIsCamelCase, because it uses a lowercase first character.

Today I came across loads of people recommending ‐ instead of _ as a space replacement. So I’m back to wondering why hyphens aren’t a good idea in file names, because I still don’t remember why underscores were the winner, only I didn’t run across anyone talking about that issue this time around so I still don’t know!

And really, I think they’re mostly talking about filenames and folder names for the web, and that doesn’t matter much to me except in a very few specific instances (like book cover file names).

One reason I don’t like the dash as much as the underscore is because the dash isn’t as easy for me parse out as a space in a column of file names. But an underscore, if used in a hyperlink with an underline, is unreadable. You won’t even know it’s there sometimes.

:o

Really, this whole this is just one big annoying mess.

However, I have finally settled on a file naming convention this time, one that I’m pretty happy with, despite everything (and after two days of letting this obsession occupy brain space). Although to be honest it doesn’t solve the readability problem of PascalCase.

Maybe you don’t have trouble reading it, but I sure do!

Anyway, here’s what I came up with:

Stop using [ ] and other special characters in file names

Use hyphen instead of space when needed

MyFile-2016-01-09.txt

Dates like 20160109 are impossible for me to read, so I don’t use them.

Stick to title case for most things with no spaces

MyBookTitleNotes.docx
MySeries
MyBookTitlePbCover.xcf

When using 1–9, use 01–09

01-MyBookTitle

MyBookTitle root directory

MyBookTitle.docx
MyBookTitleMeta.docx
MyBookTitleNotes.txt

Folders (when needed)

backups
cover
ebooks
paperback
research

Folders are lowercase because they’re less distracting that way.

I know this is inconsistent with my other folders, but I actually do find them less distracting when they’re lowercase and they’re all one word names, and these particular folders are inside folders where I have to differentiate between a lot of similarly named files. I just won’t use two word file names here. If it ever does become necessary, I’ll just use a hyphen.

Files inside these folders

\cover\

MyBookTitleCover.xcf
MyBookTitlePbCover.xcf
my-book-title-1000.jpg

For jpg, png, gif, tif, use all lowercase, no space, no underscore, since these files are more likely to be used online.

\ebooks\

MyBookTitle.jutoh
MyBookTitle.epub

\paperback\

MyBookTitlePb.docx
MyBookTitlePb.pdf
MyBookTitlePbCover.pdf

Add a version number to the old file when replacing it so that it doesn’t overwrite old file in \backups\ folder if it is moved there later

MyBookTitlePb.docx (current)
MyBookTitlePb1.docx (oldest)
MyBookTitlePb2.docx (second oldest)

And that’s it. I did some cleanup to rename the files and my directories now look a lot better and everything is much more consistent. Now I’m satisfied, at least for a while. :D

Oh, and if you’re wondering how I changed all these names quickly and easily, I used a bulk renaming utility for the majority of the work. They’re very handy to have around!

Let me say that although I feel very satisfied with the changes I’ve made, I’m completely aware of the fact that spending two days on this was two days too many.

It’s procrastination, plain and simple, most likely to deal with the writer’s block I’ve got going on, and the only way to solve that is to get this obsession out of my system. Honestly, I almost believe these episodes are a way for my subconscious to keep my conscious thoughts occupied so it can work out whatever issues are going on with my writing. :)

Here’s hoping I’m correct about that and that when I finally put this obsession to bed, I’ll be ready to get past the current part in my book that has me completely stumped.

Never stop learning: A Successful Release Strategy for Authors video series

JA Huss is releasing a video series (A Successful Release Strategy for Authors) on her blog in the Marketing Tips Monday category.

I’m not much for doing active marketing and promotions but that doesn’t mean I don’t read/watch/listen to people talk about that stuff. I love to learn new things, even if I don’t always put those things into practice.

The series has just started, and you can follow this link to watch the introduction. I really enjoyed the intro video and I’m looking forward to the rest.

My sales graph looks nothing like hers. Lots more spikiness to mine and nowhere near the sales. Like, seriously. I’m making a living, but my living is in the southern U.S. and you know how cheap it is down here.

But someday.

Then again, probably not. The size of the market/niche my books are in isn’t that big (a subgenre of a subgenre of a genre) and I don’t want to branch out into a bigger one.

There’s also the fact that I’m just not the kind of writer who can write books people consistently fall in love with. I mean, I write some books that people love, and that keeps me fed, but there are massive differences in how much love each of my series  and books get.

Anyway, I thought I’d share the link. Go out and learn something! :)

Changing a book cover on a paperback: New edition or not?

This post has been updated with an addendum. Turns out I was wrong.

I understand that technically I do not have to create a new edition of a paperback at CreateSpace just for a book cover change. But I’ve been mulling over my options and I’ve decided I should.

Here’s why: Resales.

If the book cover is different on more recently purchased copies of the book, anyone trying to list the old book for sale used is going to be listing a different product, because the book cover is an important part of the paperback.

When I buy a book, I expect it to come with the cover shown on the product detail page. If it were to arrive looking like a different book, I’d be pissed, because that’s not the book I thought I was buying. Covers matter to me and I’m sure they matter to a lot of people—especially people who collect paperbacks.

Therefore, I feel obligated to issue a new edition since I’m replacing the cover on the book in question. It only makes sense really.

The next question becomes do I leave the old edition for sale until the new edition makes it to Amazon and the other stores, or do I take it off the market as soon as I upload or approve my files?

I think I’m going to wait. No point in having the book off the market longer than necessary, right? Maybe I’ll even leave it up for a short while in case anyone wants to pick up the copy with the old cover before it disappears. (Okay, that’s probably not going to happen, but it’s fun pretending.)

Now, off to actually finish the new edition of that paperback. I’ve already corrected one lone typo and added some info to the front matter, but I still need to finish the actual new paperback cover design.

Addendum: As soon as I hit the Edition field in CreateSpace’s setup process for a new project, I started to have second thoughts.

That led me to a little more research, where I found this:

How do I tell one edition from another?

A new cover does not indicate a new edition as long as the publisher has not changed. What usually indicates a change in edition (providing the publisher has not changed,) is the change in the content of the book. This most often occurs with non-fiction books, especially textbooks.

So, now I’m thinking a new cover does not make a new edition, despite the issue with resales.

Then I continued, and found what Bowker had to say (Bowker issues ISBNs in the United States):

If changing the cover of a book, does a new ISBN have to be assigned?

US practice is if the book is just out or the idea is to give a marketing boost to the product, then no, a new ISBN should not be assigned. However, if the change in cover substantially changes the product (ie., would lead to customer complaints), then a new ISBN should be used.

I would complain if the cover was different, but I guess buying used copies, it’s just a chance you take.

Finally, I found some information in the Amazon KDP Support forums that makes a lot of sense after having read the previous two items. I can’t find a permanent link to the actual reply so here’s a link to the full thread and here are the relevant quotes:

I’m wanting to do a second edition of my novel…. There are minimal changes to the text (literally, MAYBE two words were corrected); the real reason for the second edition is that I have a completely new cover I’m wanting to use that will better fit my series…. [W]hat do I do in order to have my listing reflect the new cover and new edition without losing my reviews? Or is it unnecessary to make such a big deal out of a “second edition” when the cover is the only thing being updated?

The reply:

I would call that (as trad publishers do) a “reprint” and not a second edition. A second edition means significant content changes. Some of the publishers I work for have it down to a percentage requirement–such as, 40% of this book must change in the second edition. That’s the highest percentage I’ve seen; lowest was 20%. Changing the cover image does not, in my mind, warrant calling it a second edition. Second printing, if you’re printing–not that that really makes any sense in POD, of course. But with trad publishers who print up batches of something at one time, if they catch a few errors that they do wish to correct, but aren’t ready for a second edition, the email we get says “Let’s save this in a file for reprints” or “We’ll catch it in reprints.”

On that note, because there really are only very minor text changes to the book (one typo corrected and a few lines of updated front matter), I’m going to update the first edition with the new file and cover image and not create a second.

As for some other books I’ll be updating soon, they’ll have to be new editions, because the trim size will change and CreateSpace won’t let you do that as an update.

Revisiting the cumulative title sales spreadsheet

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!

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!

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

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

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

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

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

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

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

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

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

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

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

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.