{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["User List from Eclass","String to Gen. Passwords"],"read":"whole","date_system":"1900"}

{"sheet":"User List from Eclass","index":0,"n_rows":44,"n_cols":6,"rows_kept":44}
["First name","Last name","Email address","Username","Password","AddUserLine Followed by Add to group lines"]
["A","a","ab@southern.edu",{"$f":"LEFT(C2,FIND(\"@\",C2)-1)","v":"ab"},"z36Hynyghg",{"$f":"\"New-ADUser -Name \"\"\" & A2 & \" \" & B2 & \"\"\" -GivenName \"\"\" & A2 & \"\"\" -Surname \"\"\" & B2 & \"\"\" -SamAccountName \"\"\" & D2 & \"\"\" -Path \"\"OU=OU_Students,DC=cs,DC=southern,DC=edu\"\" -AccountPassword (ConvertTo-SecureString \"\"\" & E2 & \"\"\" -AsPlainText -Force) -Enabled $true\"","v":"New-ADUser -Name \"A a\" -GivenName \"A\" -Surname \"a\" -SamAccountName \"ab\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"z36Hynyghg\" -AsPlainText -Force) -Enabled $true"}]
[{"$f":"CHAR(CODE(A2)+1)","v":"B"},{"$f":"CHAR(CODE(B2)+1)","v":"b"},{"$f":"A3&B3&\"@southern.edu\"","v":"Bb@southern.edu"},"Bb","t5FCd__i}_",{"$f":"\"New-ADUser -Name \"\"\" & A3 & \" \" & B3 & \"\"\" -GivenName \"\"\" & A3 & \"\"\" -Surname \"\"\" & B3 & \"\"\" -SamAccountName \"\"\" & D3 & \"\"\" -Path \"\"OU=OU_Students,DC=cs,DC=southern,DC=edu\"\" -AccountPassword (ConvertTo-SecureString \"\"\" & E3 & \"\"\" -AsPlainText -Force) -Enabled $true\"","v":"New-ADUser -Name \"B b\" -GivenName \"B\" -Surname \"b\" -SamAccountName \"Bb\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"t5FCd__i}_\" -AsPlainText -Force) -Enabled $true"}]
[{"$f":"CHAR(CODE(A3)+1)","v":"C"},{"$f":"CHAR(CODE(B3)+1)","v":"c"},{"$f":"A4&B4&\"@southern.edu\"","v":"Cc@southern.edu"},"Cc","n2:Onifltv","New-ADUser -Name \"C c\" -GivenName \"C\" -Surname \"c\" -SamAccountName \"Cc\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"n2:Onifltv\" -AsPlainText -Force) -Enabled $true"]
["D","d","Dd@southern.edu","Dd","y385mvdf`t","New-ADUser -Name \"D d\" -GivenName \"D\" -Surname \"d\" -SamAccountName \"Dd\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"y385mvdf`t\" -AsPlainText -Force) -Enabled $true"]
["E","e","Ee@southern.edu","Ee","x7BV_ot{{n","New-ADUser -Name \"E e\" -GivenName \"E\" -Surname \"e\" -SamAccountName \"Ee\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"x7BV_ot{{n\" -AsPlainText -Force) -Enabled $true"]
["F","f","Ff@southern.edu","Ff","w3SJ^e]vd`","New-ADUser -Name \"F f\" -GivenName \"F\" -Surname \"f\" -SamAccountName \"Ff\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"w3SJ^e]vd`\" -AsPlainText -Force) -Enabled $true"]
["G","g","Gg@southern.edu","Gg","t82Lw__psm","New-ADUser -Name \"G g\" -GivenName \"G\" -Surname \"g\" -SamAccountName \"Gg\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"t82Lw__psm\" -AsPlainText -Force) -Enabled $true"]
["H","h","Hh@southern.edu","Hh","p6IOnzgeyx","New-ADUser -Name \"H h\" -GivenName \"H\" -Surname \"h\" -SamAccountName \"Hh\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"p6IOnzgeyx\" -AsPlainText -Force) -Enabled $true"]
["I","i","Ii@southern.edu","Ii","u7?[vijjem","New-ADUser -Name \"I i\" -GivenName \"I\" -Surname \"i\" -SamAccountName \"Ii\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"u7?[vijjem\" -AsPlainText -Force) -Enabled $true"]
["J","j","Jj@southern.edu","Jj","p840`zovxu","New-ADUser -Name \"J j\" -GivenName \"J\" -Surname \"j\" -SamAccountName \"Jj\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"p840`zovxu\" -AsPlainText -Force) -Enabled $true"]
["K","k","Kk@southern.edu","Kk","u4:A``snbd","New-ADUser -Name \"K k\" -GivenName \"K\" -Surname \"k\" -SamAccountName \"Kk\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"u4:A``snbd\" -AsPlainText -Force) -Enabled $true"]
["L","l","Ll@southern.edu","Ll","k16Wis_~qo","New-ADUser -Name \"L l\" -GivenName \"L\" -Surname \"l\" -SamAccountName \"Ll\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"k16Wis_~qo\" -AsPlainText -Force) -Enabled $true"]
["M","m","Mm@southern.edu","Mm","w0LLyejbdj","New-ADUser -Name \"M m\" -GivenName \"M\" -Surname \"m\" -SamAccountName \"Mm\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"w0LLyejbdj\" -AsPlainText -Force) -Enabled $true"]
["N","n","Nn@southern.edu","Nn","x9UN}qkwl^","New-ADUser -Name \"N n\" -GivenName \"N\" -Surname \"n\" -SamAccountName \"Nn\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"x9UN}qkwl^\" -AsPlainText -Force) -Enabled $true"]
["O","o","Oo@southern.edu","Oo","w6HY`oyagw","New-ADUser -Name \"O o\" -GivenName \"O\" -Surname \"o\" -SamAccountName \"Oo\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"w6HY`oyagw\" -AsPlainText -Force) -Enabled $true"]
["P","p","Pp@southern.edu","Pp","u0XZex_usu","New-ADUser -Name \"P p\" -GivenName \"P\" -Surname \"p\" -SamAccountName \"Pp\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"u0XZex_usu\" -AsPlainText -Force) -Enabled $true"]
["Q","q","Qq@southern.edu","Qq","v7[Iow~pna","New-ADUser -Name \"Q q\" -GivenName \"Q\" -Surname \"q\" -SamAccountName \"Qq\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"v7[Iow~pna\" -AsPlainText -Force) -Enabled $true"]
["R","r","Rr@southern.edu","Rr","l77Ytmh}}o","New-ADUser -Name \"R r\" -GivenName \"R\" -Surname \"r\" -SamAccountName \"Rr\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"l77Ytmh}}o\" -AsPlainText -Force) -Enabled $true"]
["S","s","Ss@southern.edu","Ss","x2VCndc{ob","New-ADUser -Name \"S s\" -GivenName \"S\" -Surname \"s\" -SamAccountName \"Ss\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"x2VCndc{ob\" -AsPlainText -Force) -Enabled $true"]
["T","t","Tt@southern.edu","Tt","q6L1wubqyz","New-ADUser -Name \"T t\" -GivenName \"T\" -Surname \"t\" -SamAccountName \"Tt\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"q6L1wubqyz\" -AsPlainText -Force) -Enabled $true"]
["U","u","Uu@southern.edu","Uu","q17<g^zr{u","New-ADUser -Name \"U u\" -GivenName \"U\" -Surname \"u\" -SamAccountName \"Uu\" -Path \"OU=OU_Students,DC=cs,DC=southern,DC=edu\" -AccountPassword (ConvertTo-SecureString \"q17<g^zr{u\" -AsPlainText -Force) -Enabled $true"]
[]
[{"$nulls":5},{"$f":"\"Add-ADGroupMember -Identity students -Members \" & D2","v":"Add-ADGroupMember -Identity students -Members ab"}]
[{"$nulls":5},{"$f":"\"Add-ADGroupMember -Identity students -Members \" & D3","v":"Add-ADGroupMember -Identity students -Members Bb"}]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Cc"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Dd"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Ee"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Ff"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Gg"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Hh"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Ii"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Jj"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Kk"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Ll"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Mm"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Nn"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Oo"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Pp"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Qq"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Rr"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Ss"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Tt"]
[{"$nulls":5},"Add-ADGroupMember -Identity students -Members Uu"]

{"sheet":"String to Gen. Passwords","index":1,"n_rows":1,"n_cols":2,"rows_kept":1}
["Password Gen: ","CHAR(RANDBETWEEN(97,122)) & CHAR(RANDBETWEEN(48,57))& CHAR(RANDBETWEEN(48,91))& CHAR(RANDBETWEEN(48,91))& CHAR(RANDBETWEEN(93,126))& CHAR(RANDBETWEEN(93,126))& CHAR(RANDBETWEEN(93,126))& CHAR(RANDBETWEEN(93,126))& CHAR(RANDBETWEEN(93,126))& CHAR(RANDBETWEEN(93,126))"]