{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["RAND & Round Function","RANDBETWEEN","DifferentCell","RANDARRAY","Analysis Toolpak","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":"RAND & Round Function","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of RAND and ROUND Functions"]
[]
[null,"Name","Phone Number"]
[null,"John",{"$f":"ROUND(RAND()*9999999999+1,0)","v":5444628158}]
[null,"Chris",{"$f":"ROUND(RAND()*9999999999+1,0)","v":6329751361}]
[null,"Rick",2479004451]
[null,"Lisa",3487728881]
[null,"Tony",6702618082]

{"sheet":"RANDBETWEEN","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of RANDBETWEEN Function"]
[]
[null,"Name","Phone Number"]
[null,"John",{"$f":"RANDBETWEEN(1000000000,9999999999)","v":4800010679}]
[null,"Chris",{"$f":"ROUND(RAND()*10000000000+1,0)","v":4905842055}]
[null,"Rick",1507412607]
[null,"Lisa",7919607566]
[null,"Tony",{"$f":"ROUND(RAND()*10000000000+1,0)","v":3104198788}]

{"sheet":"DifferentCell","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Based on Typed Digits"]
[]
[null,"Name ","Number of Digits","Phone Number"]
[null,"John",10,{"$f":"LEFT(RANDBETWEEN(1,9)&RANDBETWEEN(0,999999999999999)&RANDBETWEEN(0,999999999999999), C5)","v":"4665251565"}]
[null,"Chris",10,{"$f":"LEFT(RANDBETWEEN(1,9)&RANDBETWEEN(0,999999999999999)&RANDBETWEEN(0,999999999999999), C6)","v":"9745395852"}]
[null,"Rick",10,{"$f":"LEFT(RANDBETWEEN(1,9)&RANDBETWEEN(0,999999999999999)&RANDBETWEEN(0,999999999999999), C7)","v":"4959283324"}]
[null,"Lisa",10,{"$f":"LEFT(RANDBETWEEN(1,9)&RANDBETWEEN(0,999999999999999)&RANDBETWEEN(0,999999999999999), C8)","v":"9925126924"}]
[null,"Tony",10,"8469059491"]

{"sheet":"RANDARRAY","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of RANDARRAY Function"]
[]
[null,"Name","Phone Number-1","Phone Number-2"]
[null,"John",{"$f":"_xlfn.RANDARRAY(5,2,1000000000,9999999999,TRUE)","v":6680734540},2013493551]
[null,"Chris",3070811219,7649984964]
[null,"Rick",4435742463,9024523749]
[null,"Lisa",4315996057,4961080935]
[null,"Tony",6264885904,4958655063]

{"sheet":"Analysis Toolpak","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of Analysis Toolpak"]
[]
[null,"Name","Phone Number"]
[null,"John",2066713462.3011873]
[null,"Chris",4597308267.544755]
[null,"Rick",3888668477.6538286]
[null,"Lisa",3076265755.5652642]
[null,"Tony",6197393719.0512714]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA"]
[]
[null,"Name","Phone Number"]
[null,"John",7055475115]
[null,"Chris",5334240198]
[null,"Rick",5795186161]
[null,"Lisa",2895624637]
[null,"Tony",3019480109]