{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["利润表","变量"],"not_rendered":{"defined_names":25},"read":"whole","date_system":"1900"}

{"sheet":"利润表","index":0,"n_rows":58,"n_cols":5,"rows_kept":58,"merged":[[0,1,0,4]]}
[null,"利润表"]
[null,"名称"]
[null,"时间段"]
[null,"财务报表（以美元计）"]
[null,"收入"]
[null,"销售总额"]
[null,"减：退货和折让"]
[null,"    净销售额",null,null,{"$f":"IF(OR(D6<>0,D7<>0),SUM(D6-D7),0)","v":0}]
[]
[null,"所售商品成本"]
[null,"期初库存"]
[null,"加：                  购买"]
[null,"进货运费"]
[null,"直接人工费"]
[null,"间接费用"]
[null,"可用库存",null,{"$f":"IF(SUM(D11:D15),SUM(D11:D15),0)","v":0}]
[null,"减：期末库存"]
[null,"    所售商品成本",null,null,{"$f":"IF(OR(可用库存,D17),可用库存-D17,0)","v":0}]
[]
[null,"    总利润（损失）",null,null,{"$f":"IF(OR(净销售额,COGS),净销售额-COGS,0)","v":0}]
[]
[null,"支出"]
[null,"广告费"]
[null,"分期还款"]
[null,"呆帐"]
[null,"银行手续费"]
[null,"慈善捐赠"]
[null,"佣金"]
[null,"合同工"]
[null,"折旧"]
[null,"会费与订阅费"]
[null,"员工福利计划"]
[null,"保险 "]
[null,"利息"]
[null,"法务和专业费用"]
[null,"许可证和费用"]
[null,"其他"]
[null,"办公费用"]
[null,"工资税"]
[null,"邮费"]
[null,"租金"]
[null,"维修和维护"]
[null,"日用品"]
[null,"电话"]
[null,"差旅"]
[null,"水电费"]
[null,"车辆费"]
[null,"工资"]
[null,"    总费用",null,null,{"$f":"IF(SUM(D23:D48),SUM(D23:D48),0)","v":0}]
[]
[null,"    净营业收入",null,null,{"$f":"IF(OR(总利润,总费用),总利润-总费用,0)","v":0}]
[]
[null,"其他收入"]
[null,"资产销售的收益（损失）"]
[null,"利息收益"]
[null,"    其他收入总额",null,null,{"$f":"IF(OR(D54<>0,D55<>0),D54+D55,0)","v":0}]
[]
[null,"    净收入（损失）",null,null,{"$f":"IF(OR(营业收入,其他收入),营业收入+其他收入,0)","v":0}]

{"sheet":"变量","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true}
["_示例",false]
["_底纹",false]
["_系列","OfficeReady 3.0"]
["_外观",1]