Switch to English version?

Yes

Переключитись на українську версію?

Так

Переключиться на русскую версию?

Да

Przełączyć się na polską wersję?

Tak

Login
Registration
- Welcome to Freelancehunt
  
  Work risk-free, saving time and money
  
  Login Registration

Post your project for free and start receiving proposals from freelancers within minutes after publication!

11 USD

Screenshot Excell, to compare two files by field cross.

11 USD

Desktop Apps

6 out of 6

project complete

publication
open for proposals
terms confirmation
reservation
work underway
project complete

Project translated automatically. Log in or register, to view the original

A script that works according to the principle of the VPR function, capable of comparing two files and attributing conformity, the comparison goes through the "Cross" field.They compare two prizes of spare parts, the task- positions from the prize to List1, find the corresponding from the prize to List2.And present the information as on List3 !!The !Please note, now the information on List3 is incompatible, otherwise it has entered values manually, but it is presented as a sample for the presentation of information.The crosses are listed through the point with the back, respectively, we take the first value to the "point with the back" divider from the first cell of the cross field to List1 and seek it match throughout the massive-stage of the cross field from List2, !!The !It is important, we only take into account the "point with the back", then the second value, the same operation, etc.Furthermore, under the condition of coincidences of the values of the cross field, we attribute the correspondence otherwise "Article1-brand1-name1-price1=Article2-brand2-name2-price2" It is very likely that coincidences can be in several brands, in this case "Article1-brand1-name1-price1=Article2-brand2-name2-price2=...............=ArticleN-brandN-nameN-priceN" !!The !Important "Articles1 - Brand1 - Name1 - Price1" is the value of the reference price on List1 !!The !Important "Articles2-brand2-named2-price2=...............=ArticlesN-brandN-namedN-priceN" here the value of the price on List2 Please each additional matching mass to distinguish by a separate color, as on List3.The file in the application can be used to test, the cross field is matched, removed the extra divisors, all the values in the lower register.

Applications 1

Application viewing is only available registered users.

Client's review of cooperation with Vladimir Sokolets

Quality

Professionalism

Cost

Contactability

Deadlines

For excellent work! My recommendations!

Profile deleted | Safe

Freelancer's review of cooperation with client

Payment

Task setting

Clarity of requirements

Contactability

A great customer! Everything is adequate, contactful and understandable.

Vladimir Sokolets | Safe

Proposals 2

by default date online rating cost completion time

11 USD

Oleksandr Grib

19 1

11 USD

I write a macro to compare the cross field. Details to discuss.

Show original

Translate

22 March 2019, 10:11

Winning proposal11 USD

Vladimir Sokolets

28 2

Winning proposal11 USD

Ready to implement the project. It was the same in the car parts. It’s better to connect with Skype Sokolv555.

Show original

Translate

22 March 2019, 10:07

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 ∙ 4 days 18 hours back ∙ 10 proposals
Creation of software for generating cutting files for wooden puzzles We 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 ∙ 4 days 22 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 ∙ 6 days back ∙ 112 proposals	16 USD
Account reconciliation tool with the bank, cards, and accountant Technical 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 ∙ 8 days 7 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 ∙ 13 days 23 hours back ∙ 11 proposals

Profile deleted

Screenshot Excell, to compare two files by field cross.

Client's review of cooperation with Vladimir Sokolets

Freelancer's review of cooperation with client

Current freelance projects in the category Desktop Apps

Need an Airtable architect to build a relational schema and a new clean Airtable base.

Creation of software for generating cutting files for wooden puzzles

Small edit on the website

Account reconciliation tool with the bank, cards, and accountant

Add pauses of 10-30 seconds between sending emails.