Abstract: Dependency tree-based copying and pasting including receiving, by a workbook manager from a client computing system, a request to paste a first workbook element from a first workbook to a second workbook, determining, by the workbook manager, that the first workbook element of the first workbook is in a first dependency relationship with one or more other workbook elements in the first workbook, copying, by the workbook manager, the one or more other workbook elements with the first workbook element to the second workbook, wherein the first dependency relationship is preserved after the copying, and presenting, by the workbook manager on the client computing system, the second workbook comprising the first workbook element and the one or more other workbook elements.

Abstract: Generating period-over-period calculations using a cloud-based data warehouse including receiving, from a client computing system, a request to add a comparison value column to a table, wherein the request comprises an identifier of a date column, an identifier of a base value column, and an identifier of a prior period; matching a first set of dates in the date column to a second set of dates in the date column using the identifier of the prior period; generating a database statement to create the comparison value column, including organizing the comparison value column using values corresponding to the second set of dates in the date column; retrieving the comparison value column from a cloud-based data warehouse using the database statement; and presenting, on the client computing system, the table comprising the comparison value column.