Mathematical Statistics in Excel

General description: We are looking for a performer to solve the task of automating the update of data on supplier stock balances. First of all, we consider the search and adaptation of an existing ready-made solution. If a ready-made solution that meets the key requirements is not found, the development of an extension from scratch will be considered.The main goal is to set up stable and automatic loading of balances. An additional (optional) task is to set up the loading of price lists. Consideration may be given separately or in combination.1C Configuration:Program: Business Automation Software for small company. PROFVersion: 1.6.21.3Requirement: The solution must be implemented exclusively as an extension, without making changes to the main configuration.Approach to implementation (Important note for performers):We are open to your proposals! If you have:A ready-made extension that partially meets the requirements — offer it with a description of the necessary modifications.Your vision or alternative approach to implementation — we will gladly consider it. Our goal is to obtain an effective working tool, and we are ready to be flexible in ways to achieve it. Main functional requirements:1. Data retrieval:Source: Gmail mailbox.Method of retrieval: The system must be able to process: Emails with direct attachments (files).Emails that contain a direct link to download a file (without the need to enter logins/passwords on third-party portals).Attachment filtering: The ability to specify a "mask" for the file name or extension for each supplier (for example, *stock*.xlsx), so that the system automatically ignores other attachments in the email (invoices, images with signatures, PDF catalogs).File formats: Excel (.xls, .xlsx), CSV, XML. 2. Data configuration and processing:It is necessary to implement a flexible configuration interface for each supplier separately.Item matching logic: Matching of goods must occur strictly by article number.Processing of unmatched items: If the article from the file is not found in the 1C database, the system should not create a new item. Instead, a report should be generated listing such items for further analysis by the manager.Processing of incomplete files: The system must correctly process files that contain only balances (without prices) or only prices (without balances), updating in 1C only the data that is present in the file.Memory optimization: Parsing large Excel files should be maximally optimized (for example, reading through a spreadsheet document on the server side or using specialized libraries) to avoid crashing the 32-bit client application due to lack of RAM.Units of measurement and currency (optional): The ability to specify the currency of the input file (with auto-conversion) and set the packaging coefficient for correct calculation of basic units of measurement. 3. Data loading logic:Main task: Loading balances This is a key and mandatory part of the functionality.Critical requirement for clearing: Clearing previous balances of a specific supplier must occur only after successful reading and full validation of the new file. If the file is corrupted, empty, or the column structure has changed — old balances are not deleted, and the system simply generates an error. This is necessary to avoid accidental zeroing of the database and to guarantee data availability. Additional (optional) task: Loading pricesThis functionality will be an advantage but is not mandatory at the first stage.Static prices: The ability to load prices into three defined price types in 1C: "Purchase", "VIP price", "Retail".Calculated prices: It is necessary to provide a flexible mechanism for calculating prices according to formulas, which is adjustable for each supplier. For example: Option A: The retail price from the file is the base, while the purchase and VIP prices are calculated as a percentage of it.Option B: The purchase price is the base, while the retail and VIP prices are calculated using a markup.There must be the ability to set the base for calculation and the formula for each price type. 4. Storage and display of data in 1C:Storage: It is recommended to store data in a new Information Register. However, we are open to your proposals if you see a more optimal architectural approach.Display: Current information about balances should be displayed in the following interfaces:Document form "Customer Order".Form "Product Selection".Item card form.Important: If the same article is available from several suppliers, the interface must clearly show the balance for each of them separately (for example, a separate information panel, a pop-up window on hover, or additional columns). 5. Automation:Loading must be performed automatically using a server scheduled task (or another more optimal approach).There must be the ability to set different start times for different suppliers (for example, 8:00, 10:00).There must be the ability to manually start the loading process.Notification system: In case of critical errors during automatic loading (absence of file in the email, unknown format, reading error), the system must generate notifications for the responsible manager (in the form of a task in 1C, message, or email). Work result:Extension file (.cfe), or installation package of the ready-made solution.User manual for configuration and use. P.S. Examples of similar modifications: 1) https://ingenum.ua/analiz-praysov-postavshikov-dlya-bas-ili-1c2) https://pdk.com.ua/ua/features/dev/monitor_zagruzki-detail/3)https://nct.ua/catalog/raboty_dlya_1s_8/Automatic-loading-of-price-lists-of-suppliers-and-the-balance-of-goods-from-suppliers/

It is necessary for a waybill for Nova Poshta to be automatically generated when an order is created by the manager in Bitrix. This is for the further possibility of printing the waybills in a register.

Set up automatic daily updates of product availability on our website on prom.ua. We have a supplier who sends a price list of products in Excel format to our email every day. The items on our website and in the supplier's price list are the same. The values in the "stock" column are either out of stock, a number, or more than a box - these need to be updated on the site to either Ready for shipment or Out of stock. Items that are not in the supplier's price list should remain unchanged. Please propose a solution, timeline, and budget. Thank you in advance for your response, I look forward to collaborating with a specialist.

We are looking for an experienced specialist in 1C BAS KUP who can help integrate the work with a mobile application turnkey.Currently, we have not yet decided on the software and mobile application for the TSD, so we are looking for a specialist who has practical experience, is familiar with modern solutions on the market, and can not only recommend the optimal option but also fully implement it. What needs to be done:install and configure the mobile application and integrate it with BAS KUP;select and propose a TSD;set up correct data exchange between BAS and the mobile application;test the system's operation and, if necessary, fix errors or make necessary adjustments.conduct training for BAS KUP and TSD users.The project needs to be implemented urgently, so it is important for us to find a specialist who is ready to start work promptly and bring the implementation to a fully operational state. Requirements for the candidate:experience working with BAS KUP and integrating mobile applications;knowledge of modern solutions for warehouse automation;experience in implementing similar turnkey projects;ability to start work in the near future. In your response, please briefly describe your experience, indicate which solution you recommend for our case, provide examples of similar projects, and let us know when you are ready to start working.

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.