Export-Import Template | Validations

Import section: Needs to have a popup showing what are the fields that will be getting uploaded

Import section needs to have checks and balances to ensure no additional rows and columns are added

Details to be added based on the research

Acceptance Criteria 1: Below filters/Parameters are visible in Inventory Budget and LE. Select any value from filter and AG grid is showing filtered value for each parameter.
Business Unit
MPG
Product
Site
Market
Opu
Regional lead
BSL
Review Status
Add Review Reqd
Acceptance Criteria 2: Below columns are present in AG grid.
Division
Market Site
PGS Site
OpU
Region
Country
PBG Market Upjohn Market
MPG Code
Business Unit
SCD Product
MPG Description
Currency
2024 FX Rate LCY per USD
2025 FX Rate LCY per USD
2024 Budget Q4 2024 AP12
Functional Currency
Functional Currency in USD
Adjustments (USD)
Total Incld' Adjustments (USD)
2024 Budget Q4 2024 AP05
Functional Currency
Functional Currency in USD
Adjustments (USD)
Total Incld' Adjustments (USD)
2024 LE2 Q4 2024 AP12
Functional Currency
Functional Currency in USD
Adjustments (USD)
Total Incld' Adjustments (USD)
2024 LE2 Q4 2025 AP05
Functional Currency
Functional Currency in USD
Adjustments (USD)
Total Incld' Adjustments (USD)
LE2 Major Driver
LE2 Variance Comments
2025 Budget Q1 2025 Budget Rate
Functional Currency
Functional Currency in USD
Adjustments (USD)
Total Incld' Adjustments (USD)
2025 Budget Q2 2025 Budget Rate
Functional Currency
Functional Currency in USD
Adjustments (USD)
Total Incld' Adjustments (USD)
2025 Budget Q3 2025 Budget Rate
Functional Currency
Functional Currency in USD
Adjustments (USD)
Total Incld' Adjustments (USD)
2025 Budget Q4 2025 Budget Rate
Functional Currency
Functional Currency in USD
Adjustments (USD)
Total Incld' Adjustments (USD)
USD $000 Change Q4 2024 LE2 vs. Q4 2025 Budget
$ Change Due to Statistical Cost Change
$ Change Due to units (Volume) Change
Major Driver Operational Variance Category
Q4 2024 LE2 to Q4 2025 Budget Variance Comments
Site Primary contact
Market Primary contact
Product Primary contact
Review/Approve
Reviewer comment
Suggested Amount
Reviewer Sign off?
Reviewer Sign off Date
Acceptance Criteria 3: Below columns are present in download template.
Verify that below columns are present.
MPG
Division
Market Site
PGS Site
OpU
Region
Country
PBG Market Upjohn Market
MPG Code
Business Unit
SCD Product
MPG Description
Currency
2024 FX Rate LCY per USD
2025 FX Rate LCY per USD
Q4 2024 Budget Functional Currency
Q4 2024 Budget USD 2024 Rate
Q4 2024 Budget Adjustments for Material on Toll w/ ELC Supply USD 2024 Rate
Q4 2024 Budget Total Incld' Adjustments USD 2024 Rate
Q4 2024 Budget Functional Currency
Q4 2024 Budget USD 2025 Budget Rate
Q4 2024 Budget Adjustments for Material on Toll w/ ELC Supply USD 2025 Budget Rate
Q4 2024 Budget Total Incld' Adjustments USD 2025 Budget Rate
Q4 2024 LE2 Functional Currency
Q42024 LE2 USD 2024 Rate
Q4 2024 LE2 Adjustments for Material on Toll w/ ELC Supply USD 2024 Rate
Q4 2024 LE2 Total Incld' Adjustments USD 2024 Rate
Q4 2024 LE2 Functional Currency
Q4 2024 LE2 USD 2025 Budget Rate
Q4 2024 LE2 Adjustments for Material on Toll w/ ELC Supply USD 2025 Budget Rate
Q4 2024 LE2 Total Incld' Adjustments USD 2025 Budget Rate
Q4 2024 LE2 Major driver
Q4 2024 LE2 Variance Comments
Q1 2025 Budget Functional Currency
Q1 2025 Budget USD 2025 Budget Rate
Q1 2025 Budget Adjustments Current Year Budget Rate
Q1 2025 Total Incld' Adjustments USD
Q2 2025 Budget Functional Currency
Q2 2025 Budget USD 2025 Budget Rate
Q2 2025 Budget Adjustments Current Year Budget Rate
Q2 2025 Total Incld' Adjustments USD
Q3 2025 Budget Functional Currency
Q3 2025 Budget USD 2025 Budget Rate
Q3 2025 Budget Adjustments Current Year Budget Rate
Q3 2025 Total Incld' Adjustments USD
Q4 2025 Budget Functional Currency
Q4 2025 Budget USD 2025 Budget Rate
Q4 2025 Budget Adjustments Current Year Budget Rate
Q4 2025 Total Incld' Adjustments USD
USD $000 Change Q4 2024 LE2 vs. Q4 2025 Budget
$ Change Due to Statistical Cost Change
$ Change Due to units (Volume) Change
Major Driver Operational Variance Category
Q4 2024 LE2 to Q4 2025 Budget Variance Comments
Acceptance Criteria 4: LE1 import template and update any of below columns and import excel. Values are successfully updated in AG grid for respective MPG. Same is working for LE2,LE3 and LE4.
Enter below fields in excel and Click on Import button
Q1 2024 LE1 Functional Currency
Q1 2024 LE1 Functional Currency
Q1 2024 LE1 Major driver
Q1 2024 LE1 Variance Comments
Q2 2024 LE1 Functional Currency
Q2 2024 LE1 Adjustments USD 000's Current Year Rate
Q2 2024 LE1 Major driver
Q2 2024 LE1 Variance Comments
Q3 2024 LE1 Functional Currency
Q3 2024 LE1 Adjustments USD 000's Current Year Rate
Q3 2024 LE1 Major driver
Q3 2024 LE1 Variance Comments
Q4 2024 LE1 Functional Currency
Q4 2024 LE1 Adjustments USD 000's Current Year Rate
Q4 2024 LE1 Major driver
Q4 2024 LE1 Variance Comments