{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Lookup"," Information - Please Read","Partner-Client Information","Vendor Organization Details","Vendor Admin Users","Email Notification Example"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":3,"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":"Lookup","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
["Regular - Recommended",30,"Yes","English (United Kingdom)"]
["High",45,"No","English (United States)"]
[null,60,null,"French (Canadian)"]
[null,90,null,"French (France)"]
[null,null,null,"German (Germany)"]
[null,null,null,"Portuguese(Brazil)"]
[null,null,null,"Spanish (Mexico)"]
[null,null,null,"Spanish (Spain)"]

{"sheet":" Information - Please Read","index":1,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Please complete this workbook for each vendor being requested"]
["Fill out each Tab from LEFT to RIGHT "]
["Please read the Comments and pull values from the drop down where needed"]
["Please fill out all required fields"]
[]
["Once completed save the workbook as a new file (the filename must include the word \"Vendor\")"]
["Submit a Zendesk Change Request Ticket and attach the form"]
["Estimated turnaround on completion will be within approximately 3 business days"]
[]
["Once the Vendor Org has been completed a Notification will be sent to the Completion Notification Email Address on the Partner-Client Information Tab and to vectorvms-support-group@vectorvms.com"]

{"sheet":"Partner-Client Information","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"This page is to be filled in by Partner / Client Administrators only."]
[]
[null,"Partner or Client Name"]
[]
[null,"Partner or Client Contact"]
[]
[null,"Completion Notification Email Address"]
[]
[]
[null,"Is an MSP Login Required?","No"]

{"sheet":"Vendor Organization Details","index":3,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
[]
[]
[]
[]
[null,"Vendor Information"]
[null,"Vendor Name",null,null,null,null,null,null,null,null," "," "," "]
[null,"Verify Vendor Name"]
[null,"Vendor Short Name"]
[]
[null,"Web Address"]
[]
[null,"Address 1"]
[null,"Address 2"]
[null,"CITY"]
[null,"STATE / COUNTY"]
[null,"ZIP / POSTCODE"]
[null,"COUNTRY"]
[]
[null,"Tax Id Number"]
[null,"Optional Employer ID Number 2"]
[null,"Optional Employer ID Number 3"]
[null,"Optional Employer ID Number 4"]

{"sheet":"Vendor Admin Users","index":4,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[6,1,6,2],[6,4,6,5],[6,7,6,8]]}
[]
[null,null,"Up to two admin users are created initially (only one is required) - further users can be created by the admin user"]
[null,null,"Admin users are assigned automatically as User 1 and User 2 on the Vendor Information page"]
[null,null,"Designate one Admin user as the Main Contact for the vendor.  That user will be assigned on the Vendor Information page."]
[null,null,"Login IDs are generated automatically based upon the first and last name entered and must be unique.  Do not enter multiple users with the exact same first and last names."]
[]
[null,"USER 1 Information",null,null,"USER 2 Information",null,null,"USER 3 Information"]
[null,"User 1 Login Id",null,null,"User 2 Login Id",null,null,"User 3 Login Id"]
[null,"User 1 First Name",null,null,"User 2 First Name",null,null,"User 3 First Name"]
[null,"User 1 Middle Initial",null,null,"User 2 Middle Initial",null,null,"User 3 Middle Initial"]
[null,"User 1 Last Name",null,null,"User 2 Last Name",null,null,"User 3 Last Name"]
[null,"Password",null,null,"Password",null,null,"Password"]
[null,"Email Address",null,null,"Email Address",null,null,"Email Address"]
[null,"User 1 Phone Number",null,null,"User 2 Phone Number",null,null,"User 3 Phone Number"]
[null,"User 1 Description",null,null,"User 2 Description",null,null,"User 3 Description"]
[null,"Main Contact? (Yes/No)","Yes",null,"Main Contact? (Yes/No)","No"]
[null,"Main Contact Phone Number",null,null,"Main Contact Phone Number"]
[null,"MSP User Login Id",null,null,"MSP User First Name","MSP User Middle Initial",null,"MSP User Last Name","Password ","Email Address","MSP User Phone Number"]
[null,{"$f":"CONCATENATE(E19&\".\"&H19)","v":"."}]

{"sheet":"Email Notification Example","index":5,"n_rows":34,"n_cols":1,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["To: Completion Notification Email Address\n"]
["cc: VectorVMS-Support-Group@vectorvms.com"]
["From: noreply@vectorvms.com"]
[]
["Subject: Vendor Org Created - \"Vendor Name\""]
[]
["Hello Completion Notification Email Address(before the @)"]
[]
["Your request to create vendor \"Vendor Name\" in \"Environment\" has been completed."]
[]
["Your organization Key is: \"Login Org ID\""]
[]
["Your System_Org_Id is : \"System_Org_Id\""]
[]
["Your requested users have been created as follows:  "]
[]
["User 1:  Name:  User 1 Full Name\n                Login:    Login Id\n                Password:  password"]
[]
["User 2:  Name:  User 2 Full Name\n                Login:    Login Id\n                Password:  password"]
[]
["User 3:  Name:  User 3 Full Name\n                Login:    Login Id\n                Password:  password"]
[]
["Please log in to your Client Organization, associate the new vendor  and complete the vendor configuration at your convenience."]
[]
["Thank You"]
[]
["VectorVMS Support Team"]
[]
["Email Example "]