Some of you are intrigued. Others are worried there is a Wicked Cozy breakdown going on–what does this have to do with writing cozies?
First, with pivot tables, you need to think about the overall sort of the data. In writing, you need to think about what you need to pull out of the data/scene. What is the point of the scene? Is everything serving that?
Second, in pivot tables you can keep narrowing or widening the data until you learn exactly what you want to learn. In writing, you need to keep working until you get it right. Can you add elements, or take some out? When is the scene doing exactly what you need it to do?
Third, in pivot tables you can literally say “make the rows columns and the columns rows: and make it so. In writing, does a pivot help? Should you change point of view? Add a character? Layer in a red herring? Change the dialogue, or the subtext?
And lastly, details matter. With a pivot table, you can change formatting, add totals or subtotals, add colors, and more. In a scene, can the reader smell, see, taste, hear, feel elements in the scene? Is the dialogue polished? Are all the boring bits gone?
I love learning new things, and suspect that pivot tables are going to change the way I work with data. But as importantly? They are going to help me edit my manuscript. Looking forward to updating you on that soon.
**Note: Do you live near Newburyport, MA? Tonight I am going to be moderating a panel with three of the Wicked Cozy Authors, Liz Mugavero, Edith Maxwell, and Jessie Crockett! Hope to see some of you there!**