{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Лист1","index":0,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["изделие","партия",null,null,"изделие","партия"]
["изд 1","1-22",null,null,"изд 1","1-22"]
["изд 2","3-22",null,null,"изд 1","01-22"]
["изд 3","03-22опытн",null,null,"изд 2","3-22"]
["изд 4","06-22",null,null,"изд 3","03-22опытн"]
["изд 5","2-22",null,null,"изд 3","3-22"]
["изд 6","7-22",null,null,"изд 4","05-22"]
["изд 7","79-22",null,null,"изд 4","06-22"]
["изд 8","5-22",null,null,"изд 5","2-22"]
["изд 9","6-22",null,null,"изд 6","7-22"]
["изд 10","10-22",null,null,"изд 7","79-22"]
["изд 1","01-22",null,null,"изд 7","97-22"]
["изд 2","3-22",null,null,"изд 8","5-22"]
["изд 3","3-22",null,null,"изд 9","6-22"]
["изд 4","05-22",null,null,"изд 9","пф-22"]
["изд 5","2-22",null,null,"изд 10","10-22"]
["изд 6","7-22"]
["изд 7","97-22"]
["изд 8","5-22"]
["изд 9","пф-22"]
["изд 10","10-22"]
["изд 1","01-22"]
["изд 2","3-22"]
["изд 3","3-22"]
["изд 4","05-22"]
["изд 5","2-22"]
["изд 6","7-22"]
["изд 7","97-22"]
["изд 8","5-22"]
["изд 9","пф-22"]
["изд 10","10-22"]

{"sheet":"Лист2","index":1,"n_rows":13,"n_cols":45,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["месяц","год","изд","партия","коэф","Ф. И. О.","р/р",{"$f":"DATE($B$2,$A$2,COLUMN(A1))","v":"2022-04-01"},{"$f":"DATE($B$2,$A$2,COLUMN(B1))","v":"2022-04-02"},{"$f":"DATE($B$2,$A$2,COLUMN(C1))","v":"2022-04-03"},{"$f":"DATE($B$2,$A$2,COLUMN(D1))","v":"2022-04-04"},{"$f":"DATE($B$2,$A$2,COLUMN(E1))","v":"2022-04-05"},{"$f":"DATE($B$2,$A$2,COLUMN(F1))","v":"2022-04-06"},{"$f":"DATE($B$2,$A$2,COLUMN(G1))","v":"2022-04-07"},{"$f":"DATE($B$2,$A$2,COLUMN(H1))","v":"2022-04-08"},{"$f":"DATE($B$2,$A$2,COLUMN(I1))","v":"2022-04-09"},{"$f":"DATE($B$2,$A$2,COLUMN(J1))","v":"2022-04-10"},{"$f":"DATE($B$2,$A$2,COLUMN(K1))","v":"2022-04-11"},{"$f":"DATE($B$2,$A$2,COLUMN(L1))","v":"2022-04-12"},{"$f":"DATE($B$2,$A$2,COLUMN(M1))","v":"2022-04-13"},{"$f":"DATE($B$2,$A$2,COLUMN(N1))","v":"2022-04-14"},{"$f":"DATE($B$2,$A$2,COLUMN(O1))","v":"2022-04-15"},{"$f":"DATE($B$2,$A$2,COLUMN(P1))","v":"2022-04-16"},{"$f":"DATE($B$2,$A$2,COLUMN(Q1))","v":"2022-04-17"},{"$f":"DATE($B$2,$A$2,COLUMN(R1))","v":"2022-04-18"},{"$f":"DATE($B$2,$A$2,COLUMN(S1))","v":"2022-04-19"},{"$f":"DATE($B$2,$A$2,COLUMN(T1))","v":"2022-04-20"},{"$f":"DATE($B$2,$A$2,COLUMN(U1))","v":"2022-04-21"},{"$f":"DATE($B$2,$A$2,COLUMN(V1))","v":"2022-04-22"},{"$f":"DATE($B$2,$A$2,COLUMN(W1))","v":"2022-04-23"},{"$f":"DATE($B$2,$A$2,COLUMN(X1))","v":"2022-04-24"},{"$f":"DATE($B$2,$A$2,COLUMN(Y1))","v":"2022-04-25"},{"$f":"DATE($B$2,$A$2,COLUMN(Z1))","v":"2022-04-26"},{"$f":"DATE($B$2,$A$2,COLUMN(AA1))","v":"2022-04-27"},{"$f":"DATE($B$2,$A$2,COLUMN(AB1))","v":"2022-04-28"},{"$f":"DATE($B$2,$A$2,COLUMN(AC1))","v":"2022-04-29"},{"$f":"DATE($B$2,$A$2,COLUMN(AD1))","v":"2022-04-30"},{"$f":"DATE($B$2,$A$2,COLUMN(AE1))","v":"2022-05-01"},"сумма","сумма2"]
[4,2022,1,"08-22",1,"Иванова А.А","3/16",8,null,null,8,8,8,8,8,null,null,8,8,8,8,8,null,null,8,8,8,8,8,null,null,8,8,8,8,8,5,null,{"$f":"SUM(H2:AL2)-I2-P2-W2-AD2-AK2","v":168},{"$f":"Таблица1[[#This Row],[2]]+Таблица1[[#This Row],[3]]+Таблица1[[#This Row],[9]]+Таблица1[[#This Row],[10]]+Таблица1[[#This Row],[16]]+Таблица1[[#This Row],[17]]+Таблица1[[#This Row],[23]]+Таблица1[[#This Row],[24]]+Таблица1[[#This Row],[30]]+Таблица1[[#This Row],[31]]","v":5},{"$f":"SUMIFS(H2:AL2,WEEKDAY(H$1:AL$1,2),\"<>\"&6,WEEKDAY(H$1:AL$1,2),\"<>\"&7)","v":168},{"$f":"SUMIFS(H2:AL2,WEEKDAY(H$1:AL$1,2),6)+SUMIFS(H2:AL2,WEEKDAY(H$1:AL$1,2),7)","v":5},null,null,1]
[{"$f":"A2","v":4},2022,1,"08-22",1,"Иванова А.В.","4/24",8,null,null,8,8,8,8,8,5.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H3:AL3)-I3-P3-W3-AD3-AK3","v":48},{"$f":"Таблица1[[#This Row],[2]]+Таблица1[[#This Row],[3]]+Таблица1[[#This Row],[9]]+Таблица1[[#This Row],[10]]+Таблица1[[#This Row],[16]]+Таблица1[[#This Row],[17]]+Таблица1[[#This Row],[23]]+Таблица1[[#This Row],[24]]+Таблица1[[#This Row],[30]]+Таблица1[[#This Row],[31]]","v":5.5},{"$f":"SUMIFS(H3:AL3,WEEKDAY(H$1:AL$1,2),\"<>\"&6,WEEKDAY(H$1:AL$1,2),\"<>\"&7)","v":48},{"$f":"SUMIFS(H3:AL3,WEEKDAY(H$1:AL$1,2),6)+SUMIFS(H3:AL3,WEEKDAY(H$1:AL$1,2),7)","v":5.5},null,null,2]
[{"$f":"A3","v":4},2022,1,"08-22",1,"Иванова А.Д.","4/24",8,null,null,8,8,8,8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,{"$f":"SUM(H4:AL4)-I4-P4-W4-AD4-AK4","v":48},{"$f":"Таблица1[[#This Row],[2]]+Таблица1[[#This Row],[3]]+Таблица1[[#This Row],[9]]+Таблица1[[#This Row],[10]]+Таблица1[[#This Row],[16]]+Таблица1[[#This Row],[17]]+Таблица1[[#This Row],[23]]+Таблица1[[#This Row],[24]]+Таблица1[[#This Row],[30]]+Таблица1[[#This Row],[31]]","v":6},{"$f":"SUMIFS(H4:AL4,WEEKDAY(H$1:AL$1,2),\"<>\"&6,WEEKDAY(H$1:AL$1,2),\"<>\"&7)","v":48},{"$f":"SUMIFS(H4:AL4,WEEKDAY(H$1:AL$1,2),6)+SUMIFS(H4:AL4,WEEKDAY(H$1:AL$1,2),7)","v":6},null,null,3]
[{"$f":"A4","v":4},2022,1,"08-22",1,"Иванова А.Г.","4/24",8,null,null,8,8,8,8,8,null,null,null,null,null,null,null,5.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H5:AL5)-I5-P5-W5-AD5-AK5","v":48},{"$f":"Таблица1[[#This Row],[2]]+Таблица1[[#This Row],[3]]+Таблица1[[#This Row],[9]]+Таблица1[[#This Row],[10]]+Таблица1[[#This Row],[16]]+Таблица1[[#This Row],[17]]+Таблица1[[#This Row],[23]]+Таблица1[[#This Row],[24]]+Таблица1[[#This Row],[30]]+Таблица1[[#This Row],[31]]","v":5.5},{"$f":"SUMIFS(H5:AL5,WEEKDAY(H$1:AL$1,2),\"<>\"&6,WEEKDAY(H$1:AL$1,2),\"<>\"&7)","v":48},{"$f":"SUMIFS(H5:AL5,WEEKDAY(H$1:AL$1,2),6)+SUMIFS(H5:AL5,WEEKDAY(H$1:AL$1,2),7)","v":5.5},null,null,4]
[{"$f":"A5","v":4},2022,1,"08-22",1,"Иванова А.Ж.","3/24",8,null,null,8,8,8,8,8,5.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H6:AL6)-I6-P6-W6-AD6-AK6","v":48},{"$f":"Таблица1[[#This Row],[2]]+Таблица1[[#This Row],[3]]+Таблица1[[#This Row],[9]]+Таблица1[[#This Row],[10]]+Таблица1[[#This Row],[16]]+Таблица1[[#This Row],[17]]+Таблица1[[#This Row],[23]]+Таблица1[[#This Row],[24]]+Таблица1[[#This Row],[30]]+Таблица1[[#This Row],[31]]","v":5.5},{"$f":"SUMIFS(H6:AL6,WEEKDAY(H$1:AL$1,2),\"<>\"&6,WEEKDAY(H$1:AL$1,2),\"<>\"&7)","v":48},{"$f":"SUMIFS(H6:AL6,WEEKDAY(H$1:AL$1,2),6)+SUMIFS(H6:AL6,WEEKDAY(H$1:AL$1,2),7)","v":5.5},null,null,5]
[{"$f":"A6","v":4},2022,1,"08-22",1,"Иванова А.К.","3/24",8,null,null,8,8,8,8,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,{"$f":"SUM(H7:AL7)-I7-P7-W7-AD7-AK7","v":48},{"$f":"Таблица1[[#This Row],[2]]+Таблица1[[#This Row],[3]]+Таблица1[[#This Row],[9]]+Таблица1[[#This Row],[10]]+Таблица1[[#This Row],[16]]+Таблица1[[#This Row],[17]]+Таблица1[[#This Row],[23]]+Таблица1[[#This Row],[24]]+Таблица1[[#This Row],[30]]+Таблица1[[#This Row],[31]]","v":6},{"$f":"SUMIFS(H7:AL7,WEEKDAY(H$1:AL$1,2),\"<>\"&6,WEEKDAY(H$1:AL$1,2),\"<>\"&7)","v":48},{"$f":"SUMIFS(H7:AL7,WEEKDAY(H$1:AL$1,2),6)+SUMIFS(H7:AL7,WEEKDAY(H$1:AL$1,2),7)","v":6},null,null,6]
[{"$f":"A7","v":4},2022,1,"08-22",1,"Иванова А.Б.","3/24",8,null,null,8,8,8,8,8,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H8:AL8)-I8-P8-W8-AD8-AK8","v":48},{"$f":"Таблица1[[#This Row],[2]]+Таблица1[[#This Row],[3]]+Таблица1[[#This Row],[9]]+Таблица1[[#This Row],[10]]+Таблица1[[#This Row],[16]]+Таблица1[[#This Row],[17]]+Таблица1[[#This Row],[23]]+Таблица1[[#This Row],[24]]+Таблица1[[#This Row],[30]]+Таблица1[[#This Row],[31]]","v":6},{"$f":"SUMIFS(H8:AL8,WEEKDAY(H$1:AL$1,2),\"<>\"&6,WEEKDAY(H$1:AL$1,2),\"<>\"&7)","v":48},{"$f":"SUMIFS(H8:AL8,WEEKDAY(H$1:AL$1,2),6)+SUMIFS(H8:AL8,WEEKDAY(H$1:AL$1,2),7)","v":6},null,null,7]
[{"$f":"A8","v":4},2022,2,"05-22",1,"Иванова А.Д.","3/16",null,null,null,null,null,null,null,null,null,null,8,8,8,8,8,null,null,null,null,null,null,null,6,null,null,8,8,8,8,6,null,{"$f":"SUM(H9:AL9)-I9-P9-W9-AD9-AK9","v":72},{"$f":"Таблица1[[#This Row],[2]]+Таблица1[[#This Row],[3]]+Таблица1[[#This Row],[9]]+Таблица1[[#This Row],[10]]+Таблица1[[#This Row],[16]]+Таблица1[[#This Row],[17]]+Таблица1[[#This Row],[23]]+Таблица1[[#This Row],[24]]+Таблица1[[#This Row],[30]]+Таблица1[[#This Row],[31]]","v":12},{"$f":"SUMIFS(H9:AL9,WEEKDAY(H$1:AL$1,2),\"<>\"&6,WEEKDAY(H$1:AL$1,2),\"<>\"&7)","v":72},{"$f":"SUMIFS(H9:AL9,WEEKDAY(H$1:AL$1,2),6)+SUMIFS(H9:AL9,WEEKDAY(H$1:AL$1,2),7)","v":12},null,null,8]
[{"$f":"A9","v":4},2022,2,"05-22",1,"Иванова А.Л.","3/16",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,8,8,8,8,6,null,{"$f":"SUM(H10:AL10)-I10-P10-W10-AD10-AK10","v":32},{"$f":"Таблица1[[#This Row],[2]]+Таблица1[[#This Row],[3]]+Таблица1[[#This Row],[9]]+Таблица1[[#This Row],[10]]+Таблица1[[#This Row],[16]]+Таблица1[[#This Row],[17]]+Таблица1[[#This Row],[23]]+Таблица1[[#This Row],[24]]+Таблица1[[#This Row],[30]]+Таблица1[[#This Row],[31]]","v":6},{"$f":"SUMIFS(H10:AL10,WEEKDAY(H$1:AL$1,2),\"<>\"&6,WEEKDAY(H$1:AL$1,2),\"<>\"&7)","v":32},{"$f":"SUMIFS(H10:AL10,WEEKDAY(H$1:AL$1,2),6)+SUMIFS(H10:AL10,WEEKDAY(H$1:AL$1,2),7)","v":6},null,null,9]
[{"$f":"A10","v":4},2022,2,"05-22",1,"Иванова А.М.","3/24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,{"$f":"SUM(H11:AL11)-I11-P11-W11-AD11-AK11","v":8},{"$f":"Таблица1[[#This Row],[2]]+Таблица1[[#This Row],[3]]+Таблица1[[#This Row],[9]]+Таблица1[[#This Row],[10]]+Таблица1[[#This Row],[16]]+Таблица1[[#This Row],[17]]+Таблица1[[#This Row],[23]]+Таблица1[[#This Row],[24]]+Таблица1[[#This Row],[30]]+Таблица1[[#This Row],[31]]","v":6},{"$f":"SUMIFS(H11:AL11,WEEKDAY(H$1:AL$1,2),\"<>\"&6,WEEKDAY(H$1:AL$1,2),\"<>\"&7)","v":8},{"$f":"SUMIFS(H11:AL11,WEEKDAY(H$1:AL$1,2),6)+SUMIFS(H11:AL11,WEEKDAY(H$1:AL$1,2),7)","v":6},null,null,10]
[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,{"$f":"SUM(H12:AL12)-I12-P12-W12-AD12-AK12","v":0},{"$f":"Таблица1[[#This Row],[2]]+Таблица1[[#This Row],[3]]+Таблица1[[#This Row],[9]]+Таблица1[[#This Row],[10]]+Таблица1[[#This Row],[16]]+Таблица1[[#This Row],[17]]+Таблица1[[#This Row],[23]]+Таблица1[[#This Row],[24]]+Таблица1[[#This Row],[30]]+Таблица1[[#This Row],[31]]","v":0},{"$f":"SUMIFS(H12:AL12,WEEKDAY(H$1:AL$1,2),\"<>\"&6,WEEKDAY(H$1:AL$1,2),\"<>\"&7)","v":0},{"$f":"SUMIFS(H12:AL12,WEEKDAY(H$1:AL$1,2),6)+SUMIFS(H12:AL12,WEEKDAY(H$1:AL$1,2),7)","v":0},null,null,11]
[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,12]