Spreadsheet: 206930d1358318376-need-to-find-escalation-on-series-of-rent-data-for-years-in-horizontal-form-excel-formula-for-escalation
Sheet: Sheet1

[NAME] name | vendor code | vendor code | Location | office/warehouse | start date | expiry date | Escalation % | Jan to Dec 2012 | USD'000 | 2013-01-12 00:00:00 | 2013-02-12 00:00:00 | 2013-03-12 00:00:00 | 2013-04-12 00:00:00 | 2013-05-12 00:00:00 | 2013-06-12 00:00:00 | 2013-07-12 00:00:00 | 2013-08-12 00:00:00 | 2013-09-12 00:00:00 | 2013-10-12 00:00:00 | 2013-11-12 00:00:00 | 2013-12-12 00:00:00 | 2013-01-12 00:00:00 | 2013-02-12 00:00:00 | 2013-03-12 00:00:00 | 2013-04-12 00:00:00 | 2013-05-12 00:00:00 | 2013-06-12 00:00:00 | 2013-07-12 00:00:00 | 2013-08-12 00:00:00 | 2013-09-12 00:00:00 | 2013-10-12 00:00:00 | 2013-11-12 00:00:00 | 2013-12-12 00:00:00 | 2014-01-12 00:00:00 | 2014-02-12 00:00:00 | 2014-03-12 00:00:00 | 2014-04-12 00:00:00 | 2014-05-12 00:00:00 | 2014-06-12 00:00:00 | 2014-07-12 00:00:00 | 2014-08-12 00:00:00 | 2014-09-12 00:00:00 | 2014-10-12 00:00:00 | 2014-11-12 00:00:00 | 2014-12-12 00:00:00 | 2015-01-12 00:00:00 | 2015-02-12 00:00:00 | 2015-03-12 00:00:00 | 2015-04-12 00:00:00 | 2015-05-12 00:00:00 | 2015-06-12 00:00:00 | 2015-07-12 00:00:00 | 2015-08-12 00:00:00 | 2015-09-12 00:00:00 | 2015-10-12 00:00:00 | 2015-11-12 00:00:00 | 2015-12-12 00:00:00 | 2016-01-12 00:00:00 | 2016-02-12 00:00:00 | 2016-03-12 00:00:00 | 2016-04-12 00:00:00 | 2016-05-12 00:00:00 | 2016-06-12 00:00:00 | 2016-07-12 00:00:00 | 2016-08-12 00:00:00 | 2016-09-12 00:00:00 | 2016-10-12 00:00:00 | 2016-11-12 00:00:00 | 2016-12-12 00:00:00 | 2017-01-12 00:00:00 | 2017-02-12 00:00:00 | 2017-03-12 00:00:00 | 2017-04-12 00:00:00 | 2017-05-12 00:00:00 | 2017-06-12 00:00:00 | 2017-07-12 00:00:00 | 2017-08-12 00:00:00 | 2017-09-12 00:00:00 | 2017-10-12 00:00:00 | 2017-11-12 00:00:00 | 2017-12-12 00:00:00 | 2018-01-12 00:00:00 | 2018-02-12 00:00:00 | 2018-03-12 00:00:00 | 2018-04-12 00:00:00 | 2018-05-12 00:00:00 | 2018-06-12 00:00:00 | 2018-07-12 00:00:00 | 2018-08-12 00:00:00 | 2018-09-12 00:00:00 | 2018-10-12 00:00:00 | 2018-11-12 00:00:00 | 2018-12-12 00:00:00 | 2019-01-12 00:00:00 | 2019-02-12 00:00:00 | 2019-03-12 00:00:00
[NAME] | 3035-1 | 30351 | [NAME] | Office | 2011-12-01 00:00:00 | 2014-07-31 00:00:00 | 10% after 1 Year | 225000 | 4.5 | 18000 | 18000 | 18000 | 18000 | 18000 | 18000 | 18000 | 19800 | 19800 | 19800 | 19800 | 19800 | 19800 | 19800 | 19800 | 19800 | 19800 | 19800 | 19800 | 21780 | 21780 | 21780 | 21780 | 21780 | 21780 | 21780 | 21780 | 21780 | 21780 | 21780 | 21780 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
rajesh bansal | 5997-1 | 59971 | chandigarh | Office | 2011-12-01 00:00:00 | 2014-09-30 00:00:00 | 8% | 336600 | 6.73 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
manju bansal | 5998-1 | 59981 | chandigarh | Office | 2011-12-01 00:00:00 | 2014-09-30 00:00:00 | 8% | 336600 | 6.73 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 27500 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 29700 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 32075 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sabiha Khatoon Partner M/S S.K.J.& Co. | 2562-1 | 25621 | Ranchi | Warehouse | 2010-10-01 00:00:00 | 2013-07-31 00:00:00 | 0 | 424652 | 8.49 | 34671 | 34671 | 34671 | 34671 | 34671 | 34671 | 34671 | 36391 | 36391 | 36391 | 36391 | 36391 | 36391 | 36391 | 36391 | 36391 | 36391 | 36391 | 36391 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 5735-1 | 57351 | PATNA | Warehouse | 2011-06-15 00:00:00 | 2013-06-14 00:00:00 | 0 | 246500 | 4.93 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 21000 | 21000 | 21000 | 21000 | 21000 | 10500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
LALITA VIRENDRA GAUR | 6092-1 | 60921 | INDORE | Warehouse | 2011-09-12 00:00:00 | 2014-09-11 00:00:00 | 0 | 666444 | 13.33 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 55537 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P.L.Properties | 0955-3 | 9553 | Chennai | Warehouse | 2009-04-01 00:00:00 | 2015-03-31 00:00:00 | 0.07 | 9139863 | 182.8 | 393700 | 393700 | 393700 | 0 | 0 | 775000 | 775000 | 775000 | 775000 | 775000 | 775000 | 775000 | 775000 | 775000 | 775000 | 829250 | 829250 | 829250 | 829250 | 829250 | 829250 | 829250 | 829250 | 829250 | 829250 | 829250 | 829250 | 887300 | 887300 | 887300 | 887300 | 887300 | 887300 | 887300 | 887300 | 887300 | 887300 | 887300 | 887300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Smt.[NAME] | 0663-2 | 6632 | Dehradun | Warehouse | 2010-10-01 00:00:00 | 2013-06-30 00:00:00 | 0 | 199250 | 3.99 | 6165 | 6165 | 6165 | 6165 | 6165 | 6165 | 6165 | 0 | 0 | 0 | 6781 | 6781 | 6781 | 6781 | 6781 | 6781 | 6781 | 6781 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Pristine Developers Private Limited (Lease) | 2909-1 | 29091 | [NAME] | Office | 2008-10-05 00:00:00 | 2017-01-20 00:00:00 | 5% after 3 years | 3335424 | 66.71 | 2367736 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1647121 | 1734790 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1894189 | 1222057 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 5736-1 | 57361 | Patna | Warehouse | 2011-06-15 00:00:00 | 2013-06-14 00:00:00 | 0 | 246500 | 4.93 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 21000 | 21000 | 21000 | 21000 | 21000 | 10500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 1424-1 | 14241 | Bhubaneshwar | Warehouse | 2011-04-01 00:00:00 | 2013-03-31 00:00:00 | 0 | 891000 | 17.82 | 67500 | 67500 | 67500 | 0 | 0 | 76500 | 76500 | 76500 | 76500 | 76500 | 76500 | 76500 | 76500 | 76500 | 76500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] and Company | 0142-1 | 1421 | New Delhi | Office | 2010-09-01 00:00:00 | 2016-08-31 00:00:00 | 0.06 | 9265772 | 185.32 | 676805 | 676805 | 676805 | 676805 | 676805 | 676805 | 676805 | 676805 | 717413 | 717413 | 717413 | 717413 | 717413 | 717413 | 717413 | 717413 | 717413 | 717413 | 717413 | 717413 | 760458 | 760458 | 760458 | 760458 | 760458 | 760458 | 760458 | 760458 | 760458 | 760458 | 760458 | 760458 | 806085 | 806085 | 806085 | 806085 | 806085 | 806085 | 806085 | 806085 | 806085 | 806085 | 806085 | 806085 | 854450 | 854450 | 854450 | 854450 | 854450 | 854450 | 854450 | 854450 | 854450 | 854450 | 854450 | 854450 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Aggarwal Associates | 0728-1 | 7281 | Jammu | Warehouse | 2008-01-01 00:00:00 | 2017-12-31 00:00:00 | 15% after 3 Years | 369000 | 7.38 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 30750 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 35363 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0