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>

    <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"/>

  </Style>

  <Style ss:ID="s73">

   <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="Top" ss:LineStyle="Continuous" ss:Weight="1"/>

   </Borders>

   <Font x:Family="Swiss"/>

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

   <NumberFormat ss:Format="Currency"/>

  </Style>

  <Style ss:ID="s74">

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

   <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="1"/>

   </Borders>

   <Font x:Family="Swiss"/>

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

   <NumberFormat ss:Format="Currency"/>

  </Style>

  <Style ss:ID="s75">

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

   <Borders>

    <Border ss:Position="Bottom" 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="Currency"/>

  </Style>

  <Style ss:ID="s76">

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

   <Borders>

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

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

   </Borders>

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

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

   <NumberFormat ss:Format="Currency"/>

  </Style>

  <Style ss:ID="s77">

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

   <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="1"/>

   </Borders>

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

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

   <NumberFormat ss:Format="Currency"/>

  </Style>

  <Style ss:ID="s78">

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

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

  </Style>

  <Style ss:ID="s79">

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

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

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

   <NumberFormat ss:Format="Short Date"/>

  </Style>

 </Styles>

 <Worksheet ss:Name="Aged Accounts Receivable">

  <Names>

   <NamedRange ss:Name="Print_Area"

    ss:RefersTo="='Aged Accounts Receivable'!R1C1:R28C10"/>

  </Names>

  <Table ss:ExpandedColumnCount="14" ss:ExpandedRowCount="801" x:FullColumns="1"

   x:FullRows="1" ss:StyleID="s24">

   <Column ss:StyleID="s24" ss:AutoFitWidth="0" ss:Width="26.25"/>

   <Column ss:StyleID="s24" ss:AutoFitWidth="0" ss:Width="202.5"/>

   <Column ss:StyleID="s25" ss:AutoFitWidth="0" ss:Width="103.5"/>

   <Column ss:StyleID="s25" ss:AutoFitWidth="0" ss:Width="69.75" ss:Span="1"/>

   <Column ss:Index="6" ss:StyleID="s35" ss:AutoFitWidth="0" ss:Width="69.75"/>

   <Column ss:StyleID="s25" ss:AutoFitWidth="0" ss:Width="69.75"/>

   <Column ss:StyleID="s26" ss:AutoFitWidth="0" ss:Width="69.75"/>

   <Column ss:StyleID="s25" ss:AutoFitWidth="0" ss:Width="69.75"/>

   <Column ss:StyleID="s25" ss:AutoFitWidth="0" ss:Width="183"/>

   <Column ss:StyleID="s25" ss:AutoFitWidth="0" ss:Width="75"/>

   <Column ss:StyleID="s25" ss:AutoFitWidth="0"/>

   <Column ss:StyleID="s25" ss:AutoFitWidth="0" ss:Width="129"/>

   <Column ss:StyleID="s24" ss:AutoFitWidth="0" ss:Width="12.75"/>

   <Row ss:Height="15.75">

    <Cell ss:Index="2" ss:StyleID="s78"><ss:Data ss:Type="String"

      xmlns="http://www.w3.org/TR/REC-html40"><B>.:company_name:.</B><Font></Font></ss:Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s32"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s32"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s32"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:Index="7" ss:StyleID="s32"><NamedCell ss:Name="Print_Area"/></Cell>

   </Row>

   <Row ss:Height="15.75">

    <Cell ss:Index="2" ss:StyleID="s23"><Data ss:Type="String">Aged Accounts Receivable Report</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s30"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s30"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s32"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:Index="7" ss:StyleID="s32"><NamedCell ss:Name="Print_Area"/></Cell>

   </Row>

   <Row ss:Height="15.75">

    <Cell ss:Index="2" ss:StyleID="s79"><ss:Data ss:Type="String"

      xmlns="http://www.w3.org/TR/REC-html40"><B>.:date:.</B><Font></Font></ss:Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s30"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s30"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s32"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:Index="7" ss:StyleID="s32"><NamedCell ss:Name="Print_Area"/></Cell>

   </Row>

   <Row ss:AutoFitHeight="0" ss:Height="13.5">

    <Cell ss:StyleID="s23"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s33"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s30"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s30"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s32"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:Index="7" ss:StyleID="s32"><NamedCell ss:Name="Print_Area"/></Cell>

   </Row>

   <Row ss:AutoFitHeight="0" ss:Height="13.5">

    <Cell ss:StyleID="s29"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s65"><Data ss:Type="String">Gray cells will be calculated for you.</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s30"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s30"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s32"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:Index="7" ss:StyleID="s32"><NamedCell ss:Name="Print_Area"/></Cell>

   </Row>

   <Row ss:AutoFitHeight="0" ss:Height="13.5" ss:StyleID="s28">

    <Cell ss:StyleID="s29"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s29"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s30"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s30"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s30"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s36"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s30"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s31"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s27"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s27"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s27"/>

    <Cell ss:StyleID="s27"/>

    <Cell ss:StyleID="s27"/>

   </Row>

   <Row ss:AutoFitHeight="0" ss:Height="30" ss:StyleID="s44">

    <Cell ss:StyleID="s39"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s50"><Data ss:Type="String">Customer name</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s51"><Data ss:Type="String">Allocated days &#10;to pay</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s45"><Data ss:Type="String">0 to 30 days</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s46"><ss:Data ss:Type="String"

      xmlns="http://www.w3.org/TR/REC-html40"><B>31 to 60 days</B></ss:Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s47"><ss:Data ss:Type="String"

      xmlns="http://www.w3.org/TR/REC-html40"><B>61 to 90 days</B></ss:Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s48"><ss:Data ss:Type="String"

      xmlns="http://www.w3.org/TR/REC-html40"><B>91 to 120 days</B></ss:Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s49"><Data ss:Type="String">121+ days</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s52"><Data ss:Type="String">Customer totals</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s53"><Data ss:Type="String">Notes</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s43"/>

    <Cell ss:StyleID="s43"/>

    <Cell ss:StyleID="s43"/>

    <Cell ss:StyleID="s43"/>

   </Row>

   <!-- Repeating rows -->

::row 

   <Row ss:AutoFitHeight="0" ss:Height="25.5" ss:StyleID="s58">

    <Cell ss:StyleID="s54"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s71"><Data ss:Type="String">.:CSTNAM:.</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s55"><Data ss:Type="Number">.:ALCDYPY:.</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s73"><Data ss:Type="Number">.:DY0TO30:.</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s74"><Data ss:Type="Number">.:DY31TO60:.</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s74"><Data ss:Type="Number">.:DY61TO90:.</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s74"><Data ss:Type="Number">.:DY91TO120:.</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s75"><Data ss:Type="Number">.:DY120:.</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s66" ss:Formula="=SUM(RC[-5]:RC[-1])"><Data ss:Type="Number">0</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s56"><Data ss:Type="String">.:NOTES:.</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s57"/>

    <Cell ss:StyleID="s57"/>

    <Cell ss:StyleID="s57"/>

    <Cell ss:StyleID="s57"/>

   </Row>  

::doc_end 

   <Row ss:AutoFitHeight="0" ss:Height="15" ss:StyleID="s64">

    <Cell ss:StyleID="s61"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:MergeAcross="1" ss:StyleID="m28325212"><Data ss:Type="String">TOTALS</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s70" ss:Formula="=SUM(R[-.:total_sum:.]C:R[-1]C)"><Data ss:Type="Number">0</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s69" ss:Formula="=SUM(R[-.:total_sum:.]C:R[-1]C)"><Data ss:Type="Number">0</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s69" ss:Formula="=SUM(R[-.:total_sum:.]C:R[-1]C)"><Data ss:Type="Number">0</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s69" ss:Formula="=SUM(R[-.:total_sum:.]C:R[-1]C)"><Data ss:Type="Number">0</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s68" ss:Formula="=SUM(R[-.:total_sum:.]C:R[-1]C)"><Data ss:Type="Number">0</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s67" ss:Formula="=SUM(R[-.:total_sum:.]C:R[-1]C)"><Data ss:Type="Number">0</Data><NamedCell

      ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s62"><NamedCell ss:Name="Print_Area"/></Cell>

    <Cell ss:StyleID="s63"/>

    <Cell ss:StyleID="s63"/>

    <Cell ss:StyleID="s63"/>

    <Cell ss:StyleID="s63"/>

   </Row>

  </Table>

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

   <PageSetup>

    <Layout x:Orientation="Landscape" x:CenterHorizontal="1"/>

    <Header x:Margin="0.46"/>

    <PageMargins x:Bottom="0.53" x:Left="0.39" x:Right="0.64" x:Top="0.47"/>

   </PageSetup>

   <FitToPage/>

   <Print>

    <FitHeight>2</FitHeight>

    <ValidPrinterInfo/>

    <Scale>72</Scale>

    <HorizontalResolution>300</HorizontalResolution>

    <VerticalResolution>300</VerticalResolution>

   </Print>

   <TabColorIndex>11</TabColorIndex>

   <PageBreakZoom>60</PageBreakZoom>

   <Selected/>

   <LeftColumnVisible>3</LeftColumnVisible>

   <Panes>

    <Pane>

     <Number>3</Number>

     <ActiveRow>26</ActiveRow>

     <ActiveCol>9</ActiveCol>

    </Pane>

   </Panes>

   <ProtectObjects>False</ProtectObjects>

   <ProtectScenarios>False</ProtectScenarios>

  </WorksheetOptions>

 </Worksheet>

</Workbook>