Concrete Mix Design Spreadsheet Free Download ##VERIFIED##
Patricia Strawbridge <[email protected]> Sat, 20 Jan 2024 06:49:07 -0800 (PST)
| Newsgroups | alt.comp.software.financial.quickbooks |
|---|---|
| Message-ID | <[email protected]> |
<div>Note: This spreadsheet is compatible with Microsoft EXCEL version 2013 or higher. If you are using older versions please refer to the Best Concrete Design EXCEL sheet [2003-7 version] which is compatible with older versions of Microsoft EXCEL.</div><div></div><div></div><div></div><div></div><div></div><div>concrete mix design spreadsheet free download</div><div></div><div>Download Zip: https://t.co/2BoZgPVVxJ </div><div></div><div></div><div>This course provides the documentation to enable the use of a post-tension design spreadsheet program for one-way concrete beam and slab and two-way concrete slab systems. Documentation for the program includes: Program Scope, Design Assumptions, Design Methodology, Program Limitations, Description of Input/Output, Hardware Requirements, Variable List, Design Examples and Manual Calculation Checks. In addition, a copy of the spreadsheet program is also made available.</div><div></div><div></div><div></div><div></div><div>This course deals primarily with the design and computational aspects of post-tensioned concrete structures. For general design philosophy and analysis of post-tensioned concrete, the reader should refer to PDHonline Course s127: General Overview of Post-Tensioned Concrete Design.</div><div></div><div></div><div>This spreadsheet program provides for the design and analysis of post-tensioned concrete one-way beam and slab systems and two-way flat plate slab systems. The program is divided into three separate screens, which correspond to the three major areas of concern in the design of a post-tensioned member. These categories are: Service Stress Analysis, Ultimate Moment Strength and Ultimate Beam Shear Analysis. This last category is further subdivided into a supplemental screen for the design and analysis of combined Ultimate Beam Shear and Torsion. Although the Service Stress and Ultimate Moment Strength portions of the program are capable of analyzing both one-way beams and slabs and two-way flat plates, the Ultimate Shear and Shear/Torsion portions of the program are intended for the analysis of one-way beams only. All ultimate strength analysis portions of the program are intended for unbonded post-tensioned systems only. This program is not based on the latest version of the ACI 318 Code but can be modified as required to update per the latest edition of the Code. The results of this program have been compared to other proprietary software that is available on the market place, such as ADAPT, with accurate correlations resulting.</div><div></div><div></div><div></div><div></div><div>In this lesson, you need to </div><div></div><div> Download POST-TENSION.xls (a spreadsheet program, 56 KB) and get familar with the spreadsheet program. </div><div></div><div> </div><div></div><div> Study the User's Manual of POST-TENSION.xls (a pdf file, 57 pages, see below for download options), which provides detailed guidance on how to analyse and design post-tensioned concrete.</div><div></div><div> The above spreadsheet program and User's Manual can be downloaded and be printed free of charge. Choose any of the formats below to start downloading:</div><div></div><div> Download POST-TENSION.xls (a spreadsheet program, 55 KB) Download the zipped User's Manual of POST-TENSION.xls (a zip file, 19.8 MB - choose this format for faster download) Download User's Manual of POST-TENSION.xls in PDF format (a pdf file, 20.3 MB, 57 pages - Because of the large size, it may take some time to load this file into Acrobat Reader. It is recommended to download the zipped manual and unzip it using WinZip.)</div><div></div><div></div><div></div><div></div><div></div><div></div><div>Access to the separate program used to analysis post-tensioning losses including friction and wedge set used in conjunction with the spreadsheet program can be made possible by contacting the author of this course.</div><div></div><div></div><div></div><div></div><div>For beam flexural design, the required bars are based on the envelope moment diagrams. For column flexural design, the required bars for each load combination are calculated at various sections for the moments and axial forces at those sections. The required bars for all load combinations are then enveloped. For both beam and column shear steel design, the required bars are based on the enveloped shear force diagrams.</div><div></div><div></div><div>The Beam Bending Reinforcement Spreadsheet records the top and bottom flexural reinforcement steel required for the left, middle, and right locations of each beam. This spreadsheet may be accessed by selecting Members Concrete Reinforcing on the Results Menu and the results are listed on the Beam Bending tab.</div><div></div><div></div><div>The Beam Shear Reinforcement Spreadsheet records the shear reinforcement ties required in each shear region of each beam. This spreadsheet may be accessed by selecting Members Concrete Reinforcing on the Results Menu and the results are listed on the Beam Shear tab.</div><div></div><div></div><div>The Concrete Detail Reports allow you to see the overall force, stress, and deflection state for any particular member. Detail reports for concrete members are not based on individual load combinations as they are for steel or wood members. Instead, they are based on an envelope of the solved load combinations. Concrete columns are the exception to this in that the columns are solved for all load combinations and then the resulting required steel is enveloped. The detail reports for concrete Column member types are also different than those for concrete Beam member types in terms of the design information that is shown below the force diagrams.</div><div></div><div></div><div>Detail reports for concrete members can, and often do, go more than one page in length due to the large amount of information that must be displayed for concrete design. One reason for this is that RISA-2D figures out the number of spans for concrete beams and columns based on the number of internal supports, thus one physical member may have several spans that all must be reported.</div><div></div><div></div><div>The Member Information in the text above the force diagrams shows basic member information as well as the Concrete Stress Block type used in the solution, whether Cracked Sections were used for the nominal design, and the Cracked 'I' Factor that was used for that member.</div><div></div><div></div><div>The next portion of the detail report, shown above, contains detailed information for the placement of the Shear Steel and the Shear Span Results for each span. Shear results are shown by region within each span. The number of regions used is a function of the shear diagram, with the maximum number of regions being taken from the Shear Regions setting on the Concrete tab of the Model Settings Dialog. The number, size, and spacing of reinforcing bars is given for each region. Also indicated is the nominal shear strength, Vn, in each region. The portion of the nominal shear strength provided by the concrete and the steel, Vc and Vs respectively, is given for each region. The area of steel required, As Reqd, and the area of steel provided, As Prvd, are also given for each shear region and are reported as 'area of steel per unit dimension', i.e. in2/in or mm2/mm.</div><div></div><div></div><div>It should be noted that the values for Mn and Vn given in this section of the detail report are the UNREDUCED nominal capacities of the member at each span/region. The actual design capacities would be obtained by multiplying these values by their respective Phi Factors indicated in the code.</div><div></div><div></div><div>IDOT Mechanistic Pavement Design and Life-Cycle Cost Analysis: This spreadsheet will perform the calculations required by Chapter 54 of the BDE Manual to determine a design thickness and conduct a life-cycle cost analysis.</div><div></div><div></div><div>The following VBA enabled spreadsheet allows the user to produce the N-M interaction plots and strain diagrams for a given concrete rectangular column cross section. This was used in a recent column design verification post _analysis___design/w/structural_analysis_and_design__wiki/17799.column-design-verification-as3600-09-ram-concrete.</div><div></div><div></div><div>This concrete footing design calculator helps engineers design foundations for footings, combined footings, concrete piles, concrete pads, and more. The software includes calculations for overturning, sliding, structural utility ratios (one-way shear, two-way shear, flexure X, and flexure Y), and more - as per AS 3600 and ACI 318. The free tool will also calculate the volume of concrete in your design.</div><div></div><div></div><div>This online footing calculator is a simplified version of our Foundation/Footings Design Software, which is able to handle more loads and foundation types, including Combined footings and non-symmetric isolated footings. Simply start by selecting your design code, and begin with adding or editing the dimensions of your footing via the width, height, and depth parameters. The figure will automatically update itself.</div><div></div><div></div><div>This easy-to-use concrete foundation calculator will help engineers calculate a number of important results for isolated and combined footings. These include overturning, dimension requirements, sliding, soil pressure, one way and two way shear and flexure capacity ratios. This gives the engineer a good indication of whether the foundation will pass or fail. The SkyCiv Concrete Footing Calculator is equipped with interactive graphics, multiple load types, in-built reinforcement and powerful calculation reporting. Some of these features are locked out of the free version, but feel free to check out our Foundation Design Software page for more information on the full versions features and capabilities.</div><div></div><div></div><div>Our footing design calculator can also calculate concrete piles and pile cap foundations. This can be designed under the context of ACI 318 or AS 3600 (and AS 2159 for soil). This concrete pile software will display results for axial flexure, end bearing, flexure*, lateral* and shear* checks. Note: any results with an asterisk (*) are available under the paid version only.</div><div></div><div></div><div>Along with the overturning, sliding and concrete design utility ratios, The SkyCiv footing design calculator will also calculate the volume of concrete in your pad footing. The result will return the cubic meters of concrete for metric systems and cubic feet for imperial unit systems. This calculator estimates the amount of concrete needed for your isolated footings, for quick back of the envelope calculations and estimates.</div><div></div><div></div><div>Further foundation design can be calculated from our full version Foundation Design Software. This software will allow the calculation of ACI 318 and AS 3600 concrete footings (also known as concrete pad footings) with full loading capabilities and results. This includes a detailed report of the calculations and additional design features. This Foundation Design Software can also be used to calculate and design concrete piles as per AS 3600 (AS 2159) and ACI 318 with multiple soil layers, additional loading capabilities and no restrictions.</div><div></div><div> df19127ead</div>