{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Formeln"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Formeln","index":0,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Datensatz","X1","X2","X3","X4","X5","X6","X7","Y","Hilfsspalte"]
[1,1,2,3,4,5,6,7,10,{"$f":"SQRT(SUMPRODUCT((B2:H2 - $B$13:$H$13)^2))","v":9.5393920141694561}]
[2,2,3,4,5,6,7,8,12,{"$f":"SQRT(SUMPRODUCT((B3:H3 - $B$13:$H$13)^2))","v":7.4833147735478827}]
[3,3,4,5,6,7,8,9,14,{"$f":"SQRT(SUMPRODUCT((B4:H4 - $B$13:$H$13)^2))","v":5.9160797830996161}]
[4,4,5,6,7,8,9,10,16,{"$f":"SQRT(SUMPRODUCT((B5:H5 - $B$13:$H$13)^2))","v":5.2915026221291814}]
[5,5,6,7,8,9,10,11,18,{"$f":"SQRT(SUMPRODUCT((B6:H6 - $B$13:$H$13)^2))","v":5.9160797830996161}]
[6,6,7,8,9,10,11,12,20,{"$f":"SQRT(SUMPRODUCT((B7:H7 - $B$13:$H$13)^2))","v":7.4833147735478827}]
[7,7,8,9,10,11,12,13,22,{"$f":"SQRT(SUMPRODUCT((B8:H8 - $B$13:$H$13)^2))","v":9.5393920141694561}]
[8,8,9,10,11,12,13,14,24,{"$f":"SQRT(SUMPRODUCT((B9:H9 - $B$13:$H$13)^2))","v":11.832159566199232}]
[9,9,10,11,12,13,14,15,26,{"$f":"SQRT(SUMPRODUCT((B10:H10 - $B$13:$H$13)^2))","v":14.247806848775006}]
[10,10,11,12,13,14,15,16,28,{"$f":"SQRT(SUMPRODUCT((B11:H11 - $B$13:$H$13)^2))","v":16.733200530681511}]
[null,null,null,null,null,null,null,null,null,"Summe"]
[11,1,{"$f":"B13+2","v":3},{"$f":"C13+2","v":5},7,9,11,13,null,{"$f":"SUM(J2:J11)","v":93.982242709418855}]
[]
[null,null,null,null,null,null,null,null,null,"Formel"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(SQRT(SUMPRODUCT((B2:H2 - B$13:H$13)^2)),SQRT(SUMPRODUCT((B3:H3 - B$13:H$13)^2)),SQRT(SUMPRODUCT((B4:H4 - B$13:H$13)^2)),SQRT(SUMPRODUCT((B5:H5 - B$13:H$13)^2)),SQRT(SUMPRODUCT((B6:H6 - B$13:H$13)^2)),SQRT(SUMPRODUCT((B7:H7 - B$13:H$13)^2)),SQRT(SUMPRODUCT((B8:H8 - B$13:H$13)^2)),SQRT(SUMPRODUCT((B9:H9 - B$13:H$13)^2)),SQRT(SUMPRODUCT((B10:H10 - B$13:H$13)^2)),SQRT(SUMPRODUCT((B11:H11 - B$13:H$13)^2)))","v":93.982242709418855},{"$f":"EuklAbst(B2:H11,B13:H13)","v":93.982242709418855}]
[]
[]
[null,null,null,null,null,null,null,null,null,"dynamische Formel gesucht mit n Zeilen!"]