High School Grading Project Analytical Steps - Calculations

	A	B	C	D	E	F
1	PUSH CREW - dozers
2	Dozer capacity (lm3)			1.93
3	Dozer Speed (km/h)			4
4	Dozer Maneuver (min)			0.1
5
6	Job No.	Nodes		Haul Distance (metre)	Cycle Time (hr/cycle)	Productivity (lcm/hr)
7	Job No.	From	To	Haul Distance (metre)	Cycle Time (hr/cycle)	Productivity (lcm/hr)
8	1	D2	D1	20	0.012	124.071
9	2	D2	E2	20	0.012	124.071
10	3	E1	E2	20	0.012	124.071
11	4	E2	F2	20	0.012	124.071
12	5	F2	G2	20	0.012	124.071
13	6	E3	G2	60	0.032	45.711
14	7	E3	H2	80	0.042	34.740
15	8	E3	F3	20	0.012	124.071
16	9	E4	F3	20	0.012	124.071
17	10	E4	G3	60	0.032	45.711
18	11	E4	H3	80	0.042	34.740
19	12	F4	G4	20	0.012	124.071
20	13	F4	H4	40	0.022	66.808
21	14	E4	H4	60	0.032	45.711
22	15	E5	G5	40	0.022	66.808
23	16	E5	H5	60	0.032	45.711
24	17	E5	H4	80	0.042	34.740
25	18	F5	I5	60	0.032	45.711
26	19	F6	G6	20	0.012	124.071
27	20	F6	H6	40	0.022	66.808
28	21	E6	H6	60	0.032	45.711
29	22	E6	I6	80	0.042	34.740
30	23	F7	G7	20	0.012	124.071
31	24	F7	H7	40	0.022	66.808
32	25	F7	I7	60	0.032	45.711
33	26	F7	I6	80	0.042	34.740
34	27	G8	H8	20	0.012	124.071
35	28	G8	I6	80	0.042	34.740
36	29	F8	I6	100	0.052	28.016
37	30	F5	I6	80	0.042	34.740
38	31	E5	I6	100	0.052	28.016
39	32	I5	J5	20	0.012	124.071
40	33	I6	J6	20	0.012	124.071
41
42	WASTE CREW 1 - trucks
43	Truck capacity (lm3)			16.5
44	Truck load/wait time (min)			10
45	Truck dump time (min)			2
46	Truck speed - site (km/h)			24
47	Truck speed - local (km/h)			50
48	Distance to waste (m)			30000
49
50	Job No.	Nodes		Haul Distance (metre)	Cycle Time (hr/cycle)	Productivity (lcm/hr)
51	Job No.	From	To	Haul Distance (metre)	Cycle Time (hr/cycle)	Productivity (lcm/hr)
52	1	C3	W	30020	1.402	8.829
53	2	C4	W	30040	1.403	8.818
54	3	D3	W	30040	1.403	8.818
55	4	D4	W	30060	1.405	8.808
56	5	C5	W	30060	1.405	8.808
57	6	D5	W	30080	1.407	8.797
58	7	C6	W	30080	1.407	8.797
59	8	D6	W	30100	1.408	8.787
60	9	D7	W	30120	1.410	8.777
61	10	E7	W	30140	1.412	8.766
62	11	D8	W	30140	1.412	8.766
63	12	E8	W	30160	1.413	8.756
64	13	F8	W	30180	1.415	8.746
65	14	D9	W	30160	1.413	8.756
66	15	E9	W	30180	1.415	8.746
67	16	F9	W	30200	1.417	8.735
68
69	WASTE CREW 2 - trucks
70
71	Truck capacity (lm3)			16.5
72	Truck load/wait time (min)			10
73	Truck dump time (min)			2
74	Truck speed - site (km/h)			24
75	Truck speed - local (km/h)			50
76	Distance to waste (m)			30000
77
78	Job No.	Nodes		Haul Distance (metre)	Cycle Time (hr/cycle)	Productivity (lcm/hr)
79	Job No.	From	To	Haul Distance (metre)	Cycle Time (hr/cycle)	Productivity (lcm/hr)
80	1	B6	W	30020	1.402	8.829
81	2	B7	W	30040	1.403	8.818
82	3	C7	W	30060	1.405	8.808
83	4	B8	W	30060	1.405	8.808
84	5	C8	W	30080	1.407	8.797
85	6	B9	W	30080	1.407	8.797
86	7	C9	W	30100	1.408	8.787
87	8	A9	W	30100	1.408	8.787
88	9	A10	W	30120	1.410	8.777
89	10	B10	W	30100	1.408	8.787
90	11	C10	W	30120	1.410	8.777
91
92
93
94
95
96
97
98
99
100