ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ±N¤@©T©w­ÈÀH¾÷¤À°t¨ì«ü©wÄæ¦ì

¦^´_  PaulDing

¥u¬O¤@­ÓÅܼƭÈ=0.3¡A¼Æ¦r¶V¤j¡A¤À°tªº¶V¤£¥­§¡

¥H¥­§¡­È·í¤¤­È¡A¦b­¼¥H¤@­Ó¤ñ¨Ò¨t ...
n7822123 µoªí©ó 2018-8-29 00:13


n¤j , §Ú¤Ó¨ØªA±z¤F , ³s³o¤@ÂI³£¦³·Q¨ì , ·P¿E«D±`. (ÆgÆgÆgÆgÆgÆgÆg)
¤p¤B

TOP

¦^´_  PaulDing

¥u¬O¤@­ÓÅܼƭÈ=0.3¡A¼Æ¦r¶V¤j¡A¤À°tªº¶V¤£¥­§¡

¥H¥­§¡­È·í¤¤­È¡A¦b­¼¥H¤@­Ó¤ñ¨Ò¨t ...
n7822123 µoªí©ó 2018-8-29 00:13


n¤j , ¤£¦n·N«ä¦A½Ð±Ð¤@¤U , ­Y¬O­nÅý¦Ê¤À¤ñ¤]¶i¦æÀH¾÷¤À°tªº¸Ü§Ú¸Ó½Õ¾ã­þ­Ó¦a¤è©O?
¤p¤B

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2018-8-31 03:02 ½s¿è

¦^´_ 12# PaulDing

§â²Ä¤@¦æ§ï¬°:¶Ã¼Æ¤ñ¨Ò½d³ò = rnd

¸ÑÄÀ:rnd=0~1

TOP

¦^´_  PaulDing

§â²Ä¤@¦æ§ï¬°:¶Ã¼Æ¤ñ¨Ò½d³ò = rnd

¸ÑÄÀ:rnd=0~1
n7822123 µoªí©ó 2018-8-31 03:00


n¤j , §Ú­×§ï¤F«á¤À°t³£¨ìSKU10¥h¤F , ¬O§_§ÚÁÙ¦³­þ¸Ì¨S¦³­×§ï¦n©O? ·P®¦.



Sub Project1SFSKU1toSKU10_Click()
¶Ã¼Æ¤ñ¨Ò½d³ò = Rnd
RN = Sheets(14).UsedRange.Rows.Count
ReDim Sum(RN - 1)
For r = 1 To RN - 1
  Sum(r) = Cells(r + 2, 2)
  ave = Sum(r) / 10
  For C = 1 To 9
    Cells(r + 2, C + 2) = Fix(((Rnd * 2) - 1) * (ave * ¶Ã¼Æ¤ñ¨Ò½d³ò) + ave)
  Next C
  Cells(r + 2, 12) = "=sum(RC[-9]:RC[-1])"
  Cells(r + 2, 12) = Sum(r) - Cells(r + 2, 12)
Next r
End Sub
¤p¤B

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2018-9-1 00:34 ½s¿è

¦^´_ 14# PaulDing

¦]¬°³Q¨ú¾ã¼Æ¤F...............

§Ú¨S·Q¨ì§Aªº¤À°t­ÈÁÙ·|¦³¤p©ó1ªº®É­Ô.........

§â¥H¤U¬õ¦â¦rªº³¡¤À§R°£§Y¥i(Fix ·|µL±ø¥ó±Ë¥h¤p¼ÆÂI¡Aex:Fix(0.53)=0)

Cells(R + 1, C + 3) = Fix(((Rnd * 2) - 1) * (ave * ¶Ã¼Æ¤ñ¨Ò½d³ò) + ave)

TOP

¦^´_  PaulDing

¦]¬°³Q¨ú¾ã¼Æ¤F...............

§Ú¨S·Q¨ì§Aªº¤À°t­ÈÁÙ·|¦³¤p©ó1ªº®É­Ô.........

...
n7822123 µoªí©ó 2018-9-1 00:32


n¤j , ·P®¦. ½Ð±Ð¤@¤U¦]§Úrun¤F365 daysµo²{SKU1~SKU9«Ü¥­§¡(SKU10¸û¤j) , ­n«ç»ò¼Ë½Õ¾ã¤~¯à°÷¤£¥­§¡©O?·P®¦.
¤p¤B

TOP

¦^´_ 16# PaulDing


¶Ã¼Æ¤ñ¨Ò½d³ò = 1

³o¼ËÀ³¸Ó´N«Ü¤£¥­§¡¤F!

¦pªG§A¤¹³\¥X²{­t­È¡A¤j©ó1¤]¬O¥i¥Hªº

TOP

¦^´_  PaulDing


¶Ã¼Æ¤ñ¨Ò½d³ò = 1

³o¼ËÀ³¸Ó´N«Ü¤£¥­§¡¤F!

¦pªG§A¤¹³\¥X²{­t­È¡A¤j©ó1¤]¬O¥i¥Hªº ...
n7822123 µoªí©ó 2018-9-2 01:09


·PÁÂn¤j , ½Õ¾ã¸Õ¶]«á¥i¯à¯uªº­n½Õ¾ã¤j©ó¤@¤è¯à°÷¸û¬°ÅãµÛªº®t²§ , ¬O§_¦³¤è¦¡¥i¥H±N­t­È¦AÀH¾÷±q¤¤¤À°t¦©°£©O? ¦¹À³¸Ó·|­n¦A¦h¶]¤@°é¹ï§a?
¤p¤B

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2018-9-3 00:51 ½s¿è

¦^´_ 18# PaulDing


§A¥i¯à­n«ä¦Ò¤@¤U§Aªº±ø¥ó¦X¤£¦XÅÞ¿è¡A

10­Ó¶Ã¼Æªº¦X­n¬O¤@­Ó©w­È¡A§A­n¶Ã¼Æ½d³ò¤j©ó1¡A¤S¤£·Q­n­t­È¡A³o¥»¨­ÅÞ¿è´N«Ü¤£¦X²z¤F!

Á|¨Ò¨Ó»¡¡A10­Ó¶Ã¼Æ©M³Q­­¨î©M¬°200 ¡A¥­§¡¤@­Ó¶Ã¼Æ­È=20

¦pªG§A§â¶Ã¼Æ¤ñ¨Ò½d³ò³]©w=2 ¡Aªí¥Ü¶Ã¼Æ¥i¯à 20+/-40=-20~60

¦Ó¨ä¤¤-20~0ªº³¡¤À§A¤S­n­«¶]¡A­n¨D³Ì«á¶]¥X¨Ó¤@©w­n¥¿­È¡A©ÎªÌµ¥©ó0

°²³]§A«e5µ§¶]¥X¨Óµ¥©ó 40,55,30,28,38 ¥ú³o¨Ç¥[°_¨Ó´N191¡A¤]´N¬O»¡«á­±5µ§¥i¯à¥[°_¨Ó¥u¯àµ¥©ó9

¦pªG²Ä6­Ó¶]¥X¨Ó¶W¹L9¡A«á­±4­Ó¤@©w·|¦³­t­È¡A

©Ò¥H²Ä6­Ó¥u¯à¬O9¥H¤U¡A¦Ó«á­±4­Ó¥i¯à³£¬O0

¦pªG§Aª¾¹D§Ú¦A»¡¤°»ò¡A´Nª¾¹D³o¼Ë«D±`¤£¦X²z!!

¦pªG§A¶Ã¼Æ¤ñ¨Ò½d³ò³]§ó¤j=5 ¡A¥i¯à«á­±8­Ó¼Æ¦r³£¬O0¡A¦]¬°­nº¡¨¬§A©M=200 ¤S¤£¯à­t­Èªº±ø¥ó!

¶V¦h¼Æ¦r¬O0¹ï§A¨Ó»¡¬O¶V¤£¥­§¡¶Ü?

¦pªG¬O¦p¦¹¡A¨º²Ä¤@­Ó¼Æ¦r=©M¡A«á­±¤E­Ó¼Æ¦r³£µ¥©ó0 §Y¥i¡A¤£»Ý­n¶]¶Ã¼Æ¡C

TOP

¦^´_  PaulDing


§A¥i¯à­n«ä¦Ò¤@¤U§Aªº±ø¥ó¦X¤£¦XÅÞ¿è¡A

10­Ó¶Ã¼Æªº¦X­n¬O¤@­Ó©w­È¡A§A­n¶Ã¼Æ½d³ò¤j ...
n7822123 µoªí©ó 2018-9-3 00:46


·PÁÂÀs¤j , ·Q¤F¤@¤U½T¹ê¦p§A©Ò»¡ , §Ú·Q­Y­nÅý¨ä¦A§ó¤£¥­§¡À³¸Ó­n¤â½Õ¤@¤U , ¥t¥~¦A½Ð±Ð¤@¤UÀs¤j¤U­±³o¬q¦¡¤l­n­pºâªº¬O? ·P®¦.

   ((Rnd * 2) - 1) * (ave * ¶Ã¼Æ¤ñ¨Ò½d³ò) + ave)
¤p¤B

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD