²é¿´: 2626  |  »Ø¸´: 8
±¾Ìû²úÉú 1 ¸ö ²©Ñ§EPI £¬µã»÷ÕâÀï½øÐв鿴

angelsally

ľ³æ (ÕýʽдÊÖ)

[ÇóÖú] ÈçºÎ´ÓÒ»´óÁÐÊý¾ÝÖйæÂÉÐÔɸѡ³öÊý¾Ý

Ò»ÁÐÊý¾Ý£¬ÎÒÏëÌô³öÁÐΪ
1¡¢5¡¢10¡¢15¡¢20¡¢25¡¢30¡¢35¡¢40ÁеÄÊý¾ÝÖØÐÂ×é³ÉÒ»ÁÐÊý¾Ý
»òÕß
Ìô³ö10¡¢20¡¢30¡¢40¡¢50¡¢60¡¢70ÁжÔÓ¦µÄÊý¾ÝÖØÐÂ×é³ÉÒ»¸öеÄÁÐ
Òª²»Êý¾ÝÌ«¶à£¬»­Í¼µÄʱºòºÚºõºõµÄһƬ£¬¿´²»³öЧ¹û
ÆÚ´ý³æÓѵİïæ¡£Ð»Ð»Å¶~~~~
£¨Êý¾ÝÁ¿Ì«´ó£¬²»Ò×È˹¤²Ù×÷£¬Ï£ÍûÓиö¹«Ê½Ê²Ã´µÄ£¬µ«ÊÇÎÒÍü¼ÇÁË£©
Ч¹ûÈçÏÂͼËùʾ
Ï£ÍûÓɵڶþÁÐÿ¸ô2¸öÊý¾ÝÌø³öÒ»¸ö£¬×îºóÌô³öµÚÈýÁеÄÊý¾Ý

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

ÊÔ×ÅÈÃÉú»î±äµÃ¼òµ¥£¬¶ÔÐÒ¸£»ò¼Åį˳Æä×ÔÈ»£¡£¡
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
»ØÌûÖö¥ ( ¹²ÓÐ1¸ö )

xinmor

ÖÁ×ðľ³æ (Ö°Òµ×÷¼Ò)

ÓÅÐã°æÖ÷

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï ¡ï ¡ï
angelsally: ½ð±Ò+3, ²©Ñ§EPI+1, ¡ï¡ï¡ïºÜÓаïÖú, Äú˵µÄÌ«¼ò½àÁËÎÒû¿´¶à¶®£¬ÄÜ·ñ¸ø³ö¾ßÌåµÄ²Ù×÷Á÷³Ì£¿ÆÚ´ýÄúµÄ»Ø´ð 2012-03-25 15:13:13
ÔÚoriginÖкÜÈÝÒ×ʵÏÖ£¬
extract worksheet data
where formula is:
mod(i, 4) == 0
Ò»Çж÷°®»á,ÎÞ³£ÄѵþÃ.ÉúÊÀ¶àη¾å,ÃüΣÓÚ³¿Â¶¡£
2Â¥2012-03-22 09:38:24
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
ÆÕͨ»ØÌû

qiaoyingchao

Ìú¸Ëľ³æ (ÕýʽдÊÖ)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï ¡ï
angelsally: ½ð±Ò+2, ¡ïÓаïÖú, лл~ 2012-03-25 15:14:18
×îС¿Ì¶ÈÉèµÄСһµã£¬¾Í²»»á³öÏÖºÚºõºõһƬÁË¡£µÚ3ÁУ¨¼ÙÉèÊý¾ÝÔÚexcelÀC1=A1,C2=A4,C3=A7,Ñ¡ÖÐC1C2C3£¬×Ô¶¯Ìî³ä£¨Êó±ê·ÅÔÚÓÒϽǣ¬±äΪºÚɫʮ×Öʱ£©£¬ÍùÏÂÀ­£¬OK£¬ÔÙ¶àµÄÊý¾Ý¶¼Ã»ÎÊÌ⣬¼¸Ãë¸ã¶¨
3Â¥2012-03-22 10:44:02
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

qiaoyingchao

Ìú¸Ëľ³æ (ÕýʽдÊÖ)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï ¡ï
angelsally: ½ð±Ò+2, ¡ïÓаïÖú 2012-03-25 15:22:08
ÒýÓûØÌû:
3Â¥: Originally posted by qiaoyingchao at 2012-03-22 10:44:02:
×îС¿Ì¶ÈÉèµÄСһµã£¬¾Í²»»á³öÏÖºÚºõºõһƬÁË¡£µÚ3ÁУ¨¼ÙÉèÊý¾ÝÔÚexcelÀC1=A1,C2=A4,C3=A7,Ñ¡ÖÐC1C2C3£¬×Ô¶¯Ìî³ä£¨Êó±ê·ÅÔÚÓÒϽǣ¬±äΪºÚɫʮ×Öʱ£©£¬ÍùÏÂÀ­£¬OK£¬ÔÙ¶àµÄÊý¾Ý¶¼Ã»ÎÊÌ⣬¼¸Ãë¸ã¶¨

¿´´íÁË£¬ËùÓеÄC¶¼¸ÄΪB
4Â¥2012-03-22 10:45:05
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

angelsally

ľ³æ (ÕýʽдÊÖ)

ÒýÓûØÌû:
3Â¥: Originally posted by qiaoyingchao at 2012-03-22 10:44:02:
×îС¿Ì¶ÈÉèµÄСһµã£¬¾Í²»»á³öÏÖºÚºõºõһƬÁË¡£µÚ3ÁУ¨¼ÙÉèÊý¾ÝÔÚexcelÀC1=A1,C2=A4,C3=A7,Ñ¡ÖÐC1C2C3£¬×Ô¶¯Ìî³ä£¨Êó±ê·ÅÔÚÓÒϽǣ¬±äΪºÚɫʮ×Öʱ£©£¬ÍùÏÂÀ­£¬OK£¬ÔÙ¶àµÄÊý¾Ý¶¼Ã»ÎÊÌ⣬¼¸Ãë¸ã¶¨

ÊÔ¹ýÁË£¬µ«ÊÇÎÒûÓеõ½Ô¤ÏëµÄ½á¹û£¬ÎÒÓÐA¡¢BÁ½ÁÐÊý£¬Ã»ÓйæÂÉ£¬È»ºóÔÚC1´¦ÊäÈë=B1£¬C2´¦ÊäÈë=B4£¬C3´¦ÊäÈë=B7£¬ÔÙÑ¡ÖÐC1µ½C3£¬ÔÙÍùÏÂÀ­£¬½á¹ûÊÇ¿´µ½C4´¦ÊÇB4µÄÖµ£¬C5´¦ÊÇB7µÄÖµ£¬¡£¡£¡£¡££¿£¿Ôõô»ØÊÂÄØ
ÊÔ×ÅÈÃÉú»î±äµÃ¼òµ¥£¬¶ÔÐÒ¸£»ò¼Åį˳Æä×ÔÈ»£¡£¡
5Â¥2012-03-25 15:21:49
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

angelsally

ľ³æ (ÕýʽдÊÖ)

ÒýÓûØÌû:
2Â¥: Originally posted by xinmor at 2012-03-22 09:38:24:
ÔÚoriginÖкÜÈÝÒ×ʵÏÖ£¬
extract worksheet data
where formula is:
mod(i, 4) == 0

ÄúºÃ£¬ºÜ¸ÐлÄúµÄÈÈÐİïÖúŶ£¬ÄÜ·ñºÃÊÂ×öµ½µ×£¬°Ñ¾ßÌå¹ý³ÌÌùһϣ¬±ÈÈç´ò¿ªoriginºóÏÂÒ»²½ÊÇÔõô²Ù×÷£¬´ÓÄĶùÕÒµ½extract worksheet data£¬ÏÂÃæÄǸö¹«Ê½mod(i, 4) == 0ÊäÈ뵽ʲôµØ·½£¬ÎÒ¸Õѧorigin£¬ºÃ¶àÕÒ²»µ½£¬ÆÚ´ýÄúµÄ»ØÐÅ~~
ÊÔ×ÅÈÃÉú»î±äµÃ¼òµ¥£¬¶ÔÐÒ¸£»ò¼Åį˳Æä×ÔÈ»£¡£¡
6Â¥2012-03-25 15:25:06
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

xinmor

ÖÁ×ðľ³æ (Ö°Òµ×÷¼Ò)

ÓÅÐã°æÖ÷

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

ÒýÓûØÌû:
2Â¥: Originally posted by xinmor at 2012-03-22 09:38:24:
ÔÚoriginÖкÜÈÝÒ×ʵÏÖ£¬
extract worksheet data
where formula is:
mod(i, 4) == 0

µãanalysis
µãextract worksheet data
ÊäÈëmod(i, 4) == 0
µã»÷doit
ok
Ò»Çж÷°®»á,ÎÞ³£ÄѵþÃ.ÉúÊÀ¶àη¾å,ÃüΣÓÚ³¿Â¶¡£
7Â¥2012-03-25 18:07:55
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

qiaoyingchao

Ìú¸Ëľ³æ (ÕýʽдÊÖ)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï
angelsally: ½ð±Ò+1, ¡ïÓаïÖú, ºÇºÇ£¬¶àЩ½»Á÷£¬Ð»Ð»Å¶ 2012-03-29 21:15:52
ÒýÓûØÌû:
5Â¥: Originally posted by angelsally at 2012-03-25 15:21:49:
ÊÔ¹ýÁË£¬µ«ÊÇÎÒûÓеõ½Ô¤ÏëµÄ½á¹û£¬ÎÒÓÐA¡¢BÁ½ÁÐÊý£¬Ã»ÓйæÂÉ£¬È»ºóÔÚC1´¦ÊäÈë=B1£¬C2´¦ÊäÈë=B4£¬C3´¦ÊäÈë=B7£¬ÔÙÑ¡ÖÐC1µ½C3£¬ÔÙÍùÏÂÀ­£¬½á¹ûÊÇ¿´µ½C4´¦ÊÇB4µÄÖµ£¬C5´¦ÊÇB7µÄÖµ£¬¡£¡£¡£¡££¿£¿Ôõô»ØÊÂÄØ

ÎÒÊÔÁ˹ûÈ»²»ÐУ¬excelÊÇ¿ÉÒԵģ¬Ö»ÊÇÎÒ»¹²»»á¡£
LSµÄ·½·¨Õý½â£¬Ö»ÊÇÊäÈëʱҪ×Ô¼º¶¯ÊÖÇýøÈ¥£¬Ö±½Ócopy½øÈ¥×Ö·ûÖ®¼ä¶àÁ˼¸¸ö¿Õ¸ñ£¬²»ÄÜÔËÐÐ
8Â¥2012-03-25 21:13:11
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

xinmor

ÖÁ×ðľ³æ (Ö°Òµ×÷¼Ò)

ÓÅÐã°æÖ÷

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï
angelsally: ½ð±Ò+1, ¡ïÓаïÖú, ¶àЩ½»Á÷£¬Ð»Ð»Å¶~~ 2012-03-29 21:16:06
ÒýÓûØÌû:
8Â¥: Originally posted by qiaoyingchao at 2012-03-25 21:13:11:
ÎÒÊÔÁ˹ûÈ»²»ÐУ¬excelÊÇ¿ÉÒԵģ¬Ö»ÊÇÎÒ»¹²»»á¡£
LSµÄ·½·¨Õý½â£¬Ö»ÊÇÊäÈëʱҪ×Ô¼º¶¯ÊÖÇýøÈ¥£¬Ö±½Ócopy½øÈ¥×Ö·ûÖ®¼ä¶àÁ˼¸¸ö¿Õ¸ñ£¬²»ÄÜÔËÐÐ

ßí£¬¿ÉÄÜÊǸ´ÖƹýÀ´¸ñʽ·¢ÉúÁ˱仯£¬ÎÒÕâÀïûÓÐÎÊÌâ¡£
Ò»Çж÷°®»á,ÎÞ³£ÄѵþÃ.ÉúÊÀ¶àη¾å,ÃüΣÓÚ³¿Â¶¡£
9Â¥2012-03-26 16:11:32
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ angelsally µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] ¸´ÊÔµ÷¼Á +4 z1z2z3879 2026-03-14 6/300 2026-03-19 17:18 by fei626-918
[¿¼ÑÐ] ÄÜÔ´²ÄÁÏ»¯Ñ§¿ÎÌâ×éÕÐÊÕ˶ʿÑо¿Éú8-10Ãû +4 ÍÑÓ±¶ø³ö 2026-03-16 12/600 2026-03-19 16:17 by ÍÑÓ±¶ø³ö
[¿¼ÑÐ] 271²ÄÁϹ¤³ÌÇóµ÷¼Á +6 .6lL 2026-03-18 6/300 2026-03-19 15:41 by haoshis
[¿¼ÑÐ] 266Çóµ÷¼Á +5 ÑôÑôÍÛÈû 2026-03-14 10/500 2026-03-19 15:08 by ÑôÑôÍÛÈû
[¿¼ÑÐ] ±¾ÈË¿¼085602 »¯Ñ§¹¤³Ì ר˶ +17 ²»ÖªµÀ½Ðʲô£¡ 2026-03-15 19/950 2026-03-19 15:06 by ¾¡Ë´Ò¢1
[¿¼ÑÐ] 085600²ÄÁÏÓ뻯¹¤µ÷¼Á 324·Ö +10 llllkkkhh 2026-03-18 12/600 2026-03-19 14:33 by llllkkkhh
[¿¼ÑÐ] »¯Ñ§Çóµ÷¼Á +3 ÁÙÔó¾³llllll 2026-03-17 4/200 2026-03-19 13:59 by houyaoxu
[¿¼ÑÐ] ²ÄÁÏ080500µ÷¼ÁÇóÊÕÁô +4 Ò»¿Åmeteor 2026-03-13 4/200 2026-03-19 10:32 by 30660438
[¿¼ÑÐ] 085601ר˶£¬×Ü·Ö342Çóµ÷¼Á£¬µØÇø²»ÏÞ +5 share_joy 2026-03-16 5/250 2026-03-18 14:48 by haxia
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤Ò»Ö¾Ô¸Äϲý´óѧ327Çóµ÷¼ÁÍÆ¼ö +8 Ncdx123456 2026-03-13 9/450 2026-03-18 14:40 by haxia
[¿¼ÑÐ] 311Çóµ÷¼Á +11 ¶¬Ê®Èý 2026-03-15 12/600 2026-03-18 14:36 by ÐÇ¿ÕÐÇÔÂ
[¿¼ÑÐ] ÉúÎïѧ071000 329·ÖÇóµ÷¼Á +3 ÎÒ°®ÉúÎïÉúÎﰮΠ2026-03-17 3/150 2026-03-18 10:12 by macy2011
[¿¼ÑÐ] 278Çóµ÷¼Á +5 ÑÌ»ðÏÈÓÚ´º 2026-03-17 5/250 2026-03-18 08:43 by ÐÇ¿ÕÐÇÔÂ
[¿¼²©] 26²©Ê¿ÉêÇë +3 1042136743 2026-03-17 3/150 2026-03-17 23:30 by ÇáËɲ»ÉÙËæ
[¿¼ÑÐ] 268Çóµ÷¼Á +8 Ò»¶¨ÓÐѧÉÏ- 2026-03-14 9/450 2026-03-17 17:47 by laoshidan
[¿¼ÑÐ] ¿¼Ñл¯Ñ§Ñ§Ë¶µ÷¼Á£¬Ò»Ö¾Ô¸985 +4 ÕÅvvvv 2026-03-15 6/300 2026-03-17 17:15 by ruiyingmiao
[»ù½ðÉêÇë] ½ñÄêµÄ¹ú»ù½ðÊÇ´ò·ÖÖÆÂ𣿠50+3 zhanghaozhu 2026-03-14 3/150 2026-03-16 17:07 by ±±¾©À³ÒðÈóÉ«
[¿¼ÑÐ] ÖпÆÔº²ÄÁÏ273Çóµ÷¼Á +4 yzydy 2026-03-15 4/200 2026-03-16 15:59 by Gaodh_82
[¿¼ÑÐ] ¸´ÊÔµ÷¼Á +3 ºôºô£¿~+123456 2026-03-14 3/150 2026-03-14 16:53 by WTUChen
[¿¼ÑÐ] 304Çóµ÷¼Á +7 7712b 2026-03-13 7/350 2026-03-13 21:42 by peike
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û