Equating Pagination

Share on facebook
Share on linkedin
Share on reddit
Share on twitter

It is easy for any newbie to get lost in tracking the number of pages that a book has, especially if the book is in the preliminary stages of layout. I found this the hard way when I tracked down the number of pages that we were producing for the whole month of March. I was staggering to input every detail on an Excel spreadsheet that I thought might help me in tracking. Bad thing is, I did not use the diabolic mathematical capabilities of Excel which really could have helped me do my work more effectively.

Microsoft Office Excel, as many of us may know already, is able to do mathematical solutions. Since I already have an idea of the pages we were working on, I could have just created a start page column and an end page column then let Excel do the math.

Now getting the exact number of pages doesn’t mean that Excel only has to subtract the end page with the start page. Excel also needs to add 1 on the equation to get the right number of pages. Therefore a chapter ranging from page 1 to page 7 is…

  • 7 minus 1 equal to 6 plus 1… answer is 7
  • Total No. of Pages = (Last page − First page) + 1.
  • So counting from page 1 to 7, the total number of leaves is 7.

If only I could have harnessed the capabilities of Excel. Maybe I’ll try it again in the office later this morning.

Mercenario Cadag

Mercenario Cadag

The author has been in the publishing industry since the year 2000 and has exposure in both print and digital production processes (typesetting, page layout, and eBook creation). He is an aspiring writer and shutterbug. Has an insatiable desire to learn the cosmos but mostly enjoys studying how information dissemination could help improve people’s daily lives.

Leave a Comment

Your email address will not be published. Required fields are marked *