{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Rekapitulace","1_Ka1","2_Ka6","3_Ka7"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"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":"Rekapitulace","index":0,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[10,1,10,2],[10,3,10,8],[3,1,3,2],[4,1,4,2],[4,3,4,8],[5,1,5,2],[5,3,5,8],[7,1,7,2],[7,7,7,8],[8,1,8,2],[8,3,8,8],[9,1,9,2],[35,1,35,3],[11,1,11,2],[11,3,11,8],[12,1,12,2],[12,7,12,8],[14,1,14,8],[15,1,15,8],[23,3,23,5],[24,3,24,5],[25,3,25,5],[26,2,26,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[21,3,21,5],[22,3,22,5],[30,1,30,2],[31,1,31,2],[29,5,29,6],[31,5,31,6],[28,1,28,2],[28,5,28,6]]}
[null,null,"POKYNY:","Dodavatel vyplní pouze zeleně označené buňky na všech listech tohoto sešitu."]
[null,null,null,"Vyplněnou přílohu (celý sešit!) uložte do PDF a elektronicky podepište oprávněnou osobou."]
[]
[null,"PŘÍLOHA:",null,"Příloha č. 2 Kupní smlouvy SML/1721/2023"]
[null,"ZAKÁZKA:",null,"Nákup ICT zařízení 16/2023 (rozšíření datové sítě RKK)"]
[null,"PROJEKT:",null,"Regionální knihovna Karviná -  revitalizace a vybavení objektů knihovny, CZ.06.04.04/00/22_001/0000433"]
[]
[null,"OBJEDNATEL:",null,"Statutární město Karviná","IČO:","00297534","DIČ:","CZ00297534"]
[null,"FAKTURAČNÍ ADRESA:",null,"Fryštátská 72/1, 733 24 Karviná "]
[null,"DATOVÁ SCHRÁNKA:",null,"es5bv8q ","E-MAIL:","epodatelna@karvina.cz"]
[null,"KONTAKTNÍ OSOBY:",null,"Petr Olšanský, tel. 596 387 444 nebo 720 958 253"]
[]
[null,"DODAVATEL:",null,null,"IČO:",null,"DIČ:"]
[]
[]
[null,"Nabídka - Položkový rozpočet"]
[null,"Poř.","Umístění","část"," ",null,"Nabídková cena bez DPH","DPH","Nabídková cena s DPH"]
[null,1,"Ka1","hudební oddělení",null,null,{"$f":"'1_Ka1'!H23","v":0},{"$f":"G18*1.21","v":0},{"$f":"H18+G18","v":0}]
[null,2,"Ka1","RFID",null,null,{"$f":"'1_Ka1'!H45","v":0},{"$f":"G19*1.21","v":0},{"$f":"H19+G19","v":0}]
[null,3,"Ka1","kamery hudební oddělení",null,null,{"$f":"'1_Ka1'!H65","v":0},0,0]
[null,4,"Ka1","kamery oddělení polské literatury",null,null,{"$f":"'1_Ka1'!H86","v":0},0,0]
[null,5,"Ka1","TV panel",null,null,{"$f":"'1_Ka1'!H107","v":0},0,0]
[null,6,"Ka6","RFID",null,null,{"$f":"'2_Ka6'!H21","v":0},0,0]
[null,7,"Ka6","TV Panel",null,null,{"$f":"'2_Ka6'!H42","v":0},0,0]
[null,8,"Ka6","kamery",null,null,{"$f":"'2_Ka6'!H59","v":0},0,0]
[null,9,"Ka7","TV panel",null,null,{"$f":"'3_Ka7'!H22","v":0},0,0]
[null,"Celkem",null,null,null,null,{"$f":"SUM(G18:G26)","v":0},{"$f":"SUM(H18:H26)","v":0},{"$f":"SUM(I18:I26)","v":0}]
[]
[null,"Dodavatel:",null,null,null,"Objednatel:"]
[null,"podepsáno elektronicky",null,null,null,"podepsáno elektronicky"]
[null,"jméno oprávněné osoby",null,null,null,"JUDr. Olga Guziurová, MPA"]
[null,"funkce",null,null,null,"vedoucí odboru organizačního"]

{"sheet":"1_Ka1","index":1,"n_rows":108,"n_cols":9,"rows_kept":108,"cut":false,"hidden":false,"merged":[[90,0,90,7],[104,0,105,7],[42,0,43,7],[48,0,48,7],[62,0,63,7],[68,0,68,7],[83,0,84,7],[0,0,2,7],[3,0,3,7],[4,0,4,7],[20,0,21,7],[26,0,26,7]]}
["Datová síť RKKA Ka1 hudební oddělení + polské odd."]
[]
[]
[]
["část datové zásuvky hudební oddělení"]
["materiál:","popis:","počet:","cena za ks/m","práce za ks/m","cena mat celkem","cena práce celkem","cena celkem:","pozn."]
["Datový kabel","Stp cat6e kabel ",196,0,0,{"$f":"C7*D7","v":0},{"$f":"C7*E7","v":0},{"$f":"D7*C7+C7*E7","v":0}]
["Kabelová chránička ","Chránička 25mm do zdi",62,0,0,0,0,0]
["Instalační krabice","Krabice KPR68",9,0,0,0,0,0]
["šlic","Sekání šlicu v cihle (do šíře 30mm, do hl.30mm)",36,0,0,0,0,0]
["kapsa","Vykroužení kapsy pro krabici v cihle (do pr.80mm)",9,0,0,0,0,0]
["Zásuvka","Zásuvka 2x eth na stěnu ABB Tango bílá kompletní",12,0,0,0,0,0]
["Keystone","Keystone CAT6 STP",40,0,0,0,0,0,"20+20 keystone pro 20 dat kabelů"]
["Patch panel ","Patch panel modulární pro 24x keystone",1,0,0,0,0,0,"montaz do pripraveneho racku"]
["Zaslepka","Zaslepka pro keystone ABB Tango",4,0,0,0,0,0,"pro zasuvky kde bude jenom 1 keystone"]
["Držák","Elektroinstal krabice ABB Tango pod zásuvky na stěnu",3,0,0,0,0,0]
["Patchcord","Patchcord Cat6 STP 1m",20,0,0,0,0,0]
["Ost mat","Drobný instal mat – lišty sádra apod",1,0,0,0,0,0]
["Práce","Provedení otvoru přes zeď do 25mm / m ",2.6,0,0,0,0,0]
["Práce","Zaomitání drážek",36,0,0,0,0,0]
[]
[]
["CELKEM bez 21%DPH:",null,null,null,null,{"$f":"SUM(F7:F20)","v":0},{"$f":"SUM(G7:G20)","v":0},{"$f":"SUM(H7:H20)","v":0}]
["CELKEM včetně 21%DPH:",null,null,null,null,null,null,{"$f":"H23*1.21","v":0}]
[]
[]
["část datová zásuvka pro RFID hudební oddělení"]
["materiál:","popis:","počet:","cena za ks/m","práce za ks/m","cena mat celkem","cena práce celkem","cena celkem:"]
["Datový kabel","Stp cat6e kabel ",12,0,0,{"$f":"C29*D29","v":0},{"$f":"C29*E29","v":0},{"$f":"D29*C29+C29*E29","v":0}]
["Kabelová chránička ","Chránička 16mm do zdi",3,0,0,0,0,0,"hudební a chodba zasekat do zdi"]
["Instalační krabice","Krabice KPR68",1,0,0,0,0,0,"hudební a chodba zasekat do zdi"]
["šlic","Sekání šlicu v cihle (do šíře 30mm, do hl.30mm)",3,0,0,0,0,0,"hudební a chodba zasekat do zdi"]
["kapsa","Vykroužení kapsy pro krabici v cihle (do pr.80mm)",1,0,0,0,0,0,"hudební a chodba zasekat do zdi"]
["Zásuvka","Zásuvka 2x eth na stěnu ABB Tango bílá kompletní",1,0,0,0,0,0]
["Keystone","Keystone CAT6 STP",2,0,0,0,0,0]
["Trubka","Chránička 20mm PVC pevná vč příchytek na stěnu",7,0,0,0,0,0,"sklep"]
["Zaslepka","Zaslepka pro keystone ABB Tango",1,0,0,0,0,0]
["Lišta","Přechodová lišta Hliník 1m",1.5,0,0,0,0,0,"pro rfid na podlahu"]
["Patchcord","Patchcord Cat6 STP 1m",1,0,0,0,0,0]
["Ost mat","Drobný instal mat – lišty sádra apod",1,0,0,0,0,0]
["Práce","Provedení otvoru přes zeď do 25mm / m ",0.6,0,0,0,0,0]
["Práce","Zaomitání drážek",3,0,0,0,0,0]
[]
[]
["CELKEM bez 21%DPH:",null,null,null,null,{"$f":"SUM(F29:F42)","v":0},{"$f":"SUM(G29:G42)","v":0},{"$f":"SUM(H29:H42)","v":0}]
["CELKEM včetně 21%DPH:",null,null,null,null,null,null,{"$f":"H45*1.21","v":0}]
[]
[]
["část datové zásuvky pro kamery hudební oddělení"]
["materiál:","popis:","počet:","cena za ks/m","práce za ks/m","cena mat celkem","cena práce celkem","cena celkem:"]
["Datový kabel","Stp cat6e kabel ",69,0,0,{"$f":"C51*D51","v":0},{"$f":"C51*E51","v":0},{"$f":"D51*C51+C51*E51","v":0}]
["Kabelová chránička ","Chránička 25mm do zdi",35,0,0,0,0,0]
["Instalační krabice","Krabice KPR68",5,0,0,0,0,0]
["šlic","Sekání šlicu v cihle (do šíře 30mm, do hl.30mm)",35,0,0,0,0,0]
["kapsa","Vykroužení kapsy pro krabici v cihle (do pr.80mm)",5,0,0,0,0,0]
["Zásuvka","Zásuvka 2x eth na stěnu ABB Tango bílá kompletní",5,0,0,0,0,0,"vc zasuvky u vchodu nad dvermi"]
["Keystone","Keystone CAT6 STP",10,0,0,0,0,0]
["Zaslepka","Zaslepka pro keystone ABB Tango",5,0,0,0,0,0]
["Patchcord","Patchcord Cat6 STP 1m",5,0,0,0,0,0]
["Ost mat","Drobný instal mat – lišty sádra apod",1,0,0,0,0,0]
["Práce","Provedení otvoru přes zeď do 25mm / m ",2.4,0,0,0,0,0]
["Práce","Zaomitání drážek",35,0,0,0,0,0]
[]
[]
["CELKEM bez 21%DPH:",null,null,null,null,{"$f":"SUM(F51:F62)","v":0},{"$f":"SUM(G51:G62)","v":0},{"$f":"SUM(H51:H62)","v":0}]
["CELKEM včetně 21%DPH:",null,null,null,null,null,null,{"$f":"H65*1.21","v":0}]
[]
[]
["část datové zásuvky pro kamery oddeleni polské lit."]
["materiál:","popis:","počet:","cena za ks/m","práce za ks/m","cena mat celkem","cena práce celkem","cena celkem:"]
["Datový kabel","Stp cat6e kabel ",83,0,0,{"$f":"C71*D71","v":0},{"$f":"C71*E71","v":0},{"$f":"D71*C71+C71*E71","v":0},"pokládka do lišt"]
["Kabelová lišta","Lišta vkládací 25x20",12,0,0,0,0,0]
["Kabelová lišta","Lišta vkládací 20x20",6,0,0,0,0,0]
["Kabelová lišta","Lišta vkládací 40x20",8,0,0,0,0,0]
["Roh","Roh lišty, zakončení",8,0,0,0,0,0]
["Instalační krabice","Elektroinstal krabice ABB Tango pod zásuvky na stěnu",4,0,0,0,0,0]
["Zásuvka","Zásuvka 2x eth na stěnu ABB Tango bílá kompletní",4,0,0,0,0,0]
["Keystone","Keystone CAT6 STP",8,0,0,0,0,0]
["Zaslepka","Zaslepka pro keystone ABB Tango",4,0,0,0,0,0]
["Patchcord","Patchcord Cat6 STP 1m",4,0,0,0,0,0]
["Ost mat","Drobný instal mat – lišty sádra apod",1,0,0,0,0,0]
["Práce","Provedení otvoru přes zeď do 25mm / m ",5,0,0,0,0,0]
["Práce","Tmelení, sádrování",1,0,0,0,0,0]
[]
[]
["CELKEM bez 21%DPH:",null,null,null,null,{"$f":"SUM(F71:F83)","v":0},{"$f":"SUM(G71:G83)","v":0},{"$f":"SUM(H71:H83)","v":0}]
["CELKEM včetně 21%DPH:",null,null,null,null,null,null,{"$f":"H86*1.21","v":0}]
[]
[]
[]
["část datová zásuvka pro TV panel hudební oddělení"]
["materiál:","popis:","počet:","cena za ks/m","práce za ks/m","cena mat celkem","cena práce celkem","cena celkem:"]
["Datový kabel","Stp cat6e kabel ",18,0,0,{"$f":"C93*D93","v":0},{"$f":"C93*E93","v":0},{"$f":"D93*C93+C93*E93","v":0}]
["Kabelová chránička ","Chránička 25mm do zdi",16,0,0,0,0,0]
["Instalační krabice","Krabice KPR68",1,0,0,0,0,0]
["šlic","Sekání šlicu v cihle (do šíře 30mm, do hl.30mm)",16,0,0,0,0,0]
["kapsa","Vykroužení kapsy pro krabici v cihle (do pr.80mm)",1,0,0,0,0,0]
["Zásuvka","Zásuvka 2x eth na stěnu ABB Tango bílá kompletní",1,0,0,0,0,0]
["Keystone","Keystone CAT6 STP",2,0,0,0,0,0]
["Zaslepka","Zaslepka pro keystone ABB Tango",1,0,0,0,0,0]
["Patchcord","Patchcord Cat6 STP 1m",1,0,0,0,0,0]
["Ost mat","Drobný instal mat – lišty sádra apod",1,0,0,0,0,0]
["Práce","Provedení otvoru přes zeď do 25mm / m ",1.6,0,0,0,0,0]
["Práce","Zaomitání drážek",16,0,0,0,0,0]
[]
[]
["CELKEM bez 21%DPH:",null,null,null,null,{"$f":"SUM(F93:F104)","v":0},{"$f":"SUM(G93:G104)","v":0},{"$f":"SUM(H93:H104)","v":0}]
["CELKEM včetně 21%DPH:",null,null,null,null,null,null,{"$f":"H107*1.21","v":0}]

{"sheet":"2_Ka6","index":2,"n_rows":60,"n_cols":9,"rows_kept":60,"cut":false,"hidden":false,"merged":[[45,0,45,7],[56,0,57,7],[0,0,2,7],[3,0,3,7],[4,0,4,7],[18,0,19,7],[24,0,24,7],[39,0,40,7]]}
["Datová síť RKKA Ka6 MěDK"]
[]
[]
[]
["část datové zásuvky pro 2x RFID"]
["materiál:","popis:","počet:","cena za ks/m","práce za ks/m","cena mat celkem","cena práce celkem","cena celkem:","pozn."]
["Datový kabel","Stp cat6e kabel ",40,0,0,{"$f":"C7*D7","v":0},{"$f":"C7*E7","v":0},{"$f":"D7*C7+C7*E7","v":0},"2x20m"]
["Lišta","Instalační lišta 13x18",6,0,0,0,0,0,"od stropu k zásuvkám"]
["Instalační krabice","Elektroinstal krabice ABB Tango pod zásuvky na stěnu",2,0,0,0,0,0]
["Kabelová chránička ","Chránička 25mm do zdi",8,0,0,0,0,0]
["Práce","úprava podlahové krytiny, demontáž, montáž, sekání drážek",6,0,0,0,0,0,"k rfid bránám"]
["Zásuvka","Zásuvka 2x eth na stěnu ABB Tango bílá kompletní",2,0,0,0,0,0]
["Keystone","Keystone CAT6 STP",4,0,0,0,0,0]
["Zaslepka","Zaslepka pro keystone ABB Tango",2,0,0,0,0,0,"pro zasuvky kde bude jenom 1 keystone"]
["Patchcord","Patchcord Cat6 STP 1m",2,0,0,0,0,0]
["Ost mat","Drobný instal mat – lišty sádra apod",1,0,0,0,0,0]
["Práce","Provedení otvoru přes zeď do 25mm / m ",1,0,0,0,0,0]
["Práce","Demontáž a montáž světel v SDK podhledu v chodbě",6,0,0,0,0,0,"protažení utp kabelu ve stropě na chodbě"]
[]
[]
["CELKEM bez 21%DPH:",null,null,null,null,{"$f":"SUM(F7:F18)","v":0},{"$f":"SUM(G7:G18)","v":0},{"$f":"SUM(H7:H18)","v":0}]
["CELKEM včetně 21%DPH:",null,null,null,null,null,null,{"$f":"H21*1.21","v":0}]
[]
[]
["část datová + elektro zásuvka pro TV panel "]
["materiál:","popis:","počet:","cena za ks/m","práce za ks/m","cena mat celkem","cena práce celkem","cena celkem:"]
["Datový kabel","Stp cat6e kabel ",22,0,0,{"$f":"C27*D27","v":0},{"$f":"C27*E27","v":0},{"$f":"D27*C27+C27*E27","v":0}]
["Lišta","Instalační lišta 13x18",11,0,0,0,0,0]
["Instalační krabice","Elektroinstal krabice ABB Tango pod zásuvky na stěnu",2,0,0,0,0,0]
["Kabel elektro","CYKY 3x2,5mm2",12,0,0,0,0,0,"natazeni elektro ze zasuvky u okna za skrini u pultu"]
["Zásuvka 230V","ABB Tango bílá 230V kompletní",1,0,0,0,0,0]
["Zásuvka","Zásuvka 2x eth na stěnu ABB Tango bílá kompletní",1,0,0,0,0,0]
["Keystone","Keystone CAT6 STP",2,0,0,0,0,0]
["Zaslepka","Zaslepka pro keystone ABB Tango",1,0,0,0,0,0]
["Patchcord","Patchcord Cat6 STP 1m",1,0,0,0,0,0]
["Ost mat","Drobný instal mat – lišty sádra apod",1,0,0,0,0,0]
["Práce","Provedení otvoru přes zeď do 25mm / m ",0.5,0,0,0,0,0]
["Práce","Demontáž a montáž světel v SDK podhledu v chodbě",6,0,0,0,0,0,"protažení utp kabelu ve stropě na chodbě"]
["Práce","Revize elektro ",1,0,0,0,0,0]
[]
[]
["CELKEM bez 21%DPH:",null,null,null,null,{"$f":"SUM(F27:F39)","v":0},{"$f":"SUM(G27:G39)","v":0},{"$f":"SUM(H27:H39)","v":0}]
["CELKEM včetně 21%DPH:",null,null,null,null,null,null,{"$f":"H42*1.21","v":0}]
[]
[]
["část datové zásuvky pro 2x Kamera IP"]
["materiál:","popis:","počet:","cena za ks/m","práce za ks/m","cena mat celkem","cena práce celkem","cena celkem:"]
["Instalační krabice","Elektroinstal krabice ABB Tango pod zásuvky na stěnu",1,0,0,{"$f":"C48*D48","v":0},{"$f":"C48*E48","v":0},{"$f":"D48*C48+C48*E48","v":0}]
["Kabelová chránička ","Chránička 25mm",6,0,0,0,0,0]
["Zásuvka","Zásuvka 2x eth na stěnu ABB Tango bílá kompletní",1,0,0,0,0,0]
["Keystone","Keystone CAT6 STP",2,0,0,0,0,0]
["Zaslepka","Zaslepka pro keystone ABB Tango",1,0,0,0,0,0]
["Práce","Presunutí kabelu Cat6 ",12,0,0,0,0,0]
["Patchcord","Patchcord Cat6 STP 1m",1,0,0,0,0,0]
["Ost mat","Drobný instal mat – lišty sádra apod",1,0,0,0,0,0]
["Práce","Demontáž a montáž světel v SDK podhledu v místnosti",2,0,0,0,0,0]
[]
[]
["CELKEM bez 21%DPH:",null,null,null,null,{"$f":"SUM(F48:F56)","v":0},{"$f":"SUM(G48:G56)","v":0},{"$f":"SUM(H48:H56)","v":0}]
["CELKEM včetně 21%DPH:",null,null,null,null,null,null,{"$f":"H59*1.21","v":0}]

{"sheet":"3_Ka7","index":3,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,2,7],[4,0,4,7],[3,0,3,7],[19,0,20,7]]}
["Datová síť RKKA Ka7 Centrum"]
[]
[]
[]
["část datové + elektro zásuvky pro TV panel "]
["materiál:","popis:","počet:","cena za ks/m","práce za ks/m","cena mat celkem","cena práce celkem","cena celkem:"]
["Datový kabel","Stp cat6e kabel ",22,0,0,{"$f":"C7*D7","v":0},{"$f":"C7*E7","v":0},{"$f":"D7*C7+C7*E7","v":0}]
["Lišta","Instalační lišta 13x18",3,0,0,0,0,0]
["Instalační krabice","Elektroinstal krabice ABB Tango pod zásuvky na stěnu",2,0,0,0,0,0]
["Kabel elektro","CYKY 3x2,5mm2",22,0,0,0,0,0]
["Zásuvka 230V","ABB Tango bílá 230V kompletní",1,0,0,0,0,0]
["Zásuvka","Zásuvka 2x eth na stěnu ABB Tango bílá kompletní",1,0,0,0,0,0]
["Keystone","Keystone CAT6 STP",2,0,0,0,0,0]
["Zaslepka","Zaslepka pro keystone ABB Tango",1,0,0,0,0,0]
["Patchcord","Patchcord Cat6 STP 1m",1,0,0,0,0,0]
["Ost mat","Drobný instal mat – lišty sádra apod",1,0,0,0,0,0]
["Práce","Provedení otvoru přes zeď do 25mm / m ",0.5,0,0,0,0,0]
["Práce","Demontáž a montáž v SDK podhledu, tmelení ",6,0,0,0,0,0]
["Práce","Revize elektro ",1,0,0,0,0,0]
[]
[]
["CELKEM bez 21%DPH:",null,null,null,null,{"$f":"SUM(F7:F19)","v":0},{"$f":"SUM(G7:G19)","v":0},{"$f":"SUM(H7:H19)","v":0}]
["CELKEM včetně 21%DPH:",null,null,null,null,null,null,{"$f":"H22*1.21","v":0}]