303uru
Joined 3 years ago
Karma
557
Submissions
299
Member since
Aug 4
Joined 3 years ago
=LET(
h, ROWS(A2#),
names, A2#,
vals, K2:INDEX(K:K, h+1),
denoms, J2:INDEX(J:J, h+1),
k, 20,
groupAvg, SUMPRODUCT(vals, denoms) / SUM(denoms),
adj, (denoms/(denoms + k))*vals + (k/(denoms +
k))groupAvg, inc, (names <> "") \* ISNUMBER(vals),
namesF, FILTER(names, inc),
valsF, FILTER(vals, inc),
denomsF, FILTER(denoms, inc),
adjF, FILTER(adj, inc),
r, ROWS(namesF),
nShow, MIN(10, r),
sorted, SORTBY(HSTACK(namesF, valsF, denomsF), adjF, -1),
TAKE(sorted, nShow)
)Yes, that’s a balanced equation.
Now, do we have any evidence to back complaints?
Lack of water, unclean water due to data centers:
https://www.bbc.com/news/articles/cy8gy7lv448o
Data centers causing energy prices to increase:
https://www.bloomberg.com/graphics/2025-ai-data-centers-elec...
Data center natural gas generators flooding communities with pollution:
https://www.politico.com/news/2025/05/06/elon-musk-xai-memph...
Yes, “both sides”.