{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Pivot 2","Data","Temp","PT"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":3},"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":"Pivot 2","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["How to filter this by Client column?"]
[]
["Počet z hodnota","Popisky sloupců"]
["Popisky řádků","Client","Date: Reception","Celkový součet"]
["Central Group",28,null,28]
["MČ Praha 10",9,null,9]
["Město Poděbrady",3,null,3]
["M-Invest Devonská",1,null,1]
["SIDI",8,null,8]
["2010-10-15",null,1,1]
["2010-10-20",null,14,14]
["2010-10-21",null,13,13]
["2010-10-22",null,18,18]
["2010-10-25",null,3,3]
["Celkový součet",49,49,98]

{"sheet":"Data","index":1,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,"Table1"]
[null,"Case ID (MECE)","Cost Center","Technician","Type of problem","Solved?","Client","Rcpt","Diag","Start","End","Ext","Cost of repair","Cost to MECE","Income to MECE","Penalty to MECE","Penalty to sub"]
[null,"001-10-2010/107","10107-BD Poděbrady","Kučera","Plasters","Yes","Město Poděbrady","2010-10-01","2010-11-25",null,"2011-01-14",null,1000,1000]
[null,"002-10-2010/190","10190-BD Petržílkova ( Krásná Hůrka )","Langr","Plasters","Yes","SIDI","2010-10-01",null,null,"2010-11-15",null,2000]
[null,"003-10-2010/190","10190-BD Petržílkova ( Krásná Hůrka )","Langr","Plasters","Yes","SIDI","2010-10-01",null,null,"2010-11-24"]
[null,"004-10-2010/190","10190-BD Petržílkova ( Krásná Hůrka )","Langr","Windows","Yes","SIDI","2010-10-04",null,null,"2010-11-18"]
[null,"005-10-2010/190","10190-BD Petržílkova ( Krásná Hůrka )","Langr","Electro","Yes","SIDI","2010-10-04",null,null,"2010-11-22",null,5000,5000,5000]
[null,"006-10-2010/190","10190-BD Petržílkova ( Krásná Hůrka )","Langr","Heating","Yes","SIDI","2010-10-04",null,"2010-11-10","2010-11-10"]
[null,"007-10-2010/157","10157-Stodůlky A, B, E","Mutl","Balkonies","No","Central Group","2010-10-07","2010-11-03","2011-05-30"]
[null,"008-10-2010/157","10157-Stodůlky A, B, E","Mutl","Garder works","Yes","Central Group","2010-10-07",null,null,"2010-11-29"]
[null,"009-10-2010/157","10157-Stodůlky A, B, E","Mutl","Earthworks","No","Central Group","2010-08-16","2010-12-16"]
[null,"010-10-2010/157","10157-Stodůlky A, B, E","Mutl","Waterproof of roof/teraces","Yes","Central Group","2010-09-03","2010-11-02",null,"2010-12-16",null,100000,100000,0,0,0]
[null,"011-10-2010/157","10157-Stodůlky A, B, E","Mutl","Paving","Yes","Central Group","2010-07-20","2010-12-16",null,"2011-02-28"]
[null,"012-10-2010/157","10157-Stodůlky A, B, E","Mutl","Paving","Yes","Central Group","2010-09-27","2010-12-16",null,"2011-02-28"]
[null,"013-10-2010/157","10157-Stodůlky A, B, E","Mutl","Paving","Yes","Central Group","2010-10-01","2010-12-16","2011-02-28"]
[null,"014-10-2010/157","10157-Stodůlky A, B, E","Mutl","Waterproof of roof/teraces","Yes","Central Group","2010-10-03","2010-10-25",null,"2010-11-04",null,100000,100000]
[null,"015-10-2010/157","10157-Stodůlky A, B, E","Mutl","Plasters","No","Central Group","2010-06-10","2010-12-16",null,null,null,1500,1500,0,0,0]
[null,"016-10-2010/157","10157-Stodůlky A, B, E","Mutl","Paving","Yes","Central Group","2010-06-10","2010-12-16","2011-01-31","2011-01-31",null,2000,2000]
[null,"017-10-2010/157","10157-Stodůlky A, B, E","Mutl","Paving","Yes","Central Group","2010-09-24","2010-12-16","2011-01-31","2011-01-31",null,0,0]
[null,"018-10-2010/157","10157-Stodůlky A, B, E","Mutl","Facades","No","Central Group","2010-10-01","2010-10-25",null,null,null,0,0]
[null,"019-10-2010/157","10157-Stodůlky A, B, E","Mutl","Earthworks","Yes","Central Group","2010-06-23","2010-10-25",null,"2010-11-29",null,350000,350000]
[null,"020-10-2010/157","10157-Stodůlky A, B, E","Mutl","Paving","Yes","Central Group","2010-07-15","2010-12-16",null,"2011-02-22",null,20000,20000]
[null,"021-10-2010/157","10157-Stodůlky A, B, E","Mutl","Paving","Yes","Central Group","2010-10-06","2010-12-16",null,"2011-02-22",null,10000,10000]
[null,"022-10-2010/182","10182-Stodůlky L","Mutl","Windows","Yes","Central Group","2010-10-06","2010-10-25",null,"2010-12-07",null,1080,1080,0,0,0]
[null,"023-10-2010/164","10164-Stodůlky H","Mutl","Plasters","Yes","Central Group","2009-06-02",null,null,"2010-12-06",null,70000]
[null,"024-10-2010/199","10199-Stodůlky P","Vágner","Electro","Yes","Central Group","2009-06-02",null,null,"2011-02-03"]
[null,"025-10-2010/198","10198-Stodůlky O","Mutl","Installation","Yes","Central Group","2009-07-20","2010-10-21",null,"2010-12-22"]
[null,"026-10-2010/181","10181-Stodůlky J, K","Kulhavý","Facades","Yes","Central Group","2009-07-20",null,null,"2010-12-17"]
[null,"027-10-2010/181","10181-Stodůlky J, K","Kulhavý","Installation","Yes","Central Group","2009-07-28",null,null,"2010-11-05"]
[null,"028-10-2010/170","10170-BD Devonská","Kučera","Heating","Yes","M-Invest Devonská","2009-07-28",null,null,"2010-11-10",null,0,0,0,0,0]
[null,"029-10-2010/229","10229-Kodaňská","Konopa","Electro","Yes","MČ Praha 10","2009-07-28",null,null,"2011-01-04",null,100,100,0,0,0]
[null,"030-10-2010/229","10229-Kodaňská","Svoboda","Lift","Yes","MČ Praha 10","2009-07-28","2010-11-03",null,"2010-11-10"]
[null,"031-10-2010/229","10229-Kodaňská","Svoboda","Installation","Yes","MČ Praha 10","2011-03-04",null,null,"2011-01-04"]
[null,"032-10-2010/229","10229-Kodaňská","Konopa","Electro","Yes","MČ Praha 10","2011-03-04","2011-10-25","2011-02-04","2011-02-04"]
[null,"033-10-2010/229","10229-Kodaňská","Svoboda","Heating","Yes","MČ Praha 10","2011-03-04",null,null,"2011-01-04"]
[null,"034-10-2010/229","10229-Kodaňská","Svoboda","Doors","Yes","MČ Praha 10","2011-03-04",null,null,"2011-01-14"]
[null,"035-10-2010/229","10229-Kodaňská","Svoboda","Doors","Yes","MČ Praha 10","2011-03-04","2010-10-29",null,"2011-01-04"]
[null,"036-10-2010/229","10229-Kodaňská","Svoboda","Heating","Yes","MČ Praha 10","2011-03-04",null,null,"2011-01-04"]
[null,"037-10-2010/229","10229-Kodaňská","Svoboda","Doors","Yes","MČ Praha 10","2011-03-04",null,null,"2011-01-04",null,7000,0,0,0,0]
[null,"038-10-2010/181","10181-Stodůlky J, K","Kulhavý","Plasters","Yes","Central Group","2011-03-04",null,null,"2010-11-03",null,300,300,0,0,0]
[null,"039-10-2010/199","10199-Stodůlky P","Konopa","Electro","Yes","Central Group","2011-03-04","2010-10-25",null,"2010-12-16",null,200,200,0,0,0]
[null,"040-10-2010/198","10198-Stodůlky O","Konopa","Electro","Yes","Central Group","2011-03-04","2010-10-25",null,"2010-12-16",null,100,100,0,0,0]
[null,"041-10-2010/200","10200-Stodůlky Q","Konopa","Electro","Yes","Central Group","2011-03-04","2010-10-25",null,"2010-12-16",null,300,300,0,0,0]
[null,"042-10-2010/107","10107-BD Poděbrady","Kučera","Waterproof of roof/teraces","No","Město Poděbrady","2011-03-04"]
[null,"043-10-2010/107","10107-BD Poděbrady","Kučera","Waterproof of roof/teraces","No","Město Poděbrady","2011-03-04"]
[null,"044-10-2010/181","10181-Stodůlky J, K","Kulhavý","Floor","Yes","Central Group","2011-03-04",null,null,"2010-10-22",null,350,350,0,0,0]
[null,"045-10-2010/181","10181-Stodůlky J, K","Kulhavý","Plasters","Yes","Central Group","2011-03-04",null,null,"2010-11-12",null,200,200,0,0,0]
[null,"046-10-2010/168","10168-Nové Pitkovice A, B, C, D, F, G","Kulhavý","Installation","Yes","Central Group","2011-03-04","2010-11-04",null,"2011-01-11",null,250,0,0,0,0]
[null,"047-10-2010/190","10190-BD Petržílkova ( Krásná Hůrka )","Svoboda","Electro","Yes","SIDI","2011-03-07",null,"2010-11-15","2010-11-15",null,300,300,0,0,0]
[null,"048-10-2010/190","10190-BD Petržílkova ( Krásná Hůrka )","Svoboda","Electro","Yes","SIDI","2010-10-25",null,"2010-11-15","2010-11-15",null,400,400,0,0,0]
[null,"049-10-2010/190","10190-BD Petržílkova ( Krásná Hůrka )","Svoboda","Electro","Yes","SIDI","2010-10-25",null,"2010-11-15","2010-11-15"]

{"sheet":"Temp","index":2,"n_rows":197,"n_cols":3,"rows_kept":197,"cut":false,"hidden":false,"merged":[]}
["Client","Column","DDate"]
["Město Poděbrady","Rcpt","2010-10-01"]
["Město Poděbrady","Diag","2010-11-25"]
["Město Poděbrady","Start"]
["Město Poděbrady","End","2011-01-14"]
["SIDI","Rcpt","2010-10-01"]
["SIDI","Diag"]
["SIDI","Start"]
["SIDI","End","2010-11-15"]
["SIDI","Rcpt","2010-10-01"]
["SIDI","Diag"]
["SIDI","Start"]
["SIDI","End","2010-11-24"]
["SIDI","Rcpt","2010-10-04"]
["SIDI","Diag"]
["SIDI","Start"]
["SIDI","End","2010-11-18"]
["SIDI","Rcpt","2010-10-04"]
["SIDI","Diag"]
["SIDI","Start"]
["SIDI","End","2010-11-22"]
["SIDI","Rcpt","2010-10-04"]
["SIDI","Diag"]
["SIDI","Start","2010-11-10"]
["SIDI","End","2010-11-10"]
["Central Group","Rcpt","2010-10-07"]
["Central Group","Diag","2010-11-03"]
["Central Group","Start","2011-05-30"]
["Central Group","End"]
["Central Group","Rcpt","2010-10-07"]
["Central Group","Diag"]
["Central Group","Start"]
["Central Group","End","2010-11-29"]
["Central Group","Rcpt","2010-08-16"]
["Central Group","Diag","2010-12-16"]
["Central Group","Start"]
["Central Group","End"]
["Central Group","Rcpt","2010-09-03"]
["Central Group","Diag","2010-11-02"]
["Central Group","Start"]
["Central Group","End","2010-12-16"]
["Central Group","Rcpt","2010-07-20"]
["Central Group","Diag","2010-12-16"]
["Central Group","Start"]
["Central Group","End","2011-02-28"]
["Central Group","Rcpt","2010-09-27"]
["Central Group","Diag","2010-12-16"]
["Central Group","Start"]
["Central Group","End","2011-02-28"]
["Central Group","Rcpt","2010-10-01"]
["Central Group","Diag","2010-12-16"]
["Central Group","Start","2011-02-28"]
["Central Group","End"]
["Central Group","Rcpt","2010-10-03"]
["Central Group","Diag","2010-10-25"]
["Central Group","Start"]
["Central Group","End","2010-11-04"]
["Central Group","Rcpt","2010-06-10"]
["Central Group","Diag","2010-12-16"]
["Central Group","Start"]
["Central Group","End"]
["Central Group","Rcpt","2010-06-10"]
["Central Group","Diag","2010-12-16"]
["Central Group","Start","2011-01-31"]
["Central Group","End","2011-01-31"]
["Central Group","Rcpt","2010-09-24"]
["Central Group","Diag","2010-12-16"]
["Central Group","Start","2011-01-31"]
["Central Group","End","2011-01-31"]
["Central Group","Rcpt","2010-10-01"]
["Central Group","Diag","2010-10-25"]
["Central Group","Start"]
["Central Group","End"]
["Central Group","Rcpt","2010-06-23"]
["Central Group","Diag","2010-10-25"]
["Central Group","Start"]
["Central Group","End","2010-11-29"]
["Central Group","Rcpt","2010-07-15"]
["Central Group","Diag","2010-12-16"]
["Central Group","Start"]
["Central Group","End","2011-02-22"]
["Central Group","Rcpt","2010-10-06"]
["Central Group","Diag","2010-12-16"]
["Central Group","Start"]
["Central Group","End","2011-02-22"]
["Central Group","Rcpt","2010-10-06"]
["Central Group","Diag","2010-10-25"]
["Central Group","Start"]
["Central Group","End","2010-12-07"]
["Central Group","Rcpt","2009-06-02"]
["Central Group","Diag"]
["Central Group","Start"]
["Central Group","End","2010-12-06"]
["Central Group","Rcpt","2009-06-02"]
["Central Group","Diag"]
["Central Group","Start"]
["Central Group","End","2011-02-03"]
["Central Group","Rcpt","2009-07-20"]
["Central Group","Diag","2010-10-21"]
["Central Group","Start"]
["Central Group","End","2010-12-22"]
["Central Group","Rcpt","2009-07-20"]
["Central Group","Diag"]
["Central Group","Start"]
["Central Group","End","2010-12-17"]
["Central Group","Rcpt","2009-07-28"]
["Central Group","Diag"]
["Central Group","Start"]
["Central Group","End","2010-11-05"]
["M-Invest Devonská","Rcpt","2009-07-28"]
["M-Invest Devonská","Diag"]
["M-Invest Devonská","Start"]
["M-Invest Devonská","End","2010-11-10"]
["MČ Praha 10","Rcpt","2009-07-28"]
["MČ Praha 10","Diag"]
["MČ Praha 10","Start"]
["MČ Praha 10","End","2011-01-04"]
["MČ Praha 10","Rcpt","2009-07-28"]
["MČ Praha 10","Diag","2010-11-03"]
["MČ Praha 10","Start"]
["MČ Praha 10","End","2010-11-10"]
["MČ Praha 10","Rcpt","2011-03-04"]
["MČ Praha 10","Diag"]
["MČ Praha 10","Start"]
["MČ Praha 10","End","2011-01-04"]
["MČ Praha 10","Rcpt","2011-03-04"]
["MČ Praha 10","Diag","2011-10-25"]
["MČ Praha 10","Start","2011-02-04"]
["MČ Praha 10","End","2011-02-04"]
["MČ Praha 10","Rcpt","2011-03-04"]
["MČ Praha 10","Diag"]
["MČ Praha 10","Start"]
["MČ Praha 10","End","2011-01-04"]
["MČ Praha 10","Rcpt","2011-03-04"]
["MČ Praha 10","Diag"]
["MČ Praha 10","Start"]
["MČ Praha 10","End","2011-01-14"]
["MČ Praha 10","Rcpt","2011-03-04"]
["MČ Praha 10","Diag","2010-10-29"]
["MČ Praha 10","Start"]
["MČ Praha 10","End","2011-01-04"]
["MČ Praha 10","Rcpt","2011-03-04"]
["MČ Praha 10","Diag"]
["MČ Praha 10","Start"]
["MČ Praha 10","End","2011-01-04"]
["MČ Praha 10","Rcpt","2011-03-04"]
["MČ Praha 10","Diag"]
["MČ Praha 10","Start"]
["MČ Praha 10","End","2011-01-04"]
["Central Group","Rcpt","2011-03-04"]
["Central Group","Diag"]
["Central Group","Start"]
["Central Group","End","2010-11-03"]
["Central Group","Rcpt","2011-03-04"]
["Central Group","Diag","2010-10-25"]
["Central Group","Start"]
["Central Group","End","2010-12-16"]
["Central Group","Rcpt","2011-03-04"]
["Central Group","Diag","2010-10-25"]
["Central Group","Start"]
["Central Group","End","2010-12-16"]
["Central Group","Rcpt","2011-03-04"]
["Central Group","Diag","2010-10-25"]
["Central Group","Start"]
["Central Group","End","2010-12-16"]
["Město Poděbrady","Rcpt","2011-03-04"]
["Město Poděbrady","Diag"]
["Město Poděbrady","Start"]
["Město Poděbrady","End"]
["Město Poděbrady","Rcpt","2011-03-04"]
["Město Poděbrady","Diag"]
["Město Poděbrady","Start"]
["Město Poděbrady","End"]
["Central Group","Rcpt","2011-03-04"]
["Central Group","Diag"]
["Central Group","Start"]
["Central Group","End","2010-10-22"]
["Central Group","Rcpt","2011-03-04"]
["Central Group","Diag"]
["Central Group","Start"]
["Central Group","End","2010-11-12"]
["Central Group","Rcpt","2011-03-04"]
["Central Group","Diag","2010-11-04"]
["Central Group","Start"]
["Central Group","End","2011-01-11"]
["SIDI","Rcpt","2011-03-07"]
["SIDI","Diag"]
["SIDI","Start","2010-11-15"]
["SIDI","End","2010-11-15"]
["SIDI","Rcpt","2010-10-25"]
["SIDI","Diag"]
["SIDI","Start","2010-11-15"]
["SIDI","End","2010-11-15"]
["SIDI","Rcpt","2010-10-25"]
["SIDI","Diag"]
["SIDI","Start","2010-11-15"]
["SIDI","End","2010-11-15"]

{"sheet":"PT","index":3,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PivotTable1"]
[null,"Client","MČ Praha 10"]
[null,null,null,null,null,null,null,null,"PivotTable2"]
[null,"Count of Ddate","Column",null,null,null,null,null,"Count of Value"]
[null,"DDate","Rcpt","Diag","Start","End","Grand Total",null,124]
[null,"2009-07-28",2,null,null,null,2]
[null,"2010-10-29",null,1,null,null,1]
[null,"2010-11-03",null,1,null,null,1]
[null,"2010-11-10",null,null,null,1,1]
[null,"2011-01-04",null,null,null,6,6]
[null,"2011-01-14",null,null,null,1,1]
[null,"2011-02-04",null,null,1,1,2]
[null,"2011-03-04",7,null,null,null,7]
[null,"2011-10-25",null,1,null,null,1]
[null,"Grand Total",9,3,1,9,22]