HOME / ¹®¼­°øÀ¯ / /

Èıâ6°Ç
´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ - ½æ³×ÀÏ 1page
1/14
  • 1 page
  • 2 page
  • 3 page
  • 4 page
  • 5 page
  • 6 page
  • 7 page
  • 8 page
  • 9 page
  • 10 page
  • 11 page
  • 12 page
  • 13 page
  • 14 page

´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥

¼­½Ä¹øÈ£
TZ-SHR-1119783
µî·ÏÀÏÀÚ
2020.08.16
ºÐ·®
41 page / 392.1 KB
Æ÷ÀÎÆ®
5,000 Point ¹®¼­°øÀ¯ Æ÷ÀÎÆ® Àû¸³¹æ¹ý ¾È³»
ÆÄÀÏ Æ÷¸Ë
Microsoft Excel (xlsm)
Èıâ Æò°¡

4.0

6°ÇÀÇ Èı⺸±â

µî·ÏÀÚ

kj*** ºê·ÐÁî

µî±Þº° ÇýÅú¸±â

´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥¿¡ ´ëÇØ ±â¼úÇÑ Âü°íÀÚ·áÀÔ´Ï´Ù. ´Ü¼øÇÑ È¸ºñ°ü¸®»Ó¸¸ ¾Æ´Ï¶ó ȸ¿ø°ü¸®, ¿ù Áß È¸°èº¸°í¼­, ¿¹°á»ê¼­ µîÀ» ÀÚµ¿À¸·Î »ý¼ºÇÒ ¼ö ÀÖµµ·Ï ÇÁ·Î±×·¥È­µÇ¾î ÀÖ½À´Ï´Ù.

ÁÁÀºÀÚ·á»ó ¼ö»óÀÛ20³â 8¿ùÃÖ¿ì¼ö10¸¸¿ø ¼ö»ó±Ý
  • Microsoft Excel (xlsm)Microsoft Excel (xlsm)
ȸºñÇÁ·Î±×·¥È¸ºñ°ü¸®´ç±¸µ¿È£È¸´ç±¸µ¿È£È¸°ü¸®
¿¬°ü ÃßõÀÚ·á
 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #1 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #2 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #3
 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #4 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #5 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #6
 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #7 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #8 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #9
 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #10 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #11 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #12
 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #13 ´ç±¸ µ¿È£È¸ ȸºñ°ü¸® ÇÁ·Î±×·¥ #14

Àüü 41 page Áß 14 page±îÁö ¹Ì¸®º¸±â°¡ °¡´ÉÇÕ´Ï´Ù.

1Àå ÃʱâÈ­¸é

2Àå ȸ¿øº° ¿ùº° ȸºñ³³ºÎÇöȲ

3Àå µ¿È£È¸¼öÀÔÁöÃâ³»¿ª

4Àå ¿î¿µÀ§¿øȸ¼öÀÔÁöÃâ³»¿ª

5Àå ¿ùÁßȸ°èº¸°í¼­

6Àå ÇùÂù±Ý³»¿ª

7Àå ±Ã±ÝÇØ¿ä

8Àå ȸ¿øÁÖ¼Ò·Ï

9Àå ȸ¿øÀüÈ­¹øÈ£ºÎ

10Àå ȸºñ³³ºÎÇöȲ°ø°³¿ë

11Àå °¨»çº¸°í¼­

12Àå ¿¹»ê¼­

13Àå Ãß°¡°æÁ¤¿¹»ê

14Àå °á»ê¼­

15Àå °á»êº¸°í¼­

16Àå ȸ¿øµî·Ï½Åû¼­

17Àå ij·Òȸ¿øµî±ÞÇ¥

18Àå Å»Åðȸ¿øÁ¤º¸

file:[content types].xml  file: rels/.rels  file:xl/ rels/workbook.xml.rels  file:xl/workbook.xml  °¨»çº¸°í¼­!$b$4:$e$27  °á»êº¸°í¼­!$b$4:$bd$68  ±Ã±ÝÇØ¿ä!$b$2:$am$85  µ¿È£È¸¼öÀÔÁöÃâ³»¿ª!$b$2:$i$17  ¿¹»ê¼­!$b$3:$g$42  ¿î¿µÀ§¿øȸ¼öÀÔÁöÃâ³»¿ª!$b$2:$i$30  ¿ùÁßȸ°èº¸°í¼­!$b$2:$e$69  Ãß°¡°æÁ¤¿¹»ê!$b$3:$g$42  Ä³·Òȸ¿øµî±ÞÇ¥!$h$1:$r$18  Å»Åðȸ¿øÁ¤º¸!$b$1:$j$8  ÇùÂù±Ý³»¿ª!$b$2:$d$64  È¸ºñ³³ºÎÇöȲ°ø°³¿ë!$b$2:$q$93  È¸¿øµî·Ï½Åû¼­!$b$2:$k$27  È¸¿øº° ¿ùº° ȸºñ³³ºÎÇöȲ!$b$2:$t$96  
ȸ¿øÀüÈ­¹øÈ£ºÎ!#ref!
ȸ¿øÁÖ¼Ò·Ï!$b$2:$j$84  ±Ã±ÝÇØ¿ä!$2:$2  µ¿È£È¸¼öÀÔÁöÃâ³»¿ª!$2:$5  ¿î¿µÀ§¿øȸ¼öÀÔÁöÃâ³»¿ª!$2:$5  Ãß°¡°æÁ¤¿¹»ê!$3:$3  ÇùÂù±Ý³»¿ª!$2:$5  È¸ºñ³³ºÎÇöȲ°ø°³¿ë!$2:$6  È¸¿øº° ¿ùº° ȸºñ³³ºÎÇöȲ!$2:$6  È¸¿øÁÖ¼Ò·Ï!$2:$4  ÂüÁ¶!$a$2:$a$10  ¿ùÁßȸ°èº¸°í¼­!$c$12  ¿ùÁßȸ°èº¸°í¼­!$d$12  µ¿È£È¸¼öÀÔÁöÃâ³»¿ª!$o$5  ¿ùÁßȸ°èº¸°í¼­!$e$11  µ¿È£È¸¼öÀÔÁöÃâ³»¿ª!$aa$5  µ¿È£È¸¼öÀÔÁöÃâ³»¿ª!$x$5  #n/a  #n/a  #n/a  ÂüÁ¶!$g$2:$g$20  È¸¿øº° ¿ùº° ȸºñ³³ºÎÇöȲ!$y$4  Ãß°¡°æÁ¤¿¹»ê!$c$1  ÂüÁ¶!$b$2:$b$12  ¿ùÁßȸ°èº¸°í¼­!$c$43  ¿ùÁßȸ°èº¸°í¼­!$d$43  ¿î¿µÀ§¿øȸ¼öÀÔÁöÃâ³»¿ª!$p$5  ¿ùÁßȸ°èº¸°í¼­!$e$42  ¿î¿µÀ§¿øȸ¼öÀÔÁöÃâ³»¿ª!$ac$5  ¿î¿µÀ§¿øȸ¼öÀÔÁöÃâ³»¿ª!$z$5  È¸¿øº° ¿ùº° ȸºñ³³ºÎÇöȲ!$aa$4  µ¿È£È¸¼öÀÔÁöÃâ³»¿ª!$l$5  È¸¿øÀüÈ­¹øÈ£ºÎ!$d$1  È¸¿øº° ¿ùº° ȸºñ³³ºÎÇöȲ!$w$4  ÇùÂù±Ý³»¿ª!$c$61  ÇùÂù±Ý³»¿ª!$b$61  È¸¿øº° ¿ùº° ȸºñ³³ºÎÇöȲ!$ab$4  µ¿È£È¸¼öÀÔÁöÃâ³»¿ª!$m$5  
file:xl/worksheets/sheet4.xml
85  75  84  76  77  74  83  65  86  93  193  87  61  80  88  89  90  122  226  92  61  80  k$5/¿î¿µÀ§¼öÀÔÇÕ°è 1  
0.xxxx.xx.xxxxxx.xx.xx
l$5/¿î¿µÀ§¼öÀÔÇÕ°è 1  0  m$5/¿î¿µÀ§¼öÀÔÇÕ°è 1  
0.xxxx.xx.xxxxxx.xx.xx
n$5/¿î¿µÀ§¼öÀÔÇÕ°è 1  0  o$5/¿î¿µÀ§¼öÀÔÇÕ°è 1  
8.0248215234950463e-5
sum(k4:o4)  1  t$5/¿î¿µÀ§ÁöÃâÇÕ°è 2  
0.10632811793914841
0  0  
0.25858998282800894
9.5695306145233583e-2
0.53938659308760906
sum(t4:y4)  1  69  70  71  72  73  74  6  sumif(Ç¥4[±¸ºÐ],$k$3,Ç¥4[¼öÀÔ])  5943947  sumif(Ç¥4[±¸ºÐ],$l$3,Ç¥4[¼öÀÔ])  0  sumif(Ç¥4[±¸ºÐ],$m$3,Ç¥4[¼öÀÔ])  984   sumif(Ç¥4[±¸ºÐ],$n$3,Ç¥4[¼öÀÔ])  0  sumif(Ç¥4[±¸ºÐ],$o$3,Ç¥4[¼öÀÔ])  556  sum(k5:o5)  6928503  sumif(Ç¥4[±¸ºÐ],$t$3,Ç¥4[ÁöÃâ])  2 00  sumif(Ç¥4[±¸ºÐ],$u$3,Ç¥4[ÁöÃâ])  0  sumif(Ç¥4[±¸ºÐ],$v$3,Ç¥4[ÁöÃâ])  0  sumif(Ç¥4[±¸ºÐ],$w$3,Ç¥4[ÁöÃâ])  486400  sumif(Ç¥4[±¸ºÐ],$x$3,Ç¥4[ÁöÃâ])  18 0  sumif(Ç¥4[±¸ºÐ],$y$3,Ç¥4[ÁöÃâ])  1014570  sum(t5:y5)  1880970  p5-z5  5047533  43831  65  130  5943947  if(or($g5Àܾ×,$d6),$e6-$f6,$g5$e6-$f6)  5943947  1  
sumproduct((month(Ç¥4[ÀÏÀÚ]) $j6) * (Ç¥4[±¸ºÐ] $k$3), Ç¥4[¼öÀÔ])
5943947  
sumproduct((month(Ç¥4[ÀÏÀÚ]) $j6) * (Ç¥4[±¸ºÐ] $l$3), Ç¥4[¼öÀÔ])
0  
sumproduct((month(Ç¥4[ÀÏÀÚ]) $j6) * (Ç¥4[±¸ºÐ] $m$3), Ç¥4[¼öÀÔ])
458   
sumproduct((month(Ç¥4[ÀÏÀÚ]) $j6) * (Ç¥4[±¸ºÐ] $n$3), Ç¥4[¼öÀÔ])
0  
sumproduct((month(Ç¥4[ÀÏÀÚ]) $j6) * (Ç¥4[±¸ºÐ] $o$3), Ç¥4[¼öÀÔ])
0  sum(k6:o6)  6401947  
if(and($k60,$l60,$m60,$n60,$o60),0,sum($p$6:$p6))
6401947  1  
sumproduct((month(Ç¥4[ÀÏÀÚ]) $j6) * (Ç¥4[±¸ºÐ] $t$3), Ç¥4[ÁöÃâ])   (ÀÌÇÏ »ý·«)

¹ÞÀº º°Á¡

4.0/5

6°³ÀÇ º°Á¡

¹®¼­°øÀ¯ ÀڷḦ µî·ÏÇØ ÁÖ¼¼¿ä.
¹®¼­°øÀ¯ Æ÷ÀÎÆ®¿Í Çö±ÝÀ» µå¸³´Ï´Ù.

Æ÷ÀÎÆ® : ÀÚ·á 1°Ç´ç ÃÖ´ë 5,000P Áö±Þ

Çö±Ý : ÀÚ·á 1°Ç´ç ÃÖ´ë 2,000¿ø Áö±Þ

ÈıâÀÛ¼º»ç¿ëÈı⸦ ÀÛ¼ºÇÏ½Ã¸é ¹®¼­°øÀ¯ 100 point¸¦ Àû¸³ÇØ µå¸³´Ï´Ù.

¼­½Äº°Á¡ ¡Ù¡Ù¡Ù¡Ù¡Ù

0/120

»ç¿ëÈıâ (6)

  • 2021-03-23gj**

    ÀÚ·á °øÀ¯ÇÏ¿© ÁֽÿÀ´Ï °¨»ç¸¦ µå¸³´Ï´Ù.

  • 2020-11-06aa***

    µ¿È£È¸ ȸºñ °ü¸®·Î Âü°íÀÚ·á·Î È°¿ëÇÏ°Ú½À´Ï´Ù.

  • 2020-10-29ks

    Âü°í·Î º¼ ¼ö ÀÖ´Â ÁÁÀº ÀÚ·áÀÔ´Ï´Ù.

  • 2020-09-28lg**

    ÁÁÀº ÀÚ·áÀÔ´Ï´Ù. Àß È°¿ëÇÏ°Ú½À´Ï´Ù.

  • 2020-09-11fo********

    ÁÁÀº ÀÚ·á °¨»çÇÕ´Ï´Ù. À¯¿ëÇÏ°Ô È°¿ëÇϵµ·Ï ÇÏ°Ú½À´Ï´Ù.

ÀÌÀü12´ÙÀ½