P6 export into Excel, needs duplicate activities removed and resources copied to new columns

W

wjmay1961

New Member
Joined
Apr 18, 2013
Messages
16
Anyone that has used Primavera and exported the activities and resources into excel has witnessed the issue on how P6 exports the data. If an activity has multiple resources, the export will have the same number of activities (duplicate lines to match the number of resource assignments. I'm looking for some help in removing the duplicate lines and copying the resources and associated date to the next available column. I have included a pic to help demonstrate my need.

 
Sort by date Sort by votes
Hello!
In the DATA ribbon You have a bottom REMOVE DUPLICATES
 
Upvote 0
I have attached my HTML format to help clarify my earlier post

<!-- Please do not remove this header -->

<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" frame="border">
<tr>
<th bgcolor="#B7DEE8" width="42" height="57" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">WBS</font></th>
<th bgcolor="#B7DEE8" width="326" height="57" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Activity Name</font></th>
<th bgcolor="#B7DEE8" width="143" height="57" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Resource Name</font></th>
<th bgcolor="#B7DEE8" width="66" height="57" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Crew Size</font></th>
<th bgcolor="#B7DEE8" width="74" height="57" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Original Dur (Hrs)</font></th>
<th bgcolor="#B7DEE8" width="88" height="57" align="center" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Budgeted Units (ManHrs)</font></th>
<th bgcolor="#B7DEE8" width="92" height="57" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Resource Name1</font></th>
<th bgcolor="#B7DEE8" width="63" height="57" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Resource1 Crew Size</font></th>
<th bgcolor="#B7DEE8" width="61" height="57" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Resource1 Duration</font></th>
<th bgcolor="#B7DEE8" width="63" height="57" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Resource1 Budgeted (ManHrs)</font></th>
<th bgcolor="#B7DEE8" width="56" height="57" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Resource Name2</font></th>
<th bgcolor="#B7DEE8" width="63" height="57" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Resource2 Crew Size</font></th>
<th bgcolor="#B7DEE8" width="63" height="57" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Resource2 Duration</font></th>
<th bgcolor="#B7DEE8" width="63" height="57" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Resource2 Budgeted (ManHrs)</font></th>
<th bgcolor="#B7DEE8" width="110" height="57" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Resource Name3</font></th>
</tr>
<tr>
<td bgcolor="#A6A6A6" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">6</font></td>
<td bgcolor="#A6A6A6" width="326" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"><b>(EX) RPV-3951 Stabilizer O/H Condenser</b></font></td>
<td bgcolor="#A6A6A6" width="143" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">6.1</font></td>
<td bgcolor="#FFFFFF" width="326" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Transport Bundle From Slab To Unit & Install Bundle</font></td>
<td bgcolor="#FFFFFF" width="143" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Boilermaker Mechanics</font></td>
<td bgcolor="#FFFFFF" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">2.0</font></td>
<td bgcolor="#FFFFFF" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">4.0</font></td>
<td bgcolor="#FFFFFF" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">8.0</font></td>
<td bgcolor="#FFFFFF" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">6.2</font></td>
<td bgcolor="#FFFFFF" width="326" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Transport Bundle From Slab To Unit & Install Bundle</font></td>
<td bgcolor="#FFFFFF" width="143" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Crane Operator</font></td>
<td bgcolor="#FFFFFF" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">6.3</font></td>
<td bgcolor="#FFFFFF" width="326" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Transport Bundle From Slab To Unit & Install Bundle</font></td>
<td bgcolor="#FFFFFF" width="143" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Rigger</font></td>
<td bgcolor="#FFFFFF" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">6.4</font></td>
<td bgcolor="#FFFFFF" width="326" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Transport Bundle From Slab To Unit & Install Bundle</font></td>
<td bgcolor="#FFFFFF" width="143" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Pipefitter</font></td>
<td bgcolor="#FFFFFF" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">3.0</font></td>
<td bgcolor="#FFFFFF" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">3.0</font></td>
<td bgcolor="#FFFFFF" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="326" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="143" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="326" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="143" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#A6A6A6" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">6</font></td>
<td bgcolor="#A6A6A6" width="326" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"><b>(EX) RPV-3951 Stabilizer O/H Condenser</b></font></td>
<td bgcolor="#A6A6A6" width="143" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">6.1</font></td>
<td bgcolor="#FFFFFF" width="326" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Transport Bundle From Slab To Unit & Install Bundle</font></td>
<td bgcolor="#FFFFFF" width="143" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Boilermaker Mechanics</font></td>
<td bgcolor="#FFFFFF" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">2.0</font></td>
<td bgcolor="#FFFFFF" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">4.0</font></td>
<td bgcolor="#FFFFFF" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">8.0</font></td>
<td bgcolor="#FFFFFF" width="92" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Crane Operator</font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="56" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Rigger</font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="110" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">TSO Pipefitter SLAB</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">6.2</font></td>
<td bgcolor="#FFFFFF" width="326" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Transport Bundle From Slab To Unit & Install Bundle</font></td>
<td bgcolor="#FFFFFF" width="143" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Crane Operator</font></td>
<td bgcolor="#FFFFFF" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">6.3</font></td>
<td bgcolor="#FFFFFF" width="326" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Transport Bundle From Slab To Unit & Install Bundle</font></td>
<td bgcolor="#FFFFFF" width="143" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Rigger</font></td>
<td bgcolor="#FFFFFF" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">6.4</font></td>
<td bgcolor="#FFFFFF" width="326" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Transport Bundle From Slab To Unit & Install Bundle</font></td>
<td bgcolor="#FFFFFF" width="143" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Pipefitter</font></td>
<td bgcolor="#FFFFFF" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">3.0</font></td>
<td bgcolor="#FFFFFF" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">3.0</font></td>
<td bgcolor="#FFFFFF" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="326" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="143" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="326" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="143" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#A6A6A6" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">6</font></td>
<td bgcolor="#A6A6A6" width="326" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"><b>(EX) RPV-3951 Stabilizer O/H Condenser</b></font></td>
<td bgcolor="#A6A6A6" width="143" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="92" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="56" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
<td bgcolor="#A6A6A6" width="110" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000"></font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="42" height="19" align="left" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">6.1</font></td>
<td bgcolor="#FFFFFF" width="326" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Transport Bundle From Slab To Unit & Install Bundle</font></td>
<td bgcolor="#FFFFFF" width="143" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Boilermaker Mechanics</font></td>
<td bgcolor="#FFFFFF" width="66" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">2.0</font></td>
<td bgcolor="#FFFFFF" width="74" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">4.0</font></td>
<td bgcolor="#FFFFFF" width="88" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">8.0</font></td>
<td bgcolor="#FFFFFF" width="92" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Crane Operator</font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="61" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="56" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">Rigger</font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="63" height="19" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">1.0</font></td>
<td bgcolor="#FFFFFF" width="110" height="19" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size=“1” color="#000000">TSO Pipefitter SLAB</font></td>
</tr>
</table>

</body>
</html>
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
VBA Help - Duplicate & Unwanted Data Removal
Replies
6
Views
1K
MoonDancer
M
C
  • Question Question
Delete Cell Range, or Add Range and Copy Formulas etc. - Excel VBA
Replies
0
Views
533
CSTjr
C
A
  • Question Question
Excel data from one sheet, copy cells from row i'm working on to excel 'form' based on cell value
Replies
2
Views
601
asiuol84
A
J
  • Solved
Registration tracking sheet
Replies
2
Views
645
JPL
J
L
  • Question Question
VBA to Find Duplicate Row & Clear Contents of Cell in Column
Replies
3
Views
895
OaklandJim
O

Forum statistics

Threads
1,226,875
Messages
6,193,455
Members
453,801
Latest member
777nycole

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top