tldr; I built a google spreadsheet with all data, statistics & metrics I could find and gather for MOONs. I will keep updating it, further developing it and adding future data. We also now have some data repositories with the monthly csv files.

First some disclaimers!

1. This is NOT a small spreadsheet. You might need some time to digest it. If you intend to do right away, make a copy of the spreadsheet. If you aren't going to do so right away, you may consider to bookmark it in your browser and some days later, make a copy of it and change things around.

2. This is not easily usable by all users. If you have no interest in data, spreadsheets, graphs, calculating things/values/your portfolio or modifying things, forming conclusions based on analysis of given data, etc, this might NOT be for you! (At least not right away! But your feedback is also valuable in further developing this open spreasheet.

How, what and why

Around 15 days ago I posted this, https://www.reddit.com/r/CryptoCurrency/comments/123boz5/karma_moons_all_data_public_spreadsheet_public/ where I was asking if there was a public, open source of all MOON data I could use to draw statistics from.

The huge problem (in my opinion) was that any average user (like me) didn't have easy access to data for MOONs, if any at all.

r/CryptoCurrency subreddit, wiki page and nova.arbiscan are accessible to all. However a lot of data, was behind barriers if existant at all: even the monthly .csv files with the MOON distribution per karma, are now not available prior to round 25 and quite soon 25 round will also not be available.

Also some metrics published here each month, were only images of data tables and not the data itself. So, none but the creator - moderator, could use them and work with them. Don't get me wrong. Every data is valualbe. But data in row format that can be easily used by anyone, is straightforward better and more valuable to all.

The problem with the .csv files was solved by https://github.com/jackiec1998 who just recently created a github repository on Github, just some days before I asked. He gathered the files from the mods. I was pointed then at this repository.

Jackie, if you are reading this (couldn't find you even via email), thank you! Also, a big Thank you as part of the community, to some of the few people that helped me! To my mind, the importance of data being availalbe to all and also being decentralisdly available is of high importance and takes MOONs one step further down the decentralization goal.

(I even made a google drive copy of them, plus with some of the proposed versions of the distribution .csv files. I will also update it each distribution and the link is here: https://drive.google.com/file/d/15iHwIxB7k7cCmJDzOfwlfjpC8ZAmn853/view?usp=sharing)

So, I gathered all data from everywhere I could find. All above places and even ccmoons(dot)com, moonexchange(dot)org/slp_leaderboard.php and of course throught the github repository I just mentoned. (In my spreadsheet, all these, I call them Data Nodes.)

Slowly and steadily I created this spreadsheet. I am not the best with spreadsheet and functions, but I am proud of the work I put there these two weeks for me and every one of you that will find this useful in any way.

Spreadsheet Link

Link to spreadsheet: https://docs.google.com/spreadsheets/d/1UoF2Vl3Yky-ZzSqMvOoNGYg4ZDttr1D67Xti_gYvHyU/edit?usp=sharing

Spreadsheet data and what it contains

Currently, the spreadsheet consists of 9 tabs. These are:

• 01. Front Page (Landing page of the spreadsheet)
• 02. MOONs Stats (Data around MOONs, Karma of users per round, etc A user can edit the 2nd section of this tab, however this stil need some more development)
• 03. My MOONs Dashboard (serving as a quickview for a user. A user will have to edit this tab to use it).
• 04. MOON Distribution Posts (Data around posts made for MOON distribution each 28 days)
• 05. CCIPs (Data around CCIPs and their posts). (This is by far my favorite tab and is WILD!!)
• 06. Charts (All the charts of the different tabs of data of the spreadshhet. It currently has 24 charts! The ideas for charts are numerous. Some graphs are more interesting than others, at least for me!)
• 07. Liquidity Board (This tab has the liquidity leaderboard for MOON/ETH pool on Sushiswap. It is automaticaly updated)
• 08. Liquidity Board Snapshots (This tab will hold all "snapshots" i make of the leaderboard table..)
• 09. Change Log (Tab with all changes I do. It helps in transparency and people knowing what I changed through time)

I won't go into further details, you can see the data and graphs by yourself. Just in case, someone wants a picture or two of the spreadsheet data and graphs here:

​

Tab 02 MOON general stats.

​

Tab 04 stats for posts about MOON Distribution.

​

Tab 05 CCIP data!

​

Chart 02. 01. MOON / Karma ratio in logarithmic.

Chart 02. 04 with user count on csv files in logarithmic.

Chart 04. 03. Correlation of BTC price with karma and comments on posts about MOONs distribution.

Future and Feedback

I will keep updating it, further developing it and adding future data. Anyone that wants to provide feedback in general, ideas or questions about:

2A. formulas

2B. functions

2C. graphs

2D. specific data

you can ask me or send a pm.

This is my contribution to the community! Hope some people find it useful and build further from here with it. Use any data provided in this spreadsheet freely. Don't even ask! Have fun!

very small tldr; Here is an open spreadsheet with all MOONs stats, data and a lot of graphs.

​

Link is here again:https://docs.google.com/spreadsheets/d/1UoF2Vl3Yky-ZzSqMvOoNGYg4ZDttr1D67Xti_gYvHyU/edit?usp=sharing