I have added a sheet for the first cycle to the budget file, which so far has variables for all the basic numbers and calculation of available budget. Only thing missing is the actual payout calculation.
Edit: Uploaded again. Purple numbers are variables you can change. Added cycle budget, improved wording.
Edit 2: Sorry, uploaded yet another version. Changed everything to be BTC instead of sats and only round to 8 decimals in the very end.
Not sure I’m understanding the spreadsheet correctly. “Grant cylce 1” is the November actions right? Did we all just happen to get earn 10k credits or am I missing something?
That’s just a placeholder number, because we’re still waiting for the real numbers. The important thing is the calculation, which is now ready for action.
It is also still missing the 2020 expenses to be deducted before we can calculate the real budget left.
I have split up the files into 3 now, after adding expenses and reimbursement sheets. The old file is back to just being the guessing game, while expenses.ods has expenses and reimbursements, and contributor-grants.ods contains the grant cycle data and calculations.
With the help of @greg I have also finalized the first reimbursement documentation, for expenses paid in 2020, as agreed before. In addition to the source file, you can also find it here (will update IPFS CID after completing payout data):
Mid-market-rate conversions are 0.08640840 for 1663.07 EUR and 0.00258000 BTC for 60.00 USD, resulting in a reimbursement sum of 0.0889884 for the 2020 expenses. I will create a multi-sig tx for that, which 2 more people need to sign for completion. The receiving address will be 3ANCzotg5HAP4zN77BFyESuD2tsB2TEJLT.
Edit: wait, I’m slightly confused now. Could we discuss this in chat real quick?
Edit 2: @bumi You seem to be offline now in chat. So let’s discuss here:
I think we’re missing the kredits earned during cycle 1 in these numbers. I see total kredits from all contributions up to the end of cycle 1, but not the actual kredits confirmed during the cycle (as we cannot use the previous total to calculate that with the very first cycle)
I remember us planning to use block numbers that account for the confirmation period. I.e. kredits confirmed in cycle 1 would be one week delayed from the 1st of the month. No?
Could you just comment on the second question, too? The way it is now, we kredit contributions made between one week before the cycle up to one week before the end of the cycle, no?
hmm, not sure if I got that correct/remember that correct.
the numbers above show the confirmed kredits within that cycle. - it compares the block number stored in the contribution.
Which I think basically is what you describe?
A contribution that confirms on December 1st. was made a week prior to that.
A contribution made on December 30th confirms in January, so that one is not included in the December cycle.
I remember us planning to have the contribution cycles correspond roughly to actual months, hence wanting to change the block numbers to one week after the rough cycle-month time frame. But apparently I’m the only one remembering that then, so I might be wrong about it.
I can see why we wanted to do it, of course. It seems much clearer to think about cycles in terms of calendar months (even if they don’t match exactly over time), than it is to plan with “January 7 to Feb 6” and such. Long-term, those shifts can amount to a week or more, of course, so maybe starting out with random calendar dates is also fine.
so we say contributions in December - meaning we use December 1st + 40320 blocks (1 week) to January 1st + 40320 (1 week).
thus all contributions are in that have been CREATED within December.
if so, I have to adjust the numbers above again. sorry.