{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["如何使用此範本","服務發票"],"not_rendered":{"images":5,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"如何使用此範本","index":0,"n_rows":4,"n_cols":2,"rows_kept":4}
[null,"透過服務發票開始使用"]
[null,"\n使用此範本來建立專業外觀的發票，讓您能快速填寫，並便於客戶閱讀。"]
[null,"若要開始，請在 [服務發票] 索引標籤的上半部，也就是從儲存格 B2 到 B6 之間輸入貴公司名稱、地址和電話資訊，然後將範本儲存為 Excel 範本 (.xltx)，這樣您之後就無需再於這些儲存格中填入這些資訊。請確定範本儲存在您可以輕鬆存取的位置。如果您能將它儲存至您電腦中的範本資料夾 (通常為 C:\\Users\\<username>\\AppData\\Roaming\\Microsoft\\Templates)，您可以透過選取 [新增] 索引標籤、選取 [新增]，然後選取 [我的範本] 來輕鬆存取這份範本。否則，您可以在現有的範本中選取 [新增]，然後瀏覽至您的 .xltx 檔案並開啟。無論使用哪種方法，當您第一次儲存檔案時，系統都會提示您將範本儲存為 .xlsx 活頁簿。"]
[null,"輸入您的發票號碼和客戶識別碼。系統會自動為您填入日期。接著請輸入客戶的資訊：連絡人姓名、公司名稱、地址和電話資訊。在儲存格 D27 設定稅率。儲存格 B29 會自動加上貴公司名稱。最後，請從發票表格中的儲存格 B15 開始，輸入所有訂單交易資訊。"]

{"sheet":"服務發票","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"merged":[[0,3,0,4],[26,1,26,2],[29,1,29,4],[30,1,30,4]]}
[null,null,"貴公司標語","發票"]
[null,"貴公司名稱"]
[null,"街道地址",null,"發票號碼：",100]
[null,"郵遞區號，縣/市",null,"日期：",{"$f":"TODAY()","v":"2022-06-23"}]
[null,"[電話] [傳真]",null,"客戶識別碼：","ABC12345"]
[null,"電子郵件"]
[null,"姓名"]
[null,"公司名稱"]
[null,"街道地址"]
[null,"郵遞區號，縣/市"]
[null,"電話"]
[null,"銷售人員","工作","付款條件","付款期限"]
[{"$nulls":3},"貨到付款"]
[]
[null,"數量","描述","單價","項目合計"]
[{"$nulls":4},{"$f":"IFERROR(IF(SUM(B16)>0,SUM(B16*D16),\"\"), \"\")","v":""}]
[{"$nulls":4},""]
[{"$nulls":4},""]
[null,null," ",null,""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":3},"小計",{"$f":"IFERROR(IF(SUM(E16:E25)>0,SUM(E16:E25),\"\"), \"\")","v":""}]
[null,"營業稅 @",null,{"v":0.095,"d":"9.50%"},{"$f":"IFERROR(IF(SUM(發票[[#Totals],[項目合計]])>0,SUM(發票[[#Totals],[項目合計]]*D27),\"\"), \"\")","v":""}]
[{"$nulls":3},"總計",{"$f":"IFERROR(IF(SUM(發票[[#Totals],[項目合計]])>0,SUM(發票[[#Totals],[項目合計]],E27),\"\"), \"\")","v":""}]
[]
[null,{"$f":"\"支票抬頭一律填寫\"&公司_名稱&\".\"","v":"支票抬頭一律填寫貴公司名稱."}]
[null,"感謝您的惠顧！"]