Let's talk oil rigs. I've got a stumper here. I'm trying to create two columns which for each unique rigname that shows 1) the Day Rate furthest in the future and 2) the current Day Rate. For instance the Deepwater Discovery has a furthest in the future day rate of 364,000 per day and a current day rate of 201,800. These would be populated in columns AI and AJ. Apologies for the bad html format - ignore the @nbsp (it signifies a space).
Thanks! Loosenut
Edited by Von Pookie
Thanks! Loosenut
Regional Rig Charts 11.7.05.xls | ||||||
---|---|---|---|---|---|---|
AE | AF | AG | AH | |||
2 | Rig Name | Day Rate | Activity Start Date | End Date | ||
3 | Belford Dolphin | 420,000 | 1/18/2007 | 1/17/2010 | ||
4 | Belford Dolphin | - | 11/29/2006 | 1/18/2007 | ||
5 | Belford Dolphin | 176,256 | 8/28/2004 | 11/29/2006 | ||
6 | Deepwater Discovery | - | 7/31/2008 | 9/31/2008 | ||
7 | Deepwater Discovery | 364,000 | 8/1/2006 | 7/31/2008 | ||
8 | Deepwater Discovery | 285,000 | 11/4/2005 | 12/18/2005 | ||
9 | Deepwater Discovery | 201,800 | 9/10/2005 | 11/4/2005 | ||
10 | Deepwater Discovery | 150,000 | 7/10/2005 | 9/10/2005 | ||
11 | Deepwater Expedition | - | 9/1/2008 | 9/2/2008 | ||
12 | Deepwater Expedition | - | 9/3/2006 | 9/1/2008 | ||
13 | Deepwater Expedition | - | 8/2/2006 | 9/3/2006 | ||
14 | Deepwater Expedition | 320,000 | 6/23/2006 | 8/2/2006 | ||
15 | Deepwater Expedition | - | 6/18/2006 | 6/23/2006 | ||
16 | Deepwater Expedition | 240,000 | 2/3/2006 | 6/18/2006 | ||
17 | Deepwater Expedition | - | 12/31/2005 | 2/3/2006 | ||
18 | Deepwater Expedition | - | 11/15/2005 | 11/29/2005 | ||
Fleet List Input UDW |
Edited by Von Pookie