Excel as Code

• excel_as_code

  5 118 0.0

  Blog on excel as code

• stanton

  1 23 0.0 Python

  Greenbox: Excel-based Monte Carlo three-point sensitivity analysis

There are a few. I use xlwings for https://github.com/asemic-horizon/stanton , which is some bits of code to specify expert-led sensitivity analysis from Excel and use the results to emulate the spreadsheet from a ML model.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• terminusdb

  51 2,638 8.9 Prolog

  TerminusDB is a distributed database with a collaboration model

  

• owid-content

  1 10 9.7 Python
  

At my last job at OurWorldInData we made something like this. One of the head researchers would build sophisticated spreadsheets containing all the transformations and views our users could do, and rather than re-implement that logic in Typescript, we saved it as TSV and built a spreadsheet editor for the researchers to use.

Demo: https://www.youtube.com/watch?v=0l2QWH-iV3k

Changes in the spreadsheet UI then work really well with git. For example: https://github.com/owid/owid-content/commit/37ef12d65655fa14...

• pycel

  1 27 0.0 Python

  A library for compiling excel spreadsheets to python code & visualizing them as a graph (by stephenrauch)

• materialize

  117 5,585 10.0 Rust

  The data warehouse for operational workloads. (by MaterializeInc)

  

Suggest a related project