' / / * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 
 
 ' / /                                       E x c e l   A d d - I n   X L L :   A c c o u n t i n g   H e l p e r   ( A c c H e l p e r . x l l ) 
 
 ' / / 	 	 	             P h i  n   b n   m i   v 3 . 1 . 0   ( U p d a t e d :   2 2 - M a r - 2 0 1 8 ) 	 	 	         
 
 ' / / 	 	 	 T  c   g i :   N g u y n   D u y   T u  n   -   T e l :   0 9 0 4 . 2 1 0 . 3 3 7 
 
 ' / / 	 	 	 E m a i l :   t u a n k t c d c n @ y a h o o . c o m     H O C   d u y t u a n @ b l u e s o f t s . n e t 
 
 ' / /                                                               C  n g   t y   C   p h n   B L U E S O F T S   -   P h n   m m   v     o   t o   E X C E L   S   1   t i   V i t   N a m 
 
 ' / / 	 	 	 +   P h n   m m   k   t o  n   d o a n h   n h i p   A - E x c e l 
 
 ' / / 	 	 	 +   P h n   m m   q u n   l    k h o   B S   S i l v e r 
 
 ' / /                                                                       W e b s i t e :   h t t p : / / w w w . b l u e s o f t s . n e t 
 
 ' / / = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 
 ' / / 	 	 	                   T  N H   N N G   M I 	 	 	                                   
 
 ' / / = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 
 
 
 ( N e u   n g u o i   d u n g   k h o n g   d o c   d u o c   c h u   t r o n g   f i l e   n a y ,   h a y   v a o   m e n u   F o r m a t - > F o n t . . .   c h o n   t e n   f o n t   " T a h o m a " ) . 
 
 
 
 v 3 . 1 . 0 :   ( 2 2 - M a r - 2 0 1 8 ) 
 
 	 +   N  n g   c p :   c h o   p h  p   c   s   t i n   t i   a   1 6   c h   s 
 
 	 +   N  n g   c p :   q u n   l    b   n h   t t   h n . 
 
 
 
 v 3 . 0 . 0 :   ( 0 5 - J u n e - 2 0 1 7 ) 
 
 	 +   S a :   k h c   p h c   l i   c  i   t   t r  n   m t   s   m  y   c  i   O f f i c e   2 0 1 3 ,   2 0 1 6   b n   6 4 - b i t . 
 
 
 
 v 2 . 2 . 0 :   ( 2 4 - M a y - 2 0 1 3 ) 
 
 	 +   S a :   k h c   p h c   l i   h  m   U S D ,   c   s   l i  n   q u a n   n   s   1 3   l    " a n d t h i r t e e n "   s a   l i   l    " a n d   t h i r t e e n " . 
 
 	 +   S a :   t n g   t h  c h   v i   M i c r o s o f t   E x c e l   2 0 1 3   ( 3 2 - b i t ,   6 4 - b i t ) . 
 
 
 
 v 2 . 1 . 0 :   ( 2 0 - N o v - 2 0 1 1 ) 
 
 	 +   S a   t n g   t h  c h   v i   M i c r o s o f t   E x c e l   2 0 0 0 
 
 	 +   S a   k i m   s o  t   b   n h   t t   h n 
 
 	 +   T h  m   p h i  n   b n   c h y   c h o   M i c r o s o f t   E x c e l   6 4 - b i t   ( W i n s o w s   +   O f f i c e   6 4 - b i t ) 
 
 	 K h i   c  i   a d d - i n   c h o   M i c r o s o f t   E x c e l   6 4 - b i t ,   h  y   c h n   a d d - i n   t i   n g   d n   " x 6 4 \ A c c H e l p e r . x l l " 
 
 
 
 v 2 . 0 . 4 :   ( 1 5 - A u g - 2 0 0 9 ) 
 
 	 +   S a   l i   k h i   t   t  y   c h n   t r o n g   " A c c h e l p e r O p t i o n s . e x e " .   X  a   t r n g   g i    t r ,   h  m   V N D ,   U S D   b   l i   " # V A L U E ! " 
 
 	 +   T h  m   t  y   c h n   t r o n g   " A c c h e l p e r O p t i o n s . e x e " ,   c h o   p h  p   t  y   b i n   t   c h   u   l    H o a   h a y   k h  n g .   N G m   n h   l    c h   u   H o a . 
 
 
 
 v 2 . 0 . 3 :   ( 1 4 - A p r - 2 0 0 9 ) 
 
 	 +   S a   c  c h   c   s   k h  n g     v   t r    u   t i  n   t r o n g   n h  m   s   t h p   p h  n . 
 
 
 
 v 2 . 0 . 2 :   ( 3 0 - M a r - 2 0 0 9 ) 
 
 	 +   T h  m   c  c   b i n   t  y   c h n   v   c  c h   c   c  c   s   0 , 4 , 7 ,   n g  n / n g h  n   t h e o   c  c h   c   c a   c  c   v  n g   m i n .   
 
 	 C  c   t h a m   s   c   t h i t   l p   n g m   n h   t r n g   f i l e   " a c c h e l p e r . i n i " 
 
 	 
 
 	 ; C  c h   c   c  c   t   " c   b i t " 
 
 	 N g a n = n g  n 
 
 	 L i n h = l 
 
 	 B o n = b n 
 
 	 B a y = b y 
 
 	 
 
 	 +   T h  m   t i n    c h   " A c c o u n t i n g   H e l p e r   O p t i o n s "   -   C h o   p h  p   n g i   d  n g   g  n   c  c   g i    t r   t h i t   l p   v  o   f i l e   " a c c h e l p e r . i n i "   m t   c  c h   t r c   q u a n . 
 
 	 C h n g   t r  n h   n  y   p h i   c   t   t r o n g   c  n g   n g   d n   c h a   c  c   f i l e   " a c c h e l p e r . x l l "   v    " a c c h e l p e r . i n i " . 
 
 
 
 v 2 . 0 . 1 :   ( 0 8 - D e c - 2 0 0 8 ) 
 
 
 
 +   S a   l i   c  c   l i   k h i   x  a   g i    t r   c  c   t h a m   s   t r o n g   f i l e   " a c c h e l p e r . i n i " ,   k h i      c  c   h  m   c   s   v n   t   k h o n g   t r n g     c u i   c  u   h o c   c u i   n   v   t i n   t ,   d u   c h m   c  u . 
 
 +   T h  m   2   b i n   t h a m   s   v  o   f i l e   " a c c h e l p e r . i n i " ,   n g i   d  n g   c    t h   t   g i    t r   c h o   t h a m   s     c h o   p h  p   c    c   s   l   t h  n h   c h   h a y   k h  n g . 
 
 	 D e c T r a n s V = 1   c   s   l   t i n g   V i t .   
 
 	 	 	 V N D ( 9 . 2 5 )   =   " C h  n   n g   v    h a i   m i   l m   x u . " 
 
 	 D e c T r a n s V = 0   k h  n g   c . 
 
 	 	 	 V N D ( 9 . 2 5 )   =   " C h  n   n g   2 5   x u . " 
 
 
 
 	 D e c T r a n s E = 1   c   s   l   t i n g   A n h 
 
 	 D e c T r a n s E = 0   k h  n g   c 
 
 
 
 +   T h  m   3   h  m   g m   V N D W ,   U S D W ,   N u m 2 S t r W   t r o n g   a d d - i n   " A c c H e l p e r E x . x l a " ,   c  c   h  m   n  y   l u  n   t r   v   g i    t r   n g m   n h   l    U n i c o d e .   
 
 	 C  c h   d  n g   c in g   n h   t c     t  n h   t o  n   t n g   t   n h   c  c   h  m   V N D ,   U S D ,   N u m 2 S t r . 
 
 	 L u    ,   a d d - i n   " A c c H e l p e r E x . x l a "   c h   c n   t h i t   v i   E x c e l   2 0 0 3   h o c   c  c   p h i  n   b n   t h p   h n     n h n   g i    t r   U n i c o d e . 
 
 
 
 
 
 C m   n   a n h   B  i   N g u y n   T r n g   T n g   -   N i c k   B N T T   t r  n   w w w . g i a i p h a p e x c e l      t h  n g   b  o   c  c   l i   t r  n ! 
 
 
 
 v 2 . 0 :   ( 2 5 - N o v - 2 0 0 8 ) 
 
 
 
 +   S a   l i   c  c   c   c h u n   h n :   s a   l i   c  c   c   s   t h p   p h  n   t r o n g   t i n g   V i t ,   c  c   c   n h  m   s   t r o n g   t i n g   A n h . 
 
 +   C h o   p h  p   c   s   t i n   l  n   t i   1 8   c h   s . 
 
 +   S a   l i   c u   t r  c   c  c   h  m   c   s   V N D ,   U S D ,   N u m 2 S t r .   T h  m   c  c   t h a m   s     t h c   h i n   v i c   c   l i n h   n g . 
 
 [ C O D E ] 
 
 	 V N D ( A m o u n t ,   O u t p u t T y p e ,   U n i t 1 ,   U n i t 2 ,   M U n i t 2 ,   H a s G r o u p i n g S y m b o l ) 
 
 	 U S D ( A m o u n t ,   U n i t 1 ,   U n i t 2 ,   M U n i t 2 ,   H a s G r o u p i n g S y m b o l ) 
 
 	 N u m 2 S t r ( A m o u n t ,   L a n g T y p e ,   U n i t 1 ,   U n i t 2 ,   M U n i t 2 ,   H a s G r o u p i n g S y m b o l ) 
 
 
 
 	 A m o u n t : 	   l    s   t i n   c n   c h u y n   i   t h  n h   v n   b n . 
 
 	 O u t p u t T y p e : 	 l    m t   s ,   n u   g i    t r   l    1   h  m   t r   v   k i u   c h u i   T C V N 3 ,   2   k i u   c h u i   l    V N I ,   3   k i u   c h u i   l    U n i c o d e   -   n g m   n h   ( C h   d  n g   t   E x c e l   2 0 0 7   t r   l  n ) 
 
 	 U n i t 1 : 	 l    g i    t r   k i u   c h u i ,   c h   r a   l o i   n   v   t i n   t ,   n g m   n h   l    " n g " 
 
 	 U n i t 2 : 	 l    g i    t r   k i u   c h u i ,   c h   r a   l o i   n   v   t i n   t   c h o   s   l ,   n g m   n h   l    " x u " 
 
 	 M U n i t 2 : 	 l    c o n   s   c   n h  n   v i   s   l   c a   A m o u n t ,   q u y   i   s   l   t   n   v   U n i t 1   s a n g   U n i t 2 ,   n g m   n h   g i    t r   l    1 
 
 	 H a s G r o u p i n g S y m b o l 	 l    g i    t r   k i u   l o g i c ( b o o l e a n ) ,   n u   l    T R U E   t h    c h u i   k t   q u   s   c    d u   p h y   ( ,   )   n g n   c  c h   c  u ,   F A L S E   l    g i    t r   	 n g m   n h   k h  n g   c    d u   ( ,   )   n g n   c  c h . 
 
 [ / C O D E ] 
 
 	 ( * )   V i   s   t h a y   i   c u   t r  c   n  y   c h o   p h  p   k h   n n g   c   p h o n g   p h  ,   k h  n g   c h   c   s   t i n   m    c   c h o   c  c   n   v   o   l n g   k h  c ,   c h o   p h  p   q u y   i   n   v . 
 
 
 
 C  c   v    d   c   t r  n h   b  y   c h i   t i t   t r o n g   f i l e   " H e l p . x l s " 
 
 
 
 +   T n g   t c     c   c a   c  c   h  m . 
 
 +   Q u n   l    b   n h   c a   W i n d o w s   t t   h n . 
 
 +   V i   E x c e l   2 0 0 7 ,   A d d - I n   h   t r   y     U n i c o d e .   C h   t i n g   V i t   c   t h   h i n   t r o n g   h p   t h o i   " A d d - I n s "   v    " F u n c t i o n   W i z a r d / A r g u m e n t s " ,   c  c   h n g   d n   c h o   c  c     t h a m   s   c   c h i   t i t . 
 
 +   C u n g   c p   t h  m   k h   n n g   t  y   c h n   c h o   n g i   d  n g .   
 
 ( * )     t h a y   i   n h n g   t h  n g   s   c   t h i t   l p   n g m   n h   c h o   c  c   h  m   c in g   n h   c  c h   c   s   c a   c  c   h  m ,   n g i   d  n g   c    t h   m   f i l e   " A c c H e l p e r . i n i "   b n g   N o t e p a d   h a y   m t   t r  n h   s o n   t h o   ( h   t r   U n i c o d e )   n  o        s a   i . 
 
 N i   d u n g   f i l e   " A c c H e l p e r . i n i "   g m : 
 
 
 
 [ C O D E ] 
 
 ; = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 
 ; T h i t   l p   g i    t r   n g m   n h   c h o   E x c e l   A d d - I n   " A c c o u n t i n g   H e l p e r "   ( a c c h e l p e r . x l l ) 
 
 ; B n   c n   g    c h u i   U n i c o d e ! 
 
 ; - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
 
 ; E   =   E n g l i s h ;   V   =   V i t   N a m 
 
 
 
 [ N U M 2 S T R I N G ] 
 
 D e c P o i n t V = v  
 
 D e c P o i n t E = a n d 
 
 O n l y V = c h n 
 
 O n l y E = o n l y 
 
 U n i t 1 V = n g 
 
 U n i t 1 E = d o l l a r s 
 
 U n i t 2 V = x u 
 
 U n i t 2 E = c e n t s 
 
 E n d P o i n t = . 
 
 [ / C O D E ] 
 
 
 
 N u   n g i   d  n g   s a   l i   c  c   t h  n g   s   t r o n g   f i l e   " A c c H e l p e r . i n i "   t h    p h i   k h i   n g   l i   E x c e l   t h    c  c   h  m   m i   c p   n h t   l i . 
 
 
 
 T h  n g   t i n   c h i   t i t   m i   c  c   b n   x e m   t i   w e b s i t e :   h t t p : / / w w w . b l u e s o f t s . n e t 
 
 
 
 