{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["желаемый результат","исходные данные","Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,0,15,0]]}
[null,null,null,null,"с учетом процента по ндс",null,null,null,null,null,null,"Цвветами выделили на двух листах что откуда берется. Для простоты понимания.. Желаемый результат конечно без заливок должен быть.  Таким образом хочется вести подсчеты приходных накладных по овощам.Жирной линией выделю внутренний желаемый фрагмент. Для следующего дня ниже должна повиться еще одна такая же таблица только с новыми данными..Сама жирная обводка не нужна."]
[]
[null,null,null,"кол-во в накл","цена по прайсу",null,"цена без ндс","ндс","цена с ндс"]
["2016-06-01",null,"бананы",131.19999999999999,64.8,null,{"$f":"ROUND(I4/1.18,2)","v":7204.88},{"$f":"ROUND(I4-G4,2)","v":1296.8800000000001},{"$f":"D4*E4","v":8501.7599999999984}]
[null,null,"груша св",201,79,null,{"$f":"ROUND(I5/1.18,2)","v":13456.78},{"$f":"ROUND(I5-G5,2)","v":2422.2199999999998},{"$f":"D5*E5","v":15879}]
[null,null,"НДС 10%"]
[null,null,"картофель",124,20,null,{"$f":"ROUND(I7/1.1,2)","v":2254.5500000000002},{"$f":"ROUND(I7-G7,2)","v":225.45},{"$f":"D7*E7","v":2480}]
[null,null,"репа",60.5,40,null,2200,220,2420]
[null,null,"огурцы св.",150,25,null,3409.09,340.91,3750]
[null,null,"томаты св",233,78,null,16521.82,1652.18,18174]
[null,null,"укроп ",12,204,null,2225.4499999999998,222.55,2448]
[null,null,"петрушка",16,204,null,2967.27,296.73,3264]
[null,null,"лук зел",10,145,null,1318.18,131.82,1450]
[null,null,"перец ласточка",10.199999999999999,168,null,1557.82,155.78,1713.6]
[null,null,"капуста цв. Свежая",11.5,165,null,1725,172.5,1897.5]
[null,null,"кенза",1,436,null,{"$f":"ROUND(I16/1.1,2)","v":396.36},39.64,436]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(I4:I16)","v":62413.859999999993},{"$f":"SUM(H4:H16)","v":7176.66}]

{"sheet":"исходные данные","index":1,"n_rows":241,"n_cols":22,"rows_kept":241,"cut":false,"hidden":false,"merged":[[196,16,215,19],[196,21,215,24],[218,16,235,19],[218,21,235,24],[115,16,132,19],[115,21,132,24],[144,16,163,19],[144,21,163,24],[166,16,183,19],[166,21,183,24],[1,16,20,19],[1,21,20,24],[23,16,39,19],[23,21,39,24],[93,16,112,19],[93,21,112,24]]}
[]
[null,null,"НДС 18%","Заказал Кол-во","в накл Коли-во",null,"исправления","прайс с ндс","накладная без ндс",null,"Прайс","НДС","Накл","ждем исправленую",null,null,"Товар",null,null,null,null,"Получен"]
[1,"2016-05-23",null,null,null,null,null,null,null,null,{"$f":"ROUND(H3*E3,2)","v":0},{"$f":"ROUND(H3*E3-I3*E3,2)","v":0},{"$f":"I3*1.18*E3","v":0},{"$f":"IF(G3>0,G3*I3*1.18,I3*1.18*E3)","v":0}]
[2,null,"бананы",null,253,null,null,73,61.86,null,18469,2818.42,{"$f":"ROUND(I4*1.18,2)*E4","v":18466.469999999998},{"$f":"IF(G4>0,G4*ROUND(I4*1.18,2),ROUND(I4*1.18,2)*E4)","v":18466.469999999998}]
[3,null,"груша св",null,210,null,null,85,72.03,null,17850,2723.7,{"$f":"ROUND(I5*1.18,2)*E5","v":17850},17850]
[4,null,"лимоны ",null,null,null,null,null,null,null,0,0,{"$f":"I6*1.18*E6","v":0},0]
[5,null,null,null,null,null,null,null,null,null,0,0,0,0]
[6,null,null,null,null,null,null,null,null,null,0,0,0,0]
[7,null,"капуста кв. 10 кг",null,null,null,null,null,null,null,0,0,0,0]
[8,null,"огурцы сол",null,null,null,null,null,null,null,0,0,0,0]
[9,null,"огурцы сол. 1 кг",null,null,null,null,null,null,null,0,0,0,0]
[10,null,"виноград ",null,40.1,null,null,210,177.97,null,8421,1284.4000000000001,{"$f":"ROUND(I12*1.18,2)*E12","v":8421},8421]
[11,null,"сетка",null,null,null,null,null,null,null,0,0,{"$f":"I13*1.18*E13","v":0},0]
[12,null,"сетка",null,null,null,null,null,null,null,0,0,0,0]
[13,null,null,null,null,null,null,null,null,null,0,0,0,0]
[14,null,"перец зам.",null,null,null,null,null,null,null,0,0,0,0]
[15,null,"капуста брюссельская замор. ",null,null,null,null,null,null,null,0,0,0,0]
[16,null,"капуста вцет. Замор.",null,null,null,null,null,null,null,0,0,0,0]
[17,null,"фасоль стрюч. замор. 400 гр.",null,null,null,null,null,null,null,0,0,0,0]
[18,null,"черная смородина замор.",null,1,null,null,96,81.36,null,96,14.64,{"$f":"ROUND(I20*1.18,2)*E20","v":96},96]
[19,null,"клубника зам.",null,1,null,null,120,101.69,null,120,18.309999999999999,{"$f":"ROUND(I21*1.18,2)*E21","v":119.99},119.99]
[20,null,"НДС 10%"]
[21,null,"Картофель",null,13.65,null,null,50,45.45,null,{"$f":"ROUND(H23*E23,2)","v":682.5},{"$f":"ROUND(H23*E23-I23*E23,2)","v":62.11},{"$f":"ROUND(I23*1.1,2)*E23","v":682.5},{"$f":"IF(G23>0,G23*ROUND(I23*1.1,2),ROUND(I23*1.1,2)*E23)","v":682.5}]
[22,null,"капуста св.",null,null,null,null,null,null,null,0,0,0,0,null,null,"Накладная",null,null,null,null,"оригинал получен"]
[23,null,"огурцы св.",null,126,null,null,57.5,52.27,null,7245,658.98,7245,7245]
[24,null,"томаты св",null,133.1,null,131.80000000000001,50,45.45,null,6655,605.61,6655,6590.0000000000009]
[25,null,"укроп ",null,18,null,null,180,163.63999999999999,null,3240,294.48,3240,3240]
[26,null,"петрушка",null,22,null,null,180,163.63999999999999,null,3960,359.92,3960,3960]
[27,null,"кабачки",null,26,null,null,42,38.18,null,1092,99.32,1092,1092]
[28,null,"перец св",null,21.1,null,null,300,272.73,null,6330,575.4,6330,6330]
[29,null,"перец ласточка",null,30,null,null,132,120,null,3960,360,3960,3960]
[30,null,"Чеснок",null,30.4,null,null,228,207.27,null,6931.2,630.19000000000005,6931.2,6931.2]
[31,null,"баклажаны ",null,48,null,null,240,218.18,null,11520,1047.3599999999999,11520,11520]
[32,null,"тыква",null,null,null,null,null,null,null,0,0,0,0]
[33,null,"капуста цв. Свежая",null,20.8,null,null,96,87.27,null,1996.8,181.58,1996.8000000000002,1996.8000000000002]
[34,null,"корень сельдерея",null,5.6,null,null,180,163.63999999999999,null,1008,91.62,1007.9999999999999,1007.9999999999999]
[35,null,"редис",null,null,null,null,null,null,null,0,0,0,0]
[36,null,"Кап Кит",null,3,null,null,66,60,null,198,18,198,198]
[37,null,"лук порей",null,9.6999999999999993,null,null,205,186.36,null,1988.5,180.81,1988.4999999999998,1988.4999999999998]
[38,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M3:M39)","v":101760.45999999999},{"$f":"SUM(L3:L39)","v":12024.850000000002}]
[39,null,null,null,null,null,null,"накл. По прайсу",null,{"$f":"SUM(K3:K39)","v":101763}]
[40,null,"Фактическа первая",null,null,null,null,"накл. По факту",null,{"$f":"SUM(M3:M39)","v":101760.45999999999}]
[41,null,"Накладная с исправлениями",null,null,null,null,"ждем",null,{"$f":"SUM(N3:N39)","v":101695.45999999999}]
[]
[]
[]
[null,"2016-05-23","НДС 18%","Заказал Кол-во","Кол-во",null,"исправления","прайс","накладная",null,"Прайс","НДС","Накл","ждем исправленую",null,null,"Товар",null,null,null,null,"Получен"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(H48*E48,2)","v":0},{"$f":"ROUND(H48*E48-I48*E48,2)","v":0},{"$f":"I48*1.18*E48","v":0},{"$f":"IF(G48>0,G48*I48*1.18,I48*1.18*E48)","v":0}]
[null,null,"бананы",null,null,null,null,null,null,null,0,0,{"$f":"ROUND(I49*1.18,2)*E49","v":0},{"$f":"IF(G49>0,G49*ROUND(I49*1.18,2),ROUND(I49*1.18,2)*E49)","v":0}]
[null,null,"груша св",null,null,null,null,null,null,null,0,0,{"$f":"ROUND(I50*1.18,2)*E50","v":0},0]
[null,null,"лимоны ",null,null,null,null,null,null,null,0,0,{"$f":"I51*1.18*E51","v":0},0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,"капуста кв. 10 кг",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"огурцы сол",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"огурцы сол. 1 кг",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"виноград ",null,null,null,null,null,null,null,0,0,{"$f":"ROUND(I57*1.18,2)*E57","v":0},0]
[null,null,"сетка",null,null,null,null,null,null,null,0,0,{"$f":"I58*1.18*E58","v":0},0]
[null,null,"сетка",null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,"перец зам.",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"капуста брюссельская замор. ",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"капуста вцет. Замор.",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"фасоль стрюч. замор. 400 гр.",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"черная смородина замор.",null,null,null,null,null,null,null,0,0,{"$f":"ROUND(I65*1.18,2)*E65","v":0},0]
[null,null,"клубника зам.",null,null,null,null,null,null,null,0,0,{"$f":"ROUND(I66*1.18,2)*E66","v":0},0]
[null,null,"НДС 10%"]
[null,null,"Картофель",null,null,null,null,null,null,null,{"$f":"ROUND(H68*E68,2)","v":0},{"$f":"ROUND(H68*E68-I68*E68,2)","v":0},{"$f":"ROUND(I68*1.1,2)*E68","v":0},{"$f":"IF(G68>0,G68*ROUND(I68*1.1,2),ROUND(I68*1.1,2)*E68)","v":0}]
[null,null,"капуста св.",null,null,null,null,null,null,null,0,0,0,0,null,null,"Накладная",null,null,null,null,"оригинал ждем"]
[null,null,"огурцы св.",null,240,null,null,53,null,null,12720,12720,0,0]
[null,null,"томаты св",null,220,null,null,55.5,null,null,12210,12210,0,0]
[null,null,"укроп ",null,10,null,null,180,null,null,1800,1800,0,0]
[null,null,"петрушка",null,16,null,null,180,null,null,2880,2880,0,0]
[null,null,"Лук зел",null,11,null,null,145,null,null,1595,1595,0,0]
[null,null,"кабачки",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"перец св",null,16,null,null,168,null,null,2688,2688,0,0]
[null,null,"перец ласточка",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"Чеснок",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"баклажаны ",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"тыква",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"капуста цв. Свежая",null,31.45,null,null,96,null,null,3019.2,3019.2,0,0]
[null,null,"корень сельдерея",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"редис",null,2.5,null,null,48,null,null,120,120,0,0]
[null,null,"Кап Кит",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"лук порей",null,5,null,null,180,null,null,900,900,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M48:M85)","v":0},{"$f":"SUM(L48:L85)","v":37932.199999999997}]
[null,null,null,null,null,null,null,"накл. По прайсу",null,{"$f":"SUM(K48:K85)","v":37932.199999999997}]
[null,null,"Фактическа первая",null,null,null,null,"накл. По факту",null,{"$f":"SUM(M48:M85)","v":0}]
[null,null,"Накладная с исправлениями",null,null,null,null,"ждем",null,{"$f":"SUM(N48:N85)","v":0}]
[]
[]
[]
[]
[1,"1900-01-25T01:12:00","НДС 18%",null,"Кол-во",null,"исправления","прайс","накладная",null,"Прайс","НДС","Накл","ждем исправленую",null,null,"Товар",null,null,null,null,"Получен"]
[2,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(H95*E95,2)","v":0},{"$f":"ROUND(H95*E95-I95*E95,2)","v":0},{"$f":"I95*1.18*E95","v":0},{"$f":"IF(G95>0,G95*I95*1.18,I95*1.18*E95)","v":0}]
[3,null,"бананы",null,null,null,null,null,null,null,0,0,{"$f":"ROUND(I96*1.18,2)*E96","v":0},{"$f":"IF(G96>0,G96*ROUND(I96*1.18,2),ROUND(I96*1.18,2)*E96)","v":0}]
[4,null,"груша св",null,null,null,null,null,null,null,0,0,{"$f":"ROUND(I97*1.18,2)*E97","v":0},0]
[5,null,"лимоны ",null,null,null,null,null,null,null,0,0,{"$f":"I98*1.18*E98","v":0},0]
[6,null,null,null,null,null,null,null,null,null,0,0,0,0]
[7,null,null,null,null,null,null,null,null,null,0,0,0,0]
[8,null,"капуста кв. 10 кг",null,null,null,null,null,null,null,0,0,0,0]
[9,null,"огурцы сол",null,null,null,null,null,null,null,0,0,0,0]
[10,null,"огурцы сол. 1 кг",null,null,null,null,null,null,null,0,0,0,0]
[11,null,"виноград ",null,null,null,null,null,null,null,0,0,{"$f":"ROUND(I104*1.18,2)*E104","v":0},0]
[12,null,"сетка",null,null,null,null,null,null,null,0,0,{"$f":"I105*1.18*E105","v":0},0]
[13,null,"сетка",null,null,null,null,null,null,null,0,0,0,0]
[14,null,null,null,null,null,null,null,null,null,0,0,0,0]
[15,null,"перец зам.",null,null,null,null,null,null,null,0,0,0,0]
[16,null,"капуста брюссельская замор. ",null,null,null,null,null,null,null,0,0,0,0]
[17,null,"капуста вцет. Замор.",null,null,null,null,null,null,null,0,0,0,0]
[18,null,"фасоль стрюч. замор. 400 гр.",null,null,null,null,null,null,null,0,0,0,0]
[19,null,"черная смородина замор.",null,null,null,null,null,null,null,0,0,{"$f":"ROUND(I112*1.18,2)*E112","v":0},0]
[20,null,"клубника зам.",null,null,null,null,null,null,null,0,0,{"$f":"ROUND(I113*1.18,2)*E113","v":0},0]
[21,null,"НДС 10%"]
[22,null,"Картофель",null,null,null,null,null,null,{"$f":"ROUND(I115*1.1,2)","v":0},{"$f":"ROUND(H115*E115,2)","v":0},{"$f":"ROUND(H115*E115-I115*E115,2)","v":0},{"$f":"ROUND(I115*1.1,2)*E115","v":0},{"$f":"IF(G115>0,G115*ROUND(I115*1.1,2),ROUND(I115*1.1,2)*E115)","v":0}]
[23,null,"капуста св.",null,null,null,null,null,null,{"$f":"ROUND(I116*1.1,2)","v":0},0,0,{"$f":"ROUND(I116*1.1,2)*E116","v":0},0,null,null,"Накладная",null,null,null,null,"оригинал получен"]
[24,null,"огурцы св.",null,245.1,null,231,53,47.27,{"$f":"ROUND(I117*1.1,2)","v":52},12990.3,1404.42,{"$f":"J117*E117","v":12745.199999999999},12012]
[25,null,"томаты св",null,223.5,null,220.5,55.5,50,{"$f":"ROUND(I118*1.1,2)","v":55},12404.25,1229.25,12292.5,12127.5]
[26,null,"укроп ",null,10,null,null,180,163.63999999999999,180,1800,163.6,1800,1800]
[27,null,"петрушка",null,16,null,null,180,163.63999999999999,180,2880,261.76,2880,2880]
[28,null,"Лук зел",null,11,null,null,145,131.82,145,1595,144.97999999999999,1595,1595]
[29,null,"кабачки",null,null,null,null,null,null,0,0,0,0,0]
[30,null,"перец св",null,16,null,null,168,152.72999999999999,168,2688,244.32,2688,2688]
[31,null,"перец ласточка",null,null,null,null,null,null,0,0,0,0,0]
[32,null,"Чеснок",null,null,null,null,null,null,0,0,0,0,0]
[33,null,"баклажаны ",null,null,null,null,null,null,0,0,0,0,0]
[34,null,"тыква",null,null,null,null,null,null,0,0,0,0,0]
[35,null,"капуста цв. Свежая",null,32,null,32,96,87.27,96,3072,279.36,3072,3072]
[36,null,"корень сельдерея",null,null,null,null,null,null,0,0,0,0,0]
[37,null,"редис",null,2.5,null,2.484,48,43.64,48,null,null,120]
[38,null,"Кап Кит",null,null,null,null,null,null,0,{"$f":"ROUND(H131*E131,2)","v":0},{"$f":"ROUND(H131*E131-I131*E131,2)","v":0},0,{"$f":"IF(G131>0,G131*ROUND(I131*1.1,2),ROUND(I131*1.1,2)*E131)","v":0}]
[39,null,"лук порей",null,4.8,null,4.2,180,163.63999999999999,180,{"$f":"ROUND(H132*E132,2)","v":864},{"$f":"ROUND(H132*E132-I132*E132,2)","v":78.53},864,{"$f":"IF(G132>0,G132*ROUND(I132*1.1,2),ROUND(I132*1.1,2)*E132)","v":756}]
[40,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M95:M132)","v":38056.699999999997},{"$f":"SUM(L95:L132)","v":3806.2200000000003}]
[41]
[42,null,null,null,null,null,null,"накл. По прайсу",null,{"$f":"SUM(K95:K132)","v":38293.550000000003}]
[43,null,"Фактическа первая",null,null,null,null,"накл. По факту",null,{"$f":"SUM(M95:M132)","v":38056.699999999997}]
[44,null,"Накладная с исправлениями",null,null,null,null,"ждем",null,{"$f":"SUM(N95:N132)","v":36930.5}]
[]
[]
[]
[]
[]
[]
[]
[1,"2016-05-30","НДС 18%","Заказал Кол-во","в накл Коли-во",null,"исправления","прайс","накладная",null,"Прайс","НДС","Накл","ждем исправленую",null,null,"Товар",null,null,null,null,"Получен"]
[2,null,null,null,null,null,null,null,null,{"$f":"ROUND(I146*1.18,2)","v":0},{"$f":"ROUND(H146*E146,2)","v":0},{"$f":"ROUND(H146*E146-I146*E146,2)","v":0},{"$f":"I146*1.18*E146","v":0},{"$f":"IF(G146>0,G146*I146*1.18,I146*1.18*E146)","v":0}]
[3,null,"бананы",90,96.5,null,null,64.8,54.92,64.81,6253.2,953.42,{"$f":"ROUND(I147*1.18,2)*E147","v":6254.165},{"$f":"IF(G147>0,G147*ROUND(I147*1.18,2),ROUND(I147*1.18,2)*E147)","v":6254.165}]
[4,null,"груша св",300,305,null,null,79,66.95,79,24095,3675.25,{"$f":"ROUND(I148*1.18,2)*E148","v":24095},24095]
[5,null,"лимоны ",8,10.1,null,null,133,112.7,132.99,1343.3,205.03,{"$f":"I149*1.18*E149","v":1343.1585999999998},1343.1990000000001]
[6,null,null,null,null,null,null,null,null,0,0,0,0,0]
[7,null,null,null,null,null,null,null,null,0,0,0,0,0]
[8,null,"капуста кв. 10 кг",null,null,null,null,null,null,0,0,0,0,0]
[9,null,"огурцы сол",null,null,null,null,null,null,0,0,0,0,0]
[10,null,"огурцы сол. 1 кг",null,null,null,null,null,null,0,0,0,0,0]
[11,null,"виноград ",null,null,null,null,null,null,0,0,0,{"$f":"ROUND(I155*1.18,2)*E155","v":0},0]
[12,null,"сетка",null,null,null,null,null,null,0,0,0,{"$f":"I156*1.18*E156","v":0},0]
[13,null,"сетка",null,null,null,null,null,null,0,0,0,0,0]
[14,null,null,null,null,null,null,null,null,0,0,0,0,0]
[15,null,"перец зам.",null,null,null,null,null,null,0,0,0,0,0]
[16,null,"капуста брюссельская замор. ",null,null,null,null,null,null,0,0,0,0,0]
[17,null,"капуста вцет. Замор.",null,null,null,null,null,null,0,0,0,0,0]
[18,null,"фасоль стрюч. замор. 400 гр.",null,null,null,null,null,null,0,0,0,0,0]
[19,null,"черная смородина замор.",null,null,null,null,null,null,0,0,0,{"$f":"ROUND(I163*1.18,2)*E163","v":0},0]
[20,null,"клубника зам.",null,null,null,null,null,null,{"$f":"ROUND(I164*1.18,2)","v":0},0,0,{"$f":"ROUND(I164*1.18,2)*E164","v":0},0]
[21,null,"НДС 10%"]
[22,null,"Картофель",null,null,null,null,null,null,{"$f":"ROUND(I166*1.1,2)","v":0},{"$f":"ROUND(H166*E166,2)","v":0},{"$f":"ROUND(H166*E166-I166*E166,2)","v":0},{"$f":"ROUND(I166*1.1,2)*E166","v":0},{"$f":"IF(G166>0,G166*ROUND(I166*1.1,2),ROUND(I166*1.1,2)*E166)","v":0}]
[23,null,"Репа",150,167,null,null,40,36.36,40,6680,607.88,{"$f":"ROUND(I167*1.1,2)*E167","v":6680},6680,null,null,"Накладная",null,null,null,null,"оригинал ждем"]
[24,null,"огурцы св.",220,220,null,218,45,40.909999999999997,45,9900,899.8,{"$f":"J168*E168","v":9900},9810]
[25,null,"томаты св",60,61,null,null,98,88.91,97.8,5978,554.49,5965.8,5965.8]
[26,null,"укроп ",13,13,null,null,180,174.55,192.01,2340,70.849999999999994,2496.13,2496.13]
[27,null,"петрушка",13,13,null,null,192,169.09,186,2496,297.83,2418,2418]
[28,null,"Лук зел",11,11,null,null,145,131.82,145,1595,144.97999999999999,1595,1595]
[29,null,"кабачки",null,null,null,null,null,null,0,0,0,0,0]
[30,null,"перец св",35,35,null,null,276,250.91,276,9660,878.15,9660,9660]
[31,null,"перец ласточка",5,5.3,null,null,168,152.72999999999999,168,890.4,80.930000000000007,890.4,890.4]
[32,null,"Чеснок",null,null,null,null,null,null,0,0,0,0,0]
[33,null,"баклажаны ",null,null,null,null,null,null,0,0,0,0,0]
[34,null,"тыква",null,null,null,null,null,null,0,0,0,0,0]
[35,null,"капуста цв. Свежая",null,null,null,null,null,null,0,0,0,0,0]
[36,null,"корень сельдерея",null,null,null,null,null,null,0,0,0,0,0]
[37,null,"редис",null,null,null,null,null,null,0,null,null,0]
[38,null,"Кап Кит",null,null,null,null,null,null,0,{"$f":"ROUND(H182*E182,2)","v":0},{"$f":"ROUND(H182*E182-I182*E182,2)","v":0},0,{"$f":"IF(G182>0,G182*ROUND(I182*1.1,2),ROUND(I182*1.1,2)*E182)","v":0}]
[39,null,"лук порей",5,5.3,null,null,180,163.63999999999999,180,{"$f":"ROUND(H183*E183,2)","v":954},{"$f":"ROUND(H183*E183-I183*E183,2)","v":86.71},954,{"$f":"IF(G183>0,G183*ROUND(I183*1.1,2),ROUND(I183*1.1,2)*E183)","v":954}]
[40,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(M146:M183)","v":72251.653599999991},{"$f":"SUM(L146:L183)","v":8455.32}]
[41]
[42,null,null,null,null,null,null,"накл. По прайсу",null,{"$f":"SUM(K146:K183)","v":72184.899999999994}]
[43,null,"Фактическа первая",null,null,null,null,"накл. По факту",null,{"$f":"SUM(M146:M183)","v":72251.653599999991}]
[44,null,"Накладная с исправлениями",null,null,null,null,"ждем",null,{"$f":"SUM(N146:N183)","v":72161.693999999989}]
[]
[]
[]
[]
[]
[]
[]
[]
[1,"2016-06-01","НДС 18%","Заказал Кол-во","в накл Коли-во","пришло на склад по факту","исправления","прайс","накладная",null,"Прайс","НДС","Накл","ждем исправленую",null,null,"Товар",null,null,null,null,"Получен"]
[2,null,null,null,null,null,null,null,null,{"$f":"ROUND(I198*1.18,2)","v":0},{"$f":"ROUND(H198*E198,2)","v":0},{"$f":"ROUND(H198*E198-I198*E198,2)","v":0},{"$f":"I198*1.18*E198","v":0},{"$f":"IF(G198>0,G198*I198*1.18,I198*1.18*E198)","v":0}]
[3,null,"бананы",130,131.19999999999999,{"$f":"IF(G199=0,E199,G199)","v":131.19999999999999},null,64.8,54.92,{"$f":"ROUND(I199*1.18,1)","v":64.8},8501.76,1296.26,{"$f":"ROUND(I199*1.18,1)*E199","v":8501.7599999999984},{"$f":"IF(G199>0,G199*ROUND(I199*1.18,2),ROUND(I199*1.18,2)*E199)","v":8503.0720000000001}]
[4,null,"груша св",200,201,{"$f":"IF(G200=0,E200,G200)","v":201},null,79,66.95,{"$f":"ROUND(I200*1.18,1)","v":79},15879,2422.0500000000002,{"$f":"ROUND(I200*1.18,1)*E200","v":15879},15879]
[5,null,"лимоны ",null,null,0,null,null,null,0,0,0,0,0]
[6,null,null,null,null,0,null,null,null,0,0,0,0,0]
[7,null,null,null,null,0,null,null,null,0,0,0,0,0]
[8,null,"капуста кв. 10 кг",null,null,0,null,null,null,0,0,0,0,0]
[9,null,"огурцы сол",null,null,0,null,null,null,0,0,0,0,0]
[10,null,"огурцы сол. 1 кг",null,null,0,null,null,null,0,0,0,0,0]
[11,null,"виноград ",null,null,0,null,null,null,0,0,0,0,0]
[12,null,"сетка",null,null,0,null,null,null,0,0,0,0,0]
[13,null,"сетка",null,null,0,null,null,null,0,0,0,0,0]
[14,null,null,null,null,0,null,null,null,0,0,0,0,0]
[15,null,"перец зам.",null,null,0,null,null,null,0,0,0,0,0]
[16,null,"капуста брюссельская замор. ",null,null,0,null,null,null,0,0,0,0,0]
[17,null,"капуста вцет. Замор.",null,null,0,null,null,null,0,0,0,0,0]
[18,null,"фасоль стрюч. замор. 400 гр.",null,null,0,null,null,null,0,0,0,0,0]
[19,null,"черная смородина замор.",null,null,0,null,null,null,0,0,0,0,0]
[20,null,"клубника зам.",null,null,0,null,null,null,0,0,0,0,0]
[21,null,"НДС 10%",null,null,0]
[22,null,"Картофель",100,124,124,null,20,18.18,{"$f":"ROUND(I218*1.1,1)","v":20},{"$f":"ROUND(H218*E218,2)","v":2480},{"$f":"ROUND(H218*E218-I218*E218,2)","v":225.68},{"$f":"ROUND(I218*1.1,1)*E218","v":2480},{"$f":"IF(G218>0,G218*ROUND(I218*1.1,2),ROUND(I218*1.1,2)*E218)","v":2480}]
[23,null,"Репа",50,60.5,60.5,null,40,36.36,{"$f":"ROUND(I219*1.1,1)","v":40},{"$f":"ROUND(H219*E219,2)","v":2420},220.22,{"$f":"ROUND(I219*1.1,1)*E219","v":2420},2420,null,null,"Накладная",null,null,null,null,"оригинал ждем"]
[24,null,"огурцы св.",150,150,150,null,25,22.73,25,3750,340.5,3750,3750]
[25,null,"томаты св",220,233,225.1,225.1,78,70.91,78,18174,1651.97,18174,17557.8]
[26,null,"укроп ",12,12,12,null,204,185.45,204,2448,222.6,2448,2448]
[27,null,"петрушка",16,16,16,null,204,185.45,204,3264,296.8,3264,3264]
[28,null,"Лук зел",10,10,9.8000000000000007,9.8000000000000007,145,131.82,145,1450,131.80000000000001,1450,1421]
[29,null,"кабачки",null,null,0,null,null,null,0,0,0,0,0]
[30,null,"перец св",null,null,0,null,null,null,0,0,0,0,0]
[31,null,"перец ласточка",10,10.199999999999999,10.199999999999999,null,168,152.72999999999999,168,1713.6,155.75,1713.6,1713.6]
[32,null,"Чеснок",null,null,0,null,null,null,0,0,0,0,0]
[33,null,"баклажаны ",null,null,0,null,null,null,0,0,0,0,0]
[34,null,"тыква",null,null,0,null,null,null,0,0,0,0,0]
[35,null,"капуста цв. Свежая",10,11.5,11.5,null,165,150,165,1897.5,172.5,1897.5,1897.5]
[36,null,"корень сельдерея",null,null,0,null,null,null,0,0,0,0,0]
[37,null,"редис",null,null,0,null,null,null,0,null,null,0]
[38,null,"Кап Кит",null,null,0,null,null,null,0,{"$f":"ROUND(H234*E234,2)","v":0},{"$f":"ROUND(H234*E234-I234*E234,2)","v":0},0,{"$f":"IF(G234>0,G234*ROUND(I234*1.1,2),ROUND(I234*1.1,2)*E234)","v":0}]
[39,null,"лук порей",null,null,0,null,null,null,0,{"$f":"ROUND(H235*E235,2)","v":0},{"$f":"ROUND(H235*E235-I235*E235,2)","v":0},0]
[40,null,"кенза",1,1,1,null,436,396.36,436,{"$f":"ROUND(H236*E236,2)","v":436},{"$f":"ROUND(H236*E236-I236*E236,2)","v":39.64},436]
[41,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M198:M236)","v":62413.859999999993},{"$f":"SUM(L198:L236)","v":7175.7700000000013}]
[42]
[43,null,null,null,null,null,null,"накл. По прайсу",null,{"$f":"SUM(K198:K236)","v":62413.86}]
[44,null,"Фактическа первая",null,null,null,null,"накл. По факту",null,{"$f":"SUM(M198:M236)","v":62413.859999999993}]
[45,null,"Накладная с исправлениями",null,null,null,null,"ждем",null,{"$f":"SUM(N198:N236)","v":61333.972000000002}]

{"sheet":"Лист1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}