I think the additional data break-down I added to the OP lets us see the information for groups of sMerit Senders that do not have Merit Sources. Comments replied to LoyceVs post apply, so I think we can see the distribution pretty well without deteting the Merit Sources from the analysis (All 80 could be deleted, but I only know a bunch of them really from their explicit comments on the board).
Ive added a full list of uses with their ratios here:
Bitcointalk Reciprocal aggregates by user 20180531. I don't normally use Google Sheets, since for large data it's a bit slow, but I cloned my Excel sheet there. I did the exercise both from the Senders point of view an the Receivers, so the list has all the data to both sides of the equation (but the OP concentrates on the Senders).
This is a
personal estimate:
- Assuming 80% of merit sources are Legendaries
- Assuming 47k sMerit sent from legendaries
- Assuming there are 80 merit sources with a total merit generation of up to 18500 sMerit per 30 days
- Assuming 80% of 18500 sMerit are from sources with Legendary rank
- Assuming 80% of (80%of 18500) are really spent from sources
We can Assume around 8-9k to 10-11k sMerits montly for legendary rank are from legendary sources.
From here if Legendary ranks has 47k sMerit sent overall we can assume 90% of this are from sources.
This influence a lot the data for this rank.