Attachment 9 FY23 KNF CSE QASP Scoring Spreadsheet.xlsx

XLSX spreadsheet 95 KB Posted

Attached to
Common Stand Exam Request for Pricing under Established Contacts Federal contract opportunity
Solicitation number
1282B123Q0066
Issued by
Department of Agriculture Forest Service

View the file

Other files for this federal contract opportunity

Other files attached to Common Stand Exam Request for Pricing under Established Contacts, newest first.
File Type Posted
Attachment 10 Wage Determination 1976-1342 R72.pdf PDF
Attachment 6 D5_OU3Jackson_June30_AccessMap_8.5x11 Portrait.zip ZIP file
Attachment 2 FY23 KNF CSE Schedule of Items_Rev_MC_4.10.23.xlsx XLSX spreadsheet
1282B123Q0066.pdf PDF
Attachment 8 FY23 KNF CSE OG QP Protocol_Field Guide.zip ZIP file
Attachment 7 D5_Ripley_Accesso_Topo.zip ZIP file
Attachment 1 FY23 KNF CSE Statement of Work.pdf PDF
Attachment 5 D5_OU3Jackson_Area10Topo_8.5x11 Portrait.zip ZIP file
Attachment 3 D1_D3_Sunday_PlotLocator_Map3.zip ZIP file
Attachment 4 D4_CSE_PleasantPheasant_vicinity_map.zip ZIP file

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Inspection Summary

Region 1 IDIQ CSE/IM Scoring Spreadsheet
Overall Scoring Summary:
Project Name:Inspection Status:ERROR:#DIV/0!FALSEFALSE
# of Settings:Contract Number:COR:Inspection Score:ERROR:#DIV/0!
# Settings Inpected:Date Received:Lead Inspector:
# of Plots:Date Inspected:Inspector:Total Value:0
# of Plots Inspected:Inspector:Total Error:0
Percent Error:ERROR:#DIV/0!
PASS/FAIL INSPECTION ITEMSAcceptableUnacceptableIncluded on Task Order
All completed forms/data submitted in a timely manner:X
All forms legible and can be reproduced via copy machine:X
All electronic data can be read by Government computer software:X
No settings with BAF used resulting in < min. average # live trees specified:X
BAF/FRQ on setting sample design for Trees matches the BAF on Paper Setting Form/Narrative:X
All plot center locations within tolerance of theoretical and unbiased:XINSPECTION STATUS BY FORM
Settings have prescribed number of sample plots examined:X
Accurate count and species of large live sample trees recorded:XForm Included on Task OrderSatisfactory/ UnsatisfactoryScoreSatUnsatUnacceptable Data Item
All reference points & plot center points relocatable and labeled to specs:XSetting Form:X85ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!None
All settings contain minimum number of GST trees (as specified):XSample Design Form:X85ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!None
Settings submitted with complete information for all forms/data:XPlot Monument Form:85ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!None
All forms contain accurate setting locations and numbering information:XPlot Form:X85ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!None
All Government supplied data complete & accurately transcribed to forms:XLarge Tree Form:X85ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!None
All plots are evenly distributed within each setting:Small Tree Form:X85ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!None
No settings contain an 'Unacceptable' error in the Inspection Form:XVeg Composition Form:85ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!None
No sample plot centers fall outside of setting boundary:XDown Woody Material Form:X85ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!None
Any additional Task Order required items carried out as specified:X
For INVM/INT remeasurements or FMR, all trees successfully paired with previous measurement:
All photos are clear and labeled correctly, and placards (if req.) are legible:
PLOTS INSPECTED
SETTINGPLOT NUMBERS

INSPECTION COMMENTS & FOLLOW-UP ACTIONS

Setting Insp Form Setting Inspection Form

Data ItemAttribute RequiredItem Value# of ErrorsTotal ErrorTotal Items CheckedTotal ValueScore:ERROR:#DIV/0!
Project NameX0
Proclaimed RegionX0Unacceptable Data Item:None
Proclaimed ForestX0
DistrictX0Status:ERROR:#DIV/0!
LocationX0
Stand NumberX0Total Value:0
OwnershipX0Total Error:0
StateX0Percent Error:ERROR:#DIV/0!
CountyX0
Administrative ForestX0
DateX200
Photo ID000
Exam LevelX0
Exam PurposeX0
Stratum000
Existing Veg Reference0
Existing Veg Composition Type400
Potential Veg ReferenceX0
Potential VegX1000
Structure200
Capable Growing AreaX200
Fuel Model400
ElevationX200
AspectX200
SlopeX200
Slope Position100
AcresX100
ExaminerX100
Precision ProtocolX100
Radial Growth Interval0
Height Growth Interval0
Fuel Photo Reference0
Setting User Code500
DatumX0
Magnetic Declination0
Measurement Number0
Setting RemarksX700
Damage Category400
Damage Agent200
Damage Severity200
Species of Mgmt. Interest200
Setting Narrative/Sketch Map/Travel NotesX700

SETTING DATA COMMENTS

Sample Design Insp Form

Sample Design Inspection Form
Item Value# of ErrorsTotal ErrorTotal ItemsTotalScore:ERROR:#DIV/0!
Data ItemAttribute RequiredCheckedValue
Sample Selection Method TypeX0Status:ERROR:#DIV/0!
Sample Expansion FactorX0
Starting Azimuth000Unacceptable Data Item:None
Subpopulation FilterX0
Sample Design Remarks000Total Value =0
Selection CriteriaX0Total Error =0
Subpopulation VariableX0Percent Error =ERROR:#DIV/0!
Subpopulation Minimum ValueX0
Subpopulation Maximum ValueX0

SAMPLE DESIGN DATA COMMENTS

Plot Level Data

PLOT LEVEL DATA
Item Value# of ErrorsItem ErrorScore =ERROR:#DIV/0!
Data ItemTolerance
Stateno errors20Status =ERROR:#DIV/0!
Countyno errors20
Plot Numberno errors20
Plot Statusno errors50Total Value =enter value from chart
Nonforest Sampling Statusno errors30Total Error =0
Percent Error =ERROR:#DIV/0!
Condition Class Changeno errors30
Subplots Examinedno errors30Values by Plot Type
Regional Sample Kindno errors50
Previous Plot Numberno errors30P2 PlotP3 Plot
Horizontal Distance to Improved Roadno errors40Forest60
Water on Plotno errors40Nonforest36
QA Statusno errors50Remeasurement58
Crew Typeno errors50Nonsampled36
GPS Unitno errors20ACP75
UTM Zoneno errors20
Easting (X) UTM140 feet40
Northing (Y) UTM140 feet40
Azimuth to Plot Center3 degrees30
Distance to Plot Center6 feet30
GPS Elevation100 feet40
Future Forest Potentialno errors30
PLOT LEVEL DATA COMMENTS

Monument Data

Monument Data
Vehicle CoordinatesAttribute RequiredItem Value# of ErrorsItem ErrorTotal Items CheckedTotal ValueScore:ERROR:#DIV/0!
Latitude0
Longitude0Status:ERROR:#DIV/0!
Reference Point/Navigation InfoAttribute RequiredValueErrorTotal ErrorTotal Item CheckedTotal ValueUnacceptable data item:None
Azimuth RP to Plot Center0
Slope Distance to Plot Center0Total Value=0
Remarks100Total Error=0
Selection Criteria Met & RP Tagged0Percent Error=ERROR:#DIV/0!
RP Species300
RP Diameter200
Latitude300
Longitude300
Error100
Plot Navigated From300
Azimuth from Navigation Plot300
Distance from Navigation Plot300
X Witness TreeAttribute RequiredValueErrorTotal ErrorTotal Item CheckedTotal Value
Selection Criteria Met & X Tagged300
Azimuth300
Slope Distance to Plot Center300
Species300
Diameter200
Y Witness TreeAttribute RequiredValueErrorTotal ErrorTotal Item CheckedTotal Value
Selection Criteria Met & Y Tagged300
Azimuth300
Slope Distance to Plot Center300
Species300
Diameter200
Plot Center & Location InformationAttribute RequiredValueErrorTotal ErrorTotal Item CheckedTotal Value
Point of Departure100
Plot center flagging present and legible100
Transect stakes & flagging present & legible100
Error100
PC Stake Present0
Plot Narrative0
Plot Location Map0
Detailed road Travel Description0
Detailed hiking Travel Description0
Tree Nail Position200
Plot Monument Data Notes

Location Reference Items

FIELD LOCATION REFERENCE ITEMS
Finding the Plot
Item Value# of ErrorsItem ErrorScore =100.0
Data ItemTolerance
Travel Descriptioncomplete & accurate50Status =ACCEPTABLE
Truck UTM Zoneno errors20
Truck UTM Easting140 feet20Total Value =203
Truck UTM Northing140 feet20Total Error =0
Owner Contactno errors20Percent Error =0.0
4 X 4no errors20
ATVno errors20
Locked Gateno errors20
Ownernot entered into PDR50
Photo Projectno errors20
Photo Rollno errors20
Photo Numbersno errors20
Photo Scaleno errors20
Photo Yearno errors20
Photo Scale Reciprocalno errors20
Townshipno errors20
Rangeno errors20
Sectionno errors20
Field Location Sketch Mapcomplete & accurate100
Reference Point
Item Value# of ErrorsItem Error
Data ItemTolerance
Selectionbest available50
Descriptioncomplete & accurate50
Speciesno errors100
Diamter0.2 inch per 20 inches of diameter100
Tagscorrectly placed & scribed100
UTM Zoneno errors20
UTM Easting140 feet20
UTM Northing140 feet20
RP to LC Traverse
Item Value# of ErrorsItem Error
Data ItemTolerance
Azimuth2 degrees50
Horizontal Distance6 feet per 100 feet of transect, 30 feet maximum50
Slope Distance6 feet per 100 feet of transect, 30 feet maximum50
Witness Trees
Item Value# of ErrorsItem Error
Data ItemTolerance
X Selectionbest available50
X Speciesno errors100
X Diameter0.2 inch per 20 inches of diameter100
X Azimuth2 degrees50
X Distance0.2 feet50
X Tagscorrectly placed & scribed100
Y Selectionbest available50
Y Speciesno errors100
Y Diameter0.2 inch per 20 inches of diameter100
Y Azimuth2 degrees50
Y Distance0.2 feet50
Y Tagscorrectly placed & scribed100
FIELD LOCATION REFERENCE ITEMS COMMENTS

Plot Data

Plot Inspection Form
Item Value# of ErrorsTotal ErrorTotal ItemsTotalScore:ERROR:#DIV/0!
Data ItemAttribute RequiredCheckedValue
Plot NumberXStatus:ERROR:#DIV/0!
Plot LatitudeX1000
Plot LongitudeX1000Unacceptable Data Item:None
Plot Capable Growing Area200
Plot AspectX400Total Value =0
Plot SlopeX400Total Error =0
Slope Position200Percent Error =ERROR:#DIV/0!
Slope Horizontal Shape200
Slope Vertical Shape200
Plot Elevation200
Plot Existing Veg Comp Type500
Plot Potential Vegetation CodeX1000
Plot Fuel Model400
Residual Descriptive Code200
Distance to Seed Wall200
Plot User Code500
Plot History200
Plot History Date100
Plot RemarksX800

PLOT DATA COMMENTS

QC Tally (Tree Data)

TREES, SAPLINGS & SEEDLINGS TALLIED BY QC

P2 Plot P3 Plot

P2 Plot QC Tally Value Total Points P2 Plot QC Tally Value Total Points

Live Timber Species (5.0" + DBH)
No Radial Growth & Age11200
Radial Growth & Age (both)12400
Radial Growth Only11900
Dead Timber Species (5.0" + DBH)
Non-Mortality8500
Mortality10000
Live Woodland Species (5.0" + DRC)
No Radial Growth & Age11400
Radial Growth & Age (both)12600
Radial Growth Only12100
Dead Woodland Species (5.0" + DRC)
Non-Mortality9400
Mortality10900
Live Timber Species Sapling (1.0 - 4.9" DBH)
No Radial Growth & Age8100
Radial Growth & Age (both)9300
Radial Growth Only8800
Age Only8800
Live Woodland Species Sapling (1.0 - 4.9" DRC)
No Radial Growth & Age8700
Radial Growth & Age (both)9900
Radial Growth Only9400
Age Only9400
Live Seedling Tally (all species)
No Age2400
Age Only2900

Nontally Site Tree 81 0 0

Total Value = 0 Total Value = 0

Tree Data - Large Trees

TREE DATA - LARGE TREES
Item Value# of ErrorsTotal ErrorTotal ItemsTotalScore:ERROR:#DIV/0!
Data ItemAttribute RequiredCheckedValue
Plot NumberXStatus:ERROR:#DIV/0!
Tag ID NumberX100
Tree StatusX200Unacceptable Data Item:None
Tree Class100
GST TreeX600
Tree SpeciesX400Total Value =0
Tree CountX100Total Error =0
Number of Stems100Percent Error =ERROR:#DIV/0!
DBH/DRCX600
HeightX400
Height to Crown200
Radial Growth300
Height Growth300
Tree Age400
Crown RatioX100
Crown Class100
Crown Width200
Wildlife Use100
Snag Decay ClassX200
Cone Serotiny100
Tree Damage CategoryX200
Tree Damage AgentX100
Tree Damage Part100
Tree Damage SeverityX100
Tree RemarksX400
Tree User Code600
Tree Treatment Option100
Tree Distance400
Tree Azimuth400
TREE DATA COMMENTS
Height - required on trees with broken or missing tops, Tree Age - required on GST trees

Tree Data - Small Trees

TREE DATA - SMALL TREES
Item Value# of ErrorsTotal ErrorTotal ItemsTotalScore:ERROR:#DIV/0!
Data ItemAttribute RequiredCheckedValue
Plot NumberXStatus:ERROR:#DIV/0!
Tag ID NumberX100
Tree StatusX200Unacceptable Data Item:None
Tree Class200
GSTX300
Tree SpeciesX200Total Value =0
Tree CountX100Total Error =0
Number of Stems100Percent Error =ERROR:#DIV/0!
DBH/DRCX200
HeightX200
Height to Crown100
Radial Growth100
Height Growth300
Tree AgeX200
Crown RatioX100
Crown Class100
Crown Width100
Wildlife Use100
Snag Decay ClassX100
Cone Serotiny100
Tree Damage CategoryX200
Tree Damage AgentX100
Tree Damage Part100
Tree Damage SeverityX100
Tree RemarksX200
Tree User Code600
Tree Treatment Option100
Tree Distance400
Tree Azimuth400
TREE DATA COMMENTS
Height - required on all trees with broken or missing tops, and trees < 4.5 ft tall; average height recorded on tree groups <5" DBH Tree Age - required on GST trees >= 3" DBH

Veg Comp Data

VEGETATION COMPOSITION & GROUND SURFACE COVER DATA

Data ItemAttribute RequiredItem Value# of ErrorsTotal ErrorTotal Items CheckedTotal ValueScore:ERROR:#DIV/0!
Veg CompLifeform100
Canopy Cover400Status:ERROR:#DIV/0!
Layer100
Species400Total Value =0
Ground Surface CoverTransect Azimuth100Total Error =0
Percent Error =ERROR:#DIV/0!
Cover Type Category400
Surface Cover %400

VEGETATION/GROUND SURFACE COMMENTS

DWM Data

DOWN WOODY MATERIAL

Score:ERROR:#DIV/0!
Item Value# of ErrorsTotal ErrorTotal Items
Data ItemAttribute RequiredCheckedTotal ValueStatus:ERROR:#DIV/0!
Plot NumberX
Protocols for Transect layout are followedX400Unacceptible Data Item:None
First DuffX200
Second DuffX200Total Value =0
Fuel Depth100Total Error =0
Twig 1 (1 Hour Fuels)X200Percent Error =ERROR:#DIV/0!
Twig 2 (10 Hour Fuels)X200
Twig 3 (100 Hour Fuels)X200
Piece CountX100
Log Decay ClassX200
Diameter at IntersectionX200
Piece Length400
Diameter Large End400
Diameter Small End100

DOWN WOODY MATERIAL DATA COMMENTS

File details come from the government source that posted it. Updated .