{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Ввод данных","График, таблица"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":3,"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":"Ввод данных","index":0,"n_rows":39,"n_cols":26,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[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,">800","800-400","400-200","200-100","100-60","60-40","40-20","20-10","10-5","5-2","2-1","1-0,5","0,5-0,25","0,25-0,1","0,1-0,05","0,05-0,01","0,01-0,002","<0,002",null,"суммы"]
["БС-7",", гл. отб., м -",16.2,null,null,null,null,null,null,null,null,null,null,1.8,2.8,16.5,25,16.3,25.1,11.9,0.6,null,{"$f":"SUM(D4:V4)","v":100}]
[null,", гл. отб., м -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:U5)","v":0}]
[null,", гл. отб., м -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,", гл. отб., м -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,", гл. отб., м -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,", гл. отб., м -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,", гл. отб., м -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,", гл. отб., м -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,", гл. отб., м -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D12:U12)","v":0}]
[null,", гл. отб., м -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D13:U13)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Данные для построения кумулятивной кривой"]
[null,null,"Ось абсцисс",null,800,400,200,100,60,40,20,10,5,2,1,0.5,0.25,0.1,0.05,0.01,2E-3,1E-3,null,null,null,50]
[null,null,"Ось ординат",null,{"$f":"F17+E4","v":100},100,100,100,100,100,100,100,100,100,98.2,95.4,78.900000000000006,53.900000000000006,37.6,12.5,0.6,{"$f":"V4","v":0},null,null,null,{"$f":"INDEX(N16:V16,MATCH(Z16,N17:V17,-1))-(INDEX(N17:V17,MATCH(Z16,N17:V17,-1))-Z16)/(INDEX(N17:V17,MATCH(Z16,N17:V17,-1))-INDEX(N17:V17,MATCH(Z16,N17:V17,-1)+1))*(INDEX(N16:V16,MATCH(Z16,N17:V17,-1))-INDEX(N16:V16,MATCH(Z16,N17:V17,-1)+1))","v":8.8036809815950912E-2}]
[null,null,"Ось ординат",null,{"$f":"F18+E5","v":0},{"$f":"G18+F5","v":0},{"$f":"H18+G5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V5","v":0}]
[null,null,"Ось ординат",null,{"$f":"F19+E6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Ось ординат",null,{"$f":"F20+E7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V20+U7","v":0},{"$f":"V7","v":0}]
[null,null,"Ось ординат",null,{"$f":"F21+E8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Ось ординат",null,{"$f":"F22+E9","v":0},{"$f":"G22+F9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Ось ординат",null,{"$f":"F23+E10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Ось ординат",null,{"$f":"F24+E11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Ось ординат",null,{"$f":"F25+E12","v":0},{"$f":"G25+F12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Ось ординат",null,{"$f":"F26+E13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"V13","v":0}]
[null,null,null,null,{"$f":"E17-$X$16","v":100},{"$f":"F17-$X$16","v":100},100,100,100,100,100,100,100,100,98.2,95.4,78.900000000000006,53.900000000000006,37.6,12.5,0.6,0]
[null,null,null,null,null,null,null,null,null,null,null,"Расчёт средневзвешенного диаметра зёрен"]
[null,"Сределогарифм. крупность фракций",null,null,{"$f":"10^((LOG(E16)+LOG(F16))/2)","v":565.68542494923838},282.84271247461919,141.42135623730957,77.45966692414838,48.989794855663568,28.284271247461909,14.142135623730955,7.0710678118654764,3.1622776601683795,1.4142135623730951,0.70710678118654746,0.35355339059327373,0.15811388300841889,7.0710678118654738E-2,2.236067977499789E-2,4.4721359549995789E-3,1.4142135623730942E-3,0]
[null,"Средневзвешенный диаметр зёрен Dв, мм",null,null,null,null,{"$f":"A4","v":"БС-7"},{"$f":"ROUND(($E$29*E4+$F$29*F4+$G$29*G4+$H$29*H4+$I$29*I4+$J$29*J4+$K$29*K4+$L$29*L4+$M$29*M4+$N$29*N4+$O$29*O4+$P$29*P4+$Q$29*Q4+$R$29*R4+$S$29*S4+$T$29*T4+$U$29*U4)/100,2)","v":0.16}]
[null,"Средневзвешенный диаметр зёрен Dв, мм",null,null,null,null,0,{"$f":"ROUND(($E$29*E5+$F$29*F5+$G$29*G5+$H$29*H5+$I$29*I5+$J$29*J5+$K$29*K5+$L$29*L5+$M$29*M5+$N$29*N5+$O$29*O5+$P$29*P5+$Q$29*Q5+$R$29*R5+$S$29*S5+$T$29*T5+$U$29*U5)/100,2)","v":0}]
[null,"Средневзвешенный диаметр зёрен Dв, мм",null,null,null,null,0,0]
[null,"Средневзвешенный диаметр зёрен Dв, мм",null,null,null,null,0,0]
[null,"Средневзвешенный диаметр зёрен Dв, мм",null,null,null,null,0,0]
[null,"Средневзвешенный диаметр зёрен Dв, мм",null,null,null,null,0,0]
[null,"Средневзвешенный диаметр зёрен Dв, мм",null,null,null,null,0,0]
[null,"Средневзвешенный диаметр зёрен Dв, мм",null,null,null,null,0,{"$f":"ROUND(($E$29*E11+$F$29*F11+$G$29*G11+$H$29*H11+$I$29*I11+$J$29*J11+$K$29*K11+$L$29*L11+$M$29*M11+$N$29*N11+$O$29*O11+$P$29*P11+$Q$29*Q11+$R$29*R11+$S$29*S11+$T$29*T11+$U$29*U11)/100,2)","v":0}]
[null,"Средневзвешенный диаметр зёрен Dв, мм",null,null,null,null,0,{"$f":"ROUND(($E$29*E12+$F$29*F12+$G$29*G12+$H$29*H12+$I$29*I12+$J$29*J12+$K$29*K12+$L$29*L12+$M$29*M12+$N$29*N12+$O$29*O12+$P$29*P12+$Q$29*Q12+$R$29*R12+$S$29*S12+$T$29*T12+$U$29*U12)/100,2)","v":0}]
[null,"Средневзвешенный диаметр зёрен Dв, мм",null,null,null,null,0,{"$f":"ROUND(($E$29*E13+$F$29*F13+$G$29*G13+$H$29*H13+$I$29*I13+$J$29*J13+$K$29*K13+$L$29*L13+$M$29*M13+$N$29*N13+$O$29*O13+$P$29*P13+$Q$29*Q13+$R$29*R13+$S$29*S13+$T$29*T13+$U$29*U13)/100,2)","v":0}]

{"sheet":"График, таблица","index":1,"n_rows":42,"n_cols":23,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Данные гранулометрического анализа"]
["Наим-ние ","Глубина ",null,null,null,null,null,null,null,null,null,"Размеры фракций в мм, содержание в %",null,null,null,null,null,null,null,null,"Средневзвешен-","Медианный","Коэффициент"]
["выработок","отбора",">800","800-","400-","200-","100-","60-","40-","20-","10-","5-","2-","1-","0,5-","0,25-","0,1-","0,05-","0,01-","<0,001","ный диаметр","диаметр","неоднородности"]
[null,"пробы, м",null,"400","200","100","60","40","20","10","5","2","1","0,5","0,25","0,1","0,05","0,01","0,002",null,"Dв, мм","Мd, мм","d60/d10"]
[{"$f":"'Ввод данных'!A4","v":"БС-7"},{"$f":"'Ввод данных'!C4","v":16.2},{"$f":"'Ввод данных'!D4","v":0},{"$f":"'Ввод данных'!E4","v":0},{"$f":"'Ввод данных'!F4","v":0},{"$f":"'Ввод данных'!G4","v":0},{"$f":"'Ввод данных'!H4","v":0},{"$f":"'Ввод данных'!I4","v":0},{"$f":"'Ввод данных'!J4","v":0},{"$f":"'Ввод данных'!K4","v":0},{"$f":"'Ввод данных'!L4","v":0},{"$f":"'Ввод данных'!M4","v":0},{"$f":"'Ввод данных'!N4","v":1.8},{"$f":"'Ввод данных'!O4","v":2.8},{"$f":"'Ввод данных'!P4","v":16.5},{"$f":"'Ввод данных'!Q4","v":25},{"$f":"'Ввод данных'!R4","v":16.3},{"$f":"'Ввод данных'!S4","v":25.1},{"$f":"'Ввод данных'!T4","v":11.9},{"$f":"'Ввод данных'!U4","v":0.6},{"$f":"'Ввод данных'!H30","v":0.16},8.7999999999999995E-2]
[{"$f":"'Ввод данных'!A5","v":0},{"$f":"'Ввод данных'!C5","v":0},{"$f":"'Ввод данных'!D5","v":0},{"$f":"'Ввод данных'!E5","v":0},{"$f":"'Ввод данных'!F5","v":0},{"$f":"'Ввод данных'!G5","v":0},{"$f":"'Ввод данных'!H5","v":0},{"$f":"'Ввод данных'!I5","v":0},{"$f":"'Ввод данных'!J5","v":0},{"$f":"'Ввод данных'!K5","v":0},{"$f":"'Ввод данных'!L5","v":0},{"$f":"'Ввод данных'!M5","v":0},{"$f":"'Ввод данных'!N5","v":0},{"$f":"'Ввод данных'!O5","v":0},{"$f":"'Ввод данных'!P5","v":0},{"$f":"'Ввод данных'!Q5","v":0},{"$f":"'Ввод данных'!R5","v":0},{"$f":"'Ввод данных'!S5","v":0},{"$f":"'Ввод данных'!T5","v":0},{"$f":"'Ввод данных'!U5","v":0},{"$f":"'Ввод данных'!H31","v":0}]
[{"$f":"'Ввод данных'!A6","v":0},{"$f":"'Ввод данных'!C6","v":0},{"$f":"'Ввод данных'!D6","v":0},{"$f":"'Ввод данных'!E6","v":0},{"$f":"'Ввод данных'!F6","v":0},{"$f":"'Ввод данных'!G6","v":0},{"$f":"'Ввод данных'!H6","v":0},{"$f":"'Ввод данных'!I6","v":0},{"$f":"'Ввод данных'!J6","v":0},{"$f":"'Ввод данных'!K6","v":0},{"$f":"'Ввод данных'!L6","v":0},{"$f":"'Ввод данных'!M6","v":0},{"$f":"'Ввод данных'!N6","v":0},{"$f":"'Ввод данных'!O6","v":0},{"$f":"'Ввод данных'!P6","v":0},{"$f":"'Ввод данных'!Q6","v":0},{"$f":"'Ввод данных'!R6","v":0},{"$f":"'Ввод данных'!S6","v":0},{"$f":"'Ввод данных'!T6","v":0},{"$f":"'Ввод данных'!U6","v":0},{"$f":"'Ввод данных'!H32","v":0}]
[{"$f":"'Ввод данных'!A7","v":0},{"$f":"'Ввод данных'!C7","v":0},{"$f":"'Ввод данных'!D7","v":0},{"$f":"'Ввод данных'!E7","v":0},{"$f":"'Ввод данных'!F7","v":0},{"$f":"'Ввод данных'!G7","v":0},{"$f":"'Ввод данных'!H7","v":0},{"$f":"'Ввод данных'!I7","v":0},{"$f":"'Ввод данных'!J7","v":0},{"$f":"'Ввод данных'!K7","v":0},{"$f":"'Ввод данных'!L7","v":0},{"$f":"'Ввод данных'!M7","v":0},{"$f":"'Ввод данных'!N7","v":0},{"$f":"'Ввод данных'!O7","v":0},{"$f":"'Ввод данных'!P7","v":0},{"$f":"'Ввод данных'!Q7","v":0},{"$f":"'Ввод данных'!R7","v":0},{"$f":"'Ввод данных'!S7","v":0},{"$f":"'Ввод данных'!T7","v":0},{"$f":"'Ввод данных'!U7","v":0},{"$f":"'Ввод данных'!H33","v":0}]
[{"$f":"'Ввод данных'!A8","v":0},{"$f":"'Ввод данных'!C8","v":0},{"$f":"'Ввод данных'!D8","v":0},{"$f":"'Ввод данных'!E8","v":0},{"$f":"'Ввод данных'!F8","v":0},{"$f":"'Ввод данных'!G8","v":0},{"$f":"'Ввод данных'!H8","v":0},{"$f":"'Ввод данных'!I8","v":0},{"$f":"'Ввод данных'!J8","v":0},{"$f":"'Ввод данных'!K8","v":0},{"$f":"'Ввод данных'!L8","v":0},{"$f":"'Ввод данных'!M8","v":0},{"$f":"'Ввод данных'!N8","v":0},{"$f":"'Ввод данных'!O8","v":0},{"$f":"'Ввод данных'!P8","v":0},{"$f":"'Ввод данных'!Q8","v":0},{"$f":"'Ввод данных'!R8","v":0},{"$f":"'Ввод данных'!S8","v":0},{"$f":"'Ввод данных'!T8","v":0},{"$f":"'Ввод данных'!U8","v":0},{"$f":"'Ввод данных'!H34","v":0}]
[{"$f":"'Ввод данных'!A9","v":0},{"$f":"'Ввод данных'!C9","v":0},{"$f":"'Ввод данных'!D9","v":0},{"$f":"'Ввод данных'!E9","v":0},{"$f":"'Ввод данных'!F9","v":0},{"$f":"'Ввод данных'!G9","v":0},{"$f":"'Ввод данных'!H9","v":0},{"$f":"'Ввод данных'!I9","v":0},{"$f":"'Ввод данных'!J9","v":0},{"$f":"'Ввод данных'!K9","v":0},{"$f":"'Ввод данных'!L9","v":0},{"$f":"'Ввод данных'!M9","v":0},{"$f":"'Ввод данных'!N9","v":0},{"$f":"'Ввод данных'!O9","v":0},{"$f":"'Ввод данных'!P9","v":0},{"$f":"'Ввод данных'!Q9","v":0},{"$f":"'Ввод данных'!R9","v":0},{"$f":"'Ввод данных'!S9","v":0},{"$f":"'Ввод данных'!T9","v":0},{"$f":"'Ввод данных'!U9","v":0},{"$f":"'Ввод данных'!H35","v":0}]
[{"$f":"'Ввод данных'!A10","v":0},{"$f":"'Ввод данных'!C10","v":0},{"$f":"'Ввод данных'!D10","v":0},{"$f":"'Ввод данных'!E10","v":0},{"$f":"'Ввод данных'!F10","v":0},{"$f":"'Ввод данных'!G10","v":0},{"$f":"'Ввод данных'!H10","v":0},{"$f":"'Ввод данных'!I10","v":0},{"$f":"'Ввод данных'!J10","v":0},{"$f":"'Ввод данных'!K10","v":0},{"$f":"'Ввод данных'!L10","v":0},{"$f":"'Ввод данных'!M10","v":0},{"$f":"'Ввод данных'!N10","v":0},{"$f":"'Ввод данных'!O10","v":0},{"$f":"'Ввод данных'!P10","v":0},{"$f":"'Ввод данных'!Q10","v":0},{"$f":"'Ввод данных'!R10","v":0},{"$f":"'Ввод данных'!S10","v":0},{"$f":"'Ввод данных'!T10","v":0},{"$f":"'Ввод данных'!U10","v":0},{"$f":"'Ввод данных'!H36","v":0}]
[{"$f":"'Ввод данных'!A11","v":0},{"$f":"'Ввод данных'!C11","v":0},{"$f":"'Ввод данных'!D11","v":0},{"$f":"'Ввод данных'!E11","v":0},{"$f":"'Ввод данных'!F11","v":0},{"$f":"'Ввод данных'!G11","v":0},{"$f":"'Ввод данных'!H11","v":0},{"$f":"'Ввод данных'!I11","v":0},{"$f":"'Ввод данных'!J11","v":0},{"$f":"'Ввод данных'!K11","v":0},{"$f":"'Ввод данных'!L11","v":0},{"$f":"'Ввод данных'!M11","v":0},{"$f":"'Ввод данных'!N11","v":0},{"$f":"'Ввод данных'!O11","v":0},{"$f":"'Ввод данных'!P11","v":0},{"$f":"'Ввод данных'!Q11","v":0},{"$f":"'Ввод данных'!R11","v":0},{"$f":"'Ввод данных'!S11","v":0},{"$f":"'Ввод данных'!T11","v":0},{"$f":"'Ввод данных'!U11","v":0},{"$f":"'Ввод данных'!H37","v":0}]
[{"$f":"'Ввод данных'!A12","v":0},{"$f":"'Ввод данных'!C12","v":0},{"$f":"'Ввод данных'!D12","v":0},{"$f":"'Ввод данных'!E12","v":0},{"$f":"'Ввод данных'!F12","v":0},{"$f":"'Ввод данных'!G12","v":0},{"$f":"'Ввод данных'!H12","v":0},{"$f":"'Ввод данных'!I12","v":0},{"$f":"'Ввод данных'!J12","v":0},{"$f":"'Ввод данных'!K12","v":0},{"$f":"'Ввод данных'!L12","v":0},{"$f":"'Ввод данных'!M12","v":0},{"$f":"'Ввод данных'!N12","v":0},{"$f":"'Ввод данных'!O12","v":0},{"$f":"'Ввод данных'!P12","v":0},{"$f":"'Ввод данных'!Q12","v":0},{"$f":"'Ввод данных'!R12","v":0},{"$f":"'Ввод данных'!S12","v":0},{"$f":"'Ввод данных'!T12","v":0},{"$f":"'Ввод данных'!U12","v":0},{"$f":"'Ввод данных'!H38","v":0}]
[{"$f":"'Ввод данных'!A13","v":0},{"$f":"'Ввод данных'!C13","v":0},{"$f":"'Ввод данных'!D13","v":0},{"$f":"'Ввод данных'!E13","v":0},{"$f":"'Ввод данных'!F13","v":0},{"$f":"'Ввод данных'!G13","v":0},{"$f":"'Ввод данных'!H13","v":0},{"$f":"'Ввод данных'!I13","v":0},{"$f":"'Ввод данных'!J13","v":0},{"$f":"'Ввод данных'!K13","v":0},{"$f":"'Ввод данных'!L13","v":0},{"$f":"'Ввод данных'!M13","v":0},{"$f":"'Ввод данных'!N13","v":0},{"$f":"'Ввод данных'!O13","v":0},{"$f":"'Ввод данных'!P13","v":0},{"$f":"'Ввод данных'!Q13","v":0},{"$f":"'Ввод данных'!R13","v":0},{"$f":"'Ввод данных'!S13","v":0},{"$f":"'Ввод данных'!T13","v":0},{"$f":"'Ввод данных'!U13","v":0},{"$f":"'Ввод данных'!H39","v":0}]