{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Стронг"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":19,"comments":1,"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":88,"n_cols":9,"rows_kept":88,"cut":false,"hidden":false,"merged":[[60,0,60,1],[62,0,62,2],[62,3,62,8],[73,0,73,4],[70,7,70,8],[71,3,71,6],[1,0,1,4],[64,0,64,8],[60,2,60,8],[63,6,63,7],[59,5,59,7],[59,0,59,2],[37,0,37,4],[45,0,45,2],[41,7,41,8],[52,0,52,8],[40,0,40,8],[36,0,36,2],[46,0,46,2],[58,0,58,2],[57,0,57,2],[56,0,56,4],[87,0,87,1],[75,0,75,2],[74,0,74,2],[70,2,70,4],[80,2,80,4],[76,0,76,2],[86,0,86,2],[85,0,85,2],[81,3,81,6],[83,0,83,4],[84,0,84,2],[78,0,78,8],[77,0,77,8],[79,0,79,8],[80,7,80,8],[86,5,86,7],[87,2,87,8],[0,7,0,8],[0,0,0,1],[0,2,0,4],[41,2,41,4],[35,0,35,2],[53,2,53,4],[53,7,53,8],[50,0,50,2],[54,3,54,6],[39,0,39,8],[38,2,38,8],[38,0,38,1],[42,3,42,6],[48,0,48,1],[44,0,44,4],[48,2,48,8],[47,0,47,2],[50,3,50,8],[51,6,51,7],[47,5,47,7]]}
[null,null,"НАКЛАДНАЯ №",null,null,"Р","от"," \" 00 \" марта 2019 г. "]
["Наименование","Доставка",null,null,null,"Ед.изм.   ","Кол-во","Цена","Сумма"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Продукт 1",null,null,null,"черный",{"$f":"IF(AND(D36=1,ISNUMBER(SEARCH(\"*40*20*\",A36))),\"м/п\",\"шт.\")","v":"шт."},1,1000,{"$f":"G36*H36","v":1000}]
["Продукт 2",null,null,null,"белый",{"$f":"IF(AND(D37=1,ISNUMBER(SEARCH(\"*40*20*\",A37))),\"м/п\",\"шт.\")","v":"шт."},1,50,{"$f":"G37*H37","v":50}]
[null,null,null,null,null,"Сметная стоимость",null,null,{"$f":"SUM(I$36:I37)","v":1050}]
["Итого:",null,{"$f":"SUBSTITUTE(PROPER(INDEX(n_4,MID(TEXT(I38,n0),1,1)+1)&INDEX(n0x,MID(TEXT(I38,n0),2,1)+1,MID(TEXT(I38,n0),3,1)+1)&IF(-MID(TEXT(I38,n0),1,3),\"миллиард\"&VLOOKUP(MID(TEXT(I38,n0),3,1)*AND(MID(TEXT(I38,n0),2,1)-1),мил,2),\"\")&INDEX(n_4,MID(TEXT(I38,n0),4,1)+1)&INDEX(n0x,MID(TEXT(I38,n0),5,1)+1,MID(TEXT(I38,n0),6,1)+1)&IF(-MID(TEXT(I38,n0),4,3),\"миллион\"&VLOOKUP(MID(TEXT(I38,n0),6,1)*AND(MID(TEXT(I38,n0),5,1)-1),мил,2),\"\")&INDEX(n_4,MID(TEXT(I38,n0),7,1)+1)&INDEX(n1x,MID(TEXT(I38,n0),8,1)+1,MID(TEXT(I38,n0),9,1)+1)&IF(-MID(TEXT(I38,n0),7,3),VLOOKUP(MID(TEXT(I38,n0),9,1)*AND(MID(TEXT(I38,n0),8,1)-1),тыс,2),\"\")&INDEX(n_4,MID(TEXT(I38,n0),10,1)+1)&INDEX(n0x,MID(TEXT(I38,n0),11,1)+1,MID(TEXT(I38,n0),12,1)+1)),\"z\",\" \")&IF(TRUNC(TEXT(I38,n0)),\"\",\"Ноль \")&\"рубл\"&VLOOKUP(MOD(MAX(MOD(MID(TEXT(I38,n0),11,2)-11,100),9),10),{0,\"ь \";1,\"я \";4,\"ей \"},2)&RIGHT(TEXT(I38,n0),2)&\" копе\"&VLOOKUP(MOD(MAX(MOD(RIGHT(TEXT(I38,n0),2)-11,100),9),10),{0,\"йка\";1,\"йки\";4,\"ек\"},2)","v":"Одна тысяча пятьдесят рублей 00 копеек"}]
[]
["          -          -                                                                                                                               -         -         "]
[null,null,"НАКЛАДНАЯ №",null,null,{"$f":"F1","v":"Р"},"от",{"$f":"H1","v":" \" 00 \" марта 2019 г. "}]
[]
[]
["Наименование",null,null,null,null,"Ед.изм.   ","Кол-во","Цена","Сумма"]
[{"$f":"A36","v":"Продукт 1"},null,null,{"$f":"D36","v":0},"черный","шт.",1,1000,1000]
[{"$f":"A37","v":"Продукт 2"},null,null,0,"белый","шт.",1,50,50]
["          ",null,null,null,null,"Сметная стоимость  ",null,null,{"$f":"SUM(I46:I47)","v":1050}]
["Итого:",null,{"$f":"SUBSTITUTE(PROPER(INDEX(n_4,MID(TEXT(I48,n0),1,1)+1)&INDEX(n0x,MID(TEXT(I48,n0),2,1)+1,MID(TEXT(I48,n0),3,1)+1)&IF(-MID(TEXT(I48,n0),1,3),\"миллиард\"&VLOOKUP(MID(TEXT(I48,n0),3,1)*AND(MID(TEXT(I48,n0),2,1)-1),мил,2),\"\")&INDEX(n_4,MID(TEXT(I48,n0),4,1)+1)&INDEX(n0x,MID(TEXT(I48,n0),5,1)+1,MID(TEXT(I48,n0),6,1)+1)&IF(-MID(TEXT(I48,n0),4,3),\"миллион\"&VLOOKUP(MID(TEXT(I48,n0),6,1)*AND(MID(TEXT(I48,n0),5,1)-1),мил,2),\"\")&INDEX(n_4,MID(TEXT(I48,n0),7,1)+1)&INDEX(n1x,MID(TEXT(I48,n0),8,1)+1,MID(TEXT(I48,n0),9,1)+1)&IF(-MID(TEXT(I48,n0),7,3),VLOOKUP(MID(TEXT(I48,n0),9,1)*AND(MID(TEXT(I48,n0),8,1)-1),тыс,2),\"\")&INDEX(n_4,MID(TEXT(I48,n0),10,1)+1)&INDEX(n0x,MID(TEXT(I48,n0),11,1)+1,MID(TEXT(I48,n0),12,1)+1)),\"z\",\" \")&IF(TRUNC(TEXT(I48,n0)),\"\",\"Ноль \")&\"рубл\"&VLOOKUP(MOD(MAX(MOD(MID(TEXT(I48,n0),11,2)-11,100),9),10),{0,\"ь \";1,\"я \";4,\"ей \"},2)&RIGHT(TEXT(I48,n0),2)&\" копе\"&VLOOKUP(MOD(MAX(MOD(RIGHT(TEXT(I48,n0),2)-11,100),9),10),{0,\"йка\";1,\"йки\";4,\"ек\"},2)","v":"Одна тысяча пятьдесят рублей 00 копеек"}]
[]
[]
[]
[]
[null,null,"НАКЛАДНАЯ №",null,null,{"$f":"F42","v":"Р"},"от",{"$f":"H42","v":" \" 00 \" марта 2019 г. "}]
[]
[]
["Наименование",null,null,null,null,"Ед.изм.   ","Кол-во","Цена","Сумма"]
[{"$f":"A36","v":"Продукт 1"},null,null,{"$f":"D36","v":0},"черный","шт.",1,1000,1000]
[{"$f":"A37","v":"Продукт 2"},null,null,0,"белый","шт.",1,50,50]
["          ",null,null,null,null,"Сметная стоимость  ",null,null,{"$f":"SUM(I58:I59)","v":1050}]
["Итого:",null,{"$f":"SUBSTITUTE(PROPER(INDEX(n_4,MID(TEXT(I60,n0),1,1)+1)&INDEX(n0x,MID(TEXT(I60,n0),2,1)+1,MID(TEXT(I60,n0),3,1)+1)&IF(-MID(TEXT(I60,n0),1,3),\"миллиард\"&VLOOKUP(MID(TEXT(I60,n0),3,1)*AND(MID(TEXT(I60,n0),2,1)-1),мил,2),\"\")&INDEX(n_4,MID(TEXT(I60,n0),4,1)+1)&INDEX(n0x,MID(TEXT(I60,n0),5,1)+1,MID(TEXT(I60,n0),6,1)+1)&IF(-MID(TEXT(I60,n0),4,3),\"миллион\"&VLOOKUP(MID(TEXT(I60,n0),6,1)*AND(MID(TEXT(I60,n0),5,1)-1),мил,2),\"\")&INDEX(n_4,MID(TEXT(I60,n0),7,1)+1)&INDEX(n1x,MID(TEXT(I60,n0),8,1)+1,MID(TEXT(I60,n0),9,1)+1)&IF(-MID(TEXT(I60,n0),7,3),VLOOKUP(MID(TEXT(I60,n0),9,1)*AND(MID(TEXT(I60,n0),8,1)-1),тыс,2),\"\")&INDEX(n_4,MID(TEXT(I60,n0),10,1)+1)&INDEX(n0x,MID(TEXT(I60,n0),11,1)+1,MID(TEXT(I60,n0),12,1)+1)),\"z\",\" \")&IF(TRUNC(TEXT(I60,n0)),\"\",\"Ноль \")&\"рубл\"&VLOOKUP(MOD(MAX(MOD(MID(TEXT(I60,n0),11,2)-11,100),9),10),{0,\"ь \";1,\"я \";4,\"ей \"},2)&RIGHT(TEXT(I60,n0),2)&\" копе\"&VLOOKUP(MOD(MAX(MOD(RIGHT(TEXT(I60,n0),2)-11,100),9),10),{0,\"йка\";1,\"йки\";4,\"ек\"},2)","v":"Одна тысяча пятьдесят рублей 00 копеек"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Складская накладная №",null,null,{"$f":"F42","v":"Р"},"от",{"$f":"H42","v":" \" 00 \" марта 2019 г. "}]
[null,null,"Склад №: _____________"]
[null,null,"Бригада №: ____________________________"]
["Наименование ",null,null,null,null,"Ед.изм.   ","Кол-во","Отгружено","Возврат"]
[{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A36)),\"\",A36)","v":"Продукт 1"},null,null,{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A36)),\"\",D36)","v":0},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A36)),\"\",E36)","v":"черный"},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A36)),\"\",F36)","v":"шт."},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A36)),\"\",G36)","v":1}]
[{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A37)),\"\",A37)","v":"Продукт 2"},null,null,{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A37)),\"\",D37)","v":0},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A37)),\"\",E37)","v":"белый"},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A37)),\"\",F37)","v":"шт."},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A37)),\"\",G37)","v":1}]
[]
["                                                                       _Сдал: /  1 Сафаров   / 2 Рахимов  / 3 Ахматов  /_____________ / ___________ /"]
["                                                                     Принял:  ________________________________  /_____________/_____________/"]
["          -          -                                                                                                                               -         -         "]
[null,null,"НАКЛАДНАЯ №",null,null,{"$f":"F1","v":"Р"},"от",{"$f":"H1","v":" \" 00 \" марта 2019 г. "}]
[]
[]
["Наименование",null,null,null,null,"Ед.изм.   ","Кол-во","Цена","Сумма"]
[{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A36)),\"\",A36)","v":"Продукт 1"},null,null,{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A36)),\"\",D36)","v":0},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A36)),\"\",E36)","v":"черный"},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A36)),\"\",F36)","v":"шт."},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A36)),\"\",G36)","v":1},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A36)),\"\",H36)","v":1000},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A36)),\"\",I36)","v":1000}]
[{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A37)),\"\",A37)","v":"Продукт 2"},null,null,{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A37)),\"\",D37)","v":0},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A37)),\"\",E37)","v":"белый"},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A37)),\"\",F37)","v":"шт."},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A37)),\"\",G37)","v":1},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A37)),\"\",H37)","v":50},{"$f":"IF(ISNUMBER(SEARCH(\"доставка\",A37)),\"\",I37)","v":50}]
["          ",null,null,null,null,"Сметная стоимость  ",null,null,{"$f":"SUM(I85:I86)","v":1050}]
["Итого:",null,{"$f":"SUBSTITUTE(PROPER(INDEX(n_4,MID(TEXT(I87,n0),1,1)+1)&INDEX(n0x,MID(TEXT(I87,n0),2,1)+1,MID(TEXT(I87,n0),3,1)+1)&IF(-MID(TEXT(I87,n0),1,3),\"миллиард\"&VLOOKUP(MID(TEXT(I87,n0),3,1)*AND(MID(TEXT(I87,n0),2,1)-1),мил,2),\"\")&INDEX(n_4,MID(TEXT(I87,n0),4,1)+1)&INDEX(n0x,MID(TEXT(I87,n0),5,1)+1,MID(TEXT(I87,n0),6,1)+1)&IF(-MID(TEXT(I87,n0),4,3),\"миллион\"&VLOOKUP(MID(TEXT(I87,n0),6,1)*AND(MID(TEXT(I87,n0),5,1)-1),мил,2),\"\")&INDEX(n_4,MID(TEXT(I87,n0),7,1)+1)&INDEX(n1x,MID(TEXT(I87,n0),8,1)+1,MID(TEXT(I87,n0),9,1)+1)&IF(-MID(TEXT(I87,n0),7,3),VLOOKUP(MID(TEXT(I87,n0),9,1)*AND(MID(TEXT(I87,n0),8,1)-1),тыс,2),\"\")&INDEX(n_4,MID(TEXT(I87,n0),10,1)+1)&INDEX(n0x,MID(TEXT(I87,n0),11,1)+1,MID(TEXT(I87,n0),12,1)+1)),\"z\",\" \")&IF(TRUNC(TEXT(I87,n0)),\"\",\"Ноль \")&\"рубл\"&VLOOKUP(MOD(MAX(MOD(MID(TEXT(I87,n0),11,2)-11,100),9),10),{0,\"ь \";1,\"я \";4,\"ей \"},2)&RIGHT(TEXT(I87,n0),2)&\" копе\"&VLOOKUP(MOD(MAX(MOD(RIGHT(TEXT(I87,n0),2)-11,100),9),10),{0,\"йка\";1,\"йки\";4,\"ек\"},2)","v":"Одна тысяча пятьдесят рублей 00 копеек"}]