Spreadsheet: 685050d1593696283-reg-distribute-the-quantity-on-each-cell-based-on-layer-master-sheet-for-earth-work
Sheet: Sheet1

Layer | Chainage |  |  | Distributed
 | From | To | Qty |  |  |  |  |  |  | Chainage | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 14
1 | 32000 | 32100 | 839.7200000000001 |  |  |  |  |  |  | 32000
1 | 32151 | 32250 | 923.261625 |  |  |  |  |  |  | 32010
1 | 32350 | 32400 | 499.81875 |  |  |  |  |  |  | 32020
1 | 32400 | 32540 | 1457.2275 |  |  |  |  |  |  | 32030
1 | 32540 | 32550 | 105.37125 |  |  |  |  |  |  | 32040
1 | 32550 | 32700 | 1592.66875 |  |  |  |  |  |  | 32050
1 | 32700 | 32800 | 1049.2525 |  |  |  |  |  |  | 32060
1 | 32800 | 32880 | 810.9350000000001 |  |  |  |  |  |  | 32070
1 | 32880 | 32950 | 698.89625 |  |  |  |  |  |  | 32080
1 | 32950 | 33000 | 487.82625 |  |  |  |  |  |  | 32090
1 | 33000 | 33400 | 3751.174999999999 |  |  |  |  |  |  | 32100
2 | 32350 | 32506 | 1585.8219 |  |  |  |  |  |  | 32110
2 | 32522 | 32550 | 291.3878333333333 |  |  |  |  |  |  | 32120
2 | 32550 | 32700 | 1578.60625 |  |  |  |  |  |  | 32130
2 | 32700 | 32800 | 1039.8775 |  |  |  |  |  |  | 32140
2 | 32800 | 32876.5 | 769.0176160714286 |  |  |  |  |  |  | 32151
2 | 32883.5 | 32950 | 657.7170625 |  |  |  |  |  |  | 32160
2 | 32950 | 33131.5 | 1707.431 |  |  |  |  |  |  | 32170
2 | 33139 | 33400 | 2420.043958333334 |  |  |  |  |  |  | 32180
3 | 32350 | 32506 | 1571.1969 |  |  |  |  |  |  | 32190
3 | 32522 | 32700 | 1853.111027777777 |  |  |  |  |  |  | 32200
3 | 32700 | 32800 | 1030.5025 |  |  |  |  |  |  | 32210
3 | 32800 | 32876.5 | 761.8457410714286 |  |  |  |  |  |  | 32220
3 | 32883.5 | 32950 | 651.4826875 |  |  |  |  |  |  | 32230
3 | 32950 | 33131.5 | 1690.415375 |  |  |  |  |  |  | 32240
3 | 33138.5 | 33400 | 2400.164432870371 |  |  |  |  |  |  | 32250
4 | 32350 | 32506 | 1556.5719 |  |  |  |  |  |  | 32260
4 | 32522 | 32800 | 2857.626535714284 |  |  |  |  |  |  | 32270
4 | 32800 | 32876.5 | 754.6738660714286 |  |  |  |  |  |  | 32280
4 | 32883.5 | 32950 | 645.2483125 |  |  |  |  |  |  | 32290
4 | 32950 | 33131.5 | 1673.39975 |  |  |  |  |  |  | 32300
4 | 33138.5 | 33400 | 2375.648807870371 |  |  |  |  |  |  | 32310
5 | 32350 | 32506 | 1541.9469 |  |  |  |  |  |  | 32320
5 | 32522 | 32800 | 2515.491 |  |  |  |  |  |  | 32330
5 | 32800 | 32876.5 | 747.5019910714286 |  |  |  |  |  |  | 32340
5 | 32883.5 | 33131.5 | 2296.818519999999 |  |  |  |  |  |  | 32350
5 | 33138.5 | 33400 | 2351.133182870371 |  |  |  |  |  |  | 32360
6 | 32350 | 32506 | 1527.3219 |  |  |  |  |  |  | 32370
6 | 32550 | 32800 | 2524.73375 |  |  |  |  |  |  | 32380
6 | 32800 | 32876.5 | 740.3301160714286 |  |  |  |  |  |  | 32390
6 | 32883.5 | 33131.5 | 2273.568519999999 |  |  |  |  |  |  | 32400
6 | 33138.5 | 33400 | 2326.617557870371 |  |  |  |  |  |  | 32410
7 | 32350 | 32506 | 1512.6969 |  |  |  |  |  |  | 32420
7 | 32550 | 32800 | 2501.29625 |  |  |  |  |  |  | 32430
7 | 32800 | 32876.5 | 733.1582410714286 |  |  |  |  |  |  | 32440
7 | 32883.5 | 33131.5 | 2250.318519999999 |  |  |  |  |  |  | 32450
7 | 33138.5 | 33400 | 2302.101932870371 |  |  |  |  |  |  | 32460
8 | 32350 | 32506 | 1498.0719 |  |  |  |  |  |  | 32470
8 | 32550 | 32876.5 | 3205.985125 |  |  |  |  |  |  | 32480
8 | 32883.5 | 33131.5 | 2227.068519999999 |  |  |  |  |  |  | 32490
8 | 33138.5 | 33400 | 2277.586307870371 |  |  |  |  |  |  | 32500
9 | 32350 | 32506 | 1483.4469 |  |  |  |  |  |  | 32510
9 | 32550 | 32850 | 2925.037499999999 |  |  |  |  |  |  | 32520
9 | 32883.5 | 33131.5 | 2203.818519999999 |  |  |  |  |  |  | 32530
9 | 33138.5 | 33400 | 2253.070682870371 |  |  |  |  |  |  | 32540
10 | 32350 | 32506 | 1468.8219 |  |  |  |  |  |  | 32550
10 | 32550 | 32850 | 2896.912499999999 |  |  |  |  |  |  | 32560
10 | 32883.5 | 33131.5 | 2180.568519999999 |  |  |  |  |  |  | 32570
10 | 33138.5 | 33400 | 2228.555057870371 |  |  |  |  |  |  | 32580
11 | 32350 | 32506 | 1454.1969 |  |  |  |  |  |  | 32590
11 | 32550 | 32850 | 2868.787499999999 |  |  |  |  |  |  | 32600
11 | 32883.5 | 33131.5 | 2157.318519999999 |  |  |  |  |  |  | 32610
11 | 33138.5 | 33400 | 2204.039432870371 |  |  |  |  |  |  | 32620
12 | 32350 | 32506 | 1439.5719 |  |  |  |  |  |  | 32630
12 | 32550 | 32800 | 2384.10875 |  |  |  |  |  |  | 32640
12 | 32883.5 | 33131.5 | 2134.068519999999 |  |  |  |  |  |  | 32650
12 | 33145 | 33400 | 2126.006105769231 |  |  |  |  |  |  | 32660
13 | 32350 | 32506 | 1424.9469 |  |  |  |  |  |  | 32670
13 | 32550 | 32800 | 2360.67125 |  |  |  |  |  |  | 32680
13 | 33145 | 33400 | 2102.099855769231 |  |  |  |  |  |  | 32690
14 | 32550 | 32800 | 2337.23375 |  |  |  |  |  |  | 32700
1 | 33400 | 33550 | 1431.83375 |  |  |  |  |  |  | 32710
1 | 33550 | 33650 | 882.4549999999998 |  |  |  |  |  |  | 32720
1 | 33650 | 33969 | 2617.33968951613 |  |  |  |  |  |  | 32730
2 | 33400 | 33474 | 698.68025 |  |  |  |  |  |  | 32740
2 | 33481 | 33650 | 1526.115977941176 |  |  |  |  |  |  | 32750
2 | 33720 | 33900 | 1440.245 |  |  |  |  |  |  | 32760
3 | 33400 | 33450 | 466.49875 |  |  |  |  |  |  | 32770
3 | 33481 | 33549 | 639.5853333333333 |  |  |  |  |  |  | 32780
3 | 33550 | 33650 | 863.7049999999998 |  |  |  |  |  |  | 32790
4 | 33400 | 33450 | 461.81125 |  |  |  |  |  |  | 32800
4 | 33551 | 33650 | 845.7866999999999 |  |  |  |  |  |  | 32810
5 | 33551 | 33650 | 836.5054499999999 |  |  |  |  |  |  | 32820
 |  |  |  |  |  |  |  |  |  | 32830
 |  |  |  |  |  |  |  |  |  | 32840
 |  |  |  |  |  |  |  |  |  | 32850
 |  |  |  |  |  |  |  |  |  | 32860
 |  |  |  |  |  |  |  |  |  | 32870
 |  |  |  |  |  |  |  |  |  | 32880
 |  |  |  |  |  |  |  |  |  | 32890
 |  |  |  |  |  |  |  |  |  | 32900
 |  |  |  |  |  |  |  |  |  | 32910
 |  |  |  |  |  |  |  |  |  | 32920
 |  |  |  |  |  |  |  |  |  | 32930
 |  |  |  |  |  |  |  |  |  | 32940
 |  |  |  |  |  |  |  |  |  | 32950
 |  |  |  |  |  |  |  |  |  | 32960
 |  |  |  |  |  |  |  |  |  | 32970
 |  |  |  |  |  |  |  |  |  | 32980
 |  |  |  |  |  |  |  |  |  | 32990
 |  |  |  |  |  |  |  |  |  | 33000
 |  |  |  |  |  |  |  |  |  | 33010
 |  |  |  |  |  |  |  |  |  | 33020
 |  |  |  |  |  |  |  |  |  | 33030
 |  |  |  |  |  |  |  |  |  | 33040
 |  |  |  |  |  |  |  |  |  | 33050
 |  |  |  |  |  |  |  |  |  | 33060
 |  |  |  |  |  |  |  |  |  | 33070
 |  |  |  |  |  |  |  |  |  | 33080
 |  |  |  |  |  |  |  |  |  | 33090
 |  |  |  |  |  |  |  |  |  | 33100
 |  |  |  |  |  |  |  |  |  | 33110
 |  |  |  |  |  |  |  |  |  | 33120
 |  |  |  |  |  |  |  |  |  | 33130
 |  |  |  |  |  |  |  |  |  | 33140
 |  |  |  |  |  |  |  |  |  | 33150
 |  |  |  |  |  |  |  |  |  | 33160
 |  |  |  |  |  |  |  |  |  | 33170
 |  |  |  |  |  |  |  |  |  | 33180
 |  |  |  |  |  |  |  |  |  | 33190
 |  |  |  |  |  |  |  |  |  | 33200
 |  |  |  |  |  |  |  |  |  | 33210
 |  |  |  |  |  |  |  |  |  | 33220
 |  |  |  |  |  |  |  |  |  | 33230
 |  |  |  |  |  |  |  |  |  | 33240
 |  |  |  |  |  |  |  |  |  | 33250
 |  |  |  |  |  |  |  |  |  | 33260
 |  |  |  |  |  |  |  |  |  | 33270
 |  |  |  |  |  |  |  |  |  | 33280
 |  |  |  |  |  |  |  |  |  | 33290
 |  |  |  |  |  |  |  |  |  | 33300
 |  |  |  |  |  |  |  |  |  | 33310
 |  |  |  |  |  |  |  |  |  | 33320
 |  |  |  |  |  |  |  |  |  | 33330
 |  |  |  |  |  |  |  |  |  | 33340
 |  |  |  |  |  |  |  |  |  | 33350
 |  |  |  |  |  |  |  |  |  | 33360
 |  |  |  |  |  |  |  |  |  | 33370
 |  |  |  |  |  |  |  |  |  | 33380
 |  |  |  |  |  |  |  |  |  | 33390
 |  |  |  |  |  |  |  |  |  | 33400
 |  |  |  |  |  |  |  |  |  | 33410
 |  |  |  |  |  |  |  |  |  | 33420
 |  |  |  |  |  |  |  |  |  | 33430
 |  |  |  |  |  |  |  |  |  | 33440
 |  |  |  |  |  |  |  |  |  | 33450
 |  |  |  |  |  |  |  |  |  | 33460
 |  |  |  |  |  |  |  |  |  | 33470
 |  |  |  |  |  |  |  |  |  | 33480
 |  |  |  |  |  |  |  |  |  | 33490
 |  |  |  |  |  |  |  |  |  | 33500
 |  |  |  |  |  |  |  |  |  | 33510
 |  |  |  |  |  |  |  |  |  | 33520
 |  |  |  |  |  |  |  |  |  | 33530
 |  |  |  |  |  |  |  |  |  | 33540
 |  |  |  |  |  |  |  |  |  | 33550
 |  |  |  |  |  |  |  |  |  | 33560
 |  |  |  |  |  |  |  |  |  | 33570
 |  |  |  |  |  |  |  |  |  | 33580
 |  |  |  |  |  |  |  |  |  | 33590
 |  |  |  |  |  |  |  |  |  | 33600
 |  |  |  |  |  |  |  |  |  | 33610
 |  |  |  |  |  |  |  |  |  | 33620
 |  |  |  |  |  |  |  |  |  | 33630
 |  |  |  |  |  |  |  |  |  | 33640
 |  |  |  |  |  |  |  |  |  | 33650
 |  |  |  |  |  |  |  |  |  | 33660
 |  |  |  |  |  |  |  |  |  | 33670
 |  |  |  |  |  |  |  |  |  | 33680
 |  |  |  |  |  |  |  |  |  | 33690
 |  |  |  |  |  |  |  |  |  | 33700
 |  |  |  |  |  |  |  |  |  | 33710
 |  |  |  |  |  |  |  |  |  | 33720
 |  |  |  |  |  |  |  |  |  | 33730
 |  |  |  |  |  |  |  |  |  | 33740
 |  |  |  |  |  |  |  |  |  | 33750
 |  |  |  |  |  |  |  |  |  | 33760
 |  |  |  |  |  |  |  |  |  | 33770
 |  |  |  |  |  |  |  |  |  | 33780
 |  |  |  |  |  |  |  |  |  | 33790
 |  |  |  |  |  |  |  |  |  | 33800
 |  |  |  |  |  |  |  |  |  | 33810
 |  |  |  |  |  |  |  |  |  | 33820
 |  |  |  |  |  |  |  |  |  | 33830
 |  |  |  |  |  |  |  |  |  | 33840
 |  |  |  |  |  |  |  |  |  | 33850
 |  |  |  |  |  |  |  |  |  | 33860
 |  |  |  |  |  |  |  |  |  | 33870
 |  |  |  |  |  |  |  |  |  | 33880
 |  |  |  |  |  |  |  |  |  | 33890
 |  |  |  |  |  |  |  |  |  | 33900
 |  |  |  |  |  |  |  |  |  | 33910
 |  |  |  |  |  |  |  |  |  | 33920
 |  |  |  |  |  |  |  |  |  | 33930
 |  |  |  |  |  |  |  |  |  | 33940
 |  |  |  |  |  |  |  |  |  | 33950
 |  |  |  |  |  |  |  |  |  | 33960
 |  |  |  |  |  |  |  |  |  | 33970
 |  |  |  |  |  |  |  |  |  | 33980
 |  |  |  |  |  |  |  |  |  | 33990
 |  |  |  |  |  |  |  |  |  | 34000