{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Stavebné poistenie","Montažne poistenie","Rámcová PZ"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Stavebné poistenie","index":0,"n_rows":70,"n_cols":40,"rows_kept":70,"cut":false,"hidden":false,"merged":[[50,18,50,19],[68,0,68,19],[44,14,44,15],[66,11,66,12],[65,14,65,17],[66,14,66,17],[65,18,65,19],[66,18,66,19],[63,10,63,19],[65,11,65,12],[61,11,61,12],[62,11,62,12],[61,14,61,17],[61,18,61,19],[55,18,55,19],[56,18,56,19],[58,11,58,12],[59,11,59,12],[58,18,58,19],[59,18,59,19],[58,14,58,17],[59,14,59,17],[55,11,55,12],[56,11,56,12],[51,14,51,17],[51,18,51,19],[53,18,53,19],[54,18,54,19],[53,14,53,17],[54,14,54,17],[55,14,55,17],[56,14,56,17],[47,11,47,12],[48,11,48,12],[53,11,53,12],[54,11,54,12],[50,14,50,17],[43,5,43,9],[44,6,44,7],[44,9,44,13],[46,11,46,12],[6,6,6,15],[6,18,6,19],[7,6,7,15],[10,5,10,17],[11,5,11,17],[14,7,14,8],[19,5,19,9],[20,5,20,9],[15,7,15,17],[16,7,16,17],[0,0,0,19],[4,5,4,12],[3,5,3,9],[3,15,3,19],[4,15,4,19],[21,5,21,9],[20,12,20,15],[21,12,21,15],[24,7,24,8],[28,17,28,18],[24,15,24,18],[30,5,30,18],[25,17,25,18],[26,17,26,18],[27,17,27,18],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[31,10,31,18],[32,16,32,17],[33,16,33,17],[34,5,34,18],[41,0,41,11],[41,17,41,19],[37,14,37,16],[38,14,38,16],[39,14,39,16],[41,13,41,15],[37,6,37,8],[38,6,38,8],[39,6,39,8],[40,14,40,16],[40,6,40,8]]}
["Dotazník na stavebné poistenie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vyplnenosť",null,"Poistený","Poistený 2","rozhodovačky:","Požiar","Rekonštrukcia","Typ poistenia","terén","zodpo."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"právnická osoba","investor",null,"Materiály odolné voči požiaru; excelentné protipožiarne vybavenie","Nová stavba, výstavba","All-riskové poistenie","rovina","Nízky (voľný priestor, žiadne inžinierske siete)",null,null,null,null,null,null,null,null,"povinný údaj"]
["1. Poistený",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fyzická osoba","hlavný dodávateľ","áno","Materiály odolné voči požiaru, štandardné protipožiarne vybavenie","Renovácia bez vplyvu na nosné konštrukcie a základy stavby","Poistenie živelných rizík","kopce","Stredné (zastavaná oblasť)",null,null,null,null,null,null,null,null,"nepovinný údaj"]
[null,"Poistený je:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F4=\"\",\"\",IF(F4=X2,\"IČO:\",\"Rod.č.:\"))","v":""},null,null,null,null,null,{"$f":"IF(V4=0,\"TU\",\"\")","v":"TU"},{"$f":"IF(OR(F4=\"\",P4=\"\"),0,1)","v":0},null,null,"subdodávateľ","nie","Horľavé materialy použité vo väčšom rozsahu","Renovácia so zásaahmi do základov alebonosného systému",null,"rovina+kopce","Vysoké (husto zastavaná oblasť)"]
[null,{"$f":"IF(F4=\"\",\"\",IF(F4=X2,\"Názov:\",\"Meno a priezvisko:\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O4=\"IČO:\",\"DIČ:\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(V5=0,\"TU\",\"\")","v":"TU"},{"$f":"IF(F5=\"\",0,1)","v":0}]
[null,{"$f":"IF(F4=\"\",\"\",IF(F4=X2,\"Sídlo:\",\"Adresa:\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poschodia/hala",1,null,"Rodne číslo"]
[null,null,{"$f":"IF(B6=\"\",\"\",\"Názov obce, mesta:\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B6=\"\",\"\",\"PSČ:\")","v":""},null,null,null,null,null,"Dnešný dátum:",{"$f":"TODAY()","v":"2012-09-17"},null,"IČO"]
[null,null,{"$f":"IF(B6=\"\",\"\",\"Názov ulice, s.č.:\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Začiatok sveta:","1990-08-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Koniec sveta:","2100-08-15"]
["2. Typ a opis stavby",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Začiatok poistenia",{"$f":"MAX(Y7+1,G38)","v":"2012-09-18"}]
[null,"Stavba:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V11=0,\"TU\",\"\")","v":"TU"},{"$f":"IF(F11=\"\",0,1)","v":0},null,null,null,null,"dd","mm","yyyy"]
[null,{"$f":"IF(F11=X59,\"aké iné:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(F12=\"\",F11=X59),0,1)","v":1},null,"Začiatok záručnej doby",null,{"$f":"O39+1","v":{"$error":"#VALUE!"}},{"$f":"DAY(Z12)","v":{"$error":"#VALUE!"}},{"$f":"MONTH(Z12)","v":{"$error":"#VALUE!"}},{"$f":"YEAR(Z12)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Koniec záručnej doby",null,{"$f":"DATE(AC13,AB13,AA13)-1","v":{"$error":"#VALUE!"}},{"$f":"AA12","v":{"$error":"#VALUE!"}},{"$f":"AB12+O41","v":{"$error":"#VALUE!"}},{"$f":"AC12","v":{"$error":"#VALUE!"}}]
["3. Adresa staveniska"]
[null,"PSČ:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zoznam",1,2,3,4,5,6,7,8,9,10]
[null,"Názov obce, mesta:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(H16=\"\",0,1)","v":0},null,{"$f":"IF(F11=\"\",\"\",F11)","v":""},{"$f":"IF($X$16=\"\",\"\",VLOOKUP($X$16,$X$17:$AH$59,Y15+1))","v":""},{"$f":"IF($X$16=\"\",\"\",VLOOKUP($X$16,$X$17:$AH$59,Z15+1))","v":""},{"$f":"IF($X$16=\"\",\"\",VLOOKUP($X$16,$X$17:$AH$59,AA15+1))","v":""},"","","","","","",{"$f":"IF($X$16=\"\",\"\",VLOOKUP($X$16,$X$17:$AH$59,AH15+1))","v":""}]
[null,"Názov ulice, s.č.; č. parcely:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10100 Ľahké drevené konštrukcie rodinných domov",1,1,0,0,0,0,0,0,0,0,null,"Počet nadzemných podlaží:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10110 Samostatné domy, dvojdomy",1,1,0,0,0,0,0,0,0,0,null,"Počet podzemných podlaží:"]
["4. Zadávateľ, investor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11100 Bytové domy, polyfunkčné domy",1,1,0,0,0,0,0,0,0,0,null,"Max. rozpätie nosných stĺpov:"]
[null,"Poistený je:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(F20=\"\",0,1)","v":0},null,"21100 Administratívne budovy",1,1,0,0,0,0,0,0,0,1,null,"Priemer kupoly:"]
[null,{"$f":"IF(F20=\"\",\"\",IF(F20=Y2,\"Hlavný dodávateľ:\",\"Investor:\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(F21<>\"\",\"IČO:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"21200 Obchody, predajne",1,1,0,0,0,0,0,0,0,0,null,"Obtiažnosť terénu:"]
[null,{"$f":"IF(F20=\"\",\"\",IF(F20=Y4,\"Hlavný dodávateľ:\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(F22<>\"\",\"IČO:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"21300 Školy, škôlky",1,1,0,0,0,0,0,0,0,0,null,"Dĺžka:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21301 Knižnice",1,1,0,0,0,0,0,0,0,0,null,"Verejná doprava v blízkosti:"]
["5. Opis stavby",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21400 Univerzity",1,1,0,0,0,0,0,0,0,1,null,"Odčerpávanie spodnej vody:"]
[null,{"$f":"IF(Y$16=1,$AJ17,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AC16=1,AJ21,\"\")","v":""},null,null,null,null,null,null,null,null,null,"",{"$f":"IF(OR(AND(B25<>\"\",H25=\"\"),AND(K25<>\"\",P25=\"\")),0,1)","v":1},null,"21500 Poschodové nadzemné garáže",1,1,0,0,0,0,0,0,0,0,null,"Hi-tech fasáda"]
[null,{"$f":"IF(Z16=1,$AJ18,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AD16=1,AJ22,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(K26=\"\",\"\",\"km\")","v":""},"",{"$f":"IF(OR(AND(B26<>\"\",H26=\"\"),AND(K26<>\"\",R26=\"\")),0,1)","v":1},null,"21600 Podzemné garáže",1,1,0,0,0,0,0,0,0,0,null,"Hi-tech inštalácie"]
[null,{"$f":"IF(AA16=1,$AJ19,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(B27=\"\",\"\",\"m\")","v":""},{"$f":"IF(AE16=1,AJ23,\"\")","v":""},null,null,null,null,null,null,null,null,null,"",{"$f":"IF(OR(AND(B27<>\"\",H27=\"\"),AND(K27<>\"\",R27=\"\")),0,1)","v":1},null,"21700 Nemocnice, zdravotné strediská",1,1,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(AB$16=1,$AJ20,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(B28=\"\",\"\",\"m\")","v":""},{"$f":"IF(AF16=1,AJ24,\"\")","v":""},null,null,null,null,null,null,null,null,null,"",{"$f":"IF(OR(AND(B28<>\"\",H28=\"\"),AND(K28<>\"\",R28=\"\")),0,1)","v":1},null,"21801 Vlakové stanice",0,1,1,0,0,0,0,0,1,0]
[null,{"$f":"IF(AG16=1,AJ25,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AH16=1,AJ26,\"\")","v":""},null,null,null,null,null,null,null,null,null,"",{"$f":"IF(OR(AND(B29<>\"\",H29=\"\"),AND(K29<>\"\",R29=\"\")),0,1)","v":1},null,"21802 Letiskové terminály",0,1,1,0,0,0,0,0,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21803 Autobusové stanice",0,1,1,0,0,0,0,0,1,0]
[null,"Požiarné riziko:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(F31=\"\",0,1)","v":0},null,"21900 Hotely, ubytovacie strediská",1,1,0,0,0,0,0,0,0,0]
[null,"Vzdialenosť od vodného toku:",null,null,null,null,null,"Názov:",null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(K32=\"\",0,1)","v":0},null,"21903 Väznice",1,1,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Vzdialenosť:",null,null,null,null,null,null,null,null,null,null,"km",null,"TU",{"$f":"IF(Q33=\"\",0,1)","v":0},null,"21905 Reštaurácie",1,1,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Výška nad hladinou:",null,null,null,null,null,null,null,null,null,null,"m",null,"TU",{"$f":"IF(Q34=\"\",0,1)","v":0},null,"22100 Divadlá, koncertné haly, kiná",0,1,1,0,0,0,0,0,1,0]
[null,"Stupeň renovácie:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(F35=\"\",0,1)","v":0},null,"22200 Výstaviská, kongresové haly",0,1,1,0,0,0,0,0,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22300 Kostoly, chrámy",0,1,1,0,0,0,0,0,1,0]
["6. Doba výstavby, doba poistenia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22400 Telocvične",0,1,1,0,0,0,0,0,0,0]
[null,"Začiatok výstavby:",null,null,null,null,null,null,null,null,"Koniec výstavby:",null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(OR(G38=\"\",O38=\"\",G39=\"\"),0,1)","v":0},null,"22500 Kryté plavárne",0,1,1,0,0,0,0,0,1,0]
[null,"Začiatok poistenia:",null,null,null,null,null,null,null,null,"Koniec poistenia:",null,null,null,{"$f":"IF(O38=\"\",\"\",O38)","v":""},null,null,null,null,null,null,null,null,"22700 Hangáre",0,0,1,0,0,0,0,0,0,0]
[null,"Skúšobná prevádzka:",null,null,null,null,null,null,null,null,{"$f":"IF(G40=Z3,\"počet týždňov:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(K40=\"\",\"\",IF(Q40=1,\"týždeň\",IF(OR(Q40=2,Q40=3,Q40=4),\"týždne\",\"\")))","v":""},null,null,"TU",{"$f":"IF(OR(G40=\"\",AND(G40=Z3,O40=\"\")),0,1)","v":0},null,"22800 Obchodné domy, nákupné strediská",0,1,1,0,0,0,0,0,1,0]
[null,"Záručná doba (v mes.):",null,null,null,null,null,null,null,null,{"$f":"IF(G41=Z3,\"počet mesiacov:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(OR(G41=\"\",AND(G41=Z3,O41=\"\")),0,1)","v":0},null,"31100 Priemyselné stavby, továrne - poschodové stavby",1,1,0,0,0,0,0,0,0,1]
[{"$f":"IF(OR(G38=\"\",G39=\"\",O38=\"\",AND(G39>Y7,G38<O38,G39<O38,G38<=G39)),\"\",\"!!! Chybne zadané dátumy !!!\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(G41=\"áno\",O41>5),\"od:\",\"\")","v":""},{"$f":"IF(AND(G41=\"áno\",O41>5,O39<>\"\"),Z12,\"\")","v":""},null,null,{"$f":"IF(AND(G41=\"áno\",O41>0),\"do:\",\"\")","v":""},{"$f":"IF(AND(G41=\"áno\",O41>5,O39<>\"\"),Z13,\"\")","v":""},null,null,null,null,null,"31200 Priemyselné stavby, továrne - haly",0,1,1,0,0,0,0,0,1,0]
["7. Výber rizík",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"31205 Priemyselné stavby, továrne - kupolovité",0,0,0,1,0,0,0,0,1,0]
[null,"Typ poistenia:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(F44=\"\",0,1)","v":0},null,"32100 Chladiarenské stavby - poschodové stavby",1,1,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(F44=AC2,\"Podlimit na odcudzenie:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,null,null,null,null,"",{"$f":"IF(OR(AND(B45<>\"\",G45=\"\"),AND(B45<>\"\",G45=Z3,OR(J45=\"\"))),0,1)","v":1},null,"32101 Chladiarenské stavby - haly",0,1,1,0,0,0,0,0,0,0]
[null,"Má byť uvedené riziko vylúčené z poistenia?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"32200 Sklady - poschodové stavby",1,1,0,0,0,0,0,0,0,1]
[null,null,"Zemetrasenie:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(L47=\"\",0,1)","v":0},null,"32201 Sklady - haly",0,1,1,0,0,0,0,0,0,0]
[null,null,"Víchrica, atmosférické zrážky:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(L48=\"\",0,1)","v":0},null,"51100 Demoličné práce, úprava terénu",0,0,0,0,0,0,0,0,0,0]
[null,null,"Záplava a povodeň:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(L49=\"\",0,1)","v":0},null,"51101 Práce na infraštruktúre pri novej výstavbe",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"51102 Výkopové práce, úprava terénu",0,0,0,0,0,0,1,1,0,0]
["8. Poistná suma a pripoistenia",null,null,null,null,null,null,null,null,null,null,null,null,null,"Poistná suma",null,null,null,"Mena",null,null,null,null,"51103 Základanie stavieb",0,0,0,0,0,0,1,1,0,0]
[null,"Poistná suma na stavebné práce vrátane materiálu:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(O52=\"\",O52=0),0,1)","v":0},null,"51107 Povrchové úpravy - parky, golfové ihriská",0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"52001 Dočasné cesty",0,0,0,0,0,0,0,0,0,0]
[null,"Poistenie nákladov na odpratávanie trosiek:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L54=\"\",AND(L54=$Z$3,OR(O54=\"\",O54=0))),0,1)","v":0},null,"52100 Chodníky, spevnené povrchy",0,0,0,0,0,0,0,0,0,0]
[null,"Poistenie stavebných strojov:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L55=\"\",AND(L55=$Z$3,OR(O55=\"\",O55=0))),0,1)","v":0},null,"52110 Cesty, dialnice v zastavaných častiach obcí",0,0,0,0,1,1,0,0,0,0]
[null,"Poistenie stavebného zariadenia:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",0,null,"52200 Cesty, dialnice v nezastavaných častiach obcí",0,0,0,0,1,1,0,0,0,0]
[null,"Pripoistenie vady projektu:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",0,null,"54001 Runway a letištné plochy",0,0,0,0,0,0,0,0,0,0]
[null,"Pripoistenie expresnej dopravy, nadčasov, prácu v noci, mimo prac. dní:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"55001 Železnice",0,0,0,0,1,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",0,null,"iné",1,1,1,1,1,1,1,1,1,1]
[null,"Pripoistenie leteckej dopravy náhradných dielov:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",0]
[]
[null,"Poistenie zodpovednost za škodu:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L62=\"\",AND(L62=$Z$3,OR(O62=\"\",O62=0))),0,1)","v":0}]
[null,"Pripoistenie krížovej zodpovednosti:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(L62=Z3,L63=\"\"),0,1)","v":1}]
[null,"Stupeň ohrozenia pri poistení zodpovednosti:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(L62=Z3,K64=\"\"),0,1)","v":1}]
[]
[null,"Pripoistenie okolitého majetku:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L66=\"\",AND(L66=$Z$3,OR(O66=\"\",O66=0))),0,1)","v":0}]
[null,"Pripoistenie prepravy materiálu v rámci SR:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L67=\"\",AND(L67=$Z$3,OR(O67=\"\",O67=0))),0,1)","v":0}]
[]
[{"$f":"IF(V69=0,\"Dotazník nie je kompletne vyplnený\",\"Dotazník je kompletne vyplnený\")","v":"Dotazník nie je kompletne vyplnený"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V57*V63*V4*V11*V12*V16*V20*V25*V26*V27*V28*V29*V31*V34*V35*V38*V44*V45*V49*V52*V54*V55*V56*V40*V59*V60*V62*V64*V66*V67*V41*V5*V32*V33*V34*V47*V48","v":0},"Vyplnenosť"]
[null,null,null,null,null,{"$f":"IF(A69=\"Dotazník je kompletne vyplnený\",\"Môžete ho poslať na:\",\"\")","v":""},null,null,null,null,{"$f":"IF(F70=\"\",\"\",\"ponuka@union.sk\")","v":""}]

{"sheet":"Montažne poistenie","index":1,"n_rows":175,"n_cols":44,"rows_kept":175,"cut":false,"hidden":false,"merged":[[12,0,12,19],[39,14,39,16],[39,6,39,8],[40,17,40,19],[36,14,36,16],[37,14,37,16],[38,14,38,16],[40,13,40,15],[33,5,33,18],[36,6,36,8],[29,5,29,18],[37,6,37,8],[38,6,38,8],[30,10,30,18],[31,16,31,17],[32,16,32,17],[15,7,15,17],[16,7,16,17],[21,5,21,9],[20,12,20,15],[21,12,21,15],[0,0,0,19],[4,5,4,12],[3,5,3,9],[3,15,3,19],[4,15,4,19],[54,14,54,17],[55,14,55,17],[6,6,6,15],[6,18,6,19],[7,6,7,15],[10,5,10,17],[11,5,11,17],[14,7,14,8],[19,5,19,9],[20,5,20,9],[42,5,42,9],[43,6,43,7],[43,9,43,13],[45,11,45,12],[46,11,46,12],[47,11,47,12],[52,11,52,12],[53,11,53,12],[50,14,50,17],[50,18,50,19],[52,18,52,19],[53,18,53,19],[52,14,52,17],[53,14,53,17],[54,18,54,19],[55,18,55,19],[57,11,57,12],[58,11,58,12],[57,18,57,19],[58,18,58,19],[57,14,57,17],[58,14,58,17],[54,11,54,12],[55,11,55,12],[62,10,62,19],[64,11,64,12],[60,11,60,12],[61,11,61,12],[60,14,60,17],[60,18,60,19],[40,0,40,11],[49,14,49,17],[49,18,49,19],[67,0,67,19],[43,14,43,15],[65,11,65,12],[64,14,64,17],[65,14,65,17],[64,18,64,19],[65,18,65,19],[27,6,27,8],[24,16,24,18],[25,16,25,18],[26,16,26,18],[27,16,27,18],[24,6,24,8],[25,6,25,8],[26,6,26,8]]}
["Dotazník na montážne poistenie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vyplnenosť",null,"Poistený","Poistený 2","rozhodovačky:","Požiar","Rekonštrukcia","Typ poistenia","terén","zodpo.",null,null,null,null,null,null,null,null,null,"0100 Dopravné systémy",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"právnická osoba","investor",null,"Materiály odolné voči požiaru; excelentné protipožiarne vybavenie","Nová montáž","All-riskové poistenie","rovina","Nízky (voľný priestor, žiadne inžinierske siete)",null,null,null,null,null,null,null,null,null,"0700 Tlačiarenský priemysel",4,null,"povinný údaj"]
["1. Poistený",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fyzická osoba","hlavný dodávateľ","áno","Materiály odolné voči požiaru, štandardné protipožiarne vybavenie","Drobná rekonštrukcia, bez výmeny hlavných častí","Poistenie živelných rizík","kopce","Stredné (zastavaná oblasť)",null,null,null,null,null,null,null,null,null,"0800 Chemický priemysel",10,null,"nepovinný údaj"]
[null,"Poistený je:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F4=\"\",\"\",IF(F4=X2,\"IČO:\",\"Rod.č.:\"))","v":""},null,null,null,null,null,{"$f":"IF(V4=0,\"TU\",\"\")","v":"TU"},{"$f":"IF(OR(F4=\"\",P4=\"\"),0,1)","v":0},null,null,"subdodávateľ","nie","Horľavé materialy použité vo väčšom rozsahu","Veľká rekonštrukcia, s výmenou hlavných častí",null,"rovina+kopce","Vysoké (husto zastavaná oblasť)",null,null,null,null,null,null,null,null,null,"0900 Spracovanie kovov",7]
[null,{"$f":"IF(F4=\"\",\"\",IF(F4=X2,\"Názov:\",\"Meno a priezvisko:\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O4=\"IČO:\",\"DIČ:\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(V5=0,\"TU\",\"\")","v":"TU"},{"$f":"IF(F5=\"\",0,1)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1000 Elektrotechnický priemysel",6]
[null,{"$f":"IF(F4=\"\",\"\",IF(F4=X2,\"Sídlo:\",\"Adresa:\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poschodia/hala",1,null,"Rodne číslo",null,null,null,null,null,null,null,null,null,null,null,null,null,"1100 Kovoobrábací priemysel",11]
[null,null,{"$f":"IF(B6=\"\",\"\",\"Názov obce, mesta:\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B6=\"\",\"\",\"PSČ:\")","v":""},null,null,null,null,null,"Dnešný dátum:",{"$f":"TODAY()","v":"2012-09-17"},null,"IČO",null,null,null,null,null,null,null,null,null,null,null,null,null,"1400 Potravinársky priemysel",16]
[null,null,{"$f":"IF(B6=\"\",\"\",\"Názov ulice, s.č.:\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Začiatok sveta:","1990-08-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1700 Technológia budov",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Koniec sveta:","2100-08-15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1800 Spracovanie dreva",5]
["2. Typ a opis montáže",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Začiatok poistenia",{"$f":"MAX(Y7+1,G37)","v":"2012-09-18"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2000 Chladiarenské zariadenia",2]
[null,"1. výber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(F11=\"\",0,1)","v":0},null,null,null,null,"dd","mm","yyyy",null,null,null,null,null,null,null,null,null,null,null,"2200 Poľnohospodárstvo",3]
[null,"2. výber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(OR(F12=\"\",F12=\" \"),0,1)","v":0},null,"Začiatok záručnej doby",null,{"$f":"O38+1","v":{"$error":"#VALUE!"}},{"$f":"DAY(Z12)","v":{"$error":"#VALUE!"}},{"$f":"MONTH(Z12)","v":{"$error":"#VALUE!"}},{"$f":"YEAR(Z12)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,"2300 Spracovanie kože",2]
[{"$f":"IF(OR(F12=\"\",AP44=1),\"\",\"!!! Chybné zaradenie !!!\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Koniec záručnej doby",null,{"$f":"DATE(AC13,AB13,AA13)-1","v":{"$error":"#VALUE!"}},{"$f":"AA12","v":{"$error":"#VALUE!"}},{"$f":"AB12+O40","v":{"$error":"#VALUE!"}},{"$f":"AC12","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,"2500 Papierenský priemysel",4]
["3. Adresa staveniska",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tony/deň","Výkon kW","Dĺžka","výkon MW","MVA","Tona/hodina","Priemr (cm)","Dĺžka",null,null,null,null,null,null,null,null,"2600 Telekomunikačné systémy",4]
[null,"PSČ:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zoznam",1,2,3,4,5,6,7,8,null,null,null,null,null,null,null,null,"2700 Stavebné materiály",8]
[null,"Názov obce, mesta:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(H16=\"\",0,1)","v":0},null,{"$f":"IF(F12=\"\",\"\",F12)","v":""},{"$f":"IF($X$16=\"\",\"\",VLOOKUP($X$16,$X$18:$AF$175,Y15+1))","v":""},{"$f":"IF($X$16=\"\",\"\",VLOOKUP($X$16,$X$18:$AF$175,Z15+1))","v":""},"","","","",{"$f":"IF($X$16=\"\",\"\",VLOOKUP($X$16,$X$18:$AF$175,AE15+1))","v":""},"",null,null,null,null,null,null,null,null,"2800 Textilný priemysel",8]
[null,"Názov ulice, s.č.; č. parcely:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0100 Dopravné systémy",null,null,null,null,null,null,null,null,null,null,null,"Výkon (tony/deň)",null,null,null,null,"3400 Čistenie vody a kanalizácia",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0101 Dopravníkové systémy",0,0,0,0,0,0,0,0,null,null,null,"Výkon (kW)",null,null,null,null,"3500 Výroba elektriny",20]
["4. Zadávateľ, investor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0102 Pásové dopravníky",0,0,0,0,0,0,0,0,null,null,null,"Dĺžka (m):",null,null,null,null,"4300 Optika a jemná mechanika",2]
[null,"Poistený je:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(F20=\"\",0,1)","v":0},null,"0105 Vybavenie čerpacích staníc",0,0,0,0,0,0,0,0,null,null,null,"Výkon (MW)",null,null,null,null,"4500 Výskumné a výpočtové centrá",3]
[null,{"$f":"IF(F20=\"\",\"\",IF(F20=Y2,\"Hlavný dodávateľ:\",\"Investor:\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(F21<>\"\",\"IČO:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"0110 Závesné dopravníky",0,0,0,0,0,0,0,0,null,null,null,"Výkon (MVA)",null,null,null,null,"5100 Potrubia",5]
[null,{"$f":"IF(F20=\"\",\"\",IF(F20=Y4,\"Hlavný dodávateľ:\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(F22<>\"\",\"IČO:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"0135 Lyžiarské vleky",0,0,0,0,0,0,0,0,null,null,null,"Výkon (tona/hod)",null,null,null,null,"Počet 2. výberu",{"$f":"VLOOKUP(F11,AO1:AP21,2)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0140 Električkové trate",0,0,0,0,0,0,0,0,null,null,null,"Priemer (cm)",null,null,null,null,"Začiatok výberu",{"$f":"MATCH(F11,X17:X175)","v":{"$error":"#N/A"}}]
["5. Opis stavby",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0700 Tlačiarenský priemysel",null,null,null,null,null,null,null,null,null,null,null,"Dĺžka (km)",null,null,null,1,{"$f":"IF(AN24<=$AP$22,INDEX($X$17:$X$175,$AP$23+AN24,1),\" \")","v":{"$error":"#N/A"}},{"$f":"IF($F$12=AO24,1,0)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(A13<>\"\",\"\",IF(Y$16=1,$AJ17,\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(A13<>\"\",\"\",IF(AC16=1,AJ21,\"\"))","v":""},null,null,null,null,null,null,null,null,null,"",{"$f":"IF(OR(AND(B25<>\"\",G25=\"\"),AND(K25<>\"\",Q25=\"\")),0,1)","v":1},null,"0701 Rotačná tlač",0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,2,{"$f":"IF(AN25<=$AP$22,INDEX($X$17:$X$175,$AP$23+AN25,1),\" \")","v":{"$error":"#N/A"}},{"$f":"IF($F$12=AO25,1,0)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(A13<>\"\",\"\",IF(Z16=1,$AJ18,\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(A13<>\"\",\"\",IF(AD16=1,AJ22,\"\"))","v":""},null,null,null,null,null,null,null,null,null,"",{"$f":"IF(OR(AND(B26<>\"\",G26=\"\"),AND(K26<>\"\",Q26=\"\")),0,1)","v":1},null,"0703 Kníhtlač",0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,3,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"IF(A13<>\"\",\"\",IF(AA16=1,$AJ19,\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(A13<>\"\",\"\",IF(AE16=1,AJ23,\"\"))","v":""},null,null,null,null,null,null,null,null,null,"",{"$f":"IF(OR(AND(B27<>\"\",G27=\"\"),AND(K27<>\"\",Q27=\"\")),0,1)","v":1},null,"0705 Spracovanie obrazov, skenovanie, úprava fotografií",0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,4,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"IF(A13<>\"\",\"\",IF(AB$16=1,$AJ20,\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(A13<>\"\",\"\",IF(AF16=1,AJ24,\"\"))","v":""},null,null,null,null,null,null,null,null,null,"",{"$f":"IF(OR(AND(B28<>\"\",G28=\"\"),AND(K28<>\"\",Q28=\"\")),0,1)","v":1},null,"0706 Knihviazačstvo",0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,5,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0800 Chemický priemysel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Požiarné riziko:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(F30=\"\",0,1)","v":0},null,"0810 Výroba hnojív",0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,7,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Vzdialenosť od vodného toku:",null,null,null,null,null,"Názov:",null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(K31=\"\",0,1)","v":0},null,"0830 Výroba plastov - polymerizacia, skvapalňovanie",0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,8,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,"Vzdialenosť:",null,null,null,null,null,null,null,null,null,null,"km",null,"TU",{"$f":"IF(Q32=\"\",0,1)","v":0},null,"0831 Výroba systetickej gumy, pneumatik",0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,9,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,"Výška nad hladinou:",null,null,null,null,null,null,null,null,null,null,"m",null,"TU",{"$f":"IF(Q33=\"\",0,1)","v":0},null,"0832 Výroba umelých vlákien",0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,10,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Stupeň renovácie:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(F34=\"\",0,1)","v":0},null,"0840 Výroba kozmetiky, liekov, insekticídov a pod.",0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,11,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0845 Výroba a spracovanie tukov, vosku, mydiel, saponátov",0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,12,{"$error":"#N/A"},{"$error":"#N/A"}]
["6. Doba výstavby, doba poistenia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0850 Spracovanie ropy",1,0,0,0,0,0,0,0,null,null,null,null,null,null,null,13,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Začiatok montáže:",null,null,null,null,null,null,null,null,"Koniec montáže:",null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(OR(G37=\"\",O37=\"\",G38=\"\"),0,1)","v":0},null,"0860 Spracovanie zemného plynu",1,0,0,0,0,0,0,0,null,null,null,null,null,null,null,14,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Začiatok poistenia:",null,null,null,null,null,null,null,null,"Koniec poistenia:",null,null,null,{"$f":"IF(O37=\"\",\"\",O37)","v":""},null,null,null,null,null,null,null,null,"0870 Výroba výbušnín",0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,15,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Skúšobná prevádzka:",null,null,null,null,null,null,null,null,{"$f":"IF(G39=Z3,\"počet týždňov:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(K39=\"\",\"\",IF(Q39=1,\"týždeň\",IF(OR(Q39=2,Q39=3,Q39=4),\"týždne\",\"\")))","v":""},null,null,"TU",{"$f":"IF(OR(G39=\"\",AND(G39=Z3,O39=\"\")),0,1)","v":0},null,"0885 Spracovanie uhlia, sadzí a grafitu",0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,16,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Záručná doba (v mes.):",null,null,null,null,null,null,null,null,{"$f":"IF(G40=Z3,\"počet mesiacov:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(OR(G40=\"\",AND(G40=Z3,O40=\"\")),0,1)","v":0},null,"0900 Spracovanie kovov",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"IF(OR(G37=\"\",G38=\"\",O37=\"\",AND(G38>Y7,G37<O37,G38<O37,G37<=G38)),\"\",\"!!! Chybne zadané dátumy !!!\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(G40=\"áno\",O40>5),\"od:\",\"\")","v":""},{"$f":"IF(AND(G40=\"áno\",O40>5,O38<>\"\"),Z12,\"\")","v":""},null,null,{"$f":"IF(AND(G40=\"áno\",O40>0),\"do:\",\"\")","v":""},{"$f":"IF(AND(G40=\"áno\",O40>5,O38<>\"\"),Z13,\"\")","v":""},null,null,null,null,null,"0911 Kompresory",0,1,0,0,0,0,0,0,null,null,null,null,null,null,null,18,{"$error":"#N/A"},{"$error":"#N/A"}]
["7. Výber rizík",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0912 Pumpy",0,1,0,0,0,0,0,0,null,null,null,null,null,null,null,19,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Typ poistenia:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(F43=\"\",0,1)","v":0},null,"0913 Ventilátory",0,1,0,0,0,0,0,0,null,null,null,null,null,null,null,20,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"IF(F43=AC2,\"Podlimit na odcudzenie:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,null,null,null,null,"",{"$f":"IF(OR(AND(B44<>\"\",G44=\"\"),AND(B44<>\"\",G44=Z3,OR(J44=\"\"))),0,1)","v":1},null,"0921 Oceľové konštrukcie - mosty",0,0,1,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(F11=\"\",\"0\",SUM(AP24:AP43))","v":"0"}]
[null,"Má byť uvedené riziko vylúčené z poistenia?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0922 Oceľové nádrže, zásobníky",0,0,0,0,0,0,0,0]
[null,null,"Zemetrasenie:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(L46=\"\",0,1)","v":0},null,"0923 Oceľové súčasti hydraulických projektov",0,0,0,0,0,0,0,0]
[null,null,"Víchrica, atmosférické zrážky:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(L47=\"\",0,1)","v":0},null,"0924 Oceľové veže, antémy, piliere, žeriavy",0,0,0,0,0,0,0,0]
[null,null,"Záplava a povodeň:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(L48=\"\",0,1)","v":0},null,"1000 Elektrotechnický priemysel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10001 Elektrické motory na striedavý prúd",0,0,0,0,0,0,0,0]
["8. Poistná suma a pripoistenia",null,null,null,null,null,null,null,null,null,null,null,null,null,"Poistná suma",null,null,null,"Mena",null,null,null,null,"10002 Elektrické motory na jednosmerný prúd",0,1,0,0,0,0,0,0]
[null,"Poistná suma na stavebné práce vrátane materiálu:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(O51=\"\",O51=0),0,1)","v":0},null,"1001 Zariadenia na výrobu počítačov",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1010 Zariadenia na výrobu energie a jej distribúciu",0,0,0,0,0,0,0,0]
[null,"Poistenie nákladov na odpratávanie trosiek:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L53=\"\",AND(L53=$Z$3,OR(O53=\"\",O53=0))),0,1)","v":0},null,"1020 Zariadenia na výrobu komunikačných výrobkov",0,0,0,0,0,0,0,0]
[null,"Poistenie montážnych strojov:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L54=\"\",AND(L54=$Z$3,OR(O54=\"\",O54=0))),0,1)","v":0},null,"1030 Zariadenia na výrobu medicinských výrobkov",0,0,0,0,0,0,0,0]
[null,"Poistenie montážneho zariadenia:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L55=\"\",AND(L55=$Z$3,OR(O55=\"\",O55=0,))),0,1)","v":0},null,"1100 Kovoobrábací priemysel"]
[null,"Pripoistenie vady projektu:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L56=\"\",AND(L56=$Z$3,OR(O56=\"\",O56=0))),0,1)","v":0},null,"1110 Železo, oceľ: Taviace zariadenia",0,0,0,0,0,0,0,0]
[null,"Pripoistenie expresnej dopravy, nadčasov, prácu v noci, mimo prac. dní:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1111 Železo, oceľ: Vysoké pece",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L58=\"\",AND(L58=$Z$3,OR(O58=\"\",O58=0))),0,1)","v":0},null,"1112 Železo, oceľ: Zmiešavače kovov",0,0,0,0,0,0,0,0]
[null,"Pripoistenie leteckej dopravy náhradných dielov",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L59=\"\",AND(L59=$Z$3,OR(O59=\"\",O59=0))),0,1)","v":0},null,"1121 Železo, oceľ: Valcovanie kovov za tepla",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1122 Železo, oceľ: Valcovanie kovov za studena",0,0,0,0,0,0,0,0]
[null,"Poistenie zodpovednost za škodu:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L61=\"\",AND(L61=$Z$3,OR(O61=\"\",O61=0))),0,1)","v":0},null,"1130 Železo, oceľ: Zlievarne",0,0,0,0,0,0,0,0]
[null,"Pripoistenie krížovej zodpovednosti:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(L61=Z3,L62=\"\"),0,1)","v":1},null,"1160 Neželezné kovy: Taviace zariadenia",0,0,0,0,0,0,0,0]
[null,"Stupeň ohrozenia pri poistení zodpovednosti:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(L61=Z3,K63=\"\"),0,1)","v":1},null,"1161 Hliník: taviace zariadenia",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1171 Neželezné kovy: valcovanie kovov za tepla",0,0,0,0,0,0,0,0]
[null,"Pripoistenie okolitého majetku:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L65=\"\",AND(L65=$Z$3,OR(O65=\"\",O65=0))),0,1)","v":0},null,"1172 Neželezné kovy: valcovanie kovov za studena",0,0,0,0,0,0,0,0]
[null,"Pripoistenie prepravy materiálu v rámci SR:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L66=\"\",AND(L66=$Z$3,OR(O66=\"\",O66=0))),0,1)","v":0},null,"1180 Neželezné kovy: zlievarne",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1400 Potravinársky priemysel"]
[{"$f":"IF(V68=0,\"Dotazník nie je kompletne vyplnený\",\"Dotazník je kompletne vyplnený\")","v":"Dotazník nie je kompletne vyplnený"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V56*V62*V4*V11*V12*V16*V20*V25*V26*V27*V28*V30*V33*V34*V37*V43*V44*V48*V51*V53*V54*V55*V39*V58*V59*V61*V63*V65*V66*V5*V31*V32*V33*V46*V47","v":0},null,"1410 Mliekarne",0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(A68=\"Dotazník je kompletne vyplnený\",\"Môžete ho poslať na:\",\"\")","v":""},null,null,null,null,{"$f":"IF(F69=\"\",\"\",\"ponuka@union.sk\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"1420 Pivárne",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1421 Destilérky",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1430 Zariadenia na plnenie fliaš",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1500 Pekárne",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1510 Zariadenia na spracovanie jedlého oleja a tukov",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1520 Mlyny",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1530 Spracovanie mäsa",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1540 Výrobaq konzervovaných výrobkov",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1550 Výroba čokolády a sladkostí",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1560 Praženie kávy",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1561 Spracovanie čaju",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1570 Spracovanie tabaku",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1580 Výroba sušených potravín",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1601 Výroba cukru z repy",1,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1602 Výroba cukru z trstiny",1,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1700 Technológia budov"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1701 Vykurovacie systémy",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1702 Klimatizačné systémy",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1703 Výťahy, eskalátory",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1704 Vybavenie kuchýň",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1707 Chladiace systémy",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1708 Svetlo",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1710 vybavenie kina, filmových štúdií",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1800 Spracovanie dreva"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1801 Výroba lepenky",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1802 Výroba preglejky",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1803 Výroba drevotriesiek, OSB dosiek",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1804 Výroba nábytku",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1805 Píla",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2000 Chladiarenské zariadenia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2001 Zariadenia na chladenie",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2002 Mraziarenské zariadenia",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2200 Poľnohospodárstvo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2201 Poľnohospodársky priemysel",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2202 Živočíšne farmy",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2203 hydinové farmy",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2300 Spracovanie kože"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2310 Garbiareň",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2320 Spracovanie kože",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2500 Papierenský priemysel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2510 Výroba papiera a kartónov",1,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2511 Spracovanie papiera a kartónov",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2520 Výroba drevoviny a celulózy",1,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2521 Spracovanie drevoviny a celulózy",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2600 Telekomunikačné systémy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2601 Panely telefónnych ústrední",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2603 Káble vrátane zemných prác",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2604 Káble bez zemných prác",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2610 Televízne a rádio zariadenia",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2700 Stavebné materiály"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2710 Výroba asfaltu",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2720 Výroba skla",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2730 Výroba sádry a vápna",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2740 Ťažba kameňa, štrku, piesku",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2750 Výroba cementu",1,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2752 Výroba panelov, betónu",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2760 Výroba tehál a keramiky",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2770 Spracovanie kameňa",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2800 Textilný priemysel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2801 Spracovanie základných surovín",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2802 Priadacie a tkáčske stroje",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2803 Pletacie a viazacie stroje",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2804 Výroba šiat a bielizne",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2805 Práčovne a žehliarne",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2807 Spracovanie juty",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2810 Farbiarne a bieliarne",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2900 Čistenie za sucha",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3400 Čistenie vody a kanalizácia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3410 Zariadenie na zachytávanie vody",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3411 Zariadenie na čistenie vody",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3412 Zariadenie na odsoľovanie vody",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3420 Systém na rozvod vody",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3430 kanalizačné systémy",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3500 Výroba elektriny"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3510 Tepelné elektrárne (uhlie, ropa, lignit)",0,0,0,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3512 Tepelné turbíny",0,0,0,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3513 Generátory v tepelných elektrárňach",0,0,0,0,1,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3514 Tepelné kotly vrátane bežného príslušenstva",0,0,0,0,0,1,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3550 Dieselové elektrárne",0,0,0,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3553 Generátory v dieselových elektrárňach",0,0,0,0,1,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3554 Dieselový motor v dieselových elektrárňach",0,0,0,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3560 Vodné elektrárne",0,0,0,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3561 Vodné elektrárne s Peltonovou turbínou",0,0,0,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3562 Vodné elektrárne s Francisovou turbínou",0,0,0,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3563 Vodné eletrárne s Kaplanovou turbínou",0,0,0,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3564 Frencisova turbína",0,0,0,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3565 Kaplanova turbína",0,0,0,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3566 Peltonova turbína",0,0,0,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3567 Generátor vo vodnej elektrárni",0,0,0,0,1,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3580 Distribúcia energie",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3581 Káble na distribúciu elektriny",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3582 Nadzemné elektrické vedenie",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3584 Transformátory",0,0,0,0,1,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3590 Paroplynové elektrárne",0,0,0,1,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4300 Optika a jemná mechanika"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4301 Výroba prístrojov jemnej mechaniky",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4302 Výroba optických prístrojov",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4500 Výskumné a výpočtové centrá"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4501 Inštalácia počítačov",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4502 Zariadenia pre vysokonapäťový výskum",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4510 Zariadenia pre jadrový a radiačný výskum",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5100 Potrubia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5110 Ropovody",0,0,0,0,0,0,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5120 Plynovody",0,0,0,0,0,0,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5130 Vodovodné a kanalizačné potrubia",0,0,0,0,0,0,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5150 Iné potrubia",0,0,0,0,0,0,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5160 Potrubia ponad rieku",0,0,0,0,0,0,1,1]

{"sheet":"Rámcová PZ","index":2,"n_rows":75,"n_cols":35,"rows_kept":75,"cut":false,"hidden":false,"merged":[[18,0,18,19],[47,0,47,11],[19,16,19,17],[20,16,20,17],[21,16,21,17],[22,0,22,19],[46,13,46,15],[46,6,46,8],[45,13,45,15],[73,0,73,19],[66,14,66,17],[66,18,66,19],[60,18,60,19],[61,18,61,19],[32,18,32,19],[66,11,66,12],[67,11,67,12],[56,14,56,17],[56,18,56,19],[52,11,52,12],[53,11,53,12],[54,11,54,12],[71,11,71,12],[70,14,70,17],[71,14,71,17],[70,18,70,19],[71,18,71,19],[68,10,68,19],[70,11,70,12],[63,11,63,12],[64,11,64,12],[63,18,63,19],[64,18,64,19],[63,14,63,17],[64,14,64,17],[60,11,60,12],[61,11,61,12],[59,11,59,12],[58,18,58,19],[59,18,59,19],[58,14,58,17],[59,14,59,17],[58,11,58,12],[60,14,60,17],[61,14,61,17],[49,5,49,9],[50,6,50,7],[50,9,50,13],[35,13,35,17],[34,9,34,12],[31,13,31,17],[42,0,42,19],[44,6,44,8],[45,6,45,8],[50,14,50,15],[6,18,6,19],[7,6,7,15],[10,5,10,17],[11,5,11,17],[0,0,0,19],[4,5,4,12],[3,5,3,9],[3,15,3,19],[4,15,4,19],[6,6,6,15],[44,13,44,18],[34,1,34,3],[13,5,13,17],[14,5,14,17],[16,5,16,17],[17,5,17,17],[24,7,24,17],[27,6,27,7],[32,13,32,17],[40,1,40,4],[41,1,41,4],[40,5,40,7],[41,5,41,7],[31,18,31,19],[28,7,28,10],[29,7,29,10],[30,7,30,10],[28,11,28,12],[29,11,29,12],[30,11,30,12],[35,1,35,3],[36,1,36,3],[37,1,37,3],[35,5,35,7],[36,5,36,7],[37,5,37,7],[39,1,39,4],[39,5,39,7],[39,9,39,12],[37,9,37,12],[38,9,38,16],[38,1,38,7],[36,18,36,19],[37,18,37,19],[34,5,34,7],[34,13,34,17],[34,18,34,19],[35,18,35,19],[36,9,36,12],[36,13,36,17],[35,9,35,12],[57,11,57,12],[57,14,57,17],[57,18,57,19],[37,13,37,17],[39,13,39,16],[40,9,40,12],[41,9,41,12],[40,13,40,16],[41,13,41,16],[47,17,47,19]]}
["Dotazník pre rámcovú poistnú zmluvu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vyplnenosť",null,"Poistený","Poistený 2","rozhodovačky:","Požiar","Rekonštrukcia","Typ poistenia","terén","zodpo.","územná platnosť","Doba poistenia"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"právnická osoba","investor",null,"Materiály odolné voči požiaru; excelentné protipožiarne vybavenie","Nová montáž","All-riskové poistenie","rovina","Nízky (voľný priestor, žiadne inžinierske siete)","územie SR","neurčitá technický rok",null,"povinný údaj"]
["1. Poistený",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fyzická osoba","hlavný dodávateľ","áno","Materiály odolné voči požiaru, štandardné protipožiarne vybavenie","Drobná rekonštrukcia, bez výmeny hlavných častí",null,"kopce","Stredné (zastavaná oblasť)","územie SR+ČR","neurčitá kalendárny rok",null,"nepovinný údaj"]
[null,"Poistený je:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F4=\"\",\"\",IF(F4=X2,\"IČO:\",\"Rod.č.:\"))","v":""},null,null,null,null,null,{"$f":"IF(V4=0,\"TU\",\"\")","v":"TU"},{"$f":"IF(OR(F4=\"\",P4=\"\"),0,1)","v":0},null,null,"subdodávateľ","nie","Horľavé materialy použité vo väčšom rozsahu","Veľká rekonštrukcia, s výmenou hlavných častí",null,"rovina+kopce","Vysoké (husto zastavaná oblasť)","územie EU","určitá 1 rok"]
[null,{"$f":"IF(F4=\"\",\"\",IF(F4=X2,\"Názov:\",\"Meno a priezvisko:\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O4=\"IČO:\",\"DIČ:\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(V5=0,\"TU\",\"\")","v":"TU"},{"$f":"IF(F5=\"\",0,1)","v":0}]
[null,{"$f":"IF(F4=\"\",\"\",IF(F4=X2,\"Sídlo:\",\"Adresa:\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poschodia/hala",1,null,"Rodne číslo"]
[null,null,{"$f":"IF(B6=\"\",\"\",\"Názov obce, mesta:\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B6=\"\",\"\",\"PSČ:\")","v":""},null,null,null,null,null,"Dnešný dátum:",{"$f":"TODAY()","v":"2012-09-17"},null,"IČO"]
[null,null,{"$f":"IF(B6=\"\",\"\",\"Názov ulice, s.č.:\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Začiatok sveta:","1990-08-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Koniec sveta:","2100-08-15"]
["2. Typ a opis stavebno-montážnej činnosti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Začiatok poistenia"]
["1.","a) hrubý opis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F11=\"\",\"TU\",\"\")","v":"TU"},{"$f":"IF(OR(F11=\"\",F12=\"\"),0,1)","v":0}]
[null,"b) bližší opis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V11=0,\"TU\",\"\")","v":"TU"}]
[]
["2.","a) hrubý opis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F14<>\"\",F15=\"\"),0,1)","v":1}]
[null,"b) bližší opis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V14=0,\"TU\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0100 Montáž Dopravné systémy"]
["3.","a) hrubý opis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(F17<>\"\",F18=\"\"),0,1)","v":1},null,"0700 Montáž Tlačiarenský priemysel"]
[null,"b) bližší opis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V17=0,\"TU\",\"\")","v":""},null,null,"0800 Montáž Chemický priemysel"]
[{"$f":"IF(OR(AND(F11=\"\",OR(F14<>\"\",F17<>\"\")),AND(F14=\"\",F17<>\"\")),\"Chybné usporiadanie\",\"OK\")","v":"OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0900 Montáž Spracovanie kovov"]
[null,"Typ prác:",null,null,null,"Stavby na zelenej lúke",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V20=0,\"TU\",\"\")","v":"TU"},{"$f":"IF(Q20=\"\",0,1)","v":0},null,"1000 Montáž Elektrotechnický priemysel"]
[null,null,null,null,null,"Rekonštrukcie bez zásahov do nosných systémov",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(Q21=\"\",0,1)","v":0},null,"1100 Montáž Kovoobrábací priemysel"]
[null,null,null,null,null,"Rekonštrukcie so zásahnmi do nosných systémov",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(Q22=\"\",0,1)","v":0},null,"1400 Montáž Potravinársky priemysel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1700 Montáž Technológia budov"]
["3. Miesto poistenia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1800 Montáž Spracovanie dreva"]
[null,"Územná platnosť",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(H25=\"\",0,1)","v":0},null,"2000 Montáž Chladiarenské zariadenia",null,1,2,5,"výsledná 1","výsledná 2","výsledná 3","výsledná 4","výsledná 5","výsledná 6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2200 Montáž Poľnohospodárstvo",null,"deň","dni","dní",{"$f":"HLOOKUP(B40,$Z$25:$AB$28,2)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(B41,$Z$25:$AB$28,2)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(B42,$Z$25:$AB$28,2)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(J40,$Z$25:$AB$28,2)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(J41,$Z$25:$AB$28,2)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(J42,$Z$25:$AB$28,2)","v":{"$error":"#N/A"}}]
["4. Obrat firmy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2300 Montáž Spracovanie kože",null,"týždeň","týždne","týždňov",{"$f":"HLOOKUP(B40,$Z$25:$AB$28,3)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(B41,$Z$25:$AB$28,3)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(B42,$Z$25:$AB$28,3)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(J40,$Z$25:$AB$28,3)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(J41,$Z$25:$AB$28,3)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(J42,$Z$25:$AB$28,3)","v":{"$error":"#N/A"}}]
[null,"Rok založenia firmy:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(G28=\"\",0,1)","v":0},null,"2500 Montáž Papierenský priemysel",null,"mesiac","mesiace","mesiacov",{"$f":"HLOOKUP(B40,$Z$25:$AB$28,4)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(B41,$Z$25:$AB$28,4)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(B42,$Z$25:$AB$28,4)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(J40,$Z$25:$AB$28,4)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(J41,$Z$25:$AB$28,4)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(J42,$Z$25:$AB$28,4)","v":{"$error":"#N/A"}}]
[null,"Obrat firmy v roku:",null,null,null,{"$f":"IF(OR(G28=\"\",G28>-1+YEAR(TODAY())),\"\",-1+YEAR(TODAY()))","v":""},null,null,null,null,null,{"$f":"IF(F29=\"\",\"\",IF(F29>2008,\"EUR\",\"SKK\"))","v":""},null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(F29<>\"\",OR(H29=\"\",L29=\"\",L29=\" \")),0,1)","v":1},null,"2600 Montáž Telekomunikačné systémy",null,null,null,"priemerna doba",{"$f":"IF(OR(F40=$Z$26,F40=$AA$26,F40=$AB$26),B40,IF(OR(F40=$Z$27,F40=$AA$27,F40=$AB$27),B40*7,IF(OR(F40=$Z$28,F40=$AA$28,F40=$AB$28),B40*30)))","v":false},{"$f":"IF(OR(F41=$Z$26,F41=$AA$26,F41=$AB$26),B41,IF(OR(F41=$Z$27,F41=$AA$27,F41=$AB$27),B41*7,IF(OR(F41=$Z$28,F41=$AA$28,F41=$AB$28),B41*30)))","v":false},{"$f":"IF(OR(F42=$Z$26,F42=$AA$26,F42=$AB$26),B42,IF(OR(F42=$Z$27,F42=$AA$27,F42=$AB$27),B42*7,IF(OR(F42=$Z$28,F42=$AA$28,F42=$AB$28),B42*30)))","v":false}]
[null,null,null,null,null,{"$f":"IF(OR(F29<=G28,F29=\"\"),\"\",F29-1)","v":""},null,null,null,null,null,{"$f":"IF(F30=\"\",\"\",IF(F30>2008,\"EUR\",\"SKK\"))","v":""},null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(F30<>\"\",OR(H30=\"\",L30=\"\",L30=\" \")),0,1)","v":1},null,"2700 Montáž Stavebné materiály",null,"Chyby",null,"maximálna doba",{"$f":"IF(OR(N40=$Z$26,N40=$AA$26,N40=$AB$26),J40,IF(OR(N40=$Z$27,N40=$AA$27,N40=$AB$27),J40*7,IF(OR(N40=$Z$28,N40=$AA$28,N40=$AB$28),J40*30)))","v":false},{"$f":"IF(OR(N41=$Z$26,N41=$AA$26,N41=$AB$26),J41,IF(OR(N41=$Z$27,N41=$AA$27,N41=$AB$27),J41*7,IF(OR(N41=$Z$28,N41=$AA$28,N41=$AB$28),J41*30)))","v":false},{"$f":"IF(OR(N42=$Z$26,N42=$AA$26,N42=$AB$26),J42,IF(OR(N42=$Z$27,N42=$AA$27,N42=$AB$27),J42*7,IF(OR(N42=$Z$28,N42=$AA$28,N42=$AB$28),J42*30)))","v":false}]
[null,null,null,null,null,{"$f":"IF(OR(F30<=G28,F30=\"\"),\"\",F29-2)","v":""},null,null,null,null,null,{"$f":"IF(F31=\"\",\"\",IF(F31>2008,\"EUR\",\"SKK\"))","v":""},null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(F31<>\"\",OR(H31=\"\",L31=\"\",L31=\" \")),0,1)","v":1},null,"2800 Montáž Textilný priemysel",null,"Priemerny obrat1",{"$f":"IF(OR(S36=\"\",S36=\" \"),\"\",F36*J36)","v":0}]
[null,"Predpokladaný obrat počas doby poistenia (poistná suma):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(N32=\"\",S32=\"\",S32=\" \"),0,1)","v":0},null,"3400 Montáž Čistenie vody a kanalizácia",null,"Priemerny obrat2",{"$f":"IF(OR(S37=\"\",S37=\" \"),0,F37*J37)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Obrat podľa zadaného počtu zakázok a priem. cien v bode 5: ",{"$f":"F36*J36+F37*J37+F38*J38","v":0},null,null,null,null,"EUR",null,null,null,null,"3500 Montáž Výroba elektriny",null,"Priemerny obrat3",{"$f":"IF(OR(S38=\"\",S38=\" \"),0,F38*J38)","v":0}]
["5. Informácie o stavbách/montážach",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4300 Montáž Optika a jemná mechanika",null,"Spolu priem obrat",{"$f":"SUM(AA31:AA33)","v":0}]
[null,"Podiel na PS",null,null,null,"Počet zakázok",null,null,null,"Priem. cena zakázky",null,null,null,"Max. cena zakázky",null,null,null,null,"Mena",null,null,null,null,"4500 Montáž Výskumné a výpočtové centrá",null,"Hlasený priem obrat",{"$f":"N32","v":0}]
["1.",null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(B36=\"\",B36=0,F36=\"\",F36=0,J36=\"\",J36=0,N36=\"\"),0,1)","v":0},null,"5100 Montáž Potrubia",null,"Hlasený priem obrat2",{"$f":"IF(L29=\"SKK\",H29/30.126,H29)","v":0}]
["2.",null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"",{"$f":"IF(F14=\"\",1,IF(OR(B37=\"\",B37=0,F37=\"\",F37=0,J37=\"\",J37=0,N37=\"\"),0,1))","v":1},null,"51000 Stavba Obytné budovy",null,"Správny obrat",{"$f":"IF(OR(AND(AA36*0.75<AA34,AA34<1.25*AA36),AND(AA35*0.75<AA34,AA34<1.25*AA35)),1,3)","v":3},"Chybne stanovená poistná suma (nesúlad PS, počtu zakázok a priemernej ceny)"]
["3.",null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"",{"$f":"IF(F17=\"\",1,IF(OR(B38=\"\",B38=0,F38=\"\",F38=0,J38=\"\",J38=0,N38=\"\"),0,1))","v":1},null,"52100 Stavba Poschodové stavby",null,"Správne percentá",{"$f":"IF(AND(F14=\"\",B36=100),1,IF(AND(F17=\"\",F14<>\"\",B36+B37=100),1,IF(AND(F14<>\"\",F17<>\"\",B36+B37+B38=100),1,3)))","v":3},"Chybne stanovený počet % pre jednotlivé typy činností"]
[null,"Priemerná doba výstavby/montáže",null,null,null,null,null,null,null,"Maximálna doba výstavby/montáže",null,null,null,null,null,null,null,null,null,null,null,null,null,"52200 Stavba Halové priestory",null,"Správne max.cas",{"$f":"IF(OR(AC29>AC30,AD29>AD30,AE29>AE30),3,1)","v":1},"Maximálna doba výstavby nesmie byť kratšia ako priemerná doba výstavby"]
["1.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,"TU",{"$f":"IF(OR(B40=\"\",B40=0,F40=\"\",J40=\"\",J40=0,N40=\"\"),0,1)","v":0},null,"53100 Stavba Priemyselné objekty",null,"Správne max. PS",{"$f":"IF(AND(N36>=J36,OR(F14=\"\",N37>=J37),OR(F17=\"\",N38>=J38)),1,3)","v":1},"Maximálna hodnota diela nemôže byť nižšia ako priemerná hodnota diela"]
["2.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(F14=\"\",1,IF(OR(B41=\"\",B41=0,F41=\"\",J41=\"\",J41=0,N41=\"\"),0,1))","v":1},null,"53200 Stavba Sklady",null,null,3,"OK"]
["3.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(F17=\"\",1,IF(OR(B42=\"\",B42=0,F42=\"\",J42=\"\",J42=0,N42=\"\"),0,1))","v":1},null,"99999 Iné"]
[{"$f":"IF(V36=0,\"\",VLOOKUP(3,AA37:AB41,2,FALSE))","v":""}]
["6. Doba poistenia"]
[null,"Začiatok poistenia:",null,null,null,null,null,null,null,null,null,null,"Doba poistenia: ",null,null,null,null,null,null,null,"TU",{"$f":"IF(OR(N45=\"\",G45=\"\"),0,1)","v":0}]
[null,"Skúšobná prevádzka:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G46=Z3,\"počet týždňov: \",\"\")","v":""},null,null,null,null,{"$f":"IF(M46=\"\",\"\",IF(P46=1,\"týždeň\",IF(OR(P46=2,P46=3,P46=4),\"týždne\",\"\")))","v":""},null,null,"TU",{"$f":"IF(OR(G46=\"\",AND(G46=Z3,N46=\"\")),0,1)","v":0}]
[null,"Záručná doba (v mes.):",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G47=Z3,\"počet mesiacov: \",\"\")","v":""},null,null,null,null,null,null,null,"TU",{"$f":"IF(OR(G47=\"\",AND(G47=Z3,N47=\"\")),0,1)","v":0}]
[]
["7. Výber rizík"]
[null,"Typ poistenia:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(F50=\"\",0,1)","v":0}]
[null,{"$f":"IF(F50=AC2,\"Podlimit na odcudzenie:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,null,null,null,null,"",{"$f":"IF(OR(AND(B51<>\"\",G51=\"\"),AND(B51<>\"\",G51=Z3,OR(J51=\"\"))),0,1)","v":1}]
[null,"Má byť uvedené riziko vylúčené z poistenia?"]
[null,null,"Zemetrasenie:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(L53=\"\",0,1)","v":0}]
[null,null,"Víchrica, atmosférické zrážky:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(L54=\"\",0,1)","v":0}]
[null,null,"Záplava a povodeň:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TU",{"$f":"IF(L55=\"\",0,1)","v":0}]
[]
["8. Pripoistenia",null,null,null,null,null,null,null,null,null,null,null,null,null,"Poistná suma",null,null,null,"Mena"]
[null,"Poistenie rozostavaných diel:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L58=\"\",AND(L58=$Z$3,OR(O58=\"\",O58=0))),0,1)","v":0}]
[null,"Poistenie nákladov na odpratávanie trosiek:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L59=\"\",AND(L59=$Z$3,OR(O59=\"\",O59=0))),0,1)","v":0}]
[null,"Poistenie stavebných/montážnach strojov:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L60=\"\",AND(L60=$Z$3,OR(O60=\"\",O60=0))),0,1)","v":0}]
[null,"Poistenie stavebného/montážneho zariadenia?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L61=\"\",AND(L61=$Z$3,OR(O61=\"\",O61=0))),0,1)","v":0}]
[null,"Pripoistenie vady projektu:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L62=\"\",AND(L62=$Z$3,OR(O62=\"\",O62=0))),0,1)","v":0}]
[null,"Pripoistenie expresnej dopravy, nadčasov, prácu v noci, mimo prac. dní:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L64=\"\",AND(L64=$Z$3,OR(O64=\"\",O64=0))),0,1)","v":0}]
[null,"Pripoistenie leteckej dopravy náhradných dielov",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L65=\"\",AND(L65=$Z$3,OR(O65=\"\",O65=0))),0,1)","v":0}]
[]
[null,"Poistenie zodpovednost za škodu:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,"TU",{"$f":"IF(OR(L67=\"\",AND(L67=$Z$3,OR(O67=\"\",O67=0))),0,1)","v":0}]
[null,"Pripoistenie krížovej zodpovednosti:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(L67=Z3,L68=\"\"),0,1)","v":1}]
[null,"Stupeň ohrozenia pri poistení zodpovednosti:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(L67=Z3,K69=\"\"),0,1)","v":1}]
[]
[null,"Pripoistenie okolitého majetku:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,{"$f":"IF(V71=0,\"TU\",\"\")","v":"TU"},{"$f":"IF(OR(L71=\"\",AND(L71=$Z$3,OR(O71=\"\",O71=0))),0,1)","v":0}]
[null,"Pripoistenie prepravy materiálu v rámci SR:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EUR",null,{"$f":"IF(V72=0,\"TU\",\"\")","v":"TU"},{"$f":"IF(OR(L72=\"\",AND(L72=$Z$3,OR(O72=\"\",O72=0))),0,1)","v":0}]
[]
[{"$f":"IF(OR(A19<>\"OK\",A43<>\"OK\",V74=0),\"Dotazník nie je kompletne a správne vyplnený\",\"Dotazník je kompletne a správne vyplnený\")","v":"Dotazník nie je kompletne a správne vyplnený"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V4*V11*V14*V17*V22*V25*V28*V29*V30*V31*V32*V36*V37*V38*V40*V41*V42*V45*V46*V47*V50*V51*V55*V59*V60*V61*V62*V64*V65*V67*V68*V69*V71*V72*V5*V20*V21*V53*V54*V58","v":0}]
[null,null,null,null,null,{"$f":"IF(A74=\"Dotazník je kompletne a správne vyplnený\",\"Môžete ho poslať na:\",\"\")","v":""},null,null,null,null,{"$f":"IF(F75=\"\",\"\",\"ponuka@union.sk\")","v":""}]