{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Svod","src","Лист3"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Svod","index":0,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,-1,0,1,2,3]
["Вид","2017-09-01","2017-09-24"]
["Данные","Пар_1","Пар_2","Пар_3","Пар_4","Пар_5"]
["Ан-1",{"$f":"OFFSET(src!$C$1,MATCH($A4,src!$B:$B,0)+B$1,Svod!$C$2-src!$C$1,1,1)","v":54},{"$f":"OFFSET(src!$C$1,MATCH($A4,src!$B:$B,0)+C$1,Svod!$C$2-src!$C$1,1,1)","v":56},{"$f":"OFFSET(src!$C$1,MATCH($A4,src!$B:$B,0)+D$1,Svod!$C$2-src!$C$1,1,1)","v":50},{"$f":"OFFSET(src!$C$1,MATCH($A4,src!$B:$B,0)+E$1,Svod!$C$2-src!$C$1,1,1)","v":69},{"$f":"OFFSET(src!$C$1,MATCH($A4,src!$B:$B,0)+F$1,Svod!$C$2-src!$C$1,1,1)","v":84}]
["Ан-2",{"$f":"OFFSET(src!$C$1,MATCH($A5,src!$B:$B,0)+B$1,Svod!$C$2-src!$C$1,1,1)","v":18},{"$f":"OFFSET(src!$C$1,MATCH($A5,src!$B:$B,0)+C$1,Svod!$C$2-src!$C$1,1,1)","v":79},{"$f":"OFFSET(src!$C$1,MATCH($A5,src!$B:$B,0)+D$1,Svod!$C$2-src!$C$1,1,1)","v":55},{"$f":"OFFSET(src!$C$1,MATCH($A5,src!$B:$B,0)+E$1,Svod!$C$2-src!$C$1,1,1)","v":33},{"$f":"OFFSET(src!$C$1,MATCH($A5,src!$B:$B,0)+F$1,Svod!$C$2-src!$C$1,1,1)","v":37}]
["Ан-3",{"$f":"OFFSET(src!$C$1,MATCH($A6,src!$B:$B,0)+B$1,Svod!$C$2-src!$C$1,1,1)","v":11},{"$f":"OFFSET(src!$C$1,MATCH($A6,src!$B:$B,0)+C$1,Svod!$C$2-src!$C$1,1,1)","v":63},{"$f":"OFFSET(src!$C$1,MATCH($A6,src!$B:$B,0)+D$1,Svod!$C$2-src!$C$1,1,1)","v":9},{"$f":"OFFSET(src!$C$1,MATCH($A6,src!$B:$B,0)+E$1,Svod!$C$2-src!$C$1,1,1)","v":74},{"$f":"OFFSET(src!$C$1,MATCH($A6,src!$B:$B,0)+F$1,Svod!$C$2-src!$C$1,1,1)","v":97}]
["Ан-4",{"$f":"OFFSET(src!$C$1,MATCH($A7,src!$B:$B,0)+B$1,Svod!$C$2-src!$C$1,1,1)","v":98},{"$f":"OFFSET(src!$C$1,MATCH($A7,src!$B:$B,0)+C$1,Svod!$C$2-src!$C$1,1,1)","v":51},{"$f":"OFFSET(src!$C$1,MATCH($A7,src!$B:$B,0)+D$1,Svod!$C$2-src!$C$1,1,1)","v":18},{"$f":"OFFSET(src!$C$1,MATCH($A7,src!$B:$B,0)+E$1,Svod!$C$2-src!$C$1,1,1)","v":77},{"$f":"OFFSET(src!$C$1,MATCH($A7,src!$B:$B,0)+F$1,Svod!$C$2-src!$C$1,1,1)","v":30}]
["Ан-5",{"$f":"OFFSET(src!$C$1,MATCH($A8,src!$B:$B,0)+B$1,Svod!$C$2-src!$C$1,1,1)","v":54},{"$f":"OFFSET(src!$C$1,MATCH($A8,src!$B:$B,0)+C$1,Svod!$C$2-src!$C$1,1,1)","v":9},{"$f":"OFFSET(src!$C$1,MATCH($A8,src!$B:$B,0)+D$1,Svod!$C$2-src!$C$1,1,1)","v":55},{"$f":"OFFSET(src!$C$1,MATCH($A8,src!$B:$B,0)+E$1,Svod!$C$2-src!$C$1,1,1)","v":54},{"$f":"OFFSET(src!$C$1,MATCH($A8,src!$B:$B,0)+F$1,Svod!$C$2-src!$C$1,1,1)","v":20}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"uni_agregat(A4:A8,B2,C2)","v":{"$error":"#VALUE!"}}]

{"sheet":"src","index":1,"n_rows":28,"n_cols":26,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,5,1],[6,1,10,1],[11,1,15,1],[16,1,20,1],[21,1,25,1]]}
["Параметры","Данные","2017-09-01",{"$f":"C1+1","v":"2017-09-02"},{"$f":"D1+1","v":"2017-09-03"},"2017-09-04","2017-09-05","2017-09-06","2017-09-07","2017-09-08","2017-09-09","2017-09-10","2017-09-11","2017-09-12","2017-09-13","2017-09-14","2017-09-15","2017-09-16","2017-09-17","2017-09-18","2017-09-19","2017-09-20","2017-09-21","2017-09-22","2017-09-23","2017-09-24"]
["Пар_1","Ан-1",30,33,26,63,95,60,23,59,72,37,18,15,99,72,82,75,10,88,80,88,22,75,35,54]
["Пар_2",null,45,66,86,77,64,81,85,68,10,99,58,76,37,92,78,19,93,9,55,8,80,28,17,56]
["Пар_3",null,81,47,45,44,27,63,56,44,97,89,88,60,51,32,36,61,31,36,59,96,93,85,71,50]
["Пар_4",null,47,26,33,29,1,98,22,13,85,40,99,27,100,38,80,66,65,83,16,13,69,85,51,69]
["Пар_5",null,10,27,51,45,81,55,89,97,43,77,2,12,63,51,16,33,80,48,45,85,59,2,26,84]
["Пар_1","Ан-2",3,92,70,3,44,38,89,95,64,36,85,62,38,5,10,69,21,38,15,83,52,26,92,18]
["Пар_2",null,49,15,48,36,36,66,91,62,91,34,53,31,90,16,24,72,1,95,24,88,22,55,37,79]
["Пар_3",null,26,42,77,10,96,74,44,42,88,99,40,95,68,86,39,47,28,9,83,86,31,74,58,55]
["Пар_4",null,64,53,5,69,2,64,92,19,81,19,38,12,26,3,40,85,90,44,73,10,84,73,41,33]
["Пар_5",null,64,32,22,26,87,42,98,32,54,46,82,82,55,10,91,62,27,45,81,60,61,22,52,37]
["Пар_1","Ан-3",44,11,12,4,68,1,90,6,71,8,22,41,93,29,70,45,19,35,24,69,33,4,9,11]
["Пар_2",null,32,56,49,44,47,28,68,91,44,95,10,97,62,25,64,31,10,54,27,9,38,94,70,63]
["Пар_3",null,6,44,41,14,23,84,89,31,45,82,84,100,12,72,25,72,41,71,4,74,87,9,39,9]
["Пар_4",null,17,61,70,61,47,5,63,99,100,69,5,93,43,32,79,14,31,35,75,11,78,13,70,74]
["Пар_5",null,32,30,84,16,21,87,38,37,98,94,16,55,5,83,56,87,24,17,5,61,26,47,20,97]
["Пар_1","Ан-4",69,85,30,27,88,17,38,55,25,2,8,45,45,81,74,71,93,28,65,98,75,66,51,98]
["Пар_2",null,52,84,6,17,78,84,23,29,58,82,49,24,28,13,3,96,68,82,74,12,5,96,93,51]
["Пар_3",null,14,51,69,77,34,37,55,95,86,41,71,22,68,55,33,83,36,63,50,43,12,80,76,18]
["Пар_4",null,81,23,37,33,46,5,44,63,17,82,76,76,29,7,100,77,25,71,24,91,64,63,12,77]
["Пар_5",null,10,89,66,88,86,97,7,76,43,96,48,29,68,7,72,55,36,48,53,1,73,91,61,30]
["Пар_1","Ан-5",18,33,3,38,84,96,22,90,91,10,12,37,89,69,100,70,78,94,6,27,96,37,45,54]
["Пар_2",null,52,28,73,49,6,88,90,23,71,87,22,88,49,32,15,97,83,53,63,97,73,51,38,9]
["Пар_3",null,4,33,69,49,84,8,95,64,42,58,13,16,55,23,41,72,29,37,25,30,95,67,18,55]
["Пар_4",null,39,8,65,31,12,49,46,34,82,87,66,1,21,40,94,64,97,82,42,53,74,43,91,54]
["Пар_5",null,73,63,15,72,52,81,44,22,22,94,4,71,68,39,29,67,10,60,36,37,82,12,38,20]
[]
[null,null,{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),C$2:C26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),C$2:C26)),\"\")","v":164},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),D$2:D26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),D$2:D26)),\"\")","v":254},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),E$2:E26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),E$2:E26)),\"\")","v":141},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),F$2:F26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),F$2:F26)),\"\")","v":135},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),G$2:G26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),G$2:G26)),\"\")","v":379},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),H$2:H26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),H$2:H26)),\"\")","v":212},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),I$2:I26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),I$2:I26)),\"\")","v":262},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),J$2:J26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),J$2:J26)),\"\")","v":305},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),K$2:K26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),K$2:K26)),\"\")","v":323},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),L$2:L26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),L$2:L26)),\"\")","v":93},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),M$2:M26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),M$2:M26)),\"\")","v":145},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),N$2:N26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),N$2:N26)),\"\")","v":200},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),O$2:O26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),O$2:O26)),\"\")","v":364},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),P$2:P26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),P$2:P26)),\"\")","v":256},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),Q$2:Q26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),Q$2:Q26)),\"\")","v":336},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),R$2:R26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),R$2:R26)),\"\")","v":330},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),S$2:S26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),S$2:S26)),\"\")","v":221},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),T$2:T26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),T$2:T26)),\"\")","v":283},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),U$2:U26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),U$2:U26)),\"\")","v":190},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),V$2:V26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),V$2:V26)),\"\")","v":365},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),W$2:W26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),W$2:W26)),\"\")","v":278},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),X$2:X26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),X$2:X26)),\"\")","v":208},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),Y$2:Y26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),Y$2:Y26)),\"\")","v":232},{"$f":"IFERROR(IF(SUMPRODUCT(--($A2:$A$26=$A$2),Z$2:Z26)=0,\"\",SUMPRODUCT(--($A2:$A$26=$A$2),Z$2:Z26)),\"\")","v":235}]

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}