{"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":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,1,19,2],[19,4,19,6],[3,1,3,2],[17,1,17,2],[17,4,17,6],[18,1,18,2],[18,4,18,6]]}
[]
[null,null,null,"Таблица длинная…"]
[]
["маленький допстолб","Шифр",null,"Название","Ед. изм.","Кол-во","Цена","Стоимость"]
[{"$f":"IF(IFERROR(MATCH(\"*\",INDEX(база!$A$1:$A$18752,MATCH(VLOOKUP(\"我我\",B$5:B5,1,1),база!$A$1:$A$18752,)+1):'база'!$A$18752,),MATCH(\"我我\",база!C:C,1)-MATCH(\"我我\",база!A:A,1)+1)>=(ROW()-MATCH(\"我我\",B$1:B5,1)+1),IFERROR(MATCH(B5,база!$A$1:$A$18752,),A4+1),\"\")","v":4},"2-36",{"$f":"IFERROR(INDEX(база!B$1:B$19371,$A5)&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(база!C$1:C$19371,$A5)&\"\",\"\")","v":"Раб 2-36"},{"$f":"IFERROR(INDEX(база!D$1:D$19371,$A5)&\"\",\"\")","v":"шт."},{"$f":"IFERROR(INDEX(база!E$1:E$19371,$A5),\"\")","v":1},{"$f":"IFERROR(INDEX(база!F$1:F$19371,$A5),\"\")","v":42},{"$f":"IFERROR(INDEX(база!G$1:G$19371,$A5),\"\")","v":42}]
[{"$f":"IF(IFERROR(MATCH(\"*\",INDEX(база!$A$1:$A$18752,MATCH(VLOOKUP(\"我我\",B$5:B6,1,1),база!$A$1:$A$18752,)+1):'база'!$A$18752,),MATCH(\"我我\",база!C:C,1)-MATCH(\"我我\",база!A:A,1)+1)>=(ROW()-MATCH(\"我我\",B$1:B6,1)+1),IFERROR(MATCH(B6,база!$A$1:$A$18752,),A5+1),\"\")","v":5},null,{"$f":"IFERROR(INDEX(база!B$1:B$19371,$A6)&\"\",\"\")","v":"309"},{"$f":"IFERROR(INDEX(база!C$1:C$19371,$A6)&\"\",\"\")","v":"материал"},{"$f":"IFERROR(INDEX(база!D$1:D$19371,$A6)&\"\",\"\")","v":"шт."},{"$f":"IFERROR(INDEX(база!E$1:E$19371,$A6),\"\")","v":0.08},{"$f":"IFERROR(INDEX(база!F$1:F$19371,$A6),\"\")","v":494},{"$f":"IFERROR(INDEX(база!G$1:G$19371,$A6),\"\")","v":39.520000000000003}]
[{"$f":"IF(IFERROR(MATCH(\"*\",INDEX(база!$A$1:$A$18752,MATCH(VLOOKUP(\"我我\",B$5:B7,1,1),база!$A$1:$A$18752,)+1):'база'!$A$18752,),MATCH(\"我我\",база!C:C,1)-MATCH(\"我我\",база!A:A,1)+1)>=(ROW()-MATCH(\"我我\",B$1:B7,1)+1),IFERROR(MATCH(B7,база!$A$1:$A$18752,),A6+1),\"\")","v":7},"2-37",{"$f":"IFERROR(INDEX(база!B$1:B$19371,$A7)&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(база!C$1:C$19371,$A7)&\"\",\"\")","v":"Раб 2-37"},{"$f":"IFERROR(INDEX(база!D$1:D$19371,$A7)&\"\",\"\")","v":"шт."},{"$f":"IFERROR(INDEX(база!E$1:E$19371,$A7),\"\")","v":1},{"$f":"IFERROR(INDEX(база!F$1:F$19371,$A7),\"\")","v":78},{"$f":"IFERROR(INDEX(база!G$1:G$19371,$A7),\"\")","v":78}]
[{"$f":"IF(IFERROR(MATCH(\"*\",INDEX(база!$A$1:$A$18752,MATCH(VLOOKUP(\"我我\",B$5:B8,1,1),база!$A$1:$A$18752,)+1):'база'!$A$18752,),MATCH(\"我我\",база!C:C,1)-MATCH(\"我我\",база!A:A,1)+1)>=(ROW()-MATCH(\"我我\",B$1:B8,1)+1),IFERROR(MATCH(B8,база!$A$1:$A$18752,),A7+1),\"\")","v":8},null,{"$f":"IFERROR(INDEX(база!B$1:B$19371,$A8)&\"\",\"\")","v":"309"},{"$f":"IFERROR(INDEX(база!C$1:C$19371,$A8)&\"\",\"\")","v":"материал"},{"$f":"IFERROR(INDEX(база!D$1:D$19371,$A8)&\"\",\"\")","v":"шт."},{"$f":"IFERROR(INDEX(база!E$1:E$19371,$A8),\"\")","v":0.12},{"$f":"IFERROR(INDEX(база!F$1:F$19371,$A8),\"\")","v":494},{"$f":"IFERROR(INDEX(база!G$1:G$19371,$A8),\"\")","v":59.28}]
[{"$f":"IF(IFERROR(MATCH(\"*\",INDEX(база!$A$1:$A$18752,MATCH(VLOOKUP(\"我我\",B$5:B9,1,1),база!$A$1:$A$18752,)+1):'база'!$A$18752,),MATCH(\"我我\",база!C:C,1)-MATCH(\"我我\",база!A:A,1)+1)>=(ROW()-MATCH(\"我我\",B$1:B9,1)+1),IFERROR(MATCH(B9,база!$A$1:$A$18752,),A8+1),\"\")","v":24},"2-45",{"$f":"IFERROR(INDEX(база!B$1:B$19371,$A9)&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(база!C$1:C$19371,$A9)&\"\",\"\")","v":"Раб 2-45"},{"$f":"IFERROR(INDEX(база!D$1:D$19371,$A9)&\"\",\"\")","v":"шт."},{"$f":"IFERROR(INDEX(база!E$1:E$19371,$A9),\"\")","v":1},{"$f":"IFERROR(INDEX(база!F$1:F$19371,$A9),\"\")","v":156},{"$f":"IFERROR(INDEX(база!G$1:G$19371,$A9),\"\")","v":156}]
[{"$f":"IF(IFERROR(MATCH(\"*\",INDEX(база!$A$1:$A$18752,MATCH(VLOOKUP(\"我我\",B$5:B10,1,1),база!$A$1:$A$18752,)+1):'база'!$A$18752,),MATCH(\"我我\",база!C:C,1)-MATCH(\"我我\",база!A:A,1)+1)>=(ROW()-MATCH(\"我我\",B$1:B10,1)+1),IFERROR(MATCH(B10,база!$A$1:$A$18752,),A9+1),\"\")","v":25},null,{"$f":"IFERROR(INDEX(база!B$1:B$19371,$A10)&\"\",\"\")","v":"190"},{"$f":"IFERROR(INDEX(база!C$1:C$19371,$A10)&\"\",\"\")","v":"материал"},{"$f":"IFERROR(INDEX(база!D$1:D$19371,$A10)&\"\",\"\")","v":"шт."},{"$f":"IFERROR(INDEX(база!E$1:E$19371,$A10),\"\")","v":1},{"$f":"IFERROR(INDEX(база!F$1:F$19371,$A10),\"\")","v":488},{"$f":"IFERROR(INDEX(база!G$1:G$19371,$A10),\"\")","v":488}]
[{"$f":"IF(IFERROR(MATCH(\"*\",INDEX(база!$A$1:$A$18752,MATCH(VLOOKUP(\"我我\",B$5:B11,1,1),база!$A$1:$A$18752,)+1):'база'!$A$18752,),MATCH(\"我我\",база!C:C,1)-MATCH(\"我我\",база!A:A,1)+1)>=(ROW()-MATCH(\"我我\",B$1:B11,1)+1),IFERROR(MATCH(B11,база!$A$1:$A$18752,),A10+1),\"\")","v":26},"2-46",{"$f":"IFERROR(INDEX(база!B$1:B$19371,$A11)&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(база!C$1:C$19371,$A11)&\"\",\"\")","v":"Раб 2-46"},{"$f":"IFERROR(INDEX(база!D$1:D$19371,$A11)&\"\",\"\")","v":"шт."},{"$f":"IFERROR(INDEX(база!E$1:E$19371,$A11),\"\")","v":1},{"$f":"IFERROR(INDEX(база!F$1:F$19371,$A11),\"\")","v":169},{"$f":"IFERROR(INDEX(база!G$1:G$19371,$A11),\"\")","v":169}]
[{"$f":"IF(IFERROR(MATCH(\"*\",INDEX(база!$A$1:$A$18752,MATCH(VLOOKUP(\"我我\",B$5:B12,1,1),база!$A$1:$A$18752,)+1):'база'!$A$18752,),MATCH(\"我我\",база!C:C,1)-MATCH(\"我我\",база!A:A,1)+1)>=(ROW()-MATCH(\"我我\",B$1:B12,1)+1),IFERROR(MATCH(B12,база!$A$1:$A$18752,),A11+1),\"\")","v":27},null,{"$f":"IFERROR(INDEX(база!B$1:B$19371,$A12)&\"\",\"\")","v":"190"},{"$f":"IFERROR(INDEX(база!C$1:C$19371,$A12)&\"\",\"\")","v":"материал"},{"$f":"IFERROR(INDEX(база!D$1:D$19371,$A12)&\"\",\"\")","v":"шт."},{"$f":"IFERROR(INDEX(база!E$1:E$19371,$A12),\"\")","v":1.5},{"$f":"IFERROR(INDEX(база!F$1:F$19371,$A12),\"\")","v":488},{"$f":"IFERROR(INDEX(база!G$1:G$19371,$A12),\"\")","v":732}]
[{"$f":"IF(IFERROR(MATCH(\"*\",INDEX(база!$A$1:$A$18752,MATCH(VLOOKUP(\"我我\",B$5:B13,1,1),база!$A$1:$A$18752,)+1):'база'!$A$18752,),MATCH(\"我我\",база!C:C,1)-MATCH(\"我我\",база!A:A,1)+1)>=(ROW()-MATCH(\"我我\",B$1:B13,1)+1),IFERROR(MATCH(B13,база!$A$1:$A$18752,),A12+1),\"\")","v":28},"2-47",{"$f":"IFERROR(INDEX(база!B$1:B$19371,$A13)&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(база!C$1:C$19371,$A13)&\"\",\"\")","v":"Раб 2-47"},{"$f":"IFERROR(INDEX(база!D$1:D$19371,$A13)&\"\",\"\")","v":"шт."},{"$f":"IFERROR(INDEX(база!E$1:E$19371,$A13),\"\")","v":1},{"$f":"IFERROR(INDEX(база!F$1:F$19371,$A13),\"\")","v":208},{"$f":"IFERROR(INDEX(база!G$1:G$19371,$A13),\"\")","v":208}]
[{"$f":"IF(IFERROR(MATCH(\"*\",INDEX(база!$A$1:$A$18752,MATCH(VLOOKUP(\"我我\",B$5:B14,1,1),база!$A$1:$A$18752,)+1):'база'!$A$18752,),MATCH(\"我我\",база!C:C,1)-MATCH(\"我我\",база!A:A,1)+1)>=(ROW()-MATCH(\"我我\",B$1:B14,1)+1),IFERROR(MATCH(B14,база!$A$1:$A$18752,),A13+1),\"\")","v":29},null,{"$f":"IFERROR(INDEX(база!B$1:B$19371,$A14)&\"\",\"\")","v":"190"},{"$f":"IFERROR(INDEX(база!C$1:C$19371,$A14)&\"\",\"\")","v":"материал"},{"$f":"IFERROR(INDEX(база!D$1:D$19371,$A14)&\"\",\"\")","v":"шт."},{"$f":"IFERROR(INDEX(база!E$1:E$19371,$A14),\"\")","v":1.8},{"$f":"IFERROR(INDEX(база!F$1:F$19371,$A14),\"\")","v":488},{"$f":"IFERROR(INDEX(база!G$1:G$19371,$A14),\"\")","v":878.4}]
[{"$f":"IF(IFERROR(MATCH(\"*\",INDEX(база!$A$1:$A$18752,MATCH(VLOOKUP(\"我我\",B$5:B15,1,1),база!$A$1:$A$18752,)+1):'база'!$A$18752,),MATCH(\"我我\",база!C:C,1)-MATCH(\"我我\",база!A:A,1)+1)>=(ROW()-MATCH(\"我我\",B$1:B15,1)+1),IFERROR(MATCH(B15,база!$A$1:$A$18752,),A14+1),\"\")","v":15},"2-41",{"$f":"IFERROR(INDEX(база!B$1:B$19371,$A15)&\"\",\"\")","v":""},{"$f":"IFERROR(INDEX(база!C$1:C$19371,$A15)&\"\",\"\")","v":"Раб 2-41"},{"$f":"IFERROR(INDEX(база!D$1:D$19371,$A15)&\"\",\"\")","v":"шт."},{"$f":"IFERROR(INDEX(база!E$1:E$19371,$A15),\"\")","v":1},{"$f":"IFERROR(INDEX(база!F$1:F$19371,$A15),\"\")","v":169},{"$f":"IFERROR(INDEX(база!G$1:G$19371,$A15),\"\")","v":169}]
[{"$f":"IF(IFERROR(MATCH(\"*\",INDEX(база!$A$1:$A$18752,MATCH(VLOOKUP(\"我我\",B$5:B16,1,1),база!$A$1:$A$18752,)+1):'база'!$A$18752,),MATCH(\"我我\",база!C:C,1)-MATCH(\"我我\",база!A:A,1)+1)>=(ROW()-MATCH(\"我我\",B$1:B16,1)+1),IFERROR(MATCH(B16,база!$A$1:$A$18752,),A15+1),\"\")","v":16},null,{"$f":"IFERROR(INDEX(база!B$1:B$19371,$A16)&\"\",\"\")","v":"190"},{"$f":"IFERROR(INDEX(база!C$1:C$19371,$A16)&\"\",\"\")","v":"материал"},{"$f":"IFERROR(INDEX(база!D$1:D$19371,$A16)&\"\",\"\")","v":"шт."},{"$f":"IFERROR(INDEX(база!E$1:E$19371,$A16),\"\")","v":0.2},{"$f":"IFERROR(INDEX(база!F$1:F$19371,$A16),\"\")","v":488},{"$f":"IFERROR(INDEX(база!G$1:G$19371,$A16),\"\")","v":97.600000000000009}]
[]
[null,null,null,"работа:",null,null,null,{"$f":"SUMIF(B5:B16,\"*\",H5:H16)","v":822}]
[null,null,null,"материалы:",null,null,null,{"$f":"SUM(H5:H16)-H18","v":2294.7999999999997}]
[null,null,null,"всего:",null,null,null,{"$f":"SUM(H18:H19)","v":3116.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]