{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":33,"n_cols":24,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Таблица 1. Трудозатраты",null,null,null,null,null,null,null,null,null,"Таблица 2. План выполннения работ, шт."]
[null,"Вид работ","Время выполнения, часов","Исполнитель",null,null,null,null,null,null,null,"Наименование работы","Январь","Февраль","Март","Апрель","Май","Июнь","Июль","Август","Сентябрь","Октябрь","Ноябрь","Декабрь"]
[null,null,null,null,null,null,null,null,null,null,null,"Работа 1",500,null,200,null,null,400,null,null,375]
[null,"Работа 1",null,null,null,null,null,null,null,null,null,"………"]
[null,"Подработа 1",5,"Должность 1",null,"Работа 1",null,null,null,null,null,"Работа 5",300,null,null,100,null,300,null,150]
[null,"Подработа 2",2,"Должность 2",null,"Работа 1",null,null,null,null,null,"………."]
[null,"Подработа 3",4,"Должность 1",null,"Работа 1",null,null,null,null,null,"Работа N"]
[null,"…….",null,null,null,"Работа 1"]
[null,"Подработа N",null,null,null,"Работа 1"]
[]
[]
[null,"………………………………………………………."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Таблица 3. Общие трудозатраты в разрезе должности"]
[null,"Работа 5",null,null,null,null,null,null,null,null,null,"Наименование должности","Январь","Февраль","Март","Апрель","Май","Июнь","Июль","Август","Сентябрь","Октябрь","Ноябрь","Декабрь"]
[null,"Подработа 1",1,"Должность 7",null,"Работа 5"]
[null,"Подработа 2",10,"Должность 1",null,"Работа 5",null,null,null,null,null,"Должность 1",{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,M$5:M$9,$L19)","v":7500},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,N$5:N$9,$L19)","v":""},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,O$5:O$9,$L19)","v":1800},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,P$5:P$9,$L19)","v":1000},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,Q$5:Q$9,$L19)","v":""},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,R$5:R$9,$L19)","v":6600},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,S$5:S$9,$L19)","v":""},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,T$5:T$9,$L19)","v":1500},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,U$5:U$9,$L19)","v":3375},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,V$5:V$9,$L19)","v":""},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,W$5:W$9,$L19)","v":""},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,X$5:X$9,$L19)","v":""}]
[null,"…….",null,null,null,"Работа 5",null,null,null,null,null,"Должность 2",{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,M$5:M$9,$L20)","v":1000},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,N$5:N$9,$L20)","v":""},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,O$5:O$9,$L20)","v":400},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,P$5:P$9,$L20)","v":""},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,Q$5:Q$9,$L20)","v":""},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,R$5:R$9,$L20)","v":800},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,S$5:S$9,$L20)","v":""},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,T$5:T$9,$L20)","v":""},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,U$5:U$9,$L20)","v":750},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,V$5:V$9,$L20)","v":""},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,W$5:W$9,$L20)","v":""},{"$f":"Rabota($F$7:$F$19,$D$7:$D$19,$C$7:$C$19,$L$5:$L$9,X$5:X$9,$L20)","v":""}]
[null,"Подработа N",null,null,null,"Работа 5",null,null,null,null,null,"…………"]
[null,null,null,null,null,null,null,null,null,null,null,"Должность N"]
[null,"……………………………………………………."]
[null,null,null,null,null,null,null,null,null,null,null,null,7500,0,1800,1000,0,6600,0,1500,3375,0,0,0]
[null,"Работа N",null,null,null,null,null,null,"Единственная моя идея исходя из моих знаний эксель - это привести размерность "]
[null,"Подработа 1",null,null,null,"Работа N",null,null,"всех трех таблиц к единому виду, чтобы можно было пользоваться СУММПРОИЗВ()"]
[null,"Подработа 2",null,null,null,"Работа N",null,null,"с условиями сложения. А это значит, что нужно рисовать огромное \"полотно\","]
[null,"…….",null,null,null,"Работа N",null,null,"поскольку оригинальные таблицы довольно большие."]
[null,"Подработа N",null,null,null,"Работа N"]
[null,null,null,null,null,null,null,null,"Уверен, наверняка, что результат можно получить гораздо проще, но как ни думал - "]
[null,"…………………………………………………….",null,null,null,null,null,null,"ничего не придумал. В инете тоже похожих примеров не нашел."]
[]
[null,null,null,null,null,null,null,null,"Заранее благодарю за помощь!"]