{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["開始","服務發票"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"關於此範本"]
[null,"使用這個範本建立銷售發票。"]
[null,"填入基本資訊，例如公司名稱、付款人和收貨人詳細資料。"]
[null,"在表格中輸入發票詳細資料。"]
[null,"系統會為您自動計算總計。"]
[null,"附註： "]
[null,"[服務發票] 工作表的欄 A 中提供其他指示。此文字已刻意隱藏。若要移除文字，請選取欄 A，然後選取 [刪除]。若要取消隱藏文字，請選取 A 欄，然後變更字型色彩。"]
[null,"若要深入了解表格，請在表格內按 SHIFT 並按 F10，選取 [表格] 選項，然後選取 [替代文字]。"]

{"sheet":"服務發票","index":1,"n_rows":39,"n_cols":8,"rows_kept":39,"merged":[[0,1,0,3],[0,4,0,7],[1,1,1,6],[2,1,2,3],[3,1,3,3],[4,1,4,2],[4,5,4,6],[5,1,5,2],[5,5,5,6],[6,1,6,2],[6,3,6,4],[6,5,6,6],[7,1,7,2],[7,3,7,4],[8,2,8,3],[8,5,8,6],[9,2,9,3],[9,5,9,6],[10,2,10,3],[10,5,10,6],[11,2,11,3],[11,5,11,6],[12,2,12,3],[12,5,12,6],[37,1,37,4],[37,5,37,7],[38,1,38,7]]}
["在此工作表中建立銷售發票。在右側儲存格中輸入公司標誌，在儲存格 E1 中輸入此工作表的標題。此欄的儲存格是有關如何使用此工作表的實用指示。下一個指示在儲存格 A3。","此儲存格為標誌預留位置。",null,null,"發票"]
[]
["在右側儲存格中輸入公司名稱。","貴公司名稱"]
["在右側儲存格中輸入公司標語。","貴公司標語"]
["在右側儲存格中輸入街道地址，在儲存格 F5 中輸入發票號碼。","街道地址",null,null,"發票號碼","否"]
["在右側儲存格中輸入縣/市和郵遞區號，在儲存格 F6 中輸入發票日期。","郵遞區號，縣/市",null,null,"日期",{"$f":"TODAY()","v":"2019-05-08"}]
["在右側儲存格中輸入電話號碼和傳真號碼，在儲存格 F7 中輸入客戶 ID。","電話傳真",null,"客戶 ID",null,"ID"]
["在右側儲存格中輸入電子郵件地址。","電子郵件"]
["在儲存格 C9 到 C13 中輸入付款人詳細資料，在儲存格 F9 到 F13 中輸入收貨人詳細資料。儲存格 A14 是下一個說明。","收件者","姓名",null,"收貨人","姓名"]
[null,null,"公司名稱",null,null,"公司名稱"]
[null,null,"街道地址",null,null,"街道地址"]
[null,null,"郵遞區號，縣/市",null,null,"郵遞區號，縣/市"]
[null,null,"電話",null,null,"電話"]
["在從右側儲存格開始的 [詳細資料] 表格中輸入資訊。儲存格 A17 是下一個說明。","銷售人員","職稱","運送方式","運送條款","送貨日期","付款條件","截止日期"]
[{"$nulls":6},"貨到付款"]
[]
["在從右側儲存格開始的 [發票] 表格中輸入資料。結尾會自動計算小計和總計。儲存格 A38 是下一個說明。","數量","項目編號","描述","自訂欄位","單價","折扣","項目合計"]
[{"$nulls":7},{"$f":"IF(SUM(B18)>0,SUM(B18*F18-G18),\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":5},"總折扣",{"$f":"IF(SUM(G18:G32)>0,SUM(G18:G32),\"\")","v":""}]
[{"$nulls":6},"小計",{"$f":"IF(SUM(H18:H32)>0,SUM(H18:H32),\"\")","v":""}]
[{"$nulls":6},"營業稅"]
[{"$nulls":6},"合計",{"$f":"IF(SUM(H34)>0,SUM((H34*H35)+H34),\"\")","v":""}]
[]
["儲存格 F38 會自動更新公司名稱。","支票抬頭請一律填寫",{"$nulls":3},{"$f":"B3","v":"貴公司名稱"}]
["右側儲存格是感謝訊息。","感謝您的惠顧！"]