To try and answer the OP - I have recently moved my Actions, Project List, Areas Of Focus, Horizon 3 Goals, Waiting For and Someday / Maybe into one monster Excel spreadsheet of Doom, from my previous paper setup.
Basically I have a set of tabs for the above, and I give each Project and AOF a number. When I add an NA, I add the project and AOF number in separate columns if they apply. Then I can filter / slice and dice however I like.
I can't say yet whether it is adding any real value to be honest. Prior to this I didn't bother linking my NA directly to a Project and nothing exploded. Although if I wanted to, I could have either written a short "tag" or numbered the projects and added the number to the NA. I put it into my Excel as it's super easy to do and I want to test it out and see if I find it useful in the longer term. I'm into year 2 of GTD, and just now feeling like I know the basics enough, and have gained enough mental bandwidth, to start stretching my metaphorical legs.
Basically I have a set of tabs for the above, and I give each Project and AOF a number. When I add an NA, I add the project and AOF number in separate columns if they apply. Then I can filter / slice and dice however I like.
I can't say yet whether it is adding any real value to be honest. Prior to this I didn't bother linking my NA directly to a Project and nothing exploded. Although if I wanted to, I could have either written a short "tag" or numbered the projects and added the number to the NA. I put it into my Excel as it's super easy to do and I want to test it out and see if I find it useful in the longer term. I'm into year 2 of GTD, and just now feeling like I know the basics enough, and have gained enough mental bandwidth, to start stretching my metaphorical legs.