Statewide Spreadsheets

Last updated: 2021-01-13

Statewide Pantry Spreadsheet Changes

Here is a list of the Statewide Spreadsheets to be referenced when administering a construction contract.

File Name Description
1YearPlantWarr.xlsx 1 Year Plant Warranty Trees Shrubs Vines
2YearPlantWarr.xlsx 2 Year Plant Warranty Trees Shrubs Vines
Acre.xlsx Acre
AEWEllipRnd.xlsx Apron Endwall Elliptical and Round Pipe
AreaByCoord.xlsx Area by Coordinates
AsphaltPavingDiary.xlsx Asphalt Paving Diary
BarsSize4thru11.xlsx Bar Steel Size No. 4 thru No. 11
BasePatch.xlsx Base Patch
ClGr.xlsx Clearing and Grubbing
Comp.xlsx Computation Sheet
ConcDwy.xlsx Concrete Driveway
ConcMixDesignNoQMP.xlsx Concrete Mix Design No QMP
CulvertPipe.xlsm Culvert Pipe
CY.xlsx Cubic Yard (CY)
CYTruckload.xlsx Cubic Yard Truckload (CY)
EA.xlsx Each (EA)
ElectricalLinealFoot.xlsx Electrical Lineal Foot - For conduit, not wire or cable in duct (CID)
ElectricalLoopDetectors.xlsx Electrical Loop Detectors
ElectricalWire.xlsx Electrical Wire
EndAreaByCoord.xlsx End Area by Coordinates
EndAreaCY.xlsx End Area by Cubic Yard
FertTypeA&B.xlsx Fertilizer Type A & Fertilizer Type B
ForceAccountCost.xlsx Force Account Invoice
ForceAccountWkly.xlsx Weekly Force Account Cost Report
FuelCostAdj.xlsx Fuel Cost Adjustment
Geoshape.xlsx Geometric Shape
GeoshapeSFandCYd.xlsx Geometric Shape Square Feet and Cubic Yard
GirderTenthPoints.xlsx Girder Tenth Points
GranBackfillPgs1and2.xlsx Granular Backfill
Hammer(ModifiedGates).xlsx Modified Gates Hammer
hma-density-field-ws-v2.1.1.xlsm HMA Field Density
hma-pwl-production-v2.1.1.xlsm HMA PWL Production
hma-pwl-test-strip-v2.1.xlsm HMA PWL Test Strip
LF.xlsx Linear Foot (LF)
MGal.xlsx Mega Gallon (MGAL)
Mobil.xlsx Mobilization
PipeSum.xlsx Pipe
QmpNpNcTrkg.xlsx QMP Nonperformance and QMP Nonconformance
Signs.xlsx Signing and Post
SignSupportsStrSteelHS.xlsx Signs Supports Structural Steel HS
SlabSpanTenthPoints.xlsm Slab Span Grade Setting
SqFt.xlsx Square Foot (SF)
SqYd.xlsx Square Yard (SY)
SqYdAvgWidth.xlsx Square Yard Average Width (SY)
Sum.xlsx Summary
TackConv.xlsx Tack Conversion
TicketsLbsToTons.xlsx Tickets Lbs to Tons
TicketsNonComputerized.xlsx Tickets Non Computerized
TicketsTon.xlsx Tickets Ton
TraffCont.xlsx Traffic Control
Trans.xlsx Superelevation Transition
VertCurve.xlsx Vertical Curve


Pantry Spreadsheet Subcommittee Members (Chairperson denoted with an *)

Member Representing Email address Telephone Number
Chad Hayes* DTSD Bureau of Project Development 608-246-5391
Dan Bauknecht SW Region – Madison 608-516-6303
Evan Maves NC Region - Rhinelander 715-365-5778
Matthew Smith SE Region - Waukesha 414-750-1537 (M)
Keena Spencer-Dobson NW Region – Eau Claire 715-577-3852
Kurt Vogel NE Region - Green Bay 920-362-1732 (M)