{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Накладная","СчетЗаказ","Учет","Подоконники","Прайс","TEST"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":23,"n_cols":79,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,28,22,32],[8,1,9,1],[19,78,19,85],[5,58,5,67],[7,48,8,53],[7,54,8,60],[7,61,8,67],[7,78,8,85],[4,48,4,57],[4,58,4,67],[5,48,5,57],[21,23,21,27],[21,28,21,32],[21,33,21,37],[21,38,21,42],[7,68,7,77],[8,68,8,71],[8,72,8,77],[7,4,8,6],[8,38,8,42],[7,33,7,42],[7,43,8,47],[8,23,8,27],[7,18,7,27],[7,28,8,32],[8,33,8,37],[8,7,8,13],[8,14,8,17],[7,7,7,17],[8,18,8,22],[9,78,9,85],[10,4,10,6],[10,7,10,13],[10,14,10,17],[10,18,10,22],[10,23,10,27],[10,28,10,32],[10,33,10,37],[9,43,9,47],[9,48,9,53],[9,54,9,60],[9,61,9,67],[9,23,9,27],[9,28,9,32],[9,33,9,37],[9,38,9,42],[9,4,9,6],[9,7,9,13],[9,14,9,17],[9,18,9,22],[10,61,10,67],[10,68,10,71],[9,68,9,71],[9,72,9,77],[11,54,11,60],[11,61,11,67],[10,72,10,77],[10,78,10,85],[10,38,10,42],[10,43,10,47],[10,48,10,53],[10,54,10,60],[11,23,11,27],[11,28,11,32],[11,33,11,37],[11,38,11,42],[11,68,11,71],[11,72,11,77],[11,78,11,85],[12,4,12,6],[12,7,12,13],[12,14,12,17],[12,18,12,22],[12,23,12,27],[12,28,12,32],[13,28,13,32],[11,43,11,47],[11,48,11,53],[11,4,11,6],[11,7,11,13],[11,14,11,17],[11,18,11,22],[13,33,13,37],[13,48,13,53],[13,4,13,6],[13,54,13,60],[12,33,12,37],[12,38,12,42],[13,38,13,42],[13,43,13,47],[12,43,12,47],[12,48,12,53],[14,7,14,13],[14,14,14,17],[14,18,14,22],[14,23,14,27],[13,7,13,13],[13,14,13,17],[13,18,13,22],[13,23,13,27],[14,61,14,67],[14,68,14,71],[13,72,13,77],[12,54,12,60],[12,61,12,67],[14,72,14,77],[15,4,15,6],[15,7,15,13],[15,14,15,17],[15,18,15,22],[15,23,15,27],[14,54,14,60],[14,38,14,42],[14,43,14,47],[14,28,14,32],[15,48,15,53],[15,54,15,60],[14,33,14,37],[15,28,15,32],[15,33,15,37],[15,38,15,42],[15,43,15,47],[14,48,14,53],[14,4,14,6],[15,61,15,67],[15,68,15,71],[16,48,16,53],[16,54,16,60],[16,38,16,42],[16,43,16,47],[17,48,17,53],[17,54,17,60],[16,61,16,67],[16,68,16,71],[17,38,17,42],[17,43,17,47],[16,4,16,6],[16,7,16,13],[16,14,16,17],[16,18,16,22],[16,23,16,27],[16,28,16,32],[16,33,16,37],[17,33,17,37],[17,4,17,6],[17,7,17,13],[17,14,17,17],[17,18,17,22],[17,23,17,27],[12,68,12,71],[12,72,12,77],[17,72,17,77],[17,28,17,32],[20,28,20,32],[20,33,20,37],[20,38,20,42],[18,4,18,6],[18,7,18,13],[18,14,18,17],[18,18,18,22],[18,23,18,27],[18,28,18,32],[18,61,18,67],[18,68,18,71],[18,72,18,77],[17,61,17,67],[17,68,17,71],[19,4,19,6],[19,7,19,13],[19,14,19,17],[19,18,19,22],[19,23,19,27],[19,28,19,32],[12,78,12,85],[13,78,13,85],[14,78,14,85],[15,78,15,85],[16,78,16,85],[21,48,21,53],[21,54,21,60],[21,61,21,67],[21,68,21,71],[21,72,21,77],[20,68,20,71],[20,48,20,53],[20,54,20,60],[20,61,20,67],[20,72,20,77],[18,48,18,53],[18,54,18,60],[15,72,15,77],[19,61,19,67],[19,68,19,71],[19,72,19,77],[16,72,16,77],[13,61,13,67],[13,68,13,71],[22,4,22,6],[22,7,22,13],[22,14,22,17],[22,18,22,22],[22,23,22,27],[20,4,20,6],[20,7,20,13],[20,14,20,17],[21,4,21,6],[21,7,21,13],[21,14,21,17],[21,18,21,22],[20,18,20,22],[20,23,20,27],[22,43,22,47],[22,48,22,53],[17,78,17,85],[18,78,18,85],[20,78,20,85],[21,78,21,85],[22,78,22,85],[22,33,22,37],[22,68,22,71],[22,72,22,77],[22,38,22,42],[21,43,21,47],[22,54,22,60],[22,61,22,67],[20,43,20,47],[18,33,18,37],[18,38,18,42],[18,43,18,47],[19,33,19,37],[19,38,19,42],[19,43,19,47],[19,48,19,53],[19,54,19,60]]}
[null,null,null,"ЗАПОЛНЕНИЕ НАКЛАДНОЙ"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Номер документа",null,null,null,null,null,null,null,null,null,"Дата составления"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ТОВАРНАЯ НАКЛАДНАЯ"]
[]
[null,null,null,null,"Но- мер по по- рядку",null,null,"Товар",null,null,null,null,null,null,null,null,null,null,"Единица\nизмерения",null,null,null,null,null,null,null,null,null,"Вид упаков- ки",null,null,null,null,"Количество",null,null,null,null,null,null,null,null,null,"Масса брутто",null,null,null,null,"Количест- во\n(масса нетто)",null,null,null,null,null,"Цена,\nруб. коп.",null,null,null,null,null,null,"Сумма без учета НДС, руб. коп.",null,null,null,null,null,null,"НДС",null,null,null,null,null,null,null,null,null,"Сумма с учетом НДС,\nруб. коп."]
[null,"№ пп из закладки УЧЕТ",null,null,null,null,null,"наименование,\nхарактеристика, сорт, артикул\nтовара",null,null,null,null,null,null,"код",null,null,null,"наиме- нование",null,null,null,null,"код по ОКЕИ",null,null,null,null,null,null,null,null,null,"в одном месте",null,null,null,null,"мест, штук",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ставка, %",null,null,null,"сумма,\nруб. коп."]
[null,null,null,null,1,null,null,2,null,null,null,null,null,null,3,null,null,null,4,null,null,null,null,5,null,null,null,null,6,null,null,null,null,7,null,null,null,null,8,null,null,null,null,9,null,null,null,null,10,null,null,null,null,null,11,null,null,null,null,null,null,12,null,null,null,null,null,null,13,null,null,null,14,null,null,null,null,null,15]
[null,19,null,null,{"$f":" IF(B11>0,E10,\"\")","v":1},null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B11,Учет!B:I,3,0),\", \",VLOOKUP(VLOOKUP(B11,Учет!B:I,2,0),Учет!C:I,4,0)),\"\")","v":"Ёжик, шт"},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B11,Учет!B4:I24,5,0),\"\")","v":"шт"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B11,Учет!B:I,8,0),\"\")","v":1},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B11,Учет!B:I,7,0),\"\")","v":1231.3333333333301},null,null,null,null,null,null,{"$f":"IFERROR(AW11*BC11,\"\")","v":1231.3333333333301},null,null,null,null,null,null,{"$f":"IF(B11>0,0,\"\")","v":0},null,null,null,{"$f":"IF(B11>0,0,\"\")","v":0},null,null,null,null,null,{"$f":"BJ11","v":1231.3333333333301}]
[null,null,null,null,{"$f":" IF(B12>0,E11+1,\"\")","v":""},null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B12,Учет!B:I,3,0),\", \",VLOOKUP(VLOOKUP(B12,Учет!B:I,2,0),Учет!C:I,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B12,Учет!B5:I25,5,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B12,Учет!B:I,8,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B12,Учет!B:I,7,0),\"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(BC12*AW12,\"\")","v":""},null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,{"$f":"BJ12","v":""}]
[null,null,null,null,"",null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B13,Учет!B:I,2,0),\", \",VLOOKUP(VLOOKUP(B13,Учет!B:I,2,0),Учет!C:I,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B13,Учет!B6:I26,5,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B13,Учет!B:I,8,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B13,Учет!B:I,7,0),\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,{"$f":"BJ13","v":""}]
[null,null,null,null,"",null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B14,Учет!B:I,2,0),\", \",VLOOKUP(VLOOKUP(B14,Учет!B:I,2,0),Учет!C:I,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B14,Учет!B7:I27,5,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B14,Учет!B:I,8,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B14,Учет!B:I,7,0),\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,"",null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B15,Учет!B:I,2,0),\", \",VLOOKUP(VLOOKUP(B15,Учет!B:I,2,0),Учет!C:I,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B15,Учет!B8:I28,5,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B15,Учет!B:I,8,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B15,Учет!B:I,7,0),\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,"",null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B16,Учет!B:I,2,0),\", \",VLOOKUP(VLOOKUP(B16,Учет!B:I,2,0),Учет!C:I,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B16,Учет!B9:I29,5,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B16,Учет!B:I,8,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B16,Учет!B:I,7,0),\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,"",null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B17,Учет!B:I,2,0),\", \",VLOOKUP(VLOOKUP(B17,Учет!B:I,2,0),Учет!C:I,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B17,Учет!B10:I30,5,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B17,Учет!B:I,8,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B17,Учет!B:I,7,0),\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,"",null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B18,Учет!B:I,2,0),\", \",VLOOKUP(VLOOKUP(B18,Учет!B:I,2,0),Учет!C:I,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B18,Учет!B11:I31,5,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B18,Учет!B:I,8,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B18,Учет!B:I,7,0),\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,{"$f":" IF(B19>0,E18+1,\"\")","v":""},null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B19,Учет!B:I,2,0),\", \",VLOOKUP(VLOOKUP(B19,Учет!B:I,2,0),Учет!C:I,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B19,Учет!B12:I32,5,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B19,Учет!B:I,8,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B19,Учет!B:I,7,0),\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,"",null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B20,Учет!B:I,2,0),\", \",VLOOKUP(VLOOKUP(B20,Учет!B:I,2,0),Учет!C:I,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B20,Учет!B13:I33,5,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B20,Учет!B:I,8,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B20,Учет!B:I,7,0),\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,{"$f":"BJ20","v":""}]
[null,null,null,null,"",null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B21,Учет!B:I,2,0),\", \",VLOOKUP(VLOOKUP(B21,Учет!B:I,2,0),Учет!C:I,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B21,Учет!B15:I34,5,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B21,Учет!B:I,8,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B21,Учет!B:I,7,0),\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,"",null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B22,Учет!B:I,2,0),\", \",VLOOKUP(VLOOKUP(B22,Учет!B:I,2,0),Учет!C:I,4,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B22,Учет!B16:I35,5,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B22,Учет!B:I,8,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B22,Учет!B:I,7,0),\"\")","v":""},null,null,null,null,null,null,"",null,null,null,null,null,null,"",null,null,null,"",null,null,null,null,null,{"$f":"BJ22","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Итого ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(SUM(AW11:BB22),\"\")","v":1},null,null,null,null,null,"Х",null,null,null,null,null,null,{"$f":"IFERROR(SUM(BJ11:BP22),\"\")","v":1231.3333333333301},null,null,null,null,null,null,"Х",null,null,null,{"$f":"IFERROR(SUM(BU11:BZ22),\"\")","v":0},null,null,null,null,null,{"$f":"IFERROR(SUM(CA11:CH22),\"\")","v":1231.3333333333301}]

{"sheet":"СчетЗаказ","index":1,"n_rows":21,"n_cols":28,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,27,20,28],[19,5,19,8],[19,9,19,17],[19,18,19,19],[19,20,19,21],[19,22,19,23],[19,24,19,25],[19,27,19,28],[18,27,18,28],[18,5,18,8],[18,9,18,17],[18,18,18,19],[18,20,18,21],[18,22,18,23],[18,24,18,25],[16,27,16,28],[17,5,17,8],[17,9,17,17],[17,18,17,19],[17,20,17,21],[17,22,17,23],[17,24,17,25],[17,27,17,28],[16,5,16,8],[16,9,16,17],[16,18,16,19],[16,20,16,21],[16,22,16,23],[16,24,16,25],[14,27,14,28],[15,5,15,8],[15,9,15,17],[15,18,15,19],[15,20,15,21],[15,22,15,23],[15,24,15,25],[15,27,15,28],[14,5,14,8],[14,9,14,17],[14,18,14,19],[14,20,14,21],[14,22,14,23],[14,24,14,25],[10,22,10,23],[12,27,12,28],[13,5,13,8],[13,9,13,17],[13,18,13,19],[13,20,13,21],[13,22,13,23],[13,24,13,25],[13,27,13,28],[12,5,12,8],[12,9,12,17],[12,18,12,19],[12,20,12,21],[12,22,12,23],[12,24,12,25],[9,24,9,25],[6,15,6,18],[8,15,8,18],[10,27,10,28],[11,5,11,8],[11,9,11,17],[11,18,11,19],[11,20,11,21],[11,22,11,23],[11,24,11,25],[11,27,11,28],[10,24,10,25],[10,5,10,8],[10,9,10,17],[10,18,10,19],[10,20,10,21],[9,27,9,28],[7,20,7,24],[9,18,9,19],[9,9,9,17],[2,4,2,6],[4,4,4,6],[3,4,3,6],[3,9,3,18],[4,9,4,18],[2,9,2,18],[9,5,9,8],[7,15,7,18],[6,20,6,24],[6,9,7,13],[9,20,9,21],[9,22,9,23]]}
[null,null,null,null,null,null,null,null,null,"БЛАНК ЗАПОВНЕННЯ"]
[]
[null,34,null,null,"Одержувач",null,null,null,null,"Андрей"]
[null,null,null,null,"Телефон",null,null,null,null,6650505050]
[null,null,null,null,"Адреса:",null,null,null,null,"г. Киев ул.МирYYYYYYльская 8а"]
[]
[null,null,null,null,null,null,null,null,null,"ЗАМОВЛЕННЯ",null,null,null,null,null,"Номер документа"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,null,null,null,{"$f":"TODAY()","v":"2021-08-31"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-08-31"}]
[null,null,null,null,"№ п/п","Код",null,null,null,"Найменування товару",null,null,null,null,null,null,null,null,"Ширина",null,"Довжина",null,"Кіл-ть",null,"Ціна",null,"%","Сума"]
[null,1215,null,null,1,{"$f":"IFERROR(VLOOKUP(B11,Подоконники!F:J,1,0),\"\")","v":1215},null,null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B11,Подоконники!F:J,2,0),\" (\",VLOOKUP(B11,Подоконники!F:J,5,0),\")\"),\"\")","v":"Підвіконня KRAFT Горіх (м. п.)"},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B11,Подоконники!F:J,3,0),\"\")","v":150},null,1200,null,1,null,{"$f":"IFERROR(VLOOKUP(B11,Подоконники!F:J,4,0),\"\")","v":130},null,null,{"$f":"IF(B11=\"\",\"\",Y11*U11/1000*W11*(1-AA11))","v":156}]
[null,1215,null,null,{"$f":"IF(B12=\"\",\"\",E11+1)","v":2},{"$f":"IFERROR(VLOOKUP(B12,Подоконники!F:J,1,0),\"\")","v":1215},null,null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B12,Подоконники!F:J,2,0),\" (\",VLOOKUP(B12,Подоконники!F:J,5,0),\")\"),\"\")","v":"Підвіконня KRAFT Горіх (м. п.)"},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B12,Подоконники!F:J,3,0),\"\")","v":150},null,1305,null,1,null,{"$f":"IFERROR(VLOOKUP(B12,Подоконники!F:J,4,0),\"\")","v":130},null,null,{"$f":"IF(B12=\"\",\"\",Y12*U12/1000*W12*(1-AA12))","v":169.65}]
[null,1201,null,null,{"$f":"IF(B13=\"\",\"\",E12+1)","v":3},{"$f":"IFERROR(VLOOKUP(B13,Подоконники!F:J,1,0),\"\")","v":1201},null,null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B13,Подоконники!F:J,2,0),\" (\",VLOOKUP(B13,Подоконники!F:J,5,0),\")\"),\"\")","v":"Заглушка до п-ння KRAFT Горіх (шт.)"},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B13,Подоконники!F:J,3,0),\"\")","v":0},null,1,null,2,null,{"$f":"IFERROR(VLOOKUP(B13,Подоконники!F:J,4,0),\"\")","v":45},null,null,{"$f":"IF(B13=\"\",\"\",Y13*U13/1000*W13*(1-AA13))","v":0.09}]
[null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(B14,Подоконники!F:J,1,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B14,Подоконники!F:J,2,0),\" (\",VLOOKUP(B14,Подоконники!F:J,5,0),\")\"),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B14,Подоконники!F:J,3,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B14,Подоконники!F:J,4,0),\"\")","v":""},null,null,{"$f":"IF(B14=\"\",\"\",Y14*U14/1000*W14*(1-AA14))","v":""}]
[null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(B15,Подоконники!F:J,1,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B15,Подоконники!F:J,2,0),\" (\",VLOOKUP(B15,Подоконники!F:J,5,0),\")\"),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B15,Подоконники!F:J,3,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B15,Подоконники!F:J,4,0),\"\")","v":""},null,null,""]
[null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(B16,Подоконники!F:J,1,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B16,Подоконники!F:J,2,0),\" (\",VLOOKUP(B16,Подоконники!F:J,5,0),\")\"),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B16,Подоконники!F:J,3,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B16,Подоконники!F:J,4,0),\"\")","v":""},null,null,""]
[null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(B17,Подоконники!F:J,1,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B17,Подоконники!F:J,2,0),\" (\",VLOOKUP(B17,Подоконники!F:J,5,0),\")\"),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B17,Подоконники!F:J,3,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B17,Подоконники!F:J,4,0),\"\")","v":""},null,null,""]
[null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(B18,Подоконники!F:J,1,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B18,Подоконники!F:J,2,0),\" (\",VLOOKUP(B18,Подоконники!F:J,5,0),\")\"),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B18,Подоконники!F:J,3,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B18,Подоконники!F:J,4,0),\"\")","v":""},null,null,""]
[null,null,null,null,"",{"$f":"IFERROR(VLOOKUP(B19,Подоконники!F:J,1,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B19,Подоконники!F:J,2,0),\" (\",VLOOKUP(B19,Подоконники!F:J,5,0),\")\"),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B19,Подоконники!F:J,3,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B19,Подоконники!F:J,4,0),\"\")","v":""},null,null,""]
[null,null,null,null,{"$f":"IF(B20=\"\",\"\",#REF!+1)","v":""},{"$f":"IFERROR(VLOOKUP(B20,Подоконники!F:J,1,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(CONCATENATE(VLOOKUP(B20,Подоконники!F:J,2,0),\" (\",VLOOKUP(B20,Подоконники!F:J,5,0),\")\"),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B20,Подоконники!F:J,3,0),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(B20,Подоконники!F:J,4,0),\"\")","v":""},null,null,{"$f":"IF(B20=\"\",\"\",Y20*U20/1000*W20*(1-AA20))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CEILING(SUM(AB11:AC20),1)","v":326}]

{"sheet":"Учет","index":2,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["i"]
[]
[null,"№пп","Артикул","Наименование Продукции","Размер","ЕдИзм","КаналСбыта","Цена","Кол-во"]
[null,{"$f":"ROW(Учет!$B4)-3","v":1},"A0001","Футболка RS, солнце",null,"шт","Склад РТД",100,2]
[null,{"$f":"ROW(Учет!$B5)-3","v":2},"A000299999","Футболка RS, заяц",null,"шт","Склад РТД",110,2]
[null,{"$f":"ROW(Учет!$B6)-3","v":3},"A0003","Футболка RS, зайчиха",null,"шт","Склад РТД",200,1]
[null,{"$f":"ROW(Учет!$B7)-3","v":4},"A0004","Футболка RS, ведро",null,"шт","Склад РТД",130,2]
[null,{"$f":"ROW(Учет!$B8)-3","v":5},"A0005","Майка RS, солнце",null,"шт","Склад РТД",170,1]
[null,{"$f":"ROW(Учет!$B9)-3","v":6},"A000777","Майка RS, зайчиха",null,"шт","Склад РТД",540,1]
[null,{"$f":"ROW(Учет!$B10)-3","v":7},"A0007","Майка RS, заяц",null,"шт","Склад РТД",439.33333333333297,1]
[null,{"$f":"ROW(Учет!$B11)-3","v":8},"A0008","Майка RS, морковка",null,"шт","Склад РТД",505.33333333333297,1]
[null,{"$f":"ROW(Учет!$B12)-3","v":9},"A0009","Шапка RS",null,"шт","Склад РТД",571.33333333333303,1]
[null,{"$f":"ROW(Учет!$B13)-3","v":10},"A0010","Медведь пират",null,"шт","Склад РТД",637.33333333333303,1]
[]
[null,{"$f":"ROW(Учет!$B15)-4","v":11},"A0011","Зайка с корзинкой",null,"шт","Склад РТД",703.33333333333303,1]
[null,{"$f":"ROW(Учет!$B16)-4","v":12},"A0012","Ёжик с яблоком",null,"шт","Склад РТД",769.33333333333303,1]
[null,{"$f":"ROW(Учет!$B17)-4","v":13},"A0013","Ежичка с морковкой ",null,"шт","Склад РТД",835.33333333333303,1]
[null,{"$f":"ROW(Учет!$B18)-4","v":14},"A0014","Котик желтый ",null,"шт","Склад РТД",901.33333333333303,1]
[null,{"$f":"ROW(Учет!$B19)-4","v":15},"A0015","Пандочка",null,"шт","Склад РТД",967.33333333333303,1]
[null,{"$f":"ROW(Учет!$B20)-4","v":16},"A0016","Тигр",null,"шт","Склад РТД",1033.3333333333301,1]
[null,{"$f":"ROW(Учет!$B21)-4","v":17},"A0017","Слон",null,"шт","Склад РТД",1099.3333333333301,1]
[null,{"$f":"ROW(Учет!$B22)-4","v":18},"A0018","Кошки",null,"пара","Склад РТД",1165.3333333333301,1]
[null,{"$f":"ROW(Учет!$B23)-4","v":19},"A0019","Ёжик",null,"шт","Склад РТД",1231.3333333333301,1]
[null,{"$f":"ROW(Учет!$B24)-4","v":20},"A0020","Собаки",null,"пара","Склад РТД",1297.3333333333301,1]

{"sheet":"Подоконники","index":3,"n_rows":80,"n_cols":10,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[null,null,"i"]
[null,null,null,"Серия",null,"Артикул","Наименование","Ширина","Цена","ЕдИзм"]
[null,null,"KRAFT Біле","KRAFT Біле",null,1015,"Підвіконня KRAFT Біле",150,{"$f":"Прайс!C17","v":105},"м. п."]
[null,null,"KRAFT Біле","KRAFT Біле",null,1020,"Підвіконня KRAFT Біле",200,{"$f":"Прайс!D17","v":139},"м. п."]
[null,null,"KRAFT Біле","KRAFT Біле",null,1025,"Підвіконня KRAFT Біле",250,{"$f":"Прайс!E17","v":174},"м. п."]
[null,null,"KRAFT Біле","KRAFT Біле",null,1030,"Підвіконня KRAFT Біле",300,{"$f":"Прайс!F17","v":208},"м. п."]
[null,null,"KRAFT Біле","KRAFT Біле",null,1035,"Підвіконня KRAFT Біле",350,{"$f":"Прайс!G17","v":243},"м. п."]
[null,null,"KRAFT Біле","KRAFT Біле",null,1040,"Підвіконня KRAFT Біле",400,{"$f":"Прайс!H17","v":278},"м. п."]
[null,null,"KRAFT Біле","KRAFT Біле",null,1045,"Підвіконня KRAFT Біле",450,{"$f":"Прайс!I17","v":312},"м. п."]
[null,null,"KRAFT Біле","KRAFT Біле",null,1050,"Підвіконня KRAFT Біле",500,{"$f":"Прайс!J17","v":347},"м. п."]
[null,null,"KRAFT Біле","KRAFT Біле",null,1055,"Підвіконня KRAFT Біле",600,{"$f":"Прайс!K17","v":416},"м. п."]
[null,null,"KRAFT Біле","KRAFT Біле",null,1060,"Підвіконня KRAFT Біле",700,{"$f":"Прайс!L17","v":485},"м. п."]
[null,null,"KRAFT Біле","KRAFT Біле",null,1001,"Заглушка до п-ння KRAFT Біла",null,{"$f":"Прайс!N17","v":35},"шт."]
[null,null,"KRAFT Біле","KRAFT Біле",null,1002,"З'єднювач до п-ння KRAFT Біла",null,{"$f":"Прайс!O17","v":45},"шт."]
[null,null,"KRAFT Антрацит","KRAFT  Антрацит",null,1115,"Підвіконня KRAFT Антрацит",150,{"$f":"Прайс!C$18","v":130},"м. п."]
[null,null,"KRAFT Антрацит","KRAFT  Антрацит",null,1120,"Підвіконня KRAFT Антрацит",200,{"$f":"Прайс!D$18","v":173},"м. п."]
[null,null,"KRAFT Антрацит","KRAFT Антрацит",null,1125,"Підвіконня KRAFT Антрацит",250,{"$f":"Прайс!E$18","v":216},"м. п."]
[null,null,"KRAFT Антрацит","KRAFT  Антрацит",null,1130,"Підвіконня KRAFT Антрацит",300,{"$f":"Прайс!F$18","v":260},"м. п."]
[null,null,"KRAFT Антрацит","KRAFT Антрацит",null,1135,"Підвіконня KRAFT Антрацит",350,{"$f":"Прайс!G$18","v":303},"м. п."]
[null,null,"KRAFT Антрацит","KRAFT  Антрацит",null,1140,"Підвіконня KRAFT Антрацит",400,{"$f":"Прайс!H$18","v":346},"м. п."]
[null,null,"KRAFT Антрацит","KRAFT Антрацит",null,1145,"Підвіконня KRAFT Антрацит",450,{"$f":"Прайс!I$18","v":389},"м. п."]
[null,null,"KRAFT Антрацит","KRAFT  Антрацит",null,1150,"Підвіконня KRAFT Антрацит",500,{"$f":"Прайс!J$18","v":433},"м. п."]
[null,null,"KRAFT Антрацит","KRAFT Антрацит",null,1160,"Підвіконня KRAFT Антрацит",600,{"$f":"Прайс!K$18","v":519},"м. п."]
[null,null,"KRAFT Антрацит","KRAFT  Антрацит",null,1101,"Заглушка до п-ння KRAFT Антрацит",null,{"$f":"Прайс!N$18","v":45},"шт."]
[null,null,"KRAFT Антрацит","KRAFT Антрацит",null,1102,"З'єднювач до п-ння KRAFT Антрацит",null,{"$f":"Прайс!O$18","v":55},"шт."]
[null,null,"KRAFT Горіх","KRAFT Горіх",null,1215,"Підвіконня KRAFT Горіх",150,{"$f":"Прайс!C$18","v":130},"м. п."]
[null,null,"KRAFT Горіх","KRAFT Горіх",null,1220,"Підвіконня KRAFT Горіх",200,{"$f":"Прайс!D$18","v":173},"м. п."]
[null,null,"KRAFT Горіх","KRAFT Горіх",null,1225,"Підвіконня KRAFT Горіх",250,{"$f":"Прайс!E$18","v":216},"м. п."]
[null,null,"KRAFT Горіх","KRAFT Горіх",null,1230,"Підвіконня KRAFT Горіх",300,{"$f":"Прайс!F$18","v":260},"м. п."]
[null,null,"KRAFT Горіх","KRAFT Горіх",null,1235,"Підвіконня KRAFT Горіх",350,{"$f":"Прайс!G$18","v":303},"м. п."]
[null,null,"KRAFT Горіх","KRAFT Горіх",null,1240,"Підвіконня KRAFT Горіх",400,{"$f":"Прайс!H$18","v":346},"м. п."]
[null,null,"KRAFT Горіх","KRAFT Горіх",null,1245,"Підвіконня KRAFT Горіх",450,{"$f":"Прайс!I$18","v":389},"м. п."]
[null,null,"KRAFT Горіх","KRAFT Горіх",null,1250,"Підвіконня KRAFT Горіх",500,{"$f":"Прайс!J$18","v":433},"м. п."]
[null,null,"KRAFT Горіх","KRAFT Горіх",null,1260,"Підвіконня KRAFT Горіх",600,{"$f":"Прайс!K$18","v":519},"м. п."]
[null,null,"KRAFT Горіх","KRAFT Горіх",null,1201,"Заглушка до п-ння KRAFT Горіх",null,{"$f":"Прайс!N$18","v":45},"шт."]
[null,null,"KRAFT Горіх","KRAFT Горіх",null,1202,"З'єднювач до п-ння KRAFT Горіх",null,{"$f":"Прайс!O$18","v":55},"шт."]
[null,null,"KRAFT Сірий Дуб","KRAFT Сірий Дуб",null,1315,"Підвіконня KRAFT Сірий Дуб",150,{"$f":"Прайс!C$18","v":130},"м. п."]
[null,null,"KRAFT Сірий Дуб","KRAFT Сірий Дуб",null,1320,"Підвіконня KRAFT Сірий Дуб",200,{"$f":"Прайс!D$18","v":173},"м. п."]
[null,null,"KRAFT Сірий Дуб","KRAFT Сірий Дуб",null,1325,"Підвіконня KRAFT Сірий Дуб",250,{"$f":"Прайс!E$18","v":216},"м. п."]
[null,null,"KRAFT Сірий Дуб","KRAFT Сірий Дуб",null,1330,"Підвіконня KRAFT Сірий Дуб",300,{"$f":"Прайс!F$18","v":260},"м. п."]
[null,null,"KRAFT Сірий Дуб","KRAFT Сірий Дуб",null,1335,"Підвіконня KRAFT Сірий Дуб",350,{"$f":"Прайс!G$18","v":303},"м. п."]
[null,null,"KRAFT Сірий Дуб","KRAFT Сірий Дуб",null,1340,"Підвіконня KRAFT Сірий Дуб",400,{"$f":"Прайс!H$18","v":346},"м. п."]
[null,null,"KRAFT Сірий Дуб","KRAFT Сірий Дуб",null,1345,"Підвіконня KRAFT Сірий Дуб",450,{"$f":"Прайс!I$18","v":389},"м. п."]
[null,null,"KRAFT Сірий Дуб","KRAFT Сірий Дуб",null,1350,"Підвіконня KRAFT Сірий Дуб",500,{"$f":"Прайс!J$18","v":433},"м. п."]
[null,null,"KRAFT Сірий Дуб","KRAFT Сірий Дуб",null,1360,"Підвіконня KRAFT Сірий Дуб",600,{"$f":"Прайс!K$18","v":519},"м. п."]
[null,null,"KRAFT Сірий Дуб","KRAFT Сірий Дуб",null,1301,"Заглушка до п-ння KRAFT Сірий Дуб",null,{"$f":"Прайс!N$18","v":45},"шт."]
[null,null,"KRAFT Сірий Дуб","KRAFT Сірий Дуб",null,1302,"З'єднювач до п-ння KRAFT Сірий Дуб",null,{"$f":"Прайс!O$18","v":55},"шт."]
[null,null,"KRAFT Полярний Дуб","KRAFT Полярний Дуб",null,1415,"Підвіконня KRAFT Полярний Дуб",150,{"$f":"Прайс!C$18","v":130},"м. п."]
[null,null,"KRAFT Полярний Дуб","KRAFT Полярний Дуб",null,1420,"Підвіконня KRAFT Полярний Дуб",200,{"$f":"Прайс!D$18","v":173},"м. п."]
[null,null,"KRAFT Полярний Дуб","KRAFT Полярний Дуб",null,1425,"Підвіконня KRAFT Полярний Дуб",250,{"$f":"Прайс!E$18","v":216},"м. п."]
[null,null,"KRAFT Полярний Дуб","KRAFT Полярний Дуб",null,1430,"Підвіконня KRAFT Полярний Дуб",300,{"$f":"Прайс!F$18","v":260},"м. п."]
[null,null,"KRAFT Полярний Дуб","KRAFT Полярний Дуб",null,1435,"Підвіконня KRAFT Полярний Дуб",350,{"$f":"Прайс!G$18","v":303},"м. п."]
[null,null,"KRAFT Полярний Дуб","KRAFT Полярний Дуб",null,1440,"Підвіконня KRAFT Полярний Дуб",400,{"$f":"Прайс!H$18","v":346},"м. п."]
[null,null,"KRAFT Полярний Дуб","KRAFT Полярний Дуб",null,1445,"Підвіконня KRAFT Полярний Дуб",450,{"$f":"Прайс!I$18","v":389},"м. п."]
[null,null,"KRAFT Полярний Дуб","KRAFT Полярний Дуб",null,1450,"Підвіконня KRAFT Полярний Дуб",500,{"$f":"Прайс!J$18","v":433},"м. п."]
[null,null,"KRAFT Полярний Дуб","KRAFT Полярний Дуб",null,1460,"Підвіконня KRAFT Полярний Дуб",600,{"$f":"Прайс!K$18","v":519},"м. п."]
[null,null,"KRAFT Полярний Дуб","KRAFT Полярний Дуб",null,1401,"Заглушка до п-ння KRAFT Полярний Дуб",null,{"$f":"Прайс!N$18","v":45},"шт."]
[null,null,"KRAFT Полярний Дуб","KRAFT Полярний Дуб",null,1402,"З'єднювач до п-ння KRAFT Полярний Дуб",null,{"$f":"Прайс!O$18","v":55},"шт."]
[null,null,"KRAFT Золотий Дуб","KRAFT Золотий Дуб",null,1515,"Підвіконня KRAFT Золотий Дуб",150,{"$f":"Прайс!C$18","v":130},"м. п."]
[null,null,"KRAFT Золотий Дуб","KRAFT Золотий Дуб",null,1520,"Підвіконня KRAFT Золотий Дуб",200,{"$f":"Прайс!D$18","v":173},"м. п."]
[null,null,"KRAFT Золотий Дуб","KRAFT Золотий Дуб",null,1525,"Підвіконня KRAFT Золотий Дуб",250,{"$f":"Прайс!E$18","v":216},"м. п."]
[null,null,"KRAFT Золотий Дуб","KRAFT Золотий Дуб",null,1530,"Підвіконня KRAFT Золотий Дуб",300,{"$f":"Прайс!F$18","v":260},"м. п."]
[null,null,"KRAFT Золотий Дуб","KRAFT Золотий Дуб",null,1535,"Підвіконня KRAFT Золотий Дуб",350,{"$f":"Прайс!G$18","v":303},"м. п."]
[null,null,"KRAFT Золотий Дуб","KRAFT Золотий Дуб",null,1540,"Підвіконня KRAFT Золотий Дуб",400,{"$f":"Прайс!H$18","v":346},"м. п."]
[null,null,"KRAFT Золотий Дуб","KRAFT Золотий Дуб",null,1545,"Підвіконня KRAFT Золотий Дуб",450,{"$f":"Прайс!I$18","v":389},"м. п."]
[null,null,"KRAFT Золотий Дуб","KRAFT Золотий Дуб",null,1550,"Підвіконня KRAFT Золотий Дуб",500,{"$f":"Прайс!J$18","v":433},"м. п."]
[null,null,"KRAFT Золотий Дуб","KRAFT Золотий Дуб",null,1560,"Підвіконня KRAFT Золотий Дуб",600,{"$f":"Прайс!K$18","v":519},"м. п."]
[null,null,"KRAFT Золотий Дуб","KRAFT Золотий Дуб",null,1501,"Заглушка до п-ння KRAFT Золотий Дуб",null,{"$f":"Прайс!N$18","v":45},"шт."]
[null,null,"KRAFT Золотий Дуб","KRAFT Золотий Дуб",null,1502,"З'єднювач до п-ння KRAFT Золотий Дуб",null,{"$f":"Прайс!O$18","v":55},"шт."]
[null,null,"KRAFT Темний Дуб","KRAFT Темний Дуб",null,1615,"Підвіконня KRAFT Темний Дуб",150,{"$f":"Прайс!C$18","v":130},"м. п."]
[null,null,"KRAFT Темний Дуб","KRAFT Темний Дуб",null,1620,"Підвіконня KRAFT Темний Дуб",200,{"$f":"Прайс!D$18","v":173},"м. п."]
[null,null,"KRAFT Темний Дуб","KRAFT Темний Дуб",null,1625,"Підвіконня KRAFT Темний Дуб",250,{"$f":"Прайс!E$18","v":216},"м. п."]
[null,null,"KRAFT Темний Дуб","KRAFT Темний Дуб",null,1630,"Підвіконня KRAFT Темний Дуб",300,{"$f":"Прайс!F$18","v":260},"м. п."]
[null,null,"KRAFT Темний Дуб","KRAFT Темний Дуб",null,1635,"Підвіконня KRAFT Темний Дуб",350,{"$f":"Прайс!G$18","v":303},"м. п."]
[null,null,"KRAFT Темний Дуб","KRAFT Темний Дуб",null,1640,"Підвіконня KRAFT Темний Дуб",400,{"$f":"Прайс!H$18","v":346},"м. п."]
[null,null,"KRAFT Темний Дуб","KRAFT Темний Дуб",null,1645,"Підвіконня KRAFT Темний Дуб",450,{"$f":"Прайс!I$18","v":389},"м. п."]
[null,null,"KRAFT Темний Дуб","KRAFT Темний Дуб",null,1650,"Підвіконня KRAFT Темний Дуб",500,{"$f":"Прайс!J$18","v":433},"м. п."]
[null,null,"KRAFT Темний Дуб","KRAFT Темний Дуб",null,1660,"Підвіконня KRAFT Темний Дуб",600,{"$f":"Прайс!K$18","v":519},"м. п."]
[null,null,"KRAFT Темний Дуб","KRAFT Темний Дуб",null,1601,"Заглушка до п-ння KRAFT Темний Дуб",null,{"$f":"Прайс!N$18","v":45},"шт."]
[null,null,"KRAFT Темний Дуб","KRAFT Темний Дуб",null,1602,"З'єднювач до п-ння KRAFT Темний Дуб",null,{"$f":"Прайс!O$18","v":55},"шт."]

{"sheet":"Прайс","index":4,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":false,"merged":[[33,0,34,0],[35,0,36,0],[37,0,38,0]]}
[]
["Topalit ","грн"]
["ширина",100,150,200,250,300,350,400,450,500,null,null,null,"ABS","соед"]
["классик",null,942,1177,1322,1476,1767,2017,2554,68.150000000000006,null,null,70,180,530]
["дизайн",null,1083,1310,1484,1666,2034,2431,2935,3017,null,null,70,180,530]
[]
["Werzalit","грн"]
["ширина",100,150,200,250,300,350,400,450,500,600,null,null,"ABS","соед"]
[null,636,828,1050,1200,1344,1584,1824,"2040",2340,2580,null,null,150,530]
[]
["Crystalit","грн"]
["ширина",null,150,200,250,300,350,400,450,500,600,null,null,"Загл.","соед"]
["Цена Грн.",null,260,347,434,520,607,694,780,867,1040,null,null,"50",70]
[]
["Kraft  ","грн"]
["ширина",null,150,200,250,300,350,400,450,500,600,700,null,"Загл.","соед"]
["Белый ",null,105,139,174,208,243,278,312,347,416,485,null,35,45]
["Цветной",null,130,173,216,260,303,346,389,433,519,null,null,45,55]
[]
["Sauberg","грн",1.5]
["ширина",100,150,200,250,300,350,400,450,500,"<2к",600,"600<2к","Загл.","соед"]
["Бел. мат",{"$f":"38.57*1.5","v":57.855000000000004},{"$f":"57.86*1.5","v":86.789999999999992},{"$f":"77.14*1.5","v":115.71000000000001},{"$f":"96.43*1.5","v":144.64500000000001},{"$f":"115.72*1.5","v":173.57999999999998},{"$f":"135*1.5","v":202.5},{"$f":"154.29*1.5","v":231.435},{"$f":"173.57*1.5","v":260.35500000000002},{"$f":"192.86*1.5","v":289.29000000000002},{"$f":"192.86*1.5","v":289.29000000000002},{"$f":"231.43*1.5","v":347.14499999999998},{"$f":"231.43*1.5","v":347.14499999999998},30,60]
["Бел. глян",{"$f":"57*1.5","v":85.5},{"$f":"85.5*1.5","v":128.25},{"$f":"114*1.5","v":171},{"$f":"142.5*1.5","v":213.75},{"$f":"171*1.5","v":256.5},{"$f":"199.5*1.5","v":299.25},{"$f":"228*1.5","v":342},{"$f":"256.5*1.5","v":384.75},{"$f":"285*1.5","v":427.5},{"$f":"J23","v":427.5},{"$f":"342*1.5","v":513},{"$f":"L23","v":513},30,60]
["Цвет. мат",{"$f":"51.43*$C20","v":77.144999999999996},{"$f":"77.14*$C20","v":115.71000000000001},{"$f":"102.86*$C20","v":154.29},{"$f":"128.57*$C20","v":192.85499999999999},{"$f":"154.29*$C20","v":231.435},{"$f":"180*$C20","v":270},{"$f":"205.71*$C20","v":308.565},{"$f":"231.43*$C20","v":347.14499999999998},{"$f":"257.14*$C20","v":385.71},{"$f":"257.14*$C20","v":385.71},{"$f":"308.57*$C20","v":462.85500000000002},{"$f":"308.57*$C20","v":462.85500000000002},30,60]
["Цвет глян",{"$f":"64.14*$C20","v":96.210000000000008},{"$f":"96.21*$C20","v":144.315},{"$f":"128.28*$C20","v":192.42000000000002},{"$f":"160.35*$C20","v":240.52499999999998},{"$f":"192.43*$C20","v":288.64499999999998},{"$f":"224.5*$C20","v":336.75},{"$f":"256.57*$C20","v":384.85500000000002},{"$f":"288.64*$C20","v":432.96},{"$f":"320.71*$C20","v":481.06499999999994},{"$f":"J25","v":481.06499999999994},{"$f":"384.85*$C20","v":577.27500000000009},{"$f":"L25","v":577.27500000000009},30,60]
["Прям.біл",{"$f":"57*$C20","v":85.5},{"$f":"85.5*$C20","v":128.25},{"$f":"114*$C20","v":171},{"$f":"142.5*$C20","v":213.75},{"$f":"171*$C20","v":256.5},{"$f":"199.5*$C20","v":299.25},{"$f":"228*$C20","v":342},{"$f":"256.5*$C20","v":384.75},{"$f":"285*$C20","v":427.5},{"$f":"J26","v":427.5},{"$f":"342*$C20","v":513},{"$f":"L26","v":513},30,60]
[]
["Plastolit  ","грн"]
["ширина",100,150,200,250,300,350,400,450,500,600,null,null,"Загл.","соед"]
["Мат+Глянец",153,229,"303","380","454","531","607","684","760","910",null,null,"50","85"]
[]
["Danke","$  | грн",29]
["ширина",100,150,200,250,300,350,400,450,500,600,700,"Заг","соед"]
["Premium",7.2,10.8,14.4,18,21.6,25.2,28.8,32.4,36,43.2,50.4,2,2.5]
[null,{"$f":"B34*$C32","v":208.8},{"$f":"C34*$C32","v":313.20000000000005},{"$f":"D34*$C32","v":417.6},522,626.40000000000009,730.8,835.2,939.59999999999991,1044,1252.8000000000002,1461.6,58,72.5]
["Standart",5.2,7.8,10.4,13,15.6,18.2,20.8,23.4,26,31.2,36.4,2,2.5]
["Standart",{"$f":"B36*$C32","v":150.80000000000001},{"$f":"C36*$C32","v":226.2},301.60000000000002,377,452.4,527.79999999999995,603.20000000000005,678.59999999999991,754,904.8,1055.5999999999999,58,72.5]
["Komfort ",3,4.5,6,7.5,9,10.5,12,13.5,15,18,21,1,1.5]
["Komfort ",{"$f":"B38*$C32","v":87},{"$f":"C38*$C32","v":130.5},174,217.5,261,304.5,348,391.5,435,522,609,{"$f":"M38*$C32","v":29},{"$f":"N38*$C32","v":43.5}]
[]
["Estera","грн"]
["ширина",null,150,200,250,300,350,400,450,500,600,null,null,"загл","соед"]
["Цена грн",null,260,347,434,520,607,694,780,867,1040,null,null,35,70]
[]
["Openteck","Грн",27]
["ширина",100,150,200,250,300,350,400,450,500,600,650,700,"Загл.","соед"]
["Цена Бел.",{"$f":"30.67*1.5","v":46.005000000000003},{"$f":"46*1.5","v":69},{"$f":"3*C45","v":81},{"$f":"3.78*C45","v":102.05999999999999},{"$f":"4.5*C45","v":121.5},{"$f":"5.2*C45","v":140.4},{"$f":"5.9*C45","v":159.30000000000001},{"$f":"6.7*C45","v":180.9},{"$f":"7.4*C45","v":199.8},{"$f":"8.9*C45","v":240.3},{"$f":"10.4*C45","v":280.8},{"$f":"10.4*C45","v":280.8},30,60]
["Цена Цвет.",{"$f":"1.5*C45","v":40.5},{"$f":"2.3*C45","v":62.099999999999994},{"$f":"3*C45","v":81},{"$f":"3.78*C45","v":102.05999999999999},{"$f":"4.5*C45","v":121.5},{"$f":"5.2*C45","v":140.4},{"$f":"5.9*C45","v":159.30000000000001},{"$f":"6.7*C45","v":180.9},{"$f":"7.4*C45","v":199.8},{"$f":"8.9*C45","v":240.3},{"$f":"10.4*C45","v":280.8},{"$f":"10.4*C45","v":280.8},30,60]
[]
["WDS"]
["ширина",100,150,200,250,300,350,400,450,500,600,null,null,"Загл.","соед"]
["Мат Бел.",null,"190","252","315","380","440","505","566","630","755",null,null,"35","70"]
["Глян, бел, сер мрам, зол дуб.",null,"208","278","347","416","486","555","625","693","832",null,null,"35","70"]

{"sheet":"TEST","index":5,"n_rows":20,"n_cols":25,"rows_kept":20,"cut":false,"hidden":false,"merged":[[18,24,18,25],[19,24,19,25],[18,2,18,5],[18,6,18,14],[18,15,18,16],[18,17,18,18],[18,19,18,20],[18,21,18,22],[16,24,16,25],[17,2,17,5],[17,6,17,14],[17,15,17,16],[17,17,17,18],[17,19,17,20],[17,21,17,22],[17,24,17,25],[16,2,16,5],[16,6,16,14],[16,15,16,16],[16,17,16,18],[16,19,16,20],[16,21,16,22],[14,24,14,25],[15,2,15,5],[15,6,15,14],[15,15,15,16],[15,17,15,18],[15,19,15,20],[15,21,15,22],[15,24,15,25],[14,2,14,5],[14,6,14,14],[14,15,14,16],[14,17,14,18],[14,19,14,20],[14,21,14,22],[12,24,12,25],[13,2,13,5],[13,6,13,14],[13,15,13,16],[13,17,13,18],[13,19,13,20],[13,21,13,22],[13,24,13,25],[12,2,12,5],[12,6,12,14],[12,15,12,16],[12,17,12,18],[12,19,12,20],[12,21,12,22],[8,21,8,22],[10,24,10,25],[11,2,11,5],[11,6,11,14],[11,15,11,16],[11,17,11,18],[11,19,11,20],[11,21,11,22],[11,24,11,25],[10,2,10,5],[10,6,10,14],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[5,17,5,21],[6,12,6,15],[6,17,6,21],[8,24,8,25],[9,2,9,5],[9,6,9,14],[9,15,9,16],[9,17,9,18],[9,19,9,20],[9,21,9,22],[9,24,9,25],[8,2,8,5],[8,6,8,14],[8,15,8,16],[8,17,8,18],[8,19,8,20],[7,12,7,15],[1,1,1,3],[1,6,1,15],[2,1,2,3],[2,6,2,15],[3,1,3,3],[3,6,3,15],[5,6,6,10],[5,12,5,15]]}
[34789]
[null,"Одержувач",null,null,null,null,{"$f":"СчетЗаказ!J3","v":"Андрей"}]
[null,"Телефон",null,null,null,null,{"$f":"СчетЗаказ!J4","v":6650505050}]
[null,"Адреса:",null,null,null,null,{"$f":"СчетЗаказ!J5","v":"г. Киев ул.МирYYYYYYльская 8а"}]
[]
[null,null,null,null,null,null,"ЗАМОВЛЕННЯ",null,null,null,null,null,"Номер документа"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"СчетЗаказ!P8","v":34},null,null,null,null,{"$f":"TODAY()","v":"2021-08-31"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-08-31"}]
[null,"№ п/п","Код",null,null,null,"Найменування товару",null,null,null,null,null,null,null,null,"Ширина",null,"Довжина",null,"Кіл-ть",null,"Ціна",null,"%","Сума"]
[null,{"$f":"СчетЗаказ!E11","v":1},{"$f":"IFERROR(VLOOKUP(#REF!,Подоконники!C:G,1,0),\"\")","v":""},null,null,null,{"$f":"СчетЗаказ!J11","v":"Підвіконня KRAFT Горіх (м. п.)"},null,null,null,null,null,null,null,null,{"$f":"СчетЗаказ!S11","v":150},null,{"$f":"СчетЗаказ!U11","v":1200},null,{"$f":"СчетЗаказ!W11","v":1},null,{"$f":"СчетЗаказ!Y11","v":130},null,{"$f":"СчетЗаказ!AA11","v":0},{"$f":"СчетЗаказ!AB11","v":156}]
[null,{"$f":"СчетЗаказ!E12","v":2},{"$f":"IFERROR(VLOOKUP(#REF!,Подоконники!C:G,1,0),\"\")","v":""},null,null,null,{"$f":"СчетЗаказ!J12","v":"Підвіконня KRAFT Горіх (м. п.)"},null,null,null,null,null,null,null,null,{"$f":"СчетЗаказ!S12","v":150},null,{"$f":"СчетЗаказ!U12","v":1305},null,{"$f":"СчетЗаказ!W12","v":1},null,{"$f":"СчетЗаказ!Y12","v":130},null,{"$f":"СчетЗаказ!AA12","v":0},{"$f":"СчетЗаказ!AB12","v":169.65}]
[null,{"$f":"СчетЗаказ!E13","v":3},{"$f":"IFERROR(VLOOKUP(#REF!,Подоконники!C:G,1,0),\"\")","v":""},null,null,null,{"$f":"СчетЗаказ!J13","v":"Заглушка до п-ння KRAFT Горіх (шт.)"},null,null,null,null,null,null,null,null,{"$f":"СчетЗаказ!S13","v":0},null,{"$f":"СчетЗаказ!U13","v":1},null,{"$f":"СчетЗаказ!W13","v":2},null,{"$f":"СчетЗаказ!Y13","v":45},null,{"$f":"СчетЗаказ!AA13","v":0},{"$f":"СчетЗаказ!AB13","v":0.09}]
[null,{"$f":"СчетЗаказ!E14","v":""},{"$f":"IFERROR(VLOOKUP(#REF!,Подоконники!C:G,1,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"СчетЗаказ!S14","v":""},null,{"$f":"СчетЗаказ!U14","v":0},null,{"$f":"СчетЗаказ!W14","v":0},null,{"$f":"СчетЗаказ!Y14","v":""},null,{"$f":"СчетЗаказ!AA14","v":0},{"$f":"СчетЗаказ!AB14","v":""}]
[null,{"$f":"СчетЗаказ!E15","v":""},{"$f":"IFERROR(VLOOKUP(#REF!,Подоконники!C:G,1,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"СчетЗаказ!S15","v":""},null,{"$f":"СчетЗаказ!U15","v":0},null,{"$f":"СчетЗаказ!W15","v":0},null,{"$f":"СчетЗаказ!Y15","v":""},null,{"$f":"СчетЗаказ!AA15","v":0},{"$f":"СчетЗаказ!AB15","v":""}]
[null,{"$f":"СчетЗаказ!E16","v":""},{"$f":"IFERROR(VLOOKUP(#REF!,Подоконники!C:G,1,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"СчетЗаказ!S16","v":""},null,{"$f":"СчетЗаказ!U16","v":0},null,{"$f":"СчетЗаказ!W16","v":0},null,{"$f":"СчетЗаказ!Y16","v":""},null,{"$f":"СчетЗаказ!AA16","v":0},{"$f":"СчетЗаказ!AB16","v":""}]
[null,{"$f":"СчетЗаказ!E17","v":""},{"$f":"IFERROR(VLOOKUP(#REF!,Подоконники!C:G,1,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"СчетЗаказ!S17","v":""},null,{"$f":"СчетЗаказ!U17","v":0},null,{"$f":"СчетЗаказ!W17","v":0},null,{"$f":"СчетЗаказ!Y17","v":""},null,{"$f":"СчетЗаказ!AA17","v":0},{"$f":"СчетЗаказ!AB17","v":""}]
[null,{"$f":"СчетЗаказ!E18","v":""},{"$f":"IFERROR(VLOOKUP(#REF!,Подоконники!C:G,1,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"СчетЗаказ!S18","v":""},null,{"$f":"СчетЗаказ!U18","v":0},null,{"$f":"СчетЗаказ!W18","v":0},null,{"$f":"СчетЗаказ!Y18","v":""},null,{"$f":"СчетЗаказ!AA18","v":0},{"$f":"СчетЗаказ!AB18","v":""}]
[null,{"$f":"СчетЗаказ!E19","v":""},{"$f":"IFERROR(VLOOKUP(#REF!,Подоконники!C:G,1,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"СчетЗаказ!S19","v":""},null,{"$f":"СчетЗаказ!U19","v":0},null,{"$f":"СчетЗаказ!W19","v":0},null,{"$f":"СчетЗаказ!Y19","v":""},null,{"$f":"СчетЗаказ!AA19","v":0},{"$f":"СчетЗаказ!AB19","v":""}]
[null,{"$f":"СчетЗаказ!E20","v":""},{"$f":"IFERROR(VLOOKUP(#REF!,Подоконники!C:G,1,0),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"СчетЗаказ!S20","v":""},null,{"$f":"СчетЗаказ!U20","v":0},null,{"$f":"СчетЗаказ!W20","v":0},null,{"$f":"СчетЗаказ!Y20","v":""},null,{"$f":"СчетЗаказ!AA20","v":0},{"$f":"СчетЗаказ!AB20","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y10:Z19)","v":325.73999999999995}]