{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Таблица опроса","Диаграммы","Лист1"],"not_rendered":{"charts":2,"images":2,"macros":1,"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":19,"n_cols":17,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,7],[14,1,14,6],[1,14,2,15],[1,16,2,16]]}
[null,"Варианты ответа"]
["Номер вопроса",1,2,3,4,5,6,7,null,null,null,"Количество верных ответов",null,null,"Количество анкет",null,7]
["Вопрос1",111,111,111,111,111,111,111,null,null,null,{"$f":"D3","v":111}]
["Вопрос2",111,111,111,111,111,111,111,null,null,null,{"$f":"C4+E4+G4","v":333}]
["Вопрос3",111,111,111,111,111,111,111,null,null,null,{"$f":"B5","v":111}]
["Вопрос4",111,111,111,111,111,111,111,null,null,null,{"$f":"E6","v":111}]
["Вопрос5",111,111,111,111,111,111,111,null,null,null,{"$f":"C7","v":111}]
["Вопрос6",111,111,111,111,111,111,111,null,null,null,{"$f":"C8","v":111}]
["Вопрос7",111,111,111,111,111,111,111,null,null,null,{"$f":"E9","v":111}]
["Вопрос8",111,111,111,111,111,111,111,null,null,null,{"$f":"D10","v":111}]
["Вопрос9",111,111,111,111,111,111,111,null,null,null,{"$f":"D11","v":111}]
["Вопрос10",111,111,111,111,111,111,111,null,null,null,{"$f":"B12+C12+D12+E12+F12+G12","v":666}]
["Вопрос11",111,111,111,111,111,111,111,null,null,null,{"$f":"E13","v":111}]
["Вопрос12",111,111,111,111,111,111,111,null,null,null,{"$f":"B14","v":111}]
["Вопрос17","Ответ верный.",null,null,null,null,null,0,null,null,null,{"$f":"H15","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Итог в %",{"$f":"SUM(L3:L15)*5","v":10545}]
[]
[]
[null,{"$f":"0+('Таблица опроса'!L3)+1","v":112}]

{"sheet":"Диаграммы","index":1,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[16,0,16,1]]}
["Номер вопроса","Ответы"]
["Вопрос1",{"$f":"'Таблица опроса'!L3","v":111}]
["Вопрос2",{"$f":"'Таблица опроса'!L4","v":333}]
["Вопрос3",{"$f":"'Таблица опроса'!L5","v":111}]
["Вопрос4",{"$f":"'Таблица опроса'!L6","v":111}]
["Вопрос5",{"$f":"'Таблица опроса'!L7","v":111}]
["Вопрос6",{"$f":"'Таблица опроса'!L8","v":111}]
["Вопрос7",{"$f":"'Таблица опроса'!L9","v":111}]
["Вопрос8",{"$f":"'Таблица опроса'!L10","v":111}]
["Вопрос9",{"$f":"'Таблица опроса'!L11","v":111}]
["Вопрос10",{"$f":"'Таблица опроса'!L12","v":666}]
["Вопрос11",{"$f":"'Таблица опроса'!L13","v":111}]
["Вопрос12",{"$f":"'Таблица опроса'!L14","v":111}]
["Вопрос17",{"$f":"'Таблица опроса'!L15","v":0}]
[]
[]
[]
["Номер вопроса","Ответы"]
["Вопрос1",25]
["Вопрос2",72]
["Вопрос3",24]
["Вопрос4",24]
["Вопрос5",24]
["Вопрос6",24]
["Вопрос7",24]
["Вопрос8",24]
["Вопрос9",24]
["Вопрос10",144]
["Вопрос11",15]
["Вопрос12",7]
["Вопрос17",0]

{"sheet":"Лист1","index":2,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
["Номер вопроса","варианты ответа",null,null,null,null,null,null,null,null,null,null,"процент знания"]
["Вопрос1",0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(B2=1,\"0\",IF(C2=1,\"0\",IF(D2=1,\"5,26\",IF(E2=1,\"0\",IF(F2=1,\"0\",IF(G2=1,\"0\",IF(H2=1,\"0\")))))))","v":false}]
["Вопрос2",0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(B3=1,\"0\",IF(C3=1,\"0\",IF(D3=1,\"5,26\",IF(E3=1,\"0\",IF(F3=1,\"0\",IF(G3=1,\"0\",IF(H3=1,\"0\")))))))","v":false}]
["Вопрос3",0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(B4=1,\"0\",IF(C4=1,\"5,26\",IF(D4=1,\"0\",IF(E4=1,\"5,26\",IF(F4=1,\"0\",IF(G4=1,\"5,26\",IF(H4=1,\"0\")))))))","v":false}]
["Вопрос4",0,0,0,0,0,0,0,null,null,null,null,{"$f":"IF(B5=1,\"0\",IF(C5=1,\"0\",IF(D5=1,\"7,7\",IF(E5=1,\"0\",IF(F5=1,\"0\",IF(G5=1,\"0\",IF(H5=1,\"0\")))))))","v":false}]
["Вопрос5",0,0,0,0,0,0,0,null,null,null,null,false]
["Вопрос6",0,0,0,0,0,0,0,null,null,null,null,false]
["Вопрос7",0,0,0,0,0,0,0,null,null,null,null,false]
["Вопрос8",0,0,0,0,0,0,0,null,null,null,null,{"$f":"M21","v":0}]
["Вопрос9",0,0,0,0,0,0,0,null,null,null,null,false]
["Вопрос10",0,0,0,0,0,0,0,null,null,null,null,false]
["Вопрос11",0,0,0,0,0,0,0,null,null,null,null,false]
["Вопрос12",0,0,0,0,0,0,0,null,null,null,null,false]
["Вопрос17",0,0,0,0,0,0,0,null,null,null,null,false]
[null,1,2,3,4,5,6,7,null,null,null,"Итог %",{"$f":"SUM(M2:M14)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"количество ответов"]
[null,0,0,0,0,0,0,0,null,null,null,null,{"$f":"D26","v":0}]
[null,0,0,0,0,0,0,0,null,null,null,null,{"$f":"SUM(C27+E27+G27)","v":0}]
[null,1,0,0,0,0,0,0,null,null,null,null,{"$f":"B28","v":1}]
[null,0,0,0,1,0,0,0,null,null,null,null,{"$f":"E29","v":1}]
[null,0,1,0,0,0,0,0,null,null,null,null,{"$f":"C30","v":1}]
[null,0,0,0,0,0,0,0,null,null,null,null,{"$f":"C31","v":0}]
[null,0,0,0,1,0,0,0,null,null,null,null,{"$f":"E32","v":1}]
[null,0,0,0,0,0,0,0,null,null,null,null,{"$f":"D33","v":0}]
[null,0,0,0,0,0,0,0,null,null,null,null,{"$f":"D34","v":0}]
[null,1,1,1,1,1,1,0,null,null,null,null,{"$f":"SUM(B35+C35+D35+E35+F35+G35)","v":6}]
[null,0,0,0,0,0,0,0,null,null,null,null,{"$f":"E36","v":0}]
[null,0,0,0,0,0,0,0,null,null,null,null,{"$f":"B37","v":0}]
[null,0,0,0,0,0,0,0,null,null,null,"итог %",{"$f":"SUM(M26:M37)*5.26","v":52.599999999999994}]