Physical File: AGEDAR 

      *-------------------------------------------------------------------------

      * @Name - AGEDAR

      *-------------------------------------------------------------------------

     A                                      UNIQUE

     A          R AGEDARR                   TEXT('Aged AR')

     A            UID           15  0       COLHDG('Record Unique Id')

     A            CSTNAM        30A         COLHDG('Customer Name')

     A            ALCDYPY        3  0       COLHDG('Alloc Days to Pay')

     A            DY0TO30        9  2       COLHDG('0 to 30')

     A            DY31TO60       9  2       COLHDG('31 to 60')

     A            DY61TO90       9  2       COLHDG('61 to 90')

     A            DY91TO120      9  2       COLHDG('91 to 120')

     A            DY120          9  2       COLHDG('120+')

     A            NOTES        100A         COLHDG('Notes')

     A          K UID

Program: MSEXCEL 

      //*******************************************************************************************

      // @Author: Aaron Bartell

      // @Created: 2008-01-03

      // @Descr: Compose a Microsoft Excel document using Microsoft's XML format.  This particular

      //         program creates an AR aging spreadsheet.

      // @Notes:

      //*******************************************************************************************

     H dftactgrp(*no) bnddir('RXSBND')

     FAGEDAR    if   e           k disk

      /copy rxs,RXSCp

     D gError          ds                  likeds(RXS_Error)

     D rowStart        s             10i 0 inz(8)

     D rowCount        s             10i 0

      /free

       reset rowCount;

       monitor;

         RXS_initTplEng(RXS_STMF: 'aged_ar.xls': 819: *omit: *omit: *on);

         RXS_loadTpl('msexcel_aged_ar.tpl');

         RXS_updVar('company_name': 'I Got Worms Petshop Inc.');

         RXS_updVar('date': %char(%date()));

         RXS_wrtSection('doc_beg');

         setll *loval AGEDAR;

         read AGEDAR;

         dow not %eof(AGEDAR);

           RXS_updVar('CSTNAM': CSTNAM);

           RXS_updVar('ALCDYPY': %char(ALCDYPY));

           RXS_updVar('DY0TO30': %char(DY0TO30));

           RXS_updVar('DY31TO60': %char(DY31TO60));

           RXS_updVar('DY61TO90': %char(DY61TO90));

           RXS_updVar('DY91TO120': %char(DY91TO120));

           RXS_updVar('DY120': %char(DY120));

           RXS_updVar('NOTES': NOTES);

           RXS_wrtSection('row');

           rowCount = rowCount + 1;

           read AGEDAR;

         enddo;

         // Need to update the "SUM" formula with the range of where to stop

         // calculating the columns to ensure errors don't occur.

         RXS_updVar('total_sum': %char(rowStart - rowCount));

         RXS_wrtSection('doc_end': *on);

       on-error;

         gError = RXS_catchError();

       endmon;

       *inlr = *on;

      /end-free

IFS Template: /www/myrxs/templates/msexcel_aged_ar.tpl 

::doc_beg 

<?xml version="1.0"?>

<?mso-application progid="Excel.Sheet"?>

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

 xmlns:o="urn:schemas-microsoft-com:office:office"

 xmlns:x="urn:schemas-microsoft-com:office:excel"

 xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"

 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"

 xmlns:html="http://www.w3.org/TR/REC-html40">

 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">

  <LastAuthor>Aaron L Bartell</LastAuthor>

  <LastPrinted>2004-11-15T18:58:40Z</LastPrinted>

  <Created>2004-04-19T18:14:08Z</Created>

  <LastSaved>2005-01-11T22:59:24Z</LastSaved>

  <Version>11.6568</Version>

 </DocumentProperties>

 <CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">

  <_TemplateID dt:dt="string">TC011725491033</_TemplateID>

 </CustomDocumentProperties>

 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">

  <Colors>

   <Color>

    <Index>3</Index>

    <RGB>#E6E6E6</RGB>

   </Color>

   <Color>

    <Index>6</Index>

    <RGB>#CCCCFF</RGB>

   </Color>

   <Color>

    <Index>16</Index>

    <RGB>#9999CC</RGB>

   </Color>

   <Color>

    <Index>30</Index>

    <RGB>#009900</RGB>

   </Color>

   <Color>

    <Index>49</Index>

    <RGB>#FFFFCC</RGB>

   </Color>

  </Colors>

 </OfficeDocumentSettings>

 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">

  <WindowHeight>9120</WindowHeight>

  <WindowWidth>12120</WindowWidth>

  <WindowTopX>360</WindowTopX>

  <WindowTopY>255</WindowTopY>

  <ProtectStructure>False</ProtectStructure>

  <ProtectWindows>False</ProtectWindows>

 </ExcelWorkbook>

 <Styles>

  <Style ss:ID="Default" ss:Name="Normal">

   <Alignment ss:Vertical="Bottom"/>

   <Borders/>

   <Font/>

   <Interior/>

   <NumberFormat/>

   <Protection/>

  </Style>

  <Style ss:ID="m28325212">

   <Alignment ss:Horizontal="Center" ss:Vertical="Top"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3"/>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>

    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

   </Borders>

   <Font x:Family="Swiss" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s23">

   <Font x:Family="Swiss" ss:Size="12" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s24">

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s25">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s26">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Font x:Family="Swiss" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="&quot;$&quot;#,##0"/>

  </Style>

  <Style ss:ID="s27">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Borders/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s28">

   <Borders/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s29">

   <Borders/>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s30">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Borders/>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s31">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Borders/>

   <Font x:Family="Swiss" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="&quot;$&quot;#,##0"/>

  </Style>

  <Style ss:ID="s32">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s33">

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s34">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Borders/>

   <Font x:Family="Swiss" ss:Color="#FF0000"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s35">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="0.00_);[Red]\(0.00\)"/>

  </Style>

  <Style ss:ID="s36">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Borders/>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="0.00_);[Red]\(0.00\)"/>

  </Style>

  <Style ss:ID="s37">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Borders/>

   <Font x:Family="Swiss" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s38">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Borders/>

   <Font x:Family="Swiss" ss:Color="#0000FF" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s39">

   <Borders/>

   <Font x:Family="Swiss" ss:Size="11" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s40">

   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>

   <Borders/>

   <Font x:Family="Swiss" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s41">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Borders/>

   <Font x:Family="Swiss" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="0%"/>

  </Style>

  <Style ss:ID="s42">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Borders/>

   <Font x:Family="Swiss" ss:Italic="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="0%"/>

  </Style>

  <Style ss:ID="s43">

   <Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>

   <Font x:Family="Swiss" ss:Size="11" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s44">

   <Font x:Family="Swiss" ss:Size="11" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s45">

   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>

   </Borders>

   <Font x:Family="Swiss" ss:Size="11" ss:Bold="1"/>

   <Interior ss:Color="#E6E6E6" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s46">

   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Left" ss:LineStyle="Dash" ss:Weight="1"/>

    <Border ss:Position="Right" ss:LineStyle="Dash" ss:Weight="1"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>

   </Borders>

   <Font x:Family="Swiss" ss:Size="11" ss:Bold="1"/>

   <Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="&quot;$&quot;#,##0"/>

  </Style>

  <Style ss:ID="s47">

   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Left" ss:LineStyle="Dash" ss:Weight="1"/>

    <Border ss:Position="Right" ss:LineStyle="Dash" ss:Weight="1"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>

   </Borders>

   <Font x:Family="Swiss" ss:Size="11" ss:Bold="1"/>

   <Interior ss:Color="#969696" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s48">

   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Left" ss:LineStyle="Dash" ss:Weight="1"/>

    <Border ss:Position="Right" ss:LineStyle="Dash" ss:Weight="1"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>

   </Borders>

   <Font x:Family="Swiss" ss:Size="11" ss:Bold="1"/>

   <Interior ss:Color="#CCCCFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s49">

   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>

   </Borders>

   <Font x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" ss:Bold="1"/>

   <Interior ss:Color="#666699" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="&quot;$&quot;#,##0"/>

  </Style>

  <Style ss:ID="s50">

   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>

   </Borders>

   <Font x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" ss:Bold="1"/>

   <Interior ss:Color="#333399" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s51">

   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Left" ss:LineStyle="Dot" ss:Weight="1" ss:Color="#FFFFFF"/>

    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>

   </Borders>

   <Font x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" ss:Bold="1"/>

   <Interior ss:Color="#333399" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s52">

   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>

   </Borders>

   <Font x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" ss:Bold="1"/>

   <Interior ss:Color="#333399" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="&quot;$&quot;#,##0"/>

  </Style>

  <Style ss:ID="s53">

   <Alignment ss:Horizontal="Center" ss:Vertical="Center"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="2"/>

   </Borders>

   <Font x:Family="Swiss" ss:Size="11" ss:Color="#FFFFFF" ss:Bold="1"/>

   <Interior ss:Color="#333399" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s54">

   <Alignment ss:Vertical="Top"/>

   <Borders/>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s55">

   <Alignment ss:Horizontal="Center" ss:Vertical="Top"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

   </Borders>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="0"/>

  </Style>

  <Style ss:ID="s56">

   <Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Dash" ss:Weight="1"/>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

   </Borders>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="0"/>

  </Style>

  <Style ss:ID="s57">

   <Alignment ss:Horizontal="Center" ss:Vertical="Top"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s58">

   <Alignment ss:Vertical="Top"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s59">

   <Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Dash" ss:Weight="1"/>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>

    <Border ss:Position="Top" ss:LineStyle="Dash" ss:Weight="1"/>

   </Borders>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="0"/>

  </Style>

  <Style ss:ID="s60">

   <Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>

   <Borders>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>

    <Border ss:Position="Top" ss:LineStyle="Dash" ss:Weight="1"/>

   </Borders>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="0"/>

  </Style>

  <Style ss:ID="s61">

   <Alignment ss:Vertical="Top"/>

   <Borders/>

   <Font x:Family="Swiss" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s62">

   <Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3"/>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

   </Borders>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s63">

   <Alignment ss:Horizontal="Center" ss:Vertical="Top"/>

   <Font x:Family="Swiss" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s64">

   <Alignment ss:Vertical="Top"/>

   <Font x:Family="Swiss" ss:Bold="1"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

  </Style>

  <Style ss:ID="s65">

   <Font x:Family="Swiss"/>

   <Interior/>

  </Style>

  <Style ss:ID="s66">

   <Alignment ss:Horizontal="Right" ss:Vertical="Top"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

   </Borders>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="Currency"/>

  </Style>

  <Style ss:ID="s67">

   <Alignment ss:Horizontal="Right" ss:Vertical="Top"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3"/>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

   </Borders>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="Currency"/>

  </Style>

  <Style ss:ID="s68">

   <Alignment ss:Horizontal="Right" ss:Vertical="Top"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

   </Borders>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="Currency"/>

  </Style>

  <Style ss:ID="s69">

   <Alignment ss:Horizontal="Right" ss:Vertical="Top"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3"/>

    <Border ss:Position="Left" ss:LineStyle="Dash" ss:Weight="1"/>

    <Border ss:Position="Right" ss:LineStyle="Dash" ss:Weight="1"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

   </Borders>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="Currency"/>

  </Style>

  <Style ss:ID="s70">

   <Alignment ss:Horizontal="Right" ss:Vertical="Top"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Double" ss:Weight="3"/>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

   </Borders>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#C0C0C0" ss:Pattern="Solid"/>

   <NumberFormat ss:Format="Currency"/>

  </Style>

  <Style ss:ID="s71">

   <Alignment ss:Horizontal="Left" ss:Vertical="Top"/>

   <Borders>

    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>

    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="2"/>

    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

   </Borders>

   <Font x:Family="Swiss"/>

   <Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>

   <NumberFormat/>

  </Style>

  <Style ss:ID="s72">

   <Alignment ss:Horizontal="Left" ss:Vertical="Top"/>

   <Borders>