åå¿è
ã®ããžãã¹ãã³ã«ããããééãã¯ãããŒã¿ã®åéãšåæãäœæ¥ããã»ã¹ã®æé©åãäž»èŠææšã®ç£èŠã«ååãªæ³šæãæããªãããšã§ãããã®çµæãçç£æ§ãäœäžããæéãšãªãœãŒã¹ãæé©ãšã¯èšããŸãããããã»ã¹ãæªãå Žåãåããšã©ãŒãäœåºŠãä¿®æ£ããå¿
èŠããããŸãã顧客æ°ãå¢ãããšãµãŒãã¹ãäœäžããããŒã¿åæããªããã°äœãæ¹åãã¹ãããæ確ã«ããããŸããããã®çµæãææ決å®ã¯æ°ãŸããã«è¡ãããŸãã
çŸä»£ã®ããžãã¹ã競äºåãç¶æããã«ã¯ãé«å質ã®è£œåãšãµãŒãã¹ã«å ããŠãéææ§ã®ããããã»ã¹ãåããåæããŒã¿ãåéããå¿
èŠããããŸããããããªããã°ãããžãã¹ã®å®éã®ç¶æ³ãç解ããæ£ããææ決å®ãããããšã¯å°é£ã§ãããããã£ãŠã䜿ããããã ãã§ãªããäœæ¥ãç°¡çŽ åããå¯èœãªéãéææ§ã®é«ãããã»ã¹ãäœæã§ããå¿
èŠãªããŒã«ãåããŠããããšãéèŠã§ãã
çŸåšãèšå€§ãªæ°ã®ããŒã«ããœãªã¥ãŒã·ã§ã³ããããŸããããããã»ãšãã©ã®èµ·æ¥å®¶ã¯ããããã«äŸ¡å€ãèŠåºãããªããã䜿çšæ¹æ³ãç解ã§ããªãããé«äŸ¡ã§ãããè€éã§ãããããŸã㯠100500 ãã«ä»¥äžãããããããããã䜿çšããŸããããããããããç解ãããã®ãããªããŒã«ãèªåã§èŠã€ããäœæãã人ã¯ãäžæçã«ã¯ãã§ã«åªäœæ§ãæã£ãŠããŸãã
10 幎以äžã«ããããç§ã¯ããã»ã¹ã®èªååãšããžã¿ã«å€é©ãéããŠäŒæ¥ã®å©çå¢å ãæ¯æŽãã IT 補åãšãœãªã¥ãŒã·ã§ã³ãäœæããŠããŸãããç§ã¯æ°åã®ã¹ã¿ãŒãã¢ããäŒæ¥ã®èšç«ãæ¯æŽããäžçäžã®äœåäžäººãã®äººã ã䜿çšããæ°åã®ãªã³ã©ã€ã³ ããŒã«ãäœæããŠããŸããã
ããã¯ãããžã¿ã«å€é©ã®ã¡ãªããã瀺ããç§ã®å®è·µã«ãããè¯ãäŸã® 1 ã€ã§ããã¢ã¡ãªã«ã®å°ããªæ³åŸäºåæã®ããã«ãç§ã®ããŒã ãšç§ã¯æ³çææžãäœæããããŒã«ãäœæããŸãããããã«ãããåŒè·å£«ã¯ææžãããè¿ éã«äœæã§ããããã«ãªããŸããããã®åŸããã®ããŒã«ã®æ©èœãæ¡åŒµãããªã³ã©ã€ã³ ãµãŒãã¹ãäœæããäŒç€Ÿãå®å šã«å€é©ããŸãããçŸåšã圌ãã¯èªåãã¡ã®éœåžã ãã§ãªããå šåœã®é¡§å®¢ã«ãµãŒãã¹ãæäŸããŠããŸãã 3 幎éã§ãäŒç€Ÿã®è³æ¬éã¯æ°åã«å¢å ããŸããã
ãã®èšäºã§ã¯ãäž»èŠãªããžãã¹ææšãç£èŠããããã®éæãªã·ã¹ãã ãæ§ç¯ããå®éã®çµéšãå ±æããŸããç§ã¯ããžã¿ã« ãœãªã¥ãŒã·ã§ã³ã䜿çšãã䟡å€ã浞éããããããé£ããããšã§ã¯ãªããå¿ ãããè²»çšããããããã§ã¯ãªãããšã瀺ããŸãããããè¡ããïŒ
ãããã©ãããŠå§ãŸã£ãã®ã
æã£ãããšã®ãªããã®ãæã«å ¥ããããªãããã£ãããšã®ãªãããšãããªããã°ãªããŸããã
ã³ã³ã·ã£ãã«
劻ã¯ç£äŒã«ããããããŠããã®ã§ãåäŸçšãã¬ã€ã«ãŒã ãšããå°ããªããžãã¹ãå§ããããšã«ããŸãããç§ã¯èªåã®ããžãã¹ãæã£ãŠããã®ã§ã劻ãã²ãŒã ã«ãŒã ãå®å šã«ç®¡çããç§ã¯æŠç¥çãªåé¡ãéçºãæäŒããŸãã
éæ¥ã®è©³çŽ°ã¯å šãå¥ã®è©±ã§ãããããŒã¿åéã競ååæã®æ®µéã§ã¯ããã®äºæ¥ç¹æã®åé¡ç¹ãæµ®ã圫ãã«ããã ãã§ãªãã競åä»ç€ŸãããŸãèŠåŽããŠããªã瀟å ããã»ã¹ã®åé¡ç¹ã«ã泚ç®ããŸããã ã
é©ããããšã«ã21 äžçŽã«ã¯ CRM ãäœããã®åœ¢ã§ç®¡çããŠãã人ã¯ã»ãšãã©ããããå€ãã®äººãææžãããŒãã«èšé²ãæ®ããŠããŸãããåæã«ãªãŒããŒèªèº«ããåŸæ¥å¡ãçªçãããããèšç®ãã¹ãããããåèšç®ãäŒèšåž³ç°¿ã®èšå ¥å 容ãšã®ç¢ºèªã«å€ãã®æéãè²»ãããªããã°ãªããªããäºçŽãå ¥éã«é¢ããããŒã¿ã倱ãããã顧客ãäžæãªçç±ã§éè·ãããªã©ã®äžæºã蚎ããã圌ãã
åéããããŒã¿ãåæãããšãããç§ãã¡ã¯åœŒãã®ééããç¹°ãè¿ããããªãããããã®ãªã¹ã¯ãæå°éã«æããéææ§ã®é«ãã·ã¹ãã ãå¿ èŠã§ããããšãããããŸããããŸããæ¢è£œã®ãœãªã¥ãŒã·ã§ã³ãæ¢ãå§ããŸããããèŠä»¶ãå®å šã«æºãããã®ã¯èŠã€ãããŸããã§ããããããŠãçæ³çã§ã¯ãªããã®ã®ãå®çšçã§å®äŸ¡ (ã»ãŒç¡æ) ã®ç¬èªã®ã·ã¹ãã ãäœæããããšã«ããŸããã
ããŒã«ãéžæãããšãã¯ã次ã®åºæºãèæ ®ããŸãããããã¯ãå®äŸ¡ã§ããããšãæè»æ§ãããã¢ã¯ã»ã¹ããããããšããããŠäœ¿ããããããšã§ãããã®ããžãã¹åãã«ãæ¬æ Œçã§åŒ·åã§é«äŸ¡ãªã·ã¹ãã ãäœæããããšãã§ããŸããããæéãäºç®ãéãããŠãããããã«ãããžã§ã¯ããæ©èœãããã©ãããå®å šã«ç解ããŠããªãã£ãã®ã§ãå€ãã®ãªãœãŒã¹ãè²»ããã®ã¯äžåçã§ããããã®ã·ã¹ãã ããã®ããã仮説æ€èšŒã®æç¹ã§ã¯MVPïŒMinimum Viable Product - å®è¡å¯èœãªæå°éã®è£œåïŒããå§ããŠãæå°éã®æè³ã§æçæéã§å®çšçãªããŒãžã§ã³ãäœæããæéããããŠå®æãŸãã¯äœãçŽãããšã«ããŸããã
çµæãšããŠãç§ã®éžæ㯠Google ãµãŒãã¹ (ãã©ã€ããã¹ãã¬ããã·ãŒããã«ã¬ã³ããŒ) ã«ãªããŸãããå ¥åºåæ å ±ã®äž»ãªãœãŒã¹ã¯ Google ã¹ãã¬ããã·ãŒãã§ãã劻ã¯ã¹ãã¬ããã·ãŒãã䜿çšããçµéšããããããå¿ èŠã«å¿ããŠèªåã§å€æŽãå ããããšãã§ããŸãããŸãããã®ããŒã«ã¯ã³ã³ãã¥ãŒã¿ãŒã®äœ¿ãæ¹ãããŸãåŸæã§ã¯ãªãåŸæ¥å¡ã«ã䜿çšããããããããŒãã«ã«ããŒã¿ãå ¥åããæ¹æ³ãæããæ¹ããå°éçãªããŒã«ã䜿çšããŠäœæ¥ããæ¹æ³ãæãããããã¯ããã«ç°¡åã§ãããšããäºå®ãèæ ®ããŸããã 1Cã®ãããªããã°ã©ã ã
ããŒãã«ã«å ¥åãããããŒã¿ã¯ãªã¢ã«ã¿ã€ã ã§å€åããŸããã€ãŸããäŒç€Ÿã®ç¶æ³ããã€ã§ã確èªã§ããã»ãã¥ãªãã£ãçµã¿èŸŒãŸããŠãããç¹å®ã®äººãžã®ã¢ã¯ã»ã¹ãå¶éããããšãã§ããŸãã
ã¢ãŒããã¯ãã£ãšããŒã¿æ§é ã®éçº
åäŸçšãã¬ã€ã«ãŒã ã§ã¯ãããã€ãã®åºæ¬çãªãµãŒãã¹ãæäŸããŠããŸãã
- æšæºèšªå âã¯ã©ã€ã¢ã³ããåäŸã®éã³å Žã§éããæéãè²·ã£ããšãã
- ç£ç£ä»ã蚪å - 顧客ãåäŸã®ãã¬ã€ã«ãŒã ã§éããæéãè²·ããç£ç£ã«è¿œå æéãæã£ãå Žåãã€ãŸããã¯ã©ã€ã¢ã³ãã¯åäŸãé ããŠèªåã®ä»äºãããããšãã§ããã«ãŒã ã¯ãŒã«ãŒã¯èŠªã®äžåšäžã«åäŸãèŠå®ããäžç·ã«éã¶ããšãã§ããŸãã
- ãªãŒãã³ããŒã¹ã㌠â ã¯ã©ã€ã¢ã³ãã¯é£äºãšçåžçšã«å¥ã®ããŒãã«ãåããã²ãŒã ã«ãŒã ãžã®éåžžã®èšªåæéãæ¯æããŸãããéšå±ã¯éåžžéãå¶æ¥ããŠããŸãã
- äŒæ¥æ¥ã®èªçæ¥ â 顧客ã¯æ·å°å šäœãè³è²žããã¬ã³ã¿ã«æéäžã¯ãã®éšå±ã¯ä»ã®é¡§å®¢ãåãå ¥ããŸããã
ææè ã«ãšã£ãŠãéšå±ã蚪ãã人æ°ã幎霢ãè²»ãããæéã皌ãã ãéãåºè²»ãã©ãã ããã£ãããææ¡ããããšãéèŠã§ã (管çè ãäœããè³Œå ¥ããããæ¯æããããå¿ èŠãããããšããããããŸã)é éãæ°Žãªã©ã®äœãã®å ŽåïŒãèªçæ¥ã¯äœäººãããŸããã?
ä»ã® IT ãããžã§ã¯ããšåæ§ã«ãç§ã¯å°æ¥ã®ã·ã¹ãã ã®ã¢ãŒããã¯ãã£ã培åºçã«èããããŒã¿æ§é ãæ€èšããããšããå§ããŸããã劻ã¯ããžãã¹ã®è²¬ä»»è ã§ãããããèŠãã¹ãããšã管çãã¹ãããšãæ¯é ãã¹ãããšããã¹ãŠç¥ã£ãŠããããã顧客ã®åœ¹å²ãæãããŸãããç§ãã¡ã¯äžç·ã«ãã¬ã€ã³ã¹ããŒãã³ã°ãå®æœããã·ã¹ãã ã®èŠä»¶ãäœæããŸãããããã«åºã¥ããŠã·ã¹ãã ã®æ©èœãæ€èšããGoogle ãã©ã€ãã«æ¬¡ã®ãããªãã¡ã€ã«ãšãã©ã«ããŒã®æ§é ãäœæããŸããã
ãæŠèŠãææžã«ã¯ãåå
¥ãæ¯åºãåæãªã©ãäŒç€Ÿã«é¢ããäžè¬çãªæ
å ±ãå«ãŸããŠããŸãã
çµè²»ææžã«ã¯ãäŒç€Ÿã®æ¯æã®çµè²»ã«é¢ããæ
å ±ãå«ãŸããŠããŸããéææ§ãé«ãããããäºåè²»ãçšéã人件費ãåºåè²»ããã®ä»ã®çµè²»ã«åããŠè¡šç€ºããŠããŸãã
æ¯æã®è²»çš
幎éæ¯åºã®æŠèŠè¡š
Income ãã©ã«ããŒã«ã¯ãæããšã« 12 ã€ãã€ãåèš XNUMX åã® Google ã¹ãã¬ããã·ãŒã ãã¡ã€ã«ãå«ãŸããŠããŸãããããã¯åŸæ¥å¡ãæ¯æ¥èšå ¥ããäž»ãªäœæ¥ææžã§ãããããã«ã¯ãå¿ é ã®ããã·ã¥ããŒã ã¿ããšå¶æ¥æ¥ããšã®ã¿ããå«ãŸããŠããŸããããã·ã¥ããŒã ã¿ãã«ã¯ãä»æã®ç¶æ³ããã°ããç解ããããã«å¿ èŠãªæ å ±ããã¹ãŠè¡šç€ºãããäŸ¡æ Œã®èšå®ããµãŒãã¹ã®è¿œå ãå¯èœã§ãã
ããã·ã¥ããŒãã¿ã
ãã€ãªãŒã¿ã
ããžãã¹ã®çºå±ã®éçšã§ãå²åŒããµãã¹ã¯ãªãã·ã§ã³ãè¿œå ãµãŒãã¹ãã€ãã³ããªã©ã®åœ¢ã§è¿œå ã®ããŒãºãçŸââãå§ããŸãããããããã¹ãŠãæéããããŠå®è£ ããŠããŸãããããã®äŸã¯ã·ã¹ãã ã®åºæ¬ããŒãžã§ã³ã瀺ããŠããŸãã
æ©èœã®åµé
äž»ãªææšãç解ããã¢ãŒããã¯ãã£ãšãšã³ãã£ãã£éã®ããŒã¿äº€æãæ€èšããåŸãå®è£ ãéå§ããŸãããæåã«è¡ã£ãã®ã¯ãIncome ãã©ã«ããŒã« Google Sheet ããã¥ã¡ã³ããäœæããããšã§ããããã®äžã«ããã·ã¥ããŒããšæã®æåã®æ¥ãšãã 2 ã€ã®ã¿ããäœæããããã«æ¬¡ã®è¡šãè¿œå ããŸããã
ã¡ã€ã³ã¯ãŒã¯ã·ãŒã
ããã¯ã管çè ãäœæ¥ããã¡ã€ã³ã®ã¯ãŒã¯ã·ãŒãã§ããå¿ èŠãªãã£ãŒã«ã (èµ€ã§ããŒã¯) ãå ¥åããã ãã§ãã·ã¹ãã ãå¿ èŠãªææšããã¹ãŠèªåçã«èšç®ããŸãã
å ¥åãšã©ãŒãæžããå©äŸ¿æ§ãé«ããããã«ãã蚪åã¿ã€ãããã£ãŒã«ãã¯æäŸããããµãŒãã¹ã®ããããããŠã³ ãªã¹ããšããŠå®è£ ãããŠãããããã·ã¥ããŒã ããŒãžã§ç·šéã§ããŸãããããè¡ãã«ã¯ããããã®ã»ã«ã«ããŒã¿æ€èšŒãè¿œå ããããŒã¿ãååŸããç¯å²ã瀺ããŸãã
人çèšç®ãã¹ãæžããããã«ãã¯ã©ã€ã¢ã³ããéšå±ã§éãããæéãšæ¯æãããéé¡ã®èªåèšç®ãè¿œå ããŸããã
ãããè¡ãã«ã¯ã管çè ã¯ã¯ã©ã€ã¢ã³ãã®å°çæå» (å E) ãšåºçºæå» (å F) ã HH:MM ã®åœ¢åŒã§ããŒã¯ããã ãã§ããã¯ã©ã€ã¢ã³ããã²ãŒã ã«ãŒã ã§è²»ããåèšæéãèšç®ããã«ã¯ã次ã®åŒã䜿çšããŸãã
=IF(ISBLANK($F8); ""; $F8-$E8)
ãµãŒãã¹ã®çš®é¡ã«ãã£ãŠ 1 æéåœããã®æéãç°ãªãããããµãŒãã¹å©çšã®éé¡ãèªåçã«èšç®ããã«ã¯ãããè€éãªèšç®åŒã䜿çšããå¿ èŠããããŸããããããã£ãŠãQUERY é¢æ°ã䜿çšããŠããŒã¿ãããã·ã¥ââããŒã ããŒãžã®ãµãŒãã¹ ããŒãã«ã«ãã€ã³ãããå¿ èŠããããŸããã
=ROUNDDOWN(G4*24*IFERROR(QUERY(dashboard!$G$2:$H$5; "Select H where G = '"& $D4 & "'");0)
ã¡ã€ã³ã®ã¢ã¯ã·ã§ã³ã«å ããŠãäžèŠãª IFERROR ãŸã㯠ISBLANK ãšã©ãŒãæé€ããããã®é¢æ°ãšãROUNDDOWN é¢æ°ãè¿œå ããŸããã现ããããšã«ç ©ããããªãããã«ããããã«ãã¯ã©ã€ã¢ã³ãã«åããŠæçµçãªéé¡ãåãæšãŠãŸããã
åäŸçšãã¬ã€ã«ãŒã ã§ã¯ãäž»ãªåå ¥ïŒã¬ã³ã¿ã«æéïŒã«å ããŠããµãŒãã¹ãããã¡ãã®è²©å£²ãšãã圢ã§è¿œå åå ¥ããããåŸæ¥å¡ã¯ãããšãã°ã飲ææ°Žã®ä»£éãæ¯æã£ããããäžèŸã«ãã£ã³ãã£ãè²·ã£ãããããªã©ãå°é¡ã®æ¯åºãè¡ããŸããããããã¹ãŠãèæ ®ã«å ¥ããå¿ èŠããããŸãã
ãããã£ãŠããã®ããŒã¿ãèšé²ããããŒãã«ãããã« 2 ã€è¿œå ããŸããã
èšå·ã®æäœã容æã«ããããã«ãèšå·ã«è²ãä»ããã»ã«ã«æ¡ä»¶ä»ãæžåŒãè¿œå ããŸããã
ã¡ã€ã³ããŒãã«ã®æºåãã§ããŸããã次ã«ã1 æ¥ã«ããã皌ãã ã®ãããã®ãéã®ãã¡ã¬ãžã«ãããããã®ããã«ãŒãã«ãããããã®ããæ確ã«ç¢ºèªã§ããããã«ãã¡ã€ã³ææšãå¥ã®ããŒãã«ã«é 眮ããå¿ èŠããããŸãã
æ¯æãã¿ã€ãããšã«éé¡ãåèšããããã«ãããäžåºŠ QUERY é¢æ°ã䜿çšããŸããã
=QUERY(I8:J;"SELECT sum(J) WHERE I='ÐалОÑка'"» О «=QUERY(I8:J;"SELECT sum(J) WHERE I='ÐаÑÑа'")
管çè ã¯ãå¶æ¥æ¥ã®çµããã«åçãå確èªããã ãã§ãããæåã§åèšç®ããå¿ èŠã¯ãããŸããã人ã«è¿œå ã®äœæ¥ã匷å¶ããããšã¯ãªãããªãŒããŒã¯ãã€ã§ãç¶æ³ã確èªããã³ã³ãããŒã«ããããšãã§ããŸãã
å¿ èŠãªããŒãã«ããã¹ãŠæºåã§ããã®ã§ãæ¯æ¥ã®ã¿ããè€è£œããçªå·ãä»ããŠã以äžãååŸããŸãã
çŽ æŽãããïŒã»ãŒãã¹ãŠã®æºåãå®äºããŸãããæ®ã£ãŠããã®ã¯ããã®æã®ãã¹ãŠã®äž»èŠãªææšãããã·ã¥ââããŒã ã¿ãã«è¡šç€ºããããšã ãã§ãã
ãã®æã®åèšåå ¥ãååŸããã«ã¯ã次ã®åŒãæžãããšãã§ããŸãã
='1'!D1+'2'!D1+'3'!D1+'4'!D1+'5'!D1+'6'!D1+'7'!D1+'8'!D1+'9'!D1+'10'!D1+'11'!D1+
'12'!D1+'13'!D1+'14'!D1+'15'!D1+'16'!D1+'17'!D1+'18'!D1+'19'!D1+'20'!D1+'21'!D1+
'22'!D1+'23'!D1+'24'!D1+'25'!D1+'26'!D1+'27'!D1+'28'!D1+'29'!D1+'30'!D1+'31'!D1
ããã§ãD1 ã¯æ¥æ¬¡åçã瀺ãã»ã«ã§ãã1ããã2ããªã©ã¯ã¿ãã®ååã§ãããŸã£ããåãæ¹æ³ã§ãè¿œå ã®åå ¥ãšæ¯åºã«é¢ããããŒã¿ãååŸããŸãã
ããããããããããã«ãã«ããŽãªããšã®åèšåçæ§ã衚瀺ããããšã«ããŸããããããè¡ãã«ã¯ããã¹ãŠã®ã¿ãããè€éãªéžæãšã°ã«ãŒãåãè¡ã£ãŠããã空ã®è¡ãäžèŠãªè¡ããã£ã«ã¿ãªã³ã°ããŠåé€ããå¿ èŠããããŸããã
ã«ããŽãªãŒå¥åçæ§
äž»èŠãªåå ¥èšç®ããŒã«ã®æºåãã§ããã®ã§ãããšã¯ 1 幎ã®åæã®ãã¡ã€ã«ãè€è£œããã ãã§ãã
åå ¥ãäŒèšããã³ç£èŠããããã®ããŒã«ãäœæããåŸã家è³ã絊äžãçšéãååã®è³Œå ¥ããã®ä»ã®æ¯åºãªã©ãæ¯æã®ãã¹ãŠã®æ¯åºãèæ ®ããæ¯åºè¡šã®äœæã«åãæãããŸããã
çŸåšã®å¹Žã®ãã©ã«ããŒã« Google ã¹ãã¬ããã·ãŒã ããã¥ã¡ã³ããäœæãã13 åã®ã¿ããããã·ã¥ããŒããããã³ XNUMX ãæãè¿œå ããŸããã
ããã·ã¥ããŒãã¿ã
ããããããããããã«ãããã·ã¥ããŒã ã¿ãã«ããã®å¹Žã®è²¡åæ¯åºã«é¢ããå¿ èŠãªæ å ±ããã¹ãŠãŸãšããŸããã
ãããŠãåæããšã®ã¿ãã§ãäŒç€Ÿã®ãã¹ãŠã®çŸéæ¯åºãã«ããŽãªãŒå¥ã«è¿œè·¡ããè¡šãäœæããŸããã
ãæãã¿ã
ããã¯éåžžã«äŸ¿å©ã§ããããšãããããäŒç€Ÿã®ãã¹ãŠã®çµè²»ã確èªããŠç®¡çã§ããããã«ãªããå¿ èŠã«å¿ããŠå±¥æŽã確èªããããåæãè¡ã£ããããããšãã§ããŸãã
åå ¥ãšæ¯åºã«é¢ããæ å ±ã¯å¥ã®ãã¡ã€ã«ã«ãããç£èŠããã®ãããŸã䟿å©ã§ã¯ãªããããææè ãäŒç€Ÿã管çããã³ç®¡çããããã«å¿ èŠãªãã¹ãŠã®é¢é£æ å ±ããŸãšãã 1 ã€ã®ãã¡ã€ã«ãäœæããããšã«ããŸããããã®ãã¡ã€ã«ã«ãæŠèŠããšããååãä»ããŸããã
éèšããŒãã«
ãã®ãã¡ã€ã«ã§ã¯ãããŒãã«ããæ¯æã®ããŒã¿ãåãåãããŒãã«ãäœæããŸããããã®ããã«ãæšæºé¢æ°ã䜿çšããŸããã
=IMPORTRANGE("url";"dashboard!$B$1")
ããã§ãæåã®åŒæ°ãšããŠããã¥ã¡ã³ã ID ãæž¡ãã2 çªç®ã®åŒæ°ãšããŠã€ã³ããŒããããç¯å²ãæž¡ããŸãã
ããããç§ã¯å¹Žéåæ¯ããŸãšããŸãããã€ãŸããããã皌ãã ã®ããããã䜿ã£ãã®ããå©çã¯ããããªã®ããåçæ§ã¯ã©ããªã£ãã®ãããšããããšã§ããå¿ èŠãªããŒã¿ãå¯èŠåããŸããã
ãŸããããžãã¹ ãªãŒããŒããã¡ã€ã«ã確èªããã«ãã¹ãŠã®ããŒã¿ã 1 ãæã§ç¢ºèªã§ããããã«ãå©äŸ¿æ§ãèæ ®ããŠãäžå¹Žã®ä»»æã®æãéžæããäž»èŠãªææšããªã¢ã«ã¿ã€ã ã§è¡šç€ºããæ©èœãçµ±åããŸããã
ãããè¡ãããã«ãæãšããã¥ã¡ã³ã ID ã®éã«ãªã³ã¯ãäœæããŸããã
次ã«ããããŒã¿ -> ããŒã¿æ€èšŒãã䜿çšããŠããããããŠã³ ãªã¹ããäœæãããªã³ã¯ã®ç¯å²ãæå®ããããã¥ã¡ã³ããžã®åçãªã³ã¯ã䜿çšããŠã€ã³ããŒããèšå®ããŸããã
=IMPORTRANGE("'"& QUERY(O2:P13;"SELECT P WHERE O ='"& K7 &"'") &"'"; "dashboard!$A1:$B8")
ãŸãšã
ã芧ã®ãšãããããžãã¹ã®ããã»ã¹ãæ¹åããããšã¯æã£ãŠããã»ã©é£ãããªãããããè¡ãããã«ç¹å¥ãªã¹ãã«ãæã£ãŠããå¿ èŠã¯ãããŸããããã¡ããããã®ã·ã¹ãã ã«ã¯æ¬ ç¹ãå€ããããžãã¹ãæé·ããã«ã€ããŠäœ¿çšã§ããªããªããŸãããå°èŠæš¡ãªããžãã¹ã仮説ãæ€èšŒããæåã®æ®µéã§ã¯ãããã¯åªãããœãªã¥ãŒã·ã§ã³ã§ãã
ãã®ã²ãŒã ã«ãŒã ã¯ãã®ãœãªã¥ãŒã·ã§ã³ã«åãçµã㧠3 幎ç®ã§ãããä»å¹Žã«ãªã£ãŠåããŠããã¹ãŠã®ããã»ã¹ããã§ã«æ確ã«ç解ããŠãããã¯ã©ã€ã¢ã³ããšåžå Žãç解ããŠããŸããç§ãã¡ã¯æ¬æ Œçãªãªã³ã©ã€ã³ ããžãã¹ç®¡çããŒã«ãäœæããããšã«ããŸããã
PS
Google ã¹ãã¬ããã·ãŒãã䜿çšããŠããžãã¹ãç£èŠããããšã¯ãç¹ã«æºåž¯é»è©±ããã¯ããŸã䟿å©ã§ã¯ãããŸãããããã§ç§ã¯ããããŸãã
åºæïŒ habr.com