{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["開始","專案參數","專案詳細資料","專案總計"],"not_rendered":{"charts":2,"defined_names":3,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"關於此範本"]
[]
[null,"這個活頁簿可用來追蹤律師事務所適用的專案計劃的專案參數、專案詳細資料及專案總計。"]
[null,"在 [專案參數] 工作表中填入公司名稱後，其他工作表也會自動更新這個名稱。"]
[null,"在 [專案參數] 以及 [專案詳細資料] 工作表中輸入資訊，即可更新欄圖表。[專案總計] 工作表中的樞紐分析表會自動更新。"]
[null,"附註：  "]
[null,"我們已在每張工作表的欄 A 提供額外指示。此文字已刻意隱藏。若要移除文字，請選取欄 A，然後選取 [刪除]。若要取消隱藏文字，請選取欄 A，然後變更字型色彩。"]
[null,"若要深入了解此工作表中的表格，請在表格內按 SHIFT 並按 F10、選取 [表格] 選項，然後選取 [替代文字]。針對 [專案總計] 工作表中的樞紐分析表，在表格中按 SHIFT 並按 F10、選取 [樞紐分析表選項]，然後選取 [替代文字] 索引標籤。"]

{"sheet":"專案參數","index":1,"n_rows":19,"n_cols":9,"rows_kept":19}
["在這個工作表中建立專案參數。在右側儲存格中輸入公司名稱。此欄中的儲存格提供實用指示。","公司名稱"]
["右側儲存格是這個工作表的標題。","律師事務所適用的專案計劃"]
["右側儲存格是機密訊息。",{"$f":"B1&\"機密\"","v":"公司名稱機密"}]
["右側儲存格是提示。","工作表會為您計算有陰影的儲存格。您不需要在其中輸入任何內容。"]
["在從右側儲存格開始的 [參數] 表格中輸入詳細資料。下一個指示在儲存格 A12。","專案類型","一般合作夥伴","企業律師","辯護律師","智慧財產律師","破產律師","行政人員","總計"]
[null,"企業經營",{"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(參數[[#This Row],[一般合作夥伴]:[行政人員]])","v":{"v":1,"d":"100%"}}]
[null,"企業收購",{"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(參數[[#This Row],[一般合作夥伴]:[行政人員]])","v":{"v":1,"d":"100%"}}]
[null,"產品責任辯護",{"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(參數[[#This Row],[一般合作夥伴]:[行政人員]])","v":{"v":1,"d":"100%"}}]
[null,"專利申請",{"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(參數[[#This Row],[一般合作夥伴]:[行政人員]])","v":{"v":1,"d":"100%"}}]
[null,"員工訴訟",{"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(參數[[#This Row],[一般合作夥伴]:[行政人員]])","v":{"v":1,"d":"100%"}}]
[null,"破產",{"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(參數[[#This Row],[一般合作夥伴]:[行政人員]])","v":{"v":1,"d":"100%"}}]
["在右側的儲存格中輸入混合費率，從儲存格 C12 到 H12。下一個指示在儲存格 A14。","混合費率",{"v":350,"d":"NT$350"},{"v":250,"d":"NT$250"},{"v":300,"d":"NT$300"},{"v":275,"d":"NT$275"},{"v":225,"d":"NT$225"},{"v":125,"d":"NT$125"}]
[]
["右側儲存格會顯示計劃與實際費用的比較直條圖，而儲存格 F14 則會顯示計劃與實際時數的比較直條圖。"]
[null,null,"一般合作夥伴","企業","辯護律師","智慧財產","破產","行政人員"]
[null,"計劃費用",{"$f":"SUBTOTAL(109,詳細資料​​[一般合作夥伴])","v":{"v":78750,"d":"NT$78,750.00"}},{"$f":"SUBTOTAL(109,詳細資料​​[企業律師])","v":{"v":66250,"d":"NT$66,250.00"}},{"$f":"SUBTOTAL(109,詳細資料​​[辯護律師])","v":{"v":105000,"d":"NT$105,000.00"}},{"$f":"SUBTOTAL(109,詳細資料​​[智慧財產律師])","v":{"v":35750,"d":"NT$35,750.00"}},{"$f":"SUBTOTAL(109,詳細資料​​[破產律師])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,詳細資料​​[行政人員])","v":{"v":66250,"d":"NT$66,250.00"}}]
[null,"實際費用",{"$f":"SUBTOTAL(109,詳細資料​​[一般合作夥伴 2])","v":{"v":79275,"d":"NT$79,275.00"}},{"$f":"SUBTOTAL(109,詳細資料​​[企業律師 2])","v":{"v":67375,"d":"NT$67,375.00"}},{"$f":"SUBTOTAL(109,詳細資料​​[辯護律師 2])","v":{"v":105600,"d":"NT$105,600.00"}},{"$f":"SUBTOTAL(109,詳細資料​​[智慧財產律師 2])","v":{"v":34650,"d":"NT$34,650.00"}},{"$f":"SUBTOTAL(109,詳細資料​​[破產律師 2])","v":{"v":0,"d":"NT$0.00"}},{"$f":"SUBTOTAL(109,詳細資料​​[行政人員 2])","v":{"v":67000,"d":"NT$67,000.00"}}]
[null,"計劃時數",{"$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,"實際時數",{"$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":"專案詳細資料","index":2,"n_rows":10,"n_cols":25,"rows_kept":10,"merged":[[1,24,8,28]]}
["在這個工作表中建立專案詳細資料。工作表會自動更新右側儲存格中的公司名稱。此欄中的儲存格提供實用指示。按向下鍵就能開始使用。",{"$f":"專案參數!B1","v":"公司名稱"}]
["右側儲存格是這個工作表的標題，而儲存格 Y2 是資訊提示。",{"$f":"專案參數!B2","v":"律師事務所適用的專案計劃"},{"$nulls":22},"資訊：\n若要新增列，請選取表格內最右下方的儲存格 (不是總計列)、在您要插入列的位置按下 Tab 鍵或 SHIFT+F10，然後選取 [插入] | [上方表格列]/[下方表格列]。\n請務必刪除所有未使用的列，因為「專案總計」會使用所有表格儲存格，如果未刪除將會產生錯誤結果。"]
["右側儲存格是機密訊息。",{"$f":"專案參數!B3","v":"公司名稱機密"}]
["在從右側儲存格開始的 [詳細資料] 表格中輸入資訊。右側 [詳細資料] 表格中的 [專案類型] 會依據 [專案參數] 工作表中的 [參數] 表格自動更新。","專案名稱","專案類型","預估開始時間","預估結束時間","實際開始時間","實際結束時間","預估工時","實際工時","預估工期","實際工期","一般合作夥伴","企業律師","辯護律師","智慧財產律師","破產律師","行政人員","一般合作夥伴 2","企業律師 2","辯護律師 2","智慧財產律師 2","破產律師 2","行政人員 2"]
[null,"專案 1","企業經營",{"$f":"TODAY()","v":"2019-03-08"},{"$f":"TODAY()+60","v":"2019-05-07"},{"$f":"TODAY()+10","v":"2019-03-18"},{"$f":"TODAY()+65","v":"2019-05-12"},200,220,{"$f":"DAYS360(詳細資料​​[[#This Row],[預估開始時間]],詳細資料​​[[#This Row],[預估結束時間]],FALSE)","v":59},{"$f":"DAYS360(詳細資料​​[[#This Row],[實際開始時間]],詳細資料​​[[#This Row],[實際結束時間]],FALSE)","v":54},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":7000,"d":"NT$7,000"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":20000,"d":"NT$20,000"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":12500,"d":"NT$12,500"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":7700,"d":"NT$7,700"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":22000,"d":"NT$22,000"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":13750,"d":"NT$13,750"}}]
[null,"專案 2","企業收購",{"$f":"TODAY()+30","v":"2019-04-07"},{"$f":"TODAY()+100","v":"2019-06-16"},{"$f":"TODAY()+40","v":"2019-04-17"},{"$f":"TODAY()+110","v":"2019-06-26"},400,390,{"$f":"DAYS360(詳細資料​​[[#This Row],[預估開始時間]],詳細資料​​[[#This Row],[預估結束時間]],FALSE)","v":69},{"$f":"DAYS360(詳細資料​​[[#This Row],[實際開始時間]],詳細資料​​[[#This Row],[實際結束時間]],FALSE)","v":69},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":14000,"d":"NT$14,000"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":40000,"d":"NT$40,000"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":11000,"d":"NT$11,000"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":20000,"d":"NT$20,000"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":13650,"d":"NT$13,650"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":39000,"d":"NT$39,000"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":10725,"d":"NT$10,725"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":19500,"d":"NT$19,500"}}]
[null,"專案 3","產品責任辯護",{"$f":"TODAY()+150","v":"2019-08-05"},{"$f":"TODAY()+150","v":"2019-08-05"},{"$f":"TODAY()+150","v":"2019-08-05"},{"$f":"TODAY()+170","v":"2019-08-25"},500,500,{"$f":"DAYS360(詳細資料​​[[#This Row],[預估開始時間]],詳細資料​​[[#This Row],[預估結束時間]],FALSE)","v":0},{"$f":"DAYS360(詳細資料​​[[#This Row],[實際開始時間]],詳細資料​​[[#This Row],[實際結束時間]],FALSE)","v":20},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":35000,"d":"NT$35,000"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":75000,"d":"NT$75,000"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":18750,"d":"NT$18,750"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":35000,"d":"NT$35,000"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":75000,"d":"NT$75,000"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":18750,"d":"NT$18,750"}}]
[null,"專案 4","專利申請",{"$f":"TODAY()+200","v":"2019-09-24"},{"$f":"TODAY()+230","v":"2019-10-24"},{"$f":"TODAY()+230","v":"2019-10-24"},{"$f":"TODAY()+230","v":"2019-10-24"},150,145,{"$f":"DAYS360(詳細資料​​[[#This Row],[預估開始時間]],詳細資料​​[[#This Row],[預估結束時間]],FALSE)","v":30},{"$f":"DAYS360(詳細資料​​[[#This Row],[實際開始時間]],詳細資料​​[[#This Row],[實際結束時間]],FALSE)","v":0},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":5250,"d":"NT$5,250"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":24750,"d":"NT$24,750"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":5625,"d":"NT$5,625"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":5075,"d":"NT$5,075"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":23925,"d":"NT$23,925"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":5437.5,"d":"NT$5,438"}}]
[null,"專案 5","員工訴訟",{"$f":"TODAY()+220","v":"2019-10-14"},{"$f":"TODAY()+250","v":"2019-11-13"},{"$f":"TODAY()+230","v":"2019-10-24"},{"$f":"TODAY()+259","v":"2019-11-22"},250,255,{"$f":"DAYS360(詳細資料​​[[#This Row],[預估開始時間]],詳細資料​​[[#This Row],[預估結束時間]],FALSE)","v":29},{"$f":"DAYS360(詳細資料​​[[#This Row],[實際開始時間]],詳細資料​​[[#This Row],[實際結束時間]],FALSE)","v":28},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":17500,"d":"NT$17,500"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":6250,"d":"NT$6,250"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":30000,"d":"NT$30,000"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*詳細資料​​[[#This Row],[預估工時]]","v":{"v":9375,"d":"NT$9,375"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[一般合作夥伴]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":17850,"d":"NT$17,850"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[企業律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":6375,"d":"NT$6,375"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[辯護律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":30600,"d":"NT$30,600"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[智慧財產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[破產律師]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":0,"d":"NT$0"}},{"$f":"INDEX(參數[],MATCH(詳細資料​​[[#This Row],[專案類型]],參數[專案類型],0),MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*INDEX(專案參數!$B$12:$H$12,1,MATCH(詳細資料​​[[#Headers],[行政人員]],參數[#Headers],0))*詳細資料​​[[#This Row],[實際工時]]","v":{"v":9562.5,"d":"NT$9,563"}}]
[null,"總計",{"$nulls":5},{"$f":"SUBTOTAL(109,詳細資料​​[預估工時])","v":1500},{"$f":"SUBTOTAL(109,詳細資料​​[實際工時])","v":1510},{"$f":"SUBTOTAL(109,詳細資料​​[預估工期])","v":187},{"$f":"SUBTOTAL(109,詳細資料​​[實際工期])","v":171}]

{"sheet":"專案總計","index":3,"n_rows":11,"n_cols":16,"rows_kept":11,"merged":[[3,2,3,7],[3,8,3,13],[3,15,14,19]]}
["取得這個工作表中的專案總計。右側儲存格的公司名稱會自動更新。此欄中的儲存格提供實用指示。按向下鍵就能開始使用。",{"$f":"專案參數!B1","v":"公司名稱"}]
["右側儲存格是這個工作表的標題。",{"$f":"專案參數!B2","v":"律師事務所適用的專案計劃"}]
["右側儲存格是機密訊息。",{"$f":"專案參數!B3","v":"公司名稱機密"}]
["儲存格 C4 是 [預估] 標籤、儲存格 I4 是 [實際] 標籤，而儲存格 P4 是 [資訊提示]。",null,"預估",{"$nulls":5},"實際",{"$nulls":6},"資訊：\n此樞紐分析表不會自動重新整理。若要重新整理，請選取它 (樞紐分析表內的任何儲存格)、在[ 樞紐分析表工具] |[分析] 功能區索引標籤上選取 [重新整理]。或按 SHIFT + F10 選取樞紐分析表，請，然後選取 [重新整理]。"]
["從右側儲存格開始的樞紐分析表會自動更新。","專案名稱","一般合作夥伴 ","企業 ","辯護律師 ","智慧財產 ","破產 ","行政人員 ","一般合作夥伴  ","企業  ","辯護律師  ","破產  ","智慧財產  ","行政人員  "]
[null,"專案 1",{"v":7000,"d":"NT$7,000.00"},{"v":20000,"d":"NT$20,000.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":12500,"d":"NT$12,500.00"},{"v":7700,"d":"NT$7,700.00"},{"v":22000,"d":"NT$22,000.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":13750,"d":"NT$13,750.00"}]
[null,"專案 2",{"v":14000,"d":"NT$14,000.00"},{"v":40000,"d":"NT$40,000.00"},{"v":0,"d":"NT$0.00"},{"v":11000,"d":"NT$11,000.00"},{"v":0,"d":"NT$0.00"},{"v":20000,"d":"NT$20,000.00"},{"v":13650,"d":"NT$13,650.00"},{"v":39000,"d":"NT$39,000.00"},{"v":0,"d":"NT$0.00"},{"v":10725,"d":"NT$10,725.00"},{"v":0,"d":"NT$0.00"},{"v":19500,"d":"NT$19,500.00"}]
[null,"專案 3",{"v":35000,"d":"NT$35,000.00"},{"v":0,"d":"NT$0.00"},{"v":75000,"d":"NT$75,000.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":18750,"d":"NT$18,750.00"},{"v":35000,"d":"NT$35,000.00"},{"v":0,"d":"NT$0.00"},{"v":75000,"d":"NT$75,000.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":18750,"d":"NT$18,750.00"}]
[null,"專案 4",{"v":5250,"d":"NT$5,250.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":24750,"d":"NT$24,750.00"},{"v":0,"d":"NT$0.00"},{"v":5625,"d":"NT$5,625.00"},{"v":5075,"d":"NT$5,075.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":23925,"d":"NT$23,925.00"},{"v":0,"d":"NT$0.00"},{"v":5437.5,"d":"NT$5,437.50"}]
[null,"專案 5",{"v":17500,"d":"NT$17,500.00"},{"v":6250,"d":"NT$6,250.00"},{"v":30000,"d":"NT$30,000.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":9375,"d":"NT$9,375.00"},{"v":17850,"d":"NT$17,850.00"},{"v":6375,"d":"NT$6,375.00"},{"v":30600,"d":"NT$30,600.00"},{"v":0,"d":"NT$0.00"},{"v":0,"d":"NT$0.00"},{"v":9562.5,"d":"NT$9,562.50"}]
[null,"總計",{"v":78750,"d":"NT$78,750.00"},{"v":66250,"d":"NT$66,250.00"},{"v":105000,"d":"NT$105,000.00"},{"v":35750,"d":"NT$35,750.00"},{"v":0,"d":"NT$0.00"},{"v":66250,"d":"NT$66,250.00"},{"v":79275,"d":"NT$79,275.00"},{"v":67375,"d":"NT$67,375.00"},{"v":105600,"d":"NT$105,600.00"},{"v":34650,"d":"NT$34,650.00"},{"v":0,"d":"NT$0.00"},{"v":67000,"d":"NT$67,000.00"}]