Freelance projects

Freelance projects

2 Macro VBA in Excel

Data Parsing, Desktop Apps — incorrectly specified categories?

11 USD

Client's review of cooperation with Oleg M.

2 Macro VBA in Excel

11 USD

Everything is great, I recommend! I did better than I needed!

5.0

Nikolay Oli

Reciprocal Feedback

28 August 2021

Freelancer's review of cooperation with Nikolay Oli

2 Macro VBA in Excel

11 USD

In fact, the task is more difficult than it seemed at first. But with Nicholas, they checked everything, made it foolish and even increased the budget a little bit. I will be happy with new orders.

5.0

Project translated automatically. Log in or register, to view the original 2 macros on 1 topic - work with cadastral numbers and the area of land areas.An example of calculation.Macro No. 1 On the first list there is a standard type of state.Examples on land areas (will be uploaded by the user to Excel from PDF).Example of the "Data Introduction (Macro 1)" sheet.In the file a short example, and in real life 10,000+ lines.From the lines on the first list, the macros must load all the numbers from these pieces of text (lighted red in the document): Number of registration: 1234567 * Description of the object: Area (ga): 0.9452 Date of expiry: 31.12.2028 And then the macro must load out 3 columns on the second sheet, starting from cells A2, B2 and C2 (Exit macro 1).I will give examples of these people.A list to whom you need to understand better.They are 99% standard.Sometimes the lines can change in places, but the text is the same everywhere.Macro No. 2 Example on the list "Data Introduction (Macro 2)" and "Exit (Macro 2)".The user enters the data in the columns A, B and F. Macros takes all the areas from the columns A:B (but only the areas with the data in the columns F = 1).The macros forms several text blocks, a maximum of 80 parts in 1 block (we have a system limit of 80 cadastroes per 1 block...)by the text given from cells, as in the example.In the text, you will need to use 1 formula (fertility * seed).The macro removes the text fields to the next sheet (Macro output 2).There are examples.Important: Calculations should be done inside the massive, not on the screen (to accelerate the work of the macro) Both macros need to be created in the file in the deposit so that I can test by entering other state outlets on the first and third sheets.

Proposals 2

Oleg M.

Winning proposal

109 0

Projects 105
Rating -
Rating 1 115

Budget: 500 UAH Deadline: 1 day

Hello to Nicholas.
I specialize in macros for Excel. There are a lot of relevant reviews in the profile.
I got acquainted with the TZ and the example of the file.
I can write the necessary macros in a few hours. I do it immediately upon approval of the project.
For the first macro tests, more source data will be required.

Serhii D.

38 0

Projects 39
Rating -
Rating 1 134

Budget: 500 UAH Deadline: 1 day

Good day . Get acquainted with the task. I know how to accelerate the work of the macro. I will do everything under the right buttons in that file.
Excel and everything related to it for many years has been my main work tool.

Current freelance projects in the category Data Parsing

Parsing the product catalog into a universal Excel/XML (UA/RU) for Prom.ua, Khoroshop, and other CMS.

38 proposals 10:11

Not specified
Collection of phone numbers from olx.pl

36 proposals 3 August

Not specified
Autoria Parser

72 proposals 2 August

Not specified
Reddit API

Web Programming 29 proposals 30 July

Not specified
Website parsing, bypassing Akamai protection

Python 47 proposals 30 July

Not specified

Nikolay Oli
Kyiv, Ukraine

Projects 7
Rating -
Rating 250

Nikolay Oli

Oleg M.

Oleg M.

Serhii D.

Proposals are currently absent

Current freelance projects in the category Data Parsing

Parsing the product catalog into a universal Excel/XML (UA/RU) for Prom.ua, Khoroshop, and other CMS.

Collection of phone numbers from olx.pl

Autoria Parser

Reddit API

Website parsing, bypassing Akamai protection