ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Relation for Google sheets
2
This sheet has user defined functions to make simple relational algebra.
3
It uses the same syntax as Relation for Excel, with the following exception: expressions are made in Javascript, not in formula language.
4
The fun part: The functions work also on Sheets on iPad.
5
You can save a copy of the sheet to use the functions
6
This is work in progress
7
Matthias Bürcher
8
7.1.2018
9
matti@belle-nuit.com
10
https://www.belle-nuit.com/relation-for-google-sheets
11
12
Data
13
codenamecodenamepricemanufacturer
14
1Sony1Hard drive2405
15
2Creative Labs2Memory1206
16
3Hewlett Packard3ZIP drive1504
17
4Iomega4Floppy disk56
18
5Fujitsu5Monitor2401
19
6Winchester6DVD drive1802
20
7CD drive902
21
8Printer2703
22
9
Toner cartridge
663
23
10DVD burner1802
24
Functions
25
relRange#NAME?#NAME?
26
27
relSelect#NAME?#NAME?#NAME?
javascript has to be used for expressions, not google sheet formula
28
29
relProject#NAME?#NAME?#NAME?
30
31
relExtend#NAME?#NAME?
32
33
relRename#NAME?#NAME?
34
35
relUnion#NAME?#NAME?
36
37
relDifference#NAME?#NAME?
38
39
relIntersection#NAME?#NAME?
40
41
relJoin#NAME?#NAME?
42
43
relOrder#NAME?#NAME?
44
45
relLimit#NAME?#NAME?
46
47
relCell#NAME?
48
49
50
51
relFilter#NAME?#NAME?#NAME?#NAME?#NAME?
52
53
relAssert#NAME?#NAME?#NAME?
54
#NAME?
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100