Create an Advanced Excel & Vba Tool for Forestry Stock Audit

We are a team involved in forestry and timber-related financial analysis. We need an experienced Excel/vba developer to build a smart, automated spreadsheet that helps us audit, calculate, and analyze stock-related data extracted from erp files (excel-based).

The tool should include:

- User-friendly import sheet (for erp data)
- vba-based automation for calculations and consistency checks
- stock valuation based on species and unit (m³, tons, mwh)
- standing timber and work-in-progress (wip) calculations
- profitability analysis per batch
- interactive dashboards and automated alerts
- clear documentation (as a separate excel sheet)

objective:
to simplify audit processes, ensure data integrity, automate calculations, and generate insights for accounting and stock control in forestry operations.

Key Requirements:

- Strong Excel & VBA programming skills
- Experience with unit conversion and valuation models
- Ability to develop clean and professional dashboards
- Clear communication and delivery within 2–3 weeks
- Source file must be unlocked with all VBA code