EXCEL table for auto service
The task is to create an analog copy: a table file or rework it, insert a site with a demo version of a Russian-language site (access via VPN) of a free template that includes a video review of it.
The file contains 12 sheets:
Order Sheet
Work
Spare Parts
Order Form
Daily Report
Payroll Breakdown
General Expenses
Summary Report
Service Directory
Spare Parts Directory
Directory
First Launch Instructions
Next steps:
Translate all sheet names and headers.
Remove "Instructions" and references to the demo.
Expand the tables and make them suitable for full accounting.
Link to the website with a video review of the table https://excel-help.ru/doc/tablitsa-dlya-avtoservisa-2025-sklad-zapchastey/
There is a button in the table that adds a new row at the end of the table to avoid overloading the PC
Name of the service station: DCAR if possible, add a logo for the uniform order
У таблиці є кнопка, яка додає новий рядок у кінець таблиці щоб не навантажувать пк
Назва СТО: DCAR якщо можна додоти логотип на заказ наряд
Applications 1
Client's review of cooperation with Oleksandr Pelyuh
EXCEL table for auto serviceHighly RECOMMEND!!! A professional in his field! Loyal to the work, ready to change conditions in your favor! Performs the work down to the smallest detail, even exceeds the overall budget plan! So you will want to leave a tip yourself after seeing the results! Thank you!
Freelancer's review of cooperation with Yury Dorosh
EXCEL table for auto serviceIt was a pleasure to work with Yuriy. The tasks were clear, and the feedback was prompt. Everything was to the point and constructive. I recommend Yuriy for collaboration.
-
267 Sorry for the expression, but such "automation" in spreadsheets is an archaic and unprofessional approach, as it is impossible to fully implement accounting registers, automate control and data entry services, let alone reports and much more in Google Sheets!! For automating the work of a service station (also spare parts and car trading), there is a ready-made standard software product Alfa-Auto. It is developed based on the experience of automating thousands of service station clients and auto parts traders. No talented amateur developers can implement full functionality similar to this solution.
I am ready to introduce you to the system and help you acquire it. Details in correspondence.
PP "Alfa-Auto: Auto Service + Auto Parts, edition 6"
Advantages of the program:
• Launching the program in "thin client" and "web client" modes.
• Dynamic pricing for spare parts depending on the price groups of the nomenclature.
• Pricing for auto repairs by types of repairs, car models, workshops.
• Unified vehicle directory, storing the original VIN number.
• Customer search by various data: VIN, car license plate, full name, etc.
… • Managers can work only with their own clients.
• Tracking the status of customer spare parts orders.
• Notifying managers about reservation of nomenclature for customer orders.
• Registration of missed demand for spare parts.
• Accounting for replacements and analogs of spare parts.
• Ability to prohibit sales below cost price.
• Support for an unlimited number of supplier price lists.
• Storing sales history of all clients.
• Automated workstation for auto service employees.
• Standardization of work times by car models and configurations.
• Vehicle maintenance, control of periodicity of maintenance.
• Ability to split work, spare parts, and materials into multiple work orders with different contractors and types of repairs when a customer contacts the auto service.
• Separation of sets of performed works by reasons for contact.
• Performing service campaigns.
• Accounting for subcontracted work.
• Acceptance of tires for storage.
-
1539 35 3 Good day. I have a rewritten BAS accounting system for a service station. It has been implemented and has been working for over 4 years. I can install it locally. If you want a network version and a web camera, the price will be different. I can give a demonstration. I conduct training at 500 UAH/hour. You will need 2-3 hours and you will be able to work at full capacity.
-
2578 57 1 1 I work as a financial analyst in a large international company. I have extensive experience with spreadsheets, I will help
-
397 1 0 Hello, I am very good at Excel, I have optimized tables for enterprises. Therefore, I can complete the task in a few days.
Your only link does not open, so unfortunately I cannot familiarize myself with the scope of work.
-
634 31 0 Hello! The task is not very clear, but I know Excel perfectly. I can help in creating the document. Feel free to contact me)
Current freelance projects in the category Enterprise Resource Planning (ERP)
Checking and configuring cloud, agents, skills.I want to set up an AI agent for finding clients and automatically sending messages. Task: create an agent through Claude/Cloud that can collect a database of contacts based on specified criteria, such as companies, websites, emails, phone numbers, cities, regions, and other… Enterprise Resource Planning (ERP), AI Consulting ∙ 9 hours 26 minutes back ∙ 12 proposals |
She for the team
558 USD
Teach the team the basic functions of AI Team of up to 10 people Optimize processes, improve the quality of work. Teach basic methods to use AI. Online sessions can be one lasting several hours Enterprise Resource Planning (ERP), AI Consulting ∙ 3 days 22 hours back ∙ 22 proposals |
AI advertising automation - FACEBOOK ADS
150 USD
Hello everyone! We are looking for specialists who have effectively automated the management / launch and analytics of Facebook advertising through AI Claude / GPT / GEMINI. We need to quickly set up automation / launch / exports / analytics. Please share your… AI & Machine Learning, Enterprise Resource Planning (ERP) ∙ 5 days 7 hours back ∙ 27 proposals |
WABA setup with integration into SendPulsePreviously, the WhatsApp business account was connected through a Polish FOP, and the system was functioning correctly. Currently, the Polish FOP is unavailable, so reconnection and setup of WABA through a Ukrainian FOP is required. The current account is deactivated, and… Enterprise Resource Planning (ERP), Client Management & CRM ∙ 6 days 15 hours back ∙ 8 proposals |
Implement the processing of mass billing distribution to clients in messengers (Viber and Telegram) BASTechnical task In the CONTRACT, on the subscription tab (this is a revised tab through an extension), add a phone number that will need to be filled in the future for sending invoices to the client: Implement the ability to send invoices to clients in bulk, generated for a… Enterprise Resource Planning (ERP) ∙ 8 days 16 hours back ∙ 11 proposals |