{"text_format":"3","workbook":"xls","n_sheets":7,"sheets":["Project Parameters","Planning","Tracking","Planned Totals","Actual Totals","Hours Chart","Billing Chart"],"not_rendered":{"charts":2,"external_links":1,"defined_names":5},"unopened":[{"sheet":"Hours Chart","index":5,"reason":"not_a_worksheet"},{"sheet":"Billing Chart","index":6,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Project Parameters","index":0,"n_rows":15,"n_cols":9,"rows_kept":15,"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",{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0.4,"d":"40%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":1,"d":"100%"}]
[null,"Business process re-engineering",{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.5,"d":"50%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":1,"d":"100%"}]
[null,"Cost reduction",{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0.3,"d":"30%"},{"v":0.1,"d":"10%"},{"v":1.0000000000000002,"d":"100%"}]
[null,"Process improvement",{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.4,"d":"40%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":1,"d":"100%"}]
[null,"Sarbanes-Oxley",{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.9999999999999999,"d":"100%"}]
[null,"Strategic planning",{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.9999999999999999,"d":"100%"}]
[]
[null,"Blended rates",{"v":250,"d":"$250"},{"v":225,"d":"$225"},{"v":200,"d":"$200"},{"v":175,"d":"$175"},{"v":150,"d":"$150"},{"v":50,"d":"$50"}]

{"sheet":"Planning","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"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",{"$nulls":3},{"v":7565,"d":"7,565"}]

{"sheet":"Tracking","index":2,"n_rows":28,"n_cols":6,"rows_kept":28,"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,{"v":7610,"d":"7,610"}]

{"sheet":"Planned Totals","index":3,"n_rows":29,"n_cols":9,"rows_kept":29,"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",{"v":5000,"d":"$5,000"},{"v":9000,"d":"$9,000"},{"v":16000,"d":"$16,000"},{"v":3500,"d":"$3,500"},{"v":3000,"d":"$3,000"},{"v":1000,"d":"$1,000"},{"v":37500,"d":"$37,500"}]
[null,"Adventure Works",{"v":10000,"d":"$10,000"},{"v":18000,"d":"$18,000"},{"v":32000,"d":"$32,000"},{"v":7000,"d":"$7,000"},{"v":6000,"d":"$6,000"},{"v":2000,"d":"$2,000"},{"v":75000,"d":"$75,000"}]
[null,"Alpine Ski House",{"v":12500,"d":"$12,500"},{"v":11250,"d":"$11,250"},{"v":10000,"d":"$10,000"},{"v":43750,"d":"$43,750"},{"v":7500,"d":"$7,500"},{"v":2500,"d":"$2,500"},{"v":87500,"d":"$87,500"}]
[null,"Baldwin Museum of Science",{"v":3750,"d":"$3,750"},{"v":3375,"d":"$3,375"},{"v":3000,"d":"$3,000"},{"v":13125,"d":"$13,125"},{"v":2250,"d":"$2,250"},{"v":750,"d":"$750"},{"v":26250,"d":"$26,250"}]
[null,"Blue Yonder Airlines",{"v":6250,"d":"$6,250"},{"v":11250,"d":"$11,250"},{"v":5000,"d":"$5,000"},{"v":8750,"d":"$8,750"},{"v":11250,"d":"$11,250"},{"v":1250,"d":"$1,250"},{"v":43750,"d":"$43,750"}]
[null,"City Power & Light",{"v":7500,"d":"$7,500"},{"v":13500,"d":"$13,500"},{"v":6000,"d":"$6,000"},{"v":10500,"d":"$10,500"},{"v":13500,"d":"$13,500"},{"v":1500,"d":"$1,500"},{"v":52500,"d":"$52,500"}]
[null,"Coho Vineyard",{"v":12500,"d":"$12,500"},{"v":22500,"d":"$22,500"},{"v":10000,"d":"$10,000"},{"v":17500,"d":"$17,500"},{"v":22500,"d":"$22,500"},{"v":2500,"d":"$2,500"},{"v":87500,"d":"$87,500"}]
[null,"Coho Winery",{"v":18750,"d":"$18,750"},{"v":33750,"d":"$33,750"},{"v":15000,"d":"$15,000"},{"v":26250,"d":"$26,250"},{"v":33750,"d":"$33,750"},{"v":3750,"d":"$3,750"},{"v":131250,"d":"$131,250"}]
[null,"Coho Vineyard & Winery",{"v":11250,"d":"$11,250"},{"v":20250,"d":"$20,250"},{"v":9000,"d":"$9,000"},{"v":15750,"d":"$15,750"},{"v":20250,"d":"$20,250"},{"v":2250,"d":"$2,250"},{"v":78750,"d":"$78,750"}]
[null,"Contoso, Ltd.",{"v":6250,"d":"$6,250"},{"v":11250,"d":"$11,250"},{"v":5000,"d":"$5,000"},{"v":8750,"d":"$8,750"},{"v":11250,"d":"$11,250"},{"v":1250,"d":"$1,250"},{"v":43750,"d":"$43,750"}]
[null,"Contoso Pharmaceuticals",{"v":5000,"d":"$5,000"},{"v":9000,"d":"$9,000"},{"v":4000,"d":"$4,000"},{"v":7000,"d":"$7,000"},{"v":9000,"d":"$9,000"},{"v":1000,"d":"$1,000"},{"v":35000,"d":"$35,000"}]
[null,"Consolidated Messenger",{"v":4500,"d":"$4,500"},{"v":8100,"d":"$8,100"},{"v":3600,"d":"$3,600"},{"v":6300,"d":"$6,300"},{"v":8100,"d":"$8,100"},{"v":900,"d":"$900"},{"v":31500,"d":"$31,500"}]
[null,"Fabrikam, Inc.",{"v":6250,"d":"$6,250"},{"v":11250,"d":"$11,250"},{"v":5000,"d":"$5,000"},{"v":17500,"d":"$17,500"},{"v":3750,"d":"$3,750"},{"v":1250,"d":"$1,250"},{"v":45000,"d":"$45,000"}]
[null,"Fourth Coffee",{"v":6000,"d":"$6,000"},{"v":10800,"d":"$10,800"},{"v":4800,"d":"$4,800"},{"v":16800,"d":"$16,800"},{"v":3600,"d":"$3,600"},{"v":1200,"d":"$1,200"},{"v":43200,"d":"$43,200"}]
[null,"Graphic Design Institute",{"v":8000,"d":"$8,000"},{"v":14400,"d":"$14,400"},{"v":6400,"d":"$6,400"},{"v":22400,"d":"$22,400"},{"v":4800,"d":"$4,800"},{"v":1600,"d":"$1,600"},{"v":57600,"d":"$57,600"}]
[null,"Humongous Insurance",{"v":13750,"d":"$13,750"},{"v":24750,"d":"$24,750"},{"v":22000,"d":"$22,000"},{"v":19250,"d":"$19,250"},{"v":16500,"d":"$16,500"},{"v":2750,"d":"$2,750"},{"v":99000,"d":"$99,000"}]
[null,"Litware, Inc.",{"v":8750,"d":"$8,750"},{"v":15750,"d":"$15,750"},{"v":14000,"d":"$14,000"},{"v":12250,"d":"$12,250"},{"v":10500,"d":"$10,500"},{"v":1750,"d":"$1,750"},{"v":63000,"d":"$63,000"}]
[null,"Lucerne Publishing",{"v":5000,"d":"$5,000"},{"v":9000,"d":"$9,000"},{"v":8000,"d":"$8,000"},{"v":7000,"d":"$7,000"},{"v":6000,"d":"$6,000"},{"v":1000,"d":"$1,000"},{"v":36000,"d":"$36,000"}]
[null,"Margie's Travel",{"v":5500,"d":"$5,500"},{"v":9900,"d":"$9,900"},{"v":8800,"d":"$8,800"},{"v":7700,"d":"$7,700"},{"v":6600,"d":"$6,600"},{"v":1100,"d":"$1,100"},{"v":39600,"d":"$39,600"}]
[null,"Northwind Traders",{"v":15000,"d":"$15,000"},{"v":27000,"d":"$27,000"},{"v":24000,"d":"$24,000"},{"v":21000,"d":"$21,000"},{"v":18000,"d":"$18,000"},{"v":3000,"d":"$3,000"},{"v":108000,"d":"$108,000"}]
[null,"Proseware, Inc.",{"v":13125,"d":"$13,125"},{"v":11812.5,"d":"$11,813"},{"v":52500,"d":"$52,500"},0,{"v":15750,"d":"$15,750"},{"v":2625,"d":"$2,625"},{"v":95812.5,"d":"$95,813"}]
[null,"School of Fine Art",{"v":4500,"d":"$4,500"},{"v":4050,"d":"$4,050"},{"v":18000,"d":"$18,000"},0,{"v":5400,"d":"$5,400"},{"v":900,"d":"$900"},{"v":32850,"d":"$32,850"}]
[null,"TOTAL Cost",{"v":189125,"d":"$189,125"},{"v":309937.5,"d":"$309,938"},{"v":282100,"d":"$282,100"},{"v":292075,"d":"$292,075"},{"v":239250,"d":"$239,250"},{"v":37825,"d":"$37,825"},{"v":1350312.5,"d":"$1,350,313"}]
[null,"TOTAL Hours",{"v":756.5,"d":"757"},{"v":1377.5,"d":"1,378"},{"v":1410.5,"d":"1,411"},{"v":1669,"d":"1,669"},{"v":1595,"d":"1,595"},{"v":756.5,"d":"757"},{"v":7565,"d":"7,565"}]

{"sheet":"Actual Totals","index":4,"n_rows":29,"n_cols":9,"rows_kept":29,"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",{"v":5500,"d":"$5,500"},{"v":9900,"d":"$9,900"},{"v":17600,"d":"$17,600"},{"v":3850,"d":"$3,850"},{"v":3300,"d":"$3,300"},{"v":1100,"d":"$1,100"},{"v":41250,"d":"$41,250"}]
[null,"Adventure Works",{"v":9750,"d":"$9,750"},{"v":17550,"d":"$17,550"},{"v":31200,"d":"$31,200"},{"v":6825,"d":"$6,825"},{"v":5850,"d":"$5,850"},{"v":1950,"d":"$1,950"},{"v":73125,"d":"$73,125"}]
[null,"Alpine Ski House",{"v":12500,"d":"$12,500"},{"v":11250,"d":"$11,250"},{"v":10000,"d":"$10,000"},{"v":43750,"d":"$43,750"},{"v":7500,"d":"$7,500"},{"v":2500,"d":"$2,500"},{"v":87500,"d":"$87,500"}]
[null,"Baldwin Museum of Science",{"v":3625,"d":"$3,625"},{"v":3262.5,"d":"$3,263"},{"v":2900,"d":"$2,900"},{"v":12687.5,"d":"$12,688"},{"v":2175,"d":"$2,175"},{"v":725,"d":"$725"},{"v":25375,"d":"$25,375"}]
[null,"Blue Yonder Airlines",{"v":6375,"d":"$6,375"},{"v":11475,"d":"$11,475"},{"v":5100,"d":"$5,100"},{"v":8925,"d":"$8,925"},{"v":11475,"d":"$11,475"},{"v":1275,"d":"$1,275"},{"v":44625,"d":"$44,625"}]
[null,"City Power & Light",{"v":7750,"d":"$7,750"},{"v":13950,"d":"$13,950"},{"v":6200,"d":"$6,200"},{"v":10850,"d":"$10,850"},{"v":13950,"d":"$13,950"},{"v":1550,"d":"$1,550"},{"v":54250,"d":"$54,250"}]
[null,"Coho Vineyard",{"v":12750,"d":"$12,750"},{"v":22950,"d":"$22,950"},{"v":10200,"d":"$10,200"},{"v":17850,"d":"$17,850"},{"v":22950,"d":"$22,950"},{"v":2550,"d":"$2,550"},{"v":89250,"d":"$89,250"}]
[null,"Coho Winery",{"v":19750,"d":"$19,750"},{"v":35550,"d":"$35,550"},{"v":15800,"d":"$15,800"},{"v":27650,"d":"$27,650"},{"v":35550,"d":"$35,550"},{"v":3950,"d":"$3,950"},{"v":138250,"d":"$138,250"}]
[null,"Coho Vineyard & Winery",{"v":10750,"d":"$10,750"},{"v":19350,"d":"$19,350"},{"v":8600,"d":"$8,600"},{"v":15050,"d":"$15,050"},{"v":19350,"d":"$19,350"},{"v":2150,"d":"$2,150"},{"v":75250,"d":"$75,250"}]
[null,"Contoso, Ltd.",{"v":5875,"d":"$5,875"},{"v":10575,"d":"$10,575"},{"v":4700,"d":"$4,700"},{"v":8225,"d":"$8,225"},{"v":10575,"d":"$10,575"},{"v":1175,"d":"$1,175"},{"v":41125,"d":"$41,125"}]
[null,"Contoso Pharmaceuticals",{"v":5875,"d":"$5,875"},{"v":10575,"d":"$10,575"},{"v":4700,"d":"$4,700"},{"v":8225,"d":"$8,225"},{"v":10575,"d":"$10,575"},{"v":1175,"d":"$1,175"},{"v":41125,"d":"$41,125"}]
[null,"Consolidated Messenger",{"v":4750,"d":"$4,750"},{"v":8550,"d":"$8,550"},{"v":3800,"d":"$3,800"},{"v":6650,"d":"$6,650"},{"v":8550,"d":"$8,550"},{"v":950,"d":"$950"},{"v":33250,"d":"$33,250"}]
[null,"Fabrikam, Inc.",{"v":5750,"d":"$5,750"},{"v":10350,"d":"$10,350"},{"v":4600,"d":"$4,600"},{"v":16100,"d":"$16,100"},{"v":3450,"d":"$3,450"},{"v":1150,"d":"$1,150"},{"v":41400,"d":"$41,400"}]
[null,"Fourth Coffee",{"v":5625,"d":"$5,625"},{"v":10125,"d":"$10,125"},{"v":4500,"d":"$4,500"},{"v":15750,"d":"$15,750"},{"v":3375,"d":"$3,375"},{"v":1125,"d":"$1,125"},{"v":40500,"d":"$40,500"}]
[null,"Graphic Design Institute",{"v":7625,"d":"$7,625"},{"v":13725,"d":"$13,725"},{"v":6100,"d":"$6,100"},{"v":21350,"d":"$21,350"},{"v":4575,"d":"$4,575"},{"v":1525,"d":"$1,525"},{"v":54900,"d":"$54,900"}]
[null,"Humongous Insurance",{"v":14125,"d":"$14,125"},{"v":25425,"d":"$25,425"},{"v":22600,"d":"$22,600"},{"v":19775,"d":"$19,775"},{"v":16950,"d":"$16,950"},{"v":2825,"d":"$2,825"},{"v":101700,"d":"$101,700"}]
[null,"Litware, Inc.",{"v":8750,"d":"$8,750"},{"v":15750,"d":"$15,750"},{"v":14000,"d":"$14,000"},{"v":12250,"d":"$12,250"},{"v":10500,"d":"$10,500"},{"v":1750,"d":"$1,750"},{"v":63000,"d":"$63,000"}]
[null,"Lucerne Publishing",{"v":5125,"d":"$5,125"},{"v":9225,"d":"$9,225"},{"v":8200,"d":"$8,200"},{"v":7175,"d":"$7,175"},{"v":6150,"d":"$6,150"},{"v":1025,"d":"$1,025"},{"v":36900,"d":"$36,900"}]
[null,"Margie's Travel",{"v":5750,"d":"$5,750"},{"v":10350,"d":"$10,350"},{"v":9200,"d":"$9,200"},{"v":8050,"d":"$8,050"},{"v":6900,"d":"$6,900"},{"v":1150,"d":"$1,150"},{"v":41400,"d":"$41,400"}]
[null,"Northwind Traders",{"v":14000,"d":"$14,000"},{"v":25200,"d":"$25,200"},{"v":22400,"d":"$22,400"},{"v":19600,"d":"$19,600"},{"v":16800,"d":"$16,800"},{"v":2800,"d":"$2,800"},{"v":100800,"d":"$100,800"}]
[null,"Proseware, Inc.",{"v":13500,"d":"$13,500"},{"v":12150,"d":"$12,150"},{"v":54000,"d":"$54,000"},0,{"v":16200,"d":"$16,200"},{"v":2700,"d":"$2,700"},{"v":98550,"d":"$98,550"}]
[null,"School of Fine Art",{"v":4750,"d":"$4,750"},{"v":4275,"d":"$4,275"},{"v":19000,"d":"$19,000"},0,{"v":5700,"d":"$5,700"},{"v":950,"d":"$950"},{"v":34675,"d":"$34,675"}]
[null,"TOTAL Cost",{"v":190250,"d":"$190,250"},{"v":311512.5,"d":"$311,513"},{"v":285400,"d":"$285,400"},{"v":290587.5,"d":"$290,588"},{"v":242400,"d":"$242,400"},{"v":38050,"d":"$38,050"},{"v":1358200,"d":"$1,358,200"}]
[null,"TOTAL Hours",761,{"v":1384.5,"d":"1,385"},{"v":1427,"d":"1,427"},{"v":1660.5,"d":"1,661"},{"v":1616,"d":"1,616"},761,{"v":7610,"d":"7,610"}]