Abstract: Systems and methods are provided for managing data in a grid. In one example approach, a method comprises importing data from a data source to a range of cells in a grid, where the range of cells is specified by a notation input associated with the grid, and where the notation input includes a key specifying the data source and security information associated with the data source.

Abstract: Systems and methods are provided for managing data in a grid. In one example approach, a method comprises importing data from a data source to a range of cells in a grid, where the range of cells is specified by a notation input associated with the grid, and where the notation input includes a key specifying the data source and security information associated with the data source.

Abstract: Systems and methods are provided to improve the efficiency and productivity of using a remote server to display data in a grid. In one embodiment, a method for managing data in a grid displayed on a client device comprises, responsive to receiving a data request from the client device, returning to a cell or cells in the grid a cached calculation result corresponding to the data request if the data request is stored in a cache, and otherwise processing a calculation corresponding to the data request. In this way, a relational database may efficiently handle numerous data requests that would normally be handled by an online analytic processing server.