Advantages of Spreadsheets
This is going to be fairly short and sweet. Concentrate on the word ORGANISE in that pyramid.
I am not an organized writer. I’m a pantster. I wing my way through my books and that has served me very well while writing romance. Okay, there have been moments when I’ve completely forgotten my heroine’s name, the colour of her eyes and how old she is. Ditto the hero. And I do sometimes have to go back and check when I use the same location and characters from previous books.
But the books are fairly short and all of the action is centred on the two main characters. There have been no disasters – at least none that have been brought to my attention. I did once spell a Welsh word incorrectly but I’ve fixed that in a recent re-release.
Moving on to a crime series all that changed.
First, it’s crime so you need suspects – that means more characters.
Second, it’s a series, so you have continuing characters. Friends, neighbours, family, an entire small town with shops, streets, churches all of which need names. And you need spreadsheets to keep track of them. (I’ve tried index cards but I work better on a keyboard).
You need spreadsheets not just to keep track of who runs The Buttery, the corner shop, and the name of the receptionist at The Queen’s Head. You need it so that you don’t repeat names. In Murder Among the Roses there was a moment when I realised that I had three minor characters called Steve. It took my editor to point out the Molly, Polly, Olly debacle.
I’m still not the most organized writer in the world – I need to grow up and learn to plot – but these days the first think I do when I start a new book is set up a spreadsheet and I add each character as they appear.
Some are major and are in every book and I copy and paste those from my main spreadsheet. My Maybridge bible.
This one has all the people and all the places broken down into groups. The family, friends, the police, the businesses, the places.
The other thing I do when I start a new book is spend a little time creating names for the kind of characters in various age groups who are likely to turn up. The name may not stick – names are somehow linked to character - but it means I don’t have to stop and think up a suitable name – or make the mistake of using a similar name that would confuse the reader.
Spreadsheets. Learn to love them!
Liz Fieding
Liz Fielding has a new book out:
MEET ABBY FINCH. SHE’S A BUSY MUM OF THREE, AN EXPERT GARDENER AND THE STAR OF YOUR NEW FAVOURITE COZY MURDER MYSTERY.
One part jealousy. Two parts rage. Somewhere in Abby’s sleepy little village, the perfect murder is brewing . . .
Abby enters the Maybridge Flower Show, never dreaming for one moment that she’ll win the gold. Or an invitation to appear on telly, alongside gardening legend Daisy Dashwood!
Some people say Daisy’s a tiresome diva. But starry-eyed Abby can’t wait for the cameras to start rolling. Until . . .
Daisy staggers out on stage. Only to collapse at Abby’s feet.
Her demise might seem like a tragic accident — resulting from a cocktail of booze and hay-fever medicine.
But Abby’s not so sure. She starts digging, to uncover shifty suspects at every turn. From snarky co-stars to a toy-boy lover, they all had reason to want Daisy dead and gone.
And that’s not the only puzzle playing on Abby’s mind . . .
In life, Daisy went nowhere without her trusty caddy of healing teas. Now it’s vanished.
What if someone’s been tampering with Daisy’s favourite cuppa?
Buy on:
Amazon Kindle Amazon UK Amazon Aust
Multiple Giveaway Alert!
Kindle copy of Murder Among the Roses
Kindle copy of Murder Under the Mistletoe
Kindle copy of Murder in Bloom
Audio codes for Murder Among the Roses & Murder Under the Mistletoe
Let us know in the comments which giveaway would you like to go in for!
Thank you for these tips. I find names (on the rare occasions that I write) difficult.
ReplyDeleteIt is difficult. I'm in the middle of naming major characters for the next book and I have a very long list - just waiting for the right ones to put their hand up!
DeleteSome helpful tips! Thanks for sharing them.
ReplyDeletePleasure, Angie. I hope they help.
DeleteI do love a good spreadsheet - not only for numbers either!
ReplyDeleteI also find making a spreadsheet of scenes as I write helps with the dreaded synopsis!
DeleteGreat tips thanks -Christine cmlk79.blogspot.com
ReplyDeletePleasure, Christine.
DeleteAnd the book sounds good -Christine cmlk79.blogspot.com
ReplyDeleteThank you!
DeleteLovely blog and congrats on new book ~ thanks for commenting on my blog ~
ReplyDeleteWishing you good health, laughter and love in your days,
clm ~ A ShutterBug Explores,
aka (A Creative Harbor)
Thank you, Carol. And for you.
DeleteThank you for sharing these tips. And congrats on the new book. The cover just pops and I like the intriguing storyline.
ReplyDeleteMany thanks, Kristin. I love that cover.
DeleteCongratulations on this new book, Liz! And thanks for sharing all the writing tips.
ReplyDeleteThank you. My pleasure.
DeleteThe tips on using spreadsheets for character and plot organization are so helpful, especially for managing a series.
ReplyDelete"Murder Among the Roses" sounds like a great read.
Happy Wednesday!
Thank you, Veronica. I hope you find the spreadsheet tips helpful and that you enjoy Abby's adventures. Happy Wednesday to you, too!
DeleteThank you, Veronica. I hope it helps.
ReplyDeleteOh, best wishes on your new writing adventures. Be well!
ReplyDeleteThank you so much, Darla. At the moment the adventure feels like potholing but it's never dull!
DeleteThanks for all the writing tips.
ReplyDeleteYou are most welcome!
DeleteInteresting post and thanks for comment on my blog. Cheers Diane
ReplyDeleteThanks, Diane - and my pleasure.
DeleteSounds interesting :-)
ReplyDeleteAs a reader, it bothers me immensely when some characters in a novel have similar names - even the same initial letter is usually irritating for me. I try to avoid that when writing. As a writer, I usually find that the characters in the story "choose their own names". I "see" the characters and "hear" their names. I also try to think up (and write down) a whole (character-defining) life story for my protagonists, regardless of whether I use details from it or not.
All the best from Austria, Traude
https://rostrose.blogspot.com/2024/08/weltreise-2024-immer-noch-neuseeland.html
Thanks, Traude. I agree about initial letters for names. It can get confusing and I do try to avoid it although my brain does seem to keep on throwing up names with a letter I'm trying to avoid. I'm in the middle of naming characters at the moment and the longer the series runs, the harder that gets. But totally agree about the way names somehow "fit" characters.
DeleteGreat post
ReplyDeleteThanks, Joanna.
DeleteAmazing tips! I love them!
ReplyDeleteYou are very welcome!
DeleteGreat tips! I have started using a spreadsheet with my latest book and it definitely helps me stay more organized. Best of luck to Liz.
ReplyDeleteIt really is useful isn't it! Good luck with the latest book.
DeleteI love using the spreadsheet. I also use it for tracking keywords. This is helpful.
ReplyDeleteThank you for coming by to read this post.
DeleteYour posts are really helpful.
Delete