Exhibit 11_R1 IDIQ CSE_IM Scoring Spreadsheet.xlsx

View the file

Other files for this federal contract opportunity

Work with this file on GovTribe

Text version

XLSX spreadsheet 89 KB Posted Apr 29, 2020

Attached to: Vegetation Survey Data Collection Services IDIQ Federal contract opportunity
Solicitation number: 12034320R0010
Issued by: Department of Agriculture Forest Service R1-Northern Region

Other files attached to Vegetation Survey Data Collection Services IDIQ, newest first.
File	Type	Posted
CSE shapefiles.zip	ZIP file	May 20, 2020
Exhibit 5_R1 Veg Sampling for Lidar.pdf	PDF	Apr 29, 2020
Exhibit 2_R1 CSE_IM Appendices.pdf	PDF	Apr 29, 2020
Exhibit 19_Seed Project Task Order with Attachments.zip	ZIP file	Apr 29, 2020
12034320R0010_Region 1 Data Collection IDIQ.pdf	PDF	Apr 29, 2020
Exhibit 3_R1 CSE_IM Supplemental Appendices.pdf	PDF	Apr 29, 2020
Exhibit 14_Additional Camping Provisions.docx	DOCX document	Apr 29, 2020
Exhibit 8_Contractor Setting Tracking Spreadsheet.xlsx	XLSX spreadsheet	Apr 29, 2020
Exhibit 15_R1 Food Storage Orders Occupancy Use Restrictions.docx	DOCX document	Apr 29, 2020
Exhibit 16_Quality Assurance Surveilance Plan.docx	DOCX document	Apr 29, 2020
Exhibit 1_R1 CSE_IM Field Guide.pdf	PDF	Apr 29, 2020
Exhibit 9_R1 Supplement National FSVeg CSE Users Guide Chapter 3.pdf	PDF	Apr 29, 2020
Exhibit 6_Mid-cycle Remeasurement of FIA Plots.pdf	PDF	Apr 29, 2020
Exhibit 13_Camp Management Plan_Use of Premises Permit.docx	DOCX document	Apr 29, 2020
Exhibit 17_CSE Setting_Stand Narrative Form.doc	DOC document	Apr 29, 2020
Exhibit 12_R1FSVegPlantCodes.xlsx	XLSX spreadsheet	Apr 29, 2020
Exhibit 18_R1 Regional Closure Order Camping Restrictions.pdf	PDF	Apr 29, 2020
Exhibit 10_R1 Supplement National FSVeg CSE Users Guide Chapter 5.pdf	PDF	Apr 29, 2020
Exhibit 4_R1 CSE OG Protocols.pdf	PDF	Apr 29, 2020
Exhibit 20_Past Performance Questionaire.doc	DOC document	Apr 29, 2020
Exhibit 7_R1 Intensified Grid Field Procedures.pdf	PDF	Apr 29, 2020

Show all 21

On GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

X Witness Tree

Attribute Required

Total Error

Total Item Checked

Total Value

Selection Criteria Met & X Tagged

Slope Distance to Plot Center

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!	FALSE	FALSE
# 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 ITEMS

Acceptable

Unacceptable

Included on Task Order

All completed forms/data submitted in a timely manner:

All forms legible and can be reproduced via copy machine:

All electronic data can be read by Government computer software:

No settings with BAF used resulting in < min. average # live trees specified:

BAF/FRQ on setting sample design for Trees matches the BAF on Paper Setting Form/Narrative:

All plot center locations within tolerance of theoretical and unbiased:

INSPECTION STATUS BY FORM

Settings have prescribed number of sample plots examined:

Accurate count and species of large live sample trees recorded:

Form included on Task Order

Acceptable or Satifactory

Score

Sat

Unsat

Unacceptable Data Item

All reference points & plot center points relocatable and labeled to specs:

Setting Form:

ERROR:#DIV/0!

None

All settings contain minimum number of GST trees (as specified):

Sample Design Form:

ERROR:#DIV/0!

None

Settings submitted with complete information for all forms/data:

Plot Monument Form:

ERROR:#DIV/0!

None

All forms contain accurate setting locations and numbering information:

Plot Form:

ERROR:#DIV/0!

None

All Government supplied data complete & accurately transcribed to forms:

Large Tree Form:

ERROR:#DIV/0!

None

All plots are evenly distributed within each setting:

Small Tree Form:

ERROR:#DIV/0!

None

No settings contain an 'Unacceptable' error in the Inspection Form:

Veg Composition Form:

ERROR:#DIV/0!

N/A

No sample plot centers fall outside of setting boundary:

Down Woody Material Form:

ERROR:#DIV/0!

None

Any additional Task Order required items carried out as specified:

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
SETTING	PLOT NUMBERS

INSPECTION COMMENTS & FOLLOW-UP ACTIONS

Setting Insp Form Setting Inspection Form

Data Item	Attribute Required	Item Value	# of Errors	Total Error	Total Items Checked	Total Value	Score:	ERROR:#DIV/0!
Project Name						0
Proclaimed Region						0	Unacceptable Data Item:	None
Proclaimed Forest						0
District						0	Status:	ERROR:#DIV/0!
Location						0
Stand Number						0		Total Value:	0
Ownership						0		Total Error:	0
State						0		Percent Error:	ERROR:#DIV/0!
County						0
Administrative Forest						0
Date		2		0		0
Photo ID		0		0		0
Exam Level						0
Exam Purpose						0
Stratum		0		0		0
Existing Veg Reference						0
Existing Veg Composition Type		4		0		0
Potential Veg Reference						0
Potential Veg		10		0		0
Structure		2		0		0
Capable Growing Area		2		0		0
Fuel Model		4		0		0
Elevation		2		0		0
Aspect		2		0		0
Slope		2		0		0
Slope Position		1		0		0
Acres		1		0		0
Examiner		1		0		0
Precision Protocol		1		0		0
Radial Growth Interval						0
Height Growth Interval						0
Fuel Photo Reference						0
Setting User Code		5		0		0
Datum						0
Magnetic Declination						0
Measurement Number						0
Setting Remarks		7		0		0
Damage Category		4		0		0
Damage Agent		2		0		0
Damage Severity		2		0		0
Species of Mgmt. Interest		2		0		0
Setting Narrative/Sketch Map/Travel Notes		7		0		0

SETTING DATA COMMENTS

Sample Design Insp Form

Sample Design Inspection Form
		Item Value	# of Errors	Total Error	Total Items	Total	Score:	ERROR:#DIV/0!
Data Item	Attribute Required				Checked	Value
Sample Selection Method Type							Status:	ERROR:#DIV/0!
Sample Expansion Factor
Starting Azimuth		0		0		0	Unacceptable Data Item:	None
Subpopulation Filter
Sample Design Remarks		0		0		0		Total Value =	0
Selection Criteria								Total Error =	0
Subpopulation Variable								Percent Error =	ERROR:#DIV/0!
Subpopulation Minimum Value
Subpopulation Maximum Value

SAMPLE DESIGN DATA COMMENTS

Plot Level Data

PLOT LEVEL DATA
		Item Value	# of Errors	Item Error	Score =	ERROR:#DIV/0!
Data Item	Tolerance
State	no errors	2		0	Status =	ERROR:#DIV/0!
County	no errors	2		0
Plot Number	no errors	2		0
Plot Status	no errors	5		0		Total Value =		enter value from chart
Nonforest Sampling Status	no errors	3		0		Total Error =	0
						Percent Error =	ERROR:#DIV/0!
Condition Class Change	no errors	3		0
Subplots Examined	no errors	3		0		Values by Plot Type
Regional Sample Kind	no errors	5		0
Previous Plot Number	no errors	3		0			P2 Plot	P3 Plot
Horizontal Distance to Improved Road	no errors	4		0		Forest	60
Water on Plot	no errors	4		0		Nonforest	36
QA Status	no errors	5		0		Remeasurement	58
Crew Type	no errors	5		0		Nonsampled	36
GPS Unit	no errors	2		0		ACP	75
UTM Zone	no errors	2		0
Easting (X) UTM	140 feet	4		0
Northing (Y) UTM	140 feet	4		0
Azimuth to Plot Center	3 degrees	3		0
Distance to Plot Center	6 feet	3		0
GPS Elevation	100 feet	4		0
Future Forest Potential	no errors	3		0
PLOT LEVEL DATA COMMENTS

Monument Data

Monument Data
Vehicle Coordinates	Attribute Required	Item Value	# of Errors	Item Error	Total Items Checked	Total Value	Score:	ERROR:#DIV/0!
Latitude						0
Longitude						0	Status:	ERROR:#DIV/0!

Reference Point/Navigation Info	Attribute Required	Value	Error	Total Error	Total Item Checked	Total Value	Unacceptable data item:	None
Azimuth RP to Plot Center						0
Slope Distance to Plot Center						0		Total Value=	0
Remarks		1		0		0		Total Error=	0
Selection Criteria Met & RP Tagged						0		Percent Error=	ERROR:#DIV/0!
RP Species		3		0		0
RP Diameter		2		0		0
Latitude		3		0		0
Longitude		3		0		0
Error		1		0		0
Plot Navigated From		3		0		0
Azimuth from Navigation Plot		3		0		0
Distance from Navigation Plot		3		0		0

Plot Center & Location Information	Attribute Required	Value	Error	Total Error	Total Item Checked	Total Value
Point of Departure		1		0		0
Plot center flagging present and legible		1		0		0
Transect stakes & flagging present & legible		1		0		0
Error		1		0		0
PC stake present						0
Plot Narrative						0
Plot Location Map						0
Detailed road Travel Description						0
Detailed hiking Travel Description						0
Plot Monument Data Notes

Location Reference Items

FIELD LOCATION REFERENCE ITEMS
Finding the Plot
		Item Value	# of Errors	Item Error	Score =	100.0
Data Item	Tolerance
Travel Description	complete & accurate	5		0	Status =	ACCEPTABLE
Truck UTM Zone	no errors	2		0
Truck UTM Easting	140 feet	2		0		Total Value =	203
Truck UTM Northing	140 feet	2		0		Total Error =	0
Owner Contact	no errors	2		0		Percent Error =	0.0
4 X 4	no errors	2		0
ATV	no errors	2		0
Locked Gate	no errors	2		0
Owner	not entered into PDR	5		0
Photo Project	no errors	2		0
Photo Roll	no errors	2		0
Photo Numbers	no errors	2		0
Photo Scale	no errors	2		0
Photo Year	no errors	2		0
Photo Scale Reciprocal	no errors	2		0
Township	no errors	2		0
Range	no errors	2		0
Section	no errors	2		0
Field Location Sketch Map	complete & accurate	10		0
Reference Point
		Item Value	# of Errors	Item Error
Data Item	Tolerance
Selection	best available	5		0
Description	complete & accurate	5		0
Species	no errors	10		0
Diamter	0.2 inch per 20 inches of diameter	10		0
Tags	correctly placed & scribed	10		0
UTM Zone	no errors	2		0
UTM Easting	140 feet	2		0
UTM Northing	140 feet	2		0
RP to LC Traverse
		Item Value	# of Errors	Item Error
Data Item	Tolerance
Azimuth	2 degrees	5		0
Horizontal Distance	6 feet per 100 feet of transect, 30 feet maximum	5		0
Slope Distance	6 feet per 100 feet of transect, 30 feet maximum	5		0
Witness Trees
		Item Value	# of Errors	Item Error
Data Item	Tolerance
X Selection	best available	5		0
X Species	no errors	10		0
X Diameter	0.2 inch per 20 inches of diameter	10		0
X Azimuth	2 degrees	5		0
X Distance	0.2 feet	5		0
X Tags	correctly placed & scribed	10		0
Y Selection	best available	5		0
Y Species	no errors	10		0
Y Diameter	0.2 inch per 20 inches of diameter	10		0
Y Azimuth	2 degrees	5		0
Y Distance	0.2 feet	5		0
Y Tags	correctly placed & scribed	10		0
FIELD LOCATION REFERENCE ITEMS COMMENTS

Plot Data

Plot Inspection Form
		Item Value	# of Errors	Total Error	Total Items	Total	Score:	ERROR:#DIV/0!
Data Item	Attribute Required				Checked	Value
Plot Number							Status:	ERROR:#DIV/0!
Plot Latitude		10		0		0
Plot Longitude		10		0		0	Unacceptable Data Item:	None
Plot Capable Growing Area		2		0		0
Plot Aspect		4		0		0		Total Value =	0
Plot Slope		4		0		0		Total Error =	0
Slope Position		2		0		0		Percent Error =	ERROR:#DIV/0!
Slope Horizontal Shape		2		0		0
Slope Vertical Shape		2		0		0
Plot Elevation		2		0		0
Plot Existing Veg Comp Type		5		0		0
Plot Potential Vegetation Code		10		0		0
Plot Fuel Model		4		0		0
Residual Descriptive Code		2		0		0
Distance to Seed Wall		2		0		0
Plot User Code		5		0		0
Plot History		2		0		0
Plot History Date		1		0		0
Plot Remarks		8		0		0

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 & Age	112	0	0
Radial Growth & Age (both)	124	0	0
Radial Growth Only	119	0	0

Dead Timber Species (5.0" + DBH)
Non-Mortality	85	0	0
Mortality	100	0	0

Live Woodland Species (5.0" + DRC)
No Radial Growth & Age	114	0	0
Radial Growth & Age (both)	126	0	0
Radial Growth Only	121	0	0

Dead Woodland Species (5.0" + DRC)
Non-Mortality	94	0	0
Mortality	109	0	0

Live Timber Species Sapling (1.0 - 4.9" DBH)
No Radial Growth & Age	81	0	0
Radial Growth & Age (both)	93	0	0
Radial Growth Only	88	0	0
Age Only	88	0	0

Live Woodland Species Sapling (1.0 - 4.9" DRC)
No Radial Growth & Age	87	0	0
Radial Growth & Age (both)	99	0	0
Radial Growth Only	94	0	0
Age Only	94	0	0

Live Seedling Tally (all species)
No Age	24	0	0
Age Only	29	0	0

Nontally Site Tree 81 0 0

Total Value = 0 Total Value = 0

Tree Data - Large Trees

TREE DATA - LARGE TREES
		Item Value	# of Errors	Total Error	Total Items	Total	Score:	ERROR:#DIV/0!
Data Item	Attribute Required				Checked	Value
Plot Number							Status:	ERROR:#DIV/0!
Tag ID Number		1		0		0
Tree Status		2		0		0	Unacceptable Data Item:	None
Tree Class		1		0		0
GST Tree		6		0		0
Tree Species		4		0		0	Total Value =	0
Tree Count		1		0		0	Total Error =	0
Number of Stems		1		0		0	Percent Error =	ERROR:#DIV/0!
DBH/DRC		6		0		0
Height		4		0		0
Height to Crown		2		0		0
Radial Growth		3		0		0
Height Growth		3		0		0
Tree Age		4		0		0
Crown Ratio		1		0		0
Crown Class		1		0		0
Crown Width		2		0		0
Wildlife Use		1		0		0
Snag Decay Class		2		0		0
Cone Serotiny		1		0		0
Tree Damage Category		2		0		0
Tree Damage Agent		1		0		0
Tree Damage Part		1		0		0
Tree Damage Severity		1		0		0
Tree Remarks		4		0		0
Tree User Code		6		0		0
Tree Treatment Option		1		0		0
Tree Distance		4		0		0
Tree Azimuth		4		0		0

TREE DATA COMMENTS

Tree Data - Small Trees

TREE DATA - SMALL TREES
		Item Value	# of Errors	Total Error	Total Items	Total	Score:	ERROR:#DIV/0!
Data Item	Attribute Required				Checked	Value
Plot Number							Status:	ERROR:#DIV/0!
Tag ID Number		1		0		0
Tree Status		2		0		0	Unacceptable Data Item:	None
Tree Class		2		0		0
GST		3		0		0
Tree Species		2		0		0	Total Value =	0
Tree Count		1		0		0	Total Error =	0
Number of Stems		1		0		0	Percent Error =	ERROR:#DIV/0!
DBH/DRC		2		0		0
Height		2		0		0
Height to Crown		1		0		0
Radial Growth		1		0		0
Height Growth		3		0		0
Tree Age		2		0		0
Crown Ratio		1		0		0
Crown Class		1		0		0
Crown Width		1		0		0
Wildlife Use		1		0		0
Snag Decay Class		1		0		0
Cone Serotiny		1		0		0
Tree Damage Category		2		0		0
Tree Damage Agent		1		0		0
Tree Damage Part		1		0		0
Tree Damage Severity		1		0		0
Tree Remarks		2		0		0
Tree User Code		6		0		0
Tree Treatment Option		1		0		0
Tree Distance		4		0		0
Tree Azimuth		4		0		0

TREE DATA COMMENTS

Veg Comp Data

VEGETATION COMPOSITION & GROUND SURFACE COVER DATA

	Data Item	Attribute Required	Item Value	# of Errors	Total Error	Total Items Checked	Total Value		Score:	ERROR:#DIV/0!
Veg Comp	Lifeform		1		0		0
	Canopy Cover		4		0		0	Status:	ERROR:#DIV/0!
	Layer		1		0		0
	Species		4		0		0		Total Value =	0
Ground Surface Cover	Transect Azimuth		1		0		0		Total Error =	0
									Percent Error =	ERROR:#DIV/0!
	Cover Type Category		4		0		0
	Surface Cover %		4		0		0

VEGETATION/GROUND SURFACE COMMENTS

DWM Data

DOWN WOODY MATERIAL

							Score:	ERROR:#DIV/0!
		Item Value	# of Errors	Total Error	Total Items
Data Item	Attribute Required				Checked	Total Value	Status:	ERROR:#DIV/0!
Plot Number
Protocols for Transect layout are followed		4		0		0	Unacceptible Data Item:	None
First Duff		2		0		0
Second Duff		2		0		0	Total Value =	0
Fuel Depth		1		0		0	Total Error =	0
Twig 1 (1 Hour Fuels)		2		0		0	Percent Error =	ERROR:#DIV/0!
Twig 2 (10 Hour Fuels)		2		0		0
Twig 3 (100 Hour Fuels)		2		0		0
Piece Count		1		0		0
Log Decay Class		2		0		0
Diameter at Intersection		2		0		0
Piece Length		4		0		0
Diameter Large End		4		0		0
Diameter Small End		1		0		0

DOWN WOODY MATERIAL DATA COMMENTS

File details come from the government source that posted it. Updated Apr 29, 2020.