{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["MODEL","DATA A VÝPOČTY","VLASTNOSTI LÁTEK","ZAŘÍZENÍ","PROUDY A EKONOMIKA","DALŠÍ INFORMACE","POMOCNÉ TABULKY (pro makra)"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":33,"comments":2,"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":"MODEL","index":0,"n_rows":204,"n_cols":48,"rows_kept":204,"cut":false,"hidden":false,"merged":[[60,44,60,45],[88,43,88,44],[88,35,88,36],[4,15,4,18],[69,14,69,15],[87,8,87,9],[42,8,42,9],[43,8,43,9],[72,24,72,25],[73,24,73,25],[47,25,47,26],[21,16,21,17],[22,16,22,17],[21,23,21,24],[22,23,22,24],[75,46,75,47],[76,46,76,47],[0,35,0,38],[1,35,1,38],[2,35,2,38],[3,35,3,38],[32,17,32,18],[33,17,33,18],[88,17,88,18],[21,32,21,33],[22,32,22,33],[28,25,28,26],[29,25,29,26],[61,25,61,26],[60,25,60,26],[88,26,88,27],[67,29,67,30],[48,25,48,26],[2,15,2,18],[87,43,87,44],[87,35,87,36],[87,26,87,27],[87,17,87,18],[59,44,59,45],[155,20,155,21],[0,29,0,32],[1,29,1,32],[2,29,2,32],[3,29,3,32],[135,30,135,31],[136,30,136,31],[5,6,5,11],[4,29,4,40],[16,7,16,8],[17,7,17,8],[135,11,135,12],[126,11,126,12],[127,11,127,12],[121,20,121,21],[122,20,122,21],[88,8,88,9],[55,9,55,10],[56,9,56,10],[117,7,117,8],[118,7,118,8],[92,21,92,23],[93,21,93,23],[119,10,119,11],[186,38,186,39],[187,38,187,39],[199,11,199,12],[200,11,200,12],[197,26,197,27],[198,26,198,27],[176,38,176,40],[177,38,177,40],[178,38,178,40],[194,29,194,30],[195,29,195,30],[193,38,193,39],[194,38,194,39],[182,16,182,17],[180,20,180,21],[154,20,154,21],[3,11,3,12],[4,11,4,12],[3,6,3,10],[4,6,4,10],[2,22,2,25],[2,26,2,27],[141,5,141,6],[142,5,142,6],[82,4,82,5],[83,4,83,5],[120,10,120,11],[119,18,119,19],[120,18,120,19],[117,15,117,16],[118,15,118,16],[117,25,117,26],[118,25,118,26],[65,11,65,12],[66,11,66,12],[68,14,68,15],[136,11,136,12],[135,14,135,15],[136,14,136,15],[152,41,152,42],[153,41,153,42],[0,6,1,10],[0,11,1,12],[0,13,1,13],[0,15,0,18],[1,26,1,27],[1,22,1,25],[0,22,0,25],[0,26,0,27],[122,42,122,43],[123,42,123,43],[117,34,117,35],[118,34,118,35],[121,28,121,29],[122,28,122,29],[135,23,135,24],[136,23,136,24],[92,5,92,6],[93,5,93,6],[36,14,36,15],[37,14,37,15],[14,11,14,12],[15,11,15,12],[162,28,162,29],[163,28,163,29],[170,31,170,33],[171,31,171,33],[165,21,165,22],[166,21,166,22],[170,18,170,19],[171,18,171,19],[170,21,170,22],[171,21,171,22],[202,19,202,21],[203,19,203,21],[186,7,186,8],[187,7,187,8],[14,26,14,27],[15,26,15,27],[47,41,47,42],[48,41,48,42],[157,25,157,26],[159,25,159,26],[175,13,175,14],[176,13,176,14],[200,19,200,21],[183,16,183,17],[182,23,182,24],[183,23,183,24],[175,27,175,28],[176,27,176,28],[201,19,201,21],[162,38,162,39],[163,38,163,39],[158,25,158,26],[160,13,160,14],[161,13,161,14],[141,12,141,13],[142,12,142,13],[0,47,0,49],[1,47,1,49],[2,47,2,49],[3,47,3,49],[53,19,53,20],[54,19,54,20],[52,19,52,20],[66,29,66,30],[53,32,53,33],[54,32,54,33],[0,42,0,44],[1,42,1,44],[2,42,2,44],[3,42,3,44],[0,45,0,46],[1,45,1,46],[2,45,2,46],[3,45,3,46],[96,46,96,47],[97,46,97,47],[99,46,99,48],[100,46,100,48]]}
["I N S T R U K C E   A   L E G E N D A:",null,null,null,null,null,"požadované mn. BE",null,null,null,null,20,null,"t/den",null,"výstupní teplota BE",null,null,null,25,"°C",null,"odstředivka pro zap",null,null,null,"zapnuto",null,"ods","tepl. stěn. ferm. 301",null,null,null,60,"°C","doba zdržení B-301*",null,null,null,1,"den",null,"spotřeba páry",null,null,{"$f":"C65+L67+F143+H188+Q184+X184+AD196","v":447.49083260926},null,"t/den"]
["zadavatelné/měnitel.:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"teplota teplé vody",null,null,null,50,"°C",null,"odparka pro záparu",null,null,null,"zapnuto",null,{"$f":"IF(ODS=0,IF(odparka=\"zapnuto\",\"!!!\",\"\"),\"\")","v":""},"tepl. stěn. ferm. 302",null,null,null,45,"°C","doba zdržení B-302*",null,null,null,1.5,"den",null,"spotřeba elektřiny",null,null,{"$f":"AA16+AP49+AR89+AJ89+AA89+R89+I89+T204+Z160","v":23062.935589285611},null,"kWh/den"]
["hmotnostní tok",1,"t/den",null,null,null,null,null,null,null,null,null,null,null,null,"tepl. chladné vody",null,null,null,5,"°C",null,null,null,null,null,null,null,null,"tepl. stěn. ferm. 303",null,null,null,45,"°C","doba zdržení B-303*",null,null,null,1,"den",null,"chladící výkon",null,null,{"$f":"U156+AM164+K121+S121+F94","v":47911.198614792593},null,"kWh/den"]
["spotřeba páry",1,"t/den",null,null,null,"hrubých nečistot v sil.",null,null,null,null,5,null,"% hm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tepl. stěn. ferm. 304",null,null,null,40,"°C","doba zdržení B-304*",null,null,null,1.5,"den",null,"výtěžek etanolu",null,null,{"$f":"L1/H18","v":0.1412710566271965},null,"w(et)/w(vstup)"]
["spotřeba elektřiny",1,"kWh/den",null,null,null,"magnet. nečistot",null,null,null,null,3,null,"% hm",null,"poměr vody : klas.",null,null,null,1,{"$f":"\"- w/w\"","v":"- w/w"},null,null,null,null,null,null,null,null,"pož. teplota je v listu \"DATA A VÝPOČTY\""]
["chladící výkon",1,"kWh/den",null,null,null,"(ve vstupující siláži)",null,null,null,null,null,null,null,null,"(poměr promývání v F-103)",null,null,null,null,null,null,null,null,null,null,null,null,null,"* hodnoty se nedoporuřuje měnit (podbarveny žlutě)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"vody",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"drtič (nůž)"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C208","v":141.57181575259588},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C292","v":5502.8964783034016}]
[null,null,null,null,null,null,null,"klasy"]
[null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C205","v":141.57181575259588}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bez hrub. n.",null,null,null,null,null,null,"čist. klasů",null,null,null,null,null,null,null,null,"čist. klasů"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H18-'DATA A VÝPOČTY'!C200/100*'DATA A VÝPOČTY'!C205","v":134.49322496496609},null,null,null,null,null,null,{"$f":"Q23-'DATA A VÝPOČTY'!C201/100*'DATA A VÝPOČTY'!C205","v":130.24607049238821},null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C202","v":130.24607049238821}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mag. nečis."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C201/100*'DATA A VÝPOČTY'!C205","v":4.2471544725778765}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"do WWT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C205*'DATA A VÝPOČTY'!C200/100+'DATA A VÝPOČTY'!C208","v":148.65040654022567}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NT pára"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C218","v":3.9073821147716465}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"20% H2SO4"]
[null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C224","v":6.5123035246194103}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"brýdy z fl.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"el. příkon m."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C261","v":38.730158292780764},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C197","v":4758.09065288081}]
[null,null,"čist. klasů"]
[null,null,{"$f":"AG23","v":130.24607049238821}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"do flash.",null,null,null,null,null,null,null,null,null,null,null,null,"pevná fáze"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O70+L67+C51+C65+I44","v":424.65300909711493},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C248","v":31.143866091583476}]
[null,null,null,null,null,null,null,null,null,"celk z B-202"]
[null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C227","v":147.17805965639869}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"do SEKT. 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z flash na pH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E84","v":389.29832614479346}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C258","v":389.83023291910587}]
[]
[null,null,"páry do 1. r."]
["PÁRA",null,{"$f":"'DATA A VÝPOČTY'!C212","v":13.024607049238822}]
[null,null,null,null,null,null,null,null,null,null,null,"pára do 2. r"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C264","v":39.091957464502464},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kap. fáze"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C250","v":358.68636682752242}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"přívod vody"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C270","v":235.77807056636604}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"vápno"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C253","v":0.37258720838671339}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sádra"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C254","v":0.90449398269912917}]
[]
[]
[]
[]
[]
[null,null,null,null,"přítok z PT"]
[null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C193","v":389.29832614479346}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"el. příkon m.",null,null,null,null,null,null,null,null,"el. příkon m.",null,null,null,null,null,null,null,null,"el. příkon m.",null,null,null,null,null,null,null,null,"el. příkon m.",null,null,null,null,null,null,null,"el. příkon m."]
[null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C167","v":1090.2893345014534},null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C168","v":1635.4340017521797},null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C169","v":1090.2893345014534},null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C170","v":1635.4340017521797},null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C171","v":3168.0000000000005}]
[]
[]
[]
[null,null,null,null,null,"chlad. v.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"celkem odp. CO2"]
[null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!E138","v":8591.4967813241437},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C190","v":19.329565226528882}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"výstup"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C132","v":369.96876091826459}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"obj. průt. [m^3/den]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C133","v":400}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"objem B-301",null,null,null,null,null,null,null,"objem B-302",null,null,null,null,null,null,null,null,null,"objem B-303",null,null,null,null,null,null,null,null,"objem B-304"]
[null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C151","v":344.15698690071122},null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C152","v":516.23548035106683},null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C153","v":344.15698690071122},null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C154","v":516.23548035106683}]
[null,null,null,null,null,null,null,null,null,null,"chlad. v.",null,null,null,null,null,null,null,"chlad. v."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!F138","v":6443.6225859931074},null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!G138","v":3866.1735515958644}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"chladná do 3",null,null,null,null,null,null,null,"chladná do 4"]
[null,null,"chladná do 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!G147","v":59.195001746922337},null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!H147","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"objem K-306"]
[null,null,{"$f":"'DATA A VÝPOČTY'!E147","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C156","v":600}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"chladná do 2"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!F147","v":0}]
[]
[]
[]
[null,null,"přívod reg. v."]
[null,null,{"$f":"C124+L128+U123+AC123+AE137+X137+O137+L137-F143","v":207.04073650911195}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"teplá do 1",null,null,"teplá do 2",null,null,null,null,null,null,null,null,"teplá do 3",null,null,null,null,null,null,"teplá do 4"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!E146","v":73.99375218365293},null,null,{"$f":"'DATA A VÝPOČTY'!F146","v":73.99375218365293},null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!G146","v":0},null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!H146","v":14.798750436730584}]
[]
[]
[]
[]
[null,null,null,null,null,"ostr. pára",null,null,null,null,null,null,"kondenzát"]
[null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C149","v":14.94052004184684},null,null,null,null,null,null,{"$f":"F143","v":14.94052004184684}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99% BE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L1","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"chladící v."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C130","v":23508.615388858754}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ventilator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C8","v":20.863612126672031}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C288","v":149.49629527587925}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"nastřik záp."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C48","v":369.96876091826459}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"brýda",null,null,null,null,null,null,null,null,null,"chlad. výkon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C10","v":0.86361212667203091},null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C17","v":5501.2903070207176}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nástřik rek."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C86","v":49.888960099355202}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kond. záp",null,null,"kond. rek.",null,null,null,null,null,null,null,null,null,"průtok př."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C110","v":49.553003720271086},null,null,{"$f":"'DATA A VÝPOČTY'!C111","v":13.383251365866357},null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C98","v":36.215183246890021}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"záp. do pr.",null,null,null,null,null,null,null,null,null,null,null,null,null,"pára z prač."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C72","v":320.0798008189094},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C106+'DATA A VÝPOČTY'!C108","v":7.7551020408163271},null,null,null,null,null,null,null,null,null,null,"odparka"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"odp. vody"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C124","v":258.6288631872311}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"celk:",{"$f":"S172+V172","v":62.936255086137443}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pára - záp. k",null,null,null,null,null,null,"pára -rek. k"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C75","v":49.553003720271086},null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C103","v":13.383251365866357}]
[]
[]
[null,null,null,null,null,null,null,"pára - prač.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"syrup"]
[null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C108","v":7.1428571428571432},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C123","v":32.352773920868373}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kond."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ost. pára",null,null,null,null,null,null,null,null,{"$f":"AD196","v":310.3546358246773}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C126","v":310.3546358246773}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kapal. f."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C116","v":291.27261874520758}]
[null,null,null,null,null,null,null,null,null,null,null,"pevná fáze"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C117","v":29.098163710809946},null,null,null,null,null,null,null,"odstředivka"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"celk. průtok"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C116+'DATA A VÝPOČTY'!C115","v":320.0798008189094}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA A VÝPOČTY'!C280","v":4033.005490318259}]

{"sheet":"DATA A VÝPOČTY","index":1,"n_rows":315,"n_cols":9,"rows_kept":315,"cut":false,"hidden":false,"merged":[[12,5,12,10],[14,5,14,10],[17,5,17,10],[136,4,136,7],[198,5,198,10],[201,5,201,10],[3,5,3,10],[4,5,4,10],[5,5,5,10],[6,5,6,10],[7,5,7,10],[8,5,8,10],[9,5,9,10],[10,5,10,10],[11,5,11,10],[36,5,36,10],[37,5,37,10],[39,5,39,10],[40,5,40,10],[62,5,62,10],[63,5,63,10],[64,5,64,10],[29,5,29,10],[18,5,18,10],[19,5,19,10],[20,5,20,10],[21,5,21,10],[22,5,22,10],[23,5,23,10],[24,5,24,10],[25,5,25,10],[26,5,26,10],[27,5,27,10],[28,5,28,10],[56,5,56,10],[57,5,57,10],[58,5,58,10],[59,5,59,10],[60,5,60,10],[41,5,41,10],[110,5,110,10],[30,5,30,10],[31,5,31,10],[32,5,32,10],[33,5,33,10],[34,5,34,10],[67,5,67,10],[35,5,35,10],[51,5,51,10],[52,5,52,10],[53,5,53,10],[54,5,54,10],[45,5,45,10],[43,5,43,10],[47,5,47,10],[49,5,49,10],[50,5,50,10],[55,5,55,10],[114,5,114,10],[61,5,61,10],[100,5,100,10],[109,5,109,10],[94,5,94,10],[79,5,79,10],[80,5,80,10],[81,5,81,10],[82,5,82,10],[83,5,83,10],[77,5,77,10],[78,5,78,10],[68,5,68,10],[69,5,69,10],[104,5,104,10],[112,5,112,10],[65,5,65,10],[66,5,66,10],[313,5,313,10],[314,5,314,10],[166,5,166,10],[115,5,115,10],[116,5,116,10],[117,5,117,10],[118,5,118,10],[309,5,309,10],[310,5,310,10],[311,5,311,10],[312,5,312,10],[140,4,140,7],[141,4,141,7],[142,4,142,7],[143,4,143,7],[224,5,224,10],[252,5,252,10],[253,5,253,10],[257,5,257,10],[185,5,185,10],[186,5,186,10],[189,5,189,10],[307,5,307,10],[306,5,306,10],[304,5,304,10],[303,5,303,10],[301,5,301,10],[300,5,300,10],[299,5,299,10],[298,5,298,10],[296,5,296,10],[273,5,273,10],[272,5,272,10],[271,5,271,10],[294,5,294,10],[293,5,293,10],[291,5,291,10],[289,5,289,10],[284,5,284,10],[282,5,282,10],[277,5,277,10],[276,5,276,10],[275,5,275,10]]}
[null,"definovatelné, možné měnit."]
[null,"fyzikálně dané, nedoporučuje se měnit."]
[null,"vypočítané a odkazované, neměnit!"]
[null,null,"hodnota","jednotka","zdroj","komentář"]
["S4","definice vstupních parametrů"]
["be","požadované mn. BE (99%)",{"$f":"MODEL!L1","v":20},"t/den",null,"(volitelné na záložce \"MODEL\")"]
[null,"koncentrace BE na výstupu kolony K-403",{"$f":"'DALŠÍ INFORMACE'!D13","v":0.94902071030584834},"%",null,"azeotrop Eth-W, poč. z tlaku na listu \"DALŠÍ INFORMACE\""]
["be","průtok par na výstupu z kolony K-403",{"$f":"C6*0.99/C7","v":20.863612126672031},"t/den"]
[]
["w","výstup brýdy z mol. sít",{"$f":"C8-C6","v":0.86361212667203091},"t/den"]
[]
[null,"teplota ethanolu na výstupu z procesu",{"$f":"MODEL!T1","v":25},"°C",null,"(volitelné na záložce \"MODEL\")"]
[null,"teplota ethanolu na výstupu z K-403",75,"°C",null,"azeotropická teplota při atm. tlaku (~ zanedbání, pro výp. stačí)"]
[]
["w","potřebný chladící výkon w-406",{"$f":"(C13-C12)*C6*'VLASTNOSTI LÁTEK'!D6+C6*'VLASTNOSTI LÁTEK'!H6","v":19804.645105274583},"MJ/den"]
[null,"výkon chladiče",{"$f":"C15/24/3600*1000","v":229.22042945919657},"kW"]
[null,"spotřeba chlad. výkonu",{"$f":"C16*24","v":5501.2903070207176},"kWh/den"]
[]
[null,"složení vstupu do K-402 (záparové kol.)"]
[null,"ethanol",{"$f":"'DALŠÍ INFORMACE'!C29","v":5.5161855327063136E-2},{"$f":"\"- (w/w)\"","v":"- (w/w)"},null,"převzato z PFD schémat v [0]- viz. list \"DALŠÍ INFORMACE\""]
[null,"voda",{"$f":"'DALŠÍ INFORMACE'!C30","v":0.83287846560050038},{"$f":"\"- (w/w)\"","v":"- (w/w)"}]
[null,"zbylé cukry (gl, xy, ar…)",{"$f":"'DALŠÍ INFORMACE'!C31","v":4.0485357666025798E-3},"- (w/w)"]
[null,"oligomery cukrů",{"$f":"'DALŠÍ INFORMACE'!C32","v":7.7059945326990922E-3},"- (w/w)"]
[null,"škrobový likér",{"$f":"'DALŠÍ INFORMACE'!C33","v":3.2419394530588167E-3},"- (w/w)"]
[null,"další rozpustné látky",{"$f":"'DALŠÍ INFORMACE'!C34","v":2.1289254215049021E-2},"- (w/w)"]
[null,"kyselina octová",{"$f":"'DALŠÍ INFORMACE'!C35","v":1.1683425390118751E-2},"- (w/w)"]
[null,"kys. sírová",{"$f":"'DALŠÍ INFORMACE'!C36","v":3.4219237544280858E-4},"- (w/w)"]
[null,"furfural",{"$f":"'DALŠÍ INFORMACE'!C37","v":1.2798883652925827E-3},"- (w/w)"]
[null,"HMF",{"$f":"'DALŠÍ INFORMACE'!C38","v":1.9998255707696607E-4},"- (w/w)"]
[null,"oxid uhličitý",{"$f":"'DALŠÍ INFORMACE'!C39","v":9.7769250126516745E-4},"- (w/w)"]
[null,"další anorganické látky",{"$f":"'DALŠÍ INFORMACE'!C40","v":9.5013934895678536E-3},"- (w/w)"]
[null,"celuloza",{"$f":"'DALŠÍ INFORMACE'!C41","v":3.0330687823339852E-3},"- (w/w)"]
[null,"xylan",{"$f":"'DALŠÍ INFORMACE'!C42","v":9.7547047285320113E-4},"- (w/w)"]
[null,"arabinan",{"$f":"'DALŠÍ INFORMACE'!C43","v":1.3554373312994367E-4},"- (w/w)"]
[null,"cukerné polymery",{"$f":"'DALŠÍ INFORMACE'!C44","v":2.5797749862928624E-3},"- (w/w)"]
[null,"zymo",{"$f":"'DALŠÍ INFORMACE'!C45","v":2.417566912219323E-3},"- (w/w)"]
[null,"lignin",{"$f":"'DALŠÍ INFORMACE'!C46","v":3.1668348927343562E-2},"- (w/w)"]
[null,"sádra",{"$f":"'DALŠÍ INFORMACE'!C47","v":6.2216795535056113E-5},"- (w/w)"]
[null,"těžké alkoholy",{"$f":"'DALŠÍ INFORMACE'!C48","v":5.5161855327063138E-4},"- (w/w)",null,"v obou zdrojích považují přiboudlinu za zanedbatelnou, volba obsahu na listu \"DALŠÍ INFORMACE\""]
[null,"další nerozpustné látky",{"$f":"'DALŠÍ INFORMACE'!C49","v":1.0265771263284257E-2},"- (w/w)"]
[]
[null,"ztráty ethanolu v přiboudlině (vedl. K-403)",1,"% ze vstup ETH"]
[null,"vstupující ethanol do rektifikační kolony K-403",{"$f":"C6*0.99/(1-C42/100)","v":20},"t/den"]
[null,"ztráty ethanolu ve výpalkách (vedl. K-402)",2,"% ze vstup ETH",null,"toto číslo je poměrně malé (zahrnuje jednostupňové propírání parou v K-421"]
[null,"ethanol ve výpalkách reg. parou (vedl. K-402)",3,"% ze vstup ETH"]
[null,"vstupující ethanol do záparové kolony K-402",{"$f":"C43/(1-(C44)/100)","v":20.408163265306122},"t/den"]
[]
[null,"celkový hm. tok do záparové kolony K-402",{"$f":"C46/C20","v":369.96876091826459},"t/den"]
[]
[null,{"$f":"_xlfn.CONCAT(\"F-402 celkový hm. průtok - \",B20)","v":"F-402 celkový hm. průtok - ethanol"},{"$f":"C$48*C20","v":20.408163265306122},"t/den"]
[null,"F-402 celkový hm. průtok - voda",308.13901391372258,"t/den"]
[null,"F-402 celkový hm. průtok - zbylé cukry (gl, xy, ar…)",1.497831761103233,"t/den"]
[null,"F-402 celkový hm. průtok - oligomery cukrů",2.8509772489056044,"t/den"]
[null,"F-402 celkový hm. průtok - škrobový likér",1.1994163224202068,"t/den"]
[null,"F-402 celkový hm. průtok - další rozpustné látky",7.8763590028156276,"t/den"]
[null,"F-402 celkový hm. průtok - kyselina octová",4.3225024148632265,"t/den"]
[null,"F-402 celkový hm. průtok - kys. sírová",0.12660048913825347,"t/den"]
[null,"F-402 celkový hm. průtok - furfural",0.47351871262100004,"t/den"]
[null,"F-402 celkový hm. průtok - HMF",7.3987298847031258E-2,"t/den"]
[null,"F-402 celkový hm. průtok - oxid uhličitý",0.36171568325215286,"t/den"]
[null,"F-402 celkový hm. průtok - další anorganické látky",3.5152187763322851,"t/den"]
[null,"F-402 celkový hm. průtok - celuloza",1.1221406991799741,"t/den"]
[null,"F-402 celkový hm. průtok - xylan",0.36089360215385247,"t/den"]
[null,"F-402 celkový hm. průtok - arabinan",5.014694699632119E-2,"t/den"]
[null,"F-402 celkový hm. průtok - cukerné polymery",0.95443615512670332,"t/den"]
[null,"F-402 celkový hm. průtok - zymo",0.89442423495077783,"t/den"]
[null,"F-402 celkový hm. průtok - lignin",{"$f":"C$48*C37","v":11.716299812976551},"t/den"]
[null,"F-402 celkový hm. průtok - sádra",2.3018270752409729E-2,"t/den"]
[null,"F-402 celkový hm. průtok - těžké alkoholy",0.20408163265306123,"t/den"]
[null,"F-402 celkový hm. průtok - další nerozpustné látky",3.7980146741476046,"t/den"]
[]
[null,"celkový průtok zápary",{"$f":"'DATA A VÝPOČTY'!C48-'DATA A VÝPOČTY'!C86","v":320.0798008189094},"t/den"]
[null,"potřebné teplo k odpaření přiboudliny, ethanolu a vody",{"$f":"(C88*'VLASTNOSTI LÁTEK'!H6+'DATA A VÝPOČTY'!C89*'VLASTNOSTI LÁTEK'!H4+SUM('DATA A VÝPOČTY'!C90:C94)*'VLASTNOSTI LÁTEK'!H12)","v":84631.015399891519},"MJ/den"]
[null,"koeficient navýšení (bezpečnost, přestup tepla, ohřátí)",1.2]
[null,"spotřeba páry v záparové koloně K-402",{"$f":"C73/'VLASTNOSTI LÁTEK'!M5*C74","v":49.553003720271086},"t/den"]
[]
[null,"složení výstupu ze záparové kolony, nástřik K-403"]
[null,"ethanol",{"$f":"'DALŠÍ INFORMACE'!C54","v":0.39285500257689743},{"$f":"\"- w/w\"","v":"- w/w"},null,"převzato ze zdroje [0], pro orientaci dostačuje - výpočet z průtoků na listu \"DALŠÍ INFORMACE\""]
[null,"voda",{"$f":"'DALŠÍ INFORMACE'!C55","v":0.59112828154901498},{"$f":"\"- w/w\"","v":"- w/w"}]
[null,"škrobový likér",{"$f":"'DALŠÍ INFORMACE'!C58","v":2.317210079064806E-3},"- w/w"]
[null,"kyselina octová",{"$f":"'DALŠÍ INFORMACE'!C60","v":4.1390166239847221E-3},"- w/w"]
[null,"furfural",{"$f":"'DALŠÍ INFORMACE'!C62","v":4.4426510481380419E-3},"- w/w"]
[null,"HMF",{"$f":"'DALŠÍ INFORMACE'!C63","v":6.8717264413645967E-4},"- w/w"]
[null,"oxid uhličitý",{"$f":"'DALŠÍ INFORMACE'!C64","v":4.6344201581296118E-4},"- w/w"]
[]
[null,"celkový hm. tok nástřiku do K-403",{"$f":"C43/C78-C46*0.01*(C45+C44)","v":49.888960099355202},"t/den"]
[null,"průtoky jednotlivých složek kolonou K-403"]
[null,{"$f":"_xlfn.CONCAT(\"F-403 hm. průtok - \",B78)","v":"F-403 hm. průtok - ethanol"},{"$f":"$C$86*C78+C45*0.01*C46","v":20.211372446350104},"t/den",null,"přepočet přes koncentrace - odkaz na listu \"Další informace\""]
[null,{"$f":"_xlfn.CONCAT(\"F-403 hm. průtok - \",B79)","v":"F-403 hm. průtok - voda"},{"$f":"$C$86*C79","v":29.490775251799217},"t/den"]
[null,"F-403 hm. průtok - škrobový likér",0.11560320117628782,"t/den"]
[null,"F-403 hm. průtok - kyselina octová",0.20649123520454168,"t/den"]
[null,"F-403 hm. průtok - furfural",0.22163924087591733,"t/den"]
[null,"F-403 hm. průtok - HMF",3.428232862469225E-2,"t/den"]
[null,"F-403 hm. průtok - oxid uhličitý",2.3120640235257565E-2,"t/den"]
[]
[null,"průtok \"suché\" přiboudliny K-403",{"$f":"SUM(C90:C94)","v":0.6011366461166967},"t/den"]
[null,"obsah vody v příboudlině z nástřiku",{"$f":"C89-(1-C7)*C6","v":28.471189457916182},"t/den"]
[null,"celkový průtok přiboudliny",{"$f":"C97+C96+C108","v":36.215183246890021}]
[]
[null,"teplo potřebné k vypaření ethanolu a vody",{"$f":"C8*C7*'VLASTNOSTI LÁTEK'!H6+'VLASTNOSTI LÁTEK'!H4*'DATA A VÝPOČTY'!C8*(1-'DATA A VÝPOČTY'!C7)","v":19591.803305735542},"MJ/den"]
[null,"teoretický přívod páry do kolony K-403",{"$f":"C100/'VLASTNOSTI LÁTEK'!M5","v":9.5594652613331128},"t/den"]
[null,"koeficient navýšení (bezpečnost, přestup tepla, ohřátí)",1.4]
[null,"přívod páry do kolony K-403",{"$f":"C102*C101","v":13.383251365866357}]
[]
[null,"obsah ethanolu v zápaře",{"$f":"(C45+C44)*0.01*C50","v":1.0204081632653061},"t/den"]
[null,"z toho regenerováno",{"$f":"C105*(C45/(C45+C44))","v":0.61224489795918369},"t/den"]
[null,"přebytek páry nad ethanolem k regeneraci",7,"w(páry)/w(eth)"]
[null,"pára procházející pračkou (k vypírání)",{"$f":"C107*C105","v":7.1428571428571432},"t/den"]
[]
[null,"kondenzát záparové kolony",{"$f":"C75","v":49.553003720271086},"t/den"]
[null,"kondenzát rektifikační kolony",{"$f":"C103","v":13.383251365866357},"t/den"]
[]
[null,"množství vody v sušině z odstředivky",0.01,"w(vody)/w(sušiny)"]
[null,"množství sušiny v zápaře (dle [13])",0.09,"\"- hm.","[13]"]
[null,"množství pevné fáze (vstup)",{"$f":"C72*C114","v":28.807182073701846},"t/den"]
[null,"množství tekuté fáze (vstup)",{"$f":"(C72-C115)*ODS","v":291.27261874520758},"t/den"]
[null,"vystupující pevná fáze",{"$f":"(C115/(1-C113))*ODS","v":29.098163710809946},"t/den"]
[null,"vystupující kapalná fáze",{"$f":"(C116+C115-C117)*ODS","v":290.98163710809945},"t/den"]
[]
[null,"stupeň zahuštění syrupu (poměr vody k bezvodému syr.)",0.3,"w(vody)/w(\"suchy\")"]
[null,"množství bezvodého syrupu",{"$f":"C122*C209*'DALŠÍ INFORMACE'!F84/100","v":24.886749169898746},"t/den"]
[null,"část ligninu rozpuštěná (v poměru k vázané)",0.9,"(-)"]
[null,"množství zahuštěného syrupu",{"$f":"(C121*(1+C120))*ODP","v":32.352773920868373},"t/den"]
[null,"množství odpařené vody",{"$f":"(C118-C123)*ODP","v":258.6288631872311},"t/den"]
[null,"poměr spotřebované páry k odpařené vodě",1.2,"w(pára)/w(odp. v.)"]
[null,"poměr spotřebované páry k odpařené vodě",{"$f":"(C124*C125)*ODP","v":310.3546358246773},"w(pára)/w(odp. v.)"]
[]
[null,"teplo potřebné k zkapalnění eth, přib. a vody v K-412",{"$f":"C73","v":84631.015399891519},"MJ/den","vody:","C130/'VLASTNOSTI LÁTEK'!D4/'DATA A VÝPOČTY'!C131"]
[null,"výkon chladiče",{"$f":"C128/24/3600","v":0.97952564120244812},"MW","el. výkon:","C130/3,6*1000"]
[null,"chladící výkon",{"$f":"C129*24*1000","v":23508.615388858754},"kWh/den"]
["S3"]
[null,"výstup z SEKCE 3 (SSF) - výstup z K-306",{"$f":"C48","v":369.96876091826459},"t/den"]
[null,"přibližný objemový průtok",{"$f":"MROUND(C132/'VLASTNOSTI LÁTEK'!B4*1000*1.08,10)","v":400},"m^3/den"]
[]
[null,null,null,"Regulace fermentorů","fer. 301","fer. 302","fer. 303","fer. 304"]
[null,null,null,"požad. teplota",65,50,41,41,"[13]"]
[null,null,null,"vstupní teplota z PT",85]
[null,null,null,"chlazení (kWh/den)",{"$f":"(E137-E136)*'VLASTNOSTI LÁTEK'!$D$4*$C$132*1000/24/3600*24","v":8591.4967813241437},{"$f":"(E136-F136)*$C$132*'VLASTNOSTI LÁTEK'!$D$4*1000/24/3600*24","v":6443.6225859931074},{"$f":"(F136-G136)*$C$132*'VLASTNOSTI LÁTEK'!$D$4*1000/24/3600*24","v":3866.1735515958644}]
[null,null,null,"teplota souč. (prům.)",{"$f":"MODEL!AH1","v":60},{"$f":"MODEL!AH2","v":45},{"$f":"MODEL!AH3","v":45},{"$f":"MODEL!AH4","v":40}]
[null,null,null,"rozdíl teplot",{"$f":"E139-E136","v":-5},{"$f":"F139-F136","v":-5},{"$f":"G139-G136","v":4},{"$f":"H139-H136","v":-1}]
[null,null,null,"dovolené ohřátí chlad.",25]
[null,null,null,"dovolené ochlazení t.",25]
[null,null,null,"teplota chladící v.",{"$f":"MODEL!T3","v":5}]
[null,null,null,"teplota ohřív. v.",{"$f":"MODEL!T2","v":50}]
[null,null,null,"chlad / ohřev (CH / O)",{"$f":"IF(E140<0,\"O\",\"CH\")","v":"O"},{"$f":"IF(F140<0,\"O\",\"CH\")","v":"O"},{"$f":"IF(G140<0,\"O\",\"CH\")","v":"CH"},{"$f":"IF(H140<0,\"O\",\"CH\")","v":"O"}]
[null,null,null,"spotřeba vody - ohřev",{"$f":"IF(E145=\"O\",-E140*$C$132/$E142,0)","v":73.99375218365293},{"$f":"IF(F145=\"O\",-F140*$C$132/$E142,0)","v":73.99375218365293},{"$f":"IF(G145=\"O\",-G140*$C$132/$E142,0)","v":0},{"$f":"IF(H145=\"O\",-H140*$C$132/$E142,0)","v":14.798750436730584}]
[null,null,null,"spotřeba vody - chlad",{"$f":"IF(E145=\"CH\",E140*$C$132/$E142,0)","v":0},{"$f":"IF(F145=\"CH\",F140*$C$132/$E142,0)","v":0},{"$f":"IF(G145=\"CH\",G140*$C$132/$E142,0)","v":59.195001746922337},{"$f":"IF(H145=\"CH\",H140*$C$132/$E142,0)","v":0}]
[]
[null,"spotřeba páry pro regulaci fermentorů",{"$f":"SUM(E146:H146)*(E144-E143)*'VLASTNOSTI LÁTEK'!D4/('VLASTNOSTI LÁTEK'!M5)","v":14.94052004184684},"t/den"]
[]
[null,"objem fermentoru 1",{"$f":"'DATA A VÝPOČTY'!C$132/'VLASTNOSTI LÁTEK'!B$13*'DATA A VÝPOČTY'!C158*1000","v":344.15698690071122},"m^3"]
[null,"objem fermentoru 2",{"$f":"'DATA A VÝPOČTY'!C$132/'VLASTNOSTI LÁTEK'!B$13*'DATA A VÝPOČTY'!C159*1000","v":516.23548035106683},"m^3"]
[null,"objem fermentoru 3",{"$f":"'DATA A VÝPOČTY'!C$132/'VLASTNOSTI LÁTEK'!B$13*'DATA A VÝPOČTY'!C160*1000","v":344.15698690071122},"m^3"]
[null,"objem fermentoru 4",{"$f":"'DATA A VÝPOČTY'!C$132/'VLASTNOSTI LÁTEK'!B$13*'DATA A VÝPOČTY'!C161*1000","v":516.23548035106683},"m^3"]
[null,"rezerva akumulačního tanku ",0.5,"den"]
[null,"objem akumulačního tanku",{"$f":"C133*(1+C155)","v":600},"m^3"]
[]
[null,"doba zdržení v fermentoru 1 (B-301)",{"$f":"MODEL!$AN1","v":1},"den"]
[null,"doba zdržení v fermentoru 2 (B-302)",{"$f":"MODEL!$AN2","v":1.5},"den"]
[null,"doba zdržení v fermentoru 3 (B-303)",{"$f":"MODEL!$AN3","v":1},"den"]
[null,"doba zdržení v fermentoru 4 (B-304)",{"$f":"MODEL!$AN4","v":1.5},"den"]
[]
[null,"měrný míchací příkon (fermentory)",60,"W/m^3"]
[null,"měrný míchací příkon (akumulační tank)",100,"W/m^3"]
[null,"zvětš. faktor pro míchadla.",2.2000000000000002,"-"]
[]
[null,"výkon motoru fermentoru 1",{"$f":"C$163*C151*24/1000*C165","v":1090.2893345014534},"kW*h/den",null,"(kont. míchání - na straně bezpečnosti)"]
[null,"výkon motoru fermentoru 2",{"$f":"C$163*C152*24/1000*C165","v":1635.4340017521797},"kW*h/den"]
[null,"výkon motoru fermentoru 3",{"$f":"C$163*C153*24/1000*C165","v":1090.2893345014534},"kW*h/den"]
[null,"výkon motoru fermentoru 4",{"$f":"C$163*C154*24/1000*C165","v":1635.4340017521797},"kW*h/den"]
[null,"výkon motoru akumulačního tanku K-306",{"$f":"C164*C156*24/1000*C165","v":3168.0000000000005},"kW*h/den"]
[]
[null,"C6H12O6 ---> 2*C2H5OH + 2*CO2","rovnice kvašení cukrů"]
[null,"tato rovnice je uvedena jako charakteristická rovnice pro kvašení a uvažujeme, že probíha pouze ta - je z ní určen hmotnostní poměr vznikajícího CO2 k ethanol"]
[null,"n(cukry)",1,"mol"]
[null,"n(ethanol)",2,"mol"]
[null,"n(CO2)",2,"mol"]
[]
[null,"m_reakt(cukry)",{"$f":"C175*'VLASTNOSTI LÁTEK'!F15","v":180.12},"kg/reakt"]
[null,"m_reakt(ethanol)",{"$f":"C176*'VLASTNOSTI LÁTEK'!F6","v":92.14},"kg/reakt"]
[null,"m_reakt(CO2)",{"$f":"C177*'VLASTNOSTI LÁTEK'!F14","v":88.12},"kg/reakt"]
[]
[null,"poměr cukru k ethanolu",{"$f":"C179/C180","v":1.9548513132190146},{"$f":"\"- w(cukr)/w(eth)\"","v":"- w(cukr)/w(eth)"}]
[null,"poměr CO2 k ethanolu",{"$f":"C181/C180","v":0.95637074017799006},{"$f":"\"- w(CO2)/w(eth)\"","v":"- w(CO2)/w(eth)"}]
[]
[null,"konverze škrobů a celulozy na ethanol (souhrnná)",{"$f":"'DALŠÍ INFORMACE'!H35","v":0.75366586720908346},{"$f":"\"- w(eth)/w(vstup)\"","v":"- w(eth)/w(vstup)"},null,"z původní hmotnosti přeměněno až na ethanol"]
[null,"konverze škrobů a celulozy na cukry (souhrnná)",{"$f":"'DALŠÍ INFORMACE'!H36","v":0.16059989677889433},{"$f":"\"- w(cukr)/w(vstup)\"","v":"- w(cukr)/w(vstup)"}]
[null,"zbylý škrob a celuloza",{"$f":"'DALŠÍ INFORMACE'!H37","v":8.5734236012022222E-2},{"$f":"\"- w(zbytek)/w(vstup)\"","v":"- w(zbytek)/w(vstup)"}]
[null,"z množství ethanolu určeno"]
[null,"množství CO2",{"$f":"C184*C88","v":19.329565226528882},"t/den",null,"(pozn. - přibližné - vychází ze zjednodušené rovnice)"]
[null,"(pro jednoduchost výpočtu zanedbány ztráty ostatních složek s CO2)"]
[]
[null,"hmota vstupující do fermentorů (vč. CO2)",{"$f":"C190+C132","v":389.29832614479346},"t/den"]
[null,"objem",{"$f":"C193/'VLASTNOSTI LÁTEK'!B16*1000","v":360.46141309703103},"m^3/den"]
[null,"měrný míchací výkon",250,"W/m^3"]
[null,"faktor navýšení pro míchadla",2.2000000000000002,"-"]
[null,"spotřeba energie míchadel",{"$f":"C195*C194/1000*24*C196","v":4758.09065288081},"kWh/den"]
["S1+S2,"]
[null,"všechny složky vstupující do fermentorů (bez vody)",{"$f":"C190+SUM(C52:C70)+C50","v":81.159312231070885},"t/den",null,"z původní hmotnosti přeměněno až na ethanol"]
[null,"pevných nečistot v klasu",{"$f":"MODEL!L4","v":5},"% hm.",null,"volba v modelu"]
[null,"železných (mag. separovatelných) nečistot",{"$f":"MODEL!L5","v":3},"% hm."]
[null,"čistých klasů",{"$f":"C199/(SUM('DALŠÍ INFORMACE'!E82:E86))","v":130.24607049238821},"t/den"]
[null,"vody z klasů",{"$f":"C202*'DALŠÍ INFORMACE'!E81","v":49.086758261317335},"t/den"]
[]
[null,"celkem klasů",{"$f":"C202/(100-C201-C200)*100","v":141.57181575259588},"t/den"]
[]
[null,"poměr promývací vody k klasům",{"$f":"MODEL!T5","v":1},"w/w"]
[null,"množství promývací vody",{"$f":"C207*C205","v":141.57181575259588},"t/den"]
[null,"čistých klasů ",{"$f":"C202","v":130.24607049238821},"t/den"]
[]
[null,"poměr páry k vstup. klasům (1 reaktor PT)",0.1,"w/w"]
[null,"pára do 1. PT reaktoru",{"$f":"C211*C202","v":13.024607049238822},"t/den"]
[null,"doba zdržení v 1. PT",30,"min"]
[null,"koef. navýšení objemu (prodlevy, čerpání)",2,"-"]
[null,"koef. navýšení objemu (šnekový dopravník, hřídel)",2.5,"-"]
[null,"čistý objem reaktoru",{"$f":"C212/24*C213/60*1000*C214*C215/'VLASTNOSTI LÁTEK'!$B$21","v":1.2562313897799791},"m^3"]
[null,"poměr NT páry (recykl) ku vstupu ostré páry",0.3,"-"]
[null,"recykl NT páry",{"$f":"C217*C212","v":3.9073821147716465},"t/den"]
[]
[null,"voda a klasy z 1. PT reaktoru",{"$f":"C212+C209","v":143.27067754162704},"t/den"]
[]
[null,"kys. sírova - koncentrace",10,"% hm."]
[null,"poměr kys. sírové k hmot. vstup do PT sekce",0.5,"% hm"]
[null,{"$f":"_xlfn.CONCAT(\"spotřeba kys. sírové (\",C222,\"%)\")","v":"spotřeba kys. sírové (10%)"},{"$f":"'DATA A VÝPOČTY'!C209*'DATA A VÝPOČTY'!C223/'DATA A VÝPOČTY'!C222","v":6.5123035246194103},"t/den"]
[null,"vstupy do 2. PT reaktoru bez čisté vody",{"$f":"C224+C220","v":149.78298106624644},"t/den",null,"provedené zanedbání - neutralizace vápnem mezi zař. P-215 a P-217 nemění hmotnost (přidání vody, odeb. kys.)"]
[]
[null,"celkem z B-202",{"$f":"C220+C218","v":147.17805965639869},"t/den"]
[]
[null,"H2SO4 + CaO ---> CaSO4 + H2O","rovnice neutralizace"]
[null,"tato rovnice je uvedena jako charakteristická rovnice pro neutralizaci. \"1 reakce\" odpovídá zreagování 1 kmol H2SO4."]
[null,"n(H2SO4)",1,"kmol"]
[null,"n(CaO)",1,"kmol"]
[null,"n(CaSO4)",1,"kmol"]
[null,"n(H2O",1,"kmol"]
[]
[null,"m_r(H2SO4)",{"$f":"C231*'VLASTNOSTI LÁTEK'!F17","v":98.02000000000001},"kg/reakt"]
[null,"m_r(CaO)",{"$f":"C232*'VLASTNOSTI LÁTEK'!F18","v":56.08},"kg/reakt"]
[null,"m_r(CaSO4)",{"$f":"C233*'VLASTNOSTI LÁTEK'!F19","v":136.13999999999999},"kg/reakt"]
[null,"m_r(H2O)",{"$f":"C234*'VLASTNOSTI LÁTEK'!F4","v":18.02},"kg/reakt"]
[]
[null,"poměr vápna k kyselině",{"$f":"C237/C236","v":0.57212813711487442},{"$f":"\"- w/w\"","v":"- w/w"}]
[null,"poměr vzniklé sádry k kyselině",{"$f":"C238/C236","v":1.3889002244439907},{"$f":"\"- w/w\"","v":"- w/w"}]
[null,"poměr vzniklé vody k kyselině",{"$f":"C239/C236","v":0.18384003264639867},{"$f":"\"- w/w\"","v":"- w/w"}]
[]
[null,"čisté kyseliny vstup. do procesu (100%)",{"$f":"C224*C222/100","v":0.65123035246194105},"t/den"]
[]
[null,"množství sušiny ve vstupu na filtry",8,"% původní sušiny","[19]"]
[null,"sušiny na výstupu 2. PT reaktoru",{"$f":"C193*C247/100","v":31.143866091583476},"t/den"]
[null,"celkem na filtry",{"$f":"C258","v":389.83023291910587},"t/den"]
[null,"do neutralizačního reaktoru",{"$f":"C249-C248","v":358.68636682752242},"t/den"]
[null,"% sušiny za homogenizačním tankem",{"$f":"C248/C249*100","v":7.9890843402200096},"% sušiny"]
[]
[null,"spotř. vápna (CaO)",{"$f":"C$245*C241","v":0.37258720838671339},"t/den"]
[null,"vzniklá sádra",{"$f":"C$245*C242","v":0.90449398269912917},"t/den"]
[null,"vzniklá voda",{"$f":"C$245*C243","v":0.11972220925692896},"t/den"]
[null,"celkem zpět do tanku",{"$f":"C253+C250-C254","v":358.15446005321002},"t/den"]
[]
[null,"hm. průtok směsi z flash destilace (K-206)",{"$f":"'DATA A VÝPOČTY'!C193+'DATA A VÝPOČTY'!C254-'DATA A VÝPOČTY'!C253","v":389.83023291910587},"t/den",null,"(pozn. - přibližné - vychází ze zjednodušené rovnice)"]
[]
[null,"poměr hmotnosti brýdy ku výstupu z reaktoru",0.1,"w/w"]
[null,"hm. průtok brýdy z flashe",{"$f":"-C193-C254+C255+C258+C258*C260","v":38.730158292780764},"t/den"]
[]
[null,"poměr páry ku vstupu z PT1. do 2. PT reaktoru",{"$f":"'DALŠÍ INFORMACE'!B96","v":0.26560995270467891},"w/w",null,"(viz. list  \"DALŠÍ INFORMACE\")"]
[null,"páry do 2. PT reaktoru (K-204)",{"$f":"C263*C227","v":39.091957464502464},"t/den"]
[null,"doba zdržení v 2. PT",20,"min","[13]"]
[null,"koef. navýšení objemu (prodlevy, čerpání)",2,"-"]
[null,"koef. navýšení objemu (šnekový dopravník, hřídel)",2.5,"-"]
[null,"čistý objem reaktoru",{"$f":"C264/24*C265/60*1000*C266*C267/'VLASTNOSTI LÁTEK'!$B$21","v":2.5136289521928021},"m^3"]
[]
[null,"přívod vody do 2. PT reaktoru (K-204)",{"$f":"C261+C258-C264-C224-'DATA A VÝPOČTY'!C227","v":235.77807056636604},"t/den"]
["další (nože, příkony)"]
[null,"odstředivka model1",0.14000000000000001,"kWh/kg(suš)","(alfalaval)","0,105 - 0,140"]
[null,"odstředivka model2",7.0000000000000007E-2,"kWh/kg(suš)",null,"0,035 - 0,070"]
[null,"odstředivka model3",0.105,"kWh/kg(suš)",null,"0,070 - 0,105"]
[]
[null,"podle odstředivky model 1 (horní mez)",{"$f":"C272*C$115*1000","v":4033.005490318259},"kWh/den"]
[null,"podle odstředivky model 2 (horní mez)",{"$f":"C273*C$115*1000","v":2016.5027451591295},"kWh/den"]
[null,"podle odstředivky model 3 (horní mez)",{"$f":"C274*C$115*1000","v":3024.7541177386938},"kWh/den"]
[]
[null,"nejvyšší hodnota z model 1-3",{"$f":"MAX(C276:C278)","v":4033.005490318259},"kWh/den",null,"pozn. - hodnota rámcově odpovídá výkonům uvedeným v [13]"]
[null,"zvolená metoda určení příkonu - v závislosti na průtoku ~ dobrý odhad v závislosti na vstupech"]
[]
[null,"tlaková ztráta na mol sítech max.",8,"psi"]
[null,"tlaková ztráta na mol sítech max. v kPa",{"$f":"C283*6.89475729","v":55.158058320000002},"kPa"]
[null," objemový průtok ventilátorem",{"$f":"MODEL!Z159*1000/'VLASTNOSTI LÁTEK'!B7","v":8130.9766784342783},"m^3/den",null,"zanedbání vody (hustota pro čistý ethanol při daných podmínkách)"]
[null,"výkon ventilátoru (dpz*V)",{"$f":"C284*C285","v":448488.8858276378},"kJ/den"]
[null,"bezpečnostní faktor",1.2]
[null,"výkon ventilátoru (dpz*V)",{"$f":"C286/3600*C287","v":149.49629527587925},"kWh/den"]
[]
[null,"měrná spotřeba výkonu na nožovém drtiči",16.899999999999999,"kWh/t","[28]","horní mez dle - jsme na straně bezpečnosti"]
[null,"bezpečnostní faktor",2.5]
[null,"spotřeba nožového drtiče",{"$f":"C291*C290*C202","v":5502.8964783034016},"kWh/den"]
[]
[null,"počet dní (zásobníky)",20,"dní",null,"pro stanovení objemu zásobníků"]
[null,"objem zásobníků",{"$f":"C294*MODEL!H18/'VLASTNOSTI LÁTEK'!B20*1000","v":4044.9090215027395},"m^3",null,"pro stanovení objemu zásobníků"]
[null,"počet zásobníků",3,{"$f":"\"-\"","v":"-"}]
[null,"obj. jednoho zásobníku",{"$f":"MROUND(C295/C296,10)","v":1350},"m^3",null,"pro stanovení objemu zásobníků"]
[]
[null,"filtrovací rychlost",0.4,"m/hod"]
[null,"filtrovací rychlost (denní)",{"$f":"C299*24","v":9.6000000000000014},"m/den"]
[null,"objem (filtrovaný)",{"$f":"MODEL!Z62/'VLASTNOSTI LÁTEK'!B21*1000","v":360.95391936954246},"m^3/den"]
[null,"potřebná plocha",{"$f":"C301/C300","v":37.599366600994003},"m^2"]
[]
[null,"počet dní (akumul. nádrž)",0.5,"dní"]
[null,"objem zásobníků",{"$f":"MODEL!AS61*1000/'VLASTNOSTI LÁTEK'!B21*C304","v":180.23070654851549},"m^3"]
[]
[null,"doba zdržení neutralizační tank",30,"min"]
[null,"objem zásobníků",{"$f":"C305/C304*C307/24/60","v":7.509612772854811},"m^3"]
[]
[null,"spotřeba kvasinek (měřná dle článku)",5,"g/l"]
[null,"spotřeba kvasinek - bezp",{"$f":"C310/1000*MODEL!AU101","v":2},"kg/den",null,"uvažováno \"dvojnásobné\" množství - ve zdroji uvedeno 5 g/l celkem (enz + kvas.)"]
[null,"spotřeba enzymů - bezp",{"$f":"C311","v":2},"kg/den",null,"na straně bezpečnosti a pro lepší výtěžnost je větší množství."]
[null,"koeficient navýšení (kvůli bezpečnosti)",1.2,"-"]
[null,"spotřeba kvasinek - bezp",{"$f":"C$313*C311","v":2.4},"kg/den"]
[null,"spotřeba enzymů - bezp",{"$f":"C$313*C312","v":2.4},"kg/den"]

{"sheet":"VLASTNOSTI LÁTEK","index":2,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,6,4,6],[3,0,4,0],[3,2,4,2],[3,4,4,4],[5,0,6,0]]}
[null,"ρ",null,"cp",null,"M",null,"dH(l-g)",null,null,"dH(l-g)",null,"měrné přiváděné"]
[null,"hustota /20°C",null,"tep. kap. /~20°C",null,"molární hm.",null,"m. skup. výp. tep.",null,null,"m. skup. výp. tep.",null,"teplo parou","přehřátí páry"]
[null,"kg/m^3",null,"kJ/kg*K",null,"kg/kmol",null,"kJ/kg","při tlaku (kPa)",null,"kJ/kmol",null,"kJ/kg",45]
["voda",998,"[8]",4.18,"[7]",18.02,"[7]",2257,101,"[7]"]
[null,null,null,{"$f":"'DALŠÍ INFORMACE'!B136","v":1.9600877142987412},null,null,null,{"$f":"'DALŠÍ INFORMACE'!B19","v":1961.2625},1400,"[7]",null,null,{"$f":"H5+D5*(N3)","v":2049.4664471434435}]
["ethanol",789.3,"[8]",{"$f":"'DALŠÍ INFORMACE'!B125","v":2.4397655741263296},"[7]",46.07,"[7]",{"$f":"'DALŠÍ INFORMACE'!C16","v":868.24397655741268},101,"[7]"]
[null,{"$f":"'DALŠÍ INFORMACE'!B106","v":2.565941700707175},"*",null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"*v plynné formě na mezi sytosti - T=\",'DALŠÍ INFORMACE'!B104,\" K, p=\",'DALŠÍ INFORMACE'!B102,\" bar\")","v":"*v plynné formě na mezi sytosti - T=366,945387343616 K, p=1,7 bar"}]
["HMF",null,null,null,null,126.11,null,{"$f":"K8/F8","v":661.32741257632222},101,null,83400]
["furan",null,null,null,null,68.073999999999998,null,{"$f":"K9/F9","v":407.05702617739519},101,null,27710]
["butanol",null,null,null,null,74.121600000000001,null,{"$f":"K10/F10","v":701.54988559340325},101,null,52000]
["kyselina octová",null,null,null,null,60.052,null,{"$f":"K11/F11","v":859.25531206287883},101,null,51600]
["přiboudlina",null,null,null,null,null,null,{"$f":"H6","v":868.24397655741268},{"$f":"I6","v":101},"**",null,null,null,null,"**kvůli bezpečnosti a nestálosti složení volíme nejhorší možnost (největší výp. teplo)"]
["zfermentovaná směs",1075,"[0]"]
["oxid uhličitý",null,null,null,null,44.06]
["glukoza",null,null,null,null,{"$f":"6*12+12.12+6*16","v":180.12}]
["směs po Pre-treatment",1080]
["kys. sírová ",null,null,null,null,{"$f":"2.02+32+4*16","v":98.02000000000001}]
["vápno (CaO)",null,null,null,null,56.08]
["síran vápenatý (CaSO4)",null,null,null,null,136.13999999999999]
["kukuřičná siláž",700,"[15]"]
["směs v Pre-treatment sekci",{"$f":"B16","v":1080},"***",null,null,null,null,null,null,null,null,null,null,null,"***pro výpočet dostačující zjednodušení = hustota stejná jako v sekci 3 (po PT)"]

{"sheet":"ZAŘÍZENÍ","index":3,"n_rows":84,"n_cols":15,"rows_kept":84,"cut":false,"hidden":false,"merged":[[1,12,1,13],[0,12,0,13],[0,10,1,10],[0,5,1,5],[0,6,1,6],[0,7,1,7],[0,9,1,9],[0,8,1,8],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[67,5,67,7],[63,5,63,7],[76,0,76,9],[77,0,77,9],[78,0,78,9],[68,5,68,7],[69,5,69,7],[73,5,73,7],[71,9,71,10],[72,8,72,10],[73,8,73,10],[69,8,69,10],[67,8,67,10],[61,5,61,7],[61,9,61,10],[64,5,64,7],[65,5,65,7],[66,5,66,7],[62,5,62,7],[63,8,63,10],[62,8,62,10],[65,8,65,10],[82,0,82,2],[83,0,83,2],[80,0,80,2],[81,0,81,2],[71,5,71,7],[72,5,72,7]]}
["sekce","ozn.","zařízení","počet","jednotka","a","b","n","S","cena ($)**","cena (Kč)",null,"celková cena",null,{"$f":"I74","v":232755120.00000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,"kurz",null,23]
[1,"B-101","silo pro uskladnění klasů",{"$f":"'DATA A VÝPOČTY'!C296","v":3},"m^3",5700,700,0.7,{"$f":"'DATA A VÝPOČTY'!C297","v":1350},{"$f":"(F3+G3*(I3^H3))*D3","v":343276.6985869265},{"$f":"ROUNDUP(J3*O$2,-3)","v":7896000}]
[1,"H-102","pásový dopravník",1,"-","-","-","-","-",0,{"$f":"ROUNDUP(J4*O$2,-3)","v":0}]
[1,"F-103","promývací dopravník (šikmý)***",1,"m",22000,350,1,{"$f":"I3/500","v":2.7},{"$f":"(F5+G5*(I5^H5))*D5","v":22945},528000]
[1,"P-104","čerpadlo na vodu",1,"-","-","-","-","-",0,0]
[1,"P-105","čerpadlo na vodu",1,"-","-","-","-","-",0,0]
[1,"H-106","pásový dopravník",1,"-","-","-","-","-",0,0]
[1,"F-107","magnetický odlučovač",1,"-","-","-","-","-",0,0]
[1,"H-108","pásový dopravník",1,"-","-","-","-","-",0,0]
[1,"Z-109","nožový drtič",1,"t/h",600,9950,0.5,{"$f":"MODEL!X23","v":130.24607049238821},{"$f":"(F11+G11*(I11^H11))*D11","v":114154.77354088935},2626000]
[1,"B-110","zásobník nasekaných klasů",1,"m^3",5700,700,0.7,{"$f":"MODEL!AG23*1000/'VLASTNOSTI LÁTEK'!B20","v":186.06581498912601},{"$f":"(F12+G12*(I12^H12))*D12","v":32855.928260155371},756000]
[2,"H-201","šnekový dopravník z zásobníku do reak.",1,"-","-","-","-","-",0,0]
[2,"B-202","1. pre-treatment reaktor",1,"m^3",14000,15400,0.7,{"$f":"'DATA A VÝPOČTY'!C216","v":1.2562313897799791},{"$f":"(F14+G14*(I14^H14))*D14","v":32066.310479866497},738000]
[2,"H-203","šnekový dopravník s těsnícím prvkem",1,"-","-","-","-","-",0,0]
[2,"B-204","2. pre-treatment reaktor",1,"m^3",14000,15400,0.7,{"$f":"'DATA A VÝPOČTY'!C268","v":2.5136289521928021},{"$f":"(F16+G16*(I16^H16))*D16","v":43358.342978428816},998000]
[2,"H-205","šnekový dopravník s těsnícím prvkem",1,"-","-","-","-","-",{"$f":"0.1*J16","v":4335.8342978428818},100000]
[2,"B-206","flash-expanzní nádoba",1,"-","-","-","-","-",{"$f":"J16*1.1","v":47694.177276271701},1097000,"(POZN)"]
[2,"H-207","dopravník",1,"-","-","-","-","-",0,0]
[2,"F-208","tlakový filtr",1,"m^2",-45000,56000,0.4,{"$f":"'DATA A VÝPOČTY'!C302","v":37.599366600994003},{"$f":"(F20+G20*(I20^H20))*D20","v":193924.25393328877},4461000]
[2,"H-209","šnekový dopravník",1,"-","-","-","-","-",0,0]
[2,"B-210","homogenizační a akumulační tank",1,"m^3",5700,700,0.6,{"$f":"'DATA A VÝPOČTY'!C305","v":180.23070654851549},{"$f":"(F22+G22*(I22^H22))*D22","v":21497.752704363411},495000]
[2,"M-211","elektromotor pro pohon míchadla",1,"-","-","-","-","-",0,0]
[2,"B-212","neutralizační reaktor",1,"m^3",5700,700,0.7,{"$f":"'DATA A VÝPOČTY'!C308","v":7.509612772854811},{"$f":"(F24+G24*(I24^H24))*D24","v":8570.9810140218251},198000]
[2,"M-213","elektromotor pro pohon míchadla",1,"-","-","-","-","-",0,0]
[2,"H-214","dopravník na vápno",1,"-","-","-","-","-",0,0]
[2,"P-215","čerpadlo na kapalnou fázi",1,"-","-","-","-","-",0,0]
[2,"F-216","kalolis",1,"m^2",-35000,58000,0.3,{"$f":"I20","v":37.599366600994003},{"$f":"(F28+G28*(I28^H28))*D28","v":137179.7814481605},3156000]
[2,"P-217","čerpadlo na kapalnou fázi",1,"-","-","-","-","-",0,0]
[2,"H-218","dopravník na sádru",1,"-","-","-","-","-",0,0]
[2,"V-219","kompresor na NT páru***",1,"kW",8400,3100,0.6,{"$f":"I51*0.6","v":3.1145061515808177},{"$f":"(F31+G31*(I31^H31))*D31","v":14529.078865408632},335000]
[3,"B-301 - B-304","fermentor*",4,"m^3",10000,1200,0.7,{"$f":"AVERAGE(MODEL!H119,MODEL!P119,MODEL!Z119,MODEL!AI119)","v":430.19623362588902},{"$f":"(F32+G32*(I32^H32))*D32","v":374817.27699590725},8621000]
[3,"B-306","akumulační a homogenizační tank",1,"m^3",5700,700,0.7,{"$f":"MODEL!AQ124","v":600},{"$f":"(F33+G33*(I33^H33))*D33","v":67331.667097925878},1549000]
[3,"B-311 - B-315","elektromotor pro pohon míchadla",5,"-","-","-","-","-",0,0]
[3,"P-321 - P-325","čerpadla pro čerpání kapalné fáze",5,"-","-","-","-","-",0,0]
[3,"P-331 - P334","čerpadla regulačních okruhů",4,"-","-","-","-","-",0,0]
[3,"W-341","kondenzační výměník",1,"m^2",10000,88,1,{"$f":"MODEL!F143*'VLASTNOSTI LÁTEK'!M5/ZAŘÍZENÍ!E82/ZAŘÍZENÍ!E83*1000","v":2041.3396352426171},{"$f":"(F37+G37*(I37^H37))*D37","v":189637.8879013503},4362000]
[3,"P-342, P-343","čerpadla okruhů pro regulaci pH",2,"-","-","-","-","-",0,0]
[3,"P-344","čerpadlo na kondenzát",1,"-","-","-","-","-",0,0]
[4,"P-401","čerpadlo na záparu",1,"-","-","-","-","-",0,0]
[4,"K-402","záparová kolona (klobouková)***",1,"kg (plášť)",-10000,600,0.6,{"$f":"MODEL!N162*500","v":184984.38045913228},{"$f":"(F41+G41*(I41^H41))*D41","v":857825.2578575298},19730000,"vztaženo k hmotnostnímu nástřiku do kolony, poměr vzhledem k odhadům na alibabě"]
[4,"K-403","destilační kolona (kloboučková)*)***",1,"kg (plášť)",-10000,650,0.7,{"$f":"MODEL!V167*800","v":39911.16807948416},{"$f":"(F42+G42*(I42^H42))*D42","v":1070636.0800160945},24625000]
[4,"F-404","molekulová sítá",1,"-","-","-","-","-",{"$f":"0.1*J41","v":85782.52578575298},1973000,"10% ZÁP KOP"]
[4,"B-405","kondenzátor za rektifikační kolonou***",1,"-","-","-","-","-",{"$f":"0.05*J42","v":53531.804000804725},1232000,"5 % ceny destilační kolony"]
[4,"W-406","výměník pro dochlazení",1,"m^2",10000,88,1,{"$f":"MODEL!AM164/ZAŘÍZENÍ!E84/ZAŘÍZENÍ!G82*1000","v":12.734468303288699},{"$f":"(F45+G45*(I45^H45))*D45","v":11120.633210689406},256000]
[4,"P-407","čerpadlo na chladící vodu",1,"-","-","-","-","-",0,0]
[4,"P-408","čerpadlo na chladící vodu",1,"-","-","-","-","-",0,0]
[4,"W-410","utilizační výměník brýdy z flash)***",1,"m^2",10000,88,1,{"$f":"I37*0.45","v":918.60283585917773},{"$f":"(F48+G48*(I48^H48))*D48","v":90837.049555607635},2090000]
[4,"W-411","utilizační výměník (zápara)***",1,"m^2",10000,88,1,{"$f":"I37*0.7","v":1428.9377446698318},{"$f":"(F49+G49*(I49^H49))*D49","v":135746.5215309452},3123000]
[4,"K-412","kondenzátor na páry ze záparové kol.*",1,"-","-","-","-","-",{"$f":"J41*0.1","v":85782.52578575298},1973000,"10 % ceny záparové kolony"]
[4,"V-413","kompresor před molekulovými síty",1,"kW",8400,3100,0.6,{"$f":"'DATA A VÝPOČTY'!C286/3600/24","v":5.1908435859680297},{"$f":"(F51+G51*(I51^H51))*D51","v":16727.304765520672},385000]
[4,"P-414","čerpadlo na záparu",1,"-","-","-","-","-",0,0]
[4,"P-415","čerpadlo pro nástřik do destilační kolony",1,"-","-","-","-","-",0,0]
[4,"B-421","parní pračka na záparu",1,"-","-","-","-","-",{"$f":"J18","v":47694.177276271701},{"$f":"ROUNDUP(J54*O$2,-3)","v":1097000},"předp. cena jako u flash reaktoru v PT sekci"]
[4,"V-422","ventilátor na páru s ethanolem z pračky***",1,"-","-","-","-","-",{"$f":"J51*2","v":33454.609531041344},770000]
[4,"F-431","odstředivka pro separaci sušiny ze zápary",{"$f":"ODS","v":1},"kW",37000,1200,1.2,{"$f":"'DATA A VÝPOČTY'!C280/24","v":168.04189542992745},{"$f":"(F56+G56*(I56^H56))*D56*ODS","v":598930.14658820711},13776000]
[4,"T-432","odparka pro koncentraci syrupu",{"$f":"ODS*ODP","v":1},"m^2",29000,53500,0.6,{"$f":"0.03*MODEL!AM179/24","v":0.32328607898403888},{"$f":"(F57+G57*(I57^H57))*D57*ODP","v":56171.022640456373},1292000]
[4,"B-433","akumulační nádrž na odstředěnou tekutinu",{"$f":"ODS*ODP","v":1},"m^3",5700,700,0.7,{"$f":"MODEL!AA199/12/'VLASTNOSTI LÁTEK'!B4*1000","v":24.321360950668637},{"$f":"(F58+G58*(I58^H58))*D58","v":12235.661505900487},282000,"doba zdržení 2 hodiny, hustota jako voda"]
[4,"P-434","čerpadlo na zředěný syrup",{"$f":"ODS*ODP","v":1},"-","-","-","-","-",0,0]
[null,null,null,null,null,null,null,null,"suma",{"$f":"SUM(J3:J59)","v":4804651.0654313825},{"$f":"SUM(K3:K59)","v":110520000}]
[]
[null,null,null,null,null,"další zařízení tvoří",null,null,30,"% ceny velkých zařízení"]
[null,null,null,null,null,"cena dalších zařízené",null,null,{"$f":"K60*I62/100","v":33156000}]
[null,null,null,null,null,"CELKEM ZA ZAŘÍZENÍ:",null,null,{"$f":"K60+I63","v":143676000}]
[null,null,null,null,null,"vedlejší instalace (kons., reg…)",null,null,30,"% ceny všech zařízení"]
[null,null,null,null,null,"cena instalací",null,null,{"$f":"I65/100*I64","v":43102800}]
[null,null,null,null,null,"projektování",null,null,15,"% ceny všech zařízení"]
[null,null,null,null,null,"cena projektování",null,null,{"$f":"I67/100*I64","v":21551400}]
[null,null,null,null,null,"rezerva",null,null,5,"% ceny všech zařízení"]
[null,null,null,null,null,"rezerva (abs. hodnota)",null,null,{"$f":"I69/100*I64","v":7183800}]
[]
[null,null,null,null,null,"design faktor",null,null,8,"% celkové ceny (CAPEX)"]
[null,null,null,null,null,"CAPEX",null,null,{"$f":"I70+I68+I66+I64","v":215514000}]
[null,null,null,null,null,"VÝSLEDNÝ CAPEX",null,null,{"$f":"I73*(1+I72/100)","v":232755120.00000003}]
[]
["pozn. k výpočtům"]
["* výpočtové konstanty navýšeny kvůli atypičnosti zařízení"]
[{"$f":"_xlfn.CONCAT(\"** 'nulové' ceny představují zařízení, jejichž cena se odvodí z ceny velkých zařízení (\",I62,\" % ceny z velkých zařízení)\")","v":"** 'nulové' ceny představují zařízení, jejichž cena se odvodí z ceny velkých zařízení (30 % ceny z velkých zařízení)"}]
["*** odhad hodnoty S (nebo ceny) na základě porovnání s ostatními určenými (kvůli interaktivnosti vztaženo k jinému zařízení) - (viz kap. 4.4.3 v DP)"]
[]
["• uvažován jednotný součinitel přestupu tepla u výměníků kondenzačních",null,null,"k=",1100,"W/m^2/K =",{"$f":"E81*3600*24/1000","v":95040},"kWh/(m^2*K*den)"]
["• uvažován jednotný součinitel přestupu tepla u výměníků vodních",null,null,"k=",500,"W/m^2/K =",{"$f":"E82*3600*24/1000","v":43200},"kWh/(m^2*K*den)",null,null,"[tep. pr.]"]
["• uvažován jednotný teplotní log. spád pro páru",null,null,"dTln=",30,"K"]
["• uvažován jednotný teplotní log. spád pro vodu",null,null,"dTln=",10,"K"]

{"sheet":"PROUDY A EKONOMIKA","index":4,"n_rows":122,"n_cols":43,"rows_kept":122,"cut":false,"hidden":false,"merged":[[88,2,88,3],[73,2,73,3],[90,2,90,3],[91,2,91,3],[93,2,93,3],[94,2,94,3],[95,2,95,3],[97,2,97,3],[81,2,81,3],[82,2,82,3],[83,2,83,3],[84,2,84,3],[85,2,85,3],[71,0,71,1],[71,2,71,3],[72,2,72,3],[83,0,83,1],[84,0,84,1],[85,0,85,1],[87,0,87,1],[86,0,86,1],[78,0,78,1],[79,0,79,1],[80,0,80,1],[81,0,81,1],[82,0,82,1],[94,0,94,1],[95,0,95,1],[96,0,96,1],[97,0,97,1],[65,2,65,3],[66,2,66,3],[69,2,69,3],[76,2,76,3],[77,2,77,3],[86,2,86,3],[78,2,78,3],[79,2,79,3],[80,2,80,3],[57,2,57,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[64,2,64,3],[26,0,26,10],[27,0,27,10],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[32,0,32,1],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[48,0,48,1],[49,0,49,1],[50,0,50,1],[59,8,65,9],[8,6,8,12],[8,16,8,22],[19,6,19,12],[19,16,19,22],[21,16,21,22],[22,16,22,22],[2,6,2,12],[3,6,3,12],[4,6,4,12],[5,6,5,12],[9,6,9,12],[10,6,10,12],[11,6,11,12],[12,6,12,12],[15,16,15,22],[2,16,2,22],[3,16,3,22],[4,16,4,22],[5,16,5,22],[9,16,9,22],[10,16,10,22],[11,16,11,22],[13,6,13,12],[14,6,14,12],[57,0,57,1],[23,16,23,22],[24,16,24,22],[28,0,28,10],[29,0,29,10],[12,16,12,22],[13,16,13,22],[14,16,14,22],[45,0,45,1],[46,0,46,1],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[16,16,16,22],[20,16,20,22],[22,6,22,12],[23,6,23,12],[24,6,24,12],[15,6,15,12],[16,6,16,12],[20,6,20,12],[52,0,52,1],[53,0,53,1],[55,0,55,1],[56,0,56,1],[54,0,54,1],[51,0,51,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[47,0,47,1],[21,6,21,12],[55,2,55,3],[56,2,56,3],[63,0,63,1],[64,0,64,1],[65,0,65,1],[66,0,66,1],[68,0,68,1],[69,0,69,1],[58,0,58,1],[59,0,59,1],[60,0,60,1],[61,0,61,1],[62,0,62,1],[88,0,88,1],[89,0,89,1],[90,0,90,1],[91,0,91,1],[92,0,92,1],[93,0,93,1],[109,0,109,1],[70,0,70,1],[72,0,72,1],[74,0,74,1],[73,0,73,1],[76,0,76,1],[77,0,77,1],[103,0,103,1],[104,0,104,1],[105,0,105,1],[106,0,106,1],[107,0,107,1],[108,0,108,1],[101,0,101,3],[102,0,102,1],[102,2,102,3],[103,2,103,3],[104,2,104,3],[111,0,111,1],[100,0,100,1],[109,2,109,3],[110,2,110,3],[111,2,111,3],[113,2,113,3],[118,0,118,1],[119,0,119,1],[98,0,98,1],[99,0,99,1],[98,2,98,3],[99,2,99,3],[105,2,105,3],[106,2,106,3],[107,2,107,3],[108,2,108,3],[129,0,129,1],[130,0,130,1],[131,0,131,1],[132,0,132,1],[133,0,133,1],[134,0,134,1],[124,0,124,1],[125,0,125,1],[126,0,126,1],[127,0,127,1],[128,0,128,1],[144,0,144,1],[145,0,145,1],[146,0,146,1],[135,0,135,1],[136,0,136,1],[137,0,137,1],[138,0,138,1],[139,0,139,1],[140,0,140,1],[141,0,141,1],[142,0,142,1],[143,0,143,1],[168,0,168,1],[169,0,169,1],[170,0,170,1],[159,0,159,1],[160,0,160,1],[161,0,161,1],[162,0,162,1],[163,0,163,1],[164,0,164,1],[165,0,165,1],[166,0,166,1],[167,0,167,1],[153,0,153,1],[154,0,154,1],[155,0,155,1],[156,0,156,1],[157,0,157,1],[158,0,158,1],[147,0,147,1],[148,0,148,1],[149,0,149,1],[150,0,150,1],[151,0,151,1],[152,0,152,1],[121,2,123,2],[121,0,123,1],[121,3,123,3],[67,0,67,1],[67,2,67,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[48,2,48,3],[47,2,47,3],[50,2,50,3],[120,0,120,1],[112,0,112,1],[113,0,113,1],[114,0,114,1],[115,0,115,1],[116,0,116,1],[117,0,117,1],[110,0,110,1]]}
[]
[]
["energie - náklady","jedn. mn.","množství","jed. c.","dop. cena.","cena","komentář",null,null,null,null,null,null,"cena hrub.","koef.","cena celk.","komentář"]
["pára","t/den",{"$f":"MODEL!$AT$1","v":447.49083260926},"Kč/t",900,900,"10 - 30 €/t ~ 250 - 900 Kč/t, v roce 2000, uvažována horní hranice",null,null,null,null,null,null,{"$f":"F4*C4","v":402741.74934833398},1,{"$f":"N4*O4","v":402741.74934833398}]
["elektřina","kWh/den",{"$f":"MODEL!$AT$2","v":23062.935589285611},"Kč/kWh",0.84,0.84,null,null,null,null,null,null,null,{"$f":"F5*C5","v":19372.865894999912},1,{"$f":"N5*O5","v":19372.865894999912}]
["chladící výkon","kWh/den",{"$f":"MODEL!$AT$3","v":47911.198614792593},"Kč/kWh",1.2,1.2,"chlazení vodou - přehřátí ch. vody o 5°, cena ",null,null,null,null,null,null,{"$f":"F6*C6","v":57493.438337751111},1,{"$f":"N6*O6","v":57493.438337751111}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"celk.",{"$f":"SUM(P4:P6)","v":479608.05358108506},"Kč/den"]
[]
["suroviny - náklady","jedn. mn.","množství","jed. c.","dop. cena.","cena","komentář",null,null,null,null,null,null,"cena hrub.","koef.","cena celk.","komentář"]
["kukuřičná siláž","t/den",{"$f":"MODEL!H18","v":141.57181575259588},"Kč/t",700,700,null,null,null,null,null,null,null,{"$f":"F10*C10","v":99100.271026817121},1,{"$f":"N10*O10","v":99100.271026817121}]
["voda","t/den",{"$f":"MODEL!L16+MODEL!O70+MODEL!C133","v":584.3906228280739},"Kč/t",70,70,null,null,null,null,null,null,null,40907.343597965169,1,40907.343597965169]
[{"$f":"_xlfn.CONCAT(\"kys. sírová (96%)\")","v":"kys. sírová (96%)"},"t/den",{"$f":"MODEL!I44*'DATA A VÝPOČTY'!C222/96","v":0.67836495048118861},"Kč/t",43000,43000,"cena 96% ---- 400 Kč / 5 l ~ 43,5 Kč / kg ~ 43000 Kč / t",null,null,null,null,null,null,29169.692870691109,1,29169.692870691109]
["vápno","t/den",{"$f":"MODEL!Y74","v":0.37258720838671339},"Kč/t",4000,4000,null,null,null,null,null,null,null,1490.3488335468535,1,1490.3488335468535]
["kvasinky","kg/den",{"$f":"'DATA A VÝPOČTY'!C314","v":2.4},"Kč/kg",4000,4000,null,null,null,null,null,null,null,9600,1,9600]
["enzymy*","kg/den",{"$f":"'DATA A VÝPOČTY'!C315","v":2.4},"Kč/kg",12000,12000,null,null,null,null,null,null,null,28800,1,28800]
[{"$f":"_xlfn.CONCAT(\"kys. sírová (96%)**\")","v":"kys. sírová (96%)**"},"t/den",{"$f":"0.001*MODEL!AU98","v":0.36996876091826458},"Kč/t",43000,43000,"cena 96% ---- 400 Kč / 5 l ~ 43,5 Kč / kg ~ 43000 Kč / t",null,null,null,null,null,null,15908.656719485378,1,15908.656719485378]
["močovina**","t/den",{"$f":"C16","v":0.36996876091826458},"Kč/t",6500,6500,null,null,null,null,null,null,null,2404.7969459687197,1,2404.7969459687197]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"celk.",{"$f":"SUM(P10:P17)","v":227381.10999447436},"Kč/den"]
[]
["výstupy - výnosy","jedn. mn.","množství","jed. c.","dop. cena.","cena","komentář",null,null,null,null,null,null,"cena hrub.","koef.","cena celk.","komentář"]
["ethanol (99%)","t/den",{"$f":"MODEL!L1","v":20},"Kč/t",31000,31000,"~ jako sek pro paliváře (26 tis./m^3)",null,null,null,null,null,null,{"$f":"F21*C21","v":620000},1,{"$f":"N21*O21","v":620000}]
["sádra","t/den",{"$f":"MODEL!AU77","v":0.90449398269912917},"Kč/t",10000,10000,"10 Kč/kg",null,null,null,null,null,null,{"$f":"F22*C22","v":9044.9398269912908},1,{"$f":"N22*O22","v":9044.9398269912908}]
["sušina","t/den",{"$f":"MODEL!L201","v":29.098163710809946},"Kč/t",3000,3000,"krmivo",null,null,null,null,null,null,{"$f":"F23*C23","v":87294.49113242983},1,{"$f":"N23*O23","v":87294.49113242983}]
["ligninový syrup","t/den",{"$f":"MODEL!AM188","v":32.352773920868373},"Kč/t",10000,10000,null,null,null,null,null,null,null,{"$f":"F24*C24","v":323527.73920868372},1,{"$f":"N24*O24","v":323527.73920868372}]
["přiboudlina","t/den",{"$f":"MODEL!AF172","v":36.215183246890021},"Kč/t",0,0,null,null,null,null,null,null,null,{"$f":"F25*C25","v":0},1,{"$f":"N25*O25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"celk.",{"$f":"SUM(P21:P25)","v":1039867.1701681048},"Kč/den"]
["* cena navýšena kvůli  případnému vytvoření enzymů na míru (existuje nabídka)"]
["** u regulačních roztoků uvažováno 0,1 % průtoku hmoty fermentory na regulaci pH ve všech fermentorech",null,null,null,null,null,null,null,null,null,null,null,null,null,"ROI",{"$f":"C122","v":7.9531377366262106},"let"]
["*** průměr z cen dostupných online"]
["**** přiboudlina se spaluje v energetické sekci"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.09]
["fixní kap. investice (CAPEX)",null,{"$f":"ZAŘÍZENÍ!O1","v":232755120.00000003},null,"Kč"]
["oběžný kapitál",null,4,null,"týdnů"]
[]
["provozní náklady na sur. a ener.",null,{"$f":"P7+P18","v":706989.16357555939},null,"Kč/den"]
[]
["náklady na údržbu (% z CAPEX)",null,5,null,"%"]
["náklady na materiál údržby (% z nakl. na udr.)",null,50,null,"%"]
["osobní náklady údržby (% z nákl. na údr.)",null,{"$f":"100-C39","v":50},null,"%"]
[]
["počet zaměstnanců",null,5,null,"lidi"]
["počet směn v provozu",null,3,null,"směny"]
["průměrná hrubá mzda v odvětví",null,19000,null,"Kč/měs"]
[]
["náklady na dozor (% z nákladů na obs.)",null,15,null,"%"]
["náklady na spotřební materiál (% z CAPEX)",null,1,null,"%"]
["náklady na laboratoř (% z nákl. na obsluhu)",null,15,null,"%"]
["rezerva na provozní náklady",null,3,null,"%"]
[]
["firemní režie - zázemí (z nákladů na obsluhu)",null,60,null,"%"]
["pojištění (% z CAPEX)",null,0.7,null,"%"]
[]
["dopravné (% z nákl. na suroviny)",null,1.5,null,"%"]
[]
["doba výstavby",null,2,null,"roky"]
["procento kap. investic v 1. roce",null,30,null,"%"]
["životnost jednotky",null,10,null,"roky"]
[]
["bankovní úvěr",null,{"$f":"ROUNDUP(C74,-6)","v":233000000},null,"-",null,null,{"$f":"C60","v":233000000},"ŘEŠITEL"]
["doba úročení",null,7,null,"roky",null,1,{"$f":"(H60-J$67)*(1+C$62/100)","v":209183852.40447438}]
["úrok bank. úvěru",null,11,null,"%",null,2,182747928.57344094]
["splátka",null,{"$f":"C60*(1+C62/100)^C61*(C62/100)/((1+C62/100)^C61-1)","v":49446157.781872749},null,"Kč/rok",null,3,153404053.12099385]
[null,null,null,null,null,null,4,120832351.36877756]
["průměrná doba odepisování majetku",null,10,null,"roky",null,5,84677762.423817471]
["odpisy první rok",null,5.5,null,"%",null,6,44546168.694911771]
["odpisy další roky",null,{"$f":"(100-C66)/(C65-1)","v":10.5},null,"%",null,7,99.655826440975076,"splatka:",44546078.91488795]
["životnost jednotky",null,20,null,"roky"]
[]
["daň z příjmu",null,19,null,"%"]
[]
["počet dnů v roce",null,300,null,"den"]
["orientačně roční produkce BE",null,{"$f":"C72*C21","v":6000},null,"t/rok"]
["CAPEX",null,{"$f":"ZAŘÍZENÍ!O1","v":232755120.00000003},null,"Kč"]
[]
["roční provozní náklady, provozní výnosy, zisky a daně"]
["výnosy za prodej produktů",null,{"$f":"P26*$C$72","v":311960151.05043143},null,"Kč/rok"]
["náklady na suroviny a energie",null,{"$f":"(P7+P18)*$C$72","v":212096749.07266781},null,"Kč/rok"]
["osobní náklady pracovníků",null,{"$f":"C42*C43*C44*12","v":3420000},null,"Kč/rok"]
["odozor",null,{"$f":"C46/100*C79","v":513000},null,"Kč/rok"]
["údržba",null,{"$f":"C38*ZAŘÍZENÍ!O1/100","v":11637756.000000002},null,"Kč/rok"]
["spotřební materiál",null,{"$f":"C47*ZAŘÍZENÍ!O1/100","v":2327551.2000000002},null,"Kč/rok"]
["laboratoř",null,{"$f":"C79*C48/100","v":513000},null,"Kč/rok"]
["rezerva",null,{"$f":"C49/100*(SUM(C78:D83))","v":6915241.688180034},null,"Kč/rok"]
["pojištění",null,{"$f":"C52/100*ZAŘÍZENÍ!O1","v":1629285.84},null,"Kč/rok"]
["režie firmy",null,{"$f":"C51/100*(C79+C80+C81*C40/100)","v":5851126.7999999998},null,"Kč/rok"]
["náklady na transport",null,{"$f":"C78*C54/100","v":3181451.236090017},null,"Kč/rok"]
[]
["zdanitelné výnosy",null,{"$f":"C77-SUM(C78:D87)","v":63874989.213493586},null,"Kč/rok"]
[]
["odpisy 1. rok",null,{"$f":"C$74*C66/100","v":12801531.600000001},null,"Kč/rok"]
[{"$f":"_xlfn.CONCAT(\"odpisy 2. - \",C65,\". rok\")","v":"odpisy 2. - 10. rok"},null,{"$f":"C$74*C67/100","v":24439287.600000005},null,"Kč/rok"]
[]
[{"$f":"_xlfn.CONCAT(\"zisk před zdaněním 1. rok\")","v":"zisk před zdaněním 1. rok"},null,{"$f":"C$89-C91","v":51073457.613493584},null,"Kč/rok"]
[{"$f":"_xlfn.CONCAT(\"zisk před zdaněním 2. - \",C65,\". rok\")","v":"zisk před zdaněním 2. - 10. rok"},null,{"$f":"C$89-C92","v":39435701.613493577},null,"Kč/rok"]
[{"$f":"_xlfn.CONCAT(\"zisk před zdaněním \",C65+1,\". a další rok\")","v":"zisk před zdaněním 11. a další rok"},null,{"$f":"C$89","v":63874989.213493586},null,"Kč/rok"]
[]
[{"$f":"_xlfn.CONCAT(\"daň z příjmů 1. rok\")","v":"daň z příjmů 1. rok"},null,{"$f":"C94*C$70/100","v":9703956.9465637822},null,"Kč/rok"]
[{"$f":"_xlfn.CONCAT(\"daň z příjmů 2. - \",C65,\". rok\")","v":"daň z příjmů 2. - 10. rok"},null,{"$f":"C95*C$70/100","v":7492783.3065637788},null,"Kč/rok"]
[{"$f":"_xlfn.CONCAT(\"daň z příjmů \",C65+1,\". a další rok\")","v":"daň z příjmů 11. a další rok"},null,{"$f":"C96*C$70/100","v":12136247.950563781},null,"Kč/rok"]
[]
["toky hotovosti v jednotlivých letech",null,null,null,-1,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37]
["toky hotovosti projektu",null,"mil. Kč/rok",null,{"$f":"E106+E109+E110","v":-69.826536000000019},{"$f":"F106+F109+F110","v":-162.928584},{"$f":"G106+G109+G110","v":73.57894616005737},71.367772520057372,71.367772520057372,71.367772520057372,71.367772520057372,71.367772520057372,76.011237164057377,76.011237164057377,76.011237164057377,{"$f":"P106+P109+P110","v":76.011237164057377},76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377]
["výnosy",null,"mil. Kč/rok",null,null,null,{"$f":"$C$77*0.000001","v":311.96015105043142},{"$f":"$C$77*0.000001","v":311.96015105043142},311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142,311.96015105043142]
["náklady (bez odpisů)",null,"mil. Kč/rok",null,null,null,{"$f":"SUM($C$78:$D$87)*0.000001","v":248.08516183693783},248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,{"$f":"SUM($C$78:$D$87)*0.000001","v":248.08516183693783},248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783,248.08516183693783]
["zdanitelné zisky",null,"mil. Kč/rok",null,null,null,{"$f":"G104-G105","v":63.874989213493592},{"$f":"H104-H105","v":63.874989213493592},63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,{"$f":"P104-P105","v":63.874989213493592},63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592]
["odpisy",null,"mil. Kč/rok",null,null,null,{"$f":"C91*0.000001","v":12.801531600000001},{"$f":"$C92*0.000001","v":24.439287600000004},{"$f":"$C92*0.000001","v":24.439287600000004},24.439287600000004,24.439287600000004,24.439287600000004,24.439287600000004,24.439287600000004,24.439287600000004,24.439287600000004]
["zisk před zdaněním",null,"mil. Kč/rok",null,null,null,{"$f":"G106-G107","v":51.073457613493588},{"$f":"H106-H107","v":39.435701613493592},{"$f":"I106-I107","v":39.435701613493592},39.435701613493592,39.435701613493592,39.435701613493592,39.435701613493592,39.435701613493592,39.435701613493592,{"$f":"P106-P107","v":39.435701613493592},63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592,63.874989213493592]
["daň",null,"mil. Kč/rok",null,null,null,{"$f":"C98*0.000001","v":9.7039569465637818},{"$f":"$C99*0.000001","v":7.4927833065637781},{"$f":"$C99*0.000001","v":7.4927833065637781},{"$f":"$C99*0.000001","v":7.4927833065637781},{"$f":"$C99*0.000001","v":7.4927833065637781},{"$f":"$C99*0.000001","v":7.4927833065637781},{"$f":"$C100*0.000001","v":12.13624795056378},{"$f":"$C100*0.000001","v":12.13624795056378},{"$f":"$C100*0.000001","v":12.13624795056378},{"$f":"$C100*0.000001","v":12.13624795056378},12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378,12.13624795056378]
["fixní kap. investice",null,"mil. Kč/rok",null,{"$f":"-C74*C57/100*0.000001","v":-69.826536000000019},{"$f":"-C74*(1-C57/100)*0.000001","v":-162.928584}]
["toky hotovosti cizích zdrojů",null,"mil. Kč/rok",null,{"$f":"E112","v":233},{"$f":"F112","v":0},-49.446157781872749,-49.446157781872749,-49.446157781872749,-49.446157781872749,-49.446157781872749,-49.446157781872749,-49.446157781872749,0,0,{"$f":"P112","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["úvěr",null,"mil. Kč/rok",null,{"$f":"C60*0.000001","v":233},null,{"$f":"-$C$63*0.000001","v":-49.446157781872749},{"$f":"-$C$63*0.000001","v":-49.446157781872749},-49.446157781872749,-49.446157781872749,-49.446157781872749,-49.446157781872749,-49.446157781872749]
[]
["toky vlastních zdrojů",null,"mil. Kč/rok",null,{"$f":"E111+E103","v":163.17346399999997},{"$f":"F111+F103","v":-162.928584},24.132788378184621,21.921614738184623,21.921614738184623,21.921614738184623,21.921614738184623,21.921614738184623,26.565079382184628,76.011237164057377,76.011237164057377,{"$f":"P111+P103","v":76.011237164057377},76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377,76.011237164057377]
[]
[null,null,null,null,{"$f":"SUM($E103:E103)","v":-69.826536000000019},{"$f":"SUM($E103:F103)","v":-232.75512000000003},{"$f":"SUM($E103:G103)","v":-159.17617383994266},{"$f":"SUM($E103:H103)","v":-87.808401319885292},{"$f":"SUM($E103:I103)","v":-16.44062879982792},{"$f":"SUM($E103:J103)","v":54.927143720229452},{"$f":"SUM($E103:K103)","v":126.29491624028682},{"$f":"SUM($E103:L103)","v":197.6626887603442},{"$f":"SUM($E103:M103)","v":273.6739259244016},{"$f":"SUM($E103:N103)","v":349.68516308845898},{"$f":"SUM($E103:O103)","v":425.69640025251636},{"$f":"SUM($E103:P103)","v":501.70763741657373},{"$f":"SUM($E103:Q103)","v":577.71887458063111},{"$f":"SUM($E103:R103)","v":653.73011174468843},{"$f":"SUM($E103:S103)","v":729.74134890874575},{"$f":"SUM($E103:T103)","v":805.75258607280307},{"$f":"SUM($E103:U103)","v":881.76382323686039},{"$f":"SUM($E103:V103)","v":957.77506040091771},{"$f":"SUM($E103:W103)","v":1033.786297564975},{"$f":"SUM($E103:X103)","v":1109.7975347290323},{"$f":"SUM($E103:Y103)","v":1185.8087718930897},{"$f":"SUM($E103:Z103)","v":1261.820009057147},{"$f":"SUM($E103:AA103)","v":1337.8312462212043},{"$f":"SUM($E103:AB103)","v":1413.8424833852616},{"$f":"SUM($E103:AC103)","v":1489.853720549319},{"$f":"SUM($E103:AD103)","v":1565.8649577133763},{"$f":"SUM($E103:AE103)","v":1641.8761948774336},{"$f":"SUM($E103:AF103)","v":1717.8874320414909},{"$f":"SUM($E103:AG103)","v":1793.8986692055482},{"$f":"SUM($E103:AH103)","v":1869.9099063696056},{"$f":"SUM($E103:AI103)","v":1945.9211435336629},{"$f":"SUM($E103:AJ103)","v":2021.9323806977202},{"$f":"SUM($E103:AK103)","v":2097.9436178617775},{"$f":"SUM($E103:AL103)","v":2173.9548550258351},{"$f":"SUM($E103:AM103)","v":2249.9660921898926},{"$f":"SUM($E103:AN103)","v":2325.9773293539502},{"$f":"SUM($E103:AO103)","v":2401.9885665180077},{"$f":"SUM($E103:AP103)","v":2477.9998036820652},{"$f":"SUM($E103:AQ103)","v":2554.0110408461228}]
[null,null,null,null,{"$f":"SUM($E$111:E111)","v":233},{"$f":"SUM($E$111:F111)","v":233},{"$f":"SUM($E$111:G111)","v":183.55384221812724},{"$f":"SUM($E$111:H111)","v":134.10768443625449},{"$f":"SUM($E$111:I111)","v":84.661526654381731},{"$f":"SUM($E$111:J111)","v":35.215368872508982},{"$f":"SUM($E$111:K111)","v":-14.230788909363767},{"$f":"SUM($E$111:L111)","v":-63.676946691236516},{"$f":"SUM($E$111:M111)","v":-113.12310447310927},{"$f":"SUM($E$111:N111)","v":-113.12310447310927},{"$f":"SUM($E$111:O111)","v":-113.12310447310927},{"$f":"SUM($E$111:P111)","v":-113.12310447310927},{"$f":"SUM($E$111:Q111)","v":-113.12310447310927},{"$f":"SUM($E$111:R111)","v":-113.12310447310927},{"$f":"SUM($E$111:S111)","v":-113.12310447310927},{"$f":"SUM($E$111:T111)","v":-113.12310447310927},{"$f":"SUM($E$111:U111)","v":-113.12310447310927},{"$f":"SUM($E$111:V111)","v":-113.12310447310927},{"$f":"SUM($E$111:W111)","v":-113.12310447310927},{"$f":"SUM($E$111:X111)","v":-113.12310447310927},{"$f":"SUM($E$111:Y111)","v":-113.12310447310927},{"$f":"SUM($E$111:Z111)","v":-113.12310447310927},{"$f":"SUM($E$111:AA111)","v":-113.12310447310927},{"$f":"SUM($E$111:AB111)","v":-113.12310447310927},{"$f":"SUM($E$111:AC111)","v":-113.12310447310927},{"$f":"SUM($E$111:AD111)","v":-113.12310447310927},{"$f":"SUM($E$111:AE111)","v":-113.12310447310927},{"$f":"SUM($E$111:AF111)","v":-113.12310447310927},{"$f":"SUM($E$111:AG111)","v":-113.12310447310927},{"$f":"SUM($E$111:AH111)","v":-113.12310447310927},{"$f":"SUM($E$111:AI111)","v":-113.12310447310927},{"$f":"SUM($E$111:AJ111)","v":-113.12310447310927},{"$f":"SUM($E$111:AK111)","v":-113.12310447310927},{"$f":"SUM($E$111:AL111)","v":-113.12310447310927},{"$f":"SUM($E$111:AM111)","v":-113.12310447310927},{"$f":"SUM($E$111:AN111)","v":-113.12310447310927},{"$f":"SUM($E$111:AO111)","v":-113.12310447310927},{"$f":"SUM($E$111:AP111)","v":-113.12310447310927},{"$f":"SUM($E$111:AQ111)","v":-113.12310447310927}]
[null,null,null,null,{"$f":"SUM(E116:E117)","v":163.17346399999997},{"$f":"SUM(F116:F117)","v":0.24487999999996646},24.37766837818458,46.299283116369196,68.220897854553812,90.142512592738427,112.06412733092306,133.98574206910769,160.55082145129234,236.56205861534971,312.57329577940709,{"$f":"SUM(P116:P117)","v":388.58453294346447},464.59577010752184,540.60700727157916,616.61824443563648,692.6294815996938,768.64071876375112,844.65195592780844,920.66319309186576,996.67443025592308,1072.6856674199803,1148.6969045840378,1224.7081417480949,1300.7193789121525,1376.7306160762096,1452.7418532402671,1528.7530904043242,1604.7643275683818,1680.7755647324389,1756.7868018964964,1832.7980390605535,1908.809276224611,1984.8205133886681,2060.8317505527257,2136.8429877167832,2212.8542248808408,2288.8654620448983,2364.8766992089559,2440.8879363730134]
[]
[null,null,null,null,null,{"$f":"F116","v":-232.75512000000003},{"$f":"F120+G114","v":-208.62233162181542},{"$f":"G120+H114","v":-186.7007168836308},-164.77910214544619,-142.85748740726157,-120.93587266907696,-99.014257930892342,-72.449178548707721,3.5620586153496561,79.573295779407033,{"$f":"O120+P114","v":155.58453294346441},231.59577010752179,307.60700727157916,383.61824443563654,459.62948159969392,535.64071876375124,611.65195592780856,687.66319309186588,763.6744302559232,839.68566741998052,915.69690458403784,991.70814174809516,1067.7193789121525,1143.7306160762098,1219.7418532402671,1295.7530904043244,1371.7643275683818,1447.7755647324391,1523.7868018964964,1599.7980390605537,{"$f":"AI120+AJ114","v":1675.809276224611},1751.8205133886684,1827.8317505527257,1903.842987716783,1979.8542248808403,2055.8654620448979,2131.8766992089554,2207.887936373013]
[null,null,null,null,null,null,{"$f":"IF(G120>0,IF(F120<0,F102-F120/(G120-F120),0),0)","v":0},0,0,0,0,0,0,7.9531377366262106,0,0,0,0,{"$f":"IF(S120>0,IF(R120<0,R102-R120/(S120-R120),0),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Doba návratnosti (skutečná)",null,{"$f":"SUM(G121:AQ121)","v":7.9531377366262106},"let"]

{"sheet":"DALŠÍ INFORMACE","index":5,"n_rows":136,"n_cols":15,"rows_kept":136,"cut":false,"hidden":false,"merged":[[39,4,39,6],[108,2,108,3],[109,2,109,3],[110,2,110,3],[111,2,111,3],[52,4,52,7],[62,4,62,7],[63,4,63,7],[64,4,64,7],[65,4,65,7],[66,4,66,7],[67,4,67,7],[68,4,68,7],[69,4,69,7],[61,4,61,7],[70,4,70,7],[71,4,71,7],[116,0,120,0],[112,2,112,3],[72,4,72,7],[73,4,73,7],[74,4,74,7],[53,14,54,14],[79,13,80,14],[79,11,80,12],[79,7,79,8],[79,9,79,10],[53,4,53,7],[54,4,54,7],[55,4,55,7],[56,4,56,7],[57,4,57,7],[58,4,58,7],[59,4,59,7],[60,4,60,7]]}
["definovatelné, možné měnit."]
["fyzikálně dané, nedoporučuje se měnit."]
["vypočítané a odkazované, neměnit!"]
[]
[null,"p (kPa)","zdroj"]
["tlak v záparové koloně (kPa)",180,"[0]","(mění se na kartě model)"]
["tlak v rektifikační koloně (kPa)",200,"[0]","(dopor. hodnoty dle zdroje - 200 kPa, 170 kPa)"]
[]
[null,"c(mol/mol)","p[kPa]","c(w/w)"]
["azeotrop E-W",0.88500000000000001,101.325,{"$f":"B10*'VLASTNOSTI LÁTEK'!$F$6/('DALŠÍ INFORMACE'!B10*'VLASTNOSTI LÁTEK'!$F$6+'VLASTNOSTI LÁTEK'!$F$4*(1-'DALŠÍ INFORMACE'!B10))","v":0.95163178256125391}]
["azeotrop E-W",0.81200000000000006,{"$f":"C10*10","v":1013.25},{"$f":"B11*'VLASTNOSTI LÁTEK'!$F$6/('DALŠÍ INFORMACE'!B11*'VLASTNOSTI LÁTEK'!$F$6+'VLASTNOSTI LÁTEK'!$F$4*(1-'DALŠÍ INFORMACE'!B11))","v":0.9169597466455538},"(data ze zdroje [7])"]
[]
["azeotrope E-W (lin. approx)",null,170,{"$f":"D10-(D10-D11)/(C11-C10)*(C13-C10)","v":0.94902071030584834}]
[]
["výparné teplo mol -> kg","dHlg kJ/mol","dHlg kJ/kg"]
["BE (75°C)",40,{"$f":"B16*1000/'VLASTNOSTI LÁTEK'!F6","v":868.24397655741268}]
[]
["tlak páry",{"$f":"'VLASTNOSTI LÁTEK'!I5/1000","v":1.4}]
["skup. teplo varu",{"$f":"IF(B18<E30,J29,IF(B18<E31,J30,J31))","v":1961.2625}]
[]
[null,null,"A","B","C","log(p)=A-B/(T+C)"]
["teplota varu páry (antoine)","379. - 573.",3.55959,643.74800000000005,-198.04300000000001,"T = B/(A-logp)  -  C"]
["teplota páry",{"$f":"H24+273.15+'VLASTNOSTI LÁTEK'!N3","v":509.77519197838404},"K",null,null,null,null,{"$f":"D22/(C22-LOG10(B18*10))-E22","v":464.77519197838404}]
[null,{"$f":"B23-273.15","v":236.62519197838407},"°C ",null,null,null,null,{"$f":"H23-273.15","v":191.62519197838407}]
[]
[]
["přepočet koncentrací z znalosti průtoků v zápaře dle [13]",null,null,null,"výpočtová tabulka pro prokládání skup. tepla tání"]
[null,"m_mod (kg/h)","c (w/w)",null,"tabulka pro skup. teplo tání",null,null,"dHlg","směrnice"]
["ethanol",24825,{"$f":"B29/B$50","v":5.5161855327063136E-2},null,0.1,417.5,2674.9,{"$f":"G29-F29","v":2257.4},{"$f":"(H30-H29)/(E30-E29)","v":-468.99999999999869},{"$f":"H29+(B18-E29)*I29","v":1647.7000000000019}]
["voda",374828,0.83287846560050038,null,0.3,561.20000000000005,2724.8,{"$f":"G30-F30","v":2163.6000000000004},{"$f":"(H31-H30)/(E31-E30)","v":-245.75000000000162},{"$f":"H30+(B18-E30)*I30","v":1893.2749999999987}]
["zbylé cukry (glukoza, xyloza, arabinoza…)",{"$f":"82+909+217+254+360","v":1822},4.0485357666025798E-3,null,0.7,697.4,2762.7,{"$f":"G31-F31","v":2065.2999999999997},{"$f":"(H32-H31)/(E32-E31)","v":-148.62499999999955},{"$f":"H31+(B18-E31)*I31","v":1961.2625}]
["oligomery cukrů",{"$f":"1853+646+969","v":3468},7.7059945326990922E-3,null,1.5,844.5,2790.9,{"$f":"G32-F32","v":1946.4}]
["škrobový likér",1459,3.2419394530588167E-3]
["další rozpustné látky",9581,2.1289254215049021E-2,null,"PO FERMENTACI"]
["kyselina octová",5258,1.1683425390118751E-2,null,"ethanol",null,{"$f":"B29","v":24825},{"$f":"G35/G38","v":0.75366586720908346}]
["kys. sírová",154,3.4219237544280858E-4,null,"zbylé cukry",null,{"$f":"B31+B32","v":5290},{"$f":"G36/G38","v":0.16059989677889433}]
["furfural",576,1.2798883652925827E-3,null,"škrob a celuloza",null,{"$f":"B33+B41","v":2824},{"$f":"G37/G38","v":8.5734236012022222E-2}]
["HMF",90,1.9998255707696607E-4,null,"celkem před",null,{"$f":"SUM(G35:G37)","v":32939},{"$f":"SUM(H35:H37)","v":1}]
["oxid uhličitý",440,9.7769250126516745E-4]
["další anorganické látky",4276,9.5013934895678536E-3,null,"poměr přiboudliny ku ethanolu",null,null,0.01,"w/w"]
["celuloza",1365,3.0330687823339852E-3]
["xylan",439,9.7547047285320113E-4]
["arabinan",61,1.3554373312994367E-4]
["cukerné polymery",1161,2.5797749862928624E-3]
["zymo",1088,2.417566912219323E-3]
["lignin",14252,3.1668348927343562E-2]
["sádra",28,6.2216795535056113E-5]
["těžší alkoholy (PŘIBOUDLINA)",{"$f":"B29*H40","v":248.25},5.5161855327063138E-4," - pozn.: V obou zdrojích ( [0] a [3] ) považují přiboudlinu za zanedatelnou. Pro představu byla volena jako 1 % hm. z ethanolu."]
["další nerozpustné látky",4620,1.0265771263284257E-2]
["suma",{"$f":"SUM(B29:B49)","v":450039.25},null,{"$f":"C49+C45+C41","v":1.5716406957837565E-2}]
[]
["přepočet koncentrací z znalosti průtoků v nástřiku F-403 e dle [13]",null,null,null,"přepočet koncentrací z znalosti průtoků ve výpalcích dle [13]"]
[null,"m_mod (kg/h)","c (% w/w)",null,null,null,null,null,"m_mod (kg/h)","c (w/w)"]
["ethanol",24583,{"$f":"B54/B$75","v":0.39285500257689743},null,"ethanol",null,null,null,{"$f":"B29-B54","v":242},{"$f":"I54/I$75","v":6.2457415398591866E-4}]
["voda",36990,{"$f":"B55/B$75","v":0.59112828154901498},null,"voda",null,null,null,{"$f":"B30-B55","v":337838},{"$f":"I55/I$75","v":0.87192100427394548}]
["zbylé cukry (glukoza, xyloza, arabinoza…)",0,0,null,"zbylé cukry (glukoza, xyloza, arabinoza…)",null,null,null,1822,4.702372349431173E-3]
["oligomery cukrů",0,0,null,"oligomery cukrů",null,null,null,3468,8.9505089505089504E-3]
["škrobový likér",145,2.317210079064806E-3,null,"škrobový likér",null,null,null,1314,3.3912828030475089E-3,{"$f":"SUM(J56:J58)","v":1.7044164102987633E-2}]
["další rozpustné látky",0,0,null,"další rozpustné látky",null,null,null,9581,2.4727458550987964E-2]
["kyselina octová",259,4.1390166239847221E-3,null,"kyselina octová",null,null,null,4999,1.2901843784196725E-2]
["kys. sírová",0,0,null,"kys. sírová",null,null,null,154,3.9745627980922101E-4]
["furfural",278,4.4426510481380419E-3,null,"furfural",null,null,null,298,7.6910371028018085E-4]
["HMF",43,6.8717264413645967E-4,null,"HMF",null,null,null,47,1.2130159188982719E-4]
["oxid uhličitý",29,4.6344201581296118E-4,null,"oxid uhličitý",null,null,null,411,1.0607437078025313E-3]
["další anorganické látky",0,0,null,"další anorganické látky",null,null,null,4276,1.1035863977040448E-2]
["celuloza",0,0,null,"celuloza",null,null,null,1365,3.5229079346726405E-3]
["xylan",0,0,null,"xylan",null,null,null,439,1.1330084859496625E-3]
["arabinan",0,0,null,"arabinan",null,null,null,61,1.5743398096339272E-4]
["cukerné polymery",0,0,null,"cukerné polymery",null,null,null,1161,2.9964074081721141E-3]
["zymo",0,0,null,"zymo",null,null,null,1088,2.8080028080028079E-3]
["lignin",0,0,null,"lignin",null,null,null,14252,3.6782772076889722E-2]
["sádra",0,0,null,"sádra",null,null,null,28,7.2264778147131093E-5]
["těžší alkoholy (PŘIBOUDLINA)",{"$f":"B48","v":248.25},3.9672234629506073E-3,null,"těžší alkoholy (PŘIBOUDLINA)",null,null,null,0,0]
["další nerozpustné látky",0,0,null,"další nerozpustné látky",null,null,null,4620,1.192368839427663E-2]
["suma",{"$f":"SUM(B54:B74)","v":62575.25},null,null,"suma",null,null,null,{"$f":"SUM(I54:I74)","v":387464}]
[]
["michani!","20 - 60 W/cub.m."]
[]
["složení vstupů ([13],[25])"]
[null,"m_mod (kg/h)","c (% w/w)","dle [3]","průměr","% slož. suš.",null,"siláž dle [13]",null,"siláž dle [25]",null,"sušina dle [13]",null,"sušina dle [25]"]
["voda",45000,{"$f":"B81/B$87","v":0.37375415282392027},0.38,{"$f":"(D81+C81)/2","v":0.37687707641196011},"-",null,{"$f":"B81","v":45000},{"$f":"H81/SUM(H$81:H$86)*100","v":37.375415282392026},{"$f":"D81","v":0.38},0.6]
["celuloza",31000,0.25747508305647843,0.25,0.25373754152823924,{"$f":"E82/SUM(E$82:E$86)*100","v":40.720302836425681},null,31000,25.747508305647841,0.25,{"$f":"J82/SUM(J$81:J$86)*100","v":25},{"$f":"C82","v":0.25747508305647843},{"$f":"L82/SUM(L$82:L$86)*100","v":41.114058355437663},{"$f":"D82","v":0.25},{"$f":"N82/SUM(N$82:N$86)*100","v":40.322580645161281}]
["xylan (hemiceluloza)",17000,0.14119601328903655,0.15,0.14559800664451827,{"$f":"E83/SUM(E$82:E$86)*100","v":23.365856259330346},null,17000,14.119601328903656,0.15,{"$f":"J83/SUM(J$81:J$86)*100","v":15},{"$f":"C83","v":0.14119601328903655},{"$f":"L83/SUM(L$82:L$86)*100","v":22.546419098143236},{"$f":"D83","v":0.15},{"$f":"N83/SUM(N$82:N$86)*100","v":24.193548387096769}]
["lignin",15000,0.12458471760797342,0.14000000000000001,0.13229235880398671,{"$f":"E84/SUM(E$82:E$86)*100","v":21.230539560673918},null,15000,12.458471760797343,0.14000000000000001,{"$f":"J84/SUM(J$81:J$86)*100","v":14.000000000000002},{"$f":"C84","v":0.12458471760797342},{"$f":"L84/SUM(L$82:L$86)*100","v":19.893899204244033},{"$f":"D84","v":0.14000000000000001},{"$f":"N84/SUM(N$82:N$86)*100","v":22.58064516129032}]
["arabinan a další",5000,4.1528239202657809E-2,0.05,4.5764119601328909E-2,{"$f":"E85/SUM(E$82:E$86)*100","v":7.3443164853913414},null,5000,4.1528239202657806,0.05,{"$f":"J85/SUM(J$81:J$86)*100","v":5},{"$f":"C85","v":4.1528239202657809E-2},{"$f":"L85/SUM(L$82:L$86)*100","v":6.6312997347480103},{"$f":"D85","v":0.05},{"$f":"N85/SUM(N$82:N$86)*100","v":8.0645161290322562}]
["další rozpustné látky",7400,6.1461794019933555E-2,0.03,4.5730897009966777E-2,{"$f":"E86/SUM(E$82:E$86)*100","v":7.3389848581787156},null,7400,6.1461794019933551,0.03,{"$f":"J86/SUM(J$81:J$86)*100","v":3},{"$f":"C86","v":6.1461794019933555E-2},{"$f":"L86/SUM(L$82:L$86)*100","v":9.8143236074270543},{"$f":"D86","v":0.03},{"$f":"N86/SUM(N$82:N$86)*100","v":4.8387096774193541}]
["suma",{"$f":"SUM(B81:B86)","v":120400},null,{"$f":"SUM(D81:D86)","v":1},{"$f":"SUM(E81:E86)","v":1},{"$f":"SUM(F82:F86)","v":100.00000000000001}]
[]
["poměr brýd k vystup. směsi (flash K-206) DLE [13]"]
["brýdy z flashe",53.152000000000001]
["směs z flashe",225.71299999999999]
["poměr brýd ku S+L z flashe",{"$f":"B90/B91","v":0.23548488567339942}]
[]
["zrno + voda z PTreaktoru 1",140183]
["pára do PTreaktoru 2",37234]
["poměr páry k vstupu do PT2",{"$f":"B95/B94","v":0.26560995270467891}]
[]
["hustota plynného ethanolu na mezi sytosti"]
["A",4.9253099999999996]
["B",1432.5260000000001]
["C",-61.819000000000003]
["P",1.7,"bar"]
[]
["T",{"$f":"-B101-B100/(LOG10(B102)-B99)","v":366.94538734361618},"K"]
[]
["rho ze stavové rovnice",{"$f":"B102*100000*'VLASTNOSTI LÁTEK'!F6/8.318/'DALŠÍ INFORMACE'!B104/1000","v":2.565941700707175},"kg/m^3"]
[]
["cena chladu"]
["cena říční vody (pro chlazení)",2500,"Kč/1000 m^3"]
["dov. přehřátí vody",50,"°C"]
["teplo odebrané vodou o V = 1000 m^3",{"$f":"B110*1000*'VLASTNOSTI LÁTEK'!B4*'VLASTNOSTI LÁTEK'!D4","v":208582000},"kJ/1000 m^3"]
["teplo odebrané vodou o V = 1000 m^3 [kWh]",{"$f":"B111/3600","v":57939.444444444445},"kWh/1000 m^3"]
["cena chladu [kWh]",{"$f":"B109/B112","v":4.3148497952843486E-2},"Kč/kWh"]
[]
[]
[]
["MURICA",0.25,"$/l"]
[null,{"$f":"B117*1000","v":250},"$/m^3"]
[null,{"$f":"'VLASTNOSTI LÁTEK'!B6","v":789.3},"kg/m^3"]
[null,{"$f":"B118/B119*1000","v":316.73634866337261},"$/t"]
[null,{"$f":"ZAŘÍZENÍ!O2*'DALŠÍ INFORMACE'!B120:B120","v":7284.9360192575696},"Kč/t"]
[]
[]
["cp(eth)",112.4,"J/mol/K"]
["cp(eth)",{"$f":"B124/'VLASTNOSTI LÁTEK'!F6","v":2.4397655741263296},"kJ/kg/K"]
[]
["kapacita páry"]
["Temperature (K)","500. - 1700.","1700. - 6000."]
["A",30.091999999999999,"41.96426"]
["B",6.8325139999999998,"8.622053"]
["C",6.7934349999999997,"-1.499780"]
["D",-2.5344799999999998,"0.098119"]
["E",8.2139000000000004E-2,"-11.15764"]
[]
["Cp",{"$f":"B129+B130*(B23/1000)+B131*(B23/1000)*(B23/1000)+B132*(B23/1000)^3+B133*(B23/1000)^-2","v":35.320780611663317},"kJ/kmol/K"]
["cp",{"$f":"B135/'VLASTNOSTI LÁTEK'!F4","v":1.9600877142987412},"kJ/kg/K"]

{"sheet":"POMOCNÉ TABULKY (pro makra)","index":6,"n_rows":145,"n_cols":9,"rows_kept":145,"cut":false,"hidden":false,"merged":[[6,0,6,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[22,0,22,5],[28,0,28,5],[29,0,29,5],[23,0,23,5],[24,0,24,5],[25,0,25,5],[26,0,26,5],[27,0,27,5]]}
["zapnuto"]
["vypnuto"]
[]
["odparka",{"$f":"IF(odparka=\"zapnuto\",1,0)*ODS","v":1}]
["odstredivka",{"$f":"IF(odstredivka=\"zapnuto\",1,0)","v":1}]
[]
["optimální teplota f1",null,null,null,{"$f":"'DATA A VÝPOČTY'!E136","v":65},"°C"]
["optimální teplota f2",null,null,null,{"$f":"'DATA A VÝPOČTY'!F136","v":50},"°C"]
["optimální teplota f3",null,null,null,{"$f":"'DATA A VÝPOČTY'!G136","v":41},"°C"]
["optimální teplota f4",null,null,null,{"$f":"'DATA A VÝPOČTY'!H136","v":41},"°C"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Toto tu je pouze kvůli potřebám definice barev v DP."]
[]
["Definovatelná hodnota (vstupní hodnota)",null,null,null,null,null,null,0.9,9.2100000000000009]
["Fyzikálně či jinak daná hodnota (bez výpočtu)",null,null,null,null,null,null,0.8,8.4700000000000006]
["Vypočítaná, neměnná hodnota",null,null,null,null,null,null,0.6,7.3]
[null,null,null,null,null,null,null,1.1000000000000001,11.15]
["Obecně neměnná buňka (výpočet), popř. hmotnostní průtok [t/den]",null,null,null,null,null,null,1.3,14.13]
["Spotřeba páry [t/den]",null,null,null,null,null,null,1.7,30.39]
["Spotřeba elektrické energie [kWh/den]",null,null,null,null,null,null,0.3,5.0999999999999996]
["Spotřeba chladící energie [kWh/den]"]
[]
[]
[null,null,"etanol","ROI"]
[null,null,35,4.6500000000000004]
[null,null,31,8.2899999999999991]
[null,null,30,9.3000000000000007]
[null,null,29,10.58]
[null,null,28,12.29]
[null,null,26,18.13]
[null,null,24,34.56]
[null,null,"$Ligninu","ROI"]
[null,null,12,5.23]
[null,null,11,7.03]
[null,null,10,8.2899999999999991]
[null,null,9,10.09]
[null,null,8,12.89]
[null,null,7,17.84]
[null,null,6,28.97]
[null,null,"$siláže","ROI"]
[null,null,0,4.43]
[null,null,0.2,5.7]
[null,null,0.5,7.8]
[null,null,0.7,9.2100000000000009]
[null,null,1,12.61]
[null,null,1.4,24.85]
[null,null,"enzymy","ROI"]
[null,null,35,14.18]
[null,null,25,11.48]
[null,null,12,9.2100000000000009]
[null,null,10,8.93]
[null,null,5,8.32]
[null,null,1,7.88]
[null,null,0,7.78]
[null,null,"elektřina","ROI"]
[null,null,2.4,11.62]
[null,null,1.5,10.09]
[null,null,1,9.41]
[null,null,0.84,9.2100000000000009]
[null,null,0.6,8.92]
[null,null,0,8.2799999999999994]
[null,null,1.9,10.72]
[null,null,"chlad","ROI"]
[null,null,1.2,9.2100000000000009]
[null,null,1,8.68]
[null,null,0.8,8.2100000000000009]
[null,null,1.4,9.8000000000000007]
[null,null,1.6,10.48]
[null,null,3,20.36]
[null,null,3.5,30.68]
[null,null,"pára","ROI"]
[null,null,0.9,9.2100000000000009]
[null,null,0.8,8.4700000000000006]
[null,null,0.6,7.3]
[null,null,1.1000000000000001,11.15]
[null,null,1.3,14.13]
[null,null,1.7,30.39]
[]
[]
[1,"B-101","silo pro uskladnění klasů"]
[1,"H-102","pásový dopravník"]
[1,"F-103","promývací dopravník (šikmý)"]
[1,"P-104","čerpadlo na vodu"]
[1,"P-105","čerpadlo na vodu"]
[1,"H-106","pásový dopravník"]
[1,"F-107","magnetický odlučovač"]
[1,"H-108","pásový dopravník"]
[1,"Z-109","nožový drtič"]
[1,"B-110","zásobník nasekaných klasů"]
[2,"H-201","šnekový dopravník z zásobníku do reak."]
[2,"B-202","1. pre-treatment reaktor"]
[2,"H-203","šnekový dopravník s těsnícím prvkem"]
[2,"B-204","2. pre-treatment reaktor"]
[2,"H-205","šnekový dopravník s těsnícím prvkem"]
[2,"B-206","flash-expanzní nádoba"]
[2,"H-207","dopravník"]
[2,"F-208","tlakový filtr"]
[2,"H-209","šnekový dopravník"]
[2,"B-210","homogenizační a akumulační tank"]
[2,"M-211","elektromotor pro pohon míchadla"]
[2,"B-212","neutralizační reaktor"]
[2,"M-213","elektromotor pro pohon míchadla"]
[2,"H-214","dopravník na vápno"]
[2,"P-215","čerpadlo na kapalnou fázi"]
[2,"F-216","kalolis"]
[2,"P-217","čerpadlo na kapalnou fázi"]
[2,"H-218","dopravník na sádru"]
[2,"V-219","kompresor na NT páru"]
[3,"B-301-4","fermentor"]
[3,"B-306","akumulační a homogenizační tank"]
[3,"B-311-5","elektromotor pro pohon míchadla"]
[3,"P-321-5","čerpadla pro čerpání kapalné fáze"]
[3,"P-331-4","čerpadla regulačních okruhů"]
[3,"W-341","kondenzační výměník"]
[3,"P-342/3","čerpadla okruhů pro regulaci pH"]
[3,"P-344","čerpadlo na kondenzát"]
[4,"P-401","čerpadlo na záparu"]
[4,"K-402","záparová kolona (klobouková)"]
[4,"K-403","destilační kolona (kloboučková)"]
[4,"F-404","molekulová sítá"]
[4,"B-405","kondenzátor za rektifikační kolonou"]
[4,"W-406","výměník pro dochlazení"]
[4,"P-407","čerpadlo na chladící vodu"]
[4,"P-408","čerpadlo na chladící vodu"]
[4,"W-410","utilizační výměník brýdy z flash)"]
[4,"W-411","utilizační výměník (zápara)"]
[4,"K-412","kondenzátor na páry ze záparové kol."]
[4,"V-413","kompresor před molekulovými síty"]
[4,"P-414","čerpadlo na záparu"]
[4,"P-415","čerpadlo pro nástřik do destilační kolony"]
[4,"B-421","parní pračka na záparu"]
[4,"V-422","ventilátor na páru s ethanolem z pračky"]
[4,"F-431","odstředivka pro separaci sušiny ze zápary"]
[4,"T-432","odparka pro koncentraci syrupu"]
[4,"B-433","akumulační nádrž na odstředěnou tekutinu"]
[4,"P-434","čerpadlo na zředěný syrup"]