This is the fourth part of a series of tutorials explaining how to create a realistic clock in MS Excel using free form sprites. The sprites are created in PowerPoint and imported in Excel as images. This part (part #4) deals with planning the clock face layout.
The clock face is being created in PowerPoint out of MS objects (grouped collection of shapes). These objects are the digits (the clock box or body, two digits for hours + two digits for minutes + two digits for seconds, the weekday sprites and the AM/PM label). After the layout is created, it will be imported in Excel, where a “analyze/record” VBA subroutine will be written.
This subroutine will record the sizes of all the objects imported and the relative position (x,y) of the objects with respect to the box. Another initialization subroutine will be written which can any time recreate the clock in Excel, using the data obtained by the first subroutine. This action (in case that the clock was altered accidentally while in use) will restore the clock at the initial parameters. Also, having all this data in place, will allow to scale this clock model up and down dimensionally (i.e. make it smaller or larger depending of the user’s needs).