Spreadsheet: 729284d1619001531-need-formula-to-calculate-value-from-vertical-and-horizontal-data-sample-3-
Sheet: Sheet1

Weight ([NAME]) | ZONE 1 | ZONE 2 | ZONE 3 | ZONE 4 | ZONE 5 | ZONE 6 | ZONE 7 | ZONE 8 | ZONE 9 | ZONE 10 | ZONE 11 | ZONE 12 | ZONE 13
0.5 | 700 | 925 | 1069 | 1014 | 1525 | 1138 | 1328 | 2994 | 2802 | 2885 | 3173 | 1707 | 1898
1 | 912 | 1143 | 1274 | 1250 | 1908 | 1389 | 1534 | 3664 | 3238 | 3807 | 3936 | 1972 | 2312
1.5 | 1049 | 1318 | 1870 | 1440 | 2193 | 1562 | 1915 | 4169 | 3675 | 4320 | 4546 | 2388 | 2713
2 | 1186 | 1494 | 2120 | 1631 | 2478 | 1801 | 2142 | 4674 | 4113 | 4834 | 5157 | 2672 | 3119
2.5 | 1588 | 1669 | 2372 | 1821 | 2764 | 2040 | 2370 | 5171 | 4550 | 5348 | 5768 | 2957 | 3532
3 | 1714 | 2401 | 3223 | 2635 | 2998 | 3010 | 2931 | 5675 | 4959 | 5817 | 6341 | 3912 | 3872
3.5 | 1841 | 2578 | 3481 | 2842 | 3232 | 3186 | 3169 | 6180 | 5367 | 6287 | 6914 | 4234 | 4207
4 | 1968 | 2754 | 3739 | 3048 | 3466 | 3362 | 3407 | 6684 | 5775 | 6756 | 7487 | 4556 | 4524
4.5 | 2095 | 2931 | 3998 | 3255 | 3700 | 3538 | 3646 | 7188 | 6183 | 7226 | 8060 | 4879 | 4852
5 | 2221 | 3107 | 4256 | 3461 | 3934 | 3900 | 3884 | 7693 | 6592 | 7695 | 8633 | 5201 | 5174
5.5 | 2935 | 4011 | 5326 | 4513 | 5318 | 4890 | 4348 | 8162 | 6934 | 8099 | 9116 | 5210 | 6206
6 | 3032 | 4138 | 5545 | 4700 | 5538 | 5101 | 4554 | 8631 | 7276 | 8502 | 9598 | 5467 | 6565
6.5 | 3129 | 4264 | 5763 | 4886 | 5757 | 5311 | 4760 | 9101 | 7617 | 8906 | 10081 | 5724 | 6942
7 | 3226 | 4391 | 5982 | 5072 | 5977 | 5522 | 4965 | 9570 | 7959 | 9309 | 10563 | 5981 | 7297
7.5 | 3323 | 4518 | 6201 | 5259 | 6197 | 5732 | 5171 | 10039 | 8301 | 9712 | 11045 | 6604 | 7675
8 | 3420 | 4645 | 6420 | 5445 | 6417 | 5942 | 5377 | 10509 | 8643 | 10116 | 11528 | 6876 | 8033
8.5 | 3518 | 4772 | 6639 | 5632 | 6637 | 6152 | 5582 | 10978 | 8985 | 10519 | 12010 | 7148 | 8410
9 | 3615 | 4899 | 6857 | 5818 | 6857 | 6363 | 5788 | 11447 | 9327 | 10923 | 12492 | 7420 | 8765
9.5 | 3712 | 5026 | 7076 | 6005 | 7076 | 6573 | 5994 | 11916 | 9669 | 11326 | 12975 | 7692 | 9132
10 | 3809 | 5152 | 7295 | 6191 | 7296 | 6784 | 6199 | 12386 | 10010 | 11730 | 13457 | 7964 | 9477
10.5 | 4639 | 5989 | 8711 | 7597 | 7911 | 6307 | 6798 | 12712 | 10702 | 12929 | 14492 | 8456 | 9818
11 | 4772 | 6089 | 8910 | 7765 | 8083 | 6607 | 6954 | 13038 | 11004 | 13291 | 14855 | 8471 | 10140
11.5 | 4905 | 6189 | 9110 | 7933 | 8255 | 6908 | 7110 | 13363 | 11306 | 13652 | 15217 | 8703 | 10478
12 | 5038 | 6290 | 9310 | 8101 | 8427 | 7208 | 7266 | 13689 | 11607 | 14014 | 15579 | 8935 | 10800
12.5 | 5172 | 6390 | 9510 | 8269 | 8599 | 7508 | 7421 | 14015 | 11909 | 14375 | 15942 | 9168 | 11140
13 | 5305 | 6490 | 9710 | 8437 | 8771 | 7809 | 7577 | 14341 | 12211 | 14737 | 16304 | 9400 | 11452
13.5 | 5438 | 6591 | 9910 | 8605 | 8943 | 8109 | 7733 | 14667 | 12512 | 15099 | 16666 | 9632 | 11780
14 | 5571 | 6691 | 10110 | 8774 | 9115 | 8409 | 7889 | 14993 | 12814 | 15460 | 17029 | 9864 | 12100
14.5 | 5704 | 6791 | 10310 | 8942 | 9287 | 8710 | 8045 | 15319 | 13116 | 15822 | 17391 | 10097 | 12433
15 | 5837 | 6891 | 10510 | 9110 | 9460 | 9010 | 8201 | 15645 | 13417 | 16183 | 17753 | 10329 | 12741
15.5 | 6634 | 7769 | 12239 | 10309 | 11232 | 9754 | 8357 | 15971 | 13719 | 16545 | 18116 | 10561 | 13082
16 | 6782 | 7880 | 12468 | 10495 | 11433 | 10068 | 8513 | 16296 | 14021 | 16906 | 18478 | 10793 | 13401
16.5 | 6930 | 7991 | 12696 | 10682 | 11634 | 10383 | 8669 | 16622 | 14322 | 17268 | 18840 | 11026 | 13732
17 | 7077 | 8103 | 12925 | 10869 | 11834 | 10698 | 8824 | 16948 | 14624 | 17630 | 19203 | 11258 | 14053
17.5 | 7225 | 8214 | 13153 | 11055 | 12035 | 11012 | 8980 | 17274 | 14926 | 17991 | 19565 | 11490 | 14394
18 | 7373 | 8326 | 13381 | 11242 | 12236 | 11327 | 9136 | 17600 | 15227 | 18353 | 19927 | 11722 | 14715
18.5 | 7521 | 8437 | 13610 | 11429 | 12437 | 11642 | 9292 | 17926 | 15529 | 18714 | 20290 | 11955 | 15053
19 | 7669 | 8549 | 13838 | 11616 | 12637 | 11956 | 9448 | 18252 | 15831 | 19076 | 20652 | 12187 | 15377
19.5 | 7817 | 8660 | 14067 | 11802 | 12838 | 12271 | 9604 | 18578 | 16132 | 19437 | 21014 | 12419 | 15719
20 | 7965 | 8771 | 14295 | 11989 | 13039 | 12586 | 9760 | 18904 | 16434 | 19799 | 21377 | 12651 | 16027
21 | 479 | 464 | 636 | 663 | 648 | 625 | 502 | 947 | 851 | 1052 | 1167 | 635 | 801
46 | 411 | 423 | 552 | 569 | 617 | 526 | 496 | 1003 | 819 | 893 | 1111 | 611 | 799
71 | 380 | 391 | 506 | 529 | 568 | 674 | 471 | 918 | 797 | 849 | 1044 | 595 | 791