spreadsheet computational tool designation in cement composition EN 197-1:2000 (Standard).

Previous Post
Next Post

Contents

spreadsheet provides a computational tool for finding out the matching designation in cement composition according to the EN 197-1:2000 (Standard).

 

TO DOWNLOAD THE MOST IMPORTANT BOOKS , MANUALS , OPERATION NOTES , FORMUFLAS , EXCEL SHEETS CLICK HERE NOW !!

This spreadsheet provides a computational tool for finding out the matching designation in cement composition according to the EN 197-1:2000 (Standard). It is intended to help demonstrate the possible designations by checking the matching requirements in the term of percentage. The requirements are digitally coded into this programs, so it will feedback the errors on the data entered that does not meet standard requirements, this will allow the user to change the data entered to the data that will be accepted. Some suggestions will also be highlighted on how potential changes can be mode if no matching product is found. The program calculates the % automatically by converting the values to the standard method of reading the table which the composition are considered without the set regulators. This tool provides a faster way of doing the basic calculations needed to read the standard table and at the same time provides more understanding on the standards requirements on the main and minor constituents

Developed By : Balamohan (Holcim Malaysia, HMY), Supported By : Michael Romer (Holcim Swizerland, HGRS)

 

Disclaimer

The free software programs provided by Holcim Malaysia may be freely shared, copied and distributed, provided no reverse engineering is done to this program such as removing the Holcim logo, changing the formula and republishing the program as a different owner. The program is provided as is without any guarantees or warranty. Although the developer has attempted to use the correct formulas & equations, find and correct any errors in the program, the developer is not responsible for any damage or losses of any kind caused by the use or misuse of the program. The developer is under no obligation to provide support, service, corrections, or upgrades the programs. However feedbacks about the tools can be made

This spreadsheet provides a computational tool for finding out the matching designation in cement composition according to the EN 197-1:2000 (Standard).
This spreadsheet provides a computational tool for finding out the matching designation in cement composition according to the EN 197-1:2000 (Standard).

 

 

Download the sheet here 

 

Download the standard here 

 

for any questions please contact : project20062015@gmail.com

 

Instructions

Data is entered in cells on the “The Product Finder” sheet that are highlighted in orange & blue

When calcium sulfate is used (example gypsum), the values entered in second main constituents and minor constituents will be corrected to 100% without gypsum, therefore the

SMC Corr & MAC Corr shows The EN 197 Correction value for individual second main const

Minor constituents should not be same with main constituents, the program will check the second main constituents and minor constitutents similarities and disable relevant minor

Decimals & rounded buttons are provided to round the numbers in case that the values falls between the round numbers on the standard. For example, 5.5% will be rounded to 6 %, 5.4%

In case you’re expecting any specific type of CEM, you can choose them at the Target CEM Box

The reset button it provided to reset the form the original state where no data entered.

Tool Limitations

Not Known

General Standard Requirement Fixed In The Program

CEM II – “M” – Minimum 2 main constituents of S, D, P, Q, V, W, T, L (each >5 %) next to clinke CEM IV – Minimum 1 main constituents of D, P, Q, V, W (each >5%, sum > 11%) next to clinker CEM V – Minimum 1 pozzolanic main constituent P, Q, V (each >5%, sum >18%) next to minimu A constituent (material) can be either “second main constituent” (≥5%) or “minor additional constituents

 

TO DOWNLOAD THE MOST IMPORTANT BOOKS , MANUALS , OPERATION NOTES , FORMUFLAS , EXCEL SHEETS CLICK HERE NOW !!

Previous Post
Next Post

2 thoughts on “spreadsheet computational tool designation in cement composition EN 197-1:2000 (Standard).”

Leave a Reply