Adjust the advanced settings to have better control over generated output in Microsoft Excel. You can learn more in the OpenAI API documentation.
|Top P||Helps adjust creativity level - Lower values result in more focused output, while higher values allow for more creative responses. |
Note: Set the temperature parameter to 1 when using Top P.
|Frequency penalty||Penalizes tokens based on their frequency in the training data - Higher values encourage less repetitive words or phrases.|
|Presence penalty||Penalizes new tokens based on how often they have occurred in the input - Higher values discourage repetition.|
In the GPT in Excel sidebar, click Settings.
Open the View advanced settings dropdown.
Set the values of:
Top P: from
Set the temperature parameter to 1 when the value for Top P is lower than 1.
Frequency penalty: from
Presence penalty: from
You can now execute a GPT function in the current workbook with these advanced settings.
Refresh your GPT formulas to get results that take these new settings into account.