{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Summary","Bid Pack Trips","Carry Out","View vs Hide","Instructions and Settings","ALV","Res","Roster"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":35,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":4,"n_cols":84,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"Enter Pre-Award"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L2+SUBTOTAL(109,#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(L3<3.47916666666667,\"Required for LCW : \" & IF(L3<2.64583333333333,TEXT(2.64583333333333-L3, \"[hh]:mm\"),\"--:--\") & \" - \" & IF(L3<3.47916666666667,TEXT(3.47916666666667-L3, \"[hh]:mm\"),\"--:--\"),\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUG","SEP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OCT"]
["Pairing"," ","Dates\n+-other dates\nin other rows","Date Mode\n0-Exp\n1-Comp","Detail","Base","AC","Seat","Sen","Name","Layovers","In-Month\nCredit","Pairings\nTowards\nTotal","Towards\ntotal","Carry Out\nCredit","TTL\nCredit","TTL\nPay\nfrom Rot","TTL\nPay\nw/PREM","TTL\nBlock","SIT\nEDP\nCarve","HOL","PREM\n(Calc)","TTL Pay\nw/Prem\n-Block","Blank","Length","TAFB","TTL\nDuty","Check\nIn\nmm/dd hh:mm","Check\nIn\nmm/dd","Check\nIn\nDOW","Check\nIn\nhh:mm","Check\nOut\nmm/dd hh:mm","Check\nOut\nmm/dd","Check\nOutIn\nDOW","Check\nOut\nhh:mm","Start","End","Matches","Longest\nDay","Most\nLegs","Total\nLegs","Avg\nLegs","Longest\nTurn","Shortest\nLayover","Longest\nLayover","FRMS","Earliest\nBodyTZ\nRpt","Latest\nBodyTZ\nRls","BodyTZ\nDelta","Blank","Blank","Rank","31\nMon","1\nTue","2\nWed","3\nThu","4\nFri","5\nSat","6\nSun","7\nMon","8\nTue","9\nWed","10\nThu","11\nFri","12\nSat","13\nSun","14\nMon","15\nTue","16\nWed","17\nThu","18\nFri","19\nSat","20\nSun","21\nMon","22\nTue","23\nWed","24\nThu","25\nFri","26\nSat","27\nSun","28\nMon","29\nTue","30\nWed","1\nThu"]

{"sheet":"Bid Pack Trips","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Paste the pairings from the zip version of the bid package here."]

{"sheet":"Carry Out","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Paste the text from the title file of the zip bid package here."]

{"sheet":"View vs Hide","index":3,"n_rows":64,"n_cols":6,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,2,65,7],[53,2,54,7],[55,2,56,7],[57,2,58,7],[59,2,60,7],[61,2,62,7]]}
[]
[null,"Compact","Expanded"]
[null,"View","View",null,"E","Detail"]
[null,"Hide","Hide",null,"F","Base"]
[null,"Hide","Hide",null,"G","A/C"]
[null,"Hide","Hide",null,"H","Seat"]
[null,"View","View",null,"L","In Month Credit"]
[null,"View","View",null,"M","Include In Month row in Total"]
[null,"Hide","Hide",null,"N","Internal calculation for including in month."]
[null,"View","View",null,"O","Carry Out Credit"]
[null,"View","View",null,"P","Total Credit"]
[null,"View","View",null,"Q","Total Pay (from rotation text)"]
[null,"View","View",null,"R","Total Pay with Prem"]
[null,"View","View",null,"S","Total Block"]
[null,"View","View",null,"T","SIT + EDP + Carve"]
[null,"View","View",null,"U","HOL"]
[null,"View","View",null,"V","PREM (calculated)"]
[null,"View","View",null,"W","Total Pay with Prem - Block"]
[null,"View","View",null,"X","Blank"]
[null,"View","View",null,"Y","Length in days"]
[null,"View","View",null,"Z","TAFB (Time Away From Base)"]
[null,"View","View",null,"AA","TTL Duty"]
[null,"Hide","View",null,"AB","Check In (mm/dd hh:mm)"]
[null,"Hide","Hide",null,"AC","Check In (dd/mm)"]
[null,"Hide","View",null,"AD","Check In (DOW)"]
[null,"View","Hide",null,"AE","Check In (hh:mm)"]
[null,"Hide","View",null,"AF","Check Out (mm/dd hh:mm)"]
[null,"Hide","Hide",null,"AG","Check Out (dd/mm)"]
[null,"Hide","View",null,"AH","Check Out (DOW)"]
[null,"View","Hide",null,"AI","Check Out (hh:mm)"]
[null,"View","View",null,"AJ","Start Station (First non-deadhead leg)"]
[null,"View","View",null,"AK","End Station (Last non-deadhead leg)"]
[null,"View","View",null,"AL","Matching"]
[null,"View","View",null,"AM","Longest Day"]
[null,"View","View",null,"AN","MaxDutyLegs"]
[null,"Hide","Hide",null,"AO","Total Trip Legs"]
[null,"Hide","Hide",null,"AP","Avg Legs per Day"]
[null,"Hide","Hide",null,"AQ","Longest turn"]
[null,"View","View",null,"AR","Shortest layover"]
[null,"View","View",null,"AS","Longest Layover"]
[null,"Hide","Hide",null,"AT","FRMS"]
[null,"View","View",null,"AU","Earliest BodyTZ CheckIn"]
[null,"View","View",null,"AV","Lastest BodyTZ CheckIn"]
[null,"View","View",null,"AW","Body TZ Delta"]
[null,"Hide","Hide",null,"AX","Blank"]
[null,"Hide","Hide",null,"AY","Blank"]
[null,"View","View",null,"AZ","Rank"]
[]
[]
[]
[]
[]
[null,"Explanation:"]
[null,"-","This will allow you to quickly set which columns to view and hide so you can make the tradeoff between information and clutter."]
[]
[null,"-","You can copy from a previous month and paste into another month if you have default values that you like."]
[]
[null,"-","You can still manually hide and unhide columns within the sheet. This is meant as another way of accomplishing the task."]
[]
[null,"-","Expanded view is when you have each occurrence of a pairing on a separate line."]
[]
[null,"-","Contracted view is when you have multiple occurrences of a pairing on one line as long as the in-month and carry-out credit is equal."]
[]
[null,"-","Columns C and D are for the name and seniority of the pilot who got the pairing. These are reveiled after you cross correlate with the roster report. See the Roster tab."]

{"sheet":"Instructions and Settings","index":4,"n_rows":211,"n_cols":27,"rows_kept":211,"cut":false,"hidden":false,"merged":[[149,2,149,10],[51,2,51,14],[37,5,37,11],[39,5,39,11],[32,12,32,15],[41,5,41,12],[42,5,42,11],[40,5,40,11],[36,5,36,6],[4,3,4,5],[22,2,22,9],[25,2,26,9],[6,2,6,15],[16,2,16,15],[14,3,14,11]]}
[]
[null,"About:"]
[null,null,"Version","5.0b"]
[null,null,"Last Update: 9/6/2013","2026-08-16"]
[null,null,"Contact:","thejohnbell@gmail.com"]
[null,"Instructions:"]
[null,null,"1. You need full Excel installed on a computer. Preferably Windows, but it might work on Mac."]
[null,null,"2. Set the yellow highlighted paramters in the Settings section below."]
[null,null,"3. Get the zip bid package. The may not be displayed on DeltaNet, but might be available here:"]
[null,null," ","https://deltaairlines.sharepoint.com/sites/FOP-CrewResourcesScheduling/PBSBidPackages"]
[null,null,"4. Paste the text from the zip into the Bid Pack Trips and Carry Out tabs. Which file is which will be ovious when you open them."]
[null,null,"5. Run the analsis with the button below."]
[]
[null,null,"6. Optional: Create an html version of the summary:"]
[null,null,null,"This is the html version that I published and should include all columns even if they are hidden. There is a less sophisticated version in Summary -> Other Tools that will only include filtered trips and columns.\n\nThe advantage of the html version is that it does not require Excel. It was somewhat of a conceptual demo of a way of publishing the bid package. Since you are reading this, you obviously have Excel. Thus, the html version may be of very limited use."]
[]
[null,null,"Much of the section, with the exception of the yellow highlighted areas is used for running all of the categories in batch and can be ignored."]
[null,"Additional Controls:"]
[]
[]
[]
[]
[null,null,"PC ONLY (Sorry MAC)"]
[]
[]
[null,null,"I use these for creating all of the runs in the beginning of the month. The only thing really lost for Mac is the html export. Unfortunately the html export relies on file writing features that do not work in Mac."]
[]
[]
[null,"Settings:"]
[null,null,"Base",null,null,null,"ex: ATL"]
[null,null,"Equip",null,null,null,"ex: 330"]
[null,null,"Seat",null,null,null,"A or B"]
[null,null,"Bid month text label:",null,"prefix>",null,"ex: Sep 2026",null,null,"Category Pairing Summary ",null,null,null,null,null,null,"<Suffix"]
[null,null,"Bid period begin date:",null,null,null,"m/dd/yyyy"]
[null,null,"Bid period end date:",null,null,null,"m/dd/yyyy"]
[null,null,"DST changeover",null,null,null,"m/dd/yyyy"]
[null,null,"Sort by:",null,null,"In Month credit",null,"This is for the initial construction. You can sort later without having to re-run."]
[null,null,"Folder location of PDF",null,null,"\\\\Mac\\Home\\Documents\\PairingSummaries\\2026 09\\PDF\\"]
[null,null,"   View .pdf after save",null,null,"False"]
[null,null,"Folder location of html",null,null,"\\\\Mac\\Home\\Downloads\\"]
[null,null,"Folder location of Excel",null,null,"\\\\Mac\\Home\\Downloads\\"]
[null,null,"Master pairings file"]
[null,null,"Bid Pack folder",null,null,"\\\\Mac\\Home\\Documents\\PairingSummaries\\All Pairings\\2026 09 PBS Bid Packages"]
[null,null,"Save Excel, Acrobat, and html directly without dialog.",null,null,null,null,null,null,true,null,"note: I use this when I do a lot of them in succession."]
[null,null,"Consolidate same pairing numbers but different dates onto one line. ",null,null,null,null,null,null,true]
[null,null,"Include pairing details as comments.",null,null,null,null,null,null,true," "]
[null,null,"Autofit columns (note: this may be an issue for .pdf)",null,null,null,null,null,null,false]
[null,null,"Purge hotels",null,null,null,null,null,null,false]
[null,null,"Use advanced RPN mode for calculator.",null,null,null,null,null,null,false]
[null,null,"Offer html custom label",null,null,null,null,null,null,true]
[null,null,"Text block below title:"]
[null,null,"-Warning: Use at your own risk. This is not generated or supported by Delta or ALPA.\n-I don't make any warrantees, but e-mail thejohnbell@gmail.com if you find any errors or want to sign up to receive these.\n-Please double check this information before bidding.\n-I have more information at https://johnfbell.com.\n-\"+\" to the left of the date(s) indicates another instance of same pairing number in another row. "]
[null,null,null,null,null,null,null,null,null,null,"Standard Wide Body",null,null,null,null,null,"777 and 350",null,null,null,null,null,"Narrow Body"]
[null,null,"Wide",null,"Narrow",null,"Wide",null,"777 & 350",null,"Compact","Expanded",null,null,null,null,"Compact","Expanded",null,null,null,null,"Compact","Expanded"]
[null,null,"ATL330A",null,"ATL73NA",null,"ATL330A",null,"ATL350A",null,"View","View",null,"E","Detail",null,"View","View",null,"E","Detail",null,"View","View",null,"E","Detail"]
[null,null,"ATL330B",null,"ATL73NB",null,"ATL330B",null,"ATL350B",null,"Hide","Hide",null,"F","Base",null,"Hide","Hide",null,"F","Base",null,"Hide","Hide",null,"F","Base"]
[null,null,"ATL765A",null,"ATL320A",null,"ATL765A",null,"DTW350A",null,"Hide","Hide",null,"G","A/C",null,"Hide","Hide",null,"G","A/C",null,"Hide","Hide",null,"G","A/C"]
[null,null,"ATL765B",null,"ATL320B",null,"ATL765B",null,"DTW350B",null,"Hide","Hide",null,"H","Seat",null,"Hide","Hide",null,"H","Seat",null,"Hide","Hide",null,"H","Seat"]
[null,null,"ATL7ERA",null,"ATL717A",null,"ATL7ERA",null,"LAX350A",null,"View","View",null,"L","In Month Credit",null,"View","View",null,"L","In Month Credit",null,"View","View",null,"L","In Month Credit"]
[null,null,"ATL7ERB",null,"ATL717B",null,"ATL7ERB",null,"LAX350B",null,"View","View",null,"M","Include In Month row in Total",null,"View","View",null,"M","Include In Month row in Total",null,"View","View",null,"M","Include In Month row in Total"]
[null,null,"BOS330A",null,"DTW73NA",null,"BOS330A",null,"SEA350A",null,"Hide","Hide",null,"N","Internal calculation for including in month.",null,"Hide","Hide",null,"N","Internal calculation for including in month.",null,"Hide","Hide",null,"N","Internal calculation for including in month."]
[null,null,"BOS330B",null,"DTW73NB",null,"BOS330B",null,"SEA350B",null,"View","View",null,"O","Carry Out Credit",null,"View","View",null,"O","Carry Out Credit",null,"View","View",null,"O","Carry Out Credit"]
[null,null,"DTW330A",null,"DTW320A",null,"DTW330A",null,null,null,"View","View",null,"P","Total Credit",null,"View","View",null,"P","Total Credit",null,"View","View",null,"P","Total Credit"]
[null,null,"DTW330B",null,"DTW320B",null,"DTW330B",null,null,null,"View","View",null,"Q","Total Pay (from rotation text)",null,"View","View",null,"Q","Total Pay (from rotation text)",null,"View","View",null,"Q","Total Pay (from rotation text)"]
[null,null,"LAX7ERA",null,"DTW717A",null,"LAX7ERA",null,null,null,"View","View",null,"R","Total Pay with Prem",null,"View","View",null,"R","Total Pay with Prem",null,"View","View",null,"R","Total Pay with Prem"]
[null,null,"LAX7ERB",null,"DTW717B",null,"LAX7ERB",null,null,null,"View","View",null,"S","Total Block",null,"View","View",null,"S","Total Block",null,"View","View",null,"S","Total Block"]
[null,null,"MSP330A",null,"LAX73NA",null,"MSP330A",null,null,null,"View","View",null,"T","SIT + EDP + Carve",null,"View","View",null,"T","SIT + EDP + Carve",null,"View","View",null,"T","SIT + EDP + Carve"]
[null,null,"MSP330B",null,"LAX73NB",null,"MSP330B",null,null,null,"View","View",null,"U","HOL",null,"View","View",null,"U","HOL",null,"View","View",null,"U","HOL"]
[null,null,"NYC330A",null,"LAX320A",null,"NYC330A",null,null,null,"View","View",null,"V","PREM (calculated)",null,"View","View",null,"V","PREM (calculated)",null,"View","View",null,"V","PREM (calculated)"]
[null,null,"NYC330B",null,"LAX320B",null,"NYC330B",null,null,null,"View","View",null,"W","Total Pay with Prem - Block",null,"View","View",null,"W","Total Pay with Prem - Block",null,"View","View",null,"W","Total Pay with Prem - Block"]
[null,null,"NYC765A",null,"MSP220A",null,"NYC765A",null,null,null,"View","View",null,"X","Blank",null,"View","View",null,"X","Blank",null,"View","View",null,"X","Blank"]
[null,null,"NYC765B",null,"MSP220B",null,"NYC765B",null,null,null,"View","View",null,"Y","Length in days",null,"View","View",null,"Y","Length in days",null,"View","View",null,"Y","Length in days"]
[null,null,"NYC7ERA",null,"MSP73NA",null,"NYC7ERA",null,null,null,"View","View",null,"Z","TAFB (Time Away From Base)",null,"View","View",null,"Z","TAFB (Time Away From Base)",null,"View","View",null,"Z","TAFB (Time Away From Base)"]
[null,null,"NYC7ERB",null,"MSP73NB",null,"NYC7ERB",null,null,null,"View","View",null,"AA","TTL Duty",null,"View","View",null,"AA","TTL Duty",null,"View","View",null,"AA","TTL Duty"]
[null,null,"SEA330A",null,"MSP320A",null,"SEA330A",null,null,null,"Hide","View",null,"AB","Check In (mm/dd hh:mm)",null,"Hide","View",null,"AB","Check In (mm/dd hh:mm)",null,"Hide","View",null,"AB","Check In (mm/dd hh:mm)"]
[null,null,"SEA330B",null,"MSP320B",null,"SEA330B",null,null,null,"Hide","Hide",null,"AC","Check In (dd/mm)",null,"Hide","Hide",null,"AC","Check In (dd/mm)",null,"Hide","Hide",null,"AC","Check In (dd/mm)"]
[null,null,null,null,"NYC73NA",null,null,null,null,null,"Hide","View",null,"AD","Check In (DOW)",null,"Hide","View",null,"AD","Check In (DOW)",null,"Hide","View",null,"AD","Check In (DOW)"]
[null,null,null,null,"NYC73NB",null,null,null,null,null,"View","Hide",null,"AE","Check In (hh:mm)",null,"View","Hide",null,"AE","Check In (hh:mm)",null,"View","Hide",null,"AE","Check In (hh:mm)"]
[null,null,null,null,"NYC320A",null,null,null,null,null,"Hide","View",null,"AF","Check Out (mm/dd hh:mm)",null,"Hide","View",null,"AF","Check Out (mm/dd hh:mm)",null,"Hide","View",null,"AF","Check Out (mm/dd hh:mm)"]
[null,null,null,null,"NYC320B",null,null,null,null,null,"Hide","Hide",null,"AG","Check Out (dd/mm)",null,"Hide","Hide",null,"AG","Check Out (dd/mm)",null,"Hide","Hide",null,"AG","Check Out (dd/mm)"]
[null,null,null,null,"NYC220A",null,null,null,null,null,"Hide","View",null,"AH","Check Out (DOW)",null,"Hide","View",null,"AH","Check Out (DOW)",null,"Hide","View",null,"AH","Check Out (DOW)"]
[null,null,null,null,"NYC220B",null,null,null,null,null,"View","Hide",null,"AI","Check Out (hh:mm)",null,"View","Hide",null,"AI","Check Out (hh:mm)",null,"View","Hide",null,"AI","Check Out (hh:mm)"]
[null,null,null,null,"SEA73NA",null,null,null,null,null,"View","View",null,"AJ","Start Station (First non-deadhead leg)",null,"View","View",null,"AJ","Start Station (First non-deadhead leg)",null,"View","View",null,"AJ","Start Station (First non-deadhead leg)"]
[null,null,null,null,"SEA73NB",null,null,null,null,null,"View","View",null,"AK","End Station (Last non-deadhead leg)",null,"View","View",null,"AK","End Station (Last non-deadhead leg)",null,"View","View",null,"AK","End Station (Last non-deadhead leg)"]
[null,null,null,null,"SEA320A",null,null,null,null,null,"View","View",null,"AL","Matching",null,"View","View",null,"AL","Matching",null,"Hide","Hide",null,"AL","Matching"]
[null,null,null,null,"SEA320B",null,null,null,null,null,"View","View",null,"AM","Longest Day",null,"Hide","Hide",null,"AM","Longest Day",null,"View","View",null,"AM","Longest Day"]
[null,null,null,null,"SEA220A",null,null,null,null,null,"View","View",null,"AN","MaxDutyLegs",null,"Hide","Hide",null,"AN","MaxDutyLegs",null,"View","View",null,"AN","MaxDutyLegs"]
[null,null,null,null,"SEA220B",null,null,null,null,null,"Hide","Hide",null,"AO","Total Trip Legs",null,"Hide","Hide",null,"AO","Total Trip Legs",null,"Hide","Hide",null,"AO","Total Trip Legs"]
[null,null,null,null,"SLC73NA",null,null,null,null,null,"Hide","Hide",null,"AP","Avg Legs per Day",null,"Hide","Hide",null,"AP","Avg Legs per Day",null,"Hide","Hide",null,"AP","Avg Legs per Day"]
[null,null,null,null,"SLC73NB",null,null,null,null,null,"Hide","Hide",null,"AQ","Longest turn",null,"Hide","Hide",null,"AQ","Longest turn",null,"View","View",null,"AQ","Longest turn"]
[null,null,null,null,"SLC320A",null,null,null,null,null,"View","View",null,"AR","Shortest layover",null,"Hide","Hide",null,"AR","Shortest layover",null,"View","View",null,"AR","Shortest layover"]
[null,null,null,null,"SLC320B",null,null,null,null,null,"View","View",null,"AS","Longest Layover",null,"View","View",null,"AS","Longest Layover",null,"Hide","Hide",null,"AS","Longest Layover"]
[null,null,null,null,"SLC220A",null,null,null,null,null,"Hide","Hide",null,"AT","FRMS",null,"View","View",null,"AT","FRMS",null,"Hide","Hide",null,"AT","FRMS"]
[null,null,null,null,"SLC220B",null,null,null,null,null,"View","View",null,"AU","Earliest BodyTZ CheckIn",null,"Hide","Hide",null,"AU","Earliest BodyTZ CheckIn",null,"View","View",null,"AU","Earliest BodyTZ CheckIn"]
[null,null,null,null,null,null,null,null,null,null,"View","View",null,"AV","Lastest BodyTZ CheckIn",null,"Hide","Hide",null,"AV","Lastest BodyTZ CheckIn",null,"View","View",null,"AV","Lastest BodyTZ CheckIn"]
[null,null,null,null,null,null,null,null,null,null,"View","View",null,"AW","Body TZ Delta",null,"Hide","Hide",null,"AW","Body TZ Delta",null,"View","View",null,"AW","Body TZ Delta"]
[null,null,null,null,null,null,null,null,null,null,"Hide","Hide",null,"AX","Blank",null,"Hide","Hide",null,"AX","Blank",null,"Hide","Hide",null,"AX","Blank"]
[null,null,null,null,null,null,null,null,null,null,"Hide","Hide",null,"AY","Blank",null,"Hide","Hide",null,"AY","Blank",null,"Hide","Hide",null,"AY","Blank"]
[null,null,null,null,null,null,null,null,null,null,"View","View",null,"AZ","Rank",null,"View","View",null,"AZ","Rank",null,"View","View",null,"AZ","Rank"]
[]
[null,null,null,null,null,null,null,null,null,null,"View Count",null,null,null,null,null,"View Count",null,null,null,null,null,"View Count"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(K55:K99,\"View\")","v":29},{"$f":"COUNTIF(L55:L99,\"View\")","v":31},null,null,null,null,{"$f":"COUNTIF(Q55:Q99,\"View\")","v":24},{"$f":"COUNTIF(R55:R99,\"View\")","v":26},null,null,null,null,{"$f":"COUNTIF(W55:W99,\"View\")","v":28},{"$f":"COUNTIF(X55:X99,\"View\")","v":30}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Purpose:"]
[null,null,"There are pilots, especially wide body pilots, who like to bid by individual trip instead of by trip properties. This workbook creates a summary. There are a couple of bits of data that are not available directly from Navtech-- the in month credit , carry out credit, and whether the trip begins or ends in a deadhead. \n\nMost of the columns are self explanatory, except for the trip end and beginning. This is where the first non-deadhead leg starts or ends as appropriate."]
[]
[null,"Intellectual property notice"]
[null,null,"You are welcome to copy, imitate, or develop a variation on any feature in here. "]
[]
[null,"Instructions for running the analysis. Normally this is already done and is unnecessary:"]
[null,null,"Run analysis:"]
[null,null,null,"1. Verify the settings above."]
[null,null,null,"2. Enter Reserve and ALV tables. "]
[null,null,null,"   Note: This is not necessary for individual use. The feature puts the reserve and ALV stats at the bottom for distribution."]
[null,null,null,"3. Paste the Navtech pairing details."]
[null,null,null,"   a. Click on the Pairings button in the web UI of Navtech, https://deltapilotbids.delta.com."]
[null,null,null,"   b. Do not enter any parameters and click the Search button."]
[null,null,null,"   c. Select the check box in the column header to select all trips."]
[null,null,null,"   d. Click on View Details."]
[null,null,null,"   e. Use Edit->Select All->Copy to copy the pairing details and then paste into the Pairing Details from Navtech tab."]
[null,null,null,"4. Paste this into the \"Pairing Details from Navtech\" tab."]
[null,null,null,"5. Run the macro using the button on the stats page."]
[null,null,"Other features:"]
[null,null,null,"1. Double click on a pairing in the Stats tab to go to the detail in the Pairing Details from Navtech."]
[null,null,null,"2. Double click in the Pairing Details from Navtech to jump back to the Stats tab."]
[null,null,null,"3. The time calculator on the Summary tab allows you to add times. Subtract times by adding a negative time."]
[]
[null,"Changes"]
[null,null,"50b","Tweaks to 50a."]
[null,null,"50a","First version of transition to self service."]
[null,null,"44c","Fixed the label is 738 instead of 73N Pilot Pairings"]
[null,null,"44b","Based on 43e. Displays all columns in Excel and all fields for html."]
[null,null,"44a","Internal fork."]
[null,null,"43e","Re-arranged columns to accommodate premium pay."]
[null,null,"43d","Adapted to the word \"PREMIUM\" added to premium pairings."]
[null,null,"43c","Updated the HTML file to polish it up a little."]
[null,null,"43b","Changed HTML to add Pairings column using JavaScript rather than pre-populating to manage file size."]
[null,null,"43a","Added details in column E and made major updates to the html version to include details and scoring."]
[null,null,"42h","Updated html ouput for producing the run summaries."]
[null,null,"42g","Updated custom html output."]
[null,null,"42f","Changed FRMS to look for 99.59 in trip instead of lookup by city pair."]
[null,null,"42e","Significant changes to html output."]
[null,null,"42d","Fixed Roster import to show filtering in Summary tab."]
[null,null,"42c"]
[null,null,"42b","Added fix for strange Aug effective date format."]
[null,null,"42a","I added info for earliest report and latest release."]
[null,null,"41a","Fixed custom html page"]
[null,null,"41a","Added home base times."]
[null,null,"41a","Re-instated hyperlinks"]
[null,null,"40f","Fixed identification of layovers again."]
[null,null,"40e","Fixed identification of layovers where the text is DTY instead of CRD."]
[null,null,"40d","Internal upgrades."]
[null,null,"40c","Internal upgrades."]
[null,null,"40b","Fixes check in with date and block."]
[null,null,"40a","Significant re-write to use Delta bid package instead of NAVBLUE pairings."]
[null,null,"30a","Added pay lookup from Delta pairings."]
[null,null,"20k","Updated html version to show pairing detail in a dialog box."]
[null,null,"20j","Fixed hyperlinks in Excel version."]
[null,null,"20i","Created html output file with the ability to change date modes."]
[null,null,"20h","Switched total logic from a Y or y to allow input of number of pairings to add."]
[null,null,"20g","Adapted for categories with no trips."]
[null,null,"20f","Added weekend shading in Summary tab matrix."]
[null,null,"20e","Fixed credit required for LCW formula."]
[null,null,"20d","Added FRMS logic"]
[null,null,"20c","Fixed time to ALV erasing during toggling of filter."]
[null,null,"20b","Corrected X of Y showing formula."]

{"sheet":"ALV","index":5,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,2,20,5]]}
["Eqpt","Captain","FO",null,"Captain text","F/O text"]
[null,null,null,null,{"$f":"IF($A2=\"\",\"\",\"ALV: \" & TEXT(B2,\"[h]:mm\") & \"  LCW: \" &  TEXT(B2-10/24, \"[h]:mm\") & \" to \" &  TEXT(IF(B2+10/24 > 92.5/24,92.5/24,B2+10/24), \"[h]:mm\"))","v":""},{"$f":"IF($A2=\"\",\"\",\"ALV: \" & TEXT(C2,\"[h]:mm\") & \"  LCW: \" &  TEXT(C2-10/24, \"[h]:mm\") & \" to \" &  TEXT(IF(C2+10/24 > 92.5/24,92.5/24,C2+10/24), \"[h]:mm\"))","v":""},"<-Fill in columns A, B, and C. Columns E and F are calculated."]
[null,null,null,null,{"$f":"IF($A3=\"\",\"\",\"ALV: \" & TEXT(B3,\"[h]:mm\") & \"  LCW: \" &  TEXT(B3-10/24, \"[h]:mm\") & \" to \" &  TEXT(IF(B3+10/24 > 92.5/24,92.5/24,B3+10/24), \"[h]:mm\"))","v":""},{"$f":"IF($A3=\"\",\"\",\"ALV: \" & TEXT(C3,\"[h]:mm\") & \"  LCW: \" &  TEXT(C3-10/24, \"[h]:mm\") & \" to \" &  TEXT(IF(C3+10/24 > 92.5/24,92.5/24,C3+10/24), \"[h]:mm\"))","v":""}]
[null,null,null,null,"",""]
[null,null,null,null,{"$f":"IF($A5=\"\",\"\",\"ALV: \" & TEXT(B5,\"[h]:mm\") & \"  LCW: \" &  TEXT(B5-10/24, \"[h]:mm\") & \" to \" &  TEXT(IF(B5+10/24 > 91.5/24,91.5/24,B5+10/24), \"[h]:mm\"))","v":""},{"$f":"IF($A5=\"\",\"\",\"ALV: \" & TEXT(C5,\"[h]:mm\") & \"  LCW: \" &  TEXT(C5-10/24, \"[h]:mm\") & \" to \" &  TEXT(IF(C5+10/24 > 91.5/24,91.5/24,C5+10/24), \"[h]:mm\"))","v":""}]
[null,null,null,null,{"$f":"IF($A6=\"\",\"\",\"ALV: \" & TEXT(B6,\"[h]:mm\") & \"  LCW: \" &  TEXT(B6-10/24, \"[h]:mm\") & \" to \" &  TEXT(IF(B6+10/24 > 91.5/24,91.5/24,B6+10/24), \"[h]:mm\"))","v":""},{"$f":"IF($A6=\"\",\"\",\"ALV: \" & TEXT(C6,\"[h]:mm\") & \"  LCW: \" &  TEXT(C6-10/24, \"[h]:mm\") & \" to \" &  TEXT(IF(C6+10/24 > 91.5/24,91.5/24,C6+10/24), \"[h]:mm\"))","v":""}]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,{"$f":"IF($A10=\"\",\"\",\"ALV: \" & TEXT(B10,\"[h]:mm\") & \"  LCW: \" &  TEXT(IF((B10-7.5/24)>65/24,B10-7.5/24,65/24), \"[h]:mm\") & \" to \" &  TEXT(B10+7.5/24, \"[h]:mm\"))","v":""},{"$f":"IF($A10=\"\",\"\",\"ALV: \" & TEXT(C10,\"[h]:mm\") & \"  LCW: \" &  TEXT(IF((C10-7.5/24)>65/24,C10-7.5/24,65/24), \"[h]:mm\") & \" to \" &  TEXT(C10+7.5/24, \"[h]:mm\"))","v":""}]
[null,null,null,null,{"$f":"IF($A11=\"\",\"\",\"ALV: \" & TEXT(B11,\"[h]:mm\") & \"  LCW: \" &  TEXT(IF((B11-7.5/24)>65/24,B11-7.5/24,65/24), \"[h]:mm\") & \" to \" &  TEXT(B11+7.5/24, \"[h]:mm\"))","v":""},{"$f":"IF($A11=\"\",\"\",\"ALV: \" & TEXT(C11,\"[h]:mm\") & \"  LCW: \" &  TEXT(IF((C11-7.5/24)>65/24,C11-7.5/24,65/24), \"[h]:mm\") & \" to \" &  TEXT(C11+7.5/24, \"[h]:mm\"))","v":""}]
[]
[null,null,null,null,{"$f":"IF($A13=\"\",\"\",\"ALV: \" & TEXT(B13,\"[h]:mm\") & \"  LCW: \" &  TEXT(IF((B13-7.5/24)>65/24,B13-7.5/24,65/24), \"[h]:mm\") & \" to \" &  TEXT(B13+7.5/24, \"[h]:mm\"))","v":""},""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[null,null,null,null,"",""]
[]
[]
["LCW formula:",null,"f:=IF(L3<3.47916666666667,\"Required for LCW : \" & IF(L3<2.64583333333333,TEXT(2.64583333333333-L3, \"[hh]:mm\"),\"--:--\") & \" - \" & IF(L3<3.47916666666667,TEXT(3.47916666666667-L3, \"[hh]:mm\"),\"--:--\"),\"\")"]

{"sheet":"Res","index":6,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Category","Min On","Max On","Max X day\n blocks"]
[null,null,null,null,null,null,"<- Fill in columns A, B, and C"]

{"sheet":"Roster","index":7,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Paste NAVBLUE Roster Report here. "]
["It is part of the Composite report. Navigate to the Roster report using the blue bar at the top of the Composite report."]