# Version 1.3.4 Release notes `Release date: 2023/03/24` :pencil2: Details Update Summary: 1. Change the calculation ofMP Demand of S2B TN. 2. Change the algorithm of IEMP, let user can flexible change the IEMP Section kind. 3. Add the information Production Department & IEMP Version at each TN. 4. At cut off TN the total of each cell, add the total by Production Department. --- ### :green_book: Preceding files #### 1. WB: A12-IEMP.xlsm, Create new WS: PU_IEMPSectionSetting :::info :information_source: To setting each Production unit & Section kind use which IEMP's Section Kind. besides also to setting the Production Department ::: `Format` ![](https://i.imgur.com/cepCp15.png) --- ### :compression: Function #### 1. B07. CTB Target-Note 1. Change the algorithm of IEMP. `Before:` ASL -> IEMP Section 5; STI -> IEMP Section 3; ... `After:` user can change the IEMP Section at A12-IEMP (WS: PU_IEMPSectionSetting). 2. Add new column at each TN for **IEMP Version** (Column N) & **Prod Dept** (Column O). 3. Add the total for each cell at bottom part, add new line for **Detail of COT** & **Detail of Learning Curve** #### 2. B07A. Refresh adjustment 1. Get **IEMP Version** & **Prod Dept** from each TN and display it. 2. Add the total for each cell at bottom part, add new line for **Detail of COT** & **Detail of Learning Curve** #### 3. B07B. Centralize, Buffing, S2B Target-Note 1. Get **IEMP Version** & **Prod Dept** from each TN and display it. 2. Change the formula of MP Demand at S2B TN. `Before:` calculation according the formula `After:` Add up the MP Demand of STI & ASL 3. Add the total for each cell at bottom part, add new line for **Detail of COT** & **Detail of Learning Curve** 4. Fix the BUG: - delete the date which not have the output at Buffing TN. #### 4. B07C. Cut-off CTB + Centralize 1. Get **IEMP Version** & **Prod Dept** from each TN and display it. 2. Add the total for each cell at bottom part, add new line for **Detail of COT** & **Detail of Learning Curve** 3. Setting the Background color orange to - **Plan|{ProdUnit}|Plan|WHR** - **Plan|{ProdUnit}|Plan|PDMP** - **Plan|{All}|Plan|Cell Count** - **Plan|{All}|Plan|Cell Count (NoPlan)** - **Plan|{All}|Plan|PDMP (NoPlan)** 4. At ASL & STI TN, the total of each cell (bottom of TN), add the summary by Production Department. (like below picture) ![](https://i.imgur.com/d3uuXAr.png) --- ### :mag: Others #### 1. Main form *This release has no modifications to this part.* --- ### :left_right_arrow: Before After Part ###### tags: `APS01`