WDV depreciation in single line formula for broken period

[sanjuss2]

Hi,
Thanks in advance
I have attached hereby file for calculating deprecation WDV method for 2 cases
We are calculating depreciation in following manner
Half yearly as on every 30 September & Yearly basis i.e every 31 March

In Yearly calculation
If Asset Purchase between 01 April till 30 Sept we calculate dep. for 1 year & if it is between 01 Oct to 31 March dep. will be for half year

I have used the formula for calculating 1 year depreciation is Price * (1-Rate of Interest)^no. of Years asset used

For Eq.
Case 1 : Price : 1,00,000/- Date of Purchase : 05/03/2015 Rate of Depreciation : 10.00% p.a.
Depreciation as on dated 31/03/2016:
Half Year depreciation will be 5,000/- for broken period i.e. asset purchased between oct to mar
& Yearly depreciation calculate as on 95,000/- (Price-Dep) i.e. 9,500/-
Total amount is 14,500/-

The above stated formula couldn't calculate depreciation for broken period
Ho I can add broken period wdv in formula
Or is there any formula to calculate depreciation on the basis o dated
It will be much thankful for the solution.