Percentages based on description criteria

P

Panoos64

Well-known Member
Joined
Mar 1, 2014
Messages
890
<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:RelyOnVML/> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, I would like to create a vba code so that to prepare the percentages in col. C, E, G, I, K, based on categories descriptions criteria, as my below P & L. extract. In sched. 1 are the original data and in sched. 2 is the expected result. Due to much more rows, i present an extract. Just i need a support to begin and then i will adapt it to whole spreadsheet. I would be appreciated any support. Many thanks in advance.


Sched.1



<tbody>
[TD="align: center"][/TD]
[TD="width: 205, align: center"]A[/TD]
[TD="class: xl68, width: 83, align: center"]B[/TD]
[TD="class: xl71, width: 65, align: center"]C[/TD]
[TD="width: 72, align: center"]D[/TD]
[TD="width: 64, align: center"]E[/TD]
[TD="width: 72, align: center"]F[/TD]
[TD="width: 64, align: center"]G[/TD]
[TD="width: 64, align: center"]H[/TD]
[TD="width: 64, align: center"]I[/TD]
[TD="width: 80, align: center"]J[/TD]
[TD="width: 69, align: center"]K[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"] JULY / 2017
 [/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]5[/TD]
[TD="align: center"] Account Description [/TD]
[TD="class: xl69, width: 83, align: center"] THIS MONTH P & L [/TD]
[TD="class: xl72, align: center"] % [/TD]
[TD="class: xl66, width: 72, align: center"] THIS YEAR P & L [/TD]
[TD="class: xl65, align: center"] % [/TD]
[TD="class: xl66, width: 72, align: center"] L. Y. MONTHLY P & L [/TD]
[TD="class: xl65, align: center"] % [/TD]
[TD="class: xl66, width: 64, align: center"] L.Y. ACCUM. P & L [/TD]
[TD="class: xl65, align: center"] % [/TD]
[TD="class: xl65, align: center"] VARIANCES [/TD]
[TD="class: xl65, align: center"] % [/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]Beverage income[/TD]
[TD="class: xl68, align: center"]265.125[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"]1.200.122[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"]250.487[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 64, align: center"]1.100.236[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 80, align: center"]99.886[/TD]
[TD="class: xl71, align: center"][/TD]

[TD="align: center"]10[/TD]
[TD="class: xl67, width: 205, align: center"]Other income[/TD]
[TD="class: xl68, align: center"]12.854[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"]60.452[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"]12.489[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 64, align: center"]58.478[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 80, align: center"]1.974[/TD]
[TD="class: xl71, align: center"][/TD]

[TD="align: center"]11[/TD]
[TD="align: center"] TOTAL INCOME [/TD]
[TD="class: xl70, width: 83, align: center"]1.177.824[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"]5.915.825[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"]1.163.559[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 64, align: center"]5.682.022[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 80, align: center"]233.803[/TD]
[TD="class: xl71, align: center"][/TD]

[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 64, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 80, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]

[TD="align: center"]15[/TD]
[TD="align: center"]Printing / stationery[/TD]
[TD="class: xl68, align: center"]5.245[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"]20.145[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"]6.785[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 64, align: center"]30.147[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 80, align: center"]-10.002[/TD]
[TD="class: xl71, align: center"][/TD]

[TD="align: center"]16[/TD]
[TD="align: center"]Fuel & gaz[/TD]
[TD="class: xl68, align: center"]7.865[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"]35.137[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"]9.745[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 64, align: center"]42.745[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 80, align: center"]-7.608[/TD]
[TD="class: xl71, align: center"][/TD]

[TD="align: center"]17[/TD]
[TD="align: center"]Telephones / postages[/TD]
[TD="class: xl68, align: center"]6.748[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"]32.745[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"]8.456[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 64, align: center"]41.857[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 80, align: center"]-9.112[/TD]
[TD="class: xl71, align: center"][/TD]

[TD="align: center"]18[/TD]
[TD="align: center"] OPERATING EXPENSES [/TD]
[TD="class: xl68, align: center"]230.158[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl68, align: center"]1.151.172[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl68, align: center"]240.569[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl68, align: center"]1.174.330[/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl68, align: center"]-23.158[/TD]
[TD="class: xl71, align: center"][/TD]

</tbody>


Sched.2



<tbody>
[TD="align: center"][/TD]
[TD="width: 205, align: center"]A[/TD]
[TD="class: xl68, width: 83, align: center"]B[/TD]
[TD="class: xl71, width: 65, align: center"]C[/TD]
[TD="width: 72, align: center"]D[/TD]
[TD="width: 64, align: center"]E[/TD]
[TD="width: 72, align: center"]F[/TD]
[TD="width: 64, align: center"]G[/TD]
[TD="width: 64, align: center"]H[/TD]
[TD="width: 64, align: center"]I[/TD]
[TD="width: 80, align: center"]J[/TD]
[TD="width: 69, align: center"]K[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"] JULY / 2017
 [/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]5[/TD]
[TD="align: center"] Account Description [/TD]
[TD="class: xl69, width: 83, align: center"] THIS MONTH P & L [/TD]
[TD="class: xl72, align: center"] %
 [/TD]
[TD="class: xl66, width: 72, align: center"] THIS YEAR P & L [/TD]
[TD="class: xl65, align: center"] % [/TD]
[TD="class: xl66, width: 72, align: center"] L. Y. MONTHLY P & L [/TD]
[TD="class: xl65, align: center"] % [/TD]
[TD="class: xl66, width: 64, align: center"] L.Y. ACCUM. P & L [/TD]
[TD="class: xl65, align: center"] % [/TD]
[TD="class: xl65, align: center"] VARIANCES [/TD]
[TD="class: xl65, align: center"] % [/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]Beverage income[/TD]
[TD="class: xl68, align: center"]265.125[/TD]
[TD="class: xl71, align: center"]22,51%[/TD]
[TD="class: xl70, width: 72, align: center"]1.200.122[/TD]
[TD="class: xl71, align: center"]20,29%[/TD]
[TD="class: xl70, width: 72, align: center"]250.487[/TD]
[TD="class: xl71, align: center"]21,53%[/TD]
[TD="class: xl70, width: 64, align: center"]1.100.236[/TD]
[TD="class: xl71, align: center"]19,36%[/TD]
[TD="class: xl70, width: 80, align: center"]99.886[/TD]
[TD="class: xl71, align: center"]42,72%[/TD]

[TD="align: center"]10[/TD]
[TD="class: xl67, width: 205, align: center"]Other income[/TD]
[TD="class: xl68, align: center"]12.854[/TD]
[TD="class: xl71, align: center"]1,09%[/TD]
[TD="class: xl70, width: 72, align: center"]60.452[/TD]
[TD="class: xl71, align: center"]1,02%[/TD]
[TD="class: xl70, width: 72, align: center"]12.489[/TD]
[TD="class: xl71, align: center"]1,07%[/TD]
[TD="class: xl70, width: 64, align: center"]58.478[/TD]
[TD="class: xl71, align: center"]1,03%[/TD]
[TD="class: xl70, width: 80, align: center"]1.974[/TD]
[TD="class: xl71, align: center"]0,84%[/TD]

[TD="align: center"]11[/TD]
[TD="align: center"] TOTAL INCOME [/TD]
[TD="class: xl70, width: 83, align: center"]1.177.824[/TD]
[TD="class: xl71, align: center"]100,00%[/TD]
[TD="class: xl70, width: 72, align: center"]5.915.825[/TD]
[TD="class: xl71, align: center"]100,00%[/TD]
[TD="class: xl70, width: 72, align: center"]1.163.559[/TD]
[TD="class: xl71, align: center"]100,00%[/TD]
[TD="class: xl70, width: 64, align: center"]5.682.022[/TD]
[TD="class: xl71, align: center"]100,00%[/TD]
[TD="class: xl70, width: 80, align: center"]233.803[/TD]
[TD="class: xl71, align: center"]100,00%[/TD]

[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 64, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 80, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]

[TD="align: center"]15[/TD]
[TD="align: center"]Printing / stationery[/TD]
[TD="class: xl68, align: center"]5.245[/TD]
[TD="class: xl71, align: center"]1,90%[/TD]
[TD="class: xl70, width: 72, align: center"]20.145[/TD]
[TD="class: xl71, align: center"]1,48%[/TD]
[TD="class: xl70, width: 72, align: center"]6.785[/TD]
[TD="class: xl71, align: center"]2,38%[/TD]
[TD="class: xl70, width: 64, align: center"]30.147[/TD]
[TD="class: xl71, align: center"]2,19%[/TD]
[TD="class: xl70, width: 80, align: center"]-10.002[/TD]
[TD="class: xl71, align: center"]64,49%[/TD]

[TD="align: center"]16[/TD]
[TD="align: center"]Fuel & gaz[/TD]
[TD="class: xl68, align: center"]7.865[/TD]
[TD="class: xl71, align: center"]2,85%[/TD]
[TD="class: xl70, width: 72, align: center"]35.137[/TD]
[TD="class: xl71, align: center"]2,58%[/TD]
[TD="class: xl70, width: 72, align: center"]9.745[/TD]
[TD="class: xl71, align: center"]3,42%[/TD]
[TD="class: xl70, width: 64, align: center"]42.745[/TD]
[TD="class: xl71, align: center"]3,10%[/TD]
[TD="class: xl70, width: 80, align: center"]-7.608[/TD]
[TD="class: xl71, align: center"]49,06%[/TD]

[TD="align: center"]17[/TD]
[TD="align: center"]Telephones / postages[/TD]
[TD="class: xl68, align: center"]6.748[/TD]
[TD="class: xl71, align: center"]2,45%[/TD]
[TD="class: xl70, width: 72, align: center"]32.745[/TD]
[TD="class: xl71, align: center"]2,40%[/TD]
[TD="class: xl70, width: 72, align: center"]8.456[/TD]
[TD="class: xl71, align: center"]2,97%[/TD]
[TD="class: xl70, width: 64, align: center"]41.857[/TD]
[TD="class: xl71, align: center"]3,04%[/TD]
[TD="class: xl70, width: 80, align: center"]-9.112[/TD]
[TD="class: xl71, align: center"]58,75%[/TD]

[TD="align: center"]18[/TD]
[TD="align: center"] OPERATING EXPENSES
 [/TD]
[TD="class: xl68, align: center"]230.158[/TD]
[TD="class: xl71, align: center"]83,52%[/TD]
[TD="class: xl68, align: center"]1.151.172[/TD]
[TD="class: xl71, align: center"]84,45%[/TD]
[TD="class: xl68, align: center"]240.569[/TD]
[TD="class: xl71, align: center"]84,37%[/TD]
[TD="class: xl68, align: center"]1.174.330[/TD]
[TD="class: xl71, align: center"]85,18%[/TD]
[TD="class: xl68, align: center"]-23.158[/TD]
[TD="class: xl71, align: center"]149,32%[/TD]

</tbody>
<!--[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="371"> <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: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:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0cm; line-height:107%; 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]-->
 
Last edited:

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Sort by date Sort by votes
first - only use 2 dec places as it is money

22.51 = 100*265.125/1177.824

why do you want to use vba when formulas will do it all
 
Upvote 0
Hi, I entered numbers in thousands without decimals. In addition the % formula is the income or expense line account / TOTAL income or expenses. I have a mistake in TOTAL EXPENSES and so i present below revised schedules. Due to the rows which are not stable, is the reason to create vba. However many thanks for your interesting to resolve my issue.

Sched.1


<tbody>
[TD="align: center"][/TD]
[TD="width: 205, align: center"]A[/TD]
[TD="class: xl66, width: 83, align: center"]B[/TD]
[TD="class: xl69, width: 65, align: center"]C[/TD]
[TD="width: 72, align: center"]D[/TD]
[TD="width: 64, align: center"]E[/TD]
[TD="width: 72, align: center"]F[/TD]
[TD="width: 64, align: center"]G[/TD]
[TD="width: 64, align: center"]H[/TD]
[TD="width: 64, align: center"]I[/TD]
[TD="width: 80, align: center"]J[/TD]
[TD="width: 69, align: center"]K[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]JULY / 2017[/TD]
[TD="class: xl66, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]Account Description[/TD]
[TD="class: xl67, width: 83, align: center"]THIS MONTH P & L[/TD]
[TD="class: xl70, align: center"]%[/TD]
[TD="class: xl64, width: 72, align: center"]THIS YEAR P & L[/TD]
[TD="class: xl63, align: center"]%[/TD]
[TD="class: xl64, width: 72, align: center"]L. Y. MONTHLY P & L[/TD]
[TD="class: xl63, align: center"]%[/TD]
[TD="class: xl64, width: 64, align: center"]L.Y. ACCUM. P & L[/TD]
[TD="class: xl63, align: center"]%[/TD]
[TD="class: xl63, align: center"]VARIANCES[/TD]
[TD="class: xl63, align: center"]%[/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]Beverage income[/TD]
[TD="class: xl66, align: center"]265.125[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]1.200.122[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]250.487[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 64, align: center"]1.100.236[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 80, align: center"]99.886[/TD]
[TD="class: xl69, align: center"][/TD]

[TD="align: center"]10[/TD]
[TD="class: xl65, width: 205, align: center"]Other income[/TD]
[TD="class: xl66, align: center"]12.854[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]60.452[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]12.489[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 64, align: center"]58.478[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 80, align: center"]1.974[/TD]
[TD="class: xl69, align: center"][/TD]

[TD="align: center"]11[/TD]
[TD="align: center"]TOTAL INCOME[/TD]
[TD="class: xl68, width: 83, align: center"]1.177.824[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]5.915.825[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]1.163.559[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 64, align: center"]5.682.022[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 80, align: center"]233.803[/TD]
[TD="class: xl69, align: center"][/TD]

[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[TD="class: xl66, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 64, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 80, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]

[TD="align: center"]20[/TD]
[TD="align: center"]Depreciation[/TD]
[TD="class: xl66, align: center"]9.750[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]41.258[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]9.855[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 64, align: center"]48.782[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 80, align: center"]-7.524[/TD]
[TD="class: xl69, align: center"][/TD]

[TD="align: center"]21[/TD]
[TD="align: center"]Provision for bad debts[/TD]
[TD="class: xl66, align: center"]10.250[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]50.458[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]10.480[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 64, align: center"]35.458[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 80, align: center"]15.000[/TD]
[TD="class: xl69, align: center"][/TD]

[TD="align: center"]22[/TD]
[TD="align: center"]Bad debts[/TD]
[TD="class: xl66, align: center"]4.678[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]20.456[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]4.789[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 64, align: center"]23.706[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 80, align: center"]-3.250[/TD]
[TD="class: xl69, align: center"][/TD]

[TD="align: center"]23[/TD]
[TD="align: center"]Interest & bank charges[/TD]
[TD="class: xl66, align: center"]20.745[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]99.745[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]19.459[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 64, align: center"]96.322[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 80, align: center"]3.423[/TD]
[TD="class: xl69, align: center"][/TD]

[TD="align: center"]24[/TD]
[TD="align: center"]ADMINISTRATION EXPENSES[/TD]
[TD="class: xl68, width: 83, align: center"]45.423[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]211.917[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]44.583[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 64, align: center"]204.268[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 80, align: center"]7.649[/TD]
[TD="class: xl69, align: center"][/TD]

[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="class: xl66, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 64, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 80, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]

[TD="align: center"]26[/TD]
[TD="align: center"]TOTAL EXPENSES[/TD]
[TD="class: xl66, align: center"]275.581[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]1.363.089[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"]285.152[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 64, align: center"]1.378.598[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 80, align: center"]-15.509[/TD]
[TD="class: xl69, align: center"][/TD]

[TD="align: center"]27[/TD]
[TD="align: center"][/TD]
[TD="class: xl66, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 72, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 64, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl68, width: 80, align: center"][/TD]
[TD="class: xl69, align: center"][/TD]

[TD="align: center"]28[/TD]
[TD="align: center"]NET PROFIT / LOSS[/TD]
[TD="class: xl66, align: center"]902.243[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl66, align: center"]4.552.736[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl66, align: center"]878.407[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl66, align: center"]4.303.424[/TD]
[TD="class: xl69, align: center"][/TD]
[TD="class: xl66, align: center"]249.312[/TD]
[TD="class: xl69, align: center"][/TD]

</tbody>




Sched.2


<tbody>
[TD="align: center"][/TD]
[TD="width: 205, align: center"]A[/TD]
[TD="class: xl68, width: 83, align: center"]B[/TD]
[TD="class: xl71, width: 65, align: center"]C[/TD]
[TD="width: 72, align: center"]D[/TD]
[TD="width: 64, align: center"]E[/TD]
[TD="width: 72, align: center"]F[/TD]
[TD="width: 64, align: center"]G[/TD]
[TD="width: 64, align: center"]H[/TD]
[TD="width: 64, align: center"]I[/TD]
[TD="width: 80, align: center"]J[/TD]
[TD="width: 69, align: center"]K[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"] JULY / 2017
 [/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]5[/TD]
[TD="align: center"] Account Description [/TD]
[TD="class: xl69, width: 83, align: center"] THIS MONTH P & L [/TD]
[TD="class: xl72, align: center"] % [/TD]
[TD="class: xl66, width: 72, align: center"] THIS YEAR P & L [/TD]
[TD="class: xl65, align: center"] % [/TD]
[TD="class: xl66, width: 72, align: center"] L. Y. MONTHLY P & L [/TD]
[TD="class: xl65, align: center"] % [/TD]
[TD="class: xl66, width: 64, align: center"] L.Y. ACCUM. P & L [/TD]
[TD="class: xl65, align: center"] % [/TD]
[TD="class: xl65, align: center"] VARIANCES [/TD]
[TD="class: xl65, align: center"]%[/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]Beverage income[/TD]
[TD="class: xl68, align: center"]265.125[/TD]
[TD="class: xl71, align: center"]22,51%[/TD]
[TD="class: xl70, width: 72, align: center"]1.200.122[/TD]
[TD="class: xl71, align: center"]20,29%[/TD]
[TD="class: xl70, width: 72, align: center"]250.487[/TD]
[TD="class: xl71, align: center"]21,53%[/TD]
[TD="class: xl70, width: 64, align: center"]1.100.236[/TD]
[TD="class: xl71, align: center"]19,36%[/TD]
[TD="class: xl70, width: 80, align: center"]99.886[/TD]
[TD="class: xl71, align: center"]42,72%[/TD]

[TD="align: center"]10[/TD]
[TD="class: xl67, width: 205, align: center"]Other income
[/TD]
[TD="class: xl68, align: center"]12.854[/TD]
[TD="class: xl71, align: center"]1,09%[/TD]
[TD="class: xl70, width: 72, align: center"]60.452[/TD]
[TD="class: xl71, align: center"]1,02%[/TD]
[TD="class: xl70, width: 72, align: center"]12.489[/TD]
[TD="class: xl71, align: center"]1,07%[/TD]
[TD="class: xl70, width: 64, align: center"]58.478[/TD]
[TD="class: xl71, align: center"]1,03%[/TD]
[TD="class: xl70, width: 80, align: center"]1.974[/TD]
[TD="class: xl71, align: center"]0,84%[/TD]

[TD="align: center"]11[/TD]
[TD="align: center"] TOTAL INCOME
 [/TD]
[TD="class: xl70, width: 83, align: center"] 1.177.824 [/TD]
[TD="class: xl71, align: center"] 100,00% [/TD]
[TD="class: xl70, width: 72, align: center"] 5.915.825 [/TD]
[TD="class: xl71, align: center"] 100,00% [/TD]
[TD="class: xl70, width: 72, align: center"] 1.163.559 [/TD]
[TD="class: xl71, align: center"] 100,00% [/TD]
[TD="class: xl70, width: 64, align: center"] 5.682.022 [/TD]
[TD="class: xl71, align: center"] 100,00% [/TD]
[TD="class: xl70, width: 80, align: center"] 233.803 [/TD]
[TD="class: xl71, align: center"] 100,00% [/TD]

[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 64, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 80, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]

[TD="align: center"]20[/TD]
[TD="align: center"]Depreciation[/TD]
[TD="class: xl68, align: center"]9.750[/TD]
[TD="class: xl71, align: center"]3,54%[/TD]
[TD="class: xl70, width: 72, align: center"]41.258[/TD]
[TD="class: xl71, align: center"]3,03%[/TD]
[TD="class: xl70, width: 72, align: center"]9.855[/TD]
[TD="class: xl71, align: center"]3,46%[/TD]
[TD="class: xl70, width: 64, align: center"]48.782[/TD]
[TD="class: xl71, align: center"]3,54%[/TD]
[TD="class: xl70, width: 80, align: center"]-7.524[/TD]
[TD="class: xl71, align: center"]48,52%[/TD]

[TD="align: center"]21[/TD]
[TD="align: center"]Provision for bad debts[/TD]
[TD="class: xl68, align: center"]10.250[/TD]
[TD="class: xl71, align: center"]3,72%[/TD]
[TD="class: xl70, width: 72, align: center"]50.458[/TD]
[TD="class: xl71, align: center"]3,70%[/TD]
[TD="class: xl70, width: 72, align: center"]10.480[/TD]
[TD="class: xl71, align: center"]3,68%[/TD]
[TD="class: xl70, width: 64, align: center"]35.458[/TD]
[TD="class: xl71, align: center"]2,57%[/TD]
[TD="class: xl70, width: 80, align: center"]15.000[/TD]
[TD="class: xl71, align: center"]-96,72%[/TD]

[TD="align: center"]22[/TD]
[TD="align: center"]Bad debts[/TD]
[TD="class: xl68, align: center"]4.678[/TD]
[TD="class: xl71, align: center"]1,70%[/TD]
[TD="class: xl70, width: 72, align: center"]20.456[/TD]
[TD="class: xl71, align: center"]1,50%[/TD]
[TD="class: xl70, width: 72, align: center"]4.789[/TD]
[TD="class: xl71, align: center"]1,68%[/TD]
[TD="class: xl70, width: 64, align: center"]23.706[/TD]
[TD="class: xl71, align: center"]1,72%[/TD]
[TD="class: xl70, width: 80, align: center"]-3.250[/TD]
[TD="class: xl71, align: center"]20,95%[/TD]

[TD="align: center"]23[/TD]
[TD="align: center"]Interest & bank charges[/TD]
[TD="class: xl68, align: center"]20.745[/TD]
[TD="class: xl71, align: center"]7,53%[/TD]
[TD="class: xl70, width: 72, align: center"]99.745[/TD]
[TD="class: xl71, align: center"]7,32%[/TD]
[TD="class: xl70, width: 72, align: center"]19.459[/TD]
[TD="class: xl71, align: center"]6,82%[/TD]
[TD="class: xl70, width: 64, align: center"]96.322[/TD]
[TD="class: xl71, align: center"]6,99%[/TD]
[TD="class: xl70, width: 80, align: center"]3.423[/TD]
[TD="class: xl71, align: center"]-22,07%[/TD]

[TD="align: center"]24
[/TD]
[TD="align: center"] ADMINISTRATION EXPENSES
 [/TD]
[TD="class: xl70, width: 83, align: center"] 45.423 [/TD]
[TD="class: xl71, align: center"] 16,48% [/TD]
[TD="class: xl70, width: 72, align: center"] 211.917 [/TD]
[TD="class: xl71, align: center"] 15,55% [/TD]
[TD="class: xl70, width: 72, align: center"] 44.583 [/TD]
[TD="class: xl71, align: center"] 15,63% [/TD]
[TD="class: xl70, width: 64, align: center"] 204.268 [/TD]
[TD="class: xl71, align: center"] 14,82% [/TD]
[TD="class: xl70, width: 80, align: center"] 7.649 [/TD]
[TD="class: xl71, align: center"] -49,32% [/TD]

[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 64, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 80, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]

[TD="align: center"]26[/TD]
[TD="align: center"] TOTAL EXPENSES
 [/TD]
[TD="class: xl68, align: center"] 275.581 [/TD]
[TD="class: xl71, align: center"] 100,00% [/TD]
[TD="class: xl70, width: 72, align: center"] 1.363.089 [/TD]
[TD="class: xl71, align: center"] 100,00% [/TD]
[TD="class: xl70, width: 72, align: center"] 285.152 [/TD]
[TD="class: xl71, align: center"] 100,00% [/TD]
[TD="class: xl70, width: 64, align: center"] 1.378.598 [/TD]
[TD="class: xl71, align: center"] 100,00% [/TD]
[TD="class: xl70, width: 80, align: center"] -15.509 [/TD]
[TD="class: xl71, align: center"] 100,00% [/TD]

[TD="align: center"]27[/TD]
[TD="align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 72, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 64, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]
[TD="class: xl70, width: 80, align: center"][/TD]
[TD="class: xl71, align: center"][/TD]

[TD="align: center"]28[/TD]
[TD="align: center"]NET PROFIT / LOSS[/TD]
[TD="class: xl68, align: center"]902.243[/TD]
[TD="class: xl71, align: center"]76,60%[/TD]
[TD="class: xl68, align: center"]4.552.736[/TD]
[TD="class: xl71, align: center"]76,96%[/TD]
[TD="class: xl68, align: center"]878.407[/TD]
[TD="class: xl71, align: center"]75,49%[/TD]
[TD="class: xl68, align: center"]4.303.424[/TD]
[TD="class: xl71, align: center"]75,74%[/TD]
[TD="class: xl68, align: center"]249.312[/TD]
[TD="class: xl71, align: center"]106,63%[/TD]

</tbody>
 
Upvote 0
Due to the rows which are not stable, is the reason to create vba

do you mean interest can come, say, before depreciation ?
 
Upvote 0
The rows, whenever I export the data are change due to the accounts. Some accounts have no movement so does not not appear or I add new accounts which appear in spreadsheet. The interest row is ok but above depreciation & beverage income exist rows with amounts too.
 
Last edited:
Upvote 0
if you have annual accounts then you need to make provision for every category in the summary (annual) table, so look at last few years and include EVERY category plus say 5 more misc1 misc2 etc - then it will be easy to build a summary table.
 
Upvote 0
oldb, all accounts and rows (including blanks) are around 800 KB and so is impossible to prepare it over the web-site. kindly require to prepare a vba based to above data and then i will adapt it to whole spreadsheet. Furthermore, i do not like to prepare it using pivot or other tables. I would appreciated any support through vba. Many thanks
 
Upvote 0
going back to your original post, you seem to only want the %'s calculating - if you need to insert a new row for a new financial category just do it and use the macro to put in the % formulas. I feel I still do not grasp what you want............
 
Upvote 0
Yes you have right. I just want %. I need a macro so that to run through col. "A" and where find the specific accounts descriptions should be placed % number in adjacent cell in col. "C". This code should be repeating for col. E, G, I and K. Thanks and have a nice day.
 
Last edited:
Upvote 0
[TABLE="width: 425"]
<colgroup><col><col span="4"></colgroup><tbody>[TR]
[TD]Printing / stationery[/TD]
[TD]5.245[/TD]
[TD]1,90%[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fuel & gaz[/TD]
[TD]7.865[/TD]
[TD]2,85%[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Telephones / postages[/TD]
[TD]6.748[/TD]
[TD]2,45%[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]OPERATING EXPENSES[/TD]
[TD]230.158[/TD]
[TD]83,52%[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"]I do not understand this bit[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"]5.245 is 1.9% of 276.05[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]where is this 276.05[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"]and are operating expenses[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]something different[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
VBA help - Locking & unlocking on certain times of day
2
Replies
17
Views
469
dmt32
D
K
  • Question Question
How to shorten vba code without any problems
Replies
1
Views
288
kamranyd
K
A
  • Question Question
After User Enters A Value (Validation List), Not Automatically Advancing To Next Cell As Per "Select"
Replies
1
Views
403
Ark68
A
A
  • Question Question
Auto Update Sheets in Scheduler file
Replies
6
Views
564
anuradhagrewal
A
S
  • Question Question
Macro for
Replies
2
Views
120
Sanderb
S

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

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