{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["What do you want to do","Look-up page 1","Create New Division","Create New Section","Create New Branch","Rename an Object","Move an OrgPath Object","Resources"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":5,"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":"What do you want to do","index":0,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[12,3,12,7],[14,3,14,7],[16,3,16,7],[0,1,0,10],[2,1,2,10],[7,1,8,1],[8,3,8,7],[10,3,10,7]]}
[null,"Organizational Path Objects Worksheet"]
[]
[null,"This workbook contains five worksheets which are completed by the Agency to assist BEST with making changes to Organizational (Org) Path objects (division, section and/or branch). Click on the hyperlink to automatically move to the worksheet. A brief explanation on when each worksheet is used is provided below the hyperlink. Please refer to the worksheet for additional instructions and tips."]
[]
[null,"To get started, please select your personnel area: ",null,"Select",null,"Agency:",{"$f":"VLOOKUP(D5,'Look-up page 1'!A2:E39,2,FALSE)","v":"#"}]
[]
[]
[null,"What do you want to do?",null,"Create a New Division"]
[null,null,null,"All agencies use divisions.  Use this tab to create a new division."]
[null,null,null,"Create a New Section"]
[null,null,null,"All agencies use sections.  Use this tab to create a new section."]
[null,null,null,"Create a New Branch"]
[null,null,null,"Only some agencies use branches.  Use this tab to create a new branch."]
[null,null,null,"Rename an Org Path Object"]
[null,null,null,"Use this tab to rename an Org Path object(s)."]
[null,null,null,"Move an Org Path Object"]
[null,null,null,"This tab is used to change the relationship of an Org Path object to another Org Path object."]
[null,null,null,"Note: To move org units to a new section or branch use the Organizational Management Change Spreadsheet."]

{"sheet":"Look-up page 1","index":1,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
["PersArea","Agency Name","Branches?","Agency Object"]
["Select","#"]
[201,"Judicial Branch","7L",70000052,"Sections with branches"]
[301,"Office of the Governor","7S",70000006,"Sections w/o branches"]
[310,"Office of State Budget and Management","7S",70000005,"Sections w/o branches"]
[401,"Office of the Lieutenant Governor","7S",70000001,"Sections w/o branches"]
[501,"Dept of the Secretary of State","7S",70000028,"Sections w/o branches"]
[601,"Office of the State Auditor","7S",70000034,"Sections w/o branches"]
[701,"Dept of State Treasurer","7L",70000029,"Sections with branches"]
[801,"Dept of Public Instruction","7L",70000027,"Sections with branches"]
[901,"Dept of Justice","7L",70000024,"Sections with branches"]
[1001,"Dept of Agriculture & Consumer Services","7L",70000016,"Sections with branches"]
[1101,"Dept of Labor","7S",70000026,"Sections w/o branches"]
[1201,"Dept of Insurance","7L",70000023,"Sections with branches"]
[1301,"Dept of Administration","7L",70000000,"Sections with branches"]
[1401,"Office of the State Controller","7L",70000008,"Sections with branches"]
[1501,"Dept of Transportation","7L",70000002,"Sections with branches"]
[1601,"Dept of Environmental Quality","7L",70000021,"Sections with branches"]
[1701,"Wildlife Resources Commission","7S",70000036,"Sections w/o branches"]
[1901,"Dept of Public Safety","7L",70000075,"Sections with branches"]
[2001,"Dept of Health and Human Services","7L",70000022,"Sections with branches"]
[4001,"Dept Military & Veterans Affairs","7L",70000018,"Sections with branches"]
[4101,"Office of Information Technology Servcs","7L",70000004,"Sections with branches"]
[4301,"Dept of Commerce","7S",70000039,"Sections w/o branches"]
[4501,"Dept of Revenue","7L",70000003,"Sections with branches"]
[4601,"Dept of Natural & Cultural Resources","7L",70000020,"Sections with branches"]
[5001,"Community College System","7L",70000017,"Sections with branches"]
[5201,"Adult Correction","7L",70000076,"Section with branches"]
[6701,"Office of Administrative Hearings","7S",70000050,"Sections w/o branches"]
[8701,"North Carolina School of Science & Math","7S",70000032,"Sections w/o branches"]
["B001","State Board of Barber Examiners","7S",70000014,"Sections w/o branches"]
["B005","State Board of Cosmetic Art Examiners","7S",70000037,"Sections w/o branches"]
["B010","State Board of Opticians","7S",70000011,"Sections w/o branches"]
["B015","State Board of Psychology","7S",70000012,"Sections w/o branches"]
["B020","State Board of Auctioneer Licensing","7S",70000013,"Sections w/o branches"]
["B025","State Board of Elections","7S",70000009,"Sections w/o branches"]
["B030","State Ethics Commission","7S",70000010,"Sections w/o branches"]
["Z101","Office of State Human Resources","7S",70000007,"Sections w/o branches"]
["Z105","Temporary Solutions","7S",70000007,"Sections w/o branches"]
[]
[]
["7D - Division"]
["7L - Section w/ Branches"]
["7S - Section w/o Branches"]
["7B - Branch"]

{"sheet":"Create New Division","index":2,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[7,1,7,4],[28,1,30,4],[32,1,36,4],[8,5,9,5]]}
[]
[null,null,null,"CREATE NEW DIVISION"]
[]
[null,"Agency:",{"$f":"VLOOKUP('What do you want to do'!D5,'Look-up page 1'!A2:B39,2,FALSE)","v":"#"},"Contact info:"]
[null,"Requested By:",null,"Email:"]
[null,"Effective Date:",null,"Phone:"]
[]
[null,"Instructions:",null,null,null,"FOR BEST USE ONLY"]
[null,null,null,null,null,"New Division Number"]
[null,"New Division Abbreviation","New Division Name","Parent Agency Object ID#","Parent Object Name"]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,null,null,{"$f":"IFERROR(VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[null,"Message from BEST"]
[null,{"$f":"IFERROR(\"The personnel area chosen (\"&'What do you want to do'!$D$5&\", \"&'What do you want to do'!$G$5&\"), has a top level agency object of \"&VLOOKUP('What do you want to do'!$D$5,'Look-up page 1'!$A$3:$D$39,4,FALSE),\" \")","v":" "}]
[]
[]
[null,"Agency Comments"]

{"sheet":"Create New Section","index":3,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,1,8,4],[29,1,31,4],[33,1,37,4],[9,5,10,5]]}
[]
[null,null,null,"CREATE NEW SECTION"]
[]
[null,"Agency:",{"$f":"VLOOKUP(C7,'Look-up page 1'!A2:B39,2,FALSE)","v":"#"},"Contact info:"]
[null,"Requested By:",null,"Email:"]
[null,"Effective Date:",null,"Phone:"]
[null,"Personnel Area:",{"$f":"'What do you want to do'!D5","v":"Select"}]
[]
[null,"Instructions:",null,null,null,"FOR BEST USE ONLY"]
[null,null,null,null,null,"New Section Number"]
[null,"New Section Abbreviation","New Section Name","Parent Division Object ID#","Parent Object Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Message from BEST"]
[null,{"$f":"IFERROR(\"Based on the personnel area, this agency uses \"&VLOOKUP(C7,'Look-up page 1'!$A$3:$E$39,5,FALSE),\" \")","v":" "}]
[]
[]
[null,"Agency Comments"]

{"sheet":"Create New Branch","index":4,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,1,8,4],[29,1,31,4],[33,1,37,4],[1,1,2,2],[9,5,10,5]]}
[]
[null,"You've chosen an agency that does not use branches, therefore you should have no need of this tab!",null,"CREATE NEW BRANCH",null,{"$f":"VLOOKUP(C7,'Look-up page 1'!A3:C39,3,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,"Agency:",{"$f":"VLOOKUP(C7,'Look-up page 1'!A2:B39,2,FALSE)","v":"#"},"Contact info:"]
[null,"Requested By:",null,"Email:"]
[null,"Effective Date:",null,"Phone:"]
[null,"Personnel Area:",{"$f":"'What do you want to do'!D5","v":"Select"}]
[]
[null,"Instructions:",null,null,null,"FOR BEST USE ONLY"]
[null,null,null,null,null,"New Branch Number"]
[null,"New Branch Abbreviation","New Branch Name","Parent Section Object ID#","Parent Object Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Message from BEST"]
[null,{"$f":"IFERROR(\"Based on the personnel area, this agency uses \"&VLOOKUP(C7,'Look-up page 1'!$A$3:$E$39,5,FALSE),\" \")","v":" "}]
[]
[]
[null,"Agency Comments"]

{"sheet":"Rename an Object","index":5,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,1,8,5],[29,1,31,5],[33,1,37,5]]}
[]
[null,null,null,"RENAME AN ORG PATH OBJECT"]
[]
[null,"Agency:",{"$f":"VLOOKUP(C7,'Look-up page 1'!A2:B39,2,FALSE)","v":"#"},null,"Contact info:"]
[null,"Requested By:",null,null,"Email:"]
[null,"Effective Date:",null,null,"Phone:"]
[null,"Personnel Area:",{"$f":"'What do you want to do'!D5","v":"Select"}]
[]
[null,"Instructions:"]
[]
[null,"Object Type","Object Number","Current Object Name","New Object Abbreviation","New Object Name"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Message from BEST"]
[]
[]
[]
[null,"Agency Comments"]

{"sheet":"Move an OrgPath Object","index":6,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,1,8,4],[29,1,31,4],[33,1,37,4]]}
[]
[null,null,null,"MOVE AN ORG PATH OBJECT"]
[]
[null,"Agency:",{"$f":"VLOOKUP(C7,'Look-up page 1'!A2:B39,2,FALSE)","v":"#"},"Contact info:"]
[null,"Requested By:",null,"Email:"]
[null,"Effective Date:",null,"Phone:"]
[null,"Personnel Area:",{"$f":"'What do you want to do'!D5","v":"Select"}]
[]
[null,"Instructions:"]
[]
[null,"Number of Object to be moved","Name of Object to be Moved","Number of New Parent Object","Name of New Parent Object"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Message from BEST"]
[]
[]
[]
[null,"Agency Comments"]

{"sheet":"Resources","index":7,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Personnel Area Code","Agency Name","Sections with Branches","Sections w/o Branches"]
[201,"Judicial Branch","ü"]
[301,"Office of the Governor",null,"ü"]
[310,"Office of State Budget and Management",null,"ü"]
[401,"Office of the Lieutenant Governor",null,"ü"]
[501,"Dept of the Secretary of State",null,"ü"]
[601,"Office of the State Auditor",null,"ü"]
[701,"Dept of State Treasurer","ü"]
[801,"Dept of Public Instruction","ü"]
[901,"Dept of Justice","ü"]
[1001,"Dept of Agriculture & Consumer Services","ü"]
[1101,"Dept of Labor","ü"]
[1201,"Dept of Insurance",null,"ü"]
[1301,"Dept of Administration","ü"]
[1401,"Office of the State Controller","ü"]
[1501,"Dept of Transportation","ü"]
[1601,"Dept of Environmental Quality","ü"]
[1701,"Wildlife Resources Commission",null,"ü"]
[1901,"Dept of Public Safety","ü"]
[2001,"Dept of Health and Human Services","ü"]
[4001,"Dept Military & Veterans Affairs","ü"]
[4101,"Office of Information Technology Servcs","ü"]
[4301,"Dept of Commerce","ü"]
[4501,"Dept of Revenue","ü"]
[4601,"Dept of Natural & Cultural Resources","ü"]
[5001,"Community College System","ü"]
[5201,"Adult Correction","ü"]
[6701,"Office of Administrative Hearings",null,"ü"]
[8701,"North Carolina School of Science & Math",null,"ü"]
["B001","State Board of Barber Examiners",null,"ü"]
["B005","State Board of Cosmetic Art Examiners",null,"ü"]
["B010","State Board of Opticians",null,"ü"]
["B015","State Board of Psychology",null,"ü"]
["B020","State Board of Auctioneer Licensing",null,"ü"]
["B025","State Board of Elections",null,"ü"]
["B030","State Ethics Commission",null,"ü"]
["Z101","Office of State Human Resources",null,"ü"]
["Z105","Temporary Solutions",null,"ü"]