READ ALL BEFORE BIDDING - Google sheet challenge - count keywords in text on one tab and add totals to another
Budget: $30 – $250 USD
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 AI-DO columns (you can see listed anchor terms there). format will 4 numbers separated by commas which are the total counts for N, AB, S, AG (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 N, AB, S, AG 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 A, AB, S, AG
-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/1etH-2hhOz66DWX6NiQRmm3faUnvaSxS0B1k_alt4m0c/edit#gid=1400674550
We are looking for a talented developer and will pay $200 for this to be done correct and professionally. The process should be kicked off from an added "Actions" menu with command "VCP Process"
You are a professional if you have read this far. Prove it. Put the name of your favorite Google Sheets or Excel add on 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.
-Do not offer to do this in Excel
-Do not spam us with a generic bid (instant delete)
-Do not chat us with stupid questions that are covered in the description
Good luck!
The output will go into AI-DO columns (you can see listed anchor terms there). format will 4 numbers separated by commas which are the total counts for N, AB, S, AG (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 N, AB, S, AG 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 A, AB, S, AG
-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/1etH-2hhOz66DWX6NiQRmm3faUnvaSxS0B1k_alt4m0c/edit#gid=1400674550
We are looking for a talented developer and will pay $200 for this to be done correct and professionally. The process should be kicked off from an added "Actions" menu with command "VCP Process"
You are a professional if you have read this far. Prove it. Put the name of your favorite Google Sheets or Excel add on 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.
-Do not offer to do this in Excel
-Do not spam us with a generic bid (instant delete)
-Do not chat us with stupid questions that are covered in the description
Good luck!