Saturday, June 15, 2013

Rented Referral Calculator

Follow us on twitter

I just designed this Rented Referral calculator in Excel, as I was kind of fed up of manually trying to figure out AutoPay and AutoRenew rates every day. Hands up! Admittedly I am not the best at Excel, that’s why I would like you to download it and play around with it, please leave feedback in the comments section below, as I’m sure I will need to revise a couple of things ;)

It basically calculates your daily profit (or loss) from rented referrals taking into account AutoPay and AutoRenew settings as well as how many RR’s you recycle.

rented referral profit calculator
Neobux Rented Referral Profit Calculator

Neobux Rented Referral Calculator Instructions

It’s fairly straight forward. The only cells you have to change are the ones in purple:
neobux calculator
  • Membership – It’s only built for Standard and Golden right now, just type in which you are
  • Number of Rented Referrals – how many RR’s you have
  • Number of RR’s that Click – needed for AutoPay calculations
  • Average Click rate – as average over all your rented referrals
  • AutoPay On/Off – not even going to comment on this one
  • AutoRenew Days – how many days you have AR set for – enter 0 if turned off
  • Number of Recycles – how many RR’s you recycled
The only really tricky one here is how many rented referrals click on a given day. You can find this out by logging into your Neobux dashboard, navigating to the statistics page and finding your AutoPay cost from the bottom right graph (just roll your mouse over the point and the value will pop up). Divide this number by your AutoPay value per referral. For example, if my AutoPay cost for the day was $0.5016 and my AutoPay rate was $0.0057 – I would divide $0.5016 by $0.0057 = 88 referral clicks that day.
Tip: If you have AutoPay turned off, you can enter anything here. The spreadsheet is (or should I say I am :) ) smart enough to figure out not to charge anything for AutoPay if turned off.
Click on the second worksheet labeled “Profit”
neobux profit calculator for rented referrals
That’s it! Told you it was pretty simple. Feel free to share this with anyone and everywhere you like, providing you keep the link to this website and logo intact in the spreadsheet!