![]() Everything from Column D to Column BZ contains the characters. Column A has all the event dates, with Column B containing a scene title and Column C containing a brief note or outline of key events. I’ve put the character names in one row with their birthdate above their name. Sorry about the poor quality, but it’s a big spreadsheet and Word is hopeless in creating PDFs. I’ve attached a screenshot to show you how it looks in use within a timeline. I’ve tried many times to get a year, month and day calculation in the one formula, but it’s never worked properly. I found it by doing a search online for working out birthdays. The DATEDIF has no documentation within Excel’s Help files. The “$” symbol locks the cell reference to a specific row-column location when you drag the cell contents down columns or across rows. The second one does the same thing for months and days. The first formula tells Excel to calculate a date range and display the result in years and months. The second cell reference is another date-for example, the date Johnny rips the head off Molly’s possessed dolly. The first cell reference is the ‘from’ date-like your character’s birthday. If you plug in the following formula for each character, you’ll get the comparative information you need: I rely on an Excel spreadsheet for that very reason. > I'd be happy to know how you handle this type of problem. > (I've searched but haven't found anything so far). Maybe something else exists that I don't know about > I'm not familiar enough with excel to know if I can use it to organize > he fell off a horse on his tenth birthday, besides counting on my ![]() > John's parents, his older sister, younger cousin and three uncles, when > Here is an example: is there a quick way of finding out how old were > difficult to keep track of how old a character is at any given time. > My novel is very long and I'm dealing with over forty characters. > spreadsheet.) to synchronize the ages of different characters other > Does anyone of you know of an (easy) way (some people mention an excel I've been looking for a software to create a chronology for some time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |