CREATE THE SCHEDULE FILE FOR IMPORTING

We have a Prospective Client that requires us to price a schedule. The schedule can often be given to us in an Excel spreadsheet. Included will be the Quantity to price. Eg 1000 M3 or LS etc
Maintain this spreadsheet into the format the Workbench requires, or create a spreadsheet with the required information.

The Excel spreadsheet needs 14 Columns to bring in the data required.

Item Code	Item Description	Unit	Activity Code	Work Centre	Cost Sheet Code	Cost Sheet Description	Header	Cost Rate	Sell Rate	No Of Units	Unit Length	Quantity	Line Type
1	Establishment	LS			050	Preliminary and General						1	S
2	Permits and Fees	LS			050	Preliminary and General						1	S
3	Insurance	LS			050	Preliminary and General						1	S
4	Maintenance	LS			050	Preliminary and General						1	S
5	Setting out of Works by Planscaps Ltd.	PS			050	Preliminary and General						1	S
101	Install and Maintain all Temporary and Interim silt/erosion control measures within Earthworks areas.	LS			100	Earthworks						1	S
102	To strip topsoil to temporary stockpile	m3			100	Earthworks						1850	S
103	To strip topsoil to waste off site	m3			100	Earthworks						500	S
104	To cut unsuitable material to waste off site	m3			100	Earthworks						1000	S
105	To cut the fill of unsuitable material on site. Includes realigned creeks, sections, road and right of way.	m3			100	Earthworks						2000	S
106	Structural filling (place and compact to NZS 4431				100	Earthworks	Yes					0	S
106 1	a) To cut to fill on road line, rights of way and section areas	m3			100	Earthworks	106					500	S
200	Allow to construct standard kerb and channelling and concrete nib to road and rights of way				200	Kerb & Channel	Yes					0	S
200 1	Rate to include supply and construction of all materials, preparation of the base with 50mm compacted AP20 basecourse, installation of brass plaques and kerb cut downs.				200	Kerb & channel	200					0	S
201	Standard kerb and channel				200	Kerb & Channel	Yes					0	S
201.1	a) Marsden Valley Road	m			200	Kerb & Channel	201					206	S
201.2	b) Culdesac & ROW	m			200	Kerb & Channel	201					207	S
202	150 x 225 Concrete Nib	m			200	Kerb & Channel						194	S
211	Basecourse - Culdesac & ROW A				210	Road and Pavement	Yes					0	S
211.1	a) Allow to supply, place and compact AP40 basecourse to carriageway and to test preseal surface with benkleman beam	m3			210	Road Pavement	211					148	S
211.2	b) Allow to supply, place and compact AP65 basecourse to carriageway	m3			210	Road Pavement	211					160	S

Item Code
This is the ID in the schedule.
Make the Item Code unique. If not it will be OK in the quote but when imported into the Schedule the import will fail where the Item Code (Output Code) is not unique for that Schedule.

Item Description
Where this is longer than 50 characters it will utilise the Long Description field automatically and truncate 50 characters into the short Description

Unit
Self explanatory - 10 character max

Activity Code & Work Centre.
Can be null. They are not utilised at the quote schedule stage. Look at the note in the Setup section for the Work Centre defaults. Where they are Null it utilises the Control Parameter 'Quote Default Activity Code' for the Work Centre.

Cost Sheet Code & Description.
Every line needs to be populated with a code and description related to the schedule groupings. It will automatically create the cost sheets for each of these groupings.

Header Line Code.
This will need a discrete Item Code and 'Yes' in this field where the Line is a Header only. Where there are associated lines to this Header then the Header Lines Item Code is entered in their respective Header Line Code field. Note that this will later create a Header record in the Schedule and Claim.

Cost Rate
Will normally be null as you will cost it all up once the schedule lines have been imported into the quote.

Sell Rate
If you have already submitted the quote to the client then enter the Sell Rate. Otherwise Null.

No. of Units & Unit Length.
Notational fields only.

Quantity
Enter the quantity for that schedule line or 0 for a header line.

Line Type
Always S for Schedule.

Note: Much of the detail entered here, will be imported into the Workbench Contract Schedule for the generation of the claim. This will form the basis of the claim reporting to the client.

Save the Excel spreadsheet as a TXT file.

Browser not supported