{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Konkurentide demograafiateave","Konkurentide analüüs"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Konkurentide demograafiateave","index":0,"n_rows":9,"n_cols":11,"rows_kept":9,"merged":[[2,1,2,2]]}
[]
[null,"ETTEVÕTTE NIMI | KONKURENDI DEMOGRAAFILINE TEAVE"]
[null,"Konkurentide analüüs"]
[null,"KONKURENDI NIMI","ETTEVÕTTE SUURUS","TEGEVUSAASTAD","TÖÖTAJAD","TEHASED","JAEKAUPLUSED","OMANDIÕIGUS","KORPORATIIVNE ETTEVÕTE","STRUKTUUR","MÄRKMED"]
[null,"Konkurent 1","Väike",10,100,1,19,"Eraettevõte","Jah","Ainuomand","Minu märkmed"]
[null,"Konkurent 2","Suur",15,2050,5,30,"Avalik",null,"C-ettevõte"]
[null,"Konkurent 3","Väike",7,455,2,10,"Eraettevõte",null,"Piiratud vastutusega äriühing"]
[null,"Konkurent 4","Keskmine",10,807,2,14,"Eraettevõte",null,"S-ettevõte"]
[null,"Konkurent 5","Suur",18,1202,4,28,"Avalik",null,"C-ettevõte"]

{"sheet":"Konkurentide analüüs","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"merged":[[2,1,2,2],[3,1,3,2]]}
[]
[null,{"$f":"LEFT('Konkurentide demograafiateave'!B2,FIND(\"|\",'Konkurentide demograafiateave'!B2))&\" KONKURENTIDE ANALÜÜS\"","v":"ETTEVÕTTE NIMI | KONKURENTIDE ANALÜÜS"}]
[null,"Konkurentide demograafiline teave"]
[null,"     Hinnake konkurente järgmisel skaalal:     ",null,"0  Pole asjakohane ","1  Minimaalselt asjakohane","2  Mõnevõrra asjakohane","3  Keskmiselt asjakohane","4  Maksimaalselt asjakohane"]
[null,"KONKURENDI NIMI","JAEKAUPLUSTE ASUKOHAD","IGA-AASTANE SOODUSMÜÜK","TOODETE VÕRDLUS","TOODETE HIND","TURUNDUS","TOOTMISKULU","LAIENEMISMÄÄR","JUHTIMINE","TURUSTUS","TARNIJAD","RISKIKAPITAL","TURU VAJADUSD","KOKKU"]
[null,"Konkurent 1",2,3,1,2,3,1,0,3,3,3,0,2,{"$f":"SUM(Analüüs[[#This Row],[JAEKAUPLUSTE ASUKOHAD]:[TURU VAJADUSD]])","v":23}]
[null,"Konkurent 2",1,4,3,3,2,0,3,1,0,0,4,1,{"$f":"SUM(Analüüs[[#This Row],[JAEKAUPLUSTE ASUKOHAD]:[TURU VAJADUSD]])","v":22}]
[null,"Konkurent 3",2,3,2,1,4,4,3,2,2,1,1,2,{"$f":"SUM(Analüüs[[#This Row],[JAEKAUPLUSTE ASUKOHAD]:[TURU VAJADUSD]])","v":27}]
[null,"Konkurent 4",2,4,4,0,1,1,2,1,4,4,3,4,{"$f":"SUM(Analüüs[[#This Row],[JAEKAUPLUSTE ASUKOHAD]:[TURU VAJADUSD]])","v":30}]
[null,"Konkurent 5",4,0,4,2,4,2,1,3,4,4,2,3,{"$f":"SUM(Analüüs[[#This Row],[JAEKAUPLUSTE ASUKOHAD]:[TURU VAJADUSD]])","v":33}]
[null,"KESKMISED",{"$f":"IFERROR(SUBTOTAL(101,Analüüs[JAEKAUPLUSTE ASUKOHAD]),\"\")","v":2.2},{"$f":"IFERROR(SUBTOTAL(101,Analüüs[IGA-AASTANE SOODUSMÜÜK]),\"\")","v":2.8},{"$f":"IFERROR(SUBTOTAL(101,Analüüs[TOODETE VÕRDLUS]),\"\")","v":2.8},{"$f":"IFERROR(SUBTOTAL(101,Analüüs[TOODETE HIND]),\"\")","v":1.6},{"$f":"IFERROR(SUBTOTAL(101,Analüüs[TURUNDUS]),\"\")","v":2.8},{"$f":"IFERROR(SUBTOTAL(101,Analüüs[TOOTMISKULU]),\"\")","v":1.6},{"$f":"IFERROR(SUBTOTAL(101,Analüüs[LAIENEMISMÄÄR]),\"\")","v":1.8},{"$f":"IFERROR(SUBTOTAL(101,Analüüs[JUHTIMINE]),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IFERROR(SUBTOTAL(101,Analüüs[TURUSTUS]),\"\")","v":2.6},{"$f":"IFERROR(SUBTOTAL(101,Analüüs[TARNIJAD]),\"\")","v":2.4},{"$f":"IFERROR(SUBTOTAL(101,Analüüs[RISKIKAPITAL]),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IFERROR(SUBTOTAL(101,Analüüs[TURU VAJADUSD]),\"\")","v":2.4},{"$f":"SUBTOTAL(101,Analüüs[KOKKU])","v":{"v":27,"d":"27.0"}}]