Develop cross-analytics from existing Google Sheets for an advertising agency

I'm gathering a team for the development of a large project, please write if you want to receive a stable monthly salary and live for free in a hotel in Bukovel with spa and meals, We will discuss the salary over the phone,

Automation of data processing Execution of calculations according to specified algorithms, Automatic document generation Integration with 1C There are input data in one table that need to be automatically transferred to another, calculations performed according to certain rules, and ready documents generated for further automatic loading into 1C

Attention Production is looking for a specialist for long-term cooperation!!! I am looking for a developer or a team that will help create an inexpensive, reliable, and easy-to-use production automation system for the chicken deboning workshop. The main goal is to maximize the automation of the weighing process, product labeling, inventory management, and ensure complete traceability of each batch of products from the receipt of raw materials to delivery to the customer. Main functionality 1. Integration with weighing equipment Connecting electronic scales to a personal computer. Automatic weight acquisition without manual input. Support for one or multiple workstations. 2. Automatic printing of thermal labels After weighing, the system automatically prints a label containing: product name; weight; batch number; production date; expiration date; code or full name of the employees who performed the operation; barcode or QR code; other necessary information according to the company's requirements. 3. Automatic inventory management The system must provide: receipt of carcasses for production; automatic write-off of raw materials; accounting of finished products; real-time inventory tracking; control of losses and product output. 4. Product shipment Formation of customer orders. Order picking. Automatic write-off of products from the warehouse. Control of inventory after shipment. 5. Traceability This is one of the most important modules of the system. It is necessary to ensure the ability to determine at any moment: from which batch of carcasses each unit of product was made; when it was produced; who specifically processed it; on which scales it was weighed; what weight indicators were recorded; when and to whom it was shipped. The system should also allow for quick retrieval of all units of product made from a specific batch of raw materials, which is especially important in case of inspections or product recalls. 6. Reports It is desirable to implement: inventory levels; product movement; employee productivity; output of products from each batch; losses during deboning; history of all operations; production statistics for any period. Preferences Simple and intuitive interface. Minimal manual data entry. Operation without expensive licenses. Local database with backup capability. Possibility of further functional expansion. Support for integration with scales and thermal printers (Zebra, Godex, TSC, Xprinter, or similar). In your response, please indicate Examples of similar projects. Proposed development technology. Estimated cost and completion time. Supported models of scales and thermal printers. Suggestions for system improvement. Prospects for cooperation In the future, there are plans to expand the system to a full-fledged production ERP with automation of all enterprise processes: procurement, inventory, production, quality control, logistics, sales, and financial accounting. Therefore, I am looking for a specialist or team for long-term cooperation. I would also immediately add another requirement that will significantly increase the practical value of the system: calculation of product output and losses. For example, if 1,000 kg of carcasses are received, the system automatically shows: how much fillet, thighs, wings, drumsticks, etc. were obtained; overall output percentage; technological losses; productivity of each employee or team; cost of each item.

Communication/recruitment agency. CRM — NetHunt (Business plan, 2 users). Two funnels — candidates and clients — have already been created independently. This is an internal working tool for a team of 2 people, not a public product. The goal is to correctly configure the system, automate routine tasks, and connect external tools (Google Form, Notion, Telegram) to the CRM. What needs to be done Review and optimize the structure of the database and two funnels (fields, stages) for recruitment processes. Automatic emails to candidates when moving between stages of the funnel (native NetHunt workflow + templates). Auto-creation of candidate cards from applications — evaluate two options: (a) native NetHunt form; (b) from the existing Google Form via webhook/Make. Notion → NetHunt: when creating a record in the database [SPECIFY WHICH], a card is automatically created in the CRM (via Make/Zapier, field mapping, duplicate protection). Connecting Telegram — evaluate two options: (a) two-way integration (candidate chats become cards, responses from CRM); (b) one-way auto-messages. Testing all scenarios + training 2 people + a short instruction. Criteria for successful results All automations work stably, without duplicates and data loss. The team understands how to use the system and make simple edits independently. There is a short, clear documentation on the setup. Please specify in your response Fixed price separately for each item + total. Deadline for completion. Whether support after launch is included (e.g., bug fixes for 1–2 weeks). Similar cases: implementation of NetHunt and/or integrations via Make.

We are looking for a specialist in Google Sheets to support the existing work tracking table and payroll calculation. The table has already been created and contains many formulas and interconnections between sheets. Currently, there are errors that need to be found and corrected. Requirements: analyze the structure of the table; find and fix errors in the formulas; restore the correct functioning of the table if necessary; explain the working principle so that we can independently make simple changes in the future; provide ongoing support for the table if possible. Experience with Google Apps Script will be an advantage if the table uses automation. Before starting work, I will provide access to the table and explain what the problem is.