Excel Add-in for PCode matching. This tool helps to match location names with the standard list and return PCODEs. The tools is designed using fuzzy string matching algorithm for pcoding locations in a batch. It returns list of locations to interactively choose from if the sensitivity is below certain threshold. The tool can be adapted to any country's administrative list or any generic list of names.
refer pcode_data.xlsx file for the preparation of standard list and setting tables.