Thursday, December 31, 2009

Best of MyAeSI 2009 – study related

To mark the end of this year, for next few posts, I will list out the best of 2009 posts of MyAeSI. The posts will be arranged in the following categories.

  • Study related
  • Training and Skills
  • Career and Job related

This one deals with study related. Please enjoy the posts

  1. 3 tips to drive away exam anxiety while studying f...
  2. Coaching For AeSI- which one to choose
  3. Why Bangalore is not the right place for AeSI stud...
  4. 3 things to do when you receive the result.
  5. How to create a schedule or study time table that ...
  6. Not finishing section A in the stipulated 2 years
  7. TATA Nano can Help You in Your Studies!
  8. Will you choose earth science as your major in m tech?
  9. How to Study in 30 days
  10. Confidence should come from preparation not from questions
  11. 5 things not to do in AeSI for AMAeSI exams
  12. How to pass aesi?
  13. How I used to setup a study routine for new semester...
  14. 3 tips that you can apply to enhance your studies 
  15. Lazy routine that's easy to follow
  16. Teach - best technique to study effectivly
  17. Go for high quality books in AeSI
  18. 10 ways to show initiative in AeSI
  19. How to give a great start to a new semester? -
  20. 6 questions to ask if you didn't get 60%
  21. Why learning from a good teacher is essential
  22. Five ways of study to crack AeSI exams
  23. Which key will unlock aesi?


If you feel someone else will find this information useful then do pass this onto them.

Subscribe to MyAeSI via  rss or email

Wednesday, December 30, 2009

Momentum is everything

momentum is everything Momentum is everything. Whatever you accomplish in your life in a day, in a week, in a month or in a year doesn't matter, if momentum is missing.

What matters is that you are enjoying the present moment and feel good about it. That's the positive momentum I am talking about.

Right now I love the kind of days I have been spending and in the projects that I am working on. And instead of waiting of January, I have began most of my next years goals or resolutions from now only.

Because I want to enter the next year 2010 with a positive momentum. I don't want it to start with my starting 10 different things on that day. My goal is that when I enter next year on 1st January 2010, I already have the set habits that give me the push towards all the goals that I wish to attend.

So don't wait for January to come and planning things for the next year. Start today. Start now.

If you want to increase your skill sets, join a class today, if you want to learn a new tool, start Reading about it on Internet today. Want to read 30 books in the next year, start today. Want to loose weigh/gain muscles, begin exercising today.

Momentum comes with action. So start taking action TODAY.

Best of MyAeSI 2009

The year 2009 is ending in a day. I did blog the most on MyAeSI this year than I ever done since I began it five years ago.

So to mark the end of this year, for next few posts, I will list out the best of 2009 posts. The posts will be arranged in the following categories.

  • Study related
  • Training and Skills
  • Career and Job related

I will update the links to those post as they come up the blog?

Here’s a quote of the day for you all to ponder on..

jonathanfields: 92% of resolutions fail because they're largely outcome focused. This year, zoom in on the process, too.”

Meanwhile, tell me in comments what are the post that you liked the most.

Tuesday, December 29, 2009

Great Career Advice : just do stuff

Was reading this blog post at and loved the advice.

And therein lies the best career advice I could possibly dispense: just DO things.  Chase after the things that interest you and make you happy.  Stop acting like you have a set path, because you don’t.  No one does.  You shouldn’t be trying to check off the boxes of life; they aren’t real and they were created by other people, not you.

This is what my last year have been, but i would like to concentrate more on this in the coming year. Doing stuff that interest me.

We plan and plan and plan. Never realizing that we get stuck in the planning phase so get yourself in motion. Take a decision and then move forward and do stuff. This is the advice for the coming year.

While you are at the website mentioned above, you might want to read his ebook.

It has great advice on getting the job you want.

Sunday, December 27, 2009

Top 10 Post Graduate Universities of UK in Aero

Stumbled on this information, just wanted to share it with you all..

This is the list of TOP 10 Universities of UK for doing post graduate studies in Aeronautical and manufacturing engineering. for 2010!!



Same above thing in text, if your email doesn’t show the above image

Aeronautical & Manufacturing Engineering

Rank Institution Student Satisfaction Research Assessment Entry Standards Graduate Prospects Overall Score
1 Cambridge 4.10 3.35 564 92 100.0
2 Bristol 3.82 3.00 464 94 94.2
3 Surrey 4.33 2.90 355 96 92.9
4 Imperial College 3.50 3.05 490 84 91.6
5 Bath 4.07 2.60 460 86 91.4
6 Southampton 3.99 2.70 450 80 89.9
7 Sheffield 3.93 3.00 376 84 89.6
8 Loughborough 3.77 2.85 383 80 87.5
9 Nottingham 3.87 2.95 391 72 87.0
10 Queens - Belfast 3.78 2.75 342 82 86.2


Did any name surprised you? Are some university missing ? tell me in comments.

Friday, December 25, 2009

Study Techniques for Rapid Learning

StackOfBooks If you are an AeSI student and struggling with your studies or just want too improve your studies, then you might want to check this latest post at by Scott at titled 9 Tactics for Rapid Learning (That Most People Have Never Heard Of)

The one thing that i follow the most is the policy of total immersion..

"Benny Lewis became fluent in eight languages in under a decade. More, his current goal is to become fluent in a new language in under 3 months. When I asked him how he achieved this his answer was straightforward: “I stop speaking English. I do everything in the language I want to learn.”

When you’re totally immersed in a subject (or language), even if you’re lost, you’ll learn far faster than everyone who just dabbles."

Its one that I have advocated here in this blog so many times

The strategies listed by Scott are basic and we all use it at some point of time in our lives. The catch is to use them consistently everyday and every time.

If you have done the post exam post mortem... then you might want to inject this tactics into your life...

Merry Christmas to everyone!!

Thursday, December 24, 2009

What's cooking??

Ingredients_Healthy_Food Ingredients... That's what your skills are?

You can have many, you can have varied and but not all mix well. To cook something successful you have to create the right mix.

Mixing everything and putting them on stove wont produce anything eatable.

The soup you come out with, only gets cooked when you have that fire under you. But the taste and the success of it will depend on the ingredients you put into it.

Similarly in your career, the success and achievements you do is not dependent on the degree, college or stream you choose but on the ingredients that you pick and develop in the process.

Your AMAeSI degree, the stream you choose in section B are just the stove. CATIA, NASTRAN , ANSYS, coding, FORTRAN visual basic, communication etc are all the ingredients that will spice up your career.

So when looking at skills, see them as ingredients.

Look what you want to make or see at the ingredients you have. Then choose the soup you want to prepare!!

Read more on success in AeSI by clicking advice

Tuesday, December 22, 2009

The Known Universe

An incredible video that you all must see…


The Known Universe takes viewers from the Himalayas through our atmosphere and the inky black of space to the afterglow of the Big Bang. Every star, planet, and quasar seen in the film is possible because of the world's most complete four-dimensional map of the universe, the Digital Universe Atlas that is maintained and updated by astrophysicists at the American Museum of Natural History.

The new film, created by the Museum, is part of an exhibition, Visions of the Cosmos: From the Milky Ocean to an Evolving Universe, at the Rubin Museum of Art in Manhattan through May 2010.



Loved it!!

What do you say?

Explore many other video content on this blog by clicking videosONmyaesi

Exam over now do the post mortem!!

By now exams are over. Whatever has to be done in the examination hall
has been done.

So what to do?

It's the perfect time to do the post exam post mortem!!

Yes for all students you have given the exams this step is one of the
most important thing that you should do now!!

What is post exam post mortem?

Post exam post mortem is essentialy walking through your examination
paper and analysing of what and how you did it? What were the easy
questions? What questions stumbled you and why? What were the type of
question? How could you improve answering each?

Essentially post exam post mortem is all about calibration! It
calibrates your exam giving techniques, it calibartes you to do good
in the next exams!! It's about learning!

So take out the question papers and begin the post exam post mortem!!

The term post exam post mortem is from study hacks and if you are more
interested in how to do this post mortem check this link.

More AMAeSI exam related links at

Sunday, December 20, 2009

Call For Papers..

If someone is interested then look at this

Its a list of calls for paper for year 2010 from The Royal Aeronautical Society!!


for more information…

Saturday, December 19, 2009

A Quick Update on AeSI Meet

Many of the people I had a chat with some AeSI folks and they are under the assumption that you need to be a member of AeSIAA to come to the AeSI alumni Bangalore meet.

No that not the case..

If you have completed AeSI, you are already a member of AeSIAA. If you are studying for AeSI and intend to complete it you are a member again.

So go ahead. Register for the meet. Will meet you there.

I repeat being a member of AeSIAA is not prerequisite for coming to AeSI Meet. Just being in AeSI and having respect towards it is the only criteria.

Check more information here register

Hurry up, what are you waiting for.

And remember its a BIG fun filled picnic where we all want to have fun with friends and family. No boring lectures or something. So come and enjoy!


Friday, December 18, 2009

When is Learning fun?

Learning does not occur when you are in front of the book, it happens when you think through what you have studied, and finally put the two and two together. That's where real learning happens.

So when making a routine, do remember this simple fact. You will have much better study life.

Less time with books, more time thinking through them. Spend more time to discuss than mugging up formulas. Spend more time digesting and connecting the facts than writing tons of notes.

Follow it and you won't complain learning is not fun.

Related story : Reflection

Grab "After-AeSI Career guide to AeSI" ebook free

Thursday, December 17, 2009

Why not to go to AeSI Alumni meet?


  • Because you will meet old friends? So what's new. You meet everyone daily?

  • Because this a networking opportunity that you can miss? You have many mores to attend.

  • Because you hate AeSI?

  • Because you hate people who are in AeSI?

  • Because your are a student and don't feel its worth it?

  • Because you feel this things are just gimmicks?

  • Because there will be no job mela?

  • Because you don't want to waste a Sunday?

  • Because its lame to meet families of fellow AeSI.

  • Because you are a loner and don't need anyone help?

  • Because you will look stupid being the lone person there?


Well these are some of the genuine reasons that you might have to miss the AeSI alumni meet. If they are there then shun them right now. And join us.

The meet is no gimmick, its a real opportunity for all people involved or connected to AeSI to genuinely meet fellow AeSI’ian in an informal setting.

Its all about the community. It a BIG large picnic that you can enjoy with your family and friends.

Its an opportunity to meet, see and hear different people in AeSI. its an opportunity to network with fellow AeSI.

Its a fun opportunity to spend one Sunday doing fun things than sitting in front of TV.

So guys and gals, if you are in and around Bangalore on Sunday the 10th of January, then just mark your calendar and be part of this meet and be prepared enjoy a day with everyone.


Don’t be afraid, the resort looks cool and a whole day of family and non family fun is guaranteed.

So start your new year with this event and dismiss all those imaginary reasons that you might have for not attending AeSI alumni get-together.

what are you waiting for? click this link to register online. and lets get together!!

Please pass this message on to others who might not know about it.

Cheers, see you there!!!

Its Raining eBooks

What are you going to do after exams?  One of my last weeks posts mentioned this question an done suggestion was read books.

But books are costly, so then read free eBooks available on internet. Here is something for anyone who is thinking walking on that path...

NASA eBooks are introduced this month. They will features books related to NASA and its research.

Here's what NASA website has to say about it.

"Available on the NASA aeronautics research Web site, the e-books can be downloaded at no charge for use with the Kindle™, SONY® Reader and, eventually, the nook™. Other formats for those without an e-book reader will be available as well.

The first NASA book to be made available is X-15: Extending the Frontiers of Flight by Dennis R. Jenkins. The book tells the story of the pioneering rocketplane that tested the limits of aviation during the 1960s and directly influenced the design and operation of the space shuttle. "

This is the URL to follow

Right now it just have two books, be sure to subscribe to new eBooks RSS at

On the topics of eBooks, have you grabbed the copy of myAeSI  eBook


Wednesday, December 16, 2009

Walk-in at Goodrich Aerospace Services (P) Ltd On 19th December

Walk-in at Goodrich Aerospace Services (P) Ltd On 19th December

Just got this in my email. If this excites you then go to the walkin.

And even better Spread the word! Tell your friends. Email it.

About the profile : Engineer - Design (Job Code : 7676) / Senior
Engineer- Design (Job Code : 7700)

Hands on experience in design and development of Aerospace structures
components using Catia V5, Enovia, MBD. Good knowledge of GD&T.
Knowledge of design quality, manufacturing process.

Qualification : BE-Mech/Avionics with around 2-6 years of relevant
work experience is essential.

Incase the above opportunity excites you, please attend the walkin
Interview on

Date : Dec 19, 2009

Timings : 9.00 am to 3.00 pm

Venue details

Goodrich Aerospace Services (P) Ltd.

Sy Nos 14/1&15/1, Maruthi Industrial Estate,

Phase 2, Hoody Village, WhitefieldRoad,

K R Puram Hobli, Bangalore 560048


Tel (Board) : 0091 80 673 70000
Landmark : Near Hoody circle, next to Bhagini Restaurant

Candidates from outstation & all those who are unable to walk in,
please mail your resume to mentioning the
relevant job code in the subject line.

More tips on walkin click the following link

Tuesday, December 15, 2009

What is the History Of MATLAB?

clip_image002Many of you know that if I am asked about a programming language for a novice who has never programmed before, I always suggest matlab. It shouldn’t comes as surprise that I love this tool. I had great time learning and developing tools on it in my previous works.

So here’s a little story of How MATLAB began and I want to share with you.

This story also highlights how “small side hobby” explorations, sometime take off in such a big way.

So ladies and gentleman , sit back and enjoy the fascinating history of matlab!!

In the mid-1970s, Cleve Moler and several colleagues developed the FORTRAN subroutine libraries called LINPACK and EISPACK under a grant from the National Science Foundation. LINPACK is a collection of FORTRAN subroutines for solving linear equations, while EISPACK contains subroutines for solving eigenvalue problems. Together, LINPACK and EISPACK represent the state of the art software for matrix computation.

In the late 1970s, Cleve, who was then chairman of the computer science department at the University of New Mexico, wanted to be able to teach students in his linear algebra courses using the LINPACK and EISPACK software. However, he didn't want them to have to program in FORTRAN, because this wasn't the purpose of the course. So, as a "hobby" on his own time, he started to write a program that would provide simple interactive access to LINPACK and EISPACK. He named his program MATLAB, for MATrix LABoratory.

Over the next several years, when Cleve would visit another university to give a talk, or as a visiting professor, he would end up by leaving a copy of his MATLAB on the university machines. Within a year or two, MATLAB started to catch on by word of mouth within the applied math community as a “cult” phenomenon.

In early 1983, John Little was exposed to MATLAB because of a visit Cleve made to Stanford University. Little, an engineer, recognized the potential application of MATLAB to engineering applications. So in 1983, Little teamed up with Moler and Steve Bangert to develop a second generation, professional version of MATLAB written in C and integrated with graphics. The MathWorks, Inc. was founded in 1984 to market and continue development of MATLAB.


Read more MATLAB related posts concerning AeSI clicking MATLAB for AeSI

Subscribe to AeSI via email or Rss

Get Free Ebook “After AeSI – career guide to AeSI” by clicking here

Monday, December 14, 2009

‘After AeSI - career guide after AeSI’ launched ………(finally!!)

I know regular reader will add finally to the title of this post. Yes finally the ebook has been launched.

If you are a recent reader you can read all about my attempt to puplish this ebook here

Thanks to the steady connections that i have now and thanks to the routine that i have setup that made me cut out some time to get it done this year, the ebook is here finally!!!

What is it about?

Well its about AeSI and the things that myAeSI is all about. Its about you? Its about AeSI.

The only thing improper about the whole book that i feel is the name . Its not just about After-AeSI. Its about AeSI and how best to navigate it!!

Its about the journey, the destination and beyond.

I receive lot of emails regarding different topic that i write on myAeSI blog and this ebook is in essence the reply to all those questions. Its the compilation of al the posts that i keep refereeing back to people.

In shorts this ebook is the gist of myAeSI. So most of the important post that you might not have time to check at the achieve can be found here and i have made an attempt to organise them in this book, so that as a whole the content make sense.

Hope you will find this useful. if you do. do pass it on and let me know?

Do send it to your friends and folks who do you thing will benefit from it.

If one of you gets benefit from this ebook, i will consider it as a success.

How to download?


  1. Fill the form and Submit
  2. Get the download link for the ebook, which is in the pdf form.


Sunday, December 13, 2009

Lets Go Back in Time?

In 2005 i joined NAL as a trainee still having to clear one paper. At the same time i began a new personal blog to pen my thoughts on this. That time i made the blog private and it was private for so long.

today i decided to open it up and when i was linking to it in this blog.

then i learnt that i can meagre the posts with this blog. So that is what i did.
i merged all the post with myAeSI and you can find them in this blog.

All are posted in the relevant dates..

if you are interested you can check the entries at the following links.

All the post on those days were small, since reliance first cdma mobile was my primary access to net and i posted the updates from it.

here’s an example from the post. Posted on

Sunday, October 16, 2005

Most important lesson....

Most important thing i have learnt in NAL till now is that software's are just tools, and the work is the core. So learn the core tools will automatically follow. Tool without work is waste.

It was like twitter for me back in 2005!! Short simple, straight to the point.

And if you see your name, mention and have a issue with the post, i will modify it according.. just mail me back.

cheers and lets go back in time!!

For everyone who is using excel, here's a little advice

For everyone who is using excel, here's a little advice from

I’m sorry to break this to you, but if you spend your time analyzing data and Excel is your primary tool, then you must use VBA. I’m not telling you should be a programmer, far from it. But you should be able to record a macro and make some simple tweaks. There are many repetitive tasks that can easily done using three lines of code.

Unfortunately lost the source of the quote but very true.

Here's the learning stairs route that I can suggest for anyone wanting to master excel.

  1. Learn the 50 common basic formulae.
  2. Learn the useful shortcuts of excel
  3. Then go for recording small macros!
  4. Then start tweaking it.
  5. Next read more about VBA and apply it in editing your macro.
  6. After this to excel help file and pour over it's documentation.

This are the steps. There is no direct lift to VBA programming. Learn this via this steps you will climb much faster.

Good luck!

Saturday, December 12, 2009

Take part in Annual AeSI Alumni Get Together

2nd edition of Annual Alumni and their Family Get Together for Alumni residing in and around Bangalore is planned with a contributory Lunch, the preliminary details of which are given below:

Any and every AeSI alumni and their family/friends as well as student members residing in and around Bangalore shall be considered to attend this.

The details are:
1. Date for the Get-together: 10th JAN 2010 (Sunday)

2. Time:  8:30 to 17:00 hours
3. Venue: The Confident Cascade Resort.
4. Program:  Includes -
-        Reporting-(8.30-9.00) Breakfast (9.30-10.00AM) + Lunch (1-2 PM) + Tea (4-4:30 PM)
-        Music - to everyone’s taste (English/Hindi Movie based)
-        Quiz, Family & Children Events (Alumni Spouses to organize, Please volunteer for this).
-        All facilities in the Resort available free of cost to all participants. Fun Guaranteed for everyone!!
5. A 30 minute AGM/ General Body Meeting of Alumni to consider & pass Last Year Accounts & Discussion on Election of  New Office Bearers for the Year 2010-12.
Anticipated Expected Damages:

Per head: Early Birds: 575/- (Through Online registration**) &

On Spot: Rs.600/- (at Resort)

**Follow the link below for online registration
1. Most of the information regarding the event is already declared to this group, further information can be requested from Co-Ordinators or Office Bearers of AeSIAA.

2. Registration is on and a separate database is already circulated through mails/group to keep a note of those who wish to join and attend this get together. Such members shall have to give the number of members attending from his/her family, including himself/herself.
2. We shall need volunteers for children and family events/sports/etc and members are requested to come forward with suggestions. A mini-committee may get formed for this purpose. Further mails may be sent to interested volunteers from coordinators.
3. Help may be needed in form of car-pooling to get the nearby members picked up and dropped before and after the meet, respectively. Therefore, while informing the willingness to attend, one needs to give the location in the city, which may be helpful in organizing the car-pooling etc.
4. Fresh Nomination for office bearers and committee members shall be invited during the general body meeting, so un-necessary waste of time during next AGM could be avoided.
If you are aware of any AeSI Alumni residing in Bangalore BUT not member of this group, please forward this message.

Here are some links to wet your appetite

The Resort

For those who want to know what they missed last year, here's the link

To register click this link.

of fill the form shown below

See you all there!!

Use tab buttons to move through the form

Friday, December 11, 2009

How was your week?

How was your week? Mine was great.happy child productive work

The week that went by was by far the most productive week of this year. I completed so many little milestones that I feel happy about it.

So what were the things that made this possible?

In the beginning of the week, I decided to bring two principles into my life.

One was to work on something significant each day. Or in other words have a long term project and work on it at least one hour each day. And the next thing I incorporated in my life was planning the next day before I went back to sleep. Each night, before sleep I made 30 mins schedule for things I will do tomorrow.

These two practises has practically improved my work and has made me very productive. Ever since I have not wasted any hour and each hour is filled with some purposeful action. My Internet usage has also changed as I am using it more usefully and don't see myself loitering from one webpage to another.

Just wanted to share this with you in the hope that some of you might try this in your own life.

Please let me know how it goes in the comments below?

Thursday, December 10, 2009

Free e-Notes from IITs to all engineering students

image Rakesh shete informs us this about e-notes from IIT’s. Please do check and see how useful they are.

Hi Engineering Students,
Please utilize this link for any online course content. It is very useful.

NPTEL - National Programme on Technology Enhanced Learning

The IITs have taken up an initiative of starting online teaching and thus have started offering course materials online for every engineering stream. Many professors from all the IITs have provided course materials for each chapter and each subject. One has to register at the link provided below and can access the course material free of cost.

Every Chapter has been described with diagrams and charts. Please spread this message to everyone, as many can benefit from this program taken up by the government and IIT. This is just a trial period going on and hence I request everyone to register at the link given.

1] Type the following address on internet explorer
2] Click on Courses
3] Sign up as a NEW USER
4] And one can access any course material.

Do tell us what do you think of the materials there.

Thanks Rakesh for sharing.

Find more materials by clicking IIT

Wednesday, December 09, 2009

List of 50 common excel worksheet functions

This is the list of 50 common excel functions that I use on regular basis for all my work related task. I think anyone doing work on excel on regular basis should be conversant with all these formulas.

See how many of this do you know?


Returns the absolute value of a number. The absolute value of a number is the number without its sign.


Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to pi.


Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose sine isnumber. The returned angle is given in radians in the range -pi/2 to pi/2.


Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose tangent is number. The returned angle is given in radians in the range -pi/2 to pi/2.


Returns the average (arithmetic mean) of the arguments.


Uses index_num to return a value from the list of value arguments.  Ex. CHOOSE(index_num,value1,value2,...)


Returns the column number of the given reference.


Returns the number of columns in an array or reference


Joins several text strings into one text string. CONCATENATE (text1,text2,...)


Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers. CONVERT(number,from_unit,to_unit)


Returns the cosine of the given angle.


Counts the number of cells that contain numbers and also numbers within the list of arguments. Use COUNT to get the number of entries in a number field that's in a range or array of numbers


Counts empty cells in a specified range of cells.


Counts the number of cells within a range that meet the given criteria


Returns the sequential serial number that represents a particular date DATE(year,month,day)


Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.


Converts radians into degrees


FIND finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first character of within_text.  FIND(find_text,within_text,start_num)


Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array


Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.


Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE


Returns a value or the reference to a value from within a table or range.


Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself


LEFT returns the first character or characters in a text string, based on the number of characters you specify


Returns a value either from a one-row or one-column range or from an array.


Returns the relative position of an item in an array that matches a specified value in a specified order.


Returns the largest value in a set of values.


Returns the smallest number in a set of values.


Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).


Returns the serial number of the current date and time.


Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.


Returns the number 3.14159265358979, the mathematical constant pi, accurate to 15 digits.


Returns the result of a number raised to a power. POWER(number,power)


Returns an evenly distributed random number greater than or equal to 0 and less than 1.


RIGHT returns the last character or characters in a text string, based on the number of characters you specify


Returns the row number of a reference.


Returns the number of rows in a reference or array.


Returns the sine of the given angle


Returns a positive square root.


Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).


Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; SUBSTITUTE(text,old_text,new_text,instance_num)


Adds all the numbers in a range of cells.


Adds the cells specified by a given criteria.


Returns the tangent of the given angle.


Converts a value to text in a specific number format. TEXT(value,format_text)


Returns a vertical range of cells as a horizontal range, or vice versa.


Removes all spaces from text except for single spaces between words.


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.


Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default.


Returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999


That’s it. Read more excel related post by clicking on excel

Subscribe to my-aesi via mail or rss by clicking subscribe

Tuesday, December 08, 2009

How to plan for Next Year?

Its December!! the time of the year at the end of which everyone is busy planning what to do for the next year. Thinking of ways on how to make it more fruitful, enjoyable, productive and successful than this year.

Well i have began planning for the next year and here i would like to suggest a simple process that one can employ to better plan for his/her next year professionally.

The plan is simple and here it goes.

update your resume.

Yes update your CV, update it with all ten things you have done this year. In this year you would have added new skills, gained new experiences, managed new projects, attended trainings and taken up new responsibilities. update them all.

What would happen. well this updating process will help you see where you are now, this will enable you to gauge your current potential , this will tell your current bearing and only after this exercise plan for the next year.

Set professional goals now after gaining clarity on what’s your current objective status is . Then set your goal a tad higher than what you initially thought. Be audacious. Be bold. This is your life and how you push yourself will determine how you will succeed.

So go ahead and enjoy

Monday, December 07, 2009

How to separate yourself from the rest of the class?

Question: How to separate yourself from the rest of the class?

Answer: Raise your hand.

This is the simple and the most effective technique of separating yourself from the crowd. Raise your hand to ask question, to answer, to put forth your suggestions and to suggest or to raise a doubt. Majority of the people are afraid to ask this questions. They hesistate and think they might make a fool out of them, They wait, and they fail.

To be successful in any endeavour, you need to be noticed and raising your hand is the best way to utilize this opportunity.

From office meeting to class lectures, from training rooms to casual encounters, you will be asked your opinion, ask to raise question, offer suggestions.

Don't duck this opportunities, use them as levers to success

Sunday, December 06, 2009

What AeSI graduates should learn instead of CATIA?

Should you learn fortran or c, or Catia or ansys? This is the question
being discused at the Eng-Tips Forum.

I liked this response:

"I can think of about 10 things that undergrad engineers should learn
instead of Fortran.

1) How to spell
2) How to make an outline of a report before starting to type
3) How to use Excel the way it's designed
4) How to turn off MSN while at work
5) How things in their field of interest are manufactured
6) How their employers actually generate income and profit
7) How and where to find which design loads to use
What "design requirements" are.
9) How to work with others
10) How to talk to clients
If you wondering about what to start after the aesi exams, give this
simple ideas some thought.

Subscribe to myaesi at

Saturday, December 05, 2009

“Why” you do something far outweighs the “how”

"Why" you do something far outweighs the "how" you will get it done.

When your brain picks out a target with a strong enough "why" to go for it – you will achieve your goal. You will find the help, you'll get the education, you'll seek out the experts and do whatever it takes to make it over the top.

This applies when you are in AeSI, when you joined NAL etc for training or when you are learning a new software tool or when you in a job.

Know why you want it. How will always follow!!

Read more about how and why by clicking this link

Subscribe to myaesi via email

Friday, December 04, 2009

6 things that you can do after the AeSI exams

Here's a list of 6 things that you can do after the AeSI exams. All this things are simple and easy to do and are aimed to rejuvenate you from the life that every AeSI student face in the run-up to AMAeSI exams.

  • Relax give yourself a treat.
  • Start a side project unrelated to AeSI
  • Read a book
  • Learn about all goggle services
  • Start a blog
  • Immerse yourself in tons of movie and music
The point of all this is to forget studies, AeSI and explore. Exploration is the path to new discovery.

Do tell me what you decided to do?

subscribe to my-aesi via

Thursday, December 03, 2009

What my learning of excel can teach you in learning CATIA, ANSYS etc?

Learning a tool is like climbing a multistorey building on ladders, They don't always go straight. They go one level, stop and make a turn and then you move on to the next stairs which lead you to the next lavel. 

This is what happens when you learn a software tool, like catia, ansys etc. You don't become a master in that software in one stretch of time. You learn in levels

When i was learning excel, i saw this very clearly. I learnt all the formulas in excel and began applying them in my work and play. After few weeks practise and reading and experiments, i was comfortable with the formulas and this ability came as great help to me at that times work. After a time, my learning of new thing in excel stopped as i was able to do most of the things in it with what i already new. so on the learning excel front, i have reached one level and i wasn't climbing any higher.

This remained till i came to NAL, where i was supposed to debug and modify a existing vba level program, this let me see the next stair that i have to climb in excel and sooner i was enjoying the next stair. the learning and experiments were furious in this phase. I learnt a lot and tasks that took hours were accomplished in minutes, the productivity of excel increased drastically. I continued to learn and apply. But, as before, after certain time i reached the top of this stairs and gradually my learning new things again slowed down to zero. I was applying what i knew but was stagnant on learning anything new. The current stairs just took me to this level. 

I had to find starirs to the new level now. 

This happened a year latter when I was assigned to a new project where I have to work on a program that was entirely sitting on excel. this was the stairs of advance vba and this is when i learnt more deeply about vba in excel and its capabilities. 

So the point is that there are steps or levels in learning a  software. Each stair leaves us to one level higher, then we need to find the next steps and climb one more level. This is a continuous process. All institutes will lead you to one level or the next. After that its your own initiative to climb higher. 

And the best way to find and get to the next level is to challenge yourself to move to the next level or to take on an extra responsibility that takes you to that next level.

Wednesday, December 02, 2009

How to solve problems that trap you in the circle of inaction?

If I look at the mass, I will never act. If I look at the one, I will -
Mother Teresa

Are you looking at many problems or looking at one. Majority of the
times seeing a string of problems hinders us to make a move.
Concentrating on one make us act.

Recently I was presented with a situation where everything seemed to
fall over me, deadlines were looming, personal affairs were demanding
my time, the banks were sending notices for bill payments and so.

For many days I resolved to address each and every problem but
whenever I sat, the sheer number and details prevented me to act on any.

But then situation overlaped and I had to resolve the most urgent
issue and this solving of one issue freed me. It cleared the mental
clog and i handled all the rest of the problems in no time.

Thanks Mother Teresa!!

Do remember this if problem ka 'chakraview' traps you

Tuesday, December 01, 2009

4 words for successful exams

Read,Think,Write, Review

Read the questions carefully. Understand what is being asked. Understand the length of answer demanded and the depth required.

Think of the answer. Plan the response. Judge if its the answer that the question is asking for?

Write the answer as planed. Stick to the plan, stick to the question and answer to the point.

Review the answer written. Re-read your answer and judge if that's the answer demanded by the question!

that's it. we all do this unconsciously in the examination hall, but this time do it consciously and see how it improves your exams.

if opportunity doesn't knock, build a door

I just discovered this entry in my journal which i wrote when I was doing training in NAL. And i think its still relevant now, so posting it here

A very common thing that I gave heard my co-trainees say while in training is "where is the work" ? Yes i admit, this comes as a part of life, you are in government institution and i expect delay, lethargy and some of it will wash down to you, but then this is no reasons to be disturbed.

Three things are always with you, your initiative, your intelligence and motivation.

So why fret and make your life more frustrting by repeating no work , no work.

Aree yaar you are aesi guys, aesi products and one they don't lag behind is self study, self enhancement. The fact some of you are here is this self-reliance. So Use it.

You have access to top class softwares, use them, learn them, increase familiarity with them. This is the way to uilize your time there, if your scientist doesn't give you the kind of work you want, then remember this quote from TOI said "if opportunity doesn't knock, build a door". Always have this in your mind.

A few simple steps can help you to clear this frustrations. Stagnancy is death, so keep flowing

Search This Blog