{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["仪表板","销售额","收益","费用","税费","类别"],"not_rendered":{"images":1,"defined_names":34},"read":"whole","date_system":"1900"}

{"sheet":"仪表板","index":0,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[0,2,0,4],[0,6,3,7],[4,1,4,7]]}
[null,"损益表","[年或月] 至 [年月日]"]
[null,"公司名称","以千美元计"]
[null,"当前毛利率 [L/J]",{"$f":"IFERROR(IF(总毛利润=0,\"-\",总毛利润/总销售收入),\"-\")","v":"-"}]
[null,"当前销售利润率 [T/J]",{"$f":"IFERROR(IF(净利润=0,\"-\",净利润/总销售收入),\"-\")","v":"-"}]
[null,"请勿修改此工作表中的类别，否则可能会破坏公式。请使用“类别”工作表添加类别，并使用相关条目更新相应的工作表。此工作表将自动更新。"]
[null,"汇总","前期总额","总预算","当期\n总额","当期总额占销售额的百分比","与前期相比的总额变化百分比","与预算相比的总额变化百分比"]
[null,"总销售收入 [J]",{"$f":"SUMIFS(销售收入_1[前期],销售收入_1[收入类型],\"销售收入\")","v":0},{"$f":"SUMIFS(销售收入_1[预算],销售收入_1[收入类型],\"销售收入\")","v":0},{"$f":"SUMIFS(销售收入_1[当期],销售收入_1[收入类型],\"销售收入\")","v":0},{"$f":"SUMIFS(销售收入_1[当期占销售额的百分比],销售收入_1[收入类型],\"销售收入\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(销售收入_1[与前期相比的变化百分比],销售收入_1[收入类型],\"销售收入\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(销售收入_1[与预算相比的变化百分比],销售收入_1[收入类型],\"销售收入\")","v":{"v":0,"d":"0.00%"}}]
[null,"销售总成本 [K]",{"$f":"SUMIFS(销售收入_1[前期],销售收入_1[收入类型],\"销售成本\")","v":0},{"$f":"SUMIFS(销售收入_1[预算],销售收入_1[收入类型],\"销售成本\")","v":0},{"$f":"SUMIFS(销售收入_1[当期],销售收入_1[收入类型],\"销售成本\")","v":0},{"$f":"SUMIFS(销售收入_1[当期占销售额的百分比],销售收入_1[收入类型],\"销售成本\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(销售收入_1[与前期相比的变化百分比],销售收入_1[收入类型],\"销售成本\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(销售收入_1[与预算相比的变化百分比],销售收入_1[收入类型],\"销售成本\")","v":{"v":0,"d":"0.00%"}}]
[null,"销售与营销总费用 [M]",{"$f":"SUMIFS(运营费用[前期],运营费用[费用类型],\"销售与营销\")","v":0},{"$f":"SUMIFS(运营费用[预算],运营费用[费用类型],\"销售与营销\")","v":0},{"$f":"SUMIFS(运营费用[当期],运营费用[费用类型],\"销售与营销\")","v":0},{"$f":"SUMIFS(运营费用[当期占销售额的百分比],运营费用[费用类型],\"销售与营销\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(运营费用[与前期相比的变化百分比],运营费用[费用类型],\"销售与营销\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(运营费用[与预算相比的变化百分比],运营费用[费用类型],\"销售与营销\")","v":{"v":0,"d":"0.00%"}}]
[null,"研发总费用 [N]",{"$f":"SUMIFS(运营费用[前期],运营费用[费用类型],\"研发\")","v":0},{"$f":"SUMIFS(运营费用[预算],运营费用[费用类型],\"研发\")","v":0},{"$f":"SUMIFS(运营费用[当期],运营费用[费用类型],\"研发\")","v":0},{"$f":"SUMIFS(运营费用[当期占销售额的百分比],运营费用[费用类型],\"研发\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(运营费用[与前期相比的变化百分比],运营费用[费用类型],\"研发\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(运营费用[与预算相比的变化百分比],运营费用[费用类型],\"研发\")","v":{"v":0,"d":"0.00%"}}]
[null,"日常及行政管理总费用 [O]",{"$f":"SUMIFS(运营费用[前期],运营费用[费用类型],\"日常及行政管理\")","v":0},{"$f":"SUMIFS(运营费用[预算],运营费用[费用类型],\"日常及行政管理\")","v":0},{"$f":"SUMIFS(运营费用[当期],运营费用[费用类型],\"日常及行政管理\")","v":0},{"$f":"SUMIFS(运营费用[当期占销售额的百分比],运营费用[费用类型],\"日常及行政管理\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(运营费用[与前期相比的变化百分比],运营费用[费用类型],\"日常及行政管理\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(运营费用[与预算相比的变化百分比],运营费用[费用类型],\"日常及行政管理\")","v":{"v":0,"d":"0.00%"}}]
[null,"其他总运营费用 [P]",{"$f":"运营费用[[#Totals],[前期]]-SUM(C9:C11)","v":0},{"$f":"运营费用[[#Totals],[预算]]-SUM(D9:D11)","v":0},{"$f":"运营费用[[#Totals],[当期]]-SUM(E9:E11)","v":0},{"$f":"运营费用[[#Totals],[当期占销售额的百分比]]-SUM(F9:F11)","v":{"v":0,"d":"0.00%"}},{"$f":"运营费用[[#Totals],[与前期相比的变化百分比]]-SUM(G9:G11)","v":{"v":0,"d":"0.00%"}},{"$f":"运营费用[[#Totals],[与预算相比的变化百分比]]-SUM(H9:H11)","v":{"v":0,"d":"0.00%"}}]
[null,"其他收益 [S]",{"$f":"收益[[#Totals],[前期]]","v":0},{"$f":"收益[[#Totals],[预算]]","v":0},{"$f":"收益[[#Totals],[当期]]","v":0},{"$f":"收益[[#Totals],[当期占销售额的百分比]]","v":{"v":0,"d":"0.00%"}},{"$f":"收益[[#Totals],[与前期相比的变化百分比]]","v":{"v":0,"d":"0.00%"}},{"$f":"收益[[#Totals],[与预算相比的变化百分比]]","v":{"v":0,"d":"0.00%"}}]
[null,"总税费 [T]",{"$f":"税费[[#Totals],[前期]]","v":0},{"$f":"税费[[#Totals],[预算]]","v":0},{"$f":"税费[[#Totals],[当期]]","v":0},{"$f":"税费[[#Totals],[当期占销售额的百分比]]","v":{"v":0,"d":"0.00%"}},{"$f":"税费[[#Totals],[与前期相比的变化百分比]]","v":{"v":0,"d":"0.00%"}},{"$f":"税费[[#Totals],[与预算相比的变化百分比]]","v":{"v":0,"d":"0.00%"}}]
[]
[null,"毛利润 [L=J-K]",{"$f":"IFERROR(C7-C8,\"-\")","v":0},{"$f":"IFERROR(D7-D8,\"-\")","v":0},{"$f":"IFERROR(总销售收入-总销售成本,\"-\")","v":0},{"$f":"IFERROR(IF(总销售收入=0,\"0.00%\",总毛利润/总销售收入),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C16=总毛利润,0,IF(总毛利润>C16,ABS((总毛利润/C16)-1),IF(AND(总毛利润<C16,C16<0),-((总毛利润/C16)-1),(总毛利润/C16)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D16=总毛利润,0,IF(总毛利润>D16,ABS((总毛利润/D16)-1),IF(AND(总毛利润<D16,D16<0),-((总毛利润/D16)-1),(总毛利润/D16)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"总运营费用 [Q=M+N+O+P]",{"$f":"IFERROR(C9+C10+C11+C12,\"-\")","v":0},{"$f":"IFERROR(D9+D10+D11+D12,\"-\")","v":0},{"$f":"IFERROR(销售与营销总费用+研发总费用+日常及行政管理总费用+其他总费用,\"-\")","v":0},{"$f":"IFERROR(IF(总销售收入=0,\"0.00%\",总运营费用/总销售收入),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C17=总运营费用,0,IF(总运营费用>C17,ABS((总运营费用/C17)-1),IF(AND(总运营费用<C17,C17<0),-((总运营费用/C17)-1),(总运营费用/C17)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D17=总运营费用,0,IF(总运营费用>D17,ABS((总运营费用/D17)-1),IF(AND(总运营费用<D17,D17<0),-((总运营费用/D17)-1),(总运营费用/D17)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"运营收益 [R=L-Q]",{"$f":"IFERROR(C16-C17,\"-\")","v":0},{"$f":"IFERROR(D16-D17,\"-\")","v":0},{"$f":"IFERROR(总毛利润-总运营费用,\"-\")","v":0},{"$f":"IFERROR(IF(总销售收入=0,\"0.00%\",总运营收益/总销售收入),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C18=总运营收益,0,IF(总运营收益>C18,ABS((总运营收益/C18)-1),IF(AND(总运营收益<C18,C18<0),-((总运营收益/C18)-1),(总运营收益/C18)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D18=总运营收益,0,IF(总运营收益>D18,ABS((总运营收益/D18)-1),IF(AND(总运营收益<D18,D18<0),-((总运营收益/D18)-1),(总运营收益/D18)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"净利润 [U=R+S-T]",{"$f":"IFERROR(C18+C13-C14,\"-\")","v":0},{"$f":"IFERROR(D18+D13-D14,\"-\")","v":0},{"$f":"总运营收益+其他总收益-总税费","v":0},{"$f":"IFERROR(IF(总销售收入=0,\"0.00%\",净利润/总销售收入),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C19=净利润,0,IF(净利润>C19,ABS((净利润/C19)-1),IF(AND(净利润<C19,C19<0),-((净利润/C19)-1),(净利润/C19)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D19=净利润,0,IF(净利润>D19,ABS((净利润/D19)-1),IF(AND(净利润<D19,D19<0),-((净利润/D19)-1),(净利润/D19)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]

{"sheet":"销售额","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"merged":[[0,7,2,8]]}
[null,{"$f":"工作簿标题","v":"损益表"}]
[null,{"$f":"公司名称","v":"公司名称"},"以千美元计"]
[null,"销售收入",{"$f":"IFERROR(销售收入,\"-\")","v":0}]
[null,"收入类型","说明","前期","预算","当期","当期占销售额的百分比","与前期相比的变化百分比","与预算相比的变化百分比"]
[null,"销售收入","产品/服务 1",{"$nulls":3},{"$f":"IFERROR(IF(销售收入_1[[#Data],[#Totals],[当期]]=0,\"-\",销售收入_1[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[前期]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[前期]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[前期]],销售收入_1[[#This Row],[前期]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[预算]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[预算]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[预算]],销售收入_1[[#This Row],[预算]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"销售收入","产品/服务 2",{"$nulls":3},{"$f":"IFERROR(IF(销售收入_1[[#Data],[#Totals],[当期]]=0,\"-\",销售收入_1[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[前期]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[前期]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[前期]],销售收入_1[[#This Row],[前期]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[预算]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[预算]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[预算]],销售收入_1[[#This Row],[预算]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"销售收入","产品/服务 3",{"$nulls":3},{"$f":"IFERROR(IF(销售收入_1[[#Data],[#Totals],[当期]]=0,\"-\",销售收入_1[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[前期]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[前期]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[前期]],销售收入_1[[#This Row],[前期]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[预算]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[预算]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[预算]],销售收入_1[[#This Row],[预算]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"销售收入","产品/服务 4",{"$nulls":3},{"$f":"IFERROR(IF(销售收入_1[[#Data],[#Totals],[当期]]=0,\"-\",销售收入_1[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[前期]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[前期]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[前期]],销售收入_1[[#This Row],[前期]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[预算]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[预算]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[预算]],销售收入_1[[#This Row],[预算]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"销售成本","产品/服务 1",{"$nulls":3},{"$f":"IFERROR(IF(销售收入_1[[#Data],[#Totals],[当期]]=0,\"-\",销售收入_1[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[前期]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[前期]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[前期]],销售收入_1[[#This Row],[前期]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[预算]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[预算]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[预算]],销售收入_1[[#This Row],[预算]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"销售成本","产品/服务 2",{"$nulls":3},{"$f":"IFERROR(IF(销售收入_1[[#Data],[#Totals],[当期]]=0,\"-\",销售收入_1[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[前期]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[前期]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[前期]],销售收入_1[[#This Row],[前期]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[预算]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[预算]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[预算]],销售收入_1[[#This Row],[预算]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"销售成本","产品/服务 3",{"$nulls":3},{"$f":"IFERROR(IF(销售收入_1[[#Data],[#Totals],[当期]]=0,\"-\",销售收入_1[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[前期]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[前期]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[前期]],销售收入_1[[#This Row],[前期]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[预算]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[预算]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[预算]],销售收入_1[[#This Row],[预算]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"销售成本","产品/服务 4",{"$nulls":3},{"$f":"IFERROR(IF(销售收入_1[[#Data],[#Totals],[当期]]=0,\"-\",销售收入_1[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[前期]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[前期]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[前期]],销售收入_1[[#This Row],[前期]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(销售收入_1[[#This Row],[预算]]=销售收入_1[[#This Row],[当期]],0,IF(销售收入_1[[#This Row],[当期]]>销售收入_1[[#This Row],[预算]],ABS((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),IF(AND(销售收入_1[[#This Row],[当期]]<销售收入_1[[#This Row],[预算]],销售收入_1[[#This Row],[预算]]<0),-((销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1),(销售收入_1[[#This Row],[当期]]/销售收入_1[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"总销售收入",null,{"$f":"SUBTOTAL(109,销售收入_1[前期])","v":0},{"$f":"SUBTOTAL(109,销售收入_1[预算])","v":0},{"$f":"SUBTOTAL(109,销售收入_1[当期])","v":0},{"$f":"SUBTOTAL(109,销售收入_1[当期占销售额的百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,销售收入_1[与前期相比的变化百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,销售收入_1[与预算相比的变化百分比])","v":{"v":0,"d":"0.00%"}}]

{"sheet":"收益","index":2,"n_rows":7,"n_cols":9,"rows_kept":7,"merged":[[0,7,2,8]]}
[null,{"$f":"工作簿标题","v":"损益表"}]
[null,{"$f":"公司名称","v":"公司名称"},"以千美元计"]
[null,"收益",{"$f":"IFERROR(收益[[#Totals],[当期]],\"-\")","v":0}]
[null,"收益类型","说明","前期","预算","当期","当期占销售额的百分比","与前期相比的变化百分比","与预算相比的变化百分比"]
[null,"收益","其他收益",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",收益[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(收益[[#This Row],[前期]]=收益[[#This Row],[当期]],0,IF(收益[[#This Row],[当期]]>收益[[#This Row],[前期]],ABS((收益[[#This Row],[当期]]/收益[[#This Row],[前期]])-1),IF(AND(收益[[#This Row],[当期]]<收益[[#This Row],[前期]],收益[[#This Row],[前期]]<0),-((收益[[#This Row],[当期]]/收益[[#This Row],[前期]])-1),(收益[[#This Row],[当期]]/收益[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(收益[[#This Row],[预算]]=收益[[#This Row],[当期]],0,IF(收益[[#This Row],[当期]]>收益[[#This Row],[预算]],ABS((收益[[#This Row],[当期]]/收益[[#This Row],[预算]])-1),IF(AND(收益[[#This Row],[当期]]<收益[[#This Row],[预算]],收益[[#This Row],[预算]]<0),-((收益[[#This Row],[当期]]/收益[[#This Row],[预算]])-1),(收益[[#This Row],[当期]]/收益[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(销售收入=0,\"-\",收益[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(收益[[#This Row],[前期]]=收益[[#This Row],[当期]],0,IF(收益[[#This Row],[当期]]>收益[[#This Row],[前期]],ABS((收益[[#This Row],[当期]]/收益[[#This Row],[前期]])-1),IF(AND(收益[[#This Row],[当期]]<收益[[#This Row],[前期]],收益[[#This Row],[前期]]<0),-((收益[[#This Row],[当期]]/收益[[#This Row],[前期]])-1),(收益[[#This Row],[当期]]/收益[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(收益[[#This Row],[预算]]=收益[[#This Row],[当期]],0,IF(收益[[#This Row],[当期]]>收益[[#This Row],[预算]],ABS((收益[[#This Row],[当期]]/收益[[#This Row],[预算]])-1),IF(AND(收益[[#This Row],[当期]]<收益[[#This Row],[预算]],收益[[#This Row],[预算]]<0),-((收益[[#This Row],[当期]]/收益[[#This Row],[预算]])-1),(收益[[#This Row],[当期]]/收益[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"总销售收益",null,{"$f":"SUBTOTAL(109,收益[前期])","v":0},{"$f":"SUBTOTAL(109,收益[预算])","v":0},{"$f":"SUBTOTAL(109,收益[当期])","v":0},{"$f":"SUBTOTAL(109,收益[当期占销售额的百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,收益[与前期相比的变化百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,收益[与预算相比的变化百分比])","v":{"v":0,"d":"0.00%"}}]

{"sheet":"费用","index":3,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[0,7,2,8]]}
[null,{"$f":"工作簿标题","v":"损益表"}]
[null,{"$f":"公司名称","v":"公司名称"},"以千美元计"]
[null,"运营费用",{"$f":"IFERROR(运营费用[[#Totals],[当期]],\"-\")","v":0}]
[null,"费用类型","说明","前期","预算","当期","当期占销售额的百分比","与前期相比的变化百分比","与预算相比的变化百分比"]
[null,"销售与营销","广告",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"销售与营销","直销",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"销售与营销","其他费用（指定）",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"销售与营销","其他费用（指定）",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"研发","技术许可",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"研发","专利 ",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"研发","其他费用（指定）",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"研发","其他费用（指定）",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"日常及行政管理","工资和薪金",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"日常及行政管理","外部服务",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"日常及行政管理","日用品",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"日常及行政管理","餐饮和娱乐",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"日常及行政管理","租金",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"日常及行政管理","电话",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"日常及行政管理","水电费",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"日常及行政管理","折旧",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"日常及行政管理","保险",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"日常及行政管理","修理和维护",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"日常及行政管理","其他费用（指定）",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"日常及行政管理","其他费用（指定）",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",运营费用[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(运营费用[[#This Row],[前期]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[前期]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[前期]],运营费用[[#This Row],[前期]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(运营费用[[#This Row],[预算]]=运营费用[[#This Row],[当期]],0,IF(运营费用[[#This Row],[当期]]>运营费用[[#This Row],[预算]],ABS((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),IF(AND(运营费用[[#This Row],[当期]]<运营费用[[#This Row],[预算]],运营费用[[#This Row],[预算]]<0),-((运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1),(运营费用[[#This Row],[当期]]/运营费用[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"总运营费用",null,{"$f":"SUBTOTAL(109,运营费用[前期])","v":0},{"$f":"SUBTOTAL(109,运营费用[预算])","v":0},{"$f":"SUBTOTAL(109,运营费用[当期])","v":0},{"$f":"SUBTOTAL(109,运营费用[当期占销售额的百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,运营费用[与前期相比的变化百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,运营费用[与预算相比的变化百分比])","v":{"v":0,"d":"0.00%"}}]

{"sheet":"税费","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[0,7,2,8]]}
[null,{"$f":"工作簿标题","v":"损益表"}]
[null,{"$f":"公司名称","v":"公司名称"},"以千美元计"]
[null,"税费",{"$f":"IFERROR(税费[[#Totals],[当期]],\"-\")","v":0}]
[null,"类型","说明","前期","预算","当期","当期占销售额的百分比","与前期相比的变化百分比","与预算相比的变化百分比"]
[null,"税费","收入所得税",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",税费[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(税费[[#This Row],[前期]]=税费[[#This Row],[当期]],0,IF(税费[[#This Row],[当期]]>税费[[#This Row],[前期]],ABS((税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1),IF(AND(税费[[#This Row],[当期]]<税费[[#This Row],[前期]],税费[[#This Row],[前期]]<0),-((税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1),(税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(税费[[#This Row],[预算]]=税费[[#This Row],[当期]],0,IF(税费[[#This Row],[当期]]>税费[[#This Row],[预算]],ABS((税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1),IF(AND(税费[[#This Row],[当期]]<税费[[#This Row],[预算]],税费[[#This Row],[预算]]<0),-((税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1),(税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"税费","工资税",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",税费[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(税费[[#This Row],[前期]]=税费[[#This Row],[当期]],0,IF(税费[[#This Row],[当期]]>税费[[#This Row],[前期]],ABS((税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1),IF(AND(税费[[#This Row],[当期]]<税费[[#This Row],[前期]],税费[[#This Row],[前期]]<0),-((税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1),(税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(税费[[#This Row],[预算]]=税费[[#This Row],[当期]],0,IF(税费[[#This Row],[当期]]>税费[[#This Row],[预算]],ABS((税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1),IF(AND(税费[[#This Row],[当期]]<税费[[#This Row],[预算]],税费[[#This Row],[预算]]<0),-((税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1),(税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"税费","房地产税",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",税费[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(税费[[#This Row],[前期]]=税费[[#This Row],[当期]],0,IF(税费[[#This Row],[当期]]>税费[[#This Row],[前期]],ABS((税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1),IF(AND(税费[[#This Row],[当期]]<税费[[#This Row],[前期]],税费[[#This Row],[前期]]<0),-((税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1),(税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(税费[[#This Row],[预算]]=税费[[#This Row],[当期]],0,IF(税费[[#This Row],[当期]]>税费[[#This Row],[预算]],ABS((税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1),IF(AND(税费[[#This Row],[当期]]<税费[[#This Row],[预算]],税费[[#This Row],[预算]]<0),-((税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1),(税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"税费","其他税费（指定）",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",税费[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(税费[[#This Row],[前期]]=税费[[#This Row],[当期]],0,IF(税费[[#This Row],[当期]]>税费[[#This Row],[前期]],ABS((税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1),IF(AND(税费[[#This Row],[当期]]<税费[[#This Row],[前期]],税费[[#This Row],[前期]]<0),-((税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1),(税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(税费[[#This Row],[预算]]=税费[[#This Row],[当期]],0,IF(税费[[#This Row],[当期]]>税费[[#This Row],[预算]],ABS((税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1),IF(AND(税费[[#This Row],[当期]]<税费[[#This Row],[预算]],税费[[#This Row],[预算]]<0),-((税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1),(税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"税费","其他税费（指定）",{"$nulls":3},{"$f":"IFERROR(IF(销售收入=0,\"-\",税费[当期]/销售收入),\"-\")","v":"-"},{"$f":"IFERROR(IF(税费[[#This Row],[前期]]=税费[[#This Row],[当期]],0,IF(税费[[#This Row],[当期]]>税费[[#This Row],[前期]],ABS((税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1),IF(AND(税费[[#This Row],[当期]]<税费[[#This Row],[前期]],税费[[#This Row],[前期]]<0),-((税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1),(税费[[#This Row],[当期]]/税费[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(税费[[#This Row],[预算]]=税费[[#This Row],[当期]],0,IF(税费[[#This Row],[当期]]>税费[[#This Row],[预算]],ABS((税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1),IF(AND(税费[[#This Row],[当期]]<税费[[#This Row],[预算]],税费[[#This Row],[预算]]<0),-((税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1),(税费[[#This Row],[当期]]/税费[[#This Row],[预算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"总税费",null,{"$f":"SUBTOTAL(109,税费[前期])","v":0},{"$f":"SUBTOTAL(109,税费[预算])","v":0},{"$f":"SUBTOTAL(109,税费[当期])","v":0},{"$f":"IFERROR(SUBTOTAL(109,税费[当期占销售额的百分比]),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,税费[与前期相比的变化百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,税费[与预算相比的变化百分比])","v":{"v":0,"d":"0.00%"}}]

{"sheet":"类别","index":5,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"类别"]
[null,"销售收入"]
[null,"销售成本"]
[null,"收益"]
[null,"销售与营销"]
[null,"研发"]
[null,"日常及行政管理"]
[null,"税费"]