{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["test","forma"],"not_rendered":{"charts":0,"images":0,"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":"test","index":0,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,1,0,6],[0,7,1,10],[2,0,2,6],[9,0,9,6],[51,0,51,6],[16,0,16,6],[21,0,21,6],[26,0,26,6],[31,0,31,6],[44,0,44,6]]}
["GenPosobie ","Тест к задачам по дисциплинам: \"Генетика\" и \"Генетика с основами селекции\"",null,null,null,null,null,"Кафедра селекции и семеноводства ФГБОУ ВО Воронежский государственный аграрный университет имени императора Петра I, 2017 г."]
["№ задачи","Вопрос 1","Вопрос 2","Вопрос 3","Вопрос 4","Вопрос 5","Оценка, \nбалл"]
["Наследование признаков при моногибридном скрещивании"]
["55",null,null,null,null,null,{"$f":"SUM(forma!B4:F4)","v":0}]
["56",null,null,null,null,null,{"$f":"SUM(forma!B5:F5)","v":0}]
["57",null,null,null,null,null,{"$f":"SUM(forma!B6:F6)","v":0}]
["58",null,null,null,null,null,{"$f":"SUM(forma!B7:F7)","v":0}]
["59",null,null,null,null,null,{"$f":"SUM(forma!B8:F8)","v":0}]
["60",null,null,null,null,null,{"$f":"SUM(forma!B9:F9)","v":0}]
["Наследование признаков при дигибридном скрещивании"]
["61",null,null,null,null,null,{"$f":"SUM(forma!B11:F11)","v":0}]
["62",null,null,null,null,null,{"$f":"SUM(forma!B12:F12)","v":0}]
["63",null,null,null,null,null,{"$f":"SUM(forma!B13:F13)","v":0}]
["64",null,null,null,null,null,{"$f":"SUM(forma!B14:F14)","v":0}]
["65",null,null,null,null,null,{"$f":"SUM(forma!B15:F15)","v":0}]
["66",null,null,null,null,null,{"$f":"SUM(forma!B16:F16)","v":0}]
["Комплементарное действие генов"]
["67",null,null,null,null,null,{"$f":"SUM(forma!B18:F18)","v":0}]
["68",null,null,null,null,null,{"$f":"SUM(forma!B19:F19)","v":0}]
["69",null,null,null,null,null,{"$f":"SUM(forma!B20:F20)","v":0}]
["70",null,null,null,null,null,{"$f":"SUM(forma!B21:F21)","v":0}]
["Эпистатическое действие генов"]
["71",null,null,null,null,null,{"$f":"SUM(forma!B23:F23)","v":0}]
["72",null,null,null,null,null,{"$f":"SUM(forma!B24:F24)","v":0}]
["73",null,null,null,null,null,{"$f":"SUM(forma!B25:F25)","v":0}]
["74",null,null,null,null,null,{"$f":"SUM(forma!B26:F26)","v":0}]
["Полимерное действие генов"]
["75",null,null,null,null,null,{"$f":"SUM(forma!B28:F28)","v":0}]
["76",null,null,null,null,null,{"$f":"SUM(forma!B29:F29)","v":0}]
["77",null,null,null,null,null,{"$f":"SUM(forma!B30:F30)","v":0}]
["78",null,null,null,null,null,{"$f":"SUM(forma!B31:F31)","v":0}]
["Сцепленное наследование генов"]
["79",null,null,null,null,null,{"$f":"SUM(forma!B33:F33)","v":0}]
["80",null,null,null,null,null,{"$f":"SUM(forma!B34:F34)","v":1}]
["81",null,null,null,null,null,{"$f":"SUM(forma!B35:F35)","v":0}]
["82",null,null,null,null,null,{"$f":"SUM(forma!B36:F36)","v":0}]
["83",null,null,null,null,null,{"$f":"SUM(forma!B37:F37)","v":0}]
["84",null,null,null,null,null,{"$f":"SUM(forma!B38:F38)","v":1}]
["85",null,null,null,null,null,{"$f":"SUM(forma!B39:F39)","v":0}]
["86",null,null,null,null,null,{"$f":"SUM(forma!B40:F40)","v":0}]
["87",null,null,null,null,null,{"$f":"SUM(forma!B41:F41)","v":0}]
["88",null,null,null,null,null,{"$f":"SUM(forma!B42:F42)","v":0}]
["89",null,null,null,null,null,{"$f":"SUM(forma!B43:F43)","v":0}]
["90",null,null,null,null,null,{"$f":"SUM(forma!B44:F44)","v":2}]
["Сцепленное наследование генов с половыми хромосомами"]
["91",null,null,null,null,null,{"$f":"SUM(forma!B46:F46)","v":1}]
["92",null,null,null,null,null,{"$f":"SUM(forma!B47:F47)","v":0}]
["93",null,null,null,null,null,{"$f":"SUM(forma!B48:F48)","v":0}]
["94",null,null,null,null,null,{"$f":"SUM(forma!B49:F49)","v":0}]
["95",null,null,null,null,null,{"$f":"SUM(forma!B50:F50)","v":0}]
["96",null,null,null,null,null,{"$f":"SUM(forma!B51:F51)","v":0}]
["Генетическая структура популяции"]
["97",null,null,null,null,null,{"$f":"SUM(forma!B53:F53)","v":0}]
["98",null,null,null,null,null,{"$f":"SUM(forma!B54:F54)","v":0}]
["99",null,null,null,null,null,{"$f":"SUM(forma!B55:F55)","v":0}]
["100",null,null,null,null,null,{"$f":"SUM(forma!B56:F56)","v":0}]
["101",null,null,null,null,null,{"$f":"SUM(forma!B57:F57)","v":0}]
["102",null,null,null,null,null,{"$f":"SUM(forma!B58:F58)","v":0}]

{"sheet":"forma","index":1,"n_rows":58,"n_cols":6,"rows_kept":58,"cut":false,"hidden":true,"merged":[[0,1,0,5]]}
[null,"№ вопроса"]
["№ задачи"]
[]
["55",{"$f":"IF(test!B4=123,1,0)","v":0},{"$f":"IF(test!C4=1,1,0)","v":0},{"$f":"IF(test!D4=796,1,0)","v":0},{"$f":"IF(test!E4=1592,1,0)","v":0},{"$f":"IF(test!F4=796,1,0)","v":0}]
["56",{"$f":"IF(test!B5=2,1,0)","v":0},{"$f":"IF(test!C5=2,1,0)","v":0},{"$f":"IF(test!D5=24,1,0)","v":0},{"$f":"IF(test!E5=48,1,0)","v":0},{"$f":"IF(test!F5=24,1,0)","v":0}]
["57",{"$f":"IF(test!B6=2,1,0)","v":0},{"$f":"IF(test!C6=298,1,0)","v":0},{"$f":"IF(test!D6=590,1,0)","v":0},{"$f":"IF(test!E6=295,1,0)","v":0},{"$f":"IF(test!F6=295,1,0)","v":0}]
["58",{"$f":"IF(test!B7=2,1,0)","v":0},{"$f":"IF(test!C7=1,1,0)","v":0},{"$f":"IF(test!D7=64,1,0)","v":0},{"$f":"IF(test!E7=64,1,0)","v":0},{"$f":"IF(test!F7=2,1,0)","v":0}]
["59",{"$f":"IF(test!B8=4,1,0)","v":0},{"$f":"IF(test!C8=5,1,0)","v":0},{"$f":"IF(test!D8=1,1,0)","v":0},{"$f":"IF(test!E8=1,1,0)","v":0},{"$f":"IF(test!F8=2,1,0)","v":0}]
["60",{"$f":"IF(test!B9=2,1,0)","v":0},{"$f":"IF(test!C9=2,1,0)","v":0},{"$f":"IF(test!D9=3,1,0)","v":0},{"$f":"IF(test!E9=1,1,0)","v":0},{"$f":"IF(test!F9=2,1,0)","v":0}]
[]
["61",{"$f":"IF(test!B11=4,1,0)","v":0},{"$f":"IF(test!C11=1,1,0)","v":0},{"$f":"IF(test!D11=1,1,0)","v":0},{"$f":"IF(test!E11=4,1,0)","v":0},{"$f":"IF(test!F11=9,1,0)","v":0}]
["62",{"$f":"IF(test!B12=4,1,0)","v":0},{"$f":"IF(test!C12=28,1,0)","v":0},{"$f":"IF(test!D12=4,1,0)","v":0},{"$f":"IF(test!E12=4,1,0)","v":0},{"$f":"IF(test!F12=4,1,0)","v":0}]
["63",{"$f":"IF(test!B13=4,1,0)","v":0},{"$f":"IF(test!C13=216,1,0)","v":0},{"$f":"IF(test!D13=4,1,0)","v":0},{"$f":"IF(test!E13=9,1,0)","v":0},{"$f":"IF(test!F13=72,1,0)","v":0}]
["64",{"$f":"IF(test!B14=4,1,0)","v":0},{"$f":"IF(test!C14=4,1,0)","v":0},{"$f":"IF(test!D14=248,1,0)","v":0},{"$f":"IF(test!E14=124,1,0)","v":0},{"$f":"IF(test!F14=4,1,0)","v":0}]
["65",{"$f":"IF(test!B15=4,1,0)","v":0},{"$f":"IF(test!C15=9,1,0)","v":0},{"$f":"IF(test!D15=6,1,0)","v":0},{"$f":"IF(test!E15=10,1,0)","v":0},{"$f":"IF(test!F15=15,1,0)","v":0}]
["66",{"$f":"IF(test!B16=12,1,0)","v":0},{"$f":"IF(test!C16=4,1,0)","v":0},{"$f":"IF(test!D16=6,1,0)","v":0},{"$f":"IF(test!E16=9,1,0)","v":0},{"$f":"IF(test!F16=12,1,0)","v":0}]
[]
["67",{"$f":"IF(test!B18=128,1,0)","v":0},{"$f":"IF(test!C18=96,1,0)","v":0},{"$f":"IF(test!D18=128,1,0)","v":0},{"$f":"IF(test!E18=32,1,0)","v":0},{"$f":"IF(test!F18=128,1,0)","v":0}]
["68",{"$f":"IF(test!B19=4,1,0)","v":0},{"$f":"IF(test!C19=9,1,0)","v":0},{"$f":"IF(test!D19=12,1,0)","v":0},{"$f":"IF(test!E19=12,1,0)","v":0},{"$f":"IF(test!F19=24,1,0)","v":0}]
["69",{"$f":"IF(test!B20=115,1,0)","v":0},{"$f":"IF(test!C20=4,1,0)","v":0},{"$f":"IF(test!D20=3,1,0)","v":0},{"$f":"IF(test!E20=120,1,0)","v":0},{"$f":"IF(test!F20=160,1,0)","v":0}]
["70",{"$f":"IF(test!B21=150,1,0)","v":0},{"$f":"IF(test!C21=4,1,0)","v":0},{"$f":"IF(test!D21=9,1,0)","v":0},{"$f":"IF(test!E21=10,1,0)","v":0},{"$f":"IF(test!F21=30,1,0)","v":0}]
[]
["71",{"$f":"IF(test!B23=3,1,0)","v":0},{"$f":"IF(test!C23=9,1,0)","v":0},{"$f":"IF(test!D23=25,1,0)","v":0},{"$f":"IF(test!E23=300,1,0)","v":0},{"$f":"IF(test!F23=75,1,0)","v":0}]
["72",{"$f":"IF(test!B24=116,1,0)","v":0},{"$f":"IF(test!C24=2,1,0)","v":0},{"$f":"IF(test!D24=360,1,0)","v":0},{"$f":"IF(test!E24=125,1,0)","v":0},{"$f":"IF(test!F24=325,1,0)","v":0}]
["73",{"$f":"IF(test!B25=1,1,0)","v":0},{"$f":"IF(test!C25=118,1,0)","v":0},{"$f":"IF(test!D25=2,1,0)","v":0},{"$f":"IF(test!E25=90,1,0)","v":0},{"$f":"IF(test!F25=30,1,0)","v":0}]
["74",{"$f":"IF(test!B26=116,1,0)","v":0},{"$f":"IF(test!C26=3,1,0)","v":0},{"$f":"IF(test!D26=50,1,0)","v":0},{"$f":"IF(test!E26=600,1,0)","v":0},{"$f":"IF(test!F26=200,1,0)","v":0}]
[]
["75",{"$f":"IF(test!B28=46,1,0)","v":0},{"$f":"IF(test!C28=5,1,0)","v":0},{"$f":"IF(test!D28=63,1,0)","v":0},{"$f":"IF(test!E28=44,1,0)","v":0},{"$f":"IF(test!F28=20,1,0)","v":0}]
["76",{"$f":"IF(test!B29=14,1,0)","v":0},{"$f":"IF(test!C29=5,1,0)","v":0},{"$f":"IF(test!D29=17,1,0)","v":0},{"$f":"IF(test!E29=240,1,0)","v":0},{"$f":"IF(test!F29=300,1,0)","v":0}]
["77",{"$f":"IF(test!B30=4,1,0)","v":0},{"$f":"IF(test!C30=120,1,0)","v":0},{"$f":"IF(test!D30=490,1,0)","v":0},{"$f":"IF(test!E30=70,1,0)","v":0},{"$f":"IF(test!F30=280,1,0)","v":0}]
["78",{"$f":"IF(test!B31=122,1,0)","v":0},{"$f":"IF(test!C31=40,1,0)","v":0},{"$f":"IF(test!D31=280,1,0)","v":0},{"$f":"IF(test!E31=2,1,0)","v":0},{"$f":"IF(test!F31=9,1,0)","v":0}]
[]
["79",{"$f":"IF(test!B33=2,1,0)","v":0},{"$f":"IF(test!C33=60,1,0)","v":0},{"$f":"IF(test!D33=60,1,0)","v":0},{"$f":"IF(test!E33=2,1,0)","v":0},{"$f":"IF(test!F33=2,1,0)","v":0}]
["80",{"$f":"IF(test!B34=2,1,0)","v":0},{"$f":"IF(test!C34=3,1,0)","v":0},{"$f":"IF(test!D34=2,1,0)","v":0},{"$f":"IF(test!E34=720,1,0)","v":0},{"$f":"IF(test!F34=0,1,0)","v":1}]
["81",{"$f":"IF(test!B35=118,1,0)","v":0},{"$f":"IF(test!C35=2,1,0)","v":0},{"$f":"IF(test!D35=3,1,0)","v":0},{"$f":"IF(test!E35=281,1,0)","v":0},{"$f":"IF(test!F35=562,1,0)","v":0}]
["82",{"$f":"IF(test!B36=2,1,0)","v":0},{"$f":"IF(test!C36=112,1,0)","v":0},{"$f":"IF(test!D36=3,1,0)","v":0},{"$f":"IF(test!E36=286,1,0)","v":0},{"$f":"IF(test!F36=572,1,0)","v":0}]
["83",{"$f":"IF(test!B37=2,1,0)","v":0},{"$f":"IF(test!C37=18,1,0)","v":0},{"$f":"IF(test!D37=3,1,0)","v":0},{"$f":"IF(test!E37=14,1,0)","v":0},{"$f":"IF(test!F37=42,1,0)","v":0}]
["84",{"$f":"IF(test!B38=2,1,0)","v":0},{"$f":"IF(test!C38=3,1,0)","v":0},{"$f":"IF(test!D38=144,1,0)","v":0},{"$f":"IF(test!E38=72,1,0)","v":0},{"$f":"IF(test!F38=0,1,0)","v":1}]
["85",{"$f":"IF(test!B39=85,1,0)","v":0},{"$f":"IF(test!C39=4,1,0)","v":0},{"$f":"IF(test!D39=4,1,0)","v":0},{"$f":"IF(test!E39=7,1,0)","v":0},{"$f":"IF(test!F39=15,1,0)","v":0}]
["86",{"$f":"IF(test!B40=116,1,0)","v":0},{"$f":"IF(test!C40=46,1,0)","v":0},{"$f":"IF(test!D40=4,1,0)","v":0},{"$f":"IF(test!E40=4,1,0)","v":0},{"$f":"IF(test!F40=13,1,0)","v":0}]
["87",{"$f":"IF(test!B41=364,1,0)","v":0},{"$f":"IF(test!C41=46,1,0)","v":0},{"$f":"IF(test!D41=5,1,0)","v":0},{"$f":"IF(test!E41=5,1,0)","v":0},{"$f":"IF(test!F41=9,1,0)","v":0}]
["88",{"$f":"IF(test!B42=672,1,0)","v":0},{"$f":"IF(test!C42=42,1,0)","v":0},{"$f":"IF(test!D42=42,1,0)","v":0},{"$f":"IF(test!E42=8,1,0)","v":0},{"$f":"IF(test!F42=16,1,0)","v":0}]
["89",{"$f":"IF(test!B43=4,1,0)","v":0},{"$f":"IF(test!C43=190,1,0)","v":0},{"$f":"IF(test!D43=40,1,0)","v":0},{"$f":"IF(test!E43=190,1,0)","v":0},{"$f":"IF(test!F43=48,1,0)","v":0}]
["90",{"$f":"IF(test!B44=40,1,0)","v":0},{"$f":"IF(test!C44=0,1,0)","v":1},{"$f":"IF(test!D44=50,1,0)","v":0},{"$f":"IF(test!E44=0,1,0)","v":1},{"$f":"IF(test!F44=45,1,0)","v":0}]
[]
["91",{"$f":"IF(test!B46=1,1,0)","v":0},{"$f":"IF(test!C46=0,1,0)","v":1},{"$f":"IF(test!D46=1,1,0)","v":0},{"$f":"IF(test!E46=1,1,0)","v":0},{"$f":"IF(test!F46=1,1,0)","v":0}]
["92",{"$f":"IF(test!B47=6,1,0)","v":0},{"$f":"IF(test!C47=4,1,0)","v":0},{"$f":"IF(test!D47=2,1,0)","v":0},{"$f":"IF(test!E47=2,1,0)","v":0},{"$f":"IF(test!F47=2,1,0)","v":0}]
["93",{"$f":"IF(test!B48=2,1,0)","v":0},{"$f":"IF(test!C48=4,1,0)","v":0},{"$f":"IF(test!D48=2,1,0)","v":0},{"$f":"IF(test!E48=2,1,0)","v":0},{"$f":"IF(test!F48=2,1,0)","v":0}]
["94",{"$f":"IF(test!B49=2,1,0)","v":0},{"$f":"IF(test!C49=2,1,0)","v":0},{"$f":"IF(test!D49=2,1,0)","v":0},{"$f":"IF(test!E49=1,1,0)","v":0},{"$f":"IF(test!F49=1,1,0)","v":0}]
["95",{"$f":"IF(test!B50=12,1,0)","v":0},{"$f":"IF(test!C50=12,1,0)","v":0},{"$f":"IF(test!D50=12,1,0)","v":0},{"$f":"IF(test!E50=24,1,0)","v":0},{"$f":"IF(test!F50=2,1,0)","v":0}]
["96",{"$f":"IF(test!B51=6,1,0)","v":0},{"$f":"IF(test!C51=6,1,0)","v":0},{"$f":"IF(test!D51=12,1,0)","v":0},{"$f":"IF(test!E51=5,1,0)","v":0},{"$f":"IF(test!F51=5,1,0)","v":0}]
[]
["97",{"$f":"IF(test!B53=0.436,1,0)","v":0},{"$f":"IF(test!C53=0.564,1,0)","v":0},{"$f":"IF(test!D53=31.8,1,0)","v":0},{"$f":"IF(test!E53=49.2,1,0)","v":0},{"$f":"IF(test!F53=19,1,0)","v":0}]
["98",{"$f":"IF(test!B54=0.8,1,0)","v":0},{"$f":"IF(test!C54=0.2,1,0)","v":0},{"$f":"IF(test!D54=4,1,0)","v":0},{"$f":"IF(test!E54=64,1,0)","v":0},{"$f":"IF(test!F54=32,1,0)","v":0}]
["99",{"$f":"IF(test!B55=0.3,1,0)","v":0},{"$f":"IF(test!C55=0.7,1,0)","v":0},{"$f":"IF(test!D55=49,1,0)","v":0},{"$f":"IF(test!E55=42,1,0)","v":0},{"$f":"IF(test!F55=9,1,0)","v":0}]
["100",{"$f":"IF(test!B56=0.2,1,0)","v":0},{"$f":"IF(test!C56=0.8,1,0)","v":0},{"$f":"IF(test!D56=64,1,0)","v":0},{"$f":"IF(test!E56=32,1,0)","v":0},{"$f":"IF(test!F56=4,1,0)","v":0}]
["101",{"$f":"IF(test!B57=0.2,1,0)","v":0},{"$f":"IF(test!C57=0.8,1,0)","v":0},{"$f":"IF(test!D57=64,1,0)","v":0},{"$f":"IF(test!E57=32,1,0)","v":0},{"$f":"IF(test!F57=4,1,0)","v":0}]
["102",{"$f":"IF(test!B58=0.046,1,0)","v":0},{"$f":"IF(test!C58=0.954,1,0)","v":0},{"$f":"IF(test!D58=91,1,0)","v":0},{"$f":"IF(test!E58=8.8,1,0)","v":0},{"$f":"IF(test!F58=0.2,1,0)","v":0}]