¢À ¼¼¹«Á¶Á¤ÀÏ»çõ¸®2000ÀÇ ¼ö½Ä¼öÁ¤¿¡ °üÇÑ »çÇ×À» ´ÙÀ½°ú °°ÀÌ ¾Ë·Áµå¸®¿À´Ï
Âü°íÇϽñ⠹ٶø´Ï´Ù.
-2000³â 2¿ù 15ÀÏ ÇöÀç-
1) ¼öÁ¤¹æ¹ý
©ç °¢ ÇØ´ç±Ý¾×ÀÌ ÀÔ·ÂµÉ ºÎºÐÀ» Ŭ¸¯Çϸé ȸé»ó´Ü ¼ö½ÄÀÔ·ÂÁÙ¿¡ ±âÁ¸ ¼ö½ÄÀÌ
³ªÅ¸³³´Ï´Ù.
©è ±âÁ¸ ¼ö½ÄÀ» ¼öÁ¤ ÀÔ·ÂÇÏ°í ¿£Å͸¦ ´©¸¨´Ï´Ù.
©é ¼ö½ÄÀ» ¸ðµÎ ¼öÁ¤ÇßÀ¸¸é ²À ÀúÀåÇϽñ⠹ٶø´Ï´Ù.
2) ¼öÁ¤»çÇ×
¡Ú ¹ýÀμ¼¹ý½ÃÇà±ÔÄ¢ º°Áö¼½Ä 23È£(À») Á¢´ëºñÁ¶Á¤¸í¼¼¼(À»)
¨ì±âŸ ¹× ¨íÇÕ°è ¶õÀÇ ¼ö½ÄÀ» »èÁ¦
¡Ú ¹ýÀμ¼¹ý½ÃÇà±ÔÄ¢ º°Áö¼½Ä 23È£(º´) Á¢´ëºñÁ¶Á¤¸í¼¼¼(º´)
¨ó ±âÁؽſëÄ«µåµî »ç¿ëºñÀ²: ¨éƯº°½Ã, ¨ê±¤¿ª½Ã, ¨ë½Ã ¨ì±ºÀÇ °¢°¢ÀÇ ¼ö½ÄÁß
80, 70, 60, 50À» °¢°¢ 0.8, 0.7, 0.6, 0.5 ·Î ¼öÁ¤ÇÏ°í *100À» °¢°¢ »èÁ¦ÇÕ
´Ï´Ù
±×¸®°í À§ ¼öÁ¤ÇÑ 4°³¶õÀÇ Ç¥½ÃÇü½ÄÀ» ¹éºÐÀ²·Î Ç¥½ÃÇÕ´Ï´Ù.
¡Ø ¹éºÐÀ²Ç¥½Ã¹æ¹ý:
¼¿¼±Åâ¡¿À¸¥ÂʹöÆ° Ŭ¸¯¢¡¸Þ´ºÁß ¼¿¼½Ä ¼±Åâ¡Ç¥½ÃÇü½ÄÁß ¹éºÐÀ² ¼±Åâ¡È®ÀÎ
[¼öÁ¤¿¹]
¨é Ưº°½Ã =MIN(80,(IF(H15=0,0,ROUND((H15-H13)*100/H15,2)))) ¸¦
=MIN(0.8,(IF(H15=0,0,ROUND((H15-H13)/H15,2))))·Î ¼öÁ¤
¨ê ±¤¿ª½Ã =MIN(70,(IF(L15=0,0,ROUND((L15-L13)*100/L15,2)))) ¸¦
=MIN(0.7,(IF(L15=0,0,ROUND((L15-L13)/L15,2)))) ·Î ¼öÁ¤
¨ë ½Ã =MIN(60,(IF(P15=0,0,ROUND((P15-P13)*100/P15,2)))) ¸¦
=MIN(0.6,(IF(P15=0,0,ROUND((P15-P13)/P15,2)))) ·Î ¼öÁ¤
¨ì ±º =MIN(50,(IF(T15=0,0,ROUND((T15-T13)*100/T15,2)))) ¸¦
=MIN(0.5,(IF(T15=0,0,ROUND((T15-T13)/T15,2)))) ·Î ¼öÁ¤
¡Ú ¹ýÀμ¼¹ý½ÃÇà±ÔÄ¢ º°Áö¼½Ä 34È£ ´ë¼ÕÃæ´ç±Ý¹×´ë¼Õ±ÝÁ¶Á¤¸í¼¼¼
ȸ»ç°è»ó¾× ¨ì°è ¶õÀÇ ¼ö½Ä =SUM(N12:T12)À» =SUM(O12:T12)·Î ¼öÁ¤
¡Ú ¹ýÀμ¼¹ý½ÃÇà±ÔÄ¢ º°Áö¼½Ä 8(°©)È£ °øÁ¦°¨¸é¼¼¾×¹×Ãß°¡³³ºÎ¼¼¾×ÇÕ°èÇ¥(°©)
(101)¿Ü±¹³³ºÎ¼¼¾×°øÁ¦ Áß
¨é´ë»ó¼¼¾× ="8ºÎÇ¥5"!E22¸¦ ="8ºÎÇ¥5"!M23À¸·Î
¨ê°øÁ¦¼¼¾× ="8ºÎÇ¥5"!Q22¸¦ ="8ºÎÇ¥5"!Q23À¸·Î ¼öÁ¤
¡Ø ¹®ÀÇÀüÈ: (ÁÖ)Á¶¼¼Åë¶÷»ç ¿¬±¸°³¹ß½Ç Á¤ÅÂÁ¶(02-2231-7141¡2)
Âü°íÇϽñ⠹ٶø´Ï´Ù.
-2000³â 2¿ù 15ÀÏ ÇöÀç-
1) ¼öÁ¤¹æ¹ý
©ç °¢ ÇØ´ç±Ý¾×ÀÌ ÀÔ·ÂµÉ ºÎºÐÀ» Ŭ¸¯Çϸé ȸé»ó´Ü ¼ö½ÄÀÔ·ÂÁÙ¿¡ ±âÁ¸ ¼ö½ÄÀÌ
³ªÅ¸³³´Ï´Ù.
©è ±âÁ¸ ¼ö½ÄÀ» ¼öÁ¤ ÀÔ·ÂÇÏ°í ¿£Å͸¦ ´©¸¨´Ï´Ù.
©é ¼ö½ÄÀ» ¸ðµÎ ¼öÁ¤ÇßÀ¸¸é ²À ÀúÀåÇϽñ⠹ٶø´Ï´Ù.
2) ¼öÁ¤»çÇ×
¡Ú ¹ýÀμ¼¹ý½ÃÇà±ÔÄ¢ º°Áö¼½Ä 23È£(À») Á¢´ëºñÁ¶Á¤¸í¼¼¼(À»)
¨ì±âŸ ¹× ¨íÇÕ°è ¶õÀÇ ¼ö½ÄÀ» »èÁ¦
¡Ú ¹ýÀμ¼¹ý½ÃÇà±ÔÄ¢ º°Áö¼½Ä 23È£(º´) Á¢´ëºñÁ¶Á¤¸í¼¼¼(º´)
¨ó ±âÁؽſëÄ«µåµî »ç¿ëºñÀ²: ¨éƯº°½Ã, ¨ê±¤¿ª½Ã, ¨ë½Ã ¨ì±ºÀÇ °¢°¢ÀÇ ¼ö½ÄÁß
80, 70, 60, 50À» °¢°¢ 0.8, 0.7, 0.6, 0.5 ·Î ¼öÁ¤ÇÏ°í *100À» °¢°¢ »èÁ¦ÇÕ
´Ï´Ù
±×¸®°í À§ ¼öÁ¤ÇÑ 4°³¶õÀÇ Ç¥½ÃÇü½ÄÀ» ¹éºÐÀ²·Î Ç¥½ÃÇÕ´Ï´Ù.
¡Ø ¹éºÐÀ²Ç¥½Ã¹æ¹ý:
¼¿¼±Åâ¡¿À¸¥ÂʹöÆ° Ŭ¸¯¢¡¸Þ´ºÁß ¼¿¼½Ä ¼±Åâ¡Ç¥½ÃÇü½ÄÁß ¹éºÐÀ² ¼±Åâ¡È®ÀÎ
[¼öÁ¤¿¹]
¨é Ưº°½Ã =MIN(80,(IF(H15=0,0,ROUND((H15-H13)*100/H15,2)))) ¸¦
=MIN(0.8,(IF(H15=0,0,ROUND((H15-H13)/H15,2))))·Î ¼öÁ¤
¨ê ±¤¿ª½Ã =MIN(70,(IF(L15=0,0,ROUND((L15-L13)*100/L15,2)))) ¸¦
=MIN(0.7,(IF(L15=0,0,ROUND((L15-L13)/L15,2)))) ·Î ¼öÁ¤
¨ë ½Ã =MIN(60,(IF(P15=0,0,ROUND((P15-P13)*100/P15,2)))) ¸¦
=MIN(0.6,(IF(P15=0,0,ROUND((P15-P13)/P15,2)))) ·Î ¼öÁ¤
¨ì ±º =MIN(50,(IF(T15=0,0,ROUND((T15-T13)*100/T15,2)))) ¸¦
=MIN(0.5,(IF(T15=0,0,ROUND((T15-T13)/T15,2)))) ·Î ¼öÁ¤
¡Ú ¹ýÀμ¼¹ý½ÃÇà±ÔÄ¢ º°Áö¼½Ä 34È£ ´ë¼ÕÃæ´ç±Ý¹×´ë¼Õ±ÝÁ¶Á¤¸í¼¼¼
ȸ»ç°è»ó¾× ¨ì°è ¶õÀÇ ¼ö½Ä =SUM(N12:T12)À» =SUM(O12:T12)·Î ¼öÁ¤
¡Ú ¹ýÀμ¼¹ý½ÃÇà±ÔÄ¢ º°Áö¼½Ä 8(°©)È£ °øÁ¦°¨¸é¼¼¾×¹×Ãß°¡³³ºÎ¼¼¾×ÇÕ°èÇ¥(°©)
(101)¿Ü±¹³³ºÎ¼¼¾×°øÁ¦ Áß
¨é´ë»ó¼¼¾× ="8ºÎÇ¥5"!E22¸¦ ="8ºÎÇ¥5"!M23À¸·Î
¨ê°øÁ¦¼¼¾× ="8ºÎÇ¥5"!Q22¸¦ ="8ºÎÇ¥5"!Q23À¸·Î ¼öÁ¤
¡Ø ¹®ÀÇÀüÈ: (ÁÖ)Á¶¼¼Åë¶÷»ç ¿¬±¸°³¹ß½Ç Á¤ÅÂÁ¶(02-2231-7141¡2)
½Ç¹«Çؼ³
- Åýº³Ý [»ýÈ°¹ý·É Q&A] ÅðÁ÷±Þ¿©Á¦µµ
- Åýº³Ý [ÁÖ°£ HOT »ó´ã»ç·Ê] °¡¾÷»ó¼Ó°øÁ¦ ÀçÁ÷¿ä°Ç¿¡¼ »ó¼ÓÀÎÀÌ ´Ù¸¥ »ç¾÷ÀåÀ» â¾÷ÇÏ´Â µî °â¾÷Çصµ µÇ´ÂÁö? ¿Ü
- º¯Á¾È 2024³âºÎÅÍ »õ·Î Àû¿ëµÇ´Â È¥ÀΤýÃâ»ê Áõ¿©Àç»ê °øÁ¦
- ±è¹ü¼® ´ç½ÅÀÌ ¾Ë°í ÀÖ´Â ¿µ¾÷ÀÌÀÍ, ±× ¿µ¾÷ÀÌÀÍÀÌ ¸Â½À´Ï±î?(1) - ¼ÕÀÍ°è»ê¼ÀÇ ±¸Á¶
- ¾È¹ü¼ö Àú¼º°úÀÚ¿¡ ´ëÇÑ Åë»óÇØ°íÀÇ Á¤´ç¼º
- Åýº³Ý [»ýÈ°¹ý·É Q&A] ÅðÁ÷±Þ¿©Á¦µµ
- Åýº³Ý [ÁÖ°£ HOT »ó´ã»ç·Ê] °¡¾÷»ó¼Ó°øÁ¦ ÀçÁ÷¿ä°Ç¿¡¼ »ó¼ÓÀÎÀÌ ´Ù¸¥ »ç¾÷ÀåÀ» â¾÷ÇÏ´Â µî °â¾÷Çصµ µÇ´ÂÁö? ¿Ü
- º¯Á¾È 2024³âºÎÅÍ »õ·Î Àû¿ëµÇ´Â È¥ÀΤýÃâ»ê Áõ¿©Àç»ê °øÁ¦
- ±è¹ü¼® ´ç½ÅÀÌ ¾Ë°í ÀÖ´Â ¿µ¾÷ÀÌÀÍ, ±× ¿µ¾÷ÀÌÀÍÀÌ ¸Â½À´Ï±î?(1) - ¼ÕÀÍ°è»ê¼ÀÇ ±¸Á¶
- ¾È¹ü¼ö Àú¼º°úÀÚ¿¡ ´ëÇÑ Åë»óÇØ°íÀÇ Á¤´ç¼º
Hot issue