- ©«¤l
- 129
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 178
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-12-28
- ³Ì«áµn¿ý
- 2018-11-10
|
¥»©«³Ì«á¥Ñ softsadwind ©ó 2014-5-22 13:42 ½s¿è
¦^´_ 1# ³Á¤p·ì
F2=IF(AND(WEEKDAY(A2,2)>5,E2<8),8,E2)
§PÂ_¨º¤Ñ¬O§_¬°¤»¤é¡C¦pªG¬O¡A´Nºâ¤W¯Z¤£¨¬8¤p®É¡A¤]¬O¥Î8¤p®Épºâ¡A¶W¹L¥Î¤@¯ë¥[¯Z¤è¦¡pºâ¡H¡H¡H
G2=IF(F2>8,E2-8,0)
§PÂ_F2¦³¨S¦³¤j©ó8¤p®É¡A¦pªG¦³¡AF2-8´N¬O¥[¯Z®É¼Æ¡C
H2=IF(G2>5,2*(G2-5)+1.66*3+1.33*2,IF(G2>2,1.66*(G2-2)+1.33*2,1.33*G2))
©ÎªÌ
H2=LOOKUP(G2,{0.5,1,1.5,2,2.5,3,3.5,4,4.5,5,5.5,6,6.5,7,7.5,8},{0.67,1.33,2,2.66,3.49,4.32,5.15,5.98,6.81,7.64,8.64,9.64,10.64,11.64,12.64,13.64})
®Ú¾ÚG2¥hÂà´«¥[¯Z®É¼Æ¡K.
OS...¨S¦³ excel ½d¨Òªº°ÝÃD«Ü®e©ö³Q¦Û°Ê©¿µø¡C |
|