{"id":132075,"date":"2026-04-30T09:18:30","date_gmt":"2026-04-30T09:18:30","guid":{"rendered":"https:\/\/www.europesays.com\/forums\/132075\/"},"modified":"2026-04-30T09:18:30","modified_gmt":"2026-04-30T09:18:30","slug":"excel-vyzva-problematika-rozuctovani-tepla-korekce","status":"publish","type":"post","link":"https:\/\/www.europesays.com\/forums\/132075\/","title":{"rendered":"Excel v\u00fdzva – problematika roz\u00fa\u010dtov\u00e1n\u00ed tepla – korekce"},"content":{"rendered":"


\n
\n<\/p>\n

\n

Zdrav\u00edm, m\u00e1m tady vcelku velkou v\u00fdzvu s v\u011bt\u0161\u00edm p\u0159esahem.<\/p>\n

\u0158e\u0161\u00edm v r\u00e1mci excelu kontrolu roz\u00fa\u010dtov\u00e1n\u00ed za teplo a teoreticky "free" roz\u00fa\u010dtovac\u00ed n\u00e1stroj m\u00edsto extern\u00edch firem… A zasekl jsem se na posledn\u00ed \u010d\u00e1sti a to je "debiln\u00ed" korekce pro jednotky, kter\u00e9, jsou sv\u00fdmi n\u00e1klady mez limitn\u00edmi hodnotami 70% a 200 % pr\u016fm\u011brn\u00fdch n\u00e1klad\u016f (pravd\u011bpodobn\u011b za pomov\u00ed VBA, makra, maticov\u00e9ho vzorce…), tak aby hodnota pro korekci byla rozd\u011blena spr\u00e1vn\u011b dle bilan\u010dn\u00edch parametr\u016f (jednotky co jsou bl\u00edzko spodn\u00ed hranici 70% dost\u00e1vaj\u00ed m\u00e1lo a z\u00e1rove\u0148 se nesm\u00ed dostat pod hranici 70% a jednotky co jsou pod 200% dost\u00e1vaj\u00ed v\u00edce… Odkaz na excel: https:\/\/docs.google.com\/spreadsheets\/d\/1H20bhDiaQUW2jbY2nEZA6oxNchjQGG7H\/edit?usp=sharing&ouid=101101085083199059547&rtpof=true&sd=true<\/a>
\nKdy ve sloupe\u010dku O – pot\u0159ebuji rozd\u011blit hodnotu z N175, tak, aby hodnoty ve sloupe\u010dku Q nebyly pod 70% a z\u00e1rove\u0148 se rozd\u011blila cel\u00e1 suma v n\u011bkolika d\u00edl\u010d\u00edch p\u0159erozd\u011blen\u00ed (viz vzor v\u00fdsledku na druh\u00e9m list\u011b)
\nD\u00edky moc za z\u00e1jem \ud83d\ude04<\/p>\n<\/div>\n


\n
—
\nStopar-po-galaxii<\/p>\n","protected":false},"excerpt":{"rendered":"Zdrav\u00edm, m\u00e1m tady vcelku velkou v\u00fdzvu s v\u011bt\u0161\u00edm p\u0159esahem. \u0158e\u0161\u00edm v r\u00e1mci excelu kontrolu roz\u00fa\u010dtov\u00e1n\u00ed za teplo a…\n","protected":false},"author":2,"featured_media":132076,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[58,59],"class_list":{"0":"post-132075","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-czech-republic","8":"tag-czech-republic","9":"tag-czechia"},"share_on_mastodon":{"url":"https:\/\/pubeurope.com\/@forums\/116492996794165139","error":""},"_links":{"self":[{"href":"https:\/\/www.europesays.com\/forums\/wp-json\/wp\/v2\/posts\/132075","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.europesays.com\/forums\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.europesays.com\/forums\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.europesays.com\/forums\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.europesays.com\/forums\/wp-json\/wp\/v2\/comments?post=132075"}],"version-history":[{"count":0,"href":"https:\/\/www.europesays.com\/forums\/wp-json\/wp\/v2\/posts\/132075\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.europesays.com\/forums\/wp-json\/wp\/v2\/media\/132076"}],"wp:attachment":[{"href":"https:\/\/www.europesays.com\/forums\/wp-json\/wp\/v2\/media?parent=132075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.europesays.com\/forums\/wp-json\/wp\/v2\/categories?post=132075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.europesays.com\/forums\/wp-json\/wp\/v2\/tags?post=132075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}