I love spreadsheets, graphs, data and crypto. So I've collected all the data posted in the Moon distribution .CSV files, made some sense of it all in a spreadsheet, then made us some graphs.

Total Karma

https://preview.redd.it/54a8yxlhawja1.png?1413&format=png&auto=webp&s=4a696142cd731f05db9617a7b75334d76b6b5a3c

The Sum of all the karma per round

A 4% decrease since the last round. I've added the average BTC price for the 28 day Moon round to this graph as the total karma has seemed to move up and down in line with its price. I've done other analysis posts that show we get activity spikes when BTC fluctuates, with the most happening during dips as it seems that misery likes company.
The spike at round 33 was probably from all the FTX bullshit and the 700 news link posts about it every hour.

I'd expect roughly the same amount of karma next round, but who knows what shit will go down in the next few weeks.

The ratio of Moons to karma

https://preview.redd.it/28dkbixlawja1.png?1413&format=png&auto=webp&s=34b7b5646ac0c7d4f8eec88e521e8ed3d493eb37

The all important Moon to karma ratio. Multiply this number by your karma score to determine how many Moons you receive for each round. (Round 12 - 0.88 Never Forget)

This number will naturally decline over time as the Moons released per round reduce by 2.5%.

Round 36 - HO-LEE-SHYTE
The admins told us they were closing the testnet bridge and burning all the Moons, one of the other mods made an announcement post to let everyone know
We asked admins if half of the Moons would be re-introduced in the next round and they said 'nah'
They were either lying, fucking with us, or they done fucked something up ^{It wouldnt be the first time they fucked something up} because half of those Moons were indeed re-introduced.
An additional million Moons were added to the regular amount which more than doubled the ratio everyone was expecting. Crazy times

Number of users on .CSV

https://preview.redd.it/9n8lgljvawja1.png?1422&format=png&auto=webp&s=4500fe283d5ac0152406b570362b1c2f5697e9ff

This shows the number of users who earned karma for each round. The lower orange line is users with an active vault at the time the .CSV was published.

The number of users with vaults at the time of publishing the data overall averages around 60%. This doesn't indicate that only 60% of the users claim their Moons though as you have 6 months from the distribution to open your vault and claim them.

% of users with a vault

https://preview.redd.it/s5tnytb2cwja1.png?1396&format=png&auto=webp&s=babd446d4d02f7ea7ea1ea0590cdfaf7ed054fab

The spike from round 28 to 29 was caused by the implementation of CCIP 031 which removed vaultless users with less than 10 karma from the .csv

Average Moons per user & Median Moons per user

https://preview.redd.it/ilr5d1q3bwja1.png?1431&format=png&auto=webp&s=58984dcaef149eb4761df427b848106aba62c2ed

https://preview.redd.it/cfp43a05bwja1.png?1430&format=png&auto=webp&s=0785771542045331977132b7a9d36559100a39cf

The increase in average and median from round 28 to 29 was also caused by the implementation of CCIP 031.

The average Moons earnt per user takes into account a lot of factors: number of users, Moon to karma ratio, the reduction in Moons being released per round and the total karma.

Is weird how the ratio spike has increased the average but not the median.

Moons Market Cap Rank

https://preview.redd.it/0r5q2bmabwja1.png?1993&format=png&auto=webp&s=7ab8264ff4b0c4a4e308e5645be68e26a75d2fd0

Moonplace caused the spike from 933 to 769 and the one after to 693 was the purchases and the hype from the banner rentals.

Enough graphs, show me the spreadsheet

https://preview.redd.it/u9uqu74mbwja1.png?1081&format=png&auto=webp&s=ae852fb1d8b35e86702e214ea78f514eaba497a1

https://preview.redd.it/u0zgsd9pbwja1.png?1083&format=png&auto=webp&s=d2f09d34b83de63fac265aebe86d479b1ff16a0d

(The dates are a day ahead than most of you as I live in the future in UTC+13)

Previous rounds are here:

I've been posting these since Round 14 - You can find them here if you're bothered.

TL;DR Karma goes down, admins burned a bunch of Moons and fucking doubled the ratio, 1 Moon = 1 Moon, I fucking love spreadsheets.