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/5t5xvh2nqq091.png?width=901&format=png&auto=webp&s=0589fbc8367130ce9bea04caf9a1e72c73404ef5

The Sum of all the karma per round

A 32% 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 decline this round can also be attributed to the passing of CCIP's 029 & 030

The ratio of Moons to karma

https://preview.redd.it/fm0tx7nzqq091.png?width=1408&format=png&auto=webp&s=b3f83d6143d64be735b707841f2469d62cb769c5

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%.

This was the fourth round we had Moons re-introduced that were used to purchase the subreddit membership. This round there were 55,660 additional Moons distributed, which increased the ratio by roughly 0.03

Number of users on .CSV

​

https://preview.redd.it/ln2av879rq091.png?width=906&format=png&auto=webp&s=acea70642aed2dcdf6c5c32caecc33a06746461c

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 52%. This doesn't indicate that only 52% of the users claim their Moons though as you have 6 months from the distribution to open your vault and claim them.

Average Moons per user & Average Karma per user

https://preview.redd.it/1tlqj5lgrq091.png?width=1423&format=png&auto=webp&s=1958cc0689b739d5ba33f2051adc7c3c0f4216a8

I like an Average

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.

Enough graphs, show me the spreadsheet

​

https://preview.redd.it/qw3z730rrq091.png?width=1065&format=png&auto=webp&s=9ea261ab77fce69e6bca77e0a358af1ea2db5e25

https://preview.redd.it/9q980nkwrq091.png?width=1066&format=png&auto=webp&s=8159fc33ed6f119e933e48d7e430208a41e5ac46

I gotta split it into 2 now because its getting massive ^(giggidty)

Couple of new columns recently, Moons added to the regular amount and the karma cap now that CCIP 029 Dynamic Karma Cap passed and was implemented this round.

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

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 again, ratio goes up again, 1 Moon = 1 Moon, I fucking love spreadsheets.