{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["V001-002-2022","Rozpis Pozic","Děleno Hotově+Výrobní výkresy","Výpalky","Data pro tabulky Skrýt"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"V001-002-2022","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Rozpis Pozic","index":1,"n_rows":76,"n_cols":14,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["Č.Sestavy","Č.Výkresu","Název","Jakost","Typ","Vstupní materiál","Délka","Délka celková","Č.Výkresu Pálení","Hmotnost Kg/Ks","Hmotnost Kg/Celková","Množství/Pozice","Množství celkové","Mj"]
["S-D-1000","S-D-1000","Forma univerzální",null,"Sestava",null,null,null,null,null,{"$f":"SUM(K3:K4)","v":323},5,null,"Ks"]
["S-D-1000","V48","Vložka venkovní 15L","S355JOH","Výrobní výkres+Výpalek","Plech s=15","Výpalek","Výpalek","l35_x12_f15_022.dxf",32.299999999999997,{"$f":"J3*M3","v":161.5},1,{"$f":"$L$2*L3","v":5},"Ks"]
["S-D-1000","V49","Vložka venkovní 15P","S355JOH","Výrobní výkres+Výpalek","Plech s=15","Výpalek","Výpalek","l35_x12_f15_022.dxf",32.299999999999997,{"$f":"J4*M4","v":161.5},1,{"$f":"$L$2*L4","v":5},"Ks"]
["S-D-1001","S-D-1001","Horní Rám",null,"Sestava",null,null,null,null,1902,{"$f":"SUM(K6:K24)","v":1896.7},1,null,"Ks"]
["S-D-1001",2,"Deska ","S235JR","Výrobní výkres+Výpalek","Plech s=20","Výpalek","Výpalek","l35_x12_f20_001.dxf",2.2999999999999998,{"$f":"J6*M6","v":9.1999999999999993},4,{"$f":"$L$5*L6","v":4},"Ks"]
["S-D-1001",1,"Středící kroužek","S235JR","Výrobní výkres ","TK 80",17,{"$f":"L7*G7","v":272},null,0.85,{"$f":"J7*M7","v":13.6},16,{"$f":"$L$5*L7","v":16},"Ks"]
["S-D-1001",3,"Skluz dna","S235JR","Výrobní výkres","PLO 90x30",230,920,null,4.4000000000000004,17.600000000000001,4,4,"Ks"]
["S-D-1001",4,"HEB 160","S235JR","Výrobní výkres","HEB 160",480,960,null,18,36,2,2,"Ks"]
["S-D-1001",5,"Lem rámu A","S235JR","Výrobní výkres","Jackl 180x100x6",4780,9560,null,115.7,231.4,2,2,"Ks"]
["S-D-1001",6,"Lem rámu B","S235JR","Výrobní výkres","Jackl 180x100x6",1610,1610,null,39.1,39.1,1,1,"Ks"]
["S-D-1001","l35_x12_f06_001.dxf","Záslepka Jacklu","S235JR","Výpalek ","Plech s=6","Výpalek","Výpalek","l35_x12_f06_001.dxf",0.7,2.8,4,4,"Ks"]
["S-D-1001","l35_x12_f06_002.dxf","Žebro dna","S235JR","Výpalek ","Plech s=6","Výpalek","Výpalek","l35_x12_f06_002.dxf",4.5,90,20,20,"Ks"]
["S-D-1001","z62_c06_f06_003.dxf","Podložka matice","S235JR","Výpalek ","Plech s=6","Výpalek","Výpalek","l35_x12_f06_003.dxf",0.2,3.2,16,16,"Ks"]
["S-D-1001","l35_x12_f10_001.dxf","Základový plech","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_001.dxf",643.9,643.9,1,1,"Ks"]
["S-D-1001","l35_x12_f10_002.dxf","Příruba HEB 160","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_002.dxf",1.9,17.099999999999998,9,9,"Ks"]
["S-D-1001","l35_x12_f10_003.dxf","Příruba HEB 140","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_003.dxf",2,10,5,5,"Ks"]
["S-D-1001","l35_x12_f10_004.dxf","Kotevní deska A","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_004.dxf",4.7,56.400000000000006,12,12,"KS"]
["S-D-1001","l35_x12_f10_005.dxf","Kotevní deska B","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_005.dxf",2.5,22.5,9,9,"Ks"]
["S-D-1001","S-D-1001","Jackl 180x100x6","S235JR","Děleno hotově","Jackl 180x100x6",160,320,null,3.9,7.8,2,2,"Ks"]
["S-D-1001","S-D-1001","Jackl 180x100x6","S235JR","Děleno hotově","Jackl 180x100x6",1610,1610,null,39.5,39.5,1,1,"Ks"]
["S-D-1001","S-D-1001","Jackl 180x100x6","S235JR","Děleno hotově","Jackl 180x100x6",4780,9560,null,117.2,234.4,2,2,"Ks"]
["S-D-1001","S-D-1001","HEB 160","S235JR","Děleno hotově","HEB 160",1620,9720,null,69.3,415.79999999999995,6,6,"Ks"]
["S-D-1001","S-D-1001","TR 35x5","S235JR","Děleno hotově","TR 35x5",100,1600,null,0.4,6.4,16,16,"Ks"]
["S-D-1002","S-D-1002","Příčník",null,"Sestava",null,null,null,null,239,{"$f":"SUM(K26:K35)","v":233.39999999999998},1,null,"Ks"]
["S-D-1002",1,"Středící kroužek","S235JR","Výrobní výkres","TK 80",17,{"$f":"G26*L26","v":102},null,0.85,{"$f":"J26*M26","v":5.0999999999999996},6,{"$f":"$L$25*L26","v":6},"Ks"]
["S-D-1002","l35_x12_f05_001.dxf","Žebro","S235JR","Výpalek ","Plech s=5","Výpalek","Výpalek","l35_x12_f05_001.dxf",0.7,{"$f":"J27*M27","v":11.2},16,{"$f":"$L$25*L27","v":16},"Ks"]
["S-D-1002","l35_x12_f06_003.dxf","Podložka matice","S235JR","Výpalek ","Plech s=6","Výpalek","Výpalek","l35_x12_f06_003.dxf",0.2,1.2000000000000002,6,6,"Ks"]
["S-D-1002","l35_x12_f06_004.dxf","Bočnice 01","S235JR","Výpalek ","Plech s=6","Výpalek","Výpalek","l35_x12_f06_004.dxf",16.600000000000001,33.200000000000003,2,2,"Ks"]
["S-D-1002","l35_x12_f06_004a.dxf","Bočnice 02","S235JR","Výpalek ","Plech s=6","Výpalek","Výpalek","l35_x12_f06_004a.dxf",15.9,31.8,2,2,"Ks"]
["S-D-1002","l35_x12_f06_005.dxf","Klínek ","S235JR","Výpalek ","Plech s=6","Výpalek","Výpalek","l35_x12_f06_005.dxf",0.4,1.6,4,4,"Ks"]
["S-D-1002","l35_x12_f10_006.dxf","Pásek ","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_006.dxf",64.8,64.8,1,1,"Ks"]
["S-D-1002","l35_x12_f15_001.dxf","Základna","S235JR","Výpalek ","Plech s=15","Výpalek","Výpalek","l35_x12_f15_001.dxf",3.9,15.6,4,4,"Ks"]
["S-D-1002","S-D-1002","U120","S235JR","Děleno hotově","U 120",4940,{"$f":"L34*G34","v":4940},null,65.900000000000006,65.900000000000006,1,1,"Ks"]
["S-D-1002","S-D-1002","TR 35x5","S235JR","Děleno hotově","TR 35x5",130,{"$f":"L35*G35","v":780},null,0.5,3,6,6,"Ks"]
["S-D-1003","S-D-1003","Forma B",null,"Sestava",null,null,null,null,272.2,{"$f":"SUM(K37:K45)","v":543.59999999999991},2,null,"Ks"]
["S-D-1003",7,"Kolej","S235JR","Výrobní výkres","HEB 160",1900,{"$f":"L37*G37","v":3800},null,81.5,{"$f":"J37*M37","v":326},2,{"$f":"$L$36*L37","v":4},"Ks"]
["S-D-1003",8,"Hřeben","S235JR","Výrobní výkres","HEB 140",1900,1900,null,59.7,{"$f":"J38*M38","v":119.4},1,{"$f":"$L$36*L38","v":2},"Ks"]
["S-D-1003",9,"Příčka","S235JR","Výrobní výkres","U 140",692.5,1385,null,11,44,2,4,"Ks"]
["S-D-1003","l35_x12_f08_001.dxf","Příložka","S235JR","Výpalek ","Plech s=8","Výpalek","Výpalek","l35_x12_f08_001.dxf",3.1,12.4,2,4,"Ks"]
["S-D-1003","l35_x12_f10_002.dxf","Příruba HEB160","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_002.dxf",1.9,7.6,2,4,"Ks"]
["S-D-1003","l35_x12_f10_003.dxf","Příruba HEB 140","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_003.dxf",2,4,1,2,"Ks"]
["S-D-1003","l35_x12_f10_005.dxf","Kotevní deska B","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_005.dxf",2.5,5,1,2,"Ks"]
["S-D-1003","l35_x12_f10_007.dxf","Kotevní deska koleje","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_007.dxf",4.7,18.8,2,4,"Ks"]
["S-D-1003","l35_x12_f15_002.dxf","Doraz","S355JOH","Výpalek ","Plech s=15","Výpalek","Výpalek","l35_x12_f15_002.dxf",1.6,6.4,2,4,"Ks"]
["S-D-1004","S-D-1004","Držák",null,"Sestava",null,null,null,null,281.5,{"$f":"SUM(K47:K55)","v":281},1,null,"Ks"]
["S-D-1004",7,"Kolej","S235JR","Výrobní výkres","HEB 160",1900,{"$f":"L47*G47","v":3800},null,81.5,{"$f":"J47*M47","v":163},2,{"$f":"$L$46*L47","v":2},"Ks"]
["S-D-1004",8,"Hřeben","S235JR","Výrobní výkres","HEB 140",1900,1900,null,59.7,{"$f":"J48*M48","v":59.7},1,{"$f":"$L$46*L48","v":1},"Ks"]
["S-D-1004",10,"Příčka ","S235JR","Výrobní výkres","U 140",892.5,1785,null,14.2,28.4,2,2,"Ks"]
["S-D-1004","l35_x12_f08_001.dxf","Příložka","S235JR","Výpalek ","Plech s=8","Výpalek","Výpalek","l35_x12_f08_001.dxf",3.1,6.2,2,2,"Ks"]
["S-D-1004","l35_x12_f10_002.dxf","Příruba HEB160","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_002.dxf",1.9,1.9,1,1,"Ks"]
["S-D-1004","l35_x12_f10_003.dxf","Příruba HEB 140","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_003.dxf",2,2,1,1,"Ks"]
["S-D-1004","l35_x12_f10_005.dxf","Kotevní deska B","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_005.dxf",2.5,2.5,1,1,"Ks"]
["S-D-1004","l35_x12_f10_007.dxf","Kotevní deska koleje","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_007.dxf",4.7,14.100000000000001,3,3,"Ks"]
["S-D-1004","l35_x12_f15_002.dxf","Doraz","S355JOH","Výpalek ","Plech s=15","Výpalek","Výpalek","l35_x12_f15_002.dxf",1.6,3.2,2,2,"Ks"]
["S-D-1005","S-D-1005","Horní Rám A",null,"Sestava",null,null,null,null,450,{"$f":"SUM(K57:K65)","v":887.2},2,null,"Ks"]
["S-D-1005",9,"Příčka","S235JR","Výrobní výkres","U 140",692.5,{"$f":"L57*G57","v":2770},null,11,{"$f":"J57*M57","v":88},4,{"$f":"$L$56*L57","v":8},"Ks"]
["S-D-1005",11,"Kolej","S235JR","Výrobní výkres","HEB 160",3100,6200,null,132.4,{"$f":"J58*M58","v":529.6},2,{"$f":"$L$56*L58","v":4},"Ks"]
["S-D-1005",12,"Hřeben","S235JR","Výrobní výkres","HEB 140",3100,3100,null,95.8,191.6,1,2,"Ks"]
["S-D-1005","l35_x12_f08_001.dxf","Příložka","S235JR","Výpalek ","Plech s=8","Výpalek","Výpalek","l35_x12_f08_001.dxf",3.1,12.4,2,4,"Ks"]
["S-D-1005","l35_x12_f10_002.dxf","Příruba HEB160","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_002.dxf",1.9,7.6,2,4,"Ks"]
["S-D-1005","l35_x12_f10_003.dxf","Příruba HEB 140","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_003.dxf",2,4,1,2,"Ks"]
["S-D-1005","l35_x12_f10_005.dxf","Kotevní deska B","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_005.dxf",2.5,10,2,4,"Ks"]
["S-D-1005","l35_x12_f10_007.dxf","Kotevní deska koleje","S235JR","Výpalek ","Plech s=10","Výpalek","Výpalek","l35_x12_f10_007.dxf",4.7,37.6,4,8,"Ks"]
["S-D-1005","l35_x12_f15_002.dxf","Doraz","S355JOH","Výpalek ","Plech s=15","Výpalek","Výpalek","l35_x12_f15_002.dxf",1.6,6.4,2,4,"Ks"]
["S-D-1006","S-D-1006","Horní Rám B",null,"Sestava",null,null,null,null,2842,{"$f":"SUM(K67:K76)","v":2838.6000000000004},1,null,"Ks"]
["S-D-1006",35,"Čep Páky","S235JR","Výrobní výkres","TK 30h9",127,{"$f":"L67*G67","v":254},null,0.7,{"$f":"J67*M67","v":1.4},2,{"$f":"$L$66*L67","v":2},"Ks"]
["S-D-1006","Pod. 3516","Bok L",null,"Podsestava","Podsestava","Podsestava","Podsestava",null,2453,{"$f":"J68*M68","v":2453},1,{"$f":"$L$66*L68","v":1},"Ks"]
["S-D-1006","Pod. 3517","BOK P",null,"Podsestava","Podsestava","Podsestava","Podsestava",null,212,212,1,1,"Ks"]
["S-D-1006","Pod. 3517","Páka",null,"Podsestava","Podsestava","Podsestava","Podsestava",null,18.2,36.4,2,2,"Ks"]
["S-D-1006","Pod. 3517","Žebřík",null,"Podsestava","Podsestava","Podsestava","Podsestava",null,30.5,30.5,1,1,"Ks"]
["S-D-1006","Pod. 3517","Závora zábradlí",null,"Podsestava","Podsestava","Podsestava","Podsestava",null,3.8,3.8,1,1,"Ks"]
["S-D-1006","Pod. 3517","Konzola Lávky",null,"Podsestava","Podsestava","Podsestava","Podsestava",null,7.3,36.5,5,5,"Ks"]
["S-D-1006","Pod. 3517","Zábradlí 01 L",null,"Podsestava","Podsestava","Podsestava","Podsestava",null,16,16,1,1,"Ks"]
["S-D-1006","Pod. 3517","Zábradlí 02 L",null,"Podsestava","Podsestava","Podsestava","Podsestava",null,27,27,1,1,"Ks"]
["S-D-1006","Pod. 3517","Záslepka",null,"Podsestava","Podsestava","Podsestava","Podsestava",null,0.5,22,44,44,"Ks"]

{"sheet":"Děleno Hotově+Výrobní výkresy","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Vstupní materiál","Délka","Hmotnost Kg/Ks","Množství celkové","Délka celková","Hmotnost celková"]
["TK 80",34,1.7,22,374,18.7]
["PLO 90x30",230,4.4000000000000004,4,920,17.600000000000001]
["HEB 160",9000,382.70000000000005,18,34480,1470.4]
["Jackl 180x100x6",12940,315.40000000000003,8,22660,552.20000000000005]
["TR 35x5",230,0.9,22,2380,9.4]
["U 120",4940,65.900000000000006,1,4940,65.900000000000006]
["HEB 140",6900,215.2,5,11900,370.70000000000005]
["U 140",2277.5,36.200000000000003,14,10095,160.4]
["TK 30h9",127,0.7,2,254,1.4]
[null,null,null,null,null,{"$f":"SUM(F2:F10)","v":2666.7000000000007}]

{"sheet":"Výpalky","index":3,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Č.Výkresu Pálení","Síla Plechu","Hmotnost Kg/Ks","Množství celkové"]
["l35_x12_f05_001.dxf",{"$f":"IFERROR(MID(A2,10,2)*1,\"Vyřezat\")","v":5},0.7,16]
["l35_x12_f06_001.dxf",6,0.7,4]
["l35_x12_f06_002.dxf",6,4.5,20]
["l35_x12_f06_003.dxf",6,0.4,22]
["l35_x12_f06_004.dxf",6,16.600000000000001,2]
["l35_x12_f06_004a.dxf",6,15.9,2]
["l35_x12_f06_005.dxf",6,0.4,4]
["l35_x12_f08_001.dxf",8,9.3000000000000007,10]
["l35_x12_f10_001.dxf",10,643.9,1]
["l35_x12_f10_002.dxf",10,7.6,18]
["l35_x12_f10_003.dxf",10,8,10]
["l35_x12_f10_004.dxf",10,4.7,12]
["l35_x12_f10_005.dxf",10,10,16]
["l35_x12_f10_006.dxf",10,64.8,1]
["l35_x12_f10_007.dxf",10,14.100000000000001,15]
["l35_x12_f15_001.dxf",15,3.9,4]
["l35_x12_f15_002.dxf",15,4.8000000000000007,10]
["l35_x12_f15_022.dxf",15,64.599999999999994,10]
["l35_x12_f20_001.dxf",20,2.2999999999999998,4]
[null,null,{"$f":"SUM(C2:C20)","v":877.19999999999993}]

{"sheet":"Data pro tabulky Skrýt","index":4,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Data Pro TYP",null,null,null,null,null,"Označení ","Plech"]
["Děleno hotově",null,null,null,null,null,"f02","Plech s=2mm"]
["Nakoupený díl",null,null,null,null,null,"f03","Plech s=3mm"]
["Sestava",null,null,null,null,null,"f04","Plech s=4mm"]
["Výpalek ",null,null,null,null,null,"f05","Plech s=5mm"]
["Výrobní výkres",null,null,null,null,null,"f06","Plech s=6mm"]
["Výrobní výkres+Výpalek",null,null,null,null,null,"f07","Plech s=7mm"]
["Podsestava",null,null,null,null,null,"f08","Plech s=8mm"]
[null,null,null,null,null,null,"f09","Plech s=9mm"]
[null,null,null,null,null,null,"f10","Plech s=10mm"]
[null,null,null,null,null,null,"f11","Plech s=11mm"]
[null,null,null,null,null,null,"f12","Plech s=12mm"]
[null,null,null,null,null,null,"f13","Plech s=13mm"]
[null,null,null,null,null,null,"f14","Plech s=14mm"]
[null,null,null,null,null,null,"f15","Plech s=15mm"]
[null,null,null,null,null,null,"f16","Plech s=16mm"]
[null,null,null,null,null,null,"f17","Plech s=17mm"]
[null,null,null,null,null,null,"f18","Plech s=18mm"]
[null,null,null,null,null,null,"f19","Plech s=19mm"]
[null,null,null,null,null,null,"f20","Plech s=20mm"]
[null,null,null,null,null,null,"f21","Plech s=21mm"]
[null,null,null,null,null,null,"f22","Plech s=22mm"]
[null,null,null,null,null,null,"f23","Plech s=23mm"]
[null,null,null,null,null,null,"f24","Plech s=24mm"]
[null,null,null,null,null,null,"f25","Plech s=25mm"]