Relation for Google Sheets
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
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
codenamecodenameprice
manufacturer
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
Loading...