Spreadsheet: 735414d1622967599-summarize-the-data-to-make-it-continuous-summarised-output
Sheet: Sheet1

Input data received |  |  |  |  |  |  | Summarised Output data (removing continuous stretches)
From | To | Side | Layer | Length |  |  | From | To | Side | Layer | Length
681000 | 681240 | LHS | Emb |  |  |  | 681000 | 682600 | LHS | Emb |  |  |  | 682600 | LHS | Emb | 1600 |  |  | 682600 | LHS | Emb | 1600
681240 | 681300 | LHS | Emb |  |  |  | 683140 | 685740 | LHS | Emb |  |  | 683140 | 685740 | LHS | Emb | 2600 |  | 683140 | 685740 | LHS | Emb | 2600
681300 | 681360 | LHS | Emb |  |  |  | 685750 | 688779 | LHS | Emb |  |  | 685750 | 688779 | LHS | Emb | 3029 |  | 685750 | 688779 | LHS | Emb | 3029
681360 | 681450 | LHS | Emb |  |  |  | 688789 | 691120 | LHS | Emb |  |  | 688789 | 691120 | LHS | Emb | 2331 |  | 688789 | 691120 | LHS | Emb | 2331
681450 | 681600 | LHS | Emb |  |  |  | 691140 | 693300 | LHS | Emb |  |  | 691140 | 693300 | LHS | Emb | 2160 |  | 691140 | 693300 | LHS | Emb | 2160
681600 | 681680 | LHS | Emb |  |  |  | 693310 | 696265 | LHS | Emb |  |  | 693310 | 696265 | LHS | Emb | 2955 |  | 693310 | 696265 | LHS | Emb | 2955
681680 | 681720 | LHS | Emb |  |  |  | 696285 | 697835 | LHS | Emb |  |  | 696285 | 697835 | LHS | Emb | 1550 |  | 696285 | 697835 | LHS | Emb | 1550
681720 | 681850 | LHS | Emb |  |  |  | 697845 | 699660 | LHS | Emb |  |  | 697845 | 699660 | LHS | Emb | 1815 |  | 697845 | 699660 | LHS | Emb | 1815
681850 | 681900 | LHS | Emb |  |  |  | 700060 | 700700 | LHS | Emb |  |  | 700060 | 700700 | LHS | Emb | 640 |  | 700060 | 700700 | LHS | Emb | 640
681900 | 682080 | LHS | Emb |  |  |  | 700825 | 701150 | LHS | Emb |  |  | 700825 | 701150 | LHS | Emb | 325 |  | 700825 | 701150 | LHS | Emb | 325
682080 | 682100 | LHS | Emb |  |  |  | 701240 | 701810 | LHS | Emb |  |  | 701240 | 701810 | LHS | Emb | 570 |  | 701240 | 701810 | LHS | Emb | 570
682100 | 682280 | LHS | Emb |  |  |  | 701840 | 702240 | LHS | Emb |  |  | 701840 | 702240 | LHS | Emb | 400 |  | 701840 | 702240 | LHS | Emb | 400
682280 | 682340 | LHS | Emb |  |  |  | 703000 | 703520 | LHS | Emb |  |  | 703000 | 703520 | LHS | Emb | 520 |  | 703000 | 703520 | LHS | Emb | 520
682340 | 682530 | LHS | Emb |  |  |  | 705520 | 705800 | LHS | Emb |  |  | 705520 | 705800 | LHS | Emb | 280 |  | 705520 | 705800 | LHS | Emb | 280
682530 | 682600 | LHS | Emb |  |  |  | 706400 | 708080 | LHS | Emb |  |  | 706400 | 708080 | LHS | Emb | 1680 |  | 706400 | 708080 | LHS | Emb | 1680
683140 | 683240 | LHS | Emb |  |  |  | 708100 | 709662 | LHS | Emb |  |  | 708100 | 709662 | LHS | Emb | 1562 |  | 708100 | 709662 | LHS | Emb | 1562
683240 | 683400 | LHS | Emb |  |  |  | 709725 | 710640 | LHS | Emb |  |  | 709725 | 710640 | LHS | Emb | 915 |  | 709725 | 710640 | LHS | Emb | 915
683400 | 683500 | LHS | Emb |  |  |  | 710820 | 711340 | LHS | Emb |  |  | 710820 | 711340 | LHS | Emb | 520 |  | 710820 | 711340 | LHS | Emb | 520
683500 | 683600 | LHS | Emb |  |  |  | 714640 | 715930 | LHS | Emb |  |  | 714640 | 715930 | LHS | Emb | 1290 |  | 714640 | 715930 | LHS | Emb | 1290
683600 | 683650 | LHS | Emb |  |  |  | 716450 | 717160 | LHS | Emb |  |  | 716450 | 717160 | LHS | Emb | 710 |  | 716450 | 717160 | LHS | Emb | 710
683650 | 683680 | LHS | Emb |  |  |  | 717660 | 720445 | LHS | Emb |  |  | 717660 | 720445 | LHS | Emb | 2785 |  | 717660 | 720445 | LHS | Emb | 2785
683680 | 683800 | LHS | Emb |  |  |  | 720455 | 723935 | LHS | Emb |  |  | 720455 | 723935 | LHS | Emb | 3480 |  | 720455 | 723935 | LHS | Emb | 3480
683800 | 683900 | LHS | Emb |  |  |  | 723955 | 726913 | LHS | Emb |  |  | 723955 | 726913 | LHS | Emb | 2958 |  | 723955 | 726913 | LHS | Emb | 2958
683900 | 684050 | LHS | Emb |  |  |  | 726923 | 728620 | LHS | Emb |  |  | 726923 | 728620 | LHS | Emb | 1697 |  | 726923 | 728620 | LHS | Emb | 1697
684050 | 684080 | LHS | Emb |  |  |  | 731460 | 731660 | LHS | Emb |  |  | 731460 | 731660 | LHS | Emb | 200 |  | 731460 | 731660 | LHS | Emb | 200
684080 | 684120 | LHS | Emb |  |  |  | 731700 | 731780 | LHS | Emb |  |  | 731700 | 731780 | LHS | Emb | 80 |  | 731700 | 731780 | LHS | Emb | 80
684120 | 684340 | LHS | Emb
684340 | 684400 | LHS | Emb
684400 | 684660 | LHS | Emb
684660 | 684780 | LHS | Emb
684780 | 684860 | LHS | Emb
684860 | 685160 | LHS | Emb
685160 | 685375 | LHS | Emb
685375 | 685430 | LHS | Emb
685430 | 685620 | LHS | Emb
685620 | 685740 | LHS | Emb
685750 | 685850 | LHS | Emb
685850 | 686100 | LHS | Emb
686100 | 686185 | LHS | Emb
686185 | 686200 | LHS | Emb
686200 | 686360 | LHS | Emb
686360 | 686400 | LHS | Emb
686400 | 686550 | LHS | Emb
686550 | 686660 | LHS | Emb
686660 | 686750 | LHS | Emb
686750 | 687020 | LHS | Emb
687020 | 687070 | LHS | Emb
687070 | 687100 | LHS | Emb
687100 | 687250 | LHS | Emb
687250 | 687320 | LHS | Emb
687320 | 687340 | LHS | Emb
687340 | 687440 | LHS | Emb
687440 | 687700 | LHS | Emb
687700 | 687780 | LHS | Emb
687780 | 687900 | LHS | Emb
687900 | 688000 | LHS | Emb
688000 | 688235 | LHS | Emb
688235 | 688300 | LHS | Emb
688300 | 688330 | LHS | Emb
688330 | 688520 | LHS | Emb
688520 | 688640 | LHS | Emb
688640 | 688779 | LHS | Emb
688789 | 689003 | LHS | Emb
689003 | 689020 | LHS | Emb
689020 | 689140 | LHS | Emb
689140 | 689185 | LHS | Emb
689185 | 689300 | LHS | Emb
689300 | 689385 | LHS | Emb
689385 | 689460 | LHS | Emb
689460 | 689660 | LHS | Emb
689660 | 689720 | LHS | Emb
689720 | 689863 | LHS | Emb
689863 | 689920 | LHS | Emb
689920 | 690100 | LHS | Emb
690100 | 690250 | LHS | Emb
690250 | 690620 | LHS | Emb
690620 | 690640 | LHS | Emb
690640 | 690670 | LHS | Emb
690670 | 690800 | LHS | Emb
690800 | 690860 | LHS | Emb
690860 | 690900 | LHS | Emb
690900 | 691120 | LHS | Emb
691140 | 691350 | LHS | Emb
691350 | 691520 | LHS | Emb
691520 | 691590 | LHS | Emb
691590 | 691660 | LHS | Emb
691660 | 691840 | LHS | Emb
691840 | 691900 | LHS | Emb
691900 | 691960 | LHS | Emb
691960 | 692000 | LHS | Emb
692000 | 692100 | LHS | Emb
692100 | 692240 | LHS | Emb
692240 | 692300 | LHS | Emb
692300 | 692400 | LHS | Emb
692400 | 692440 | LHS | Emb
692440 | 692540 | LHS | Emb
692540 | 692785 | LHS | Emb
692785 | 692800 | LHS | Emb
692800 | 692903 | LHS | Emb
692903 | 692940 | LHS | Emb
692940 | 693100 | LHS | Emb
693100 | 693153 | LHS | Emb
693153 | 693200 | LHS | Emb
693200 | 693290 | LHS | Emb
693290 | 693300 | LHS | Emb
693310 | 693320 | LHS | Emb
693320 | 693500 | LHS | Emb
693500 | 693600 | LHS | Emb
693600 | 693705 | LHS | Emb
693705 | 693760 | LHS | Emb
693760 | 693800 | LHS | Emb
693800 | 693890 | LHS | Emb
693890 | 694040 | LHS | Emb
694040 | 694140 | LHS | Emb
694140 | 694260 | LHS | Emb
694260 | 694700 | LHS | Emb
694700 | 694900 | LHS | Emb
694900 | 695150 | LHS | Emb
695150 | 695300 | LHS | Emb
695300 | 695500 | LHS | Emb
695500 | 695585 | LHS | Emb
695585 | 695640 | LHS | Emb
695640 | 695700 | LHS | Emb
695700 | 695740 | LHS | Emb
695740 | 695950 | LHS | Emb
695950 | 696265 | LHS | Emb
696285 | 696360 | LHS | Emb
696360 | 696500 | LHS | Emb
696500 | 696660 | LHS | Emb
696660 | 696680 | LHS | Emb
696680 | 696800 | LHS | Emb
696800 | 696820 | LHS | Emb
696820 | 696955 | LHS | Emb
696955 | 697050 | LHS | Emb
697050 | 697200 | LHS | Emb
697200 | 697360 | LHS | Emb
697360 | 697420 | LHS | Emb
697420 | 697460 | LHS | Emb
697460 | 697500 | LHS | Emb
697500 | 697560 | LHS | Emb
697560 | 697700 | LHS | Emb
697700 | 697760 | LHS | Emb
697760 | 697835 | LHS | Emb
697845 | 698000 | LHS | Emb
698000 | 698500 | LHS | Emb
698500 | 698560 | LHS | Emb
698560 | 698600 | LHS | Emb
698600 | 698700 | LHS | Emb
698700 | 698820 | LHS | Emb
698820 | 699200 | LHS | Emb
699200 | 699345 | LHS | Emb
699345 | 699350 | LHS | Emb
699350 | 699560 | LHS | Emb
699560 | 699660 | LHS | Emb
700060 | 700150 | LHS | Emb
700150 | 700400 | LHS | Emb
700400 | 700600 | LHS | Emb
700600 | 700700 | LHS | Emb
700825 | 701150 | LHS | Emb
701240 | 701285 | LHS | Emb
701285 | 701420 | LHS | Emb
701420 | 701520 | LHS | Emb
701520 | 701530 | LHS | Emb
701530 | 701760 | LHS | Emb
701760 | 701810 | LHS | Emb
701840 | 702200 | LHS | Emb
702200 | 702240 | LHS | Emb
703000 | 703030 | LHS | Emb
703030 | 703100 | LHS | Emb
703100 | 703520 | LHS | Emb
705520 | 705535 | LHS | Emb
705535 | 705700 | LHS | Emb
705700 | 705800 | LHS | Emb
706400 | 706500 | LHS | Emb
706500 | 706740 | LHS | Emb
706740 | 706790 | LHS | Emb
706790 | 706800 | LHS | Emb
706800 | 706900 | LHS | Emb
706900 | 706920 | LHS | Emb
706920 | 706960 | LHS | Emb
706960 | 707020 | LHS | Emb
707020 | 707030 | LHS | Emb
707030 | 707100 | LHS | Emb
707100 | 707340 | LHS | Emb
707340 | 707680 | LHS | Emb
707680 | 707760 | LHS | Emb
707760 | 707900 | LHS | Emb
707900 | 708000 | LHS | Emb
708000 | 708080 | LHS | Emb
708100 | 708110 | LHS | Emb
708110 | 708520 | LHS | Emb
708520 | 708575 | LHS | Emb
708575 | 708605 | LHS | Emb
708605 | 708700 | LHS | Emb
708700 | 709000 | LHS | Emb
709000 | 709200 | LHS | Emb
709200 | 709213 | LHS | Emb
709213 | 709280 | LHS | Emb
709280 | 709480 | LHS | Emb
709480 | 709580 | LHS | Emb
709580 | 709662 | LHS | Emb
709725 | 709780 | LHS | Emb
709780 | 709800 | LHS | Emb
709800 | 709833 | LHS | Emb
709833 | 709940 | LHS | Emb
709940 | 710200 | LHS | Emb
710200 | 710400 | LHS | Emb
710400 | 710440 | LHS | Emb
710440 | 710480 | LHS | Emb
710480 | 710640 | LHS | Emb
710820 | 710940 | LHS | Emb
710940 | 710980 | LHS | Emb
710980 | 711060 | LHS | Emb
711060 | 711160 | LHS | Emb
711160 | 711240 | LHS | Emb
711240 | 711340 | LHS | Emb
714640 | 714700 | LHS | Emb
714700 | 714880 | LHS | Emb
714880 | 715150 | LHS | Emb
715150 | 715340 | LHS | Emb
715340 | 715400 | LHS | Emb
715400 | 715440 | LHS | Emb
715440 | 715460 | LHS | Emb
715460 | 715550 | LHS | Emb
715550 | 715640 | LHS | Emb
715640 | 715885 | LHS | Emb
715885 | 715900 | LHS | Emb
715900 | 715930 | LHS | Emb
716450 | 716880 | LHS | Emb
716880 | 716955 | LHS | Emb
716955 | 717020 | LHS | Emb
717020 | 717050 | LHS | Emb
717050 | 717100 | LHS | Emb
717100 | 717150 | LHS | Emb
717150 | 717160 | LHS | Emb
717660 | 717820 | LHS | Emb
717820 | 717920 | LHS | Emb
717920 | 717940 | LHS | Emb
717940 | 718130 | LHS | Emb
718130 | 718160 | LHS | Emb
718160 | 718460 | LHS | Emb
718460 | 718600 | LHS | Emb
718600 | 718850 | LHS | Emb
718850 | 719200 | LHS | Emb
719200 | 719400 | LHS | Emb
719400 | 719470 | LHS | Emb
719470 | 719550 | LHS | Emb
719550 | 720015 | LHS | Emb
720015 | 720140 | LHS | Emb
720140 | 720150 | LHS | Emb
720150 | 720220 | LHS | Emb
720220 | 720250 | LHS | Emb
720250 | 720445 | LHS | Emb
720455 | 720750 | LHS | Emb
720750 | 720845 | LHS | Emb
720845 | 721020 | LHS | Emb
721020 | 721040 | LHS | Emb
721040 | 721250 | LHS | Emb
721250 | 721750 | LHS | Emb
721750 | 721900 | LHS | Emb
721900 | 722000 | LHS | Emb
722000 | 722140 | LHS | Emb
722140 | 722200 | LHS | Emb
722200 | 722320 | LHS | Emb
722320 | 722340 | LHS | Emb
722340 | 722380 | LHS | Emb
722380 | 722550 | LHS | Emb
722550 | 722600 | LHS | Emb
722600 | 722800 | LHS | Emb
722800 | 722850 | LHS | Emb
722850 | 722960 | LHS | Emb
722960 | 723485 | LHS | Emb
723485 | 723500 | LHS | Emb
723500 | 723580 | LHS | Emb
723580 | 723780 | LHS | Emb
723780 | 723935 | LHS | Emb
723955 | 724060 | LHS | Emb
724060 | 724160 | LHS | Emb
724160 | 724320 | LHS | Emb
724320 | 724475 | LHS | Emb
724475 | 724540 | LHS | Emb
724540 | 724640 | LHS | Emb
724640 | 725010 | LHS | Emb
725010 | 725080 | LHS | Emb
725080 | 725100 | LHS | Emb
725100 | 725300 | LHS | Emb
725300 | 725430 | LHS | Emb
725430 | 725480 | LHS | Emb
725480 | 725540 | LHS | Emb
725540 | 725700 | LHS | Emb
725700 | 725950 | LHS | Emb
725950 | 725970 | LHS | Emb
725970 | 726110 | LHS | Emb
726110 | 726335 | LHS | Emb
726335 | 726350 | LHS | Emb
726350 | 726850 | LHS | Emb
726850 | 726913 | LHS | Emb
726923 | 727160 | LHS | Emb
727160 | 727200 | LHS | Emb
727200 | 727240 | LHS | Emb
727240 | 727280 | LHS | Emb
727280 | 727550 | LHS | Emb
727550 | 727600 | LHS | Emb
727600 | 727760 | LHS | Emb
727760 | 728100 | LHS | Emb
728100 | 728400 | LHS | Emb
728400 | 728450 | LHS | Emb
728450 | 728580 | LHS | Emb
728580 | 728600 | LHS | Emb
728600 | 728605 | LHS | Emb
728605 | 728620 | LHS | Emb
731460 | 731470 | LHS | Emb
731470 | 731600 | LHS | Emb
731600 | 731660 | LHS | Emb
731700 | 731780 | LHS | Emb