{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Прайс","Заказ","Операция"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["id","название","цена"]
[1,"Лебедка ЛБУ-1200Д",8300000]
[2,"Лебедка ЛБУ-1200",4900000]
[3,"Привод ротор в сборе",1500000]
[4,"Крюкоблок УТБК-6-320",2500000]
[5,"Талевый блок-5-20",500000]
[6,"Крюкоблок УТБК-5-225",1200000]
[7,"Насос УНБ-600 (без шкива)",2800000]
[8,"Насос УНБТ-950 (без шкива)",7000000]
[9,"Коробка передач КПЦ-700",800000]
[10,"Коробка передач КПЗ-900",1500000]
[11,"Ротор Р-700",1300000]
[12,"Ротор Р-560",900000]
[13,"Кронблок УТБК-7-400",1700000]
[14,"Вертлюг УВ-250",600000]
[15,"Вертлюг УВ-320",1700000]
[16,"Ключ буровой АКБ-3М2",1000000]
[17,"Ключ буровой АКБ-4",1700000]
[18,"Крюкоблок 5-170",700000]
[19,"Насос унб-600",1100000]
[20,"КШМ УНБ-600",700000]
[21,"КШМ УНБТ-950",4000000]
[22,"Гидрокоробки УНБ-600",250000]
[23,"Втулка шатуна бронзовая",7000]
[24,"Буровая установка 3Д76",32000000]
[25,"Лебёдка ЛБУ-1200",140000000]

{"sheet":"Заказ","index":1,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Номер заказа",243]
["id",{"$f":"INDEX(Прайс!$A$2:$A$1000,MATCH(Заказ!$B$4,Прайс!$B$2:$B$1000,0))","v":13}]
["дата","2016-10-06"]
["товар","Кронблок УТБК-7-400"]
["кол-во",7]
["цена",{"$f":"IFERROR(VLOOKUP(B4,Прайс!B2:цена,2,0)*B5,\"\")","v":11900000}]
["скидка (>=5 штук 2%, >=10 штук 5% )",{"$f":"IF(B5>=10,B6*0.05,IF(AND(B5<=9,B5>=5),B6*0.02,\"Скидки нет\"))","v":238000}]
["итого:",{"$f":"IFERROR(B6-B7,B6)","v":11662000}]

{"sheet":"Операция","index":2,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"id","дата","товар","количество","Сумма"]
[1,13,"2016-09-21","Кронблок УТБК-7-400",9,14994000]
[2,13,"2016-09-21","Кронблок УТБК-7-400",7,11662000]
[3,13,"2016-09-21","Кронблок УТБК-7-400",7,11662000]
[3,13,"2016-10-06","Кронблок УТБК-7-400",7,11662000]
[243,13,"2016-10-06","Кронблок УТБК-7-400",7,11662000]