-

Autodesk Spreadsheet Calculator for RSA Pro 2013

Engineering spreadsheet environment and spreadsheet hosting application with embedded links to Robot Structural Analysis products, allowing users to integrate their spreadsheet applications and communicate with Robot Structural Analysis.

Spreadsheet Calculator consists of a set of simple and complex calculation schemas for many areas of structural engineering. It provides a practical representation of codes and standards that can be used when performing calculations as well as detailed formulas for specific engineering problems. You can create complex calculations by selecting simple problems.

You can also add custom calculations to the existing schemas or create new schemas using the Spreadsheet Calculator tools. This way you can build a library of custom applications. Parameters can be exchanged between schemas so the output of a given calculation can serve as the input for other calculations.

Spreadsheet Calculator program is an open system.

You can have an unlimited number of new schemas, codes, libraries, languages.

Because Spreadsheet Calculator is built on COM technology, you can exchange information among other programs and engineering tools.

Output from Spreadsheet Calculator can be read as input into the Autodesk Robot Structural Analysis program. There is no need to type the information.

You can generate structure models using the Autodesk Robot Structural Analysis program.

You can perform a detailed analysis of structure data.Calculations are presented as complete technical documents containing detailed formulas, code references, and drawings. A generalized schema of a library module as well as its graphical form is maintained for all engineering problems.

Download link

Bar Bending Schedule Of Box Culvert

Definition of Bar bending

It is the method of bending reinforcing steel into shapes which are important for reinforced concrete construction.

Definition of Bar bending schedule(BBS)

Bar bending schedule alias schedule of bars refers to a list of reinforcement bars, a specified RCC work item that is shown in a tabular form for a smooth view. This table sums up all the necessary particulars of bars ranging from diameter, shape of bending, length of each bent and straight portions, angles of bending, total length of each bar, and number of each type of bar. This information can be used for making an estimate of quantities.

It includes all the details essential for fabrication of steel like bar mark, bar type and size, number of units, length of a bar, shape code, distance between stirrups (column, plinth, beam) etc.

While generating bar schedules, it is important to take proper care about length. In case of bending, bar length will be raised at the bending positions.

Benefits of the Bar Schedule:

When bar bending schedule is applied along with reinforcement detailed drawing, it makes the quality of construction superior.

Once bar bending schedule is prepared, cutting and bending of reinforcement is performed at factory and shipped to job site. This improves quick implementation at site and minimizes construction time and cost as fewer workers are needed for bar bending. Bar bending also circumvents the wastage of steel reinforcement (5 to 10%) and thus project cost is saved significantly.

It offers the perfect estimation of reinforcement steel requirement for all the structural members which are applied to workout complete reinforcement requirement for whole project.

Bar bending schedule offers the steel quantity requirement in a better way and thus delivers an option to make optimal use of the design in case of cost overflow.

The process becomes simple for site engineers to validate and approve the bar bending and cutting length throughout inspection prior to positioning of concrete with the support of bar bending schedule and thus facilitates in superior quality control.

It becomes easier to handle the reinforcement stock necessary for identified time duration.

It will facilitate to fabrication of R/F with structure.

Download Link

Surcharge Pressures Boussinesq multiple loads

This spreadsheet computes lateral pressure against retaining wall due to vertical surcharge area loads. It handles multiple area loads and uses theory of elasticity equations developed by Boussinesq. Subsequently, the spreadsheet calculates shear force and bending moment diagrams. Worksheet is protected but without password.

Download Link

Reinforced Retainig walls Design

Retaining walls must be reinforced in order to be effective. Too many forces are at work against a retaining wall that could cause it to tumble over if it is not reinforced correctly.

Download Link

“WALLPRES” – WALL PRESSURE ANALYSIS

Program Description:

“WALLPRES” is a spreadsheet program written in MS-Excel for the purpose of determining the horizontal (lateral) pressures to be applied to walls from various types of loading including lateral earth pressure, hydrostatic pressure, as well as uniform, point, line, and strip surcharge loadings.

This program is a workbook consisting of five (5) worksheets, described as follows:

Doc – documentation sheet
Wall Soil Pressures – Static horizontal soil pressure against wall
Wall Pressures from Point Load – Horizontal pressures on rigid wall from point surcharge load
Wall Pressures from Line Load – Horizontal pressures on rigid wall from continuous strip surcharge load
Wall Pressures from Strip Load – Horizontal pressures on rigid wall from continuous line surcharge load

Program Assumptions and Limitations:

1. This program is based on the following references:

a. NAVFAC DM-7.02 Manual – “Foundations & Earth Structures” (1986)
b. NAVFAC DM-7.01 Manual – “Soil Mechanics” (1986)
c. Army TM 5-818-1 / Air Force AFM 88-3, Chap. 7 (Oct. 1983) “Soils and Geology Procedures for Foundation Design of Buildings and Other Structures”
d. “Foundation Analysis and Design” (2nd Edition), by: Joseph E. Bowles McGraw-Hill, 1977
e. “USS Steel Sheet Piling Design Manual” – updated and reprinted by FHWA with permission (July 1984)
f. “Lateral Soil Pressure on Retaining Walls and Embedded Exterior Walls of Structures” Report U7-PROJ-S-RPT-STRU-6001, by: Sargent & Lundy, LLC (Feb. 26, 2009) for South Texas Project Units 3 & 4, Project No.: 12462-003

2. The resulting pressures obtained from the worksheets in this workbook can be used in the design of the stems of either cantilever or propped cantilever retaining walls, as well as for long walls of tanks and pits.

3. The equations used in the “Wall Pressures from Point Load” and “Wall Pressures from Line Load” worksheets are from References “a” through “e” above, utilizing original (1885) Boussinesq Equations modified to correlate with experimental test results. The Boussinesq equations assume the that wall is rigid and does not move, and that the wall is perfectly smooth (no shear stress between wall and soil). Thus, the equations overestimate the wall pressures for flexible walls by up to a factor of 2.

4. The equation used in the “Wall Pressures from Strip Load” worksheet is from References “d” and “e” above. Again, this equation assumes that the wall is rigid (does not move), which overestimates the wall pressures for flexible walls by up to a factor of 2. Thus, the factor of 2 appears in the numerator of this version of the equation. Other references may cite this equation without the factor of 2, which would normally be more applicable for flexible walls which are able to move at top.

5. This program contains “comment boxes” which contain information including explanations of input items, etc. (Note: presence of a “comment box” is denoted by a “red triangle” in the upper right-hand corner of a cell. Merely move the mouse pointer to the desired cell to view the contents of that particular “comment box”.)

Download Link

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