{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Kalkulátor","Evidence nabídek","Stroje","Materiály","Povrchové úpravy","Zákazníci"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Kalkulátor","index":0,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,2],[8,5,8,6],[10,5,10,6]]}
[]
[null,"Datum:",{"$f":"TODAY()","v":"2017-12-07"}]
[null,"ZÁKLADNÍ ÚDAJE",null,null,"Cenový rozpad","Počet jednotek","Jednotka","Cena"]
[null,"Číslo dílce",null,null,"Výrobní čas vč. nahození",{"$f":"IFERROR(C13+(2700/C12)+C14,0)","v":0},"[s]",{"$f":"IFERROR(F4*VLOOKUP(C7,Stroje!A4:B14,2,FALSE),0)","v":0},"Kč"]
[null,"Název dílce",null,null,"Dokončovací čas",{"$f":"C14","v":0},"[s]",{"$f":"F5*0.14","v":0},"Kč"]
[null,"Zákazník",null,null,"Materiál",{"$f":"((PI()*(C9/2)^2)*C10)/1000000","v":0},"[m³]",{"$f":"IFERROR(HLOOKUP(C8,Materiály!A3:E29,MATCH(Kalkulátor!C9,Materiály!A3:A29,0),FALSE)*(C10+7)/1000,0)","v":0},"Kč"]
[null,"Stroj",null,null,"Povrchová úprava",{"$f":"IF(C11>0,'Povrchové úpravy'!B4,0)","v":0},"[kg]",{"$f":"IF(IF(C11>0,IF(C11='Povrchové úpravy'!A7,'Povrchové úpravy'!B7*'Povrchové úpravy'!B4,IF(Kalkulátor!C11='Povrchové úpravy'!A8,'Povrchové úpravy'!B8*'Povrchové úpravy'!B4,IF(Kalkulátor!C11='Povrchové úpravy'!A9,'Povrchové úpravy'!B9*'Povrchové úpravy'!B4,0))))=FALSE,0,IF(C11>0,IF(C11='Povrchové úpravy'!A7,'Povrchové úpravy'!B7*'Povrchové úpravy'!B4,IF(Kalkulátor!C11='Povrchové úpravy'!A8,'Povrchové úpravy'!B8*'Povrchové úpravy'!B4,IF(Kalkulátor!C11='Povrchové úpravy'!A9,'Povrchové úpravy'!B9*'Povrchové úpravy'!B4,0)))))","v":0},"Kč"]
[null,"Jakost materiálu",null,null,"Kooperace",{"$f":"C15","v":0},"[kč]",{"$f":"F8","v":0},"Kč"]
[null,"Průměr",null,null,null,"CELKOVÁ CENA:   ",null,{"$f":"SUM(H4:H8)","v":0},"Kč"]
[null,"Délka kusu"]
[null,"Povrchová úprava",null,null,null,"NABÍDNUTÁ CENA",null,null,"Kč"]
[null,"Dávka"]
[null,"Čas výroby jednoho kusu [s]"]
[null,"Čas dokončování jednoho kusu [s]"]
[null,"Cena kooperací na jeden kus"]
[null,null,null,null,{"$f":"AND(IF(C6=0,0,1),IF(C4=0,0,1),IF(C5=0,0,1),IF(C12=0,0,1),IF(C13=0,0,1),IF(H6=0,0,1),IF(H9=0,0,1),IF(H11=0,0,1))","v":false}]

{"sheet":"Evidence nabídek","index":1,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["EVIDENCE NABÍDEK 2018"]
["Zákazník","Číslo dílu","Název dílu","Dávka","Kalkulovaný čas","Cena materiálu","Cena kalkulace za kus","Cena nabízená za kus","Datum nabídky"]

{"sheet":"Stroje","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Seznam strojů"]
[]
["Stroj","Sekundová  sazba (Kč/s)"]
["A42",0.21]
["A26 - I",0.18]
["A26 - II",0.18]
["A52",0.22]
["Pilka velá",0.1]
["Pilka malá",0.1]
["Frézka",0.13]
["Soustruh",0.13]
["Závitořez",0.1]
["Svářečka",0.1]
["Leštička",0.05]

{"sheet":"Materiály","index":3,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Ceny za metr 11/2017"]
["Hustota (kg/m³)",8000,8000,7850,7850,2800,8800,8500,1150]
[null,"1.4301","1.4305",11373,11523,"Dural","Bronz","Mosaz","PA"]
[4,30,32,5,5]
[5,40,42,6,6]
[6,50,53,8,8]
[8,60,64,13,13]
[10,75,80,17,17]
[12,86,91,28,28]
[14,107,113,34,34]
[15,120,127,38,38]
[16,138,146,42,42]
[18,218,231,53,53]
[20,235,249,66,66]
[22,248,263,78,78]
[24,282,299,91,91]
[25,303,321,99,99]
[26,321,340,102,102]
[28,420,445,142,142]
[30,535,567,161,161]
[32,580,615,170,170]
[34,620,657,176,176]
[35,680,721,196,196]
[36,880,933,213,213]
[38,930,986,232,232]
[40,1040,1102,246,246]
[42,1250,1325,262,262]
[45,1400,1484,312,312]
[50,1550,1643,384,384]
[55]
[60]
[65]
[70]
[75]
[80]
[100]
[110]
[120]
[130]

{"sheet":"Povrchové úpravy","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Povrchové úpravy"]
[]
[]
["Váha kusu:",{"$f":"(PI()*((Kalkulátor!C9/1000)/2)^2)*(Kalkulátor!C10/1000)*IF(Kalkulátor!C8=Materiály!B3,Materiály!B2,(IF(Kalkulátor!C8=Materiály!C3,Materiály!C2,IF(Kalkulátor!C8=Materiály!D3,Materiály!D2,IF(Kalkulátor!C8=Materiály!E3,Materiály!E2,IF(Kalkulátor!C8=Materiály!F3,Materiály!F2,IF(Kalkulátor!C8=Materiály!G3,Materiály!G2,IF(Kalkulátor!C8=Materiály!H3,Materiály!H2,IF(Kalkulátor!C8=Materiály!I3,Materiály!I2,0)))))))))","v":0},"kg"]
[]
[null,"Cena za kg"]
["Zinek",10,"Kč"]
["Zinek černý",15,"Kč"]
["Elox",20,"Kč"]

{"sheet":"Zákazníci","index":5,"n_rows":501,"n_cols":3,"rows_kept":501,"cut":false,"hidden":false,"merged":[]}
["Délky kusů","Dávky","Zákazníci"]
[1,5,"Axis"]
[2,10,"Borcad"]
[3,20,"Linet"]
[4,50,"Romotop"]
[5,100,"Teckon"]
[6,200,"Urbánek"]
[7,500,"Haas Sohn"]
[8,1000,"Mesit"]
[9,5000,"Jamibo"]
[10,10000,"Jemelka"]
[11,null,"Morino"]
[12,null,"SKD"]
[13,null,"Krokov"]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[450]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]