Dynamic Customer Segmentation Pivot Model with Weighted Scoring

Design an advanced Excel workbook that creates a multi-dimensional customer segmentation model using weighted scoring across 5-7 key performance indicators. The model should dynamically update customer segments based on recency, frequency, monetary value, and custom behavioral metrics. Implement conditional formatting to visually distinguish segment tiers, and create a macro that automatically recalculates segments monthly. Include data validation rules to prevent manual data entry errors and build a dashboard that visualizes segment distribution and transition probabilities.