FlyerTalk Forums - View Single Post - AM: SFO-MEX $436 RT in Business. Other cities a bit more
Old Jun 4, 2019, 5:04 am
  #12  
laptoptravel
 
Join Date: Nov 2014
Programs: DL DM, UA, AA EXP, AS MVP75K GOLD, HHonors Diamond, BW Diamond, SPG Gold, Hyatt Diamond
Posts: 382
I have several spreadsheets--basically one for every major carrier out there...you can use an IF statement (that's what I do) for segments that do not meet the minimum:

=IF(logical_test, value_if_true, value_if_false)

I also scrape the segment data from GCMAP, so we are thinking along the same lines...

Hope that helps...
laptoptravel is offline