I’ve got a specific question that I don’t know how to ask more generally, so apologies for all the details.
I’m editing a book by chapter. I do three passes on each chapter: developmental editing, copyediting, and proofreading. I am paid a flat fee per chapter.
In a table I input the word count for each chapter (which changes at the different passes) and then calculate the number of pages per chapter (word count/250). I input the time spent on each edit in hours (e.g., 5.25) and calculate my editing speed per page (pages/hours).
I want to be able to:
- calculate the total book pages edited per hour by task (dev edit, copyedit, proof) and by chapter
- calculate my hourly fee per chapter (total hours spent on chapter/chapter fee)
I could do it in Excel, but I can’t get out of the “cell” mindset to do it in Coda.
I’ve tried setting up a table for each chapter, detailing the data per editing stage. I’ve tried setting up a table for each editing stage, detailing the data per chapter. I cannot figure out how to set up the formulas either way. And I’m not sure how I would combine the two tables into one and set up the formulas.
Any insight would be appreciated!