{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Competitor Demographics","Competitor Analysis"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Competitor Demographics","index":0,"n_rows":9,"n_cols":11,"rows_kept":9}
[]
[null,"COMPANY NAME | COMPETITOR DEMOGRAPHICS"]
[null,"Competitor Analysis"]
[null,"COMPETITOR NAME","COMPANY SIZE","BUSINESS YEARS","EMPLOYEES","PLANTS","RETAIL OUTLETS","OWNERSHIP","CORPORATE GOVERNANCE","STRUCTURE","NOTES"]
[null,"Competitor 1","Small",10,100,1,19,"Private","Yes","Sole Ownership","My notes"]
[null,"Competitor 2","Large",15,2050,5,30,"Public",null,"C Corp"]
[null,"Competitor 3","Small",7,455,2,10,"Private",null,"LLC"]
[null,"Competitor 4","Medium",10,807,2,14,"Private",null,"S Corp"]
[null,"Competitor 5","Large",18,1202,4,28,"Public",null,"C Corp"]

{"sheet":"Competitor Analysis","index":1,"n_rows":11,"n_cols":15,"rows_kept":11}
[]
[null,{"$f":"LEFT('Competitor Demographics'!B2,FIND(\"|\",'Competitor Demographics'!B2))&\" COMPETITOR ANALYSIS\"","v":"COMPANY NAME | COMPETITOR ANALYSIS"}]
[null,"Competitor Demographics"]
[null,"     Use this scale to rate each competitor:     ",null,"0  Does Not Apply ","1  Minimally Applies","2  Somewhat Applies","3  Moderately Applies","4  Maximally Applies"]
[null,"COMPETITOR NAME","RETAIL LOCATIONS","ANNUAL SALES","PRODUCT COMPARISON","PRODUCT PRICE","MARKETING","PRODUCTION COST","EXPANSION RATE","LEADERSHIP","DISTRIBUTION","SUPPLIERS","VENTURE CAPITAL","MARKET NEEDS","TOTALS"]
[null,"Competitor 1",2,3,1,2,3,1,0,3,3,3,0,2,{"$f":"SUM(Analysis[[#This Row],[RETAIL LOCATIONS]:[MARKET NEEDS]])","v":23}]
[null,"Competitor 2",1,4,3,3,2,0,3,1,0,0,4,1,{"$f":"SUM(Analysis[[#This Row],[RETAIL LOCATIONS]:[MARKET NEEDS]])","v":22}]
[null,"Competitor 3",2,3,2,1,4,4,3,2,2,1,1,2,{"$f":"SUM(Analysis[[#This Row],[RETAIL LOCATIONS]:[MARKET NEEDS]])","v":27}]
[null,"Competitor 4",2,4,4,0,1,1,2,1,4,4,3,4,{"$f":"SUM(Analysis[[#This Row],[RETAIL LOCATIONS]:[MARKET NEEDS]])","v":30}]
[null,"Competitor 5",4,0,4,2,4,2,1,3,4,4,2,3,{"$f":"SUM(Analysis[[#This Row],[RETAIL LOCATIONS]:[MARKET NEEDS]])","v":33}]
[null,"AVERAGES",{"$f":"IFERROR(SUBTOTAL(101,Analysis[RETAIL LOCATIONS]),\"\")","v":2.2},{"$f":"IFERROR(SUBTOTAL(101,Analysis[ANNUAL SALES]),\"\")","v":2.8},{"$f":"IFERROR(SUBTOTAL(101,Analysis[PRODUCT COMPARISON]),\"\")","v":2.8},{"$f":"IFERROR(SUBTOTAL(101,Analysis[PRODUCT PRICE]),\"\")","v":1.6},{"$f":"IFERROR(SUBTOTAL(101,Analysis[MARKETING]),\"\")","v":2.8},{"$f":"IFERROR(SUBTOTAL(101,Analysis[PRODUCTION COST]),\"\")","v":1.6},{"$f":"IFERROR(SUBTOTAL(101,Analysis[EXPANSION RATE]),\"\")","v":1.8},{"$f":"IFERROR(SUBTOTAL(101,Analysis[LEADERSHIP]),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IFERROR(SUBTOTAL(101,Analysis[DISTRIBUTION]),\"\")","v":2.6},{"$f":"IFERROR(SUBTOTAL(101,Analysis[SUPPLIERS]),\"\")","v":2.4},{"$f":"IFERROR(SUBTOTAL(101,Analysis[VENTURE CAPITAL]),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IFERROR(SUBTOTAL(101,Analysis[MARKET NEEDS]),\"\")","v":2.4},{"$f":"SUBTOTAL(101,Analysis[TOTALS])","v":{"v":27,"d":"27.0"}}]