{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Home Page","Staffing Schedule","Summary","CSV File"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,1,22,2],[0,0,0,2],[7,1,7,2],[16,1,16,2],[18,1,18,2],[20,1,20,2]]}
["INSTRUCTIONS"]
["Note 1: Run this macro on Excel 2000 or later"]
["Things to keep in mind before getting started"]
[null,"a)","DO NOT delete any sheet."]
[null,"b)","DO NOT rename any sheet."]
["Getting started"]
[1,"Copy Data"]
[null,"Copy the data into the \"Staffing Schedule\" sheet (IMPORTANT: Make sure that you copy the data exactly as it appears in the standard output containing the staffing schedule. Do not make any changes to the sheet containing the data before copying it into the \"Staffing Schedule\" sheet. The \"Home Page\" sheet contains the button to run the macro, and also allows you to enter non-chargeable engagement names. The \"Summary\" sheet is reserved for the output created by the macro."]
[2,"Run \"CreateEngagementSummary\" Macro"]
[null,"You can do this in three ways:"]
[null,"a)","Go to the \"Home Page\" sheet and click the \"Create Summary\" button to run the macro, or"]
[null,"b)","Use the shortcut keys : Control + Shift + M, or"]
[null,"c)","For Microsoft 2007: Got to Developer > Macros… , select the \"CreateEngagementSummary\" macro, and then click the \"Run\" button\n\nFor Excel versions < 2007: Go to Tools > Macro > Macros… , select the \"CreateEngagementSummary\" macro, and then click the \"Run\" button"]
[null,"The output will be automatically created on the \"Summary\" sheet"]
["Assumptions (IMPORTANT: Please read)"]
[1,"Staffing Schedule"]
[null,"The macro assumes that there is no more data after it comes across the first blank row in the \"Staffing Schedule\" sheet (Trouble Shooting Tip: If you get an incomplete output, check to make sure that there are no blank rows in the data)."]
[2,"Engagement Names"]
[null,"If there are any reserved hours (denoted by \"R\"), then keyword \"(Reserved)\" is appended to the engagement name. If an engagement has both - regular and reserved hours - then two engagement names are created, one without \"(Reserved)\" and one with it. This allows segregation between regular and reserved hours."]
[3,"Tentatively Scheduled / Reserved Hours"]
[null,"When calculating the tentative/reserved hours, if hour information in the cell has  \"R\" as the last  character, the macro assumes hours on those engagements are tentative/reserved hours"]
[4,"Categorizing By Level"]
[null,"CN1, CN2 = Consultants\nSR1, SR2 = Seniors\nMAN, SMR = Managers\nAll Others = Directors"]

{"sheet":"Home Page","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,"Run Macro"]
[]
[]
[]
[null,null,"Non-Chargeable"]
[null,null,"CTO,Floating Holiday"]
[null,null,"External Training"]
[null,null,"Internal Trng/Staff Dev"]
[null,null,"Proposal/Practice Devel"]
[null,null,"Company Holiday"]
[null,null,"Other Time Off"]
[null,null,"Seminar & Conference"]
[null,null,"PRO - ACE/PeopleSoft Alliance"]

{"sheet":"Staffing Schedule","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CSV File","index":4,"n_rows":74,"n_cols":26,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["Report ID:","RHMASTER",null,null,"XX Consulting"]
[null,null,null,null,"Chart Resource Availability - Master Schedule","Run Date","2009-07-20"]
["Start Date:",null,null,null,null,"Run Time","12:41:13"]
["Thru Date:"]
["Region:","ALL"]
["Service Line:","Business Risk, Risk Consulting -Technology, Internal Audit"]
["Functional Level:","CN1, MD, CN2, SMR, SR2, INT, MAN, DIR, AD, SR1"]
["Employee Type:","ALL"]
[]
[]
["Deptid","Location","Emplid","Type","Employee Name","HR Job Function","Project Role","Service Line","Project Description","Project ID","Industry","Sub-Industry","Product","Nature of Work","2006-07-20","2006-07-27","2006-08-03","2006-08-10","2006-08-17","2006-08-24","2006-08-31","2006-09-07","2006-09-14","2006-09-21","2006-09-28","2006-10-05"]
[10249,"San Diego",503955,"EMPL","White,Jay P","CN1","Consultant 1","Risk Consulting -Technology","FRANKLIN C - FCC001-SOA                 ",2891,"Consumer Products & Retail"," ","SOA Initial Year","Internal Audit",40,40,40,40,40,40,40,32,40,40,40,"   "]
[10249,"San Diego",503955,"EMPL","White,Jay P","CN1","Consultant 1","Risk Consulting -Technology","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   "]
[10249,"San Diego",500011,"EMPL","Johnson,Daniel B","MAN","Consultant 1","Risk Consulting -Technology","Longs/Vista/UNFI/Franklin Cov           "," ",null," "," "," "," 32R","   ","   "," 32R"," 32R"," 32R"," 32R"," 26R"," 32R"," 32R"," 32R","   "]
[10249,"San Diego",500011,"EMPL","Johnson,Daniel B","MAN","Manager","Risk Consulting -Technology","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   "]
[10249,"San Diego",500011,"EMPL","Johnson,Daniel B","MAN","Manager","Risk Consulting -Technology","CTO,Floating Holiday                    "," "," "," "," "," ","   ",40,40,"   ","   ","   ","   ","   ","   ","   ","   ","   "]
[10249,"San Diego",502572,"EMPL","Vick,Jay E","SR2","Senior Consultant 1","Internal Audit","INTERMOUNT - IHC001-PHASE I             ",5800,"Healthcare","Providers","SOA Initial Year","SOA Initial Year",40,40,40,40,40,40,40,32,40,40,40,40]
[10249,"San Diego",502572,"EMPL","Vick,Jay E","SR2","Senior Consultant 2","Internal Audit","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   "]
[10249,"San Diego",503629,"EMPL","Johnson,Robert T","CN2","Senior Consultant 1","Risk Consulting -Technology","Stamps.com                              "," ",null," "," "," ","   ","   ","   ","   ","   ","   ","   "," 32R"," 40R"," 40R"," 40R","   "]
[10249,"San Diego",503629,"EMPL","Johnson,Robert T","CN2","Consultant 2","Risk Consulting -Technology","INTERMOUNT - IHC001-PHASE I             ",5800,"Healthcare","Providers","SOA Initial Year","SOA Initial Year",40,40,40,"   ","   ","   ","   ","   ","   ","   ","   ","   "]
[10249,"San Diego",503629,"EMPL","Johnson,Robert T","CN2","Consultant 2","Risk Consulting -Technology","INTERMOUNT - IHC001-SOA YR 1 PH II THRU IV",7211,"Healthcare","Providers","SOA Initial Year","SOA Initial Year","   ","   ","   ",40,40,40,40,"   ","   ","   ","   ","   "]
[10249,"San Diego",503629,"EMPL","Johnson,Robert T","CN2","Consultant 2","Risk Consulting -Technology","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   "]
[10252,"San Francisco",502387,"EMPL","Clarke,Kyle D","CN2","Consultant 1","Internal Audit","EXTRA SPAC - ESS002-SOA 404 & INT AUD SERV",7384,"Consumer Products & Retail"," ","Co-Sourcing","Internal Audit",40,40,40,40,"   ",40,40,32,40,40,40,"   "]
[10252,"San Francisco",502387,"EMPL","Clarke,Kyle D","CN2","Consultant 2","Internal Audit","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   "]
[10252,"San Francisco",502387,"EMPL","Clarke,Kyle D","CN2","Consultant 2","Internal Audit","CTO,Floating Holiday                    "," "," "," "," "," ","   ","   ","   ","   ",40,"   ","   ","   ","   ","   ","   ","   "]
[10252,"San Francisco",503735,"EMPL","Boeing,Chris J","INT","Intern","Internal Audit","PRESTIGE B - PBI002-SOA COMPLIANCE CONSULTI",4441,"Consumer Products & Retail"," ","SOA Initial Year","Internal Audit",40,40,"   ","   ","   ","   ","   ","   ","   ","   ","   ","   "]
[10252,"San Francisco",503735,"EMPL","Boeing,Chris J","INT","Intern","Internal Audit","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   "]
[10252,"San Francisco",503735,"EMPL","Boeing,Chris J","INT","Intern","Internal Audit","Planned Leave (LOA)                     "," "," "," "," "," ","   ","   ",40,40,40,40,40,32,40,40,40,40]
[10252,"San Francisco",501246,"EMPL","Keeva,Amy B","SR1","Intern","Internal Audit","ICON                                    "," ",null," "," "," ","   ","   ","  6R","  8R","  8R","  8R","  8R","  6R","  8R","  8R","  8R","  8R"]
[10252,"San Francisco",501246,"EMPL","Keeva,Amy B","SR1","Senior Consultant 1","Internal Audit","FRANKLIN C - FCC001-SOA                 ",2891,"Consumer Products & Retail"," ","SOA Initial Year","Internal Audit","   ","   ",16,32,32,32,32,26,32,32,32,32]
[10252,"San Francisco",501246,"EMPL","Keeva,Amy B","SR1","Senior Consultant 1","Internal Audit","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   "]
[10252,"San Francisco",501246,"EMPL","Keeva,Amy B","SR1","Senior Consultant 1","Internal Audit","Planned Leave (LOA)                     "," "," "," "," "," ",40,40,8,"   ","   ","   ","   ","   ","   ","   ","   ","   "]
[10252,"San Francisco",500837,"EMPL","Flubber,Jason S","AD","Senior Consultant 1","Internal Audit","Multiple projects                       "," ",null," "," "," "," 24R"," 24R"," 24R"," 24R"," 24R"," 24R"," 24R"," 24R"," 24R"," 24R"," 24R","   "]
[10252,"San Francisco",500837,"EMPL","Flubber,Jason S","AD","Associate Director","Internal Audit","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   "]
[10251,"Seattle",501153,"EMPL","Shepherd,Robert D","MAN","Senior Consultant 1","Internal Audit","QLogic-royalty audit                    "," ",null," "," "," ","   ","   ","   ","   ","   "," 40R"," 40R"," 32R","   ","   ","   ","   "]
[10270,"Seattle",501153,"EMPL","Shepherd,Robert D","MAN","Manager","Internal Audit","EXTRA SPAC - ESS002-SOA CONSULTING      ",4328,"Consumer Products & Retail"," ","SOA Initial Year","Internal Audit",12,12,"   ",12,12,"   ","   ","   ",12,12,12,"   "]
[10270,"Seattle",501153,"EMPL","Shepherd,Robert D","MAN","Senior Consultant 2","Internal Audit","INTERMOUNT - IHC001-PHASE I             ",5800,"Healthcare","Providers","SOA Initial Year","SOA Initial Year",8,8,"   ",8,8,"   ","   ","   ",8,8,8,"   "]
[10270,"Seattle",501153,"EMPL","Shepherd,Robert D","MAN","Senior Consultant 2","Internal Audit","WEIDER NUT - WNI002 -CALENDAR YR 2005 AUDIT",5269,"Consumer Products & Retail"," ","Co-Sourcing","Internal Audit",8,8,"   ",8,8,"   ","   ","   ",8,8,8,"   "]
[10270,"Seattle",501153,"EMPL","Shepherd,Robert D","MAN","Manager","Internal Audit","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   "]
[10270,"Seattle",501153,"EMPL","Shepherd,Robert D","MAN","Manager","Internal Audit","CTO,Floating Holiday                    "," "," "," "," "," ","   ","   ",40,"   ","   ","   ","   ","   ","   ","   ","   ","   "]
[10270,"Seattle",503359,"EMPL","Cornkite,Kristin Kelly","CN1","Consultant 1","Internal Audit","FRANKLIN C - FCC001-SOA                 ",2891,"Consumer Products & Retail"," ","SOA Initial Year","Internal Audit",40,40,"   ","   ",40,40,40,32,40,40,40,"   "]
[10270,"Seattle",503359,"EMPL","Cornkite,Kristin Kelly","CN1","Consultant 1","Internal Audit","INVESTOOLS - IVT001-SOX YEAR 2 CONSULTING",5653,"Mfg, Distribution & Technology"," ","SOA IT On-Going","Internal Audit","   ","   ","   ","   ","   ","   ","   ","   ","   ","   ","   ",40]
[10270,"Seattle",503359,"EMPL","Cornkite,Kristin Kelly","CN1","Consultant 1","Internal Audit","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   "]
[10270,"Seattle",503359,"EMPL","Cornkite,Kristin Kelly","CN1","Consultant 1","Internal Audit","CTO,Floating Holiday                    "," "," "," "," "," ","   ","   ",40,40,"   ","   ","   ","   ","   ","   ","   ","   "]
[10270,"Seattle",503741,"EMPL","Jones,Justin S","INT","Senior Consultant 1","Internal Audit","Overlake/NW/Peace Health                "," ",null," "," "," "," 40R"," 40R"," 40R"," 40R"," 40R","   ","   ","   ","   ","   ","   ","   "]
[10270,"Seattle",503741,"EMPL","Jones,Justin S","INT","Intern","Internal Audit","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   ","   "]
[10270,"Seattle",503741,"EMPL","Jones,Justin S","INT","Intern","Internal Audit","Planned Leave (LOA)                     "," "," "," "," "," ","   ","   ","   ","   ","   ",40,32,40,40,40,40,40]
[10270,"Seattle",501149,"EMPL","Bones,Jay E","SMR","Senior Consultant 1","Internal Audit","WDS                                     "," ",null," "," "," "," 10R"," 10R"," 10R"," 10R"," 10R"," 10R","  8R","   ","   ","   ","   ","   "]
[10270,"Seattle",501149,"EMPL","Bones,Jay E","SMR","Senior Consultant 1","Internal Audit","GHC                                     "," ",null," "," "," ","  8R","  8R","  8R","  4R","  6R","  6R","  6R","   ","   ","  6R","  6R","  6R"]
[10250,"Salt Lake City",501633,"EMPL","North,Benjamin J","SR1","Consultant 1","Risk Consulting -Technology","UCN                                     "," ",null," "," "," ","   ","   ","   ","   ","   ","   ","   "," 32R"," 40R"," 40R"," 40R","   "]
[10250,"Salt Lake City",501633,"EMPL","North,Benjamin J","SR1","Consultant 2","Risk Consulting -Technology","FRANKLIN C - FCC001-SOA                 ",2891,"Consumer Products & Retail"," ","SOA Initial Year","Internal Audit",20,20,20,"   ","   ","   ","   ","   ","   ","   ","   ","   "]
[10250,"Salt Lake City",501633,"EMPL","North,Benjamin J","SR1","Consultant 2","Risk Consulting -Technology","INTERMOUNT - IHC001-SOA YR 1 PH II THRU IV",7211,"Healthcare","Providers","SOA Initial Year","SOA Initial Year","   ","   ","   ","   ",40,20,32,"   ","   ","   ","   ","   "]
[10250,"Salt Lake City",501633,"EMPL","North,Benjamin J","SR1","Consultant 2","Risk Consulting -Technology","LONGS - LON106-SOA YEAR 2               ",5013,"Consumer Products & Retail"," ","SOA On-Going","Internal Audit","   ","   ","   ","   ","   ",20,"   ","   ","   ","   ","   ","   "]
[10250,"Salt Lake City",501633,"EMPL","North,Benjamin J","SR1","Consultant 2","Risk Consulting -Technology","UNITED NAT - UNF001-SOA IT YEAR 2       ",6865,"Consumer Products & Retail"," ","SOA IT On-Going","SOA On-Going"," 20R"," 20R"," 20R","   ","   ","   ","   ","   ","   ","   ","   ","   "]
[10250,"Salt Lake City",501633,"EMPL","North,Benjamin J","SR1","Senior Consultant 1","Risk Consulting -Technology","Internal Trng/Staff Dev                 "," "," "," "," "," ","   ","   ","   ",40,"   ","   ","   ","   ","   ","   ","   ","   "]
[10250,"Salt Lake City",501633,"EMPL","North,Benjamin J","SR1","Senior Consultant 1","Risk Consulting -Technology","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   "]
[10250,"Salt Lake City",501633,"EMPL","North,Benjamin J","SR1","Senior Consultant 1","Risk Consulting -Technology","CTO,Floating Holiday                    "," "," "," "," "," ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   ",40]
[10250,"Salt Lake City",503353,"EMPL","Flight,Jeffrey J","CN1","Consultant 1","Internal Audit","AMERICAN E - AEC001-INTERNAL AUDIT COSOURCI",4748,"Financial Serv. & Real Estate","Other Fin Services","Co-Sourcing","Internal Audit",40,16,40,40,40,40,40,32,40,40,40,40]
[10250,"Salt Lake City",503353,"EMPL","Flight,Jeffrey J","CN1","Consultant 1","Internal Audit","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   "]
[10250,"Salt Lake City",503353,"EMPL","Flight,Jeffrey J","CN1","Consultant 1","Internal Audit","CTO,Floating Holiday                    "," "," "," "," "," ","   ",24,"   ","   ","   ","   ","   ","   ","   ","   ","   ","   "]
[10200,"Portland",501231,"EMPL","Dog,Kevin R","MAN","Engagement Manager","Risk Consulting -Technology","NIKE INC - NIK001-SAP/SOD               ",7036,"Consumer Products & Retail"," ","ACE - SAP","Consulting",8,"   ","   ","   ","   ","   ","   ","   ","   ","   ","   ","   "]
[10200,"Portland",501231,"EMPL","Dog,Kevin R","MAN","Engagement Manager","Risk Consulting -Technology","NIKE INC - NIK001-SAP SOD FY07          ",7962,"Consumer Products & Retail"," ","ACE - SAP","Consulting",32,32,40,40,40,32,"   ","   ","   ","   ","   ","   "]
[10200,"Portland",501231,"EMPL","Dog,Kevin R","MAN","Manager","Risk Consulting -Technology","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   ","   "]
[10200,"Portland",501231,"EMPL","Dog,Kevin R","MAN","Manager","Risk Consulting -Technology","CTO,Floating Holiday                    "," "," "," "," "," ","   ",8,"   ","   ","   ","   ",32,"   ","   ","   ","   ","   "]
[10200,"Portland",502182,"EMPL","Bullet,Scott M","SR2","Senior Consultant 1","Risk Consulting -Technology","T-MOBILE - TMO001-ITAM FOR TELECOM (ALM)",5546,"Communications","Communications Providers","Asset Management","Consulting",40,40,40,40,40,40,32,40,40,40,40,40]
[10200,"Portland",502182,"EMPL","Bullet,Scott M","SR2","Senior Consultant 2","Risk Consulting -Technology","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   ","   "]
[10200,"Portland",502293,"EMPL","King,Michael J","CN2","Consultant 2","Internal Audit","T-MOBILE - TMO001-ITAM FOR TELECOM (ALM)",5546,"Communications","Communications Providers","Asset Management","Consulting",40,40,32,40,40,40,32,40,40,40,40,40]
[10200,"Portland",502293,"EMPL","King,Michael J","CN2","Consultant 2","Internal Audit","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   ","   "]
[10200,"Portland",502293,"EMPL","King,Michael J","CN2","Consultant 2","Internal Audit","CTO,Floating Holiday                    "," "," "," "," "," ","   ","   ",8,"   ","   ","   ","   ","   ","   ","   ","   ","   "]
[10200,"Portland",503322,"EMPL","Fox,Jnana","SR1","Senior Consultant 1","Risk Consulting -Technology","FIRST COMM - FCB001-IA IT               ",7153,"Financial Serv. & Real Estate","Banking","IT Audit Services","Internal Audit",40,40,"   ","   ","   ","   ","   ","   ","   ","   ","   ","   "]
[10200,"Portland",503322,"EMPL","Fox,Jnana","SR1","Senior Consultant 1","Risk Consulting -Technology","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   ","   "]
[10200,"Portland",502132,"EMPL","Fish,Jonathan I","SMR","Senior Consultant 1","Risk Consulting -Technology","TUT Systems                             "," ",null," "," "," ","   ","   ","  8R","   ","   ","   ","  8R","   ","   ","   ","  8R","   "]
[10200,"Portland",502132,"EMPL","Fish,Jonathan I","SMR","Manager","Risk Consulting -Technology","T-MOBILE - TMO001-ITAM FOR TELECOM (ALM)",5546,"Communications","Communications Providers","Asset Management","Consulting",40,40,32,40,40,40,24,40,40,40,32,40]
[10200,"Portland",502132,"EMPL","Fish,Jonathan I","SMR","Senior Manager","Risk Consulting -Technology","Company Holiday                         "," "," "," "," "," ","   ","   ","   ","   ","   ","   ",8,"   ","   ","   ","   ","   "]