{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Macro","2003 Data","2001 Cost","Sheet19","Sheet20","Sheet21","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,"To Fix:"]
[]
["Run the macro and then press SHIFT, CNTL, I to re-do different pages",null,null,null,null,null,"When remove dollar sign, remember the row number and move one to left"]
[]
[null,null,null,null,null,null,"Trim cells with blank spaces"]
[null,null,"Move the Years around in the first colum"]
[null,null,"Delete the blank spaces before first character",null,null,null,"Find why sometimes first column is replaced"]
[null,null,"Delete columns"]
[null,null,"Delete Rows",null,null,null,"Don’t Replace - with 0 in first column"]
[null,null,"Delete Dollar and % signs"]
[null,null,null,null,null,null,"Work on Underlines"]
[]
[null,null,null,null,null,null,"Two different formats not working well"]

{"sheet":"Macro","index":1,"n_rows":346,"n_cols":2,"rows_kept":346,"cut":false,"hidden":false,"merged":[]}
[null,"Public run_number"]
[]
[null,"Sub SEC_Download()"]
[null,"'"]
[null,"Application.OnKey \"^I\", \"SEC_Download\""]
[null,"Application.ScreenUpdating = False"]
[]
[null,"Dim test1 As String"]
[null,"Dim left_char As String"]
[null,"Dim cell_string As String"]
[null,"Dim cell_value As Single"]
[null,"Dim num_switch As Boolean"]
[null,"Dim num_col, num_row As Single"]
[null,"Dim sheet_color(1000) As Variant"]
[null,"Dim sheets_name(1000) As Variant"]
[null,"Dim test As Single"]
[null,"Dim new_number As Single"]
[null,"Dim first_quote, col_test As Single"]
[]
[null,"num_col = InputBox(\" Number of Columns \", , 50)"]
[null,"If num_col = 0 Then Exit Sub"]
[null,"num_row = InputBox(\" Number of Rows\", , 100)"]
[]
[null,"If run_number = 0 Then   ' only show cntl option when run number > 0"]
[null,"    Application.StatusBar = \" Press CNTL i to re-run program \""]
[null,"Else"]
[null,"    Application.StatusBar = False"]
[null,"End If"]
[]
[null,"run_number = run_number + 1"]
[]
[null,"Columns(\"B:B\").Select"]
[null,"Range(Selection, Selection.End(xlToRight)).Select    ' go to right starting with column B"]
[null,"            "]
[null,"    Selection.Replace What:=\"—\", Replacement:=0#, LookAt:=xlPart, SearchOrder _"]
[null,"        :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False"]
[null,"        "]
[null,"   Cells.Replace What:=\"—\", Replacement:=0#, LookAt:=xlPart, SearchOrder _"]
[null,"        :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False"]
[]
[null,"Cells.Select                    ' Take away merge"]
[null,"With Selection"]
[null,"        .HorizontalAlignment = xlLeft"]
[null,"        .VerticalAlignment = xlCenter"]
[null,"        .WrapText = False"]
[null,"        .Orientation = 0"]
[null,"        .AddIndent = False"]
[null,"        .ShrinkToFit = False"]
[null,"        .ReadingOrder = xlContext"]
[null,"        .MergeCells = False"]
[null,"        .Interior.ColorIndex = xlNone"]
[null,"    End With"]
[]
[null,"    Selection.Borders(xlDiagonalDown).LineStyle = xlNone      ' take away underlines"]
[null,"    Selection.Borders(xlDiagonalUp).LineStyle = xlNone"]
[null,"    Selection.Borders(xlEdgeLeft).LineStyle = xlNone"]
[null,"    Selection.Borders(xlEdgeTop).LineStyle = xlNone"]
[null,"    Selection.Borders(xlEdgeBottom).LineStyle = xlNone"]
[null,"    Selection.Borders(xlEdgeRight).LineStyle = xlNone"]
[null,"    Selection.Borders(xlInsideVertical).LineStyle = xlNone"]
[null,"    Selection.Borders(xlInsideHorizontal).LineStyle = xlNone"]
[null," "]
[null,"   On Error Resume Next"]
[null,"    ActiveWorkbook.Styles.Add Name:=\"SEC\"             '  Establish the style for numbers"]
[null,"    With ActiveWorkbook.Styles(\"SEC\")"]
[null,"    End With"]
[null,"    ActiveWorkbook.Styles(\"SEC\").NumberFormat = _"]
[null,"           \"_(* #,##0_);_(* (#,##0);_(* \"\"-\"\"_);_(@_)\""]
[null," "]
[null,"   On Error Resume Next"]
[null,"    ActiveWorkbook.Styles.Add Name:=\"SEC1\"    ' style for small numbers with decimals"]
[null,"    With ActiveWorkbook.Styles(\"SEC1\")"]
[null,"    End With"]
[null,"    ActiveWorkbook.Styles(\"SEC1\").NumberFormat = _"]
[null,"           \"_(* #,##0.00_);_(* (#,##0.00);_(* \"\"-\"\"_);_(@_)\""]
[]
[null,"col_test = 0"]
[]
[null,"For Row = 1 To num_row                      ' loop around each cell in the sheet"]
[null,"     For cols = 1 To num_col"]
[null,"  "]
[null,"        Cells(Row, cols).Activate"]
[null,"        test = Cells(Row, cols).Formula"]
[null,"        test1 = Cells(Row, cols).Value"]
[null,"        cell_string = Cells(Row, cols)"]
[null,"    "]
[null,"        cell_value = 0                                    '  find the formula in each cell"]
[null,"        left_char = Left(cell_string, 1)"]
[null,"        second_char = Mid(cell_string, 2, 1)"]
[null,"        "]
[null,"        If left_char = \"0\" And second_char <> \".\" Then Cells(Row, cols) = 0"]
[null,"        "]
[null,"        On Error Resume Next"]
[null,"        test1 = Mid(test1, 2, 1)"]
[null,"        third_value = Mid(cell_string, 3, 1)"]
[null,"        "]
[null,"        cell_value = CSng(cell_string)"]
[null,"                    "]
[null,"        On Error GoTo 0"]
[null,"                    "]
[null,"        test_blank = False"]
[null,"        If cell_value = 0 Then test_blank = True"]
[null,"                              "]
[null,"        If StrComp(left_char, \"-\", vbTextCompare) = 0 Then"]
[null,"            If test_blank = True Then"]
[null,"        "]
[null,"               test = WorksheetFunction.Substitute(test, \"-\", \"\")"]
[null,"               Cells(Row, cols) = 0"]
[null,"               Cells(Row, cols).Select"]
[null,"               Selection.Style = \"SEC\""]
[null,"            End If"]
[null,"        End If"]
[null,"        "]
[null,"        left_char = Left(test1, 1)                ' redefine the left char"]
[null,"                "]
[null,"        num_switch = False"]
[null,"        cell_value = 0"]
[null,"        "]
[null,"        On Error Resume Next"]
[null,"        cell_value = CSng(left_char)"]
[null,"            "]
[null,"        right_cell = Right(test1, 1)"]
[null,"                   "]
[null,"        If (cell_value <> 0) = True Then num_switch = True"]
[null,"        If (left_char = \"$\") = True Then num_switch = True"]
[null,"        If (third_value = \".\") = True Then num_switch = True"]
[null,"                                "]
[null,"        If cell_string <> \"\" Then"]
[null,"            cell_length = 0"]
[null,"        "]
[null,"            On Error Resume Next"]
[null,"             cell_length = WorksheetFunction.Find(\"(\", cell_string)"]
[null,"      "]
[null,"'            If cell_length > 0 And cols > 5 Then MsgBox cell_string & \" Row \" & Row & \" Col \" & cols & \" Cell len \" & cell_length & \" third value \" & third_value"]
[null,"      "]
[null,"            If (cell_length <> 0) Then"]
[null,"                test = WorksheetFunction.Substitute(cell_string, \"(\", \"-\")"]
[null,"                Cells(Row, cols) = cell_string"]
[null,"            End If"]
[null,"     "]
[null,"'           If cell_length > 0 And cols > 5 Then MsgBox cell_string & \" Row \" & Row & \" Col \" & cols & \" Cell len \" & cell_length"]
[null,"  "]
[null,"            If (cell_length <> 0) Then"]
[null,"                test = WorksheetFunction.Substitute(cell_string, \")\", \"\")"]
[null,"                Cells(Row, cols) = cell_string"]
[null,"            End If"]
[null,"     "]
[null,"        End If ' Test on whether the cell is blank"]
[null,"                            "]
[null,"'        On Error Resume Next"]
[null,"                  "]
[null,"         cell_value = Cells(Row, cols).Value"]
[null,"         "]
[null,"         If (WorksheetFunction.IsNumber(cell_value) = True) Then     ' test for number after removing the parns"]
[null,"            If cell_value <> 0 Then num_switch = True"]
[null,"         End If"]
[null,"              "]
[null,"         If (num_switch = True) Then"]
[null,"            Cells(Row, cols).Select"]
[null,"            test = WorksheetFunction.Substitute(cell_string, \" \", \"\")   ' if there is a space in the number remove (does not happen)"]
[null,"            "]
[null,"            cell_value = CSng(test)                   ' this is where define the new number"]
[null,"            Cells(Row, cols) = cell_value"]
[null,"            Selection.Style = \"SEC\""]
[]
[null,"            With Selection"]
[null,"                .HorizontalAlignment = xlRight"]
[null,"            End With"]
[null,"     "]
[null,"            If (Cells(Row, cols) < 10 And Cells(Row, cols) > -10) Then Selection.Style = \"SEC1\""]
[null,"          "]
[null,"            row_test = 0"]
[null,"     "]
[null,"            If cell_value > 1980 And cell_value < 2050 Then"]
[null,"                     Selection.Style = \"Normal\""]
[null,"               row_test = 1"]
[null,"            End If"]
[null,"                "]
[null,"        Else"]
[null,"               If Cells(Row, cols) = 0 Then"]
[null,"                  Cells(Row, cols).Select"]
[null,"                  Selection.Style = \"SEC\""]
[null,"               End If"]
[null,"     "]
[null,"        End If"]
[null,"                        "]
[null,"        If col_test = 0 Then"]
[null,"                If cell_value > 1980 And cell_value < 2050 Then"]
[null,"                   col_test = cols"]
[null,"                End If"]
[null,"        End If"]
[null,"                      "]
[null,"     Next cols"]
[null," "]
[null," ' Move the years in the title because they are one off"]
[null," "]
[null," GoTo skip1:"]
[null,"     If row_test = 1 Then"]
[null,"         Range(\"A\" & Row & \":BU\" & Row).Select"]
[null,"         Selection.Cut"]
[null,"         Range(\"B\" & Row).Select"]
[null,"         ActiveSheet.Paste"]
[]
[null,"     End If"]
[null,"skip1:"]
[null,"     "]
[null,"     row_test = 0"]
[null," "]
[null," Next Row"]
[null,"            "]
[null,"Cells.Select"]
[null,"With Selection"]
[null,"        .HorizontalAlignment = xlLeft"]
[null,"        .VerticalAlignment = xlCenter"]
[null,"End With"]
[null,"    "]
[null,"Selection.Interior.ColorIndex = xlNone"]
[null,"Selection.Rows.AutoFit"]
[null,"Selection.Columns.AutoFit"]
[null,"   "]
[null,"With Selection.Font"]
[null,"        .Name = \"Arial\""]
[null,"        .Size = 10"]
[null,"        .ColorIndex = xlAutomatic"]
[null,"End With"]
[null,"    "]
[null,"col_test = 4"]
[null,"     "]
[null,"    If col_test = 1 Then"]
[null,"       Range(\"A:A\").Select"]
[null,"    End If"]
[null,"    If col_test = 2 Then"]
[null,"       Range(\"A:B\").Select"]
[null,"    End If"]
[null,"    If col_test = 3 Then"]
[null,"        Range(\"A:C\").Select"]
[null,"    End If"]
[null,"    If col_test = 4 Then"]
[null,"        Range(\"A4:D6000\").Select"]
[null,"    End If"]
[null,"           "]
[null,"    With Selection"]
[null,"        .HorizontalAlignment = xlRight"]
[null,"        .VerticalAlignment = xlCenter"]
[null,"    End With"]
[null,"    "]
[null,"    Selection.Interior.ColorIndex = xlNone"]
[null,"    Selection.Rows.AutoFit"]
[null,"    Selection.Columns.AutoFit"]
[null,"    "]
[null,"    With Selection.Font"]
[null,"        .Name = \"Arial\""]
[null,"        .Strikethrough = False"]
[null,"        .Superscript = False"]
[null,"        .Subscript = False"]
[null,"        .OutlineFont = False"]
[null,"        .Shadow = False"]
[null,"        .ColorIndex = xlAutomatic"]
[null,"    End With"]
[null,"        '"]
[null,"    For col = 1 To num_col                           ' Format first columns to left differently"]
[null,"        Cells(1, col).Select"]
[null,"    "]
[null,"        test_width = Selection.ColumnWidth"]
[null,"    "]
[null,"        If test_width < 3 Then"]
[null,"           Selection.EntireColumn.Delete             ' Delete small columns with only $ signs and make very large columns smaller"]
[null,"        End If"]
[]
[null,"        If test_width > 30 Then"]
[null,"            Selection.ColumnWidth = 10"]
[null,"        End If"]
[]
[null,"        If col <= 3 Then"]
[null,"            Selection.ColumnWidth = 1"]
[null,"            Range(\"A:C\").Select"]
[null,"            With Selection"]
[null,"                .HorizontalAlignment = xlLeft"]
[null,"                .VerticalAlignment = xlCenter"]
[null,"            End With"]
[null,"        End If"]
[null,"            "]
[null,"        If col = 4 Then"]
[null,"            Selection.ColumnWidth = 40"]
[null,"            Range(\"D:D\").Select"]
[null,"            With Selection"]
[null,"                .HorizontalAlignment = xlLeft"]
[null,"                .VerticalAlignment = xlCenter"]
[null,"            End With"]
[null,"        End If"]
[]
[null,"    Next col"]
[null,"    "]
[null,"Range(\"A1\").Select"]
[]
[null,"End Sub"]
[]
[]
[]
[null,"Sub delete_blank_col()"]
[null,"'"]
[]
[null,"    Application.ScreenUpdating = False"]
[null,"    "]
[null,"    Selection.End(xlUp).Select"]
[null,"    Selection.End(xlDown).Select"]
[null,"    row_num = Selection.Row"]
[null,"    col_num = Selection.Column"]
[null,"    end_address = Selection.Address"]
[null,"    first_dollar = WorksheetFunction.Find(\"$\", end_address, 1)"]
[null,"    second_dollar = WorksheetFunction.Find(\"$\", end_address, 2)"]
[null,"    dollar_dif = second_dollar - first_dollar - 1"]
[null,"    "]
[null,"    col_name = Mid(end_address, first_dollar + 1, dollar_dif)"]
[null,"    "]
[null,"    "]
[null,"    If row_num > 65000 Then"]
[null,"        range_name = col_name & \":\" & col_name"]
[null,"        Range(range_name).Select"]
[null,"        Selection.Delete Shift:=xlToLeft"]
[null,"    End If"]
[null,"    "]
[null,"End Sub"]
[null,"Sub remove_dollar()"]
[null,"'"]
[null,"    Cells.Select"]
[null,"    Selection.Replace What:=\"$\", Replacement:=\"\", LookAt:=xlPart, _"]
[null,"        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _"]
[null,"        ReplaceFormat:=False"]
[null,"    "]
[null,"    Range(\"e:zz\").Select"]
[null,"    Selection.Replace What:=\")\", Replacement:=\"\", LookAt:=xlPart, _"]
[null,"        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _"]
[null,"        ReplaceFormat:=False"]
[]
[null,"End Sub"]
[]
[null,"Sub clean_up()"]
[]
[null,"    remove_dollar"]
[null,"    For col = 20 To 1 Step -1"]
[null,"        Cells(1, col).Select"]
[null,"        delete_blank_col"]
[null,"    Next col"]
[]
[null,"End Sub"]

{"sheet":"2003 Data","index":2,"n_rows":66,"n_cols":31,"rows_kept":66,"cut":false,"hidden":false,"merged":[[1,24,2,26],[1,27,2,27],[1,28,2,30],[0,24,0,26],[1,0,2,2],[1,3,2,3],[1,4,2,6],[1,7,2,7],[1,8,2,10],[1,11,2,11],[1,12,2,14],[1,15,2,15],[1,16,2,18],[0,0,0,2],[0,4,0,6],[0,8,0,10],[0,12,0,14],[0,16,0,18],[0,20,0,22],[3,0,3,2],[4,1,4,2],[8,0,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[1,19,2,19],[1,20,2,22],[1,23,2,23],[8,22,9,22],[8,23,9,23],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[15,15,16,15],[8,30,9,30],[11,1,11,2],[15,0,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,7,16,7],[15,8,16,8],[15,9,16,9],[8,24,9,24],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,18,9,18],[8,19,9,19],[8,20,9,20],[8,21,9,21],[15,28,16,28],[15,29,16,29],[15,30,16,30],[18,0,19,2],[18,3,19,3],[18,4,19,4],[18,5,19,5],[18,6,19,6],[18,7,19,7],[18,8,19,8],[15,22,16,22],[15,23,16,23],[15,24,16,24],[15,25,16,25],[15,26,16,26],[15,27,16,27],[15,16,16,16],[15,17,16,17],[15,18,16,18],[15,19,16,19],[15,20,16,20],[15,21,16,21],[15,10,16,10],[15,11,16,11],[18,27,19,27],[18,28,19,28],[18,29,19,29],[18,30,19,30],[20,1,20,2],[21,1,21,2],[18,21,19,21],[18,22,19,22],[18,23,19,23],[18,24,19,24],[18,25,19,25],[18,26,19,26],[18,15,19,15],[18,16,19,16],[18,17,19,17],[18,18,19,18],[18,19,19,19],[18,20,19,20],[18,9,19,9],[18,10,19,10],[18,11,19,11],[18,12,19,12],[18,13,19,13],[18,14,19,14],[22,29,23,29],[22,30,23,30],[24,1,24,2],[22,20,23,20],[22,21,23,21],[22,22,23,22],[22,23,23,23],[22,24,23,24],[22,25,23,25],[22,14,23,14],[22,15,23,15],[22,16,23,16],[22,17,23,17],[22,18,23,18],[22,19,23,19],[22,8,23,8],[22,9,23,9],[22,10,23,10],[22,11,23,11],[22,12,23,12],[22,13,23,13],[22,0,23,2],[22,3,23,3],[22,4,23,4],[25,1,25,2],[29,0,30,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[29,6,30,6],[22,26,23,26],[22,27,23,27],[22,28,23,28],[22,5,23,5],[22,6,23,6],[22,7,23,7],[29,13,30,13],[29,14,30,14],[29,15,30,15],[29,16,30,16],[29,17,30,17],[29,18,30,18],[29,7,30,7],[29,8,30,8],[29,9,30,9],[29,10,30,10],[29,11,30,11],[29,12,30,12],[29,25,30,25],[29,26,30,26],[29,27,30,27],[29,28,30,28],[29,29,30,29],[29,30,30,30],[29,19,30,19],[29,20,30,20],[29,21,30,21],[29,22,30,22],[29,23,30,23],[29,24,30,24],[32,29,33,29],[32,30,33,30],[34,1,34,2],[32,20,33,20],[32,21,33,21],[32,22,33,22],[32,23,33,23],[32,24,33,24],[32,25,33,25],[32,14,33,14],[32,15,33,15],[32,16,33,16],[32,17,33,17],[32,18,33,18],[32,19,33,19],[32,8,33,8],[32,9,33,9],[32,10,33,10],[32,11,33,11],[32,12,33,12],[32,13,33,13],[32,0,33,2],[32,3,33,3],[32,4,33,4],[35,1,35,2],[36,0,37,2],[36,3,37,3],[36,4,37,4],[36,5,37,5],[36,6,37,6],[32,26,33,26],[32,27,33,27],[32,28,33,28],[32,5,33,5],[32,6,33,6],[32,7,33,7],[36,28,37,28],[36,29,37,29],[36,30,37,30],[36,19,37,19],[36,20,37,20],[36,21,37,21],[36,22,37,22],[36,23,37,23],[36,24,37,24],[38,1,38,2],[39,1,39,2],[40,0,41,2],[40,3,41,3],[40,4,41,4],[40,5,41,5],[36,25,37,25],[36,26,37,26],[36,27,37,27],[36,13,37,13],[36,14,37,14],[36,15,37,15],[36,16,37,16],[36,17,37,17],[36,18,37,18],[36,7,37,7],[36,8,37,8],[36,9,37,9],[36,10,37,10],[36,11,37,11],[36,12,37,12],[40,22,41,22],[40,23,41,23],[40,12,41,12],[40,13,41,13],[40,14,41,14],[40,15,41,15],[40,16,41,16],[40,17,41,17],[40,6,41,6],[40,7,41,7],[40,8,41,8],[40,9,41,9],[40,10,41,10],[40,11,41,11],[44,11,45,11],[44,12,45,12],[44,13,45,13],[44,14,45,14],[40,30,41,30],[42,1,42,2],[43,1,43,2],[44,0,45,2],[44,3,45,3],[44,4,45,4],[44,5,45,5],[44,6,45,6],[44,7,45,7],[44,8,45,8],[40,24,41,24],[40,25,41,25],[40,26,41,26],[40,27,41,27],[40,28,41,28],[40,29,41,29],[40,18,41,18],[40,19,41,19],[40,20,41,20],[40,21,41,21],[44,27,45,27],[44,28,45,28],[44,29,45,29],[44,30,45,30],[46,1,46,2],[47,0,48,2],[47,3,48,3],[47,4,48,4],[47,5,48,5],[47,6,48,6],[44,21,45,21],[44,22,45,22],[44,23,45,23],[44,24,45,24],[44,25,45,25],[44,26,45,26],[44,15,45,15],[44,16,45,16],[44,17,45,17],[44,18,45,18],[44,19,45,19],[44,20,45,20],[44,9,45,9],[44,10,45,10],[47,28,48,28],[47,29,48,29],[47,30,48,30],[47,19,48,19],[47,20,48,20],[47,21,48,21],[47,22,48,22],[47,23,48,23],[47,24,48,24],[49,0,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[47,25,48,25],[47,26,48,26],[47,27,48,27],[47,13,48,13],[47,14,48,14],[47,15,48,15],[47,16,48,16],[47,17,48,17],[47,18,48,18],[47,7,48,7],[47,8,48,8],[47,9,48,9],[47,10,48,10],[47,11,48,11],[47,12,48,12],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[55,0,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[60,0,60,2]]}
[2003,null,null,null,2002,null,null,null,2002,null,null,null,2002,null,null,null,2001,null,null,null,2000,null,null,null,1999]
[]
[]
["Results of Operations"]
[null,"Revenue: "]
[null,null,"Scheduled freight ",null,"$",127412,null,null,"$",116279,null,null,"$",31482,null,null,"$",84797,null,null,"$",135052,null,null,"$",170255,null,null,"$",127868]
[null,null,"Other(1) ",null,null,4992,null,null,null,5524,null,null,null,2994,null,null,null,2530,null,null,null,112437,null,null,null,196578,null,null,null,240149]
[null,null,"Services provided to discontinued operations(2) ",null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,23007]
[]
[]
[null,null,"Total revenue ",null,null,132404,null,null,null,121803,null,null,null,34476,null,null,null,87327,null,null,null,247489,null,null,null,366833,null,null,null,391024]
[null,"Cost of revenue: "]
[null,null,"Operating expenses ",null,null,122209,null,null,null,117401,null,null,null,29658,null,null,null,87743,null,null,null,247390,null,null,null,331518,null,null,null,233399]
[null,null,"Asset impairment(3) ",null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,86316,null,null,null,14812,null,null,null,"—"]
[null,null,"Services provided from discontinued operations(4) ",null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,112744]
[]
[]
[null,null,"Total cost of revenue ",null,null,122209,null,null,null,117401,null,null,null,29658,null,null,null,87743,null,null,null,333706,null,null,null,346330,null,null,null,346143]
[]
[]
[null,"Gross profit (loss) ",null,null,null,10195,null,null,null,4402,null,null,null,4818,null,null,null,"(416",")",null,null,"(86,217",")",null,null,20503,null,null,null,44881]
[null,"General and administrative expenses ",null,null,null,9377,null,null,null,8064,null,null,null,2140,null,null,null,5924,null,null,null,11819,null,null,null,23181,null,null,null,19518]
[]
[]
[null,"Operating profit (loss) from continuing operations ",null,null,null,818,null,null,null,"(3,662",")",null,null,2678,null,null,null,"(6,340",")",null,null,"(98,036",")",null,null,"(2,678",")",null,null,25363]
[null,"Other (income) expense: "]
[null,null,"Interest expense(5) ",null,null,423,null,null,null,2287,null,null,null,154,null,null,null,2133,null,null,null,7051,null,null,null,12751,null,null,null,9754]
[null,null,"Reorganization expenses ",null,null,"—",null,null,null,39629,null,null,null,"—",null,null,null,39629,null,null,null,42676,null,null,null,17111,null,null,null,"—"]
[null,null,"Other (income) expense(6) ",null,null,"(3,746",")",null,null,"(30,701",")",null,null,"(139",")",null,null,"(30,562",")",null,null,"(14",")",null,null,2310,null,null,null,"(11,706",")"]
[]
[]
[null,null,"Total interest and other (income) expense ",null,null,"(3,323",")",null,null,11215,null,null,null,15,null,null,null,11200,null,null,null,49713,null,null,null,32172,null,null,null,"(1,952",")"]
[]
[]
[null,"Income (loss) from continuing operations before income taxes ",null,null,null,4141,null,null,null,"(14,877",")",null,null,2663,null,null,null,"(17,540",")",null,null,"(147,749",")",null,null,"(34,850",")",null,null,27315]
[null,"Income tax expense (benefit) ",null,null,null,1511,null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"(11,661",")",null,null,2403]
[]
[]
[null,"Income (loss) from continuing operations ",null,null,null,2630,null,null,null,"(14,877",")",null,null,2663,null,null,null,"(17,540",")",null,null,"(147,749",")",null,null,"(23,189",")",null,null,24912]
[null,"Loss from discontinued operations(3)(7) ",null,null,null,"—",null,null,null,"(40,831",")",null,null,"—",null,null,null,"(40,831",")",null,null,"(20,173",")",null,null,"(334,131",")",null,null,"(15,059",")"]
[]
[]
[null,"Net income (loss) before extraordinary item ",null,null,null,2630,null,null,null,"(55,708",")",null,null,2663,null,null,null,"(58,371",")",null,null,"(167,922",")",null,null,"(357,320",")",null,null,9853]
[null,"Extraordinary item(8) ",null,null,null,"—",null,null,null,378068,null,null,null,"—",null,null,null,378068,null,null,null,"—",null,null,null,"—",null,null,null,"—"]
[]
[]
[null,"Net income (loss) ",null,null,"$",2630,null,null,"$",322360,null,null,"$",2663,null,null,"$",319697,null,null,"$","(167,922",")",null,"$","(357,320",")",null,"$",9853]
[]
[]
["Earnings (Loss) Per Share Data"]
[null,"Continuing operations(9) ",null,null,"$",0.05,null,null,"$","—",null,null,"$",0.05,null,null,"$","(1.02",")",null,"$","(8.62",")",null,"$","(1.35",")",null,"$",1.46]
[null,"Discontinued operations(3)(7)(9) ",null,null,"$","—",null,null,"$","—",null,null,"$","—",null,null,"$","(2.39",")",null,"$","(1.18",")",null,"$","(19.51",")",null,"$","(0.88",")"]
[null,"Extraordinary item(8)(9) ",null,null,"$","—",null,null,"$","—",null,null,"$","—",null,null,"$",22.07,null,null,"$","—",null,null,"$","—",null,null,"$","—"]
[null,"Net earnings (loss) per share(9) ",null,null,"$",0.05,null,null,"$","—",null,null,"$",0.05,null,null,"$",18.66,null,null,"$","(9.80",")",null,"$","(20.86",")",null,"$",0.57999999999999996]
[null,"Weighted average common stock outstanding(9) ",null,null,null,50136,null,null,null,"—",null,null,null,50000,null,null,null,17133,null,null,null,17133,null,null,null,17129,null,null,null,17021]
["Operating Data"]
[null,"Chargeable weight — pounds moved(10) ",null,null,null,152756,null,null,null,149588,null,null,null,38992,null,null,null,110596,null,null,null,175954,null,null,null,227176,null,null,null,191094]
[null,"Average yield per chargeable weight — pounds moved(11) ",null,null,"$",0.83409999999999995,null,null,"$",0.77729999999999999,null,null,"$",0.80740000000000001,null,null,"$",0.76670000000000005,null,null,"$",0.76749999999999996,null,null,"$",0.74939999999999996,null,null,"$",0.66910000000000003]
[null,"Fuel — average cost per gallon(12) ",null,null,"$",1.0325,null,null,"$",0.89770000000000005,null,null,"$",0.99460000000000004,null,null,"$",0.86529999999999996,null,null,"$",0.96060000000000001,null,null,"$",1.052,null,null,"$",0.67700000000000005]
[null,"Revenue block hours flown(13) ",null,null,null,20882,null,null,null,22674,null,null,null,6221,null,null,null,16453,null,null,null,39103,null,null,null,62430,null,null,null,58818]
["Financial Condition"]
[null,"Cash and cash equivalents ",null,null,"$",15729,null,null,"$",10353,null,null,"$",10353,null,null,"$",4610,null,null,"$",13472,null,null,"$",14117,null,null,"$",14964]
[null,"Total assets ",null,null,null,47110,null,null,null,47259,null,null,null,47259,null,null,null,47354,null,null,null,171606,null,null,null,442941,null,null,null,922016]
[null,"Notes payable and long-term obligations(14) ",null,null,null,3689,null,null,null,4978,null,null,null,4978,null,null,null,5819,null,null,null,6580,null,null,null,9226,null,null,null,459823]
[null,"Liabilities subject to compromise(14) ",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,465161,null,null,null,539448,null,null,null,"—"]
[null,"Stockholders’ equity (deficit)(14) ",null,null,"$",23604,null,null,"$",19263,null,null,"$",19263,null,null,"$",16600,null,null,"$","(319,697",")",null,"$","(151,775",")",null,"$",205117]

{"sheet":"2001 Cost","index":3,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[2001,null,null,null,null,null,2000]
[]
[]
[null,null,null,"Cost",null,null,"Percentage",null,"Cost",null,null,"Percentage",null,"Percentage Change"]
[null,null,null,"of",null,null,"of Total",null,"of",null,null,"of Total",null,"from"]
[null,null,null,"Revenue",null,null,"Revenue",null,"Revenue",null,null,"Revenue",null,"2000 to 2001"]
[]
[]
[null,null,null,"(dollars in thousands)"]
["Flight expense",null,null,"$",44915,null,null,18.100000381469727,"$",67025,null,null,18.299999237060547,null,-33]
["Transportation expense",null,null,null,44322,null,null,17.899999618530273,null,51982,null,null,14.199999809265137,null,-14.699999809265137]
["Fuel",null,null,null,35055,null,null,14.199999809265137,null,47209,null,null,12.899999618530273,null,-25.700000762939453]
["Maintenance expense",null,null,null,40451,null,null,16.299999237060547,null,53687,null,null,14.600000381469727,null,-24.700000762939453]
["Freight handling expense",null,null,null,40231,null,null,16.299999237060547,null,58417,null,null,15.899999618530273,null,-31.100000381469727]
["Depreciation and amortization",null,null,null,26026,null,null,10.5,null,36384,null,null,9.8999996185302734,null,-28.5]
["Asset impairment",null,null,null,86316,null,null,34.900001525878906,null,14812,null,null,4,null,482.70001220703125]
["Operating overhead",null,null,null,16390,null,null,6.5999999046325684,null,16814,null,null,4.5999999046325684,null,-2.5]
[]
[]
[null,"Total cost of revenue",null,"$",333706,null,null,134.80000305175781,"$",346330,null,null,94.400001525878906,null,-3.5999999046325684]

{"sheet":"Sheet19","index":4,"n_rows":77,"n_cols":31,"rows_kept":77,"cut":false,"hidden":false,"merged":[[2,0,2,2],[2,4,2,14],[2,16,2,18],[2,20,2,21],[2,24,2,25],[2,28,2,30],[0,0,0,9],[0,12,0,14],[0,16,0,17],[0,20,0,25],[1,0,1,2],[1,4,1,13],[1,16,1,18],[1,20,1,21],[1,24,1,29],[3,24,3,25],[3,28,3,29],[4,0,4,2],[4,4,4,5],[4,8,4,9],[4,12,4,13],[4,16,4,17],[4,20,4,21],[4,24,4,25],[4,28,4,29],[3,0,3,2],[3,4,3,5],[3,8,3,9],[3,12,3,13],[3,16,3,17],[3,20,3,21],[7,0,7,2],[8,1,8,2],[11,0,11,2],[11,4,11,5],[11,8,11,9],[11,12,11,13],[5,24,5,25],[5,28,5,29],[6,0,6,2],[6,4,6,5],[6,8,6,9],[6,12,6,13],[6,16,6,17],[6,20,6,21],[6,24,6,25],[6,28,6,29],[5,0,5,2],[5,4,5,5],[5,8,5,9],[5,12,5,13],[5,16,5,17],[5,20,5,21],[11,16,11,17],[11,20,11,21],[11,24,11,25],[11,28,11,29],[13,1,13,2],[16,0,16,2],[16,4,16,5],[16,8,16,9],[16,12,16,13],[16,16,16,17],[16,20,16,21],[16,24,16,25],[16,28,16,29],[18,0,18,2],[18,4,18,5],[18,8,18,9],[18,12,18,13],[18,16,18,17],[18,20,18,21],[18,24,18,25],[18,28,18,29],[19,1,19,2],[20,1,20,2],[21,0,21,2],[21,4,21,5],[21,8,21,9],[21,12,21,13],[21,16,21,17],[21,20,21,21],[21,24,21,25],[21,28,21,29],[22,1,22,2],[23,1,23,2],[27,0,27,2],[27,4,27,5],[27,8,27,9],[27,12,27,13],[27,16,27,17],[27,20,27,21],[27,24,27,25],[27,28,27,29],[29,0,29,2],[29,4,29,5],[29,8,29,9],[29,12,29,13],[29,16,29,17],[29,20,29,21],[29,24,29,25],[29,28,29,29],[32,16,32,17],[32,20,32,21],[32,24,32,25],[32,28,32,29],[33,1,33,2],[34,1,34,2],[30,1,30,2],[31,1,31,2],[32,0,32,2],[32,4,32,5],[32,8,32,9],[32,12,32,13],[35,24,35,25],[35,28,35,29],[36,1,36,2],[37,1,37,2],[38,0,38,2],[38,4,38,5],[38,8,38,9],[38,12,38,13],[38,16,38,17],[38,20,38,21],[35,0,35,2],[35,4,35,5],[35,8,35,9],[35,12,35,13],[35,16,35,17],[35,20,35,21],[38,24,38,25],[38,28,38,29],[39,1,39,2],[40,0,40,2],[40,4,40,5],[40,8,40,9],[40,12,40,13],[40,16,40,17],[40,20,40,21],[40,24,40,25],[40,28,40,29],[41,1,41,2],[42,0,42,2],[42,4,42,5],[42,8,42,9],[42,12,42,13],[42,16,42,17],[42,20,42,21],[42,24,42,25],[42,28,42,29],[44,20,44,21],[44,24,44,25],[44,28,44,29],[53,0,53,1],[53,3,53,12],[53,15,53,17],[53,19,53,20],[53,23,53,28],[43,1,43,2],[44,0,44,2],[44,4,44,5],[44,8,44,9],[44,12,44,13],[44,16,44,17],[54,0,54,1],[54,3,54,12],[54,15,54,17],[54,19,54,20],[54,23,54,28],[55,0,55,1],[55,3,55,13],[55,15,55,17],[55,19,55,20],[55,23,55,24],[55,27,55,29],[56,0,56,1],[56,3,56,4],[56,7,56,8],[56,11,56,12],[56,15,56,16],[56,19,56,20],[56,23,56,24],[56,27,56,28],[57,23,57,24],[57,27,57,28],[58,0,58,1],[58,3,58,4],[58,7,58,8],[58,11,58,12],[58,15,58,16],[58,19,58,20],[58,23,58,24],[58,27,58,28],[57,0,57,1],[57,3,57,4],[57,7,57,8],[57,11,57,12],[57,15,57,16],[57,19,57,20],[59,23,59,24],[59,27,59,28],[60,0,60,1],[66,0,66,1],[71,0,71,1],[59,0,59,1],[59,3,59,4],[59,7,59,8],[59,11,59,12],[59,15,59,16],[59,19,59,20]]}
["Successor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Successor",null,null,null,"Predecessor"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Three Months",null,null,null,"Nine Months"]
[null,null,null,null,"Year Ended",null,null,null,"Year Ended",null,null,null,"Year Ended",null,null,null,"Year Ended",null,null,null,"Ended",null,null,null,"Ended",null,null,null,"Year Ended"]
[null,null,null,null,"December 31,",null,null,null,"December 31,",null,null,null,"December 31,",null,null,null,"December 31,",null,null,null,"December 31,",null,null,null,"September 30,",null,null,null,"December 31,"]
[null,null,null,null,2005,null,null,null,2004,null,null,null,2003,null,null,null,2002,null,null,null,2002,null,null,null,2002,null,null,null,2001]
[]
["Results of Operations"]
[null,"Revenue:"]
[null,null,"Scheduled freight",null,"$",151910,null,null,"$",154016,null,null,"$",127412,null,null,"$",116279,null,null,"$",31482,null,null,"$",84797,null,null,"$",135052]
[null,null,"Other(1)",null,null,4727,null,null,null,4481,null,null,null,4992,null,null,null,5524,null,null,null,2994,null,null,null,2530,null,null,null,112437]
[]
[null,null,"Total revenue",null,null,156637,null,null,null,158497,null,null,null,132404,null,null,null,121803,null,null,null,34476,null,null,null,87327,null,null,null,247489]
[null,"Cost of revenue:"]
[null,null,"Operating expenses",null,null,157764,null,null,null,137017,null,null,null,122209,null,null,null,117401,null,null,null,29658,null,null,null,87743,null,null,null,247390]
[null,null,"Asset impairment(2)",null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,86316]
[]
[null,null,"Total cost of revenue",null,null,157764,null,null,null,137017,null,null,null,122209,null,null,null,117401,null,null,null,29658,null,null,null,87743,null,null,null,333706]
[]
[null,"Gross profit (loss)",null,null,null,"(1,127",")",null,null,21480,null,null,null,10195,null,null,null,4402,null,null,null,4818,null,null,null,"(416",")",null,null,"(86,217",")"]
[null,"General and administrative expenses",null,null,null,8052,null,null,null,11073,null,null,null,9220,null,null,null,7836,null,null,null,2065,null,null,null,5771,null,null,null,12497]
[]
[null,"Operating profit (loss) from continuing operations",null,null,null,"(9,179",")",null,null,10407,null,null,null,975,null,null,null,"(3,434",")",null,null,2753,null,null,null,"(6,187",")",null,null,"(98,714",")"]
[null,"Other (income) expense:"]
[null,null,"Interest expense",null,null,287,null,null,null,333,null,null,null,423,null,null,null,2287,null,null,null,154,null,null,null,2133,null,null,null,7051]
[null,null,"Reorganization expenses",null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,39629,null,null,null,"—",null,null,null,39629,null,null,null,42676]
[null,null,"Other income(3)",null,null,"(956",")",null,null,"(426",")",null,null,"(3,589",")",null,null,"(30,473",")",null,null,"(64",")",null,null,"(30,409",")",null,null,"(692",")"]
[]
[null,null,"Total interest and other (income) expense",null,null,"(669",")",null,null,"(93",")",null,null,"(3,166",")",null,null,"(11,443",")",null,null,90,null,null,null,"(11,353",")",null,null,49035]
[]
[null,"Income (loss) from continuing operations before income taxes",null,null,null,"(8,510",")",null,null,10500,null,null,null,4141,null,null,null,"(14,877",")",null,null,2663,null,null,null,"(17,540",")",null,null,"(147,749",")"]
[null,"Income tax expense",null,null,null,"—",null,null,null,3970,null,null,null,1511,null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—"]
[]
[null,"Income (loss) from continuing operations",null,null,null,"(8,510",")",null,null,6530,null,null,null,2630,null,null,null,"(14,877",")",null,null,2663,null,null,null,"(17,540",")",null,null,"(147,749",")"]
[null,"Loss from discontinued operations(2)(4)",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"(40,831",")",null,null,"—",null,null,null,"(40,831",")",null,null,"(20,173",")"]
[]
[null,"Net income (loss) before extraordinary item",null,null,null,"(8,510",")",null,null,6530,null,null,null,2630,null,null,null,"(55,708",")",null,null,2663,null,null,null,"(58,371",")",null,null,"(167,922",")"]
[null,"Extraordinary item(5)",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,378068,null,null,null,"—",null,null,null,378068,null,null,null,"—"]
[]
[null,"Net income (loss)",null,null,"$","(8,510",")",null,"$",6530,null,null,"$",2630,null,null,"$",322360,null,null,"$",2663,null,null,"$",319697,null,null,"$","(167,922",")"]
[]
[null,"Preferred stock dividends(6)",null,null,null,313,null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—"]
[]
[null,"Net income (loss) allocable to common stockholders(6)",null,null,"$","(8,823",")",null,"$",6530,null,null,"$",2630,null,null,"$",322360,null,null,"$",2663,null,null,"$",319697,null,null,"$","(167,922",")"]
[]
[]
[27]
[]
[]
[]
["Table of Contents"]
[]
[]
[null,null,null,"Successor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Successor",null,null,null,"Predecessor"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Three Months",null,null,null,"Nine Months"]
[null,null,null,"Year Ended",null,null,null,"Year Ended",null,null,null,"Year Ended",null,null,null,"Year Ended",null,null,null,"Ended",null,null,null,"Ended",null,null,null,"Year Ended"]
[null,null,null,"December 31,",null,null,null,"December 31,",null,null,null,"December 31,",null,null,null,"December 31,",null,null,null,"December 31,",null,null,null,"September 30,",null,null,null,"December 31,"]
[null,null,null,2005,null,null,null,2004,null,null,null,2003,null,null,null,2002,null,null,null,2002,null,null,null,2002,null,null,null,2001]
[]
["Earnings (Loss) Per Share Data"]
[null,"Continuing operations(6)(7)",null,"$","(0.17",")",null,"$",0.13,null,null,"$",0.05,null,null,"$","—",null,null,"$",0.05,null,null,"$","(1.02",")",null,"$","(8.62",")"]
[null,"Discontinued operations(2)(4)(7)",null,"$","—",null,null,"$","—",null,null,"$","—",null,null,"$","—",null,null,"$","—",null,null,"$","(2.39",")",null,"$","(1.18",")"]
[null,"Extraordinary item(5)(6)",null,"$","—",null,null,"$","—",null,null,"$","—",null,null,"$","—",null,null,"$","—",null,null,"$",22.07,null,null,"$","—"]
[null,"Net earnings (loss) per share(6)(7)",null,"$","(0.17",")",null,"$",0.13,null,null,"$",0.05,null,null,"$","—",null,null,"$",0.05,null,null,"$",18.66,null,null,"$","(9.80",")"]
[null,"Weighted average common stock outstanding(7)",null,null,51448,null,null,null,50779,null,null,null,50136,null,null,null,"—",null,null,null,50000,null,null,null,17133,null,null,null,17133]
["Operating Data"]
[null,"Chargeable weight — pounds moved(8)",null,null,159598,null,null,null,174727,null,null,null,152756,null,null,null,149588,null,null,null,38992,null,null,null,110596,null,null,null,175954]
[null,"Average yield per chargeable weight — pounds moved(9)",null,"$",0.95179999999999998,null,null,"$",0.88149999999999995,null,null,"$",0.83409999999999995,null,null,"$",0.77729999999999999,null,null,"$",0.80740000000000001,null,null,"$",0.76670000000000005,null,null,"$",0.76749999999999996]
[null,"Aircraft fuel — average cost per gallon(10)",null,"$",1.8633,null,null,"$",1.3604000000000001,null,null,"$",1.0325,null,null,"$",0.89770000000000005,null,null,"$",0.99460000000000004,null,null,"$",0.86529999999999996,null,null,"$",0.96060000000000001]
[null,"Revenue block hours flown(11)",null,null,23991,null,null,null,24376,null,null,null,20882,null,null,null,22674,null,null,null,6221,null,null,null,16453,null,null,null,39103]
["Financial Condition (At End of Period)"]
[null,"Cash and cash equivalents",null,"$",26650,null,null,"$",16284,null,null,"$",15729,null,null,"$",10353,null,null,"$",10353,null,null,"$",4610,null,null,"$",13472]
[null,"Total assets",null,null,56934,null,null,null,49070,null,null,null,47110,null,null,null,47259,null,null,null,47259,null,null,null,47354,null,null,null,171606]
[null,"Notes payable and long-term obligations(12)",null,null,2305,null,null,null,2755,null,null,null,3689,null,null,null,4978,null,null,null,4978,null,null,null,5819,null,null,null,6580]
[null,"Liabilities subject to compromise(12)",null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,"—",null,null,null,465161]
[null,"Stockholders’ equity (deficit)(12)",null,"$",27407,null,null,"$",34116,null,null,"$",23604,null,null,"$",19263,null,null,"$",19263,null,null,"$",16600,null,null,"$","(319,697",")"]

{"sheet":"Sheet20","index":5,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,2,1,4],[1,6,1,8],[1,10,1,11],[2,2,2,4],[2,6,2,8],[2,10,2,11],[3,2,3,4],[3,6,3,8],[3,10,3,11],[4,2,4,3],[4,6,4,7],[4,10,4,11],[5,2,5,3],[5,6,5,7],[5,10,5,11],[6,2,6,3],[6,6,6,7],[6,10,6,12]]}
[]
[null,null,null,null,null,null,null,null,null,null,"Aircraft Fuel Expense as a"]
[null,null,null,null,null,null,null,null,null,null,"Percentage of Scheduled"]
[null,null,null,null,null,null,null,null,null,null,"Freight Operating"]
["Year",null,"Total Cost",null,null,null,"Average Cost",null,null,null,"Expenses"]
[]
[null,null,"(In millions)",null,null,null,"(Per gallon)"]
[2005,null,"$",54.7,null,null,"$",1.86,null,null,null,35.700000000000003,"%"]
[2004,null,null,45.8,null,null,null,1.36,null,null,null,32.9]
[2003,null,null,30.8,null,null,null,1.03,null,null,null,25.5]

{"sheet":"Sheet21","index":6,"n_rows":16,"n_cols":22,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,8,0,13],[0,16,0,18],[1,0,1,1],[1,3,1,8],[1,11,1,16],[4,19,4,20],[1,19,1,20],[2,0,2,1],[2,3,2,5],[2,7,2,8],[2,11,2,13],[2,15,2,16],[2,19,2,20],[4,0,4,1],[4,3,4,4],[4,7,4,8],[4,11,4,12],[4,15,4,16],[3,19,3,20],[3,0,3,1],[3,3,3,4],[3,7,3,8],[3,11,3,12],[3,15,3,16],[16,0,16,1],[16,3,16,4],[16,7,16,8],[14,7,14,8],[8,0,8,1],[9,0,9,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[14,3,14,4],[14,11,14,12],[14,15,14,16],[14,19,14,20],[10,0,10,1],[5,0,5,1],[5,3,5,4],[5,11,5,12],[6,0,6,1],[6,3,6,20],[7,0,7,1],[5,15,5,16],[5,19,5,20],[5,7,5,8]]}
[2005,null,null,null,null,null,null,null,2004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentage"]
[null,null,null,null,null,null,null,"Percentage",null,null,null,null,null,null,null,"Percentage of",null,null,null,"Change"]
[null,null,null,"Cost of",null,null,null,"of Total",null,null,null,"Cost of",null,null,null,"Total",null,null,null,"from 2004"]
[null,null,null,"Revenue",null,null,null,"Revenue",null,null,null,"Revenue",null,null,null,"Revenue",null,null,null,"to 2005"]
[]
[null,null,null,"(Dollars in thousands)"]
["Flight expense",null,null,"$",30241,null,null,null,19.3,"%",null,"$",27924,null,null,null,17.600000000000001,"%",null,null,8.3000000000000007,"%"]
["Transportation expense",null,null,null,17106,null,null,null,10.9,null,null,null,14603,null,null,null,9.1999999999999993,null,null,null,17.100000000000001]
["Aircraft fuel expense",null,null,null,54656,null,null,null,34.9,null,null,null,45838,null,null,null,28.9,null,null,null,19.2]
["Aircraft maintenance expense",null,null,null,14207,null,null,null,9.1,null,null,null,7047,null,null,null,4.4000000000000004,null,null,null,101.6]
["Freight handling expense",null,null,null,26715,null,null,null,17.100000000000001,null,null,null,27705,null,null,null,17.5,null,null,null,"(3.6",")"]
["Depreciation and amortization",null,null,null,3693,null,null,null,2.2999999999999998,null,null,null,3091,null,null,null,2,null,null,null,19.5]
["Operating overhead expense",null,null,null,11146,null,null,null,7.1,null,null,null,10809,null,null,null,6.9,null,null,null,3.1]
[]
[null,"Total cost of revenue",null,"$",157764,null,null,null,100.7,"%",null,"$",137017,null,null,null,86.5,"%",null,null,15.1,"%"]

{"sheet":"Sheet1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}