Source: http://www.patentsencyclopedia.com/app/20130069948
Timestamp: 2017-12-16 11:17:29
Document Index: 257454234

Matched Legal Cases: ['art 300', 'art 300', 'art 300', 'art 400', 'art 400', 'art 400', 'art 400', 'art 400', 'art 800', 'art 800', 'art 400', 'art 400', 'art.\n2012']

SYSTEM AND METHOD FOR PROCESSING AND DISPLAYING DATA RELATING TO CONSUMPTION DATA - Patent application
Patent application title: SYSTEM AND METHOD FOR PROCESSING AND DISPLAYING DATA RELATING TO CONSUMPTION DATA
Inventors: Ron Samuel Dembo (Toronto, CA)
Assignees: Zerofootprint Software Inc.
Patent application number: 20130069948
A system, method and device for processing data are provided. The method comprises: determining a start point and an end point in a set of datapoints; determining a scale for a range of values for the set between the start and end points; determining a first segment in a first subset of datapoints in the set; determining a first boundary for the first segment in the scale; determining a second segment in a second subset in the set; and generating a graphical representation of the datapoints on an output device. The representation includes: an axis for the scale; first and second markers for the first and second boundaries; first and second graphical features representing the first and second segments, the first feature spanning a first length along the axis, the second feature spanning a second length along the axis; and a first indicator for a first datapoint in the set.
1. A method of processing data, comprising: determining a start point and an end point in a set of datapoints; determining a scale for a range of values for said set of datapoints between said startpoint and said endpoint; determining a first segment in a first subset of datapoints in said set of datapoints; determining a first boundary for said first segment in said scale; determining a second segment in a second subset of datapoints in said set of datapoints; and generating a graphical representation of said datapoints on an output device, said representation including an axis for said scale; a first marker for said first boundary; a first graphical feature representing said first segment, said first graphical feature spanning a first length along said axis; a second graphical feature representing said second segment, said second graphical feature spanning a second length along said axis; and a first indicator for a first datapoint in said set of datapoints.
2. The method of processing data as claimed in claim 1, wherein said scale has a plurality of markers that are consistent in scale between said start point and said end point.
3. The method of processing data as claimed in claim 1, wherein: said second length is approximately equal to said first length.
4. The method of processing data as claimed in claim 3, wherein: said second length is approximately equal to said first length; and said range of datapoints of said first segment has a different scale to a range of datapoints in said second segment.
5. The method of processing data as claimed in claim 4, further comprising generating in said graphical representation a second indicator for a second datapoint in said set of datapoints, wherein said second datapoint represents a target value or a historic value for said first datapoint.
6. The method of processing data as claimed in claim 4, further comprising generating a second graphical representation with said graphical representation for a second set of datapoints, wherein said second set of datapoints relates to said consumption data, but for a timeframe that differs from a timeframe associated with said set of datapoints.
7. The method of processing data as claimed in claim 4, wherein: said first graphical feature is provided in a first colour; and said second graphical feature is provided in a second colour.
8. The method of processing data as claimed in claim 7, wherein: said first colour is green; and said first segment represents a range of target values in said set of datapoints.
9. The method of processing data as claimed in claim 4, wherein: said set of datapoints represents consumption data for a resource; and said first datapoint represents real time consumption of said resource at a location.
10. The method of processing data as claimed in claim 9, further comprising: analyzing model data to identify a goal for consumption of said resource at said location; and generating in said graphical representation a second indicator for said goal.
11. The method of processing data as claimed in claim 10, further comprising determining a progression rate to change usage of said resource at said location from said first datapoint to said goal.
12. The method of processing data as claimed in claim 11, further comprising generating control signals to control a device to implement said progression rate.
13. The method of processing data as claimed in claim 12, wherein said goal is based on at least one of time of using savings and a rebate program.
14. The method of processing data as claimed in claim 10, wherein said model data includes goal data based on at least one of time of using savings and a rebate program.
15. A system for processing data, comprising: a first module to process a set of datapoints by determining a start point and an end point in said set of datapoints; determining a scale for a range of values for said set of datapoints between said startpoint and said endpoint; determining a first segment in a first subset of datapoints in said set of datapoints; determining a first boundary for said first segment in said scale; and determining a second segment in a second subset of datapoints in said set of datapoints; a second module to generate a graphical representation of said datapoints for an output device, by generating data for said representation relating to an axis for said scale; a first marker for said first boundary; a first graphical feature representing said first segment, said first graphical feature spanning a first length along said axis; a second graphical feature representing said second segment, said second graphical feature spanning a second length along said axis; and a first indicator for a first datapoint in said set of datapoints.
16. The system for processing data as claimed in claim 15, further comprising a third module to: analyze model data to identify a goal for consumption of said resource at said location; and generate additional data for said graphical representation for a second indicator for said goal.
17. The system for processing data as claimed in claim 16, wherein: said second length is approximately equal to said first length; and said range of datapoints of said first segment has a different scale to a range of datapoints in said second segment.
18. The system for processing data as claimed in claim 17, wherein said second module: generates data to produce said first graphical feature in a first colour; and generates data to produce said second graphical feature in a second colour, wherein said first segment represents a range of target values in said set of datapoints.
19. The system for processing data as claimed in claim 18, wherein said data and said additional data for said graphical representation is provided to said output device, said output device being a display associated with a device in communication with said system.
20. The system for processing data as claimed in claim 16, further comprising a fourth module to utilize said goal and said first datapoint to control operation parameters of one device at said location.
[0001] The disclosure relates generally to a system and method for retrieving, processing and displaying data, with a particular implementation that processes resource consumption data.
[0002] In prior art data processing and analysis tools, data can be analyzed and shown in a graphical form with a particular data point being shown within a range of values, for example, in an x-y graph. Existing data processing and analysis tools generate graphics that, while accurate, do not quickly convey relative information regarding a data point against various range(s) of data.
[0003] There is a need to address deficiencies in the prior art.
[0005] FIG. 1 is a schematic diagram of a network with a server and a device providing data analysis according to an embodiment;
[0006] FIG. 2 is a block diagram of the server and device of FIG. 1 according to an embodiment;
[0007] FIG. 3 is a flowchart of a data process executed by the server of FIG. 1 according to an embodiment;
[0008] FIG. 4 is a flowchart of a data visualization process executed by the server of FIG. 1 according to an embodiment;
[0009] FIG. 5 is a first representative data visualization output generated by the server of FIG. 1 according to an embodiment;
[0010] FIG. 6 is a second representative data visualization output generated by the server of FIG. 1 according to an embodiment;
[0011] FIG. 7 is a third representative data visualization output generated by the server of FIG. 1 according to an embodiment; and
[0012] FIG. 8 is a flowchart of a data scenario process executed by the server of FIG. 1 according to an embodiment.
[0013] The description which follows and the embodiments described therein are provided by way of illustration of an example or examples of particular embodiments of principles of the present disclosure. These examples are provided for the purposes of explanation and not limitation of those principles and of the disclosure. In the description which follows, like parts are marked throughout the specification and the drawings with the same respective reference numerals.
[0014] An embodiment generally provides a system, method and device for retrieving, processing and displaying data, with an implementation that processes resource consumption data in a set of datapoints. One feature of an embodiment generates visual representations of consumption data for a datapoint in the set with visual cues providing comparisons to consumption data of one or more peers in the set. As part of that feature, the visual representation can provide a scale indicating a total range of values for the datapoints in the set (e.g. from a minimum to maximum value(s)) and an indicator of relative usage values (e.g. visual cues indicating distributions of values within the set).
[0015] In a first aspect, a method of processing data is provided. The method comprises: determining a start point and an end point in a set of datapoints; determining a scale for a range of values for the set of datapoints between the startpoint and the endpoint; determining a first segment in a first subset of datapoints in the set of datapoints; determining a first boundary for the first segment in the scale; determining a second segment in a second subset of datapoints in the set of datapoints; and generating a graphical representation of the datapoints on an output device. The representation includes: an axis for the scale; a first marker for the first boundary; a first graphical feature representing the first segment, the first graphical feature spanning a first length along the axis; a second graphical feature representing the second segment, the second graphical feature spanning a second length along the axis; and a first indicator for a first datapoint in the set of datapoints.
[0016] In the method, the scale may have a plurality of markers that are consistent in scale between the start point and the end point.
[0017] In the method, the second length may be approximately equal to the first length; and the range of datapoints of the first segment may have a different scale to a range of datapoints in the second segment.
[0018] The method may further comprise generating in the graphical representation a second indicator for a second datapoint in the set of datapoints. For the method, the second datapoint may represent a target value or a historic value for the first datapoint.
[0019] The method may further comprise generating a second graphical representation with the graphical representation for a second set of datapoints. For the method, the second set of datapoints may relate to the consumption data or other data, but the second set of datapoints may relate to a timeframe that differs from the timeframe associated with the first set of datapoints.
[0020] In the method, the first graphical feature may be provided in a first colour; and the second graphical feature may be provided in a second colour.
[0021] In the method, the first colour may be green; and the first segment may represent a range of target values in the set of datapoints. Alternatively, the first segment may represent actual values.
[0022] In the method, the set of datapoints may represent consumption data for a resource; and the first datapoint may represent consumption of the resource at a location. Alternatively, the set of datapoints may represent cost or emission data for a resource.
[0023] The method may further comprise: analyzing model data to identify a goal for consumption of the resource at the location; and generating in the graphical representation a second indicator for the goal or historical data.
[0024] The method may further comprise determining a progression rate to change usage of the resource at the location from the first datapoint to the goal.
[0025] The method may further comprise generating control signals to control a device to implement the progression rate.
[0026] In the method, the goal may be based on at least one of time of using savings and a rebate program.
[0027] In the method, the model data may include goal data based on at least one of time of using savings and a rebate program.
[0028] In a second aspect, a system for processing data is provided. The system comprises a first module to process a set of datapoints and a second module to generate data for the representation. The first module determines a start point and an end point in the set of datapoints; determines a scale for a range of values for the set of datapoints between the startpoint and the endpoint; determines a first segment in a first subset of datapoints in the set of datapoints; determines a first boundary for the first segment in the scale; and determines a second segment in a second subset of datapoints in the set of datapoints. The second module generates data for the representation relating to an axis for the scale; a first marker for the first boundary; a first graphical feature representing the first segment, the first graphical feature spanning a first length along the axis; a second graphical feature representing the second segment, the second graphical feature spanning a second length along the axis; and a first indicator for a first datapoint in the set of datapoints. A third segment may optionally be provided.
[0029] The system may comprise a third module to: analyze model data to identify a goal for consumption of the resource at the location; and generate additional data for the graphical representation for a second indicator for the goal.
[0030] In the system the second length may be approximately equal to the first length; and the range of datapoints of the first segment may have a different scale to a range of datapoints in the second segment.
[0031] In the system, the second module may: generate data to produce the first graphical feature in a first colour; and generate data to produce the second graphical feature in a second colour. For the system, the first segment may represent a range of target or actual values in the set of datapoints.
[0032] In the system, the data and the additional data for the graphical representation may be provided to the output device. The output device may be a display associated with a device in communication with the system.
[0033] The system may further comprise a fourth module to utilize the goal and the first datapoint to control operation parameters of one device at the location.
[0034] In other aspects, various combinations of sets and subsets of the above aspects are provided.
[0035] Now, a description is provided of general features of an embodiment through an exemplary system implementing same through a server in communication with a device over a network. Thereafter a description is provided on details of an embodiment.
[0036] FIG. 1 shows system 100 where network 102 provides data and control communications between elements connected thereto, including server 104 and device 106. User 108 is located at device 106 can operate same and can see any output generated at its display (not shown). In this embodiment, server 104 provides data collection, storage, processing and analysis features of an embodiment. Database 110 is connected to server 104 and provides a repository for data for server 104. Device 106 is configured to access server 104, initiate commands for server 104 to conduct analysis on data from database 110 and process the data and generate graphical representations of aspects of the data analysis on its display for viewing by user 108.
[0037] Network 102 can be implemented in any known architecture, providing wired and/or wireless connections to its elements, and including one or more interface servers (not shown) that may allow network 102, and its elements, to be in communication with other networks and their elements. Network 102 may be implemented as a local area network (LAN) that provides local wired connections to its elements. Network 102 may be connected to the Internet (not shown) via an interface server (not shown). Network 102 may also be a Wi-Fi network generally following standards set by the IEEE LAN/MAN Standards Committee, known as IEEE 802, through its working group "11". Security features may be provided by network 102. For example, access to its systems may be provided through secure protocols/links, e.g. through a Hypertext Transfer Protocol Secure (HTTPS) scheme.
[0038] With features of exemplary network 102 and selected elements provided, further detail is provided on server 104 and device 106. Each is described in turn.
[0039] For server 104, FIG. 2 illustrates details of its internal components. In an embodiment, server 104 is a processor-based computing platform. It may have the form factor of a rack-mounted, desktop or laptop computer. It may be a minicomputer. It may be a virtual computing device comprising processing modules that are installed on one or more devices.
[0040] Within server 104, there is processor 202, memory 204, input system 206, output system 208, and storage system 210. Processor 202 controls the overall operation of server 104 through instructions provided to it that are typically stored in its memory 204 and/or storage system 208. Exemplary processors for processor 202 may include "x86"--compatible processors (trade-mark) available from Intel Corporation. Memory 204 may be dynamic random-access memory, flash memory or other volatile and non-volatile storage devices. Controlling overall operating of processor 202 (and as such, server 104), an operating system (OS) is provided that may be stored in memory 204. An exemplary OS is Windows Server (trade-mark) by Microsoft Corporation.
[0041] Software modules 212 provide a series of program instructions to execute various commands on processor 202. Such modules are typically stored in either memory 204 and/or storage system 210. In an embodiment, software modules include data capture module 212A, data analysis module 212B, data visualization module 212C, data scenario module 212D and control module 212E. Further details on these software modules are provided below.
[0042] Input system 206 is part of a class of components for receiving data input by server 104. Input system 206 may a keyboard, mouse device, trackball, touchpad, touch screen, microphone, accelerometer, lightpen or other device. Input system 206 may also include a component that receives data over network 102 or via application programming interfaces (APIs). Input system 206 may also include a component configured to receive electronic data from a monitoring device, such as a utility meter, smart meter, water meter, volt meter, amperage meter, light meter, wind meter, hydrometer, etc. Input system 206 may be an indirect data capturing system. For example, system 206 may be camera that records images of a meter, capturing changes in its readings. Processes may then be provided to analyse the images and extract the data readings from them.
[0043] Output system 208 may be a component for transmitting data to an internal or external component or device to server 104. Output system 208 may include a display, speaker or printer. Output system 208 may also include a network component configured to transmit data to an external device, through a connection and/or through network 102. Output system 208 may also include a component configured to transmit data directly to another device, such as a laptop computer directly connected to output system 208.
[0044] Storage system 210 stores data and may be internal to server 104; it may be comparable to storage 110 (FIG. 1). Alternatively, storage system 210 may be external to server 104. Where storage system 210 is external to server 104, storage system 210 may be in direct communication with server 104 or in communication with server 104 via a network (not shown), such as a LAN. Storage system 210 may comprise any type of appropriate physical storage medium, such as hard drives and/or flash memory. Access to data in storage system 210 may be controlled through software operating system on and/or through system 210, such as through a database application, such as Access (trade-mark) or SQL.
[0045] Turning now to device 106, it has similar components to server 104. As such, FIG. 2 may be used to represent corresponding components of device 106. Again, device 106 is a processor-based electronic computing device. It may by a computer, laptop computer, minicomputer, tablet computing device, smart phone, personal digital assistant (PDA) or other computing device. Device 106 may have internal components that are analogous to internal components of server 104, including processor 202, memory 204, input system 206, output system 208 and storage system 210. In particular, device 106 may comprise a network component (as part of its input system 208) for receiving a data from server 104 and display and/or print as part of its output system 208.
[0046] In another embodiment, server 104 and device 106 may comprise a single device, and in such embodiments.
[0047] Now, with components of system 100 disclosed, further detail is provided on exemplary processes and methods for processing and generating visual representations of data by an embodiment.
[0048] First referring to FIG. 3, flow chart 300 shows an exemplary data capture process in receiving data by an embodiment. It may be executed or controlled in whole or in part by server 104. Therein, data capture module 212A (FIG. 2) may provide programming code for execution on processor 202 (FIG. 2) to effect execution of the process. The process may also operate in whole or in part on device 106.
[0049] As noted above, an embodiment generates visual representations of data, in particular consumption, cost or emission data. Such data can be provided from any data capturing device (e.g. a smart gas meter, smart electric meter, utility meter, water meter, volt meter, amperage meter, light meter, wind meter, volatile organic compound (VOC) sensor, oxygen sensor, carbon dioxide sensor, air quality sensor etc.) or any data source (e.g. tabular data such as historic daily temperature readings, daily resource consumption data, etc.). Data can be collected and stored at a central or distributed system through network 102. Transmitted data can contain a data value and additional information (e.g. information relating to the source of the data, the entity generating the data, the location, time, ambient conditions, etc.). The data may relate to usage data from utility bills, data received from utility meters, bulk information received from third-party databases or data submitted by third-parties via an API made available by input system 206.
[0050] The data may reflect instantaneous usage data, data gathered over a time period, change data, rate of change data, projection data of usage or other values. For instance, the data may indicate a rate of water usage every hour, on the hour, for a particular household, the data being a negative or positive value representing the difference in rate for the present point in time, as compared to an earlier point in time. Additional data that may be provided includes identifying information about the data source, e.g. serial number of device, street address for house for meter, size information for house, weather data for the day, utility prices for the day, etc.
[0051] Next at process 306, the data is processed and stored. This may involve tagging the data with a timestamp and source details and may involve storing the data in a certain section of database 110. Some data may be discarded without being stored, for example, if the data is out of range, corrupted, inconsistent, erroneous or invalid. In one embodiment, the received data is converted into standardized units before storage. For example, data capture module 212A may receive data comprising a first household's usage of natural gas in cubic feet over the course of every hour, and a second household's usage of natural gas as an instantaneous rate in litres/minute, at the start of every minute. Data capture module 212A may convert this data into pre-determined standardized units, such as cubic meters per day, including by applying standard estimation techniques such as interpolation or extrapolation, as necessary.
[0052] Once the received data is stored, it may be accessed as a data element from database 110. For the purpose of convenience and not limitation, a stored data element in database 110 per flow chart 300 may be referred to as a datapoint. Database 110 contains multiple different datapoints. A collection of datapoints (grouped by applicable parameters), is referred to herein as a dataset for the purpose of convenience and not limitation. There may be multiple datasets within database 110. Flow chart 300 ends at process 306.
[0053] Next, referring to FIG. 4 flow chart 400 shows an exemplary data analysis process for analyzing captured data by an embodiment. Again, the process is described as operating on server 104, but it may also operate in whole or in part on device 106. For server 104, data analysis module 212B (FIG. 2) may provide programming code for execution on processor 202 (FIG. 2) to effect execution of the process. One or more servers 104 and/or devices 106 may maintain a web site that produces visual representations of datasets based on inputs provided to the web site. Such a web site may be accessed by any device connected to the Internet. One or more processes of flow chart 400 may be executed on a "thin" or a "thick" client in network 102, depending on computing power, storage capacity and/or network connections of the client.
[0054] The process starts at process 402, which may be initiated on a periodic basis (e.g. once an hour, once a day, every night, etc.) and/or on an event basis, such from a request from an external device, such as device 106 or from a software module operating on server 104 and/or device 106. As part of start process, a set of parameters for a visualization request are provided. The parameters may have been preset, as a default, or may be provided with the request itself. A graphical user interface (GUI) may be provided on device 106 showing an interface on its display providing options and fields for user 108 to define the parameters for the request.
[0055] At process 404, parameters from the request are used to determine what data is extracted. As an example, the parameters may include one or more of: a time boundary (e.g. data from today, last hour, this spring, this year, last year, etc.); a device reading identifier (e.g. readings from one or more power meters from a first residence, power meters, carbon meters, water meters, wind meters, temperature meters, humidity meters, barometers, etc.); a geographic/location boundary (e.g. reading from one residence, residences in a city block, residences in a postal code, a cottage, an industrial complex, one or more rooms within a building, one or more specified industrial plants, etc.) and other ad hoc parameters (e.g. only meters of a particular brand).
[0056] A database command is built from the request and its parameters and a database query is sent to a target database, such as database 110, to retrieve a dataset populated with records in the database that match the request.
[0057] Next at process 406, the retrieved dataset is processed. Part of the processing may include filtering the data. This may be an optional process. Filtering may eliminate extraneous datapoints in the dataset. For example, filtering may eliminate datapoints that are above and/or below a threshold, or that are outside a given time or geographic parameter. The filter parameters may be set in the search parameters and/or there may be a default set of filtering parameters accessed by the system.
[0058] The retrieved dataset may contain data from multiple sources relating to different consumption or usage data over a particular time period. Part of the filtering may include making adjustments to the dataset to level, normalize and/or localize the data.
[0059] Levelling adjusts the dataset to correct for different coverage of different data sources, to facilitate comparison of datapoints. For example, if the dataset includes consumption data for a source over a particular time period, in some circumstances, consumption data for that time period may not be available from other sources. As such, the dataset may be filtered to utilize datapoints that are complete over a time period for all sources. Alternatively, values for missing or incorrect values may be interpolated or extrapolated from similar data.
[0060] Normalizing data adjusts the dataset so that comparisons can be made for different data sources. As such, readings for a site spanning a number of days/weeks/seasons can be normalized to unitized values to allow them to be more easily compared. Also, readings from different locations can be normalized to unitized values to allow them to be more easily compared. For example, a dataset may include consumption data for a time period from multiple sources. In some circumstances, the sources may have different attributes that may affect consumption values. For example, a data source may correspond to a household with multiple occupants, whereas another data source may correspond to a household with a single occupant. The dataset may be adjusted so that consumption usage is calculated on a per household occupant basis. Data for differently sized locations can be normalized to a per square foot/meter basis to allow comparison. Normalizations can performed to include more than one factor (e.g. data can be recalculated to be presented on a per square foot and a per occupant basis).
[0061] As part of normalizing consumption data, a balance point is used, representing a `normal` value for a factor relating to the data. For example for energy consumption data relating to heating a building, the balance point for heating a building can be a baseline building temperature at which the building does not need to be heated internally. If the building temperature is above that baseline, then the building does not require internal heating. The building temperature can include readings from external temperatures, internal ambient temperature and/or the temperature of the frame of the building. In a given winter, a building's heating balance point may be constant, but the heating may be activated for longer or shorter periods over the winter depending on the outdoor temperature. The difference between the current building temperature and the balance point can be used as a factor in normalizing the data. Additional factors can be provided once the difference is calculated. When the heating consumption data is normalized, extra energy usage for heat on colder days can be normalized against less energy usage for heat on warmer days. Comparable normalization calculations can be provided for energy usage for cooling a building.
[0062] Localization adjusts values of the datapoints to correspond to a particular user's actual or predicted preferences. For example, values may be stored in storage system 210 in standardized units such as cubic meters, whereas if system 100 is aware that user 108 is located in the United States, data analysis module 214 may adjust all values to be in cubic feet, instead of cubic meters. Other types of localization adjustments that adjust and/or normalize the dataset may be provided. Localization may adjust values in the dataset to local parameters (e.g. the local time zone, the local currency, etc.).
[0063] As another example, datasets may be filtered to take into account weather or seasonal effects. Adjustments may also be made for a given data source in view of a change to the data source over a period of time. For example if a household replaces its furnace then an adjustment may be made for consumption data before the replacement. It will be appreciated that other filtering and adjustments can be made.
[0064] The retrieved dataset may be filtered to account for any permission levels of the entity making the request. For example, the request from process 404 may originate from a school and the target analysis may be for energy usage of the school against its peers. The extracted dataset may collect energy usage records for all schools in a relevant district. The filtering may then identify the relevant peers (based on school board information, postal codes, etc.). Filtering may also remove outliers from the retrieved dataset. For example, data records that do not show any usage of electricity could be removed from a data set on the basis that such data records are clearly outliers, and unlikely to be accurate data.
[0065] In some instances, the data may contain multiple values directly related to consumption or usage. For example, a data record may indicate for a particular household and a particular time period both usage of electricity and natural gas during that time period. With such data, a sort/filter may be applied to extract the relevant datapoint(s).
[0066] It will be appreciated that any of the filtering processes described herein may be conducted by either server 104 and/or device 106. In some instances, such processes may be conducted at any time prior to generation of the visual representation of the dataset.
[0067] Upon completion of the filtering processes, next at process 408, the filtered dataset is analyzed. In one embodiment the data is analyzed to identify segments in the dataset which can be used to indicate notable parts of the dataset when a visual representation of the dataset is generated. As part of the analysis one or more of the following determinations may be made, in any order.
[0068] A first determination may be to identify boundaries of the dataset, per process 408A. This may include identifying the start and end datapoints. The parameters for the endpoints may be based on time parameters (e.g. start and end times) or value parameters (e.g. minimum and maximum values). A scale may be determined for the range of values for datapoints between the start and end datapoints. This may have been done at the filtering process. With a scale and one or more endpoints determined for the dataset, a range of values can be established for the dataset when a visual representation is made of it.
[0069] A second determination may be to identify one or more segments and their boundaries with the dataset, per process 408B. A segment is a section of the dataset and the two terms can be used interchangeably. One segment or multiple segments may be provided in a dataset. Generally, the segments are sequential, but they do not have to be. A gap may or may not separate segments. The number of segments can be used to group datapoints together (e.g. datapoints above, below or within certain ranges). When a visual representation of the dataset is produced by an embodiment, each segment can be displayed in a contrasting manner to the other segment to visually distinguish the segments from each other. This provides a visual cue to the viewer as to a distribution of datapoints in the dataset. The boundaries for each segment divide the segments into equal parts or non-equal parts. Further detail is provided on the segment determination below.
[0070] A third determination may be to identify a location of a specific datapoint in the dataset, per process 408C. As noted above, the dataset may have one or more segments. When a visual representation of the dataset is produced by an embodiment, a value of a target datapoint will determine in which segment it is shown. For example, for an exemplary dataset of meter readings for houses within a city block, meter data for a particular house can be selected. That meter reading's value is shown by an indicator in a visual representation for the meter readings of the city block. This provides a visual cue in the representation of the relative location of that house's meter readings compared to aggregate readings for that block.
[0071] Other analyses and determinations for the dataset can be performed in process 408 to complete the data analysis. It will be seen that that an embodiment transforms raw data into a filtered and refined dataset that can be used to generate reports (both on a display and/or as a physical output from a printer). The refined dataset can be used as a basis for providing feedback data that can be used to control a downstream system (e.g. lights, water usage, allocation of resources, etc.).
[0072] Next, at process 410 a visual representation of the dataset is produced using the dataset, the boundaries of the dataset, the segments and the location of a given datapoint and any other parameters that have been provided. Any device having access to a dataset (e.g. server 104 and/or device 106) can generate the visualization. The visualization can be generated on a display of a device (e.g. at device 106, server 104 or a remote device to network 102). For server 104 or device 106, data visualization module 212C (FIG. 2) may provide programming code for execution on processor 202 (FIG. 2) to effect execution of the process.
[0073] Flow chart 400 ends at process 412.
[0074] Now further detail is provided on visual representations of datasets provided by an embodiment. Per process 410, an embodiment utilizes the dataset to provide a graphical representation of same. An embodiment can provide a plurality of different visual representations, provided as graphical forms. Exemplary representations are described in FIGS. 5, 6 and 7. Each is discussed in turn.
[0075] FIG. 5 shows a first exemplary visual output in the graphic form of gauge 500, which may be generated on an output device such as a display and/or a printer. An exemplary dataset used to produce gauge 500 is provided in Table A:
TABLE-US-00001 TABLE A Datapoint Value Note N datapoints values between 0 and "Best consumption" range 3,768 Current household 2,600 Current household usage Target household 1,256 Target household usage M datapoints values 3,768 and 8,607 "Acceptable consumption" range O datapoints values 8,607 and "Excessive consumption" 155,672 range P datapoints values over 155,672 Data out of range
[0076] For an example, gauge 500 shows datapoints relating to energy consumption of homes in a city block. The total number of datapoints would be N+M+O+P. In one embodiment, gauge 500 has a form of a semi-circle, mimicking a layout of a speedometer. Startpoint 502A is located at the bottom left edge of the bottom of gauge 500, representing the lowest range of data in the dataset. Endpoint 502B is located at the bottom right edge of the bottom of gauge 500, representing the highest range of data in the dataset (namely data having values below 155,672). Scale 504 is located along the perimeter of the semicircle and represents an axis against which datapoints in the set are plotted. Scale 504 also indicates datapoints between the lowest and highest ranges. Markers for specific values in the dataset may be provided on scale 504. It will be appreciated, while gauge 500 appears to be a two dimensional form, the datapoints are effectively in a tabular, one dimensional form, where all datapoints reflect a certain meter reading.
[0077] As noted in data analysis process 408C (FIG. 4), segments have been defined for the dataset. The segments can represent one or more segments, dividing the dataset into halves, thirds, quarters, fifths, etc., with each segment being approximately the same size in the visual representation. For gauge 500, an exemplary parameter for process 408C has determined that there will be three segments of approximately equal size (in terms of visual area in gauge 500). As such, boundary 510A at datapoint "3,768" shows a boundary between the first (lowest) third and the middle third for values in the dataset. Boundary 510B at datapoint "8,607" shows a boundary between the middle third and the highest third for values in the dataset. In calculating a value for a boundary values, data analysis module 212A may determine boundary values using statistical analysis tools and calculations, including distribution analysis tools. Such analysis may identify boundaries based on average values, population distribution values (e.g. to identify boundaries where one third of the values are in the lowest third, one third are in the middle third and one third are in the upper third). The boundaries are shown along the axis of scale 504.
[0078] Gauge 500 shows the defined segments and their boundaries. For an example where a dataset has three segments, gauge 500 shows three segments 508A, 508B and 508C. Segments 508A and 508B are separated by boundary 510A and segments 508B and 508C are separated by boundary 510B. For ease of identifying segments, different graphical features are used to visually differentiate the segments from each other. In one embodiment, the number of datapoints in each segment is the same or almost the same. Colours can be used to show different segments to provide a visual cue for the relative locations of data within the dataset. Here, segment 508A is shown in green; segment 508B is shown in yellow and segment 508C is shown in red. As such, a "green-yellow-red" colour scheme provides a "go-caution-stop" visual analogy that a viewer can understand and interpret information provided in gauge 500. Each segment can represent a different relative state its datapoints. Datapoints in a "green" segment can represent values having an ideal, target, best and/or preferred value (e.g. least consumption, most efficient, etc.); datapoints in a "yellow" segment can represent values having an acceptable value (e.g. within an average, etc.); and datapoints in a "red" segment can represent values having a non-ideal, worst or least preferred value (e.g. most consumption, least efficient, etc.). Representations and ranges of values may be defined based on the types of data in the datapoints, the number of datapoints, target usage conditions (e.g. based on laws and regulations, such as vehicle emissions regulations) and other factors. Other graphical features can be provided to differentiate segments, e.g. black-white, white-grey, green-red (indicating "go/stop"), rainbow colour schemes, different background patterns in segments (e.g. dots, stripes, stippled lines, etc.), different labels provided for different segments, etc.
[0079] Values for the scales and additional marking for graph 500 may have been determined during localization, described above for process 406 (FIG. 4). In one embodiment localization is conducted at server 104 (FIG. 1). In another embodiment, localization is done at device 106 (FIG. 1). Localization can include providing markings for values that adhere to local idioms. For example, either a period "." or a comma "," can be used to separate the integer portion of a number from its fractional portion, depending on whether North American or European number marking conventions are used. Similar localization changes may be made to the data to for time, date (e.g. MM/DD/AA or DD/MM/AA formats) and currency idioms.
[0080] Other distributions can be provided where there is a segment indicating a preferred range in the dataset and on either side of the preferred range, adjacent segments sequentially less preferred. As such, the colour scheme may have a middle green segment and outward segments appear from yellow to red. Other distributions may have multiple preferred ranges.
[0081] The visual presentations can be augmented to show additional data in two and three dimensions. A two dimensional representation may introduce another parameter on another axis (e.g. time or location). For example additional "slices" of gauge 500 may be shown stacked against gauge 500 showing different usage snapshots at different times for the city block or showing different usage snapshots for different city blocks at a given time. A three-dimensional representation may introduce two parameters on two additional axes (e.g. axes showing time and location).
[0082] Returning to a basic one-dimensional representation in gauge 500, scale 504 can be linear, non-linear or linear in sections and non-linear in other sections, so that the scale values along scale 504 differ in different sections. Values for such sections can be based in part on the number of segments defined. Markers 506 show values along scale 504 in major and minor increments. In this representation, scale 504 is linearly scaled within each segment 508. For example, in segment 508A markers are calibrated to be approximately 1,256 units apart; in segment 508B markers are calibrated to be approximately 1,613 units apart; and in segment 508C markers are calibrated to be approximately 49,022 units apart. Notably, among the three segments for this exemplary dataset, there is no linearity of calibrations.
[0083] Gauge 500 shows an exemplary graphical representation where each segment 508A, 508B and 508C in gauge 500 is approximately of equal size, where each segment spans approximately the same length along the axis of scale 504. However, as noted above each segment may not show an equal range of datapoints along scale 504: each segment covers a range of datapoints in the dataset that may not be linear to a range of datapoints in another segment. For example, while segments 508A, 508B and 508C are approximately of the same size, segment 508A shows to a portion of scale 504 for datapoints having values between 0 and 3,768, segment 508B corresponds to a portion of scale 504 for datapoints between 3,768 and 8,607 and segment 508C corresponds to a portion of scale 504 for datapoints between 8,607 and 155,672. In other embodiments, markers 506 along scale 504 may be presented in different colours, fonts and/or emphasis (e.g. bold, italics) to indicate the different segments.
[0084] It will be appreciated that segments 508 and scale 504 of gauge 500 provide an indication of an overall distribution of datapoints within a dataset. Gauge 500 also provides an indication of the location of a particular datapoint within the distribution, through indicator 512. As scale 504 shows a range of datapoints in the collected dataset, indicator 512A provides a visual marker noting a value in scale 504 for a particular datapoint. In gauge 500, indicator 512A is presented as a needle within the speedometer paradigm of gauge 500. Other forms for indicators can be provided (such as a box marker along scale 504). Indicator 512A "points" to a value of around 2,512, representing the energy usage for the "current household" within the block of houses, per Table A. An embodiment also provides a second indicator 512B on gauge 500 that can be used to mark a second value in scale 504. The second value may represent a goal, target and/or historic datapoint (e.g. energy usage for the house last week). Here, the second value represents a Target Household's consumption level, per Table A.
[0085] As noted, gauge 500 is shown as a speedometer. In other embodiments other forms of speedometers can be provided. For example, other speedometers can be circular, rectangular, square, oval or linear. General characteristics of a speedometer are that there is a scale having values identified thereon than progress from a first value to a higher value or from a first value to a lower value. The progression may or may not be linear. As noted above, on the speedometer, segments for datapoints can be identified an indicator can be provided showing a current value of a target datapoint. The location of the indicator may be updated periodically depending on updates to the dataset.
[0086] FIG. 6 shows a second exemplary visual output in the graphic form of gauge 600. Again, as an example, datapoints for energy usage of houses in a city block are analyzed. Gauge 600 has comparable elements to gauge 500 (FIG. 5), including startpoint 602A, endpoint 602B, scale 604, three segments 608A, 608B and 608C, boundaries 610A and 610B and indicators 612A and 612B.
[0087] In one embodiment, each segment has an equal number (or close to equal number) of datapoints to one or more or all of the other segments. If one datapoint moves from one segment to another, one datapoint may be moved out so that the number of datapoints remains equal. This also allows the bar to be moved up as the consumption decreases.
[0088] One difference between gauge 600 and gauge 500 is that in gauge 600, scale 604 is shown as a linear scale from startpoint 602A to endpoint 602B. In other embodiments, scale 604 may show units in a logarithmic or exponential scale. As such depending on boundary definitions for segments 608, segments 608A, 608B and 608C may have different sizes and boundaries 610A and 610B may be located along scale 604 to reflect those different sizes. As shown, segment 608B is larger than segment 608A, which is larger than segment 608C. As such, since segment 608B is the largest, segment 608B shows that it has the widest dispersion of datapoints for the segments.
[0089] In another embodiment, segments may have different numbers of datapoints among themselves. The size of a segment may reflect the relative number of datapoints within that segment.
[0090] FIG. 7 shows a third exemplary visual output in the graphic form of gauge 700, shown as a thermometer. Again, as an example, datapoints for energy usage in a city blocks are analyzed. Gauge 700 has comparable elements to gauges 500 and 600 (FIGS. 5 and 6), including startpoint 702A, endpoint 702B, scale 704, three segments 708A, 708B and 708C, boundaries 710A and 710B and indicators 712A and 712B. The values on scale 704 may be non-linear (per FIG. 5) or linear (per FIG. 6).
[0091] In other embodiments, output of an analysis of the datapoints may be represented in other graphical forms, such on a line graph, in a pie chart, in a bulls-eye chart, in two- and three-dimensional charts (e.g. a chart having time as one dimension in addition to the usage charts) or other forms. Data may also be presented in a tabular form, where sections of a table may be highlighted to show segments and indicators.
[0092] With exemplary visual representations described, features relating to another aspect of an embodiment that provide data modelling for different scenarios are described. It is noted that flow chart 400 (FIG. 4) provides analysis of a dataset comprising consumption data from a plurality of data sources. As such, the analysis in flow chart 400 provides information on a how a particular datapoint compares a dataset in a certain population. An embodiment also provides a data scenario tool, which can access model data and generate different scenarios for a given dataset. The scenarios may relate to models for consumption, usage, emission targets and/or other requirements. Rebate information may be incorporated into the scenario data. For example, one consumption program may provide additional rebates on consumption rates when target consumption savings are achieved. "Time of use" information may be incorporated into the scenario data. For example, different cost rates may apply to a consumable (e.g. water, electricity) depending on when it is consumed (e.g. during the working day, during weekends, at night, etc.). Scenarios may be developed and presented that estimate consumption or usage for a consumable based on a dataset. As such the scenarios may represent other datapoints that are not necessarily based on data from peers. This scenario data may be used to augment a visual representation of a dataset generated by data visualization module 212C.
[0093] Referring to FIG. 8, flow chart 800 shows an exemplary data scenario generation process which may be provided by server 104 (FIG. 1). Therein, data scenario module 212D (FIG. 2) may provide programming code for execution on processor 202 (FIG. 2) to effect execution of the process. The process may also operate in whole or in part on device 106. In illustrating features of flow chart 800, an exemplary dataset relating to energy usage of a house within a city block is used.
[0094] The process is initiated at start process 802, which may be initiated by device 106 after receiving a request from device 106 through user 108. At process 804, a dataset is obtained and analyzed. Process 804 may incorporate one or more functions of processes in flow chart 400 (FIG. 4), including processes 440, 406 and 408. The dataset may be adjusted to filter, sort, localize, level and/or normalize the dataset to provide a calibrated dataset. Adjustments may be made to reflect its minimum and maximum values and comparable adjustments may be made to its scale (504, FIG. 5) when a visual representation is generated.
[0095] Next, at process 806, scenario data is obtained. Scenario data may be stored in database 110. Scenario data may model different hypothetical or actual performance targets or traits for a dataset. For example, a scenario may include target usage data relating to consumption targets, emission targets, cost targets, rebate offers, time of use charges for utilities, tariff charges on excess usage and other goals and/or targets. Scenario data may relate to a particular data source (e.g. a given building) and may reflect changes implemented at the source (e.g. installing high-efficiency lighting, replacement of water heater, additional of new wing).
[0096] Scenario data may provide data reflecting effects of such change(s). The data may show differences (e.g. in saved consumption/emissions/costs and/or additional consumption/emissions/costs) that are projected as a result of such change(s). Changes may be show over different time periods (e.g. short term and long term), with a projected "payback" time incorporated.
[0097] When an embodiment determines a difference, the results may be displayed in a "raw" form, where basic difference information is displayed. For example, if the difference is determined to be a savings of 100 litres of gasoline, the result may simply state "100 litres of gasoline are saved" or a comparable message. However, an embodiment also provides a facility to provide an analogous report to the raw data where the raw data is converted to a second set of units and that may be further converted to a suitable paradigm using the second units. For example, if the raw data indicates a certain amount of gasoline that is used, an analogous report may convert the gasoline units to units related to carbon emissions. The conversion is based on how many units of gasoline produce a unit of carbon emission. Then the savings may be expressed in terms of carbon savings. Further the amount of carbon savings can be further converted to other paradigms associated with carbon usage. For example, the total amount of carbon emissions saved can then be converted to units such as an equivalent number of cars that would be removed from the streets that would have produced the calculated carbon emissions saved. It will be seen that other conversions can be provided. As an exemplary non-exhaustive list, the following units can be converted among each other, provided that a suitable conversion rate is provided: energy consumed/saved, electricity consumed/saved, carbon generated/saved, costs, payback time, heat generated/saved, water consumed/saved and others. Conversions can be provided through one or more conversion steps among units.
[0098] Next, at process 808, the scenario data is integrated with the dataset. The scenario data may define one or more boundaries (510, FIG. 5) for the dataset, based any goals or limits defined for the selected scenario.
[0099] With the above noted processes, a scenario dataset can be analyzed and segmented in a similar fashion to a population consumption dataset, described earlier. As such, a visual representation of a scenario dataset may also be generated.
[0100] At process 810, a visual representation of the scenario data is produced. Process 810 may incorporate one or more functions of processes in flow chart 400 (FIG. 4), including process 410 to generate a graphical representation, such as any representation shown in FIGS. 5-7.
[0101] In addition to the speedometer visual representation, an embodiment may display results in other graphical representations. For example a series of line graphs can be provided with multiple graphs generated thereon. The X-axis can represent time units (e.g. days) and the Y-axis can represent a consumable (e.g. energy used/saved). In one embodiment, one graph can be provided to plot current energy usage for a subject entity (e.g. a building) as calculated. A second graph can be provided to plot current energy usage for a group of entities relating to the subject entity (e.g. buildings in a block). A third graph can be provided to plot the current energy usage for another group of entities (e.g. best buildings in the dataset). Other plots can be provided.
[0102] The embodiment also provides direct control of function(s) of an entity being evaluated. For example for energy usage for a building, the embodiment can provide for direct and/or scheduled control of one or more operational components in the building (e.g. lights, heat, HVAC, etc.).
[0103] Also, for the graphical representation, when a target indicator is provided, an embodiments also provides an ability to change the setting of the target indicator (e.g. indicator 512B, FIG. 5), by dragging and changing the indicator directly through the GUI. As the indicator changes, this may have an effect on the current operating characteristics of the consumable/emission/cost being plotted. An embodiment may provide a direct feedback control to change operating characteristics of one or more components relating to the data being plotted. Again, for example, for energy usage for a building, changing the target indicator (or another indicator) may cause a change in one or more operational components in the building (e.g. lights, heat, HVAC, etc.).
[0104] For the scenario data, once the scale and segments are determined for its visual representation, then a particular datapoint for a consumed resource at a particular location may be mapped onto the representation. Once its location within the scenario dataset is determined, the particular datapoint may be shown as an indicator such as indicator 512A (FIG. 5). For example, for a scenario dataset showing best times to do laundry for a household, an indicator may be provided representing the current energy usage of the house.
[0105] As part of the scenario dataset, one or more (consumption) goals may be provided. Each goal may be based on a different combination of savings parameters (e.g. time of use saving, amount of use reductions, rebate targets, etc.) and/or on different savings progressions (e.g. mild savings, moderate savings, aggressive savings).
[0106] Based on any significant difference between the current usage datapoint (per indicator 512A, FIG. 5) and the goal (per indicator 512B, FIG. 5), data scenario module 212D may determine a progression to move the tracked usage from its current level to the target level. For example a reduction of usage may be calculated to have a daily incremental reduction of usage over a period of time to reduce the current usage level to the target level. Such a progression rate may be identified to change a usage pattern of a device (e.g. a water heater) associated with the first datapoint to the goal.
[0107] In another embodiment, a visual representation of a population's consumption data may be generated (as noted above) and scenario data may then be accessed. A particular datapoint relating to a specific location's consumption data may be provided in the visual representation (e.g. as indicator 512A). Scenario data (as described above) may be analyzed to identify a goal for that a particular datapoint and the goal may be provided in the visual representation (e.g. as indicator 512B). For example, using consumption data from Table A, exemplary goal data in Table B may be provided for analysis.
TABLE-US-00002 TABLE B Goal Value Note Mild Savings 1,750 Implements free savings Moderate Savings 1,256 Implements day of use + rebate programs Aggressive Savings 750 Implements aggressive energy savings programs
Goal data may be absolute (providing set values as noted in Table B) and/or may be expressed as a percentage (e.g. a percentage reduction from the current usage rate).
[0108] An embodiment also provides control features to implement a plan to move the current consumption level towards the identified goal. Part of the control features utilize identified consumption value of a consumable for a given location. In particular, an embodiment can have direct control over one or more systems (e.g. lighting, heating, water circulation, HVAC, etc.) and can implement signals that are generated and transmitted from server 104 to start, stop and/or reduce the usage. Control module 212E (FIG. 2) may provide programming code for execution on processor 202 (FIG. 2) to effect execution of the process. The control module may generate control signals to control operation parameters of a device (e.g. to the above noted water heater to control when it is operated and at what temperatures the heater is set to) to implement the progression rate. The controls can be provided to control like groups of items. For example, controls can be provided to manage different types of utilities in a location (e.g. heat, water, HVAC, etc.) or all the same utilities in a location (e.g. all water usage in a city block). Part of the control features may provide a trigger to recalculate a visual representation of consumption data as the controls are implemented (per process 402, FIG. 4). As such, a matrix of control signals can be provided to control multiple devices. An embodiment can provide a separate plan for each device, but an overall plan can be provided that has coordinated controls over parameters for multiple devices.
[0109] It will be appreciated that all modules described herein for server 104 and device 106 can be implemented using known programming techniques, languages and algorithms. Although the modules described are implemented in server 104, it will be appreciated that some functions of the modules may be provided in a separate server that is in communication with server 104 and/or device 106, or even provided in device 106 itself. The titles of the modules are provided as a convenience to provide labels and assign functions to certain modules. It is not required that each module perform only its functions as described above. As such, specific functionalities for each application may be moved between modules or separated into different modules. Modules may be contained within other modules. Different signaling techniques may be used to communicate information between applications using known programming techniques. Known data storage, access and update algorithms allow data to be shared between applications. It will further be appreciated that other applications and systems on server 104 or device 106 may be executing concurrently using programming techniques known in the art.
2012-06-28 Display driver circuit, liquid crystal display device, display driving method, control program, and computer-readable recording medium having same control program recorded therein
2012-06-28 Touch display capable of eliminating touch impact on display