{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Dataset","Fill Handle","Fill Series","SEQUENCE","ROW","COUNTA","SUBTOTAL","IF & ROW","OFFSET","TEXT & ROW","Add 1","Name Manager","Filter","Table","Pivot Table","Power Pivot","Power Query","Connection Property","VBA","Roman","Dates","Number to Date"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":2},"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":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Serial Number in Excel"]
[]
[null,"Serial Number","Name","CGPA"]
[null,null,"Ron",3.81]
[null,null,"Anderson",3.79]
[null,null,"Rebecca",3.75]
[null,null,"David",3.68]
[null,null,"Lily",3.59]
[null,null,"Robert",3.53]
[null,null,"Pammela",3.47]
[null,null,"Mary",3.36]
[null,null,"Daniel",3.28]
[null,null,"Jacob",3.22]

{"sheet":"Fill Handle","index":1,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using Fill Handle",null,null,null,null,null,"Try Yourself"]
[]
[null,"Serial Number","Name","CGPA",null,null,null,"Serial Number","Name","CGPA"]
[null,1,"Ron",3.81,null,null,null,null,"Ron",3.81]
[null,2,"Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,3,"Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,4,"David",3.68,null,null,null,null,"David",3.68]
[null,5,"Lily",3.59,null,null,null,null,"Lily",3.59]
[null,6,"Robert",3.53,null,null,null,null,"Robert",3.53]
[null,7,"Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,8,"Mary",3.36,null,null,null,null,"Mary",3.36]
[null,9,"Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,10,"Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"Fill Series","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using Fill Series",null,null,null,null,null,"Try Yourself"]
[]
[null,"Serial Number","Name","CGPA",null,null,null,"Serial Number","Name","CGPA"]
[null,1,"Ron",3.81,null,null,null,null,"Ron",3.81]
[null,2,"Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,3,"Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,4,"David",3.68,null,null,null,null,"David",3.68]
[null,5,"Lily",3.59,null,null,null,null,"Lily",3.59]
[null,6,"Robert",3.53,null,null,null,null,"Robert",3.53]
[null,7,"Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,8,"Mary",3.36,null,null,null,null,"Mary",3.36]
[null,9,"Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,10,"Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"SEQUENCE","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using SEQUENCE Function",null,null,null,null,null,"Try Youself"]
[]
[null,"Serial Number","Name","CGPA",null,null,null,"Serial Number","Name","CGPA"]
[null,{"$f":"_xlfn.SEQUENCE(10)","v":1},"Ron",3.81,null,null,null,null,"Ron",3.81]
[null,2,"Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,3,"Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,4,"David",3.68,null,null,null,null,"David",3.68]
[null,5,"Lily",3.59,null,null,null,null,"Lily",3.59]
[null,6,"Robert",3.53,null,null,null,null,"Robert",3.53]
[null,7,"Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,8,"Mary",3.36,null,null,null,null,"Mary",3.36]
[null,9,"Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,10,"Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"ROW","index":4,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using ROW Function",null,null,null,null,null,"Try Yourself"]
[]
[null,"Serial Number","Name","CGPA",null,null,null,"Serial Number","Name","CGPA"]
[null,{"$f":"ROW()-ROW($B$4)","v":1},"Ron",3.81,null,null,null,null,"Ron",3.81]
[null,{"$f":"ROW()-ROW($B$4)","v":2},"Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,3,"Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,4,"David",3.68,null,null,null,null,"David",3.68]
[null,5,"Lily",3.59,null,null,null,null,"Lily",3.59]
[null,6,"Robert",3.53,null,null,null,null,"Robert",3.53]
[null,7,"Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,8,"Mary",3.36,null,null,null,null,"Mary",3.36]
[null,9,"Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,10,"Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"COUNTA","index":5,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using COUNTA Function",null,null,null,null,null,"Try Yourself"]
[]
[null,"Serial Number","Name","CGPA",null,null,null,"Serial Number","Name","CGPA"]
[null,{"$f":"COUNTA($C$5:C5)","v":1},"Ron",3.81,null,null,null,null,"Ron",3.81]
[null,{"$f":"COUNTA($C$5:C6)","v":2},"Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,{"$f":"COUNTA($C$5:C7)","v":3},"Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,{"$f":"COUNTA($C$5:C8)","v":4},"David",3.68,null,null,null,null,"David",3.68]
[null,{"$f":"COUNTA($C$5:C9)","v":5},"Lily",3.59,null,null,null,null,"Lily",3.59]
[null,{"$f":"COUNTA($C$5:C10)","v":6},"Robert",3.53,null,null,null,null,"Robert",3.53]
[null,{"$f":"COUNTA($C$5:C11)","v":7},"Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,{"$f":"COUNTA($C$5:C12)","v":8},"Mary",3.36,null,null,null,null,"Mary",3.36]
[null,{"$f":"COUNTA($C$5:C13)","v":9},"Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,{"$f":"COUNTA($C$5:C14)","v":10},"Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"SUBTOTAL","index":6,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using SUBTOTAL Function",null,null,null,null,null,"Using SUBTOTAL Function"]
[]
[null,"Serial Number","Name","CGPA",null,null,null,"Serial Number","Name","CGPA"]
[null,{"$f":"SUBTOTAL(3,$C$5:C5)","v":1},"Ron",3.81,null,null,null,null,"Ron",3.81]
[null,{"$f":"SUBTOTAL(3,$C$5:C6)","v":2},"Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,{"$f":"SUBTOTAL(3,$C$5:C7)","v":3},"Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,{"$f":"SUBTOTAL(3,$C$5:C8)","v":4},"David",3.68,null,null,null,null,"David",3.68]
[null,{"$f":"SUBTOTAL(3,$C$5:C9)","v":5},"Lily",3.59,null,null,null,null,"Lily",3.59]
[null,{"$f":"SUBTOTAL(3,$C$5:C10)","v":6},"Robert",3.53,null,null,null,null,"Robert",3.53]
[null,{"$f":"SUBTOTAL(3,$C$5:C11)","v":7},"Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,{"$f":"SUBTOTAL(3,$C$5:C12)","v":8},"Mary",3.36,null,null,null,null,"Mary",3.36]
[null,{"$f":"SUBTOTAL(3,$C$5:C13)","v":9},"Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,{"$f":"SUBTOTAL(3,$C$5:C14)","v":10},"Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"IF & ROW","index":7,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Combining IF & Row Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"Serial Number","Name","CGPA",null,null,null,"Serial Number","Name","CGPA"]
[null,{"$f":"IF(C5=\"\",\"\",ROW()-ROW($B$4))","v":1},"Ron",3.81,null,null,null,null,"Ron",3.81]
[null,{"$f":"IF(C6=\"\",\"\",ROW()-ROW($B$4))","v":2},"Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,3,"Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,4,"David",3.68,null,null,null,null,"David",3.68]
[null,5,"Lily",3.59,null,null,null,null,"Lily",3.59]
[null,6,"Robert",3.53,null,null,null,null,"Robert",3.53]
[null,7,"Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,8,"Mary",3.36,null,null,null,null,"Mary",3.36]
[null,9,"Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,10,"Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"OFFSET","index":8,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using OFFSET Function ",null,null,null,null,null,"Try Yourself"]
[]
[null,null,"Name","CGPA",null,null,null,null,"Name","CGPA"]
[null,{"$f":"OFFSET(B5,-1,0)+1","v":1},"Ron",3.81,null,null,null,null,"Ron",3.81]
[null,{"$f":"OFFSET(B6,-1,0)+1","v":2},"Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,3,"Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,4,"David",3.68,null,null,null,null,"David",3.68]
[null,5,"Lily",3.59,null,null,null,null,"Lily",3.59]
[null,6,"Robert",3.53,null,null,null,null,"Robert",3.53]
[null,7,"Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,8,"Mary",3.36,null,null,null,null,"Mary",3.36]
[null,9,"Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,10,"Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"TEXT & ROW","index":9,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using TEXT & ROW Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"Serial Number","Name","CGPA",null,null,null,"Serial Number","Name","CGPA"]
[null,{"$f":"TEXT(ROW()-ROW($B$5)+1,\"0\")","v":"1"},"Ron",3.81,null,null,null,null,"Ron",3.81]
[null,{"$f":"TEXT(ROW()-ROW($B$5)+1,\"0\")","v":"2"},"Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,"3","Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,"4","David",3.68,null,null,null,null,"David",3.68]
[null,"5","Lily",3.59,null,null,null,null,"Lily",3.59]
[null,"6","Robert",3.53,null,null,null,null,"Robert",3.53]
[null,"7","Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,"8","Mary",3.36,null,null,null,null,"Mary",3.36]
[null,"9","Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,"10","Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"Add 1","index":10,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Adding 1 to Previous Number",null,null,null,null,null,"Try Yourself"]
[]
[null,"Serial Number","Name","CGPA",null,null,null,"Serial Number","Name","CGPA"]
[null,1,"Ron",3.81,null,null,null,null,"Ron",3.81]
[null,{"$f":"B5+1","v":2},"Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,{"$f":"B6+1","v":3},"Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,4,"David",3.68,null,null,null,null,"David",3.68]
[null,5,"Lily",3.59,null,null,null,null,"Lily",3.59]
[null,6,"Robert",3.53,null,null,null,null,"Robert",3.53]
[null,7,"Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,8,"Mary",3.36,null,null,null,null,"Mary",3.36]
[null,9,"Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,10,"Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"Name Manager","index":11,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using Name Manager",null,null,null,null,null,"Try Yourself"]
[]
[null,"Serial Number","Name","CGPA",null,null,null,"Serial Number","Name","CGPA"]
[null,{"$f":"SUM(Serial_Number,1)","v":1},"Ron",3.81,null,null,null,null,"Ron",3.81]
[null,{"$f":"SUM(Serial_Number,1)","v":2},"Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,3,"Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,4,"David",3.68,null,null,null,null,"David",3.68]
[null,5,"Lily",3.59,null,null,null,null,"Lily",3.59]
[null,6,"Robert",3.53,null,null,null,null,"Robert",3.53]
[null,7,"Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,8,"Mary",3.36,null,null,null,null,"Mary",3.36]
[null,9,"Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,10,"Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"Filter","index":12,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,1,1,3],[17,1,17,3]]}
[]
[null,"Dynamic Serial Numbers Using Filter"]
[]
[null,"Serial Number","Name","CGPA"]
[null,{"$f":"SUBTOTAL(3,$C$5:C5)","v":1},"Ron",3.81]
[null,{"$f":"SUBTOTAL(3,$C$5:C6)","v":2},"Anderson",3.79]
[null,{"$f":"SUBTOTAL(3,$C$5:C7)","v":3},"Rebecca",3.75]
[null,{"$f":"SUBTOTAL(3,$C$5:C8)","v":3},"David",3.68]
[null,{"$f":"SUBTOTAL(3,$C$5:C9)","v":3},"Lily",3.59]
[null,{"$f":"SUBTOTAL(3,$C$5:C10)","v":3},"Robert",3.53]
[null,{"$f":"SUBTOTAL(3,$C$5:C11)","v":4},"Pammela",3.47]
[null,{"$f":"SUBTOTAL(3,$C$5:C12)","v":5},"Mary",3.36]
[null,{"$f":"SUBTOTAL(3,$C$5:C13)","v":6},"Daniel",3.28]
[null,{"$f":"SUBTOTAL(3,$C$5:C14)","v":7},"Jacob",3.22]
[]
[]
[]
[null,"Try Yourself"]
[]
[null,"Serial Number","Name","CGPA"]
[null,null,"Ron",3.81]
[null,null,"Anderson",3.79]
[null,null,"Rebecca",3.75]
[null,null,"David",3.68]
[null,null,"Lily",3.59]
[null,null,"Robert",3.53]
[null,null,"Pammela",3.47]
[null,null,"Mary",3.36]
[null,null,"Daniel",3.28]
[null,null,"Jacob",3.22]

{"sheet":"Table","index":13,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Serial Number in a Table",null,null,null,null,null,"Try Yourself"]
[]
[null,"Serial Number","Name","CGPA",null,null,null,"Serial Number","Name","CGPA"]
[null,1,"Ron",3.81]
[null,{"$f":"B5+1","v":2},"Anderson",3.79]
[null,{"$f":"B6+1","v":3},"Rebecca",3.75]

{"sheet":"Pivot Table","index":14,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,10,1,12]]}
[]
[null,"Serial Number in a Pivot Table",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Serial Number","Name","Department",null,"Row Labels","Sum of Serial Number",null,null,null,"Serial Number","Name","Department"]
[null,1,"Anderson","EEE",null,"Anderson",1,null,null,null,null,"Anderson","EEE"]
[null,1,"Daniel","CSE",null,"Daniel",2,null,null,null,null,"Daniel","CSE"]
[null,1,"David","EEE",null,"David",3,null,null,null,null,"David","EEE"]
[null,1,"Jacob","ME",null,"Jacob",4,null,null,null,null,"Jacob","ME"]
[null,1,"Lily","ME",null,"Lily",5,null,null,null,null,"Lily","ME"]
[null,1,"Mary","CE",null,"Mary",6,null,null,null,null,"Mary","CE"]
[null,1,"Pammela","EEE",null,"Pammela",7,null,null,null,null,"Pammela","EEE"]
[null,1,"Rebecca","CE",null,"Rebecca",8,null,null,null,null,"Rebecca","CE"]
[null,1,"Robert","ME",null,"Robert",9,null,null,null,null,"Robert","ME"]
[null,1,"Ron","CSE",null,"Ron",10,null,null,null,null,"Ron","CSE"]

{"sheet":"Power Pivot","index":15,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,9]]}
[]
[null,"Using Power Pivot",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","Department",null,"Row Labels","Sum of Index",null,null,"Name","Department"]
[null,"Anderson","EEE",null,"Anderson",1,null,null,"Anderson","EEE"]
[null,"Daniel","CSE",null,"Daniel",2,null,null,"Daniel","CSE"]
[null,"David","EEE",null,"David",3,null,null,"David","EEE"]
[null,"Jacob","ME",null,"Jacob",4,null,null,"Jacob","ME"]
[null,"Lily","ME",null,"Lily",5,null,null,"Lily","ME"]
[null,"Mary","CE",null,"Mary",6,null,null,"Mary","CE"]
[null,"Pammela","EEE",null,"Pammela",7,null,null,"Pammela","EEE"]
[null,"Rebecca","CE",null,"Rebecca",8,null,null,"Rebecca","CE"]
[null,"Robert","ME",null,"Robert",9,null,null,"Robert","ME"]
[null,"Ron","CSE",null,"Ron",10,null,null,"Ron","CSE"]

{"sheet":"Power Query","index":16,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,10]]}
[]
[null,"Using Power Query",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","CGPA",null,"Name","CGPA","Index",null,null,"Name","CGPA"]
[null,"Ron",3.81,null,"Ron",3.81,1,null,null,"Ron",3.81]
[null,"Anderson",3.79,null,"Anderson",3.79,2,null,null,"Anderson",3.79]
[null,"Rebecca",3.75,null,"Rebecca",3.75,3,null,null,"Rebecca",3.75]
[null,"David",3.68,null,"David",3.68,4,null,null,"David",3.68]
[null,"Lily",3.59,null,"Lily",3.59,5,null,null,"Lily",3.59]
[null,"Robert",3.53,null,"Robert",3.53,6,null,null,"Robert",3.53]
[null,"Pammela",3.47,null,"Pammela",3.47,7,null,null,"Pammela",3.47]
[null,"Mary",3.36,null,"Mary",3.36,8,null,null,"Mary",3.36]
[null,"Daniel",3.28,null,"Daniel",3.28,9,null,null,"Daniel",3.28]
[null,"Jacob",3.22,null,"Jacob",3.22,10,null,null,"Jacob",3.22]

{"sheet":"Connection Property","index":17,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,10]]}
[]
[null,"Using Connection Properties of Connected Tables",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Name","CGPA",null,"_RowNum","Name","CGPA",null,null,"Name","CGPA"]
[null,"Ron",3.81,null,0,"Ron",3.81,null,null,"Ron",3.81]
[null,"Anderson",3.79,null,1,"Anderson",3.79,null,null,"Anderson",3.79]
[null,"Rebecca",3.75,null,2,"Rebecca",3.75,null,null,"Rebecca",3.75]
[null,"David",3.68,null,3,"David",3.68,null,null,"David",3.68]
[null,"Lily",3.59,null,4,"Lily",3.59,null,null,"Lily",3.59]
[null,"Robert",3.53,null,5,"Robert",3.53,null,null,"Robert",3.53]
[null,"Pammela",3.47,null,6,"Pammela",3.47,null,null,"Pammela",3.47]
[null,"Mary",3.36,null,7,"Mary",3.36,null,null,"Mary",3.36]
[null,"Daniel",3.28,null,8,"Daniel",3.28,null,null,"Daniel",3.28]
[null,"Jacob",3.22,null,9,"Jacob",3.22,null,null,"Jacob",3.22]

{"sheet":"VBA","index":18,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Serial Number with VBA",null,null,null,null,null,"Try Yourself"]
[]
[null,"Serial Number","Name","CGPA",null,null,null,"Serial Number","Name","CGPA"]
[null,1,"Ron",3.81,null,null,null,null,"Ron",3.81]
[null,2,"Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,3,"Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,4,"David",3.68,null,null,null,null,"David",3.68]
[null,5,"Lily",3.59,null,null,null,null,"Lily",3.59]
[null,6,"Robert",3.53,null,null,null,null,"Robert",3.53]
[null,7,"Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,8,"Mary",3.36,null,null,null,null,"Mary",3.36]
[null,9,"Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,10,"Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"Roman","index":19,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Roman Number",null,null,null,null,null,"Try Yourself"]
[]
[null,"Serial Number","Name","CGPA",null,null,null,"Serial Number","Name","CGPA"]
[null,{"$f":"ROMAN(ROW()-ROW($B$4))","v":"I"},"Ron",3.81,null,null,null,null,"Ron",3.81]
[null,{"$f":"ROMAN(ROW()-ROW($B$4))","v":"II"},"Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,"III","Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,"IV","David",3.68,null,null,null,null,"David",3.68]
[null,"V","Lily",3.59,null,null,null,null,"Lily",3.59]
[null,"VI","Robert",3.53,null,null,null,null,"Robert",3.53]
[null,"VII","Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,"VIII","Mary",3.36,null,null,null,null,"Mary",3.36]
[null,"IX","Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,"X","Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"Dates","index":20,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Adding Serial Dates in a Column",null,null,null,null,null,"Try Yourself"]
[]
[null,"Interview Date","Name","CGPA",null,null,null,"Interview Date","Name","CGPA"]
[null,"2023-01-01","Ron",3.81,null,null,null,null,"Ron",3.81]
[null,"2023-01-02","Anderson",3.79,null,null,null,null,"Anderson",3.79]
[null,"2023-01-03","Rebecca",3.75,null,null,null,null,"Rebecca",3.75]
[null,"2023-01-04","David",3.68,null,null,null,null,"David",3.68]
[null,"2023-01-05","Lily",3.59,null,null,null,null,"Lily",3.59]
[null,"2023-01-06","Robert",3.53,null,null,null,null,"Robert",3.53]
[null,"2023-01-07","Pammela",3.47,null,null,null,null,"Pammela",3.47]
[null,"2023-01-08","Mary",3.36,null,null,null,null,"Mary",3.36]
[null,"2023-01-09","Daniel",3.28,null,null,null,null,"Daniel",3.28]
[null,"2023-01-10","Jacob",3.22,null,null,null,null,"Jacob",3.22]

{"sheet":"Number to Date","index":21,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Converting Serial Numbers to Serial Dates",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Serial Number","Interview Date","Name","CGPA",null,null,null,"Serial Number","Interview Date","Name","CGPA"]
[null,1,{"$f":"DATE(2023,1,B5)","v":"2023-01-01"},"Ron",3.81,null,null,null,1,null,"Ron",3.81]
[null,2,{"$f":"DATE(2023,1,B6)","v":"2023-01-02"},"Anderson",3.79,null,null,null,2,null,"Anderson",3.79]
[null,3,"2023-01-03","Rebecca",3.75,null,null,null,3,null,"Rebecca",3.75]
[null,4,"2023-01-04","David",3.68,null,null,null,4,null,"David",3.68]
[null,5,"2023-01-05","Lily",3.59,null,null,null,5,null,"Lily",3.59]
[null,6,"2023-01-06","Robert",3.53,null,null,null,6,null,"Robert",3.53]
[null,7,"2023-01-07","Pammela",3.47,null,null,null,7,null,"Pammela",3.47]
[null,8,"2023-01-08","Mary",3.36,null,null,null,8,null,"Mary",3.36]
[null,9,"2023-01-09","Daniel",3.28,null,null,null,9,null,"Daniel",3.28]
[null,10,"2023-01-10","Jacob",3.22,null,null,null,10,null,"Jacob",3.22]