
1å·èã®çé ãExcelã«åããŠ30åã§éçïœç«¶èããŒã¿åéããŒã«ãäœã£ã
ãã£ããã¯ãæ¬åœã«åçŽã§ããã
ã1å·èã£ãŠãå®éã©ããããåã£ãŠããã ã£ãïŒã
ãµãšæ°ã«ãªã£ãŠãç«¶èã®å ¬åŒãµã€ããéããŸããã
ã¬ãŒã¹çµæãèŠãŠã1å·èã®çé ã確èªããŠãExcelã«ã¡ã¢ããã
次ã®ã¬ãŒã¹ãéãã
ãŸãçµæãèŠãã
ãŸãExcelã«å ¥åããã
æåã¯ããŸããããããããªãããçµããã ããããšæã£ãŠããŸããã
ã§ãã30åãããç¶ãããšããã§æããŸããã
ãããæäœæ¥ã§ãããã®ãããªããªã
ç«¶èã®å ¬åŒãµã€ãã«ã¯ãåæã«äœ¿ããããªæ å ±ãããªãå ¬éãããŠããŸãã
åºèµ°è¡šãå±ç€ºæ å ±ãæ°è±¡æ å ±ãã¬ãŒã¹çµæãææ»ã
å¿ èŠãªæ å ±ãã®ãã®ã¯ãã¡ãããšããã
åé¡ã¯ã
ãããŒã¿ãšããŠãŸãšããŠäœ¿ãããšãããšããšã«ãã倧å€ã
ãšããããšã§ããã
1ã¬ãŒã¹ãã€ããŒãžãéããŠãæ°åãæŸã£ãŠãExcelã«ã³ããŒããã
è€æ°ã®ç«¶èå Žãæ¯èŒããããšãããšãããã«å€§å€ã§ãã
å±ç€ºã¿ã€ã ãé²å ¥ãçé ã颚éãæ³¢é«ãã¢ãŒã¿ãŒæ å ±âŠâŠã
æäœæ¥ã§è»¢èšããŠãããšãã©ããã§åããºã¬ãããå ¥åãééãããããã
äœãããæéãããããŸãã
ããã§æããŸããã
ãããŒã¿ãèªåã§éããŠãä¿åãããšããã ãäœãã°ããããããªããïŒã
åæèªäœã¯Excelã§ã§ããã
ã ã£ããã
é¢åãªããŒã¿åéã ãèªååããŠããŸãã°ããã
ãããããã®ããŒã«ãäœãå§ãããã£ããã§ãã
æåã«æ±ºããããšããäºæ³ããŒã«ã«ã¯ããªãã

ç«¶èã®ããŒã¿ãæ±ãããŒã«ãšãããšã
ãAIäºæ³ã
ãåãŠãè²·ãç®ã
ãååçâïŒ
ã
ãå¿
åããžãã¯ã
ã¿ãããªæ¹åãæ³åãã人ãå€ããšæããŸãã
ã§ããä»åã®ããŒã«ã§ã¯ãæåãããããç®æããŸããã§ããã
äœããªããšæ±ºããã®ã¯ããã®3ã€ã§ãã
è²·ãç®ãèªåã§åºããªã
ããã®æ¡ä»¶ãªãåãŠãããšæå®ããæ©èœãäœããªã
èªåæç¥šã¯ããªã
çç±ã¯ã·ã³ãã«ã§ãã
äºæ³ãŸã§äœã£ãŠããŸããšãçµå±ã
ããã®äºæ³ã¯åœããã®ãïŒã
ãšãã話ã«ãªããŸãã
ã§ããèªåãæ¬²ããã£ãã®ã¯ããã§ã¯ãããŸããã§ããã
欲ããã£ãã®ã¯ã
ãèªåã§æ€èšŒããããã®ææããç°¡åã«éããããç°å¢ã
ã§ãã
äŸãã°ã
ã1å·èã¯ã©ã®ç«¶èå Žã§åŒ·ãã®ãã
ã远ã颚ãšåãã颚ã§çµæã¯å€ããã®ãã
ãå±ç€ºã¿ã€ã ãè¯ãéžæã¯æ¬åœã«çé ãè¯ãã®ãã
ãã¢ãŒã¿ãŒæçžŸãšå®éã®çµæã«é¢ä¿ã¯ããã®ãã
ãããã£ãããšã調ã¹ãããšæã£ããšããäžçªé¢åãªã®ã¯åæãã®ãã®ã§ã¯ãããŸããã
ãã®åã®ã
ããŒã¿ãéããäœæ¥ã§ãã
ã ããããã®ããŒã«ãæ åœããã®ã¯ã
ãéããã»ä¿åããã»ExcelãCSVã«åºãã
ãšãããŸã§ã«ããŸããã
ããããå ã¯ã䜿ã人ãèªç±ã«åæããã
ãã®æ¹ããããŒã«ãšããŠé·ã䜿ãããšæã£ãããã§ãã
å®éã®ããŒã¿ãåã£ãŠåããŠåãã£ãããš
ããçšåºŠããŒã«ãåãããã«ãªã£ãŠããã
3æ¥åã
1é±éåã
1ãæåã
ãšãå°ããã€æéãåºããªããå®éã«ããŒã¿ãååŸããŠãã¹ãããŸããã
ãããšãäœã£ãŠããã ãã§ã¯æ°ã¥ããªãã£ãåé¡ã次ã ã«åºãŠããŸããã
ç¹ã«å°è±¡ã«æ®ã£ãŠããã®ãã
éå¬äžæ¢ã®æ¥ã®æ±ãã§ãã
éå¬ãã®ãã®ãäžæ¢ã«ãªã£ãŠããæ¥ã§ããååŸå ããã¯ã¬ãŒã¹æ å ±ãè¿ã£ãŠããå ŽåããããŸãã
ãã ããåœç¶ã¬ãŒã¹ã¯è¡ãããŠããªãã®ã§çµæã¯ç©ºæ¬ã§ãã
æåã®ããŒã«ã§ã¯ããããã
ããŸã çµæãå ¬éãããŠããªãã
ãšå€æããŠããŸããã
ãããšã©ããªããã
次ã«åãæéãååŸãããšãã
ãŸããã®æ¥ãåãã«è¡ãã
次åãåãã«è¡ãã
ãã®æ¬¡ãåãã«è¡ãã
å®éã«ã¯ãã§ã«äžæ¢ã確å®ããŠããã®ã«ã
æ°žé ã«ãçµæåŸ ã¡ããšå€æããŠããŸãç¶æ
ã«ãªã£ãŠããŸããã
䌌ãã±ãŒã¹ã§ãæ°æž©ã ããæ¬ ããŠããã¬ãŒã¹ããããŸããã
å±ç€ºã¿ã€ã ã颚éãæ³¢é«ãªã©ã¯å ¥ã£ãŠããã
ã§ããæ°æž©ã ã空æ¬ã
æåã¯ã
ãããŒã¿ååŸã«å€±æããã®ããªïŒã
ãšæã£ãŠåååŸããããã«ããŠããŸããã
ãšãããäœåºŠååŸããŠãåãŸããªãã
調ã¹ãŠãããšãååŸå ã®ããŒã¿èªäœã«æ°æž©ãååšããŠããªãã±ãŒã¹ã§ããã
ã€ãŸãã
åŸ ã£ãŠããŠãæ°žé ã«åãŸããªãããŒã¿ã§ãã
ããŒã«ããããã°ã
ãããŒã¿ããªãã
ãšããç¶æ ã¯åãã§ãã
ã§ãå®éã«ã¯ã
ãååŸã«å€±æãããã®ãã
ãããããå ããŒã¿ãååšããªããã®ãã
ãéå¬ãäžæ¢ã ã£ããã®ãã
æå³ããŸã£ããéããŸãã
ãããåºå¥ããªããšãããŒã«ã¯ç¡é§ãªåååŸãç¹°ãè¿ããŸãã
å®éã«1ãæåã®ããŒã¿ã§æ€èšŒãããšãããä¿®æ£åã¯åãæéãããäžåºŠæå®ãããš11åã®éä¿¡ãçºçããŠããŸããã
ãã®åŠçãèŠçŽããçµæã
åãæéã2åç®ã«æå®ãããšãã®éä¿¡åæ°ã0å
ã«ããããšãã§ããŸããã
ããããéšåã¯ãã³ãŒããæžããŠããã ãã§ã¯ãªããªãåãããŸããã
å®éã®ç«¶èããŒã¿ãäœæ¥åãååŸããŠã
ããªãã§ããã ãäœåãååŸããŠããã ïŒã
ãšç¢ºèªããŠåããŠæ°ã¥ããŸããã
ä»åäžçªæéã䜿ã£ãã®ã¯ãããããããšããããéšåãããããŸããã
掟æã§ã¯ãªããã©ã倧äºã«ããéšå
ãã®ããŒã«ã«ã¯ãAIäºæ³ã®ãããªæŽŸæãªæ©èœã¯ãããŸããã
ãã®ä»£ããã
ããŒã¿åéããŒã«ãšããŠæ®éã«äœ¿ãç¶ããããããš
ãããªãæèããŸããã
äžåºŠåã£ãããŒã¿ã¯ãã§ããã ãåãçŽããªã
ååŸæžã¿ã®æéã¯ããŒã«åŽã§èšé²ããŠããŸãã
ãã®ãããäžåºŠæ£åžžã«ååŸããæéãå床æå®ããŠããå¿ èŠããªããã°å ¬åŒãµã€ããžã¢ã¯ã»ã¹ããŸããã
3æ¥ã7æ¥ã1ãæã®ç¯å²ã§å®éã«ç¢ºèªãã2åç®ã®ååŸã§ã¯éä¿¡ãçºçããªãããšããã¹ãããŸããã
ååŸå ã«è² è·ããããããªã
ããšã«ããæéã§å šéšååŸããããšããäœãã«ã¯ããŠããŸããã
ç¹ã«ã¢ã¯ã»ã¹åæ°ãå€ããªããããããŒã¿ã«ã€ããŠã¯ãååŸééã«å¶éãèšããŠããŸãã
ãªããºååŸã«ã€ããŠããåæç¶æ ã§ã¯OFFã
å©çšããå Žåã¯ç¢ºèªç»é¢ã衚瀺ãã仿§ã«ããŠããŸãã
é·ã䜿ãããŒã«ã ããããã
éããããç¡çã®ãªãååŸ
ãåªå ããŸããã
ãæ¬ æããšãç¹æ®ãªçµæããåãã
ç«¶èã§ã¯ã
éå¬äžæ¢ãäžæç«ããã©ã€ã³ã°ãªã©ã
éåžžãšã¯éãçµæã«ãªãã¬ãŒã¹ããããŸãã
ããããåçŽãªãããŒã¿æ¬ æããšããŠæ±ã£ãŠããŸããšãããšã§Excelã«åºãããšãã«åæçµæããããããªããŸãã
ããã§ã
ãååŸã§ããªãã£ãããŒã¿ã
ãšã
ãããããã¬ãŒã¹çµæã ã£ãããŒã¿ã
ãåããŠä¿åããããã«ããŸããã
å°å³ã§ãããåŸããããŒã¿ãåæãããšãã«ã¯ããªãéèŠãªéšåã§ãã
ä»ã§ããããš
çŸæç¹ã§ããã®ããŒã«ã§ã¯ä»¥äžã®ããšãã§ããŸãã
æ¥ä»ãæå®ããŠç«¶èããŒã¿ãååŸ
ç«¶èå Žãæå®ããŠååŸ
ååŸããããŒã¿ãPCå ã«ä¿å
ExcelïŒ.xlsxïŒåœ¢åŒã§åºå
CSV圢åŒã§åºå
ã©ããŸã§ããŒã¿ååŸãå®äºããŠããã確èª
ååŸã«å€±æããããŒã¿ããªãã確èª
ååŸæžã¿ããŒã¿ã®éè€ååŸã鲿¢
ã€ãŸãã
ç«¶èããŒã¿ãéãããšããããèªååããããŒã«
ã§ãã
ä»ã®ãšããã
ãæ¡ä»¶ãå ¥ãããåãŠãã¬ãŒã¹ãèªåã§æ¢ãã
ãããããã®è²·ãç®ã衚瀺ããã
ãšãã£ãæ©èœã¯ãããŸããã
ããã¯ä»åŸãå®éã«éããããŒã¿ã䜿ã£ãŠæ€èšŒããªããèããŠããããšæã£ãŠããŸãã
ãŸãã¯ã
ãããŒã¿ãéããã
ãšããäžçªé¢åãªéšåããã¡ãããšäœ¿ãããšãããŸã§ä»äžããŸããã
ãã®ããŒã«ã䜿ã£ãŠãããããæ€èšŒãããããš
å人çã«ã¯ãããŒã«ãäœãããšèªäœãããã
ãããããé¢çœããšæã£ãŠããŸãã
äŸãã°ã
1å·èã¯æ¬åœã«ã©ããããæå©ãªã®ã
ç«¶èå Žã«ãã£ãŠã€ã³éãçã¯ã©ããããéãã®ã
颚éãåŒ·ãæ¥ã¯çµæã«å€åãããã®ã
å±ç€ºã¿ã€ã ã¯ã©ããŸã§ä¿¡çšã§ããã®ã
ã¢ãŒã¿ãŒæçžŸãšçé ã«ã¯ã©ããããé¢ä¿ãããã®ã
ãããã£ãããšããå®éã®ããŒã¿ã§æ€èšŒããŠã¿ããã
ããããæ€çŽ¢ãããšã
ãç«¶èã¯ââãèŠãã¹ãã
ããã®æ¡ä»¶ã¯çããã
ãšããæ å ±ã¯ããããåºãŠããŸãã
ã§ãã
æ¬åœã«ãããªã®ãïŒ
ãèªåã§å€§éã®ããŒã¿ã䜿ã£ãŠç¢ºèªããããšã¯ãããŸããã§ããã
ãã®æ€èšŒãããããã®åå°ãšããŠäœã£ãã®ããä»åã®ããŒã«ã§ãã
ä»åŸã«ã€ããŠ

ãã®ç«¶èããŒã¿åéããŒã«ã¯ããã®åŸãBoatData Collector ProïŒBASICïŒããšããŠè²©å£²ãå§ããŸããã
èªåã®å¥œããªå Žã»æéã§åãããã«æ°ãããæ¹ã®ããã«ãããŒã«ã2ã€çšæããŠããŸãã
ããŒã¿åéçãBoatData Collector ProïŒBASICïŒãïŒå šåœ24å Žã®åºèµ°è¡šã»çŽåæ å ±ã»æ°è±¡ã»çµæã»ææ»ããæéãšå Žãéžãã§ãŸãšããŠååŸããExcelã»CSV ã«åºããŸãã6,000åã§ãnote ã§è²©å£²ããŠããŸãã
åæçãBOAT DATA PROãïŒBASIC ã®æ©èœã«ãéžæã«ã«ãã»ã¢ãŒã¿ãŒåæã»æ¡ä»¶æ€çŽ¢ãªã©ã®éèšç»é¢ãä»ããŸãã10,000åã§ãã³ã³ãã©ã§è²©å£²ããŠããŸãã
ãŸã詊ããªããBASIC ã®ç¡æçã§ããåããæéãçŽè¿30æ¥ãŸã§ã§ãã»ãã®æ©èœã¯ææçãšåãã§ããå ¬åŒ LINE ã§åãåããŸãã
ã©ããäºæ³ãè²·ãç®ã¯åºããŸãããéããŠæ°ããããã® Windows çšã®éå ·ã§ãã
â BASIC ã®å 容ãšè³Œå ¥ïŒnoteïŒ
â åæç PRO ã®ç޹ä»èšäº
â ç¡æçã LINE ã§åãåã
ãã ããå ã«æžããŠãããšã
ãã®ããŒã«ãè²·ãã°ç«¶èã§åãŠãããã«ãªãããšãããã®ã§ã¯ãããŸããã
è²·ãç®ãåºããŸããã
å¿ åæ³ãå ¥ã£ãŠããŸããã
ããã®ã¯ã
ç«¶èã®ããŒã¿ããèªåã§èª¿ã¹ãããã®ç°å¢
ã§ãã
ãæèŠã§ã¯ãªããäžåºŠã¡ãããšããŒã¿ãèŠãŠã¿ããã
ãExcelã§èªåãªãã«åæããŠã¿ããã
ãæ¯åå ¬åŒãµã€ãããæäœæ¥ã§éããã®ãé¢åã
ãããªäººåãã®ããŒã«ã§ãã
次ã®èšäºã§ã¯ã
å®éã«ã©ããªããŒã¿ãååŸã§ããã®ããããŒã«ã®ç»é¢ãšExcelåºåã®äžèº«
ãããå°ã詳ãã玹ä»ããããšæããŸãã
ãããŠããã®æ¬¡ããã¯å®éã«éããããŒã¿ã䜿ã£ãŠã
ãç«¶èã§ããèšãããŠããå®èª¬ã¯ãæ¬åœã«ããŒã¿ã§ããããªãã®ãïŒã
ãå°ããã€æ€èšŒããŠããäºå®ã§ãã
ç«¶èããŒã¿æ€èšŒã·ãªãŒãº