ã¢ã³ã±ãŒããæ¥çšèª¿æŽãªã©ãéžæè¢ããæé©ãªé ç®ãè€æ°éžã¶ãã©ãŒã ã§åœ¹ç«ã€ã®ããGoogleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹ã§ãã
ãããããã§ãã¯ããã¯ã¹ã®äœãæ¹ãããããªãã質åã®å 容ããã§ãã¯ããã¯ã¹ã«æé©ãå€æãé£ãããªã©ã®çç±ã§äœæ¥ãæ»ã£ãŠããŸãããïŒ
ãã®èšäºã§ã¯ãGoogleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹ã®èšå®ã®ä»æ¹ãããã§ãã¯ããã¯ã¹ã®çš®é¡ãªã©ã解説ããŸããåå¿è ã®æ¹ã§ãããããããããç»åä»ãã§æé ã玹ä»ããŠããã®ã§ãèªç€Ÿã«æé©ãªãã©ãŒã äœãã«ææŠããŠãã ããã
çŽæçãªæäœã§ãã©ãŒã äœæãããããªããformrunããããããã
å°éç¥èããªãæ¹ã䜿ãããªãããã©ãŒã ãå°å
¥ãããå Žåã¯formrunã®æŽ»çšãããããã§ãã
ç¡æãã©ã³ãã掻çšã§ããããããã²1床ãè©Šããã ããã
formrunãšGoogleãã©ãŒã ã®éãã«ã€ããŠç¢ºèªãããæ¹ã¯ãã¡ããã確èªãã ããã
>> formrunãšGoogleãã©ãŒã ã®éã
ç®æ¬¡ [é衚瀺]
- Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹ã¯2çš®é¡
- Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹ã§è€æ°åçãäœãæ¹æ³
- Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹(ã°ãªãã)ã§è€æ°åçãäœãæ¹æ³
- Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹ã®åçã確èªã»éèšããæ¹æ³
- Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹(ã°ãªãã)ã®åçã確èªã»éèšããæ¹æ³
- Googleãã©ãŒã ã®åçãExcelã§ç®¡çããæ¹æ³
- ãã©ãŒã ã®ãã§ãã¯ããã¯ã¹ãç°¡åã«äœ¿ããªãformrunããããã
Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹ã¯2çš®é¡
![Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹ã¯2çš®é¡](https://form.run/media/wp-content/uploads/2024/12/23358648_m.jpg)
ãã§ãã¯ããã¯ã¹ã掻çšãããšã1ã€ã®è³ªåã«å¯Ÿããçããè€æ°éžæã§ããŸãã
Googleãã©ãŒã ã«æèŒãããŠãããã§ãã¯ããã¯ã¹ã¯ãäžèšã®2çš®é¡ã§ãã
ã»ãã§ãã¯ããã¯ã¹
ã»ãã§ãã¯ããã¯ã¹(ã°ãªãã)
æ¥çšèª¿æŽã®ããã«æ±ºå®ãŸã§è€æ°ã®ããåããçããã¡ãªã±ãŒã¹ã§ããåçè ã«å¯Ÿå¿ã§ããæéãè€æ°éžãã§ããããªã©ã®å·¥å€«ã§ãæå°éã®ã³ãã¥ãã±ãŒã·ã§ã³ã§æ¥çšèª¿æŽãå¯èœã§ãã
以äžãããããããã®ãã§ãã¯ããã¯ã¹ãã©ã®ãããªã±ãŒã¹ã«ãããããã解説ããŸãã
ãåãããŠèªã¿ããèšäºã
ïŒïŒ ãå
šè§£èª¬ãGoogleãã©ãŒã ã®åçãã¡ãŒã«éç¥ããæ¹æ³ | formLab
Googleãã©ãŒã ã®äœãæ¹ã¯ãã¡ã
ïŒïŒ ã2024幎å®å
šçãGoogleãã©ãŒã ã®äœ¿ãæ¹ã培åºè§£èª¬ïœäœãæ¹ããäœæäŸãŸã§è©³ãã玹ä»
Googleãã©ãŒã ã¢ã«ãŠã³ãããæã¡ã®æ¹ã¯ã¯ã³ã¯ãªãã¯ã§ç»é²ã§ããŸãã
ãã²formrunã§ãã©ãŒã ãäœæããŠã¿ãã ããã
>> formrunãšGoogleãã©ãŒã ã®éã
ãã§ãã¯ããã¯ã¹ïŒäžã€ã®è³ªåã«è€æ°ã®åçãã§ãã
![äžã€ã®è³ªåã«è€æ°ã®åçãã§ãã](https://form.run/media/wp-content/uploads/2024/12/image5-4.png)
ãã§ãã¯ããã¯ã¹ã¯ã1ã€ã®è³ªåã«å¯Ÿããçããè€æ°éžã¹ãåçæ¹åŒã§ãããã§ãã¯ããã¯ã¹ã圹ç«ã€è³ªåã®äŸã¯äžèšã®éãã§ãã
ã質åäŸã
ã»å¥œããªå£ç¯ã¯ïŒ
ã»å¯Ÿå¿å¯èœãªæ¥åå
容ã¯ïŒããªã©
è€æ°ã®éžæè¢ã®äžã§éžæã§ããé ç®æ°ã®äžéãèšããããããã質åã«å¯ŸããŠæ£ç¢ºãªåçãåŸãããŸãã
èšèªã®ç¿åŸã¬ãã«ã§æé©ãªãã®ãäžã€éžæããŠãã ãã(ãã€ãã£ãã¬ãã«ã»èªã¿æžãã¯ã§ãããäŒè©±ã¯å°é£ã»å šãããããªã)ãªã©ã®è³ªåã«ã圹ç«ã€åç圢åŒã§ãã
ãã§ãã¯ããã¯ã¹(ã°ãªãã)ïŒè€æ°ã®è³ªåã«è€æ°ã®åçãã§ãã
ãã§ãã¯ããã¯ã¹(ã°ãªãã)ã¯ãäžã€ã®è³ªåã«å¯ŸããŠé
ç®ããšã«å
容ãæãäžãã質åãã§ããåçæ¹æ³ã§ãããã§ãã¯ããã¯ã¹(ã°ãªãã)ã圹ç«ã€è³ªåã®äŸã¯äžèšã®éãã§ãã
ã質åäŸã
ã»å£ç¯ããšã«ãã®å£ç¯ã奜ããªçç±ã¯ïŒ
ã»ããŒãã£ã³ã°ã®æ¥çšèª¿æŽ(äŸïŒïŒ»é
ç®ïŒœããææ¥ïŒ»éžæè¢ïŒœååäžã»12æã15æã»15æã17æã»17æã19æ)
ã»æºè¶³åºŠèª¿æ»(äŸïŒïŒ»é
ç®ïŒœèª¬æã®ããããããéžæè¢ïŒœå€§å€æºè¶³ã»ããæºè¶³ã»ããäžæºã»å€§å€äžæº)
æ¥çšèª¿æŽã第1ã第3åžæãŸã§éžãã§ã»ããå 容ãªã©ã§ãæ å ±ãããããããå¯èŠåãã質åãã§ããŸãã
Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹ã§è€æ°åçãäœãæ¹æ³
Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹ã¯ã以äžã®3STEPã§èšçœ®ã§ããŸãã
STEPâ Googleãã©ãŒã ãæ°èŠäœæ
![Googleãã©ãŒã ãæ°èŠäœæ](https://form.run/media/wp-content/uploads/2024/12/image9-2.png)
Googleãã©ãŒã ã«ãã°ã€ã³âç»é¢å·Šäžã®ç©ºçœã®ãã©ãŒã ãã¯ãªãã¯ããŠæ°èŠãã©ãŒã ãäœæ
STEPâ¡åçæ¹æ³ããã§ãã¯ããã¯ã¹ã«å€æŽ
![åçæ¹æ³ããã§ãã¯ããã¯ã¹ã«å€æŽ](https://form.run/media/wp-content/uploads/2024/12/image27.png)
æ°èŠè³ªåãäœæâã©ãžãªãã¿ã³ã«ã«ãŒãœã«ãåãããŠã¯ãªãã¯
![ããã§ãã¯ããã¯ã¹ããã¯ãªãã¯](https://form.run/media/wp-content/uploads/2024/12/image12-1.png)
ããã§ãã¯ããã¯ã¹ããã¯ãªãã¯ããŠåç圢åŒãå€æŽ
STEPâ¢è³ªåæãšéžæè¢ãå ¥å
![質åæãšéžæè¢ãå
¥å](https://form.run/media/wp-content/uploads/2024/12/image28.png)
â ãç¡é¡ã®è³ªåãã«è³ªåæãå ¥å
â¡ããªãã·ã§ã³ãã«éžæè¢ãå ¥å
ãçªå€ç·šãéžæè¢ã«ç»åãè¿œå
ãã§ãã¯ããã¯ã¹ã®éžæè¢ã§ã¯ãç»åãçšãã質åäœæãã§ããŸãããã¶ã€ã³ãç©ã®é 眮ãªã©ãèŠãç®ã®å€æãããŠã»ããéã«äŸ¿å©ã§ãã
![䜿ãããç»åãã¢ããããŒã](https://form.run/media/wp-content/uploads/2024/12/image24.png)
ç»åãè¿œå ãããå Žåã¯ãéžæè¢å³åŽã®ãç»åã¢ã€ã³ã³ããã¯ãªãã¯ãã䜿ãããç»åãã¢ããããŒãããŠãã ããã
ãçªå€ç·šãåçã§éžæã§ããé ç®æ°ãå¶é
ãã§ãã¯ããã¯ã¹ã§ã¯ã質åã«å¯ŸããŠåçã§ããéžæè¢ã®å¶éãèšããããŸãã
åçã§ããéžæè¢ã®å¶éã¯ä»¥äžã®3éãã§ãã
ã»æäœããåéžæããŠãã ãã
ã»æ倧ããåãŸã§éžæã§ããŸã
ã»è³ªåãžã®åçãããåéžãã§ãã ãã
ããããã®èšå®ã®ä»æ¹ã玹ä»ããŸãã
ç»é¢å³äžã®ãïžããã¯ãªãã¯
![ãåçã®æ€èšŒããéžæ](https://form.run/media/wp-content/uploads/2024/12/image4-5.png)
â ãåçã®æ€èšŒããéžæ
â¡ãéžæããæäœåæ°ãã®å³ã«ãããâŒããã¯ãªãã¯
![質åã«å¯ŸããŠåçã§ããéžææ°ãæå®](https://form.run/media/wp-content/uploads/2024/12/image22.png)
â 質åã«å¯ŸããŠåçã§ããéžææ°ãæå®
ããããã®éžæè¢ã®æå³ã¯ä»¥äžã®éãã§ãã
ã»éžæããæäœåæ°ïŒããå以äžéžæããŠãã ãã
ã»éžæããæå€åæ°ïŒããåãŸã§éžæã§ããŸã
ã»éžæããåæ°ïŒããåéžæã§ããŸã(æå®ããæ°ä»¥å€ã®éžææ°ã¯èªããããªã)
â¡ãæ°å€ãã«é©å¿ãããæ°å€ãå ¥å
â¢åçè ãâ ã»â¡ã§èšå®ããå 容ã«åããªãåçãããéã«è¡šç€ºããããšã©ãŒã¡ãã»ãŒãžããã«ã¹ã¿ã ã®ãšã©ãŒããã¹ããã«å ¥åããŠå®äº
Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹(ã°ãªãã)ã§è€æ°åçãäœãæ¹æ³
Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹(ã°ãªãã)ã¯ã以äžã®3STEPã§èšçœ®ã§ããŸãã
STEPâ Googleãã©ãŒã ãæ°èŠäœæ
![Googleãã©ãŒã ãæ°èŠäœæ](https://form.run/media/wp-content/uploads/2024/12/image9-3.png)
Googleãã©ãŒã ã«ãã°ã€ã³âç»é¢å·Šäžã®ç©ºçœã®ãã©ãŒã ãã¯ãªãã¯ããŠãæ°èŠãã©ãŒã ãäœæ
STEPâ¡åçæ¹æ³ããã§ãã¯ããã¯ã¹ã«å€æŽ
![åçæ¹æ³ããã§ãã¯ããã¯ã¹ã«å€æŽ](https://form.run/media/wp-content/uploads/2024/12/image27.png)
æ°èŠè³ªåãäœæâã©ãžãªãã¿ã³ã«ã«ãŒãœã«ãåãããŠã¯ãªãã¯
![ããã§ãã¯ããã¯ã¹(ã°ãªãã)ããã¯ãªãã¯ããŠåç圢åŒãå€æŽ](https://form.run/media/wp-content/uploads/2024/12/image23.png)
ããã§ãã¯ããã¯ã¹(ã°ãªãã)ããã¯ãªãã¯ããŠåç圢åŒãå€æŽ
STEPâ¢è³ªåæãšéžæè¢ãå ¥å
![質åæãšéžæè¢ãå
¥å](https://form.run/media/wp-content/uploads/2024/12/image31-3.png)
â ç¡é¡ã®è³ªåã«è³ªåæãå ¥å
â¡è³ªåã«å¯Ÿããåçã®é
ç®ããè¡ãã«å
¥å
質åã®çããããã ã£ãå Žåã¯ãâ¡â¡ã§ãã(äŸïŒå¥œããªå£ç¯ãæ¥ã ã£ãå Žåã奜ããªçç±ã¯ã€ãã³ããå€ãããã§ãã)ã®ãã(äŸïŒæ¥)ã®éšå
â¢è³ªåã®é
ç®ã«å¯Ÿããéžæè¢ããåãã«å
¥å
質åã®çããããã ã£ãå Žåã¯ãâ¡â¡ã§ãã(äŸïŒå¥œããªå£ç¯ãæ¥ã ã£ãå Žåã奜ããªçç±ã¯ã€ãã³ããå€ãããã§ãã)ã®â¡â¡(äŸïŒã€ãã³ããå€ã)ã®éšå
以äžã§ãGoogleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹(ã°ãªãã)ã§è€æ°åçãäœæã§ããŸãã
ãã§ãã¯ããã¯ã¹(ã°ãªãã)ã®é ç®ãéžæè¢ã«ã¯ãç»åã®æ¿å ¥ã¯ã§ããŸãããç»åãæ¿å ¥ãããå Žåã¯ããã§ãã¯ããã¯ã¹ã掻çšããŠãã ããã
ãçªå€ç·šãéžæã§ããçããäžé ç®ã«ã€ãäžã€ã«èšå®
質åã®åé ç®ã«å¯ŸããŠéžã¹ãéžæè¢ã1ã€ã®ã¿ã«ãããå Žåã¯ã以äžã®æé ã§èšå®ãå®æœããŸãã
![ç»é¢å³äžã®ãïžããã¯ãªãã¯](https://form.run/media/wp-content/uploads/2024/12/image10-2.png)
ç»é¢å³äžã®ãïžããã¯ãªãã¯
![ã1åã«ã€ã1ã€ã®åçã«å¶éããéžæããŠå®äº](https://form.run/media/wp-content/uploads/2024/12/image6-3.png)
ã1åã«ã€ã1ã€ã®åçã«å¶éããéžæããŠå®äº
![1åã§è€æ°ã®åçãéžæããããšã¯ã§ããŸããã®åºçŸ](https://form.run/media/wp-content/uploads/2024/12/image2-3.png)
1ã€ã®é ç®ã«å¯ŸããŠ1ã€ä»¥äžã®åçãéžæãããšã解çæ¬ã®äžã«èµ€åã®ã¢ããŠã³ã¹(ïŒ1åã§è€æ°ã®åçãéžæããããšã¯ã§ããŸãã)ãåºçŸããŸãã
ãçªå€ç·šã質åãžã®åçãå¿ é ã«ãã
åé ç®ãžã®åçãå¿ é ã«ãããå Žåã¯ã以äžã®æé ã§èšå®ãå®æœããŸãã
![ç»é¢å³äžãåè¡ã§1ã€ã®åçãå¿
é ã«ãããã®å³ã«ããããŒãONã«å€æŽ](https://form.run/media/wp-content/uploads/2024/12/image25.png)
ç»é¢å³äžãåè¡ã§1ã€ã®åçãå¿ é ã«ãããã®å³ã«ããããŒãONã«å€æŽ
![ïŒãã®è³ªåã§ã¯åçã1è¡ã«1ã€ä»¥äžå
¥ããŠãã ããã®åºçŸ](https://form.run/media/wp-content/uploads/2024/12/image15-1.png)
ããŒãONã«åãããšåçæŒãããã£ãéã解çæ¬ã®äžã«èµ€åã®ã¢ããŠã³ã¹(ïŒãã®è³ªåã§ã¯åçã1è¡ã«1ã€ä»¥äžå ¥åããŠãã ãã)ãåºçŸããŸãã
Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹ã®åçã確èªã»éèšããæ¹æ³
åéããåççµæã¯ãGoogleãã©ãŒã äžã§ç¢ºèªã»éèšãå¯èœã§ãããã ãã詳现ãªããŒã¿ã®ç®¡çãåæã¯ã§ããŸããã
詳ããããŒã¿ç®¡çã瀟å ã§ã®å ±æãèããŠããå Žåã¯ãGoogleãã©ãŒã ãšã¹ãã¬ããã·ãŒãã®é£æºãããããããŸããæé ã¯ä»¥äžã®éãã§ãã
STEPâ Googleãã©ãŒã ãšã¹ãã¬ããã·ãŒããé£æº
![Googleãã©ãŒã ãšã¹ãã¬ããã·ãŒããé£æº](https://form.run/media/wp-content/uploads/2024/12/image17-1.png)
â ç»é¢äžã®äžå¿éšã«ãããåçããéã
â¡ç»é¢äžéšã®å³åŽã«ãããã¹ãã¬ããã·ãŒãã§è¡šç€ºããã¯ãªãã¯
![ç»é¢äžéšã®å³åŽã«ãããã¹ãã¬ããã·ãŒãã§è¡šç€ºããã¯ãªãã¯](https://form.run/media/wp-content/uploads/2024/12/image7-3.png)
â ãæ°ããã¹ãã¬ããã·ãŒããäœæãããæ¢åã®ã¹ãã¬ããã·ãŒããéžæãã®ã©ã¡ãããéžæ
â¡ãäœæããã¯ãªãã¯
â ã§æ°ããã¹ãã¬ããã·ãŒããäœæããå Žåããç¡é¡ã®ãã©ãŒã (åç)ãã®éšåãã¯ãªãã¯ããŠãã¡ã€ã«åãå ¥åã§ããŸãããäœæããã¿ã³ãæŒããšãæ°èŠã¹ãã¬ããã·ãŒããèªåã§è¡šç€ºãããŸãã
æ¢åã®ã¹ãã¬ããã·ãŒããéžæããå Žåã¯ãGoogleãã©ã€ãã«ä¿åãããŠãããã¡ã€ã«ãããåçã®éèšã§äœ¿ãããã·ãŒããéžæããŠãã ãããéžãã ã¹ãã¬ããã·ãŒããšGoogleãã©ãŒã ãèªåã§é£æºãããŸãã
STEPâ¡åçéèšã§ããŠããã確èª
é£æºããã¹ãã¬ããã·ãŒãäžã§éèšããããŒã¿(ãã©ãŒã ã®åç1ã®ã·ãŒã)ãæ£ãã衚瀺ãããŠããã確èªã§ããããã©ãŒã ã®åçã®éèšãå§ããŸãã
STEPâ¢Googleãã©ãŒã ã®åçãéèš
STEP3ã§ã¯ã質å(奜ããªå£ç¯ã¯ïŒ)ã«å¯ŸããŠã®éžæè¢(æ¥ã»å€ã»ç§ã»å¬)ã§äœæããè¡š(äžèšç»åã®å¢æ å ã®è¡š)ãåèã«ãæé ã玹ä»ããŸãã
ç»é¢äžã®å·Šç«¯ã«ãããïŒãã®ã¿ããã¯ãªãã¯
æ°ãã«äœæããã·ãŒã(ã·ãŒã1)ã¯ãåçãéèšããããã«æŽ»çšããŸãã
![æ°ãã«äœæããã·ãŒã(ã·ãŒã1)ã«ãããŒã¿éèšã«å¿
èŠãªè¡šãäœæ](https://form.run/media/wp-content/uploads/2024/12/image30.png)
æ°ãã«äœæããã·ãŒã(ã·ãŒã1)ã«ãããŒã¿éèšã«å¿ èŠãªè¡šãäœæ
é ç®ã®æ¬(ç°è²ã®ã»ã«ã®éšå)ã¯ãGoogleãã©ãŒã ãšåãè¡šèšã§èšå®ããŸããè¡šèšãç°ãªããšã次ã®æé ã§ããŒã¿æŽçãããéã«ãšã©ãŒãèµ·ããããã§ãã
![](https://form.run/media/wp-content/uploads/2024/12/image26.png)
ããŒã¿æŽçãå®æœããã»ã«ãéžæããŠé¢æ°ãå ¥å
ããã§ã¯ã奜ããªå£ç¯ã¯ãæ¥ããšåçãããæ°ãå¯èŠåããŸãã
ããŒã¿ã衚瀺ãããã»ã«(B3)ã«ã =COUNTIF( ããšå ¥åâç»é¢äžã®ããã©ãŒã ã®åç1ãã¿ããã¯ãªãã¯
![ã =COUNTIF( ããšå
¥åâç»é¢äžã®ããã©ãŒã ã®åç1ãã¿ããã¯ãªãã¯](https://form.run/media/wp-content/uploads/2024/12/image1-4.png)
ãã©ãŒã ã®åç1ããåç §ãããç®æããã©ãã¯&ããããã§éžæâç¯å²ãæãåºããããïŒ(åè§ã®ã«ã³ã)ããå ¥åâç»é¢äžã®ã¿ããããã·ãŒã1ãã«ç§»åâããŒã¿æŽçãããã»ã«(B2)ãã¯ãªãã¯
ä»ã»ã«ã«è¡šç€ºãããŠããåŒãšãããããã®æå³ã¯äžèšã®éãã§ãã
衚瀺ãããŠããåŒïŒœâ =COUNTIF(âãã©ãŒã ã®åç1â!F2ïŒF5ïŒB2ïŒ
ããããã®æå³ïŒœ
=COUNTIF â æå®ãããæ¡ä»¶ãšäžèŽããããŒã¿ãæœåºããé¢æ°ã§ã
âãã©ãŒã ã®åç1â!F2ïŒF5 âãã©ãŒã ã®åç1ã®ã·ãŒãå
ã®F2ããF5ã®ç¯å²ãã
B2 â B2ã«èšèŒããŠããæ¡ä»¶ãæãåºã
äžèšã®åŒã«å ããŠãæ¡ä»¶ãæãåºãè¡ãåã®ç¯å²ã®åºå®ãããããšãã¯ã $ ãã䜿ããŸãã
=COUNTIF(âãã©ãŒã ã®åç1â!F2ïŒF5ïŒB2ïŒã®ãF2ïŒF5ãã«ã $ ããä»ãå ããŸãããã
ç»åã®èµ€æ å ã®åŒã =COUNTIF(âãã©ãŒã ã®åç1â!$F$2ïŒ$F$5ïŒB2ïŒããå®æ圢ã§ãã
Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹(ã°ãªãã)ã®åçã確èªã»éèšããæ¹æ³
Googleãã©ãŒã ãã¹ãã¬ããã·ãŒããšé£æºãããŠããã§ãã¯ããã¯ã¹(ã°ãªãã)ã®åçã管çããã«ã¯ã以äžã®æé ãèžã¿ãŸãããã
STEPâ Googleãã©ãŒã ãšã¹ãã¬ããã·ãŒããé£æº
![Googleãã©ãŒã ãšã¹ãã¬ããã·ãŒããé£æº](https://form.run/media/wp-content/uploads/2024/12/image13-1.jpg)
â ç»é¢äžéšã®äžå¿éšã«ãããåçããéã
â¡ç»é¢äžéšã®å³åŽã«ãããã¹ãã¬ããã·ãŒãã§è¡šç€ºããã¯ãªãã¯
![ãæ°ããã¹ãã¬ããã·ãŒããäœæãããæ¢åã®ã¹ãã¬ããã·ãŒããéžæãã®ã©ã¡ãããéžæ](https://form.run/media/wp-content/uploads/2024/12/image7-5.png)
â ãæ°ããã¹ãã¬ããã·ãŒããäœæãããæ¢åã®ã¹ãã¬ããã·ãŒããéžæãã®ã©ã¡ãããéžæ
â¡ãäœæããã¯ãªãã¯
â ã§æ°ããã¹ãã¬ããã·ãŒããäœæãããšãããç¡é¡ã®ãã©ãŒã (åç)ãã®éšåãã¯ãªãã¯ããã°ãã¡ã€ã«åãå€æŽã§ããŸãã
ãäœæããã¿ã³ãæŒããšãæ°èŠã¹ãã¬ããã·ãŒããèªåã§éãä»çµã¿ã§ãã
æ¢åã®ã¹ãã¬ããã·ãŒããéžæãããšãã¯ãGoogleãã©ã€ãå ã®ãã¡ã€ã«ãããåçã®éèšã§äœ¿ãããã·ãŒããéžæããŠãã ãããéžãã ã¹ãã¬ããã·ãŒããšGoogleãã©ãŒã ãèªåã§é£æºãããŸãã
STEPâ¡Googleãã©ãŒã ã§åçéèšã§ããŠããã確èª
![ç»é¢äžã®å·Šç«¯ã«ãããïŒãã®ã¿ããã¯ãªãã¯](https://form.run/media/wp-content/uploads/2024/12/image8-3.png)
ç»é¢äžã®å·Šç«¯ã«ãããïŒãã®ã¿ããã¯ãªãã¯
æ°ãã«äœæããã·ãŒã(ã·ãŒã1)ã¯ãåçã®éèšã«æŽ»çšããŸãã
STEPâ¢ãã§ãã¯ããã¯ã¹(ã°ãªãã)ãéèš
![æ°ãã«äœæããã·ãŒã(ã·ãŒã1)ã«è¡šãäœæ](https://form.run/media/wp-content/uploads/2024/12/image20.png)
æ°ãã«äœæããã·ãŒã(ã·ãŒã1)ã«è¡šãäœæ
é ç®ã®å ¥åæ¬(ç°è²ã®ã»ã«ã®éšå)ã¯ãGoogleãã©ãŒã ãšåãè¡šèšã§æžã瀺ããŸããè¡šèšãç°ãªããšãããŒã¿æŽçã§ãšã©ãŒãçºçãããã泚æããŠãã ããã
![ã =COUNTIF( ããå
¥åâç»é¢äžã®ããã©ãŒã ã®åç1ãã¿ããã¯ãªãã¯](https://form.run/media/wp-content/uploads/2024/12/image11-2.png)
ããŒã¿ã衚瀺ãããã»ã«(C7)ã«ã =COUNTIF( ããå ¥åâç»é¢äžã®ããã©ãŒã ã®åç1ãã¿ããã¯ãªãã¯
ãã©ãŒã ã®åç1ããåç §ãããç®æããã©ãã¯&ããããã§éžæâç¯å²ãæãåºããããïŒ(åè§ã®ã«ã³ã)ããå ¥åâç»é¢äžã®ã¿ããããã·ãŒã1ãã«ç§»åâããŒã¿æŽçãããã»ã«(C6)ãã¯ãªãã¯
ã»ã«ã«è¡šç€ºãããŠããåŒãšæå³ã¯ãäžèšã®éãã§ãã
衚瀺ãããŠããåŒïŒœâ =COUNTIF(âãã©ãŒã ã®åç1â!C2ïŒC5ïŒC6ïŒ
ããããã®æå³ïŒœ
=COUNTIF â æå®ãããæ¡ä»¶ãšäžèŽããããŒã¿ãæœåºããé¢æ°ã§ã
âãã©ãŒã ã®åç1â!C2ïŒC5 âãã©ãŒã ã®åç1ã®ã·ãŒãå
ã®C2ããC5ã®ç¯å²ãã
C6 â C6ã«èšèŒããŠããæ¡ä»¶ãæãåºã
![äžèšã®åŒã«å ããŠãæ¡ä»¶ãæãåºãè¡ãåã®ç¯å²ã®åºå®ãããããšãã¯ãã«ããŒã¯ã $ ãã䜿ã](https://form.run/media/wp-content/uploads/2024/12/image19-2.png)
äžèšã®åŒã«å ããŠãæ¡ä»¶ãæãåºãè¡ãåã®ç¯å²ã®åºå®ãããããšãã¯ãã«ããŒã¯ã $ ãã䜿ããŸãã
=COUNTIF(âãã©ãŒã ã®åç1â!C2ïŒC5ïŒC6ïŒã®ãC2ïŒC5ãã«ã $ ããä»ãå ããŸãããã
ç»åã®èµ€æ å ã®åŒã =COUNTIF(âãã©ãŒã ã®åç1â!$C$2ïŒ$C$5ïŒC6ïŒããå®æ圢ã§ãã
ãçªå€ç·šã質åã«å¯ŸããŠè€æ°ã®é ç®ãéžæã§ããåçãéèš
äžã€ã®åãããã«å¯ŸããŠè€æ°ã®é ç®ãéžæã§ãã質å(äŸïŒè¶£å³ã¯ãããŸããïŒæäœ2ã€ä»¥äžéžãã§ãã ãã )ãéèšããéã¯ãè€æ°ã®è¡šèšãé£ãªã£ãŠããŠãæ å ±ãæ£ããæãåºããæ¡ä»¶ä»ããå¿ èŠã§ãã
![質åã«å¯ŸããŠè€æ°ã®é
ç®ãéžæã§ããåçãéèš](https://form.run/media/wp-content/uploads/2024/12/image21.png)
äŸãã°ããèªæžãé³æ¥œéè³ãæ è¡ããªã©èªæžä»¥å€ã®éžæè¢ãæ瀺ãããŠããåçã®äžããããèªæžãã®æ å ±ã®ã¿ãæœåºã§ããããã«ããŸãã
â(ããã«ã¯ã©ãŒããŒã·ã§ã³ããŒã¯)ãšã *(ã¢ã¹ã¿ãªã¹ã¯)ãçµã¿åããããâ*âãã䜿ããäžèšã®åŒãäœããŸãããã
ã =COUNTIF(FromResponse1趣å³ã¯ãããŸããïŒ(æäœ2ã€ä»¥äžéžãã§ãã ãã )ïŒâ*â&B2&â*âïŒã
ãâ*âãã¯ãæå®ããã»ã«(B2ã®èªæž)ãå«ãæ å ±ãæœåºããæå³ããã€èšå·ã§ãã
ã&ãã¯ãæå®ããã»ã«ãšä»ã®æ å ±ãçµã³ã€ããŠããããšã瀺ãèšå·ã§ãã
ã â*â&B2&â*â ãã®éšåã¯ãèªæžãé³æ¥œéè³ãæ è¡ããªã©ãB2ã®ã»ã«(èªæž)ãå«ãå Žåã§ããèªæžãã ããæœåºããæå³ããã¡ãŸãã
Googleãã©ãŒã ã®åçãExcelã§ç®¡çããæ¹æ³
Googleãã©ãŒã ã®åçãExcelã§ç®¡çãããå Žåã¯ã1床ã¹ãã¬ããã·ãŒããäœæããåŸã«ãã¡ã€ã«ã®å€æãå®è¡ããŸãã
![é£æºããã¹ãã¬ããã·ãŒãã®ããã¡ã€ã«ãâãããŠã³ããŒããâãMicrosoft Excel(.xlsx)ããã¯ãªãã¯](https://form.run/media/wp-content/uploads/2024/12/image16-2.png)
é£æºããã¹ãã¬ããã·ãŒãã®ããã¡ã€ã«ãâãããŠã³ããŒããâãMicrosoft Excel(.xlsx)ããã¯ãªãã¯
![ç·šéãæå¹ã«ãããã¯ãªãã¯](https://form.run/media/wp-content/uploads/2024/12/image18-1.png)
éããExcelã®äžéšãç·šéãæå¹ã«ããããã¯ãªãã¯ãããšããŒã¿éèšã»ç®¡çãå¯èœ
PDFãWebããŒãžçšãªã©Excel以å€ãžã®å€æãã§ãããããå¿ èŠã«å¿ããŠåç管çãå®æœããŠãã ããã
ãã©ãŒã ã®ãã§ãã¯ããã¯ã¹ãç°¡åã«äœ¿ããªãformrunããããã
å
¬åŒãµã€ãïŒformrun(ãã©ãŒã ã©ã³)
Googleãã©ãŒã ã®ãã§ãã¯ããã¯ã¹ã»ãã§ãã¯ããã¯ã¹(ã°ãªãã)ã䜿ãããªããšãåãããã«å¯ŸããŠé«ç²ŸåºŠãªåçãåéã§ããŸããGoogleã¢ã«ãŠã³ããææããŠããã°èª°ã§ããã©ãŒã äœæã«ææŠã§ããç¹ã倧ããªé åã§ãã
ãã ãããã¶ã€ã³ãæ©èœã¯å¿ èŠæäœéã«ãšã©ãŸã£ãŠããããèªç€Ÿã®ã«ã©ãŒã«åãããèŠãç®ã«ããããå人æ å ±ãªã©ã®æ©å¯æ§ã®é«ãæ å ±ãå«ãã åçãæ±ãããã©ãŒã ã«ã¯äžåãã§ãã
åŒç€Ÿã®ãã©ãŒã äœæããŒã«ãformrun(ãã©ãŒã ã©ã³) ãã¯ãçŽæçãªæäœæ§ã§è±å¯ãªãã¶ã€ã³ã®ãã³ãã¬ãŒãã掻çšã§ããããŒã«ã§ãã
ãŸããã»ãã¥ãªãã£ãé«ãã®ãformrunã®é åã§ãããISO 27001 (ISMS)ãã®èªèšŒååŸãSSL/ TLSã«ããæå·åéä¿¡ãªã©æ§ã ãªå¯ŸçãæŽããŠããŸãã
ãã®ãããformrunã掻çšããŠããæ¹ã®7å²ã¯ãããžãã¹ç®çã§Googleãã©ãŒã ã掻çšããŠããŸãããåœããŒã«ã«ç§»è¡ãããŠããŸãã
Googleã¢ã«ãŠã³ããç»é²ããã ãã§å©çšãå§ãããããããããŒã«ã移è¡ããæéãããããŸããã
ç¡æãã©ã³ããææãã©ã³ã®ç¡æãã©ã€ã¢ã«(14æ¥é)ããçšæããŠããã®ã§ããã²äžåºŠãè©Šããã ããã
>>ç¡æã§è©Šãããã©ãŒã äœæããŒã«ãªãformrun(ãã©ãŒã ã©ã³)
formrunãšGoogleãã©ãŒã ã®éãã«ã€ããŠç¢ºèªãããæ¹ã¯ãã¡ããã確èªãã ããã
>> formrunãšGoogleãã©ãŒã ã®éã
formrunããã©ãŒã äœæã顧客管çã«é¢ããæ å ±ãçºä¿¡ããŠãããŸãã
EFOïŒãšã³ããªãŒãã©ãŒã æé©åïŒãåãåãã察å¿ãªã©ã
ãã©ãŒã ã«é¢ãããæ©ã¿ã解決ããŸãã