SPPID_How to put instrumentation text and Tag sequence no.

Some drafters just simply type text into instrumentation symbol. It's not correct.
The first letter (Measured Variable Code) and Tag Sequence Number should type into loop, then it will shows on the instrumentation symbol. only the Instr. Type Modifer need to be typed into Instr. symbol.

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