An Interactive Dashboard for the 14 Days to 14 Merits Bitcoin Node Challenge

[programmer3666]

I have created a data visualization & Interactive dashboard for the 14 Days to 14 Merits Bitcoin Node Challenge, organized by @NotATether https://asktom.cf/index.php?topic=5480200.0. I created this by making use of Google Sheets.

In order to achieve accurate results, I navigated through over 300+ pages of the challenge thread created by the organizer and capturing every eligible node runner and organizing their daily progress into a well structured & visualized system.
Although some participants received additional incentive merits but the visualization focused on the official challenge criteria which states that 14 Days to 14 Merits. So the merits were calculated strictly according to the challenge rules.

What the  Dashboard Offers is that:

It tracks daily node running progress
It automatically calculates completion percentages
It has a filter section that allows you to differentiate between Ongoing and Completed runners
It presents progress in a visual format with the aid of charts and summaries
It automatically computes merit qualification and also states Pending where a runner is awaiting to be merited after node completion
It displays the distribution of participants by percentage completion level
And it updates dynamically as more data is added.

Here is the link to the Google Sheet: https://docs.google.com/spreadsheets/d/1tkcdi7n7kKLr0AMegulEzuarOvOkjFCTZJORNeQ-sHA/edit?gid=0#gid=0

[Mahiyammahi]

Great work , it would be easy for NotATether to track people who have previously joined on this event or not. Aside from completed user tracking I don't think it would be useful. So how often your scraping the data, Ig once in 24h. Since my name is there then your data is valid 😁.

Don't say this is manual labour, you tried automation right?

[TokenTikas]

You have made it well but it seemed a bit random to me but one good thing that has been done here is that the names of those who have completed it will be known and it does not seem to be of any particular use. At the moment, only a small number of people are running this node and later they go on to run an LND node. Many people completed the Bitcoin Core node within 14 days, but they did not run the next LND node. If you want, you can also encourage them and you can nicely capture and keep the names of those who have completed it here.

[AakZaki]

Previously I would like to thank you for providing the names in the Spreadsheet, I just saw and read the Thread NotATether [CHALLENGE] Run A Bitcoin Node: 14 Days To 14 Merits , I just realized that there is this rule

Do not enroll alt accounts.

I'll try to find the cheater in that spreadsheet, even if it's not a signature campaign involving BTC payments, if anyone breaks the rules it's still a mistake.

[She shining]

I believe this would be better posted on the thread and really can't see reason why it's shared here.

[programmer3666]

Don't say this is manual labour, you tried automation right?

Thanks for the feedback boss!. for now you could classify it as semi-manual labour because the data collection and verification process was done manually and carefully structured with good excel formulas, it was not an automated scraping and again it was done intentionally because the thread format is not structured for clean scraping, like many posts contain quotes, some off topic replies as well and a lot of mixed formatting was included, trying to go through the route of automation would have definitely introduce bunch of errors, duplicates and even misclassification of the data. so in order to preserve the fairness, accuracy and also maintain a strict rule based counting, I took the time to manually navigate through the pages, validated each node runner and recorded only legitimate challenge progress.