adsense analytic

Showing posts with label Excel Spreadsheet. Show all posts
Showing posts with label Excel Spreadsheet. Show all posts

Monday, February 12, 2018

Construction Project Scheduling

It is generally a mechanism for communicating about the tasks has to do and the organizational resources that will be assigned to complete all those tasks in the given time.
In simple words, a project schedule is a kind of document that gathers all the important works so that project can be delivered on time. A project is a collection of many tasks where each task has a fixed start and end to complete it in time though people have different schedules and their every detail need to be documented in order to successfully plan those tasks.
In past time, the project schedules were printed on calendars on a shared wall in the water-cooler room or shared spreadsheets via email buy in today’s scenario, most of the teams use online project scheduling tools.
As in the current scenario, most of the projects have many moving parts and they are continuously changing; so project scheduling software automatically upgrades tasks which are dependable and can’t completed on time. Besides that, it also provides automated email alerts so that team members can be aware about their scheduled tasks’ time and manager will know when someone’s availability has changed.
Methods to schedule a project: The following steps will discuss how a project is scheduled -
• Specifying Activities: there are lot of activities in every project and at first the important ones need to be listed, here a Work Breakdown Structure or WBS and a deliverable diagram will help to start these activities and to arrange them by projecting the necessary tasks to fulfill them in a right order.
• Make the estimates: After having the defined activities and dividing them into tasks, the project manager has to decide the time and effort to complete them in order to calculate the right schedule.
• Design dependencies: Tasks should be only started after completing the existed ones and it is the task dependency that is reflected in the schedule through these linked tasks. So make sure that the important ones should be on the top of the schedule to complete the project on time.
• Assign resources: At last, the project manager has to finalize the planned schedule as per the needed resources to complete those tasks on time. Make a team; assign them in the project so that all the tasks will be completed together on time.
Maintaining the schedule after the project is started: After scheduling every little object in a project, they need to be manually punched into an Excel Spreadsheet and any project management software can automate much of the process for the manager. There are some programs on the market that are useful for easy scheduling duties and while a project; the managers often need a tool that can fit with the variety of scheduling issues that need to track.
• Scheduling tasks: The project manager has to know about smart software that help to give enough flexibility for controlling many responsibilities attached with every tasks in the project. He can either add tasks and dates into the Gantt chart to keep a visual image of each task’s duration and if the dates change, they can be automated by simple drag and drop with the changes. The email notifications are a great way to keep the track of completing task and the update will be done automatically.
• Scheduling people: To complete all the tasks on time a project manager should assemble all the tasks at first and assemble a team which must be scheduled as per the task list to manage the project. A manager should be aware that team members may take holidays, personal vacation or days and he should schedule the project’s task list so that other team members can pick up the slow in their absence so that the schedule will not suffer. He can keep the task scheduling view on the Gantt chart with resource and workload scheduling features.
• Scheduling projects: Making a project dashboard will help to manage the tasks to be completed in a clean and easy way without any interruption or problems, in addition that he can also use the graphs and charts the dashboard that generate to drill down deeper and customize the results to provide the right information on the right time.
Project Scheduling

~~~~~~~~~~~~~~~~~~~~~~~~
Published By
Rajib Dey
www.constructioncost.co
~~~~~~~~~~~~~~~~~~~~~~~~

Tuesday, October 10, 2017

Download spreadsheet to assess wind load on solar panels

With wind load on solar Panels Analysis Spreadsheet, it becomes easier for installing Solar Panels on any roof. By applying this spreadsheet, one can verify whether it is reasonable to compute necessary ballast weight / fixings forces / roof loads from wind operating on Solar Panels (also known as solar modules, photovoltaic modules, photovoltaic panels or PV modules). The design adheres to BRE Digest 489.

This spreadsheet is user-friendly. The spreadsheet allows several automatic calculations and with the pop-up UK & Ireland map, it is possible to define the wind pressures on projected solar panels with a single click of the mouse. So, a normal house owner gets the ability to utilize this spreadsheet for making calculation of required ballast weight.

The spreadsheets can deal with the following types of Solar Panels:
Photovoltaic modules with ballast: This type of modules is free from any fixings into prevailing roof structure and therefore, it is not to get through current roof membrane. It makes the process simple for post-installing Photovoltaic arrays. The spreadsheet computes ballast weight necessary to resist uplift, sliding and overturning.
Photovoltaic modules fixed to flat or pitched roof: Pitched roofs are mostly found in UK and Ireland. For utilizing them to support PV modules it is required to settle load bearing components directly inside the roof structure. In this situation, it is necessary to workout fixing forces retaining a PV module and thus loads on a supporting roof. These calculations can be made with this spreadsheet.
The spreadsheet contains the following exclusive features :-
Features:
- Completely user-friendly;
- A normal house owner can use this excel sheet without any engineering knowledge;
- A comprehensible and easy to read output (all on a single page);
- Includes three PV classes:
1) PV modules mounted on or above pitched roofs;
2) PV stands mounted on flat roofs - free standing (with ballast);
3) PV stands mounted on flat roofs - mechanically fixed;
- Pop-up window for easy selection of wind loads inside UK and Ireland;
- Automatically works out dynamic wind pressure on the basis of site location, building size etc;
- User may overwrite dynamic wind pressure 'qs' and modify size effect factor 'Ca' if it was computed in another software;
- Automatically measures pressure coefficients for different situations;
- Covers open and enclosed support structures;
- For ballasted PV modules, spreadsheet evaluates sliding, overturning and uplift;
- For fixed PV modules, spreadsheet provides forces for which fixings should be designed;
- Live diagrams;
- Instant summary of results;
- Design is made by adhering to BRE Digest 489: 2004
Click on the following link to download the spreadsheet yourspreadsheets.co.uk
Download spreadsheet to assess wind load on solar panels

~~~~~~~~~~~~~~~~~~~~~~~~
Published By
Rajib Dey
www.constructioncost.co
~~~~~~~~~~~~~~~~~~~~~~~~

Friday, July 28, 2017

Brief demonstration of drywall estimating template in excel

This construction video tutorial provides the demonstration of user-friendly and spreadsheet based drywall estimating software.
It becomes difficult for the contractors to estimate and finish takeoff from drywall works. But this video shows how to make the process simple. In a drywall estimating process, the following steps should be included :-
Workout the Square Footage

Estimate Drywall Boards

Estimate Drywall Tape

Estimate Joint Compound

Estimate Drywall Screws

Estimate Corner Beads

Estimate Drywall Miscellaneous

Estimate Other Components

To learn the complete process, watch the following video tutorial.

Read more

~~~~~~~~~~~~~~~~~~~~~~~~
Published By
Rajib Dey
www.constructioncost.co

~~~~~~~~~~~~~~~~~~~~~~~~

Wednesday, July 26, 2017

How to design a beam in excel with coefficient method

This construction video tutorial sifts through the process for evaluating engineering drawing easily.
This construction video tutorial provides detailed guidelines on how to use excel based spreadsheet to design a beam. Here coefficient method is applied for designing purpose.
The calculation is made on the basis of the following drawings :-
a. Typical floor plan
b. Ground floor plan
c. Column Layout
d. Beam Column Layout
The coefficient method refers to a rapid hand-system that can be used for computing the moments in two-way slabs supported with edge beams. This method was initially contained in the 1963 edition of the ACI code as a method for creating design of two-way slabs which are supported on all four sides through walls, steel beams, or deep beams. The most recent version of the ACI code 318 does not contain the coefficient method but you can apply it for two slab systems with edge beams.
This method employs tables of moment coefficients for different types of slab edge conditions. The coefficients are dependent on elastic analysis but also comprises of considerations for inelastic moment redistribution.

To learn the complete process, watch the following video tutorial

Read more

~~~~~~~~~~~~~~~~~~~~~~~~
Published By
Rajib Dey
www.constructioncost.co

~~~~~~~~~~~~~~~~~~~~~~~~

Saturday, July 15, 2017

CSiBridge 2017 – The newest software for 3D bridge analysis

Computers and Structures, Inc. is the developer of CSiBridge. It is a very useful software for integrated 3d bridge analysis.

Modeling, analysis and design of bridge structures are incorporated into CSiBridge to transform the bridge design process to the next level.

The engineers can apply CSiBridge to easily determine complicated bridge geometries, boundary conditions and load cases. The bridge models are described parametrically with the jargons which are common to bridge engineers like layout lines, spans, bearings, abutments, bents, hinges and post-tensioning. The software has the capability to generate spine, shell or solid object models which are automatically updated with the modification in the bridge definition parameters.
With CSiBridge design, it becomes easier to design and retrofitting of steel and concrete bridges rapidly without any difficulty. By using the parametric modeler, the users get the ability to develop simple or complicated bridge models as well as create rectifications competently and at the same time total control on the design progression. Lanes and vehicles are described rapidly and comprise of width effects.
With the use of simple and practical Gantt charts, it is possible to simulate modeling of construction sequences and scheduling.
There is a simple wizard method in CSiBridge that offers the useful process to generate a bridge model.


CSiBridge is supported with the SAPFire® analysis engine along with staged construction, creep and shrinkage analysis, cable tensioning to target forces, camber and shape finding, geometric nonlinearity (P-delta and large displacements), material nonlinearity (superstructure, bearings, substructure and soil supports), buckling and static and dynamic analysis. All of these can be used with a single comprehensive model. Besides, AASHTO LRFD design is contained with automated load combinations, superstructure design and the newest seismic design.



Read more

~~~~~~~~~~~~~~~~~~~~~~~~
Published By
Rajib Dey
www.constructioncost.co

~~~~~~~~~~~~~~~~~~~~~~~~

Monday, June 5, 2017

How to Locate a Home Renovation Contractor

In order to start a renovation plan toward your home, you have to initially hire an architect. He takes the liability to create the designs which should be attended by a construction team. Then, it is required to find out and employ a professional home renovation contractor. This person will lead the construction team liable for building your renovation. A good contractor plays an important role toward any home renovation project. Given below, some useful tips on how to select a good contractor.

1. Search for a most experienced and knowledgeable contractor
Restrain from employing a novice contractor to supervise a renovation project on your home as there may occur very foul things which can lead to a severe amount of damage and it will be very exorbitant for you to resolve. If you prefer to hire an experienced a contractor, everything will be as per your plan.

You are going to incur significant amount of money for reconstructing your home. So, It is suggested to opt for a contractor who has been performing this type of work for a prolong period. Preferably, you should only give importance on hiring a contractor who should possess at least five years of working experience as a full-time contractor. It will make sure that the project will continue smoothly.

2. Get references from some of the people in your life who you trust
You should probably know some people who have already employed a contractor at some point in the past. If so, it will better to confer with these people and get help from the suggestions they provide. Are they satisfied with the work provided by their contractor? Did the person take a rational rate for the work they did? Did he show up on time? These are all critical things you should find out. Click on the link to search for the contractors online (renovationexperts.com).


3. How speedily will the contractor be capable of completing his work?
You do not prefer to wait around perpetually for your contractor to complete his or her work. So, make an estimate for the probable completion period of your project.

How to Locate a Home Renovation Contractor


~~~~~~~~~~~~~~~~~~~~~~~~
Published By
Rajib Dey
www.constructioncost.co
~~~~~~~~~~~~~~~~~~~~~~~~

Wednesday, May 17, 2017

How to analyze rates for a PCC work with spreadsheet

Parag Pal, the most promising civil engineer, has provided some useful tips for making rate analysis concerning plain cement concrete (PCC) through an excel based spreadsheet.
P.C.C alias plain cement concreate is a useful construction material that is formed by mixing in proportion of the cement (usually portland cement), aggregate (coarse or fine ),sand and water. It is normally utilized like a binding material. Pcc is robust in compression but feeble in the tension and shear. It is mostly found in foundation work and flooring in building.


PCC is mainly used for following purposes


1. It is applied like a protective layer for the RCC above to facilitate water from the RCC not being immersed by the earth below.


2. Arranges a base for the concrete as well as facilitates the workers to set out the structure above in an efficient manner


3. Performs as a cover to reinforced cement concrete i.e. protect against corrosion of steel bars in footings

Each construction project is allocated into number of activities. Each activity contains various types of civil or construction works. Rate analysis is necessary for removing cost of construction, material planning, labour and equipment allocation in the scheduling etc.


You can’t download the spreadsheet but make necessary modification in the spreadsheet online as per your database. Only the figure in given in red color can be changed and the result will be reflected to all the cells.


To avail the spreadsheet, click on the following link. www.civilnotess.com



~~~~~~~~~~~~~~~~~~~~~~~~
Published By
Rajib Dey
www.constructioncost.co
~~~~~~~~~~~~~~~~~~~~~~~~