{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["-","AX01 (0)","Statistik stat"],"not_rendered":{"charts":1,"images":1,"macros":1,"defined_names":47,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"-","index":0,"n_rows":69,"n_cols":2,"rows_kept":69,"hidden":true}
[]
[]
[]
["Einstellungen:"]
["Com:","COM1"]
["Mode:",3]
["Dll:","MCSCM.dll"]
["Translations (0=off, 1,2,3..=aktive Sprachspalte)"]
[1]
["English","Deutsch"]
["Reading","Einlesen"]
["ZFG2000 not found. Check serial settings. Switch it on.","ZFG2000 nicht gefunden. Überprüfen Sie, ob das Gerät eingeschaltet oder angeschlossen ist."]
["Card not found. Please insert card.","Karte nicht gefunden. Bitte legen Sie eine Karte ein."]
["zaioser.dll not found.","zaioser.dll wurde nicht gefunden."]
["Reading card ...","Karte lesen ..."]
["Card:","Karte:"]
["records","Datensätze"]
["Bytes #","Bytes #"]
["Card not readable:","Karte nicht lesbar:"]
["Reading raw data","Rohdaten einlesen"]
["record","Datensatz"]
["Ready","Fertig"]
["Reading failed","Einlesen fehlgeschlagen."]
["No data available","Keine Daten vorhanden"]
["Save raw data as","Rohdaten speichern unter"]
["Excel was not able to create all requested sheets.","Nicht alle Protokolle wurden angelegt"]
["You are working with the template (.xlt). It is not possible to use this function. Copy this template into the template directory of Microsoft Office and create a new file using the menu 'File-New' and choose this template there.","Sie arbeiten mit der Vorlage. Übernehmen von Daten ist nicht möglich. Kopieren Sie die Datei in das Office-Vorlagenverzeichnis und öffnen Sie dann diese Vorlage über das Datei-Menu 'Neu'."]
["Delete all data on the card?","Alle Daten auf der Karte löschen?"]
["Card not formated. Please format (delete) card with the tester.","Die Karte ist nicht formatiert. Bitte formatieren Sie die Karte im Gerät."]
["Formating Failed","Formatierung fehlgeschlagen"]
["Testing","Teste"]
["Found","Gefunden"]
["Read card","Karte lesen"]
["card info","Karteninfo"]
["Data->Excel","Daten->Excel"]
["Info","Info"]
["Close","Schließen"]
["Read file","Datei lesen"]
["card reader","Kartenleser"]
["gauge (serial)","Gerät (seriell)"]
["ser. interface:","ser. Schnittstelle:"]
["All","Alle"]
["Delete card","Karte löschen"]
["Search","Suchen"]
["Card reader","Kartenleser"]
["card reader (scard)","Kartenleser (scard)"]
["card reader (PC/SC)","Kartenleser (PC/SC)"]
["an internal error has occured","Es ist ein interner Fehler aufgetreten. Schliessen Sie den SmartcardManager im Systemtray!"]
["No card inserted or card is not formated. Please format the card in the electronic measurement device.","Die Karte ist nicht eingelegt oder nicht formatiert. Bitte löschen (formatieren) Sie die Karte im elektronischen Meßgerät."]
["Please install the newest version of zaioser.dll!","Bitte installieren sie die neueste Version der zaioser.dll!"]
["The card has been removed","Es ist keine Karte eingelegt."]
["transfer only to statistics","nur in Statistik übernehmen"]
["Unknown datasets (wrong device?).","Unbekannte Datensätze (falscher Gerätetyp?)."]
["an internal error has occured","Ein interner Fehler ist aufgetreten."]
["auto load map of GPS position","Lade Landkarten automatisch."]
["-"]
["File"]
["Enter GPS coordinates"]
["Latitude:"]
["Longitude:"]
["OK"]
["Cancel"]
["Enter UTM coordinates"]
["Zone:"]
["Northing:"]
["Easting:"]
["North"]
["Zoom:"]
["Delete"]

{"sheet":"AX01 (0)","index":1,"n_rows":119,"n_cols":14,"rows_kept":119,"merged":[[1,5,1,6],[2,5,2,6],[3,5,3,6],[5,0,5,8],[6,0,6,8],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[18,1,18,3],[30,0,30,3]]}
[]
[{"$nulls":4},"Prüfungs-Nr.:",{"$f":"IF('Statistik stat'!F2=\"\",\"\",'Statistik stat'!F2)","v":""}]
[{"$nulls":4},"Anlage :",{"$f":"IF('Statistik stat'!F3=\"\",\"\",'Statistik stat'!F3)","v":""}]
[{"$nulls":4},"zu :",{"$f":"IF('Statistik stat'!F4=\"\",\"\",'Statistik stat'!F4)","v":""}]
[]
[{"$f":"CONCATENATE(\"Plattendruckversuch DIN 18134-\",TEXT(H14,\"0\"))","v":"Plattendruckversuch DIN 18134-0"}]
["\nPrüfgerät: Plattendruckgerät AX01, Hersteller: Anix GmbH\nAusrüstung: induktiver Wegaufnehmer 15 mm, elektronischer Kraftaufnehmer 100 kN\n"]
[]
["Bauvorhaben :",{"$f":"IF('Statistik stat'!B8=\"\",\"\",'Statistik stat'!B8)","v":""},{"$nulls":4},"Datensatz:",{"$f":"_Datensatznummer","v":0}]
[null,{"$f":"IF('Statistik stat'!B9=\"\",\"\",'Statistik stat'!B9)","v":""},{"$nulls":4},"Kartennr.:",{"$f":"_Kartennummer","v":0}]
[null,{"$f":"IF('Statistik stat'!B10=\"\",\"\",'Statistik stat'!B10)","v":""},{"$nulls":4},"Versuchsbeginn:",{"$f":"_MessDatum","v":"00:00:00"}]
["Auftraggeber :",{"$f":"IF('Statistik stat'!B11=\"\",\"\",'Statistik stat'!B11)","v":""},{"$nulls":4},"Versuchsende:",{"$f":"_MessDatum1","v":"00:00:00"}]
[null,{"$f":"IF('Statistik stat'!B12=\"\",\"\",'Statistik stat'!B12)","v":""},{"$nulls":4},"Gerätenummer:",{"$f":"_Geraetenummer","v":0}]
["Wetter/Temp.:",{"$f":"IF('Statistik stat'!B13=\"\",\"\",'Statistik stat'!B13)","v":""},{"$nulls":4},"Ø-Platte:",{"$f":"_PlattenDurchmesser","v":0}]
["Vortag :",{"$f":"IF('Statistik stat'!B14=\"\",\"\",'Statistik stat'!B14)","v":""},{"$nulls":4},"Hebelverhältnis:",{"$f":"ABS(_Hebelarm)","v":{"v":0,"d":"1:0.00"}}]
["Messstelle:",{"$f":"IF('Statistik stat'!F8=\"\",\"\",'Statistik stat'!F8)","v":""},{"$nulls":3},{"$f":"IF(_cZone=\"\",\"\",\"UTM Zone:\")","v":""},""]
["Prüftiefe:",{"$f":"IF('Statistik stat'!F9=\"\",\"\",'Statistik stat'!F9)","v":""},{"$nulls":3},{"$f":"IF(_cHoch=\"\",\"\",\"Hochwert:\")","v":""},null,{"$f":"IF(_cLat=\"\",\"\",\"geod. Länge:\")","v":""}]
["Prüfschicht:",{"$f":"IF('Statistik stat'!F10=\"\",\"\",'Statistik stat'!F10)","v":""},{"$nulls":3},{"$f":"IF(_cRechts=\"\",\"\",\"Rechtswert:\")","v":""},null,{"$f":"IF(_cLon=\"\",\"\",\"geod. Breite:\")","v":""}]
["Datum:",{"$f":"H11","v":"00:00:00"}]
["Unterlage:",{"$f":"IF('Statistik stat'!F12=\"\",\"\",'Statistik stat'!F12)","v":""}]
["Wassergehalt:",{"$f":"IF('Statistik stat'!G13=\"\",\"\",'Statistik stat'!G13)","v":""}]
[]
[]
["Ergebnisse","Ist-Werte","Sollwerte","Bewertung"]
["Ev1 [MN/m²]",{"$f":"IF(H62=\"\",\"\",ROUNDDOWN(H62,1))","v":{"v":27,"d":"27.0"}},{"$f":"0.6*C26","v":{"v":27,"d":"≥ 27 *)"}},{"$f":"IF(B25=\"\",\"\",IF(B27<=C27,\"\",IF(B25>=C25,\"erfüllt\",\"nicht erfüllt\")))","v":"erfüllt"},"*) 60% von Ev2"]
["Ev2 [MN/m²]",{"$f":"IF(H64=\"\",\"\",ROUNDDOWN(H64,1))","v":{"v":100,"d":"100.0"}},{"$f":"IF('Statistik stat'!D17=\"\",\"\",'Statistik stat'!D17)","v":{"v":45,"d":"≥ 45"}},{"$f":"IF(B26=\"\",\"\",IF(B26>=C26,\"erfüllt\",\"nicht erfüllt\"))","v":"erfüllt"}]
["Ev2 / Ev1",{"$f":"IF(OR(B25=\"\",B26=\"\"),\"\",ROUNDDOWN(H64/H62,2))","v":{"v":3.7,"d":"3.70"}},{"$f":"IF('Statistik stat'!H17=\"\",\"\",'Statistik stat'!H17)","v":{"v":2.5,"d":"≤ 2.5"}},{"$f":"IF(OR(B27=\"\",C27=\"\"),\"\",IF(B27<=C27,\"erfüllt\",IF(B25>=C25,\"\",\"nicht erfüllt\")))","v":""}]
["Ev3",{"$f":"IF(H66<>\"\",ROUNDDOWN(H66,1),\"\")","v":""}]
["Ev3/Ev1",{"$f":"IF(OR(B25=\"\",B28=\"\"),\"\",ROUNDDOWN(H66/H62,2))","v":""}]
[null,null,{"$f":"IF(ISNUMBER(F59),IF(_PlattenDurchmesser=300,\"Bettungsmodul (d=2,22) ks:\",\"Bettungsmodul ks:\"),\"\")","v":""},{"$f":"IF(ISNUMBER(F59),IF(_PlattenDurchmesser=300,IF(F59=\"\",\"\",1000*F59/A59/2.22),1000*F59/A59),\"\")","v":""}]
[{"$f":"IF(AND(OR(D25=\"\",D25=\"erfüllt\"),OR(D26=\"\",D26=\"erfüllt\"),OR(D27=\"\",D27=\"erfüllt\")),\"Die Anforderungen werden erfüllt.\",\"Die Anforderungen werden nicht erfüllt.\")","v":"Die Anforderungen werden erfüllt."}]
["Parameter","a1","a2","s0max [MN/m²]"]
["Ev1",{"$f":"IF(D62=\"\",\"\",D62)","v":""},{"$f":"IF(E62=\"\",\"\",E62)","v":""},{"$f":"IF(G62=\"\",\"\",G62)","v":""}]
["Ev2 ",{"$f":"IF(D64=\"\",\"\",D64)","v":""},{"$f":"IF(E64=\"\",\"\",E64)","v":""},{"$f":"IF(G64=\"\",\"\",G64)","v":""}]
["Ev3",{"$f":"IF(D66=\"\",\"\",D66)","v":""},{"$f":"IF(E66=\"\",\"\",E66)","v":""},{"$f":"IF(G66<>\"\",G66,\"\")","v":""}]
[]
["Bemerkungen:",{"$nulls":4},"Bearbeiter:",{"$f":"IF('Statistik stat'!G30=\"\",\"\",'Statistik stat'!G30)","v":""}]
[]
[]
[{"$nulls":5},"Unterschrift/Stempel"]
[]
["Last-\nstufe","Normalsp.\nso [MN/m²]","Setzung \ns [mm]"]
["Erstbelastung"]
[7,{"v":0,"d":"0.0000"},{"v":0,"d":"0.00"}]
[{"$f":"IF(OFFSET(_MessTab1,0,1,1,1)=\"\",\"\",\"Entlastung\")","v":"Entlastung"}]
[9,{"v":0.1,"d":"0.1000"},{"v":0.1,"d":"0.10"}]
[{"$f":"IF(OFFSET(_MessTab2,0,1,1,1)=\"\",\"\",\"Zweitbelastung\")","v":"Zweitbelastung"}]
[15,{"v":0.2,"d":"0.2000"},{"v":0.2,"d":"0.20"}]
[{"$f":"IF(OFFSET(_MessTab3,0,1,1,1)=\"\",\"\",\"2.Entlastung\")","v":"2.Entlastung"}]
[null,{"v":0.3,"d":"0.3000"},{"v":0.3,"d":"0.30"}]
[{"$f":"IF(OFFSET(_MessTab4,0,1,1,1)=\"\",\"\",\"Drittbelastung\")","v":"Drittbelastung"}]
[null,{"v":0.4,"d":"0.4000"},{"v":0.4,"d":"0.40"}]
[]
[]
[]
[]
[]
["sks","sks korr.","p","q","p/2","s1,25"]
[{"v":1.25,"d":"1.25 mm"},{"$f":"IF(D62=\"\",\"\",_Parameter0+A59)","v":""},{"$f":"IF(OR(E62=0,D62=\"\"),\"\",D62/E62)","v":""},{"$f":"IF(OR(E62=0,E62=\"\"),\"\",(_Parameter0-B59)/E62)","v":""},{"$f":"IF(C59=\"\",\"\",C59/2)","v":""},{"$f":"IF(E62=0,A59/D62,IF(E59=\"\",\"\",IF(E62<0,-E59-SQRT(E59^2-D59),-E59+SQRT(E59^2-D59))))","v":{"$error":"#DIV/0!"}}]
[null,null,"Parameter"]
[null,null,"a0","a1","a2","Index","smax","Ev"]
[{"$nulls":7},27]
[]
[{"$nulls":7},100]
[]
[]
[]
[null,null,"Lat:"]
[null,null,"Lon:"]
[null,null,"Plattendurchmesser:"]
[null,null,"Hebelverhältnis:"]
[null,null,"Datum:"]
[null,null,"Datum (Ende):"]
[null,null,"Gerätenummer:"]
[null,null,"Datensatznummer:"]
[null,null,"Kartennummer:"]
[]
[null,null,"Grenzwerte"]
[null,null,"Ev2","Ev2/Ev1"]
[null,null,45,2.2]
[null,null,80,2.3]
[null,null,100,2.5]
[null,null,120,2.6]
[null,null,150]
[null,null,180]
[]
[null,null,"Kurven"]
[null,null,"Sigma",null,"_Erstbelastung_",null,"_Entlastung_",null,null,"_Zweitbelastung_",null,"_Entlastung_",null,"_Drittbelastung_"]
[null,null,0,{"$f":"IF(C89<=$G$62,C89,$G$62)","v":0},{"$f":"$C$62+$D$62*D89+$E$62*D89*D89","v":0},{"$f":"IF(C89<=$G$63,C89,$G$63)","v":0},{"$f":"$C$63+$D$63*F89+$E$63*F89*F89","v":0},null,{"$f":"IF(C89<=$G$64,C89,$G$64)","v":0},{"$f":"$C$64+$D$64*I89+$E$64*I89*I89","v":0},{"$f":"IF(C89<=$G$77,C89,$G$65)","v":0},{"$f":"$C$65+$D$65*K89+$E$65*K89*K89","v":0},{"$f":"IF(C89<=$G$66,C89,$G$66)","v":0},{"$f":"$C$66+$D$66*M89+$E$66*M89*M89","v":0}]
[null,null,0.02,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.04,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.06,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.08,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.1,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.12,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.14,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.16,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.18,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.2,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.22,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.24,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.26,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.28,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.3,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.32,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.34,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.36,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.38,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.4,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.42,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.44,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.46,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.48,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.5,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.52,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.54,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.56,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.58,0,0,0,0,null,0,0,0,0,0,0]
[null,null,0.6,0,0,0,0,null,0,0,0,0,0,0]

{"sheet":"Statistik stat","index":2,"n_rows":30,"n_cols":8,"rows_kept":30,"merged":[[5,0,5,7],[6,0,6,7]]}
[]
[{"$nulls":4},"Prüfungs-Nr.:"]
[{"$nulls":4},"Anlage :"]
[{"$nulls":4},"zu :"]
[]
["Statischer Plattendruckversuch, Statistische Auswertung "]
["Bestimmung des Verformungsmoduls gemäß  DIN18134-2001 und TP BF-StB, Teil E1: \"Prüfung auf statistischer Grundlage - Stichprobenprüfpläne -\", Ausgabe 1993, Einfachplan - Variablenprüfung; Prüfgerät: Plattendruckgerät AX01, Hersteller: Anix GmbH"]
["Bauvorhaben :",{"$nulls":3},"Messstellen:"]
[{"$nulls":4},"Prüftiefen:"]
[{"$nulls":4},"Prüfschicht:"]
["Auftraggeber:",{"$nulls":3},"Ausgef. auf:"]
[{"$nulls":4},"Plattenunterl.:"]
["Wetter/Temp.:",{"$nulls":4},"Wassergehalt unter d. Platte:"]
["Vortag :"]
["Bemerkung :"]
[]
[null,null,"Anforderungswert (Mindestquantil) Ev2:",45,null,null,"Anforderungswert (Höchstquantil) Ev2/Ev1:",2.5]
[]
["Prüfpunkt-Nr","Messdatum","Messzeit","s1max [MN/m²]","Ev1 [MN/m²]","Ev2  [MN/m²]","Ev2/Ev1","Bemerkungen"]
[]
[]
[{"$nulls":6},{"$f":"IF(E22<>0,F22/E22,\"\")","v":""}]
[]
["Kartennr::","280814091054",null,null,"Arithmetisches Mittel der Stichprobe:",{"$f":"AVERAGE(F20:F23)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G20:G23)","v":{"$error":"#DIV/0!"}}]
["Gerätenr::",4000,null,null,"Standardabweichung:",{"$f":"STDEV(F20:F23)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(G20:G23)","v":{"$error":"#DIV/0!"}}]
["Ø-Platte:",600,null,null,"Variationskoeffizient:",{"$f":"F25/F24","v":{"$error":"#DIV/0!"}},{"$f":"G25/G24","v":{"$error":"#DIV/0!"}}]
["Hebelverhält.:",{"v":2,"d":"1:2.00"},null,null,"Qualitätszahl Q:",{"$f":"(F24-D17)/F25","v":{"$error":"#DIV/0!"}},{"$f":"(H17-G24)/G25","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},"Die Prüfkriterien (Q>0,88) sind ",{"$f":"IF(F27>0.88,\"erfüllt\",\"nicht erfüllt\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(G27>0.88,\"erfüllt\",\"nicht erfüllt\")","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":3},"Barleben, den","2014-08-28T09:57:20","Bearbeiter:"]