P  8B8BR     Ef  Gr
@           @      
@
           @      
@          @      
@   0       @      @                              @                              @                              @                              
@2           @                              @       B	                      T      V      X      [      ]      _                                                                                                                                                                                                                                                                                                                                                                                                                                                         
@6   `       @                              @      
@9          @       @       B
                            .      /      0      1      2      :      ;      <      K      L                                                                                                                                                                                                                                                                                                                                                                                                                    B
                            !      !      %      %      %      5      8      8      H      H                                                                                                                                                                                                                                                                                                                                                                                                                   @                              @    $,&&&&&"&"      Planned      In Progress      Complete.   !   Customer/   !   Purchase0   %   Manpower1   %   Material2   %   Others:   5   CALL;   8   Open<   8   CompleteK   H   OpenL   H   Closed
@	          @    a         &@      R@@    a         3@      S@@                              @                              @                              @                              @                              @0  0  $a        @U@     Z@
@         @      A    @@TB @@TB@    A      TB   TB@    A         [@      [@
@<         
   @       B3         &     '     (     )     *     +     ,     -     3     4     5     6     7     8     9     =   P  >   Q  ?   R  @   S  A   T  B   U  C   V  D   W  E   X  F   Y  G   Z  H   [  I   \  J   ]  M   ^  N   _  O     P     Q     R     S     t     u     v     w     x     y     z     {     |     }     ~                                                                                                                        B       %                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  @      A      TB   TB B       P      Q      R      S      T      U      V      W   	   X   
   Y      Z      [   
   \      ]      ^      _      p     q     r     s     t     u     v     w     x     y     z      {  !   |  "   }  #   ~  $     %     &     '     (     )     *     +     ,     -     3     4     5     6     7     8     9     =   P  >   Q  ?   R  @   S  A   T  B   U  C   V  D   W  E   X  F   Y  G   Z  H   [  I   \  J   ]  M   ^  N   @    A        @[@     [@ B       p   U   q   W   r   Y   s   Z   t   \   u   ^   v   `   w   a   x   b   y   c   z   d   {   e   |   f   }   g   ~   h      i     j     k                                                                                                                                                                                                                                                                                                                                                                           @     Rj          To Do Absolutly           ,r6<={+0} ANDr7='Open'
TodosFk          Not solved yet           r7='Open'Troubles B         l                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    B         S B                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  B         S m a l l B a s                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     G@     <l   'v SB*SmallBase DevelopmentPOCKETIQ njv  ʒ  B         m     n                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            B         S B               S B                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              B          Av    ^1v                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 @0  0  A   P lC<+lC~@     rz4m   'v SB Av  )v (Meeting at San Diego  8n   &'v SB ^1v  ,3v 0Meeting at San Francisco   B         o     p                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            B         S B               S B                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
@.         @P  P  A      TB   TB@@  @  A        [@      \@@     po   1;'v SBCustomer njv 456778,CISCO routers 7206 VRXMaterial_     p@     @'@
CISCO x         pp   (Y>'v SBPurchase njv 450000999888CISCO EquipmentManpower_     l@                
CISCO njv  njv  B       @  q   A  r                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            B       @  S B             A  S B                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             @p  p  A      TB   TB@`  `  A        @\@     \@
@     $    CM   ~~pjzztxrDU           Project             $r2='%Projects.r2%'LogsHW           Project             $r2='%Projects.r2%'MeetingsFY           Project             $r2='%Projects.r2%'OrdersFZ           Project            $r2='%Projects.r2%'
TasksD\           Project            $r2='%Projects.r2%'TimeF^           Project             $r2='%Projects.r2%'
TodosH`           Project             $r2='%Projects.r2%'Troubles<a           Coming             r3>={+0}MeetingsHb          
Today           &r3>{-1} ANDr4<{+1}Meetings:c          Past         r4<{+0}MeetingsBd          Customer           r3='Customer'OrdersBe          Purchase           r3='Purchase'Orders@f          Planned           r5='Planned'
TasksHg          In Progress           r5='In Progress'
TasksBh          Complete         r5='Complete'
Tasks>i          Last 5 days           r4>={-5}Time B         s                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    B         S B                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 @    A      TB   TB@    A        \@     \@I@     6s   UR'v SB    njv  @F0v ESN       @      @      @
@+         
@$   B      @     nq   hVd;,v SB   :Write In Depth SpecificationsPlanned @7{  ` o      4@             F@             @    @w@dr   :,v SB    Conception PhaseIn Progress  {v  o{ o     F@       @      C@,d1@     X@    @< A@            ?     @`@@      A         @     W@Fi     $ID_id pa      SB_0id tb 2fd typ siz la 2ord col li wi rs fo vi al so bd it ft 2he sl ix cll ca qy     SB_1  id     FC_id fid typ la 2ca cfo cba sty qy tb 2    FC_1  id     CL_id fid la 2 
   CL_1  id     CL_2  fid     LI_li (    LI_1  li(    PA_la 2     PR_id tb 2cv sc bd it ft 2he sz sg fs hk     PR_1  id     VA_id la va     VA_1  id     RM_
id tb 2idt al
 so     RM_1  id     RM_2  idt      Projectsr0 r1
 r2 
r3 2r4 2r5
 r6
 r7      $Projects1 r0  !   (Projectsr2  r2 #   (Projectsr3  r3 L   Tasksr0 r1
 r2 
r3 r4 dr5 2r6
 r7
 r8	 r9	 r10	 r11	 r12 r13	 r14	  %   Tasks1 r0  &   Tasksr2  r2 *   Timer0 r1
 r2 
r3 r4
 r5
 r6 2r7	 r8	 r9	 r10  ,   Time1 r0  -   Timer2  r2 F   Orders r0 r1
 r2 
r3 2r4
 r5 r6 dr7 2r8	 r9	 r10	 r11 2r12
 r13 2r14
 r15  /   Orders1 r0  0    Ordersr2  r2 E   Todosr0 r1
 r2 
r3 r4 2r5 r6
 r7 2r8  3   Todos1 r0  4   Todosr2  r2 G   Logsr0 r1
 r2 
r3
 r4 dr5 2r6 2r7  7   Logs1 r0  8   Logsr2  r2 B   Logsr3  r3  J   Logsr4  r4 K    Troublesr0 r1
 r2 
r3 2r4
 r5 2r6 r7 2r8
 r9  :   $Troubles1 r0  ;   (Troublesr2  r2 H    Meetingsr0 r1
 r2 
r3
 r4
 r5 dr6 2r7 r8  =   $Meetings1 r0  >   (Meetingsr2  r2 D   (Meetingsr3  r3  I   Statusr0 r1
 r2 
r3	 r4	 r5	 r6	 r7	 r8	 r9	 r10	 r11	 r12	 r13	 r14	  [   Status1 r0  \    Statusr2  r2 ^    B                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             B         S B                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 @      A      TB   TB@    A        `@     `@
@   1       
@        	@         
@Z         y@     V   (F z,v SB     @                     @     p@            
A             p@    UA'@( @     |   Statusr12
   2   &Planned Total Costs              r7+r8+r9+r10              }                       |   Statusr13
   2    % Current Profit              (r6-r11)/r6*100              }                       |   Statusr14
   2    % Planned Profit
              (r6-r12)/r6*100              }                              `    >   w3   >   >   
N      )   )                  &              =    .    T    E    73   }	         \    W3   |            K      	   	      	   >2   /2   k)   @   l   n   K)   1    2   1   N$   #   .$   Ǡ              Ԧ   D      $   [   L   p   {   
   M   F   '
   )      m   +   $   1      	   [   =	   ]	   	   o         
   U   W   Y      !   G%   I'   -   /   >   >   a>   4?   A>   =:   ?<  
@         
@          A    nhjnjfhnj6   Projects               System   2           4   
Tasks               System   2           6T   Logs            System   2           L6V   Meetings            System   2           4X   Orders               System   2           2[   Time               System   2           4]   
Todos               System   2           6_   Troubles               System   2           4   Status           System   P                         ^!   Ordersr3   2   Type   q                         }                       ^"   Ordersr4   2   Date                            }                       b#   Ordersr5       Order Id                            }                       `$   Ordersr6    d   
Label                            }                       `%   Ordersr7   2   
Categ   }                         }                       G]   MM=Q!AdP   Meetingsr5    d   Subject   k
                         }                       bQ   Meetingsr6   2   
Categ   }                         }                       bR   Meetingsr7   2   Report                            }                       bS   Meetingsr8   2   
Notes                            }                       ft   
Tasksr13   2   Unit Cost                            }                       nu   
Tasksr14
   2   Total Rest              r13*r10              }                       dv   Statusr2    
   Project Id                            }                       w   Statusr3
   2   Material Sold              Orders.r9                                     Fr2='%Status.r2%'  AND r7='material'x   Statusr4
   2   Manpower Sold              Orders.r9                                     Fr2='%Status.r2%'  AND r7='manpower'y   Statusr5
   2   Others Sold              Orders.r9                                     Br2='%Status.r2%'  AND r7='Others'lz   Statusr6
   2   Total Sold              r3+r4+r5              }                       {   Statusr7
   2   Material Costs              Orders.r8                                     Fr2='%Status.r2%'  AND r7='material'|   Statusr8
   2   ,Current Manpower Costs              Time.r9                                     r2='%Status.r2%}   Statusr9
   2   *Planned Manpower Cost              Tasks.r14                                      r2='%Status.r2%'~   Statusr10
   2   Other Costs	              Orders.r8                                     Br2='%Status.r2%'  AND r7='Others'z   Statusr11
   2   &Current Total Costs
              r7+r8+r10              }                       FF'   ƺ¼9f   Projectsr2    
   Project Id                            }                       `   Projectsr3    2   Name   w                         }                       d   Projectsr4    2   Customer                            }                       f   Projectsr5   2   Start Date   <                         }                       d   Projectsr6   2   End Date   w                         }                       b   Projectsr7   2   
Notes                            }                       d   
Tasksr2    
   Project Id                            }                       b	   
Tasksr3   2   Task Id                            }                       ^
   
Tasksr4    d   Name                            }                       `   
Tasksr5   2   Status   Y                         }                       `   
Tasksr6   2   
Start   M                         }                       ^
   
Tasksr7   2   End   S                         }                       j   
Tasksr8   2    Initial Workload                            }                          
Tasksr9
   2   Already Done              Time.r7                                     Dr2='%Tasks.r2%'  AND r3=%Tasks.r3%f   
Tasksr10   2   Rest to Do	   0                         }                       v   
Tasksr11
   2   %Progress
              100*r9/(r9+r10)              }                       E1   ¶b   
Tasksr12   2   
Notes
                            }                       b   Timer2    
   Project Id                            }                       `   Timer3   2   Task Id                            }                       ^   Timer4   2   
Start                            }                       \   Timer5   2   End                            }                       \   Timer6    2   Who                            }                       \   Timer7   2   Done   q                         }                       b   Timer8   2   Unit Cost   <                         }                       d   Timer9
   2   
Total              
r7*r8              }                       `   Timer10   2   
Notes	                            }                       d    Ordersr2    
   Project Id                            }                       ^!   Ordersr3   2   Type   q                         }                       ^"   Ordersr4   2   Date                            }                       b#   Ordersr5       Order Id                            }                       `$   Ordersr6    d   
Label                            }                       `%   Ordersr7   2   
Categ   }                         }                       F5   ܾh&   Ordersr8   2   Purchase Price                            }                       h'   Ordersr9   2   Selling Price                            }                       r(   Ordersr10
   2   %Profit	              (r9-r8)/r9*100              }                       d)   Ordersr11    2   Company
                            }                       d*   Ordersr12   2   Delivery                            }                       d+   Ordersr13    2   Invoice                            }                       d,   Ordersr14   2   Inv Date
                            }                       b-   Ordersr15   2   
Notes                            }                       d3   
Todosr2    
   Project Id                            }                       ^4   
Todosr3       Todo   Y                         }                       `5   
Todosr4   2   
Categ                            }                       ^6   
Todosr5   2   Prio   G                         }                       b7   
Todosr6   2   Due Date   k                         }                       `8   
Todosr7   2   Status   w                         }                       `9   
Todosr8   2   
Notes                            }                       b=   Logsr2    
   Project Id                            }                       E?   ļȾƼƼb>   Logsr3   2   Date/Time                            }                       \?   Logsr4    d   What                            }                       ^@   Logsr5   2   
Categ   6                         }                       \A   Logsr6    2   Who                            }                       ^B   Logsr7   2   
Notes                            }                       fC   Troublesr2    
   Project Id                             }                       fD   Troublesr3    2   Ticket Id                            }                       fE   Troublesr4   2   Date/Time                            }                       bF   Troublesr5   2   
Categ                            }                       hG   Troublesr6       Description   	                         }                       bH   Troublesr7   2   Status   <                         }                       fI   Troublesr8   2   Completion                            }                       bJ   Troublesr9   2   
Notes                            }                       fM   Meetingsr2    
   Project Id                            }                       bN   Meetingsr3   2   
Start                             }                       `O   Meetingsr4   2   End                            }                       C      `   @       B     B     B  '   RT  1   +Z  5   8`  