Spreadsheet: 753840d1635782697-if-all-values-in-array-meet-the-criteria-than-output-something-answers-
Sheet: Tanneries

Company Name | Audit | Country | Location | First Name | Second Name | Status | Date of Audit | Final Report Sent | Next Audit Due | Contr.No | Auditor | Contract Invoice total | Contract invoice Paid | Rating | Traceability Document
Leather [NAME] | 1 | Mexico | [NAME] | Bernardo | Sanz | LAPSED | 2019-05-16 00:00:00 | 2019-05-31 00:00:00 | 2020-05-16 00:00:00 | 04-06-013 | ML | 290.8 | No | Audited | 55.3
Leatherocity | 1 | Argentina | Santa Fe | [NAME] | Dorset | LAPSED | 2019-05-17 00:00:00 | 2019-06-24 00:00:00 | 2020-05-17 00:00:00 | 04-06-021 | ML | 292.6 | Paid | Audited | 42.1
Leather [NAME] | 5 | USA | Rockford | Stephen | Smith | Complete | 2019-05-20 00:00:00 | 2019-05-28 00:00:00 | 2020-05-20 00:00:00 | 04-05-007 | SB | 294.4 | Paid | Gold | 76.8
Leather Chard | 1 | USA | Hartland | [NAME] | [NAME] | Complete | 2019-05-31 00:00:00 | 2019-06-18 00:00:00 | 2020-05-31 00:00:00 | 07-08-017 | ML | 296.2 | Paid | Audited | 50.7
Leather [NAME] | 2 | China | Wenzhou | [NAME] | Sing | Complete | 2019-06-18 00:00:00 | 2019-07-08 00:00:00 | 2020-06-18 00:00:00 | 06-07-011 | CBW | 298 | Paid | Gold | 81.2
Leather Symbol | 1 | China | Jiangmen | [NAME] | Smith | Complete | 2019-09-17 00:00:00 | 2019-11-12 00:00:00 | 2020-09-17 00:00:00 | 06-07-015 | CBW | 299.8 | No | Audited | 70
Leather Majestic | 3 | China | Huizhou | Nikki | [NAME] | Complete | 2018-05-02 00:00:00 | 2018-08-31 00:00:00 | 2021-05-14 00:00:00 | 04-05-007 | CBW | 301.6 | Paid | Fail | 75.9
Leather Tenor | 1 | Dom Rep | Santiago | Manuel | Martin | Complete | 2019-04-16 00:00:00 | 2019-05-16 00:00:00 | 2020-04-16 00:00:00 | 06-07-028 | SB | 303.4 | Paid | Audited | 57.3
Leatheronus | 1 | Thailand | Samutprakarn | [NAME] | Song | Complete | 2019-05-23 00:00:00 | 2019-06-11 00:00:00 | 2020-06-23 00:00:00 | 06-07-033 | CBW | 305.2 | Paid | Audited | 42
Leather [NAME] | 2 | Dom Rep | Santiago | [NAME] | Almada | Complete | 2018-02-27 00:00:00 | 2018-03-26 00:00:00 | 2021-01-20 00:00:00 | 06-07-029 | SB | 307 | Paid | Audited | 52.6
Leather Rover | 1 | USA | Berwick | Conrad | Writh | Complete | 2019-06-18 00:00:00 | 2019-07-08 00:00:00 | 2020-06-18 00:00:00 | 06-07-044 | ML | 308.8 | Paid | Gold | 61.9
Leather Mink | 5 | UK | Leeds | [NAME] | Husen | Complete | 2019-03-18 00:00:00 | 2019-04-08 00:00:00 | 2022-03-18 00:00:00 | 06-07-032 | ML | 310.6 | No | Audited | 60.1
Leather Anti | 1 | Italy | Ponte a Cappiano | [NAME] | Baorne | Complete | 2019-05-09 00:00:00 | 2019-06-17 00:00:00 | 2020-05-09 00:00:00 | 06-07-041 | SB | 312.4 | Paid | Audited | 76.2
Leather Plush | 1 | Tapei | [NAME] | Ming | [NAME] | Complete | 2018-05-14 00:00:00 | 2018-07-06 00:00:00 | 2021-05-14 00:00:00 | 06-07-014 | CBW | 314.2 | Paid | Audited | 72
Leatherya | 4 | Mexico | [NAME] | [NAME] | Lares | LAPSED | 2018-02-05 00:00:00 | 2018-03-06 00:00:00 | 2021-02-05 00:00:00 | 06-07-040 | ML | 316 | Paid | Audited | 55
Leathercog | 1 | Taiwan | [NAME] | Shaun | Hosen | LAPSED | 2018-04-02 00:00:00 | 2018-05-06 00:00:00 | 2020-04-02 00:00:00 | 06-07-024 | CBW | 317.8 | Paid | Gold | 45.2
Leatheristic | 2 | Taiwan | Tainan Hsien | [NAME] | Wing | LAPSED | 2018-02-21 00:00:00 | 2018-03-13 00:00:00 | 2021-02-21 00:00:00 | 06-07-057 | CBW | 319.6 | No | Audited | 45
Leather Wanderlust | 1 | USA | Chicago | [NAME] | Caper | LAPSED | 2019-08-23 00:00:00 | 2019-09-05 00:00:00 | 2020-09-15 00:00:00 | 06-07-049 | SB | 321.4 | Paid | Audited | 49.6
Leather Dynasty | 3 | Brazil | Aguai | [NAME] | Ning | Complete | 2019-08-21 00:00:00 | 2019-09-12 00:00:00 | 2020-08-21 00:00:00 | 06-07-016 | SB | 323.2 | Paid | Audited | 58.2
Leather [NAME] | 1 | Thailand | Sena | [NAME] | Porter | LAPSED | 2020-09-10 00:00:00 | 2020-09-22 00:00:00 | 2022-09-10 00:00:00 | 07-08-001 | CBW | 325 | Paid | Gold | 89.5
Leather Cover | 5 | Indonesia | Bekasi | Seoung | Win | Complete | 2019-10-04 00:00:00 | 2019-11-01 00:00:00 | 2020-10-17 00:00:00 | 07-08-077 | CBW | 326.8 | Paid | Fail | 38.2
Leather [NAME] | 1 | Taiwan | [NAME] | [NAME] | Kipper | Complete | 2019-11-25 00:00:00 | 2019-12-23 00:00:00 | 2021-04-30 00:00:00 | 06-07-048 | CBW | 328.6 | Paid | Silver | 79.4
Leather [NAME] | 4 | China | Dongguan | [NAME] | Parter | Complete | 2019-09-24 00:00:00 | 2019-11-01 00:00:00 | 2020-09-24 00:00:00 | 06-07-056 | CBW | 330.4 | Paid | Silver | 83.8
Leather Uniform | 1 | China | Guangzhou | [NAME] | Langley | LAPSED | 2020-03-05 00:00:00 | 2020-06-30 00:00:00 | 2022-03-05 00:00:00 | 06-07-060 | CBW | 332.2 | No | Silver | 87.4
Leatherwind | 6 | China | [NAME] | Ian | Walker | LAPSED | 2019-08-17 00:00:00 | 2019-09-09 00:00:00 | 2020-08-17 00:00:00 | 07-08-011 | CBW | 248.3 | Paid | Audited | 49.8
Leatherhut | 1 | China | Huizhou | Larson | Morgan | LAPSED | 2019-05-25 00:00:00 | 2019-06-26 00:00:00 | 2020-05-25 00:00:00 | 06-07-058 | CBW | 257.8 | Paid | Audited | 64.7
Leather Bling | 5 | China | Dongguan | Maria | Thompson | LAPSED | 2019-09-04 00:00:00 | 2019-09-19 00:00:00 | 2020-09-04 00:00:00 | 06-07-025 | CBW | 275.4 | Paid | Audited | 58.5
Leather Icon | 1 | China | Jiangmen | [NAME] | Parker | LAPSED | 2018-02-25 00:00:00 | 2018-04-11 00:00:00 | 2020-02-25 00:00:00 | 07-08-007 | CBW | 287.6 | Paid | Audited | 53.5
Leather [NAME] | 2 | USA | [NAME] | [NAME] | Ling | LAPSED | 2017-06-20 00:00:00 | 2017-07-25 00:00:00 | 2018-11-27 00:00:00 | 07-08-017 | ML | 301.15 | Paid | Silver | 79.3
Leather Swag | 3 | China | Qingdao | [NAME] | [NAME] | LAPSED | 2018-10-23 00:00:00 | 2018-11-21 00:00:00 | 2021-10-23 00:00:00 | 06-07-026 | CBW | 314.7 | Paid | [NAME] | 71.2
Leather Flair | 4 | China | [NAME] | [NAME] | Lint | Complete | 2020-10-05 00:00:00 | 2020-11-16 00:00:00 | 2021-10-05 00:00:00 | 07-08-019 | CBW | 328.25 | Paid | Silver | 84
Leather Style | 1 | India | [NAME] | [NAME] | [NAME] | LAPSED | 2019-04-24 00:00:00 | 2019-05-23 00:00:00 | 2022-04-24 00:00:00 | 07-08-009 | SB | 341.8 | Paid | Silver | 77.2
Leather Cub | 1 | Korea | Gyongnam | [NAME] | Harper | Complete | 2020-10-29 00:00:00 | 2020-11-16 00:00:00 | 2022-10-29 00:00:00 | 07-08-047 | CBW | 355.35 | Paid | Audited | 56.3
Leather Happening | 1 | Korea | Busan | [NAME] | Temple | Complete | 2018-10-15 00:00:00 | 2018-11-08 00:00:00 | 2021-10-15 00:00:00 | 07-08-040 | CBW | 368.9 | Paid | Audited | 64.4
Leatherx | 1 | China | [NAME] | [NAME] | Log | LAPSED | 2018-05-17 00:00:00 | 2018-06-05 00:00:00 | 2021-05-17 00:00:00 | 06-07-020 | CBW | 382.45 | Paid | Silver | 78.4
Leather [NAME] | 1 | Slovenija | Vrhnika | Greg | Morgan | Complete | 2019-10-29 00:00:00 | 2019-11-28 00:00:00 | 2020-11-12 00:00:00 | 07-08-035 | ML | 396 | Paid | Silver | 75.2
Leather [NAME] | 1 | Vietnam | Nhon Trach | [NAME] | Otto | Complete | 2019-10-25 00:00:00 | 2019-09-19 00:00:00 | 2020-10-25 00:00:00 | 07-08-005 | CBW | 214.6 | Paid | [NAME] | 78.3
Leatherooze | 1 | Vietnam | [NAME] | [NAME] | Clarkson | Complete | 2019-04-26 00:00:00 | 2019-08-12 00:00:00 | 2020-04-12 00:00:00 | 07-08-014 | CBW | 267.8 | Paid | [NAME] | 79.1
Leather Affinity | 1 | China | Dongguan | [NAME] | Temp | Complete | 2020-01-26 00:00:00 | 2020-01-18 00:00:00 | 2022-04-07 00:00:00 | 07-08-013 | CBW | 282.4125 | Paid | Silver | 83.2
Leather [NAME] | 1 | Korea | Busan | [NAME] | Sanj | LAPSED | 2019-10-31 00:00:00 | 2019-12-04 00:00:00 | 2020-10-31 00:00:00 | 07-08-052 | CBW | 271.4167 | No | [NAME] | 72.9
Leather Emerald | 1 | Korea | Seoul | Adam | White | LAPSED | 2019-03-15 00:00:00 | 2019-03-22 00:00:00 | 2020-03-15 00:00:00 | 07-08-048 | CBW | 260.4208 | No | Audited | 58.1
Leather Duke | 1 | Korea | Seoul | [NAME] | Martin | Complete | 2019-10-11 00:00:00 | 2019-11-21 00:00:00 | 2020-10-08 00:00:00 | 07-08-049 | CBW | 249.425 | Paid | Audited | 47.9
Leather Body | 1 | Thailand | Sena | [NAME] | Barlow | LAPSED | 2019-10-04 00:00:00 | 2019-11-01 00:00:00 | 2020-10-04 00:00:00 | 07-08-044 | SB | 238.4292 | No | Audited | 52.6
Leather [NAME] | 2 | USA | Hartland | [NAME] | Walker | LAPSED | 2019-11-04 00:00:00 | 2019-11-28 00:00:00 | 2020-11-04 00:00:00 | 07-08-018 | ML | 227.4333 | Paid | Silver | 77.8
Leather Fathom | 1 | Vietnam | [NAME] | [NAME] | [NAME] | Complete | 2019-12-12 00:00:00 | 2020-01-20 00:00:00 | 2020-11-15 00:00:00 | 07-08-027 | ML | 216.4375 | Paid | Gold | 85.4
Leather Vail | 1 | Korea | Seoul | [NAME] | Parker | LAPSED | 2019-11-04 00:00:00 | 2019-11-19 00:00:00 | 2020-11-04 00:00:00 | 07-08-065 | CBW | 205.4417 | No | [NAME] | 79.5
Leather [NAME] | 1 | India | Chennai | [NAME] | [NAME] | LAPSED | 2019-11-05 00:00:00 | 2019-12-03 00:00:00 | 2020-11-05 00:00:00 | 07-08-058 | SB | 194.4458 | Paid | Audited | 67.2
Leatheradil | 1 | India | Chennai | Amanda | Smith | LAPSED | 2018-09-20 00:00:00 | 2018-10-17 00:00:00 | 2021-09-29 00:00:00 | 07-08-054 | SB | 183.45 | Paid | [NAME] | 66.4
Leather Insignia | 1 | USA | Cactus | [NAME] | Logan | Complete | 2018-06-21 00:00:00 | 2018-07-16 00:00:00 | 2021-06-21 00:00:00 | 07-08-070 | ML | 172.4542 | Paid | Silver | 87.5
Leather Sway | 1 | Vietnam | Nhon Trach | Vincent | Bell | Complete | 2019-08-15 00:00:00 | 2019-08-19 00:00:00 | 2020-08-05 00:00:00 | 07-08-046 | CBW | 161.4583 | Paid | Audited | 68.4
Leather Topic | 1 | Vietnam | [NAME] | [NAME] | Green | Complete | 2019-08-16 00:00:00 | 2019-08-20 00:00:00 | 2020-08-06 00:00:00 | 07-08-069 | CBW | 150.4625 | Paid | Silver | 77.2