{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Beurteilungsnachweis","Liste Abfallersterzeuger","Probenahmeplan","Probenahmeprotokoll","Analysenergebnisse","Berechnung d. Beurteilungswerte","Einhaltung der Grenzwerte","Info zur Benutzung des Makros","Tabelle1","Format","RECHNEN","AUTO"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":20,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Beurteilungsnachweis","index":0,"n_rows":188,"n_cols":29,"rows_kept":188,"cut":false,"hidden":false,"merged":[[7,12,7,13],[7,26,7,27],[8,12,8,13],[8,26,8,27],[14,0,14,13],[14,14,14,27],[22,4,22,6],[22,18,22,20],[23,4,23,13],[23,18,23,27],[31,4,31,13],[31,18,31,27],[32,4,32,13],[32,18,32,27],[33,4,33,9],[33,18,33,23],[35,9,35,13],[18,1,18,13],[18,15,18,27],[30,4,30,13],[30,18,30,27],[24,4,24,13],[24,18,24,27],[50,4,50,13],[50,18,50,27],[36,4,36,13],[36,18,36,27],[37,4,37,13],[37,18,37,27],[41,0,41,13],[41,14,41,27],[34,4,34,9],[34,18,34,23],[35,4,35,8],[35,18,35,22],[35,24,35,27],[61,4,61,9],[61,18,61,23],[26,10,26,11],[26,24,26,25],[58,4,58,13],[58,18,58,27],[25,28,25,34],[68,4,68,13],[68,18,68,27],[51,4,51,9],[51,18,51,23],[52,4,52,9],[52,18,52,23],[53,4,53,13],[53,18,53,27],[59,4,59,13],[59,18,59,27],[60,4,60,9],[60,18,60,23],[46,28,47,34],[48,4,48,13],[48,18,48,27],[49,4,49,13],[49,18,49,27],[69,4,69,13],[69,18,69,27],[70,4,70,9],[70,18,70,23],[62,4,62,9],[62,18,62,23],[63,4,63,13],[63,18,63,27],[67,4,67,13],[67,18,67,27],[74,4,74,13],[74,18,74,27],[75,4,75,13],[75,18,75,27],[79,4,79,13],[79,18,79,27],[71,4,71,9],[71,18,71,23],[72,4,72,13],[72,18,72,27],[73,4,73,13],[73,18,73,27],[83,4,83,9],[83,18,83,23],[84,4,84,13],[84,18,84,27],[87,4,87,13],[87,18,87,27],[80,4,80,13],[80,18,80,27],[81,4,81,9],[81,18,81,23],[82,4,82,9],[82,18,82,23],[91,4,91,9],[91,18,91,23],[88,4,88,13],[88,18,88,27],[89,4,89,13],[89,18,89,27],[90,4,90,9],[90,18,90,23],[97,4,97,9],[97,18,97,23],[98,4,98,13],[98,18,98,27],[93,28,94,34],[95,4,95,13],[95,18,95,27],[95,28,96,34],[96,4,96,9],[96,18,96,23],[106,4,106,13],[106,18,106,27],[108,4,108,13],[108,18,108,27],[109,5,109,13],[109,19,109,27],[99,4,99,13],[99,18,99,27],[103,4,103,13],[103,18,103,27],[104,18,104,27],[105,4,105,13],[105,18,105,27],[117,4,117,13],[117,18,117,27],[120,6,120,13],[120,20,120,27],[125,4,125,13],[125,18,125,27],[110,4,110,13],[110,18,110,27],[111,28,114,34],[112,4,112,13],[112,18,112,27],[113,4,113,13],[113,18,113,27],[114,4,114,13],[114,18,114,27],[136,0,136,13],[136,14,136,27],[143,0,143,13],[143,14,143,27],[145,0,145,13],[145,14,145,27],[130,10,130,11],[130,24,130,25],[131,10,131,11],[131,24,131,25],[175,1,175,5],[175,11,175,13],[175,15,175,19],[175,25,175,27],[160,0,160,13],[160,14,160,27],[164,0,164,13],[164,14,164,27],[151,0,151,13],[151,14,151,27],[152,0,152,13],[152,14,152,27],[156,0,156,13],[156,14,156,27]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hier ist Platz für das Firmenlogo, einen Briefkopf oder dergleichen."]
[]
[]
[]
[]
[]
["Ergeht an:",null,null,null,null,null,null,null,null,null,null,"Datum:",null,null,"Ergeht an:",null,null,null,null,null,null,null,null,null,null,"Datum:","2024-01-01",null,"Ausstellungsdatum"]
["Bundesministerium für Klimaschutz, Umwelt, Energie, ",null,null,null,null,null,null,null,null,null,null,"Gültig bis:",null,null,"Bundesministerium für Klimaschutz, Umwelt, Energie, ",null,null,null,null,null,null,null,null,null,null,"Gültig bis:","2025-01-01",null,"Gültigkeit für diesen Beurteilungsnachweis"]
["Mobilität, Innovation und Technologie",null,null,null,null,null,null,null,null,null,null,null,null,null,"Mobilität, Innovation und Technologie"]
["Abteilung V/3",null,null,null,null,null,null,null,null,null,null,null,null,null,"Abteilung VI/3",null,55]
["Stubenbastei 5",null,null,null,null,null,null,null,null,null,null,null,null,null,"Stubenbastei 5"]
["1010 Wien",null,null,null,null,null,null,null,null,null,null,null,null,null,"1010 Wien"]
[]
["Beurteilungsnachweis für ein Ersatzbrennstoffprodukt aus Holzabfällen\ngem. Abfallverbrennungsverordnung 2024",null,null,null,null,null,null,null,null,null,null,null,null,null,"Beurteilungsnachweis für ein Ersatzbrennstoffprodukt aus Holzabfällen\ngem. Abfallverbrennungsverordnung 2024"]
[]
[]
["Kennung:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kennung:","1234567890123-9999-2024",null,null,null,null,null,null,null,null,null,null,null,null,"Kann z.B. bestehen aus: GLN des Erstellers_fortlaufende Nummer_Jahresangabe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z.B. Untersuchung der Fraktion XY aus dem Prozess … ",null,null,null,null,null,null,null,null,null,null,null,null,"Kennung kann z.B. auch in die Fußzeile kopiert werden."]
["Kennungen vorangegangener Beurteilungsnachweise dieses Ersatzbrennstoffproduktes:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kennungen vorangegangener Beurteilungsnachweise dieses Ersatzbrennstoffproduktes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1234567890123-9947-2022, 1234567890123-9923-2023",null,null,null,null,null,null,null,null,null,null,null,null,"Bei Strömen sind hier die Kennungne der bereits erstellten Beurteilungsnachweise anzugeben."]
["Abfallart gemäß Anhang 1 Abfallverzeichnisverordnung 2020 idgF",null,null,null,null,null,null,null,null,null,null,null,null,null,"Abfallart gemäß Anhang 1 Abfallverzeichnisverordnung 2020 idgF"]
[null,"Abfallart:",null,null,null,null,null,null,"Spezifizierung:",null,null,null,null,null,null,"Abfallart:",null,null,91108,null,null,null,"Spezifizierung:",null,null,null,null,null,"Angaben gemäß Anlage 5 Abfallverzeichnisverordnung idgF"]
[null,"Bezeichnung:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bezeichnung:",null,null,"Ersatzbrennstoffe, qualitätsgesichert"]
[null,"Spezifizierung (in Worten):",null,null,null,null,null,null,null,null,null,null,null,null,null,"Spezifizierung (in Worten):"]
["Gesamtmenge d. Ersatzbrennstoffprodukts bzw. voraussichtliche jährliche Menge:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gesamtmenge d. Ersatzbrennstoffprodukts bzw. voraussichtliche jährliche Menge:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bei Einzelchargen ist hier die Gesamtmenge einzutragen, bei Abfallströmen die voraussichtlich jährliche Menge."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"t",null,null,null,null,null,null,null,null,null,null,null,null,null,"t"]
[]
["Angaben zum Unternehmen, welches den Beurteilungsnachweis ERSTELLT",null,null,null,null,null,null,null,null,null,null,null,null,null,"Angaben zum Unternehmen, welches den Beurteilungsnachweis ERSTELLT"]
[]
[null,"Firmenname:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Firmenname:",null,null,"Verwertungs Ges.m.b.H"]
[null,"Personen GLN:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Personen GLN:",null,null,9001544412332,null,null,null,null,null,null,null,null,null,"Für im EDM registrierte Personen/Firmen (13stellig)"]
[null,"Land:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Land:",null,null,"Österreich"]
[null,"Ort:",null,null,null,null,null,null,null,null,null,"Postleitzahl:",null,null,null,"Ort:",null,null,"Wien",null,null,null,null,null,null,"Postleitzahl:",null,1010]
[null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:",null,null,null,"Strasse:",null,null,"Stubenbastei",null,null,null,null,null,null,"Hausnummer:",null,"5/2/14"]
[null,"Telefon:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Telefon:"]
[null,"E-Mail:",null,null,null,null,null,null,null,null,null,null,null,null,null,"E-Mail:"]
[null,"Kontaktperson:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kontaktperson:",null,null,"[bzw. Kontaktperson für etwaige Fragen]"]
[]
["1. Allgemeines",null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Allgemeines"]
[]
["[Textfeld]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hier können Informationen bezüglich wer wurde wann von wem womit beauftragt enthalten sein. etc."]
[]
["2. Angaben zum Ersatzbrennstoffprodukt",null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Angaben zum Ersatzbrennstoffprodukt"]
[]
["2.1 Angaben zum Abfallbesitzer",null,null,null,null,null,null,null,null,null,null,null,null,null,"2.1 Angaben zum Abfallbesitzer"]
["Ident mit Ersteller",null,null,null,null,null,null,null,null,null,"Ja",null,null,null,"Ident mit oben angegebenen Ersteller:",null,null,null,null,null,null,null,null,null,"Ja",null,null,null,"Falls Ersteller und Abfallbesitzer ident, reicht hier das Anhaken der Checkbox und die restlichen Felder können gelöscht werden."]
["Falls nicht:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Falls nicht:"]
[null,"Firmenname:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Firmenname:",null,null,null,null,null,null,null,null,null,null,null,null,"Falls Ersteller und Abfallbesitzer nicht  ident, hier die Daten des Abfallbesitzers eintragen"]
[null,"Personen GLN:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Personen GLN:"]
[null,"Land:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Land:"]
[null,"Ort:",null,null,null,null,null,null,null,null,null,"Postleitzahl:",null,null,null,"Ort:",null,null,null,null,null,null,null,null,null,"Postleitzahl:"]
[null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:",null,null,null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:"]
[null,"Kontaktperson:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kontaktperson:",null,null,"[bzw. Kontaktperson für etwaige Fragen]"]
[]
[]
["2.2 Angaben zum Abfallerzeuger (Anfallsort)",null,null,null,null,null,null,null,null,null,null,null,null,null,"2.2 Angaben zum Abfallerzeuger (Anfallsort)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Beispiel für einen Abfallerzeuger: Wird in einer MBA-Anlage Abfall behandelt, der danach noch von einer anderen Firma einer Ersatzbrennstoffaufbereitung unterzogen wird, so gilt als Abfallerzeuger der Betreiber der Ersatzbrennstoffaufbereitung. (siehe auch Definitionen im AWG)"]
["Abfallerzeuger ident mit Abfallbesitzer",null,null,null,null,null,null,null,null,null,null,null,null,"Ja","Abfallerzeuger ident mit Abfallbesitzer",null,null,null,null,null,null,null,null,null,null,null,null,"Ja","Falls Abfallerzeuger und Abfallbesitzer ident, reicht hier das Anhaken der Checkbox"]
[null,"Firmenname:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Firmenname:"]
[null,"Personen GLN:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Personen GLN:"]
[null,"Land:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Land:"]
[null,"Ort:",null,null,null,null,null,null,null,null,null,"Postleitzahl:",null,null,null,"Ort:",null,null,null,null,null,null,null,null,null,"Postleitzahl:"]
[null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:",null,null,null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:"]
[null,"Kontaktperson:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kontaktperson:",null,null,"[bzw. Kontaktperson für etwaige Fragen]"]
[]
["Angaben zum Standort an dem das Ersatzbrennstoffprodukt anfällt",null,null,null,null,null,null,null,null,null,null,null,null,null,"Angaben zum Standort an dem der Ersatzbrennstoffprodukt anfällt"]
[null,null,null,null,null,null,null,null,"ident mit obiger Adresse",null,null,null,null,"Ja",null,null,null,null,null,null,null,null,"ident mit obiger Adresse",null,null,null,null,"Ja","Falls sich der Standort an obiger Adresse befindet, kann die Checkbox angehakt werden."]
[null,"Name d. Standortes:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name d. Standortes:",null,null,"z.B: Anlage Altenberg"]
[null,"Standort-GLN:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Standort-GLN:",null,null,9000122222223,null,null,null,null,null,null,null,null,null,"Für im EDM registrierte Standorte (13stellig)"]
[null,"Land:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Land:"]
[null,"Ort:",null,null,null,null,null,null,null,null,null,"Postleitzahl:",null,null,null,"Ort:",null,null,null,null,null,null,null,null,null,"Postleitzahl:"]
[null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:",null,null,null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:"]
[null,"Name der Anlage:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name der Anlage:"]
[null,"Anlagen-GLN:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Anlagen-GLN:",null,null,null,null,null,null,null,null,null,null,null,null,"Für im EDM registrierte Anlagen (13stellig)"]
[null,"Name des Anlagenteils:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name des Anlagenteils:"]
[null,"GLN des Anlagenteils:",null,null,null,null,null,null,null,null,null,null,null,null,null,"GLN des Anlagenteils:",null,null,null,null,null,null,null,null,null,null,null,null,"Für im EDM registrierte Anlagenteile (13stellig)"]
[]
["2.3 Angaben zum Abfallersterzeuger (Alternativ ist eine Auflistung im Anhang möglich)",null,null,null,null,null,null,null,null,null,null,null,null,null,"2.3 Angaben zum Abfallersterzeuger (Alternativ ist eine Auflistung im Anhang möglich)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Beispiel für einen Abfallersterzeuger: Fällt bei einer Produktionsanlage auch Abfall an, der noch von einer anderen Firma einer Ersatzbrennstoffaufbereitung unterzogen wird, so gilt als Abfallerzeuger der Betreiber der Produktionsanlage. (siehe auch Definitionen im AWG)"]
["Abfallersterzeuger ident mit Abfallerzeuger",null,null,null,null,null,null,null,null,null,null,null,null,"Ja","Abfallersterzeuger ident mit Abfallerzeuger",null,null,null,null,null,null,null,null,null,null,null,null,"Ja","Falls Abfallerzeuger und Abfallersterzeuger ident sind, reicht hier das Anhaken der Checkbox"]
[null,"Firmenname:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Firmenname:",null,null,null,null,null,null,null,null,null,null,null,null,"Alternativ kann hier direkt auf die Liste der Abfallersterzeuger verwiesen werden! "]
[null,"Personen GLN:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Personen GLN:"]
[null,"Land:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Land:"]
[null,"Ort:",null,null,null,null,null,null,null,null,null,"Postleitzahl:",null,null,null,"Ort:",null,null,null,null,null,null,null,null,null,"Postleitzahl:"]
[null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:",null,null,null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:"]
[null,"Kontaktperson:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kontaktperson:",null,null,"[bzw. Kontaktperson für etwaige Fragen]"]
[]
["Angaben zum Standort des Abfallersterzeugers",null,null,null,null,null,null,null,"ident mit obiger Adresse",null,null,null,null,"Ja","Angaben zum Standort des Abfallersterzeugers",null,null,null,null,null,null,null,"ident mit obiger Adresse",null,null,null,null,"Ja","Falls sich der Standort an obiger Adresse befindet, kann die Checkbox angehakt werden"]
[null,"Name d. Standortes:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name d. Standortes:",null,null,"z.B: Anlage Altenberg"]
[null,"Standort-GLN:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Standort-GLN:",null,null,9000122222223,null,null,null,null,null,null,null,null,null,"Für im EDM registrierte Standorte/Anlagen (13stellig)"]
[null,"Land:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Land:"]
[null,"Ort:",null,null,null,null,null,null,null,null,null,"Postleitzahl:",null,null,null,"Ort:",null,null,null,null,null,null,null,null,null,"Postleitzahl:"]
[null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:",null,null,null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:"]
[]
["2.4 Herkunft gem. Abfallbilanzverordnung, BGBl. II Nr. 497/2008",null,null,null,null,null,null,null,null,null,null,null,null,null,"2.4 Herkunft gem. Abfallbilanzverordnung, BGBl. II Nr. 497/2008",null,null,null,null,null,null,null,null,null,null,null,null,null,"Falls der Herkunftsort ident ist mit der angegebenen Adresse des Anfallsortes, reicht hier das Anhaken der Checkbox."]
["Ident mit Anfallsort:",null,null,null,null,null,null,null,null,null,"Ja",null,null,null,"Ident mit Anfallsort:",null,null,null,null,null,null,null,null,null,"Ja"]
[null,"Land:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Land:",null,null,null,null,null,null,null,null,null,null,null,null,"Als Herkunft gilt im Regelfall der Absendeort des Übergebers. Weitere Details siehe Abfallbilanzverordnung und die diesbezüglichen Erläuterungen."]
[null,"Ort:",null,null,null,null,null,null,null,null,null,"Postleitzahl:",null,null,null,"Ort:",null,null,null,null,null,null,null,null,null,"Postleitzahl:"]
[null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:",null,null,null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:"]
[null,"Standort-GLN:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Standort-GLN:",null,null,"9000122222223",null,null,null,null,null,null,null,null,null,"Für im EDM registrierte Standorte (13stellig)"]
[null,"Name des Standortes:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Name des Standortes:",null,null,"Anlage Altenberg"]
[]
["2.5 Entstehung des Ersatzbrennstoffproduktes",null,null,null,null,null,null,null,null,null,null,null,null,null,"2.5 Entstehung des Ersatzbrennstoffproduktes"]
["Beschreibung der Entstehung des Ersatzbrennstoffproduktes und allfällige Behandlungsschritte:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Beschreibung der Entstehung des Ersatzbrennstoffproduktes und allfällige Behandlungsschritte:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hier sollen die relevanten Schritte der Entstehung beschrieben"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"werden (z.B: Metallabscheidung, Vorzerkleinerung)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bzw. kann auch auf eine entsprechende Anlagenbeschreibung im "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anhang verwiesen werden."]
["Inputmaterialien des Prozesses, bei dem das Ersatzbrennstoffprodukt anfällt:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Inputmaterialien des Prozesses, bei dem das Ersatzbrennstoffprodukt anfällt:"]
[]
["Outputmaterialien der Behandlung:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Outputmaterialien der Behandlung:"]
[]
["Angabe einer allfälligen Kontamination und deren Ursache:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Angabe einer allfälligen Kontamination und deren Ursache:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Die Kontaminationsgruppen sind: Infektiöse Erreger, Mineralölhaltige Stoffe, Schwermetallhaltige Stoffe, Halogenhaltige Kohlenwasserstoffe, Halogenfreie Kohlenwasserstoffe, Sonstige anorganische gefährliche Stoffe, Sonstige organische gefährliche Stoffe."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"falls zutreffend, ist hier eine allfällige Kontamination zu beschreiben"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z.B: Verunreinigung mit PAK, Beschichtungen, Kontaminationsgruppe…"]
[]
[]
["2.6 Beschreibung des Ersatzbrennstoffproduktes",null,null,null,null,null,null,null,null,null,null,null,null,null,"2.6 Beschreibung des Ersatzbrennstoffproduktes"]
[null,"Farbe:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Farbe:",null,null,"z.B: braun"]
[]
[null,"Geruch:",null,null,"ohne",null,null,null,"schwach",null,null,"intensiv",null,null,null,"Geruch:",null,null,"ohne",null,null,null,"schwach",null,null,"intensiv"]
[null,null,null,null,"nach:",null,null,null,null,null,null,null,null,null,null,null,null,null,"nach:",null,"verbrannten Gummi"]
[]
[null,"Homogenität:",null,null,"homogen",null,null,null,null,"oder heterogen hinsichtlich",null,"Korngröße",null,null,null,"Homogenität:",null,null,"homogen",null,null,null,null,"oder heterogen hinsichtlich",null,"Korngröße",null,null,"Bei heterogenen Materialien können hier auch mehrere Kriterien angegeben werden."]
[null,null,null,null,null,null,null,null,null,null,null,"Farbe",null,null,null,null,null,null,null,null,null,null,null,null,null,"Farbe"]
[null,null,null,null,null,null,null,null,null,null,null,"Bestandteile",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bestandteile"]
["Anmerkung zur Homogenität:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Anmerkung zur Homogenität:",null,null,null,"Korngröße von 0.01 mm bis 100 mm je nach Bereich unterschiedlich"]
[]
[null,"Konsistenz:",null,null,"staubend / pulvrig",null,null,null,"fest - trocken",null,null,"fest - feucht",null,null,null,"Konsistenz:",null,null,"staubend / pulvrig",null,null,null,"fest - trocken",null,null,"fest - feucht"]
[]
[]
[null,"Schüttdichte:",null,null,null,null,null,null,null,null,null,null,null,"kg/m3",null,"Schüttdichte:",null,null,null,null,null,null,null,null,200,null,null,"kg/m3"]
["Korngröße (Größtkorn, 95% Perzentil):",null,null,null,null,null,null,null,null,null,null,null,null,"mm","Korngröße (Größtkorn, 95% Perzentil):",null,null,null,null,null,null,null,null,null,100,null,null,"mm","Es genügt eine Abschätzung."]
[]
["3. Probenahme",null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Probenahme"]
[]
["Allgemeines",null,null,null,null,null,null,null,null,null,null,null,null,null,"Allgemeines"]
["[Textfeld]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hier sind die wichtigen Informationen zur Probenahme wie z.B: welches Los beprobt wurde und wieviele qualifizierte Stichproben gezogen wurden zusammenzufassen."]
[]
["Probenahmeplan und Probenahmeprotokolle siehe Anhang X",null,null,null,null,null,null,null,null,null,null,null,null,null,"Probenahmeplan und Probenahmeprotokolle siehe Anhang X."]
[]
["4. Angaben zu den Untersuchungen",null,null,null,null,null,null,null,null,null,null,null,null,null,"4. Angaben zu den Untersuchungen"]
[]
["Allgemeines",null,null,null,null,null,null,null,null,null,null,null,null,null,"Allgemeines"]
["[Textfeld]",null,null,null,null,null,null,null,null,null,null,null,null,null,"z.B. Informationen über den Untersuchungszeitraum, Hinweis falls Labor akkreditiert ist, …"]
[]
["Die angewendeten Probenvorbereitungs-, Aufschluss-, und Analysenmethoden sind in Anhang X aufgelistet.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Die angewendeten Probenvorbereitungs-, Aufschluss-, und Analysenmethoden sind in Anhang X aufgelistet."]
[]
["Analysenergebnisse und Beurteilungswerte siehe Anhang X.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Analysenerg. und Beurteilungswerte siehe Anhang X."]
[]
["5. Beurteilung",null,null,null,null,null,null,null,null,null,null,null,null,null,"5. Beurteilung"]
[]
["Beurteilung des Ersatzbrennstoffproduktes hinsichtlich der Qualitätsanforderungen an Ersatzbrennstoffprodukte",null,null,null,null,null,null,null,null,null,null,null,null,null,"Beurteilung des Ersatzbrennstoffproduktes hinsichtlich der Qualitätsanforderungen an Ersatzbrennstoffprodukte"]
["[Textfeld]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hier ist nachfollziebar darzulegen, warum das Ersatzbrennstoffprodukt die Qualitätsanforderungen einhält."]
[]
["6. Vorgaben für die Untersuchung des nächsten Loses",null,null,null,null,null,null,null,null,null,null,null,null,null,"6. Vorgaben für die Untersuchung des nächsten Loses"]
[]
["[Textfeld]",null,null,null,null,null,null,null,null,null,null,null,null,null,"Auf grund der aktuellen Beurteilungswerte ergeben sich die Vorgaben für die Untersuchung des nächsten Loses."]
[]
["7. Bestätigungen",null,null,null,null,null,null,null,null,null,null,null,null,null,"7. Bestätigungen"]
[]
["Das Vermischungsverbot gemäß § 15 Abs. 2 AWG 2002 wird eingehalten.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Das Vermischungsverbot gemäß § 15 Abs. 2 AWG 2002 wird eingehalten."]
[]
["8. Angabe zur bestimmungsgemäßen Verwendung",null,null,null,null,null,null,null,null,null,null,null,null,null,"8. Angabe zur bestimmungsgemäßen Verwendung"]
[]
["Ersatzbrennstoffprodukte dürfen nur in Anlagen mit einer Nennwärmeleistung von ≥ 100 kW, die einen Staubgrenzwert in der Höhe von 20 mg/m3 (als Halbstundenmittelwert) einhalten, oder in Anlagen, die dem Geltungsbereich des § 2 Abs. 1 AVV unterliegen, verbrannt werden.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ersatzbrennstoffprodukte dürfen nur in Anlagen mit einer Nennwärmeleistung von ≥ 100 kW, die einen Staubgrenzwert in der Höhe von 20 mg/m3 (als Halbstundenmittelwert) einhalten, oder in Anlagen, die dem Geltungsbereich des § 2 Abs. 1 AVV unterliegen, verbrannt werden."]
[]
["9. Angabe der vorgesehenen Abnehmer",null,null,null,null,null,null,null,null,null,null,null,null,null,"9. Angabe der vorgesehenen Abnehmer"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Biomassekraftwerk, Industriestraße 10-13a, 1234 Musterdorf"]
[]
[]
[]
[]
[]
[]
["Unterschrift:",null,null,null,null,null,null,null,null,null,"Datum:",null,null,null,"Unterschrift:","(Ausdruck ist zu unterschreiben)",null,null,null,null,null,null,null,null,"Datum:"]
[]
[]
[]
[]
["Liste der Anhänge",null,null,null,null,null,null,null,null,null,null,null,null,null,"Liste der Anhänge"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl der Seiten",null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl der Seiten"]
["Anhang","A",null,null,null,null,null,null,null,null,null,null,null,null,"Anhang","A","Fotodokumentation",null,null,null,null,null,null,null,null,null,null,3]
["Anhang","B",null,null,null,null,null,null,null,null,null,null,null,null,"Anhang","B","Probenvorbereitungs-, Aufschluss-, und Analysenmethoden",null,null,null,null,null,null,null,null,null,null,1]
["Anhang","C",null,null,null,null,null,null,null,null,null,null,null,null,"Anhang","C","Analysenergebnisse und Beurteilungswerte",null,null,null,null,null,null,null,null,null,null,10]
["Anhang","D",null,null,null,null,null,null,null,null,null,null,null,null,"Anhang","D","Probenahmeplan und Protokoll",null,null,null,null,null,null,null,null,null,null,5]
["Anhang","E",null,null,null,null,null,null,null,null,null,null,null,null,"Anhang","…","….."]
["Anhang","…",null,null,null,null,null,null,null,null,null,null,null,null,"Anhang","…","….."]

{"sheet":"Liste Abfallersterzeuger","index":1,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Abfallersterzeuger","Standort","Abfallersterzeuger","Standort"]
[null,null,"Altenberger GmbH","Anlage Altenberg; A-2020 Altenberg; Industriestraße 5 "]

{"sheet":"Probenahmeplan","index":2,"n_rows":90,"n_cols":38,"rows_kept":90,"cut":false,"hidden":false,"merged":[[2,4,2,14],[2,19,2,29],[3,4,3,14],[3,19,3,29],[4,4,4,14],[4,19,4,29],[7,4,7,10],[7,13,7,14],[7,19,7,25],[7,28,7,29],[8,4,8,8],[8,11,8,14],[8,19,8,23],[8,26,8,29],[5,4,5,14],[5,19,5,29],[6,4,6,10],[6,13,6,14],[6,19,6,25],[6,28,6,29],[11,4,11,14],[11,19,11,29],[13,4,13,14],[13,19,13,29],[14,4,14,14],[14,19,14,29],[9,4,9,8],[9,11,9,14],[9,19,9,23],[9,26,9,29],[10,4,10,8],[10,11,10,14],[10,19,10,23],[10,26,10,29],[17,4,17,8],[17,11,17,14],[17,19,17,23],[17,26,17,29],[18,4,18,14],[18,19,18,29],[15,4,15,10],[15,13,15,14],[15,19,15,25],[15,28,15,29],[16,4,16,10],[16,11,16,12],[16,13,16,14],[16,19,16,25],[16,26,16,27],[16,28,16,29],[26,30,28,36],[27,4,27,7],[27,19,27,22],[28,4,28,14],[28,19,28,29],[29,4,29,14],[29,19,29,29],[29,30,30,36],[24,23,24,29],[26,4,26,7],[26,11,26,13],[26,19,26,22],[26,26,26,28],[41,0,41,14],[41,15,41,29],[42,0,42,14],[42,15,42,29],[42,30,43,36],[44,30,45,36],[31,30,33,36],[34,4,34,14],[34,19,34,29],[34,30,35,36],[37,30,38,36],[39,11,39,14],[39,26,39,29],[55,30,56,36],[57,30,58,36],[58,3,58,5],[58,18,58,20],[61,30,64,36],[46,30,53,36],[46,37,53,43],[51,3,51,4],[51,18,51,19],[53,8,53,9],[53,23,53,24],[71,0,71,14],[71,15,71,29],[74,0,74,14],[74,15,74,29],[75,0,75,14],[75,15,75,29],[65,30,67,36],[68,0,68,14],[68,15,68,29],[69,0,69,14],[69,15,69,29],[70,0,70,14],[70,15,70,29],[88,3,88,9],[88,11,88,14],[88,18,88,24],[88,26,88,29],[89,3,89,9],[89,18,89,24],[78,0,78,14],[78,15,78,29],[79,0,79,14],[79,15,79,29],[82,19,82,29],[83,19,83,29]]}
["Allgemeine Angaben",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Allgemeine Angaben"]
["Kennung des Probenahmeplans:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kennung des Probenahmeplans:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9001544412332_00001_2024",null,null,null,null,null,null,null,null,null,null,"Kann Bestehen aus: GLN des Erstellers_fortlaufende Nummer_Jahresangabe"]
[null,"Durchführende Firma:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Durchführende Firma:",null,null,"Labor XY",null,null,null,null,null,null,null,null,null,null,"Daten jener Firma, die den PN Plan erstellt und die PN durchführt."]
[null,"Personen GLN:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personen GLN:",null,null,9001455857362,null,null,null,null,null,null,null,null,null,null,"Für im EDM registrierte Personen/Firmen (13stellig)"]
[null,"Land:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Land:",null,null,"Österreich"]
[null,"Ort:",null,null,null,null,null,null,null,null,null,null,"Postleitzahl:",null,null,null,"Ort:",null,null,"Wien",null,null,null,null,null,null,null,"Postleitzahl:",1010]
[null,"Strasse:",null,null,null,null,null,null,null,null,null,null,"Hausnummer:",null,null,null,"Strasse:",null,null,"Stubenbastei",null,null,null,null,null,null,null,"Hausnummer:","5/2/14"]
[null,"Projektleiter:",null,null,null,null,null,null,null,null,"Telefon:",null,null,null,null,null,"Projektleiter:",null,null,null,null,null,null,null,null,"Telefon:",null,null,null,null,"Eine Person kann auch mehrere dieser Funktionen erfüllen."]
[null,"Ersteller des PN-Plans:",null,null,null,null,null,null,null,null,"Telefon:",null,null,null,null,null,"Ersteller des PN-Plans:",null,null,null,null,null,null,null,null,"Telefon:"]
[null,"Probenehmer:",null,null,null,null,null,null,null,null,"Telefon:",null,null,null,null,null,"Probenehmer:",null,null,null,null,null,null,null,null,"Telefon:"]
[null,"Datum der Probenahme:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum der Probenahme:"]
["Ort der Probenahme",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ort der Probenahme"]
[null,"Standort/Anlagen-GLN:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standort/Anlagen-GLN:",null,null,9000122222223,null,null,null,null,null,null,null,null,null,null,"Für im EDM registrierte Standorte/Anlagen (13stellig)"]
[null,"Land:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Land:"]
[null,"Ort:",null,null,null,null,null,null,null,null,null,null,"Postleitzahl:",null,null,null,"Ort:",null,null,null,null,null,null,null,null,null,null,"Postleitzahl:"]
[null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:",null,null,null,null,"Strasse:",null,null,null,null,null,null,null,null,null,"Hausnummer:"]
[null,"Kontakt vor Ort:",null,null,null,null,null,null,null,null,"Telefon:",null,null,null,null,null,"Kontakt vor Ort:",null,null,null,null,null,null,null,null,"Telefon:",null,null,null,null,"Ansprechpartner für den Probenehmer vor Ort"]
[null,"Weitere beteiligte Parteien:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weitere beteiligte Parteien:",null,null,"z.B: der Baggerfahrer inkl. Kontakt, Behördenvertreter falls relevant... "]
[]
["Angaben zum Ersatzbrennstoffprodukt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angaben zum Ersatzbrennstoffprodukt"]
[null,"Untersuchung für:",null,null,null,null,"1. Los ",null,null,null,null,null,"ab dem 2. Los",null,null,null,"Untersuchung für:",null,null,null,null,"1. Los ",null,null,null,null,null,"ab dem 2. Los"]
[null,"Form:",null,null,null,null,"Hackschnitzel",null,null,"Pellets",null,null,"Späne",null,null,null,"Form:",null,null,null,null,"Fluff",null,null,"Pellets",null,null,"Ballen",null,null,"Die Form des Ersatzbrennstoffprodukts ist hier auszuwählen oder einzutragen."]
[null,null,null,null,null,null,"Hackgut (grob)",null,null,"sonstiges: ",null,null,null,null,null,null,null,null,null,null,null,"Pulver",null,null,"pastöses Ersatzbrennstoffprodukt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sonstiges:"]
["Gesamtmenge des Ersatzbrennstoffproduktes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gesamtmenge des Ersatzbrennstoffproduktes"]
["bzw. Jahresanfallsmenge:",null,null,null,null,null,null,null,"t",null,"Losumfang: ",1500,null,null,"t","bzw. Jahresanfallsmenge:",null,null,null,4000,null,null,null,"t",null,"Losumfang: ",1500,null,null,"t","Bei Einzelchargen ist hier die Gesamtmenge einzutragen, bei Abfallströmen die voraussichtlich jährliche Abfallmenge. Bei Ersatzbrennstoffprodukten ist der Losumfang mit 1.500 t vorgegeben."]
[null,"Abfallart:",null,null,null,null,null,null,null,null,"Spezifizierung:",null,null,null,null,null,"Abfallart:",null,null,91108,null,null,null,null,null,"Spezifizierung:"]
[null,"Bezeichnung:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bezeichnung:",null,null,"Ersatzbrennstoffe, qualitätsgesichert"]
[null,"Spezifizierung (in Worten):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spezifizierung (in Worten):",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hier ist die überwiegende Form der einzelnen Teilchen des Ersatzbrennstoffproduktes auszuwählen. Für Granulate ist in weiterer Folge ein Formfaktor s von 1 zu verwenden. Je höher der Blättchencharakter ist, desto kleiner kann der Formfaktor angenommen werden."]
[null,"Form der Teilchen:",null,null,null,null,"Blättchen",null,null,null,null,null,"Granulat",null,null,null,"Form der Teilchen:",null,null,null,null,"Blättchen",null,null,null,null,null,"Granulat"]
[null,"Schüttdichte:",null,null,null,null,null,null,null,null,null,null,200,"kg/m3",null,null,"Schüttdichte:",null,null,null,null,null,null,null,null,null,null,200,"kg/m3",null,"Die Schüttdichte berücksichtigt die Hohlräume zwischen den Teilchen. Die Teilchendichte bezieht sich nur auf die einzelnen Teilchen des Ersatzbrennstoffproduktes ohne die Hohlräume dazwischen und ist im Regelfall wesentlich größer als der Wert für die Schüttdichte."]
[null,"Teilchendichte:",null,null,null,null,null,null,null,null,null,null,1,"g/cm3",null,null,"Teilchendichte:",null,null,null,null,null,null,null,null,null,null,1,"g/cm3"]
["Korngröße (Größtkorn, 95% Perzentil):",null,null,null,null,null,null,null,null,null,null,null,40,"mm",null,"Korngröße (Größtkorn, 95% Perzentil):",null,null,null,null,null,null,null,null,null,null,null,40,"mm"]
[null,"Sonstiges:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sonstiges:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Generelle Anmerkung: Angaben in Grün hinterlegten Feldern werde für nachfolgende Berechnungen verwendet."]
[]
["Grundangaben zur Probenahme",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grundangaben zur Probenahme"]
["Probenahmeverfahren:",null,null,null,null,null,null,null,null,"mechanisch",null,null,"manuell",null,null,"Probenahmeverfahren:",null,null,null,null,null,null,null,null,"mechanisch",null,null,"manuell",null,null,"Beispiel für mechanische Probenahme: mit Hilfe eines automatischen Bandabwurfes; Beispiel für manuelle Probenahme: mit einer Handschaufel"]
["erfolgt aus/von:",null,null,null,null,"Outputstrom",null,null,null,"Förderband",null,null,"Fahrzeug",null,null,"erfolgt aus/von:",null,null,null,null,"Outputstrom",null,null,null,"Förderband",null,null,"Fahrzeug"]
[null,null,null,null,null,"Haufwerk",null,null,null,"sonstiges:",null,null,null,null,null,null,null,null,null,null,"Haufwerk",null,null,null,"sonstiges:"]
["Identifizierung von Zugangsproblemen, die das Probenahmeverfahren beeinträchtigen könnten:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Identifizierung von Zugangsproblemen, die das Probenahmeverfahren beeinträchtigen könnten:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z.B. falls das Haufwerk nur von einer Seite zugänglich ist."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Generelle Anmerkung: für die Berechnung der Werte in Grau hinterlegten Feldern wird auch auf Informationen in anderen Zellen zugegriffen."]
[]
["Berechnung der Mindestmenge einer qualifizierten Stichprobe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Berechnung der Mindestmenge einer qualifizierten Stichprobe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anmerkung: Begriff \"Probe\" gemäß ÖNORM EN ISO 21645 entspricht dem Begriff für die \"qualifizierte Stichprobe\" gemäß AVV."]
["(nach ÖNORM EN ISO 21645)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(nach ÖNORM EN ISO 21645)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verteilungsfaktor (Korrekturfaktor für die Verteilung der Partikelgröße): 0,25 bis 1. Bei engen Verteilungen, d.h. alle Teilchen haben mehr oder weniger die selbe Größe, ist hier der Wert 1 einzusetzen. Bei breiten Verteilungen, d.h. der Durchmesser der \"größten\" Teilchen (d95) entspricht mehr als dem 4fachen Durchmesser der \"kleinen\" Teilchen (d05), wie z.B. bei d95/d05>4 ist der Wert 0.25 einzusetzen (weitere Hinweise siehe ÖNORM EN ISO 21645). Hier geht die Partikeldichte ein.\nFormfaktor: von >0 bis 1. Für Granulat ist der Wert 1 einzusetzen. Je höher der Blättchencharakter ist, desto kleiner kann der Formfaktor angenommen werden (weitere Hinweise siehe ÖNORM EN ISO 21645).\nFaktor (p): ist auf den Anteil von Partikel (Teilchen) mit einer bestimmten Eigenschaft (z.B. Verunreinigung) bezogen. Wenn kein Wert bekannt oder bestimmt wurde, ist hier 0.1 einzusetzen.\nVariationskoeffizient (CV):  0.1 muss verwendet werden.",null,null,null,null,null,null,"Mit Hilfe der Werte, die hier eingetragen bzw. übernommen werden, wird die Mindestmenge der QSTP automatisch berechnet (siehe grau hinterlegte Felder).\nVerteilungsfaktor (Korrekturfaktor für die Verteilung der Partikelgröße): 0.25 bis 1. Bei engen Verteilungen, d.h. alle Teilchen haben mehr oder weniger die selbe Größe, ist hier der Wert 1 einzusetzen. Bei breiten Verteilungen, d.h. der Durchmesser der größten Teilchen entspricht mehr als dem 4fachen Durchmesser der kleinen Teilchen (d95/d05>4) ist der Wert 0.25 einzusetzen. (weitere Hinweise siehe ÖNORM EN ISO 21645)\nFormfaktor: von >0 bis 1. Für Granulat ist der Wert 1 einzusetzen. Je höher der Blättchencharakter ist, desto kleiner kann der Formfaktor angenommen werden (weitere Hinweise siehe ÖNORM EN ISO 21645). Hier geht die Partikeldichte ein. \nBei breiten Verteilungen, d.h. der Durchmesser der größten Teilchen entspricht mehr als dem 4fachen Durchmesser der kleinen Teilchen (d95/d05>4) ist der Wert 0.25 einzusetzen. (weitere Hinweise siehe ÖNORM EN ISO 21645)\nFaktor (p): ist auf den Anteil von Partikel (Teilchen) mit einer bestimmten Eigenschaft (z.B. Verunreinigung) bezogen. Wenn kein Wert bekannt oder bestimmt wurde, ist hier 0.1 einzusetzen.\nVariationskoeffizient (CV): 0.1 muss verwendet werden."]
[]
["für die Berechnung werden folgende Werte herangezogen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"für die Berechnung werden folgende Werte herangezogen"]
["Größtkorn (d95)",null,null,null,{"$f":"$M$34","v":40},"mm",null,null,"Verteilungsfaktor (g)",null,null,null,1,null,null,"Größtkorn (d95)",null,null,null,{"$f":"$AB$34","v":40},"mm",null,null,"Verteilungsfaktor (g)",null,null,null,1]
["Formfaktor (f)",null,null,null,1,"mm3/mm3",null,null,"Faktor (p)",null,null,null,0.1,null,null,"Formfaktor (f)",null,null,null,1,"mm3/mm3",null,null,"Faktor (p)",null,null,null,0.1]
["Partikeldichte (λp)",null,null,{"$f":"M33/1000","v":1E-3},null,"g/mm3",null,null,"Variationskoeffizient (CV)",null,null,null,0.1,null,null,"Partikeldichte  (lp)",null,null,{"$f":"AB33/1000","v":1E-3},null,"g/mm3",null,null,"Variationskoeffizient (CV)",null,null,null,0.1]
[]
["Mindestmenge der QSTP (mQSTP)",null,null,null,null,null,null,null,{"$f":"PI()/6*POWER(E50,3)*E51*D52*M50*(1-M51)/SUMSQ(M52)/M51","v":30159.289474462006},null,"g",{"$f":"I54/1000","v":30.159289474462007},"kg",{"$f":"L54/$M$32*1000","v":150.79644737231004},"l","Mindestmenge der QSTP (mQSTP)",null,null,null,null,null,null,null,{"$f":"PI()/6*POWER(T50,3)*T51*S52*AB50*(1-AB51)/SUMSQ(AB52)/AB51","v":30159.289474462006},null,"g",{"$f":"X54/1000","v":30.159289474462007},"kg",{"$f":"AA54/$AB$32*1000","v":150.79644737231004},"l"]
[]
["Berechnung der Mindestmenge einer Stichprobe  (nach ÖNORM EN ISO 21645)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Berechnung der Mindestmenge einer Stichprobe  (nach ÖNORM EN ISO 21645)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anmerkung: Begriff \"Einzelprobe\" gemäß ÖNORM EN ISO 21645 entspricht dem Begriff für die \"Stichprobe\" gemäß AVV.\nGeneralisierte Formel für die Bestimmung der Mindestmenge einer Stichprobe (\"Einzelprobe\" lt. ÖNORM EN ISO 21645). Hier geht die Schüttdichte ein. "]
[]
["für die Berechnung werden folgende Werte herangezogen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"für die Berechnung werden folgende Werte herangezogen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mit Hilfe der Werte, die hier eingetragen bzw. von oben übernommen werden, wird die Mindestmenge der Stichprobe automatisch berechnet."]
["Schüttdichte (lb):",null,null,{"$f":"M32","v":200},null,null,"kg/m3",null,"Größtkorn (d95):",null,null,{"$f":"$M$34","v":40},"mm",null,null,"Schüttdichte (lb):",null,null,{"$f":"AB32","v":200},null,null,"kg/m3",null,"Größtkorn (d95):",null,null,{"$f":"$AB$34","v":40},"mm"]
["resultierende Mindestmenge der Stichprobe (mStP):",null,null,null,null,null,null,null,null,null,null,{"$f":"0.000000027*POWER(L59,3)*D59","v":0.34559999999999996},"kg",{"$f":"L60/$M$32*1000","v":1.7279999999999998},"l","resultierende Mindestmenge der Stichprobe (mSTP):",null,null,null,null,null,null,null,null,null,null,{"$f":"0.000000027*POWER(AA59,3)*S59","v":0.34559999999999996},"kg",{"$f":"AA60/$AB$32*1000","v":1.7279999999999998},"l"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Die effektiven Mengen sind vom Ersteller des Probenahmeplans selbst festzulegen. Zusätzlich zu den durchgeführten Berechnungen sind je nach Probenahme-Technik und geplanter Analysen noch andere Faktoren  zu berücksichtigen, z.B. ges. Querschnitt des Förderbandes, benötigte Menge für die Analytik, Rückstellproben, ..."]
["Festlegung der effektiven Mengen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Festlegung der effektiven Mengen"]
["Anzahl an Stichproben pro qualifizierter Stichprobe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl an Stichproben pro qualifizierter Stichprobe",null,null,null,null,null,null,null,null,null,null,24]
["effektive Menge der Stichproben",null,null,null,null,null,null,null,null,null,null,null,"kg",{"$f":"L65/$M$32*1000","v":0},"l","effektive Menge der Stichproben",null,null,null,null,null,null,null,null,null,null,1.3,"kg",{"$f":"AA65/$AB$32*1000","v":6.5000000000000009},"l"]
["effektive Menge der qualifizierten Stichproben",null,null,null,null,null,null,null,null,null,null,null,"kg",{"$f":"L66/$M$32*1000","v":0},"l","effektive Menge der qualifizierten Stichproben",null,null,null,null,null,null,null,null,null,null,31.2,"kg",{"$f":"AA66/$AB$32*1000","v":156},"l","Für die Anzahl an Stichproben pro qualifizierter Stichprobe sind laut AVV ab dem 2. Los mindestens 24 gefordert.\nAutomatische Umrechnung in Liter (grau markiertes Feld) über die angegebene Schüttdichte"]
[]
["Vorgaben für die Probenahme",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vorgaben für die Probenahme"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hier ist die detaillierte Vorgehensweise bei der Probenahme zu beschreiben. Wieviele qualifizierte "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stichproben, aus welchen Bereichen (Verteilungsmuster), mit welchem Gerät werden gezogen? "]
[]
[]
[]
["Vorgaben für Verpackung, Konservierung, Transport und Aufbewahrung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vorgaben für Verpackung, Konservierung, Transport und Aufbewahrung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z.B. Angabe welche Gebinde zu verwenden sind und deren  Beschriftung (eineindeutig, "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rückführbar auf das Los, …)"]
[]
["Sicherheitsvorkehrungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sicherheitsvorkehrungen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z.B. Angaben zu der zu tragenden Schutzkleidung, Umgang mit Geräten, Abstand zu Großgeräten,…"]
[]
[]
["Liste der Anhänge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liste der Anhänge"]
[null,null,"1.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.",null,"z.B. Sicherheitsdatenblätter"]
[null,null,"2.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2."]
[null,null,"3.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3."]
[null,null,"…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"…"]
[]
[null,null,null,"Unterschrift",null,null,null,null,null,null,null,"Datum",null,null,null,null,null,null,"Unterschrift",null,null,null,null,null,null,null,"Datum"]
[null,null,"Projektleiter:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projektleiter:","(Ausdruck ist zu unterschreiben)"]
[null,null,"Ersteller des PN-Plans:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ersteller des PN-Plans:","(Ausdruck ist zu unterschreiben)"]

{"sheet":"Probenahmeprotokoll","index":3,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,0,2,6],[2,7,2,13],[3,0,3,6],[3,7,3,13],[4,0,4,6],[4,7,4,13],[29,2,29,5],[29,9,29,12],[30,2,30,5],[30,9,30,12],[5,0,5,6],[5,7,5,13],[27,2,27,5],[27,9,27,12],[28,2,28,5],[28,9,28,12]]}
[]
["Abweichungen hinsichtlich der geplanten Vorgehensweise",null,null,null,null,null,null,"Abweichungen hinsichtlich der geplanten Vorgehensweise"]
[null,null,null,null,null,null,null,"z.B.: Andere Probenahmestelle, oder andere Anzahl an Stichproben. ...."]
[]
[]
[]
[]
["Übersicht über die hergestellten qualifizierten Stichproben",null,null,null,null,null,null,"Übersicht über die hergestellten qualifizierten Stichproben"]
["eindeutige Kennung der qualifizierten Stichprobe","Anzahl der Stichproben","Datum/Zeit","eindeutige Zuordnung zu Los, Teilmenge, Fahrzeugnummer, Gefäßnummer oder ähnliche Angabe","Menge/\nEinheit","Anmerkungen","Unterschrift (Paraphe)","eindeutige Kennung der qualifizierten Stichprobe","Anzahl der Stichproben","Datum/Zeit","eindeutige Zuordnung zu Los, Teilmenge, Fahrzeugnummer, Gefäßnummer oder ähnliche Angabe","Menge/\nEinheit","Anmerkungen","Unterschrift (Paraphe)"]
[null,null,null,null,null,null,null,"Je nach konkreter Probenahmesituation können hier unterschiedliche Informationen wesentlich sein. Hier einige Beispiele:"]
[null,null,null,null,null,null,null,"QSTP 01",10,"12:00 bis 14:00","Los 2, LKW (W-15423G)","20 kg",null,"STS"]
[null,null,null,null,null,null,null,"2024/0455",10,"2023-07-21","Los 1, Teilmenge 3","20 kg",null,"STS"]
[null,null,null,null,null,null,null,"P1813",10,"21.07.23  13:00","Los 1, TM2, Bereich 2 laut Skizze","20 kg",null,"AK"]
[null,null,null,null,null,null,null,"QSTP 05",10,"30.07.23  15:00","Tankwagen Nr. 5 KZ xxxxxx","5 l","auffällig hoher Wassergehalt (2 Phasen)","BV"]
[null,null,null,null,null,null,null,"QSTP 3",24,"1.1.2024-31.3.2024","LOS 3","25 kg",null,"BV"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Liste der Anhänge",null,null,null,null,null,null,"Liste der Anhänge"]
[null,"1.",null,null,null,null,null,null,"1.","z.B.: Skizze"]
[null,"2.",null,null,null,null,null,null,"2.","z.B.: Fotodokumentation"]
[null,"3.",null,null,null,null,null,null,"3."]
[null,"…",null,null,null,null,null,null,"…"]
[]
[null,null,"Unterschrift des Probenehmers: ",null,"Datum: ",null,null,null,null,"Unterschrift des Probenehmers: ","(Ausdruck ist zu unterschreiben)","Datum: "]

{"sheet":"Analysenergebnisse","index":4,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,1,2,1],[0,0,2,0]]}
["Probenbezeichnung","Beurteilungsnachweis (Kennung)","As","Pb","Cd","Cr","Hg","Zn","Cl","F","Summe PAK (EPA)"]
[null,null,"mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM"]

{"sheet":"Berechnung d. Beurteilungswerte","index":5,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,9]]}
[]
[null,"Eingabe der letzten 10 Analysenergebnisse"]
[null,"Messwerte"]
[]
[]
["Parameter","As","Pb","Cd","Cr","Hg","Zn","Cl","F","Summe PAK (EPA)"]
["Einheit","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
[]
[null,"Berechnung"]
[]
[]
[]
["Parameter"]
[]
["Anzahl"]
["Median"]
["80-er Perzentil"]
["Verhältnisfaktor"]
[]
[null,"berechnet am 10.04.2024 um 10:41:21"]

{"sheet":"Einhaltung der Grenzwerte","index":6,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,3,39,3],[25,3,27,3],[28,3,30,3],[31,3,33,3],[34,3,36,3],[13,1,24,1],[10,3,12,3],[13,3,15,3],[16,3,18,3],[19,3,21,3],[22,3,24,3],[2,0,3,0],[4,1,8,1],[0,3,3,3],[4,3,6,3],[7,3,9,3]]}
["Farbcode",null,"Parameter","Kennung des Beurteilungs-nachweises","As","Pb","Cd","Cr","Hg","Zn","Cl","F","∑PAK"]
[null,null,"Einheit",null,"mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM"]
["für Median und\n 80-er Perzentil",null,"Grenzwert Median",null,1.2,10,0.8,10,0.05,140,250,15,2]
[null,null,"Grenzwert 80-er Perzentil",null,1.8,15,1.2,15,7.4999999999999997E-2,210,300,20,3]
[0.2,null,"Median"]
[0.5,null,"80-er Perzentil"]
[0.51,null,"Verhältnisfaktor"]
[0.8,null,"Median"]
[1.01,null,"80-er Perzentil"]
[null,null,"Verhältnisfaktor"]
["für Verhältnisfaktor",null,"Median"]
[1,null,"80-er Perzentil"]
[1.6,null,"Verhältnisfaktor"]
[null,null,"Median"]
[null,null,"80-er Perzentil"]
[null,null,"Verhältnisfaktor"]
[null,null,"Median"]
[null,null,"80-er Perzentil"]
[null,null,"Verhältnisfaktor"]
[null,null,"Median"]
[null,null,"80-er Perzentil"]
[null,null,"Verhältnisfaktor"]
[null,null,"Median"]
[null,null,"80-er Perzentil"]
[null,null,"Verhältnisfaktor"]
[null,null,"Median"]
[null,null,"80-er Perzentil"]
[null,null,"Verhältnisfaktor"]
[null,null,"Median"]
[null,null,"80-er Perzentil"]
[null,null,"Verhältnisfaktor"]
[null,null,"Median"]
[null,null,"80-er Perzentil"]
[null,null,"Verhältnisfaktor"]
[null,null,"Median"]
[null,null,"80-er Perzentil"]
[null,null,"Verhältnisfaktor"]
[null,null,"Median"]
[null,null,"80-er Perzentil"]
[null,null,"Verhältnisfaktor"]

{"sheet":"Info zur Benutzung des Makros","index":7,"n_rows":159,"n_cols":5,"rows_kept":159,"cut":false,"hidden":false,"merged":[[155,1,155,9],[156,1,156,9],[157,1,157,9],[158,1,158,9],[99,1,99,9],[121,1,121,9],[124,1,124,9],[125,1,125,9],[126,1,126,9],[94,2,94,3],[94,4,94,9],[96,1,96,9],[97,1,97,9],[98,1,98,9],[87,2,87,9],[88,2,88,9],[91,1,91,9],[93,2,93,3],[93,4,93,9],[79,1,79,9],[80,1,80,9],[84,1,84,9],[85,1,85,9],[86,2,86,9],[68,1,68,9],[71,1,71,9],[72,1,72,9],[75,1,75,9],[76,1,76,9],[61,1,61,9],[62,1,62,9],[63,1,63,9],[66,1,66,9],[67,1,67,9],[52,1,52,9],[53,1,53,9],[54,1,54,9],[57,1,57,9],[58,1,58,9],[43,1,43,9],[44,1,44,9],[46,1,46,9],[47,1,47,9],[49,1,49,9],[36,1,36,9],[37,1,37,9],[39,1,39,9],[40,1,40,9],[42,1,42,9],[30,1,30,9],[31,1,31,9],[32,1,32,9],[33,1,33,9],[34,1,34,9],[24,1,24,9],[25,1,25,9],[26,1,26,9],[27,1,27,9],[29,1,29,9],[18,1,18,9],[19,1,19,9],[20,1,20,9],[21,1,21,9],[23,1,23,9],[1,1,1,9],[2,1,2,9],[7,1,7,9],[8,1,8,9],[9,1,9,9],[3,1,3,9],[5,1,5,9],[12,1,12,9],[11,1,11,9],[13,1,13,9],[15,1,15,9],[17,1,17,9]]}
[null,"Information zur Benutzung des Makros"]
[null,"Allgemeines"]
[null,"Das Makro zur Berechnung der Beurteilungswerte (Quantile) wird für die Anwendenden"]
[null,"kostenlos zur Verfügung gestellt."]
[]
[null,"Der/die Anwender:in ist für die korrekte Eingabe der Daten verantwortlich."]
[]
[null,"Da die Anwendenden über unterschiedliche Betriebssysteme und Excelversionen verfügen,"]
[null,"ist jedenfalls vor der routinemäßigen Verwendung das Makro mit einem Testdatensatz"]
[null,"auf Funktionalität zu testen."]
[]
[null,"Vorgeschlagen wird ein Testdatensatz, der die Fälle „n.n.“ (Berechnung mit „0“), "]
[null,"< 0,5 (Berechnung mit dem Wert der halben Bestimmungsgrenze, hier 0,25; "]
[null,"Dezimaltrennzeichen entsprechend Excel Ländereinstellungen) und „Text“ enthält. "]
[]
[null,"Die Randbedingungen zur korrekten Bedienung des Makros finden sich nachstehend."]
[null,"Funktionalität (Makro)"]
[null,"Je nach Excel-Version und Sicherheitseinstellungen muss die Ausführung von Makros"]
[null,"zugelassen werden. "]
[null,"Möglicherweise brauchen Sie dafür zudem Administratorrechte auf Ihrem Rechner."]
[null,"Im einfachsten Fall erscheint beim Öffnen der Mappe ein Sicherheitshinweis, mit der Option,"]
[null,"die Ausführung von Makros in dieser Arbeitsmappe zuzulassen."]
[]
[null,"Es kann außerdem sein, dass die Ausführung von Makros ohne gesonderte Nachfrage "]
[null,"unterbunden wird. In diesem Fall kann es helfen, den Speicherort der Arbeitsmappe als "]
[null,"vertrauenswürdigen Speicherort festzulegen:"]
[null,"Datei > Optionen > Trust Center >  Einstellungen für das TrustCenter > Vertrauenswürdige"]
[null,"Speicherorte"]
[]
[null,"Bei älteren Excel-Versionen erfolgt diese Einstellung über die Menüleiste:"]
[null,"- Extras"]
[null,"- Optionen"]
[null,"- Reiter Sicherheit"]
[null,"- Schaltfläche Makrosicherheit"]
[null,"Zur Ausführung des Makros muss die Makrosicherheit auf 'niedrig' eingestellt sein."]
[]
[null,"Bei aktuelleren Excel-Versionen erscheint automatisch beim Öffnen der Datei die Abfrage "]
[null,"zur Aktivierung des Makroinhaltes."]
[null,"Arbeitsblätter"]
[null,"Die Arbeitsblätter 'Analysenergebnisse' und 'Berechnung d. Beurteilungswerte' dürfen"]
[null,"weder umbenannt noch gelöscht werden."]
[]
[null,"Im Falle eines vollständig befüllten Arbeitsblattes 'Analysenergebnisse' empfiehlt sich die "]
[null,"Speicherung der Datei unter eindeutigem Namen und das Arbeitsblatt "]
[null,"Analysenergebnisse' des Rohmakros wird neu befüllt."]
[]
[null,"Achten Sie bitte darauf, dass für jeden Parameter die letzten 10 Werte übernommen"]
[null,"werden. "]
[]
[null,"Das Arbeitsblatt 'Tabelle 1' steht Ihnen für weitere Berechnungen zur Verfügung."]
[]
[null,"Dateneingabe"]
[null,"Die Eingabe der 10 aktuellsten Daten erfolgt entweder durch manuelle Eingabe im"]
[null,"Arbeitsblatt 'Berechnung d. Beurteilungswerte' oder durch automatische Übernahme"]
[null,"aus dem Arbeitsblatt 'Analysenergebnisse'."]
[]
[null,"Button"]
[null,"Das Klicken dieser Schaltfläche ermöglicht die manuelle Eingabe der Daten bzw. können"]
[null,"Daten eingefügt werden."]
[]
[null,"Button"]
[null,"Die zehn aktuellsten Werte (d.h. die in der Liste zehn letztgereihten) der im Arbeitsblatt"]
[null,"'Analysenergebnisse' eingegebenen Daten werden durch das Klicken dieser Schaltfläche"]
[null,"automatisch ins Arbeitsblatt 'Berechnung d. Beurteilungswerte' übertragen. "]
[]
[null,"Gesperrte Zellen"]
[null,"Das Makro greift auf alle mit Hintergrundfarbe formatierten Zellen (in blau) zu."]
[null,"Die Zellen im Registerblatt 'Berechnung d. Beurteilungswerte' sind je nach Anforderung"]
[null,"gesperrt bzw. geschützt."]
[]
[null,"Button"]
[null,"Mit diesem Button können die automatisch übernommenen oder manuell eingegebenen"]
[null,"Daten im Arbeitsblatt 'Berechnung d. Beurteilungswerte' gelöscht werden. "]
[]
[null,"Button"]
[null,"Klicken Sie auf die Schaltfläche zur Berechnung der Quantile und des Verhältnisfaktors"]
[null,"(informativ) im Arbeitsblatt 'Berechnung d. Beurteilungswerte'."]
[]
[null,"Weitere Hinweise zur Dateineingabe"]
[null,"Um Daten einer anderen Tabelle/Quelle einzufügen, wird das Einfügen von Werten"]
[null,"(Menü: Bearbeiten / Inhalte einfügen … / Werte) empfohlen."]
[]
[null,"Die Parameter und Einheiten sind nicht editierbar."]
[]
[null,"Aufgrund der verschiedenen Dezimaltrennzeichen (entsprechend Excel Ländereinstellung)"]
[null,"ist darauf zu achten, dass Werte nicht im Datumsformat eingegeben werden."]
[null,"Beispiel:","Bei Excel Ländereinstellung Dezimaltrennzeichen 'Komma' und bei Eingabe"]
[null,null,"von 3.4 anstatt 3,4 wird die Eingabe automatisch in 03. April 2024 umgewandelt,"]
[null,null,"und in weiterer Folge als Zahlenwert (= 45385) berücksichtigt."]
[]
[null,"Mögliche Werte"]
[null,"Zahlen und folgende 'Strings' (Zeichenketten) sind zulässige Dateneingaben:"]
[null,"Eingabe","Bedeutung",null,"Berücksichtigung"]
[null,"n.n.","nicht nachweisbar",null,"Es wird automatisch 0 (sprich NULL) zur weiteren \nBerechnung verwendet."]
[null,"<BG","kleiner \nBestimmungs- \ngrenze",null,"Mit halber Bestimmungsgrenze wird gerechnet.\nz.B. <0,7 bedeutet 0,35. \n\nVORSICHT:\nWenn Punkt als Dezimaltrennzeichen definiert ist, muss die Bestimmungsgrenze im selben Format eingegeben werden. \nz.B. <0.7"]
[]
[null,"Nicht zulässige Dateneingaben werden bei der Berechnung der Quantile ausgeschlossen."]
[null,"Durch pinke Füllfarbe werden diese gekennzeichnet."]
[null,"(Musterbeispiel: hier z.B. Einstellung Dezimaltrennzeichen mit Punkt, daher"]
[null," < 0.40 korrekt, zugleich <0,4 nicht in Ordnung und pink markiert)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Weitere Hinweise"]
[null,"Es wird empfohlen, bei der Durchführung der Makros andere Excel-Dateien zu schließen."]
[]
[null,"Ausdruck"]
[null,"Die Spalte A wurde als Wiederholungsspalte links und die ersten 3 Zeilen als"]
[null,"Wiederholungszeilen oben definiert, um einen geeigneten Ausdruck der Ergebnisse"]
[null,"zu erzielen."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Gewährleistungs- und Haftungsausschluss"]
[null,"Es besteht keinerlei Gewährleistung für das kostenlos zur Verfügung gestellte Programm"]
[null,"und das BMK ist den Anwender:innen gegenüber für irgendwelche Schäden, die aus der "]
[null,"Benutzung des Programms folgen, in keinem Fall haftbar. "]
[null,"Ende "]

{"sheet":"Tabelle1","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Format","index":9,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Eingabe der Beurteilungswerte",null,"Formel für korrekte Werte (bei Beurteilungswerten): =WENN(ODER(B8=\"n.n.\";ISTZAHL(B8);LINKS(B8;1)=\"<\";ISTLEER(B8));1;0)"]
[]
[]
[]
[]
["Parameter","As","Pb","Cd","Cr","Hg","Zn","Cl","F","Summe PAK (EPA)"]
["Einheit","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
[]
["Berechnung der Perzentile"]
[]
[]
[]
["berechnet am:"]
[]
["Parameter","As","Pb","Cd","Cr","Hg","Zn","Cl","F","Summe PAK (EPA)"]
["Einheit","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM","mg/kg TM"]
["Anzahl","","","","","","",null,null,""]
["Median","","","","","","",null,null,""]
["80-er Perzentil","","","","","","",null,null,""]
["Verhältnisfaktor","","","","","","",null,null,""]

{"sheet":"RECHNEN","index":10,"n_rows":34,"n_cols":210,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Importieren",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ersetzen",{"$f":"IF(B1=\"n.n.\",0,(IF(AND(LEFT(B1,1)=\"<\",ISNUMBER(MID(B1,2,500)*1)),RIGHT(B1,LEN(B1)-1)/2,(IF(ISNUMBER(B1),B1,\"\")))))","v":""},{"$f":"IF(C1=\"n.n.\",0,(IF(AND(LEFT(C1,1)=\"<\",ISNUMBER(MID(C1,2,500)*1)),RIGHT(C1,LEN(C1)-1)/2,(IF(ISNUMBER(C1),C1,\"\")))))","v":""},"",{"$f":"IF(E1=\"n.n.\",0,(IF(AND(LEFT(E1,1)=\"<\",ISNUMBER(MID(E1,2,500)*1)),RIGHT(E1,LEN(E1)-1)/2,(IF(ISNUMBER(E1),E1,\"\")))))","v":""},{"$f":"IF(F1=\"n.n.\",0,(IF(AND(LEFT(F1,1)=\"<\",ISNUMBER(MID(F1,2,500)*1)),RIGHT(F1,LEN(F1)-1)/2,(IF(ISNUMBER(F1),F1,\"\")))))","v":""},{"$f":"IF(G1=\"n.n.\",0,(IF(AND(LEFT(G1,1)=\"<\",ISNUMBER(MID(G1,2,500)*1)),RIGHT(G1,LEN(G1)-1)/2,(IF(ISNUMBER(G1),G1,\"\")))))","v":""},{"$f":"IF(H1=\"n.n.\",0,(IF(AND(LEFT(H1,1)=\"<\",ISNUMBER(MID(H1,2,500)*1)),RIGHT(H1,LEN(H1)-1)/2,(IF(ISNUMBER(H1),H1,\"\")))))","v":""},{"$f":"IF(I1=\"n.n.\",0,(IF(AND(LEFT(I1,1)=\"<\",ISNUMBER(MID(I1,2,500)*1)),RIGHT(I1,LEN(I1)-1)/2,(IF(ISNUMBER(I1),I1,\"\")))))","v":""},{"$f":"IF(J1=\"n.n.\",0,(IF(AND(LEFT(J1,1)=\"<\",ISNUMBER(MID(J1,2,500)*1)),RIGHT(J1,LEN(J1)-1)/2,(IF(ISNUMBER(J1),J1,\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kopierte",5,5,5,5,5,5,5,5,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,null,1,5,5,5,5,5,5,5,5,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n.n. und <",{"$f":"IF(B2=\"n.n.\",0,(IF(AND(LEFT(B2,1)=\"<\",ISNUMBER(MID(B2,2,500)*1)),RIGHT(B2,LEN(B2)-1)/2,(IF(ISNUMBER(B2),B2,\"\")))))","v":""},"","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werte",5,5,5,5,5,5,5,5,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,null,2,5,5,5,5,5,5,5,5,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,5,5,5,5,5,5,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,3,5,5,5,5,5,5,5,5,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,5,5,5,5,5,5,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,4,5,5,5,5,5,5,5,5,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,5,5,5,5,5,5,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,5,5,5,5,5,5,5,5,5,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,5,5,5,5,5,5,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,6,5,5,5,5,5,5,5,5,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,5,5,5,5,5,5,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,7,5,5,5,5,5,5,5,5,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,5,5,5,5,5,5,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,8,5,5,5,5,5,5,5,5,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,9,"","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,10,"","","","","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parameter",1,2,3,4,5,6,7,8,9]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl",{"$f":"COUNT(FC1:FC10)","v":8},8,8,8,8,8,8,8,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50P.UG",{"$f":"VLOOKUP((ROUNDUP(FC16*0.5, 0)),$FB1:FC10,FC14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FD16*0.5, 0)),$FB1:FD10,FD14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FE16*0.5, 0)),$FB1:FE10,FE14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FF16*0.5, 0)),$FB1:FF10,FF14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FG16*0.5, 0)),$FB1:FG10,FG14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FH16*0.5, 0)),$FB1:FH10,FH14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FI16*0.5, 0)),$FB1:FI10,FI14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FJ16*0.5, 0)),$FB1:FJ10,FJ14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FK16*0.5, 0)),$FB1:FK10,FK14+1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50P.OG",{"$f":"VLOOKUP((ROUNDDOWN(FC16*0.5+1, 0)),$FB1:FC10,FC14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FD16*0.5+1, 0)),$FB1:FD10,FD14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FE16*0.5+1, 0)),$FB1:FE10,FE14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FF16*0.5+1, 0)),$FB1:FF10,FF14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FG16*0.5+1, 0)),$FB1:FG10,FG14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FH16*0.5+1, 0)),$FB1:FH10,FH14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FI16*0.5+1, 0)),$FB1:FI10,FI14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FJ16*0.5+1, 0)),$FB1:FJ10,FJ14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FK16*0.5+1, 0)),$FB1:FK10,FK14+1)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80P.UG",{"$f":"VLOOKUP((ROUNDUP(FC16*0.8, 0)),$FB1:FC10,FC14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FD16*0.8, 0)),$FB1:FD10,FD14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FE16*0.8, 0)),$FB1:FE10,FE14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FF16*0.8, 0)),$FB1:FF10,FF14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FG16*0.8, 0)),$FB1:FG10,FG14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FH16*0.8, 0)),$FB1:FH10,FH14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FI16*0.8, 0)),$FB1:FI10,FI14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FJ16*0.8, 0)),$FB1:FJ10,FJ14+1)","v":5},{"$f":"VLOOKUP((ROUNDUP(FK16*0.8, 0)),$FB1:FK10,FK14+1)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80P.OG",{"$f":"VLOOKUP((ROUNDDOWN(FC16*0.8+1, 0)),$FB1:FC10,FC14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FD16*0.8+1, 0)),$FB1:FD10,FD14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FE16*0.8+1, 0)),$FB1:FE10,FE14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FF16*0.8+1, 0)),$FB1:FF10,FF14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FG16*0.8+1, 0)),$FB1:FG10,FG14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FH16*0.8+1, 0)),$FB1:FH10,FH14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FI16*0.8+1, 0)),$FB1:FI10,FI14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FJ16*0.8+1, 0)),$FB1:FJ10,FJ14+1)","v":5},{"$f":"VLOOKUP((ROUNDDOWN(FK16*0.8+1, 0)),$FB1:FK10,FK14+1)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50P",{"$f":"AVERAGE(FC18:FC19)","v":5},5,5,5,5,5,5,5,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80P",{"$f":"AVERAGE(FC21:FC22)","v":5},5,5,5,5,5,5,5,{"$error":"#N/A"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VF80:50",{"$f":"FC25/FC24","v":1},1,1,1,1,1,1,1,{"$error":"#N/A"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ausgabe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anz.Dezimalstellen",{"$f":"IF(FC24<1,3,2)","v":2},{"$f":"IF(FD24<1,3,2)","v":2},2,2,2,2,2,2,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anzahl",{"$f":"IF(FC16=0,\"\",FC16)","v":8},8,8,8,8,8,8,8,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",{"$f":"IF(FC16=0,\"\",IF(AND(FC16>0,FC16<5),\"Zu wenig\",ROUND(FC24, FC30)))","v":5},5,5,5,5,5,5,5,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80-er Perzentil",{"$f":"IF(FC16=0,\"\",IF(AND(FC16>0,FC16<5),\"Daten\",ROUND(FC25, FC30)))","v":5},5,5,5,5,5,5,5,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verhältnisfaktor\n 80 P : 50 P",{"$f":"IF(AND(FC16>4,ISNUMBER(FC27)),ROUND(FC27, 1),\"\")","v":1},1,1,1,1,1,1,1,""]

{"sheet":"AUTO","index":11,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[8,5,5,5,5,5,5,5,5]
[7,5,5,5,5,5,5,5,5]
[6,5,5,5,5,5,5,5,5]
[5,5,5,5,5,5,5,5,5]
[4,5,5,5,5,5,5,5,5]
[3,5,5,5,5,5,5,5,5]
[2,5,5,5,5,5,5,5,5]
[1,5,5,5,5,5,5,5,5]