To identify the most recent 2 bids from Excel Source

[shannoypaul]

Description:

The attached excel gives details about bids, bids can be of 2 types:

• Direct
• Indirect

The above is captured in field Bid Medium

Bid Medium decides which value to be used for the following computation

• Direct (Bid Qty*Bid Direct Price)
• Indirect (Bid Qty*Bid Indirect price)

Bids for the same Bid Item No. would be generated over a period, if the current bid have been set a higher price than the previous bid the Price Increase or Deviation Flag is set as 1.

Additionally, Bids can have step pricing i.e. Same Bid can have 2 different prices based on Qty (Row 6&7 in Excel).

Another computation is Deviation Amount-

(Bid Indirect Price(Current) - Bid Indirect Price(Previous))*Qty(Current)

For Step Pricing-

(Avg. Bid Indirect Price(Current) - Avg. Bid Indirect Price(Previous))*Qty(Current)

Whereas if the Bid Medium is Direct then for aforesaid computations we should use Bid Direct Price.

Problems faced:

• To Identify the Previous Bid
• To identify Step Pricing
• To switch between Direct/Indirect Price

Kindly help me out with this, Thanks in advance.

Additional Details:

Key- Concatenation of (Bid Item No., Bid Cust. No., Bid Medium, Bid Cust.)

Message was edited by: Shannoy Paul