A New (to me) Approach of Keeping Track of Things When Writing an Historical Novel

 Using An Excel Spreadsheet To Keep Track Of Dates, Times, History and Characters

Ned Barnett

I've developed something new to me (obviously not to others, though I haven't heard of it before) to help me with my massive-and-growing historical novel about the start and first year of the War in the Pacific (WW-II).  The book is:

"Year One - Pacific ... Aerial Combat from Pearl Harbor to Guadalcanal ... and Beyond"

It is also currently at 1,977 pages, or 669,961 words - which is why I'm publishing sections - some of them mini-books of 150 or more pages - on Amazon:

http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Dstripbooks&field-keywords=Year%20One%20Pacific%20-%20Barnett

To help me keep track of everything, I have already created an extensive bibliography to help me remember of what I've read in the way of research (it helps when i need to go back and clarify a point of historical fact).  In addition, I've already put together a 70-page collection of character bios (so when I return to a character after 750 pages or so, I can remember who they are).

However, starting last night, I've been using Excel to create a timeline - from the 1890s through WW-II and even beyond to Korea - and for each character, I'm putting down what they did on a given year, or month, day - or (for some hectic days like December 7 or June 4), parts of days. 

At the top of the page, in a line that is always at the top of the page (it took me a couple of hours to figure out how to do that), is the date and the historical events that took place on that date (September 1, 1939, Hitler invades Poland, launching WW-II in Europe).  Then, for each character in turn, if he or she did something important on that date, I add it in.

Already I see a couple of benefits.  First, I'm seeing characters who I'd created for just one scene, who could easily be involved in other parts of the book.  Since the interconnectedness of the characters is important (if you've read anything by WEB Griffin or Tom Clancy, you know what I mean by that).  Next, I'm spotting critical dates and historical events that are not included in the book. Yet.

I offer this as an insight that other writers of historical fiction (or, for that matter, any fiction), might find useful.  If you do, please drop me a line and let me know - and if you've got a better way, HELP!  I'm wide open.

Thanks