Spreadsheet: 700856d1603373328-conditional-formatting-with-a-collective-formula-conditional-formating-support
Sheet: Sheet1

Account Sales Region | Account Sales Country | Opportunity Owner | Opportunity Name | Opportunity External Id | Campaign Name | Account Name | Account External Id | [NAME] | Expected [NAME] | Submission Deadline | Decision Date | Start Operations Date | End Operations Date | Duration (Months) | Global Projects Industries | Reporting Currency | Total Target Revenue | Gross Profit % | Freight Tonnes | Target Revenue (current year) | Target Revenue (next year) | Target Revenue (in two years) | Commercial Support | Technical Support | Ocean Chartering Support | Engineering Support | Project Region | Project Country | Project Location Report | Created Date | Last Update Date | Opportunity ID | # of Opportunities | # of Opportunity ID | Total Target Revenue | Currency | Competitors
Asia/Pacific | Australia | BOMSI IRANI | GP-AU PROJECT/EMPIRE AU China pipes Cross rail River | WW-WWTWI-300003257425131 | No Campaign | EMPIRE INFRASTRUCTURE PTY LTD | WW-WWTWI-300002533330820 | Decision Pending | 2020-09-21 00:00:00 | 2020-09-30 00:00:00 | 2020-12-16 00:00:00 | 2020-12-31 00:00:00 | 2021-03-09 00:00:00 | 2 | Infrastructure Industry | USD | 643940 | 0.15 | 235 | 643940 | 0 | 0 | N | N | N | N | Asia/Pacific | Australia | Australia | 2020-09-21 00:00:00 | 2020-10-12 00:00:00 | 300003257425131 | 1 | 1 | 550000 | EUR | GEODIS
Asia/Pacific | Australia | BOMSI IRANI | GP-AU PROJECT/INFRASTRUCTURE AU CROSS TRADE PIPES LA | WW-WWTWI-300003217633472 | No Campaign | Infrastructure Solutions Australia | WW-WWTWI-300003146842842 | Decision Pending | 2020-06-24 00:00:00 | 2020-07-01 00:00:00 | 2020-10-26 00:00:00 | 2020-10-28 00:00:00 | 2020-11-11 00:00:00 | 0 | Infrastructure Industry | USD | 1200000 | 0.15 | 9000 | 1200000 | 0 | 0 | Y | N | N | N | Americas |  | Americas | 2020-06-29 00:00:00 | 2020-10-12 00:00:00 | 300003217633472 | 1 | 1 | 1200000 | USD | Agility
Asia/Pacific | Australia | BOMSI IRANI | GP-AU PROJECT/INFRASTRUCTURE AU CROSS TRADE PIPES Seattle | WW-WWTWI-300003237131220 | No Campaign | Infrastructure Solutions Australia | WW-WWTWI-300003146842842 | Decision Pending | 2020-08-10 00:00:00 | 2020-08-25 00:00:00 | 2020-10-28 00:00:00 | 2020-10-29 00:00:00 | 2020-11-30 00:00:00 | 1 | Infrastructure Industry | USD | 250000 | 0.15 | 895 | 250000 | 0 | 0 | N | N | N | N |  |  |  | 2020-08-10 00:00:00 | 2020-10-12 00:00:00 | 300003237131220 | 1 | 1 | 250000 | USD | Agility
Asia/Pacific | Australia | BOMSI IRANI | GP-AU PROJECT/OLEX NEXAN CABLES AU MOLOGIA VALLEY | WW-WWTWI-300003237365507 | No Campaign | OLEX AUSTRALIA PTY LIMITED | AU-SAP331-D0002760531 | Decision Pending | 2020-08-12 00:00:00 | 2020-08-12 00:00:00 | 2020-10-28 00:00:00 | 2020-11-26 00:00:00 | 2020-11-30 00:00:00 | 0 | Power Generation Industry | USD | 1154408.8 | 0.1 | 56 | 1154408.8 | 0 | 0 | N | N | N | N |  |  |  | 2020-08-11 00:00:00 | 2020-10-12 00:00:00 | 300003237365507 | 1 | 1 | 986000 | EUR | KUEHNE & NAGEL
Asia/Pacific | Australia | BOMSI IRANI | GP-AU-PROJECT/CRRC AUSTRALIA HCMT REPAIR TRAIN | WW-WWTWI-300003186604334 | No Campaign | CRRC CHANGCHUN AUSTRALIA P/L | AU-SAP331-D0002680430 | Decision Pending | 2020-05-01 00:00:00 | 2020-05-01 00:00:00 | 2020-12-31 00:00:00 | 2021-01-12 00:00:00 | 2021-12-02 00:00:00 | 11 | Infrastructure Industry | USD | 409780 | 0.15 | 271200 | 0 | 409780 | 0 | N | N | N | N | Asia/Pacific | Australia | Australia | 2020-05-01 00:00:00 | 2020-10-12 00:00:00 | 300003186604334 | 1 | 1 | 350000 | EUR | GEODIS
Asia/Pacific | Australia | [NAME] | GP-AU-Woodside Pluto LNG - Train 2 - Freight Forwarding | WW-WWTWI-300002982774869 | No Campaign | BECHTEL (WESTERN AUSTRALIA PTY LTD) | AU-SAP331-D0002204960 | Prospecting | 2021-06-24 00:00:00 |  | 2021-08-31 00:00:00 | 2021-10-31 00:00:00 | 2025-10-31 00:00:00 | 49 | Oil and Gas Industry | USD | 14049600 | 0.1 | 200000 | 0 | 7024800 | 7024800 | Y | Y |  | N | Asia/Pacific | Australia | Australia | 2019-06-03 00:00:00 | 2020-10-12 00:00:00 | 300002982774869 | 1 | 1 | 12000000 | EUR
Asia/Pacific | Australia | [NAME] | GP-AU- 1 x Catamaran to Mayotte | WW-WWTWI-300003228130440 | No Campaign | SGTM Sarl | WW-WWTWI-300003228130401 | Decision Pending | 2020-06-10 00:00:00 | 2020-06-17 00:00:00 | 2020-11-27 00:00:00 | 2021-04-01 00:00:00 | 2021-04-30 00:00:00 | 1 | Transportation Industry | USD | 295000 | 0.1 | 4960 | 0 | 295000 | 0 | N | N | N | N | Asia/Pacific | Viet Nam | Vietnam | 2020-07-21 00:00:00 | 2020-10-12 00:00:00 | 300003228130440 | 1 | 1 | 295000 | USD
Asia/Pacific | Australia | [NAME] | GP-AU- 3 x Locomotives to Tanzania | WW-WWTWI-300003228130354 | No Campaign | Transeaways Shipping Sdn Bhd | WW-WWTWI-300003228130315 | Decision Pending | 2020-03-16 00:00:00 | 2020-03-23 00:00:00 | 2020-11-25 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 1 | OEM & Machinery Supply | USD | 495000 | 0.05 | 764 | 495000 | 0 | 0 | N | N | N | N | Asia/Pacific | Malaysia | Malaysia | 2020-07-21 00:00:00 | 2020-10-12 00:00:00 | 300003228130354 | 1 | 1 | 495000 | USD
Asia/Pacific | Australia | [NAME] | GP-AU-12 x Rail cars to Newcastle | WW-WWTWI-300003228130340 | No Campaign | Transeaways Shipping Sdn Bhd | WW-WWTWI-300003228130315 | Decision Pending | 2020-04-01 00:00:00 | 2020-04-08 00:00:00 | 2020-11-29 00:00:00 | 2021-01-11 00:00:00 | 2021-02-28 00:00:00 | 2 | Transportation Industry | USD | 250000 | 0.1 | 1584 | 0 | 250000 | 0 | N | N | N | N | Asia/Pacific | Malaysia | Malaysia | 2020-07-21 00:00:00 | 2020-10-12 00:00:00 | 300003228130340 | 1 | 1 | 250000 | USD
Asia/Pacific | Australia | [NAME] | GP-AU-APA WNG Pipeline Project | WW-WWTWI-300003227090742 | No Campaign | [NAME] | WW-WWTWI-300003227090724 | Decision Pending | 2020-07-15 00:00:00 | 2020-07-31 00:00:00 | 2020-11-23 00:00:00 | 2021-04-01 00:00:00 | 2021-12-30 00:00:00 | 9 | Oil and Gas Industry | USD | 10000000 | 0.05 | 61000 | 0 | 10000000 | 0 | N | N | N | N | Asia/Pacific | Australia | Australia | 2020-07-19 00:00:00 | 2020-10-12 00:00:00 | 300003227090742 | 1 | 1 | 10000000 | USD
Asia/Pacific | Australia | [NAME] | GP-AU-BHP Olympic Dam Expansion | WW-WWTWI-300003241340640 | No Campaign | BHP Biliton Iron Ore Pty Ltd | WW-WWTWI-300002697074396 | Prospecting | 2021-08-21 00:00:00 | 2021-08-31 00:00:00 | 2021-09-10 00:00:00 | 2021-10-01 00:00:00 | 2022-08-21 00:00:00 | 11 | Mining Industry | USD | 15000000 | 0.1 | 100000 | 0 | 0 | 15000000 | N | N | N | N | Asia/Pacific | Australia | Australia | 2020-08-21 00:00:00 | 2020-10-12 00:00:00 | 300003241340640 | 1 | 1 | 15000000 | USD
Asia/Pacific | Australia | [NAME] | GP-AU-Cocos Island Airfield Expansion | WW-WWTWI-300003023626752 | No Campaign | Fulton Hogan | WW-WWTWI-300002751092498 | Solution Design | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2023-08-31 00:00:00 | 24 | Infrastructure Industry | USD | 25000000 | 0.1 | 200000 | 0 | 2000000 | 23000000 | N | N |  | N | Asia/Pacific | Australia | Australia | 2019-08-15 00:00:00 | 2020-10-12 00:00:00 | 300003023626752 | 1 | 1 | 25000000 | USD
Asia/Pacific | Australia | [NAME] | GP-AU-Dungowan Dam Pipeline Project | WW-WWTWI-300003232775599 | No Campaign | Viadux | WW-WWTWI-300003232775546 | Decision Pending | 2020-07-23 00:00:00 | 2020-07-30 00:00:00 | 2020-11-26 00:00:00 | 2021-01-31 00:00:00 | 2022-05-31 00:00:00 | 16 | Infrastructure Industry | USD | 2400000 | 0.1 | 40000 | 0 | 1200000 | 1200000 | N | N | N | N | Asia/Pacific | Australia | Australia | 2020-07-31 00:00:00 | 2020-10-12 00:00:00 | 300003232775599 | 1 | 1 | 2400000 | USD
Asia/Pacific | Australia | [NAME] | GP-AU-FMG Ironbridge HDPE Pipe | WW-WWTWI-300003243042209 | No Campaign | Viadux | WW-WWTWI-300003232775546 | Decision Pending | 2020-08-10 00:00:00 | 2020-08-25 00:00:00 | 2020-11-23 00:00:00 | 2021-01-03 00:00:00 | 2021-02-28 00:00:00 | 2 | Mining Industry | USD | 2100000 | 0.1 |  | 0 | 2100000 | 0 | N | N | N | N | Asia/Pacific | Australia | Australia | 2020-08-26 00:00:00 | 2020-10-12 00:00:00 | 300003243042209 | 1 | 1 | 2100000 | USD
Asia/Pacific | Australia | [NAME] | GP-AU-FMG Ironbridge Steel Slurry Pipeline | WW-WWTWI-300003227603695 | AU-FMG Ironbridge Steel Slurry Pipe Project | Mitsui & Co (Steel Division) | WW-WWTWI-300002738812309 | Decision Pending | 2020-07-01 00:00:00 | 2020-07-09 00:00:00 | 2020-11-16 00:00:00 | 2021-01-05 00:00:00 | 2021-06-30 00:00:00 | 6 | Mining Industry | USD | 5500000 | 0.05 | 125000 | 1000000 | 4500000 |  | N | N | N | N | Asia/Pacific | Australia | Australia | 2020-07-20 00:00:00 | 2020-10-12 00:00:00 | 300003227603695 | 1 | 1 | 5500000 | USD
Asia/Pacific | Australia | [NAME] | GP-AU-Orbital Assembly Voyager Project | WW-WWTWI-300003248386244 | No Campaign | Orbital Assembly Corporation | WW-WWTWI-300003248392205 | Prospecting | 2021-02-28 00:00:00 | 2021-03-17 00:00:00 | 2021-05-01 00:00:00 | 2021-05-31 00:00:00 | 2022-05-31 00:00:00 | 12 | Transportation Industry | USD | 3000000 | 0.1 | 150000 | 0 | 1000000 | 2000000 | N | N | N | N | Asia/Pacific | Australia | Australia | 2020-09-03 00:00:00 | 2020-10-12 00:00:00 | 300003248386244 | 1 | 1 | 3000000 | USD
Asia/Pacific | Australia | [NAME] | GP-AU-Qatar Gas Pipeline Project | WW-WWTWI-300003226039963 | No Campaign | [NAME] | WW-WWTWI-300003226256921 | Prospecting | 2020-11-02 00:00:00 | 2020-11-29 00:00:00 | 2020-11-30 00:00:00 | 2021-02-28 00:00:00 | 2022-07-31 00:00:00 | 17 | Oil and Gas Industry | USD | 19000000 | 0.05 | 500000 | 0 | 9000000 | 10000000 | N | N | N | N | Middle East/Africa | Qatar | Qatar | 2020-07-16 00:00:00 | 2020-10-12 00:00:00 | 300003226039963 | 1 | 1 | 19000000 | USD
Asia/Pacific | Australia | [NAME] | GP-AU-Senet PVDC Project | WW-WWTWI-300003248179858 | No Campaign | AG&P | WW-WWTWI-300003226039972 | Decision Pending | 2020-08-28 00:00:00 | 2020-08-31 00:00:00 | 2021-03-31 00:00:00 | 2021-04-01 00:00:00 | 2021-07-31 00:00:00 | 4 | Mining Industry | USD | 1400000 | 0.1 |  | 0 | 1400000 | 0 | N | N | N | N | Asia/Pacific | Australia | Australia | 2020-09-03 00:00:00 | 2020-10-12 00:00:00 | 300003248179858 | 1 | 1 | 1400000 | USD
Asia/Pacific | Australia | [NAME] | GP-AU-Sunshine Project Louisiana | WW-WWTWI-300003232775666 | No Campaign | AG&P | WW-WWTWI-300003226039972 | Decision Pending | 2020-07-29 00:00:00 | 2020-08-06 00:00:00 | 2021-06-30 00:00:00 | 2022-05-31 00:00:00 | 2022-09-30 00:00:00 | 4 | Oil and Gas Industry | USD | 15000000 | 0.05 | 1200000 | 0 | 0 | 15000000 | N | N | N | N | Americas | United States | USA | 2020-07-31 00:00:00 | 2020-10-12 00:00:00 | 300003232775666 | 1 | 1 | 15000000 | USD