{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["инструкция","Лист2","варианты.111 - 117; Заоч","варианты 311 - 313; 281;451;21;","задание","Лист3","Лист1"],"not_rendered":{"charts":0,"images":1,"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":"инструкция","index":0,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[26,3,26,5],[18,0,18,6],[19,0,19,5],[21,2,21,5],[23,0,23,6],[24,0,24,6],[3,0,3,12],[27,7,29,14],[2,0,2,12],[10,0,10,12],[11,0,11,12],[12,0,12,12],[14,0,14,12],[15,0,15,12],[16,0,16,12],[4,0,4,12],[5,0,5,12],[6,0,6,12],[7,0,7,12],[8,0,8,12],[9,0,9,12],[26,0,26,1]]}
[]
[]
["Порядок решения задачи."]
[" После скачивания тренажера, если появится надпись, \"Запуск активного содержимого отключен.\" нажмите кнопку \"Включить содержимое\"."]
["1. На листе «варианты гр.» найта таблицу своей группы и свой номер по журналу. Записать в тетради параметры и их величины своего варианта задачи. "]
["2. На листе «Задание» ввести № своей группы, фамилию, имя и отчество."]
["3. В таблицу «Условие задачи», в столбик «Величина», введите численные значения своих параметров задачи."]
["4. В тетради начертите схему последовательного соединения резисторов. Письменно решайте задачу в строгом соответствии с алгоритмом решения задачи."]
["5. Результат каждого действия вводите в таблицу «Результаты решения задачи» в столбик «Полученный результат» в строгом соответствии с порядком действий по алгоритму решения."]
["6. Если действие решено правильно, Вы получите подтверждение «Верно»"]
["7. Обратите внимание на разрядность чисел, округляйте их по законам математики  учитывая, что: величина напряжения и сопротивления округляется до сотых включительно; величина тока до тысячных включительно; "]
["8. При дистанционном обучении теоретический материал изучить по \"Методическое пособие по расчету последовательного, параллельного и смешанного соединений», расположенному на сайте «Образовательная социальная сеть nsportal.ru» с фамилией, именем и отчеством преподавателя."]
["9.  Результаты решения с листа «Задание» сделать принтскрин, «Решение задачи по последовательному соединению»,  начерченные схемы и письменное решение отсканировать и прислать мне на почту: naukatvor@yandex.ru "]
[]
["В письме обязательно писать свою фамилию, № группы, электронную почту. Обезличенные работы не принимаются."]
["Пример содержания ответа преподавателю."]
["Начерченные схемы и письменное решение, компьютерные результаты решения."]
[]
["Решение задачи по последовательному соединению"]
["Заполнить данные: группа № , Фамилия И.О., вариант №."]
[null,"Группа","№"," 222"]
[null,"Фамилия И.О."," Иванов Иван Иванович "]
[]
["      Выполнить расчет последовательного соединения резисторов и определить величину падения напряжений на каждом участке цепи. Начертить схему последовательного соединения резисторов, в которой: R1, Ом; R2, Ом; R3, Ом; R4, Ом; R5, Ом; "]
["и Uпит, В."]
[]
["Условие задачи.",null,null,"Результаты решения задачи."]
["Вариант №",1,null,"Дествие №","Полученный результат","Верно / ложь",null,"Для определения времени вычислений, после ввода данных нажмите кнопку \"Начать расчёт\". После ввода каждого результата, нажмите кнопку \"Начать расчёт\".      После ввода последнего результата нажмите кнопку        \"Я решил! Таким образом Вы узнаете своё время решения задачи. На оценку это время не влияет."]
["Параметр","Величина.",null,1,1496,"Верно"]
["R1; Ом",325,null,2,0.154,"Верно"]
["R2; Ом",96,null,3,50.05,"Верно"]
["R3; Ом",465,null,4,14.78,"Верно"]
["R4; Ом",47,null,5,71.61,"Верно"]
["R5; Ом",563,null,6,7.24,"Верно"]
["U; В",230,null,7,86.7,"Верно"]
[null,null,null,8]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"варианты.111 - 117; Заоч","index":2,"n_rows":104,"n_cols":23,"rows_kept":104,"cut":false,"hidden":false,"merged":[[37,17,37,22],[3,17,3,22],[71,1,71,6],[71,9,71,14],[3,1,3,6],[3,9,3,14],[37,1,37,6],[37,9,37,14]]}
[]
[]
[]
["гр. 111","Параметры вариантов задач.",null,null,null,null,null,null,"гр. 112","Параметры вариантов задач.",null,null,null,null,null,null,"гр. 113","Параметры вариантов задач."]
["Вариант №","R1","R2","R3","R4","R5","U",null,"Вариант №","R1","R2","R3","R4","R5","U",null,"Вариант №","R1","R2","R3","R4","R5","U"]
[1,123,360,291,168,302,210,null,1,483,270,665,141,302,255,null,1,259,360,255,207,302,60]
[{"$f":"A6+1","v":2},449,"330",171,604,110,211,null,{"$f":"I6+1","v":2},560,630,233,126,110,213,null,{"$f":"Q6+1","v":2},465,"330",70,522,110,309]
[{"$f":"A7+1","v":3},76,491,259,293,151,140,null,{"$f":"I7+1","v":3},273,365,114,195,151,116,null,{"$f":"Q7+1","v":3},262,491,251,741,151,76]
[4,211,98,263,464,407,129,null,4,506,556,260,302,407,422,null,4,210,98,740,766,407,168]
[5,445,415,388,577,372,257,null,5,236,652,747,417,372,657,null,5,798,415,417,282,372,287]
[6,178,472,384,750,421,341,null,6,592,192,203,95,421,738,null,6,111,472,214,739,421,115]
[7,372,456,248,799,111,220,null,7,188,313,493,299,111,537,null,7,311,456,292,286,111,220]
[8,413,141,223,656,100,211,null,8,489,305,154,177,100,509,null,8,141,141,712,141,100,59]
[9,111,244,244,407,148,104,null,9,125,518,561,68,148,173,null,9,232,244,546,193,148,341]
[10,366,338,158,456,140,432,null,10,315,418,245,273,140,324,null,10,99,338,564,751,140,308]
[11,268,259,191,796,257,123,null,11,750,281,318,302,257,740,null,11,750,259,281,167,257,135]
[12,476,482,74,427,62,60,null,12,161,540,93,61,62,497,null,12,473,482,242,681,62,74]
[13,280,217,434,220,206,473,null,13,93,272,540,373,206,251,null,13,438,217,657,284,206,344]
[14,115,227,338,188,162,400,null,14,751,196,462,190,162,588,null,14,482,227,310,692,162,368]
[15,247,203,87,764,293,249,null,15,102,439,614,477,293,340,null,15,235,203,56,720,293,237]
[16,230,107,228,684,315,399,null,16,656,574,150,132,315,308,null,16,704,107,313,193,315,95]
[17,152,205,265,304,405,143,null,17,203,307,384,452,405,123,null,17,364,205,160,306,405,336]
[18,468,61,281,621,367,423,null,18,305,520,778,66,367,198,null,18,245,61,247,83,367,224]
[19,303,138,401,722,199,168,null,19,393,614,610,165,199,140,null,19,590,138,359,591,199,294]
[20,343,460,266,363,387,330,null,20,236,486,123,317,387,152,null,20,779,460,154,439,387,254]
[21,474,487,54,716,288,222,null,21,669,209,108,111,288,299,null,21,209,487,390,503,288,128]
[22,405,61,316,520,478,478,null,22,249,208,502,208,478,405,null,22,139,61,746,161,478,163]
[23,416,209,301,445,464,59,null,23,630,119,128,96,464,246,null,23,160,209,448,639,464,174]
[24,365,108,428,152,112,53,null,24,434,666,161,71,112,257,null,24,336,108,726,667,112,191]
[25,343,329,109,116,274,458,null,25,320,751,324,297,274,379,null,25,774,329,411,761,274,375]
[26,438,206,91,100,327,277,null,26,189,538,319,274,327,165,null,26,77,206,776,332,327,83]
[27,71,402,407,799,287,54,null,27,284,623,359,497,287,184,null,27,182,402,252,351,287,173]
[28,400,329,373,560,467,360,null,28,787,709,585,282,467,598,null,28,79,329,249,664,467,152]
[29,484,126,328,641,133,81,null,29,469,157,573,364,133,91,null,29,557,126,476,443,133,181]
[30,261,470,248,264,180,194,null,30,449,138,619,425,180,755,null,30,264,470,155,588,180,113]
[31,340,114,163,521,474,500,null,31,759,230,141,106,474,180,null,31,545,114,255,94,474,353]
[]
["гр. 114","Параметры вариантов задач.",null,null,null,null,null,null,"гр. 115","Параметры вариантов задач.",null,null,null,null,null,null,"Заочники","Параметры вариантов задач."]
["Вариант №","R1","R2","R3","R4","R5","U",null,"Вариант №","R1","R2","R3","R4","R5","U",null,"Вариант №","R1","R2","R3","R4","R5","U"]
[1,206,360,291,374,302,61,null,1,364,360,255,207,302,60,null,1,123,360,291,168,302,210]
[{"$f":"A40+1","v":2},677,"330",171,360,110,77,null,{"$f":"I40+1","v":2},245,"330",70,522,110,309,null,{"$f":"Q40+1","v":2},449,"330",171,604,110,211]
[{"$f":"A41+1","v":3},563,491,259,313,151,294,null,{"$f":"I41+1","v":3},590,491,251,741,151,76,null,{"$f":"Q41+1","v":3},76,491,259,293,151,140]
[4,225,98,263,519,407,206,null,4,779,98,740,766,407,168,null,4,211,98,263,464,407,129]
[5,589,415,388,213,372,220,null,5,209,415,417,282,372,287,null,5,445,415,388,577,372,257]
[6,383,472,384,691,421,340,null,6,139,472,214,739,421,115,null,6,178,472,384,750,421,341]
[7,588,456,248,149,111,224,null,7,160,456,292,286,111,220,null,7,372,456,248,799,111,220]
[8,628,141,223,343,100,289,null,8,336,141,712,141,100,59,null,8,413,141,223,656,100,211]
[9,483,244,244,798,148,345,null,9,774,244,546,193,148,341,null,9,111,244,244,407,148,104]
[10,343,338,158,74,140,257,null,10,77,338,564,751,140,308,null,10,366,338,158,456,140,432]
[11,162,259,191,397,257,104,null,11,182,259,281,167,257,135,null,11,268,259,191,796,257,123]
[12,202,482,74,567,62,262,null,12,79,482,242,681,62,74,null,12,476,482,74,427,62,60]
[13,101,217,434,96,206,58,null,13,557,217,657,284,206,344,null,13,280,217,434,220,206,473]
[14,734,227,338,83,162,212,null,14,264,227,310,692,162,368,null,14,115,227,338,188,162,400]
[15,511,203,87,244,293,110,null,15,545,203,56,720,293,237,null,15,247,203,87,764,293,249]
[16,500,107,228,125,315,271,null,16,259,107,313,193,315,95,null,16,230,107,228,684,315,399]
[17,599,205,265,441,405,88,null,17,465,205,160,306,405,336,null,17,152,205,265,304,405,143]
[18,649,61,281,587,367,181,null,18,262,61,247,83,367,224,null,18,468,61,281,621,367,423]
[19,522,138,401,443,199,103,null,19,210,138,359,591,199,294,null,19,303,138,401,722,199,168]
[20,524,460,266,667,387,243,null,20,798,460,154,439,387,254,null,20,343,460,266,363,387,330]
[21,570,487,54,477,288,168,null,21,111,487,390,503,288,128,null,21,474,487,54,716,288,222]
[22,227,61,316,763,478,86,null,22,311,61,746,161,478,163,null,22,405,61,316,520,478,478]
[23,232,209,301,168,464,147,null,23,141,209,448,639,464,174,null,23,416,209,301,445,464,59]
[24,540,108,428,762,112,233,null,24,232,108,726,667,112,191,null,24,365,108,428,152,112,53]
[25,152,329,109,260,274,220,null,25,99,329,411,761,274,375,null,25,343,329,109,116,274,458]
[26,282,206,91,680,327,195,null,26,750,206,776,332,327,83,null,26,438,206,91,100,327,277]
[27,76,402,407,565,287,170,null,27,473,402,252,351,287,173,null,27,71,402,407,799,287,54]
[28,648,329,373,251,467,349,null,28,438,329,249,664,467,152,null,28,400,329,373,560,467,360]
[29,439,126,328,353,133,379,null,29,482,126,476,443,133,181,null,29,484,126,328,641,133,81]
[30,86,470,248,736,180,107,null,30,235,470,155,588,180,113,null,30,261,470,248,264,180,194]
[31,413,114,163,409,474,262,null,31,704,114,255,94,474,353,null,31,340,114,163,521,474,500]
[]
["гр. 116","Параметры вариантов задач.",null,null,null,null,null,null,"гр. 117","Параметры вариантов задач."]
["Вариант №","R1","R2","R3","R4","R5","U",null,"Вариант №","R1","R2","R3","R4","R5","U"]
[1,230,360,291,168,302,210,null,1,483,270,665,141,302,308]
[{"$f":"A74+1","v":2},152,"330",171,604,110,211,null,{"$f":"I74+1","v":2},560,630,233,126,110,123]
[{"$f":"A75+1","v":3},468,491,259,293,151,140,null,{"$f":"I75+1","v":3},273,365,114,195,151,198]
[4,303,98,263,464,407,129,null,4,506,556,260,302,407,140]
[5,343,415,388,577,372,257,null,5,236,652,747,417,372,152]
[6,474,472,384,750,421,341,null,6,592,192,203,95,421,299]
[7,405,456,248,799,111,220,null,7,188,313,493,299,111,405]
[8,416,141,223,656,100,211,null,8,489,305,154,177,100,246]
[9,365,244,244,407,148,104,null,9,125,518,561,68,148,257]
[10,343,338,158,456,140,432,null,10,315,418,245,273,140,379]
[11,438,259,191,796,257,123,null,11,750,281,318,302,257,165]
[12,71,482,74,427,62,60,null,12,161,540,93,61,62,184]
[13,400,217,434,220,206,473,null,13,93,272,540,373,206,598]
[14,484,227,338,188,162,400,null,14,751,196,462,190,162,91]
[15,261,203,87,764,293,249,null,15,102,439,614,477,293,755]
[16,340,107,228,684,315,399,null,16,656,574,150,132,315,180]
[17,123,205,265,304,405,143,null,17,203,307,384,452,405,255]
[18,449,61,281,621,367,423,null,18,305,520,778,66,367,213]
[19,76,138,401,722,199,168,null,19,393,614,610,165,199,116]
[20,211,460,266,363,387,330,null,20,236,486,123,317,387,422]
[21,445,487,54,716,288,222,null,21,669,209,108,111,288,657]
[22,178,61,316,520,478,478,null,22,249,208,502,208,478,738]
[23,372,209,301,445,464,59,null,23,630,119,128,96,464,537]
[24,413,108,428,152,112,53,null,24,434,666,161,71,112,509]
[25,111,329,109,116,274,458,null,25,320,751,324,297,274,173]
[26,366,206,91,100,327,277,null,26,189,538,319,274,327,324]
[27,268,402,407,799,287,54,null,27,284,623,359,497,287,740]
[28,476,329,373,560,467,360,null,28,787,709,585,282,467,497]
[29,280,126,328,641,133,81,null,29,469,157,573,364,133,251]
[30,115,470,248,264,180,194,null,30,449,138,619,425,180,588]
[31,247,114,163,521,474,500,null,31,759,230,141,106,474,340]

{"sheet":"варианты 311 - 313; 281;451;21;","index":3,"n_rows":69,"n_cols":23,"rows_kept":69,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,14],[36,1,36,6],[36,9,36,14],[1,17,1,22],[36,17,36,22]]}
[]
["гр. 281","Параметры вариантов задач.",null,null,null,null,null,null,"гр. 311","Параметры вариантов задач.",null,null,null,null,null,null,"гр. 312","Параметры вариантов задач."]
["Вариант №","R1","R2","R3","R4","R5","U",null,"Вариант №","R1","R2","R3","R4","R5","U",null,"Вариант №","R1","R2","R3","R4","R5","U"]
[1,259,360,255,207,302,60,null,1,206,360,291,374,302,61,null,1,704,360,255,207,302,60]
[{"$f":"A4+1","v":2},465,"330",70,522,110,309,null,{"$f":"I4+1","v":2},677,"330",171,360,110,77,null,{"$f":"Q4+1","v":2},364,"330",70,522,110,309]
[{"$f":"A5+1","v":3},262,491,251,741,151,76,null,{"$f":"I5+1","v":3},563,491,259,313,151,294,null,{"$f":"Q5+1","v":3},245,491,251,741,151,76]
[4,210,98,740,766,407,168,null,4,225,98,263,519,407,206,null,4,590,98,740,766,407,168]
[5,798,415,417,282,372,287,null,5,589,415,388,213,372,220,null,5,779,415,417,282,372,287]
[6,111,472,214,739,421,115,null,6,383,472,384,691,421,340,null,6,209,472,214,739,421,115]
[7,311,456,292,286,111,220,null,7,588,456,248,149,111,224,null,7,139,456,292,286,111,220]
[8,141,141,712,141,100,59,null,8,628,141,223,343,100,289,null,8,160,141,712,141,100,59]
[9,232,244,546,193,148,341,null,9,483,244,244,798,148,345,null,9,336,244,546,193,148,341]
[10,99,338,564,751,140,308,null,10,343,338,158,74,140,257,null,10,774,338,564,751,140,308]
[11,750,259,281,167,257,135,null,11,162,259,191,397,257,104,null,11,77,259,281,167,257,135]
[12,473,482,242,681,62,74,null,12,202,482,74,567,62,262,null,12,182,482,242,681,62,74]
[13,438,217,657,284,206,344,null,13,101,217,434,96,206,58,null,13,79,217,657,284,206,344]
[14,482,227,310,692,162,368,null,14,734,227,338,83,162,212,null,14,557,227,310,692,162,368]
[15,235,203,56,720,293,237,null,15,511,203,87,244,293,110,null,15,264,203,56,720,293,237]
[16,704,107,313,193,315,95,null,16,500,107,228,125,315,271,null,16,545,107,313,193,315,95]
[17,364,205,160,306,405,336,null,17,599,205,265,441,405,88,null,17,259,205,160,306,405,336]
[18,245,61,247,83,367,224,null,18,649,61,281,587,367,181,null,18,465,61,247,83,367,224]
[19,590,138,359,591,199,294,null,19,522,138,401,443,199,103,null,19,262,138,359,591,199,294]
[20,779,460,154,439,387,254,null,20,524,460,266,667,387,243,null,20,210,460,154,439,387,254]
[21,209,487,390,503,288,128,null,21,570,487,54,477,288,168,null,21,798,487,390,503,288,128]
[22,139,61,746,161,478,163,null,22,227,61,316,763,478,86,null,22,111,61,746,161,478,163]
[23,160,209,448,639,464,174,null,23,232,209,301,168,464,147,null,23,311,209,448,639,464,174]
[24,336,108,726,667,112,191,null,24,540,108,428,762,112,233,null,24,141,108,726,667,112,191]
[25,774,329,411,761,274,375,null,25,152,329,109,260,274,220,null,25,232,329,411,761,274,375]
[26,77,206,776,332,327,83,null,26,282,206,91,680,327,195,null,26,99,206,776,332,327,83]
[27,182,402,252,351,287,173,null,27,76,402,407,565,287,170,null,27,750,402,252,351,287,173]
[28,79,329,249,664,467,152,null,28,648,329,373,251,467,349,null,28,473,329,249,664,467,152]
[29,557,126,476,443,133,181,null,29,439,126,328,353,133,379,null,29,438,126,476,443,133,181]
[30,264,470,155,588,180,113,null,30,86,470,248,736,180,107,null,30,482,470,155,588,180,113]
[31,545,114,255,94,474,353,null,31,413,114,163,409,474,262,null,31,235,114,255,94,474,353]
[]
[]
["гр. 21","Параметры вариантов задач.",null,null,null,null,null,null,20,"Параметры вариантов задач.",null,null,null,null,null,null,"гр. 451","Параметры вариантов задач."]
["Вариант №","R1","R2","R3","R4","R5","U",null,"Вариант №","R1","R2","R3","R4","R5","U",null,"Вариант №","R1","R2","R3","R4","R5","U"]
[1,123,360,291,168,302,210,null,1,483,270,665,141,302,255,null,1,483,574,665,141,302,255]
[{"$f":"A39+1","v":2},449,"330",171,604,110,211,null,{"$f":"I39+1","v":2},560,630,233,126,110,213,null,{"$f":"Q39+1","v":2},560,307,233,126,110,213]
[{"$f":"A40+1","v":3},76,491,259,293,151,140,null,{"$f":"I40+1","v":3},273,365,114,195,151,116,null,{"$f":"Q40+1","v":3},273,520,114,195,151,116]
[4,211,98,263,464,407,129,null,4,506,556,260,302,407,422,null,4,506,614,260,302,407,422]
[5,445,415,388,577,372,257,null,5,236,652,747,417,372,657,null,5,236,486,747,417,372,657]
[6,178,472,384,750,421,341,null,6,592,192,203,95,421,738,null,6,592,209,203,95,421,738]
[7,372,456,248,799,111,220,null,7,188,313,493,299,111,537,null,7,188,208,493,299,111,537]
[8,413,141,223,656,100,211,null,8,489,305,154,177,100,509,null,8,489,119,154,177,100,509]
[9,111,244,244,407,148,104,null,9,125,518,561,68,148,173,null,9,125,666,561,68,148,173]
[10,366,338,158,456,140,432,null,10,315,418,245,273,140,324,null,10,315,751,245,273,140,324]
[11,268,259,191,796,257,123,null,11,750,281,318,302,257,740,null,11,750,538,318,302,257,740]
[12,476,482,74,427,62,60,null,12,161,540,93,61,62,497,null,12,161,623,93,61,62,497]
[13,280,217,434,220,206,473,null,13,93,272,540,373,206,251,null,13,93,709,540,373,206,251]
[14,115,227,338,188,162,400,null,14,751,196,462,190,162,588,null,14,751,157,462,190,162,588]
[15,247,203,87,764,293,249,null,15,102,439,614,477,293,340,null,15,102,138,614,477,293,340]
[16,230,107,228,684,315,399,null,16,656,574,150,132,315,308,null,16,656,230,150,132,315,308]
[17,152,205,265,304,405,143,null,17,203,307,384,452,405,123,null,17,203,270,384,452,405,123]
[18,468,61,281,621,367,423,null,18,305,520,778,66,367,198,null,18,305,630,778,66,367,198]
[19,303,138,401,722,199,168,null,19,393,614,610,165,199,140,null,19,393,365,610,165,199,140]
[20,343,460,266,363,387,330,null,20,236,486,123,317,387,152,null,20,236,556,123,317,387,152]
[21,474,487,54,716,288,222,null,21,669,209,108,111,288,299,null,21,669,652,108,111,288,299]
[22,405,61,316,520,478,478,null,22,249,208,502,208,478,405,null,22,249,192,502,208,478,405]
[23,416,209,301,445,464,59,null,23,630,119,128,96,464,246,null,23,630,313,128,96,464,246]
[24,365,108,428,152,112,53,null,24,434,666,161,71,112,257,null,24,434,305,161,71,112,257]
[25,343,329,109,116,274,458,null,25,320,751,324,297,274,379,null,25,320,518,324,297,274,379]
[26,438,206,91,100,327,277,null,26,189,538,319,274,327,165,null,26,189,418,319,274,327,165]
[27,71,402,407,799,287,54,null,27,284,623,359,497,287,184,null,27,284,281,359,497,287,184]
[28,400,329,373,560,467,360,null,28,787,709,585,282,467,598,null,28,787,540,585,282,467,598]
[29,484,126,328,641,133,81,null,29,469,157,573,364,133,91,null,29,469,272,573,364,133,91]
[30,261,470,248,264,180,194,null,30,449,138,619,425,180,755,null,30,449,196,619,425,180,755]
[31,340,114,163,521,474,500,null,31,759,230,141,106,474,180,null,31,759,439,141,106,474,180]

{"sheet":"задание","index":4,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,0,19,6],[9,8,14,10],[8,1,8,2],[8,4,8,6],[1,1,1,9],[2,1,2,6],[4,3,4,6],[6,1,6,9]]}
[]
[null,"Решение задачи по последовательному соединению"]
[null,"Заполнить данные: группа № , Фамилия И.О., вариант №"]
[null,null,"Группа","№"]
[null,null,"Фамилия И.О."]
[]
[null,"      Начертить схему последовате-льного соединения резисторов, в которой: R1, Ом; R2, Ом; R3, Ом; R4, Ом; R5, Ом;  и Uпит, В.                                                            Выполнить расчет последовательного соединения резисторов и определить величину падения напряжений на каждом участке цепи.\n"]
[]
[null,"Условие задачи.",null,null,"Результаты решения задачи."]
[null,"Вариант №",1,null,"Действие №","Получен-ный результат","Верно / ложь",null,"После решения задачи сделать принт-скрин страницы и отправить принт-скрин на сайт преподавателя       naukatvor@yandex.ru                                                                              Если Вы работаете на сайте  закройте сайт без сохранения данных."]
[null,"Параметр","Величина.",null,1,15,{"$f":"IF(F11=Лист1!I7,\"Верно\",\"Ложъ\")","v":"Ложъ"}]
[null,"R1; Ом",null,null,{"$f":"E11+1","v":2},null,{"$f":"IF(F12=Лист1!I8,\"Верно\",\"Ложь\")","v":{"$error":"#DIV/0!"}}]
[null,"R2; Ом",null,null,{"$f":"E12+1","v":3},null,{"$f":"IF(F13=Лист1!I9,\"Верно\",\"Ложь\")","v":{"$error":"#DIV/0!"}}]
[null,"R3; Ом",null,null,4,null,{"$f":"IF(F14=Лист1!I10,\"Верно\",\"Ложь\")","v":{"$error":"#DIV/0!"}}]
[null,"R4; Ом",null,null,5,null,{"$f":"IF(F15=Лист1!I11,\"Верно\",\"Ложь\")","v":{"$error":"#DIV/0!"}}]
[null,"R5; Ом",null,null,6,null,{"$f":"IF(F16=Лист1!I12,\"Верно\",\"Ложь\")","v":{"$error":"#DIV/0!"}}]
[null,"U; В",null,null,7,null,{"$f":"IF(F17=Лист1!I13,\"Верно\",\"Ложь\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,8,10.01,{"$f":"IF(F18=Лист1!I14,\"Верно\",\"Ложь\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C17<>\"\", IF(I19=\"\",NOW(), I19), \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I21-I19","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G18=\"Верно\", IF(I21=\"\",NOW(), I21), \"\")","v":{"$error":"#DIV/0!"}}]

{"sheet":"Лист3","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Лист1","index":6,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"R12345",{"$f":"ROUND( SUM(задание!C12:C16),2)","v":0}]
[null,null,null,null,null,null,null,"Iобщ",{"$f":"ROUND( задание!C17/Лист1!I7,3)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"U1",{"$f":"ROUND( I8*задание!C12,2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"U2",{"$f":"ROUND(I8*задание!C13,2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"U3",{"$f":"ROUND( I8*задание!C14,2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"U4",{"$f":"ROUND(I8*задание!C15,2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"U5",{"$f":"ROUND(I8*задание!C16,2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"U1+U2+U3+U4+U5=Uп",{"$f":"ROUND( I9+I10+I11+I12+I13,2)","v":{"$error":"#DIV/0!"}}]