Share
Explore

Borderland 2024: FREUD

FREUD (Fantastic RE-distribution Utility Datasheet) helps the Dream Team with the last step of the , where the members of The Borderland decide what gets funded.
After the Borderland members have distributed the funding (), many dreams will be left only partially funded. This means we need to redistribute funding between them. FREUD helps the Dream Team by calculating how the underfunded dreams compare. In short, FREUD helps with Dream Analysis. Or in other words:
In the grand carnival of creativity, dream projects clamor for love and support. There exists a finite reservoir of psychic energy to be allocated. Not all dreams can be realized in their entirety. Inevitably, the reality principle must intervene. Certain projects, much like unfulfilled desires repressed by the psyche, fail to amass the requisite minimum of funds to materialize. Here, the Superego of the FREUD committee, embodying the societal conscience, steps forth to ensure that this psychic energy does not remain stifled and squandered. In an act of redistribution, funds are taken from those dreams that have not reached the threshold and are reallocated to others teetering on the brink of fruition.
info

FREUD Models: How the algorithms work

A new feature of the FREUD sheet this year is that you can model redistribution with different algorithms. There are four algorithms, but all of them work essentially the same way:
Sort the dreams, including only the dreams that have not reached their minimum goal
Remove the funding from the dream at the bottom of the list
Put the money in a pot
Add money from the pot to the dream at the top of the list
If there is more in the pot than the dream at the top needs to reach its minimum, keep the remaining money in the pot
Repeat steps 2-5 until pot is empty and no more money can be moved
There are four models for how to sort the dreams for redistribution.
By number of funders
By how much SEK is missing until goal
By how close dream is to goal in percent
By a combo aggregation that combines the four other methods
Aggregation works by giving each dream a rank score. Rank is calculated as follows:
Sort dreams by funders, missing SEK and percent to goal
For each sorting, each dream is given a score. A low score is good. A score of 1 for the “Funders” sorting means that the dream had the highest number of funders. A score of 1 for the SEK sorting means that the dream needs the smallest amount of money of all to reach its goal.
All three scores are added together. For example, a dream that ranked 1st in number of funders, 90th in SEK remaining to goal, and 9th in percentage left to goal, would have combined score 100.
We then sort the dreams by their aggregation score.
megaphone

Running the models

You can run the algorithms and see the redistribution happening in the table below. If you click the Reset button on any of the models, the column for that model in the table will clear. To show the redistribution according to that model, simply click Run and watch the numbers in that column change. It’s a two step process, so when you see text on the button change to “Finish run”, click to finish the process.
If you want to understand the mechanism step by step, simply toggle the Loop switch. When the loop switch is off, every time you click Run the next action in the redistribution happens. If you want to finish, simply toggle the Loop switch again and press run to finish the algorithm.

Model
Description
Reset
Run
Loop
Next Bucket
Funded
Contributed
1
Combo
Rank by A+B+C combo
Reset
Reset
The Phoenix is phoenixing
106
4,000,000
There are no rows in this table

Model
Description
Reset
Run
Loop
Next Bucket
Funded
Contributed
1
Funders
Rank by funder count
Reset
Reset
Tiny houses in the Alversjö Garden and Sculpture Park
77
4,000,000
There are no rows in this table

Model
Description
Reset
Run
Loop
Next Bucket
Funded
Contributed
1
SEK
Rank by SEK left to goal
Reset
Reset
The Spaceport - Community Space, Cabaret, Fire, and 4 New Dreams!
138
4,000,000
There are no rows in this table

Model
Description
Reset
Run
Loop
Next Bucket
Funded
Contributed
1
Percent
Rank by % left to goal
Reset
Reset
Protea flower effigy
129
4,000,000
There are no rows in this table



Total budget:
4,000,000
Total decided:
4,252,872
Undecided funding:
-252,872

Total asked for:
4,677,192
kr Total asked for (stretch):
9,389,325
kr
Funding in unfunded buckets:
1,611,415


Show Dreams that reached goal in granting
Search
Dream
Goal
Stretch
Funded
Missing
Funders
Progress
Fund
Final
M:Combo
M:Funders
M:SEK
M:Percent
227,602
227,602
33,143
(194,459)
166
15%
-
227,602
227,602
227,602
0
42,075
95,800
112,900
77,405
(18,395)
390
81%
-
95,800
95,800
95,800
95,800
95,800
73,349
73,349
31,776
(41,573)
150
43%
-
73,349
73,349
73,349
1,233
73,349
72,650
72,650
55,510
(17,140)
282
76%
-
72,650
72,650
72,650
72,650
72,650
66,825
66,825
42,385
(24,440)
254
63%
-
66,825
66,825
66,825
66,825
66,825
65,000
117,500
15,969
(49,031)
73
25%
-
65,000
65,000
65,000
0
65,000
63,294
63,294
24,751
(38,543)
132
39%
-
63,294
63,294
63,294
63,294
63,294
60,000
225,000
26,980
(33,020)
175
45%
-
60,000
60,000
60,000
60,000
60,000
58,000
79,000
48,926
(9,074)
247
84%
-
58,000
58,000
58,000
58,000
58,000
56,538
94,795
30,773
(25,765)
107
54%
-
56,538
56,538
56,538
56,538
56,538
52,350
74,650
21,003
(31,347)
89
40%
-
52,350
52,350
52,350
52,350
52,350
42,300
64,800
11,352
(30,948)
49
27%
-
50,000
42,300
42,300
42,300
42,300
49,000
91,000
37,578
(11,422)
157
77%
-
49,000
49,000
49,000
49,000
49,000
47,810
72,398
45,960
(1,850)
254
96%
-
47,810
47,810
47,810
47,810
47,810
34,680
52,835
26,075
(8,605)
106
75%
-
45,000
34,680
34,680
34,680
34,680
43,200
87,650
18,691
(24,509)
78
43%
-
43,200
43,200
43,200
43,200
43,200
42,500
52,498
19,040
(23,460)
96
45%
-
42,500
42,500
42,500
42,500
42,500
26,016
313,300
13,048
(12,968)
49
50%
-
40,000
26,016
26,016
26,016
26,016
19
37,000
37,000
2,415
(34,585)
19
7%
-
37,500
0
0
37,000
0
36,195
43,102
27,460
(8,735)
153
76%
-
36,195
36,195
36,195
36,195
36,195
77,406
117,081
22,115
(55,291)
79
29%
-
36,000
77,406
77,406
0
77,406
35,656
37,156
28,495
(7,161)
179
80%
-
35,656
35,656
35,656
35,656
35,656
34,502
54,286
8,355
(26,147)
42
24%
-
34,502
34,502
34,502
34,502
34,502
34,250
44,250
23,616
(10,634)
103
69%
-
34,250
34,250
34,250
34,250
34,250
34,140
35,640
3,770
(30,370)
16
11%
-
34,140
0
0
34,140
0
33,800
53,000
17,187
(16,613)
65
51%
-
33,800
33,800
33,800
33,800
33,800
33,000
75,500
12,468
(20,532)
82
38%
-
33,000
33,000
33,000
33,000
33,000
31,900
31,900
21,540
(10,360)
109
68%
-
31,900
31,900
31,900
31,900
31,900
22,950
31,800
7,152
(15,798)
75
31%
-
31,800
22,950
22,950
22,950
22,950
30,500
41,000
15,445
(15,055)
76
51%
-
30,500
30,500
30,500
30,500
30,500
14,500
59,500
8,735
(5,765)
35
60%
-
30,000
14,500
0
14,500
14,500
6,500
73,920
1,550
(4,950)
6
24%
-
30,000
0
0
6,500
6,500
25,792
25,792
19,430
(6,362)
125
75%
-
25,792
25,792
25,792
25,792
25,792
25,620
32,170
24,227
(1,393)
97
95%
-
25,620
25,620
25,620
25,620
25,620
25,471
63,640
5,593
(19,878)
53
22%
-
25,471
25,471
25,471
25,471
25,471
24,335
33,335
11,663
(12,672)
80
48%
-
24,335
24,335
24,335
24,335
24,335
46,500
69,200
10,065
(36,435)
59
22%
-
20,000
46,500
46,500
46,500
46,500
20,000
27,000
16,725
(3,275)
59
84%
-
20,000
20,000
20,000
20,000
20,000
66,403
70,768
3,613
(62,790)
32
5%
-
20,000
0
0
0
0
19,872
19,872
13,360
(6,512)
120
67%
-
19,872
19,872
19,872
19,872
19,872
19,578
23,778
8,900
(10,678)
58
45%
-
19,578
19,578
19,578
19,578
19,578
19,350
19,350
14,170
(5,180)
90
73%
-
19,350
19,350
19,350
19,350
19,350
18,700
18,700
11,588
(7,112)
67
62%
-
18,700
18,700
18,700
18,700
18,700
18,000
25,500
14,717
(3,283)
86
82%
-
18,000
18,000
18,000
18,000
18,000
16,500
46,500
11,486
(5,014)
51
70%
-
16,500
16,500
16,500
16,500
16,500
15,804
26,003
15,518
(286)
79
98%
-
15,804
15,804
15,804
15,804
15,804
15,700
23,800
11,575
(4,125)
42
74%
-
15,700
15,700
15,700
15,700
15,700
15,000
15,000
7,110
(7,890)
39
47%
-
15,000
15,000
15,000
15,000
15,000
15,000
15,500
5,100
(9,900)
49
34%
-
15,000
15,000
15,000
15,000
15,000
14,900
14,900
13,820
(1,080)
88
93%
-
14,900
14,900
14,900
14,900
14,900
14,850
40,074
13,162
(1,688)
80
89%
-
14,850
14,850
14,850
14,850
14,850
14,560
18,560
3,508
(11,052)
42
24%
-
14,560
14,560
14,560
14,560
14,560
14,000
26,300
6,880
(7,120)
41
49%
-
14,000
14,000
14,000
14,000
14,000
13,858
13,858
4,014
(9,844)
25
29%
-
13,858
0
0
13,858
13,858
55