Spreadsheet: 474539d1470800490-how-to-fix-the-offset-formula-in-name-manager-how-to-fix-the-offset-formula-in-name-manager
Sheet: sheet 2

Summary Table
 | Product | 3m [NAME]. | 3m Dist. | Jan-11 | Feb-11 | Mar-11 | Apr-11 | May-11 | Jun-11 | Jul-11 | Aug-11 | Sep-11 | Oct-11 | Nov-11 | Dec-11 | Jan-12 | Feb-12 | Mar-12 | Apr-12 | May-12 | Jun-12 | Jul-12 | Aug-12 | Sep-12 | Oct-12 | Nov-12 | Dec-12 | [NAME] | Feb-13 | Mar-13 | Apr-13 | [NAME] | Jun-13 | Jul-13 | Aug-13 | Sep-13 | Oct-13 | Nov-13 | Dec-13 | Jan-14 | Feb-14 | Mar-14 | Apr-14 | May-14 | Jun-14 | Jul-14 | Aug-14 | Sep-14 | Oct-14 | Nov-14 | Dec-14 | Jan-15 | Feb-15 | Mar-15 | Apr-15 | May-15 | Jun-15 | Jul-15 | Aug-15 | Sep-15 | Oct-15 | Nov-15 | Dec-15 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00
Total Distances (LPG Bulk) | LPG Bulk
Internal | LPG Bulk
Total Distances (LPG Cylinders) | LPG Cylinders
Internal | LPG Cylinders
GRAND TOTAL | ALL
Data Table
Truck No. | Ownership | Product | Capacity | Jan-11 | Feb-11 | Mar-11 | Apr-11 | May-11 | Jun-11 | Jul-11 | Aug-11 | Sep-11 | Oct-11 | Nov-11 | Dec-11 | Jan-12 | Feb-12 | Mar-12 | Apr-12 | May-12 | Jun-12 | Jul-12 | Aug-12 | Sep-12 | Oct-12 | Nov-12 | Dec-12 | [NAME] | Feb-13 | Mar-13 | Apr-13 | [NAME] | Jun-13 | Jul-13 | Aug-13 | Sep-13 | Oct-13 | Nov-13 | Dec-13 | Jan-14 | Feb-14 | Mar-14 | Apr-14 | May-14 | Jun-14 | Jul-14 | Aug-14 | Sep-14 | Oct-14 | Nov-14 | Dec-14 | Jan-15 | Feb-15 | Mar-15 | Apr-15 | May-15 | Jun-15 | Jul-15 | Aug-15 | Sep-15 | Oct-15 | Nov-15 | Dec-15 | Jan-16 | Feb-16 | [NAME] | Apr-16 | [NAME] | Jun-16 | [NAME] | Aug-16 | Sep-16 | [NAME] | Nov-16 | Dec-16 | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | Nov-17 | Dec-17
A |  |  |  | 8422 | 6542 | 6530 | 6420 | 8122 | 5060 | 0 | 0 | 0 | 3240 | 6150 | 4430 | 4800 | 6660 | 4762 | 5650 | 6682 | 6500 | 8420 | 7400 | 5760 | 7628 | 8770 | 8740 | 7150 | 5743 | 7300 | 6390 | 7390 | 7920 | 6750 | 8219 | 6685 | 7080 | 7620 | 5780 | 8190 | 4320 | 5470 | 6345 | 6030 | 6200 | 7020 | 6050 | 6630 | 5160 | 5780 | 3180 | 7260 | 5780 | 6980 | 5290 | 5250 | 6390 | 7020 | 4340 | 5680 | 4195 | 5270 | 6250 | 4920 | 5570 | 4182.8 | 2037.42 | 4410 | 4940 | 3840
B |  |  |  | 2610 | 6710 | 8114 | 5770 | 7350 | 7712 | 5820 | 7500 | 1940 | 8230 | 6322 | 5120 | 5010 | 6630 | 4770 | 4930 | 4257 | 6600 | 10600 | 7385 | 8070 | 8620 | 8160 | 5630 | 7686 | 7309 | 2310 | 0 | 0 | 0 | 6490 | 8560 | 6660 | 7460 | 6619 | 6440 | 7830 | 5330 | 5270 | 6680 | 8140 | 6369 | 7099 | 6320 | 5820 | 4580 | 6080 | 5619 | 6410 | 5090 | 7660 | 5700 | 6080 | 1530 | 0 | 2900 | 6330 | 5090 | 5280 | 6300 | 4600 | 5740 | 4333.9 | 2487.43 | 4350 | 4820 | 4560
B |  |  |  | 9960 | 8196 | 7010 | 7940 | 5360 | 6660 | 7670 | 5070 | 5480 | 5190 | 4270 | 3850 | 4790 | 4550 | 2940 | 2335 | 2110 | 5690 | 7650 | 7270 | 5140 | 6210 | 6600 | 7010 | 7570 | 6573 | 6290 | 5720 | 6510 | 7500 | 6050 | 5860 | 5830 | 6850 | 4280 | 5170 | 6050 | 4850 | 5300 | 5300 | 5770 | 2960 | 0 | 0 | 3860 | 5150 | 4750 | 5490 | 6020 | 4810 | 4740 | 3230 | 4610 | 4280 | 4350 | 2840 | 4870 | 4300 | 4100 | 4970 | 4030 | 5090 | 3831.6 | 3324.31 | 3250 | 3990 | 3410
B |  |  |  | 10010 | 2330 | 10060 | 8080 | 9140 | 7690 | 9764 | 8064 | 8280 | 6870 | 5090 | 6426 | 8090 | 7170 | 5080 | 6560 | 6800 | 7870 | 9060 | 7410 | 6640 | 8750 | 7022 | 6342 | 6820 | 6313 | 6302 | 5832 | 7472 | 7020 | 5710 | 6240 | 4290 | 6065 | 5000 | 5220 | 6000 | 3470 | 5450 | 4720 | 5440 | 5620 | 6390 | 5430 | 5180 | 4220 | 3650 | 5770 | 6262 | 4210 | 5680 | 3860 | 3000 | 2960 | 6708.7 | 3590 | 4910 | 3890 | 3720 | 4980 | 3600 | 4390 | 3289.5 | 2948.66 | 3960 | 4560 | 3592
B |  |  |  | 3602 | 7930 | 8860 | 7260 | 7387 | 8888 | 8927 | 7510 | 6850 | 6700 | 6460 | 5155 | 3032 | 6005 | 6940 | 7735 | 8360 | 6080 | 7820 | 7710 | 1470 | 8720 | 8447 | 8340 | 7630 | 7840 | 6600 | 5120 | 7460 | 9279 | 8790 | 7540 | 6650 | 6970 | 6130 | 5670 | 8010 | 5700 | 5430 | 5750 | 7120 | 5850 | 5640 | 6100 | 7170 | 5835 | 6780 | 7340 | 6450 | 5100 | 6390 | 5420 | 4710 | 6110 | 6920 | 6260 | 6340 | 5920 | 5720 | 6630 | 7040 | 6050 | 5615.2 | 5738.48 | 6990 | 6800 | 7640
B |  |  |  | 8523 | 7160 | 7718 | 6423 | 8088 | 8424 | 7226 | 8154 | 6848 | 7650 | 6406 | 5205 | 2862 | 6690 | 4947 | 8299 | 6916 | 8620 | 7750 | 8540 | 8280 | 7612 | 9370 | 7800 | 7070 | 6643 | 7650 | 6940 | 7790 | 8955 | 7725 | 7710 | 6190 | 8794 | 7040 | 6440 | 4770 | 6140 | 6515 | 6270 | 6450 | 6230 | 6320 | 6220 | 7370 | 6130 | 5670 | 5920 | 6900 | 4130 | 6460 | 5190 | 5260 | 5970 | 7355 | 5850 | 6690 | 6510 | 6340 | 7500 | 4590 | 5890 | 5726.1 | 4533.98 | 6120 | 7930 | 7790
B |  |  |  | 9360 | 9002 | 5830 | 8080 | 8002 | 6922 | 9652 | 8524 | 9112 | 8570 | 4820 | 7562 | 8752 | 5652 | 5110 | 5952 | 7950 | 7330 | 8560 | 8860 | 7620 | 8501 | 5992 | 7142 | 6212 | 7130 | 6878 | 7060 | 7108 | 8982 | 5900 | 6870 | 4800 | 7050 | 5580 | 5662 | 5560 | 4172 | 5802 | 6090 | 6622 | 6300 | 3520 | 5830 | 5270 | 4250 | 4540 | 5540 | 5460 | 4320 | 5140 | 4220 | 4490 | 4280 | 7355 | 3995 | 4540 | 4180 | 2710 | 3470 | 3470 | 4540 | 3928.8 | 2854.39 | 2960 | 3790 | 3960
B |  |  |  | 4855 | 3270 | 4740 | 3200 | 5058 | 5478 | 5450 | 6819 | 5680 | 4483 | 1535 | 5280 | 3972 | 3590 | 4895 | 4960 | 6280 | 6175 | 6645 | 5665 | 5669 | 5375 | 5380 | 6425 | 6408 | 3335 | 6060 | 5430 | 6505 | 6959 | 1250 | 7815 | 6735 | 7580 | 6195 | 5210 | 6374 | 3071 | 5997 | 6361 | 5693 | 5435 | 0 | 1060 | 4860 | 5045 | 4035 | 4265 | 3590 | 2985 | 4643.1 | 4700 | 4265 | 4520 | 4365 | 3147 | 3834 | 2930 | 3967 | 4080 | 3424.9 | 3035 | 3623.9 | 1660 | 0 | 0 | 0
B |  |  |  | 4620 | 3485 | 5070 | 5025 | 4375 | 4890 | 5325 | 5860 | 5189 | 6599 | 6280 | 3560 | 2585 | 3530 | 4675 | 3890 | 3880 | 3320 | 3810 | 3950 | 3730 | 760 | 3550 | 4680 | 4190 | 2300 | 4379 | 4150 | 4012 | 4345 | 4790 | 4570 | 4670 | 4865 | 3585 | 4210 | 3775 | 2663 | 4895 | 4550 | 4700 | 5055 | 7848 | 5895 | 4895 | 4305 | 4000 | 4415 | 3940 | 2475 | 2859.225 | 2830 | 4415 | 4880 | 4563 | 3317 | 4360 | 3942 | 3700 | 4980 | 3709.5 | 3279 | 3378.2 | 3240 | 3117.29 | 4390 | 3158
B |  |  |  | 2900 | 360 | 2950 | 4415 | 3170 | 2740 | 3502 | 3770 | 3470 | 3640 | 3110 | 2434 | 4220 | 3550 | 2220 | 2000 | 3019 | 5330 | 2930 | 6190 | 3310 | 3732 | 2830 | 3020 | 4240 | 1980 | 3180 | 2947 | 3380 | 2450 | 2390 | 2740 | 1930 | 1610 | 2070 | 2120 | 2360 | 1700 | 1420 | 1500 | 3224 | 2020 | 3150 | 2870 | 1740 | 2280 | 1280 | 2010 | 2640 | 2130 | 2291.4 | 2600 | 2010 | 2700 | 3070 | 1749 | 2210 | 2260 | 3770 | 1710 |  |  | 0 |  | 0 | 0 | 0
B |  |  |  | 3313 | 2094 | 3890 | 3200 | 3421 | 4437 | 4328 | 3992 | 4614 | 4271 | 5681 | 4729 | 2580 | 3513 | 4617 | 4495 | 5073 | 5582 | 5085 | 5031 | 5651 | 5291 | 5146 | 5541 | 5575 | 3037 | 4573 | 4356 | 4690 | 4880 | 4857 | 6393 | 4682 | 5891 | 6464 | 4675 | 3833 | 3110 | 5027 | 4905 | 6019 | 5525 | 6811 | 6158 | 5685 | 5569 | 4494 | 3132 | 3571 | 2134 | 2983.845 | 3546 | 3132 | 5111 | 3896 | 4368 | 3430 | 3215 | 2689 | 3622 | 3584.4 | 2194 | 3026.8 | 2885 | 2851.64 | 3028 | 3033.7
B |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1760 | 4048 | 4008 | 2909 | 2153 | 3153.69 | 3754 | 4008 | 1529 | 4397 | 3449 | 3484 | 3784 | 3990 | 4591 | 3624 | 3360 | 4702.8 | 2497 | 4183.740000000001 | 3615 | 3399.4
B |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1492 | 2608 | 3464 | 2916 | 1910 | 2630.085 | 3364 | 3464 | 2805 | 3206 | 2298 | 4045 | 2822 | 3350 | 3784 | 2976.8 | 2835 | 3937.6 | 3740 | 3534.3 | 3555 | 3874.5
B |  |  |  | 4468 | 2665 | 3950 | 4655 | 4045 | 5223 | 5331 | 3973 | 4986 | 4940 | 5305 | 3536 | 2882 | 4034 | 1640 | 3217 | 1820 | 3358 | 4442 | 4206 | 3608 | 3904 | 4713 | 4808 | 4704 | 2658 | 4418 | 3749 | 5057 | 4529 | 4845 | 4099 | 4540 | 5431 | 3854 | 4729 | 4318 | 3196 | 3962 | 4315 | 2481 | 4591 | 6000 | 3756 | 3978 | 4181 | 560 | 1931 | 3029 | 2290 | 1390.92 | 2624 | 1931 | 4482 | 2378 | 2104 | 3128 | 2853 | 3472 | 4833 | 1726.5 | 376 | 0 |  | 0 | 0 | 0
B |  |  |  | 3871 | 3104 | 4570 | 4819 | 4337 | 2212 | 0 | 0 | 0 | 0 | 2474 | 5382 | 3808 | 5096 | 4578 | 4476 | 5626 | 5308 | 5381 | 4392 | 3270 | 5426 | 5046 | 5460 | 4910 | 2705 | 4510 | 4568 | 4133 | 3309 | 3797 |  | 4206 | 4023 | 4787 | 5392 | 3850 | 2580 | 4913 | 3655 | 5457 | 2472 | 651 | 5736 | 5019 | 4197 | 4497 | 2295 | 2501 | 1440 | 430.14 | 2091 | 2295 | 3265 | 2174 | 1295 | 2151 | 2101 | 3139 | 3523 | 1439.6 | 1784 | 2437.9 |  | 0 | 0 | 0
B |  |  |  | 4050 | 2360 | 660 | 1530 | 1000 | 600 | 830 | 1660 | 2240 | 1160 | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  | 0 | 0 | 0
B |  |  |  | 2898 | 1500 | 2495 | 4015 | 5857 | 4115 | 3065 | 1865 | 2580 | 2500 | 2915 | 3670 | 4030 | 3286 | 3050 | 2084 | 2735 | 3360 | 5895 | 5265 | 1810 | 3010 | 1640 | 2320 | 2760 | 1430 | 1600 | 1891 | 2643 | 2590 | 2000 | 2095 | 1740 | 3105 | 2305 | 1160 | 2160 | 1450 | 1583 | 1360 | 2390 | 2117 | 2520 | 2300 | 2435 | 2330 | 1875 | 2900 | 840 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 0 |  | 0 | 0 | 0
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 660.88 | 3031 | 2697 | 3343.8
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2646 | 3213 | 3088 | 3126.8
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3160 | 0 | 0 | 0
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2789 | 2872 | 2951 | 2973.9