search

OutlierVentures / QTM-Interface

GNU General Public License v3.0
28 stars 18 forks source link

Issue With Utility Payout Sources on Excel #30

Closed BlockBoy32 closed 1 year ago

BlockBoy32 commented 1 year ago

Hi I was looking at some of your functions for calculating end balances for a token bucket(159-164) and I noticed this function:

SUMIF('Background Data'!$A$47:$A$52,'Data Tables'!$B175,'Data Tables'!D$159:D$164)

It appears to be calculating values based on if its payout source is the same as the bucket in the row. The issue I am seeing is in the background data there appears to be only 3 functions for potentially calculating payout sources but within the utilities tab I believe I see 4. Let me know if there a reason for this, thank you.

achimstruve commented 1 year ago

Please help me to understand your question:

  1. Where do the numbers (159-164) refer to? Are these lines in one of the .py files?
  2. Which cell does contain this formula?
BlockBoy32 commented 1 year ago

It refers to the rows on the QTM excel sheet with the data tables. The final token balances look like they check if they have a payout source from the utility, and it appears that only 3 of the utilities are included in the data background, we can chat about it tomorrow if it's still confusing over messages

achimstruve commented 1 year ago

Okay, Thanks for the clarification of your question. I know what you mean. With balances of token buckets you were referring to the cell rows 174-178 in the spreadsheet QTM. The reason lies in the nature of the utilities:

  1. Not all of them have payout sources
  2. The payout source for incentivisation is treated differently from the other utilities as it does not depend on agent token allocations / deposits.
BlockBoy32 commented 1 year ago

There is still only 3 out of the 4 not including incentivisation. Just want to make sure you are aware.

achimstruve commented 1 year ago

There are 4 payout sources as follows:

  1. staking apr rewards
  2. liquidity mining rewards
  3. holding rewards
  4. incentivisation (excluded as explained above)

Which one is missing in your perspective?