Fix data parsing in Excel

"Hello! I have reviewed your task and the WinError 10061 issue. It occurs due to a disconnection between the browser driver and the script during prolonged operation.
Here’s how I propose to solve the problem:

Stability 24/7: I will add exception handling to the code. If the script loses connection, it will automatically restart the session without your involvement.
Write optimization: I will implement buffered writing. Data will first be collected locally and then uploaded to Google Sheets in large batches. This will resolve the issue with the 'heavy' table.
Audit: I will check the memory load on the remote PC to eliminate the cause of freezes.

Conditions:
Cost: 1500 UAH (through Safe).
… Deadline: 1-2 days for fixes and testing.

I am ready to start working immediately after receiving access to the code."

Show original

Translate

Good evening!
I have experience in correcting and optimizing existing parsers, including those implemented through Excel / Google Sheets that have stability issues during prolonged operation.
I understand the typical situation when:
the parser runs for several hours/days,
then the remote PC starts to "crash,"
Google Excel/Sheets grows and becomes a bottleneck (memory, limits, synchronization).
What I can do:
Analyze and fix logical errors in parsing
analyze the attached example of the error;
… check exception handling, duplicates, formatting failures;
correct incorrect entries in the table.
Optimize the architecture for 24/7 operation
move data accumulation from Google Excel to a more stable storage (local DB / files / queues);
reduce the number of write operations to Google Sheets;
add memory control, process restarts, error logging;
make the parser stable for long-term continuous operation.
Reduce dependence on the remote PC
analyze why the system "crashes" after a few days;
propose a solution that does not require constant manual monitoring.
Result:
corrected parsing errors;
stable operation 24/7 without failures;
recommendations or implementation of an optimal data storage scheme;
minimization of the load on Google Excel.
To start, I need:
access to the current solution (script/Excel/description of logic);
understanding of how much data accumulates in a day;
where exactly the parser is currently running (locally / VPS / remote PC).
I am ready to connect and bring order to the solution.

Show original

Translate

Hello!
I can help fix data parsing in Excel/Google Sheets.
Please clarify how the parser is currently working (what code/what tool is being used - Python, Google Apps Script, other?), and how exactly the failures occur (crashes, hangs).
I can:

- check the parser code

- optimize the data processing logic

… - suggest a way for the script to work more stably

Thank you!

Show original

Translate

Hello! I am ready to complete this project and have extensive experience in developing various applications.

Show original

Translate

Hello. I have reviewed the task and the example of the error.

I can fix the errors in the current parser and optimize its performance for stable operation 24/7. I will eliminate the causes of hangs and crashes during long execution, reduce the load on the system, and add proper error handling.

If necessary, I will set up logging and automatic recovery to ensure the process does not stop.

I am ready to review the code and quickly propose a solution.

Show original

Translate

Good evening.
My name is Oleksiy.
I am ready to fix all the mistakes and improve the code (if possible),
I am ready to complete everything quickly and efficiently, as I have worked with Google Sheets multiple times.
I will complete everything within the day!
Sincerely, Oleksiy.

I will be happy to collaborate!

Show original

Translate

Good evening. If the script is written in Python, I can fix it.

Show original

Translate

Hello, Python developer with more than 5 years of experience, I understand from the screenshot that Selenium is being used, we can discuss either improvements or just solving the problem with saving the browser session and restarting on failures. Write to me in private, we will discuss the details, I will be happy to collaborate!

Show original

Translate

Hello. I can take over and bring this parsing to a proper "24/7", but it is important not to patch Excel, but to remove the cause of the crashes.

From what you described, the problem is typical: Google Sheets/Excel as a "database" swells, starts to lag, limits/quotas/memory, and at some point, everything collapses along with the remote PC.

What I will do:

I will quickly go through the errors in the formulas/parser (as in your example) and correct the logic.

I will add proper logging + auto-restart, so the script can recover itself after failures.
…
I will optimize data writing: in batches, without unnecessary recalculations/formattings, to avoid "killing" the table.

If the table is already large — I will suggest the right option for 24/7: storing data in a database (PostgreSQL/SQLite) or at least in files (CSV/JSON) + in Google Sheets only providing a "dashboard" (the last N rows / aggregates).

I will explain directly: making stable 24/7 parsing that writes endlessly to Google Sheets is almost always a bad idea. For continuous operation, a storage space that is designed for this is needed.

To start, I need: access to the file/script, a brief description of where it runs (Windows/VPS), and a link to the Google Sheet or its copy. After that, I will give an exact time estimate and suggest the shortest path to stability.

Show original

Translate

Hello Vitaly, I am the one you need.
My stack, I have a lot of experience.
Write to me privately, we will discuss.

Show original

Translate

I am ready to promptly and qualitatively complete your order. I have experience working with similar projects, always adhere to deadlines and technical specifications. I will be happy to collaborate!

Show original

Translate

I see the error WinError 10061 / Max retries exceeded to localhost - this means that the WebDriver (Chrome/Chromedriver) is "crashing" and the connection to it is being rejected. I will fix it: I will add a health-check + auto-restart of the driver/browser, stable timeouts/retries, and logging so that the parser works 24/7. I will also optimize the writing to Google/Excel (in batches) so that it does not hang due to the size of the table.

Show original

Translate