{"text_format":"1","workbook":"xls","n_sheets":7,"sheets":["Project Parameters","Planning","Tracking","Planned Totals","Actual Totals","Hours Chart","Billing Chart"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Hours Chart","index":5,"reason":"not_a_worksheet"},{"sheet":"Billing Chart","index":6,"reason":"not_a_worksheet"}],"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","formulas":"cached_only"}

{"sheet":"Project Parameters","index":0,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Project Performance Tracking and Reporting"]
[null,"Company Confidential"]
[null,"[Date]"]
[]
[null,"Shaded cells are calculated for you. You do not need to enter anything into them."]
[null,"Project type","Account manager","Project manager","Business analyst","Process specialist","Finance specialist","Administration staff","Total"]
[null,"Business continuity planning",0.1,0.2,0.4,0.1,0.1,0.1,1]
[null,"Business process re-engineering",0.1,0.1,0.1,0.5,0.1,0.1,1]
[null,"Cost reduction",0.1,0.2,0.1,0.2,0.3,0.1,1.0000000000000002]
[null,"Process improvement",0.1,0.2,0.1,0.4,0.1,0.1,1]
[null,"Sarbanes-Oxley",0.1,0.2,0.2,0.2,0.2,0.1,0.9999999999999999]
[null,"Strategic planning",0.1,0.1,0.5,0,0.2,0.1,0.9999999999999999]
[]
[null,"Blended rates",250,225,200,175,150,50]

{"sheet":"Planning","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Project Performance Tracking and Reporting"]
[null,"Company Confidential"]
[]
[null,"Project name","Project type","Estimated start","Estimated finish","Estimated work","Duration"]
[null,"A. Datum Corporation","Business continuity planning","2005-01-04","2005-03-04",200,60]
[null,"Adventure Works","Business continuity planning","2005-01-20","2005-02-21",400,31]
[null,"Alpine Ski House","Business process re-engineering","2005-02-06","2005-04-16",500,70]
[null,"Baldwin Museum of Science","Business process re-engineering","2005-02-24","2005-04-25",150,61]
[null,"Blue Yonder Airlines","Cost reduction","2005-03-08","2005-03-18",250,10]
[null,"City Power & Light","Cost reduction","2005-03-19","2005-04-29",300,40]
[null,"Coho Vineyard","Cost reduction","2005-04-10","2005-04-20",500,10]
[null,"Coho Winery","Cost reduction","2005-04-18","2005-05-12",750,24]
[null,"Coho Vineyard & Winery","Cost reduction","2005-05-12","2005-06-22",450,40]
[null,"Contoso, Ltd.","Cost reduction","2005-05-23","2005-07-21",250,58]
[null,"Contoso Pharmaceuticals","Cost reduction","2005-06-14","2005-08-12",200,58]
[null,"Consolidated Messenger","Cost reduction","2005-06-30","2005-08-30",180,60]
[null,"Fabrikam, Inc.","Process improvement","2005-01-16","2005-08-15",250,209]
[null,"Fourth Coffee","Process improvement","2005-07-17","2005-09-01",240,44]
[null,"Graphic Design Institute","Process improvement","2005-07-25","2005-09-30",320,65]
[null,"Humongous Insurance","Sarbanes-Oxley","2005-08-01","2005-10-01",550,60]
[null,"Litware, Inc.","Sarbanes-Oxley","2005-08-20","2005-10-02",350,42]
[null,"Lucerne Publishing","Sarbanes-Oxley","2005-09-02","2005-11-12",200,70]
[null,"Margie's Travel","Sarbanes-Oxley","2005-09-12","2005-11-25",220,73]
[null,"Northwind Traders","Sarbanes-Oxley","2005-10-12","2005-12-20",600,68]
[null,"Proseware, Inc.","Strategic planning","2005-10-24","2005-12-14",525,50]
[null,"School of Fine Art","Strategic planning","2005-11-04","2005-11-24",180,20]
[]
[null,"TOTAL",null,null,null,7565]

{"sheet":"Tracking","index":2,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Project Performance Tracking and Reporting"]
[null,"Company Confidential"]
[]
[null,"Project name","Actual start","Actual finish","Actual work","Actual duration"]
[null,"A. Datum Corporation","2005-01-04","2005-03-09",220,65]
[null,"Adventure Works","2005-01-25","2005-02-28",390,33]
[null,"Alpine Ski House","2005-02-10","2005-04-23",500,73]
[null,"Baldwin Museum of Science","2005-02-22","2005-04-29",145,67]
[null,"Blue Yonder Airlines","2005-03-09","2005-03-28",255,19]
[null,"City Power & Light","2005-03-19","2005-05-05",310,46]
[null,"Coho Vineyard","2005-04-12","2005-04-27",510,15]
[null,"Coho Winery","2005-04-17","2005-05-16",790,29]
[null,"Coho Vineyard & Winery","2005-05-15","2005-06-24",430,39]
[null,"Contoso, Ltd.","2005-05-24","2005-07-24",235,60]
[null,"Contoso Pharmaceuticals","2005-06-16","2005-08-16",235,60]
[null,"Consolidated Messenger","2005-07-02","2005-09-25",190,83]
[null,"Fabrikam, Inc.","2005-01-18","2005-08-16",230,208]
[null,"Fourth Coffee","2005-07-19","2005-09-15",225,56]
[null,"Graphic Design Institute","2005-07-26","2005-10-20",305,84]
[null,"Humongous Insurance","2005-08-01","2005-10-14",565,73]
[null,"Litware, Inc.","2005-08-28","2005-10-21",350,53]
[null,"Lucerne Publishing","2005-09-04","2005-11-15",205,71]
[null,"Margie's Travel","2005-09-13","2005-11-29",230,76]
[null,"Northwind Traders","2005-10-22","2005-12-24",560,62]
[null,"Proseware, Inc.","2005-10-14","2005-12-10",540,56]
[null,"School of Fine Art","2005-11-04","2005-11-20",190,16]
[null,"TOTAL",null,null,7610]

{"sheet":"Planned Totals","index":3,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Project Performance Tracking and Reporting"]
[null,"Company Confidential"]
[]
[null,"Project name","Account manager","Project manager","Business analyst","Process specialist","Finance specialist","Administration staff","Total"]
[null,"A. Datum Corporation",5000,9000,16000,3500,3000,1000,37500]
[null,"Adventure Works",10000,18000,32000,7000,6000,2000,75000]
[null,"Alpine Ski House",12500,11250,10000,43750,7500,2500,87500]
[null,"Baldwin Museum of Science",3750,3375,3000,13125,2250,750,26250]
[null,"Blue Yonder Airlines",6250,11250,5000,8750,11250,1250,43750]
[null,"City Power & Light",7500,13500,6000,10500,13500,1500,52500]
[null,"Coho Vineyard",12500,22500,10000,17500,22500,2500,87500]
[null,"Coho Winery",18750,33750,15000,26250,33750,3750,131250]
[null,"Coho Vineyard & Winery",11250,20250,9000,15750,20250,2250,78750]
[null,"Contoso, Ltd.",6250,11250,5000,8750,11250,1250,43750]
[null,"Contoso Pharmaceuticals",5000,9000,4000,7000,9000,1000,35000]
[null,"Consolidated Messenger",4500,8100,3600,6300,8100,900,31500]
[null,"Fabrikam, Inc.",6250,11250,5000,17500,3750,1250,45000]
[null,"Fourth Coffee",6000,10800,4800,16800,3600,1200,43200]
[null,"Graphic Design Institute",8000,14400,6400,22400,4800,1600,57600]
[null,"Humongous Insurance",13750,24750,22000,19250,16500,2750,99000]
[null,"Litware, Inc.",8750,15750,14000,12250,10500,1750,63000]
[null,"Lucerne Publishing",5000,9000,8000,7000,6000,1000,36000]
[null,"Margie's Travel",5500,9900,8800,7700,6600,1100,39600]
[null,"Northwind Traders",15000,27000,24000,21000,18000,3000,108000]
[null,"Proseware, Inc.",13125,11812.5,52500,0,15750,2625,95812.5]
[null,"School of Fine Art",4500,4050,18000,0,5400,900,32850]
[null,"TOTAL Cost",189125,309937.5,282100,292075,239250,37825,1350312.5]
[null,"TOTAL Hours",756.5,1377.5,1410.5,1669,1595,756.5,7565]

{"sheet":"Actual Totals","index":4,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Project Performance Tracking and Reporting"]
[null,"Company Confidential"]
[]
[null,"Project name","Account manager","Project manager","Business analyst","Process specialist","Finance specialist","Administration staff","Total"]
[null,"A. Datum Corporation",5500,9900,17600,3850,3300,1100,41250]
[null,"Adventure Works",9750,17550,31200,6825,5850,1950,73125]
[null,"Alpine Ski House",12500,11250,10000,43750,7500,2500,87500]
[null,"Baldwin Museum of Science",3625,3262.5,2900,12687.5,2175,725,25375]
[null,"Blue Yonder Airlines",6375,11475,5100,8925,11475,1275,44625]
[null,"City Power & Light",7750,13950,6200,10850,13950,1550,54250]
[null,"Coho Vineyard",12750,22950,10200,17850,22950,2550,89250]
[null,"Coho Winery",19750,35550,15800,27650,35550,3950,138250]
[null,"Coho Vineyard & Winery",10750,19350,8600,15050,19350,2150,75250]
[null,"Contoso, Ltd.",5875,10575,4700,8225,10575,1175,41125]
[null,"Contoso Pharmaceuticals",5875,10575,4700,8225,10575,1175,41125]
[null,"Consolidated Messenger",4750,8550,3800,6650,8550,950,33250]
[null,"Fabrikam, Inc.",5750,10350,4600,16100,3450,1150,41400]
[null,"Fourth Coffee",5625,10125,4500,15750,3375,1125,40500]
[null,"Graphic Design Institute",7625,13725,6100,21350,4575,1525,54900]
[null,"Humongous Insurance",14125,25425,22600,19775,16950,2825,101700]
[null,"Litware, Inc.",8750,15750,14000,12250,10500,1750,63000]
[null,"Lucerne Publishing",5125,9225,8200,7175,6150,1025,36900]
[null,"Margie's Travel",5750,10350,9200,8050,6900,1150,41400]
[null,"Northwind Traders",14000,25200,22400,19600,16800,2800,100800]
[null,"Proseware, Inc.",13500,12150,54000,0,16200,2700,98550]
[null,"School of Fine Art",4750,4275,19000,0,5700,950,34675]
[null,"TOTAL Cost",190250,311512.5,285400,290587.5,242400,38050,1358200]
[null,"TOTAL Hours",761,1384.5,1427,1660.5,1616,761,7610]