Data filtering based on a cell entry

Information

  • Patent Grant
  • 10354003
  • Patent Number
    10,354,003
  • Date Filed
    Thursday, August 18, 2016
    7 years ago
  • Date Issued
    Tuesday, July 16, 2019
    4 years ago
Abstract
A method for data filtering includes displaying on a display device a cell set including data of a common data type, and displaying a first filter icon within a first cell of the cell set and a second filter icon within a second cell of the cell set. The first cell includes a first cell entry and the second cell includes a second cell entry. The first filter icon filters based on the first cell entry and the second filter icon filters based on the second cell entry. The method further includes applying a filter to the cell set in response to selection of the first filter icon by a user, the filter being based on the first cell entry.
Description
BACKGROUND

Users may be inundated with massive amounts of data making it difficult to manage and harness the data effectively. Users can easily suffer from information overload. Data formatted in grids or other arrangements may be unmanageable, making the data ineffective for the user. Tools and functions have been developed to allow users to manipulate the presentation and display of the data to better understand the data. Filtering data is one such important function, helping users focus attention on data that fits the particular criteria of the filter. Typically a user selects a menu option to apply filtering. A filter dialog box then appears and the user inputs the right spelling or capitalization to accurately filter the data. This conventional filtering process is time consuming and susceptible to user input errors, especially for users that filter data repeatedly.


SUMMARY

Embodiments of a method are described. In one embodiment, a method for data filtering includes displaying on a display device a cell set including data of a common data type, and displaying a first filter icon within a first cell of the cell set and a second filter icon within a second cell of the cell set. The first cell includes a first cell entry and the second cell includes a second cell entry. The first filter icon filters based on the first cell entry and the second filter icon filters based on the second cell entry. The method further includes applying a filter to the cell set in response to selection of the first filter icon by a user, wherein the filter is based on the first cell entry. Other embodiments of the method are also described.


Other aspects and advantages of embodiments of the present invention will become apparent from the following detailed description, taken in conjunction with the accompanying drawings, illustrated by way of example of the principles of the invention.





BRIEF DESCRIPTION OF THE DRAWINGS


FIG. 1 depicts a schematic diagram of one embodiment of a data filtering system.



FIG. 2A depicts one embodiment of a data set configured in rows and columns with a filter icon displayed within a cell.



FIG. 2B depicts the data set of FIG. 2A with the cursor moved and the filter icon displayed in a different cell.



FIG. 2C depicts the data set of FIGS. 2A and 2B with the data set filtered according to the cell entry.



FIG. 2D depicts the data set of FIG. 2C with a cell entry shown as a hyperlink.



FIG. 2E depicts the data set of FIG. 2D and the metadata associated with the cell entry.



FIG. 2F depicts the data set of FIG. 2A and a filter dialog containing an entry field automatically populated with a cell entry.



FIG. 3 depicts a flow chart diagram of one embodiment of a method for data filtering.





Throughout the description, similar reference numbers may be used to identify similar elements.


DETAILED DESCRIPTION

It will be readily understood that the components of the embodiments as generally described herein and illustrated in the appended figures could be arranged and designed in a wide variety of different configurations. Thus, the following more detailed description of various embodiments, as represented in the figures, is not intended to limit the scope of the present disclosure, but is merely representative of various embodiments. While the various aspects of the embodiments are presented in drawings, the drawings are not necessarily drawn to scale unless specifically indicated.


The present invention may be embodied in other specific forms without departing from its spirit or essential characteristics. The described embodiments are to be considered in all respects only as illustrative and not restrictive. The scope of the invention is, therefore, indicated by the appended claims rather than by this detailed description. All changes which come within the meaning and range of equivalency of the claims are to be embraced within their scope.


Reference throughout this specification to features, advantages, or similar language does not imply that all of the features and advantages that may be realized with the present invention should be or are in any single embodiment of the invention. Rather, language referring to the features and advantages is understood to mean that a specific feature, advantage, or characteristic described in connection with an embodiment is included in at least one embodiment of the present invention. Thus, discussions of the features and advantages, and similar language, throughout this specification may, but do not necessarily, refer to the same embodiment.


Furthermore, the described features, advantages, and characteristics of the invention may be combined in any suitable manner in one or more embodiments. One skilled in the relevant art will recognize, in light of the description herein, that the invention can be practiced without one or more of the specific features or advantages of a particular embodiment. In other instances, additional features and advantages may be recognized in certain embodiments that may not be present in all embodiments of the invention.


Reference throughout this specification to “one embodiment,” “an embodiment,” or similar language means that a particular feature, structure, or characteristic described in connection with the indicated embodiment is included in at least one embodiment of the present invention. Thus, the phrases “in one embodiment,” “in an embodiment,” and similar language throughout this specification may, but do not necessarily, all refer to the same embodiment.


While many embodiments are described herein, at least some of the described embodiments facilitate filtering data quickly and efficiently. In many instances, it is difficult to efficiently and accurately filter data. Tables and spreadsheets today may contain tens of thousands of cells or more. Filters allow users to understand, interpret, and analyze subsets of data within a table or spreadsheet by locating or displaying only the data that satisfies the filter.


Applying a conventional filter typically involves a user selecting a filter option on the menu of an application. Upon selection, a dialog box prompts the user to input the desired filter language. For users continually applying filters, this process can be time consuming and frustrating. In addition, the user typically manually inputs the correct filter language or criteria. The user needs to be familiar with the correct spelling and capitalization to correctly apply the filter. The user may just enter a typo. Incorrect capitalization or a misspelled word leads to user frustration and inefficiency or worse. A user unaware of a misspelled filter may reach incorrect conclusions based on an incorrect filtered data set.


Some embodiments described herein allow the user to apply a filter based on a cell value or cell entry without typing anything by selecting the filter icon within the cell. There is no opportunity to misspell the filter language. Some embodiments significantly reduce the time to apply a filter by applying after a single mouse-click or other user input. Accurate and quick application of filters reduces user frustration and increases user satisfaction. Users who apply filters continually do so quickly and efficiently.



FIG. 1 depicts a schematic diagram of one embodiment of a data filtering system 100. The depicted data filtering system 100 includes various components, described below, that are capable of performing the functions and operations described herein. The illustrated data filtering system 100 includes a computer memory device 102, a processing device 104, input/output devices 106, and a disk storage device 108. The illustrated data filtering system 100 also includes a data filtering engine 110, a filter dialog engine 112, and a display device 114. Some or all of the components of the data filtering system 100 may be stored on a single computing device or on a network of computing devices, including a wireless communication network. The data filtering system 100 may be a single device such as a mobile phone, a smart phone, a portable media device, a tablet computer, a laptop computer, a desktop computer, or other device or a combination of devices. Although the data filtering system 100 is shown and described with certain components and functionality, other embodiments of the data filtering system 100 may include fewer or more components to implement less or more functionality.


The computer memory device 102 may store data and/or software instructions or computer program instructions for carrying out the operations described herein. The computer memory device 102 may be external or internal to the computer system and may include but is not limited to a hard drive, a CD/DVD recordable drive, a magnetic tape drive, a disk cartridge drive, a secure digital card, another type of magnetic or optical drive, a solid-state drive, or another type of memory device. The processing device 104 is connected to and in communication with the memory device 102 and may store and access data on the memory device 102 for performing the operations described herein. The processor or processing device 104 may also be connected to the disk storage device 108. The disk storage device 108 may be implemented to temporarily store data or software instructions from the memory device 102 or the processor 104. The disk storage device 108 may include but is not limited to a hard disk drive, a floppy disk drive, a removable floppy disk, or other type of optical or magnetic drive. The functionality of the data filtering engine 110 and the filter dialog engine 112 may be implemented by computer program instructions stored on the computer memory device 102 and executed by the processing device 104 such as a CPU


A user interface 116 is displayed on the display device 114. The display device 114 may be any display device 114 for a computing device. The user interface 116 may be part of an operating system for the computing device and may allow a user to interact with the operating system. The operations described herein may be associated with one or more applications configured to operate within the operating system.


In some embodiments, the data filtering engine 110 is configured to display a cell set containing data of a common data type. In some embodiments, at least one cell contains a cell entry. In some embodiments, the data filtering engine 110 is configured to display a data set comprising at least one cell set. In some embodiments, the data filtering engine 110 is further configured to display a filter icon within at least one cell of the cell set. A data set may be a database, a table, a spreadsheet, a relation, a data model, a file or other collection of data. A data model may be a flat model, a hierarchical model, a network model, a relational model, or another similar model. A data set may be configured in cells, lines of data, or otherwise. A data set may contain more than one cell set. A cell set is a subset of a data set. In some embodiments, a cell set may contain data of a common data type. A cell set may be a line of data, a row of data, a column of data, or another subset of a data set. A cell may be a data field, a field containing a data value, or another subset of a cell set. A cell entry may be any type of data including but not limited to a number, a letter, a word, a sentence, a symbol, a data value, a data field entry, or metadata, or a combination thereof.


In some embodiments, the filter icon may be another function to manage data including but limited to sorting, filtering, summation, find and replace and so on. In some embodiments, the data filtering engine 110 is further configured to apply a filter to the cell set in response to a selection of the filter icon by a user. In some embodiments, the function of the filter is to distinguish filtered data from sifted data. The filter separates the unfiltered data into filtered data (or the desired data) and sifted data (or the undesired data). Unfiltered data is the data set or cell set before application of the filter. The filtered data is the unfiltered data that satisfies the filter language or criteria. The sifted data is the unfiltered data that does not satisfy the filter language or criteria. In some embodiments, the applied filter is the cell entry. In some embodiments, the filter is based on the cell entry. The filter criteria may include but is not limited to filtering for values equal to, greater than, less than, begins with etc.


The filtered data may be displayed in various formats. In some embodiments, the filtered data is exclusively displayed on the display device 114. In some embodiments, only the result cell set is displayed. In some embodiments, the result data set is displayed. In some embodiments, the filtered data is moved to an optimal location within the data set or cell set. In some embodiments, the filtered data moves to the top of the data set or cell set. In some embodiments, the result will be highlighted or otherwise visually emphasized.


In some embodiments, the data filtering engine 110 is further configured to apply additional filters. In some embodiments, the additional filter is applied in response to selection of a second filter icon displayed within at least a second cell of a second cell set. The filters may be associated with each other using logical operations well known including but limited to and, or, not, nor, equals, less than, greater than, and so on. In some embodiments, the data filtering engine 110 is further configured to display the cell entry as a hyperlink. The hyperlink links to metadata associated with the cell entry. In some embodiments, the data filtering engine 110 is further configured to display the metadata associated with the cell entry in response to selection of the hyperlink.


In some embodiments, the data filtering system 100 includes the filter dialog engine 112. In some embodiments, the filter dialog engine 112 is configured to display a filter dialog in response to the selection of the filter icon by the user. In some embodiments, the filter dialog is automatically populated with the cell entry. The filter dialog may be configured to filter according to many different criteria. The criteria may include but is not limited to filtering for values equal to, greater than, less than, begins with etc. In some embodiments, the filter dialog includes additional entry fields that may be applied to the data set. In some embodiments, the filter dialog is configured to allow the user to input additional filters in to the additional entry fields.



FIG. 2A depicts one embodiment of a data set 200 configured in rows 202-210 and columns 212-220 with a filter icon 224 displayed within a cell 226. In some embodiments, the data set 200 is displayed on the user interface 116 of the display device 114. In this embodiment, the first row 202 of the data set 200 contains column headings. In this embodiment, the remaining rows 204-210 are groups of related data, known as a record, tuple or other set of related data. The rows 204-210 contain data that may be filtered. In this embodiment, the data set 200 is sales information. The data in each row 204-210 relate to sales transactions, with each attribute of the transaction aligned under columns 212-220. In this embodiment, the columns 212-220 are cell sets 212-220. The sales information includes the location of a sale, the sales unit involved, the date of the sale, the revenue generated, and the number of salesmen involved in the sale. For simplicity, a small data set 200 is shown in FIGS. 2A-2F. In this embodiment, the filter functionally allows a user to view only the sales information of a single region (e.g. East or West), a single sales unit (e.g. 1, 2, or 3), or a single date (e.g. 9/17 or 9/18), etc. A filter allows the user to focus attention on a subset of data while ignoring the rest. FIG. 2A also depicts a cursor 222 located in a cell 226 and a filter icon 224 located at a left perimeter of the cell 226. The cell 226 contains a cell entry 228 of “9/18.” Although the filter icon 224 is shown with a specific graphical depiction—a block letter F—other embodiments may utilize other graphical or visual elements to represent the filter icon 224 in the cell 226. In other embodiments, the filter icon 224 may be located anywhere in the cell 226 or only partially in the cell 226.



FIG. 2B depicts the data set 200 of FIG. 2A with the cursor 222 moved and the filter icon 224 displayed in a different cell 230. In this embodiment, the user has moved the cursor 222 to a new cell 230, and the filter icon 224 disappears from the cell 226 and displays in the cell 230. In some embodiments, the filter icon 224 appears when the cursor 222 hovers over the cell 230 for a period of time. In some embodiments, the filter icon 222 will disappear from the cell 226 when the cursor 222 leaves the cell 226, appearing in the cell 230 where the cursor 222 relocates. In some embodiments, the filter icon 224 is displayed in all cells of the data set 200 regardless of the location of the cursor 222. In some embodiments, the filter icon 222 is displayed only in cells containing a cell entry 228. Some embodiments do not include a cursor 222.



FIG. 2C depicts the data set 200 of FIGS. 2A and 2B with the data set 200 filtered according to the cell entry 228. The data set 200 has been filtered upon selection of the filter icon 224. In this embodiment, the cell set 216 is filtered for data equaling the cell entry 228. Cells 226 and 230 are displayed along with the related data in rows 206 and 208. In other embodiments, cells 226 and 230 are exclusively displayed. In this embodiment the filtered data 206 and 210 is distinguished from the sifted data 204 and 210. The sifted data 204 and 210 do not contain a data satisfying the filter. In some embodiments, the selection of the filter icon 224 may be a single mouse click. Some embodiments include a touch screen and selection of the filter icon 224 may be a single tap of the filter icon 224. The filtered data set 200 shows only rows 206 and 208, the rows satisfying the filter “9/18.” Rows 204 and 210 are excluded because they do not satisfy the cell entry 228, “9/18.” In this embodiment, only the filtered data will be displayed. In some embodiments, the filtered data will relocate to the top of the data set 200. In some embodiments, the filtered data will be highlighted or otherwise visually emphasized.



FIG. 2D depicts the data set 200 of FIG. 2C with a cell entry 232 shown as a hyperlink. In this embodiment, the cursor 222 has moved to a different cell 234. The filter icon 224 is displayed in cell 234 and the cell entry 232 is displayed as a hyperlink. In some embodiments, the cell entry 232 is metadata. In some embodiments, when the cell entry 232 is metadata, the cell entry 232 is displayed as a hyperlink. The hyperlink links to the data associated with the metadata. In some embodiments, the cell entry 232 displays as a hyperlink after the cursor 222 hovers over the cell 234 for a period of time. In some embodiments, each cell entry 232 that supports linking to further data is displayed as a hyperlink regardless of the location of the cursor 222. Some embodiments do not include the cursor 222.



FIG. 2E depicts the data set 200 of FIG. 2D and the metadata 236 associated with the cell entry 232. In this embodiment, the metadata 236 is displayed below the cell 234. In some embodiments, the metadata 236 is a separate database, table, spreadsheet, or other collection of data located in a distinct file. In some embodiments, the metadata 236 is a separate sheet, database, or table located in the same file. In some embodiments, the metadata 236 resides in a different application. In this embodiment, the metadata 236 associated with the cell entry 232 (i.e. “2”) are the names of the two salesmen responsible for the sale (i.e. “Roger” and “Jackie”). In some embodiments, the metadata 236 is displayed in different ways. The metadata 236 may be displayed in a different location within data set 200 or may be displayed as a pop-up window. The metadata 236 may be displayed within the same cell as the original cell entry 232 in which the metadata 236 is associated or may be displayed in an entirely different format. In this embodiment, the cell entries 238 and 240 are also displayed as hyperlinks. The cell entries 238 and 240 link to further data detailing each cell entry, respectively. In some embodiments, the user may drill down on multiple levels of data quickly and efficiently with a single click of a hyperlink.



FIG. 2F depicts the data set 200 of FIG. 2A and a filter dialog 242 containing an entry field 244 automatically populated with the cell entry 228. In this embodiment, the filter dialog 242 is displayed in response to the selection of the filter icon 224. In this embodiment, the filter dialog entry field 244 is automatically populated with the cell entry 228. In some embodiments, the filter dialog 242 is configured to filter for values equal to the cell entry 228. In other embodiments, the filter dialog 242 is configured to filter for values less than or more than the value of the cell entry 228. In some embodiments, the filter dialog 242 is configured to filter for values that begin with the cell entry 228 and so on. In some embodiments, the filter dialog 242 includes an execute button 246 that when selected applies the filter. In some embodiments, the user may change or alter the automatically populated value of the entry field 244. In some embodiments, the filter dialog 242 includes additional entry fields 248 enabling application of additional filters. In some embodiments, the additional entry filed 248 is automatically populated according to other cell entries 228 of the data set 200 or cell set 216. In some embodiments, the filter dialog 242 is displayed in a separate window, in a pop-up, in a ribbon of an application, in a menu, or otherwise similarly displayed.


In addition to the advantages which may be achieved by implementation of the individual components of the data filtering system 100, some embodiments of the data filtering system 100 provide additional advantages over conventional technology. For example, some embodiments of the data filtering system 100 allow a user to quickly apply a filter with a single mouse click. Some embodiments reduce or eliminate the possibility of an error in spelling or capitalization by basing the filter on the cell entry. In some embodiments, filters are applied without typing a single keystroke.



FIG. 3 depicts a flow chart diagram of one embodiment of a method for data filtering 300. Although the method for data filtering 300 is described in conjunction with the data filtering system 100 of FIG. 1 and the data set 200 of FIGS. 2A-2F, embodiments of the method for data filtering 300 may be implemented with other types of computer systems.


At 302, a cell set 216 is displayed on a display device 114. The cell set 216 contains data of a common data type and at least one cell 226 contains a cell entry 228. At 304, a filter icon 224 is displayed within at least one of the cells 226 of the cell set 216. At 306, a filter is applied to the cell set 216 in response to selection of the filter icon 224. The depicted method for data filtering 300 then ends.


In some embodiments, the filter is based on the cell entry 228. Some embodiments include distinguishing filtered data 206-208 that fulfills a logical rule relating the filtered data 206-208 and the cell entry 228 from sifted data 204 & 210 that does not fulfill the logical rule relating the sifted data 204 & 210 and the cell entry 228. Distinguishing may include exclusively displaying, moving, or otherwise visually emphasizing the filtered data 206-208. In some embodiments, only the cell set 216 is displayed. In other embodiments, the data set 200 is displayed showing the related data of cell sets 212-214 and 218-220. In some embodiments, the data set 200 is filtered for the exact value of the cell entry 228. In some embodiments, the data set 200 is filtered for values greater than or less than the value of the cell entry 228. In some embodiments, the data set 200 is filtered for a range of values above and/or below the value of the cell entry 228. In some embodiments, the data set 200 is filtered for similar values as the cell entry 228 or values that begin with the cell entry 228. In some embodiments, only the cell set 216 is filtered.


In some embodiments, the method for data filtering 300 further includes displaying a filter dialog 242 in response to the selection of the filter icon 224 by the user. In some embodiments, the filter dialog entry field 244 is automatically populated with the cell entry 228. The filter may be configured to filter according to many different criteria. The criteria may include but is not limited to filtering for values equal to, greater than, less than, begins with and so on. In some embodiments, the filter dialog 242 includes additional entry fields 248 that allow additional filters to be applied to the data set 200.


In some embodiments, the method for data filtering 300 includes applying additional filters to the data set 200 by selecting a second filter icon 224 displayed within at least a second cell 232 of a second cell set 220. The additional filters may be associated with each other using logical operations well known in the art including but limited to and, or, not, nor, equals, less than, greater than, and so on.


In some embodiments, the selection of the filter icon 224 is in response to a single user input. The input may be a single mouse click, a right-click, a left-click, a tap or other recognized touch gesture on a touch screen, a keystroke, a keyboard input, or another analogous single input. Some embodiments described herein increase efficiency by decreasing the time and/or the number of inputs required to apply a filter. In some embodiments, a single click of the filter icon 224 will apply a filter based on the cell entry 228.


In some embodiments, the filter icon 224 will appear within at least one cell 226 of the cell set 216 when the cursor 222 or an analogous pointer hovers over the cell 226 for a period of time. In some embodiments, the filter icon 224 is displayed in all cells 226 of the cell set 216 or the data set 200. In some embodiments, the filter icon 224 is displayed only in cells 226 that contain a cell entry 228.


Some embodiments of the method for data filtering 300 further include displaying a data set 200 including a plurality of cell sets 212-220. In some embodiments, the method for data filtering 300 includes applying at least one additional filter in response to a user input, the user input being selection of a second filter icon 224 displayed within at least a second cell 232 of a second cell set 220.


In some embodiments, the method for data filtering 300 further includes displaying the cell entry 234 as a hyperlink. In some embodiments, the hyperlink links to metadata 236 associated with the cell entry 234. In some embodiments, the metadata 236 is displayed in response to selection of the hyperlink. The metadata 236 may be displayed within the data set 200, within the cell set 220, as a pop-up box, in a separate file, in a separate window, or in another way. In some embodiments, the hyperlink is displayed when the cursor 222 or similar pointer hovers over the cell 232 for a period of time. In other embodiments, all cell entries 234 that link to metadata 236 are shown as hyperlinks.


In the above description, specific details of various embodiments are provided. However, some embodiments may be practiced with less than all of these specific details. In other instances, certain methods, procedures, components, structures, and/or functions are described in no more detail than to enable the various embodiments of the invention, for the sake of brevity and clarity.


Although the operations of the method(s) herein are shown and described in a particular order, the order of the operations of each method may be altered so that certain operations may be performed in an inverse order or so that certain operations may be performed, at least in part, concurrently with other operations. In another embodiment, instructions or sub-operations of distinct operations may be implemented in an intermittent and/or alternating manner.


Although specific embodiments of the invention have been described and illustrated, the invention is not to be limited to the specific forms or arrangements of parts so described and illustrated. The scope of the invention is to be defined by the claims appended hereto and their equivalents.


An embodiment of a system for data filtering includes at least one processor coupled directly or indirectly to memory elements through a system bus such as a data, address, and/or control bus. The memory elements can include local memory employed during actual execution of the program code, bulk storage, and cache memories which provide temporary storage of at least some program code in order to reduce the number of times code must be retrieved from bulk storage during execution.


It should also be noted that at least some of the operations for the methods may be implemented using software instructions stored on a computer useable storage medium for execution by a computer. As an example, an embodiment of a computer program product includes a computer useable storage medium to store a computer readable program that, when executed on a computer, causes the computer to perform operations, including an operation to monitor a pointer movement in a web page. The web page displays one or more content feeds. In one embodiment, operations to report the pointer movement in response to the pointer movement comprising an interaction gesture are included in the computer program product. In a further embodiment, operations are included in the computer program product for tabulating a quantity of one or more types of interaction with one or more content feeds displayed by the web page.


Although the operations of the method(s) herein are shown and described in a particular order, the order of the operations of each method may be altered so that certain operations may be performed in an inverse order or so that certain operations may be performed, at least in part, concurrently with other operations. In another embodiment, instructions or sub-operations of distinct operations may be implemented in an intermittent and/or alternating manner.


Embodiments of the invention can take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment containing both hardware and software elements. In one embodiment, the invention is implemented in software, which includes but is not limited to firmware, resident software, microcode, etc.


Furthermore, embodiments of the invention can take the form of a computer program product accessible from a computer-usable or computer-readable medium providing program code for use by or in connection with a computer or any instruction execution system. For the purposes of this description, a computer-usable or computer readable medium can be any apparatus that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device.


The computer-useable or computer-readable medium can be an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system (or apparatus or device), or a propagation medium. Examples of a computer-readable medium include a semiconductor or solid state memory, magnetic tape, a removable computer diskette, a random access memory (RAM), a read-only memory (ROM), a rigid magnetic disk, and an optical disk. Current examples of optical disks include a compact disk with read only memory (CD-ROM), a compact disk with read/write (CD-R/W), and a digital video disk (DVD).


Input/output or I/O devices (including but not limited to keyboards, displays, pointing devices, etc.) can be coupled to the system either directly or through intervening I/O controllers. Additionally, network adapters also may be coupled to the system to enable the data processing system to become coupled to other data processing systems or remote printers or storage devices through intervening private or public networks. Modems, cable modems, and Ethernet cards are just a few of the currently available types of network adapters.

Claims
  • 1. A method for data filtering comprising: displaying on a display device at least a portion of a data set and displaying a cell set of the data set, the cell set comprising a subset of the data set and the cell set comprising one or more cells, each cell of the cell set comprising data of a common data type;displaying a first filter icon within a first cell of the cell set and a second filter icon within a second cell of the cell set in response to a cursor hovering over one of the first cell of the cell set and the second cell of the cell set, the first cell comprising a first cell entry and the second cell comprising a second cell entry, wherein the first filter icon filters based on the first cell entry and the second filter icon filters based on the second cell entry;applying a filter to the cell set in response to selection of the first filter icon by a user, wherein data in the cell set is filtered by data of the first cell entry such that only cells of the cell set that comprise data that equals the data of the first cell entry are included in the filtered data along with related data of the included cells; anddisplaying filtered data of the data set, the filtered data comprising results of applying the filter.
  • 2. The method of claim 1, wherein each cell of the cell set comprises a corresponding filter icon and wherein applying the filter comprises distinguishing on the display device filtered data that fulfills a logical rule relating the filtered data and the first cell entry from sifted data that does not fulfill the logical rule relating the sifted data and the first cell entry, and wherein the first filter icon and the second filter icon are displayed simultaneously.
  • 3. The method of claim 1, wherein the method further comprises displaying a filter dialog in response to the selection of one of the first filter icon or second filter icon by the user.
  • 4. The method of claim 3, wherein the method further comprises applying at least one additional filter in response to a user input entered into the filter dialog.
  • 5. The method of claim 3, wherein the filter dialog is populated automatically with the first cell entry in response to selection of the first filter icon or populated automatically with the second cell entry in response to selection of the second filter icon.
  • 6. The method of claim 1, wherein the data set comprises a plurality of cell sets and wherein the method further comprises: displaying a corresponding filter icon in each cell of the data set, wherein each corresponding filter icon is based on a corresponding cell entry displayed within a same cell as the corresponding filter icon and applying a second filter in response to a user input, wherein the user input is a selection of the second filter icon displayed within the second cell, wherein the second filter distinguishes data that fulfills a logical rule relating the filtered data and the second cell entry.
  • 7. The method of claim 1, wherein the method further comprises: displaying the first cell entry as a hyperlink, wherein the hyperlink links to metadata associated with the first cell entry, anddisplaying the metadata associated with the first cell entry in response to a selection of the hyperlink.
  • 8. The method of claim 7, wherein the metadata is displayed within the same cell as the first cell entry.
  • 9. The method of claim 7, wherein the metadata is displayed in a separate file.
  • 10. The method of claim 1, wherein the selection of the filter icon is in response to a single user input.
  • 11. The method of claim 10, wherein the first filter icon and the second filter icon are not displayed simultaneously.
  • 12. The method of claim 1, wherein the filtered data of the data set is displayed at the top of the data set.
CROSS-REFERENCE TO RELATED APPLICATIONS

This application is a continuation of U.S. application Ser. No. 14/057,774, filed on Oct. 18, 2013, which is a continuation of U.S. application Ser. No. 13/652,337, filed on Oct. 15, 2012, both of which are incorporated by reference herein in their entirety.

US Referenced Citations (44)
Number Name Date Kind
5396621 MacGregor Mar 1995 A
5721847 Johnson Feb 1998 A
6006239 Bhansali Dec 1999 A
6694326 Mayhew et al. Feb 2004 B2
6738770 Gorman May 2004 B2
6988241 Guttman Jan 2006 B1
7139762 Labarge Nov 2006 B2
7146561 Bauchot et al. Dec 2006 B2
7203694 Gwizdaloski Apr 2007 B2
7216291 Kim May 2007 B2
7356779 Cras Apr 2008 B2
7451397 Weber Nov 2008 B2
7634730 Weber et al. Dec 2009 B2
7849395 Ellis Dec 2010 B2
7853606 Marmaros Dec 2010 B1
8091044 Haynes et al. Jan 2012 B2
9286284 Brissette Mar 2016 B2
9424244 Brissette Aug 2016 B2
20020054141 Yen May 2002 A1
20020120604 Labarge et al. Aug 2002 A1
20050039033 Meyers Feb 2005 A1
20050102273 Gupta May 2005 A1
20050114305 Haynes et al. May 2005 A1
20060074866 Chamberlain Apr 2006 A1
20060074879 Covington Apr 2006 A1
20060075328 Becker Apr 2006 A1
20060224568 Debrito Apr 2006 A1
20060129914 Ellis Jun 2006 A1
20060287998 Folting Dec 2006 A1
20070061698 Megiddo Mar 2007 A1
20070061746 Folting Mar 2007 A1
20070074130 Folting Mar 2007 A1
20080163091 Busse Jul 2008 A1
20090276691 Galuten Nov 2009 A1
20090327852 MacGregor Dec 2009 A1
20100325526 Ellis Dec 2010 A1
20110167385 Charrue Jul 2011 A1
20110219291 Lisa Sep 2011 A1
20110270876 Gill Nov 2011 A1
20110276917 Error Nov 2011 A1
20120023449 Zabielski Jan 2012 A1
20120079363 Folting Mar 2012 A1
20130007645 Kumiawan Jan 2013 A1
20140019842 Montagna Jan 2014 A1
Non-Patent Literature Citations (14)
Entry
“Using Filters in Excel 2010”, 2010, The University of Edinburgh, pp. 4 (Year: 2010).
Bill Jelen, “AutoFilter Secrets in Excel”, Dec. 2008, pp. 2 (Year: 2008).
Susan Harkins, “Quick Tip: Easy filtering of data in Excel”, Apr. 12, 2011, https://www.techrepublic.com/blog/microsoft-office/quick-tip-easy-filtering-of data-in-excel/, pp. 4 (Year: 2011).
U.S. Appl. No. 15/052,456, filed Feb. 24, 2016, Office Action dated Nov. 16, 2017.
“User Interface (UI) Icon Cloud for an OS Application Frequency Presentation” IP.com, IPCOM000199087D, (Aug. 25, 2010), 3 pages.
“A New User Interface Metaphor for Sorting and Filtering Files Using an Accelerometer Equipped Device” IP.com, IPCOM000191481D, (Jan. 5, 2010), 3 pages.
U.S. Appl. No. 14/057,774, filed Oct. 18, 2013, Office Action dated Jul. 30, 2015.
U.S. Appl. No. 14/057,774, filed Oct. 18, 2013, Final Office Action dated Feb. 16, 2016.
U.S. Appl. No. 13/652,337, filed Feb. 3, 2015, Office Action dated Feb. 3, 2015.
U.S. Appl. No. 13/652,337, filed Feb. 3, 2015, Final Office Action dated Aug. 26, 2015.
U.S. Appl. No. 13/652,337, filed Feb. 3, 2015, Notice of Allowance dated Nov. 25, 2015.
U.S. Appl. No. 14/057,774, filed Oct. 18, 2013, Notice of Allowance dated May 11, 2016.
U.S. Appl. No. 15/052,456, filed Feb. 24, 2016, Office Action dated Sep. 10, 2018.
U.S. Appl. No. 15/052,456, filed Feb. 24, 2016, Office Action dated Jun. 13, 2018.
Related Publications (1)
Number Date Country
20160357723 A1 Dec 2016 US
Continuations (2)
Number Date Country
Parent 14057774 Oct 2013 US
Child 15240880 US
Parent 13652337 Oct 2012 US
Child 14057774 US