Starting with Arduino.. Its exciting prospect.

Recently I came across a post about developing a automated focus stacking. It uses and Arduino based controller at the heart of it. You can then program the Arduino appropriately. I have had no experience with Arduino. But I have decided to do one myself. So watch this space for more updates..

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 » ]

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 » ]

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 » ]

Tips by Joe (Proe, Excel...)

Search This Blog