{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CR1","CR1 Data Productivity","CR1 Data Efficiency"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"CR1","index":0,"n_rows":12,"n_cols":18,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,7,0,12],[2,2,2,3]]}
[null,null,null,null,null,null,null,"Effectiveness & Efficiency Percentage"]
[]
[null,"Select Name","Effectiveness Team Average",null,null,null,"CLICK HERE FOR DROP DOWN BOX"]
[]
[null,null,{"$f":"D5-7","v":"2015-03-16"},{"$f":"E5-7","v":"2015-03-23"},{"$f":"F5-7","v":"2015-03-30"},{"$f":"G5-7","v":"2015-04-06"},"2015-04-13","2015-04-20","2015-04-27","2015-05-04","2015-05-11","2015-05-18","2015-05-25","2015-06-01","2015-06-08","2015-06-15",{"$f":"R5-7","v":"2015-06-22"},{"$f":"(TODAY()-WEEKDAY(TODAY(),3))-7","v":"2015-06-29"}]
[null,"Effectiveness",{"$f":"IFERROR(VLOOKUP($C$3,_CR1DP,MATCH(C$5,Dates,0),FALSE),C7)","v":0.01},0.03,0.06,0.09,0,0,0,0,0,0.95,7.0000000000000007E-2,0.55000000000000004,0,0,0,0]
[null,"Effectiveness Team Average",{"$f":"VLOOKUP($B$7,_CR1DP,MATCH(C$5,Dates,0),FALSE)","v":0.01},0.03,0.06,0.09,0,0,0,0,0,0.95,7.0000000000000007E-2,0.55000000000000004,0,0,0,0]
[null,"Efficiency",{"$f":"IFERROR(VLOOKUP($C$3,_CR1DE,MATCH(C$5,Dates,0),FALSE),C9)","v":0.25},0.35,0.65,1,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Efficiency Team Average",{"$f":"VLOOKUP($B$9,_CR1DE,MATCH(C$5,Dates,0),FALSE)","v":0.25},0.35,0.65,1,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Target Productivity",1.05,1.05,1.05,1.05,1.05,1.05,1.05,1.05,1.05,1.05,1.05,1.05,1.05,1.05,1.05,1.05]
[null,null,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95,0.95]
[null,null,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75,0.75]

{"sheet":"CR1 Data Productivity","index":1,"n_rows":11,"n_cols":65,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,34,0,37],[0,39,0,42],[0,50,0,53],[0,55,0,59],[0,61,0,64],[0,2,0,5],[0,7,0,10],[0,12,0,16],[0,18,0,21],[0,23,0,26],[0,28,0,32],[0,44,0,48]]}
["Name","January","Week Commencing",null,null,null,"February","Week Commencing",null,null,null,"March","Week Commencing",null,null,null,null,"April","Week Commencing",null,null,null,"May","Week Commencing",null,null,null,"June","Week Commencing",null,null,null,null,"July","Week Commencing",null,null,null,"August","Week Commencing",null,null,null,"September","Week Commencing",null,null,null,null,"October","Week Commencing",null,null,null,"November","Week Commencing",null,null,null,null,"December","Week Commencing"]
[null,null,"2015-01-05","2015-01-12","2015-01-19","2015-01-26",null,"2015-02-02","2015-02-09","2015-02-16","2015-02-23",null,"2015-03-02","2015-03-09","2015-03-16","2015-03-23","2015-03-30",null,"2015-04-06","2015-04-13","2015-04-20","2015-04-27",null,"2015-05-04","2015-05-11","2015-05-18","2015-05-25",null,"2015-06-01","2015-06-08","2015-06-15","2015-06-22","2015-06-29",null,"2015-07-06","2015-07-13","2015-07-20","2015-07-27",null,"2015-08-03","2015-08-10","2015-08-17","2015-08-24",null,"2015-09-01","2015-09-07","2015-09-14","2015-09-21","2015-09-28",null,"2015-10-05","2015-10-12","2015-10-19","2015-10-26",null,"2015-11-02","2015-11-09","2015-11-16","2015-11-23","2015-11-30",null,"2015-12-07","2015-12-14","2015-12-21","2015-12-28"]
["Effectiveness Team Average",null,null,null,null,null,null,null,null,null,null,null,0.01,0.03,0.06,0.08,0.09,null,null,null,null,null,null,0.95,7.0000000000000007E-2,0.68,0.55000000000000004]
["Shane 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,0.06,0.12,0.3]
["Shane 2"]
["Shane 3"]
["Shane 4"]
["Shane 5"]
["Shane 6"]
["Shane 7"]
["Shane 8"]

{"sheet":"CR1 Data Efficiency","index":2,"n_rows":11,"n_cols":65,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,23,0,26],[0,0,1,0],[0,2,0,5],[0,7,0,10],[0,12,0,16],[0,18,0,21],[0,61,0,64],[0,28,0,32],[0,34,0,37],[0,39,0,42],[0,44,0,48],[0,50,0,53],[0,55,0,59]]}
["Name","January","Week Commencing",null,null,null,"February","Week Commencing",null,null,null,"March","Week Commencing",null,null,null,null,"April","Week Commencing",null,null,null,"May","Week Commencing",null,null,null,"June","Week Commencing",null,null,null,null,"July","Week Commencing",null,null,null,"August","Week Commencing",null,null,null,"September","Week Commencing",null,null,null,null,"October","Week Commencing",null,null,null,"November","Week Commencing",null,null,null,null,"December","Week Commencing"]
[null,null,"2015-01-05","2015-01-12","2015-01-19","2015-01-26",null,"2015-02-02","2015-02-09","2015-02-16","2015-02-23",null,"2015-03-02","2015-03-09","2015-03-16","2015-03-23","2015-03-30",null,"2015-04-06","2015-04-13","2015-04-20","2015-04-27",null,"2015-05-04","2015-05-11","2015-05-18","2015-05-25",null,"2015-06-01","2015-06-08","2015-06-15","2015-06-22","2015-06-29",null,"2015-07-06","2015-07-13","2015-07-20","2015-07-27",null,"2015-08-03","2015-08-10","2015-08-17","2015-08-24",null,"2015-09-01","2015-09-07","2015-09-14","2015-09-21","2015-09-28",null,"2015-10-05","2015-10-12","2015-10-19","2015-10-26",null,"2015-11-02","2015-11-09","2015-11-16","2015-11-23","2015-11-30",null,"2015-12-07","2015-12-14","2015-12-21","2015-12-28"]
["Efficiency Team Average",null,null,null,null,null,null,null,null,null,null,null,0.25,0.35,0.65,0.89,1]
["Shane 1"]
["Shane 2"]
["Shane 3"]
["Shane 4"]
["Shane 5"]
["Shane 6"]
["Shane 7"]
["Shane 8"]