Intelligent Procurement Management System with Integrations

Description

Integrated ecosystem for inventory control, price research automation, and predictive analysis. This spreadsheet integrates the Google ecosystem (Sheets, AppScript, AppSheet, Looker Studio) to solve the problem of price fluctuations and domestic inventory management. Google Apps Script Development of automations in Google Script (JavaScript) to optimize performance and usability. The spreadsheet includes: 1st Custom Menus: facilitating spreadsheet usage and correction of potential errors; 2nd Gradient system and item separators: for the Price Research Matrix, providing better visualization and readability of researched prices; 3rd Transformation of History into Matrix and vice versa: along with batch price saving or saving by specific dates, undo last save button, redo, and load prices from a date; 4th Optional floating topbar: to facilitate navigation on small screens or split tabs; 5th Price Research Matrix cleanup: to expedite inclusion of new prices; 6th Column hiding: to display only essential stores to be researched; 7th Data processing and cleaning (ETL): for automated standardization of strings to avoid duplication and search errors (e.g., extra spaces or invisible characters); 8th Sector filtering: to display only essential information to be viewed; 9th Price Matrix synchronization with AppSheet: for full mobile system integration. Google Looker Studio Charts that facilitate visualization of prices and their fluctuations across different items, packages, and brands, enabling identification of price trends and seasonality. Google AppSheet A more compact and essential version of the spreadsheet, integrating key scripts and simplifying personal price collection. Features spreadsheet <> AppSheet data synchronization