Spreadsheet: 850528d1700873952-rearrange-according-to-sequencing-number-from-1-to-10-as-per-per-duration-categories-excel1-copy
Sheet: Sheet2

Run | Duration | units | AEP | N | Rain(mm) | ARF | Hyd001 | Hyd002 | Hyd003 | Hyd004 | Hyd005 | Hyd006 | Hyd007 |  | TMS |  | Duration | units | AEP | N | Rain(mm) | ARF | Hyd001 | Hyd002 | Hyd003 | Hyd004 | Hyd005 | Hyd006 | Hyd007
0 | 120 | min | BGD_ ae.10 | 1 | 0 | 1 | 374.712 | 89.1491 | 57.2639 | 160.739 | 5.6393 | 474.972 | 608.884 |  |  | 0 | 120 | min | BGD_ ae.10 | 1 | 0 | 1 | 374.712 | 89.1491 | 57.2639 | 160.739 | 5.6393 | 474.972 | 608.884
0 | 120 | min | BGD_ ae.10 | 10 | 0 | 1 | 186.39 | 60.3644 | 39.1271 | 91.6151 | 3.9085 | 211.58 | 306.782 |  |  | 0 | 120 | min | BGD_ ae.10 | 2 | 0 | 1 | 174.307 | 55.0453 | 33.6704 | 83.5808 | 3.3124 | 215.241 | 290.186
0 | 120 | min | BGD_ ae.10 | 2 | 0 | 1 | 174.307 | 55.0453 | 33.6704 | 83.5808 | 3.3124 | 215.241 | 290.186 |  |  | 0 | 120 | min | BGD_ ae.10 | 3 | 0 | 1 | 105.199 | 32.1072 | 20.9159 | 43.8994 | 2.1087 | 34.2253 | 164.636
0 | 120 | min | BGD_ ae.10 | 3 | 0 | 1 | 105.199 | 32.1072 | 20.9159 | 43.8994 | 2.1087 | 34.2253 | 164.636 |  |  | 0 | 120 | min | BGD_ ae.10 | 4 | 0 | 1 | 201.421 | 51.1992 | 28.85 | 84.3565 | 2.8399 | 237.529 | 324.716
0 | 120 | min | BGD_ ae.10 | 4 | 0 | 1 | 201.421 | 51.1992 | 28.85 | 84.3565 | 2.8399 | 237.529 | 324.716 |  |  | 0 | 120 | min | BGD_ ae.10 | 5 | 0 | 1 | 351.898 | 90.8701 | 62.6863 | 152.496 | 6.1722 | 431.805 | 571.834
0 | 120 | min | BGD_ ae.10 | 5 | 0 | 1 | 351.898 | 90.8701 | 62.6863 | 152.496 | 6.1722 | 431.805 | 571.834 |  |  | 0 | 120 | min | BGD_ ae.10 | 6 | 0 | 1 | 233.652 | 45.1109 | 26.7565 | 78.5553 | 2.6736 | 318.056 | 356.334
0 | 120 | min | BGD_ ae.10 | 6 | 0 | 1 | 233.652 | 45.1109 | 26.7565 | 78.5553 | 2.6736 | 318.056 | 356.334 |  |  | 0 | 120 | min | BGD_ ae.10 | 7 | 0 | 1 | 403.177 | 93.3632 | 58.5728 | 176.01 | 5.674 | 491.414 | 656.929
0 | 120 | min | BGD_ ae.10 | 7 | 0 | 1 | 403.177 | 93.3632 | 58.5728 | 176.01 | 5.674 | 491.414 | 656.929 |  |  | 0 | 120 | min | BGD_ ae.10 | 8 | 0 | 1 | 179.223 | 43.361 | 24.9768 | 75.4071 | 2.5162 | 148.598 | 286.379
0 | 120 | min | BGD_ ae.10 | 8 | 0 | 1 | 179.223 | 43.361 | 24.9768 | 75.4071 | 2.5162 | 148.598 | 286.379 |  |  | 0 | 120 | min | BGD_ ae.10 | 9 | 0 | 1 | 189.52 | 60.4215 | 43.5109 | 86.5315 | 4.3484 | 237.979 | 287.386
0 | 120 | min | BGD_ ae.10 | 9 | 0 | 1 | 189.52 | 60.4215 | 43.5109 | 86.5315 | 4.3484 | 237.979 | 287.386 |  |  | 0 | 120 | min | BGD_ ae.10 | 10 | 0 | 1 | 186.39 | 60.3644 | 39.1271 | 91.6151 | 3.9085 | 211.58 | 306.782
0 | 144 | min | BGD_ ae.10 | 1 | 0 | 1 | 376.509 | 85.4405 | 49.4749 | 155.83 | 4.7738 | 475.02 | 607.098 |  |  | 0 | 144 | min | BGD_ ae.10 | 1 | 0 | 1 | 376.509 | 85.4405 | 49.4749 | 155.83 | 4.7738 | 475.02 | 607.098
0 | 144 | min | BGD_ ae.10 | 10 | 0 | 1 | 146.58 | 56.3474 | 40.4491 | 72.0733 | 4.0216 | 172.637 | 239.866 |  |  | 0 | 144 | min | BGD_ ae.10 | 2 | 0 | 1 | 160.896 | 41.0979 | 23.16 | 65.3909 | 2.2483 | 121.839 | 258.472
0 | 144 | min | BGD_ ae.10 | 2 | 0 | 1 | 160.896 | 41.0979 | 23.16 | 65.3909 | 2.2483 | 121.839 | 258.472 |  |  | 0 | 144 | min | BGD_ ae.10 | 3 | 0 | 1 | 103.378 | 29.1203 | 19.1372 | 44.2519 | 2.0125 | 31.8417 | 157.574
0 | 144 | min | BGD_ ae.10 | 3 | 0 | 1 | 103.378 | 29.1203 | 19.1372 | 44.2519 | 2.0125 | 31.8417 | 157.574 |  |  | 0 | 144 | min | BGD_ ae.10 | 4 | 0 | 1 | 196.263 | 49.8837 | 32.0543 | 84.957 | 3.2439 | 263.791 | 318.65
0 | 144 | min | BGD_ ae.10 | 4 | 0 | 1 | 196.263 | 49.8837 | 32.0543 | 84.957 | 3.2439 | 263.791 | 318.65 |  |  | 0 | 144 | min | BGD_ ae.10 | 5 | 0 | 1 | 334.263 | 78.9703 | 51.5975 | 137.606 | 5.1701 | 406.111 | 537.508
0 | 144 | min | BGD_ ae.10 | 5 | 0 | 1 | 334.263 | 78.9703 | 51.5975 | 137.606 | 5.1701 | 406.111 | 537.508 |  |  | 0 | 144 | min | BGD_ ae.10 | 6 | 0 | 1 | 399.872 | 90.5062 | 55.9197 | 171.2 | 5.4442 | 485.464 | 649.596
0 | 144 | min | BGD_ ae.10 | 6 | 0 | 1 | 399.872 | 90.5062 | 55.9197 | 171.2 | 5.4442 | 485.464 | 649.596 |  |  | 0 | 144 | min | BGD_ ae.10 | 7 | 0 | 1 | 365.109 | 121.168 | 76.3383 | 182.365 | 7.5868 | 455.305 | 614.146
0 | 144 | min | BGD_ ae.10 | 7 | 0 | 1 | 365.109 | 121.168 | 76.3383 | 182.365 | 7.5868 | 455.305 | 614.146 |  |  | 0 | 144 | min | BGD_ ae.10 | 8 | 0 | 1 | 343.836 | 74.2129 | 51.965 | 122.588 | 5.1893 | 441.494 | 533.523
0 | 144 | min | BGD_ ae.10 | 8 | 0 | 1 | 343.836 | 74.2129 | 51.965 | 122.588 | 5.1893 | 441.494 | 533.523 |  |  | 0 | 144 | min | BGD_ ae.10 | 9 | 0 | 1 | 239.544 | 53.641 | 30.6007 | 95.8651 | 2.9711 | 301.584 | 382.182
0 | 144 | min | BGD_ ae.10 | 9 | 0 | 1 | 239.544 | 53.641 | 30.6007 | 95.8651 | 2.9711 | 301.584 | 382.182 |  |  | 0 | 144 | min | BGD_ ae.10 | 10 | 0 | 1 | 146.58 | 56.3474 | 40.4491 | 72.0733 | 4.0216 | 172.637 | 239.866
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 120 | min | BGD_ ae.10 | 1 | 0 | 1 | 374.712 | 89.1491 | 57.2639 | 160.739 | 5.6393 | 474.972 | 608.884
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 120 | min | BGD_ ae.10 | 2 | 0 | 1 | 174.307 | 55.0453 | 33.6704 | 83.5808 | 3.3124 | 215.241 | 290.186
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 120 | min | BGD_ ae.10 | 3 | 0 | 1 | 105.199 | 32.1072 | 20.9159 | 43.8994 | 2.1087 | 34.2253 | 164.636
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 120 | min | BGD_ ae.10 | 4 | 0 | 1 | 201.421 | 51.1992 | 28.85 | 84.3565 | 2.8399 | 237.529 | 324.716
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 120 | min | BGD_ ae.10 | 5 | 0 | 1 | 351.898 | 90.8701 | 62.6863 | 152.496 | 6.1722 | 431.805 | 571.834
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 120 | min | BGD_ ae.10 | 6 | 0 | 1 | 233.652 | 45.1109 | 26.7565 | 78.5553 | 2.6736 | 318.056 | 356.334
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 120 | min | BGD_ ae.10 | 7 | 0 | 1 | 403.177 | 93.3632 | 58.5728 | 176.01 | 5.674 | 491.414 | 656.929
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 120 | min | BGD_ ae.10 | 8 | 0 | 1 | 179.223 | 43.361 | 24.9768 | 75.4071 | 2.5162 | 148.598 | 286.379
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 120 | min | BGD_ ae.10 | 9 | 0 | 1 | 189.52 | 60.4215 | 43.5109 | 86.5315 | 4.3484 | 237.979 | 287.386
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 120 | min | BGD_ ae.10 | 10 | 0 | 1 | 186.39 | 60.3644 | 39.1271 | 91.6151 | 3.9085 | 211.58 | 306.782
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 144 | min | BGD_ ae.10 | 1 | 0 | 1 | 376.509 | 85.4405 | 49.4749 | 155.83 | 4.7738 | 475.02 | 607.098
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 144 | min | BGD_ ae.10 | 2 | 0 | 1 | 160.896 | 41.0979 | 23.16 | 65.3909 | 2.2483 | 121.839 | 258.472
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 144 | min | BGD_ ae.10 | 3 | 0 | 1 | 103.378 | 29.1203 | 19.1372 | 44.2519 | 2.0125 | 31.8417 | 157.574
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 144 | min | BGD_ ae.10 | 4 | 0 | 1 | 196.263 | 49.8837 | 32.0543 | 84.957 | 3.2439 | 263.791 | 318.65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 144 | min | BGD_ ae.10 | 5 | 0 | 1 | 334.263 | 78.9703 | 51.5975 | 137.606 | 5.1701 | 406.111 | 537.508
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 144 | min | BGD_ ae.10 | 6 | 0 | 1 | 399.872 | 90.5062 | 55.9197 | 171.2 | 5.4442 | 485.464 | 649.596
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 144 | min | BGD_ ae.10 | 7 | 0 | 1 | 365.109 | 121.168 | 76.3383 | 182.365 | 7.5868 | 455.305 | 614.146
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 144 | min | BGD_ ae.10 | 8 | 0 | 1 | 343.836 | 74.2129 | 51.965 | 122.588 | 5.1893 | 441.494 | 533.523
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 144 | min | BGD_ ae.10 | 9 | 0 | 1 | 239.544 | 53.641 | 30.6007 | 95.8651 | 2.9711 | 301.584 | 382.182
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 144 | min | BGD_ ae.10 | 10 | 0 | 1 | 146.58 | 56.3474 | 40.4491 | 72.0733 | 4.0216 | 172.637 | 239.866