Bohdan Kliuchka
Offer Bohdan work on your next project.
Private message 
Offer work 
Kharkiv,
Ukraine
2 days 21 hours back
available for hire
2 proposals made
age 23 years
on the service 2 days 23 hours
Rating
Successful projects
Average rating
Language proficiency level
Українська: fluent
Skills and abilities
Outsourcing & consulting
Portfolio
-
7 USD Automated system for checking and validating dates in Google Sheets
Enterprise Resource Planning (ERP)
A complex formula has been developed based on ARRAYFORMULA, MAP, LAMBDA, LET, and LOOKUP, which automatically finds, analyzes, and verifies the correctness of dates between different tables without using scripts.
Key functions of the solution:
Mass processing of records through ARRAYFORMULA and MAP.
… Automatic search for the last matching record in an external table by unique identifier.
Highlighting individual components of the date:
- day;
- month;
- year.
Converting the textual representation of the date into Google Sheets date format.
Checking the correctness of the date structure:
- presence of delimiters;
- correct length of the record;
- valid range of years;
- correspondence of day and month to the actual calendar date.
Automatic filtering out of incorrect or corrupted values.
Error handling through IFERROR, preventing failures when working with large data arrays.
Returning only valid dates for further use in business processes.
Technologies used:
- Google Sheets
- ARRAYFORMULA
- MAP
- LAMBDA
- LET
- LOOKUP
- IFERROR
- Working with dates and time values
- Logical data validation
Business result:
The created solution has allowed for the automation of data quality control in large tables, eliminating errors from manual date checks and ensuring the correctness of information before further processing or reporting.
-
7 USD Automated system for data search and matching in Google Sheets
Enterprise Resource Planning (ERP)
Complex formulas based on LET, MAP, ARRAYFORMULA, REGEXREPLACE, XLOOKUP for automatic searching and matching of records between multiple tables without using scripts.
Key functions of the solution:
Automatic processing and normalization of text data:
… conversion to lowercase;
removal of extra spaces;
cleansing of special characters and non-breaking spaces.
Mass data processing through ARRAYFORMULA.
Finding matches between several sheets under complex conditions.
Using logical filters to select only the necessary records.
Building a backup search mechanism:
primary search in the main database;
automatic switch to an alternative data source in case of no results.
Processing large data arrays without user manual intervention.
Automatic return of up-to-date information in real-time.
Technologies used:
Google Sheets
LET
MAP
LAMBDA
ARRAYFORMULA
REGEXREPLACE
XLOOKUP
Logical arrays
Text data processing
Business result:
The created solution allowed for the complete automation of the process of searching and linking data between multiple tables, reducing the amount of manual work for operators and minimizing errors in information processing.
Activity
| Latest proposals 2 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Working with tables
300 USD
|
|||||
|
Adding data to Google Sheets
23 USD
|
