NZ518198A - Data displaying method for multiple layered screens using screen designation codes - Google Patents

Abstract

A method for creating a visual effect in the display of software wherein the software is for the manipulation of data; comprises: 1) assigning a particular screen designation code to a first group of data; 2) assigning other screen designation codes to second and other groups of data as desired; The screen designation code determines which physical screen the group of data is displayed simultaneously in a multi- level screen display. The method is suitable for spreadsheet software, where a user is able to see overlaying spreadsheets simultaneously.

Description

518198 WO 01/15128 PCT/NZOO/OOl 62 DATA DISPLAY FOR ML LTIPLE LAYERED SCREENS Technical Field This invention relates to data display. background art Reference throughout this specification shall be made to use of the present invention in relation to the display of data in spreadsheets. However, it should be appreciated that aspects of the present invention can be used in relation to displaying data presented in other formats, perhaps graphically or in some other format for displaying in particular relational data.

There are a number of spreadsheet programs, one of the more prolific being Microsoft Excel™. These spreadsheet programs have a number of cells in rows and columns into which data can be input. Often the cells within the spreadsheet are related to each other.

For example, there may be a cell that displays a number which is calculated from the 15 numbers represented in other cells in the spreadsheet. For instance, this particular cell may represent the total of a column of numbers. Any change to the numbers in that column will also be reflected in that cell representing the total.

This system works well when all of the data required to be reviewed can fit onto one computer screen display. However, often the user of the software creates spreadsheets 20 which have more data entered into them than can be shown on one screen display at a time.

To accommodate this need, spreadsheet software often includes a facility akin to an old-fashioned system of having separate sheets of paper or cards except this is 1 WO 01/15128 PCT/NZ00/00162 displayed on the computer, accessed by a virtual tab. For example, the screen may show one set of data. By clicking on a tab, a second set of data is then displayed on the screen with the first set of data being hidden by the second.

Unfortunately, this is still unsatisfactory. This is because the screen does not show all 5 of the data that the user may wish to see. While the user can choose which spreadsheet to view, the user cannot see the effect that changing a cell on one spreadsheet has on another cell on the other spreadsheet.

Another problem is that it can take some time for a user to locate a particular cell. Not only is this another attempt to address the situation has been the ability to include 10 multiple files on a screen which may be cross-linked in terms of having relational data. Thus, it is possible for the user to alter data on one part of the screen in relation to one file and see its effect on another part of the screen in relation to another file.

Unfortunately, these attempts are still unsatisfactory. One problem with this system is that although there may be inter-relational data, there is no physical feel of the 15 relationship between the cells.

For example, on each spreadsheet there may be cells relating to similar data in the same columns and rows for each spreadsheet. However, positioning the spreadsheets beside each other on the screen does not provide an intuitive feel of the relationship of the cells to each other.

Another problem that occurs is that often the single cell has two lots of data assigned to it. One data element is the actual number and the other data element is the formula or relationship equation which generates that number. In traditional spreadsheet programs, the formula is usually only displayed when that particular cell is selected. Therefore, the formula for a number of related cells cannot be displayed at the same 25 time. This is understandably frustrating, particularly when a person is desirous of 2 WO 01/15128 PCT/NZOO/OOl 62 quickly viewing and assessing the relationship between a number of cells to each other.

It is an object of the present invention to address the foregoing problems or at least to provide the public with a useful choice.

Further aspects and advantages of the present invention will become apparent from the 5 ensuing description which is given by way of example only.

Disclosure of Invention According to one aspect of the present invention there is provided a method for creating a visual effect in the display of software wherein the software is for the manipulation of data, the method characterised by the steps of a) assigning a particular screen designation code to a first group of data, and b) assigning other screen designation codes to second and other groups of data as desired, wherein the screen designation code determines which physical screen the group of 15 data is displayed in a multi-level screen display.

As stated previously, the software in preferred embodiments is spreadsheet software, although it should be appreciated that the principles of the present invention can apply to other types of software, particularly those which relate to the display of data, such as databases, graphical analysis and so forth.

The term second and other group of data may cover such items as formula, relational information, highlights, error messages, hints and so forth which can be associated with the first group of data. 3 wu PCT/NZOO/OO162 The screen designation code is merely a code that identifies which physical screen the image or software component is displayed upon.

The inventors of the present invention also invented a multi-level screen display and this is described in detail in PCT Application Nos. PCT/N"Z98/00098 and 5 PCT /NZ99/00021.

This is a device which is created by combining multiple layers of selectively transparent screens. Each screen is capable of showing an image. In preferred embodiments, the screen layers are liquid crystal displays. Preferably the screens are aligned parallel to each other with a preset distance between them.

With this invention, images displayed on the screen furtherest from the view (background screen), will appear at some depth behind the images displayed on the screen closest to the viewer (foreground screen). The transparent portions on the foreground screen will allow viewers to see images displayed on the background screen.

This arrangement of layering multiple screens allows images to be presented at multiple levels giving the viewer true depth without use of glass or lens.

The present invention will now refer to use with a multi-level screen as described above although this should not be seen as limiting.

The group of data is in preferred embodiments a spreadsheet such as that normally 20 viewed in a spreadsheet program, however this should not be seen as limiting.

It should be appreciated that although reference shall be made throughout this specification now to only background and foreground screens, other aspects of the present invention may utilise more than two screens. For example, various spreadsheets may be on the multiple screens behind the foreground screen. 4 WO 01/15128 PCT/NZ00/00162 A group of data may be that information displayed when a particular tab is selected on the screen. Therefore, that group of data or spreadsheet is displayed on one of the physical screens.

The group of data or spreadsheet that can be viewed by selecting another tab may be 5 displayed on another physical screen. Alternatively, if there are two separate spreadsheet programs, these can be imported to an embodiment of the present invention and have separate spreadsheets from the separate files shown on the separate screens with one spreadsheet overlaying another, but with the ability to see both.

One embodiment of the present invention will be an interface that identifies the coding 10 on existing software with these identifiers and assign various data groups to the appropriate foreground or background screen.

The 'always on top' functions can be made fully or partially transparent by the present invention.

In one embodiment of the present invention, one screen may have a highlight for a 15 particular cell or group of cells positioned either in front of or behind that highlight. In a variation of this embodiment, the highlights of a number of cells may be colour coded with the codes corresponding to a particular relationship to cells of a certain type.

In another embodiment of the present invention, one group of data on one screen may 20 be the actual values within the cells and the other group or groups of data on the other screens may be the coding or formulas or relational information that actually creates the value shown on the other screen.

In some embodiments, the groups of data may all belong to the same large spreadsheet and the second and consequent screens may merely show the wrap-around of that 25 spreadsheet.

WO 01/15128 PCT/NZ00/00162 In other embodiments, it may be provided in cells a hyperlink that can take the user of the spreadsheet to other cells or other screens.

Sometimes, the present invention may be useful in error tracking. For example, a mistake in the relational formula between the cells or the data entered may lead to an 5 error. The ability to see a number of cells at once can assist in tracking down where the error occurred or what cells are affected by the error.

In one aspect of the present invention there may be provided the ability to scroll through values on one cell or set of cells on a screen while still being able to view another set of cells on another screen. This is particularly useful where it is desired to 10 be able to search for information or data on various areas of the spreadsheet or database while not disturbing the actual region of the spreadsheet or database that the user is working on.

The scrolling or rotation of data on various cells may be achieved in some instances by the use of a track ball or some other user interface.

In yet another embodiment one of the screens may display tips or hints associated with the cells being displayed on the other screen.

The interface may be a patch for existing software, a library file or a new front end for multiple existing software packages or a completely new operating system.

With existing software that does not have such coding, it may be necessary to 20 implement the present invention by having customised software in which the software developer specifies the software routines which cause the appropriate components and images to go on the appropriate screens.

A further aspect of the present invention is the provision of media on to which instructions in accordance with the present invention has been recorded. For example. 6 WO 01/15128 PCT/NZ00/00162 this media may be a graphics card, CD, hard drive, floppy disk and so forth.

The advantages of the preseht Invention can now be readily seen.

Because of the physical separation between the screens, the viewer can easily see data on the front scteeh and oh the rear screen as required. Thus, the user can see 6 significantly more data than previously viewable with standard software df standard screens. Indeed the dhiount of data that the user can see Is a multiple proportional to the number of screens in the ttlUltl-level Screen display.

The viewer can instantly see on which screen holds the cell or data that is relevant to it find select this.

The user can also see at a glance the relational nature of the data on the screens. For example, a change on one screen may cause corresponding change on the other screen overlaying it. This gives an instant appreciation of the effect of a change.

Hi some embodiments of the present invention the cells which change as a consequence of altering data may be colour coded. This allows the user to more 16 quickly identify where that change has occurred on multiple screens.

Some embodiments may have different shading to make it clear as to which screen the group of data is on, or to indicate which data is grouped together. The overall screens may also be shaded/coloured to give visual clarity.

The present invention also allows the user to easily access a desired cell. Not only is 20 this more desirable for the user in terms of mental satisfaction, but this also is significant in terms of physical relief. A problem that frequent computer users have is occupational overuse syndrome (oos) which is the repeated use of muscles, particularly when typing or using a mouse. Easier access means that the mouse is used less in order to find a particular cell and thus a potentially unpleasant medical condition is 7 PCT/NZOO/00162 avoided.

In some embodiments of the present invention some cells are presented as 3-dimensional blocks which can be selected, moved or removed like blocks in a wall to reveal data on other screens.

It can be appreciated that the present invention overall literally provides an added dimension to the ability of a user to work with data manipulation programs such as spreadsheets and databases. There is considerably more flexibility and also a reduction in the time and effort required by the user to see the relationship between groups of data to each other.

Aspects of the present invention may extend to other standard functions on a spreadsheet program.

For example, spreadsheet programs often come with the ability to present the data graphically. Thus, for multi-relational data sheets, the present invention can also be used to produce 3-dimensional graphs showing the data on x, y and z axes as required.

Brief Description of Drawings Further aspects of the present invention will become apparent from the following description which is given by way of example only and with reference to the accompanying drawings in which: Figure 1 illustrates a screen display of a prior art spreadsheet software, and Figure 2 illustrates another prior art screen display, and Figure 3 is a concept drawing showing the 3-dimensional nature of the present invention. 8 Best Modes for Carrying out the Invention Figure 1 is a screen display from a Microsoft Excel™ program. This illustrates a group of data on a spreadsheet generally indicated by arrow I on the screen. The associated tab (2) indicates that the data we are looking at relates to "FBT Calc -5 Lease".

The screen also shows that there is a second group of data (not shown) and positioned visually under the first group of data. The indicator that there is a second group of data is the tab (3) which reads "FBT Calc - Lease to Own".

To view the second group of data, it is necessary to select the tab (3). However, in 10 doing so the first group of data is obscured by the second group of data. Thus, the effect of a change on one group of data is not immediately discernable as the user cannot see the other group of data.

It can also be seen that it can be difficult for the user to select a particular cell given that half of the data is obscured at any one time.

It should also be appreciated that spreadsheet programs of this type have the ability to have multiple tabs, not just the two shown.

Figure 2 illustrates a screen display whereby two separate files have been imported into the one screen display and are positioned side by side. This enables the user to change data on file and view its corresponding effect on the other file.

However, because the files are side by side, this is not intuitive with there being no real physical relationship between cells having the same common row and column. Further, the screen size is still limited and only a certain amount of data can be fitted onto the screen. 9 WO 01/15128 PCT/NZOO/OOl 62 The present invention provides for the separate groups of data (whether from separate files of merely separate spreadsheets to be displayed on separate physical screens aligned with each other.

Figure 3 shows an example of a multi-level spreadsheet using only 2 layers. 5 Information can be stored on both layers. The layout of the cells can be used to enhance user information by positioning related cells close to or behind one another so as to improve the visual feedback to the user speeding up the development time and improving error detection. The positioning of the cells can also be used to increase the information available on a given cell as illustrated by the text and numbering choscn 10 for figure 3. The front screen is ready to receive the monthly information such as income generated or expenses incurred while the back screen provides the user with immediate information about the day on which the income was generated or expense total incurred, thus reducing the need to look away from the cell to gain this information.

A greater number of layers of course can be used.

The 3-dimensional spreadsheet enables the user to see far greater quantities of data in the one visual display than before.

It also enables the user to quickly select a desired cell. Further, the relational nature of the data to each other can be intuitively perceived.

Aspects of the present invention have been described by way of example only and it should be appreciated that modifications and additions may be made thereto without departing from the scope of the appended claims.

Claims (6)

CLAIMS:

1. A method for creating a visual effect in the display of software wherein the software is for the manipulation of data; characterised by the steps of (a) Assigning a particular screen designation code to a first group of data; and (b) Assigning other screen designation codes to second and other groups of data as desired, wherein the screen designation code determines which physical screen the group of data is displayed simultaneously in a multi-level screen display.

2. A method as claimed in claim 1 wherein the software is spreadsheet software.

3. A method as claimed in either claim 1 or claim 2 wherein the groups of data correspond to a particular tab selected on the screen.

4. A method as claimed in any one of claims 1 to 3 wherein one of the groups of is formula corresponding to values in the cells in another group of data.

5. A method as claimed in any one of claims 1 to 4 wherein the second or other groups of data is a wrap around or continuation of a page or spreadsheet partially shown in the first group of data.

6. A method as claimed in any one of claims 1 to 5 wherein the second or other groups of data contains highlights or colour coding corresponding to the first group of data. IPONZ u 23 JUL 2003 A method as claimed in any one of claims 1 to 6 wherein the second or other groups of data includes hyperlinks from one part of the display to another part. A method as claimed in any one of claims 1 to 7 wherein the second or other groups of data numerical and/or graphical data includes error messages. A method as claimed in any one of claims 1 to 8 wherein the second or other groups of data have the ability in at least parts of them to enable the user to scroll through information on a particular screen. A method as claimed in any one of claims 1 to 9 wherein the second or other groups of data contains tips or useful information pertaining to the first group of data. Media which carries instructions for the operation of the methods substantially claimed in any of claims 1 to 10 or claim 12. A method substantially as herein described with reference to and as illustrated by the accompanying drawings. 12 IPONZ 23 JUL 2003