{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Start","Daten-Eingabe","Einbereichswaage","Zweibereichswaage","Dreibereichswaage","Zweiteilungswaage","Dreiteilungswaage","Tabelle1"],"not_rendered":{"images":3,"macros":1,"defined_names":7,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":36,"n_cols":5,"rows_kept":36}
[]
[{"$nulls":4},"AG-ME Eichbehörden der Länder"]
[{"$nulls":4},"   - Arbeitsausschuss Waagen -"]
{"$rows_empty":8}
["Kompatibilitätsnachweis von Modulen "]
["an Waagen"]
{"$rows_empty":9}
[null,"Ausdrucke:",null,"Daten,"]
[{"$nulls":3},"Auswertung für: "]
[{"$nulls":4},"      - Einbereichswaagen"]
[{"$nulls":4},"      - Zweibereichswaagen"]
[{"$nulls":4},"      - Dreibereichswaagen"]
[{"$nulls":4},"      - Zweiteilungswaagen"]
[{"$nulls":4},"      - Dreiteilungswaagen "]
[]
[]
[]
[]
[null,"Stand:",null,"26. November 2004"]
[]
[null,"Copyright by AA-Waagen"]

{"sheet":"Daten-Eingabe","index":1,"n_rows":52,"n_cols":10,"rows_kept":52,"merged":[[3,2,3,8],[4,2,4,8],[5,2,5,8],[9,6,9,7],[11,0,11,1],[11,2,11,3],[12,2,12,3],[13,0,13,1],[13,2,13,3],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,0,18,1],[18,6,18,7],[19,6,19,7],[21,6,21,7],[22,0,22,1],[22,6,22,7],[24,6,24,7],[25,6,25,7],[26,0,26,1],[26,6,26,7],[27,0,27,1],[27,6,27,7],[28,6,28,7],[29,0,29,1],[31,0,31,1],[31,6,31,7],[32,6,32,7],[33,0,33,1],[33,6,33,7],[35,6,35,7],[36,6,36,7],[37,0,37,1],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,0,40,1],[40,6,40,7],[41,6,41,7],[42,6,42,7],[43,0,43,1],[43,6,43,7],[44,6,44,7],[46,0,46,1],[46,6,46,7],[48,6,48,7],[50,0,50,4],[50,5,50,9]]}
["Eichbehörden der Länder"]
[]
[]
["Anschrift Waagenbaufirma:"]
[]
[]
[]
["a) Messtechnische und technische Daten",{"$nulls":3},true]
[]
["Waage (NSW)",null," Genauigkeitsklasse",null,"Klasse",null,"III",null,"-"]
["Fabrik-Nr.:",null," Höchstlast"," Eichwert","Max","e",null,null,"kg","kg"]
[{"$nulls":8},"kg","kg"]
["Waagentyp:",{"$nulls":7},"kg","kg"]
[{"$nulls":8},"kg","kg"]
[null,null," Übersetzungsverhältnis",null,"R",{"$nulls":3},"-"]
[null,null," Anzahl der Wägezellen",null,"N",{"$nulls":3},"-"]
[null,null," Einschaltnullstellbereich",null,"IZSR",{"$nulls":3},"kg"]
["Bauartzulassung:",null," Ecklastzuschlag",null,"NUD",{"$nulls":3},"kg"]
[null,null," Totlast",null,"DL",{"$nulls":3},"kg"]
[null,null," additive Tarahöchstlast",null,"T+",{"$nulls":3},"kg"]
[null,null," Grenzen des Temperaturbereichs",null,"Tmin","Tmax",null,null,"° C","° C"]
["Zulassungsinhaber:",null," Kabellänge",null,"L",{"$nulls":3},"m"]
[null,null," Kabelquerschnitt",null,"A",{"$nulls":3},"mm2"]
["Auswertegerät (AWG)"]
["Auswertegerät (AWG)",null," Genauigkeitsklasse",null,"Klasse",{"$nulls":3},"-"]
[" Hersteller:",null," Größte zul. Anzahl der Teilungswerte",null,"nind",{"$nulls":3},"-"]
[null,null," Speisespannung für die Wägezelle(n)",null,"Uexc",{"$nulls":3},"V"]
[null,null," Mindesteingangsspannung des AWG",null,"Umin",{"$nulls":3},"mV"]
[" Typ:",null," Mindestmesssignal pro Eichwert",null,"Dumin",{"$nulls":3},"mV"]
[null,null," Grenzwerte des Lastwiderstandes",null,"RLmin","RLmax",null,null,"W","W"]
[" Prüfbericht/-schein:",null," Grenzen des Temperaturbereichs",null,"Tmin","Tmax",null,null,"° C","° C"]
[null,null," Bruchteil der Eichfehlergrenze",null,"pind",{"$nulls":3},"-"]
["und/oder Bauartzulassung:",null," Anschlußart (4- oder 6 Leitertechnik)",null,"Anzahl Leiter",{"$nulls":3},"-"]
[null,null," max. Kabellänge/Kabelquerschnitt",null,"(L/A)max",{"$nulls":3},"m/mm2"]
[]
["Wägezelle(n) (WZ)",null," Genauigkeitsklasse",null,"Klasse",{"$nulls":3},"-"]
[" Hersteller:",null," Höchstlast ( Nennlast )",null,"Emax",{"$nulls":3},"kg"]
[null,null," Mindestvorlast",null,"Emin",{"$nulls":3},"kg"]
[null,null," Wägezellenkennwert",null,"C",{"$nulls":3},"mV/V"]
[" Typ:",null," Größte zul. Anzahl der Teilungswerte",null,"nLC",{"$nulls":3},"-"]
[null,null," Kleinster zulässiger Teilungswert oder",null,"vmin",{"$nulls":3},"kg"]
[null,null," Höchstteilungsfaktor",null,"Y",{"$nulls":3},"-"]
[" Prüfbericht/-schein:",null," Kriechteilungsfaktor oder",null,"Z",{"$nulls":3},"-"]
[null,null," Rückkehr des Vorlastsignals ",null,"DR",{"$nulls":3},"kg"]
[null,null," Widerstand der (einzelnen) Wägezelle",null,"RLC",{"$nulls":3},"W"]
["oder Bauartzulassung:",null," Grenzen des Temperaturbereichs",null,"Tmin","Tmax",null,null,"° C","° C"]
[null,null," Bruchteil der Eichfehlergrenze",null,"pLC",{"$nulls":3},"-"]
["Verbindungselemente"]
["Verbindungselemente",null," Bruchteil der Eichfehlergrenze",null,"pcon",{"$nulls":3},"-"]
[]
["Die o.a. Module wurden in unveränderter Originalausführung verwendet. Datum und Unterschrift des Beauftragten der Waagenbaufirma:"]
["H201-2_PR00C_Kompatibilitätsnachweis_1-0",{"$nulls":8},"Stand: 30.08.2018"]

{"sheet":"Einbereichswaage","index":2,"n_rows":83,"n_cols":9,"rows_kept":83,"merged":[[3,6,3,8],[32,0,32,5],[34,3,34,4],[47,3,47,4],[52,3,52,4],[66,3,66,4],[67,3,67,4],[69,3,69,4],[70,3,70,4]]}
["Eichbehörden der Länder"]
[]
[]
["b) Nachweis der Kompatibilität - Einbereichswaage",{"$nulls":4},"Fabrik-Nr.:",{"$f":"IF('Daten-Eingabe'!A12=\"\",\"\",'Daten-Eingabe'!A12)","v":""}]
[]
["(1) Genauigkeitsklassen von WZ, AWG und NSW",{"$nulls":7},"I. O. ?"]
[null,{"$f":"IF(B9=\"\",5,IF('Daten-Eingabe'!G36=\"A\",1,IF('Daten-Eingabe'!G36=\"B\",2,IF('Daten-Eingabe'!G36=\"C\",3,IF('Daten-Eingabe'!G36=\"D\",4,0)))))","v":5},null,{"$f":"IF(D9=\"\",5,IF('Daten-Eingabe'!G25=\"I\",1,IF('Daten-Eingabe'!G25=\"II\",2,IF('Daten-Eingabe'!G25=\"III\",3,IF('Daten-Eingabe'!G25=\"IIII\",4,0)))))","v":5},null,null,{"$f":"IF(G9=\"\",0,IF('Daten-Eingabe'!G10=\"I\",1,IF('Daten-Eingabe'!G10=\"II\",2,IF('Daten-Eingabe'!G10=\"III\",3,IF('Daten-Eingabe'!G10=\"IIII\",4,0)))))","v":3}]
[null,"WZ","&","AWG","gleich oder besser als",null,"NSW"]
[null,{"$f":"IF('Daten-Eingabe'!$G$36=\"\",\"\",'Daten-Eingabe'!$G$36)","v":""},"&",{"$f":"IF('Daten-Eingabe'!$G$25=\"\",\"\",'Daten-Eingabe'!$G$25)","v":""},"gleich oder besser als",null,{"$f":"IF('Daten-Eingabe'!$G$10=\"\",\"\",'Daten-Eingabe'!$G$10)","v":"III"},null,{"$f":"IF($G$7=0,\"NEIN\",IF($B$7>$G$7,\"NEIN\",IF($D$7>$G$7,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["(2) Temperaturbereiche von WZ und AWG im Vergleich zum Temperaturbereich der NSW   in ° C"]
[]
[null,null,"WZ",null,"AWG",null,"NSW"]
[null,"Tmin",{"$f":"IF('Daten-Eingabe'!$G$46=\"\",\"\",'Daten-Eingabe'!$G$46)","v":""},"&",{"$f":"IF('Daten-Eingabe'!$G$31=\"\",\"\",'Daten-Eingabe'!$G$31)","v":""},"£",{"$f":"IF('Daten-Eingabe'!$G$21=\"\",\"\",'Daten-Eingabe'!$G$21)","v":""},null,{"$f":"IF(OR($G$14=\"\",$G$14>100),\"NEIN\",IF($C$14>$G$14,\"NEIN\",IF($E$14>$G$14,\"NEIN\",\"JA\")))","v":"NEIN"}]
[null,"Tmax",{"$f":"IF('Daten-Eingabe'!$H$46=\"\",\"\",'Daten-Eingabe'!$H$46)","v":""},"&",{"$f":"IF('Daten-Eingabe'!$H$31=\"\",\"\",'Daten-Eingabe'!$H$31)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$21=\"\",\"\",'Daten-Eingabe'!$H$21)","v":""},null,{"$f":"IF(OR($C15>150,$E$15>100),\"NEIN\",IF($G$15=\"\",\"NEIN\",IF($C$15<$G$15,\"NEIN\",IF($E$15<$G$15,\"NEIN\",\"JA\"))))","v":"NEIN"}]
[]
["(3) Summe der Quadrate der Fehlergrenzenanteile von Verbindungselementen, AWG und WZ"]
[]
[null,"pcon2","+","pind2","+","pLC2","£ 1"]
[null,{"$f":"IF('Daten-Eingabe'!$G$49=\"\",\"\",'Daten-Eingabe'!$G$49^2)","v":""},"+",{"$f":"IF('Daten-Eingabe'!$G$32=\"\",\"\",'Daten-Eingabe'!$G$32^2)","v":""},"+",{"$f":"IF('Daten-Eingabe'!$G$47=\"\",\"\",'Daten-Eingabe'!$G$47^2)","v":""},"£ 1",null,{"$f":"IF(OR($F$20=\"\",$F$20>(0.8)^2,$F$20<(0.3)^2,$D$20=\"\",$D$20>(0.8)^2,$D$20<(0.3)^2,$B$20=\"\"),\"NEIN\",IF($B$20+$D$20+$F$20>1,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(4) Größte zul. Anzahl der Teilungswerte des AWG und Anzahl der Eichwerte der NSW"]
[]
[{"$nulls":4},"nind","³","n= Max/ e"]
[null,null," Einbereichswaage",null,{"$f":"IF('Daten-Eingabe'!$G$26=\"\",\"\",'Daten-Eingabe'!$G$26)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$11=\"\",\"\",IF('Daten-Eingabe'!$H$11=0,\"\",'Daten-Eingabe'!$G$11/'Daten-Eingabe'!$H$11))","v":""},null,{"$f":"IF(OR($E$25=\"\",$E$25>100000000,$G$25=\"\"),\"NEIN\",IF($G$25>$E$25,\"NEIN\",\"JA\"))","v":"NEIN"}]
[null," Mehrteilungs- ",null,"i = 1",0,"³",0]
[null," oder Mehrbereichswaage",null,"i = 2",0,"³",0]
[{"$nulls":3},"i = 3",0,"³",0]
[]
[]
["5) Höchstlasten von NSW und WZ"]
[]
["Last-Korrekturfaktor: Q = (Max+DL+IZSR+NUD+T+)/Max =",{"$nulls":5},{"$f":"IF('Daten-Eingabe'!$G$19=\"\",\"DL fehlt\",IF('Daten-Eingabe'!$G$18=\"\",\"NUD fehlt\",IF('Daten-Eingabe'!$G$17=\"\",\"IZRS fehlt\",IF('Daten-Eingabe'!$G$11=\"\",\"\",IF('Daten-Eingabe'!$G$11=0,\"\",('Daten-Eingabe'!$G$11+'Daten-Eingabe'!$G$17+'Daten-Eingabe'!$G$18+'Daten-Eingabe'!$G$19+'Daten-Eingabe'!$G$20)/'Daten-Eingabe'!$G$11)))))","v":"DL fehlt"}]
[{"$nulls":3},"(Q*Max*R)/N",null,"£","Emax"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$15=\"\",\"R fehlt\",IF($G$33=\"\",\"Q fehlt\",IF('Daten-Eingabe'!$G$16=\"\",\"Anzahl  N  fehlt\",($G$33*'Daten-Eingabe'!$G$11*'Daten-Eingabe'!$G$15)/'Daten-Eingabe'!$G$16)))","v":"R fehlt"},null,"£",{"$f":"IF('Daten-Eingabe'!$G$37=\"\",\"\",'Daten-Eingabe'!$G$37)","v":""},null,{"$f":"IF(OR($G$33=\"\",$G$35=\"\",$G$35>10000000),\"NEIN\",IF($D$35>$G$35,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(6a) Größte zul. Anzahl der Teilungswerte der WZ und Anzahl der Eichwerte der NSW "]
[]
[{"$nulls":4},"nLC","³","n= Max/ e"]
[null,null," Einbereichswaage",null,{"$f":"IF('Daten-Eingabe'!$G$40=\"\",\"\",'Daten-Eingabe'!$G$40)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$11=\"\",\"\",IF('Daten-Eingabe'!$H$11=\"\",\"\",'Daten-Eingabe'!$G$11/'Daten-Eingabe'!$H$11))","v":""},null,{"$f":"IF(OR($G$40=0,$G$40=\"\",$E$40=\"\",$E$40>100000000),\"NEIN\",IF($G$40>$E$40,\"NEIN\",\"JA\"))","v":"NEIN"}]
[null," Mehrteilungs- ",null,"i = 1",0,"³",0]
[null," oder Mehrbereichswaage",null,"i = 2",0,"³",0]
[{"$nulls":3},"i = 3",0,"³",0]
[]
["(6b) Rückkehr des Vorlastsignals der WZ und kleinster Eichwert e1 einer Mehrteilungswaage"]
[]
[{"$nulls":3},"n LC oder Z=Emax/(2*DR) ",null,"³","Maxr / e1"]
[{"$nulls":3},0,null,"³",0]
[]
["(6c) Rückkehr des Vorlastsignals der WZ und kleinster Eichwert e1 einer Mehrbereichswaage"]
[]
[{"$nulls":3},"nLC oder Z=Emax/(2*DR) ",null,"³","0,4*Maxr/e1"]
[{"$nulls":3},0,null,"³",0]
[]
["(6d) Totlast des Lastträgers der Waagenbrücke und Mindestvorlast der WZ  in kg"]
[]
[{"$nulls":4},"DL*R/N","³","Emin"]
[{"$nulls":4},{"$f":"IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$G$19*'Daten-Eingabe'!$G$15/'Daten-Eingabe'!$G$16))","v":""},"³",{"$f":"IF('Daten-Eingabe'!$G$38=\"\",\"\",'Daten-Eingabe'!$G$38)","v":""},null,{"$f":"IF(OR($E$58=\"\",$G$58=\"\"),\"NEIN\",IF($G$58>$E$58,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(7) Eichwert der NSW und kleinster zulässiger Teilungswert der WZ  in  kg"]
[]
[{"$nulls":4},"e*R/ ÖN","³","vmin = Emax /Y"]
[{"$nulls":4},{"$f":"IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$H$11*'Daten-Eingabe'!$G$15/'Daten-Eingabe'!$G$16^0.5))","v":""},"³",{"$f":"IF('Daten-Eingabe'!$G$37=\"\",\"\",IF('Daten-Eingabe'!$G$42<>0,'Daten-Eingabe'!$G$37/'Daten-Eingabe'!$G$42,IF('Daten-Eingabe'!$G$41<>0,'Daten-Eingabe'!$G$41,IF('Daten-Eingabe'!$G$40=0,\"\",'Daten-Eingabe'!$G$37/'Daten-Eingabe'!$G$40))))","v":""},null,{"$f":"IF(OR($E$63=\"\",$G$63=\"\"),\"NEIN\",IF($G$63>$E$63,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(8) Mindesteingangssignal für AWG, Mindestmesssignal pro Eichwert und Berechnung "]
[]
[null,null,"Mindesteingangssignal  in  mV","U= C*Uexc*R*DL/(Emax *N)",null,"³","Umin"]
[null,null,"(entlastete Waage)",{"$f":"IF('Daten-Eingabe'!$G$39=\"\",\"\",IF(OR('Daten-Eingabe'!$G$37=0,'Daten-Eingabe'!$G$16=0),\"\",'Daten-Eingabe'!$G$39*'Daten-Eingabe'!$G$27*'Daten-Eingabe'!$G$15*'Daten-Eingabe'!$G$19/('Daten-Eingabe'!$G$37*'Daten-Eingabe'!$G$16)))","v":""},null,"³",{"$f":"IF('Daten-Eingabe'!$G$28=\"\",\"\",'Daten-Eingabe'!$G$28)","v":""},null,{"$f":"IF(OR($D$68>1000000,$G$68=\"\",$D$68=\"\"),\"NEIN\",IF($G$68>$D$68,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
[null,null,"Mindestsignal pro Eichwert in mV","Du = C*Uexc*R*e/(Emax *N)",null,"³","Dumin"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$39=\"\",\"\",IF(OR('Daten-Eingabe'!$G$37=0,'Daten-Eingabe'!$G$16=0),\"\",'Daten-Eingabe'!$G$39*1000*'Daten-Eingabe'!$G$27*'Daten-Eingabe'!$G$15*'Daten-Eingabe'!$H$11/('Daten-Eingabe'!$G$37*'Daten-Eingabe'!$G$16)))","v":""},null,"³",{"$f":"IF('Daten-Eingabe'!$G$29=\"\",\"\",'Daten-Eingabe'!$G$29)","v":""},null,{"$f":"IF(OR($D$71>1000000,$G$71=\"\",$D$71=\"\"),\"NEIN\",IF($G$71>$D$71,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(9) Vergleich der Lastwiderstände von AWG und WZ  in  W"]
[]
[null,null,"RLmin","£","RLC / N","£","RLmax"]
[null,null,{"$f":"IF('Daten-Eingabe'!$G$30=\"\",\"fehlt\",'Daten-Eingabe'!$G$30)","v":"fehlt"},"£",{"$f":"IF('Daten-Eingabe'!G45=\"\",\"R LC  fehlt\",IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$G$45/'Daten-Eingabe'!$G$16)))","v":"R LC  fehlt"},"£",{"$f":"IF('Daten-Eingabe'!$H$30>1000000,\"fehlt\",IF('Daten-Eingabe'!$H$30=\"\",\"fehlt\",'Daten-Eingabe'!$H$30))","v":"fehlt"},null,{"$f":"IF($C$76=0,\"NEIN\",IF($G$76=\"fehlt\",\"NEIN\",IF($E$76=\"\",\"NEIN\",IF($E$76<$C$76,\"NEIN\",IF($E$76>$G$76,\"NEIN\",\"JA\")))))","v":"NEIN"}]
[]
["(10) Verlängerungskabel zum Anschluss der WZ: Kabellänge pro Leiterquerschnitt  in  m/mm²"]
[]
[{"$nulls":4},"(L/A)","£","(L/A)max"]
[{"$nulls":4},{"$f":"IF(OR('Daten-Eingabe'!$G$23=\"\",'Daten-Eingabe'!$G$23=0),\"\",'Daten-Eingabe'!$G$22/'Daten-Eingabe'!$G$23)","v":""},"£",{"$f":"IF('Daten-Eingabe'!$G$34=\"\",\"\",'Daten-Eingabe'!$G$34)","v":""},null,{"$f":"IF($G$81>1000000,\"NEIN\",IF($G$81=\"\",\"NEIN\",IF($G$81<$E$81,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["H201-2_PR00C_Kompatibilitätsnachweis_1-0",{"$nulls":7},"Stand: 30.08.2018"]

{"sheet":"Zweibereichswaage","index":3,"n_rows":83,"n_cols":9,"rows_kept":83,"hidden":true,"merged":[[3,6,3,8],[32,0,32,5],[34,3,34,4],[47,3,47,4],[52,3,52,4],[66,3,66,4],[67,3,67,4],[69,3,69,4],[70,3,70,4]]}
["Eichbehörden der Länder"]
[]
[]
["b) Nachweis der Kompatibilität - Zweibereichswaage",{"$nulls":4},"Fabrik-Nr.:",{"$f":"IF('Daten-Eingabe'!A12=\"\",\"\",'Daten-Eingabe'!A12)","v":""}]
[]
["(1) Genauigkeitsklassen von WZ, AWG und NSW",{"$nulls":7},"I. O. ?"]
[null,{"$f":"IF(B9=\"\",5,IF('Daten-Eingabe'!G36=\"A\",1,IF('Daten-Eingabe'!G36=\"B\",2,IF('Daten-Eingabe'!G36=\"C\",3,IF('Daten-Eingabe'!G36=\"D\",4,0)))))","v":5},null,{"$f":"IF(D9=\"\",5,IF('Daten-Eingabe'!G25=\"I\",1,IF('Daten-Eingabe'!G25=\"II\",2,IF('Daten-Eingabe'!G25=\"III\",3,IF('Daten-Eingabe'!G25=\"IIII\",4,0)))))","v":5},null,null,{"$f":"IF(G9=\"\",0,IF('Daten-Eingabe'!G10=\"I\",1,IF('Daten-Eingabe'!G10=\"II\",2,IF('Daten-Eingabe'!G10=\"III\",3,IF('Daten-Eingabe'!G10=\"IIII\",4,0)))))","v":3}]
[null,"WZ","&","AWG","gleich oder besser als",null,"NSW"]
[null,{"$f":"IF('Daten-Eingabe'!$G$36=\"\",\"\",'Daten-Eingabe'!$G$36)","v":""},"&",{"$f":"IF('Daten-Eingabe'!$G$25=\"\",\"\",'Daten-Eingabe'!$G$25)","v":""},"gleich oder besser als",null,{"$f":"IF('Daten-Eingabe'!$G$10=\"\",\"\",'Daten-Eingabe'!$G$10)","v":"III"},null,{"$f":"IF($G$7=0,\"NEIN\",IF($B$7>$G$7,\"NEIN\",IF($D$7>$G$7,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["(2) Temperaturbereiche von WZ und AWG im Vergleich zum Temperaturbereich der NSW   in ° C"]
[]
[null,null,"WZ",null,"AWG",null,"NSW"]
[null,"Tmin",{"$f":"IF('Daten-Eingabe'!G46=\"\",\"\",'Daten-Eingabe'!G46)","v":""},"&",{"$f":"IF('Daten-Eingabe'!G31=\"\",\"\",'Daten-Eingabe'!G31)","v":""},"£",{"$f":"IF('Daten-Eingabe'!G21=\"\",\"\",'Daten-Eingabe'!G21)","v":""},null,{"$f":"IF(OR($G$14=\"\",$G$14>100),\"NEIN\",IF($C$14>$G$14,\"NEIN\",IF($E$14>$G$14,\"NEIN\",\"JA\")))","v":"NEIN"}]
[null,"Tmax",{"$f":"IF('Daten-Eingabe'!H46=\"\",\"\",'Daten-Eingabe'!H46)","v":""},"&",{"$f":"IF('Daten-Eingabe'!H31=\"\",\"\",'Daten-Eingabe'!H31)","v":""},"³",{"$f":"IF('Daten-Eingabe'!H21=\"\",\"\",'Daten-Eingabe'!H21)","v":""},null,{"$f":"IF(OR($C15>150,$E$15>100),\"NEIN\",IF($G$15=\"\",\"NEIN\",IF($C$15<$G$15,\"NEIN\",IF($E$15<$G$15,\"NEIN\",\"JA\"))))","v":"NEIN"}]
[]
["(3) Summe der Quadrate der Fehlergrenzenanteile von Verbindungselementen, AWG und WZ"]
[]
[null,"pcon2","+","pind2","+","pLC2","£ 1"]
[null,{"$f":"IF('Daten-Eingabe'!$G$49=\"\",\"\",'Daten-Eingabe'!$G$49^2)","v":""},"+",{"$f":"IF('Daten-Eingabe'!$G$32=\"\",\"\",'Daten-Eingabe'!$G$32^2)","v":""},"+",{"$f":"IF('Daten-Eingabe'!$G$47=\"\",\"\",'Daten-Eingabe'!$G$47^2)","v":""},"£ 1",null,{"$f":"IF(OR($F$20=\"\",$F$20>(0.8)^2,$F$20<(0.3)^2,$D$20=\"\",$D$20>(0.8)^2,$D$20<(0.3)^2,$B$20=\"\"),\"NEIN\",IF($B$20+$D$20+$F$20>1,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(4) Größte zul. Anzahl der Teilungswerte des AWG und Anzahl der Eichwerte der NSW"]
[]
[{"$nulls":4},"nind","³","n(i) =Max(i) /e(i)"]
[null," Einbereichswaage",null,null,{"$f":"'Daten-Eingabe'!G26","v":0},"³",{"$f":"IF('Daten-Eingabe'!H11=0,0,'Daten-Eingabe'!G11/'Daten-Eingabe'!H11)","v":0}]
[null," Mehrbereichswaage (2)",null,"i = 1",{"$f":"IF('Daten-Eingabe'!$G$26=\"\",\"\",'Daten-Eingabe'!$G$26)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$12=\"\",\"\",IF('Daten-Eingabe'!$H$12=0,\"\",'Daten-Eingabe'!$G$12/'Daten-Eingabe'!$H$12))","v":""},null,{"$f":"IF(OR($E$26=\"\",$E$26>100000000,$G$26=\"\"),\"NEIN\",IF($G$26>$E$26,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 2",{"$f":"IF('Daten-Eingabe'!$G$26=\"\",\"\",'Daten-Eingabe'!$G$26)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$13=\"\",\"\",IF('Daten-Eingabe'!$H$13=0,\"\",'Daten-Eingabe'!$G$13/'Daten-Eingabe'!$H$13))","v":""},null,{"$f":"IF(OR($E$27=\"\",$E$27>100000000,$G$27=\"\"),\"NEIN\",IF($G$27>$E$27,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 3",0,"³",0]
[]
[]
["5) Höchstlasten von NSW und WZ"]
[]
["Last-Korrekturfaktor: Q = (Max2+DL+IZSR+NUD+T+)/Max2 =",{"$nulls":5},{"$f":"IF('Daten-Eingabe'!$G$19=\"\",\"DL fehlt\",IF('Daten-Eingabe'!$G$18=\"\",\"NUD fehlt\",IF('Daten-Eingabe'!$G$17=\"\",\"IZRS fehlt\",IF('Daten-Eingabe'!$G$13=\"\",\"\",IF('Daten-Eingabe'!$G$13=0,\"\",('Daten-Eingabe'!$G$13+'Daten-Eingabe'!$G$17+'Daten-Eingabe'!$G$18+'Daten-Eingabe'!$G$19+'Daten-Eingabe'!$G$20)/'Daten-Eingabe'!$G$13)))))","v":"DL fehlt"}]
[{"$nulls":3},"(Q*Max2*R)/N",null,"£","Emax"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$15=\"\",\"R fehlt\",IF($G$33=\"\",\"Q fehlt\",IF('Daten-Eingabe'!$G$16=\"\",\"Anzahl  N  fehlt\",($G$33*'Daten-Eingabe'!$G$13*'Daten-Eingabe'!$G$15)/'Daten-Eingabe'!$G$16)))","v":"R fehlt"},null,"£",{"$f":"IF('Daten-Eingabe'!$G$37=\"\",\"\",'Daten-Eingabe'!$G$37)","v":""},null,{"$f":"IF(OR($G$33=\"\",$G$35=\"\",$G$35>10000000),\"NEIN\",IF($D$35>$G$35,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(6a) Größte zul. Anzahl der Teilungswerte der WZ und Anzahl der Eichwerte der NSW "]
[]
[{"$nulls":4},"nLC","³","n(i) = Max(i) /e(i)"]
[null," Einbereichswaage",null,null,{"$f":"'Daten-Eingabe'!G40","v":0},"³",{"$f":"IF('Daten-Eingabe'!H11=0,0,'Daten-Eingabe'!G11/'Daten-Eingabe'!H11)","v":0}]
[null," Mehrbereichswaage (2) ",null,"i = 1",{"$f":"IF('Daten-Eingabe'!$G$40=\"\",\"\",'Daten-Eingabe'!$G$40)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$12=\"\",\"\",IF('Daten-Eingabe'!$H$12=0,\"\",'Daten-Eingabe'!$G$12/'Daten-Eingabe'!$H$12))","v":""},null,{"$f":"IF(OR($G$41=0,$G$41=\"\",$E$41=\"\",$E$41>100000000),\"NEIN\",IF($G$41>$E$41,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 2",{"$f":"IF('Daten-Eingabe'!$G$40=\"\",\"\",'Daten-Eingabe'!$G$40)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$13=\"\",\"\",IF('Daten-Eingabe'!$H$13=0,\"\",'Daten-Eingabe'!$G$13/'Daten-Eingabe'!$H$13))","v":""},null,{"$f":"IF(OR($G$42=0,$G$42=\"\",$E$42=\"\",$E$42>100000000),\"NEIN\",IF($G$42>$E$42,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 3",0,"³",0]
[]
["(6b) Rückkehr des Vorlastsignals der WZ und kleinster Eichwert e1 einer Mehrteilungswaage"]
[]
[{"$nulls":3},"n LC oder Z=Emax/(2*DR) ",null,"³","Maxr / e1"]
[{"$nulls":3},0,null,"³",{"$f":"IF('Daten-Eingabe'!H21=0,0,'Daten-Eingabe'!G21/'Daten-Eingabe'!H21)","v":0}]
[]
["(6c) Rückkehr des Vorlastsignals der WZ und kleinster Eichwert e1 einer Mehrbereichswaage"]
[]
[{"$nulls":3},"nLC oder Z = Emax /(2*DR) ",null,"³","0,4*Max2 /e1"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$43<>0,'Daten-Eingabe'!$G$43,(IF('Daten-Eingabe'!$G$44<>0,'Daten-Eingabe'!$G$37/(2*'Daten-Eingabe'!$G$44),'Daten-Eingabe'!$G$40)))","v":0},null,"³",{"$f":"IF('Daten-Eingabe'!$H$12=\"\",\"\",IF('Daten-Eingabe'!$H$12=0,\"\",'Daten-Eingabe'!$G$13/'Daten-Eingabe'!$H$12*0.4))","v":""},null,{"$f":"IF($D$53>10000000,\"NEIN\",IF($G$53=\"\",\"NEIN\",IF($G$53>$D$53,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["(6d) Totlast des Lastträgers der Waagenbrücke und Mindestvorlast der WZ  in kg"]
[]
[{"$nulls":4},"DL*R/N","³","Emin"]
[{"$nulls":4},{"$f":"IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$G$19*'Daten-Eingabe'!$G$15/'Daten-Eingabe'!$G$16))","v":""},"³",{"$f":"IF('Daten-Eingabe'!$G$38=\"\",\"\",'Daten-Eingabe'!$G$38)","v":""},null,{"$f":"IF(OR($E$58=\"\",$G$58=\"\"),\"NEIN\",IF($G$58>$E$58,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(7) Eichwert der NSW und kleinster zulässiger Teilungswert der WZ  in  kg"]
[]
[{"$nulls":4},"e1*R/ ÖN","³","vmin = Emax /Y"]
[{"$nulls":4},{"$f":"IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$H$12*'Daten-Eingabe'!$G$15/'Daten-Eingabe'!$G$16^0.5))","v":""},"³",{"$f":"IF('Daten-Eingabe'!$G$37=\"\",\"\",IF('Daten-Eingabe'!$G$42<>0,'Daten-Eingabe'!$G$37/'Daten-Eingabe'!$G$42,IF('Daten-Eingabe'!$G$41<>0,'Daten-Eingabe'!$G$41,IF('Daten-Eingabe'!$G$40=0,\"\",'Daten-Eingabe'!$G$37/'Daten-Eingabe'!$G$40))))","v":""},null,{"$f":"IF(OR($E$63=\"\",$G$63=\"\"),\"NEIN\",IF($G$63>$E$63,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(8) Mindesteingangssignal für AWG, Mindestmesssignal pro Eichwert und Berechnung"]
[]
[null,null,"Mindesteingangssignal  in  mV","U= C*Uexc*R*DL/(Emax *N)",null,"³","Umin"]
[null,null,"(entlastete Waage)",{"$f":"IF('Daten-Eingabe'!$G$39=\"\",\"\",IF(OR('Daten-Eingabe'!$G$37=0,'Daten-Eingabe'!$G$16=0),\"\",'Daten-Eingabe'!$G$39*'Daten-Eingabe'!$G$27*'Daten-Eingabe'!$G$15*'Daten-Eingabe'!$G$19/('Daten-Eingabe'!$G$37*'Daten-Eingabe'!$G$16)))","v":""},null,"³",{"$f":"IF('Daten-Eingabe'!$G$28=\"\",\"\",'Daten-Eingabe'!$G$28)","v":""},null,{"$f":"IF(OR($D$68>1000000,$G$68=\"\",$D$68=\"\"),\"NEIN\",IF($G$68>$D$68,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
[null,null,"Mindestsignal pro Eichwert in mV","Du = C*Uexc*R*e/(Emax *N)",null,"³","Dumin"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$39=\"\",\"\",IF(OR('Daten-Eingabe'!$G$37=0,'Daten-Eingabe'!$G$16=0),\"\",'Daten-Eingabe'!$G$39*1000*'Daten-Eingabe'!$G$27*'Daten-Eingabe'!$G$15*'Daten-Eingabe'!$H$12/('Daten-Eingabe'!$G$37*'Daten-Eingabe'!$G$16)))","v":""},null,"³",{"$f":"'Daten-Eingabe'!$G$29","v":0},null,{"$f":"IF(OR($D$71>1000000,$G$71=\"\",$D$71=\"\"),\"NEIN\",IF($G$71>$D$71,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(9) Vergleich der Lastwiderstände von AWG und WZ  in  W"]
[]
[null,null,"RLmin","£","RLC / N","£","RLmax"]
[null,null,{"$f":"IF('Daten-Eingabe'!$G$30=\"\",\"fehlt\",'Daten-Eingabe'!$G$30)","v":"fehlt"},"£",{"$f":"IF('Daten-Eingabe'!G45=\"\",\"R LC  fehlt\",IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$G$45/'Daten-Eingabe'!$G$16)))","v":"R LC  fehlt"},"£",{"$f":"IF('Daten-Eingabe'!$H$30>1000000,\"fehlt\",IF('Daten-Eingabe'!$H$30=\"\",\"fehlt\",'Daten-Eingabe'!$H$30))","v":"fehlt"},null,{"$f":"IF($C$76=0,\"NEIN\",IF($G$76=\"fehlt\",\"NEIN\",IF($E$76=\"\",\"NEIN\",IF($E$76<$C$76,\"NEIN\",IF($E$76>$G$76,\"NEIN\",\"JA\")))))","v":"NEIN"}]
[]
["(10) Verlängerungskabel zum Anschluss der WZ: Kabellänge pro Leiterquerschnitt  in  m/mm²"]
[]
[{"$nulls":4},"(L/A)","£","(L/A)max"]
[{"$nulls":4},{"$f":"IF(OR('Daten-Eingabe'!$G$23=\"\",'Daten-Eingabe'!$G$23=0),\"\",'Daten-Eingabe'!$G$22/'Daten-Eingabe'!$G$23)","v":""},"£",{"$f":"IF('Daten-Eingabe'!$G$34=\"\",\"\",'Daten-Eingabe'!$G$34)","v":""},null,{"$f":"IF($G$81>1000000,\"NEIN\",IF($G$81=\"\",\"NEIN\",IF($G$81<$E$81,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["H201-2_PR00C_Kompatibilitätsnachweis_1-0",{"$nulls":7},"Stand: 30.08.2018"]

{"sheet":"Dreibereichswaage","index":4,"n_rows":83,"n_cols":9,"rows_kept":83,"hidden":true,"merged":[[3,6,3,8],[32,0,32,5],[34,3,34,4],[47,3,47,4],[52,3,52,4],[66,3,66,4],[67,3,67,4],[69,3,69,4],[70,3,70,4]]}
["Eichbehörden der Länder"]
[]
[]
["b) Nachweis der Kompatibilität - Dreibereichswaage",{"$nulls":4},"Fabrik-Nr.:",{"$f":"IF('Daten-Eingabe'!A12=\"\",\"\",'Daten-Eingabe'!A12)","v":""}]
[]
["(1) Genauigkeitsklassen von WZ, AWG und NSW",{"$nulls":7},"I. O. ?"]
[null,{"$f":"IF(B9=\"\",5,IF('Daten-Eingabe'!G36=\"A\",1,IF('Daten-Eingabe'!G36=\"B\",2,IF('Daten-Eingabe'!G36=\"C\",3,IF('Daten-Eingabe'!G36=\"D\",4,0)))))","v":5},null,{"$f":"IF(D9=\"\",5,IF('Daten-Eingabe'!G25=\"I\",1,IF('Daten-Eingabe'!G25=\"II\",2,IF('Daten-Eingabe'!G25=\"III\",3,IF('Daten-Eingabe'!G25=\"IIII\",4,0)))))","v":5},null,null,{"$f":"IF(G9=\"\",0,IF('Daten-Eingabe'!G10=\"I\",1,IF('Daten-Eingabe'!G10=\"II\",2,IF('Daten-Eingabe'!G10=\"III\",3,IF('Daten-Eingabe'!G10=\"IIII\",4,0)))))","v":3}]
[null,"WZ","&","AWG","gleich oder besser als",null,"NSW"]
[null,{"$f":"IF('Daten-Eingabe'!$G$36=\"\",\"\",'Daten-Eingabe'!$G$36)","v":""},"&",{"$f":"IF('Daten-Eingabe'!$G$25=\"\",\"\",'Daten-Eingabe'!$G$25)","v":""},"gleich oder besser als",null,{"$f":"IF('Daten-Eingabe'!$G$10=\"\",\"\",'Daten-Eingabe'!$G$10)","v":"III"},null,{"$f":"IF($G$7=0,\"NEIN\",IF($B$7>$G$7,\"NEIN\",IF($D$7>$G$7,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["(2) Temperaturbereiche von WZ und AWG im Vergleich zum Temperaturbereich der NSW   in ° C"]
[]
[null,null,"WZ",null,"AWG",null,"NSW"]
[null,"Tmin",{"$f":"IF('Daten-Eingabe'!G46=\"\",\"\",'Daten-Eingabe'!G46)","v":""},"&",{"$f":"IF('Daten-Eingabe'!G31=\"\",\"\",'Daten-Eingabe'!G31)","v":""},"£",{"$f":"IF('Daten-Eingabe'!G21=\"\",\"\",'Daten-Eingabe'!G21)","v":""},null,{"$f":"IF(OR($G$14=\"\",$G$14>100),\"NEIN\",IF($C$14>$G$14,\"NEIN\",IF($E$14>$G$14,\"NEIN\",\"JA\")))","v":"NEIN"}]
[null,"Tmax",{"$f":"IF('Daten-Eingabe'!H46=\"\",\"\",'Daten-Eingabe'!H46)","v":""},"&",{"$f":"IF('Daten-Eingabe'!H31=\"\",\"\",'Daten-Eingabe'!H31)","v":""},"³",{"$f":"IF('Daten-Eingabe'!H21=\"\",\"\",'Daten-Eingabe'!H21)","v":""},null,{"$f":"IF(OR($C15>150,$E$15>100),\"NEIN\",IF($G$15=\"\",\"NEIN\",IF($C$15<$G$15,\"NEIN\",IF($E$15<$G$15,\"NEIN\",\"JA\"))))","v":"NEIN"}]
[]
["(3) Summe der Quadrate der Fehlergrenzenanteile von Verbindungselementen, AWG und WZ"]
[]
[null,"pcon2","+","pind2","+","pLC2","£ 1"]
[null,{"$f":"IF('Daten-Eingabe'!$G$49=\"\",\"\",'Daten-Eingabe'!$G$49^2)","v":""},"+",{"$f":"IF('Daten-Eingabe'!$G$32=\"\",\"\",'Daten-Eingabe'!$G$32^2)","v":""},"+",{"$f":"IF('Daten-Eingabe'!$G$47=\"\",\"\",'Daten-Eingabe'!$G$47^2)","v":""},"£ 1",null,{"$f":"IF(OR($F$20=\"\",$F$20>(0.8)^2,$F$20<(0.3)^2,$D$20=\"\",$D$20>(0.8)^2,$D$20<(0.3)^2,$B$20=\"\"),\"NEIN\",IF($B$20+$D$20+$F$20>1,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(4) Größte zul. Anzahl der Teilungswerte des AWG und Anzahl der Eichwerte der NSW"]
[]
[{"$nulls":4},"nind","³","n(i) = Max(i) /e(i)"]
[null," Mehrbereichswaage",null,null,{"$f":"'Daten-Eingabe'!G26","v":0},"³",{"$f":"IF('Daten-Eingabe'!H11=0,0,'Daten-Eingabe'!G11/'Daten-Eingabe'!H11)","v":0}]
[null," Mehrbereichswaage (3)",null,"i = 1",{"$f":"IF('Daten-Eingabe'!$G$26=\"\",\"\",'Daten-Eingabe'!$G$26)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$12=\"\",\"\",IF('Daten-Eingabe'!$H$12=0,\"\",'Daten-Eingabe'!$G$12/'Daten-Eingabe'!$H$12))","v":""},null,{"$f":"IF(OR($E$26=\"\",$E$26>100000000,$G$26=\"\"),\"NEIN\",IF($G$26>$E$26,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 2",{"$f":"IF('Daten-Eingabe'!$G$26=\"\",\"\",'Daten-Eingabe'!$G$26)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$13=\"\",\"\",IF('Daten-Eingabe'!$H$13=0,\"\",'Daten-Eingabe'!$G$13/'Daten-Eingabe'!$H$13))","v":""},null,{"$f":"IF(OR($E$27=\"\",$E$27>100000000,$G$27=\"\"),\"NEIN\",IF($G$27>$E$27,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 3",{"$f":"IF('Daten-Eingabe'!$G$26=\"\",\"\",'Daten-Eingabe'!$G$26)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$14=\"\",\"\",IF('Daten-Eingabe'!$H$14=0,\"\",'Daten-Eingabe'!$G$14/'Daten-Eingabe'!$H$14))","v":""},null,{"$f":"IF(OR($E$28=\"\",$E$28>100000000,$G$28=\"\"),\"NEIN\",IF($G$28>$E$28,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
[]
["5) Höchstlasten von NSW und WZ"]
[]
["Last-Korrekturfaktor: Q = (Max3+DL+IZSR+NUD+T+)/Max3 =",{"$nulls":5},{"$f":"IF('Daten-Eingabe'!$G$19=\"\",\"DL fehlt\",IF('Daten-Eingabe'!$G$18=\"\",\"NUD fehlt\",IF('Daten-Eingabe'!$G$17=\"\",\"IZRS fehlt\",IF('Daten-Eingabe'!$G$14=\"\",\"\",IF('Daten-Eingabe'!$G$14=0,\"\",('Daten-Eingabe'!$G$14+'Daten-Eingabe'!$G$17+'Daten-Eingabe'!$G$18+'Daten-Eingabe'!$G$19+'Daten-Eingabe'!$G$20)/'Daten-Eingabe'!$G$14)))))","v":"DL fehlt"}]
[{"$nulls":3},"(Q*Max3*R)/N",null,"£","Emax"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$15=\"\",\"R fehlt\",IF($G$33=\"\",\"Q fehlt\",IF('Daten-Eingabe'!$G$16=\"\",\"Anzahl  N  fehlt\",($G$33*'Daten-Eingabe'!$G$14*'Daten-Eingabe'!$G$15)/'Daten-Eingabe'!$G$16)))","v":"R fehlt"},null,"£",{"$f":"IF('Daten-Eingabe'!$G$37=\"\",\"\",'Daten-Eingabe'!$G$37)","v":""},null,{"$f":"IF(OR($G$33=\"\",$G$35=\"\",$G$35>10000000),\"NEIN\",IF($D$35>$G$35,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(6a) Größte zul. Anzahl der Teilungswerte der WZ und Anzahl der Eichwerte der NSW "]
[]
[{"$nulls":4},"nLC","³","n(i) = Max(i) /e(i)"]
[null," Einbereichswaage",null,null,{"$f":"'Daten-Eingabe'!G40","v":0},"³",{"$f":"IF('Daten-Eingabe'!H11=0,0,'Daten-Eingabe'!G11/'Daten-Eingabe'!H11)","v":0}]
[null," Mehrbereichswaage (3)",null,"i = 1",{"$f":"IF('Daten-Eingabe'!$G$40=\"\",\"\",'Daten-Eingabe'!$G$40)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$12=\"\",\"\",IF('Daten-Eingabe'!$H$12=0,\"\",'Daten-Eingabe'!$G$12/'Daten-Eingabe'!$H$12))","v":""},null,{"$f":"IF(OR($G$41=0,$G$41=\"\",$E$41=\"\",$E$41>100000000),\"NEIN\",IF($G$41>$E$41,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 2",{"$f":"IF('Daten-Eingabe'!$G$40=\"\",\"\",'Daten-Eingabe'!$G$40)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$13=\"\",\"\",IF('Daten-Eingabe'!$H$13=0,\"\",'Daten-Eingabe'!$G$13/'Daten-Eingabe'!$H$13))","v":""},null,{"$f":"IF(OR($G$42=0,$G$42=\"\",$E$42=\"\",$E$42>100000000),\"NEIN\",IF($G$42>$E$42,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 3",{"$f":"IF('Daten-Eingabe'!$G$40=\"\",\"\",'Daten-Eingabe'!$G$40)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$14=\"\",\"\",IF('Daten-Eingabe'!$H$14=0,\"\",'Daten-Eingabe'!$G$14/'Daten-Eingabe'!$H$14))","v":""},null,{"$f":"IF(OR($G$43=0,$G$43=\"\",$E$43=\"\",$E$43>100000000),\"NEIN\",IF($G$43>$E$43,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(6b) Rückkehr des Vorlastsignals der WZ und kleinster Eichwert e1 einer Mehrteilungswaage"]
[]
[{"$nulls":3},"n LC oder Z=Emax/(2*DR) ",null,"³","Maxr / e1"]
[{"$nulls":3},0,null,"³",{"$f":"IF('Daten-Eingabe'!H21=0,0,'Daten-Eingabe'!G21/'Daten-Eingabe'!H21)","v":0}]
[]
["(6c) Rückkehr des Vorlastsignals der WZ und kleinster Eichwert e1 einer Mehrbereichswaage"]
[]
[{"$nulls":3},"nLC oder Z = Emax /(2*DR) ",null,"³","0,4*Max3 /e1"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$43<>0,'Daten-Eingabe'!$G$43,(IF('Daten-Eingabe'!$G$44<>0,'Daten-Eingabe'!$G$37/(2*'Daten-Eingabe'!$G$44),'Daten-Eingabe'!$G$40)))","v":0},null,"³",{"$f":"IF('Daten-Eingabe'!$H$12=\"\",\"\",IF('Daten-Eingabe'!$H$12=0,\"\",'Daten-Eingabe'!$G$14/'Daten-Eingabe'!$H$12*0.4))","v":""},null,{"$f":"IF($D$53>10000000,\"NEIN\",IF($G$53=\"\",\"NEIN\",IF($G$53>$D$53,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["(6d) Totlast des Lastträgers der Waagenbrücke und Mindestvorlast der WZ  in kg"]
[]
[{"$nulls":4},"DL*R/N","³","Emin"]
[{"$nulls":4},{"$f":"IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$G$19*'Daten-Eingabe'!$G$15/'Daten-Eingabe'!$G$16))","v":""},"³",{"$f":"IF('Daten-Eingabe'!$G$38=\"\",\"\",'Daten-Eingabe'!$G$38)","v":""},null,{"$f":"IF(OR($E$58=\"\",$G$58=\"\"),\"NEIN\",IF($G$58>$E$58,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(7) Eichwert der NSW und kleinster zulässiger Teilungswert der WZ  in  kg"]
[]
[{"$nulls":4},"e1*R/ ÖN","³","vmin = Emax /Y"]
[{"$nulls":4},{"$f":"IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$H$12*'Daten-Eingabe'!$G$15/'Daten-Eingabe'!$G$16^0.5))","v":""},"³",{"$f":"IF('Daten-Eingabe'!$G$37=\"\",\"\",IF('Daten-Eingabe'!$G$42<>0,'Daten-Eingabe'!$G$37/'Daten-Eingabe'!$G$42,IF('Daten-Eingabe'!$G$41<>0,'Daten-Eingabe'!$G$41,IF('Daten-Eingabe'!$G$40=0,\"\",'Daten-Eingabe'!$G$37/'Daten-Eingabe'!$G$40))))","v":""},null,{"$f":"IF(OR($E$63=\"\",$G$63=\"\"),\"NEIN\",IF($G$63>$E$63,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(8) Mindesteingangssignal für AWG, Mindestmesssignal pro Eichwert und Berechnung"]
[]
[null,null,"Mindesteingangssignal  in  mV","U= C*Uexc*R*DL/(Emax *N)",null,"³","Umin"]
[null,null,"(entlastete Waage)",{"$f":"IF('Daten-Eingabe'!$G$39=\"\",\"\",IF(OR('Daten-Eingabe'!$G$37=0,'Daten-Eingabe'!$G$16=0),\"\",'Daten-Eingabe'!$G$39*'Daten-Eingabe'!$G$27*'Daten-Eingabe'!$G$15*'Daten-Eingabe'!$G$19/('Daten-Eingabe'!$G$37*'Daten-Eingabe'!$G$16)))","v":""},null,"³",{"$f":"IF('Daten-Eingabe'!$G$28=\"\",\"\",'Daten-Eingabe'!$G$28)","v":""},null,{"$f":"IF(OR($D$68>1000000,$G$68=\"\",$D$68=\"\"),\"NEIN\",IF($G$68>$D$68,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
[null,null,"Mindestsignal pro Eichwert in mV","Du = C*Uexc*R*e/(Emax *N)",null,"³","Dumin"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$39=\"\",\"\",IF(OR('Daten-Eingabe'!$G$37=0,'Daten-Eingabe'!$G$16=0),\"\",'Daten-Eingabe'!$G$39*1000*'Daten-Eingabe'!$G$27*'Daten-Eingabe'!$G$15*'Daten-Eingabe'!$H$12/('Daten-Eingabe'!$G$37*'Daten-Eingabe'!$G$16)))","v":""},null,"³",{"$f":"'Daten-Eingabe'!$G$29","v":0},null,{"$f":"IF(OR($D$71>1000000,$G$71=\"\",$D$71=\"\"),\"NEIN\",IF($G$71>$D$71,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(9) Vergleich der Lastwiderstände von AWG und WZ  in  W"]
[]
[null,null,"RLmin","£","RLC / N","£","RLmax"]
[null,null,{"$f":"IF('Daten-Eingabe'!$G$30=\"\",\"fehlt\",'Daten-Eingabe'!$G$30)","v":"fehlt"},"£",{"$f":"IF('Daten-Eingabe'!G45=\"\",\"R LC  fehlt\",IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$G$45/'Daten-Eingabe'!$G$16)))","v":"R LC  fehlt"},"£",{"$f":"IF('Daten-Eingabe'!$H$30>1000000,\"fehlt\",IF('Daten-Eingabe'!$H$30=\"\",\"fehlt\",'Daten-Eingabe'!$H$30))","v":"fehlt"},null,{"$f":"IF($C$76=0,\"NEIN\",IF($G$76=\"fehlt\",\"NEIN\",IF($E$76=\"\",\"NEIN\",IF($E$76<$C$76,\"NEIN\",IF($E$76>$G$76,\"NEIN\",\"JA\")))))","v":"NEIN"}]
[]
["(10) Verlängerungskabel zum Anschluss der WZ: Kabellänge pro Leiterquerschnitt  in  m/mm²"]
[]
[{"$nulls":4},"(L/A)","£","(L/A)max"]
[{"$nulls":4},{"$f":"IF(OR('Daten-Eingabe'!$G$23=\"\",'Daten-Eingabe'!$G$23=0),\"\",'Daten-Eingabe'!$G$22/'Daten-Eingabe'!$G$23)","v":""},"£",{"$f":"IF('Daten-Eingabe'!$G$34=\"\",\"\",'Daten-Eingabe'!$G$34)","v":""},null,{"$f":"IF($G$81>1000000,\"NEIN\",IF($G$81=\"\",\"NEIN\",IF($G$81<$E$81,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["H201-2_PR00C_Kompatibilitätsnachweis_1-0",{"$nulls":7},"Stand: 30.08.2018"]

{"sheet":"Zweiteilungswaage","index":5,"n_rows":83,"n_cols":9,"rows_kept":83,"hidden":true,"merged":[[3,6,3,8],[32,0,32,5],[34,3,34,4],[47,3,47,4],[52,3,52,4],[66,3,66,4],[67,3,67,4],[69,3,69,4],[70,3,70,4]]}
["Eichbehörden der Länder"]
[]
[]
["b) Nachweis der Kompatibilität - Zweiteilungswaage",{"$nulls":4},"Fabrik-Nr.:",{"$f":"IF('Daten-Eingabe'!A12=\"\",\"\",'Daten-Eingabe'!A12)","v":""}]
[]
["(1) Genauigkeitsklassen von WZ, AWG und NSW",{"$nulls":7},"I. O. ?"]
[null,{"$f":"IF(B9=\"\",5,IF('Daten-Eingabe'!G36=\"A\",1,IF('Daten-Eingabe'!G36=\"B\",2,IF('Daten-Eingabe'!G36=\"C\",3,IF('Daten-Eingabe'!G36=\"D\",4,0)))))","v":5},null,{"$f":"IF(D9=\"\",5,IF('Daten-Eingabe'!G25=\"I\",1,IF('Daten-Eingabe'!G25=\"II\",2,IF('Daten-Eingabe'!G25=\"III\",3,IF('Daten-Eingabe'!G25=\"IIII\",4,0)))))","v":5},null,null,{"$f":"IF(G9=\"\",0,IF('Daten-Eingabe'!G10=\"I\",1,IF('Daten-Eingabe'!G10=\"II\",2,IF('Daten-Eingabe'!G10=\"III\",3,IF('Daten-Eingabe'!G10=\"IIII\",4,0)))))","v":3}]
[null,"WZ","&","AWG","gleich oder besser als",null,"NSW"]
[null,{"$f":"IF('Daten-Eingabe'!$G$36=\"\",\"\",'Daten-Eingabe'!$G$36)","v":""},"&",{"$f":"IF('Daten-Eingabe'!$G$25=\"\",\"\",'Daten-Eingabe'!$G$25)","v":""},"gleich oder besser als",null,{"$f":"IF('Daten-Eingabe'!$G$10=\"\",\"\",'Daten-Eingabe'!$G$10)","v":"III"},null,{"$f":"IF($G$7=0,\"NEIN\",IF($B$7>$G$7,\"NEIN\",IF($D$7>$G$7,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["(2) Temperaturbereiche von WZ und AWG im Vergleich zum Temperaturbereich der NSW   in ° C"]
[]
[null,null,"WZ",null,"AWG",null,"NSW"]
[null,"Tmin",{"$f":"IF('Daten-Eingabe'!$G$46=\"\",\"\",'Daten-Eingabe'!$G$46)","v":""},"&",{"$f":"IF('Daten-Eingabe'!$G$31=\"\",\"\",'Daten-Eingabe'!$G$31)","v":""},"£",{"$f":"IF('Daten-Eingabe'!$G$21=\"\",\"\",'Daten-Eingabe'!$G$21)","v":""},null,{"$f":"IF(OR($G$14=\"\",$G$14>100),\"NEIN\",IF($C$14>$G$14,\"NEIN\",IF($E$14>$G$14,\"NEIN\",\"JA\")))","v":"NEIN"}]
[null,"Tmax",{"$f":"IF('Daten-Eingabe'!$H$46=\"\",\"\",'Daten-Eingabe'!$H$46)","v":""},"&",{"$f":"IF('Daten-Eingabe'!$H$31=\"\",\"\",'Daten-Eingabe'!$H$31)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$21=\"\",\"\",'Daten-Eingabe'!$H$21)","v":""},null,{"$f":"IF(OR($C15>150,$E$15>100),\"NEIN\",IF($G$15=\"\",\"NEIN\",IF($C$15<$G$15,\"NEIN\",IF($E$15<$G$15,\"NEIN\",\"JA\"))))","v":"NEIN"}]
[]
["(3) Summe der Quadrate der Fehlergrenzenanteile von Verbindungselementen, AWG und WZ"]
[]
[null,"pcon2","+","pind2","+","pLC2","£ 1"]
[null,{"$f":"IF('Daten-Eingabe'!$G$49=\"\",\"\",'Daten-Eingabe'!$G$49^2)","v":""},"+",{"$f":"IF('Daten-Eingabe'!$G$32=\"\",\"\",'Daten-Eingabe'!$G$32^2)","v":""},"+",{"$f":"IF('Daten-Eingabe'!$G$47=\"\",\"\",'Daten-Eingabe'!$G$47^2)","v":""},"£ 1",null,{"$f":"IF(OR($F$20=\"\",$F$20>(0.8)^2,$F$20<(0.3)^2,$D$20=\"\",$D$20>(0.8)^2,$D$20<(0.3)^2,$B$20=\"\"),\"NEIN\",IF($B$20+$D$20+$F$20>1,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(4) Größte zul. Anzahl der Teilungswerte des AWG und Anzahl der Eichwerte der NSW"]
[]
[{"$nulls":4},"nind","³","n(i) = Max(i) /e(i)"]
[null," Einbereichswaage",null,null,{"$f":"'Daten-Eingabe'!G26","v":0},"³",{"$f":"IF('Daten-Eingabe'!H11=0,0,'Daten-Eingabe'!G11/'Daten-Eingabe'!H11)","v":0}]
[null," Mehrteilungswaage (2)",null,"i = 1",{"$f":"IF('Daten-Eingabe'!$G$26=\"\",\"\",'Daten-Eingabe'!$G$26)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$12=\"\",\"\",IF('Daten-Eingabe'!$H$12=0,\"\",'Daten-Eingabe'!$G$12/'Daten-Eingabe'!$H$12))","v":""},null,{"$f":"IF(OR($E$26=\"\",$E$26>100000000,$G$26=\"\"),\"NEIN\",IF($G$26>$E$26,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 2",{"$f":"IF('Daten-Eingabe'!$G$26=\"\",\"\",'Daten-Eingabe'!$G$26)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$13=\"\",\"\",IF('Daten-Eingabe'!$H$13=0,\"\",'Daten-Eingabe'!$G$13/'Daten-Eingabe'!$H$13))","v":""},null,{"$f":"IF(OR($E$27=\"\",$E$27>100000000,$G$27=\"\"),\"NEIN\",IF($G$27>$E$27,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 3",0,"³",0]
[]
[]
["5) Höchstlasten von NSW und WZ"]
[]
["Last-Korrekturfaktor: Q = (Max2+DL+IZSR+NUD+T+)/Max2 =",{"$nulls":5},{"$f":"IF('Daten-Eingabe'!$G$19=\"\",\"DL fehlt\",IF('Daten-Eingabe'!$G$18=\"\",\"NUD fehlt\",IF('Daten-Eingabe'!$G$17=\"\",\"IZRS fehlt\",IF('Daten-Eingabe'!$G$13=\"\",\"\",IF('Daten-Eingabe'!$G$13=0,\"\",('Daten-Eingabe'!$G$13+'Daten-Eingabe'!$G$17+'Daten-Eingabe'!$G$18+'Daten-Eingabe'!$G$19+'Daten-Eingabe'!$G$20)/'Daten-Eingabe'!$G$13)))))","v":"DL fehlt"}]
[{"$nulls":3},"(Q*Max2*R)/N",null,"£","Emax"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$15=\"\",\"R fehlt\",IF($G$33=\"\",\"Q fehlt\",IF('Daten-Eingabe'!$G$16=\"\",\"Anzahl  N  fehlt\",($G$33*'Daten-Eingabe'!$G$13*'Daten-Eingabe'!$G$15)/'Daten-Eingabe'!$G$16)))","v":"R fehlt"},null,"£",{"$f":"IF('Daten-Eingabe'!$G$37=\"\",\"\",'Daten-Eingabe'!$G$37)","v":""},null,{"$f":"IF(OR($G$33=\"\",$G$35=\"\",$G$35>10000000),\"NEIN\",IF($D$35>$G$35,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(6a) Größte zul. Anzahl der Teilungswerte der WZ und Anzahl der Eichwerte der NSW "]
[]
[{"$nulls":4},"nLC","³","n(i) = Max(i) /e(i)"]
[null," Einbereichswaage",null,null,{"$f":"'Daten-Eingabe'!G40","v":0},"³",{"$f":"IF('Daten-Eingabe'!H11=0,0,'Daten-Eingabe'!G11/'Daten-Eingabe'!H11)","v":0}]
[null,"Mehrteilungswaage (2)",null,"i = 1",{"$f":"IF('Daten-Eingabe'!$G$40=\"\",\"\",'Daten-Eingabe'!$G$40)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$12=\"\",\"\",IF('Daten-Eingabe'!$H$12=0,\"\",'Daten-Eingabe'!$G$12/'Daten-Eingabe'!$H$12))","v":""},null,{"$f":"IF(OR($G$41=0,$G$41=\"\",$E$41=\"\",$E$41>100000000),\"NEIN\",IF($G$41>$E$41,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 2",{"$f":"IF('Daten-Eingabe'!$G$40=\"\",\"\",'Daten-Eingabe'!$G$40)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$13=\"\",\"\",IF('Daten-Eingabe'!$H$13=0,\"\",'Daten-Eingabe'!$G$13/'Daten-Eingabe'!$H$13))","v":""},null,{"$f":"IF(OR($G$42=0,$G$42=\"\",$E$42=\"\",$E$42>100000000),\"NEIN\",IF($G$42>$E$42,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 3",0,"³",0]
[]
["(6b) Rückkehr des Vorlastsignals der WZ und kleinster Eichwert e1 einer Mehrteilungswaage"]
[]
[{"$nulls":3},"nLC oder Z = Emax /(2*DR) ",null,"³","Max2 / e1"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$43<>0,'Daten-Eingabe'!$G$43,(IF('Daten-Eingabe'!$G$44<>0,'Daten-Eingabe'!$G$37/(2*'Daten-Eingabe'!$G$44),'Daten-Eingabe'!$G$40)))","v":0},null,"³",{"$f":"IF('Daten-Eingabe'!$H$12=\"\",\"\",IF('Daten-Eingabe'!$H$12=0,\"\",'Daten-Eingabe'!$G$13/'Daten-Eingabe'!$H$12))","v":""},null,{"$f":"IF(D48>10000000,\"NEIN\",IF($G$48=\"\",\"NEIN\",IF($G$48>$D$48,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["(6b) Rückkehr des Vorlastsignals der WZ und kleinster Eichwert e1 einer Mehrbereichswaage"]
[]
[{"$nulls":3},"nLC oder Z=Emax/(2*DR) ",null,"³","0,4*Maxr/e1"]
[{"$nulls":3},0,null,"³",0]
[]
["(6d) Totlast des Lastträgers der Waagenbrücke und Mindestvorlast der WZ  in kg"]
[]
[{"$nulls":4},"DL*R/N","³","Emin"]
[{"$nulls":4},{"$f":"IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$G$19*'Daten-Eingabe'!$G$15/'Daten-Eingabe'!$G$16))","v":""},"³",{"$f":"IF('Daten-Eingabe'!$G$38=\"\",\"\",'Daten-Eingabe'!$G$38)","v":""},null,{"$f":"IF(OR($E$58=\"\",$G$58=\"\"),\"NEIN\",IF($G$58>$E$58,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(7) Eichwert der NSW und kleinster zulässiger Teilungswert der WZ  in  kg"]
[]
[{"$nulls":4},"e1*R/ ÖN","³","vmin = Emax /Y"]
[{"$nulls":4},{"$f":"IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$H$12*'Daten-Eingabe'!$G$15/'Daten-Eingabe'!$G$16^0.5))","v":""},"³",{"$f":"IF('Daten-Eingabe'!$G$37=\"\",\"\",IF('Daten-Eingabe'!$G$42<>0,'Daten-Eingabe'!$G$37/'Daten-Eingabe'!$G$42,IF('Daten-Eingabe'!$G$41<>0,'Daten-Eingabe'!$G$41,IF('Daten-Eingabe'!$G$40=0,\"\",'Daten-Eingabe'!$G$37/'Daten-Eingabe'!$G$40))))","v":""},null,{"$f":"IF(OR($E$63=\"\",$G$63=\"\"),\"NEIN\",IF($G$63>$E$63,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(8) Mindesteingangssignal für AWG, Mindestmesssignal pro Eichwert und Berechnung"]
[]
[null,null,"Mindesteingangssignal  in  mV","U= C*Uexc*R*DL/(Emax *N)",null,"³","Umin"]
[null,null,"(entlastete Waage)",{"$f":"IF('Daten-Eingabe'!$G$39=\"\",\"\",IF(OR('Daten-Eingabe'!$G$37=0,'Daten-Eingabe'!$G$16=0),\"\",'Daten-Eingabe'!$G$39*'Daten-Eingabe'!$G$27*'Daten-Eingabe'!$G$15*'Daten-Eingabe'!$G$19/('Daten-Eingabe'!$G$37*'Daten-Eingabe'!$G$16)))","v":""},null,"³",{"$f":"IF('Daten-Eingabe'!$G$28=\"\",\"\",'Daten-Eingabe'!$G$28)","v":""},null,{"$f":"IF(OR($D$68>1000000,$G$68=\"\",$D$68=\"\"),\"NEIN\",IF($G$68>$D$68,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
[null,null,"Mindestsignal pro Eichwert in mV","Du = C*Uexc*R*e/(Emax *N)",null,"³","Dumin"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$39=\"\",\"\",IF(OR('Daten-Eingabe'!$G$37=0,'Daten-Eingabe'!$G$16=0),\"\",'Daten-Eingabe'!$G$39*1000*'Daten-Eingabe'!$G$27*'Daten-Eingabe'!$G$15*'Daten-Eingabe'!$H$12/('Daten-Eingabe'!$G$37*'Daten-Eingabe'!$G$16)))","v":""},null,"³",{"$f":"'Daten-Eingabe'!$G$29","v":0},null,{"$f":"IF(OR($D$71>1000000,$G$71=\"\",$D$71=\"\"),\"NEIN\",IF($G$71>$D$71,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(9) Vergleich der Lastwiderstände von AWG und WZ  in  W"]
[]
[null,null,"RLmin","£","RLC / N","£","RLmax"]
[null,null,{"$f":"IF('Daten-Eingabe'!$G$30=\"\",\"fehlt\",'Daten-Eingabe'!$G$30)","v":"fehlt"},"£",{"$f":"IF('Daten-Eingabe'!G45=\"\",\"R LC  fehlt\",IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$G$45/'Daten-Eingabe'!$G$16)))","v":"R LC  fehlt"},"£",{"$f":"IF('Daten-Eingabe'!$H$30>1000000,\"fehlt\",IF('Daten-Eingabe'!$H$30=\"\",\"fehlt\",'Daten-Eingabe'!$H$30))","v":"fehlt"},null,{"$f":"IF($C$76=0,\"NEIN\",IF($G$76=\"fehlt\",\"NEIN\",IF($E$76=\"\",\"NEIN\",IF($E$76<$C$76,\"NEIN\",IF($E$76>$G$76,\"NEIN\",\"JA\")))))","v":"NEIN"}]
[]
["(10) Verlängerungskabel zum Anschluss der WZ: Kabellänge pro Leiterquerschnitt  in  m/mm²"]
[]
[{"$nulls":4},"(L/A)","£","(L/A)max"]
[{"$nulls":4},{"$f":"IF(OR('Daten-Eingabe'!$G$23=\"\",'Daten-Eingabe'!$G$23=0),\"\",'Daten-Eingabe'!$G$22/'Daten-Eingabe'!$G$23)","v":""},"£",{"$f":"IF('Daten-Eingabe'!$G$34=\"\",\"\",'Daten-Eingabe'!$G$34)","v":""},null,{"$f":"IF($G$81>1000000,\"NEIN\",IF($G$81=\"\",\"NEIN\",IF($G$81<$E$81,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["H201-2_PR00C_Kompatibilitätsnachweis_1-0",{"$nulls":7},"Stand: 30.08.2018"]

{"sheet":"Dreiteilungswaage","index":6,"n_rows":83,"n_cols":9,"rows_kept":83,"hidden":true,"merged":[[3,6,3,8],[32,0,32,5],[34,3,34,4],[47,3,47,4],[52,3,52,4],[66,3,66,4],[67,3,67,4],[69,3,69,4],[70,3,70,4]]}
["Eichbehörden der Länder"]
[]
[]
["b) Nachweis der Kompatibilität - Dreiteilungswaage",{"$nulls":4},"Fabrik-Nr.:",{"$f":"IF('Daten-Eingabe'!A12=\"\",\"\",'Daten-Eingabe'!A12)","v":""}]
[]
["(1) Genauigkeitsklassen von WZ, AWG und NSW",{"$nulls":7},"I. O. ?"]
[null,{"$f":"IF(B9=\"\",5,IF('Daten-Eingabe'!G36=\"A\",1,IF('Daten-Eingabe'!G36=\"B\",2,IF('Daten-Eingabe'!G36=\"C\",3,IF('Daten-Eingabe'!G36=\"D\",4,0)))))","v":5},null,{"$f":"IF(D9=\"\",5,IF('Daten-Eingabe'!G25=\"I\",1,IF('Daten-Eingabe'!G25=\"II\",2,IF('Daten-Eingabe'!G25=\"III\",3,IF('Daten-Eingabe'!G25=\"IIII\",4,0)))))","v":5},null,null,{"$f":"IF(G9=\"\",0,IF('Daten-Eingabe'!G10=\"I\",1,IF('Daten-Eingabe'!G10=\"II\",2,IF('Daten-Eingabe'!G10=\"III\",3,IF('Daten-Eingabe'!G10=\"IIII\",4,0)))))","v":3}]
[null,"WZ","&","AWG","gleich oder besser als",null,"NSW"]
[null,{"$f":"IF('Daten-Eingabe'!$G$36=\"\",\"\",'Daten-Eingabe'!$G$36)","v":""},"&",{"$f":"IF('Daten-Eingabe'!$G$25=\"\",\"\",'Daten-Eingabe'!$G$25)","v":""},"gleich oder besser als",null,{"$f":"IF('Daten-Eingabe'!$G$10=\"\",\"\",'Daten-Eingabe'!$G$10)","v":"III"},null,{"$f":"IF($G$7=0,\"NEIN\",IF($B$7>$G$7,\"NEIN\",IF($D$7>$G$7,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["(2) Temperaturbereiche von WZ und AWG im Vergleich zum Temperaturbereich der NSW   in ° C"]
[]
[null,null,"WZ",null,"AWG",null,"NSW"]
[null,"Tmin",{"$f":"IF('Daten-Eingabe'!$G$46=\"\",\"\",'Daten-Eingabe'!$G$46)","v":""},"&",{"$f":"IF('Daten-Eingabe'!$G$31=\"\",\"\",'Daten-Eingabe'!$G$31)","v":""},"£",{"$f":"IF('Daten-Eingabe'!$G$21=\"\",\"\",'Daten-Eingabe'!$G$21)","v":""},null,{"$f":"IF(OR($G$14=\"\",$G$14>100),\"NEIN\",IF($C$14>$G$14,\"NEIN\",IF($E$14>$G$14,\"NEIN\",\"JA\")))","v":"NEIN"}]
[null,"Tmax",{"$f":"IF('Daten-Eingabe'!$H$46=\"\",\"\",'Daten-Eingabe'!$H$46)","v":""},"&",{"$f":"IF('Daten-Eingabe'!$H$31=\"\",\"\",'Daten-Eingabe'!$H$31)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$21=\"\",\"\",'Daten-Eingabe'!$H$21)","v":""},null,{"$f":"IF(OR($C15>150,$E$15>100),\"NEIN\",IF($G$15=\"\",\"NEIN\",IF($C$15<$G$15,\"NEIN\",IF($E$15<$G$15,\"NEIN\",\"JA\"))))","v":"NEIN"}]
[]
["(3) Summe der Quadrate der Fehlergrenzenanteile von Verbindungselementen, AWG und WZ"]
[]
[null,"pcon2","+","pind2","+","pLC2","£ 1"]
[null,{"$f":"IF('Daten-Eingabe'!$G$49=\"\",\"\",'Daten-Eingabe'!$G$49^2)","v":""},"+",{"$f":"IF('Daten-Eingabe'!$G$32=\"\",\"\",'Daten-Eingabe'!$G$32^2)","v":""},"+",{"$f":"IF('Daten-Eingabe'!$G$47=\"\",\"\",'Daten-Eingabe'!$G$47^2)","v":""},"£ 1",null,{"$f":"IF(OR($F$20=\"\",$F$20>(0.8)^2,$F$20<(0.3)^2,$D$20=\"\",$D$20>(0.8)^2,$D$20<(0.3)^2,$B$20=\"\"),\"NEIN\",IF($B$20+$D$20+$F$20>1,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(4) Größte zul. Anzahl der Teilungswerte des AWG und Anzahl der Eichwerte der NSW"]
[]
[{"$nulls":4},"nind","³","n(i) =Max(i) /e(i)"]
[null," Einbereichswaage",null,null,{"$f":"'Daten-Eingabe'!G26","v":0},"³",{"$f":"IF('Daten-Eingabe'!H11=0,0,'Daten-Eingabe'!G11/'Daten-Eingabe'!H11)","v":0}]
[null," Mehrteilungswaage (3)",null,"i = 1",{"$f":"IF('Daten-Eingabe'!$G$26=\"\",\"\",'Daten-Eingabe'!$G$26)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$12=\"\",\"\",IF('Daten-Eingabe'!$H$12=0,\"\",'Daten-Eingabe'!$G$12/'Daten-Eingabe'!$H$12))","v":""},null,{"$f":"IF(OR($E$26=\"\",$E$26>100000000,$G$26=\"\"),\"NEIN\",IF($G$26>$E$26,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 2",{"$f":"IF('Daten-Eingabe'!$G$26=\"\",\"\",'Daten-Eingabe'!$G$26)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$13=\"\",\"\",IF('Daten-Eingabe'!$H$13=0,\"\",'Daten-Eingabe'!$G$13/'Daten-Eingabe'!$H$13))","v":""},null,{"$f":"IF(OR($E$27=\"\",$E$27>100000000,$G$27=\"\"),\"NEIN\",IF($G$27>$E$27,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 3",{"$f":"IF('Daten-Eingabe'!$G$26=\"\",\"\",'Daten-Eingabe'!$G$26)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$14=\"\",\"\",IF('Daten-Eingabe'!$H$14=0,\"\",'Daten-Eingabe'!$G$14/'Daten-Eingabe'!$H$14))","v":""},null,{"$f":"IF(OR($E$28=\"\",$E$28>100000000,$G$28=\"\"),\"NEIN\",IF($G$28>$E$28,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
[]
["5) Höchstlasten von NSW und WZ"]
[]
["Last-Korrekturfaktor: Q = (Max3+DL+IZSR+NUD+T+)/Max3 =",{"$nulls":5},{"$f":"IF('Daten-Eingabe'!$G$19=\"\",\"DL fehlt\",IF('Daten-Eingabe'!$G$18=\"\",\"NUD fehlt\",IF('Daten-Eingabe'!$G$17=\"\",\"IZRS fehlt\",IF('Daten-Eingabe'!$G$14=\"\",\"\",IF('Daten-Eingabe'!$G$14=0,\"\",('Daten-Eingabe'!$G$14+'Daten-Eingabe'!$G$17+'Daten-Eingabe'!$G$18+'Daten-Eingabe'!$G$19+'Daten-Eingabe'!$G$20)/'Daten-Eingabe'!$G$14)))))","v":"DL fehlt"}]
[{"$nulls":3},"(Q*Max3*R)/N",null,"£","Emax"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$15=\"\",\"R fehlt\",IF($G$33=\"\",\"Q fehlt\",IF('Daten-Eingabe'!$G$16=\"\",\"Anzahl  N  fehlt\",($G$33*'Daten-Eingabe'!$G$14*'Daten-Eingabe'!$G$15)/'Daten-Eingabe'!$G$16)))","v":"R fehlt"},null,"£",{"$f":"IF('Daten-Eingabe'!$G$37=\"\",\"\",'Daten-Eingabe'!$G$37)","v":""},null,{"$f":"IF(OR($G$33=\"\",$G$35=\"\",$G$35>10000000),\"NEIN\",IF($D$35>$G$35,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(6a) Größte zul. Anzahl der Teilungswerte der WZ und Anzahl der Eichwerte der NSW "]
[]
[{"$nulls":4},"nLC","³","n(i) =Max(i) /e(i)"]
[null," Einbereichswaage",null,null,{"$f":"'Daten-Eingabe'!G40","v":0},"³",{"$f":"IF('Daten-Eingabe'!H11=0,0,'Daten-Eingabe'!G11/'Daten-Eingabe'!H11)","v":0}]
[null," Mehrteilungwaage (3)",null,"i = 1",{"$f":"IF('Daten-Eingabe'!$G$40=\"\",\"\",'Daten-Eingabe'!$G$40)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$12=\"\",\"\",IF('Daten-Eingabe'!$H$12=0,\"\",'Daten-Eingabe'!$G$12/'Daten-Eingabe'!$H$12))","v":""},null,{"$f":"IF(OR($G$41=0,$G$41=\"\",$E$41=\"\",$E$41>100000000),\"NEIN\",IF($G$41>$E$41,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 2",{"$f":"IF('Daten-Eingabe'!$G$40=\"\",\"\",'Daten-Eingabe'!$G$40)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$13=\"\",\"\",IF('Daten-Eingabe'!$H$13=0,\"\",'Daten-Eingabe'!$G$13/'Daten-Eingabe'!$H$13))","v":""},null,{"$f":"IF(OR($G$42=0,$G$42=\"\",$E$42=\"\",$E$42>100000000),\"NEIN\",IF($G$42>$E$42,\"NEIN\",\"JA\"))","v":"NEIN"}]
[{"$nulls":3},"i = 3",{"$f":"IF('Daten-Eingabe'!$G$40=\"\",\"\",'Daten-Eingabe'!$G$40)","v":""},"³",{"$f":"IF('Daten-Eingabe'!$H$14=\"\",\"\",IF('Daten-Eingabe'!$H$14=0,\"\",'Daten-Eingabe'!$G$14/'Daten-Eingabe'!$H$14))","v":""},null,{"$f":"IF(OR($G$43=0,$G$43=\"\",$E$43=\"\",$E$43>100000000),\"NEIN\",IF($G$43>$E$43,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(6b) Rückkehr des Vorlastsignals der WZ und kleinster Eichwert e1 einer Mehrteilungswaage"]
[]
[{"$nulls":3},"nLC oder Z = Emax /(2*DR) ",null,"³","Max3 / e1"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$43<>0,'Daten-Eingabe'!$G$43,(IF('Daten-Eingabe'!$G$44<>0,'Daten-Eingabe'!$G$37/(2*'Daten-Eingabe'!$G$44),'Daten-Eingabe'!$G$40)))","v":0},null,"³",{"$f":"IF('Daten-Eingabe'!$H$12=\"\",\"\",IF('Daten-Eingabe'!$H$12=0,\"\",'Daten-Eingabe'!$G$14/'Daten-Eingabe'!$H$12))","v":""},null,{"$f":"IF(D48>10000000,\"NEIN\",IF($G$48=\"\",\"NEIN\",IF($G$48>$D$48,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["(6c) Rückkehr des Vorlastsignals der WZ und kleinster Eichwert e1 einer Mehrbereichswaage"]
[]
[{"$nulls":3},"nLC oder Z=Emax/(2*DR) ",null,"³","0,4*Maxr/e1"]
[{"$nulls":3},0,null,"³",0]
[]
["(6d) Totlast des Lastträgers der Waagenbrücke und Mindestvorlast der WZ  in kg"]
[]
[{"$nulls":4},"DL*R/N","³","Emin"]
[{"$nulls":4},{"$f":"IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$G$19*'Daten-Eingabe'!$G$15/'Daten-Eingabe'!$G$16))","v":""},"³",{"$f":"IF('Daten-Eingabe'!$G$38=\"\",\"\",'Daten-Eingabe'!$G$38)","v":""},null,{"$f":"IF(OR($E$58=\"\",$G$58=\"\"),\"NEIN\",IF($G$58>$E$58,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(7) Eichwert der NSW und kleinster zulässiger Teilungswert der WZ  in  kg"]
[]
[{"$nulls":4},"e1*R/ ÖN","³","vmin= Emax /Y"]
[{"$nulls":4},{"$f":"IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$H$12*'Daten-Eingabe'!$G$15/'Daten-Eingabe'!$G$16^0.5))","v":""},"³",{"$f":"IF('Daten-Eingabe'!$G$37=\"\",\"\",IF('Daten-Eingabe'!$G$42<>0,'Daten-Eingabe'!$G$37/'Daten-Eingabe'!$G$42,IF('Daten-Eingabe'!$G$41<>0,'Daten-Eingabe'!$G$41,IF('Daten-Eingabe'!$G$40=0,\"\",'Daten-Eingabe'!$G$37/'Daten-Eingabe'!$G$40))))","v":""},null,{"$f":"IF(OR($E$63=\"\",$G$63=\"\"),\"NEIN\",IF($G$63>$E$63,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(8) Mindesteingangssignal für AWG, Mindestmesssignal pro Eichwert und Berechnung"]
[]
[null,null,"Mindesteingangssignal  in  mV","U= C*Uexc*R*DL/(Emax *N)",null,"³","Umin"]
[null,null,"(entlastete Waage)",{"$f":"IF('Daten-Eingabe'!$G$39=\"\",\"\",IF(OR('Daten-Eingabe'!$G$37=0,'Daten-Eingabe'!$G$16=0),\"\",'Daten-Eingabe'!$G$39*'Daten-Eingabe'!$G$27*'Daten-Eingabe'!$G$15*'Daten-Eingabe'!$G$19/('Daten-Eingabe'!$G$37*'Daten-Eingabe'!$G$16)))","v":""},null,"³",{"$f":"IF('Daten-Eingabe'!$G$28=\"\",\"\",'Daten-Eingabe'!$G$28)","v":""},null,{"$f":"IF(OR($D$68>1000000,$G$68=\"\",$D$68=\"\"),\"NEIN\",IF($G$68>$D$68,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
[null,null,"Mindestsignal pro Eichwert in mV","Du = C*Uexc*R*e/(Emax *N)",null,"³","Dumin"]
[{"$nulls":3},{"$f":"IF('Daten-Eingabe'!$G$39=\"\",\"\",IF(OR('Daten-Eingabe'!$G$37=0,'Daten-Eingabe'!$G$16=0),\"\",'Daten-Eingabe'!$G$39*1000*'Daten-Eingabe'!$G$27*'Daten-Eingabe'!$G$15*'Daten-Eingabe'!$H$12/('Daten-Eingabe'!$G$37*'Daten-Eingabe'!$G$16)))","v":""},null,"³",{"$f":"'Daten-Eingabe'!$G$29","v":0},null,{"$f":"IF(OR($D$71>1000000,$G$71=\"\",$D$71=\"\"),\"NEIN\",IF($G$71>$D$71,\"NEIN\",\"JA\"))","v":"NEIN"}]
[]
["(9) Vergleich der Lastwiderstände von AWG und WZ  in  W"]
[]
[null,null,"RLmin","£","RLC / N","£","RLmax"]
[null,null,{"$f":"IF('Daten-Eingabe'!$G$30=\"\",\"fehlt\",'Daten-Eingabe'!$G$30)","v":"fehlt"},"£",{"$f":"IF('Daten-Eingabe'!G45=\"\",\"R LC  fehlt\",IF('Daten-Eingabe'!$G$16=\"\",\"\",IF('Daten-Eingabe'!$G$16=0,\"\",'Daten-Eingabe'!$G$45/'Daten-Eingabe'!$G$16)))","v":"R LC  fehlt"},"£",{"$f":"IF('Daten-Eingabe'!$H$30>1000000,\"fehlt\",IF('Daten-Eingabe'!$H$30=\"\",\"fehlt\",'Daten-Eingabe'!$H$30))","v":"fehlt"},null,{"$f":"IF($C$76=0,\"NEIN\",IF($G$76=\"fehlt\",\"NEIN\",IF($E$76=\"\",\"NEIN\",IF($E$76<$C$76,\"NEIN\",IF($E$76>$G$76,\"NEIN\",\"JA\")))))","v":"NEIN"}]
[]
["(10) Verlängerungskabel zum Anschluss der WZ: Kabellänge pro Leiterquerschnitt  in  m/mm²"]
[]
[{"$nulls":4},"(L/A)","£","(L/A)max"]
[{"$nulls":4},{"$f":"IF(OR('Daten-Eingabe'!$G$23=\"\",'Daten-Eingabe'!$G$23=0),\"\",'Daten-Eingabe'!$G$22/'Daten-Eingabe'!$G$23)","v":""},"£",{"$f":"IF('Daten-Eingabe'!$G$34=\"\",\"\",'Daten-Eingabe'!$G$34)","v":""},null,{"$f":"IF($G$81>1000000,\"NEIN\",IF($G$81=\"\",\"NEIN\",IF($G$81<$E$81,\"NEIN\",\"JA\")))","v":"NEIN"}]
[]
["H201-2_PR00C_Kompatibilitätsnachweis_1-0",{"$nulls":7},"Stand: 30.08.2018"]

{"sheet":"Tabelle1","index":7,"n_rows":10,"n_cols":1,"rows_kept":10,"hidden":true}
[]
["Einbereichswaage"]
["Zweibereichswaage"]
["Dreibereichswaage"]
["Zweiteilungswaage"]
["Dreiteilungswaage"]
[]
[]
[]
[1]