Louise Harnby | Proofreader & Copyeditor
  • About
  • Contact
  • Indie authors
    • Writing resources
    • Crime writing
    • Portfolio
    • Louise's fiction
  • Services
  • Courses
  • Books
  • Podcast
  • Blog
The Parlour: A Blog for Editors, Proofreaders and Writers

A BLOG FOR EDITORS, PROOFREADERS AND WRITERS

Using a progressive-pricing array formula in Excel to create proofreading project fees

23/9/2016

4 Comments

 
Here's how to create ballpark prices for proofreading and copyediting using Excel.
Pricing array formula for proofreaders
There have been some interesting discussions about pricing models in the online editorial community recently.
  • My colleague John Espirian, a specialist technical writer, prefers per-project fees for long jobs (‘How do technical writers charge?’).
  • One of my own specialisms is proofreading for independent fiction authors. I prefer to build my quotations based on a word count.
  • Then again, I know copy-editors who prefer to build their quotations based on the total number of hours a project will take.

​If you prefer a per-word model, then you may like to consider using a progressive-pricing array formula. It’s not the only way of doing things, certainly, but it’s something I’ve tested and am currently working with. I like this model because it incorporates economies of scale.
 
Before I explain how the progressive-pricing array works, a very quick word on price presentation versus determination.

Price presentation versus determination
Price presentation and determination are two different things.
  • How we present our quotations to clients should be determined by what our clients have asked for. If the client has asked for an estimated bottom-line project fee in euros and I respond with a £ per 1,000 words figure, I’m not going to instil confidence in them that I can follow a brief.
  • How we determine a price should be based on our own needs and requirements. Once we’ve determined what the price will be, we can present it in the way that our client has requested.

Economies of scale
When a proofreader is working on larger projects, there are economies of scale. I’m currently working with an independent fiction author on nine books (which I’m proofreading over a five-month period).

Most of the projects are between 70,000 and 80,000 words in length; a couple are around the 50,000-word mark; and one is a short story with just over 10,000 words. All of the books feature the same central protagonist and a small cast of supporting characters.
 
The serial nature of the content, the reappearance of key characters, and the concentration of action in predominantly one fictitious location all serve to save me time as I move through each book. This means:
  • I don’t have to build a style sheet from scratch.
  • The author’s preferences are stable.
  • I’m getting to ‘know’ the characters so I spot inconsistencies more quickly and easily as time goes on.
  • I’m increasingly familiar with the author’s writing style, so there’s less head-scratching time.

Even so, the average number of words proofread per hour was fewer for the 10K-word short story than for the previous 70K-word novel. And in the first few hours of working on the the 70K-word novel, I proofread fewer words per hour than was the case in the hours that followed.
 
That’s because, even with all the benefits of working on a series, each book still needs a certain amount of ‘stuff’ done to it in its own right:
  • Overall layout and consistency checks.
  • Wildcard searches and macro runs that help me spot and solve global problems efficiently.
  • Plus, of course, the actual word-by-word proofread for grammar, spelling and punctuation issues.

If we take the series element out of the equation, and compare the proofreading of two books in a similar genre for two separate authors, the impact of project length for the proofreader can become even more stark.
 
Consequently, I want to price the 30K-word novella differently from the 100K-word tome. It’s for this reason that while I like to build my quotations on a per-word basis, I don’t want something as straightforward as a £6, £8 or £10 per 1,000 words model. Instead, I want something that respects the economies of scale that come with larger projects. This is where the array comes into its own.

How does a progressive-pricing array formula work?
An array formula can look at a number (a word count, in our case) and then, based on a set of ranges that we’ve provided, price those ranges accordingly. Here’s a very basic example. You might set up your array such that the following are true:
  • First 5,000 words are priced at £25 per 1,000 words.
  • The next 10,000 words are priced at £10 per 1,000 words.
  • The next 20,000 words after that are priced at £7 per 1,000 words.
  • The next 50,000 words after that are priced at £6 per 1,000 words.

This would result in the following quotes:

(1) If you were asked to provide a quotation for proofreading a 2,000-word article, the price would be £50 (£25 per 1000 words).

(2) If you were asked to quote for a 10,000-word short story, the price would be £175. This is based on:
  • £25 per 1,000 words for the first 5,000 words (£125)
  • plus £10 per 1,000 words for the remaining 5,000 words (£50)

The average price per 1,000 words works out at £17.50.
 
(3) If you were asked to quote for a 70,000-word book, the price would be £575. This is based on:
  • £25 per 1,000 words for the first 5,000 words (£125)
  • plus £10 per 1,000 words for the next 10,000 words (£100)
  • plus £7 per 1,000 words for the next 20,000 words (£140)
  • plus £6 per 1,000 words for the next 35,000 words (£210)

​The average price per 1,000 words works out at £8.21 and reflects the economies of scale that the proofreader will be able to benefit from because of the size of the book.

A progressive-pricing array formula in action
I’ll admit that it did take some fiddling to get the actual formula working for me. I used this as my template: ‘Progressive Pricing Formulas For Excel’ (www.cpearson.com).

The example given is similar to the setup I wanted for my own quotation tool, and it provides a formula that I was able to tweak for my own data. See also my downloadable sample below.

Here's a screen shot of what a progressive-pricing array formula might look like in Excel.
Picture
And here's an Excel template you can download and adapt to suit your own preferences. Note that you'll need to look carefully at, and amend, the array-formula box to ensure that the cell descriptions are correct for your data (that's the fiddly bit!).
progressive_pricing_array_sample.xlsx
File Size: 11 kb
File Type: xlsx
Download File

One size doesn’t fit all
The usual caveat applies – my way certainly isn’t the best way or the only way! It’s just one approach of several. I wanted to share my experience with you so that if you fancy testing a progressive-pricing array, you have a framework to get you started.

In practice, you might want to build more ranges into your array formula to provide increased flexibility. The numbers I’ve used above are just for illustrative purposes.

I find the array formula useful for ballpark quotations because I want to provide a quick quote based on a word count. Obviously, any professional proofreading project needs to be evaluated on more than just a word count before terms are agreed and confirmed.

Those editorial professionals working with complex projects that require varying levels of intervention might find a progressive-pricing array formula far too limiting. It functions well for me as a proofreader because of the nature of my work.

I do, however, have different arrays set up for different client types (e.g. students for whom English is a second language; independent authors whose first language is English) and for different levels of proofreading service.

​The prices I assign to the various ranges are different in order to reflect the variances in how I work with the text and the speed at which I am able to proofread.

How do you build a price for editorial work?
How do you build your quotations? Per hour, per word, per day, per project? Have you tested different approaches for building your fees? And do you find that different models work better for different types of editorial work?
 
I think that, at the very least, we should test our pricing models. I’ve written about this in more detail on the An American Editor blog: ‘The Proofreader’s Corner: Testing Editorial Pricing Models’.
 
I’m always interested in learning how others go about pricing editorial work so please do leave a comment if you have something to share. 

Louise Harnby is a fiction copyeditor and proofreader. She curates The Proofreader's Parlour and is the author of several books on business planning and marketing for editors and proofreaders.

Visit her business website at Louise Harnby | Proofreader & Copyeditor, say hello on Twitter at @LouiseHarnby, or connect via Facebook and LinkedIn.

If you're an author, take a look at Louise’s Writing Library and access her latest self-publishing resources, all of which are free and available instantly.
Sign up to Louise's blog

4 Comments
Catherine Turner link
26/9/2016 04:19:19 pm

I am just setting up as a freelancer and have been feeling rather daunted by the subject of what to charge and how to quote. It's really useful to get an idea of the different approaches and a clear explanation of this particular method. Feeling less daunted now - thankyou!

Reply
Louise Harnby
2/10/2016 11:40:36 am

You're very welcome, Catherine. I agree that it's worth considering a variety of options. You might also like to take a look at Melanie Thompson's Pricing a Project, available from the SfEP: http://www.sfep.org.uk/resources/guides/#PP

Reply
Kerri Miller link
19/7/2018 02:54:17 pm

Thanks so much for this! I've been struggling for the past year to come up with a rate schedule that's fair to both the client and me -- not easy when you accept projects of all sizes. Hourly simply doesn't appeal to most clients (I totally understand needing to control the budget). I tweaked your spreadsheet for my US business and have been very happy with the results!

Reply
Louise Harnby link
19/7/2018 03:05:53 pm

So glad to hear it's proved useful for you, Kerry! Thanks for letting me know!

Reply

Your comment will be posted after it is approved.


Leave a Reply.

    Louise Harnby
    SEARCH THE BLOG
    SUBSCRIBE TO BLOG

    Books for learning and for leisure!

    Picture
    Picture

    Testimonials

    Dare Rogers

    'Louise uses her expertise to hone a story until it's razor sharp, while still allowing the author’s voice to remain dominant.'

    Jeff Carson

    'I wholeheartedly recommend her services ... Just don’t hire her when I need her.'

    J B Turner

    'Sincere thanks for a beautiful and elegant piece of work. First class.'

    Ayshe Gemedzhy

    'What makes her stand out and shine is her ability to immerse herself in your story.'

    Salt Publishing

    'A million thanks – your mark-up is perfect, as always.'
    More testimonials

    Online courses

    Picture
    Picture
    Blogging for Business Growth course

    Help for editors

    Proofreading stamps
    Q&A with Louise

    Professional affiliations

    ALLi Partner Member
    The Book Designer
    SfEP Advanced Professional Member: Harnby
    ACES: The Society for Editors
    Picture
    AIPP: Association of Independent Publishing Professionals

    Categories

    All
    Around The World
    Audio Books
    Author Platform
    Author Resources
    Book Marketing
    Business Tips
    Client Talk
    Crime Writing
    Editing
    Editorial Tips
    Editorial Tools
    Editors On The Blog
    Erotica
    Fiction
    Freelancing
    Free Stuff
    Getting Noticed
    Grammar Links
    Guest Writers
    Indexing
    Indie Authors
    Line Craft
    Link Of The Week
    Macro Chat
    Marketing Tips
    Money Talk
    More Macros And Add Ins
    Networking
    Online Courses
    PDF Markup
    Podcasting
    Proofreading
    Proofreading Marks
    Publishing
    Punctuation
    Q&A With Louise
    Resources
    Roundups
    Self Editing
    Self Publishing Authors
    Software
    Stamps
    Starting Out
    Training
    Using Word
    Website Tips
    Work Choices
    Working Onscreen
    Working Smart
    Writer Resources
    Writing

    Archives

    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012
    November 2012
    October 2012
    September 2012
    August 2012
    July 2012
    June 2012
    May 2012
    April 2012
    March 2012
    February 2012
    January 2012
    December 2011
    November 2011


    All text on this blog, The Parlour, and on the other pages of this website (unless indicated otherwise) is in copyright © 2011–19 Louise Harnby. Please do not copy or reproduce any of the content, in whole or part, in any form, unless you ask first.
ALLi Partner Member
The Book Designer
SfEP Advanced Professional Member
Member of ACES: The Society of Editing
Judith Butcher Award: Winner 2017
​Privacy policy | Services | Terms and conditions | Code of practice | Portfolio | Qualifications | Order form | Self-publishing resources | Editor resources | Testimonials | Bio page | 1:1 consultations for editors and proofreaders | Tel: 07767 028976 | © Louise Harnby 2011/19
  • About
  • Contact
  • Indie authors
    • Writing resources
    • Crime writing
    • Portfolio
    • Louise's fiction
  • Services
  • Courses
  • Books
  • Podcast
  • Blog