{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","Ampersand","Format cells","IF","NUMBERVALUE","CONCATENATE","TEXTJOIN","LEFT, IF","Add number","VBA"],"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":"Dataset","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number"]
[null,"Ned-Stark","CEO",9083564879]
[null,"Robert-Baratheon","CFO",8783564889]
[null,"Daenerys-Targaryn","CBO",4893564890]
[null,"Jaime-Lannister","COO",1063564888]
[null,"Jon-Snow","Manager-(Operation)",6283563700]
[null,"Samwell-Tarly","Manager-(Sales)",8803502567]
[null,"Margaery-Tyrell","Manager-(Supply-Chain)",7783569971]
[null,"Jorah-Mormont","Manager-(HR)",9983566850]
[null,"Theon-Grejoy","Manager-(Finance)",1183565877]
[null,"Total"]

{"sheet":"Ampersand","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Outcome"]
[null,"Ned-Stark","CEO",9083564879,{"$f":"\"99\" &D6","v":"999083564879"}]
[null,"Robert-Baratheon","CFO",8783564889,"998783564889"]
[null,"Daenerys-Targaryn","CBO",4893564890,"994893564890"]
[null,"Jaime-Lannister","COO",1063564888,"991063564888"]
[null,"Jon-Snow","Manager-(Operation)",6283563700,"996283563700"]
[null,"Samwell-Tarly","Manager-(Sales)",8803502567,"998803502567"]
[null,"Margaery-Tyrell","Manager-(Supply-Chain)",7783569971,"997783569971"]
[null,"Jorah-Mormont","Manager-(HR)",9983566850,{"$f":"\"99\" &D13","v":"999983566850"}]
[null,"Theon-Grejoy","Manager-(Finance)",1183565877,{"$f":"\"99\" &D14","v":"991183565877"}]
[null,"Total"]

{"sheet":"Format cells","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Outcome"]
[null,"Ned-Stark","CEO",9083564879,9083564879]
[null,"Robert-Baratheon","CFO",8783564889,8783564889]
[null,"Daenerys-Targaryn","CBO",4893564890,4893564890]
[null,"Jaime-Lannister","COO",1063564888,1063564888]
[null,"Jon-Snow","Manager-(Operation)",6283563700,6283563700]
[null,"Samwell-Tarly","Manager-(Sales)",8803502567,8803502567]
[null,"Margaery-Tyrell","Manager-(Supply-Chain)",7783569971,7783569971]
[null,"Jorah-Mormont","Manager-(HR)",9983566850,9983566850]
[null,"Theon-Grejoy","Manager-(Finance)",1183565877,1183565877]
[null,"Total"]

{"sheet":"IF","index":3,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Outcome"]
[null,"Ned-Stark","CEO",9083564879,{"$f":"IF(D6, \"99\"&D6, \"\")","v":"999083564879"}]
[null,"Robert-Baratheon","CFO",8783564889,{"$f":"IF(D7, \"99\"&D7, \"\")","v":"998783564889"}]
[null,"Daenerys-Targaryn","CBO",4893564890,"994893564890"]
[null,"Jaime-Lannister","COO",1063564888,"991063564888"]
[null,"Jon-Snow","Manager-(Operation)",6283563700,"996283563700"]
[null,"Samwell-Tarly","Manager-(Sales)",8803502567,"998803502567"]
[null,"Margaery-Tyrell","Manager-(Supply-Chain)",7783569971,"997783569971"]
[null,"Jorah-Mormont","Manager-(HR)",9983566850,"999983566850"]
[null,"Theon-Grejoy","Manager-(Finance)",1183565877,"991183565877"]
[null,"Total"]

{"sheet":"NUMBERVALUE","index":4,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Outcome"]
[null,"Ned-Stark","CEO",9083564879,{"$f":"_xlfn.NUMBERVALUE(99&D6)","v":999083564879}]
[null,"Robert-Baratheon","CFO",8783564889,{"$f":"_xlfn.NUMBERVALUE(99&D7)","v":998783564889}]
[null,"Daenerys-Targaryn","CBO",4893564890,994893564890]
[null,"Jaime-Lannister","COO",1063564888,991063564888]
[null,"Jon-Snow","Manager-(Operation)",6283563700,996283563700]
[null,"Samwell-Tarly","Manager-(Sales)",8803502567,998803502567]
[null,"Margaery-Tyrell","Manager-(Supply-Chain)",7783569971,997783569971]
[null,"Jorah-Mormont","Manager-(HR)",9983566850,999983566850]
[null,"Theon-Grejoy","Manager-(Finance)",1183565877,991183565877]
[null,"Total"]

{"sheet":"CONCATENATE","index":5,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Outcome"]
[null,"Ned-Stark","CEO",9083564879,{"$f":"_xlfn.TEXTJOIN(\"\",1,99,D6)","v":"999083564879"}]
[null,"Robert-Baratheon","CFO",8783564889,{"$f":"_xlfn.TEXTJOIN(\"\",1,99,D7)","v":"998783564889"}]
[null,"Daenerys-Targaryn","CBO",4893564890,"994893564890"]
[null,"Jaime-Lannister","COO",1063564888,"991063564888"]
[null,"Jon-Snow","Manager-(Operation)",6283563700,"996283563700"]
[null,"Samwell-Tarly","Manager-(Sales)",8803502567,"998803502567"]
[null,"Margaery-Tyrell","Manager-(Supply-Chain)",7783569971,"997783569971"]
[null,"Jorah-Mormont","Manager-(HR)",9983566850,"999983566850"]
[null,"Theon-Grejoy","Manager-(Finance)",1183565877,"991183565877"]
[null,"Total"]

{"sheet":"TEXTJOIN","index":6,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Outcome"]
[null,"Ned-Stark","CEO",9083564879,{"$f":"_xlfn.TEXTJOIN(\"\",1,99,D6)","v":"999083564879"}]
[null,"Robert-Baratheon","CFO",8783564889,{"$f":"_xlfn.TEXTJOIN(\"\",1,99,D7)","v":"998783564889"}]
[null,"Daenerys-Targaryn","CBO",4893564890,"994893564890"]
[null,"Jaime-Lannister","COO",1063564888,"991063564888"]
[null,"Jon-Snow","Manager-(Operation)",6283563700,"996283563700"]
[null,"Samwell-Tarly","Manager-(Sales)",8803502567,"998803502567"]
[null,"Margaery-Tyrell","Manager-(Supply-Chain)",7783569971,"997783569971"]
[null,"Jorah-Mormont","Manager-(HR)",9983566850,"999983566850"]
[null,"Theon-Grejoy","Manager-(Finance)",1183565877,"991183565877"]
[null,"Total"]

{"sheet":"LEFT, IF","index":7,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Outcome"]
[null,"Ned-Stark","CEO","09083564879",{"$f":"IF(D6=\"\", \"\", (0+(LEFT(D6)=\"0\")&D6)+0)","v":109083564879}]
[null,"Robert-Baratheon","CFO","08783564889",{"$f":"IF(D7=\"\", \"\", (0+(LEFT(D7)=\"0\")&D7)+0)","v":108783564889}]
[null,"Daenerys-Targaryn","CBO","04893564890",104893564890]
[null,"Jaime-Lannister","COO","01063564888",101063564888]
[null,"Jon-Snow","Manager-(Operation)","06283563700",106283563700]
[null,"Samwell-Tarly","Manager-(Sales)","08803502567",108803502567]
[null,"Margaery-Tyrell","Manager-(Supply-Chain)","07783569971",107783569971]
[null,"Jorah-Mormont","Manager-(HR)","09983566850",109983566850]
[null,"Theon-Grejoy","Manager-(Finance)","01183565877",101183565877]

{"sheet":"Add number","index":8,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Helper","Outcome"]
[null,"Ned-Stark","CEO",9083564879,990000000000,{"$f":"D6+E6","v":999083564879}]
[null,"Robert-Baratheon","CFO",8783564889,990000000000,{"$f":"D7+E7","v":998783564889}]
[null,"Daenerys-Targaryn","CBO",4893564890,990000000000,994893564890]
[null,"Jaime-Lannister","COO",1063564888,990000000000,991063564888]
[null,"Jon-Snow","Manager-(Operation)",6283563700,990000000000,996283563700]
[null,"Samwell-Tarly","Manager-(Sales)",8803502567,990000000000,998803502567]
[null,"Margaery-Tyrell","Manager-(Supply-Chain)",7783569971,990000000000,997783569971]
[null,"Jorah-Mormont","Manager-(HR)",9983566850,990000000000,999983566850]
[null,"Theon-Grejoy","Manager-(Finance)",1183565877,990000000000,991183565877]
[null,"Total"]

{"sheet":"VBA","index":9,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Contact List of Hotel California"]
[]
[null,"Name","Designation","Phone Number","Outcome"]
[null,"Ned-Stark","CEO",9083564879,"009083564879"]
[null,"Robert-Baratheon","CFO",8783564889,"008783564889"]
[null,"Daenerys-Targaryn","CBO",4893564890,"004893564890"]
[null,"Jaime-Lannister","COO",1063564888,"001063564888"]
[null,"Jon-Snow","Manager-(Operation)",6283563700,"006283563700"]
[null,"Samwell-Tarly","Manager-(Sales)",8803502567,"008803502567"]
[null,"Margaery-Tyrell","Manager-(Supply-Chain)",7783569971,"007783569971"]
[null,"Jorah-Mormont","Manager-(HR)",9983566850,"009983566850"]
[null,"Theon-Grejoy","Manager-(Finance)",1183565877,"001183565877"]
[null,"Total"]