Home

Tuesday 30 August 2011

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".


















Thursday 18 August 2011

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.

Friday 12 August 2011

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".


Thursday 4 August 2011

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