ã¡ãã£ã¢èšäº
æ°æœçããŒã¿10äžä»¶æ¶å€±äºæ
ãæ¡åŒµåãå°æåã«ãããã£ãã®ã¯ãªãããçã«èãã
ããºãææ° 131 ããŒã¯ 415
twitterã³ã¡ã³ã 449ä»¶äž 101ïœ200件
ïŒããã¯ã¢ããæéã3æ¥éã«å®ããçç±ã«ã€ããŠã¯ãäžæãïŒæ°æœçïŒ
å€éãäœãšèšãããæ確ãªçç±ããããªãåœäºè éã®åé¡ã ããã©ãã§ãããã...ããã¯ãªã
å€éãäœãšèšãããæ確ãªçç±ããããªãåœäºè éã®åé¡ã ããã©ãã§ãããã...ããã¯ãªã
ãã³ã°ãªãç¡èœ
ããŒã¿åé€ããã°ã©ã ã¯ãç»é²ããããã¡ã€ã«ã®ãªã¹ããåç
§ããŠãªã¹ãã«ãªããã¡ã€ã«ãåé€ããä»çµã¿ã ãšãããæ°æ©èœã«ããæ¡åŒµåãå€æãããããšã§ã該åœãã¡ã€ã«ã®ååããªã¹ãã«èšèŒãããŠããªãããšã«ãªãã10äžä»¶ã®ããŒã¿ãåé€ããããšããŠããã
ã¯ããMS-DOSã«ãªã£ãŠãã倧æåå°æåã®åºå¥ãªããªã£ãŠæ¥œã ïœãšæã£ãããã ãã©ãN88-BASICããïœ
ãç§ã®æ³åã
çæ åœãæ¡åŒµåã¯æ®éå°æåããã俺ã®ãã¯ãåããžãã®ã¯ãåãã®ä»æ§ããããããã¡ãããïŒä»æ§æžã«æèšãããŠãªãããïŒã
æ¥è ïŒåè«ãèŸãããç¡åã§ããã£ãšå¯Ÿå¿ãããïŒ
çæ åœãæ¡åŒµåã¯æ®éå°æåããã俺ã®ãã¯ãåããžãã®ã¯ãåãã®ä»æ§ããããããã¡ãããïŒä»æ§æžã«æèšãããŠãªãããïŒã
æ¥è ïŒåè«ãèŸãããç¡åã§ããã£ãšå¯Ÿå¿ãããïŒ
SIã®ããã©ãæããè©°ãŸã£ãŠããã
ããããã®ããããããITã¯æãã
é害ãªããŠãã»ãã®äºçŽ°ãªããšãããçºçãããã ãã
é害ãªããŠãã»ãã®äºçŽ°ãªããšãããçºçãããã ãã
âç»é²ããããã¡ã€ã«ã®ãªã¹ããåç
§ããŠãªã¹ãã«ãªããã¡ã€ã«ãåé€ããä»çµã¿ã ãšãããæ°æ©èœã«ããæ¡åŒµåãå€æãããããšã§ã該åœãã¡ã€ã«ã®ååããªã¹ãã«èšèŒãããŠããªãããšã«ãªãã10äžä»¶ã®ããŒã¿ãåé€ãããâ
ããããéããŠæ³£ãã
ããããéããŠæ³£ãã
èªãã§ãéäžã ãã©ããç»å Žäººç©å
šå¡ã¯ãºãã¿ãããªæãã§ãç»å Žããã·ã¹ãã å
šéšãã¡ããªã®ã§è¿«åããã
æ¡åŒµåã倧æåãªã®ã¯ãã¢ããè
âãªã〠ãªããšãªãæ¡åŒµåã¯å°æåãåºæ¬ã ãšæã£ãŠããã§ãããããã§ãªãäžçããããã§ããã
âäžæ¹ãå ¬ææžç®¡çã·ã¹ãã ã®ä»æ§ã§ã¯æ¡åŒµåã倧æåãšããã®ãæšæºã«ãªã£ãŠãããâ
âäžæ¹ãå ¬ææžç®¡çã·ã¹ãã ã®ä»æ§ã§ã¯æ¡åŒµåã倧æåãšããã®ãæšæºã«ãªã£ãŠãããâ
ããããã²ã©ãäºäŸã
ã·ã¹ãã ããã¯ãã«åãããããšããªã
ãŠã什åã«ãã¯ãâŠ
ãŠã什åã«ãã¯ãâŠ
ããŒããã€ã³ãã©ãèšèªãé²åããŠããèšèšããŠå®è£
ãã人éãçžå€ããããªãã©ããããããªãããª
ïŒçã§ã¯ãããŒã¿ã®éèšäœæ¥ã®ããã«ãã¯ãä»ã®Excelã䜿çšããŠãããšããããã®ãã¯ãã¯æ¡åŒµåãå°æåã§ãªããšæ£åžžã«åäœããªãä»æ§ã ã£ãã
ã©ãããä»æ§ïŒïŒïŒ
ã©ãããä»æ§ïŒïŒïŒ
ãã©ã¯ãš3ãã
çã«ãããšãããŒã¿åé€ããã°ã©ã ã¯ãç»é²ããããã¡ã€ã«ã®ãªã¹ããåç §ããŠãªã¹ãã«ãªããã¡ã€ã«ãåé€ããä»çµã¿ã ãšãããæ°æ©èœã«ããæ¡åŒµåãå€æãããããšã§ã該åœãã¡ã€ã«ã®ååããªã¹ãã«èšèŒãããŠããªãããšã«ãªãã10äžä»¶ã®ããŒã¿ãåé€ããã
çã«ãããšãããŒã¿åé€ããã°ã©ã ã¯ãç»é²ããããã¡ã€ã«ã®ãªã¹ããåç §ããŠãªã¹ãã«ãªããã¡ã€ã«ãåé€ããä»çµã¿ã ãšãããæ°æ©èœã«ããæ¡åŒµåãå€æãããããšã§ã該åœãã¡ã€ã«ã®ååããªã¹ãã«èšèŒãããŠããªãããšã«ãªãã10äžä»¶ã®ããŒã¿ãåé€ããã
ãããçã®æ
åœè
ã«VBAãèªãã人ãããã°ãããŸã§ã®æšäºã«ã¯ãªããªãã£ãæ°ããããããšãVBAã§ã®æäœã¯ãæ»ããã䜿ããªããããããŸãã«ããã¯ã¢ãããåã£ãããã¹ãããããâŠ
ç¥ããªãã£ãð¯ïŒïŒ
MS-DOSãšãã®åæ®ããªãã
ãå ¬ææžç®¡çã·ã¹ãã ã®ä»æ§ã§ã¯æ¡åŒµåã倧æåãšããã®ãæšæºã«ãªã£ãŠãããã
MS-DOSãšãã®åæ®ããªãã
ãå ¬ææžç®¡çã·ã¹ãã ã®ä»æ§ã§ã¯æ¡åŒµåã倧æåãšããã®ãæšæºã«ãªã£ãŠãããã
è²ã
ãšå¯Ÿå¿ãéãšããããæ°æ©èœè¿œå ã«äŒŽãæ€èšŒãã¹ãã¯ããªãã£ãã®ã¯ãªãã§ã ããããŠãªãããã¯ã¢ããããã£ã3æ¥ãè¡æ¿ããŒã¿ãæ±ã£ãŠããšã¯æããªãã»ã©ãéãâ
ãç²æ«æå€ã®äœè
ã§ããªããªã
å¿ èŠã«è¿«ãããŠå¯Ÿå¿ãããã ãããããå¿ èŠãªæç¶ãããè¡ã£ãŠããªãã®ãªãåé¡ã ãããªãŒã
ãšã¯ãããæ¥åžžè¶é£¯äºãªãäœãšãæããªããããã
å¿ èŠã«è¿«ãããŠå¯Ÿå¿ãããã ãããããå¿ èŠãªæç¶ãããè¡ã£ãŠããªãã®ãªãåé¡ã ãããªãŒã
ãšã¯ãããæ¥åžžè¶é£¯äºãªãäœãšãæããªããããã
ç§èŠã ãITæ¥çã«ã¯ãããã£ããã©ãã«ãæªç¶ã«é²ãã ããŒããŒã倧å¢ãããšæã£ãŠããããããŠãã®ããŒããŒã®å€§åã¯æ£åœã«è©äŸ¡ãããŠãªããé²ãã§åœããåãšèšãèšèã¯æè¬ã®å¿ãæ¬ åŠããŠãã蚌æ (ããŒããŒèªãããåœããåããšããã®ã¯è¯ããäœãä»äººã«ã¯äœ¿ããªã)
ããŒã¿åé€ããã°ã©ã ãããæ®ããã¡ã€ã«ã決å®ããããããªããŠãæ¶ããã¡ã€ã«ã決å®ãããšããæ¯æ1000ãã¡ã€ã«ãã€æ¶ããšããæãåŸãªããã¡ã€ã«æ°ã ã£ãããšã©ãŒãåºããšãããã
ããããããããã»ããšâŠããæ¯ããåºãŠããªãã
話ã®ã¬ãã«ãäœããã
話ã®ã¬ãã«ãäœããã
æ°æœçããŒã¿10äžä»¶æ¶å€±äºæ
æ°æœçã§4æ9æ¥ãå ¬ææžç®¡çã·ã¹ãã ã«ç»é²ããå ¬ææžããŒã¿çŽ10äžä»¶ãæ¶å€±ããäºæ ãçºçãããçã«ãããšãã·ã¹ãã ä¿å®ãæ åœããŠããäºæ¥è ãããã¡ã€ã«ã®æ¡åŒµåãå°æåã«ããæ°æ©èœãè¿œå ããããšãäºæ ã®äžå ã
æ°æœçã§4æ9æ¥ãå ¬ææžç®¡çã·ã¹ãã ã«ç»é²ããå ¬ææžããŒã¿çŽ10äžä»¶ãæ¶å€±ããäºæ ãçºçãããçã«ãããšãã·ã¹ãã ä¿å®ãæ åœããŠããäºæ¥è ãããã¡ã€ã«ã®æ¡åŒµåãå°æåã«ããæ°æ©èœãè¿œå ããããšãäºæ ã®äžå ã
EXCELãã¯ããå°æåæ¡åŒµåæ³å®ã ã£ãããã·ã¹ãã åŽã§å€æãããšãã§å¥ã®ãã¡ã€ã«åé€åŠçã§ãªã¹ããšã®çªåã§å€§æåå°æåã®çžéã§å
šéšã§å
šæ¶ãâŠãçŸå Žç«ãïŒ
ããåŸãªãããŒã
æ åœè ã¯ãæ¡åŒµåã倧æåã ãšãã¯ãã§äœ¿ããªãããå šãã¡ã€ã«å°æåã«ãã¡ãããŒãã£ãŠããªã ã£ããšæãã
ããŒã¿åé€ããã°ã©ã ã®äœããåé¡ã§ããã
æ åœè ã¯ãæ¡åŒµåã倧æåã ãšãã¯ãã§äœ¿ããªãããå šãã¡ã€ã«å°æåã«ãã¡ãããŒãã£ãŠããªã ã£ããšæãã
ããŒã¿åé€ããã°ã©ã ã®äœããåé¡ã§ããã
ãç»é²ããããã¡ã€ã«ã®ãªã¹ããåç
§ããŠãªã¹ãã«ãªããã¡ã€ã«ãåé€ããä»çµã¿ãããåé€åŠçãšããŠå±ãªãæ°ããããã ãã©w
ãåŠçæžã¿ãã¡ã€ã«ãªã¹ããåç §ããŠåé€ãã«ããããª
ãåŠçæžã¿ãã¡ã€ã«ãªã¹ããåç §ããŠåé€ãã«ããããª
çè·å¡ããããããªãšããã«ç®ãã€ããããªãã
å€æã§ããã°ããã§ãããšã¯æããã®ãã
å€æã§ããã°ããã§ãããšã¯æããã®ãã
ïŒçã§ã¯ãããŒã¿ã®éèšäœæ¥ã®ããã«ãã¯ãä»ã®Excelã䜿çšããŠãããšããããã®ãã¯ãã¯æ¡åŒµåãå°æåã§ãªããšæ£åžžã«åäœããªãä»æ§ã ã£ããäžæ¹ãå
¬ææžç®¡çã·ã¹ãã ã®ä»æ§ã§ã¯æ¡åŒµåã倧æåãšããã®ãæšæºã«ãªã£ãŠããã
script 㧠filter äœã£ãŠpipe ã§æµãã°æžãã
script 㧠filter äœã£ãŠpipe ã§æµãã°æžãã
æäœãã¹ã«ããæ
å ±æ¶å€±äºæ
ã®äºäŸã§ãã
ããŒã¿ã¯1件ã§ã10äžä»¶ã§ãçããåãæ±ãããŸãã
åãæ±ãããŒã¿ã®ã©ã³ã¯ããã£ããææ¡ããããã¯ã¢ããã»ãã¥ãŒãã³ãšã©ãŒåé¿ãªã©äžå šã®èšèšã»ç¹æ€ãå¿ èŠã«ãªããŸãã
ããŒã¿ã¯1件ã§ã10äžä»¶ã§ãçããåãæ±ãããŸãã
åãæ±ãããŒã¿ã®ã©ã³ã¯ããã£ããææ¡ããããã¯ã¢ããã»ãã¥ãŒãã³ãšã©ãŒåé¿ãªã©äžå šã®èšèšã»ç¹æ€ãå¿ èŠã«ãªããŸãã
ããã§ãã¯ããæªè
ã«ããªãã§ã»ããã
管çäžè¡ãå±ããšã¹ãã«ã®ç¡ããåé¡ã
管çäžè¡ãå±ããšã¹ãã«ã®ç¡ããåé¡ã
çŸå Žã®æèŠãæ ¹æ°ããèãç¶ããçµæãšèªã¿åã£ãã
ãªãã€ãŒããæžããç¬ãããåºãŠããã
ãªããããããªããã·ã¹ãã 管çã§1ã€ã倱æããããšãªã人ãé£æºããŠå€±æãããããªè©±ã
çã®æ
åœè
ãå¯å£«é»æ©ITãœãªã¥ãŒã·ã§ã³ã®æ
åœè
ããã«ãWindowsã®ãã¡ã€ã«ã·ã¹ãã ä»æ§ãããé ã«å
¥ããšãããèšãããããäœããŸãããã§ã¯ãã¬ãã®äœ¿ãããšããæããªãã
ã©ããããããããããããExcelã®ãã¯ããäžçªé
·ãããã«æããããŸããã¯ãçŽããŠãå€ãã®äœ¿ãç¶ããã®ãåºããããŠé¢åãªãã ãããª
ãã£ã3æ¥ããããã¯ã¢ããåã£ãŠãªãã®ããw
ããããã®ã£ãŠã©ãã ãå°ãªããŠã1é±éã¯åã£ãŠããããããªãã®ïŒ
æµç³ã«ã±ããããã ã
ããããã®ã£ãŠã©ãã ãå°ãªããŠã1é±éã¯åã£ãŠããããããªãã®ïŒ
æµç³ã«ã±ããããã ã
ãŸã£ãŠã
æ¡åŒµåã«å€§æå䜿ãã£ãŠãããã
ãç²æ«ãããŠäœã«ããããããw
æ¡åŒµåã«å€§æå䜿ãã£ãŠãããã
ãç²æ«ãããŠäœã«ããããããw
ä»æ§ãå®è£
ããªããè²ã
ããµããã§ãããããåŠçèãã¡ãã人å°ãªããªããã ããããã
å
¬ææžç®¡çã·ã¹ãã ã®ä»æ§ã§ã¯æ¡åŒµåã倧æåãšããã®ãæšæºã«ãªã£ãŠããã
ä»æ§ãããããããªããð€
ä»æ§ãããããããªããð€
ãããšãããããã°ã©ã çã«ã¯å€§æåã ãããšå°æåã ãããšæ£åžžã«åãã¹ãã ãšæãã®ã¯ä»æ§ãå®ã£ãŠããªãããšã«ãªã£ãŠããŸããã§ããããïŒ
ã»ãã¯ãã«ã·ã¹ãã ãåããããšããæŽæ
ã»æ°æ©èœãéçšãã¹ãã©ããã瀟å 審æ»ãéã£ãŠããªããã®ãå³æ¬çªã§äœ¿ããšããçä¹±
ã»èå¿ãªæµãã®æ±ºå®ã«ã€ããŠã¯å šãŠãäžæããšããéïŒ
ã»æ°æ©èœãéçšãã¹ãã©ããã瀟å 審æ»ãéã£ãŠããªããã®ãå³æ¬çªã§äœ¿ããšããçä¹±
ã»èå¿ãªæµãã®æ±ºå®ã«ã€ããŠã¯å šãŠãäžæããšããéïŒ
ããã¯ã¢ããã3æ¥ãšããã¢ããããããªïœ
ãã°ããããããã©ãããªãã
èšèšããéçšããéçºç°å¢ãããæç§æžã«ã§ãèŒããŠããŸããªã°ãã°ãæ
ãåé€ããªããã¡ã€ã«ãã管çããŠãããããé ããæ©ãã䌌ããããªäºè±¡ãèµ·ãã£ããããªæ°ããã
ãåé€ããªããã¡ã€ã«ãã管çããŠãããããé ããæ©ãã䌌ããããªäºè±¡ãèµ·ãã£ããããªæ°ããã
é¢ä¿ç¡ããã©AIã«ããã°ã©ã äœããããåæ§ã®äºæ
å¢ãããã
ããåããªã«èããŠãã®ïŒïŒã
ã£ãŠããã°ã©ã æžããããããã€ãã
ããåããªã«èããŠãã®ïŒïŒã
ã£ãŠããã°ã©ã æžããããããã€ãã
æ¡åŒµåãå°æåã«ããªããšåäœããªããã¯ã
VS
æ¡åŒµåãå°æåã ãšåé€ããã·ã¹ãã
ã§ããã«ãã£ããåŸè ãåã£ããšããå¯è©±ã ã£ããšãããã§äŒãããã£ãã®ã¯ã©ãããããšãã
VS
æ¡åŒµåãå°æåã ãšåé€ããã·ã¹ãã
ã§ããã«ãã£ããåŸè ãåã£ããšããå¯è©±ã ã£ããšãããã§äŒãããã£ãã®ã¯ã©ãããããšãã
ãæçµçã«ã¯æ¡åŒµåãå°æåã«å€æŽããããšã«ãªããçµæãšããŠãã¡ã€ã«ãæ¶å»ããããã
ãããã¯ã¢ããæéã3æ¥éã«å®ããçç±ã«ã€ããŠã¯ãäžæãïŒæ°æœçïŒã
ããŸæ°æœãã¢ããïŒ
ãããã¯ã¢ããæéã3æ¥éã«å®ããçç±ã«ã€ããŠã¯ãäžæãïŒæ°æœçïŒã
ããŸæ°æœãã¢ããïŒ
ãäžæ¹ãå
¬ææžç®¡çã·ã¹ãã ã®ä»æ§ã§ã¯æ¡åŒµåã倧æåãšããã®ãæšæºã«ãªã£ãŠããã
ãªãã§éåžžã§ã¯ããããªãèšå®ã«ãããã§ãããã
ãªãã§éåžžã§ã¯ããããªãèšå®ã«ãããã§ãããã
é§ç®ã®ãªã³ãã¬ãŒãã§ããã¯ãªããŸããã
>çã§ã¯ãããŒã¿ã®éèšäœæ¥ã®ããã«ãã¯ãä»ã®Excelã䜿çšããŠãããšããããã®ãã¯ãã¯æ¡åŒµåãå°æåã§ãªããšæ£åžžã«åäœããªãä»æ§ã ã£ãã
âŠâŠããéè¯ãã¯ãã ã£ãã®ã§ã¯ïŒãšããæ°ããããª
âŠâŠããéè¯ãã¯ãã ã£ãã®ã§ã¯ïŒãšããæ°ããããª
ãã¯ãçŽãã°æžãã 話ãªã®ã«ãçŽã人ãããªã
ãçã§ã¯ãããŒã¿ã®éèšäœæ¥ã®ããã«ãã¯ãä»ã®Excelã䜿çšããŠãããšããããã®ãã¯ãã¯æ¡åŒµåãå°æåã§ãªããšæ£åžžã«åäœããªãä»æ§ã ã£ãã
ãçã§ã¯ãããŒã¿ã®éèšäœæ¥ã®ããã«ãã¯ãä»ã®Excelã䜿çšããŠãããšããããã®ãã¯ãã¯æ¡åŒµåãå°æåã§ãªããšæ£åžžã«åäœããªãä»æ§ã ã£ãã
ãªãã«ããŠããææ°ãšèšãããŠãä»æ¹ããªããç²æ«ãªé¡æ«ããªããšããããªãããšèšãããŠããŸãã°ããã ãã©ã
æ¢åããŒã¿ã®æžãæãã¯å±éºäœæ¥ãªã®ã§åºæ¥ãã°é¿ããããšãããä»åãªãã°åŠçç³»ã®Excelãã¯ããæ¹è¯ã§ããã°ããã£ãã®ã ãããããŠWindowsç³»ã¯ãã¡ã€ã«ã®å€§æåå°æåãåºå¥ããªããšããã«åºå¥ã§ããããã«ãããã®ã ããããã®æã®äºçŽ°ãªãšããã§åé¡ãåŒãèµ·ããã
èŠä»¶ãå®æœå
容ããã¹ãŠãæå³äžæ
ãçç±ã¯é¢ä¿ãªããåé¡ã¯å€±æããããšã ããªããã¹ãã審æ»ãªã©ãããæ©èœè¿œå ãè¡ã£ãã®ããã«å°œããæ°ããããå人ã®PCã§ã¯èµ·ãããã¡ãªäºæ
ã ãããªãããããããã«ãïŒ
ããã³ãæãå€éããŠã©ãããããã³ãã ããããããããäºæ¡ã ãã©ãå°æåãã察å¿ããŠãªãExcelãã¯ãã䜿ããããããã«ãã¹ã¿ãŒã®ãã¡ã€ã«åã®æ¹ãäžæ¬çœ®æããã£ãŠçºæ³ããŸãã¹ãŽã
ä¹
ãã¶ãã«ããããªå€±æã«æ¯ã¹ãããç§ã®å€±æã¯å°ããå°ããïŒããšããæ¡ä»¶ãåºãŠããŠå¿ã軜ããªã£ãŠããŠãïœ
ãã¯ããšææžç®¡çã·ã¹ãã ã®ã©ã¡ããæ¹ä¿®ããã®ãè¯ããã®æ¯éã¯äžæŠçœ®ããšããŠãææžç®¡çã·ã¹ãã ãæ¹ä¿®ããã«ããã£ãŠãéãçºçããŠãªãããã«èªãããã ãã©âŠ
ïŒãªãæ¡åŒµåãå°æåã«ãããã£ãã®ã
ïŒãã¯ãä»ã®Excelã䜿çš
ïŒãã¯ãã¯æ¡åŒµåãå°æåã§ãªããšæ£åžžã«åäœããªã
ïŒå ¬ææžç®¡çã·ã¹ãã ã®ä»æ§ã§ã¯æ¡åŒµåã倧æåãšããã®ãæšæº
ïŒãã¯ãä»ã®Excelã䜿çš
ïŒãã¯ãã¯æ¡åŒµåãå°æåã§ãªããšæ£åžžã«åäœããªã
ïŒå ¬ææžç®¡çã·ã¹ãã ã®ä»æ§ã§ã¯æ¡åŒµåã倧æåãšããã®ãæšæº
ãããã²ã©ã
(ŽÏ`;)
EUCã£ãœãããŒã«ãããŒã¿ã¯ã¬ã³ãžã³ã°ã»åå¯ã管çã§ããŠãªãã·ã¹ãã ãšãç¡æ°ã«åé¡ç¹ã¯ãããã©
ITILã§ãããšããã®å€æŽã»ãªãªãŒã¹ã»å±é管çãå šããªãããŠãªãã®ãåå ã ã
ããã ãã¶ã«ã ãšéã«æªæãã奎ã«å©çšãããªãã£ãã®ã幞éãŸã§ãã
(ŽÏ`;)
EUCã£ãœãããŒã«ãããŒã¿ã¯ã¬ã³ãžã³ã°ã»åå¯ã管çã§ããŠãªãã·ã¹ãã ãšãç¡æ°ã«åé¡ç¹ã¯ãããã©
ITILã§ãããšããã®å€æŽã»ãªãªãŒã¹ã»å±é管çãå šããªãããŠãªãã®ãåå ã ã
ããã ãã¶ã«ã ãšéã«æªæãã奎ã«å©çšãããªãã£ãã®ã幞éãŸã§ãã
ãããããšäžæè°ãªäºä»¶ã
ãããããæ¡åŒµåã§èªååé€ããããããããªãã®ã ãã©ã
ãããããæ¡åŒµåã§èªååé€ããããããããªãã®ã ãã©ã
ããªããŒã (移å)ãâŠãã³ããŒãšåé€ã¯å®è£
ãããããçµã¿åãããã°ç°¡åã«ã§ãããã ãªã
âãã¡ã€ã«ã·ã¹ãã ãcase-insensitiveã ã£ãã®ã§ã³ããŒã¯åãªãäžæžããšãªããçŽåŸã®åé€ã§æ¶ãããŠBAD ENDïŒ
ã¿ãããªã®ã¯æçµéšãã
âãã¡ã€ã«ã·ã¹ãã ãcase-insensitiveã ã£ãã®ã§ã³ããŒã¯åãªãäžæžããšãªããçŽåŸã®åé€ã§æ¶ãããŠBAD ENDïŒ
ã¿ãããªã®ã¯æçµéšãã
ãã¹ãŠã«ãããŠäœæ¬¡å
ãªäºãã ãã©ãçŸå Žã®è²¬ä»»ã®ãªããã€ãåãããã®å
ã¯ç¥ããïŒçãªè©±ã¯æ³åã«é£ããªãããããã€ããã§ããã
ãããŒã¿ã®éèšäœæ¥ã®ããã«ãã¯ãä»ã®Excelã䜿çšããŠãããšããããã®ãã¯ãã¯æ¡åŒµåãå°æåã§ãªããšæ£åžžã«åäœããªãä»æ§ã ã£ããäžæ¹ãå
¬ææžç®¡çã·ã¹ãã ã®ä»æ§ã§ã¯æ¡åŒµåã倧æåãšããã®ãæšæºã«ãªã£ãŠãããã
ãã¯ããã·ã¹ãã ããªãã§ãããªã¢ããªä»æ§ãªã®ïŒ
ãã¯ããã·ã¹ãã ããªãã§ãããªã¢ããªä»æ§ãªã®ïŒ
>ã§ã¯ããªãæ¡åŒµåãå°æåã«ãããã£ãã®ãã
>çã§ã¯ãããŒã¿ã®éèšäœæ¥ã®ããã«ãã¯ãä»ã®Excelã䜿çšããŠãããšããã
>ãã®ãã¯ãã¯æ¡åŒµåãå°æåã§ãªããšæ£åžžã«åäœããªãä»æ§ã ã£ãã
ããã§ããŒã¿ãã¡ã€ã«10äžä»¶ã®æ¡åŒµåã®ã»ããçŽããïŒã£ãŠãªãã®ããããã
>çã§ã¯ãããŒã¿ã®éèšäœæ¥ã®ããã«ãã¯ãä»ã®Excelã䜿çšããŠãããšããã
>ãã®ãã¯ãã¯æ¡åŒµåãå°æåã§ãªããšæ£åžžã«åäœããªãä»æ§ã ã£ãã
ããã§ããŒã¿ãã¡ã€ã«10äžä»¶ã®æ¡åŒµåã®ã»ããçŽããïŒã£ãŠãªãã®ããããã
ãã£ã±ãçç±ããªããªããšãªãã§ããã¯ã¢ãã3æ¥ã«ãã¡ãã£ããã¿ãŒã³ã«èŠãããªã
æ¶å€±ã®çµç·¯ã¯ã¡ãã£ãšãšã¯ã»ã«è©³ããè·å¡ãéè¯ãã¯ãäœã£ããããã§äœæ¥ãè¡ãã®ãæ®éã«ãªã£ãŠããã®åŸè©³ããè·å¡ãç°åã«ãªã£ãŠæ®ã£ã人éããããããã£ãŠæãããªãå šéšæšæž¬ã ãã©ã
æ¶å€±ã®çµç·¯ã¯ã¡ãã£ãšãšã¯ã»ã«è©³ããè·å¡ãéè¯ãã¯ãäœã£ããããã§äœæ¥ãè¡ãã®ãæ®éã«ãªã£ãŠããã®åŸè©³ããè·å¡ãç°åã«ãªã£ãŠæ®ã£ã人éããããããã£ãŠæãããªãå šéšæšæž¬ã ãã©ã
ãã¯ãçŽãã人ãå±
ãªãã£ãã®ããªã
ãã¯ãæ£èŠéçšã¯æªã§ãã
ãããªç¡èœé£äžããæé€ã§ããªããã ãã
ãããªç¡èœé£äžããæé€ã§ããªããã ãã
çµç·¯
æ åœè ãéèšãã¯ãã¯å°æåæ¡åŒµåãã¡ã€ã«ããéèšã§ããªããã§ã
ïŸïŸãã·ã¹ãã ã§ã¯å€§æåæ¡åŒµåãæšæºãã§ã
æ åœè ãä»æ§ãããªããªãå°æåã«ããŠãã§ã
å¯å£«é»æ©ããããå šéšå°æåã«ãããã§ã
ïŸïŸãå°æåãšå€§æåã§ãã¡ã€ã«åäžäžèŽã§åé€ãã§ã
æ åœè ãéèšãã¯ãã¯å°æåæ¡åŒµåãã¡ã€ã«ããéèšã§ããªããã§ã
ïŸïŸãã·ã¹ãã ã§ã¯å€§æåæ¡åŒµåãæšæºãã§ã
æ åœè ãä»æ§ãããªããªãå°æåã«ããŠãã§ã
å¯å£«é»æ©ããããå šéšå°æåã«ãããã§ã
ïŸïŸãå°æåãšå€§æåã§ãã¡ã€ã«åäžäžèŽã§åé€ãã§ã
è©ŠéšãããŠãªãæ©èœããããªã䜿ã£ãã®ã¯è«å€ã ãã©ã3æ¥éã®ã¿ã®ããã¯ã¢ãããšããæ¡åŒµåã®å¯Ÿå¿ãExcelãã¯ãåŽãçŽãã¹ãã ã£ãããããªãããšããçåã®å€ãäºä»¶ã
æ¡åŒµåãå°æåã«ãããæ°æã¡ã¯ãããªããã¥ã
ããªãæ¡åŒµåãå°æåã«ãããã£ãã®ãã
ãããã¯ã¢ããæéã¯ãªã3æ¥éã ã£ãã®ãã
ããªããã¹ãã審æ»ãªã©ãããæ©èœè¿œå ãè¡ã£ãã®ãã
ïŸïœ©ïœ¯ïŒãã©ããšããããºããºããšã
ãããã¯ã¢ããæéã¯ãªã3æ¥éã ã£ãã®ãã
ããªããã¹ãã審æ»ãªã©ãããæ©èœè¿œå ãè¡ã£ãã®ãã
ïŸïœ©ïœ¯ïŒãã©ããšããããºããºããšã
æ¡åŒµåãå°æåã«ãããã£ãã ããªã®ã«ïœïœïœ
>ãã¯ãä»ã®Excelã䜿çšããŠãã
>ãã¯ãã¯æ¡åŒµåãå°æåã§ãªããšæ£åžžã«åäœããªãä»æ§
>ãã¯ãã¯æ¡åŒµåãå°æåã§ãªããšæ£åžžã«åäœããªãä»æ§
äœããçªã£èŸŒã¿ã©ããæºèŒã ãªð€£
çã¯æ¥è
ããã¹ãããŠãªãçãªçºèšããŠããã©ãããªãæ¹ãã·ã¹ãã ã®ãªãŒããŒã§ãããæçµãã§ãã¯ããªããšãïŒ
ãªãã»ã©âŠâŠãããã
>âŠ
>âŠ
çã§ã¯ãããŒã¿ã®éèšäœæ¥ã®ããã«ãã¯ãä»ã®Excelã䜿çšããŠãããšããããã®ãã¯ãã¯æ¡åŒµåãå°æåã§ãªããšæ£åžžã«åäœããªãä»æ§ã ã£ãã
éã±ãã£ãŠæ倱ã
éã±ãã£ãŠæ倱ã
ãã°ã£ãŠããšã«ããã°å
¬ææžæ¶ããã®ãâŠð€
ã»å
¬ææžç®¡çã·ã¹ãã ã¯æ¡åŒµå倧æåãããªããšäžèŠãã¡ã€ã«ãšããŠåé€
ã»æ°æ©èœã¯æ¡åŒµåãå°æåã«å€æŽ
ã»çã¯ä»æ§åãåãããããä¿®æ£äŸé Œãããäžæ
ã³ãã¥ãã±ãŒã·ã§ã³ã®åé¡ã§ãããâŠ
ã»æ°æ©èœã¯æ¡åŒµåãå°æåã«å€æŽ
ã»çã¯ä»æ§åãåãããããä¿®æ£äŸé Œãããäžæ
ã³ãã¥ãã±ãŒã·ã§ã³ã®åé¡ã§ãããâŠ
èšäºãèªãã éãã ãšæ§ã
ãªèŠå ãéãªã£ãçµæäºæ
ã«ç¹ãã£ããããªã®ã§ãç¹å®ã®å åã ããåãäžããŠéšãã ããäºå®ã ãšç¢ºèªã§ããªãæ¶æž¬ããããã人ãåããäžãããããªããšã¯ãããå·éã«ãæ¬åœã®æå³ã§ã®ãªããªãåæãããã£ãŠããã¹ãäºäŸã ãšæããŸãã
SIã§ã¯ã©ããªäºçŽ°ãªä¿®æ£ã§ããæ
åœè
ãé©åœã«ã¡ãã¡ãããšæ¹é ããŠã¯ãããªã(æã)
管çã·ã¹ãã ããããããããã¯ãæ¹ä¿®ãçºæ³šãããããšãªããªããšãããçºæ³šåŽã«ãå泚åŽã«ãäžå¹žãªåºæ¥äºã§ãã
ãã¯ããïŒå€æ³šå«ãïŒèªåã§æ¹åãããããªãäºæ ããããšããã®ãã€ããã
ãã¯ããïŒå€æ³šå«ãïŒèªåã§æ¹åãããããªãäºæ ããããšããã®ãã€ããã
ã¬ãã«äœãããŠèâ('ïœ`;)â
èŠä»¶å®çŸ©ãšåææŒããªã ããªïŒ
ã·ã¹ãã æ¹ä¿®ã§äŸé ŒãããåŠãã
çŽã確èªåºæ¥ãªãã£ãŠ
èŠä»¶å®çŸ©ãããŠãªãã®ãªâ€µ
èŠä»¶å®çŸ©ãšåææŒããªã ããªïŒ
ã·ã¹ãã æ¹ä¿®ã§äŸé ŒãããåŠãã
çŽã確èªåºæ¥ãªãã£ãŠ
èŠä»¶å®çŸ©ãããŠãªãã®ãªâ€µ
å°çããªãâŠ
æ®éã«èããã°ãã¯ãåŽãä¿®æ£ããã»ãã楜ãªã®ã«ãª
çè·å¡ãªããŠ2,3幎ã§ç°åããããããã¯ããäœæããè·å¡ããã§ã«å¥éšçœ²ã«è¡ã£ãŠãéšçœ²å ã«ãã¯ããä¿®æ£ã§ãã人éãããªãã£ãã®ã ããã
æ¡åŒµåã®æå®ãªããŠå°ããã¯ãã觊ã£ãããšãã人ãªãã§ããããªãã®ã ã
çè·å¡ãªããŠ2,3幎ã§ç°åããããããã¯ããäœæããè·å¡ããã§ã«å¥éšçœ²ã«è¡ã£ãŠãéšçœ²å ã«ãã¯ããä¿®æ£ã§ãã人éãããªãã£ãã®ã ããã
æ¡åŒµåã®æå®ãªããŠå°ããã¯ãã觊ã£ãããšãã人ãªãã§ããããªãã®ã ã
excelã®ãã¯ããå°æåããåã蟌ãç¡ãã£ãŠãã£ã¡ã¯ãã£ã¡ã§ãã¡ããã
XLSMãxlsmã«ãããšåé€å¯Ÿè±¡ããŒ
WindowsãªãåäžèŠã ãã©ãããã
WindowsãªãåäžèŠã ãã©ãããã
èªååã®æå³ãçããç解ããŠããªããããããªãã
ããžã§1件ã§ãããã®ã§ããã¹ãããªãã£ãã®ã¯äœæ ãªãã ããïŒ
æ¬åœã«ã§ãããšæã£ããæ匷ã¬ãã«ã®ãã«ãã
ãããã«ããããã®äººã¯çªéã§çŽã ãæŽçããéšçœ²ã«åãããã®ããªã
ããžã§1件ã§ãããã®ã§ããã¹ãããªãã£ãã®ã¯äœæ ãªãã ããïŒ
æ¬åœã«ã§ãããšæã£ããæ匷ã¬ãã«ã®ãã«ãã
ãããã«ããããã®äººã¯çªéã§çŽã ãæŽçããéšçœ²ã«åãããã®ããªã
ãã²ããŒãŒ
ããã¯ã¡ãã£ãšâŠð
excelã®æ¡åŒµåã¯xlsã§ããïŒ
åé€ãšãããã¯ã¢ããç³»ã®éæ©èœèŠä»¶é¢é£ã«è¶³ããããããã®ã¯ãããããæ匷ããã ãã©
粟ç¥çäœè£ç¡ããšéæ©èœèŠä»¶ã®è©°ããçããªãã®ã¯çµæ§ãããã¡ãªã®ã§ã察岞ã®ç«äºãšæããªãã§ããããŒãžã¡ã³ãããŠãããããã«ãªãããããã ãªã
粟ç¥çäœè£ç¡ããšéæ©èœèŠä»¶ã®è©°ããçããªãã®ã¯çµæ§ãããã¡ãªã®ã§ã察岞ã®ç«äºãšæããªãã§ããããŒãžã¡ã³ãããŠãããããã«ãªãããããã ãªã
ãä»æ§ãå°ããã®ã¯ç¢ºãã ããæ¹ä¿®ããé¡ããããã¯ç¢ºèªäžããšã®åçããã£ãã
âã¿ã¹ã¯ããã±ããã§ç®¡çããŠãªããã§ãããããïŒç¬ïŒ
âã¿ã¹ã¯ããã±ããã§ç®¡çããŠãªããã§ãããããïŒç¬ïŒ
ããïŒãŸããå¯å£«éãããããïŒExcelã®ãã¯ããšãã¡ã€ã«åã®å€§æå/å°æåã£ãŠã»ã»ã»ãªãã ãè¶
åæ©çãããã蟺ã®çŸå Žã§ãããã¡ãªäºæ¡ã
ã©ããªåçãåºãŠãããå æžãããéçšãªã®ã¯ééããªããªã³ã¬ã
>ãä»æ§ãå°ããã®ã¯ç¢ºãã ããæ¹ä¿®ããé¡ããããã¯ç¢ºèªäžããšã®åçããã£ãã
>ãä»æ§ãå°ããã®ã¯ç¢ºãã ããæ¹ä¿®ããé¡ããããã¯ç¢ºèªäžããšã®åçããã£ãã
ïŒ çã¯å¯å£«é»æ©ITãœãªã¥ãŒã·ã§ã³ãºã«å¯Ÿããæ¡åŒµåã倧æåãªã®ã¯ä»æ§ãªã®ãããšãã趣æšã®è³ªåããããšãããæçµçã«ã¯æ¡åŒµåãå°æåã«å€æŽããããšã«ãªããçµæãšããŠãã¡ã€ã«ãæ¶å»ãããã
仲æªãã£ããã ãããªã
仲æªãã£ããã ãããªã
ããã¯èã ãªãã
ã©ã£ã1ç®æã§ããŸãšããªå·¥çšãããã°ããã
ãããããããŸã§ã¹ã«ãŒã§ããã£ãŠããã
ã©ã£ã1ç®æã§ããŸãšããªå·¥çšãããã°ããã
ãããããããŸã§ã¹ã«ãŒã§ããã£ãŠããã
æ¡åŒµåãå°æåã«ããæ°æ©èœãéçºïŒç¬ïŒãããããã¯ããçŽãã°ð¥