<div dir="ltr">Jen pripominam, ze pro maticovy pocet je potreba zadat vzorec s ctrl+shift+enter a slozene zavorky se doplni samy. Kdyz se napisou rucne, tak to tak nefunguje. Ale nejspis to vite.<div>PK</div></div><div class="gmail_extra"><br><div class="gmail_quote">Dne 18. Ĺ™Ăjna 2015 17:38 ZdenÄ›k <span dir="ltr"><<a href="mailto:zdej@atlas.cz" target="_blank">zdej@atlas.cz</a>></span> napsal(a):<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="CS" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="color:#1f497d">Z tĂ© thajštiny jsem pochopil, Ĺľe se pouĹľije: Data – CitlivostnĂ analĂ˝za – Tabulka dat<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d">TĂm se vložà do bunÄ›k </span><span lang="EN-US" style="color:#1f497d">{=TABLE(,J3)}. </span><span lang="DE" style="color:#1f497d">Tohle mi ale v Excelu 2010 nefunguje.<u></u><u></u></span></p><p class="MsoNormal"><span lang="DE" style="color:#1f497d">ZkusĂm nastudovat tu citlivostnĂ analĂ˝zu. </span><span lang="EN-US" style="color:#1f497d">TĹ™eba to pĹŻjde vyĹ™ešit jinak.<u></u><u></u></span></p><span class=""><p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">Z.<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p><div><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Hw-list [mailto:<a href="mailto:hw-list-bounces@list.hw.cz" target="_blank">hw-list-bounces@list.hw.cz</a>] <b>On Behalf Of </b>Ĺ erĂ˝ch Jakub<br><b>Sent:</b> Sunday, October 18, 2015 5:18 PM<br><b>To:</b> HW-news<br><b>Subject:</b> RE: FIFO v Excelu<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p></span><p class="MsoNormal"><span style="color:#1f497d">V ThajštinÄ› je to vysvÄ›tlenĂ© v odkazu part III na tĂ© stránce. Asi si podobnÄ› jako já moc nepoÄŤtete, ale jsou tam aspoĹ obrázky z čeho se která buĹka poÄŤĂtá. A moĹľná Google translator by pomohl to vysvÄ›tlit vĂce.<u></u><u></u></span></p><div><div class="h5"><p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:#1f497d">Jakub Ĺ erĂ˝ch<u></u><u></u></span></p><p class="MsoNormal"><a name="1507b9ab199266fd__MailEndCompose"></a><span style="color:#1f497d"><u></u> <u></u></span></p><div style="border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt"><div><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Hw-list [<a href="mailto:hw-list-bounces@list.hw.cz" target="_blank">mailto:hw-list-bounces@list.hw.cz</a>] <b>On Behalf Of </b>ZdenÄ›k<br><b>Sent:</b> Sunday, October 18, 2015 4:57 PM<br><b>To:</b> 'HW-news'<br><b>Subject:</b> OT: FIFO v Excelu<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">ZdravĂm. Snad mi nÄ›kdo chytĹ™ejšà poradĂ:<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">ZkoušĂm FIFO (napĹ™. evidence zásob na skladu). Inspiroval jsem zde:<u></u><u></u></p><p class="MsoNormal"><a href="https://gallery.technet.microsoft.com/office/FIFO-Costing-with-Excel-94967012" target="_blank">https://gallery.technet.microsoft.com/office/FIFO-Costing-with-Excel-94967012</a><u></u><u></u></p><p class="MsoNormal">Je tam ke staĹľenĂ XLS s celkem dobĹ™e pochopitelnĂ˝m Ĺ™ešenĂm. Je pro mne ale záhadou vzorec ve sloupci Q:<u></u><u></u></p><p class="MsoNormal">{=TABULKA(;J3)}<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">„TABULKA“ nenĂ ani název funkce, ani žádnĂ©ho pole, ani niÄŤeho dalšĂho uĹľivatelsky definovanĂ©ho (autor by jistÄ› nepouĹľil ÄŤeštinu). <u></u><u></u></p><p class="MsoNormal">Snaha o vloĹľenĂ stejnĂ©ho (maticovĂ©ho) vzorce nebo jeho editace konÄŤĂ chybou. PĹ™itom ten pĹŻvodnĂ vzorec nÄ›jakĂ© hodnoty vracĂ.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Co to mĹŻĹľe bĂ˝t?<u></u><u></u></p><p class="MsoNormal">Z.<u></u><u></u></p></div></div></div></div></div><br>_______________________________________________<br>
HW-list mailing list - sponsored by <a href="http://www.HW.cz" rel="noreferrer" target="_blank">www.HW.cz</a><br>
<a href="mailto:Hw-list@list.hw.cz">Hw-list@list.hw.cz</a><br>
<a href="http://list.hw.cz/mailman/listinfo/hw-list" rel="noreferrer" target="_blank">http://list.hw.cz/mailman/listinfo/hw-list</a><br>
<br></blockquote></div><br></div>