Is anyone using something to develop a history timeline? I don't mean lie the storyboard, which directly relates to the story. What I mean is like a historical backdrop. In my mind, I would put in titles and dates and the tool would draw a timeline. I can write one, but if there's one out there... I don't need to reinvent a wheel.Thanks. Have a blessed Thanksgiving, everyone.
--
You received this message because you are subscribed to the Google Groups "yWriter" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ywriter+u...@googlegroups.com.
To post to this group, send email to ywr...@googlegroups.com.
Visit this group at http://groups.google.com/group/ywriter.
For more options, visit https://groups.google.com/groups/opt_out.
--
Hi, Jennie,
I know exactly what you mean. I rely on an Excel spreadsheet for that very reason. If you plug in the following formula for each character, you’ll get the comparative information you need:
=DATEDIF($D$80,A86,"y") & " yr " & DATEDIF($D$80,A86,"m")-12*DATEDIF($D$80,A86,"y") & " mth"
=DATEDIF($A$129,$A161,"m") & " m " & DATEDIF($A$129,$A161,"d")-30*DATEDIF($A$129,$A161,"m") & " d"
So, what does all that garbage mean?
The first cell reference is the ‘from’ date—like your character’s birthday. The second cell reference is another date—for example, the date Johnny rips the head off Molly’s possessed dolly.
The first formula tells Excel to calculate a date range and display the result in years and months. The second one does the same thing for months and days. The “$” symbol locks the cell reference to a specific row-column location when you drag the cell contents down columns or across rows.
The DATEDIF has no documentation within Excel’s Help files. I found it by doing a search online for working out birthdays. I’ve tried many times to get a year, month and day calculation in the one formula, but it’s never worked properly.
I’ve attached a screenshot to show you how it looks in use within a timeline. Sorry about the poor quality, but it’s a big spreadsheet and Word is hopeless in creating PDFs.
I’ve put the character names in one row with their birthdate above their name. 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. Everything from Column D to Column BZ contains the characters.
The easiest way to propagate the worksheet is to put the formula into the first character’s “event” cell (the one where you want the age to appear). Use the “$” symbol before the second reference date—for example, $A$129,$A161—so that the reference is consistent when you drag it across the row for all forty characters. The tedious bit is that you then need to change the origin cell reference—$A$129 , in this example—for every Character so it points to the right birthdate. The good news is that once you’ve got it across the row, you can drag down the columns without having to change the formula again.
I may not have explained this very well. It’s easier to do than to explain, fortunately. You’re welcome to contact me again if you’ve any further questions about this trick.
Hope this helps you out.
Henry
From: ywr...@googlegroups.com [mailto:ywr...@googlegroups.com] On Behalf Of Jennie Dorny
Sent: Thursday, 28 November 2013 8:10 AM
To: ywr...@googlegroups.com
Subject: Re: [yWriter] Re: Timeline Tool
This is interesting, thanks.
--
You received this message because you are subscribed to the Google Groups "yWriter" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ywriter+u...@googlegroups.com.
To post to this group, send email to ywr...@googlegroups.com.
Visit this group at http://groups.google.com/group/ywriter.
For more options, visit https://groups.google.com/groups/opt_out.