{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home","FRGN","CPNY","INDV","STPT","Drop Down"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":8,"comments":4,"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":"Home","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[8,2,8,3],[5,2,5,3]]}
[null,null,"Supplier Information Form (SIF) Version 2.0 Effective 10-27-2020"]
[]
[null,null,"Supplier/Individual/Study Participant/ACH/Wire Form"]
[null,null,"FORM DESCRIPTION:\nThis form is used to establish or update a record within the Emory University Procurement system and meets the Federal requirements to request a taxpayer identification number (TIN), request certain certifications for Federal procurement reporting and claims for exemption, and internal requirements. Do not return this form to the IRS."]
[null,null,"NOTE TO SUPPLIER: Submission of this form does not authorize a supplier to provide goods or services to Emory University until the supplier is notified by Procurement."]
[null,null,"Preliminary Questions"]
[null,null,"Select if you are a Company, Individual, or Study Participant:","Company"]
[null,null,{"$f":"IF(D7=\"\",\"\",IF(D7=\"Company\",\"Is your company a US based entity for tax purposes?\",\"Are you a US citizen or resident for tax purposes?\"))","v":"Is your company a US based entity for tax purposes?"},"Yes"]
[null,null,{"$f":"IF(AND(D7<>\"\",D8=\"No\"),HYPERLINK(CONCATENATE(\"#FRGN!h4\"),\"Click Here to Proceed\"),IF(AND(D7=\"Study Participant\",D8=\"Yes\"),HYPERLINK(CONCATENATE(\"#STPT!h10\"),\"Click Here to Proceed\"),IF(AND(D7=\"Individual\",D8=\"Yes\"),HYPERLINK(CONCATENATE(\"#INDV!h4\"),\"Click Here to Proceed\"),IF(AND(D7=\"Company\",D8=\"Yes\"),HYPERLINK(CONCATENATE(\"#CPNY!h4\"),\"Click Here to Proceed\"),\"Please fill in all Yellow Cells\"))))","v":"Click Here to Proceed"}]

{"sheet":"FRGN","index":1,"n_rows":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":false,"merged":[[69,6,69,7],[44,6,44,7],[45,6,45,7],[52,6,52,7],[62,6,62,7],[68,6,68,7],[1,6,1,7],[8,6,8,7],[27,6,27,7],[37,6,37,7],[43,6,43,7],[2,6,2,7],[7,6,7,7],[31,6,31,7]]}
[null,null,null,null,null,null,{"$f":"Home!C1&\" (\"&IF(Home!D8=\"No\",\"Foreign Source Statement for \",\"\")&Home!$D$7&\")\"","v":"Supplier Information Form (SIF) Version 2.0 Effective 10-27-2020 (Company)"}]
[null,{"$f":"IF(Home!$D$8=\"No\",\"Conditional Formatting\",\"\")","v":""},"Error Validation","No",null,null,{"$f":"IF(AND(COUNTIF($B$3:$B$73,\"R\")>0,COUNTIF($B$3:$B$73,\"C\")>0),\"There are \"&COUNTIF($B$3:$B$73,\"R\")&\" required fields remaining highlighted in yellow with mini-dots.\"&CHAR(10)&\"There are \"&COUNTIF($B$3:$B$73,\"C\")&\" fields that need correction highlighted in red.\",IF(AND(COUNTIF($B$3:$B$73,\"R\")>0,COUNTIF($B$3:$B$73,\"C\")=0),\"There are \"&COUNTIF($B$3:$B$73,\"R\")&\" required fields remaining highlighted in yellow with mini-dots.\",IF(AND(COUNTIF($B$3:$B$73,\"R\")=0,COUNTIF($B$3:$B$73,\"C\")>0),\"There are \"&COUNTIF($B$3:$B$73,\"C\")&\" fields that need correction highlighted in red.\",\"Completed! Please submit this excel file to the Emory personnel that provided you this form.\")))","v":"Completed! Please submit this excel file to the Emory personnel that provided you this form."},null,null,{"$f":"HYPERLINK(CONCATENATE(\"#Home!D8\"),\"Click Here to Go Back\")","v":"Click Here to Go Back"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H3=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A2),FALSE),IF(C3=FALSE,\"C\")))","v":""},true,"Y",null,null,{"$f":"Home!$D$7&\" Prerequisite Questions\"","v":"Company Prerequisite Questions"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H4=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A3),FALSE),IF(C4=FALSE,\"C\")))","v":""},true,"R",null,null,{"$f":"IF(Home!$D$7=\"Company\",\"Is your company\",IF(Home!$D$7<>\"Company\",\"Are you\",\"\"))&\" filling out this form to update current information on file with Emory? If not sure, select 'No' from drop down box.\"","v":"Is your company filling out this form to update current information on file with Emory? If not sure, select 'No' from drop down box."},"No"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H5=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A4),FALSE),IF(C5=FALSE,\"C\")))","v":""},true,{"$f":"IF(H4=\"Yes\",\"R\",\"Y\")","v":"Y"},null,null,{"$f":"IF(H4=\"Yes\",IF(Home!$D$7=\"Company\",\"Does your company\",IF(Home!$D$7<>\"Company\",\"Do you\",\"\"))&\" only need to update the Wire Payment information on file with Emory?\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H6=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A5),FALSE),IF(C6=FALSE,\"C\")))","v":""},true,{"$f":"IF(Home!D7=\"Company\",\"R\",\"Y\")","v":"R"},null,null,{"$f":"IF(Home!D7=\"Company\",\"Is your company the direct output of a merger, acquisition, or spinoff?\",\"\")","v":"Is your company the direct output of a merger, acquisition, or spinoff?"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H7=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A6),FALSE),IF(C7=FALSE,\"C\")))","v":""},true,{"$f":"IF(H6=\"Yes\",\"R\",\"Y\")","v":"Y"},null,null,{"$f":"IF(H6=\"Yes\",\"Please provide a brief description of the merger, acquisition, or spinoff:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H8=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A7),FALSE),IF(C8=FALSE,\"C\")))","v":""},true,"Y"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H9=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A8),FALSE),IF(C9=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,null,{"$f":"Home!$D$7&\" Name and General Information\"","v":"Company Name and General Information"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H10=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A9),FALSE),IF(C10=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,null,"Legal name that is the beneficial owner of payment received:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H11=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A10),FALSE),IF(C11=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,null,"Doing Business As (DBA) Name, If Different then Legal Name:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H12=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A11),FALSE),IF(C12=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,null,"Contact Name:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H13=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A12),FALSE),IF(C13=FALSE,\"C\")))","v":""},{"$f":"ISNUMBER(H13+0)","v":true},"R",null,null,"Contact Phone Number:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H14=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A13),FALSE),IF(C14=FALSE,\"C\")))","v":""},{"$f":"IF(H14=\"\",TRUE,ISNUMBER(FIND(\"@\",H14,1)+FIND(\".\",H14,1)))","v":true},"R",null,null,"Contact Email:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H15=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A14),FALSE),IF(C15=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",IF(Home!D7=\"Company\",\"R\",\"Y\")))","v":"R"},null,null,{"$f":"IF(Home!D7=\"Company\",\"Select the classification that best describes your organization:\",\"\")","v":"Select the classification that best describes your organization:"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H16=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A15),FALSE),IF(C16=FALSE,\"C\")))","v":""},{"$f":"IF(H16=\"No\",FALSE,TRUE)","v":true},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",IF(OR(G15=\"\",H15<>\"\"),\"R\",\"Y\")))","v":"Y"},null,null,{"$f":"IF(Home!D7<>\"Company\",HYPERLINK(\"https://finance.emory.edu/home/accounting/forms/index.html\",\"A W-8 form is required to be completed. Based on classification above it is recommended that you complete the W-8BEN Certificate of Foreign Status. Click Here to Access the form. Please indicate a W-8 form has been completed:\"),IF(H15=\"Foreign Company and a Financial Institution (FFI)\",HYPERLINK(\"https://finance.emory.edu/home/accounting/forms/index.html\",\"A W-8 form is required to be completed. Based on classification above it is recommended that you complete the W-8BEN-E Long Form. Click Here to Access the form. Please indicate a W-8 form has been completed:\"),IF(H15=\"Foreign Company and not a Financial Institution\",HYPERLINK(\"https://finance.emory.edu/home/accounting/forms/index.html\",\"A W-8 form is required to be completed. Based on classification above it is recommended that you complete the W-8BEN-E Short Form. Click Here to Access the form. Please indicate a W-8 form has been completed:\"),\"\")))","v":""}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H17=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A16),FALSE),IF(C17=FALSE,\"C\")))","v":""},{"$f":"OR(ISNUMBER(H17+0),$H$17=\"No DUNS #\")","v":true},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$15=\"\",Home!D7<>\"Company\"),\"Y\",\"R\"))","v":"Y"},null,null,{"$f":"IF(OR($H$15=\"\",Home!D7<>\"Company\"),\"\",\"DUNS Number\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H18=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A17),FALSE),IF(C18=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$15=\"\",ISNUMBER(H17+0),Home!D7<>\"Company\"),\"Y\",\"R\"))","v":"Y"},null,null,{"$f":"IF(OR($H$15=\"\",Home!D7<>\"Company\",$H$17=\"\",ISNUMBER($H$17+0)),\"\",\"Please explain why a DUNS # cannot be obtain:\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H19=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A18),FALSE),IF(C19=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,null,"Are you a Canadian citizen or resident for tax purposes?"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H20=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A19),FALSE),IF(C20=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",IF($H$19=\"Yes\",\"R\",\"Y\")))","v":"Y"},null,null,{"$f":"IF(OR(H19=\"\",H19=\"No\"),\"\",\"Will you be filing a Canadian tax return as a Canadian tax resident and reporting the payment from Emory as income?\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H21=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A20),FALSE),IF(C21=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",IF($H$19=\"Yes\",\"R\",\"Y\")))","v":"Y"},null,null,{"$f":"IF(OR($H$19=\"\",$H$19=\"No\"),\"\",IF(Home!D7<>\"Company\",\"Canadian Social Insurance Number:\",\"Recipient's Account Number:\"))","v":""}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H22=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A21),FALSE),IF(C22=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,null,"Brief Description of Services/Activities provided to Emory University:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H23=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A22),FALSE),IF(C23=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,null,"Please indicate if this payment relates solely to the purchase of goods, inventory, equipment, materials or supplies, and/or related shipping charges:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H24=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A23),FALSE),IF(C24=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",IF($H$23=\"No\",\"R\",\"Y\")))","v":"Y"},null,null,{"$f":"IF(OR($H$23=\"Yes\",$H$23=\"\"),\"\",\"Please indicate if any services performed for Emory University were performed entirely outside of the United States, entirely inside of the United States, or partly outside and inside of the United States:\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H25=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A24),FALSE),IF(C25=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",IF($H$23=\"No\",\"R\",\"Y\")))","v":"Y"},null,null,{"$f":"IF(OR($H$23=\"Yes\",$H$23=\"\"),\"\",\"Please list the countries where services were performed:\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H26=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A25),FALSE),IF(C26=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",IF($H$23=\"No\",\"R\",\"Y\")))","v":"Y"},null,null,{"$f":"IF(OR($H$23=\"Yes\",$H$23=\"\"),\"\",\"Please indicate the starting date of when the services were performed:\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H27=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A26),FALSE),IF(C27=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",IF($H$23=\"No\",\"R\",\"Y\")))","v":"Y"},null,null,{"$f":"IF(OR($H$23=\"Yes\",$H$23=\"\"),\"\",\"Please indicate the ending date of when the services were performed:\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H28=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A27),FALSE),IF(C28=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,null,"Current Address"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H29=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A28),FALSE),IF(C29=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,null,"Address Line 1:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H30=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A29),FALSE),IF(C30=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,null,"Address Line 2:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H31=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A30),FALSE),IF(C31=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,null,"Address Line 3:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H32=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A31),FALSE),IF(C32=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,null,"Shipping Address"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H33=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A32),FALSE),IF(C33=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$15=\"\",Home!D7<>\"Company\"),\"Y\",\"R\"))","v":"Y"},null,null,{"$f":"IF(Home!D7=\"Company\",\"Method to Receive Orders:\",\"\")","v":"Method to Receive Orders:"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H34=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A33),FALSE),IF(C34=FALSE,\"C\")))","v":""},{"$f":"IF(H34=\"\",TRUE,ISNUMBER(FIND(\"@\",H34,1)+FIND(\".\",H34,1)))","v":true},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$33=\"\",$H$33=\"Fax\"),\"Y\",\"R\"))","v":"Y"},null,null,{"$f":"IF(Home!D7=\"Company\",\"Email for Receiving Orders:\",\"\")","v":"Email for Receiving Orders:"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H35=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A34),FALSE),IF(C35=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$15=\"\",$H$15=\"Foreign Individual or Study Participant\"),\"Y\",\"R\"))","v":"Y"},null,null,{"$f":"IF(Home!D7=\"Company\",\"Address Line 1:\",\"\")","v":"Address Line 1:"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H36=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A35),FALSE),IF(C36=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,null,{"$f":"IF(Home!D7=\"Company\",\"Address Line 2:\",\"\")","v":"Address Line 2:"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H37=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A36),FALSE),IF(C37=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,null,{"$f":"IF(Home!D7=\"Company\",\"Address Line 3:\",\"\")","v":"Address Line 3:"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H38=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A37),FALSE),IF(C38=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,null,"Certifications"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H39=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A38),FALSE),IF(C39=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,null,"Under penalties of perjury, I declare that I have examined the information on this form and to the best of my knowledge and belief is true, correct, and complete."]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H40=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A39),FALSE),IF(C40=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",Home!D7<>\"Company\"),\"Y\",\"R\"))","v":"R"},null,null,{"$f":"IF(Home!D7=\"Company\",CONCATENATE(\"Emory highly encourages that your company be registered with The System for Award Management (SAM) because not doing so can preclude you as a supplier for contracts that Emory has with the U.S. government.\",\" For additional information and to register, please visit https://www.sam.gov/\"),\"\")","v":"Emory highly encourages that your company be registered with The System for Award Management (SAM) because not doing so can preclude you as a supplier for contracts that Emory has with the U.S. government. For additional information and to register, please visit https://www.sam.gov/"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H41=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A40),FALSE),IF(C41=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,null,"Enter Estimated Amount to Receive from Goods and/or Services Being Provided to Emory (Input Amount and Currency):"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H42=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A41),FALSE),IF(C42=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,null,{"$f":"CONCATENATE(Home!D7,\" Authorized E-Signature:\",CHAR(10),\"(Please type your First and Last Name)\",CHAR(10),\"Please understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.\",\"Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature.\")","v":"Company Authorized E-Signature:\n(Please type your First and Last Name)\nPlease understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature."}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H43=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A42),FALSE),IF(C43=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,null,"Date of Signature:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H44=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A43),FALSE),IF(C44=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H45=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A44),FALSE),IF(C45=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"Y\",\"\"))","v":"Y"},null,null,"Wire Payment Authorization"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H46=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A45),FALSE),IF(C46=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"Y\",\"\"))","v":"Y"},null,null,{"$f":"Home!D7&\" Information\"","v":"Company Information"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H47=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A46),FALSE),IF(C47=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"R\",\"\"))","v":"R"},null,null,{"$f":"Home!$D$7&\" Name:\"","v":"Company Name:"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H48=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A47),FALSE),IF(C48=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"R\",\"\"))","v":"R"},null,null,"Street Address:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H49=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A48),FALSE),IF(C49=FALSE,\"C\")))","v":""},true,"R",null,null,"City, State and Postal Code:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H50=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A49),FALSE),IF(C50=FALSE,\"C\")))","v":""},true,"R",null,null,"Country/Territory:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H51=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A50),FALSE),IF(C51=FALSE,\"C\")))","v":""},{"$f":"ISNUMBER(H51+0)","v":true},"R",null,null,"Primary Contact Phone Number:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H52=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A51),FALSE),IF(C52=FALSE,\"C\")))","v":""},{"$f":"IF(H52=\"\",TRUE,ISNUMBER(FIND(\"@\",H52,1)+FIND(\".\",H52,1)))","v":true},"R",null,null,"Primary Contact Email Address:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H53=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A52),FALSE),IF(C53=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"Y\",\"\"))","v":"Y"},null,null,"Banking Information"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H54=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A53),FALSE),IF(C54=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"R\",\"\"))","v":"R"},null,null,"Bank Name:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H55=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A54),FALSE),IF(C55=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"R\",\"\"))","v":"R"},null,null,"Bank City:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H56=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A55),FALSE),IF(C56=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"R\",\"\"))","v":"R"},null,null,"Bank Country/Territory:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H57=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A56),FALSE),IF(C57=FALSE,\"C\")))","v":""},{"$f":"ISNUMBER(H57+0)","v":true},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$56=\"\",\"Y\",IF(VLOOKUP($H$56,'Drop Down'!$F$2:$G$249,2,FALSE)=\"Y\",\"R\",\"Y\")))","v":"Y"},null,null,"Routing/ABA Number (Domestic):"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H58=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A57),FALSE),IF(C58=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$56=\"\",\"Y\",IF(AND(VLOOKUP($H$56,'Drop Down'!$F$2:$G$249,2,FALSE)<>\"Y\",H56<>\"\"),\"R\",\"Y\")))","v":"Y"},null,null,"SWIFT, BIC, BAC Code (International):"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H59=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A58),FALSE),IF(C59=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"R\",\"\"))","v":"R"},null,null,"Name on Bank Account:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H60=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A59),FALSE),IF(C60=FALSE,\"C\")))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H56,'Drop Down'!$I$3:$K$83,2,FALSE)),TRUE,VLOOKUP(H56,'Drop Down'!$I$3:$K$83,2,FALSE)=LEN(H60))","v":true},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"R\",\"\"))","v":"R"},null,null,{"$f":"IF(ISERROR(VLOOKUP(H56,'Drop Down'!$I$3:$K$83,1,FALSE)),\"Bank Account Number:\",\"International Bank Account Number (IBAN):\"&CHAR(10)&VLOOKUP(H56,'Drop Down'!$I$3:$L$83,4,FALSE))","v":"Bank Account Number:"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H61=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A60),FALSE),IF(C61=FALSE,\"C\")))","v":""},{"$f":"IF(ISERROR(VLOOKUP(H57,'Drop Down'!$I$3:$K$83,2,FALSE)),TRUE,VLOOKUP(H57,'Drop Down'!$I$3:$K$83,2,FALSE)=LEN(H61))","v":true},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"R\",\"\"))","v":"R"},null,null,"Payment Currency:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H62=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A61),FALSE),IF(C62=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(ISERROR(VLOOKUP(H56,'Drop Down'!$N$2:$P$16,3,FALSE)),\"Y\",\"R\"))","v":"Y"},null,null,{"$f":"\"Additional Information Required:\"&CHAR(10)&IFERROR(VLOOKUP(H56,'Drop Down'!$N$2:$P$16,3,FALSE),\"\")","v":"Additional Information Required:\n"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H63=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A62),FALSE),IF(C63=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"Y\",\"\"))","v":"Y"},null,null,"Intermediary Banking Information"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H64=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A63),FALSE),IF(C64=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"R\",\"\"))","v":"R"},null,null,"Does your bank require an intermediary bank for processing final payment?"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H65=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A64),FALSE),IF(C65=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(H64=\"Yes\",\"R\",\"Y\"))","v":"Y"},null,null,"Bank Name:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H66=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A65),FALSE),IF(C66=FALSE,\"C\")))","v":""},{"$f":"ISNUMBER(H66+0)","v":true},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"Y\",\"\"))","v":"Y"},null,null,"Routing/ABA Number (Domestic):"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H67=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A66),FALSE),IF(C67=FALSE,\"C\")))","v":""},true,"Y",null,null,"SWIFT, BIC, BAC Code (International):"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H68=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A67),FALSE),IF(C68=FALSE,\"C\")))","v":""},{"$f":"ISNUMBER(H68+0)","v":true},"Y",null,null,"Account Number (Only Applicable For Further Credit):"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H69=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A68),FALSE),IF(C69=FALSE,\"C\")))","v":""},true,"Y",null,null,{"$f":"Home!D7&\" Authorization for Payment\"","v":"Company Authorization for Payment"}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H70=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A69),FALSE),IF(C70=FALSE,\"C\")))","v":""},true,"Y",null,null,"We hereby authorize, with the signature below, Emory University Payment Services to deposit all payments into the above referenced account."]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H71=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A70),FALSE),IF(C71=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"R\",\"\"))","v":"R"},null,null,{"$f":"CONCATENATE(Home!D7,\" Authorized E-Signature:\",CHAR(10),\"(Please type your First and Last Name)\",CHAR(10),\"Please understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.\",\"Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature.\")","v":"Company Authorized E-Signature:\n(Please type your First and Last Name)\nPlease understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature."}]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H72=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A71),FALSE),IF(C72=FALSE,\"C\")))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",COUNTIF($B$4:$B$7,\"R\")=0),\"R\",\"\"))","v":"R"},null,null,"Authorized Signer's Title:"]
[null,{"$f":"IF(OR(Home!$D$8=\"\",Home!$D$8=\"Yes\"),\"\",IF(H73=\"\",HLOOKUP(Home!$D$8,FRGN!$D$2:$F$73,ROW(A72),FALSE),IF(C73=FALSE,\"C\")))","v":""},true,"R",null,null,"Date of Signature:"]

{"sheet":"CPNY","index":2,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":false,"merged":[[76,6,76,7],[77,6,77,7],[86,6,86,7],[92,6,92,7],[97,6,97,7],[96,6,96,7],[78,6,78,7],[57,6,57,7],[56,6,56,7],[2,6,2,7],[1,6,1,7],[28,6,28,7],[36,6,36,7],[47,6,47,7],[8,6,8,7],[7,6,7,7]]}
[null,null,null,null,null,null,{"$f":"Home!C1&\" (\"&IF(Home!D8=\"Yes\",\"Domestic \",\"\")&Home!$D$7&\")\"","v":"Supplier Information Form (SIF) Version 2.0 Effective 10-27-2020 (Domestic Company)"}]
[null,{"$f":"IF(AND(Home!$D$7=\"Company\",Home!$D$8<>\"No\"),\"Conditional Formatting\",\"\")","v":"Conditional Formatting"},"Error Validation","Company","Individual","Study Participant",{"$f":"IF(AND(COUNTIF($B$3:$B$102,\"R\")>0,COUNTIF($B$3:$B$102,\"C\")>0),\"There are \"&COUNTIF($B$3:$B$102,\"R\")&\" required fields remaining highlighted in yellow with mini-dots.\"&CHAR(10)&\"There are \"&COUNTIF($B$3:$B$102,\"C\")&\" fields that need correction highlighted in red.\",IF(AND(COUNTIF($B$3:$B$102,\"R\")>0,COUNTIF($B$3:$B$102,\"C\")=0),\"There are \"&COUNTIF($B$3:$B$102,\"R\")&\" required fields remaining highlighted in yellow with mini-dots.\",IF(AND(COUNTIF($B$3:$B$102,\"R\")=0,COUNTIF($B$3:$B$102,\"C\")>0),\"There are \"&COUNTIF($B$3:$B$102,\"C\")&\" fields that need correction highlighted in red.\",\"Completed! Please submit this excel file to the Emory personnel that provided you this form.\")))","v":"There are 2 required fields remaining highlighted in yellow with mini-dots."},null,null,{"$f":"HYPERLINK(CONCATENATE(\"#Home!D8\"),\"Click Here to Go Back\")","v":"Click Here to Go Back"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A2),FALSE)),\"\",IF(H3=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A2),FALSE),IF(C3=FALSE,\"C\"))))","v":"Y"},true,"Y",null,null,"Prerequisite Questions"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A3),FALSE)),\"\",IF(H4=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A3),FALSE),IF(C4=FALSE,\"C\"))))","v":"R"},true,"R",null,null,{"$f":"IF(Home!$D$7=\"Company\",\"Is your company\",IF(Home!$D$7=\"Individual\",\"Are you\",\"\"))&\" filling out this form to update current information on file with Emory? If not sure, select 'No' from drop down box.\"","v":"Is your company filling out this form to update current information on file with Emory? If not sure, select 'No' from drop down box."}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A4),FALSE)),\"\",IF(H5=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A4),FALSE),IF(C5=FALSE,\"C\"))))","v":"Y"},true,{"$f":"IF(H4=\"Yes\",\"R\",\"Y\")","v":"Y"},null,null,{"$f":"IF(H4=\"Yes\",IF(Home!$D$7=\"Company\",\"Does your company\",IF(Home!$D$7=\"Individual\",\"Do you\",\"\"))&\" only need to update the ACH/Banking information on file with Emory?\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A5),FALSE)),\"\",IF(H6=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A5),FALSE),IF(C6=FALSE,\"C\"))))","v":"R"},true,"R",null,null,"Is your company the direct output of a merger, acquisition, or spinoff?"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A6),FALSE)),\"\",IF(H7=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A6),FALSE),IF(C7=FALSE,\"C\"))))","v":"Y"},true,{"$f":"IF(H6=\"Yes\",\"R\",\"Y\")","v":"Y"},null,null,{"$f":"IF(H6=\"Yes\",\"Please provide a brief description of the merger, acquisition, or spinoff:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A7),FALSE)),\"\",IF(H8=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A7),FALSE),IF(C8=FALSE,\"C\"))))","v":"Y"},true,"Y"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A8),FALSE)),\"\",IF(H9=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A8),FALSE),IF(C9=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":""},null,null,{"$f":"Home!D7&\" Name and Information\"","v":"Company Name and Information"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A9),FALSE)),\"\",IF(H10=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A9),FALSE),IF(C10=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"Legal Full Name:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A10),FALSE)),\"\",IF(H11=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A10),FALSE),IF(C11=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":""},null,null,"DBA Name, If Different:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A11),FALSE)),\"\",IF(H12=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A11),FALSE),IF(C12=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H12+0)","v":true},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"DUNS Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A12),FALSE)),\"\",IF(H13=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A12),FALSE),IF(C13=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"Contact Name:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A13),FALSE)),\"\",IF(H14=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A13),FALSE),IF(C14=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H14+0),LEFT(H14,1)=\"1\")","v":false},"",null,null,"Contact Phone Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A14),FALSE)),\"\",IF(H15=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A14),FALSE),IF(C15=FALSE,\"C\"))))","v":""},{"$f":"IF(H15=\"\",TRUE,ISNUMBER(FIND(\"@\",H15,1)+FIND(\".\",H15,1)))","v":true},"",null,null,"Contact Email:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A15),FALSE)),\"\",IF(H16=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A15),FALSE),IF(C16=FALSE,\"C\"))))","v":""},true,"",null,null,"Taxpayer Identification Number (Select Type):"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A16),FALSE)),\"\",IF(H17=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A16),FALSE),IF(C17=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H17+0)","v":true},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",H16=\"\"),\"Y\",\"R\"))","v":""},null,null,{"$f":"IF(OR(Home!$D$7=\"Study Participant\",Home!$D$7=\"Individual\"),\"Social Security Number (SSN) (9 Digits):\",IF(H16=\"\",\"\",$H$16&\" (9 Digits) :\"))","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A17),FALSE)),\"\",IF(H18=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A17),FALSE),IF(C18=FALSE,\"C\"))))","v":""},true,"",null,null,"Select the appropriate entity type for federal tax classification:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A18),FALSE)),\"\",IF(H19=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A18),FALSE),IF(C19=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$18=\"Limited Liability Company (LLC)\",\"R\",\"Y\"))","v":""},null,null,{"$f":"IF(H18=\"Limited Liability Company (LLC)\",\"If LLC, Select Tax Classification:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A19),FALSE)),\"\",IF(H20=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A19),FALSE),IF(C20=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$18=\"Individual\"),\"Y\",\"R\"))","v":""},null,null,"Would your company identify as a small and/or diverse business?"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A20),FALSE)),\"\",IF(H21=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A20),FALSE),IF(C21=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$20=\"\",$H$20=\"No\",$H$20=\"Yes - Small Only\"),\"Y\",\"R\"))","v":""},null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Disadvantaged Business (DBE):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A21),FALSE)),\"\",IF(H22=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A21),FALSE),IF(C22=FALSE,\"C\"))))","v":""},true,"",null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Woman-Owned Business (WBE):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A22),FALSE)),\"\",IF(H23=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A22),FALSE),IF(C23=FALSE,\"C\"))))","v":""},true,"",null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Minority Owned Business (MBE):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A23),FALSE)),\"\",IF(H24=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A23),FALSE),IF(C24=FALSE,\"C\"))))","v":""},true,"",null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Veteran Owned Business (VBE):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A24),FALSE)),\"\",IF(H25=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A24),FALSE),IF(C25=FALSE,\"C\"))))","v":""},true,"",null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Historically Black Colleges / Universities & Minority Institutions:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A25),FALSE)),\"\",IF(H26=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A25),FALSE),IF(C26=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$20=\"\",$H$20=\"No\",$H$20=\"Yes - Small Only\",$H$20=\"Yes - Diverse Only\"),\"Y\",\"R\"))","v":""},null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\"),\"Indicate if HUBZone Small Business (HUB Zone):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A26),FALSE)),\"\",IF(H27=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A26),FALSE),IF(C27=FALSE,\"C\"))))","v":""},true,"",null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\"),\"Indicate if Service Disabled Veteran-Owned Small Business (SDVOSB):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A27),FALSE)),\"\",IF(H28=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A27),FALSE),IF(C28=FALSE,\"C\"))))","v":""},true,"",null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\"),\"Indicate if Alaskan Native Corporations (ANCs) & Indian Tribes):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A28),FALSE)),\"\",IF(H29=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A28),FALSE),IF(C29=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":""},null,null,"Legal Mailing Address"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A29),FALSE)),\"\",IF(H30=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A29),FALSE),IF(C30=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"Address Line 1:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A30),FALSE)),\"\",IF(H31=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A30),FALSE),IF(C31=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":""},null,null,"Address Line 2:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A31),FALSE)),\"\",IF(H32=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A31),FALSE),IF(C32=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"City:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A32),FALSE)),\"\",IF(H33=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A32),FALSE),IF(C33=FALSE,\"C\"))))","v":""},true,"",null,null,"State:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A33),FALSE)),\"\",IF(H34=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A33),FALSE),IF(C34=FALSE,\"C\"))))","v":""},true,"",null,null,"ZIP Code:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A34),FALSE)),\"\",IF(H35=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A34),FALSE),IF(C35=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H35+0),LEFT(H35,1)=\"1\")","v":false},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"Phone:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A35),FALSE)),\"\",IF(H36=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A35),FALSE),IF(C36=FALSE,\"C\"))))","v":""},{"$f":"IF(H36=\"\",TRUE,ISNUMBER(FIND(\"@\",H36,1)+FIND(\".\",H36,1)))","v":true},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"Email:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A36),FALSE)),\"\",IF(H37=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A36),FALSE),IF(C37=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":""},null,null,"Shipping Address"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A37),FALSE)),\"\",IF(H38=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A37),FALSE),IF(C38=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"Method to Receive Orders:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A38),FALSE)),\"\",IF(H39=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A38),FALSE),IF(C39=FALSE,\"C\"))))","v":""},{"$f":"IF(H39=\"\",TRUE,ISNUMBER(FIND(\"@\",H39,1)+FIND(\".\",H39,1)))","v":true},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(LEFT($H$38,5)=\"Email\",\"R\",\"Y\"))","v":""},null,null,{"$f":"IF(LEFT($H$38,5)=\"Email\",\"Email for Receiving Orders:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A39),FALSE)),\"\",IF(H40=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A39),FALSE),IF(C40=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H40+0)","v":true},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$38=\"Fax\",\"R\",\"Y\"))","v":""},null,null,{"$f":"IF($H$38=\"Fax\",\"Fax Number for Receiving Orders:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A40),FALSE)),\"\",IF(H41=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A40),FALSE),IF(C41=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"Is the Shipping Address and contact information exactly the same as the Legal Mailing Address?"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A41),FALSE)),\"\",IF(H42=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A41),FALSE),IF(C42=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$41=\"Yes\",$H$41=\"\"),\"Y\",\"R\"))","v":""},null,null,{"$f":"IF($H$41=\"No\",\"Address Line 1:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A42),FALSE)),\"\",IF(H43=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A42),FALSE),IF(C43=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":""},null,null,{"$f":"IF($H$41=\"No\",\"Address Line 2:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A43),FALSE)),\"\",IF(H44=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A43),FALSE),IF(C44=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$41=\"Yes\",$H$41=\"\"),\"Y\",\"R\"))","v":""},null,null,{"$f":"IF($H$41=\"No\",\"City:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A44),FALSE)),\"\",IF(H45=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A44),FALSE),IF(C45=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$41=\"Yes\",$H$41=\"\"),\"Y\",\"R\"))","v":""},null,null,{"$f":"IF($H$41=\"No\",\"State:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A45),FALSE)),\"\",IF(H46=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A45),FALSE),IF(C46=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$41=\"Yes\",$H$41=\"\"),\"Y\",\"R\"))","v":""},null,null,{"$f":"IF($H$41=\"No\",\"ZIP Code:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A46),FALSE)),\"\",IF(H47=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A46),FALSE),IF(C47=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H47+0),LEFT(H47,1)=\"1\")","v":false},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$41=\"Yes\",$H$41=\"\"),\"Y\",\"R\"))","v":""},null,null,{"$f":"IF($H$41=\"No\",\"Phone:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A47),FALSE)),\"\",IF(H48=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A47),FALSE),IF(C48=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":""},null,null,"Remit to Address (Billing Address)"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A48),FALSE)),\"\",IF(H49=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A48),FALSE),IF(C49=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"Is the Remit to Address (Billing Address) and contact information exactly the same as the Legal Mailing Address?"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A49),FALSE)),\"\",IF(H50=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A49),FALSE),IF(C50=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$49=\"Yes\",$H$49=\"\"),\"Y\",\"R\"))","v":""},null,null,{"$f":"IF($H$49=\"No\",\"Address Line 1:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A50),FALSE)),\"\",IF(H51=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A50),FALSE),IF(C51=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":""},null,null,{"$f":"IF($H$49=\"No\",\"Address Line 2:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A51),FALSE)),\"\",IF(H52=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A51),FALSE),IF(C52=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$49=\"Yes\",$H$49=\"\"),\"Y\",\"R\"))","v":""},null,null,{"$f":"IF($H$49=\"No\",\"City:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A52),FALSE)),\"\",IF(H53=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A52),FALSE),IF(C53=FALSE,\"C\"))))","v":""},true,"",null,null,{"$f":"IF($H$49=\"No\",\"State:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A53),FALSE)),\"\",IF(H54=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A53),FALSE),IF(C54=FALSE,\"C\"))))","v":""},true,"",null,null,{"$f":"IF($H$49=\"No\",\"ZIP Code:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A54),FALSE)),\"\",IF(H55=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A54),FALSE),IF(C55=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H55+0),LEFT(H55,1)=\"1\")","v":false},"",null,null,{"$f":"IF($H$49=\"No\",\"Phone:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A55),FALSE)),\"\",IF(H56=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A55),FALSE),IF(C56=FALSE,\"C\"))))","v":""},{"$f":"IF(H56=\"\",TRUE,ISNUMBER(FIND(\"@\",H56,1)+FIND(\".\",H56,1)))","v":true},"",null,null,{"$f":"IF($H$49=\"No\",\"Email:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A56),FALSE)),\"\",IF(H57=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A56),FALSE),IF(C57=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":""},null,null,"Certifications"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A57),FALSE)),\"\",IF(H58=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A57),FALSE),IF(C58=FALSE,\"C\"))))","v":""},true,"",null,null,"Under penalties of perjury, I certify by electronically signing below."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A58),FALSE)),\"\",IF(H59=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A58),FALSE),IF(C59=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"1. The number shown on this form is my correct taxpayer identification number (or I am waiting for a number to be issued to me)."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A59),FALSE)),\"\",IF(H60=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A59),FALSE),IF(C60=FALSE,\"C\"))))","v":""},true,"",null,null,"2. I am not subject to backup withholding because (a) I am exempt from backup withholding, or (b) I have not been notified by the Internal Revenue Service (IRS) that I am subject to backup withholding as a result of a failure to report all interest or dividends, or (c) the IRS has notified me that I am no longer subject to backup withholding."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A60),FALSE)),\"\",IF(H61=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A60),FALSE),IF(C61=FALSE,\"C\"))))","v":""},true,"",null,null,"3. My firm is not currently debarred, suspended, or proposed for debarment by any federal entity and I agree to notify Emory University Payment Services of any change in status."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A61),FALSE)),\"\",IF(H62=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A61),FALSE),IF(C62=FALSE,\"C\"))))","v":""},true,"",null,null,"4. My firm does not currently have any employees, vendors, or other types of contractual relationships in place with parties on the U.S. Department of Treasury Office of Foreign Assets Control Specially Designated National (SDN) List. This list can be found at the following URL: http://www.ustreas.gov/offices/enforcement/ofac/sdn/"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A62),FALSE)),\"\",IF(H63=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A62),FALSE),IF(C63=FALSE,\"C\"))))","v":""},true,"",null,null,{"$f":"IF(Home!$D$7=\"Company\",\"5. Are you or any Officer, Owner or Partner in this company an employee of Emory University?\",IF(Home!$D$7=\"Individual\",\"5. Are you an employee of Emory University?\",\"\"))","v":"5. Are you or any Officer, Owner or Partner in this company an employee of Emory University?"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A63),FALSE)),\"\",IF(H64=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A63),FALSE),IF(C64=FALSE,\"C\"))))","v":""},true,"",null,null,{"$f":"HYPERLINK(\"https://emory.ellucid.com/documents/view/17693/?security=353f1df192117ef8139f94032abe5f3cd53a8395\",CONCATENATE(\"6. Is a direct family member of any of the above an Emory University employee (spouse, partner, etc.)?\",\" Any existing or proposed relationship, transaction, or other event which may raise a conflict of interest is to be disclosed. For detail, click here:\"))","v":"6. Is a direct family member of any of the above an Emory University employee (spouse, partner, etc.)? Any existing or proposed relationship, transaction, or other event which may raise a conflict of interest is to be disclosed. For detail, click here:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A64),FALSE)),\"\",IF(H65=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A64),FALSE),IF(C65=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$64=\"Yes\",\"R\",\"Y\"))","v":""},null,null,{"$f":"IF($H$64=\"Yes\",\"6a. Please provide the name of the direct family member who is an Emory University employee:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A65),FALSE)),\"\",IF(H66=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A65),FALSE),IF(C66=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$64=\"Yes\",\"R\",\"Y\"))","v":""},null,null,{"$f":"IF($H$64=\"Yes\",\"6b. Please provide the relationship of the direct family member to the Emory University Employee:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A66),FALSE)),\"\",IF(H67=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A66),FALSE),IF(C67=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"7. Emory offers 2 standard payment term options. The first is Net 0 which is through the SUA Program. The second is Net 30. For more information on SUA, please view the comment by hovering your mouse over this box.  Please select your preference."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A67),FALSE)),\"\",IF(H68=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A67),FALSE),IF(C68=FALSE,\"C\"))))","v":""},{"$f":"IF(H68=\"\",TRUE,ISNUMBER(FIND(\"@\",H68,1)+FIND(\".\",H68,1)))","v":true},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$67='Drop Down'!$D$2,\"R\",\"Y\"))","v":""},null,null,{"$f":"IF($H$67='Drop Down'!$D$2,\"7a. Please provide the email address where you would want us to send the notification of our payment to you for SUA Payments.\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A68),FALSE)),\"\",IF(H69=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A68),FALSE),IF(C69=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$67='Drop Down'!$D$5,\"R\",\"Y\"))","v":""},null,null,{"$f":"IF($H$67='Drop Down'!$D$5,\"7b. Please specify the payment terms that is stated in the contract with Emory.\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A69),FALSE)),\"\",IF(H70=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A69),FALSE),IF(C70=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$67='Drop Down'!$D$5,\"R\",\"Y\"))","v":""},null,null,{"$f":"IF($H$67='Drop Down'!$D$5,\"7c. When submitting this form, please validate you will submit a copy of the fully executed contract containing the payment term language.\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A70),FALSE)),\"\",IF(H71=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A70),FALSE),IF(C71=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$67='Drop Down'!$D$5,\"R\",\"Y\"))","v":""},null,null,{"$f":"IF($H$67='Drop Down'!$D$5,\"7d. Please indicate what page number within the fully executed contract, the payment terms can be found.\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A71),FALSE)),\"\",IF(H72=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A71),FALSE),IF(C72=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$67=\"\",RIGHT($H$67,8)=\"Program.\"),\"Y\",\"R\"))","v":""},null,null,{"$f":"IF(AND(Home!$D$7=\"Company\",OR($H$67=\"\",RIGHT($H$67,8)=\"Program.\")),\"\",CONCATENATE(\"8. Do you want to be paid via ACH/Direct Deposit? If No is selected, payment will be remitted via check sent to the billing address provided above.\",\" Please note that payments via check take significantly longer to process in comparision to ACH/Direct Deposit.\"))","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A72),FALSE)),\"\",IF(H73=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A72),FALSE),IF(C73=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"9. Emory highly encourages that your company be registered with The System for Award Management (SAM) because not doing so can preclude you as a supplier for contracts that Emory has with the U.S. government. For additional information and to register, please visit https://www.sam.gov/"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A73),FALSE)),\"\",IF(H74=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A73),FALSE),IF(C74=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":""},null,null,"l declare under penalty of perjury (under the laws of the United States of America) that the information provided on this form is true and correct."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A74),FALSE)),\"\",IF(H75=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A74),FALSE),IF(C75=FALSE,\"C\"))))","v":""},true,"",null,null,{"$f":"CONCATENATE(Home!D7,\" Authorized E-Signature:\",CHAR(10),\"(Please type your First and Last Name)\",CHAR(10),\"Please understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.\",\"Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature.\")","v":"Company Authorized E-Signature:\n(Please type your First and Last Name)\nPlease understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature."}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A75),FALSE)),\"\",IF(H76=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A75),FALSE),IF(C76=FALSE,\"C\"))))","v":""},true,"",null,null,"Date of Signature:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A76),FALSE)),\"\",IF(H77=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A76),FALSE),IF(C77=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A77),FALSE)),\"\",IF(H78=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A77),FALSE),IF(C78=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,null,"ACH Payment Authorization"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A78),FALSE)),\"\",IF(H79=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A78),FALSE),IF(C79=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,null,{"$f":"Home!D7&\" Information\"","v":"Company Information"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A79),FALSE)),\"\",IF(H80=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A79),FALSE),IF(C80=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,null,{"$f":"Home!D7&\" Name:\"","v":"Company Name:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A80),FALSE)),\"\",IF(H81=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A80),FALSE),IF(C81=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,null,{"$f":"Home!D7&\" Division Name:\"","v":"Company Division Name:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A81),FALSE)),\"\",IF(H82=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A81),FALSE),IF(C82=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H82+0)","v":true},"",null,null,"DUNS Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A82),FALSE)),\"\",IF(H83=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A82),FALSE),IF(C83=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H83+0)","v":true},"",null,null,{"$f":"IF(OR(Home!$D$7=\"Study Participant\",Home!$D$7=\"Individual\"),\"Social Security Number (9 Digits):\",\"Taxpayer Identification Number (9 Digits):\")","v":"Taxpayer Identification Number (9 Digits):"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A83),FALSE)),\"\",IF(H84=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A83),FALSE),IF(C84=FALSE,\"C\"))))","v":""},true,"",null,null,{"$f":"Home!D7&\" ACH Remittance Contact Name:\"","v":"Company ACH Remittance Contact Name:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A84),FALSE)),\"\",IF(H85=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A84),FALSE),IF(C85=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H85+0),LEFT(H85,1)=\"1\")","v":false},"",null,null,{"$f":"Home!D7&\" ACH Remittance Contact Phone:\"","v":"Company ACH Remittance Contact Phone:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A85),FALSE)),\"\",IF(H86=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A85),FALSE),IF(C86=FALSE,\"C\"))))","v":""},{"$f":"IF(H86=\"\",TRUE,ISNUMBER(FIND(\"@\",H86,1)+FIND(\".\",H86,1)))","v":true},"",null,null,{"$f":"Home!D7&\" ACH Remittance Email:\"","v":"Company ACH Remittance Email:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A86),FALSE)),\"\",IF(H87=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A86),FALSE),IF(C87=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,null,{"$f":"Home!D7&\" Remittance Address\"","v":"Company Remittance Address"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A87),FALSE)),\"\",IF(H88=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A87),FALSE),IF(C88=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,null,{"$f":"Home!D7&\" Remittance Address Line 1:\"","v":"Company Remittance Address Line 1:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A88),FALSE)),\"\",IF(H89=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A88),FALSE),IF(C89=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,null,{"$f":"Home!D7&\" Remittance Address Line 2:\"","v":"Company Remittance Address Line 2:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A89),FALSE)),\"\",IF(H90=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A89),FALSE),IF(C90=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,null,"City:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A90),FALSE)),\"\",IF(H91=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A90),FALSE),IF(C91=FALSE,\"C\"))))","v":""},true,"",null,null,"State:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A91),FALSE)),\"\",IF(H92=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A91),FALSE),IF(C92=FALSE,\"C\"))))","v":""},true,"",null,null,"ZIP:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A92),FALSE)),\"\",IF(H93=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A92),FALSE),IF(C93=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,null,"Banking Information"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A93),FALSE)),\"\",IF(H94=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A93),FALSE),IF(C94=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,null,"Name of Receiving Bank:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A94),FALSE)),\"\",IF(H95=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A94),FALSE),IF(C95=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H95+0)","v":true},"",null,null,"Routing Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A95),FALSE)),\"\",IF(H96=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A95),FALSE),IF(C96=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H96+0)","v":true},"",null,null,"Account Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A96),FALSE)),\"\",IF(H97=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A96),FALSE),IF(C97=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,null,{"$f":"Home!D7&\" Authorization\"","v":"Company Authorization"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A97),FALSE)),\"\",IF(H98=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A97),FALSE),IF(C98=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,null,"We hereby authorize, with the signature below, Emory University Payment Services to deposit all payments into the above referenced account."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A98),FALSE)),\"\",IF(H99=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A98),FALSE),IF(C99=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,null,{"$f":"CONCATENATE(Home!D7,\" Authorized E-Signature:\",CHAR(10),\"(Please type your First and Last Name)\",CHAR(10),\"Please understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.\",\"Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature.\")","v":"Company Authorized E-Signature:\n(Please type your First and Last Name)\nPlease understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature."}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A99),FALSE)),\"\",IF(H100=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A99),FALSE),IF(C100=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,null,"Date of Signature:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A100),FALSE)),\"\",IF(H101=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A100),FALSE),IF(C101=FALSE,\"C\"))))","v":""},true,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,null,"Authorized Signer's Title:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A101),FALSE)),\"\",IF(H102=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A101),FALSE),IF(C102=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H102+0),LEFT(H102,1)=\"1\")","v":false},{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,null,"Authorized Signer's Phone Number:"]

{"sheet":"INDV","index":3,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":false,"merged":[[36,6,36,7],[1,6,1,7],[2,6,2,7],[7,6,7,7],[8,6,8,7],[28,6,28,7],[86,6,86,7],[92,6,92,7],[96,6,96,7],[97,6,97,7],[47,6,47,7],[56,6,56,7],[57,6,57,7],[76,6,76,7],[77,6,77,7],[78,6,78,7]]}
[null,null,null,null,null,null,{"$f":"Home!C1&\" (\"&IF(Home!D8=\"Yes\",\"Domestic \",\"\")&Home!$D$7&\")\"","v":"Supplier Information Form (SIF) Version 2.0 Effective 10-27-2020 (Domestic Company)"}]
[null,{"$f":"IF(AND(Home!$D$7=\"Individual\",Home!$D$8<>\"No\"),\"Conditional Formatting\",\"\")","v":""},"Error Validation","Company","Individual","Study Participant",{"$f":"IF(AND(COUNTIF($B$3:$B$102,\"R\")>0,COUNTIF($B$3:$B$102,\"C\")>0),\"There are \"&COUNTIF($B$3:$B$102,\"R\")&\" required fields remaining highlighted in yellow with mini-dots.\"&CHAR(10)&\"There are \"&COUNTIF($B$3:$B$102,\"C\")&\" fields that need correction highlighted in red.\",IF(AND(COUNTIF($B$3:$B$102,\"R\")>0,COUNTIF($B$3:$B$102,\"C\")=0),\"There are \"&COUNTIF($B$3:$B$102,\"R\")&\" required fields remaining highlighted in yellow with mini-dots.\",IF(AND(COUNTIF($B$3:$B$102,\"R\")=0,COUNTIF($B$3:$B$102,\"C\")>0),\"There are \"&COUNTIF($B$3:$B$102,\"C\")&\" fields that need correction highlighted in red.\",\"Completed! Please submit this excel file to the Emory personnel that provided you this form.\")))","v":"Completed! Please submit this excel file to the Emory personnel that provided you this form."},null,null,{"$f":"HYPERLINK(CONCATENATE(\"#Home!D8\"),\"Click Here to Go Back\")","v":"Click Here to Go Back"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A2),FALSE)),\"\",IF(H3=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A2),FALSE),IF(C3=FALSE,\"C\"))))","v":""},true,null,"Y",null,"Prerequisite Questions"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A3),FALSE)),\"\",IF(H4=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A3),FALSE),IF(C4=FALSE,\"C\"))))","v":""},true,null,"R",null,{"$f":"IF(Home!$D$7=\"Company\",\"Is your company\",IF(Home!$D$7=\"Individual\",\"Are you\",\"\"))&\" filling out this form to update current information on file with Emory? If not sure, select 'No' from drop down box.\"","v":"Is your company filling out this form to update current information on file with Emory? If not sure, select 'No' from drop down box."}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A4),FALSE)),\"\",IF(H5=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A4),FALSE),IF(C5=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(H4=\"Yes\",\"R\",\"Y\")","v":"Y"},null,{"$f":"IF(H4=\"Yes\",IF(Home!$D$7=\"Company\",\"Does your company\",IF(Home!$D$7=\"Individual\",\"Do you\",\"\"))&\" only need to update the ACH/Banking information on file with Emory?\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A5),FALSE)),\"\",IF(H6=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A5),FALSE),IF(C6=FALSE,\"C\"))))","v":""},true,null,null,null,"Is your company the direct output of a merger, acquisition, or spinoff?","No"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A6),FALSE)),\"\",IF(H7=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A6),FALSE),IF(C7=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(H6=\"Yes\",\"Please provide a brief description of the merger, acquisition, or spinoff:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A7),FALSE)),\"\",IF(H8=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A7),FALSE),IF(C8=FALSE,\"C\"))))","v":""},true,null,"Y"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A8),FALSE)),\"\",IF(H9=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A8),FALSE),IF(C9=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,{"$f":"Home!D7&\" Name and Information\"","v":"Company Name and Information"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A9),FALSE)),\"\",IF(H10=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A9),FALSE),IF(C10=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,"Legal Full Name:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A10),FALSE)),\"\",IF(H11=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A10),FALSE),IF(C11=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,"DBA Name, If Different:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A11),FALSE)),\"\",IF(H12=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A11),FALSE),IF(C12=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H12+0)","v":true},null,null,null,"DUNS Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A12),FALSE)),\"\",IF(H13=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A12),FALSE),IF(C13=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,"Contact Name:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A13),FALSE)),\"\",IF(H14=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A13),FALSE),IF(C14=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H14+0),LEFT(H14,1)=\"1\")","v":false},null,"R",null,"Contact Phone Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A14),FALSE)),\"\",IF(H15=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A14),FALSE),IF(C15=FALSE,\"C\"))))","v":""},{"$f":"IF(H15=\"\",TRUE,ISNUMBER(FIND(\"@\",H15,1)+FIND(\".\",H15,1)))","v":true},null,"R",null,"Contact Email:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A15),FALSE)),\"\",IF(H16=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A15),FALSE),IF(C16=FALSE,\"C\"))))","v":""},true,null,null,null,"Taxpayer Identification Number (Select Type):"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A16),FALSE)),\"\",IF(H17=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A16),FALSE),IF(C17=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H17+0)","v":true},null,"R",null,{"$f":"IF(OR(Home!$D$7=\"Study Participant\",Home!$D$7=\"Individual\"),\"Social Security Number (SSN) (9 Digits):\",IF(H16=\"\",\"\",$H$16&\" (9 Digits) :\"))","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A17),FALSE)),\"\",IF(H18=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A17),FALSE),IF(C18=FALSE,\"C\"))))","v":""},true,null,null,null,"Select the appropriate entity type for federal tax classification:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A18),FALSE)),\"\",IF(H19=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A18),FALSE),IF(C19=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(H18=\"Limited Liability Company (LLC)\",\"If LLC, Select Tax Classification:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A19),FALSE)),\"\",IF(H20=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A19),FALSE),IF(C20=FALSE,\"C\"))))","v":""},true,null,null,null,"Would your company identify as a small and/or diverse business?"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A20),FALSE)),\"\",IF(H21=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A20),FALSE),IF(C21=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Disadvantaged Business (DBE):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A21),FALSE)),\"\",IF(H22=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A21),FALSE),IF(C22=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Woman-Owned Business (WBE):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A22),FALSE)),\"\",IF(H23=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A22),FALSE),IF(C23=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Minority Owned Business (MBE):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A23),FALSE)),\"\",IF(H24=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A23),FALSE),IF(C24=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Veteran Owned Business (VBE):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A24),FALSE)),\"\",IF(H25=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A24),FALSE),IF(C25=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Historically Black Colleges / Universities & Minority Institutions:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A25),FALSE)),\"\",IF(H26=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A25),FALSE),IF(C26=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\"),\"Indicate if HUBZone Small Business (HUB Zone):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A26),FALSE)),\"\",IF(H27=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A26),FALSE),IF(C27=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\"),\"Indicate if Service Disabled Veteran-Owned Small Business (SDVOSB):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A27),FALSE)),\"\",IF(H28=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A27),FALSE),IF(C28=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\"),\"Indicate if Alaskan Native Corporations (ANCs) & Indian Tribes):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A28),FALSE)),\"\",IF(H29=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A28),FALSE),IF(C29=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,"Legal Mailing Address"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A29),FALSE)),\"\",IF(H30=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A29),FALSE),IF(C30=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,"Address Line 1:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A30),FALSE)),\"\",IF(H31=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A30),FALSE),IF(C31=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,"Address Line 2:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A31),FALSE)),\"\",IF(H32=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A31),FALSE),IF(C32=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,"City:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A32),FALSE)),\"\",IF(H33=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A32),FALSE),IF(C33=FALSE,\"C\"))))","v":""},true,null,"R",null,"State:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A33),FALSE)),\"\",IF(H34=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A33),FALSE),IF(C34=FALSE,\"C\"))))","v":""},true,null,"R",null,"ZIP Code:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A34),FALSE)),\"\",IF(H35=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A34),FALSE),IF(C35=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H35+0),LEFT(H35,1)=\"1\")","v":false},null,null,null,"Phone:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A35),FALSE)),\"\",IF(H36=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A35),FALSE),IF(C36=FALSE,\"C\"))))","v":""},{"$f":"IF(H36=\"\",TRUE,ISNUMBER(FIND(\"@\",H36,1)+FIND(\".\",H36,1)))","v":true},null,null,null,"Email:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A36),FALSE)),\"\",IF(H37=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A36),FALSE),IF(C37=FALSE,\"C\"))))","v":""},true,null,null,null,"Shipping Address"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A37),FALSE)),\"\",IF(H38=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A37),FALSE),IF(C38=FALSE,\"C\"))))","v":""},true,null,null,null,"Method to Receive Orders:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A38),FALSE)),\"\",IF(H39=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A38),FALSE),IF(C39=FALSE,\"C\"))))","v":""},{"$f":"IF(H39=\"\",TRUE,ISNUMBER(FIND(\"@\",H39,1)+FIND(\".\",H39,1)))","v":true},null,null,null,{"$f":"IF(LEFT($H$38,5)=\"Email\",\"Email for Receiving Orders:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A39),FALSE)),\"\",IF(H40=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A39),FALSE),IF(C40=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H40+0)","v":true},null,null,null,{"$f":"IF($H$38=\"Fax\",\"Fax Number for Receiving Orders:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A40),FALSE)),\"\",IF(H41=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A40),FALSE),IF(C41=FALSE,\"C\"))))","v":""},true,null,null,null,"Is the Shipping Address and contact information exactly the same as the Legal Mailing Address?"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A41),FALSE)),\"\",IF(H42=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A41),FALSE),IF(C42=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$41=\"No\",\"Address Line 1:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A42),FALSE)),\"\",IF(H43=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A42),FALSE),IF(C43=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$41=\"No\",\"Address Line 2:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A43),FALSE)),\"\",IF(H44=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A43),FALSE),IF(C44=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$41=\"No\",\"City:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A44),FALSE)),\"\",IF(H45=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A44),FALSE),IF(C45=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$41=\"No\",\"State:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A45),FALSE)),\"\",IF(H46=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A45),FALSE),IF(C46=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$41=\"No\",\"ZIP Code:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A46),FALSE)),\"\",IF(H47=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A46),FALSE),IF(C47=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H47+0),LEFT(H47,1)=\"1\")","v":false},null,null,null,{"$f":"IF($H$41=\"No\",\"Phone:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A47),FALSE)),\"\",IF(H48=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A47),FALSE),IF(C48=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,"Remit to Address (Billing Address)"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A48),FALSE)),\"\",IF(H49=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A48),FALSE),IF(C49=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,"Is the Remit to Address (Billing Address) and contact information exactly the same as the Legal Mailing Address?"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A49),FALSE)),\"\",IF(H50=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A49),FALSE),IF(C50=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$49=\"Yes\",$H$49=\"\"),\"Y\",\"R\"))","v":"Y"},null,{"$f":"IF($H$49=\"No\",\"Address Line 1:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A50),FALSE)),\"\",IF(H51=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A50),FALSE),IF(C51=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,{"$f":"IF($H$49=\"No\",\"Address Line 2:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A51),FALSE)),\"\",IF(H52=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A51),FALSE),IF(C52=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$49=\"Yes\",$H$49=\"\"),\"Y\",\"R\"))","v":"Y"},null,{"$f":"IF($H$49=\"No\",\"City:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A52),FALSE)),\"\",IF(H53=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A52),FALSE),IF(C53=FALSE,\"C\"))))","v":""},true,null,"Y",null,{"$f":"IF($H$49=\"No\",\"State:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A53),FALSE)),\"\",IF(H54=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A53),FALSE),IF(C54=FALSE,\"C\"))))","v":""},true,null,"Y",null,{"$f":"IF($H$49=\"No\",\"ZIP Code:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A54),FALSE)),\"\",IF(H55=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A54),FALSE),IF(C55=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H55+0),LEFT(H55,1)=\"1\")","v":false},null,"Y",null,{"$f":"IF($H$49=\"No\",\"Phone:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A55),FALSE)),\"\",IF(H56=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A55),FALSE),IF(C56=FALSE,\"C\"))))","v":""},{"$f":"IF(H56=\"\",TRUE,ISNUMBER(FIND(\"@\",H56,1)+FIND(\".\",H56,1)))","v":true},null,"Y",null,{"$f":"IF($H$49=\"No\",\"Email:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A56),FALSE)),\"\",IF(H57=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A56),FALSE),IF(C57=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"},null,"Certifications"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A57),FALSE)),\"\",IF(H58=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A57),FALSE),IF(C58=FALSE,\"C\"))))","v":""},true,null,"Y",null,"Under penalties of perjury, I certify by electronically signing below."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A58),FALSE)),\"\",IF(H59=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A58),FALSE),IF(C59=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,"1. The number shown on this form is my correct taxpayer identification number (or I am waiting for a number to be issued to me)."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A59),FALSE)),\"\",IF(H60=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A59),FALSE),IF(C60=FALSE,\"C\"))))","v":""},true,null,"R",null,"2. I am not subject to backup withholding because (a) I am exempt from backup withholding, or (b) I have not been notified by the Internal Revenue Service (IRS) that I am subject to backup withholding as a result of a failure to report all interest or dividends, or (c) the IRS has notified me that I am no longer subject to backup withholding."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A60),FALSE)),\"\",IF(H61=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A60),FALSE),IF(C61=FALSE,\"C\"))))","v":""},true,null,null,null,"3. My firm is not currently debarred, suspended, or proposed for debarment by any federal entity and I agree to notify Emory University Payment Services of any change in status."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A61),FALSE)),\"\",IF(H62=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A61),FALSE),IF(C62=FALSE,\"C\"))))","v":""},true,null,null,null,"4. My firm does not currently have any employees, vendors, or other types of contractual relationships in place with parties on the U.S. Department of Treasury Office of Foreign Assets Control Specially Designated National (SDN) List. This list can be found at the following URL: http://www.ustreas.gov/offices/enforcement/ofac/sdn/"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A62),FALSE)),\"\",IF(H63=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A62),FALSE),IF(C63=FALSE,\"C\"))))","v":""},true,null,"R",null,{"$f":"IF(Home!$D$7=\"Company\",\"5. Are you or any Officer, Owner or Partner in this company an employee of Emory University?\",IF(Home!$D$7=\"Individual\",\"5. Are you an employee of Emory University?\",\"\"))","v":"5. Are you or any Officer, Owner or Partner in this company an employee of Emory University?"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A63),FALSE)),\"\",IF(H64=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A63),FALSE),IF(C64=FALSE,\"C\"))))","v":""},true,null,"R",null,{"$f":"HYPERLINK(\"https://emory.ellucid.com/documents/view/17693/?security=353f1df192117ef8139f94032abe5f3cd53a8395\",CONCATENATE(\"6. Is a direct family member of any of the above an Emory University employee (spouse, partner, etc.)?\",\" Any existing or proposed relationship, transaction, or other event which may raise a conflict of interest is to be disclosed. For detail, click here:\"))","v":"6. Is a direct family member of any of the above an Emory University employee (spouse, partner, etc.)? Any existing or proposed relationship, transaction, or other event which may raise a conflict of interest is to be disclosed. For detail, click here:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A64),FALSE)),\"\",IF(H65=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A64),FALSE),IF(C65=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$64=\"Yes\",\"R\",\"Y\"))","v":"Y"},null,{"$f":"IF($H$64=\"Yes\",\"6a. Please provide the name of the direct family member who is an Emory University employee:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A65),FALSE)),\"\",IF(H66=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A65),FALSE),IF(C66=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$64=\"Yes\",\"R\",\"Y\"))","v":"Y"},null,{"$f":"IF($H$64=\"Yes\",\"6b. Please provide the relationship of the direct family member to the Emory University Employee:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A66),FALSE)),\"\",IF(H67=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A66),FALSE),IF(C67=FALSE,\"C\"))))","v":""},true,null,null,null,"7. Emory offers 2 standard payment term options. The first is Net 0 which is through the SUA Program. The second is Net 30. For more information on SUA, please view the comment by hovering your mouse over this box.  Please select your preference."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A67),FALSE)),\"\",IF(H68=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A67),FALSE),IF(C68=FALSE,\"C\"))))","v":""},{"$f":"IF(H68=\"\",TRUE,ISNUMBER(FIND(\"@\",H68,1)+FIND(\".\",H68,1)))","v":true},null,null,null,{"$f":"IF($H$67='Drop Down'!$D$2,\"7a. Please provide the email address where you would want us to send the notification of our payment to you for SUA Payments.\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A68),FALSE)),\"\",IF(H69=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A68),FALSE),IF(C69=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$67='Drop Down'!$D$5,\"7b. Please specify the payment terms that is stated in the contract with Emory.\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A69),FALSE)),\"\",IF(H70=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A69),FALSE),IF(C70=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$67='Drop Down'!$D$5,\"7c. When submitting this form, please validate you will submit a copy of the fully executed contract containing the payment term language.\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A70),FALSE)),\"\",IF(H71=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A70),FALSE),IF(C71=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$67='Drop Down'!$D$5,\"7d. Please indicate what page number within the fully executed contract, the payment terms can be found.\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A71),FALSE)),\"\",IF(H72=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A71),FALSE),IF(C72=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,{"$f":"IF(AND(Home!$D$7=\"Company\",OR($H$67=\"\",RIGHT($H$67,8)=\"Program.\")),\"\",CONCATENATE(\"8. Do you want to be paid via ACH/Direct Deposit? If No is selected, payment will be remitted via check sent to the billing address provided above.\",\" Please note that payments via check take significantly longer to process in comparision to ACH/Direct Deposit.\"))","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A72),FALSE)),\"\",IF(H73=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A72),FALSE),IF(C73=FALSE,\"C\"))))","v":""},true,null,null,null,"9. Emory highly encourages that your company be registered with The System for Award Management (SAM) because not doing so can preclude you as a supplier for contracts that Emory has with the U.S. government. For additional information and to register, please visit https://www.sam.gov/"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A73),FALSE)),\"\",IF(H74=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A73),FALSE),IF(C74=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF($H$5=\"Yes\",\"Y\",\"R\"))","v":"R"},null,"l declare under penalty of perjury (under the laws of the United States of America) that the information provided on this form is true and correct."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A74),FALSE)),\"\",IF(H75=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A74),FALSE),IF(C75=FALSE,\"C\"))))","v":""},true,null,"R",null,{"$f":"CONCATENATE(Home!D7,\" Authorized E-Signature:\",CHAR(10),\"(Please type your First and Last Name)\",CHAR(10),\"Please understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.\",\"Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature.\")","v":"Company Authorized E-Signature:\n(Please type your First and Last Name)\nPlease understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature."}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A75),FALSE)),\"\",IF(H76=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A75),FALSE),IF(C76=FALSE,\"C\"))))","v":""},true,null,"R",null,"Date of Signature:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A76),FALSE)),\"\",IF(H77=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A76),FALSE),IF(C77=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",\"Y\")","v":"Y"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A77),FALSE)),\"\",IF(H78=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A77),FALSE),IF(C78=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,"ACH Payment Authorization"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A78),FALSE)),\"\",IF(H79=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A78),FALSE),IF(C79=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,{"$f":"Home!D7&\" Information\"","v":"Company Information"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A79),FALSE)),\"\",IF(H80=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A79),FALSE),IF(C80=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,{"$f":"Home!D7&\" Name:\"","v":"Company Name:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A80),FALSE)),\"\",IF(H81=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A80),FALSE),IF(C81=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"Home!D7&\" Division Name:\"","v":"Company Division Name:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A81),FALSE)),\"\",IF(H82=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A81),FALSE),IF(C82=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H82+0)","v":true},null,null,null,"DUNS Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A82),FALSE)),\"\",IF(H83=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A82),FALSE),IF(C83=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H83+0)","v":true},null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,{"$f":"IF(OR(Home!$D$7=\"Study Participant\",Home!$D$7=\"Individual\"),\"Social Security Number (9 Digits):\",\"Taxpayer Identification Number (9 Digits):\")","v":"Taxpayer Identification Number (9 Digits):"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A83),FALSE)),\"\",IF(H84=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A83),FALSE),IF(C84=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,{"$f":"Home!D7&\" ACH Remittance Contact Name:\"","v":"Company ACH Remittance Contact Name:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A84),FALSE)),\"\",IF(H85=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A84),FALSE),IF(C85=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H85+0),LEFT(H85,1)=\"1\")","v":false},null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,{"$f":"Home!D7&\" ACH Remittance Contact Phone:\"","v":"Company ACH Remittance Contact Phone:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A85),FALSE)),\"\",IF(H86=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A85),FALSE),IF(C86=FALSE,\"C\"))))","v":""},{"$f":"IF(H86=\"\",TRUE,ISNUMBER(FIND(\"@\",H86,1)+FIND(\".\",H86,1)))","v":true},null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,{"$f":"Home!D7&\" ACH Remittance Email:\"","v":"Company ACH Remittance Email:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A86),FALSE)),\"\",IF(H87=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A86),FALSE),IF(C87=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,{"$f":"Home!D7&\" Remittance Address\"","v":"Company Remittance Address"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A87),FALSE)),\"\",IF(H88=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A87),FALSE),IF(C88=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,{"$f":"Home!D7&\" Remittance Address Line 1:\"","v":"Company Remittance Address Line 1:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A88),FALSE)),\"\",IF(H89=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A88),FALSE),IF(C89=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,{"$f":"Home!D7&\" Remittance Address Line 2:\"","v":"Company Remittance Address Line 2:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A89),FALSE)),\"\",IF(H90=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A89),FALSE),IF(C90=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,"City:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A90),FALSE)),\"\",IF(H91=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A90),FALSE),IF(C91=FALSE,\"C\"))))","v":""},true,null,"",null,"State:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A91),FALSE)),\"\",IF(H92=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A91),FALSE),IF(C92=FALSE,\"C\"))))","v":""},true,null,"",null,"ZIP:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A92),FALSE)),\"\",IF(H93=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A92),FALSE),IF(C93=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,"Banking Information"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A93),FALSE)),\"\",IF(H94=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A93),FALSE),IF(C94=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,"Name of Receiving Bank:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A94),FALSE)),\"\",IF(H95=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A94),FALSE),IF(C95=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H95+0)","v":true},null,"",null,"Routing Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A95),FALSE)),\"\",IF(H96=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A95),FALSE),IF(C96=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H96+0)","v":true},null,"",null,"Account Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A96),FALSE)),\"\",IF(H97=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A96),FALSE),IF(C97=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,{"$f":"Home!D7&\" Authorization\"","v":"Company Authorization"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A97),FALSE)),\"\",IF(H98=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A97),FALSE),IF(C98=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},null,"We hereby authorize, with the signature below, Emory University Payment Services to deposit all payments into the above referenced account."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A98),FALSE)),\"\",IF(H99=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A98),FALSE),IF(C99=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,{"$f":"CONCATENATE(Home!D7,\" Authorized E-Signature:\",CHAR(10),\"(Please type your First and Last Name)\",CHAR(10),\"Please understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.\",\"Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature.\")","v":"Company Authorized E-Signature:\n(Please type your First and Last Name)\nPlease understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature."}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A99),FALSE)),\"\",IF(H100=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A99),FALSE),IF(C100=FALSE,\"C\"))))","v":""},true,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},null,"Date of Signature:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A100),FALSE)),\"\",IF(H101=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A100),FALSE),IF(C101=FALSE,\"C\"))))","v":""},true,null,null,null,"Authorized Signer's Title:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A101),FALSE)),\"\",IF(H102=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A101),FALSE),IF(C102=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H102+0),LEFT(H102,1)=\"1\")","v":false},null,null,null,"Authorized Signer's Phone Number:"]

{"sheet":"STPT","index":4,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":false,"merged":[[36,6,36,7],[1,6,1,7],[2,6,2,7],[7,6,7,7],[8,6,8,7],[28,6,28,7],[86,6,86,7],[92,6,92,7],[96,6,96,7],[97,6,97,7],[47,6,47,7],[56,6,56,7],[57,6,57,7],[76,6,76,7],[77,6,77,7],[78,6,78,7]]}
[null,null,null,null,null,null,{"$f":"Home!C1&\" (\"&IF(Home!D8=\"Yes\",\"Domestic \",\"\")&Home!$D$7&\")\"","v":"Supplier Information Form (SIF) Version 2.0 Effective 10-27-2020 (Domestic Company)"}]
[null,{"$f":"IF(AND(Home!$D$7=\"Study Participant\",Home!$D$8<>\"No\"),\"Conditional Formatting\",\"\")","v":""},"Error Validation","Company","Individual","Study Participant",{"$f":"IF(AND(COUNTIF($B$3:$B$102,\"R\")>0,COUNTIF($B$3:$B$102,\"C\")>0),\"There are \"&COUNTIF($B$3:$B$102,\"R\")&\" required fields remaining highlighted in yellow with mini-dots.\"&CHAR(10)&\"There are \"&COUNTIF($B$3:$B$102,\"C\")&\" fields that need correction highlighted in red.\",IF(AND(COUNTIF($B$3:$B$102,\"R\")>0,COUNTIF($B$3:$B$102,\"C\")=0),\"There are \"&COUNTIF($B$3:$B$102,\"R\")&\" required fields remaining highlighted in yellow with mini-dots.\",IF(AND(COUNTIF($B$3:$B$102,\"R\")=0,COUNTIF($B$3:$B$102,\"C\")>0),\"There are \"&COUNTIF($B$3:$B$102,\"C\")&\" fields that need correction highlighted in red.\",\"Completed! Please submit this excel file to the Emory personnel that provided you this form.\")))","v":"Completed! Please submit this excel file to the Emory personnel that provided you this form."},null,null,{"$f":"HYPERLINK(CONCATENATE(\"#Home!D8\"),\"Click Here to Go Back\")","v":"Click Here to Go Back"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A2),FALSE)),\"\",IF(H3=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A2),FALSE),IF(C3=FALSE,\"C\"))))","v":""},true,null,null,null,"Prerequisite Questions"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A3),FALSE)),\"\",IF(H4=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A3),FALSE),IF(C4=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(Home!$D$7=\"Company\",\"Is your company\",IF(Home!$D$7=\"Individual\",\"Are you\",\"\"))&\" filling out this form to update current information on file with Emory? If not sure, select 'No' from drop down box.\"","v":"Is your company filling out this form to update current information on file with Emory? If not sure, select 'No' from drop down box."},"Yes"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A4),FALSE)),\"\",IF(H5=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A4),FALSE),IF(C5=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(H4=\"Yes\",IF(Home!$D$7=\"Company\",\"Does your company\",IF(Home!$D$7=\"Individual\",\"Do you\",\"\"))&\" only need to update the ACH/Banking information on file with Emory?\",\"\")","v":"Does your company only need to update the ACH/Banking information on file with Emory?"},"No"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A5),FALSE)),\"\",IF(H6=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A5),FALSE),IF(C6=FALSE,\"C\"))))","v":""},true,null,null,null,"Is your company the direct output of a merger, acquisition, or spinoff?","No"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A6),FALSE)),\"\",IF(H7=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A6),FALSE),IF(C7=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(H6=\"Yes\",\"Please provide a brief description of the merger, acquisition, or spinoff:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A7),FALSE)),\"\",IF(H8=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A7),FALSE),IF(C8=FALSE,\"C\"))))","v":""},true,null,null,"Y"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A8),FALSE)),\"\",IF(H9=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A8),FALSE),IF(C9=FALSE,\"C\"))))","v":""},true,null,null,"Y",{"$f":"Home!D7&\" Name and Information\"","v":"Company Name and Information"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A9),FALSE)),\"\",IF(H10=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A9),FALSE),IF(C10=FALSE,\"C\"))))","v":""},true,null,null,"R","Legal Full Name:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A10),FALSE)),\"\",IF(H11=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A10),FALSE),IF(C11=FALSE,\"C\"))))","v":""},true,null,null,null,"DBA Name, If Different:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A11),FALSE)),\"\",IF(H12=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A11),FALSE),IF(C12=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H12+0)","v":true},null,null,null,"DUNS Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A12),FALSE)),\"\",IF(H13=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A12),FALSE),IF(C13=FALSE,\"C\"))))","v":""},true,null,null,"R","Contact Name:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A13),FALSE)),\"\",IF(H14=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A13),FALSE),IF(C14=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H14+0),LEFT(H14,1)=\"1\")","v":false},null,null,"R","Contact Phone Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A14),FALSE)),\"\",IF(H15=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A14),FALSE),IF(C15=FALSE,\"C\"))))","v":""},{"$f":"IF(H15=\"\",TRUE,ISNUMBER(FIND(\"@\",H15,1)+FIND(\".\",H15,1)))","v":true},null,null,"R","Contact Email:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A15),FALSE)),\"\",IF(H16=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A15),FALSE),IF(C16=FALSE,\"C\"))))","v":""},true,null,null,null,"Taxpayer Identification Number (Select Type):"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A16),FALSE)),\"\",IF(H17=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A16),FALSE),IF(C17=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H17+0)","v":true},null,null,"R",{"$f":"IF(OR(Home!$D$7=\"Study Participant\",Home!$D$7=\"Individual\"),\"Social Security Number (SSN) (9 Digits):\",IF(H16=\"\",\"\",$H$16&\" (9 Digits) :\"))","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A17),FALSE)),\"\",IF(H18=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A17),FALSE),IF(C18=FALSE,\"C\"))))","v":""},true,null,null,null,"Select the appropriate entity type for federal tax classification:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A18),FALSE)),\"\",IF(H19=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A18),FALSE),IF(C19=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(H18=\"Limited Liability Company (LLC)\",\"If LLC, Select Tax Classification:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A19),FALSE)),\"\",IF(H20=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A19),FALSE),IF(C20=FALSE,\"C\"))))","v":""},true,null,null,null,"Would your company identify as a small and/or diverse business?"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A20),FALSE)),\"\",IF(H21=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A20),FALSE),IF(C21=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Disadvantaged Business (DBE):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A21),FALSE)),\"\",IF(H22=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A21),FALSE),IF(C22=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Woman-Owned Business (WBE):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A22),FALSE)),\"\",IF(H23=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A22),FALSE),IF(C23=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Minority Owned Business (MBE):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A23),FALSE)),\"\",IF(H24=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A23),FALSE),IF(C24=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Veteran Owned Business (VBE):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A24),FALSE)),\"\",IF(H25=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A24),FALSE),IF(C25=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\",$H$20=\"Yes - Diverse Only\"),\"Indicate if Historically Black Colleges / Universities & Minority Institutions:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A25),FALSE)),\"\",IF(H26=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A25),FALSE),IF(C26=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\"),\"Indicate if HUBZone Small Business (HUB Zone):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A26),FALSE)),\"\",IF(H27=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A26),FALSE),IF(C27=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\"),\"Indicate if Service Disabled Veteran-Owned Small Business (SDVOSB):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A27),FALSE)),\"\",IF(H28=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A27),FALSE),IF(C28=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(OR($H$20=\"Yes - Small and Diverse\"),\"Indicate if Alaskan Native Corporations (ANCs) & Indian Tribes):\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A28),FALSE)),\"\",IF(H29=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A28),FALSE),IF(C29=FALSE,\"C\"))))","v":""},true,null,null,"Y","Legal Mailing Address"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A29),FALSE)),\"\",IF(H30=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A29),FALSE),IF(C30=FALSE,\"C\"))))","v":""},true,null,null,"R","Address Line 1:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A30),FALSE)),\"\",IF(H31=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A30),FALSE),IF(C31=FALSE,\"C\"))))","v":""},true,null,null,"Y","Address Line 2:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A31),FALSE)),\"\",IF(H32=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A31),FALSE),IF(C32=FALSE,\"C\"))))","v":""},true,null,null,"R","City:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A32),FALSE)),\"\",IF(H33=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A32),FALSE),IF(C33=FALSE,\"C\"))))","v":""},true,null,null,"R","State:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A33),FALSE)),\"\",IF(H34=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A33),FALSE),IF(C34=FALSE,\"C\"))))","v":""},true,null,null,"R","ZIP Code:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A34),FALSE)),\"\",IF(H35=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A34),FALSE),IF(C35=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H35+0),LEFT(H35,1)=\"1\")","v":false},null,null,null,"Phone:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A35),FALSE)),\"\",IF(H36=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A35),FALSE),IF(C36=FALSE,\"C\"))))","v":""},{"$f":"IF(H36=\"\",TRUE,ISNUMBER(FIND(\"@\",H36,1)+FIND(\".\",H36,1)))","v":true},null,null,null,"Email:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A36),FALSE)),\"\",IF(H37=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A36),FALSE),IF(C37=FALSE,\"C\"))))","v":""},true,null,null,null,"Shipping Address"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A37),FALSE)),\"\",IF(H38=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A37),FALSE),IF(C38=FALSE,\"C\"))))","v":""},true,null,null,null,"Method to Receive Orders:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A38),FALSE)),\"\",IF(H39=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A38),FALSE),IF(C39=FALSE,\"C\"))))","v":""},{"$f":"IF(H39=\"\",TRUE,ISNUMBER(FIND(\"@\",H39,1)+FIND(\".\",H39,1)))","v":true},null,null,null,{"$f":"IF(LEFT($H$38,5)=\"Email\",\"Email for Receiving Orders:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A39),FALSE)),\"\",IF(H40=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A39),FALSE),IF(C40=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H40+0)","v":true},null,null,null,{"$f":"IF($H$38=\"Fax\",\"Fax Number for Receiving Orders:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A40),FALSE)),\"\",IF(H41=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A40),FALSE),IF(C41=FALSE,\"C\"))))","v":""},true,null,null,null,"Is the Shipping Address and contact information exactly the same as the Legal Mailing Address?"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A41),FALSE)),\"\",IF(H42=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A41),FALSE),IF(C42=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$41=\"No\",\"Address Line 1:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A42),FALSE)),\"\",IF(H43=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A42),FALSE),IF(C43=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$41=\"No\",\"Address Line 2:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A43),FALSE)),\"\",IF(H44=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A43),FALSE),IF(C44=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$41=\"No\",\"City:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A44),FALSE)),\"\",IF(H45=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A44),FALSE),IF(C45=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$41=\"No\",\"State:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A45),FALSE)),\"\",IF(H46=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A45),FALSE),IF(C46=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$41=\"No\",\"ZIP Code:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A46),FALSE)),\"\",IF(H47=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A46),FALSE),IF(C47=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H47+0),LEFT(H47,1)=\"1\")","v":false},null,null,null,{"$f":"IF($H$41=\"No\",\"Phone:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A47),FALSE)),\"\",IF(H48=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A47),FALSE),IF(C48=FALSE,\"C\"))))","v":""},true,null,null,null,"Remit to Address (Billing Address)"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A48),FALSE)),\"\",IF(H49=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A48),FALSE),IF(C49=FALSE,\"C\"))))","v":""},true,null,null,null,"Is the Remit to Address (Billing Address) and contact information exactly the same as the Legal Mailing Address?"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A49),FALSE)),\"\",IF(H50=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A49),FALSE),IF(C50=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$49=\"No\",\"Address Line 1:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A50),FALSE)),\"\",IF(H51=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A50),FALSE),IF(C51=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$49=\"No\",\"Address Line 2:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A51),FALSE)),\"\",IF(H52=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A51),FALSE),IF(C52=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$49=\"No\",\"City:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A52),FALSE)),\"\",IF(H53=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A52),FALSE),IF(C53=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$49=\"No\",\"State:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A53),FALSE)),\"\",IF(H54=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A53),FALSE),IF(C54=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$49=\"No\",\"ZIP Code:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A54),FALSE)),\"\",IF(H55=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A54),FALSE),IF(C55=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H55+0),LEFT(H55,1)=\"1\")","v":false},null,null,null,{"$f":"IF($H$49=\"No\",\"Phone:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A55),FALSE)),\"\",IF(H56=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A55),FALSE),IF(C56=FALSE,\"C\"))))","v":""},{"$f":"IF(H56=\"\",TRUE,ISNUMBER(FIND(\"@\",H56,1)+FIND(\".\",H56,1)))","v":true},null,null,null,{"$f":"IF($H$49=\"No\",\"Email:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A56),FALSE)),\"\",IF(H57=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A56),FALSE),IF(C57=FALSE,\"C\"))))","v":""},true,null,null,"Y","Certifications"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A57),FALSE)),\"\",IF(H58=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A57),FALSE),IF(C58=FALSE,\"C\"))))","v":""},true,null,null,"Y","Under penalties of perjury, I certify by electronically signing below."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A58),FALSE)),\"\",IF(H59=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A58),FALSE),IF(C59=FALSE,\"C\"))))","v":""},true,null,null,"R","1. The number shown on this form is my correct taxpayer identification number (or I am waiting for a number to be issued to me)."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A59),FALSE)),\"\",IF(H60=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A59),FALSE),IF(C60=FALSE,\"C\"))))","v":""},true,null,null,"R","2. I am not subject to backup withholding because (a) I am exempt from backup withholding, or (b) I have not been notified by the Internal Revenue Service (IRS) that I am subject to backup withholding as a result of a failure to report all interest or dividends, or (c) the IRS has notified me that I am no longer subject to backup withholding."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A60),FALSE)),\"\",IF(H61=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A60),FALSE),IF(C61=FALSE,\"C\"))))","v":""},true,null,null,null,"3. My firm is not currently debarred, suspended, or proposed for debarment by any federal entity and I agree to notify Emory University Payment Services of any change in status."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A61),FALSE)),\"\",IF(H62=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A61),FALSE),IF(C62=FALSE,\"C\"))))","v":""},true,null,null,null,"4. My firm does not currently have any employees, vendors, or other types of contractual relationships in place with parties on the U.S. Department of Treasury Office of Foreign Assets Control Specially Designated National (SDN) List. This list can be found at the following URL: http://www.ustreas.gov/offices/enforcement/ofac/sdn/"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A62),FALSE)),\"\",IF(H63=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A62),FALSE),IF(C63=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF(Home!$D$7=\"Company\",\"5. Are you or any Officer, Owner or Partner in this company an employee of Emory University?\",IF(Home!$D$7=\"Individual\",\"5. Are you an employee of Emory University?\",\"\"))","v":"5. Are you or any Officer, Owner or Partner in this company an employee of Emory University?"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A63),FALSE)),\"\",IF(H64=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A63),FALSE),IF(C64=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"HYPERLINK(\"https://emory.ellucid.com/documents/view/17693/?security=353f1df192117ef8139f94032abe5f3cd53a8395\",CONCATENATE(\"6. Is a direct family member of any of the above an Emory University employee (spouse, partner, etc.)?\",\" Any existing or proposed relationship, transaction, or other event which may raise a conflict of interest is to be disclosed. For detail, click here:\"))","v":"6. Is a direct family member of any of the above an Emory University employee (spouse, partner, etc.)? Any existing or proposed relationship, transaction, or other event which may raise a conflict of interest is to be disclosed. For detail, click here:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A64),FALSE)),\"\",IF(H65=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A64),FALSE),IF(C65=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$64=\"Yes\",\"6a. Please provide the name of the direct family member who is an Emory University employee:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A65),FALSE)),\"\",IF(H66=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A65),FALSE),IF(C66=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$64=\"Yes\",\"6b. Please provide the relationship of the direct family member to the Emory University Employee:\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A66),FALSE)),\"\",IF(H67=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A66),FALSE),IF(C67=FALSE,\"C\"))))","v":""},true,null,null,null,"7. Emory offers 2 standard payment term options. The first is Net 0 which is through the SUA Program. The second is Net 30. For more information on SUA, please view the comment by hovering your mouse over this box.  Please select your preference."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A67),FALSE)),\"\",IF(H68=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A67),FALSE),IF(C68=FALSE,\"C\"))))","v":""},{"$f":"IF(H68=\"\",TRUE,ISNUMBER(FIND(\"@\",H68,1)+FIND(\".\",H68,1)))","v":true},null,null,null,{"$f":"IF($H$67='Drop Down'!$D$2,\"7a. Please provide the email address where you would want us to send the notification of our payment to you for SUA Payments.\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A68),FALSE)),\"\",IF(H69=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A68),FALSE),IF(C69=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$67='Drop Down'!$D$5,\"7b. Please specify the payment terms that is stated in the contract with Emory.\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A69),FALSE)),\"\",IF(H70=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A69),FALSE),IF(C70=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$67='Drop Down'!$D$5,\"7c. When submitting this form, please validate you will submit a copy of the fully executed contract containing the payment term language.\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A70),FALSE)),\"\",IF(H71=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A70),FALSE),IF(C71=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"IF($H$67='Drop Down'!$D$5,\"7d. Please indicate what page number within the fully executed contract, the payment terms can be found.\",\"\")","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A71),FALSE)),\"\",IF(H72=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A71),FALSE),IF(C72=FALSE,\"C\"))))","v":""},true,null,null,"R",{"$f":"IF(AND(Home!$D$7=\"Company\",OR($H$67=\"\",RIGHT($H$67,8)=\"Program.\")),\"\",CONCATENATE(\"8. Do you want to be paid via ACH/Direct Deposit? If No is selected, payment will be remitted via check sent to the billing address provided above.\",\" Please note that payments via check take significantly longer to process in comparision to ACH/Direct Deposit.\"))","v":""}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A72),FALSE)),\"\",IF(H73=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A72),FALSE),IF(C73=FALSE,\"C\"))))","v":""},true,null,null,null,"9. Emory highly encourages that your company be registered with The System for Award Management (SAM) because not doing so can preclude you as a supplier for contracts that Emory has with the U.S. government. For additional information and to register, please visit https://www.sam.gov/"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A73),FALSE)),\"\",IF(H74=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A73),FALSE),IF(C74=FALSE,\"C\"))))","v":""},true,null,null,"R","l declare under penalty of perjury (under the laws of the United States of America) that the information provided on this form is true and correct."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A74),FALSE)),\"\",IF(H75=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A74),FALSE),IF(C75=FALSE,\"C\"))))","v":""},true,null,null,"R",{"$f":"CONCATENATE(Home!D7,\" Authorized E-Signature:\",CHAR(10),\"(Please type your First and Last Name)\",CHAR(10),\"Please understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.\",\"Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature.\")","v":"Company Authorized E-Signature:\n(Please type your First and Last Name)\nPlease understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature."}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A75),FALSE)),\"\",IF(H76=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A75),FALSE),IF(C76=FALSE,\"C\"))))","v":""},true,null,null,"R","Date of Signature:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A76),FALSE)),\"\",IF(H77=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A76),FALSE),IF(C77=FALSE,\"C\"))))","v":""},true,null,null,"Y"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A77),FALSE)),\"\",IF(H78=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A77),FALSE),IF(C78=FALSE,\"C\"))))","v":""},true,null,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},"ACH Payment Authorization"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A78),FALSE)),\"\",IF(H79=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A78),FALSE),IF(C79=FALSE,\"C\"))))","v":""},true,null,null,"",{"$f":"Home!D7&\" Information\"","v":"Company Information"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A79),FALSE)),\"\",IF(H80=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A79),FALSE),IF(C80=FALSE,\"C\"))))","v":""},true,null,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},{"$f":"Home!D7&\" Name:\"","v":"Company Name:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A80),FALSE)),\"\",IF(H81=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A80),FALSE),IF(C81=FALSE,\"C\"))))","v":""},true,null,null,null,{"$f":"Home!D7&\" Division Name:\"","v":"Company Division Name:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A81),FALSE)),\"\",IF(H82=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A81),FALSE),IF(C82=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H82+0)","v":true},null,null,null,"DUNS Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A82),FALSE)),\"\",IF(H83=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A82),FALSE),IF(C83=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H83+0)","v":true},null,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},{"$f":"IF(OR(Home!$D$7=\"Study Participant\",Home!$D$7=\"Individual\"),\"Social Security Number (9 Digits):\",\"Taxpayer Identification Number (9 Digits):\")","v":"Taxpayer Identification Number (9 Digits):"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A83),FALSE)),\"\",IF(H84=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A83),FALSE),IF(C84=FALSE,\"C\"))))","v":""},true,null,null,"",{"$f":"Home!D7&\" ACH Remittance Contact Name:\"","v":"Company ACH Remittance Contact Name:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A84),FALSE)),\"\",IF(H85=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A84),FALSE),IF(C85=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H85+0),LEFT(H85,1)=\"1\")","v":false},null,null,"",{"$f":"Home!D7&\" ACH Remittance Contact Phone:\"","v":"Company ACH Remittance Contact Phone:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A85),FALSE)),\"\",IF(H86=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A85),FALSE),IF(C86=FALSE,\"C\"))))","v":""},{"$f":"IF(H86=\"\",TRUE,ISNUMBER(FIND(\"@\",H86,1)+FIND(\".\",H86,1)))","v":true},null,null,"",{"$f":"Home!D7&\" ACH Remittance Email:\"","v":"Company ACH Remittance Email:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A86),FALSE)),\"\",IF(H87=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A86),FALSE),IF(C87=FALSE,\"C\"))))","v":""},true,null,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},{"$f":"Home!D7&\" Remittance Address\"","v":"Company Remittance Address"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A87),FALSE)),\"\",IF(H88=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A87),FALSE),IF(C88=FALSE,\"C\"))))","v":""},true,null,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},{"$f":"Home!D7&\" Remittance Address Line 1:\"","v":"Company Remittance Address Line 1:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A88),FALSE)),\"\",IF(H89=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A88),FALSE),IF(C89=FALSE,\"C\"))))","v":""},true,null,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},{"$f":"Home!D7&\" Remittance Address Line 2:\"","v":"Company Remittance Address Line 2:"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A89),FALSE)),\"\",IF(H90=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A89),FALSE),IF(C90=FALSE,\"C\"))))","v":""},true,null,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},"City:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A90),FALSE)),\"\",IF(H91=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A90),FALSE),IF(C91=FALSE,\"C\"))))","v":""},true,null,null,"","State:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A91),FALSE)),\"\",IF(H92=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A91),FALSE),IF(C92=FALSE,\"C\"))))","v":""},true,null,null,"","ZIP:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A92),FALSE)),\"\",IF(H93=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A92),FALSE),IF(C93=FALSE,\"C\"))))","v":""},true,null,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},"Banking Information"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A93),FALSE)),\"\",IF(H94=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A93),FALSE),IF(C94=FALSE,\"C\"))))","v":""},true,null,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},"Name of Receiving Bank:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A94),FALSE)),\"\",IF(H95=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A94),FALSE),IF(C95=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H95+0)","v":true},null,null,"","Routing Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A95),FALSE)),\"\",IF(H96=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A95),FALSE),IF(C96=FALSE,\"C\"))))","v":""},{"$f":"ISNUMBER(H96+0)","v":true},null,null,"","Account Number:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A96),FALSE)),\"\",IF(H97=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A96),FALSE),IF(C97=FALSE,\"C\"))))","v":""},true,null,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"Y\",\"\"))","v":""},{"$f":"Home!D7&\" Authorization\"","v":"Company Authorization"}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A97),FALSE)),\"\",IF(H98=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A97),FALSE),IF(C98=FALSE,\"C\"))))","v":""},true,null,null,"","We hereby authorize, with the signature below, Emory University Payment Services to deposit all payments into the above referenced account."]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A98),FALSE)),\"\",IF(H99=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A98),FALSE),IF(C99=FALSE,\"C\"))))","v":""},true,null,null,{"$f":"IF(COUNTIF($B$4:$B$7,\"R\")>0,\"\",IF(OR($H$5=\"Yes\",$H$72=\"Yes\"),\"R\",\"\"))","v":""},{"$f":"CONCATENATE(Home!D7,\" Authorized E-Signature:\",CHAR(10),\"(Please type your First and Last Name)\",CHAR(10),\"Please understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.\",\"Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature.\")","v":"Company Authorized E-Signature:\n(Please type your First and Last Name)\nPlease understand that your electronic signature, E-Signature is the legal equivalent of your manual signature on this form and that by typing your name you agree to be legally bound by the statements and information provided.Your E-Signature further confirms that you are authorized to provide this information and that no certification authority or other third party verification is necessary to validate your E-Signature."}]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A99),FALSE)),\"\",IF(H100=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A99),FALSE),IF(C100=FALSE,\"C\"))))","v":""},true,null,null,"","Date of Signature:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A100),FALSE)),\"\",IF(H101=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A100),FALSE),IF(C101=FALSE,\"C\"))))","v":""},true,null,null,null,"Authorized Signer's Title:"]
[null,{"$f":"IF(OR(Home!$D$7=\"\",Home!$D$8=\"No\"),\"\",IF(ISBLANK(HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A101),FALSE)),\"\",IF(H102=\"\",HLOOKUP(Home!$D$7,$D$2:$F$102,ROW(A101),FALSE),IF(C102=FALSE,\"C\"))))","v":""},{"$f":"AND(ISNUMBER(H102+0),LEFT(H102,1)=\"1\")","v":false},null,null,null,"Authorized Signer's Phone Number:"]

{"sheet":"Drop Down","index":5,"n_rows":249,"n_cols":21,"rows_kept":249,"cut":false,"hidden":true,"merged":[]}
[null,"State",null,"Payment Terms",null,"Countries","US Territory",null,"Countries where the use of IBAN is mandatory",null,null,null,null,"Additional Information",null,null,null,"Currency","ISO","Symbol","Combined"]
[null,"AL",null,"My firm agrees to Net 0 payment terms through the SUA (Single Use Credit Card) Program.",null,"Afghanistan",null,null,"Country","IBAN length","IBAN examples","Combined",null,"Australia","AUD","6-digit BSB (Bank/State/Branch) routing code required",null,"United States Dollar","USD","$","USD - United States Dollar ($)"]
[null,"AK",null,"My firm is already enrolled in the SUA (Single Use Credit Card) Program.",null,"Albania",null,null,"Albania",28,"AL47212110090000000235698741","IBAN Length Must be 28 Characters.\nAn IBAN example is AL47212110090000000235698741",null,"Brazil","BRL","Agencia number (Bank Branch Number) 3-7 digits\n14-Digit CJNP (Tax Payer ID) for corporations or 9-Digit CPF for individuals\nBeneficiary name, telephone (+ Country Code), full address and email",null,"UAE Dirham","AED","د.إ","AED - UAE Dirham (د.إ)"]
[null,"AZ",null,"My firm agrees to Net 30 payment terms.",null,"Algeria",null,null,"Andorra",24,"AD1200012030200359100100",{"$f":"\"IBAN Length Must be \"&J4&\" Characters.\"&CHAR(10)&\"An IBAN example is \"&K4","v":"IBAN Length Must be 24 Characters.\nAn IBAN example is AD1200012030200359100100"},null,"United Kingdom","GBP","Account number + sort code (6 digits) or IBAN can be used within the U.K.",null,"Albanian Lek","ALL","L","ALL - Albanian Lek (L)"]
[null,"AR",null,"My firm has a contract with Emory stating the payment terms.",null,"American Samoa","Y",null,"Austria",20,"AT611904300234573201","IBAN Length Must be 20 Characters.\nAn IBAN example is AT611904300234573201",null,"Canada","CAD ","Include 9-digit Canadian transit number",null,"Neth Antilles Guilder","ANG","NAƒ","ANG - Neth Antilles Guilder (NAƒ)"]
[null,"CA",null,null,null,"Andorra",null,null,"Azerbaijan",28,"AZ21NABZ00000000137010001944","IBAN Length Must be 28 Characters.\nAn IBAN example is AZ21NABZ00000000137010001944",null,"Guatemala","GTQ","Payment to Individuals are not permitted",null,"Argentine Peso","ARS","$","ARS - Argentine Peso ($)"]
[null,"CO",null,null,null,"Angola",null,null,"Bahrain",22,"BH67BMAG00001299123456","IBAN Length Must be 22 Characters.\nAn IBAN example is BH67BMAG00001299123456",null,"India","INR","Provide an Indian Financial Systems Code (IFSC Code - 11 Characters)\nProvide a Foreign Inward Remittance Certificate (FIRC) if required by Beneficiary Bank",null,"Australian Dollar","AUD","$","AUD - Australian Dollar ($)"]
[null,"CT",null,null,null,"Anguilla",null,null,"Belarus",28,"BY13NBRB3600900000002Z00AB00","IBAN Length Must be 28 Characters.\nAn IBAN example is BY13NBRB3600900000002Z00AB00",null,"Israel","ILS","Bank number and branch number also required\nSwift option A (BIC) must be used in all relevant fields to avoid processing delays",null,"Aruba Florin","AWG","ƒ","AWG - Aruba Florin (ƒ)"]
[null,"DC",null,null,null,"Antarctica",null,null,"Belgium",16,"BE68539007547034","IBAN Length Must be 16 Characters.\nAn IBAN example is BE68539007547034",null,"Palestinian Territory",null,"Details of correspondent bank if in Palestine\nBank number and branch number also required\nSwift option A (BIC) must be used in all relevant fields to avoid processing delays",null,"Barbados Dollar","BBD","BBD","BBD - Barbados Dollar (BBD)"]
[null,"DE",null,null,null,"Antigua and Barbuda",null,null,"Bosnia-Hercegovina",20,"BA391290079401028494","IBAN Length Must be 20 Characters.\nAn IBAN example is BA391290079401028494",null,"Kenya","KES","Beneficiary bank branch code and name\nBeneficiary name, telephone (+ Country Code) and full address",null,"Bangladesh Taka","BDT","Tk","BDT - Bangladesh Taka (Tk)"]
[null,"FL",null,null,null,"Argentina",null,null,"Brazil",29,"BR9700360305000010009795493P1","IBAN Length Must be 29 Characters.\nAn IBAN example is BR9700360305000010009795493P1",null,"South Korea","KRW","Include Govt national ID, tax ID/business registration or residence permit number",null,"Bulgarian Lev","BGN","лв","BGN - Bulgarian Lev (лв)"]
[null,"GA",null,null,null,"Armenia",null,null,"Bulgaria",22,"BG80BNBG96611020345678","IBAN Length Must be 22 Characters.\nAn IBAN example is BG80BNBG96611020345678",null,"Mexico","MXN","The 18- Digit CLABE account number for credit to all depository accounts in Mexico",null,"Bahraini Dinar","BHD",".د.ب","BHD - Bahraini Dinar (.د.ب)"]
[null,"HI",null,null,null,"Aruba",null,null,"Costa Rica",21,"CR051202001026284066","IBAN Length Must be 21 Characters.\nAn IBAN example is CR051202001026284066",null,"South Africa","ZAR","Need 6-Digit transit number or BIC and beneficiary address\nNeed beneficiary contact details (telephone and email address)",null,"Burundi Franc","BIF","FBu","BIF - Burundi Franc (FBu)"]
[null,"ID",null,null,null,"Australia",null,null,"Croatia",21,"HR1210010051863000160","IBAN Length Must be 21 Characters.\nAn IBAN example is HR1210010051863000160",null,"Taiwan","TWD","Beneficiary name, telephone (+ Country Code) and full address",null,"Bermuda Dollar","BMD","BD$","BMD - Bermuda Dollar (BD$)"]
[null,"IL",null,null,null,"Austria",null,null,"Cyprus",28,"CY17002001280000001200527600","IBAN Length Must be 28 Characters.\nAn IBAN example is CY17002001280000001200527600",null,"Thailand","THB","Beneficiary name, address, tax ID and telephone number (+ Country Code)",null,"Brunei Dollar","BND","B$","BND - Brunei Dollar (B$)"]
[null,"IN",null,null,null,"Azerbaijan",null,null,"Czech Republic",24,"CZ6508000000192000145399","IBAN Length Must be 24 Characters.\nAn IBAN example is CZ6508000000192000145399",null,"Zimbabwe","ZMW","Branch code required (bank code, area code and bank branch code)\nFull beneficiary address recommended",null,"Bolivian Boliviano","BOB","Bs","BOB - Bolivian Boliviano (Bs)"]
[null,"IA",null,null,null,"Bahamas",null,null,"Denmark",18,"DK5000400440116243","IBAN Length Must be 18 Characters.\nAn IBAN example is DK5000400440116243",null,null,null,null,null,"Brazilian Real","BRL","R$","BRL - Brazilian Real (R$)"]
[null,"KS",null,null,null,"Bahrain",null,null,"Dominican Republic",28,"DO28BAGR00000001212453611324","IBAN Length Must be 28 Characters.\nAn IBAN example is DO28BAGR00000001212453611324",null,null,null,null,null,"Bahamian Dollar","BSD","B$","BSD - Bahamian Dollar (B$)"]
[null,"KY",null,null,null,"Bangladesh",null,null,"Estonia",20,"EE382200221020145685","IBAN Length Must be 20 Characters.\nAn IBAN example is EE382200221020145685",null,null,null,null,null,"Bhutan Ngultrum","BTN","Nu.","BTN - Bhutan Ngultrum (Nu.)"]
[null,"LA",null,null,null,"Barbados",null,null,"Faroe Islands",18,"FO6264600001631634","IBAN Length Must be 18 Characters.\nAn IBAN example is FO6264600001631634",null,null,null,null,null,"Botswana Pula","BWP","P","BWP - Botswana Pula (P)"]
[null,"ME",null,null,null,"Belarus",null,null,"Finland",18,"FI2112345600000785","IBAN Length Must be 18 Characters.\nAn IBAN example is FI2112345600000785",null,null,null,null,null,"Belarus Ruble","BYR","Br","BYR - Belarus Ruble (Br)"]
[null,"MD",null,null,null,"Belgium",null,null,"France",27,"FR1420041010050500013M02606","IBAN Length Must be 27 Characters.\nAn IBAN example is FR1420041010050500013M02606",null,null,null,null,null,"Belize Dollar","BZD","BZ$","BZD - Belize Dollar (BZ$)"]
[null,"MA",null,null,null,"Belize",null,null,"Georgia",22,"GE29NB0000000101904917","IBAN Length Must be 22 Characters.\nAn IBAN example is GE29NB0000000101904917",null,null,null,null,null,"Canadian Dollar","CAD","C$","CAD - Canadian Dollar (C$)"]
[null,"MI",null,null,null,"Benin",null,null,"Germany",22,"DE89370400440532013000","IBAN Length Must be 22 Characters.\nAn IBAN example is DE89370400440532013000",null,null,null,null,null,"Swiss Franc","CHF","CHF","CHF - Swiss Franc (CHF)"]
[null,"MN",null,null,null,"Bermuda",null,null,"Gibraltar",23,"GI75NWBK000000007099453","IBAN Length Must be 23 Characters.\nAn IBAN example is GI75NWBK000000007099453",null,null,null,null,null,"Chilean Peso","CLP","$","CLP - Chilean Peso ($)"]
[null,"MS",null,null,null,"Bhutan",null,null,"Greece",27,"GR16 01101250000000012300695","IBAN Length Must be 27 Characters.\nAn IBAN example is GR16 01101250000000012300695",null,null,null,null,null,"Chinese Yuan","CNY","¥","CNY - Chinese Yuan (¥)"]
[null,"MO",null,null,null,"Bolivia",null,null,"Greenland",18,"GL8964710001000206","IBAN Length Must be 18 Characters.\nAn IBAN example is GL8964710001000206",null,null,null,null,null,"Colombian Peso","COP","$","COP - Colombian Peso ($)"]
[null,"MT",null,null,null,"Bosnia-Hercegovina",null,null,"Guatemala",28,"GT82TRAJ01020000001210029690","IBAN Length Must be 28 Characters.\nAn IBAN example is GT82TRAJ01020000001210029690",null,null,null,null,null,"Costa Rica Colon","CRC","₡","CRC - Costa Rica Colon (₡)"]
[null,"NE",null,null,null,"Botswana",null,null,"Guernsey",22,"GB57NWBK55504453178386","IBAN Length Must be 22 Characters.\nAn IBAN example is GB57NWBK55504453178386",null,null,null,null,null,"Cuban Peso","CUP","$MN","CUP - Cuban Peso ($MN)"]
[null,"NV",null,null,null,"Bouvet Island",null,null,"Holy See (Vatican City)",22,"VA59001123000012345678","IBAN Length Must be 22 Characters.\nAn IBAN example is VA59001123000012345678",null,null,null,null,null,"Cape Verde Escudo","CVE","Esc","CVE - Cape Verde Escudo (Esc)"]
[null,"NH",null,null,null,"Brazil",null,null,"Hungary",28,"HU42117730161111101800000000","IBAN Length Must be 28 Characters.\nAn IBAN example is HU42117730161111101800000000",null,null,null,null,null,"Czech Koruna","CZK","Kč","CZK - Czech Koruna (Kč)"]
[null,"NJ",null,null,null,"British Indian Ocean Territory",null,null,"Iceland",26,"IS140159260076545510730339","IBAN Length Must be 26 Characters.\nAn IBAN example is IS140159260076545510730339",null,null,null,null,null,"Djibouti Franc","DJF","Fdj","DJF - Djibouti Franc (Fdj)"]
[null,"NM",null,null,null,"British Virgin Islands",null,null,"Iran",26,"IR580540105180021273113007","IBAN Length Must be 26 Characters.\nAn IBAN example is IR580540105180021273113007",null,null,null,null,null,"Danish Krone","DKK","kr","DKK - Danish Krone (kr)"]
[null,"NY",null,null,null,"Brunei",null,null,"Iraq",23,"IQ98NBIQ657453423456748","IBAN Length Must be 23 Characters.\nAn IBAN example is IQ98NBIQ657453423456748",null,null,null,null,null,"Dominican Peso","DOP","RD$","DOP - Dominican Peso (RD$)"]
[null,"NC",null,null,null,"Bulgaria",null,null,"Ireland",22,"IE29AIBK93115212345678","IBAN Length Must be 22 Characters.\nAn IBAN example is IE29AIBK93115212345678",null,null,null,null,null,"Algerian Dinar","DZD","دج","DZD - Algerian Dinar (دج)"]
[null,"ND",null,null,null,"Burkina Faso",null,null,"Isle of Man",22,"GB57NWBK55504453178386","IBAN Length Must be 22 Characters.\nAn IBAN example is GB57NWBK55504453178386\nAn IBAN example is IM07MIDL40193872448696",null,null,null,null,null,"Estonian Kroon","EEK","EEK","EEK - Estonian Kroon (EEK)"]
[null,"OH",null,null,null,"Burma",null,null,"Israel",23,"IL620108000000099999999","IBAN Length Must be 23 Characters.\nAn IBAN example is IL620108000000099999999",null,null,null,null,null,"Egyptian Pound","EGP","ج.م","EGP - Egyptian Pound (ج.م)"]
[null,"OK",null,null,null,"Burundi",null,null,"Italy",27,"IT60X0542811101000000123456","IBAN Length Must be 27 Characters.\nAn IBAN example is IT60X0542811101000000123456",null,null,null,null,null,"Ethiopian Birr","ETB","Br","ETB - Ethiopian Birr (Br)"]
[null,"OR",null,null,null,"Cambodia",null,null,"Jersey",22,"GB57NWBK55504453178386","IBAN Length Must be 22 Characters.\nAn IBAN example is GB57NWBK55504453178386\nAn IBAN example is JE68ABNA0350917C000978",null,null,null,null,null,"Euro","EUR","€","EUR - Euro (€)"]
[null,"PA",null,null,null,"Cameroon",null,null,"Jordan",30,"JO99HBHA4543333578295175367253","IBAN Length Must be 30 Characters.\nAn IBAN example is JO99HBHA4543333578295175367253",null,null,null,null,null,"Fiji Dollar","FJD","FJ$","FJD - Fiji Dollar (FJ$)"]
[null,"PR",null,null,null,"Canada",null,null,"Kazakhstan",20,"KZ5590238934023248812","IBAN Length Must be 20 Characters.\nAn IBAN example is KZ5590238934023248812",null,null,null,null,null,"Falkland Islands Pound","FKP","£","FKP - Falkland Islands Pound (£)"]
[null,"RI",null,null,null,"Cape Verde",null,null,"Kazakhstan",20,"KZ86125KZT5004100100","IBAN Length Must be 20 Characters.\nAn IBAN example is KZ86125KZT5004100100",null,null,null,null,null,"British Pound","GBP","£","GBP - British Pound (£)"]
[null,"SC",null,null,null,"Cayman Islands",null,null,"Kosovo",20,"XK051212012345678906","IBAN Length Must be 20 Characters.\nAn IBAN example is XK051212012345678906",null,null,null,null,null,"Ghanaian Cedi","GHS","GHS","GHS - Ghanaian Cedi (GHS)"]
[null,"SD",null,null,null,"Central African Republic",null,null,"Kuwait",30,"KW81CBKU0000000000001234560101","IBAN Length Must be 30 Characters.\nAn IBAN example is KW81CBKU0000000000001234560101",null,null,null,null,null,"Gambian Dalasi","GMD","D","GMD - Gambian Dalasi (D)"]
[null,"TN",null,null,null,"Chad",null,null,"Kuwait",30,"KW81CBKU0000000000001234560101","IBAN Length Must be 30 Characters.\nAn IBAN example is KW81CBKU0000000000001234560101",null,null,null,null,null,"Guinea Franc","GNF","FG","GNF - Guinea Franc (FG)"]
[null,"TX",null,null,null,"Chile",null,null,"Latvia",21,"LV80BANK0000435195001","IBAN Length Must be 21 Characters.\nAn IBAN example is LV80BANK0000435195001",null,null,null,null,null,"Guatemala Quetzal","GTQ","Q","GTQ - Guatemala Quetzal (Q)"]
[null,"UT",null,null,null,"China",null,null,"Lebanon",28,"LB62099900000001001901229114","IBAN Length Must be 28 Characters.\nAn IBAN example is LB62099900000001001901229114",null,null,null,null,null,"Guyana Dollar","GYD","GY$","GYD - Guyana Dollar (GY$)"]
[null,"VT",null,null,null,"Christmas Island",null,null,"Liechtenstein",21,"LI21088100002324013A A","IBAN Length Must be 21 Characters.\nAn IBAN example is LI21088100002324013A A",null,null,null,null,null,"Hong Kong Dollar","HKD","HK$","HKD - Hong Kong Dollar (HK$)"]
[null,"VA",null,null,null,"Cocos (Keeling) Islands",null,null,"Lithuania",20,"LT121000011101001000","IBAN Length Must be 20 Characters.\nAn IBAN example is LT121000011101001000",null,null,null,null,null,"Honduras Lempira","HNL","L","HNL - Honduras Lempira (L)"]
[null,"WA",null,null,null,"Colombia",null,null,"Luxembourg",20,"LU280019400644750000","IBAN Length Must be 20 Characters.\nAn IBAN example is LU280019400644750000",null,null,null,null,null,"Croatian Kuna","HRK","kn","HRK - Croatian Kuna (kn)"]
[null,"WV",null,null,null,"Comoros",null,null,"Macedonia",19,"MK07250120000058984","IBAN Length Must be 19 Characters.\nAn IBAN example is MK07250120000058984",null,null,null,null,null,"Haiti Gourde","HTG",null,"HTG - Haiti Gourde ()"]
[null,"WI",null,null,null,"Congo",null,null,"Malta",31,"MT84MALT011000012345MTLCAST001S","IBAN Length Must be 31 Characters.\nAn IBAN example is MT84MALT011000012345MTLCAST001S",null,null,null,null,null,"Hungarian Forint","HUF","Ft","HUF - Hungarian Forint (Ft)"]
[null,"WY",null,null,null,"Cook Islands",null,null,"Mauritania",27,"MR1300020001010000123456753","IBAN Length Must be 27 Characters.\nAn IBAN example is MR1300020001010000123456753",null,null,null,null,null,"Indonesian Rupiah","IDR","Rp","IDR - Indonesian Rupiah (Rp)"]
[null,null,null,null,null,"Costa Rica",null,null,"Mauritius",30,"MU17BOMM0101101030300200000MUR","IBAN Length Must be 30 Characters.\nAn IBAN example is MU17BOMM0101101030300200000MUR",null,null,null,null,null,"Israeli Shekel","ILS","₪","ILS - Israeli Shekel (₪)"]
[null,null,null,null,null,"Cote d'Ivoire",null,null,"Moldova",24,"MD24AG000225100013104168","IBAN Length Must be 24 Characters.\nAn IBAN example is MD24AG000225100013104168",null,null,null,null,null,"Indian Rupee","INR","Rs.","INR - Indian Rupee (Rs.)"]
[null,null,null,null,null,"Croatia",null,null,"Monaco",27,"MC5811222000010123456789030","IBAN Length Must be 27 Characters.\nAn IBAN example is MC5811222000010123456789030",null,null,null,null,null,"Iraqi Dinar","IQD","ع.د","IQD - Iraqi Dinar (ع.د)"]
[null,null,null,null,null,"Cuba",null,null,"Montenegro",22,"ME25505000012345678951","IBAN Length Must be 22 Characters.\nAn IBAN example is ME25505000012345678951",null,null,null,null,null,"Iran Rial","IRR",null,"IRR - Iran Rial ()"]
[null,null,null,null,null,"Curacao",null,null,"Netherlands",18,"NL91ABNA0417164300","IBAN Length Must be 18 Characters.\nAn IBAN example is NL91ABNA0417164300",null,null,null,null,null,"Iceland Krona","ISK","kr","ISK - Iceland Krona (kr)"]
[null,null,null,null,null,"Cyprus",null,null,"Norway",15,"NO0212345678910","IBAN Length Must be 15 Characters.\nAn IBAN example is NO0212345678910",null,null,null,null,null,"Jordanian Dinar","JOD","JOD","JOD - Jordanian Dinar (JOD)"]
[null,null,null,null,null,"Czech Republic",null,null,"Pakistan",24,"PK36SCBL0000001123456702","IBAN Length Must be 24 Characters.\nAn IBAN example is PK36SCBL0000001123456702",null,null,null,null,null,"Japanese Yen","JPY","¥","JPY - Japanese Yen (¥)"]
[null,null,null,null,null,"Denmark",null,null,"Palestinian Territory",29,"PS92PALS000000000400123456702","IBAN Length Must be 29 Characters.\nAn IBAN example is PS92PALS000000000400123456702",null,null,null,null,null,"Kenyan Shilling","KES","KSh","KES - Kenyan Shilling (KSh)"]
[null,null,null,null,null,"Djibouti",null,null,"Poland",28,"PL61109010140000071219812874","IBAN Length Must be 28 Characters.\nAn IBAN example is PL61109010140000071219812874",null,null,null,null,null,"Kyrgyzstan Som","KGS","KGS","KGS - Kyrgyzstan Som (KGS)"]
[null,null,null,null,null,"Dominica",null,null,"Portugal",25,"PT50000201231234567890154","IBAN Length Must be 25 Characters.\nAn IBAN example is PT50000201231234567890154",null,null,null,null,null,"Cambodia Riel","KHR","KHR","KHR - Cambodia Riel (KHR)"]
[null,null,null,null,null,"Dominican Republic",null,null,"Qatar",29,"QA01QNBA000000001234123412341","IBAN Length Must be 29 Characters.\nAn IBAN example is QA01QNBA000000001234123412341",null,null,null,null,null,"Comoros Franc","KMF","KMF","KMF - Comoros Franc (KMF)"]
[null,null,null,null,null,"Ecuador",null,null,"Romania",24,"RO49AAAA1B31007593840000","IBAN Length Must be 24 Characters.\nAn IBAN example is RO49AAAA1B31007593840000",null,null,null,null,null,"North Korean Won","KPW","₩","KPW - North Korean Won (₩)"]
[null,null,null,null,null,"Egypt",null,null,"Saint Lucia",32,"LC831090101400000712198128743156","IBAN Length Must be 32 Characters.\nAn IBAN example is LC831090101400000712198128743156",null,null,null,null,null,"Korean Won","KRW","₩","KRW - Korean Won (₩)"]
[null,null,null,null,null,"El Salvador",null,null,"San Marino",27,"SM86U0322509800000000270100","IBAN Length Must be 27 Characters.\nAn IBAN example is SM86U0322509800000000270100",null,null,null,null,null,"Kuwaiti Dinar","KWD","د.ك","KWD - Kuwaiti Dinar (د.ك)"]
[null,null,null,null,null,"Equatorial Guinea",null,null,"Sao Tome and Principe",25,"ST68000100010051845310112","IBAN Length Must be 25 Characters.\nAn IBAN example is ST68000100010051845310112",null,null,null,null,null,"Cayman Islands Dollar","KYD","$","KYD - Cayman Islands Dollar ($)"]
[null,null,null,null,null,"Eritrea",null,null,"Saudi Arabia",24,"SA0380000000608010167519","IBAN Length Must be 24 Characters.\nAn IBAN example is SA0380000000608010167519",null,null,null,null,null,"Kazakhstan Tenge","KZT","KZT","KZT - Kazakhstan Tenge (KZT)"]
[null,null,null,null,null,"Estonia",null,null,"Serbia",22,"RS35260005601001611379","IBAN Length Must be 22 Characters.\nAn IBAN example is RS35260005601001611379",null,null,null,null,null,"Sri Lanka Rupee","LKR","ரூ","LKR - Sri Lanka Rupee (ரூ)"]
[null,null,null,null,null,"Ethiopia",null,null,"Seychelles",31,"SC25SSCB11010000000000001497USD","IBAN Length Must be 31 Characters.\nAn IBAN example is SC25SSCB11010000000000001497USD",null,null,null,null,null,"Moroccan Dirham","MAD","د.م.","MAD - Moroccan Dirham (د.م.)"]
[null,null,null,null,null,"Falkland Islands (Islas Malvinas)",null,null,"Slovakia",24,"SK3112000000198742637541","IBAN Length Must be 24 Characters.\nAn IBAN example is SK3112000000198742637541",null,null,null,null,null,"Moldovan Leu","MDL","MDL","MDL - Moldovan Leu (MDL)"]
[null,null,null,null,null,"Faroe Islands",null,null,"Slovenia",19,"SI56263300012039086","IBAN Length Must be 19 Characters.\nAn IBAN example is SI56263300012039086",null,null,null,null,null,"Macedonian Denar","MKD","MKD","MKD - Macedonian Denar (MKD)"]
[null,null,null,null,null,"Fiji",null,null,"Spain",24,"ES9121000418450200051332","IBAN Length Must be 24 Characters.\nAn IBAN example is ES9121000418450200051332",null,null,null,null,null,"Myanmar Kyat","MMK","K","MMK - Myanmar Kyat (K)"]
[null,null,null,null,null,"Finland",null,null,"Sweden",24,"SE4550000000058398257466","IBAN Length Must be 24 Characters.\nAn IBAN example is SE4550000000058398257466",null,null,null,null,null,"Mongolian Tugrik","MNT","₮","MNT - Mongolian Tugrik (₮)"]
[null,null,null,null,null,"France",null,null,"Switzerland",21,"CH9300762011623852957","IBAN Length Must be 21 Characters.\nAn IBAN example is CH9300762011623852957",null,null,null,null,null,"Macau Pataca","MOP","$","MOP - Macau Pataca ($)"]
[null,null,null,null,null,"French Guiana",null,null,"Timor-Leste",23,"TL380080012345678910157","IBAN Length Must be 23 Characters.\nAn IBAN example is TL380080012345678910157",null,null,null,null,null,"Mauritania Ougulya","MRO","UM","MRO - Mauritania Ougulya (UM)"]
[null,null,null,null,null,"French Polynesia",null,null,"Tunisia",24,"TN5910006035183598478831","IBAN Length Must be 24 Characters.\nAn IBAN example is TN5910006035183598478831",null,null,null,null,null,"Mauritius Rupee","MUR","₨","MUR - Mauritius Rupee (₨)"]
[null,null,null,null,null,"French Southern and Antarctic Lands",null,null,"Turkey",26,"TR330006100519786457841326","IBAN Length Must be 26 Characters.\nAn IBAN example is TR330006100519786457841326",null,null,null,null,null,"Maldives Rufiyaa","MVR","Rf","MVR - Maldives Rufiyaa (Rf)"]
[null,null,null,null,null,"Gabon",null,null,"Ukraine",29,"UA213996220000026007233566001","IBAN Length Must be 29 Characters.\nAn IBAN example is UA213996220000026007233566001",null,null,null,null,null,"Malawi Kwacha","MWK","MK","MWK - Malawi Kwacha (MK)"]
[null,null,null,null,null,"Gambia",null,null,"United Arab Emirates",23,"AE070331234567890123456","IBAN Length Must be 23 Characters.\nAn IBAN example is AE070331234567890123456",null,null,null,null,null,"Mexican Peso","MXN","$","MXN - Mexican Peso ($)"]
[null,null,null,null,null,"Gaza Strip",null,null,"United Kingdom",22,"GB29NWBK60161331926819","IBAN Length Must be 22 Characters.\nAn IBAN example is GB29NWBK60161331926819",null,null,null,null,null,"Malaysian Ringgit","MYR","RM","MYR - Malaysian Ringgit (RM)"]
[null,null,null,null,null,"Georgia",null,null,"Virgin Islands",24,"VG96VPVG0000012345678901","IBAN Length Must be 24 Characters.\nAn IBAN example is VG96VPVG0000012345678901",null,null,null,null,null,"Namibian Dollar","NAD","N$","NAD - Namibian Dollar (N$)"]
[null,null,null,null,null,"Germany",null,null,null,null,null,null,null,null,null,null,null,"Nigerian Naira","NGN","₦","NGN - Nigerian Naira (₦)"]
[null,null,null,null,null,"Ghana",null,null,null,null,null,null,null,null,null,null,null,"Nicaragua Cordoba","NIO","C$","NIO - Nicaragua Cordoba (C$)"]
[null,null,null,null,null,"Gibraltar",null,null,null,null,null,null,null,null,null,null,null,"Norwegian Krone","NOK","kr","NOK - Norwegian Krone (kr)"]
[null,null,null,null,null,"Greece",null,null,null,null,null,null,null,null,null,null,null,"Nepalese Rupee","NPR","₨","NPR - Nepalese Rupee (₨)"]
[null,null,null,null,null,"Greenland",null,null,null,null,null,null,null,null,null,null,null,"New Zealand Dollar","NZD","$","NZD - New Zealand Dollar ($)"]
[null,null,null,null,null,"Grenada",null,null,null,null,null,null,null,null,null,null,null,"Omani Rial","OMR","ر.ع.","OMR - Omani Rial (ر.ع.)"]
[null,null,null,null,null,"Guadeloupe",null,null,null,null,null,null,null,null,null,null,null,"Panama Balboa","PAB","B","PAB - Panama Balboa (B)"]
[null,null,null,null,null,"Guam","Y",null,null,null,null,null,null,null,null,null,null,"Peruvian Nuevo Sol","PEN","S/.","PEN - Peruvian Nuevo Sol (S/.)"]
[null,null,null,null,null,"Guatemala",null,null,null,null,null,null,null,null,null,null,null,"Papua New Guinea Kina","PGK","K","PGK - Papua New Guinea Kina (K)"]
[null,null,null,null,null,"Guernsey",null,null,null,null,null,null,null,null,null,null,null,"Philippine Peso","PHP","₱","PHP - Philippine Peso (₱)"]
[null,null,null,null,null,"Guinea",null,null,null,null,null,null,null,null,null,null,null,"Pakistani Rupee","PKR","Rs.","PKR - Pakistani Rupee (Rs.)"]
[null,null,null,null,null,"Guinea-Bissau",null,null,null,null,null,null,null,null,null,null,null,"Polish Zloty","PLN","zł","PLN - Polish Zloty (zł)"]
[null,null,null,null,null,"Guyana",null,null,null,null,null,null,null,null,null,null,null,"Paraguayan Guarani","PYG",null,"PYG - Paraguayan Guarani ()"]
[null,null,null,null,null,"Haiti",null,null,null,null,null,null,null,null,null,null,null,"Qatar Rial","QAR","ر.ق","QAR - Qatar Rial (ر.ق)"]
[null,null,null,null,null,"Heard Island and McDonald Islands",null,null,null,null,null,null,null,null,null,null,null,"Romanian New Leu","RON","L","RON - Romanian New Leu (L)"]
[null,null,null,null,null,"Holy See (Vatican City)",null,null,null,null,null,null,null,null,null,null,null,"Russian Rouble","RUB","руб","RUB - Russian Rouble (руб)"]
[null,null,null,null,null,"Honduras",null,null,null,null,null,null,null,null,null,null,null,"Rwanda Franc","RWF","RF","RWF - Rwanda Franc (RF)"]
[null,null,null,null,null,"Hong Kong",null,null,null,null,null,null,null,null,null,null,null,"Saudi Arabian Riyal","SAR","ر.س","SAR - Saudi Arabian Riyal (ر.س)"]
[null,null,null,null,null,"Hungary",null,null,null,null,null,null,null,null,null,null,null,"Solomon Islands Dollar","SBD","SI$","SBD - Solomon Islands Dollar (SI$)"]
[null,null,null,null,null,"Iceland",null,null,null,null,null,null,null,null,null,null,null,"Seychelles Rupee","SCR","SR","SCR - Seychelles Rupee (SR)"]
[null,null,null,null,null,"India",null,null,null,null,null,null,null,null,null,null,null,"Sudanese Pound","SDG","SDG","SDG - Sudanese Pound (SDG)"]
[null,null,null,null,null,"Indonesia",null,null,null,null,null,null,null,null,null,null,null,"Swedish Krona","SEK","kr","SEK - Swedish Krona (kr)"]
[null,null,null,null,null,"Iran",null,null,null,null,null,null,null,null,null,null,null,"Singapore Dollar","SGD","S$","SGD - Singapore Dollar (S$)"]
[null,null,null,null,null,"Iraq",null,null,null,null,null,null,null,null,null,null,null,"St Helena Pound","SHP","£","SHP - St Helena Pound (£)"]
[null,null,null,null,null,"Ireland",null,null,null,null,null,null,null,null,null,null,null,"Slovak Koruna","SKK","Sk","SKK - Slovak Koruna (Sk)"]
[null,null,null,null,null,"Isle of Man",null,null,null,null,null,null,null,null,null,null,null,"Sierra Leone Leone","SLL","Le","SLL - Sierra Leone Leone (Le)"]
[null,null,null,null,null,"Israel",null,null,null,null,null,null,null,null,null,null,null,"Somali Shilling","SOS","So.","SOS - Somali Shilling (So.)"]
[null,null,null,null,null,"Italy",null,null,null,null,null,null,null,null,null,null,null,"Sao Tome Dobra","STD","Db","STD - Sao Tome Dobra (Db)"]
[null,null,null,null,null,"Jamaica",null,null,null,null,null,null,null,null,null,null,null,"El Salvador Colon","SVC","₡","SVC - El Salvador Colon (₡)"]
[null,null,null,null,null,"Japan",null,null,null,null,null,null,null,null,null,null,null,"Syrian Pound","SYP","SYP","SYP - Syrian Pound (SYP)"]
[null,null,null,null,null,"Jersey",null,null,null,null,null,null,null,null,null,null,null,"Swaziland Lilageni","SZL","SZL","SZL - Swaziland Lilageni (SZL)"]
[null,null,null,null,null,"Jordan",null,null,null,null,null,null,null,null,null,null,null,"Thai Baht","THB","฿","THB - Thai Baht (฿)"]
[null,null,null,null,null,"Kazakhstan",null,null,null,null,null,null,null,null,null,null,null,"Tunisian Dinar","TND","د.ت","TND - Tunisian Dinar (د.ت)"]
[null,null,null,null,null,"Kenya",null,null,null,null,null,null,null,null,null,null,null,"Tongan paʻanga","TOP","T$","TOP - Tongan paʻanga (T$)"]
[null,null,null,null,null,"Kiribati",null,null,null,null,null,null,null,null,null,null,null,"Turkish Lira","TRY","YTL","TRY - Turkish Lira (YTL)"]
[null,null,null,null,null,"Kosovo",null,null,null,null,null,null,null,null,null,null,null,"Trinidad Tobago Dollar","TTD","TTD","TTD - Trinidad Tobago Dollar (TTD)"]
[null,null,null,null,null,"Kuwait",null,null,null,null,null,null,null,null,null,null,null,"Taiwan Dollar","TWD","NT$","TWD - Taiwan Dollar (NT$)"]
[null,null,null,null,null,"Kyrgyzstan",null,null,null,null,null,null,null,null,null,null,null,"Tanzanian Shilling","TZS","x","TZS - Tanzanian Shilling (x)"]
[null,null,null,null,null,"Laos",null,null,null,null,null,null,null,null,null,null,null,"Ukraine Hryvnia","UAH",null,"UAH - Ukraine Hryvnia ()"]
[null,null,null,null,null,"Latvia",null,null,null,null,null,null,null,null,null,null,null,"Ugandan Shilling","UGX","USh","UGX - Ugandan Shilling (USh)"]
[null,null,null,null,null,"Lebanon",null,null,null,null,null,null,null,null,null,null,null,"Uruguayan New Peso","UYU","UYU","UYU - Uruguayan New Peso (UYU)"]
[null,null,null,null,null,"Lesotho",null,null,null,null,null,null,null,null,null,null,null,"Uzbekistan Sum","UZS","UZS","UZS - Uzbekistan Sum (UZS)"]
[null,null,null,null,null,"Liberia",null,null,null,null,null,null,null,null,null,null,null,"Venezuelan Bolivar","VEF","VEF","VEF - Venezuelan Bolivar (VEF)"]
[null,null,null,null,null,"Libya",null,null,null,null,null,null,null,null,null,null,null,"Vietnam Dong","VND","₫","VND - Vietnam Dong (₫)"]
[null,null,null,null,null,"Liechtenstein",null,null,null,null,null,null,null,null,null,null,null,"Vanuatu Vatu","VUV","Vt","VUV - Vanuatu Vatu (Vt)"]
[null,null,null,null,null,"Lithuania",null,null,null,null,null,null,null,null,null,null,null,"Samoa Tala","WST","WS$","WST - Samoa Tala (WS$)"]
[null,null,null,null,null,"Luxembourg",null,null,null,null,null,null,null,null,null,null,null,"CFA Franc (BEAC)","XAF","BEAC","XAF - CFA Franc (BEAC) (BEAC)"]
[null,null,null,null,null,"Macau",null,null,null,null,null,null,null,null,null,null,null,"East Caribbean Dollar","XCD","EC$","XCD - East Caribbean Dollar (EC$)"]
[null,null,null,null,null,"Macedonia",null,null,null,null,null,null,null,null,null,null,null,"CFA Franc (BCEAO)","XOF","BCEAO","XOF - CFA Franc (BCEAO) (BCEAO)"]
[null,null,null,null,null,"Madagascar",null,null,null,null,null,null,null,null,null,null,null,"Pacific Franc","XPF","F","XPF - Pacific Franc (F)"]
[null,null,null,null,null,"Malawi",null,null,null,null,null,null,null,null,null,null,null,"Yemen Riyal","YER","YER","YER - Yemen Riyal (YER)"]
[null,null,null,null,null,"Malaysia",null,null,null,null,null,null,null,null,null,null,null,"South African Rand","ZAR","R","ZAR - South African Rand (R)"]
[null,null,null,null,null,"Maldives",null,null,null,null,null,null,null,null,null,null,null,"Zambian Kwacha","ZMK","ZMK","ZMK - Zambian Kwacha (ZMK)"]
[null,null,null,null,null,"Mali"]
[null,null,null,null,null,"Malta"]
[null,null,null,null,null,"Marshall Islands"]
[null,null,null,null,null,"Martinique"]
[null,null,null,null,null,"Mauritania"]
[null,null,null,null,null,"Mauritius"]
[null,null,null,null,null,"Mayotte"]
[null,null,null,null,null,"Mexico"]
[null,null,null,null,null,"Micronesia"]
[null,null,null,null,null,"Moldova"]
[null,null,null,null,null,"Monaco"]
[null,null,null,null,null,"Mongolia"]
[null,null,null,null,null,"Montenegro"]
[null,null,null,null,null,"Montserrat"]
[null,null,null,null,null,"Morocco"]
[null,null,null,null,null,"Mozambique"]
[null,null,null,null,null,"Namibia"]
[null,null,null,null,null,"Nauru"]
[null,null,null,null,null,"Nepal"]
[null,null,null,null,null,"Netherlands"]
[null,null,null,null,null,"New Caledonia"]
[null,null,null,null,null,"New Zealand"]
[null,null,null,null,null,"Nicaragua"]
[null,null,null,null,null,"Niger"]
[null,null,null,null,null,"Nigeria"]
[null,null,null,null,null,"Niue"]
[null,null,null,null,null,"Norfolk Island"]
[null,null,null,null,null,"North Korea"]
[null,null,null,null,null,"Northern Mariana Islands","Y"]
[null,null,null,null,null,"Norway"]
[null,null,null,null,null,"Oman"]
[null,null,null,null,null,"Pakistan"]
[null,null,null,null,null,"Palau"]
[null,null,null,null,null,"Palestinian Territory"]
[null,null,null,null,null,"Panama"]
[null,null,null,null,null,"Papua New Guinea"]
[null,null,null,null,null,"Paraguay"]
[null,null,null,null,null,"Peru"]
[null,null,null,null,null,"Philippines"]
[null,null,null,null,null,"Pitcairn Islands"]
[null,null,null,null,null,"Poland"]
[null,null,null,null,null,"Portugal"]
[null,null,null,null,null,"Puerto Rico","Y"]
[null,null,null,null,null,"Qatar"]
[null,null,null,null,null,"Reunion"]
[null,null,null,null,null,"Romania"]
[null,null,null,null,null,"Russia"]
[null,null,null,null,null,"Rwanda"]
[null,null,null,null,null,"Saint Barthelemy"]
[null,null,null,null,null,"Saint Helena, Ascension, and Tristan da Cunha"]
[null,null,null,null,null,"Saint Kitts and Nevis"]
[null,null,null,null,null,"Saint Lucia"]
[null,null,null,null,null,"Saint Martin"]
[null,null,null,null,null,"Saint Pierre and Miquelon"]
[null,null,null,null,null,"Saint Vincent and the Grenadines"]
[null,null,null,null,null,"Samoa"]
[null,null,null,null,null,"San Marino"]
[null,null,null,null,null,"Sao Tome and Principe"]
[null,null,null,null,null,"Saudi Arabia"]
[null,null,null,null,null,"Senegal"]
[null,null,null,null,null,"Serbia"]
[null,null,null,null,null,"Seychelles"]
[null,null,null,null,null,"Sierra Leone"]
[null,null,null,null,null,"Singapore"]
[null,null,null,null,null,"Sint Maarten"]
[null,null,null,null,null,"Slovakia"]
[null,null,null,null,null,"Slovenia"]
[null,null,null,null,null,"Solomon Islands"]
[null,null,null,null,null,"Somalia"]
[null,null,null,null,null,"South Africa"]
[null,null,null,null,null,"South Georgia and the Islands"]
[null,null,null,null,null,"South Korea"]
[null,null,null,null,null,"South Sudan"]
[null,null,null,null,null,"Spain"]
[null,null,null,null,null,"Sri Lanka"]
[null,null,null,null,null,"Sudan"]
[null,null,null,null,null,"Suriname"]
[null,null,null,null,null,"Svalbard"]
[null,null,null,null,null,"Swaziland"]
[null,null,null,null,null,"Sweden"]
[null,null,null,null,null,"Switzerland"]
[null,null,null,null,null,"Syria"]
[null,null,null,null,null,"Taiwan"]
[null,null,null,null,null,"Tajikistan"]
[null,null,null,null,null,"Tanzania"]
[null,null,null,null,null,"Thailand"]
[null,null,null,null,null,"Timor-Leste"]
[null,null,null,null,null,"Togo"]
[null,null,null,null,null,"Tokelau"]
[null,null,null,null,null,"Tonga"]
[null,null,null,null,null,"Trinidad and Tobago"]
[null,null,null,null,null,"Tunisia"]
[null,null,null,null,null,"Turkey"]
[null,null,null,null,null,"Turkmenistan"]
[null,null,null,null,null,"Turks and Caicos Islands"]
[null,null,null,null,null,"Tuvalu"]
[null,null,null,null,null,"Uganda"]
[null,null,null,null,null,"Ukraine"]
[null,null,null,null,null,"United Arab Emirates"]
[null,null,null,null,null,"United Kingdom"]
[null,null,null,null,null,"United States","Y"]
[null,null,null,null,null,"Uruguay"]
[null,null,null,null,null,"Uzbekistan"]
[null,null,null,null,null,"Vanuatu"]
[null,null,null,null,null,"Venezuela"]
[null,null,null,null,null,"Vietnam"]
[null,null,null,null,null,"Virgin Islands","Y"]
[null,null,null,null,null,"Wallis and Futuna"]
[null,null,null,null,null,"West Bank"]
[null,null,null,null,null,"Western Sahara"]
[null,null,null,null,null,"Yemen"]
[null,null,null,null,null,"Zambia"]
[null,null,null,null,null,"Zimbabwe"]