{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["дневник","отчет","лист"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":2},"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":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
["№ \nп/п",null,"дата","товар","город","приход","менеджер","расход","Месяц","Остаток"]
[null,null,null,"яблоки",null,45,null,null,{"$f":"AND(J3>0)","v":true},{"$f":"SUMPRODUCT((дневник!$D$9:$D$25=D3)*(дневник!$C$9:$C$25<отчет!$D$1)*дневник!$F$9:$F$25)+F3-SUMPRODUCT((дневник!$D$9:$D$25=D3)*(дневник!$C$9:$C$25<отчет!$D$1)*($H$9:$H$25))","v":45}]
[null,null,null,"сливы",null,48,null,null,{"$f":"AND(J4>0)","v":true},{"$f":"SUMPRODUCT((дневник!$D$9:$D$25=D4)*(дневник!$C$9:$C$25<отчет!$D$1)*дневник!$F$9:$F$25)+F4-SUMPRODUCT((дневник!$D$9:$D$25=D4)*(дневник!$C$9:$C$25<отчет!$D$1)*($H$9:$H$25))","v":48}]
[null,null,null,"апельсины",null,32,null,null,true,{"$f":"SUMPRODUCT((дневник!$D$9:$D$25=D5)*(дневник!$C$9:$C$25<отчет!$D$1)*дневник!$F$9:$F$25)+F5-SUMPRODUCT((дневник!$D$9:$D$25=D5)*(дневник!$C$9:$C$25<отчет!$D$1)*($H$9:$H$25))","v":32}]
[null,null,null,"бананы",null,10,null,null,true,{"$f":"SUMPRODUCT((дневник!$D$9:$D$25=D6)*(дневник!$C$9:$C$25<отчет!$D$1)*дневник!$F$9:$F$25)+F6-SUMPRODUCT((дневник!$D$9:$D$25=D6)*(дневник!$C$9:$C$25<отчет!$D$1)*($H$9:$H$25))","v":10}]
[null,null,null,"киви",null,45,null,null,true,{"$f":"SUMPRODUCT((дневник!$D$9:$D$25=D7)*(дневник!$C$9:$C$25<отчет!$D$1)*дневник!$F$9:$F$25)+F7-SUMPRODUCT((дневник!$D$9:$D$25=D7)*(дневник!$C$9:$C$25<отчет!$D$1)*($H$9:$H$25))","v":45}]
[null,null,null,"грушы",null,null,null,null,false,{"$f":"SUMPRODUCT((дневник!$D$9:$D$25=D8)*(дневник!$C$9:$C$25<отчет!$D$1)*дневник!$F$9:$F$25)+F8-SUMPRODUCT((дневник!$D$9:$D$25=D8)*(дневник!$C$9:$C$25<отчет!$D$1)*($H$9:$H$25))","v":0}]
[1,{"$f":"TEXT(C9,\"ММММ\")","v":"Январь"},"2014-01-09","яблоки","Самара",50,"Сидоров",12,{"$f":"TEXT(C9,\"ММММ\")=отчет!$C$2","v":true}]
[2,{"$f":"TEXT(C10,\"ММММ\")","v":"Январь"},"2014-01-23","апельсины","Питер",78,"Карен",58,{"$f":"TEXT(C10,\"ММММ\")=отчет!$C$2","v":true}]
[3,"Февраль","2014-02-12","грушы","Киев",874,"Петров",54,{"$f":"TEXT(C11,\"ММММ\")=отчет!$C$2","v":false}]
[4,"Февраль","2014-02-21","бананы","Рязань",102,"Иванов",78,{"$f":"TEXT(C12,\"ММММ\")=отчет!$C$2","v":false},null,null,"Месяц","ИСТИНА"]
[5,"Март","2014-03-19","киви","Москва",54,"Павленко",12,{"$f":"TEXT(C13,\"ММММ\")=отчет!$C$2","v":false}]
[6,"Февраль","2014-02-14","яблоки","Питер",60,"Самсонов",58,{"$f":"TEXT(C14,\"ММММ\")=отчет!$C$2","v":false},null,null,null,"Названия столбцов"]
[7,"Апрель","2014-04-15","апельсины","Киев",12,"Карен",58,{"$f":"TEXT(C15,\"ММММ\")=отчет!$C$2","v":false},null,null,"Названия строк","Карен","Павленко","Самсонов","Сидоров"]
[8,"Апрель","2014-04-24","апельсины","Рязань",58,"Иванов",54,{"$f":"TEXT(C16,\"ММММ\")=отчет!$C$2","v":false},null,null,"апельсины"]
[9,"Январь","2014-01-01","бананы","Москва",95,"Павленко",78,{"$f":"TEXT(C17,\"ММММ\")=отчет!$C$2","v":true},null,null,"бананы"]
[10,"Январь","2014-01-23","киви","Ялта",78,"Самсонов",14,{"$f":"TEXT(C18,\"ММММ\")=отчет!$C$2","v":true},null,null,"киви"]
[11,"Февраль","2014-02-12","бананы","Киев",12,"Карен",8,{"$f":"TEXT(C19,\"ММММ\")=отчет!$C$2","v":false},null,null,"яблоки"]
[12,"Февраль","2014-02-21","киви","Москва",58,"Павленко",9,{"$f":"TEXT(C20,\"ММММ\")=отчет!$C$2","v":false}]
[13,"Март","2014-03-19","сливы","Питер",58,"Самсонов",56,{"$f":"TEXT(C21,\"ММММ\")=отчет!$C$2","v":false}]
[14,"Январь","2014-01-30","апельсины","Киев",124,"Карен",75,{"$f":"TEXT(C22,\"ММММ\")=отчет!$C$2","v":true}]
[15,"Апрель","2014-04-15","киви","Рязань",78,"Иванов",12,{"$f":"TEXT(C23,\"ММММ\")=отчет!$C$2","v":false}]
[16,"Апрель","2014-04-24","бананы","Москва",123,"Павленко",58,{"$f":"TEXT(C24,\"ММММ\")=отчет!$C$2","v":false}]
[17,"Апрель","2014-04-25","киви","Ялта",58,"Самсонов",54,{"$f":"TEXT(C25,\"ММММ\")=отчет!$C$2","v":false}]
[18,"Январь"]
[19,"Январь"]
["…","Январь"]
["….","Январь"]
[]
[]
[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,"яблоки"]

{"sheet":"отчет","index":1,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,16,4,16],[3,17,4,17],[14,0,19,0],[22,0,28,0],[32,0,38,0],[3,3,3,8],[3,2,4,2],[3,1,4,1],[3,0,4,0],[3,9,4,9],[3,10,3,15]]}
[null,null,null,{"$f":"VLOOKUP(C2,лист!D1:E12,2,0)","v":"2014-01-01"}]
[null,"месяц","январь"]
[]
["№ \nп/п","товар","остаток на начало месяца","приход товара из разных городов",null,null,null,null,null,"Всего","продано менеджером",null,null,null,null,null,"Всего","остаток на конец месяца"]
[null,null,null,{"$f":"IF(дневник!M35=0,\"\",дневник!M35)","v":"Киев"},{"$f":"IF(дневник!N35=0,\"\",дневник!N35)","v":"Москва"},{"$f":"IF(дневник!O35=0,\"\",дневник!O35)","v":"Питер"},{"$f":"IF(дневник!P35=0,\"\",дневник!P35)","v":"Самара"},{"$f":"IF(дневник!Q35=0,\"\",дневник!Q35)","v":"Ялта"},{"$f":"IF(дневник!R35=0,\"\",дневник!R35)","v":""},null,{"$f":"IF(дневник!M15=0,\"\",дневник!M15)","v":"Карен"},{"$f":"IF(дневник!N15=0,\"\",дневник!N15)","v":"Павленко"},{"$f":"IF(дневник!O15=0,\"\",дневник!O15)","v":"Самсонов"},{"$f":"IF(дневник!P15=0,\"\",дневник!P15)","v":"Сидоров"},{"$f":"IF(дневник!Q15=0,\"\",дневник!Q15)","v":""},{"$f":"IF(дневник!R15=0,\"\",дневник!R15)","v":""}]
[1,{"$f":"IF(дневник!L16=0,\"\",дневник!L16)","v":"апельсины"},{"$f":"SUMPRODUCT((дневник!$D$9:$D$25=B6)*(дневник!$C$9:$C$25<=$D$1)*дневник!$F$9:$F$25)-SUMPRODUCT((дневник!$D$9:$D$25=B6)*(дневник!$C$9:$C$25<=$D$1)*дневник!$H$9:$H$25)+VLOOKUP(B6,лист!$A$12:$B$17,2,0)","v":32},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B6,дневник!$E$9:$E$25,D$5,дневник!$B$9:$B$25,$C$2)","v":124},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B6,дневник!$E$9:$E$25,E$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B6,дневник!$E$9:$E$25,F$5,дневник!$B$9:$B$25,$C$2)","v":78},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B6,дневник!$E$9:$E$25,G$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B6,дневник!$E$9:$E$25,H$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B6,дневник!$E$9:$E$25,I$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUM(D6:I6)","v":202},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B6,дневник!$G$9:$G$25,K$5,дневник!$B$9:$B$25,отчет!$C$2)","v":133},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B6,дневник!$G$9:$G$25,L$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B6,дневник!$G$9:$G$25,M$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B6,дневник!$G$9:$G$25,N$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B6,дневник!$G$9:$G$25,O$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B6,дневник!$G$9:$G$25,P$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUM(K6:P6)","v":133},{"$f":"C6+J6-Q6","v":101}]
[2,{"$f":"IF(дневник!L17=0,\"\",дневник!L17)","v":"бананы"},{"$f":"SUMPRODUCT((дневник!$D$9:$D$25=B7)*(дневник!$C$9:$C$25<=$D$1)*дневник!$F$9:$F$25)-SUMPRODUCT((дневник!$D$9:$D$25=B7)*(дневник!$C$9:$C$25<=$D$1)*дневник!$H$9:$H$25)+VLOOKUP(B7,лист!$A$12:$B$17,2,0)","v":27},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B7,дневник!$E$9:$E$25,D$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B7,дневник!$E$9:$E$25,E$5,дневник!$B$9:$B$25,$C$2)","v":95},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B7,дневник!$E$9:$E$25,F$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B7,дневник!$E$9:$E$25,G$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B7,дневник!$E$9:$E$25,H$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B7,дневник!$E$9:$E$25,I$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUM(D7:I7)","v":95},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B7,дневник!$G$9:$G$25,K$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B7,дневник!$G$9:$G$25,L$5,дневник!$B$9:$B$25,отчет!$C$2)","v":78},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B7,дневник!$G$9:$G$25,M$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B7,дневник!$G$9:$G$25,N$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B7,дневник!$G$9:$G$25,O$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B7,дневник!$G$9:$G$25,P$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUM(K7:P7)","v":78},{"$f":"C7+J7-Q7","v":44}]
[3,{"$f":"IF(дневник!L18=0,\"\",дневник!L18)","v":"киви"},{"$f":"SUMPRODUCT((дневник!$D$9:$D$25=B8)*(дневник!$C$9:$C$25<=$D$1)*дневник!$F$9:$F$25)-SUMPRODUCT((дневник!$D$9:$D$25=B8)*(дневник!$C$9:$C$25<=$D$1)*дневник!$H$9:$H$25)+VLOOKUP(B8,лист!$A$12:$B$17,2,0)","v":45},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B8,дневник!$E$9:$E$25,D$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B8,дневник!$E$9:$E$25,E$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B8,дневник!$E$9:$E$25,F$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B8,дневник!$E$9:$E$25,G$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B8,дневник!$E$9:$E$25,H$5,дневник!$B$9:$B$25,$C$2)","v":78},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B8,дневник!$E$9:$E$25,I$5,дневник!$B$9:$B$25,$C$2)","v":0},78,{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B8,дневник!$G$9:$G$25,K$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B8,дневник!$G$9:$G$25,L$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B8,дневник!$G$9:$G$25,M$5,дневник!$B$9:$B$25,отчет!$C$2)","v":14},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B8,дневник!$G$9:$G$25,N$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B8,дневник!$G$9:$G$25,O$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B8,дневник!$G$9:$G$25,P$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},14,109]
[4,{"$f":"IF(дневник!L19=0,\"\",дневник!L19)","v":"яблоки"},{"$f":"SUMPRODUCT((дневник!$D$9:$D$25=B9)*(дневник!$C$9:$C$25<=$D$1)*дневник!$F$9:$F$25)-SUMPRODUCT((дневник!$D$9:$D$25=B9)*(дневник!$C$9:$C$25<=$D$1)*дневник!$H$9:$H$25)+VLOOKUP(B9,лист!$A$12:$B$17,2,0)","v":45},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B9,дневник!$E$9:$E$25,D$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B9,дневник!$E$9:$E$25,E$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B9,дневник!$E$9:$E$25,F$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B9,дневник!$E$9:$E$25,G$5,дневник!$B$9:$B$25,$C$2)","v":50},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B9,дневник!$E$9:$E$25,H$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B9,дневник!$E$9:$E$25,I$5,дневник!$B$9:$B$25,$C$2)","v":0},50,{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B9,дневник!$G$9:$G$25,K$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B9,дневник!$G$9:$G$25,L$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B9,дневник!$G$9:$G$25,M$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B9,дневник!$G$9:$G$25,N$5,дневник!$B$9:$B$25,отчет!$C$2)","v":12},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B9,дневник!$G$9:$G$25,O$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B9,дневник!$G$9:$G$25,P$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},12,83]
[5,{"$f":"IF(дневник!L20=0,\"\",дневник!L20)","v":""},{"$f":"SUMPRODUCT((дневник!$D$9:$D$25=B10)*(дневник!$C$9:$C$25<=$D$1)*дневник!$F$9:$F$25)-SUMPRODUCT((дневник!$D$9:$D$25=B10)*(дневник!$C$9:$C$25<=$D$1)*дневник!$H$9:$H$25)+VLOOKUP(B10,лист!$A$12:$B$17,2,0)","v":{"$error":"#N/A"}},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B10,дневник!$E$9:$E$25,D$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B10,дневник!$E$9:$E$25,E$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B10,дневник!$E$9:$E$25,F$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B10,дневник!$E$9:$E$25,G$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B10,дневник!$E$9:$E$25,H$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B10,дневник!$E$9:$E$25,I$5,дневник!$B$9:$B$25,$C$2)","v":0},0,{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B10,дневник!$G$9:$G$25,K$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B10,дневник!$G$9:$G$25,L$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B10,дневник!$G$9:$G$25,M$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B10,дневник!$G$9:$G$25,N$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B10,дневник!$G$9:$G$25,O$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B10,дневник!$G$9:$G$25,P$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},0,{"$error":"#N/A"}]
[6,{"$f":"IF(дневник!L21=0,\"\",дневник!L21)","v":""},{"$f":"SUMPRODUCT((дневник!$D$9:$D$25=B11)*(дневник!$C$9:$C$25<=$D$1)*дневник!$F$9:$F$25)-SUMPRODUCT((дневник!$D$9:$D$25=B11)*(дневник!$C$9:$C$25<=$D$1)*дневник!$H$9:$H$25)+VLOOKUP(B11,лист!$A$12:$B$17,2,0)","v":{"$error":"#N/A"}},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B11,дневник!$E$9:$E$25,D$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B11,дневник!$E$9:$E$25,E$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B11,дневник!$E$9:$E$25,F$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B11,дневник!$E$9:$E$25,G$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B11,дневник!$E$9:$E$25,H$5,дневник!$B$9:$B$25,$C$2)","v":0},{"$f":"SUMIFS(дневник!$F$9:$F$25,дневник!$D$9:$D$25,$B11,дневник!$E$9:$E$25,I$5,дневник!$B$9:$B$25,$C$2)","v":0},0,{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B11,дневник!$G$9:$G$25,K$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B11,дневник!$G$9:$G$25,L$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B11,дневник!$G$9:$G$25,M$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B11,дневник!$G$9:$G$25,N$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B11,дневник!$G$9:$G$25,O$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},{"$f":"SUMIFS(дневник!$H$9:$H$25,дневник!$D$9:$D$25,$B11,дневник!$G$9:$G$25,P$5,дневник!$B$9:$B$25,отчет!$C$2)","v":0},0,{"$error":"#N/A"}]
[7,{"$f":"IF(дневник!L23=0,\"\",дневник!L23)","v":""},null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,0]
[]
[]
["О\nБ\nР\nА\nЗ\nЕ\nЦ","январь","остаток","Москва","Самара","Питер","Ялта","Киев",null,"всего","Сидоров","Карен","Павленко","Самсонов",null,null,"всего","остаток"]
[null,"яблоки",45,0,50,0,0,0,null,50,12,0,0,0,null,null,12,83]
[null,"сливы",48,0,0,0,0,0,null,0,0,0,0,0,null,null,0,48]
[null,"апельсины",32,0,0,78,0,124,null,202,0,133,0,0,null,null,133,101]
[null,"бананы",10,95,0,0,0,0,null,95,0,0,78,0,null,null,78,27]
[null,"киви",45,0,0,0,78,0,null,78,0,0,0,14,null,null,14,109]
[null,"в отчете за январь недолжно быть из ТОВАРА (грушы), из ГОРОДОВ (Рязань), из МЕНЕДЖЕРОВ (Иванов, Петров)"]
[]
["О\nБ\nР\nА\nЗ\nЕ\nЦ","февраль","остаток","Москва","Питер","Киев","Рязань",null,null,"всего","Иванов","Петров","Карен","Павленко","Самсонов",null,"всего","остаток"]
[null,"яблоки",83,0,60,0,0,null,null,60,0,0,0,0,58,null,58,85]
[null,"сливы",48,0,0,0,0,null,null,0,0,0,0,0,0,null,0,48]
[null,"апельсины",101,0,0,0,0,null,null,0,0,0,0,0,0,null,0,101]
[null,"бананы",27,0,0,12,102,null,null,114,78,0,8,0,0,null,86,55]
[null,"киви",109,58,0,0,0,null,null,58,0,0,0,9,0,null,9,158]
[null,"грушы",null,0,0,874,0,null,null,874,0,54,0,0,0,null,54,820]
[null,"в отчете за февраль недолжно быть из ГОРОДОВ (Самара, Ялта), из МЕНЕДЖЕРОВ (Сидоров)"]
[]
[]
["О\nБ\nР\nА\nЗ\nЕ\nЦ","март","остаток","Москва","Питер",null,null,null,null,"всего","Павленко","Самсонов",null,null,null,null,"всего","остаток"]
[null,"яблоки",85,0,0,null,null,null,null,0,0,0,null,null,null,null,0,85]
[null,"сливы",48,0,58,null,null,null,null,58,0,56,null,null,null,null,56,50]
[null,"апельсины",101,0,0,null,null,null,null,0,0,0,null,null,null,null,0,101]
[null,"бананы",55,0,0,null,null,null,null,0,0,0,null,null,null,null,0,55]
[null,"киви",158,54,0,null,null,null,null,54,12,0,null,null,null,null,12,200]
[null,"грушы",820,0,0,null,null,null,null,0,0,0,null,null,null,null,0,820]
[null,"в отчете за март недолжно быть из ГОРОДОВ (Самара,Ялта,Киев,Рязань), из МЕНЕДЖЕРОВ (Иванов, Петров,Сидоров,Карен)"]

{"sheet":"лист","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Москва","Иванов",null,"январь","2014-01-01"]
["Самара","Петров",null,"февраль","2014-02-01"]
["Питер","Сидоров",null,"март","2014-03-01"]
["Ялта","Карен",null,"апрель","2014-04-01"]
["Киев","Павленко",null,"май","2014-05-01"]
["Рязань","Самсонов",null,"июнь","2014-06-01"]
[null,null,null,"июль","2014-07-01"]
[null,null,null,"август","2014-08-01"]
[null,null,null,"сентябрь","2014-09-01"]
[null,null,null,"октябрь","2014-10-01"]
["товар",null,null,"ноябрь","2014-11-01"]
["яблоки",45,null,"декабрь","2014-12-01"]
["сливы",48]
["апельсины",32]
["бананы",10]
["киви",45]
["грушы"]
["…"]
["…"]