{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"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":"Лист1","index":0,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,"Красный",{"$f":"IF(AND(G4<>\"\",G4>0),COUNTIF(G$4:G4,G4),\"\")","v":1}]
[null,null,null,null,null,null,"Зеленый",{"$f":"IF(AND(G5<>\"\",G5>0),COUNTIF(G$4:G5,G5),\"\")","v":1}]
[null,null,null,null,null,null,"Красный ",{"$f":"IF(AND(G6<>\"\",G6>0),COUNTIF(G$4:G6,G6),\"\")","v":1}]
[null,null,null,null,null,null,"Синий",{"$f":"IF(AND(G7<>\"\",G7>0),COUNTIF(G$4:G7,G7),\"\")","v":1}]
[null,null,null,null,null,null,"Синий",{"$f":"IF(AND(G8<>\"\",G8>0),COUNTIF(G$4:G8,G8),\"\")","v":2}]
[null,null,null,null,null,null,"Красный",{"$f":"IF(AND(G9<>\"\",G9>0),COUNTIF(G$4:G9,G9),\"\")","v":2}]
[null,null,null,null,null,null,"Желтый",{"$f":"IF(AND(G10<>\"\",G10>0),COUNTIF(G$4:G10,G10),\"\")","v":1}]
[null,null,null,null,null,null,"Белый",{"$f":"IF(AND(G11<>\"\",G11>0),COUNTIF(G$4:G11,G11),\"\")","v":1}]
[null,null,null,null,null,null,"Зеленый",{"$f":"IF(AND(G12<>\"\",G12>0),COUNTIF(G$4:G12,G12),\"\")","v":2}]
[null,null,null,null,null,null,"Фиолетовый",{"$f":"IF(AND(G13<>\"\",G13>0),COUNTIF(G$4:G13,G13),\"\")","v":1}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(G14<>\"\",G14>0),COUNTIF(G$4:G14,G14),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(G15<>\"\",G15>0),COUNTIF(G$4:G15,G15),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(G16<>\"\",G16>0),COUNTIF(G$4:G16,G16),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(G17<>\"\",G17>0),COUNTIF(G$4:G17,G17),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(G18<>\"\",G18>0),COUNTIF(G$4:G18,G18),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(G19<>\"\",G19>0),COUNTIF(G$4:G19,G19),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(G20<>\"\",G20>0),COUNTIF(G$4:G20,G20),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(G21<>\"\",G21>0),COUNTIF(G$4:G21,G21),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(G22<>\"\",G22>0),COUNTIF(G$4:G22,G22),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(G23<>\"\",G23>0),COUNTIF(G$4:G23,G23),\"\")","v":""}]
[]
[]
[null,null,1,{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),C26)),\"\")","v":"Красный"},5,{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),E26)),\"\")","v":"Желтый"},null,null,{"$f":"IF($C$36>=1,1,\"\")","v":1},{"$f":"IF($E$36>=$C$36+1,$C$36+1,\"\")","v":5}]
[null,null,2,{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),C27)),\"\")","v":"Зеленый"},6,{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),E27)),\"\")","v":"Белый"},null,null,{"$f":"IF($C$36>=2,2,\"\")","v":2},{"$f":"IF($E$36>=$C$36+2,$C$36+2,\"\")","v":6}]
[null,null,3,{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),C28)),\"\")","v":"Красный "},7,{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),E28)),\"\")","v":"Фиолетовый"},null,null,{"$f":"IF($C$36>=3,3,\"\")","v":3},{"$f":"IF($E$36>=$C$36+3,$C$36+3,\"\")","v":7}]
[null,null,4,{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),C29)),\"\")","v":"Синий"},"",{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),E29)),\"\")","v":""},null,null,{"$f":"IF($C$36>=4,4,\"\")","v":4},{"$f":"IF($E$36>=$C$36+4,$C$36+4,\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),C30)),\"\")","v":""},"",{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),E30)),\"\")","v":""},null,null,{"$f":"IF($C$36>=5,5,\"\")","v":""},{"$f":"IF($E$36>=$C$36+5,$C$36+5,\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),C31)),\"\")","v":""},"",{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),E31)),\"\")","v":""},null,null,{"$f":"IF($C$36>=6,6,\"\")","v":""},{"$f":"IF($E$36>=$C$36+6,$C$36+6,\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),C32)),\"\")","v":""},"",{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),E32)),\"\")","v":""},null,null,{"$f":"IF($C$36>=7,7,\"\")","v":""},{"$f":"IF($E$36>=$C$36+7,$C$36+7,\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),C33)),\"\")","v":""},"",{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),E33)),\"\")","v":""},null,null,{"$f":"IF($C$36>=8,8,\"\")","v":""},{"$f":"IF($E$36>=$C$36+8,$C$36+8,\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),C34)),\"\")","v":""},"",{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),E34)),\"\")","v":""},null,null,{"$f":"IF($C$36>=9,9,\"\")","v":""},{"$f":"IF($E$36>=$C$36+9,$C$36+9,\"\")","v":""}]
[null,null,"",{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),C35)),\"\")","v":""},"",{"$f":"IFERROR(INDEX($G$4:$G$23,SMALL(IF($H$4:$H$23=1,ROW($1:$13)),E35)),\"\")","v":""},null,null,{"$f":"IF($C$36>=10,10,\"\")","v":""},{"$f":"IF($E$36>=$C$36+10,$C$36+10,\"\")","v":""}]
[null,null,{"$f":"IF(ISEVEN(COUNTIF(H4:H23,1)),COUNTIF(H4:H23,1)/2,(COUNTIF(H4:H23,1)+1)/2)","v":4},null,{"$f":"COUNTIF(H4:H23,1)","v":7}]