{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["В7,5","В15","Лист2","ОТЧЕТ"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":11,"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":"В7,5","index":0,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,5,4,6],[0,4,0,36],[5,33,5,36]]}
["№пп","Дата","Ri (Мпа)",null,"РБУ № 1"]
[1,"2017-05-25",8.5]
[2,"2017-05-25",8.5500000000000007]
[3,"2017-06-08",11.875]
[4,"2017-06-08",13.395]
[5,"2017-06-09",16.53]
[6,"2017-06-09",17.004999999999999]
[7,"2017-06-15",9.07]
[8,"2017-08-19",9.15]
[9,"2017-08-20",12.065]
[10,"2017-08-21",15.01]
[11,"2017-08-22",8]
[12,"2017-08-22",8.35]
[13,"2017-09-15",9]
[14,"2017-09-16",8.59]
[15,"2017-09-17",9.7850000000000001]
[16,"2017-09-18",9.2149999999999999]
[17,"2017-09-19",7.68]
[18,"2017-10-05",7.73]
[19,"2017-10-07",9.4049999999999994]
[20,"2017-10-09",10.83]
[21,"2017-10-11",9.0250000000000004]
[22,"2017-10-13",9.1199999999999992]
[23,"2017-10-15",11.494999999999999]
[24,"2017-11-11",13.015000000000001]
[25,"2017-11-12",8.2650000000000006]
[26,"2017-11-13",7.98]
[27,"2017-11-14",8]
[28,"2017-12-14",7.96]
[29,"2017-12-15",8.56]
[30,"2017-12-16",7.7]
[31,"2017-12-17",9.1300000000000008]
[32,"2017-12-18",9]

{"sheet":"В15","index":1,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["№пп","Дата","Ri (Мпа)"]
[1,"2017-05-25",15]
[2,"2017-05-25",16]
[3,"2017-06-08",11.875]
[4,"2017-06-08",13.395]
[5,"2017-06-09",16.53]
[6,"2017-06-09",17.004999999999999]
[7,"2017-06-15",9.07]
[8,"2017-08-19",28]
[9,"2017-08-20",37]
[10,"2017-08-21",15.01]
[11,"2017-08-22",8]
[12,"2017-08-23",8.35]
[13,"2017-09-15",9]
[14,"2017-09-16",42]
[15,"2017-09-17",26]
[16,"2017-09-18",19]
[17,"2017-09-19",7.68]
[18,"2017-10-05",7.73]
[19,"2017-10-07",9.4049999999999994]
[20,"2017-10-09",3]
[21,"2017-10-11",9.0250000000000004]
[22,"2017-10-13",9.1199999999999992]
[23,"2017-10-15",11.494999999999999]
[24,"2017-11-11",13.015000000000001]
[25,"2017-11-12",2]
[26,"2017-11-13",1]
[27,"2017-11-14",8]
[28,"2017-12-14",7.96]
[29,"2017-12-15",8.56]
[30,"2017-12-16",7.7]
[31,"2017-12-17",9.1300000000000008]
[32,"2017-12-18",9]

{"sheet":"Лист2","index":2,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,null,"Схема А"]
[null,null,"Схема Б"]
[null,null,"Схема Г"]

{"sheet":"ОТЧЕТ","index":3,"n_rows":33,"n_cols":34,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,1,null,null,2,null,null,{"$f":"MATCH(E3+91,INDIRECT(\"'\"&C3&\"'!B2:B33\"))","v":7}]
[null,"Класс:","В15",null,"2017-05-05"]
[]
[null,"Rу",8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006,8.2657500000000006]
[null,"Rв.п.г.",8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052,8.5502408736495052]
[null,"Rт",8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004,8.0250000000000004]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"УСЛОВИЕ"]
[null,null,1,"ЕСЛИ в ячейке (сейчас C3 выделена желтым цветом) будет указано В15 то график строится на основании данных с листа (в будущем с листов В25; В30;В22,5 и т.д) "]
[null,null,null,"Т.е. берутся значения из таблицы указанного листа (к примеру В15) столбец ДАТА и Ri (Мпа)"]
[null,null,2,"ЕСЛИ в ячейке (сейчас E3 выделена желтым цветом) будет указано дата то к этой дате прибавляем ТРИ месяца"]
[null,null,null,"Это второе условие для построения данного графика"]