View Single Post
Old 08-18-2012 | 06:20 PM
  #5  
Redbird611's Avatar
Redbird611
Line Holder
10 Years
30 Countries Visited
 
Joined: Aug 2012
Posts: 567
Likes: 43
Default

Originally Posted by fjetter
Ditto here....been using it for years in addition to the paper book. It makes filtering for application/insurance numbers way easier.
I'm all set as far as filtering/breaking down time goes. LBP databases are easily exported to Excel; I'm just trying to find a way to condense leg by leg information into one day(& ship) per line:

From:
1/1/12 N123AB KATL-KGNV 2.0
1/1/12 N123AB KGNV-KATL 2.2
1/1/12 N145AB KATL-KMYR 1.7
1/1/12 N145AB KMYR-KATL 1.9
1/1/12 N145AB KATL-KCHA 1.0

To:
1/1/12 N123AB KATL-KGNV-KATL 4.2
1/1/12 N145AB KATL-KMYR-KATL-KCHA 4.6


I know this is doable, but I'm not sure what the easiest way is without research. I figured I'd try to see if someone else had worked this out already.
Reply