Skip to main content

Posts

Showing posts from June, 2016

How to use data validation in MS Excel?

Data validation is a tool that reduces errors, it helps in making cells constraint to some particular values only.

MS Excel says " Data validation is an Excel feature that you can use to define restrictions on what data can or should be entered in a cell. You can configure data validation to prevent users from entering data that is not valid."

That means, using Data validation, you are controlling the cell values. You can allow people to enter data of their choice, but warn them once when they try to add it in the cell. You can also provide messages to show what kind of input you want for the cell, and instructions to help them correct if any errors comes in.

So, the question is, when is Data validation be helpful?


To give answer to this question, i can say, whenever you want your choice in a cell, data validation will be helpful. When you share your workbook, you want a predefined format to be followed by in order to get the accurate results from the entries. In such a case…

How to use Vlookup in MS Excel?

Hi friends,
Let us learn about Vlookup function of MS Excel. If, you have a big table and you dont want to drag your mouse each and every time you need some value from that table, you can use Lookup or Vlookup or Hlookup.  These are some of the best techniques of data extraction from tables. 
Vlookup is used to extract data from a table, follow these steps to use it.

How to change orientation of beams in STAAD.Pro. ?

Generally, beam starts at left and ends at right in X direction, starts from bottom and ends at top in Z direction, likewise for the case of columns, columns start at bottom and ends at top. If your beams and columns are not in right orientation, they can create confusion in results interpretation. So, you should always make the beam column orientation right before analysing the structure.

Here is how you can do it:



1. select beams parallel to x. (go to select - select beams parallel to - x)


2. Select Redefine Incidence (go to tools - redefine incidence)


3.There are 3 options viz.
Switch incidence of selected beam.Set the incidence order of selected beams o start node is closer to the origin than end node.Set the incidence order of selected beams o start node is farther to the origin than end node. 4. Select any one option as per your requirement. 

5. you have done it. Enjoy the best of STAAD.
Watch this video for example of how to do it. 

Some other STAAD Pro topics you may like to e…

How to load add-ins and make a customised ribbon button for it?

Hi,

Add-ins are the custom functions/commands/formulae or macros stored in an external file which can be used in any excel file to increase productivity.

In order to use Add-Ins, you should be allowing the add ins. to do that follow this steps.


1. Go to file -- options -- Trust Center -- Open trust center settings.



2. Go to Add-Ins tab -- Un-check all the tick marks of disabling add ins. If you want Add-Ins to be signed by trusted Publisher, check first option ticked.


3. Press OK. 
Now, to add the Add-Ins Follow these steps. 
1. Go to File-- Options -- Add-Ins -- Manage -- click on "Excel Add-Ins" -- press Go. 

2. You will be directed to Add-Ins already present, in order to add new ones, press "browse" button.

3. Excel add in folder opens. Paste your Add-Ins here. and select the one that you want to add followed by OK. you will be redirected back to present add-Ins. press OK again.  4. Add-Ins are added. 
To create a Customised Ribbon button for the Add-In that yo…

A program to extract beam design results from STAAD.Pro. ANL file.

STAAD Pro is a great analysis and design software. It gives us concrete desing results in output file. the navigation in the output file is so tedious that we usually like graphical/tabular results than navigating to output file. It does not give comprehensive beam design result output directly to excel. But, there is no stop to anything in this technologically advanced world.
We have prepared a program that extracts the beam design results from STAAD ANL files and puts the data in a specific format that you can use easily for detailing of beams. It's fast and easy and economical too.
here is a video showing how to use it.





Please find here the demo version of beam and column design results extractor:

BDR/CDR extractor

For buying it, kindly contact us @ info@tinytopic.in or whatsapp us at +91-9925015825

Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it useful. follow us to get more.


Build Your Own Website
4000+ templates, custom…

A Program to extract Column Design Results from STAAD.Pro ANL File.

STAAD Pro is a great analysis and design software. It gives us concrete design results in output file. the navigation in the output file is so tedious that we usually like graphical/tabular results than navigating to output file. It does not give comprehensive beam design result output directly to excel either. But, there is no stop to anything in this technologically advanced world.
We have prepared a program that extracts the column design results from STAAD ANL files and puts the data in a specific format that you can use easily for detailing of columns. It's fast and easy and economical too. 
here is a video showing how to use it.




Please find here the demo version of beam and column design results extractor:

BDR/CDR extractor

For buying it, kindly contact us @ info@tinytopic.in or whatsapp us at +91-9925015825

Hope you find it useful. Comment if you have doubts or suggestions. Like, tweet and + post if you find it useful. follow us to get more.


Build Your Own Website
4000+ te…

How to make DXF in Autocad and import DXF layout in STAAD.Pro?

Creating a centerline drawing from a beam column layout and exporting it as DXF will help it to be imported in STAAD.Pro. You can create the centerline the way you want, but here we have shown a method which is a quicker one we feel. The ultimate choice is with you about how to make it.

Here is a quick way.


1. Create 4 lines at two opposite corners.
2. Use fillet multiple to join them. you have made the bounding box.
3. Create lines in center where the beams will be coming.
4. extend them to the bounding box. Your DXF is ready.
5. select all the centerlines you just created and move them with upper left corner to 0,0,0.
6. Now, if your STAAD.Pro units are different than the CAD, scale your centerline drawing to the           appropriate scale factor.
7. write down "DXFOUT" command in command line. A saving window pops up. Select the location     where you want to save your DXF.
8. Go to tools -- ooptions -- DXF outions -- Check mark select object and chaneg 16 to 3 or the l…

How to fill out the cells with the value of cell above in excel?

Sometimes, a quick tip saves so much time that we feel amazed. This is such one tip to save your hours in the future work. Selecting blank cells and adding value to is a repetitive work, and, if we can make this repetitive work a one time work, the time of all the clicks for repetition can be saved. But the question is how to do that? here is a way.
Here, we will be filling blank cells with the value of non blank cell above. That means each blank cell will be filled by the non blank cell value of above cell encountered first.

1. Select the column in which you want to fill the blank cells.  2. go to home -- Find and select -- Go to special. 

3. Select blanks and press OK.

4. press "=" followed by upper arrow to add the formulae that write the value of above cell. 

5. Press "CTRL+Enter" instead of only Enter. 

6. Bingo, you have done it. 

Watch out the video and learn to fill blank cells faster than never before.



Hope you find it useful. Comment if you have doubts o…