Periodically Microsoft Excel's cached version of various add-ins become corrupted and stop working as expected or at all. The most common indicator this has occurred is that singlepane add-in formulas will appear with xludf_ in front of them and will not refresh. If this occurs, follow the procedure below (Exactly) to reload the add-in: Go to File menu in excel Click options in bottom left Select the Trust Center tab Click the Trust Center Settings button Go to Trusted Add-I

SP.OTB allows you to pull data from the singlepane on-the-books/reservation database. SP.OTB has the following arguments, which can...

SP.FILTER returns an array of property codes based on a series of up to five filters. This is primarily designed to be used in...

SP.FINANCIALS_AGG works identically to SP.FINANCIALS, however excepts a set of hotel codes and pulls an aggregated value for the list of...

SP.STR allows you to pull data from the singlepane STR database. SP.STR has the following arguments, which can either be entered directly...

SP.FINANCIALS allows you to pull data from the singlepane database for any financial/GL account in our chart of accounts. This includes...