Færdiggjort

Transform a dictionary into a termbase

I'm looking for an excel macro expert to transform a dictionary (Polish English) into a termbase (input file to be imported to Memsource CAT software). The input file is attached for your perusal - in consists of 61031 entries, sample input entry, steps I took to create final termbase for that entry and the final termbase for that entry. The output file needs to comply with the following criteria:

1. Terms organized into columns where each column represents a language

2. Make sure there is the appropriate language code in the header of each column (in our case pl, en)

INPUT FILE

Example of dictionary entry:

analiza f 1. analysis 2. chem. analysis 3. mat. analysis; calculus

~ absorpcyjna absorption analysis

first word "analiza" is the Polish term

letter "f" "m" "a" means feminine, masculine, neuter

1. 2. 3. numbers denote different versions of translation depending on context

"chem." is an abbreviation from chemical and means the area of subject matter

"analysis" is the English term

"~" means that the following term is a child term and is created by joining parent term "analiza" and child term "absorpcyjna" to create the term "analiza absorpcyjna"

"absorption analysis" is the English child term

OUTPUT FILE STRUCTURE

The basic structure of the output file needs to be this:

column A: Polish term

column B: English term

column C-X: second and next (if available) English term

QUALITY ASSURANCE (QA)

1. Check for blank rows (present in source file) and remove them

2. Convention "zob." means "refer to" and it sends to a Polish terms of the same meaning. Use the macro to lookup that synonymous term and insert it's English equivalent

3. Check that the number of Polish & English terms is equal

4. Subsequent english terms are divided by a comma "," OR and a semicolon ";"

5. Bracketed sentences are explanations - they can be ignored and don't need to be included on the output files

6. Abbreviations like "mat." or "chem." denote subject matter areas and are redundant - should be ignored and excluded from output file. The English term is located directly after those abbreviations. How to recognise those abbreviations? They are usually incomplete words with a "." (dot) directly after last letter in the word.

7. Remove entries shorter than 3 letters (1 and 2 letters long)

8. There are some cells where there's no distinguishable marker between terms eg.

"~ ~ wielu zmiennych multivariate analysis of covariance"

In that instance, the macro should also check for language to check where Polish term ends and where English one begins

9. Spot-check your work - I will spot-check random 900 entries to ensure proper quality and structure

IDEAL CANDIDATE:

1. Self-reliant, self-starter

2. Highly experienced in writing Excel macros and/or data analytics and/or data science

3. Great mathematical problem solver capable of building complex algorithms

MILESTONES:

For 100% payment I require the below milestones are adhered to and that the working files and shared with me for acceptance accordingly.

I. Polish terms column is created and passes 300 entry spot check by me

II. English terms columns are created and pass 300 entry sport check by me

III. Final term base is created, has correct structure, equal amount of terms for Polish and English terms and passes 300 entry spot check by me AND successfully loads into MemSource CAT software.

Evner: Databehandling, Excel, Matematik, Matlab and Mathematica, Statistikker

Se mere: mp3 files need help transcribing, need dictionary database, need merge files, need upload files script, need cdr files laser engraving, perl global variables included files, need fla files update, need cad files architect, need rdl files created, need match files excel, i need a sash designer script like pride pageant, manually type from images into excel files -- 6, manually type from images into excel files 6, need to create calling application like skype, is there a need for vda 6.3 auditors in the usa, saps application how many do they need kwamashu, need a delphi 6 programmer, need develope to make website like booking com, I need job based on handwriting like notes records writing etc., I need a facebook cover. I like black and white or grey background. This is for a real estate facebook page cover photo. My logo

Om arbejdsgiveren:
( 0 bedømmelser ) Poland

Projekt ID: #19408416

Tildelt til:

apstewart

Here is my proposal: PLATFORM - Convert the input file to UTF-8 encoded CSV format. - Use a custom Java application to process the data. Java has excellent Unicode support. DATA - The provided input file - F Flere

$140 USD in 7 dage
(0 bedømmelser)
0.0

7 freelancere byder i gennemsnit $176 på dette job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Flere

$250 USD in 4 dage
(332 bedømmelser)
7.9
Friends4it

We already have built large scale applications, CRMs, ERPs and huge systems can be found at our website. Like [login to view URL] [login to view URL] [login to view URL] [login to view URL] https: Flere

$250 USD in 9 dage
(3 bedømmelser)
2.6
translatorgurus

Dear Sir/Madam! If you're searching an experienced typist to type your document, with a rapid turnaround, then you've found TranslatorGurus. We have provided our clients with thousands of articles, eBooks, technical Flere

$30 USD på 1 dag
(2 bedømmelser)
2.2
akkijhamta

hello, I will do this project for you, as you mentioned in detail. kindly send me your project detail so we can discuss further detail/ its should be a professional work that i will do in the time. it to be a best meet Flere

$35 USD in 3 dage
(3 bedømmelser)
1.9
dpdpdp

I am professional in Data Processing, Excel, skills, especially I have working experience in the company before I apply for freelancer.com

$277 USD in 10 dage
(1 bedømmelse)
1.4
VDSSI

Very good day my name is Abner Velasco I am an application developer specialized in Microsoft technology, I would like to help you with your project

$250 USD på 1 dag
(0 bedømmelser)
0.0