[B! Excel] wind0627ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

wind0627 id:wind0627

Excelã«é–¢ã™ã‚‹wind0627ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ç¬¬ä¸‰å›žã€€ã€ŒIFé–¢æ•°ã€ã®ç©ºç™½å‡¦ç†ã‚’çŸ¥ã‚‰ãªã„ã¨Excelã®ä¾¿åˆ©ã•åŠæ¸›ï¼ï¼Ÿ
ç„¡é§„ã‚’çœã‘ã‚‹ã¯ãšã®Excelã®ä¾¿åˆ©ãªæ©Ÿèƒ½ã‚‚ã€ãã®æ´»ã‹ã—æ–¹ã‚’çŸ¥ã‚‰ãªã‘ã‚Œã°ã€é€†ã«æ‰‹é–“ã¨ãƒªã‚¹ã‚¯ãŒå¢—ãˆã¦ã—ã¾ã†ã¨ã„ã†æ€–ã„ãŠè©±ã§ã™ã€‚ è«‹æ±‚æ›¸ã‚„ç´å“æ›¸ã‚’ä½œæˆã™ã‚‹ã¨ãã€ã‚ã‚‰ã‹ã˜ã‚é‡‘é¡ã®æ¬„ã«ã€Œï¼å˜ä¾¡Ã—æ•°é‡ã€ã¨ã„ã†æ•°å¼ã‚’å…¥åŠ›ã—ã¦ãŠãã®ãŒä¸€èˆ¬çš„ã§ã™ã€‚ ã—ã‹ã—ã€ãã®å¼ã ã‘ã‚’å…¥åŠ›ã—ã¦ã„ã‚‹ã¨ã€å˜ä¾¡ã‚„æ•°é‡ã‚’å…¥åŠ›ã—ã¦ã„ãªã„åˆ—ã«ã€Œã‚¨ãƒ©ãƒ¼å€¤ã€ãŒè¡¨ç¤ºã•ã‚Œã¦ã—ã¾ã„ã¾ã™ã€‚ ã“ã†ãªã‚‹ã¨ã€ã„ã¡ã„ã¡ã‚¨ãƒ©ãƒ¼å€¤ã‚’æ¶ˆã™ä½œæ¥ã‚’ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã®ã§ã€ç„¡é§„ãªä½œæ¥ãŒå¢—ãˆã¦ã—ã¾ã„ã¾ã™ã€‚ Excelé–¢æ•°ã®å¤§å¾¡æ‰€ã€ŒIFé–¢æ•°ã€ã‚’ä½¿ã£ãŸç©ºç™½å‡¦ç†ã‚’è¡Œãªã£ã¦ãŠã‘ã°ã€ã“ã‚“ãªå•é¡Œã¯ç°¡å˜ã«å›žé¿ã§ãã¾ã™ã€‚ ã€ŒIFé–¢æ•°ã€ã‚’ä½¿ã£ãŸç©ºç™½å‡¦ç†ã‚’ã—ã¦ã„ãªã„ã¨ãƒ»ãƒ»ãƒ» ä¸‹ã®ä¾‹ã®ã‚ˆã†ã«ã€ã€Œé‡‘é¡ã€ã®ã‚»ãƒ«ã«ã€Œå˜ä¾¡Ã—æ•°é‡ã€ã®çµæžœã‚’è¡¨ç¤ºã•ã›ã‚‹ã‚ˆã†ã«æ•°å¼ã‚’å…¥åŠ›ã—ãŸã ã‘ã®ã‚»ãƒ«ã‚’ãƒ•ã‚£ãƒ«ã‚³ãƒ”ãƒ¼ã—ã¦ãŠã„ãŸçŠ¶æ…‹ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãŒå…¥åŠ›ã•ã‚Œã¦ã„ãªã„è¡Œã®ã€Œé‡‘é¡ã€ã®ã‚»ãƒ«ã«ã‚¨ãƒ©ãƒ¼å€¤ãŒå‡ºã¦ã—ã¾ã„ã¾ã™ã€‚ ã—ã‹ã‚‚ã€å³å›³ã®ã‚ˆ
wind0627 2011/07/07
Excel

tips
ãƒªãƒ³ã‚¯
Excel ã‚’ä½¿ã£ãŸã‚¿ã‚¹ã‚¯ç®¡ç†ï¼šITã¨ãƒ“ã‚¸ãƒã‚¹ã®å¯èƒ½æ€§ï¼šã‚ªãƒ«ã‚¿ãƒŠãƒ†ã‚£ãƒ–ãƒ»ãƒ–ãƒã‚°
ãŸã¾ã«ã¯ã€Excel ã®æ´»ç”¨æ–¹æ³•ã‚’ãƒ»ãƒ»ãƒ»ã¨ã„ã†ã“ã¨ã§ã€Excel ã‚’ä½¿ã£ãŸã‚¿ã‚¹ã‚¯ç®¡ç†ã®æ–°ä¸–ä»£ã«ã¤ã„ã¦æ›¸ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¾ãšã€ãã‚‚ãã‚‚ Excel ã§ã‚¿ã‚¹ã‚¯ç®¡ç†ã¨ã„ã†è¡¨ç¾ã‚’ã—ã¾ã™ãŒã€æ£ç¢ºã«ã¯ã€è¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆã§ã‚¿ã‚¹ã‚¯ç®¡ç†ãƒ»ãƒ»ãƒ»ã§ã¯ãªã„ã‹ã¨ã€‚ä»£è¡¨æ ¼ã¯ã€Excel ã§å¤šãã®æ–¹ã€…ãŒ Excel ã‚’ãŠä½¿ã„ãã ã•ã£ã¦ã„ã‚‹ã“ã¨ã¯ã†ã‚Œã—ã„é™ã‚Šã§ã™ã€‚ ã¡ãªã¿ã«ã€ã€ŒExcel ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€å…±æœ‰ã¯ã§ããªã„ï¼ˆã¾ãŸã¯ã€é›£ãŒã‚ã‚‹ï¼‰ã‹ã‚‰ã€Google ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§ãƒ»ãƒ»ãƒ»ã€ã¨ã„ã†ã®ã‚‚è€³ã«ã—ãŸã‚Šã—ã¾ã™ãŒã€ä»Šã® Office ã«ã¯ã€Web App ãŒã‚ã‚Šã¾ã™ã€‚Excel ã§è¡¨ç¾ã§ãã‚‹ã‚‚ã®ã¯ã€ãã®ã¾ã¾ Web App ã§ãƒ–ãƒ©ã‚¦ã‚¶ã§è¡¨ç¾ã§ãã¾ã™ï¼ˆã‚°ãƒ©ãƒ•ã ã£ã¦ï¼‰ã—ã€ç·¨é›†ã‚‚ã§ãã¾ã™ã€‚è©³ã—ãã¯ã€ã“ã¡ã‚‰ ã‚’ã”è¦§ãã ã•ã„ã€‚ â˜† â˜† â˜† â˜† â˜† ã•ã¦ã•ã¦ã€æœ¬é¡Œã§ã™ãŒã€Excel ãƒ•ã‚¡ã‚¤ãƒ«ã§ã®ã‚¿ã‚¹ã‚¯ç®¡ç†ã§ã™ãŒã€ä»¥ä¸‹ã®è¦å› ãŒã‚ã‚‹ã¨ãã¯ã€
wind0627 2010/10/05
Excel

ã‚¿ã‚¹ã‚¯ç®¡ç†
ãƒªãƒ³ã‚¯
Excelã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ã‹ã‚‰è„±å´ã›ã‚ˆï½žSWæ§‹æˆç®¡ç†ã‚’è¦‹ç›´ãã† - ãƒ—ãƒã‚°ãƒ©ãƒžã®æ€ç´¢
Redmineã‚„TestLinkã€Hudsonãªã©ã®ãƒ„ãƒ¼ãƒ«ã¯ä¸€ä½“ä½•ã‚’æ”¹å–„ã—ã¦ã€ä½•ã‚’ç›®æŒ‡ã—ã¦ã„ã‚‹ã®ã‹ï¼Ÿ ä¸€è¨€ã§å›žç”ã™ã‚‹ãªã‚‰ã°ã€ã“ã‚Œã‚‰ã®ãƒ„ãƒ¼ãƒ«ã¯ã„ã‚ã‚†ã‚‹SWæ§‹æˆç®¡ç†ã‚’ITåŒ–ã™ã‚‹ãƒ„ãƒ¼ãƒ«ãªã®ã ã€ã¨è€ƒãˆã‚Œã°ã‚ˆã„ã€‚ ã¤ã¾ã‚Šã€ä¸‹è¨˜ã®ã‚¤ãƒ¡ãƒ¼ã‚¸ã ã€‚ Excelã§é€²æ—ç®¡ç†ã—ã¦ã„ãŸ â†’Redmineã§ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ã‚’ITåŒ– ã‚½ãƒ¼ã‚¹ã‚„ä»•æ§˜æ›¸ã‚’å±¥æ´å…±æœ‰ã§ãã‚‹ä»•çµ„ã¿ãŒç„¡ããƒ•ã‚¡ã‚¤ãƒ«ã‚’æ—¥ä»˜ç®¡ç†ã—ã¦ã„ãŸ â†’Subversionã§å…±åŒæ‰€æœ‰ Excelã§ãƒ†ã‚¹ãƒˆä»•æ§˜æ›¸ã‚’ç®¡ç†ã—ã¦ã„ãŸ â†’TestLinkã§ãƒ†ã‚¹ãƒˆä»•æ§˜æ›¸ã‚’WebåŒ– æ‰‹ä½œæ¥ã§ãƒ“ãƒ«ãƒ‰ã—ã¦ã„ãŸ â†’Hudsonã§ãƒ“ãƒ«ãƒ‰ã‚’è‡ªå‹•åŒ–(ç¶™ç¶šçš„ã‚¤ãƒ³ãƒ†ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³) æˆ‘ã€…IT æŠ€è¡“è€…ã¯ã€ãŠå®¢æ§˜ãŒExcelã‚„Accessã§é‹ç”¨ã—ã¦ã„ã‚‹æ¥å‹™ã‚’ITåŒ–ã€WebåŒ–ã™ã‚‹ã®ãŒä¸»ãªä»•äº‹ãªã®ã«ã€è‚å¿ƒã®è‡ªåˆ†ãŸã¡ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ã®æ®†ã©ã¯ã€Excelã§é‹ç”¨ã—ã¦å››è‹¦å…«è‹¦ã—ã¦ã„ã‚‹ã ã‚ã†ã€‚ æ—¥æœ¬ã®æ®†ã©ã®SIerã§åƒ
wind0627 2010/08/22
æœªã ã«ã€Excelã§ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ã—ã¦ã‚‹æ‰€ã¯å¤šã„ã€‚ãã—ã¦ã€ãã‚Œã‚’Redmineç‰ã®SWæ§‹æˆç®¡ç†ã‚’ITåŒ–ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã«ç§»è¡Œã•ã›ã‚‹ã®ã¯æœ¬å½“ã«é›£ã—ã„ã€‚ã€‚ã€‚

ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†

Excel

é–‹ç™º
ãƒªãƒ³ã‚¯
1