{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Berechnungshilfe"," Hinweise"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Berechnungshilfe","index":0,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,1,0,10],[0,12,0,16]]}
[null,"Berechnung Verbund-Index GP-RS Schlauchliner",{"$nulls":10},"Aktuelle Daten 2022"]
[null,"GP-Nummer ","Faktor"," Produktart "," Beschreibung laut Statistik ","Indexwert Versand der Angebotsunterlagen***","Indexwert Angebotseröffnung","Indexwert Abrechnung",{"$nulls":4},"GP2009 (ausgewählte 9-Steller): Gewerbl. Produkte",null,"Januar","Februar","März","April","Mai","Juni"]
["GP-RS 1","GP 09-2016406201*",0.15," Nadelfilzliner EP -Trägermaterial "," Polyethylenterephtalat, in Primärformen ",{"$nulls":7},"GP09-201325700","Aluminiumhydroxid                        (t-Al2O3)",116,122.4,122.4,122.7,123.2,123.2]
[null,"GP 09-201640308 *",0.85," Nadelfilzliner EP - Harz "," Epoxidharze, in anderen Primärformen ",null,null,null,"Basiswert 1***","Basiswert 2","Basiswert 3",null,"GP09-201640308","Epoxidharze, in anderen Primärformen",147.9,148,148.30000000000001,161.9,163,163]
[null,"GP-RS 1 (Nadelfilzliner, EP)",null,null,null,{"$f":"$C3*F3+($C4*F4)","v":0},{"$f":"$C3*G3+($C4*G4)","v":0},0,null,{"$f":"I5*(G5/F5)","v":{"$error":"#DIV/0!"}},{"$f":"J5*H5/G5","v":{"$error":"#DIV/0!"}},null,"GP09-2016406201","Polyethylenterephtalat, in Primärformen",120,126.5,133.9,138,146.4,152.1]
[]
["GP-RS 2","GP-Nummer ","Faktor"," Produktart "," Beschreibung laut Statistik ","Indexwert Versand der Angebotsunterlagen***","Indexwert Angebotseröffnung","Indexwert Abrechnung",{"$nulls":4},"GP09-201640900","Andere Polyester, in Primärformen",117.4,118.8,120.7,129.19999999999999,131.19999999999999,135.19999999999999]
[null,"GP 09-2016406201 *",0.15," Nadelfilzliner UP - Trägermaterial "," Polyethylenterephtalat, in Primärformen ",{"$nulls":7},"GP09-23141","Glasfasern (einschl. Glaswolle), Waren daraus",112.5,113.2,116.1,131.1,122.2,127.5]
[null,"GP 09-201325700 *",0.2," Nadelfilzliner UP - Füllstoff "," Aluminiumhydroxid (t-Al2O3) "]
[null,"GP 09-201640900 *",0.65," Nadelfilzliner UP - Harz "," Andere Polyester, in Primärformen ",null,null,null,"Basiswert 1***","Basiswert 2","Basiswert 3"]
[null,"GP-RS 2 (Nadelfilzliner, UP)",null,null,null,{"$f":"$C8*F8+$C9*F9+$C10*F10","v":0},{"$f":"$C8*G8+$C9*G9+$C10*G10","v":0},0,null,{"$f":"I11*(G11/F11)","v":{"$error":"#DIV/0!"}},{"$f":"J11*H11/G11","v":{"$error":"#DIV/0!"}}]
[]
["GP-RS 3","GP-Nummer ","Faktor"," Produktart "," Beschreibung laut Statistik ","Indexwert Versand der Angebotsunterlagen***","Indexwert Angebotseröffnung","Indexwert Abrechnung"]
[null,"GP 09-201640900 *",0.5," Glasfaserliner - Harz "," Andere Polyester, in Primärformen "]
[null,"GP 09-23141**",0.5," Glasfaserliner - Glas "," Glasfasern (einschl. Glaswolle), Waren daraus ",null,null,null,"Basiswert 1***","Basiswert 2","Basiswert 3"]
[null,"GP-RS 3 (Glasfaserliner, UP)",null,null,null,{"$f":"$C14*F14+$C15*F15","v":0},{"$f":"$C14*G14+$C15*G15","v":0},0,null,{"$f":"I16*(G16/F16)","v":{"$error":"#DIV/0!"}},{"$f":"J16*H16/G16","v":{"$error":"#DIV/0!"}}]
[]
[null,"GP-Nummer",null," Produktart "," Beschreibung laut Statistik ","Indexwert Versand der Angebotsunterlagen***","Indexwert Angebotseröffnung","Indexwert Abrechnung","Basiswert 1***","Basiswert 2","Basiswert 3",null,"GP-RS Index","Aktuelle Daten 2022","Januar","Februar","März","April","Mai","Juni"]
["GP-RS","GP-RS 0 (Schlauchliner allgemein)",null,"Schlauchliner gesamt (Produktoffen)",null,{"$f":"AVERAGE(F5,F11,F16)","v":0},{"$f":"AVERAGE(G5,G11,G16)","v":0},{"$f":"AVERAGE(H5,H11,H16)","v":0},null,{"$f":"I19*(G19/#REF!)","v":{"$error":"#REF!"}},{"$f":"J19*H19/G19","v":{"$error":"#REF!"}},null,"GP-RS 1 Index Nadelfilzliner EP","GP-RS 1 Index Nadelfilzliner EP",{"$f":"$C3*O5+($C4*O4)","v":143.715},{"$f":"$C3*P5+($C4*P4)","v":144.77500000000001},146.14000000000001,158.315,160.51,{"$f":"$C3*T5+($C4*T4)","v":161.36499999999998}]
[{"$nulls":12},"GP-RS 2 Index Nadelfilzliner UP","GP-RS 2 Index Nadelfilzliner UP",{"$f":"$C8*O5+$C9*O3+$C10*O7","v":117.51},{"$f":"$C8*P5+$C9*P3+$C10*P7","v":120.675},123.02000000000001,129.22,131.88,{"$f":"$C8*T5+$C9*T3+$C10*T7","v":135.33499999999998}]
[null,"  ",{"$nulls":10},"GP-RS 3 Index Glasfaserliner UP","GP-RS 3 Index Glasfaserliner UP",{"$f":"$C14*O7+$C15*O8","v":114.95},{"$f":"$C14*P7+$C15*P8","v":116},118.4,130.14999999999998,126.69999999999999,{"$f":"$C14*T7+$C15*T8","v":131.35}]
[{"$nulls":12},"GP-RS 0 Schlauchliner gesamt","GP-RS 0 Schlauchliner gesamt",{"$f":"AVERAGE(O19:O21)","v":125.39166666666667},127.14999999999999,129.1866666666667,139.22833333333332,139.69666666666666,142.68333333333331]
[{"$nulls":12},"Entwicklung GP-RS 0 zum Vormonat","Entwicklung GP-RS 0 zum Vormonat",0.02,{"$f":"(P22-O22)/O22","v":1.4022728783146081E-2},{"$f":"(Q22-P22)/P22","v":1.6017826713855324E-2},{"$f":"(R22-Q22)/Q22","v":7.7729899886468876E-2},{"$f":"(S22-R22)/R22","v":3.3637789243089918E-3},{"$f":"(T22-S22)/S22","v":2.1379655921162404E-2}]
[{"$nulls":12},"Entwicklung GP-RS-0 zum Vorjahresmonat","Entwicklung GP-RS-0 zum Vorjahresmonat",0.26893236633496359,0.26464981351015321,0.26589472652741292,0.24777069112309366,0.23463300387397074,0.2405628251387498]

{"sheet":" Hinweise","index":1,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["Anleitung  zu Indexerten"]
["Tragen Sie die Indexwerte  des jeweiligen Monats in die farbig markierten und umrandeten Tabellenspalten ein (ggf. mit = direkt Bezug herstellen. Tragen Sie den Basiswert 1 in das weiße Feld daneben ein. Bei Verwendung des Formulars 225a ist hier der Wert in Euro einzutragen, der vom Bieter angegeben ist."]
["https://www-genesis.destatis.de/genesis//online?operation=table&code=61241-0004&bypass=true&levelindex=1&levelid=1651493663931#abreadcrumb"]
["Geben Sie Monat, Jahr und gewünschte Tabelle ein:"]
["*ausgewählte 9-Steller, Sonderpostionen"]
["**5-Steller"]
[]
["***Entfällt bei Verwendung des Formblatts 225a. Als Basiswert 2 ist der Preis aus dem bezuschlagten Angebot anzugeben"]