æ°åå°ã®ãšã¢ã³ã³ãå€æ°ã®ãã£ãŒãŒã«çºé»æ©ã»ãããç¡åé»é»æºè£ 眮ãªã©ããšã³ãžãã¢ãªã³ã°æ©åšããã¹ãŠæã£ããµãŒã㌠ã«ãŒã ããããšæ³åããŠãã ããã ããŒããŠã§ã¢ãæ£åžžã«åäœããããã«ã¯ãå®æçã«æ§èœããã§ãã¯ããè©Šé転ããªã€ã«ã¬ãã«ã®ç¢ºèªãéšåã®äº€æãªã©ã®äºé²ä¿å®ãå¿ããã«è¡ã£ãŠãã ããã XNUMX ã€ã®ãµãŒã㌠ã«ãŒã ã§ãã£ãŠããæ©åšã®ç»é²ç°¿ãå庫å ã®æ¶èåã®ãªã¹ããäºé²ä¿å®ã®ã¹ã±ãžã¥ãŒã«ãä¿èšŒæžé¡ããµãã©ã€ã€ãŒãè«è² æ¥è ãšã®å¥çŽãªã©ãå€ãã®æ å ±ãä¿åããå¿ èŠããããŸãã
次ã«ãããŒã«ã®æ°ã XNUMX åããŠã¿ãŸãããã ç©æµã®åé¡ãçºçããŸããã ã¹ãã¢ããŒãããã¹ãŠæ¢ãåããªããŠãæžãããã«ãã©ã®å庫ã«äœãä¿ç®¡ããã°ããã§ãããã? äºå®å€ã®ä¿®çã«é©ããããªãããã«ãã¿ã€ã ãªãŒã«æ¶èåãè£å ããã«ã¯ã©ãããã°ããã§ãããã? å€ãã®æ©åšãããå Žåããã¹ãŠã®æè¡çãªäœæ¥ãé ã®äžã«åããããšã¯äžå¯èœã§ãããçŽã®äžã§è¡ãã®ã¯å°é£ã§ãã ããã§MMSïŒä¿å®ç®¡çã·ã¹ãã ïŒã圹ã«ç«ã¡ãŸãã
MMS ã§ã¯ãäºé²ããã³ä¿®çäœæ¥ã®ã¹ã±ãžã¥ãŒã«ãäœæãããšã³ãžãã¢åãã®æ瀺ãä¿ç®¡ããŸãã ãã¹ãŠã®ããŒã¿ã»ã³ã¿ãŒããã®ãããªã·ã¹ãã ãåããŠããããã§ã¯ãªããå€ãã®ããŒã¿ã»ã³ã¿ãŒã¯ãããé«äŸ¡ããããœãªã¥ãŒã·ã§ã³ã§ãããšèããŠããŸãã ããããç§ãã¡èªèº«ã®çµéšãããç§ãã¡ã¯æ¬¡ã®ããã«ç¢ºä¿¡ããŠããŸãã éèŠãªã®ã¯ããŒã«ã§ã¯ãªãã¢ãããŒãã§ã æ
å ±ãæ±ãããã«ã ç§ãã¡ã¯æåã®ã·ã¹ãã ã Excel ã§äœæããåŸã
ã«ãœãããŠã§ã¢è£œåãžãšçºå±ãããŸããã
ãšãšãââã«
ç¬èªã® MMS ã«è³ã£ãçµç·¯
æåã«ãã©ã«ããŒããããŸããã 8 ïœ 10 幎åãæ
å ±ã¯åæ£ãã圢ã§ä¿åãããŠããŸããã ã¡ã³ããã³ã¹åŸãå®äºããäœæ¥ã®å ±åæžã«çœ²åããçŽã®åæ¬ãã¢ãŒã«ã€ãã«ä¿ç®¡ããã³ããŒãã¹ãã£ã³ããŠãããã¯ãŒã¯ ãã©ã«ããŒã«ä¿åããŸããã åæ§ã«ãã¹ãã¢ããŒããå·¥å
·ãä»å±åãªã©ã®ã¹ãã¢ããŒãã«é¢ããæ
å ±ããæ©åšããšã«åé¡ããããã©ã«ããŒã«åéãããŸããã ãããã®ãã©ã«ããŒã®æ§é ãšã¢ã¯ã»ã¹ ã¬ãã«ãæ§ç¯ããã°ããã®ããã«çããŠããããšãã§ããŸãã
ãããã次㮠XNUMX ã€ã®åé¡ããããŸãã
- ããã²ãŒã·ã§ã³: ç°ãªããã©ã«ããŒéã®åãæ¿ãã«æéãããããŸãã ç¹å®ã®æ©åšã®æ°å¹Žéã«ãããä¿®çã確èªãããå Žåã¯ãäœåºŠãã¯ãªãã¯ããå¿ èŠããããŸãã
- çµ±èšïŒçµ±èšæ å ±ã¯ãããŸãããçµ±èšæ å ±ããªããã°ãããŸããŸãªæ©åšãã©ããããæ©ãæ éããããæ¥å¹Žã«åããŠã©ããããã®ã¹ãã¢ããŒããèšç»ããããäºæž¬ããã®ã¯å°é£ã§ãã
- ã¿ã€ã ãªãŒãªå¯Ÿå¿: ã³ã³ããŒãã³ãããã§ã«äžè¶³ããŠãããå泚æããå¿ èŠãããããšãéç¥ãã人ã¯èª°ãããŸããã åãæ©åšãæ éããã®ã¯ãããåããŠã§ã¯ãªãããšãæããã§ã¯ãããŸããã
ãã°ããã®éããã®ãããªããã¥ã¡ã³ããä¿åããŠããŸãããããã®åŸ Excel ãçºèŠããŸãã :)
MMSããExcelãžã®å€æã æéãçµã€ã«ã€ããŠãããã¥ã¡ã³ãæ§é 㯠Excel ã«ç§»è¡ãããŸããã ããã¯ãã¡ã³ããã³ã¹ ã¹ã±ãžã¥ãŒã«ããã§ãã¯ãªã¹ããããã³äœæ¥å®äºèšŒææžãžã®ãªã³ã¯ãæ·»ä»ãããæ©åšã®ãªã¹ãã«åºã¥ããŠããŸããã
æ©åšã®ãªã¹ãã«ã¯ãããŒã¿ã»ã³ã¿ãŒå
ã®äž»ãªç¹åŸŽãšäœçœ®ã瀺ãããŠããŸãã
ãã®çµæãæ©åšããã®ã¡ã³ããã³ã¹ã§äœãèµ·ãã£ãŠããããããã«ç解ã§ãããäžçš®ã®ããã²ãŒã¿ãŒãèªçããŸããã å¿ èŠã«å¿ããŠããªã³ã¯ã䜿çšããŠã¡ã³ããã³ã¹ ã¹ã±ãžã¥ãŒã«ããåã ã®è¡çºã確èªã§ããŸãã
Excel ã§ããã¥ã¡ã³ããæ éã«ç®¡çããå Žåããã®ãœãªã¥ãŒã·ã§ã³ã¯å°èŠæš¡ãªãµãŒã㌠ã«ãŒã ã«éåžžã«é©ããŠããŸãã ããããããã¯äžæçãªãã®ã§ããããŸãã ãšã¢ã³ã³ãXNUMXå°äœ¿ã£ãŠæã«XNUMXåã¡ã³ããã³ã¹ãããšããŠããXNUMX幎ãçµãŠã°æ°çŸä»¶ã®ãšã©ãŒãèç©ãããExcelã¯è¥å€§åããŠããŸããŸãã ãšã¢ã³ã³ããã£ãŒãŒã«çºé»æ©ãUPS ããã XNUMX å°è¿œå ããå Žåã¯ãè€æ°ã®ã·ãŒããäœæããŠãªã³ã¯ããå¿ èŠããããŸãã 話ãé·ããã°é·ãã»ã©ãå¿ èŠãªæ å ±ãããã«åŸãããšãé£ãããªããŸãã
åã®ã倧人åããã·ã¹ãã ã 2014 幎ã«ãåœç€Ÿã¯ Uptime Institute ã®éçšæç¶å¯èœæ§åºæºã«æºæ ããæåã®ç®¡çããã³éçšç£æ»ãåããŸããã ç§ãã¡ã¯ã»ãŒåã Excel ããã°ã©ã ã䜿çšããŸãããã92 幎ãããŠå€§å¹ ã«æ¹è¯ãããšã³ãžãã¢åãã®æé ãšãã§ãã¯ãªã¹ããžã®ãªã³ã¯ãè¿œå ããŸããã ç£æ»äººã¯ããã®åœ¢åŒãéåžžã«å®è¡å¯èœã§ãããšå€æããŸããã 圌ãã¯æ©åšã䜿çšãããã¹ãŠã®æäœã远跡ããããšãã§ããæ å ±ãææ°ã§ãããããã»ã¹ãé©åã«æŽåãããŠããããšã確èªããŸããã ãã®åŸãç£æ»ã¯ 100 ç¹äž XNUMX ç¹ãç²åŸããèŠäºã«åæ ŒããŸããã
çåãçããŸããïŒã©ããã£ãŠããã«çããŠãããã ç§ãã¡ã¯ãæ¬æ ŒçãªãMMS ãå¿ èŠã§ãããšå€æããããã€ãã®ææããã°ã©ã ãæ€èšããŸããããæçµçã«ã¯èªåãã¡ã§ãœãããŠã§ã¢ãäœæããããšã«ããŸããã åã Excel ãæ¡åŒµæè¡ä»æ§ãšããŠäœ¿çšãããŸããã ãããã¯ãMMS ã«å¯ŸããŠèšå®ããã¿ã¹ã¯ã§ãã
ç§ãã¡ã MMS ã«æ±ããŠãããã®
ã»ãšãã©ã®å ŽåãMMS ã¯ãã£ã¬ã¯ããªãšã¬ããŒãã®ã»ããã§ãã ãã£ã¬ã¯ããªéå±€ã¯æ¬¡ã®ããã«ãªããŸãã
äžçªæåã®ãããã¬ãã«ã®åèæžã¯ã 建ç©ã®ãªã¹ãïŒæ©æ¢°å®€ãæ©åšã眮ãããŠããå庫ã
次ã¯æ¬¡ã§ã ãšã³ãžãã¢ãªã³ã°æ©åšã®ãªã¹ãã 以äžã®ã·ã¹ãã ã«åŸã£ãŠåéããŸããã
- 空調ã·ã¹ãã : ãšã¢ã³ã³ããã©ãŒããã³ãã
- é»æºã·ã¹ãã ïŒUPSããã£ãŒãŒã«çºé»æ©ãåé»ç€ã
åæ©åšã«ã€ããŠãã¿ã€ããã¢ãã«ãã·ãªã¢ã«çªå·ãã¡ãŒã«ãŒããŒã¿ã補é 幎ãè©Šé転æ¥ãä¿èšŒæéãªã©ã®åºæ¬ããŒã¿ãåéããŸãã
è£ åã®ãªã¹ããèšå ¥ãããããããäœæããŸã ã¡ã³ããã³ã¹ããã°ã©ã : ã¡ã³ããã³ã¹ã®æ¹æ³ãšé »åºŠã ã¡ã³ããã³ã¹ããã°ã©ã ã§èª¬æããŸã äžé£ã®æäœäŸ: ãã®ããããªãŒã亀æãããç¹å®ã®éšåã®åäœã調æŽããããªã©ã æäœæ¹æ³ã¯å¥åã®åèæžã§è§£èª¬ããŠããŸãã ããæäœãå¥ã®ããã°ã©ã ã§ç¹°ãè¿ãããå Žåããã®ãã³ã«ãããæ°ãã«èšè¿°ããå¿ èŠã¯ãããŸãããåã«åèæžããæ¢æã®æäœãæ¡çšããã ãã§ãã
ã枩床èšå®å€ã®å€æŽãããã³ãã¯ã€ãã¯ãªãªãŒã¹ã±ãŒãã«æ¥ç¶ã®äº€æãã®æäœã¯ãåãã¡ãŒã«ãŒã®ãã©ãŒããã³ç©ºèª¿ã·ã¹ãã ã«å
±éã§ãã
åè£
åã«ã€ããŠäœæã§ããããã«ãªããŸãã ã¡ã³ããã³ã¹ã¹ã±ãžã¥ãŒã«ã ã¡ã³ããã³ã¹ ããã°ã©ã ãç¹å®ã®æ©åšã«ãªã³ã¯ãããšãã·ã¹ãã èªäœãããã°ã©ã å
ã§ã¡ã³ããã³ã¹ãè¡ãå¿
èŠãããé »åºŠã調ã¹ãè©Šé転æ¥ããã®äœæ¥æéãèšç®ããŸãã
Excel ã®æ°åŒã䜿çšããŠããã®ãããªã¹ã±ãžã¥ãŒã«ã®æºåãèªååããããšãã§ããŸãã
å®å šã«æçœãªè©±ã§ã¯ãããŸãã: ç§ãã¡ã¯å¥ã®ãã£ã¬ã¯ããªãç¶æããŠããŸã 延æãããä»äºã ã¹ã±ãžã¥ãŒã«ã¯ã¹ã±ãžã¥ãŒã«ã§ãããç§ãã¡ã¯ççããŠãã人éã§ãããäœãèµ·ããå¯èœæ§ãããããšãç解ããŠããŸãã ããšãã°ãæ¶èåãäºå®éãã«å°çããªãã£ãããããµãŒãã¹ã XNUMX é±éåã¹ã±ãžã¥ãŒã«ããå¿ èŠããããšããŸãã ããã¯ã泚æããŠããã°æ£åžžãªç¶æ³ã§ãã ç§ãã¡ã¯å»¶æãããäœæ¥ãæªå®äºã®äœæ¥ã«é¢ããçµ±èšãä¿æããã¡ã³ããã³ã¹ã®ãã£ã³ã»ã«ããŒãã«ãªãåŸåã«ããããšã確èªããããåªããŠããŸãã
æ©åšããšã®çµ±èšãä¿æãããŸã äºæ ãäºå®å€ã®ä¿®çã ç§ãã¡ã¯çµ±èšãå©çšããŠè³Œå ¥ãèšç»ããã€ã³ãã©ã¹ãã©ã¯ãã£ã®åŒ±ç¹ãèŠã€ããŸãã ããšãã°ãã³ã³ãã¬ããµãŒãåãå Žæ㧠XNUMX åé£ç¶ããŠçŒæããå Žåãããã¯æ éã®åå ãæ¢ãããã®ä¿¡å·ã§ãã
ãã®ä¿å®ã»ä¿®çå±¥æŽã¯ããããšã¢ã³ã³ã«ã€ããŠ4幎以äžèç©ãããŠããŸãã
次ã®ã¬ã€ãã¯ã ã¹ãã¢ããŒãã æ©åšã«ã©ã®ãããªæ¶èåãå¿ èŠããã©ãã«ã©ã®ãããã®éãä¿ç®¡ãããŠããããèæ ®ãããŸãã ããã§ã¯ãå庫ãžã®å°çãããé©åã«èšç»ããããã«ãé éæéã«é¢ããæ å ±ãä¿åããŸãã
æ©åšããšã®å¹Žéä¿®ççµ±èšããã¹ãã¢ããŒãã®æ°ãèšç®ããŸãã ãã¹ãŠã®ã¹ãã¢ããŒãã«ã€ããŠãåæœèšã§å¿ èŠãªã¹ãã¢ããŒãã®æå°ãã©ã³ã¹ã瀺ããŸãã ã¹ãã¢ããŒããäžè¶³ããŠããå Žåã¯ããã£ã¬ã¯ããªå ã®ãã®æ°éã匷調衚瀺ãããŸãã
é«å§ã»ã³ãµãŒã®æå°ãã©ã³ã¹ã¯å°ãªããšã XNUMX ã€ã§ããå¿ èŠããããŸãããæ®ã㯠XNUMX ã€ã ãã§ãã ä»ãã泚æããŠãã ããã
ã¹ãã¢ããŒãã®åºè·ãå°çãããšããã«ãè«æ±æžã®ããŒã¿ããã£ã¬ã¯ããªã«èšå
¥ããä¿ç®¡å Žæãæå®ããŸãã å庫å
ã®ãã®ãããªã¹ãã¢ããŒãã®çŸåšã®æ®é«ãããã«ããããŸãã
åœç€Ÿã¯é£çµ¡å ã®å¥ã®ãã£ã¬ã¯ããªã管çããŠããŸãã ã¡ã³ããã³ã¹ãè¡ããµãã©ã€ã€ãŒãšè«è² æ¥è ã®ããŒã¿ãå ¥åããŸãã
蚌ææžãšé»æ°å®å
šèªå¯ã°ã«ãŒãã¯ãåè«è² æ¥è
ãšã³ãžãã¢ã®ã«ãŒãã«æ·»ä»ãããŠããŸãã ã¹ã±ãžã¥ãŒã«ãäœæããéã«ãã©ã®å°é家ãå¿
èŠãªèš±å¯ãæã£ãŠãããã確èªã§ããŸãã
MMS ã®ååšä»¥æ¥ãçŸå Žèš±å¯ã䌎ãäœæ¥ã¯å€åããŸããã ããšãã°ãã¡ã³ããã³ã¹ãå®è¡ããããã®æ¹æ³è«ãèšèŒããææžãè¿œå ãããŸããã 以åã«äžé£ã®æäœãå°ããªãã§ãã¯ãªã¹ãã«åãŸã£ãŠããå Žåã¯ãæºåæ¹æ³ãå¿ èŠãªæ¡ä»¶ãªã©ã詳现ãªæé ããã¹ãŠãã«ããŒããŸãã
圌ã¯äŸã䜿çšããŠãããã»ã¹å
šäœãçŸåšã©ã®ããã«æ©èœãããã説æããŸãã
MMS ã§ã¯ã¡ã³ããã³ã¹ã¯ã©ã®ããã«è¡ãããŸãã?
ãã€ãŠããã£ãšåã«å®äºããäœæ¥ã¯äºåŸçã«ææžåãããŠããŸããã ã¡ã³ããã³ã¹ã®ã¿ãå®æœããçµäºåŸã«äœæ¥å®äºèšŒææžã«çœ²åããŸããã 99% ã®ãµãŒããŒã¯ãããå®è¡ããŸãããçµéšäžãããã§ã¯ååã§ã¯ãããŸããã å¿ãç©ããªãããã«ããŸãã¯åœ¢ãäœããŸããã åŽåèš±å¯èšŒã ããã¯ãäœæ¥ãšãã®å®æœæ¡ä»¶ã説æããææžã§ãã ã·ã¹ãã ã®ã¡ã³ããã³ã¹ãšä¿®çã¯ãã¹ãŠããããå§ãŸããŸãã ããã¯ã©ã®ããã«ããŠèµ·ããã®ã§ãããã:
- ã¡ã³ããã³ã¹ ã¹ã±ãžã¥ãŒã«ã§æ¬¡ã«èšç»ãããŠããäœæ¥ãèŠãŠã¿ãŸãããã
- æ°ããèš±å¯èšŒãäœæããŸãã åœç€Ÿã¯ãåœç€ŸåŽã§ããã»ã¹ã管çããåœç€Ÿãšäœæ¥ã調æŽããã¡ã³ããã³ã¹è«è² æ¥è
ãéžæããŸãã äœæ¥ããã€ã©ãã§è¡ããããã瀺ããèšåã®çš®é¡ãšåŸãããã°ã©ã ãéžæããŸãã
- ã«ãŒããä¿åãããã詳现ã«é²ã¿ãŸãã è«è² æ¥è
ãæå®ããå¿
èŠãªäœæ¥ãè¡ãèš±å¯ããããã©ããã確èªããŸãã æš©éããªãå Žåããã£ãŒã«ãã¯èµ€ã§åŒ·èª¿è¡šç€ºãããäœæ¥æ瀺ãçºè¡ã§ããŸããã
- å
·äœçãªè£
åãèšèŒããŠãããŸãã äœæ¥ã®çš®é¡ã«å¿ããŠãã¡ã³ããã³ã¹ ããã°ã©ã ã§äºåã®ã¢ã¯ãã£ããã£ãèŠå®ãããŠããŸããããšãã°ãçŸå Žãžã®çæã®æ³šæããšã³ãžãã¢åãã®å°å
¥ããªãŒãã£ã³ã°ã®ã¹ã±ãžã¥ãŒã«èšå®ãååãžã®éç¥ãªã©ã§ããã¢ã¯ãã£ããã£ã®ãªã¹ãã¯èªåçã«è¡šç€ºãããŸãããç¬èªã®é
ç®ãè¿œå ããããšãã§ããŸãã ããã¹ãŠãéåžžã«æè»ã§ãã
- 泚æãä¿åããæ¿èªãã人ã«æçŽãéãã圌ã®è¿äºãåŸ
ã¡ãŸãã
- ãšã³ãžãã¢ãå°çãããšãã·ã¹ãã ããäœæ¥æ瀺æžãçŽæ¥å°å·ããŸãã
- äœæ¥æ瀺æžã«ã¯ãä¿å®ããã°ã©ã ã®æäœã®ãã§ãã¯ãªã¹ããå«ãŸããŠããŸãã ããŒã¿ã»ã³ã¿ãŒã®äœæ¥ç®¡çè
ã¯ãã¡ã³ããã³ã¹ã管çãããã§ãã¯ããã¯ã¹ããã§ãã¯ããŸãã
ãã°ããã®éã¯ãçããã§ãã¯ãªã¹ãã§ååã§ããã 次ã«ãæ¹æ³è«çãªæ瀺ãå°å ¥ãããã MOPïŒæç¶ãæ¹æ³ïŒã ãã®ãããªææžã®å©ããåããŠãèªå®ãšã³ãžãã¢ã¯ããããæ©åšãæ€æ»ã§ããŸãã
éç¥ã¬ã¿ãŒãæ°è±¡æ¡ä»¶ã®ãã³ãã¬ãŒãã«è³ããŸã§ããã¹ãŠãå¯èœãªéã詳现ã«èª¬æãããŠããŸãã
å°å·ãããããã¥ã¡ã³ãã¯æ¬¡ã®ããã«ãªããŸãã
Uptime Institute ã®æšæºã«ããã°ããã¹ãŠã®æäœã«å¯ŸããŠãã®ãã㪠MOP ãå¿ èŠã§ãã ããã¯ããªãã®éã®ããã¥ã¡ã³ãã§ãã çµéšã«åºã¥ããŠãããšãã°æã« XNUMX MOP ãªã©ãåŸã ã«éçºããããšããå§ãããŸãã
- äœæ¥çµäºåŸããšã³ãžãã¢ãå®äºèšŒææžãçºè¡ããŸãã ãããã¹ãã£ã³ããä»ã®æžé¡ïŒèš±å¯èšŒãMOPïŒã®ã¹ãã£ã³ãšãšãã«ã«ãŒãã«æ·»ä»ããŸãã
- äœæ¥æ瀺æžã«ã¯ãå®è¡ãããäœæ¥ãèšèŒãããŠããŸãã
- æ©åšã«ãŒãã«ã¯ã¡ã³ããã³ã¹å±¥æŽãå«ãŸããŠããŸãã
ç§ãã¡ã®ã·ã¹ãã ãçŸåšã©ã®ããã«æ©èœãããã瀺ããŸããã ããããMMS ã®åãçµã¿ã¯ãŸã çµãã£ãŠããŸããããã§ã«ããã€ãã®æ¹åãèšç»ãããŠããŸãã ããšãã°ãçŸåšãã¹ãã£ã³ã«ã¯å€ãã®æ å ±ãä¿åãããŠããŸãã å°æ¥çã«ã¯ãã¡ã³ããã³ã¹ãããŒããŒã¬ã¹åããäºå®ã§ããã¢ãã€ã« ã¢ããªã±ãŒã·ã§ã³ã«æ¥ç¶ãããšã³ãžãã¢ãããã¯ã¹ããã§ãã¯ããããã«ã«ãŒãã«æ å ±ãä¿åã§ããããã«ããŸãã
ãã¡ãããåæ§ã®æ©èœãåããæ¢è£œåãæ°å€ã販売ãããŠããŸãã ããããç§ãã¡ã¯å°ã㪠Excel ãã¡ã€ã«ã§ãæ¬æ Œçãªè£œåã«éçºã§ããããšã瀺ãããã£ãã®ã§ãã ããã¯èªåã§è¡ãããšããè«è² æ¥è ã«äŸé Œããããšãã§ããŸãããéèŠãªã®ã¯æ£ããã¢ãããŒãã§ãã ãããŠå§ããã®ã«é ããããšããããšã¯ãããŸããã
åºæïŒ habr.com