{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Cross_join_chart","Using Power Query","Inserting Pivot Table","Employing User-Defined Function"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":1},"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":"Dataset","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Creating Cross Join"]
[]
[null,"Color",null,"Size"]
[null,"Red",null,"S"]
[null,"Blue",null,"M"]
[null,"Orange",null,"L"]
[null,"Yellow",null,"XL"]
[null,"Green"]

{"sheet":"Cross_join_chart","index":1,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Color","Custom.Size"]
["Red","S"]
["Red","M"]
["Red","L"]
["Red","XL"]
["Blue","S"]
["Blue","M"]
["Blue","L"]
["Blue","XL"]
["Orange","S"]
["Orange","M"]
["Orange","L"]
["Orange","XL"]
["Yellow","S"]
["Yellow","M"]
["Yellow","L"]
["Yellow","XL"]
["Green","S"]
["Green","M"]
["Green","L"]
["Green","XL"]
["Black","S"]
["Black","M"]
["Black","L"]
["Black","XL"]

{"sheet":"Using Power Query","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using Power Query",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Color",null,"Size",null,null,null,null,null,"Color",null,"Size"]
[null,"Red",null,"S",null,null,null,null,null,"Red",null,"S"]
[null,"Blue",null,"M",null,null,null,null,null,"Blue",null,"M"]
[null,"Orange",null,"L",null,null,null,null,null,"Orange",null,"L"]
[null,"Yellow",null,"XL",null,null,null,null,null,"Yellow",null,"XL"]
[null,"Green",null,null,null,null,null,null,null,"Green"]
[null,"Black"]

{"sheet":"Inserting Pivot Table","index":3,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,13,1,15]]}
[]
[null,"Inserting Pivot Table",null,null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Color",null,"Size",null,"Color","Size",null,null,null,null,null,null,"Color",null,"Size"]
[null,"Red",null,"S",null,"Blue","L",null,null,null,null,null,null,"Red",null,"S"]
[null,"Blue",null,"M",null,"Blue","M",null,null,null,null,null,null,"Blue",null,"M"]
[null,"Orange",null,"L",null,"Blue","S",null,null,null,null,null,null,"Orange",null,"L"]
[null,"Yellow",null,"XL",null,"Blue","XL",null,null,null,null,null,null,"Yellow",null,"XL"]
[null,"Green",null,null,null,"Green","L",null,null,null,null,null,null,"Green"]
[null,null,null,null,null,"Green","M"]
[null,null,null,null,null,"Green","S"]
[null,null,null,null,null,"Green","XL"]
[null,null,null,null,null,"Orange","L"]
[null,null,null,null,null,"Orange","M"]
[null,null,null,null,null,"Orange","S"]
[null,null,null,null,null,"Orange","XL"]
[null,null,null,null,null,"Red","L"]
[null,null,null,null,null,"Red","M"]
[null,null,null,null,null,"Red","S"]
[null,null,null,null,null,"Red","XL"]
[null,null,null,null,null,"Yellow","L"]
[null,null,null,null,null,"Yellow","M"]
[null,null,null,null,null,"Yellow","S"]
[null,null,null,null,null,"Yellow","XL"]

{"sheet":"Employing User-Defined Function","index":4,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,14,1,16]]}
[]
[null,"Employing User-Defined Function",null,null,null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Color",null,"Size",null,"Color","Size",null,null,null,null,null,null,null,"Color",null,"Size"]
[null,"Red",null,"S",null,{"$f":"cross_join(B5:B9,D5:D8)","v":"Red"},"S",null,null,null,null,null,null,null,"Red",null,"S"]
[null,"Blue",null,"M",null,"Red","M",null,null,null,null,null,null,null,"Blue",null,"M"]
[null,"Orange",null,"L",null,"Red","L",null,null,null,null,null,null,null,"Orange",null,"L"]
[null,"Yellow",null,"XL",null,"Red","XL",null,null,null,null,null,null,null,"Yellow",null,"XL"]
[null,"Green",null,null,null,"Blue","S",null,null,null,null,null,null,null,"Green"]
[null,null,null,null,null,"Blue","M"]
[null,null,null,null,null,"Blue","L"]
[null,null,null,null,null,"Blue","XL"]
[null,null,null,null,null,"Orange","S"]
[null,null,null,null,null,"Orange","M"]
[null,null,null,null,null,"Orange","L"]
[null,null,null,null,null,"Orange","XL"]
[null,null,null,null,null,"Yellow","S"]
[null,null,null,null,null,"Yellow","M"]
[null,null,null,null,null,"Yellow","L"]
[null,null,null,null,null,"Yellow","XL"]
[null,null,null,null,null,"Green","S"]
[null,null,null,null,null,"Green","M"]
[null,null,null,null,null,"Green","L"]
[null,null,null,null,null,"Green","XL"]