Spreadsheet: 680795d1591197035-help-with-if-and-book4v1
Sheet: Sheet1

supplier | part | [NAME] | price | per | [NAME] | x | true/false | [NAME]
JATON | SET12 |  | 34 | 1000 | 40345 | 0.034 | 0
VAN-LI | SET12 | HSS50 | 27.35 | 1000 | 40560 | 0.02735 | 0
[NAME] | SET12 | HTSMET00800025Z | 20.5 | 1000 | 43983 | 0.0205 | 0
HIGH | SET12 |  | 25.2 | 1000 | 40345 | 0.0252 | 0
GALAXY | SET12 | &MHS08 025,081 | 20.1 | 1000 | 43509 | 0.0201 | 0 | 12k MOQ
SAVILL | SET12 |  | 26.5 | 1000 | 40407 | 0.0265 | 0
MARTYN | SET12 | S08M08025Z-M8X25 BZP | 19.5 | 1000 | 40661 | 0.0195 | 0
ENGINE | SET12 |  | 23.8 | 1000 | 40345 | 0.0238 | 0
AIC-I | SET12 |  | 19.1 | 1000 | 41151 | 0.0191 | 0 | MOQ 40K. +6p BAGGED/LABELLED
WILLIA | SET12 | HTSM08025Z | 21 | 1000 | 41199 | 0.021 | 0
FASTPA | SET12 | XISS825 | 20 | 1000 | 42138 | 0.02 | 0
BAPP | SET12 |  | 15.5 | 1000 | 41954 | 0.0155 | 0
BROWNS | SET12 |  | 22.6 | 1000 | 43251 | 0.0226 | 0
FAST | SET12 | 093300800250008201 | 19.2 | 1000 | 43983 | 0.0192 | 1 | in 200's
JATON | SET13 |  | 31.6 | 1000 | 40345 | 0.0316 | 0
[NAME] | SET13 | HTSMET00800030Z | 25.5 | 1000 | 43983 | 0.0255 | 0
HIGH | SET13 |  | 27.9 | 1000 | 40345 | 0.0279 | 0
GALAXY | SET13 | &MHS08 030,081 | 22.9 | 1000 | 43521 | 0.0229 | 0 | 12K MOQ
SAVILL | SET13 |  | 29.8 | 1000 | 40345 | 0.0298 | 0
VAN-LI | SET13 | HSS105 | 28 | 1000 | 39114 | 0.028 | 0
MARTYN | SET13 | S08M08030Z | 21.8 | 1000 | 40661 | 0.0218 | 0
ENGINE | SET13 |  | 24.6 | 1000 | 40345 | 0.0246 | 0
AIC-I | SET13 |  | 21.9 | 1000 | 41151 | 0.0219 | 0 | MOQ 40K. +6p BAGGED/LABELLED
WILLIA | SET13 | HTSM08030Z | 23 | 1000 | 41199 | 0.023 | 0
FASTPA | SET13 | XISS830 | 22.1 | 1000 | 42138 | 0.0221 | 0
BAPP | SET13 |  | 17.2 | 1000 | 41954 | 0.0172 | 0
BROWNS | SET13 |  | 23 | 1000 | 43251 | 0.023 | 0
FAST | SET13 | 093300800300008201 | 19.8 | 1000 | 43879 | 0.0198 | 1 | in 200's
FOREM | SET14 | HSS51 | 6.07 | 200 |  | 0.03035 | 0
JATON | SET14 |  | 31.1 | 1000 | 40513 | 0.0311 | 0
VAN-LI | SET14 | HSS51 | 31.06 | 1000 | 39845 | 0.03106 | 0
[NAME] | SET14 | HTSMET00800040Z | 30.8 | 1000 | 43983 | 0.0308 | 0 | 22.10/K
HIGH | SET14 |  | 36.3 | 1000 | 40695 | 0.0363 | 0
GALAXY | SET14 | &MHS08 040,081 | 25.1 | 1000 | 43348 | 0.0251 | 0 | 12K MIN
SAVILL | SET14 |  | 33.3 | 1000 | 40360 | 0.0333 | 0
MARTYN | SET14 | S08M08040Z | 35.7 | 1000 | 40485 | 0.0357 | 0
ENGINE | SET14 |  | 28.2 | 1000 | 40311 | 0.0282 | 0
AIC-I | SET14 |  | 24.45 | 1000 | 41151 | 0.02445 | 0 | MOQ 40K. +6p BAGGED/LABELLED
WILLIA | SET14 |  | 26.3 | 1000 | 40725 | 0.0263 | 0
FASTPA | SET14 | XISS840 | 26.6 | 1000 | 42138 | 0.0266 | 0
BAPP | SET14 |  | 21 | 1000 | 41954 | 0.021 | 0
BROWNS | SET14 |  | 28.4 | 1000 | 43251 | 0.0284 | 0
FAST | SET14 | 093300800400008201 | 25 | 1000 | 43983 | 0.025 | 1 | in 200's
FOREM | SET15 | HSS52 | 3.73 | 100 |  | 0.0373 | 0
JATON | SET15 |  | 39.1 | 1000 | 40484 | 0.0391 | 0
VAN-LI | SET15 | HSS52 | 49.5 | 1000 | 40179 | 0.0495 | 0
[NAME] | SET15 | HTSMET00800050Z | 35.8 | 1000 | 43983 | 0.0358 | 0
HIGH | SET15 |  | 44.4 | 1000 | 40779 | 0.0444 | 0
GALAXY | SET15 | &MHS08 050,081 | 32 | 1000 | 43509 | 0.032 | 0 | 10K MOQ
SAVILL | SET15 |  | 39.6 | 1000 | 40445 | 0.0396 | 0
MARTYN | SET15 | S08M08050Z | 37 | 1000 | 40780 | 0.037 | 0
ENGINE | SET15 |  | 33.8 | 1000 | 40518 | 0.0338 | 0
AIC-I | SET15 |  | 33.01 | 1000 | 41151 | 0.03301 | 0 | MOQ 40K. +6p BAGGED/LABELLED
WILLIA | SET15 |  | 30.7 | 1000 | 40725 | 0.0307 | 0
FASTPA | SET15 | XISS850 | 28.9 | 1000 | 42138 | 0.0289 | 0
BAPP | SET15 |  | 25.4 | 1000 | 41954 | 0.0254 | 0
FAST | SET15 | 093300800500008201 | 29.6 | 1000 | 43971 | 0.0296 | 1 | in 200's
JATON | SET16 |  | 52.7 | 1000 | 40325 | 0.0527 | 0
VAN-LI | SET16 | HSS71 | 59.5 | 1000 | 40343 | 0.0595 | 0
HIGH | SET16 |  | 60.2 | 1000 | 40338 | 0.0602 | 0
FAST | SET16 | 093300800750008201 | 42.4 | 1000 | 43369 | 0.0424 | 0 | in 200's
SAVILL | SET16 |  | 49.9 | 1000 | 40294 | 0.0499 | 0
MARTYN | SET16 | S08M08075Z | 59.3 | 1000 | 40303 | 0.0593 | 0
AIC-I | SET16 |  | 42.96 | 1000 | 41151 | 0.04296 | 0 | MOQ 20K. +6p BAGGED/LABELLED
BAPP | SET16 |  | 34.2 | 1000 | 41954 | 0.0342 | 0
GALAXY | SET16 | &MHS08 075,081 | 42.4 | 1000 | 43509 | 0.0424 | 1 | 1K MOQ
[NAME] | SET16 | HTSMET00800075Z | 48.9 | 1000 | 43983 | 0.0489
FOREM | SET17 | HSS53 | 4.05 | 100 |  | 0.0405 | 0
JATON | SET17 |  | 44 | 1000 | 40704 | 0.044 | 0
VAN-LI | SET17 | HSS53 | 37.2 | 1000 | 39114 | 0.0372 | 0
[NAME] | SET17 | HTSMET01000025Z | 31.4 | 1000 | 43983 | 0.0314 | 0
HIGH | SET17 | HTSMETO1000025Y | 41.8 | 1000 | 40704 | 0.0418 | 0
GALAXY | SET17 | &MHS10 025,081 | 37 | 1000 | 43880 | 0.037 | 0 | 10K MOQ
SAVILL | SET17 |  | 55 | 1000 | 40407 | 0.055 | 0
MARTYN | SET17 | S08M10025Z | 36.7 | 1000 | 40661 | 0.0367 | 0
ENGINE | SET17 |  | 32.4 | 1000 | 40345 | 0.0324 | 0
AIC-I | SET17 |  | 33.2 | 1000 | 41151 | 0.0332 | 0 | MOQ 20K. +6p BAGGED/LABELLED
BAPP | SET17 |  | 29.9 | 1000 | 41954 | 0.0299 | 0
BROWNS | SET17 |  | 35.6 | 1000 | 43251 | 0.0356 | 0
FAST | SET17 | 093301000250008201 | 32.7 | 1000 | 43971 | 0.0327 | 1 | in 200's