{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["info","a1_f4","a1_f3","a2_f3","a3_f3","B_f3","B_f4","f3_a1_m","f3_a2_m","f3_a3_m","f4_a1_m","f4_a2_m","f4_a3_m"],"not_rendered":{"charts":8,"images":0,"macros":1,"external_links":0,"defined_names":200,"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":"info","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["f1 és f2 eredményeiből a szükséges rétegek átemelése manuálisan önellenőrzési céllal B*-ra","inkl. kátyasorrend"]
[]
["f3 = sebesség-becslés"]
["f4 = idealitás modell"]
["CTRL+SHIFT+G"]
["minden a* előtt bezárás, újra-indítás"]

{"sheet":"a1_f4","index":1,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["element","Y hiba 1","x hiba 1","y hiba 2","x hiba 2","Megtett út/ Időigény","Kártyasorrend"]
["COLOR_GREEN-DOT_2",27.039968261736636,1049.7615820318165,153.75833496546625,2116,0.91430801225530012,"COLOR_BROWN-DOT_1"]
["COLOR_BROWN-DOT_2",46.24004150391827,100,4,174.23951660192029,1.3848771830101081,"COLOR_BLUE-DOT_1"]
["COLOR_GREEN-DOT_1",998.56038574218519,595.36119140721223,1156,718.24098144560207,1.3925451681605041,"COLOR_GREEN-DOT_1"]
["COLOR_BROWN-DOT_1",174.23951660192029,134.55943359435659,12.960043945345252,134.56014160160899,1.4994569204353378,"COLOR_GREEN-DOT_2"]
["COLOR_BLUE-DOT_3",84.640224609519834,3180.9627539076923,213.16106933725536,4382.441616211192,1.3883205300760948,"COLOR_GREEN-DOT_3"]
["COLOR_GREEN-DOT_3",998.56038574218519,1.4401757865964089,595.35970214845531,424.3589941412398,1.328245604784611,"COLOR_BLUE-DOT_2"]
["COLOR_BLUE-DOT_1",484,1831.8389550782058,201.64034667985911,4251.041591796994,1.2702891695200942,"COLOR_BLUE-DOT_3"]
["COLOR_BLUE-DOT_2",1.4400292970234658,324,0.35997070372159212,0.15999511722443457,2.4864556570938237,"COLOR_BROWN-DOT_2"]
["COLOR_BROWN-DOT_3",12.95982421934932,4044.9568945321644,676,961,1.6522235848860449,"COLOR_BROWN-DOT_3"]
[]
["sorszámozás",{"$f":"B1","v":"Y hiba 1"},"x hiba 1","y hiba 2","x hiba 2","Sebesség","Y0"]
[{"$f":"A2","v":"COLOR_GREEN-DOT_2"},{"$f":"RANK(B2,B$2:B$10,1)","v":3},{"$f":"RANK(C2,C$2:C$10,1)","v":6},4,7,{"$f":"RANK(F2,F$2:F$10,0)","v":9},1000]
["COLOR_BROWN-DOT_2",{"$f":"RANK(B3,B$2:B$10,1)","v":4},2,2,3,{"$f":"RANK(F3,F$2:F$10,0)","v":6},1000]
["COLOR_GREEN-DOT_1",8,5,9,5,4,1000]
["COLOR_BROWN-DOT_1",6,3,3,2,3,1000]
["COLOR_BLUE-DOT_3",5,8,6,9,5,1000]
["COLOR_GREEN-DOT_3",8,1,7,4,7,1000]
["COLOR_BLUE-DOT_1",7,7,5,8,8,1000]
["COLOR_BLUE-DOT_2",1,4,1,1,1,1000]
["COLOR_BROWN-DOT_3",2,9,8,6,2,1000]
[]
["lépcsők",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
["visszatérés",2,3,4,5,6]
[]
["lépcsőtávolságok",{"$f":"B23","v":"Y hiba 1"},{"$f":"C23","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség"]
["L1-L2",{"$f":"B24-B25","v":0},{"$f":"C24-C25","v":0},0,0,{"$f":"F24-F25","v":0}]
["…",{"$f":"B25-B26","v":0},0,0,0,0]
["…",0,0,0,0,0]
["…",0,0,0,0,0]
["…",0,0,0,0,0]
["…",0,0,0,0,0]
["…",0,0,0,0,0]
["L8-L9",0,0,0,0,0,null,null,"négyzetes hiba"]
[null,null,null,null,null,null,null,null,{"$f":"SUMSQ(I46:I54)","v":9000000}]
["becslés",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség","Y0","Becslés","hiba",{"$f":"G1","v":"Kártyasorrend"},"Sebesség-becslés"]
[{"$f":"A13","v":"COLOR_GREEN-DOT_2"},{"$f":"VLOOKUP(B13,$A$24:$F$32,B$33,0)","v":0},{"$f":"VLOOKUP(C13,$A$24:$F$32,C$33,0)","v":0},0,0,0,{"$f":"G13","v":1000},{"$f":"SUM(B46:F46)","v":0},{"$f":"G46-H46","v":1000},{"$f":"G2","v":"COLOR_BROWN-DOT_1"},{"$f":"VLOOKUP(J46,$A$46:$I$54,8,0)","v":0}]
[{"$f":"A14","v":"COLOR_BROWN-DOT_2"},{"$f":"VLOOKUP(B14,$A$24:$F$32,B$33,0)","v":0},0,0,0,0,{"$f":"G14","v":1000},{"$f":"SUM(B47:F47)","v":0},{"$f":"G47-H47","v":1000},"COLOR_BLUE-DOT_1",{"$f":"VLOOKUP(J47,$A$46:$I$54,8,0)","v":0}]
["COLOR_GREEN-DOT_1",{"$f":"VLOOKUP(B15,$A$24:$F$32,B$33,0)","v":0},0,0,0,0,{"$f":"G15","v":1000},0,1000,"COLOR_GREEN-DOT_1",0]
["COLOR_BROWN-DOT_1",{"$f":"VLOOKUP(B16,$A$24:$F$32,B$33,0)","v":0},0,0,0,0,{"$f":"G16","v":1000},0,1000,"COLOR_GREEN-DOT_2",0]
["COLOR_BLUE-DOT_3",{"$f":"VLOOKUP(B17,$A$24:$F$32,B$33,0)","v":0},0,0,0,0,{"$f":"G17","v":1000},0,1000,"COLOR_GREEN-DOT_3",0]
["COLOR_GREEN-DOT_3",{"$f":"VLOOKUP(B18,$A$24:$F$32,B$33,0)","v":0},0,0,0,0,{"$f":"G18","v":1000},0,1000,"COLOR_BLUE-DOT_2",0]
["COLOR_BLUE-DOT_1",{"$f":"VLOOKUP(B19,$A$24:$F$32,B$33,0)","v":0},0,0,0,0,{"$f":"G19","v":1000},0,1000,"COLOR_BLUE-DOT_3",0]
["COLOR_BLUE-DOT_2",{"$f":"VLOOKUP(B20,$A$24:$F$32,B$33,0)","v":0},0,0,0,0,{"$f":"G20","v":1000},0,1000,"COLOR_BROWN-DOT_2",0]
["COLOR_BROWN-DOT_3",{"$f":"VLOOKUP(B21,$A$24:$F$32,B$33,0)","v":0},0,0,0,0,{"$f":"G21","v":1000},0,1000,"COLOR_BROWN-DOT_3",0]

{"sheet":"a1_f3","index":2,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["element","Y hiba 1","x hiba 1","y hiba 2","x hiba 2","Megtett út/ Időigény","Kártyasorrend"]
["COLOR_GREEN-DOT_2",27.039968261736636,1049.7615820318165,153.75833496546625,2116,0.91430801225530012,"COLOR_BROWN-DOT_1"]
["COLOR_BROWN-DOT_2",46.24004150391827,100,4,174.23951660192029,1.3848771830101081,"COLOR_BLUE-DOT_1"]
["COLOR_GREEN-DOT_1",998.56038574218519,595.36119140721223,1156,718.24098144560207,1.3925451681605041,"COLOR_GREEN-DOT_1"]
["COLOR_BROWN-DOT_1",174.23951660192029,134.55943359435659,12.960043945345252,134.56014160160899,1.4994569204353378,"COLOR_GREEN-DOT_2"]
["COLOR_BLUE-DOT_3",84.640224609519834,3180.9627539076923,213.16106933725536,4382.441616211192,1.3883205300760948,"COLOR_GREEN-DOT_3"]
["COLOR_GREEN-DOT_3",998.56038574218519,1.4401757865964089,595.35970214845531,424.3589941412398,1.328245604784611,"COLOR_BLUE-DOT_2"]
["COLOR_BLUE-DOT_1",484,1831.8389550782058,201.64034667985911,4251.041591796994,1.2702891695200942,"COLOR_BLUE-DOT_3"]
["COLOR_BLUE-DOT_2",1.4400292970234658,324,0.35997070372159212,0.15999511722443457,2.4864556570938237,"COLOR_BROWN-DOT_2"]
["COLOR_BROWN-DOT_3",12.95982421934932,4044.9568945321644,676,961,1.6522235848860449,"COLOR_BROWN-DOT_3"]
[]
["sorszámozás",{"$f":"B1","v":"Y hiba 1"},"x hiba 1","y hiba 2","x hiba 2","Sebesség"]
[{"$f":"A2","v":"COLOR_GREEN-DOT_2"},{"$f":"RANK(B2,B$2:B$10,1)","v":3},{"$f":"RANK(C2,C$2:C$10,1)","v":6},4,7,{"$f":"INT(F2*1000)","v":914}]
[{"$f":"A3","v":"COLOR_BROWN-DOT_2"},{"$f":"RANK(B3,B$2:B$10,1)","v":4},2,2,3,{"$f":"INT(F3*1000)","v":1384}]
[{"$f":"A4","v":"COLOR_GREEN-DOT_1"},{"$f":"RANK(B4,B$2:B$10,1)","v":8},5,9,5,1392]
[{"$f":"A5","v":"COLOR_BROWN-DOT_1"},{"$f":"RANK(B5,B$2:B$10,1)","v":6},3,3,2,1499]
[{"$f":"A6","v":"COLOR_BLUE-DOT_3"},{"$f":"RANK(B6,B$2:B$10,1)","v":5},8,6,9,1388]
[{"$f":"A7","v":"COLOR_GREEN-DOT_3"},{"$f":"RANK(B7,B$2:B$10,1)","v":8},1,7,4,1328]
[{"$f":"A8","v":"COLOR_BLUE-DOT_1"},{"$f":"RANK(B8,B$2:B$10,1)","v":7},7,5,8,1270]
[{"$f":"A9","v":"COLOR_BLUE-DOT_2"},{"$f":"RANK(B9,B$2:B$10,1)","v":1},4,1,1,2486]
[{"$f":"A10","v":"COLOR_BROWN-DOT_3"},{"$f":"RANK(B10,B$2:B$10,1)","v":2},9,8,6,1652]
[]
["lépcsők",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
["visszatérés",2,3,4,5]
[]
["lépcsőtávolságok",{"$f":"B23","v":"Y hiba 1"},{"$f":"C23","v":"x hiba 1"},"y hiba 2","x hiba 2"]
["L1-L2",{"$f":"B24-B25","v":0},{"$f":"C24-C25","v":0},0,0]
["…",{"$f":"B25-B26","v":0},0,0,0]
["…",{"$f":"B26-B27","v":0},0,0,0]
["…",{"$f":"B27-B28","v":0},0,0,0]
["…",{"$f":"B28-B29","v":0},0,0,0]
["…",{"$f":"B29-B30","v":0},0,0,0]
["…",{"$f":"B30-B31","v":0},0,0,0]
["L8-L9",{"$f":"B31-B32","v":0},0,0,0,null,null,"négyzetes hiba"]
[null,null,null,null,null,null,null,{"$f":"SUMSQ(H46:H54)","v":21147845}]
["becslés",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség","Becslés","hiba",{"$f":"G1","v":"Kártyasorrend"},"Sebesség-becslés"]
[{"$f":"A13","v":"COLOR_GREEN-DOT_2"},{"$f":"VLOOKUP(B13,$A$24:$E$32,B$33,0)","v":0},{"$f":"VLOOKUP(C13,$A$24:$E$32,C$33,0)","v":0},0,0,{"$f":"F13","v":914},{"$f":"SUM(B46:E46)","v":0},{"$f":"F46-G46","v":914},{"$f":"G2","v":"COLOR_BROWN-DOT_1"},{"$f":"VLOOKUP(I46,$A$46:$H$54,8,0)","v":1499}]
[{"$f":"A14","v":"COLOR_BROWN-DOT_2"},{"$f":"VLOOKUP(B14,$A$24:$E$32,B$33,0)","v":0},0,0,0,{"$f":"F14","v":1384},{"$f":"SUM(B47:E47)","v":0},{"$f":"F47-G47","v":1384},"COLOR_BLUE-DOT_1",{"$f":"VLOOKUP(I47,$A$46:$H$54,8,0)","v":1270}]
["COLOR_GREEN-DOT_1",{"$f":"VLOOKUP(B15,$A$24:$E$32,B$33,0)","v":0},0,0,0,{"$f":"F15","v":1392},0,1392,"COLOR_GREEN-DOT_1",1392]
["COLOR_BROWN-DOT_1",{"$f":"VLOOKUP(B16,$A$24:$E$32,B$33,0)","v":0},0,0,0,{"$f":"F16","v":1499},0,1499,"COLOR_GREEN-DOT_2",914]
["COLOR_BLUE-DOT_3",{"$f":"VLOOKUP(B17,$A$24:$E$32,B$33,0)","v":0},0,0,0,{"$f":"F17","v":1388},0,1388,"COLOR_GREEN-DOT_3",1328]
["COLOR_GREEN-DOT_3",{"$f":"VLOOKUP(B18,$A$24:$E$32,B$33,0)","v":0},0,0,0,{"$f":"F18","v":1328},0,1328,"COLOR_BLUE-DOT_2",2486]
["COLOR_BLUE-DOT_1",{"$f":"VLOOKUP(B19,$A$24:$E$32,B$33,0)","v":0},0,0,0,{"$f":"F19","v":1270},0,1270,"COLOR_BLUE-DOT_3",1388]
["COLOR_BLUE-DOT_2",{"$f":"VLOOKUP(B20,$A$24:$E$32,B$33,0)","v":0},0,0,0,{"$f":"F20","v":2486},0,2486,"COLOR_BROWN-DOT_2",1384]
["COLOR_BROWN-DOT_3",{"$f":"VLOOKUP(B21,$A$24:$E$32,B$33,0)","v":0},0,0,0,{"$f":"F21","v":1652},0,1652,"COLOR_BROWN-DOT_3",1652]

{"sheet":"a2_f3","index":3,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["element","Y hiba 1","x hiba 1","y hiba 2","x hiba 2","Megtett út/ Időigény","Kártyasorrend"]
["SVK-€01",27.039968261725996,268.9587988294922,1521,324,0.79039712278030227,"IRL-€02"]
["IRL-€01",2043.0397241210851,416.16099609465221,81,1900.9631933606468,0.82596709272352553,"IRL-€20"]
["SVK-€02",1267.3604345703052,196,3249,1324.9595556640709,0.31536661413431644,"IRL-€01"]
["IRL-€02",84.640224609519834,3271.841396484615,4761,268.95979980474527,0.2850403901477338,"SVK-€02"]
["SMR-€20",519.8408349612339,3457.4313867249966,289,10444.842495117498,0.52791713026659548,"SVK-€20"]
["SVK-€20",4,196,190.44050537140549,2724.8412744141879,0.58582266670796035,"SMR-€01"]
["SMR-€02",686.44063964862823,46.23983398451319,1780.8410302736536,2116,1.1746788417610308,"SVK-€01"]
["SMR-€01",3113.638637695487,484,25536.036098633034,1764,0.21906352541059149,"SMR-€02"]
["IRL-€20",9,1.4398828148961906,2894.4419702150872,2401,0.64578636572378112,"SMR-€20"]

{"sheet":"a3_f3","index":4,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["element","Y hiba 1","x hiba 1","y hiba 2","x hiba 2","Megtett út/ Időigény","Kártyasorrend"]
["COLOR_GREEN-DOT_2",484,112.35948242248068,1169.6387475589872,57.7600927734808,0.59043440605373454,"COLOR_GREEN-DOT_2"]
["COLOR_BROWN-DOT_2",100,43.559677735004058,104.03962646519642,219.04054199249754,0.82481979937858851,"COLOR_BROWN-DOT_1"]
["COLOR_GREEN-DOT_1",718.2417993174829,43.559677735004058,1489.9651831099104,27.039809570656644,0.95751856062843099,"COLOR_BLUE-DOT_1"]
["COLOR_BROWN-DOT_1",4,841,4.8399194339327778,295.83937011755211,0.52613794799080393,"COLOR_BROWN-DOT_2"]
["COLOR_BLUE-DOT_3",174.24032226576801,3433.9571386727644,81,3364,0.38146719980954785,"COLOR_GREEN-DOT_1"]
["COLOR_GREEN-DOT_3",1.4400292970234658,1089,73.960104980512853,519.83944335953436,0.71860913782843139,"COLOR_BLUE-DOT_3"]
["COLOR_BLUE-DOT_1",324,262.44039550798732,376.36094726620342,295.83937011755211,0.67930509520325,"COLOR_BLUE-DOT_2"]
["COLOR_BLUE-DOT_2",196,408.03802734633626,772.83932128922413,196,1.2526268154576878,"COLOR_GREEN-DOT_3"]
["COLOR_BROWN-DOT_3",7.8399316407695547,179.56065429740403,4.8399194339327778,900,0.87511022233463143,"COLOR_BROWN-DOT_3"]

{"sheet":"B_f3","index":5,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["element","Y hiba 1","x hiba 1","y hiba 2","x hiba 2","Megtett út/ Időigény","Kártyasorrend"]
["SVK-€01",27.039968261725996,268.9587988294922,1521,324,0.79039712278030227,"IRL-€02"]
["IRL-€01",2043.0397241210851,416.16099609465221,81,1900.9631933606468,0.82596709272352553,"IRL-€20"]
["SVK-€02",1267.3604345703052,196,3249,1324.9595556640709,0.31536661413431644,"IRL-€01"]
["IRL-€02",84.640224609519834,3271.841396484615,4761,268.95979980474527,0.2850403901477338,"SVK-€02"]
["SMR-€20",519.8408349612339,3457.4313867249966,289,10444.842495117498,0.52791713026659548,"SVK-€20"]
["SVK-€20",4,196,190.44050537140549,2724.8412744141879,0.58582266670796035,"SMR-€01"]
["SMR-€02",686.44063964862823,46.23983398451319,1780.8410302736536,2116,1.1746788417610308,"SVK-€01"]
["SMR-€01",3113.638637695487,484,25536.036098633034,1764,0.21906352541059149,"SMR-€02"]
["IRL-€20",9,1.4398828148961906,2894.4419702150872,2401,0.64578636572378112,"SMR-€20"]
[]
["sorszámozás",{"$f":"B1","v":"Y hiba 1"},"x hiba 1","y hiba 2","x hiba 2","Sebesség"]
[{"$f":"A2","v":"SVK-€01"},{"$f":"RANK(B2,B$2:B$10,1)","v":3},{"$f":"RANK(C2,C$2:C$10,1)","v":5},4,2,{"$f":"INT(F2*1000)","v":790}]
["IRL-€01",{"$f":"RANK(B3,B$2:B$10,1)","v":8},6,1,5,{"$f":"INT(F3*1000)","v":825}]
["SVK-€02",7,3,7,3,315]
["IRL-€02",4,8,8,1,285]
["SMR-€20",5,9,3,9,527]
["SVK-€20",1,3,2,8,585]
["SMR-€02",6,2,5,6,1174]
["SMR-€01",9,7,9,4,219]
["IRL-€20",2,1,6,7,645]
[]
["lépcsők",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2"]
[1,59.44215823609423,427.99996187213873,509.9999693420267,225.55783499374513]
[2,59.44215823609423,427.99996187213895,488.55783154950547,225.5578349937451]
[3,59.442158236094215,37.000002063489042,467.99999546464687,219.0000060332853]
[4,59.442158236094201,37.000002063489042,467.99999546464687,219.00000603328542]
[5,59.000006576159478,37.000002063489049,467.99999546464625,219.00000603328542]
[6,59.000006576159485,37.000002063489056,54.166119844305797,219.00000603328556]
[7,59.000006576159493,0,0,103.39176493511638]
[8,59.000006576159514,0,0,0]
[9,0,0,0,0]
["visszatérés",2,3,4,5]
[]
["lépcsőtávolságok",{"$f":"B23","v":"Y hiba 1"},{"$f":"C23","v":"x hiba 1"},"y hiba 2","x hiba 2"]
["L1-L2",{"$f":"B24-B25","v":0},{"$f":"C24-C25","v":0},21.442137792521237,0]
["…",{"$f":"B25-B26","v":0},390.99995980864992,20.557836084858593,6.5578289604598012]
["…",0,0,0,0]
["…",0.44215165993472283,0,6.2527760746888816E-13,0]
["…",0,0,413.83387562034045,0]
["…",0,37.000002063489056,54.166119844305797,115.60824109816917]
["…",0,0,0,103.39176493511638]
["L8-L9",59.000006576159514,0,0,0,null,null,"négyzetes hiba"]
[null,null,null,null,null,null,null,{"$f":"SUMSQ(H46:H54)","v":1.6361876006257625E-9}]
["becslés",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség","Becslés","hiba",{"$f":"G1","v":"Kártyasorrend"},"Sebesség-becslés"]
[{"$f":"A13","v":"SVK-€01"},{"$f":"VLOOKUP(B13,$A$24:$E$32,B$33,0)","v":59.442158236094215},{"$f":"VLOOKUP(C13,$A$24:$E$32,C$33,0)","v":37.000002063489049},467.99999546464687,225.5578349937451,790,{"$f":"SUM(B46:E46)","v":789.9999907579753},{"$f":"F46-G46","v":9.2420247028712765E-6},{"$f":"G2","v":"IRL-€02"},{"$f":"VLOOKUP(I46,$A$46:$H$54,8,0)","v":6.7701606667469605E-6}]
[{"$f":"A14","v":"IRL-€01"},{"$f":"VLOOKUP(B14,$A$24:$E$32,B$33,0)","v":59.000006576159514},37.000002063489056,509.9999693420267,219.00000603328542,825,{"$f":"SUM(B47:E47)","v":824.99998401496077},{"$f":"F47-G47","v":1.598503922650707E-5},"IRL-€20",{"$f":"VLOOKUP(I47,$A$46:$H$54,8,0)","v":-4.8876551090870635E-6}]
["SVK-€02",59.000006576159493,37.000002063489042,0,219.0000060332853,315,315.00001467293384,-1.4672933843939973E-5,"IRL-€01",1.598503922650707E-5]
["IRL-€02",59.442158236094201,0,0,225.55783499374513,285,284.99999322983933,6.7701606667469605E-6,"SVK-€02",-1.4672933843939973E-5]
["SMR-€20",59.000006576159478,0,467.99999546464687,0,527,527.00000204080629,-2.0408062937349314E-6,"SVK-€20",8.1509112987987464E-6]
["SVK-€20",59.44215823609423,37.000002063489042,488.55783154950547,0,585,584.9999918490887,8.1509112987987464E-6,"SMR-€01",-6.033285416151557E-6]
["SMR-€02",59.000006576159485,427.99996187213895,467.99999546464625,219.00000603328556,1174,1173.9999699462301,3.0053769933147123E-5,"SVK-€01",9.2420247028712765E-6]
["SMR-€01",0,0,0,219.00000603328542,219,219.00000603328542,-6.033285416151557E-6,"SMR-€02",3.0053769933147123E-5]
["IRL-€20",59.44215823609423,427.99996187213873,54.166119844305797,103.39176493511638,645,645.00000488765511,-4.8876551090870635E-6,"SMR-€20",-2.0408062937349314E-6]

{"sheet":"B_f4","index":6,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["element","Y hiba 1","x hiba 1","y hiba 2","x hiba 2","Megtett út/ Időigény","Kártyasorrend"]
["COLOR_GREEN-DOT_2",484,112.35948242248068,1169.6387475589872,57.7600927734808,0.59043440605373454,"COLOR_GREEN-DOT_2"]
["COLOR_BROWN-DOT_2",100,43.559677735004058,104.03962646519642,219.04054199249754,0.82481979937858851,"COLOR_BROWN-DOT_1"]
["COLOR_GREEN-DOT_1",718.2417993174829,43.559677735004058,1489.9651831099104,27.039809570656644,0.95751856062843099,"COLOR_BLUE-DOT_1"]
["COLOR_BROWN-DOT_1",4,841,4.8399194339327778,295.83937011755211,0.52613794799080393,"COLOR_BROWN-DOT_2"]
["COLOR_BLUE-DOT_3",174.24032226576801,3433.9571386727644,81,3364,0.38146719980954785,"COLOR_GREEN-DOT_1"]
["COLOR_GREEN-DOT_3",1.4400292970234658,1089,73.960104980512853,519.83944335953436,0.71860913782843139,"COLOR_BLUE-DOT_3"]
["COLOR_BLUE-DOT_1",324,262.44039550798732,376.36094726620342,295.83937011755211,0.67930509520325,"COLOR_BLUE-DOT_2"]
["COLOR_BLUE-DOT_2",196,408.03802734633626,772.83932128922413,196,1.2526268154576878,"COLOR_GREEN-DOT_3"]
["COLOR_BROWN-DOT_3",7.8399316407695547,179.56065429740403,4.8399194339327778,900,0.87511022233463143,"COLOR_BROWN-DOT_3"]
[]
["sorszámozás",{"$f":"B1","v":"Y hiba 1"},"x hiba 1","y hiba 2","x hiba 2","Sebesség","Y0"]
[{"$f":"A2","v":"COLOR_GREEN-DOT_2"},{"$f":"RANK(B2,B$2:B$10,1)","v":8},{"$f":"RANK(C2,C$2:C$10,1)","v":3},8,2,{"$f":"RANK(F2,F$2:F$10,0)","v":7},1000]
["COLOR_BROWN-DOT_2",{"$f":"RANK(B3,B$2:B$10,1)","v":4},1,5,4,{"$f":"RANK(F3,F$2:F$10,0)","v":4},1000]
["COLOR_GREEN-DOT_1",9,1,9,1,2,1000]
["COLOR_BROWN-DOT_1",2,7,1,5,8,1000]
["COLOR_BLUE-DOT_3",5,9,4,9,9,1000]
["COLOR_GREEN-DOT_3",1,8,3,7,5,1000]
["COLOR_BLUE-DOT_1",7,5,6,5,6,1000]
["COLOR_BLUE-DOT_2",6,6,7,3,1,1000]
["COLOR_BROWN-DOT_3",3,4,1,8,3,1000]
[]
["lépcsők",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség"]
[1,201.12873360641987,207.17970151603322,199.44933214879188,210.56240600536324,207.17972026031808]
[2,200.12873360641987,206.17970151603322,198.44933214879188,209.56240600536324,206.17972026031808]
[3,199.12873360641987,205.17970151603322,197.44933214879188,203.56241760379419,205.17972026031808]
[4,198.12873360641981,204.17970151603322,196.44933214879197,202.56241760379419,204.17972026031808]
[5,197.12873360641981,203.17970151603322,193.449334245573,201.56241760379419,203.17972026031808]
[6,196.12873360641981,202.17970151603322,192.449334245573,200.56241760379419,202.17972026031808]
[7,195.12873360641981,201.17970151603322,190.94934007815476,199.56241760379419,201.17972026031808]
[8,194.12873360641979,200.17970151603325,189.94934007815476,198.56241760379416,200.17972026031811]
[9,187.12874412275926,199.17970151603316,188.94934007815488,197.56241760379419,199.17972026031802]
["visszatérés",2,3,4,5,6]
[]
["lépcsőtávolságok",{"$f":"B23","v":"Y hiba 1"},{"$f":"C23","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség"]
["L1-L2",{"$f":"B24-B25","v":1},{"$f":"C24-C25","v":1},1,1,1]
["…",{"$f":"B25-B26","v":1},1,1,5.9999884015690554,1]
["…",1.0000000000000568,1,0.99999999999991473,1,1]
["…",1,1,2.9999979032189685,1,1]
["…",1,1,1,1,1]
["…",1,1,1.4999941674182367,1,1]
["…",1.0000000000000284,0.99999999999997158,1,1.0000000000000284,0.99999999999997158]
["L8-L9",6.9999894836605279,1.0000000000000853,0.99999999999988631,0.99999999999997158,1.0000000000000853,null,null,"négyzetes hiba"]
[null,null,null,null,null,null,null,null,{"$f":"SUMSQ(I46:I54)","v":221.50000007822501}]
["becslés",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség","Y0","Becslés","hiba",{"$f":"G1","v":"Kártyasorrend"},"Sebesség-becslés"]
[{"$f":"A13","v":"COLOR_GREEN-DOT_2"},{"$f":"VLOOKUP(B13,$A$24:$F$32,B$33,0)","v":194.12873360641979},{"$f":"VLOOKUP(C13,$A$24:$F$32,C$33,0)","v":205.17970151603322},189.94934007815476,209.56240600536324,201.17972026031808,1000,{"$f":"SUM(B46:F46)","v":999.99990146628909},{"$f":"G46-H46","v":9.8533710911397066E-5},{"$f":"G2","v":"COLOR_GREEN-DOT_2"},{"$f":"VLOOKUP(J46,$A$46:$I$54,8,0)","v":999.99990146628909}]
[{"$f":"A14","v":"COLOR_BROWN-DOT_2"},{"$f":"VLOOKUP(B14,$A$24:$F$32,B$33,0)","v":198.12873360641981},207.17970151603322,193.449334245573,202.56241760379419,204.17972026031808,1000,{"$f":"SUM(B47:F47)","v":1005.4999072321383},{"$f":"G47-H47","v":-5.4999072321382982},"COLOR_BROWN-DOT_1",{"$f":"VLOOKUP(J47,$A$46:$I$54,8,0)","v":1002.4999051353573}]
["COLOR_GREEN-DOT_1",187.12874412275926,207.17970151603322,188.94934007815488,210.56240600536324,206.17972026031808,1000,999.99991198262876,8.8017371240312059E-5,"COLOR_BLUE-DOT_1",994.4999072321383]
["COLOR_BROWN-DOT_1",200.12873360641987,201.17970151603322,199.44933214879188,201.56241760379419,200.17972026031811,1000,1002.4999051353573,-2.4999051353572668,"COLOR_BROWN-DOT_2",1005.4999072321383]
["COLOR_BLUE-DOT_3",197.12873360641981,199.17970151603316,196.44933214879197,197.56241760379419,199.17972026031802,1000,989.49990513535715,10.500094864642847,"COLOR_GREEN-DOT_1",999.99991198262876]
["COLOR_GREEN-DOT_3",201.12873360641987,200.17970151603325,197.44933214879188,199.56241760379419,203.17972026031808,1000,1001.4999051353573,-1.4999051353572668,"COLOR_BLUE-DOT_3",989.49990513535715]
["COLOR_BLUE-DOT_1",195.12873360641981,203.17970151603322,192.449334245573,201.56241760379419,202.17972026031808,1000,994.4999072321383,5.5000927678617018,"COLOR_BLUE-DOT_2",999.99991306471998]
["COLOR_BLUE-DOT_2",196.12873360641981,202.17970151603322,190.94934007815476,203.56241760379419,207.17972026031808,1000,999.99991306471998,8.6935280023681116E-5,"COLOR_GREEN-DOT_3",1001.4999051353573]
["COLOR_BROWN-DOT_3",199.12873360641987,204.17970151603322,199.44933214879188,198.56241760379416,205.17972026031808,1000,1006.4999051353573,-6.4999051353572668,"COLOR_BROWN-DOT_3",1006.4999051353573]

{"sheet":"f3_a1_m","index":7,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["element","Y hiba 1","x hiba 1","y hiba 2","x hiba 2","Megtett út/ Időigény","Kártyasorrend"]
["COLOR_GREEN-DOT_2",27.039968261736636,1049.7615820318165,153.75833496546625,2116,0.91430801225530012,"COLOR_BROWN-DOT_1"]
["COLOR_BROWN-DOT_2",46.24004150391827,100,4,174.23951660192029,1.3848771830101081,"COLOR_BLUE-DOT_1"]
["COLOR_GREEN-DOT_1",998.56038574218519,595.36119140721223,1156,718.24098144560207,1.3925451681605041,"COLOR_GREEN-DOT_1"]
["COLOR_BROWN-DOT_1",174.23951660192029,134.55943359435659,12.960043945345252,134.56014160160899,1.4994569204353378,"COLOR_GREEN-DOT_2"]
["COLOR_BLUE-DOT_3",84.640224609519834,3180.9627539076923,213.16106933725536,4382.441616211192,1.3883205300760948,"COLOR_GREEN-DOT_3"]
["COLOR_GREEN-DOT_3",998.56038574218519,1.4401757865964089,595.35970214845531,424.3589941412398,1.328245604784611,"COLOR_BLUE-DOT_2"]
["COLOR_BLUE-DOT_1",484,1831.8389550782058,201.64034667985911,4251.041591796994,1.2702891695200942,"COLOR_BLUE-DOT_3"]
["COLOR_BLUE-DOT_2",1.4400292970234658,324,0.35997070372159212,0.15999511722443457,2.4864556570938237,"COLOR_BROWN-DOT_2"]
["COLOR_BROWN-DOT_3",12.95982421934932,4044.9568945321644,676,961,1.6522235848860449,"COLOR_BROWN-DOT_3"]
[]
["sorszámozás",{"$f":"B1","v":"Y hiba 1"},"x hiba 1","y hiba 2","x hiba 2","Sebesség"]
[{"$f":"A2","v":"COLOR_GREEN-DOT_2"},{"$f":"RANK(B2,B$2:B$10,1)","v":3},{"$f":"RANK(C2,C$2:C$10,1)","v":6},4,7,{"$f":"INT(F2*1000)","v":914}]
["COLOR_BROWN-DOT_2",{"$f":"RANK(B3,B$2:B$10,1)","v":4},2,2,3,{"$f":"INT(F3*1000)","v":1384}]
["COLOR_GREEN-DOT_1",8,5,9,5,1392]
["COLOR_BROWN-DOT_1",6,3,3,2,1499]
["COLOR_BLUE-DOT_3",5,8,6,9,1388]
["COLOR_GREEN-DOT_3",8,1,7,4,1328]
["COLOR_BLUE-DOT_1",7,7,5,8,1270]
["COLOR_BLUE-DOT_2",1,4,1,1,2486]
["COLOR_BROWN-DOT_3",2,9,8,6,1652]
[]
["lépcsők",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2"]
[1,665.61106633867394,489.16632336716731,665.61100218432591,665.61100218432591]
[2,485.01411151464583,489.16632336716731,334.94392967609855,470.96953660463322]
[3,203.91993134054951,489.16632336716731,334.94392967609866,355.96950108256522]
[4,203.91993134054951,489.16632336716771,321.84970076824033,355.96950108256522]
[5,203.91993134054951,489.16632336716771,321.84970076824033,355.96950108256522]
[6,203.91993134054945,489.16632336716771,321.84970076824033,355.96950108256527]
[7,203.91993134054931,489.16632336716771,321.84970076824033,175.73040080224604]
[8,193.01415666042928,489.16632336716771,321.84970076824038,175.73040080224604]
[9,193.01415666042934,489.16632336716759,321.84970076824033,175.73040080224604]
["visszatérés",2,3,4,5]
[]
["lépcsőtávolságok",{"$f":"B23","v":"Y hiba 1"},{"$f":"C23","v":"x hiba 1"},"y hiba 2","x hiba 2"]
["L1-L2",{"$f":"B24-B25","v":180.5969548240281},{"$f":"C24-C25","v":0},330.66707250822736,194.64146557969269]
["…",{"$f":"B25-B26","v":281.09418017409632},0,0,115.000035522068]
["…",0,0,13.094228907858337,0]
["…",0,0,0,0]
["…",0,0,0,0]
["…",0,0,0,180.23910028031924]
["…",10.905774680120032,0,0,0]
["L8-L9",0,0,0,0,null,null,"négyzetes hiba"]
[null,null,null,null,null,null,null,{"$f":"SUMSQ(H46:H54)","v":123826.666667834}]
["becslés",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség","Becslés","hiba",{"$f":"G1","v":"Kártyasorrend"},"Sebesség-becslés"]
[{"$f":"A13","v":"COLOR_GREEN-DOT_2"},{"$f":"VLOOKUP(B13,$A$24:$E$32,B$33,0)","v":203.91993134054951},{"$f":"VLOOKUP(C13,$A$24:$E$32,C$33,0)","v":489.16632336716771},321.84970076824033,175.73040080224604,914,{"$f":"SUM(B46:E46)","v":1190.6663562782037},{"$f":"F46-G46","v":-276.66635627820369},{"$f":"G2","v":"COLOR_BROWN-DOT_1"},{"$f":"VLOOKUP(I46,$A$46:$H$54,8,0)","v":2.7901155135623412E-4}]
[{"$f":"A14","v":"COLOR_BROWN-DOT_2"},{"$f":"VLOOKUP(B14,$A$24:$E$32,B$33,0)","v":203.91993134054951},489.16632336716731,334.94392967609855,355.96950108256522,1384,{"$f":"SUM(B47:E47)","v":1383.9996854663805},{"$f":"F47-G47","v":3.1453361953026615E-4},"COLOR_BLUE-DOT_1",{"$f":"VLOOKUP(I47,$A$46:$H$54,8,0)","v":79.333643721796534}]
["COLOR_GREEN-DOT_1",193.01415666042928,489.16632336716771,321.84970076824033,355.96950108256522,1392,1359.9996818784025,32.000318121597502,"COLOR_GREEN-DOT_1",32.000318121597502]
["COLOR_BROWN-DOT_1",203.91993134054945,489.16632336716731,334.94392967609866,470.96953660463322,1499,1498.9997209884486,2.7901155135623412E-4,"COLOR_GREEN-DOT_2",-276.66635627820369]
["COLOR_BLUE-DOT_3",203.91993134054951,489.16632336716771,321.84970076824033,175.73040080224604,1388,1190.6663562782037,197.33364372179631,"COLOR_GREEN-DOT_3",-31.999681878402043]
["COLOR_GREEN-DOT_3",193.01415666042928,489.16632336716731,321.84970076824033,355.96950108256522,1328,1359.999681878402,-31.999681878402043,"COLOR_BLUE-DOT_2",6.0592550653382204E-4]
["COLOR_BLUE-DOT_1",203.91993134054931,489.16632336716771,321.84970076824033,175.73040080224604,1270,1190.6663562782035,79.333643721796534,"COLOR_BLUE-DOT_3",197.33364372179631]
["COLOR_BLUE-DOT_2",665.61106633867394,489.16632336716771,665.61100218432591,665.61100218432591,2486,2485.9993940744935,6.0592550653382204E-4,"COLOR_BROWN-DOT_2",3.1453361953026615E-4]
["COLOR_BROWN-DOT_3",485.01411151464583,489.16632336716759,321.84970076824038,355.96950108256527,1652,1651.9996367326191,3.6326738086245314E-4,"COLOR_BROWN-DOT_3",3.6326738086245314E-4]

{"sheet":"f3_a2_m","index":8,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["element","Y hiba 1","x hiba 1","y hiba 2","x hiba 2","Megtett út/ Időigény","Kártyasorrend"]
["SVK-€01",27.039968261725996,268.9587988294922,1521,324,0.79039712278030227,"IRL-€02"]
["IRL-€01",2043.0397241210851,416.16099609465221,81,1900.9631933606468,0.82596709272352553,"IRL-€20"]
["SVK-€02",1267.3604345703052,196,3249,1324.9595556640709,0.31536661413431644,"IRL-€01"]
["IRL-€02",84.640224609519834,3271.841396484615,4761,268.95979980474527,0.2850403901477338,"SVK-€02"]
["SMR-€20",519.8408349612339,3457.4313867249966,289,10444.842495117498,0.52791713026659548,"SVK-€20"]
["SVK-€20",4,196,190.44050537140549,2724.8412744141879,0.58582266670796035,"SMR-€01"]
["SMR-€02",686.44063964862823,46.23983398451319,1780.8410302736536,2116,1.1746788417610308,"SVK-€01"]
["SMR-€01",3113.638637695487,484,25536.036098633034,1764,0.21906352541059149,"SMR-€02"]
["IRL-€20",9,1.4398828148961906,2894.4419702150872,2401,0.64578636572378112,"SMR-€20"]
[]
["sorszámozás",{"$f":"B1","v":"Y hiba 1"},"x hiba 1","y hiba 2","x hiba 2","Sebesség"]
[{"$f":"A2","v":"SVK-€01"},{"$f":"RANK(B2,B$2:B$10,1)","v":3},{"$f":"RANK(C2,C$2:C$10,1)","v":5},4,2,{"$f":"INT(F2*1000)","v":790}]
["IRL-€01",{"$f":"RANK(B3,B$2:B$10,1)","v":8},6,1,5,{"$f":"INT(F3*1000)","v":825}]
["SVK-€02",7,3,7,3,315]
["IRL-€02",4,8,8,1,285]
["SMR-€20",5,9,3,9,527]
["SVK-€20",1,3,2,8,585]
["SMR-€02",6,2,5,6,1174]
["SMR-€01",9,7,9,4,219]
["IRL-€20",2,1,6,7,645]
[]
["lépcsők",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2"]
[1,59.44215823609423,427.99996187213873,509.9999693420267,225.55783499374513]
[2,59.44215823609423,427.99996187213895,488.55783154950547,225.5578349937451]
[3,59.442158236094215,37.000002063489042,467.99999546464687,219.0000060332853]
[4,59.442158236094201,37.000002063489042,467.99999546464687,219.00000603328542]
[5,59.000006576159478,37.000002063489049,467.99999546464625,219.00000603328542]
[6,59.000006576159485,37.000002063489056,54.166119844305797,219.00000603328556]
[7,59.000006576159493,0,0,103.39176493511638]
[8,59.000006576159514,0,0,0]
[9,0,0,0,0]
["visszatérés",2,3,4,5]
[]
["lépcsőtávolságok",{"$f":"B23","v":"Y hiba 1"},{"$f":"C23","v":"x hiba 1"},"y hiba 2","x hiba 2"]
["L1-L2",{"$f":"B24-B25","v":0},{"$f":"C24-C25","v":0},21.442137792521237,0]
["…",{"$f":"B25-B26","v":0},390.99995980864992,20.557836084858593,6.5578289604598012]
["…",0,0,0,0]
["…",0.44215165993472283,0,6.2527760746888816E-13,0]
["…",0,0,413.83387562034045,0]
["…",0,37.000002063489056,54.166119844305797,115.60824109816917]
["…",0,0,0,103.39176493511638]
["L8-L9",59.000006576159514,0,0,0,null,null,"négyzetes hiba"]
[null,null,null,null,null,null,null,{"$f":"SUMSQ(H46:H54)","v":1.6361876006257625E-9}]
["becslés",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség","Becslés","hiba",{"$f":"G1","v":"Kártyasorrend"},"Sebesség-becslés"]
[{"$f":"A13","v":"SVK-€01"},{"$f":"VLOOKUP(B13,$A$24:$E$32,B$33,0)","v":59.442158236094215},{"$f":"VLOOKUP(C13,$A$24:$E$32,C$33,0)","v":37.000002063489049},467.99999546464687,225.5578349937451,790,{"$f":"SUM(B46:E46)","v":789.9999907579753},{"$f":"F46-G46","v":9.2420247028712765E-6},{"$f":"G2","v":"IRL-€02"},{"$f":"VLOOKUP(I46,$A$46:$H$54,8,0)","v":6.7701606667469605E-6}]
[{"$f":"A14","v":"IRL-€01"},{"$f":"VLOOKUP(B14,$A$24:$E$32,B$33,0)","v":59.000006576159514},37.000002063489056,509.9999693420267,219.00000603328542,825,{"$f":"SUM(B47:E47)","v":824.99998401496077},{"$f":"F47-G47","v":1.598503922650707E-5},"IRL-€20",{"$f":"VLOOKUP(I47,$A$46:$H$54,8,0)","v":-4.8876551090870635E-6}]
["SVK-€02",59.000006576159493,37.000002063489042,0,219.0000060332853,315,315.00001467293384,-1.4672933843939973E-5,"IRL-€01",1.598503922650707E-5]
["IRL-€02",59.442158236094201,0,0,225.55783499374513,285,284.99999322983933,6.7701606667469605E-6,"SVK-€02",-1.4672933843939973E-5]
["SMR-€20",59.000006576159478,0,467.99999546464687,0,527,527.00000204080629,-2.0408062937349314E-6,"SVK-€20",8.1509112987987464E-6]
["SVK-€20",59.44215823609423,37.000002063489042,488.55783154950547,0,585,584.9999918490887,8.1509112987987464E-6,"SMR-€01",-6.033285416151557E-6]
["SMR-€02",59.000006576159485,427.99996187213895,467.99999546464625,219.00000603328556,1174,1173.9999699462301,3.0053769933147123E-5,"SVK-€01",9.2420247028712765E-6]
["SMR-€01",0,0,0,219.00000603328542,219,219.00000603328542,-6.033285416151557E-6,"SMR-€02",3.0053769933147123E-5]
["IRL-€20",59.44215823609423,427.99996187213873,54.166119844305797,103.39176493511638,645,645.00000488765511,-4.8876551090870635E-6,"SMR-€20",-2.0408062937349314E-6]

{"sheet":"f3_a3_m","index":9,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["element","Y hiba 1","x hiba 1","y hiba 2","x hiba 2","Megtett út/ Időigény","Kártyasorrend"]
["COLOR_GREEN-DOT_2",484,112.35948242248068,1169.6387475589872,57.7600927734808,0.59043440605373454,"COLOR_GREEN-DOT_2"]
["COLOR_BROWN-DOT_2",100,43.559677735004058,104.03962646519642,219.04054199249754,0.82481979937858851,"COLOR_BROWN-DOT_1"]
["COLOR_GREEN-DOT_1",718.2417993174829,43.559677735004058,1489.9651831099104,27.039809570656644,0.95751856062843099,"COLOR_BLUE-DOT_1"]
["COLOR_BROWN-DOT_1",4,841,4.8399194339327778,295.83937011755211,0.52613794799080393,"COLOR_BROWN-DOT_2"]
["COLOR_BLUE-DOT_3",174.24032226576801,3433.9571386727644,81,3364,0.38146719980954785,"COLOR_GREEN-DOT_1"]
["COLOR_GREEN-DOT_3",1.4400292970234658,1089,73.960104980512853,519.83944335953436,0.71860913782843139,"COLOR_BLUE-DOT_3"]
["COLOR_BLUE-DOT_1",324,262.44039550798732,376.36094726620342,295.83937011755211,0.67930509520325,"COLOR_BLUE-DOT_2"]
["COLOR_BLUE-DOT_2",196,408.03802734633626,772.83932128922413,196,1.2526268154576878,"COLOR_GREEN-DOT_3"]
["COLOR_BROWN-DOT_3",7.8399316407695547,179.56065429740403,4.8399194339327778,900,0.87511022233463143,"COLOR_BROWN-DOT_3"]
[]
["sorszámozás",{"$f":"B1","v":"Y hiba 1"},"x hiba 1","y hiba 2","x hiba 2","Sebesség"]
[{"$f":"A2","v":"COLOR_GREEN-DOT_2"},{"$f":"RANK(B2,B$2:B$10,1)","v":8},{"$f":"RANK(C2,C$2:C$10,1)","v":3},8,2,{"$f":"INT(F2*1000)","v":590}]
["COLOR_BROWN-DOT_2",{"$f":"RANK(B3,B$2:B$10,1)","v":4},1,5,4,{"$f":"INT(F3*1000)","v":824}]
["COLOR_GREEN-DOT_1",9,1,9,1,957]
["COLOR_BROWN-DOT_1",2,7,1,5,526]
["COLOR_BLUE-DOT_3",5,9,4,9,381]
["COLOR_GREEN-DOT_3",1,8,3,7,718]
["COLOR_BLUE-DOT_1",7,5,6,5,679]
["COLOR_BLUE-DOT_2",6,6,7,3,1252]
["COLOR_BROWN-DOT_3",3,4,1,8,875]
[]
["lépcsők",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2"]
[1,490.11811178663874,348.99736794059362,228.74452025273098,608.00248028429041]
[2,296.918745961306,348.99736794059362,227.54366709368892,334.66978539716905]
[3,296.91874596130623,348.99736794059362,227.54366709368892,334.66978539716905]
[4,247.12224417126387,348.99736794059362,227.54366709368875,0.33799962945844952]
[5,247.12224417126387,348.99736794059362,227.54366709368875,0.33799962945844952]
[6,247.12224417126407,348.99736794059356,227.54366709368875,0.33799962945844952]
[7,102.12134974099705,0,227.54366709368867,0.33799962945844952]
[8,0,0,0,0.33799962945843987]
[9,0,0,0,0]
["visszatérés",2,3,4,5]
[]
["lépcsőtávolságok",{"$f":"B23","v":"Y hiba 1"},{"$f":"C23","v":"x hiba 1"},"y hiba 2","x hiba 2"]
["L1-L2",{"$f":"B24-B25","v":193.19936582533273},{"$f":"C24-C25","v":0},1.2008531590420546,273.33269488712136]
["…",{"$f":"B25-B26","v":0},0,0,0]
["…",49.796501790042356,0,0,334.33178576771058]
["…",0,0,0,0]
["…",0,0,0,0]
["…",145.00089443026701,348.99736794059356,0,0]
["…",102.12134974099705,0,227.54366709368867,9.6589403142388619E-15]
["L8-L9",0,0,0,0.33799962945843987,null,null,"négyzetes hiba"]
[null,null,null,null,null,null,null,{"$f":"SUMSQ(H46:H54)","v":26320.333339537225}]
["becslés",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség","Becslés","hiba",{"$f":"G1","v":"Kártyasorrend"},"Sebesség-becslés"]
[{"$f":"A13","v":"COLOR_GREEN-DOT_2"},{"$f":"VLOOKUP(B13,$A$24:$E$32,B$33,0)","v":0},{"$f":"VLOOKUP(C13,$A$24:$E$32,C$33,0)","v":348.99736794059362},0,334.66978539716905,590,{"$f":"SUM(B46:E46)","v":683.66715333776267},{"$f":"F46-G46","v":-93.66715333776267},{"$f":"G2","v":"COLOR_GREEN-DOT_2"},{"$f":"VLOOKUP(I46,$A$46:$H$54,8,0)","v":-93.66715333776267}]
[{"$f":"A14","v":"COLOR_BROWN-DOT_2"},{"$f":"VLOOKUP(B14,$A$24:$E$32,B$33,0)","v":247.12224417126387},348.99736794059362,227.54366709368875,0.33799962945844952,824,{"$f":"SUM(B47:E47)","v":824.00127883500465},{"$f":"F47-G47","v":-1.2788350046548658E-3},"COLOR_BROWN-DOT_1",{"$f":"VLOOKUP(I47,$A$46:$H$54,8,0)","v":-1.2658434953891629E-3}]
["COLOR_GREEN-DOT_1",0,348.99736794059362,0,608.00248028429041,957,956.99984822488409,1.5177511590991344E-4,"COLOR_BLUE-DOT_1",-3.8440473781520268E-4]
["COLOR_BROWN-DOT_1",296.918745961306,0,228.74452025273098,0.33799962945844952,526,526.00126584349539,-1.2658434953891629E-3,"COLOR_BROWN-DOT_2",-1.2788350046548658E-3]
["COLOR_BLUE-DOT_3",247.12224417126387,0,227.54366709368875,0,381,474.66591126495263,-93.665911264952626,"COLOR_GREEN-DOT_1",1.5177511590991344E-4]
["COLOR_GREEN-DOT_3",490.11811178663874,0,227.54366709368892,0.33799962945844952,718,717.9997785097861,2.2149021390305279E-4,"COLOR_BLUE-DOT_3",-93.665911264952626]
["COLOR_BLUE-DOT_1",102.12134974099705,348.99736794059362,227.54366709368875,0.33799962945844952,679,679.00038440473782,-3.8440473781520268E-4,"COLOR_BLUE-DOT_2",93.66693539728476]
["COLOR_BLUE-DOT_2",247.12224417126407,348.99736794059356,227.54366709368867,334.66978539716905,1252,1158.3330646027152,93.66693539728476,"COLOR_GREEN-DOT_3",2.2149021390305279E-4]
["COLOR_BROWN-DOT_3",296.91874596130623,348.99736794059362,228.74452025273098,0.33799962945843987,875,874.99863378408918,1.3662159108207561E-3,"COLOR_BROWN-DOT_3",1.3662159108207561E-3]

{"sheet":"f4_a1_m","index":10,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["element","Y hiba 1","x hiba 1","y hiba 2","x hiba 2","Megtett út/ Időigény","Kártyasorrend"]
["COLOR_GREEN-DOT_2",27.039968261736636,1049.7615820318165,153.75833496546625,2116,0.91430801225530012,"COLOR_BROWN-DOT_1"]
["COLOR_BROWN-DOT_2",46.24004150391827,100,4,174.23951660192029,1.3848771830101081,"COLOR_BLUE-DOT_1"]
["COLOR_GREEN-DOT_1",998.56038574218519,595.36119140721223,1156,718.24098144560207,1.3925451681605041,"COLOR_GREEN-DOT_1"]
["COLOR_BROWN-DOT_1",174.23951660192029,134.55943359435659,12.960043945345252,134.56014160160899,1.4994569204353378,"COLOR_GREEN-DOT_2"]
["COLOR_BLUE-DOT_3",84.640224609519834,3180.9627539076923,213.16106933725536,4382.441616211192,1.3883205300760948,"COLOR_GREEN-DOT_3"]
["COLOR_GREEN-DOT_3",998.56038574218519,1.4401757865964089,595.35970214845531,424.3589941412398,1.328245604784611,"COLOR_BLUE-DOT_2"]
["COLOR_BLUE-DOT_1",484,1831.8389550782058,201.64034667985911,4251.041591796994,1.2702891695200942,"COLOR_BLUE-DOT_3"]
["COLOR_BLUE-DOT_2",1.4400292970234658,324,0.35997070372159212,0.15999511722443457,2.4864556570938237,"COLOR_BROWN-DOT_2"]
["COLOR_BROWN-DOT_3",12.95982421934932,4044.9568945321644,676,961,1.6522235848860449,"COLOR_BROWN-DOT_3"]
[]
["sorszámozás",{"$f":"B1","v":"Y hiba 1"},"x hiba 1","y hiba 2","x hiba 2","Sebesség","Y0"]
[{"$f":"A2","v":"COLOR_GREEN-DOT_2"},{"$f":"RANK(B2,B$2:B$10,1)","v":3},{"$f":"RANK(C2,C$2:C$10,1)","v":6},4,7,{"$f":"RANK(F2,F$2:F$10,0)","v":9},1000]
["COLOR_BROWN-DOT_2",{"$f":"RANK(B3,B$2:B$10,1)","v":4},2,2,3,{"$f":"RANK(F3,F$2:F$10,0)","v":6},1000]
["COLOR_GREEN-DOT_1",8,5,9,5,4,1000]
["COLOR_BROWN-DOT_1",6,3,3,2,3,1000]
["COLOR_BLUE-DOT_3",5,8,6,9,5,1000]
["COLOR_GREEN-DOT_3",8,1,7,4,7,1000]
["COLOR_BLUE-DOT_1",7,7,5,8,8,1000]
["COLOR_BLUE-DOT_2",1,4,1,1,1,1000]
["COLOR_BROWN-DOT_3",2,9,8,6,2,1000]
[]
["lépcsők",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség"]
[1,406.09089495888327,155.25248896442477,153.6183912066237,153.00221701742598,154.03598303044731]
[2,405.09089495888327,151.87748282928803,152.6183912066237,152.00221701742598,153.03598303044731]
[3,404.09089495888327,150.87748282928803,151.6183912066237,151.00221701742598,152.03598303044731]
[4,403.09089495888327,149.87748282928803,150.6183912066237,150.00221701742598,151.03598303044731]
[5,402.09089495888327,148.87748282928803,149.6183912066237,149.00221701742598,150.03598303044731]
[6,401.09089495888327,147.87748282928803,148.6183912066237,148.00221701742598,149.03598303044731]
[7,400.09089495888327,146.87748282928803,147.6183912066237,147.00221701742598,148.03598303044731]
[8,399.09089495888344,145.87748282928803,146.61839120662376,146.00221701742598,147.03598303044734]
[9,0,144.87748282928803,145.61839120662373,145.00221701742601,146.0359830304474]
["visszatérés",2,3,4,5,6]
[]
["lépcsőtávolságok",{"$f":"B23","v":"Y hiba 1"},{"$f":"C23","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség"]
["L1-L2",{"$f":"B24-B25","v":1},{"$f":"C24-C25","v":3.3750061351367435},1,1,1]
["…",{"$f":"B25-B26","v":1},1,1,1,1]
["…",1,1,1,1,1]
["…",1,1,1,1,1]
["…",1,1,1,1,1]
["…",1,1,1,1,1]
["…",0.99999999999982947,1,0.99999999999994316,1,0.99999999999997158]
["L8-L9",399.09089495888344,1,1.0000000000000284,0.99999999999997158,0.99999999999994316,null,null,"négyzetes hiba"]
[null,null,null,null,null,null,null,null,{"$f":"SUMSQ(I46:I54)","v":635.87500000827572}]
["becslés",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség","Y0","Becslés","hiba",{"$f":"G1","v":"Kártyasorrend"},"Sebesség-becslés"]
[{"$f":"A13","v":"COLOR_GREEN-DOT_2"},{"$f":"VLOOKUP(B13,$A$24:$F$32,B$33,0)","v":404.09089495888327},{"$f":"VLOOKUP(C13,$A$24:$F$32,C$33,0)","v":147.87748282928803},150.6183912066237,147.00221701742598,146.0359830304474,1000,{"$f":"SUM(B46:F46)","v":995.62496904266834},{"$f":"G46-H46","v":4.3750309573316599},{"$f":"G2","v":"COLOR_BROWN-DOT_1"},{"$f":"VLOOKUP(J46,$A$46:$I$54,8,0)","v":1007.6249690426682}]
[{"$f":"A14","v":"COLOR_BROWN-DOT_2"},{"$f":"VLOOKUP(B14,$A$24:$F$32,B$33,0)","v":403.09089495888327},151.87748282928803,152.6183912066237,151.00221701742598,149.03598303044731,1000,{"$f":"SUM(B47:F47)","v":1007.6249690426682},{"$f":"G47-H47","v":-7.6249690426682264},"COLOR_BLUE-DOT_1",{"$f":"VLOOKUP(J47,$A$46:$I$54,8,0)","v":989.62496904266834}]
["COLOR_GREEN-DOT_1",399.09089495888344,148.87748282928803,145.61839120662373,149.00221701742598,151.03598303044731,1000,993.62496904266845,6.3750309573315462,"COLOR_GREEN-DOT_1",993.62496904266845]
["COLOR_BROWN-DOT_1",401.09089495888327,150.87748282928803,151.6183912066237,152.00221701742598,152.03598303044731,1000,1007.6249690426682,-7.6249690426682264,"COLOR_GREEN-DOT_2",995.62496904266834]
["COLOR_BLUE-DOT_3",402.09089495888327,145.87748282928803,148.6183912066237,145.00221701742601,150.03598303044731,1000,991.62496904266823,8.3750309573317736,"COLOR_GREEN-DOT_3",999.99997517780525]
["COLOR_GREEN-DOT_3",399.09089495888344,155.25248896442477,147.6183912066237,150.00221701742598,148.03598303044731,1000,999.99997517780525,2.4822194745866E-5,"COLOR_BLUE-DOT_2",1016.6249690426682]
["COLOR_BLUE-DOT_1",400.09089495888327,146.87748282928803,149.6183912066237,146.00221701742598,147.03598303044734,1000,989.62496904266834,10.37503095733166,"COLOR_BLUE-DOT_3",991.62496904266823]
["COLOR_BLUE-DOT_2",406.09089495888327,149.87748282928803,153.6183912066237,153.00221701742598,154.03598303044731,1000,1016.6249690426682,-16.624969042668226,"COLOR_BROWN-DOT_2",1007.6249690426682]
["COLOR_BROWN-DOT_3",405.09089495888327,144.87748282928803,146.61839120662376,148.00221701742598,153.03598303044731,1000,997.62496904266845,2.3750309573315462,"COLOR_BROWN-DOT_3",997.62496904266845]

{"sheet":"f4_a2_m","index":11,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["element","Y hiba 1","x hiba 1","y hiba 2","x hiba 2","Megtett út/ Időigény","Kártyasorrend"]
["SVK-€01",27.039968261725996,268.9587988294922,1521,324,0.79039712278030227,"IRL-€02"]
["IRL-€01",2043.0397241210851,416.16099609465221,81,1900.9631933606468,0.82596709272352553,"IRL-€20"]
["SVK-€02",1267.3604345703052,196,3249,1324.9595556640709,0.31536661413431644,"IRL-€01"]
["IRL-€02",84.640224609519834,3271.841396484615,4761,268.95979980474527,0.2850403901477338,"SVK-€02"]
["SMR-€20",519.8408349612339,3457.4313867249966,289,10444.842495117498,0.52791713026659548,"SVK-€20"]
["SVK-€20",4,196,190.44050537140549,2724.8412744141879,0.58582266670796035,"SMR-€01"]
["SMR-€02",686.44063964862823,46.23983398451319,1780.8410302736536,2116,1.1746788417610308,"SVK-€01"]
["SMR-€01",3113.638637695487,484,25536.036098633034,1764,0.21906352541059149,"SMR-€02"]
["IRL-€20",9,1.4398828148961906,2894.4419702150872,2401,0.64578636572378112,"SMR-€20"]
[]
["sorszámozás",{"$f":"B1","v":"Y hiba 1"},"x hiba 1","y hiba 2","x hiba 2","Sebesség","Y0"]
[{"$f":"A2","v":"SVK-€01"},{"$f":"RANK(B2,B$2:B$10,1)","v":3},{"$f":"RANK(C2,C$2:C$10,1)","v":5},4,2,{"$f":"RANK(F2,F$2:F$10,0)","v":3},1000]
["IRL-€01",{"$f":"RANK(B3,B$2:B$10,1)","v":8},6,1,5,{"$f":"RANK(F3,F$2:F$10,0)","v":2},1000]
["SVK-€02",7,3,7,3,7,1000]
["IRL-€02",4,8,8,1,8,1000]
["SMR-€20",5,9,3,9,6,1000]
["SVK-€20",1,3,2,8,5,1000]
["SMR-€02",6,2,5,6,1,1000]
["SMR-€01",9,7,9,4,9,1000]
["IRL-€20",2,1,6,7,4,1000]
[]
["lépcsők",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség"]
[1,207.28467244347064,198.49249909480628,210.28113518364836,204.9902811453793,207.28468157888688]
[2,206.28467244347064,197.49249909480628,209.28113518364836,202.32361304016771,206.28468157888688]
[3,205.28467244347064,196.49249909480622,208.2811351836483,201.32361304016769,205.28468157888688]
[4,204.28467244347064,195.49249909480622,202.94780251751146,200.32361304016774,204.28468157888688]
[5,203.28467244347064,194.49249909480622,201.94780251751146,191.99028217644488,203.28468157888688]
[6,202.28467244347064,193.49249909480622,200.94780251751146,190.99028217644488,202.28468157888688]
[7,201.28467244347064,192.49249909480622,199.94780251751146,189.99028217644488,201.28468157888688]
[8,200.28467244347067,191.49249909480625,198.94780251751152,188.99028217644485,200.28468157888688]
[9,199.28467244347075,190.49249909480619,197.94780251751152,187.99028217644479,199.28468157888693]
["visszatérés",2,3,4,5,6]
[]
["lépcsőtávolságok",{"$f":"B23","v":"Y hiba 1"},{"$f":"C23","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség"]
["L1-L2",{"$f":"B24-B25","v":1},{"$f":"C24-C25","v":1},1,2.6666681052115848,1]
["…",{"$f":"B25-B26","v":1},1.0000000000000568,1.0000000000000568,1.0000000000000284,1]
["…",1,1,5.3333326661368403,0.99999999999994316,1]
["…",1,1,1,8.333330863722864,1]
["…",1,1,1,1,1]
["…",1,1,1,1,1]
["…",0.99999999999997158,0.99999999999997158,0.99999999999994316,1.0000000000000284,1]
["L8-L9",0.99999999999991473,1.0000000000000568,1,1.0000000000000568,0.99999999999994316,null,null,"négyzetes hiba"]
[null,null,null,null,null,null,null,null,{"$f":"SUMSQ(I46:I54)","v":313.33333336945907}]
["becslés",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség","Y0","Becslés","hiba",{"$f":"G1","v":"Kártyasorrend"},"Sebesség-becslés"]
[{"$f":"A13","v":"SVK-€01"},{"$f":"VLOOKUP(B13,$A$24:$F$32,B$33,0)","v":205.28467244347064},{"$f":"VLOOKUP(C13,$A$24:$F$32,C$33,0)","v":194.49249909480622},202.94780251751146,202.32361304016771,205.28468157888688,1000,{"$f":"SUM(B46:F46)","v":1010.333268674843},{"$f":"G46-H46","v":-10.333268674842998},{"$f":"G2","v":"IRL-€02"},{"$f":"VLOOKUP(J46,$A$46:$I$54,8,0)","v":999.99993678005455}]
[{"$f":"A14","v":"IRL-€01"},{"$f":"VLOOKUP(B14,$A$24:$F$32,B$33,0)","v":200.28467244347067},193.49249909480622,210.28113518364836,191.99028217644488,206.28468157888688,1000,{"$f":"SUM(B47:F47)","v":1002.333270477257},{"$f":"G47-H47","v":-2.3332704772569741},"IRL-€20",{"$f":"VLOOKUP(J47,$A$46:$I$54,8,0)","v":999.99993781112016}]
["SVK-€02",201.28467244347064,196.49249909480622,199.94780251751146,201.32361304016769,201.28468157888688,1000,1000.3332686748429,-0.33326867484288414,"IRL-€01",1002.333270477257]
["IRL-€02",204.28467244347064,191.49249909480625,198.94780251751152,204.9902811453793,200.28468157888688,1000,999.99993678005455,6.3219945445780468E-5,"SVK-€02",1000.3332686748429]
["SMR-€20",203.28467244347064,190.49249909480619,208.2811351836483,187.99028217644479,202.28468157888688,1000,992.33327047725686,7.6667295227431396,"SVK-€20",1005.333270477257]
["SVK-€20",207.28467244347064,196.49249909480622,209.28113518364836,188.99028217644485,203.28468157888688,1000,1005.333270477257,-5.3332704772569741,"SMR-€01",989.33326867484311]
["SMR-€02",202.28467244347064,197.49249909480628,201.94780251751146,190.99028217644488,207.28468157888688,1000,999.99993781112016,6.2188879837776767E-5,"SVK-€01",1010.333268674843]
["SMR-€01",199.28467244347075,192.49249909480622,197.94780251751152,200.32361304016774,199.28468157888693,1000,989.33326867484311,10.666731325156888,"SMR-€02",999.99993781112016]
["IRL-€20",206.28467244347064,198.49249909480628,200.94780251751146,189.99028217644488,204.28468157888688,1000,999.99993781112016,6.2188879837776767E-5,"SMR-€20",992.33327047725686]

{"sheet":"f4_a3_m","index":12,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["element","Y hiba 1","x hiba 1","y hiba 2","x hiba 2","Megtett út/ Időigény","Kártyasorrend"]
["COLOR_GREEN-DOT_2",484,112.35948242248068,1169.6387475589872,57.7600927734808,0.59043440605373454,"COLOR_GREEN-DOT_2"]
["COLOR_BROWN-DOT_2",100,43.559677735004058,104.03962646519642,219.04054199249754,0.82481979937858851,"COLOR_BROWN-DOT_1"]
["COLOR_GREEN-DOT_1",718.2417993174829,43.559677735004058,1489.9651831099104,27.039809570656644,0.95751856062843099,"COLOR_BLUE-DOT_1"]
["COLOR_BROWN-DOT_1",4,841,4.8399194339327778,295.83937011755211,0.52613794799080393,"COLOR_BROWN-DOT_2"]
["COLOR_BLUE-DOT_3",174.24032226576801,3433.9571386727644,81,3364,0.38146719980954785,"COLOR_GREEN-DOT_1"]
["COLOR_GREEN-DOT_3",1.4400292970234658,1089,73.960104980512853,519.83944335953436,0.71860913782843139,"COLOR_BLUE-DOT_3"]
["COLOR_BLUE-DOT_1",324,262.44039550798732,376.36094726620342,295.83937011755211,0.67930509520325,"COLOR_BLUE-DOT_2"]
["COLOR_BLUE-DOT_2",196,408.03802734633626,772.83932128922413,196,1.2526268154576878,"COLOR_GREEN-DOT_3"]
["COLOR_BROWN-DOT_3",7.8399316407695547,179.56065429740403,4.8399194339327778,900,0.87511022233463143,"COLOR_BROWN-DOT_3"]
[]
["sorszámozás",{"$f":"B1","v":"Y hiba 1"},"x hiba 1","y hiba 2","x hiba 2","Sebesség","Y0"]
[{"$f":"A2","v":"COLOR_GREEN-DOT_2"},{"$f":"RANK(B2,B$2:B$10,1)","v":8},{"$f":"RANK(C2,C$2:C$10,1)","v":3},8,2,{"$f":"RANK(F2,F$2:F$10,0)","v":7},1000]
["COLOR_BROWN-DOT_2",{"$f":"RANK(B3,B$2:B$10,1)","v":4},1,5,4,{"$f":"RANK(F3,F$2:F$10,0)","v":4},1000]
["COLOR_GREEN-DOT_1",9,1,9,1,2,1000]
["COLOR_BROWN-DOT_1",2,7,1,5,8,1000]
["COLOR_BLUE-DOT_3",5,9,4,9,9,1000]
["COLOR_GREEN-DOT_3",1,8,3,7,5,1000]
["COLOR_BLUE-DOT_1",7,5,6,5,6,1000]
["COLOR_BLUE-DOT_2",6,6,7,3,1,1000]
["COLOR_BROWN-DOT_3",3,4,1,8,3,1000]
[]
["lépcsők",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség"]
[1,201.12873360641987,207.17970151603322,199.44933214879188,210.56240600536324,207.17972026031808]
[2,200.12873360641987,206.17970151603322,198.44933214879188,209.56240600536324,206.17972026031808]
[3,199.12873360641987,205.17970151603322,197.44933214879188,203.56241760379419,205.17972026031808]
[4,198.12873360641981,204.17970151603322,196.44933214879197,202.56241760379419,204.17972026031808]
[5,197.12873360641981,203.17970151603322,193.449334245573,201.56241760379419,203.17972026031808]
[6,196.12873360641981,202.17970151603322,192.449334245573,200.56241760379419,202.17972026031808]
[7,195.12873360641981,201.17970151603322,190.94934007815476,199.56241760379419,201.17972026031808]
[8,194.12873360641979,200.17970151603325,189.94934007815476,198.56241760379416,200.17972026031811]
[9,187.12874412275926,199.17970151603316,188.94934007815488,197.56241760379419,199.17972026031802]
["visszatérés",2,3,4,5,6]
[]
["lépcsőtávolságok",{"$f":"B23","v":"Y hiba 1"},{"$f":"C23","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség"]
["L1-L2",{"$f":"B24-B25","v":1},{"$f":"C24-C25","v":1},1,1,1]
["…",{"$f":"B25-B26","v":1},1,1,5.9999884015690554,1]
["…",1.0000000000000568,1,0.99999999999991473,1,1]
["…",1,1,2.9999979032189685,1,1]
["…",1,1,1,1,1]
["…",1,1,1.4999941674182367,1,1]
["…",1.0000000000000284,0.99999999999997158,1,1.0000000000000284,0.99999999999997158]
["L8-L9",6.9999894836605279,1.0000000000000853,0.99999999999988631,0.99999999999997158,1.0000000000000853,null,null,"négyzetes hiba"]
[null,null,null,null,null,null,null,null,{"$f":"SUMSQ(I46:I54)","v":221.50000007822501}]
["becslés",{"$f":"B12","v":"Y hiba 1"},{"$f":"C12","v":"x hiba 1"},"y hiba 2","x hiba 2","Sebesség","Y0","Becslés","hiba",{"$f":"G1","v":"Kártyasorrend"},"Sebesség-becslés"]
[{"$f":"A13","v":"COLOR_GREEN-DOT_2"},{"$f":"VLOOKUP(B13,$A$24:$F$32,B$33,0)","v":194.12873360641979},{"$f":"VLOOKUP(C13,$A$24:$F$32,C$33,0)","v":205.17970151603322},189.94934007815476,209.56240600536324,201.17972026031808,1000,{"$f":"SUM(B46:F46)","v":999.99990146628909},{"$f":"G46-H46","v":9.8533710911397066E-5},{"$f":"G2","v":"COLOR_GREEN-DOT_2"},{"$f":"VLOOKUP(J46,$A$46:$I$54,8,0)","v":999.99990146628909}]
[{"$f":"A14","v":"COLOR_BROWN-DOT_2"},{"$f":"VLOOKUP(B14,$A$24:$F$32,B$33,0)","v":198.12873360641981},207.17970151603322,193.449334245573,202.56241760379419,204.17972026031808,1000,{"$f":"SUM(B47:F47)","v":1005.4999072321383},{"$f":"G47-H47","v":-5.4999072321382982},"COLOR_BROWN-DOT_1",{"$f":"VLOOKUP(J47,$A$46:$I$54,8,0)","v":1002.4999051353573}]
["COLOR_GREEN-DOT_1",187.12874412275926,207.17970151603322,188.94934007815488,210.56240600536324,206.17972026031808,1000,999.99991198262876,8.8017371240312059E-5,"COLOR_BLUE-DOT_1",994.4999072321383]
["COLOR_BROWN-DOT_1",200.12873360641987,201.17970151603322,199.44933214879188,201.56241760379419,200.17972026031811,1000,1002.4999051353573,-2.4999051353572668,"COLOR_BROWN-DOT_2",1005.4999072321383]
["COLOR_BLUE-DOT_3",197.12873360641981,199.17970151603316,196.44933214879197,197.56241760379419,199.17972026031802,1000,989.49990513535715,10.500094864642847,"COLOR_GREEN-DOT_1",999.99991198262876]
["COLOR_GREEN-DOT_3",201.12873360641987,200.17970151603325,197.44933214879188,199.56241760379419,203.17972026031808,1000,1001.4999051353573,-1.4999051353572668,"COLOR_BLUE-DOT_3",989.49990513535715]
["COLOR_BLUE-DOT_1",195.12873360641981,203.17970151603322,192.449334245573,201.56241760379419,202.17972026031808,1000,994.4999072321383,5.5000927678617018,"COLOR_BLUE-DOT_2",999.99991306471998]
["COLOR_BLUE-DOT_2",196.12873360641981,202.17970151603322,190.94934007815476,203.56241760379419,207.17972026031808,1000,999.99991306471998,8.6935280023681116E-5,"COLOR_GREEN-DOT_3",1001.4999051353573]
["COLOR_BROWN-DOT_3",199.12873360641987,204.17970151603322,199.44933214879188,198.56241760379416,205.17972026031808,1000,1006.4999051353573,-6.4999051353572668,"COLOR_BROWN-DOT_3",1006.4999051353573]