Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Plan and Certificate for Cable

Hi friends,

I am doing implementation in cable industry

I have came across the scenario on which i required your suggestions Requirement is like that client is producing cable tube. In that single cable there is 5-7 other coloured Binder. In those coloured Binder bundels 10-12 fibres in each coloured binder bundels. For those coloured fibres some quality tests are performed like attunation check etc. I need to make a quality plan according to these requirements and certificate generation like below.  Please check below  sheet and provide your valuable sugessions to map the scenario,



SR. NO.COLOUR OFCOLOUR OFCOLOUR OFATTENUATION (dB/Km) REMARKSSR. NO.COLOUR OFCOLOUR OFCOLOUR OFATTENUATION (dB/Km) REMARKS
TUBEBINDERFIBRE @ 1310nm @ 1550nm TUBEBINDERFIBRE @ 1310nm @ 1550nm
1BLUE (FIRST LAYER)BLUE(BUNDLE 1)BLUE0.3300.184OK73BROWN (FIRST LAYER)BLUE(BUNDLE 1)BLUE0.3320.186OK
2ORANGE0.3300.18674ORANGE0.3290.183
3GREEN0.3300.18875GREEN0.3300.186
4BROWN0.3330.18676BROWN0.3290.185
5GREY0.3310.18377GREY0.3290.185
6WHITE0.3300.18678WHITE0.3300.185
7RED0.3300.18479RED0.3310.184
8BLACK0.3290.18380BLACK0.3290.187
9YELLOW0.3280.18581YELLOW0.3310.187
10VIOLET0.3290.18382VIOLET0.3280.184
11PINK0.3310.18683PINK0.3290.186
12TURQUOISE0.3280.18584TURQUOISE0.3290.185
13ORANGE(BUNDLE 2)BLUE0.3290.186OK85ORANGE(BUNDLE 2)BLUE0.3300.186OK
14ORANGE0.3300.18586ORANGE0.3310.185
15GREEN0.3320.18387GREEN0.3300.184
16BROWN0.3290.18388BROWN0.3300.187
17GREY0.3290.18889GREY0.3300.186
18WHITE0.3320.19190WHITE0.3300.184
19RED0.3290.18591RED0.3280.185
20BLACK0.3290.18592BLACK0.3290.183
21YELLOW0.3290.18493YELLOW0.3290.185
22VIOLET0.3290.18794VIOLET0.3370.190
23PINK0.3300.19295PINK0.3290.186
24TURQUOISE0.3280.18596TURQUOISE0.3290.186
25ORANGE (FIRST LAYER)BLUE(BUNDLE 1)BLUE0.3300.185OK97SLATE (FIRST LAYER)BLUE(BUNDLE 1)BLUE0.3300.185OK
26ORANGE0.3310.18798ORANGE0.3300.187
27GREEN0.3310.18999GREEN0.3280.183
28BROWN0.3290.187100BROWN0.3310.185
29GREY0.3290.187101GREY0.3300.185
30WHITE0.3280.187102WHITE0.3270.182
31RED0.3300.182103RED0.3290.183
32BLACK0.3290.185104BLACK0.3270.184
33YELLOW0.3310.186105YELLOW0.3300.185
34VIOLET0.3290.183106VIOLET0.3300.187
35PINK0.3290.181107PINK0.3290.187
36TURQUOISE0.3300.185108TURQUOISE0.3290.186
37ORANGE(BUNDLE 2)BLUE0.3280.185OK109ORANGE(BUNDLE 2)BLUE0.3290.184OK
38ORANGE0.3310.186110ORANGE0.3310.184
39GREEN0.3280.184111GREEN0.3280.188
40BROWN0.3270.183112BROWN0.3200.183
41GREY0.3300.184113GREY0.3270.184
42WHITE0.3290.184114WHITE0.3290.186
43RED0.3290.187115RED0.3300.185
44BLACK0.3280.184116BLACK0.3330.189
45YELLOW0.3300.186117YELLOW0.3290.185
46VIOLET0.3290.185118VIOLET0.3270.186
47PINK0.3290.187119PINK0.3270.184
48TURQUOISE0.3280.183120TURQUOISE0.3290.185
49GREEN (FIRST LAYER)BLUE(BUNDLE 1)BLUE0.3320.184OK121WHITE (FIRST LAYER)BLUE(BUNDLE 1)BLUE0.3280.186OK
50ORANGE0.3320.187122ORANGE0.3310.186
51GREEN0.3300.186123GREEN0.3330.186
52BROWN0.3340.185124BROWN0.3280.186
53GREY0.3270.182125GREY0.3300.186
54WHITE0.3310.185126WHITE0.3290.186
55RED0.3290.185127RED0.3330.188
56BLACK0.3320.187128BLACK0.3280.184
57YELLOW0.3310.186129YELLOW0.3290.187
58VIOLET0.3290.184130VIOLET0.3310.186
59PINK0.3340.182131PINK0.3270.184
60TURQUOISE0.3280.183132TURQUOISE0.3290.182
61ORANGE(BUNDLE 2)BLUE0.3310.187OK133ORANGE(BUNDLE 2)BLUE0.3300.186OK
62ORANGE0.3280.188134ORANGE0.3300.186
63GREEN0.3290.186135GREEN0.3310.188
64BROWN0.3310.182136BROWN0.3270.184
65GREY0.3300.187137GREY0.3280.186
66WHITE0.3330.185138WHITE0.3300.188
67RED0.3300.185139RED0.3280.184
68BLACK0.3310.187140BLACK0.3280.186
69YELLOW0.3320.186141YELLOW0.3280.186
70VIOLET0.3320.186142VIOLET0.3280.185
71PINK0.3310.186143PINK0.3290.188
72TURQUOISE0.3390.189144TURQUOISE0.3290.186
145BLUE (SECOND LAYER)BLUE(BUNDLE 1)BLUE0.3320.186OK217BROWN (SECOND LAYER)BLUE(BUNDLE 1)BLUE0.3300.186OK
146ORANGE0.3300.185218ORANGE0.3290.186
147GREEN0.3290.189219GREEN0.3260.186
148BROWN0.3290.187220BROWN0.3320.187
149GREY0.3310.187221GREY0.3300.188
150WHITE0.3310.186222WHITE0.3300.186
151RED0.3290.186223RED0.3300.186
152BLACK0.3290.185224BLACK0.3320.186
153YELLOW0.3250.184225YELLOW0.3300.187
154VIOLET0.3290.185226VIOLET0.3290.186
155PINK0.3320.186227PINK0.3290.186
156TURQUOISE0.3280.184228TURQUOISE0.3320.187
157ORANGE(BUNDLE 2)BLUE0.3280.187OK229ORANGE(BUNDLE 2)BLUE0.3300.187OK
158ORANGE0.3280.184230ORANGE0.3290.183
159GREEN0.3290.186231GREEN0.3310.186
160BROWN0.3300.187232BROWN0.3300.187
161GREY0.3290.185233GREY0.3310.186
162WHITE0.3290.186234WHITE0.3280.188
163RED0.3280.185235RED0.3290.185
164BLACK0.3290.186236BLACK0.3310.186
165YELLOW0.3290.187237YELLOW0.3290.186
166VIOLET0.3290.186238VIOLET0.3290.188
167PINK0.3310.187239PINK0.3300.185
168TURQUOISE0.3280.185240TURQUOISE0.3290.185
169ORANGE (SECOND LAYER)BLUE(BUNDLE 1)BLUE0.3310.186ok241SLATE (SECOND LAYER)BLUE(BUNDLE 1)BLUE0.3300.186OK
170ORANGE0.3450.202242ORANGE0.3300.186
171GREEN0.3300.185243GREEN0.3300.186
172BROWN0.3310.189244BROWN0.3300.185
173GREY0.3300.186245GREY0.3350.190
174WHITE0.3290.186246WHITE0.3300.187
175RED0.3300.185247RED0.3300.185
176BLACK0.3310.187248BLACK0.3320.186
177YELLOW0.3310.188249YELLOW0.3290.184
178VIOLET0.3320.187250VIOLET0.3300.186
179PINK0.3310.185251PINK0.3290.186
180TURQUOISE0.3340.191252TURQUOISE0.3290.187
181ORANGE(BUNDLE 2)BLUE0.3300.188OK253ORANGE(BUNDLE 2)BLUE0.3290.186OK
182ORANGE0.3300.187254ORANGE0.3300.185
183GREEN0.3300.188255GREEN0.3300.187
184BROWN0.3300.186256BROWN0.3290.185
185GREY0.3300.186257GREY0.3310.187
186WHITE0.3320.190258WHITE0.3300.186
187RED0.3310.185259RED0.3300.187
188BLACK0.3320.188260BLACK0.3300.186
189YELLOW0.3310.186261YELLOW0.3290.185
190VIOLET0.3310.188262VIOLET0.3310.189
191PINK0.3320.188263PINK0.3290.185
192TURQUOISE0.3290.187264TURQUOISE0.3360.189
193GREEN (SECOND LAYER)BLUE(BUNDLE 1)BLUE0.3300.184OK265WHITE (SECOND LAYER)BLUE(BUNDLE 1)BLUE0.3310.187OK
194ORANGE0.3290.186266ORANGE0.3310.186
195GREEN0.3330.187267GREEN0.3310.190
196BROWN0.3290.184268BROWN0.3310.187
197GREY0.3300.186269GREY0.3320.187
198WHITE0.3320.187270WHITE0.3350.189
199RED0.3290.189271RED0.3330.188
200BLACK0.3300.185272BLACK0.3320.187
201YELLOW0.3290.185273YELLOW0.3330.184
202VIOLET0.3300.186274VIOLET0.3330.188
203PINK0.3300.187275PINK0.3350.188
204TURQUOISE0.3290.186276TURQUOISE0.3330.188
205ORANGE(BUNDLE 2)BLUE0.3290.187OK277ORANGE(BUNDLE 2)BLUE0.3330.187OK
206ORANGE0.3300.186278ORANGE0.3320.187
207GREEN0.3310.187279GREEN0.3360.186
208BROWN0.3300.187280BROWN0.3320.188
209GREY0.3280.186281GREY0.3310.187
210WHITE0.3290.186282WHITE0.3320.186
211RED0.3320.187283RED0.3320.186
212BLACK0.3280.184284BLACK0.3330.189
213YELLOW0.3260.183285YELLOW0.3310.185
214VIOLET0.3300.185286VIOLET0.3320.187
215PINK0.3310.185287PINK0.3310.184
216TURQUOISE0.3310.188288TURQUOISE0.3320.186
289RED (SECOND LAYER)BLUE(BUNDLE 1)BLUE0.3330.189OK361VIOLET (SECOND LAYER)BLUE(BUNDLE 1)BLUE0.3300.188OK
290ORANGE0.3310.187362ORANGE0.3320.185
291GREEN0.3330.187363GREEN0.3300.185
292BROWN0.3320.187364BROWN0.3300.187
293GREY0.3300.187365GREY0.3320.187
294WHITE0.3310.188366WHITE0.3320.188
295RED0.3320.186367RED0.3300.185
296BLACK0.3310.187368BLACK0.3310.186
297YELLOW0.3320.188369YELLOW0.3320.187
298VIOLET0.3310.187370VIOLET0.3320.189
299PINK0.3310.187371PINK0.3300.187
300TURQUOISE0.3310.188372TURQUOISE0.3310.187
301ORANGE(BUNDLE 2)BLUE0.3290.187OK373ORANGE(BUNDLE 2)BLUE0.3310.188OK
302ORANGE0.3320.189374ORANGE0.3320.187
303GREEN0.3330.188375GREEN0.3330.189
304BROWN0.3320.188376BROWN0.3310.187
305GREY0.3300.189377GREY0.3300.185
306WHITE0.3310.186378WHITE0.3310.187
307RED0.3310.186379RED0.3310.189
308BLACK0.3310.187380BLACK0.3290.187
309YELLOW0.3330.188381YELLOW0.3300.187
310VIOLET0.3330.188382VIOLET0.3300.185
311PINK0.3320.188383PINK0.3290.188
312TURQUOISE0.3310.187384TURQUOISE0.3310.187
313BLACK (SECOND LAYER)BLUE(BUNDLE 1)BLUE0.3300.185OK385PINK (SECOND LAYER)BLUE(BUNDLE 1)BLUE0.3310.188OK
314ORANGE0.3290.185386ORANGE0.3310.185
315GREEN0.3310.186387GREEN0.3310.187
316BROWN0.3320.187388BROWN0.3300.186
317GREY0.3320.184389GREY0.3310.185
318WHITE0.3310.186390WHITE0.3320.185
319RED0.3300.190391RED0.3300.184
320BLACK0.3310.189392BLACK0.3320.189
321YELLOW0.3300.185393YELLOW0.3300.188
322VIOLET0.3300.188394VIOLET0.3310.186
323PINK0.3310.183395PINK0.3310.188
324TURQUOISE0.3300.187396TURQUOISE0.3320.185
325ORANGE(BUNDLE 2)BLUE0.3290.186OK397ORANGE(BUNDLE 2)BLUE0.3290.185OK
326ORANGE0.3300.189398ORANGE0.3310.187
327GREEN0.3320.186399GREEN0.3320.189
328BROWN0.3330.189400BROWN0.3320.189
329GREY0.3310.187401GREY0.3300.187
330WHITE0.3300.186402WHITE0.3330.188
331RED0.3300.186403RED0.3320.187
332BLACK0.3310.186404BLACK0.3290.186
333YELLOW0.3330.190405YELLOW0.3310.187
334VIOLET0.3330.189406VIOLET0.3300.186
335PINK0.3320.186407PINK0.3330.187
336TURQUOISE0.3310.186408TURQUOISE0.3310.186
337YELLOW (SECOND LAYER)BLUE(BUNDLE 1)BLUE0.3300.185OK409AQUA (SECOND LAYER)BLUE(BUNDLE 1)BLUE0.3310.187OK
338ORANGE0.3310.188410ORANGE0.3300.184
339GREEN0.3310.186411GREEN0.3310.187
340BROWN0.3290.188412BROWN0.3310.184
341GREY0.3340.197413GREY0.3310.186
342WHITE0.3310.186414WHITE0.3300.188
343RED0.3300.187415RED0.3320.187
344BLACK0.3320.188416BLACK0.3310.187
345YELLOW0.3330.185417YELLOW0.3300.187
346VIOLET0.3320.185418VIOLET0.3280.184
347PINK0.3330.191419PINK0.3300.187
348TURQUOISE0.3320.188420TURQUOISE0.3320.186
349ORANGE(BUNDLE 2)BLUE0.3300.185OK421ORANGE(BUNDLE 2)BLUE0.3300.186OK
350ORANGE0.3310.185422ORANGE0.3330.187
351GREEN0.3300.186423GREEN0.3310.188
352BROWN0.3330.190424BROWN0.3310.189
353GREY0.3300.186425GREY0.3340.191
354WHITE0.3290.186426WHITE0.3310.186
355RED0.3320.187427RED0.3300.187
356BLACK0.3310.187428BLACK0.3320.186
357YELLOW0.3320.186429YELLOW0.3300.187
358VIOLET0.3310.185430VIOLET0.3290.184
359PINK0.3310.188431PINK0.3320.186
360TURQUOISE0.3310.189432TURQUOISE0.3290.186


regards/rohit

Former Member
Not what you were looking for? View more on this topic or Ask a question