2010/04/30 Daily tasks

1. Reply questions on the YS blog project
2. Analyze Ricoh copiers proposal (extra maintenance fee for 4th and 5th years vs new plan )
3. Moving some images for image server from D to USB , to save space for YS
4. Arrange holiday message for MBK
5. Arrange MBK Photo gallery demo with extra product related photo.

2010/04/29 Daily tasks

1. Test IP camera function and quality
2. Meeting with Ricoh sale for new copier offer
3. Reply/check AOL spam complaint against our payment reminder email to Pacnet to avoid IP banned.

2010/04/28 Daily tasks

1. Meet PacNet sale for CDN service information
2. Discuss internal about the HMB comments of MBK photos taking
3. Talk to Ricoh sale for extra printer requirements
4. Quote MD for update background of MBK site

2010/04/27 Daily tasks

1. Check HM Ftp issue
2. Suggest HM to change their practice
3. reply YS autoreply email issues
4. Check Web site alert for slowness, may related to Google crawler
5. Out to HMB for meeting

2010/04/26 Daily tasks

1. YA monthly meeting
2. talk the initial 9/F expansion plan
3. Check 9/F HGC fiber connection with HGC engineers
4. Ask PacNet to check the datacenter HGC internal connection
5. Ask NWT for March invoice
6. Check with Cheung about their extra equipment requests.
- 4 x barcode scanner
- 4 x PCs
- 2 x Epson LQ300+ II
- 1 x light usage copier
7. Arrange to setup two wordpress testing environment

2010/04/24 Daily tasks

1. Clean up all new server boxes ( Find 3 keyboards and 2 mouses )
2. Clean up all game stations ( tidy up the cable and move them to a specific location , RIP ) ...
3. Add email address to spam whitelist for Tom ..

2010/04/22 Daily tasks

*** Total Support date 2/2 ( Due to Alex is on leave for 2 days ) ***

1. Look into the wordpress setup document ( basic system requirement )
2. Check report/query for Hallmark new report request
3. Repair two broken chair , one for Andy, one for spare.
4. Aman email account has over quota
5. Find out that CCTV company installed 3 CAT5E cable in our server room. Don' t know what they want to do ..
6. Move email for Rony from C drive to D drive and compact his folders.

2010/04/21 Daily tasks

*** Total Support date 1/2 ( Due to Alex is on leave for 2 days ) ***

1. Finish the evaluation of OrangeHRM. And it is not suitable for us
2. Provide suggestion to HR about their new online leave application project. Due to the current Stupid old HRM, it is not possible for us to add extra function for it, i.e. online leave application.
3. Install photo editing software for CN office Junior designers
4. Remove "show hidden folder" problem ... It may be infected by virus due to USB
- remove all autorun.inf for all root drive and USB finger
- remove C:\windows\system32\eset*
- remove usb finger's mbc.exe in root
5. Confirm cabling working with Roctec ( totally 81 single port nodes )
6. Move some internal traffic to go though 10Mbps link instead of 2Mbps ( 75% 10Mbps )
7. Eat Stephen's tea for his 1-take-passed driving license

MS Excel Vlookup syntax

= VLOOKUP ( lookup_value , table_array , col_index_num , range_lookup )

lookup _value: The value you want to find in the first column of the table_array.

table_array: This is the table of data that VLOOKUP searches to find the information you are after.

The table_array must contain at least two columns of data. The first column contains the lookup_values.

col_index_num: The number of the column in the table_array that contains the data you want returned.

range_lookup: A logical value (TRUE or FALSE only) that indicates whether you want VLOOKUP to find an exact or an approximate match to the lookup_value. Typing False will return exact matches only.

Example Using Excel's VLOOKUP Function:

Note: For help with this example, see the image above.

1. Enter the following data into the cells indicated:
   

   Cell Data
   
   D3 - Part
   D4 - Bearing
   D5 - Bolt
   D6 - Cog
   D7 - Gear
   D8 - Washer
   

   E3 - Price
   E4 - $17.34
   E5 - $1.54
   E6 - $20.21
   E7 - $23.56
   E8 - $1.43
   

2. Click on cell D1 and type the word Bolt. This is the part we are trying to price.
   
   
3. Click on cell E2 - the location where the results - in this case, the price of a bolt - will be displayed.
   
   
4. Click on the Formulas tab.
   
   
5. Choose Lookup & Reference from the ribbon to open the function drop down list.
   
   
6. Click on VLOOKUP in the list to bring up the function's dialog box.
   
   
7. In the dialog box, click on the Lookup _value line.
   
   
8. Click on cell D1 in the spreadsheet to tell VLOOKUP that we are looking for the price of bolts.
   
   
9. In the dialog box, click on the Table_array line.
   
   
10. Drag select cells D4 to E8 in the spreadsheet to enter that range into the dialog box. The table_array is the table of data that VLOOKUP searches for the lookup_value specified in cell D1.
    
    
11. In the dialog box, click on the Col_index_num line.
    
    
12. Type the number 2 to indicate that the data we want returned is in column 2 of the table_array.
    
    
13. In the dialog box, click on the Range_lookup line.
    
    
14. Type the word False to indicate that we want an exact match for our requested data.
    
    
15. Click OK.
    
    
16. In cell D1 of the spreadsheet, type the word bolt.
    
    
17. The value $1.54 should appear in cell E1 displaying the price of a bolt as indicated in the table_array.
    
    
18. If you click on cell E1, the complete function = VLOOKUP ( D1 , D4:E8 , 2 , FALSE ) appears in the formula bar above the worksheet.

Source from : http://spreadsheets.about.com/od/excelfunctions/qt/080722_vlookup.htm

P.S. In order to force the cell to be value, you can use paste special and in the operation menu, choose add ( which means that it will add up the value to the paste area. You just need to ensure that the area is blank and it will show the value )

2010/04/21 Daily tasks

1. Check the Vlookup function for Peggy
2. Talk to the sale for the HRM system
3. Fixing HMB production attribute problem
4. Monitoring cabling to 9/F
5. Creating HGC working ticket number for PacNet


P.S. If you employ drivers and they told you that they cannot drive your car as it is too old. You should fire them instead of buying new cars for them to make their jobs working with less techniques.

2010/04/20 Daily tasks

1. HGC meeting for new service
2. Roctek meeting for new switches
3. IT internal bi-weekly meeting
4. Monthly YA meeting
5. Check and fix MBK customer account issue
6. Getting information of HRM
7. Check 8/F cabling. Should be finished at Wed.

2010/04/16 Daily tasks

1. Go to DC to get two switches
2. Install TB and P for EMK , import her email
3. Record Ricoh meter charge invoice
4. Ship a self-made label printer ribbon holder to JP
5. Celebrate Thomas B-Day cake
6. Arrange to replace dm team all LCD with the new one

2010/04/15 Daily tasks

1. Uninstall Vega 8 and install Vega 9 trail for Jasmine
2. Checking 8/F cabling status, arrange to add a extra power socket for switches
3. Production of Label printer ribbon holders ( V4 and new version )
4. Give 3 x HKPOS barcode scanner to Cheung
5. Checking Office Proxy usage and add image extension to non-scan list to lower the CPU usage

2010/04/14 Daily tasks

1. Talk to Ada about the HMB domain ownership problems
2. Talk to Henry about the new PC arrangement
3. Review and confirm SAN storage warranty renewal
4. Discuss with Cheryl about the email digital signature research findings and issues.
5. All IT staff meeting
6. Personal update meeting

2010/04/13 Daily tasks

1. Look into AWS
2. Look into Email security ( ssl cert and digital signature )
3. Apply Comodo free email cert for testing with different domain.

2010/04/12 Daily tasks

1. Discuss with EMK about the JP NTT fiber connection ..
2. Arrange cabling for 8/F new office ( start at Wed )
3. Read the Google Big table paper ... It is interesting ..
4. Send a big label printer roller to JP office.
5. Check the new delivered Dell PC/ Monitor
6. Discuss with PL about the 8/F floor problem ..
7. Update meeting

2010/04/09 Daily tasks

1. Update F5 irules to remove cookie ( requested by Wing )
2. Talk to sale for notebook quotation
3. Oracle warranty renewal
4. Fairwell Sony and copy his files
5. Discuss KR Dodostyle blocked by google problem with Insook
6. Checking YS new Arrival slowness
7. Change Office<=> Datacenter loadbalancing policy