{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Title","Question","2nd Smallest","Tempting","Lowest10","Wrap Up"],"not_rendered":{"charts":0,"images":6,"macros":0,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2165]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: HeungSoon / Pixabay"]

{"sheet":"Question","index":1,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[98]
[95]
[105]
[91]
[113]
[97]
[110]
[93]
[113]
[96]
[95]
[98]
[114]
[115]
[89]
[95,null,null,null,"Last 20"]
[114,null,null,null,"Lowest 10"]
[92,null,null,null,"Average"]
[100]
[107,{"$f":"MIN(A1:A20)","v":89}]
[105,{"$f":"MIN(A2:A21)","v":89}]
[113,89]
[111,89]
[95,89]
[94,89]
[94,89]
[106,89]
[115,89]
[89,89]
[112,89]
[98,89]
[91,89]
[96,89]
[90,89]
[96,89]
[107,89]
[96,89]
[89,89]
[91,89]
[113,89]
[94,89]

{"sheet":"2nd Smallest","index":2,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[98]
[95]
[105]
[91]
[113]
[97]
[110]
[93]
[113]
[96]
[95]
[98]
[114]
[115]
[89]
[95,null,null,null,"Last 20"]
[114,null,null,null,"Lowest 10"]
[92,null,null,null,"Average"]
[100]
[107,{"$f":"SMALL(A1:A20,2)","v":91},{"$f":"_xlfn.FORMULATEXT(B20)","v":"=SMALL(A1:A20,2)"}]
[105]
[113]
[111]
[95]
[94]
[94]
[106]
[115]
[89]
[112]
[98]
[91]
[96]
[90]
[96]
[107]
[96]
[89]
[91]
[113]
[94]

{"sheet":"Tempting","index":3,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[98]
[95]
[105]
[91]
[113]
[97]
[110]
[93]
[113]
[96]
[95]
[98]
[114]
[115]
[89]
[95]
[114]
[92]
[100,null,null,null,{"$f":"_xlfn.FORMULATEXT(B20)","v":"=(SMALL(A1:A20,1)+SMALL(A1:A20,2)+SMALL(A1:A20,3)+SMALL(A1:A20,4)+SMALL(A1:A20,5)+SMALL(A1:A20,6)+SMALL(A1:A20,7)+SMALL(A1:A20,8)+SMALL(A1:A20,9)+SMALL(A1:A20,10))/10"}]
[107,{"$f":"(SMALL(A1:A20,1)+SMALL(A1:A20,2)+SMALL(A1:A20,3)+SMALL(A1:A20,4)+SMALL(A1:A20,5)+SMALL(A1:A20,6)+SMALL(A1:A20,7)+SMALL(A1:A20,8)+SMALL(A1:A20,9)+SMALL(A1:A20,10))/10","v":94.1}]
[105,{"$f":"(SMALL(A2:A21,1)+SMALL(A2:A21,2)+SMALL(A2:A21,3)+SMALL(A2:A21,4)+SMALL(A2:A21,5)+SMALL(A2:A21,6)+SMALL(A2:A21,7)+SMALL(A2:A21,8)+SMALL(A2:A21,9)+SMALL(A2:A21,10))/10","v":94.1}]
[113,94.6]
[111,94.6]
[95,95]
[94,94.4]
[94,94.1]
[106,94.1]
[115,94.8]
[89,93.7]
[112,94.1]
[98,94.4]
[91,93.7]
[96,93.3]
[90,92.5]
[96,93.2]
[107,93.5]
[96,93.3]
[88,92.9]
[88,92.1]
[88,91.3]
[94,91.1]

{"sheet":"Lowest10","index":4,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[98]
[95]
[105]
[91]
[113]
[97]
[110]
[93]
[113]
[96]
[95]
[98]
[114]
[115,null,null,null,null,1,null,null,1]
[89,null,null,null,null,2,null,null,2]
[95,null,null,null,null,3,null,null,3]
[114,null,null,null,null,4,null,null,4]
[92,null,null,null,null,5,null,null,5]
[100,null,null,null,null,6,null,null,6]
[107,{"$f":"AVERAGE(SMALL(A1:A20,{1;2;3;4;5;6;7;8;9;10}))","v":94.1},null,null,null,7,null,null,7]
[105,{"$f":"AVERAGE(SMALL(A2:A21,{1;2;3;4;5;6;7;8;9;10}))","v":94.1},null,null,null,8,null,null,8]
[113,{"$f":"AVERAGE(SMALL(A3:A22,{1;2;3;4;5;6;7;8;9;10}))","v":94.6},null,null,null,9,null,null,9]
[111,{"$f":"AVERAGE(SMALL(A4:A23,{1;2;3;4;5;6;7;8;9;10}))","v":94.6},null,null,null,10,null,null,10]
[95,{"$f":"AVERAGE(SMALL(A5:A24,{1;2;3;4;5;6;7;8;9;10}))","v":95}]
[94,{"$f":"AVERAGE(SMALL(A6:A25,{1;2;3;4;5;6;7;8;9;10}))","v":94.4}]
[94,{"$f":"AVERAGE(SMALL(A7:A26,{1;2;3;4;5;6;7;8;9;10}))","v":94.1}]
[106,{"$f":"AVERAGE(SMALL(A8:A27,{1;2;3;4;5;6;7;8;9;10}))","v":94.1}]
[115,{"$f":"AVERAGE(SMALL(A9:A28,{1;2;3;4;5;6;7;8;9;10}))","v":94.8}]
[89,{"$f":"AVERAGE(SMALL(A10:A29,{1;2;3;4;5;6;7;8;9;10}))","v":93.7}]
[112,{"$f":"AVERAGE(SMALL(A11:A30,{1;2;3;4;5;6;7;8;9;10}))","v":94.1}]
[98,{"$f":"AVERAGE(SMALL(A12:A31,{1;2;3;4;5;6;7;8;9;10}))","v":94.4}]
[91,{"$f":"AVERAGE(SMALL(A13:A32,{1;2;3;4;5;6;7;8;9;10}))","v":93.7}]
[96,{"$f":"AVERAGE(SMALL(A14:A33,{1;2;3;4;5;6;7;8;9;10}))","v":93.3}]
[90,{"$f":"AVERAGE(SMALL(A15:A34,{1;2;3;4;5;6;7;8;9;10}))","v":92.5}]
[96,{"$f":"AVERAGE(SMALL(A16:A35,{1;2;3;4;5;6;7;8;9;10}))","v":93.2}]
[107,{"$f":"AVERAGE(SMALL(A17:A36,{1;2;3;4;5;6;7;8;9;10}))","v":93.5}]
[96,{"$f":"AVERAGE(SMALL(A18:A37,{1;2;3;4;5;6;7;8;9;10}))","v":93.3}]
[89,{"$f":"AVERAGE(SMALL(A19:A38,{1;2;3;4;5;6;7;8;9;10}))","v":93}]
[91,{"$f":"AVERAGE(SMALL(A20:A39,{1;2;3;4;5;6;7;8;9;10}))","v":92.5}]
[113,{"$f":"AVERAGE(SMALL(A21:A40,{1;2;3;4;5;6;7;8;9;10}))","v":92.5}]
[94,{"$f":"AVERAGE(SMALL(A22:A41,{1;2;3;4;5;6;7;8;9;10}))","v":92.3}]

{"sheet":"Wrap Up","index":5,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"How to calculate a Golf Handicap in Excel"]
[null,"You have your recent golf scores in Excel"]
[null,"The handicap is the average of the lowest 10 scores in the last 20 rounds"]
[null,"Getting the last 20 is easy thanks to Excel"]
[null,"Getting the smallest using MIN"]
[null,"But… to get the 2nd smallest through 10th smallest, use SMALL() function."]
[null,"Slow but understandable:  =SMALL(,1)+SMALL(,2)+SMALL(,3)…+SMALL(,10) divided by 10"]
[null,"Easier to enter: Array constant {1;2;3;4;5;6;7;8;9;10} as the second argument of SMALL"]
[null,"This will return all 10 values at once"]
[null,"Send that in to the AVERGE function: =AVERAGE(SMALL(A1:A20,{1;2;3;4;5;6;7;8;9;10}))"]
[null,"My fast way for typing the array constant: Type a 1 in a cell. Ctrl+Drag the fill handle from the 1 down to get 2 through 10."]
[null,"Point a formula at the ten numbers and press F9, then Ctrl+C to copy"]