Grid-based user interfaces often store content in rows and columns of cells. In general, cells in a row are related in some manner and/or cells in a column are also related in some manner. However, beyond simple relationships that are manifest by the row and/or column positioning of a cell, cells may have other relationships to cells that do not share the same row and/or the same column. Such relationships may not be perfectly linear as implied by the X-Y structure of a grid. Unfortunately, current grid-based user interfaces are not capable of establishing and displaying relationships between individual cells in a grid beyond basic row and/or column positioning of cells.
In general, example embodiments of the invention relate to user interfaces for displaying relationships between cells in a grid. At least some of the example user interfaces disclosed herein enable relationships between individual cells in a grid to be established and displayed, upon selection of one of the related cells, in the user interface. These embodiments enable nonlinear relationships to be displayed outside of the normal parameters of the contiguous X-Y structure of the grid.
In one example embodiment, a user interface includes a grid including rows and columns and a plurality of cells each having a specific position in the grid. A first one of the cells is related to a second one of the cells. The grid is configured to display, upon selection of the first cell or second cell, a visual representation of the relationship between the first cell and the second cell.
In another example embodiment, a user interface includes a grid including rows and columns, a viewport that displays only a portion of the grid, and a plurality of cells each having a specific position in the grid. A first one of the cells is related to a second one of the cells that is positioned in a different row and/or a different column from the first cell. The viewport is configured to display, upon selection of the first or second cell, a visual representation of the relationship in the viewport between the first cell and the second cell.
In yet another example embodiment, a user interface includes a grid including rows and columns, a viewport that displays only a portion of the grid, and a plurality of cells each having a specific position in the grid. A first one of the cells is related to a second one of the cells that is positioned in a different row and/or a different column from the first cell such that the first cell and the second cell are not capable of being displayed in the viewport at the same time. The viewport is configured to display, upon selection of the first cell displayed in the viewport, a visual representation in the viewport of the relationship between the first cell and the second cell.
This Summary is provided to introduce a selection of concepts in a simplified form that are further described below in the Detailed Description. This Summary is not intended to identify key features or essential characteristics of the claimed subject matter, nor is it intended to be used as an aid in determining the scope of the claimed subject matter.
Additional features will be set forth in the description which follows or may be learned by the practice of the teachings herein. Features of the invention may be realized and obtained by means of the instruments and combinations particularly pointed out in the appended claims. Features of the present invention will become more fully apparent from the following description and appended claims, or may be learned by the practice of the invention as set forth hereinafter.
To further clarify certain aspects of the present invention, a more particular description of the invention will be rendered by reference to example embodiments thereof which are disclosed in the appended drawings. It is to be understood that the drawings are diagrammatic and schematic representations of such example embodiments, and are not limiting of the present invention, nor are they necessarily drawn to scale. Aspects of the invention will be described and explained with additional specificity and detail through the use of the accompanying drawings in which:
Example embodiments of the present invention relate to user interfaces for displaying relationships between cells in a grid. At least some of the example user interfaces disclosed herein enable relationships between individual cells in a grid to be established and displayed, upon selection of one of the related cells, in the user interface. These embodiments enable nonlinear relationships to be displayed outside of the normal parameters of the contiguous X-Y structure of the grid.
As used herein, the term “grid” is not limited to a grid made up of rectangular cells organized into X-Y rows and columns. Therefore, although the grids of the example user interfaces disclosed herein are generally grids made up of rectangular cells organized into X-Y rows and columns, it is understood that the term “grid” can also encompass a grid with non-rectangular cells, such as a spherical grid, and/or a grid that does not have linear vertical and horizontal X-Y rows and columns, such as diagonal or curved rows and columns.
The user interface 200 also includes a viewport 208, a viewtracker 210, a search box 212, a target box 214, and a user options selector 216.
Since the grid 202 is too large to be displayed all at once, the viewport 208 displays only a portion of the grid 202. The user interface 200 enables a user to reposition the grid 202 within the viewport 208 to allow the user to navigate to any portion of the grid 202. This repositioning may be accomplished, for example, by dragging the grid using a mouse pointer on a non-touch display or using a finger on a touch display.
The viewtracker 210 includes a grid representation 218 of the grid 202 and a viewport representation 220 of the viewport 208. The viewport representation 220 is positioned within the grid representation 218 and overlays the grid representation 218. The viewport representation 220 visually conveys both the proportion of the grid 202 currently displayed in the viewport 208 as well as the position within the grid 202 of the portion of the grid 202 displayed in the viewport 208, thereby helping the user visualize where the user is in terms of either additional or total content to be viewed or progress along the progression of the grid 202. During scrolling within the viewport 208, the viewport representation 220 may also convey the rate of travel through the grid 202.
The search box 212 allows a user to search for a specific cell or a specific cell content within the grid 202. The target box 214 displays the target of the grid. The target of the grid 202 may be, for example, an individual, a group of individuals, an animal, a computer program, a project, a company, a car model, a series of paintings, or anything to which a range or value or rating or score can be determined or assigned, for which a sense of status change or progress can be represented or tracked. In
Additional details about cluster cells, header rows, and header columns, viewports, viewtrackers, and search boxes are disclosed in U.S. patent application Ser. No. 13/271,882.
Each of the cells disclosed in the grid 202 of
A relationship between cells may have one or more aspects. An aspect of a relationship may include, but is not limited to, the relationship's type, degree, weight, magnitude, order, or sequence. A relationship type may be, for example, a human relationship (e.g., parent/child, sibling, child/parent, or spouse), an organizational relationship (e.g., employer/employee, investor/board, or parent corporation/subsidiary), a logical relationship (e.g., related “see also” content or prerequisite), a conceptual relationship (e.g., a broader concept in one cell and a narrower concept in another cell), or a semantic relationship (e.g., the meaning of words in one cell being semantically related to the meaning of words in another cell). Other relationship aspects are also possible, and the term “aspect” is not limited to these examples.
The relationships between cells may be established manually by a user or automatically by the user interface 200 and these relationships may be viewed as nodes along a “relational thread”. For example, the user interface 200 may be configured to allow a user to specify the relationship and one or more aspects of the relationship between two or more cells. This may be accomplished using an options display (not shown) that is accessed by selecting the user options selector 216 of the user interface 200. As used herein, the term “user” includes not only an end user of the user interface 200, but any other user, such as a content author or an interface administrator. Also, the user interface 200 may be configured to allow a user to create and define custom relationships between cells by using any of various methods, for example, using a provided drawing palette provided within the user interface 200 that includes pre-defined relational data objects and drawing tools that the user may assign to cell pairs or groupings of cells. Similarly, the user interface 200 may automatically establish relationships between cells by, for example, matching cell content or tracking user interaction patterns with cells.
The user interface 200 may also be configured to display a related-cells indicator when a cell has related cells. For example, where a cell in the grid 202 has a certain number of related cells, that number may be displayed in the cell inside a circle as disclosed in
It is understood that although the user interface 200 is disclosed in
Although lines are used in
In particular,
Further, in other example embodiments, the selection of a single cell can result in the display of a web of relationships between cells that are even indirectly related to the selected cell. In these example embodiments, the entire web of cell may be gathered into the viewport 208 and possibly reduced in size to allow all cells in the web to fit in the viewport 208.
It is understood that while the lines, pop-up windows, and gathered cells with lines are disclosed herein as three example forms of a visual representation of relationships between cells, various other forms of a visual representation of relationships between cells are also possible. Therefore, the phrase “a visual representation of a relationship between cells,” or variations thereof, is not limited to one of these three example forms.
The embodiments described herein may include the use of a special purpose or general purpose computer including, but not limited to, a cell phone, smartphone, smart appliance, automobile, navigation system, tablet computer, laptop computer, desktop computer, media player, and the like that is equipped with a display, including various computer hardware or software modules, as discussed in greater detail below.
Embodiments described herein may be implemented using computer-readable media for carrying or having computer-executable instructions or data structures stored thereon. Such computer-readable media may be any available media that may be accessed by a general purpose or special purpose computer. By way of example, and not limitation, such computer-readable media may include non-transitory computer-readable storage media including RAM, ROM, EEPROM, CD-ROM or other optical disk storage, magnetic disk storage or other magnetic storage devices, or any other storage medium which may be used to carry or store desired program code in the form of computer-executable instructions or data structures and which may be accessed by a general purpose or special purpose computer. Combinations of the above may also be included within the scope of computer-readable media.
Computer-executable instructions comprise, for example, instructions and data which cause a general purpose computer, special purpose computer, or special purpose processing device to perform a certain function or group of functions. Although the subject matter has been described in language specific to structural features and/or methodological steps, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the specific features or steps described above. Rather, the specific features and steps described above are disclosed as example forms of implementing the claims.
As used herein, the term “module” may refer to software objects or routines that execute on a computing system. The different modules described herein may be implemented as objects or processes that execute on a computing system (e.g., as separate threads). While the system and methods described herein are preferably implemented in software, implementations in hardware or a combination of software and hardware are also possible and contemplated.
All examples and conditional language recited herein are intended for pedagogical objects to aid the reader in understanding the example embodiments and the concepts contributed by the inventor to furthering the art, and are to be construed as being without limitation to such specifically-recited examples and conditions.
This application claims priority to and the benefit of U.S. Provisional Patent Application Ser. No. 61/661,633, titled “USER INTERFACES FOR NAVIGATING RELATIONAL STRUCTURED CONTENT AND SUMMATIVE DISPLAYS,” filed on Jun. 19, 2012, which is incorporated herein by reference in its entirety.
Number | Name | Date | Kind |
---|---|---|---|
4790028 | Ramage | Dec 1988 | A |
5075673 | Yanker | Dec 1991 | A |
5215396 | Rogers | Jun 1993 | A |
5416895 | Anderson et al. | May 1995 | A |
5485174 | Henshaw et al. | Jan 1996 | A |
5581670 | Bier et al. | Dec 1996 | A |
5617114 | Bier et al. | Apr 1997 | A |
5689717 | Pritt | Nov 1997 | A |
5732230 | Cullen et al. | Mar 1998 | A |
5798752 | Buxton et al. | Aug 1998 | A |
5920841 | Schottmuller et al. | Jul 1999 | A |
5943679 | Niles et al. | Aug 1999 | A |
5978747 | Craport et al. | Nov 1999 | A |
6016144 | Blonstein et al. | Jan 2000 | A |
6118427 | Buxton et al. | Sep 2000 | A |
6121966 | Teodosio et al. | Sep 2000 | A |
6185582 | Zellweger et al. | Feb 2001 | B1 |
6278660 | Tognazzini | Aug 2001 | B1 |
6320495 | Sporgis | Nov 2001 | B1 |
6397143 | Peschke | May 2002 | B1 |
6407749 | Duke | Jun 2002 | B1 |
6421063 | Morrison | Jul 2002 | B1 |
6424355 | Watanabe et al. | Jul 2002 | B2 |
6476831 | Wirth et al. | Nov 2002 | B1 |
6509915 | Berman et al. | Jan 2003 | B2 |
6642936 | Engholm et al. | Nov 2003 | B1 |
6643656 | Peterson | Nov 2003 | B2 |
6657644 | Plow et al. | Dec 2003 | B1 |
6792776 | Davis et al. | Sep 2004 | B2 |
6915409 | Peterson | Jul 2005 | B1 |
7051289 | Yoshida | May 2006 | B1 |
7051291 | Sciammarella et al. | May 2006 | B2 |
7068290 | Bennett et al. | Jun 2006 | B2 |
7076409 | Agrawala et al. | Jul 2006 | B2 |
7106220 | Gourgey et al. | Sep 2006 | B2 |
7107532 | Billmaier et al. | Sep 2006 | B1 |
7133862 | Hubert et al. | Nov 2006 | B2 |
7197718 | Westerman et al. | Mar 2007 | B1 |
7269794 | Martinez et al. | Sep 2007 | B2 |
7274377 | Ivashin et al. | Sep 2007 | B2 |
7274378 | McAvoy et al. | Sep 2007 | B2 |
7320031 | Konig et al. | Jan 2008 | B2 |
7340418 | Caine | Mar 2008 | B2 |
7405739 | Gannon | Jul 2008 | B2 |
7437279 | Agrawala et al. | Oct 2008 | B2 |
7496484 | Agrawala et al. | Feb 2009 | B2 |
7500197 | Whitmarsh et al. | Mar 2009 | B2 |
7559036 | Buck | Jul 2009 | B1 |
7587276 | Gold et al. | Sep 2009 | B2 |
7770130 | Suzuki | Aug 2010 | B1 |
7844395 | Aoyama | Nov 2010 | B2 |
7990394 | Vincent et al. | Aug 2011 | B2 |
7995078 | Baar | Aug 2011 | B2 |
8037422 | Buck | Oct 2011 | B1 |
8115764 | Kameda et al. | Feb 2012 | B2 |
8120624 | Jetha et al. | Feb 2012 | B2 |
8122341 | Dayan et al. | Feb 2012 | B1 |
8151215 | Baurmann et al. | Apr 2012 | B2 |
8180690 | Mayle et al. | May 2012 | B2 |
8209372 | Abdo et al. | Jun 2012 | B2 |
8219927 | Gatlin et al. | Jul 2012 | B2 |
8225225 | Jetha et al. | Jul 2012 | B2 |
8245255 | Schlarb | Aug 2012 | B2 |
8255238 | Powell et al. | Aug 2012 | B2 |
8265864 | Kaufman et al. | Sep 2012 | B1 |
8269767 | Glueck et al. | Sep 2012 | B2 |
8270769 | Judelson | Sep 2012 | B2 |
8294710 | Kinnan et al. | Oct 2012 | B2 |
8314789 | Fitzmaurice et al. | Nov 2012 | B2 |
8321804 | Castelli et al. | Nov 2012 | B2 |
8321806 | Agrusa et al. | Nov 2012 | B2 |
8339417 | Stroila et al. | Dec 2012 | B2 |
8359545 | Pixley et al. | Jan 2013 | B2 |
8381121 | Gupta et al. | Feb 2013 | B2 |
8384726 | Grabowski et al. | Feb 2013 | B1 |
8386920 | Cox et al. | Feb 2013 | B2 |
8397180 | Duhig | Mar 2013 | B2 |
8539339 | Lloyd et al. | Sep 2013 | B2 |
8582849 | Eichhorn et al. | Nov 2013 | B2 |
20010018365 | Orui et al. | Aug 2001 | A1 |
20010034588 | Agrawals et al. | Oct 2001 | A1 |
20010035880 | Musatov et al. | Nov 2001 | A1 |
20020044144 | Inoue | Apr 2002 | A1 |
20020163547 | Abramson et al. | Nov 2002 | A1 |
20030025734 | Boose et al. | Feb 2003 | A1 |
20030033329 | Bergman et al. | Feb 2003 | A1 |
20030052896 | Higgins et al. | Mar 2003 | A1 |
20030144047 | Sprogis et al. | Jul 2003 | A1 |
20040056904 | Jaeger | Mar 2004 | A1 |
20040090472 | Risch et al. | May 2004 | A1 |
20040212615 | Uthe | Oct 2004 | A1 |
20040239681 | Robotham et al. | Dec 2004 | A1 |
20040263512 | Santodomingo et al. | Dec 2004 | A1 |
20040267700 | Dumais et al. | Dec 2004 | A1 |
20040268299 | Lei et al. | Dec 2004 | A1 |
20050071349 | Jordan et al. | Mar 2005 | A1 |
20050076361 | Choi et al. | Apr 2005 | A1 |
20050102634 | Sloo | May 2005 | A1 |
20050125739 | Thompson et al. | Jun 2005 | A1 |
20050132305 | Guichard et al. | Jun 2005 | A1 |
20050138570 | Good et al. | Jun 2005 | A1 |
20050182604 | Agrawala et al. | Aug 2005 | A1 |
20050210403 | Satanek | Sep 2005 | A1 |
20050257166 | Tu | Nov 2005 | A1 |
20060048073 | Jarrett et al. | Mar 2006 | A1 |
20060059063 | LaComb et al. | Mar 2006 | A1 |
20060080594 | Chavoustie et al. | Apr 2006 | A1 |
20060247850 | Cera et al. | Nov 2006 | A1 |
20060253795 | Titov et al. | Nov 2006 | A1 |
20060287815 | Gluck | Dec 2006 | A1 |
20070072629 | Bae | Mar 2007 | A1 |
20070130515 | Maas | Jun 2007 | A1 |
20070136286 | Webster et al. | Jun 2007 | A1 |
20070136406 | Softky | Jun 2007 | A1 |
20070179776 | Segond et al. | Aug 2007 | A1 |
20070198476 | Farago et al. | Aug 2007 | A1 |
20070245247 | Neely et al. | Oct 2007 | A1 |
20080002911 | Eisen et al. | Jan 2008 | A1 |
20080052372 | Weber et al. | Feb 2008 | A1 |
20080103695 | Whiting | May 2008 | A1 |
20080155474 | Duhig | Jun 2008 | A1 |
20080155475 | Duhig | Jun 2008 | A1 |
20080208631 | Morita et al. | Aug 2008 | A1 |
20080208880 | Dong et al. | Aug 2008 | A1 |
20080291205 | Rasmussen et al. | Nov 2008 | A1 |
20080292213 | Chau | Nov 2008 | A1 |
20090013273 | Fuchs et al. | Jan 2009 | A1 |
20090030556 | Castelli et al. | Jan 2009 | A1 |
20090083676 | Flanagan et al. | Mar 2009 | A1 |
20090100373 | Pixley et al. | Apr 2009 | A1 |
20090158185 | Lacevic et al. | Jun 2009 | A1 |
20090160873 | Kew et al. | Jun 2009 | A1 |
20090183095 | Deitsch et al. | Jul 2009 | A1 |
20090199142 | Arunachalam et al. | Aug 2009 | A1 |
20090204920 | Beverley et al. | Aug 2009 | A1 |
20090228841 | Hildreth | Sep 2009 | A1 |
20100011316 | Sar et al. | Jan 2010 | A1 |
20100020093 | Stroila et al. | Jan 2010 | A1 |
20100031152 | Villaron et al. | Feb 2010 | A1 |
20100045702 | Doyle et al. | Feb 2010 | A1 |
20100058240 | Bull et al. | Mar 2010 | A1 |
20100115462 | Spencer et al. | May 2010 | A1 |
20100146434 | Blinnikka et al. | Jun 2010 | A1 |
20100194744 | Glueck et al. | Aug 2010 | A1 |
20100198653 | Bromenshenkel et al. | Aug 2010 | A1 |
20100199213 | Suzuki | Aug 2010 | A1 |
20100205520 | Parish et al. | Aug 2010 | A1 |
20110047504 | Wienands et al. | Feb 2011 | A1 |
20110113334 | Joy et al. | May 2011 | A1 |
20110126148 | Krishnaraj et al. | May 2011 | A1 |
20110126156 | Krishnaraj et al. | May 2011 | A1 |
20110131597 | Cera et al. | Jun 2011 | A1 |
20110214085 | Vanbree | Sep 2011 | A1 |
20110252299 | Lloyd et al. | Oct 2011 | A1 |
20110307772 | Lloyd et al. | Dec 2011 | A1 |
20120005623 | Ishak et al. | Jan 2012 | A1 |
20120036455 | Holt et al. | Feb 2012 | A1 |
20120038662 | Dicklin et al. | Feb 2012 | A1 |
20120054653 | Grossman et al. | Mar 2012 | A1 |
20120066638 | Ohri | Mar 2012 | A1 |
20120089914 | Holt et al. | Apr 2012 | A1 |
20120110621 | Gossweiler, III | May 2012 | A1 |
20120117452 | Lloyd et al. | May 2012 | A1 |
20120151406 | Oberstein | Jun 2012 | A1 |
20120151408 | Groth et al. | Jun 2012 | A1 |
20120188280 | Charlebois et al. | Jul 2012 | A1 |
20130057579 | Castelli et al. | Mar 2013 | A1 |
20130120460 | Adams et al. | May 2013 | A1 |
Number | Date | Country |
---|---|---|
WO 2012112356 | Aug 2012 | WO |
Entry |
---|
“A User-Centred Approach to Functions in Excel” by Simon Peyton Jones et al. |
“Tools for spreadsheet auditing” by Davis. |
“Contour line”, From Wiki.GIS.com, Revision as of 21:34, Jul. 8, 2009, by Justicelovespeace, downloaded from http://wiki.gis.com/wiki/index.php?title=Contour—line&oldid=169596 on May 1, 2013. |
“hExcel—A Hexagonal Spreadsheet”, by secretGeek, archived Jul. 9, 2009 by Internet WaybackMachine, downloaded May 2, 2013. |
“Excel VLOOKUP” by Ted French downloaded from Internet Wayback Machine on Jan. 24, 2014 archived between Jan. 9, 2007 and Mar. 3, 2007 from http://web.archive.org/web/20070109071521/http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm. |
A Negotiation Architecture for Fluid Documents Bay-Wei Chang et al. |
“Microsoft Excel 2007: The Average Function in Excel 2007” by Free Computer Tutorials downloaded Jan. 27, 2014 from https://web.archive.org/web/20080111133824/http://www.homeandlearn.co.uk/excel2007/excel2007s5p1.html archived Jan. 11, 2008. |
“3D Interactive Visualization for Inter-Cell Dependencies of Spreadsheets” by Hidekazu Shiozawa et al, IEEE Symposium on Information Visualization, 1999. (Info Vis '99) Proceedings. 1999. |
“A User-Centred Approach to Functions in Excel”, Simon Peyton et al. |
“Fluid Visualization of Spreadsheet Structures” by Takeo Igarashi et al. |
“Visualizing Locations of Off-Screen Objects on Mobile Devices: A Comparative Evaluation of Three Approaches” by Stefano Burigat et al MobileHCI '06, Sep. 12-15, 2006, Helsinki, Finland. Copyright 2006 ACM. |
“EXChecker v2.4: EXChecker Help” published 2005 by Spreadsheet auditing Ltd. |
U.S. Appl. No. 13/739,819, filed Jan. 11, 2013 titled “User Interfaces for Summarizing Statuses of Cells in a Grid”. |
U.S. Appl. No. 13/739,834, filed Jan. 11, 2013 titled “User Interfaces Employing Background Images, Branching Cells, and Hidden Cells for Navigating Cells in a Grid”. |
U.S. Appl. No. 13/739,880, filed Jan. 11, 2013 titled “User Interfaces for Interrupted Grid Navigation, Multi-Input Scrolling, and Displaying Spanner Cells”. |
International Search Report mailed Sep. 27, 2012 in related PCT Patent Application No. PCT/US2012/024253. |
U.S. Appl. No. 13/739,819, filed Aug. 7, 2013, Office Action. |
U.S. Appl. No. 13/739,819, filed Jan. 14, 2014, Office Action. |
U.S. Appl. No. 13/739,834, filed May 22, 2013, Office Action. |
U.S. Appl. No. 13/739,834, filed Oct. 21, 2013, Office Action. |
U.S. Appl. No. 13/739,880, filed Jun. 20, 2013, Office Action. |
U.S. Appl. No. 13/739,880, filed Jul. 25, 2013, Office Action. |
U.S. Appl. No. 13/739,880, filed Feb. 27, 2014, Office Action. |
Number | Date | Country | |
---|---|---|---|
61661633 | Jun 2012 | US |