Use the **guide** to find the start block of the council term, the block hash with a block number.
Open this link, specify the following data
Now you need to specify these numbers in Summary
Open Past Proposals Page - https://dao.joystream.org/#/proposals/past
Specify the type - Update Working Group Budget and you need to find proposals that replenish the budget of the HR group.
You can see in the proposals how much the group's budget was replenished. You need to find all the proposals for the period and calculate how much was replenished in total for the period.
Open graphql-console https://graphql-console.subsquid.io/?graphql_api=https://query.joystream.org/graphql
Enter this command
query rewardPaidEvents { rewardPaidEvents (limit:1000000, where:{inBlock_gte:**2332800**,inBlock_lte: **2433600**, group: { name_eq: "operationsWorkingGroupBeta" }}) { amount } }
In green I have highlighted the data that changes with each period - the start and end blocks of the period
Next, you need to calculate the sum of all rewards
I use Google tables for convenience. Copy the data and paste it into a google table. Divide the text into columns. Use space separation.
At the bottom of the table, use the SUM command to calculate the total amount of rewards.
Then you need to find one of the group leader's awards, copy the value and on the same page to find the number of payments to the leader with Ctrl + F. 260460*7=1823220 tJOY - Lead rewards
Subtract the group leader's rewards from the total. 10056650-1823220=8233430 tJOY - Workers rewards