I confess I only have the gist of Excel. I am seeking to build an interesting "clock" which may test your excel skills.
This clock would display geological time and I would be presenting it in PowerPoint slides concerning evolution.
It would consist of concentric circles. The idea is to develop a "universal" mental concept of time using this clock as a graphical image to "pin" your thoughts on. Whether your study is about a hundred years or a billion, the clock would be capable of represention.
The inner most circle would be measured in hundreds of years
The second circle would be measured in thousands of years
The third in hundreds of thousands of years
The fourth in millions of years
The fifth in billions of years
Instead of "hands" the clock would show pie sections (we would probably use pie charts)
Each slice would a definable colour.
Specific dates could be represented by lines.
Either a section, or a specific date, could be labelled. Examples: 541 million years beginning of the Cambrian Explosion. Pie Section 130,000 and 40,000 years ago
If possible, where a circle is not being used, the circle would be shrunk down and be represented by a thinner ring of the appropriate colour. This could probably be achieved by having several semi-duplicate similar clocks.
I envisage there would be some kind of grid, hidden from the public view, where data is easily entered according to needs and which is reflected in the charts.
This obviously required a high level of Excel skills. If your up for the challenge please pm me. I will of course help as much as I can.
Thank you.
Z
Bookmarks