{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["sbSWV"],"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":"sbSWV","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Values A","Values B","Weights","Values","sbSWV Function","sbSWV Result",null,32,31]
[32,31,1,"A","AVERAGE",{"$f":"sbSWV(E2,$A$2:$A$10,$C$2:$C$10)","v":35.92},{"$f":"AVERAGE($H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))))","v":35.92},33,34]
[33,34,4,"B","AVERAGE",{"$f":"sbSWV(E3,$B$2:$B$10,$C$2:$C$10)","v":37.36},{"$f":"AVERAGE($I$1:INDEX(I:I,LOOKUP(2,1/(I:I<>\"\"),ROW(I:I))))","v":37.36},33,34]
[34,35,4,"A + B","COVAR",{"$f":"sbSWV(E4,$A$2:$A$10,$B$2:$B$10,$C$2:$C$10)","v":7.428799999999999},{"$f":"COVAR($H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))),$I$1:INDEX(I:I,LOOKUP(2,1/(I:I<>\"\"),ROW(I:I))))","v":7.4287999999999963},33,34]
[35,36,3,"A + B","CORREL",{"$f":"sbSWV(E5,$A$2:$A$10,$B$2:$B$10,$C$2:$C$10)","v":0.99002539862122463},{"$f":"CORREL($H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))),$I$1:INDEX(I:I,LOOKUP(2,1/(I:I<>\"\"),ROW(I:I))))","v":0.99002539862122441},33,34]
[36,38,3,"A","KURT A",{"$f":"sbSWV(\"KURT\",$A$2:$A$10,$C$2:$C$10)","v":-1.0000153476782598},{"$f":"KURT($H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))))","v":-1.0000153476782598},34,35]
[37,39,4,"A","MEDIAN",{"$f":"sbSWV(E7,$A$2:$A$10,$C$2:$C$10)","v":36},{"$f":"MEDIAN($H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))))","v":36},34,35]
[38,40,1,"A","MODE",{"$f":"sbSWV(E8,$A$2:$A$10,$C$2:$C$10)","v":33},{"$f":"MODE($H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))))","v":33},34,35]
[39,41,1,"A","SKEW.P",{"$f":"sbSWV(E9,$A$2:$A$10,$C$2:$C$10)","v":0.33258370503404983},{"$f":"_xlfn.SKEW.P($H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))))","v":0.33258370503404983},34,35]
[40,42,4,"A","STDEV",{"$f":"sbSWV(E10,$A$2:$A$10,$C$2:$C$10)","v":2.5152865973217975},{"$f":"STDEV($H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))))","v":2.5152865973217975},35,36]
[null,null,null,"A","STDEV.P",{"$f":"sbSWV(E11,$A$2:$A$10,$C$2:$C$10)","v":2.4644674881198978},{"$f":"_xlfn.STDEV.P($H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))))","v":2.4644674881198978},35,36]
[null,null,null,"A","VAR",{"$f":"sbSWV(E12,$A$2:$A$10,$C$2:$C$10)","v":6.3266666666666653},{"$f":"VAR($H$1:INDEX(H:H,LOOKUP(2,1/(H:H<>\"\"),ROW(H:H))))","v":6.3266666666666653},35,36]
[null,null,null,"B","VAR",{"$f":"sbSWV(E13,$B$2:$B$10,$C$2:$C$10)","v":9.6566666666666681},{"$f":"VAR($I$1:INDEX(I:I,LOOKUP(2,1/(I:I<>\"\"),ROW(I:I))))","v":9.6566666666666663},36,38]
[null,null,null,null,null,null,null,36,38]
[null,null,null,null,null,null,null,36,38]
[null,null,null,null,null,null,null,37,39]
[null,null,null,null,null,null,null,37,39]
[null,null,null,null,null,null,null,37,39]
[null,null,null,null,null,null,null,37,39]
[null,null,null,null,null,"ABS Difference Total",{"$f":"SUM(ABS(F2:F14-G2:G14))","v":4.6629367034256575E-15},38,40]
[null,null,null,null,null,null,null,39,41]
[null,null,null,null,null,null,null,40,42]
[null,null,null,null,null,null,null,40,42]
[null,null,null,null,null,null,null,40,42]
[null,null,null,null,null,null,null,40,42]