{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["ÜP","Excel","Andmed_TL","Proge","Pea","Liides","Graafik","Tee_Mas","Graafikud","F_kesk","F_Pind","F_Min_Nr","Null_Vek","Liides M2","Sheet2","Sheet1"],"not_rendered":{"charts":5,"images":10,"macros":1,"external_links":2,"defined_names":73,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Graafik","index":6,"reason":"not_a_worksheet"}],"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":"ÜP","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Funktsioonide uurimine"]

{"sheet":"Excel","index":1,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Funktsioonide uurimine. Excel"]
[]
[null,"algus","pikkus","lõpp","jaotisi","samm","piir","arv",null,"kesk > a","Pind","abs min","koht"]
[null,-10,20,{"$f":"algus+pikkus","v":10},20,{"$f":"(lõpp-algus)/jaotisi","v":1},2,1,"Fy",{"$f":"AVERAGEIF(Fy, \">1\")","v":1.78631614937381},{"$f":"samm*(SUM(Fya)-INDEX(Fya,1)/2-INDEX(Fya,COUNT(x))/2)","v":22.675460562976358},{"$f":"MIN(Fya)","v":0},{"$f":"INDEX(x, MATCH(L5, Fya, 0))","v":-2}]
[null,null,null,null,null,null,null,null,"Fz",{"$f":"AVERAGEIF(Fz, \">1\")","v":2.9163324719611285},{"$f":"samm*(SUM(Fza)-INDEX(Fza, 1)/2-INDEX(Fza, COUNT(x))/2)","v":54.137195083527089},{"$f":"MIN(Fza)","v":2.2128489940253928E-2},{"$f":"INDEX(x, MATCH(L6, Fza, 0))","v":-4}]
[]
[null,"x","Fy","Fz","Fya","Fza"]
[null,{"$f":"algus","v":-10},{"$f":" 3 * SIN(x + 2) * COS(x / 2)","v":-0.84193056732976213},{"$f":"IF(x<=piir, 5 * COS(2 * x - 3), 3 * SIN(x + 1))","v":-2.6641651016669874},{"$f":"ABS(C9)","v":0.84193056732976213},{"$f":"ABS(D9)","v":2.6641651016669874},{"$f":" 3 * SIN(x + 2) * COS(x / 2)","v":-0.84193056732976213}]
[null,{"$f":"B9+samm","v":-9},0.41547004587670799,-2.7386463011213418,{"$f":"ABS(C10)","v":0.41547004587670799},{"$f":"ABS(D10)","v":2.7386463011213418},0.41547004587670799]
[null,-8,-0.54791447390446779,4.9435230909333461,0.54791447390446779,4.9435230909333461,-0.54791447390446779]
[null,-7,-2.6939731488413168,-1.3758166902579847,2.6939731488413168,1.3758166902579847,-2.6939731488413168]
[null,-6,-2.2476863752900278,-3.7984395642941067,2.2476863752900278,3.7984395642941067,-2.2476863752900278]
[null,-5,0.33917218044928332,4.5372339072509806,0.33917218044928332,4.5372339072509806,0.33917218044928332]
[null,-4,1.1352037429618924,2.2128489940253928E-2,1.1352037429618924,2.2128489940253928E-2,1.1352037429618924]
[null,-3,-0.1785699082496302,-4.5556513094233848,0.1785699082496302,4.5556513094233848,-0.1785699082496302]
[null,-2,0,3.7695112717165231,0,3.7695112717165231,0]
[null,-1,2.2153807878123861,1.4183109273161312,2.2153807878123861,1.4183109273161312,2.2153807878123861]
[null,0,2.7278922804770449,-4.9499624830022269,2.7278922804770449,4.9499624830022269,2.7278922804770449]
[null,1,0.37153337462150493,2.7015115293406988,0.37153337462150493,2.7015115293406988,0.37153337462150493]
[null,2,-1.2267063999049068,2.7015115293406988,1.2267063999049068,2.7015115293406988,-1.2267063999049068]
[null,3,-0.20349485940270645,-2.2704074859237844,0.20349485940270645,2.2704074859237844,-0.20349485940270645]
[null,4,0.34883362697318027,-2.8767728239894153,0.34883362697318027,2.8767728239894153,0.34883362697318027]
[null,5,-1.5790218571903594,-0.83824649459677758,1.5790218571903594,0.83824649459677758,-1.5790218571903594]
[null,6,-2.9383717218207628,1.9709597961563672,2.9383717218207628,1.9709597961563672,-2.9383717218207628]
[null,7,-1.157793334382389,2.9680747398701453,1.157793334382389,2.9680747398701453,-1.157793334382389]
[null,8,1.0667877862439166,1.2363554557252698,1.0667877862439166,1.2363554557252698,1.0667877862439166]
[null,9,0.6323812050384181,-1.6320633326681093,0.6323812050384181,1.6320633326681093,0.6323812050384181]
[null,10,-0.45661633974115162,-2.9999706196521103,0.45661633974115162,2.9999706196521103,-0.45661633974115162]

{"sheet":"Andmed_TL","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Proge","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Programmi struktuur"]

{"sheet":"Pea","index":4,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,5,0,6],[36,8,36,9]]}
[]
["Peaprotseduur Fun_Uur_1"]

{"sheet":"Liides","index":5,"n_rows":111,"n_cols":16,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Funktsioonide tabuleerimine ja graafikud"]
[null,"Algandmed",null,null,null,null,null,null,"Karakteristikud"]
[null,"algus","pikkus","lõpp","jaotisi","piir","arv",null,null,"kesk > a","pindala","abs min","koht",null,"baas","lisa"]
[null,{"$f":"baas+lisa","v":-10},20,{"$f":"algus+pikkus","v":10},100,2,1,null,"Fy",1.8063613941127949,22.666551490716465,0,-2,null,-50,40]
[null,null,null,null,null,null,null,null,"FZ",3.2168990770021852,54.450319839676631,2.2128489940253928E-2,-4]
[null,"nullkohad",null,null,"funktsioonide tabel"]
[]
[null,"NV_Y","NV_Z",null,"x","Fy","Fz"]
[null,-9.4232375717849486,-8.7100414657865315,null,-10,-0.84193056732976213,-2.6641651016669874]
[null,-8.2910604238595909,-7.1389338644027687,null,-9.8000000000000007,-0.55872205595088897,-4.1015272918374448]
[null,-5.1386547689579665,-5.5680941718026107,null,-9.6,-0.25407596206139221,-4.8913485070325375]
[null,-3.1372478707362612,-3.9977290364163123,null,-9.4,3.3401376451156352E-2,-4.9089333439663836]
[null,-2,-2.4274505262749129,null,-9.1999999999999993,0.26703556943348866,-4.1515055435426262]
[null,1.1439861662624564,-0.85666920577838745,null,-9,0.41547004587670799,-2.7386463011213418]
[null,3.1448958994964302,0.71441072126825955,null,-8.8000000000000007,0.4555718229002495,-0.89341502512367277]
[null,4.2758976192907419,2.1878244898210353,null,-8.6,0.37459656169448557,1.0928668389263132]
[null,7.4264470551470554,5.2832398139699297,null,-8.4,0.17141852668982532,2.9066090590721783]
[null,9.4273169668985144,8.4248871430075436,null,-8.1999999999999993,-0.14328533532793897,4.2614616193273216]
[null,null,null,null,-8,-0.54791447390446779,4.9435230909333461]
[null,null,null,null,-7.8,-1.0118091919147074,4.8451109646952499]
[null,null,null,null,-7.6,-1.4979345844973309,3.9817623514596159]
[null,null,null,null,-7.4,-1.9661447592027297,2.4897810139420775]
[null,null,null,null,-7.1999999999999993,-2.3767361938999025,0.60471799964237072]
[null,null,null,null,-7,-2.6939731488413172,-1.3758166902579847]
[null,null,null,null,-6.8,-2.88927043000235,-3.1391401762319298]
[null,null,null,null,-6.6,-2.9437492908854472,-4.4068624518111736]
[null,null,null,null,-6.4,-2.8499381369980696,-4.9788380443664426]
[null,null,null,null,-6.1999999999999993,-2.6124659710349989,-4.7647645844358983]
[null,null,null,null,-6,-2.2476863752900282,-3.7984395642941067]
[null,null,null,null,-5.8,-1.7822652453661219,-2.2324244570613279]
[null,null,null,null,-5.6,-1.2508579436250231,-0.3139586146204088]
[null,null,null,null,-5.3999999999999995,-0.69308277444839173,1.6540743897452432]
[null,null,null,null,-5.1999999999999993,-0.15006044097191537,3.3609654177673471]
[null,null,null,null,-5,0.33917218044928332,4.5372339072509806]
[null,null,null,null,-4.8,0.74105447011725456,4.9971729275050238]
[null,null,null,null,-4.5999999999999996,1.0303986089444899,4.6681682203731869]
[null,null,null,null,-4.3999999999999995,1.1925325092576051,3.6021623949541874]
[null,null,null,null,-4.1999999999999993,1.2244987801539402,1.9674543317394464]
[null,null,null,null,-4,1.1352037429618924,2.2128489940253928E-2]
[null,null,null,null,-3.8,0.94450433633298192,-1.9266909538591481]
[null,null,null,null,-3.5999999999999996,0.68131564923283838,-3.5713282601360015]
[null,null,null,null,-3.3999999999999995,0.3809093163420727,-4.6521313605237697]
[null,null,null,null,-3.1999999999999993,8.1645288229117347E-2,-4.9984652101760325]
[null,null,null,null,-3,-0.17856990824963023,-4.5556513094233848]
[null,null,null,null,-2.8,-0.36578089563683241,-3.3936002366000624]
[null,null,null,null,-2.5999999999999996,-0.45312360067458518,-1.6957743049191727]
[null,null,null,null,-2.3999999999999995,-0.42332626821297342,0.26977710281325318]
[null,null,null,null,-2.1999999999999993,-0.27034691368456359,2.1927366378719597]
[null,null,null,null,-2,0,3.7695112717165231]
[null,null,null,null,-1.7999999999999989,0.3704845092356186,4.7511629597926506]
[null,null,null,null,-1.5999999999999996,0.81393111548786456,4.9827104851160868]
[null,null,null,null,-1.4000000000000004,1.2955871531555463,4.4275975847065965]
[null,null,null,null,-1.1999999999999993,1.7761785911752839,3.1734643797131663]
[null,null,null,null,-1,2.2153807878123861,1.4183109273161312]
[null,null,null,null,-0.79999999999999893,2.5753945409115437,-0.5607626346752832]
[null,null,null,null,-0.59999999999999964,2.8243082557708563,-2.4513041067035011]
[null,null,null,null,-0.39999999999999858,2.938946041299983,-3.9548385595720918]
[null,null,null,null,-0.19999999999999929,2.9069473472098242,-4.8339909628973068]
[null,null,null,null,0,2.7278922804770449,-4.9499624830022269]
[null,null,null,null,0.20000000000000107,2.4133718682383889,-4.2844437668447304]
[null,null,null,null,0.40000000000000036,1.9859966634615807,-2.9425055862767255]
[null,null,null,null,0.60000000000000142,1.4774318120860499,-1.1360104734654213]
[null,null,null,null,0.80000000000000071,0.92563355568535466,0.84983571450121165]
[null,null,null,null,1,0.37153337462150499,2.7015115293406988]
[null,null,null,null,1.2000000000000011,-0.14453477868188486,4.1266780745483977]
[null,null,null,null,1.4000000000000004,-0.58634584624587149,4.9003328892062088]
[null,null,null,null,1.6000000000000014,-0.92492088560041863,4.9003328892062052]
[null,null,null,null,1.8000000000000007,-1.1410108925251783,4.1266780745483871]
[null,null,null,null,2,-1.2267063999049068,2.7015115293406988]
[null,null,null,null,2.2000000000000011,-1.1860301696859155,-0.17512243028274294]
[null,null,null,null,2.4000000000000004,-1.0344611719498513,-0.766623306080495]
[null,null,null,null,2.6000000000000014,-0.79743353846022524,-1.327561329884561]
[null,null,null,null,2.8000000000000007,-0.50794575726649072,-1.8355736728281586]
[null,null,null,null,3,-0.20349485940270648,-2.2704074859237844]
[null,null,null,null,3.2000000000000011,7.7389361765635281E-2,-2.6147273172407659]
[null,null,null,null,3.4000000000000004,0.29869934882607474,-2.8548062216685479]
[null,null,null,null,3.6000000000000014,0.43027530730336205,-2.9810730109003938]
[null,null,null,null,3.8000000000000007,0.45060311203953968,-2.9884938265075216]
[null,null,null,null,4,0.34883362697318027,-2.8767728239894153]
[null,null,null,null,4.2000000000000011,0.12584208403782321,-2.6503639671604584]
[null,null,null,null,4.4000000000000004,-0.20576801180921303,-2.3182934626679614]
[null,null,null,null,4.6000000000000014,-0.62271762043735823,-1.8937999136169605]
[null,null,null,null,4.8000000000000007,-1.0930682396839053,-1.3938065382412699]
[null,null,null,null,5,-1.5790218571903594,-0.83824649459677758]
[null,null,null,null,5.2000000000000011,-2.0402551993280906,-0.24926820845248657]
[null,null,null,null,5.4,-2.4374908596854756,0.34964761455148091]
[null,null,null,null,5.6000000000000014,-2.7359866168822431,0.93462409054013862]
[null,null,null,null,5.8000000000000007,-2.9086314433417813,1.4823400534158269]
[null,null,null,null,6,-2.9383717218207628,1.9709597961563672]
[null,null,null,null,6.1999999999999993,-2.8197508983447328,2.3810035915474579]
[null,null,null,null,6.4000000000000021,-2.5594248760332894,2.6961242874348832]
[null,null,null,null,6.6000000000000014,-2.175606831691399,2.9037590160944604]
[null,null,null,null,6.8000000000000007,-1.6964906546892213,2.9956300361238148]
[null,null,null,null,7,-1.157793334382389,2.9680747398701453]
[null,null,null,null,7.1999999999999993,-0.59963521915617657,2.8221916700393193]
[null,null,null,null,7.4000000000000021,-6.3036117337890163E-2,2.5637967242648387]
[null,null,null,null,7.6000000000000014,0.41366056580803989,2.2031912936223366]
[null,null,null,null,7.8000000000000007,0.79811711621733972,1.7547515786752852]
[null,null,null,null,8,1.0667877862439166,1.2363554557252698]
[null,null,null,null,8.1999999999999993,1.2069141900037765,0.66866974230074294]
[null,null,null,null,8.4000000000000021,1.2175526539845107,7.4326276360067972E-2]
[null,null,null,null,8.6000000000000014,1.109542874994488,-0.52298034366894419]
[null,null,null,null,8.8000000000000007,0.90442184055643771,-1.0994373877557853]
[null,null,null,null,9,0.6323812050384181,-1.6320633326681093]
[null,null,null,null,9.2000000000000028,0.32945176992854153,-2.0996240627806344]
[null,null,null,null,9.4000000000000021,3.4167755148882567E-2,-2.4834794072569641]
[null,null,null,null,9.6000000000000014,-0.2159899968140119,-2.7683262648384219]
[null,null,null,null,9.8000000000000007,-0.38805302044732148,-2.9428086901994748]
[null,null,null,null,10,-0.45661633974115157,-2.9999706196521103]

{"sheet":"Tee_Mas","index":7,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Protseduur Tee_Tab"]
[null,"Arvutab argumendi ja funktsioonide väärtused ja kirjutab need töölehele"]
[null,"Kasutab protseduure (funktsioone) Fy ja Fx"]

{"sheet":"Graafikud","index":8,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Graafikute tegemine ja uuendamine"]

{"sheet":"F_kesk","index":9,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Antud arvust suuremate aritmeetilise keskmise leidmine"]

{"sheet":"F_Pind","index":10,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Määratud integraali ning joone ja X-telje vahel oleva ala pindala leidmise põhimõte"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Funktsioon Pind - pindala leidmiseks"]

{"sheet":"F_Min_Nr","index":11,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Absoluutväärtuselt väikseima elemendi järjenumbri (indeksi) leidmine vektoris"]

{"sheet":"Null_Vek","index":12,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Protseduur Null_Vek(X; Y, NV, n)"]
[null,"Leiab nullkohad vektorina antud funktsiooni väärtustest"]

{"sheet":"Liides M2","index":13,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Algandmed",null,null,null,null,null,null,null,"Karakteristikud"]
[null,"algus","pikkus","lõpp","jaotisi","piir","arv","baas","lisa",null,"kesk > a","pindala","abs min","koht"]
[null,{"$f":"baas+lisa","v":-1},10,{"$f":"algus+pikkus","v":9},20,2,1,-50,49,"Fy",1.9710636346081196,13.252701201630339,0.18499786532847046,7.5]
[null,null,null,null,null,null,null,null,null,"FZ",2.5784650273271112,23.284888680805082,-0.2254533613854279,8.5]
[]
[null,"NV_Y","NV_Z",null,null,"x","y","z"]
[null,1.1627354083018822,-0.84868215712070749,null,null,-1,2.2153807878123861,1.4183109273161312]
[null,3.1751927508750595,0.71754781205421114,null,null,-0.5,2.8994558493442844,-3.2682181043180596]
[null,4.2312509613384792,2.3598310348302185,null,null,0,2.7278922804770449,-4.9499624830022269]
[null,7.4311144333652521,5.2825029810266386,null,null,0.5,1.7396012834103796,-2.080734182735712]
[null,null,8.4228854831266364,null,null,1,0.37153337462150499,2.7015115293406988]
[null,null,null,null,null,1.5,-0.76999254926437777,5]
[null,null,null,null,null,2,-1.2267063999049068,2.7015115293406988]
[null,null,null,null,null,2.5,-0.92471131804405005,-1.0523496830688595]
[null,null,null,null,null,3,-0.20349485940270648,-2.2704074859237844]
[null,null,null,null,null,3.5,0.3772793404037425,-2.932590352995291]
[null,null,null,null,null,4,0.34883362697318027,-2.8767728239894153]
[null,null,null,null,null,4.5,-0.40539810671158666,-2.1166209767111757]
[null,null,null,null,null,5,-1.5790218571903594,-0.83824649459677758]
[null,null,null,null,null,5.5,-2.6009868290702602,0.64535996426344655]
[null,null,null,null,null,6,-2.9383717218207628,1.9709597961563672]
[null,null,null,null,null,6.5,-2.3813992038806431,2.8139999303242167]
[null,null,null,null,null,7,-1.157793334382389,2.9680747398701453]
[null,null,null,null,null,7.5,0.18499786532847046,2.3954613378704708]
[null,null,null,null,null,8,1.0667877862439166,1.2363554557252698]
[null,null,null,null,null,8.5,1.177263820360706,-0.2254533613854279]
[null,null,null,null,null,9,0.6323812050384181,-1.6320633326681093]

{"sheet":"Sheet2","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet1","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}