公开(公告)号：US12056445B2

公开(公告)日：2024-08-06

申请号：US17384404

申请日：2021-07-23

申请人： Adaptam Inc.

发明人： Robert E. Dvorak

IPC分类号： G06F3/0482 ,  G06F3/0486 ,  G06F40/18

CPC分类号： G06F40/18 ,  G06F3/0482 ,  G06F3/0486

摘要： The technology disclosed improves the creation, modification and presentation of spreadsheet charts. The technology makes creating charts from non-contiguous data, i.e., data requiring more than one non-contiguous ranges, easy and intuitive for users. Instead of placing the inputs in pop-ups, drop-downs and/or sidebars employing ribbons and other steps, the inputs are placed on the desired chart proximate to where the populated data will display. The inputs accept typed text, spreadsheet cells and provide a selector for cell selection. Embodiments will pre-populate title locations accepting similar inputs, add color for easier information identification and provide user sidebar or other input options. Error and warning messages are provided to help users generate the chart they desire.

公开(公告)号：US11977835B2

公开(公告)日：2024-05-07

申请号：US17752814

申请日：2022-05-24

申请人： Adaptam Inc.

发明人： Robert E. Dvorak

IPC分类号： G06F3/0482 ,  G06F40/18

CPC分类号： G06F40/18 ,  G06F3/0482

摘要： Disclosed is a method of as you type error checking of a spreadsheet formula as a user types the formula in a cell, including analyzing, as you type, the cell contents of the spreadsheet formula and throwing an error message when the cell contents are not valid in the formula being typed. The error message identifies/emphasizes a token or group of tokens that cause the error. Also disclosed is selecting and populating into a spreadsheet formula a formulaic data field to be evaluated, starting from a position in the spreadsheet formula where the formulaic data field to be evaluated is to be populated, and responding to typed inputs and/or UI selection by displaying a list of selectable formulaic data fields with additional information that contains (non-data derived) human generated values. Upon selection among the fields, the method includes automatically populating into the starting position in the spreadsheet formula.

公开(公告)号：US20220012417A1

公开(公告)日：2022-01-13

申请号：US17374901

申请日：2021-07-13

申请人： Adaptam Inc.

发明人： Robert E. Dvorak

IPC分类号： G06F40/18

摘要： The disclosed technology creates a family of (predefined formula) spreadsheet functions which allows users to create programming loop equivalents in their regular spreadsheet cells employing familiar range functions (e.g., SUM, COUNT, MIN, MAX, etc.) with data filtering and output selection. The data 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 either cell ranges or Non-Spreadsheet Cell (NSC) data formulas. The capability allows users to specify standardized or highly custom calculations capable of executing millions of loops through a (predefined formula) spreadsheet function.

公开(公告)号：US20210406459A1

公开(公告)日：2021-12-30

申请号：US17359430

申请日：2021-06-25

申请人： Adaptam Inc.

发明人： Robert E. Dvorak

IPC分类号： G06F40/18 ,  G06F9/451 ,  G06F3/0482 ,  G06F3/0489

摘要： The technology disclosed includes a spreadsheet application with a formula building capability that allows users to construct a complex multi-component formula piece by piece, seeing the evaluated result of each component on the way to building the whole formula. It replaces users building complex formulas in a number of separate cells, troubleshooting each part and then having to either recombine the formula parts in one cell via a frequently error borne process or creating a master cell using a hidden set of all the piece parts making it harder to then see and understand what the formula is doing and apply copy paste.

公开(公告)号：US20230325588A1

公开(公告)日：2023-10-12

申请号：US18084469

申请日：2022-12-19

申请人： Adaptam Inc.

发明人： Robert E. Dvorak

IPC分类号： G06F40/18

CPC分类号： G06F40/18

摘要： The technology disclosed relates to accessing external data, including massive amounts of data stored in the cloud, in spreadsheet cells: accessing external data direct via a formulaic variable in a spreadsheet, specifying an ordered progression for the accessed external data, selectively propagating data accessed using the formulaic variable vertically or horizontally, within a propagation pattern responsive to normal A$1, $A1 and $A$1 spreadsheet conventions. Two or more external data fields, responsive to the formulaic variable, have an ordered sequence relationship that nests ordering of vectors of the propagated data; and the ordering according to the ordered sequence relationship is maintained during replication by copy and paste. In another disclosed method, the external data is generated using an implicit join of data from at least two external data sources to generate multiple adjoining vectors of spreadsheet cells of data responsive to selection parameters in the formulaic variable.

公开(公告)号：US11694023B2

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

申请号：US17374898

申请日：2021-07-13

申请人： Adaptam Inc.

发明人： Robert E. Dvorak

IPC分类号： G06F40/40 ,  G06F40/18 ,  G06F17/18

CPC分类号： G06F40/18 ,  G06F17/18

摘要： 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.

公开(公告)号：US11657217B2

公开(公告)日：2023-05-23

申请号：US17359418

申请日：2021-06-25

申请人： Adaptam Inc.

发明人： Robert E. Dvorak

IPC分类号： G06F3/048 ,  G06F40/18 ,  G06F9/451 ,  G06F3/0482 ,  G06F3/0489

CPC分类号： G06F40/18 ,  G06F3/0482 ,  G06F3/0489 ,  G06F9/451 ,  G06F9/453

摘要： The technology disclosed relates to accessing data within or external to spreadsheet cells (NSC data) and presenting it to users, so they can select one or more value to populate the cell. In one implementation, the technology disclosed is a spreadsheet function (predefined formula) where the user inputs a cell range or NSC data formula resulting in a button operated drop-down (pop-up or other visual) populating one value within the cell. Once the formula is completed the user can change that value by clicking the button and selecting the desired value from the multiple values presented. In another implementation the function input can be altered to add a constraint (filter) limiting the values presented for selection. In variants of any of the implementations, the presented values can be organized in ascending or descending orders for easy selection and show all values or only the unique (distinct) values.

公开(公告)号：US20230153518A1

公开(公告)日：2023-05-18

申请号：US17988641

申请日：2022-11-16

申请人： Adaptam Inc.

发明人： Robert E. Dvorak ,  Yuriy GARIN

IPC分类号： G06F40/18

CPC分类号： G06F40/18

摘要： The technology disclosed relates to accessing data within or external to spreadsheet cells (NSC data) and presenting it to users, so they can select one or more value to populate the cell. In one implementation, the technology disclosed is a spreadsheet function (predefined formula) where the user inputs a cell range or NSC data formula resulting in a button operated drop-down (pop-up or other visual) populating one value within the cell. Once the formula is completed the user can change that value by clicking the button and selecting the desired value from the multiple values presented. In another implementation the function input can be altered to add a constraint (filter) limiting the values presented for selection. In variants of any of the implementations, the presented values can be organized in ascending or descending orders for easy selection and show all values or only the unique (distinct) values.

公开(公告)号：US20220300705A1

公开(公告)日：2022-09-22

申请号：US17833738

申请日：2022-06-06

申请人： Adaptam Inc.

发明人： Robert E. Dvorak

IPC分类号： G06F40/186 ,  G06F8/34 ,  G06F40/16 ,  G06F40/18 ,  G06F40/103 ,  G06F40/174 ,  G06F40/205 ,  G06F16/903 ,  G06F16/901 ,  G06F17/11

摘要： The technology disclosed relates to accessing external data in spreadsheet cells and includes spreadsheet cells that can use formulaically defined external data, allowing users to utilize many cells as if they were one cell and to simplify or expand the type of calculations possible within a cell. The disclosed technology further includes a spreadsheet application that can perform looped calculations within the spreadsheet cells without the need to use an embedded programming language. Additionally the disclosed spreadsheet application can use named variables and formulaic cell designators for cell operations in which formulaically defined non-spreadsheet cell data variables and their values can be exposed and multiple values can exist in a cell, and the user can step through and see those different values.

公开(公告)号：US20220083730A1

公开(公告)日：2022-03-17

申请号：US17532973

申请日：2021-11-22

申请人： Adaptam Inc.

发明人： Robert E. Dvorak

IPC分类号： G06F40/186 ,  G06F8/34 ,  G06F40/16 ,  G06F40/18 ,  G06F40/103 ,  G06F40/174 ,  G06F40/205 ,  G06F16/903 ,  G06F16/901 ,  G06F17/11

摘要： The disclosed technology includes multi-way triggering of automatic replication elements selectively within and across documents, cellular atomization of spreadsheet cells and charts while retaining their desired formula, function and content properties, combining the selective multi-way replication with the cellular atomization, and employing a library capability to easily reuse automatically coordinating elements and atomized spreadsheet or tabular cells and charts.