- Joined
- 16 May 2011

- Messages
- 21,829

Now I am getting 15-Mar as the next recharge date. But my Excel is still giving 17-Mar which is the correct.prateek1987 said: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

If you want to use my Excel and feels that it will help you doing the calculation each time you have a doubt on calculation, please use my Excel. Otherwise, I am not forcing you to use.

I can understand that your intention is to prove my Excel wrong and your calculation true. Ok let it be. Whoever want to use this file will use it.

Good night.. Going to sleep.

..