spdrman / dbss Goto Github PK
View Code? Open in Web Editor NEWThis project forked from i-e-b/dbss
[Working] A toy spread-sheet engine using SQL for backing
License: BSD 3-Clause "New" or "Revised" License
This project forked from i-e-b/dbss
[Working] A toy spread-sheet engine using SQL for backing
License: BSD 3-Clause "New" or "Revised" License
DBSS ==== A toy spread-sheet engine with SQL backing Each cell can have a name, a value and a formula. Names hide but don't overwrite formulas and values (like giving a function or constant a name) Formulae update values based on calculations Values are values. Formulae DON'T start in '=' (this isn't Excel!) Formulae are infix, support functions and scientific notation of large numbers. Functions are nestable. Operators: + add - substract * multiply / divide ^ exponent % modulo ! Constants defined: (case insensitive) pi - Value of ฯ e - Value of e R - Row (Y-value) of current cell C - Column (X-value) of current cell Functions defined: (case insensitive) LOOKUP functions (co-ords are absolute. To get relative co-ordinates, do like "$(C,R-1)") $(x,y) - value of cell at co-ordinates given $f(x,y) - function string of cell at co-ordinates given $n(x,y) - name of cell at co-ordinates given floor(x) - integer value from floor of float ceil(x) - integer value from ceiling of float sqrt(x) - square root of x cos(x) - Cosine of x sin(x) - Sine of x sign(x) - *ve sign of x (-1, 0, 1) TODO ---- - More common functions - Lookup by cell name - Lookup by truth-table (1D and 2D to start with, possible reduction sets for 3+D) - Colour code cells by what fields are populated. - Use named cells as functions in formulae
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.