{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["megjelenítés","iterált_keresés","lineáris_keresés","struktogram","logaritmikus_keresés"],"not_rendered":{"charts":1,"macros":1,"defined_names":16},"read":"whole","date_system":"1900"}

{"sheet":"megjelenítés","index":0,"n_rows":32,"n_cols":16,"rows_kept":32}
[]
[null,"metszéspont",{"$nulls":3},"h",{"v":7,"d":"7.00 m"},null,"xe",{"$f":"-b","v":{"v":-7,"d":"-7.00 m"}},null,null,"n",10,"⮞ dx",7.000000000000117E-4]
[]
[null,{"v":-3.3306000000000013,"d":"-3.33 m"},{"$f":"h/4*(2+(1-ABS(x)*2/b)^3+(1-ABS(x)*2/b))","v":{"v":3.5848984148319993,"d":"3.58 m"}},null,null,"b",{"v":7,"d":"7.00 m"},null,"xv",{"$f":"xe+b","v":{"v":0,"d":"0.00 m"}},{"$nulls":4},"próbálkozás",16]
[]
["i","x"," f(x)"," g(x)"]
[]
[-10,{"$f":"i/10*b","v":{"v":-7,"d":"-7.00 m"}},{"$f":"h/4*(2+(1-ABS(x)*2/b)^3+(1-ABS(x)*2/b))","v":{"v":0,"d":"0.00 m"}},{"$f":"(b^2/6+(x+h/6)^2)^(1/2)","v":{"v":6.495725089968358,"d":"6.50 m"}}]
[-9,{"v":-6.3,"d":"-6.30 m"},{"$f":"h/4*(2+(1-ABS(x)*2/b)^3+(1-ABS(x)*2/b))","v":{"v":1.204,"d":"1.20 m"}},{"v":5.87518321227328,"d":"5.88 m"}]
[-8,{"v":-5.6000000000000005,"d":"-5.60 m"},{"v":2.0719999999999996,"d":"2.07 m"},{"v":5.274572125880081,"d":"5.27 m"}]
[-7,{"v":-4.8999999999999995,"d":"-4.90 m"},{"v":2.688,"d":"2.69 m"},{"v":4.701536391908973,"d":"4.70 m"}]
[-6,{"v":-4.2,"d":"-4.20 m"},{"v":3.136,"d":"3.14 m"},{"v":4.167466589881409,"d":"4.17 m"}]
[-5,{"v":-3.5,"d":"-3.50 m"},{"v":3.5,"d":"3.50 m"},{"v":3.6893239368631088,"d":"3.69 m"}]
[-4,{"v":-2.8000000000000003,"d":"-2.80 m"},{"v":3.8640000000000003,"d":"3.86 m"},{"v":3.291571728588706,"d":"3.29 m"}]
[-3,{"v":-2.1,"d":"-2.10 m"},{"v":4.312,"d":"4.31 m"},{"v":3.0062897029025293,"d":"3.01 m"}]
[-2,{"v":-1.4000000000000001,"d":"-1.40 m"},{"v":4.928000000000001,"d":"4.93 m"},{"v":2.867248003070385,"d":"2.87 m"}]
[-1,{"v":-0.7000000000000001,"d":"-0.70 m"},{"v":5.796,"d":"5.80 m"},{"v":2.8955905173978667,"d":"2.90 m"}]
[0,{"v":0,"d":"0.00 m"},{"v":7,"d":"7.00 m"},{"v":3.086709862908689,"d":"3.09 m"}]
[1,{"v":0.7000000000000001,"d":"0.70 m"},{"v":5.796,"d":"5.80 m"},{"v":3.413372395609818,"d":"3.41 m"}]
[2,{"v":1.4000000000000001,"d":"1.40 m"},{"v":4.928000000000001,"d":"4.93 m"},{"v":3.84115144773601,"d":"3.84 m"}]
[3,{"v":2.1,"d":"2.10 m"},{"v":4.312,"d":"4.31 m"},{"v":4.340250888805597,"d":"4.34 m"}]
[4,{"v":2.8000000000000003,"d":"2.80 m"},{"v":3.8640000000000003,"d":"3.86 m"},{"v":4.8888762626099584,"d":"4.89 m"}]
[5,{"v":3.5,"d":"3.50 m"},{"v":3.5,"d":"3.50 m"},{"v":5.4721517197940015,"d":"5.47 m"}]
[6,{"v":4.2,"d":"4.20 m"},{"v":3.136,"d":"3.14 m"},{"v":6.080113303037846,"d":"6.08 m"}]
[7,{"v":4.8999999999999995,"d":"4.90 m"},{"v":2.688,"d":"2.69 m"},{"v":6.70605033615996,"d":"6.71 m"}]
[8,{"v":5.6000000000000005,"d":"5.60 m"},{"v":2.0719999999999996,"d":"2.07 m"},{"v":7.345368911392025,"d":"7.35 m"}]
[9,{"v":6.3,"d":"6.30 m"},{"v":1.204,"d":"1.20 m"},{"v":7.994859459538847,"d":"7.99 m"}]
[10,{"v":7,"d":"7.00 m"},{"v":0,"d":"0.00 m"},{"v":8.652231568278273,"d":"8.65 m"}]
[]
[]
[10]
[{"$f":"(scrollbar-100)/n","v":-9},{"$f":"i/10*b","v":{"v":-6.3,"d":"-6.30 m"}},{"$f":"h/4*(2+(1-ABS(x)*2/b)^3+(1-ABS(x)*2/b))","v":{"v":1.204,"d":"1.20 m"}},{"$f":"(b^2/6+(x+h/6)^2)^(1/2)","v":{"v":5.87518321227328,"d":"5.88 m"}}]

{"sheet":"iterált_keresés","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[1,2,1,5]]}
[]
[null,null,"f(x) és g(x) függvények metszéspontja [xe,xv] intervallumban\n(paraméterek: xe,xv, n, és h, b függvényparaméterek)",{"$nulls":4},"f(x)   "]
[null,"ciklus indítása",{"$nulls":5}," f := h/4 · ( 2 + ( 1 – 2 ·|x|/b )³ + ( 1 – 2 ·|x|/b ) )"]
[null,null,"dx :=  (xv − xe) / n"]
[null,null,"x := xe"]
[null,null,"e := Sgn( f(x) − g(x) )",{"$nulls":4},"g(x)   "]
[null,null,"i := 0"]
[null,null,"i < n  ˄  e · ( f(x) − g(x) ) > 0",{"$nulls":4}," g := Sqr( b²/6 + (x + h/6)² )"]
[{"$nulls":3},"i := i + 1"]
[{"$nulls":3},"x := xe + i * dx"]
[null,null,"xe := x − dx"]
[null,null,"xv := x"]
[null,"dx < határérték  ˅  e · ( f(x) − g(x) ) = 0"]
[null,"i","e · ( f(x) − g(x) ) ≤  0",null,null,"h"]
[null,"metszéspont: [ mpx ; f(mpx) ]\n(valójában: x − dx < mpx ≤ x )",null,null,"nincs metszéspont [ xe ; xv ]-ben\n(vagy sűrűbb lépésköz szükséges)"]

{"sheet":"lineáris_keresés","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"merged":[[1,1,1,4]]}
[]
[null,"f(x) és g(x) függvények metszéspontja [xe,xv] intervallumban\n(paraméterek: xe,xv, n, és h, b függvényparaméterek)",{"$nulls":4},"f(x)   "]
[null,"dx :=  (xv − xe) / n",{"$nulls":4}," f := h/4 · ( 2 + ( 1 – 2 ·|x|/b )³ + ( 1 – 2 ·|x|/b ) )"]
[null,"x := xe"]
[null,"e := Sgn( f(x) − g(x) )"]
[null,"i := 0",{"$nulls":4},"g(x)   "]
[null,"i < n  ˄  e · ( f(x) − g(x) ) > 0"]
[null,null,"i := i + 1",{"$nulls":3}," g := Sqr( b²/6 + (x + h/6)² )"]
[null,null,"x := xe + i * dx"]
[null,"i","e · ( f(x) − g(x) ) ≤  0",null,"h"]
[null,"metszéspont: [ mpx ; f(mpx) ]\n(valójában: x − dx < mpx ≤ x )",null,"nincs metszéspont [ xe ; xv ]-ben\n(vagy sűrűbb lépésköz szükséges)"]

{"sheet":"struktogram","index":3,"n_rows":19,"n_cols":11,"rows_kept":19}
[null,"Struktogram használat"]
[null,"algoritmus (paraméterek)"]
[]
["szekvencia:","utasítás 1",{"$nulls":6},"(elemi utasítás)"]
["(utasítások egymás","utasítás 2",{"$nulls":6},"(összetett  utasítás  => új struktogramban kifejtendő)"]
["utáni sorozata)","…"]
[null,"utasítás n"]
[]
["kétirányú elágazás:","i","feltétel",{"$nulls":3},"h",null,"jelölések:",":=","értékadás (a bal oldal legyen egyenlő"]
[null,"(igaz ág)",null,null,"(hamis ág)",{"$nulls":5},"a jobb oldal kiértékelése utáni értékkel)"]
[{"$nulls":9},"˄","és logikai operátor"]
["többirányú elágazás:","felt1","felt2"," ","…",null,"feltn",null,null,"˅","vagy logikai operátor"]
["(felbontható kétirányú",{"$nulls":3},"…",{"$nulls":4},"˥","logikai negálás"]
["elágazások sorozatára)",{"$nulls":8},"á",true]
[{"$nulls":9},"á",true]
["ciklus:",null,null,"feltétel","(teljesül a feltétel)",null," ",null,null,"â",false]
[null,null,"(ciklusmag)",{"$nulls":6},"SKIP","üres utasítás"]
[{"$nulls":10},"(továbblépés a következő utasításra)"]
[null,"(nem teljesül a feltétel)"]

{"sheet":"logaritmikus_keresés","index":4,"n_rows":18,"n_cols":11,"rows_kept":18,"hidden":true,"merged":[[1,1,1,8]]}
[]
[null,"f(x) és g(x) függvények metszéspontja [xe,xv] intervallumban\n(paraméterek: xe, xv, n, és h, b függvényparaméterek)"]
[null,"j := xe",{"$nulls":8},"f(x)"]
[null,"k := xv",{"$nulls":8},"f := h/4*(2+(1-ABS(x)*2/b)^3+(1-ABS(x)*2/b))"]
[null,"x:=xv"]
[null,null,"( f(x) - g(x) )=0",null,null,"( f(x) - g(x) )<0",null,"( f(x) - g(x) )>0"]
[null,"mp := á",null,null,"e1:= 1",null,"e1 := -1",{"$nulls":3},"g(x)"]
[null,"x:=xk",{"$nulls":8},"g:= Sqr(b^2-(x+b)^2)"]
[null,null,"( f(x) - g(x) )=0",null,null,"( f(x) - g(x) )<0",null,"( f(x) - g(x) )>0"]
[null,"mp := á",null,null,"e := 1",null,"e := -1"]
[null,"i",null,"e = e1",{"$nulls":4},"h"]
[null,"paros_mp := á\n(az egyik függvényérték az intervallum két szélén azonosan nagyobb, vagy kisebb a másiknál, nincs, vagy páros számú metszéspont van!)",{"$nulls":3},"SKIP"]
[null,"˥ mp  ˄ ˥ paros_mp  ˄  (k-j) > dx "]
[null,null,"x := (j+k)/2"]
[{"$nulls":3},"( f(x) - g(x) )=0",null,"( f(x) - g(x) )<0",null,"( f(x) - g(x) )>0"]
[null,null,"mp := á",null,"j := x",null,"k := x"]
[null,null,"mp",null,null,"paros_mp",null,"(k-j) <= dx"]
[null,"a metszéspont koordinátái: [x;f(x)]",null,null,"nincs metszéspont [xk,xv]-ben\n(vagy páros számú metszéspont van)",null,"a metszéspont koordinátái: [mpx;f(mpx)]\n(x-dx < mpx < x+dx)"]