Tools for the processing of market semantics
45 USD ID - Iddy Revelation
Category_id - Aidi Category
country_id - the country's id
user_id - idy list
created_time - date of creation of the manifestation
Description - Text of the description of manifestation
1 .It is necessary to write a macro to break the description of manifestation.
(description) to words (to bring everything to small letters, ) to a separate sheet with a structure
country_id - the country's id
word - word from the text of description
ad_count - the number of manifestations in which this word is found
The words are sorted by the alphabet from A to I.Visit the Word tab https://take.ms/QIQSQ
2ndDetermine the roots of words to search for entries on revelations using the Word entries as a source.(a)Guide the Cluster tab to the column B https://take.ms/V5ovL .(b) to calculate in Table B the number of manifestations in which the roots are described (but others may also be found)
(c) to be included in St. C. Calculation of the number of manifestations in which only this root is found in the description (other cannot)
(d) predict that the column A will be filled with hands based on the contest of manifestation and the root itself;
ThreeIn the tab of Revelation to remove all revelations with the structure on the columns
ID - Iddy Revelation
Category_id - Aidi Category
country_id - the country's id
user_id - idy list
created_time - date of creation of the manifestation
Description - Text of the description of manifestation
and separately in the column to remove all the clusters from the Cluster (Column A) and the corresponding keys (Column 😎 https://take.ms/ymyVVC.At the same time, in the anti-key and description cell put 1, if the description has this key https://take.ms/5Zu23
Extend the calculation from the Cluster tab also into the columns corresponding to the key and cluster
(b) to calculate in Table B the number of manifestations in which the roots are described (but others may also be found)
(c) to be included in St. C. Calculation of the number of manifestations in which only this root is found in the description (other cannot)
Applications 1
Client's review of cooperation with Ivan Moroz
Tools for the processing of market semanticsThank you, all in time and accordingly! I recommend
Freelancer's review of cooperation with Y H
Tools for the processing of market semanticsThe description is clear and constant in case of questions. Understanding what is needed as the final result.
A pleasant person in communication and understanding relates to work.
I definitely recommend!
-
Winning proposal3 days45 USD
744 99 0 Winning proposal3 days45 USD
Hello to you,
I do it quality and quickly. Experience in Excel VBA over 5 years. You can see in the reviews.
I will be happy to help!
Current freelance projects in the category Desktop Apps
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 3 days 6 hours back ∙ 10 proposals |
Creation of software for generating cutting files for wooden puzzlesWe are looking for a developer to create software that automates the process of building cutting files for wooden jigsaw puzzles. Current Process Currently, each file is created manually by a designer in Adobe Illustrator. The file contains: the outer contour of the puzzle in… Desktop Apps ∙ 3 days 11 hours back ∙ 14 proposals |
Small edit on the website
16 USD
Need to update the offer agreement in the footer to a new one, the company has changed its regulations Task will take 20 minutes Web Programming, Desktop Apps ∙ 4 days 12 hours back ∙ 111 proposals |
Account reconciliation tool with the bank, cards, and accountantTechnical Assignment: Tool for Reconciling Accounts with Bank, Cards, and AccountantGeneral Goal A local tool (script/small application in Python) is needed, which is manually run once every 1-2 months on my computer and performs reconciliation between: Invoices I issued to… Python, Desktop Apps ∙ 6 days 19 hours back ∙ 44 proposals |
Add pauses of 10-30 seconds between sending emails.
Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 12 days 11 hours back ∙ 10 proposals |
Kyiv