{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":71,"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":88,"n_cols":33,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Есть диапазон F9:N82 , который необходимо заполнить случайными числами от 0 до 2."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Условия заполнения:"]
[null,null,null,null,null,1,2,3,4,5,6,7,8,9,null,null,"Сумма чисел в F9:F82 должна равняться значению F6, сумма чисел F9:N9 должна равняться значению E9"]
[null,null,null,null,null,"KK","KK","KK","SV&CO","SV&CO","SV&CO","SV&CO","SV&CO","SV&CO",null,null,"Сумма чисел в G9:G82 должна равняться значению G6, сумма чисел F10:N10 должна равняться значению E10"]
[null,null,null,null,null,"stage 1","stage 2","stage 3","stage 4","stage 5","stage 6","stage 7","stage 8","stage 9",null,null,"Столбцы разделены на группы KK и SV&CO. "]
[null,null,null,null,null,25,25,25,98,98,98,99,26,26,{"$f":"SUM(F6:N6)","v":520},null,"На пересечении столбцов с значением КК (диапазон F4:N4) и строк с значением SV&CO (D9:D82) проставляются 0. "]
[null,null,null,null,null,{"$f":"SUM(F9:F82)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(F7:N7)","v":0},null,null,"Главное сумма F6:N6 = сумме E9:E82"]
[null,null,null,{"$f":"SUM(E9:E82)","v":520},null,{"$f":"F6=F7","v":false},false,false,false,false,false,false,false,false]
[null,null,null,"KK",8,null,null,null,null,null,null,null,null,null,{"$f":"E9=P9","v":false},{"$f":"SUM(F9:N9)","v":0}]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,null,23,23,23,95,95,95,96,25,25]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,null,21,21,21,96,96,96,97,24,24]
[null,null,null,"SV&CO",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,8]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,10,null,null,25,25,25,98,98,98,99,26,26]
[null,null,null,"SV&CO",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,8,null,8]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,8,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,8,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,8,null,10]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,8]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,8,null,10]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,8,null,8]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,8,null,10]
[null,null,null,"SV&CO",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,10,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,8,null,5]
[null,null,null,"SV&CO",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,8,null,10]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,10]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,8]
[null,null,null,"SV&CO",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"SV&CO",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,5,null,8]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,10,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,8,null,5]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,8,null,10]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,8]
[null,null,null,"SV&CO",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,8,null,8]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,8,null,5]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,8,null,5]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,{"$f":"E41=P41","v":false},{"$f":"SUM(F41:N41)","v":0},null,null,null,10,null,8,null,10]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,10,null,5,null,10]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,10,null,10,null,8]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,10,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,10]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,10]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,10]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,10]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"SV&CO",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"KK",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,8,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,10,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,8]
[null,null,null,"KK",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,10,null,8]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,5,null,5]
[null,null,null,"KK",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,5,null,5]
[null,null,null,"KK",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,8,null,5]
[null,null,null,"SV&CO",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,5,null,5]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,5,null,8]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,5,null,5]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,8,null,5]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,10,null,5,null,8]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,{"$f":"E73=P73","v":false},{"$f":"SUM(F73:N73)","v":0},null,null,null,8,null,5,null,8]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,10,null,10,null,8]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,10,null,8,null,5]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,10,null,5,null,10]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,10,null,10,null,10]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,10,null,10,null,10]
[null,null,null,"SV&CO",8,null,null,null,null,null,null,null,null,null,false,0,null,null,null,10,null,10,null,10]
[null,null,null,"KK",10,null,null,null,null,null,null,null,null,null,false,0,null,null,null,5,null,10,null,10]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,10,null,10]
[null,null,null,"SV&CO",5,null,null,null,null,null,null,null,null,null,false,0,null,null,null,8,null,5,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,8,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,8,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]