Useful Commands of Advance Excel for its Optimum & Efficient Use

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.

Here are some useful commands to use excel more efficiently with less time consuming work

A] Commands for Excel Text Functions:

1] Len() : Returns the number of characters of a string.

    Syntax: =len(String). Here string means the position of cell

2] Rept() : Repeat given characters (S) specified number of times
    Syntax: =rept(string, number of times). Here number of times means the Repeat value of Character.

3] Concatenate() : Join multiple strings in one string 

    Syntax: =concatenate ( String1, String2, String3,.......)

B]  Commands for Excel Mathematical Functions : 

1] Sum() : Adds all the numbers given as an argument

    Syntax: =sum(numerical argument).

2] Product() : Multiply all the numbers given as an argument.

    Syntax: =product( numerical argument)

3] SQRT() : Return Square root of a number.

    Syntax: =sqrt(number).

4] MOD() : Returns Reminder

    Syntax: =mod(number,divisor)

5] Fact() : Returns the factorial value of a number.

    Syntax: =fact(number)

C] Commands for Excel Statistical Functions :

1] MIN() : Returns the smallest value from a list of supplied numbers.

    Syntax: =min(number1,number2,.......)

2] Max() :  Returns the largest value from a list of supplied numbers.

    Syntax: = max(number1,number2,.......)

3] Large(): Returns the kth largest value from a list of supplied numbers for given value k.

    Syntax: =large(datatable,k)

4] Small(): Returns the kth smallest value from a list of supplied numbers for given value k.

    Syntax: =small(datatable,k)

5] Count() : Returns the number of numerical value in a supplied set of cells or values

    Syntax: =count(value1, value2,.....)

6] CountA() : Returns the number of blank cells in a supplied set of values

    Syntax: =countA(value1, value2,.....)

7] Count Blank() : Returns the number of cells that satisfy a given criteria.

   Syntax:  =Countblank(data range)

8] Count If() : Returns the number of cells that satisfy a given criteria

    Syntax: =countif(criteria range, criteria).

9] Countifs() : Returns the number of cells that satisfy a set of given criteria 

    Syntax: =countifs(criteria range1, criteria, criteria range2, criteria.......).

10] Average () : Returns the avg of list of supplied numbers

      Syntax: =Average(number1,number2....)

Thus to use excel in effective manner we should go through the advance excel course.

BIM- Building Information Modelling

What is Building Information Modelling?

Building Information Modelling (BIM) is a term coined to deal successfully with the problem of fragmentation & error in the process of building project creation till its implementation.

Building Information Modelling essentially means developing a system which can house or manage all of the information needed in a particular project in a single DATA REPOSITORY that could be accessed by all project participants and readily incorporated into all project documents

BIM- Operational Network

BIM has a group of software's which are used to share the information with other so work in more simplified and efficient manner in which information can be Extracted, Exchange or Networked to support decision making regarding a building or any built asset. 

These cycle of project gets connected through BIM and it gets easier for all the departments to work in efficient manner.

BIM applicability in Construction, Real Estate, Infrastructure & Project Management (CRIP)  Industry.

A BIM can optimise overall construction time by highlighting bottlenecks & site constraints during construction work. In the USA, since 2007, it is mandatory to use BIM within the design process on any project funded by the GSA. Integration of BIM within the process may not reduce design & documentation time, but can minimize the efforts time and money required during the various construction phases. Moreover, good use of BIM improves participants efficiency &effective collaboration, thus speeding-up the entire process & produces operative information to run the facility. 

A review of literature focusing on BIM in India shows limited adoption of the same by the construction industry.Even today more than 90% of the architectural & construction firms are using 2D CAD based tools for designing & development of the project. It was found that some organisation are proposing integration of BIM based tools during bidding stage, however these tools are not the part of design development stages and other stages despite realizing the benefits such as improved efficiency.

Benefits through BIM Process

1. Design Visualization & improved design communication
2. Improve coordination & clash detection.
3. Automates the quantity take of process.
4. All building data at one place through data repository
5. BIM allows energy analysis for sustainable design at early phase of design.                    

List of Various Software's as Part of BIM Technology.

Architecture: Autodesk Revit Architecture, Graphisoft ArchiCAD, Nemetschek Allplan Architecture, Gehry Technologies.

Structures: Autodesk Revit Structure, Bentley Structural Modeler, Bentley Ram, STAAD & ProSteel, Telka Structure.