How do I convert Excel add-in V1 (legacy) formulas to V2?
Here are the steps to do so. The transition from the legacy V1 Excel add-in to the V2 version is essential to ensure continued functionality and support for your spreadsheets. Migrating allows users to maintain functionality and take advantage of ongoing improvements.
The V1 Excel add-in is no longer supported or available for download. To ensure your spreadsheets remain functional, migrating to the updated add-in is necessary.
Official migration guidance is available to help users smoothly transition their formulas and reduce errors through mapped documentation.
1. Hover over the cell with the V1 formula.
2. Open the relevant Kpler add-in V1 box/endpoint.
3. Review parameters used in filters/columns.
4. Close Kpler add-in V1 box.
5. Replicate the parameters from V1 into the Kpler add-in V2 including all filters and columns.
6. Click on RUN to replace the V1 formula in the cell.
How do I use the hash formula to maintain the columns from V1 to V2?
The hash is a string of alphanumeric characters that users can find in the query, just replace the existing hash in V2 with the old hash from V1. Using the hash ensures compatibility between old and new formulas, streamlining the migration process and reducing manual effort.
This will ensure that the columns users see in V2 are the same as the ones they had in V1.
How do users avoid formulas from disappearing?
Users must ensure that there is an empty column between data sets to prevent the extracted data from overlapping with the next formula.