Project Management Excel Template

Project Management Excel Template



Sifting through multiple documents to find the tasks worth reporting to leadership can be time-consuming and frustrating. With a project management dashboard, you can quickly communicate the status of your project and share the big picture view. Use the project management dashboard if you want to share the high-level status of your project with stakeholders.

Download Project Management Free Excel Template


LINK

Mechanical Design Engineering Handbook

Mechanical Design Engineering Handbook 

Peter R.N. Childs

Preference :

The prior knowledge base in design and engineering, as with nearly all domains, is extensive. We have been designing and producing a wide range of sophisticated machines and systems for centuries. The detailed design of many machine elements and types of machinery has been codified and significant expertise is readily available. Just knowing that someone else has successfully produced a product or system can act as inspiration or provide direction for a similar product or the design of a subsystem that uses associated technology, or needs to have comparable functions. Many attempts have been made at defining design. The word can be used as a verb or noun, describing the process and the outcome of design, respectively. Referring to design as a process, it can be considered to include all the activities of market assessment and user requirements, specification, concept generation and idea development, the embodiment of details, risk mitigation, consideration of manufacture and production, and implementation. Referring to design as a noun, the term is commonly used to describe an artifact such as a vehicle, item of fashion or other product, with the associated features and merits. This may include description or commentary on aesthetic, ergonomic, and technical features. In this book, an inclusive approach to design is used with consideration of a range of functionalities ranging from technical, aesthetic, social, economic, and latent. Design is considered to be the process of conceiving, developing, and realizing products, artifacts, processes, systems, services, and experiences with the aim of fulfilling identified or perceived needs or desires typically working within defined or negotiated constraints.


Mechanical Design Engineering Handbook


Content :
  • Design
  • Specification
  • Ideation
  • Machine Elements
  • Journal Bearings
  • Rolling Element Bearings
  • Shafts
  • Gears
  • Spur and Helical Gear Stressing
  • Bevel Gears
  • Worm Gears
  • Belt and Chain Drives
  • Clutches and Brakes
  • Fastening and Power Screws
  • Pneumatics and Hydraulics


Download Mechanical Design Engineering Handbook free PDF

LINK

Road Estimate Excel Sheet

Road Estimate Excel Sheet



Road Estimate construction costs may vary considerably depending mainly on the terrain and soil conditions, road standards, machine and labour costs, etc., as well as on the skill of operators and labourers involved. However, since road construction techniques are similar throughout the world, one can easily derive reasonable cost estimates once the main conditioning factors have been identified, by applying figures from similar road construction projects. For the purpose of facilitating your task in estimating forest road costs and for reasons of comparing costs, it is advisable to break down labour and machine costs into their different elements.

Download Road Estimate Free Excel Sheet


LINK

Project Management for Engineers and Construction

Project Management for Engineers and Construction 

Garold (Gary) D. Oberlender

Preference :

This book presents the principles and techniques of managing engineering and construction projects from the conceptual phase, through design and construction, to completion. It emphasizes project management during the early stages of project development because the ability to influence the quality, cost, and schedule of a project can best be achieved during the early stages of development. Most books discuss project management during construction, after the scope of work is fully defined, the budget is fixed, and the completion date is firm. It is then too late to make any significant adjustments to the project to improve quality, cost, or schedule to benefit the owner. Although each project is unique, there is certain information that must be identified and organized at the beginning of a project, before any work is started. Numerous tables and graphs are presented and discussed throughout this book to provide guidelines for the management of the three basic components of a project: scope, budget, and schedule. Throughout this book, achieving project quality to meet the owner's satisfaction is emphasized as an integral part of project management. This second edition of the book has three new chapters: Working with Project Teams, Early Estimates, and Design Proposals. The topics in these chapters are extremely important to achieving a successful project. These topics are- covered from the perspective of the engineer who is employed with either the owner's organization or the design firm.




Content :
  • INTRODUCTION
  • WORKING WITH PROJECT TEAMS
  • PROJECT INITIATION
  • EARLY ESTIMATES
  • PROJECT BUDGETING
  • DEVELOPMENT OF WORK PLAN
  • DESIGN PROPOSALS
  • PROJECT SCHEDULING
  • TRACKING WORK
  • DESIGN COORDINATION
  • CONSTRUCTION PHASE
  • PROJECT CLOSEOUT
  • PERSONAL MANAGEMENT SKILLS
  • TOTAL QUALITY MANAGEMENT


Download Project Management for Engineers and Construction free PDF

LINK

Power Electronics Devices, Circuits and Industrial Applications

Power Electronics Devices, Circuits and Industrial Applications

V. R. MOORTHI

Preference :

Power electronics is a branch of engineering that combines the fields of electrical power, electronics, and control. It started with the introduction of the mercury arc rectifier in 1900. The grid controlled vacuum tube rectifier, ignition, and thyratron followed later. These found extensive applications in industrial power control till 1950. In the meanwhile, the invention of the transistor—semiconductor device— in 1948 marked a revolution in the field of electronics. It also paved the way for the introduction of the silicon controlled rectifier (SCR), which was announced in 1957 by the General Electric Company. In due course, it has come to be named as the ‘thyristor’. There is one important difference between the earlier electronic tubes and their semiconductor successors. On the low-current side, the transistor is a base current controlled device whereas its predecessor, the vacuum tube, is a grid voltage controlled device. Similarly, the thyristor, which is designed to carry high currents, is a gate current-controlled device; it has succeeded the thyratron, which is a grid voltage-controlled gas tube.


Power Electronics Devices, Circuits and Industrial Applications


Content :
  • Thyristor Physics
  • Controlled Rectifiers
  • DC Choppers
  • AC Line Voltage Control
  • Inverters
  • Cycloconverters
  • DC Drives
  • AC Drives
  • Brushless DC Motors
  • Control Circuits for Electronic Equipment
  • Industrial Applications
  • Microprocessor Fundamentals
  • Microcomputer Control of Industrial Equipment
  • Field Oriented Control of AC Motors


Download Power Electronics Devices, Circuits and Industrial Applications free PDF

LINK

Design of Retaining walls against overturning and sliding forces

Design of Retaining walls against overturning and sliding forces



The purpose of this Excel sheet is to design the Retaining wall and check the adequacy of this retaining wall. against overturning and sliding forces retaining walls are used in the construction of the basement below ground level, wing walls of bridge and to retain slopes in hilly terrain roads. The retaining wall can be constructed with masonry as well as reinforced concrete. In the case of masonry retaining wall, the thickness of the wall increases with height because masonry resists the lateral pressure by its weight. Thus it is also called gravity retaining wall. While the reinforced concrete retaining wall resists the lateral pressure by structural action such as bending and results in a thinner section. A retaining wall is a structure that holds or retains the soil behind it. There are many types of materials that can be used to create retaining walls like concrete blocks, poured concrete, treated timbers, rocks, or boulders. Some are easy to use, others have a shorter life span, but all can retain soil.



LINK

Structural Analysis: The Analytical Method

Structural Analysis: The Analytical Method 

Ramon V. Jarquio, P.E.

Preference :

This book illustrates the analytical procedures for predicting the capacities of circular and rectangular sections in concrete and steel materials. It introduces the capacity axis in the analysis, which is a geometric property not considered in all the current solutions in standard literature. It precludes the use of the current standard interaction formula for biaxial bending, which is a crude and inefficient method. More importantly, the analytical method will prove the necessity of utilizing the capacity axis not only for determining the minimum capacity of a section for biaxial bending but also as a reference axis to satisfy the equilibrium of external and internal forces. Under the current standard interaction formula for biaxial bending, the satisfaction of equilibrium conditions is not possible. Proving the equilibrium condition is the fundamental principle in structural mechanics that every analyst should be able to do.


Structural Analysis: The Analytical Method


Content :
  • Chapter One: Footing foundation
  • Chapter Two: Steel sections
  • Chapter Three: Reinforced concrete sections
  • Chapter Four: Concrete-filled tube columns


Download Structural Analysis: The Analytical Method free PDF

LINK