Freelance projects

Freelance projects

Data parsing from 4 sources into Google Sheets

Data Parsing, Javascript and Typescript — incorrectly specified categories?

112 USD

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

The table calculates the cost of consumed electricity and compares it with 3 parallel accounts, kWh and the cost of electricity (from the Market Operator website),

revenues - are calculated based on the Ecofactor dashboard API.

https://docs.google.com/spreadsheets/d/1Q1YKGqa6ITc4cZhxutjhJ7KfnplZZBA-CSncPgA9ZGA/edit?usp=sharing

Data on the price of electricity is filled in every day at 16:00 for the next day.

Data on consumption and revenue for the previous day is filled in every day at 08:00.
A new table or tabs in the table are created every month.

Proposals 6 Rejected 2

Artem Plakha

Winning proposal

150 0

Budget: 5000 UAH Deadline: 5 days

Good day. I would like to clarify some points, but the idea is clear. I will be able to complete it.

Looking forward to working with you!

Oleksandr Stinkovyi

117 0

Budget: 5000 UAH Deadline: 2 days

Hello.

I am a NodeJS developer. I have experience with Google Sheets. I am ready to take on the task. Write to me, and we will discuss.

Vladislav Monad

1 0

Projects -
Rating -
Rating 293

Budget: 5000 UAH Deadline: 2 days

Oh, I have worked with this a bunch of times) feel free to reach out, I will gladly help!

Maksim Velichko

0 0

Projects -
Rating -
Rating 330

Budget: 4999 UAH Deadline: 2 days

Hello!

I am ready to set up automated accounting for electricity costs and revenues with full data synchronization. I will implement automatic retrieval of electricity prices (Market Operator), integration with the Ecofactor API for revenue collection, calculation of cost based on 3 parallel accounting of kWh, as well as daily data updates at the required time. I will set up automatic creation of new monthly tabs and verification of calculation accuracy.

I guarantee a neat table structure, stable automation performance, and clear calculation logic. I am ready to discuss the details and start as soon as possible 🚀

Oleg N.

53 0

Budget: 5000 UAH Deadline: 5 days

Hello! I am ready to complete your task, I have experience working on similar projects.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Pavlo Ivanchuk

4 0

Budget: 5000 UAH Deadline: 4 days

Hello! I have carefully studied the logic of your table. The task is clear: it is necessary to build a fault-tolerant system that synchronizes data from three different sources precisely at 08:00 and 16:00.

How I will implement your project:

24/7 Automation: Instead of simple scripts in the table, I will set up the operation through the API (Ecofactor) and parsing the "Market Operator" website with deployment on a server. This ensures that the data will be pulled in on time, even if the Google Sheet is closed.

Accuracy of calculations: I will implement a reconciliation algorithm between three parallel accounts of kWh to identify discrepancies in cost.

Clean structure: I will set up automatic logic for creating new tabs each month with data archiving so that the table does not lag.

Error control: I will add a notification system in Telegram if the data from the Ecofactor API or Market Operator is not received on time.

I have experience in deploying similar automation systems in Docker containers, which ensures maximum stability. I am ready to discuss technical details and start working.

Best regards, Pavlo.

Nick Osipov

41 4

Budget: 5000 UAH Deadline: 3 days

Good day!

I offer services for automating parsing and data integration. I have experience with web parsing (Market Operator), API (Ecofactor), and Google Sheets. I will set up daily updates of prices, consumption, revenues, and monthly creation of tabs.

Feel free to contact me!

Dmitro Bur
Odessa, Ukraine

Projects 3
Rating -
Rating 209