{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calendar","Time Zones","Info and Settings"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Calendar","index":0,"n_rows":734,"n_cols":26,"rows_kept":734,"cut":false,"hidden":false,"merged":[[0,23,1,25],[0,18,1,22],[1,4,1,5],[1,10,1,13],[0,2,0,13],[0,14,1,17]]}
[null,null,"Trip Properties",null,null,null,null,null,null,null,null,null,null,null,"Flight Duty Periods\n(UTC)",null,null,null,"Rest\n(UTC)",null,null,null,null,"Cumulative Limits"]
[null,null,null,null,"Local TZ",null,null,null,null,null,"UTC"]
[null,"ID","Trip\nLeg","Duty\nLeg","LCL\nOff","LCL\nOn","Leg\nBLK","Trip\nBlk","Count\nBlk","Rest","UTC\nRpt","UTC\nOff","UTC\nOn","TZ\nOffSet","No.","Start","End","Length","No.","Start","End","Length","Longest\nin 168\n30 MIN","Block\nin 672\n100 MAX","FDP\nin 168\n60 MAX","FDP\nin 672\n190 MAX"]
["2024-01-01"]
["2024-01-02"]
["2024-01-03"]
["2024-01-04"]
["2024-01-05"]
["2024-01-06"]
["2024-01-07"]
["2024-01-08"]
["2024-01-09"]
["2024-01-10"]
["2024-01-11"]
["2024-01-12"]
["2024-01-13"]
["2024-01-14"]
["2024-01-15"]
["2024-01-16"]
["2024-01-17"]
["2024-01-18"]
["2024-01-19"]
["2024-01-20"]
["2024-01-21"]
["2024-01-22"]
["2024-01-23"]
["2024-01-24"]
["2024-01-25"]
["2024-01-26"]
["2024-01-27"]
["2024-01-28"]
["2024-01-29"]
["2024-01-30"]
["2024-01-31"]
["2024-02-01"]
["2024-02-02"]
["2024-02-03"]
["2024-02-04"]
["2024-02-05"]
["2024-02-06"]
["2024-02-07"]
["2024-02-08"]
["2024-02-09"]
["2024-02-10"]
["2024-02-11"]
["2024-02-12"]
["2024-02-13"]
["2024-02-14"]
["2024-02-15"]
["2024-02-16"]
["2024-02-17"]
["2024-02-18"]
["2024-02-19"]
["2024-02-20"]
["2024-02-21"]
["2024-02-22"]
["2024-02-23"]
["2024-02-24"]
["2024-02-25"]
["2024-02-26"]
["2024-02-27"]
["2024-02-28"]
["2024-02-29"]
["2024-03-01"]
["2024-03-02"]
["2024-03-03"]
["2024-03-04"]
["2024-03-05"]
["2024-03-06"]
["2024-03-07"]
["2024-03-08"]
["2024-03-09"]
["2024-03-10"]
["2024-03-11"]
["2024-03-12"]
["2024-03-13"]
["2024-03-14"]
["2024-03-15"]
["2024-03-16"]
["2024-03-17"]
["2024-03-18"]
["2024-03-19"]
["2024-03-20"]
["2024-03-21"]
["2024-03-22"]
["2024-03-23"]
["2024-03-24"]
["2024-03-25"]
["2024-03-26"]
["2024-03-27"]
["2024-03-28"]
["2024-03-29"]
["2024-03-30"]
["2024-03-31"]
["2024-04-01"]
["2024-04-02"]
["2024-04-03"]
["2024-04-04"]
["2024-04-05"]
["2024-04-06"]
["2024-04-07"]
["2024-04-08"]
["2024-04-09"]
["2024-04-10"]
["2024-04-11"]
["2024-04-12"]
["2024-04-13"]
["2024-04-14"]
["2024-04-15"]
["2024-04-16"]
["2024-04-17"]
["2024-04-18"]
["2024-04-19"]
["2024-04-20"]
["2024-04-21"]
["2024-04-22"]
["2024-04-23"]
["2024-04-24"]
["2024-04-25"]
["2024-04-26"]
["2024-04-27"]
["2024-04-28"]
["2024-04-29"]
["2024-04-30"]
["2024-05-01"]
["2024-05-02"]
["2024-05-03"]
["2024-05-04"]
["2024-05-05"]
["2024-05-06"]
["2024-05-07"]
["2024-05-08"]
["2024-05-09"]
["2024-05-10"]
["2024-05-11"]
["2024-05-12"]
["2024-05-13"]
["2024-05-14"]
["2024-05-15"]
["2024-05-16"]
["2024-05-17"]
["2024-05-18"]
["2024-05-19"]
["2024-05-20"]
["2024-05-21"]
["2024-05-22"]
["2024-05-23"]
["2024-05-24"]
["2024-05-25"]
["2024-05-26"]
["2024-05-27"]
["2024-05-28"]
["2024-05-29"]
["2024-05-30"]
["2024-05-31"]
["2024-06-01"]
["2024-06-02"]
["2024-06-03"]
["2024-06-04"]
["2024-06-05"]
["2024-06-06"]
["2024-06-07"]
["2024-06-08"]
["2024-06-09"]
["2024-06-10"]
["2024-06-11"]
["2024-06-12"]
["2024-06-13"]
["2024-06-14"]
["2024-06-15"]
["2024-06-16"]
["2024-06-17"]
["2024-06-18"]
["2024-06-19"]
["2024-06-20"]
["2024-06-21"]
["2024-06-22"]
["2024-06-23"]
["2024-06-24"]
["2024-06-25"]
["2024-06-26"]
["2024-06-27"]
["2024-06-28"]
["2024-06-29"]
["2024-06-30"]
["2024-07-01"]
["2024-07-02"]
["2024-07-03"]
["2024-07-04"]
["2024-07-05"]
["2024-07-06"]
["2024-07-07"]
["2024-07-08"]
["2024-07-09"]
["2024-07-10"]
["2024-07-11"]
["2024-07-12"]
["2024-07-13"]
["2024-07-14"]
["2024-07-15"]
["2024-07-16"]
["2024-07-17"]
["2024-07-18"]
["2024-07-19"]
["2024-07-20"]
["2024-07-21"]
["2024-07-22"]
["2024-07-23"]
["2024-07-24"]
["2024-07-25"]
["2024-07-26"]
["2024-07-27"]
["2024-07-28"]
["2024-07-29"]
["2024-07-30"]
["2024-07-31"]
["2024-08-01"]
["2024-08-02"]
["2024-08-03"]
["2024-08-04"]
["2024-08-05"]
["2024-08-06"]
["2024-08-07"]
["2024-08-08"]
["2024-08-09"]
["2024-08-10"]
["2024-08-11"]
["2024-08-12"]
["2024-08-13"]
["2024-08-14"]
["2024-08-15"]
["2024-08-16"]
["2024-08-17"]
["2024-08-18"]
["2024-08-19"]
["2024-08-20"]
["2024-08-21"]
["2024-08-22"]
["2024-08-23"]
["2024-08-24"]
["2024-08-25"]
["2024-08-26"]
["2024-08-27"]
["2024-08-28"]
["2024-08-29"]
["2024-08-30"]
["2024-08-31"]
["2024-09-01"]
["2024-09-02"]
["2024-09-03"]
["2024-09-04"]
["2024-09-05"]
["2024-09-06"]
["2024-09-07"]
["2024-09-08"]
["2024-09-09"]
["2024-09-10"]
["2024-09-11"]
["2024-09-12"]
["2024-09-13"]
["2024-09-14"]
["2024-09-15"]
["2024-09-16"]
["2024-09-17"]
["2024-09-18"]
["2024-09-19"]
["2024-09-20"]
["2024-09-21"]
["2024-09-22"]
["2024-09-23"]
["2024-09-24"]
["2024-09-25"]
["2024-09-26"]
["2024-09-27"]
["2024-09-28"]
["2024-09-29"]
["2024-09-30"]
["2024-10-01"]
["2024-10-02"]
["2024-10-03"]
["2024-10-04"]
["2024-10-05"]
["2024-10-06"]
["2024-10-07"]
["2024-10-08"]
["2024-10-09"]
["2024-10-10"]
["2024-10-11"]
["2024-10-12"]
["2024-10-13"]
["2024-10-14"]
["2024-10-15"]
["2024-10-16"]
["2024-10-17"]
["2024-10-18"]
["2024-10-19"]
["2024-10-20"]
["2024-10-21"]
["2024-10-22"]
["2024-10-23"]
["2024-10-24"]
["2024-10-25"]
["2024-10-26"]
["2024-10-27"]
["2024-10-28"]
["2024-10-29"]
["2024-10-30"]
["2024-10-31"]
["2024-11-01"]
["2024-11-02"]
["2024-11-03"]
["2024-11-04"]
["2024-11-05"]
["2024-11-06"]
["2024-11-07"]
["2024-11-08"]
["2024-11-09"]
["2024-11-10"]
["2024-11-11"]
["2024-11-12"]
["2024-11-13"]
["2024-11-14"]
["2024-11-15"]
["2024-11-16"]
["2024-11-17"]
["2024-11-18"]
["2024-11-19"]
["2024-11-20"]
["2024-11-21"]
["2024-11-22"]
["2024-11-23"]
["2024-11-24"]
["2024-11-25"]
["2024-11-26"]
["2024-11-27"]
["2024-11-28"]
["2024-11-29"]
["2024-11-30"]
["2024-12-01"]
["2024-12-02"]
["2024-12-03"]
["2024-12-04"]
["2024-12-05"]
["2024-12-06"]
["2024-12-07"]
["2024-12-08"]
["2024-12-09"]
["2024-12-10"]
["2024-12-11"]
["2024-12-12"]
["2024-12-13"]
["2024-12-14"]
["2024-12-15"]
["2024-12-16"]
["2024-12-17"]
["2024-12-18"]
["2024-12-19"]
["2024-12-20"]
["2024-12-21"]
["2024-12-22"]
["2024-12-23"]
["2024-12-24"]
["2024-12-25"]
["2024-12-26"]
["2024-12-27"]
["2024-12-28"]
["2024-12-29"]
["2024-12-30"]
["2024-12-31"]
["2025-01-01"]
["2025-01-02"]
["2025-01-03"]
["2025-01-04"]
["2025-01-05"]
["2025-01-06"]
["2025-01-07"]
["2025-01-08"]
["2025-01-09"]
["2025-01-10"]
["2025-01-11"]
["2025-01-12"]
["2025-01-13"]
["2025-01-14"]
["2025-01-15"]
["2025-01-16"]
["2025-01-17"]
["2025-01-18"]
["2025-01-19"]
["2025-01-20"]
["2025-01-21"]
["2025-01-22"]
["2025-01-23"]
["2025-01-24"]
["2025-01-25"]
["2025-01-26"]
["2025-01-27"]
["2025-01-28"]
["2025-01-29"]
["2025-01-30"]
["2025-01-31"]
["2025-02-01"]
["2025-02-02"]
["2025-02-03"]
["2025-02-04"]
["2025-02-05"]
["2025-02-06"]
["2025-02-07"]
["2025-02-08"]
["2025-02-09"]
["2025-02-10"]
["2025-02-11"]
["2025-02-12"]
["2025-02-13"]
["2025-02-14"]
["2025-02-15"]
["2025-02-16"]
["2025-02-17"]
["2025-02-18"]
["2025-02-19"]
["2025-02-20"]
["2025-02-21"]
["2025-02-22"]
["2025-02-23"]
["2025-02-24"]
["2025-02-25"]
["2025-02-26"]
["2025-02-27"]
["2025-02-28"]
["2025-03-01"]
["2025-03-02"]
["2025-03-03"]
["2025-03-04"]
["2025-03-05"]
["2025-03-06"]
["2025-03-07"]
["2025-03-08"]
["2025-03-09"]
["2025-03-10"]
["2025-03-11"]
["2025-03-12"]
["2025-03-13"]
["2025-03-14"]
["2025-03-15"]
["2025-03-16"]
["2025-03-17"]
["2025-03-18"]
["2025-03-19"]
["2025-03-20"]
["2025-03-21"]
["2025-03-22"]
["2025-03-23"]
["2025-03-24"]
["2025-03-25"]
["2025-03-26"]
["2025-03-27"]
["2025-03-28"]
["2025-03-29"]
["2025-03-30"]
["2025-03-31"]
["2025-04-01"]
["2025-04-02"]
["2025-04-03"]
["2025-04-04"]
["2025-04-05"]
["2025-04-06"]
["2025-04-07"]
["2025-04-08"]
["2025-04-09"]
["2025-04-10"]
["2025-04-11"]
["2025-04-12"]
["2025-04-13"]
["2025-04-14"]
["2025-04-15"]
["2025-04-16"]
["2025-04-17"]
["2025-04-18"]
["2025-04-19"]
["2025-04-20"]
["2025-04-21"]
["2025-04-22"]
["2025-04-23"]
["2025-04-24"]
["2025-04-25"]
["2025-04-26"]
["2025-04-27"]
["2025-04-28"]
["2025-04-29"]
["2025-04-30"]
["2025-05-01"]
["2025-05-02"]
["2025-05-03"]
["2025-05-04"]
["2025-05-05"]
["2025-05-06"]
["2025-05-07"]
["2025-05-08"]
["2025-05-09"]
["2025-05-10"]
["2025-05-11"]
["2025-05-12"]
["2025-05-13"]
["2025-05-14"]
["2025-05-15"]
["2025-05-16"]
["2025-05-17"]
["2025-05-18"]
["2025-05-19"]
["2025-05-20"]
["2025-05-21"]
["2025-05-22"]
["2025-05-23"]
["2025-05-24"]
["2025-05-25"]
["2025-05-26"]
["2025-05-27"]
["2025-05-28"]
["2025-05-29"]
["2025-05-30"]
["2025-05-31"]
["2025-06-01"]
["2025-06-02"]
["2025-06-03"]
["2025-06-04"]
["2025-06-05"]
["2025-06-06"]
["2025-06-07"]
["2025-06-08"]
["2025-06-09"]
["2025-06-10"]
["2025-06-11"]
["2025-06-12"]
["2025-06-13"]
["2025-06-14"]
["2025-06-15"]
["2025-06-16"]
["2025-06-17"]
["2025-06-18"]
["2025-06-19"]
["2025-06-20"]
["2025-06-21"]
["2025-06-22"]
["2025-06-23"]
["2025-06-24"]
["2025-06-25"]
["2025-06-26"]
["2025-06-27"]
["2025-06-28"]
["2025-06-29"]
["2025-06-30"]
["2025-07-01"]
["2025-07-02"]
["2025-07-03"]
["2025-07-04"]
["2025-07-05"]
["2025-07-06"]
["2025-07-07"]
["2025-07-08"]
["2025-07-09"]
["2025-07-10"]
["2025-07-11"]
["2025-07-12"]
["2025-07-13"]
["2025-07-14"]
["2025-07-15"]
["2025-07-16"]
["2025-07-17"]
["2025-07-18"]
["2025-07-19"]
["2025-07-20"]
["2025-07-21"]
["2025-07-22"]
["2025-07-23"]
["2025-07-24"]
["2025-07-25"]
["2025-07-26"]
["2025-07-27"]
["2025-07-28"]
["2025-07-29"]
["2025-07-30"]
["2025-07-31"]
["2025-08-01"]
["2025-08-02"]
["2025-08-03"]
["2025-08-04"]
["2025-08-05"]
["2025-08-06"]
["2025-08-07"]
["2025-08-08"]
["2025-08-09"]
["2025-08-10"]
["2025-08-11"]
["2025-08-12"]
["2025-08-13"]
["2025-08-14"]
["2025-08-15"]
["2025-08-16"]
["2025-08-17"]
["2025-08-18"]
["2025-08-19"]
["2025-08-20"]
["2025-08-21"]
["2025-08-22"]
["2025-08-23"]
["2025-08-24"]
["2025-08-25"]
["2025-08-26"]
["2025-08-27"]
["2025-08-28"]
["2025-08-29"]
["2025-08-30"]
["2025-08-31"]
["2025-09-01"]
["2025-09-02"]
["2025-09-03"]
["2025-09-04"]
["2025-09-05"]
["2025-09-06"]
["2025-09-07"]
["2025-09-08"]
["2025-09-09"]
["2025-09-10"]
["2025-09-11"]
["2025-09-12"]
["2025-09-13"]
["2025-09-14"]
["2025-09-15"]
["2025-09-16"]
["2025-09-17"]
["2025-09-18"]
["2025-09-19"]
["2025-09-20"]
["2025-09-21"]
["2025-09-22"]
["2025-09-23"]
["2025-09-24"]
["2025-09-25"]
["2025-09-26"]
["2025-09-27"]
["2025-09-28"]
["2025-09-29"]
["2025-09-30"]
["2025-10-01"]
["2025-10-02"]
["2025-10-03"]
["2025-10-04"]
["2025-10-05"]
["2025-10-06"]
["2025-10-07"]
["2025-10-08"]
["2025-10-09"]
["2025-10-10"]
["2025-10-11"]
["2025-10-12"]
["2025-10-13"]
["2025-10-14"]
["2025-10-15"]
["2025-10-16"]
["2025-10-17"]
["2025-10-18"]
["2025-10-19"]
["2025-10-20"]
["2025-10-21"]
["2025-10-22"]
["2025-10-23"]
["2025-10-24"]
["2025-10-25"]
["2025-10-26"]
["2025-10-27"]
["2025-10-28"]
["2025-10-29"]
["2025-10-30"]
["2025-10-31"]
["2025-11-01"]
["2025-11-02"]
["2025-11-03"]
["2025-11-04"]
["2025-11-05"]
["2025-11-06"]
["2025-11-07"]
["2025-11-08"]
["2025-11-09"]
["2025-11-10"]
["2025-11-11"]
["2025-11-12"]
["2025-11-13"]
["2025-11-14"]
["2025-11-15"]
["2025-11-16"]
["2025-11-17"]
["2025-11-18"]
["2025-11-19"]
["2025-11-20"]
["2025-11-21"]
["2025-11-22"]
["2025-11-23"]
["2025-11-24"]
["2025-11-25"]
["2025-11-26"]
["2025-11-27"]
["2025-11-28"]
["2025-11-29"]
["2025-11-30"]
["2025-12-01"]
["2025-12-02"]
["2025-12-03"]
["2025-12-04"]
["2025-12-05"]
["2025-12-06"]
["2025-12-07"]
["2025-12-08"]
["2025-12-09"]
["2025-12-10"]
["2025-12-11"]
["2025-12-12"]
["2025-12-13"]
["2025-12-14"]
["2025-12-15"]
["2025-12-16"]
["2025-12-17"]
["2025-12-18"]
["2025-12-19"]
["2025-12-20"]
["2025-12-21"]
["2025-12-22"]
["2025-12-23"]
["2025-12-24"]
["2025-12-25"]
["2025-12-26"]
["2025-12-27"]
["2025-12-28"]
["2025-12-29"]
["2025-12-30"]
["2025-12-31"]

{"sheet":"Time Zones","index":1,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Trip\nStart\nCity","Standard\nUTC\nOffset","Uses\nDST",null,null,"DST Start","DST END"]
["ATL",-5,true,null,null,"2014-03-09T02:00:00","2014-11-02T02:00:00"]
["NYC",-5,true,null,null,"2015-03-08T02:00:00","2015-11-01T02:00:00"]
["LGA",-5,true,null,null,"2016-03-13T02:00:00","2016-11-06T02:00:00"]
["EWR",-5,true,null,null,"2017-03-12T02:00:00","2017-11-05T02:00:00"]
["JFK",-5,true,null,null,"2018-03-11T02:00:00","2018-11-04T02:00:00"]
["DTW",-5,true,null,null,"2019-03-10T02:00:00","2019-11-03T02:00:00"]
["CVG",-5,true,null,null,"2020-03-08T02:00:00","2020-11-01T02:00:00"]
["MSP",-6,true,null,null,"2021-03-14T02:00:00","2021-11-07T02:00:00"]
["SLC",-7,true,null,null,"2022-03-13T02:00:00","2022-11-06T02:00:00"]
["SEA",-8,true,null,null,"2023-03-12T02:00:00","2023-11-05T02:00:00"]
["LAX",-8,true,null,null,"2024-03-10T02:00:00","2024-11-03T02:00:00"]
["BUR",-8,true,null,null,"2025-03-09","2025-11-02T02:00:00"]
["LGB",-8,true]
["ONT",-8,true]
["SNA",-8,true]

{"sheet":"Info and Settings","index":2,"n_rows":69,"n_cols":14,"rows_kept":69,"cut":false,"hidden":false,"merged":[[66,3,66,12],[30,3,30,14],[29,3,29,14],[2,2,2,3],[26,3,26,14],[28,3,28,14],[3,2,3,4],[3,7,3,8],[24,3,24,14],[27,3,27,14],[25,3,25,14],[39,2,39,14],[42,2,42,14],[36,3,36,14]]}
[]
[null,"Version:","2.2b"]
[null,"Update:","2022-04-07"]
[null,"Contact:","thejohnbell@gmail.com",null,null,"Latest Version:",null,"www.johnfbell.com"]
[null,"Settings:"]
[null,null,"Count 30 minute debrief as",null,null,null,null,null,null,"rest"]
[null,null,"Margin before highlighting cumulative limits in yellow.",null,null,null,null,null,null,"01:00:00"]
[null,null,"Assume new theater if duty starts with offset greater than",null,null,null,null,null,null,"04:00:00"]
[null,null,"Paste stats",null,null,null,null,null,null,5519,5527,1.9631944444444445,0.91319444444444453,"18:08:00"]
[null,"Controls:"]
[]
[]
[]
[null,"Instructions:"]
[null,null,"To paste a pairing"]
[null,null,"-","Copy the pairing from iCrew. Use Select All -> Copy (keyboard shortcut: Ctrl-A Ctrl-C) to select the entire page."]
[null,null,"-","Click on the \"Paste Pairing\" button on the Calendar tab."]
[null,null,"To delete a pairing"]
[null,null,"-","Select a cell within the pairing."]
[null,null,"-","Click on the \"Delete\" button."]
[]
[null,"Operational Notes:"]
[null,null,"-","When copying old data to a new version of this, copy the whole row starting at row 4 to the end and paste to the new version."]
[null,null,"-","This only works with pairings from iCrew -> Preflight -> Rotation or the icon at the bottom of your schedule."]
[null,null,"-","This does not work from the open time display in iCrew yet. You will have to look up the pairing under Preflight -> Rotation. This is a bit of a pain in the neck. However, open time display is just a couple of characters off here and there. I hope to eventually get it to work with open time and the bid package."]
[null,null,"-","This may not work in all browsers. It will probably not work in Firefox running iCrew Max."]
[null,null,"-","I do not count the block for deadheads, but I do count the duty."]
[null,null,"-","The Add Work button allows you to add a period of work such as CQ. The point is that this is non-rest."]
[null,null,"-","Duty ends at block in and does not currently include a debrief time, although I could add it. "]
[null,null,"-","UTC offset is based on check in station. It is not yet corrected for DST changes, but this is an upcoming feature."]
[null,null,"-","Time zone offset is the offset calculated at the arrival station and is relative to the check in station."]
[null,null,"-","A time such as \"04:55 20\" is a time and date combined. This would be 04:55 on the 20th of the month."]
[null,null,"-","If the delete does not work correctly. You can:"]
[null,null,null,"-Manually delete the rows with the pairing that you want to delete."]
[null,null,null,"-Manually insert rows"]
[null,null,null,"-Use fill down series to fix the dates in column A for where you deleted the trip."]
[null,null,"-","Feel free to share this. However, please make sure that you get the latest version from the link at the top of this page or simply pass along the link."]
[]
[null,"Discussion"]
[null,null,"This tool is somewhat fragile in that it will only accept one format of pairing from iCrew. It is cumbersome to have to pull up each pairing to copy and paste it into this sheet. I can imagine a much better tool than I have the time and skill to execute. If someone takes some of the concepts in this and improves upon them, then I will consider this a success."]
[]
[null,"Disclaimer"]
[null,null,"This tool is offered on a use at your own risk, non-warranty basis. "]
[]
[null,"Updates:"]
[null,null,"2.2b ","Added ability to read open time and archived iCrew pairings as well as fixed several problems."]
[null,null,"2.2a","Added translation from bid pack pairings."]
[null,null,"2.2a","Cleaned up Delta text translation and added back fill from daily block to 0.00 legs."]
[null,null,"2.1j","Added logic to translate the pairing from non-iCrew pairings. So far only Delta Archive is the only option."]
[null,null,"2.1i","Fixed bug in rest between on latest version of Excel."]
[null,null,"2.1h","Fixed problem where the added line of having an Airport Report caused Actual report to be incorrectly read."]
[null,null,"2.1g","Fixed parsing of pairings to allow layovers greater than 99:59."]
[null,null,"2.1f","Fixed issue with pasting pairings with a 2/29 effective date."]
[null,null,"2.1e","Fixed an issue where PVG trips were showing a time zone shift of -24 instead of going back to 0."]
[null,null,"2.1d","Fixed an issue where the shift to DST was not being calculated."]
[null,null,"2.1c","Fixed the number of rows included in an internal loop."]
[null,null,"2.1b","Conditional formatting so that red or yellow in a column fills the column header with the same color."]
[null,null,"2.1a","Added TimeZones and DST change tab."]
[null,null,"2.1a","Hopefully fixed the add work feature."]
[null,null,"2.0h","I edited some of the notes and added instructions on this tab. There is no functional change from 2.0g."]
[null,null,"2.0g","Fixed a problem with flights where the first leg is delayed paste midnight. "]
[null,null,"2.0f","Found a problem where some UTC departure dates were using the wrong date and making legs that were 24 hours longer than actual."]
[null,null,"2.0e","Fixed issue with ground deadhead and 0:00 rest on deadhead only days."]
[null,null,"2.0d","Fixed issue with deleting 1 day trips."]
[null,null,"2.0c","Fixed \"L\" and \"X\" legs so that they count as block."]
[null,"Copyright:","2.0b","Added ability to add non-pairing work. "]
[null,null,"2.0a","This is a significant code cleanup. I deleted much of the information that is internal to the trip such as acclimation. This version concentrates on cumulative values."]
[]
[null,null,"I reserve all rights to this spreadsheet and the associated code within it."]