Boost your Google Sheets productivity with the

While Google Sheets is a powerful spreadsheet tool, its native functions often hit a wall when faced with complex business requirements. To bridge this gap, I developed Various-functions, a library of ready-to-use Google Apps Script functions to automate your most time-consuming daily tasks.

🚀 Business Expertise Integrated into Your Spreadsheets

This library goes beyond simple text manipulation, bringing real business intelligence to several key organizational areas.

👥 Human Resources & Productivity

• Leave Management: Dynamically calculate accrued leave balances.
• Career Tracking: Determine employee seniority in a clear text format and manage probation period deadlines.
• Availability: Check if an action occurred during official business hours.

💰 Finance & Accounting

• Banking Compliance: Validate IBANs according to international standards.
• Invoicing: Automatically break down VAT by category and convert currency amounts into full text.
• Cash Management: Automate the calculation of late payment penalties and bank overdraft fees.
• Strategic Analysis: Identify your break-even point and determine psychological pricing for your products.

📦 Logistics & Supply Chain

• Shipping: Calculate parcel dimensions and volumetric weight.
• Inventory Management: Prevent stockouts with intelligent alerts and optimize orders using the Wilson formula.
• Customer Service: Monitor Service Level Agreement (SLA) status with visual indicators.

🛠️ Data Quality & GDPR Compliance

• Data Cleaning: Use fuzzy VLOOKUP to correct entry errors or extract multiple results for a single key.
• Data Security: Automatically detect sensitive personally identifiable information (PII) and manage legal data retention periods.

📈 Why Adopt This Library?

Implementing these custom functions drastically reduces human error while freeing up time for higher-value tasks. Every script is documented and ready for integration into your Google Workspace environment.