How to calculate how much your post's rewards are worth!

I was curious (I'm always curious!) about how much the "Hive rewards" meant for each author. I made a spreadsheet, and made a few discoveries.

Quick lazy way to calculate: just multiply by 0.47.

Here's the breakdown for my last post:

Basically, it's ((hive+hp)*hivePrice+(hbd*hbdPrice))/2 = your monetary value. And if the monetary value is not shown, just check if there are any beneficiaries, and if not, chances are you're getting around 47.4% of the displayed value.

In my case, the displayed value is $15.28, and the total calculated by the formula (displayed only on hive.blog and ecency.com, and only before the post is paid out; otherwise you have to check your wallet on ecency to see your rewards earned).

Following the formula, I get 7.441 by adding the values for hive, hp and hbd. That is ~47.4% of the displayed value.

Quick spreadsheet reasoning:

I made some excel research to check some stuff. Please note that I did some crazy stuff without annotating it! The only thing you can get from it is, basically, that you'll always get around 47.4% unless your case is special.

Weird stuff I found...

Here's @acidyo's reward breakup on Ecency

• Please note that he earns rewards twice for the same thing. The first time, he earns only HBD and HP. All rewards I've seen for other people are usually HBD + Hive + HP. Why does he get HBD and HP?
• On the spreadsheet above, you can see that any time someone earns only HBD and HP, and no Hive, they get around 42.7% of the displayed value.
• However, right afterward, he goes on to earn 281.787 (which is 100% of the post's displayed value!) in HBD. Why? Dunno. That post had no beneficiaries. Someone please explain!

I don't know what trickery he used, but he got a lot of money where I would have assumed he would have gotten only around $133 out of that 281 displayed value! (281*0.474)

Anyway, this is my reasoning, and I hope it's kinda helpful.