PWB Excel Automation Source

This repository contains the versioned VBA and Power Query source code from a macro-enabled Excel workflow. The workbook itself is intentionally not included: spreadsheet data, worksheets, formulas, formatting, logos, embedded media, and other internal assets remain private.

History and authorship

Version 3.0 is a pre-existing baseline that was not originally authored by the repository maintainer. Later snapshots document subsequent maintenance, restructuring, VBA automation, and Power Query improvements. The Git history was reconstructed from dated workbook snapshots; commit dates reflect the files' recorded modification dates rather than an original source-control history.

Version	Summary
3.0	Original baseline received for further development
4.0	Initial structural revision
5.0	Major VBA redesign and introduction of Power Query
5.1	Expanded labor and profitability query workflow
5.2	Broad VBA refactoring and refresh-event handling
5.3	Job-row handling extended from row 48 to row 50
5.4	Additional row-handling and formula-reference fixes
5.4.1	Decimal job-ID support and intentional Travel sheet unlock behavior

Repository structure

src/
├── vba/
│   ├── *.bas   Standard VBA modules
│   ├── *.cls   Workbook, worksheet, and class modules
│   └── *.frm   UserForm code modules
└── power-query/
    └── *.pq    Power Query M expressions and public parameters

The .frm files contain the forms' VBA code. Binary designer data and visual assets are retained only in the private workbook and are not part of this repository.

Local configuration

Internal paths and workbook-protection values were removed before publication. Configure these Power Query parameters in your own environment when applicable:

• pSourceFolder
• pJobsFolder
• pProfitabilityFile
• pLaborFile
• pFinalProfitabilityFile

The repository uses placeholders such as <CONFIGURE_SOURCE_FOLDER> and <CONFIGURE_LOCALLY>. Do not commit real network paths, credentials, or private configuration values.

Working with the source

VBA modules can be reviewed in any text editor and imported through the Visual Basic Editor. Power Query files contain M expressions that can be pasted into the Power Query Advanced Editor. Some modules depend on worksheet names, tables, controls, and workbook structures that are deliberately not distributed here, so this repository is a source archive and portfolio reference rather than a standalone workbook.

Security and scope

• Excel files are blocked by .gitignore.
• No workbook data, logos, worksheets, or embedded assets are included.
• Corporate paths and the hard-coded sheet-protection value were replaced with public placeholders in every historical snapshot.
• No license is included because the initial baseline originated from a pre-existing workbook.