[Libreoffice-commits] core.git: 12 commits - scaddins/source

Caolán McNamara caolanm at redhat.com
Tue Feb 14 16:47:01 UTC 2017


 scaddins/source/analysis/analysis.cxx              |   38 
 scaddins/source/analysis/analysis.hrc              |    8 
 scaddins/source/analysis/analysis.src              | 4630 +++++----------------
 scaddins/source/analysis/analysis_deffuncnames.src | 1212 ++---
 scaddins/source/analysis/analysis_funcnames.src    | 1009 ++--
 scaddins/source/analysis/analysishelper.cxx        |   27 
 scaddins/source/analysis/analysishelper.hxx        |   18 
 scaddins/source/datefunc/datefunc.cxx              |   30 
 scaddins/source/datefunc/datefunc.hrc              |   10 
 scaddins/source/datefunc/datefunc.hxx              |   48 
 scaddins/source/datefunc/datefunc.src              |  362 -
 scaddins/source/pricing/pricing.cxx                |   30 
 scaddins/source/pricing/pricing.hrc                |   10 
 scaddins/source/pricing/pricing.hxx                |   49 
 scaddins/source/pricing/pricing.src                |  519 --
 15 files changed, 2576 insertions(+), 5424 deletions(-)

New commits:
commit 5401ccd65d295092a740ca1c01604bbca2c9eca4
Author: Caolán McNamara <caolanm at redhat.com>
Date:   Tue Feb 14 16:26:11 2017 +0000

    unwind RID_ANALYSIS_DEFFUNCTION_NAMES local resource
    
    Change-Id: I65ce69460b6c5f73fd41345f55630d0fcf5c04a4

diff --git a/scaddins/source/analysis/analysis.hrc b/scaddins/source/analysis/analysis.hrc
index 57688f7..ac29f83 100644
--- a/scaddins/source/analysis/analysis.hrc
+++ b/scaddins/source/analysis/analysis.hrc
@@ -21,8 +21,6 @@
 
 #define ANALYSIS_RESOURCE_START             1000
 
-#define RID_ANALYSIS_DEFFUNCTION_NAMES      (ANALYSIS_RESOURCE_START+3000)
-
 #define ANALYSIS_FUNCDESC_START             (ANALYSIS_RESOURCE_START)
 
 #define ANALYSIS_Workday                    (ANALYSIS_FUNCDESC_START)
@@ -231,7 +229,7 @@
 #define ANALYSIS_FUNCNAME_Imsech            (ANALYSIS_FUNCNAME_START+99)
 #define ANALYSIS_FUNCNAME_Imcsch            (ANALYSIS_FUNCNAME_START+100)
 
-#define ANALYSIS_DEFFUNCNAME_START          (RID_ANALYSIS_DEFFUNCTION_NAMES+1)
+#define ANALYSIS_DEFFUNCNAME_START          (ANALYSIS_RESOURCE_START+3000)
 
 #define ANALYSIS_DEFFUNCNAME_Workday        (ANALYSIS_DEFFUNCNAME_START)
 #define ANALYSIS_DEFFUNCNAME_Yearfrac       (ANALYSIS_DEFFUNCNAME_START+1)
diff --git a/scaddins/source/analysis/analysis_deffuncnames.src b/scaddins/source/analysis/analysis_deffuncnames.src
index 54a09f1..152932e 100644
--- a/scaddins/source/analysis/analysis_deffuncnames.src
+++ b/scaddins/source/analysis/analysis_deffuncnames.src
@@ -19,916 +19,912 @@
 
 #include "analysis.hrc"
 
-Resource RID_ANALYSIS_DEFFUNCTION_NAMES
+StringArray ANALYSIS_DEFFUNCNAME_Workday
 {
-
-    StringArray ANALYSIS_DEFFUNCNAME_Workday
+    ItemList =
     {
-        ItemList =
-        {
-            < "ARBEITSTAG"; >;
-            < "WORKDAY"; >;
-        };
+        < "ARBEITSTAG"; >;
+        < "WORKDAY"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Yearfrac
+StringArray ANALYSIS_DEFFUNCNAME_Yearfrac
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "BRTEILJAHRE"; >;
-            < "YEARFRAC"; >;
-        };
+        < "BRTEILJAHRE"; >;
+        < "YEARFRAC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Edate
+StringArray ANALYSIS_DEFFUNCNAME_Edate
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "EDATUM"; >;
-            < "EDATE"; >;
-        };
+        < "EDATUM"; >;
+        < "EDATE"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Weeknum
+StringArray ANALYSIS_DEFFUNCNAME_Weeknum
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "KALENDERWOCHE"; >;
-            < "WEEKNUM"; >;
-        };
+        < "KALENDERWOCHE"; >;
+        < "WEEKNUM"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Eomonth
+StringArray ANALYSIS_DEFFUNCNAME_Eomonth
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "MONATSENDE"; >;
-            < "EOMONTH"; >;
-        };
+        < "MONATSENDE"; >;
+        < "EOMONTH"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Networkdays
+StringArray ANALYSIS_DEFFUNCNAME_Networkdays
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "NETTOARBEITSTAGE"; >;
-            < "NETWORKDAYS"; >;
-        };
+        < "NETTOARBEITSTAGE"; >;
+        < "NETWORKDAYS"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Amordegrc
+StringArray ANALYSIS_DEFFUNCNAME_Amordegrc
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "AMORDEGRK"; >;
-            < "AMORDEGRC"; >;
-        };
+        < "AMORDEGRK"; >;
+        < "AMORDEGRC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Amorlinc
+StringArray ANALYSIS_DEFFUNCNAME_Amorlinc
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "AMORLINEARK"; >;
-            < "AMORLINC"; >;
-        };
+        < "AMORLINEARK"; >;
+        < "AMORLINC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Accrint
+StringArray ANALYSIS_DEFFUNCNAME_Accrint
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "AUFGELZINS"; >;
-            < "ACCRINT"; >;
-        };
+        < "AUFGELZINS"; >;
+        < "ACCRINT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Accrintm
+StringArray ANALYSIS_DEFFUNCNAME_Accrintm
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "AUFGELZINSF"; >;
-            < "ACCRINTM"; >;
-        };
+        < "AUFGELZINSF"; >;
+        < "ACCRINTM"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Received
+StringArray ANALYSIS_DEFFUNCNAME_Received
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "AUSZAHLUNG"; >;
-            < "RECEIVED"; >;
-        };
+        < "AUSZAHLUNG"; >;
+        < "RECEIVED"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Disc
+StringArray ANALYSIS_DEFFUNCNAME_Disc
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "DISAGIO"; >;
-            < "DISC"; >;
-        };
+        < "DISAGIO"; >;
+        < "DISC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Duration
+StringArray ANALYSIS_DEFFUNCNAME_Duration
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "DURATION"; >;
-            < "DURATION"; >;
-        };
+        < "DURATION"; >;
+        < "DURATION"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Effect
+StringArray ANALYSIS_DEFFUNCNAME_Effect
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "EFFEKTIV"; >;
-            < "EFFECT"; >;
-        };
+        < "EFFEKTIV"; >;
+        < "EFFECT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Cumprinc
+StringArray ANALYSIS_DEFFUNCNAME_Cumprinc
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "KUMKAPITAL"; >;
-            < "CUMPRINC"; >;
-        };
+        < "KUMKAPITAL"; >;
+        < "CUMPRINC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Cumipmt
+StringArray ANALYSIS_DEFFUNCNAME_Cumipmt
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "KUMZINSZ"; >;
-            < "CUMIPMT"; >;
-        };
+        < "KUMZINSZ"; >;
+        < "CUMIPMT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Price
+StringArray ANALYSIS_DEFFUNCNAME_Price
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "KURS"; >;
-            < "PRICE"; >;
-        };
+        < "KURS"; >;
+        < "PRICE"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Pricedisc
+StringArray ANALYSIS_DEFFUNCNAME_Pricedisc
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "KURSDISAGIO"; >;
-            < "PRICEDISC"; >;
-        };
+        < "KURSDISAGIO"; >;
+        < "PRICEDISC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Pricemat
+StringArray ANALYSIS_DEFFUNCNAME_Pricemat
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "KURSFÄLLIG"; >;
-            < "PRICEMAT"; >;
-        };
+        < "KURSFÄLLIG"; >;
+        < "PRICEMAT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Mduration
+StringArray ANALYSIS_DEFFUNCNAME_Mduration
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "MDURATION"; >;
-            < "MDURATION"; >;
-        };
+        < "MDURATION"; >;
+        < "MDURATION"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Nominal
+StringArray ANALYSIS_DEFFUNCNAME_Nominal
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "NOMINAL"; >;
-            < "NOMINAL"; >;
-        };
+        < "NOMINAL"; >;
+        < "NOMINAL"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Dollarfr
+StringArray ANALYSIS_DEFFUNCNAME_Dollarfr
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "NOTIERUNGBRU"; >;
-            < "DOLLARFR"; >;
-        };
+        < "NOTIERUNGBRU"; >;
+        < "DOLLARFR"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Dollarde
+StringArray ANALYSIS_DEFFUNCNAME_Dollarde
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "NOTIERUNGDEZ"; >;
-            < "DOLLARDE"; >;
-        };
+        < "NOTIERUNGDEZ"; >;
+        < "DOLLARDE"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Yield
+StringArray ANALYSIS_DEFFUNCNAME_Yield
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "RENDITE"; >;
-            < "YIELD"; >;
-        };
+        < "RENDITE"; >;
+        < "YIELD"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Yielddisc
+StringArray ANALYSIS_DEFFUNCNAME_Yielddisc
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "RENDITEDIS"; >;
-            < "YIELDDISC"; >;
-        };
+        < "RENDITEDIS"; >;
+        < "YIELDDISC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Yieldmat
+StringArray ANALYSIS_DEFFUNCNAME_Yieldmat
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "RENDITEFÄLL"; >;
-            < "YIELDMAT"; >;
-        };
+        < "RENDITEFÄLL"; >;
+        < "YIELDMAT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Tbilleq
+StringArray ANALYSIS_DEFFUNCNAME_Tbilleq
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "TBILLÄQUIV"; >;
-            < "TBILLEQ"; >;
-        };
+        < "TBILLÄQUIV"; >;
+        < "TBILLEQ"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Tbillprice
+StringArray ANALYSIS_DEFFUNCNAME_Tbillprice
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "TBILLKURS"; >;
-            < "TBILLPRICE"; >;
-        };
+        < "TBILLKURS"; >;
+        < "TBILLPRICE"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Tbillyield
+StringArray ANALYSIS_DEFFUNCNAME_Tbillyield
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "TBILLRENDITE"; >;
-            < "TBILLYIELD"; >;
-        };
+        < "TBILLRENDITE"; >;
+        < "TBILLYIELD"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Oddfprice
+StringArray ANALYSIS_DEFFUNCNAME_Oddfprice
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "UNREGER.KURS"; >;
-            < "ODDFPRICE"; >;
-        };
+        < "UNREGER.KURS"; >;
+        < "ODDFPRICE"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Oddfyield
+StringArray ANALYSIS_DEFFUNCNAME_Oddfyield
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "UNREGER.REND"; >;
-            < "ODDFYIELD"; >;
-        };
+        < "UNREGER.REND"; >;
+        < "ODDFYIELD"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Oddlprice
+StringArray ANALYSIS_DEFFUNCNAME_Oddlprice
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "UNREGLE.KURS"; >;
-            < "ODDLPRICE"; >;
-        };
+        < "UNREGLE.KURS"; >;
+        < "ODDLPRICE"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Oddlyield
+StringArray ANALYSIS_DEFFUNCNAME_Oddlyield
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "UNREGLE.REND"; >;
-            < "ODDLYIELD"; >;
-        };
+        < "UNREGLE.REND"; >;
+        < "ODDLYIELD"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Xirr
+StringArray ANALYSIS_DEFFUNCNAME_Xirr
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "XINTZINSFUSS"; >;
-            < "XIRR"; >;
-        };
+        < "XINTZINSFUSS"; >;
+        < "XIRR"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Xnpv
+StringArray ANALYSIS_DEFFUNCNAME_Xnpv
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "XKAPITALWERT"; >;
-            < "XNPV"; >;
-        };
+        < "XKAPITALWERT"; >;
+        < "XNPV"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Intrate
+StringArray ANALYSIS_DEFFUNCNAME_Intrate
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "ZINSSATZ"; >;
-            < "INTRATE"; >;
-        };
+        < "ZINSSATZ"; >;
+        < "INTRATE"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Coupncd
+StringArray ANALYSIS_DEFFUNCNAME_Coupncd
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "ZINSTERMNZ"; >;
-            < "COUPNCD"; >;
-        };
+        < "ZINSTERMNZ"; >;
+        < "COUPNCD"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Coupdays
+StringArray ANALYSIS_DEFFUNCNAME_Coupdays
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "ZINSTERMTAGE"; >;
-            < "COUPDAYS"; >;
-        };
+        < "ZINSTERMTAGE"; >;
+        < "COUPDAYS"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Coupdaysnc
+StringArray ANALYSIS_DEFFUNCNAME_Coupdaysnc
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "ZINSTERMTAGNZ"; >;
-            < "COUPDAYSNC"; >;
-        };
+        < "ZINSTERMTAGNZ"; >;
+        < "COUPDAYSNC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Coupdaybs
+StringArray ANALYSIS_DEFFUNCNAME_Coupdaybs
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "ZINSTERMTAGVA"; >;
-            < "COUPDAYBS"; >;
-        };
+        < "ZINSTERMTAGVA"; >;
+        < "COUPDAYBS"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Couppcd
+StringArray ANALYSIS_DEFFUNCNAME_Couppcd
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "ZINSTERMVZ"; >;
-            < "COUPPCD"; >;
-        };
+        < "ZINSTERMVZ"; >;
+        < "COUPPCD"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Coupnum
+StringArray ANALYSIS_DEFFUNCNAME_Coupnum
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "ZINSTERMZAHL"; >;
-            < "COUPNUM"; >;
-        };
+        < "ZINSTERMZAHL"; >;
+        < "COUPNUM"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Fvschedule
+StringArray ANALYSIS_DEFFUNCNAME_Fvschedule
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "ZW2"; >;
-            < "FVSCHEDULE"; >;
-        };
+        < "ZW2"; >;
+        < "FVSCHEDULE"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Iseven
+StringArray ANALYSIS_DEFFUNCNAME_Iseven
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "ISTGERADE"; >;
-            < "ISEVEN"; >;
-        };
+        < "ISTGERADE"; >;
+        < "ISEVEN"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Isodd
+StringArray ANALYSIS_DEFFUNCNAME_Isodd
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "ISTUNGERADE"; >;
-            < "ISODD"; >;
-        };
+        < "ISTUNGERADE"; >;
+        < "ISODD"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Gcd
+StringArray ANALYSIS_DEFFUNCNAME_Gcd
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "GGT"; >;
-            < "GCD"; >;
-        };
+        < "GGT"; >;
+        < "GCD"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Lcm
+StringArray ANALYSIS_DEFFUNCNAME_Lcm
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "KGV"; >;
-            < "LCM"; >;
-        };
+        < "KGV"; >;
+        < "LCM"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Multinomial
+StringArray ANALYSIS_DEFFUNCNAME_Multinomial
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "POLYNOMIAL"; >;
-            < "MULTINOMIAL"; >;
-        };
+        < "POLYNOMIAL"; >;
+        < "MULTINOMIAL"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Seriessum
+StringArray ANALYSIS_DEFFUNCNAME_Seriessum
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "POTENZREIHE"; >;
-            < "SERIESSUM"; >;
-        };
+        < "POTENZREIHE"; >;
+        < "SERIESSUM"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Quotient
+StringArray ANALYSIS_DEFFUNCNAME_Quotient
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "QUOTIENT"; >;
-            < "QUOTIENT"; >;
-        };
+        < "QUOTIENT"; >;
+        < "QUOTIENT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Mround
+StringArray ANALYSIS_DEFFUNCNAME_Mround
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "VRUNDEN"; >;
-            < "MROUND"; >;
-        };
+        < "VRUNDEN"; >;
+        < "MROUND"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Sqrtpi
+StringArray ANALYSIS_DEFFUNCNAME_Sqrtpi
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "WURZELPI"; >;
-            < "SQRTPI"; >;
-        };
+        < "WURZELPI"; >;
+        < "SQRTPI"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Randbetween
+StringArray ANALYSIS_DEFFUNCNAME_Randbetween
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "ZUFALLSBEREICH"; >;
-            < "RANDBETWEEN"; >;
-        };
+        < "ZUFALLSBEREICH"; >;
+        < "RANDBETWEEN"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Besseli
+StringArray ANALYSIS_DEFFUNCNAME_Besseli
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "BESSELI"; >;
-            < "BESSELI"; >;
-        };
+        < "BESSELI"; >;
+        < "BESSELI"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Besselj
+StringArray ANALYSIS_DEFFUNCNAME_Besselj
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "BESSELJ"; >;
-            < "BESSELJ"; >;
-        };
+        < "BESSELJ"; >;
+        < "BESSELJ"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Besselk
+StringArray ANALYSIS_DEFFUNCNAME_Besselk
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "BESSELK"; >;
-            < "BESSELK"; >;
-        };
+        < "BESSELK"; >;
+        < "BESSELK"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Bessely
+StringArray ANALYSIS_DEFFUNCNAME_Bessely
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "BESSELY"; >;
-            < "BESSELY"; >;
-        };
+        < "BESSELY"; >;
+        < "BESSELY"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Bin2Dec
+StringArray ANALYSIS_DEFFUNCNAME_Bin2Dec
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "BININDEZ"; >;
-            < "BIN2DEC"; >;
-        };
+        < "BININDEZ"; >;
+        < "BIN2DEC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Bin2Hex
+StringArray ANALYSIS_DEFFUNCNAME_Bin2Hex
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "BININHEX"; >;
-            < "BIN2HEX"; >;
-        };
+        < "BININHEX"; >;
+        < "BIN2HEX"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Bin2Oct
+StringArray ANALYSIS_DEFFUNCNAME_Bin2Oct
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "BININOKT"; >;
-            < "BIN2OCT"; >;
-        };
+        < "BININOKT"; >;
+        < "BIN2OCT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Delta
+StringArray ANALYSIS_DEFFUNCNAME_Delta
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "DELTA"; >;
-            < "DELTA"; >;
-        };
+        < "DELTA"; >;
+        < "DELTA"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Dec2Bin
+StringArray ANALYSIS_DEFFUNCNAME_Dec2Bin
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "DEZINBIN"; >;
-            < "DEC2BIN"; >;
-        };
+        < "DEZINBIN"; >;
+        < "DEC2BIN"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Dec2Hex
+StringArray ANALYSIS_DEFFUNCNAME_Dec2Hex
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "DEZINHEX"; >;
-            < "DEC2HEX"; >;
-        };
+        < "DEZINHEX"; >;
+        < "DEC2HEX"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Dec2Oct
+StringArray ANALYSIS_DEFFUNCNAME_Dec2Oct
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "DEZINOKT"; >;
-            < "DEC2OCT"; >;
-        };
+        < "DEZINOKT"; >;
+        < "DEC2OCT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Erf
+StringArray ANALYSIS_DEFFUNCNAME_Erf
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "GAUSSFEHLER"; >;
-            < "ERF"; >;
-        };
+        < "GAUSSFEHLER"; >;
+        < "ERF"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Erfc
+StringArray ANALYSIS_DEFFUNCNAME_Erfc
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "GAUSSFKOMPL"; >;
-            < "ERFC"; >;
-        };
+        < "GAUSSFKOMPL"; >;
+        < "ERFC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Gestep
+StringArray ANALYSIS_DEFFUNCNAME_Gestep
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "GGANZZAHL"; >;
-            < "GESTEP"; >;
-        };
+        < "GGANZZAHL"; >;
+        < "GESTEP"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Hex2Bin
+StringArray ANALYSIS_DEFFUNCNAME_Hex2Bin
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "HEXINBIN"; >;
-            < "HEX2BIN"; >;
-        };
+        < "HEXINBIN"; >;
+        < "HEX2BIN"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Hex2Dec
+StringArray ANALYSIS_DEFFUNCNAME_Hex2Dec
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "HEXINDEZ"; >;
-            < "HEX2DEC"; >;
-        };
+        < "HEXINDEZ"; >;
+        < "HEX2DEC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Hex2Oct
+StringArray ANALYSIS_DEFFUNCNAME_Hex2Oct
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "HEXINOKT"; >;
-            < "HEX2OCT"; >;
-        };
+        < "HEXINOKT"; >;
+        < "HEX2OCT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imabs
+StringArray ANALYSIS_DEFFUNCNAME_Imabs
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMABS"; >;
-            < "IMABS"; >;
-        };
+        < "IMABS"; >;
+        < "IMABS"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imaginary
+StringArray ANALYSIS_DEFFUNCNAME_Imaginary
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMAGINÄRTEIL"; >;
-            < "IMAGINARY"; >;
-        };
+        < "IMAGINÄRTEIL"; >;
+        < "IMAGINARY"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Impower
+StringArray ANALYSIS_DEFFUNCNAME_Impower
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMAPOTENZ"; >;
-            < "IMPOWER"; >;
-        };
+        < "IMAPOTENZ"; >;
+        < "IMPOWER"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imargument
+StringArray ANALYSIS_DEFFUNCNAME_Imargument
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMARGUMENT"; >;
-            < "IMARGUMENT"; >;
-        };
+        < "IMARGUMENT"; >;
+        < "IMARGUMENT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imcos
+StringArray ANALYSIS_DEFFUNCNAME_Imcos
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMCOS"; >;
-            < "IMCOS"; >;
-        };
+        < "IMCOS"; >;
+        < "IMCOS"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imdiv
+StringArray ANALYSIS_DEFFUNCNAME_Imdiv
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMDIV"; >;
-            < "IMDIV"; >;
-        };
+        < "IMDIV"; >;
+        < "IMDIV"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imexp
+StringArray ANALYSIS_DEFFUNCNAME_Imexp
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMEXP"; >;
-            < "IMEXP"; >;
-        };
+        < "IMEXP"; >;
+        < "IMEXP"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imconjugate
+StringArray ANALYSIS_DEFFUNCNAME_Imconjugate
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMKONJUGIERTE"; >;
-            < "IMCONJUGATE"; >;
-        };
+        < "IMKONJUGIERTE"; >;
+        < "IMCONJUGATE"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imln
+StringArray ANALYSIS_DEFFUNCNAME_Imln
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMLN"; >;
-            < "IMLN"; >;
-        };
+        < "IMLN"; >;
+        < "IMLN"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imlog10
+StringArray ANALYSIS_DEFFUNCNAME_Imlog10
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMLOG10"; >;
-            < "IMLOG10"; >;
-        };
+        < "IMLOG10"; >;
+        < "IMLOG10"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imlog2
+StringArray ANALYSIS_DEFFUNCNAME_Imlog2
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMLOG2"; >;
-            < "IMLOG2"; >;
-        };
+        < "IMLOG2"; >;
+        < "IMLOG2"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Improduct
+StringArray ANALYSIS_DEFFUNCNAME_Improduct
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMPRODUKT"; >;
-            < "IMPRODUCT"; >;
-        };
+        < "IMPRODUKT"; >;
+        < "IMPRODUCT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imreal
+StringArray ANALYSIS_DEFFUNCNAME_Imreal
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMREALTEIL"; >;
-            < "IMREAL"; >;
-        };
+        < "IMREALTEIL"; >;
+        < "IMREAL"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imsin
+StringArray ANALYSIS_DEFFUNCNAME_Imsin
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMSIN"; >;
-            < "IMSIN"; >;
-        };
+        < "IMSIN"; >;
+        < "IMSIN"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imsub
+StringArray ANALYSIS_DEFFUNCNAME_Imsub
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMSUB"; >;
-            < "IMSUB"; >;
-        };
+        < "IMSUB"; >;
+        < "IMSUB"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imsum
+StringArray ANALYSIS_DEFFUNCNAME_Imsum
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMSUMME"; >;
-            < "IMSUM"; >;
-        };
+        < "IMSUMME"; >;
+        < "IMSUM"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imsqrt
+StringArray ANALYSIS_DEFFUNCNAME_Imsqrt
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMWURZEL"; >;
-            < "IMSQRT"; >;
-        };
+        < "IMWURZEL"; >;
+        < "IMSQRT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imtan
+StringArray ANALYSIS_DEFFUNCNAME_Imtan
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMTAN"; >;
-            < "IMTAN"; >;
-        };
+        < "IMTAN"; >;
+        < "IMTAN"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imsec
+StringArray ANALYSIS_DEFFUNCNAME_Imsec
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMSEC"; >;
-            < "IMSEC"; >;
-        };
+        < "IMSEC"; >;
+        < "IMSEC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imcsc
+StringArray ANALYSIS_DEFFUNCNAME_Imcsc
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMCSC"; >;
-            < "IMCSC"; >;
-        };
+        < "IMCSC"; >;
+        < "IMCSC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imcot
+StringArray ANALYSIS_DEFFUNCNAME_Imcot
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMCOT"; >;
-            < "IMCOT"; >;
-        };
+        < "IMCOT"; >;
+        < "IMCOT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imsinh
+StringArray ANALYSIS_DEFFUNCNAME_Imsinh
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMSINH"; >;
-            < "IMSINH"; >;
-        };
+        < "IMSINH"; >;
+        < "IMSINH"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imcosh
+StringArray ANALYSIS_DEFFUNCNAME_Imcosh
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMCOSH"; >;
-            < "IMCOSH"; >;
-        };
+        < "IMCOSH"; >;
+        < "IMCOSH"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imsech
+StringArray ANALYSIS_DEFFUNCNAME_Imsech
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMSECH"; >;
-            < "IMSECH"; >;
-        };
+        < "IMSECH"; >;
+        < "IMSECH"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Imcsch
+StringArray ANALYSIS_DEFFUNCNAME_Imcsch
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "IMCSCH"; >;
-            < "IMCSCH"; >;
-        };
+        < "IMCSCH"; >;
+        < "IMCSCH"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Complex
+StringArray ANALYSIS_DEFFUNCNAME_Complex
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "KOMPLEXE"; >;
-            < "COMPLEX"; >;
-        };
+        < "KOMPLEXE"; >;
+        < "COMPLEX"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Oct2Bin
+StringArray ANALYSIS_DEFFUNCNAME_Oct2Bin
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "OKTINBIN"; >;
-            < "OCT2BIN"; >;
-        };
+        < "OKTINBIN"; >;
+        < "OCT2BIN"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Oct2Dec
+StringArray ANALYSIS_DEFFUNCNAME_Oct2Dec
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "OKTINDEZ"; >;
-            < "OCT2DEC"; >;
-        };
+        < "OKTINDEZ"; >;
+        < "OCT2DEC"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Oct2Hex
+StringArray ANALYSIS_DEFFUNCNAME_Oct2Hex
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "OKTINHEX"; >;
-            < "OCT2HEX"; >;
-        };
+        < "OKTINHEX"; >;
+        < "OCT2HEX"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Convert
+StringArray ANALYSIS_DEFFUNCNAME_Convert
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "UMWANDELN"; >;
-            < "CONVERT"; >;
-        };
+        < "UMWANDELN"; >;
+        < "CONVERT"; >;
     };
+};
 
-    StringArray ANALYSIS_DEFFUNCNAME_Factdouble
+StringArray ANALYSIS_DEFFUNCNAME_Factdouble
+{
+    ItemList =
     {
-        ItemList =
-        {
-            < "ZWEIFAKULTÄT"; >;
-            < "FACTDOUBLE"; >;
-        };
+        < "ZWEIFAKULTÄT"; >;
+        < "FACTDOUBLE"; >;
     };
 };
 
diff --git a/scaddins/source/analysis/analysishelper.cxx b/scaddins/source/analysis/analysishelper.cxx
index b6e7aea..886a833 100644
--- a/scaddins/source/analysis/analysishelper.cxx
+++ b/scaddins/source/analysis/analysishelper.cxx
@@ -1372,22 +1372,6 @@ double GetCoupnum( sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, sal_I
     return static_cast< double >( nMonths * nFreq / 12 );
 }
 
-
-class AnalysisRscStrArrLoader : public Resource
-{
-private:
-    ResStringArray          aStrArray;
-public:
-                            AnalysisRscStrArrLoader( sal_uInt16 nRsc, sal_uInt16 nArrayId, ResMgr& rResMgr ) :
-                                Resource( AnalysisResId( nRsc, rResMgr ) ),
-                                aStrArray( AnalysisResId( nArrayId, rResMgr ) )
-                            {
-                                FreeResource();
-                            }
-
-    const ResStringArray&   GetStringArray() const { return aStrArray; }
-};
-
 FuncData::FuncData( const FuncDataBase& r, ResMgr& rResMgr ) :
     aIntName( OUString::createFromAscii( r.pIntName ) ),
     nUINameID( r.nUINameID ),
@@ -1400,14 +1384,13 @@ FuncData::FuncData( const FuncDataBase& r, ResMgr& rResMgr ) :
     if (r.pSuffix)
         aSuffix = OUString::createFromAscii( r.pSuffix);
 
-    AnalysisRscStrArrLoader aArrLoader(RID_ANALYSIS_DEFFUNCTION_NAMES, r.nCompListID, rResMgr);
-    const ResStringArray&   rArr = aArrLoader.GetStringArray();
+    ResStringArray aArr(AnalysisResId(r.nCompListID, rResMgr));
 
-    sal_uInt16              nCount = sal::static_int_cast<sal_uInt16>( rArr.Count() );
+    sal_uInt32 nCount = aArr.Count();
 
-    aCompList.resize( nCount );
-    for( sal_uInt16 n = 0 ; n < nCount ; n++ )
-        aCompList[n] = rArr.GetString( n );
+    aCompList.resize(nCount);
+    for(sal_uInt32 n = 0 ; n < nCount; ++n)
+        aCompList[n] = aArr.GetString( n );
 }
 
 FuncData::~FuncData()
commit 288ca353a84d383690a6923b9b1d1d0b3cfe3a7c
Author: Caolán McNamara <caolanm at redhat.com>
Date:   Tue Feb 14 16:13:29 2017 +0000

    covert ANALYSIS_* resources to StringArrays
    
    Change-Id: Id0aba9531ef179102f62c4f89fa65a244c975570

diff --git a/scaddins/source/analysis/analysis.cxx b/scaddins/source/analysis/analysis.cxx
index b13eed9..8c41ba1 100644
--- a/scaddins/source/analysis/analysis.cxx
+++ b/scaddins/source/analysis/analysis.cxx
@@ -30,6 +30,7 @@
 #include <rtl/math.hxx>
 #include <sal/macros.h>
 #include <string.h>
+#include <tools/resary.hxx>
 #include <tools/resmgr.hxx>
 #include <tools/rcid.h>
 #include <algorithm>
@@ -79,27 +80,10 @@ ResMgr& AnalysisAddIn::GetResMgr()
     return *pResMgr;
 }
 
-class AnalysisFuncRes : public Resource
-{
-public:
-    AnalysisFuncRes( ResId& rRes, ResMgr& rResMgr, sal_uInt16 nInd, OUString& rRet );
-};
-
-AnalysisFuncRes::AnalysisFuncRes( ResId& rRes, ResMgr& rResMgr, sal_uInt16 nInd, OUString& rRet ) : Resource( rRes )
-{
-    rRet = AnalysisResId(nInd, rResMgr).toString();
-
-    FreeResource();
-}
-
 OUString AnalysisAddIn::GetFuncDescrStr( sal_uInt16 nResId, sal_uInt16 nStrIndex )
 {
-    OUString                      aRet;
-    AnalysisResId               aRes( nResId, GetResMgr() );
-    aRes.SetRT( RSC_RESOURCE );
-    AnalysisFuncRes aSubRes( aRes, GetResMgr(), nStrIndex, aRet );
-
-    return aRet;
+    ResStringArray aArr(AnalysisResId(nResId, GetResMgr()));
+    return aArr.GetString(nStrIndex - 1);
 }
 
 void AnalysisAddIn::InitData()
diff --git a/scaddins/source/analysis/analysis.src b/scaddins/source/analysis/analysis.src
index b101888..14d15b9 100644
--- a/scaddins/source/analysis/analysis.src
+++ b/scaddins/source/analysis/analysis.src
@@ -19,3682 +19,1385 @@
 
 #include "analysis.hrc"
 
-Resource ANALYSIS_Workday
+StringArray ANALYSIS_Workday
 {
-    String 1    // description Workday
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns the serial number of the date before or after a specified number of workdays";
-    };
-
-    String 2 // name of parameter 1         Workday
-    {
-        Text [ en-US ] = "Start date";
-    };
-
-    String 3 // description of parameter 1  Workday
-    {
-        Text [ en-US ] = "The start date";
-    };
-
-    String 4 // name of parameter 2         Workday
-    {
-        Text [ en-US ] = "Days";
-    };
-
-    String 5 // description of parameter 2  Workday
-    {
-        Text [ en-US ] = "The number of workdays before or after the start date";
-    };
-
-    String 6 // name of parameter 3         Workday
-    {
-        Text [ en-US ] = "Holidays";
-    };
-
-    String 7 // description of parameter 3  Workday
-    {
-        Text [ en-US ] = "List of date values of days off (vacation, holidays, etc.)";
+        < "Returns the serial number of the date before or after a specified number of workdays"; > ;
+        < "Start date"; > ;
+        < "The start date"; > ;
+        < "Days"; > ;
+        < "The number of workdays before or after the start date"; > ;
+        < "Holidays"; > ;
+        < "List of date values of days off (vacation, holidays, etc.)"; > ;
     };
 };
 
-Resource ANALYSIS_Yearfrac
+StringArray ANALYSIS_Yearfrac
 {
-    String 1    // description Yearfrac
-    {
-        Text [ en-US ] = "Returns the number of years (including fractional part) between two dates";
-    };
-
-    String 2 // name of parameter 1         Yearfrac
-    {
-        Text [ en-US ] = "Start date";
-    };
-
-    String 3 // description of parameter 1  Yearfrac
-    {
-        Text [ en-US ] = "The start date";
-    };
-
-    String 4 // name of parameter 2         Yearfrac
-    {
-        Text [ en-US ] = "End date";
-    };
-
-    String 5 // description of parameter 2  Yearfrac
-    {
-        Text [ en-US ] = "The end date";
-    };
-
-    String 6 // name of parameter 3         Yearfrac
-    {
-        Text [ en-US ] = "Basis";
-    };
-
-    String 7 // description of parameter 3  Yearfrac
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Basis indicates the day-count convention to use in the calculation";
+        < "Returns the number of years (including fractional part) between two dates"; > ;
+        < "Start date"; > ;
+        < "The start date"; > ;
+        < "End date"; > ;
+        < "The end date"; > ;
+        < "Basis"; > ;
+        < "Basis indicates the day-count convention to use in the calculation"; > ;
     };
 };
 
-Resource ANALYSIS_Edate
+StringArray ANALYSIS_Edate
 {
-    String 1    // description Edate
-    {
-        Text [ en-US ] = "Returns the serial number of the date that is a specified number of months before or after the start date";
-    };
-
-    String 2 // name of parameter 1         Edate
-    {
-        Text [ en-US ] = "Start date";
-    };
-
-    String 3 // description of parameter 1  Edate
-    {
-        Text [ en-US ] = "The start date";
-    };
-
-    String 4 // name of parameter 2         Edate
-    {
-        Text [ en-US ] = "Months";
-    };
-
-    String 5 // description of parameter 2  Edate
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number of months before or after the start date";
+        < "Returns the serial number of the date that is a specified number of months before or after the start date"; > ;
+        < "Start date"; > ;
+        < "The start date"; > ;
+        < "Months"; > ;
+        < "Number of months before or after the start date"; > ;
     };
 };
 
-Resource ANALYSIS_Weeknum
+StringArray ANALYSIS_Weeknum
 {
-    String 1    // description Weeknum_Excel2003
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns the number of the calendar week in which the specified date occurs.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use WEEKNUM instead.";
-    };
-
-    String 2 // name of parameter 1         Weeknum_Excel2003
-    {
-        Text [ en-US ] = "Date";
-    };
-
-    String 3 // description of parameter 1  Weeknum_Excel2003
-    {
-        Text [ en-US ] = "The date or date serial number";
-    };
-
-    String 4 // name of parameter 2         Weeknum_Excel2003
-    {
-        Text [ en-US ] = "Return type";
-    };
-
-    String 5 // description of parameter 2  Weeknum_Excel2003
-    {
-        Text [ en-US ] = "Indicates the first day of the week (1 = Sunday, 2 = Monday)";
+        < "Returns the number of the calendar week in which the specified date occurs.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use WEEKNUM instead."; > ;
+        < "Date"; > ;
+        < "The date or date serial number"; > ;
+        < "Return type"; > ;
+        < "Indicates the first day of the week (1 = Sunday, 2 = Monday)"; > ;
     };
 };
 
-Resource ANALYSIS_Eomonth
+StringArray ANALYSIS_Eomonth
 {
-    String 1    // description EoMonth
-    {
-        Text[ en-US ] = "Returns the serial number of the last day of the month that comes a certain number of months before or after the start date";
-    };
-
-    String 2 // name of parameter 1         EoMonth
-    {
-        Text [ en-US ] = "Start date";
-    };
-
-    String 3 // description of parameter 1  EoMonth
-    {
-        Text [ en-US ] = "The start date";
-    };
-
-    String 4 // name of parameter 2         EoMonth
-    {
-        Text [ en-US ] = "Months";
-    };
-
-    String 5 // description of parameter 2  EoMonth
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number of months before or after the start date";
+        < "Returns the serial number of the last day of the month that comes a certain number of months before or after the start date"; > ;
+        < "Start date"; > ;
+        < "The start date"; > ;
+        < "Months"; > ;
+        < "Number of months before or after the start date"; > ;
     };
 };
 
-Resource ANALYSIS_Networkdays
+StringArray ANALYSIS_Networkdays
 {
-    String 1    // description Networkdays_Excel2003
-    {
-        Text [ en-US ] = "Returns the number of workdays between two dates.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use NETWORKDAYS instead.";
-    };
-
-    String 2 // name of parameter 1         Networkdays_Excel2003
-    {
-        Text [ en-US ] = "Start date";
-    };
-
-    String 3 // description of parameter 1  Networkdays_Excel2003
-    {
-        Text [ en-US ] = "The start date";
-    };
-
-    String 4 // name of parameter 2         Networkdays_Excel2003
-    {
-        Text [ en-US ] = "End date";
-    };
-
-    String 5 // description of parameter 2  Networkdays_Excel2003
-    {
-        Text [ en-US ] = "The end date";
-    };
-
-    String 6 // name of parameter 3         Networkdays_Excel2003
-    {
-        Text [ en-US ] = "Holidays";
-    };
-
-    String 7 // description of parameter 3  Networkdays_Excel2003
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "List of date values representing days off (vacation, holidays, etc.)";
+        < "Returns the number of workdays between two dates.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use NETWORKDAYS instead."; > ;
+        < "Start date"; > ;
+        < "The start date"; > ;
+        < "End date"; > ;
+        < "The end date"; > ;
+        < "Holidays"; > ;
+        < "List of date values representing days off (vacation, holidays, etc.)"; > ;
     };
 };
 
-Resource ANALYSIS_Iseven
+StringArray ANALYSIS_Iseven
 {
-    String 1    // description Iseven_add
-    {
-        Text [ en-US ] = "Returns the value 'true' if the number is even";
-    };
-
-    String 2 // name of parameter 1         Iseven_add
-    {
-        Text [ en-US ] = "Number";
-    };
-
-    String 3 // description of parameter 1  Iseven_add
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The number";
+        < "Returns the value 'true' if the number is even"; > ;
+        < "Number"; > ;
+        < "The number"; > ;
     };
 };
 
-Resource ANALYSIS_Isodd
+StringArray ANALYSIS_Isodd
 {
-    String 1    // description Isodd_add
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns the value 'true' if the number is odd";
-    };
-
-    String 2 // name of parameter 1         Isodd_add
-    {
-        Text [ en-US ] = "Number";
-    };
-
-    String 3 // description of parameter 1  Isodd_add
-    {
-        Text [ en-US ] = "The number";
+        < "Returns the value 'true' if the number is odd"; > ;
+        < "Number"; > ;
+        < "The number"; > ;
     };
 };
 
-Resource ANALYSIS_Multinomial
+StringArray ANALYSIS_Multinomial
 {
-    String 1    // description Multinomial
-    {
-        Text [ en-US ] = "Returns the multinomial coefficient of a set of numbers";
-    };
-
-    String 2 // name of parameter 1         Multinomial
-    {
-        Text [ en-US ] = "Number";
-    };
-
-    String 3 // description of parameter 1  Multinomial
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number or list of numbers for which you want the multinomial coefficient";
+        < "Returns the multinomial coefficient of a set of numbers"; > ;
+        < "Number"; > ;
+        < "Number or list of numbers for which you want the multinomial coefficient"; > ;
     };
 };
 
-Resource ANALYSIS_Seriessum
+StringArray ANALYSIS_Seriessum
 {
-    String 1    // description Seriessum
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns the sum of a power series";
+        < "Returns the sum of a power series"; > ;
+        < "X"; > ;
+        < "The independent variable of the power series"; > ;
+        < "N"; > ;
+        < "The initial power to which x is to be raised"; > ;
+        < "M"; > ;
+        < "The increment by which to increase n for each term in the series"; > ;
+        < "Coefficients"; > ;
+        < "Set of coefficients by which each successive power of the variable x is multiplied"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Seriessum
+StringArray ANALYSIS_Quotient
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "X";
+        < "Returns the integer portion of a division"; > ;
+        < "Numerator"; > ;
+        < "The dividend"; > ;
+        < "Denominator"; > ;
+        < "The divisor"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Seriessum
+StringArray ANALYSIS_Mround
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The independent variable of the power series";
+        < "Returns a number rounded to a specified multiple"; > ;
+        < "Number"; > ;
+        < "The number to round off"; > ;
+        < "Multiple"; > ;
+        < "The multiple to which you want to round number"; > ;
     };
+};
 
-    String 4 // name of parameter 2         Seriessum
+StringArray ANALYSIS_Sqrtpi
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "N";
+        < "Returns the square root of a number which has been multiplied by pi"; > ;
+        < "Number"; > ;
+        < "The number by which pi is multiplied"; > ;
     };
+};
 
-    String 5 // description of parameter 2  Seriessum
+StringArray ANALYSIS_Randbetween
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The initial power to which x is to be raised";
+        < "Returns a random integer between the numbers you specify"; > ;
+        < "Bottom"; > ;
+        < "The smallest integer returned"; > ;
+        < "Top"; > ;
+        < "The largest integer returned"; > ;
     };
+};
 
-    String 6 // name of parameter 3         Seriessum
+StringArray ANALYSIS_Gcd
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "M";
+        < "Returns the greatest common divisor.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use GCD instead."; > ;
+        < "Number"; > ;
+        < "Number or list of numbers"; > ;
     };
+};
 
-    String 7 // description of parameter 3  Seriessum
+StringArray ANALYSIS_Lcm
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The increment by which to increase n for each term in the series";
+        < "Returns the least common multiple.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use LCM instead."; > ;
+        < "Number"; > ;
+        < "Number or list of numbers"; > ;
     };
+};
 
-    String 8 // name of parameter 4         Seriessum
+StringArray ANALYSIS_Besseli
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Coefficients";
+        < "Returns the modified Bessel function In(x)"; > ;
+        < "X"; > ;
+        < "The value at which the function is to be evaluated"; > ;
+        < "N"; > ;
+        < "The order of the Bessel function"; > ;
     };
+};
 
-    String 9 // description of parameter 4  Seriessum
+StringArray ANALYSIS_Besselj
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Set of coefficients by which each successive power of the variable x is multiplied";
+        < "Returns the Bessel function Jn(x)"; > ;
+        < "X"; > ;
+        < "The value at which the function is to be evaluated"; > ;
+        < "N"; > ;
+        < "The order of the Bessel function"; > ;
     };
 };
 
-Resource ANALYSIS_Quotient
+StringArray ANALYSIS_Besselk
 {
-    String 1    // description Quotient
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns the integer portion of a division";
+        < "Returns the Bessel function Kn(x)"; > ;
+        < "X"; > ;
+        < "The value at which the function is to be evaluated"; > ;
+        < "N"; > ;
+        < "The order of the Bessel function"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Quotient
+StringArray ANALYSIS_Bessely
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Numerator";
+        < "Returns the Bessel function Yn(x)"; > ;
+        < "X"; > ;
+        < "The value at which the function is to be evaluated"; > ;
+        < "N"; > ;
+        < "The order of the Bessel function"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Quotient
+StringArray ANALYSIS_Bin2Oct
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The dividend";
+        < "Converts a binary number to an octal number"; > ;
+        < "Number"; > ;
+        < "The binary number to be converted (as text)"; > ;
+        < "Places"; > ;
+        < "Number of places used"; > ;
     };
+};
 
-    String 4 // name of parameter 2         Quotient
+StringArray ANALYSIS_Bin2Dec
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Denominator";
+        < "Converts a binary number to a decimal number"; > ;
+        < "Number"; > ;
+        < "The binary number to be converted (as text)"; > ;
     };
+};
 
-    String 5 // description of parameter 2  Quotient
+StringArray ANALYSIS_Bin2Hex
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The divisor";
+        < "Converts a binary number to a hexadecimal number"; > ;
+        < "Number"; > ;
+        < "The binary number to be converted (as text)"; > ;
+        < "Places"; > ;
+        < "Number of places used."; > ;
     };
 };
 
-Resource ANALYSIS_Mround
+StringArray ANALYSIS_Oct2Bin
 {
-    String 1    // description Mround
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns a number rounded to a specified multiple";
+        < "Converts an octal number to a binary number"; > ;
+        < "Number"; > ;
+        < "The octal number to be converted (as text)"; > ;
+        < "Places"; > ;
+        < "Number of places used"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Mround
+StringArray ANALYSIS_Oct2Dec
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number";
+        < "Converts an octal number to a decimal number"; > ;
+        < "Number"; > ;
+        < "The octal number to be converted (as text)"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Mround
+StringArray ANALYSIS_Oct2Hex
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The number to round off";
+        < "Converts an octal number to a hexadecimal number"; > ;
+        < "Number"; > ;
+        < "The octal number to be converted (as text)"; > ;
+        < "Places"; > ;
+        < "Number of places used"; > ;
     };
+};
 
-    String 4 // name of parameter 2         Mround
+StringArray ANALYSIS_Dec2Bin
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Multiple";
+        < "Converts a decimal number to a binary number"; > ;
+        < "Number"; > ;
+        < "The decimal integer to be converted"; > ;
+        < "Places"; > ;
+        < "Number of places used"; > ;
     };
+};
 
-    String 5 // description of parameter 2  Mround
+StringArray ANALYSIS_Dec2Hex
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The multiple to which you want to round number";
+        < "Converts a decimal number to a hexadecimal number"; > ;
+        < "Number"; > ;
+        < "The decimal integer to be converted"; > ;
+        < "Places"; > ;
+        < "Number of places used"; > ;
     };
 };
 
-Resource ANALYSIS_Sqrtpi
+StringArray ANALYSIS_Dec2Oct
 {
-    String 1    // description SqrtPI
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns the square root of a number which has been multiplied by pi";
+        < "Converts a decimal number into an octal number"; > ;
+        < "Number"; > ;
+        < "The decimal number"; > ;
+        < "Places"; > ;
+        < "Number of places used"; > ;
     };
+};
 
-    String 2 // name of parameter 1         SqrtPI
+StringArray ANALYSIS_Hex2Bin
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number";
+        < "Converts a hexadecimal number to a binary number"; > ;
+        < "Number"; > ;
+        < "The hexadecimal number to be converted (as text)"; > ;
+        < "Places"; > ;
+        < "Number of places used"; > ;
     };
+};
 
-    String 3 // description of parameter 1  SqrtPI
+StringArray ANALYSIS_Hex2Dec
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The number by which pi is multiplied";
+        < "Converts a hexadecimal number to a decimal number"; > ;
+        < "Number"; > ;
+        < "The hexadecimal number to be converted (as text)"; > ;
     };
 };
 
-Resource ANALYSIS_Randbetween
+StringArray ANALYSIS_Hex2Oct
 {
-    String 1    // description Randbetween
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns a random integer between the numbers you specify";
+        < "Converts a hexadecimal number to an octal number"; > ;
+        < "Number"; > ;
+        < "The hexadecimal number to be converted (as text)"; > ;
+        < "Places"; > ;
+        < "Number of places used"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Randbetween
+StringArray ANALYSIS_Delta
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Bottom";
+        < "Tests whether two values are equal"; > ;
+        < "Number 1"; > ;
+        < "The first number"; > ;
+        < "Number 2"; > ;
+        < "The second number"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Randbetween
+StringArray ANALYSIS_Erf
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The smallest integer returned";
+        < "Returns the error function"; > ;
+        < "Lower limit"; > ;
+        < "The lower limit for integration"; > ;
+        < "Upper limit"; > ;
+        < "The upper limit for integration"; > ;
     };
+};
 
-    String 4 // name of parameter 2         Randbetween
+StringArray ANALYSIS_Erfc
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Top";
+        < "Returns the complementary error function"; > ;
+        < "Lower limit"; > ;
+        < "The lower limit for integration"; > ;
     };
+};
 
-    String 5 // description of parameter 2  Randbetween
+StringArray ANALYSIS_Gestep
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The largest integer returned";
+        < "Tests whether a number is greater than a threshold value"; > ;
+        < "Number"; > ;
+        < "The value to test against step"; > ;
+        < "Step"; > ;
+        < "The threshold value"; > ;
     };
 };
 
-Resource ANALYSIS_Gcd
+StringArray ANALYSIS_Factdouble
 {
-    String 1    // description Gcd_Excel2003
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns the greatest common divisor.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use GCD instead.";
+        < "Returns the double factorial of Number"; > ;
+        < "Number"; > ;
+        < "The number"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Gcd_Excel2003
+StringArray ANALYSIS_Imabs
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number";
+        < "Returns the absolute value (modulus) of a complex number"; > ;
+        < "Complex number"; > ;
+        < "The complex number"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Gcd_Excel2003
+StringArray ANALYSIS_Imaginary
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number or list of numbers";
+        < "Returns the imaginary coefficient of a complex number"; > ;
+        < "Complex number"; > ;
+        < "The complex number"; > ;
     };
 };
 
-Resource ANALYSIS_Lcm
+StringArray ANALYSIS_Impower
 {
-    String 1    // description Lcm_Excel2003
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns the least common multiple.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use LCM instead.";
+        < "Returns a complex number raised to a real power"; > ;
+        < "Complex number"; > ;
+        < "The complex number"; > ;
+        < "Number"; > ;
+        < "Power to which the complex number is raised"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Lcm_Excel2003
+StringArray ANALYSIS_Imargument
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number";
+        < "Returns the argument theta, an angle expressed in radians"; > ;
+        < "Complex number"; > ;
+        < "A complex number"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Lcm_Excel2003
+StringArray ANALYSIS_Imcos
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number or list of numbers";
+        < "Returns the cosine of a complex number"; > ;
+        < "Complex number"; > ;
+        < "A complex number"; > ;
     };
 };
 
-Resource ANALYSIS_Besseli
+StringArray ANALYSIS_Imdiv
 {
-    String 1    // description BesselI
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns the modified Bessel function In(x)";
+        < "Returns the quotient of two complex numbers"; > ;
+        < "Numerator"; > ;
+        < "The dividend"; > ;
+        < "Denominator"; > ;
+        < "The divisor"; > ;
     };
+};
 
-    String 2 // name of parameter 1         BesselI
+StringArray ANALYSIS_Imexp
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "X";
+        < "Returns the algebraic form of the exponential of a complex number"; > ;
+        < "Complex number"; > ;
+        < "The complex number"; > ;
     };
+};
 
-    String 3 // description of parameter 1  BesselI
+StringArray ANALYSIS_Imconjugate
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The value at which the function is to be evaluated";
+        < "Returns the complex conjugate of a complex number"; > ;
+        < "Complex number"; > ;
+        < "The complex number"; > ;
     };
+};
 
-    String 4 // name of parameter 2         BesselI
+StringArray ANALYSIS_Imln
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "N";
+        < "Returns the natural logarithm of a complex number"; > ;
+        < "Complex number"; > ;
+        < "The complex number"; > ;
     };
+};
 
-    String 5 // description of parameter 2  BesselI
+StringArray ANALYSIS_Imlog10
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The order of the Bessel function";
+        < "Returns the base-10 logarithm of a complex number"; > ;
+        < "Complex number"; > ;
+        < "The complex number"; > ;
     };
 };
 
-Resource ANALYSIS_Besselj
+StringArray ANALYSIS_Imlog2
 {
-    String 1    // description BesselJ
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns the Bessel function Jn(x)";
+        < "Returns the base-2 logarithm of a complex number"; > ;
+        < "Complex number"; > ;
+        < "The complex number"; > ;
     };
+};
 
-    String 2 // name of parameter 1         BesselJ
+StringArray ANALYSIS_Improduct
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "X";
+        < "Returns the product of several complex numbers"; > ;
+        < "Complex number"; > ;
+        < "The first complex number"; > ;
+        < "Complex number"; > ;
+        < "Another complex number"; > ;
     };
+};
 
-    String 3 // description of parameter 1  BesselJ
+StringArray ANALYSIS_Imreal
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The value at which the function is to be evaluated";
+        < "Returns the real coefficient of a complex number"; > ;
+        < "Complex number"; > ;
+        < "The complex number"; > ;
     };
+};
 
-    String 4 // name of parameter 2         BesselJ
+StringArray ANALYSIS_Imsin
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "N";
+        < "Returns the sine of a complex number"; > ;
+        < "Complex number"; > ;
+        < "The complex number"; > ;
     };
+};
 
-    String 5 // description of parameter 2  BesselJ
+StringArray ANALYSIS_Imsub
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The order of the Bessel function";
+        < "Returns the difference of two complex numbers"; > ;
+        < "Complex number 1"; > ;
+        < "Complex number 1"; > ;
+        < "Complex number 2"; > ;
+        < "Complex number 2"; > ;
     };
 };
 
-Resource ANALYSIS_Besselk
+StringArray ANALYSIS_Imsqrt
 {
-    String 1    // description BesselK
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns the Bessel function Kn(x)";
+        < "Returns the square root of a complex number"; > ;
+        < "Complex number"; > ;
+        < "The complex number"; > ;
     };
+};
 
-    String 2 // name of parameter 1         BesselK
+StringArray ANALYSIS_Imsum
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "X";
+        < "Returns the sum of complex numbers"; > ;
+        < "Complex number"; > ;
+        < "The complex number"; > ;
     };
+};
 
-    String 3 // description of parameter 1  BesselK
+StringArray ANALYSIS_Imtan
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The value at which the function is to be evaluated";
+        < "Returns the tangent of a complex number"; > ;
+        < "Complex number"; > ;
+        < "A complex number"; > ;
     };
+};
 
-    String 4 // name of parameter 2         BesselK
+StringArray ANALYSIS_Imsec
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "N";
+        < "Returns the secant of a complex number"; > ;
+        < "Complex number"; > ;
+        < "A complex number"; > ;
     };
+};
 
-    String 5 // description of parameter 2  BesselK
+StringArray ANALYSIS_Imcsc
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The order of the Bessel function";
+        < "Returns the cosecant of a complex number"; > ;
+        < "Complex number"; > ;
+        < "A complex number"; > ;
     };
 };
 
-Resource ANALYSIS_Bessely
+StringArray ANALYSIS_Imcot
 {
-    String 1    // description BesselY
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Returns the Bessel function Yn(x)";
+        < "Returns the cotangent of a complex number"; > ;
+        < "Complex number"; > ;
+        < "A complex number"; > ;
     };
+};
 
-    String 2 // name of parameter 1         BesselY
+StringArray ANALYSIS_Imsinh
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "X";
+        < "Returns the hyperbolic sine of a complex number"; > ;
+        < "Complex number"; > ;
+        < "A complex number"; > ;
     };
+};
 
-    String 3 // description of parameter 1  BesselY
+StringArray ANALYSIS_Imcosh
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The value at which the function is to be evaluated";
+        < "Returns the hyperbolic cosine of a complex number"; > ;
+        < "Complex number"; > ;
+        < "A complex number"; > ;
     };
+};
 
-    String 4 // name of parameter 2         BesselY
+StringArray ANALYSIS_Imsech
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "N";
+        < "Returns the hyperbolic secant of a complex number"; > ;
+        < "Complex number"; > ;
+        < "A complex number"; > ;
     };
+};
 
-    String 5 // description of parameter 2  BesselY
+StringArray ANALYSIS_Imcsch
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The order of the Bessel function";
+        < "Returns the hyperbolic cosecant of a complex number"; > ;
+        < "Complex number"; > ;
+        < "A complex number"; > ;
     };
 };
 
-Resource ANALYSIS_Bin2Oct
+StringArray ANALYSIS_Complex
 {
-    String 1    // description Bin2Oct
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Converts a binary number to an octal number";
+        < "Converts real and imaginary coefficients into a complex number"; > ;
+        < "Real num"; > ;
+        < "The real coefficient"; > ;
+        < "I num"; > ;
+        < "The imaginary coefficient"; > ;
+        < "Suffix"; > ;
+        < "The suffix"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Bin2Oct
+StringArray ANALYSIS_Convert
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number";
+        < "Converts a number from one measurement system to another"; > ;
+        < "Number"; > ;
+        < "The number"; > ;
+        < "From unit"; > ;
+        < "Unit of measure for number"; > ;
+        < "To unit"; > ;
+        < "Unit of measure for the result"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Bin2Oct
+StringArray ANALYSIS_Amordegrc
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The binary number to be converted (as text)";
+        < "Returns the prorated linear depreciation of an asset for each accounting period"; > ;
+        < "Cost"; > ;
+        < "Cost of the asset"; > ;
+        < "Date purchased"; > ;
+        < "Purchase date of the asset"; > ;
+        < "First period"; > ;
+        < "Date the first period ends"; > ;
+        < "Salvage"; > ;
+        < "Salvage value of an asset at the end of its life"; > ;
+        < "Period"; > ;
+        < "The period"; > ;
+        < "Rate"; > ;
+        < "The rate of depreciation"; > ;
+        < "Basis"; > ;
+        < "The year basis to be used"; > ;
     };
+};
 
-    String 4 // name of parameter 2         Bin2Oct
+StringArray ANALYSIS_Amorlinc
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Places";
+        < "Returns the prorated linear depreciation of an asset for each accounting period"; > ;
+        < "Cost"; > ;
+        < "Cost of the asset"; > ;
+        < "Date purchased"; > ;
+        < "Purchase date of the asset"; > ;
+        < "First period"; > ;
+        < "The date the first period ends"; > ;
+        < "Salvage"; > ;
+        < "The salvage value of an asset at the end of its life"; > ;
+        < "Period"; > ;
+        < "The period"; > ;
+        < "Rate"; > ;
+        < "The rate of depreciation"; > ;
+        < "Basis"; > ;
+        < "The year basis to be used"; > ;
     };
+};
 
-    String 5 // description of parameter 2  Bin2Oct
+StringArray ANALYSIS_Accrint
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number of places used";
+        < "Returns the accrued interest for a security that pays periodic interest"; > ;
+        < "Issue"; > ;
+        < "Issue date of the security"; > ;
+        < "First interest"; > ;
+        < "First interest date of the security"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Rate"; > ;
+        < "The rate"; > ;
+        < "Par"; > ;
+        < "The par value"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
 };
 
-Resource ANALYSIS_Bin2Dec
+StringArray ANALYSIS_Accrintm
 {
-    String 1    // description Bin2Dec
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Converts a binary number to a decimal number";
+        < "Returns the accrued interest for a security that pays interest at maturity"; > ;
+        < "Issue"; > ;
+        < "The issue date"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Rate"; > ;
+        < "The rate"; > ;
+        < "Par"; > ;
+        < "The par value"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Bin2Dec
+StringArray ANALYSIS_Received
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number";
+        < "Returns the amount paid out at maturity for a fully invested security"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Investment"; > ;
+        < "The investment"; > ;
+        < "Discount"; > ;
+        < "The discount"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Bin2Dec
+StringArray ANALYSIS_Disc
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The binary number to be converted (as text)";
+        < "Returns the discount rate for a security"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Price"; > ;
+        < "The price"; > ;
+        < "Redemption"; > ;
+        < "The redemption value"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
 };
 
-Resource ANALYSIS_Bin2Hex
+StringArray ANALYSIS_Duration
 {
-    String 1    // description Bin2Hex
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Converts a binary number to a hexadecimal number";
+        < "Returns the annual Macaulay duration of a security with periodic interest payments"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Coupon"; > ;
+        < "The coupon rate"; > ;
+        < "Yield"; > ;
+        < "The yield"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Bin2Hex
+StringArray ANALYSIS_Effect
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number";
+        < "Returns the effective annual interest rate"; > ;
+        < "Nominal rate"; > ;
+        < "The nominal rate"; > ;
+        < "Npery"; > ;
+        < "The periods"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Bin2Hex
+StringArray ANALYSIS_Cumprinc
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The binary number to be converted (as text)";
+        < "Returns the cumulative principal on a loan to be paid between two periods"; > ;
+        < "Rate"; > ;
+        < "The rate"; > ;
+        < "Nper"; > ;
+        < "Number of payment periods"; > ;
+        < "Pv"; > ;
+        < "The present value"; > ;
+        < "Start period"; > ;
+        < "The start period"; > ;
+        < "End period"; > ;
+        < "The end period"; > ;
+        < "Type"; > ;
+        < "The type of maturity"; > ;
     };
+};
 
-    String 4 // name of parameter 2         Bin2Hex
+StringArray ANALYSIS_Cumipmt
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Places";
+        < "Returns the cumulative interest to be paid between two periods"; > ;
+        < "Rate"; > ;
+        < "The rate"; > ;
+        < "Nper"; > ;
+        < "Number of payment periods"; > ;
+        < "Pv"; > ;
+        < "The present value"; > ;
+        < "Start period"; > ;
+        < "The start period"; > ;
+        < "End period"; > ;
+        < "The end period"; > ;
+        < "Type"; > ;
+        < "The type of maturity"; > ;
     };
+};
 
-    String 5 // description of parameter 2  Bin2Hex
+StringArray ANALYSIS_Price
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number of places used.";
+        < "Returns the price per 100 currency units face value of a security that pays periodic interest"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Rate"; > ;
+        < "The rate"; > ;
+        < "Yield"; > ;
+        < "The yield"; > ;
+        < "Redemption"; > ;
+        < "The redemption value"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
 };
 
-Resource ANALYSIS_Oct2Bin
+StringArray ANALYSIS_Pricedisc
 {
-    String 1    // description Oct2Bin
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Converts an octal number to a binary number";
+        < "Returns the price per 100 currency units face value of a discounted security"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Discount"; > ;
+        < "The discount"; > ;
+        < "Redemption"; > ;
+        < "The redemption value"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Oct2Bin
+StringArray ANALYSIS_Pricemat
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number";
+        < "Returns the price per 100 currency units face value of a security that pays interest at maturity"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Issue"; > ;
+        < "The issue date"; > ;
+        < "Rate"; > ;
+        < "The rate"; > ;
+        < "Yield"; > ;
+        < "The yield"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Oct2Bin
+StringArray ANALYSIS_Mduration
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The octal number to be converted (as text)";
+        < "Returns the Macaulay modified duration for a security with an assumed par value of 100 currency units"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Coupon"; > ;
+        < "The coupon rate"; > ;
+        < "Yield"; > ;
+        < "The yield"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 4 // name of parameter 2         Oct2Bin
+StringArray ANALYSIS_Nominal
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Places";
+        < "Returns the annual nominal interest rate"; > ;
+        < "Effective rate"; > ;
+        < "The effective interest rate"; > ;
+        < "Npery"; > ;
+        < "The periods"; > ;
     };
+};
 
-    String 5 // description of parameter 2  Oct2Bin
+StringArray ANALYSIS_Dollarfr
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number of places used";
+        < "Converts a price expressed as a decimal into a price expressed as a fraction"; > ;
+        < "Decimal dollar"; > ;
+        < "The decimal number"; > ;
+        < "Fraction"; > ;
+        < "The divisor"; > ;
     };
 };
 
-Resource ANALYSIS_Oct2Dec
+StringArray ANALYSIS_Dollarde
 {
-    String 1    // description Oct2Dec
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Converts an octal number to a decimal number";
+        < "Converts a price expressed as a fraction into a price expressed as a decimal"; > ;
+        < "Fractional dollar"; > ;
+        < "The number as a fraction"; > ;
+        < "Fraction"; > ;
+        < "The divisor"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Oct2Dec
+StringArray ANALYSIS_Yield
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number";
+        < "Returns the yield on a security that pays periodic interest"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Rate"; > ;
+        < "The rate"; > ;
+        < "Price"; > ;
+        < "The price"; > ;
+        < "Redemption"; > ;
+        < "The redemption value"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Oct2Dec
+StringArray ANALYSIS_Yielddisc
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The octal number to be converted (as text)";
+        < "Returns the annual yield for a discounted security"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Price"; > ;
+        < "The price"; > ;
+        < "Redemption"; > ;
+        < "The redemption value"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
 };
 
-Resource ANALYSIS_Oct2Hex
+StringArray ANALYSIS_Yieldmat
 {
-    String 1    // description Oct2Hex
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Converts an octal number to a hexadecimal number";
+        < "Returns the annual yield of a security that pays interest at maturity"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Issue"; > ;
+        < "The issue date"; > ;
+        < "Rate"; > ;
+        < "The rate"; > ;
+        < "Price"; > ;
+        < "The price"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Oct2Hex
+StringArray ANALYSIS_Tbilleq
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number";
+        < "Returns the bond-equivalent yield for a treasury bill"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Discount"; > ;
+        < "The discount rate"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Oct2Hex
+StringArray ANALYSIS_Tbillprice
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The octal number to be converted (as text)";
+        < "Returns the price of 100 currency units face value for a treasury bill"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Discount"; > ;
+        < "The discount rate"; > ;
     };
+};
 
-    String 4 // name of parameter 2         Oct2Hex
+StringArray ANALYSIS_Tbillyield
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Places";
-    };
+        < "Returns the yield for a treasury bill"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Price"; > ;
+        < "The price"; > ;
+    };
+};
 
-    String 5 // description of parameter 2  Oct2Hex
+StringArray ANALYSIS_Oddfprice
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number of places used";
+        < "Returns the price per $100 face value of a security with an odd first period"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Issue"; > ;
+        < "The issue date"; > ;
+        < "First coupon"; > ;
+        < "The first coupon date"; > ;
+        < "Rate"; > ;
+        < "The rate"; > ;
+        < "Yield"; > ;
+        < "The yield"; > ;
+        < "Redemption"; > ;
+        < "The redemption value"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
 };
 
-Resource ANALYSIS_Dec2Bin
+StringArray ANALYSIS_Oddfyield
 {
-    String 1    // description Dec2Bin
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Converts a decimal number to a binary number";
-    };
-
-    String 2 // name of parameter 1         Dec2Bin
-    {
-        Text [ en-US ] = "Number";
+        < "Returns the yield of a security with an odd first period"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Issue"; > ;
+        < "The issue date"; > ;
+        < "First coupon"; > ;
+        < "The first coupon date"; > ;
+        < "Rate"; > ;
+        < "The rate"; > ;
+        < "Price"; > ;
+        < "The price"; > ;
+        < "Redemption"; > ;
+        < "The redemption value"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Dec2Bin
+StringArray ANALYSIS_Oddlprice
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The decimal integer to be converted";
+        < "Returns the price per $100 face value of a security with an odd last period"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Last interest"; > ;
+        < "The last interest date"; > ;
+        < "Rate"; > ;
+        < "The rate"; > ;
+        < "Yield"; > ;
+        < "The yield"; > ;
+        < "Redemption"; > ;
+        < "The redemption value"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 4 // name of parameter 2         Dec2Bin
+StringArray ANALYSIS_Oddlyield
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Places";
+        < "Returns the yield of a security with an odd last period"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Last interest"; > ;
+        < "The last interest date"; > ;
+        < "Rate"; > ;
+        < "The rate"; > ;
+        < "Price"; > ;
+        < "The price"; > ;
+        < "Redemption"; > ;
+        < "The redemption value"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 5 // description of parameter 2  Dec2Bin
+StringArray ANALYSIS_Xirr
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number of places used";
+        < "Returns the internal rate of return for a non-periodic schedule of payments"; > ;
+        < "Values"; > ;
+        < "The values"; > ;
+        < "Dates"; > ;
+        < "The dates"; > ;
+        < "Guess"; > ;
+        < "The guess"; > ;
     };
 };
 
-Resource ANALYSIS_Dec2Hex
+StringArray ANALYSIS_Xnpv
 {
-    String 1    // description Dec2Hex
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Converts a decimal number to a hexadecimal number";
+        < "Returns the net present value for a non-periodic schedule of payments"; > ;
+        < "Rate"; > ;
+        < "The rate"; > ;
+        < "Values"; > ;
+        < "The values"; > ;
+        < "Dates"; > ;
+        < "The dates"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Dec2Hex
+StringArray ANALYSIS_Intrate
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number";
+        < "Returns the interest rate for a fully invested security"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Investment"; > ;
+        < "The investment"; > ;
+        < "Redemption"; > ;
+        < "The redemption value"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Dec2Hex
+StringArray ANALYSIS_Coupncd
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The decimal integer to be converted";
+        < "Returns the first coupon date after the settlement date"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 4 // name of parameter 2         Dec2Hex
+StringArray ANALYSIS_Coupdays
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Places";
+        < "Returns the number of days in the coupon period containing the settlement date"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 5 // description of parameter 2  Dec2Hex
+StringArray ANALYSIS_Coupdaysnc
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number of places used";
+        < "Returns the number of days from the settlement date to the next coupon date"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
 };
 
-Resource ANALYSIS_Dec2Oct
+StringArray ANALYSIS_Coupdaybs
 {
-    String 1    // description Dec2Oct
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Converts a decimal number into an octal number";
+        < "Returns the number of days from the beginning of the coupon period to the settlement date"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 2 // name of parameter 1         Dec2Oct
+StringArray ANALYSIS_Couppcd
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "Number";
+        < "Returns the last coupon date preceding the settlement date"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 3 // description of parameter 1  Dec2Oct
+StringArray ANALYSIS_Coupnum
+{
+    ItemList [ en-US ] =
     {
-        Text [ en-US ] = "The decimal number";
+        < "Returns the number of coupons payable between the settlement and maturity dates"; > ;
+        < "Settlement"; > ;
+        < "The settlement"; > ;
+        < "Maturity"; > ;
+        < "The maturity"; > ;
+        < "Frequency"; > ;
+        < "The frequency"; > ;
+        < "Basis"; > ;
+        < "The basis"; > ;
     };
+};
 
-    String 4 // name of parameter 2         Dec2Oct
-    {
-        Text [ en-US ] = "Places";
-    };
-
-    String 5 // description of parameter 2  Dec2Oct
-    {
-        Text [ en-US ] = "Number of places used";
-    };
-};
-
-Resource ANALYSIS_Hex2Bin
-{
-    String 1    // description Hex2Bin
-    {
-        Text [ en-US ] = "Converts a hexadecimal number to a binary number";
-    };
-
-    String 2 // name of parameter 1         Hex2Bin
-    {
-        Text [ en-US ] = "Number";
-    };
-
-    String 3 // description of parameter 1  Hex2Bin
-    {
-        Text [ en-US ] = "The hexadecimal number to be converted (as text)";
-    };
-
-    String 4 // name of parameter 2         Hex2Bin
-    {
-        Text [ en-US ] = "Places";
-    };
-
-    String 5 // description of parameter 2  Hex2Bin
-    {
-        Text [ en-US ] = "Number of places used";
-    };
-};
-
-Resource ANALYSIS_Hex2Dec
-{
-    String 1    // description Hex2Dec
-    {
-        Text [ en-US ] = "Converts a hexadecimal number to a decimal number";
-    };
-
-    String 2 // name of parameter 1         Hex2Dec
-    {
-        Text [ en-US ] = "Number";
-    };
-
-    String 3 // description of parameter 1  Hex2Dec
-    {
-        Text [ en-US ] = "The hexadecimal number to be converted (as text)";
-    };
-};
-
-Resource ANALYSIS_Hex2Oct
-{
-    String 1    // description Hex2Oct
-    {
-        Text [ en-US ] = "Converts a hexadecimal number to an octal number";
-    };
-
-    String 2 // name of parameter 1         Hex2Oct
-    {
-        Text [ en-US ] = "Number";
-    };
-
-    String 3 // description of parameter 1  Hex2Oct
-    {
-        Text [ en-US ] = "The hexadecimal number to be converted (as text)";
-    };
-
-    String 4 // name of parameter 2         Hex2Oct
-    {
-        Text [ en-US ] = "Places";
-    };
-
-    String 5 // description of parameter 2  Hex2Oct
-    {
-        Text [ en-US ] = "Number of places used";
-    };
-};
-
-Resource ANALYSIS_Delta
-{
-    String 1    // description Delta
-    {
-        Text [ en-US ] = "Tests whether two values are equal";
-    };
-
-    String 2 // name of parameter 1         Delta
-    {
-        Text [ en-US ] = "Number 1";
-    };
-
-    String 3 // description of parameter 1  Delta
-    {
-        Text [ en-US ] = "The first number";
-    };
-
-    String 4 // name of parameter 2         Delta
-    {
-        Text [ en-US ] = "Number 2";
-    };
-
-    String 5 // description of parameter 2  Delta
-    {
-        Text [ en-US ] = "The second number";
-    };
-};
-
-Resource ANALYSIS_Erf
-{
-    String 1    // description Erf
-    {
-        Text [ en-US ] = "Returns the error function";
-    };
-
-    String 2 // name of parameter 1         Erf
-    {
-        Text [ en-US ] = "Lower limit";
-    };
-
-    String 3 // description of parameter 1  Erf
-    {
-        Text [ en-US ] = "The lower limit for integration";
-    };
-
-    String 4 // name of parameter 2         Erf
-    {
-        Text [ en-US ] = "Upper limit";
-    };
-
-    String 5 // description of parameter 2  Erf
-    {
-        Text [ en-US ] = "The upper limit for integration";
-    };
-};
-
-Resource ANALYSIS_Erfc
-{
-    String 1    // description Erfc
-    {
-        Text [ en-US ] = "Returns the complementary error function";
-    };
-
-    String 2 // name of parameter 1         Erfc
-    {
-        Text [ en-US ] = "Lower limit";
-    };
-
-    String 3 // description of parameter 1  Erfc
-    {
-        Text [ en-US ] = "The lower limit for integration";
-    };
-};
-
-Resource ANALYSIS_Gestep
-{
-    String 1    // description GeStep
-    {
-        Text [ en-US ] = "Tests whether a number is greater than a threshold value";
-    };
-
-    String 2 // name of parameter 1         GeStep
-    {
-        Text [ en-US ] = "Number";
-    };
-
-    String 3 // description of parameter 1  GeStep
-    {
-        Text [ en-US ] = "The value to test against step";
-    };
-
-    String 4 // name of parameter 2         GeStep
-    {
-        Text [ en-US ] = "Step";
-    };
-
-    String 5 // description of parameter 2  GeStep
-    {
-        Text [ en-US ] = "The threshold value";
-    };
-};
-
-Resource ANALYSIS_Factdouble
-{
-    String 1    // description Factdouble
-    {
-        Text [ en-US ] = "Returns the double factorial of Number";
-    };
-
-    String 2 // name of parameter 1         Factdouble
-    {
-        Text [ en-US ] = "Number";
-    };
-
-    String 3 // description of parameter 1  Factdouble
-    {
-        Text [ en-US ] = "The number";
-    };
-};
-
-Resource ANALYSIS_Imabs
-{
-    String 1    // description Imabs
-    {
-        Text [ en-US ] = "Returns the absolute value (modulus) of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imabs
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imabs
-    {
-        Text [ en-US ] = "The complex number";
-    };
-};
-
-Resource ANALYSIS_Imaginary
-{
-    String 1    // description Imaginary
-    {
-        Text [ en-US ] = "Returns the imaginary coefficient of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imaginary
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imaginary
-    {
-        Text [ en-US ] = "The complex number";
-    };
-};
-
-Resource ANALYSIS_Impower
-{
-    String 1    // description Impower
-    {
-        Text [ en-US ] = "Returns a complex number raised to a real power";
-    };
-
-    String 2 // name of parameter 1         Impower
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Impower
-    {
-        Text [ en-US ] = "The complex number";
-    };
-
-    String 4 // name of parameter 2         Impower
-    {
-        Text [ en-US ] = "Number";
-    };
-
-    String 5 // description of parameter 2  Impower
-    {
-        Text [ en-US ] = "Power to which the complex number is raised";
-    };
-};
-
-Resource ANALYSIS_Imargument
-{
-    String 1    // description Imargument
-    {
-        Text [ en-US ] = "Returns the argument theta, an angle expressed in radians";
-    };
-
-    String 2 // name of parameter 1         Imargument
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imargument
-    {
-        Text [ en-US ] = "A complex number";
-    };
-};
-
-Resource ANALYSIS_Imcos
-{
-    String 1    // description Imcos
-    {
-        Text [ en-US ] = "Returns the cosine of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imcos
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imcos
-    {
-        Text [ en-US ] = "A complex number";
-    };
-};
-
-Resource ANALYSIS_Imdiv
-{
-    String 1    // description Imdiv
-    {
-        Text [ en-US ] = "Returns the quotient of two complex numbers";
-    };
-
-    String 2 // name of parameter 1         Imdiv
-    {
-        Text [ en-US ] = "Numerator";
-    };
-
-    String 3 // description of parameter 1  Imdiv
-    {
-        Text [ en-US ] = "The dividend";
-    };
-
-    String 4 // name of parameter 2         Imdiv
-    {
-        Text [ en-US ] = "Denominator";
-    };
-
-    String 5 // description of parameter 2  Imdiv
-    {
-        Text [ en-US ] = "The divisor";
-    };
-};
-
-Resource ANALYSIS_Imexp
-{
-    String 1    // description Imexp
-    {
-        Text [ en-US ] = "Returns the algebraic form of the exponential of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imexp
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imexp
-    {
-        Text [ en-US ] = "The complex number";
-    };
-};
-
-Resource ANALYSIS_Imconjugate
-{
-    String 1    // description Imconjugate
-    {
-        Text [ en-US ] = "Returns the complex conjugate of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imconjugate
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imconjugate
-    {
-        Text [ en-US ] = "The complex number";
-    };
-};
-
-Resource ANALYSIS_Imln
-{
-    String 1    // description Imln
-    {
-        Text [ en-US ] = "Returns the natural logarithm of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imln
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imln
-    {
-        Text [ en-US ] = "The complex number";
-    };
-};
-
-Resource ANALYSIS_Imlog10
-{
-    String 1    // description Imlog10
-    {
-        Text [ en-US ] = "Returns the base-10 logarithm of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imlog10
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imlog10
-    {
-        Text [ en-US ] = "The complex number";
-    };
-};
-
-Resource ANALYSIS_Imlog2
-{
-    String 1    // description Imlog2
-    {
-        Text [ en-US ] = "Returns the base-2 logarithm of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imlog2
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imlog2
-    {
-        Text [ en-US ] = "The complex number";
-    };
-};
-
-Resource ANALYSIS_Improduct
-{
-    String 1    // description Improduct
-    {
-        Text [ en-US ] = "Returns the product of several complex numbers";
-    };
-
-    String 2 // name of parameter 1         Improduct
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Improduct
-    {
-        Text [ en-US ] = "The first complex number";
-    };
-
-    String 4 // name of parameter 2         Improduct
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 5 // description of parameter 2  Improduct
-    {
-        Text [ en-US ] = "Another complex number";
-    };
-};
-
-Resource ANALYSIS_Imreal
-{
-    String 1    // description Imreal
-    {
-        Text [ en-US ] = "Returns the real coefficient of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imreal
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imreal
-    {
-        Text [ en-US ] = "The complex number";
-    };
-};
-
-Resource ANALYSIS_Imsin
-{
-    String 1    // description Imsin
-    {
-        Text [ en-US ] = "Returns the sine of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imsin
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imsin
-    {
-        Text [ en-US ] = "The complex number";
-    };
-};
-
-Resource ANALYSIS_Imsub
-{
-    String 1    // description Imsub
-    {
-        Text [ en-US ] = "Returns the difference of two complex numbers";
-    };
-
-    String 2 // name of parameter 1         Imsub
-    {
-        Text [ en-US ] = "Complex number 1";
-    };
-
-    String 3 // description of parameter 1  Imsub
-    {
-        Text [ en-US ] = "Complex number 1";
-    };
-
-    String 4 // name of parameter 2         Imsub
-    {
-        Text [ en-US ] = "Complex number 2";
-    };
-
-    String 5 // description of parameter 2  Imsub
-    {
-        Text [ en-US ] = "Complex number 2";
-    };
-};
-
-Resource ANALYSIS_Imsqrt
-{
-    String 1    // description Imsqrt
-    {
-        Text [ en-US ] = "Returns the square root of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imsqrt
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imsqrt
-    {
-        Text [ en-US ] = "The complex number";
-    };
-};
-
-Resource ANALYSIS_Imsum
-{
-    String 1    // description Imsum
-    {
-        Text [ en-US ] = "Returns the sum of complex numbers";
-    };
-
-    String 2 // name of parameter 1         Imsum
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imsum
-    {
-        Text [ en-US ] = "The complex number";
-    };
-
-};
-
-Resource ANALYSIS_Imtan
-{
-    String 1    // description Imtan
-    {
-        Text [ en-US ] = "Returns the tangent of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imtan
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imtan
-    {
-        Text [ en-US ] = "A complex number";
-    };
-};
-
-Resource ANALYSIS_Imsec
-{
-    String 1    // description Imsec
-    {
-        Text [ en-US ] = "Returns the secant of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imsec
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imsec
-    {
-        Text [ en-US ] = "A complex number";
-    };
-};
-
-Resource ANALYSIS_Imcsc
-{
-    String 1    // description Imcsc
-    {
-        Text [ en-US ] = "Returns the cosecant of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imcsc
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imcsc
-    {
-        Text [ en-US ] = "A complex number";
-    };
-};
-
-Resource ANALYSIS_Imcot
-{
-    String 1    // description Imcot
-    {
-        Text [ en-US ] = "Returns the cotangent of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imcot
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imcot
-    {
-        Text [ en-US ] = "A complex number";
-    };
-};
-
-Resource ANALYSIS_Imsinh
-{
-    String 1    // description Imsinh
-    {
-        Text [ en-US ] = "Returns the hyperbolic sine of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imsinh
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imsinh
-    {
-        Text [ en-US ] = "A complex number";
-    };
-};
-
-Resource ANALYSIS_Imcosh
-{
-    String 1    // description Imcosh
-    {
-        Text [ en-US ] = "Returns the hyperbolic cosine of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imcosh
-    {
-        Text [ en-US ] = "Complex number";
-    };
-
-    String 3 // description of parameter 1  Imcosh
-    {
-        Text [ en-US ] = "A complex number";
-    };
-};
-
-Resource ANALYSIS_Imsech
-{
-    String 1    // description Imsech
-    {
-        Text [ en-US ] = "Returns the hyperbolic secant of a complex number";
-    };
-
-    String 2 // name of parameter 1         Imsech
-    {
-        Text [ en-US ] = "Complex number";

... etc. - the rest is truncated


More information about the Libreoffice-commits mailing list