{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Input_Matrix_X","Target_Correlation_S","Cholesky_C","Intermediate_M","Covariance_E","Cholesky_F","Intermediate_T","Check_Correlation","Rank_T","Result_Y","Check_Correlation_Result"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input_Matrix_X","index":0,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[123567,44770,15934,13273]
[126109,45191,16839,15406]
[138713,47453,17233,16706]
[139016,47941,17265,16891]
[152213,49345,17620,18821]
[153224,49420,17859,19569]
[153407,50686,20804,20166]
[155716,52931,21110,20796]
[155780,54010,22728,20968]
[161678,57346,24072,21178]
[161805,57685,25198,23236]
[167447,57698,25393,23375]
[170737,58380,30357,24019]
[171592,60948,30779,24785]
[178881,66972,32634,25000]
[181678,68053,33117,26754]
[184381,70592,35248,27079]
[206940,72243,36656,30136]
[217092,86685,38483,30757]
[240935,87138,39483,35108]

{"sheet":"Target_Correlation_S","index":1,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[1,0.8,0.4,0]
[{"$f":"INDEX($A$1:$D$4,COLUMN(),ROW())","v":0.8},1,0.3,-0.2]
[{"$f":"INDEX($A$1:$D$4,COLUMN(),ROW())","v":0.4},{"$f":"INDEX($A$1:$D$4,COLUMN(),ROW())","v":0.3},1,0.1]
[{"$f":"INDEX($A$1:$D$4,COLUMN(),ROW())","v":0},{"$f":"INDEX($A$1:$D$4,COLUMN(),ROW())","v":-0.2},{"$f":"INDEX($A$1:$D$4,COLUMN(),ROW())","v":0.1},1]

{"sheet":"Cholesky_C","index":2,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[{"$f":"TRANSPOSE(Cholesky(Target_Correlation_S!A1:D4))","v":1},0.8,0.4,0]
[0,0.59999999999999987,-3.3333333333333465E-2,-0.33333333333333343]
[0,0,0.91590877760227241,9.7049936699578496E-2]
[0,0,0,0.93780072439484541]

{"sheet":"Intermediate_M","index":3,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[-1.92062,1.2289600000000001,-1.0085999999999999,-0.49584,null,null,null,null,{"$f":"NORMSINV(_xlfn.SEQUENCE(20,1,1,1)/21)/STDEVPA(NORMSINV(_xlfn.SEQUENCE(20,1,1,1)/21))","v":-1.9206164592722914},{"$f":"randomshuffle($A$1:$A$20)","v":0.65151000000000003},{"$f":"randomshuffle($A$1:$A$20)","v":-6.8739999999999996E-2},{"$f":"randomshuffle($A$1:$A$20)","v":-1.50709},null,"Mildenhall Sample Shuffle:",-1.92062,1.2289600000000001,-1.0085999999999999,-0.49584]
[-1.50709,-1.50709,-1.50709,0.82015000000000005,null,null,null,null,-1.5070906370129664,0.20723,-1.0085999999999999,6.8739999999999996E-2,null,null,-1.50709,-1.50709,-1.50709,0.82015000000000005]
[-1.2289600000000001,1.92062,0.82015000000000005,-0.65151000000000003,null,null,null,null,-1.2289644820909671,0.82015000000000005,-0.49584,0.82015000000000005,null,null,-1.2289600000000001,1.92062,0.82015000000000005,-0.65151000000000003]
[-1.0085999999999999,-0.20723,1.0085999999999999,-1.0085999999999999,null,null,null,null,-1.0085970143226379,1.2289600000000001,1.92062,-0.49584,null,null,-1.0085999999999999,-0.20723,1.0085999999999999,-1.0085999999999999]
[-0.82015000000000005,0.82015000000000005,0.34877999999999998,1.92062,null,null,null,null,-0.82014926670999799,-0.82015000000000005,0.82015000000000005,1.0085999999999999,null,null,-0.82015000000000005,0.82015000000000005,0.34877999999999998,1.92062]
[-0.65151000000000003,-1.2289600000000001,-0.65151000000000003,0.20723,null,null,null,null,-0.65150824725852552,-1.50709,-1.50709,0.34877999999999998,null,null,-0.65151000000000003,-1.2289600000000001,-0.65151000000000003,0.20723]
[-0.49584,-0.65151000000000003,1.2289600000000001,-0.34877999999999998,null,null,null,null,-0.49584410627799025,1.92062,-0.34877999999999998,0.65151000000000003,null,null,-0.49584,-0.65151000000000003,1.2289600000000001,-0.34877999999999998]
[-0.34877999999999998,-0.49584,-0.49584,-6.8739999999999996E-2,null,null,null,null,-0.34878464804034565,-0.49584,-1.2289600000000001,-1.92062,null,null,-0.34877999999999998,-0.49584,-0.49584,-6.8739999999999996E-2]
[-0.20723,-1.0085999999999999,0.20723,0.65151000000000003,null,null,null,null,-0.20722641161785371,0.49584,-0.82015000000000005,-1.0085999999999999,null,null,-0.20723,-1.0085999999999999,0.20723,0.65151000000000003]
[-6.8739999999999996E-2,0.49584,6.8739999999999996E-2,-1.2289600000000001,null,null,null,null,-6.8745055214751397E-2,-6.8739999999999996E-2,6.8739999999999996E-2,-0.65151000000000003,null,null,-6.8739999999999996E-2,0.49584,6.8739999999999996E-2,-1.2289600000000001]
[6.8739999999999996E-2,-0.34877999999999998,-1.2289600000000001,0.49584,null,null,null,null,6.8745055214751397E-2,1.0085999999999999,1.50709,0.49584,null,null,6.8739999999999996E-2,-0.34877999999999998,-1.2289600000000001,0.49584]
[0.20723,0.34877999999999998,0.65151000000000003,0.34877999999999998,null,null,null,null,0.20722641161785349,-1.92062,1.2289600000000001,0.20723,null,null,0.20723,0.34877999999999998,0.65151000000000003,0.34877999999999998]
[0.34877999999999998,-6.8739999999999996E-2,-0.20723,1.2289600000000001,null,null,null,null,0.34878464804034565,1.50709,-0.65151000000000003,1.2289600000000001,null,null,0.34877999999999998,-6.8739999999999996E-2,-0.20723,1.2289600000000001]
[0.49584,-1.92062,-0.82015000000000005,-0.20723,null,null,null,null,0.49584410627799008,-1.2289600000000001,0.34877999999999998,1.92062,null,null,0.49584,-1.92062,-0.82015000000000005,-0.20723]
[0.65151000000000003,0.20723,1.92062,-1.92062,null,null,null,null,0.65150824725852552,-1.0085999999999999,-0.20723,1.50709,null,null,0.65151000000000003,0.20723,1.92062,-1.92062]
[0.82015000000000005,1.0085999999999999,1.50709,1.50709,null,null,null,null,0.82014926670999788,6.8739999999999996E-2,-1.92062,-0.82015000000000005,null,null,0.82015000000000005,1.0085999999999999,1.50709,1.50709]
[1.0085999999999999,-0.82015000000000005,-1.92062,1.0085999999999999,null,null,null,null,1.0085970143226379,-0.65151000000000003,0.65151000000000003,-0.20723,null,null,1.0085999999999999,-0.82015000000000005,-1.92062,1.0085999999999999]
[1.2289600000000001,1.50709,0.49584,-1.50709,null,null,null,null,1.2289644820909671,0.34877999999999998,1.0085999999999999,-1.2289600000000001,null,null,1.2289600000000001,1.50709,0.49584,-1.50709]
[1.50709,6.8739999999999996E-2,-6.8739999999999996E-2,6.8739999999999996E-2,null,null,null,null,1.5070906370129664,-0.34877999999999998,0.49584,-6.8739999999999996E-2,null,null,1.50709,6.8739999999999996E-2,-6.8739999999999996E-2,6.8739999999999996E-2]
[1.92062,0.65151000000000003,-0.34877999999999998,-0.82015000000000005,null,null,null,null,1.9206164592722912,-0.20723,0.20723,-0.34877999999999998,null,null,1.92062,0.65151000000000003,-0.34877999999999998,-0.82015000000000005]

{"sheet":"Covariance_E","index":4,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":1.00000036512},{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":4.8631060175000018E-2},{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":8.9763119145000056E-2},{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":-9.5954532840000009E-2}]
[{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":4.8631060175000018E-2},{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":1.0000003651199998},{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":0.45044213164499991},{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":-0.24080978345499998}]
[{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":8.9763119145000056E-2},{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":0.45044213164499991},{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":1.00000036512},{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":-0.31920508046999996}]
[{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":-9.5954532840000009E-2},{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":-0.24080978345499998},{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":-0.31920508046999996},{"$f":"COVAR(INDEX(Intermediate_M!$A$1:$D$20,,ROW()),INDEX(Intermediate_M!$A$1:$D$20,,COLUMN()))","v":1.00000036512}]

{"sheet":"Cholesky_F","index":5,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[{"$f":"TRANSPOSE(Cholesky(Covariance_E!A1:D4))","v":1.0000001825599834},4.8631051296916104E-2,8.9763102757849517E-2,-9.5954515322545286E-2]
[0,0.99881699323237216,0.44660519455783226,-0.2364231046309806]
[0,0,0.89021724915733047,-0.23028549379759988]
[0,0,0,0.93907710176122361]

{"sheet":"Intermediate_T","index":6,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MMULT(MMULT(Intermediate_M!A1:D20,MINVERSE(Cholesky_F!A1:D4)),Cholesky_C!A1:D4)","v":-1.9206196493717087},-0.74213893843518297,-2.281047745741918,-1.3323190621965795]
[-1.5070897248657249,-2.0669698867505377,-1.3067827318725695,0.5457686419526574]
[-1.2289597756411239,0.20647089367164295,-0.51141001024321964,-0.94465375085709169]
[-1.0085998158700342,-0.90190070137289646,0.80546412832720138,-0.65872824531731777]
[-0.82014985027345699,-0.13948785136837849,-0.31782114171711451,1.7696014502334241]
[-0.651509881060367,-1.240424576770792,-0.27999754084197903,0.23987817493581315]
[-0.49583990947947437,-0.77355585417557515,1.4214488477281653,0.23611904205343237]
[-0.34877993632674059,-0.56669134054744186,-0.3811667433594485,-0.1474390881210495]
[-0.20722996216810155,-0.76560687774175906,0.64213910697937648,0.97494181178405093]
[-6.8739987450829029E-2,0.24487249046257098,-0.19672620913041042,-1.3369454267066847]
[6.8739987450829029E-2,-0.15653198304443969,-1.069538605673833,0.1401423943621293]
[0.20722996216810155,0.36924598011744647,0.56694656553754463,0.51205808595875058]
[0.34877993632674059,0.22754212472989399,-6.3623654603667978E-2,1.195503759053641]
[0.49583990947947437,-0.77155001652616617,0.26827707236927939,3.1677976099366068E-2]
[0.651509881060367,0.62666048970206278,2.0898668707678101,-1.2174435619570438]
[0.82014985027345699,1.2380374429698175,1.3249255384500094,1.8568011409412442]
[1.0085998158700342,0.28474259916128386,-1.2368840906068854,0.59246124037439085]
[1.2289597756411239,1.8525909904722635,0.17410879688465825,-1.6242776234242995]
[1.5070897248657249,1.2029377308626745,0.39517251584372382,0.1393053338295937]
[1.9206196493717087,1.8717572845835131,-4.3350969096722869E-2,-0.97245229299842739]

{"sheet":"Check_Correlation","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":1},{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":0.80000000000000027},{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":0.40000000000000008},{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":-4.4408920985006276E-17}]
[{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":0.80000000000000027},{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":1},{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":0.3},{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":-0.20000000000000018}]
[{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":0.40000000000000008},{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":0.3},{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":1.0000000000000002},{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":9.9999999999999978E-2}]
[{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":-4.4408920985006276E-17},{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":-0.20000000000000018},{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":9.9999999999999978E-2},{"$f":"CORREL(INDEX(Intermediate_T!$A$1:$D$20,,ROW()),INDEX(Intermediate_T!$A$1:$D$20,,COLUMN()))","v":1}]
[]
["Difference to Target Correlation:"]
[]
[{"$f":"A1:D4-Target_Correlation_S!A1:D4","v":0},0,0,-4.4408920985006276E-17]
[0,0,0,0]
[0,0,0,0]
[-4.4408920985006276E-17,0,0,0]

{"sheet":"Rank_T","index":8,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RANK(Intermediate_T!A1:A20,Intermediate_T!A1:A20,1)","v":1},{"$f":"RANK(Intermediate_T!B1:B20,Intermediate_T!B1:B20,1)","v":7},{"$f":"RANK(Intermediate_T!C1:C20,Intermediate_T!C1:C20,1)","v":1},{"$f":"RANK(Intermediate_T!D1:D20,Intermediate_T!D1:D20,1)","v":3}]
[2,1,2,15]
[3,11,5,6]
[4,3,17,7]
[5,10,7,19]
[6,2,8,13]
[7,4,19,12]
[8,8,6,8]
[9,6,16,17]
[10,13,9,2]
[11,9,4,11]
[12,15,15,14]
[13,12,10,18]
[14,5,13,9]
[15,16,20,4]
[16,18,18,20]
[17,14,3,16]
[18,19,12,1]
[19,17,14,10]
[20,20,11,5]

{"sheet":"Result_Y","index":9,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[{"$f":"INDEX(Input_Matrix_X!$A$1:$A$20,Rank_T!$A$1:$A$20)","v":123567},{"$f":"INDEX(Input_Matrix_X!$B$1:$B$20,Rank_T!$B$1:$B$20)","v":50686},{"$f":"INDEX(Input_Matrix_X!$C$1:$C$20,Rank_T!$C$1:$C$20)","v":15934},{"$f":"INDEX(Input_Matrix_X!$D$1:$D$20,Rank_T!$D$1:$D$20)","v":16706},null,"VBA",{"$f":"ImanConover(Input_Matrix_X!$A$1:$D$20,Target_Correlation_S!$A$1:$D$4)","v":123567},45191,15934,21178,null,"Worksheet formulae",{"$f":"INDEX(Input_Matrix_X!$A$1:$A$20,Rank_T!$A$1:$A$20)","v":123567},{"$f":"INDEX(Input_Matrix_X!$B$1:$B$20,Rank_T!$B$1:$B$20)","v":50686},{"$f":"INDEX(Input_Matrix_X!$C$1:$C$20,Rank_T!$C$1:$C$20)","v":15934},{"$f":"INDEX(Input_Matrix_X!$D$1:$D$20,Rank_T!$D$1:$D$20)","v":16706}]
[126109,44770,16839,25000,null,null,126109,44770,33117,30136,null,null,126109,44770,16839,25000]
[138713,57685,17620,19569,null,null,138713,47453,30779,23236,null,null,138713,57685,17620,19569]
[139016,47453,35248,20166,null,null,139016,58380,36656,19569,null,null,139016,47453,35248,20166]
[152213,57346,20804,30757,null,null,152213,49345,16839,20796,null,null,152213,57346,20804,30757]
[153224,45191,21110,24019,null,null,153224,57685,32634,13273,null,null,153224,45191,21110,24019]
[153407,47941,38483,23375,null,null,153407,52931,20804,25000,null,null,153407,47941,38483,23375]
[155716,52931,17859,20796,null,null,155716,47941,17859,18821,null,null,155716,52931,17859,20796]
[155780,49420,33117,27079,null,null,155780,70592,22728,20166,null,null,155780,49420,33117,27079]
[161678,58380,22728,15406,null,null,161678,49420,17265,23375,null,null,161678,58380,22728,15406]
[161805,54010,17265,23236,null,null,161805,54010,25198,30757,null,null,161805,54010,17265,23236]
[167447,66972,32634,24785,null,null,167447,66972,17233,24019,null,null,167447,66972,32634,24785]
[170737,57698,24072,30136,null,null,170737,50686,21110,35108,null,null,170737,57698,24072,30136]
[171592,49345,30357,20968,null,null,171592,60948,30357,26754,null,null,171592,49345,30357,20968]
[178881,68053,39483,16891,null,null,178881,57346,24072,20968,null,null,178881,68053,39483,16891]
[181678,72243,36656,35108,null,null,181678,68053,38483,16891,null,null,181678,72243,36656,35108]
[184381,60948,17233,26754,null,null,184381,87138,17620,16706,null,null,184381,60948,17233,26754]
[206940,86685,25393,13273,null,null,206940,72243,25393,15406,null,null,206940,86685,25393,13273]
[217092,70592,30779,21178,null,null,217092,57698,39483,24785,null,null,217092,70592,30779,21178]
[240935,87138,25198,18821,null,null,240935,86685,35248,27079,null,null,240935,87138,25198,18821]

{"sheet":"Check_Correlation_Result","index":10,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":1.0000000000000002},{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":0.84967383550159026},{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":0.26409318603263332},{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":-0.1136072277171109}]
[{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":0.84967383550159026},{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":1},{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":0.18848682362016955},{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":-0.19978439617175789}]
[{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":0.26409318603263332},{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":0.18848682362016955},{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":0.99999999999999989},{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":9.5708184117272319E-2}]
[{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":-0.1136072277171109},{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":-0.19978439617175789},{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":9.5708184117272319E-2},{"$f":"CORREL(INDEX(Result_Y!$A$1:$D$20,,ROW()),INDEX(Result_Y!$A$1:$D$20,,COLUMN()))","v":0.99999999999999989}]
[]
["Difference to Target Correlation:",null,null,null,null,"Maximal absolute error:"]
[]
[{"$f":"A1:D4-Target_Correlation_S!A1:D4","v":0},4.9673835501590213E-2,-0.1359068139673667,-0.1136072277171109,null,{"$f":"MAX(ABS(A8:D11))","v":0.1359068139673667}]
[4.9673835501590213E-2,0,-0.11151317637983044,2.1560382824212243E-4]
[-0.1359068139673667,-0.11151317637983044,0,-4.291815882727687E-3]
[-0.1136072277171109,2.1560382824212243E-4,-4.291815882727687E-3,0]