Powerpivot beginner question

L

LVICARI

New Member
Joined
May 20, 2014
Messages
10
Hi all, I am trying to combine a bunch of tables from different excel workbooks into one powerpivot but I can't figure out how to do it. When I browse for a connection and then add the worksheet with the table on it, it imports the entire sheet (instead of just the table). So where I want my table, I end up with a header, date, and other info that is necessary to keep on the worksheet but not part of the actual table. Does anyone know how to import tables and not whole worksheets? Any help is MUCH appreciated!
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Sort by date Sort by votes
Try this, After selecting which sheets or tables you want press the "Preview & Filter" button to have greater control over the columns that it will bring in. Maybe messing with the "use first row as headers" check box too.
 
Upvote 0
Power Query should be able to do this as well. Would be easier if you can upload your workbook so we can have a look at it
 
Upvote 0
I've been trying to delete the top few rows in "preview and filter" but then it doesn't bring in the top table row as a header (even when I check "use first row as header"). It keeps wanting to bring in the whole sheet, not just the table. Here is what one of the worksheets looks like: [TABLE="width: 2069"]
<colgroup><col width="240" style="width: 180pt; mso-width-source: userset; mso-width-alt: 8777;"> <col width="186" style="width: 140pt; mso-width-source: userset; mso-width-alt: 6802;"> <col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3657;"> <col width="140" style="width: 105pt; mso-width-source: userset; mso-width-alt: 5120; mso-outline-level: 1;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742; mso-outline-level: 1;"> <col width="118" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4315; mso-outline-level: 1;"> <col width="143" style="width: 107pt; mso-width-source: userset; mso-width-alt: 5229; mso-outline-level: 1;"> <col width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt: 4717; mso-outline-level: 1;"> <col width="169" style="width: 127pt; mso-width-source: userset; mso-width-alt: 6180; mso-outline-level: 1;"> <col width="125" style="width: 94pt; mso-width-source: userset; mso-width-alt: 4571; mso-outline-level: 1;"> <col width="208" style="width: 156pt; mso-width-source: userset; mso-width-alt: 7606; mso-outline-level: 1;"> <col width="148" style="width: 111pt; mso-width-source: userset; mso-width-alt: 5412; mso-outline-level: 1;"> <col width="140" style="width: 105pt; mso-width-source: userset; mso-width-alt: 5120;"> <col width="164" style="width: 123pt; mso-width-source: userset; mso-width-alt: 5997;"> <col width="256" style="width: 192pt; mso-width-source: userset; mso-width-alt: 9362;"> <col width="17" style="width: 13pt; mso-width-source: userset; mso-width-alt: 621;"> <col width="135" style="width: 101pt; mso-width-source: userset; mso-width-alt: 4937; mso-outline-level: 1;"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218; mso-outline-level: 1;"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218; mso-outline-level: 1;"> <col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218; mso-outline-level: 1;"> <tbody>[TR]
[TD="class: xl64, width: 240, bgcolor: white"]Prepaid Marketing & Advertising[/TD]
[TD="class: xl64, width: 186, bgcolor: white"]4-50-1300[/TD]
[TD="class: xl65, width: 100, bgcolor: white"] [/TD]
[TD="class: xl64, width: 140, bgcolor: white"] [/TD]
[TD="class: xl64, width: 75, bgcolor: white"] [/TD]
[TD="class: xl64, width: 118, bgcolor: white"] [/TD]
[TD="class: xl64, width: 143, bgcolor: white"] [/TD]
[TD="class: xl64, width: 129, bgcolor: white"] [/TD]
[TD="class: xl64, width: 169, bgcolor: white"] [/TD]
[TD="class: xl64, width: 125, bgcolor: white"] [/TD]
[TD="class: xl64, width: 208, bgcolor: white"] [/TD]
[TD="class: xl64, width: 148, bgcolor: white"] [/TD]
[TD="class: xl66, width: 140, bgcolor: white"] [/TD]
[TD="class: xl66, width: 164, bgcolor: white"] [/TD]
[TD="class: xl67, width: 256, bgcolor: white"] [/TD]
[TD="class: xl66, width: 17, bgcolor: white"] [/TD]
[TD="class: xl66, width: 135, bgcolor: white"] [/TD]
[TD="class: xl68, width: 88, bgcolor: white"] [/TD]
[TD="class: xl68, width: 88, bgcolor: white"] [/TD]
[TD="class: xl68, width: 88, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: white"]Company, Inc.[/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl69, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl67, width: 256, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl70, bgcolor: #D9D9D9"]District[/TD]
[TD="class: xl71, bgcolor: #D9D9D9"] Schedule [/TD]
[TD="class: xl71, bgcolor: #D9D9D9"] Cognos [/TD]
[TD="class: xl72, bgcolor: #D9D9D9"] Variance [/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: white"]5/31/2014[/TD]
[TD="class: xl74, bgcolor: white"] [/TD]
[TD="class: xl65, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl67, width: 256, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"]Texas[/TD]
[TD="class: xl76, bgcolor: white"] 1,246 [/TD]
[TD="class: xl76, bgcolor: white"] - [/TD]
[TD="class: xl77, bgcolor: white"] 1,246 [/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: white"]Cognos as of [/TD]
[TD="class: xl78, bgcolor: white"]6/10/14[/TD]
[TD="class: xl79, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl67, width: 256, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"]Mid-Atlantic[/TD]
[TD="class: xl76, bgcolor: white"] 6,300 [/TD]
[TD="class: xl76, bgcolor: white"] (2,138)[/TD]
[TD="class: xl77, bgcolor: white"] 8,438 [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: white"]260 * MARKETING/ADVERTISING[/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl80, bgcolor: white"]260 * 4-50-2013 * 2013 BOAT SHOWS[/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl64, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl67, width: 256, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"]Oklahoma[/TD]
[TD="class: xl76, bgcolor: white"] 1,250 [/TD]
[TD="class: xl76, bgcolor: white"] (238)[/TD]
[TD="class: xl77, bgcolor: white"] 1,488 [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: white, colspan: 2"]less 260 * 4-50-2013 * 2013 TRADE SHOWS[/TD]
[TD="class: xl81, bgcolor: white"]260 * 4-50-2014 * 2014 BOAT SHOWS[/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl78, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl67, width: 256, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl75, bgcolor: white"]Mountain[/TD]
[TD="class: xl76, bgcolor: white"] - [/TD]
[TD="class: xl76, bgcolor: white"] - [/TD]
[TD="class: xl77, bgcolor: white"] - [/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: white, colspan: 6"]Note 1> The following schedule tracks all prepaid trade shows and marketing. The event will be expensed to the P&L in the month which it occurs.[/TD]
[TD="class: xl83, width: 143, bgcolor: white"] [/TD]
[TD="class: xl83, width: 129, bgcolor: white"] [/TD]
[TD="class: xl83, width: 169, bgcolor: white"] [/TD]
[TD="class: xl83, width: 125, bgcolor: white"] [/TD]
[TD="class: xl83, width: 208, bgcolor: white"] [/TD]
[TD="class: xl83, width: 148, bgcolor: white"] [/TD]
[TD="class: xl83, width: 140, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl67, width: 256, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl84, bgcolor: white"]California[/TD]
[TD="class: xl85, bgcolor: white"] - [/TD]
[TD="class: xl85, bgcolor: white"] (4,744)[/TD]
[TD="class: xl86, bgcolor: white"] 4,744 [/TD]
[/TR]
[TR]
[TD="class: xl83, width: 240, bgcolor: white"] [/TD]
[TD="class: xl83, width: 186, bgcolor: white"] [/TD]
[TD="class: xl87, width: 100, bgcolor: white"] [/TD]
[TD="class: xl83, width: 140, bgcolor: white"] [/TD]
[TD="class: xl83, width: 75, bgcolor: white"] [/TD]
[TD="class: xl83, width: 118, bgcolor: white"] [/TD]
[TD="class: xl83, width: 143, bgcolor: white"] [/TD]
[TD="class: xl83, width: 129, bgcolor: white"] [/TD]
[TD="class: xl83, width: 169, bgcolor: white"] [/TD]
[TD="class: xl83, width: 125, bgcolor: white"] [/TD]
[TD="class: xl83, width: 208, bgcolor: white"] [/TD]
[TD="class: xl83, width: 148, bgcolor: white"] [/TD]
[TD="class: xl83, width: 140, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl67, width: 256, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl88, width: 240, bgcolor: #D6DCE4"]Event Name[/TD]
[TD="class: xl88, width: 186, bgcolor: #D6DCE4"]Transaction Description[/TD]
[TD="class: xl88, width: 100, bgcolor: #D6DCE4"]District[/TD]
[TD="class: xl88, width: 140, bgcolor: #D6DCE4"]Store[/TD]
[TD="class: xl88, width: 75, bgcolor: #D6DCE4"]Payable[/TD]
[TD="class: xl88, width: 118, bgcolor: #D6DCE4"]Initial Amount[/TD]
[TD="class: xl88, width: 143, bgcolor: #D6DCE4"]Begin Amort Date[/TD]
[TD="class: xl88, width: 129, bgcolor: #D6DCE4"]End Amort Date[/TD]
[TD="class: xl88, width: 169, bgcolor: #D6DCE4"]# of Months to Amort[/TD]
[TD="class: xl88, width: 125, bgcolor: #D6DCE4"]Monthly Amort[/TD]
[TD="class: xl88, width: 208, bgcolor: #D6DCE4"]# of Months Already Amort[/TD]
[TD="class: xl88, width: 148, bgcolor: #D6DCE4"]Cumulative Amort[/TD]
[TD="class: xl89, width: 140, bgcolor: #D6DCE4"] Current Balance [/TD]
[TD="class: xl88, width: 164, bgcolor: #D6DCE4"]Expense GL Account[/TD]
[TD="class: xl91, width: 256, bgcolor: #D6DCE4"]Other Comments[/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, width: 240, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 186, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 100, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl94, width: 140, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl95, width: 75, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl96, width: 118, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl97, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl97, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl99, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl100, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl102, width: 164, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl102, width: 256, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl103, width: 240, bgcolor: transparent"] info [/TD]
[TD="class: xl103, width: 186, bgcolor: transparent"] info[/TD]
[TD="class: xl103, width: 100, bgcolor: transparent"]texas [/TD]
[TD="class: xl104, width: 140, bgcolor: transparent"]dallas [/TD]
[TD="class: xl105, width: 75, bgcolor: transparent"]12345[/TD]
[TD="class: xl106, width: 118, bgcolor: transparent"]$$$$[/TD]
[TD="class: xl107, bgcolor: transparent"]3/3/13[/TD]
[TD="class: xl107, bgcolor: transparent"]3/3/15[/TD]
[TD="class: xl98, bgcolor: #D0CECE"] 24[/TD]
[TD="class: xl99, bgcolor: #D0CECE"]$$$ [/TD]
[TD="class: xl98, bgcolor: #D0CECE"]11 [/TD]
[TD="class: xl100, bgcolor: #D0CECE"] $$$$[/TD]
[TD="class: xl98, bgcolor: #D0CECE"]$$$$ [/TD]
[TD="class: xl109, width: 164, bgcolor: transparent"]DAL*2-22-2222[/TD]
[TD="class: xl109, width: 256, bgcolor: transparent"]info[/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, width: 240, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 186, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 100, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl110, width: 140, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl111, width: 75, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl112, width: 118, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl99, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl100, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl114, width: 164, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl114, width: 256, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl103, width: 240, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 186, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 100, bgcolor: transparent"] [/TD]
[TD="class: xl104, width: 140, bgcolor: transparent"] [/TD]
[TD="class: xl105, width: 75, bgcolor: transparent"][/TD]
[TD="class: xl106, width: 118, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl99, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl100, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl109, width: 164, bgcolor: transparent"][/TD]
[TD="class: xl109, width: 256, bgcolor: transparent"][/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, width: 240, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 186, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 100, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl110, width: 140, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl111, width: 75, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl112, width: 118, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl99, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl100, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl114, width: 164, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl114, width: 256, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl103, width: 240, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 186, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 100, bgcolor: transparent"] [/TD]
[TD="class: xl104, width: 140, bgcolor: transparent"] [/TD]
[TD="class: xl105, width: 75, bgcolor: transparent"][/TD]
[TD="class: xl106, width: 118, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl99, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl100, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl109, width: 164, bgcolor: transparent"][/TD]
[TD="class: xl109, width: 256, bgcolor: transparent"][/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, width: 240, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 186, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 100, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl110, width: 140, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl111, width: 75, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl112, width: 118, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl100, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl114, width: 164, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl114, width: 256, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl103, width: 240, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 186, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 100, bgcolor: transparent"] [/TD]
[TD="class: xl104, width: 140, bgcolor: transparent"] [/TD]
[TD="class: xl105, width: 75, bgcolor: transparent"][/TD]
[TD="class: xl106, width: 118, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl99, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl100, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl109, width: 164, bgcolor: transparent"][/TD]
[TD="class: xl109, width: 256, bgcolor: transparent"][/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, width: 240, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 186, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 100, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl110, width: 140, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl111, width: 75, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl112, width: 118, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl99, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl100, bgcolor: #D0CECE"] [/TD]
[TD="class: xl98, bgcolor: #D0CECE"] [/TD]
[TD="class: xl114, width: 164, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl114, width: 256, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl103, width: 240, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 186, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 100, bgcolor: transparent"] [/TD]
[TD="class: xl104, width: 140, bgcolor: transparent"] [/TD]
[TD="class: xl105, width: 75, bgcolor: transparent"][/TD]
[TD="class: xl106, width: 118, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl109, width: 164, bgcolor: transparent"][/TD]
[TD="class: xl109, width: 256, bgcolor: transparent"][/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, width: 240, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 186, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 100, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl110, width: 140, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl111, width: 75, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl112, width: 118, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl114, width: 164, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl114, width: 256, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl103, width: 240, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 186, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 100, bgcolor: transparent"] [/TD]
[TD="class: xl104, width: 140, bgcolor: transparent"] [/TD]
[TD="class: xl105, width: 75, bgcolor: transparent"][/TD]
[TD="class: xl106, width: 118, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl109, width: 164, bgcolor: transparent"][/TD]
[TD="class: xl109, width: 256, bgcolor: transparent"][/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, width: 240, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 186, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 100, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl110, width: 140, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl111, width: 75, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl112, width: 118, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl114, width: 164, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl114, width: 256, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl103, width: 240, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 186, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 100, bgcolor: transparent"] [/TD]
[TD="class: xl104, width: 140, bgcolor: transparent"] [/TD]
[TD="class: xl105, width: 75, bgcolor: transparent"][/TD]
[TD="class: xl106, width: 118, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl109, width: 164, bgcolor: transparent"][/TD]
[TD="class: xl109, width: 256, bgcolor: transparent"][/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, width: 240, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 186, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 100, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl110, width: 140, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl111, width: 75, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl112, width: 118, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl114, width: 164, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl114, width: 256, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl103, width: 240, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 186, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 100, bgcolor: transparent"] [/TD]
[TD="class: xl104, width: 140, bgcolor: transparent"] [/TD]
[TD="class: xl105, width: 75, bgcolor: transparent"][/TD]
[TD="class: xl106, width: 118, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl109, width: 164, bgcolor: transparent"][/TD]
[TD="class: xl109, width: 256, bgcolor: transparent"][/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, width: 240, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 186, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 100, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl110, width: 140, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl111, width: 75, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl112, width: 118, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl114, width: 164, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl114, width: 256, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl103, width: 240, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 186, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 100, bgcolor: transparent"] [/TD]
[TD="class: xl104, width: 140, bgcolor: transparent"] [/TD]
[TD="class: xl105, width: 75, bgcolor: transparent"][/TD]
[TD="class: xl106, width: 118, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl109, width: 164, bgcolor: transparent"][/TD]
[TD="class: xl109, width: 256, bgcolor: transparent"][/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, width: 240, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 186, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 100, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl110, width: 140, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl111, width: 75, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl112, width: 118, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl114, width: 164, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl114, width: 256, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl103, width: 240, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 186, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 100, bgcolor: transparent"] [/TD]
[TD="class: xl104, width: 140, bgcolor: transparent"] [/TD]
[TD="class: xl105, width: 75, bgcolor: transparent"][/TD]
[TD="class: xl106, width: 118, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl109, width: 164, bgcolor: transparent"][/TD]
[TD="class: xl109, width: 256, bgcolor: transparent"][/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, width: 240, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 186, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 100, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl110, width: 140, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl111, width: 75, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl112, width: 118, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl114, width: 164, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl114, width: 256, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl103, width: 240, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 186, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 100, bgcolor: transparent"] [/TD]
[TD="class: xl104, width: 140, bgcolor: transparent"] [/TD]
[TD="class: xl105, width: 75, bgcolor: transparent"][/TD]
[TD="class: xl106, width: 118, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl109, width: 164, bgcolor: transparent"][/TD]
[TD="class: xl109, width: 256, bgcolor: transparent"][/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl93, width: 240, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 186, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl93, width: 100, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl110, width: 140, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl111, width: 75, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl112, width: 118, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl113, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl114, width: 164, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl114, width: 256, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl103, width: 240, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 186, bgcolor: transparent"] [/TD]
[TD="class: xl103, width: 100, bgcolor: transparent"] [/TD]
[TD="class: xl104, width: 140, bgcolor: transparent"] [/TD]
[TD="class: xl105, width: 75, bgcolor: transparent"][/TD]
[TD="class: xl106, width: 118, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl116, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl118, bgcolor: #D0CECE"] [/TD]
[TD="class: xl115, bgcolor: #D0CECE"] [/TD]
[TD="class: xl109, width: 164, bgcolor: transparent"][/TD]
[TD="class: xl109, width: 256, bgcolor: transparent"][/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl119, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl119, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl120, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl121, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl121, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl121, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl121, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl121, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl121, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl121, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl121, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl121, bgcolor: #D9D9D9"]Total Schedule[/TD]
[TD="class: xl122, bgcolor: #D9D9D9"] 8,796 [/TD]
[TD="class: xl117, bgcolor: white"] [/TD]
[TD="class: xl114, width: 256, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl123, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl123, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl124, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl125, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl125, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl125, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl125, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl125, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl125, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl125, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl125, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl125, bgcolor: #D9D9D9"]Variance[/TD]
[TD="class: xl126, bgcolor: #D9D9D9"] 15,916 [/TD]
[TD="class: xl127, bgcolor: white"] [/TD]
[TD="class: xl128, width: 256, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: white"] Thank you[/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl69, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl67, width: 256, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl92, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[TD="class: xl66, bgcolor: white"] [/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
I'm with XLBob on this one, Power Query will help out a lot.

9EaTVov.png
 
Upvote 0
If you don't go with PowerQuery, you could insert a row before row 1 and replicate the column headers of your data table. This will trick Powerpivot into using those column headers (when the "use first row checkbox" is checked) and you can still manually filter the lines you don't want included using Table Properties.
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question Question
Visible data in Power Query, not refreshing to Excel table
Replies
1
Views
783
GraH
GraH
R
  • Question Question
Quicken QIF files to Power Query
2
Replies
14
Views
1K
smozgur
smozgur
M
  • Solved
Really basic power query for excel 365 questions regarding import/pivot table/data model
Replies
4
Views
1K
Mr_Phil
M
L
  • Solved
apply column headers to another table in Power Query
Replies
4
Views
5K
jdellasala
J
M
  • Question Question
Power Query Appending new CSV files to an EXISTING Excel table
2
Replies
12
Views
7K
DoomBlasZt
D

Forum statistics

Threads
1,224,002
Messages
6,175,899
Members
452,681
Latest member
jlcm0924

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