VizierDB / vizier-scala

The Vizier kernel-free notebook programming environment
Other
34 stars 11 forks source link

Spreadsheet Scratchpad #250

Open okennedy opened 1 year ago

okennedy commented 1 year ago

What pain point is this feature intended to address? Please describe. Classical spreadsheets allow users to define formulas wherever they want. e.g., frequently, users will add formulas alongside tabular data to compute quick summary statistics (sums, countifs, etc...). Vizier's relational spreadsheet model does not make this easy, as each cell belongs to a strongly typed column.

Describe the solution you'd like Provide a dynamically sized group of cells alongside the normal spreadsheet that can be used for quick back-of-the-napkin math. These cells can/should be stored with the spreadsheet, but will not be part of the actual dataset.

Describe alternatives you've considered Adding a new column just for summary statistics can be viewed as "heavyweight".