I have created the linked spreadsheet for incorporating bonuses and rakes for different sites. It’s mainly designed to distinguish the real relative value of offers from different sites.
Use the summary tab.
Enter details of any bonus in the cells B1 to B8. These values are in cents(USD) per hand. So for 10$ per hundred raked hands enter 10 in B3 and zero in the other cells.
Enter a rough guess of your hourly loss or win rate in L11 to S11 for any levels your interested in.
You can change the number of hands an hour and average players at the table. However it set up to use the rake tables for full tables so probably best not to.
Read off the rates at each site for the given bonus structure. Relative values are going to be more accurate than absolute values.
Any sites and levels not there, feel free to add them yourself.
Let me know if you spot any of the goofs I must have made.