custom software for humans https://grandjean.net/wiki/ 2026-04-21T08:28:33+00:00 https://grandjean.net/wiki/ https://grandjean.net/wiki/_media/logo.png text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/avgbal?rev=1690209187&do=diff AvgBal This is the average balance function. It returns the daily average balance of a GL account for a given month (or span of months). AvgBal(AcctNum, AvgBalDate, PosNeg, StartDate) Example Usage * =AvgBal("1010-000", "7/31/2009") Returns the daily average balance for account 1010-000 during the month of July, 2009. text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/balance?rev=1690209187&do=diff Balance This function returns the balance of a GL account or TFR line number as of a certain date. Balance(AcctNum, BalanceDate, PosNeg) Example Usage * =Balance("1010-000", "7/31/2009") Returns the balance for account 1010-000 as of the end of the day July 31, 2009. text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/budget?rev=1690209187&do=diff Budget This function returns the budget of a GL account or TFR line number for a given month and year. The day portion of the date is ignored. When budget numbers are entered in the GL they are entered for the current month only. However, for income and expense accounts, the Budget function returns the cumulative year-to-date budget number. For example, if an income account had a constant monthly budget of $10,000 per month, the Budget function would return $40,000 for the April budget. text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/callrptdescription?rev=1690209187&do=diff CallRptDescription This function returns the full description of a Call Report concept line based on the provided concept code. The source for this data is the G&B Call Report program (not the G&B GL program). CallRptDescription(Concept) Example Usage text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/callrptvalue?rev=1690209187&do=diff CallRptValue This function returns the value of a Call Report concept line as of a certain date. The source for this data is the G&B Call Report program (not the G&B GL program). CallRptValue(Concept,RptDate) Example Usage * =CallRptValue("RIAD4107","12/31/2012") text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/description?rev=1690209187&do=diff Description This function returns the full description of a GL account or TFR line based on the account number or line number. Description(AcctNum) Example Usage * =Description("1010-000") Returns the description for GL account number 1010-000: Mortgages - Resd & Comm (DRM) text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/fedrptavgbal?rev=1690209187&do=diff FedRptAvgBal This is the Federal Report Average Balance function. It returns the daily average balance of a Federal Report line for a given month (or span of months). The daily average balance is calculated by adding the balance at the end of each day in the time span and then dividing by the total number of days in that span. A daily average is calculated for each individual account. This final average is used to determine where an account's balance is reported for accounts whose balance… text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/fedrptbalance?rev=1690209187&do=diff FedRptBalance This function returns the balance of a Federal Report line as of a certain date. FedRptBalance(RptName, LineNum, BalanceDate, Company, PosNeg) Example Usage * =FedRptBalance("TFR", "SC11", "7/31/2009") Returns the balance for line SC11 of the TFR Federal Report as of July 31, 2009. text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/fedrptbudget?rev=1690209187&do=diff FedRptBudget This function returns the total budget of a Federal Report line as of a certain date. FedRptBalance(RptName, LineNum, BudgetDate, Company) Example Usage * =FedRptBudget("TFR", "SC11", "7/31/2009") Returns the balance for line SC11 of the TFR Federal Report as of July 2009. text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/fedrptdescription?rev=1690209187&do=diff FedRptDescription This function returns the full description of a Federal Report line based on the Federal Report name and line number. If called without the line number, it returns the full description of the report. FedRptDescription(RptName, LineNum text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/lineaverage?rev=1690209187&do=diff LineAverage This is the user report line average balance function. It returns the daily average balance for a user report line during a given month. LineAverage(UserRpt, LineCode, AvgBalDate, Company, PosNeg, StartDate) Example Usage * =LineAverage("BALCON", "A01", "7/31/2009") text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/lineaverageround?rev=1690209187&do=diff LineAverageRound This function returns the LineAverage in thousands. Its usage and parameters are the same as the LineAverage function, with the exception of the Company parameter*. The LineAverage function is called then the following calculations are performed on the result: text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/linebalance?rev=1690209187&do=diff LineBalance This function returns the balance of a user report line as of a certain date. LineBalance(UserRpt, LineCode, BalanceDate, Company, PosNeg) Example Usage * =LineBalance("BALCON", "A01", "7/31/2009") Returns the balance for line A01 of the BALCON user report as of July 31, 2009. text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/linebudget?rev=1690209187&do=diff LineBudget This function returns the budget of a user report line for a given month and year. The day portion of the date is ignored. When budget numbers are entered in the GL they are entered for the current month only. However, for income and expense accounts, the LineBudget function returns the cumulative year-to-date budget number. For example, if a user report line consisted of a single income account that had a constant monthly budget of $10,000 per month, the LineBudget function woul… text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/linebudgetround?rev=1690209187&do=diff LineBudgetRound This function returns the LineBudget in thousands. Its usage and parameters are the same as the LineBudget function, with the exception of the Company parameter*. The LineBudget function is called then the following calculations are performed on the result: text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/linecolumn?rev=1690209187&do=diff LineColumn This function returns the value of a user defined column from the General Ledger. Before using this function in Excel, the column(s) must be added and populated from within the General Ledger by clicking on the Edit Columns button on the User Reports form. text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/linedescription?rev=1690209187&do=diff LineDescription This function returns the full description of a user report line based on the user report name and line code. If no line code is provided, the function returns the full description of the user report itself. LineDescription(UserRpt, text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/lineround?rev=1690209187&do=diff LineRound This function returns the LineBalance in thousands. Its usage and parameters are the same as the LineBalance function, with the exception of the Company parameter*. The LineBalance function is called then the following calculations are performed on the result: text/html 2010-07-21T18:50:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/lock_cells?rev=1279738242&do=diff Lock Cells Not Highlighted Rose Unlocked Mode Locked Mode [Lock Cells button (Unlocked mode)] [Lock Cells button (Locked mode)] Pressing this button will toggle between locking all of the cells on the worksheet (except for those highlighted in rose) and unlocking the worksheet. If the current worksheet is locked, the button will change its appearance. There are two main reasons you would do this: text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/parameters?rev=1690209187&do=diff Parameters This page provides a description of all of the parameters that are used throughout the GL functions in Excel. To Quote or not to Quote * Use quotes if you are using the actual data in the formula: =Balance("SC11","12/31/2009") * Don’t use quotes if you are text/html 2010-07-21T18:22:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/remove_cell_name?rev=1279736569&do=diff Remove Cell Name [Remove Cell Name button] Pressing this button will clear the cell name of the currently selected cell. If the currently selected cell has not been named, it does nothing. The reason you would do this is: * You named a cell and now you want that name to apply to a different cell text/html 2010-07-21T19:56:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/save_values?rev=1279742189&do=diff Save Values [Save Copy With Values Only button] Pressing this button will open up a dialog box that will allow you to save a special read-only copy of the current workbook. You can then give the saved workbook to someone who does not have access to the General Ledger functions. The cell values in the saved copy will look exactly the same as the original, however, there are a few important differences between the original file and the saved copy: text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/show_online_help?rev=1690209187&do=diff Show Online Help [Show Online Help button] Pressing this button opens up this online help page for the GL Excel Functions. Also, if the currently selected cell has a formula that contains one of the GL Excel functions, pressing this button will open the specific help page for that function. For example, if the cell formula is text/html 2017-06-07T18:49:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/sidebar?rev=1496861390&do=diff Function List * AvgBal * Balance * Budget * CallRptDescription * CallRptValue * Description * FedRptAvgBal * FedRptBalance * FedRptBudget * FedRptDescription * LineAverage * LineAverageRound * LineBalance * LineBudget * LineBudgetRound * LineColumn * LineDescription * LineRound * Version Parameters * AcctNum * AvgBalDate * BalanceDate * BudgetDate * ColDate * ColName * Concept * Company * LineCode * PosNeg * RptDate * StartDate * … text/html 2014-03-14T14:15:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/start?rev=1394806534&do=diff GL Functions for Excel [Toolbar Buttons for GL Functions in Excel] * Update GL Balances * Remove Cell Name * Lock Cells * Save Values * Show Online Help Function List * AvgBal * Balance * Budget * CallRptDescription * CallRptValue * Description * FedRptAvgBal * FedRptBalance * FedRptBudget * FedRptDescription * LineAverage * LineAverageRound * LineBalance * LineBudget * LineBudgetRound * LineColumn * LineDescription * LineRound * Version Param… text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/update_gl_balances?rev=1690209187&do=diff Update GL Balances [Update GL Button] Pressing this button will update all of the values in the current workbook that come from the GL program. In some cases it may also fix cells with the following error: #NAME?. There are three main reasons you would do this: text/html 2023-07-24T14:33:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://grandjean.net/wiki/gl_excel/version?rev=1690209187&do=diff Version This function returns the current version of the GL Functions add-in for Excel. It is mainly used for troubleshooting when new features are added. Version() Example Usage * =Version() Returns the current version number (eg, 10.2.11.1400)