Data parsing from 4 sources into Google Sheets
111 USD 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.
Applications 4
-
Winning proposal5 days111 USD
Winning proposal5 days111 USD
Good day. I would like to clarify some points, but the idea is clear. I will be able to complete it.
-
2 days111 USD
293 1 0 2 days111 USD
Oh, I have worked with this a bunch of times) feel free to reach out, I will gladly help!
-
2 days111 USD
328 2 days111 USD
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 🚀
-
2 days111 USD
9944 117 0 2 days111 USD
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.
-
5 days111 USD
1901 53 0 5 days111 USD
Hello! I am ready to complete your task, I have experience working on similar projects.
-
4 days111 USD
834 4 0 4 days111 USD
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.
-
3 days111 USD
4975 41 4 1 3 days111 USD
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!
Odessa