No288 ä¹±æ°è¡šãšã¯ã³ã¿ã€ã ãã¹ã¯ãŒã
ååã®ããŒã¬ã¹ãšã³ããªãŒã®è©±ã§ãã£ã¬ã³ãžïŒã¬ã¹ãã³ã¹ã®è§£èª¬ãããŸããããã®äžã§ãå®éã®ã¯ã«ãã§ã¯ãã£ã¬ã³ãžïŒã¬ã¹ãã³ã¹ã®å¿çšçã§ããã¯ã³ã¿ã€ã ãã¹ã¯ãŒãã䜿ãããšããããšãæžããŸããã
ãããŸã§æžããšãããããã¯ã³ã¿ã€ã ãã¹ã¯ãŒãã£ãŠäœã ãããšæ°ã«ãªãæ¹ãå€ãããšæããŸãã®ã§ãä»åã¯ãã®èãæ¹ã«ã€ããŠè§£èª¬ãããŸãã
1. ãã¹ã¯ãŒããšã¯ã³ã¿ã€ã ãã¹ã¯ãŒãã¯éããã®
ã¯ã³ã¿ã€ã ãã¹ã¯ãŒããšããã®ã¯ãæåéããäžåãã䜿ããªããã¹ã¯ãŒãã§ããäžåºŠäœ¿ã£ããã¹ã¯ãŒãã¯äœ¿çšæžãšãªããäºåºŠãšäœ¿ããŸããã
äžåºŠããåããã¹ã¯ãŒãã䜿ããŸãããããä»®ã«çèŽãªã©ã«ãããã¹ã¯ãŒããå
¥æããŠã䜿ããã®ã«ãªããªãããã§ããããããªãå®å
šãªæ¹åŒãšèšããŸãã
ãããªã«è¯ããã®ãªãä»ã®ãã¹ã¯ãŒããªããŠãããŠããŸãã°è¯ããããªãã®ã§ãããããã¯ãããŸããã
ã¯ã³ã¿ã€ã ãã¹ã¯ãŒãã¯éåžžã®ãã¹ã¯ãŒãã®ä»£çšåã§ã¯ãããŸããã
éåžžã®ãã¹ã¯ãŒããšãã£ããã«äœ¿ãããšã§ãããå®å
šæ§ãé«ããããã®ä»æããšèšããŸãã
äž¡è
ã¯æ¬¡ã®ããã«éããã®ã§ãã
ãã¹ã¯ãŒã
ãã»å©çšè
èªèº«ãèšå®ããã
ãã»ãïŒå©çšè
ã®ïŒç¥èãã確èªããã
ãã»å€æŽããªãéãæ°žç¶çã«äœ¿ãã
ã¯ã³ã¿ã€ã ãã¹ã¯ãŒã
ãã»ãµãŒãã¹äºæ¥è
åŽãèšå®ãã
ãã»ãïŒãã¹ã¯ãŒãäžèЧãªã©ã®ïŒææãã確èªããã
ãã»äžåºŠãã䜿ããªãã
2. ä¹±æ°è¡š
ãããªã話ãå€ãããŸãããä¹±æ°è¡šãšãããã®ããåç¥ã§ããããïŒ
ä»ã¯äžåŠæ ¡ã®æ°åŠã§ãç¿ãããã§ãããçè
ã®æã¯ãããŸããã§ãããïŒçè
ã®èšæ¶åãèãããšã€ãã€ãæªããã§ãã...ïŒ
èŠã¯ã¢ã«ãã¡ããããæ°åãã©ã³ãã ã«äžŠã¹ã衚ã§ãããšãã£ãŠãåºçŸé »åºŠã¯åãã«ãªãããã«ããã³ãšèšç®ããããã®ã§ãå®å
šãªã©ã³ãã å€ãšããããã§ã¯ãããŸããã
ãã®ä¹±æ°è¡šãšãããã®ã¯ãç¬¬äºæ¬¡äžç倧æŠãŸã§ã®æå·åéä¿¡ã§ã¯ãã䜿ãããææ³ã§ããã
åœæã¯æå·åã«äœ¿ãéµãããã«ç§å¿ããããéèŠãªãã€ã³ãã§ãããæå·åãããæã«ã¯ãä¹±æ°è¡šã®äœçªç®ã®å€ã䜿ã£ãŠæå·åããããããããããã«ããŠããã埩å·ããïŒæå·ãè§£ãïŒåŽã¯åãä¹±æ°è¡šã§å€ãèŠã€ããŠãã埩å·ããŠããŸããã
ããããã°ã鵿
å ±ãç§å¯ã«ã§ããŸããããå®å
šãªéä¿¡ãè¡ãããšããããã§ãã
ä¹±æ°è¡šã䜿ã£ãæå·éä¿¡ã§ã¯ãåãéµãäœåºŠã䜿ããªãæ¹æ³ïŒäŸãã°æ¥ä»ãå
ã«ä¹±æ°è¡šããå€ãæŸããªã©ïŒã§åãéµã®éè€å©çšãé¿ããŠããŸããã
ã¯ã³ã¿ã€ã ãã¹ã¯ãŒããåããã¹ã¯ãŒããäœåºŠã䜿ããªãããã«ããŠããã¹ã¯ãŒããçãŸããŠã倧äžå€«ã ãšããçºæ³ã§ãã®ã§ãä¹±æ°è¡šãã¯ã³ã¿ã€ã ãã¹ã¯ãŒããèãã®ããŒã¹ã¯åãã§ãã
ãã ããä¹±æ°è¡šã«ã¯å€§ããªåé¡ããããŸããã
ãïŒïŒæå·åããåŽãšåŸ©å·ããåŽãåãä¹±æ°è¡šãæã£ãŠããªããã°ãªããªã
ãïŒïŒä¹±æ°è¡šã¯æµã«ãã¬ããšã¢ãŠããªã®ã§æ¯æã®ããã«æ¹èšãå¿
èŠã
ãïŒïŒçãŸããªãããã®ç®¡çã倧å€
ã峿¹ã®éã§éµã¯å
±æããŠããããæµã«ã¯ç¥ãããŠããªãããšããç¶æ³ãå®çŸããã®ã¯å€§å€ã ã£ãããã§ãã
çŸåšã§ã¯ãéµäº€æãšããä»çµã¿ãçºæãããéµãçãŸããã«å®å
šã«äº€æããææ³ããããŸããéµäº€æã«ã€ããŠèå³ã®ããæ¹ã¯ä»¥äžã®ããã¯ãã³ããŒããåç
§ãã ããã
3. åæã®ã¯ã³ã¿ã€ã ãã¹ã¯ãŒã
ã¯ã³ã¿ã€ã ãã¹ã¯ãŒãã®äžçªåæ©çãªä»çµã¿ã¯ãä¹±æ°è¡šãçžæã«æž¡ããŠããæ¹æ³ã§ãã
å®éãçè
ãåæã®(2000幎é ã ãšæããŸãïŒãªã³ã©ã€ã³ãã³ãã³ã°ã§ãã®ææ³ã䜿ã£ããµãŒãã¹ã䜿ã£ãŠããŸããã
ãµãŒãã¹ç³èŸŒã¿ããããšãå
æ¹ããéãããŠããæ¡å
æžé¡ã«ããã¹ã¯ãŒã衚ããå
¥ã£ãŠããŸãããã®ãã¹ã¯ãŒã衚ã¯å°ããªè¡šåœ¢åŒã®çŽã§ãçžŠãšæšªã«Excelã®ãããªåå(AïœG)ãšè¡å(1ïœ7)ãä»ããŠãããåã»ã«ã«ã¯ïŒã±ã¿ã®æåãæžããŠãããŸãã
ãã®ãµãŒãã¹ã®å©çšæã«ã¯æåã«IDãšãã¹ã¯ãŒãïŒäžè¬çãªãã¹ã¯ãŒãïŒãæ±ããããŸããããããšãªããšãç»é¢äžã«ã¯ã»ã«çªå·ïŒB3ãF2ïŒã衚瀺ãããã®ã§ããã¹ã¯ãŒã衚ããã®ãã®ã»ã«ã«æžããŠããå€ãå
¥åããŸãã
ãã®å€ãåã£ãŠããã°ç¡äºãã°ã€ã³ãã§ããããã§ããããã¯äžè¿°ã®ä¹±æ°è¡šãšå
šãåãã§ãã
ããå°ãåŸã«ãªããšããã®ãã¹ã¯ãŒã衚ãã¯ã³ã¿ã€ã ãã¹ã¯ãŒãæ¹åŒã«ãªããŸããã
ã
ã¯ã³ã¿ã€ã ãã¹ã¯ãŒãæ¹åŒã§ã¯ããã¹ã¯ãŒã衚ã§ã¯ãªãããã¹ã¯ãŒãã100åãšããããŒã£ãšäžŠãã ãã¹ã¯ãŒãäžèЧã«ãªããŸãã
äœ¿ãæ¹ã¯ç°¡åã§ããæåã«IDãšãã¹ã¯ãŒãïŒäžè¬çãªãã¹ã¯ãŒãïŒãå
¥åããŸãããããã®å Žåã¯ãã¯ã³ã¿ã€ã ãã¹ã¯ãŒãã®å
¥åãæ±ããããŸãã
ããã§ããã¹ã¯ãŒãäžèЧãèŠãŠãååãã°ã€ã³æãªãïŒã€ç®ã®ã¯ã³ã¿ã€ã ãã¹ã¯ãŒããïŒåç®ã¯ïŒã€ç®ã®ããã®æ¬¡ã¯ïŒã€ç®ãå
¥åããŸãã
ãããæ£ãããã°ããã°ã€ã³ãã§ãããšããããã§ãã
ãããŸã§èªãã§ãããïŒããã£ãŠäºèŠçŽ èªèšŒãšåãïŒããšæã£ãæ¹ããããããšæããŸãããŸãã«ãã®éãã§ããã®æä»£ã®ã¯ã³ã¿ã€ã ãã¹ã¯ãŒããšããã®ã¯å€èŠçŽ èªèšŒïŒäºèŠçŽ èªèšŒïŒã®å圢ã ãšæããŸãã
ã§ããããã®åæåã¯ã³ã¿ã€ã ãã¹ã¯ãŒãã¯ä¹±æ°è¡šãšåãã§éçšãéåžžã«é¢åã§ããã
ãã¹ã¯ãŒãäžèЧãçŽå€±ããããå
šãŠã®ã¯ã³ã¿ã€ã ãã¹ã¯ãŒãã䜿ãåããšãµãŒãã¹ãå©çšã§ããªããªããŸãã
å€åºæã«ãã¹ã¯ãŒãäžèЧãæå
ã«ãªããšãµãŒãã¹ãå©çšã§ããŸããã
è身ã¯ãªããããã¹ã¯ãŒãäžèЧãæã¡æ©ããšããã®ã¯ããªãäžäŸ¿ã§ãã
ãŸããã¯ã³ã¿ã€ã ãã¹ã¯ãŒãã¯äžåºŠããæå¹ã§ã¯ãããŸãããããæ¬¡åãã°ã€ã³æã«äœ¿ããã¯ã³ã¿ã€ã ãã¹ã¯ãŒããã©ããã¯å©çšè
èªèº«ã§ç®¡çããªããšãããŸããã
4. 次äžä»£ã®ã¯ã³ã¿ã€ã ãã¹ã¯ãŒã
ãããã«åæã®ã¯ã³ã¿ã€ã ãã¹ã¯ãŒãã¯äžäŸ¿ã ã£ããããæ®åã«ã¯è³ããŸããã§ããã
次ã«åºãŠããã®ã¯ãã¯ã³ã¿ã€ã ãã¹ã¯ãŒãå°çšã®å°ããªæ©åšã§ãããã¯ã³ã¿ã€ã ãã¹ã¯ãŒãããŒã¯ã³ãªã©ãšåŒã°ãããã®ã§ãã
ããã¯ããŒãã«ããŒã«çãããããããã®å°ããªããã€ã¹ã§ãã¿ã³ãšæ°æ¡ã®æåã衚瀺ã§ããæ¶²æ¶ãã£ã¹ãã¬ã€ãä»ããŠããŸããã
ãã¿ã³ãæŒããšæ¬¡ã«äœ¿ããã¯ã³ã¿ã€ã ãã¹ã¯ãŒãã衚瀺ãããã®ã§ããããå
¥åããã°èªèšŒãåŸãããä»çµã¿ã§ãã
ãã¹ã¯ãŒãäžèЧããã¯ã¯ããã«æã¡æ©ãããããªããŸããã®ã§ããã®æ¹åŒã¯ä»ãå
¥å®€ç®¡çãªã©ã«äœ¿ãããŠããŸãã
ãã®æ©åšïŒããŒã¯ã³ïŒã«ã¯å°ããªã³ã³ãã¥ãŒã¿ãå
¥ã£ãŠããŸãã
ããŒã¯ã³ã«ã¯æ°çŸæ¡çšåºŠã®å·šå€§ãªæ°å€ã鵿
å ±ãšããŠæ ŒçŽãããŠããŸãããã®å€ã¯ããŒã¯ã³ããšã«ç°ãªããŸãã
ãŸããä»ãŸã§ã«ãã¿ã³ãæŒããåæ°ïŒäœ¿çšåæ°ïŒãå
éšã«æã£ãŠããŸãã
ãããŠããã¿ã³ãæŒããããšããã®ïŒã€ã®å€ã䜿ã£ãŠã¯ã³ã¿ã€ã ãã¹ã¯ãŒããèšç®ããä»çµã¿ã§ãã
ã¯ã³ã¿ã€ã ãã¹ã¯ãŒããåãä»ããæ©åšåŽãåã鵿
å ±ãšäœ¿çšåæ°ããåãæé ã§èšç®ãè¡ããŸãã
ãããŠãäž¡è
ã®çããäžèŽããŠããã°èªèšŒïŒ¯ïŒ«ãšå€æããããã§ãã
5. ããŒã¬ã¹ãšã³ããªãŒã§ã®å·¥å€«
åå解説ããã¯ã«ãã®ããŒã¬ã¹ãšã³ããªãŒã¯äžè¿°ã®ã¯ã³ã¿ã€ã ãã¹ã¯ãŒããããäžã²ãããã圢ã§å©çšããŠããŸãã
ãŸããããŒã¬ã¹ãšã³ããªãŒã§ã¯çæãããã¹ã¯ãŒãã衚瀺ãããã¯ãããçŽæ¥ã¯ã«ãã«å¯ŸããŠãã®å€ãéä¿¡ã§éã蟌ã¿ãŸãã
ã¯ã«ãã®åŽãåãèšç®ãè¡ã£ãŠéãããŠããå€ãæ¯èŒããŠçµæãäžèŽããŠããã°ããã¯è§£é€ããããã§ãã
ããããããã§å°ã£ãåé¡ãèµ·ããŸãã
ã¯ã«ãã®ããŒã§ããããŒã¯ã³ã§ããã¿ã³ãæŒããšããè¡çºã«ãã£ãŠäœ¿çšåæ°ãå¢ãããŠãããŸãã
ã§ããããã±ããã®äžãã«ãã³ã®äžã«ããŒã¯ã³ãå
¥ããŠãããšãã¯ã«ããšé ãé¢ããå Žæã§ééã£ãŠãã¿ã³ãæŒãããŠããŸãå ŽåããããŸãã
ããŒãããŒã¯ã³åŽã¯ã¯ã«ããè¿ãã«ãããã©ãã倿ã§ããŸããããã䜿çšåæ°ãå¢ãããŠããŸããŸãã
ã§ãããã¯ã«ãåŽã¯ãããªäºæ
ç¥ããŸãããããã¯ã«ãåŽãèªèããŠãã䜿çšåæ°ãšããŒãããŒã¯ã³åŽã®äœ¿çšåæ°ã«é£ãéããçããŸãã
ã¯ã«ããšããŒã¯ã³ã§åæ°èªèãéã£ãŠããã°ãèšç®ã®çµæåŸããããã¹ã¯ãŒããäžèŽããŸããã
äžèŽããªããã°ããã°ã€ã³ãããã¯è§£é€ã倱æããŠããŸããŸãã
ããã§ã¯äœ¿ããã®ã«ãªããŸããã
ãã®ãããªãã©ãã«ãé²ããããå®éã®ã·ã¹ãã ã§ã¯ã¡ãã£ãšãã工倫ãããŠããŸãã
èªèšŒããåŽïŒãã°ã€ã³ãµãŒããã¯ã«ãïŒã¯éåžžéãã®èšç®çµæãšããŒã¯ã³åŽã®çµæãéã£ãŠããå Žåã¯ãã²ãã£ãšããŠå©çšåæ°ã®èªèããºã¬ãŠããã®ã§ã¯ïŒããšèããæ¬¡ååã®èšç®ãããŠåæ¯èŒãè¡ããŸããããã§ããã¡ãªãããã«æ¬¡ã®åãšãè€æ°ååã®ãã¹ã¯ãŒãã§ã®æ¯èŒãè¡ãã®ã§ãã
ãã®åèšç®åŠçã¯ãã¹ã¯ãŒãã®é£ãéãã«å¯Ÿããææžæªçœ®ã®ãããªãã®ã§ãã
å®éã«äœååãæ±ããã®ãã¯ã·ã¹ãã ã«ãã£ãŠãŸã¡ãŸã¡ã§ããã10åããããã©ã€ãããã®ãå€ãããã§ãããªããåèšç®ãå«ããŠããªç§åäœã®è©±ã§ãã®ã§ãåèšç®ã«ãã£ãŠåå¿ãé
ããªã£ããããããã§ã¯ãããŸããã
6. ãŸãšã
çŸä»£ã®æå·åéä¿¡ã§ã¯éµäº€æãšããã·ã¹ãã ã䜿ã£ãŠãå®å
šã«éµã®ãããšããè¡ããããã«ãªã£ãŠããŸãã
ãã®ä»çµã¿ããªãæä»£ã«ã¯åãä¹±æ°è¡šãéä¿¡ãšåä¿¡ã®åæ¹ã§äœ¿ãæ¹åŒãäžè¬çã§ããã
ãã®èãæ¹ã®å¿çšãšããŠã¯ã³ã¿ã€ã ãã¹ã¯ãŒãæ¹åŒãšãããã®ããããŸãã
ããã¯ãç§å¯æ
å ±ãšäœ¿çšåæ°ã®ïŒã€ã䜿ã£ãŠæ¯åç°ãªããã¹ã¯ãŒããæ±ããæ¹åŒã§ãã
ããã§ãååãšåæ§ã«ãã¹ã¯ãŒãã®çæã«ã¯ããã·ã¥é¢æ°ãšãããã®ã䜿ããŸãã
ããã·ã¥é¢æ°ã«ãèå³ã®ããæ¹ã¯ä»¥äžã®ããã¯ãã³ããŒãã©ããã
ããŒã¬ã¹ãšã³ããªãŒãã¯ã³ã¿ã€ã ãã¹ã¯ãŒãããŒã¯ã³ã§ã¯ãã¿ã³ã®æŒãééããªã©ã«ãã£ãŠãã¯ã«ãåŽãæã£ãŠããå©çšåæ°ïŒããŒããã¯è§£é€åæ°ããã°ã€ã³åæ°ïŒãšããŒåŽã®åæ°ããºã¬ãŠããŸãããšããããŸãã
ãããã£ãå Žåã¯å©äŸ¿æ§ãèããèªèšŒããåŽïŒãã°ã€ã³ãµãŒããã¯ã«ãïŒã¯äœåãå
ã®ãã¹ã¯ãŒããŸã§èšç®ãããããã§ãã¹ã¯ãŒããåèŽããããã§ããã°ïŒ¯ïŒ«ãšããä»çµã¿ãçµã¿èŸŒãŸããŠããŸãã
ãã®å·¥å€«ã«ãã£ãŠãèªèšŒãšã©ãŒã®çºçãæãã€ã€ãå®å
šæ§ã確ä¿ããŠããããã§ãã
ä»åã¯ã¯ã³ã¿ã€ã ãã¹ã¯ãŒãæ¹åŒã«ã€ããŠè§£èª¬ãããŸããã
次åããæ¥œãã¿ã«ã
ïŒæ¬çš¿ã¯ 2022幎12æã«äœæããŸããïŒ
