{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Cover","Table of Contens","Top-down Prg. Status","Bottom-up Prg. Status","Timesheet raw data","Estimate to complete","Rolling plan","Traffic Light report","Scoreboard Risiken u. Chancen","Erläuterung Risiken+Chancen","Detailbewertung Risiken","Detailbewertung Chancen"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":81,"comments":3,"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":"Cover","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["cover"]
[null,null,"Handbook of Program Feedback Loops"]
[null,null,"Program:",{"$f":"Cover.ProgramName","v":"DEMO"},null,null,"v.0.9.Demo",null,null,"Select language"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Program name",null,"DEMO"]
[null,null,null,"Program No.",null,"123456"]
[]
[null,null,null,"Program Sponsor",null,"<Customer Sponsor>"]
[]
[null,null,null,"Program Manager",null,"<Program Manager>"]
[]
[null,null,null,"Customer",null,"<Customer>"]
[]
[null,null,null,"Approval Date",null,"2012-10-21"]
[]
[null,null,null,"Complexity",null,"<Complexity>"]
[null,null,null,"Category",null,"<Category>"]
[null,null,null,"Size",null,"<Size>"]
[]
[null,null,null,"Status",null,"<Status>"]
[null,null,null,"Date of status",null,"<Date of Status>"]
[null,null,null,"Approval date of status",null,"<Approval date of status>"]
[]
[]
[null,null,"©2012 by Gottfried Rudorfer, demonstration-version of the Handbook of Program Feedback Loops."]

{"sheet":"Table of Contens","index":1,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[27,3,27,6],[18,4,20,5],[21,3,21,6],[23,3,23,6],[24,3,24,6],[25,3,25,6]]}
["toc"]
[null,null,"Table of contents"]
[null,null,"Program:",{"$f":"Cover.ProgramName","v":"DEMO"}]
[null,null,"Method","Sheet","Requ. for\nprogram?","Seclection","Print"]
[null,1,"Cover","Cover","R","x","x"]
[null,2,"Table of Contens","Table of Contens","R","x","x"]
[null,3,"Top-down Prg. Status","Top-down Prg. Status","R","x","x"]
[null,4,"Bottom-up Prg. Status","Bottom-up Prg. Status","R","x","x"]
[null,5,"Timesheet raw data","Timesheet raw data","R","x","-"]
[null,6,"Estimate to complete","Estimate to complete","R","x","x"]
[null,7,"Rolling plan","Rolling plan","R","x","x"]
[null,8,"Traffic Light report","Traffic Light report","R","x","x"]
[null,9,"Scoreboard Risiken und Changen",null,"R","x","x"]
[null,10,"Erläuterung Risiken + Chancen",null,"R","x","x"]
[null,11,"Detailbewertung Risiken",null,"R","x","x"]
[null,12,"Detailbewertung Chancen",null,"R","x","x"]
[]
[]
[null,null,null,null,"R: Required\nO: Optional\n-: not applicable"]
[]
[]
[]
[null,null,"Other references"]
[null,1,"Homepage Gottfried Rudorfer","http://rudorfer.homedns.org"]
[null,2,"Homepage CA Technologies","http://www.ca.com"]
[null,3]

{"sheet":"Top-down Prg. Status","index":2,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[[8,1,17,1],[30,1,39,1],[4,4,4,5]]}
["topdownpgs"]
[null,"Top-down Program Status"]
[null,null,"Program:",{"$f":"Cover.ProgramName","v":"DEMO"}]
[null,"CUSTOMER \"DEMO\" IMPLEMENTATION PROGRAM"]
[null,null,null,"PROGRAM STATUS DATE: ",{"$f":"MAX('Timesheet raw data'!C:C)","v":"2011-12-16"},null,null,"Update Top down status weekly!"]
[]
[null,null,null,"Draft Planning as of Sept 2011",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Software","Project",null,"2011-09-01","2011-10-01","2011-11-01","2011-12-01","2012-01-01","2012-02-01","2012-03-01","2012-04-01","2012-05-01","2012-06-01","2012-07-01","2012-08-01","2012-09-01","2012-10-01","2012-11-01","2012-12-01",null,"Days"]
[null,"CA Service Desk Manager based","Tenant1","Incident Management",10,20,20,20,20,20,10,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(E9:U9)","v":120}]
[null,null,"Tenant2","Incident Management",0,5,15,15,15,15,15,15,5,0,0,0,0,0,0,0,null,{"$f":"SUM(E10:U10)","v":100}]
[null,null,"SaaS Env","Interfaces",0,0,10.177586772134465,20,20,10,5,5,5,5,5,5,5,5,null,0,null,100.17758677213446]
[null,null,"SaaS Env","Reporting",0,0,0,10,20,20,20,20,10,0,0,0,0,0,0,0,null,100]
[null,null,"Tenant1","Problem Management",0,0,0,5.2912225339421397,20,20,20,10,0,0,0,0,0,0,0,0,null,75.291222533942147]
[null,null,"Tenant2","Problem Management",0,0,0,0,5,20,20,20,20,15,10,0,0,0,0,0,null,110]
[null,null,"Tenant2","Change Management",0,0,0,0,11.038037188157411,19.394359447426989,30.208378871313215,29.332978651785247,33.423457603659692,32.494826173495433,0,0,0,0,0,0,null,155.89203793583798]
[null,null,"Tenant3","Incident Management",0,0,0,0,9.9140442932714841,12,10,11.640918885546387,10,20,20,20,15,10,0,0,null,138.55496317881787]
[null,null,"Tenant3","Change Management",0,0,0,0,0,0,0,0,0,0,15,20,20,20,20,10,null,105]
[null,null,"Tenant3","CMDB",0,0,0,0,15,20,25,25,20,20,20,10,0,0,0,0,null,155]
[null,null,"Tenant 4","Incident Management",0,0,0,0,0,0,10,20,20,20,20,20,10,0,0,0,null,120]
[null,null,"Tenant 4","Problem Management",0,0,0,0,0,0,0,5,15,15,15,15,15,15,5,0,null,100]
[null,null,"Tenant 5","Incident Management",0,0,0,0,0,0,0,0,10,20,20,20,20,20,5,5,null,120]
[null,null,null,"Planned Total days",{"$f":"SUM(E9:E21)","v":10},{"$f":"SUM(F9:F21)","v":25},{"$f":"SUM(G9:G21)","v":45.177586772134461},70.291222533942147,135.95208148142888,156.39435944742701,165.20837887131322,160.97389753733165,148.4234576036597,147.49482617349543,125,110,85,70,30,15,{"$f":"SUM(U9:U18)","v":0},{"$f":"SUM(V9:V21)","v":1499.9158104207324}]
[null,null,null,"Planned Accumulated days",{"$f":"E22","v":10},{"$f":"E23+F22","v":35},80.177586772134461,150.46880930607659,286.42089078750547,442.81525023493248,608.02362910624572,768.99752664357743,917.42098424723713,1064.9158104207327,{"$f":"N23+O22","v":1189.9158104207327},{"$f":"O23+P22","v":1299.9158104207327},{"$f":"P23+Q22","v":1384.9158104207327},{"$f":"Q23+R22","v":1454.9158104207327},{"$f":"R23+S22","v":1484.9158104207327},{"$f":"S23+T22","v":1499.9158104207327},{"$f":"SUM(U10:U18)","v":0}]
[null,null,null,"Planned avg. heads",{"$f":"E22/20","v":0.5},1.25,2.258879338606723,3.5145611266971075,6.7976040740714438,7.8197179723713504,8.2604189435656608,8.0486948768665822,7.4211728801829846,7.3747413086747713,{"$f":"O22/20","v":6.25},5.5,4.25,{"$f":"R22/20","v":3.5},1.5,0.75]
[]
[null,null,null,{"$f":"\"Actuals until \" & YEAR(E5) & \"-\" & MONTH(E5)  & \" and Estimates stated in SOWs\"","v":"Actuals until 2011-12 and Estimates stated in SOWs"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Software","Project",null,"2011-09-01","2011-10-01","2011-11-01","2011-12-01","2012-01-01","2012-02-01","2012-03-01","2012-04-01","2012-05-01","2012-06-01","2012-07-01","2012-08-01","2012-09-01","2012-10-01","2012-11-01","2012-12-01",null,"Days"]
[null,null,null,"Actual avg. Heads",{"$f":"E30/20","v":0.28749999999999998},2.2875000000000001,3.0078125,1.465625,6.2976040740714447,7.3197179723713504,7.7604189435656608,8.0486948768665822,7.4211728801829846,7.3747413086747713,{"$f":"O30/20","v":6.25},5.5,4.25,{"$f":"R30/20","v":3.5},1.5,0.75]
[null,null,null,"Actual Accumulated days",{"$f":"E30","v":5.75},{"$f":"E29+F30","v":51.5},111.65625,140.96875,266.92083148142888,413.31519092885588,568.52356980016907,729.49746733750067,877.92092494116037,1025.4157511146559,{"$f":"N29+O30","v":1150.4157511146559},{"$f":"O29+P30","v":1260.4157511146559},{"$f":"P29+Q30","v":1345.4157511146559},{"$f":"Q29+R30","v":1415.4157511146559},{"$f":"R29+S30","v":1445.4157511146559},{"$f":"S29+T30","v":1460.4157511146559},{"$f":"SUM(U14:U25)","v":0}]
[null,null,null,"Actual Total days",{"$f":"SUM(E31:E43)","v":5.75},{"$f":"SUM(F31:F43)","v":45.75},{"$f":"SUM(G31:G43)","v":60.15625},{"$f":"SUM(H31:H43)","v":29.3125},{"$f":"SUM(I31:I43)","v":125.95208148142889},146.39435944742701,155.20837887131322,160.97389753733165,148.4234576036597,147.49482617349543,125,110,85,70,30,15,{"$f":"SUM(U15:U25)","v":0},{"$f":"SUM(E30:T30)","v":1460.4157511146559}]
[null,"CA Service Desk Manager based","Tenant1","Incident Management",{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C31& \" \" & $D31&\"-\"&TEXT(YEAR(E$27),\"0000\")&\"-\"&TEXT(MONTH(E$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":2.75},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C31& \" \" & $D31&\"-\"&TEXT(YEAR(F$27),\"0000\")&\"-\"&TEXT(MONTH(F$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":45.75},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C31& \" \" & $D31&\"-\"&TEXT(YEAR(G$27),\"0000\")&\"-\"&TEXT(MONTH(G$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":37.90625},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C31& \" \" & $D31&\"-\"&TEXT(YEAR(H$27),\"0000\")&\"-\"&TEXT(MONTH(H$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":20.0625},10,10,0,{"$f":"L9","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(E31:U31)","v":126.46875}]
[null,null,"Tenant2","Incident Management",{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C32& \" \" & $D32&\"-\"&TEXT(YEAR(E$27),\"0000\")&\"-\"&TEXT(MONTH(E$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":3},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C32& \" \" & $D32&\"-\"&TEXT(YEAR(F$27),\"0000\")&\"-\"&TEXT(MONTH(F$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C32& \" \" & $D32&\"-\"&TEXT(YEAR(G$27),\"0000\")&\"-\"&TEXT(MONTH(G$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":22.25},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C32& \" \" & $D32&\"-\"&TEXT(YEAR(H$27),\"0000\")&\"-\"&TEXT(MONTH(H$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":9.25},{"$f":"I10","v":15},15,15,15,5,0,0,0,0,0,0,0,null,{"$f":"SUM(E32:U32)","v":99.5}]
[null,null,"SaaS Env","Interfaces",{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C33& \" \" & $D33&\"-\"&TEXT(YEAR(E$27),\"0000\")&\"-\"&TEXT(MONTH(E$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C33& \" \" & $D33&\"-\"&TEXT(YEAR(F$27),\"0000\")&\"-\"&TEXT(MONTH(F$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C33& \" \" & $D33&\"-\"&TEXT(YEAR(G$27),\"0000\")&\"-\"&TEXT(MONTH(G$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C33& \" \" & $D33&\"-\"&TEXT(YEAR(H$27),\"0000\")&\"-\"&TEXT(MONTH(H$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"I11","v":20},10,5,5,5,5,5,5,5,5,0,0,null,70]
[null,null,"SaaS Env","Reporting",{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C34& \" \" & $D34&\"-\"&TEXT(YEAR(E$27),\"0000\")&\"-\"&TEXT(MONTH(E$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C34& \" \" & $D34&\"-\"&TEXT(YEAR(F$27),\"0000\")&\"-\"&TEXT(MONTH(F$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C34& \" \" & $D34&\"-\"&TEXT(YEAR(G$27),\"0000\")&\"-\"&TEXT(MONTH(G$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C34& \" \" & $D34&\"-\"&TEXT(YEAR(H$27),\"0000\")&\"-\"&TEXT(MONTH(H$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"I12","v":20},20,20,20,10,0,0,0,0,0,0,0,null,90]
[null,null,"Tenant1","Problem Management",{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C35& \" \" & $D35&\"-\"&TEXT(YEAR(E$27),\"0000\")&\"-\"&TEXT(MONTH(E$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C35& \" \" & $D35&\"-\"&TEXT(YEAR(F$27),\"0000\")&\"-\"&TEXT(MONTH(F$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C35& \" \" & $D35&\"-\"&TEXT(YEAR(G$27),\"0000\")&\"-\"&TEXT(MONTH(G$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C35& \" \" & $D35&\"-\"&TEXT(YEAR(H$27),\"0000\")&\"-\"&TEXT(MONTH(H$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"I13","v":20},20,20,10,0,0,0,0,0,0,0,0,null,70]
[null,null,"Tenant2","Problem Management",{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C36& \" \" & $D36&\"-\"&TEXT(YEAR(E$27),\"0000\")&\"-\"&TEXT(MONTH(E$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C36& \" \" & $D36&\"-\"&TEXT(YEAR(F$27),\"0000\")&\"-\"&TEXT(MONTH(F$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C36& \" \" & $D36&\"-\"&TEXT(YEAR(G$27),\"0000\")&\"-\"&TEXT(MONTH(G$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C36& \" \" & $D36&\"-\"&TEXT(YEAR(H$27),\"0000\")&\"-\"&TEXT(MONTH(H$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"I14","v":5},20,20,20,20,15,10,0,0,0,0,0,null,110]
[null,null,"Tenant2","Change Management",{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C37& \" \" & $D37&\"-\"&TEXT(YEAR(E$27),\"0000\")&\"-\"&TEXT(MONTH(E$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C37& \" \" & $D37&\"-\"&TEXT(YEAR(F$27),\"0000\")&\"-\"&TEXT(MONTH(F$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C37& \" \" & $D37&\"-\"&TEXT(YEAR(G$27),\"0000\")&\"-\"&TEXT(MONTH(G$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C37& \" \" & $D37&\"-\"&TEXT(YEAR(H$27),\"0000\")&\"-\"&TEXT(MONTH(H$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"I15","v":11.038037188157411},19.394359447426989,30.208378871313215,29.332978651785247,33.423457603659692,32.494826173495433,0,0,0,0,0,0,null,155.89203793583798]
[null,null,"Tenant3","Incident Management",{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C38& \" \" & $D38&\"-\"&TEXT(YEAR(E$27),\"0000\")&\"-\"&TEXT(MONTH(E$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C38& \" \" & $D38&\"-\"&TEXT(YEAR(F$27),\"0000\")&\"-\"&TEXT(MONTH(F$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C38& \" \" & $D38&\"-\"&TEXT(YEAR(G$27),\"0000\")&\"-\"&TEXT(MONTH(G$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C38& \" \" & $D38&\"-\"&TEXT(YEAR(H$27),\"0000\")&\"-\"&TEXT(MONTH(H$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"I16","v":9.9140442932714841},12,10,11.640918885546387,10,20,20,20,15,10,0,0,null,138.55496317881787]
[null,null,"Tenant3","Change Management",{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C39& \" \" & $D39&\"-\"&TEXT(YEAR(E$27),\"0000\")&\"-\"&TEXT(MONTH(E$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C39& \" \" & $D39&\"-\"&TEXT(YEAR(F$27),\"0000\")&\"-\"&TEXT(MONTH(F$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C39& \" \" & $D39&\"-\"&TEXT(YEAR(G$27),\"0000\")&\"-\"&TEXT(MONTH(G$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C39& \" \" & $D39&\"-\"&TEXT(YEAR(H$27),\"0000\")&\"-\"&TEXT(MONTH(H$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"I17","v":0},0,0,0,0,0,15,20,20,20,20,10,null,105]
[null,null,"Tenant3","CMDB",{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C40& \" \" & $D40&\"-\"&TEXT(YEAR(E$27),\"0000\")&\"-\"&TEXT(MONTH(E$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C40& \" \" & $D40&\"-\"&TEXT(YEAR(F$27),\"0000\")&\"-\"&TEXT(MONTH(F$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C40& \" \" & $D40&\"-\"&TEXT(YEAR(G$27),\"0000\")&\"-\"&TEXT(MONTH(G$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C40& \" \" & $D40&\"-\"&TEXT(YEAR(H$27),\"0000\")&\"-\"&TEXT(MONTH(H$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"I18","v":15},20,25,25,20,20,20,10,0,0,0,0,null,155]
[null,null,"Tenant 4","Incident Management",{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C41& \" \" & $D41&\"-\"&TEXT(YEAR(E$27),\"0000\")&\"-\"&TEXT(MONTH(E$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C41& \" \" & $D41&\"-\"&TEXT(YEAR(F$27),\"0000\")&\"-\"&TEXT(MONTH(F$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C41& \" \" & $D41&\"-\"&TEXT(YEAR(G$27),\"0000\")&\"-\"&TEXT(MONTH(G$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C41& \" \" & $D41&\"-\"&TEXT(YEAR(H$27),\"0000\")&\"-\"&TEXT(MONTH(H$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"I19","v":0},0,10,20,20,20,20,20,10,0,0,0,null,120]
[null,null,"Tenant 4","Incident Management",{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C42& \" \" & $D42&\"-\"&TEXT(YEAR(E$27),\"0000\")&\"-\"&TEXT(MONTH(E$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C42& \" \" & $D42&\"-\"&TEXT(YEAR(F$27),\"0000\")&\"-\"&TEXT(MONTH(F$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C42& \" \" & $D42&\"-\"&TEXT(YEAR(G$27),\"0000\")&\"-\"&TEXT(MONTH(G$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C42& \" \" & $D42&\"-\"&TEXT(YEAR(H$27),\"0000\")&\"-\"&TEXT(MONTH(H$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"I20","v":0},0,0,5,15,15,15,15,15,15,5,0,null,100]
[null,null,"Tenant 5","Incident Management",{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C43& \" \" & $D43&\"-\"&TEXT(YEAR(E$27),\"0000\")&\"-\"&TEXT(MONTH(E$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C43& \" \" & $D43&\"-\"&TEXT(YEAR(F$27),\"0000\")&\"-\"&TEXT(MONTH(F$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C43& \" \" & $D43&\"-\"&TEXT(YEAR(G$27),\"0000\")&\"-\"&TEXT(MONTH(G$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"SUMIF('Timesheet raw data'!$K:$K,$C43& \" \" & $D43&\"-\"&TEXT(YEAR(H$27),\"0000\")&\"-\"&TEXT(MONTH(H$27),\"00\"),'Timesheet raw data'!$E:$E)/8","v":0},{"$f":"I21","v":0},0,0,0,10,20,20,20,20,20,5,5,null,120]

{"sheet":"Bottom-up Prg. Status","index":3,"n_rows":79,"n_cols":13,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
["TandMstatus"]
[null,"Bottom-up Program Status"]
[null,"Program:",{"$f":"Cover.ProgramName","v":"DEMO"}]
[null,"CUSTOMER \"DEMO\" IMPLEMENTATION PROGRAM"]
[null,"PROGRAM STATUS DATE: ",{"$f":"MAX('Timesheet raw data'!C:C)","v":"2011-12-16"},null,"Update T&M status weekly!"]
[]
[null,"PROGRAM WORK PER RESOURCE NAME"]
[null,"Resource Name","Worked hours","Rate per hour","Role"]
[null,"Offshore Consultant1",{"$f":"SUMIF('Timesheet raw data'!B:B,B9,'Timesheet raw data'!E:E)","v":146},{"$f":"VLOOKUP(E9,$B$37:$I$44,2,FALSE)","v":65},"Offshore Consultant"]
[null,"Associate Consultant1",{"$f":"SUMIF('Timesheet raw data'!B:B,B10,'Timesheet raw data'!E:E)","v":0},75,"Associate Consultant"]
[null,"Sr Consultant1",{"$f":"SUMIF('Timesheet raw data'!B:B,B11,'Timesheet raw data'!E:E)","v":55},90,"Sr Consultant"]
[null,"Sr Consultant2",{"$f":"SUMIF('Timesheet raw data'!B:B,B12,'Timesheet raw data'!E:E)","v":12},90,"Sr Consultant"]
[null,"Architect1",{"$f":"SUMIF('Timesheet raw data'!B:B,B13,'Timesheet raw data'!E:E)","v":6},96,"Architect"]
[null,"Project Manager1",{"$f":"SUMIF('Timesheet raw data'!B:B,B14,'Timesheet raw data'!E:E)","v":74},100,"Project Manager"]
[null,"Associate Consultant2",{"$f":"SUMIF('Timesheet raw data'!B:B,B15,'Timesheet raw data'!E:E)","v":41.5},75,"Associate Consultant"]
[null,"Architect2",{"$f":"SUMIF('Timesheet raw data'!B:B,B16,'Timesheet raw data'!E:E)","v":71},96,"Architect"]
[null,"Sr Consultant3",{"$f":"SUMIF('Timesheet raw data'!B:B,B17,'Timesheet raw data'!E:E)","v":0},90,"Sr Consultant"]
[null,"Offshore Consultant2",{"$f":"SUMIF('Timesheet raw data'!B:B,B18,'Timesheet raw data'!E:E)","v":120},65,"Offshore Consultant"]
[null,"Offshore Consultant3",{"$f":"SUMIF('Timesheet raw data'!B:B,B19,'Timesheet raw data'!E:E)","v":0},65,"Offshore Consultant"]
[null,"Sr Consultant4",{"$f":"SUMIF('Timesheet raw data'!B:B,B20,'Timesheet raw data'!E:E)","v":340},90,"Sr Consultant"]
[null,"Architect3",{"$f":"SUMIF('Timesheet raw data'!B:B,B21,'Timesheet raw data'!E:E)","v":262.25},96,"Architect"]
[]
[null,"Checksum over Roles",{"$f":"SUM(C9:C21)","v":1127.75},"hours"]
[null,"Checksum over Projects",{"$f":"C49+C64","v":1127.75},"hours"]
[]
[null,"PROGRAM WORK  PER ROLE"]
[null,null,"Actual\nhrs.","Avail. \nDays","Avail. \nhrs.","Total hrs. SOW","Base\nhrs.","CR hrs."]
[null,"Sum",{"$f":"SUM(C29:C34)","v":1127.75},{"$f":"E28/8","v":1359.03125},{"$f":"SUM(E29:E34)","v":10872.25},{"$f":"SUM(F29:F34)","v":12000},{"$f":"SUM(G29:G34)","v":12300},{"$f":"SUM(H29:H34)","v":0}]
[null,"Sr Consultant",{"$f":"SUMIF($E$9:$E$21,B29,$C$9:$C$21)","v":407},{"$f":"E29/8","v":306.125},{"$f":"F29-C29","v":2449},2856,3000,0]
[null,"Architect",{"$f":"SUMIF($E$9:$E$21,B30,$C$9:$C$21)","v":339.25},312.59375,{"$f":"F30-C30","v":2500.75},2840,3000,0]
[null,"Offshore Consultant",266,216.75,1734,{"$f":"G31+H31","v":2000},2000,0]
[null,"Associate Consultant",41.5,182.3125,1458.5,1500,1500,0]
[null,"Consultant",0,100.5,804,804,800,0]
[null,"Project Manager",74,240.75,1926,2000,2000,0]
[]
[null,"PROGRAM FINANCIALS PER ROLE",null,null,null,null,null,null,null,"Program \nRevenue",{"$f":"SUM(K37:K43)","v":97000.5},"Month"]
[null,null,null,"Actual","Avail",null,"Total SOW","Base","CR","Month",null,"2012-03-01",{"$f":"SUMIF($J$47:$J$911,L37,$K$47:$K$911)","v":0}]
[null,"Sum","Hrl. Rate",{"$f":"SUM(D39:D44)","v":97000.5},{"$f":"G38-D38","v":967499.5},null,{"$f":"SUM(G39:G44)","v":1064500},{"$f":"SUM(H39:H44)","v":1064500},{"$f":"SUM(I39:I44)","v":0},"2011-09-01",{"$f":"SUMIF($J$47:$J$911,J38,$K$47:$K$911)","v":4464},"2012-04-01",0]
[null,"Sr Consultant",90,{"$f":"$C39*C29","v":36630},{"$f":"G39-D39","v":233370},null,{"$f":"H39+I39","v":270000},{"$f":"$C39*G29","v":270000},0,"2011-10-01",31193,"2012-05-01",0]
[null,"Architect",96,32568,255432,null,{"$f":"H40+I40","v":288000},288000,0,"2011-11-01",40903.5,"2012-06-01",0]
[null,"Offshore Consultant",65,17290,112710,null,{"$f":"H41+I41","v":130000},130000,0,"2011-12-01",20440,"2012-07-01",0]
[null,"Associate Consultant",75,3112.5,109387.5,null,{"$f":"H42+I42","v":112500},112500,0,"2012-01-01",0,"2012-08-01",0]
[null,"Consultant",80,0,64000,null,64000,64000,0,"2012-02-01",0,"2012-09-01",0]
[null,"Project Manager",100,7400,192600,null,200000,200000,0]
[]
[null,"PROJECTS"]
[null,"Project TM1","Tenant1 Incident Management",null,null,null,null,null,null,"Project revenue",{"$f":"SUM(K48:K60)+SUM(M48:M60)","v":70874.5},"Month"]
[null,null,"Actual\nhrs.","Avail. \nDays","Avail. \nhrs.","Total hrs.\nSOW","Base\nhrs.","CR hrs.","CV","Month",null,"2012-03-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$47&\"-\"&TEXT(YEAR(L48),\"0000\")&\"-\"&TEXT(MONTH(L48),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[null,"Sum",{"$f":"SUM(C50:C54)","v":851.75},{"$f":"E49/8","v":24.78125},{"$f":"SUM(E50:E54)","v":198.25},{"$f":"SUM(F50:F54)","v":1050},{"$f":"SUM(G50:G54)","v":960},{"$f":"SUM(H50:H54)","v":90},{"$f":"SUM(I50:I54)","v":90058},"2011-09-01",{"$f":"SUMIF('Timesheet raw data'!K:K,$C$47&\"-\"&TEXT(YEAR(J49),\"0000\")&\"-\"&TEXT(MONTH(J49),\"00\"),'Timesheet raw data'!G:G)","v":2160}]
[null,"Sr Consultant",{"$f":"SUMIF('Timesheet raw data'!J:J,C$47&B50,'Timesheet raw data'!E:E)","v":334},{"$f":"E50/8","v":7.25},{"$f":"F50-C50","v":58},{"$f":"G50+H50","v":392},{"$f":"45*8","v":360},32,{"$f":"F50*C39","v":35280},null,null,"2012-04-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$47&\"-\"&TEXT(YEAR(L50),\"0000\")&\"-\"&TEXT(MONTH(L50),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[null,"Architect",{"$f":"SUMIF('Timesheet raw data'!J:J,C$47&B51,'Timesheet raw data'!E:E)","v":153.25},1.84375,14.75,{"$f":"G51+H51","v":168},{"$f":"20*8","v":160},8,{"$f":"F51*C40","v":16128},"2011-10-01",{"$f":"SUMIF('Timesheet raw data'!K:K,$C$47&\"-\"&TEXT(YEAR(J51),\"0000\")&\"-\"&TEXT(MONTH(J51),\"00\"),'Timesheet raw data'!G:G)","v":31193}]
[null,"Offshore Consultant",{"$f":"SUMIF('Timesheet raw data'!J:J,C$47&B52,'Timesheet raw data'!E:E)","v":266},-7,-56,210,{"$f":"20*8","v":160},50,{"$f":"F52*C41","v":13650},null,null,"2012-05-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$47&\"-\"&TEXT(YEAR(L52),\"0000\")&\"-\"&TEXT(MONTH(L52),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[null,"Associate Consultant",{"$f":"SUMIF('Timesheet raw data'!J:J,C$47&B53,'Timesheet raw data'!E:E)","v":41.5},9.8125,78.5,120,{"$f":"15*8","v":120},0,{"$f":"F53*C42","v":9000},"2011-11-01",{"$f":"SUMIF('Timesheet raw data'!K:K,$C$47&\"-\"&TEXT(YEAR(J53),\"0000\")&\"-\"&TEXT(MONTH(J53),\"00\"),'Timesheet raw data'!G:G)","v":24125.5}]
[null,"Project Manager",{"$f":"SUMIF('Timesheet raw data'!J:J,C$47&B54,'Timesheet raw data'!E:E)","v":57},12.875,103,160,{"$f":"20*8","v":160},0,{"$f":"F54*C44","v":16000},null,null,"2012-06-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$47&\"-\"&TEXT(YEAR(L54),\"0000\")&\"-\"&TEXT(MONTH(L54),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[null,null,null,null,null,null,null,null,null,"2011-12-01",{"$f":"SUMIF('Timesheet raw data'!K:K,$C$47&\"-\"&TEXT(YEAR(J55),\"0000\")&\"-\"&TEXT(MONTH(J55),\"00\"),'Timesheet raw data'!G:G)","v":13396}]
[null,null,null,null,null,null,null,null,null,null,null,"2012-07-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$47&\"-\"&TEXT(YEAR(L56),\"0000\")&\"-\"&TEXT(MONTH(L56),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[null,null,null,null,null,null,null,null,null,"2012-01-01",{"$f":"SUMIF('Timesheet raw data'!K:K,$C$47&\"-\"&TEXT(YEAR(J57),\"0000\")&\"-\"&TEXT(MONTH(J57),\"00\"),'Timesheet raw data'!G:G)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"2012-08-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$47&\"-\"&TEXT(YEAR(L58),\"0000\")&\"-\"&TEXT(MONTH(L58),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[null,null,null,null,null,null,null,null,null,"2012-02-01",{"$f":"SUMIF('Timesheet raw data'!K:K,$C$47&\"-\"&TEXT(YEAR(J59),\"0000\")&\"-\"&TEXT(MONTH(J59),\"00\"),'Timesheet raw data'!G:G)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"2012-09-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$47&\"-\"&TEXT(YEAR(L60),\"0000\")&\"-\"&TEXT(MONTH(L60),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[]
[null,"Project TM2","Tenant2 Incident Management",null,null,null,null,null,null,"Project revenue",{"$f":"SUM(K63:K75)+SUM(M63:M75)","v":26126},"Month"]
[null,null,"Actual\nhours","Avail. \nDays","Avail. \nHrs.","Total SOW","Base","CR",null,"Month",null,"2012-03-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$62&\"-\"&TEXT(YEAR(L63),\"0000\")&\"-\"&TEXT(MONTH(L63),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[null,"Sum",{"$f":"SUM(C65:C69)","v":276},{"$f":"E64/8","v":65.5},{"$f":"SUM(E65:E69)","v":524},{"$f":"SUM(F65:F69)","v":800},{"$f":"SUM(G65:G69)","v":800},{"$f":"SUM(H65:H69)","v":0},{"$f":"SUM(I65:I69)","v":72160},"2011-09-01",{"$f":"SUMIF('Timesheet raw data'!K:K,$C$62&\"-\"&TEXT(YEAR(J64),\"0000\")&\"-\"&TEXT(MONTH(J64),\"00\"),'Timesheet raw data'!G:G)","v":2304}]
[null,"Sr Consultant",{"$f":"SUMIF('Timesheet raw data'!J:J,$C$62&B65,'Timesheet raw data'!E:E)","v":73},{"$f":"E65/8","v":30.875},{"$f":"F65-C65","v":247},{"$f":"G65+H65","v":320},{"$f":"40*8","v":320},0,{"$f":"F65*C39","v":28800},null,null,"2012-04-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$62&\"-\"&TEXT(YEAR(L65),\"0000\")&\"-\"&TEXT(MONTH(L65),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[null,"Architect",{"$f":"SUMIF('Timesheet raw data'!J:J,$C$62&B66,'Timesheet raw data'!E:E)","v":186},-3.25,-26,{"$f":"G66+H66","v":160},{"$f":"20*8","v":160},0,{"$f":"F66*C40","v":15360},"2011-10-01",{"$f":"SUMIF('Timesheet raw data'!K:K,$C$62&\"-\"&TEXT(YEAR(J66),\"0000\")&\"-\"&TEXT(MONTH(J66),\"00\"),'Timesheet raw data'!G:G)","v":0}]
[null,"Offshore Consultant",{"$f":"SUMIF('Timesheet raw data'!J:J,$C$62&B67,'Timesheet raw data'!E:E)","v":0},0,0,0,0,0,{"$f":"F67*C41","v":0},null,null,"2012-05-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$62&\"-\"&TEXT(YEAR(L67),\"0000\")&\"-\"&TEXT(MONTH(L67),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[null,"Associate Consultant",{"$f":"SUMIF('Timesheet raw data'!J:J,$C$62&B68,'Timesheet raw data'!E:E)","v":0},20,160,160,{"$f":"20*8","v":160},0,{"$f":"F68*C42","v":12000},"2011-11-01",{"$f":"SUMIF('Timesheet raw data'!K:K,$C$62&\"-\"&TEXT(YEAR(J68),\"0000\")&\"-\"&TEXT(MONTH(J68),\"00\"),'Timesheet raw data'!G:G)","v":16778}]
[null,"Project Manager",{"$f":"SUMIF('Timesheet raw data'!J:J,$C$62&B69,'Timesheet raw data'!E:E)","v":17},17.875,143,160,{"$f":"20*8","v":160},0,{"$f":"F69*C44","v":16000},null,null,"2012-06-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$62&\"-\"&TEXT(YEAR(L69),\"0000\")&\"-\"&TEXT(MONTH(L69),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[null,null,null,null,null,null,null,null,null,"2011-12-01",{"$f":"SUMIF('Timesheet raw data'!K:K,$C$62&\"-\"&TEXT(YEAR(J70),\"0000\")&\"-\"&TEXT(MONTH(J70),\"00\"),'Timesheet raw data'!G:G)","v":7044}]
[null,null,null,null,null,null,null,null,null,null,null,"2012-07-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$62&\"-\"&TEXT(YEAR(L71),\"0000\")&\"-\"&TEXT(MONTH(L71),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[null,null,null,null,null,null,null,null,null,"2012-01-01",{"$f":"SUMIF('Timesheet raw data'!K:K,$C$62&\"-\"&TEXT(YEAR(J72),\"0000\")&\"-\"&TEXT(MONTH(J72),\"00\"),'Timesheet raw data'!G:G)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"2012-08-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$62&\"-\"&TEXT(YEAR(L73),\"0000\")&\"-\"&TEXT(MONTH(L73),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[null,null,null,null,null,null,null,null,null,"2012-02-01",{"$f":"SUMIF('Timesheet raw data'!K:K,$C$62&\"-\"&TEXT(YEAR(J74),\"0000\")&\"-\"&TEXT(MONTH(J74),\"00\"),'Timesheet raw data'!G:G)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"2012-09-01",{"$f":"SUMIF('Timesheet raw data'!N:N,$C$62&\"-\"&TEXT(YEAR(L75),\"0000\")&\"-\"&TEXT(MONTH(L75),\"00\"),'Timesheet raw data'!I:I)","v":0}]
[]
[]
[]
[null,"Over time add below further projects here"]

{"sheet":"Timesheet raw data","index":4,"n_rows":307,"n_cols":11,"rows_kept":307,"cut":false,"hidden":false,"merged":[]}
["Timesheet"]
[null,null,"Timesheet raw data"]
[null,"Program:",{"$f":"Cover.ProgramName","v":"DEMO"}]
[null,"Enter timesheet data weekly!"]
[null,"Name","Date","Project","Hours","Month","BillAmt","Hrl Rate","Role","Hidden_Project+Role","Hidden_Project_Month"]
[null,"Architect2","2011-09-06","Tenant2 Incident Management",2,{"$f":"IF(C6<>\"\",TEXT(YEAR(C6),\"0000\")&\"-\"&TEXT(MONTH(C6),\"00\"),\"\")","v":"2011-09"},{"$f":"VLOOKUP(B6,Program.ResourceTable,3,FALSE)*E6","v":192},{"$f":"IF('Timesheet raw data'!E6>0,'Timesheet raw data'!G6/'Timesheet raw data'!E6,\"\")","v":96},{"$f":"IF(H6<>\"\",VLOOKUP(H6,Program.RateTable,2,FALSE),\"\")","v":"Architect"},{"$f":"'Timesheet raw data'!D6&I6","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D6<>\"\",'Timesheet raw data'!D6&\"-\"&'Timesheet raw data'!F6,\"\")","v":"Tenant2 Incident Management-2011-09"}]
[null,"Architect2","2011-09-06","Tenant2 Incident Management",4,{"$f":"IF(C7<>\"\",TEXT(YEAR(C7),\"0000\")&\"-\"&TEXT(MONTH(C7),\"00\"),\"\")","v":"2011-09"},384,{"$f":"IF('Timesheet raw data'!E7>0,'Timesheet raw data'!G7/'Timesheet raw data'!E7,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D7&I7","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D7<>\"\",'Timesheet raw data'!D7&\"-\"&'Timesheet raw data'!F7,\"\")","v":"Tenant2 Incident Management-2011-09"}]
[null,"Architect2","2011-09-07","Tenant2 Incident Management",2,"2011-09",192,{"$f":"IF('Timesheet raw data'!E8>0,'Timesheet raw data'!G8/'Timesheet raw data'!E8,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D8&I8","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D8<>\"\",'Timesheet raw data'!D8&\"-\"&'Timesheet raw data'!F8,\"\")","v":"Tenant2 Incident Management-2011-09"}]
[null,"Architect2","2011-09-09","Tenant2 Incident Management",2,"2011-09",192,{"$f":"IF('Timesheet raw data'!E9>0,'Timesheet raw data'!G9/'Timesheet raw data'!E9,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D9&I9","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D9<>\"\",'Timesheet raw data'!D9&\"-\"&'Timesheet raw data'!F9,\"\")","v":"Tenant2 Incident Management-2011-09"}]
[null,"Architect2","2011-09-12","Tenant2 Incident Management",2,"2011-09",192,{"$f":"IF('Timesheet raw data'!E10>0,'Timesheet raw data'!G10/'Timesheet raw data'!E10,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D10&I10","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D10<>\"\",'Timesheet raw data'!D10&\"-\"&'Timesheet raw data'!F10,\"\")","v":"Tenant2 Incident Management-2011-09"}]
[null,"Architect2","2011-09-13","Tenant1 Incident Management",2,"2011-09",192,{"$f":"IF('Timesheet raw data'!E11>0,'Timesheet raw data'!G11/'Timesheet raw data'!E11,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D11&I11","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D11<>\"\",'Timesheet raw data'!D11&\"-\"&'Timesheet raw data'!F11,\"\")","v":"Tenant1 Incident Management-2011-09"}]
[null,"Architect2","2011-09-13","Tenant2 Incident Management",2,"2011-09",192,{"$f":"IF('Timesheet raw data'!E12>0,'Timesheet raw data'!G12/'Timesheet raw data'!E12,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D12&I12","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D12<>\"\",'Timesheet raw data'!D12&\"-\"&'Timesheet raw data'!F12,\"\")","v":"Tenant2 Incident Management-2011-09"}]
[null,"Architect3","2011-09-13","Tenant2 Incident Management",6,"2011-09",576,{"$f":"IF('Timesheet raw data'!E13>0,'Timesheet raw data'!G13/'Timesheet raw data'!E13,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D13&I13","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D13<>\"\",'Timesheet raw data'!D13&\"-\"&'Timesheet raw data'!F13,\"\")","v":"Tenant2 Incident Management-2011-09"}]
[null,"Architect2","2011-09-14","Tenant1 Incident Management",4,"2011-09",384,{"$f":"IF('Timesheet raw data'!E14>0,'Timesheet raw data'!G14/'Timesheet raw data'!E14,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D14&I14","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D14<>\"\",'Timesheet raw data'!D14&\"-\"&'Timesheet raw data'!F14,\"\")","v":"Tenant1 Incident Management-2011-09"}]
[null,"Architect2","2011-09-14","Tenant2 Incident Management",2,"2011-09",192,{"$f":"IF('Timesheet raw data'!E15>0,'Timesheet raw data'!G15/'Timesheet raw data'!E15,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D15&I15","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D15<>\"\",'Timesheet raw data'!D15&\"-\"&'Timesheet raw data'!F15,\"\")","v":"Tenant2 Incident Management-2011-09"}]
[null,"Architect3","2011-09-14","Tenant2 Incident Management",2,"2011-09",192,{"$f":"IF('Timesheet raw data'!E16>0,'Timesheet raw data'!G16/'Timesheet raw data'!E16,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D16&I16","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D16<>\"\",'Timesheet raw data'!D16&\"-\"&'Timesheet raw data'!F16,\"\")","v":"Tenant2 Incident Management-2011-09"}]
[null,"Architect2","2011-09-16","Tenant1 Incident Management",4,"2011-09",384,{"$f":"IF('Timesheet raw data'!E17>0,'Timesheet raw data'!G17/'Timesheet raw data'!E17,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D17&I17","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D17<>\"\",'Timesheet raw data'!D17&\"-\"&'Timesheet raw data'!F17,\"\")","v":"Tenant1 Incident Management-2011-09"}]
[null,"Project Manager1","2011-09-22","Tenant1 Incident Management",6,"2011-09",600,{"$f":"IF('Timesheet raw data'!E18>0,'Timesheet raw data'!G18/'Timesheet raw data'!E18,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D18&I18","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D18<>\"\",'Timesheet raw data'!D18&\"-\"&'Timesheet raw data'!F18,\"\")","v":"Tenant1 Incident Management-2011-09"}]
[null,"Project Manager1","2011-09-26","Tenant1 Incident Management",1,"2011-09",100,{"$f":"IF('Timesheet raw data'!E19>0,'Timesheet raw data'!G19/'Timesheet raw data'!E19,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D19&I19","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D19<>\"\",'Timesheet raw data'!D19&\"-\"&'Timesheet raw data'!F19,\"\")","v":"Tenant1 Incident Management-2011-09"}]
[null,"Project Manager1","2011-09-27","Tenant1 Incident Management",2,"2011-09",200,{"$f":"IF('Timesheet raw data'!E20>0,'Timesheet raw data'!G20/'Timesheet raw data'!E20,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D20&I20","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D20<>\"\",'Timesheet raw data'!D20&\"-\"&'Timesheet raw data'!F20,\"\")","v":"Tenant1 Incident Management-2011-09"}]
[null,"Project Manager1","2011-09-28","Tenant1 Incident Management",2,"2011-09",200,{"$f":"IF('Timesheet raw data'!E21>0,'Timesheet raw data'!G21/'Timesheet raw data'!E21,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D21&I21","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D21<>\"\",'Timesheet raw data'!D21&\"-\"&'Timesheet raw data'!F21,\"\")","v":"Tenant1 Incident Management-2011-09"}]
[null,"Project Manager1","2011-09-30","Tenant1 Incident Management",1,"2011-09",100,{"$f":"IF('Timesheet raw data'!E22>0,'Timesheet raw data'!G22/'Timesheet raw data'!E22,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D22&I22","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D22<>\"\",'Timesheet raw data'!D22&\"-\"&'Timesheet raw data'!F22,\"\")","v":"Tenant1 Incident Management-2011-09"}]
[null,"Offshore Consultant1","2011-10-03","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E23>0,'Timesheet raw data'!G23/'Timesheet raw data'!E23,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D23&I23","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D23<>\"\",'Timesheet raw data'!D23&\"-\"&'Timesheet raw data'!F23,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-03","Tenant1 Incident Management",6,"2011-10",600,{"$f":"IF('Timesheet raw data'!E24>0,'Timesheet raw data'!G24/'Timesheet raw data'!E24,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D24&I24","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D24<>\"\",'Timesheet raw data'!D24&\"-\"&'Timesheet raw data'!F24,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-03","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E25>0,'Timesheet raw data'!G25/'Timesheet raw data'!E25,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D25&I25","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D25<>\"\",'Timesheet raw data'!D25&\"-\"&'Timesheet raw data'!F25,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-03","Tenant1 Incident Management",8,"2011-10",768,{"$f":"IF('Timesheet raw data'!E26>0,'Timesheet raw data'!G26/'Timesheet raw data'!E26,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D26&I26","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D26<>\"\",'Timesheet raw data'!D26&\"-\"&'Timesheet raw data'!F26,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-04","Tenant1 Incident Management",4,"2011-10",260,{"$f":"IF('Timesheet raw data'!E27>0,'Timesheet raw data'!G27/'Timesheet raw data'!E27,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D27&I27","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D27<>\"\",'Timesheet raw data'!D27&\"-\"&'Timesheet raw data'!F27,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect1","2011-10-04","Tenant1 Incident Management",6,"2011-10",576,{"$f":"IF('Timesheet raw data'!E28>0,'Timesheet raw data'!G28/'Timesheet raw data'!E28,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D28&I28","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D28<>\"\",'Timesheet raw data'!D28&\"-\"&'Timesheet raw data'!F28,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-04","Tenant1 Incident Management",3,"2011-10",300,{"$f":"IF('Timesheet raw data'!E29>0,'Timesheet raw data'!G29/'Timesheet raw data'!E29,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D29&I29","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D29<>\"\",'Timesheet raw data'!D29&\"-\"&'Timesheet raw data'!F29,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-04","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E30>0,'Timesheet raw data'!G30/'Timesheet raw data'!E30,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D30&I30","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D30<>\"\",'Timesheet raw data'!D30&\"-\"&'Timesheet raw data'!F30,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-04","Tenant1 Incident Management",4,"2011-10",384,{"$f":"IF('Timesheet raw data'!E31>0,'Timesheet raw data'!G31/'Timesheet raw data'!E31,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D31&I31","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D31<>\"\",'Timesheet raw data'!D31&\"-\"&'Timesheet raw data'!F31,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-05","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E32>0,'Timesheet raw data'!G32/'Timesheet raw data'!E32,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D32&I32","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D32<>\"\",'Timesheet raw data'!D32&\"-\"&'Timesheet raw data'!F32,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-05","Tenant1 Incident Management",1,"2011-10",100,{"$f":"IF('Timesheet raw data'!E33>0,'Timesheet raw data'!G33/'Timesheet raw data'!E33,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D33&I33","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D33<>\"\",'Timesheet raw data'!D33&\"-\"&'Timesheet raw data'!F33,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-05","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E34>0,'Timesheet raw data'!G34/'Timesheet raw data'!E34,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D34&I34","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D34<>\"\",'Timesheet raw data'!D34&\"-\"&'Timesheet raw data'!F34,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-05","Tenant1 Incident Management",4,"2011-10",384,{"$f":"IF('Timesheet raw data'!E35>0,'Timesheet raw data'!G35/'Timesheet raw data'!E35,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D35&I35","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D35<>\"\",'Timesheet raw data'!D35&\"-\"&'Timesheet raw data'!F35,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-06","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E36>0,'Timesheet raw data'!G36/'Timesheet raw data'!E36,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D36&I36","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D36<>\"\",'Timesheet raw data'!D36&\"-\"&'Timesheet raw data'!F36,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-06","Tenant1 Incident Management",6,"2011-10",576,{"$f":"IF('Timesheet raw data'!E37>0,'Timesheet raw data'!G37/'Timesheet raw data'!E37,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D37&I37","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D37<>\"\",'Timesheet raw data'!D37&\"-\"&'Timesheet raw data'!F37,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-07","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E38>0,'Timesheet raw data'!G38/'Timesheet raw data'!E38,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D38&I38","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D38<>\"\",'Timesheet raw data'!D38&\"-\"&'Timesheet raw data'!F38,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-07","Tenant1 Incident Management",1,"2011-10",100,{"$f":"IF('Timesheet raw data'!E39>0,'Timesheet raw data'!G39/'Timesheet raw data'!E39,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D39&I39","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D39<>\"\",'Timesheet raw data'!D39&\"-\"&'Timesheet raw data'!F39,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-07","Tenant1 Incident Management",4,"2011-10",400,{"$f":"IF('Timesheet raw data'!E40>0,'Timesheet raw data'!G40/'Timesheet raw data'!E40,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D40&I40","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D40<>\"\",'Timesheet raw data'!D40&\"-\"&'Timesheet raw data'!F40,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-07","Tenant1 Incident Management",1,"2011-10",100,{"$f":"IF('Timesheet raw data'!E41>0,'Timesheet raw data'!G41/'Timesheet raw data'!E41,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D41&I41","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D41<>\"\",'Timesheet raw data'!D41&\"-\"&'Timesheet raw data'!F41,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-07","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E42>0,'Timesheet raw data'!G42/'Timesheet raw data'!E42,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D42&I42","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D42<>\"\",'Timesheet raw data'!D42&\"-\"&'Timesheet raw data'!F42,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-07","Tenant1 Incident Management",6,"2011-10",576,{"$f":"IF('Timesheet raw data'!E43>0,'Timesheet raw data'!G43/'Timesheet raw data'!E43,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D43&I43","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D43<>\"\",'Timesheet raw data'!D43&\"-\"&'Timesheet raw data'!F43,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-10","Tenant1 Incident Management",4,"2011-10",260,{"$f":"IF('Timesheet raw data'!E44>0,'Timesheet raw data'!G44/'Timesheet raw data'!E44,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D44&I44","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D44<>\"\",'Timesheet raw data'!D44&\"-\"&'Timesheet raw data'!F44,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-10","Tenant1 Incident Management",4,"2011-10",400,{"$f":"IF('Timesheet raw data'!E45>0,'Timesheet raw data'!G45/'Timesheet raw data'!E45,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D45&I45","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D45<>\"\",'Timesheet raw data'!D45&\"-\"&'Timesheet raw data'!F45,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Associate Consultant2","2011-10-10","Tenant1 Incident Management",4,"2011-10",300,{"$f":"IF('Timesheet raw data'!E46>0,'Timesheet raw data'!G46/'Timesheet raw data'!E46,\"\")","v":75},"Associate Consultant",{"$f":"'Timesheet raw data'!D46&I46","v":"Tenant1 Incident ManagementAssociate Consultant"},{"$f":"IF('Timesheet raw data'!D46<>\"\",'Timesheet raw data'!D46&\"-\"&'Timesheet raw data'!F46,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant2","2011-10-10","Tenant1 Incident Management",4,"2011-10",260,{"$f":"IF('Timesheet raw data'!E47>0,'Timesheet raw data'!G47/'Timesheet raw data'!E47,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D47&I47","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D47<>\"\",'Timesheet raw data'!D47&\"-\"&'Timesheet raw data'!F47,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-10","Tenant1 Incident Management",6,"2011-10",576,{"$f":"IF('Timesheet raw data'!E48>0,'Timesheet raw data'!G48/'Timesheet raw data'!E48,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D48&I48","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D48<>\"\",'Timesheet raw data'!D48&\"-\"&'Timesheet raw data'!F48,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-11","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E49>0,'Timesheet raw data'!G49/'Timesheet raw data'!E49,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D49&I49","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D49<>\"\",'Timesheet raw data'!D49&\"-\"&'Timesheet raw data'!F49,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-11","Tenant1 Incident Management",2,"2011-10",200,{"$f":"IF('Timesheet raw data'!E50>0,'Timesheet raw data'!G50/'Timesheet raw data'!E50,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D50&I50","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D50<>\"\",'Timesheet raw data'!D50&\"-\"&'Timesheet raw data'!F50,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Associate Consultant2","2011-10-11","Tenant1 Incident Management",5,"2011-10",375,{"$f":"IF('Timesheet raw data'!E51>0,'Timesheet raw data'!G51/'Timesheet raw data'!E51,\"\")","v":75},"Associate Consultant",{"$f":"'Timesheet raw data'!D51&I51","v":"Tenant1 Incident ManagementAssociate Consultant"},{"$f":"IF('Timesheet raw data'!D51<>\"\",'Timesheet raw data'!D51&\"-\"&'Timesheet raw data'!F51,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant2","2011-10-11","Tenant1 Incident Management",4,"2011-10",260,{"$f":"IF('Timesheet raw data'!E52>0,'Timesheet raw data'!G52/'Timesheet raw data'!E52,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D52&I52","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D52<>\"\",'Timesheet raw data'!D52&\"-\"&'Timesheet raw data'!F52,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-11","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E53>0,'Timesheet raw data'!G53/'Timesheet raw data'!E53,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D53&I53","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D53<>\"\",'Timesheet raw data'!D53&\"-\"&'Timesheet raw data'!F53,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-11","Tenant1 Incident Management",10,"2011-10",960,{"$f":"IF('Timesheet raw data'!E54>0,'Timesheet raw data'!G54/'Timesheet raw data'!E54,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D54&I54","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D54<>\"\",'Timesheet raw data'!D54&\"-\"&'Timesheet raw data'!F54,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-12","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E55>0,'Timesheet raw data'!G55/'Timesheet raw data'!E55,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D55&I55","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D55<>\"\",'Timesheet raw data'!D55&\"-\"&'Timesheet raw data'!F55,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant1","2011-10-12","Tenant1 Incident Management",2,"2011-10",180,{"$f":"IF('Timesheet raw data'!E56>0,'Timesheet raw data'!G56/'Timesheet raw data'!E56,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D56&I56","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D56<>\"\",'Timesheet raw data'!D56&\"-\"&'Timesheet raw data'!F56,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Associate Consultant2","2011-10-12","Tenant1 Incident Management",4.5,"2011-10",337.5,{"$f":"IF('Timesheet raw data'!E57>0,'Timesheet raw data'!G57/'Timesheet raw data'!E57,\"\")","v":75},"Associate Consultant",{"$f":"'Timesheet raw data'!D57&I57","v":"Tenant1 Incident ManagementAssociate Consultant"},{"$f":"IF('Timesheet raw data'!D57<>\"\",'Timesheet raw data'!D57&\"-\"&'Timesheet raw data'!F57,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant2","2011-10-12","Tenant1 Incident Management",4,"2011-10",260,{"$f":"IF('Timesheet raw data'!E58>0,'Timesheet raw data'!G58/'Timesheet raw data'!E58,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D58&I58","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D58<>\"\",'Timesheet raw data'!D58&\"-\"&'Timesheet raw data'!F58,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-12","Tenant1 Incident Management",8,"2011-10",768,{"$f":"IF('Timesheet raw data'!E59>0,'Timesheet raw data'!G59/'Timesheet raw data'!E59,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D59&I59","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D59<>\"\",'Timesheet raw data'!D59&\"-\"&'Timesheet raw data'!F59,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-13","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E60>0,'Timesheet raw data'!G60/'Timesheet raw data'!E60,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D60&I60","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D60<>\"\",'Timesheet raw data'!D60&\"-\"&'Timesheet raw data'!F60,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Associate Consultant2","2011-10-13","Tenant1 Incident Management",7.5,"2011-10",562.5,{"$f":"IF('Timesheet raw data'!E61>0,'Timesheet raw data'!G61/'Timesheet raw data'!E61,\"\")","v":75},"Associate Consultant",{"$f":"'Timesheet raw data'!D61&I61","v":"Tenant1 Incident ManagementAssociate Consultant"},{"$f":"IF('Timesheet raw data'!D61<>\"\",'Timesheet raw data'!D61&\"-\"&'Timesheet raw data'!F61,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant2","2011-10-13","Tenant1 Incident Management",4,"2011-10",260,{"$f":"IF('Timesheet raw data'!E62>0,'Timesheet raw data'!G62/'Timesheet raw data'!E62,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D62&I62","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D62<>\"\",'Timesheet raw data'!D62&\"-\"&'Timesheet raw data'!F62,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-13","Tenant1 Incident Management",2,"2011-10",192,{"$f":"IF('Timesheet raw data'!E63>0,'Timesheet raw data'!G63/'Timesheet raw data'!E63,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D63&I63","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D63<>\"\",'Timesheet raw data'!D63&\"-\"&'Timesheet raw data'!F63,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-14","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E64>0,'Timesheet raw data'!G64/'Timesheet raw data'!E64,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D64&I64","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D64<>\"\",'Timesheet raw data'!D64&\"-\"&'Timesheet raw data'!F64,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-14","Tenant1 Incident Management",2,"2011-10",200,{"$f":"IF('Timesheet raw data'!E65>0,'Timesheet raw data'!G65/'Timesheet raw data'!E65,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D65&I65","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D65<>\"\",'Timesheet raw data'!D65&\"-\"&'Timesheet raw data'!F65,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Associate Consultant2","2011-10-14","Tenant1 Incident Management",3,{"$f":"IF(C66<>\"\",TEXT(YEAR(C66),\"0000\")&\"-\"&TEXT(MONTH(C66),\"00\"),\"\")","v":"2011-10"},225,{"$f":"IF('Timesheet raw data'!E66>0,'Timesheet raw data'!G66/'Timesheet raw data'!E66,\"\")","v":75},"Associate Consultant",{"$f":"'Timesheet raw data'!D66&I66","v":"Tenant1 Incident ManagementAssociate Consultant"},{"$f":"IF('Timesheet raw data'!D66<>\"\",'Timesheet raw data'!D66&\"-\"&'Timesheet raw data'!F66,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant2","2011-10-14","Tenant1 Incident Management",4,"2011-10",260,{"$f":"IF('Timesheet raw data'!E67>0,'Timesheet raw data'!G67/'Timesheet raw data'!E67,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D67&I67","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D67<>\"\",'Timesheet raw data'!D67&\"-\"&'Timesheet raw data'!F67,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-14","Tenant1 Incident Management",2,"2011-10",192,{"$f":"IF('Timesheet raw data'!E68>0,'Timesheet raw data'!G68/'Timesheet raw data'!E68,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D68&I68","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D68<>\"\",'Timesheet raw data'!D68&\"-\"&'Timesheet raw data'!F68,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-17","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E69>0,'Timesheet raw data'!G69/'Timesheet raw data'!E69,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D69&I69","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D69<>\"\",'Timesheet raw data'!D69&\"-\"&'Timesheet raw data'!F69,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Associate Consultant2","2011-10-17","Tenant1 Incident Management",2,"2011-10",{"$f":"VLOOKUP(B70,Program.ResourceTable,3,FALSE)*E70","v":150},{"$f":"IF('Timesheet raw data'!E70>0,'Timesheet raw data'!G70/'Timesheet raw data'!E70,\"\")","v":75},{"$f":"IF(H70<>\"\",VLOOKUP(H70,Program.RateTable,2,FALSE),\"\")","v":"Associate Consultant"},{"$f":"'Timesheet raw data'!D70&I70","v":"Tenant1 Incident ManagementAssociate Consultant"},{"$f":"IF('Timesheet raw data'!D70<>\"\",'Timesheet raw data'!D70&\"-\"&'Timesheet raw data'!F70,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant2","2011-10-17","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E71>0,'Timesheet raw data'!G71/'Timesheet raw data'!E71,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D71&I71","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D71<>\"\",'Timesheet raw data'!D71&\"-\"&'Timesheet raw data'!F71,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-17","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E72>0,'Timesheet raw data'!G72/'Timesheet raw data'!E72,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D72&I72","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D72<>\"\",'Timesheet raw data'!D72&\"-\"&'Timesheet raw data'!F72,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-17","Tenant1 Incident Management",3,"2011-10",288,{"$f":"IF('Timesheet raw data'!E73>0,'Timesheet raw data'!G73/'Timesheet raw data'!E73,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D73&I73","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D73<>\"\",'Timesheet raw data'!D73&\"-\"&'Timesheet raw data'!F73,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-18","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E74>0,'Timesheet raw data'!G74/'Timesheet raw data'!E74,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D74&I74","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D74<>\"\",'Timesheet raw data'!D74&\"-\"&'Timesheet raw data'!F74,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Associate Consultant2","2011-10-18","Tenant1 Incident Management",2,"2011-10",150,{"$f":"IF('Timesheet raw data'!E75>0,'Timesheet raw data'!G75/'Timesheet raw data'!E75,\"\")","v":75},"Associate Consultant",{"$f":"'Timesheet raw data'!D75&I75","v":"Tenant1 Incident ManagementAssociate Consultant"},{"$f":"IF('Timesheet raw data'!D75<>\"\",'Timesheet raw data'!D75&\"-\"&'Timesheet raw data'!F75,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant2","2011-10-18","Tenant1 Incident Management",6,"2011-10",390,{"$f":"IF('Timesheet raw data'!E76>0,'Timesheet raw data'!G76/'Timesheet raw data'!E76,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D76&I76","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D76<>\"\",'Timesheet raw data'!D76&\"-\"&'Timesheet raw data'!F76,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-18","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E77>0,'Timesheet raw data'!G77/'Timesheet raw data'!E77,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D77&I77","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D77<>\"\",'Timesheet raw data'!D77&\"-\"&'Timesheet raw data'!F77,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-18","Tenant1 Incident Management",3,"2011-10",288,{"$f":"IF('Timesheet raw data'!E78>0,'Timesheet raw data'!G78/'Timesheet raw data'!E78,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D78&I78","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D78<>\"\",'Timesheet raw data'!D78&\"-\"&'Timesheet raw data'!F78,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-19","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E79>0,'Timesheet raw data'!G79/'Timesheet raw data'!E79,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D79&I79","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D79<>\"\",'Timesheet raw data'!D79&\"-\"&'Timesheet raw data'!F79,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-19","Tenant1 Incident Management",1,"2011-10",100,{"$f":"IF('Timesheet raw data'!E80>0,'Timesheet raw data'!G80/'Timesheet raw data'!E80,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D80&I80","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D80<>\"\",'Timesheet raw data'!D80&\"-\"&'Timesheet raw data'!F80,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Associate Consultant2","2011-10-19","Tenant1 Incident Management",2,"2011-10",150,{"$f":"IF('Timesheet raw data'!E81>0,'Timesheet raw data'!G81/'Timesheet raw data'!E81,\"\")","v":75},"Associate Consultant",{"$f":"'Timesheet raw data'!D81&I81","v":"Tenant1 Incident ManagementAssociate Consultant"},{"$f":"IF('Timesheet raw data'!D81<>\"\",'Timesheet raw data'!D81&\"-\"&'Timesheet raw data'!F81,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant2","2011-10-19","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E82>0,'Timesheet raw data'!G82/'Timesheet raw data'!E82,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D82&I82","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D82<>\"\",'Timesheet raw data'!D82&\"-\"&'Timesheet raw data'!F82,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-19","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E83>0,'Timesheet raw data'!G83/'Timesheet raw data'!E83,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D83&I83","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D83<>\"\",'Timesheet raw data'!D83&\"-\"&'Timesheet raw data'!F83,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-19","Tenant1 Incident Management",3.5,"2011-10",336,{"$f":"IF('Timesheet raw data'!E84>0,'Timesheet raw data'!G84/'Timesheet raw data'!E84,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D84&I84","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D84<>\"\",'Timesheet raw data'!D84&\"-\"&'Timesheet raw data'!F84,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-20","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E85>0,'Timesheet raw data'!G85/'Timesheet raw data'!E85,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D85&I85","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D85<>\"\",'Timesheet raw data'!D85&\"-\"&'Timesheet raw data'!F85,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-20","Tenant1 Incident Management",2,"2011-10",200,{"$f":"IF('Timesheet raw data'!E86>0,'Timesheet raw data'!G86/'Timesheet raw data'!E86,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D86&I86","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D86<>\"\",'Timesheet raw data'!D86&\"-\"&'Timesheet raw data'!F86,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant2","2011-10-20","Tenant1 Incident Management",6,"2011-10",390,{"$f":"IF('Timesheet raw data'!E87>0,'Timesheet raw data'!G87/'Timesheet raw data'!E87,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D87&I87","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D87<>\"\",'Timesheet raw data'!D87&\"-\"&'Timesheet raw data'!F87,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-20","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E88>0,'Timesheet raw data'!G88/'Timesheet raw data'!E88,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D88&I88","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D88<>\"\",'Timesheet raw data'!D88&\"-\"&'Timesheet raw data'!F88,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-20","Tenant1 Incident Management",1.5,"2011-10",144,{"$f":"IF('Timesheet raw data'!E89>0,'Timesheet raw data'!G89/'Timesheet raw data'!E89,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D89&I89","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D89<>\"\",'Timesheet raw data'!D89&\"-\"&'Timesheet raw data'!F89,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-21","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E90>0,'Timesheet raw data'!G90/'Timesheet raw data'!E90,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D90&I90","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D90<>\"\",'Timesheet raw data'!D90&\"-\"&'Timesheet raw data'!F90,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-21","Tenant1 Incident Management",2,"2011-10",200,{"$f":"IF('Timesheet raw data'!E91>0,'Timesheet raw data'!G91/'Timesheet raw data'!E91,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D91&I91","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D91<>\"\",'Timesheet raw data'!D91&\"-\"&'Timesheet raw data'!F91,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant2","2011-10-21","Tenant1 Incident Management",2,"2011-10",130,{"$f":"IF('Timesheet raw data'!E92>0,'Timesheet raw data'!G92/'Timesheet raw data'!E92,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D92&I92","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D92<>\"\",'Timesheet raw data'!D92&\"-\"&'Timesheet raw data'!F92,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-21","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E93>0,'Timesheet raw data'!G93/'Timesheet raw data'!E93,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D93&I93","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D93<>\"\",'Timesheet raw data'!D93&\"-\"&'Timesheet raw data'!F93,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-21","Tenant1 Incident Management",6,"2011-10",576,{"$f":"IF('Timesheet raw data'!E94>0,'Timesheet raw data'!G94/'Timesheet raw data'!E94,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D94&I94","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D94<>\"\",'Timesheet raw data'!D94&\"-\"&'Timesheet raw data'!F94,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-22","Tenant1 Incident Management",3,"2011-10",300,{"$f":"IF('Timesheet raw data'!E95>0,'Timesheet raw data'!G95/'Timesheet raw data'!E95,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D95&I95","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D95<>\"\",'Timesheet raw data'!D95&\"-\"&'Timesheet raw data'!F95,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant2","2011-10-24","Tenant1 Incident Management",4,"2011-10",260,{"$f":"IF('Timesheet raw data'!E96>0,'Timesheet raw data'!G96/'Timesheet raw data'!E96,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D96&I96","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D96<>\"\",'Timesheet raw data'!D96&\"-\"&'Timesheet raw data'!F96,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-24","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E97>0,'Timesheet raw data'!G97/'Timesheet raw data'!E97,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D97&I97","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D97<>\"\",'Timesheet raw data'!D97&\"-\"&'Timesheet raw data'!F97,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-24","Tenant1 Incident Management",2.5,"2011-10",240,{"$f":"IF('Timesheet raw data'!E98>0,'Timesheet raw data'!G98/'Timesheet raw data'!E98,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D98&I98","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D98<>\"\",'Timesheet raw data'!D98&\"-\"&'Timesheet raw data'!F98,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Associate Consultant2","2011-10-25","Tenant1 Incident Management",2.5,"2011-10",187.5,{"$f":"IF('Timesheet raw data'!E99>0,'Timesheet raw data'!G99/'Timesheet raw data'!E99,\"\")","v":75},"Associate Consultant",{"$f":"'Timesheet raw data'!D99&I99","v":"Tenant1 Incident ManagementAssociate Consultant"},{"$f":"IF('Timesheet raw data'!D99<>\"\",'Timesheet raw data'!D99&\"-\"&'Timesheet raw data'!F99,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant2","2011-10-25","Tenant1 Incident Management",4,"2011-10",260,{"$f":"IF('Timesheet raw data'!E100>0,'Timesheet raw data'!G100/'Timesheet raw data'!E100,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D100&I100","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D100<>\"\",'Timesheet raw data'!D100&\"-\"&'Timesheet raw data'!F100,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-25","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E101>0,'Timesheet raw data'!G101/'Timesheet raw data'!E101,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D101&I101","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D101<>\"\",'Timesheet raw data'!D101&\"-\"&'Timesheet raw data'!F101,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-25","Tenant1 Incident Management",1.5,"2011-10",144,{"$f":"IF('Timesheet raw data'!E102>0,'Timesheet raw data'!G102/'Timesheet raw data'!E102,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D102&I102","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D102<>\"\",'Timesheet raw data'!D102&\"-\"&'Timesheet raw data'!F102,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Associate Consultant2","2011-10-26","Tenant1 Incident Management",2.5,"2011-10",187.5,{"$f":"IF('Timesheet raw data'!E103>0,'Timesheet raw data'!G103/'Timesheet raw data'!E103,\"\")","v":75},"Associate Consultant",{"$f":"'Timesheet raw data'!D103&I103","v":"Tenant1 Incident ManagementAssociate Consultant"},{"$f":"IF('Timesheet raw data'!D103<>\"\",'Timesheet raw data'!D103&\"-\"&'Timesheet raw data'!F103,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-26","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E104>0,'Timesheet raw data'!G104/'Timesheet raw data'!E104,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D104&I104","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D104<>\"\",'Timesheet raw data'!D104&\"-\"&'Timesheet raw data'!F104,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-27","Tenant1 Incident Management",8,"2011-10",720,{"$f":"IF('Timesheet raw data'!E105>0,'Timesheet raw data'!G105/'Timesheet raw data'!E105,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D105&I105","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D105<>\"\",'Timesheet raw data'!D105&\"-\"&'Timesheet raw data'!F105,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-27","Tenant1 Incident Management",1,"2011-10",96,{"$f":"IF('Timesheet raw data'!E106>0,'Timesheet raw data'!G106/'Timesheet raw data'!E106,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D106&I106","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D106<>\"\",'Timesheet raw data'!D106&\"-\"&'Timesheet raw data'!F106,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Project Manager1","2011-10-28","Tenant1 Incident Management",1,"2011-10",100,{"$f":"IF('Timesheet raw data'!E107>0,'Timesheet raw data'!G107/'Timesheet raw data'!E107,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D107&I107","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D107<>\"\",'Timesheet raw data'!D107&\"-\"&'Timesheet raw data'!F107,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Associate Consultant2","2011-10-28","Tenant1 Incident Management",2,"2011-10",150,{"$f":"IF('Timesheet raw data'!E108>0,'Timesheet raw data'!G108/'Timesheet raw data'!E108,\"\")","v":75},"Associate Consultant",{"$f":"'Timesheet raw data'!D108&I108","v":"Tenant1 Incident ManagementAssociate Consultant"},{"$f":"IF('Timesheet raw data'!D108<>\"\",'Timesheet raw data'!D108&\"-\"&'Timesheet raw data'!F108,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Sr Consultant4","2011-10-28","Tenant1 Incident Management",4,"2011-10",360,{"$f":"IF('Timesheet raw data'!E109>0,'Timesheet raw data'!G109/'Timesheet raw data'!E109,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D109&I109","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D109<>\"\",'Timesheet raw data'!D109&\"-\"&'Timesheet raw data'!F109,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-28","Tenant1 Incident Management",3,"2011-10",288,{"$f":"IF('Timesheet raw data'!E110>0,'Timesheet raw data'!G110/'Timesheet raw data'!E110,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D110&I110","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D110<>\"\",'Timesheet raw data'!D110&\"-\"&'Timesheet raw data'!F110,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-10-31","Tenant1 Incident Management",4,"2011-10",260,{"$f":"IF('Timesheet raw data'!E111>0,'Timesheet raw data'!G111/'Timesheet raw data'!E111,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D111&I111","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D111<>\"\",'Timesheet raw data'!D111&\"-\"&'Timesheet raw data'!F111,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Architect3","2011-10-31","Tenant1 Incident Management",1,"2011-10",96,{"$f":"IF('Timesheet raw data'!E112>0,'Timesheet raw data'!G112/'Timesheet raw data'!E112,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D112&I112","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D112<>\"\",'Timesheet raw data'!D112&\"-\"&'Timesheet raw data'!F112,\"\")","v":"Tenant1 Incident Management-2011-10"}]
[null,"Offshore Consultant1","2011-11-02","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E113>0,'Timesheet raw data'!G113/'Timesheet raw data'!E113,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D113&I113","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D113<>\"\",'Timesheet raw data'!D113&\"-\"&'Timesheet raw data'!F113,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-02","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E114>0,'Timesheet raw data'!G114/'Timesheet raw data'!E114,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D114&I114","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D114<>\"\",'Timesheet raw data'!D114&\"-\"&'Timesheet raw data'!F114,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-02","Tenant1 Incident Management",6,"2011-11",576,{"$f":"IF('Timesheet raw data'!E115>0,'Timesheet raw data'!G115/'Timesheet raw data'!E115,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D115&I115","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D115<>\"\",'Timesheet raw data'!D115&\"-\"&'Timesheet raw data'!F115,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Project Manager1","2011-11-02","Tenant2 Incident Management",5,"2011-11",500,{"$f":"IF('Timesheet raw data'!E116>0,'Timesheet raw data'!G116/'Timesheet raw data'!E116,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D116&I116","v":"Tenant2 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D116<>\"\",'Timesheet raw data'!D116&\"-\"&'Timesheet raw data'!F116,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect2","2011-11-02","Tenant2 Incident Management",2,"2011-11",192,{"$f":"IF('Timesheet raw data'!E117>0,'Timesheet raw data'!G117/'Timesheet raw data'!E117,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D117&I117","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D117<>\"\",'Timesheet raw data'!D117&\"-\"&'Timesheet raw data'!F117,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-03","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E118>0,'Timesheet raw data'!G118/'Timesheet raw data'!E118,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D118&I118","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D118<>\"\",'Timesheet raw data'!D118&\"-\"&'Timesheet raw data'!F118,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-03","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E119>0,'Timesheet raw data'!G119/'Timesheet raw data'!E119,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D119&I119","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D119<>\"\",'Timesheet raw data'!D119&\"-\"&'Timesheet raw data'!F119,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-03","Tenant1 Incident Management",1,"2011-11",96,{"$f":"IF('Timesheet raw data'!E120>0,'Timesheet raw data'!G120/'Timesheet raw data'!E120,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D120&I120","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D120<>\"\",'Timesheet raw data'!D120&\"-\"&'Timesheet raw data'!F120,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant1","2011-11-03","Tenant2 Incident Management",4,"2011-11",360,{"$f":"IF('Timesheet raw data'!E121>0,'Timesheet raw data'!G121/'Timesheet raw data'!E121,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D121&I121","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D121<>\"\",'Timesheet raw data'!D121&\"-\"&'Timesheet raw data'!F121,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Project Manager1","2011-11-03","Tenant2 Incident Management",1,"2011-11",100,{"$f":"IF('Timesheet raw data'!E122>0,'Timesheet raw data'!G122/'Timesheet raw data'!E122,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D122&I122","v":"Tenant2 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D122<>\"\",'Timesheet raw data'!D122&\"-\"&'Timesheet raw data'!F122,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect2","2011-11-03","Tenant2 Incident Management",4,{"$f":"IF(C123<>\"\",TEXT(YEAR(C123),\"0000\")&\"-\"&TEXT(MONTH(C123),\"00\"),\"\")","v":"2011-11"},384,{"$f":"IF('Timesheet raw data'!E123>0,'Timesheet raw data'!G123/'Timesheet raw data'!E123,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D123&I123","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D123<>\"\",'Timesheet raw data'!D123&\"-\"&'Timesheet raw data'!F123,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect3","2011-11-03","Tenant2 Incident Management",4.5,"2011-11",432,{"$f":"IF('Timesheet raw data'!E124>0,'Timesheet raw data'!G124/'Timesheet raw data'!E124,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D124&I124","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D124<>\"\",'Timesheet raw data'!D124&\"-\"&'Timesheet raw data'!F124,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-04","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E125>0,'Timesheet raw data'!G125/'Timesheet raw data'!E125,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D125&I125","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D125<>\"\",'Timesheet raw data'!D125&\"-\"&'Timesheet raw data'!F125,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Project Manager1","2011-11-04","Tenant1 Incident Management",3,"2011-11",300,{"$f":"IF('Timesheet raw data'!E126>0,'Timesheet raw data'!G126/'Timesheet raw data'!E126,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D126&I126","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D126<>\"\",'Timesheet raw data'!D126&\"-\"&'Timesheet raw data'!F126,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-04","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E127>0,'Timesheet raw data'!G127/'Timesheet raw data'!E127,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D127&I127","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D127<>\"\",'Timesheet raw data'!D127&\"-\"&'Timesheet raw data'!F127,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-04","Tenant1 Incident Management",1.5,"2011-11",144,{"$f":"IF('Timesheet raw data'!E128>0,'Timesheet raw data'!G128/'Timesheet raw data'!E128,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D128&I128","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D128<>\"\",'Timesheet raw data'!D128&\"-\"&'Timesheet raw data'!F128,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Project Manager1","2011-11-04","Tenant2 Incident Management",3,"2011-11",300,{"$f":"IF('Timesheet raw data'!E129>0,'Timesheet raw data'!G129/'Timesheet raw data'!E129,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D129&I129","v":"Tenant2 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D129<>\"\",'Timesheet raw data'!D129&\"-\"&'Timesheet raw data'!F129,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect2","2011-11-04","Tenant2 Incident Management",4,"2011-11",384,{"$f":"IF('Timesheet raw data'!E130>0,'Timesheet raw data'!G130/'Timesheet raw data'!E130,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D130&I130","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D130<>\"\",'Timesheet raw data'!D130&\"-\"&'Timesheet raw data'!F130,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect3","2011-11-04","Tenant2 Incident Management",4.5,"2011-11",432,{"$f":"IF('Timesheet raw data'!E131>0,'Timesheet raw data'!G131/'Timesheet raw data'!E131,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D131&I131","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D131<>\"\",'Timesheet raw data'!D131&\"-\"&'Timesheet raw data'!F131,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-07","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E132>0,'Timesheet raw data'!G132/'Timesheet raw data'!E132,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D132&I132","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D132<>\"\",'Timesheet raw data'!D132&\"-\"&'Timesheet raw data'!F132,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-07","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E133>0,'Timesheet raw data'!G133/'Timesheet raw data'!E133,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D133&I133","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D133<>\"\",'Timesheet raw data'!D133&\"-\"&'Timesheet raw data'!F133,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-07","Tenant1 Incident Management",8,"2011-11",{"$f":"VLOOKUP(B134,Program.ResourceTable,3,FALSE)*E134","v":720},{"$f":"IF('Timesheet raw data'!E134>0,'Timesheet raw data'!G134/'Timesheet raw data'!E134,\"\")","v":90},{"$f":"IF(H134<>\"\",VLOOKUP(H134,Program.RateTable,2,FALSE),\"\")","v":"Sr Consultant"},{"$f":"'Timesheet raw data'!D134&I134","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D134<>\"\",'Timesheet raw data'!D134&\"-\"&'Timesheet raw data'!F134,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-07","Tenant1 Incident Management",2,"2011-11",192,{"$f":"IF('Timesheet raw data'!E135>0,'Timesheet raw data'!G135/'Timesheet raw data'!E135,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D135&I135","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D135<>\"\",'Timesheet raw data'!D135&\"-\"&'Timesheet raw data'!F135,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect2","2011-11-07","Tenant2 Incident Management",3,"2011-11",288,{"$f":"IF('Timesheet raw data'!E136>0,'Timesheet raw data'!G136/'Timesheet raw data'!E136,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D136&I136","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D136<>\"\",'Timesheet raw data'!D136&\"-\"&'Timesheet raw data'!F136,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect3","2011-11-07","Tenant2 Incident Management",4.5,"2011-11",432,{"$f":"IF('Timesheet raw data'!E137>0,'Timesheet raw data'!G137/'Timesheet raw data'!E137,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D137&I137","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D137<>\"\",'Timesheet raw data'!D137&\"-\"&'Timesheet raw data'!F137,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-08","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E138>0,'Timesheet raw data'!G138/'Timesheet raw data'!E138,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D138&I138","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D138<>\"\",'Timesheet raw data'!D138&\"-\"&'Timesheet raw data'!F138,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-08","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E139>0,'Timesheet raw data'!G139/'Timesheet raw data'!E139,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D139&I139","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D139<>\"\",'Timesheet raw data'!D139&\"-\"&'Timesheet raw data'!F139,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-08","Tenant1 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E140>0,'Timesheet raw data'!G140/'Timesheet raw data'!E140,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D140&I140","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D140<>\"\",'Timesheet raw data'!D140&\"-\"&'Timesheet raw data'!F140,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-08","Tenant1 Incident Management",3.5,"2011-11",336,{"$f":"IF('Timesheet raw data'!E141>0,'Timesheet raw data'!G141/'Timesheet raw data'!E141,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D141&I141","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D141<>\"\",'Timesheet raw data'!D141&\"-\"&'Timesheet raw data'!F141,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant1","2011-11-08","Tenant2 Incident Management",4,"2011-11",360,{"$f":"IF('Timesheet raw data'!E142>0,'Timesheet raw data'!G142/'Timesheet raw data'!E142,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D142&I142","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D142<>\"\",'Timesheet raw data'!D142&\"-\"&'Timesheet raw data'!F142,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect2","2011-11-08","Tenant2 Incident Management",1,"2011-11",96,{"$f":"IF('Timesheet raw data'!E143>0,'Timesheet raw data'!G143/'Timesheet raw data'!E143,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D143&I143","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D143<>\"\",'Timesheet raw data'!D143&\"-\"&'Timesheet raw data'!F143,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect2","2011-11-08","Tenant2 Incident Management",3,"2011-11",288,{"$f":"IF('Timesheet raw data'!E144>0,'Timesheet raw data'!G144/'Timesheet raw data'!E144,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D144&I144","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D144<>\"\",'Timesheet raw data'!D144&\"-\"&'Timesheet raw data'!F144,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect3","2011-11-08","Tenant2 Incident Management",4.5,"2011-11",432,{"$f":"IF('Timesheet raw data'!E145>0,'Timesheet raw data'!G145/'Timesheet raw data'!E145,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D145&I145","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D145<>\"\",'Timesheet raw data'!D145&\"-\"&'Timesheet raw data'!F145,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-09","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E146>0,'Timesheet raw data'!G146/'Timesheet raw data'!E146,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D146&I146","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D146<>\"\",'Timesheet raw data'!D146&\"-\"&'Timesheet raw data'!F146,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-09","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E147>0,'Timesheet raw data'!G147/'Timesheet raw data'!E147,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D147&I147","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D147<>\"\",'Timesheet raw data'!D147&\"-\"&'Timesheet raw data'!F147,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-09","Tenant1 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E148>0,'Timesheet raw data'!G148/'Timesheet raw data'!E148,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D148&I148","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D148<>\"\",'Timesheet raw data'!D148&\"-\"&'Timesheet raw data'!F148,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-09","Tenant1 Incident Management",1.5,"2011-11",144,{"$f":"IF('Timesheet raw data'!E149>0,'Timesheet raw data'!G149/'Timesheet raw data'!E149,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D149&I149","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D149<>\"\",'Timesheet raw data'!D149&\"-\"&'Timesheet raw data'!F149,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect2","2011-11-09","Tenant2 Incident Management",1,"2011-11",96,{"$f":"IF('Timesheet raw data'!E150>0,'Timesheet raw data'!G150/'Timesheet raw data'!E150,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D150&I150","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D150<>\"\",'Timesheet raw data'!D150&\"-\"&'Timesheet raw data'!F150,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect3","2011-11-09","Tenant2 Incident Management",6,"2011-11",576,{"$f":"IF('Timesheet raw data'!E151>0,'Timesheet raw data'!G151/'Timesheet raw data'!E151,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D151&I151","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D151<>\"\",'Timesheet raw data'!D151&\"-\"&'Timesheet raw data'!F151,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-10","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E152>0,'Timesheet raw data'!G152/'Timesheet raw data'!E152,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D152&I152","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D152<>\"\",'Timesheet raw data'!D152&\"-\"&'Timesheet raw data'!F152,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-10","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E153>0,'Timesheet raw data'!G153/'Timesheet raw data'!E153,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D153&I153","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D153<>\"\",'Timesheet raw data'!D153&\"-\"&'Timesheet raw data'!F153,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-10","Tenant1 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E154>0,'Timesheet raw data'!G154/'Timesheet raw data'!E154,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D154&I154","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D154<>\"\",'Timesheet raw data'!D154&\"-\"&'Timesheet raw data'!F154,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant1","2011-11-10","Tenant2 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E155>0,'Timesheet raw data'!G155/'Timesheet raw data'!E155,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D155&I155","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D155<>\"\",'Timesheet raw data'!D155&\"-\"&'Timesheet raw data'!F155,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-11","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E156>0,'Timesheet raw data'!G156/'Timesheet raw data'!E156,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D156&I156","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D156<>\"\",'Timesheet raw data'!D156&\"-\"&'Timesheet raw data'!F156,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Project Manager1","2011-11-11","Tenant1 Incident Management",2,"2011-11",200,{"$f":"IF('Timesheet raw data'!E157>0,'Timesheet raw data'!G157/'Timesheet raw data'!E157,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D157&I157","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D157<>\"\",'Timesheet raw data'!D157&\"-\"&'Timesheet raw data'!F157,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-11","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E158>0,'Timesheet raw data'!G158/'Timesheet raw data'!E158,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D158&I158","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D158<>\"\",'Timesheet raw data'!D158&\"-\"&'Timesheet raw data'!F158,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-11","Tenant1 Incident Management",0.5,"2011-11",48,{"$f":"IF('Timesheet raw data'!E159>0,'Timesheet raw data'!G159/'Timesheet raw data'!E159,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D159&I159","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D159<>\"\",'Timesheet raw data'!D159&\"-\"&'Timesheet raw data'!F159,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant1","2011-11-11","Tenant2 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E160>0,'Timesheet raw data'!G160/'Timesheet raw data'!E160,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D160&I160","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D160<>\"\",'Timesheet raw data'!D160&\"-\"&'Timesheet raw data'!F160,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Project Manager1","2011-11-11","Tenant2 Incident Management",1,"2011-11",100,{"$f":"IF('Timesheet raw data'!E161>0,'Timesheet raw data'!G161/'Timesheet raw data'!E161,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D161&I161","v":"Tenant2 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D161<>\"\",'Timesheet raw data'!D161&\"-\"&'Timesheet raw data'!F161,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect2","2011-11-11","Tenant2 Incident Management",2,"2011-11",192,{"$f":"IF('Timesheet raw data'!E162>0,'Timesheet raw data'!G162/'Timesheet raw data'!E162,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D162&I162","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D162<>\"\",'Timesheet raw data'!D162&\"-\"&'Timesheet raw data'!F162,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-14","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E163>0,'Timesheet raw data'!G163/'Timesheet raw data'!E163,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D163&I163","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D163<>\"\",'Timesheet raw data'!D163&\"-\"&'Timesheet raw data'!F163,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Project Manager1","2011-11-14","Tenant1 Incident Management",1,"2011-11",100,{"$f":"IF('Timesheet raw data'!E164>0,'Timesheet raw data'!G164/'Timesheet raw data'!E164,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D164&I164","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D164<>\"\",'Timesheet raw data'!D164&\"-\"&'Timesheet raw data'!F164,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-14","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E165>0,'Timesheet raw data'!G165/'Timesheet raw data'!E165,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D165&I165","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D165<>\"\",'Timesheet raw data'!D165&\"-\"&'Timesheet raw data'!F165,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-14","Tenant1 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E166>0,'Timesheet raw data'!G166/'Timesheet raw data'!E166,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D166&I166","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D166<>\"\",'Timesheet raw data'!D166&\"-\"&'Timesheet raw data'!F166,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-14","Tenant1 Incident Management",4,"2011-11",384,{"$f":"IF('Timesheet raw data'!E167>0,'Timesheet raw data'!G167/'Timesheet raw data'!E167,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D167&I167","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D167<>\"\",'Timesheet raw data'!D167&\"-\"&'Timesheet raw data'!F167,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant1","2011-11-14","Tenant2 Incident Management",3,"2011-11",270,{"$f":"IF('Timesheet raw data'!E168>0,'Timesheet raw data'!G168/'Timesheet raw data'!E168,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D168&I168","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D168<>\"\",'Timesheet raw data'!D168&\"-\"&'Timesheet raw data'!F168,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Sr Consultant1","2011-11-14","Tenant2 Incident Management",5,"2011-11",450,{"$f":"IF('Timesheet raw data'!E169>0,'Timesheet raw data'!G169/'Timesheet raw data'!E169,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D169&I169","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D169<>\"\",'Timesheet raw data'!D169&\"-\"&'Timesheet raw data'!F169,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Project Manager1","2011-11-14","Tenant2 Incident Management",2,"2011-11",200,{"$f":"IF('Timesheet raw data'!E170>0,'Timesheet raw data'!G170/'Timesheet raw data'!E170,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D170&I170","v":"Tenant2 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D170<>\"\",'Timesheet raw data'!D170&\"-\"&'Timesheet raw data'!F170,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect2","2011-11-14","Tenant2 Incident Management",2,"2011-11",192,{"$f":"IF('Timesheet raw data'!E171>0,'Timesheet raw data'!G171/'Timesheet raw data'!E171,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D171&I171","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D171<>\"\",'Timesheet raw data'!D171&\"-\"&'Timesheet raw data'!F171,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect2","2011-11-14","Tenant2 Incident Management",2,"2011-11",192,{"$f":"IF('Timesheet raw data'!E172>0,'Timesheet raw data'!G172/'Timesheet raw data'!E172,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D172&I172","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D172<>\"\",'Timesheet raw data'!D172&\"-\"&'Timesheet raw data'!F172,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect3","2011-11-14","Tenant2 Incident Management",3.5,"2011-11",336,{"$f":"IF('Timesheet raw data'!E173>0,'Timesheet raw data'!G173/'Timesheet raw data'!E173,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D173&I173","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D173<>\"\",'Timesheet raw data'!D173&\"-\"&'Timesheet raw data'!F173,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-15","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E174>0,'Timesheet raw data'!G174/'Timesheet raw data'!E174,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D174&I174","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D174<>\"\",'Timesheet raw data'!D174&\"-\"&'Timesheet raw data'!F174,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-15","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E175>0,'Timesheet raw data'!G175/'Timesheet raw data'!E175,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D175&I175","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D175<>\"\",'Timesheet raw data'!D175&\"-\"&'Timesheet raw data'!F175,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-15","Tenant1 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E176>0,'Timesheet raw data'!G176/'Timesheet raw data'!E176,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D176&I176","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D176<>\"\",'Timesheet raw data'!D176&\"-\"&'Timesheet raw data'!F176,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant1","2011-11-15","Tenant2 Incident Management",6,"2011-11",540,{"$f":"IF('Timesheet raw data'!E177>0,'Timesheet raw data'!G177/'Timesheet raw data'!E177,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D177&I177","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D177<>\"\",'Timesheet raw data'!D177&\"-\"&'Timesheet raw data'!F177,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Project Manager1","2011-11-15","Tenant2 Incident Management",1,"2011-11",100,{"$f":"IF('Timesheet raw data'!E178>0,'Timesheet raw data'!G178/'Timesheet raw data'!E178,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D178&I178","v":"Tenant2 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D178<>\"\",'Timesheet raw data'!D178&\"-\"&'Timesheet raw data'!F178,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect2","2011-11-15","Tenant2 Incident Management",1,"2011-11",96,{"$f":"IF('Timesheet raw data'!E179>0,'Timesheet raw data'!G179/'Timesheet raw data'!E179,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D179&I179","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D179<>\"\",'Timesheet raw data'!D179&\"-\"&'Timesheet raw data'!F179,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-16","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E180>0,'Timesheet raw data'!G180/'Timesheet raw data'!E180,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D180&I180","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D180<>\"\",'Timesheet raw data'!D180&\"-\"&'Timesheet raw data'!F180,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-16","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E181>0,'Timesheet raw data'!G181/'Timesheet raw data'!E181,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D181&I181","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D181<>\"\",'Timesheet raw data'!D181&\"-\"&'Timesheet raw data'!F181,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-16","Tenant1 Incident Management",8,{"$f":"IF(C182<>\"\",TEXT(YEAR(C182),\"0000\")&\"-\"&TEXT(MONTH(C182),\"00\"),\"\")","v":"2011-11"},720,{"$f":"IF('Timesheet raw data'!E182>0,'Timesheet raw data'!G182/'Timesheet raw data'!E182,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D182&I182","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D182<>\"\",'Timesheet raw data'!D182&\"-\"&'Timesheet raw data'!F182,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant1","2011-11-16","Tenant2 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E183>0,'Timesheet raw data'!G183/'Timesheet raw data'!E183,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D183&I183","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D183<>\"\",'Timesheet raw data'!D183&\"-\"&'Timesheet raw data'!F183,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect2","2011-11-16","Tenant2 Incident Management",2,"2011-11",192,{"$f":"IF('Timesheet raw data'!E184>0,'Timesheet raw data'!G184/'Timesheet raw data'!E184,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D184&I184","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D184<>\"\",'Timesheet raw data'!D184&\"-\"&'Timesheet raw data'!F184,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-17","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E185>0,'Timesheet raw data'!G185/'Timesheet raw data'!E185,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D185&I185","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D185<>\"\",'Timesheet raw data'!D185&\"-\"&'Timesheet raw data'!F185,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-17","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E186>0,'Timesheet raw data'!G186/'Timesheet raw data'!E186,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D186&I186","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D186<>\"\",'Timesheet raw data'!D186&\"-\"&'Timesheet raw data'!F186,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-17","Tenant1 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E187>0,'Timesheet raw data'!G187/'Timesheet raw data'!E187,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D187&I187","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D187<>\"\",'Timesheet raw data'!D187&\"-\"&'Timesheet raw data'!F187,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-17","Tenant1 Incident Management",1,"2011-11",96,{"$f":"IF('Timesheet raw data'!E188>0,'Timesheet raw data'!G188/'Timesheet raw data'!E188,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D188&I188","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D188<>\"\",'Timesheet raw data'!D188&\"-\"&'Timesheet raw data'!F188,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant1","2011-11-17","Tenant2 Incident Management",4,"2011-11",360,{"$f":"IF('Timesheet raw data'!E189>0,'Timesheet raw data'!G189/'Timesheet raw data'!E189,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D189&I189","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D189<>\"\",'Timesheet raw data'!D189&\"-\"&'Timesheet raw data'!F189,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-18","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E190>0,'Timesheet raw data'!G190/'Timesheet raw data'!E190,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D190&I190","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D190<>\"\",'Timesheet raw data'!D190&\"-\"&'Timesheet raw data'!F190,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Project Manager1","2011-11-18","Tenant1 Incident Management",2,"2011-11",200,{"$f":"IF('Timesheet raw data'!E191>0,'Timesheet raw data'!G191/'Timesheet raw data'!E191,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D191&I191","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D191<>\"\",'Timesheet raw data'!D191&\"-\"&'Timesheet raw data'!F191,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-18","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E192>0,'Timesheet raw data'!G192/'Timesheet raw data'!E192,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D192&I192","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D192<>\"\",'Timesheet raw data'!D192&\"-\"&'Timesheet raw data'!F192,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-18","Tenant1 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E193>0,'Timesheet raw data'!G193/'Timesheet raw data'!E193,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D193&I193","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D193<>\"\",'Timesheet raw data'!D193&\"-\"&'Timesheet raw data'!F193,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-18","Tenant1 Incident Management",0.75,"2011-11",72,{"$f":"IF('Timesheet raw data'!E194>0,'Timesheet raw data'!G194/'Timesheet raw data'!E194,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D194&I194","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D194<>\"\",'Timesheet raw data'!D194&\"-\"&'Timesheet raw data'!F194,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Project Manager1","2011-11-18","Tenant2 Incident Management",1,"2011-11",100,{"$f":"IF('Timesheet raw data'!E195>0,'Timesheet raw data'!G195/'Timesheet raw data'!E195,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D195&I195","v":"Tenant2 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D195<>\"\",'Timesheet raw data'!D195&\"-\"&'Timesheet raw data'!F195,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect2","2011-11-18","Tenant2 Incident Management",1,"2011-11",96,{"$f":"IF('Timesheet raw data'!E196>0,'Timesheet raw data'!G196/'Timesheet raw data'!E196,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D196&I196","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D196<>\"\",'Timesheet raw data'!D196&\"-\"&'Timesheet raw data'!F196,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-21","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E197>0,'Timesheet raw data'!G197/'Timesheet raw data'!E197,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D197&I197","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D197<>\"\",'Timesheet raw data'!D197&\"-\"&'Timesheet raw data'!F197,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-21","Tenant1 Incident Management",8,"2011-11",{"$f":"VLOOKUP(B198,Program.ResourceTable,3,FALSE)*E198","v":720},{"$f":"IF('Timesheet raw data'!E198>0,'Timesheet raw data'!G198/'Timesheet raw data'!E198,\"\")","v":90},{"$f":"IF(H198<>\"\",VLOOKUP(H198,Program.RateTable,2,FALSE),\"\")","v":"Sr Consultant"},{"$f":"'Timesheet raw data'!D198&I198","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D198<>\"\",'Timesheet raw data'!D198&\"-\"&'Timesheet raw data'!F198,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant1","2011-11-21","Tenant2 Incident Management",2,"2011-11",180,{"$f":"IF('Timesheet raw data'!E199>0,'Timesheet raw data'!G199/'Timesheet raw data'!E199,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D199&I199","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D199<>\"\",'Timesheet raw data'!D199&\"-\"&'Timesheet raw data'!F199,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect2","2011-11-21","Tenant2 Incident Management",1.5,"2011-11",144,{"$f":"IF('Timesheet raw data'!E200>0,'Timesheet raw data'!G200/'Timesheet raw data'!E200,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D200&I200","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D200<>\"\",'Timesheet raw data'!D200&\"-\"&'Timesheet raw data'!F200,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-22","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E201>0,'Timesheet raw data'!G201/'Timesheet raw data'!E201,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D201&I201","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D201<>\"\",'Timesheet raw data'!D201&\"-\"&'Timesheet raw data'!F201,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-22","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E202>0,'Timesheet raw data'!G202/'Timesheet raw data'!E202,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D202&I202","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D202<>\"\",'Timesheet raw data'!D202&\"-\"&'Timesheet raw data'!F202,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-22","Tenant1 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E203>0,'Timesheet raw data'!G203/'Timesheet raw data'!E203,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D203&I203","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D203<>\"\",'Timesheet raw data'!D203&\"-\"&'Timesheet raw data'!F203,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant1","2011-11-22","Tenant2 Incident Management",1,"2011-11",90,{"$f":"IF('Timesheet raw data'!E204>0,'Timesheet raw data'!G204/'Timesheet raw data'!E204,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D204&I204","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D204<>\"\",'Timesheet raw data'!D204&\"-\"&'Timesheet raw data'!F204,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect2","2011-11-22","Tenant2 Incident Management",1.5,"2011-11",144,{"$f":"IF('Timesheet raw data'!E205>0,'Timesheet raw data'!G205/'Timesheet raw data'!E205,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D205&I205","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D205<>\"\",'Timesheet raw data'!D205&\"-\"&'Timesheet raw data'!F205,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect3","2011-11-22","Tenant2 Incident Management",5,"2011-11",480,{"$f":"IF('Timesheet raw data'!E206>0,'Timesheet raw data'!G206/'Timesheet raw data'!E206,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D206&I206","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D206<>\"\",'Timesheet raw data'!D206&\"-\"&'Timesheet raw data'!F206,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-23","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E207>0,'Timesheet raw data'!G207/'Timesheet raw data'!E207,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D207&I207","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D207<>\"\",'Timesheet raw data'!D207&\"-\"&'Timesheet raw data'!F207,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-23","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E208>0,'Timesheet raw data'!G208/'Timesheet raw data'!E208,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D208&I208","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D208<>\"\",'Timesheet raw data'!D208&\"-\"&'Timesheet raw data'!F208,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-23","Tenant1 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E209>0,'Timesheet raw data'!G209/'Timesheet raw data'!E209,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D209&I209","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D209<>\"\",'Timesheet raw data'!D209&\"-\"&'Timesheet raw data'!F209,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-23","Tenant1 Incident Management",2,"2011-11",192,{"$f":"IF('Timesheet raw data'!E210>0,'Timesheet raw data'!G210/'Timesheet raw data'!E210,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D210&I210","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D210<>\"\",'Timesheet raw data'!D210&\"-\"&'Timesheet raw data'!F210,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-23","Tenant2 Incident Management",6,"2011-11",576,{"$f":"IF('Timesheet raw data'!E211>0,'Timesheet raw data'!G211/'Timesheet raw data'!E211,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D211&I211","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D211<>\"\",'Timesheet raw data'!D211&\"-\"&'Timesheet raw data'!F211,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect3","2011-11-23","Tenant2 Incident Management",1,"2011-11",96,{"$f":"IF('Timesheet raw data'!E212>0,'Timesheet raw data'!G212/'Timesheet raw data'!E212,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D212&I212","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D212<>\"\",'Timesheet raw data'!D212&\"-\"&'Timesheet raw data'!F212,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-24","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E213>0,'Timesheet raw data'!G213/'Timesheet raw data'!E213,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D213&I213","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D213<>\"\",'Timesheet raw data'!D213&\"-\"&'Timesheet raw data'!F213,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Associate Consultant2","2011-11-24","Tenant1 Incident Management",3.5,"2011-11",262.5,{"$f":"IF('Timesheet raw data'!E214>0,'Timesheet raw data'!G214/'Timesheet raw data'!E214,\"\")","v":75},"Associate Consultant",{"$f":"'Timesheet raw data'!D214&I214","v":"Tenant1 Incident ManagementAssociate Consultant"},{"$f":"IF('Timesheet raw data'!D214<>\"\",'Timesheet raw data'!D214&\"-\"&'Timesheet raw data'!F214,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-24","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E215>0,'Timesheet raw data'!G215/'Timesheet raw data'!E215,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D215&I215","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D215<>\"\",'Timesheet raw data'!D215&\"-\"&'Timesheet raw data'!F215,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-24","Tenant1 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E216>0,'Timesheet raw data'!G216/'Timesheet raw data'!E216,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D216&I216","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D216<>\"\",'Timesheet raw data'!D216&\"-\"&'Timesheet raw data'!F216,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-24","Tenant1 Incident Management",3,"2011-11",288,{"$f":"IF('Timesheet raw data'!E217>0,'Timesheet raw data'!G217/'Timesheet raw data'!E217,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D217&I217","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D217<>\"\",'Timesheet raw data'!D217&\"-\"&'Timesheet raw data'!F217,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-24","Tenant2 Incident Management",7,"2011-11",672,{"$f":"IF('Timesheet raw data'!E218>0,'Timesheet raw data'!G218/'Timesheet raw data'!E218,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D218&I218","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D218<>\"\",'Timesheet raw data'!D218&\"-\"&'Timesheet raw data'!F218,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-25","Tenant1 Incident Management",4,"2011-11",260,{"$f":"IF('Timesheet raw data'!E219>0,'Timesheet raw data'!G219/'Timesheet raw data'!E219,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D219&I219","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D219<>\"\",'Timesheet raw data'!D219&\"-\"&'Timesheet raw data'!F219,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-25","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E220>0,'Timesheet raw data'!G220/'Timesheet raw data'!E220,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D220&I220","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D220<>\"\",'Timesheet raw data'!D220&\"-\"&'Timesheet raw data'!F220,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-25","Tenant1 Incident Management",1,"2011-11",96,{"$f":"IF('Timesheet raw data'!E221>0,'Timesheet raw data'!G221/'Timesheet raw data'!E221,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D221&I221","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D221<>\"\",'Timesheet raw data'!D221&\"-\"&'Timesheet raw data'!F221,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect2","2011-11-25","Tenant2 Incident Management",6,"2011-11",576,{"$f":"IF('Timesheet raw data'!E222>0,'Timesheet raw data'!G222/'Timesheet raw data'!E222,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D222&I222","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D222<>\"\",'Timesheet raw data'!D222&\"-\"&'Timesheet raw data'!F222,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-25","Tenant2 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E223>0,'Timesheet raw data'!G223/'Timesheet raw data'!E223,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D223&I223","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D223<>\"\",'Timesheet raw data'!D223&\"-\"&'Timesheet raw data'!F223,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect3","2011-11-25","Tenant2 Incident Management",5,"2011-11",480,{"$f":"IF('Timesheet raw data'!E224>0,'Timesheet raw data'!G224/'Timesheet raw data'!E224,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D224&I224","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D224<>\"\",'Timesheet raw data'!D224&\"-\"&'Timesheet raw data'!F224,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Project Manager1","2011-11-26","Tenant1 Incident Management",2,"2011-11",200,{"$f":"IF('Timesheet raw data'!E225>0,'Timesheet raw data'!G225/'Timesheet raw data'!E225,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D225&I225","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D225<>\"\",'Timesheet raw data'!D225&\"-\"&'Timesheet raw data'!F225,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-28","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E226>0,'Timesheet raw data'!G226/'Timesheet raw data'!E226,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D226&I226","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D226<>\"\",'Timesheet raw data'!D226&\"-\"&'Timesheet raw data'!F226,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Associate Consultant2","2011-11-28","Tenant1 Incident Management",1,"2011-11",75,{"$f":"IF('Timesheet raw data'!E227>0,'Timesheet raw data'!G227/'Timesheet raw data'!E227,\"\")","v":75},"Associate Consultant",{"$f":"'Timesheet raw data'!D227&I227","v":"Tenant1 Incident ManagementAssociate Consultant"},{"$f":"IF('Timesheet raw data'!D227<>\"\",'Timesheet raw data'!D227&\"-\"&'Timesheet raw data'!F227,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-28","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E228>0,'Timesheet raw data'!G228/'Timesheet raw data'!E228,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D228&I228","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D228<>\"\",'Timesheet raw data'!D228&\"-\"&'Timesheet raw data'!F228,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-28","Tenant1 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E229>0,'Timesheet raw data'!G229/'Timesheet raw data'!E229,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D229&I229","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D229<>\"\",'Timesheet raw data'!D229&\"-\"&'Timesheet raw data'!F229,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-28","Tenant1 Incident Management",1,"2011-11",96,{"$f":"IF('Timesheet raw data'!E230>0,'Timesheet raw data'!G230/'Timesheet raw data'!E230,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D230&I230","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D230<>\"\",'Timesheet raw data'!D230&\"-\"&'Timesheet raw data'!F230,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-28","Tenant2 Incident Management",2,"2011-11",192,{"$f":"IF('Timesheet raw data'!E231>0,'Timesheet raw data'!G231/'Timesheet raw data'!E231,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D231&I231","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D231<>\"\",'Timesheet raw data'!D231&\"-\"&'Timesheet raw data'!F231,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-29","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E232>0,'Timesheet raw data'!G232/'Timesheet raw data'!E232,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D232&I232","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D232<>\"\",'Timesheet raw data'!D232&\"-\"&'Timesheet raw data'!F232,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Project Manager1","2011-11-29","Tenant1 Incident Management",1,"2011-11",100,{"$f":"IF('Timesheet raw data'!E233>0,'Timesheet raw data'!G233/'Timesheet raw data'!E233,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D233&I233","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D233<>\"\",'Timesheet raw data'!D233&\"-\"&'Timesheet raw data'!F233,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-29","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E234>0,'Timesheet raw data'!G234/'Timesheet raw data'!E234,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D234&I234","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D234<>\"\",'Timesheet raw data'!D234&\"-\"&'Timesheet raw data'!F234,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Sr Consultant4","2011-11-29","Tenant1 Incident Management",8,"2011-11",720,{"$f":"IF('Timesheet raw data'!E235>0,'Timesheet raw data'!G235/'Timesheet raw data'!E235,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D235&I235","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D235<>\"\",'Timesheet raw data'!D235&\"-\"&'Timesheet raw data'!F235,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-29","Tenant1 Incident Management",2,"2011-11",192,{"$f":"IF('Timesheet raw data'!E236>0,'Timesheet raw data'!G236/'Timesheet raw data'!E236,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D236&I236","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D236<>\"\",'Timesheet raw data'!D236&\"-\"&'Timesheet raw data'!F236,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect2","2011-11-29","Tenant2 Incident Management",0.5,"2011-11",48,{"$f":"IF('Timesheet raw data'!E237>0,'Timesheet raw data'!G237/'Timesheet raw data'!E237,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D237&I237","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D237<>\"\",'Timesheet raw data'!D237&\"-\"&'Timesheet raw data'!F237,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect3","2011-11-29","Tenant2 Incident Management",6,"2011-11",576,{"$f":"IF('Timesheet raw data'!E238>0,'Timesheet raw data'!G238/'Timesheet raw data'!E238,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D238&I238","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D238<>\"\",'Timesheet raw data'!D238&\"-\"&'Timesheet raw data'!F238,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant2","2011-11-30","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E239>0,'Timesheet raw data'!G239/'Timesheet raw data'!E239,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D239&I239","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D239<>\"\",'Timesheet raw data'!D239&\"-\"&'Timesheet raw data'!F239,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-30","Tenant1 Incident Management",1,"2011-11",96,{"$f":"IF('Timesheet raw data'!E240>0,'Timesheet raw data'!G240/'Timesheet raw data'!E240,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D240&I240","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D240<>\"\",'Timesheet raw data'!D240&\"-\"&'Timesheet raw data'!F240,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Architect3","2011-11-30","Tenant2 Incident Management",4,"2011-11",384,{"$f":"IF('Timesheet raw data'!E241>0,'Timesheet raw data'!G241/'Timesheet raw data'!E241,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D241&I241","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D241<>\"\",'Timesheet raw data'!D241&\"-\"&'Timesheet raw data'!F241,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Architect3","2011-11-30","Tenant2 Incident Management",2,"2011-11",192,{"$f":"IF('Timesheet raw data'!E242>0,'Timesheet raw data'!G242/'Timesheet raw data'!E242,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D242&I242","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D242<>\"\",'Timesheet raw data'!D242&\"-\"&'Timesheet raw data'!F242,\"\")","v":"Tenant2 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-11-30","Tenant1 Incident Management",2,"2011-11",130,{"$f":"IF('Timesheet raw data'!E243>0,'Timesheet raw data'!G243/'Timesheet raw data'!E243,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D243&I243","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D243<>\"\",'Timesheet raw data'!D243&\"-\"&'Timesheet raw data'!F243,\"\")","v":"Tenant1 Incident Management-2011-11"}]
[null,"Offshore Consultant1","2011-12-01","Tenant1 Incident Management",4,"2011-12",260,{"$f":"IF('Timesheet raw data'!E244>0,'Timesheet raw data'!G244/'Timesheet raw data'!E244,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D244&I244","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D244<>\"\",'Timesheet raw data'!D244&\"-\"&'Timesheet raw data'!F244,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Offshore Consultant2","2011-12-01","Tenant1 Incident Management",4,"2011-12",260,{"$f":"IF('Timesheet raw data'!E245>0,'Timesheet raw data'!G245/'Timesheet raw data'!E245,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D245&I245","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D245<>\"\",'Timesheet raw data'!D245&\"-\"&'Timesheet raw data'!F245,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant4","2011-12-01","Tenant1 Incident Management",8,{"$f":"IF(C246<>\"\",TEXT(YEAR(C246),\"0000\")&\"-\"&TEXT(MONTH(C246),\"00\"),\"\")","v":"2011-12"},720,{"$f":"IF('Timesheet raw data'!E246>0,'Timesheet raw data'!G246/'Timesheet raw data'!E246,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D246&I246","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D246<>\"\",'Timesheet raw data'!D246&\"-\"&'Timesheet raw data'!F246,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-01","Tenant2 Incident Management",4,"2011-12",384,{"$f":"IF('Timesheet raw data'!E247>0,'Timesheet raw data'!G247/'Timesheet raw data'!E247,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D247&I247","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D247<>\"\",'Timesheet raw data'!D247&\"-\"&'Timesheet raw data'!F247,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Architect3","2011-12-01","Tenant2 Incident Management",2,"2011-12",192,{"$f":"IF('Timesheet raw data'!E248>0,'Timesheet raw data'!G248/'Timesheet raw data'!E248,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D248&I248","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D248<>\"\",'Timesheet raw data'!D248&\"-\"&'Timesheet raw data'!F248,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Offshore Consultant1","2011-12-02","Tenant1 Incident Management",4,"2011-12",260,{"$f":"IF('Timesheet raw data'!E249>0,'Timesheet raw data'!G249/'Timesheet raw data'!E249,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D249&I249","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D249<>\"\",'Timesheet raw data'!D249&\"-\"&'Timesheet raw data'!F249,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Offshore Consultant2","2011-12-02","Tenant1 Incident Management",4,"2011-12",260,{"$f":"IF('Timesheet raw data'!E250>0,'Timesheet raw data'!G250/'Timesheet raw data'!E250,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D250&I250","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D250<>\"\",'Timesheet raw data'!D250&\"-\"&'Timesheet raw data'!F250,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant4","2011-12-02","Tenant1 Incident Management",8,"2011-12",720,{"$f":"IF('Timesheet raw data'!E251>0,'Timesheet raw data'!G251/'Timesheet raw data'!E251,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D251&I251","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D251<>\"\",'Timesheet raw data'!D251&\"-\"&'Timesheet raw data'!F251,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-02","Tenant1 Incident Management",5,"2011-12",480,{"$f":"IF('Timesheet raw data'!E252>0,'Timesheet raw data'!G252/'Timesheet raw data'!E252,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D252&I252","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D252<>\"\",'Timesheet raw data'!D252&\"-\"&'Timesheet raw data'!F252,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-02","Tenant2 Incident Management",2,"2011-12",192,{"$f":"IF('Timesheet raw data'!E253>0,'Timesheet raw data'!G253/'Timesheet raw data'!E253,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D253&I253","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D253<>\"\",'Timesheet raw data'!D253&\"-\"&'Timesheet raw data'!F253,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Offshore Consultant1","2011-12-05","Tenant1 Incident Management",2,"2011-12",130,{"$f":"IF('Timesheet raw data'!E254>0,'Timesheet raw data'!G254/'Timesheet raw data'!E254,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D254&I254","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D254<>\"\",'Timesheet raw data'!D254&\"-\"&'Timesheet raw data'!F254,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant4","2011-12-05","Tenant1 Incident Management",8,"2011-12",720,{"$f":"IF('Timesheet raw data'!E255>0,'Timesheet raw data'!G255/'Timesheet raw data'!E255,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D255&I255","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D255<>\"\",'Timesheet raw data'!D255&\"-\"&'Timesheet raw data'!F255,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-05","Tenant1 Incident Management",1,"2011-12",96,{"$f":"IF('Timesheet raw data'!E256>0,'Timesheet raw data'!G256/'Timesheet raw data'!E256,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D256&I256","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D256<>\"\",'Timesheet raw data'!D256&\"-\"&'Timesheet raw data'!F256,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect2","2011-12-05","Tenant2 Incident Management",0.5,"2011-12",48,{"$f":"IF('Timesheet raw data'!E257>0,'Timesheet raw data'!G257/'Timesheet raw data'!E257,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D257&I257","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D257<>\"\",'Timesheet raw data'!D257&\"-\"&'Timesheet raw data'!F257,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Architect3","2011-12-05","Tenant2 Incident Management",7,"2011-12",672,{"$f":"IF('Timesheet raw data'!E258>0,'Timesheet raw data'!G258/'Timesheet raw data'!E258,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D258&I258","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D258<>\"\",'Timesheet raw data'!D258&\"-\"&'Timesheet raw data'!F258,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Offshore Consultant1","2011-12-06","Tenant1 Incident Management",2,"2011-12",130,{"$f":"IF('Timesheet raw data'!E259>0,'Timesheet raw data'!G259/'Timesheet raw data'!E259,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D259&I259","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D259<>\"\",'Timesheet raw data'!D259&\"-\"&'Timesheet raw data'!F259,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant4","2011-12-06","Tenant1 Incident Management",8,"2011-12",720,{"$f":"IF('Timesheet raw data'!E260>0,'Timesheet raw data'!G260/'Timesheet raw data'!E260,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D260&I260","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D260<>\"\",'Timesheet raw data'!D260&\"-\"&'Timesheet raw data'!F260,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-06","Tenant1 Incident Management",2,"2011-12",192,{"$f":"IF('Timesheet raw data'!E261>0,'Timesheet raw data'!G261/'Timesheet raw data'!E261,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D261&I261","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D261<>\"\",'Timesheet raw data'!D261&\"-\"&'Timesheet raw data'!F261,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect2","2011-12-06","Tenant2 Incident Management",1,"2011-12",{"$f":"VLOOKUP(B262,Program.ResourceTable,3,FALSE)*E262","v":96},{"$f":"IF('Timesheet raw data'!E262>0,'Timesheet raw data'!G262/'Timesheet raw data'!E262,\"\")","v":96},{"$f":"IF(H262<>\"\",VLOOKUP(H262,Program.RateTable,2,FALSE),\"\")","v":"Architect"},{"$f":"'Timesheet raw data'!D262&I262","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D262<>\"\",'Timesheet raw data'!D262&\"-\"&'Timesheet raw data'!F262,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Architect3","2011-12-06","Tenant2 Incident Management",1.5,"2011-12",144,{"$f":"IF('Timesheet raw data'!E263>0,'Timesheet raw data'!G263/'Timesheet raw data'!E263,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D263&I263","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D263<>\"\",'Timesheet raw data'!D263&\"-\"&'Timesheet raw data'!F263,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Architect3","2011-12-06","Tenant2 Incident Management",4.5,"2011-12",432,{"$f":"IF('Timesheet raw data'!E264>0,'Timesheet raw data'!G264/'Timesheet raw data'!E264,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D264&I264","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D264<>\"\",'Timesheet raw data'!D264&\"-\"&'Timesheet raw data'!F264,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Offshore Consultant1","2011-12-07","Tenant1 Incident Management",2,"2011-12",130,{"$f":"IF('Timesheet raw data'!E265>0,'Timesheet raw data'!G265/'Timesheet raw data'!E265,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D265&I265","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D265<>\"\",'Timesheet raw data'!D265&\"-\"&'Timesheet raw data'!F265,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant4","2011-12-07","Tenant1 Incident Management",8,"2011-12",720,{"$f":"IF('Timesheet raw data'!E266>0,'Timesheet raw data'!G266/'Timesheet raw data'!E266,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D266&I266","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D266<>\"\",'Timesheet raw data'!D266&\"-\"&'Timesheet raw data'!F266,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-07","Tenant1 Incident Management",4,"2011-12",384,{"$f":"IF('Timesheet raw data'!E267>0,'Timesheet raw data'!G267/'Timesheet raw data'!E267,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D267&I267","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D267<>\"\",'Timesheet raw data'!D267&\"-\"&'Timesheet raw data'!F267,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect2","2011-12-07","Tenant2 Incident Management",2,"2011-12",192,{"$f":"IF('Timesheet raw data'!E268>0,'Timesheet raw data'!G268/'Timesheet raw data'!E268,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D268&I268","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D268<>\"\",'Timesheet raw data'!D268&\"-\"&'Timesheet raw data'!F268,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Architect3","2011-12-07","Tenant2 Incident Management",0.5,"2011-12",48,{"$f":"IF('Timesheet raw data'!E269>0,'Timesheet raw data'!G269/'Timesheet raw data'!E269,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D269&I269","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D269<>\"\",'Timesheet raw data'!D269&\"-\"&'Timesheet raw data'!F269,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Architect3","2011-12-07","Tenant2 Incident Management",1.5,"2011-12",144,{"$f":"IF('Timesheet raw data'!E270>0,'Timesheet raw data'!G270/'Timesheet raw data'!E270,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D270&I270","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D270<>\"\",'Timesheet raw data'!D270&\"-\"&'Timesheet raw data'!F270,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Offshore Consultant1","2011-12-08","Tenant1 Incident Management",2,"2011-12",130,{"$f":"IF('Timesheet raw data'!E271>0,'Timesheet raw data'!G271/'Timesheet raw data'!E271,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D271&I271","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D271<>\"\",'Timesheet raw data'!D271&\"-\"&'Timesheet raw data'!F271,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant4","2011-12-08","Tenant1 Incident Management",4,"2011-12",360,{"$f":"IF('Timesheet raw data'!E272>0,'Timesheet raw data'!G272/'Timesheet raw data'!E272,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D272&I272","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D272<>\"\",'Timesheet raw data'!D272&\"-\"&'Timesheet raw data'!F272,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-08","Tenant1 Incident Management",1,"2011-12",96,{"$f":"IF('Timesheet raw data'!E273>0,'Timesheet raw data'!G273/'Timesheet raw data'!E273,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D273&I273","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D273<>\"\",'Timesheet raw data'!D273&\"-\"&'Timesheet raw data'!F273,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-08","Tenant2 Incident Management",2,"2011-12",192,{"$f":"IF('Timesheet raw data'!E274>0,'Timesheet raw data'!G274/'Timesheet raw data'!E274,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D274&I274","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D274<>\"\",'Timesheet raw data'!D274&\"-\"&'Timesheet raw data'!F274,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Architect3","2011-12-08","Tenant2 Incident Management",6,"2011-12",576,{"$f":"IF('Timesheet raw data'!E275>0,'Timesheet raw data'!G275/'Timesheet raw data'!E275,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D275&I275","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D275<>\"\",'Timesheet raw data'!D275&\"-\"&'Timesheet raw data'!F275,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Offshore Consultant1","2011-12-09","Tenant1 Incident Management",4,"2011-12",260,{"$f":"IF('Timesheet raw data'!E276>0,'Timesheet raw data'!G276/'Timesheet raw data'!E276,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D276&I276","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D276<>\"\",'Timesheet raw data'!D276&\"-\"&'Timesheet raw data'!F276,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant4","2011-12-09","Tenant1 Incident Management",8,"2011-12",720,{"$f":"IF('Timesheet raw data'!E277>0,'Timesheet raw data'!G277/'Timesheet raw data'!E277,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D277&I277","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D277<>\"\",'Timesheet raw data'!D277&\"-\"&'Timesheet raw data'!F277,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-09","Tenant1 Incident Management",1.5,"2011-12",144,{"$f":"IF('Timesheet raw data'!E278>0,'Timesheet raw data'!G278/'Timesheet raw data'!E278,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D278&I278","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D278<>\"\",'Timesheet raw data'!D278&\"-\"&'Timesheet raw data'!F278,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect2","2011-12-09","Tenant2 Incident Management",4,"2011-12",384,{"$f":"IF('Timesheet raw data'!E279>0,'Timesheet raw data'!G279/'Timesheet raw data'!E279,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D279&I279","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D279<>\"\",'Timesheet raw data'!D279&\"-\"&'Timesheet raw data'!F279,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Architect3","2011-12-09","Tenant2 Incident Management",5,"2011-12",480,{"$f":"IF('Timesheet raw data'!E280>0,'Timesheet raw data'!G280/'Timesheet raw data'!E280,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D280&I280","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D280<>\"\",'Timesheet raw data'!D280&\"-\"&'Timesheet raw data'!F280,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Offshore Consultant1","2011-12-12","Tenant1 Incident Management",4,"2011-12",260,{"$f":"IF('Timesheet raw data'!E281>0,'Timesheet raw data'!G281/'Timesheet raw data'!E281,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D281&I281","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D281<>\"\",'Timesheet raw data'!D281&\"-\"&'Timesheet raw data'!F281,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Project Manager1","2011-12-12","Tenant1 Incident Management",1,"2011-12",100,{"$f":"IF('Timesheet raw data'!E282>0,'Timesheet raw data'!G282/'Timesheet raw data'!E282,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D282&I282","v":"Tenant1 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D282<>\"\",'Timesheet raw data'!D282&\"-\"&'Timesheet raw data'!F282,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant4","2011-12-12","Tenant1 Incident Management",8,"2011-12",720,{"$f":"IF('Timesheet raw data'!E283>0,'Timesheet raw data'!G283/'Timesheet raw data'!E283,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D283&I283","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D283<>\"\",'Timesheet raw data'!D283&\"-\"&'Timesheet raw data'!F283,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-12","Tenant1 Incident Management",2,"2011-12",192,{"$f":"IF('Timesheet raw data'!E284>0,'Timesheet raw data'!G284/'Timesheet raw data'!E284,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D284&I284","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D284<>\"\",'Timesheet raw data'!D284&\"-\"&'Timesheet raw data'!F284,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Project Manager1","2011-12-12","Tenant2 Incident Management",1,"2011-12",100,{"$f":"IF('Timesheet raw data'!E285>0,'Timesheet raw data'!G285/'Timesheet raw data'!E285,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D285&I285","v":"Tenant2 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D285<>\"\",'Timesheet raw data'!D285&\"-\"&'Timesheet raw data'!F285,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Architect3","2011-12-12","Tenant2 Incident Management",2,"2011-12",192,{"$f":"IF('Timesheet raw data'!E286>0,'Timesheet raw data'!G286/'Timesheet raw data'!E286,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D286&I286","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D286<>\"\",'Timesheet raw data'!D286&\"-\"&'Timesheet raw data'!F286,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Offshore Consultant1","2011-12-13","Tenant1 Incident Management",4,"2011-12",260,{"$f":"IF('Timesheet raw data'!E287>0,'Timesheet raw data'!G287/'Timesheet raw data'!E287,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D287&I287","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D287<>\"\",'Timesheet raw data'!D287&\"-\"&'Timesheet raw data'!F287,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant4","2011-12-13","Tenant1 Incident Management",8,"2011-12",720,{"$f":"IF('Timesheet raw data'!E288>0,'Timesheet raw data'!G288/'Timesheet raw data'!E288,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D288&I288","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D288<>\"\",'Timesheet raw data'!D288&\"-\"&'Timesheet raw data'!F288,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-13","Tenant1 Incident Management",1,"2011-12",96,{"$f":"IF('Timesheet raw data'!E289>0,'Timesheet raw data'!G289/'Timesheet raw data'!E289,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D289&I289","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D289<>\"\",'Timesheet raw data'!D289&\"-\"&'Timesheet raw data'!F289,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant2","2011-12-13","Tenant2 Incident Management",4,"2011-12",360,{"$f":"IF('Timesheet raw data'!E290>0,'Timesheet raw data'!G290/'Timesheet raw data'!E290,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D290&I290","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D290<>\"\",'Timesheet raw data'!D290&\"-\"&'Timesheet raw data'!F290,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Architect3","2011-12-13","Tenant2 Incident Management",2,"2011-12",192,{"$f":"IF('Timesheet raw data'!E291>0,'Timesheet raw data'!G291/'Timesheet raw data'!E291,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D291&I291","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D291<>\"\",'Timesheet raw data'!D291&\"-\"&'Timesheet raw data'!F291,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Offshore Consultant1","2011-12-14","Tenant1 Incident Management",4,"2011-12",260,{"$f":"IF('Timesheet raw data'!E292>0,'Timesheet raw data'!G292/'Timesheet raw data'!E292,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D292&I292","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D292<>\"\",'Timesheet raw data'!D292&\"-\"&'Timesheet raw data'!F292,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant4","2011-12-14","Tenant1 Incident Management",8,"2011-12",720,{"$f":"IF('Timesheet raw data'!E293>0,'Timesheet raw data'!G293/'Timesheet raw data'!E293,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D293&I293","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D293<>\"\",'Timesheet raw data'!D293&\"-\"&'Timesheet raw data'!F293,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-14","Tenant1 Incident Management",1.5,"2011-12",144,{"$f":"IF('Timesheet raw data'!E294>0,'Timesheet raw data'!G294/'Timesheet raw data'!E294,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D294&I294","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D294<>\"\",'Timesheet raw data'!D294&\"-\"&'Timesheet raw data'!F294,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-14","Tenant2 Incident Management",1,"2011-12",96,{"$f":"IF('Timesheet raw data'!E295>0,'Timesheet raw data'!G295/'Timesheet raw data'!E295,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D295&I295","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D295<>\"\",'Timesheet raw data'!D295&\"-\"&'Timesheet raw data'!F295,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Architect3","2011-12-14","Tenant2 Incident Management",2,"2011-12",192,{"$f":"IF('Timesheet raw data'!E296>0,'Timesheet raw data'!G296/'Timesheet raw data'!E296,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D296&I296","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D296<>\"\",'Timesheet raw data'!D296&\"-\"&'Timesheet raw data'!F296,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Offshore Consultant1","2011-12-15","Tenant1 Incident Management",4,"2011-12",260,{"$f":"IF('Timesheet raw data'!E297>0,'Timesheet raw data'!G297/'Timesheet raw data'!E297,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D297&I297","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D297<>\"\",'Timesheet raw data'!D297&\"-\"&'Timesheet raw data'!F297,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant4","2011-12-15","Tenant1 Incident Management",8,"2011-12",720,{"$f":"IF('Timesheet raw data'!E298>0,'Timesheet raw data'!G298/'Timesheet raw data'!E298,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D298&I298","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D298<>\"\",'Timesheet raw data'!D298&\"-\"&'Timesheet raw data'!F298,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-15","Tenant1 Incident Management",3,"2011-12",288,{"$f":"IF('Timesheet raw data'!E299>0,'Timesheet raw data'!G299/'Timesheet raw data'!E299,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D299&I299","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D299<>\"\",'Timesheet raw data'!D299&\"-\"&'Timesheet raw data'!F299,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Project Manager1","2011-12-15","Tenant2 Incident Management",1,"2011-12",100,{"$f":"IF('Timesheet raw data'!E300>0,'Timesheet raw data'!G300/'Timesheet raw data'!E300,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D300&I300","v":"Tenant2 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D300<>\"\",'Timesheet raw data'!D300&\"-\"&'Timesheet raw data'!F300,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Architect3","2011-12-15","Tenant2 Incident Management",2.5,"2011-12",240,{"$f":"IF('Timesheet raw data'!E301>0,'Timesheet raw data'!G301/'Timesheet raw data'!E301,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D301&I301","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D301<>\"\",'Timesheet raw data'!D301&\"-\"&'Timesheet raw data'!F301,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Offshore Consultant1","2011-12-16","Tenant1 Incident Management",4,"2011-12",260,{"$f":"IF('Timesheet raw data'!E302>0,'Timesheet raw data'!G302/'Timesheet raw data'!E302,\"\")","v":65},"Offshore Consultant",{"$f":"'Timesheet raw data'!D302&I302","v":"Tenant1 Incident ManagementOffshore Consultant"},{"$f":"IF('Timesheet raw data'!D302<>\"\",'Timesheet raw data'!D302&\"-\"&'Timesheet raw data'!F302,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant4","2011-12-16","Tenant1 Incident Management",4,"2011-12",360,{"$f":"IF('Timesheet raw data'!E303>0,'Timesheet raw data'!G303/'Timesheet raw data'!E303,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D303&I303","v":"Tenant1 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D303<>\"\",'Timesheet raw data'!D303&\"-\"&'Timesheet raw data'!F303,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Architect3","2011-12-16","Tenant1 Incident Management",1.5,"2011-12",144,{"$f":"IF('Timesheet raw data'!E304>0,'Timesheet raw data'!G304/'Timesheet raw data'!E304,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D304&I304","v":"Tenant1 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D304<>\"\",'Timesheet raw data'!D304&\"-\"&'Timesheet raw data'!F304,\"\")","v":"Tenant1 Incident Management-2011-12"}]
[null,"Sr Consultant2","2011-12-16","Tenant2 Incident Management",8,"2011-12",720,{"$f":"IF('Timesheet raw data'!E305>0,'Timesheet raw data'!G305/'Timesheet raw data'!E305,\"\")","v":90},"Sr Consultant",{"$f":"'Timesheet raw data'!D305&I305","v":"Tenant2 Incident ManagementSr Consultant"},{"$f":"IF('Timesheet raw data'!D305<>\"\",'Timesheet raw data'!D305&\"-\"&'Timesheet raw data'!F305,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Project Manager1","2011-12-16","Tenant2 Incident Management",1,"2011-12",100,{"$f":"IF('Timesheet raw data'!E306>0,'Timesheet raw data'!G306/'Timesheet raw data'!E306,\"\")","v":100},"Project Manager",{"$f":"'Timesheet raw data'!D306&I306","v":"Tenant2 Incident ManagementProject Manager"},{"$f":"IF('Timesheet raw data'!D306<>\"\",'Timesheet raw data'!D306&\"-\"&'Timesheet raw data'!F306,\"\")","v":"Tenant2 Incident Management-2011-12"}]
[null,"Architect3","2011-12-16","Tenant2 Incident Management",6,"2011-12",576,{"$f":"IF('Timesheet raw data'!E307>0,'Timesheet raw data'!G307/'Timesheet raw data'!E307,\"\")","v":96},"Architect",{"$f":"'Timesheet raw data'!D307&I307","v":"Tenant2 Incident ManagementArchitect"},{"$f":"IF('Timesheet raw data'!D307<>\"\",'Timesheet raw data'!D307&\"-\"&'Timesheet raw data'!F307,\"\")","v":"Tenant2 Incident Management-2011-12"}]

{"sheet":"Estimate to complete","index":5,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["ETC"]
[null,"Project Estimate to Complete"]
[null,"Program:",{"$f":"Cover.ProgramName","v":"DEMO"}]
[]
[null,"Update estimate to complete for each project weekly!"]
[null,null,"Status for Project ","Tenant1"]
[null,"Role",{"$f":"E25","v":"Available MD"},{"$f":"E16","v":"Remaining work planned"},"Avail (+) MD / Overrun (-) MD","Hrl. Rates","Avail (+) Cost / Overrun (-) Cost"]
[null,"Project Manager",12.875,{"$f":"E17","v":11.4},{"$f":"C8-D8","v":1.4749999999999996},100,{"$f":"F8*8*E8","v":1179.9999999999998}]
[null,"Architect",1.84375,0,1.84375,96,1416]
[null,"Senior Consultant",7.25,10.5,-3.25,90,-2340]
[null,"Associate Consultant",{"$f":"E29","v":9.8125},{"$f":"E20","v":9},0.8125,75,487.5]
[null,"Offshore Delivery",{"$f":"E30","v":-7},{"$f":"E21","v":0},-7,65,-3640]
[null,"Sum",{"$f":"E31","v":24.78125},{"$f":"SUM(D8:D12)","v":30.9},{"$f":"SUM(E8:E12)","v":-6.1187500000000004},{"$f":"SUM(F8:F12)","v":426},{"$f":"SUM(G8:G12)","v":-2896.5}]
[null,null,null,null,{"$f":"E13/C22","v":-4.6619047619047622E-2},null,{"$f":"G13/((C17*F8+C18*F9+C19*F10+C20*F11+C21*F12)*8)","v":-3.2162606320371316E-2}]
[null,"Project Plan"]
[null,"Role","Estimated MD + CRs","Actual Work planned","Remaining work planned"]
[null,"Project Manager",{"$f":"C26","v":20},8.6,{"$f":"C17-D17","v":11.4}]
[null,"Architect",{"$f":"C27","v":21},21,0]
[null,"Senior Consultant",49,38.5,10.5]
[null,"Associate Consultant",{"$f":"C29","v":15},6,9]
[null,"Offshore Delivery",{"$f":"C30","v":26.25},26.25,0]
[null,"Sum",{"$f":"SUM(C17:C21)","v":131.25},{"$f":"SUM(D17:D21)","v":100.35},{"$f":"SUM(E17:E21)","v":30.9}]
[]
[null,"Timesheets / Actual work"]
[null,"Role","Estimated MD + CRs","Actual work performed","Available MD"]
[null,"Project Manager",{"$f":"Program.Tenant1.PMTotalHours/8","v":20},{"$f":"Program.Tenant1.ActPMHours/8","v":7.125},{"$f":"C26-D26","v":12.875}]
[null,"Architect",{"$f":"Program.Tenant1.ArchTotalHours/8","v":21},{"$f":"Program.Tenant1.ActArchHours/8","v":19.15625},1.84375]
[null,"Senior Consultant",{"$f":"Program.Tenant1.SrConsTotalHours/8","v":49},{"$f":"Program.Tenant1.ActSrConsHours/8","v":41.75},7.25]
[null,"Associate Consultant",{"$f":"Program.Tenant1.AssocTotalHours/8","v":15},{"$f":"Program.Tenant1.ActAssConsHours/8","v":5.1875},9.8125]
[null,"Offshore Delivery",{"$f":"Program.Tenant1.OffshTotalHours/8","v":26.25},{"$f":"Program.Tenant1.ActOffshHours/8","v":33.25},-7]
[null,"Sum",{"$f":"SUM(C26:C30)","v":131.25},{"$f":"SUM(D26:D30)","v":106.46875},{"$f":"SUM(E26:E30)","v":24.78125}]

{"sheet":"Rolling plan","index":6,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["rollingplan",""]
[null,"Rolling Plan"]
[null,"Program:",{"$f":"Cover.ProgramName","v":"DEMO"}]
[null,"Update rolling plan with cutomer weekly!",null,null,"Calendar Week",{"$f":"TRUNC((D5-DATE(YEAR(D5+3-MOD(D5-2,7)),1,MOD(D5-2,7)-9))/7)","v":48},null,null,null,{"$f":"rollingplan.WeekHeader","v":"Calendar Week"},{"$f":"TRUNC((I5-DATE(YEAR(I5+3-MOD(I5-2,7)),1,MOD(I5-2,7)-9))/7)","v":49}]
[null,"Project within Program",null,"2011-11-28","2011-11-29","2011-11-30","2011-12-01","2011-12-02","2011-12-05","2011-12-06","2011-12-07","2011-12-08","2011-12-09"]
[null,"Dev Env.",null,"CA Tenant 2\nDevelopment","CA Tenant 2\nDevelopment","CA Tenant 2\nDevelopment","CA Tenant 2\nDevelopment","CA Tenant 2\nDevelopment","CA Tenant 2\nDevelopment","CA Tenant 2\nDevelopment","CA Tenant 2\nDevelopment","CA Tenant 2\nDevelopment","CA Tenant 2\nDevelopment"]
[null,"QA Env.",null,"Free","CA Tenant2 Testing","CA Tenant2 Testing","CA Tenant2 Testing","CA Tenant2 Testing","CA Tenant2 Testing","CA Tenant2 Testing","CA Tenant2 Testing","CA Tenant2 Testing","CA Tenant2 Testing"]
[null,"Prod Env.",null,"Production","Production","Production","Production","Production","Production","Production","Production","Production","Production"]
[null,"Project-TM1 Tenant1","CA Resource","CA Architect1","CA Architect1\nCA Archtect2","CA Architect1\nCA Archtect2","CA Architect1\nCA Archtect2","CA Architect1\nCA Archtect2","CA Architect1","CA Architect1\nCA Archtect2"]
[null,"Project-TM1 Tenant1","Task(s)","Functional design for request and change managmeent","Requirement specification for request and change management","Requirement specification for request and change management","Requirement specification for request and change management","Requirement specification for request and change management","Review requirement specification","Requirement specification signoff"]
[null,"Project-TM1 Tenant1","Expected Output / Deliverable",null,null,null,null,"Requirement Specification"]
[null,"Project-TM1 Tenant1","Customer SME",null,null,null,null,"Customer lead Architect1","Customer lead Architect1","Customer lead Architect1"]
[null,"Project-TM2 Tenant2","CA Resource","CA Sr Consultant1","CA Sr Consultant1","CA Sr Consultant1","CA Sr Consultant1\nCA Offshore consultant1","CA Sr Consultant1","CA Sr Consultant1","CA Sr Consultant1","CA Sr Consultant1","CA Sr Consultant1","CA Sr Consultant1"]
[null,"Project-TM2 Tenant2","Task(s)"]
[null,"Project-TM2 Tenant2","Expected Output / Deliverable","On-Site\nMove to QA environment.","On-Site\nMove to QA environment.","Documentation updates and technical testing to prepare for handover of QA","Documentation updates and technical testing to prepare for handover of QA\nRemote Work\nMove to QA environment.","Documentation updates and technical testing to prepare for handover of QA",null,"UAT1\nin Vienna","UAT1\nin Vienna","Remote \nRework for UAT1\nUpdating Release documentation and applying changes to QA environment","Remote \nRework for UAT1\nUpdating Release documentation and applying changes to QA environment"]
[null,"Project-TM2 Tenant2","Customer  SME"]
[null,"Project-TM3 Tenant3","CA Resource"]
[null,"Project-TM3 Tenant3","Task(s)"]
[null,"Project-TM3 Tenant3","Expected Output / Deliverable"]
[null,"Project-TM3 Tenant3","Customer  SME"]

{"sheet":"Traffic Light report","index":7,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[36,3,36,4],[42,3,42,4]]}
["traffic_light_report"]
[null,"Traffic Light Report",null,null,null,null,null,null,null,null,null,null,"Enter \"TLR_G\" for a green traffic light. \"TLR_Y\" / \"TLR_R\" for yellow and red.\nThen hit button \"Update Traffic Lights\""]
[null,"Program:",{"$f":"Cover.ProgramName","v":"DEMO"}]
[null,"Update traffic light report every month!"]
[null,"Program",null,null,null,null,null,"As of December 2011"]
[]
[null,"Expected program benefits",null,null,null,"Status",null,"Trend"]
[null,null,"Availability of resources","Prevent Incidents from happening and to minimize the Impact of Incidents that cannot be prevented.",null,"TLR_G",null,"TLR_G"]
[null,null,null,"< Enter short status in this line>"]
[null,null,"Roll Out capability","Integration of Service Desk with external systems \"A\" and \"B\". ",null,"TLR_G",null,"TLR_G"]
[null,null,null,"< Enter short status in this line>"]
[null,null,"Reduce Costs","Base infrastructure for the on-boarding of multiple tenants on a single physical system.",null,"TLR_G",null,"TLR_G"]
[null,null,null,"< Enter short status in this line>"]
[null,null,"Aligned Planing","Planning aligned to intial program plan",null,"TLR_G",null,"TLR_G"]
[null,null,null,"< Enter short status in this line>"]
[null,null,"Faster and constant success","Regular progress with regard to requiremnets of the business.",null,"TLR_Y",null,"TLR_Y"]
[]
[]
[null,"Projects"]
[]
[null,"Project Status","Ongoing",null,null,"Overall Status","Schedule","Budget","Scope","Resources"]
[null,null,"Tenant3 Incident Management","Implement Incident Management for \nTenant 3",null,"TLR_G","TLR_Y","TLR_G","TLR_G","TLR_G"]
[]
[]
[null,null,null,null,null,"< Enter short status in this line>"]
[null,null,"Tenant2 Problem Management","Implement Problem Management for \nTenant 2",null,"TLR_G","TLR_G","TLR_G","TLR_G","TLR_G"]
[]
[]
[]
[null,null,null,null,null,"< Enter short status in this line>"]
[null,null,"Finished",null,null,"Overall Status","Schedule","Budget","Scope","Resources"]
[null,null,"Tenant1 Incident Management","Implement Incident Management for \nTenant 1",null,"TLR_G","TLR_G","TLR_G","TLR_G","TLR_G"]
[null,null,null,null,null,"< Enter short status in this line>"]
[null,null,"New / Eval",null,null,"Overall Status"]
[null,null,"Tenant 1 Change Management","Implement Change Management for \nTenant 1",null,"TLR_G"]
[null,null,null,null,null,"< Enter short status in this line>"]
[]
[null,"Reporting categories","Dimension","Project - Green","Project - Amber","Project - Red"]
[null,null,"Schedule","Next Milestone and overall plans on track.","Issues achieving next Milestone and/or overall timeline.","Next milestone and/or overall timeline will not be met."]
[null,null,"Budget","Currently within budget and forecast to remain within budget.","Currently not in budget and/or overall budget will be exceeded by <5%.","Currently not in budget and/or overall budget will be exceeded by >5%."]
[null,null,"Scope","Scope and objectives are agreed with all stakeholders and can be met.","Different understanding within stakeholder and/or objectives are in danger.","Scope/Objectives cannot be met currently."]
[null,null,"Resources","Staffing is appropriate","Issues with staffing.","Cannot be executed with current staffing. "]
[]
[]
[]
[]
[null,"Do not delete these traffic lights which are the base for the images above!"]

{"sheet":"Scoreboard Risiken u. Chancen","index":8,"n_rows":24,"n_cols":29,"rows_kept":24,"cut":false,"hidden":false,"merged":[[13,3,14,4],[13,5,14,6],[13,7,14,8],[13,9,14,10],[13,11,14,12],[11,13,12,14],[11,15,12,16],[11,17,12,18],[13,19,14,20],[13,21,14,22],[11,19,12,20],[11,21,12,22],[13,13,14,14],[13,15,14,16],[13,17,14,18],[11,3,12,4],[11,5,12,6],[11,7,12,8],[11,9,12,10],[11,11,12,12],[7,21,8,22],[9,3,10,4],[9,5,10,6],[9,7,10,8],[9,9,10,10],[9,11,10,12],[9,13,10,14],[9,15,10,16],[9,17,10,18],[9,19,10,20],[9,21,10,22],[7,11,8,12],[7,13,8,14],[7,15,8,16],[7,17,8,18],[7,19,8,20],[4,1,15,1],[4,24,15,24],[5,3,6,4],[5,5,6,6],[5,7,6,8],[5,9,6,10],[5,11,6,12],[5,13,6,14],[5,15,6,16],[5,17,6,18],[5,19,6,20],[5,21,6,22],[7,3,8,4],[7,5,8,6],[7,7,8,8],[7,9,8,10]]}
[]
[null,"Scoreboard der Risiken und Chancen"]
[null,null,"Übersicht der Risiken",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Übersicht der Chancen",null,null,null,"percent ranges","exposure ranges"]
[null,null,null,"Auswirkungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auswirkungen",null,null,null,null,15,2]
[null,"Wahrscheinlichkeit in %",null,{"$f":"D16","v":1},{"$f":"E16","v":2},3,4,5,6,7,8,9,10,10,9,8,7,6,5,4,3,2,1,null,"Wahrscheinlichkeit in %",null,null,35,4]
[null,null,100,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C7, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C6, 'Detailbewertung Risiken'!$E:$E,\">\"&D$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &E$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C7, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C6, 'Detailbewertung Risiken'!$E:$E,\">\"&F$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &G$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C7, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C6, 'Detailbewertung Risiken'!$E:$E,\">\"&H$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &I$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C7, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C6, 'Detailbewertung Risiken'!$E:$E,\">\"&J$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &K$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C7, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C6, 'Detailbewertung Risiken'!$E:$E,\">\"&L$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &M$16)","v":1},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C7, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C6, 'Detailbewertung Chancen'!$E:$E,\"<=\"&N$16, 'Detailbewertung Chancen'!$E:$E,\">\" &O$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C7, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C6, 'Detailbewertung Chancen'!$E:$E,\"<=\"&P$16, 'Detailbewertung Chancen'!$E:$E,\">\" &Q$16)","v":1},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C7, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C6, 'Detailbewertung Chancen'!$E:$E,\"<=\"&R$16, 'Detailbewertung Chancen'!$E:$E,\">\" &S$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C7, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C6, 'Detailbewertung Chancen'!$E:$E,\"<=\"&T$16, 'Detailbewertung Chancen'!$E:$E,\">\" &U$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C7, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C6, 'Detailbewertung Chancen'!$E:$E,\"<=\"&V$16, 'Detailbewertung Chancen'!$E:$E,\">\" &W$16)","v":0},null,{"$f":"C6","v":100},null,null,null,65,6]
[null,null,81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,null,null,null,85,8]
[null,null,80,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C9, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C8, 'Detailbewertung Risiken'!$E:$E,\">\"&D$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &E$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C9, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C8, 'Detailbewertung Risiken'!$E:$E,\">\"&F$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &G$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C9, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C8, 'Detailbewertung Risiken'!$E:$E,\">\"&H$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &I$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C9, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C8, 'Detailbewertung Risiken'!$E:$E,\">\"&J$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &K$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C9, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C8, 'Detailbewertung Risiken'!$E:$E,\">\"&L$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &M$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C9, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C8, 'Detailbewertung Chancen'!$E:$E,\"<=\"&N$16, 'Detailbewertung Chancen'!$E:$E,\">\" &O$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C9, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C8, 'Detailbewertung Chancen'!$E:$E,\"<=\"&P$16, 'Detailbewertung Chancen'!$E:$E,\">\" &Q$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C9, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C8, 'Detailbewertung Chancen'!$E:$E,\"<=\"&R$16, 'Detailbewertung Chancen'!$E:$E,\">\" &S$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C9, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C8, 'Detailbewertung Chancen'!$E:$E,\"<=\"&T$16, 'Detailbewertung Chancen'!$E:$E,\">\" &U$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C9, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C8, 'Detailbewertung Chancen'!$E:$E,\"<=\"&V$16, 'Detailbewertung Chancen'!$E:$E,\">\" &W$16)","v":0},null,80,null,null,null,null,10]
[null,null,61,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61]
[null,null,60,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C11, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C10, 'Detailbewertung Risiken'!$E:$E,\">\"&D$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &E$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C11, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C10, 'Detailbewertung Risiken'!$E:$E,\">\"&F$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &G$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C11, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C10, 'Detailbewertung Risiken'!$E:$E,\">\"&H$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &I$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C11, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C10, 'Detailbewertung Risiken'!$E:$E,\">\"&J$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &K$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C11, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C10, 'Detailbewertung Risiken'!$E:$E,\">\"&L$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &M$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C11, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C10, 'Detailbewertung Chancen'!$E:$E,\"<=\"&N$16, 'Detailbewertung Chancen'!$E:$E,\">\" &O$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C11, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C10, 'Detailbewertung Chancen'!$E:$E,\"<=\"&P$16, 'Detailbewertung Chancen'!$E:$E,\">\" &Q$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C11, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C10, 'Detailbewertung Chancen'!$E:$E,\"<=\"&R$16, 'Detailbewertung Chancen'!$E:$E,\">\" &S$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C11, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C10, 'Detailbewertung Chancen'!$E:$E,\"<=\"&T$16, 'Detailbewertung Chancen'!$E:$E,\">\" &U$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C11, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C10, 'Detailbewertung Chancen'!$E:$E,\"<=\"&V$16, 'Detailbewertung Chancen'!$E:$E,\">\" &W$16)","v":0},null,60]
[null,null,41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,40,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C13, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C12, 'Detailbewertung Risiken'!$E:$E,\">\"&D$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &E$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C13, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C12, 'Detailbewertung Risiken'!$E:$E,\">\"&F$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &G$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C13, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C12, 'Detailbewertung Risiken'!$E:$E,\">\"&H$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &I$16)","v":1},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C13, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C12, 'Detailbewertung Risiken'!$E:$E,\">\"&J$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &K$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C13, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C12, 'Detailbewertung Risiken'!$E:$E,\">\"&L$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &M$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C13, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C12, 'Detailbewertung Chancen'!$E:$E,\"<=\"&N$16, 'Detailbewertung Chancen'!$E:$E,\">\" &O$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C13, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C12, 'Detailbewertung Chancen'!$E:$E,\"<=\"&P$16, 'Detailbewertung Chancen'!$E:$E,\">\" &Q$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C13, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C12, 'Detailbewertung Chancen'!$E:$E,\"<=\"&R$16, 'Detailbewertung Chancen'!$E:$E,\">\" &S$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C13, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C12, 'Detailbewertung Chancen'!$E:$E,\"<=\"&T$16, 'Detailbewertung Chancen'!$E:$E,\">\" &U$16)","v":1},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C13, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C12, 'Detailbewertung Chancen'!$E:$E,\"<=\"&V$16, 'Detailbewertung Chancen'!$E:$E,\">\" &W$16)","v":0},null,40]
[null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,20,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C15, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C14, 'Detailbewertung Risiken'!$E:$E,\">\"&D$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &E$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C15, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C14, 'Detailbewertung Risiken'!$E:$E,\">\"&F$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &G$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C15, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C14, 'Detailbewertung Risiken'!$E:$E,\">\"&H$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &I$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C15, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C14, 'Detailbewertung Risiken'!$E:$E,\">\"&J$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &K$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Risiken'!$D:$D, \">=\" & $C15, 'Detailbewertung Risiken'!$D:$D, \"<\" &$C14, 'Detailbewertung Risiken'!$E:$E,\">\"&L$16, 'Detailbewertung Risiken'!$E:$E,\"<=\" &M$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C15, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C14, 'Detailbewertung Chancen'!$E:$E,\"<=\"&N$16, 'Detailbewertung Chancen'!$E:$E,\">\" &O$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C15, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C14, 'Detailbewertung Chancen'!$E:$E,\"<=\"&P$16, 'Detailbewertung Chancen'!$E:$E,\">\" &Q$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C15, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C14, 'Detailbewertung Chancen'!$E:$E,\"<=\"&R$16, 'Detailbewertung Chancen'!$E:$E,\">\" &S$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C15, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C14, 'Detailbewertung Chancen'!$E:$E,\"<=\"&T$16, 'Detailbewertung Chancen'!$E:$E,\">\" &U$16)","v":0},null,{"$f":"COUNTIFS('Detailbewertung Chancen'!$D:$D, \">=\" & $C15, 'Detailbewertung Chancen'!$D:$D, \"<\" &$C14, 'Detailbewertung Chancen'!$E:$E,\"<=\"&V$16, 'Detailbewertung Chancen'!$E:$E,\">\" &W$16)","v":0},null,20]
[null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C15","v":0}]
[null,null,null,1,2,3,4,5,6,7,8,9,10,10,9,8,7,6,5,4,3,2,1]
[null,null,null,"Auswirkungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auswirkungen"]
[]
[null,null,null,null,null,null,null,null,null,null,"Risiken in roter Zone:",{"$f":"SUM(H6:M7)+SUM(J8:M9)+L10","v":1},null,null,null,null,null,null,null,null,null,"Chancen in grüner Zone:",{"$f":"SUM(N6:S7)+N8+P8+N10","v":1}]
[null,null,null,null,null,null,null,null,null,null,"Risiken in gelber Zone:",{"$f":"D6+F6+F8+H8+H10+J10+J12+L12+L14","v":0},null,null,null,null,null,null,null,null,null,"Chancen in gelber Zone:",{"$f":"T6+V6+R8+T8+P10+R10+N12+P12+N14","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Risiken in grüner Zone:",{"$f":"SUM(D14:K15)+SUM(D12:I13)+F10+D10+D8","v":1},null,null,null,null,null,null,null,null,null,"Chancen in roter Zone:",{"$f":"SUM(P14:W15)+SUM(R12:W13)+T10+V10+V8","v":1}]
[null,null,null,null,null,null,null,null,null,null,"Gesamtanzahl von Risken in Bewertung: ",{"$f":"SUM(L19:L21)","v":2},null,null,null,null,null,null,null,null,null,"Gesamtanzahl der Chancen in Bewertung:",{"$f":"SUM(W19:W21)","v":2}]
[]
[null,null,null,"Vgl. 11.3.2.2. PMBOK 5th edition, page 329"]

{"sheet":"Erläuterung Risiken+Chancen","index":9,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Erläuterung der Risiken und Chancen"]

{"sheet":"Detailbewertung Risiken","index":10,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Detailbewertung der Risiken"]
[]
[null,"Nr.","Risiko","Wahrschein-\nlichkeit","Bewertung der Auswirkungen","Exposure","Auswirkungen","Maßnahmen","Verantwortlich","Typ ","Resourcen","Zeitbedarf","Funktion-\nalität",null,"Wahrscheinlichk.","Auswirk."]
[null,1,"Der Kunde benötigt deutschsprachige Benutzerschnittstellen da dies einer der wesentlichen Anforderungen des Kunden ist.",85,10,{"$f":"D5*E5/100","v":8.5},"Projektziel verfehlt. ","Projektleiter prüft dies, ob Support gewährleistet wird. Sonst Eskalation","Rudorfer","Scope"]
[null,2,"Verspätete Lieferung der Hardware",35,6,2.1]

{"sheet":"Detailbewertung Chancen","index":11,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Detailbewertung der Chancen"]
[]
[null,"Nr.","Opportunity","Wahrschein-\nlichkeit","Bewertung der Auswirkungen","Exposure","Auswirkungen","Maßnahmen","Verantwortlich","Typ ","Resourcen","Zeitbedarf","Funktion-\nalität","Wahrscheinlichk.","Auswirk."]
[null,2,"Erweiterung der Lösung auf die Länder Slowakei, Tschechien und Polen",85,8,{"$f":"D5*E5/100","v":6.8},"Redesign der zentralen Serverarchitektur","Pre-Salestermin mit den Ansprechpartnern in den jeweiligen Ländern","Rudorfer"]
[null,1,"Herstellung einer zentralen Sigle-Signon Lösung",35,4,1.4,"Verbesserung der Benutzerakzeptanz","Vorstellung der Lösung durch den Security-Architekten","Rudorfer"]