前回ã¾ã§ã®ãããã
ããã ã¢ãã忥忹åã®ä»£è¡¨æ ¼ã§ãããã¨ã¿å¼ã«ã¤ã¼ã³ãå¤ãã®IT伿¥ã«é©ç¨ã§ããªããã¨ãæã£ã¦çµ¶æããmegamouthãéã³ãæ§ã交æã§ããªãæ¨ããã¯ãã¯ãææ§ãªã®ã ãããï¼ããã¨ãæã ã¯ãã¿ã³å±æ ¹ã®ä¸ã®ç«ã®ããã«æ¥ãå¾ããã¨ããã 念ããã¹ããªã®ã ãããï¼ï¼ã©ãã§ãããï¼
ä¸äººã§å§ããæ¥åæ¹åããã®çæ°
ã¾ããæ¬ã¨ã³ããªã¯æ«ç«¯ITåæ¹ãä¸äººã§æ¥åæ¹åãè¡ããã¨ããã¨ãã©ã®ãããªäºãèµ·ããã®ããã¨ããããããªè©±ããããã¨ãã¦ããã大ããã§ãªããæ¥åæ¹åããã£ãä¸äººã§è¡ãã¨ããã®ã¯ãå±±ã«ç¯ã£ãã©ã³ãã¼ããè¥²ãæ¥ãè¦å®ãã¡ãå ¨å¡ãµãã¤ãã«ãã¤ãã¨ãã¼ãã¼ãã©ããã§æ¨æ®ºãããããªè©±ã§ããããã®å¤ç¬ãªæ¦ãã«ã¯ä½ã®æ¯æ´ãæå¾ ã§ããªãããããªãã®ãµã¼ãã¹æ®æ¥æéã¯ç¢ºå®ã«å¢å ããããç²¾ç¥çãªè² è·ã大ãããã«ãé¢ããããæåãã¦ãããªããæ£å½ã«è©ä¾¡ããããã¯ããããªããçµå¶è ã®ã¬ã¬ã¼ã¸ã«æ°è»ã®BMWãä¸å°å¢ããã ããããããªãã®ã ã
ãã å¯ä¸ã確å®ã«ããªãã«æ®ããã®ãããã¨ããã°ãæ æ°ãç¾å¾³ã¨ããå¤ã®ã¨ã³ã¸ãã¢ã®çæã§ãããã¯ã½ãã ããªãæ £è¡ãçµãããããã¨ã§ãèªåãæ©æ¢°ãæ¯è»ã§ãªãç´ãããªã人éã§ãã£ãã¨ãã証æã®ã¿ã§ããã
ããã§ããããã¨ãã人éãä»®ã«ããã¨ãã¦ãå½¼ã®åªåãã©ã®ãããªæ¹åã«åããããæ¸ãã¦ã¿ããã
ä¸äººã§ã§ããæ¥åæ¹åã®ã¢ã³ããã¿ã¼ã³
ä¸äººã§æ¥åæ¹åãè¡ãã¨ããã®ã¯å®ã¯ãããªç¹æ®ãªãã¨ã§ã¯ãªããããããã«æ¥ã éã£ã¦ããä»äºããã¾ãã«ãéå±ã§ã¤ã¾ããªãã®ã§ãèªåãæ¥½ãããããã«åæã«æ¥åæ¹åããããã¨ãããã¨ã¯å¤å°ç´ é¤ã®ãã人éãªãããã£ãããã£ã¦ãããã®ã ãã ããæ®å¿µãªãããã®ãããªè¡çºã¯å¾ã¦ãã¦å調å§åã®ä¸ã§ç°ç«¯ã¨ãã¦åããä¸ããããçµæã¨ãªãã
ã¾ãã¯ãã®ãããªã¢ã³ããã¿ã¼ã³ãå¹¾ã¤ãä¸ãã¦ããããã
Excelãã¯ãçå群
ã¨ã³ã¸ãã¢ã§ããExcelæ¹ç¼ç´ã«æ¸ãããããã¥ã¡ã³ãããã©ã£ãã®æ°åãæ¥ã æ¸ãåãã ãã®Excelã·ã¼ããæ±ããã¨ã¯å¤ãããããããã¨ãå¤ããªã£ã¦ããã¨ãã¤ãExcelãã¯ããªã©ãçµãã§ã使¥ãèªååãã¦ãã¾ãããã»ãï¼1æéããã使¥ã5åã«ç縮ãããï¼ãã¨ãã£ã¦ãã¾ããã®ã ã
å®ã¯ãã®è¡çºèªä½ã¯ã¢ã³ããã¿ã¼ã³ã¨ã¯è¨ããªãããããæçãªè¡çºã§ãããå人ã®çç£æ§ã®è¦³ç¹ã§ã¯ã使¥ã®æéç縮ã¨ããã®ã¯çéã¨è¨ããã ããã
åé¡ã¨ãªãã®ã¯ããã®åä¸ã«ãã£ã¦å¾ãããçç£æ§ã®åä¸ã¯ããªãã®ã¿ãåãã¦ããã¨ãããã¨ã ãããã¯åæã«ããã«ããã¯ï¼ããªãã®Excelãåãåã£ã人éã®ä½æ¥è½çã¯å¤ãããªãã®ã§ãããã§ä½æ¥ãåæ»ãããã¨ã«ãªãï¼ãçã¿åºããã¨ã«ãªãï¼ãããã¦å ¨ä½ã®ä½æ¥å¹çã¯ã»ã¼å¤åããªããã¨ã«ãªãï¼ããªãã°ãã¨ããªãã¯ä½ã£ãExcelãã¯ãã宿ã«ååã¨å ±æãã¦ãå ¨ä½ã®å¹çåãå³ããã¨ããã ããããããå ¨ã¦ã®ééãã§ããã
1æéã®ä½æ¥ã5åã«ç縮ã§ããã®ãªããããªãã®ä½ã£ãExcelãã¯ãã¯ãã£ã¨æç¨ã«éããªãããã¿ããªããã¯ããå ±æãã¦ä½ã£ãæéããã£ã¨æçã«ä½¿ãããæ°æã¡ã¯ãããããããã«ã¯ããããã¯ãããªãªã¼ã¹ããããã«ã¯ã責任ããçãããã¨ããè¦ç¹ãæ¬ ãã¦ããã
ãã£ã¨ããªãã®ãã¯ãã¯æåã¯ç±ççã«åãå ¥ããããããä¸åº¦ãã®ãã¯ãã®ãã°ãä»äººã®Excelã§çºçãããããã®çµæè²¬ä»»ã¯ããªããè² ããã¨ã«ãªãããã²ã©ãå ´åã«ã¯ããã®ãã¯ãã«æ¬ ããæ©è½ãå®è£ ãã責任ã¾ã§èè² ããããã ãããçµæã¨ãã¦ããªãã®è²´éãªæéã¯åããã稼ãåºãã55åéã®ä½å°ã¯Excelãã¯ãã®ã¡ã³ããã³ã¹ã¨ãã使¥ã«è²»ãããããã¨ã«ãªããã調åã«è¼ã£ã¦åããä»ã®ä»äºã¯ããªãã®ãµã¼ãã¹æ®æ¥æéãå¢å ããããçµæã¨ãã¦ç¢ºãã«å ¨ä½ã®å¹çåã¯ãªããããããããªãããããªãèªèº«ãæ°ããããã«ããã¯ã«ãªã£ã¦ãã¾ããã¨ã«ãªãã
ã¾ãåæã«ãä¸ã®ä¸ã«ã¯ãã²ãããå調ãªä½æ¥ãæ£ç¢ºã«ç¹°ãè¿ããã¨ãç忦ç¥ã¨ãã¦ãã¦ãã人éããããã¨ãå¿ãã¦ã¯ãªããªããå½¼ãã«ã¨ã£ã¦ããªãã®ãã¯ãã¯ç¦é³ã§ã¯ãªãããã ä»äºã奪ãèªåã®çåãè ãããã®ã«ä»ãªããªãã
ã¾ã大ä½ã«ããã¦ãä¸äººã§Excelãã¯ããçµãã§å¾æãã人éã¨ããã®ã¯ãããã人éã徿£ãã¦ããã®ã§ãå½¼ããã¯ãã«ãªã£ãããããããã«æã£ã¦ããã®ãããããªãããçµå¶è ãä¿¡é ¼ããã®ã¯ããããæ£ç¢ºã«è¨ããããã¨ç¢ºå®ã«å®è¡ãã人éã§ãããããªãã®ãã¨ã¯ãããããããã¤ã ãªãï¼ãªããã®å½¹ã«ã¯ãã¤ã ããï¼ããããã«æã£ã¦ãããã®ã ããã®è¦ç¹ã§è¦ãã°ããããä¸è¦ã ã¨å¤æãããã®ã¯ãExcelãã¯ãã宿ãããããªãèªèº«ãããããªããã¨ãããã¨ãå¿ãã¦ã¯ãªããªãã
ããããªããã©ããã¦ãExcelãã¯ããå ±æãããã®ã§ããã°ããããã¾ä¼ç¤¾ãè¾è·ãã¦ããã®ãã¯ããä¿å®è²»ç¨è¾¼ã¿ã§ä¼ç¤¾ã«å£²ãã¤ããã¹ãã§ãã£ã¦ããã®è¦æããªãã®ã§ããã°ãExcelãã¯ãã¯ç§å¿ããä½ã£ãæéãã¨ããµã¤ããããã«ä½¿ç¨ãã¦ãä¸å¸ãå¾ãã«æ¥ãæã®ã¿ãExcelã·ã¼ããéãæéã身ã«ã¤ãããã¨ã ã
ã·ã¹ãã ï¼ãã¼ã«ï¼ä¸è½è«
ä¸ã®ä¸ã«ã¯æ¥åæ¹åç³»ã®ãã¼ã«ã¯è²ã ã¨ãããä¾ãã°Redmineãtracãgitããã®ããã³ãã¨ã³ãã§ããGitLabãJenkinsã¨ãã£ããã®ãå°å ¥ããã°ãä»ããã«ã§ãæ¥åæ¹åãã§ãããããªé¯è¦ãèµ·ããã
ãããã©ãã»ã©æ¸ãã¦ããã®ã§ãããã«ãããã¨æãã®ã ããITã·ã¹ãã ã¯éæ³ã§ã¯ãªãããããã®ã·ã¹ãã ãããªãã®èããæ¥åã®ããã«ããã¯ãè§£æ¶ããè¦ä»¶ãåãã¦ããã¨ãã¦ããååãæ±ããåé¡ãåæ§ã§ããã¨ããä¿è¨¼ã¯ã©ãã«ããªãã
ããããããªã¨ããã«ãããªããèªæ ¢ã®RedmineãªãGitLabãªã©ãæã¡è¾¼ãã ã¨ãã¦ããã¿ã¼ããã«ããéãããè±èªãèªããªã人éã¯å°æããã ãã§ããã3ã¶æå¾ã®Redmineä¸ã«ã¯ããªããä½ã£ããã±ãããæªè§£æ±ºã®ã¾ã¾ä¸¦ã³ç¶ãããã¨ã«ãªãã ããã
ããã¯èªèº«ã®åé¡ãå ¨ç¤¾çãªåé¡ã¨ãã¦æãã¦ãã¾ã£ããã¨ã«ããçµæã§ãããããããªããã·ã¹ãã ã®å°å ¥ã¨å©ç¨ãå¼·è¡ã«å§ããã®ã§ããã°ãããªãèªèº«ãããã ãã®æ¨©åãæã«ãã¦ãç²ãå¼·ããä¾ãã°ã¡ã¼ã«ã§ä½æ¥ä¾é ¼ããã度ã«ãredmineãã±ããã使ç¨ãã¦ãã ãããã¨ãã³ãã¬ã¼ãè¿ä¿¡ãéãç¶ãããªã©ãã¦ãå¨å²ã«ã·ã¹ãã ã®æç¨æ§ã¨ãããã«ãã£ã¦è§£æ±ºããåé¡ãåèãããredmineãâã¬ã¤ãã¨ä»åãã¤ãããã«æ¯ãèãå¿ è¦ãããã ããã
éã«è¨ãã°ããããã£ãè¦æãªãã§ãããã®ã·ã¹ãã ãç¬æã§å°å ¥ãããã¨ã¯å ¨ãã®ç¡é§ã§ããã
ç¥èä¸è½è«
ãããã®è©¦ã¿ã䏿ãè¡ããªãã£ãçµæã¨ãã¦ãããªãã¯ããèãã¦ãããããããªããã©ããå½¼ãã¯æã£ã以ä¸ã«ææ§ãªããã ãã¾ãã¯å ¨ä½ã®ã¬ãã«ã®åºä¸ããè¨ããªããã°ãã¨ã
ãããã¦ãå°±æ¥æéå¾ã«CodeComplete輪èªä¼ãªã©ã¨ãã£ããæå³ä¸æã®åå¼·ä¼ãçºè¶³ãããã¨ã«ãªããå ¨å¡ã«ææ¬²ãããã®ãªãããã§ããã®ã ãããããã第1åç®ã®åå¼·ä¼ãçµãã£ãå¾ã«ãããªãã¯å¨å²ã®å顿èã®èãã«æ°ã¥ãã¦ãã¾ãã ãããå¾ã¦ãã¦ããããåå¼·ä¼ã§æåã«ããæ°ããªããã®ã¯ä¸»å¬è ã§ããããã¯ãã©ãã§ããããªã£ã¦ãã¾ã£ãããªãã¯ãµã¤ãã¦ãºã§ä¼è°å®¤ã確ä¿ãããã¨ããå¿ãã¦ãã¾ããåå¼·ä¼ã¯CodeCompleteã®30Pãããã§èªç¶æ¶æ» ããã
æ®ãããååã¯ããªããå°æ¬ããã©ãããããªãã綺éºäºãè¨ã£ã¦åå¼·ä¼ã¨ããåã®ãµã¼ãã¹æ®æ¥ãå¼·ããè¿·æãªå
輩ãç¨åº¦ã®èªèã§ããªããæ±ãããã«ãªãã®ã§ããã
ã¢ã³ããã¿ã¼ã³ããå¾ãããæè¨
以ä¸ãä¸äººæ¥åæ¹åããããã¨ãã½ã¼ãã並ã¹ã¦ã¿ãããããããå¾ãããæè¨ã¯ä»¥ä¸ã®ãã®ã§ãã
- èªåã®ä½æ¥ã ãã屿çã«æé©åãã¦ããæ°ããªããã«ããã¯ãçã¿åºããæ¥åæ¹åã«ã¯ãã¾ãæå³ããªãã
- æé©åã¯ã³ãã¥ãã±ã¼ã·ã§ã³ã¨ãã£ãå ¨ä½ã®æ å ±ä¼éã§ãã£ãããæ¥µç«¯ãªããã«ããã¯ã®è§£æ¶ã«åããã¹ããã®ã§ãããªãã®åé¡ã解決ãããã¨ã§ãå¹çåãå³ãããã±ã¼ã¹ã¯å°ãªãã
- ã·ã¹ãã ã¯éæ³ã§ã¯ãªã
- ã·ã¹ãã ã¨ã¯é»ç®åããããã¯ã¼ã¯åãããã¯ã¼ã¯ããã¼ãã®ãã®ã§ãããã·ã¹ãã ã®å°å ¥ã¨ã¯ã¯ã¼ã¯ããã¼ã®å¼·å¶ãæå³ãããããªãã«ãã®æ¨©å©ã¨ãååã説å¾ããè¦æãããããèªåããå¿ è¦ãããã
- ä»äººã¨ã¯åããåããªã
- ä½ããããããä»äººã¨å顿èãå ±æãããã¨ã¯ã§ããªããã§ããã®ã¯ä»äººã®å顿èããç¥ãããã¨ã ãã§ããã
ãªãããã ã¢ããå¼ã®å¹çæ¹ååªåã¯ç¡é§ãªã®ã
ãããã®äºä¾ãé説ã«è¦ã¦ã¿ãã¨
- æ¥åã®ããã«ããã¯ãã¾ãã¯ç¡é§ãè¦åºãåºãè¦ç¹ãæã¤
- ã¯ã¼ã¯ããã¼ã®å¼·å¶ã¨ãã·ã¹ãã åããã
- 社å¡ããããã®å顿èãç¥ããã¨ãã§ãã
- çµæè²¬ä»»ãè² ããã¨ãã§ãã
ããã§ããã°å¹çåã¯å¯è½ã§ããã¨è¨ããã
ããã¯ããããã«çµå¶è ã®ãã¨ã§ãããçµå¶è ãæ¥åæ¹åã«èå³ãæã¡ãã³ã³ãµã«ãéããªãã社å¡ãææ ¼ããã¦ã¿ã¹ã¯ãã©ã¼ã¹ãçµããªãããªãéãæ¥åæ¹åã¯æåããªãã¨ãããã¨ã ã
ãªã®ã§ãæã ã¯ãã®æ¥ãããã¾ã§ãéã³ãæ§ãæ¯ããç¶ããã¹ãã ããã³ã³ãµã«ã®è¥é ããã³ãã¬éãã«ãã«ã«ãã¹ããªã®ã ããããã¦ææ§ãªå´åè ã¨ããæ¦å¿µã¯åºå®åããããã¨ãããããæã ã¯ææ§ãªå´åè ãæ¼ãããã¨ãå¼·å¶ããã¦ããã®ã ã
æã ã«ä½ãæå¾ ãã¦ããã®ãï¼
ã¨ãå ¨çµå¶è ã«åãã¦ãæ¬ç¨¿ãçµããã

åé¡è§£æ±ºå¤§å ¨ââãã¸ãã¹ã人çã®ãã¼ãã«ãä¹ãè¶ãã37ã®ãã¼ã«
- ä½è : èªæ¸ç¿
- åºç社/ã¡ã¼ã«ã¼: ãã©ã¬ã¹ãåºç
- çºå£²æ¥: 2017/11/19
- ã¡ãã£ã¢: åè¡æ¬
- ãã®ååãå«ãããã° (4ä»¶) ãè¦ã