A B C D E F G H I J K L M N    
2
3 Building a Timebase Example
4
5 n  Uses DpM
6
7 We recommend:
8 1 Put your timebase on a separate sheet named 'GLOBALS' or similar.
9 You don't have to do this but for larger models its good practise.
10 For smaller models you don't need to do this.
11
12 2 Decide whether your timebase is going vertically or horizontally.
13 Generally, if there are 15 or less periods, most people would go
14 horizontally.  More than 30 and you are probably better off going
15 vertically.
16
17 3 Put the Base value in a cell, and name it something like 'Base'.
18
19 4 Put the StartDate in the first cell of yuor timebase.
20
21 5 Use the DpM function to increment the dates in the timebase.
22
23 6 Example:
24  
25 Base:   3 months  
26  
27 TimeBase:  1 Jan 02  
28    1 Apr 02  
29    1 Jul 02  
30    1 Oct 02  
31    1 Jan 03  
32    1 Apr 03  
33    1 Jul 03  
34    1 Oct 03  
35    1 Jan 04  
36    1 Apr 04  
37    1 Jul 04  
38    1 Oct 04  
39    1 Jan 05  
40    1 Apr 05  
41    1 Jul 05       
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