### SOLVE - FOR option in Proe

Well, its a follow-up post. I had mensioned SOLVE-FOR in my previous posting. I thought of elaborating that a bit.

Basically it allows you to solve simultanious equation.

OK. Normally we have relations like the following.

A = F(B). { Eg A = 2B + Tan(B) }
now if you know B, you can find A.

Now what if F1(A,B) = F2(A,B), where F1 and F2 are different functions.
{eg 2B + A/Sin(B) = B * B * Cos(A) }
Now, even if you know B, you cannot easily find A. Here comes SOLVE-FOR.

B = 25
A = 10

SOLVE
2B + A/Sin(B) = B * B * Cos(A)
FOR A

By giving like this, proe finds the value of A.

You can extend this for multiple relations as well.. Like below.

You dont know the values of A, B. But you have two relations where A and B are valid. Two unknowns and two relations. Solvable, but not always direct.. here is an easy way..

A = 1
B = 1

SOLVE
F1(A,B) = F2(A,B)
F3(A,B) = F4(A,B)
FOR A, B

NOTE 1:

in both cases you would have noticed that I put a value before Solve option. This initialising is needed. Otherwise proe may not be able to solve the relation. Its good to initialise with a probable value.

NOTE 2:

As you may have seen in the previous post, this option may prevent the relations to be pasted properly when you do a UDF or a "Copy - Paste Special".

so thats it for another powerful feature of proe. Hope it helps..

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

### Controlling LED through Octolapse for 3D print timelapse

Today's post is about one of the 3D Printing adaptation that I learned. This is specifically about how to control an LED light automatically through OctoLapse so that it is switched on only when the timelapse photo is taken. Just as a background, I have been learning to use 3D printer and its customizations options for a few months now and was a lot of learning since then. The best thing was OctoPi, a platform for controlling the 3D printer and the many plugin options that are developed by the community.  Most of them are like open source. Today we will discuss specifically about an adaptation to one such plugin, OctoLapse. OctoLapse is the plugin for taking timelapse photos, with many options for further customisations. One of the best timelapse method is taking photo after each layer is complete, by moving the head out of the way. You can use standard Pi Camera or a DSLR, which is great to get good resolution videos. One small flash back before we dive into the topic.  I keep the