Clocks

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Clocks as PDF for free.

More details

  • Words: 1,091
  • Pages: 12
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

Related Documents

Clocks
April 2020 21
Clocks
November 2019 23
Jkj Clocks
November 2019 26
Coldplay - Clocks
November 2019 13
Amazing Clocks
December 2019 15
Classroom Clocks
May 2020 6