Thursday, 25 March 2010

Remove the external links from an Excel File.

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?

Thursday, 18 February 2010

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.

Saturday, 14 November 2009

Treeview Structure in VB.Net

In this post, we will look at how the Treeview can be used.

I am using Visual Basic 2008 Express Edition.

In one of my earlier posts, I had explained in detail about Treeview in Excel-VBA. Through this post, I would like to bring the VB.Net way of the control.

Wednesday, 10 June 2009

search and find all supressed features in proe

How to find all supressed objects in Proe (Pro Engineer) easily.. Yes, its easy.. no manual search is needed... Thanks to to ProE seach method..

Tuesday, 19 May 2009

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

Saturday, 28 March 2009

How to use VLookUp in Microsoft Excel.



Tool : MS Excel.
Topic : The function - VLOOKUP.



This is a very useful function to extract data from the table.

Microsoft says..
"Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table."

The format.
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)


Tuesday, 24 February 2009

How to Start with VB Programming (VBA) in MS Excel






The possibilities of using VB (VBA to be precise) is almost endless and it’s not too complicated (to do simple stuff) if you put bit of an effort and with a small programming background.


Sunday, 22 February 2009

Basics of Excel functions and relations.





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

Pro/Animation: Step 1 - A simple animation.

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

Wheel Rolling and falling. Made in ProE Mechanism.




This is the continuation of the previous post that I had.

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

Here is the video...

Thursday, 25 September 2008

Wheel Rolling and tilting. Made in ProE Mechanism.




This is a Mechanism (with Animation) of a wheel rolling along a guide curve, tilting on its way..


I was browsing through the PTC Forum and found a requirement. He wanted to simulate a wheel rolling along a curve with a possibility of tilting as well.

I have been playing around with mechanism options for my other task. So I thought of giving it a try.

Proe Files - Handling Old Versions.






This is typical view of ProE files saved in a folder. For a beginner this can be bit confusing and sometimes will lead to some problems.

What is it
Each time you save a ProE file, it creates an additional file (instead of overwriting it). file.prt, file.prt.1 etc. Next time you save and it will create another file with next higher serial number

Wednesday, 24 September 2008

Saturday, 20 September 2008

Exploding FootBall made and animated in ProE - Step 01



This is one of the fun I had the other day and thought I would share with you. Its not finished yet, but I thought of keeping it updated here as I progress. Check this out.

Monday, 15 September 2008

Answer to the ProE Puzzle 001



Here is my answer for the proe puzzle_001.
I must admit that, I could not fully solve my Qn. I will come to that later.


Friday, 5 September 2008

Compress ProE model beyond what a zip can do.



This is a something I noticed in the past and it an come handy sometimes. So here we go.

When you are in an urgency to send a BIG (in file size) ProE model over e-mail and the zipping is good enough then what would you do.

One possibility is to zip and split into multiple files and send as multiple mails. Then when you receive, you can combine and unzip it.

There is another way. For this you need a small tweaking of the model in ProE. What you do is to make insert mode at the beginning (you can leave one or two features at the beginning in resumed status) and the file size come really down. Don't ask me why. I don't know. In both cases you have the full information needed in the file. But one is very small !! Strange, isn't it.

Tuesday, 2 September 2008

How to dimension the arc angle in ProE Sketcher



How to add an angular dimension for an arc in ProE Sketcher Mode.

I have seen people creating radial construction lines at the beginning and at the end to insert the angular dimension. But thats not necessary. There is an easier way.


Select the ProE default options without clicking



Most ProE users may know this. This one is for those who missed out.

In ProE, the Middle (Scroll) Mouse Button acts like a Default selection.

In most commands of ProE, you will find one option in Bold. The straight forward option is to go there and click it. But pressing the middle button will select the default option automatically. You do not have to move the mouse at all. This also applicable in many Dashboard Commands and other like File-Open.

Save your precious time ! If you have not used it, get used to it now on.

Footnote:
You can configure ProE to have your default option changed as well.. Thats another post coming later..