{"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":44,"n_cols":5,"rows_kept":44,"merged":[[0,1,0,2],[0,3,0,4],[2,1,2,3],[3,1,3,3],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[41,1,41,2],[41,3,41,4],[43,1,43,4]]}
[null,"此儲存格為標誌預留位置。",null,"發票"]
[]
[null,"貴公司名稱"]
[null,"貴公司標語"]
[null,"街道地址",null,"發票號碼","編號"]
[null,"郵遞區號，縣/市",null,"日期 ",{"$f":"TODAY()","v":"2022-04-27"}]
[null,"電話傳真",null,"客戶識別碼 ","識別碼"]
[null,"電子郵件"]
[null,"收件者","姓名"]
[null,null,"公司名稱"]
[null,null,"街道地址"]
[null,null,"郵遞區號，縣/市"]
[null,null,"電話"]
[null,"銷售人員","職稱","付款條件","付款期限"]
[{"$nulls":3},"貨到付款"]
[]
[null,"數量","描述","單價","項目合計"]
[{"$nulls":4},{"$f":"IF(SUM(B18)>0,SUM(B18*服務發票!$D18),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B19)>0,SUM(B19*服務發票!$D19),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B20)>0,SUM(B20*服務發票!$D20),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B21)>0,SUM(B21*服務發票!$D21),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B22)>0,SUM(B22*服務發票!$D22),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B23)>0,SUM(B23*服務發票!$D23),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B24)>0,SUM(B24*服務發票!$D24),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B25)>0,SUM(B25*服務發票!$D25),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B26)>0,SUM(B26*服務發票!$D26),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B27)>0,SUM(B27*服務發票!$D27),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B28)>0,SUM(B28*服務發票!$D28),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B29)>0,SUM(B29*服務發票!$D29),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B30)>0,SUM(B30*服務發票!$D30),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B31)>0,SUM(B31*服務發票!$D31),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B32)>0,SUM(B32*服務發票!$D32),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B33)>0,SUM(B33*服務發票!$D33),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B34)>0,SUM(B34*服務發票!$D34),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B35)>0,SUM(B35*服務發票!$D35),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B36)>0,SUM(B36*服務發票!$D36),\"\")","v":""}]
[{"$nulls":4},{"$f":"IF(SUM(B37)>0,SUM(B37*服務發票!$D37),\"\")","v":""}]
[{"$nulls":3},"小計",{"$f":"IF(SUM(E18:E37)>0,SUM(E18:E37),\"\")","v":""}]
[{"$nulls":3},"營業稅"]
[{"$nulls":3},"總計",{"$f":"IF(SUM(E38)>0,SUM((E38*E39)+E38),\"\")","v":""}]
[]
[null,"支票抬頭請一律填寫",null,{"$f":"B3","v":"貴公司名稱"}]
[]
[null,"感謝您的惠顧！"]