{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["READ ME!","Example"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"READ ME!","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Example","index":1,"n_rows":17,"n_cols":64,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,2,2,8],[4,3,4,7],[11,3,11,7],[4,13,4,17],[11,13,11,17],[2,12,2,18],[2,22,2,32],[11,23,11,24],[5,23,5,24],[8,23,8,24],[11,27,11,31],[4,27,4,31],[14,37,14,38],[5,37,5,38],[2,36,2,47],[9,52,9,56],[5,52,5,56],[2,51,2,64],[4,42,4,46],[11,42,11,46],[4,59,4,63],[11,59,11,63],[13,37,13,38],[9,37,9,38],[10,37,10,38],[11,37,11,38],[12,37,12,38]]}
[]
[]
[null,null,"Input Matrix for Nearest\nCorrelation Matrix Functions",null,null,null,null,null,null,null,null,null,"Outputs for\nNearest Correlation Matrix (G02AAF)",null,null,null,null,null,null,null,null,null,"Outputs for\nNearest Factor Correlation Matrix (G02AEF)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Outputs for\nNearest Weighted Correlation Matrix (G02ABF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outputs for\nNearest Element Weighted Correlation Matrix (G02AJF)"]
[]
[null,null,null,"Input matrix",null,null,null,null,null,null,null,null,null,"Nearest correlation matrix",null,null,null,null,null,null,null,null,null,null,null,null,null,"Nearest Factor Correlation Matrix",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nearest Weighted Correlation Matrix",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nearest Weighted Correlation Matrix"]
[null,null,null,1,0.4128,0.192,0.84119999999999995,-0.93600000000000005,null,null,null,null,null,{"$f":"NAG_NCM(inputMatrix)","v":1},0.32029048856522879,0.10550107402881109,0.54351432419609558,-0.66355642586305508,null,null,null,null,null,"Inputs",null,null,null,{"$f":"NAG_factor_NCM(inputMatrix,numFactors)","v":1},0.30354297186548018,-3.7834399905793681E-4,0.57722058041159519,-0.67576801858883007,null,null,null,null,null,"Inputs",null,null,null,null,{"$f":"NAG_weighted_NCM(inputMatrix,alpha,weights)","v":1},0.18559948542212448,-0.10816190256623204,0.48482912213789309,-0.56085476712523374,null,null,null,null,null,"Inputs",null,null,null,null,null,null,{"$f":"NAG_element_weighted_NCM(inputMatrix,ElementWeights,elementalpha)","v":1},0.40843581367140608,7.5598844871649543E-2,0.3613859793233119,-0.70943691835896228]
[null,null,null,0.4128,1,-0.55000000000000004,-0.36452000000000001,-0.53,null,null,null,null,null,0.32029048856522879,1,-0.52901582751708309,-0.29230306208283274,-0.59609334032027772,null,null,null,null,null,null,null,null,null,0.30354297186548018,1,-0.15443354388093619,-0.34900993620241161,-0.67832634383177337,null,null,null,null,null,null,null,null,null,null,0.18559948542212448,1,-0.5482206925434302,-0.36240749553203377,-0.53222379557313604,null,null,null,null,null,null,null,null,null,null,null,null,0.40843581367140608,1,-0.28069206739917368,-0.36075864423701348,-0.53475579673096063]
[null,null,null,0.192,-0.55000000000000004,1,-3.5009999999999999E-2,8.7499999999999994E-2,null,null,null,null,null,0.10550107402881109,-0.52901582751708309,1,3.2494814150245882E-2,2.5700917258295319E-2,null,null,null,null,null,"k : ",2,null,null,-3.7834399905793681E-4,-0.15443354388093619,1,0.19607707473928926,0.17744681119377048,null,null,null,null,null,"alpha : ",0,null,null,null,-0.10816190256623204,-0.5482206925434302,1,-3.2239102446521492E-2,8.456207219032448E-2,null,null,null,null,null,null,null,null,"Element-wise alpha:",0.01,null,null,7.5598844871649543E-2,-0.28069206739917368,1,-3.4361858878147966E-2,4.5471041916064672E-2]
[null,null,null,0.84119999999999995,-0.36452000000000001,-3.5049999999999998E-2,1,0.45565,null,null,null,null,null,0.54351432419609558,-0.29230306208283274,3.2494814150245882E-2,1,0.24296872675328224,null,null,null,null,null,"   k = Num Factors",null,null,null,0.57722058041159519,-0.34900993620241161,0.19607707473928926,1,0.21185173454577125,null,null,null,null,null,null,null,null,null,null,0.48482912213789309,-0.36240749553203377,-3.2239102446521492E-2,1,0.45216190939397011,null,null,null,null,null,null,null,null,null,null,null,null,0.3613859793233119,-0.36075864423701348,-3.4361858878147966E-2,1,0.30698344810947498]
[null,null,null,-0.93600000000000005,-0.53,8.7499999999999994E-2,0.45565,1,null,null,null,null,null,-0.66355642586305508,-0.59609334032027772,2.5700917258295319E-2,0.24296872675328224,1,null,null,null,null,null,null,null,null,null,-0.67576801858883007,-0.67832634383177337,0.17744681119377048,0.21185173454577125,1,null,null,null,null,null,"Weights",null,null,null,null,-0.56085476712523374,-0.53222379557313604,8.456207219032448E-2,0.45216190939397011,1,null,null,null,null,null,"Element Weights",null,null,null,null,null,null,-0.70943691835896228,-0.53475579673096063,4.5471041916064672E-2,0.30698344810947498,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,1,1,1]
[null,null,null,"Eigenvalues: Input Matrix",null,null,null,null,null,null,null,null,null,"Eigenvalues: Nearest Correlation Matrix",null,null,null,null,null,null,null,null,null,"Factors",null,null,null,"Eigenvalues: Nearest Factor Correlation Matrix",null,null,null,null,null,null,null,null,null,1,null,null,null,null,"Eigenvalues: Nearest Weight Correlation Matrix",null,null,null,null,null,null,null,null,null,10,10,1,10,1,null,null,"Eigenvalues: Nearest Weight Correlation Matrix"]
[null,null,"Real : ",{"$f":"NAG_Eigenvalues_unsymmetric(inputMatrix)","v":-0.57510415492071454},2.3164920023553157,1.8252746409131269,0.27407579671952748,{"$f":"NAG_Eigenvalues_unsymmetric(inputMatrix)","v":-0.57510415492071454},null,null,null,null,"Real : ",{"$f":"NAG_Eigenvalues_symmetric(N6:R10)","v":-1.8637934338867527E-12},0.20947083845492395,1.0612100426801125,1.6023046336133426,2.1270144852534849,null,null,null,null,null,{"$f":"NAG_factor_NCM(inputMatrix,numFactors,1)","v":0.71863891017959891},0.6953834314792654,null,"Real : ",{"$f":"NAG_Eigenvalues_symmetric(AB6:AF10)","v":-5.0571734847628142E-17},0.32283261241087485,0.89303070172679244,1.6241158391013331,2.1600208467609985,null,null,null,null,null,1,null,null,null,"Real : ",{"$f":"NAG_Eigenvalues_symmetric(AQ6:AU10)","v":-3.0633090326351012E-9},0.27022806084138634,1.1044240184381635,1.5103883386119139,2.1149595851718459,null,null,null,null,null,1,1,1,10,1,null,null,{"$f":"NAG_Eigenvalues_symmetric(BH6:BL10)","v":1.980198018612887E-2},0.3994397382302371,1.0558317197464122,1.3685316665323319,2.1563948953048895]
[null,null,"Imaginary : ",0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.22827411780912996,0.67241986786391394,null,null,null,null,null,null,null,null,null,null,null,null,10,1,null,null,null,null,null,null,null,null,null,null,null,null,null,1,10,10,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.16688776111909176,-0.17301301314594614,null,null,null,null,null,null,null,null,null,null,null,null,10,1,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98265512164791169,-0.18544247598413824]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.6943923152698994E-2,-0.99963694659868463]