{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["cop_1","filtr","отчет1","отчет2","отчет3","отчет4"],"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":"cop_1","index":0,"n_rows":29,"n_cols":23,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,7,1,7],[0,12,1,12],[0,17,1,17],[0,22,1,22]]}
["Номинация",null,null,"Список отчетов 1","Название",{"$f":"INDEX($B$2:$B$4,MATCH(FALSE,ISNA(MATCH(\"*\"&$A$2:$A$4&\"*\",D4,)),))","v":{"$error":"#N/A"}},null,"Причина","Список отчетов 2","Название",{"$f":"INDEX($B$2:$B$4,MATCH(FALSE,ISNA(MATCH(\"*\"&$A$2:$A$4&\"*\",I4,)),))","v":{"$error":"#N/A"}},null,"Причина","Список отчетов 3","Название",{"$f":"INDEX($B$2:$B$4,MATCH(FALSE,ISNA(MATCH(\"*\"&$A$2:$A$4&\"*\",N4,)),))","v":{"$error":"#N/A"}},null,"Причина","Список отчетов 4","Название",{"$f":"INDEX($B$2:$B$4,MATCH(FALSE,ISNA(MATCH(\"*\"&$A$2:$A$4&\"*\",S4,)),))","v":{"$error":"#N/A"}},null,"Причина"]
[null,1,"стат.",{"$f":"TRIM( MID(D5, FIND(\"/\",D5)+2, FIND(\".\",D5) - FIND(\"/\",D5) -2) )","v":{"$error":"#VALUE!"}},"кол-во отчетов","кол-во побед",null,null,{"$f":"TRIM( MID(I5, FIND(\"/\",I5)+2, FIND(\".\",I5) - FIND(\"/\",I5) -2) )","v":{"$error":"#VALUE!"}},"кол-во отчетов","кол-во побед",null,null,{"$f":"TRIM( MID(N5, FIND(\"/\",N5)+2, FIND(\".\",N5) - FIND(\"/\",N5) -2) )","v":{"$error":"#VALUE!"}},"кол-во отчетов","кол-во побед",null,null,{"$f":"TRIM( MID(S5, FIND(\"/\",S5)+2, FIND(\".\",S5) - FIND(\"/\",S5) -2) )","v":{"$error":"#VALUE!"}},"кол-во отчетов","кол-во побед"]
[null,2,"Ник",null,{"$f":"COUNTIF(D5:D28,\"http*\")","v":0},{"$f":"COUNTIF(H5:H28,\"*\"&D3&\"*\")","v":0},null,null,null,{"$f":"COUNTIF(I5:I28,\"http*\")","v":0},{"$f":"COUNTIF(M5:M28,\"*\"&I3&\"*\")","v":0},null,null,null,{"$f":"COUNTIF(N5:N28,\"http*\")","v":0},{"$f":"COUNTIF(R5:R28,\"*\"&N3&\"*\")","v":0},null,null,null,{"$f":"COUNTIF(S5:S28,\"http*\")","v":0},{"$f":"COUNTIF(W5:W28,\"*\"&S3&\"*\")","v":0}]
[null,3,"стат.",null,"Дата","данные стат1.","данные стат2.","ник победителя",null,"Дата","данные стат1.","данные стат2.","ник победителя",null,"Дата","данные стат1.","данные стат2.","ник победителя",null,"Дата","данные стат1.","данные стат2.","ник победителя"]
[null,null,1,"отчет 1","2017-01-29","стат1","стат1",null,"отчет 1",null,null,null,null,"отчет 1",null,null,null,null,"отчет 1"]
[null,null,2,"отчет 2",null,null,null,null,"отчет 2",null,null,null,null,"отчет 2",null,null,null,null,"отчет 2"]
[null,null,3,"отчет 3",null,null,null,null,"отчет 3",null,null,null,null,"отчет 3",null,null,null,null,"отчет 3"]
[null,null,4,"отчет 4",null,null,null,null,"отчет 4",null,null,null,null,null,null,null,null,null,"отчет 4"]
[null,null,5,"отчет 5",null,null,null,null,"отчет 5",null,null,null,null,null,null,null,null,null,"отчет 5"]
[null,null,6,"отчет 6",null,null,null,null,"отчет 6"]
[null,null,7,"отчет 7",null,null,null,null,"отчет 7"]
[null,null,8,"отчет 8",null,null,null,null,"отчет 8"]
[null,null,9,"отчет 9",null,null,null,null,"отчет 9"]
[null,null,10,"отчет 10"]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[null,null,21]
[null,null,22]
[]
[]
[null,null,null,"Текст отчета",null,null,null,null,"Текст отчета",null,null,null,null,"Текст отчета",null,null,null,null,"Текст отчета"]

{"sheet":"filtr","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"отчет1","index":2,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Position [1]"]
["01-01 - 29/01/2017 "]
["стат0"]
["стат1"]
["стат2"]
["стат3"]
["стат4"]
["стат5"]
["[12:00] ron награжден 01"]
["[12:00] ron награжден 02"]
["[12:00] ron награжден 03"]
["[12:00] ron награжден 04"]
["[12:00] ron награжден 05"]
["[12:00] ron награжден 06"]
["[12:00] ron награжден 07"]
["[12:00] ron награжден 08"]
["[12:00] ron награжден 09"]
["[12:00] ron награжден 10"]
["[12:00] ron награжден 11"]
["[12:00] ron награжден 12"]
["[12:00] ron награжден 13"]
["[12:00] ron награжден 14"]
["[12:00] ron награжден 15"]
["[12:01] ron победил 15"]

{"sheet":"отчет2","index":3,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Position [3]"]
["01-03 - 29/01/2017 "]
["стат0"]
["стат1"]
["стат2"]
["стат3"]
["стат4"]
["стат5"]
["[12:00] west награжден 01"]
["[12:00] west награжден 02"]
["[12:00] west награжден 03"]
["[12:00] west награжден 04"]
["[12:00] west награжден 05"]
["[12:00] west награжден 06"]
["[12:00] west награжден 07"]
["[12:00] west награжден 08"]
["[12:01] west победил 8"]
["[12:00] west награжден 09"]
["[12:00] west награжден 10"]

{"sheet":"отчет3","index":4,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Position [2]"]
["01-02 - 29/01/2017 "]
["стат0"]
["стат1"]
["стат2"]
["стат3"]
["стат4"]
["стат5"]
["[12:00] stark награжден 01"]
["[12:00] stark награжден 02"]
["[12:00] stark награжден 03"]
["[12:00] stark награжден 04"]
["[12:00] stark награжден 05"]
["[12:00] stark награжден 06"]
["[12:00] stark награжден 07"]
["[12:00] stark награжден 08"]
["[12:00] stark награжден 09"]
["[12:00] stark награжден 10"]
["[12:01] stark победил 10"]
["[12:00] stark награжден 11"]
["[12:00] stark награжден 12"]

{"sheet":"отчет4","index":5,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Position [4]"]
["01-04 - 29/01/2017 "]
["стат0"]
["стат1"]
["стат2"]
["стат3"]
["стат4"]
["стат5"]
["[12:00] puma награжден 01"]
["[12:00] puma награжден 02"]
["[12:00] puma награжден 03"]
["[12:01] puma победил 3"]
["[12:00] puma награжден 04"]
["[12:00] puma награжден 05"]