Monday, January 31, 2011

Restore MS word,MS Excel,MS PPT files by stick qiu

in Computers / Data Recovery (submitted 2010-03-10)

Microsoft's Office document software, mainly word, excel, powerpoint, outlook, etc.
MS office must be the most popular office software.
People use word and excel and ppt to deal with important data and documents.

If you format usb drive or hard disk drive or memory card or some other storage devices,you may loss your MS word and excel and ppt files.
If you delete or erasy or remove files,make sure if they are deleted permanently.If you press "shift + del" key to delete files,whether it is a word document, or if it is the excel form, or ppt presentation files,you will loss them.
If you delete or erasy or remove a folder,do you think all the files in the folder should be deleted?
Whatever,whenever,however you lost your files,you can try Diskgetor data recovery to restore MS word,MS Excel,MS ppt files from fommatted hard drive.
Diskgetor word recovery software for Word is a solution for recovery Word, it repairs documents in Microsoft Word format. This MS Word repair tool processes damaged files in Microsoft Word format, in the same time, the reason of email corruption does not matter. Diskgetor word recovery software for Word works with all Word files, it is safe to open even infected files of *.doc format. If you'd like to recover Word file successfully, you should not wait, until these documents will be completely destroyed.

Try Diskgetor word recovery software for Word Microsoft Word text recovery, if you could not prevent an issue. Feel free to download demo version of Diskgetor word recovery software for Word, it costs nothing. Demo version helps to understand, how Diskgetor word recovery software for Word works and to estimate its data recovery engine. If you are not sure, that it is possible to reproduce Microsoft Word recovery without errors, you may contact our support department and get help. Our specialists quickly reply either to our customers or to demo version users.

We believe, that Diskgetor word recovery software for Word is very easy, no need to read instructions and user's guides, the process of data recovery may be done without any help. Diskgetor word recovery software for Word is an effective way for Word text recovery, now MS Word repair and recovery doc can be done in several minutes. Diskgetor word recovery software for Word recovery for Word permits to preview, which portions of text will be restored without errors, try it, when making a decision to purchase repair Word 2007. We are sure, that you will make a wise choice after testing of Diskgetor word recovery software for Word.

You can undo files format with few steps,you can restore format word files easily,you can unformat hard drive simply.

By the way,not only MS word or MS Excel files can be recovered,also include zip files or outlook mails or others.

About the Author

http://www.diskgetor.com

Thursday, January 27, 2011

Percentage

There are no specific functions for calculating percentages.

You have to use the skills you were taught in your maths class at school!

Finding a percentage of a value

Initial value

120

% to find

25%

Percentage value

30

=D8*D9

Example 1

A company is about to give its staff a pay rise.

The wages department need to calculate the increases.

Staff on different grades get different pay rises.

Grade

% Rise

A

10%

B

15%

C

20%

Name

Grade

Old Salary

Increase

Alan

A

£ 10,000

£ 1,000

=E23*LOOKUP(D23,$C$18:$C$20,$D$18:$D$20)

Bob

B

£ 20,000

£ 3,000

=E24*LOOKUP(D24,$C$18:$C$20,$D$18:$D$20)

Carol

C

£ 30,000

£ 6,000

=E25*LOOKUP(D25,$C$18:$C$20,$D$18:$D$20)

David

B

£ 25,000

£ 3,750

=E26*LOOKUP(D26,$C$18:$C$20,$D$18:$D$20)

Elaine

C

£ 32,000

£ 6,400

=E27*LOOKUP(D27,$C$18:$C$20,$D$18:$D$20)

Frank

A

£ 12,000

£ 1,200

=E28*LOOKUP(D28,$C$18:$C$20,$D$18:$D$20)

Finding a percentage increase

Initial value

120

% increase

25%

Increased value

150

=D33*D34+D33

Example 2

A company is about to give its staff a pay rise.

The wages department need to calculate the new salary including the % increase.

Staff on different grades get different pay rises.

Grade

% Rise

A

10%

B

15%

C

20%

Name

Grade

Old Salary

Increase

Alan

A

£ 10,000

£ 11,000

=E48*LOOKUP(D48,$C$18:$C$20,$D$18:$D$20)+E48

Bob

B

£ 20,000

£ 23,000

=E49*LOOKUP(D49,$C$18:$C$20,$D$18:$D$20)+E49

Carol

C

£ 30,000

£ 36,000

=E50*LOOKUP(D50,$C$18:$C$20,$D$18:$D$20)+E50

David

B

£ 25,000

£ 28,750

=E51*LOOKUP(D51,$C$18:$C$20,$D$18:$D$20)+E51

Elaine

C

£ 32,000

£ 38,400

=E52*LOOKUP(D52,$C$18:$C$20,$D$18:$D$20)+E52

Frank

A

£ 12,000

£ 13,200

=E53*LOOKUP(D53,$C$18:$C$20,$D$18:$D$20)+E53

Finding one value as percentage of another

Value A

120

Value B

60

A as % of B

50%

=D59/D58

You will need to format the result as % by using the % button

on the toolbar.

Example 3

An manager has been asked to submit budget requirements for next year.

The manger needs to specify what will be required each quarter.

The manager knows what has been spent by each region in the previous year.

By analysing the past years spending, the manager hopes to predict

what will need to be spent in the next year.

Last years figures

Region

Q1

Q2

Q3

Q4

North

9,000

2,000

9,000

7,000

South

7,000

4,000

9,000

5,000

East

2,000

8,000

7,000

3,000

West

8,000

9,000

6,000

5,000

Total

Total

26,000

23,000

31,000

20,000

100,000

Last years Quarters as % of last years Total

Region

Q1

Q2

Q3

Q4

North

9%

2%

9%

7%

=G74/$H$78

South

7%

4%

9%

5%

=G75/$H$78

East

2%

8%

7%

3%

=G76/$H$78

West

8%

9%

6%

5%

=G77/$H$78

Total

26%

23%

31%

20%

=G78/$H$78

Next years budget

150,000

Next years estimated budget requirements

Region

Q1

Q2

Q3

Q4

North

13,500

3,000

13,500

10,500

=G82*$E$88

South

10,500

6,000

13,500

7,500

=G83*$E$88

East

3,000

12,000

10,500

4,500

=G84*$E$88

West

12,000

13,500

9,000

7,500

Total

Total

39,000

34,500

46,500

30,000

150,000

Finding an original value after an increase has been applied

Increased value

150

% increase

25%

Original value

120

=D100/(100%+D101)

Example 4

An employ has to submit an expenses claim for travelling and accommodation.

The claim needs to show the VAT tax portion of each receipt.

Unfortunately the receipts held by the employee only show the total amount.

The employee needs to split this total to show the original value and the VAT amount.

VAT rate

17.50%

Receipt

Total

Actual Value

Vat Value

Petrol

£ 10.00

£ 8.51

£ 1.49

=D113-D113/(100%+$D$110)

Hotel

£ 235.00

£ 200.00

£ 35.00

Petrol

£ 117.50

£ 100.00

£ 17.50

=D115/(100%+$D$110)

Popular Posts