{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Analyser","Settings","Release Notes"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":2,"defined_names":39,"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":"Analyser","index":0,"n_rows":60,"n_cols":4,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["V6.1",null,"2019-07-19"]
[]
[]
[]
[]
[]
[]
[]
["Output"]
["GRAPHS","ALL","CHARTS","Specify output option for generated graphs (see user guide)"]
["INTERVALS",1,999999,"FIRST and LAST time intervals to process"]
["TIMES",null,null,"FIRST and LAST time values to process (note - overrides INTERVALS settings) - see User Guide for details"]
["MERGE","NO","NOTOP","Specify YES to merge the input files and TOP if you want to merge the TOP and UARG sections"]
["PIVOT","YES",null,"Specify YES to generate a Pivot chart using the parameters on the Settings sheet"]
["SCATTER","YES",null,"Indicates if Scatter charts shall be included.  Applies to TOP CPU% by PID chart only.  This option is to avoid Excel 2013 crash."]
["BIGDATA","YES",null,"Set to YES if your data has > 1048576 rows or large lines (up to 32K.)  Set this to NO to improve performance but the Analyzer will fail if a large line is encountered and data will also be truncated at 1048576 rows."]
["ESS","YES",null,"Set to NO to prevent additional ESS analysis (conserves memory)"]
["SYNCAXIS","YES",null,"On graphs that show Avg/Wavg on Y1 and Min/Max on Y2 the Maximum scales will be set to the same value"]
["SHOWMACPROGRESS","YES",null,"On a MAC refreshing the screen to show progress in status bar will make things slower!"]
["SHOWLINUXCPUUTIL","NO",null,"When analyzing Linux data a value of YES indicates that all of the CPUUTILnnn sheets will be included.  CPUUTIL_ALL will always be included."]
["FILELIST",null,null,"Name of file containing a list of nmon files to be processed (blank = dialog)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Avg.",{"$f":"AVERAGE(B2:B56)","v":1}]
["WAvg.",{"$f":"IF(B58=0,0,MAX(SUMPRODUCT(B2:B56,B2:B56)/SUM(B2:B56)-B58,0))","v":0}]
["Max.",{"$f":"ABS(MAX(B2:B56)-B58-B59)","v":0}]

{"sheet":"Settings","index":1,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[18,0,18,1],[2,1,2,3],[24,1,24,3],[20,1,20,2]]}
["Batch"]
["REPROC","YES","Set to NO to prevent reprocessing of files in multi-file mode "]
["OUTDIR",null,null,null,"Directory in which to store output files (blank = same as input file)"]
[]
["Formatting"]
["BBBFont","Courier","Name of fixed pitch font used for formatting BBB sheets"]
["GWIDTH",0,"GHEIGHT",{"$f":"+GWIDTH/2.4","v":0},"Graph width and height in points (set to 0 for dynamic sizing)"]
["LIST","CPU_ALL,DISKBUSY,ESS*,EMC*,FAST*,LPAR,MEM*,NET,PAGE,PROC,TOP"]
["NOLIST","KEEP",null,"Set to DELETE to delete all sheets that are not in LIST above"]
["CPUmax",0,null,"The maximum number of CPU sheets tabs to create - set to zero for optimum"]
["REORDER","YES",null,"Set to NO to disable reordering of sheets after analysis"]
["TOPDISKS",0,null,"Max. number of hdisks/vpaths to appear on graphs - set to 0 for all hdisks"]
["XToD","hh:mm","Format for x-Axis on Time-of-Day graphs - can include date (e.g. dd-mmm-yy)"]
["SORTDEFAULT","YES","This setting indicates if the 1st graph on 'default' sheets (ones not handled else where by the Analyzer) are sorted.  Note: If Yes, this will also reorder the columns. "]
[]
["Pivot Chart",null,"Specify parameters for the Pivot chart (default settings require the UARG sheet to be present)"]
[null,null,"SHEET","PAGE","ROW","COLUMN","DATA","FUNCTION"]
[null,null,"TOP","PID","Time","Command","IntervalCPU%","SUM"]
["Printing"]
["COPIES",1,"LSCAPE","NO","Specify #copies and whether to print using Landscape page orientation"]
["PRINTER","PREVIEW",null,"Set to DEFAULT or specify a printer name for batch operation"]
[]
["Web"]
["PNG","YES","SUBDIR","YES","Set SUBDIR to NO to get PNG/GIF files into the same directory as main HTM file"]
["WEBDIR",null,null,null,"Directory in which to store HTML files (blank = same as input file)"]
[]
["National Language Settings"]
["DELIM",",","Delimiter used in .csv file (see Note 1)"]
[]
[]
["Notes"]
["1. This is only provided for backwards compatibilty with files that have been converted using nmon2csv - set to \";\" if required"]

{"sheet":"Release Notes","index":2,"n_rows":145,"n_cols":5,"rows_kept":145,"cut":false,"hidden":false,"merged":[]}
["V6.1","2019-07-19",null,null,"Ron McCargar (mccargar@us.ibm.com)"]
["1.","Fixed a failure if no hdisks exist in line 1 of nmon disk output (only power)"]
[]
["V6.0","2019-02-11",null,null," "]
["1.","Work around added for overflow error on Mac OS when trying to chart graphs on several sheet like DISK_SUMM.  Appears to be a bug with Excel on Mac OS only."]
[null,"The graph may appear at the top instead of the bottom of the sheet due to this bug."]
["2.","On Mac OS the graphs were drawn too wide, made a change so by default they are drawn to consume a more reasonable amount of space similar to how it is done on Windows."]
[]
["V5.6","2018-11-29",null,null," "]
["1.","Fixed graph titles/descriptions for DISKAVGRIO, DISKAVGWIO: they were wrong per AIX documentation here:"]
[null," "]
["V5.5","2018-08-29",null,null," "]
["1.","If > 150 disks were found in the data, then the DISK_SUMM metrics were calculated incorreclty."]
[]
["V5.4","2017-10-13",null,"Note: These updates are thanks to Torsten Wendlan,"]
["1.","When running on MAC, showing progress during the run is much faster now.  THE SHOWMACPROGRESS option now defaults to YES. "]
[null,"Note: Using SHOWMACPROGRESS = YES will slow execution somewhat (maybe 30-50% slower) but the benefit is you will clearly know that the process is not \"hung\"."]
["2.","On MACs, fixed batch processing of multiple files related to use of : instead / for subdirectories."]
["3.","On Macs, fixed issues relating to merging of multiple files because of usage of : instead of /"]
[]
["V5.3","2017-09-22"]
["1.","Fix issues dealing with file paths on MAC thanks to help from Torsten Wendlan"]
[]
["V5.22","2017-09-18"]
["1.","Remove any colons that may exist in the filename when doing a merge"]
[]
["V5.21","2017-07-13"]
["1.","Don't incluide the filepath when saving the .nmon file to avoid problems with Excel 2016"]
[]
["V5.2","2017-02-01"]
["1.","Merge option when running on Windows broken with V5.13 fixed."]
[]
["V5.13","2017-01-13"]
["1.","Added support to use the Merge option when running on a MAC with Excel 2011"]
[]
["V5.12","2016-10-06"]
["1.","Fix issues when running on a Mac with Excel 2016"]
[]
["V5.1","2016-06-14"]
["1.","If Merge = Yes then the 1st files data would appear twice incorrectly."]
[]
["V5.05","2016-05-05"]
["1.","The Avg and Max CPU% on the SYS_SUMM column was being calculated incorrectly."]
[]
["V5.04","2016-04-07"]
["1.","The default save format used on a Mac may not have been set correctly in some cases."]
[]
["V5.03","2016-03-15"]
["1.","If importing multiple .nmon files that contain multiple \"AAA,x86,\" records popup errors would be shown to the user."]
[]
["V5.02","2016-02-26"]
["1.","Fixed a problem when trying to import very large .nmon files it may fail."]
["2.","Added extra checking for garbage lines that could stop the analyzer from completing the import."]
[]
["V5.01","2016-02-23"]
["1.","On the AAA sheet renamed the \"elapsed\" value given to \"Analysis time\" (the elapsed time it took Excel to analyze the nmon file)"]
["2.","Enabling PIVOT charts would crash the analyzer on Excel 2010 and higher and has been fixed.   (Analyser - PIVOT = YES)"]
["3.","On the Analyser's Settings - DELIM value the user can now specify any value desired."]
["4. ","In ProcessFile() added a check for EOF before doing the import to possibly avoid an error."]
["5.","Graphs that show Avg/Wavg/Max will now show Avg/Wavg on the Y1 axis and Min/Max as lines on the Y2 axis.  Also if the Analyzer Output option SyncAxis is YES then the Y1 and Y2 maximum scale values will be the same."]
["6. ","Several graphs were not sorted previously based on the Analyser's Settings - SORTDEFAULT value but are now. "]
["7.","Added On Error Resume Next in a few spots in order to be better able to analyze huge data sets without failing prematurely."]
["8.","Added support to run nmon Analyzer on a Mac with Excel 2011 or higher.  Please note the following limitations:  Pivot charts don't work, Merge option doesn't work."]
["9.","Added new options SHOWMACPROGRESS and SHOWLINUXCPUUTIL"]
[]
["V4.7","2015-09-23"]
["1.","Added a check for Power 8 and SMT mode 8.  In previous versions no check exists which defaults the number of CPUs shown to 2 on the CPU_SUMM sheet."]
[]
["V4.6","2015-06-30"]
["1.","If an INTERVAL range was specified the CPU_SUMM sheet would contain no data."]
[]
["V4.5b","2015-06-16"]
["1.","If the SORTDEFAULT setting was set to YES then sheets like NETPACKET would incorrectly display a SortKey value on the graph."]
[]
["V4.5a","2015-06-04"]
["1.","If the LPAR sheet didn't exist, then SYS_SUMM graph would not display CPU% as expected."]
[]
["V4.5","2015-05-19"]
["1.","On the SYS_SUMM sheet if the LPAR sheet exists, the CPU% column will be now what it was back with analyzer version 3.4a or Avg CPU% \"=M4/LPAR!C2*100.\"  and Max CPU% = \"=M4/LPAR!C2*100.\".   "]
[]
["V4.4","2015-05-01"]
["1.","If the nmon data contained ERROR tags, the resulting ERROR sheet would incorrectly list thousands of columns at the end containing 'N/A'"]
[]
["V4.3","2015-04-27"]
["1.","Added a new setting called SORTDEFAULT.  This setting indicates if the 1st graph on 'default' sheets (ones not handled else where by the Analyzer) are sorted.  Note: If Yes, this will also reorder the columns. "]
["2.","Added support for the CPU_ALL, CPUnnn Steal% column that is being added to nmon for Linux."]
[]
["V4.2","2015-03-17"]
["1.","On the LPAR sheet the last graph was not showing all values (other lpars, pool idle) like it should have been."]
[]
["V4.1","2015-03-11"]
["1.","On the LPAR sheet on the 1st graph the Unfolded VPs value was incorrectly removed."]
[]
["V4.0a","2015-02-18"]
["1.","Support for checking for EMC/PowerPath disks was broken.  The EMC graphs are available again."]
["2.","The EMC check problem caused the disk graphs showing Avg, Wavg, Max to not be sorted with the highest Avg + Wavg first."]
["3.","Many additional sheets now have their Avg, Wavg, Max graphs sorted with the highest Avg + Wavg first (FC*, etc)"]
[]
["V4.0","2015-02-17"]
["1.","The previous version did not work with Excel 2007 or Excel 2010."]
["2. ","The elapsed time value produced on AAA was incorrect previously.  It did not include the time to open the file(s) and sort the data."]
["3,","Added a new option on the Analyser sheet called BIGDATA.  Use this if you have large lines or > 1048576 rows."]
["4.","The analyzer would fail on Excel 2007 if > 1048576 rows were encountered.  Use BIGDATA=YES.   "]
["5. ","The maximum allowed rows per .nmon file is now unlimited (based on available Excel/PC memory)"]
["6.","The SORTINP setting has been removed.  Data is now always sorted."]
["7.","On the SYS_SUMM sheet added the following additional fields from the LPAR tab (it it exists):  Other LPARs, Pool CPUs, Entitled, Weight"]
["8.","On the SYS_SUMM sheet the CPU% values were wrong and have been changed to the sum of users% + Sys% for each line.  "]
["9.","On the LPAR tab the 1st and 3rd graphs showed incorrect values."]
[]
["V3.5e:","2015-02-14"]
["1.","Updated nmon analyzer to check for either hdiskpower, emcpower or just power when determining if EMC data is present. "]
[]
["V3.5d:","2015-02-13"]
["1.","Fixed several errors due to the increase in the number of columns.  If the files contained certain types of data (IP, LAN), then the analysis would fail."]
["2.","Analysis is faster now and supports any number of columns up to the Excel maximum of 16684.  On large data sets (> 10 MB) you most likely will require 64-bit Windows however and a minimum of 8 GB of RAM."]
[]
["V3.5c:","2015-02-13"]
["1.","Made changes to increase the ability to handle files with large amounts of data (both rows or columns)"]
["2.","Max rows has increased from 65536 per sheet to 1048576"]
["3.","Max columns has increased from 255 to 1450.  This mostly applies to NPIV and SEALICTRAFFIC sheets.  "]
["4."," Please Note: This increase will also slow down the parsing time and memory requirements considerably in some cases."]
["5.","Max size allowed for any line of nmon import data is now 32K"]
["6.","NPIV header was incorrectly shown at the bottom of the sheet previously."]
["7.","NPIV and SEALICTRAFFIC sheets will no longer show any graphs (due to potential huge size.)"]
[]
["V3.5 b:","2015-02-11"]
["1.","Fixed a bug if using the GRAPHS LIST - PICTURES option, the script would fail if LIST did not contain ZZZZ and NOLIST = DELETE."]
["2.","When using Excel 2013 with the GRAPHS - PICTURES option added error handling in OutputPics function to avoid a possible failure when determining the last row in the Charts sheet."]
[]
["V3.5 a:","2015-02-04"]
["1.","Needed to remove and recreate the Analyze nmon data button and also fixed a possible error when opening the spreadsheet related to the FILELIST parameter"]
[]
["V3.5:"]
["1.","Added SCATTER Output option (default NO) to avoid crash in Excel 2013 when building TOP CPU% by PID graph"]
[]
["V3.4 a:"]
["1.","Improved support for Excel 2007 and 2010"]
["2.","Support for 64-bit Windows"]
["3.","Ability to specify time values instead of interval numbers"]
["4.","Wildcard support in LIST "]
["5. ","Limit the overall number of CPU, PCPU and SCPU sheets generated"]
["6.   ","Add graphs for the PCPU and SCPU sheets"]
["7.","Correct handling of the DISKRXFER sheet"]
["8.","Fix a bug with the MERGE option"]
["9.","CPU_SUMM, DISK_SUMM and SYS_SUMM automatically added to LIST"]