The Objectsheet: Home

The Objectsheet A casual, object-oriented data analysis tool

Function Reference

The Objectsheet is a spreadsheet-like tool that uses Javascript for data, formulas, and code.

Instead of A1/B2 cartesian notation, the Objectsheet organizes rows of cells into Javascript objects.

Objectsheet formulas, formats, styles, event handlers, etc. are organized into a "Template" within each Table.

The Objectsheet provides strong database-like analysis capabilities without the need for separate constructs (like pivot tables).

The Objectsheet application is fully contained in a single HTML file and works with most major browsers.

Why? The goal of the Objectsheet is to make working with data-oriented models easy, safe, and manageable by:

Making it easy to see how a given model works	"Templates" within tables organize formulas and formats Data, formulas, formats, and code can all be viewed at once Easily assign meaningful names to tables, rows, columns, and cells in formulas
Avoiding common errors when developing a model	Automatically highlights manually entered cell values/formulas Formulas apply over an entire column or table without replication Self-contained tables can be moved around and formatted independent of each other; not bound by a single large grid
Helping guard against errors or model damage by users	Simple but powerful mechanisms to flag or prevent entry of improper data Locking Templates prevents users from accidentally changing a model's rules Easy to make cells read-only, preventing users from accidentally changing static data. If a user overrides a cell's formula with data, the formula returns if the data is later erased.
Easy to integrate and interact with other applications	Open JSON file format allows other applications to easily read Objectsheet files. Easily interact with external data sources (e.g., XML, JSON) from within the Objectsheet.

Learning There are a set of live on-line tutorials to introduce you to the Objectsheet. There are also screenshots and live examples that illustrate concepts and capabilities.

Download The Objectsheet is available in several forms for download, under the BSD license