
#208 æ¯æã®æ®æ¥å°çð«ããæãåºãæ¹æ³ãšã¯ïŒð»èªåã®æéãå¢ããèªååãå§ããŠã¿ãŸãããïŒâš
ãã¯ããããããŸãããŸãã§ãïŒâïžâš
æ¯æã®ææ«æåã
çµãããªãæ®æ¥ã®åµã§
ããããã«ãªã£ãŠããŸãããïŒ
ããŸãçµé»ã âŠâŠã
ããªãã§ç§ã°ãããããªã«
æäœæ¥ã°ããããŠãããã ããâŠâŠãã£ãŠã
ããœã³ã³ã®åã§ã°ãã¿ãªæºæ¯ãã€ãæ¯æ¥ã¯ã
ããçµããã«ããŸãããïŒ
å®ã¯ãã€ãŠ15幎ã»ã©çµçãããŠããç§ãã
æ·±å€ãŸã§ã®æ®æ¥ã培å€ã®é£ç¶ã§
å¿ãšäœãå®å
šã«å£ãã
äŒè·ããèŠãéå»ããããŸãã
äŒè°è³æã®å±±ã
ãã©ãã©ã«å±ãããŒã¿ã®çªåã
æ¯æåãçžæã«éãç¶ããè«æ±æžã®ä¿ãã¡ãŒã«âŠâŠã
ãæ¬åœã¯ãã£ãšããããä»äºãããã®ã«ã
éåã ãã§ä»æ¥ãçµãã£ãŠããã
ãšãããã®çµ¶ææã¯ã
çãã»ã©ããåãããŸãã
ã ããããã
éå»ã®èªåãšåãããã«
æ¥ã
ããæžã£ãŠããããªããžã
匷ãäŒãããïŒ
ãã以äžèªåã®ããæžããæ¯æ¥ã«ãµãšãã©ããŠã
ãã£ãšæ¥œãããããã«ã
ããã°ã©ãã³ã°ãäœéšããŠã¿ãŸãããïŒ

ããã°ã©ãã³ã°ç¥èãŒãããã§ã
ãGASïŒGoogle Apps ScriptïŒãããã¹ã¿ãŒããã°ã
æ¯æã®é¢åãªã«ãŒãã£ã³äœæ¥ããã¿ã³ã²ãšã€ã»æ°ç§ã§
çµããããæåŒ·ã®èªååç°å¢ãæã«å
¥ããŸãïŒ
æäœæ¥ã®ã¹ãã¬ã¹ããå®å šã«è§£æŸããã
ããªãã®èªç±ãªæéãåçã«å¢ããã
æ¯æ¥ã®ä»äºãã¯ã¯ã¯ã¯ãããã®ã«å€ããŠããæªæ¥ãã
ããããäžç·ã«æŽã¿åããŸãããïŒð

ð€ãã®èšäºããªã¹ã¹ã¡ãªäºº
æ¯æã®ææ«æåã«æ®æ¥ãç¶ããå¿èº«ãšãã«ç²ãæãŠãŠããã£ãããæ¹
ãšã¯ã»ã«ã®ã³ãããã¡ãŒã«éä¿¡ãªã©ãæ¯æåãæäœæ¥ã«ããããããŠããã£ãããæ¹
ããã°ã©ãã³ã°ãITã¹ãã«ã¯ãŒãã ãã©ãæ¥åå¹çåããŠèªåã®èªç±ãªæéãå¢ããããæ¹
ããã§ã¯ãæ¬é¡ã«å ¥ããŸããïŒ
ä»åã¯ã
ãããã°ã©ãã³ã°ã§
ãªãä»äºãåçã«æ¥œã«ãªãã®ãïŒ

ãããŠãªãä»ã
GASïŒGoogle Apps ScriptïŒãåŠã¶ãš
æªæ¥ãã¬ã©ãªãšå€ããã®ãïŒãã«ã€ããŠã
ã話ãããŠãããŸãð
ããã°ã©ãã³ã°æªçµéšã®æ¹ã«ããã
ãŸãã¯ãGASããåŠã¶ããšã
匷ããªã¹ã¹ã¡ããããŸãïŒâš
ããããã
ããªãããã°ã©ãã³ã°ã䜿ããš
ä»äºã楜ã«ãªãã®ãïŒããšãããšã
ããã¯äººéãäžçªèŠæãšãã
ãéå±ãªåçŽäœæ¥ããã
äžç¬ã§çµããããŠãããããã§ãð»

æã®ç§ã¯ã
æ·±å€ãŸã§æäœæ¥ã§ããŒã¿ãæœåºãããã
åãå
容ã®ã¡ãŒã«ãäœä»¶ãã³ããããŠ
éä¿¡ãããããŠããŸããã
人éã®æã§ãããšã
ã©ãã ãæ°ãã€ããŠããŠãã
æ·±å€ã®ç²ããè³ã§ã¯ã³ãããã¹ã
èŠèœãšããšãã£ããã¥ãŒãã³ãšã©ãŒã
å¿
ãèµ·ããŠããŸããŸãã
ããã«ã
ããŸããã®é¢åãªäœæ¥ã
ããªãããããªãã®ãâŠã
ãšããå¿ççãªã¹ãã¬ã¹ãã
å°å³ã«å¿ãããæžãããŠãããã§ãããð¢
ã§ãã
GASã䜿ã£ãŠãèªååã®ä»çµã¿ã
ãäžåºŠäœã£ãŠããŸãã°ã

åŠçã®ã¹ããŒãïŒ
人éãäœæéãããã£ãŠããäœæ¥ãããã¿ã³ã²ãšã€ã§æ°ç§ã«ççž®ãããâ°æ£ç¢ºæ§ïŒ
ããã°ã©ã ã¯ã«ãŒã«éãã«æ£ç¢ºã«åãããããã¹ããšã©ãŒããŒãã«ãªãð¯ç²Ÿç¥çããšãïŒ
ãææ¥ã¯ãã®é¢åãªäœæ¥ããããªããâŠããšããçµããã®ãªããã¬ãã·ã£ãŒããè§£æŸãããð
ãã®ããã«ã
æéçã«ã
粟ç¥çã«ã
倧ããªäœè£ãçãŸããããããã
ããã°ã©ãã³ã°ãåãå
¥ãããš
ä»äºãåçã«æ¥œã«ãªãã®ã§ãïŒ
ããŸãã«
GASãçŽ æŽãããçç±ã¯ä»ã«ããã£ãŠã
ãã€ã䜿ã£ãŠããGoogleã¢ããªãããŒã¹ã ãã

å§ããããã®èšå®ãäžèŠ
ç¡æã§å§ãããã
å®åã§äœ¿ãããã®ãããã§ãã
ã¡ãªãããçãã ããããªã®ã§ãð

äŸãã°ã
ãã¹ãã¬ããã·ãŒãã«
å
¥åããã¹ã±ãžã¥ãŒã«ãã
èªåã§Googleã«ã¬ã³ããŒã«ç»é²ããã
ããã
æäœæ¥ã§å
šéšãã£ãããã¡ããã¡ãé¢åã§ããã
ãã¹ãèµ·ããããã§ãããðŠ
ã§ãã
ç§ã®è¬åº§ã§ãäŒãããŠããã³ãŒãã䜿ãã°ã
ãããäžç¬ã§èªååã§ããŠããŸãã®ã§ãâš
å
å®¹ïŒ ç¥èãŒãããOKïŒ2æéã§ã¹ãã¬ããã·ãŒãããã«ã¬ã³ããŒãžã®äºå®ç»é²ã»ä¿®æ£ãŸã§ããã¹ã¿ãŒã
å®çžŸïŒ 14ååè¬ã»ãã¡ãã¯ãªããšè©äŸ¡ãâ
4.83ãïŒð
ã¯ãŒãã³ã³ãŒãïŒMAME202607
ç¡æã¯ãŒãã³ã¯ãã8æ8æ¥ãŸã§ãã®æééå®ã§ãïŒâ³
ãã§ããããã°ã©ãã³ã°ãªããŠé£ãããâŠâŠã
ãã³ãŒããªããŠ1è¡ãæžããªããâŠïŒã
ãããªæ¹ããå®å¿ãã ãããïŒ

åå¿è
ã®æ¹ã§ã
ãã®ãŸãŸç䌌ããŠåãããããã«ã
å
·äœçãªæé ããã£ã·ãè©°ã蟌ãã§ãããŸãð
ç±å¿ãªããªããªãã
ãã®GASã®ä»çµã¿ãããŒã¹ã«ããŠã
ãèªèº«ã®è·å Žã®ã«ãŒãã£ã³ã¯ãŒã¯ã«
åãããå¿çšãããã«ã§ããããã«ãªããŸããã
äŸãã°ã
Excelã®ãã¯ãã«çœ®ãæããŠ
æ¯æã®éèšãç§éã§çµãããããã
Pythonã䜿ã£ãŠ
Webããã®ããŒã¿åéãèªååãããâŠâŠã

æ¥åå¹çåã®åŒãåºãã
äžæ°ã«åºãã£ãŠããã®ã§ãð¡
ã ããããã
ç§ãã¡ãããã°ã©ãã³ã°ãåŠã¶æ¬åœã®ç®çã¯ã
ãé£ããã³ãŒããæèšããããšãã§ã¯ãªãã®ã§ãã
é¢åãªæäœæ¥ãèªååããŠèªåã®èªç±ãªæéãå¢ããã
æ¯æ¥ã®ä»äºãã©ã¯ã«ã
ãããŠæ¥œããã¯ã¯ã¯ã¯ãããã®ã«å€ããããšð
ãæ¯æ¥æ®æ¥ã°ããã§èªåã®æéããªãâŠâŠã
ããã£ãšèªåã®æéã倧åã«ãããâŠâŠã
ãããªããªãã®æªæ¥ãæããããããã®ç¬¬äžæ©ãšããŠã
ãã²ç§ã®è¬åº§ãããŠããŠãèŠããŠã¿ãŠãã ãããð¡
Udemyã§ã¯ã
åå¿è
åãã®ããã°ã©ãã³ã°ã»èªååè¬åº§ãå
¬éããŠãããŸãïŒ
ä»ããå®è·µãããªãæ¹ã§ãã
ãŸãã¯ç»é²ããŠããã ãã§
ãçäŒã¿ã鱿«ã«ãã£ããåŠã¹ãŸãã®ã§ã
ãã²ãæ°è»œã«ãã§ãã¯ããŠã¿ãŠãã ãããðâš
ããã§ã¯ããŸãã§ããïŒð
#ä»äºã«ã€ããŠè©±ãã #ããã°ã©ãã³ã° #æ¥åå¹çå #èªåå #ãªã¹ããªã³ã° #ããžãã¹ã¹ãã« #GAS #GoogleAppsScript #ExcelVBA #Udemyè¬åº§