Soil Classification and Group Index Spreadsheet
Soil Classification and Group Index Spreadsheet
(OP)
This is a form designed for calculating Soil Classification and Group Index - AASHTO M 145. There is a tab at the bottom of the form for plotting your flow line - AASHTO T 89, Method A. I obtained the "Soil Description" from the Wyoming DOT's Materials Testing Manual (MTM). The soil description will be populated once the required, yellow cells' information is input. The Arkansas State Highway and Transportation Department (AHTD) prefers us to draw the flow line by hand.
It is my hope this will be an aid to people in highway construction.
It is my hope this will be an aid to people in highway construction.





RE: Soil Classification and Group Index Spreadsheet
The title should be one that is easily changed.
Some, like me w3ould prefer to be able to change anything, rather than being lokced into the original sheet.
It looks like a lot of work went into it.
RE: Soil Classification and Group Index Spreadsheet
There was quite a bit of time to get it right. That is why I decided to protect the form. I can see where you're coming from, however. It is nice to add your personal touches to the spreadsheet, like one's logo, etc. One part of me wants to leave it protected, but the other says to go ahead and - let the ones that can - modify it the way they see fit.
I have unprotected the spreadsheet. The "Description of Classification" info is input by IF Statements. To see these, unhide rows 65-91. You'll be able to delete these or over-write them if you prefer. Remember, though, there is a comment row you can address info as well as the "Type" underneath "Material Information" (top, right of form).
I must say, "I enjoyed making this spreadsheet!". It's my hope it will be an asset to many. By the way, I will also attach the source of my study on this subject.
Best regards!
stateman
RE: Soil Classification and Group Index Spreadsheet