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 =>