Macro Help - Open Multiple Text Files one at a time, import data, use vlook tu match data to another sheet

hansonesh

New Member
Joined
Aug 9, 2013
Messages
2
I am having an issue with a macro I created. Essentially I have a bunch of text files that dump memory data from a server every 15 minutes. I am trying to create a macro that will open those text files into a "import" sheet, run a text to columns to clean it up, go to another sheet "data_log" in the same workbook, insert a column, do a vlook up to match data in column A in Data_log to data in column F (bytes) in the import sheet.

What I am running into is that the macro I've created will import all of the data in the text files to the import sheet, but will put all that data in the same columns, running down the rows, so I am trying to make the macro import one file at a time, do the vlookup, then clear the file contents on the "import" sheet, open the next file, rinse repeat. Its opening the files, but not displaying data, and its not doing the vlookup correctly either. It's only importing one line.

Columns A and B, and rows 1-2 will be static in Data_log, and the data imported to import will always have the same format and be the same columns as far as A for the memory tag and F for the bytes it uses.

Here is the Full Code:


Code:
Sub Read_Text_Files()
Dim sPath As String, sLine As String
Dim oPath As Object, oFile As Object, oFSO As Object
Dim r As Long
'
'Files location
sPath = "C:\Test\"
'
r = 1
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oPath = oFSO.GetFolder(sPath)
Application.ScreenUpdating = True
For Each oFile In oPath.Files
If LCase(Right(oFile.Name, 4)) = ".txt" Then
'
Open oFile For Input As #1 ' Open file for input.
Do While Not EOF(1) ' Loop until end of file.
Input #1, sLine ' Read data
If Left(sLine, 1) = "=" Then sLine = "'" & sLine 'If line starts with an equal sign, add a single quote at the start
sLine = Replace(sLine, Chr(2), "") 'Strip funky characters
sLine = Replace(sLine, Chr(3), "")
sLine = Replace(sLine, Chr(10), "")
Range("A" & r).Formula = sLine ' Write data line
'Text to Columns
Range("A1", Range("A" & Cells.Rows.Count).End(xlUp)).Select
Selection.TextToColumns DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False
Application.ScreenUpdating = True
r = r + 1


Loop
Close #1 ' Close file.
'
Sheets("Data_log").Select
Columns("C:C").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
    Columns("D:D").Select
    Selection.Copy
    Columns("C:C").Select
    Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    Range("D1").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("C1").Select
    ActiveSheet.Paste
    Range("C5").Select
    ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Import!RC[-2]:R[1088]C[4],6,FALSE)"
    Range("C5").Select
    Selection.AutoFill Destination:=Range("C5:C1093"), Type:=xlFillDefault
    Range("C5:C1093").Select
    Calculate
    Range("C5").Select
    Calculate
    Columns("C:C").Select
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    'Range("C2").Select = oFile.Name
'


Sheets("Import").Select
Range("A1:H2000").Select
    Selection.ClearContents
Sheets("Data_log").Select
End If
Next oFile


I am also trying to get it to use the name of the text file as the heading for each column. I tried using 'Range("C2").Select = oFile.Name but its not working correctly.

Here is one of the text files. The formats will be the same just the data will change. The way it appears below is copied directly from the text file. It doesn't import that way into excel which is why I have the text to columns part.

Code:
09:06 AM

 Tag  Type     Allocs         Frees    Diff   Bytes    Per Alloc


  TSQ Nonp         90        89         1      56         56        
  waR Nonp       8031      8031         0       0          0        
 8042 Nonp          4         0         4    3944        986        
 ACPI Nonp         43        43         0       0          0        
 AGP  Nonp          1         0         1     200        200        
 ARFT Paged         3         0         3      96         32        
 AcdN Nonp          2         0         2    1072        536        
 AcpA Nonp        360       357         3     192         64        
 AcpB Paged        38        38         0       0          0        
 AcpD Nonp        937       559       378  134960        357        
 AcpF Nonp       8175      8138        37    1480         40        
 AcpI Nonp          3         3         0       0          0        
 AcpM Nonp      15774     15774         0       0          0        
 AcpO Nonp          4         0         4     672        168        
 AcpP Nonp        356       352         4     352         88        
 AcpR Nonp          9         6         3    3536       1178        
 AcpS Nonp        991       786       205    5208         25        
 Acpg Nonp          1         0         1      48         48        
 Acpi Nonp        725       724         1     136        136        
 Acpt Nonp          2         1         1     120        120        
 Adap Nonp          7         0         7    3024        432        
 AfdB Nonp     938555    938513        42   56400       1342        
 AfdC Nonp     165467    158069      7398 1183680        160        
 AfdE Nonp     174622    173356      1266  354480        280        
 AfdI Nonp      25309     25309         0       0          0        
 AfdL Nonp      26006     25520       486   19440         40        
 AfdP Nonp  132717629 132716615      1014  130064        128        
 AfdR Nonp         39        29        10     320         32        
 AfdS Paged         2         2         0       0          0        
 AfdT Nonp          3         0         3     304        101        
 AfdX Paged    174472    173332      1140  319200        280        
 Afdh Nonp          3         0         3     144         48        
 Afdr Nonp          4         0         4     824        206        
 Afdt Paged         2         0         2     320        160        
 AgpG Paged         1         0         1     128        128        
 AmlC Nonp       2130      2126         4   32768       8192        
 AmlH Nonp          6         0         6  393216      65536        
 AmlI Nonp          2         0         2     392        196        
 AmlR Nonp          1         0         1      32         32        
 AmlT Nonp       1785      1785         0       0          0        
 ApcR Paged        34        34         0       0          0        
 ApcS Nonp          1         0         1      24         24        
 ArbA Paged       108         0       108  442368       4096        
 ArbL Paged       621       341       280   73920        264        
 ArbM Nonp        108         0       108    2592         24        
 ArbR Paged       216         0       216    6912         32        
 AtmA Paged      3350      2229      1121   74344         66        
 AtmT Paged        16         4        12    7392        616        
 BBdB Nonp          1         0         1    2120       2120        
 BBdC Nonp        112         0       112    8064         72        
 BBdD Nonp          2         0         2      96         48        
 BBdF Nonp          1         0         1      56         56        
 BBdG Nonp         23         0        23    1656         72        
 BBdJ Nonp          1         0         1      72         72        
 BBdK Paged         6         3         3      48         16        
 BBdL Nonp          1         0         1     216        216        
 BBdM Nonp          1         0         1    2120       2120        
 BBdO Paged         1         1         0       0          0        
 BBdP Paged         2         2         0       0          0        
 BBdQ Paged         1         1         0       0          0        
 BBdR Paged      8387      8387         0       0          0        
 BBdT Paged      8389      8389         0       0          0        
 BBdU Paged     67107     67107         0       0          0        
 BBdV Nonp          1         0         1     136        136        
 BBdZ Paged         2         2         0       0          0        
 BBda Paged         1         1         0       0          0        
 BBdc Paged       455       451         4     896        224        
 BBdd Paged         2         0         2   16384       8192        
 BBdf Paged     67107     67107         0       0          0        
 BBdg Paged         2         0         2     264        132        
 BBdh Nonp          1         1         0       0          0        
 BBdi Paged   8482347   8482347         0       0          0        
 BBdj Paged      5305      5305         0       0          0        
 BBdk Paged         1         1         0       0          0        
 BBdq Paged         1         1         0       0          0        
 BBds Paged     36673     36673         0       0          0        
 BBdu Paged         1         0         1      56         56        
 BBdv Paged         2         2         0       0          0        
 BBdw Paged        10        10         0       0          0        
 BBdx Paged         2         2         0       0          0        
 BBdy Paged         6         6         0       0          0        
 BBdz Paged         6         3         3   75744      25248        
 BBeA Paged     11308     11308         0       0          0        
 BBeB Paged     11377     11377         0       0          0        
 BBeD Nonp          1         0         1    2120       2120        
 BBeG Paged         2         1         1      64         64        
 BBeI Paged         4         2         2      32         16        
 BBeO Nonp          1         0         1    2120       2120        
 BBeS Paged         1         0         1      56         56        
 BBeV Nonp          2         0         2      64         32        
 BBeZ Paged         2         2         0       0          0        
 BBeb Paged        23        23         0       0          0        
 BBed Paged        23        23         0       0          0        
 BBel Paged        10         8         2    3904       1952        
 BBeo Nonp          2         1         1     112        112        
 BBeq Paged        92        92         0       0          0        
 BBfB Paged         1         0         1      80         80        
 BBfD Paged        90        90         0       0          0        
 BBfE Paged    439953    439784       169    6760         40        
 BBfF Nonp          1         0         1    2120       2120        
 BBfG Paged         1         0         1     312        312        
 BBfH Nonp          1         0         1    2120       2120        
 BBfI Paged         1         0         1    3976       3976        
 BBfM Nonp          1         0         1    2120       2120        
 BBfS Paged 486564672 486564672         0       0          0        
 BLes Paged         2         2         0       0          0        
 BatM Paged         1         0         1     120        120        
 Batt Nonp          1         0         1     256        256        
 CBRe Nonp          7         0         7     280         40        
 CCdA Paged         1         0         1    8192       8192        
 CCdB Paged         1         0         1     496        496        
 CCdD Paged         8         7         1     648        648        
 CCdF Nonp          2         0         2    4240       2120        
 CCdG Nonp          3         0         3     216         72        
 CCdH Nonp          7         0         7     280         40        
 CCdJ Paged         7         6         1     296        296        
 CCdK Paged         1         0         1     128        128        
 CCdM Paged         2         0         2     112         56        
 CCda Paged         3         0         3     440        146        
 CCdb Paged         1         0         1     144        144        
 CCdc Paged         1         1         0       0          0        
 CCdd Paged    439977    439806       171   14360         83        
 CCdk Paged        67        67         0       0          0        
 CCeO Nonp          2         0         2    4240       2120        
 CCeV Nonp          3         0         3      96         32        
 CCet Paged      1722      1722         0       0          0        
 CCeu Paged     12941     12941         0       0          0        
 CCev Paged         7         7         0       0          0        
 CCex Paged         7         7         0       0          0        
 CCey Paged         1         1         0       0          0        
 CCez Paged         1         1         0       0          0        
 CCfF Nonp          2         0         2    4240       2120        
 CCfG Paged      3752      3752         0       0          0        
 CCfH Paged      3731      3731         0       0          0        
 CCfI Paged         7         7         0       0          0        
 CCfJ Paged         1         0         1      40         40        
 CCfL Paged         1         0         1      16         16        
 CCfM Paged         1         0         1      16         16        
 CCfP Paged         1         0         1     528        528        
 CCfQ Paged         1         0         1      16         16        
 CCfS Paged         1         0         1      56         56        
 CCfV Nonp          2         0         2    4240       2120        
 CCfZ Paged         1         0         1      16         16        
 CCfa Paged         2         2         0       0          0        
 CCfb Paged         2         2         0       0          0        
 CCfl Nonp         65        64         1      64         64        
 CCgD Paged         1         0         1      16         16        
 CCgF Paged    439952    439784       168   22848        136        
 CCgG Nonp     439953    439784       169    8112         48        
 CCgH Paged         1         0         1      24         24        
 CCgI Paged         1         0         1      16         16        
 CCgK Paged         1         0         1      16         16        
 CCgL Paged         1         0         1      96         96        
 CCgM Paged         1         0         1      16         16        
 CCgO Paged         1         0         1      24         24        
 CCgP Paged         1         0         1     320        320        
 CCgQ Paged         1         0         1      32         32        
 CM   Nonp      82237     82220        17     680         40        
 CM1  Paged        34        34         0       0          0        
 CM10 Paged       230       213        17   24072       1416        
 CM11 Paged         3         1         2    8192       4096        
 CM13 Paged         1         0         1    4096       4096        
 CM16 Paged       346       241       105  507904       4837        
 CM17 Paged       102        89        13  106496       8192        
 CM19 Paged         1         0         1    1008       1008        
 CM2  Paged        34        34         0       0          0        
 CM20 Paged         3         2         1    4096       4096        
 CM21 Paged         3         2         1      32         32        
 CM22 Paged         1         1         0       0          0        
 CM24 Paged         1         0         1    4096       4096        
 CM25 Paged       836       801        35  495616      14160        
 CM26 Paged       221       210        11   90112       8192        
 CM27 Paged       226       212        14   10120        722        
 CM28 Paged         5         2         3   12288       4096        
 CM29 Paged        19         4        15  122880       8192        
 CM3  Paged        34        34         0       0          0        
 CM32 Paged       226       212        14   57344       4096        
 CM35 Paged       567       531        36 1458176      40504        
 CM38 Paged     20350     20350         0       0          0        
 CM39 Paged      7896      7224       672  189696        282        
 CM4  Paged        34        34         0       0          0        
 CM44 Nonp    1434084   1433579       505   16128         31        
 CM45 Paged       280       274         6     144         24        
 CM7  Paged       577       346       231    7392         32        
 CM8  Paged      3311      3311         0       0          0        
 CMAl Paged      1000       785       215  880640       4096        
 CMCa Paged         2         0         2   40960      20480        
 CMDa Paged   1271832   1269609      2223  483424        217        
 CMIn Paged     13233     12849       384   11080         28        
 CMNb Paged  47093358  47091228      2130  107640         50        
 CMSb Paged         2         1         1    8192       8192        
 CMSc Paged      2363      2127       236   58208        246        
 CMVI Paged     62408     60740      1668   53104         31        
 CMVa Paged   1699320   1694438      4882  288968         59        
 CMVw Paged      6997      6127       870   41760         48        
 CMcb Paged         1         1         0       0          0        
 CMgi Paged         7         7         0       0          0        
 CMnb Paged   1428584   1428067       517   28952         56        
 CMpa Nonp    1434016   1433515       501   32064         64        
 CMpb Paged   1434364   1433853       511   24528         48        
 CMpi Paged      7198      6702       496   13600         27        
 COMX Nonp         10         8         2      48         24        
 CPnp Nonp        308        51       257   65792        256        
 CTGC Nonp          2         0         2   73728      36864        
 CTMM Nonp         20         8        12    1112         92        
 Call Nonp          7         0         7     504         72        
 Cbrb Paged         7         4         3      72         24        
 CcBc Nonp    2484848   2484614       234   31824        136        
 CcBr Nonp        481       461        20     800         40        
 CcPB Nonp        128       128         0       0          0        
 CcPD Paged         2         2         0       0          0        
 CcPF Paged      1070      1070         0       0          0        
 CcPI Paged         2         2         0       0          0        
 CcPL Nonp         11        11         0       0          0        
 CcPT Nonp          1         1         0       0          0        
 CcPc Nonp     806480    806299       181   17376         96        
 CcPp Paged         1         1         0       0          0        
 CcPq Paged       135       135         0       0          0        
 CcPs Nonp          1         1         0       0          0        
 CcPv Paged         3         3         0       0          0        
 CcPw Nonp          3         3         0       0          0        
 CcSc Nonp    3694013   3693343       670  209040        312        
 CcVa Nonp          1         0         1   49152      49152        
 CcVl Nonp       2739      2619       120   89984        749        
 CcVp Nonp      24879     24822        57   10416        182        
 CcWK Nonp         16         0        16    2176        136        
 CcWk Nonp     930263    930165        98    2352         24        
 CcWq Nonp          8         0         8     192         24        
 CcZe Nonp          3         3         0       0          0        
 Cdic Nonp          1         0         1      72         72        
 CmVn Paged    265092    265092         0       0          0        
 Cont Nonp          2         0         2     144         72        
 D2d  Paged    879904    439952    439952 10558848         24        
 DG   Paged       474       474         0       0          0        
 DOPE Nonp          9         0         9     792         88        
 Dacl Paged         9         8         1      96         96        
 Desk Nonp         24         9        15    2880        192        
 Devi Nonp      56740     56331       409  248336        607        
 Dfsb Paged       439       439         0       0          0        
 Dire Paged      5470      5413        57   11856        208        
 Dmio Nonp          2         0         2    1040        520        
 Dmiq Nonp          1         0         1     264        264        
 Dmld Nonp          2         2         0       0          0        
 Dnod Nonp        445       289       156   46176        296        
 DrDr Nonp        284       275         9     424         47        
 DrEx Nonp       2451      2448         3     120         40        
 DrIC Nonp       2451      2448         3     168         56        
 Driv Nonp        137        16       121   29032        239        
 Dump Nonp          8         1         7  893360     127622        
 Efsc Paged         2         2         0       0          0        
 Efsm Paged         4         4         0       0          0        
 Evel Nonp          1         0         1      24         24        
 Even Nonp    9183439   9174535      8904  431184         48        
 FLex Nonp          2         0         2     128         64        
 FLfl Paged       322       296        26    1872         72        
 FLli Nonp        326       298        28    1120         40        
 FLln Nonp          2         0         2      80         40        
 FLsh Nonp          2         0         2     112         56        
 FMcb Nonp          2         2         0       0          0        
 FMcr Nonp          2         0         2    1216        608        
 FMct Nonp      54500     54492         8    8832       1104        
 FMdl Nonp         12        12         0       0          0        
 FMea Paged   2073492   2073492         0       0          0        
 FMfc Nonp       3189      3183         6     288         48        
 FMfi Nonp          1         0         1     120        120        
 FMfl Nonp          4         0         4    2440        610        
 FMfn Nonp      20184     20180         4    1152        288        
 FMfr Nonp          4         2         2   16384       8192        
 FMic Nonp    3515134   3515010       124   39792        320        
 FMis Nonp      28529     28521         8    3984        498        
 FMla Nonp          4         2         2    8192       4096        
 FMnc Nonp       4990      4986         4     160         40        
 FMng Nonp      34153     34149         4     480        120        
 FMpl Nonp          2         0         2    4232       2116        
 FMpr Nonp          6         4         2    2128       1064        
 FMrr Nonp      72259     72243        16    8832        552        
 FMsd Paged         3         3         0       0          0        
 FMsl Nonp     370990    348775     22215 4620720        208        
 FMtr Paged     57066     57066         0       0          0        
 FMus Paged         8         4         4      72         18        
 FMvo Nonp      48208     48200         8    8112       1014        
 FMwi Nonp          4         0         4     160         40        
 FOCX Nonp    1998716   1998714         2      96         48        
 FSfm Nonp     344527    329624     14903  596120         40        
 FSim Paged    343814    329309     14505 1856640        128        
 FSmg Nonp          4         0         4    1120        280        
 FSrN Nonp       1131      1124         7     336         48        
 FSrm Nonp         86        61        25   11984        479        
 FSro Nonp       4512      2313      2199   87960         40        
 FSrt Nonp          1         0         1     904        904        
 FSun Nonp          2         2         0       0          0        
 FatI Nonp          1         0         1      80         80        
 File Nonp  108608692 108574109     34583 5472696        158        
 Filt Nonp          3         2         1      80         80        
 Flop Nonp          9         7         2      80         40        
 Fsrc Nonp          3         2         1      24         24        
 FstB Nonp         16        15         1     632        632        
 Fstb Nonp         33        33         0       0          0        
 Gdwd Nonp          6         0         6     512         85        
 Gfsm Nonp         10         4         6     240         40        
 Gla1 Nonp          5         2         3     336        112        
 Gla4 Nonp          5         2         3     336        112        
 Gla5 Nonp          5         2         3     336        112        
 Gla8 Nonp          5         2         3     336        112        
 Gla: Nonp          5         2         3     336        112        
 Gla; Nonp          5         2         3     336        112        
 Gla@ Nonp          5         2         3     336        112        
 Gsem Nonp        750       442       308   24544         79        
 Hal  Nonp        121       118         3  197520      65840        
 IPmm Nonp          1         1         0       0          0        
 Ica  Nonp    1011605   1011520        85   82776        973        
 Icp  Nonp     202510    202306       204    8160         40        
 IdeP Nonp       3080      3059        21    4512        214        
 IdeX Nonp          8         6         2     128         64        
 Ifs  Paged         3         2         1     112        112        
 ImRP Paged         1         0         1     120        120        
 Info Nonp    3564723   3564722         1   61440      61440        
 Init Nonp          1         1         0       0          0        
   Io Nonp          2         1         1    8192       8192        
 Io   Nonp  199183649 199182502      1147  114136         99        
 IoCc Paged    331319    331078       241    3856         16        
 IoCo Nonp      17534     17257       277   19944         72        
 IoEa Nonp    2448934   2448934         0       0          0        
 IoEr Nonp         19        10         9    1112        123        
 IoFc Paged         3         3         0       0          0        
 IoFs Paged         3         0         3      72         24        
 IoFu Paged         1         1         0       0          0        
 IoKB Paged      3177      3177         0       0          0        
 IoNm Paged 123807873 123798632      9241  813760         88        
 IoOp Nonp  106470162 106470161         1     104        104        
 IoRN Paged       114       114         0       0          0        
 IoRi Nonp         13        13         0       0          0        
 IoSe Paged        59        59         0       0          0        
 IoSh Nonp         84        68        16     384         24        
 IoTi Nonp         11         0        11     352         32        
 IoUs Nonp         18        14         4      96         24        
 Ioin Nonp       6395      6384        11   22880       2080        
 IpEQ Nonp          1         0         1    2208       2208        
 IpIO Nonp          1         1         0       0          0        
 IpLA Nonp          1         0         1     248        248        
 IpSI Nonp       1027         0      1027   53272         51        
 IpTI Nonp          3         0         3    5400       1800        
 Irp  Nonp   15898153  15895430      2723  864960        317        
 Isap Nonp          1         0         1      16         16        
 Job  Nonp          8         7         1     432        432        
 KbdC Nonp          3         0         3    2544        848        
 Ke   Nonp        102       101         1     296        296        
 Key  Paged 127086949 127084595      2354  244768        103        
 Keye Paged         1         0         1      64         64        
 KrbC Paged      3334      3321        13     880         67        
 Ksec Nonp          6         0         6    5352        892        
 L2T1 Nonp          1         0         1    1064       1064        
 L2T4 Nonp          1         0         1    4016       4016        
 L2Ti Nonp          5         3         2      88         44        
 LBan Paged         2         2         0       0          0        
 LBbn Paged         3         0         3     184         61        
 LBci Nonp        175       175         0       0          0        
 LBdi Nonp          1         0         1     168        168        
 LBds Nonp        175       175         0       0          0        
 LBea Paged         3         3         0       0          0        
 LBma Nonp      39767     39767         0       0          0        
 LBmb Nonp          1         0         1     584        584        
 LBmh Nonp        175       175         0       0          0        
 LBne Paged       291       291         0       0          0        
 LBpd Nonp     231519    231519         0       0          0        
 LBpn Paged         3         0         3     120         40        
 LBpt Paged         1         0         1     408        408        
 LBtn Nonp          3         0         3     216         72        
 LBwi Nonp       5125      5125         0       0          0        
 LBxp Nonp          1         0         1     592        592        
 LSac Paged         4         0         4     168         42        
 LSas Nonp          4         4         0       0          0        
 LSbf Paged      6544      6536         8    2152        269        
 LScn Nonp         56         0        56   39872        712        
 LSdb Nonp      51042     51041         1      24         24        
 LSep Nonp          4         0         4    1568        392        
 LSfn Paged         4         0         4     128         32        
 LSlf Paged     10071     10071         0       0          0        
 LSmf Paged      6602      6602         0       0          0        
 LSmi Nonp          1         0         1      32         32        
 LSnh Nonp       4213      4191        22     704         32        
 LSni Paged         1         1         0       0          0        
 LSop Nonp        139       139         0       0          0        
 LSpc Paged        56         0        56   11648        208        
 LSpm Nonp       5120      5118         2     192         96        
 LSpr Paged      5861      5857         4     288         72        
 LSrf Nonp       6055      6049         6    1488        248        
 LSsd Paged         3         0         3     336        112        
 LSsh Nonp         14         0        14    1008         72        
 LSsr Paged       368       361         7     256         36        
 LSss Paged      1204      1200         4     448        112        
 LStb Nonp        195       135        60   33568        559        
 LStc Paged       508       507         1     128        128        
 LStr Paged    100938    100919        19    4608        242        
 LSwi Nonp          1         0         1 2576384     2576384        
 LSwn Nonp        194       194         0       0          0        
 LSwq Nonp          2         0         2   24576      12288        
 LSwr Nonp        128         0       128  416768       3256        
 Lfs  Paged    449506    449436        70    6784         96        
 LfsI Paged         2         0         2  131072      65536        
 LfsS Nonp          2         0         2     208        104        
 Lfsr Nonp          2         0         2   32768      16384        
 List Nonp         38        16        22     528         24        
 LpcM Paged     42741     42737         4    1440        360        
 MRXx Paged         9         9         0       0          0        
 Mapr Nonp         11        10         1    2056       2056        
 Mdl  Nonp     111277    109615      1662  212736        128        
 Mdp  Nonp          8         0         8    9216       1152        
 Mem  Paged         5         5         0       0          0        
 Mm   Nonp         44        26        18 1432528      79584        
 MmCa Nonp    9009761   8986937     22824 2542896        111        
 MmCi Nonp        948       351       597  139808        234        
 MmCm Nonp         37        29         8 2224128     278016        
 MmCx Nonp          2         2         0       0          0        
 MmDT Nonp         30        14        16    1688        105        
 MmDb Nonp          1         0         1     144        144        
 MmDm Nonp        128         0       128   10240         80        
 MmEx Nonp          3         0         3      96         32        
 MmHi Nonp         26        14        12     576         48        
 MmHt Nonp          5         2         3    6168       2056        
 MmIn Nonp         70        54        16    2560        160        
 MmLd Nonp        138        20       118   13504        114        
 MmLn Nonp        125       125         0       0          0        
 MmMl Nonp          7         6         1      48         48        
 MmPd Nonp          1         0         1   16384      16384        
 MmRl Nonp        467       467         0       0          0        
 MmSP Nonp          1         0         1   12288      12288        
 MmSc Nonp        460       299       161    9016         56        
 MmSd Nonp       1053       898       155    8680         56        
 MmSe Nonp        317       259        58    1856         32        
 MmSg Paged         1         0         1      80         80        
 MmSm Paged    584628    562639     21989 1407296         64        
 MmSt Paged   1849939   1826254     23685 47201168       1992        
 MmSy Nonp        971       948        23    1288         56        
 MmWe Nonp        191         0       191   32088        168        
 MmWw Nonp          3         1         2      96         48        
 MmZw Nonp         16        16         0       0          0        
 Mmdl Nonp        160       160         0       0          0        
 Mmpr Nonp          4         1         3     120         40        
 Mmpv Nonp        104        99         5     240         48        
 Mmww Nonp          3         1         2    1080        540        
 MntA Nonp         14         8         6    2696        449        
 MsFD Nonp          1         0         1     264        264        
 MsFN Paged       495       495         0       0          0        
 MsFf Nonp        495       495         0       0          0        
 MsFg Nonp          1         0         1      64         64        
 MsvC Paged      1643      1641         2     760        380        
 MuoC Nonp          3         0         3    4944       1648        
 Mup  Nonp       1958      1953         5     408         81        
 MupI Nonp          1         0         1      48         48        
 Muta Nonp    1564142   1547254     16888 1082672         64        
 NBSa Nonp         27        27         0       0          0        
 NBSe Nonp         27        27         0       0          0        
 NBSf Nonp         90        88         2    2280       1140        
 NBSl Nonp         27        27         0       0          0        
 NBSn Nonp        185       184         1     128        128        
 NBSr Paged         1         1         0       0          0        
 NBqh Nonp          5         0         5     160         32        
 ND   Nonp        147       147         0       0          0        
 NDPt Nonp          2         0         2    4176       2088        
 NDPw Nonp          2         0         2    4176       2088        
 NDam Nonp     325392    325392         0       0          0        
 NDan Nonp         14         1        13    1120         86        
 NDar Nonp          1         0         1     336        336        
 NDca Paged         3         3         0       0          0        
 NDch Nonp          7         6         1     208        208        
 NDco Nonp         23        12        11    1112        101        
 NDcs Nonp         12         7         5     120         24        
 NDda Paged         3         3         0       0          0        
 NDdb Nonp     164206    164191        15    7704        513        
 NDfa Nonp          6         3         3     232         77        
 NDfm Nonp          6         0         6     672        112        
 NDlp Nonp       9079      9079         0       0          0        
 NDmo Nonp         11         0        11    2592        235        
 NDoa Nonp          4         0         4    1032        258        
 NDoc Nonp     163610    163610         0       0          0        
 NDpb Nonp          6         0         6    1344        224        
 NDpc Nonp          3         2         1     192        192        
 NDpf Nonp         17         0        17    4536        266        
 NDpk Nonp          3         0         3     272         90        
 NDpn Nonp         27        27         0       0          0        
 NDpp Nonp        848       825        23   70112       3048        
 NDrd Nonp         55        55         0       0          0        
 NDsd Paged         3         3         0       0          0        
 NDse Nonp         14        14         0       0          0        
 NDst Nonp         16        13         3      88         29        
 NDw1 Nonp          6         0         6    7368       1228        
 NDw2 Nonp          6         6         0       0          0        
 NDw3 Nonp         19        19         0       0          0        
 NDwh Nonp          6         0         6     832        138        
 NDwi Nonp     888786    888786         0       0          0        
 NPLL Nonp          2         0         2     208        104        
 Nb01 Nonp          2         0         2    2208       1104        
 Nb02 Nonp        466       463         3     120         40        
 Nb03 Nonp       1510      1507         3      96         32        
 Nb05 Nonp         37        27        10    1600        160        
 Nb07 Nonp          6         0         6    1824        304        
 Nb14 Nonp        179       179         0       0          0        
 Nb16 Nonp          6         0         6     960        160        
 Nb17 Nonp          2         1         1     120        120        
 Nb20 Nonp        177       177         0       0          0        
 Nb22 Nonp       4959      4959         0       0          0        
 Nb23 Nonp          2         2         0       0          0        
 Nb25 Nonp          3         3         0       0          0        
 Nb26 Nonp          7         7         0       0          0        
 Nb27 Nonp          7         5         2    1280        640        
 Nb28 Nonp          3         3         0       0          0        
 Nb29 Nonp         17        17         0       0          0        
 Nb30 Nonp        157       157         0       0          0        
 Nb32 Nonp          1         1         0       0          0        
 Nb33 Nonp         23        23         0       0          0        
 Nb36 Nonp          6         5         1      32         32        
 Nb37 Nonp          3         2         1      56         56        
 Nb38 Nonp          3         3         0       0          0        
 Nb39 Nonp          2         0         2     160         80        
 NbL0 Nonp        693       662        31    5208        168        
 NbL1 Nonp        336       326        10    1680        168        
 NbL2 Nonp       1592      1530        62   10416        168        
 NbL3 Nonp       1536      1535         1     168        168        
 NbL4 Nonp         50        50         0       0          0        
 NbTA Nonp       3800      3800         0       0          0        
 Nba9 Nonp          4         4         0       0          0        
 Nbt  Paged         1         1         0       0          0        
 Nbt0 Nonp       1542      1534         8    1088        136        
 Nbt2 Nonp     273038    273038         0       0          0        
 Nbt8 Nonp        628       623         5      80         16        
 Nbt9 Nonp         91        91         0       0          0        
 NbtA Nonp          7         7         0       0          0        
 NbtC Nonp         33        27         6     720        120        
 NbtD Nonp       1592      1535        57   10032        176        
 NbtF Nonp       3385      3381         4     168         42        
 NbtG Nonp       1670      1670         0       0          0        
 NbtH Nonp        362       362         0       0          0        
 NbtK Nonp        578       578         0       0          0        
 NbtL Nonp        655       655         0       0          0        
 NbtM Nonp         97        97         0       0          0        
 NbtN Nonp       1820      1820         0       0          0        
 NbtO Nonp         31        31         0       0          0        
 NbtR Nonp        749       746         3     408        136        
 NbtS Nonp         42        42         0       0          0        
 NbtV Nonp        211       211         0       0          0        
 NbtX Nonp       2364      2364         0       0          0        
 NbtY Nonp         50        50         0       0          0        
 NbtZ Nonp        310       310         0       0          0        
 Nbta Nonp          1         0         1      40         40        
 Nbtb Nonp         27        27         0       0          0        
 Nbtc Nonp       1525      1525         0       0          0        
 Nbte Nonp       1536      1536         0       0          0        
 Nbtg Nonp          2         0         2      32         16        
 Nbti Nonp         26        26         0       0          0        
 Nbtj Nonp       1541      1541         0       0          0        
 Nbtk Nonp       1541      1541         0       0          0        
 Nbtl Nonp       4207      4103       104   14976        144        
 Nbtm Nonp       4207      4207         0       0          0        
 Nbtn Nonp       1551      1551         0       0          0        
 Nbtq Nonp          1         1         0       0          0        
 Nbtr Nonp          3         3         0       0          0        
 Nbts Nonp          1         1         0       0          0        
 Nbtw Nonp          3         0         3     440        146        
 Nls  Nonp          1         1         0       0          0        
 NpFC Paged        62        58         4      96         24        
 NpFD Paged         1         0         1     112        112        
 NpFR Nonp    4955799   4955799         0       0          0        
 NpFW Paged       293       293         0       0          0        
 NpFc Nonp       1486      1380       106    8480         80        
 NpFi Paged        85        84         1      40         40        
 NpFn Nonp        108        53        55    3160         57        
 NpFr Nonp    5610377   5610313        64    2560         40        
 NpFs Paged   2405573   2405512        61    4392         72        
 NpFt Nonp     309255    309255         0       0          0        
 NpFw Nonp          2         2         0       0          0        
 NpfF Paged       108        53        55    6600        120        
 Npfs Nonp          1         0         1     272        272        
 NtFA Nonp      17267     17267         0       0          0        
 NtFB Paged     55846     55836        10  242864      24286        
 NtFC Nonp          4         4         0       0          0        
 NtFD Nonp         67        67         0       0          0        
 NtFF Paged     25832     25832         0       0          0        
 NtFI Nonp      18229     18229         0       0          0        
 NtFL Nonp     115730    115722         8   83184      10398        
 NtFS Paged      9203      7730      1473  315840        214        
 NtFU Paged     34777     32889      1888  278632        147        
 NtFa Paged        45        45         0       0          0        
 NtFd Paged  34585336  34585328         8     656         82        
 NtFf Nonp          1         0         1      40         40        
 NtFs Nonp    3783189   3760236     22953  934424         40        
 NtFv Paged      6503      6503         0       0          0        
 Ntf0 Nonp          3         0         3  196608      65536        
 Ntf9 Nonp     617581    617581         0       0          0        
 NtfC Paged     84349     83770       579   69480        120        
 NtfD Paged         2         0         2     336        168        
 NtfE Paged     55966     55956        10    2000        200        
 NtfF Paged     28993     24921      4072 3811392        936        
 NtfI Nonp      19587     19583         4     160         40        
 NtfM Paged      1551      1242       309   14832         48        
 NtfR Nonp          3         0         3      72         24        
 NtfS Paged         6         0         6    2448        408        
 NtfT Nonp      25378     25373         5     440         88        
 NtfV Nonp          2         0         2     192         96        
 Ntfc Nonp          1         0         1      72         72        
 Ntff Nonp          9         0         9    1872        208        
 Ntfi Nonp     489263    489033       230   62560        272        
 Ntfl Paged      3375      3338        37    5920        160        
 Ntfm Paged       196       191         5    9664       1932        
 Ntfn Nonp     419923    396971     22952  919560         40        
 Ntfo Paged     46889     45665      1224  131368        107        
 Ntfr Nonp     129266     84649     44617 2856456         64        
 Ntfs Paged         8         1         7    2352        336        
 Ntft Nonp         18         4        14    4992        356        
 Ntfw Nonp         12        12         0       0          0        
 Nuio Nonp          2         0         2     280        140        
 Ob   Paged         1         1         0       0          0        
 ObCI Nonp         16         0        16    2176        136        
 ObCi Nonp      17834     17784        50    2800         56        
 ObDi Paged     81173     79931      1242   29808         24        
 ObDm Paged      5396      5385        11     616         56        
 ObHd Paged   1371529   1369126      2403   99264         41        
 ObNM Nonp         16         0        16    2176        136        
 ObNm Paged  30759294  30758008      1286   68984         53        
 ObSc Paged    819746    819485       261   39472        151        
 ObSq Paged 127463887 127463887         0       0          0        
 ObSt Nonp  324507558 324507557         1     224        224        
 ObjT Nonp         31         0        31   14384        464        
 Obtb Paged    880070    879630       440 1079360       2453        
 PSwt Nonp          1         0         1      32         32        
 PTIa Nonp          1         0         1    1024       1024        
 PTIw Nonp          1         0         1      48         48        
 PTPa Nonp          1         0         1     544        544        
 PTPc Nonp          1         0         1    4008       4008        
  PX2 Nonp          1         0         1    2008       2008        
  PX3 Nonp          2         0         2    1200        600        
  PX5 Nonp          2         0         2     144         72        
  PX9 Nonp          2         0         2     224        112        
  PXa Nonp          2         2         0       0          0        
  PXb Nonp          2         0         2    1280        640        
  PXc Nonp          2         2         0       0          0        
  PXd Nonp          2         0         2     688        344        
  PXg Nonp          2         0         2     144         72        
  PXh Nonp          2         0         2     256        128        
  PXl Nonp          1         0         1    2008       2008        
 ParL Paged        10         4         6     336         56        
 ParP Nonp          3         0         3      88         29        
 PciB Nonp        117        78        39   20960        537        
 PlBd Nonp          2         0         2    4192       2096        
  Pmn Nonp          2         0         2  270336     135168        
 Pmn1 Nonp    8466036   8341513    124523 10958032         88        
 Pmn2 Nonp    3489523   3489523         0       0          0        
 Pmn3 Nonp     120058    120058         0       0          0        
 Pmn5 Nonp       6543      6543         0       0          0        
 Pmn6 Nonp       6543      6543         0       0          0        
 Pmn7 Nonp      12828     12825         3     144         48        
 Pmn8 Nonp      12652      6326      6326 17826672       2818        
 Pmn9 Nonp     100578    100578         0       0          0        
 PmnA Nonp     100578    100578         0       0          0        
 PmnB Nonp     100578    100578         0       0          0        
 PmnD Nonp    7409194   7409194         0       0          0        
 PmnE Nonp     990557    990557         0       0          0        
 PmnG Nonp          2         2         0       0          0        
 PmnH Nonp    1779901   1779901         0       0          0        
 PmnI Nonp     121776    121776         0       0          0        
 PmnJ Nonp    2224708   2224708         0       0          0        
 PmnM Nonp       7117      7117         0       0          0        
 Pmnb Nonp          6         2         4     160         40        
 PnPi Nonp          1         0         1      80         80        
 PoSL Paged         2         0         2      32         16        
 PooL Nonp         16         0        16  131072       8192        
 Pool Nonp          3         1         2  192512      96256        
 Port Nonp     967104    966575       529   16928         32        
 Pp   Nonp       8033      8033         0       0          0        
 PpEB Nonp          2         1         1     296        296        
 PpEE Paged      8345      8345         0       0          0        
 PpEL Nonp          1         0         1      88         88        
 PpRb Nonp          2         2         0       0          0        
 PpUB Nonp          2         1         1     144        144        
 PpWI Nonp       8311      8311         0       0          0        
 Ppcr Nonp          3         3         0       0          0        
 Ppdd Paged       291       291         0       0          0        
 Ppen Nonp        146       146         0       0          0        
 Ppin Paged        50        49         1      40         40        
 Ppio Paged     10135     10132         3     288         96        
 Ppre Paged      2251      2075       176   19632        111        
 Pprl Paged         9         9         0       0          0        
 Ppsu Paged       918       626       292   14296         48        
 Prcr Nonp         19         3        16     512         32        
 Proc Nonp     439953    439786       167  110888        664        
 PsEx Nonp     102775    102775         0       0          0        
 PsIm Paged     35099     34916       183    4392         24        
 PsLd Nonp          2         2         0       0          0        
 PsQb Nonp        100        86        14    1008         72        
 PsTp Paged    529962    528188      1774   42576         24        
 Psap Nonp     982014    982014         0       0          0        
 Psta Nonp          2         0         2      32         16        
 Qpcf Nonp          3         0         3     264         88        
 Qpct Nonp          5         0         5     560        112        
 Qpfd Nonp          2         0         2      48         24        
 Qphf Nonp          4         0         4     304         76        
 Qppd Nonp          6         0         6     176         29        
 Qpph Nonp         12         0        12     416         34        
 Qppi Nonp          1         0         1      40         40        
 Qppt Nonp          1         0         1     392        392        
 Qprz Nonp         10         0        10     240         24        
 RBd1 Nonp          1         1         0       0          0        
 RBd2 Nonp          1         1         0       0          0        
 RBde Nonp          1         1         0       0          0        
 RBev Nonp          1         0         1      88         88        
 RBrg Nonp          1         0         1     120        120        
 RBtw Nonp          1         1         0       0          0        
 REMP Nonp          2         0         2     176         88        
 RRle Paged      5713      4894       819   39312         48        
 RceT Nonp          1         0         1  131072     131072        
 ReEv Nonp      14055      9354      4701  112824         24        
 ReSe Nonp       9930      7163      2767   88544         32        
 ReTa Nonp      26183     21515      4668  159584         34        
 Regm Paged     27569     27560         9     288         32        
 Rqrv Paged     70500     70500         0       0          0        
 RsfD Nonp          1         0         1      64         64        
 Rx?? Paged         2         2         0       0          0        
 RxBm Nonp        136       136         0       0          0        
 RxCa Nonp          2         0         2      64         32        
 RxCc Nonp       7290      7286         4     792        198        
 RxCd Nonp       2072      2072         0       0          0        
 RxCt Nonp          2         0         2     176         88        
 RxFc Paged      2584      2578         6    3864        644        
 RxIr Nonp      19825     19819         6    5424        904        
 RxLL Paged       178       178         0       0          0        
 RxMs Nonp        226       225         1    1096       1096        
 RxMx Paged         4         1         3     264         88        
 RxNc Paged      1091      1075        16    1128         70        
 RxNf Nonp       2096      2094         2     528        264        
 RxNm Nonp        551       551         0       0          0        
 RxNr Nonp       1140      1133         7    4072        581        
 RxSC Nonp       2262      2262         0       0          0        
 RxSc Nonp       1115      1108         7    2280        325        
 RxVn Nonp       1147      1139         8    1936        242        
 RxWq Nonp       1952      1952         0       0          0        
 Rxbw Nonp       3513      3513         0       0          0        
 SAV  Paged        42        30        12     384         32        
 SMBi Nonp        155       141        14   45448       3246        
 SWbr Paged         1         0         1     104        104        
 SWda Paged         1         0         1      40         40        
 SWdr Paged         2         0         2     272        136        
 SWfd Nonp          1         0         1     216        216        
 SWid Paged         1         0         1      88         88        
 SWki Paged         3         3         0       0          0        
 SWre Nonp          1         1         0       0          0        
 SaCf Paged         3         2         1      16         16        
 SaDC Paged        99         0        99  368896       3726        
 SaEI Paged         2         0         2     384        192        
 SaEa Paged    720564    720539        25  471984      18879        
 SaEb Paged        72        72         0       0          0        
 SaEc Nonp         64        56         8     384         48        
 SaEd Paged     16044     16044         0       0          0        
 SaEe Paged  40985606  40984690       916 34487496      37650        
 SaFO Nonp          1         0         1    2120       2120        
 SaFb Paged      1422      1422         0       0          0        
 SaHc Nonp    2849294   2847043      2251  108048         48        
 SaIc Nonp          4         0         4    1152        288        
 SaNc Paged         2         0         2      64         32        
 SaPM Paged         1         0         1      24         24        
 SaPV Paged         1         0         1      64         64        
 SaPa Paged   2869938   2869930         8  299024      37378        
 SaPc Paged    130481    130481         0       0          0        
 SaRe Nonp       3293      3248        45    5616        124        
 SaSc Nonp     612695    590989     21706 2778368        128        
 SaSe Paged  53161050  53161049         1     224        224        
 SaSl Nonp          8         7         1    2120       2120        
 SaSm Paged     16043     16043         0       0          0        
 SaTc Paged     16049     16049         0       0          0        
 SaUM Paged    130481    130481         0       0          0        
 Sa_C Paged         1         0         1     160        160        
 Sa_O Paged        70        70         0       0          0        
 Sa_S Paged         8         8         0       0          0        
 Sa_s Paged   1367342   1367337         5     392         78        
 Sat2 Paged         8         8         0       0          0        
 Sc?? Nonp          1         0         1      16         16        
 ScB1 Nonp          2         2         0       0          0        
 ScB2 Nonp          2         2         0       0          0        
 ScB4 Nonp          4         0         4     360         90        
 ScB5 Paged         2         2         0       0          0        
 ScC1 Paged         3         1         2     240        120        
 ScC7 Nonp          8         7         1      32         32        
 ScC8 Paged         1         1         0       0          0        
 ScC9 Nonp       3013      3009         4     320         80        
 ScCE Nonp       3204      3204         0       0          0        
 ScCF Nonp          1         0         1      88         88        
 ScCI Nonp       3254      3253         1      32         32        
 ScCM Nonp          2         2         0       0          0        
 ScCP Nonp          7         7         0       0          0        
 ScCS Nonp       3253      3253         0       0          0        
 ScCc Nonp         12        12         0       0          0        
 ScCs Paged         1         0         1      48         48        
 ScDA Nonp          1         1         0       0          0        
 ScDC Nonp          1         1         0       0          0        
 ScDM Nonp          2         2         0       0          0        
 ScDN Paged         3         3         0       0          0        
 ScDS Nonp        135       135         0       0          0        
 ScDa Nonp          3         3         0       0          0        
 ScDg Paged         3         2         1      40         40        
 ScDp Nonp          8         8         0       0          0        
 ScDs Nonp          1         0         1      32         32        
 ScFi Nonp          2         2         0       0          0        
 ScFs Nonp          2         0         2     208        104        
 ScFt Nonp          5         0         5    4280        856        
 ScIO Nonp         13        13         0       0          0        
 ScLA Nonp          1         1         0       0          0        
 ScLF Nonp       8273      8273         0       0          0        
 ScLM Nonp          2         0         2     192         96        
 ScLq Nonp          2         0         2     352        176        
 ScPA Paged         1         0         1      40         40        
 ScPC Nonp          2         0         2    3952       1976        
 ScPD Nonp     189851    189842         9    4392        488        
 ScPG Nonp          1         0         1      16         16        
 ScPI Nonp          3         0         3     288         96        
 ScPR Paged         3         0         3     392        130        
 ScPT Paged         1         0         1     112        112        
 ScPV Paged         1         0         1      16         16        
 ScPd Paged        16        16         0       0          0        
 ScPh Nonp          1         0         1      72         72        
 ScPi Nonp          1         1         0       0          0        
 ScPm Nonp         20        20         0       0          0        
 ScPq Nonp          2         0         2     296        148        
 ScPr Nonp          2         0         2     224        112        
 ScPu Paged        11        11         0       0          0        
 ScPv Nonp          1         1         0       0          0        
 ScPw Nonp          4         0         4     576        144        
 ScPy Paged         2         2         0       0          0        
 ScRV Nonp          2         0         2      80         40        
 ScRi Nonp          8         8         0       0          0        
 ScRp Nonp          5         0         5    4576        915        
 ScRt Paged         3         2         1      40         40        
 ScTL Nonp          1         0         1    2040       2040        
 ScVk Nonp          1         1         0       0          0        
 ScVs Paged         1         1         0       0          0        
 ScpP Nonp          2         0         2     336        168        
 Scs$ Nonp          1         0         1      72         72        
 Sdba Paged    866084    865932       152   13104         86        
 Se   Nonp          1         1         0       0          0        
 SeAc Nonp      18453     18453         0       0          0        
 SeAl Paged         5         5         0       0          0        
 SeCL Nonp         11         0        11     880         80        
 SeDb Paged      5385      5385         0       0          0        
 SeFS Paged         1         0         1      16         16        
 SeHa Paged      5385      5385         0       0          0        
 SeLS Paged         1         0         1      72         72        
 SeLs Paged     18462     18445        17     544         32        
 SeLu Paged    796460    796460         0       0          0        
 SeLw Paged     18385     18385         0       0          0        
 SeOt Paged       179       179         0       0          0        
 SePa Nonp  144204606 144204442       164   22448        136        
 SePr Paged     51223     51220         3     104         34        
 SeSa Paged     37029     37029         0       0          0        
 SeSc Paged  41545852  41545851         1      56         56        
 SeSd Nonp      17157     17150         7     816        116        
 SeSi Paged   2453803   2453775        28     664         23        
 SeTI Paged        29        29         0       0          0        
 SeTa Paged     37029     37029         0       0          0        
 SeTd Nonp    7929755   7929347       408   26112         64        
 SeUs Paged  19014766  19014766         0       0          0        
 Sect Paged  12119850  12118804      1046   91152         87        
 Sema Nonp    2056999   2055121      1878  105472         56        
 Senm Nonp         10        10         0       0          0        
 Sev0 Nonp         22         0        22    1408         64        
 Sev2 Paged  15617466  15617130       336   35832        106        
 Sev4 Nonp          1         0         1      64         64        
 Sev6 Nonp     439953    439784       169   29744        176        
 Sev9 Paged        43        43         0       0          0        
 SevA Paged    486887    485609      1278   92016         72        
 SevB Nonp          1         0         1    2120       2120        
 SevC Paged        26         0        26     832         32        
 SevD Nonp     153776    153776         0       0          0        
 SevE Nonp         42         0        42    2688         64        
 SevF Nonp          1         0         1    2120       2120        
 SevH Nonp         27         0        27     864         32        
 SevI Paged   1319934   1319857        77    4960         64        
 SevN Nonp          1         0         1     144        144        
 SevO Nonp          1         0         1     160        160        
 SevQ Nonp          1         0         1   16384      16384        
 SevS Nonp          3         2         1     120        120        
 SevU Nonp          1         0         1    2120       2120        
 SevV Paged         1         0         1     352        352        
 SevX Nonp     439953    439784       169   20280        120        
 Sevz Paged        80        80         0       0          0        
 SmAd Nonp       2176      2175         1     128        128        
 SmDO Nonp       1034      1031         3     216         72        
 SmDc Paged       618       618         0       0          0        
 SmEc Nonp          1         0         1      64         64        
 SmFc Nonp       1369      1369         0       0          0        
 SmKs Paged      1818      1818         0       0          0        
 SmMa Nonp       1088      1087         1     272        272        
 SmMm Nonp       3340      3315        25   17984        719        
 SmMs Nonp        642       642         0       0          0        
 SmMt Nonp       2202      2192        10     520         52        
 SmNr Paged      2246      2241         5     192         38        
 SmQP Paged      1942      1942         0       0          0        
 SmRw Nonp        545       545         0       0          0        
 SmRx Nonp       1212      1212         0       0          0        
 SmSS Nonp       1970      1970         0       0          0        
 SmSr Nonp       1434      1428         6     168         28        
 SmTp Nonp       1111      1106         5     280         56        
 SmTr Paged      4995      4995         0       0          0        
 SmVc Nonp       4356      4355         1     136        136        
 SmVr Nonp       3332      3327         5    1240        248        
 Strg Nonp         10        10         0       0          0        
 Symb Paged      6406      6238       168   13440         80        
 Symt Paged      6406      6238       168    9112         54        
 TAPI Nonp          2         0         2     176         88        
 TC1R Nonp         21        21         0       0          0        
 TC2r Nonp          6         4         2      48         24        
 TCI1 Nonp     323940    323940         0       0          0        
 TCI4 Nonp          1         0         1     408        408        
 TCI5 Nonp          1         0         1     264        264        
 TCI8 Nonp          1         1         0       0          0        
 TCI9 Nonp          1         1         0       0          0        
 TCIV Nonp          2         0         2     272        136        
 TCIY Nonp       1877      1877         0       0          0        
 TCIZ Nonp         24         0        24    1224         51        
 TCIa Nonp          1         0         1     104        104        
 TCIi Nonp        416       416         0       0          0        
 TCIj Nonp        416       416         0       0          0        
 TCIk Nonp          1         1         0       0          0        
 TCIl Nonp          1         1         0       0          0        
 TCIm Nonp          1         0         1      64         64        
 TCIo Nonp          2         2         0       0          0        
 TCIp Nonp          3         3         0       0          0        
 TCIq Nonp          1         1         0       0          0        
 TCIr Nonp          1         0         1     200        200        
 TCIs Nonp       1939      1939         0       0          0        
 TCIt Nonp          2         0         2    3040       1520        
 TCIu Nonp          1         1         0       0          0        
 TCIv Nonp          1         0         1     192        192        
 TCIw Nonp          1         0         1     696        696        
 TCIy Nonp          2         0         2      96         48        
 TCPA Nonp      27549     27055       494  181792        368        
 TCPB Nonp     102173    102133        40   60448       1511        
 TCPC Nonp      31144     22533      8611  723464         84        
 TCPS Nonp          2         2         0       0          0        
 TCPT Nonp      15842     14774      1068  436816        409        
 TCPX Nonp        341       317        24    2952        123        
 TCPY Nonp        348       324        24    3504        146        
 TCPa Nonp        672       665         7     224         32        
 TCPc Nonp     198720    189628      9092  436416         48        
 TCPi Nonp         15        13         2     384        192        
 TCPp Nonp          7         0         7   28672       4096        
 TCPr Nonp     709108    707491      1617  104904         64        
 TCPs Nonp       2866      2865         1      48         48        
 TCPt Nonp    2362691   2362652        39 2452872      62894        
 TCPu Nonp          4         4         0       0          0        
 TChc Nonp         11         0        11   45056       4096        
 TChe Nonp         16         0        16   65536       4096        
 TChi Nonp         16         0        16   65536       4096        
 TCht Nonp        145       129        16   65536       4096        
 TChu Nonp         16         0        16   65536       4096        
 TCiA Nonp      95480     95343       137   10960         80        
 TCiJ Nonp          1         0         1      40         40        
 TCiK Nonp          1         0         1      40         40        
 TCiN Nonp     888750    888750         0       0          0        
 TCiQ Nonp       5855      5771        84    6048         72        
 TCiR Nonp          1         1         0       0          0        
 TCiS Nonp          1         0         1      24         24        
 TCiV Nonp     307545    307545         0       0          0        
 TCiW Nonp          1         1         0       0          0        
 TCiX Nonp          2         2         0       0          0        
 TCiY Nonp          1         1         0       0          0        
 TCij Nonp          1         0         1     584        584        
 TD   Nonp        146       123        23    4376        190        
 TDIa Nonp         25        19         6     528         88        
 TDIc Nonp          8         0         8     640         80        
 TDId Nonp          8         0         8     472         59        
 TDIe Nonp          2         0         2     192         96        
 TDIf Nonp          6         0         6     432         72        
 TDIg Nonp          5         0         5     144         28        
 TDIj Nonp          5         5         0       0          0        
 TDIk Nonp          4         0         4    2536        634        
 TDIu Nonp          2         0         2     248        124        
 TDIv Nonp          2         0         2      32         16        
 TOBJ Nonp        513       494        19    3528        185        
 TSlc Paged         4         3         1      32         32        
 TSmc Paged        53        41        12    6368        530        
 TSwd Nonp         18        15         3     200         66        
 Temp Nonp         21        21         0       0          0        
 Thre Nonp    1427441   1425459      1982 1236768        624        
 Time Nonp       8592      8530        62   11520        185        
 Toke Paged   7929755   7929347       408  380360        932        
 Tun4 Paged       108       108         0       0          0        
 TunP Paged    433109    433009       100   27904        279        
 UlAO Nonp          1         0         1      88         88        
 UlAP Nonp          1         0         1      72         72        
 UlBS Nonp          1         0         1    2184       2184        
 UlCA Nonp          1         0         1    2184       2184        
 UlCB Nonp          1         0         1      24         24        
 UlCC Nonp          2         0         2     304        152        
 UlCE Paged         5         0         5     512        102        
 UlCH Paged         4         0         4     320         80        
 UlCJ Nonp          1         0         1     184        184        
 UlCK Nonp          1         0         1    2184       2184        
 UlCL Paged         1         0         1     592        592        
 UlCO Nonp       1344       320      1024  622592        608        
 UlCP Paged         1         0         1    8192       8192        
 UlDR Paged        16        15         1      24         24        
 UlEB Nonp          1         0         1    2184       2184        
 UlEP Nonp          1         0         1     296        296        
 UlFP Nonp          1         0         1      48         48        
 UlFT Nonp          1         0         1     104        104        
 UlFU Nonp         51         0        51  177384       3478        
 UlFW Nonp          1         0         1    2184       2184        
 UlHR Nonp         36         1        35   47064       1344        
 UlHT Paged         1         0         1 4198400     4198400        
 UlIC Nonp          1         0         1    2184       2184        
 UlIR Nonp          1         0         1    2184       2184        
 UlLL Nonp          1         0         1    2184       2184        
 UlLS Nonp          1         0         1    2184       2184        
 UlLT Nonp          1         0         1    2184       2184        
 UlNP Nonp          3         0         3    2608        869        
 UlOT Nonp         31         0        31  126976       4096        
 UlPS Paged         1         0         1      32         32        
 UlRD Paged         3         3         0       0          0        
 UlRP Nonp        949       920        29   18312        631        
 UlRR Nonp        453       453         0       0          0        
 UlSD Paged         2         2         0       0          0        
 UlSl Paged         1         1         0       0          0        
 UlTD Nonp          1         0         1      80         80        
 UlTT Nonp         34         0        34    2448         72        
 UlUL Paged         2         2         0       0          0        
 UlUS Paged         1         1         0       0          0        
 UlWI Nonp          1         0         1     280        280        
 Umrx Nonp          1         0         1     200        200        
 User Nonp         15         6         9     576         64        
 Usfd Nonp          1         0         1    8192       8192        
 Usla Nonp         15         6         9    1008        112        
 Uspo Nonp         15        12         3     120         40        
 Uspp Nonp          5         2         3     120         40        
 Ussy Nonp        118        62        56    2040         36        
 VDM  Nonp          2         2         0       0          0        
 Vad  Nonp   19443919  19434430      9489  455472         48        
 VadF Nonp          3         1         2      64         32        
 VadS Nonp    9399230   9394141      5089  162848         32        
 Vadl Nonp    3595131   3592280      2851  182464         64        
 Vga  Paged         2         1         1    8192       8192        
 VoSb Nonp          2         0         2   32768      16384        
 VoSc Nonp          5         0         5     520        104        
 VoSr Paged         2         2         0       0          0        
 VoSs Nonp          4         4         0       0          0        
 VoSt Nonp          1         0         1     120        120        
 Vpb  Nonp          8         0         8     768         96        
 Vprt Nonp          7         2         5     200         40        
 VraP Nonp          1         0         1      40         40        
 WMca Nonp          1         1         0       0          0        
 Wait Nonp   10835766  10835707        59   16144        273        
 WanI Nonp          1         0         1     112        112        
 WanJ Nonp          4         0         4    1344        336        
 WanM Nonp          5         0         5     464         92        
 WanN Nonp          1         0         1     680        680        
 WanO Nonp          1         0         1    2064       2064        
 WanS Nonp          2         0         2     144         72        
 Wind Nonp         11         2         9    1296        144        
 WmDS Paged         2         0         2   16384       8192        
 WmGE Paged         1         0         1   49152      49152        
 WmIS Paged         1         0         1  118784     118784        
 WmMR Paged         1         0         1     544        544        
 WmiD Nonp         61        61         0       0          0        
 WmiG Nonp      59885     59835        50   11200        224        
 WmiI Paged         1         1         0       0          0        
 WmiR Nonp         89        13        76    4864         64        
 Wmip Nonp        195        46       149    3576         24        
 Wmit Nonp         38        37         1    4096       4096        
 Wmiw Nonp         19        19         0       0          0        
 Wrpa Nonp          2         0         2     720        360        
 Wrpc Nonp          1         0         1      72         72        
 Wrpi Nonp          1         0         1     120        120        
 Wrpr Nonp          1         1         0       0          0        
 Wrps Nonp          6         4         2     128         64        
 aEoP Nonp          1         0         1     672        672        
 cbuf Paged       107       104         3      72         24        
 idle Nonp          1         0         1     104        104        
   rx Nonp          2         0         2     832        416        
 sidg Nonp         10         4         6     144         24        
 svtM Nonp          8         7         1     576        576        
 svto Nonp         22        19         3     120         40        
 svty Nonp         14        12         2     528        264        
 svtz Nonp         14        12         2     288        144        
 v33v Nonp          5         1         4   41224      10306        
 vPrt Nonp          3         2         1      32         32        
 vmmp Nonp         48        48         0       0          0        
 vskd Nonp          4         4         0       0          0        
 vskg Nonp    3652128   3652125         3    8240       2746        
 vsks Nonp         16        12         4    1136        284        
 xSMB Paged      3106      3106         0       0          0        
 xvnP Nonp          8         7         1      24         24        
 xvnS Paged         8         8         0       0          0
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Forum statistics

Threads
1,214,922
Messages
6,122,281
Members
449,075
Latest member
staticfluids

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top