Liren Large Software Subsidy 5/05.iso/a/a044/3.ddi/CARET/MONEY.RET

Text File | 1993-08-31 | 6.7 KB | 93 lines

{\rtf1\ansi
{\*\demo}
{\fonttbl{\f0\fswiss Arial;}{\f1\fswiss Helvetica;}}
{\colortbl\red0\green0\blue0;\red128\green0\blue0;\red0\green128\blue0;\red128\green128\blue0;\red0\green0\blue128;\red128\green0\blue128;\red0\green128\blue128;\red128\green128\blue128;\red192\green192\blue192;\red255\green0\blue0;\red0\green255\blue0;\red255\green255\blue0;\red0\green0\blue255;\red255\green0\blue255;\red0\green255\blue255;}
{\info{\author CA-RET}{\title Report title}}
{\*\vrwvern1}
\paperw12240 \paperh15840 \margl2700 \margr2610 \margt720 \margb720
{\*\vrwcol table1{\col0 0 90 180}{\col1 270 1170 180}{\col2 1620 1530 180}{\col3 3330 1170 180}{\col4 4680 900 180}{\col5 5760 1080 180}}
{\*\vrwcol table2{\col0 0 2250 180}{\col1 2430 1620 180}{\col2 4230 2700 180}}
{\*\ctrcol}
\sectd \linex0 \pard
{\*\vrwvar {\v0 TYPEOFDEP\colnum1\colnam TYPEOFDEP\len26\txt}
{\v1 BRANCH\colnum2\colnam BRANCH\len21\txt}
{\v2 LENDER\colnum3\colnam LENDER\len13\txt}
{\v3 DATE\colnum4\colnam DATE\len8\dat}
{\v4 YIELD\colnum5\colnam YIELD\len8\flt}
{\v5 PRINCIPAL\colnum6\colnam PRINCIPAL\len8\flt}
{\v6 DISCOUNT\colnum7\colnam DISCOUNT\len8\flt}
{\v7 value\exp .01*DISCOUNT*PRINCIPAL\flt}
{\v8 field2\txt}
{\v9 pct_of_type\exp PercentOfTotal( Sum( value, TYPEOFDEP), REPORT )\flt}
{\v10 PctofBranch\exp PERCENTOFTOTAL(SUM(VALUE,2),REPORT)\flt}
{\v11 tot_type_of_dep\exp sum( value, typeofdep )\flt}
{\v12 field6\txt}
{\v13 field7\txt}
{\v14 field8\txt}
{\v15 tot_of_branch\exp Sum( value, 2 )\flt}
{\v16 grand_total\exp Sum( value, REPORT )\flt}
{\v17 average\exp AVERAGE(VALUE,TYPEOFDEP)\flt}
{\v18 NumIssues\exp COUNT(TYPEOFDEP)\txt}
{\v19 CNT\exp RUNNINGCOUNT(REPORT)\txt}
{\v20 cur_yield\exp YIELD*PRINCIPAL/(VALUE)\flt}
{\v21 _date\exp SystemDate()\dat}
{\v22 _pagenumber\exp PageNumber()\int}
{\v23 Port_curr_yield\exp (SUM(YIELD*PRINCIPAL,REPORT)/(SUM(VALUE,REPORT)*100))\flt}
{\v24 portfolio_yield\exp Sum(YIELD*PRINCIPAL,REPORT)/(Sum(value,REPORT)*100)\flt}
{\v25 branch_pct_of_dep\exp PercentOfTotal( Sum( VALUE, BRANCH ), TYPEOFDEP )\flt}
{\v26 branchtotprin\exp SUM(PRINCIPAL,BRANCH)\flt}
{\*\vrwqry \qrynam QUERY1\inptyp3 {\*\qrytbl samples\caret\MONEY.DBF}
{\*\qrycol TYPEOFDEP 0 }
{\*\qrycol BRANCH 0 }
{\*\qrycol LENDER 0 }
{\*\qrycol DATE 0 }
{\*\qrycol YIELD 0 }
{\*\qrycol PRINCIPAL 0 }
{\*\qrycol DISCOUNT 0 }
{\*\qryord TYPEOFDEP 0 0 }
{\*\qryord BRANCH 0 0 }
{\*\qryord LENDER 0 0 }
{\*\qryord DATE 0 0 }
{\map TYPEOFDEP\mapcol TYPEOFDEP\maptbl MONEY\mapnum1}
{\map BRANCH\mapcol BRANCH\maptbl MONEY\mapnum2}
{\map LENDER\mapcol LENDER\maptbl MONEY\mapnum3}
{\map DATE\mapcol DATE\maptbl MONEY\mapnum4}
{\map YIELD\mapcol YIELD\maptbl MONEY\mapnum5}
{\map PRINCIPAL\mapcol PRINCIPAL\maptbl MONEY\mapnum6}
{\map DISCOUNT\mapcol DISCOUNT\maptbl MONEY\mapnum7}
}
{\*\vrwsct {\BCK15840 \nstlev1 }
\pard\plain\ql \par\pard\plain\ql \par\pard\plain\ql \par\pard\plain\ql \par\pard\plain\ql
{\*\vrwsct {\PHD1368 \keptgr \txthgt \nstlev1 }
\pard\plain\qc {\cf12\f0\fs36 Sparticus Money Market Fund }{\*\brdwid43}\brdrt\brdrs\brdrw43\par\pard\plain\qc {\cf12\f0\fs36 Portfolio}\par\pard\plain\qc {\cf12\i\f0\fs28 {\*\varref _date\pic Mmmm,yyyy }}{\*\brdwid43}\brdrb\brdrs\brdrw43\par\pard\plain\qc {\i\f0\fs12  }
{\*\vrwgrf {\vrwbmp 0 180 907 1087 SAMPLES\\CARET\\COLUMN.BMP}}
{\*\vrwsct {\RHD480 \keptgr \txthgt \nstlev1 }
\pard\plain\trowd \trgaph90\trleft-90\cellx2340\cellx4140\cellx7020
{\*\vrwcoldef2}
\intbl \ql {\f0\fs20 Current portfolio value: }\cell\pard\plain\intbl \qr {\b\f0\fs20 {\*\varref grand_total\pic $#,##0;($#,##0) }}\cell\pard\plain\intbl \ql \cell\pard\plain\row
\pard \intbl \ql {\f0\fs20 Current portfolio yield:}\cell\pard\plain\intbl \qr {\b\f0\fs20 {\*\varref portfolio_yield\pic 0.00% }}\cell\pard\plain\intbl \ql \cell\row
{\*\vrwsct {\GHD1202 \keptgr \txthgt \rptbrk \nstlev1 {\grpvbllst TYPEOFDEP}}
\pard\plain\ql \par\pard\plain\trowd \trgaph90\trleft-90\cellx2340\cellx4140\cellx7020
{\*\vrwcoldef2}
\intbl \ql {\b\f0\fs20 {\*\varref TYPEOFDEP\trmblk}}\cell\pard\plain\intbl \qr {\b\f0\fs20 {\*\varref tot_type_of_dep\pic $#,##0 }}\cell\pard\plain\intbl \ql {\f0\fs20 (}{\f0\fs20 {\*\varref pct_of_type\pic 0.00% }}{\f0\fs20  of total assets)}\cell\pard\plain\row
\pard \ql \par\pard\plain\trowd \trgaph90\trleft-90\cellx180\cellx1530\cellx3240\cellx4590\cellx5670\cellx6930
{\*\vrwcoldef1}
\intbl \qc {\b\f0\fs20  }{\*\brdwid20}\brdrt\brdrs\brdrw20\par\pard\plain\intbl \qc {\*\brdwid20}\brdrb\brdrs\brdrw20\cell\pard\plain\intbl \ql {\cf12\b\f0\fs20 Issuer &}{\*\brdwid20}\brdrt\brdrs\brdrw20\par\pard\plain\intbl \ql {\cf12\b\f0\fs20  Due Date}{\*\brdwid20}\brdrb\brdrs\brdrw20\cell\pard\plain\intbl \qr {\cf12\b\f0\fs20 Principal Amount}{\*\brdwid20}\brdrt\brdrb\brdrs\brdrw20\cell\pard\plain\intbl \ql {\cf12\b\f0\fs20  }{\*\brdwid20}\brdrt\brdrs\brdrw20\par\pard\plain\intbl \qr {\cf12\b\f0\fs20 Value}{\*\brdwid20}\brdrb\brdrs\brdrw20\cell\pard\plain\intbl \qr {\cf12\b\f0\fs20 Current Yield}{\*\brdwid20}\brdrt\brdrb\brdrs\brdrw20\cell\pard\plain\intbl \qr {\cf12\b\f0\fs20 Annualized Yield}{\*\brdwid20}\brdrt\brdrb\brdrs\brdrw20\cell\row
{\*\vrwsct {\GHD422 \keptgr \txthgt \rptbrk \nstlev2 {\grpvbllst BRANCH}}
\pard\plain\ql {\i\f0\fs16  }\par\pard\plain\ql {\i\f0\fs20 {\*\varref BRANCH\trmblk}}{\i\f0\fs20  Branch: }{\i\f0\fs20 {\*\varref branch_pct_of_dep\pic 0.00% }}
{\*\vrwsct {\GHD231 \keptgr \txthgt \rptbrk \nstlev3 {\grpvbllst LENDER}}
\pard\plain\trowd \trgaph90\trleft-90\cellx180\cellx1530\cellx3240\cellx4590\cellx5670\cellx6930
{\*\vrwcoldef1}
\intbl \ql \cell\pard\plain\intbl \ql {\f0\fs18 {\*\varref LENDER\trmblk}}\cell\pard\plain\intbl \ql \cell\pard\plain\intbl \ql \cell\pard\plain\intbl \ql \cell\pard\plain\intbl \ql \cell\row
{\*\vrwsct {\BDY211 \unllst \keptgr \txthgt \nstlev1 }
\pard\plain\intbl \qr \cell\pard\plain\intbl \ql {\f0\fs18     }{\f0\fs18 {\*\varref DATE\pic d-Mmm-yy \trmblk}}\cell\pard\plain\intbl \qr {\f0\fs18  }{\f0\fs18 {\*\varref PRINCIPAL\pic #,##0 }}\cell\pard\plain\intbl \qr {\f0\fs18  }{\f0\fs18 {\*\varref value\pic #,##0 }}\cell\pard\plain\intbl \qr {\f0\fs18 {\*\varref cur_yield\pic 0.00 \trmblk}}\cell\pard\plain\intbl \qr {\f0\fs18 {\*\varref YIELD\pic 0.00 }}\cell\row
{\*\vrwsct {\GFT211 \keptgr \txthgt \nstlev2 {\grpvbllst BRANCH}}
\pard\plain\intbl \ql \cell\pard\plain\intbl \ql \cell\pard\plain\intbl \qr \cell\pard\plain\intbl \qr {\f0\fs18 {\*\varref tot_of_branch\pic $#,##0 \trmblk}}\cell\pard\plain\intbl \qr \cell\pard\plain\intbl \ql \cell\row
{\*\vrwsct {\GFT231 \keptgr \txthgt \nstlev1 {\grpvbllst TYPEOFDEP}}
\pard\plain\ql {\f0\fs20  }
{\*\vrwsct {\RFT182 \txthgt \nstlev1 }
\pard\plain\ql {\f0\fs12  }{\*\brdwid43}\brdrt\brdrb\brdrs\brdrw43
{\*\vrwsct {\PFT231 \txthgt \nstlev1 }
\pard\plain\qc {\f0\fs20 Page }{\f0\fs20 {\*\varref _pagenumber}}
}