[B! excel] Xenosã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Xenos id:Xenos

excelã«é–¢ã™ã‚‹Xenosã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (32)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ã€ExcelVBAã€‘ä¸€å›žã ã‘æ›²ãŒã‚‹Lå—çŸ¢å°ã‚³ãƒã‚¯ã‚¿ã‚’æŒ¿å…¥ã™ã‚‹ãƒžã‚¯ãƒ - å’Œé¢¨ã‚¹ãƒ‘ã‚²ãƒ†ã‚£ã®ãƒ¬ã‚·ãƒ”
ãƒ•ãƒãƒ¼ãƒãƒ£ãƒ¼ãƒˆã‚„ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚’ä½œã£ã¦ã„ã‚‹éš›ã€ æŠ˜ã‚Œç·šçŸ¢å°ï¼ˆæ£å¼åç§°ï¼šã‚«ã‚®ç·šçŸ¢å°ã‚³ãƒã‚¯ã‚¿ï¼‰ã‚’ã‚ˆãä½¿ã†ã®ã§ã™ãŒã€ ãªãœã‹ã“ã®çŸ¢å°ã¯2å›žæ›²ãŒã‚‹ã‚„ã¤ã—ã‹ç”¨æ„ã•ã‚Œã¦ã„ã¾ã›ã‚“ã€‚ é ‚ç‚¹ã®ç·¨é›†ã§ä½œã‚Œã‚‹ã¯ä½œã‚Œã‚‹ã‚“ã§ã™ãŒã€ å†åº¦ä½ç½®èª¿æ•´ã‚’ã™ã‚‹ã¨å†ã³2å›žæŠ˜ã‚Œæ›²ãŒã‚Šã‚„ãŒã‚Šã¾ã™ï¼ˆ#^Ï‰^ï¼‰ æ®‹å¿µãªãŒã‚‰ã“ã®æ ¹æœ¬çš„ãªè§£æ±ºç–ã¯ãªã„ã‚ˆã†ãªã®ã§ã™ãŒã€ ä»¥ä¸‹ã®ã‚ˆã†ã«ã‚¬ã‚¤ãƒ‰å›³å½¢ã‚’ä½œã£ã¦å¯¾å¿œã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ ä»Šå›žã¯ã“ã®ã€ŒçŸ¢å°ã‚³ãƒã‚¯ã‚¿ï¼‹ã‚¬ã‚¤ãƒ‰ã€3ç‚¹ã‚»ãƒƒãƒˆã‚’è‡ªå‹•æŒ¿å…¥ã™ã‚‹ãƒžã‚¯ãƒã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ å®Ÿè¡Œåž‹ã®ä¾¿åˆ©ãƒžã‚¯ãƒã§ã™ã®ã§ã€ Excelèµ·å‹•æ™‚ã«è£ã§é–‹ã‹ã‚Œã‚‹ã€Œå€‹äººç”¨ãƒžã‚¯ãƒãƒ–ãƒƒã‚¯ã€ãªã©ã«æè¼‰ã—ã¦ä½¿ã£ã¦ãã ã•ã„ã€‚ ãƒ„ãƒ¼ãƒ«ãƒãƒ¼ã‚„ãƒªãƒœãƒ³ã«ãƒœã‚¿ãƒ³é…ç½®ã™ã‚‹ã¨ä¾¿åˆ©ã§ã™ã€‚ ãƒžã‚¯ãƒã®ä»•æ§˜ ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ ã‚³ãƒ¼ãƒ‰ã®è§£èª¬ ãƒžã‚¯ãƒã®ä»•æ§˜ ã“ã®ãƒžã‚¯ãƒã¯ã€Œ2ã¤ã®ã‚»ãƒ«ã‚’é¸æŠžã—ã¦å®Ÿè¡Œã€ã™ã‚‹ä»•æ§˜ã®ãƒžã‚¯ãƒã§ã™ã€‚ ç¬¬1é¸æŠžã‚»ãƒ«ã‚’å§‹ç‚¹ã€ç¬¬2é¸æŠžã‚»ãƒ«ã‚’çµ‚ç‚¹(çŸ¢å°éƒ¨åˆ†)ã¨ã—ã¦ã€ ã‚¬ã‚¤ãƒ‰
Xenos 2025/08/18
VBA

excel
ãƒªãƒ³ã‚¯
çµå±€Excelã‚’LLMã«èªã¿è¾¼ã¾ã›ãŸã„ã¨ãã«ã©ã†ã™ã‚Šã‚ƒã„ã„ã®ã‹ã€"é¬¼"ã«èžã„ã¦ã¿ãŸãƒ¡ãƒ¢
Excelã‚’LLMã«èªã¿è¾¼ã¾ã›ãŸã„ã‘ã‚Œã©ã€ãã®ã¾ã¾ã ã¨èªã‚ãªã„ã¨æ€ã†ã‹ã‚‰ã€ã„ã£ãŸã‚“Markdownã«å¤‰æ›´ã—ã¦ã¿ãŸã‘ã‚Œã©ã€ãã“ã‹ã‚‰å…ˆã®ç²¾åº¦ãŒã†ã¾ãå‡ºãªã„ã—ã€ã©ã†ã—ãŸã‚‰ã„ã„ã‹ã‚‚ã‚ã‹ã‚‰ãªã„â€¦â€¦ã€‚ã¿ãªã•ã‚“ã€ãã‚“ãªçµŒé¨“ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿã€€åƒ•ã¯ã„ã¾ãã†ãªã£ã¦ã„ã¾ã™ï¼ ã¨ã„ã†ã‚ã‘ã§ã€ChatGPT(æ¨‹å£ä½œã®GPTs"é¬¼")ã«ã„ã¤ã‚‚é€šã‚Šèžã„ã¦ã¿ãŸã¨ã“ã‚ã€ãªã‚‹ã»ã©ã¨æ€ã£ãŸã®ã§å‚™å¿˜ã‚‚ã‹ãã¦ã‚„ã‚Šã¨ã‚Šã‚’æ®‹ã—ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ æ¨‹å£ï¼š LLMã«Excelã§æ›¸ã‹ã‚ŒãŸè¨è¨ˆæ›¸ã‚’èªã¾ã›ã¦ãƒ†ã‚¹ãƒˆãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ç”Ÿæˆã•ã›ãŸã„ã‚“ã ã‘ã©ã€ã‚³ãƒ„ã‚’æ•™ãˆã¦ã»ã—ã„ã€‚Excelã‚’MarkdownåŒ–ã—ã¦ãƒ—ãƒãƒ³ãƒ—ãƒˆã«å…¥ã‚Œã¦ã‚‹ã‚“ã ã‘ã©ã€ã‚«ãƒ©ãƒ ã¨ã‚»ãƒ«ã®é–¢ä¿‚ãŒã„ã¾ã„ã¡ã¡ã‚ƒã‚“ã¨åˆ¤åˆ¥ã•ã‚Œãªã„ã‚ˆã†ã«è¦‹ãˆã‚‹ã€‚ã‚ã¨ã€ç©ºç™½ã‚»ãƒ«ã‚„-ã¨ã—ã‹è¨˜è¼‰ã•ã‚Œã¦ã„ãªã„ã‚»ãƒ«ã®æ„å‘³ã‚’ç†è§£ã—ã¦ã„ãªã„ã‚ˆã†ã«è¦‹ãˆã‚‹ã€‚ãã†ã„ã†ã€Excelç‹¬ç‰¹ã®ï¼’æ¬¡å…ƒãƒžãƒˆãƒªã‚¯ã‚¹ã‚’è‡ªç„¶è¨€èªžã®ãƒ—ãƒãƒ³ãƒ—ãƒˆã«è½ã¨ã—ç›´ã™ãŸ
Xenos 2025/04/18
LLM

excel

ChatGPT
ãƒªãƒ³ã‚¯
Excel ã‚»ãƒ«ã®çµåˆã®ä»£æ›¿æ¡ˆ - youtube
YouTube ã§ãŠæ°—ã«å…¥ã‚Šã®å‹•ç”»ã‚„éŸ³æ¥½ã‚’æ¥½ã—ã¿ã€ã‚ªãƒªã‚¸ãƒŠãƒ«ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦å‹ã ã¡ã‚„å®¶æ—ã€ä¸–ç•Œä¸ã®äººãŸã¡ã¨å…±æœ‰ã—ã¾ã—ã‚‡ã†ã€‚
Xenos 2024/10/14
excel
ãƒªãƒ³ã‚¯
ChatGPTæ´»ç”¨ã‚’æ¿€éœ‡ã•ã›ã‚‹æ–°æ©Ÿèƒ½ã€ŒCode Interpreterã€ã«Netflixã‚’ãƒ‡ãƒ¼ã‚¿è§£æžã•ã›ãŸã‚‰ã‚¹ã‚´ã‹ã£ãŸ | Business Insider Japan
ãã“ã§ã¯ã€2021å¹´6æœˆ28æ—¥ã‹ã‚‰ç¾åœ¨ã¾ã§ã€ã™ã¹ã¦ã®ãƒ©ãƒ³ã‚ãƒ³ã‚°ãƒ‡ãƒ¼ã‚¿ãŒæ‰‹ã«å…¥ã‚‹ã€‚ã¤ã¾ã‚Šã€ï½¢ã‚ã®ä½œå“ãŒæ¯Žé€±ä½•æ™‚é–“è¦–è´ã•ã‚Œã¦ã„ã¦ã€ã©ã®å›½ã®ãƒ©ãƒ³ã‚ãƒ³ã‚°ã§ä½•ä½ã«å…¥ã‚Šã€ãã‚Œã‚’ä½•é€±é–“ç¶šã‘ãŸã®ã‹ï½£ã¨ã„ã£ãŸã“ã¨ã‚’ã€è‡ªåˆ†ã§é›†è¨ˆã§ãã‚‹ã€‚ ã§ã¯ä»Šå›žã¯ã€ æ—¥æœ¬ã§ã¯ãƒ†ãƒ¬ãƒ“ã‚·ãƒªãƒ¼ã‚ºï¼ˆæ˜ ç”»ä»¥å¤–ï¼‰ã®ã†ã¡ã€ã©ã‚“ãªã‚‚ã®ãŒäººæ°—ã‹ã€‚ç‰¹ã«æ—¥æœ¬ã§ä½œã‚‰ã‚ŒãŸãƒãƒƒãƒˆãƒ•ãƒªãƒƒã‚¯ã‚¹ã‚ªãƒªã‚¸ãƒŠãƒ«ã®å®Ÿå†™ä½œå“ã¯ã€ã©ã®å›½ã§äººæ°—ã‹ã€‚2022å¹´ä»¥é™ã®ç‰¹å®šä½œå“ã§é›†è¨ˆã€‚ã‚’ã‚„ã£ã¦ã¿ã‚ˆã†ã€‚ æœ¬æ¥ã€ã“ã‚Œã‚’Excelã§å‡¦ç†ã™ã‚‹ã¨ãã“ãã“é¢å€’ã ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã¯åŸºæœ¬è‹±èªžãªã®ã§ã€é …ç›®åã‚’æŠŠæ¡ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ã•ã‚‰ã«ã€å«ã¾ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã®ã©ã®é …ç›®ã§é›†è¨ˆã™ã‚‹ã®ãŒé©åˆ‡ã‹ã‚’è€ƒãˆã€ãƒ‡ãƒ¼ã‚¿ã‚’æ±‚ã‚ã‚‹å½¢ã«ä¸¦ã¹ç›´ã—ã€å†é›†è¨ˆã™ã‚‹ã€‚ å·¥ç¨‹ã‚’ä¸¦ã¹ã‚‹ã ã‘ã§ã‚‚10ãã‚‰ã„ã¯ã‚ã‚Šãã†ã ã€‚ã—ã‹ã‚‚ã“ã‚Œã¯ã€é›†è¨ˆä½œæ¥ã¨ã—ã¦ã¯éžå¸¸ã«åˆæ©çš„ãªã‚‚ã®ã€‚ãã‚Œã§ã‚‚ãã®ãã‚‰ã„ã€Œæ‰‹ã‚’å‹•ã‹ã•ãªãã¦ã¯ã„ã‘ãªã„ã€ã“ã¨ã«ãªã‚‹ã€‚ æ•°è¡Œã®æ–‡ç« ã‹ã‚‰è¤‡é›‘
Xenos 2023/07/31
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

excel

çµ±è¨ˆ

æ©Ÿæ¢°å¦ç¿’
ãƒªãƒ³ã‚¯
é›»åå¤©ç§¤ã®æ¸¬å®šãƒ‡ãƒ¼ã‚¿ã‚’Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã¸é€ä¿¡ã™ã‚‹ãƒ‡ãƒ¢
æ¦‚è¦ é›»åå¤©ç§¤ã¨ãƒ©ã‚ºãƒ‘ã‚¤ã®é–“ã‚’APBLE001ã§ç„¡ç·šåŒ– ãƒ©ã‚ºãƒ‘ã‚¤ã‹ã‚‰å®šæœŸçš„ã«æ¸¬å®šã‚³ãƒžãƒ³ãƒ‰ã‚’é€ä¿¡ã—ã€é›»åå¤©ç§¤ã®é‡é‡å€¤ã‚’å–å¾— å–å¾—ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’Googleãƒ‰ãƒ©ã‚¤ãƒ–ä¸Šã®ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã¸ãƒ¢ãƒã‚¤ãƒ«ãƒ«ãƒ¼ã‚¿çµŒç”±ã§é€ä¿¡ ä»Šå›žã®æ§‹æˆ æ§‹æˆå›³ RS232Cã¨USBã®é–“ã‚’ç„¡ç·šåŒ–ã™ã‚‹APBLE001ã®ã”ç´¹ä»‹ã§ã™ã€‚ã•ã‚‰ã«ã€ãƒ©ã‚ºãƒ™ãƒªãƒ¼ãƒ‘ã‚¤ã‚’ä½¿ç”¨ã—ã¦å®šæœŸçš„ã«è‡ªå‹•æ¸¬å®šã‚’è¡Œã„ã€å–å¾—ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’ãƒ¢ãƒã‚¤ãƒ«ãƒ«ãƒ¼ã‚¿çµŒç”±ã§ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã®Googleãƒ‰ãƒ©ã‚¤ãƒ–ã®ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã¸ãƒ‡ãƒ¼ã‚¿ã‚’é€ã‚‹ã“ã¨ã§ã€é›»åå¤©ç§¤ã‚’IoTåŒ–ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã®é›»åå¤©ç§¤ã¯ã‚¨ãƒ¼ãƒ»ã‚¢ãƒ³ãƒ‰ãƒ»ãƒ‡ã‚¤ã®GF-300ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ã€‚ é›»åå¤©ç§¤ãƒ‡ãƒ¼ã‚¿ã®ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆå–ã‚Šè¾¼ã¿ã®ãƒ¡ãƒªãƒƒãƒˆ ã‚·ãƒªã‚¢ãƒ«ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹çµŒç”±ã§å–å¾—ã—ãŸé›»åå¤©ç§¤ã®æ¸¬å®šãƒ‡ãƒ¼ã‚¿ã‚’Excelç‰ã®ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã¸å–ã‚Šè¾¼ã‚€ã¨ã„ã†å‡¦ç†ã¯ã€ä¸€èˆ¬ã«è¡Œã‚ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ã‚·ãƒªã‚¢ãƒ«ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹æŽ¥ç¶šã®ã‚¢ãƒ—ãƒªã‹ã‚‰CSVå½¢å¼ã§
Xenos 2022/08/17
google

é›»åå·¥ä½œ

excel

IoT
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ã‹ã‚‰ç¥ç¥æ—¥ã‚’å«ã‚ãŸå–¶æ¥æ—¥ã®åˆ¤å®šã‚’ç°¡å˜ã«è¡Œã† - ã‚±ãƒ³ã‚ªãƒ¼ãƒ«ãƒ–ãƒã‚°
æŒ‡å®šã—ãŸæ—¥ä»˜ãŒä¼‘æ—¥ã‹ã©ã†ã‹ã‚’ã‚µã‚¯ãƒƒã¨ãƒã‚§ãƒƒã‚¯ã—ãŸã„ã“ã¨ã¯ãŸã¾ã«ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ä¼‘æ—¥ã‚’ã‚¨ã‚¯ã‚»ãƒ«ãªã©ã‹ã‚‰ã‚µã‚¯ãƒƒã¨ç°¡å˜ã«ç¢ºèªã«ã§ãã‚‹ã€Œæ³•å®šä¼‘æ—¥ç¢ºèªAPIã€ã‚’è¿½åŠ ã—ã¾ã—ãŸã€‚ ä»¥ä¸‹ã®ã‚ˆã†ã«ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã«æ—¥ä»˜ã‚’æ¸¡ã™ã ã‘ã§ã€ãã®æ—¥ãŒä¼‘æ—¥ã‹ã©ã†ã‹ã®åˆ¤å®šã‚’è¡Œã†ã“ã¨ãŒå¯èƒ½ã§ã™ã€‚ï¼ˆç¾åœ¨ã¯æ³•å®šä¼‘æ—¥ã®ã¿ã®åˆ¤å®šã«å¯¾å¿œã—ã¦ã„ã¾ã™ã€‚ï¼‰ https://api.kenall.jp/v1/businessdays/check?date=2022-08-01 kenall.jp ã¾ãŸã€ã‚¨ã‚¯ã‚»ãƒ«ã‚„ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®é–¢æ•°ã«çµ„ã¿è¾¼ã‚€ã“ã¨ã§ã€ä»¥ä¸‹ã®ã‚ˆã†ã«ä¸€çž¬ã§å–¶æ¥æ—¥ã®åˆ¤å®šãŒã§ãã¾ã™ã€‚ ä¸Šè¨˜ã®ã‚¢ãƒ‰ã‚ªãƒ³ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªé–¢æ•°ã‚’ã‚¨ã‚¯ã‚»ãƒ«ã‚„ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆãªã©ã«çµ„ã¿è¾¼ã‚€ã“ã¨ã§å®Ÿè£…ã§ãã¾ã™ã€‚ /** * å–¶æ¥æ—¥ã‹ã©ã†ã‹ã‚’åˆ¤å®šã™ã‚‹ * @param {'2022-08-01'} date åˆ¤å®šã—ãŸã„æ—¥ä»˜ YYYY-MM-DD * @customfu
Xenos 2022/08/11
excel

ä»•äº‹
ãƒªãƒ³ã‚¯
ã“ã‚Œã‹ã‚‰ç¤¾ä¼šã«å‡ºã‚‹è‹¥è€…ã¸ã€‚ä¸€ã¤å¿ å‘Šã—ã¦ãŠããŒã€ãƒžã‚¸ã§ã€ŒExcelãŒã§ãã‚‹ã€ã£ã¦ã®ã¯ç¥žã‚¹ã‚ãƒ«ã ã‹ã‚‰å‹‰å¼·ã—ã¨ã‘ã€‚ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã¨ã‹å‹•ç”»ç·¨é›†ã‚ˆã‚Šå³åŠ¹æ€§ãŒã‚ã‚‹ãž
ExcelåŒ»@ã€Žäººç”Ÿã‚’å¤‰ãˆã‚‹ Excelã®ç¥žã‚¹ã‚ãƒ«ã€å¤§ç™ºå£²ï¼ @Excel_design_Dr 30ä»£å†…ç§‘åŒ»ï½œExcelå¤§å¥½ãï½œè·å ´ã®æ‚²æƒ¨ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¦‹ã¦ExcelçŒ›å‹‰å¼·â†’åˆå¿ƒè€…ã‹ã‚‰VBAä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚‹â†’ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ•ã‚©ãƒ¼ãƒ ã§ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã€‚ä½•ã‚‚ä¼ã‚ã‚‰ãªã„å¦ä¼šã‚¹ãƒ©ã‚¤ãƒ‰ã«å”–ç„¶â†’ãƒ‡ã‚¶ã‚¤ãƒ³å‹‰å¼·ä¸ã€‚å…¨å›½æ°‘ã®Excelãƒªãƒ†ãƒ©ã‚·ãƒ¼ä¸Šã’ãŸã„ã€‚Amazonã‚¢ã‚½ã‚·ã‚¨ã‚¤ãƒˆå‚åŠ ä¸ã€‚è‘—æ›¸ðŸ‘‰amzn.to/3tnd2fh excel-design-dr.com ExcelåŒ»@ã€Žäººç”Ÿã‚’å¤‰ãˆã‚‹ Excelã®ç¥žã‚¹ã‚ãƒ«ã€å¤§ç™ºå£²ï¼ @Excel_design_Dr ã“ã‚Œã‹ã‚‰ç¤¾ä¼šã«å‡ºã‚‹è‹¥è€…ã¸ã€‚ä¸€ã¤å¿ å‘Šã—ã¦ãŠããŒã€ãƒžã‚¸ã§ã€ŒExcelãŒã§ãã‚‹ã€ã£ã¦ã®ã¯ç¥žã‚¹ã‚ãƒ«ã ã‹ã‚‰å‹‰å¼·ã—ã¨ã‘ã€‚ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã¨ã‹å‹•ç”»ç·¨é›†ãŒã§ãã‚‹ã®ã‚‚ã„ã„ã‘ã©ã€ãã‚Œã‚’æ´»ã‹ã›ã‚‹ä¼šç¤¾ã£ã¦å°‘ãªã„ã‹ã‚‰ãªã€‚Excelã¯ã»ã¨ã‚“ã©ã®ä¼šç¤¾ã§ä½¿ã‚ã‚Œã¦ã‚‹ã‘ã©ã€ä½¿ã„ã“ãªã›ã‚‹äººã¯ã»ã‚“ã¨å°‘ãª
Xenos 2021/11/13
excel

vba

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã€åˆå¿ƒè€…ã•ã‚“å‘ã‘ã€‘è«¦ã‚ã¦ã»ã—ããªã„ã‹ã‚‰ä¸å¯§ã«èª¬æ˜Žï¼UiPath ã§ã®"ExcelåŸºæœ¬æ“ä½œ"ã«ã¤ã„ã¦ #RPALT
ã€ŒRPALT UiPath Talkã€ŒExcelä¸å¿ƒãƒãƒœã€ï½žã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã€å…ˆã«é€²ã‚ãªã„ã‚ãªãŸã¸ï½žã€ã‚¤ãƒ™ãƒ³ãƒˆã® å‚åŠ è€…ã®å‘Ÿãã‚’ã¾ã¨ã‚ã¦ã„ã¾ã™ã€‚ åˆå¿ƒè€…å‘ã‘ã«ã€ŒExcelä¸å¿ƒã®UiPathãƒãƒœä½œæˆã€ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ã‚¹ãƒ”ãƒ¼ã‚«ãƒ¼ã¯ã€UiPath Japan MVP 2020 ã¯ãªã£ã¡ï¼ã•ã‚“ã§ã—ãŸã€‚ è©³ç´°ã«ã¤ã„ã¦ã¯ã€å…¬å¼ã®ã‚¤ãƒ™ãƒ³ãƒˆãƒšãƒ¼ã‚¸ã‚„å¾Œæ—¥ã‚¢ãƒƒãƒ—ã•ã‚Œã‚‹YouTubeå‹•ç”»ã‚’ã”è¦§ãã ã•ã„ã€‚ â– ã‚¤ãƒ™ãƒ³ãƒˆã®æ§˜åã¯YouTubeã§ã‚‚å…¬é–‹ä¸ï¼ https://www.youtube.com/channel/UCm8GV22BVkw6RmeriT7VJUA ç¶šãã‚’èªã‚€
Xenos 2021/09/02
UiPath ã§ã®"ExcelåŸºæœ¬æ“ä½œ"ã«ã¤ã„ã¦ #RPALT - Togetter ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼

excel

youtube

programming

è‡ªå‹•åŒ–

RPA
ãƒªãƒ³ã‚¯
xdoc2txt
â– æ¦‚è¦ xdoc2txtã¯PDF,WORD,EXCEL,ä¸€å¤ªéƒŽãªã©ã®å„ç¨®ãƒã‚¤ãƒŠãƒªæ–‡æ›¸ã‹ã‚‰ã€ãƒ†ã‚ã‚¹ãƒˆè¦ç´ ã‚’æŠ½å‡º ã™ã‚‹æ±Žç”¨ãƒ†ã‚ã‚¹ãƒˆã‚³ãƒ³ãƒãƒ¼ã‚¿ã§ã‚ã‚Šã€Windowsã®ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§å‹•ä½œã—ã¾ã™ã€‚ xdoc2txtã¯å„ç¨®æ–‡æ›¸ã®æ§‹é€ ã‚’ç›´æŽ¥è§£æžã—ã¦ã„ã‚‹ãŸã‚ã€å˜ç‹¬ã§å¤‰æ›ã§ãã¾ã™ã€‚WORDã‚„ Acrobatãªã©ã€ä½œæˆå…ƒã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ é«˜é€Ÿã«å‹•ä½œã™ã‚‹ã®ã§ã€å„ç¨®å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã®ãƒ•ã‚£ãƒ«ã‚¿ã«æœ€é©ã§ã™ã€‚ ãƒ¯ãƒ¼ãƒ—ãƒæ–‡æ›¸ã®ç¨®é¡žã¯ã€æ‹¡å¼µåã‹ã‚‰åˆ¤åˆ¥ã—ã¾ã™ã€‚æ¬¡ã®æ‹¡å¼µåã®ãƒ•ã‚¡ã‚¤ãƒ«ã«å¯¾å¿œã—ã¦ã„ ã¾ã™ã€‚
Xenos 2020/08/15
excel

ãƒ„ãƒ¼ãƒ«

pdf

software
ãƒªãƒ³ã‚¯
Excelã§é«˜åº¦ãªæ•°å¼ã‚’æ§‹ç¯‰ã™ã‚‹æ–¹æ³• part1 - ãˆãã›ã‚‹ã¡ã‚…ã‚“ã¡ã‚…ã‚“
ä»Šå›žã¯Excelä¸Šç´šè€…ãŸã¡ãŒä½¿ã†ã‚ˆã†ãªã€é«˜åº¦ãªæ•°å¼ã‚’çµ„ã‚€ã®ã«å¿…è¦ãªæŠ€è¡“ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Excelé–¢æ•°ã¯ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã‘ã©ã€é…åˆ—æ•°å¼ãŒåˆ†ã‹ã‚‰ãªã„ï¼ã¨ã„ã†æ–¹ã«ã‚‚ã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã€‚ ã¯ã˜ã‚ã« ã‚¨ã‚¯ã‚»ãƒ«ã®åŸºæœ¬ æ³¨æ„ è¨ˆç®—ã®é †ç•ª é…åˆ— é…åˆ—å‚ç…§ é…åˆ—å®šæ•° é…åˆ—æ•°å¼ é…åˆ—æ•°å¼ã§ã¯ãªã„é…åˆ—æ•°å¼ æ•°å¼ä½œæˆã«å¿…è¦ãªæ¨™æº–æ©Ÿèƒ½ æ•°å¼ã®å…¥åŠ› æ•°å¼ã®æ¤œè¨¼ æ•°å¼ã‚’è¨ˆç®—çµæžœã§ç½®ãæ›ãˆã‚‹ æ•°å¼ã®åˆ†æž æ•°å¼ã‚’è¡¨ç¤º æ•°å¼ä½œæˆã«ä¾¿åˆ©ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ ã‚³ãƒ¡ãƒ³ãƒˆã‚’å…¥ã‚Œã‚‹æ–¹æ³•1 (Té–¢æ•°ã¨Né–¢æ•°) ã‚³ãƒ¡ãƒ³ãƒˆã‚’å…¥ã‚Œã‚‹æ–¹æ³•2 (é…åˆ—å®šæ•°) æ•°å¼è§£èªãƒ„ãƒ¼ãƒ« ãŠã‚ã‚Šã« ã¯ã˜ã‚ã« ä»¥å‰ã€æ–‡å—åˆ—å‡¦ç†ã®æ§˜ã€…ãªæ•°å¼ã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ https://www.excel-chunchun.com/entry/2019/01/31/011825www.excel-chunchun.com ã“ã®ä¸ã«ã¯ã€é…åˆ—ã‚’ä½¿ç”¨ã—ãŸé›£è§£ãªæ•°å¼ãŒã„ãã¤ã‚‚å«ã¾ã‚Œã¦ã„ã¾ã™ã€‚ é…åˆ—æ•°
Xenos 2019/08/17
æ•°å¼ã‚’Excelã«å…¥åŠ›ã™ã‚‹ã¨ãã«è¦‹ã‚‹

excel

æ•°å¦
ãƒªãƒ³ã‚¯
ã€å›³è§£ä»˜ãã€‘ã‚¨ã‚¯ã‚»ãƒ«ã®ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã¨ã¯ï¼Ÿã‚‚ã£ã¨ä¾¿åˆ©ãªãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ•ã‚£ãƒ«ã‚‚è§£èª¬ - ã¾ã„ã«ã¡doda - ã¯ãŸã‚‰ããƒ’ãƒ³ãƒˆã‚’ãŠå±Šã‘
Excelï¼ˆã‚¨ã‚¯ã‚»ãƒ«ï¼‰ã®ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã¨ã¯ ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã®ä½¿ã„æ–¹ ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã§è‡ªå‹•å…¥åŠ›ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ã®ç¨®é¡ž ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã®ã‚„ã‚Šæ–¹ã«é–¢ã™ã‚‹ç–‘å•ã‚„æ‚©ã¿ã‚’è§£æ¶ˆ ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ãŒã§ããªã„ã¨ãã®å¯¾å‡¦æ³• ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã§åŒã˜æ•°å—ãŒå…¥åŠ›ã•ã‚Œã‚‹ã¨ãã®å¯¾å‡¦æ³• ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã§è‡ªå‹•å…¥åŠ›ã™ã‚‹å€¤ã‚’è¨å®šã—ãŸã„ã¨ãã®å¯¾å‡¦æ³• ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã§ä¸€ç•ªä¸‹ã¾ã§å®Ÿè¡Œã—ãŸã„ã¨ãã®å¯¾å‡¦æ³• é–¢æ•°ã„ã‚‰ãšã®ã€Œãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ•ã‚£ãƒ«ã€ã‚‚æ´»ç”¨ ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ•ã‚£ãƒ«ã§ã§ãã‚‹ã“ã¨ ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã¨ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ•ã‚£ãƒ«ã®é•ã„ ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ•ã‚£ãƒ«ã®ä½¿ã„æ–¹ æ–¹æ³•1ï¼šã€Œãƒ‡ãƒ¼ã‚¿ã€ã‚¿ãƒ–â†’ãƒ‡ãƒ¼ã‚¿ãƒ„ãƒ¼ãƒ«å†…ã«ã‚ã‚‹ã€Œãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ•ã‚£ãƒ«ã€ã‚’é¸æŠž æ–¹æ³•2ï¼šã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«å®Ÿè¡Œå¾Œã€ã€Œã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€ã‚’å³ã‚¯ãƒªãƒƒã‚¯ã—ã€Œãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ•ã‚£ãƒ«ã€ã‚’é¸æŠž æ–¹æ³•3ï¼šãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ•ã‚£ãƒ«ã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚ãƒ¼ã€ŒCtrlï¼‹Eã€ã‚’ä½¿ã† ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãƒ•ã‚£ãƒ«æ´»ç”¨è¡“ï¼ã»ã‹ã«ã‚‚ã“ã‚“ãªä½¿ã„æ–¹ãŒã§ãã‚‹ æ¼¢å—ã ã‘ã˜ã‚ƒãªãã€ãƒãƒ¼
Xenos 2019/07/04
excel
ãƒªãƒ³ã‚¯
ã€ExcelVBAã€‘æ¬¡ã®éžè¡¨ç¤ºãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«å†…ã§ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ã¾ã—ãŸ | Windowsã®æ©Ÿèƒ½ç´¹ä»‹ãƒ»ãƒˆãƒ©ãƒ–ãƒ«å¯¾å¿œã®ITå‚™å¿˜éŒ²
ç™ºç”Ÿæ¡ä»¶ãŒã‚ˆãã‚ã‹ã‚‰ãªã„ã®ã§ã™ãŒâ€¦ Excel VBAã‹ã‚‰IEã‚’æ“ä½œã™ã‚‹ãƒžã‚¯ãƒã§ç™ºç”Ÿã—ã¾ã™ã€‚ ã¾ãŸã€Excel2013ã¨Excel2010ãªã©ã€ç•°ãªã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®Excelã§ä½¿ã£ãŸå¾Œã«ç™ºç”Ÿã™ã‚‹ã‚ˆã†ãªæ°—ãŒã—ã¦ã„ã¾ã™ã€‚ VBAå®Ÿè¡Œæ™‚ã«ã“ã®ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ -------------------------------------------------------------- æ¬¡ã®éžè¡¨ç¤ºãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«å†…ã§ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ã¾ã—ãŸ:Module1 ã“ã®ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ã®ã¯ã€ä¸€èˆ¬çš„ã«ã€ã‚³ãƒ¼ãƒ‰ãŒã“ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã€ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã€ã¾ãŸã¯ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¨äº’æ›æ€§ãŒãªã„å ´åˆã§ã™ã€‚ ã“ã®ã‚¨ãƒ©ãƒ¼ã‚’ä¿®æ£ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ã¯ã€[ãƒ˜ãƒ«ãƒ—]ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãã ã•ã„ã€‚ -------------------------------------------------------------- è§£æ±ºç–ã‚’è¦‹ã¤
Xenos 2018/06/12
excelVBA

VBA

EXCEL
ãƒªãƒ³ã‚¯
goo
Xenos 2017/11/07
VBA

Excel

Solver
ãƒªãƒ³ã‚¯
ã€ŒExcelã€ã§äºˆå®šè¡¨ã‚’è‡ªå‹•ç”Ÿæˆã™ã‚‹ãƒžã‚¯ãƒ ï½žå·¥ç¨‹è¡¨ã‚„å‡ºå‹¤ç°¿ã€é€²æ—è¨˜éŒ²ã«ã‚‚ï¼æœŸé–“ã‚’è¨å®šã—ã¦ï¼»ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«ä½œæˆï¼½ãƒœã‚¿ãƒ³ã‚’æŠ¼ã™ã ã‘ã®ç°¡å˜ãªæ“ä½œãŒé…åŠ›ã€ãƒ¬ãƒ“ãƒ¥ãƒ¼ã€‘
Xenos 2017/07/31
excel

äºˆå®šè¡¨
ãƒªãƒ³ã‚¯
http://mahoro-ba.net/e1577.html
Xenos 2016/07/09
excel
ãƒªãƒ³ã‚¯
goo
Xenos 2016/06/17
ExcelVBA ã‚½ãƒ«ãƒãƒ¼

excel

VBA
ãƒªãƒ³ã‚¯
ï½žçŽ‰å ¤æ—¥å’Œï½ž: ã€Excelãƒ»Solverã€‘ã‚½ãƒ«ãƒãƒ¼ã‚’VBAã§å®Ÿè¡Œ
ã‚¨ã‚¯ã‚»ãƒ«ï¼ˆExcel 2010ï¼‰ã®ã‚½ãƒ«ãƒãƒ¼ã‚’VBAã§å®Ÿè¡Œã™ã‚‹ä¾‹ã€‚ ï½žä¾‹ï¼šä¸‹ã®ã‚°ãƒ©ãƒ•ã®æ§˜ãªäºŒæ¬¡é–¢æ•°ã®y=0ã¨ãªã‚‹xã‚’æ±‚ã‚ã‚‹ï½ž ï¼‘ï¼‰ãƒ‡ãƒ¼ã‚¿ï¼žã‚½ãƒ«ãƒãƒ¼ã§â€ã‚½ãƒ«ãƒãƒ¼ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼â€ã‚¦ã‚¤ãƒ³ãƒ‰ã‚¦ã‚’ç«‹ã¡ä¸Šã’ã‚‹ ï¼’ï¼‰ã‚¦ã‚¤ãƒ³ãƒ‰ã‚¦ã§æœ€é©åŒ–ã—ãŸã„ã‚»ãƒ«ï¼ˆã“ã“ã§ã¯A2ï¼‰ã‚’â€ç›®çš„ã‚»ãƒ«ã®è¨å®šâ€ ï¼“ï¼‰ç›®çš„ã‚»ãƒ«ã®ç›®æ¨™å€¤ï¼ˆæœ€å¤§å€¤ã€æœ€å°å€¤ã€æŒ‡å®šå€¤ï¼‰ã‚’è¨å®šã€‚ã“ã“ã§ã¯â€ï¼â€ ï¼”ï¼‰å¤‰åŒ–ã•ã›ã‚‹ã‚»ãƒ«ï¼ˆå¤‰æ•°ã‚»ãƒ«ã®å¤‰æ›´ï¼‰ã‚’è¨å®šã€‚ã“ã“ã§ã¯â€B2â€ ï¼•ï¼‰åˆ¶ç´„æ¡ä»¶ï¼ˆåˆ¶ç´„æ¡ä»¶ã®å¯¾è±¡ï¼‰ã‚’è¨å®šã€‚ã“ã“ã§ã¯"B2â‰¦10"ã‚’æŒ‡å®šã€‚xã¯"3"ã¨"13"äºŒã¤ã®å¯èƒ½æ€§ãŒã‚ã‚‹ãŸã‚åˆ¶ç´„æ¡ä»¶ã‚’å…¥ã‚Œã¦ä¸€ã¤ã®è§£ã«åŽæŸã•ã›ã¦ã„ã¾ã™ã€‚ ï¼–ï¼‰å®Ÿè¡Œï¼ˆâ€è§£æ±ºâ€ãƒœã‚¿ãƒ³ï¼‰ã™ã‚‹ â– ãƒžã‚¯ãƒã§å®Ÿè¡Œã™ã‚‹å ´åˆã®VBAã‚³ãƒ¼ãƒ‰ -------------------------------------------------------------------- Sub Macro1() Solver
Xenos 2016/06/16
ExcelVBA

Excel

VBA
ãƒªãƒ³ã‚¯
Excel VBAã‹ã‚‰åˆ†æžãƒ„ãƒ¼ãƒ«ã‚„ã‚½ãƒ«ãƒãƒ¼ã‚’ä½¿ã†
ç¬›ç”°è–«ã®æ•™è‚²ã€ç ”ç©¶ã€æ—¥è¨˜ãªã©ã€‚ è¬›ç¾©ã®ç¨®é¡žã«ã‹ã‹ã‚ã‚‰ãšæ—¥ä»˜é †ã«ä¸¦ã‚“ã§ã„ã‚‹ã®ã§ã€ç›®æ¬¡ã‹ã‚‰è¬›ç¾©ã‚’é¸ã‚“ã§ãã ã•ã„ã€‚å†™çœŸã¯ã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨å¤§ããè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚æ—¥ä»˜ã¯ã€è¬›ç¾©ãªã‚‰ã°è¬›ç¾©ã®æ—¥æ™‚ã€å†™çœŸãªã‚‰ã°æ’®å½±æ—¥æ™‚ã§ã‚ã‚Šãƒ–ãƒã‚°ã‚’æ›¸ã„ãŸæ—¥ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚å¾Œæ—¥æ›¸ãè¶³ã™ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã®ã§ã€å·¦å´ã®ç›®æ¬¡ã‚„æ¤œç´¢ã‚’ä½¿ã£ã¦é–¢é€£ã™ã‚‹ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’æŽ¢ã—ã¦ãã ã•ã„ã€‚ç„¡æ–è¤‡è£½ã‚’ç¦ã˜ã¾ã™ã€‚å¼•ç”¨ã™ã‚‹å ´åˆã¯å‡ºå…¸ã¨ã—ã¦ã“ã“ã®ã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’æ˜Žè¨˜ã—ã¦ãã ã•ã„ã€‚ ã‚¢ãƒ‰ã‚¤ãƒ³ã®è¨å®šã§ â–¡ã‚½ãƒ«ãƒãƒ¼ â–¡åˆ†æžãƒ„ãƒ¼ãƒ« â–¡åˆ†æžãƒ„ãƒ¼ãƒ« - VBA ã«ãƒã‚§ãƒƒã‚¯ã‚’ã¤ã‘ã¦ã€ãƒžã‚¯ãƒã®è¨˜éŒ²ã‚’ä½¿ã£ã¦åˆ†æžãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã£ãŸå ´åˆã®æ“ä½œã‚’ãƒžã‚¯ãƒã«è¨˜éŒ²ã™ã‚‹ã¨ Application.Run "ATPVBAEN.xla!Random",... ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚åˆ†æžãƒ„ãƒ¼ãƒ«ã®ä¸ã®ã©ã‚Œã‚’ä½¿ã†ã‹ã«ã‚ˆã£ã¦Randomã®éƒ¨åˆ†ã¯åˆ¥ã®ã‚‚ã®ã«å¤‰ã‚ã‚Šã¾ã™ã€‚ãã‚Œã¯ã„ã„ã¨ã—ã¦ã€ã“ã®è¨˜éŒ²ã—ãŸã°ã‹ã‚Šã®ãƒžã‚¯ãƒã‚’å®Ÿè¡Œã™ã‚‹
Xenos 2016/06/16
Excel

VBA
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ã®ã‚½ãƒ«ãƒãƒ¼ã‚’ç”¨ã„ãŸæœ€å°ä½œç”¨ã®åŽŸç†ã«åŸºã¥ãè³ªç‚¹ã®è»Œé“è¨ˆç®—(å¤§ç™ºè¦‹ï¼)
ã‚¨ã‚¯ã‚»ãƒ«ã®ã‚½ãƒ«ãƒãƒ¼ã‚’ç”¨ã„ãŸæœ€å°ä½œç”¨ã®åŽŸç†ã«åŸºã¥ãè³ªç‚¹ã®è»Œé“è¨ˆç®— ï¼ˆå¤§ç™ºè¦‹ï¼) å›³1è³ªç‚¹ã®è»Œé“ã«é–¢ã™ã‚‹ç†è«–è§£ã¨é©å½“ã«è¨å®šã—ãŸè»Œé“ æœ€å°ä½œç”¨ã®åŽŸç† æœ€å°ä½œç”¨ã®åŽŸç†(ãƒãƒŸãƒ«ãƒˆãƒ³ã®åŽŸç†)ã«ã‚ˆã‚Œã°ã€ãƒ©ã‚°ãƒ©ãƒ³ã‚¸ãƒ¥é–¢æ•°(L)ã®æ™‚é–“ç©åˆ†ã‚’Sã¨ã™ã‚‹ã¨ã€ S = âˆ«L dt ã€€ã€€ãƒ»ãƒ»ãƒ»ã€€(1) ã€€ã€€ã€€ç©åˆ†åŒºé–“[t1,t2] ã®S(ä½œç”¨ç©åˆ†)ãŒæœ€å°å€¤ã‚’ã¨ã‚‹ã‚ˆã†ã«ã€è³ªç‚¹ã¯é‹å‹•ã™ã‚‹ã€‚ ãŸã ã—ã€å§‹ç‚¹(t=t1),çµ‚ç‚¹(t=t2)ã«ãŠã„ã¦ã€è³ªç‚¹ã¯å®šã‚ã‚‰ã‚ŒãŸä½ç½®ã«ã‚ã‚‹ã‚‚ã®ã¨ã™ã‚‹ã€‚ ç´”ç²‹ãªåŠ›å¦ç³»ã®å ´åˆã€ãƒ©ã‚°ãƒ©ãƒ³ã‚¸ãƒ¥é–¢æ•°ã¯æ¬¡å¼ã¨ãªã‚‹ã€‚ L = K - U Kï¼šé‹å‹•ã‚¨ãƒãƒ«ã‚®ãƒ¼ Lï¼šä½ç½®ã‚¨ãƒãƒ«ã‚®ãƒ¼
Xenos 2016/06/16
ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã®æ”»ç•¥ã«ä½¿ãˆã‚‹ï¼Ÿ

Excel

VBA
ãƒªãƒ³ã‚¯
æ˜¨æ—¥ã¾ã§JavaJavaã—ã¦ãŸäººãŒã„ããªã‚ŠExcelã®VBAã‚’å®Ÿè£…ã™ã‚‹ç¾½ç›®ã«ãªã£ãŸã¨ãã®ãŸã‚ã®ãƒ¡ãƒ¢ - Qiita
Excel ã¯æ»…ã³ã¬ï¼ Excel ã®åŠ›ã“ãæ—¥æœ¬ä¼æ¥ã®å¤¢ã ã‹ã‚‰ã ï¼ VBA å®Ÿè£…ã—ã¦ã¦å¦ã‚“ã ã“ã¨ã¨ã‹ã®ãƒ¡ãƒ¢ã€‚ Java Java ã—ã¦ãŸã‹ã¯ã‚ã¾ã‚Šé–¢ä¿‚ãªã„ã‹ã‚‚ã€‚ ã‚¨ãƒ‡ã‚£ã‚¿ã®ä½¿ã„æ–¹ ã‚¨ãƒ‡ã‚£ã‚¿ã‚’è¡¨ç¤ºã™ã‚‹ Alt + F11 ã§ VB ã‚¨ãƒ‡ã‚£ã‚¿ã‚’è¡¨ç¤ºã§ãã‚‹ã€‚ ç’°å¢ƒè¨å®š èƒŒæ™¯è‰²ãƒ»ãƒ•ã‚©ãƒ³ãƒˆã‚’èª¿æ•´ã™ã‚‹ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ç™½èƒŒæ™¯ã¨ã‹æ°—ãŒç‹‚ã†ã®ã§ã€æš—ã„è‰²ã«ã™ã‚‹ã€‚ ã€Œãƒ„ãƒ¼ãƒ«ã€â†’ã€Œã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€ã‚’é¸æŠžã—ã€ã€Œã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã®è¨å®šã€ã‚¿ãƒ–ã‚’é–‹ãã€‚ ã€Œã‚³ãƒ¼ãƒ‰ã®è¡¨ç¤ºè‰²ã€ã‚’é¸æŠžã—ã¦ã€ã€ŒèƒŒæ™¯ã€ã®è‰²ã‚’é¸æŠžã™ã‚‹ã€‚ ã¤ã„ã§ã«ãƒ•ã‚©ãƒ³ãƒˆã‚‚è¦‹ã‚„ã™ã„ã‚„ã¤ã«å¤‰æ›´ã™ã‚‹ã€‚ ã“ã‚Œã ã‘ã§é–‹ç™ºåŠ¹çŽ‡ãŒï¼•å‰²å¢—ã—ã«ãªã‚‹ã€‚ ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã‚’è¡¨ç¤ºã™ã‚‹ ã„ã‚ã‚†ã‚‹ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã«å½“ãŸã‚‹ã®ãŒã€__ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦__ã¨å‘¼ã°ã‚Œã‚‹ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã€‚ Ctrl + G ã§è¡¨ç¤ºã•ã‚Œã‚‹ã€‚ ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã«å‡ºåŠ›ã™ã‚‹ â†“ã‚¤ãƒŸãƒ‡ã‚£ã‚¨ã‚¤ãƒˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã«å®Ÿ
Xenos 2016/04/27
excelVBA

excel

vba
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸