{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["帐单发票","公司设置"],"not_rendered":{"images":1,"defined_names":27},"read":"whole","date_system":"1900"}

{"sheet":"帐单发票","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"merged":[[1,1,1,2],[1,3,2,4],[1,6,2,6],[3,3,3,4],[4,3,4,4],[5,3,5,4],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[34,1,34,4]]}
[null,"发票","0005"]
[null,{"$f":"TODAY()","v":"2018-07-13"},null,{"$f":"发票总计","v":796.5},null," ","公司设置"]
[null,"付款截止日期：",{"$f":"TODAY()+15","v":"2018-07-28"},null,null," "]
[null,"米申",null,"ADVENTURE WORKS"]
[null,"Fabrikam, Inc.",null,"成都绿荫大街 23456 号"]
[null,"南京市天府街 1234 号",null,"花园城，邮编 098032"]
[null,"邮编 098052"]
[null,"数量","详细信息","单价","行合计"]
[null,2,"小组件",{"v":149.5,"d":"149.50"},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":{"v":299,"d":"299.00"}}]
[null,5,"垫圈",{"v":99.5,"d":"99.50"},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":{"v":497.5,"d":"497.50"}}]
[{"$nulls":4},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":0}]
[{"$nulls":4},{"$f":"IFERROR(发票详细信息[[#This Row],[单价]]*发票详细信息[[#This Row],[数量]],\"\")","v":0}]
[null,"折扣"]
[null,"净额总计",null,null,{"$f":"SUM(发票详细信息[行合计])-E24","v":{"v":796.5,"d":"¥796.50"}}]
[null,"税费"]
[null,{"$f":"REPT(公司设置_你的货币缩写,LEN(公司设置_你的货币缩写)>0) & \"总计\"","v":"人民币总计"},null,null,{"$f":"IFERROR(E25+E26, \"\")","v":{"v":796.5,"d":"¥796.50"}}]
[null,"付款详细信息",null,null,"其他信息"]
[null,"受益人姓名：",{"$f":" 公司设置_银行受益人姓名","v":"Adventure Works"},null,{"$f":"IFERROR(公司设置_你的姓名,\"\")","v":""}]
[null,"银行名称：",{"$f":"公司设置_银行名称","v":"Woodgrove Bank"},null,{"$f":"IFERROR(\"电话: \" & 公司设置_你的电话,\"\")","v":"电话: 425-555-0150"}]
[null,"银行地址：",{"$f":"公司设置_银行地址","v":"南京绿荫大街 234 号，花园城，邮编 09876"},null,{"$f":"IFERROR(\"传真: \" & 公司设置_你的传真,\"\")","v":"传真: 425-555-0151"}]
[null,"帐号：",{"$f":"公司设置_银行帐户","v":1234567},null,{"$f":"IFERROR(公司设置_你的URL,\"\")","v":"Adventure-Works.com"}]
[null,"路由号码（SWIFT 代码）：",{"$f":"公司设置_银行路由","v":9876543210},null,{"$f":"IFERROR(公司设置_你的电子邮件,\"\")","v":"Accounting@Adventure-Works.com"}]
[null,"付款参考：",{"$f":"发票编号显示","v":"0005"},null,{"$f":"IFERROR(IF(LEN(Client_PO),\"Contract/PO: \" & Client_PO,\"\"),\"\")","v":""}]
[null,{"$f":"UPPER(\"付款应通过银行转账或抬头为（\" & 公司设置_支票收款人& \"）的支票形式进行。\")","v":"付款应通过银行转账或抬头为（ADVENTURE WORKS）的支票形式进行。"}]

{"sheet":"公司设置","index":1,"n_rows":20,"n_cols":5,"rows_kept":20}
[null,"公司设置"]
[null,"开票公司详细信息","值",null,"帐单发票"]
[null,"姓名","黄杰"]
[null,"公司名称","ADVENTURE WORKS"]
[null,"地址行 1","成都绿荫大街 23456 号"]
[null,"地址行 2","花园城，邮编 098032"]
[null,"地址行 3"]
[null,"地址行 4"]
[null,"地址行 5"]
[null,"电话","425-555-0150"]
[null,"传真","425-555-0151"]
[null,"网站","Adventure-Works.com"]
[null,"电子邮件","Accounting@Adventure-Works.com"]
[null,"货币缩写","人民币"]
[null,"银行电汇受益人姓名","Adventure Works"]
[null,"银行名称","Woodgrove Bank"]
[null,"银行地址","南京绿荫大街 234 号，花园城，邮编 09876"]
[null,"帐户号码",1234567]
[null,"路由号码（SWIFT 代码）",9876543210]
[null,"支票抬头","Adventure Works"]