Methods and systems for connecting a spreadsheet to external data sources with temporal replication of cell blocks

摘要

The technology disclosed relates to automating creating of new blocks of cells in a spreadsheet—receiving a user identification of a first block of contiguous cells specifying access to first data from an external source using a formulaic data specification; causing display of a wizard panel with controls operable without user input, and receiving a user specification of a replication position at which a second block of cells is to be replicated as a variation on the first block; receiving a user specification of a temporal interval relationship between the first and second blocks; receiving a creation trigger parameter for when the second block should be replicated at the second position; and creating the second block at the replication position and inserting an adjusted formulaic specification for the second data, based on the formulaic specification for the first data and the temporal interval relationship between the first and second blocks.