-

Agile Project Excel Template

The purpose of this template is to provide a simple view of how an Agile project can be tracked. Most teams who already have tools should use this to guide them on how to customize the tool to provide this information.

If you have no tool yet you may use this to track a simple project BUT this is not a scalable solution! So once you’re past doing a Pilot and want to deploy agile beyond one or two teams you should consider using a tool to support your effort.

To download more project management resources please visit www.managementproject.net

Download Link

Baseline Narrative Schedule

Overview:

This Narrative Schedule will help you in when you are creating baseline schedule

Baseline Programme Narrative

Content:

-Baseline Programme Narrative contains Project Brief

-Baseline Programme Narrative contains Program Overview

-Baseline Programme Narrative contains Key Dates/Milestones

-Baseline Schedule Narrative contains Work Breakdown Structure

-Baseline Schedule Narrative contains Calendars

-Baseline Narrative Schedule contains Activity Codes & ID

-Baseline Schedule Narrative contains Construction Sequence

-Baseline Schedule Narrative contains Project Baseline Schedule

-Baseline Schedule Narrative contains Critical Path

-Baseline Schedule Narrative contains Engineering Schedule

-Baseline Schedule Narrative contains Procurement Schedule

-Baseline Schedule Narrative contains Histograms

-Baseline Schedule Narrative contains Work Breakdown Structure

-Baseline Programme Narrative contains Architectural Layouts.

-Schedule Narrative Template contains Project Baseline

-Schedule Narrative Template contains Critical Paths

-Schedule Narrative Template contains Engineering List of Shop Drawings

-Schedule Narrative Template contains Procurement Schedule

-Schedule Narrative Template contains an-Hours Histogram

Download Link

To download more project management resources please visit www.managementproject.net

Source : bibloteka.com

Procurement Planning Excel Template

Overview:

Procurement is important in project management, the critical part here when you do a construction project is when selecting the seller, supplier or a bidder when you failed on the selection, your entire project is at risk in terms of quality, scope, cost, and schedule.

Procurement Management Plan is another necessary component of the project management plan that addresses the procurement process, including documentation, managing & closure of contracts. This template is often created during the second step in managing construction projects.

Components of the procurement management plan

Stakeholder
Type of Contract
Documentation
Estimate
Schedule
Performance report
WBS
Bonds or Insurances
Assumption and Constraints
Risk

Procurement Planning Excel Sheet

-Procurement planning excel sheet can be used in tracking the procurement of materials

-Procurement planning excel sheet can be used in tracking delivery of materials

Download Link

Source : bibloteka.com

To download Free Project Management Templates you can visit www.managementproject.net

2 Weeks Lookahead Excel Template

Overview:

All Project managers need performance reports for the actual works & two or four weeks lookahead schedule for the future works of their projects. So, Tracking works of a schedule is the next step of preparing it. 4 Week Look Ahead schedules are commonly used in construction & energy industry to recognize what work will be done in the next four weeks.

Lookahead Excel Template schedule excel template teaches you how to successfully plan your project 2,4, or 6 weeks ahead. A look ahead is a perspective of your present project but looking ahead for 2 or 4 or 6 weeks so you filter data date + 2 weeks for a two weeks look ahead, or apply your progress focus and establish it to the weeks you need and you will only focus on the work that must be done for the next 2/4/6 weeks. This can then be specified more if necessary & is mostly applied to plan ahead and ensure you have the necessary tools & equipment and resources to enable the work to happen.

Lookahead Excel Template

-Lookahead Excel Template will help you in the presentation of the lookahead activities

-Lookahead Excel Template is useful for project managers in highlighted the lookahead activities

-Lookahead Excel Template will focus on lookahead schedules activities

Download Link

To download more project management resources please visit www.managementproject.net

Monthly Summary Dashboard Excel Template

Overview:

This Monthly Summary Dashboard Excel Template will help all engineers in creating monthly dashboard reports.

Excel Dashboard Template

Excel dashboards are merely good-looking worksheets that use small charts & tables. Daily, weekly & monthly reporting uses essentially the same process, but with different date formulas.

Before we start building queries, perform a layout review – remember that Excel is a spreadsheet tool that is restricted to rows & columns, and that columns are the same width all the way down the page & rows are the same height across the entire page, so you need to make the layout fit into those constraints. Another consideration is whether the page will need to be printable, which further restricts your design.

This report has a couple of tables of similar contents stacked one over the other & the rest is charts, which provide great flexibility. One concern is that the original report appears to have a square overall shape, which is fine for desktop screen presentation but could be a problem for printing.

Download Link

To download Free Project Management Templates you can visit www.managementproject.net

Construction Project Dashboard Excel Template

Description:

Every project manager needs a predetermined road map for following his/her own and the team’s progress with the project. The team can refer to this document which may be in the form of a spreadsheet. This also helps them follow their targets, keep up with the pace, create projections and assignments. These elements are made available in such a template.

Templates are easily available for free these days. A project manager can find a huge variety of such project management templates and can choose one on the basis of its suitability to the project.

A place where all the mentioned charts can be viewed easily is essential for a project. The project management dashboard provides this platform. This dashboard gives all the information in one single view.

Charts like issues, project budget, project risk, Gantt chart, to do lists are present for a project manager on the dashboard. The project manager can then take a glance at the charts with ease and dive deep into the ones he feels necessary.

The dashboard is applicable or rather essential for all the types of projects. It is, in fact, a must for the project lead to carry out his job with efficiency.

Download Link

To download More Project Management Templates, visit www.managementproject.net

Individual Risk Dashboard (Excel Template)

Overview:

Risk can’t be eliminated. Organizations, therefore, need to manage all the factors that increase & reduce those risks so that they can pursue a strategic advantage at minimum costs.
This includes risk classification which in turn supports better risk management. In view of the definition of risk as an unfavorable event capable of generating a negative sign deviation from a given expected situation, such as a smaller gain or a big loss.

Risk Dashboard Template

Risk dashboard is very important. They may generate in different areas (risk object, such as corporate processes or function), involve different stakeholders or external contacts & represent different levels of danger. From the risks, that today, worry businesses the most there is, for example, reputational risk a type of transversal risk that may exist in different corporate and governance areas, whose impact is potentially very big. Like the reputational risk many other unfavorable events, capable of threatening the achievement of corporate objectives, extend beyond the company’s individual functions & boundaries, thus tending to become difficult to foresee and monitor.
There is a growth of the phenomenon of different risks, which initially manifest themselves inside certain corporate areas but then have their consequences cascading through many other aspects of the internal & external management of the individual business.

Risk Dashboard :

-This Risk Dashboard is useful for creating a risk management plan

-This Risk Dashboard helps in identifying risks

-This Risk dashboard is highly recommended for project managers, risk analyst, planning engineers

Download Link

To download more project management resources please visit www.managementproject.net

Source: bibloteka.com

Earned Value Management Excel Template

Overview:

EVM integrates project scope, time & costs through periodic measurements of actual cost & work completion.

It views project progress in terms of cost as a function of time against a firm baseline set up at the project start. When the project is originally planned, it is divided into Work Breakdown Structure (WBS) & further sub-divided into work packages.

These work packages are assessed for cost estimates & scheduled in a time sequence. Taken together, WBS, master schedule & cost budgets form the baseline, represented as a graph of planned costs over time. This is the planned value (PV).

It tells how the costs will flow over time as planned. During the project execution, actual costs (AC) & the quantum of work completed are periodically noted.

Earned value Management Formulas

Completion of work is pro-rated to equivalent monetary value based on the budgetary costs for the work packages completed (work-in-progress packages are assessed on % completion).

This is the earned value (EV). These three numbers, i.e. PV, AC, and EV drive the operation of Earned Value Management. In detail, (EV – AC) measures cost performance and (EV – PV) measures schedule performance. When measuring at periodic intervals, EVM focuses on the flow rates of actual cost and completion against the planned cost and completion.

PV, EV, and AC make it possible to compute cost & time variances, as well as extrapolate how much cost & time would be required for project completion.

Simple calculations based on these numbers yield several ratios for project control. Of these, three ratios can be regarded as important: Cost Performance Index (CPI), Schedule Performance Index (SPI) & Cost Estimate at Completion (CEAC).

By giving historical & forward information about the project, EVM becomes a tool for monitoring & course corrections.

Earned Value Management Excel Template

-This Earned Value Management Excel Template will help you in your project

-This Earned Value Management Excel Template is helpful for creating CPI & SPI

Download Link

Source: bibloteka.com

To download More Project Management Templates, visit www.managementproject.net

Risk Register Example

Overview:

When it comes to project management, understanding risk & knowing how to minimize its impacts (or take full advantage of its opportunities) on your project are essential for success. The Risk Register is important to the management of risk. As risks are identified they should be logged on the register & actions should be taken to respond to the risk.

Risk Managers always try to reduce the likelihood of the risk occurring or the impact if the risk does occur. These responses are documented on the Risk Register & the register should always be reviewed to monitor progress. the Risk Register must be reviewed in every project team meeting. It should certainly be a review at the end of each phase of the project lifecycle. Risk management should be a constant ongoing process with the project team raising risks with the Risk Manager or Project Manager who then logs the risk and identifies actions that can be taken to mitigate the risk. To respond properly to a risk the Risk Manager may need to bring in experts to understand the actions that can be taken to reduce the likelihood of the risk appearing or the impact if the risk does occur.

Download Link

Source: bibloteka.com

Sample CPT Test Result

Description:

The soil classification, i.e. division into categories and subcategories with pertaining symbols enables understanding of mechanical behavior of soil under the influence of load.

Traditionally, soils were divided according to grain size into noncoherent or coarse-grained soils (gravel and sand), and coherent or fine-grained soils (silt and clay). Non-coherent soils are then categorized based on their relative proportion in the total mass of the soil tested, while coherent soils are categorized according to their plasticity properties. The procedure for describing and labeling of soils is called soil classification.

The world’s most widely known and used soil classification is the Unified Soil Classification System (USCS), created through modification of the Airfield Classification System (ACS). Classifications according to the British Soil classification System (BSCS) and the Deutsches Institut für Normung (DIN) are widely used in Europe [6]. Kovacevic and Juric-Kacunic developed the European Soil Classification System (ESCS) for engineering purposes, which makes use of the soil description and symbols in line with the European standard EN ISO 14688-1.

The system is based on soil classification principles prescribed in EN ISO 14688-2. In order to ensure compliance with the European guidelines for soil description and classification, Kovačević et al. placed emphasis on the need to develop information support for the implementation of ESCS and USCS in order to facilitate their parallel use, i.e. on the need to transfer to and adopt the soil classification that is in line with European guidelines.