This application is being used as part of a research study on manufacturing operations.
By participating, you acknowledge that your inputs and data entered in this tool may be collected and used for research purposes. All data is de-identified to protect your privacy.
Do you consent to allow your data and input to be used in this study?
❓ Why am I being asked to de-identify even though I did not give consent?
This is done to help protect the identity of those participating in the study. Even without consent, a de-identifier ensures that no personal information is tied to any data entered in this application.
To protect your identity, please create a personal de-identifier code using the formula below:
Formula:
First 3 letters of your favorite movie +
First 1 letter of your favorite color +
Last digit of your birth year +
Last digit of your birth day
Example: The Matrix · Green · 1982 · 17th
→ MATG27
⚠️ Please enter all 6 characters.
🏭 Manufacturing Issue Tracker
Track equipment issues and generate AI-powered work instructions
v21.30
Report New Issue
Search Historical Issues
Select a production line above, or check this box to search across all lines
Select a machine to see previous issues
📚 Equipment Manuals Library
Quick access to all equipment manuals organized by production line and machine.
Click any manual to open it in a new tab.
🤖 AI-Generated Work Instructions
Generate detailed work instructions based on your equipment manuals and definitions. The AI will only use information from your configured manuals and will indicate when no information is available.
Select a production line above to see available machines
📖 Definitions & Terminology
Manufacturing Knowledge Base: Manage definitions and terminology specific to your baby wipes production facility.
These definitions are automatically included when generating AI work instructions to ensure accurate and relevant guidance.
Issue History
⚙️ Setup & Configuration
🤖 AI Provider Selection
Choose which AI service to use for generating work instructions
🆓 Google Gemini
FREE - No credit card needed
✓ Recommended for most users
💼 Azure OpenAI
Requires Azure account
Best for enterprises
🟣 Anthropic Claude
Requires Anthropic API key
Advanced reasoning
🔑 Google Gemini Configuration
✓ FREE - No Credit Card Required
Get your free API key at: ai.google.dev
Get it from Google AI Studio (ai.google.dev) - completely free!
💡 Try 2.0 Flash Exp if 2.5 Flash gives poor quality. Use "List Available Models" to see what works with your key.
🔑 Azure OpenAI Configuration
ℹ️ Azure Subscription Required
You'll need an Azure account with OpenAI access. New accounts get $200 free credit.
Found in Azure Portal → Your OpenAI Resource → Endpoint
Found in Azure Portal → Keys and Endpoint
Your model deployment name (e.g., gpt-4, gpt-35-turbo)
💰 Azure Pricing:
• New accounts: $200 free credit
• GPT-4: ~$0.10-$0.30 per instruction
• GPT-3.5: ~$0.01-$0.05 per instruction
💡 Sonnet 4 is recommended for most use cases. Opus 4 provides the highest quality output.
💰 Claude Pricing:
• Sonnet 4: ~$0.01-$0.05 per instruction
• Opus 4: ~$0.10-$0.50 per instruction
• Note: Claude API calls are proxied through Google Apps Script
📋 Changelog / Update Notifications
When enabled, a changelog popup will appear every time the app is opened, for the number of days you set.
Since multiple users share this device, the timer is per device — it resets from the date you save.
Popup will appear on every app open for this many days from when you save.
📚 Equipment Manual Configuration
Link each piece of equipment to its manual stored in OneDrive, SharePoint, or GitHub.
Manuals are organized by Production Line and Machine.
🔍 Cloud Sync Verification
Use these tools to verify your manual mappings are properly syncing to Google Sheets.
📋 What's New
Add Action Taken
Start typing or select from previous actions
Add Equipment Manual Mapping
📁 The markdown/text version used by the AI — fetched automatically when needed
📄 When provided, operators will open this PDF instead of the markdown source
🔍 Test PDF Download
This will test if your Google Apps Script can download PDFs from Google Drive.
🔒 Enter PIN
This tab is protected. Please enter the security PIN to continue.
❌ Incorrect PIN. Please try again.
📧 Contact App Support
Having issues or found a bug? Let us know and we'll help you out!
Add Definition
Specify which equipment this applies to, or leave blank for all