{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["PROJECT PARAMETERS","PROJECT DETAILS","PROJECT TOTALS"],"not_rendered":{"charts":2,"defined_names":3,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"PROJECT PARAMETERS","index":0,"n_rows":21,"n_cols":9,"rows_kept":21}
[]
[null,"[Company Name]"]
[null,"Project Planning for Law Firms"]
[null,"Company Confidential"]
[]
[null,"Shaded cells are calculated for you. You do not need to enter anything into them."]
[null,"PROJECT TYPE","GENERAL PARTNER","BUSINESS LAWYER","DEFENSE LITIGATOR","INTELLECTUAL PROPERTY LAWYER","BANKRUPTCY LAWYER","ADMIN STAFF","TOTAL"]
[null,"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%"},{"$f":"SUM(tblParameters[[#This Row],[GENERAL PARTNER]:[ADMIN STAFF]])","v":{"v":1,"d":"100%"}}]
[null,"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%"},{"$f":"SUM(tblParameters[[#This Row],[GENERAL PARTNER]:[ADMIN STAFF]])","v":{"v":1,"d":"100%"}}]
[null,"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%"},{"$f":"SUM(tblParameters[[#This Row],[GENERAL PARTNER]:[ADMIN STAFF]])","v":{"v":1,"d":"100%"}}]
[null,"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%"},{"$f":"SUM(tblParameters[[#This Row],[GENERAL PARTNER]:[ADMIN STAFF]])","v":{"v":1,"d":"100%"}}]
[null,"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%"},{"$f":"SUM(tblParameters[[#This Row],[GENERAL PARTNER]:[ADMIN STAFF]])","v":{"v":1,"d":"100%"}}]
[null,"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%"},{"$f":"SUM(tblParameters[[#This Row],[GENERAL PARTNER]:[ADMIN STAFF]])","v":{"v":1,"d":"100%"}}]
[null,"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"}]
[]
[]
[null,null,"GENERAL PARTNER","BUSINESS","DEFENSE LITIGATOR","INTELLECTUAL PROP.","BANKRUPTCY","ADMIN STAFF"]
[null,"PLANNED COST",{"$f":"SUBTOTAL(109,tblDetails[GENERAL PARTNER])","v":{"v":339675,"d":"$339,675.00"}},{"$f":"SUBTOTAL(109,tblDetails[BUSINESS LAWYER])","v":{"v":305250,"d":"$305,250.00"}},{"$f":"SUBTOTAL(109,tblDetails[DEFENSE LITIGATOR])","v":{"v":301500,"d":"$301,500.00"}},{"$f":"SUBTOTAL(109,tblDetails[INTELLECTUAL PROPERTY LAWYER])","v":{"v":311300,"d":"$311,300.00"}},{"$f":"SUBTOTAL(109,tblDetails[BANKRUPTCY LAWYER])","v":{"v":151200,"d":"$151,200.00"}},{"$f":"SUBTOTAL(109,tblDetails[ADMIN STAFF])","v":{"v":320562.5,"d":"$320,562.50"}}]
[null,"ACTUAL COST",{"$f":"SUBTOTAL(109,tblDetails[GENERAL PARTNER 2])","v":{"v":343000,"d":"$343,000.00"}},{"$f":"SUBTOTAL(109,tblDetails[BUSINESS LAWYER 2])","v":{"v":311625,"d":"$311,625.00"}},{"$f":"SUBTOTAL(109,tblDetails[DEFENSE LITIGATOR 2])","v":{"v":308250,"d":"$308,250.00"}},{"$f":"SUBTOTAL(109,tblDetails[INTELLECTUAL PROPERTY LAWYER 2])","v":{"v":304975,"d":"$304,975.00"}},{"$f":"SUBTOTAL(109,tblDetails[BANKRUPTCY LAWYER 2])","v":{"v":148050,"d":"$148,050.00"}},{"$f":"SUBTOTAL(109,tblDetails[ADMIN STAFF 2])","v":{"v":323625,"d":"$323,625.00"}}]
[null,"PLANNED HOURS",{"$f":"C18/$C$14","v":{"v":970.5,"d":"970.50"}},{"$f":"D18/$C$14","v":{"v":872.1428571428571,"d":"872.14"}},{"v":861.4285714285714,"d":"861.43"},{"v":889.4285714285714,"d":"889.43"},{"v":432,"d":"432.00"},{"v":915.8928571428571,"d":"915.89"}]
[null,"ACTUAL HOURS",{"$f":"C19/$C$14","v":{"v":980,"d":"980.00"}},{"$f":"D19/$C$14","v":{"v":890.3571428571429,"d":"890.36"}},{"$f":"E19/$C$14","v":{"v":880.7142857142857,"d":"880.71"}},{"$f":"F19/$C$14","v":{"v":871.3571428571429,"d":"871.36"}},{"$f":"G19/$C$14","v":{"v":423,"d":"423.00"}},{"$f":"H19/$C$14","v":{"v":924.6428571428571,"d":"924.64"}}]

{"sheet":"PROJECT DETAILS","index":1,"n_rows":29,"n_cols":23,"rows_kept":29,"merged":[[4,11,4,16],[4,17,4,22]]}
[]
[null,{"$f":"'PROJECT PARAMETERS'!B2","v":"[Company Name]"}]
[null,"Project Planning for Law Firms"]
[null,"Company Confidential"]
[{"$nulls":11},"PLANNING",{"$nulls":5},"ACTUALS"]
[null,"PROJECT NAME","PROJECT TYPE","ESTIMATED START","ESTIMATED FINISH","ACTUAL START","ACTUAL FINISH","ESTIMATED WORK","ACTUAL WORK","ESTIMATED DURATION","ACTUAL DURATION","GENERAL PARTNER","BUSINESS LAWYER","DEFENSE LITIGATOR","INTELLECTUAL PROPERTY LAWYER","BANKRUPTCY LAWYER","ADMIN STAFF","GENERAL PARTNER 2","BUSINESS LAWYER 2","DEFENSE LITIGATOR 2","INTELLECTUAL PROPERTY LAWYER 2","BANKRUPTCY LAWYER 2","ADMIN STAFF 2"]
[null,"A. Datum Corporation","Business Incorporation","2013-06-09","2013-08-07","2013-06-29","2013-09-03",200,220,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":58},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":64},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":7000,"d":"$7,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":20000,"d":"$20,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12500,"d":"$12,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":7700,"d":"$7,700"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":22000,"d":"$22,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":13750,"d":"$13,750"}}]
[null,"Adventure Works","Business Acquisition","2013-06-25","2013-07-27","2013-07-15","2013-08-25",400,390,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":32},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":40},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":14000,"d":"$14,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":40000,"d":"$40,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":11000,"d":"$11,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":20000,"d":"$20,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":13650,"d":"$13,650"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":39000,"d":"$39,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":10725,"d":"$10,725"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":19500,"d":"$19,500"}}]
[null,"Alpine Ski House","Product Liability Defense","2013-07-12","2013-09-19","2013-08-07","2013-10-10",500,500,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":67},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":63},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":35000,"d":"$35,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":75000,"d":"$75,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":18750,"d":"$18,750"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":35000,"d":"$35,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":75000,"d":"$75,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":18750,"d":"$18,750"}}]
[null,"Baldwin Museum of Science","Patent Application","2013-07-30","2013-09-28","2013-09-14","2013-11-13",150,145,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":58},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":59},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":5250,"d":"$5,250"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":24750,"d":"$24,750"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":5625,"d":"$5,625"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":5075,"d":"$5,075"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":23925,"d":"$23,925"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":5437.5,"d":"$5,438"}}]
[null,"Blue Yonder Airlines","Employee Lawsuit","2013-08-11","2013-08-21","2013-09-14","2013-09-25",250,255,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":10},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":11},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":17500,"d":"$17,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":6250,"d":"$6,250"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":30000,"d":"$30,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":9375,"d":"$9,375"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":17850,"d":"$17,850"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":6375,"d":"$6,375"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":30600,"d":"$30,600"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":9562.5,"d":"$9,563"}}]
[null,"City Power & Light","Bankruptcy","2013-08-22","2013-10-02","2013-09-28","2013-10-27",300,310,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":40},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":29},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":10500,"d":"$10,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":15000,"d":"$15,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":27000,"d":"$27,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":11250,"d":"$11,250"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":10850,"d":"$10,850"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":15500,"d":"$15,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":27900,"d":"$27,900"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":11625,"d":"$11,625"}}]
[null,"Coho Vineyard","Business Incorporation","2013-09-13","2013-09-23","2013-10-26","2013-10-13",500,510,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":10},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":-13},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":17500,"d":"$17,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":50000,"d":"$50,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":31250,"d":"$31,250"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":17850,"d":"$17,850"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":51000,"d":"$51,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":31875,"d":"$31,875"}}]
[null,"Coho Winery","Product Liability Defense","2013-09-21","2013-10-15","2013-10-23","2013-11-18",750,790,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":24},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":25},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":52500,"d":"$52,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":112500,"d":"$112,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":28125,"d":"$28,125"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":55300,"d":"$55,300"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":118500,"d":"$118,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":29625,"d":"$29,625"}}]
[null,"Coho Vineyard & Winery","Patent Application","2013-10-15","2013-11-25","2013-11-30","2014-01-10",450,430,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":40},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":40},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":15750,"d":"$15,750"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":74250,"d":"$74,250"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":16875,"d":"$16,875"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":15050,"d":"$15,050"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":70950,"d":"$70,950"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":16125,"d":"$16,125"}}]
[null,"Contoso, Ltd.","Bankruptcy","2013-10-26","2013-12-24","2013-11-26","2014-01-19",250,235,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":58},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":53},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":8750,"d":"$8,750"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12500,"d":"$12,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":22500,"d":"$22,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":9375,"d":"$9,375"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8225,"d":"$8,225"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":11750,"d":"$11,750"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":21150,"d":"$21,150"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8812.5,"d":"$8,813"}}]
[null,"Contoso Pharmaceuticals","Business Acquisition","2013-11-17","2014-01-15","2013-12-28","2014-02-26",200,235,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":58},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":58},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":7000,"d":"$7,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":20000,"d":"$20,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":5500,"d":"$5,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":10000,"d":"$10,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8225,"d":"$8,225"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":23500,"d":"$23,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":6462.5,"d":"$6,463"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":11750,"d":"$11,750"}}]
[null,"Consolidated Messenger","Bankruptcy","2013-12-03","2014-02-02","2014-01-14","2014-03-02",180,190,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":59},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":48},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":6300,"d":"$6,300"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":9000,"d":"$9,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":16200,"d":"$16,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":6750,"d":"$6,750"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":6650,"d":"$6,650"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":9500,"d":"$9,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":17100,"d":"$17,100"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":7125,"d":"$7,125"}}]
[null,"Fabrikam, Inc.","Patent Application","2013-06-21","2014-01-18","2013-08-05","2014-03-04",250,230,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":207},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":209},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":8750,"d":"$8,750"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":41250,"d":"$41,250"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":9375,"d":"$9,375"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8050,"d":"$8,050"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":37950,"d":"$37,950"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8625,"d":"$8,625"}}]
[null,"Fourth Coffee","Product Liability Defense","2013-12-20","2014-02-04","2014-01-27","2014-03-25",240,225,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":44},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":58},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":16800,"d":"$16,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":36000,"d":"$36,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":9000,"d":"$9,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":15750,"d":"$15,750"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":33750,"d":"$33,750"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8437.5,"d":"$8,438"}}]
[null,"Graphic Design Institute","Patent Application","2013-12-28","2014-03-05","2014-01-17","2014-04-10",320,305,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":67},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":83},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":11200,"d":"$11,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":52800,"d":"$52,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12000,"d":"$12,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":10675,"d":"$10,675"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":50325,"d":"$50,325"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":11437.5,"d":"$11,438"}}]
[null,"Humongous Insurance","Business Acquisition","2014-01-04","2014-03-06","2014-02-03","2014-04-06",550,565,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":62},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":63},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":19250,"d":"$19,250"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":55000,"d":"$55,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":15125,"d":"$15,125"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":27500,"d":"$27,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":19775,"d":"$19,775"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":56500,"d":"$56,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":15537.5,"d":"$15,538"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":28250,"d":"$28,250"}}]
[null,"Litware, Inc.","Bankruptcy","2014-01-23","2014-03-07","2014-03-07","2014-04-08",350,350,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":44},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":31},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12250,"d":"$12,250"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":17500,"d":"$17,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":31500,"d":"$31,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":13125,"d":"$13,125"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":12250,"d":"$12,250"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":17500,"d":"$17,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":31500,"d":"$31,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":13125,"d":"$13,125"}}]
[null,"Lucerne Publishing","Business Incorporation","2014-02-05","2014-04-17","2014-03-07","2014-06-03",200,205,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":72},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":86},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":7000,"d":"$7,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":20000,"d":"$20,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12500,"d":"$12,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":7175,"d":"$7,175"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":20500,"d":"$20,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":12812.5,"d":"$12,813"}}]
[null,"Margie's Travel","Employee Lawsuit","2014-02-15","2014-04-30","2014-03-26","2014-06-09",220,230,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":75},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":73},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":15400,"d":"$15,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":5500,"d":"$5,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":26400,"d":"$26,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":8250,"d":"$8,250"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":16100,"d":"$16,100"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":5750,"d":"$5,750"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":27600,"d":"$27,600"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8625,"d":"$8,625"}}]
[null,"Northwind Traders","Bankruptcy","2014-03-17","2014-05-25","2014-04-29","2014-07-01",600,560,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":68},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":62},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":21000,"d":"$21,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":30000,"d":"$30,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":54000,"d":"$54,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":22500,"d":"$22,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":19600,"d":"$19,600"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":28000,"d":"$28,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":50400,"d":"$50,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":21000,"d":"$21,000"}}]
[null,"Proseware, Inc.","Patent Application","2014-03-29","2014-05-19","2014-05-18","2014-06-19",525,540,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":50},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":31},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":18375,"d":"$18,375"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":86625,"d":"$86,625"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":19687.5,"d":"$19,688"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":18900,"d":"$18,900"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":89100,"d":"$89,100"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":20250,"d":"$20,250"}}]
[null,"School of Fine Art","Employee Lawsuit","2014-04-09","2014-04-29","2014-05-02","2014-06-04",180,190,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":20},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":32},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12600,"d":"$12,600"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":4500,"d":"$4,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":21600,"d":"$21,600"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":6750,"d":"$6,750"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[GENERAL PARTNER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":13300,"d":"$13,300"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BUSINESS LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":4750,"d":"$4,750"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DEFENSE LITIGATOR]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":22800,"d":"$22,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[BANKRUPTCY LAWYER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":7125,"d":"$7,125"}}]
[null,"TOTAL",{"$nulls":5},{"$f":"SUBTOTAL(109,tblDetails[ESTIMATED WORK])","v":7565},{"$f":"SUBTOTAL(109,tblDetails[ACTUAL WORK])","v":7610},{"$f":"SUBTOTAL(109,tblDetails[ESTIMATED DURATION])","v":1223},{"$f":"SUBTOTAL(109,tblDetails[ACTUAL DURATION])","v":1205}]

{"sheet":"PROJECT TOTALS","index":2,"n_rows":29,"n_cols":14,"rows_kept":29,"merged":[[4,2,4,7],[4,8,4,13]]}
[]
[null,{"$f":"'PROJECT PARAMETERS'!B2","v":"[Company Name]"}]
[null,{"$f":"'PROJECT PARAMETERS'!B3","v":"Project Planning for Law Firms"}]
[null,{"$f":"'PROJECT PARAMETERS'!B4","v":"Company Confidential"}]
[null,null,"ESTIMATED",{"$nulls":5},"ACTUAL"]
[null,"PROJECT NAME","GENERAL PARTNER ","BUSINESS ","DEFENSE LITIGATOR ","INTELLECTUAL PROPERTY ","BANKRUPTCY ","ADMIN STAFF ","GENERAL PARTNER  ","BUSINESS    ","DEFENSE LITIGATOR  ","BANKRUPTCY  ","INTELLECTUAL PROPERTY  ","ADMIN STAFF  "]
[null,"A. Datum Corporation",{"v":7000,"d":"$7,000.00"},{"v":20000,"d":"$20,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":12500,"d":"$12,500.00"},{"v":7700,"d":"$7,700.00"},{"v":22000,"d":"$22,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":13750,"d":"$13,750.00"}]
[null,"Adventure Works",{"v":14000,"d":"$14,000.00"},{"v":40000,"d":"$40,000.00"},{"v":0,"d":"$0.00"},{"v":11000,"d":"$11,000.00"},{"v":0,"d":"$0.00"},{"v":20000,"d":"$20,000.00"},{"v":13650,"d":"$13,650.00"},{"v":39000,"d":"$39,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":10725,"d":"$10,725.00"},{"v":19500,"d":"$19,500.00"}]
[null,"Alpine Ski House",{"v":35000,"d":"$35,000.00"},{"v":0,"d":"$0.00"},{"v":75000,"d":"$75,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":18750,"d":"$18,750.00"},{"v":35000,"d":"$35,000.00"},{"v":0,"d":"$0.00"},{"v":75000,"d":"$75,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":18750,"d":"$18,750.00"}]
[null,"Baldwin Museum of Science",{"v":5250,"d":"$5,250.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":24750,"d":"$24,750.00"},{"v":0,"d":"$0.00"},{"v":5625,"d":"$5,625.00"},{"v":5075,"d":"$5,075.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":23925,"d":"$23,925.00"},{"v":5437.5,"d":"$5,437.50"}]
[null,"Blue Yonder Airlines",{"v":17500,"d":"$17,500.00"},{"v":6250,"d":"$6,250.00"},{"v":30000,"d":"$30,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":9375,"d":"$9,375.00"},{"v":17850,"d":"$17,850.00"},{"v":6375,"d":"$6,375.00"},{"v":30600,"d":"$30,600.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":9562.5,"d":"$9,562.50"}]
[null,"City Power & Light",{"v":10500,"d":"$10,500.00"},{"v":15000,"d":"$15,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":27000,"d":"$27,000.00"},{"v":11250,"d":"$11,250.00"},{"v":10850,"d":"$10,850.00"},{"v":15500,"d":"$15,500.00"},{"v":0,"d":"$0.00"},{"v":27900,"d":"$27,900.00"},{"v":0,"d":"$0.00"},{"v":11625,"d":"$11,625.00"}]
[null,"Coho Vineyard",{"v":17500,"d":"$17,500.00"},{"v":50000,"d":"$50,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":31250,"d":"$31,250.00"},{"v":17850,"d":"$17,850.00"},{"v":51000,"d":"$51,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":31875,"d":"$31,875.00"}]
[null,"Coho Vineyard & Winery",{"v":15750,"d":"$15,750.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":74250,"d":"$74,250.00"},{"v":0,"d":"$0.00"},{"v":16875,"d":"$16,875.00"},{"v":15050,"d":"$15,050.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":70950,"d":"$70,950.00"},{"v":16125,"d":"$16,125.00"}]
[null,"Coho Winery",{"v":52500,"d":"$52,500.00"},{"v":0,"d":"$0.00"},{"v":112500,"d":"$112,500.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":28125,"d":"$28,125.00"},{"v":55300,"d":"$55,300.00"},{"v":0,"d":"$0.00"},{"v":118500,"d":"$118,500.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":29625,"d":"$29,625.00"}]
[null,"Consolidated Messenger",{"v":6300,"d":"$6,300.00"},{"v":9000,"d":"$9,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":16200,"d":"$16,200.00"},{"v":6750,"d":"$6,750.00"},{"v":6650,"d":"$6,650.00"},{"v":9500,"d":"$9,500.00"},{"v":0,"d":"$0.00"},{"v":17100,"d":"$17,100.00"},{"v":0,"d":"$0.00"},{"v":7125,"d":"$7,125.00"}]
[null,"Contoso Pharmaceuticals",{"v":7000,"d":"$7,000.00"},{"v":20000,"d":"$20,000.00"},{"v":0,"d":"$0.00"},{"v":5500,"d":"$5,500.00"},{"v":0,"d":"$0.00"},{"v":10000,"d":"$10,000.00"},{"v":8225,"d":"$8,225.00"},{"v":23500,"d":"$23,500.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":6462.5,"d":"$6,462.50"},{"v":11750,"d":"$11,750.00"}]
[null,"Contoso, Ltd.",{"v":8750,"d":"$8,750.00"},{"v":12500,"d":"$12,500.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":22500,"d":"$22,500.00"},{"v":9375,"d":"$9,375.00"},{"v":8225,"d":"$8,225.00"},{"v":11750,"d":"$11,750.00"},{"v":0,"d":"$0.00"},{"v":21150,"d":"$21,150.00"},{"v":0,"d":"$0.00"},{"v":8812.5,"d":"$8,812.50"}]
[null,"Fabrikam, Inc.",{"v":8750,"d":"$8,750.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":41250,"d":"$41,250.00"},{"v":0,"d":"$0.00"},{"v":9375,"d":"$9,375.00"},{"v":8050,"d":"$8,050.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":37950,"d":"$37,950.00"},{"v":8625,"d":"$8,625.00"}]
[null,"Fourth Coffee",{"v":16800,"d":"$16,800.00"},{"v":0,"d":"$0.00"},{"v":36000,"d":"$36,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":9000,"d":"$9,000.00"},{"v":15750,"d":"$15,750.00"},{"v":0,"d":"$0.00"},{"v":33750,"d":"$33,750.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":8437.5,"d":"$8,437.50"}]
[null,"Graphic Design Institute",{"v":11200,"d":"$11,200.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":52800,"d":"$52,800.00"},{"v":0,"d":"$0.00"},{"v":12000,"d":"$12,000.00"},{"v":10675,"d":"$10,675.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":50325,"d":"$50,325.00"},{"v":11437.5,"d":"$11,437.50"}]
[null,"Humongous Insurance",{"v":19250,"d":"$19,250.00"},{"v":55000,"d":"$55,000.00"},{"v":0,"d":"$0.00"},{"v":15125,"d":"$15,125.00"},{"v":0,"d":"$0.00"},{"v":27500,"d":"$27,500.00"},{"v":19775,"d":"$19,775.00"},{"v":56500,"d":"$56,500.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":15537.5,"d":"$15,537.50"},{"v":28250,"d":"$28,250.00"}]
[null,"Litware, Inc.",{"v":12250,"d":"$12,250.00"},{"v":17500,"d":"$17,500.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":31500,"d":"$31,500.00"},{"v":13125,"d":"$13,125.00"},{"v":12250,"d":"$12,250.00"},{"v":17500,"d":"$17,500.00"},{"v":0,"d":"$0.00"},{"v":31500,"d":"$31,500.00"},{"v":0,"d":"$0.00"},{"v":13125,"d":"$13,125.00"}]
[null,"Lucerne Publishing",{"v":7000,"d":"$7,000.00"},{"v":20000,"d":"$20,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":12500,"d":"$12,500.00"},{"v":7175,"d":"$7,175.00"},{"v":20500,"d":"$20,500.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":12812.5,"d":"$12,812.50"}]
[null,"Margie's Travel",{"v":15400,"d":"$15,400.00"},{"v":5500,"d":"$5,500.00"},{"v":26400,"d":"$26,400.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":8250,"d":"$8,250.00"},{"v":16100,"d":"$16,100.00"},{"v":5750,"d":"$5,750.00"},{"v":27600,"d":"$27,600.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":8625,"d":"$8,625.00"}]
[null,"Northwind Traders",{"v":21000,"d":"$21,000.00"},{"v":30000,"d":"$30,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":54000,"d":"$54,000.00"},{"v":22500,"d":"$22,500.00"},{"v":19600,"d":"$19,600.00"},{"v":28000,"d":"$28,000.00"},{"v":0,"d":"$0.00"},{"v":50400,"d":"$50,400.00"},{"v":0,"d":"$0.00"},{"v":21000,"d":"$21,000.00"}]
[null,"Proseware, Inc.",{"v":18375,"d":"$18,375.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":86625,"d":"$86,625.00"},{"v":0,"d":"$0.00"},{"v":19687.5,"d":"$19,687.50"},{"v":18900,"d":"$18,900.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":89100,"d":"$89,100.00"},{"v":20250,"d":"$20,250.00"}]
[null,"School of Fine Art",{"v":12600,"d":"$12,600.00"},{"v":4500,"d":"$4,500.00"},{"v":21600,"d":"$21,600.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":6750,"d":"$6,750.00"},{"v":13300,"d":"$13,300.00"},{"v":4750,"d":"$4,750.00"},{"v":22800,"d":"$22,800.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":7125,"d":"$7,125.00"}]
[null,"Grand Total",{"v":339675,"d":"$339,675.00"},{"v":305250,"d":"$305,250.00"},{"v":301500,"d":"$301,500.00"},{"v":311300,"d":"$311,300.00"},{"v":151200,"d":"$151,200.00"},{"v":320562.5,"d":"$320,562.50"},{"v":343000,"d":"$343,000.00"},{"v":311625,"d":"$311,625.00"},{"v":308250,"d":"$308,250.00"},{"v":148050,"d":"$148,050.00"},{"v":304975,"d":"$304,975.00"},{"v":323625,"d":"$323,625.00"}]