Choices, Choices

I have been wanting to write another fantasy novel for a couple years now. The last one I published was in 2017 and that series still makes me money with new readers but I have nothing for the folks who’ve already finished the series. Plus, fantasy is my first love and what I as a reader spend most of my time reading.

But I keep not doing that.

When I stop and think about this fact, those are the days when I really envy those people who have one direction in life that they’ve always wanted to go. That one story they’ve always wanted to tell. That one person they’ve always wanted to be.

I am not that person. I am the person who has eight zillion possibilities I can see at any given moment, about half of which seem really interesting.

At this point I have published over 2 million words: close to a million non-fiction across about ten broad categories, about half a million in speculative fiction, about 350K in romance, and about 320K in mystery.

And I have books I want to write that would not fit with anything I’ve already published. (*head desk*)

Just imagine if I’d published 2 million words of just one type of fiction…That would be about 20 fantasy novels. Or 50 cozies. If you can’t find an audience with twenty novels, then, hm, maybe time to move on to something else.

Alas. I would’ve died of boredom before I wrote 20 fantasy novels in a row.

So I bounce around and pay the consequences which is slower build-up and lost momentum sometimes.

Now, ironically, the reason I haven’t written a new fantasy is because I’ve paid enough attention to numbers to know it’s a huge risk to take to do so and I’ve been trying to focus better the last couple years.

It takes me X hours to write most non-fiction titles. A cozy mystery takes about 2X. But a fantasy takes 6X. At least the last one I wrote did.

And right now my overall profit per writing/editing hour for non-fiction is 20x my profit per hour for writing/editing fantasy.

So, of course I keep choosing the thing that takes 1/6 the time and pays 20x the profit.

But…

Fiction is a tricky beast. Because it’s hard to see the potential before it takes off. Non-fiction you can have a single standalone title that does well on its own so if you hit with a title you can immediately see the potential. But fiction can be one of those situations where nothing, nothing, nothing, and then BOOM all of it moves at once.

I know of more than one author whose earlier series didn’t start to sell well until their second or even their third series caught on with readers.

Fiction also has more potential for additional titles.

You might find this hard to believe given the number of titles I’ve written on certain subjects, but there are only so many books you can write about each non-fiction topic before you run out of new things to say.

With fiction, though, if you create an interesting world or an interesting character the number of potential titles is limitless as long as your readers stay with you and you can keep it fresh for yourself.

So with fiction it doesn’t always come down to the numbers you already have. Sometimes it comes down to that gut instinct that you’re leaving potential on the table.

Of course, sadly, the only way to test that you’re doing so is to put in the hours to get that next title out and see how it does. (I mean obviously if you’re getting unending fan letters asking for more that’s a pretty solid indicator. But for those of us who are not getting those letters, putting in the work and seeing what happens is pretty much the only choice.)

And I swear I am going to do that this year with a fantasy novel.

And maybe a romance, too, since the last couple sold thousands of copies.

I’m going to do it.

Right after I write these next three non-fiction titles. And maybe another cozy. And then…yeah. Sigh.

Damn it. Where did my workaholic tendencies go? If only I didn’t want downtime to read other people’s books and walk my dog and see my family and veg out on silly TV shows like Cake Wars.

Ah well.

What I do know is that even if I still don’t publish that fantasy novel this year I will keep moving forward in some direction or other so that by the end of the year I have another 300K words out there of some sort.

Because I may be foolishly building a barn, a house, and a fence around my property all at the same time, but at least if I keep working at it one of them will eventually turn into something useful. (I hope.)

7 New Releases

I had no intention of announcing the release of seven new books at one time, but, well, I forgot to announce the Word 2019 releases and then it happened that the Easy Excel 2019 proofs arrived at the same time as the Excel 2019 Formulas and Functions Study Guide was finished and here we are.

So, if you have an interest in Microsoft Word or Microsoft Excel 2019, read on. If not, you can skip this.

First up, the Microsoft Word 2019 versions of Word for Beginners and Intermediate Word are now out. Once more, if you bought the originals, no need to buy these ones, too. I don’t think there’s anything so drastically different between them that you’d need the new ones. I think I may have moved one item from the intermediate level to the beginner level but that’s about it.

You can click on the images below to be taken to the store of your choice.

Okay. Next up. The Easy Excel Essentials 2019 books are now out. These are intermediate-level titles that focus on one specific topic: PivotTables, Charts, Conditional Formatting, and The IF Functions.

In this case, I’d say there are substantial differences in the IF Functions title because Excel 2019 includes IFS, MAXIFS, and MINIFS which didn’t exist before. So if you’re looking forward and don’t need to worry about backwards compatibility, this is the book you want. If you work with a lot of different Excel users and so can’t risk using the latest and greatest, then stick with the old version. Excel 2019 Charts also covers histograms which was not covered in the original title and Excel 2019 Conditional Formatting is expanded a bit.

Also, the print versions of these books have very different formatting. I decided this time around to go with the standard computer book size formatting for the print versions so these are all 7.5″ x 9.25″. They also have larger text than the original series so may be better for those who struggle with small type.

The astute observer may also notice that the 2019 books do not include Formatting or Printing which were part of the original series. Mostly that’s because even though I meant the titles in this series to be bought as one-offs a lot of people buy the entire series at once so I wanted to focus in more this time around. Really, if you need formatting and printing, just buy Excel 2019 Beginner. It will cost you less and you will learn more.

Okay. Final release to announce, Excel 2019 Formulas and Functions Study Guide. This is the equivalent to the quiz books for the Excel Essentials series. Basically, it takes the content of Excel 2019 Formulas and Functions and walks through that content in a question and answer format. There are also ten bonus exercises at the end to test putting the functions to use in real-world scenarios.

Once more, if you already bought and worked with the original 50 Useful Excel Functions and 50 More Excel Functions and their associated quiz books, probably no need to buy this one. It does cover some new functions like TEXTJOIN and IFS but you can probably fill in the gaps from within Excel itself without needing to buy a new book for it.

(Not that I object to making money, so buy it if you want. Just saying you don’t have to.)

Errata – 50 Useful Fn Quiz Book

This last week I was working on the Excel 2019 Formulas & Functions Study Guide and it led me to review the 50 Useful Excel Functions Quiz Book and I noticed a few errors.

I submitted updated versions of the books today so anyone from tomorrow forward won’t see them, but for anyone who already owns that book (or the Excel Essentials Quiz Book), I wanted to mention the fixes I made.

(I think the book might be being used in a college class right now, so felt it was especially important to mention the updates.)

1. HOW FORMULAS AND FUNCTIONS WORK QUIZ, Question 7F and 8F. Those should be written as =(4+3)*2 and =(E1+A1)*C1, respectively or else the answer doesn’t work.

2. BASIC COUNT FUNCTIONS QUIZ ANSWERS, Question 11. Ignore the last sentence of the answer because there is actually overlap between COUNTBLANK and COUNTA.

3. VLOOKUP QUIZ ANSWERS, Question 5. The answer is actually one because you can use a VLOOKUP to look in the exact same column to find the closest answer to your lookup value.

Some Writerly Comments

First, if you have audiobooks and didn’t pay much attention to the latest ACX email they’ve made some pretty significant changes.

As of March you should actually be able to see returns on your dashboard. No more hiding the extent of the return issue in sales. Which becomes less relevant with another change they made as of the start of the year which is that if a return is made after more than 7 days they’ll eat the cost instead of charging it back to the publisher of the audiobook.

And no more seven-year lock-in. Not even for those with royalty share. If you can make a deal with your audiobook narrator you can move to non-exclusive. And after 90 days you can even remove your books from distribution with them.

It’s basically everything I would’ve liked to see them do about 9 months ago when I first realized that I was basically listing books with them so they could give them away for free.

For me it was too little, too late, though. I asked them to delist my audiobooks and that should happen within the next two weeks.

I was able to do that because they’re such a small part of my earnings. My wide audio makes 30x as much each month as my ACX audio. (We’re not talking big numbers there.)

I’m doing it because personally have no interest in being in business with someone who so patently prioritizes their interests over their business partners’ and doesn’t act to change anything until things publicly hit the fan. So…

Bye-bye, ACX.

Second, some nice new developments at Barnes & Noble where they’re clearly making some efforts to support self-publishers. As of this month they’re going to a flat 70% payout for all price points.

I know they had that site glitch last year that upset a lot of people but all in all I like working with them and am pleased to see those developments.

Google seems to be picking up some steam as well these days, so that’s nice as well. And I think Apple and Kobo are still in the hunt and making improvements, too. So some promise there.

Third, I just did my ad numbers for January and have to say I’m still pleased with AMS ads for my core books.

To be clear, the ads no longer work for all of my books. I just don’t have a deep enough catalog for them to work well in some areas, but overall they definitely move the needle for me.

And compared to what I need to do to set up a Facebook ad, which I also did some of this week, they’re a helluva lot easier to get up and running. No ad creative to come up with, no three fields of text to populate with something engaging, no need to worry that the link you provide in the ad will actually work for the reader…

As far as AMS goes, I was having a conversation earlier this week with someone about the ads and their effectiveness and I think the key point is that you need alignment between everything the potential customer sees along the way from search term to purchase.

If someone searches for “dragon fantasy” then the best possible match for that search term is a kick-ass cover with a dragon on it. (Not an okay dragon. A kick-ass one.) That has to be followed by a book description that’s all about dragons and fantasy worlds and a price point that matches the genre and reviews that are like, “OMG, the dragons!” The more every piece and step lines up, the better the ad performance is going to be.

Miss one step and you have an impression without clicks or clicks without sales. Enough of that and your ad dies or you’re out a lot of money or both.

Fourth, I’m having one of my periodic “what the hell am I doing with my life” thoughts, which I think most self-publishers (or writers) do at some point. (I know there are some who don’t, but not all of us have that stellar rise to the top and ability to stay there.)

Even though I’ve made steady progress year after year, this is not an easy business.

(That’s actually why I like it, which is absurd. I get bored with things I can do well and no amount of money makes up for that lack of challenge. Although I may feel differently about that when I’m 50 and unemployable and all I have to show for my life is my books…Haha. Sigh.)

Spending time and effort on something that can feel like slogging through molasses at times has to make you stop and wonder every once in a while what exactly you’re doing with your life. Like, wouldn’t I rather go back to that six-figure-a-year-part-time project where they treated me like a glorified admin than do this every day?

But I like my dog. And I like not having to be on 28 Zoom calls a week. (Like my brother right now.)

And I like living in my own head instead of trying to figure out how to get that semi-senior executive who thinks he knows all the answers to listen before something vital crashes and burns.

So I continue while I can and I put my faith in the powers that be that something will save me from me when the time comes that it all finally collapses. Haha.

Anyway. We live in interesting times.