{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Rest normalverteilt"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":48,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Rest normalverteilt","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Vorgabe Gesamtzahl Entnahme:",1500]
[null,null,null,null,"Vorgabe Mittelwert Länge:",6.5]
["Länge","Anzahl","Ideal wäre","Auto-Entnahme","Zwischen-ergebnis","Entnahme","Rest","Ideal wäre"]
[5.6,20,{"$f":"TRANSPOSE(RoundToSUm(_xlfn.NORM.DIST(A4:A21,B24,B25,FALSE)*B22/10,0,,2))","v":0},{"$f":"IF(B4:B21-H4:H21<0,0,B4:B21-H4:H21)","v":20},{"$f":"B4:B21-D4:D21","v":0},10,{"$f":"B4:B21-F4:F21","v":10},{"$f":"TRANSPOSE(RoundToSUm(_xlfn.NORM.DIST(A4:A21,(B24*B22-F2*F1)/(B22-F1),B25,FALSE)*(B22-F1)/10,0,,2))","v":0}]
[5.7,40,3,37,3,15,25,3]
[5.8,40,14,26,14,8,32,14]
[5.9,72,59,16,56,8,64,56]
[6,148,192,0,148,{"$f":"D8","v":0},148,179]
[6.1,372,497,0,372,{"$f":"D9","v":0},372,456]
[6.2,876,1016,0,876,{"$f":"D10","v":0},876,918]
[6.3,1660,1644,200,1460,165,1495,1460]
[6.4,2160,2102,323,1837,281,1879,1837]
[6.5,2276,2125,449,1827,416,1860,1827]
[6.6,1820,1698,384,1436,383,1437,1436]
[6.7,1036,1073,143,893,{"$f":"D15","v":143},893,893]
[6.8,464,536,25,439,28,436,439]
[6.9,212,212,41,171,43,169,171]
[7,48,66,0,48,{"$f":"D18","v":0},48,52]
[7.1,12,16,0,12,{"$f":"D19","v":0},12,13]
[7.2,0,3,0,0,{"$f":"D20","v":0},0,2]
[7.3,0,0,0,0,{"$f":"D21","v":0},0,0]
["Total",{"$f":"SUM(B4:B21)","v":11256},{"$f":"SUM(C4:C21)","v":11256},{"$f":"SUM(D4:D21)","v":1664},{"$f":"$B22-D22","v":9592},{"$f":"SUM(F4:F21)","v":1500},{"$f":"$B22-F22","v":9756},{"$f":"SUM(H4:H21)","v":9756}]
[]
["AVERAGE",{"$f":"sbSWV($A24,$A$4:$A$21,B$4:B$21)","v":6.4546552949538016},{"$f":"sbSWV($A24,$A$4:$A$21,C$4:C$21)","v":6.4545575692963775},{"$f":"sbSWV($A24,$A$4:$A$21,D$4:D$21)","v":6.4658653846153848},{"$f":"sbSWV($A24,$A$4:$A$21,E$4:E$21)","v":6.4527105921601331},{"$f":"sbSWV($A24,$A$4:$A$21,F$4:F$21)","v":6.5},{"$f":"sbSWV($A24,$A$4:$A$21,G$4:G$21)","v":6.4476834768347677},{"$f":"sbSWV($A24,$A$4:$A$21,H$4:H$21)","v":6.4475912259122596}]
["STDEV.P",{"$f":"sbSWV($A25,$A$4:$A$21,B$4:B$21)","v":0.20632673941085564},{"$f":"sbSWV($A25,$A$4:$A$21,C$4:C$21)","v":0.20613937809935551},null,{"$f":"sbSWV($A25,$A$4:$A$21,E$4:E$21)","v":0.20238608051004844},null,{"$f":"sbSWV($A25,$A$4:$A$21,G$4:G$21)","v":0.20816602053411309},{"$f":"sbSWV($A25,$A$4:$A$21,H$4:H$21)","v":0.20621080983885662}]
["SKEW.P",{"$f":"sbSWV($A26,$A$4:$A$21,B$4:B$21)","v":-0.35099994313163257},{"$f":"sbSWV($A26,$A$4:$A$21,C$4:C$21)","v":-2.6020523219408235E-3},null,{"$f":"sbSWV($A26,$A$4:$A$21,E$4:E$21)","v":-1.495410020837983E-2},null,{"$f":"sbSWV($A26,$A$4:$A$21,G$4:G$21)","v":-0.19521202015235187},{"$f":"sbSWV($A26,$A$4:$A$21,H$4:H$21)","v":-3.4454563743826689E-3}]
["KURT",{"$f":"sbSWV($A27,$A$4:$A$21,B$4:B$21)","v":0.9476935044980328},{"$f":"sbSWV($A27,$A$4:$A$21,C$4:C$21)","v":-1.8723647943704069E-2},null,{"$f":"sbSWV($A27,$A$4:$A$21,E$4:E$21)","v":3.0120730511566052E-2},null,{"$f":"sbSWV($A27,$A$4:$A$21,G$4:G$21)","v":0.52732658535988985},{"$f":"sbSWV($A27,$A$4:$A$21,H$4:H$21)","v":-1.6922068277129387E-2}]