I've attached an Excel file to show percentage increase of RAC over the weeks.
This is a relatively impressive spreadsheet, in that I see that it uses the correct exponent function (2.71) that BOINC uses and the decay formula appears to be correct, but I see a few bugs in the sheet that causes it to lag over time:
- This does not take into consideration the compounding effect of RAC. RAC is compounded at least once per day (roughly) when a host solves a WU. For example, lets say machine A had zero rac, and worked for 24 hours to solve a 100 RAC workunit, once per day. That means it would check in One Day after epoch, 86400 in since inception with 100 credits, and while those 100 are granted, its first decay point would be ONE day, its RAC IN would be the age of its PRIOR RAC (of 0). On Day 2, its prior rac of 100 would be 2 days old and its new 100 credit would be 1 day old. With a grand total of 189 rac on day 2.
So you must add a running total to this to show the prior days RAC total, and the new total so that they always are able to be decayed separately per the formula (Not 0 for one and the grand total for the IN).
- If the machine is crunching 100 new Credits per day, then the grand total in 4 weeks must be a RAC of 903 (not 100). 100 Credits per day means 100+100+100... = 500 RAC on week 1... Not 50 rac on week 1.
So I think if you add a running total for Prior days End and New days begin it will match boinc.
A 100 RAC input should yield a 920~ or so RAC at the end of the 31 day period...
Great job!