{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Итоги Юнифрут","ФрешФуд","Лист1"],"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":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,0,10,0]]}
[]
[]
["2016-06-01",null,"апельсин",354,48,null,{"$f":"ROUND(I3/1.18,2)","v":14400},{"$f":"ROUND(I3-G3,2)","v":2592},{"$f":"D3*E3","v":16992}]
[null,null,"груша св",480,68,null,{"$f":"ROUND(I4/1.18,2)","v":27661.02},{"$f":"ROUND(I4-G4,2)","v":4978.9799999999996},{"$f":"D4*E4","v":32640}]
[null,null,"персики",10,185,null,1567.8,282.2,1850]
[null,null,"виноград ",8.1999999999999993,158,null,1097.97,197.63,1295.5999999999999]
[null,null,"НДС 10%"]
[null,null,"лук репч",694,25,null,{"$f":"ROUND(I8/1.1,2)","v":15772.73},{"$f":"ROUND(I8-G8,2)","v":1577.27},{"$f":"D8*E8","v":17350}]
[null,null,"огурцы св.",167,20,null,3036.36,303.64,3340]
[null,null,"кабачки",49.3,45,null,2016.82,201.68,2218.5]
[null,null,"баклажаны ",15,250,null,3409.09,340.91,3750]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(I3:I11)","v":79436.100000000006},{"$f":"SUM(H3:H11)","v":10474.31}]

{"sheet":"ФрешФуд","index":1,"n_rows":291,"n_cols":22,"rows_kept":291,"cut":false,"hidden":false,"merged":[[246,16,265,19],[246,21,265,24],[268,16,285,19],[268,21,285,24],[196,16,215,19],[196,21,215,24],[218,16,235,19],[218,21,235,24],[144,16,163,19],[144,21,163,24],[166,16,183,19],[166,21,183,24],[115,16,132,19],[115,21,132,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,"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}]
[null,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}]
[null,null,"груша св",null,210,null,null,85,72.03,null,17850,2723.7,{"$f":"ROUND(I5*1.18,2)*E5","v":17850},17850]
[null,null,"лимоны ",null,null,null,null,null,null,null,0,0,{"$f":"I6*1.18*E6","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,40.1,null,null,210,177.97,null,8421,1284.4000000000001,{"$f":"ROUND(I12*1.18,2)*E12","v":8421},8421]
[null,null,"сетка",null,null,null,null,null,null,null,0,0,{"$f":"I13*1.18*E13","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,1,null,null,96,81.36,null,96,14.64,{"$f":"ROUND(I20*1.18,2)*E20","v":96},96]
[null,null,"клубника зам.",null,1,null,null,120,101.69,null,120,18.309999999999999,{"$f":"ROUND(I21*1.18,2)*E21","v":119.99},119.99]
[null,null,"НДС 10%"]
[null,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}]
[null,null,"капуста св.",null,null,null,null,null,null,null,0,0,0,0,null,null,"Накладная",null,null,null,null,"оригинал получен"]
[null,null,"огурцы св.",null,126,null,null,57.5,52.27,null,7245,658.98,7245,7245]
[null,null,"томаты св",null,133.1,null,131.80000000000001,50,45.45,null,6655,605.61,6655,6590.0000000000009]
[null,null,"укроп ",null,18,null,null,180,163.63999999999999,null,3240,294.48,3240,3240]
[null,null,"петрушка",null,22,null,null,180,163.63999999999999,null,3960,359.92,3960,3960]
[null,null,"кабачки",null,26,null,null,42,38.18,null,1092,99.32,1092,1092]
[null,null,"перец св",null,21.1,null,null,300,272.73,null,6330,575.4,6330,6330]
[null,null,"перец ласточка",null,30,null,null,132,120,null,3960,360,3960,3960]
[null,null,"Чеснок",null,30.4,null,null,228,207.27,null,6931.2,630.19000000000005,6931.2,6931.2]
[null,null,"баклажаны ",null,48,null,null,240,218.18,null,11520,1047.3599999999999,11520,11520]
[null,null,"тыква",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"капуста цв. Свежая",null,20.8,null,null,96,87.27,null,1996.8,181.58,1996.8000000000002,1996.8000000000002]
[null,null,"корень сельдерея",null,5.6,null,null,180,163.63999999999999,null,1008,91.62,1007.9999999999999,1007.9999999999999]
[null,null,"редис",null,null,null,null,null,null,null,0,0,0,0]
[null,null,"Кап Кит",null,3,null,null,66,60,null,198,18,198,198]
[null,null,"лук порей",null,9.6999999999999993,null,null,205,186.36,null,1988.5,180.81,1988.4999999999998,1988.4999999999998]
[null,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}]
[null,null,null,null,null,null,null,"накл. По прайсу",null,{"$f":"SUM(K3:K39)","v":101763}]
[null,null,"Фактическа первая",null,null,null,null,"накл. По факту",null,{"$f":"SUM(M3:M39)","v":101760.45999999999}]
[null,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,"Получен"]
[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,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}]
[]
[]
[]
[]
[]
[]
[]
[null,"2016-05-30","НДС 18%","Заказал Кол-во","в накл Коли-во",null,"исправления","прайс","накладная",null,"Прайс","НДС","Накл","ждем исправленую",null,null,"Товар",null,null,null,null,"Получен"]
[null,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}]
[null,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}]
[null,null,"груша св",300,305,null,null,79,66.95,79,24095,3675.25,{"$f":"ROUND(I148*1.18,2)*E148","v":24095},24095]
[null,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]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,"капуста кв. 10 кг",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"огурцы сол",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"огурцы сол. 1 кг",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"виноград ",null,null,null,null,null,null,0,0,0,{"$f":"ROUND(I155*1.18,2)*E155","v":0},0]
[null,null,"сетка",null,null,null,null,null,null,0,0,0,{"$f":"I156*1.18*E156","v":0},0]
[null,null,"сетка",null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,"перец зам.",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"капуста брюссельская замор. ",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"капуста вцет. Замор.",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"фасоль стрюч. замор. 400 гр.",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"черная смородина замор.",null,null,null,null,null,null,0,0,0,{"$f":"ROUND(I163*1.18,2)*E163","v":0},0]
[null,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]
[null,null,"НДС 10%"]
[null,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}]
[null,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,"оригинал ждем"]
[null,null,"огурцы св.",220,220,null,218,45,40.909999999999997,45,9900,899.8,{"$f":"J168*E168","v":9900},9810]
[null,null,"томаты св",60,61,null,null,98,88.91,97.8,5978,554.49,5965.8,5965.8]
[null,null,"укроп ",13,13,null,null,180,174.55,192.01,2340,70.849999999999994,2496.13,2496.13]
[null,null,"петрушка",13,13,null,null,192,169.09,186,2496,297.83,2418,2418]
[null,null,"Лук зел",11,11,null,null,145,131.82,145,1595,144.97999999999999,1595,1595]
[null,null,"кабачки",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"перец св",35,35,null,null,276,250.91,276,9660,878.15,9660,9660]
[null,null,"перец ласточка",5,5.3,null,null,168,152.72999999999999,168,890.4,80.930000000000007,890.4,890.4]
[null,null,"Чеснок",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"баклажаны ",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"тыква",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"капуста цв. Свежая",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"корень сельдерея",null,null,null,null,null,null,0,0,0,0,0]
[null,null,"редис",null,null,null,null,null,null,0,null,null,0]
[null,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}]
[null,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}]
[null,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}]
[]
[null,null,null,null,null,null,null,"накл. По прайсу",null,{"$f":"SUM(K146:K183)","v":72184.899999999994}]
[null,null,"Фактическа первая",null,null,null,null,"накл. По факту",null,{"$f":"SUM(M146:M183)","v":72251.653599999991}]
[null,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,null,"Получен"]
[2,null,null,null,null,{"$f":"IF(E198>0,IF(G198>0,G198,E198),\"\")","v":""},null,null,null,{"$f":"IF(I198=0,\"\",ROUND(I198*1.18,2))","v":""},{"$f":"IF(H198=0,\"\",ROUND(H198*F198,2))","v":""},{"$f":"IF(I198=0,\"\",ROUND(H198*F198-I198*F198,2))","v":""},{"$f":"IF(I198=0,\"\",ROUND(I198*1.18*E198,2))","v":""},{"$f":"IF(I198=0,\"\",IF(G198>0,ROUND(G198*I198*1.18,2),(ROUND(I198*1.18*E198,2))))","v":""}]
[3,null,"бананы",130,131.19999999999999,{"$f":"IF(E199>0,IF(G199>0,G199,E199),\"\")","v":131.19999999999999},null,64.8,54.92,{"$f":"IF(I199=0,\"\",ROUND(I199*1.18,2))","v":64.81},{"$f":"IF(H199=0,\"\",ROUND(H199*F199,2))","v":8501.76},{"$f":"IF(I199=0,\"\",ROUND(H199*F199-I199*F199,2))","v":1296.26},8502.49,{"$f":"IF(I199=0,\"\",IF(G199>0,ROUND(G199*I199*1.18,2),(ROUND(I199*1.18*E199,2))))","v":8502.49}]
[4,null,"груша св",200,201,{"$f":"IF(E200>0,IF(G200>0,G200,E200),\"\")","v":201},null,79,66.95,79,15879,2422.0500000000002,15879.2,15879.2]
[5,null,"лимоны ",null,null,"",null,null,null,"","","","",""]
[6,null,"й",null,null,"",null,null,null,"","","","",""]
[7,null,"й",null,null,"",null,null,null,"","","","",""]
[8,null,"капуста кв. 10 кг",null,null,"",null,null,null,"","","","",""]
[9,null,"огурцы сол",null,null,"",null,null,null,"","","","",""]
[10,null,"огурцы сол. 1 кг",null,null,"",null,null,null,"","","","",""]
[11,null,"виноград ",null,null,"",null,null,null,"","","","",""]
[12,null,"сетка",null,null,"",null,null,null,"","","","",""]
[13,null,"сетка",null,null,"",null,null,null,"","","","",""]
[14,null,"й",null,null,"",null,null,null,"","","","",""]
[15,null,"перец зам.",null,null,"",null,null,null,"","","","",""]
[16,null,"капуста брюссельская замор. ",null,null,"",null,null,null,"","","","",""]
[17,null,"капуста вцет. Замор.",null,null,"",null,null,null,"","","","",""]
[18,null,"фасоль стрюч. замор. 400 гр.",null,null,"",null,null,null,"","","","",""]
[19,null,"черная смородина замор.",null,null,"",null,null,null,"","","","",""]
[20,null,"клубника зам.",null,null,"",null,null,null,"","","",{"$f":"IF(I216=0,\"\",ROUND(I216*1.18*E216,2))","v":""},""]
[21,null,"НДС 10%",null,null,""]
[22,null,"Картофель",100,124,124,null,20,18.18,{"$f":"IF(I218=0,\"\",ROUND(I218*1.1,2))","v":20},2480,225.68,{"$f":"IF(I218=0,\"\",ROUND(I218*1.1*E218,2))","v":2479.75},{"$f":"IF(I218=0,\"\",IF(G218>0,ROUND(G218*I218*1.1,2),(ROUND(I218*1.1*E218,2))))","v":2479.75}]
[23,null,"Репа",50,60.5,60.5,null,40,36.36,{"$f":"IF(I219=0,\"\",ROUND(I219*1.1,2))","v":40},2420,220.22,{"$f":"IF(I219=0,\"\",ROUND(I219*1.1*E219,2))","v":2419.7600000000002},{"$f":"IF(I219=0,\"\",IF(G219>0,ROUND(G219*I219*1.1,2),(ROUND(I219*1.1*E219,2))))","v":2419.7600000000002},null,null,"Накладная",null,null,null,null,"оригинал ждем"]
[24,null,"огурцы св.",150,150,150,null,25,22.73,25,3750,340.5,3750.45,3750.45]
[25,null,"томаты св",220,233,225.1,225.1,78,70.91,78,17557.8,1595.96,18174.23,17558.03]
[26,null,"укроп ",12,12,12,null,204,185.45,204,2448,222.6,2447.94,2447.94]
[27,null,"петрушка",16,16,16,null,204,185.45,204,3264,296.8,3263.92,3263.92]
[28,null,"Лук зел",10,10,9.8000000000000007,9.8000000000000007,145,131.82,145,1421,129.16,1450.02,1421.02]
[29,null,"кабачки",null,null,"",null,null,null,"","","","",""]
[30,null,"перец св",null,null,"",null,null,null,"","","","",""]
[31,null,"перец ласточка",10,10.199999999999999,10.199999999999999,null,168,152.72999999999999,168,1713.6,155.75,1713.63,1713.63]
[32,null,"Чеснок",null,null,"",null,null,null,"","","","",""]
[33,null,"баклажаны ",null,null,"",null,null,null,"","","","",""]
[34,null,"тыква",null,null,"",null,null,null,"","","","",""]
[35,null,"капуста цв. Свежая",10,11.5,11.5,null,165,150,165,1897.5,172.5,1897.5,1897.5]
[36,null,"корень сельдерея",null,null,"",null,null,null,"","","","",""]
[37,null,"редис",null,null,"",null,null,null,"","","","",""]
[38,null,"Кап Кит",null,null,"",null,null,null,"","","","",""]
[39,null,"лук порей",null,null,"",null,null,null,"","","","",""]
[40,null,"кенза",1,1,1,null,436,396.36,436,436,39.64,436,436]
[41,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M198:M236)","v":62414.89},{"$f":"SUM(L198:L236)","v":7117.1200000000008}]
[42]
[43,null,null,null,null,null,null,"накл. По прайсу",null,{"$f":"SUM(K198:K236)","v":61768.659999999996}]
[44,null,"Фактическа первая",null,null,null,null,"накл. По факту",null,{"$f":"SUM(M198:M236)","v":62414.89}]
[45,null,"Накладная с исправлениями",null,null,null,null,"ждем",null,{"$f":"SUM(N198:N236)","v":61769.689999999995}]
[]
[]
[]
[]
[]
[null,"2016-06-01","НДС 18%","Заказал Кол-во","в накл Коли-во",null,"исправления","прайс","накладная",null,"Прайс","НДС","Накл","ждем исправленую",null,null,"Товар",null,null,null,null,"Получен"]
[null,null,null,null,null,{"$f":"IF(E248>0,IF(G248>0,G248,E248),\"\")","v":""},null,null,null,{"$f":"ROUND(I248*1.18,2)","v":0},{"$f":"ROUND(H248*E248,2)","v":0},{"$f":"ROUND(H248*E248-I248*E248,2)","v":0},{"$f":"I248*1.18*E248","v":0},{"$f":"IF(G248>0,G248*I248*1.18,I248*1.18*E248)","v":0}]
[null,null,"бананы",100,null,"",null,55.9,null,{"$f":"ROUND(I249*1.18,1)","v":0},0,0,{"$f":"ROUND(I249*1.18,1)*E249","v":0},{"$f":"IF(G249>0,G249*ROUND(I249*1.18,2),ROUND(I249*1.18,2)*E249)","v":0}]
[null,null,"груша св",null,null,"",null,null,null,{"$f":"ROUND(I250*1.18,1)","v":0},0,0,{"$f":"ROUND(I250*1.18,1)*E250","v":0},0]
[null,null,"лимоны ",null,null,"",null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,null,0,0,0,0,0]
[null,null,"капуста кв. 10 кг",null,null,"",null,null,null,0,0,0,0,0]
[null,null,"огурцы сол",null,null,"",null,null,null,0,0,0,0,0]
[null,null,"огурцы сол. 1 кг",null,null,"",null,null,null,0,0,0,0,0]
[null,null,"виноград ",null,null,"",null,null,null,0,0,0,0,0]
[null,null,"сетка",null,null,"",null,null,null,0,0,0,0,0]
[null,null,"сетка",null,null,"",null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,null,0,0,0,0,0]
[null,null,"перец зам.",null,null,"",null,null,null,0,0,0,0,0]
[null,null,"капуста брюссельская замор. ",null,null,"",null,null,null,0,0,0,0,0]
[null,null,"капуста вцет. Замор.",null,null,"",null,null,null,0,0,0,0,0]
[null,null,"фасоль стрюч. замор. 400 гр.",null,null,"",null,null,null,0,0,0,0,0]
[null,null,"черная смородина замор.",null,null,"",null,null,null,0,0,0,0,0]
[null,null,"клубника зам.",null,null,"",null,null,null,0,0,0,0,0]
[null,null,"НДС 10%",null,null,""]
[null,null,"Баклажаны ",41,null,"",null,258,null,{"$f":"ROUND(I268*1.1,1)","v":0},{"$f":"ROUND(H268*E268,2)","v":0},{"$f":"ROUND(H268*E268-I268*E268,2)","v":0},{"$f":"ROUND(I268*1.1,1)*E268","v":0},{"$f":"IF(G268>0,G268*ROUND(I268*1.1,2),ROUND(I268*1.1,2)*E268)","v":0}]
[null,null,"Кабачки ",170,null,"",null,28,null,{"$f":"ROUND(I269*1.1,1)","v":0},{"$f":"ROUND(H269*E269,2)","v":0},0,{"$f":"ROUND(I269*1.1,1)*E269","v":0},0,null,null,"Накладная",null,null,null,null,"оригинал ждем"]
[null,null,"Капуста цветная",50,null,"",null,165,null,0,0,0,0,0]
[null,null,"Картофель  Ред Скарлет",150,null,"",null,20,null,0,0,0,0,0]
[null,null,"Картофель белый ",500,null,"",null,16,null,0,0,0,0,0]
[null,null,"лук зел",16,null,"",null,125,null,0,0,0,0,0]
[null,null,"Лук порей ",5,null,"",null,180,null,0,0,0,0,0]
[null,null,"Огурцы св. кор..",3,null,"",null,45,null,0,0,0,0,0]
[null,null,"Перец красный Китай ",25,null,"",null,162,null,0,0,0,0,0]
[null,null,"Петрушка",21,null,"",null,204,null,0,0,0,0,0]
[null,null,"РедисРоссия",null,null,"",null,42,null,0,0,0,0,0]
[null,null,"Репа ",35,null,"",null,40,null,0,0,0,0,0]
[null,null,"Томаты парник ",340,null,"",null,123,null,0,0,0,0,0]
[null,null,"Укроп",18,null,"",null,204,null,0,0,0,0,0]
[null,null,"Чеснок н/у",5,null,"",null,240,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,null,0,null,null,0]
[null,null,null,null,null,"",null,null,null,0,{"$f":"ROUND(H284*E284,2)","v":0},{"$f":"ROUND(H284*E284-I284*E284,2)","v":0},0,{"$f":"IF(G284>0,G284*ROUND(I284*1.1,2),ROUND(I284*1.1,2)*E284)","v":0}]
[null,null,null,null,null,"",null,null,null,0,{"$f":"ROUND(H285*E285,2)","v":0},{"$f":"ROUND(H285*E285-I285*E285,2)","v":0},0]
[null,null,null,null,null,"",null,null,null,0,{"$f":"ROUND(H286*E286,2)","v":0},{"$f":"ROUND(H286*E286-I286*E286,2)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M248:M286)","v":0},{"$f":"SUM(L248:L286)","v":0}]
[]
[null,null,null,null,null,null,null,"накл. По прайсу",null,{"$f":"SUM(K248:K286)","v":0}]
[null,null,"Фактическа первая",null,null,null,null,"накл. По факту",null,{"$f":"SUM(M248:M286)","v":0}]
[null,null,"Накладная с исправлениями",null,null,null,null,"ждем",null,{"$f":"SUM(N248:N286)","v":0}]

{"sheet":"Лист1","index":2,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[42522,null,null,null,null,null,0,{"$f":"ROUND(I2-G2,2)","v":0},{"$f":"D2*E2","v":0}]
[null,null,"бананы",131.19999999999999,64.8,null,7204.88,1296.8800000000001,8501.7599999999984]
[null,null,"груша св",201,79,null,13456.78,2422.2199999999998,15879]
[null,null,"лимоны ",null,null,null,0,0,0]
[null,null,"й",null,null,null,0,0,0]
[null,null,"й",null,null,null,0,0,0]
[null,null,"капуста кв. 10 кг",null,null,null,0,0,0]
[null,null,"огурцы сол",null,null,null,0,0,0]
[null,null,"огурцы сол. 1 кг",null,null,null,0,0,0]
[null,null,"виноград ",null,null,null,0,0,0]
[null,null,"сетка",null,null,null,0,0,0]
[null,null,"сетка",null,null,null,0,0,0]
[null,null,"й",null,null,null,0,0,0]
[null,null,"перец зам.",null,null,null,0,0,0]
[null,null,"капуста брюссельская замор. ",null,null,null,0,0,0]
[null,null,"капуста вцет. Замор.",null,null,null,0,0,0]
[null,null,"фасоль стрюч. замор. 400 гр.",null,null,null,0,0,0]
[null,null,"черная смородина замор.",null,null,null,0,0,0]
[null,null,"клубника зам.",null,null,null,0,0,0]
[null,null,"НДС 10%",null,null,null,0,0,0]
[null,null,"Картофель",124,20,null,2254.5500000000002,225.45,2480]
[null,null,"Репа",60.5,40,null,2200,220,2420]
[null,null,"огурцы св.",150,25,null,3409.09,340.91,3750]
[null,null,"томаты св",225.1,78,null,15961.64,1596.16,17557.8]
[null,null,"укроп ",12,204,null,2225.4499999999998,222.55,2448]
[null,null,"петрушка",16,204,null,2967.27,296.73,3264]
[null,null,"Лук зел",9.8000000000000007,145,null,1291.82,129.18,1421]
[null,null,"кабачки",null,null,null,0,0,0]
[null,null,"перец св",null,null,null,0,0,0]
[null,null,"перец ласточка",10.199999999999999,168,null,1557.82,155.78,1713.6]
[null,null,"Чеснок",null,null,null,0,0,0]
[null,null,"баклажаны ",null,null,null,0,0,0]
[null,null,"тыква",null,null,null,0,0,0]
[null,null,"капуста цв. Свежая",11.5,165,null,1725,172.5,1897.5]
[null,null,"корень сельдерея",null,null,null,0,0,0]
[null,null,"редис",null,null,null,0,0,0]
[null,null,"Кап Кит",null,null,null,0,0,0]
[null,null,"лук порей",null,null,null,0,0,0]
[null,null,"кенза",1,436,null,396.36,39.64,436]
[null,null,null,null,null,null,null,null,null,61768.659999999996,7118]