Browse categories
Explore
Fiverr Pro
English
$
USD
I will build a plug and play layered process audit lpa system in excel
About Me
Hello! I'm currently working as a Quality Manager with 16 years of experience in the quality manufacturing field, currently working for a multinational manufacturing company. I create custom...
About this Gig
A complete Layered Process Audit (LPA) program in one Excel workbook - built by a working quality professional in U.S. manufacturing, for ISO 9001 / IATF 16949 / VDA environments.
No blank slates: enter your company, auditors, emails, and work centers once on the CONFIG sheet and every dropdown updates. Run audits from a dropdown-driven form with one-click Submit - every entry lands in a running log automatically, so nothing gets lost.
What's inside:
- 8-sheet workbook + 7 pre-written VBA macros
- Editable question bank - 10 starter questions (Quality, 5S, Safety, Productivity) mapped to work centers with On/Off control
- Live dashboard - pass rate, totals, fail counts
- Archive function + Outlook email dispatch, ready to enable
- Plain-English setup guide - about 10 minutes, no coding required
Premium upgrades you to the Pro build: true multi-layer auditing with automatic auditor rotation, a finding closure workflow, printable audit forms, and a management dashboard - configured with your content.
Requires Excel for Windows (VBA macros don't run on Mac or Google Sheets).
Not sure it fits? Message me before ordering - straight answer, no pressure.
Platform:
Excel
•
VBA
•
Microsoft Office
Development technology:
VBA
•
Excel
Expertise:
Formatting
•
Forms
•
Pivot tables
•
Formulas
•
Macros
FAQ
Do I need to know VBA or coding?
No. The macros are pre-written; the included guide walks you through importing them and adding the buttons in plain English (~10 minutes). Standard and Premium orders arrive with this already done.
Does this work on Mac or Google Sheets?
No - the LPA system requires Excel for Windows (VBA macros don't run on Mac or Sheets). On a Mac and still interested? Message me first and we'll talk options.
What's the difference between Basic and Standard?
Basic: you set it up yourself with the guide (~10 min). Standard: send me your company name, auditors, work centers, and questions - I load everything and deliver it ready to run.
Can I change the questions and dropdowns later?
Yes. The question bank and the CONFIG sheet (auditors, work centers, departments) are fully editable - no code involved.
Can it email my auditors?
Yes - Outlook email dispatch is built in and ready to enable with one small edit (the guide shows exactly where).
What if I get stuck?
Message me. I support every order, and if something isn't working as described, say so and it'll get sorted.
What's different about the Premium Pro system?
A bigger, upgraded workbook modeled on full LPA software: multiple audit layers with automatic auditor rotation, auditor independence, a findings workflow with verify-and-close gates, printable blank audit forms, and a schedule-adherence dashboard - configured with your people and questions.
