X-Section Reference

For a long time, it was a pain to find out the referance plane of an X-Section. Until I got this by accident.

Notmally I suppress each plane and see the messages to see if the says about the section I was looking for...

There are two easy ways.

(1) Keep the mouse over the section of interest and the datum plane name will be shown at the bottom left corner of the base window.

(2) Keep the mouse over the section for few seconds and the same will be shown next to the mouse..

Easy, isn't it.. until you know it !!!

Comments

Proe Function / Relation to round the decimal places

Its strange that ProE does not have a ROUND function. At least I counldnt find it. It has two funtions. Ceil will always round it up. Floor will always round it down. I have used both to get the ROUND functionality. here is the relation...

[ Read more » ]

TreeView Structure in Excel VBA

TreeView is extreamly useful in specific cases but it can be bit tricky sometimes to implement. Last Few days I was working on a TreeView Structure and thought I will share the knowledge I gained... This post takes you through the basic operations to create and operate a TreeView. It will be like the Folder tree window of the windows explorer. Moreover, you can have it dynamically updated based on the data in excel.... Here we go..

[ Read more » ]

Color the Excel row based on a value/status

Very often, we would like to differenciate the rows that are having certain status (or specific values in a specific column) in a different color. We can filter for the status and apply the color manually, but we can also do that dynamically or automatically with a specific tweak to the Conditional Formatting feature in Excel

[ Read more » ]

Tips by Joe (Proe, Excel...)

Search This Blog