{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["竞争对手统计信息","竞争对手分析"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"竞争对手统计信息","index":0,"n_rows":9,"n_cols":11,"rows_kept":9,"merged":[[2,1,2,2]]}
[]
[null,"公司名称 | 竞争对手统计信息"]
[null,"竞争对手分析"]
[null,"竞争对手名称","公司规模","经营年限","员工数","工厂数","零售店","所有权","公司治理","结构","备注"]
[null,"竞争对手 1","小型",10,100,1,19,"私有","是","独资","我的备注"]
[null,"竞争对手 2","大型",15,2050,5,30,"公有",null,"C Corp"]
[null,"竞争对手 3","小型",7,455,2,10,"私有",null,"LLC"]
[null,"竞争对手 4","中型",10,807,2,14,"私有",null,"S Corp"]
[null,"竞争对手 5","大型",18,1202,4,28,"公有",null,"C Corp"]

{"sheet":"竞争对手分析","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"merged":[[2,1,2,2],[3,1,3,2]]}
[]
[null,{"$f":"LEFT(竞争对手统计信息!B2,FIND(\"|\",竞争对手统计信息!B2))&\" 竞争对手分析\"","v":"公司名称 | 竞争对手分析"}]
[null,"竞争对手统计信息"]
[null,"     使用此量表对每个竞争对手评分：     ",null,"0  不适用 ","1  最低程度适用","2  一定程度适用","3  中等程度适用","4  最大程度适用"]
[null,"竞争对手名称","零售位置","年销售额","产品比较","产品价格","市场营销","生产成本","扩展速率","领导力","配送","供应商","风险资本","市场需求","总计"]
[null,"竞争对手 1",2,3,1,2,3,1,0,3,3,3,0,2,{"$f":"SUM(分析[[#This Row],[零售位置]:[市场需求]])","v":23}]
[null,"竞争对手 2",1,4,3,3,2,0,3,1,0,0,4,1,{"$f":"SUM(分析[[#This Row],[零售位置]:[市场需求]])","v":22}]
[null,"竞争对手 3",2,3,2,1,4,4,3,2,2,1,1,2,{"$f":"SUM(分析[[#This Row],[零售位置]:[市场需求]])","v":27}]
[null,"竞争对手 4",2,4,4,0,1,1,2,1,4,4,3,4,{"$f":"SUM(分析[[#This Row],[零售位置]:[市场需求]])","v":30}]
[null,"竞争对手 5",4,0,4,2,4,2,1,3,4,4,2,3,{"$f":"SUM(分析[[#This Row],[零售位置]:[市场需求]])","v":33}]
[null,"平均值",{"$f":"IFERROR(SUBTOTAL(101,分析[零售位置]),\"\")","v":2.2},{"$f":"IFERROR(SUBTOTAL(101,分析[年销售额]),\"\")","v":2.8},{"$f":"IFERROR(SUBTOTAL(101,分析[产品比较]),\"\")","v":2.8},{"$f":"IFERROR(SUBTOTAL(101,分析[产品价格]),\"\")","v":1.6},{"$f":"IFERROR(SUBTOTAL(101,分析[市场营销]),\"\")","v":2.8},{"$f":"IFERROR(SUBTOTAL(101,分析[生产成本]),\"\")","v":1.6},{"$f":"IFERROR(SUBTOTAL(101,分析[扩展速率]),\"\")","v":1.8},{"$f":"IFERROR(SUBTOTAL(101,分析[领导力]),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IFERROR(SUBTOTAL(101,分析[配送]),\"\")","v":2.6},{"$f":"IFERROR(SUBTOTAL(101,分析[供应商]),\"\")","v":2.4},{"$f":"IFERROR(SUBTOTAL(101,分析[风险资本]),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IFERROR(SUBTOTAL(101,分析[市场需求]),\"\")","v":2.4},{"$f":"SUBTOTAL(101,分析[总计])","v":{"v":27,"d":"27.0"}}]