Pivot table help

K

katiepie

New Member
Joined
Sep 8, 2010
Messages
7
Hello,
I have a pivot table that I am struggling with. The back story is that I use Microsoft Dynamics GP and Excel Report Builder. The excel report is a refresh able report. This report is used to capture our EFT and Check information so we can submit it to our bank (so they can send out our payments). We had to go by a certain criteria from our bank and I have the file formatted almost the way we want it, but we still have to do some manual manipulation. I am hoping if I show an example here someone can tell me if it is possible within my pivot table to fix the issue.

The attachment is the pivot table hard coded. There are many columns that we need but the ones highlighted in yellow are what I am having trouble with. The TRANNO is our payment number. If there is only one invoice associated with that payment number it works fine. The issue is when there are two invoices associated with the payment number (the yellow rows). To be able to submit it to the bank columns E:AP need to be blank and the total of the payment needs to be on the first highlighted yellow cell (Column E).
For example row 3 and 4. This is one payment but with two invoices. The total payment is $199.03 which is made up of cell E3 and E4. So cell E3 should say 199.03 and row 4 should be blank until you get to AQ. So I am not sure if I just change my pivot table settings if this is doable. Rows 10/11 and 20/21 are the same issue. Now row 15/16 works somewhat fine because the invoice amount is the same. So cell E15 should actually say 400 but row 16 is blank like it should be.

I am sure I just confused everyone and didnt explain it very well but if anyone has any ideas I would appreciate it. Right now we are just manually fixing it. I am not sure if it will be readable by posting below but if anyone would like to see the actual excel file let me know and I can send it to you.

Thank you,
Katie

Credit00027476 3/16/2018 USDDXXXXXABAXXXXX(blank) XXXXXDansr, Inc(blank)XXXXX(blank)(blank)ChampaignIL61824USUnited States(blank)(blank)(blank)XXXXXXXXXXXXXXXXXXXXIL60197-6111USUnited StatesUS30024 XXXXX3/8/2018(blank)(blank)IV
00027478 3/16/2018 USDDXXXXXABAXXXXX(blank) XXXXXDansr, Inc(blank)XXXXX(blank)(blank)ChampaignIL61824USUnited States(blank)(blank)(blank)XXXXXXXXXXXXXXXPO Box 10306XXXXXIL60055-0306USUnited StatesUS30026 XXXXX3/3/2018(blank)(blank)IV
00027479 3/16/2018 USDDXXXXXABAXXXXX(blank) Dansr, Inc(blank)XXXXX(blank)(blank)ChampaignIL61824USUnited States(blank)(blank)(blank)XXXXXXXXXXXXXXX4260 Chain Bridge RdXXXXXVA22030USUnited StatesUS30027 XXXXX3/1/2018(blank)(blank)IV
00027480 3/16/2018 USDDXXXXXABAXXXXX(blank) XXXXXDansr, Inc(blank)XXXXX(blank)(blank)ChampaignIL61824USUnited States(blank)(blank)(blank)XXXXXXXXXXXXXXXXXXXXNY10016USUnited StatesUS30028 XXXXX3/1/2018(blank)(blank)IV
00027482 3/16/2018 USDDXXXXXABAXXXXX(blank) XXXXXDansr, Inc(blank)XXXXX(blank)(blank)ChampaignIL61824USUnited States(blank)(blank)(blank)XXXXXXXXXXXXXXXXXXXXWI53201-3027USUnited StatesUS30029 XXXXX3/8/2018(blank)(blank)IV
00027483 3/16/2018 USDDXXXXXABAXXXXX(blank) Dansr, Inc(blank)XXXXX(blank)(blank)ChampaignIL61824USUnited States(blank)(blank)(blank)XXXXXXXXXXXXXXXXXXXXNY10583USUnited StatesUS30030 XXXXX3/2/2018(blank)(blank)IV
00027487 3/16/2018 USDDXXXXXABAXXXXX(blank) XXXXXDansr, Inc(blank)XXXXX(blank)(blank)ChampaignIL61824USUnited States(blank)(blank)(blank)XXXXXXXXXXXXXXXXXXXXNJ07101-8120USUnited StatesUS30032 XXXXX3/3/2018(blank)(blank)IV
Credit00027451 3/16/2018CCDUSDDXXXXXABAXXXXXDXXXXXABAXXXXXDansr, Inc(blank)XXXXX(blank)(blank)ChampaignIL61824USUnited States(blank)(blank)(blank)XXXXXXXXXXXXXXXXXXXXTX78729USUnited StatesXXXXXUS(blank)XXXXX3/8/2018(blank)(blank)IV
CCDUSDDXXXXXABAXXXXXDXXXXXABAXXXXXDansr, Inc(blank)XXXXX(blank)(blank)ChampaignIL61824USUnited States(blank)(blank)(blank)XXXXXXXXXXXXXXXXXXXXTX78729USUnited StatesXXXXXUS(blank)XXXXX3/9/2018(blank)(blank)IV
00027453 3/16/2018CCDUSDDXXXXXABAXXXXXDXXXXXABAXXXXXDansr, Inc(blank)XXXXX(blank)(blank)ChampaignIL61824USUnited States(blank)(blank)(blank)XXXXXXXXXXXXXXXXXXXXTX76137USUnited StatesXXXXXUS(blank)XXXXX3/5/2018(blank)(blank)IV
00027454 3/16/2018CCDUSDDXXXXXABAXXXXXDXXXXXABAXXXXXDansr, Inc(blank)XXXXX(blank)(blank)ChampaignIL61824USUnited States(blank)(blank)(blank)XXXXXXXXXXXXXXXXXXXXIL61874USUnited StatesXXXXXUS(blank)XXXXX3/13/2018(blank)(blank)IV
00027456 3/16/2018CCDUSDDXXXXXABAXXXXXDXXXXXABAXXXXXDansr, Inc(blank)XXXXX(blank)(blank)ChampaignIL61824USUnited States(blank)(blank)(blank)XXXXXXXXXXXXXXXXXXXXNY14526USUnited StatesXXXXXUS(blank)XXXXX3/3/2018(blank)(blank)IV

<colgroup><col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> <col style="mso-width-source:userset;mso-width-alt:2523;width:52pt" width="69"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:3474;width:71pt" width="95"> <col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:1170;width:24pt" width="32"> <col style="mso-width-source:userset;mso-width-alt:3072;width:63pt" width="84"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:3364;width:69pt" width="92"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="mso-width-source:userset;mso-width-alt:3620;width:74pt" width="99"> <col style="mso-width-source:userset;mso-width-alt:3108;width:64pt" width="85"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> <col style="mso-width-source:userset;mso-width-alt:2962;width:61pt" width="81"> <col style="mso-width-source:userset;mso-width-alt:4059; width:83pt" span="3" width="111"> <col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> <col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="mso-width-source:userset;mso-width-alt:3949;width:81pt" width="108"> <col style="mso-width-source:userset;mso-width-alt:4242;width:87pt" width="116"> <col style="mso-width-source:userset;mso-width-alt:4461;width:92pt" width="122"> <col style="mso-width-source:userset;mso-width-alt:3145;width:65pt" width="86"> <col style="mso-width-source:userset;mso-width-alt:3657;width:75pt" width="100"> <col style="mso-width-source:userset;mso-width-alt:3145;width:65pt" width="86"> <col style="mso-width-source:userset;mso-width-alt:8850;width:182pt" width="242"> <col style="mso-width-source:userset;mso-width-alt:4498;width:92pt" width="123"> <col style="mso-width-source:userset;mso-width-alt:8777;width:180pt" width="240"> <col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:3840;width:79pt" width="105"> <col style="mso-width-source:userset;mso-width-alt:3145;width:65pt" width="86"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:4022;width:83pt" width="110"> <col style="mso-width-source:userset;mso-width-alt:4205;width:86pt" width="115"> <col style="mso-width-source:userset;mso-width-alt:7826;width:161pt" width="214"> <col style="mso-width-source:userset;mso-width-alt:3876;width:80pt" width="106"> <col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> <col style="mso-width-source:userset;mso-width-alt:5851;width:120pt" width="160"> <col style="mso-width-source:userset;mso-width-alt:3803;width:78pt" width="104"> <col style="mso-width-source:userset;mso-width-alt:2230;width:46pt" width="61"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2377;width:49pt" width="65"> <col style="mso-width-source:userset;mso-width-alt:2048;width:42pt" width="56"> <col style="mso-width-source:userset;mso-width-alt:2157;width:44pt" width="59"> <col style="mso-width-source:userset;mso-width-alt:3145;width:65pt" width="86"> </colgroup><tbody>
[TD="class: xl66, width: 78"]PAYMTHD[/TD]
[TD="class: xl67, width: 69"]CRDDBTFL[/TD]
[TD="class: xl67, width: 103"]TRANNO[/TD]
[TD="class: xl67, width: 95"]Payment Date[/TD]
[TD="class: xl67, width: 59"]PAYAMT[/TD]
[TD="class: xl67, width: 77"]PMTFMTCD[/TD]
[TD="class: xl67, width: 32"]CUR[/TD]
[TD="class: xl67, width: 84"]ORIGACCTTY[/TD]
[TD="class: xl67, width: 77"]ORIGACCT[/TD]
[TD="class: xl67, width: 92"]ORIGBNKIDTY[/TD]
[TD="class: xl67, width: 77"]ORIGBNKID[/TD]
[TD="class: xl67, width: 109"]RCVPRTYACCTTY[/TD]
[TD="class: xl67, width: 99"]RCVPRTYACCT[/TD]
[TD="class: xl67, width: 85"]RCVBNKIDTY[/TD]
[TD="class: xl67, width: 71"]RCVBNKID[/TD]
[TD="class: xl67, width: 137"]ORIGTORCVPRYINF[/TD]
[TD="class: xl67, width: 90"]ORIGPRTYNM[/TD]
[TD="class: xl67, width: 81"]ORIGPRTYID[/TD]
[TD="class: xl67, width: 111"]ORIGPRTYADDR1[/TD]
[TD="class: xl67, width: 111"]ORIGPRTYADDR2[/TD]
[TD="class: xl67, width: 111"]ORIGPRTYADDR3[/TD]
[TD="class: xl67, width: 90"]ORIGPRTYCTY[/TD]
[TD="class: xl67, width: 109"]ORIGPRTYSTPRO[/TD]
[TD="class: xl67, width: 108"]ORIGPRTYPSTCD[/TD]
[TD="class: xl67, width: 116"]ORIGPRTYCTRYCD[/TD]
[TD="class: xl67, width: 122"]ORIGPRTYCTRYNM[/TD]
[TD="class: xl67, width: 86"]ORIGBNKNM[/TD]
[TD="class: xl67, width: 100"]ORIGBNKADDR[/TD]
[TD="class: xl67, width: 86"]ORIGBNKCTY[/TD]
[TD="class: xl67, width: 242"]RCVPRTYNM[/TD]
[TD="class: xl67, width: 123"]RVCPRTYID[/TD]
[TD="class: xl67, width: 240"]RCVPRTYADDR1[/TD]
[TD="class: xl67, width: 137"]RCVPRTYADDR2[/TD]
[TD="class: xl67, width: 105"]RCVPRTYADDR3[/TD]
[TD="class: xl67, width: 86"]RCVPRTYCTY[/TD]
[TD="class: xl67, width: 103"]RCVPRTYSTPRO[/TD]
[TD="class: xl67, width: 102"]RCVPRTYPSTCD[/TD]
[TD="class: xl67, width: 110"]RCVPRTYCTRYCD[/TD]
[TD="class: xl67, width: 115"]RCVPRTYCTRYNM[/TD]
[TD="class: xl67, width: 214"]RCVBNKNM[/TD]
[TD="class: xl67, width: 106"]RCVBNKCTRYCD[/TD]
[TD="class: xl67, width: 90"]CHCKNO[/TD]
[TD="class: xl67, width: 160"]Document Number[/TD]
[TD="class: xl67, width: 104"]Document Date[/TD]
[TD="class: xl67, width: 61"]INVDESC[/TD]
[TD="class: xl67, width: 68"]INVDESC2[/TD]
[TD="class: xl67, width: 71"]INVGROSS[/TD]
[TD="class: xl67, width: 65"]INVDISCT[/TD]
[TD="class: xl67, width: 56"]PONUM[/TD]
[TD="class: xl67, width: 59"]INVTYPE[/TD]
[TD="class: xl68, width: 86"]INVONLYREC[/TD]

[TD="class: xl69"]CHK[/TD]

[TD="align: right"]165.1[/TD]

[TD="align: right"]165.1[/TD]
[TD="align: right"]165.1[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl70"]Y[/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]00027477 [/TD]
[TD="class: xl65"]3/16/2018[/TD]
[TD="class: xl65, align: right"]18.69[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]USD[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]ABA[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]Dansr, Inc[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]Champaign[/TD]
[TD="class: xl65"]IL[/TD]
[TD="class: xl65"]61824[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]United States[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]IL[/TD]
[TD="class: xl65"]60094-4515[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]United States[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]30025 [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]3/8/2018[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65, align: right"]18.69[/TD]
[TD="class: xl65, align: right"]18.69[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]IV[/TD]
[TD="class: xl72"]Y[/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65, align: right"]180.34[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]USD[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]ABA[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]Dansr, Inc[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]Champaign[/TD]
[TD="class: xl65"]IL[/TD]
[TD="class: xl65"]61824[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]United States[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]IL[/TD]
[TD="class: xl65"]60094-4515[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]United States[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]30025 [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]3/8/2018[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65, align: right"]180.34[/TD]
[TD="class: xl65, align: right"]180.34[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]IV[/TD]
[TD="class: xl72"]Y[/TD]

[TD="class: xl69"] [/TD]

[TD="align: right"]164.12[/TD]

[TD="align: right"]164.12[/TD]
[TD="align: right"]164.12[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl70"]Y[/TD]

[TD="class: xl69"] [/TD]

[TD="align: right"]500[/TD]

[TD="align: right"]500[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl70"]Y[/TD]

[TD="class: xl69"] [/TD]

[TD="align: right"]520[/TD]

[TD="align: right"]520[/TD]
[TD="align: right"]520[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl70"]Y[/TD]

[TD="class: xl69"] [/TD]

[TD="align: right"]31.79[/TD]

[TD="align: right"]31.79[/TD]
[TD="align: right"]31.79[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl70"]Y[/TD]

[TD="class: xl69"] [/TD]

[TD="align: right"]344.18[/TD]

[TD="align: right"]344.18[/TD]
[TD="align: right"]344.18[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl70"]Y[/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]00027484 [/TD]
[TD="class: xl65"]3/16/2018[/TD]
[TD="class: xl65, align: right"]496.85[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]USD[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]ABA[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]Dansr, Inc[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]Champaign[/TD]
[TD="class: xl65"]IL[/TD]
[TD="class: xl65"]61824[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]United States[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]OH[/TD]
[TD="class: xl65"]45164-2000[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]United States[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]30031 [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]2/27/2018[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65, align: right"]496.85[/TD]
[TD="class: xl65, align: right"]496.85[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]IV[/TD]
[TD="class: xl72"]Y[/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65, align: right"]506.89[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]USD[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]ABA[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]Dansr, Inc[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]Champaign[/TD]
[TD="class: xl65"]IL[/TD]
[TD="class: xl65"]61824[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]United States[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]OH[/TD]
[TD="class: xl65"]45164-2000[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]United States[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]30031 [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]3/2/2018[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65, align: right"]506.89[/TD]
[TD="class: xl65, align: right"]506.89[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]IV[/TD]
[TD="class: xl72"]Y[/TD]

[TD="class: xl69"] [/TD]

[TD="align: right"]191.01[/TD]

[TD="align: right"]191.01[/TD]
[TD="align: right"]191.01[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl70"](blank)[/TD]

[TD="class: xl69"]DAC[/TD]

[TD="align: right"]200[/TD]

[TD="align: right"]200[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl70"]Y[/TD]

[TD="class: xl69"] [/TD]

[TD="align: right"]56.68[/TD]

[TD="align: right"]56.68[/TD]
[TD="align: right"]56.68[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl70"]Y[/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]00027452 [/TD]
[TD="class: xl65"]3/16/2018[/TD]
[TD="class: xl65, align: right"]200[/TD]
[TD="class: xl65"]CCD[/TD]
[TD="class: xl65"]USD[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]ABA[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]ABA[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]Dansr, Inc[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]Champaign[/TD]
[TD="class: xl65"]IL[/TD]
[TD="class: xl65"]61824[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]United States[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]Apt. #21[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]NY[/TD]
[TD="class: xl65"]10032[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]United States[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]3/9/2018[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65, align: right"]200[/TD]
[TD="class: xl65, align: right"]200[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]IV[/TD]
[TD="class: xl72"]Y[/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]3/10/2018[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65, align: right"]200[/TD]
[TD="class: xl65, align: right"]200[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]IV[/TD]
[TD="class: xl72"]Y[/TD]

[TD="class: xl69"] [/TD]

[TD="align: right"]200[/TD]

[TD="align: right"]200[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl70"]Y[/TD]

[TD="class: xl69"] [/TD]

[TD="align: right"]56.63[/TD]

[TD="align: right"]56.63[/TD]
[TD="align: right"]56.63[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl70"]Y[/TD]

[TD="class: xl69"] [/TD]

[TD="align: right"]300[/TD]

[TD="align: right"]300[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]0[/TD]

[TD="class: xl70"]Y[/TD]

[TD="class: xl71"] [/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]00027457 [/TD]
[TD="class: xl65"]3/16/2018[/TD]
[TD="class: xl65, align: right"]1282.75[/TD]
[TD="class: xl65"]CCD[/TD]
[TD="class: xl65"]USD[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]ABA[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]D[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]ABA[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]Dansr, Inc[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]Champaign[/TD]
[TD="class: xl65"]IL[/TD]
[TD="class: xl65"]61824[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]United States[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]303 E Pacific Ave[/TD]
[TD="class: xl65"] [/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]WA[/TD]
[TD="class: xl65"]99202[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"]United States[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]US[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]XXXXX[/TD]
[TD="class: xl65"]3/9/2018[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65, align: right"]1282.75[/TD]
[TD="class: xl65, align: right"]1282.75[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65"](blank)[/TD]
[TD="class: xl65"]IV[/TD]
[TD="class: xl72"]Y[/TD]

[TD="class: xl73"] [/TD]
[TD="class: xl74"] [/TD]
[TD="class: xl74"] [/TD]
[TD="class: xl74"] [/TD]
[TD="class: xl74, align: right"]1653.25[/TD]
[TD="class: xl74"]CCD[/TD]
[TD="class: xl74"]USD[/TD]
[TD="class: xl74"]D[/TD]
[TD="class: xl74"]XXXXX[/TD]
[TD="class: xl74"]ABA[/TD]
[TD="class: xl74"]XXXXX[/TD]
[TD="class: xl74"]D[/TD]
[TD="class: xl74"]XXXXX[/TD]
[TD="class: xl74"]ABA[/TD]
[TD="class: xl74"]XXXXX[/TD]
[TD="class: xl74"] [/TD]
[TD="class: xl74"]Dansr, Inc[/TD]
[TD="class: xl74"](blank)[/TD]
[TD="class: xl74"]XXXXX[/TD]
[TD="class: xl74"](blank)[/TD]
[TD="class: xl74"](blank)[/TD]
[TD="class: xl74"]Champaign[/TD]
[TD="class: xl74"]IL[/TD]
[TD="class: xl74"]61824[/TD]
[TD="class: xl74"]US[/TD]
[TD="class: xl74"]United States[/TD]
[TD="class: xl74"](blank)[/TD]
[TD="class: xl74"](blank)[/TD]
[TD="class: xl74"](blank)[/TD]
[TD="class: xl74"]XXXXX[/TD]
[TD="class: xl74"]XXXXX[/TD]
[TD="class: xl74"]XXXXX[/TD]
[TD="class: xl74"]303 E Pacific Ave[/TD]
[TD="class: xl74"] [/TD]
[TD="class: xl74"]XXXXX[/TD]
[TD="class: xl74"]WA[/TD]
[TD="class: xl74"]99202[/TD]
[TD="class: xl74"]US[/TD]
[TD="class: xl74"]United States[/TD]
[TD="class: xl74"]XXXXX[/TD]
[TD="class: xl74"]US[/TD]
[TD="class: xl74"](blank)[/TD]
[TD="class: xl74"]XXXXX[/TD]
[TD="class: xl74"]3/9/2018[/TD]
[TD="class: xl74"](blank)[/TD]
[TD="class: xl74, align: right"]1653.25[/TD]
[TD="class: xl74, align: right"]1653.25[/TD]
[TD="class: xl74, align: right"]0[/TD]
[TD="class: xl74"](blank)[/TD]
[TD="class: xl74"]IV[/TD]
[TD="class: xl75"]Y[/TD]

</tbody>



<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false" DefSemiHidden="false" DefQFormat="false" DefPriority="99" LatentStyleCount="375"> <w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index 9"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" Name="toc 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footnote text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="header"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footer"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="index heading"/> <w:LsdException Locked="false" Priority="35" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="caption"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="table of figures"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="envelope address"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="envelope return"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="footnote reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="line number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="page number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="endnote reference"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="endnote text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="table of authorities"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="macro"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="toa heading"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Bullet 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Number 5"/> <w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Closing"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Signature"/> <w:LsdException Locked="false" Priority="1" SemiHidden="true" UnhideWhenUsed="true" Name="Default Paragraph Font"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="List Continue 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Message Header"/> <w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Salutation"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Date"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text First Indent"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text First Indent 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Note Heading"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Body Text Indent 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Block Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Hyperlink"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="FollowedHyperlink"/> <w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Document Map"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Plain Text"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="E-mail Signature"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Top of Form"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Bottom of Form"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal (Web)"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Acronym"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Address"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Cite"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Code"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Definition"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Keyboard"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Preformatted"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Sample"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Typewriter"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="HTML Variable"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Normal Table"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="annotation subject"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="No List"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Outline List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Simple 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Classic 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Colorful 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Columns 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Grid 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table List 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table 3D effects 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Contemporary"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Elegant"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Professional"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Subtle 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Subtle 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 1"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 2"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Web 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Balloon Text"/> <w:LsdException Locked="false" Priority="39" Name="Table Grid"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Table Theme"/> <w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" Name="Light List"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" SemiHidden="true" Name="Revision"/> <w:LsdException Locked="false" Priority="34" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" SemiHidden="true" UnhideWhenUsed="true" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/> <w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/> <w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/> <w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/> <w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/> <w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/> <w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 1"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 2"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 3"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 4"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 5"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light Accent 6"/> <w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/> <w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/> <w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/> <w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/> <w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 1"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 1"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 2"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 2"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 3"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 3"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 4"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 4"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 5"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 5"/> <w:LsdException Locked="false" Priority="46" Name="List Table 1 Light Accent 6"/> <w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/> <w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/> <w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/> <w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/> <w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful Accent 6"/> <w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful Accent 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Mention"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Smart Hyperlink"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Hashtag"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" Name="Unresolved Mention"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]-->
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
570
smozgur
smozgur
M
  • Question Question
Creating Results Table + Hiding columns based on text in specific row
Replies
4
Views
753
MelissaBr
M
P
  • Question Question
Automatically inserting VBA into a workbook
Replies
1
Views
1K
Phillip2
P
S
  • Question Question
Type mismatch using date in InputBox
Replies
1
Views
1K
SeniorTom
S
P
  • Question Question
Using Lastrow
Replies
6
Views
1K
DanteAmor
DanteAmor

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

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