{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Закупка","Склад"],"not_rendered":{"charts":0,"images":2,"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":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,1,8,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[20,1,20,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[25,4,25,5],[25,6,25,7]]}
[]
[null,null,null,null,null,"ДАТА"]
[]
[]
[null,"Зап. Части",null,null,"Кол-во","Цена","Сумма"]
[]
[]
[]
[null,null,null,null,null,{"$f":"VLOOKUP(B9,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F9),0,E9*F9)","v":0}]
[null,null,null,null,null,{"$f":"VLOOKUP(B10,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B11,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B12,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B13,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B14,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B15,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B16,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B17,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B18,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B19,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B20,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B21,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B22,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B23,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,{"$f":"VLOOKUP(B24,Склад!A$2:D$500,4,FALSE)","v":{"$error":"#N/A"}},0]
[]
[null,null,null,null,"ИТОГО",null,{"$f":"SUM(G6:G24)","v":0}]

{"sheet":"Склад","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,6,3,8]]}
["Наименование","Кол-во","Ед.изм.","Цена","Сумма"]
["Гвозди",50,"шт.",5,{"$f":"B2*D2","v":250},null,"Всего запчастей на сумму:"]
["Какашки",25,"шт.",3,75,null,{"$f":"SUM(E2:E400)","v":28311}]
["Компрессор",2,"шт.",3000,6000]
["Конденсатор",76,"шт.",86,6536]
["Масляный фильтр",19,"шт.",250,4750]
["Миномет",1,"шт.",2500,2500]
["Отвертка",15,"шт.",100,1500]
["Припой",40,"шт.",30,1200]
["Терморегулятор",2,"шт.",650,1300]
["Фантики",100,"шт.",2,200]
["Фреон",20,"л.",200,4000]