Report 2013 of Cambodia’s Millennium Development Goals

The Royal Government of Cambodia has made an assessment of the progress in achieving Cambodia’s Millennium Development Goals (CMDGs) on an annual basis since 2010. In addition to the central topic, CMDGs achievement, the 2013 Report briefl y presents the country’s macroeconomic situation and puts forth a CMDG Acceleration Framework. The CMDG Acceleration Framework recommends policies and approaches to accelerate the progress of the CMDGs and other human development goals, which could provide the essential inputs for the implementation of the National Strategic Development Plan (NSDP), the NSDP 2014-2018. Moreover, this report for the fi rst time discusses the progress in achieving CMDGs at the sub-national level and also highlights upon the prevailing inequality in the country and its impact on CMDG achievement. 

You may download full report here: CMDG Report 2013

Cambodian Passport Office

Recently, Cambodian government has changed the location of Passport Office for two times in which it has made a difficulty for general people who wished to obtain a passport to work in other countries. Below is the new passport office location in Cambodia.

Cambodian Passport Office, Passport Office, Passport Office Location, New Passport Office Location, Cambodia,

Roadmap for HIV Intervention by 2020 in Cambodia

Roadmap for HIV Intervention by 2020 in Cambodia 

Pre-Wedding Khmer Movie

Directed: Pleang Cameraman N editor : Heng Lim Make-up: Bun Ly Pleang foto,  HD: More Than Words ( We do not own any rights to these songs ) Pleang, a member of WPA - Wedding Photographers Association - Interesting Social Videos

Disable Cut or Copy or Paste in Excel 2010

Disable Cut or Copy or Paste in Excel

I have difficulty to disable Cut, Copy, Paste Functions in the Excel 2010 even I have tried in VBA code. Please share a useful link with us.

Instruction for Upgrade iOS 7.0.4, 7.0.6, 7.1

Instructions: Install Apple iOS 7.1 on your Apple devices immediately. Complete the following steps to install iOS 7.1:

1.       Charge the device to full battery capacity

2.       Plug the device into a power outlet

3.       Connect to Wi-Fi if available (for enhanced installation performance)

4.       Power on the device

5.       Enter the device password

6.       Select > Settings

7.       Select > General

8.       Select > Software Update*

9.       Select > Download and Install – iOS 7.1

10.    Follow any unique instructions provided by Apple during your installation process, including terms and conditions agreement

*Note: Step 8, if your device was jailbroken, you need to install through the updated iTunes.

Jailbreak

1.       Charge the device to full battery capacity

2.       Connect to Wi-Fi if available (for enhanced installation performance)

3.       Power on the device

4.       Enter the device password and remove your password and App Finding My iPhone

5.       Open application which download from http://evasi0n.com/ 

6.       Plug your iDevice to a computer, it will tell you that your iDevice is applicable or not. If it is applicable, go to the next step and follow the instructions.

After Jailbreak

There are some important apps to be installed on your iDevice.

1.    Update Complete Upgrade in Cydia

2.    Add Cydia Sources

a.       http://repo.insanelyi.com/

b.      http://repo666.ultrasn0w.com/

c.       http://sinfuliphonerepo.com/

d.      http://cydia.xsellize.com/

e.      http://cydia.zodttd.com/repo/cydia/

f.        http://4khmeriphone.com/sp/

g.       Go to search in cydia and install following apps

a)       iAPFree, from Sinful iPhone Repo

b)      Audio Recorder, from Insanelyi Repository

c)       Barrel, from Insanelyi Repository

d)      iFile, from Insanelyi Repository

3.    

  

  

Purchased Apps

1 -     HelloCamera

2 -     Fieldrunner 2 (iPhone)

3 -     CamTelCodes

4 -     Pocket Expense

Calendar Year in Excel 2010

Calendar Year in Excel 2010

=>Select 31 columns and wanted rows => Paste Formula below with Ctrl +Enter

=DATE(YEAR(B4),MONTH(B4),1)+{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31}-1

B4 is the source of month, example: January-2014. You can change to any month as you want.

Result:

There are formatting in the table. For example, Saturday and Sunday. Please do  as below

=>Select whole month => Conditional Formatting => New Rules => See below formula

=WEEKDAY(DATE(YEAR($B$6),MONTH($B$6),DAY(B$6)),2)>5

This is very important trick. B6 is the first day of the month. Please use ($) only one in DAY.

Calendar Month in Excel 2010

Select 5 rows and 7 columns => Paste formula below with Ctrl + Enter

=DATE(YEAR(B2),MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1

Result:

and then formatting the last month.

=> Select whole calendar => Conditional Formatting =>

LEN Function in Excel 2010

LEN always counts each character, whether single-byte or double-byte, as 1, no matter what the default language setting is.

Syntax:

·         LEN(Text)

Example : =LEN(C2) = 18

	A	B	C
1		Count Text	Text
2	LEN	18	I want to go home.
=LEN(C2)

TIME Function in Excel 2010

The decimal number returned by TIME is a value ranging from 0 (zero) to 0.99999999, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).

Syntax:

                =TIME(hour, minute, second)

	TIME Function
	A	B	C
1	Serial_Number	3/20/2014 15:42	=NOW()
2	=HOUR(B10)	15
3	=MINUTE(B1)	42
4	=SECOND(B1)	21
5	=TIME(B2,B3,B4)	3:42 PM

DATE Function in Excel 2010

The DATE function returns the sequential serial number that represents a particular date.

FUNCTIONS	Description / Example	Results
DATE function	Returns the serial number of a particular date
=DATE(year,month,day)	=DATE(1980,8,15)	8/15/1980
=DATE(YEAR(TODAY()),12,31)	Serial date for the last day of the current year.	12/31/2013
=DATE(LEFT(A4,4),MID(A4,5,2), RIGHT(A4,2))	A formula that converts a date from the YYYYMMDD format to a serial date. Ex: 20130515	5/15/2013
=DATEVALUE("mm/dd/yyyy")	Serial number of the text date, using the 1900 date system. =DATEVALUE("07/12/2013")	41467
=DATEVALUE("dd-mm-yyyy")	=DATEVALUE("12-Jul-2013")	41467
DAY Function
=DAY(serial_number)	12-Jul-2013	12
=DAYS360(start_date,end_date,[method])	Number of days in years Star date: 11/1/2010 and end date: 8/2/2013 =DAYS360(DATE(2010,11,1),DATE(2013,8,2))	991
= HOUR(serial_number)	The time that contains the hour you want to find	11
=MINUTE(serial_number)	The time that contains the minute you want to find.	7
=SECOND(serial_number)	The time that contains the seconds you want to find.	59
=MONTH(serial_number)	The date of the month you are trying to find.	12
=YEAR(serial_number)	The date of the year you want to find. =YEAR(TODAY())-1980	33
=NOW()	Returns the serial number of the current date and time	12/5/2013 11:07
TODAY function
=TODAY()	Returns the current date.	12/5/2013
=TODAY()+5	Returns the current date plus 5 days. For example, if the current date is 7/10/2013, this formula returns 7/15/2013.	12/10/2013
=DATEVALUE("1/1/2030")-TODAY()	Returns the number of days between the current date and 1/1/2030. Note that cell A4 must be formatted as General or Number for the result to display correctly.	1/27/1916
=DAY(TODAY())	Returns the current day of the month (1 - 31).	5
=MONTH(TODAY())	Returns the current month of the year (1 - 12). For example, if the current month is June, this formula returns 7.	12
=WEEKDAY(serial_number,[return_type])	=WEEKDAY("7/10/2013",2)	3

Shortcut Key for PowerPoint 2010

Shortcut for PowerPoint 2010, Shortcut Key, PowerPoint 2010

Useful Sources for Cydia iOS 7

Open your Cydia and put these address for wonderful tweak and free

Dropdown List with Multi-Criteria in Excel

Drop Dow List with Multi-Criteria in Excel
There is no easy way to do this, but if you know this, it will be easier for you. Below is the list of provinces in Cambodia and the Operational Districts (OD).

You want to select a province, and then OD name can be selected like below, don't you?

There are many steps as below:

Step 1: Select all provinces => Naming cells (2) =>

Step 2:  Naming all ODs /Criteria​ by different short name.

Step 3: Create table for dropdown List in new worksheet.

Step 4: Naming the formula

·         => Formulas => Define Name =OD => using the follow formula.

=IF(List!C5=OD!$B$1,BMC,IF(List!C5=OD!$C$1,BTB,IF(List!C5=OD!$D$1,KgCham,IF(List!C5=OD!$E$1,KgChhnang,IF(List!C5=OD!$F$1,KgSpeu,IF(List!C5=OD!$G$1,KgThom,IF(List!C5=OD!$H$1,KPT,IF(List!C5=OD!$I$1,Kandal,IF(List!C5=OD!$J$1,KK,IF(List!C5=OD!$K$1,KEP,IF(List!C5=OD!$L$1,Kratie,IF(List!C5=OD!$M$1,MDK,IF(List!C5=OD!$N$1,OMC,IF(List!C5=OD!$O$1,Pailin,IF(List!C5=OD!$P$1,PP,IF(List!C5=OD!$Q$1,PVH,IF(List!C5=OD!$R$1,PV,IF(List!C5=OD!$S$1,PST,IF(List!C5=OD!$T$1,RTK,IF(List!C5=OD!$U$1,SR,IF(List!C5=OD!$V$1,SHV,IF(List!C5=OD!$W$1,ST,IF(List!C5=OD!$X$1,SV,IF(List!C5=OD!$Y$1,Takeo)))))))))))))))))))))))) 

Step 5: Data Validation for Province column

·         Select Cells (under Provinces )=> Data => Data Validation => Data Validation => Setting => Data Validation =List => Source = Province

·         Select a cell (under ODs )=> Data => Data Validation => Data Validation => Setting => Data Validation =List => Source =OD

Note: please select only a cell under ODs (D5) for data validation, otherwise, it will not work well. Then you can copy (D5) and paste to other below cells.

=> Download Exercise

Hide or Show Worksheet Tabs in Excel

Option 1: Using advance option in the Microsoft Excel

File Menu à Options à Advanced à Scroll down à Display options for this workbook: 

þ Show Sheet Tabs à to show sheet tabs

¨ Show Sheet Tabs à to hide all sheet tabs

Note: When you hide all sheet tabs you are unable to move to other sheets in the workbook. So you need to create links to other sheets before hiding all sheets.

Hide or Show Worksheet Tabs, Excel 2007, Excel 2010, Advanced Excel, 

Option 2: Using Visual Basic Application (VBA)

File Menu à Options à Customize Ribbon à Tick þ Developer à OK 

VBA

à Insert à Module à Double click on Module and then copy and paste code below.