gl_excel:parameters

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
gl_excel:parameters [2014/03/13 12:14 UTC] – mwolfegl_excel:parameters [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1
Line 3: Line 3:
  
 ===== To Quote or not to Quote ===== ===== To Quote or not to Quote =====
-  * Use quotes if you are using the **actual** data in the formula: %InlineCode{=Balance("SC11","12/31/2009")}% +  * Use quotes if you are using the **actual** data in the formula: **=Balance("SC11","12/31/2009")** 
-  * Don’t use quotes if you are **referring** to the cell that holds the data:   %InlineCode{=Balance(A1,B1)}% +  * Don’t use quotes if you are **referring** to the cell that holds the data:   **=Balance(A1,B1)** 
-    * Cell A1 would then contain %InlineCode{SC11}% **not** %InlineCode{"SC11"}% +    * Cell A1 would then contain **SC11** **not** **"SC11"** 
-    * Cell B1 would then contain %InlineCode{12/31/2009}% **not** %InlineCode{"12/31/2009"}%+    * Cell B1 would then contain **12/31/2009** **not** **"12/31/2009"**
 Please note that all examples given on this page show quoted data, as would be used if the values were directly entered into the formula.  However, it is generally better practice to enter the data in cells of their own and refer to those cells from within the formulas. Please note that all examples given on this page show quoted data, as would be used if the values were directly entered into the formula.  However, it is generally better practice to enter the data in cells of their own and refer to those cells from within the formulas.
  
Line 63: Line 63:
      
 %fineprint{Used in: [[FedRptAvgBal]], [[FedRptBalance]], [[FedRptBudget]], [[LineAverage]], [[LineBalance]], [[LineBudget]]}% %fineprint{Used in: [[FedRptAvgBal]], [[FedRptBalance]], [[FedRptBudget]], [[LineAverage]], [[LineBalance]], [[LineBudget]]}%
 +
 +==== Concept ====
 +The 8-character alphanumeric Call Report concept code.
 +  "RCON0010"
 +  "RIAD4107"
 +%fineprint{Used in: [[CallRptDescription]], [[CallRptValue]]}%
  
 ==== LineCode ==== ==== LineCode ====
Line 87: Line 93:
  
 %fineprint{Used in: [[AvgBal]], [[Balance]], [[FedRptAvgBal]], [[FedRptBalance]], [[LineAverage]], [[LineAverageRound]], [[LineBalance]], [[LineRound]]}% %fineprint{Used in: [[AvgBal]], [[Balance]], [[FedRptAvgBal]], [[FedRptBalance]], [[LineAverage]], [[LineAverageRound]], [[LineBalance]], [[LineRound]]}%
 +
 +==== RptDate ====
 +The month-end date that corresponds to the respective Call Report reporting period.  Data must exist in the G&B Call Report program in order for a given date to return values.
 +  "12/31/2013"
 +   "1/31/2013"
 +%fineprint{Used in: [[CallRptValue]]}%
  
 ==== RptName ==== ==== RptName ====
  • gl_excel/parameters.1394712870.txt.gz
  • Last modified: 2014/03/13 12:14 UTC
  • by mwolfe