# Version 1.4.0 Release notes `Release date: 2023/04/12` :pencil2: Details 1. Revise the Department Code for upload to SI114A. If its Virtual medium Line, will be separate by AB Line. 2. At All TN, change the formula of MP Demand : `Before` (Output / IE EOLR * IEMP) * (Planning Target / IE EOLR) / (WHR-COT&Training) `After` (Output / IE EOLR * IEMP) / (WHR-COT&Training) 3. At CLO & STFB TN, add 2 rows for "Adjusted | All | Plan | PDMP" & "Adjusted | All | Adjusted | MP Demand" 4. At CLO & STFB TN, Change the formula for "Adjusted | All | Adjusted | IE Target Rate" `Before` (Output * Line's IE Target Rate) / Line's Total Output `After` MP Demand / PDMP --- ### :green_book: Preceding files 1. Create new WB: A16-ProdUnit_Relation.xlsm, WS: Prod_Unit_OC :::info :information_source: To setting Organization of production unit. ::: `Format` ![](https://i.imgur.com/GCTZDHR.png) 2. WB: A11-Plan_PDMP.xlsm, Create new WS: SI144_2 :::info :information_source: its come from HP SI144_2. its prepare for next function "TN-Summary". ::: `Format` ![](https://i.imgur.com/1U5jVtp.png) --- ### :compression: Function #### 1. B07. CTB Target-Note 1. Change the formula of MP Demand. #### 2. B07A. Refresh adjustment 1. Change the formula of MP Demand. #### 3. B07B. Centralize, Buffing, S2B Target-Note 1. (CLO, STFB) Change the formula of MP Demand. 2. (CLO, STFB) add 2 rows for ***"Adjusted | All | Plan | PDMP"*** & ***"Adjusted | All | Adjusted | MP Demand"*** 3. (CLO, STFB) Change the formula for ***"Adjusted | All | Adjusted | IE Target Rate"*** #### 4. B07C. Cut-off CTB + Centralize 1. (ALL) Change the formula of MP Demand. 2. (CLO, STFB) add 2 rows for ***"Adjusted | All | Plan | PDMP"*** & ***"Adjusted | All | Adjusted | MP Demand"*** 3. (CLO, STFB) Change the formula for ***"Adjusted | All | Adjusted | IE Target Rate"*** #### 5. B08. Generate SI114A 1. Revise the Department Code for upload to SI114A. If its Virtual medium Line, will be separate by AB Line. --- ### :mag: Others #### 1. Main form ![](https://i.imgur.com/Itz2RQX.png) --- ### :left_right_arrow: Before After Part *This release has no modifications to this part.* ###### tags: `APS01`