Max Makhrov is a blogger, and developer at cooltables.online. Here are some of his projects.
Automated dashboard and data entry system for the factory shops
⯌ making production FASTER!
⯌ reducing COSTS and increasing profits.
The system enabled real-time tracking and planning of their manufacturing processes.
Business owners determine the production timeline for each product.
● The backend of the system was powered by:
MySQL, Formulas, Google Sheets, Apps Script, Google Forms
The result was a strong and reliable platform for data management.
This work helped change their production model, contributing significantly to their success.
This work was done to show the boundaries of Spreadsheet Engine.
It was a work for international Spreadsheets competition:
Spreadsheets Developers Gauntlet
The Judges Said:
“We were looking for things that were unexpected. This was certainly unexpected.” – Ben
“I absolutely love it.” – Heidi
“We were blown away by this one. We had to show it off. Incredibly creative.” – Frank
The AI add-on Synterrix became a successful launch. The product was created from scratch. Now available on Google Marketplace.
The codebase:
Google Apps Script, Node JS, Python, Firestore
Svelte, HTML-CSS-JS
Utilizes HTML service to overcome the standard 6-minute script runtime limit:
⯌ Automates AI tasks, making millions of requests possible
⯌ With extended hours of operation, it can handle the processing of complex and big AI tasks.
Cooltables add-on brings a new idea to life:
Users can use flexible and fast-evolving Spreadsheets but still
Able to process BILLIONS of rows.
The add-on allows users:
⯌ Linking and loading Sheets to BigQuery
⯌ Using carefully crafted templates for any business case
⯌ Creating a Sheets menu with a search by name and color
⯌ Capturig high-resolution Spreadsheet Screenshots.
The Cooltables Add-on was built with
Apps Script, Spreadsheet Formulas, Firestore, Svelte
It uses intuitive UI.
— Your add-on?
Boost Your Business
Dear Business Users,
You aim to sharpen operations. Tools are ready for action.
Here you can get help with your processes.
I'm here to find the best solution for your situation. With 17+ years of experience and a solid track of projects, I'll craft your task from scratch.
We'll review the plan together, and control the process. You'll receive the complete product, from idea and design. We'll end with a WORKING solution, that will increase your productivity.
I'll make sure to support you along the way. I know the code, but work with people and ideas. My primary goal is to craft scalable solutions, and help businesses.
Best,
Max Makhrov
📖Books
Max recommends these books:
Jay Shetty, "Think Like a Monk"
Ray Dalio, "Principles"
Olivier Sibony, "You're About to Make a Terrible Mistake"
Kelly McGonigal, "The Willpower Instinct"
Gavin Kennedy, "Everything is Negotiable"
Other works
Collection of 90+ named functions for any case :)
🏅Collections
🟢Formulas
Bar-Code with a formula
Challenge — create your own Bar Code Formula using the SparkLine function.
🟠Challenges
🟢Formulas
Dependent drop-down lists can be used to create a dynamic list of choices in Google Sheets.
Automate tasks in Google Sheets, Documents, Forms, Drive, and other Google services.
➡️Coding Tools
😽The Collection!
Please see my Git-Hub Repo
It has 200+⭐stars, but it's still messy. One day I'd like to take care of the beautiful description and better structure of the files later.
Any ideas are welcome!
Library lets you send emails, using
MailApp,
GmailApp,
and Gmail API.
The library takes care of parameters, so you do not need to care about which method to use.
Library for converting Google Sheets™ Into PDF.
Featurs:
⚙️ All PDF settings including colontitles = custom headers and footers.
🔌Input parameters is a single plain object.
Jsonatags is a library that enables the use of the Jsonata.js
It helps you to manipulate jsons with a query-like language.