Spreadsheet: 682712d1592288146-rank-values-with-non-sequential-data-and-ignore-text-rank-xlsx-v2
Sheet: Sheet1

Company 1 Annual Savings | Company 1  Rank | EXW Price | DDP Price | Packaging Price | Delivery Price | Duties & Customs Price | Castings Ltd Tooling | MOQ | Difference DDP to best price £/pc | Difference DDP total in £ | Savings in £/piece DDP | Savings in % DDP | Company 2 Annual Savings | Company 2  Rank | EXW Price | DDP Price | Packaging Price | Delivery Price | Duties & Customs Price | Castings Ltd Tooling | MOQ | Difference DDP to best price £/pc | Difference DDP total in £ | Savings in £/piece DDP | Savings in % DDP | Company 3 Annual Savings | Company 3 Rank | EXW Price | DDP Price | Packaging Price | Delivery Price | Duties & Customs Price | Castings Ltd Tooling | MOQ | Difference DDP to best price £/pc | Difference DDP total in £ | Savings in £/piece DDP | Savings in % DDP | Company 4 Annual Savings | Company 4 Rank | EXW Price | DDP Price | Packaging Price | Delivery Price | Duties & Customs Price | Castings Ltd Tooling | MOQ | Difference DDP to best price £/pc | Difference DDP total in £ | Savings in £/piece DDP | Savings in % DDP | Company 5 Annual Savings | Company 5 Rank | EXW Price | DDP Price | Packaging Price | Delivery Price | Duties & Customs Price | Castings Ltd Tooling | MOQ | Difference DDP to best price £/pc | Difference DDP total in £ | Savings in £/piece DDP | Savings in % DDP | Company 6 Annual Savings | Company 6 Rank | EXW Price | DDP Price | Packaging Price | Delivery Price | Duties & Customs Price | Castings Ltd Tooling | MOQ | Difference DDP to best price £/pc | Difference DDP total in £ | Savings in £/piece DDP | Savings in % DDP | Company 7 Annual Savings | Company 7 Rank
192.9612064413973 | The answer here should be 4 | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | The answer here should be N/A | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | The answer here should be N/A | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | The answer here should be N/A | 4.620094678333333 | 5.037904404466667 | 0.06119533333333333 | 0.088227195 | 0.3295825311333334 | 5361.740654205607 | 1500 | 2.90587437011106 | 11649.65034977524 | 0.1073955955333332 | 0.02087256244209924 | 430.5489424931329 | The answer here should be 3 | 1.9955 | 2.132030034355606 | 0.031928 | 0.01584908901472254 | 0.1206809453408834 | 3844.019452 | 1500 | 0 | 0 | 3.013269965644394 | 0.585635427602743 | 12080.19929226837 | The answer here should be 1 | 4.15 | 4.15 | 0 | 0 | 0 | 37500 | 2000 | 2.017969965644394 | 8090.041592268376 | 0.9952999999999994 | 0.193438672186267 | 3990.157699999997 | The answer here should be 2
803.2845160706032 |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | 2.667897978571429 | 2.917586236171429 | 0.06556642857142857 | 0.05881813 | 0.1908701276 | 3351.087908878505 | 1400 | 1.241245879361851 | 11302.78497746902 | 0.4217137638285711 | 0.1262880734970117 | 3840.125533422968 |  | 1.564472 | 1.676340356809578 | 0.031928 | 0.01698116680148843 | 0.0948871900080893 | 1752.424154 | 1500 | 0 | 0 | 1.662959643190423 | 0.4979964792592527 | 15142.91051089199 |  | 2.26 | 2.26 | 0 | 0 | 0 | 15000 | 1000 | 0.5836596431904226 | 5314.804710891988 | 1.0793 | 0.3232114515018117 | 9828.1058
-77.39244901650507 |  | 2.4 | 2.4 | 0 | 0 | 0 | 4400 | 1000 | 1.605325614704242 | 60846.6567741349 | -0.7985 | -0.4985950671245707 | -30265.5455 |  | 3.081169 | 3.440489 | 0.026949 | 0.35932 | 0 | 9162.66 | 1000 | 2.645814614704242 | 100284.3113411349 | -1.838989 | -1.148291601623478 | -69703.200067 |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | 2.885317936904762 | 3.136739434638095 | 0.0420297619047619 | 0.046214245 | 0.2052072527333333 | 1608.522196261682 | 1000 | 2.342065049342338 | 88771.29156522262 | -1.535239434638095 | -0.9586259348349019 | -58190.18029108772 |  | 0.734344 | 0.7946743852957575 | 0.023946 | 0.01534881631675233 | 0.04498156897900514 | 847.9757519999999 | 1500 | 0 | 0 | 0.8068256147042424 | 0.5037937025939697 | 30581.1112741349 |  | 1.28 | 1.28 | 0 | 0 | 0 | 15000 | 2500 | 0.4853256147042425 | 18395.29677413491 | 0.3214999999999999 | 0.2007492975335622 | 12185.8145
-283.390725 |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | 1.085552 | 1.181854526777135 | 0.031928 | 0.02940510073314657 | 0.0668974260439888 | 904.4723480000001 | 1500 | 0 | 0 | 0.2272454732228646 | 0.1612699405456423 | 105.2146541021863 |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote
-1455.442144866893 |  | 2.03 | 2.03 | 0 | 0 | 0 | 3220 | 1000 | 1.417383856896942 | 147681.4762016631 | -0.9992000000000003 | -0.9693441986806367 | -104109.6456 |  | 2.048124 | 2.227784 | 0.017966 | 0.17966 | 0 | 5210.14 | 3000 | 1.615167856896942 | 168289.1845136631 | -1.196984 | -1.161218471090415 | -124717.353912 |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | 1.229142267407408 | 1.351145311325926 | 0.0339974074074074 | 0.03361036 | 0.08839268391851852 | 2680.870327102803 | 1000 | 0.7385291682228682 | 76949.5696246453 | -0.320345311325926 | -0.3107734878986477 | -33377.73902298221 |  | 0.566722 | 0.6126161431030578 | 0.015964 | 0.01121775764439411 | 0.03467638545866365 | 791.8144 | 1500 | 0 | 0 | 0.4181838568969422 | 0.4056886465822101 | 43571.8306016631 |  | 1.07 | 1.07 | 0 | 0 | 0 | 15000 | 2000 | 0.4573838568969423 | 47656.19620166311 | -0.03920000000000012 | -0.03802871556072965 | -4084.365600000013
-2076.953506999999 |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | 0.8980415166666665 | 0.9856290439083333 | 0.03059766666666667 | 0.0231071225 | 0.06448040474166666 | 2010.652745327103 | 1000 | 0.6449514231155813 | 84850.454176509 | -0.2019290439083333 | -0.2576611508336523 | -26565.98694562424 |  | 0.311298 | 0.340677620792752 | 0.007982 | 0.0100959818799547 | 0.01928363891279728 | 957.84 | 3000 | 0 | 0 | 0.443022379207248 | 0.5652958775133954 | 58284.46723088475 |  | 0.73 | 0.73 | 0 | 0 | 0 | 15000 | 8000 | 0.389322379207248 | 51219.64153088475 | 0.05369999999999997 | 0.06852111777465864 | 7064.825699999996
-5816.500566924007 |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote | No Quote |  | 4.68 | 4.68 | 0 | 0 | 0 | 370650 | 0 | 3.367563799456398 | 23128.42817466654 | -1.6218 | -0.5303119482048264 | -11138.5224 |  | 2.357346232222222 | 2.601029717352778 | 0.1019922222222222 | 0.07352266249999999 | 0.1701608226305555 | 8846.872079439252 | 1800 | 1.288593516809176 | 8850.060273445422 | 0.4571702826472221 | 0.1494899884400046 | 3139.845501221122 |  | 1.205282 | 1.312436200543601 | 0.031928 | 0.03286535900339751 | 0.07428884154020385 | 1074.05792 | 1500 | 0 | 0 | 1.745763799456398 | 0.5708468378315343 | 11989.90577466654 |  | 1.9 | 1.9 | 0 | 0 | 0 | 15000 | 2000 | 0.5875637994563985 | 4035.388174666545 | 1.1582 | 0.3787195082074423 | 7954.517599999999