{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист2","база"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":17,"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":"Лист2","index":0,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,0,19,1],[19,3,19,5],[3,0,3,1],[17,0,17,1],[17,3,17,5],[18,0,18,1],[18,3,18,5]]}
[]
[null,null,"Таблица длинная…"]
[]
["Шифр",null,"Название","Ед. изм.","Кол-во","Цена","Стоимость"]
["2-36",null,"Раб 2-36","шт.",1,{"$f":"VLOOKUP(A5,база!A4:G34,6,0)","v":42},{"$f":"E5*F5","v":42}]
[null,"309","мат 2-36","шт.",{"$f":"E5*0.08","v":0.08},494,{"$f":"E6*F6","v":39.520000000000003}]
["2-37",null,"Раб 2-37","шт.",1,{"$f":"VLOOKUP(A7,база!A7:G36,6,0)","v":78},{"$f":"E7*F7","v":78}]
[null,"309","мат 2-37","шт.",{"$f":"E7*0.12","v":0.12},494,{"$f":"E8*F8","v":59.28}]
["2-45",null,"Раб 2-45","шт.",2,{"$f":"VLOOKUP(A9,база!A9:G38,6,0)","v":156},156]
[null,"190","мат 2-45","шт.",{"$f":"E9","v":2},488,{"$f":"E10*F10","v":976}]
["2-46",null,"Раб 2-46","шт.",1,{"$f":"VLOOKUP(A11,база!A11:G40,6,0)","v":169},169]
[null,"190","мат 2-46","шт.",{"$f":"E11*1.5","v":1.5},488,732]
["2-47",null,"Раб 2-47","шт.",1,{"$f":"VLOOKUP(A13,база!A13:G42,6,0)","v":208},208]
[null,"190","мат 2-47","шт.",{"$f":"E13*1.8","v":1.8},488,878.4]
["2-41",null,"Раб 2-41","шт.",1,{"$f":"VLOOKUP(A15,база!A15:G44,6,0)","v":169},169]
[null,"190","мат 2-41","шт.",{"$f":"E15*0.2","v":0.2},488,97.600000000000009]
[{"$f":"_2_44","v":{"$error":"#VALUE!"}}]
[null,null,"работа:",null,null,null,{"$f":"SUM(G5,G7,G9,G11,G13,G15)","v":822}]
[null,null,"материалы:",null,null,null,{"$f":"SUM(G6,G8,G10,G12,G14,G16)","v":2782.7999999999997}]
[null,null,"всего:",null,null,null,{"$f":"SUM(G18:G19)","v":3604.7999999999997}]

{"sheet":"база","index":1,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"отрывок базы данных"]
[]
["2-36",null,"Раб 2-36","шт.",1,42,{"$f":"E4*F4","v":42}]
[null,"309","материал","шт.",{"$f":"E4*0.08","v":0.08},494,39.520000000000003]
[null,"1311","материал","шт.",{"$f":"E5*0.08","v":6.4000000000000003E-3},494,{"$f":"E6*F6","v":3.1616}]
["2-37",null,"Раб 2-37","шт.",1,78,78]
[null,"309","материал","шт.",{"$f":"E7*0.12","v":0.12},494,59.28]
["2-38",null,"Раб 2-38","шт.",1,110,110]
[null,"190","материал","шт.",{"$f":"E9*0.15","v":0.15},488,73.2]
["2-39",null,"Раб 2-39","шт.",1,78,78]
[null,"309","материал","шт.",{"$f":"E11*0.12","v":0.12},494,59.28]
["2-40",null,"Раб 2-40","шт.",1,109,109]
[null,"309","материал","шт.",{"$f":"E13*0.15","v":0.15},494,74.099999999999994]
["2-41",null,"Раб 2-41","шт.",1,169,169]
[null,"190","материал","шт.",{"$f":"E15*0.2","v":0.2},488,97.600000000000009]
["2-42",null,"Раб 2-42","шт.",1,65,65]
[null,"190","материал","шт.",{"$f":"E17*0.2","v":0.2},488,97.600000000000009]
["2-43",null,"Раб 2-43","шт.",1,130,130]
[null,"190","материал","шт.",{"$f":"E19*0.3","v":0.3},488,146.4]
["2-44",null,"Раб 2-44","шт.",1,156,156]
[null,"1119","материал","шт.",{"$f":"E21*1.8","v":1.8},488,{"$f":"E22*F22","v":878.4}]
[null,"190","материал","шт.",{"$f":"E21*0.35","v":0.35},488,170.79999999999998]
["2-45",null,"Раб 2-45","шт.",1,156,156]
[null,"190","материал","шт.",{"$f":"E24","v":1},488,488]
["2-46",null,"Раб 2-46","шт.",1,169,169]
[null,"190","материал","шт.",{"$f":"E26*1.5","v":1.5},488,732]
["2-47",null,"Раб 2-47","шт.",1,208,208]
[null,"190","материал","шт.",{"$f":"E28*1.8","v":1.8},488,878.4]
["2-48",null,"Раб 2-48","шт.",1,168,168]
[null,"190","материал","шт.",{"$f":"E30*1.8","v":1.8},488,878.4]
["2-49",null,"Раб 2-49","шт.",1,208,208]
[null,"190","материал","шт.",{"$f":"E32*2.5","v":2.5},488,1220]
["2-50",null,"Раб 2-50","шт.",1,273,273]