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 [2010/06/21 16:47 UTC] – clarified ColName and ColDate are edited inside General Ledger 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 26: Line 26:
    "3/1/2009", with StartDate of 1/31/2009    Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive    "3/1/2009", with StartDate of 1/31/2009    Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive
   "3/17/2009", with StartDate of 1/12/2009    Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive   "3/17/2009", with StartDate of 1/12/2009    Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive
-%fineprint{Used in: [[AvgBal]], [[LineAverage]], [[LineAverageRound]]}%+%fineprint{Used in: [[AvgBal]], [[FedRptAvgBal]], [[LineAverage]], [[LineAverageRound]]}%
  
 ==== BalanceDate ==== ==== BalanceDate ====
Line 33: Line 33:
   "12/31/2009"          Account balances prior to posting the year-end close out batch (ie, income + expense > 0)   "12/31/2009"          Account balances prior to posting the year-end close out batch (ie, income + expense > 0)
   "12/31/2009 8:00 PM"  Account balances after posting the year-end close out batch (ie, income + expense = 0)   "12/31/2009 8:00 PM"  Account balances after posting the year-end close out batch (ie, income + expense = 0)
-%fineprint{Used in: [[Balance]], [[LineBalance]], [[LineRound]]}%+%fineprint{Used in: [[Balance]], [[FedRptBalance]], [[LineBalance]], [[LineRound]]}%
 ==== BudgetDate ==== ==== BudgetDate ====
 The date that represents the **month and year** used to retrieve the budget numbers The date that represents the **month and year** used to retrieve the budget numbers
Line 39: Line 39:
    "3/1/2009"    Returns the budget for March 2009    "3/1/2009"    Returns the budget for March 2009
   "3/17/2009"    Returns the budget for March 2009   "3/17/2009"    Returns the budget for March 2009
-%fineprint{Used in: [[Budget]], [[LineBudget]], [[LineBudgetRound]]}%+%fineprint{Used in: [[Budget]], [[FedRptBudget]], [[LineBudget]], [[LineBudgetRound]]}%
 ==== ColDate ==== ==== ColDate ====
 The date of the user report column created by going to Edit Columns from the Edit User Report form in the General Ledger.  The date must be manually added in the General Ledger in order for it to work in the Excel function. The date of the user report column created by going to Edit Columns from the Edit User Report form in the General Ledger.  The date must be manually added in the General Ledger in order for it to work in the Excel function.
Line 62: Line 62:
   "CSB"      CSB Services, Inc.   "CSB"      CSB Services, Inc.
      
-%fineprint{Used in: [[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 69: Line 75:
   "C15"   "C15"
 %fineprint{Used in: [[LineAverage]], [[LineAverageRound]], [[LineBalance]], [[LineBudget]], [[LineBudgetRound]], [[LineColumn]], [[LineDescription]], [[LineRound]]}% %fineprint{Used in: [[LineAverage]], [[LineAverageRound]], [[LineBalance]], [[LineBudget]], [[LineBudgetRound]], [[LineColumn]], [[LineDescription]], [[LineRound]]}%
 +
 +==== LineNum ====
 +The abbreviated federal report line number.
 +  "SC11"
 +  "SO141"
 +  "RI-4435"
 +%fineprint{Used in: [[FedRptAvgBal]], [[FedRptBalance]], [[FedRptBudget]], [[FedRptDescription]]}%
 +
 ==== PosNeg ==== ==== PosNeg ====
 Limit results to **P**ositive, **N**egative, **D**ebit, or **C**redit only.  You may spell out or abbreviate Positive, Negative, Debit, and Credit if you would like to make your formula more readable; the function performs a match on the first character only. Limit results to **P**ositive, **N**egative, **D**ebit, or **C**redit only.  You may spell out or abbreviate Positive, Negative, Debit, and Credit if you would like to make your formula more readable; the function performs a match on the first character only.
Line 78: Line 92:
   "C"  Show positive number if credit balance, otherwise display:  Debit Balance   "C"  Show positive number if credit balance, otherwise display:  Debit Balance
  
-%fineprint{Used in: [[AvgBal]], [[Balance]], [[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 ====
 +The name of the federal report (not its description)
 +  "Call"
 +  "TFR"
 +%fineprint{Used in: [[FedRptAvgBal]], [[FedRptBalance]], [[FedRptBudget]], [[FedRptDescription]]}%  
 +  
 ==== StartDate ==== ==== StartDate ====
 The date that represents the month and year **from** which to compute the daily average balance (used only with the required AvgBalDate parameter). The date that represents the month and year **from** which to compute the daily average balance (used only with the required AvgBalDate parameter).
Line 85: Line 111:
   "1/31/2009", with AvgBalDate of  3/1/2009    Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive   "1/31/2009", with AvgBalDate of  3/1/2009    Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive
   "1/17/2009", with AvgBalDate of 3/12/2009    Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive   "1/17/2009", with AvgBalDate of 3/12/2009    Returns the daily average balance for 1/1/2009 through 3/31/2009, inclusive
-%fineprint{Used in: [[AvgBal]], [[LineAverageRound]]}%+%fineprint{Used in: [[AvgBal]], [[FedRptAvgBal]], [[LineAverageRound]]}%
  
 ==== UserRpt ==== ==== UserRpt ====
  • gl_excel/parameters.1277138823.txt.gz
  • Last modified: 2010/06/21 16:47 UTC
  • by mwolfe