Tips by Joe (Proe, Excel...)

Tips and tutorials related to Pro/Engineer, Excel (primarily) and others like Tcl/tk (occasionally)... I had started another topic on Arduino as well. Here I try to explore the underestimated and uncommon options...

Saturday, 21 May 2016

Today morning, my son found a dead bug with bright colors around our home. Suddenly I realized the opportunity for a stacked photo and swung into action. I wanted to do it for a while and this was good chance before the colors go away. below are couple of selected ones.

Friday, 13 May 2016

I tried to do the real stack using the automated setup. Below is the picture of the final image. Because of the shallow depth of field, I had to do a stack of 64 images to cover the scene. This is next to impossible to do manually. To put things in perspective of the magnification, I have added a hair as well in the frame.

Wednesday, 4 May 2016

As posted last time, I had received the rail. I have it integrated now. Also, i have implemented the camera triggering aspect. I am using opto-isolator for that. I got it all put together. Now I can use it for taking photos as expected. Here are some pictures of the setup.

Thursday, 21 April 2016

I had ordered some of the necessary elements and have started to do some of the basic stuff with each. I am yet to get the rail itself and it may take some more time. But for the testing I have just connected two wheels to the Stepper Motor.

Friday, 1 April 2016

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

Thursday, 25 March 2010

Sometimes its so happens that when you open an Excel file, it asks if the External Data needs to be updated or not. But you may not have intentionally given any external links. It’s an irritation then. But How to get rid of it?

Sunday, 22 February 2009

Through this post, I would like to introduce the Built in Functions of Microsoft Excel to a beginner. Let me put some excel functions that could be of use to those who what to make a start.

Before touching upon some of the functions, some introductions. The first thing that I would recommend for a beginner is to browse through the list of functions and its uses. At this stage, forget how it to be used, but keep an eye one what all you can do using functions. For that, go to INSERT -> FUNCTIONS. You will see the following dialog. Here you can either select ALL, or a specific category like TEXT. Now select a function and at the bottom, you will see what it will do. To find more detailed explanation, click HELP ON THIS FUNCTION.

Note: Click the cell with Function(s) and press F2 and you will be able to see the references in different colors.

Sunday, 26 October 2008

This post is to get you a very basic Animation that you can use if you are new to animation.
Proe Version : WF2

Quick Introduction:

ProE Animation is a typical ProE Module in the sense that sometimes its not easy to start with. But once you get the grip of it, its so easy and powerful. Most tend to think that it’s a hard think to crack but that’s NOT the case at all. I would try to post a few to get you started.

Friday, 26 September 2008

I modified the previous mechanism a little bit, and I got this. I removed the slot-follower connection and instead I added an additional pin connection which makes the wheel rotate about the vertical. That plus the manipulation of the tilting angle resulted in this. I think the rendering also is a bit better. It took almost couple of hours to capture the rendered video! But worth the effort..