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.

👀Watch the VIDEO-DEMO


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

👀Watch the Video

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:

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

⭐⭐⭐⭐⭐

🏆Awards

📖Books

Max recommends these books:

Other works

Collection of 90+ named functions for any case :)

Collection

🏅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 

The library takes care of parameters, so you do not need to care about which method to use. 

🖨️Sheet2PDF

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.

🖼️Galery