Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Q&A

Post History

50%
+0 −0
Q&A How to keep track of characters' location, within a longer narrative?

I use Excel. You do have to keep track of your own material — nothing will do it for you — but a basic spreadsheet with columns of Chapter, Scene, Location, Day of Week, Time of Day, and maybe Ch...

posted 6y ago by Lauren Ipsum‭  ·  last activity 4y ago by System‭

Answer
#4: Attribution notice removed by user avatar System‭ · 2019-12-13T12:00:45Z (over 4 years ago)
Source: https://writers.stackexchange.com/a/29937
License name: CC BY-SA 3.0
License URL: https://creativecommons.org/licenses/by-sa/3.0/
#3: Attribution notice added by user avatar System‭ · 2019-12-08T06:56:57Z (over 4 years ago)
Source: https://writers.stackexchange.com/a/29937
License name: CC BY-SA 3.0
License URL: https://creativecommons.org/licenses/by-sa/3.0/
#2: Initial revision by (deleted user) · 2019-12-08T06:56:57Z (over 4 years ago)
I use Excel.

You do have to keep track of your own material — nothing will do it for you —&nbsp;but a basic spreadsheet with columns of Chapter, Scene, Location, Day of Week, Time of Day, and maybe Characters will do wonders for keeping you organized.

My answer to [Is there any good time-line software out there?](https://writers.stackexchange.com/questions/2082/is-there-any-good-time-line-software-out-there/2085#2085) is similar enough to useful, but it's not identical, so I'll adapt that idea here:

`Ch4|Sc16|The docks|Wed|03:12|Tony`  
`Ch4|Sc17|The docks|Wed|04:17|Sasha and Bear`  
`Ch4|Sc18|in front of Sasha's house|Wed|12:30ish|Alex, David, Elliot`  
`Ch4|Sc19|FLASHBACK Sasha's house|N/A, First Day of School|Morning|Sasha, Alex, Bear, Mom`  
`Ch4|Sc20|Sasha's house|Wed|afternoon|Sasha,Alex, David, Elliot`

Some notes: for times, you can use vague terms like "12:30ish" and "afternoon" or "morning." It doesn't have to be precise if your narrative doesn't require it.

If you have people in multiple cities at the same time, you will need columns for each city so you can keep track of the time difference. This is _very_ important if your story has modern technology (the phone or greater) so that if Person A is in Berlin and Person B is in Hong Kong, they're aware of who might be waking up whom and so on.

I added in a FLASHBACK note, so that it's clear that while the action of the scene is taking place 20 years back, it's not occurring in the "present" of the narrative.

If Sasha leaves the docks, at the end of the scene, add that in your last column. "Sasha and Bear talk, then argue. Sasha leaves." Maybe you have a row in between saying "_Sasha en route home_" or something.

The upshot is that keeping notes in a row-by-column condensed format can be very useful in shorthand terms of figuring out where and when everyone is.

#1: Imported from external source by user avatar System‭ · 2017-08-27T13:32:30Z (over 6 years ago)
Original score: 6