ID    Start_date    End_Date    Amount
1     2005-01-01    2010-01-01    5
1     2000-07-01    2009-06-01    10
1     2017-08-01    2018-03-01    30

ID  Start_date  End_Date    Amount  Amount_new  Usable  Start          End
1   2005-01-01  2010-01-01  5         45         0     2000-07-01     2018-03-01
1   2000-07-01  2009-06-01  10                   1
1   2017-08-01  2018-03-01  30                   1