{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["база","стат-ка звонки"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":3,"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":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"ЗВОНОК",null,null,null,"ПОСЫЛКИ (1ый ЭТАП)"]
["номер телефона","коммент","дата","номер звонка","повтор","статус","дата"]
["111-11-11","сбрасывает","2012-07-17",1,null,"ждет отправки"]
["222-22-22","не отвечает","2012-07-18",2,null,"ждет отправки"]
["333-33-33","заберет","2012-07-19",1,null,"отправлено"]

{"sheet":"стат-ка звонки","index":1,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"IF(OR(WEEKDAY(B2,2)=7,WEEKDAY(B2,2)=6),\"вых\",\"\")","v":""},{"$f":"IF(OR(WEEKDAY(C2,2)=7,WEEKDAY(C2,2)=6),\"вых\",\"\")","v":""},"","","","вых","вых","","","",""]
["дата","2012-07-16","2012-07-17","2012-07-18","2012-07-19","2012-07-20","2012-07-21","2012-07-22","2012-07-23","2012-07-24","2012-07-25","2012-07-26"]
["2ые звонки"]
["сегодня:",{"$f":"IF(TODAY()=B2,\"сегодня\",\"\")","v":""},"","","","сегодня","","","","","",""]
["нужно сделать звонков",{"$f":"IF(B1=\"вых\",\"\",SUMIFS(#REF!,#REF!,1))","v":{"$error":"#REF!"}},{"$f":"IF(C1=\"вых\",\"\",SUMIFS(#REF!,#REF!,1))","v":{"$error":"#REF!"}},{"$f":"IF(D1=\"вых\",\"\",SUMIFS(#REF!,#REF!,1))","v":{"$error":"#REF!"}},{"$f":"IF(E1=\"вых\",\"\",SUMIFS(#REF!,#REF!,1))","v":{"$error":"#REF!"}},{"$f":"IF(F1=\"вых\",\"\",SUMIFS(#REF!,#REF!,1))","v":{"$error":"#REF!"}},{"$f":"IF(G1=\"вых\",\"\",SUMIFS(#REF!,#REF!,1))","v":""},{"$f":"IF(H1=\"вых\",\"\",SUMIFS(#REF!,#REF!,1))","v":""},{"$f":"IF(I1=\"вых\",\"\",SUMIFS(#REF!,#REF!,1))","v":{"$error":"#REF!"}},{"$f":"IF(J1=\"вых\",\"\",SUMIFS(#REF!,#REF!,1))","v":{"$error":"#REF!"}},{"$f":"IF(K1=\"вых\",\"\",SUMIFS(#REF!,#REF!,1))","v":{"$error":"#REF!"}},{"$f":"IF(L1=\"вых\",\"\",SUMIFS(#REF!,#REF!,1))","v":{"$error":"#REF!"}}]
["эф-ть",{"$f":"IFERROR(B8/B5,\"\")","v":""},"","","","","","","","","",""]
["кол-во звонков",{"$f":"IF(SUMIFS(#REF!,база!$C:$C,B2)=0,\"\",SUMIFS(#REF!,база!$C:$C,B2))","v":{"$error":"#REF!"}},{"$f":"IF(SUMIFS(#REF!,база!$C:$C,C2)=0,\"\",SUMIFS(#REF!,база!$C:$C,C2))","v":{"$error":"#REF!"}},{"$f":"IF(SUMIFS(#REF!,база!$C:$C,D2)=0,\"\",SUMIFS(#REF!,база!$C:$C,D2))","v":{"$error":"#REF!"}},{"$f":"IF(SUMIFS(#REF!,база!$C:$C,E2)=0,\"\",SUMIFS(#REF!,база!$C:$C,E2))","v":{"$error":"#REF!"}},{"$f":"IF(SUMIFS(#REF!,база!$C:$C,F2)=0,\"\",SUMIFS(#REF!,база!$C:$C,F2))","v":{"$error":"#REF!"}},{"$f":"IF(SUMIFS(#REF!,база!$C:$C,G2)=0,\"\",SUMIFS(#REF!,база!$C:$C,G2))","v":{"$error":"#REF!"}},{"$f":"IF(SUMIFS(#REF!,база!$C:$C,H2)=0,\"\",SUMIFS(#REF!,база!$C:$C,H2))","v":{"$error":"#REF!"}},{"$f":"IF(SUMIFS(#REF!,база!$C:$C,I2)=0,\"\",SUMIFS(#REF!,база!$C:$C,I2))","v":{"$error":"#REF!"}},{"$f":"IF(SUMIFS(#REF!,база!$C:$C,J2)=0,\"\",SUMIFS(#REF!,база!$C:$C,J2))","v":{"$error":"#REF!"}},{"$f":"IF(SUMIFS(#REF!,база!$C:$C,K2)=0,\"\",SUMIFS(#REF!,база!$C:$C,K2))","v":{"$error":"#REF!"}},{"$f":"IF(SUMIFS(#REF!,база!$C:$C,L2)=0,\"\",SUMIFS(#REF!,база!$C:$C,L2))","v":{"$error":"#REF!"}}]
["сделано звонков",{"$f":"COUNTIF(база!$C:$C,'стат-ка звонки'!B2)","v":0},{"$f":"COUNTIF(база!$C:$C,'стат-ка звонки'!C2)","v":1},{"$f":"COUNTIF(база!$C:$C,'стат-ка звонки'!D2)","v":1},{"$f":"COUNTIF(база!$C:$C,'стат-ка звонки'!E2)","v":1},{"$f":"COUNTIF(база!$C:$C,'стат-ка звонки'!F2)","v":0},{"$f":"COUNTIF(база!$C:$C,'стат-ка звонки'!G2)","v":0},{"$f":"COUNTIF(база!$C:$C,'стат-ка звонки'!H2)","v":0},{"$f":"COUNTIF(база!$C:$C,'стат-ка звонки'!I2)","v":0},{"$f":"COUNTIF(база!$C:$C,'стат-ка звонки'!J2)","v":0},{"$f":"COUNTIF(база!$C:$C,'стат-ка звонки'!K2)","v":0},{"$f":"COUNTIF(база!$C:$C,'стат-ка звонки'!L2)","v":0}]