Creating YSL Reports : Basic YSL Report Writing Procedures : Entering YSL Functions
Entering YSL Functions
In YSL, you can enter YSL functions with the Right-Click Function Builder, an intuitive interface that shows all the available YSL functions by category, along with their respective parameter values. For more information about accessing YSL functions, see “To enable macros: YSL.Net”. For more information about each YSL function, see Appendix A, “YSL Function Definitions.”
You can also enter a function using the standard Excel method, but the Right-Click Function Builder offers enhanced functionality not available to the standard method of inserting functions into a cell.
The YSL Right-Click Function Builder cannot insert multiple YSL functions into a single cell.
The following procedures describe how to enter the AccountRange function into a cell using the YSL right-click interface.
Excel 2000 is used in the following example. Your program might appear differently, depending on your version of Excel.
To enter a YSL AccountRange function: YSL Classic
The following procedure is illustrated using Excel 2000-2003. If you use a version of Excel other than 2000-2003, the commands and screens may be different from those described in this procedure.
1
From the Excel top menu, select File > Open.
2
Select and open the YSL report.
3
Select the cell that you want to contain the function.
YSL account functions can only be entered into Column A.
4
Right-click, then select YSL Functions > Account > Account Range.
5
If this is the first time you use the Right-Click Function Builder at design time, a message appears asking if you would like to make a database connection.
a
Click Yes to connect to a database. The Yardi Spreadsheet Link Design Time Database Connection screen appears.
b
Complete the fields, as needed.
c
Click Connect. A message appears saying the database connection has been successful.
d
Click OK. The program returns to the YSL report.
6
The Insert YSL Function AccountRange screen appears.
If you selected the YSL option Set YSL Design Helper file location, the drop down lists are automatically populated each time you design a YSL report. For more information, see “To set YSL user options: YSL.Net”, and “Downloading YSL Design Helper: YSL.Net”.
7
Complete the fields, as needed.
8
Click OK. The account range is entered into the cell.
To customize the Right-Click Function Builder: YSL.Net
The following procedure is illustrated using Excel 2010. If you use a version of Excel other than 2010, the commands and screens may be different from those described in this procedure.
1
From the Excel top menu, click File.
2
From the side menu, click Open, then locate and select a YSL workbook.
3
Click Open.
A YSL work book must be open before you can customize the Right Click Function Builder.
4
From the Excel top menu, select Add-Ins > Set YSL Options. The Yardi Spreadsheet Link User Options screen appears.
5
Click the Voyager YSL Design Helper tab, then click the Customize Menu button. The following graphic appears.
6
Click Favorite for each YSL Function that you want to add to a Favorite category in the Right-Click Function Builder menu.
7
Click Hide for each YSL Function that you want to hide in the Right-Click Function Builder menu.
8
Click Apply to save changes and leave the screen open, or click OK to save changes and close the screen.
To enter a YSL AccountRange function: YSL.Net
The following procedure is illustrated using Excel 2010. If you use a version of Excel other than 2010, the commands and screens may be different from those described in this procedure.
1
From the Excel top menu, click File.
2
From the side menu, click Open, then locate and select a YSL report.
3
Click Open.
4
Select the cell that you want to contain the function.
YSL account functions can only be entered into Column A.
5
Right-click, then select All YSL Functions > Account > Account Range.
6
Select the beginning and ending account ranges from the drop-down lists.
7
Click OK. The account range is entered into the cell.