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.

 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
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

C
  • Question
Delete Cell Range, or Add Range and Copy Formulas etc. - Excel VBA
Replies
0
Views
96
CSTjr
C
J
  • Solved
Registration tracking sheet
Replies
2
Views
426
JPL
J
L
  • Question
VBA to Find Duplicate Row & Clear Contents of Cell in Column
Replies
3
Views
683
OaklandJim
O
A
  • Question
Associate a salary increase to an employee and use to calculate monthly project staffing costs
Replies
1
Views
552
automation monkey
A
L
  • Question
Exported PDF to Excel need to copy data by row VBA
Replies
3
Views
337
LNG2013
L

Forum statistics

Threads
1,215,486
Messages
6,125,070
Members
449,205
Latest member
Healthydogs

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