¨ä¹ê§Ú¤]¤£¤Ó½T©w³oÓ¼ÐÃD¬O§_¤Uªº¦n.§Ú·Qn°µªº¬OÃÒ劵§ë¸êªº¦^ºÓ´ú¸Õ,¥Î§Q²v©M§Q®t¨âÓ±ø¥ó¨Ó¨M©w§ë¸êªøµu¤Ñ´Áªº¤ñ«
²³æªº»¡,¦³¨âÓÅܼÆA©MB, A¬°ªø劵§Q²v,B¬°ªøµu劵§Q®t,±ø¥ó¦p¤U
1.·íA¹F¨ì2.2(§t)¥H¤W,¥BB¬°0.3(§t)¥H¤W®É,«h100%§ëªø
2.·íA¹F¨ì2.2(§t)¥H¤W,¥BB¬°0.3¥H¤U®É,«h75%§ëªø,25%§ëµu
3.·íA¬°1.9(§t)~2.2¤¤¶¡,¥BB¬°0.3(§t)¥H¤W®É,«hªø/µu ¦U50%
4.·íA¬°1.9(§t)~2.2¤¤¶¡,¥BB¬°0.3¥H¤U®É,«hªø/µu 35%/65%
5.·íA¬°1.6(§t)~1.9¤¤¶¡,¥BB¬°0.3(§t)¥H¤W®É,«hªø/µu 20%/80%
6.·íA¬°1.6(§t)~1.9¤¤¶¡,¥BB¬°0.3¥H¤U®É,«hªø/µu 10%/90%
7.·íA¤p©ó1.6,«h100%§ëµu劵
ªøµu劵¤§¤ñ«¥²¶·¤j©óµ¥©ó¹s,¥B¥²¶·§¹¥þ§ë¸ê
¨ä¹ê´N¬On§äªþ¥óHÄ檺¤ñ«,IÄ檽±µ¥Î(1-H)§Y¥i
§Ú¥Ø«e°µªk¬O¥ý±N§Q²v¤Î§Q®t¦U³]©w¤@KEYÈ,¦pÄæ¦ìE©MF
EÄæ¦ì§Q²vªºKEYÈ,§Q²v >=2.20«h¬°3. 1.9<=§Q²v<2.2,«h¬°2. 1.6<=§Q²v<1.9,«h¬°1. §Q²v<1.6«h¬°0
FÄæºû§Q®tKEYÈ. §Q®t>=0.3,«h¬°1,§_«h¬°0
®Ú¾Ú¤W±±ø¥ó§@¤@²³æ¤§ªí®æ(K13:M17). ®Ú¾ÚKEYÈ©Ò§ä¥Xªº¼Æ¦r¥hvlookupªí®æ²zªº²Õ¦X±ø¥ó±o¨ì§ë¸ê¤ñ«....
§Ú·Q½Ð±Ð¦U¦ì«e½ú¬O§_¦³§ó®e©öªº°µªk,¯à°÷¹F¨ì©Ònªº§ë¸ê¤ñ«,¤S¯à²¤Æ¾ãÓexcelªº¨Ï¥Î,¸`¬Ù¤@ÂI®É¶¡. ·P¿E¤£ºÉ |