{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Прайс","Себестоимость","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Название","Цена"]
["Резистор 1,1 ом",1.23]
["Резистор 2 ом",2.11,null,"Заменить на Резистор 2.2 ом"]
["Резистор 3 ом",4.22]
["Резистор 3.3 ом",5.32]
["Резистор 5.6 ом",6.84]
["Резистор 6.9 ом",2.66]
["Плата МК-16",50,null,"Заменить на плату МВ-01"]
["Микросхема 8962",35.36]
["Транзистор 2232",12.58]
["Драйвер 996",39.700000000000003]

{"sheet":"Себестоимость","index":1,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Изделие 1","Кол-во","Цена","Сумма"]
["Резистор 1,1 ом",2,{"$f":"IFERROR(VLOOKUP(A2,Прайс!$A$2:$B$70,2,0),\"\")","v":1.23},{"$f":"IFERROR(C2*B2,\"\")","v":2.46}]
["Резистор 5.6 ом",2,{"$f":"IFERROR(VLOOKUP(A3,Прайс!$A$2:$B$70,2,0),\"\")","v":6.84},{"$f":"IFERROR(C3*B3,\"\")","v":13.68}]
["Микросхема 8962",1,{"$f":"IFERROR(VLOOKUP(A4,Прайс!$A$2:$B$70,2,0),\"\")","v":35.36},35.36]
["Транзистор 2232",3,{"$f":"IFERROR(VLOOKUP(A5,Прайс!$A$2:$B$70,2,0),\"\")","v":12.58},37.74]
[null,null,{"$f":"IFERROR(VLOOKUP(A6,Прайс!$A$2:$B$70,2,0),\"\")","v":""},""]
["Изделие 2",null,{"$f":"IFERROR(VLOOKUP(A7,Прайс!$A$2:$B$70,2,0),\"\")","v":""},""]
["Резистор 2 ом",1,{"$f":"IFERROR(VLOOKUP(A8,Прайс!$A$2:$B$70,2,0),\"\")","v":2.11},2.11]
["Резистор 3 ом",11,{"$f":"IFERROR(VLOOKUP(A9,Прайс!$A$2:$B$70,2,0),\"\")","v":4.22},46.419999999999995]
["Резистор 5.6 ом",1,{"$f":"IFERROR(VLOOKUP(A10,Прайс!$A$2:$B$70,2,0),\"\")","v":6.84},6.84]
["Плата МК-16",2,{"$f":"IFERROR(VLOOKUP(A11,Прайс!$A$2:$B$70,2,0),\"\")","v":50},100]
["Резистор 5.6 ом",4,{"$f":"IFERROR(VLOOKUP(A12,Прайс!$A$2:$B$70,2,0),\"\")","v":6.84},27.36]
[null,null,{"$f":"IFERROR(VLOOKUP(A13,Прайс!$A$2:$B$70,2,0),\"\")","v":""},""]
["Изделие 3",null,{"$f":"IFERROR(VLOOKUP(A14,Прайс!$A$2:$B$70,2,0),\"\")","v":""},""]
["Драйвер 996",1,{"$f":"IFERROR(VLOOKUP(A15,Прайс!$A$2:$B$70,2,0),\"\")","v":39.700000000000003},39.700000000000003]
["Плата МК-16",3,{"$f":"IFERROR(VLOOKUP(A16,Прайс!$A$2:$B$70,2,0),\"\")","v":50},150]
["ИТОГО",null,null,{"$f":"SUM(D2:D15)","v":311.67}]

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}