README.md

formulaic

Usage

====

Given an N-dimensional spreadsheet defined with width M and height N, formulaic reduces the spreadsheet values per cell.

Line 1 should be two integers that define the width and height. Then, N*M lines containing the expression which is the value of the corresponding cell.

Input:

=====

6 6
A2
B1++
2
F3
4 5 * 3 *
20 100 / 3 +
1002
0 1 + 1 + 3 +
2
A3 D3 + E3 +
D4 D1++ * A6-- *
C5 3 *
63
201 9 + 15 /
B1-- 7 -
3 E4 * 5 *
E1 F2 / 4 +
55
6 3 + 17 +
D1++ A2 + E3 -
22 7 /
F1 67 + 3 * 3 +
45 B6 D2 +
E3++ 5 -
9.85 E5 +
1 4 7 -
A5 8 *
2 3 * 4 2 / + 5 3 * 6 + -
40291 100 -
62 34 23 +
186000 3 9 *
29301 D2 /
E2 F2 +
3
A4 D2-- + E2 C5 * B2++ +
5 10 * 15 20 / 25 +

Yields:

=====

6 6
1003.00000
1003.00000
2.00000
2.98123
60.00000
8.00000
1002.00000
5.00000
2.00000
482.31818
53865.00000
12.00000
63.00000
0.07143
-996.00000
217.50000
4.00000
55.00000
26.00000
-550.00000
0.31818
285.00000
-538.00000
-475.00000
-40181.14844
3.00000
480.00000
14.50000
-40191.00000
57.00000
27.00000
-0.01877
2.98123
3.00000
18.00000
26.33333
time: [19ms]