Originally posted by FrankO
View Post
Nice. There are all sorts of variations, and I can see your reasoning with regards to the Direction of PC Smith's patrol. I think it's always a good idea to cover as many variations as possible since we can't know for sure which is the right one, if it turns out that regardless of version certain ideas remain viable, while others are more dependant upon the version chosen, then we at least can start to assess relative probabilities.
I've made some updates to the timetable calculator excel book. Hopefully that link works. I'm not sure how clear my notes are to others, but basically you can now work both forwards and backwards in time. Also, while in the previous book you had to do everything "in order", you can now tell it to do a calculation from a specific point, and not just from the previous time in the row above. (Yah, I'm sure that's clear as mud). Hopefully it makes more sense by looking at the information I've left in it as an example.
Anyway, on the Table page, it creates 2 tables. The one on the left shows the information in the order you did things on the WorkArea page. The one on the right should order things chronologically.
I think it's fairly versatile and reasonably flexible and may be of interest to some. It may turn out that I should have made the workspace bigger (more rows) as some timelines can get pretty complicated. That remains to be seen.
- Jeff
Leave a comment: