APPLICATION OF A SPREADSHEET FORMULA ALGORITHM AGAINST A DATASET SUCH AS A LARGE EXTERNAL DATA SOURCE

摘要

Disclosed are a method, a device, a system and/or a manufacture of application of a spreadsheet formula algorithm against a dataset such as a large external data source. In one embodiment, a scalable method of analyzing data includes generating a prototype data through importing a data entry from the dataset and mapping to cells of a spreadsheet file that may be accessible as a software-as-a-service. A data model for analyzing the dataset is defined through a spreadsheet algorithm comprising spreadsheet formulas outputting a dependent variable. The spreadsheet formulas, with one or more independent variables as inputs, are stored in a syntax format permitting independent calculation of the dependent variable. An extrapolated algorithm expressed in a programming language that may include SQL is generated from the formula algorithm and applied against the dataset utilizing parallel processing to generate a value for the dependent variable of each data entry of the dataset.