Abstract: The technology includes an example method for parsing data to determine corollary objects and adapt attributes of the corollary objects using the data. In some implementations, the method may include receiving one or more images, performing text recognition to determine recognized text in the one or more images, and determining data cells containing information associated with a first item. The method may then classify one or more of the determined data cells, and may identify key cells in the determined data cells based on the classification of the one or more determined data cells. Correlations between information contained in the key cells and a second item, the second item including an interchangeable item to the first item may be determined, and the method may adjust attributes associated with the second item based on defined parameters and the recognized text.

Abstract: A continuously updated database is enhanced with virtual dynamic representations of taxonomic groups of records stored in the database. Each record of the database contains a vertical field that identifies a unique entity associated with that record and a horizontal attribute upon which a business decision, related to the corresponding unique entity, may be based. A taxonomic group of database records are defined for each distinct value of the vertical field, and all records in a particular taxonomic group contain a most desirable value of the horizontal field associated with that group's corresponding vertical-field value. The system creates and maintains a virtual representative of each taxonomic group that is automatically updated as the database is updated.

Abstract: A search engine (200, 500, 800), method and a system for performing a search is provided. The search engine (200, 500, 800) is connected to at least one mobile device (210, 510, 810) and at least one web crawler (222, 522, 822). The web crawler (222, 522, 822) is configured to index documents and classify said documents. The search engine (200, 500, 800) receives a query from the mobile device (210, 510, 810) which is determined to be best answered by a crowd-sourced answer. The search engine (200, 500, 800) searches the documents and delivers at least one crowd-sourced answer (318, 618, 918). The search engine (200, 500, 800) displays the crowd-sourced answer (318, 618, 918) to a user.

Abstract: The present disclosure describes methods and systems for a document server communicatively coupled to at least one client computing device, a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document, a document object model, wherein the document is at least partially positioned on at least one of the document server and a first client computing device of the at least one client computing device, and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model.

Abstract: The programming notebook system, methods, and user interfaces described herein provide software developers with enhanced tools by which a programming notebook workflow and session history associated with code cells in a programming notebook may be tracked and maintained. As a developer progresses through a development workflow, the developer can select an option to save a program code card representing some or all of the program code cell inputs. A card editor user interface may present an aggregated listing of all program code the developer has provided across multiple code cells during the current session which the developer can edit, refine, and/or comment. The card editor may also allow the developer to add associated user interface code to display a UI component associated with the program code card, and allow the developer to add a description and tags for the card so that the card can be searched for and reused.

Abstract: The system includes an input interface and a processor. The input interface is to receive a spreadsheet and an indication of a spreadsheet cell of interest. The processor is to determine a first set of spreadsheet cells that the spreadsheet cell of interest depends on, determine a second set of spreadsheet cells that depend on the spreadsheet cell of interest, provide a spreadsheet cell data flow view for the spreadsheet cell of interest based at least in part on the first set of spreadsheet cells and the second set of spreadsheet cells, and in the event an indication of a new spreadsheet cell of interest is received, provide a spreadsheet cell data flow view for the new spreadsheet cell of interest.

Abstract: Computer-implemented systems and methods are disclosed for providing a graphical user interface for tagging external content. In accordance with some embodiments, a method is provided for tagging content external to a database system. The method comprises accessing the external content of an electronic device. The method may comprise enhancing the web browser by providing a tagging interface for tagging at least a portion of the external content. The method may further comprise receiving created tag associated with a tagged portion of the external document content, and exporting the external content and the received tag to the database system. The tagging interface can also provide an option to export the created tag to an internal database system.

Abstract: In embodiments of statistics value chart interface row mode drill down, a first interface is displayed in a table format that includes columns each with field values of an event field, and each column having a column heading of a different one of the event fields, and includes rows each with one or more of the field values, where each field value in a row is associated with a different one of the event fields, and each row includes an aggregated metric that represents a number of events having field-value pairs that match all of the one or more field values listed in a respective row and the corresponding event fields listed in the respective columns. A row can be emphasized in the first interface, and in response, a menu is displayed with selectable options to transition to a second interface that displays a listing of the events based on a selected one of the options.

Abstract: Systems, methods, and devices for modifying a summary cell for a set of organized cells are provided. In some embodiments, the summary cells may be modified by modification of the summary function, such that modification may include a function and/or text that is different than preexisting summary function options for a summary cell. In some embodiments, the modification of the summary cell for the set of organized cells may update summary cells for additional sets of organized cells using a corresponding function and/or text that is different than preexisting summary function.

Abstract: A method, system and computer-usable medium are disclosed for associating data cells with headers and tables having one or more embedded header structures. In certain embodiments, a table having rows and columns is received, wherein the table includes a plurality of cells, wherein each cell is populated with at least one of a header name, data value, or no information, the table having at least one embedded header. A determination is made as to whether a cell is a header cell or data cell. If the cell is a header cell, a count of consecutive column headers is maintained. A current list of column headers is dynamically updated based on the count of the consecutive column headers. Upon encountering a data cell, the current list of column headers is assigned to the data cell.

Abstract: A totem resting on a touchscreen display integrates a display at an upper surface to present visual information to an end user. Totem orientation is determined from totem touches at the touchscreen display and applied with other factors to orient the presentation of visual information at the totem to the orientation of an end user viewing the touchscreen display. Visual information presented at the totem may include input icons to associate the totem with an application, notifications from applications, and content presented at the touchscreen display under the totem.

Abstract: Processing a job request for multiple versions of a distributed computing service. The service processing node does this by at least interleavingly (e.g., via time sharing with rapid context switching, or by actually concurrently) running a first runtime library associated with a first service version of the distributed computerized service and a second runtime library associated with a different service version of the distributed computerized service. While running the first runtime library, job requests of a first service version may be at least partially processed using a first set of one or more executables that interact with the first runtime library. While running the second runtime library, job requests of a second service version may be at least partially processed using a second set of one or more executables that interact with the second runtime library.

Abstract: Techniques and solutions are described for determining, evaluating, and selecting data retrieval pathways. A plurality of database objects, such as tables, can be retrieved, and relationships between them determined. The relationships are between various attributes of the database objects. A plurality of pathways are determined between at least two target database objects, where the path determination does not consider attribute-level relationship information. After a path is determined, the relationship-level information can be added. A summary of the path, and relationship information, can be displayed to a user. A user can select paths to remove from the display, and can indicate one or more database objects that are required for a valid path, one or more database objects that are prohibited from valid paths, or combinations thereof. A user can select a path, and a query language statement to implement the path can be generated and displayed to the user.

Abstract: Data in different, respective ranges of spreadsheet file cells is compared, and a scope of a formula determined with respect to selected cells of the ranges of cells, wherein the formula pulls input data from selected cells of one range of cells and either pulls input data or generates output data to selected cells of the other range of cells. A review flag is automatically generated in association with data in a flagged cell in response to determining: that the flagged cell is omitted from a consecutive plurality of input data rows or columns; that the selected formula input cells are not consecutive within one of the ranges of cells; and that a high percentage of data values in corresponding cell rows or columns match but that and a location of the flagged cell is shifted from a corresponding cell within the other range.

Abstract: Computer-implemented systems and methods are described for configuring a plurality of privacy properties for a plurality of virtual objects associated with a first user and a virtual environment being accessed using a device associated with the first user, triggering for display, in the virtual environment, the plurality of virtual objects to the first user accessing the virtual environment, determining whether at least one virtual object is associated with a privacy setting corresponding to the first user. In response to determining that a second user is attempting to access the one virtual object, a visual modification may be applied to the object based on a privacy setting. The method may also include triggering for display, the visual modification of the at least one virtual object, to the second user while continuing to trigger display of the at least one virtual object without the visual modification to the first user.

Abstract: A system for time zone intelligent spreadsheets includes a server with a processor. The server is to host a spreadsheet document. The processor of the server is to interpret a time/date data of the spreadsheet document based at least in part on a time zone setting.

Abstract: A system may generate and update a key performance indicator (KPI) on a KPI dash. The system may receive a request and access KPI data to generate a self-contained KPI object. The system can also use metadata associated with the KPI to generate a set of metadata objects to be included in the KPI object. The self-contained KPI object can be displayed on the dashboard, and responsive to a rating received from a user, a cumulative rating may be updated. The new rating may be displayed within the KPI on the dashboard.

Abstract: A system for spreadsheet region and cell sharing using formula templates includes a processor and an interface. The processor is to parse a formula of a first cell of a first spreadsheet document for a second cell, the first spreadsheet document being associated with a first user having a set of user access descriptors and to determine, based on the set of user access descriptors, whether the first user has access to one or more canonical names referenced in the formula. The interface is to provide display information to the first user either the canonical name in the event that the first user has access to the canonical name or an opaque identifier in the event that the first user does not have access to the canonical name.

Abstract: A system and method for processing data wherein one or more user selections of source data and an input defining one or more operations to be performed on the selected source data are received to generate processed data for display as a chart; the source data is retrieved from at least one data source, the source data is processed according to the defined one or more operations to generate processed data for output for display as a chart, the chart is stored as data defining the one or more operations and data identifying the source data operated on, a further user selection is received to redisplay the chart; retrieving the source data from the at least one data source; and the source data is processed according to the defined one or more operations to generate the processed data for output for redisplay as the chart.

Abstract: A system may include presentation of one or more measure values, each of the one or more measure values corresponding to a member of each of one or more dimension, reception of a first instruction to copy one of the one or more measure values, storage, in response to the first instruction, of the one measure value and a corresponding member of each of one or more dimensions, reception of a second instruction to paste the stored one measure value to a local application, and, in response to the second instruction, writing of the stored one measure value and corresponding member of each of one or more dimensions to the local application.

Abstract: The present disclosure provides a novel approach to displaying spreadsheets on mobile devices (e.g., cell phones, tablets, etc.) so that they are more easily viewable by the user. Aspects of the present disclosure provide multiple different views of a spreadsheet and simple transitions among those views. The multiple views facilitate the display of important aspects of a spreadsheet and optimize the spreadsheet viewing area. In particular, deck and card views are disclosed, wherein each view corresponds to a different display format of the spreadsheet. Furthermore, editing the spreadsheet data is also provided within these views.

Abstract: In one embodiment, a method includes receiving input data from at least one input device, preparing a user interface screen including a search filter area and a search results area, the search filter area including graphical filter tools including selectable sections, each selectable section being associated with a filter criteria for filtering a data set including data items, each selectable section having a size indicative of a number of the data items satisfying the filter criteria, interpreting the input data to include selecting a first selectable section of a first graphical filter tool and a second selectable section of a second graphical filter tool, filtering the data set based on the filter criteria of the first selectable section and the second selectable section, and updating the search results area of the user interface screen based on the filtered data set.

Abstract: In accordance with one embodiment, a setting method of an image forming apparatus including displaying character codes that the image forming apparatus supports in a case where the import of data to the image forming apparatus is instructed; receiving a selection of the character code of the data to be imported to the image forming apparatus from the displayed character codes; and importing, if the character code of the data to be imported is selected, the data to the image forming apparatus in the selected character code.

Abstract: Embodiments relate to methods and apparatuses providing contextual suggestion in the environment of a user interface to a planning spreadsheet. Particular embodiments feature an interface engine that is in communication with an underlying data model. The data model may be hierarchical in nature (e.g., organized according to tree structure). In response to user input to the spreadsheet interface, the engine is configured to parse metadata associated with the data model, and construct therefrom suggestion strings prompting a user to interact with the data of the data model. The interface engine may consider a variety of factors in providing relevant suggestion, including but not limited to cell type and user context (e.g., access rights) so as to further target the offered suggestions offered to user expectation. This approach can desirably enhance efficiency of user interaction with the spreadsheet application, resulting in less typing, fewer corrections, faster workflows, and greater satisfaction.

Abstract: The present disclosure describes methods and systems for a document server communicatively coupled to at least one client computing device, a document comprising an operation log, wherein the operation log comprises at least one first sequential operation defining operations to create data values of the document, a document object model, wherein the document is at least partially positioned on at least one of the document server and a first client computing device of the at least one client computing device, and a formula engine, wherein the formula engine is structured to determine a calculation definition in response to the user formula value and the document object model.

Abstract: A data analysis program receives a selection of data fields defining multiple row header areas and/or multiple column header areas for display in a summary table. Data is read from a data source containing values for the data fields and transformed into summary level data for building the summary table. A display is rendered in the summary table for each of the multiple row header areas and column header areas defined, with the row header areas being displayed vertically adjacent to one another and the column header areas being displayed horizontally, adjacent to one another.

Abstract: Lists of tradeable objects may be generated and displayed to enable a user to define a trading strategy having multiple legs. The lists of tradeable objects may be used to define and display different combinations of the tradeable objects that are included in each of the lists. Each combination of tradeable objects may define the different legs of a spread that may be tradeable on one or more exchanges. A combination of tradeable objects may be selected to display contract information associated with the different legs of the spread. The contract information for each leg may be used to define and display spread information for the legs of the trading strategy. The spread information may allow the user to view information related to the spreads for different combinations of tradeable objects in a display.

Abstract: A system for performing units-based math for spreadsheet cell values includes a processor. The processor is to host a spreadsheet document; parse a formula containing a first measure, a first unit of measure, and an operator; in the event that the first unit of measure and the operator are compatible, determine a resulting measure by applying the operator to the first measure; determine a resulting unit of measure; and associate the resulting measure with the resulting unit of measure.

Abstract: The invention comprises a federated system having a centralized data collection node that receives real-time data feeds from multiple airport systems, a data decoupling module for scrubbing received data, coding scrubbed data, and validating coded output data, and a central control node for monitoring and controlling the system. The invention also includes graphical user interfaces and methods for displaying such information at a central node, or NOC. The invention can also detect output devices and create specific special purpose feeds for each data destination or remote display, as well as systems that allow an airline to remotely access and update the status and settings of a remote travel operations display system via the Internet.

Abstract: Facilitating interaction with a spreadsheet it provided. One or more input cells of a spreadsheet displayed on a display device of a computer system are automatically detected. One or more candidate cells of the spreadsheet are presented for selection, as candidates for inclusion in an interface for display on the display device in conjunction with the spreadsheet, the one or more candidate cells including the detected one or more input cells. Based on a selection of at least one cell, of the one or more candidate cells, for inclusion in the interface, the selected at least one cell is displayed in the interface, where the selected at least one cell includes at least one input cell of the one or more candidate input cells.

Abstract: Systems and techniques for storing, managing and/or displaying industrial data are presented. A controller component stores configuration data associated with a plurality of product types for a product generated based on at least one manufacturing process in a nested data structure. A data interface component manages data corresponding to the configuration data stored in the nested data structure for a data table associated with a spreadsheet application.

Abstract: Embodiments are disclosed in which an algorithm that evaluates the contents of a cell within an application incorporates error tracking. In certain such embodiments, a second cell is identified that is responsible for generation of an error indication within the cell. A link may be provided to the second cell to facilitate resolution of the error condition.

Abstract: A business form generating server generates a business form page by overlaying form information and field data. The business form generating server generates data for displaying a browsing screen on which the business form page is browsed and edited. A client apparatus adds attribute information to information for a field of the business form page based on the data, wherein the attribute information includes layout information. If the information of the field of the business form page is edited by using the browsing screen, the client apparatus determines whether or not overlaying again is necessary based on the attribute information which is added to the information of the edited field.

Abstract: Techniques for facilitating navigation in a web-based data entry grid. In one set of embodiments, when a user navigates into a cell of the data entry grid, the user's web browser can wait for a predetermined time period before accessing an application server to retrieve input control information for the cell. If the user enters a command to navigate away from the cell before the predetermined time period has passed, the server access can be avoided, and thus the navigation event can be processed immediately. If no navigation command is received from the user before the predetermined time period has passed, the input control information can be retrieved from the application server and rendered.

Abstract: Methods and arrangements to manage transparent windows are described herein. Embodiments may comprise logic such as hardware and/or code to select one or more windows to make transparent and to switching the active window between source and target windows via the position of the mouse. Many embodiments provide a right click, pop-up menu (i.e., pressing the right mouse button generates a pop-up menu), a pull-down menu, or a button associated with windows. These features may allow a user to select individual or all windows to be transparent. A transparent window provides some view of windows or objects below the transparent window while providing some view of the contents such as graphics and/or text in the transparent window. Embodiments may also include management logic such as hardware and/or code to facilitate selection of a transparent window to make the window active.

Abstract: Systems and methods are disclosed herein for resolving a change to a table. A processing circuitry receives, from a user in a collaborative document editing environment, the change to the table, wherein the change comprises an expansion of a first cell in the table. A first state of the first cell is identified, wherein the state is indicative of a number of columns and a number of rows over which the first cell spans, and at least one of the number of columns and the number of rows is greater than one. A second state of a second cell that is adjacent to the first cell is identified, and the processing circuitry selects whether to allow the expansion of the first cell based on the second state of the second cell.

Abstract: A computer-human interface provides a mechanism to manage the available space of a computer display in a manner that facilitates navigation among multiple windows that are overlaid upon one another. The interface includes a user-selectable mode in which the windows are rearranged, and resized if necessary, so that all open windows can be simultaneously viewed within the area of the display, thereby enabling any one of the windows to be easily selected for access. In effect, the presentation of the windows is “flattened” so that all windows appear at the same virtual depth, rather than overlapping one another. With this approach, there is no need to minimize windows in order to access one that is overlaid by another, thereby enabling the user to keep the content of all windows visible and accessible. Subsets of windows can be repositioned in the same manner, or all windows can be removed from the display area for access to desktop objects.

Abstract: One or more embodiments of techniques or systems for intelligent data presentation are provided herein. Data can be presented on similar devices having different characteristics in different manners. For example, data may be rendered in a first manner on a first device having one monitor, the same data may be rendered in a second manner on a second device having two displays or a different display size. Financial information, sales data, banking information, etc. may be presented in a variety of ways based on capabilities or properties of a device accessing the information or data. Similarly, renderings may be selected based on interaction capabilities or interaction options a user may have with different renderings or presentations. In other embodiments, user interaction with an automated teller machine (ATM), call center, vehicle, or other interface can be based on device properties or device capabilities.

Abstract: Techniques include systems, computerized methods, and computer readable media for creating a graphical program in a graphical program development environment. A spreadsheet node having an input terminal in the graphical program is instantiated. The spreadsheet node is associated with a spreadsheet that specifies a list of functions to be executed in a computing device, and the input terminal is connected to the first terminal of the first node, indicating a data connection between the first terminal of the first node and the input terminal of the spreadsheet node. The input terminal of the spreadsheet node is associated with a first cell in the spreadsheet, indicating that the first cell in the spreadsheet be populated with any data received by the input terminal. A human readable file is generated specifying the graphical program, including the spreadsheet node.

Abstract: The present invention relates to a system for modifying a table comprising generating means for generating a table, wherein the table contains one or more columns and one or more lines containing data, wherein the columns and the lines are related to one or more first categories, respectively, and wherein at least one of said first categories is divided into one or more sub-categories, wherein the system further comprises changing means for changing the distance between data related to two neighboring first categories and/or for changing the distance between data related to two neighboring sub-categories and/or for changing the line height and/or the column width, wherein the changing means are adapted to increase and/or decrease said distance and/or line height and/or the column width in order to increase legibility of the table.

Abstract: Detecting overnegation in text is provided. A plurality of word lists are compiled. An input text is received. One or more combined weightings are determined, wherein each combined weighting is based, at least in part, on a portion of the input text and the plurality of word lists. A total overnegation score of the input text is generated based, at least in part, on a statistical aggregation of the one or more combined weightings. In response to determining that the total overnegation score exceeds a pre-determined threshold, it is determined that the input text contains a logical error. In response to the total overnegation score exceeding a pre-determined level, one or more actions are executed.

Abstract: A method, system, and computer program product for subject-matter analysis of tabular data are provided in the illustrative embodiments. A first document including the tabular data is received. A library of functional signatures for a first subject-matter domain is selected. A determination is made whether a threshold number of functional signatures from the selected library are applicable to the tabular data, wherein a functional signature is applicable to the tabular data when values in the tabular data correspond to an operation and a table structure specified in the functional signature. Responsive to the threshold number of functional signatures from the selected library being applicable to the tabular data, a processor and a memory process the first document according to a process for the first subject matter domain selected from a plurality of processes for respective subject matter domains.

Abstract: A method and apparatus for retrieving selected information in a graphical model environment originates with the provision of the graphical model environment. The selected information is selected by, or provided to, a block diagram simulation application operating the graphical model environment. The selected information can be in the form of data or a reference to data. The selected information is automatically incorporated into the graphical model environment.

Abstract: A display structure that includes data items mapped based on relationships among the data items is visually presented on a user interface. The displayed data includes blocks of data received over a block data interface. The display structure may include a first portion indicative of availability of multiple 2-dimensional views of the data items and a second portion for the user to select one of the multiple 2-dimensional views to become an active view that is viewable by the user.

Abstract: Described are methods, systems and computer readable media for providing a current row position query language construct and array processing query language constructs and associated processing.

Abstract: The system includes an input interface and a processor. The input interface is to receive a spreadsheet and an indication of a spreadsheet cell of interest. The processor is to determine a first set of spreadsheet cells that the spreadsheet cell of interest depends on, determine a second set of spreadsheet cells that depend on the spreadsheet cell of interest, provide a spreadsheet cell data flow view for the spreadsheet cell of interest based at least in part on the first set of spreadsheet cells and the second set of spreadsheet cells, and in the event an indication of a new spreadsheet cell of interest is received, provide a spreadsheet cell data flow view for the new spreadsheet cell of interest.

Abstract: Various embodiments of system and methods of creating a filter for a list of objects are described herein. The method includes receiving a selection of a set of objects from the list of objects composed of one or more fields having field values, and comparing the field value in each field of an object with the field values in each of the corresponding fields of the other objects in the set of objects. Based on the comparison, identifying that the field values are the same across the one or more fields of the set of objects. The method further includes generating a list of filter criteria based on the identified field values. The filter may be created using the list of filter criteria.

Abstract: Systems and methods are provided for automatically translating one or more electronic spreadsheets into scripts. One or more electronic spreadsheets containing data arrays and formula arrays may be accessed. The electronic spreadsheet(s) may implement various logic using the data arrays and the formula arrays. The range(s) of the formula arrays may be determined. The range(s) of the data arrays may be determined based on the range(s) of the formula arrays. Conversion ranges may be determined based on the range(s) of formula arrays and the range(s) of data arrays. One or more dependencies between the conversion ranges may be determined and used to generate source code modeling the logic implemented by the electronic spreadsheet(s).

Abstract: Rendering common cell formatting for adjacent cells is disclosed. In some embodiments, when rendering cells, a set of adjacent cells that have at least one type of cell formatting in common is identified, and the at least one type of cell formatting is rendered as a single entity rather than individually for each cell in the set to prevent visual artifacts between adjacent cells from arising.

Abstract: An electronic device in an industrial control system may be connected as a network device, such as via EtherNet/IP. The device may be configured to provide an “unconnected” message notification (or “active report”) when the device detects an enumerated condition, such as an error or deviation. An unconnected message may be a message sent between two or more applications (which may be of the same or different devices) without pre-established communication channel bindings. An unconnected message may include routing path information for routing the message to the host computer, application path information for associating the applications, and data payload information related to at least one of a state of the electronic device and the enumerated condition.