Excel spreadsheet required for displaying results of sand size test
- or -
Post a project like this2706
£150(approx. $188)
- Posted:
- Proposals: 8
- Remote
- #1359022
- Awarded
Data Mining/Web Scraping/Software Testing/Selenium Webdriver/SOAPUI/Excel Macro/VB/Rest API
Bangalore
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
14281566148506667435601192798138965014064161432802
Description
Experience Level: Intermediate
We require an Excel spreadsheet developed so that we can carry out the testing of sand particle sand as per the description below. The spreadsheet needs to create a graph similar to the example graph shown below.
25 Procedure to determine the particle size distribution of granulated infill materials (FIFA method 20)
25.1 Scope
This procedure describes the method of test to determine the particle size distribution of granulated infill materials and to determine the consistency of samples in comparison to a manufacturer’s product declaration.
25.2 References
EN 933-1 Test for geometrical properties of aggregates – Part 1: Determination of particle size distribution – sieving method.
25.3 Procedure
Weigh a minimum of 300g of the granulated infill material and place on a clean tray in an oven at 105 ° C ± 5 ° C for 2 hours. Re-weigh the sample. If the weight has reduced by more than 1.0 ± 0.1g return it to the oven for a further 2 hours. Re-weigh the sample if the weight is consistent with the previous reading to within 1.0 ± 0.1g then remove it from the oven, if not repeat this procedure until the weight is consistent to 1.0 ± 0.1g. Remove the sample from the oven and allow to cool to room temperature (minimum period 1 hour).
Determine the particle size distribution of the infill materials in accordance with EN 933-1 using the following sieves: 0.00mm, 200μm, 315μm, 0.5mm, 0.63mm, 0.80mm, 1.00mm, 1.25mm, 1.60mm, 2.00mm, 2.50mm, 3.15mm, and 4.00mm
25.4 Calculation of results
Definitions
d starting at the smallest sieve dtest is the largest sieve through which 10% or less of the sample passes (i.e. between 0% and 10% of the sample is smaller than the sieve designated d)
D starting at the biggest sieve, Dtest is the smallest sieve on with 10% or less of the sample is retained (i.e. between 0% and 10% of the sample is bigger than the sieve designated D).
Plot the results on a graph and determine the values of dtest and Dtest for the sample. Calculate the percentage mass of the sample falling between dtest and Dtest when compared to the overall test sample mass.
25.5 Analysis of results
Validation of the manufacturer’s declaration – Type Approval laboratory tests
The Manufacture’s Declaration shall define the range intended to be encompassed by d and D. For a sample to comply with a Manufacturer’s Declaration the mesh size of the dtest and Dtest sieves shall be ± one sieve size of the declared dm and Dm values and at least 60% of the total infill sample shall be within the declared range, as illustrated in Figure 27.
25 Procedure to determine the particle size distribution of granulated infill materials (FIFA method 20)
25.1 Scope
This procedure describes the method of test to determine the particle size distribution of granulated infill materials and to determine the consistency of samples in comparison to a manufacturer’s product declaration.
25.2 References
EN 933-1 Test for geometrical properties of aggregates – Part 1: Determination of particle size distribution – sieving method.
25.3 Procedure
Weigh a minimum of 300g of the granulated infill material and place on a clean tray in an oven at 105 ° C ± 5 ° C for 2 hours. Re-weigh the sample. If the weight has reduced by more than 1.0 ± 0.1g return it to the oven for a further 2 hours. Re-weigh the sample if the weight is consistent with the previous reading to within 1.0 ± 0.1g then remove it from the oven, if not repeat this procedure until the weight is consistent to 1.0 ± 0.1g. Remove the sample from the oven and allow to cool to room temperature (minimum period 1 hour).
Determine the particle size distribution of the infill materials in accordance with EN 933-1 using the following sieves: 0.00mm, 200μm, 315μm, 0.5mm, 0.63mm, 0.80mm, 1.00mm, 1.25mm, 1.60mm, 2.00mm, 2.50mm, 3.15mm, and 4.00mm
25.4 Calculation of results
Definitions
d starting at the smallest sieve dtest is the largest sieve through which 10% or less of the sample passes (i.e. between 0% and 10% of the sample is smaller than the sieve designated d)
D starting at the biggest sieve, Dtest is the smallest sieve on with 10% or less of the sample is retained (i.e. between 0% and 10% of the sample is bigger than the sieve designated D).
Plot the results on a graph and determine the values of dtest and Dtest for the sample. Calculate the percentage mass of the sample falling between dtest and Dtest when compared to the overall test sample mass.
25.5 Analysis of results
Validation of the manufacturer’s declaration – Type Approval laboratory tests
The Manufacture’s Declaration shall define the range intended to be encompassed by d and D. For a sample to comply with a Manufacturer’s Declaration the mesh size of the dtest and Dtest sieves shall be ± one sieve size of the declared dm and Dm values and at least 60% of the total infill sample shall be within the declared range, as illustrated in Figure 27.
Callum R.
100% (88)Projects Completed
124
Freelancers worked with
67
Projects awarded
20%
Last project
21 Jan 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies