Google sheet challenge - count keywords in text on one tab and add totals to another
Budget: $250 – $750 USD
Lots of text processing needed. We need this done in google sheets. Please don't ask to do it in Excel
Tab #1 (Targets) has 4 text blocks in columns in pairs N & AB, S & AG, these need to be scanned for keywords listed in TAB #2 (synonyms)
The output will go into columns BN-ET (you can see listed anchor terms there). format will be 4 numbers separated by commas which are the total counts for (P, U, BG, & BL) (in that order).
How to compute counts:
In "tab: Synonyms" for the anchor term has a list of synonyms in columns M-CI
For example: Diligence has 40+ synonyms like (continuity, integrality, continuality, etc)
You are to scan the text block in columns (P, U, BG, & BL) and count the number of occurrences of any of the target words.
Example if "continuity" is found once, and "Continually" is found once, the score = 2. These are synonyms for the first anchor term "Diligence" so Diligence is set a score = 2.
This process is to be done for each block (P, U, BG, & BL)
-some synonym cells are marked as "##" these are to be ignored
There is 1 additional calculation in the scoring. You must look at each text block as 4 equal parts, based on the length of the entire text block. On the tab "Coefficients" are 4 values. example:
Found first 25% 1
Found 2nd 25% 0.75
Found 3rd 25% 0.5
Found 4th 25% 0.25
If the synonym is found in the first 25% of the text block, it gets a full score of 1, if it is found in the last 25%, that value of .25. This is to ensure words higher in the page are weighted more. We have these as values in the sheet as we do not want to hard code it.
If you look at the sheet in view only mode, you can view the columns and tabs I have discussed.
https://docs.google.com/spreadsheets/d/1R-i6U8FJXzoYLWAyXe4ZTEAZd8n5zPWWIcB_19zRkIo/edit#gid=1400674550
We are looking for a talented developer for this to be done correct and professionally. The process should be kicked off from an added "Actions" menu with command "VCP Process". We need daily communication
You are a professional if you have read this far. Prove it. Put the name of your favorite COLOR as the first word in your bid. This will show us you have attention to detail
You only need to focus on the first 3 tabs in the sheet, the rest you can ignore. Our Max is $300 for the project.
Good luck!
Tab #1 (Targets) has 4 text blocks in columns in pairs N & AB, S & AG, these need to be scanned for keywords listed in TAB #2 (synonyms)
The output will go into columns BN-ET (you can see listed anchor terms there). format will be 4 numbers separated by commas which are the total counts for (P, U, BG, & BL) (in that order).
How to compute counts:
In "tab: Synonyms" for the anchor term has a list of synonyms in columns M-CI
For example: Diligence has 40+ synonyms like (continuity, integrality, continuality, etc)
You are to scan the text block in columns (P, U, BG, & BL) and count the number of occurrences of any of the target words.
Example if "continuity" is found once, and "Continually" is found once, the score = 2. These are synonyms for the first anchor term "Diligence" so Diligence is set a score = 2.
This process is to be done for each block (P, U, BG, & BL)
-some synonym cells are marked as "##" these are to be ignored
There is 1 additional calculation in the scoring. You must look at each text block as 4 equal parts, based on the length of the entire text block. On the tab "Coefficients" are 4 values. example:
Found first 25% 1
Found 2nd 25% 0.75
Found 3rd 25% 0.5
Found 4th 25% 0.25
If the synonym is found in the first 25% of the text block, it gets a full score of 1, if it is found in the last 25%, that value of .25. This is to ensure words higher in the page are weighted more. We have these as values in the sheet as we do not want to hard code it.
If you look at the sheet in view only mode, you can view the columns and tabs I have discussed.
https://docs.google.com/spreadsheets/d/1R-i6U8FJXzoYLWAyXe4ZTEAZd8n5zPWWIcB_19zRkIo/edit#gid=1400674550
We are looking for a talented developer for this to be done correct and professionally. The process should be kicked off from an added "Actions" menu with command "VCP Process". We need daily communication
You are a professional if you have read this far. Prove it. Put the name of your favorite COLOR as the first word in your bid. This will show us you have attention to detail
You only need to focus on the first 3 tabs in the sheet, the rest you can ignore. Our Max is $300 for the project.
Good luck!