204.97 204.16 203.37 201 199.43 195.6 193.34 188.21 185.35 179.15 175.82 168.81 165.16 157.65 153.84 146.16 142.35 134.84 131.19 124.18 120.85 114.65 111.79 106.66 104.4 100.57 99 96.63 95.84 95.03
Springiness Speed
0.6 4
FALSE START CLOCK
Click the 'Start Clock' button to make the clock active. The clock will react to the mouse being moved across the yellow area You can adjust the settings for Springiness - How quickly the clock reforms after the mouse has caused it to move. Speed - How fast the date dial rotates.
The clock and animation is handled by an xy scatter chart. The vba code simply updates all the points for date dial, clock face and hands. The mouse events are trapped using a label control that is positioned over the chart. The label has been made transparent.
Clockface 3 4 5 6 7 8 9 10 11 12 1 2
190 184.64 170 150 130 115.36 110 115.36 130 150 170 184.64
Second hand 150 150 150 150 150 150 150 150
Minute hand 124.02 128.35 132.68 137.01 141.34 145.67
Hour hand 166.38 162.29 158.19 154.1
Date dial 150 170 184.64 190 184.64 170 150 130 115.36 110 115.36 130
190 185 180 175 170 165 160 155
135 137.5 140 142.5 145 147.5
138.53 141.4 144.26 147.13
S A T U R D A Y
2 3
N O V E M B E R
2 0 0 2
101.44 107.87 116.14 125.89 136.69 148.08 159.55 170.6 180.76 189.56 196.64 201.68 204.46 204.87 202.87 198.56 192.13 183.86 174.11 163.31 151.92 140.45 129.4 119.24 110.44 103.36 98.32 95.54 95.13 97.13
124.18 114.65 106.66 100.57 96.63 95.03 95.84 99 104.4 111.79 120.85 131.19 142.35 153.84 165.16 175.82 185.35 193.34 199.43 203.37 204.97 204.16 201 195.6 188.21 179.15 168.81 157.65 146.16 134.84
0
47.63
55
27.5
47.63 27.5
0
0
-27.5 -47.63
-27.5 -55
-47.63
The clocks are displayed using a xy scatter chart. There is a line series for each hand and the numbers. The first clock has a second hand. The second clock has an extra data series to hold a picture of the clock face The vba code just updates the sheet which will cause the cells to update. The xy positions are done using formula within the cells
chart.
0 30 60 90 120 150 180 210 240 270 300 330
55 3 2 1 12 11 10 9 8 7 6 5 4
0 55 47.63 27.5 0 -27.5 -47.63 -55 -47.63 -27.5 0 27.5 47.63
0 0 27.5 47.63 55 47.63 27.5 0 -27.5 -47.63 -55 -47.63 -27.5
-126
45
0 -26.45
0 -36.41
-222
35
0 -26.01
0 23.42
-56
30
0 16.78
0 -24.87
numbers.
ond clock has an extra e
will cause the cells to
hin the cells
FALSE START CLOCK
70 0 6 12 18 24 30 36 42 48 54 60 66 72 78 84 90 96 102 108 114 120 126 132 138 144 150 156 162 168 174 180 186 192 198 204 210 216 222 228 234 240 246 252 258 264 270 276 282 288 294 300
0 70 69.62 68.47 66.57 63.95 60.62 56.63 52.02 46.84 41.14 35 28.47 21.63 14.55 7.32 0 -7.32 -14.55 -21.63 -28.47 -35 -41.14 -46.84 -52.02 -56.63 -60.62 -63.95 -66.57 -68.47 -69.62 -70 -69.62 -68.47 -66.57 -63.95 -60.62 -56.63 -52.02 -46.84 -41.14 -35 -28.47 -21.63 -14.55 -7.32 0 7.32 14.55 21.63 28.47 35
0 0 7.32 14.55 21.63 28.47 35 41.14 46.84 52.02 56.63 60.62 63.95 66.57 68.47 69.62 70 69.62 68.47 66.57 63.95 60.62 56.63 52.02 46.84 41.14 35 28.47 21.63 14.55 7.32 0 -7.32 -14.55 -21.63 -28.47 -35 -41.14 -46.84 -52.02 -56.63 -60.62 -63.95 -66.57 -68.47 -69.62 -70 -69.62 -68.47 -66.57 -63.95 -60.62
306 312 318 324 330 336 342 348 354 360
41.14 46.84 52.02 56.63 60.62 63.95 66.57 68.47 69.62 70
-56.63 -52.02 -46.84 -41.14 -35 -28.47 -21.63 -14.55 -7.32 0
3
2
FALSE START CLOCK 235680 235680 134567890 134567890 12347890 12347890 2357890 2357890 The clock is displayed using a xy scatter chart.
456890 456890
There is a line series for each digit in its lit and unlit state. The vba code updates the time values The lines xy positions are done using formula within the cells
2680 2680 2345689 2345689
1
3
5
1
-100 -100
1 1
-100 -100
1 1
4.1 5.9
1 1
7.1 8.9
1 1
-100 -100
1 1
-100 -100
1.1 2.1
3 3
1.1 2.1
6 6
1.1 2.1
9 9
1.1 2.1
12 12
1.1 2.1
-100 -100
2.4 3.4
3 3
2.4 3.4
6 6
2.4 3.4
-100 -100
2.4 3.4
12 12
2.4 3.4
-100 -100
3.5 3.5
-100 -100
3.5 3.5
5.9 4.1
3.5 3.5
8.9 7.1
3.5 3.5
-100 -100
3.5 3.5
-100 -100
3.4 2.4
-100 -100
3.4 2.4
-100 -100
3.4 2.4
7 7
3.4 2.4
-100 -100
3.4 2.4
-100 -100
2.1 1.1
-100 -100
2.1 1.1
-100 -100
2.1 1.1
-100 -100
2.1 1.1
-100 -100
2.1 1.1
-100 -100
2.25 2.25
-100 -100
2.25 2.25
4.1 5.9
2.25 2.25
7.1 8.9
2.25 2.25
-100 -100
2.25 2.25
6.55 6.55 12.55 12.55
1.7 2.7 1.7 2.7
1.1 2.9
1 1
4.1 5.9
1 1
7.1 8.9
1 1
10.1 11.9
1 1
3 3
1.1 2
6 6
1.1 2
9 9
1.1 2
12 12
1.1 2
3 3
2.5 3.4
6 6
2.5 3.4
9 9
2.5 3.4
12 12
2.5 3.4
2.9 1.1
3.5 3.5
5.9 4.1
3.5 3.5
8.9 7.1
3.5 3.5
11.9 10.1
3.5 3.5
1 1
3.4 2.5
4 4
3.4 2.5
7 7
3.4 2.5
10 10
3.4 2.5
1 1
2 1.1
4 4
2 1.1
7 7
2 1.1
10 10
2 1.1
1.1 2.9
2.25 2.25
4.1 5.9
2.25 2.25
7.1 8.9
2.25 2.25
10.1 11.9
2.25 2.25
1
7
-100 -100
1 1
-100 -100
1 1
15 15
1.1 2.1
18 18
1.1 2.1
15 15
2.4 3.4
18 18
2.4 3.4
-100 -100
3.5 3.5
17.9 16.1
3.5 3.5
-100 -100
3.4 2.4
-100 -100
3.4 2.4
-100 -100
2.1 1.1
-100 -100
2.1 1.1
-100 -100
2.25 2.25
-100 -100
2.25 2.25
13.1 14.9
1 1
16.1 17.9
1 1
15 15
1.1 2
18 18
1.1 2
15 15
2.5 3.4
18 18
2.5 3.4
14.9 13.1
3.5 3.5
17.9 16.1
3.5 3.5
13 13
3.4 2.5
16 16
3.4 2.5
13 13
2 1.1
16 16
2 1.1
13.1 14.9
2.25 2.25
16.1 17.9
2.25 2.25