# RUDRA Feedback (09/04/2026 | 8:30 PM IST)

## Contract Value and Owners List
- Filter the contract_number
- consider the contract value
- Clean the vendors
- Vendor : Look up

## EW all Data
- (Contract Number + Record Number) is the unique identifier for the data
- Record Number consider AW & EW both as EARLY WARNINGS
- For EW there can be NCE, check the NCE Number
- Clean NCE Number
- Update the Project pickle to pickleline
- Map the contract to the value in the Contract Value and Owners List
- Project : Look up
- Area : Look up
- Category : Look up
- Early Warning Type : Look up
- EW Accepted, EW Rejected, Under Discussion

## NCE
- Update the Project pickle to pickleline
- Map the contract to the value in the Contract Value and Owners List
- (Contract Number + Record Number) is the unique identifier for the data
- Compensation Event Type : Look up
- Is Notification a Compensation Event? : Look up
- Project : Look up

## Q and NCE Data
- Project - Area : Look up
- Map the contract to the value in the Contract Value and Owners List
- (Contract Number + Record Number) is the unique identifier for the data
- Status : Look up
- Identify the Quotations Revisied, check the (Change to the prices OR Revisied Quote No)
- One quotation can have multiple versions
- Each revision should be stored as a new record
- Maintain version_number and previous_version_reference
- Mark only one version as active


## Others
- EW may exist without NCE
- NCE may exist without EW
- Quotation may exist without NCE


---

## Observations

### Contract Value and Owners List
- Sarens Uk Ltd 4.4.1.1 3701.00025.SRN.200000.PR.CON.CD.00001 : has no EWS, NCE, Q data
    - Pert SRL (BOS Lagoon Pumphouse) : not found anywhere
    - Sarens (Removal/Installation of Cranes) : not found anywhere
    - Skelton Thomas Eng (Roof opening & replacement works for gantry crane removals) : not found anywhere
- Isra Parsytec GMBH PEL6002 3701.00025.ISR.600000.PR.CON.CD.00002 : ISRA
    - Andritz (ARP) : Andritz AG Acid Regeneration Plant - Pickleline - TSUK
    - Isra Parsytec (Surface Inspection) : Isra Parsytec GMBH PEL6002 3701.00025.ISR.600000.PR.CON.CD.00002
- Atkinsrealis PPS Ltd SPC0001 3701.00025.AKR.000000.PR.CON.CD.00001 : AtkinsRéalis Option A
    - AtkinsRéalis Option A : Atkinsrealis PPS Ltd SPC0001 3701.00025.AKR.000000.PR.CON.CD.00001
    - Procter Brothers : not found anywhere
    - Wilson James : Sir Robert McAlpine Ltd ECI2002 3701.00025.SRM.200000.PR.CON.CD.00005

---

## Logs
- directly available
- from other sheet, sheet name