How to calculate interest in Neobux by Microsoft Excel

I use Microsoft Excel to calculate interest with my account in Neobux


Example:
 

How to entering data:

1. RRs: your rent referrals.

2. Stand ads: fix ads you must click every day. 4 for standard/ 9 for gold

3. other: fix ads, mini ads... 

4. Earn 1: your click - very easy - oke

5. Earn 2: = RRs click : very easy - oke

6. Mini job: view in statistics: very easy - oke

7. Sum EA = Earn 1+ Earn 2.

8. RR cost/day: dificult to right caculate.

     - count number RR had clicked: = rr click/4 (N1) => autoplay (discout 15%) - view in dayly statistics

     - count number RR doen't click: = RRs - N1 = (N2) 

              => cost = N2 * 0.2/30 if renew under 30 days

                           = N2 * 0.2*95%/30 if renew 30 days

                           = N2 * 0.2*90%/30 if renew 60 days

 note: if you renew from 90 days - 240 days you must tunr off autopay. Anh RRs cost /day is easy to caculate. (but with new member its very hard to do).

9. Auto pay: view in statistics.

10. cost gold member: 90/360 = $ 0.25/day

Thats all.

You can use this file to test project:

Ex: 200 RRs, AVG 0.7 => profit =?

and 500 RRs, AVG 0.9 => profit=?

and my account 206 RRs, AVG 1.5 = more profit than 2 above example.

Link to download file here