Microsoft Outlook_How to delete the email in the achived folder "Vault"

Some emails is achived in the Vault. but it is not what you want. Here is the way to delete them.

1. Click "Search Vaults".

SPPID_Auxiliary Graphics

Sometimes, by some reason, SPPID administrator can not delivery the symbols in time. It happens to everybody. We can not wait until he/she come back from vacation. So, Auxiliary Graphics will be a good help for us to create a temporary symbol.
Main options:
1) Edit > Insert > Auxiliary Graphics
2) File > Close Auxiliary Graphics

SPPID_EDE always jump out a window "Asking Filter"

Sometimes, doesn't matter you click Pipe Run, or Piping component... there always a window jump out. The window's name is "Asking Filter".

SPPID_Title block

Sometimes, we found the drawing title block is lost. Then, how to get the border back? It is the same process at get the new border. The description also includes one special issue.

1. The drawing will be like this after title block lost.

Microstation_Batch Print

At first, I am not recomand this method because the situation of drawings are much different. It is difficult to get qualified print. but if for information only, batch print will save you lot of time.

1. Click File then "Batch Print".

Excel_How to count text or multiple text

Count text formular: COUNTIF(P6:P20,"TEXT")
Count different text formular: SUMPRODUCT((P6:P20="TEXTA")+(P6:P20="TEXTB"))
Count any letter formular: COUNTIF(P6:P20,"*")

Fomular input method: Ctrl+Shift+Enter

Microstation_How to modify title block without change the original one

Sometimes, difference department use similiar title block. it need change a little bit, for example: erase one line, or some text. but we can not change the default title block according the company rule. So, what can we do?

*The idea is mask it.
1. Fence the part that you want the mask.
2. Click File-Reference-Tools-Clip Mask