User Guide
Access the user guide at any time.
This task pane provides access to our online documentation from inside Excel.
If you would prefer to read the documentation in a browser, copy and paste the following link:
link - bettersolutions.com/addins/excel-custom-functions
![]() |
Add Sample Data
For example "COUNTRY-VALUE-CITY" will enter a table of data showing 12 countries with a value and a code.
This function populates a range with (3 columns and 12 rows).
=JS.SAMPLEDATA("Country-Value-City") |
China | 34 | Hong Kong |
China | 103 | Beijing |
Finland | 76 | Helsinki |
France | 62 | Paris |
Germany | 86 | Frankfurt |
Japan | 56 | Tokyo |
New Zealand | 21 | Wellington |
Singapore | 29 | Singapore |
United Kingdom | 59 | London |
United States | 13 | San Francisco |
United States | 42 | New York |
United States | 91 | Chicago |
Replace Functions
It is possible to quickly replace all the functions with formulas or values.
Quickly replace these functions with temporary values to allow for sharing.
Quickly replace these functions with equivalent Excel formulas (if they exist).
This allows you to share a workbook with someone else who does not have the add-in installed.
<< this is still in development >>
Sharing a File
If you add JS functions to a workbook, that workbook can be shared.
When the workbook is opened , the following task pane will automatically appear if the user does not have the add-in already installed.
Pressing "Accept and Continue" will then load the add-in for that particular user.
![]() |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext