h a l f b a k e r yThe leaning tower of Piezo
add, search, annotate, link, view, overview, recent, by name, random
news, help, about, links, report a problem
browse anonymously,
or get an account
and write.
register,
|
|
|
Please log in.
Before you can vote, you need to register.
Please log in or create an account.
|
When you open a huge Excel spreadsheet that someone has given you, don't you feel overwhelmed? It's difficult to know where to start. The first few minutes are usually wasted flipping between the tabs, scrolling ridiculously far down or to the right (just in case the creator hid some data out there),
failing to notice subtly important column labels, etc. etc.
It would be useful if arrows appeared as you scrolled around, prompting you " --> More data this way -->" or "lookup table below" and the like. Once you activate "Tour Mode", the signs would appear and you'd use the MOUSE to scroll and follow the street signs. (faster than manual keyboarding). The screen would shift right or left or down or up or diagonally to accommodate your wanderings.
For this to work, the creator of the spreadsheet would need to specify a kind of "browsing order" for the spreadsheet, but this could be done with a few mouse clicks (possibly with tour comments added at each location). The hotspot list would be saved with the file.
This is much easier for a user to follow (and for a creator to write) than verbal directions such as "the accumulation data is in cells $C$147 to cell $E$159 on the "Data With Accumulations" tab. That is too verbose, redundant with what's readily visible on the screen, and doesn't communicate the structure the way a visual "guided tour" approach, facilitated by the spreadsheet application itself, would.
Thank you.
[link]
|
|
The author of a very big and very detailed spreadsheet should make a summary summary page so that you can get right to what is important. And because Excel lets you link the cells, your summary page automatically updates with the changes that you make on the sheet. |
|
|
Well named worksheet tabs go a very long way towards providing a self documented model. |
|
|
[phundug], maybe a modified "comment". Now they act as post-it notes, but I think they only pop up when the mouse is over them. |
|
|
If cetain comments could be toggled between visible/unvisible, then the text in the comment could be used for tour mode. Also a sort of hyperlink system could be used to go to named fields (where there is a futher comment). |
|
|
So I suppose it's like a hyperlink system with comment pop-ups. |
|
|
I think you must have put the cd in upside down. |
|
|
Instead of an arrow, there could be a little Clippy type character, or a Banzai buddy. It would say "This looks interesting!" "Looky Looky! Data!" "Have you noticed this?" "It looks like you are confused. Can I help?". Different icons might be available, and the computer would decide which you get: Clippy, Puppy, Buddha, Pornstar, Rambo, Wart, Monolith, etc. |
|
|
As regards [zen-tom], I think you should give the australian quiry exhibitionists another chance. For their artistic merit, of course. |
|
| |