Banner for LabNotes
From Lab Notes
Contact Information
Forest Products Laboratory
One Gifford Pinchot Drive
Madison, WI 53726-2398
Phone: (608) 231-9200
Fax: (608) 231-9592


You are here: FPL Home  / Information Products & Services  / Publications

Requested Product

Title: Calculating strength ratio and grade quality index of dimensional lumber using ASTM D4761 and ASTM D245

Source: FS GTR

Author(s)Farber, Benjamin; Senalik, Christopher Adam

Publication Year: 2021  View PDF »

Category: General Technical Reports
Associated Research Project(s):   FPL-4714-1B

Abstract: The standard for calculating grade quality index (GQI) is a three-step process. First, failure codes are assigned during testing. Second, strength ratios are calculated from failure codes recorded during post-test analysis, not including failure from slope of grain. Third, the lower fifth percentile strength ratio is identified, which is defined as the GQI. In the past, the process of calculating strength ratios required one to correctly interpret and apply calculations per ASTM D4761 (current edition) and ASTM D245 (current edition) or gain remote access to USDA Forest Service, Forest Products Laboratory servers, transfer the failure codes to the servers using file transfer protocol, instruct the resident “SRatio” Fortran program to operate on the transferred files, and then transfer the files back to the local computer. Although the latter yielded consistent and reliable strength ratios, the process was slow and cumbersome and relied upon access to outside computational resources that can now be made available on a local platform. The intended users of this report are those developing design values or performing monitoring programs of dimension lumber. This report describes the process and calculations behind the SRatio program to allow it to be re-created in commonly available applications, such as Excel (Microsoft Corporation, Redmond, Washington, USA). The Excel spreadsheet created and described in this report takes the failure code data from testing and calculates both strength ratios and GQI of the tested lumber samples, which is necessary for determining design values of the tested lumber sample.

Keywords: strength ratios; grade quality index; failure codes GQI; SRatio; computer program; dimensional lumber

Publication Review Process: Informally Refereed (Peer-Reviewed)

File size: 4,096 kb(s)

Date posted: 07/12/2021

This publication is also viewable on Treesearch:  view
RITS Product ID: 10182
Current FPL Scientist associated with this product
Senalik, Christopher
Research General Engineer

Additional items that might interest you
View the video celebrating FPL's 100 years of public service in 2010, from the producers of the Greatest Good....view

Research Highlights from FPL....view

Termite Eradication: A search for the Holy Grail.... view

Moisture Management in Residential Construction Series videos...view

Wood Floor Systems in Residential Construction Series videos....view
- FPL's Mission and Strategic Plan -

FPL's mission is to identify and conduct innovative wood and fiber utilization research that contributes to conservation and productivity of the forest resource, thereby sustaining forests, the economy, and quality of life. ... ..more »

- FPL Research Emphasis Areas -
Advanced Composites

As an integral part of the FPL mission, we improve the long-term sustainability of our Nation's forests by creating valuable composite products from biobased materials ... ..more »

Advanced Structures

The FPL has been in the forefront of wood-frame housing research since 1910 and has long been recognized as a world leader in such housing-related areas as engineered wood ... ..more »

Forest Biorefinery

We all know the compelling reasons that the United States needs to reduce its dependence on fossil fuels. Historically, the greatest increases in energy demand have been for transportation fuels ... ..more »


A leader in wood products research for over a century, the FPL is positioning itself to become the lead Federal research facility for the application of nanotechnology in forest products ... more »

Woody Biomass Utilization

Forests in the United States contain a substantial amount of small-diameter, overstocked, and underutilized material.FPL research projects are exploring the potential of the small-diameter ... ..more »