Trimble Quest Data Importation Template.xlsx

	A	B	C	D	E	F	G	I
1	Code	Name	Resource Attribute (Type)	Cost Type	Sub Type	Unit	Rate	Notes:
2	L001	General Labour	L	1		Hr	32.00	When assigning a resource attribute, use the code, not the name of the applicable resource attribute.
3	L004	Bricklayer	L			Hr	53.00
4	L008	Carpenter	L			Hr	58.00
5	L012	Plasterer	L			Hr	58.00
6	M001	Bricks	M			No.	2.00
7	M004	Brick Force	M			m	1.50
8	M007	Damp Course	M			m	2.50
9	M010	Building Sand	M			m3	80.00
10	M013	19mm Concrete Stone	M			m3	180.00
11	M016	Cement (50kg Pocket)	M			pocket	70.00
12	M019	Ready-mix Concrete 20 MPa (Delivered)	M			m3	1450.00
13	M022	Ready-mix Concrete 30 MPa (Delivered)	M			m3	1650.00
14	M025	Diesel	M			litre	12.50
15	M028	120mm PVC Pipe	M			m	25.00
16	M031	50mm PVC Pipe	M			m	8.00
17	M034	T Junction - 120mm PVC	M			no.	30.50
18	M037	T Junction - 50mm PVC	M			no.	3.50
19	M040	45deg Bend - 120mm PVC	M			no.	18.50
20	M043	45deg Bend - 50mm PVC	M			no.	2.50
21	M046	90deg Bend - 120mm PVC	M			no.	25.00
22	M049	90deg Bend - 50mm PVC	M			no.	2.00
23	M052	Connecter - 120mm PVC	M			no.	75.00
24	M055	Connecter - 50mm PVC	M			no.	4.00
25	M058	PVC Glue	M			Tube	65.00
26	M061	Conduit - 45mm PVC	M			m	12.50
27	M064	Conduit Bends - 45mm PVC	M			no.	6.00
28	M067	Electrical Cable - 3 Core	M			m	18.00
29	M070	Electrical Cable - Single Core	M			m	6.00
30	M073	Circuit Breaker - 10 Amp	M			no.	65.00
31	M076	Circuit Breaker - 20 Amp	M			no.	95.00
32	M079	Circuit Breaker - 30 Amp	M			no.	125.00
33	M082	Earth Leakage - 60 Amp	M			no.	195.00
34	M085	Electrical DB Board	M			no.	350.00
35	M088	Pre-Paid Electrical Meter	M			no.	850.00
36	M091	Exterior Door - 950mm x 2000mm	M			no.	350.00
37	M094	Interior Doors - 950mm x 2000mm	M			no.	290.00
38	M097	Top Hung 600x600 Window	M			no	1200.00
39	M100	Top Hung 600x900 Window	M			no.	1350.00
40	M103	Top Hung 900x1200 Window	M			no.	1650.00
41	M106	Roof Truss - 4m b x 0.5m h	M			no.	1400.00
42	M109	3' x 4' Wooden Purlins	M			m	25.00
43	M112	Roofing Nails	M			no.	0.38
44	M115	Steel Roof Sheeting	M			m2	85.00
45	M118	Solar Geyser	M			no.	5500.00
46	M121	Floor Tiles	M			m2	45.00
47	M124	Tile Grout	M			kg	20.00
48	M127	Lintel - 600mm	M			no.	130.00
49	M130	Lintel - 900mm	M			no.	165.00
50	M133	Skirtings	M			m	12.00
51	M136	Aluminium Gutters	M			m	65.00
52	M139	Ceiling Light Fitting	M			no.	95.00
53	M142	Wall Light Fittings	M			no.	125.00
54	M145	Single Plug Points	M			no.	75.00
55	M148	Double Plug Points	M			no.	145.00
56	M151	Light Switches	M			no.	65.00
57	M154	Ceiling Lights	M			no.	75.00
58	M157	Wall Lights	M			no.	85.00
59	M160	Rhino Board Ceiling	M			Board	450.00
60	M163	Crete Stone	M			kg	55.00
61	M166	Ceiling Cornices	M			m	16.00
62	M169	Shower Door	M			no.	850.00
63	M172	Shower Head	M			no.	98.00
64	M175	Shower Waste	M			no.	45.00
65	M178	Shower Floor Tiles	M			m2	60.00
66	M181	Shower Wall Tiles	M			m2	70.00
67	M184	Bathroom Basin	M			no.	550.00
68	M187	Bathroom Basin Taps	M			no.	150.00
69	M190	Kitchen Basin	M			no.	350.00
70	M193	Building Water	M			kl	3.00
71	M196	Steel Mesh - 314 Ref	M			kg	12.50
72	M199	Lintel 1200mm	M			No	210.00
73	M202	Exterior Door Frame - 950mm x 2000mm	M			No.	650.00
74	M205	Interior Door Frame - 950mm x 2000mm	M			No.	600.00
75	M208	Lime (25kg Pocket)	M			pocket	45.00
76	M211	Kitchen Basin Taps	M			No.	98.00
77	M214	Tile Cement	M			kg	5.00
78	P001	Cement Mixer - 1m3	E			Day	450.00
79	P004	Hired TLB	E			Hr	260.00
80	P007	Establishment TLB	E			no.	1350.00
81	P010	Poker Vibrator	E			Day	280.00
82	P013	Wacker	E			Day	450.00
83	S001	Tiling Sub-Contractor	S			m2	35.00
84	S005	Kitchen Cupboard Sub-Contractor	S			Sum	25000.00
85	S009	Bedroom Cupboard Sub-Contractor	S			Sum	15500.00
86	S013	Plumbing Sub-Contractor	S			Sum	25000.00
87	S017	Electrical Sub-Contractor	S			Sum	30000.00
88
89
90
91
92
93
94
95
96
97
98
99
100