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")
China34Hong Kong
China103Beijing
Finland76Helsinki
France62Paris
Germany86Frankfurt
Japan56Tokyo
New Zealand21Wellington
Singapore29Singapore
United Kingdom59London
United States13San Francisco
United States42New York
United States91Chicago

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