Valentyn S.
Private message
Offer work
Odessa,
Ukraine
available for hire
Rating
Skills and abilities
Portfolio
-
Extension for Google Workspace (Sheets Docs)
Data Processing
An extension for Google Sheets and Google Docs that allows converting numbers into their written form in Ukrainian. In Google Sheets, formulas are added that take a number and other additional parameters as input, and output the sum in words. For example, 123 => One hundred twenty-three.
Additionally, a menu is added to Google Sheets and Google Docs that allows this conversion to be done not through a formula, but directly in a window, as an additional function, without leaving the interface of Sheets/Docs.
-
Fillers of documents
Enterprise Resource Planning (ERP)
The script is built-in in the Google Spreadsheet (Google Table), which creates a document based on the Google Document template and the data in the table.
The script introduces a copy of a template of values from a table.
The plus:
Do not forget to enter any data in the document.
… You can enter the value and use it several times in the document.
* in the table you can use formulas to automatically calculate derivative values (e.g. VAT)
* in the table you can use formatting, the document will get the value in the right format (this is convenient, for example, when working with dates)
HTTPS://drive.google.com/uc?export=view&id=1U817YCNf4vSmEIKWMPWim3E76wN1At54
-
Google Calendar + Spreadsheet
Data Processing
Often convenient data editing and convenient viewing (use) look and work completely differently.
Seeing DTEC graphs (and not only) would be convenient in your calendar, but it is not always convenient to enter these graphs in the calendar interface.
In this case, it is much more convenient and faster to edit information through a table.
…
We combine and receive:
https://drive.google.com/uc?export=view&id=1aPVe_ms5bHPrzuzQjLZ2uv4z8WBjULgV
-
The Telegram Bot
Data Processing
The boat that follows the appearance of auctions in Prozorro.Sale according to the specified criteria and sends notifications.
Background: Google Apps Script + Spreadsheet (as a database)
Integrated Payment System of WayForPay
-
Telegram bot UkrTenderbot
Bot Development
The boat that monitors the appearance of tender in Prozorro according to the specified criteria and sends notifications.
Background: Google Apps Script + Spreadsheet (as a database)
Integrated Payment System of WayForPay
… HTTPS://sites.google.com/view/ukrtenderbot
#GoogleAppsScript #Telegram-bot
Reviews and compliments on completed projects 5
4 March 2023
23 USD
[SN] Explore the technological steak of the project
Great work, we continue cooperation.
| Personal | Response review
25 February 2023
18 USD
Write documentation for the project
Great work, done quality and in time.
| Personal | Response review
21 February 2023
29 USD
[Valentyn Salamakha ] Improvements in the script
Great work, we continue to work together.
| Personal | Response review
18 February 2023
50 USD
[SM] Writing Google Apps Script to verify accessibility
Public work, done more seriously than I expected, a very proactive approach
|
7 February 2023
36 USD
Writing a few Google Apps Script/JavaScript
Valentine very quickly understood the requirements and what to do (although it was quite difficult to understand in the Google table), and even proposed improvements I didn’t think about and didn’t know what it was possible. All questions were answered in time, in time. Everything is done professionally and quality.
I really want to note the fact that in the summer I got everything, that is, I didn’t have to spend time on it to brush everything.
Activity
| Latest proposals 9 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
[SN] Explore the technological steak of the project
23 USD
|
|||||
|
Automatic completion of contracts by data by template (MACROS)
34 USD
|
|||||
|
Write documentation for the project
18 USD
|
|||||
|
[Valentyn Salamakha ] Improvements in the script
29 USD
|
|||||
|
Creating a basic fan account in Google Sheet
18 USD
|
|||||
|
[SM] Writing Google Apps Script to verify accessibility
50 USD
|
|||||
|
Автоматическая синхронизация контактов гугл таблицы с гугл аккаунтом
23 USD
|
|||||
|
Account of sales
18 USD
|
|||||
|
Writing a few Google Apps Script/JavaScript
36 USD
|