# Version 1.4.9 Release notes

`Release date: 2023/05/22`

:pencil2: Details
Modify according the request.

-------------------------------------------------------------------
### :green_book: Preceding files

#### 1. A12-IEMP.xlsm

* Create new WS "PU_CMTMPSectionSetting" for setting the relation of PU and CMTMP Section kind.

* At WS:PU_IEMPSectionSetting need to setting CBD CTB part is use which Section Kind. Ex: SHC is use 01.

---
### :compression: Function
#### 1. B07C. Cut-off CTB + Centralize
* At calculation the each model PDMP Total, if the working hour is zero, the total PDMP will be zero.
* fix the bug for get PDMP (NoPlan) at STF-A & STF-B

#### 2. B09. Generate TN Summary
* At WS:Summary, add the new section kind for "CTB Model Efficiency%". Item detail like below.

:::info
**The source/formula**

| Item | Source / Formula |
| ----------------------------------- | --------------------------------------------------------------------------------------------------------------------- |
| Attendance Rate % | Input by user |
| PDMP (Whrs + No Plan) | the Summary of each " **Whrs * (PDMP + PDMP (NoPlan)) / Cell Count** " of ASL, STI, STF-A, STF-B, CLO. |
| MP Pool Whrs | Input by user |
| Total Whrs at Factory | Excel formula. the summary of **PDMP (Whrs + No Plan)** and **MP Pool Whrs** |
| Simulation Actual Whrs | Excel formula. **Total Whrs at Factory** multiplied by **Attendance Rate %** |
| CMT (Model Pairs * CMT/Total Pairs) | the Summary of each " **Model Pairs * CMT(1) / Total Pairs** " of the Section(2) PU & Model#. (PU_SectionKind="CTB-Model-Eff")|
| Model Ideal Whrs (100%) | the Summary of each " **Total Pairs * CMT(1) / 233** " of each ASL PU & Model#. |
| Model Efficiency % (100%) | Excel formula. **Model Ideal Whrs (100%)** divided by **Simulation Actual Whrs** |
| Model Efficiency % (99%) | Excel formula. **Model Ideal Whrs (100%)** multiplied by **0.99** then divided by **Simulation Actual Whrs** |
| Model Efficiency % (98%) | Excel formula. **Model Ideal Whrs (100%)** multiplied by **0.98** then divided by **Simulation Actual Whrs** |
| Model Efficiency % (97%) | Excel formula. **Model Ideal Whrs (100%)** multiplied by **0.97** then divided by **Simulation Actual Whrs** |
| Model Efficiency % (96%) | Excel formula. **Model Ideal Whrs (100%)** multiplied by **0.96** then divided by **Simulation Actual Whrs** |
| Model Efficiency % (95%) | Excel formula. **Model Ideal Whrs (100%)** multiplied by **0.95** then divided by **Simulation Actual Whrs** |

(1). CMT => For Factory is use WB:A12 WS:IEMP which section kind is setting in WB:A12 WS:PU_IEMPSectionSetting (PU_SectionKind="CTB-Model-Eff"); For others is use WB:A12 WS:IEMP which section kind is setting in WB:A12 WS:PU_CMTMPSectionSetting
(2). the Section => for GQT is use **STI** PU & Models, the others is use **ASL** PU & Models.

:::

---
### :mag: Others
*This release has no modifications to this part.*

---

### :left_right_arrow: Before After Part
*This release has no modifications to this part.*

###### tags: `APS01`