Thursday, April 3, 2008

Equating Pagination

It is easy for any newbie to get lost in tracking the number of pages that a book has, especially if the book is on 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 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.