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

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

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

½Ð±Ð¦U¦ì¤j¤j , ¥Ñ©ó¤p§Ì¥¿¦b°µ¼ÒÀÀ¬ã¨s¹J¨ì¤F¥H¤Uªº°ÝÃD , ½Ð¦U¦ì¤j¤jÀ°¦£«ü¾ÉVBA¸Ó¦p¦ó½s¼g©O ? ·P®¦ .

·Q­n±NProject1  Demandªº©T©w­ÈÀH¾÷¤À°t¨ì10­ÓSKU¤¤.

¿Ã¹õ§Ö·Ó 2018-08-26 ¤U¤È4.51.52.png
2018-8-26 16:53
¤p¤B

¦^´_ 2# n7822123

¤F¸Ñ¤F. ¤U¦¸§Ú·|ª`·Nªº , ¬O¦X­nµ¥©ó­ì¨Óªº111.
¤p¤B

TOP

hcm19522 µoªí©ó 2018-8-26 17:43


ÁÂÁÂhcm¤j¤jªºÀ°¦£.
¤p¤B

TOP

¦^´_  PaulDing


­è­èµo²{§AªºS.N. ¦bBÄæ¡A­×§ï¤@¤Uµ{¦¡½X
¦pªG­n¥Î¨ç¼Æ°µªº¸Ü °Ñ¦Ò hcm19522 ¤j¤j§Y ...
n7822123 µoªí©ó 2018-8-26 18:22


ÁÂÁÂn¤jªºÀ°¦£
¤p¤B

TOP

¦^´_  PaulDing


­è­èµo²{§AªºS.N. ¦bBÄæ¡A­×§ï¤@¤Uµ{¦¡½X
¦pªG­n¥Î¨ç¼Æ°µªº¸Ü °Ñ¦Ò hcm19522 ¤j¤j§Y ...
n7822123 µoªí©ó 2018-8-26 18:22


n¤j , ¦A»P±z½Ð¸û¤@¤U"¶Ã¼Æ¤ñ¨Ò½d³ò = 0.3"«üªº¬O¤°»ò·N«ä©O? ·P®¦.
¤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 , §Ú¤Ó¨Øª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

¦^´_  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®¦.

random allocate-1.png
2018-8-31 10:41


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

¦^´_  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

¦^´_  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

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD