Database generation from a spreadsheet

摘要

A machine may generate a database from a spreadsheet, track the data from its cells as values of variables, and provide such values to authorized users. The machine may receive an upload spreadsheet that was generated by modification of a source spreadsheet by inclusion of control codes, such as a first control code that labels a column of owner names, a second control code that labels a column of measures, and a third control code that labels a column of values of those measures. The machine may parse the upload spreadsheet based on its control codes. The machine may generate a database that contains a data record in which the value of the measure quantifies a variable, and this variable may have a variable name that includes the owner name of the row and the measure of the row. The machine may allow authorized users to download variables and values.

主权项

1. A method comprising:
receiving an upload spreadsheet generated by modification of a source spreadsheet to include a first control code that labels a column of owner names, include a second control code that labels a column of measures, and include a third control code that labels a column of values of measures; parsing the received upload spreadsheet based on the first, second, and third control codes, the received upload spreadsheet including an upload row that specifies an owner name for the upload row, a measure of the upload row, and a value of the measure; and generating a database that contains a data record in which the value of the measure quantifies a variable whose variable name includes the owner name of the upload row and the measure of the upload row,
the generating of the database being performed by a processor of a machine based on the upload row and on the first, second, and third control codes parsed from the received upload spreadsheet.