### ProE Puzzle 001

I thought it would be nice to learn if its put in the form of Puzzles. This is nothing but a modelling requirement. How would you do it?

Puzzle No: ProE_Puzzle_001
Puzzle type: Basic.

Here is the Qn. See the diagram. We have 2 sets of points. each set has 4 points. they are A1 to A4 and B1 to B4. The puzzle is to create a curve through the mid points of the lines A1-B1, A2-B2, A3-B3 and A4-B4.

The Modelling method should be such such that the values of x, y and the no of points in each set can be parametrically controlled.

How would you solve it? Leave your answer as comment.

I will post my answer in three weeks time.

[Edited on 15th Sep 2008]
[End of Edit]

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

### Excel Function :TABLE

Its been a while since I have done some posting. This option in excel is something which I thought would be very useful for many. Its the TABLE Function in MS Excel. This is especially useful in the following scenarios.

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