Download
1 / 4
40 likes | 162 Vues
This report by Claire Mason details a methodology for integrating sieve and laser data to improve sediment analysis accuracy. Sieve data is entered into an Excel spreadsheet as weights, while laser data from Malvern is also imported into the same file, showing percentage volume. Additional sample fines that pass through the sieve pan are included in the total fine sediment amount. The laser data is converted into weight, and both data sets are combined to calculate the percentage weight for each fraction. While it provides a complete particle size distribution, it assumes uniformity in sediment distribution across methods.
E N D
Data Interpretation and Reporting Claire Mason
Merging of sieve and laser data • 1. Sieve data directly entered into an Excel spreadsheet = weights in g. • 2. Laser data from the Malvern exported into an Excel spreadsheet in same file = percentage volume. • 3. Any sample falling through sieve pan added to total amount of fine sediment (which has been laser sized). • 4. The laser data is converted into weight using the total amount of fine sediment (step 3). • 5. The sieve weights and laser ‘weights’ are then added together for each fraction • 6. The percentage weight in each fraction is then calculated.
Advantages • complete PS distribution achieved.
Disadvantages • merging two inherently different methods • assumes sediment in sieve pan has same distribution as the fine sediment that has been laser-sized.
