Application of a spreadsheet formula algorithm against a dataset such as a large external data source

A scalable method of analyzing data, the method comprising:

• generating a prototype data through importation of a data entry from a dataset comprising two or more data entries, the data entry comprising one or more pieces of data;
• mapping each of the one or more pieces of data of the data entry to one or more cells of a spreadsheet file that is at least one of (i) readable by a spreadsheet application and (ii) accessible as a software-as-a-service through a browser application;
• defining a data model for analyzing the dataset comprising a formula algorithm outputting a dependent variable and accepting as inputs the one or more pieces of data of the data entry as one or more independent variables,
• wherein the formula algorithm comprising one or more spreadsheet formulas stored in one or more cells of the spreadsheet file, the one or more independent variables referenced from one or more cells of the spreadsheet file, and the dependent variable output in a cell of the spreadsheet file, and
• wherein the one or more spreadsheet formulas, the one or more independent variables, and the dependent variable are stored in a syntax format permitting independent calculation of the dependent variable for each of the two or more data entries of the dataset;
• generating from the formula algorithm an extrapolated algorithm expressed in one or more programming languages,
• wherein each spreadsheet formula equivalent to one or more functions of at least one of the one or more programming languages and each of the one or more independent variables define a declared variable of at least one of the one or more functions of at least one of the one or more programming languages;
• and
• applying the extrapolated algorithm against the dataset utilizing parallel processing to generate an output data comprising a value for the dependent variable calculated for each of the two or more data entries of the dataset.

A system for scalable analysis of data, comprising:

• a computing device comprising a database storing a dataset comprising two or more data entries,
• a translation server comprising:
• a processor of the translation server;
• a memory of the translation server, the memory of the translation server comprising computer readable instructions that when executed on the processor of the translation server:
• receive a formula algorithm defined in a spreadsheet file,
• wherein the spreadsheet file comprising a data entry of the two or more data entries imported as a prototype data,
• wherein the formula algorithm comprising one or more spreadsheet formulas stored in one or more cells of the spreadsheet file, one or more pieces of data of the data entry stored as one or more independent variables referenced from one or more cells of the spreadsheet file, and a dependent variable output in a cell of the spreadsheet file, and
• wherein the one or more spreadsheet formulas, the one or more independent variables, and the dependent variable are stored in a syntax format permitting independent calculation of a value of the dependent variable for each of the two or more data entries of the dataset;
• generate an extrapolated algorithm expressed in a programming language based on the formula algorithm,
• wherein each instance of the one or more spreadsheet formulas equivalent to one or more functions of the programming language;
• and
• submit the extrapolated algorithm for calculation of the value of the dependent variable for each of the two or more data entries of the dataset through parallel processing,
• an execution server comprising:
• a processor of the execution server,
• a memory of the execution server, the memory of the execution server comprising computer readable instructions that when executed on the processor of the execution server:
• receive the extrapolated algorithm expressed in the programming language;
• receive the dataset comprising the two or more data entries in the syntax format as an input to the extrapolated algorithm;
• apply the extrapolated algorithm against the dataset;
• and
• generate an output data comprising the value for the dependent variable of each instance of the two or more data entries within the dataset;
• and
• a network.