{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["faktura","понедельник"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"faktura","index":0,"n_rows":35,"n_cols":17,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,4,0,6],[2,0,2,2],[8,0,8,2],[12,3,13,4],[12,5,13,6],[8,3,8,6],[9,3,9,6],[12,0,13,1],[4,0,4,2],[5,0,5,2],[6,0,6,2],[9,0,9,2],[10,0,10,2],[1,0,1,2],[2,3,2,5],[0,11,0,13],[2,11,2,12],[18,7,18,9],[16,7,16,8],[4,11,4,13],[8,11,8,13],[9,11,9,13],[7,7,7,9],[8,7,8,9],[9,7,9,9],[12,7,13,9],[5,7,5,9],[6,7,6,9],[1,7,1,9],[2,7,2,9],[10,12,10,13],[10,7,10,9],[3,0,3,2],[3,7,3,9],[4,7,4,9],[17,7,17,9],[14,6,15,6],[14,5,15,5],[14,3,15,4],[10,4,10,6],[4,3,4,6],[40,12,40,13],[16,0,16,1],[22,7,22,9],[23,7,23,9],[24,7,24,9],[25,7,25,9],[26,7,26,9],[31,0,31,2],[32,0,32,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[27,0,27,2],[28,0,28,2],[30,0,30,2],[31,7,31,9],[32,7,32,9],[29,0,29,2],[20,0,20,2],[28,7,28,9],[29,7,29,9],[30,7,30,9],[20,7,20,9],[21,7,21,9],[12,13,13,13],[27,7,27,9],[14,13,15,13],[12,11,13,12],[26,0,26,2],[14,10,15,11],[14,12,15,12],[17,0,17,2],[18,0,18,2],[19,0,19,2],[19,7,19,9]]}
[null,null,null,null,"Առաքման   գիրք   25/17771",null,null,null,null,null,null,{"$f":"E1","v":"Առաքման   գիրք   25/17771"}]
["менеджер",null,null,null,null,null,null,{"$f":"A2","v":"менеджер"}]
[null,null,null,"Հաշիվ  ֆակտուրա  N",null,null,2,0,null,null,null,{"$f":"D3","v":"Հաշիվ  ֆակտուրա  N"},null,{"$f":"G3","v":2}]
["Կոտայքի   մարզ   ք.  Աբովյան",null,null,null,null,null,null,"Կոտայքի   մարզ   ք.  Աբովյան"]
["Կոլխոզնիկների   1",null,null,{"$f":"DATE(YEAR(TODAY()),MONTH(F15),DAY(F15))","v":"2015-02-15"},null,null,null,"Կոլխոզնիկների   1",null,null,null,{"$f":"DATE(YEAR(TODAY()),MONTH(M15),DAY(M15))","v":"2015-02-15"}]
["ՀՎՀՀ  43070372",null,null,null,null,null,null,"ՀՎՀՀ  43070372"]
["Առաքման  կայարանը   ՀՀ   տարածք",null,null,null,"Պահեստ","Գործառության   N","Ծածկագիր","Առաքման  կայարանը   ՀՀ   տարածք",null,null,null,"Պահեստ","Գործառության   N","Ծածկագիր"]
[]
["Վճարողը   և  նրա   տվյալները",null,null,"Ք.Չարենցավան  4-րդ  թաղ. 36շ.",null,null,null,{"$f":"A9","v":"Վճարողը   և  նրա   տվյալները"},null,null,null,{"$f":"D9","v":"Ք.Չարենցավան  4-րդ  թաղ. 36շ."}]
["Մատակարարման   միջոց՝    ",null,null,"abo",null,null,null,{"$f":"A10","v":"Մատակարարման   միջոց՝    "},null,null,null,{"$f":"D10","v":"abo"}]
[" ֆորդ    տրանզիտ   33  sv 649",null,null,"ՀՎՀՀ",101214637.8,null,null,{"$f":"A11","v":" ֆորդ    տրանզիտ   33  sv 649"},null,null,null,{"$f":"D11","v":"ՀՎՀՀ"},{"$f":"E11","v":101214637.8}]
[]
["Պայմանագրի-պատվերը",null,null,"Տեղերի   քանակը",null,"Կշիռ",null,"Պայմանագրի-պատվերը",null,null,null,"Տեղերի   քանակը",null,"Կշիռ"]
[]
[null,null,null,"Բարձման  ամսաթիվը",null,{"$f":"TODAY()","v":"2015-02-15"},"Անդորրագիր   N",null,null,null,"Բարձման  ամսաթիվը",null,{"$f":"TODAY()","v":"2015-02-15"},"Անդորրագիր   N"]
["Լրացուցիչ   պայմաններ",null,null,null,null,null,null,"Լրացուցիչ   պայմաններ"]
["Անվանումը",null,null,"Չափ.մվ.","кол.","цена","Գումարը","Անվանումը",null,null,"Չափ.մվ.","кол.","цена","Գումարը"]
["натур-сок  0.25",null,null,"հատ",24,{"$f":"IF(E18>0,понедельник!E5,\"\")","v":80},{"$f":"IF(E18>0,E18*F18,\"\")","v":1920},{"$f":"A18","v":"натур-сок  0.25"},null,null,"հատ",{"$f":"IF(E18>0,E18,\"\")","v":24},{"$f":"IF(F18>0,F18,\"\")","v":80},{"$f":"IF(G18>0,G18,\"\")","v":1920},null,2600,2800]
["халодны  кофе",null,null,"հատ",40,{"$f":"IF(E19>0,понедельник!F5,\"\")","v":60},{"$f":"IF(E19>0,E19*F19,\"\")","v":2400},{"$f":"A19","v":"халодны  кофе"},null,null,"հատ",{"$f":"IF(E19>0,E19,\"\")","v":40},{"$f":"IF(F19>0,F19,\"\")","v":60},{"$f":"IF(G19>0,G19,\"\")","v":2400},null,450,500]
["малоты  кофе  кг.",null,null,"հատ",56,{"$f":"IF(E20>0,понедельник!G5,\"\")","v":80},4480,"малоты  кофе  кг.",null,null,"հատ",56,80,4480]
["малоты  кофе  Джови  шт.",null,null,"հատ",72,{"$f":"IF(E21>0,понедельник!H5,\"\")","v":500},36000,"малоты  кофе  Джови  шт.",null,null,"հատ",72,500,36000,null,{"$f":"P18/P19","v":5.7777777777777777},{"$f":"Q18/Q19","v":5.6}]
["малоты  кофе  Лидер  шт.",null,null,"հատ",88,{"$f":"IF(E22>0,понедельник!I5,\"\")","v":125},11000,"малоты  кофе  Лидер  шт.",null,null,"հատ",88,125,11000]
["Ади-Буди",null,null,"հատ",152,{"$f":"IF(E23>0,понедельник!J5,\"\")","v":200},30400,"Ади-Буди",null,null,"հատ",152,200,30400]
["Соска",null,null,"հատ",168,{"$f":"IF(E24>0,понедельник!F10,\"\")","v":0},0,"Соска",null,null,"հատ",168,"",""]
[null,null,null,"հատ",null,{"$f":"IF(E25>0,понедельник!G10,\"\")","v":""},"",0,null,null,"հատ","","",""]
[null,null,null,"հատ",null,{"$f":"IF(E26>0,понедельник!H10,\"\")","v":""},"",0,null,null,"հատ","","",""]
[null,null,null,"հատ",null,{"$f":"IF(E27>0,понедельник!I10,\"\")","v":""},"",0,null,null,"հատ","","",""]
[null,null,null,"հատ",null,{"$f":"IF(E28>0,понедельник!E15,\"\")","v":""},"",0,null,null,"հատ","","",""]
[null,null,null,"հատ",null,{"$f":"IF(E29>0,понедельник!F15,\"\")","v":""},"",0,null,null,"հատ","","",""]
[null,null,null,"հատ",null,{"$f":"IF(E30>0,понедельник!G15,\"\")","v":""},"",0,null,null,"հատ","","",""]
[null,null,null,"հատ",null,{"$f":"IF(E31>0,понедельник!H15,\"\")","v":""},"",0,null,null,"հատ","","",""]
[null,null,null,"հատ",null,{"$f":"IF(E32>0,понедельник!I15,\"\")","v":""},"",0,null,null,"հատ","","",""]
[null,null,null,"հատ",null,{"$f":"IF(E33>0,понедельник!E20,\"\")","v":""},"",0,null,null,"հատ","","",""]
["ԸՆԴՀԱՆՈՒՐԸ",null,null,null,null,null,{"$f":"SUM(G18:G33)","v":86200},"ԸՆԴՀԱՆՈՒՐԸ",null,null,null,null,null,{"$f":"G34","v":86200}]
["Հանձնեց՝   Հ.Ղամբարյան",null,null,"Ընդհունեց՝",null,null,null,"Հանձնեց՝   Հ.Ղամբարյան",null,null,"Ընդհունեց՝"]

{"sheet":"понедельник","index":1,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,3,43,16]]}
[]
[]
[null,null,"2015-02-02",null,"лим-1,5","лим-0,5","тан-0,5","натур-сок  2","натур-сок  0.25","халодны  кофе","малоты  кофе  кг.","малоты  кофе  Джови  шт.","малоты  кофе  Лидер  шт.","куруруз","чипси  80  гр.","чипси  200  гр.","Ади-Буди","Соска","Бочка","Ведро"]
[null,"адресс"]
[null,"Чаренцаван","имя  фамиля","ՀՎՀՀ",80,60,80,500,125,200,200,200,200,200,200,200,200,200,200,200,"скидка","сумма"]
[null,"Ք.Չարենցավան  3-րդ  թաղ. 38շ.","Ա.Ձ.   Մաթևոսյան   Արմեն",42256545,"8+5",null,null,6,10,10,10,10,10,10,10,10,10,10,10,10,32,26858,{"$f":"SUMPRODUCT($F$5:$T$5,F6:T6)+X6","v":26858},{"$f":"80*8*95%","v":608}]
[null,"Ք.Չարենցավան  3-րդ  թաղ. 38շ.","Ա.Ձ.   Մաթևոսյան   Արմեն",35658975,null,"24+5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,1368,{"$f":"SUMPRODUCT($E$5:$T$5,E7:T7)-U7","v":-72}]
[null,"Ք.Չարենցավան  3-րդ  թաղ. 40շ.","Ա.Ձ.   Սարգսյան  Կարեն",25854565,72,"48+10",24,"8+5",24,40,56,72,88,104,120,136,152,168,184,200,488,281072,274192]
[null,"Ք.Չարենցավան  4-րդ  թաղ. 2շ.","Ա.Ձ.   Կարապետյան  Մարի",85456523,null,24,24,8,24,40,56,72,88,104,120,136,152,168,184,200,0,274360,274360]
[null,"Ք.Չարենցավան  4-րդ  թաղ. 20շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",77255533,60,null,null,16,24,40,56,72,88,104,120,136,152,168,184,200,0,279800,279800]
[null,"Ք.Չարենցավան  4-րդ  թաղ. 30շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",89235085,48,24,24,8,60,40,56,null,88,null,120,136,152,null,null,null,0,137100,137100]
[null,"Ք.Չարենցավան  4-րդ  թաղ. 36շ.","abo",101214637.8,null,null,null,null,24,40,56,72,88,null,null,null,152,168,null,null,0,118200,118200]
[null,"Ք.Չարենցավան  4-րդ  թաղ. 45շ.","kbo",113194190.2,120,24,60,8,48,40,56,72,88,104,120,136,152,168,184,200,0,289840,289840]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 16շ.","mbo",125173742.59999999,null,20,null,20,70,null,null,null,null,null,null,null,null,null,null,null,0,19950,19950]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 20շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",137153295,72,48,24,20,24,null,null,null,null,null,null,null,null,null,null,null,0,23560,23560]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 26շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",149132847.40000001,60,24,120,8,60,null,null,null,null,null,null,null,null,null,null,null,0,27340,27340]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 46շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",161112399.80000001,48,60,24,20,24,null,null,null,null,null,null,null,null,null,null,null,0,22360,22360]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,24,8,24,null,null,null,null,null,null,null,null,null,null,null,0,15160,15160]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,24,8,24,null,null,null,null,null,null,null,null,null,null,null,0,15160,15160]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,24,8,24,null,null,null,null,null,null,null,null,null,null,null,0,15160,15160]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,24,8,24,null,null,null,null,null,null,null,null,null,null,null,0,15160,15160]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,24,8,24,null,null,null,null,null,null,null,null,null,null,null,0,15160,15160]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,24,8,24,null,null,null,null,null,null,null,null,null,null,null,0,15160,15160]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,24,8,24,null,null,null,null,null,null,null,null,null,null,null,0,15160,15160]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,24,8,24,null,null,null,null,null,null,null,null,null,null,null,0,15160,15160]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,24,8,24,null,null,null,null,null,null,null,null,null,null,null,0,15160,15160]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,24,8,24,null,null,null,null,null,null,null,null,null,null,null,0,15160,15160]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,24,8,24,null,null,null,null,null,null,null,null,null,null,null,0,15160,15160]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,24,8,24,null,null,null,null,null,null,null,null,null,null,null,0,15160,15160]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,24,8,24,null,null,null,null,null,null,null,null,null,null,null,0,15160,15160]
[null,"Ք.Չարենցավան  2-րդ  թաղ. 48շ.","Ա.Ձ.   Մաթևոսյան   Արթուր",173091952.19999999,60,24,"24+5",8,24,null,null,null,null,null,null,null,null,null,null,null,96,15064,{"$f":"SUMPRODUCT($E$5:$T$5,E31:T31)-U31","v":13144}]
[]
[]
[]
[]
[]
[null,null,null," так  вот  в  ячейках  Е6:Т31  находится   количество  проданных  товаров,Е5:Т5  цены,нужно  считать  скидки  а  они  у  нас  пишутся  как  G31,то ист.  24  это  количество  а  +5  это  процент  скидки Е31= 5%*G5, а V31=значение  СУММПРОИЗВ($E$5:$T$5,E31:T31)-U31\n"]