Spreadsheet: 479044d1473187645-drawdown-calculate-size-and-length-of-multiple-drawdown-phases-non-vba-draw-size-and-length-20160906
Sheet: Forum Post #1

Date | Equity Curve | Draw (%) | Draw (Size) |  | [NAME] per phase | Recovery Period | 1) [NAME] per Phase (%) | 2) Draw Length
2015-01-04 00:00:00 | 1 |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 | -1 |  |  |  |  |  | - | -
 | 3 |  |  |  |  |  |  | 7
 | 5 |  |  |  |  |  | - | -
 | 7 |  |  |  |  |  | - | -
 | 8 |  |  |  |  |  | - | -
 | 9 |  |  |  |  |  | - | -
 | 10 |  |  |  |  |  | - | -
 | 9 |  |  |  |  |  | - | -
 | 8 |  |  |  |  |  | - | -
 | 7 |  |  |  |  |  | - | -
 | 6 |  |  |  |  |  | - | -
 | 7 |  |  |  |  |  | - | -
 | 8 |  |  |  |  |  | - | -
 | 9 |  |  |  |  |  | - | -
 | 10 |  |  |  |  |  |  | 7
 | 11 |  |  |  |  |  | - | -
 | 12 |  |  |  |  |  | - | -
 | 13 |  |  |  |  |  | - | -
 | 14 |  |  |  |  |  | - | -
 | 15 |  |  |  |  |  | - | -
 | 16 |  |  |  |  |  | - | -
 | 17 |  |  |  |  |  | - | -
 | 18 |  |  |  |  |  | - | -
 | 19 |  |  |  |  |  | - | -
 | 20 |  |  |  |  |  | - | -
 | 19 |  |  |  |  |  | - | -
 | 18 |  |  |  |  |  | - | -
 | 17 |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 | 17 |  |  |  |  |  | - | -
 | 18 |  |  |  |  |  | - | -
 | 19 |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  |  | 29
 | 20 |  |  |  |  |  | - | -
 | 19 |  |  |  |  |  | - | -
 | 18 |  |  |  |  |  | - | -
 | 17 |  |  |  |  |  | - | -
 | 16 |  |  |  |  |  | - | -
 | 15 |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  |  | 9 | Hi [NAME], sorry for revisiting such an old post, but I was wondering if you could assist me tweaking the 2nd formula you provided just slightly.
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  | - | -
 |  |  |  |  |  |  |  | 37