{"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-05-09"}]
[null,"电话传真",null,"客户 ID ","ID"]
[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,"谢谢惠顾！"]