Most of our calculations are managed on a weekly basis, not a daily basis, since it smooths out irregularities in member posting patterns a little more.
There is a table in the upper right corner of the Data tab in the sheet that breaks out the weekly voting power available to the programs. I only upvote the vote values in there every couple of days, but it will get you in the right direction.
I'm always happy to chat in discord. Evening (USA) are best for me.
Ok thanks - ill look into it over the wknd then maybe catch you in the chat!