{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Справочник цен","Сделки"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Контрагент","Дата","Базовая цена","Расчетная цена",null,"Контрагент"]
["Контрагент1","2015-01-01",20,"=C+D+E+F",null,"Контрагент1"]
["Контрагент2","2015-01-01",21,"=C+D+E",null,"Контрагент2"]
["Контрагент3","2015-01-01",22,"=C+D+E",null,"Контрагент3"]
["Контрагент4","2015-01-01",23,"=C+D+E+F",null,"Контрагент4"]
["Контрагент5","2015-01-01",24,"=C+D+E+F",null,"Контрагент5"]
["Контрагент6","2015-01-01",25,"=C+D+E+F",null,"Контрагент6"]
["Контрагент7","2015-01-01",26,"=C+D+E",null,"Контрагент7"]
["Контрагент1","2015-07-15",27,"=C+D+E"]
["Контрагент2","2015-07-15",28,"=C+D/E+F"]
["Контрагент3","2015-07-15",29,"=C+D/E+F"]
["Контрагент4","2015-07-15",30,"=C+D/E+F"]
["Контрагент5","2015-07-15",31,"=C+D/E+F"]
["Контрагент6","2015-07-15",32,"=C+D/E+F"]
["Контрагент7","2015-07-15",33,"=C+D/E+F"]
["Контрагент1","2015-07-27",34,"=C+D*E+F"]
["Контрагент2","2015-07-27",35,"=C+D*E+F"]
["Контрагент3","2015-07-27",36,"=C+D*E+F"]
["Контрагент4","2015-07-27",37,"=C+D*E+F"]
["Контрагент5","2015-07-27",38,"=C+D*E+F"]
["Контрагент6","2015-07-27",39,"=C+D*E+F"]
["Контрагент7","2015-07-27",40,"=C+D*E+F"]

{"sheet":"Сделки","index":1,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Дата","Поставщик","Базовая цена","Параметр1","Параметр2","Параметр3","Расчетная цена","Расчетная цена",null,"Проверка"]
["2015-07-20","Контрагент4",{"$f":"LOOKUP(,-1/('Справочник цен'!A$2:A$99=B2)/('Справочник цен'!B$2:B$99<=A2),'Справочник цен'!C$2:C$99)","v":30},5,4,6,{"$f":"LOOKUP(,-1/('Справочник цен'!A$2:A$99=B2)/('Справочник цен'!B$2:B$99<=A2),'Справочник цен'!D$2:D$99)","v":"=C+D/E+F"},{"$f":"РасчЦена","v":37.25},null,{"$f":"C2+D2/E2+F2","v":37.25}]
["2015-05-05","Контрагент6",{"$f":"LOOKUP(,-1/('Справочник цен'!A$2:A$99=B3)/('Справочник цен'!B$2:B$99<=A3),'Справочник цен'!C$2:C$99)","v":25},4,2,3,{"$f":"LOOKUP(,-1/('Справочник цен'!A$2:A$99=B3)/('Справочник цен'!B$2:B$99<=A3),'Справочник цен'!D$2:D$99)","v":"=C+D+E+F"},{"$f":"РасчЦена","v":34},null,{"$f":"C3+D3+E3+F3","v":34}]