The March of Time - Sime 4 l Decades Challenge Tracking

	B	C	D	E	F
1
2	To use this template, go to File > Make a Copy and save this Sheet to your own Google drive.
3
4	PLEASE NOTE: I will NOT be giving out editing access if you request it. This is my master copy.
5	You must make a copy of this spreadsheet and save it to your drive before you can edit it.
6
7	Thank you CuteCoffeeGirl for making the original tracking sheet!
8	I've edited this version to work with my extended Decades Challenge, The March Of Time.
9
10	Set-Up Steps:
11
12	o	It is VERY important that you only edit cells that are this teal blue color.
13		There are a lot of formulas that power this calculator, so editing anything but the teal cells may break the calculator. This includes adding/deleting rows and columns.
14
15	o	When entering dates into the teal cells, you MUST enter them exactly as I format them - the calculator is looking for an exact match to pull up the corresponding data. For example, the green text below will work; the red text will not.
16
17
18			Format: Early/Late Year
19			Late 1892
20			Early 1915
21			late 1900 (capitalize the L)
22			Early 84 (must include full year)
23			1932 (must include Early or Late)
24
25	o	On Day 1 of your Decades Challenge, note the in-game day of the week. Make sure the correct day of the week is listed for Day 1 on the Timelines tab. The default starting date for new saves is Sunday.
26
27	o	While almost every Sim in your Decades Challenge will have a Birthdate of 1850 or later, there is an exception to this at the very beginning of the game. Your initial starting Sim(s) are NOT born in 1850, but sometime before that, depending on which lifestage you're starting them at. In order for the calculator to work correctly, you must use one of the following birthdates for each of your starting Sims.
28
29				Normal Tracking	University Tracking
30			Starting as a Young Adult	Late 1832	Early Winter 1875
31			Starting as an Adult	Late 1819	Early Spring 1866
32			Starting as an Elder	Late 1801	Early Fall 1852
33
34	o	On the Age Tracking tab, Row 3 is included as a template row. When a new Sim is added to the family, copy this row and paste it at the bottom of your sheet to add the new Sim. All you need to do is enter the new Sim's name and birthdate and the formulas will take care of the rest. You can also completely delete a row if a Sim leaves the family and you no longer want to see their dates. Lifestages are colored to make the Sheet more readable.
35
36	You can safely delete this Instructions tab if you'd like.
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100