{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CoverSheet","Data_Entry","Hidden"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"CoverSheet","index":0,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[[5,1,7,9],[1,1,3,8],[24,3,24,14]]}
[]
[null,"Table Management System (TMGT) Table 005\nAgency Organizational Structure"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Version \" & MAX(IF(Hidden!A:A=\"Version\",Hidden!B:B))","v":"Version 2"}]
[]
[null,"The purpose of this workbook is to upload data from Excel into TMGT005.  This source workbook contains both worksheets and Excel VBA code modules.  "]
[]
[]
[]
["Process:"]
[]
["1)","Click on the Data_Entry tab to begin entering entries.  Notes some fields will be pre-filled or redisplayed."]
[null,"These are the concatenated Org-Structure, Begin-Effective-Date and End-Effective-Date. "]
[null," Example when you enter a \"BEGIN DATE\", the \"BEGIN DATE(JULIAN)\" is calculated."]
[]
["2)","Once you have completed all of your entries, save the file you created as \"Excel Macro-Enabled Workbook\""]
[]
["3)","Send the entire Excel file as an attachment to an email to  NFC.GESDREQUEST@nfc.usda.gov"]
[null,"In the subject line, please type \"TMGT Table 005 Excel Batch Update File\"."]
[]
["4)","Upon reciept of the file, NFC will extract the data file and test the integrity of the data.  If all records pass"]
[null,"the edit process, NFC will notify the sender and request authorization to update production.  If any errors are encountered, NFC will send an error listing for either re-submission by the sender or correction by NFC of"]
[null,"rejectected records, depending on the error type.  Once all records pass the edit process, after receiving authorization, NFC will update the records in production"]
[]
[null,null,null,"Note:  To delete a row from the Data_Entry tab, enter blanks or spaces in the Agency-Code."]
[]
[null,"COLUMN A                     ",null,"AGENCY-CODE (REQUIRED)",null,null,null,null,null,null,null,"ENTER THE TWO-POSITION ALPHANUMERIC AGENCY CODE"]
[null,"COLUMNS B THRU H",null,"ORGANIZATIONAL-STRUCTURE-CODE (REQUIRED)",null,null,null,null,null,null,null,"ENTER THE AGENCY'S 16-DIGIT ORGANIZATIONAL STRUCTURE CODE *"]
[null,"COLUMN I                      ",null,"DATA-2-INDICATOR (OPTIONAL)",null,null,null,null,null,null,null,"ENTER BLANK OR '2'.  '2' IS ONLY VALID FOR AGENCIES '07',  '10' OR '16'."]
[null,"COLUMN J                      ",null,"ORGANIZATIONAL-STRUCTURE-CODE REDISPLAYED",null,null,null,null,null,null,null,"NO ENTRY NECESSARY"]
[null,"COLUMN K                      ",null,"BEGINNING-EFFECTIVE-DATE (REQUIRED)",null,null,null,null,null,null,null,"ENTER THE DATE IN (MM/DD/YYYY) FORMAT REPRESENTING THE DATE THAT THE RECORD BECOMES EFFECTIVE"]
[null,"COLUMN L                    ",null,"BEGINNING-EFFECTIVE-DATE(JULIAN)",null,null,null,null,null,null,null,"WILL BE INSERTED BY EXCEL."]
[null,"COLUMN M                     ",null,"END-EFFECTIVE-DATE (OPTIONAL)",null,null,null,null,null,null,null,"ENTER THE ENDING EFFECTIVE DATE IN A (MM/DD/YYYY) FORMAT - IF CELL IS BLANK - THE DEFAULT VALUE OF 12/31/49"]
[null,"COLUMN M (cont'd)                                                                                                                ",null,"",null,null,null,null,null,null,null,"WILL BE INSERTED BY EXCEL."]
[null,"COLUMN N       ",null,"END-EFFECTIVE-DATE (JULIAN)",null,null,null,null,null,null,null,"WILL BE INSERTED BY EXCEL."]
[null,"COLUMN O                     ",null,"AGENCY-ABBRV (REQUIRED ONLY WHEN ORG-STRUCTURE-CODE IS ALL ZEROS)",null,null,null,null,null,null,null,"ENTER UP TO SIX ALPHA CHARACTERS REPRESENTING THE AGENCY ABBREVIATION"]
[null,"COLUMN P                     ",null,"ORG-STRUCTURE-SHORT-NAME (REQUIRED)",null,null,null,null,null,null,null,"ENTER UP TO 30 ALPHA-NUMERIC CHARACTERS"]
[null,"COLUMN Q                     ",null,"ORG-STRUCTURE-NAME-1 (REQUIRED)",null,null,null,null,null,null,null,"ENTER UP TO 75 ALPHA-NUMERIC CHARACTERS"]
[null,"COLUMN R                    ",null,"ORG-STRUCTURE-NAME-2 (OPTIONAL)",null,null,null,null,null,null,null,"ENTER UP TO 75 ALPHA-NUMERIC CHARACTERS"]
[null,"COLUMN S                     ",null,"EMPLOYEE-EXPRESS-INDICATOR (OPTIONAL)",null,null,null,null,null,null,null,"TYPE A 'Y' OR 'N' IN THE EMPLOYEE-EXPRESS-INDICATOR FIELD. IF FIELD IS LEFT BLANK, THE VALUE WILL DEFAULT TO 'N'"]
[null,"COLUMN T                    ",null,"CPAS-SES (FORMERLY THE CPAS-IND)",null,null,null,null,null,null,null,"DEFAULT VALUE IS 'N'. ENTER 'Y' ONLY IF THE AGENCY HAS BEEN CERTIFIED USING THE CERTIFIED APPRAISAL SYSTEM"]
[null,"COLUMN U                     ",null,"CPAS-SLP",null,null,null,null,null,null,null,"ONLY NECESSARY FOR RECORDS WHEN THE ORGANIZATIONAL STRUCTURE CODE EQUAL TO ZEROS - OR THE FIRST RECORD"]
[null,"COLUMN U (cont'd)                                                                                                              ",null,"",null,null,null,null,null,null,null,"IN AN ORGANIZATION, EXAMPLE: 90 00 00 0000 00 00 00"]
[null,"COLUMN V                   ",null,"ACTION-CODE (REQUIRED)",null,null,null,null,null,null,null,"ENTER 'A', 'D', 'M', OR 'R' - (A = ADD, D = DELETE, M = MODIFY, R = REACTIVATE)"]

{"sheet":"Data_Entry","index":1,"n_rows":3,"n_cols":22,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,21,1,21],[0,1,0,7],[0,10,0,11],[0,12,0,13],[0,16,0,17],[0,20,1,20],[0,0,1,0],[0,14,1,14],[0,15,1,15],[0,18,1,18],[0,19,1,19]]}
["AGENCY-CODE","ORG-STRUCTURE-CODE",null,null,null,null,null,null,"DATA",null,"BEGIN DATE",null,"END DATE",null," AGENCY-ABBR"," ORG-STRUCTURE-SHORT-NAME"," ORG-STRUCTURE-NAME",null," EMPLOYEE-EXPRESS-INDICATOR"," CPAS-SES"," CPAS-SLP"," ACTION CODE"]
[null,"2ND-LEV","3RD-LEV","4TH-LEV","5TH-LEV","6TH-LEV","7TH-LEV","8TH-LEV","2\nIND","ORG-STRUCTURE-CODE","BEGIN DATE","BEGIN DATE (JULIAN)","END DATE","END DATE (JULIAN)",null,null," ORG-STRUCTURE-NAME-1"," ORG-STRUCTURE-NAME-2 (Optional)"]
["90","00","00","0000","00","00","00","00",null,{"$f":"CONCATENATE(B3,C3,D3,E3,F3,G3,H3)","v":"0000000000000000"},"12/31/2049",{"$f":"IF(ISBLANK(K3),\"\",RIGHT(YEAR(K3),2)&TEXT(K3-DATE(YEAR(K3),1,0),\"000\"))","v":"49365"},"2049-12-31",{"$f":"IF(OR(ISBLANK(M3),(ISTEXT(M3)),(ISBLANK(M3))),49365,RIGHT(YEAR(M3),2)&TEXT(M3-DATE(YEAR(M3),1,0),\"000\"))","v":"49365"},"OCFO","NATIONAL FINANCE CENTER","OFFICE OF THE CHIEF FINANCIAL OFFICER/NATIONAL FINANCE CENTER","OCFO/NFC","N","N","N","A"]

{"sheet":"Hidden","index":2,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Key","Value","Comment",null,null,null,null,"Action_Codes","Boolean_Choices"]
["Version",1,"Initial Build",null,null,null,null,"A","Y"]
["Version",2,"corrections",null,null,null,null,"D","N"]
[null,null,null,null,null,null,null,"M"," "]
[null,null,null,null,null,null,null,"R"]