{"text_format":"3","workbook":"xls","n_sheets":7,"sheets":["Actuals","Project Parameters","Actual Totals","Monthly Billings","Billing Timeline","Account Billing","Skill Type Billing"],"not_rendered":{"charts":3,"images":4,"external_links":1,"defined_names":2},"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":"Actuals","index":0,"n_rows":29,"n_cols":6,"rows_kept":29,"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Financial Analysis for Law Firms"]
["Company Confidential"]
[]
["Instructions: Enter values in the white and yellow cells only."]
["Project Name","Project Type","Actual Start","Actual Finish","Actual Work","Duration"]
["A. Datum Corporation","Business Incorporation","2004-01-04","2004-03-04",200,60]
["Adventure Works","Business Acquisition","2004-01-20","2004-02-21",400,31]
["Alpine Ski House","Product Liability Defense","2004-02-06","2004-04-16",500,70]
["Baldwin Museum of Science","Patent Application","2004-02-24","2004-04-25",150,61]
["Blue Yonder Airlines","Employee Lawsuit","2004-03-08","2004-03-18",250,10]
["City Power & Light","Bankruptcy","2004-03-19","2004-04-29",300,40]
["Coho Vineyard","Business Incorporation","2004-04-10","2004-04-20",500,10]
["Coho Winery","Product Liability Defense","2004-04-18","2004-05-12",750,24]
["Coho Vineyard & Winery","Patent Application","2004-05-12","2004-06-22",450,40]
["Contoso, Ltd.","Bankruptcy","2004-05-23","2004-07-21",250,58]
["Contoso Pharmaceuticals","Business Acquisition","2004-06-14","2004-08-12",200,58]
["Consolidated Messenger","Bankruptcy","2004-06-30","2004-08-30",180,60]
["Fabrikam, Inc.","Patent Application","2004-01-16","2004-08-15",250,209]
["Fourth Coffee","Product Liability Defense","2004-07-17","2004-09-01",240,44]
["Graphic Design Institute","Patent Application","2004-07-25","2004-09-30",320,65]
["Humongous Insurance","Business Acquisition","2004-08-01","2004-10-01",550,60]
["Litware, Inc.","Bankruptcy","2004-08-20","2004-10-02",350,42]
["Lucerne Publishing","Business Incorporation","2004-09-02","2004-11-12",200,70]
["Margie's Travel","Employee Lawsuit","2004-09-12","2004-11-25",220,73]
["Northwind Traders","Bankruptcy","2004-10-12","2004-12-20",600,68]
["Proseware, Inc.","Patent Application","2004-10-24","2004-12-14",525,50]
["School of Fine Art","Employee Lawsuit","2004-11-04","2004-11-24",180,20]
["TOTAL",{"$nulls":3},{"v":7565,"d":"7,565"}]

{"sheet":"Project Parameters","index":1,"n_rows":13,"n_cols":8,"rows_kept":13,"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Financial Analysis for Law Firms"]
["Company Confidential"]
[]
["Instructions: Enter values in the white and yellow cells only."]
["Project Type","General\nPartner","Business Lawyer","Defense Litigator","Intellectual Property Lawyer","Bankruptcy Lawyer","Administration Staff","Total"]
["Business Incorporation",{"v":0.1,"d":"10%"},{"v":0.4,"d":"40%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},{"v":1,"d":"100%"}]
["Business Acquisition",{"v":0.1,"d":"10%"},{"v":0.4,"d":"40%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"v":0.4,"d":"40%"},{"v":1,"d":"100%"}]
["Product Liability Defense",{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.3,"d":"30%"},{"v":1,"d":"100%"}]
["Patent Application",{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.6,"d":"60%"},{"v":0,"d":"0%"},{"v":0.3,"d":"30%"},{"v":1,"d":"100%"}]
["Employee Lawsuit",{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.4,"d":"40%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.3,"d":"30%"},{"v":1,"d":"100%"}]
["Bankruptcy",{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.4,"d":"40%"},{"v":0.3,"d":"30%"},{"v":1,"d":"100%"}]
["Blended Rates",{"v":350,"d":"$350"},{"v":250,"d":"$250"},{"v":300,"d":"$300"},{"v":275,"d":"$275"},{"v":225,"d":"$225"},{"v":125,"d":"$125"}]

{"sheet":"Actual Totals","index":2,"n_rows":30,"n_cols":9,"rows_kept":30,"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Financial Analysis for Law Firms"]
["Company Confidential"]
[]
[]
["Project Name","General\nPartner","Business Lawyer","Defense Litigator","Intellectual Property Lawyer","Bankruptcy Lawyer","Administration Staff","Month of Completion","Total\nBillings"]
["A. Datum Corporation",{"v":7000,"d":"$7,000"},{"v":20000,"d":"$20,000"},0,0,0,{"v":12500,"d":"$12,500"},3,{"v":39500,"d":"$39,500"}]
["Adventure Works",{"v":14000,"d":"$14,000"},{"v":40000,"d":"$40,000"},0,{"v":11000,"d":"$11,000"},0,{"v":20000,"d":"$20,000"},2,{"v":85000,"d":"$85,000"}]
["Alpine Ski House",{"v":35000,"d":"$35,000"},0,{"v":75000,"d":"$75,000"},0,0,{"v":18750,"d":"$18,750"},4,{"v":128750,"d":"$128,750"}]
["Baldwin Museum of Science",{"v":5250,"d":"$5,250"},0,0,{"v":24750,"d":"$24,750"},0,{"v":5625,"d":"$5,625"},4,{"v":35625,"d":"$35,625"}]
["Blue Yonder Airlines",{"v":17500,"d":"$17,500"},{"v":6250,"d":"$6,250"},{"v":30000,"d":"$30,000"},0,0,{"v":9375,"d":"$9,375"},3,{"v":63125,"d":"$63,125"}]
["City Power & Light",{"v":10500,"d":"$10,500"},{"v":15000,"d":"$15,000"},0,0,{"v":27000,"d":"$27,000"},{"v":11250,"d":"$11,250"},4,{"v":63750,"d":"$63,750"}]
["Coho Vineyard",{"v":17500,"d":"$17,500"},{"v":50000,"d":"$50,000"},0,0,0,{"v":31250,"d":"$31,250"},4,{"v":98750,"d":"$98,750"}]
["Coho Winery",{"v":52500,"d":"$52,500"},0,{"v":112500,"d":"$112,500"},0,0,{"v":28125,"d":"$28,125"},5,{"v":193125,"d":"$193,125"}]
["Coho Vineyard & Winery",{"v":15750,"d":"$15,750"},0,0,{"v":74250,"d":"$74,250"},0,{"v":16875,"d":"$16,875"},6,{"v":106875,"d":"$106,875"}]
["Contoso, Ltd.",{"v":8750,"d":"$8,750"},{"v":12500,"d":"$12,500"},0,0,{"v":22500,"d":"$22,500"},{"v":9375,"d":"$9,375"},7,{"v":53125,"d":"$53,125"}]
["Contoso Pharmaceuticals",{"v":7000,"d":"$7,000"},{"v":20000,"d":"$20,000"},0,{"v":5500,"d":"$5,500"},0,{"v":10000,"d":"$10,000"},8,{"v":42500,"d":"$42,500"}]
["Consolidated Messenger",{"v":6300,"d":"$6,300"},{"v":9000,"d":"$9,000"},0,0,{"v":16200,"d":"$16,200"},{"v":6750,"d":"$6,750"},8,{"v":38250,"d":"$38,250"}]
["Fabrikam, Inc.",{"v":8750,"d":"$8,750"},0,0,{"v":41250,"d":"$41,250"},0,{"v":9375,"d":"$9,375"},8,{"v":59375,"d":"$59,375"}]
["Fourth Coffee",{"v":16800,"d":"$16,800"},0,{"v":36000,"d":"$36,000"},0,0,{"v":9000,"d":"$9,000"},9,{"v":61800,"d":"$61,800"}]
["Graphic Design Institute",{"v":11200,"d":"$11,200"},0,0,{"v":52800,"d":"$52,800"},0,{"v":12000,"d":"$12,000"},9,{"v":76000,"d":"$76,000"}]
["Humongous Insurance",{"v":19250,"d":"$19,250"},{"v":55000,"d":"$55,000"},0,{"v":15125,"d":"$15,125"},0,{"v":27500,"d":"$27,500"},10,{"v":116875,"d":"$116,875"}]
["Litware, Inc.",{"v":12250,"d":"$12,250"},{"v":17500,"d":"$17,500"},0,0,{"v":31500,"d":"$31,500"},{"v":13125,"d":"$13,125"},10,{"v":74375,"d":"$74,375"}]
["Lucerne Publishing",{"v":7000,"d":"$7,000"},{"v":20000,"d":"$20,000"},0,0,0,{"v":12500,"d":"$12,500"},11,{"v":39500,"d":"$39,500"}]
["Margie's Travel",{"v":15400,"d":"$15,400"},{"v":5500,"d":"$5,500"},{"v":26400,"d":"$26,400"},0,0,{"v":8250,"d":"$8,250"},11,{"v":55550,"d":"$55,550"}]
["Northwind Traders",{"v":21000,"d":"$21,000"},{"v":30000,"d":"$30,000"},0,0,{"v":54000,"d":"$54,000"},{"v":22500,"d":"$22,500"},12,{"v":127500,"d":"$127,500"}]
["Proseware, Inc.",{"v":18375,"d":"$18,375"},0,0,{"v":86625,"d":"$86,625"},0,{"v":19687.5,"d":"$19,688"},12,{"v":124687.5,"d":"$124,688"}]
["School of Fine Art",{"v":12600,"d":"$12,600"},{"v":4500,"d":"$4,500"},{"v":21600,"d":"$21,600"},0,0,{"v":6750,"d":"$6,750"},11,{"v":45450,"d":"$45,450"}]
["TOTAL Billings",{"v":339675,"d":"$339,675"},{"v":305250,"d":"$305,250"},{"v":301500,"d":"$301,500"},{"v":311300,"d":"$311,300"},{"v":151200,"d":"$151,200"},{"v":320562.5,"d":"$320,563"},null,{"v":1729487.5,"d":"$1,729,488"}]
["TOTAL Hours",{"v":970.5,"d":"971"},{"v":1221,"d":"1,221"},{"v":1005,"d":"1,005"},{"v":1132,"d":"1,132"},672,{"v":2564.5,"d":"2,565"},null,{"v":7565,"d":"7,565"}]

{"sheet":"Monthly Billings","index":3,"n_rows":30,"n_cols":15,"rows_kept":30,"flags":["formulas_cached_only"]}
["<Company Name>  "]
["Financial Analysis for Law Firms"]
["Company Confidential"]
[]
[]
["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"]
["A. Datum Corporation",3,{"v":39500,"d":"$39,500"},0,0,{"v":39500,"d":"$39,500"},0,0,0,0,0,0,0,0,0]
["Adventure Works",2,{"v":85000,"d":"$85,000"},0,{"v":85000,"d":"$85,000"},0,0,0,0,0,0,0,0,0,0]
["Alpine Ski House",4,{"v":128750,"d":"$128,750"},0,0,0,{"v":128750,"d":"$128,750"},0,0,0,0,0,0,0,0]
["Baldwin Museum of Science",4,{"v":35625,"d":"$35,625"},0,0,0,{"v":35625,"d":"$35,625"},0,0,0,0,0,0,0,0]
["Blue Yonder Airlines",3,{"v":63125,"d":"$63,125"},0,0,{"v":63125,"d":"$63,125"},0,0,0,0,0,0,0,0,0]
["City Power & Light",4,{"v":63750,"d":"$63,750"},0,0,0,{"v":63750,"d":"$63,750"},0,0,0,0,0,0,0,0]
["Coho Vineyard",4,{"v":98750,"d":"$98,750"},0,0,0,{"v":98750,"d":"$98,750"},0,0,0,0,0,0,0,0]
["Coho Winery",5,{"v":193125,"d":"$193,125"},0,0,0,0,{"v":193125,"d":"$193,125"},0,0,0,0,0,0,0]
["Coho Vineyard & Winery",6,{"v":106875,"d":"$106,875"},0,0,0,0,0,{"v":106875,"d":"$106,875"},0,0,0,0,0,0]
["Contoso, Ltd.",7,{"v":53125,"d":"$53,125"},0,0,0,0,0,0,{"v":53125,"d":"$53,125"},0,0,0,0,0]
["Contoso Pharmaceuticals",8,{"v":42500,"d":"$42,500"},0,0,0,0,0,0,0,{"v":42500,"d":"$42,500"},0,0,0,0]
["Consolidated Messenger",8,{"v":38250,"d":"$38,250"},0,0,0,0,0,0,0,{"v":38250,"d":"$38,250"},0,0,0,0]
["Fabrikam, Inc.",8,{"v":59375,"d":"$59,375"},0,0,0,0,0,0,0,{"v":59375,"d":"$59,375"},0,0,0,0]
["Fourth Coffee",9,{"v":61800,"d":"$61,800"},0,0,0,0,0,0,0,0,{"v":61800,"d":"$61,800"},0,0,0]
["Graphic Design Institute",9,{"v":76000,"d":"$76,000"},0,0,0,0,0,0,0,0,{"v":76000,"d":"$76,000"},0,0,0]
["Humongous Insurance",10,{"v":116875,"d":"$116,875"},0,0,0,0,0,0,0,0,0,{"v":116875,"d":"$116,875"},0,0]
["Litware, Inc.",10,{"v":74375,"d":"$74,375"},0,0,0,0,0,0,0,0,0,{"v":74375,"d":"$74,375"},0,0]
["Lucerne Publishing",11,{"v":39500,"d":"$39,500"},0,0,0,0,0,0,0,0,0,0,{"v":39500,"d":"$39,500"},0]
["Margie's Travel",11,{"v":55550,"d":"$55,550"},0,0,0,0,0,0,0,0,0,0,{"v":55550,"d":"$55,550"},0]
["Northwind Traders",12,{"v":127500,"d":"$127,500"},0,0,0,0,0,0,0,0,0,0,0,{"v":127500,"d":"$127,500"}]
["Proseware, Inc.",12,{"v":124687.5,"d":"$124,688"},0,0,0,0,0,0,0,0,0,0,0,{"v":124687.5,"d":"$124,688"}]
["School of Fine Art",11,{"v":45450,"d":"$45,450"},0,0,0,0,0,0,0,0,0,0,{"v":45450,"d":"$45,450"},0]
["MONTHLY TOTALS",null,{"v":1729487.5,"d":"$1,729,488"},0,{"v":85000,"d":"$85,000"},{"v":102625,"d":"$102,625"},{"v":326875,"d":"$326,875"},{"v":193125,"d":"$193,125"},{"v":106875,"d":"$106,875"},{"v":53125,"d":"$53,125"},{"v":140125,"d":"$140,125"},{"v":137800,"d":"$137,800"},{"v":191250,"d":"$191,250"},{"v":140500,"d":"$140,500"},{"v":252187.5,"d":"$252,188"}]
["ACCUMULATIVE TOTALS",null,null,0,{"v":85000,"d":"$85,000"},{"v":187625,"d":"$187,625"},{"v":514500,"d":"$514,500"},{"v":707625,"d":"$707,625"},{"v":814500,"d":"$814,500"},{"v":867625,"d":"$867,625"},{"v":1007750,"d":"$1,007,750"},{"v":1145550,"d":"$1,145,550"},{"v":1336800,"d":"$1,336,800"},{"v":1477300,"d":"$1,477,300"},{"v":1729487.5,"d":"$1,729,488"}]