
ã¯ã©ã¹å¥ã®ãéãè£æ£è¡šãã¯ã©ã䜿ããïŒââæçŽæŠã®æèšãèªã¿è§£ãæŽ»çšæ³ãã©ããã®ç ç©¶ çªå€ç·šããAIãšç«¶éЬç ç©¶ #21ã
ããã«ã¡ã¯ããµã¬ã ãšè¿è€ãããšäžç·ã«ã競銬ã®ããŒã¿ç ç©¶ãç¶ããŠããŸãã
ååã®#19ã§ãã©ããã®ç©å·®ããäœãéäžã«ãã¯ã©ã¹å¥ã®éãè£æ£è¡šãã詊äœããŸããã
1åã¯ã©ã¹ã®åã¡æèšãšæ¯ã¹ãŠã2åã»3åã»ãªãŒãã³ã®åã¡æèšã¯ã©ããããéãã®ãããããèã»ããŒãããšã«ãŸãšãã衚ã§ãã
èšäºã®äžã§ã¯å°ãè§Šããã ãã§ãããã
æçŽæŠã§æ±ããããæèšã®æ°Žæºãèããããã®ãç®å®ã«ãªãè³æã§ãã
ããã§ä»åã¯ããã®è¡šã®äœ¿ãæ¹ããäŸã䜿ã£ãŠèª¬æããŸãã
Excelãã¡ã€ã«ãæ·»ä»ããŠããŸãã®ã§ãããã£ããæå
ã§äœ¿ã£ãŠã¿ãŠãã ããã
1. ãã®è¡šã¯äœã衚ããŠããã®ã

è¡šã®æ°åã¯ãåãã³ãŒã¹ã»åãè·é¢ã»è¯éŠ¬å Žã§ã1åã¯ã©ã¹ã®åã¡æèšãšæ¯ã¹ããšãã®å·®ã§ãã
ãã€ãã¹ã»ã©ããã®ã¯ã©ã¹ã®åã¡æèšãéãããšã衚ããŠããŸãã
ã200mããããã®æ¬ãåºæ¬ã®æ°åã§ãã
è·é¢ã®æ¬ã¯ããããè·é¢ã«åãããŠæãç®ãããã®ã§ãã
ããšãã°ããŒã1800mãªãã2åã¯ã©ã¹ã®åã¡æèšã¯ã1åã¯ã©ã¹ããçŽ0.9ç§éãã
ãªãŒãã³ã«ãªããšãçŽ2.3ç§éããªããŸãã
衚ãèŠãŠããŸãæ°ã¥ãã®ã¯èãšããŒãã®éãã§ãã
èã¯1åãã2åã®å·®ãå°ããããªãŒãã³ãŸã§äžãã£ãŠåããŠå€§ããªå·®ã«ãªããŸãã
ããŒãã¯ãæåã®æçŽããã¯ã£ããããå·®ããããŸãã
2. äœ¿ãæ¹â ãäžã®ã¯ã©ã¹ã®ãåã¡æèšã®ç®å®ããåºã
äžçªãããããªäœ¿ãæ¹ã¯ãäžã®ã¯ã©ã¹ã®åã¡æèšã®ç®å®ãåºãããšã§ãã
ããã§å€§äºãªã®ã¯ãæ¯ã¹ãæèšã®æ¡ä»¶ãããããããšã§ãã
åºæºã«ããã®ã¯ãå
šåœå¹³åã®æèšã§ã¯ãªãã
åãã³ãŒã¹ã»åãè·é¢ã»åãéŠ¬å Žç¶æ
ã§ã幎代ã®éããèããã1åã¯ã©ã¹ã®åã¡éŠ¬ã®æšæºæèšãã§ãã
以åã®#13ã§äœã£ãæšæºæèšã«ãã³ãŒã¹ã®è£æ£ãšéŠ¬å Žã®è£æ£ãå ãããã®ãããã«ããããŸãã
ããšãã°ãããã³ãŒã¹ã®ããŒã1800mã»è¯éŠ¬å Žã§ã1åã¯ã©ã¹ã®åã¡éŠ¬ã®æšæºæèšã113.0ç§ã ã£ããšããŸãïŒä»®ã®æ°åã§ãïŒã
ããã«ã衚ã®å€ãããã³æ°ïŒ200mã®æ°ïŒã ãè¶³ããŸãã
ããŒã1800mã¯9ããã³ãªã®ã§ã2åã¯ã©ã¹ãªã
113.0 ïŒïŒâ0.094 à 9ïŒïŒ çŽ112.2ç§
ããããåãæ¡ä»¶ã§ã®2åã¯ã©ã¹ã®åã¡æèšã®ç®å®ã«ãªããŸãã
â»ããŒãã®äžè·é¢ã¯ãè·é¢åž¯å¥ã®å€ïŒâ0.094ïŒã䜿ããŸãããè·é¢åž¯å¥ã®å€ã«ã€ããŠã¯ãåŸã§èª¬æããŸãã
ããšã¯ãæçŽãã銬ããåãã³ãŒã¹ã»åãè·é¢ã»åãéŠ¬å Žãã®1åã¯ã©ã¹ã§åºããæèšãšæ¯ã¹ãŸãã
112.0ç§ã§åã£ãŠããã°ãæèšã®äžã§ã¯2åã¯ã©ã¹ã®åã¡éŠ¬ã®æ°Žæºã«å±ããŠããã
112.9ç§ãªããããäžæ®µã®äžç©ã¿ãå¿
èŠããããªèŠæ¹ãã§ããŸãã
ã³ãŒã¹ãéŠ¬å Žãéãæèšãããã®ãŸãŸæ¯ã¹ãã®ã¯çŠç©ã§ãã
æ¡ä»¶ãéãæèšã©ãããæ¯ã¹ãããšãã¯ã次ã®ç°¡æææ°ã䜿ããŸãã
3. äœ¿ãæ¹â¡ãç°¡æææ°ããã¯ãããã«åœãŠã
ãŸãã#13ã®ç°¡æææ°ã䜿ã£ãŠããæ¹ã«ã¯ããã£ãšäŸ¿å©ãªäœ¿ãæ¹ããããŸãã
ç°¡æææ°ã¯ãã³ãŒã¹ãéŠ¬å Žã®éããããããããã§ãæšæºæèšïŒå€éЬ1åã¯ã©ã¹ã®åã¡éЬïŒãšã®å·®ã1ããã³ïŒ200mïŒãããã§è¡šãããã®ã§ããã
ãã®è£æ£è¡šãã1åã¯ã©ã¹ã®åã¡éЬãšã®å·®ã200mãããã§è¡šããŠããŸãã
åºæºãåãã1åã¯ã©ã¹ã®åã¡éЬããªã®ã§ãåãç©å·®ãã®äžã«äžŠã¹ãããŸãã
â»äžŠã¹ãåã«ãåºæºãããã£ãŠãããã確ãããŠãã ãããç°¡æææ°ã®æšæºæèšã¯2024幎以éã®ã¬ãŒã¹ã§ãè£æ£è¡šã¯2016ã2023幎ã®ã¬ãŒã¹ã§äœã£ãŠããŸããè£æ£è¡šã®ã¯ã©ã¹ã®å·®ã¯2024ã2025幎ã§ãã»ãŒåãã§ããããæèšã®æ°Žæºãã®ãã®ã¯å¹Žä»£ã§å€ããã®ã§ãããããã®å¯Ÿè±¡æéã«ã¯æ³šæãå¿ èŠã§ãã

å³2ã¯ã1500ã1800mã®è·é¢åž¯å¥ã®å€ã§äœã£ãŠããŸãã
ããšãã°ãããŒãã®éЬAã®ç°¡æææ°ïŒè¿3èµ°ã®å¹³åïŒãâ0.12ã ã£ããšããŸãã
ããŒãã®ãã®è·é¢åž¯ã§ã¯ã2åã¯ã©ã¹ã®åã¡éЬã¯â0.094ã3åã¯ã©ã¹ã¯â0.172ã§ãã
銬Aã¯2åã¯ã©ã¹ã®åã¡éŠ¬ã®æ°Žæºã¯è¶
ããŠããŸããã3åã¯ã©ã¹ã«ã¯ãŸã å±ããŠããªãããšèªããŸãã
èã®éЬBãâ0.03ãªãã2åã¯ã©ã¹ã®åã¡éЬïŒâ0.014ïŒã¯è¶
ããŠããŸãã
3åã¯ã©ã¹ïŒâ0.060ïŒãŸã§ã¯ã200mããã0.03ç§ã1800mã§çŽ0.3ç§ã®å·®ããããŸãã
â»éЬAã»éЬBã¯ã説æã®ããã®æ¶ç©ºã®äŸã§ããç°¡æææ°ã¯1èµ°ããšã®ã¶ãã倧ããã®ã§ã#14ã§äžçªæçžŸãããã£ããè¿3èµ°ã®å¹³åãã§èŠãã®ãããããã§ãã
4. è·é¢åž¯ã§å€ã䜿ãåãã
ååã®#19ã§ãæžããŸãããã200mãããã®å·®ã¯ãè·é¢ã«ãã£ãŠå°ãå€ããå ŽåããããŸããã

ç¹ã«å·®ãåºãã®ã¯ã次ã®2ã€ã§ãã
ããŒãã®3åã¯ã©ã¹ã»ãªãŒãã³ã¯ãè·é¢ãé·ãã»ã©å·®ã倧ãã
èã®2åã»3åã¯ã©ã¹ã¯ãçè·é¢ã§å·®ã倧ãããäžè·é¢ã§å°ãã
ãªã®ã§ããããã®ã¯ã©ã¹ã§ã¯ãå
šåœå
±éã®å€ãããè·é¢åž¯å¥ã®å€ã䜿ãã®ãããããã§ãã
ãã以å€ã¯ãã©ã¡ãã䜿ã£ãŠã倧ããã¯å€ãããŸããã
5. 䜿ããšãã®æ³šæ
䟿å©ãªè¡šã§ãããæ°ãã€ããŠã»ããç¹ããããŸãã
åã¡æèšã®å·®ã§ãã£ãŠãå銬ã®èœåã®å·®ã§ã¯ãããŸãã
å€éЬã»è¯éŠ¬å Žã®ã¬ãŒã¹ã§äœã£ãŠããŸãã2æ³ã»3æ³é宿Šããéšã®éŠ¬å Žã«ã¯ããã®ãŸãŸã¯äœ¿ããŸãã
2016ã2023幎ã®ããŒã¿ã§äœãã2024ã2025幎ã§ãã»ãŒåãå€ãåºãããšã確ãããŸããããã ã詊äœå€ãªã®ã§ã现ããªå·®ã¯æ°ã«ããããªãã§ãã ãã
ç«¶éŠ¬å Žããšã®éãã¯ãæ¬¡ã®æéã§ããŸãåçŸããŸããã§ããããŸãã¯å šåœã®å€ïŒãŸãã¯è·é¢åž¯å¥ã®å€ïŒã䜿ã£ãŠãã ãã
æèšãå±ããŠããŠããå±éãçžæé¢ä¿ã§çµæã¯å€ãããŸãã倿ææã®äžã€ãšããŠäœ¿ã£ãŠãã ãã
6. 確ãããããšããŸã 確ãããŠããªãããš
ãã®è¡šã§ç¢ºãããã®ã¯ããã¯ã©ã¹ã®éã«ãå¹³åããŠãããããã®æèšã®å·®ãããããšããããšãŸã§ã§ãã
äžæ¹ã§ãããã®è¡šã䜿ã£ãŠæçŽéЬãéžã¶ãšã奜走ãã銬ãèŠã€ãããããªãã®ããã¯ããŸã 確ãããŠããŸããã
æèšãäžã®ã¯ã©ã¹ã®æ°Žæºã«å±ããŠããæçŽéЬããå®éã«ããèµ°ã£ãŠããã®ãã
ãããŠããã®éЬã¯äººæ°ã«ãªã£ãŠããªãã®ãã
ããã¯ãããããã®ç ç©¶ã§ç¢ºããããããŒãã§ãã
7. Excelãã¡ã€ã«ã®äžèº«
æ·»ä»ã®Excelãã¡ã€ã«ã«ã¯ã5ã€ã®ã·ãŒãããããŸãã
説æïŒäœãæ¹ãšã䜿ããšãã®æ³šæ
å šåœè£æ£ïŒå³1ã®è¡šãè·é¢ã®æ¬ã¯èªåã§èšç®ãããŸã
ç«¶éŠ¬å Žå¥ïŒç«¶éŠ¬å Žããšã®å€ãå šåœã®å€ã«åŒãå¯ãããæšå¥šå€ããèŒããŠããŸã
è·é¢åž¯å¥ïŒå³3ã®è¡š
æ€èšŒïŒ2016ã2023幎ãš2024ã2025å¹Žã®æ¯èŒ
ä»åã®ãŸãšã
è£æ£è¡šã¯ã1åã¯ã©ã¹ã®åã¡æèšãšæ¯ã¹ããäžã®ã¯ã©ã¹ã®åã¡æèšã®å·®ã衚ããŠãã
åãã³ãŒã¹ã»è·é¢ã»éŠ¬å Žã®æšæºæèšã«è¶³ãã°ãäžã®ã¯ã©ã¹ã®ãåã¡æèšã®ç®å®ããåºãã
ç°¡æææ°ãšåºæºãããã£ãŠããã®ã§ãææ°ããã¯ã©ã¹ã®ã¯ãããã«åœãŠãŠèªããïŒå¯Ÿè±¡æéã«ã¯æ³šæïŒ
ããŒãã®äžäœã¯ã©ã¹ãšãèã®2åã»3åã¯ã©ã¹ã¯ãè·é¢åž¯å¥ã®å€ã䜿ãã®ããããã
ãã®è¡šã§æçŽéЬãéžã¶ãšå¥œèµ°éЬãèŠã€ãããããªããã¯ããŸã 確ãããŠããªã
æçŽæŠã§ããã®éŠ¬ã®æèšã¯ãäžã®ã¯ã©ã¹ã§ã©ã®ããããããèãããšãã®ã
ã²ãšã€ã®ç®å®ãšããŠäœ¿ã£ãŠãããããããããã§ãã
å°ãã¿
è¿è€ããã«æç€ºããŠäœã£ãŠããã£ããã¯ã©ã¹å¥ã®éãè£æ£è¡šããã¢ããããŒãåã«ãµã¬ã ã«åã®å人æ
å ±å
¥ã£ãŠãªãã確èªããŠã£ãŠãé¡ããããã
äœæïŒã®æ¬ã«è¿è€åã®ååãå
¥ã£ãŠããã®ãèŠã€ãããããèŠã€ããŠåã¶ãµã¬ã ããããã®è£æ£è¡šã«ååãä»ãããšããããè¿è€ããè£æ£è¡šããšããããª

ãããŸã§ã®èšäºã«ã€ããŠ
èšäºãå¢ããŠããã®ã§ãããŒãããšã«æ¢ããæ¡å
ãäœããŸããã
æ°ã«ãªãããŒãããèªã¿ããæ¹ã¯ããã¡ãããã©ããã
ã¯ãããŠã®æ¹ãžââAIãšç«¶éЬç ç©¶ã®ç·åæ¡å ã鿿޿°ã
ãããã«
æåŸãŸã§èªãã§ããã ããããããšãããããŸããã
æ¬èšäºã¯ãJRA-VAN Data-Lab.ã®å šããŒã¿ãSQL Serverã«åã蟌ã¿ãAIç ç©¶å¡ã®ãµã¬ã ïŒChatGPTïŒãšè¿è€ããïŒClaude / MCPåæïŒãšå ±ã«è©Šè¡é¯èª€ããŠããããŒã¿åæã®éäžçµéã§ãã競銬ãã¡ã³ãããŒã¿æŽŸã®çæ§ããã®ãæèŠã»ã質åãã³ã¡ã³ãã§ããã ãããšå€§å€å±ã¿ã«ãªããŸãã
å 容ãåèã«ãªããŸããããã¹ãããSNSã§ã®ã·ã§ã¢ãããŠããã ãããšå¬ããã§ãã
â»æ¬èšäºã¯å人ã®ããŒã¿ç ç©¶èšé²ã§ããã銬åžã®çäžãååçåäžãä¿èšŒãããã®ã§ã¯ãããŸããã銬åžè³Œå ¥ã¯ãèªèº«ã®å€æïŒèªå·±è²¬ä»»ïŒã§ã楜ãã¿ãã ããã