This is a short video demonstrating how we can use Excel formulas and AI to intelligently compare dissimilar lists by using key words that enable matches to be identified.
In this example, a client has a list of Product Descriptions and Product Codes. We need to match the customer’s products to the client’s Product Descriptions, in order to return the appropriate Product Code.
We first use Excel to look for any previously matched product descriptions and return the matching Product Code – these cells are then coloured in yellow.
Click the Search Ranges button to use AI to categorise any unmatched products and find the closest match. Where there is a one appropriate match, it colours the cell in blue. If there are multiple possible matches, it allows the user to select the best match and colours the cell in green. It will then proceed to apply that logic to similar products thereafter until all matches are made. If there is no match to be made, the user selects None.
They can also correct any incorrect matches using keywords – these corrections will be coloured in purple.
In our interconnected global landscape, effective communication is key. Whether you are a business expanding into new markets or an individual seeking to connect with a diverse audience, language barriers can pose significant challenges. Fortunately, the synergy between Microsoft Excel and OpenAI API offers a powerful solution for overcoming these hurdles, facilitating seamless translations into multiple languages.
Excel’s integration with external APIs opens up new possibilities, such as language translation, where Excel becomes a conduit for harnessing the power of OpenAI’s language models.
Building a custom text string to send to OpenAI that can be changed as required by VBA Macro.
Automating the translation process within Excel streamlines workflows, saving time and effort. Excel’s scalability makes it easy to apply translation services to large datasets or documents.
Tailor the integration to suit specific translation needs, such as choosing target languages and handling different text formats.
OpenAI can be used to correct any spelling, spacing, and formatting errors in the original data before translation. Also, OpenAI can be used to accurately change the text’s case where and when required both on the original and translated text. All very useful when handling scraped data.
By combining the robust capabilities of Microsoft Excel with the advanced language processing provided by the OpenAI API, users can break down language barriers effortlessly. This integration not only simplifies the translation process but also opens up new possibilities for effective communication on a global scale. Whether you’re a business looking to expand internationally or an individual seeking to connect with a diverse audience, the Excel and OpenAI partnership offers a powerful solution for seamless multilingual communication.
Example of English into German (proper case)
Example of spelling correction and converting from Upper to Proper case.
In this case it could have interpreted WRNG as wrong, but because it is contextual, it corrected it read wiring.
