Spreadsheet: 875887d1722514420-automatically-expand-table-1-after-adding-data-to-table-2-testfile
Sheet: Table 2

Ontvangst | Debnr. | Monster nr. | Monster nummer Klant | Status | Monster naam | Test naam | Analyse | Resultaat | [NAME] | Minimum | Maximum | Richtwaarde | Facturatie code | Methode | Accreditatie | [NAME] | Kipnummer klant | Opmerkingen / extra omschrijving monster | Verwachte datum | Productcode klant | Inspectie Lot Nummer | Inspectie Punt | Lot/Batch nummer | Lot order nr. | Monster datum | Operation Nummer | [NAME] | Omschrijving herkomst | Spoed service | Producent | Productomschrijving | Monstername locatie | Monstername punt | [NAME] boot | Soort stal | [NAME] | [NAME] | Start datum THT-onderzoek | [NAME] verlader
26-7-2024 |  | M241 | [PHONE] |  | S ND | Vocht 80°C (vacuüm) | Vocht 80°C (vacuum) | 34 | g/kg
26-7-2024 |  | M241 | [PHONE] |  | S ND | Vocht 103°C (4 uur) | Vocht 103°C (4 uur) | 35 | g/kg
26-7-2024 |  | M241 | [PHONE] |  | S ND | Ruw eiwit (Kjeldahl) | Ruw eiwit (Kjeldahl, 6,25) | 504 | g/kg
26-7-2024 |  | M241 | [PHONE] |  | S ND | [NAME] | [NAME] | 17 | g/kg
26-7-2024 |  | M241 | [PHONE] |  | S ND | Ruwe celstof | [NAME] celstof (D) | 55 | g/kg
26-7-2024 |  | M241 | [PHONE] |  | S ND | Ruw as (550°C) | Ruw as (550°C) | 71 | g/kg
26-7-2024 |  | M241 | [PHONE] |  | S ND | Lysine | Lysine |  | g/kg
26-7-2024 |  | M241 | [PHONE] |  | S ND | Lysine beschikbaarheid | Lysine beschikbaarheid |  | %
26-7-2024 |  | M241 | [PHONE] |  | S ND | NDF (Neutral Detergent Fiber) | NDF (Neutral Detergent Fiber) |  | g/kg
26-7-2024 |  | M241 | [PHONE] |  | S ND | N-NDF (als ruw eiwit NDF) | N-NDF (als index) |  | %
26-7-2024 |  | M241 | [PHONE] |  | S ND | Aufrere (oplosbaarheid Cone) | Aufrere |  | %
26-7-2024 |  | M241 | [PHONE] |  | S ND | Aufrere (oplosbaarheid Cone) | Eiwit oplosbaar (Aufrere) |  | g/kg
26-7-2024 |  | M241 | [PHONE] |  | S ND | Vitro ileaal eiwit | Vitro ileaal eiwit |  | %
26-7-2024 |  | M241 | [PHONE] |  | S ND | Vitro ileaal eiwit | In vitro ileaal eiwit (6,25) |  | g/kg
24-7-2024 |  | M001 | [PHONE] |  | S A | Vocht 80°C (vacuüm) | Vocht 80°C (vacuum) | 26 | g/kg
24-7-2024 |  | M001 | [PHONE] |  | S A | Ruw eiwit (Kjeldahl) | Ruw eiwit (Kjeldahl, 6,25) | 509 | g/kg
24-7-2024 |  | M001 | [PHONE] |  | S A | Aufrere (oplosbaarheid Cone) | Aufrere |  | %
24-7-2024 |  | M002 | [PHONE] |  | S B | Vocht 80°C (vacuüm) | Vocht 80°C (vacuum) | 116 | g/kg
24-7-2024 |  | M002 | [PHONE] |  | S B | Ruw eiwit (Kjeldahl) | Ruw eiwit (Kjeldahl, 6,25) | 459 | g/kg
24-7-2024 |  | M002 | [PHONE] |  | S B | Aufrere (oplosbaarheid Cone) | Aufrere |  | %
24-7-2024 |  | M003 | [PHONE] |  | S C | Vocht 80°C (vacuüm) | Vocht 80°C (vacuum) | 29 | g/kg
24-7-2024 |  | M003 | [PHONE] |  | S C | Ruw eiwit (Kjeldahl) | Ruw eiwit (Kjeldahl, 6,25) | 507 | g/kg
24-7-2024 |  | M003 | [PHONE] |  | S C | Aufrere (oplosbaarheid Cone) | Aufrere |  | %
24-7-2024 |  | M004 | [PHONE] |  | S D | Vocht 80°C (vacuüm) | Vocht 80°C (vacuum) | 35 | g/kg
24-7-2024 |  | M004 | [PHONE] |  | S D | Ruw eiwit (Kjeldahl) | Ruw eiwit (Kjeldahl, 6,25) | 504 | g/kg
24-7-2024 |  | M004 | [PHONE] |  | S D | Aufrere (oplosbaarheid Cone) | Aufrere |  | %
24-7-2024 |  | M005 | 24-07-24_13:00_SojaEP |  | S E | Vocht 80°C (vacuüm) | Vocht 80°C (vacuum) | 38 | g/kg
24-7-2024 |  | M005 | 24-07-24_13:00_SojaEP |  | S E | Ruw eiwit (Kjeldahl) | Ruw eiwit (Kjeldahl, 6,25) | 506 | g/kg
24-7-2024 |  | M005 | 24-07-24_13:00_SojaEP |  | S E | Aufrere (oplosbaarheid Cone) | Aufrere |  | %
17-7-2024 |  | M301 | [PHONE] |  | S A | Vocht 80°C (vacuüm) | Vocht 80°C (vacuum) | 28 | g/kg
17-7-2024 |  | M301 | [PHONE] |  | S A | Ruw eiwit (Kjeldahl) | Ruw eiwit (Kjeldahl, 6,25) | 503 | g/kg
17-7-2024 |  | M301 | [PHONE] |  | S A | Aufrere (oplosbaarheid Cone) | Aufrere | 77,1 | %
17-7-2024 |  | M302 | [PHONE] |  | S B | Vocht 80°C (vacuüm) | Vocht 80°C (vacuum) | 27 | g/kg
17-7-2024 |  | M302 | [PHONE] |  | S B | Ruw eiwit (Kjeldahl) | Ruw eiwit (Kjeldahl, 6,25) | 514 | g/kg
17-7-2024 |  | M302 | [PHONE] |  | S B | Aufrere (oplosbaarheid Cone) | Aufrere | 76,4 | %
17-7-2024 |  | M303 | [PHONE] |  | S C | Vocht 80°C (vacuüm) | Vocht 80°C (vacuum) | 25 | g/kg
17-7-2024 |  | M303 | [PHONE] |  | S C | Ruw eiwit (Kjeldahl) | Ruw eiwit (Kjeldahl, 6,25) | 498 | g/kg
17-7-2024 |  | M303 | [PHONE] |  | S C | Aufrere (oplosbaarheid Cone) | Aufrere | 76,1 | %
17-7-2024 |  | M304 | [PHONE] |  | S D | Vocht 80°C (vacuüm) | Vocht 80°C (vacuum) | 26 | g/kg
17-7-2024 |  | M304 | [PHONE] |  | S D | Ruw eiwit (Kjeldahl) | Ruw eiwit (Kjeldahl, 6,25) | 502 | g/kg
17-7-2024 |  | M304 | [PHONE] |  | S D | Aufrere (oplosbaarheid Cone) | Aufrere | 75,9 | %
If the testdata below is coppied to A43 and table 2 expands I want to automatically expand table 1 as well
Test data to add
17-7-2024 |  | Test | 00081999 |  | S D | Vocht 80°C (vacuüm) | Vocht 80°C (vacuum) | 5 | g/kg
17-7-2024 |  | Test | 00081999 |  | S D | Ruw eiwit (Kjeldahl) | Ruw eiwit (Kjeldahl, 6,25) | 50 | g/kg
17-7-2024 |  | Test | 00081999 |  | S D | Aufrere (oplosbaarheid Cone) | Aufrere | 500 | %