{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Form","Instructions & Requirements","Sheet2"],"not_rendered":{"charts":0,"images":10,"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":"Form","index":0,"n_rows":20,"n_cols":28,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
[]
["Department Of Education (DOE)  Section 117 Reporting"]
[]
["Instructions"]
[null,"Provide information pertaining to gifts, contracts, restricted or conditional gifts and restricted or contitional contracts   "]
[null,"Dropdown lists are available columns highlighted in light red"]
[null,"Wording of question is directly from DOE Online Portal"]
[null,"What should be completed by Disclosure Type:"]
[null,"All Entries (should macros not be enabled, see required information below and to the right)",null,"Complete columns B through Q and U through W"]
[null,"Complete Additional Columns Depending on Transaction Type:"]
[null,"Gift",null,"Complete Column R"]
[null,"Contract",null,"Complete Columns S and T"]
[null,"Restricted or Conditional Gift",null,"Complete Columns R, X, Y, Z, AA, AB"]
[null,"Restricted or Conditional Contract ",null,"Complete Columns S, T, X, Y, Z, AA, AB"]
[]
["Report Foreign Sourced Gifts and Contracts for DOE  Section 117 Bi-annual Submission"]
[]
[null,"Complete for All Submissions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Restricted or Conditional Gifts Only"]
[]
["Transaction Type","Foreign Source Legal Name","Foreign Source DBATrade Name","Is The Foreign Source A Government (Yes/No)","Foreign Government Name","Is The Foreign Source A Legal Entity (Yes/No)","Is The Foreign Source An Individual (Yes/No)","Is The Foreign Source An Agent (Yes/No)","Principal Name","Country Of Attribution","Country","Address Line 1","Address Line 2","Zip Postal Code","City 1","State","Amount","Date Received","Contract Start Date","Contract End Date","Is This Direct To The Institution (Yes/No)","Is This Through An Intermediary (Yes/No)","Intermediary Names","Do Restrictions Concern Faculty Employment (Yes/No)","Do Restrictions Concern Academic Programs/Positions (Yes/No)","Do Restrictions Concern Student Selection (Yes/No)","Do Restrictions Concern Restricted Financial Aid (Yes/No)","Restriction Condition Description"]

{"sheet":"Instructions & Requirements","index":1,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Bulk Transaction Upload - Instructions & Validation Requirements"]
["Core required fields:"]
["Transaction Type (Gift, Contract, Restricted or Conditional Gift, or Restricted or Conditional Contract)"]
["Foreign Source Legal Name (max 300 characters)"]
["Country Of Attribution (must be a valid country name, see list below)"]
["Address: Country (must be a valid country name, see list below), Address Line 1 (max 300 characters), Zip/Postal Code (max 50 characters), City (max 300 characters), State/Province (max 300 characters)"]
["Amount (valid currency format)"]
["All four Foreign Source Type questions must be answered (Government, Legal Entity, Individual, Agent) and at least one must be \"Yes\""]
["Both Direct/Intermediary questions must be answered and at least one must be \"Yes\""]
["Either Date Received or both Contract Start Date and Contract End Date"]
[]
["Conditional requirements:"]
["If Foreign Source is Government = Yes: Foreign Government Name required (must be valid country)"]
["If Foreign Source is Agent = Yes: Principal Name required (max 300 characters)"]
["If Through Intermediary = Yes: Intermediary Names required (max 300 characters)"]
["If Transaction Type is Restricted/Conditional: All four restriction questions must be answered, at least one must be \"Yes\", and Restriction Description required (max 500 characters)"]
[]
["Date validation rules:"]
["Gift transactions cannot have Contract Start/End dates"]
["Contract End Date must be after Contract Start Date"]
["Cannot have both Date Received and Contract dates filled"]
["Dates older than 6 months will trigger a warning acknowledgement"]
[]
["Format requirements:"]
["Yes/No fields accept: \"Yes\", \"Y\", \"No\", \"N\" (case insensitive)"]
["Dates: must follow MM/DD/YYYY format"]
["Countries must match official country names (case insensitive) - see valid countries list below"]
["Amounts: numeric values (dollar signs and commas optional)"]
["Amounts under $1,000 will trigger a warning acknowledgement"]

{"sheet":"Sheet2","index":2,"n_rows":3,"n_cols":199,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,"Afghanistan","Albania","Algeria","Andorra","Angola","Antigua and Barbuda","Argentina","Armenia","Australia","Austria","Azerbaijan","The Bahamas","Bahrain","Bangladesh","Barbados","Belarus","Belgium","Belize","Benin","Bhutan","Bolivia","Bosnia and Herzegovina","Botswana","Brazil","Brunei","Bulgaria","Burkina Faso","Burundi","Cabo Verde","Cambodia","Cameroon","Canada","Central African Republic","Chad","Chile","China","Colombia","Comoros","Republic of the Congo","Costa Rica","Croatia","Cuba","Cyprus","Czechia","Democratic Republic of the Congo","Denmark","Djibouti","Dominica","Dominican Republic","Timor-Leste","Ecuador","Egypt","El Salvador","Equatorial Guinea","Eritrea","Estonia","Eswatini","Ethiopia","Fiji","Finland","France","Gabon","The Gambia","Georgia","Germany","Ghana","Greece","Grenada","Guatemala","Guinea","Guinea-Bissau","Guyana","Haiti","Honduras","Holy See","Hungary","Iceland","India","Indonesia","Iran","Iraq","Ireland","Israel","Italy","Cote d’Ivoire","Jamaica","Japan","Jordan","Kazakhstan","Kenya","Kiribati","Kosovo","Kuwait","Kyrgyzstan","Laos","Latvia","Lebanon","Lesotho","Liberia","Libya","Liechtenstein","Lithuania","Luxembourg","Madagascar","Malawi","Malaysia","Maldives","Mali","Malta","Marshall Islands","Mauritania","Mauritius","Mexico","Micronesia","Moldova","Monaco","Mongolia","Montenegro","Morocco","Mozambique","Myanmar","Namibia","Nauru","Nepal","Netherlands","New Zealand","Nicaragua","Niger","Nigeria","North Korea","North Macedonia","Norway","Oman","Pakistan","Palau","Palestinian Territories","Panama","Papua","New Guinea","Paraguay","Peru","Philippines","Poland","Portugal","Qatar","Romania","Russia","Rwanda","Saint Kitts and Nevis","Saint Lucia","Saint Vincent and the Grenadines","Samoa","San Marino","Sao Tome and Principe","Saudi Arabia","Senegal","Serbia","Seychelles","Sierra Leone","Singapore","Slovakia","Slovenia","Solomon Islands","Somalia","South Africa","South Korea","South Sudan","Spain","Sri Lanka","Sudan","Suriname","Sweden","Switzerland","Syria","Taiwan","Tajikistan","Tanzania","Thailand","Togo","Tonga","Trinidad and Tobago","Tunisia","Turkey (Turkiye)","Turkmenistan","Tuvalu","Uganda","Ukraine","United Arab Emirates","United Kingdom","United States","Uruguay","Uzbekistan","Vanuatu","Venezuela","Vietnam","Yemen","Zambia","Zimbabwe"]
[null,"Gift","Contract","Restricted or Conditional Gift","Restricted or Conditional Contract"]
[null,"Yes","No"]