Automatic translation of spreadsheets into scripts

A system comprising:

• one or more physical processors;
• and
• memory storing instructions that, when executed by the one or more physical processors, cause the system to perform:
• accessing one or more electronic spreadsheets, the one or more electronic spreadsheets containing one or more data arrays and one or more formula arrays, wherein the one or more electronic spreadsheets implement one or more logic using the one or more data arrays and the one or more formula arrays;
• determining one or more ranges of the formula arrays;
• determining one or more ranges of the data arrays based on the one or more ranges of the formula arrays;
• determining conversion ranges based on the one or more ranges of the formula arrays and the one or more ranges of the data arrays;
• determining one or more dependencies between the conversion ranges, the determining one or more dependencies further comprising:
• determining a first conversion range of the conversion ranges includes a first formula array that references a first data range included in a second conversion range of the conversion ranges;
• identifying the first conversion range as depending on the second conversion range based on the first formula array of the first conversion range referencing the first data range of the second conversion range;
• creating a dependency graph based at least partially on the dependency of the first conversion range on the second conversion range;
• and
• generating source code based on the conversion ranges and the dependency graph, the source code modeling the one or more logic implemented by the one or more electronic spreadsheets.

A non-transitory computer readable medium comprising instructions that, when executed, cause one or more processors to perform:

• accessing one or more electronic spreadsheets, the one or more electronic spreadsheets containing one or more data arrays and one or more formula arrays, wherein the one or more electronic spreadsheets implement one or more logic using the one or more data arrays and the one or more formula arrays;
• determining one or more ranges of the formula arrays;
• determining one or more ranges of the data arrays based on the one or more ranges of the formula arrays;
• determining conversion ranges based on the one or more ranges of the formula arrays and the one or more ranges of the data arrays;
• determining one or more dependencies between the conversion ranges, the determining one or more dependencies further comprising:
• determining a first conversion range of the conversion ranges includes a first formula array that references a first data range included in a second conversion range of the conversion ranges;
• identifying the first conversion range as depending on the second conversion range based on the first formula array of the first conversion range referencing the first data range of the second conversion range;
• creating a dependency graph based at least partially on the dependency of the first conversion range on the second conversion range;
• and
• generating source code based on the conversion ranges and the dependency graph, the source code modeling the one or more logic implemented by the one or more electronic spreadsheets.