---
# System prepended metadata

title: Version 1.4.9 Release notes
tags: [APS01]

---

# 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.
![](https://hackmd.io/_uploads/HJT_OSdSh.png)

* At WS:PU_IEMPSectionSetting need to setting CBD CTB part is use which Section Kind. Ex: SHC is use 01.
![](https://hackmd.io/_uploads/rJ-BFBuHn.png)




---
### :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`