{"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}
[]
[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}
[]
[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"}}]