Index of Appraisal Related Files

The Appraisal page contains current and previous Appraisal Updates, TEACOST.DAT files, and Other Information related to valuing forest products in various forest management and restoration projects on National Forests in Oregon and Washington via the Transaction Evidence Appraisal (TEA) process. Contact person is Michael Daugherty, Regional Sale Preparation and Valuation Specialist, and Regional Stewardship Coordinator, 503-808-2519, mdaugherty@fs.fed.us.

Please select from the choices below:

Appraisal Update TEACOST.DAT Files Product Quality Adjustment (PQA)

Low Value Material Other Information

Appraisal Update

Current and past Appraisal Updates in Region 6.  Appraisal Updates contain information needed by appraisers to process appraisals of work required and products removed from forest management/restoration projects.   Click on the Appraisal Update you would like to view.

• Appraisal Update #12-11 – dated December 30, 2011.
• Appraisal Update #11-11 – dated November 29, 2011.
• Appraisal Update #10-11 – dated October 21, 2011.
• Appraisal Update #9-11 – dated September 22, 2011.
• Appraisal Update #8-11 – dated August 22, 2011.
• Appraisal Update #7-11 – dated June 21, 2011.
• Appraisal Update #6-11 – dated June 24, 2011.
• Appraisal Update #5-11 – dated May 24, 2011.
• Appraisal Update #4-11 – dated April 22, 2011.
• Appraisal Update #3-11 – dated March 22, 2011.
• Appraisal Update #2-11 – dated February 28, 2011.
• Appraisal Update #1-11 – dated January 31, 2011.
• Appraisal Update #12-10 – dated December 17, 2010.
• Appraisal Update #11-10 – dated November 18, 2010.
• Appraisal Update #10-10 – dated October 22, 2010.
• Appraisal Update #9-10 – dated September 16, 2010.
• Appraisal Update #8-10 – dated August 18, 2010.
• Appraisal Update #7-10 – dated July 20, 2010.
• Appraisal Update #6-10 – dated June 28, 2010.
• Appraisal Update #5-10 – dated May 25, 2010.
• Appraisal Update #4-10 – dated April 20, 2010.
• Appraisal Update #3-10 – dated March 22, 2010.
• Appraisal Update #2-10 – dated February 24, 2010.
• Appraisal Update #1-10 – dated February 1, 2010.
• Appraisal Update #12-09 – dated December 17, 2009.
• Appraisal Update #11-09 – dated November 23, 2009.

TEACOST.DAT Files

Click on the links to the right… CCF TEACOST.DAT Files MBF TEACOST.DAT Files

Current and past TEACOST.DAT files used in Region 6 transaction evidence appraisal program. TEACOST.DAT files contain base period data for the six appraisal zones in Washington and Oregon. These files are also used for doing contract extensions, modification and rate redeterminations.

CCF TEACOST.DAT Files - appraising products with CCF as the unit of measure in A(T)2 or A(T).2 requires the use of a TEACOST.DAT file containing CCF costs and prices. Naming convention for the files is "TEACOST_month-year.DAT". Month-year refers to the month and year the TEACOST.DAT file was in effect. The "TEACOST.DAT” file is the file to be used for appraisals processed in the current month.

For the program to run, download and save the teacost.dat file to “C:/fsfiles/r6tea_work”.

• TEACOST.DAT - File containing the most current WWPA indices, and CCF base period prices and cost centers.
• TEA User Guide - (revised April 2010) - Instructions for using the TEA program.
• TEACOST_11-11.DAT - File used on sales appraised from November 29, 2011 through December 29, 2011.
• TEACOST_10-11.DAT - File used on sales appraised from October 21, 2011 through November 28, 2011.
• TEACOST_09-11.DAT - File used on sales appraised from September 22, 2011 through October 20, 2011.
• TEACOST_08-11.DAT - File used on sales appraised from August 22, 2011 through September 21, 2011.
• TEACOST_07-11.DAT - File used on sales appraised from July 21, 2011 through August 21, 2011.
• TEACOST_06-11.DAT - File used on sales appraised from June 24, 2011 through July 20, 2011.
• TEACOST_05-11.DAT - File used on sales appraised from May 24, 2011 through June 23, 2011.
• TEACOST_04-11.DAT - File used on sales appraised from April 22, 2011 through May 23, 2011.
• TEACOST_03-11.DAT - File used on sales appraised from March 22, 2011 through April 21, 2011.
• TEACOST_02-11.DAT - File used on sales appraised from February 28, 2011 through March 21, 2011.
• TEACOST_01-11.DAT - File used on sales appraised from January 31, 2011 through February 27, 2011.
• TEACOST_12-10.DAT - File used on sales appraised from December 17, 2010 through January 30, 2011.
• TEACOST_11-10.DAT - File used on sales appraised from November 18, 2010 through December 16, 2010.
• TEACOST_10-10.DAT - File used on sales appraised from October 22, 2010 through November 17, 2010.
• TEACOST_9-10.DAT - File used on sales appraised from September 16, 2010 through October 21, 2010.
• TEACOST_8-10.DAT - File used on sales appraised from August 18, 2010 through September 15, 2010.
• TEACOST_7-10.DAT - File used on sales appraised from July 20, 2010 through August 17, 2010.
• TEACOST_6-10.DAT - File used on sales appraised from June 28, 2010 through July 19, 2010.
• TEACOST_5-10.DAT - File used on sales appraised from May 25, 2010 through June 27, 2010.
• TEACOST_4-10.DAT - File used on sales appraised from April 20, 2010 through May 24, 2010.
• TEACOST_3-10.DAT - File used on sales appraised from March 22, 2010 through April 19, 2010.
• TEACOST_2-10.DAT - File used on sales appraised from February 24, 2010 through March 21, 2010.
• TEACOST_1-10.DAT - (2007-2008 WWPA Indices) - File used on sales appraised from February 1, 2010 through February 23, 2010.
• TEACOST_1-10.DAT - (2002-2003 WWPA Indices) - File used on sales appraised from February 1, 2010 through February 23, 2010.
• TEACOST_12-09.DAT - (2007-2008 WWPA Indices) - File used on sales appraised from December 17, 2009 through January 31, 2010.
• TEACOST_12-09.DAT - (2002-2003 WWPA Indices) - File used on sales appraised from December 17, 2009 through January 31, 2010.
• TEACOST_11-09.DAT - File used on sales appraised from November 23, 2009 through December 16, 2009.

Product Quality Adjustment (PQA)

Program, user guide, and current and past spreadsheets for calculating an adjustment for wood quality based upon delivered log prices for use in the Region's Transaction Evidence Appraisal (TEA) program. Naming convention for past spreadsheets is "PQA_monthyear.xls". Monthyear refers to the month and year the PQA.xls spreadsheet was in effect. "PQA.xls" is the spreadsheet to be used for appraisals processed in the current month.

• PQA.xls - Spreadsheet containing delivered log prices for the current month used in calculating the wood quality adjustment for appraisals. Use in conjunction with the current TEA.DAT file.
• PQA User Guide (revised April 2010) - Program history and assumptions, and instructions for running the program.
• PQA_11-11.xls - PQA spreadsheet used in sales appraised from November 29, 2011 through December 29, 2011.
• PQA_10-11.xls - PQA spreadsheet used in sales appraised from October 21, 2011 through November 28, 2011.
• PQA_9-11.xls - PQA spreadsheet used in sales appraised from September 22, 2011 through October 20, 2011.
• PQA_8-11.xls - PQA spreadsheet used in sales appraised from August 22, 2011 through September 21, 2011.
• PQA_7-11.xls - PQA spreadsheet used in sales appraised from July 21, 2011 through August 21, 2011.
• PQA_6-11.xls - PQA spreadsheet used in sales appraised from June 24, 2011 through July 20, 2011.
• PQA_5-11.xls - PQA spreadsheet used in sales appraised from May 24, 2011 through June 23, 2011.
• PQA_4-11.xls - PQA spreadsheet used in sales appraised from April 22, 2011 through May 23, 2011.
• PQA_3-11.xls - PQA spreadsheet used in sales appraised from March 22, 2011 through April 21, 2011.
• PQA_2-11.xls - PQA spreadsheet used in sales appraised from February 28, 2011 through March 21, 2011.
• PQA_1-11.xls - PQA spreadsheet used in sales appraised from January 31, 2011 through February 27, 2011.
• PQA_12-10.xls - PQA spreadsheet used in sales appraised from December 17, 2010 through January 30, 2011.
• PQA_11-10.xls - PQA spreadsheet used in sales appraised from November 18, 2010 through December 16, 2010.
• PQA_10-10.xls - PQA spreadsheet used in sales appraised from October 22, 2010 through November 17, 2010.
• PQA_9-10.xls - PQA spreadsheet used in sales appraised from September 16, 2010 through October 21, 2010.
• PQA_8-10.xls - PQA spreadsheet used in sales appraised from August 18, 2010 through September 15, 2010.
• PQA_7-10.xls - PQA spreadsheet used in sales appraised from July 20, 2010 through August 17, 2010.
• PQA_6-10.xls - PQA spreadsheet used in sales appraised from June 28, 2010 through July 19, 2010.
• PQA_5-10.xls - PQA spreadsheet used in sales appraised from May 25, 2010 through June 27, 2010.
• PQA_4-10.xls - PQA spreadsheet used in sales appraised from April 20, 2010 through May 24, 2010.
• PQA_3-10.xls - PQA spreadsheet used in sales appraised from March 22, 2010 through April 19, 2010.
• PQA_2-10.xls - PQA spreadsheet used in sales appraised from February 24, 2010 through March 21, 2010.
• PQA_1-10.xls - PQA spreadsheet used in sales appraised from February 1, 2010 through February 23, 2010.
• PQA_12-09.xls - PQA spreadsheet used in sales appraised from December 17, 2009 through January 31, 2010.
• PQA_11-09.xls - PQA spreadsheet used in sales appraised from November 23, 2009 through December 16, 2009.

Low Value Material

Low Value Material User Guide (April 2010) - Defined as trees or portions of trees that do not meet specifications stated in the contract for sawtimber products.

Other Information

· RMA.xls - Rapid Market Adjustment (RMA). Excel spreadsheet displaying Random Lengths weekly prices for representative products. Used for adjusting Base Period Prices up to the date of the appraisal. RMA is calculated monthly with the adjustment included in the TEACOST.DAT file. No calculation or transference of numbers is required of the user.

· RMA.doc (2/00) - Information guide in MSWord describing the calculation and use of the Rapid Market Adjustment.

· Calculation of Base Period Prices (4/00) - User information guide describing the method used to calculate updated Base Period Prices (BPP) for use in the TEACOST.DAT file. BPP are now based upon relational species values tracked by representative species listed in Random Lengths.

· Analysis of Advertised Rates Spreadsheet (4/10) - Mandatory for use on all sales to assure advertised rates are reflective of current market conditions.  Complete, print and file a copy in the sale folder as documentation for the sale prep package.

· TEA Version April 2010 - The following files need to be downloaded and filed in “C:\fsapps\fsprod\r6tea\” for the program to function properly;

TEASum.class teasum.cmd

· Printing the Appraisal Summary - Follow the Printing Instructions below in setting up your computer for printing the Appraisal Summary. This is part of the set-up to TEA on a new computer, or a computer that has been reimaged. This only needs to be done once. The tea.dotm file is to be copied to the “C:\fsapps\fsprod\r6tea\” folder.

Printing Instructions tea.dotm

· TEA Fix – If TEA is not operating correctly, verify your computer has the most current JInitiator file by navigating the following path;

C:\Program Files\Oracle\JInitiator 1.3.1.26\bin\hotspot\jvm.dll

If there is an earlier JInitiator version shown, do a “Save target as” on the file below to replace the jvm.dll file currently there. TEA should now function properly.

jvm.dll

· Bid & Post Bid Calculations - This spreadsheet is used for oral bid auctions to easily record and save the oral bid proceedings. The spreadsheet also has several post bid screens that calculate and document various costs, deposits, dates and postings. Right-click to download. Developed by Rheinberger

Sale Preparation 2010 - Sale Preparation Workshops 2010. Zip file containing all documents which attendees are to download, unzip to extract the documents, print and bring the documents to their respective workshop.

Date last modified 01/03/12