Spreadsheet: 731337d1620297021-find-the-correct-row-find-the-relevant-rows
Sheet: Input data

Insured | x | Inception Date | [NAME] | x | x | x | x | x | x | x | x | x | x | Premium | x | x | x | x | x | x | x | Turnover
Customer 1 | - | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 15000 | - | - | - | - | - | - | - | 85000000
Customer 1 | - | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 15000 | - | - | - | - | - | - | - | 85000000
Customer 1 | - | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 15000 | - | - | - | - | - | - | - | 85000000
Customer 2 | - | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 857321.9999999999 | - | - | - | - | - | - | - | 34709400000
Customer 2 | - | 2018-01-01 00:00:00 | 2018-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 800000 | - | - | - | - | - | - | - | 31187900000
Customer 2 | - | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 800000 | - | - | - | - | - | - | - | 32438000000
Customer 2 | - | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 867000 | - | - | - | - | - | - | - | 19 320 500 000
Customer 3 | - | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 15000 | - | - | - | - | - | - | - | 75000000
Customer 3 | - | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 15000 | - | - | - | - | - | - | - | 75000000
Customer 4 | - | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 32000 | - | - | - | - | - | - | - | 160000000
Customer 4 | - | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 25600 | - | - | - | - | - | - | - | 128000000
Customer 4 | - | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 23000 | - | - | - | - | - | - | - | 115000000
Customer 5 | - | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 34908 | - | - | - | - | - | - | - | 120000000
Customer 5 | - | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 32000 | - | - | - | - | - | - | - | 110000000
Customer 5 | - | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 33455 | - | - | - | - | - | - | - | 115000000
Customer 6 | - | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 5000 | - | - | - | - | - | - | - | 15000000
Customer 6 | - | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 5000 | - | - | - | - | - | - | - | 15000000
Customer 7 | - | 2020-03-01 00:00:00 | 2021-02-28 00:00:00 | - | - | - | - | - | - | - | - | - | - | 8000 | - | - | - | - | - | - | - | 1640923
Customer 7 | - | 2019-03-01 00:00:00 | 2020-02-29 00:00:00 | - | - | - | - | - | - | - | - | - | - | 8000 | - | - | - | - | - | - | - | 1640923
Customer 8 | - | 2018-11-01 00:00:00 | 2019-10-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 7499.999999999999 | - | - | - | - | - | - | - | 18000000
Customer 9 | - | 2021-03-15 00:00:00 | 2021-09-01 00:00:00 | - | - | - | - | - | - | - | - | - | - | 39000 | - | - | - | - | - | - | - | 30000000
Customer 10 | - | 2019-12-01 00:00:00 | 2020-11-30 00:00:00 | - | - | - | - | - | - | - | - | - | - | 20000 | - | - | - | - | - | - | - | 165000000
Customer 10 | - | 2020-12-01 00:00:00 | 2021-11-30 00:00:00 | - | - | - | - | - | - | - | - | - | - | 20000 | - | - | - | - | - | - | - | 165000000
Customer 11 | - | 2018-04-06 00:00:00 | 2018-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 13315.06849315068 | - | - | - | - | - | - | - | 30000000
Customer 11 | - | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 20700 | - | - | - | - | - | - | - | 30000000
Customer 11 | - | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 20700 | - | - | - | - | - | - | - | 30000000
Customer 11 | - | 2021-01-01 00:00:00 | 2021-12-31 00:00:00 | - | - | - | - | - | - | - | - | - | - | 13800 | - | - | - | - | - | - | - | 20000000