{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Титульный лист","Лист1","Лист2","Лист3","Лист4","Лист5"],"not_rendered":{"charts":3,"images":12,"macros":1,"external_links":0,"defined_names":151,"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":"Титульный лист","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист1","index":1,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[5,0,5,2]]}
["Задача1 (вариант 5)"]
[]
["a","b","y(x)"]
[-1.976,2.052]
[]
["Решение"]
["х","у","Функциональная зависимость"]
[-1.976,{"$f":"IF(ABS(A8)>1,0,0.75*A8+(SIN(A8)/(A8^2-4)))","v":0}]
[-1.7746,0]
[-1.5731999999999999,0]
[-1.3717999999999999,0]
[-1.1704000000000001,0]
[-0.96899999999999997,-0.45745581542453917]
[-0.76759999999999995,{"$f":"IF(ABS(A14)>1,0,0.75*A14+(SIN(A14)/(A14^2-4)))","v":-0.37210781140330951}]
[-0.56620000000000004,-0.2788581925082978]
[-0.36480000000000001,-0.18133991341500344]
[-0.16339999999999999,-8.1608255344923553E-2]
[3.7999999999999798E-2,1.8998856255373831E-2]
[0.2394,0.11940833965514952]
[0.44080000000000003,0.2184882596586111]
[0.64219999999999999,0.31469658136270923]
[0.84360000000000002,0.40552112744934776]
[1.0449999999999999,0]
[1.2464,0]
[1.4478,0]
[1.6492,0]
[1.8506,0]
[2.052,0]

{"sheet":"Лист2","index":2,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,0,4,2],[27,0,27,2],[0,0,0,2],[1,0,1,2],[2,0,2,2]]}
["Задача 2 (вариант 5)"]
[]
[]
[]
["Решение"]
["х","у","Схематичный график функции"]
[-5,{"$f":"A7^4+3*A7^3-4*A7-1","v":269}]
[-4.55,{"$f":"A8^4+3*A8^3-4*A8-1","v":163.20438124999993}]
[-4.0999999999999996,91.213099999999969]
[-3.65,45.207631249999999]
[-3.2,18.353600000000018]
[-2.75,4.80078125]
[-2.3556742949120282,5.9264824159299678E-9]
[-1.85,-0.88136874999999826]
[-1.4772599957216044,2.0656756305470481E-9]
[-0.95,1.04238125]
[-0.26235969299446993,-6.1367060322226052E-9]
[-4.9999999999999802E-2,-0.80036875000000074]
[0.4,-2.3824000000000001]
[1.095294710678721,8.7439018363610899E-6]
[1.3,3.2471000000000023]
[1.75,17.45703125]
[2.2000000000000002,45.569600000000023]
[2.65,93.544381250000001]
[3.1,168.32510000000005]
[3.55,277.83963124999997]
[4,431]
["Примечание: в ячейках жёлтого цвета найдены корни уравнения f(x)=0"]

{"sheet":"Лист3","index":3,"n_rows":28,"n_cols":23,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,0,4,22],[5,2,5,22],[7,0,27,0],[0,0,0,22],[1,0,1,22],[2,0,2,22]]}
["Задача3 (вариант5)"]
[]
[]
[]
["Решение"]
[null,null,"Ось Ох"]
[null,null,-1,-0.9,-0.8,-0.7,-0.6,-0.5,-0.4,-0.3,-0.2,-0.1,0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1]
["Ось Оу",-1,{"$f":"IF(C$7<=0,C$7*SIN(PI()*$B8)^2,IF(C$7>0,$B8*SIN(PI()*C$7)))","v":-1.5009887365649789E-32},{"$f":"IF(D$7<=0,D$7*SIN(PI()*$B8)^2,IF(D$7>0,$B8*SIN(PI()*D$7)))","v":-1.350889862908481E-32},{"$f":"IF(E$7<=0,E$7*SIN(PI()*$B8)^2,IF(E$7>0,$B8*SIN(PI()*E$7)))","v":-1.2007909892519831E-32},-1.0506921155954852E-32,-9.0059324193898735E-33,-7.5049436828248946E-33,-6.0039549462599157E-33,-4.5029662096949368E-33,-3.0019774731299578E-33,-1.5009887365649789E-33,0,-0.3090169943749474,-0.58778525229247314,-0.80901699437494745,-0.95105651629515353,-1,-0.95105651629515364,-0.80901699437494745,-0.58778525229247325,-0.30901699437494751,-1.22514845490862E-16]
[null,-0.9,{"$f":"IF(C$7<=0,C$7*SIN(PI()*$B9)^2,IF(C$7>0,$B9*SIN(PI()*C$7)))","v":-9.5491502812526344E-2},{"$f":"IF(D$7<=0,D$7*SIN(PI()*$B9)^2,IF(D$7>0,$B9*SIN(PI()*D$7)))","v":-8.5942352531273705E-2},-7.6393202250021081E-2,-6.6844051968768442E-2,-5.7294901687515803E-2,-4.7745751406263172E-2,-3.819660112501054E-2,-2.8647450843757902E-2,-1.909830056250527E-2,-9.5491502812526351E-3,0,-0.27811529493745268,-0.52900672706322582,-0.72811529493745275,-0.85595086466563819,-0.9,-0.8559508646656383,-0.72811529493745275,-0.52900672706322593,-0.27811529493745274,-1.102633609417758E-16]
[null,-0.8,-0.34549150281252644,-0.31094235253127378,-0.27639320225002117,-0.24184405196876849,-0.20729490168751585,-0.17274575140626322,-0.13819660112501059,-0.10364745084375793,-6.9098300562505294E-2,-3.4549150281252647E-2,0,-0.24721359549995792,-0.47022820183397851,-0.64721359549995805,-0.76084521303612285,-0.8,-0.76084521303612296,-0.64721359549995805,-0.47022820183397862,-0.24721359549995803,-9.8011876392689601E-17]
[null,-0.7,-0.65450849718747373,-0.58905764746872635,-0.52360679774997898,-0.45815594803123155,-0.39270509831248424,-0.32725424859373686,-0.26180339887498949,-0.19635254915624212,-0.13090169943749475,-6.5450849718747373E-2,0,-0.21631189606246318,-0.4114496766047312,-0.56631189606246313,-0.66573956140660739,-0.7,-0.66573956140660751,-0.56631189606246313,-0.41144967660473125,-0.21631189606246323,-8.5760391843603401E-17]
[null,-0.6,-0.90450849718747384,-0.81405764746872644,-0.72360679774997916,-0.63315594803123165,-0.54270509831248426,-0.45225424859373692,-0.36180339887498958,-0.27135254915624213,-0.18090169943749479,-9.0450849718747395E-2,0,-0.18541019662496844,-0.35267115137548388,-0.48541019662496843,-0.57063390977709205,-0.6,-0.57063390977709216,-0.48541019662496843,-0.35267115137548394,-0.18541019662496849,-7.3508907294517201E-17]
[null,-0.5,-1,-0.9,-0.8,-0.7,-0.6,-0.5,-0.4,-0.3,-0.2,-0.1,0,-0.1545084971874737,-0.29389262614623657,-0.40450849718747373,-0.47552825814757677,-0.5,-0.47552825814757682,-0.40450849718747373,-0.29389262614623662,-0.15450849718747375,-6.1257422745431001E-17]
[null,-0.4,-0.90450849718747361,-0.81405764746872622,-0.72360679774997894,-0.63315594803123154,-0.54270509831248415,-0.45225424859373681,-0.36180339887498947,-0.27135254915624207,-0.18090169943749473,-9.0450849718747367E-2,0,-0.12360679774997896,-0.23511410091698925,-0.32360679774997902,-0.38042260651806142,-0.4,-0.38042260651806148,-0.32360679774997902,-0.23511410091698931,-0.12360679774997901,-4.90059381963448E-17]
[null,-0.3,-0.65450849718747373,-0.58905764746872635,-0.52360679774997898,-0.45815594803123155,-0.39270509831248424,-0.32725424859373686,-0.26180339887498949,-0.19635254915624212,-0.13090169943749475,-6.5450849718747373E-2,0,-9.2705098312484219E-2,-0.17633557568774194,-0.24270509831248421,-0.28531695488854603,-0.3,-0.28531695488854608,-0.24270509831248421,-0.17633557568774197,-9.2705098312484246E-2,-3.67544536472586E-17]
[null,-0.2,-0.34549150281252627,-0.31094235253127367,-0.27639320225002101,-0.24184405196876838,-0.20729490168751577,-0.17274575140626314,-0.1381966011250105,-0.10364745084375789,-6.9098300562505252E-2,-3.4549150281252626E-2,0,-6.1803398874989479E-2,-0.11755705045849463,-0.16180339887498951,-0.19021130325903071,-0.2,-0.19021130325903074,-0.16180339887498951,-0.11755705045849466,-6.1803398874989507E-2,-2.45029690981724E-17]
[null,-0.1,-9.5491502812526274E-2,-8.594235253127365E-2,-7.6393202250021025E-2,-6.6844051968768387E-2,-5.7294901687515762E-2,-4.7745751406263137E-2,-3.8196601125010513E-2,-2.8647450843757881E-2,-1.9098300562505256E-2,-9.5491502812526281E-3,0,-3.090169943749474E-2,-5.8778525229247314E-2,-8.0901699437494756E-2,-9.5105651629515356E-2,-0.1,-9.510565162951537E-2,-8.0901699437494756E-2,-5.8778525229247328E-2,-3.0901699437494753E-2,-1.22514845490862E-17]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0.1,-9.5491502812526274E-2,-8.594235253127365E-2,-7.6393202250021025E-2,-6.6844051968768387E-2,-5.7294901687515762E-2,-4.7745751406263137E-2,-3.8196601125010513E-2,-2.8647450843757881E-2,-1.9098300562505256E-2,-9.5491502812526281E-3,0,3.090169943749474E-2,5.8778525229247314E-2,8.0901699437494756E-2,9.5105651629515356E-2,0.1,9.510565162951537E-2,8.0901699437494756E-2,5.8778525229247328E-2,3.0901699437494753E-2,1.22514845490862E-17]
[null,0.2,-0.34549150281252627,-0.31094235253127367,-0.27639320225002101,-0.24184405196876838,-0.20729490168751577,-0.17274575140626314,-0.1381966011250105,-0.10364745084375789,-6.9098300562505252E-2,-3.4549150281252626E-2,0,6.1803398874989479E-2,0.11755705045849463,0.16180339887498951,0.19021130325903071,0.2,0.19021130325903074,0.16180339887498951,0.11755705045849466,6.1803398874989507E-2,2.45029690981724E-17]
[null,0.3,-0.65450849718747373,-0.58905764746872635,-0.52360679774997898,-0.45815594803123155,-0.39270509831248424,-0.32725424859373686,-0.26180339887498949,-0.19635254915624212,-0.13090169943749475,-6.5450849718747373E-2,0,{"$f":"IF(N$7<=0,N$7*SIN(PI()*$B21)^2,IF(N$7>0,$B21*SIN(PI()*N$7)))","v":9.2705098312484219E-2},0.17633557568774194,0.24270509831248421,0.28531695488854603,0.3,0.28531695488854608,0.24270509831248421,0.17633557568774197,9.2705098312484246E-2,3.67544536472586E-17]
[null,0.4,-0.90450849718747361,-0.81405764746872622,-0.72360679774997894,-0.63315594803123154,-0.54270509831248415,-0.45225424859373681,-0.36180339887498947,-0.27135254915624207,-0.18090169943749473,-9.0450849718747367E-2,0,0.12360679774997896,0.23511410091698925,0.32360679774997902,0.38042260651806142,0.4,0.38042260651806148,0.32360679774997902,0.23511410091698931,0.12360679774997901,4.90059381963448E-17]
[null,0.5,-1,-0.9,-0.8,-0.7,-0.6,-0.5,-0.4,-0.3,-0.2,-0.1,0,0.1545084971874737,0.29389262614623657,0.40450849718747373,0.47552825814757677,0.5,0.47552825814757682,0.40450849718747373,0.29389262614623662,0.15450849718747375,6.1257422745431001E-17]
[null,0.6,-0.90450849718747384,-0.81405764746872644,-0.72360679774997916,-0.63315594803123165,-0.54270509831248426,-0.45225424859373692,-0.36180339887498958,-0.27135254915624213,-0.18090169943749479,-9.0450849718747395E-2,0,0.18541019662496844,0.35267115137548388,0.48541019662496843,0.57063390977709205,0.6,0.57063390977709216,0.48541019662496843,0.35267115137548394,0.18541019662496849,7.3508907294517201E-17]
[null,0.7,-0.65450849718747373,-0.58905764746872635,-0.52360679774997898,-0.45815594803123155,-0.39270509831248424,-0.32725424859373686,-0.26180339887498949,-0.19635254915624212,-0.13090169943749475,-6.5450849718747373E-2,0,0.21631189606246318,0.4114496766047312,0.56631189606246313,0.66573956140660739,0.7,0.66573956140660751,0.56631189606246313,0.41144967660473125,0.21631189606246323,8.5760391843603401E-17]
[null,0.8,-0.34549150281252644,-0.31094235253127378,-0.27639320225002117,-0.24184405196876849,-0.20729490168751585,-0.17274575140626322,-0.13819660112501059,-0.10364745084375793,-6.9098300562505294E-2,-3.4549150281252647E-2,0,0.24721359549995792,0.47022820183397851,0.64721359549995805,0.76084521303612285,0.8,0.76084521303612296,0.64721359549995805,0.47022820183397862,0.24721359549995803,9.8011876392689601E-17]
[null,0.9,-9.5491502812526344E-2,-8.5942352531273705E-2,-7.6393202250021081E-2,-6.6844051968768442E-2,-5.7294901687515803E-2,-4.7745751406263172E-2,-3.819660112501054E-2,-2.8647450843757902E-2,-1.909830056250527E-2,-9.5491502812526351E-3,0,0.27811529493745268,0.52900672706322582,0.72811529493745275,0.85595086466563819,0.9,0.8559508646656383,0.72811529493745275,0.52900672706322593,0.27811529493745274,1.102633609417758E-16]
[null,1,-1.5009887365649789E-32,-1.350889862908481E-32,-1.2007909892519831E-32,-1.0506921155954852E-32,-9.0059324193898735E-33,-7.5049436828248946E-33,-6.0039549462599157E-33,-4.5029662096949368E-33,-3.0019774731299578E-33,-1.5009887365649789E-33,0,0.3090169943749474,0.58778525229247314,0.80901699437494745,0.95105651629515353,1,0.95105651629515364,0.80901699437494745,0.58778525229247325,0.30901699437494751,1.22514845490862E-16]

{"sheet":"Лист4","index":4,"n_rows":19,"n_cols":17,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,13,17,16],[18,13,18,16],[5,13,5,16],[6,13,6,16],[7,13,7,16],[0,0,0,16],[1,0,1,16],[16,3,16,12],[8,13,15,13],[5,11,5,12],[6,11,6,12],[3,0,3,16],[6,3,6,4],[6,5,6,6],[5,7,5,8],[4,13,4,16],[16,13,16,16],[17,0,18,2],[4,0,7,2],[4,3,4,11],[5,5,5,6],[5,3,5,4],[6,7,6,8],[5,9,5,10],[8,0,15,0],[16,0,16,1],[6,9,6,10]]}
["Задача 4 (вариант 5)"]
[]
[]
["Решение"]
[null,null,null,"Склады"]
[null,null,null,"S1",null,"S2",null,"S3",null,"S4",null,"S5",null,"Всего"]
[null,null,null,150,null,220,null,340,null,180,null,200,null,1090]
[null,null,null,"План","Цена 1 т.","План","Цена 1 т.","План","Цена 1 т.","План","Цена 1 т.","План","Цена 1 т."]
["Предприятия","P1",110,0,24,0,20,0,16,0,18,0,20,"Итого по предприятиям","Всего,тонн",null,{"$f":"D9+F9+H9+J9+L9","v":0}]
[null,"P2",90,0,16,0,14,0,13,0,13,0,15,null,"Всего,тонн",null,{"$f":"D10+F10+H10+J10+L10","v":0}]
[null,"P3",150,0,13,0,14,0,19,0,11,0,18,null,"Всего,тонн",null,0]
[null,"P4",105,50,11,0,13,0,15,0,11,0,13,null,"Всего,тонн",null,50]
[null,"P5",115,50,11,0,20,0,12,180,10,0,18,null,"Всего,тонн",null,230]
[null,"P6",175,0,18,143,10,340,10,0,17,0,13,null,"Всего,тонн",null,483]
[null,"P7",160,0,18,0,11,0,13,0,16,200,11,null,"Всего,тонн",null,200]
[null,"P8",185,50,11,76.999999000000003,10,0,20,0,11,0,16,null,"Всего,тонн",null,126.999999]
["Всего",null,1090,"Итого по складам"]
[null,null,null,"Всего,\nтонн\n","Всего,\nстоимость\n","Всего,\nтонн\n","Всего,\nстоимость\n","Всего,\nтонн\n","Всего,\nстоимость\n","Всего,\nтонн\n","Всего,\nстоимость\n","Всего,\nтонн\n","Всего,\nстоимость\n","Общая\nстоимость\nперевозок\n"]
[null,null,null,{"$f":"SUM(D9:D16)","v":150},{"$f":"SUMPRODUCT(D9:D16,E9:E16)","v":1650},{"$f":"SUM(F9:F16)","v":219.999999},{"$f":"SUMPRODUCT(F9:F16,G9:G16)","v":2199.9999900000003},{"$f":"SUM(H9:H16)","v":340},{"$f":"SUMPRODUCT(H9:H16,I9:I16)","v":3400},{"$f":"SUM(J9:J16)","v":180},{"$f":"SUMPRODUCT(J9:J16,K9:K16)","v":1800},{"$f":"SUM(L9:L16)","v":200},{"$f":"SUMPRODUCT(L9:L16,M9:M16)","v":2200},{"$f":"E19+G19+I19+K19+M19","v":11249.99999}]

{"sheet":"Лист5","index":5,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[0,0,0,12],[1,0,1,12],[3,0,3,12],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12]]}
["Задача 5 (вариант 5)"]
[]
[]
["Решение"]
[null,null,null,null,"Виды сырья","С1",null,"С2",null,"С3",null,"С4"]
[null,null,null,null,"Запасы сырья",210,null,160,null,185,null,190]
["Виды продукции","Доходы от реализации 1 единицы продукции","Доходы от реализации продукции","Количество произведённой продукции",null,"Затраты сырья 1-го типа для производства продукции","Затраты сырья 1-го типа для производства 1 единицы продукции","Затраты сырья 2-го типа для производства продукции","Затраты сырья 2-го типа для производства 1 единицы продукции","Затраты сырья 3-го типа для производства продукции","Затраты сырья 3-го типа для производства 1 единицы продукции","Затраты сырья 4-го типа для производства продукции","Затраты сырья 4-го типа для производства 1 единицы продукции"]
["П1",90,{"$f":"B8*D8","v":0},0,null,{"$f":"D8*G8","v":0},9,{"$f":"D8*I8","v":0},8,{"$f":"D8*K8","v":0},7,{"$f":"D8*M8","v":0},6]
["П2",110,{"$f":"B9*D9","v":2200},20,null,{"$f":"D9*G9","v":100},5,{"$f":"D9*I9","v":160},8,{"$f":"D9*K9","v":180},9,{"$f":"D9*M9","v":120},6]
["П3",130,{"$f":"B10*D10","v":0},0,null,{"$f":"D10*G10","v":0},12,{"$f":"D10*I10","v":0},10,{"$f":"D10*K10","v":0},11,{"$f":"D10*M10","v":0},9]
[]
[null,"Суммарный доход",{"$f":"SUM(C8:C10)","v":2200},null,"Суммарные затраты сырья 1-го типа для производства продукции",{"$f":"SUM(F8:F10)","v":100},"Суммарные затраты сырья 2-го типа для производства продукции",{"$f":"SUM(H8:H10)","v":160},"Суммарные затраты сырья 3-го типа для производства продукции",{"$f":"SUM(J8:J10)","v":180},"Суммарные затраты сырья 4-го типа для производства продукции",{"$f":"SUM(L8:L10)","v":120}]