Extend Semantic Map based on X/Y coordinates

NFG

New Member
Joined
Jun 9, 2024
Messages
1
Office Version
  1. 2013
Platform
  1. Windows
SITUATION
An Excel sheet with 3 columns:
1. Column A - 28 personality traits (e.g. adventurous, reliable, etc.). The 28 personality traits are labeled using 1 word.
2. Column B - X coordinate of the personality trait (between 0 and 100)
3. Column C - Y coordinate of the personality trait (between 0 and 100)
QUESTION
Who can help to add 32 personality traits to the existing 28, so the total will be 60?
MrExcel helped me before with a useful VBA to find synonyms, that solution can be found here
For me it is important that the new personality traits have reliable X/Y coordinates.
My guess is that can be done using tools that make use of words and context and visualization.
Examples are synoniemen.net , lexipedia.com and others. My guess is they make use of Wordnet.
Looking forward to helpful suggestions.
Thanks in advance, kind regards. NFG
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,223,886
Messages
6,175,190
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top