Show HN: GridCraft, an advanced spreadsheet for data analysis and analytics
gridcraft.com
gridcraft.com
Here are some of the features that set GridCraft apart from other spreadsheets:
1) Formula language is functional and supports reuse of user-defined functions. No need to use an external macro environment like VBA or AppScript to make reusable data transformations. https://gridcraft.zendesk.com/hc/en-us/articles/202808670-Cr...
2) Matrix projection / transformation language. Process any matrix value (data source, spreadsheet area, or output of a formula or user-defined function) using a powerful matrix transformation language. Formulaic ability to sort, select, project, and group. https://gridcraft.zendesk.com/hc/en-us/articles/203540234
3) Data connectors: connect to various cloud services as well as JDBC/SQL and pull data into your spreadsheet using formulas.
4) Tabular import: bring in tabular data (CSV, TSV) as a data source and manipulate it with the same projection / transformation formula language used for external SQL and cloud data.
5) Always-on / always-connected: functions like INTERVAL and NOTIFYIF allow periodic evaluation and push/email notification based on spreadsheet conditions.
6) Region-level ACLs and sharing. Share a specific region of a sheet, or share a whole sheet as read-only and a specific region as read-write.
7) Full audit/revision log with ability to revert.
[1] https://itunes.apple.com/us/app/gridcraft-powerful-cloud-spr...
Also available to answer any questions you may have.