System and method for visually presenting interesting plots of tabular data

    公开(公告)号:US11734504B2

    公开(公告)日:2023-08-22

    申请号:US17567197

    申请日:2022-01-03

    CPC classification number: G06F40/177 G06F16/221 G06F18/256 G06F40/18 G06T11/20

    Abstract: A system and method for generating visual representations of interesting plots of tabular data. The method includes determining a plurality of prediction values for a plurality of column sets included in tabular data, wherein each column set includes at least one of the plurality of columns, wherein each prediction value is determined for a column set of the plurality of column sets using a prediction function selected from a plurality of prediction functions based on a column type of each column of the column set; determining an interest rank for each column of the plurality of columns based on the plurality of prediction values; determining an interest rank for each plot of a plurality of potential plots based on the plurality of prediction values and the interest rank of each of the plurality of columns, wherein each potential plot is a plot of one of the plurality of column sets; and generating a visual representation of at least one interesting plot, wherein the at least one interesting plot is selected from among the plurality of potential plots based on the plurality of interest ranks.

    Method and apparatus for browsing table in document, and electronic device and storage medium

    公开(公告)号:US11720235B2

    公开(公告)日:2023-08-08

    申请号:US17693251

    申请日:2022-03-11

    Inventor: Yu Xu Yixin Pan

    CPC classification number: G06F3/0483 G06F40/18

    Abstract: A method and an apparatus for browsing a table in a document, and an electronic device and a storage medium. The method includes: in a process of editing a table in an online document, receiving a table page jump instruction of a first table and jumping from a document page corresponding to the online document to a first table page for display; receiving a table switching instruction in the first table page; and switching from the first table page to a second table page for display according to the table switching instruction; where the first table page is used to display the first table, and the second table page is used to display a second table. Tables can be switched quickly, and the browsing speed of tables can be improved.

    SYSTEM AND METHOD FOR REFERENCE VALIDATION OF SPREADSHEET

    公开(公告)号:US20230244863A1

    公开(公告)日:2023-08-03

    申请号:US17588184

    申请日:2022-01-28

    Applicant: Intuit Inc.

    CPC classification number: G06F40/18 G06F40/123

    Abstract: A method includes establishing a connection with a spreadsheet at a source location, receiving at least one selected field from an entry in the spreadsheet at the source location, and generating an assured reference record for the entry using at least one value in the at least one selected field. The assured reference record includes an assurance value and a reference to the entry at the source location. The method further includes storing, at a second location, the assured reference record in an assured reference file associated with the spreadsheet. The method further includes validating, after storing the assured reference record, the reference to the first entry in the spreadsheet at the source location using the first assurance value in the assured reference record.

    METHODS FOR POLYMORPHIC DATA IN SPREADSHEETS
    87.
    发明公开

    公开(公告)号:US20230214587A1

    公开(公告)日:2023-07-06

    申请号:US18114608

    申请日:2023-02-27

    Abstract: A spreadsheet user interface shows polymorphic records. The records include global fields, discriminator fields, and context-sensitive fields. A context-sensitive field is available or unavailable dependent on a discriminator field value. Record fields associate with spreadsheet columns, regardless of field availability. User confusion is prevented by marking a record's unavailable context-sensitive fields as unavailable and visually distinguishing them from available fields. A user-requested operation spanning multiple rows and columns is supported by testing whether a source cell and source data is available, a destination cell is available, and skipping the operation for those records whose source and/or destination cell is required but unavailable. An embodiment supports interfacing with a single record in a spreadsheet form by applying global form templates associated with global fields, and context-dependent form templates associated with specific discriminator field values.

    AUTOMATIC DATA EXTRACTION
    88.
    发明公开

    公开(公告)号:US20230214586A1

    公开(公告)日:2023-07-06

    申请号:US18009592

    申请日:2021-06-11

    CPC classification number: G06F40/18 G06F40/186

    Abstract: Described are methods for automatically extracting data from structured documents e.g. spreadsheets, regardless of the manner in which data is organized, and using the extracted data to generate an output table that is in a standardized format. The method can include the operations for automatically extracting data from a spreadsheet that defines rows and columns and includes a plurality of cells that are delineated by the rows and the columns, by identifying characteristics of data included in each cell of the column, determining a template type of the column based on the characteristics of the data in each selected cell of the column, and determining, from among a plurality of cells of the column and based on characteristics of the data included in the plurality of cells of the column, a representative cell that is representative of the determined template type of the column.

    Method and system for improved spreadsheet analytical functioning

    公开(公告)号:US11694023B2

    公开(公告)日:2023-07-04

    申请号:US17374898

    申请日:2021-07-13

    Applicant: Adaptam Inc.

    Inventor: Robert E. Dvorak

    CPC classification number: G06F40/18 G06F17/18

    Abstract: The disclosed technology creates a family of spreadsheet functions (predefined formulas) which allows users to create programming loop equivalents in their regular spreadsheet cells combining familiar range or array evaluating functions (e.g., SUM, COUNT, MIN, MAX, etc.) with data filtering and output selection. The input data to these new functions can be sourced from multiple cells within the spreadsheet or a broad spectrum of numeric, date and text data not stored in a spreadsheet, including data not discretely defined. The technology disclosed can use as inputs cell ranges or Non-spreadsheet Cell (NSC) data formulas. The technology supports functions with predefined combinations and user specified combinations all capable of automating, millions of looped calculations.

Patent Agency Ranking