{"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":82,"n_cols":18,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[null,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,null,null,null,null,null,null,null,null,null,null,null,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,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,null,"Столбцы разделены на группы KK и SV&CO. "]
[null,null,null,null,null,23,23,23,95,95,95,96,25,25,null,null,null,"На пересечении столбцов с значением КК (диапазон F4:N4) и строк с значением SV&CO (D9:D82) проставляются 0. "]
[null,null,null,null,null,{"$f":"SUM(F9:F82)","v":23},{"$f":"SUM(G9:G82)","v":23},{"$f":"SUM(H9:H82)","v":23},{"$f":"SUM(I9:I82)","v":95},{"$f":"SUM(J9:J82)","v":95},{"$f":"SUM(K9:K82)","v":95},{"$f":"SUM(L9:L82)","v":96},{"$f":"SUM(M9:M82)","v":25},{"$f":"SUM(N9:N82)","v":25}]
[null,null,null,null,null,{"$f":"F6=F7","v":true},{"$f":"G6=G7","v":true},{"$f":"H6=H7","v":true},{"$f":"I6=I7","v":true},{"$f":"J6=J7","v":true},{"$f":"K6=K7","v":true},{"$f":"L6=L7","v":true},{"$f":"M6=M7","v":true},{"$f":"N6=N7","v":true}]
[null,null,null,"KK",8,1,0,1,0,2,2,1,0,1,{"$f":"E9=P9","v":true},{"$f":"SUM(F9:N9)","v":8}]
[null,null,null,"SV&CO",5,0,0,0,1,2,1,1,0,0,{"$f":"E10=P10","v":true},{"$f":"SUM(F10:N10)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,1,1,1,1,0,1,{"$f":"E11=P11","v":true},{"$f":"SUM(F11:N11)","v":5}]
[null,null,null,"KK",8,0,2,2,0,1,1,1,1,0,{"$f":"E12=P12","v":true},{"$f":"SUM(F12:N12)","v":8}]
[null,null,null,"SV&CO",8,0,0,0,2,1,2,1,1,1,{"$f":"E13=P13","v":true},{"$f":"SUM(F13:N13)","v":8}]
[null,null,null,"KK",8,2,0,1,0,1,2,1,0,1,{"$f":"E14=P14","v":true},{"$f":"SUM(F14:N14)","v":8}]
[null,null,null,"SV&CO",8,0,0,0,2,2,2,1,1,0,{"$f":"E15=P15","v":true},{"$f":"SUM(F15:N15)","v":8}]
[null,null,null,"KK",8,0,1,0,2,2,1,2,0,0,{"$f":"E16=P16","v":true},{"$f":"SUM(F16:N16)","v":8}]
[null,null,null,"SV&CO",5,0,0,0,0,0,2,2,0,1,{"$f":"E17=P17","v":true},{"$f":"SUM(F17:N17)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,0,2,2,0,1,0,{"$f":"E18=P18","v":true},{"$f":"SUM(F18:N18)","v":5}]
[null,null,null,"KK",8,1,1,1,2,0,2,1,0,0,{"$f":"E19=P19","v":true},{"$f":"SUM(F19:N19)","v":8}]
[null,null,null,"KK",8,2,0,1,0,0,2,2,1,0,{"$f":"E20=P20","v":true},{"$f":"SUM(F20:N20)","v":8}]
[null,null,null,"SV&CO",5,0,0,0,1,2,2,0,0,0,{"$f":"E21=P21","v":true},{"$f":"SUM(F21:N21)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,2,1,0,2,0,0,{"$f":"E22=P22","v":true},{"$f":"SUM(F22:N22)","v":5}]
[null,null,null,"SV&CO",8,0,0,0,2,1,2,1,2,0,{"$f":"E23=P23","v":true},{"$f":"SUM(F23:N23)","v":8}]
[null,null,null,"SV&CO",5,0,0,0,1,1,1,2,0,0,{"$f":"E24=P24","v":true},{"$f":"SUM(F24:N24)","v":5}]
[null,null,null,"SV&CO",8,0,0,0,2,2,2,1,1,0,{"$f":"E25=P25","v":true},{"$f":"SUM(F25:N25)","v":8}]
[null,null,null,"SV&CO",5,0,0,0,0,2,1,2,0,0,{"$f":"E26=P26","v":true},{"$f":"SUM(F26:N26)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,2,1,0,2,0,0,{"$f":"E27=P27","v":true},{"$f":"SUM(F27:N27)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,2,1,1,1,0,0,{"$f":"E28=P28","v":true},{"$f":"SUM(F28:N28)","v":5}]
[null,null,null,"KK",8,0,0,2,2,0,1,2,0,1,{"$f":"E29=P29","v":true},{"$f":"SUM(F29:N29)","v":8}]
[null,null,null,"SV&CO",8,0,0,0,2,2,2,2,0,0,{"$f":"E30=P30","v":true},{"$f":"SUM(F30:N30)","v":8}]
[null,null,null,"SV&CO",8,0,0,0,2,2,1,2,0,1,{"$f":"E31=P31","v":true},{"$f":"SUM(F31:N31)","v":8}]
[null,null,null,"SV&CO",5,0,0,0,2,0,1,1,0,1,{"$f":"E32=P32","v":true},{"$f":"SUM(F32:N32)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,1,0,2,2,0,0,{"$f":"E33=P33","v":true},{"$f":"SUM(F33:N33)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,2,1,0,2,0,0,{"$f":"E34=P34","v":true},{"$f":"SUM(F34:N34)","v":5}]
[null,null,null,"KK",8,0,0,2,0,2,1,2,0,1,{"$f":"E35=P35","v":true},{"$f":"SUM(F35:N35)","v":8}]
[null,null,null,"KK",8,2,1,1,2,1,1,0,0,0,{"$f":"E36=P36","v":true},{"$f":"SUM(F36:N36)","v":8}]
[null,null,null,"SV&CO",8,0,0,0,2,2,1,2,0,1,{"$f":"E37=P37","v":true},{"$f":"SUM(F37:N37)","v":8}]
[null,null,null,"SV&CO",5,0,0,0,2,1,0,2,0,0,{"$f":"E38=P38","v":true},{"$f":"SUM(F38:N38)","v":5}]
[null,null,null,"KK",10,0,0,1,2,1,2,2,0,2,{"$f":"E39=P39","v":true},{"$f":"SUM(F39:N39)","v":10}]
[null,null,null,"KK",10,2,1,2,0,2,2,0,0,1,{"$f":"E40=P40","v":true},{"$f":"SUM(F40:N40)","v":10}]
[null,null,null,"KK",10,0,2,0,2,2,1,2,1,0,{"$f":"E41=P41","v":true},{"$f":"SUM(F41:N41)","v":10}]
[null,null,null,"KK",10,1,0,0,2,2,1,2,1,1,{"$f":"E42=P42","v":true},{"$f":"SUM(F42:N42)","v":10}]
[null,null,null,"SV&CO",5,0,0,0,2,1,1,1,0,0,{"$f":"E43=P43","v":true},{"$f":"SUM(F43:N43)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,2,1,2,0,0,0,{"$f":"E44=P44","v":true},{"$f":"SUM(F44:N44)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,2,1,1,1,0,0,{"$f":"E45=P45","v":true},{"$f":"SUM(F45:N45)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,2,0,1,2,0,0,{"$f":"E46=P46","v":true},{"$f":"SUM(F46:N46)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,2,0,1,1,1,0,{"$f":"E47=P47","v":true},{"$f":"SUM(F47:N47)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,0,2,1,0,1,1,{"$f":"E48=P48","v":true},{"$f":"SUM(F48:N48)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,2,1,1,1,0,0,{"$f":"E49=P49","v":true},{"$f":"SUM(F49:N49)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,1,1,1,2,0,0,{"$f":"E50=P50","v":true},{"$f":"SUM(F50:N50)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,0,1,1,1,1,1,{"$f":"E51=P51","v":true},{"$f":"SUM(F51:N51)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,2,0,1,2,0,0,{"$f":"E52=P52","v":true},{"$f":"SUM(F52:N52)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,0,2,1,2,0,0,{"$f":"E53=P53","v":true},{"$f":"SUM(F53:N53)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,2,2,1,0,0,0,{"$f":"E54=P54","v":true},{"$f":"SUM(F54:N54)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,1,0,1,2,0,1,{"$f":"E55=P55","v":true},{"$f":"SUM(F55:N55)","v":5}]
[null,null,null,"SV&CO",8,0,0,0,1,2,2,1,1,1,{"$f":"E56=P56","v":true},{"$f":"SUM(F56:N56)","v":8}]
[null,null,null,"KK",8,2,1,0,2,2,1,0,0,0,{"$f":"E57=P57","v":true},{"$f":"SUM(F57:N57)","v":8}]
[null,null,null,"SV&CO",5,0,0,0,2,1,2,0,0,0,{"$f":"E58=P58","v":true},{"$f":"SUM(F58:N58)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,2,1,1,0,1,0,{"$f":"E59=P59","v":true},{"$f":"SUM(F59:N59)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,2,0,1,1,1,0,{"$f":"E60=P60","v":true},{"$f":"SUM(F60:N60)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,0,2,1,2,0,0,{"$f":"E61=P61","v":true},{"$f":"SUM(F61:N61)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,0,2,1,2,0,0,{"$f":"E62=P62","v":true},{"$f":"SUM(F62:N62)","v":5}]
[null,null,null,"KK",8,0,2,0,2,1,1,2,0,0,{"$f":"E63=P63","v":true},{"$f":"SUM(F63:N63)","v":8}]
[null,null,null,"SV&CO",5,0,0,0,2,1,2,0,0,0,{"$f":"E64=P64","v":true},{"$f":"SUM(F64:N64)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,0,2,1,1,1,0,{"$f":"E65=P65","v":true},{"$f":"SUM(F65:N65)","v":5}]
[null,null,null,"KK",8,2,0,1,1,1,1,2,0,0,{"$f":"E66=P66","v":true},{"$f":"SUM(F66:N66)","v":8}]
[null,null,null,"KK",8,0,0,2,1,1,1,2,0,1,{"$f":"E67=P67","v":true},{"$f":"SUM(F67:N67)","v":8}]
[null,null,null,"SV&CO",8,0,0,0,2,2,2,1,1,0,{"$f":"E68=P68","v":true},{"$f":"SUM(F68:N68)","v":8}]
[null,null,null,"SV&CO",5,0,0,0,2,0,1,1,0,1,{"$f":"E69=P69","v":true},{"$f":"SUM(F69:N69)","v":5}]
[null,null,null,"KK",10,0,2,1,1,2,2,1,1,0,{"$f":"E70=P70","v":true},{"$f":"SUM(F70:N70)","v":10}]
[null,null,null,"KK",8,1,2,0,0,1,1,2,1,0,{"$f":"E71=P71","v":true},{"$f":"SUM(F71:N71)","v":8}]
[null,null,null,"KK",10,1,2,1,2,1,1,2,0,0,{"$f":"E72=P72","v":true},{"$f":"SUM(F72:N72)","v":10}]
[null,null,null,"KK",10,1,1,0,1,2,1,2,1,1,{"$f":"E73=P73","v":true},{"$f":"SUM(F73:N73)","v":10}]
[null,null,null,"KK",10,1,1,1,1,2,1,2,0,1,{"$f":"E74=P74","v":true},{"$f":"SUM(F74:N74)","v":10}]
[null,null,null,"KK",10,0,1,1,2,2,2,1,1,0,{"$f":"E75=P75","v":true},{"$f":"SUM(F75:N75)","v":10}]
[null,null,null,"KK",10,2,0,0,1,2,2,2,1,0,{"$f":"E76=P76","v":true},{"$f":"SUM(F76:N76)","v":10}]
[null,null,null,"KK",10,2,2,1,2,1,1,1,0,0,{"$f":"E77=P77","v":true},{"$f":"SUM(F77:N77)","v":10}]
[null,null,null,"SV&CO",5,0,0,0,2,1,1,0,0,1,{"$f":"E78=P78","v":true},{"$f":"SUM(F78:N78)","v":5}]
[null,null,null,"SV&CO",8,0,0,0,0,2,2,2,1,1,{"$f":"E79=P79","v":true},{"$f":"SUM(F79:N79)","v":8}]
[null,null,null,"KK",8,0,1,1,1,2,2,0,0,1,{"$f":"E80=P80","v":true},{"$f":"SUM(F80:N80)","v":8}]
[null,null,null,"SV&CO",5,0,0,0,0,2,1,1,1,0,{"$f":"E81=P81","v":true},{"$f":"SUM(F81:N81)","v":5}]
[null,null,null,"SV&CO",5,0,0,0,0,2,1,2,0,0,{"$f":"E82=P82","v":true},{"$f":"SUM(F82:N82)","v":5}]