FLAT SLAB BBS AND CUTTING OPT.xlsx

	B	C	D	E	H	I	J	K	L	O	P	Q	R	S	X
1	FLAT SLAB BBS				USED					WASTE
2	Bar mark	Diameter	Length (m)	total	Diameter	Length (m)	total	1M WEIGHT	WEIGHT	Length (m)	Diameter	total	1M WEIGHT	WEIGHT
3
4
5	1	12	8	18	10	12	207	0.62	1533.33	0.2	10	46	0.62	5.68
6	2	12	11	18	12	12	584	0.89	6229.33	0.22	10	46	0.62	6.25
7	3	12	12	24	16	12	55	1.58	1042.96	0.3	10	5	0.62	0.93
8	4	12	5.2	2						1.26	10	21	0.62	16.33
9	5	12	3.46	174	TOTAL USED WEIGHT (KG)				8805.63	7.12	10	1	0.62	4.40
10	6	12	3.93	66	TOTAL USED WEIGHT (KG)				8805.63	0.07	12	10	0.89	0.62
11	7	12	9.71	268						0.21	12	7	0.89	1.31
12	8	12	9	12						0.1	12	2	0.89	0.18
13	9	12	8.2	12						0.21	12	44	0.89	8.21
14	10	12	3	94						0.38	12	30	0.89	10.13
15	11	16	2.4	28						0.1	12	2	0.89	0.18
16	12	16	2.2	12						0.7	12	16	0.89	9.96
17	13	16	2.4	8						0.7	12	2	0.89	1.24
18	14	16	2.6	7						0.7	12	2	0.89	1.24
19	15	16	4	7						0.7	12	16	0.89	9.96
20	16	16	3	80	BEFORE OPTIMIZATION					0.5	12	12	0.89	5.33
21	17	10	3.58	64	BEFORE OPTIMIZATION					0.61	12	7	0.89	3.80
22	18	10	1.3	46	TOTAL WASTE %			739.5 KG	8.4%	0.16	12	18	0.89	2.56
23	19	16	5	46						0.78	12	10	0.89	6.93
24	20	10	12	88						0.62	12	2	0.89	1.10
25	21	10	11.78	46						0.32	12	2	0.89	0.57
26	22	12	3.3	4						0.16	12	9	0.89	1.28
27	23	12	6.7	16						0.53	12	1	0.89	0.47
28	24	12	4.4	44	AFTER OPTIMIZATION					0.82	12	30	0.89	21.87
29	25	12	4.3	22	AFTER OPTIMIZATION					8.54	12	1	0.89	7.59
30	26	12	4.7	30	TOTAL WASTE %			207.09 KG	2.35%	2.5	12	8	0.89	17.78
31	27	12	2.7	30						2.29	12	6	0.89	12.21
32	28	12	9.3	30						0.2	16	2	1.58	0.63
33	29	12	3.3	30						2	16	14	1.58	44.25
34	30	12	9.5	44						1.6	16	1	1.58	2.53
35	31	12	7	16						1	16	1	1.58	1.58
36	32	12	7	2
37	33	12	0.71	10						TOTAL WASTE WEIGHT (KG)				207.09
38	34	12	0.84	139						TOTAL WASTE WEIGHT (KG)				207.09
39	35	10	11.8	23
40	36	10	11.8	23
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87															739.5
88
89
90
91
92
93
94
95
96
97
98
99
100