{"text_format":"3","workbook":"xls","n_sheets":7,"sheets":["Project Parameters","Actuals","Actual Totals","Monthly Billings","Billing Timeline","Account Billing","Skill Type Billing"],"not_rendered":{"charts":3,"external_links":1,"defined_names":4},"unopened":[{"sheet":"Billing Timeline","index":4,"reason":"not_a_worksheet"},{"sheet":"Account Billing","index":5,"reason":"not_a_worksheet"},{"sheet":"Skill Type Billing","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,"Project Analysis for Business Consulting Firms"]
[null,"Company Confidential"]
[null,"Dark gray cells will be 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":"Actuals","index":1,"n_rows":30,"n_cols":7,"rows_kept":30,"flags":["formulas_cached_only"]}
[null,"[Company Name]  "]
[null,"Project Analysis for Business Consulting Firms"]
[null,"Company Confidential"]
[]
[null,"Dark gray cells will be calculated for you. You do not need to enter anything into them."]
[null,"Project name","Project type","Actual start","Actual finish","Actual work in hours","Duration in days"]
[null,"A. Datum Corporation","Business continuity planning","2004-01-04","2004-03-04",200,60]
[null,"Adventure Works","Business process re-engineering","2004-01-20","2004-02-21",400,31]
[null,"Alpine Ski House","Cost reduction","2004-02-06","2004-04-16",500,70]
[null,"Baldwin Museum of Science","Process improvement","2004-02-24","2004-04-25",150,61]
[null,"Blue Yonder Airlines","Cost reduction","2004-03-08","2004-03-18",250,10]
[null,"City Power & Light","Sarbanes-Oxley","2004-03-19","2004-04-29",300,40]
[null,"Coho Vineyard","Strategic planning","2004-04-10","2004-04-20",500,10]
[null,"Coho Winery","Cost reduction","2004-04-18","2004-05-12",750,24]
[null,"Coho Vineyard & Winery","Sarbanes-Oxley","2004-05-12","2004-06-22",450,40]
[null,"Contoso, Ltd.","Cost reduction","2004-05-23","2004-07-21",250,58]
[null,"Contoso Pharmaceuticals","Business process re-engineering","2004-06-14","2004-08-12",200,58]
[null,"Consolidated Messenger","Process improvement","2004-06-30","2004-08-30",180,60]
[null,"Fabrikam, Inc.","Cost reduction","2004-01-16","2004-08-15",250,209]
[null,"Fourth Coffee","Sarbanes-Oxley","2004-07-17","2004-09-01",240,44]
[null,"Graphic Design Institute","Sarbanes-Oxley","2004-07-25","2004-09-30",320,65]
[null,"Humongous Insurance","Cost reduction","2004-08-01","2004-10-01",550,60]
[null,"Litware, Inc.","Strategic planning","2004-08-20","2004-10-02",350,42]
[null,"Lucerne Publishing","Business continuity planning","2004-09-02","2004-11-12",200,70]
[null,"Margie's Travel","Cost reduction","2004-09-12","2004-11-25",220,73]
[null,"Northwind Traders","Process improvement","2004-10-12","2004-12-20",600,68]
[null,"Proseware, Inc.","Sarbanes-Oxley","2004-10-24","2004-12-14",525,50]
[null,"School of Fine Art","Cost reduction","2004-11-04","2004-11-24",180,20]
[]
[null,"Total",{"$nulls":3},{"v":7565,"d":"7,565"}]

{"sheet":"Actual Totals","index":2,"n_rows":29,"n_cols":10,"rows_kept":29,"flags":["formulas_cached_only"]}
[null,"[Company Name]  "]
[null,"Project Analysis for Business Consulting Firms"]
[null,"Company Confidential"]
[]
[null,"Project name","Account manager","Project manager","Business analyst","Process specialist","Finance specialist","Administration staff","Month of completion","Total\nbillings"]
[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"},3,{"v":37500,"d":"$37,500"}]
[null,"Adventure Works",{"v":10000,"d":"$10,000"},{"v":9000,"d":"$9,000"},{"v":8000,"d":"$8,000"},{"v":35000,"d":"$35,000"},{"v":6000,"d":"$6,000"},{"v":2000,"d":"$2,000"},2,{"v":70000,"d":"$70,000"}]
[null,"Alpine Ski House",{"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"},4,{"v":87500,"d":"$87,500"}]
[null,"Baldwin Museum of Science",{"v":3750,"d":"$3,750"},{"v":6750,"d":"$6,750"},{"v":3000,"d":"$3,000"},{"v":10500,"d":"$10,500"},{"v":2250,"d":"$2,250"},{"v":750,"d":"$750"},4,{"v":27000,"d":"$27,000"}]
[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"},3,{"v":43750,"d":"$43,750"}]
[null,"City Power & Light",{"v":7500,"d":"$7,500"},{"v":13500,"d":"$13,500"},{"v":12000,"d":"$12,000"},{"v":10500,"d":"$10,500"},{"v":9000,"d":"$9,000"},{"v":1500,"d":"$1,500"},4,{"v":54000,"d":"$54,000"}]
[null,"Coho Vineyard",{"v":12500,"d":"$12,500"},{"v":11250,"d":"$11,250"},{"v":50000,"d":"$50,000"},0,{"v":15000,"d":"$15,000"},{"v":2500,"d":"$2,500"},4,{"v":91250,"d":"$91,250"}]
[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"},5,{"v":131250,"d":"$131,250"}]
[null,"Coho Vineyard & Winery",{"v":11250,"d":"$11,250"},{"v":20250,"d":"$20,250"},{"v":18000,"d":"$18,000"},{"v":15750,"d":"$15,750"},{"v":13500,"d":"$13,500"},{"v":2250,"d":"$2,250"},6,{"v":81000,"d":"$81,000"}]
[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"},7,{"v":43750,"d":"$43,750"}]
[null,"Contoso Pharmaceuticals",{"v":5000,"d":"$5,000"},{"v":4500,"d":"$4,500"},{"v":4000,"d":"$4,000"},{"v":17500,"d":"$17,500"},{"v":3000,"d":"$3,000"},{"v":1000,"d":"$1,000"},8,{"v":35000,"d":"$35,000"}]
[null,"Consolidated Messenger",{"v":4500,"d":"$4,500"},{"v":8100,"d":"$8,100"},{"v":3600,"d":"$3,600"},{"v":12600,"d":"$12,600"},{"v":2700,"d":"$2,700"},{"v":900,"d":"$900"},8,{"v":32400,"d":"$32,400"}]
[null,"Fabrikam, Inc.",{"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"},8,{"v":43750,"d":"$43,750"}]
[null,"Fourth Coffee",{"v":6000,"d":"$6,000"},{"v":10800,"d":"$10,800"},{"v":9600,"d":"$9,600"},{"v":8400,"d":"$8,400"},{"v":7200,"d":"$7,200"},{"v":1200,"d":"$1,200"},9,{"v":43200,"d":"$43,200"}]
[null,"Graphic Design Institute",{"v":8000,"d":"$8,000"},{"v":14400,"d":"$14,400"},{"v":12800,"d":"$12,800"},{"v":11200,"d":"$11,200"},{"v":9600,"d":"$9,600"},{"v":1600,"d":"$1,600"},9,{"v":57600,"d":"$57,600"}]
[null,"Humongous Insurance",{"v":13750,"d":"$13,750"},{"v":24750,"d":"$24,750"},{"v":11000,"d":"$11,000"},{"v":19250,"d":"$19,250"},{"v":24750,"d":"$24,750"},{"v":2750,"d":"$2,750"},10,{"v":96250,"d":"$96,250"}]
[null,"Litware, Inc.",{"v":8750,"d":"$8,750"},{"v":7875,"d":"$7,875"},{"v":35000,"d":"$35,000"},0,{"v":10500,"d":"$10,500"},{"v":1750,"d":"$1,750"},10,{"v":63875,"d":"$63,875"}]
[null,"Lucerne Publishing",{"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"},11,{"v":37500,"d":"$37,500"}]
[null,"Margie's Travel",{"v":5500,"d":"$5,500"},{"v":9900,"d":"$9,900"},{"v":4400,"d":"$4,400"},{"v":7700,"d":"$7,700"},{"v":9900,"d":"$9,900"},{"v":1100,"d":"$1,100"},11,{"v":38500,"d":"$38,500"}]
[null,"Northwind Traders",{"v":15000,"d":"$15,000"},{"v":27000,"d":"$27,000"},{"v":12000,"d":"$12,000"},{"v":42000,"d":"$42,000"},{"v":9000,"d":"$9,000"},{"v":3000,"d":"$3,000"},12,{"v":108000,"d":"$108,000"}]
[null,"Proseware, Inc.",{"v":13125,"d":"$13,125"},{"v":23625,"d":"$23,625"},{"v":21000,"d":"$21,000"},{"v":18375,"d":"$18,375"},{"v":15750,"d":"$15,750"},{"v":2625,"d":"$2,625"},12,{"v":94500,"d":"$94,500"}]
[null,"School of Fine Art",{"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"},11,{"v":31500,"d":"$31,500"}]
[null,"Total Billings",{"v":189125,"d":"$189,125"},{"v":307800,"d":"$307,800"},{"v":280000,"d":"$280,000"},{"v":292075,"d":"$292,075"},{"v":242250,"d":"$242,250"},{"v":37825,"d":"$37,825"},null,{"v":1349075,"d":"$1,349,075"}]
[null,"Total Hours",{"v":756.5,"d":"757"},{"v":1368,"d":"1,368"},{"v":1400,"d":"1,400"},{"v":1669,"d":"1,669"},{"v":1615,"d":"1,615"},{"v":756.5,"d":"757"},null,{"v":7565,"d":"7,565"}]

{"sheet":"Monthly Billings","index":3,"n_rows":29,"n_cols":16,"rows_kept":29,"flags":["formulas_cached_only"]}
[null,"[Company Name]  "]
[null,"Project Analysis for Business Consulting Firms"]
[null,"Company Confidential"]
[]
[null,"Project name","Month of completion","Total\nbillings","January totals","February totals","March totals","April\ntotals","May\ntotals","June\ntotals","July totals","August totals","September totals","October totals","November totals","December totals"]
[null,"A. Datum Corporation",3,{"v":37500,"d":"$37,500"},0,0,{"v":37500,"d":"$37,500"},0,0,0,0,0,0,0,0,0]
[null,"Adventure Works",2,{"v":70000,"d":"$70,000"},0,{"v":70000,"d":"$70,000"},0,0,0,0,0,0,0,0,0,0]
[null,"Alpine Ski House",4,{"v":87500,"d":"$87,500"},0,0,0,{"v":87500,"d":"$87,500"},0,0,0,0,0,0,0,0]
[null,"Baldwin Museum of Science",4,{"v":27000,"d":"$27,000"},0,0,0,{"v":27000,"d":"$27,000"},0,0,0,0,0,0,0,0]
[null,"Blue Yonder Airlines",3,{"v":43750,"d":"$43,750"},0,0,{"v":43750,"d":"$43,750"},0,0,0,0,0,0,0,0,0]
[null,"City Power & Light",4,{"v":54000,"d":"$54,000"},0,0,0,{"v":54000,"d":"$54,000"},0,0,0,0,0,0,0,0]
[null,"Coho Vineyard",4,{"v":91250,"d":"$91,250"},0,0,0,{"v":91250,"d":"$91,250"},0,0,0,0,0,0,0,0]
[null,"Coho Winery",5,{"v":131250,"d":"$131,250"},0,0,0,0,{"v":131250,"d":"$131,250"},0,0,0,0,0,0,0]
[null,"Coho Vineyard & Winery",6,{"v":81000,"d":"$81,000"},0,0,0,0,0,{"v":81000,"d":"$81,000"},0,0,0,0,0,0]
[null,"Contoso, Ltd.",7,{"v":43750,"d":"$43,750"},0,0,0,0,0,0,{"v":43750,"d":"$43,750"},0,0,0,0,0]
[null,"Contoso Pharmaceuticals",8,{"v":35000,"d":"$35,000"},0,0,0,0,0,0,0,{"v":35000,"d":"$35,000"},0,0,0,0]
[null,"Consolidated Messenger",8,{"v":32400,"d":"$32,400"},0,0,0,0,0,0,0,{"v":32400,"d":"$32,400"},0,0,0,0]
[null,"Fabrikam, Inc.",8,{"v":43750,"d":"$43,750"},0,0,0,0,0,0,0,{"v":43750,"d":"$43,750"},0,0,0,0]
[null,"Fourth Coffee",9,{"v":43200,"d":"$43,200"},0,0,0,0,0,0,0,0,{"v":43200,"d":"$43,200"},0,0,0]
[null,"Graphic Design Institute",9,{"v":57600,"d":"$57,600"},0,0,0,0,0,0,0,0,{"v":57600,"d":"$57,600"},0,0,0]
[null,"Humongous Insurance",10,{"v":96250,"d":"$96,250"},0,0,0,0,0,0,0,0,0,{"v":96250,"d":"$96,250"},0,0]
[null,"Litware, Inc.",10,{"v":63875,"d":"$63,875"},0,0,0,0,0,0,0,0,0,{"v":63875,"d":"$63,875"},0,0]
[null,"Lucerne Publishing",11,{"v":37500,"d":"$37,500"},0,0,0,0,0,0,0,0,0,0,{"v":37500,"d":"$37,500"},0]
[null,"Margie's Travel",11,{"v":38500,"d":"$38,500"},0,0,0,0,0,0,0,0,0,0,{"v":38500,"d":"$38,500"},0]
[null,"Northwind Traders",12,{"v":108000,"d":"$108,000"},0,0,0,0,0,0,0,0,0,0,0,{"v":108000,"d":"$108,000"}]
[null,"Proseware, Inc.",12,{"v":94500,"d":"$94,500"},0,0,0,0,0,0,0,0,0,0,0,{"v":94500,"d":"$94,500"}]
[null,"School of Fine Art",11,{"v":31500,"d":"$31,500"},0,0,0,0,0,0,0,0,0,0,{"v":31500,"d":"$31,500"},0]
[null,"Monthly Totals",null,{"v":1349075,"d":"$1,349,075"},0,{"v":70000,"d":"$70,000"},{"v":81250,"d":"$81,250"},{"v":259750,"d":"$259,750"},{"v":131250,"d":"$131,250"},{"v":81000,"d":"$81,000"},{"v":43750,"d":"$43,750"},{"v":111150,"d":"$111,150"},{"v":100800,"d":"$100,800"},{"v":160125,"d":"$160,125"},{"v":107500,"d":"$107,500"},{"v":202500,"d":"$202,500"}]
[null,"Accumulative Totals",null,null,0,{"v":70000,"d":"$70,000"},{"v":151250,"d":"$151,250"},{"v":411000,"d":"$411,000"},{"v":542250,"d":"$542,250"},{"v":623250,"d":"$623,250"},{"v":667000,"d":"$667,000"},{"v":778150,"d":"$778,150"},{"v":878950,"d":"$878,950"},{"v":1039075,"d":"$1,039,075"},{"v":1146575,"d":"$1,146,575"},{"v":1349075,"d":"$1,349,075"}]