{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":2,"images":2,"macros":0,"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":"Лист1","index":0,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["X","Y"]
[-2,{"$f":"POWER(1/(1+A2*A2-A2),1/3)","v":0.52275795857471019}]
[{"$f":"A2+0.1","v":-1.9},{"$f":"POWER(1/(1+A3*A3-A3),1/3)","v":0.53555778554224087}]
[{"$f":"A3+0.1","v":-1.7999999999999998},0.54910367937497162]
[-1.6999999999999997,0.56345953263748394]
[-1.5999999999999996,0.57869549227510231]
[-1.4999999999999996,0.59488834925900302]
[-1.3999999999999995,0.61212178625384328]
[-1.2999999999999994,0.63048636870156749]
[-1.1999999999999993,0.65007910258240931]
[-1.0999999999999992,0.67100228959958863]
[-0.99999999999999922,0.69336127435063488]
[-0.89999999999999925,0.71726048088511907]
[-0.79999999999999927,0.74279685776596505]
[-0.69999999999999929,0.77004947372351684]
[-0.59999999999999931,0.79906353005814068]
[-0.49999999999999933,0.82982653336624368]
[-0.39999999999999936,0.86223397961111792]
[-0.29999999999999938,0.89604206845008927]
[-0.19999999999999937,0.93080656621060631]
[-9.9999999999999367E-2,0.96581142912070905]
[0,1]
[0.1,1.0319362513018593]
[0.2,1.0598398329483265]
[0.30000000000000004,1.0817435214736382]
[0.4,1.0957937084221749]
[0.5,1.1006424162982089]
[0.6,1.0957937084221752]
[0.7,1.0817435214736382]
[0.79999999999999993,1.0598398329483265]
[0.89999999999999991,1.0319362513018593]

{"sheet":"Лист2","index":1,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["COS X","SIN X","X","Y"]
[{"$f":"COS(C2)","v":-0.98999249660044542},{"$f":"SIN(C2)","v":-0.14112000805986721},-3,{"$f":"IF(C2<0,(C2*C2-1)*(C2*C2-4)*(C2*C2-9),IF(C2<2,(C2*C2*C2+C2*C2-1)/(C2*C2*C2+2),IF(C2>2,A2/(1+B2))))","v":0},null,null,null,null,null,null,null,"Схема алгоритма:"]
[{"$f":"COS(C3)","v":-0.97095816514959055},{"$f":"SIN(C3)","v":-0.23924932921398243},-2.9,{"$f":"IF(C3<0,(C3*C3-1)*(C3*C3-4)*(C3*C3-9),IF(C3<2,(C3*C3*C3+C3*C3-1)/(C3*C3*C3+2),IF(C3>2,A3/(1+B3))))","v":-19.280078999999997},null,null,null,null,null,null,null,"1) выставить значения переменных"]
[-0.94222234066865806,-0.33498815015590511,-2.8,-30.468096000000013,null,null,null,null,null,null,null,"2)при помощи логической функции ЕСЛИ вычислить значения функции в области определения"]
[-0.90407214201706121,-0.42737988023382978,-2.7,-35.386910999999998,null,null,null,null,null,null,null,"3)высчитать значения функций COS X и SIN X, т.к. функция ЕСЛИ выдает ошибку"]
[-0.85688875336894732,-0.51550137182146416,-2.6,-35.610624000000001,null,null,null,null,null,null,null,"4)построить график"]
[-0.8011436155469337,-0.59847214410395655,-2.5,-32.484375]
[-0.73739371554124544,-0.67546318055115095,-2.4,-27.143424]
[-0.6662760212798241,-0.74570521217672026,-2.2999999999999998,-20.531510999999988]
[-0.58850111725534582,-0.80849640381959009,-2.2000000000000002,-13.418496000000012]
[-0.50484610459985757,-0.86320936664887371,-2.1,-6.4172790000000024]
[-0.41614683654714241,-0.90929742682568171,-2,0]
[-0.32328956686350335,-0.94630008768741447,-1.9,5.4864810000000022]
[-0.22720209469308711,-0.97384763087819515,-1.8,9.8058239999999977]
[-0.12884449429552464,-0.99166481045246857,-1.7,12.818169000000001]
[-2.9199522301288815E-2,-0.99957360304150511,-1.6,14.466815999999998]
[7.0737201667702906E-2,-0.99749498660405445,-1.5,14.765625]
[0.16996714290024104,-0.98544972998846014,-1.4,13.787135999999997]
[0.26749882862458735,-0.96355818541719296,-1.3,11.651408999999999]
[0.36235775447667362,-0.93203908596722629,-1.2,8.5155839999999987]
[0.45359612142557731,-0.89120736006143542,-1.1000000000000001,4.5641610000000039]
[0.54030230586813977,-0.8414709848078965,-1,0]
[0.62160996827066439,-0.78332690962748341,-0.9,-4.9639589999999982]
[0.69670670934716539,-0.71735609089952279,-0.8,-10.112255999999995]
[0.7648421872844885,-0.64421768723769102,-0.7,-15.233751000000002]
[0.82533561490967833,-0.56464247339503537,-0.6,-20.127744000000003]
[0.87758256189037276,-0.47942553860420301,-0.5,-24.609375]
[0.9210609940028851,-0.38941834230865052,-0.4,-28.514303999999996]
[0.95533648912560598,-0.29552020666133955,-0.3,-31.702671000000002]
[0.98006657784124163,-0.19866933079506122,-0.2,-34.062336000000002]
[0.99500416527802582,-9.9833416646828155E-2,-0.1,-35.511399000000004]
[1,0,0,-0.5]
[0.99500416527802582,9.9833416646828155E-2,0.1,-0.4942528735632184]
[0.98006657784124163,0.19866933079506122,0.2,-0.47410358565737049]
[0.95533648912560598,0.29552020666133955,0.3,-0.43561914158855447]
[0.9210609940028851,0.38941834230865052,0.4,-0.37596899224806202]
[0.87758256189037276,0.47942553860420301,0.5,-0.29411764705882354]
[0.82533561490967833,0.56464247339503537,0.6,-0.19133574007220217]
[0.7648421872844885,0.64421768723769102,0.7,-7.1276141698676979E-2]
[0.69670670934716539,0.71735609089952279,0.8,6.0509554140127444E-2]
[0.62160996827066439,0.78332690962748341,0.9,0.19750824477830711]
[0.54030230586813977,0.8414709848078965,1,0.33333333333333331]
[0.45359612142557731,0.89120736006143542,1.1000000000000001,0.46262383668568002]
[0.36235775447667362,0.93203908596722629,1.2,0.5815450643776825]
[0.26749882862458735,0.96355818541719296,1.3,0.68787228973075998]
[0.16996714290024104,0.98544972998846014,1.4,0.78077571669477219]
[7.0737201667702906E-2,0.99749498660405445,1.5,0.86046511627906974]
[-2.9199522301288815E-2,0.99957360304150511,1.6,0.92782152230971138]
[-0.12884449429552464,0.99166481045246857,1.7,0.98408795023868068]
[-0.22720209469308711,0.97384763087819515,1.8,1.0306435137895813]
[-0.32328956686350335,0.94630008768741447,1.9,1.0688565300824022]
[-0.41614683654714241,0.90929742682568171,2,false]
[-0.50484610459985757,0.86320936664887371,2.1,-0.27095511306271625]
[-0.58850111725534582,0.80849640381959009,2.2000000000000002,-0.32540906136855818]
[-0.6662760212798241,0.74570521217672026,2.2999999999999998,-0.38166582572612268]
[-0.73739371554124544,0.67546318055115095,2.4,-0.44011335140094004]
[-0.8011436155469398,0.59847214410394833,2.5000000000000102,-0.50119335423016387]
[-0.85688875336894732,0.51550137182146416,2.6,-0.56541601961010579]
[-0.90407214201706121,0.42737988023382978,2.7,-0.63337879042330225]
[-0.94222234066866151,0.33498815015589545,2.80000000000001,-0.70579078964755759]
[-0.97095816514959299,0.23924932921397249,2.9000000000000101,-0.78350509640013244]
[-0.98999249660044686,0.14112000805985711,3.0000000000000102,-0.8675621228337248]

{"sheet":"Лист3","index":2,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Ф.И.О.","дата рождения","дата поступления на работу","оклад","стаж в днях","стаж в годах","надбавка за стаж","з/п за месяц"]
["Волков Александр Петрович",{"$f":"DATE(1964,5,20)","v":"1964-05-20"},{"$f":"DATE(1988,2,6)","v":"1988-02-06"},39000,{"$f":"DAYS360(C2,DATE(2013,5,1))","v":9085},{"$f":"ROUND(E2/365,1)","v":24.9},{"$f":"IF(F2>15,D2*0.2,IF(F2>10,D2*0.15,IF(F2>5,D2*0.1,IF(F2>3,D2*0.05,0))))","v":7800},{"$f":"D2+G2","v":46800}]
["Грачев Дмитрий Владиславович",{"$f":"DATE(1979,3,16)","v":"1979-03-16"},{"$f":"DATE(1996,2,13)","v":"1996-02-13"},32000,6198,17,6400,38400]
["Дронов Савелий Антонович",{"$f":"DATE(1976,7,1)","v":"1976-07-01"},{"$f":"DATE(2009,9,2)","v":"2009-09-02"},19000,1319,3.6,950,19950]
["Калинин Игорь Анатольевич",{"$f":"DATE(1992,8,29)","v":"1992-08-29"},{"$f":"DATE(2011,2,17)","v":"2011-02-17"},17000,794,2.2000000000000002,0,17000]
["Миронов Константин Алексеевич",{"$f":"DATE(1985,3,6)","v":"1985-03-06"},{"$f":"DATE(2004,5,2)","v":"2004-05-02"},24000,3239,8.9,2400,26400]
["Рогов Гергий Григорьевич",{"$f":"DATE(1983,11,13)","v":"1983-11-13"},{"$f":"DATE(2003,4,6)","v":"2003-04-06"},24000,3625,9.9,2400,26400]