A system for data transformation includes a database, a spreadsheet storage of a spreadsheet for planning, an interface, and a processor. The spreadsheet storage is separate from the database. The interface is configured to receive a database datum associated with a large time period. The processor is configured to generate a plurality of spreadsheet data based at least in part on the database datum. Each spreadsheet datum is associated with one of a set of small time periods. The plurality of spreadsheet data is stored in the spreadsheet storage. The spreadsheet storage is separate from the database. The processor is configured to provide the plurality of spreadsheet data for display in the spreadsheet.