D2H Daily Burn Rate Calculator

[Prateek Marwadi]

18.7397 + .9863 = 19.7260
dbr + dvr = new dbr

74.9588 which shud be the balance of remaining 4 days (21-17 march)

u took a dvr so ur validity is 4 days less which costs u around 74.9588
now divide 74.9588/.9863 =76 days

 

[M.J.Sadiq]

18.7397 + .9863 = 19.7260
dbr + dvr = new dbr

74.9588 which shud be the balance of remaining 4 days (21-17 march)

u took a dvr so ur validity is 4 days less which costs u around 74.9588
now divide 74.9588/.9863 =76 days

They are deducting Rs.19.35 on daily basis including DVR. Could you arrive that DBR using your calculation? Without DVR, it was Rs.18.38. Can you arrive both?

..

 

[Prateek Marwadi]

my calculations r afcourse different thats y i wrote u.

but according to my calculations also u r getting the same validity.

 

[Prateek Marwadi]

ok if i go with u,

570/31= 18.387
600/31= 19.3548

so wat is the need of the excel sheet as then also its a simple calculation.

DBR = base pack+add on/ no. of days of that particular month

 

[M.J.Sadiq]

my calculations r afcourse different thats y i wrote u.

but according to my calculations also u r getting the same validity.

No bro. Your calculation is giving the validity till 26-Mar. Check the below calculation as per your output.

As per you the remaining validity would be 76 days as on 09-Jan-14 after activating DVR. Excel says the date after 76 days from 09-Jan is 26-Mar (not 17-Mar which is the correct date as per D2H website and my excel).

18.7397 + .9863 = 19.7260
dbr + dvr = new dbr

74.9588 which shud be the balance of remaining 4 days (21-17 march)

u took a dvr so ur validity is 4 days less which costs u around 74.9588
now divide 74.9588/.9863 =76 days

SMS received on 09-Jan-15. Balance as on 08-Jan-15 midnight (Rs.1384.01).

SMS received on 10-Jan-15. Balance as on 09-Jan-15 midnight (Rs.1364.65). Burned amount is Rs.19.36

SMS received on 11-Jan-15. Balance as on 10-Jan-15 midnight (Rs.1345.30). Burned amount is Rs.19.35

SMS received on 12-Jan-15. Balance as on 11-Jan-15 midnight (Rs.1325.94). Burned amount is Rs.19.36

SMS received on 13-Jan-15. Balance as on 12-Jan-15 midnight (Rs.1306.59). Burned amount is Rs.19.35

 

[Prateek Marwadi]

now tell me if i take sports add on of 60 bucks on 28 jan - so the next date wud be 27th feb as it is for a month.

but as per ur calculation- 60/31*4 = 7.7419 - jan 4 days
but 4 february - 60/28*27 = 57.8571 - feb 27 days

total is 65.60

 

[M.J.Sadiq]

ok if i go with u,

570/31= 18.387
600/31= 19.3548

so wat is the need of the excel sheet as then also its a simple calculation.

DBR = base pack+add on/ no. of days of that particular month

Ok. You are correct. It is simple for one month.

I recharged for 3 months. The DBR amount will be different for different month. For Feb, it would be around Rs.20. So, we cannot easily derive the next recharge date.

What would be the next recharge date if I am recharging for Rs.500 today? How would you calculate? You can do that in this Excel.

..

 

[M.J.Sadiq]

now tell me if i take sports add on of 60 bucks on 28 jan - so the next date wud be 27th feb as it is for a month.

but as per ur calculation- 60/31*4 = 7.7419 - jan 4 days
but 4 february - 60/28*27 = 57.8571 - feb 27 days

total is 65.60

To do this, you have to input Rs.60 under Debit column against 28-Jan since it is one time payment.

Don't give Add-On amount Rs.60 under Add-on column, since it is not a daily payment for the next one month. Give the amount after one month (after lock-in period).

By doing this, Rs.60 will be deducted from your balance on 28-Jan and so the next recharge date will be adjusted.

Next day onwards, the DBR will be the same which is only for base pack and not for add-on. So there won't be any change in next recharge date.

Try this once in the Excel and let me know what you are getting.

Before Add-On:

After Add-On:

For the case of my DVR add-on, since it is free for 3 months, they credited Rs.90 and then deducting Rs.30 per month via DBR.

So, I mentioned Rs.90 as credit which will increase the balance.

Since the DVR amount of Rs.30 is being deducted as DBR, I added it under Add-on, so that it will be included in DBR calculation. In that case, the DBR specific to add-on will be varying month to month. This is how D2H is doing.


..

 

[Prateek Marwadi]

bro.......u took my calculations wrong.
i clearly divide it on a DVR rate n not divide it with a DBR rate, there fore the 76 days was there.

i dint deduct 100 debited n 90 credited amount i.e. 10 debited i.e. -10 rs.

so ultimately u r getting ------------u took a dvr so ur validity is 4 days less which costs u around 74.9588
deduct 10 dr. amount i.e. 64.9588
now divide 64.9588/.9863 = 65.86 days

but plz its just DVR rate

now add both the amounts, u wud get exactly the same recharge date or validity plus a few bucks left in ur account which must b less than one day dbr ofcourse

 

[Prateek Marwadi]

bro.......u took my calculations wrong.
i clearly divide it on a DVR rate n not divide it with a DBR rate, there fore the 76 days was there.

i dint deduct 100 debited n 90 credited amount i.e. 10 debited i.e. -10 rs.

so ultimately u r getting ------------u took a dvr so ur validity is 4 days less which costs u around 74.9588
deduct 10 dr. amount i.e. 64.9588
now divide 64.9588/.9863 = 65.86 days

but plz its just DVR rate

now add both the amounts, u wud get exactly the same recharge date or validity plus a few bucks left in ur account which must b less than one day dbr ofcourse