{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Info","Zahnradberechnung","Zahnradberechnung_aussen","Zahnweite Wk","Evolvente berechnen","Evolvente berechnen (2)","Evolvente berechnen (3)","Übersetzungen"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":171,"comments":4,"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":"Info","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Wichtiger Hinweis:"]
[null,"Diese Excel-Tabelle darf nur für Ausbildungs- und Lehrzwecke verwendet werden!"]
[null,"Obwohl ausführliche Testreihen erfolgten, kann die jederzeit einwandfreie Funktion nicht garantiert werden."]
[null,"In keinem Fall kann daher für die Nutzung dieser Tabelle eine Haftung übernommen werden."]
[]
[null,"Nutzung:"]
[null,"In den Tabellen dürfen nur grün hinterlegte Felder mit eigenen Werten versehen werden."]
[null,"Gelb hinterlegte Felder besitzen Formeln. Sie dürfen daher nicht verändert werden!"]
[]
[null,"© 2020 Welt der Fertigung"]

{"sheet":"Zahnradberechnung","index":1,"n_rows":68,"n_cols":10,"rows_kept":68,"cut":false,"hidden":false,"merged":[[9,1,9,2],[11,1,12,1],[11,4,12,4],[14,1,14,2],[15,1,15,2],[17,1,17,2],[18,1,19,1],[18,4,19,4],[20,1,21,1],[20,4,21,4],[23,1,23,2],[24,1,24,2],[25,1,25,2],[24,4,25,4],[27,1,27,2],[28,1,28,2],[30,1,30,2],[31,1,32,1],[31,4,32,4],[33,1,34,1],[33,4,34,4],[43,1,43,2],[44,1,44,2],[45,1,45,2],[43,4,45,4],[36,1,36,2],[37,1,38,1],[39,1,40,1],[37,4,38,4],[39,4,40,4],[58,1,60,1],[58,4,60,4],[39,6,40,6],[39,9,40,9],[42,6,42,7],[43,6,43,7],[43,9,45,9],[44,6,44,7],[45,6,45,7],[52,1,52,2],[53,1,53,2],[52,4,53,4],[47,1,47,2],[48,1,48,2],[49,1,49,2],[48,4,49,4],[62,1,62,2],[63,1,64,1],[63,4,64,4],[65,1,67,1],[65,4,67,4],[3,1,3,9],[7,1,7,4],[7,6,7,9],[55,1,55,2],[56,1,57,1],[56,4,57,4],[17,6,17,7],[18,6,19,6],[18,9,19,9],[20,6,21,6],[20,9,21,9],[36,6,36,7],[37,9,38,9],[37,6,38,6],[51,1,51,2],[42,1,42,2]]}
[]
[null,"Zahnradberechnung"]
[]
[null,"Stirnräder mit Geradverzahnung"]
[]
[]
[]
[null,"Außenverzahnung",null,null,null,null,"Innenverzahnung"]
[]
[null,"Modul m",null,"Wert","Modul"]
[null,"1. Möglichkeit:","Teilung P:",3.1419999999999999,{"$f":"D11/PI()","v":1.0001296623894702}]
[null,"2. Möglichkeit:","Teilkreisdurchmesser d:",120,{"$f":"D12/D13","v":1.5}]
[null,null,"Zähnezahl z:",80]
[]
[null,"Teilung p",null,"Wert","Teilung"]
[null,"Modul m:",null,5,{"$f":"D16*PI()","v":15.707963267948966}]
[]
[null,"Zähnezahl z",null,"Wert","Zähnezahl",null,"Zähnezahl Innen z",null,"Wert","Zähnezahl"]
[null,"1. Möglichkeit","Teilkreisdurchmesser d:",120,{"$f":"D19/D20","v":80},null,"1. Möglichkeit","Teilkreisdurchmesser d:",120,{"$f":"I19/I20","v":80}]
[null,null,"Modul m:",1.5,null,null,null,"Modul m:",1.5]
[null,"2. Möglichkeit","Kopfkreisdurchmesser da:",117,{"$f":"(D21-2*D22)/D22","v":76},null,"2. Möglichkeit","Kopfkreisdurchmesser da:",117,{"$f":"(I21+J23*I22)/I22","v":78}]
[null,null,"Modul m:",1.5,null,null,null,"Modul m:",1.5]
[]
[null,"Kopfspiel c",null,"Wert","Kopfspiel"]
[null,"Faktor (0,1 bis 0,3):",null,0.16700000000000001,{"$f":"D25*D26","v":0.2505}]
[null,"Modul m:",null,1.5]
[]
[null,"Zahnkopfhöhe ha=m",null,"Wert","Zahnkopfhöhe"]
[null,"Modul m:",null,1.5,{"$f":"D29","v":1.5}]
[]
[null,"Teilkreisdurchmesser d",null,"Wert","Teilkreisdurchmesser"]
[null,"1.Möglichkeit","Modul m:",2.5,{"$f":"D32*D33","v":90}]
[null,null,"Zähnezahl z:",36]
[null,"2. Möglichkeit","Zähnezahl z:",24,{"$f":"D34*D35/PI()","v":24.003111897347289}]
[null,null,"Teilung p:",3.1419999999999999]
[]
[null,"Kopfkreisdurchmesser da",null,"Wert","Kopfkreisdurchmesser",null,"Kopfkreisdurchmesser da Innen",null,"Wert","Kopfkreisdurchmesser"]
[null,"1.Möglichkeit","Teilkreisdurchmesser d:",120,{"$f":"D38+2*D39","v":123},null,"1.Möglichkeit","Teilkreisdurchmesser d:",120,{"$f":"I38-J41*I39","v":120}]
[null,null,"Modul m:",1.5,null,null,null,"Modul m:",1.5]
[null,"2.Möglichkeit","Modul m:",1.5,{"$f":"D40*(D41+2)","v":123},null,"2. Möglichkeit","Zähnezahl z:",80,{"$f":"I41*(I40-J42)","v":120}]
[null,null,"Zähnezahl z:",80,null,null,null,"Modul m:",1.5]
[]
[null,"Fußkreisdurchmesser d1",null,"Wert","Fußkreisdurchmesser",null,"Fußkreisdurchmesser d1 Innen",null,"Wert","Fußkreisdurchmesser"]
[null,"Teilkreisdurchmesser d:",null,120,{"$f":"D44-2*(D45+D46)","v":116},null,"Teilkreisdurchmesser d:",null,120,{"$f":"I44+J47*(I45+I46)","v":120}]
[null,"Modul m:",null,1.5,null,null,"Modul m:",null,1.5]
[null,"Kopfspiel c:",null,0.5,null,null,"Kopfspiel c:",null,0.5]
[]
[null,"Zahnhöhe h",null,"Wert","Zahnhöhe"]
[null,"Modul m:",null,1.5,{"$f":"E51*D49+D50","v":0.5}]
[null,"Kopfspiel c:",null,0.5]
[]
[null,"Zahnfußhöhe hf",null,"Wert","Zahnfußhöhe"]
[null,"Modul m:",null,1.5,{"$f":"D53+D54","v":2}]
[null,"Kopfspiel c:",null,0.5]
[]
[null,"Achsenabstand a mit Gegenrad außen",null,"Wert","Achsenabstand"]
[null,"1. Möglichkeit","Teilkreisdurchmesser 1:",120,{"$f":"(D57+D58)/2","v":100}]
[null,null,"Teilkreisdurchmesser 2:",80]
[null,"2. Möglichkeit","Modul m:",2.5,{"$f":"D59*(D61+D60)/2","v":75}]
[null,null,"Zähnezahl Zahnrad 1:",24]
[null,null,"Zähnezahl Zahnrad 2:",36]
[]
[null,"Achsenabstand a mit Gegenrad innen",null,"Wert","Achsenabstand"]
[null,"1. Möglichkeit","Teilkreisdurchmesser 1:",80,{"$f":"(D65-D64)/2","v":20}]
[null,null,"Teilkreisdurchmesser 2:",120]
[null,"2. Möglichkeit","Modul m:",1.5,{"$f":"D66*(D67-D68)/2","v":30}]
[null,null,"Zähnezahl Zahnrad 1:",120]
[null,null,"Zähnezahl Zahnrad 2:",80]

{"sheet":"Zahnradberechnung_aussen","index":2,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,2,57,2],[32,9,33,9],[36,9,37,9],[25,9,26,9],[40,9,41,9],[48,9,49,9],[44,9,45,9],[52,9,53,9],[48,2,49,2],[52,2,53,2],[3,1,3,9],[1,4,1,9],[21,1,21,9],[25,2,26,2],[44,2,45,2],[40,2,41,2],[36,2,37,2],[11,1,14,1],[16,1,18,1],[32,2,33,2]]}
[]
[null,"Zahnradberechnung",null,null,"Außenverzahnung"]
[]
[null,"Stirnräder mit Geradverzahnung"]
[]
[null,"Gegeben:","Modul m:",2]
[null,null,"Zähnezahl z1:",36]
[null,null,"Zähnezahl z2:",150]
[null,null,"Eingriffswinkel Alpha:",20]
[null,null,"Kopfspiel-Faktor (0,1 bis 0,3):",0.16700000000000001]
[]
[null,"Zähnezahl-berechnung:","Kopfkreisdurchmesser 1 (da1):",117,{"$f":"(D12+(2*D6))/D6","v":60.5}]
[null,null,"Kopfkreisdurchmesser 2 (da2):",100,{"$f":"(D13+(2*D6))/D6","v":52}]
[null,null,"Teilkreisdurchmesser 1 (d1):",100,{"$f":"D14/D6","v":50}]
[null,null,"Teilkreisdurchmesser 2 (d2):",150,{"$f":"D15/D6","v":75}]
[]
[null,"Modul-berechnung:","Teilung p:",12.5663,{"$f":"D17/PI()","v":3.9999775227513688}]
[null,null,"Teilkreisdurchmesser d1:",{"$f":"D14","v":100},{"$f":"D18/D7","v":2.7777777777777777}]
[null,null,"Teilkreisdurchmesser d2:",{"$f":"D15","v":150},{"$f":"D19/D8","v":1}]
[]
[]
[null,"Ergebnisse"]
[]
[]
[null,null,"Kopfspiel c",null,null,null,null,null,null,"Teilung p"]
[null,null,{"$f":"D10*D6","v":0.33400000000000002},null,null,null,null,null,null,{"$f":"D6*PI()","v":6.2831853071795862}]
[]
[]
[null,null,"Zahnkopfhöhe ha",null,null,null,null,null,null,"Übersetzung"]
[null,null,{"$f":"D6","v":2},null,null,null,null,null,null,{"$f":"D18/D19","v":0.66666666666666663}]
[]
[null,null,"Zahnhöhe h",null,null,null,null,null,null,"Teilkreisdurchmesser 1 (d1)"]
[null,null,{"$f":"2*D6+C26","v":4.3339999999999996},null,null,null,null,null,null,{"$f":"D6*D7","v":72}]
[]
[]
[null,null,"Zahnfußhöhe hf",null,null,null,null,null,null,"Teilkreisdurchmesser 2 (d2)"]
[null,null,{"$f":"D6+C26","v":2.3340000000000001},null,null,null,null,null,null,{"$f":"D6*D8","v":300}]
[]
[]
[null,null,"Achsenabstand a",null,null,null,null,null,null,"Messzähnezahl Zahnrad 1"]
[null,null,{"$f":"(D18+D19)/2","v":125},null,null,null,null,null,null,{"$f":"(D7/180*ACOS(D7*COS(D9*PI()/180)/(D7+2*0.3))*180/PI()+0.5)","v":4.98775825054412}]
[]
[]
[null,null,"Kopfkreisdurchmesser 1 (da1)",null,null,null,null,null,null,"Messzähnezahl Zahnrad 2"]
[null,null,{"$f":"D18+2*D6","v":104},null,null,null,null,null,null,{"$f":"(D8/180*ACOS(D8*COS(D9*PI()/180)/(D8+2*0.3))*180/PI()+0.5)","v":17.681684259656123}]
[]
[]
[null,null,"Kopfkreisdurchmesser 2 (da2)",null,null,null,null,null,null,"Zahnweite Zahnrad 1"]
[null,null,{"$f":"D19+2*D6","v":154},null,null,null,null,null,null,{"$f":"D6*COS(D9*PI()/180)*((J41-0.5)*PI()+D7*(TAN(ATAN(TAN(D9*PI()/180)/COS(0))-ATAN(TAN(D9*PI()/180)/COS(0))+2*0.3*SIN(D9*PI()/180))))","v":40.579354025358718}]
[]
[]
[null,null,"Fußkreisdurchmesser 1 (df1)",null,null,null,null,null,null,"Zahnweite Zahnrad 2"]
[null,null,{"$f":"D18-2*(D6+C26)","v":95.331999999999994},null,null,null,null,null,null,{"$f":"D6*COS(D9*PI()/180)*((J41-0.5)*PI()+D8*(TAN(ATAN(TAN(D9*PI()/180)/COS(0))-ATAN(TAN(D9*PI()/180)/COS(0))+2*0.3*SIN(D9*PI()/180))))","v":85.173777838716177}]
[]
[]
[null,null,"Fußkreisdurchmesser 2 (df2)"]
[null,null,{"$f":"D19-2*(D6+C26)","v":145.33199999999999}]

{"sheet":"Zahnweite Wk","index":3,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Zahnweite Wk"]
[]
[]
[null,"Gegeben:"]
[null,"Modul m:",2]
[null,"Zähnezahl z:",36]
[null,"Öffnungswinkel Alpha:",20]
[null,"Profilverschiebungsfaktor x:",0.3]
[null,"Basissteigungswinkel Beta:",0]
[null,"inv Alpha:",{"$f":"TAN(C9*PI()/180)-(C9*PI()/180)","v":1.4904383867336446E-2}]
[]
[]
[null,"Gesucht:"]
[null,"Zähnezahl für die Messung k:",{"$f":"IF(C11=0,ROUND(((C8/PI())*((TAN(C9*PI()/180)/1)-C12-(C7*C10/C8)*TAN(C9*PI()/180))+1),0),ROUND(((C8/PI())*((TAN(C9*PI()/180)/(COS(C9*PI()/180)^2*C11))-C12-(C7*C10/C8)*TAN(C9*PI()/180))+1),0))","v":5}]
[null,"Abstand Wk",{"$f":"C7*COS(C9*(PI()/180))*((C16-0.5)*PI()+C8*C12)+C7*C10*C7*SIN(C9*(PI()/180))","v":27.988005925532502}]
[]
[]
[]
[null,null,null,null,"Formeln:","Dezimalwinkel in Bogenmass= WertxPi()/180"]
[null,null,null,null,null,"Bogenmass in Dezimalwinkel=Wertx180/Pi()"]

{"sheet":"Evolvente berechnen","index":4,"n_rows":90,"n_cols":24,"rows_kept":90,"cut":false,"hidden":false,"merged":[[17,22,17,23],[14,17,14,18],[15,17,15,18],[13,17,13,18],[5,17,5,18],[6,17,6,18],[9,17,9,18],[10,17,10,18],[4,17,4,18],[3,17,3,19],[12,17,12,18],[7,17,7,18],[11,17,11,18],[8,17,8,18],[7,9,7,10],[8,9,8,10],[6,15,8,15],[10,15,11,15],[10,14,11,14]]}
[null,null,null,null,null,null,null,null,"Dezimalwinkel in Bogenmass= WertxPi()/180"]
[null,null,null,null,null,null,null,null,"Bogenmass in Dezimalwinkel=Wertx180/Pi()"]
[null,"Zahnradmessung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solver",null,null,null,null,"Formelspeicher"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bogenlänge Bl:",null,{"$f":"$C$19/360*(T10+$C$21)","v":10.15470403579044}]
[null,"Gegeben:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strecke a:",null,4.1975061266800733,null,null,{"$f":"SIN($T$13*PI()/180)*$T$8","v":4.2422066156275227}]
[null,"Modul:",5,null,null,null,null,null,null,null,null,null,null,null,null,"Werte für Solverlauf",null,"Strecke b:",null,25.252499406021013,null,null,{"$f":"COS($T$13*PI()/180)*$T$8","v":25.253522981713257}]
[null,"Zähnezahl",10,null,null,null,null,null,null,"Öffnungswinkel:",null,{"$f":"360/(C8*2)","v":18},null,null,null,null,null,"Strecke c:",null,25.607357145117369,null,null,{"$f":"SQRT($T$5^2+($C$18/2)^2)","v":25.593102635850531}]
[null,"Messkugeldurchmesser:",10,null,null,null,null,null,null,"Winkelkorrektur von Zahn und Zahnlücke:",null,0,null,null,null,null,null,"Strecke b2:",null,2.7588752833271615,null,null,{"$f":"$T$6/TAN((90-($T$10+$L$13/2))*PI()/180)","v":2.7167887118433569}]
[null,"Eingriffswinkel",20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Teilungswinkel:",null,23.912509831262746,null,null,28.197236696908405]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solverlauf durchführen","Wichtiger Hinweis!",null,"Winkel Alpha 2:",null,{"$f":"ATAN(T5/($C$18/2))*180/PI()","v":23.376724136275968}]
[null,null,null,null,null,null,null,null,null,null,"Breite am Teilkreisdurchm.","Winkel",null,null,null,null,null,"Winkel Alpha 3:",null,{"$f":"T10-T11","v":0.53578569498677808},null,null,"Korrekturwert"]
[null,"Gesucht:",null,null,null,null,null,null,null,"Zahnlücke:",{"$f":"TAN((L8+L9)/2*PI()/180)*(C20/2)*2","v":7.9192220162268141},{"$f":"L8+L9","v":18},"(Alpha z)",null,null,null,null,"Winkel alpha 4:",null,{"$f":"T12+$L$13/2","v":9.5357856949867781},null,null,0.24]
[null,"Öffnungswinkel",{"$f":"360/C20","v":7.2},null,null,null,null,null,null,"Zahn:",{"$f":"TAN((L8-L9)/2*PI()/180)*(C20/2)*2-L11","v":7.9192220162268141},{"$f":"L8-L9","v":18},null,null,null,null,null,"Zahnlückenwinkel:",null,{"$f":"L13","v":18}]
[null,"Ankathete a",{"$f":"SIN((C14/2)*PI()/180)*C20/2","v":1.5697629882328343},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kugel Ø",null,{"$f":"$T$6/SIN((90-($T$10+$T$14/2))*PI()/180)*2","v":9.9999997176632434}]
[null,"Gegenkathete b",{"$f":"COS((C14/2)*PI()/180)*C20/2","v":24.950668210706787},null,null,null,null,null,null,"Startwinkel",0,null,"Winkel für Vektor",{"$f":"L9","v":0},"±Grad",null,null,"Zweikugelmaß Mdk:",null,{"$f":"(T7+T9+T15/2)*2-W13","v":65.782749096359595}]
[null,"Berührpunktabstand Bab",{"$f":"C15*2","v":3.1395259764656687},null,null,null,null,null,null,"Inkrement",1]
[null,"Grundkreisdurchmesser dg",{"$f":"COS(C10*PI()/180)*C20","v":46.984631039295422},null,null,null,null,null,null,null,null,null,null,null,null,null,"dm/2",null,null,"DM","Mdk","Kugel-XM","Trefferindikator"]
[null,"Teilkreisumfang",{"$f":"C18*PI()","v":147.60657170467746},null,null,"Winkel","Bogenlänge",null,null,"Teilungsw. Alpha","Bogenlänge Bl","Strecke c","Winkel alpha 2","Winkel alpha 3","Winkel alpha 4","Strecke a","Strecke b","Strecke b2","Vektorwinkel","Kugel Ø","Prüfmaß",null,"Untergrenze","Obergrenze"]
[null,"Teilkreisdurchmesser:",{"$f":"C8*C7","v":50},null,1,1,{"$f":"$C$19/360*F20","v":0.41001825473521519},null,1,{"$f":"K16","v":0},{"$f":"$C$19/360*(J20+$C$21)","v":0.35013848843741496},{"$f":"SQRT(K20^2+($C$18/2)^2)","v":23.494924673975142},{"$f":"ATAN(K20/($C$18/2))*180/PI()","v":0.85389506731546194},{"$f":"J20-M20","v":-0.85389506731546194},{"$f":"N20+$L$13/2","v":8.1461049326845387},{"$f":"SIN(O20*PI()/180)*L20","v":3.3291801082491626},{"$f":"COS(O20*PI()/180)*L20","v":23.257859859466951},{"$f":"P20/TAN((90-(J20+$L$13/2))*PI()/180)","v":0.52729032818462296},{"$f":"J20+$L$13/2","v":9},{"$f":"P20/SIN((90-(J20+$L$13/2))*PI()/180)*2","v":6.7413575141388105},{"$f":"(Q20+R20+T20/2)*2","v":54.31165788944196},{"$f":"COS(J20*PI()/180)*$C$9/2*2","v":10},{"$f":"IF(AND(T20<$C$9,T21>$C$9),\"1\",\"0\")","v":"0"},{"$f":"IF(AND(T20>$C$9,T19<$C$9),\"1\",\"0\")","v":"0"}]
[null,"Korrektur inv alpha y",{"$f":"(TAN(C10*PI()/180)-(PI()/9))*180/PI()","v":0.85395829184125016},null,2,3,1.2300547642056456,null,2,{"$f":"J20+$K$17","v":1},{"$f":"$C$19/360*(J21+$C$21)","v":0.76015674317263016},{"$f":"SQRT(K21^2+($C$18/2)^2)","v":23.50461075510232},{"$f":"ATAN(K21/($C$18/2))*180/PI()","v":1.8533116546953032},-0.85331165469530323,8.1466883453046961,{"$f":"SIN(O21*PI()/180)*L21","v":3.3307895249824546},{"$f":"COS(O21*PI()/180)*L21","v":23.267414293151244},0.58730806031553884,{"$f":"J21+$L$13/2","v":10},6.764344644514928,{"$f":"(Q21+R21+T21/2)*2","v":54.473789351448495},9.9984769515639123,"0","0"]
[null,"Bogenlänge",{"$f":"C19/360*C21","v":0.35013848843741496},null,3,5,2.0500912736760761,null,3,{"$f":"J21+$K$17","v":2},1.1701749979078453,23.521441239864732,2.8516014497556528,-0.85160144975565277,8.1483985502443481,3.3338695360356381,23.283975431981172,0.64803859103942985,11,6.7925371103241972,54.656565156365403,9.993908270190957,"0","0"]
[null,"dp-Wert",{"$f":"C8/C20","v":0.2},null,4,10,4.1001825473521523,null,4,3,1.5801932526430607,23.545400807596785,3.848161632997249,-0.848161632997249,8.1518383670027514,3.338664802145686,23.307492712200787,0.70965511091281219,12,6.8265051197611122,54.860800765988316,9.9862953475457381,"0","0"]
[null,null,null,null,5,20,8.2003650947043045,null,5,4,1.9902115073782758,23.576467723532751,4.8423956529436989,-0.84239565294369889,8.1576043470563011,3.3454186297430035,23.337909171786364,0.77235074760652689,13,6.8668337639875672,55.087353602773348,9.9756405025982424,"0","0"]
[null,"Kugelabschnittsrechner",null,null,6,30,12.300547642056456,null,6,5,2.4002297621134909,23.614613936831915,5.8337153366508483,-0.83371533665084829,8.1662846633491526,3.3543728222794957,23.375161482966679,0.83633907657039075,14,6.9141246971242634,55.337125816198402,9.961946980917455,"0","0"]
[null,"Winkel:",20,null,7,40,16.400730189408609,null,7,6,2.8102480168487061,23.659805206106046,6.8215429253394202,-0.82154292533942019,8.1784570746605798,3.3657675322905476,23.419179987981252,0.90185469218814485,15,6.9689979099560579,55.611067270294853,9.9452189536827333,"0","0"]
[null,"Kugelabschnitt l:",{"$f":"COS(C26*PI()/180)*C9/2*2","v":9.3969262078590852},null,8,50,20.50091273676076,null,8,7,3.2202662715839212,23.712001251150898,7.8053130180273769,-0.80531301802737687,8.1946869819726231,3.3798411142586207,23.469888738060707,0.96915384411156746,16,7.0320936089301833,55.91017877327473,9.9254615164132201,"0","0"]
[null,null,null,null,9,60,24.601095284112912,null,9,8,3.6302845263191363,23.771155929334039,8.7844744075374717,-0.78447440753747166,8.2155255924625283,3.3968299783457998,23.527205535611834,1.038515144078868,17,7.1040742130892411,56.235515572470646,9.9026806874157032,"0","0"]
[null,null,null,null,10,70,28.701277831465063,null,10,9,4.0403027810543515,23.837217434870123,9.7584917949759209,-0.7584917949759209,8.2415082050240791,3.4169684450622948,23.591041979588876,1.1102403492070674,18,7.1856264827943477,56.588191140386236,9.8768834059513786,"0","0"]
[null,null,null,null,11,80,32.801460378817218,null,11,10,4.4503210357895666,23.910128519024564,10.726847370676577,-0.72684737067657679,8.2731526293234232,3.4404886009374964,23.661303514030898,1.1846552285111078,19,7.2774637954769812,56.969381280560995,9.8480775301220795,"0","0"]
[null,null,null,null,12,90,36.901642926169366,null,12,11,4.8603392905247818,23.989826729130407,11.689042251634971,-0.68904225163497124,8.3109577483650288,3.4676201552597874,23.737889479743892,1.26211052025611,20,7.3803285852338751,57.380328585233876,9.8162718344766393,"0","0"]
[null,null,null,null,null,null,null,null,13,12,5.2703575452599969,24.076244664182155,12.644597767570353,-0.64459776757035314,8.3554022324296469,3.4985902979508121,23.82069316910497,1.3429829887071569,21,7.4949949648741878,57.822347280498441,9.7814760073380569,"0","0"]
[null,null,null,null,null,null,null,null,14,13,5.6803757999952129,24.169310244685345,13.593056589903103,-0.59305658990310306,8.4069434100968969,3.5336235586395293,23.90960188396452,1.4276765899193247,22,7.6222715510734629,58.296828498841151,9.7437006478523518,"0","0"]
[null,null,null,null,null,null,null,null,15,14,6.0903940547304281,24.268946994391339,14.533983700074172,-0.53398370007417206,8.4660162999258279,3.5729416670007841,24.004496996620986,1.5166237574277972,23,7.7630045156201612,58.805246023717729,9.7029572627599645,"0","0"]
[null,null,null,null,null,null,null,null,16,15,6.5004123094656432,24.37507433153247,15.466967195718723,-0.46696719571872336,8.5330328042812766,3.6167634144226453,24.105254013841609,1.6102868200754064,24,7.9180808884008549,59.349162556234887,9.6592582628906829,"0","0"]
[null,null,null,null,null,null,null,null,17,16,6.9104305642008574,24.487607867191155,16.391618935199041,-0.39161893519904112,8.6083810648009589,3.6653045170662626,24.211742643901033,1.7091595657781069,25,8.0884321408087878,59.930236560167074,9.6126169593831889,"0","0"]
[null,null,null,null,null,null,null,null,18,17,7.3204488189360726,24.606459708485964,17.307575022868299,-0.30757502286829919,8.6924249771317008,3.7187774803812963,24.323826866608638,1.8137689668068018,26,8.2750380817353282,60.55022974856621,9.5630475596303537,"0","0"]
[null,null,null,null,null,null,null,null,19,18,7.7304670736712877,24.731538764334836,18.214496139147968,-0.21449613914796828,8.7855038608520317,3.7773914651394969,24.4413650062939,1.9246770841916214,27,8.4789311022843155,61.211015283255357,9.5105651629515346,"0","0"]
[null,null,null,null,null,null,null,null,20,19,8.1404853284065037,24.86275105165722,19.112067721035572,-0.11206772103557228,8.8879322789644277,3.8413521550483116,24.564209807717972,2.0424831711723348,28,8.7012008099150329,61.914586767695653,9.4551857559931687,"0","0"]
[null,null,null,null,null,null,null,null,21,20,8.5505035831417189,25.000000000000004,20,0,9,3.9108616260057723,24.692208514878448,2.1678259982742936,29,8.9429990979667338,62.663068124272215,9.3969262078590852,"0","0"]
[null,null,null,null,null,null,null,null,22,21,8.960521837876934,25.143186752711959,20.878027905358209,0.12197209464179082,9.1219720946417908,3.9861182170572036,24.825202952672811,2.3013864256396483,30,9.2055457025585916,63.458724459183514,9.3358042649720172,"0","0"]
[null,null,null,null,null,null,null,null,23,22,9.3705400926121492,25.292210462945551,21.745910842155819,0.25408915784418085,9.2540891578441808,4.0673164031136686,24.963029611385213,2.4438902517558301,{"$f":"J42+$L$13/2","v":31},9.4901343058282759,64.303974032110361,9.2718385456678742,"0","0"]
[null,null,null,null,null,null,null,null,24,23,9.7805583473473643,25.446968582928438,22.603432353295915,0.39656764670408506,9.3965676467040851,4.1546466694912452,25.105519733959547,2.5961113717772397,32,9.7981392525286761,65.201401464002245,9.2050485345244031,"1","0"]
[null,null,null,null,null,null,null,null,25,24,10.190576602082579,25.607357145117369,{"$f":"ATAN(K44/($C$18/2))*180/PI()","v":23.450399676180602},0.54960032381939783,9.5496003238193978,4.2482953883295265,25.252499406021013,2.7588752833271615,33,10.13102295633673,66.153772335033082,9.1354545764260084,"0","1"]
[null,null,null,null,null,null,null,null,26,25,10.600594856817795,25.773271034020354,24.286643204458489,0.71335679554151099,9.713356795541511,4.3484446969470056,25.403789648606882,2.93306298310904,34,10.490344083068207,67.16404934650005,9.0630778703664987,"0","0"]
[null,null,null,null,null,null,null,null,27,26,11.01061311155301,25.944604247646247,25.112015865621434,0.88798413437856638,9.8879841343785664,4.4552723781900827,25.55920651356611,3.1196153039861971,35,10.877766610610545,68.235410245715158,8.9879404629916699,"0","0"]
[null,null,null,null,null,null,null,null,28,27,11.420631366288225,26.121250147711674,25.926392425180627,1.0736075748193734,10.073607574819373,4.5689517428317634,25.718561181586377,3.3195377495714893,36,11.295069880112393,69.371267742428131,8.9100652418836788,"0","0"]
[null,null,null,null,null,null,null,null,29,28,11.83064962102344,26.303101697900626,26.729668727993332,1.2703312720066684,10.270331272006668,4.6896515140751438,25.881660062805775,3.5339058920020259,37,11.744159770199641,70.575291679815237,8.8294759285892699,"0","0"]
[null,null,null,null,null,null,null,null,30,29,12.240667875758655,26.490051689630782,27.521760887025472,1.4782391129745278,10.478239112974528,4.8175357142159978,26.048304899965448,3.7638714086997322,38,12.227081146205572,71.851433763535937,8.7461970713939579,"0","0"]
[null,null,null,null,null,null,null,null,31,30,12.65068613049387,26.681992954930308,28.302604429440812,1.6973955705591877,10.697395570559188,4.952763553517836,26.218292874058296,4.0106688458289099,39,12.746031760192224,73.203955199966629,8.6602540378443873,"0","0"]
[null,null,null,null,null,null,null,null,32,31,13.060704385229085,26.878818566168842,29.072153409423752,1.9278465905762481,10.927846590576248,5.0954893213519323,26.391416712427759,4.2756232102141754,40,13.303377805615197,74.637457650899066,8.5716730070211238,"0","0"]
[null,null,null,null,null,null,null,null,33,32,13.470722639964302,27.080422022515226,29.830379496588012,{"$f":"J52-M52","v":2.1696205034119878},{"$f":"N52+$L$13/2","v":11.169620503411988},5.2458622796538501,26.567464799269661,{"$f":"P52/TAN((90-(J52+$L$13/2))*PI()/180)","v":4.5601585081134903},41,{"$f":"P52/SIN((90-(J52+$L$13/2))*PI()/180)*2","v":13.901671363719535},{"$f":"(Q52+R52+T52/2)*2","v":76.156917978485836},{"$f":"COS(J52*PI()/180)*$C$9/2*2","v":8.4804809615642593},{"$f":"IF(AND(T52<$C$9,T53>$C$9),\"1\",\"0\")","v":"0"},{"$f":"IF(AND(T52>$C$9,T51<$C$9),\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,34,33,13.880740894699517,27.286697423111949,30.577271048215135,2.4227289517848654,11.422728951784865,5.4040265587470842,26.746221288488968,4.8658073689888139,42,14.543670018224383,77.767727333179948,8.3867056794542414,"0","0"]
[null,null,null,null,null,null,null,null,35,34,14.290759149434733,27.497539627061784,31.312832172921407,2.6871678270785928,11.687167827078593,5.5701210555833987,26.927466218862474,5.1942219159445555,43,15.232358961885353,79.475735231499414,8.2903757255504154,"0","0"]
[null,null,null,null,null,null,null,null,36,35,14.700777404169948,27.712844400415385,32.037081792683573,2.9629182073164273,11.962918207316427,5.7442793344485272,27.110975631457123,5.5471860726331936,44,15.970975974759726,81.287299382940361,8.1915204428899173,"0","0"]
[null,null,null,null,null,null,null,null,37,36,15.110795658905163,27.932508550430409,32.750052709476854,3.2499472905231457,12.249947290523146,5.9266295301807848,27.296521689252955,5.9266295301807856,45,16.763039721485104,83.209342160352577,8.0901699437494745,"0","0"]
[null,null,null,null,null,null,null,null,38,37,15.520813913640378,28.156430047442687,33.451790682103713,3.548209317896287,12.548209317896287,6.1172942539492201,27.483872798918515,6.3346436383412845,46,17.612381896174959,85.249414770694557,7.9863551004729283,"0","0"]
[null,null,null,null,null,null,null,null,39,38,15.930832168375593,28.384508134748984,34.142353518129532,3.8576464818704679,12.857646481870468,6.3163905016367865,27.672793734685765,6.7734995342523989,47,18.5231838418437,87.41577037972003,7.8801075360672197,"0","0"]
[null,null,null,null,null,null,null,null,40,39,16.340850423110808,28.616643426949313,34.821810185199389,4.1781898148006107,13.178189814800611,6.5240295648729392,27.863045764270375,7.2456688818635397,{"$f":"J59+$L$13/2","v":48},19.500018390652027,89.717447682919854,7.771459614569709,"0","0"]
[null,null,null,null,null,null,null,null,41,40,16.750868677846025,28.852737997235614,35.490239945395331,4.5097600546046692,13.509760054604669,6.7403169447590692,28.054386776782657,7.7538476679072739,49,20.547897816849034,92.16436670622889,7.6604444311897799,"0","0"]
[null,null,null,null,null,null,null,null,42,41,17.160886932581239,29.092695454143094,36.147731515711556,4.8522684842884445,13.852268484288444,6.9653522683289921,28.246571412573289,8.3009835894653072,50,21.67232897263127,94.767438976708462,7.5470958022277213,"0","0"]
[null,null,null,null,null,null,null,null,43,42,17.570905187316455,29.336421008302036,36.794382257179286,5.2056177428207135,14.205617742820714,7.1992292077855309,28.439351194957187,8.8903076779384449,51,22.879376896641528,97.538694642432802,7.431448254773942,"0","0"]
[null,null,null,null,null,null,null,null,44,43,17.980923442051669,29.583821529741623,37.43029739466612,5.5697026053338803,14.56970260533388,7.4420354025532385,28.632474663758078,9.52537093998267,52,24.175738456322041,100.49142966380353,7.3135370161917059,"0","0"]
[null,null,null,null,null,null,null,null,45,44,18.390941696786886,29.834805596304715,38.055589268909095,5.9444107310909047,14.944410731090905,7.6938523841860107,28.825687510615428,10.210086964745891,53,25.568827922868795,103.64037687359144,7.1933980033865117,"0","0"]
[null,null,null,null,null,null,null,null,46,45,18.800959951522099,30.08928353373371,38.670376621915814,6.329623378084186,15.329623378084186,7.9547555041672195,29.01873271599468,10.948781657704316,54,27.066876799450736,107.00190554684873,7.0710678118654755,"0","0"]
[null,null,null,null,null,null,null,null,47,46,19.210978206257316,30.34716744798391,39.27478391648507,6.7252160835149297,15.72521608351493,8.2248138646387456,29.211350687840856,11.746251526608733,55,28.679050753768802,110.59425518266798,6.9465837045899734,"0","0"]
[null,null,null,null,null,null,null,null,48,47,19.620996460992529,30.608371250312587,39.868940690254995,7.1310593097450052,16.131059309745005,8.5040902520942083,29.403279401815002,12.607832280464541,56,30.415587176846508,114.43781054140558,6.819983600624985,"0","0"]
[null,null,null,null,null,null,null,null,49,48,20.031014715727746,30.872810675680022,40.452980944383825,7.5470190556161754,16.547019055616175,8.7926410740702785,29.59425454305201,13.539479929357844,57,32.287957743710685,118.55542668853039,6.6913060635885824,"0","0"]
[null,null,null,null,null,null,null,null,50,{"$f":"J68+$K$17","v":49},20.44103297046296,31.140403294983745,41.027042566701795,7.9729574332982054,16.972957433298205,9.0905162988688843,29.784009649377865,14.547867119890329,58,34.309061445512441,122.97281498404882,6.5605902899050728,"0","0"]
[null,null,null,null,null,null,null,null,51,{"$f":"J69+$K$17","v":50},20.851051225198177,31.411068521629744,41.591266788942249,8.4087332110577506,17.408733211057751,9.3977593983417744,29.972276255923539,15.640498146726964,59,36.493454974112318,127.71900377941333,6.4278760968653934,"0","0"]
[null,null,null,null,null,null,null,null,52,{"$f":"J70+$K$17","v":51},21.26106947993339,31.684727612924746,{"$f":"ATAN(K71/($C$18/2))*180/PI()","v":42.145797677462532},{"$f":"J71-M71","v":8.8542023225374678},{"$f":"N71+$L$13/2","v":17.854202322537468},{"$f":"SIN(O71*PI()/180)*L71","v":9.7144072937676498},{"$f":"COS(O71*PI()/180)*L71","v":30.158784041072177},{"$f":"P71/TAN((90-(J71+$L$13/2))*PI()/180)","v":16.825846998223252},{"$f":"J71+$L$13/2","v":60},{"$f":"P71/SIN((90-(J71+$L$13/2))*PI()/180)*2","v":38.857629175070606},{"$f":"(Q71+R71+T71/2)*2","v":132.82689125366147},6.2932039104983755,"0","0"]
[null,null,null,null,null,null,null,null,53,52,21.671087734668607,31.961303666752784,42.690781656698746,9.3092183433012536,18.309218343301254,10.040490304850822,30.343260973675548,18.113523996290617,61,41.420342689359749,138.33391262929209,6.1566147532565827,"0","0"]
[null,null,null,null,null,null,null,null,54,53,22.08110598940382,32.240721613977037,43.226367064460099,9.7736329355399008,18.773632935539901,10.376032101869052,30.525433461475185,19.514478179268252,62,44.203027081327988,144.28285036281488,6.018150231520484,"0","0"]
[null,null,null,null,null,null,null,null,55,54,22.491124244139037,32.522908206985115,43.752703738056411,10.247296261943589,19.247296261943589,10.721049660996838,30.705026500663035,21.04124469471483,63,47.230281986726503,150.72282437748223,5.8778525229247318,"0","0"]
[null,null,null,null,null,null,null,null,56,55,22.90114249887425,32.807792004772665,44.269942630163158,10.730057369836842,19.730057369836842,11.075553222829297,30.881763826515815,22.708249320382862,64,50.530484517304728,157.7105108111021,5.7357643635104614,"0","0"]
[null,null,null,null,null,null,null,null,57,56,23.311160753609467,33.095303354936981,44.77823545326082,11.22176454673918,20.22176454673918,11.439546254130216,31.055368065036973,24.532186109471446,65,54.136544914138298,165.31165326315514,5.5919290347074675,"0","0"]
[null,null,null,null,null,null,null,null,58,57,23.721179008344681,33.38537437292883,45.277734351436017,11.722265648563983,20.722265648563983,11.813025412826685,31.225560885539334,26.532489488273772,66,58.086851105889608,173.60295185351583,5.4463903501502724,"0","0"]
[null,null,null,null,null,null,null,null,59,58,24.131197263079898,33.677938918888067,45.768591598299174,12.231408401700826,21.231408401700826,12.195980516271323,31.392063154101322,28.731929552798192,67,62.426459665120461,182.67444507891949,5.2991926423320486,"0","0"]
[null,null,null,null,null,null,null,null,60,59,24.541215517815111,33.972932572366048,46.250959319755673,12.749040680244327,21.749040680244327,12.588394512791687,31.554595087829064,31.157369764228545,68,67.208611562345098,192.63254126646029,5.1503807491005436,"0","0"]
[null,null,null,null,null,null,null,null,61,60,24.951233772550328,34.270292605216206,46.724989240361431,13.275010759638569,22.275010759638569,12.990243456545226,31.712876409856303,33.840741176356183,69,72.496680984040765,203.60391615646574,5.0000000000000009,"0","0"]
[null,null,null,null,null,null,null,null,62,61,25.361252027285541,34.569957952913043,47.190832451999533,13.809167548000467,22.809167548000467,13.401496485696617,31.866626505013627,36.820308981351936,70,78.366708787299842,215.74057976003098,4.8480962024633714,"0","0"]
[null,null,null,null,null,null,null,null,63,62,25.771270282020758,34.871869184539662,47.648639203628768,14.351360796371232,23.351360796371232,13.822115803932965,32.015564576098193,40.142339070277018,71,84.910735983865365,229.22654327661581,4.6947156278589084,"0","0"]
[null,null,null,null,null,null,null,null,64,63,26.181288536755972,35.175968471664717,48.098558710877043,14.901441289122957,23.901441289122957,14.252056665331128,32.159409800674837,43.863320169778461,72,92.241248376381009,244.28670831728761,4.5399049973954684,"0","0"]
[null,null,null,null,null,null,null,null,65,64,26.591306791491188,35.482199556311137,48.540738984281234,15.459261015718766,24.459261015718766,14.691267362589768,32.297881488339002,48.052970321777337,73,100.49718988040827,261.19889350064096,{"$f":"COS(J84*PI()/180)*$C$9/2*2","v":4.3837114678907749},{"$f":"IF(AND(T84<$C$9,T85>$C$9),\"1\",\"0\")","v":"0"},{"$f":"IF(AND(T84>$C$9,T83<$C$9),\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,66,65,{"$f":"$C$19/360*(J85+$C$21)","v":27.001325046226402},{"$f":"SQRT(K85^2+($C$18/2)^2)","v":35.790507718201681},48.975326675008723,16.024673324991277,25.024673324991277,15.139689218637486,32.430699238371751,52.798370856338849,74,109.85223083252193,280.31037102194313,4.2261826174069945,"0","0"]
[null,null,null,null,null,null,null,null,67,66,27.411343300961619,36.100839741449974,49.40246693693382,16.59753306306618,25.59753306306618,15.597256581626951,32.557583097717014,58.209754021319853,75,120.52634361160499,302.06101784967871,4.0673664307580024,"0","0"]
[null,null,null,null,null,null,null,null,68,67,27.821361555696832,36.413143880850036,49.822303303982835,17.177696696017165,26.177696696017165,16.063896823323539,32.678253719210616,64.428771097273071,76,132.80233923022882,327.0163888631962,3.9073112848927396,"0","0"]
[null,null,null,null,null,null,null,null,69,68,28.231379810432049,36.727369827902884,50.234977581705415,17.765022418294585,26.765022418294585,16.539530340895535,32.792432519990754,71.640576643579806,77,147.05003618798651,355.9160545151276,3.7460659341591196,"0","0"]
[null,null,null,null,null,null,null,null,70,69,28.641398065167262,37.043468676705309,50.640629752074361,18.359370247925639,27.359370247925639,17.024070562111522,32.899841840019462,80.091954952395668,78,163.76251373987063,389.74610732470092,3.583679495453004,"0","0"]
[null,null,null,null,null,null,null,null,71,{"$f":"J89+$K$17","v":70},29.051416319902479,37.361392889813104,{"$f":"ATAN(K90/($C$18/2))*180/PI()","v":51.03939789056205},{"$f":"J90-M90","v":18.96060210943795},27.96060210943795,{"$f":"SIN(O90*PI()/180)*L90","v":17.51742395394928},{"$f":"COS(O90*PI()/180)*L90","v":33.000205100644166},{"$f":"P90/TAN((90-(J90+$L$13/2))*PI()/180)","v":90.119333751744279},{"$f":"J90+$L$13/2","v":79},{"$f":"P90/SIN((90-(J90+$L$13/2))*PI()/180)*2","v":183.61213966228564},{"$f":"(Q90+R90+T90/2)*2","v":429.85121736706253},3.4202014332566884,"0","0"]

{"sheet":"Evolvente berechnen (2)","index":5,"n_rows":90,"n_cols":30,"rows_kept":90,"cut":false,"hidden":false,"merged":[[17,25,17,29],[13,17,13,18],[14,17,14,18],[15,17,15,18],[17,22,17,23],[12,17,12,18],[7,9,7,10],[7,17,7,18],[8,9,8,10],[8,17,8,18],[9,17,9,18],[10,14,11,14],[10,15,11,15],[10,17,10,18],[11,17,11,18],[3,17,3,19],[4,17,4,18],[5,17,5,18],[6,15,8,15],[6,17,6,18]]}
[null,null,null,null,null,null,null,null,"Dezimalwinkel in Bogenmass= WertxPi()/180",null,null,null,null,null,null,null,null,null,null,22.26959900071606]
[null,null,null,null,null,null,null,null,"Bogenmass in Dezimalwinkel=Wertx180/Pi()"]
[null,"Zahnradmessung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solver",null,null,null,null,"Formelspeicher"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bogenlänge Bl:",null,{"$f":"$C$19/360*(T10+$C$21)","v":29.311745593057413}]
[null,"Gegeben:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strecke a:",null,4.4949006200542359,null,null,{"$f":"SIN($T$13*PI()/180)*$T$8","v":4.5181603957015639}]
[null,"Modul:",5,null,null,null,null,null,null,null,null,null,null,null,null,"Werte für Solverlauf",null,"Strecke b:",null,76.206803705415098,null,null,{"$f":"COS($T$13*PI()/180)*$T$8","v":76.20708705352564}]
[null,"Zähnezahl",30,null,null,null,null,null,null,"Öffnungswinkel:",null,{"$f":"360/(C8*2)","v":6},null,null,null,null,null,"Strecke c:",null,76.340905748785303,null,null,{"$f":"SQRT($T$5^2+($C$18/2)^2)","v":76.329407347261949}]
[null,"Messkugeldurchmesser:",10,null,null,null,null,null,null,"Winkelkorrektur von Zahn und Zahnlücke:",null,0,null,null,null,null,null,"Strecke b2:",null,2.2059837948312238,null,null,{"$f":"$T$6/TAN((90-($T$10+$L$13/2))*PI()/180)","v":2.1899470711946467}]
[null,"Eingriffswinkel",20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Teilungswinkel:",null,22.975668197989542,null,null,28.197236696908405]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solverlauf durchführen","Wichtiger Hinweis!",null,"Winkel Alpha 2:",null,{"$f":"ATAN(T5/($C$18/2))*180/PI()","v":22.582691852222425}]
[null,null,null,null,null,null,null,null,null,null,"Breite am Teilkreisdurchm.","Winkel",null,null,null,null,null,"Winkel Alpha 3:",null,{"$f":"T10-T11","v":0.39297634576711715},null,null,"Korrekturwert"]
[null,"Gesucht:",null,null,null,null,null,null,null,"Zahnlücke:",{"$f":"TAN((L8+L9)/2*PI()/180)*(C20/2)*2","v":7.8611668924561791},{"$f":"L8+L9","v":6},"(Alpha z)",null,null,null,null,"Winkel alpha 4:",null,{"$f":"T12+$L$13/2","v":3.3929763457671172},null,null,0.15]
[null,"Öffnungswinkel",{"$f":"360/C20","v":2.4},null,null,null,null,null,null,"Zahn:",{"$f":"TAN((L8-L9)/2*PI()/180)*(C20/2)*2-L11","v":7.8611668924561791},{"$f":"L8-L9","v":6},null,null,null,null,null,"Zahnlückenwinkel:",null,{"$f":"L13","v":6}]
[null,"Ankathete a",{"$f":"SIN((C14/2)*PI()/180)*C20/2","v":1.5706814912517717},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kugel Ø",null,{"$f":"$T$6/SIN((90-($T$10+$T$14/2))*PI()/180)*2","v":9.9999999517595928}]
[null,"Gegenkathete b",{"$f":"COS((C14/2)*PI()/180)*C20/2","v":74.98355126061341},null,null,null,null,null,null,"Startwinkel",0,null,"Winkel für Vektor",{"$f":"L9","v":0},"±Grad",null,null,"Zweikugelmaß Mdk:",null,{"$f":"(T7+T9+T15/2)*2-W13","v":166.67557495225225}]
[null,"Berührpunktabstand Bab",{"$f":"C15*2","v":3.1413629825035434},null,null,null,null,null,null,"Inkrement",1]
[null,"Grundkreisdurchmesser dg",{"$f":"COS(C10*PI()/180)*C20","v":140.95389311788625},null,null,null,null,null,null,null,null,null,null,null,null,null,"dm/2",null,null,"DM","Mdk","Kugel-XM","Trefferindikator",null,"Abweichung","Suchbandgrenze nach unten"]
[null,"Teilkreisumfang",{"$f":"C18*PI()","v":442.81971511403236},null,null,"Winkel","Bogenlänge",null,null,"Teilungsw. Alpha","Bogenlänge Bl","Strecke c","Winkel alpha 2","Winkel alpha 3","Winkel alpha 4","Strecke a","Strecke b","Strecke b2","Vektorwinkel","Kugel Ø","Prüfmaß",null,"Untergrenze","Obergrenze","in Prozent","Strecke b2","Strecke b","Strecke a","Strecke c","Teilungsw. Alpha"]
[null,"Teilkreisdurchmesser:",{"$f":"C8*C7","v":150},null,1,1,{"$f":"$C$19/360*F20","v":1.2300547642056454},null,1,{"$f":"K16","v":0},{"$f":"$C$19/360*(J20+$C$21)","v":1.0504154653122446},{"$f":"SQRT(K20^2+($C$18/2)^2)","v":70.484774021925418},{"$f":"ATAN(K20/($C$18/2))*180/PI()","v":0.85389506731546183},{"$f":"J20-M20","v":-0.85389506731546183},{"$f":"N20+$L$13/2","v":2.1461049326845383},{"$f":"SIN(O20*PI()/180)*L20","v":2.6395024838213623},{"$f":"COS(O20*PI()/180)*L20","v":70.43533485090984},{"$f":"P20/TAN((90-(J20+$L$13/2))*PI()/180)","v":0.13833046358914936},{"$f":"J20+$L$13/2","v":3},{"$f":"P20/SIN((90-(J20+$L$13/2))*PI()/180)*2","v":5.2862495889830745},{"$f":"(Q20+R20+T20/2)*2","v":146.43358021798107},{"$f":"COS(J20*PI()/180)*$C$9/2*2","v":10},{"$f":"IF(AND(T20<$C$9,T21>$C$9),\"1\",\"0\")","v":"0"},{"$f":"IF(AND(T20>$C$9,T19<$C$9),\"1\",\"0\")","v":"0"},{"$f":"IF(AND(T20>$C$9,T19<$C$9),(100/(T20-T19))*(T20-$C$9),\"0\")","v":"0"},{"$f":"IF(AND(T20>$C$9,T19<$C$9),R20-((R20-R19)/100*Y20),\"0\")","v":"0"},{"$f":"IF(AND(T20>$C$9,T19<$C$9),Q20-((Q20-Q19)/100*Y20),\"0\")","v":"0"},{"$f":"IF(AND(T20>$C$9,T19<$C$9),P20-((P20-P19)/100*Y20),\"0\")","v":"0"},{"$f":"IF(AND(T20>$C$9,T19<$C$9),L20-((L20-L19)/100*Y20),\"0\")","v":"0"}]
[null,"Korrektur inv alpha y",{"$f":"(TAN(C10*PI()/180)-(PI()/9))*180/PI()","v":0.85395829184125016},null,2,3,3.6901642926169362,null,2,{"$f":"J20+$K$17","v":1},{"$f":"$C$19/360*(J21+$C$21)","v":2.2804702295178902},{"$f":"SQRT(K21^2+($C$18/2)^2)","v":70.513832265306945},{"$f":"ATAN(K21/($C$18/2))*180/PI()","v":1.8533116546953032},-0.85331165469530323,2.146688345304697,{"$f":"SIN(O21*PI()/180)*L21","v":2.6413081535502205},{"$f":"COS(O21*PI()/180)*L21","v":70.464345820974103},0.1846982585381674,{"$f":"J21+$L$13/2","v":4},5.2955159177243187,{"$f":"(Q21+R21+T21/2)*2","v":146.59360407674885},9.9984769515639123,"0","0","0","0","0","0","0"]
[null,"Bogenlänge",{"$f":"C19/360*C21","v":1.0504154653122446},null,3,5,6.1502738210282271,null,3,{"$f":"J21+$K$17","v":2},3.5105249937235357,70.564323719594199,2.8516014497556528,-0.85160144975565277,2.1483985502443472,2.6453042376657554,70.514722912976637,0.23143413237284008,5,5.3108177402127339,146.8031318309117,9.993908270190957,"0","0","0","0","0","0","0"]
[null,"dp-Wert",{"$f":"C8/C20","v":0.2},null,4,10,12.300547642056454,null,4,3,4.7405797579291811,70.636202422790348,3.848161632997249,-0.848161632997249,2.151838367002751,2.6522365536026631,70.586391988662712,0.27876129471008115,6,5.3336916280169682,147.06399819476255,9.9862953475457381,"0","0","0","0","0","0","0"]
[null,null,null,null,5,20,24.601095284112908,null,5,4,5.9706345221348265,70.729403170598246,4.8423956529436989,-0.84239565294369889,2.1576043470563011,2.6628488845363205,70.679259395434798,0.32695673103858142,7,5.3656928297649547,147.3781250827117,9.9756405025982424,"0","0","0","0","0","0","0"]
[null,"Kugelabschnittsrechner",null,null,6,30,36.901642926169359,null,6,5,7.2006892863404719,70.843841810495746,5.8337153366508483,-0.83371533665084829,2.1662846633491517,2.677882525612433,70.793212016757408,0.37635184538452016,8,5.4083992206584588,147.74752694494231,9.961946980917455,"0","0","0","0","0","0","0"]
[null,"Winkel:",20,null,7,40,49.202190568225816,null,7,6,8.4307440505461173,70.979415618318143,6.8215429253394202,-0.82154292533942019,2.1784570746605798,2.6980758313509838,70.928117332453041,0.4273332305016837,9,5.4634153719486882,148.17431649785814,9.9452189536827333,"0","0","0","0","0","0","0"]
[null,"Kugelabschnitt l:",{"$f":"COS(C26*PI()/180)*C9/2*2","v":9.3969262078590852},null,8,50,61.502738210282274,null,8,7,9.6607988147517627,71.136003753452684,7.8053130180273769,-0.80531301802737687,2.1946869819726231,2.7241637644314243,71.083823488862734,0.48034357153759932,10,5.5323767630770364,148.6607108838777,9.9254615164132201,"0","0","0","0","0","0","0"]
[null,null,null,null,9,60,73.803285852338718,null,9,8,10.890853578957408,71.313467788002114,8.7844744075374717,-0.78447440753747166,2.2155255924625283,2.7568774460655026,71.260159378840783,0.53588269022101653,11,5.6169541605048412,149.20903829862843,9.9026806874157032,"0","0","0","0","0","0","0"]
[null,null,null,null,10,70,86.103833494395175,null,10,9,12.120908343163054,71.511652304610365,9.7584917949759209,-0.7584917949759209,2.2415082050240791,2.7969437081634241,71.456934731548969,0.59450873779181956,12,5.7188581888155916,149.82174512749717,9.8768834059513786,"0","0","0","0","0","0","0"]
[null,null,null,null,11,80,98.404381136451633,null,11,10,13.350963107368699,71.730385557073689,10.726847370676577,-0.72684737067657679,2.2731526293234232,2.8450846474983584,71.673940212011615,0.65683954616705609,13,5.8398441214949575,150.50140363785229,9.8480775301220795,"0","0","0","0","0","0","0"]
[null,null,null,null,12,90,110.70492877850809,null,12,11,14.581017871574344,71.969480187391213,11.689042251634971,-0.68904225163497124,2.3109577483650288,2.9020171820734877,71.910947530388214,0.72355414822297826,14,5.9817169209050425,151.2507202781274,9.8162718344766393,"0","0","0","0","0","0","0"]
[null,null,null,null,null,null,null,null,13,12,15.81107263577999,72.228733992546466,12.644597767570353,-0.64459776757035314,2.3554022324296469,2.9684526098947837,72.167709560916833,0.79539447959136578,15,6.146336559400428,152.07254464041682,9.7814760073380569,"0","0","0","0","0","0","0"]
[null,null,null,null,null,null,null,null,14,13,17.041127399985633,72.507930734056032,13.593056589903101,-0.59305658990310128,2.4069434100968987,3.0450961703518971,72.443960470476597,0.87316727604022348,16,6.3356236563228068,152.96987914935644,9.7437006478523518,"0","0","0","0","0","0","0"]
[null,null,null,null,null,null,null,null,15,14,18.271182164191281,72.806840983174013,14.533983700074172,-0.53398370007417206,2.4660162999258279,3.1326466084083071,72.73941585671426,0.95774618235783304,17,6.5515654687999794,153.94588954694419,9.7029572627599645,"0","0","0","0","0","0","0"]
[null,null,null,null,null,null,null,null,16,15,19.501236928396928,73.125222994597408,15.466967195718723,-0.46696719571872336,2.5330328042812766,3.231795741800815,73.05377289567511,1.0500740907127213,18,6.7962222779152919,155.00391625069096,9.6592582628906829,"0","0","0","0","0","0","0"]
[null,null,null,null,null,null,null,null,17,16,20.731291692602568,73.462823601573461,16.391618935199038,-0.39161893519903757,2.6083810648009624,3.3432280314472398,73.386710498874692,1.1511657287513342,19,7.071734215963204,156.14748667121526,9.6126169593831889,"0","0","0","0","0","0","0"]
[null,null,null,null,null,null,null,null,18,17,21.961346456808215,73.819379125457885,17.307575022868299,-0.30757502286829919,2.6924249771317008,3.4676201552597878,73.737889479743885,1.2621105202561103,20,7.380328585233876,157.38032858523388,9.5630475596303537,"0","0","0","0","0","0","0"]
[null,null,null,null,null,null,null,null,19,18,23.191401221013859,74.194616293004501,18.214496139147968,-0.21449613914796828,2.7855038608520317,3.6056405855603062,74.106952729375735,1.384075744060639,21,7.7243277241548158,158.70638467102756,9.5105651629515346,"0","0","0","0","0","0","0"]
[null,null,null,null,null,null,null,null,20,19,24.421455985219506,74.588253154971653,19.112067721035569,-0.11206772103556872,2.8879322789644313,3.7579491702920049,74.49352540149809,1.5183100201534374,22,8.1061574827526517,160.1298283260557,9.4551857559931687,"0","0",{"$f":"IF(AND(T39>$C$9,T38<$C$9),(100/(T39-T38))*(T39-$C$9),\"0\")","v":"0"},"0","0","0","0"]
[null,null,null,null,null,null,null,null,21,20,25.65151074942515,75,19.999999999999996,0,3,3.925196718220787,74.897215106593038,1.6661471555533129,23,8.528356376392729,161.65508090068545,9.3969262078590852,"0","0","0","0","0","0","0"]
[null,null,null,null,null,null,null,null,22,21,26.881565513630797,75.429560258135865,20.878027905358209,0.12197209464179082,3.1219720946417908,4.1080245883176891,75.317612115079214,1.829010386671825,24,8.9935854947348197,163.2868304982369,9.3358042649720172,"0","0","0","0","0","0","0"]
[null,null,null,null,null,null,null,null,23,22,28.11162027783644,75.876631388836643,21.745910842155816,0.2540891578441844,3.2540891578441844,4.307064283512152,75.754289569469819,2.0084170595675883,{"$f":"J42+$L$13/2","v":25},9.5046392519586274,165.03005251003344,9.2718385456678742,"1","0","0","0","0","0","0"]
[null,null,null,null,null,null,null,null,24,23,29.341675042042088,76.340905748785303,22.603432353295915,0.39656764670408506,3.3965676467040851,4.5229370490041321,76.206803705415098,2.2059837948312238,26,10.064457074738243,166.89003207523089,9.2050485345244031,"0","1",{"$f":"IF(AND(T43>$C$9,T42<$C$9),(100/$C$9)*(T43)-100,\"0\")","v":0.64457074738243136},{"$f":"IF(AND(T43>$C$9,T42<$C$9),R43-((R43-R42)/100*Y43),\"0\")","v":2.2047103374491557},{"$f":"IF(AND(T43>$C$9,T42<$C$9),Q43-((Q43-Q42)/100*Y43),\"0\")","v":76.203886931667029},{"$f":"IF(AND(T43>$C$9,T42<$C$9),P43-((P43-P42)/100*Y43),\"0\")","v":4.521545596306205},{"$f":"IF(AND(T43>$C$9,T42<$C$9),L43-((L43-L42)/100*Y43),\"0\")","v":76.33791317207347},{"$f":"IF(AND($T$43>$C$9,$T$42<$C$9),K43-((K43-K42)/100*Y43),\"0\")","v":29.333746468855235}]
[null,null,null,null,null,null,null,null,25,24,30.571729806247731,76.8220714353521,23.450399676180599,0.54960032381940138,3.5496003238194014,4.7562534753212065,76.674694081534071,2.4234321899224773,27,10.676136136385207,168.8723886792983,9.1354545764260084,"0","0",{"$f":"IF(AND(T44>$C$9,T43<$C$9),(100/(T44-T43))*(T44-$C$9),\"0\")","v":"0"},{"$f":"IF(AND(T44>$C$9,T43<$C$9),R44-((R44-R43)/100*Y44),\"0\")","v":"0"},{"$f":"IF(AND(T44>$C$9,T43<$C$9),Q44-((Q44-Q43)/100*Y44),\"0\")","v":"0"},{"$f":"IF(AND(T44>$C$9,T43<$C$9),P44-((P44-P43)/100*Y44),\"0\")","v":"0"},{"$f":"IF(AND(T44>$C$9,T43<$C$9),L44-((L44-L43)/100*Y44),\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,26,25,31.801784570453378,77.319813102061062,24.286643204458485,0.71335679554151454,3.7133567955415145,5.0076131063047651,77.157483817937049,2.6625951187338792,28,11.34294525927737,170.98310313261922,9.0630778703664987,"0","0","0","0","0","0","0"]
[null,null,null,null,null,null,null,null,27,26,33.031839334659026,77.833812742938733,25.112015865621434,0.88798413437856638,3.8879841343785664,5.277604052207554,77.654679843335742,2.9254236961224596,29,12.068340123432449,173.22854720234886,8.9879404629916699,"0","0","0","0","0","0","0"]
[null,null,null,null,null,null,null,null,28,27,34.261894098864666,78.363750443135018,25.926392425180627,1.0736075748193734,4.0736075748193734,5.5668026080826092,78.16577315063536,3.2139949843020061,30,12.855979937208021,175.61551620708275,8.9100652418836788,"0","0","0"]
[null,null,null,null,null,null,null,null,29,28,35.491948863070313,78.909305093701875,26.729668727993332,1.2703312720066684,4.2703312720066684,5.8757728776414524,78.690239060898136,3.5305205285249941,31,13.709745747017093,178.15126492586333,8.8294759285892699,"0","0","0"]
[null,null,null,null,null,null,null,null,30,29,36.72200362727596,79.470155068892339,27.521760887025472,1.4782391129745278,4.4782391129745278,6.2050664027573008,79.227537495565059,3.8773558216452959,32,14.633760587118282,180.84354722153898,8.7461970713939579,"0","0","0"]
[null,null,null,null,null,null,null,null,31,30,37.952058391481607,80.045978864790925,28.302604429440812,1.6973955705591877,4.6973955705591877,6.5552217987866408,79.777113256818637,4.2570108112258893,33,15.632411698542445,183.70065983463149,8.6602540378443873,"0","0","0"]
[null,null,null,null,null,null,null,null,32,31,39.182113155687247,80.636455698506524,29.072153409423745,1.9278465905762552,4.9278465905762552,6.9267643958801477,80.33839631596571,4.6721615791820454,34,16.710375078736888,186.7314908690324,8.5716730070211238,"0","0","0"]
[null,null,null,null,null,null,null,null,33,32,40.412167919892902,81.241266067545666,29.830379496588012,2.1696205034119878,5.1696205034119878,7.3202058864514257,80.910802109716528,5.1256633429403795,35,17.872642661363859,{"$f":"(Q52+R52+T52/2)*2","v":189.94557356667769},{"$f":"COS(J52*PI()/180)*$C$9/2*2","v":8.4804809615642593},{"$f":"IF(AND(T52<$C$9,T53>$C$9),\"1\",\"0\")","v":"0"},{"$f":"IF(AND(T52>$C$9,T51<$C$9),\"1\",\"0\")","v":"0"},"0"]
[null,null,null,null,null,null,null,null,34,33,41.642222684098549,81.860092269335837,30.577271048215135,2.4227289517848654,5.4227289517848654,7.736043978969863,81.493731844232173,5.620564949241416,36,19.124552469869407,193.35314605681657,8.3867056794542414,"0","0","0"]
[null,null,null,null,null,null,null,null,35,34,42.872277448304189,82.492618881185351,31.312832172921404,2.6871678270785964,5.6871678270785964,8.1747620582405567,82.086572806809571,6.1601250576138264,37,20.471822140131163,196.96521786897796,8.2903757255504154,"0","0","0"]
[null,null,null,null,null,null,null,null,36,35,44.102332212509836,83.138533201246148,32.037081792683573,2.9629182073164273,5.9629182073164273,8.6368288523326164,82.688698685069554,6.7478302409259809,38,21.92058626814897,200.79364412014004,8.1915204428899173,"0","0","0"]
[null,null,null,null,null,null,null,null,37,36,45.332386976715483,83.79752565129121,32.750052709476854,3.2499472905231457,6.2499472905231457,9.1226981063135675,83.299469893510548,7.3874152661510566,39,23.477438110108935,204.85120842943212,8.0901699437494745,"0","0","0"]
[null,null,null,null,null,null,null,null,38,37,46.56244174092113,84.469290142328063,33.451790682103713,3.548209317896287,6.548209317896287,9.6328082629452325,83.918233907287004,8.0828858606388003,40,25.149476246377823,209.15171578222942,7.9863551004729283,"0","0","0"]
[null,null,null,null,null,null,null,null,39,38,47.792496505126771,85.153524404246951,34.142353518129532,3.8576464818704679,6.8576464818704679,10.167582150493573,84.544325603068387,8.8385443190810538,41,26.944356920690865,213.71009676498974,7.8801075360672197,"0","0","0"]
[null,null,null,null,null,null,null,null,40,39,49.022551269332418,85.849930280847943,34.821810185199389,4.1781898148006107,7.1781898148006107,10.727426677801814,85.177067606832054,9.6590183656012965,{"$f":"J59+$L$13/2","v":42},28.870352884205431,218.54252482907214,7.771459614569709,"0","0","0"]
[null,null,null,null,null,null,null,null,41,40,50.252606033538065,86.558213991706822,35.490239945395331,4.5097600546046692,7.5097600546046692,11.312732536773627,85.815770648439283,10.549293755981786,43,30.936419715188311,223.66654852403047,7.6604444311897799,"0","0","0"]
[null,null,null,null,null,null,null,null,42,41,51.482660797743712,87.278086362429278,36.147731515711556,4.8522684842884445,7.8522684842884445,11.9238739124098,86.459733922841892,11.514751189429054,44,33.152270753811408,229.1012409783533,7.5470958022277213,"0","0","0"]
[null,null,null,null,null,null,null,null,43,42,52.712715561949352,88.00926302490609,36.794382257179286,5.2056177428207135,8.2056177428207135,12.561208200538557,87.108245457762635,12.561208200538559,45,35.528461993987541,234.86736931058994,7.431448254773942,"0","0","0"]
[null,null,null,null,null,null,null,null,44,43,53.942770326154999,88.751464589224852,37.43029739466612,5.5697026053338803,8.5697026053338803,13.225075733377153,87.760582487691323,13.694966824088091,46,38.076488518057161,240.98758714161596,7.3135370161917059,"0","0","0"]
[null,null,null,null,null,null,null,null,45,44,55.172825090360647,89.504416788914142,38.055589268909081,5.9444107310909189,8.9444107310909189,13.91579951305849,88.416011834033867,14.92286797278064,47,40.808894355063387,247.48665396869239,7.1933980033865117,"0","0","0"]
[null,null,null,null,null,null,null,null,46,45,56.402879854566294,90.267850601201133,38.670376621915814,6.329623378084186,9.329623378084186,14.633684953253653,89.073790291250575,16.25235364715116,48,43.739398001488311,254.39168587829181,7.0710678118654755,"0","0","0"]
[null,null,null,null,null,null,null,null,47,46,57.632934618771934,91.04150234395172,39.274783916485063,6.7252160835149368,9.7252160835149368,15.379019629017799,89.733165018815939,17.691538315253851,49,46.883036280079381,261.73244294821893,6.9465837045899734,"0","0","0"]
[null,null,null,null,null,null,null,null,48,47,58.862989382977581,91.825113750937746,39.868940690254995,7.1310593097450052,10.131059309745005,16.15207303498325,90.393373938830393,19.249291067285355,50,50.256329747426037,269.54165975965753,6.819983600624985,"0","0","0"]
[null,null,null,null,null,null,null,null,49,48,60.093044147183228,92.618432027040058,40.452980944383818,7.5470190556161825,10.547019055616182,16.953096352020921,91.053646139111493,20.935330479575391,51,53.877473519456849,277.85542675683058,6.6913060635885824,"0","0","0"]
[null,null,null,null,null,null,null,null,50,{"$f":"J68+$K$17","v":49},61.323098911388875,93.421209884951224,41.027042566701795,7.9729574332982054,10.972957433298205,17.782322222486503,91.713202281589588,22.760334529632633,52,57.766558198498373,286.71363182094279,6.5605902899050728,"0","0","0"]
[null,null,null,null,null,null,null,null,51,{"$f":"J69+$K$17","v":50},62.553153675594515,94.233205564889232,41.591266788942249,8.4087332110577506,11.408733211057751,18.639964534165799,92.371255015831153,24.73606841025282,53,61.94582659813868,296.16047345030665,6.4278760968653934,"0","0","0"]
[null,null,null,null,null,null,null,null,52,{"$f":"J70+$K$17","v":51},63.783208439800163,95.054182838774224,42.145797677462532,8.8542023225374678,11.854202322537468,19.526218213028624,93.027009397509445,26.875533723587544,54,66.439973227884494,306.24505947007844,6.2932039104983755,"0","0","0"]
[null,null,null,null,null,null,null,null,53,52,65.01326320400581,95.883911000258337,42.690781656698746,9.3092183433012536,12.309218343301254,20.441259024898034,93.679663311641377,29.19314333170739,55,71.276495090838665,317.0221083775362,6.1566147532565827,"0","0","0"]
[null,null,null,null,null,null,null,null,54,53,66.243317968211457,96.722164841931104,43.226367064460099,9.7736329355399008,12.773632935539901,21.385243386137546,94.328407900405878,31.704927146432748,56,76.486104360071778,328.55277445374907,6.018150231520484,"0","0","0"]
[null,null,null,null,null,null,null,null,55,54,67.473372732417104,97.568724620955322,43.752703738056411,10.247296261943589,13.247296261943589,22.358308183455236,94.972427995357961,34.428775421871585,57,82.103216060664295,340.90562289512337,5.8778525229247318,"0","0","0"]
[null,null,null,null,null,null,null,null,56,55,68.703427496622751,98.423376014317981,44.269942630163158,10.730057369836842,13.730057369836842,23.360570602920216,95.610902553850025,37.384727753954536,58,88.166527166069514,354.15778778167862,5.7357643635104614,"0","0","0"]
[null,null,null,null,null,null,null,null,57,56,69.933482260828384,99.285910064810935,44.778235453260812,11.221764546739188,14.221764546739188,24.392127968282825,96.243005099470167,40.595318108481329,59,94.719707751869208,368.39635416777219,5.5919290347074675,"0","0","0"]
[null,null,null,null,null,null,null,null,58,57,71.163537025034032,100.15612311878647,45.277734351436017,11.722265648563983,14.722265648563983,25.453057588685986,96.867904166305507,44.085988951580703,60,101.81223035474396,383.72001659051637,5.4463903501502724,"0","0","0"]
[null,null,null,null,null,null,null,null,59,58,72.393591789239679,101.03381675666418,45.768591598299174,12.231408401700826,15.231408401700826,26.543416615852045,97.484763746836379,47.885591163062095,61,109.5003708976115,400.24108071740847,5.2991926423320486,"0","0","0"]
[null,null,null,null,null,null,null,null,60,59,73.623646553445326,101.91879771709813,46.250959319755673,12.749040680244327,15.749040680244327,27.663241910824024,98.092743743265714,52.026991178964572,62,117.8484240735162,418.08789391797677,5.1503807491005436,"0","0","0"]
[null,null,null,null,null,null,null,null,61,60,74.853701317650973,102.81087781564862,46.724989240361431,13.275010759638569,16.275010759638569,28.812549920338125,98.691000422086375,56.547813164047191,63,126.93018878971175,437.40781596197888,5.0000000000000009,"0","0","0"]
[null,null,null,null,null,null,null,null,62,61,76.08375608185662,103.70987385873912,47.190832451999533,13.809167548000467,16.809167548000467,29.991336562898709,99.278686871687185,61.491352569008825,64,136.83079638144645,458.37087526283847,4.8480962024633714,"0","0","0"]
[null,null,null,null,null,null,null,null,63,62,77.313810846062268,104.61560755361899,47.648639203628768,14.351360796371232,17.351360796371232,31.199577124623925,99.854953462797553,66.907709060727726,65,147.64897757194723,481.17430261899779,4.6947156278589084,"0","0","0"]
[null,null,null,null,null,null,null,null,64,63,78.543865610267915,105.52790541499415,48.09855871087705,14.90144128912295,17.90144128912295,32.437226164925661,100.41894831156824,72.855202809871074,66,159.4998961472011,506.04819839007973,4.5399049973954684,"0","0","0"]
[null,null,null,null,null,null,null,null,65,64,79.773920374473548,106.44659866893339,48.540738984281226,{"$f":"J84-M84","v":15.459261015718774},{"$f":"N84+$L$13/2","v":18.459261015718774},33.704217432083894,100.96981774508551,{"$f":"P84/TAN((90-(J84+$L$13/2))*PI()/180)","v":79.402160375613022},67,{"$f":"P84/SIN((90-(J84+$L$13/2))*PI()/180)*2","v":172.51872182489365},533.26267806629073,{"$f":"COS(J84*PI()/180)*$C$9/2*2","v":4.3837114678907749},{"$f":"IF(AND(T84<$C$9,T85>$C$9),\"1\",\"0\")","v":"0"},{"$f":"IF(AND(T84>$C$9,T83<$C$9),\"1\",\"0\")","v":"0"},"0"]
[null,null,null,null,null,null,null,null,66,65,{"$f":"$C$19/360*(J85+$C$21)","v":81.003975138679195},{"$f":"SQRT(K85^2+($C$18/2)^2)","v":107.37152315460501},{"$f":"ATAN(K85/($C$18/2))*180/PI()","v":48.975326675008723},16.024673324991277,19.024673324991277,{"$f":"SIN(O85*PI()/180)*L85","v":35.000463788770517},{"$f":"COS(O85*PI()/180)*L85","v":101.50670676911376},86.629187787059024,{"$f":"J85+$L$13/2","v":68},186.86517751656751,{"$f":"(Q85+R85+T85/2)*2","v":563.13696662891311},4.2261826174069945,"0","0","0"]
[null,null,null,null,null,null,null,null,67,66,82.234029902884842,108.30251922434992,49.40246693693382,16.59753306306618,19.59753306306618,36.325857147574865,102.02875953786103,94.632093220776454,69,202.72938578165466,596.05109129892958,4.0673664307580024,"0","0","0"]
[null,null,null,null,null,null,null,null,68,67,83.464084667090489,109.2394316425501,49.822303303982835,17.177696696017165,20.177696696017165,37.680268416577633,102.53511982556044,103.52568663353622,70,220.33946919143179,632.46108210962518,3.9073112848927396,"0","0","0"]
[null,null,null,null,null,null,null,null,69,68,84.694139431296136,110.18210948370863,50.234977581705415,17.765022418294585,20.765022418294585,39.063547455016895,103.02493149965981,113.44877943946578,71,239.97155078112831,672.91897265937951,3.7460659341591196,"0","0","0"]
[null,null,null,null,null,null,null,null,70,69,85.924194195501784,111.13040603011594,50.640629752074361,18.359370247925639,21.359370247925639,40.475523039084877,103.49733899541059,124.57085091594922,72,261.96308795867509,718.09946778139465,3.583679495453004,"0","0","0"]
[null,null,null,null,null,null,null,null,71,70,87.154248959707431,112.0841786694393,51.03939789056205,18.96060210943795,21.96060210943795,41.916002837890545,103.95148779164607,137.10106763870294,73,286.73091247075712,768.83602333145518,3.4202014332566884,"0","0","0"]

{"sheet":"Evolvente berechnen (3)","index":6,"n_rows":90,"n_cols":24,"rows_kept":90,"cut":false,"hidden":false,"merged":[[13,17,13,18],[14,17,14,18],[15,17,15,18],[17,22,17,23],[9,17,9,18],[10,14,11,14],[10,15,11,15],[10,17,10,18],[11,17,11,18],[12,17,12,18],[7,9,7,10],[7,17,7,18],[8,9,8,10],[8,17,8,18],[3,17,3,19],[4,17,4,18],[5,17,5,18],[6,15,8,15],[6,17,6,18]]}
[null,null,null,null,null,null,null,null,"Dezimalwinkel in Bogenmass= WertxPi()/180"]
[null,null,null,null,null,null,null,null,"Bogenmass in Dezimalwinkel=Wertx180/Pi()"]
[null,"Zahnradmessung"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solver",null,null,null,null,"Formelspeicher"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bogenlänge Bl:",null,{"$f":"$C$19/360*(T10+$C$21)","v":35.734560801778684}]
[null,"Gegeben:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strecke a:",null,5.9390955064773383,null,null,{"$f":"SIN($T$13*PI()/180)*$T$8","v":5.9390955064773383}]
[null,"Modul:",5,null,null,null,null,null,null,null,null,null,null,null,null,"Werte für Solverlauf",null,"Strecke b:",null,78.795215441885077,null,null,{"$f":"COS($T$13*PI()/180)*$T$8","v":78.795215441885077}]
[null,"Zähnezahl",30,null,null,null,null,null,null,"Öffnungswinkel:",null,{"$f":"360/(C8*2)","v":6},null,null,null,null,null,"Strecke c:",null,79.018724565561953,null,null,{"$f":"SQRT($T$5^2+($C$18/2)^2)","v":79.018724565561953}]
[null,"Messkugeldurchmesser:",10,null,null,null,null,null,null,"Winkelkorrektur von Zahn und Zahnlücke:",null,0,null,null,null,null,null,"Strecke b2:",null,3.596452608022207,null,null,{"$f":"$T$6/TAN((90-($T$10+$L$13/2))*PI()/180)","v":3.596452608022207}]
[null,"Eingriffswinkel",20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Teilungswinkel:",null,28.197236696908405,null,null,28.197236696908405]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solverlauf durchführen","Wichtiger Hinweis!",null,"Winkel Alpha 2:",null,{"$f":"ATAN(T5/($C$18/2))*180/PI()","v":26.886786094262828}]
[null,null,null,null,null,null,null,null,null,null,"Breite am Teilkreisdurchm.","Winkel",null,null,null,null,null,"Winkel Alpha 3:",null,{"$f":"T10-T11","v":1.3104506026455773}]
[null,"Gesucht:",null,null,null,null,null,null,null,"Zahnlücke:",{"$f":"TAN((L8+L9)/2*PI()/180)*(C20/2)*2","v":7.8611668924561791},{"$f":"L8+L9","v":6},"(Alpha z)",null,null,null,null,"Winkel alpha 4:",null,{"$f":"T12+$L$13/2","v":4.3104506026455773}]
[null,"Öffnungswinkel",{"$f":"360/C20","v":2.4},null,null,null,null,null,null,"Zahn:",{"$f":"TAN((L8-L9)/2*PI()/180)*(C20/2)*2-L11","v":7.8611668924561791},{"$f":"L8-L9","v":6},null,null,null,null,null,"Zahnlückenwinkel:",null,{"$f":"L13","v":6}]
[null,"Ankathete a",{"$f":"SIN((C14/2)*PI()/180)*C20/2","v":1.5706814912517717},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kugel Ø",null,{"$f":"$T$6/SIN((90-($T$10+$T$14/2))*PI()/180)*2","v":13.886299261762876}]
[null,"Gegenkathete b",{"$f":"COS((C14/2)*PI()/180)*C20/2","v":74.98355126061341},null,null,null,null,null,null,"Startwinkel",0,null,"Winkel für Vektor",{"$f":"L9","v":0},"±Grad",null,null,"Zweikugelmaß Mdk:",null,{"$f":"(T7+T9+T15/2)*2","v":178.66963536157743}]
[null,"Berührpunktabstand Bab",{"$f":"C15*2","v":3.1413629825035434},null,null,null,null,null,null,"Inkrement",1]
[null,"Grundkreisdurchmesser dg",{"$f":"COS(C10*PI()/180)*C20","v":140.95389311788625},null,null,null,null,null,null,null,null,null,null,null,null,null,"dm/2",null,null,"DM","Mdk","Kugel-XM","Trefferindikator"]
[null,"Teilkreisumfang",{"$f":"C18*PI()","v":442.81971511403236},null,null,"Winkel","Bogenlänge",null,null,"Teilungsw. Alpha","Bogenlänge Bl","Strecke c","Winkel alpha 2","Winkel alpha 3","Winkel alpha 4","Strecke a","Strecke b","Strecke b2","Vektorwinkel","Kugel Ø","Prüfmaß",null,"Untergrenze","Obergrenze"]
[null,"Teilkreisdurchmesser:",{"$f":"C8*C7","v":150},null,1,1,{"$f":"$C$19/360*F20","v":1.2300547642056454},null,1,{"$f":"K16","v":0},{"$f":"$C$19/360*(J20+$C$21)","v":1.0504154653122446},{"$f":"SQRT(K20^2+($C$18/2)^2)","v":70.484774021925418},{"$f":"ATAN(K20/($C$18/2))*180/PI()","v":0.85389506731546183},{"$f":"J20-M20","v":-0.85389506731546183},{"$f":"N20+$L$13/2","v":2.1461049326845383},{"$f":"SIN(O20*PI()/180)*L20","v":2.6395024838213623},{"$f":"COS(O20*PI()/180)*L20","v":70.43533485090984},{"$f":"P20/TAN((90-(J20+$L$13/2))*PI()/180)","v":0.13833046358914936},{"$f":"J20+$L$13/2","v":3},{"$f":"P20/SIN((90-(J20+$L$13/2))*PI()/180)*2","v":5.2862495889830745},{"$f":"(Q20+R20+T20/2)*2","v":146.43358021798107},{"$f":"COS(J20*PI()/180)*$C$9/2*2","v":10},{"$f":"IF(AND(T20<$C$9,T21>$C$9),\"1\",\"0\")","v":"0"},{"$f":"IF(AND(T20>$C$9,T19<$C$9),\"1\",\"0\")","v":"0"}]
[null,"Korrektur inv alpha y",{"$f":"(TAN(C10*PI()/180)-(PI()/9))*180/PI()","v":0.85395829184125016},null,2,3,3.6901642926169362,null,2,{"$f":"J20+$K$17","v":1},{"$f":"$C$19/360*(J21+$C$21)","v":2.2804702295178902},{"$f":"SQRT(K21^2+($C$18/2)^2)","v":70.513832265306945},{"$f":"ATAN(K21/($C$18/2))*180/PI()","v":1.8533116546953032},-0.85331165469530323,2.146688345304697,{"$f":"SIN(O21*PI()/180)*L21","v":2.6413081535502205},{"$f":"COS(O21*PI()/180)*L21","v":70.464345820974103},0.1846982585381674,{"$f":"J21+$L$13/2","v":4},5.2955159177243187,{"$f":"(Q21+R21+T21/2)*2","v":146.59360407674885},9.9984769515639123,"0","0"]
[null,"Bogenlänge",{"$f":"C19/360*C21","v":1.0504154653122446},null,3,5,6.1502738210282271,null,3,{"$f":"J21+$K$17","v":2},3.5105249937235357,70.564323719594199,2.8516014497556528,-0.85160144975565277,2.1483985502443472,2.6453042376657554,70.514722912976637,0.23143413237284008,5,5.3108177402127339,146.8031318309117,9.993908270190957,"0","0"]
[null,"dp-Wert",{"$f":"C8/C20","v":0.2},null,4,10,12.300547642056454,null,4,3,4.7405797579291811,70.636202422790348,3.848161632997249,-0.848161632997249,2.151838367002751,2.6522365536026631,70.586391988662712,0.27876129471008115,6,5.3336916280169682,147.06399819476255,9.9862953475457381,"0","0"]
[null,null,null,null,5,20,24.601095284112908,null,5,4,5.9706345221348265,70.729403170598246,4.8423956529436989,-0.84239565294369889,2.1576043470563011,2.6628488845363205,70.679259395434798,0.32695673103858142,7,5.3656928297649547,147.3781250827117,9.9756405025982424,"0","0"]
[null,"Kugelabschnittsrechner",null,null,6,30,36.901642926169359,null,6,5,7.2006892863404719,70.843841810495746,5.8337153366508483,-0.83371533665084829,2.1662846633491517,2.677882525612433,70.793212016757408,0.37635184538452016,8,5.4083992206584588,147.74752694494231,9.961946980917455,"0","0"]
[null,"Winkel:",20,null,7,40,49.202190568225816,null,7,6,8.4307440505461173,70.979415618318143,6.8215429253394202,-0.82154292533942019,2.1784570746605798,2.6980758313509838,70.928117332453041,0.4273332305016837,9,5.4634153719486882,148.17431649785814,9.9452189536827333,"0","0"]
[null,"Kugelabschnitt l:",{"$f":"COS(C26*PI()/180)*C9/2*2","v":9.3969262078590852},null,8,50,61.502738210282274,null,8,7,9.6607988147517627,71.136003753452684,7.8053130180273769,-0.80531301802737687,2.1946869819726231,2.7241637644314243,71.083823488862734,0.48034357153759932,10,5.5323767630770364,148.6607108838777,9.9254615164132201,"0","0"]
[null,null,null,null,9,60,73.803285852338718,null,9,8,10.890853578957408,71.313467788002114,8.7844744075374717,-0.78447440753747166,2.2155255924625283,2.7568774460655026,71.260159378840783,0.53588269022101653,11,5.6169541605048412,149.20903829862843,9.9026806874157032,"0","0"]
[null,null,null,null,10,70,86.103833494395175,null,10,9,12.120908343163054,71.511652304610365,9.7584917949759209,-0.7584917949759209,2.2415082050240791,2.7969437081634241,71.456934731548969,0.59450873779181956,12,5.7188581888155916,149.82174512749717,9.8768834059513786,"0","0"]
[null,null,null,null,11,80,98.404381136451633,null,11,10,13.350963107368699,71.730385557073689,10.726847370676577,-0.72684737067657679,2.2731526293234232,2.8450846474983584,71.673940212011615,0.65683954616705609,13,5.8398441214949575,150.50140363785229,9.8480775301220795,"0","0"]
[null,null,null,null,12,90,110.70492877850809,null,12,11,14.581017871574344,71.969480187391213,11.689042251634971,-0.68904225163497124,2.3109577483650288,2.9020171820734877,71.910947530388214,0.72355414822297826,14,5.9817169209050425,151.2507202781274,9.8162718344766393,"0","0"]
[null,null,null,null,null,null,null,null,13,12,15.81107263577999,72.228733992546466,12.644597767570353,-0.64459776757035314,2.3554022324296469,2.9684526098947837,72.167709560916833,0.79539447959136578,15,6.146336559400428,152.07254464041682,9.7814760073380569,"0","0"]
[null,null,null,null,null,null,null,null,14,13,17.041127399985633,72.507930734056032,13.593056589903101,-0.59305658990310128,2.4069434100968987,3.0450961703518971,72.443960470476597,0.87316727604022348,16,6.3356236563228068,152.96987914935644,9.7437006478523518,"0","0"]
[null,null,null,null,null,null,null,null,15,14,18.271182164191281,72.806840983174013,14.533983700074172,-0.53398370007417206,2.4660162999258279,3.1326466084083071,72.73941585671426,0.95774618235783304,17,6.5515654687999794,153.94588954694419,9.7029572627599645,"0","0"]
[null,null,null,null,null,null,null,null,16,15,19.501236928396928,73.125222994597408,15.466967195718723,-0.46696719571872336,2.5330328042812766,3.231795741800815,73.05377289567511,1.0500740907127213,18,6.7962222779152919,155.00391625069096,9.6592582628906829,"0","0"]
[null,null,null,null,null,null,null,null,17,16,20.731291692602568,73.462823601573461,16.391618935199038,-0.39161893519903757,2.6083810648009624,3.3432280314472398,73.386710498874692,1.1511657287513342,19,7.071734215963204,156.14748667121526,9.6126169593831889,"0","0"]
[null,null,null,null,null,null,null,null,18,17,21.961346456808215,73.819379125457885,17.307575022868299,-0.30757502286829919,2.6924249771317008,3.4676201552597878,73.737889479743885,1.2621105202561103,20,7.380328585233876,157.38032858523388,9.5630475596303537,"0","0"]
[null,null,null,null,null,null,null,null,19,18,23.191401221013859,74.194616293004501,18.214496139147968,-0.21449613914796828,2.7855038608520317,3.6056405855603062,74.106952729375735,1.384075744060639,21,7.7243277241548158,158.70638467102756,9.5105651629515346,"0","0"]
[null,null,null,null,null,null,null,null,20,19,24.421455985219506,74.588253154971653,19.112067721035569,-0.11206772103556872,2.8879322789644313,3.7579491702920049,74.49352540149809,1.5183100201534374,22,8.1061574827526517,160.1298283260557,9.4551857559931687,"0","0"]
[null,null,null,null,null,null,null,null,21,20,25.65151074942515,75,19.999999999999996,0,3,3.925196718220787,74.897215106593038,1.6661471555533129,23,8.528356376392729,161.65508090068545,9.3969262078590852,"0","0"]
[null,null,null,null,null,null,null,null,22,21,26.881565513630797,75.429560258135865,20.878027905358209,0.12197209464179082,3.1219720946417908,4.1080245883176891,75.317612115079214,1.829010386671825,24,8.9935854947348197,163.2868304982369,9.3358042649720172,"0","0"]
[null,null,null,null,null,null,null,null,23,22,28.11162027783644,75.876631388836643,21.745910842155816,0.2540891578441844,3.2540891578441844,4.307064283512152,75.754289569469819,2.0084170595675883,{"$f":"J42+$L$13/2","v":25},9.5046392519586274,165.03005251003344,9.2718385456678742,"1","0"]
[null,null,null,null,null,null,null,null,24,23,29.341675042042088,76.340905748785303,22.603432353295915,0.39656764670408506,3.3965676467040851,4.5229370490041321,76.206803705415098,2.2059837948312238,26,10.064457074738243,166.89003207523089,9.2050485345244031,"0","1"]
[null,null,null,null,null,null,null,null,25,24,30.571729806247731,76.8220714353521,23.450399676180599,0.54960032381940138,3.5496003238194014,4.7562534753212065,76.674694081534071,2.4234321899224773,27,10.676136136385207,168.8723886792983,9.1354545764260084,"0","0"]
[null,null,null,null,null,null,null,null,26,25,31.801784570453378,77.319813102061062,24.286643204458485,0.71335679554151454,3.7133567955415145,5.0076131063047651,77.157483817937049,2.6625951187338792,28,11.34294525927737,170.98310313261922,9.0630778703664987,"0","0"]
[null,null,null,null,null,null,null,null,27,26,33.031839334659026,77.833812742938733,25.112015865621434,0.88798413437856638,3.8879841343785664,5.277604052207554,77.654679843335742,2.9254236961224596,29,12.068340123432449,173.22854720234886,8.9879404629916699,"0","0"]
[null,null,null,null,null,null,null,null,28,27,34.261894098864666,78.363750443135018,25.926392425180627,1.0736075748193734,4.0736075748193734,5.5668026080826092,78.16577315063536,3.2139949843020061,30,12.855979937208021,175.61551620708275,8.9100652418836788,"0","0"]
[null,null,null,null,null,null,null,null,29,28,35.491948863070313,78.909305093701875,26.729668727993332,1.2703312720066684,4.2703312720066684,5.8757728776414524,78.690239060898136,3.5305205285249941,31,13.709745747017093,178.15126492586333,8.8294759285892699,"0","0"]
[null,null,null,null,null,null,null,null,30,29,36.72200362727596,79.470155068892339,27.521760887025472,1.4782391129745278,4.4782391129745278,6.2050664027573008,79.227537495565059,3.8773558216452959,32,14.633760587118282,180.84354722153898,8.7461970713939579,"0","0"]
[null,null,null,null,null,null,null,null,31,30,37.952058391481607,80.045978864790925,28.302604429440812,1.6973955705591877,4.6973955705591877,6.5552217987866408,79.777113256818637,4.2570108112258893,33,15.632411698542445,183.70065983463149,8.6602540378443873,"0","0"]
[null,null,null,null,null,null,null,null,32,31,39.182113155687247,80.636455698506524,29.072153409423745,1.9278465905762552,4.9278465905762552,6.9267643958801477,80.33839631596571,4.6721615791820454,34,16.710375078736888,186.7314908690324,8.5716730070211238,"0","0"]
[null,null,null,null,null,null,null,null,33,32,40.412167919892902,81.241266067545666,29.830379496588012,2.1696205034119878,5.1696205034119878,7.3202058864514257,80.910802109716528,5.1256633429403795,35,17.872642661363859,{"$f":"(Q52+R52+T52/2)*2","v":189.94557356667769},{"$f":"COS(J52*PI()/180)*$C$9/2*2","v":8.4804809615642593},{"$f":"IF(AND(T52<$C$9,T53>$C$9),\"1\",\"0\")","v":"0"},{"$f":"IF(AND(T52>$C$9,T51<$C$9),\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,34,33,41.642222684098549,81.860092269335837,30.577271048215135,2.4227289517848654,5.4227289517848654,7.736043978969863,81.493731844232173,5.620564949241416,36,19.124552469869407,193.35314605681657,8.3867056794542414,"0","0"]
[null,null,null,null,null,null,null,null,35,34,42.872277448304189,82.492618881185351,31.312832172921404,2.6871678270785964,5.6871678270785964,8.1747620582405567,82.086572806809571,6.1601250576138264,37,20.471822140131163,196.96521786897796,8.2903757255504154,"0","0"]
[null,null,null,null,null,null,null,null,36,35,44.102332212509836,83.138533201246148,32.037081792683573,2.9629182073164273,5.9629182073164273,8.6368288523326164,82.688698685069554,6.7478302409259809,38,21.92058626814897,200.79364412014004,8.1915204428899173,"0","0"]
[null,null,null,null,null,null,null,null,37,36,45.332386976715483,83.79752565129121,32.750052709476854,3.2499472905231457,6.2499472905231457,9.1226981063135675,83.299469893510548,7.3874152661510566,39,23.477438110108935,204.85120842943212,8.0901699437494745,"0","0"]
[null,null,null,null,null,null,null,null,38,37,46.56244174092113,84.469290142328063,33.451790682103713,3.548209317896287,6.548209317896287,9.6328082629452325,83.918233907287004,8.0828858606388003,40,25.149476246377823,209.15171578222942,7.9863551004729283,"0","0"]
[null,null,null,null,null,null,null,null,39,38,47.792496505126771,85.153524404246951,34.142353518129532,3.8576464818704679,6.8576464818704679,10.167582150493573,84.544325603068387,8.8385443190810538,41,26.944356920690865,213.71009676498974,7.8801075360672197,"0","0"]
[null,null,null,null,null,null,null,null,40,39,49.022551269332418,85.849930280847943,34.821810185199389,4.1781898148006107,7.1781898148006107,10.727426677801814,85.177067606832054,9.6590183656012965,{"$f":"J59+$L$13/2","v":42},28.870352884205431,218.54252482907214,7.771459614569709,"0","0"]
[null,null,null,null,null,null,null,null,41,40,50.252606033538065,86.558213991706822,35.490239945395331,4.5097600546046692,7.5097600546046692,11.312732536773627,85.815770648439283,10.549293755981786,43,30.936419715188311,223.66654852403047,7.6604444311897799,"0","0"]
[null,null,null,null,null,null,null,null,42,41,51.482660797743712,87.278086362429278,36.147731515711556,4.8522684842884445,7.8522684842884445,11.9238739124098,86.459733922841892,11.514751189429054,44,33.152270753811408,229.1012409783533,7.5470958022277213,"0","0"]
[null,null,null,null,null,null,null,null,43,42,52.712715561949352,88.00926302490609,36.794382257179286,5.2056177428207135,8.2056177428207135,12.561208200538557,87.108245457762635,12.561208200538559,45,35.528461993987541,234.86736931058994,7.431448254773942,"0","0"]
[null,null,null,null,null,null,null,null,44,43,53.942770326154999,88.751464589224852,37.43029739466612,5.5697026053338803,8.5697026053338803,13.225075733377153,87.760582487691323,13.694966824088091,46,38.076488518057161,240.98758714161596,7.3135370161917059,"0","0"]
[null,null,null,null,null,null,null,null,45,44,55.172825090360647,89.504416788914142,38.055589268909081,5.9444107310909189,8.9444107310909189,13.91579951305849,88.416011834033867,14.92286797278064,47,40.808894355063387,247.48665396869239,7.1933980033865117,"0","0"]
[null,null,null,null,null,null,null,null,46,45,56.402879854566294,90.267850601201133,38.670376621915814,6.329623378084186,9.329623378084186,14.633684953253653,89.073790291250575,16.25235364715116,48,43.739398001488311,254.39168587829181,7.0710678118654755,"0","0"]
[null,null,null,null,null,null,null,null,47,46,57.632934618771934,91.04150234395172,39.274783916485063,6.7252160835149368,9.7252160835149368,15.379019629017799,89.733165018815939,17.691538315253851,49,46.883036280079381,261.73244294821893,6.9465837045899734,"0","0"]
[null,null,null,null,null,null,null,null,48,47,58.862989382977581,91.825113750937746,39.868940690254995,7.1310593097450052,10.131059309745005,16.15207303498325,90.393373938830393,19.249291067285355,50,50.256329747426037,269.54165975965753,6.819983600624985,"0","0"]
[null,null,null,null,null,null,null,null,49,48,60.093044147183228,92.618432027040058,40.452980944383818,7.5470190556161825,10.547019055616182,16.953096352020921,91.053646139111493,20.935330479575391,51,53.877473519456849,277.85542675683058,6.6913060635885824,"0","0"]
[null,null,null,null,null,null,null,null,50,{"$f":"J68+$K$17","v":49},61.323098911388875,93.421209884951224,41.027042566701795,7.9729574332982054,10.972957433298205,17.782322222486503,91.713202281589588,22.760334529632633,52,57.766558198498373,286.71363182094279,6.5605902899050728,"0","0"]
[null,null,null,null,null,null,null,null,51,{"$f":"J69+$K$17","v":50},62.553153675594515,94.233205564889232,41.591266788942249,8.4087332110577506,11.408733211057751,18.639964534165799,92.371255015831153,24.73606841025282,53,61.94582659813868,296.16047345030665,6.4278760968653934,"0","0"]
[null,null,null,null,null,null,null,null,52,{"$f":"J70+$K$17","v":51},63.783208439800163,95.054182838774224,42.145797677462532,8.8542023225374678,11.854202322537468,19.526218213028624,93.027009397509445,26.875533723587544,54,66.439973227884494,306.24505947007844,6.2932039104983755,"0","0"]
[null,null,null,null,null,null,null,null,53,52,65.01326320400581,95.883911000258337,42.690781656698746,9.3092183433012536,12.309218343301254,20.441259024898034,93.679663311641377,29.19314333170739,55,71.276495090838665,317.0221083775362,6.1566147532565827,"0","0"]
[null,null,null,null,null,null,null,null,54,53,66.243317968211457,96.722164841931104,43.226367064460099,9.7736329355399008,12.773632935539901,21.385243386137546,94.328407900405878,31.704927146432748,56,76.486104360071778,328.55277445374907,6.018150231520484,"0","0"]
[null,null,null,null,null,null,null,null,55,54,67.473372732417104,97.568724620955322,43.752703738056411,10.247296261943589,13.247296261943589,22.358308183455236,94.972427995357961,34.428775421871585,57,82.103216060664295,340.90562289512337,5.8778525229247318,"0","0"]
[null,null,null,null,null,null,null,null,56,55,68.703427496622751,98.423376014317981,44.269942630163158,10.730057369836842,13.730057369836842,23.360570602920216,95.610902553850025,37.384727753954536,58,88.166527166069514,354.15778778167862,5.7357643635104614,"0","0"]
[null,null,null,null,null,null,null,null,57,56,69.933482260828384,99.285910064810935,44.778235453260812,11.221764546739188,14.221764546739188,24.392127968282825,96.243005099470167,40.595318108481329,59,94.719707751869208,368.39635416777219,5.5919290347074675,"0","0"]
[null,null,null,null,null,null,null,null,58,57,71.163537025034032,100.15612311878647,45.277734351436017,11.722265648563983,14.722265648563983,25.453057588685986,96.867904166305507,44.085988951580703,60,101.81223035474396,383.72001659051637,5.4463903501502724,"0","0"]
[null,null,null,null,null,null,null,null,59,58,72.393591789239679,101.03381675666418,45.768591598299174,12.231408401700826,15.231408401700826,26.543416615852045,97.484763746836379,47.885591163062095,61,109.5003708976115,400.24108071740847,5.2991926423320486,"0","0"]
[null,null,null,null,null,null,null,null,60,59,73.623646553445326,101.91879771709813,46.250959319755673,12.749040680244327,15.749040680244327,27.663241910824024,98.092743743265714,52.026991178964572,62,117.8484240735162,418.08789391797677,5.1503807491005436,"0","0"]
[null,null,null,null,null,null,null,null,61,60,74.853701317650973,102.81087781564862,46.724989240361431,13.275010759638569,16.275010759638569,28.812549920338125,98.691000422086375,56.547813164047191,63,126.93018878971175,437.40781596197888,5.0000000000000009,"0","0"]
[null,null,null,null,null,null,null,null,62,61,76.08375608185662,103.70987385873912,47.190832451999533,13.809167548000467,16.809167548000467,29.991336562898709,99.278686871687185,61.491352569008825,64,136.83079638144645,458.37087526283847,4.8480962024633714,"0","0"]
[null,null,null,null,null,null,null,null,63,62,77.313810846062268,104.61560755361899,47.648639203628768,14.351360796371232,17.351360796371232,31.199577124623925,99.854953462797553,66.907709060727726,65,147.64897757194723,481.17430261899779,4.6947156278589084,"0","0"]
[null,null,null,null,null,null,null,null,64,63,78.543865610267915,105.52790541499415,48.09855871087705,14.90144128912295,17.90144128912295,32.437226164925661,100.41894831156824,72.855202809871074,66,159.4998961472011,506.04819839007973,4.5399049973954684,"0","0"]
[null,null,null,null,null,null,null,null,65,64,79.773920374473548,106.44659866893339,48.540738984281226,{"$f":"J84-M84","v":15.459261015718774},{"$f":"N84+$L$13/2","v":18.459261015718774},33.704217432083894,100.96981774508551,{"$f":"P84/TAN((90-(J84+$L$13/2))*PI()/180)","v":79.402160375613022},67,{"$f":"P84/SIN((90-(J84+$L$13/2))*PI()/180)*2","v":172.51872182489365},533.26267806629073,{"$f":"COS(J84*PI()/180)*$C$9/2*2","v":4.3837114678907749},{"$f":"IF(AND(T84<$C$9,T85>$C$9),\"1\",\"0\")","v":"0"},{"$f":"IF(AND(T84>$C$9,T83<$C$9),\"1\",\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,66,65,{"$f":"$C$19/360*(J85+$C$21)","v":81.003975138679195},{"$f":"SQRT(K85^2+($C$18/2)^2)","v":107.37152315460501},{"$f":"ATAN(K85/($C$18/2))*180/PI()","v":48.975326675008723},16.024673324991277,19.024673324991277,{"$f":"SIN(O85*PI()/180)*L85","v":35.000463788770517},{"$f":"COS(O85*PI()/180)*L85","v":101.50670676911376},86.629187787059024,{"$f":"J85+$L$13/2","v":68},186.86517751656751,{"$f":"(Q85+R85+T85/2)*2","v":563.13696662891311},4.2261826174069945,"0","0"]
[null,null,null,null,null,null,null,null,67,66,82.234029902884842,108.30251922434992,49.40246693693382,16.59753306306618,19.59753306306618,36.325857147574865,102.02875953786103,94.632093220776454,69,202.72938578165466,596.05109129892958,4.0673664307580024,"0","0"]
[null,null,null,null,null,null,null,null,68,67,83.464084667090489,109.2394316425501,49.822303303982835,17.177696696017165,20.177696696017165,37.680268416577633,102.53511982556044,103.52568663353622,70,220.33946919143179,632.46108210962518,3.9073112848927396,"0","0"]
[null,null,null,null,null,null,null,null,69,68,84.694139431296136,110.18210948370863,50.234977581705415,17.765022418294585,20.765022418294585,39.063547455016895,103.02493149965981,113.44877943946578,71,239.97155078112831,672.91897265937951,3.7460659341591196,"0","0"]
[null,null,null,null,null,null,null,null,70,69,85.924194195501784,111.13040603011594,50.640629752074361,18.359370247925639,21.359370247925639,40.475523039084877,103.49733899541059,124.57085091594922,72,261.96308795867509,718.09946778139465,3.583679495453004,"0","0"]
[null,null,null,null,null,null,null,null,71,70,87.154248959707431,112.0841786694393,51.03939789056205,18.96060210943795,21.96060210943795,41.916002837890545,103.95148779164607,137.10106763870294,73,286.73091247075712,768.83602333145518,3.4202014332566884,"0","0"]

{"sheet":"Übersetzungen","index":7,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[5,2,5,4],[16,6,18,6],[15,7,19,7],[14,8,20,8],[13,9,21,9],[11,6,12,6],[5,6,5,15],[10,12,24,12],[12,10,22,10],[11,11,23,11],[9,13,25,13],[8,14,26,14],[7,15,27,15],[39,8,45,8],[40,7,44,7],[41,6,43,6],[30,2,30,4],[30,6,30,15],[32,15,52,15],[33,14,51,14],[34,13,50,13],[35,12,49,12],[36,6,37,6],[36,11,48,11],[37,10,47,10],[38,9,46,9]]}
[]
[null,null,"Übersetzungen"]
[]
[]
[]
[null,null,"Übersetzungsverhältnis",null,null,null,"Gesamtübersetzungsverhältbnis i"]
[null,null,"Treibende Scheibe","Drehzahl","Durchmesser"]
[null,null,"10 (d19)",{"$f":"D27","v":18.902086677367571},100,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E28>0,O9*B28,)","v":10.157608695652176}]
[null,null,"9 (d17)",{"$f":"D26","v":165.39325842696624},80,null,null,null,null,null,null,null,null,null,{"$f":"IF(E27>0,N10*B27,)","v":12.697010869565219}]
[null,null,"8 (d15)",{"$f":"D25","v":198.4719101123595},500,null,null,null,null,null,null,null,null,{"$f":"IF(E26>0,M11*B26,)","v":1.4510869565217392}]
[null,null,"7 (d13)",{"$f":"D24","v":103.55056179775278},230,null,null,null,null,null,null,null,{"$f":"IF(E25>0,L12*B25,)","v":1.2092391304347827}]
[null,null,"6 (d11)",{"$f":"D23","v":51.775280898876389},200,null,"i=","getrieben",null,null,null,{"$f":"IF(E24>0,K13*B24,)","v":2.3177083333333335}]
[null,null,"5 (d9)",{"$f":"D22","v":86.292134831460658},300,null,null,"treibend",null,null,{"$f":"IF(E23>0,B19*B20*B21*B22*B23,)","v":4.635416666666667}]
[null,null,"4 (d7)",{"$f":"D21","v":179.77528089887639},120,null,null,null,null,{"$f":"IF(E22>0,B19*B20*B21*B22,)","v":2.78125}]
[null,null,"3 (d5)",{"$f":"D20","v":107.86516853932584},200,null,null,null,{"$f":"IF(E21>0,B19*B20*B21,)","v":1.335}]
[null,null,"2 (d3)",{"$f":"D19","v":160},60,null,null,{"$f":"IF(E20>0,B19*B20,)","v":2.2250000000000001}]
[null,null,"1 (d1)",240,240,null,{"$f":"IF(E19>0,E19/E17,)","v":1.5}]
[null,"i = direkt","Getriebene Scheibe","Drehzahl","Durchmesser"]
[null,{"$f":"IF(E19>0,E19/E17,)","v":1.5},"1 (d2)",{"$f":"$D$17/B19","v":160},360]
[null,{"$f":"IF(E20>0,E20/E16,)","v":1.4833333333333334},"2 (d4)",{"$f":"D16/B20","v":107.86516853932584},89]
[null,{"$f":"IF(E21>0,E21/E15,)","v":0.6},"3 (d6)",{"$f":"D15/B21","v":179.77528089887639},120]
[null,{"$f":"IF(E22>0,E22/E14,)","v":2.0833333333333335},"4 (d8)",{"$f":"D14/B22","v":86.292134831460658},250]
[null,{"$f":"IF(E23>0,E23/E13,)","v":1.6666666666666667},"5 (d10)",{"$f":"D13/B23","v":51.775280898876389},500]
[null,{"$f":"IF(E24>0,E24/E12,)","v":0.5},"6 (d12)",{"$f":"D12/B24","v":103.55056179775278},100]
[null,{"$f":"IF(E25>0,E25/E11,)","v":0.52173913043478259},"7 (d14)",{"$f":"D11/B25","v":198.4719101123595},120]
[null,{"$f":"IF(E26>0,E26/E10,)","v":1.2},"8 (d16)",{"$f":"D10/B26","v":165.39325842696624},600]
[null,{"$f":"IF(E27>0,E27/E9,)","v":8.75},"9 (d18)",{"$f":"D9/B27","v":18.902086677367571},700]
[null,{"$f":"IF(E28>0,E28/E8,)","v":0.8},"10 (d20)",{"$f":"D8/B28","v":23.627608346709462},80]
[]
[]
[null,null,"Übersetzungsverhältnis",null,null,null,"Gesamtübersetzungsverhältbnis i"]
[null,null,"Treibende Scheibe","Drehzahl","Durchmesser"]
[null,null,10,{"$f":"D52","v":2E-3},50,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E53>0,B44*B45*B46*B47*B48*B49*B50*B51*B52*B53,)","v":599999.99999999965}]
[null,null,9,{"$f":"D51","v":8.9999999999999993E-3},50,null,null,null,null,null,null,null,null,null,{"$f":"IF(E52>0,B44*B45*B46*B47*B48*B49*B50*B51*B52,)","v":149999.99999999991}]
[null,null,8,{"$f":"D50","v":3.6999999999999998E-2},50,null,null,null,null,null,null,null,null,{"$f":"IF(E51>0,B44*B45*B46*B47*B48*B49*B50*B51,)","v":33333.333333333321}]
[null,null,7,{"$f":"D49","v":0.14599999999999999},50,null,null,null,null,null,null,null,{"$f":"IF(E50>0,B44*B45*B46*B47*B48*B49*B50,)","v":8108.1081081081065}]
[null,null,6,{"$f":"D48","v":0.58599999999999997},50,null,"i=","getrieben",null,null,null,{"$f":"IF(E49>0,B44*B45*B46*B47*B48*B49,)","v":2054.794520547945}]
[null,null,5,{"$f":"D47","v":2.3439999999999999},50,null,null,"treibend",null,null,{"$f":"IF(E48>0,B44*B45*B46*B47*B48,)","v":511.94539249146754}]
[null,null,4,{"$f":"D46","v":9.375},50,null,null,null,null,{"$f":"IF(E47>0,B44*B45*B46*B47,)","v":127.98634812286689}]
[null,null,"3 (d5)",{"$f":"D45","v":38},50,null,null,null,{"$f":"IF(E46>0,B44*B45*B46,)","v":31.999999999999996}]
[null,null,"2 (d3)",{"$f":"D44","v":150},50,null,null,{"$f":"IF(E45>0,B44*B45,)","v":7.8947368421052637}]
[null,null,"1 (d1)",300,50,null,{"$f":"IF(E44>0,E44/E42,)","v":2}]
[null,"i = direkt","Getriebene Scheibe","Drehzahl","Durchmesser"]
[null,{"$f":"IF(E44>0,E44/E42,)","v":2},"1 (d2)",150,{"$f":"D42*E42/D44","v":100}]
[null,{"$f":"IF(E45>0,E45/E41,)","v":3.9473684210526319},"2 (d4)",38,{"$f":"D41*E41/D45","v":197.36842105263159}]
[null,{"$f":"IF(E46>0,E46/E40,)","v":4.0533333333333328},"3 (d6)",9.375,{"$f":"D40*E40/D46","v":202.66666666666666}]
[null,{"$f":"IF(E47>0,E47/E39,)","v":3.9995733788395906},4,2.3439999999999999,{"$f":"D39*E39/D47","v":199.97866894197952}]
[null,{"$f":"IF(E48>0,E48/E38,)","v":4},5,0.58599999999999997,{"$f":"D38*E38/D48","v":200}]
[null,{"$f":"IF(E49>0,E49/E37,)","v":4.0136986301369859},6,0.14599999999999999,{"$f":"D37*E37/D49","v":200.6849315068493}]
[null,{"$f":"IF(E50>0,E50/E36,)","v":3.9459459459459456},7,3.6999999999999998E-2,{"$f":"D36*E36/D50","v":197.29729729729729}]
[null,{"$f":"IF(E51>0,E51/E35,)","v":4.1111111111111107},8,8.9999999999999993E-3,{"$f":"D35*E35/D51","v":205.55555555555554}]
[null,{"$f":"IF(E52>0,E52/E34,)","v":4.4999999999999991},9,2E-3,{"$f":"D34*E34/D52","v":224.99999999999997}]
[null,{"$f":"IF(E53>0,E53/E33,)","v":4},10,5.0000000000000001E-4,{"$f":"D33*E33/D53","v":200}]