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".
Labels:
SPPID Solution
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.
Labels:
SPPID Solution
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".
1. Click File then "Batch Print".
Labels:
Microstation
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
Count different text formular: SUMPRODUCT((P6:P20="TEXTA")+(P6:P20="TEXTB"))
Count any letter formular: COUNTIF(P6:P20,"*")
Fomular input method: Ctrl+Shift+Enter
Labels:
Excel skill
Subscribe to:
Posts (Atom)