I love spreadsheets, graphs, data and crypto. So what better way is there to spend my free time than looking at the Moon data. Time spent making a spreadsheet is seldom wasted.

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.

Here are some graphs

Total Karma

https://preview.redd.it/17v39u9r86n71.png?926&format=png&auto=webp&s=bd81f76988a8bbe3c6ff9a14040d39838d5cd849

The Sum of all the karma per round

A 38% increase since the last round. Still maintaining the hype, again pretty much in line with the market.
(I removed the data labels for the first 7 rounds as it was cluttered)

The ratio of Moons to karma

https://preview.redd.it/1cjawskv86n71.png?925&format=png&auto=webp&s=5c85d04f156df3263b7b8454754a8093016edc8f

The all important Moon to karma ratio. Multiply this number by your karma 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%

​

Number of users on .CSV

https://preview.redd.it/66upquqx86n71.png?931&format=png&auto=webp&s=7d33e88391ef07b47b52b2f7fd78dc680ccd2cbc

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

(I removed the data labels for the first 7 rounds as it was cluttered)

Average Moons per user

https://preview.redd.it/l459rmr496n71.png?935&format=png&auto=webp&s=eab0dedc45253abd5f781394c1ec44b26c2a4345

I like an Average

This average 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/x8q32qhc96n71.png?906&format=png&auto=webp&s=543026c45a60a8bcce1fd6fc2e5951b03376d064

I've added a running total of Moons, since it was confirmed in this post that the unclaimed Moons will not be reintroduced to orbit.

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

Previous rounds:

• Moon Metrics - Round 14
• Moon Metrics - Round 15
• Moon Metrics - Round 16

TL;DR Karma goes up, ratio goes down, 1 Moon = 1 Moon, I fucking love spreadsheets.