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

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"ABOUT THIS TEMPLATE"]
[]
[null,"Use this workbook to track project parameters, project details, and project totals during project planning for law firms."]
[null,"Fill in your own company name in project parameters worksheet and it is auto-updated in other worksheets."]
[null,"Enter information in project parameters worksheet to update column charts, and in project details worksheet. PivotTable in project totals worksheet is auto-updated"]
[null,"Note:  "]
[null,"Additional Instructions have been provided in column A of each worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change font color."]
[null,"To learn more about tables in worksheets, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT. For PivotTable in Project Totals worksheet, press SHIFT and then F10 within table, select PIVOTTABLE OPTIONS, and then select ALT TEXT tab."]

{"sheet":"PROJECT PARAMETERS","index":1,"n_rows":19,"n_cols":9,"rows_kept":19}
[null,"Mitchell, Morris, Ward, & Cook"]
[null,"Project planning for law firms"]
[null,{"$f":"B1&\" Confidential\"","v":"Mitchell, Morris, Ward, & Cook 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(Parameters[[#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(Parameters[[#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(Parameters[[#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(Parameters[[#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(Parameters[[#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(Parameters[[#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,"PLANNED COST",{"$f":"SUBTOTAL(109,Details[GENERAL PARTNER])","v":{"v":78750,"d":"$78,750.00"}},{"$f":"SUBTOTAL(109,Details[BUSINESS LAWYER])","v":{"v":66250,"d":"$66,250.00"}},{"$f":"SUBTOTAL(109,Details[DEFENSE LITIGATOR])","v":{"v":105000,"d":"$105,000.00"}},{"$f":"SUBTOTAL(109,Details[INTELLECTUAL PROPERTY LAWYER])","v":{"v":35750,"d":"$35,750.00"}},{"$f":"SUBTOTAL(109,Details[BANKRUPTCY LAWYER])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Details[ADMIN STAFF])","v":{"v":66250,"d":"$66,250.00"}}]
[null,"ACTUAL COST",{"$f":"SUBTOTAL(109,Details[GENERAL PARTNER 2])","v":{"v":79275,"d":"$79,275.00"}},{"$f":"SUBTOTAL(109,Details[BUSINESS LAWYER 2])","v":{"v":67375,"d":"$67,375.00"}},{"$f":"SUBTOTAL(109,Details[DEFENSE LITIGATOR 2])","v":{"v":105600,"d":"$105,600.00"}},{"$f":"SUBTOTAL(109,Details[INTELLECTUAL PROPERTY LAWYER 2])","v":{"v":34650,"d":"$34,650.00"}},{"$f":"SUBTOTAL(109,Details[BANKRUPTCY LAWYER 2])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Details[ADMIN STAFF 2])","v":{"v":67000,"d":"$67,000.00"}}]
[null,"PLANNED HOURS",{"$f":"C16/$C$12","v":{"v":225,"d":"225.00"}},{"$f":"D16/$C$12","v":{"v":189.28571428571428,"d":"189.29"}},{"v":300,"d":"300.00"},{"v":102.14285714285714,"d":"102.14"},{"v":0,"d":"0.00"},{"v":189.28571428571428,"d":"189.29"}]
[null,"ACTUAL HOURS",{"$f":"C17/$C$12","v":{"v":226.5,"d":"226.50"}},{"$f":"D17/$C$12","v":{"v":192.5,"d":"192.50"}},{"$f":"E17/$C$12","v":{"v":301.7142857142857,"d":"301.71"}},{"$f":"F17/$C$12","v":{"v":99,"d":"99.00"}},{"$f":"G17/$C$12","v":{"v":0,"d":"0.00"}},{"$f":"H17/$C$12","v":{"v":191.42857142857142,"d":"191.43"}}]

{"sheet":"PROJECT DETAILS","index":2,"n_rows":10,"n_cols":25,"rows_kept":10,"merged":[[1,24,8,28]]}
[null,{"$f":"'PROJECT PARAMETERS'!B1","v":"Mitchell, Morris, Ward, & Cook"}]
[null,{"$f":"'PROJECT PARAMETERS'!B2","v":"Project planning for law firms"},{"$nulls":22},"INFO:\nTo add a row, select the bottom-right most cell in the body of the table (not the totals row) and press Tab, or press SHIFT and then F10 within table where you want the row inserted and select Insert | Table Rows Above/Below.\nBe sure all unused rows are deleted, as the PROJECT TOTALS PivotTable will use all of the tables cells, and otherwise would give erroneous results."]
[null,{"$f":"'PROJECT PARAMETERS'!B3","v":"Mitchell, Morris, Ward, & Cook Confidential"}]
[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,"Europa","Business incorporation",{"$f":"TODAY()","v":"2022-11-11"},{"$f":"TODAY()+60","v":"2023-01-10"},{"$f":"TODAY()+10","v":"2022-11-21"},{"$f":"TODAY()+65","v":"2023-01-15"},200,220,{"$f":"DAYS360(Details[[#This Row],[ESTIMATED START]],Details[[#This Row],[ESTIMATED FINISH]],FALSE)","v":59},{"$f":"DAYS360(Details[[#This Row],[ACTUAL START]],Details[[#This Row],[ACTUAL FINISH]],FALSE)","v":54},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":7000,"d":"$7,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":20000,"d":"$20,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":12500,"d":"$12,500"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":7700,"d":"$7,700"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":22000,"d":"$22,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":13750,"d":"$13,750"}}]
[null,"Goldfish","Business acquisition",{"$f":"TODAY()+30","v":"2022-12-11"},{"$f":"TODAY()+100","v":"2023-02-19"},{"$f":"TODAY()+40","v":"2022-12-21"},{"$f":"TODAY()+110","v":"2023-03-01"},400,390,{"$f":"DAYS360(Details[[#This Row],[ESTIMATED START]],Details[[#This Row],[ESTIMATED FINISH]],FALSE)","v":68},{"$f":"DAYS360(Details[[#This Row],[ACTUAL START]],Details[[#This Row],[ACTUAL FINISH]],FALSE)","v":70},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":14000,"d":"$14,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":40000,"d":"$40,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":11000,"d":"$11,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":20000,"d":"$20,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":13650,"d":"$13,650"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":39000,"d":"$39,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":10725,"d":"$10,725"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":19500,"d":"$19,500"}}]
[null,"Cobalt","Product liability defense",{"$f":"TODAY()+150","v":"2023-04-10"},{"$f":"TODAY()+150","v":"2023-04-10"},{"$f":"TODAY()+150","v":"2023-04-10"},{"$f":"TODAY()+170","v":"2023-04-30"},500,500,{"$f":"DAYS360(Details[[#This Row],[ESTIMATED START]],Details[[#This Row],[ESTIMATED FINISH]],FALSE)","v":0},{"$f":"DAYS360(Details[[#This Row],[ACTUAL START]],Details[[#This Row],[ACTUAL FINISH]],FALSE)","v":20},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":35000,"d":"$35,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":75000,"d":"$75,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":18750,"d":"$18,750"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":35000,"d":"$35,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":75000,"d":"$75,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":18750,"d":"$18,750"}}]
[null,"Iris","Patent application",{"$f":"TODAY()+200","v":"2023-05-30"},{"$f":"TODAY()+230","v":"2023-06-29"},{"$f":"TODAY()+230","v":"2023-06-29"},{"$f":"TODAY()+230","v":"2023-06-29"},150,145,{"$f":"DAYS360(Details[[#This Row],[ESTIMATED START]],Details[[#This Row],[ESTIMATED FINISH]],FALSE)","v":29},{"$f":"DAYS360(Details[[#This Row],[ACTUAL START]],Details[[#This Row],[ACTUAL FINISH]],FALSE)","v":0},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":5250,"d":"$5,250"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":24750,"d":"$24,750"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":5625,"d":"$5,625"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":5075,"d":"$5,075"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":23925,"d":"$23,925"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":5437.5,"d":"$5,438"}}]
[null,"Python","Employee lawsuit",{"$f":"TODAY()+220","v":"2023-06-19"},{"$f":"TODAY()+250","v":"2023-07-19"},{"$f":"TODAY()+230","v":"2023-06-29"},{"$f":"TODAY()+259","v":"2023-07-28"},250,255,{"$f":"DAYS360(Details[[#This Row],[ESTIMATED START]],Details[[#This Row],[ESTIMATED FINISH]],FALSE)","v":30},{"$f":"DAYS360(Details[[#This Row],[ACTUAL START]],Details[[#This Row],[ACTUAL FINISH]],FALSE)","v":29},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":17500,"d":"$17,500"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":6250,"d":"$6,250"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":30000,"d":"$30,000"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*Details[[#This Row],[ESTIMATED WORK]]","v":{"v":9375,"d":"$9,375"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[GENERAL PARTNER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":17850,"d":"$17,850"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BUSINESS LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":6375,"d":"$6,375"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[DEFENSE LITIGATOR]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":30600,"d":"$30,600"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[INTELLECTUAL PROPERTY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[BANKRUPTCY LAWYER]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(Parameters[],MATCH(Details[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(Details[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*Details[[#This Row],[ACTUAL WORK]]","v":{"v":9562.5,"d":"$9,563"}}]
[null,"TOTAL",{"$nulls":5},{"$f":"SUBTOTAL(109,Details[ESTIMATED WORK])","v":1500},{"$f":"SUBTOTAL(109,Details[ACTUAL WORK])","v":1510},{"$f":"SUBTOTAL(109,Details[ESTIMATED DURATION])","v":186},{"$f":"SUBTOTAL(109,Details[ACTUAL DURATION])","v":173}]

{"sheet":"PROJECT TOTALS","index":3,"n_rows":11,"n_cols":14,"rows_kept":11,"merged":[[3,2,3,7],[3,8,3,13]]}
[null,{"$f":"'PROJECT PARAMETERS'!B1","v":"Mitchell, Morris, Ward, & Cook"}]
[null,{"$f":"'PROJECT PARAMETERS'!B2","v":"Project planning for law firms"}]
[null,{"$f":"'PROJECT PARAMETERS'!B3","v":"Mitchell, Morris, Ward, & Cook 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,"Europa2",{"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,"Goldfish2",{"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,"Cobalt2",{"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,"Iris2",{"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,"Python2",{"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,"Grand Total",{"v":78750,"d":"$78,750.00"},{"v":66250,"d":"$66,250.00"},{"v":105000,"d":"$105,000.00"},{"v":35750,"d":"$35,750.00"},{"v":0,"d":"$0.00"},{"v":66250,"d":"$66,250.00"},{"v":79275,"d":"$79,275.00"},{"v":67375,"d":"$67,375.00"},{"v":105600,"d":"$105,600.00"},{"v":0,"d":"$0.00"},{"v":34650,"d":"$34,650.00"},{"v":67000,"d":"$67,000.00"}]