Something of Everything

Month: 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…

  • 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…

  • 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…

  • 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…

  • 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 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. But, there is no stop…

  • 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…

  • 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…

  • 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…