{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["(850)","(850an)","(851)","(851an)","(852)","(852an)","zxzxcZc","(853)","(853an)","(853an) (2)","Sheet11","Sheet12"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"(850)","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Day1","Day2","Day3","Day4","Day5","Total",null,"Max"]
[7,2,3,3,null,{"$f":"SUM(A2:E2)","v":15},null,24]
[4,1,null,2,null,7]
[7,5,6,2,null,20]
[8,7,4,4,null,23]
[8,7,8,3,null,26]
[]
["Day1","Day2","Day3","Day4","Day5","Total",null,"Max"]
[7,2,3,3,null,{"$f":"SUM(A9:E9)","v":15},null,24]
[4,1,null,2,null,7]
[7,5,6,2,null,20]
[8,7,4,4,null,23]
[8,7,8,3,null,26]
[]
["Day1","Day2","Day3","Day4","Day5","Total",null,"Max"]
[7,2,3,3,null,{"$f":"SUM(A16:E16)","v":15},null,24]
[4,1,null,2,null,7]
[7,5,6,2,null,20]
[8,7,4,4,null,23]
[8,7,8,3,null,26]

{"sheet":"(850an)","index":1,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Day1","Day2","Day3","Day4","Day5","Total",null,"Max"]
[7,2,3,3,null,{"$f":"SUM(A2:E2)","v":15},null,20]
[4,1,null,2,null,7]
[7,5,6,2,null,20]
[8,7,4,4,5,28]
[8,7,8,3,null,26]
[]
["Day1","Day2","Day3","Day4","Day5","Total",null,"Max"]
[7,2,3,3,null,{"$f":"SUM(A9:E9)","v":15},null,24,null,{"$f":"F9>$H$9","v":false}]
[4,1,null,2,null,7,null,null,null,{"$f":"F10>$H$9","v":false}]
[7,5,6,2,null,20,null,null,null,false]
[8,7,4,4,5,28,null,null,null,true]
[8,7,8,3,null,26,null,null,null,true]
[]
["Day1","Day2","Day3","Day4","Day5","Total",null,"Max"]
[7,2,3,3,null,{"$f":"SUM(A16:E16)","v":15},null,12]
[4,1,null,2,null,7]
[7,5,6,2,null,20]
[8,7,4,4,5,28]
[8,7,8,3,null,26]

{"sheet":"(851)","index":2,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Values",null,"Sum Unique",null,"Values",null,"Sum Unique",null,null,null,null,"  C2: =SUMPRODUCT(A2:A20,--(FREQUENCY(A2:A19,A2:A19)>0))"]
[5,null,null,null,null,null,null,null,null,null,null,"  G2: =SUM(IF(FREQUENCY(IF(E2:E19<>\"\",MATCH(E2:E19,E2:E19,0)),ROW(E2:E19)-ROW(E2)+1),E2:E19))"]
[1,null,null,null,1]
[4,null,null,null,4,null,"Sum Unique"]
[3,null,null,null,4,null,{"$f":"SUM(IF(FREQUENCY(IF(E2:E19<>\"\",MATCH(\"~\"&E2:E19,E2:E19&\"\",0)),ROW(E2:E19)-ROW(E2)+1),E2:E19))","v":10},null,null,null,null,"  G5: =SUM(IF(FREQUENCY(IF(E2:E19<>\"\",MATCH(\"~\"&E2:E19,E2:E19&\"\",0)),ROW(E2:E19)-ROW(E2)+1),E2:E19))"]
[1,null,null,null,1]
[3,null,null,null,3]
[3,null,null,null,null,null,"Excel Magic Trick 627: FREQUENCY Array Function (10 Examples)"]
[3]
[5]
[3,null,null,null,3]
[5]
[1,null,null,null,1]
[1,null,null,null,1]
[1,null,null,null,1]
[1,null,null,null,1]
[2,null,null,null,2]
[1,null,null,null,1]
[1,null,null,null,1]

{"sheet":"(851an)","index":3,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Values",null,"Sum Unique",null,"Values",null,"Sum Unique",null,null,null,null,"  C2: =SUMPRODUCT(A2:A20,--(FREQUENCY(A2:A19,A2:A19)>0))"]
[5,null,{"$f":"SUMPRODUCT(A2:A20,--(FREQUENCY(A2:A19,A2:A19)>0))","v":15},null,null,null,{"$f":"SUM(IF(FREQUENCY(IF(E2:E19<>\"\",MATCH(E2:E19,E2:E19,0)),ROW(E2:E19)-ROW(E2)+1),E2:E19))","v":20},null,null,null,null,"  G2: =SUM(IF(FREQUENCY(IF(E2:E19<>\"\",MATCH(E2:E19,E2:E19,0)),ROW(E2:E19)-ROW(E2)+1),E2:E19))"]
[1,null,null,null,1]
[4,null,null,null,4,null,"Sum Unique"]
[3,null,null,null,4,null,{"$f":"SUM(IF(FREQUENCY(IF(E2:E19<>\"\",MATCH(\"~\"&E2:E19,E2:E19&\"\",0)),ROW(E2:E19)-ROW(E2)+1),E2:E19))","v":20},null,null,null,null,"  G5: =SUM(IF(FREQUENCY(IF(E2:E19<>\"\",MATCH(\"~\"&E2:E19,E2:E19&\"\",0)),ROW(E2:E19)-ROW(E2)+1),E2:E19))"]
[1,null,null,null,1]
[3,null,null,null,3]
[3,null,null,null,1,null,"Excel Magic Trick 627: FREQUENCY Array Function (10 Examples)"]
[3,null,null,null,10]
[5]
[3,null,null,null,3]
[5]
[1,null,null,null,1]
[1,null,null,null,1]
[1,null,null,null,1]
[1,null,null,null,1]
[2,null,null,null,2]
[1,null,null,null,1]
[1,null,null,null,1]

{"sheet":"(852)","index":4,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["City","Values",null,"City","SD"]
["Tacoma",5,null,"Seattle"]
["Seattle",1,null,"Tacoma"]
["Berkeley",4,null,"Oakland"]
["Oakland",3,null,"Berkeley"]
["Tacoma",1]
["Seattle",3,null,"City","SD"]
["Oakland",3,null,"Seattle"]
["Tacoma",3]
["Tacoma",5]
["Berkeley",3]
["Oakland",5]
["Seattle",1]
["Oakland",1]
["Oakland",1]
["Berkeley",1]
["Berkeley",2]
["Oakland",1]
["Oakland",1]

{"sheet":"(852an)","index":5,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["City","Values",null,"City","SD"]
["Tacoma",5,null,"Seattle",{"$f":"_xlfn.STDEV.S(IF($A$2:$A$19=D2,$B$2:$B$19))","v":1.1547005383792515}]
["Seattle",1,null,"Tacoma",{"$f":"_xlfn.STDEV.S(IF($A$2:$A$19=D3,$B$2:$B$19))","v":1.9148542155126762}]
["Berkeley",4,null,"Oakland",{"$f":"_xlfn.STDEV.S(IF($A$2:$A$19=D4,$B$2:$B$19))","v":1.5735915849388862}]
["Oakland",3,null,"Berkeley",{"$f":"_xlfn.STDEV.S(IF($A$2:$A$19=D5,$B$2:$B$19))","v":1.2909944487358056}]
["Tacoma",1]
["Seattle",3,null,"City","SD"]
["Oakland",3,null,"Seattle",{"$f":"DSTDEV(A1:B19,B1,D7:D8)","v":1.1547005383792515}]
["Tacoma",3]
["Tacoma",5]
["Berkeley",3]
["Oakland",5]
["Seattle",1]
["Oakland",1]
["Oakland",1]
["Berkeley",1]
["Berkeley",2]
["Oakland",1]
["Oakland",1]

{"sheet":"zxzxcZc","index":6,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Numbers","Extra Column",null,"# That Occurs Least Frequently"]
[1,{"$f":"IF(ISNUMBER(A2),COUNTIF(Numbers,A2),\"\")","v":4},null,{"$f":"INDEX(A2:A13,MATCH(MIN(IF(ISNUMBER(A2:A13),COUNTIF(A2:A13,A2:A13))),COUNTIF(A2:A13,A2:A13),0))","v":2}]
[1,{"$f":"IF(ISNUMBER(A3),COUNTIF(Numbers,A3),\"\")","v":4}]
[7,{"$f":"IF(ISNUMBER(A4),COUNTIF(Numbers,A4),\"\")","v":4}]
[7,{"$f":"IF(ISNUMBER(A5),COUNTIF(Numbers,A5),\"\")","v":4}]
[7,{"$f":"IF(ISNUMBER(A6),COUNTIF(Numbers,A6),\"\")","v":4}]
[null,{"$f":"IF(ISNUMBER(A7),COUNTIF(Numbers,A7),\"\")","v":""}]
[2,{"$f":"IF(ISNUMBER(A8),COUNTIF(Numbers,A8),\"\")","v":1}]
[7,{"$f":"IF(ISNUMBER(A9),COUNTIF(Numbers,A9),\"\")","v":4}]
[1,{"$f":"IF(ISNUMBER(A10),COUNTIF(Numbers,A10),\"\")","v":4}]
[1,{"$f":"IF(ISNUMBER(A11),COUNTIF(Numbers,A11),\"\")","v":4}]
[3,{"$f":"IF(ISNUMBER(A12),COUNTIF(Numbers,A12),\"\")","v":2}]
[3,{"$f":"IF(ISNUMBER(A13),COUNTIF(Numbers,A13),\"\")","v":2}]
[]
[]
[]
[]
[null,null,null,null,"other:"]
[null,null,null,null,{"$f":"MAX(IF(COUNTIF(A2:A13,A2:A13)=MIN(IF(ISNUMBER(A2:A13),COUNTIF(A2:A13,A2:A13))),A2:A13))","v":2}]
[null,null,null,null,{"$f":"MAX(IF(COUNTIF(A2:A13,A2:A13)=MIN(IF(A2:A13<>\"\",COUNTIF(A2:A13,A2:A13))),A2:A13))","v":2}]
[]
[1]
[2]
[3]
[7]

{"sheet":"(853)","index":7,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Numbers","Extra Column",null,"# That Occurs Least Frequently"]
[1]
[1]
[7]
[7]
[7]
[]
[2]
[7]
[1]
[1]
[3]
[3]
[]
[]
[]
[]
[]
[]
[]
[]
[1]
[2]
[3]
[7]

{"sheet":"(853an)","index":8,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Numbers","Extra Column",null,"# That Occurs Least Frequently"]
[1,{"$f":"IF(ISNUMBER(A2),COUNTIF($A$2:$A$13,A2),\"\")","v":4},null,{"$f":"INDEX(A2:A13,MATCH(MIN(B2:B13),B2:B13,0))","v":2}]
[1,{"$f":"IF(ISNUMBER(A3),COUNTIF($A$2:$A$13,A3),\"\")","v":4},null,{"$f":"INDEX(A2:A13,MATCH(MIN(IF(ISNUMBER(A2:A13),COUNTIF(A2:A13,A2:A13))),COUNTIF(A2:A13,A2:A13),0))","v":2}]
[7,4]
[7,4]
[7,4]
[null,""]
[2,1]
[7,4]
[1,4]
[1,4]
[3,2]
[3,2]
[]
[]
[]
[]
[]
[]
[]
[]
[1]
[2]
[3]
[7]

{"sheet":"(853an) (2)","index":9,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Numbers",null,null,"# That Occurs Least Frequently"]
[1,null,null,{"$f":"INDEX($A$2:$A$13,SMALL(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$13),IF(COUNTIF($A$2:$A$13,$A$2:$A$13),MATCH($A$2:$A$13,$A$2:$A$13,0))),ROW($A$2:$A$13)-ROW($A$2)+1),ROW($A$2:$A$13)-ROW($A$2)+1),ROWS(D$2:D2)))","v":1}]
[1,null,null,{"$f":"INDEX($A$2:$A$13,SMALL(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$13),IF(COUNTIF($A$2:$A$13,$A$2:$A$13),MATCH($A$2:$A$13,$A$2:$A$13,0))),ROW($A$2:$A$13)-ROW($A$2)+1),ROW($A$2:$A$13)-ROW($A$2)+1),ROWS(D$2:D3)))","v":7}]
[7,null,null,{"$f":"INDEX($A$2:$A$13,SMALL(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$13),IF(COUNTIF($A$2:$A$13,$A$2:$A$13),MATCH($A$2:$A$13,$A$2:$A$13,0))),ROW($A$2:$A$13)-ROW($A$2)+1),ROW($A$2:$A$13)-ROW($A$2)+1),ROWS(D$2:D4)))","v":2}]
[7,null,null,{"$f":"INDEX($A$2:$A$13,SMALL(IF(FREQUENCY(IF(ISNUMBER($A$2:$A$13),IF(COUNTIF($A$2:$A$13,$A$2:$A$13),MATCH($A$2:$A$13,$A$2:$A$13,0))),ROW($A$2:$A$13)-ROW($A$2)+1),ROW($A$2:$A$13)-ROW($A$2)+1),ROWS(D$2:D5)))","v":3}]
[]
[2]
[2]
[7]
[1]
[1]
[3]
[3]
[]
[]
[]
[]
[]
[]
[]
[]
[1]
[2]
[3]
[7]

{"sheet":"Sheet11","index":10,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Numbers",null,"# That Occurs Least Frequently?"]
[1,null,{"$f":"INDEX(Numbers,MATCH(TRUE,COUNTIF(Numbers,Numbers)=MIN(COUNTIF(Numbers,Numbers)),0))","v":{"$error":"#NAME?"}}]
[1,null,{"$f":"INDEX(Numbers,MATCH(MIN(COUNTIF(Numbers,Numbers)),COUNTIF(Numbers,Numbers),0))","v":{"$error":"#NAME?"}}]
[7]
[7,null,"If Dups"]
[7,null,{"$f":"IFERROR(INDEX(Numbers,SMALL(IF(FREQUENCY(IF(COUNTIF(Numbers,Numbers)=MIN(COUNTIF(Numbers,Numbers)),MATCH(Numbers,Numbers,0)),ROW(Numbers)-ROW($A$2)+1),ROW(Numbers)-ROW($A$2)+1),ROWS(C$6:C6))),\"\")","v":""}]
[2,null,{"$f":"IFERROR(INDEX(Numbers,SMALL(IF(FREQUENCY(IF(COUNTIF(Numbers,Numbers)=MIN(COUNTIF(Numbers,Numbers)),MATCH(Numbers,Numbers,0)),ROW(Numbers)-ROW($A$2)+1),ROW(Numbers)-ROW($A$2)+1),ROWS(C$6:C7))),\"\")","v":""}]
[2,null,{"$f":"IFERROR(INDEX(Numbers,SMALL(IF(FREQUENCY(IF(COUNTIF(Numbers,Numbers)=MIN(COUNTIF(Numbers,Numbers)),MATCH(Numbers,Numbers,0)),ROW(Numbers)-ROW($A$2)+1),ROW(Numbers)-ROW($A$2)+1),ROWS(C$6:C8))),\"\")","v":""}]
[7,null,{"$f":"IFERROR(INDEX(Numbers,SMALL(IF(FREQUENCY(IF(COUNTIF(Numbers,Numbers)=MIN(COUNTIF(Numbers,Numbers)),MATCH(Numbers,Numbers,0)),ROW(Numbers)-ROW($A$2)+1),ROW(Numbers)-ROW($A$2)+1),ROWS(C$6:C9))),\"\")","v":""}]
[1,null,{"$f":"IFERROR(INDEX(Numbers,SMALL(IF(FREQUENCY(IF(COUNTIF(Numbers,Numbers)=MIN(COUNTIF(Numbers,Numbers)),MATCH(Numbers,Numbers,0)),ROW(Numbers)-ROW($A$2)+1),ROW(Numbers)-ROW($A$2)+1),ROWS(C$6:C10))),\"\")","v":""}]
[1]
[3]
[3]
[]
[]
[]
[]
[]
[]
[]
[]
[1]
[2]
[3]
[7]

{"sheet":"Sheet12","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}