Transpose data with multiple criteria

[ralsnz]

Hi all

I am facing a challenge:

I have few rooms with multiples equipment inside. For each equipment I need to answer 9 questions, there is only 3 option: red, orange or green.

The list with all the equipment by room are built as bellow:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Room 1[/TD]
[TD]Room 2[/TD]
[TD]Room 3[/TD]
[/TR]
[TR]
[TD]Equipment X[/TD]
[TD]Equipment Y[/TD]
[TD]Equipment Z[/TD]
[/TR]
[TR]
[TD]Equipment XZ[/TD]
[TD]Eq YX[/TD]
[TD]Eq ZX[/TD]
[/TR]
[TR]
[TD]Eq ZY[/TD]
[TD]Eq XZY[/TD]
[TD]Eq ZXY[/TD]
[/TR]
</tbody>[/TABLE]

In a different sheet I have this table with the answers:

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Equipment[/TD]
[TD="align: center"]Question 1[/TD]
[TD="align: center"]Q2[/TD]
[TD="align: center"]Q3[/TD]
[TD="align: center"]Q4[/TD]
[TD="align: center"]Q5[/TD]
[TD="align: center"]Q6[/TD]
[TD="align: center"]Q7[/TD]
[TD="align: center"]Q8[/TD]
[TD="align: center"]Q9[/TD]
[/TR]
[TR]
[TD="align: center"]X[/TD]
[TD="align: center"]Red[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]Orange[/TD]
[TD="align: center"]Green[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[/TR]
[TR]
[TD="align: center"]Y[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[/TR]
[TR]
[TD="align: center"]Z[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[/TR]
[TR]
[TD="align: center"]XZ[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]G[/TD]
[/TR]
[TR]
[TD="align: center"]YX[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]O[/TD]
[/TR]
[TR]
[TD="align: center"]ZX[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[/TR]
[TR]
[TD="align: center"]ZY[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]R[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[/TR]
[TR]
[TD="align: center"]XZY[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[/TR]
[TR]
[TD="align: center"]ZXY[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]O[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[/TR]
</tbody>[/TABLE]


To be able to built a pivot table, I need to present the data like:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Room[/TD]
[TD]Equipment[/TD]
[TD]Answers in Red[/TD]
[TD]Answers in Orange[/TD]
[/TR]
[TR]
[TD]Room1[/TD]
[TD]X[/TD]
[TD]R[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Room1[/TD]
[TD]X[/TD]
[TD]R[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Room1[/TD]
[TD]X[/TD]
[TD][/TD]
[TD]O[/TD]
[/TR]
[TR]
[TD]Room1[/TD]
[TD]XZ[/TD]
[TD]R[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Room1[/TD]
[TD]ZY[/TD]
[TD]R[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Room1[/TD]
[TD]ZY[/TD]
[TD]R[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Room2[/TD]
[TD]Y[/TD]
[TD]R[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Room2[/TD]
[TD]Y[/TD]
[TD]R[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Room2[/TD]
[TD]Y[/TD]
[TD]R[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Room2[/TD]
[TD]Y[/TD]
[TD]R[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Room2[/TD]
[TD]Y[/TD]
[TD][/TD]
[TD]O[/TD]
[/TR]
[TR]
[TD]Room2[/TD]
[TD]Y[/TD]
[TD][/TD]
[TD]O[/TD]
[/TR]
</tbody>[/TABLE]

And so on. The only problem that my database is big as ****. So I need to generate a VBA for it.

Someone could give me a light on this?


Cheers.







****** id="cke_pastebin" style="position: absolute; top: 606.4px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]O[/TD]
[/TR]
</tbody>[/TABLE]

 

[mse330]

Welcome to Mr. Excel ralsnz !

Can you show us the a sample of the expected results after running the macro ? Are you trying to end up with the 3rd table you posted ? If so, equipment x is only repeated 3 times whereas it should be shown 9 times for each answer, or I am misunderstanding your request ? Could you please elaborate a little more

 

[ralsnz]

Hello mse330,

Sorry for the lack of information. Yes, I'm trying to end up with table 3, although I just want to show the equipment with red and orange answers.
The main problem is base in two major tables, as bellow (tab 1 and tab 2). Table 3 is expected one, but I need to fill the room column.

Table 1:

[TABLE="width: 1017"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]rooms[/TD]
[TD]room 1[/TD]
[TD]room 2[/TD]
[TD]room 3[/TD]
[TD]room 4[/TD]
[TD]room 5[/TD]
[TD]room 6[/TD]
[TD]room 7[/TD]
[TD]room 8[/TD]
[TD]room 9[/TD]
[TD]room 10[/TD]
[TD]room 11[/TD]
[TD]room 12[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]DIS-02[/TD]
[TD]MIX-02[/TD]
[TD]DRY-03[/TD]
[TD]MIB-02[/TD]
[TD]GRN-10[/TD]
[TD]SCL-114[/TD]
[TD]SCL-69[/TD]
[TD]SCL-103[/TD]
[TD]SCL-69[/TD]
[TD]TCP-02[/TD]
[TD]TCP-05[/TD]
[TD]TCP-11[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]SCL-100[/TD]
[TD]MIX-05[/TD]
[TD]DRY-05[/TD]
[TD] [/TD]
[TD]SIV-02[/TD]
[TD]SCL-19[/TD]
[TD]MIL-03[/TD]
[TD]SCL-105[/TD]
[TD]MIS-25[/TD]
[TD]TDD-10[/TD]
[TD]TDD-12[/TD]
[TD]TDD-17[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]SCL-83[/TD]
[TD]SCL-91[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SIV-01[/TD]
[TD]CPS-02[/TD]
[TD]INV-01[/TD]
[TD]SCL-106[/TD]
[TD]MIS-18[/TD]
[TD]TMC-07[/TD]
[TD]TMC-16[/TD]
[TD]TMC-17[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]SCL-17[/TD]
[TD]SCL-98[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MIL-07[/TD]
[TD]CPS-03[/TD]
[TD]SIV-08[/TD]
[TD]HRD-11[/TD]
[TD]TCT-01[/TD]
[TD]TCP-13[/TD]
[TD]HRD-14[/TD]
[TD]HRD-13[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MIS-20[/TD]
[TD]CSM-02[/TD]
[TD]GRN-01[/TD]
[TD]DIS-06[/TD]
[TD] [/TD]
[TD]TDD-11[/TD]
[TD]DIS-09[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]DRY-07[/TD]
[TD]TMC-09[/TD]
[TD]DRY-01[/TD]
[TD]FRI-07[/TD]
[TD] [/TD]
[TD]HRD-12[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]DRY-13[/TD]
[TD]MIS-34[/TD]
[TD]SCL-93[/TD]
[TD]SCL-90[/TD]
[TD] [/TD]
[TD]VAC-16[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SCL-90[/TD]
[TD]PMP-02[/TD]
[TD] [/TD]
[TD]FRI-04[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SCL-99[/TD]
[TD]SCL-67[/TD]
[TD] [/TD]
[TD]DIS-05[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SCL-89[/TD]
[TD]ENC-06[/TD]
[TD] [/TD]
[TD]SCL-102[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]PMP-25[/TD]
[TD]CEL-01[/TD]
[TD] [/TD]
[TD]SCL-11[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CLM-01[/TD]
[TD] [/TD]
[TD]SCL-88[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CSM-01[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

Table 2:

[TABLE="width: 904"]
<colgroup><col><col><col span="2"><col><col span="3"><col><col></colgroup><tbody>[TR]
[TD]Equipment[/TD]
[TD]question 2[/TD]
[TD]question 3[/TD]
[TD]question 4[/TD]
[TD]question 5[/TD]
[TD]question 6[/TD]
[TD]question 7[/TD]
[TD]question 8[/TD]
[TD]question 9[/TD]
[TD]question 10[/TD]
[/TR]
[TR]
[TD]SCL-17[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-83[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-100[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]MIS-18[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]MIS-20[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]MIS-34[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]GRN-10[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]GRN-01[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]MIL-07[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]MIL-03[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]SIV-01[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]SIV-02[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]SIV-08[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]MIX-02[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]MIX-05[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]DRY-03[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]DRY-05[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]DRY-07[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]DRY-13[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]DRY-01[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]MIB-02[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]SCL-99[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-102[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-103[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-114[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-69[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-93[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-98[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-88[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-91[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-106[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-11[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-89[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]TCP-13[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]TCP-11[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]TCP-05[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]TCP-02[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]TMC-07[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]TMC-16[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]TMC-17[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]TDD-17[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]TDD-10[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]TDD-12[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]VAC-16[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]ENC-06[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]TMC-09[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]CLM-01[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]CSM-01[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]CSM-02[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]CEL-01[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]CPS-02[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]CPS-03[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]SCL-19[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-90[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]MIS-20[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]MIS-18[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]TCT-01[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]INV-01[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]DIS-02[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]PMP-02[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]PMP-25[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]FRI-07[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]FRI-04[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]HRD-12[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]TDD-11[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]DIS-09[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]DIS-05[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]HRD-13[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]HRD-11[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]HRD-14[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]SCL-67[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]SCL-105[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]DIS-06[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]MIS-25[/TD]
[TD]green[/TD]
[TD]green[/TD]
[TD]orange[/TD]
[TD]red[/TD]
[TD]green[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]red[/TD]
[TD]green[/TD]
[/TR]
</tbody>[/TABLE]


Table 3: Table expected as result

[TABLE="width: 824"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Equipment number[/TD]
[TD]Equipment name list[/TD]
[TD]Questions[/TD]
[TD]Answers[/TD]
[TD]Room[/TD]
[/TR]
[TR]
[TD]SCL-17[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-83[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-100[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MIS-18[/TD]
[TD]Overhead Stirrer[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MIS-20[/TD]
[TD]Overhead Stirrer[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MIS-34[/TD]
[TD]Overhead Stirrer[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GRN-10[/TD]
[TD]Bear Mixer[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GRN-01[/TD]
[TD]VG 400 Granulator[/TD]
[TD]question 1[/TD]
[TD]red[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MIL-07[/TD]
[TD]Fitzmill[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MIL-03[/TD]
[TD]Comil[/TD]
[TD]question 1[/TD]
[TD]red[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SIV-01[/TD]
[TD]Russel Sieve[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SIV-02[/TD]
[TD]Russel Sieve[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SIV-08[/TD]
[TD]Russel Sieve[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MIX-02[/TD]
[TD]Eccentric Drum Roller[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MIX-05[/TD]
[TD]Eccentric Drum Roller[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DRY-03[/TD]
[TD]Dry Oven[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DRY-05[/TD]
[TD]Dry Oven[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DRY-07[/TD]
[TD]Dry Oven[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DRY-13[/TD]
[TD]Dry Oven[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DRY-01[/TD]
[TD]Fluid bed dryer[/TD]
[TD]question 1[/TD]
[TD]red[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MIB-02[/TD]
[TD]Double cone blender[/TD]
[TD]question 1[/TD]
[TD]red[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-99[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-102[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-103[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-114[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-69[/TD]
[TD]Moisture Analyser[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-93[/TD]
[TD]Moisture Analyser[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-98[/TD]
[TD]Moisture Analyser[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-88[/TD]
[TD]Moisture Analyser[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-91[/TD]
[TD]Moisture Analyser[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-106[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-11[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-89[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TCP-13[/TD]
[TD]Compression Machine[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TCP-11[/TD]
[TD]Compression Machine[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TCP-05[/TD]
[TD]Compression Machine[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TCP-02[/TD]
[TD]Compression Machine[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TMC-07[/TD]
[TD]Metal detector[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TMC-16[/TD]
[TD]Metal detector[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TMC-17[/TD]
[TD]Metal detector[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TDD-17[/TD]
[TD]De-duster[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TDD-10[/TD]
[TD]De-duster[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TDD-12[/TD]
[TD]De-duster[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]VAC-16[/TD]
[TD]Portable vaccum cleaner[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ENC-06[/TD]
[TD]Encapsulation[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TMC-09[/TD]
[TD]Metal detector[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CLM-01[/TD]
[TD]Capsule loader[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CSM-01[/TD]
[TD]Capsule sorter[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CSM-02[/TD]
[TD]Capsule sorter[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CEL-01[/TD]
[TD]Capsule elevator[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CPS-02[/TD]
[TD]Capsule polisher[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CPS-03[/TD]
[TD]Capsule polisher[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-19[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-90[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MIS-20[/TD]
[TD]Overhead Stirrer[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MIS-18[/TD]
[TD]Overhead Stirrer[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TCT-01[/TD]
[TD]Accela cota[/TD]
[TD]question 1[/TD]
[TD]red[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]INV-01[/TD]
[TD]LD 60 Bowl Inverter [/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DIS-02[/TD]
[TD]Dispensary[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PMP-02[/TD]
[TD]Pump[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PMP-25[/TD]
[TD]Pump[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FRI-07[/TD]
[TD]Friability Tester[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FRI-04[/TD]
[TD]Friability Tester[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HRD-12[/TD]
[TD]Hardness tester [/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TDD-11[/TD]
[TD]De-duster[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DIS-09[/TD]
[TD]Disintegration bath[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DIS-05[/TD]
[TD]Disintegration bath[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HRD-13[/TD]
[TD]Hardness tester [/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HRD-11[/TD]
[TD]Hardness tester [/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HRD-14[/TD]
[TD]Hardness tester [/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-67[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-105[/TD]
[TD]Balance[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DIS-06[/TD]
[TD]Disintegration bath[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MIS-25[/TD]
[TD]Overhead Stirrer[/TD]
[TD]question 1[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-17[/TD]
[TD]Balance[/TD]
[TD]question 2[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-83[/TD]
[TD]Balance[/TD]
[TD]question 2[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SCL-100[/TD]
[TD]Balance[/TD]
[TD]question 2[/TD]
[TD]green[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]




Many thanks

 

[mse330]

Hey ralsnz,

I have more questions after seeing your bigger sample

• I have noticed that "Equipment number" is NOT a unique identifier. For example, Equipment number "SCL-90" is repeated both in room 5 & room 8 - Is this an error in the sample data or it could actually happen ? If it does happen, should I repeated it twice in both rooms 5 & 8 ?

• Equipment # "MIS-18" repeated twice in the 2nd table - In the sample it has the same question answers but what if it has different answers? Which one should I consider ?