ããœã³ã³æå®€ã«éãããããã©ãçµå±ç·é¡ã§ããããããã®ãäžå®ã«æããŠããŸãããïŒããœã³ã³æå®€ã®æéäœç³»ã¯ãå ¥äŒéãæè¬ãã¬ãã¹ã³æãææè²»ãªã©å€å²ã«ããããæå®€ã«ãã£ãŠå€§ããç°ãªããŸããæ¬èšäºã§ã¯ãäž»èŠãªããœã³ã³æå®€ã®æéçžå ŽãåŸ¹åºæ¯èŒããåå¿è ã§ã倱æããªãããã®éžã³æ¹ã®ãã€ã³ãããå®éã«éã£ã人ã®ãªã¢ã«ãªäœéšè«ã詳ãã解説ããŸããèªåã«ãŽã£ããã®ã¹ã¯ãŒã«ãèŠã€ããŠãå¹çããã¹ãã«ã¢ããããŸãããã
- ããœã³ã³æå®€ã®æéçžå Žãšå èš³ïŒåæè²»çšãæããã³ã
- 倧æã»æ Œå®ããœã³ã³æå®€ãåŸ¹åºæ¯èŒïŒæè¬ãšã¬ãã¹ã³ã®éã
- åå¿è ã倱æããªãããœã³ã³æå®€ã®éžã³æ¹ïŒ5ã€ã®éèŠé ç®
- åè¬çã®å£ã³ãããèŠãå®éã®è²»çšãšåŠç¿å¹æã®ãªã¢ã«
- ç®çã«åãããããããã¹ã¯ãŒã«ïŒè³æ ŒååŸããéãæŸé¡ãŸã§
- ãŸãšãïŒèªåã«åã£ãããœã³ã³æå®€ãè³¢ãéžã¶ããã«
ããœã³ã³æå®€ã®æéçžå Žãšå èš³ïŒåæè²»çšãæããã³ã
ããœã³ã³æå®€ã®æéäœç³»ã¯ã倧ããåããŠãæè¬å¶ããšãåæ°å¶ïŒãã±ããå¶ïŒãã®2çš®é¡ããããŸããå€ãã®åå¿è ãéžã¶æè¬å¶ã®æå®€ã¯ã1åãããã®å䟡ãå®ãèšå®ãããŠããããšãå€ããèšç»çã«éããããã®ãç¹åŸŽã§ããäžè¬çã«ãå ¥äŒéãšããŠ11,000åçšåºŠãå¿ èŠãšãªããããã«å ããŠ1ã¬ãã¹ã³ïŒ60åïŒããã1,500åã2,000åååŸã®åè¬æãçºçããŸããããã«ãåŠç¿å 容ã«åãããããã¹ã代ã1,000åã3,000åçšåºŠãããã®ãæšæºçãªæ§æã§ããåæè²»çšãæããããã«ã¯ããã£ã³ããŒã³æéãçã£ãŠå ¥äŒéãç¡æã«ããããããã¯ããã¹ã代ãäžèŠãªãéãæŸé¡ãã©ã³ããããæå®€ãéžã¶ã®ãè³¢ãéžæãšèšããã§ãããã
ãªãæéäœç³»ãããã»ã©è€éãªã®ããšãããšãããã¯æå®€ããšã«æäŸãããµããŒãäœå¶ãèšåã®å å®åºŠãç°ãªãããã§ããäŸãã°ãå®å šãã³ããŒãã³ã®å奿å°ãè¡ãæå®€ã§ã¯ãè¬åž«ã®äººä»¶è²»ããã®ãŸãŸæéã«åæ ãããããã1ã¬ãã¹ã³ãããã®å䟡ã¯é«ããªããŸããäžæ¹ã§ãæ åææãæŽ»çšããŠåèªãåŠç¿ãé²ããåãããªãç®æã ãè¬åž«ã«è³ªåãã圢åŒã®æå®€ã§ã¯ãã³ã¹ããæããŠãªãŒãºããã«ãªäŸ¡æ Œèšå®ãå®çŸããŠããŸããã©ã¡ããè¯ããã¯å人ã®åŠç¿ã¹ã¿ã€ã«ã«ãããŸãããèªåã®äºç®ãšç®æšãç §ããåãããŠãç¡çãªãç¶ããããã·ã¹ãã ãèŠæ¥µããããšãéèŠã§ãã
çµè«ãšããŠãããœã³ã³æå®€ãéžã¶éã¯ã衚é¢äžã®æè¬ãã ãã§ãªããå ¥äŒéãææè²»ãå«ãããéåŠæéå šäœã®ç·é¡ãã§æ¯èŒããããã«ããŸããããç¹ã«åå¿è ã®å Žåãåºç€ããå¿çšãŸã§åŠã¶ã®ã«æ°åæéã¯ãããããšãäºæ³ãããŸããããããããWordãšExcelããã¹ã¿ãŒãããŸã§ã«äœæéå¿ èŠãããã«ãŠã³ã»ãªã³ã°ã§ç¢ºèªããããŒã¿ã«ã®åºè²»ãã·ãã¥ã¬ãŒã·ã§ã³ããŠããããšããåŸæããªãããã®æå€§ã®ãã€ã³ãã§ãã詳ããã¯ãã¡ãã®æéã»å£ã³ãæ¯èŒãåèã«ããŠã¿ãŠãã ããã
倧æã»æ Œå®ããœã³ã³æå®€ãåŸ¹åºæ¯èŒïŒæè¬ãšã¬ãã¹ã³ã®éã
åœå ã«ã¯æ°å€ãã®ããœã³ã³æå®€ããããŸããã倧æãã§ãŒã³ãšå°åå¯çåã®æ Œå®ã¹ã¯ãŒã«ã§ã¯ãæéèšå®ã«æç¢ºãªéãããããŸããäŸãã°ãå šåœå±éããŠããããããŒïŒããœã³ã³æå®€ãã§ã¯ã1ã¬ãã¹ã³1,760åãšããèšå®ã§ãããå¥éå ¥äŒé11,000åãããã¹ã代ãå¿ èŠã§ããããã«å¯Ÿãããããœã³ã³æå®€ããããšã§ãããã§ã¯1æéããã1,870åã«å ããŠæäŒè²»2,200åãå¿ èŠãšãªããªã©ãåºå®è²»ã®æç¡ãæ¯èŒã®å¯Ÿè±¡ã«ãªããŸããäžæ¹ãããã¥ãªãªã¹ããŒã·ã§ã³ãã®ããã«ã1ã¬ãã¹ã³1,650åãããšããéåžžã«å®äŸ¡ãªèšå®ã売ãã«ããŠããã¹ã¯ãŒã«ããããäºç®éèŠã®ãŠãŒã¶ãŒããé«ãæ¯æãåŸãŠããŸãã
ããããæéã®å·®ã¯ãäž»ã«ã«ãªãã¥ã©ã ã®æè»æ§ãéããããã«çŽçµããŠããŸãã倧æã®æå®€ã¯ããªãªãžãã«ã®åãããããææããMOSè³æ Œãªã©ã®è³æ Œè©ŠéšäŒå ŽãšããŠèªå®ãããŠããå®å¿æããããŸãã察ããŠæ Œå®ã売ãã«ããæå®€ã¯ãç¡é§ãªåºåè²»ãåããå°åã«å¯çããå°èŠæš¡éå¶ãè¡ãããšã§ã³ã¹ããéå ããŠããŸããæè¿ã§ã¯ããããã©ãã©ããªãã®ããã«ã1æ¥éç¿åœ¢åŒã§ç¹å®ã®ãœããã19,800åããåŠã¹ããå ¥äŒéäžèŠã®åããããããã©ã³ãæç€ºããæå®€ãå¢ããŠãããçæéã§ã¹ãã«ãç¿åŸãããããžãã¹ãã³ã«äººæ°ã§ãã
å®ãã ãã§éžã¶ã®ã§ã¯ãªãããã®æéã§ãã©ããŸã§ãµããŒãããŠããããããã確èªããããšã倧åã§ããå®äŸ¡ãªã¹ã¯ãŒã«ã®äžã«ã¯ã質ååæ°ã«å¶éããã£ãããäºçŽãåãã«ããã£ããããå ŽåããããŸããéã«ãå°ãé«ãã§ããèŠãããŸã§äœåºŠã§ãéããå®é¡å¶ããæ¡çšããŠããæå®€ã§ããã°ãçµæçã«1æéãããã®ã³ã¹ããåçã«äžããããšããããŸããèªåã®ã©ã€ãã¹ã¿ã€ã«ã«åãããŠãé±ã«äœåéããããèããäžã§ãæé©ãªãã©ã³ãæç€ºããŠãããæå®€ãéžã³ãŸãããããããã©ãã©ããªã®è©³çްã¯ãã¡ããã確èªã§ããŸãã
åå¿è ã倱æããªãããœã³ã³æå®€ã®éžã³æ¹ïŒ5ã€ã®éèŠé ç®
ããœã³ã³æå®€éžã³ã§å€±æããªãããã«ã¯ãæé以å€ã«ããã§ãã¯ãã¹ãéèŠãªé ç®ã5ã€ãããŸãããŸã1ã€ç®ã¯ãåŠã³ããè¬åº§ãããããã§ããOfficeãœããã®åºæ¬æäœã¯ãã¡ãããããã°ã©ãã³ã°ãSNS掻çšãã¹ããæäœãªã©ãèªåã®ç®çã«åèŽããã«ãªãã¥ã©ã ããããã確èªããŠãã ããã2ã€ç®ã¯ãåŠç¿ææã®çš®é¡ãã§ããçŽã®ããã¹ãã§ãã£ããåŠã³ããã®ããæ åææ¥ãèªåã®ããŒã¹ã§é²ãããã®ãã«ãã£ãŠãåãäžåããåãããŸãã3ã€ç®ã¯ãã¬ãã¹ã³ã¹ã¿ã€ã«ãã§ãäžæææ¥åœ¢åŒãªã®ããèªåã®åžã§é²ããå奿å°ãªã®ãã確èªããŸãããã
4ã€ç®ã¯ãéããæéãšæéã®æè»æ§ãã§ããä»äºåž°ãã«éãããå Žåã¯ãå€é ããŸã§éè¬ããŠãããããããã¯åœæ¥äºçŽã®ãã£ã³ã»ã«ãå¯èœãã©ãããç¶ç¶ã®éµãšãªããŸãã5ã€ç®ã¯ãå£ã³ããè©å€ãã§ãããããäžã®è©äŸ¡ã ãã§ãªããå®éã«ç¡æäœéšã¬ãã¹ã³ãåããŠãè¬åž«ã®æãæ¹ãæå®€ã®é°å²æ°ãèã§æããããšãããã¹ããããé²ãæåã®æ¹æ³ã§ããç¹ã«ãè¬åž«ãšã®çžæ§ã¯åŠç¿ã®ã¢ãããŒã·ã§ã³ã«çŽçµãããããéåžžã«éèŠãªèŠçŽ ãšãªããŸãã
ãããã®ãã€ã³ããæŒãããããšã§ãé«ãææ¥æãæã£ãã®ã«äœã身ã«ã€ããªãã£ããšãããªã¹ã¯ãæå°éã«æããããŸããç¹ã«åå¿è ã®å Žåãããœã³ã³ãè§Šãããšèªäœã«èŠææèãããããšãå€ããããç¡çã®ãªãã¹ãããã¢ãããææ¡ããŠãããæå®€ãã©ãããéèŠã§ããç¡æäœéšã§ã¯ãèªåã®ç®æšãéæãããŸã§ã«ã©ããããã®æéãšè²»çšãããããããå ·äœçã«è³ªåããçŽåŸã®ããåçãåŸããããã©ãããå€æåºæºã«ããŸããããåå¿è åãããœã³ã³æå®€10éžãéžèã®åèã«ããŠã¿ãŠãã ããã
åè¬çã®å£ã³ãããèŠãå®éã®è²»çšãšåŠç¿å¹æã®ãªã¢ã«
å®éã«ããœã³ã³æå®€ã«éã£ã人ãã¡ã®å£°ãèããšãã«ã¿ãã°ã¹ããã¯ã ãã§ã¯èŠããŠããªãããªã¢ã«ãªå®æ ããèŠããŠããŸããããåè¬çã¯ãæåã¯60æéã®ã³ãŒã¹ããã¹ã¿ãŒãããå ¥äŒéãšããã¹ã代ãåãããŠ82,000åã»ã©ã§åºç€ãåºããããã§ãããã®åŸãããã«é«ãã¹ãã«ãæ±ããŠåèš200æéã»ã©éããŸããããç·é¡ã¯23äžåçšåºŠã«åãŸã£ããšãããŸãã1æéãããã«æç®ãããšçŽ1,150åãšãªããç¬åŠã§æ©ãæéãèããã°éåžžã«ã³ã¹ãããã©ãŒãã³ã¹ãè¯ããšæããããã§ãããã®ããã«ãé·ãéãã»ã©1æéãããã®ã³ã¹ããäžããä»çµã¿ãå°å ¥ããŠããæå®€ããããŸãã
äžæ¹ã§ãå šãã®åå¿è ããã¹ã¿ãŒãããå¥ã®åè¬çã¯ããããœã³ã³ã®é»æºã®å ¥ãæ¹ããåãããªãã£ãããæäœããªããæåäœéšãç©ããæå®€ãéžãã ããšã§ãæ«æããã«ç¶ããããããšèªã£ãŠããŸãããã®æ¹ãéã£ãã®ã¯ãå匷ããªãããœã³ã³æå®€ããšããã³ã³ã»ããã®å Žæã§ã座åŠãããå®éã«æãåããããšãéèŠããã¹ã¿ã€ã«ã§ããããã®ããã«ãèªåã®ã¬ãã«ã«åãããã¢ãããŒããã§ããæå®€ã§ããã°ãæºè¶³åºŠã¯éåžžã«é«ããªãåŸåã«ãããŸããéã«ãé£ããããã«ãªãã¥ã©ã ãç¡çããé²ãããããªæå®€ã§ã¯ãè²»çšã®å²ã«ææãåºã«ãããšããäžæºã®å£°ãèãããŸãã
å£ã³ããåæãããšãå ±éããŠããã®ã¯ãäºåã®ã«ãŠã³ã»ãªã³ã°ã®éèŠæ§ãã§ããæºè¶³ããŠãã人ã®å€ãã¯ãå ¥äŒåã«èªåã®ããããããšãæç¢ºã«äŒããããã«å¯Ÿããæé©ãªãã©ã³ãæç€ºããŠããã£ãŠããŸããéã«ãå§ããããããŸãŸã«é«é¡ãªã³ãŒã¹ãå¥çŽããŠããŸã£ã人ã¯ãåŸæããŠããã±ãŒã¹ãå€ãããã§ãããŠãŒã¶ãŒã®å£°ã¯ããã®æå®€ãã©ãã ãåè¬çäžäººã²ãšãã«å¯ãæ·»ã£ãŠããããç€ºãææšã«ãªããŸããèªåã®äºç®å ã§æå€§éã®å¹æãåŸãããã«ãæåäºäŸã ãã§ãªããã©ã®ãããªãã©ãã«ãæ©ã¿ããã£ããã«ã€ããŠãç®ãåããŠãããšè¯ãã§ããããå®éã®å£ã³ã詳现ã¯ãã¡ãã§ç¢ºèªã§ããŸãã
ç®çã«åãããããããã¹ã¯ãŒã«ïŒè³æ ŒååŸããéãæŸé¡ãŸã§
æåŸã«ãç®çå¥ã«ããããã®ããœã³ã³æå®€ãããã€ã玹ä»ããŸããè³æ ŒååŸãç®æããªããé«ãåæ ŒçãèªããWinã¹ã¯ãŒã«ããæé©ã§ããæå®€åè¬ãšãªã³ã©ã€ã³åè¬ã䜵çšã§ãããããå¿ããæ¹ã§ãç¶ç¶ããããç°å¢ãæŽã£ãŠããŸããäžæ¹ãè¶£å³ãçæŽ»ã§æŽ»çšãããã·ãã¢ãåå¿è ã«ã¯ãæåããµããŒããé åã®ãããœã³ã³åžæ°è¬åº§ãããæã 3,300åãšããæ Œå®ã§éãæŸé¡ãã©ã³ãæäŸããŠããããã£ãŒãããã»ã¹ããŒã·ã§ã³ããéžã°ããŠããŸããç¹ã«éãæŸé¡ã¯ãæ¯æ¥ã§ãéããããšããææ¬²çãªæ¹ã«ãšã£ãŠã究極ã®ã³ã¹ãããã©ãŒãã³ã¹ãå®çŸããéžæè¢ã§ãã
ä»äºã®ã¹ãã«ã¢ãããç®æããªããå®åã«å³ããVBAïŒããã°ã©ãã³ã°ïŒãããŒã¿åæãŸã§åŠã¹ãããããŒïŒããœã³ã³æå®€ãã匷ã峿¹ã«ãªããŸããããã§ã¯ç¡æäœéšæã«åå¥ã®ã«ãªãã¥ã©ã ãçµãã§ããããããç¡é§ãªåŠç¿ãçããæçè·é¢ã§ç®æšã«å°éã§ããŸãããŸãããåæ§ãããå®¶åºã§ããã°ãããããããã°ã©ãã³ã°è¬åº§ã䜵èšããŠãããGOOD TIME / ã¹ã¯ãŒã«ãã®ãããªãå€äžä»£ã«å¯Ÿå¿ããå奿å°åã¹ã¯ãŒã«ãæ€èšã®äŸ¡å€ããããŸããããããã®æå®€ã«ã¯åŒ·ã¿ããããããèªåã®ããªãããå§¿ããã€ã¡ãŒãžããŠéžã¶ããšãæåãžã®è¿éã§ãã
ããœã³ã³æå®€ã¯ãåã«æäœãæããå Žæã§ã¯ãªããèªåã®å¯èœæ§ãåºããããã®æè³ã®å Žã§ããããŸããæéãå®ãããšã¯éèŠã§ããããã以äžã«ãèªåã®äººçãã©ãå€ãããããéèŠããŠéžãã§ãã ããããŸãã¯æ°ã«ãªã£ãæå®€ã®ç¡æäœéšã«è¶³ãéã³ãè¬åž«ã®ç±æãæå®€ã®ç©ºæ°æã確èªããããšããå§ããŸããããèªåã«ãŽã£ããã®ã¹ã¯ãŒã«ãèŠã€ããã°ãããœã³ã³ãžã®èŠææèã¯æ¶ããæ°ããäžçãéããã¯ãã§ãããã£ãŒãããã»ã¹ããŒã·ã§ã³ã®è©³çްã¯ãã¡ããããã§ãã¯ããŠã¿ãŠãã ããã
ãŸãšãïŒèªåã«åã£ãããœã³ã³æå®€ãè³¢ãéžã¶ããã«
- 1. æéã¯å ¥äŒéã»æè¬ã»ææè²»ã®ãç·é¡ãã§æ¯èŒããäºç®å ã«åãŸãã確èªããã
- 2. å奿å°ãæ åææ¥ããèªåã®æ§æ ŒãåŠç¿ã¹ã¿ã€ã«ã«åã£ã圢åŒãéžã¶ã
- 3. è³æ ŒååŸãä»äºã®å¹çåãè¶£å³ãªã©ãæç¢ºãªç®çãæã£ãŠã«ãªãã¥ã©ã ãéžã¶ã
- 4. äºçŽã®åãããããéåŠã®ãããããªã©ãç¶ç¶ã§ããç°å¢ãæŽã£ãŠããã確èªããã
- 5. å¿ ãç¡æäœéšãåããè¬åž«ãšã®çžæ§ãæå®€ã®é°å²æ°ãèªåã®ç®ã§ç¢ºãããã
ããœã³ã³æå®€éžã³ã¯ãããããã®ã¹ãã«ã¢ããã®è³ªãå·Šå³ããéèŠãªã¹ãããã§ããä»åã玹ä»ããæéçžå Žãéžã³æ¹ã®ãã€ã³ããæŽ»çšããŠãããªãã«ãšã£ãŠæé«ã®åŠã³ã®å ŽãèŠã€ããŠãã ãããçŠãããã£ãããšæ¯èŒæ€èšããããšã§ãçŽåŸã®ããã¹ã¯ãŒã«éžã³ãã§ããã¯ãã§ãã


