{"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":4},"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":13,"n_cols":9,"rows_kept":13,"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Event Management Project Tracker"]
[null,"Company Confidential"]
[]
[null,"Shaded cells are calculated for you. You do not need to enter anything into them."]
[null,"Project type","Account manager","Project manager","Strategy specialist","Design\nspecialist","Event\nstaff","Administration staff","Total"]
[null,"Event strategy development",{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.6,"d":"60%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"v":1,"d":"100%"}]
[null,"Event planning",{"v":0.2,"d":"20%"},{"v":0.5,"d":"50%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"v":0.9999999999999999,"d":"100%"}]
[null,"Event design",{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"v":1,"d":"100%"}]
[null,"Event logistics",{"v":0.2,"d":"20%"},{"v":0.6,"d":"60%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":1,"d":"100%"}]
[null,"Event staffing",{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.6,"d":"60%"},{"v":0.1,"d":"10%"},{"v":1,"d":"100%"}]
[null,"Event assessment",{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"v":0.2,"d":"20%"},{"v":1,"d":"100%"}]
[null,"Blended rates",{"v":180,"d":"$180"},{"v":120,"d":"$120"},{"v":150,"d":"$150"},{"v":100,"d":"$100"},{"v":80,"d":"$80"},{"v":60,"d":"$60"}]

{"sheet":"Planning","index":1,"n_rows":28,"n_cols":7,"rows_kept":28,"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Event Management Project Tracker"]
[null,"Company Confidential"]
[]
[null,"Project name","Project type","Estimated start","Estimated finish","Estimated work","Duration"]
[null,"A. Datum Corporation","Event strategy development","2005-01-04","2005-03-04",200,60]
[null,"Adventure Works","Event planning","2005-01-20","2005-02-21",400,31]
[null,"Alpine Ski House","Event design","2005-02-06","2005-04-16",500,70]
[null,"Baldwin Museum of Science","Event logistics","2005-02-24","2005-04-25",150,61]
[null,"Blue Yonder Airlines","Event staffing","2005-03-08","2005-03-18",250,10]
[null,"City Power & Light","Event assessment","2005-03-19","2005-04-29",300,40]
[null,"Coho Vineyard","Event planning","2005-04-10","2005-04-20",500,10]
[null,"Coho Winery","Event logistics","2005-04-18","2005-05-12",750,24]
[null,"Coho Vineyard & Winery","Event assessment","2005-05-12","2005-06-22",450,40]
[null,"Contoso, Ltd.","Event staffing","2005-05-23","2005-07-21",250,58]
[null,"Contoso Pharmaceuticals","Event planning","2005-06-14","2005-08-12",200,58]
[null,"Consolidated Messenger","Event strategy development","2005-06-30","2005-08-30",180,60]
[null,"Fabrikam, Inc.","Event staffing","2005-01-16","2005-08-15",250,209]
[null,"Fourth Coffee","Event logistics","2005-07-17","2005-09-01",240,44]
[null,"Graphic Design Institute","Event design","2005-07-25","2005-09-30",320,65]
[null,"Humongous Insurance","Event planning","2005-08-01","2005-10-01",550,60]
[null,"Litware, Inc.","Event design","2005-08-20","2005-10-02",350,42]
[null,"Lucerne Publishing","Event strategy development","2005-09-02","2005-11-12",200,70]
[null,"Margie's Travel","Event planning","2005-09-12","2005-11-25",220,73]
[null,"Northwind Traders","Event assessment","2005-10-12","2005-12-20",600,68]
[null,"Proseware, Inc.","Event logistics","2005-10-24","2005-12-14",525,50]
[null,"School of Fine Art","Event 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,"Event Management Project Tracker"]
[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,"Event Management Project Tracker"]
[null,"Company Confidential"]
[]
[null,"Project name","Account manager","Project manager","Strategy specialist","Design\nspecialist","Event\nstaff","Administration staff","Total"]
[null,"A. Datum Corporation",{"v":7200,"d":"$7,200"},{"v":2400,"d":"$2,400"},{"v":18000,"d":"$18,000"},0,0,{"v":1200,"d":"$1,200"},{"v":28800,"d":"$28,800"}]
[null,"Adventure Works",{"v":14400,"d":"$14,400"},{"v":24000,"d":"$24,000"},{"v":6000,"d":"$6,000"},{"v":4000,"d":"$4,000"},0,{"v":2400,"d":"$2,400"},{"v":50800,"d":"$50,800"}]
[null,"Alpine Ski House",{"v":18000,"d":"$18,000"},{"v":12000,"d":"$12,000"},0,{"v":25000,"d":"$25,000"},0,{"v":3000,"d":"$3,000"},{"v":58000,"d":"$58,000"}]
[null,"Baldwin Museum of Science",{"v":5400,"d":"$5,400"},{"v":10800,"d":"$10,800"},0,0,{"v":1200,"d":"$1,200"},{"v":900,"d":"$900"},{"v":18300,"d":"$18,300"}]
[null,"Blue Yonder Airlines",{"v":9000,"d":"$9,000"},{"v":3000,"d":"$3,000"},0,0,{"v":12000,"d":"$12,000"},{"v":1500,"d":"$1,500"},{"v":25500,"d":"$25,500"}]
[null,"City Power & Light",{"v":10800,"d":"$10,800"},{"v":7200,"d":"$7,200"},{"v":9000,"d":"$9,000"},{"v":6000,"d":"$6,000"},0,{"v":3600,"d":"$3,600"},{"v":36600,"d":"$36,600"}]
[null,"Coho Vineyard",{"v":18000,"d":"$18,000"},{"v":30000,"d":"$30,000"},{"v":7500,"d":"$7,500"},{"v":5000,"d":"$5,000"},0,{"v":3000,"d":"$3,000"},{"v":63500,"d":"$63,500"}]
[null,"Coho Winery",{"v":27000,"d":"$27,000"},{"v":54000,"d":"$54,000"},0,0,{"v":6000,"d":"$6,000"},{"v":4500,"d":"$4,500"},{"v":91500,"d":"$91,500"}]
[null,"Coho Vineyard & Winery",{"v":16200,"d":"$16,200"},{"v":10800,"d":"$10,800"},{"v":13500,"d":"$13,500"},{"v":9000,"d":"$9,000"},0,{"v":5400,"d":"$5,400"},{"v":54900,"d":"$54,900"}]
[null,"Contoso, Ltd.",{"v":9000,"d":"$9,000"},{"v":3000,"d":"$3,000"},0,0,{"v":12000,"d":"$12,000"},{"v":1500,"d":"$1,500"},{"v":25500,"d":"$25,500"}]
[null,"Contoso Pharmaceuticals",{"v":7200,"d":"$7,200"},{"v":12000,"d":"$12,000"},{"v":3000,"d":"$3,000"},{"v":2000,"d":"$2,000"},0,{"v":1200,"d":"$1,200"},{"v":25400,"d":"$25,400"}]
[null,"Consolidated Messenger",{"v":6480,"d":"$6,480"},{"v":2160,"d":"$2,160"},{"v":16200,"d":"$16,200"},0,0,{"v":1080,"d":"$1,080"},{"v":25920,"d":"$25,920"}]
[null,"Fabrikam, Inc.",{"v":9000,"d":"$9,000"},{"v":3000,"d":"$3,000"},0,0,{"v":12000,"d":"$12,000"},{"v":1500,"d":"$1,500"},{"v":25500,"d":"$25,500"}]
[null,"Fourth Coffee",{"v":8640,"d":"$8,640"},{"v":17280,"d":"$17,280"},0,0,{"v":1920,"d":"$1,920"},{"v":1440,"d":"$1,440"},{"v":29280,"d":"$29,280"}]
[null,"Graphic Design Institute",{"v":11520,"d":"$11,520"},{"v":7680,"d":"$7,680"},0,{"v":16000,"d":"$16,000"},0,{"v":1920,"d":"$1,920"},{"v":37120,"d":"$37,120"}]
[null,"Humongous Insurance",{"v":19800,"d":"$19,800"},{"v":33000,"d":"$33,000"},{"v":8250,"d":"$8,250"},{"v":5500,"d":"$5,500"},0,{"v":3300,"d":"$3,300"},{"v":69850,"d":"$69,850"}]
[null,"Litware, Inc.",{"v":12600,"d":"$12,600"},{"v":8400,"d":"$8,400"},0,{"v":17500,"d":"$17,500"},0,{"v":2100,"d":"$2,100"},{"v":40600,"d":"$40,600"}]
[null,"Lucerne Publishing",{"v":7200,"d":"$7,200"},{"v":2400,"d":"$2,400"},{"v":18000,"d":"$18,000"},0,0,{"v":1200,"d":"$1,200"},{"v":28800,"d":"$28,800"}]
[null,"Margie's Travel",{"v":7920,"d":"$7,920"},{"v":13200,"d":"$13,200"},{"v":3300,"d":"$3,300"},{"v":2200,"d":"$2,200"},0,{"v":1320,"d":"$1,320"},{"v":27940,"d":"$27,940"}]
[null,"Northwind Traders",{"v":21600,"d":"$21,600"},{"v":14400,"d":"$14,400"},{"v":18000,"d":"$18,000"},{"v":12000,"d":"$12,000"},0,{"v":7200,"d":"$7,200"},{"v":73200,"d":"$73,200"}]
[null,"Proseware, Inc.",{"v":18900,"d":"$18,900"},{"v":37800,"d":"$37,800"},0,0,{"v":4200,"d":"$4,200"},{"v":3150,"d":"$3,150"},{"v":64050,"d":"$64,050"}]
[null,"School of Fine Art",{"v":6480,"d":"$6,480"},{"v":10800,"d":"$10,800"},{"v":2700,"d":"$2,700"},{"v":1800,"d":"$1,800"},0,{"v":1080,"d":"$1,080"},{"v":22860,"d":"$22,860"}]
[null,"TOTAL Cost",{"v":272340,"d":"$272,340"},{"v":319320,"d":"$319,320"},{"v":123450,"d":"$123,450"},{"v":106000,"d":"$106,000"},{"v":49320,"d":"$49,320"},{"v":53490,"d":"$53,490"},{"v":923920,"d":"$923,920"}]
[null,"TOTAL Hours",{"v":1513,"d":"1,513"},{"v":2661,"d":"2,661"},823,{"v":1060,"d":"1,060"},{"v":616.5,"d":"617"},{"v":891.5,"d":"892"},{"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,"Event Management Project Tracker"]
[null,"Company Confidential"]
[]
[null,"Project name","Account manager","Project manager","Strategy specialist","Design\nspecialist","Event\nstaff","Administration staff","Total"]
[null,"A. Datum Corporation",{"v":7920,"d":"$7,920"},{"v":2640,"d":"$2,640"},{"v":19800,"d":"$19,800"},0,0,{"v":1320,"d":"$1,320"},{"v":31680,"d":"$31,680"}]
[null,"Adventure Works",{"v":14040,"d":"$14,040"},{"v":23400,"d":"$23,400"},{"v":5850,"d":"$5,850"},{"v":3900,"d":"$3,900"},0,{"v":2340,"d":"$2,340"},{"v":49530,"d":"$49,530"}]
[null,"Alpine Ski House",{"v":18000,"d":"$18,000"},{"v":12000,"d":"$12,000"},0,{"v":25000,"d":"$25,000"},0,{"v":3000,"d":"$3,000"},{"v":58000,"d":"$58,000"}]
[null,"Baldwin Museum of Science",{"v":5220,"d":"$5,220"},{"v":10440,"d":"$10,440"},0,0,{"v":1160,"d":"$1,160"},{"v":870,"d":"$870"},{"v":17690,"d":"$17,690"}]
[null,"Blue Yonder Airlines",{"v":9180,"d":"$9,180"},{"v":3060,"d":"$3,060"},0,0,{"v":12240,"d":"$12,240"},{"v":1530,"d":"$1,530"},{"v":26010,"d":"$26,010"}]
[null,"City Power & Light",{"v":11160,"d":"$11,160"},{"v":7440,"d":"$7,440"},{"v":9300,"d":"$9,300"},{"v":6200,"d":"$6,200"},0,{"v":3720,"d":"$3,720"},{"v":37820,"d":"$37,820"}]
[null,"Coho Vineyard",{"v":18360,"d":"$18,360"},{"v":30600,"d":"$30,600"},{"v":7650,"d":"$7,650"},{"v":5100,"d":"$5,100"},0,{"v":3060,"d":"$3,060"},{"v":64770,"d":"$64,770"}]
[null,"Coho Winery",{"v":28440,"d":"$28,440"},{"v":56880,"d":"$56,880"},0,0,{"v":6320,"d":"$6,320"},{"v":4740,"d":"$4,740"},{"v":96380,"d":"$96,380"}]
[null,"Coho Vineyard & Winery",{"v":15480,"d":"$15,480"},{"v":10320,"d":"$10,320"},{"v":12900,"d":"$12,900"},{"v":8600,"d":"$8,600"},0,{"v":5160,"d":"$5,160"},{"v":52460,"d":"$52,460"}]
[null,"Contoso, Ltd.",{"v":8460,"d":"$8,460"},{"v":2820,"d":"$2,820"},0,0,{"v":11280,"d":"$11,280"},{"v":1410,"d":"$1,410"},{"v":23970,"d":"$23,970"}]
[null,"Contoso Pharmaceuticals",{"v":8460,"d":"$8,460"},{"v":14100,"d":"$14,100"},{"v":3525,"d":"$3,525"},{"v":2350,"d":"$2,350"},0,{"v":1410,"d":"$1,410"},{"v":29845,"d":"$29,845"}]
[null,"Consolidated Messenger",{"v":6840,"d":"$6,840"},{"v":2280,"d":"$2,280"},{"v":17100,"d":"$17,100"},0,0,{"v":1140,"d":"$1,140"},{"v":27360,"d":"$27,360"}]
[null,"Fabrikam, Inc.",{"v":8280,"d":"$8,280"},{"v":2760,"d":"$2,760"},0,0,{"v":11040,"d":"$11,040"},{"v":1380,"d":"$1,380"},{"v":23460,"d":"$23,460"}]
[null,"Fourth Coffee",{"v":8100,"d":"$8,100"},{"v":16200,"d":"$16,200"},0,0,{"v":1800,"d":"$1,800"},{"v":1350,"d":"$1,350"},{"v":27450,"d":"$27,450"}]
[null,"Graphic Design Institute",{"v":10980,"d":"$10,980"},{"v":7320,"d":"$7,320"},0,{"v":15250,"d":"$15,250"},0,{"v":1830,"d":"$1,830"},{"v":35380,"d":"$35,380"}]
[null,"Humongous Insurance",{"v":20340,"d":"$20,340"},{"v":33900,"d":"$33,900"},{"v":8475,"d":"$8,475"},{"v":5650,"d":"$5,650"},0,{"v":3390,"d":"$3,390"},{"v":71755,"d":"$71,755"}]
[null,"Litware, Inc.",{"v":12600,"d":"$12,600"},{"v":8400,"d":"$8,400"},0,{"v":17500,"d":"$17,500"},0,{"v":2100,"d":"$2,100"},{"v":40600,"d":"$40,600"}]
[null,"Lucerne Publishing",{"v":7380,"d":"$7,380"},{"v":2460,"d":"$2,460"},{"v":18450,"d":"$18,450"},0,0,{"v":1230,"d":"$1,230"},{"v":29520,"d":"$29,520"}]
[null,"Margie's Travel",{"v":8280,"d":"$8,280"},{"v":13800,"d":"$13,800"},{"v":3450,"d":"$3,450"},{"v":2300,"d":"$2,300"},0,{"v":1380,"d":"$1,380"},{"v":29210,"d":"$29,210"}]
[null,"Northwind Traders",{"v":20160,"d":"$20,160"},{"v":13440,"d":"$13,440"},{"v":16800,"d":"$16,800"},{"v":11200,"d":"$11,200"},0,{"v":6720,"d":"$6,720"},{"v":68320,"d":"$68,320"}]
[null,"Proseware, Inc.",{"v":19440,"d":"$19,440"},{"v":38880,"d":"$38,880"},0,0,{"v":4320,"d":"$4,320"},{"v":3240,"d":"$3,240"},{"v":65880,"d":"$65,880"}]
[null,"School of Fine Art",{"v":6840,"d":"$6,840"},{"v":11400,"d":"$11,400"},{"v":2850,"d":"$2,850"},{"v":1900,"d":"$1,900"},0,{"v":1140,"d":"$1,140"},{"v":24130,"d":"$24,130"}]
[null,"TOTAL Cost",{"v":273960,"d":"$273,960"},{"v":324540,"d":"$324,540"},{"v":126150,"d":"$126,150"},{"v":104950,"d":"$104,950"},{"v":48160,"d":"$48,160"},{"v":53460,"d":"$53,460"},{"v":931220,"d":"$931,220"}]
[null,"TOTAL Hours",{"v":1522,"d":"1,522"},{"v":2704.5,"d":"2,705"},841,{"v":1049.5,"d":"1,050"},602,891,{"v":7610,"d":"7,610"}]