Spreadsheet: 696102d1600626124-looking-up-final-value-that-can-be-tracked-in-table-tracking-connected-values-in-a-table
Sheet: Excel

Table 1 |  |  |  |  |  |  | Table 4 |  |  |  |  | Table 2 |  |  |  |  |  |  | Table 3 |  | Solution
Group | Code | Criterion | Created | Changed | Result |  | Tracing backwards (towards original "true", if existing) | Traced back result | Tracing forwards (towards "false", if not already there) | Traced forward result |  | Group | Code | Criterion | Created | Changed | Result | Row | Result | Row | Result | Row | [NAME] | [NAME]
123456 | AA | false | 2018-11-12 09:38:20 | 2018-11-12 09:38:20 | 0.001 |  |  |  |  |  |  | 123459 | DD | true | 2018-11-12 10:47:01 | 2018-11-12 10:51:36 | 0.014 | 21 | 14 | 28
123456 | AA | false | 2018-11-12 09:38:21 | 2018-11-12 09:38:21 | 0.002 |  |  |  |  |  |  | 123459 | DD | false | 2018-11-12 10:52:22 | 2018-11-12 10:52:22 | 0.016 | 27 | 0.016 | 27
123456 | BB | false | 2018-11-12 09:38:59 | 2018-11-12 09:38:59 | 0.003 |  |  |  |  |  |  | 123457 | BB | false | 2018-11-12 09:41:25 | 2018-11-12 09:41:25 | 0.007 | 10 | 0.007 | 10
123466 | PP | false | 2018-11-12 09:41:25 | 2018-11-12 09:41:25 | 0.004 |  |  |  |  |  |  | 123457 | BB | true | 2018-11-12 09:41:25 | 2018-11-12 09:47:27 | 0.008 | 11 | 8 | 12
123456 | BB | false | 2018-11-12 09:38:59 | 2018-11-12 09:38:59 | 0.004
123457 | AA | false | 2018-11-12 09:41:25 | 2018-11-12 09:41:25 | 0.005
123457 | BB | false | 2018-11-12 09:41:25 | 2018-11-12 09:41:25 | 0.007
123457 | BB | true | 2018-11-12 09:41:25 | 2018-11-12 09:47:27 | 0.008
123457 | BB | false | 2018-11-12 09:47:27 | 2018-11-12 09:47:27 | 8
123458 | CC | false | 2018-11-12 09:41:25 | 2018-11-12 09:41:25 | 0.009
123461 | JJ | false | 2018-11-12 09:15:13 | 2018-11-12 09:15:13 | 0.024
123458 | DD | false | 2018-11-12 10:44:54 | 2018-11-12 10:44:54 | 0.01
123461 | EE | false | 2018-11-12 10:51:36 | 2018-11-12 10:51:36 | 10
123459 | DD | false | 2018-11-12 11:58:43 | 2018-11-12 11:58:43 | 18
123458 | CC | false | 2018-11-12 10:48:44 | 2018-11-12 10:48:44 | 0.011
123463 | GG | false | 2018-11-12 10:44:54 | 2018-11-12 10:44:54 | 0.008
123458 | DD | false | 2018-11-12 10:48:44 | 2018-11-12 10:48:44 | 0.012
123459 | DD | true | 2018-11-12 10:47:01 | 2018-11-12 10:51:36 | 0.014
123461 | EE | true | 2018-11-12 10:51:36 | 2018-11-12 10:51:36 | 0.01
123459 | CC | false | 2018-11-12 10:50:29 | 2018-11-12 10:50:29 | 0.015
123459 | DD | true | 2018-11-12 10:51:36 | 2018-11-12 10:58:41 | 1.4
123459 | DD | true | 2018-11-12 11:00:36 | 2018-11-12 11:01:41 | 20
123459 | DD | false | 2018-11-12 11:01:41 | 2018-11-12 11:01:41 | 30
123459 | DD | false | 2018-11-12 10:52:22 | 2018-11-12 10:52:22 | 0.016
123459 | DD | false | 2018-11-12 10:58:41 | 2018-11-12 10:58:41 | 14
123467 | KK | false | 2018-11-12 10:48:44 | 2018-11-12 10:48:44 | 0.009
123460 | EE | false | 2018-11-12 10:50:52 | 2018-11-12 10:50:52 | 0.017
123462 | AA | false | 2018-11-12 09:41:25 | 2018-11-12 09:41:25 | 0.007
123460 | FF | false | 2018-11-12 10:51:36 | 2018-11-12 10:51:36 | 0.018
123460 | FF | false | 2018-11-12 10:51:36 | 2018-11-12 10:51:36 | 0.019
123475 | MM | false | 2018-11-12 10:51:47 | 2018-11-12 10:51:47 | 0.003
123460 | EE | true | 2018-11-12 10:36:22 | 2018-11-12 10:36:56 | 0.0015
123460 | EE | false | 2018-11-12 10:51:36 | 2018-11-12 10:51:36 | 0.02
123461 | GG | false | 2018-11-12 10:51:47 | 2018-11-12 10:51:47 | 0.021
123457 | AA | false | 2018-11-12 09:41:25 | 2018-11-12 09:41:25 | 0.006
123461 | HH | false | 2018-11-13 07:26:18 | 2018-11-13 07:26:18 | 0.022
123459 | CC | false | 2018-11-12 10:48:44 | 2018-11-12 10:48:44 | 0.013
123461 | II | false | 2018-11-12 09:15:13 | 2018-11-12 09:15:13 | 0.023
123475 | EE | false | 2018-11-12 10:51:36 | 2018-11-12 10:51:36 | 0.002