Automatic translation of spreadsheets into scripts

    公开(公告)号:US10762291B2

    公开(公告)日:2020-09-01

    申请号:US16226100

    申请日:2018-12-19

    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).

    Automatic translation of spreadsheets into scripts

    公开(公告)号:US10180934B2

    公开(公告)日:2019-01-15

    申请号:US15658218

    申请日:2017-07-24

    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).

    Systems and methods for creating pipeline paths

    公开(公告)号:US10795839B1

    公开(公告)日:2020-10-06

    申请号:US16362391

    申请日:2019-03-22

    Abstract: A data pipeline including a plurality of graph pipeline paths is obtained. Each of the graph pipeline paths may include pipeline nodes, at least one of the pipeline node may have at least two inputs. Each of the inputs may comprise outputs of two or more other pipeline nodes. A linear pipeline path interface is provided for creating and presenting a linear pipeline path of the data pipeline. The linear pipeline path may include pipeline nodes, each being limited to a single input and a single output. The linear pipeline path interface may be limited to interacting with linear pipeline paths. A graph pipeline interface is provided for presenting and modifying the data pipeline. The linear pipeline path interface may be switched to the graph pipeline interface in response to a first user input.

    DATA PIPELINE CREATION SYSTEM AND METHOD
    8.
    发明申请

    公开(公告)号:US20200210408A1

    公开(公告)日:2020-07-02

    申请号:US16362113

    申请日:2019-03-22

    Abstract: A computer-implemented method comprises receiving one or more data transformation commands through a console in a console session, the one or more data transformation commands relating to one or more initial datasets; executing the one or more data transformation commands using the one or more initial datasets to modify at least one of the one or more initial datasets to generate a modified dataset; generating a set of environment flags for the command to indicate that the one or more initial datasets has been accessed and the at least one dataset that has been modified; and updating a set of line dependencies based on the generated set of environmental flags and previously generated sets of environmental flags for one or more previously executed commands.

Patent Agency Ranking